b-dokudrucker.w 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387
  1. &ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
  2. &ANALYZE-RESUME
  3. /* Connected Databases
  4. anadat PROGRESS
  5. */
  6. &Scoped-define WINDOW-NAME CURRENT-WINDOW
  7. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS bTableWin
  8. /*------------------------------------------------------------------------
  9. File: adm2\src\browser.w
  10. Description: SmartDataBrowser Object
  11. Input Parameters:
  12. <none>
  13. Output Parameters:
  14. <none>
  15. ------------------------------------------------------------------------*/
  16. /* This .W file was created with the Progress AppBuilder. */
  17. /*----------------------------------------------------------------------*/
  18. /* Create an unnamed pool to store all the widgets created
  19. by this procedure. This is a good default which assures
  20. that this procedure's triggers and internal procedures
  21. will execute in this procedure's storage, and that proper
  22. cleanup will occur on deletion of the procedure. */
  23. CREATE WIDGET-POOL.
  24. /* *************************** Definitions ************************** */
  25. /* Parameters Definitions --- */
  26. /* Local Variable Definitions --- */
  27. /* _UIB-CODE-BLOCK-END */
  28. &ANALYZE-RESUME
  29. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  30. /* ******************** Preprocessor Definitions ******************** */
  31. &Scoped-define PROCEDURE-TYPE SmartDataBrowser
  32. &Scoped-define DB-AWARE no
  33. &Scoped-define ADM-SUPPORTED-LINKS TableIO-Target,Data-Target,Update-Source
  34. /* Include file with RowObject temp-table definition */
  35. &Scoped-define DATA-FIELD-DEFS "d-dokudrucker.i"
  36. /* Name of designated FRAME-NAME and/or first browse and/or first query */
  37. &Scoped-define FRAME-NAME F-Main
  38. &Scoped-define BROWSE-NAME br_table
  39. /* Internal Tables (found by Frame, Query & Browse Queries) */
  40. &Scoped-define INTERNAL-TABLES rowObject
  41. /* Definitions for BROWSE br_table */
  42. &Scoped-define FIELDS-IN-QUERY-br_table rowObject.Sort_1 rowObject.Sort_2 ~
  43. rowObject.Zeichen_1 rowObject.Zeichen_2 rowObject.Zahl1 rowObject.Zahl2 ~
  44. rowObject.Zahl3 rowObject.Zahl4 rowObject.Zahl5 rowObject.Zahl6 ~
  45. rowObject.Zahl7 rowObject.Zahl8
  46. &Scoped-define ENABLED-FIELDS-IN-QUERY-br_table
  47. &Scoped-define QUERY-STRING-br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION
  48. &Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION.
  49. &Scoped-define TABLES-IN-QUERY-br_table rowObject
  50. &Scoped-define FIRST-TABLE-IN-QUERY-br_table rowObject
  51. /* Definitions for FRAME F-Main */
  52. /* Standard List Definitions */
  53. &Scoped-Define ENABLED-OBJECTS RECT-1 br_table
  54. /* Custom List Definitions */
  55. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  56. /* _UIB-PREPROCESSOR-BLOCK-END */
  57. &ANALYZE-RESUME
  58. /* *********************** Control Definitions ********************** */
  59. /* Definitions of the field level widgets */
  60. DEFINE RECTANGLE RECT-1
  61. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  62. SIZE 150 BY 8.81.
  63. /* Query definitions */
  64. &ANALYZE-SUSPEND
  65. DEFINE TEMP-TABLE RowObject NO-UNDO
  66. {{&DATA-FIELD-DEFS}}
  67. {src/adm2/robjflds.i}.
  68. DEFINE QUERY br_table FOR
  69. rowObject SCROLLING.
  70. &ANALYZE-RESUME
  71. /* Browse definitions */
  72. DEFINE BROWSE br_table
  73. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table bTableWin _STRUCTURED
  74. QUERY br_table NO-LOCK DISPLAY
  75. rowObject.Sort_1 FORMAT "x(20)":U WIDTH 9
  76. rowObject.Sort_2 FORMAT "x(20)":U WIDTH 15
  77. rowObject.Zeichen_1 FORMAT "X(60)":U
  78. rowObject.Zeichen_2 FORMAT "x(20)":U WIDTH 15
  79. rowObject.Zahl1 COLUMN-LABEL "Total!Zeilen" FORMAT "99":U
  80. WIDTH 6
  81. rowObject.Zahl2 COLUMN-LABEL "Kopf!Zeilen" FORMAT "99":U
  82. WIDTH 6
  83. rowObject.Zahl3 COLUMN-LABEL "Fuss!Zeilen" FORMAT "99":U
  84. WIDTH 6
  85. rowObject.Zahl4 FORMAT "99":U WIDTH 7
  86. rowObject.Zahl5 COLUMN-LABEL "Schacht!Original" FORMAT "zzz9":U
  87. WIDTH 8
  88. rowObject.Zahl6 COLUMN-LABEL "Schacht!Kopie" FORMAT "zzz9":U
  89. WIDTH 8
  90. rowObject.Zahl7 COLUMN-LABEL "Besr" FORMAT "zzz9":U WIDTH 5
  91. rowObject.Zahl8 COLUMN-LABEL "Schacht!BESR" FORMAT "zzz9":U
  92. WIDTH 8
  93. /* _UIB-CODE-BLOCK-END */
  94. &ANALYZE-RESUME
  95. WITH NO-ASSIGN NO-AUTO-VALIDATE NO-ROW-MARKERS SEPARATORS SIZE 148 BY 8.33.
  96. /* ************************ Frame Definitions *********************** */
  97. DEFINE FRAME F-Main
  98. br_table AT ROW 1.48 COL 3
  99. RECT-1 AT ROW 1.24 COL 2
  100. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
  101. SIDE-LABELS NO-UNDERLINE THREE-D
  102. AT COL 1 ROW 1 SCROLLABLE .
  103. /* *********************** Procedure Settings ************************ */
  104. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  105. /* Settings for THIS-PROCEDURE
  106. Type: SmartDataBrowser
  107. Data Source: "d-dokudrucker.w"
  108. Allow: Basic,Browse
  109. Frames: 1
  110. Add Fields to: Neither
  111. Other Settings: PERSISTENT-ONLY COMPILE
  112. */
  113. /* This procedure should always be RUN PERSISTENT. Report the error, */
  114. /* then cleanup and return. */
  115. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  116. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  117. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  118. RETURN.
  119. END.
  120. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  121. /* ************************* Create Window ************************** */
  122. &ANALYZE-SUSPEND _CREATE-WINDOW
  123. /* DESIGN Window definition (used by the UIB)
  124. CREATE WINDOW bTableWin ASSIGN
  125. HEIGHT = 9.29
  126. WIDTH = 153.8.
  127. /* END WINDOW DEFINITION */
  128. */
  129. &ANALYZE-RESUME
  130. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB bTableWin
  131. /* ************************* Included-Libraries *********************** */
  132. {src/adm2/browser.i}
  133. /* _UIB-CODE-BLOCK-END */
  134. &ANALYZE-RESUME
  135. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  136. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  137. /* SETTINGS FOR WINDOW bTableWin
  138. NOT-VISIBLE,,RUN-PERSISTENT */
  139. /* SETTINGS FOR FRAME F-Main
  140. NOT-VISIBLE FRAME-NAME Size-to-Fit */
  141. /* BROWSE-TAB br_table RECT-1 F-Main */
  142. ASSIGN
  143. FRAME F-Main:SCROLLABLE = FALSE
  144. FRAME F-Main:HIDDEN = TRUE.
  145. ASSIGN
  146. br_table:COLUMN-RESIZABLE IN FRAME F-Main = TRUE.
  147. /* _RUN-TIME-ATTRIBUTES-END */
  148. &ANALYZE-RESUME
  149. /* Setting information for Queries and Browse Widgets fields */
  150. &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_table
  151. /* Query rebuild information for BROWSE br_table
  152. _TblList = "rowObject"
  153. _Options = "NO-LOCK INDEXED-REPOSITION"
  154. _FldNameList[1] > _<SDO>.rowObject.Sort_1
  155. "rowObject.Sort_1" ? ? "character" ? ? ? ? ? ? no "?" no no "9" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  156. _FldNameList[2] > _<SDO>.rowObject.Sort_2
  157. "rowObject.Sort_2" ? ? "character" ? ? ? ? ? ? no "?" no no "15" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  158. _FldNameList[3] > _<SDO>.rowObject.Zeichen_1
  159. "rowObject.Zeichen_1" ? ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  160. _FldNameList[4] > _<SDO>.rowObject.Zeichen_2
  161. "rowObject.Zeichen_2" ? ? "character" ? ? ? ? ? ? no "?" no no "15" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  162. _FldNameList[5] > _<SDO>.rowObject.Zahl1
  163. "rowObject.Zahl1" "Total!Zeilen" ? "integer" ? ? ? ? ? ? no "?" no no "6" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  164. _FldNameList[6] > _<SDO>.rowObject.Zahl2
  165. "rowObject.Zahl2" "Kopf!Zeilen" ? "integer" ? ? ? ? ? ? no "?" no no "6" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  166. _FldNameList[7] > _<SDO>.rowObject.Zahl3
  167. "rowObject.Zahl3" "Fuss!Zeilen" ? "integer" ? ? ? ? ? ? no "?" no no "6" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  168. _FldNameList[8] > _<SDO>.rowObject.Zahl4
  169. "rowObject.Zahl4" ? ? "integer" ? ? ? ? ? ? no "?" no no "7" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  170. _FldNameList[9] > _<SDO>.rowObject.Zahl5
  171. "rowObject.Zahl5" "Schacht!Original" ? "integer" ? ? ? ? ? ? no "?" no no "8" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  172. _FldNameList[10] > _<SDO>.rowObject.Zahl6
  173. "rowObject.Zahl6" "Schacht!Kopie" ? "integer" ? ? ? ? ? ? no "?" no no "8" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  174. _FldNameList[11] > _<SDO>.rowObject.Zahl7
  175. "rowObject.Zahl7" "Besr" ? "integer" ? ? ? ? ? ? no "?" no no "5" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  176. _FldNameList[12] > _<SDO>.rowObject.Zahl8
  177. "rowObject.Zahl8" "Schacht!BESR" ? "integer" ? ? ? ? ? ? no "?" no no "8" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  178. _Query is NOT OPENED
  179. */ /* BROWSE br_table */
  180. &ANALYZE-RESUME
  181. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
  182. /* Query rebuild information for FRAME F-Main
  183. _Options = "NO-LOCK"
  184. _Query is NOT OPENED
  185. */ /* FRAME F-Main */
  186. &ANALYZE-RESUME
  187. /* ************************ Control Triggers ************************ */
  188. &Scoped-define BROWSE-NAME br_table
  189. &Scoped-define SELF-NAME br_table
  190. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  191. ON CTRL-END OF br_table IN FRAME F-Main
  192. DO:
  193. APPLY "END":U TO BROWSE {&BROWSE-NAME}.
  194. END.
  195. /* _UIB-CODE-BLOCK-END */
  196. &ANALYZE-RESUME
  197. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  198. ON CTRL-HOME OF br_table IN FRAME F-Main
  199. DO:
  200. APPLY "HOME":U TO BROWSE {&BROWSE-NAME}.
  201. END.
  202. /* _UIB-CODE-BLOCK-END */
  203. &ANALYZE-RESUME
  204. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  205. ON END OF br_table IN FRAME F-Main
  206. DO:
  207. {src/adm2/brsend.i}
  208. END.
  209. /* _UIB-CODE-BLOCK-END */
  210. &ANALYZE-RESUME
  211. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  212. ON HOME OF br_table IN FRAME F-Main
  213. DO:
  214. {src/adm2/brshome.i}
  215. END.
  216. /* _UIB-CODE-BLOCK-END */
  217. &ANALYZE-RESUME
  218. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  219. ON OFF-END OF br_table IN FRAME F-Main
  220. DO:
  221. {src/adm2/brsoffnd.i}
  222. END.
  223. /* _UIB-CODE-BLOCK-END */
  224. &ANALYZE-RESUME
  225. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  226. ON OFF-HOME OF br_table IN FRAME F-Main
  227. DO:
  228. {src/adm2/brsoffhm.i}
  229. END.
  230. /* _UIB-CODE-BLOCK-END */
  231. &ANALYZE-RESUME
  232. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  233. ON ROW-ENTRY OF br_table IN FRAME F-Main
  234. DO:
  235. {src/adm2/brsentry.i}
  236. END.
  237. /* _UIB-CODE-BLOCK-END */
  238. &ANALYZE-RESUME
  239. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  240. ON ROW-LEAVE OF br_table IN FRAME F-Main
  241. DO:
  242. {src/adm2/brsleave.i}
  243. END.
  244. /* _UIB-CODE-BLOCK-END */
  245. &ANALYZE-RESUME
  246. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  247. ON SCROLL-NOTIFY OF br_table IN FRAME F-Main
  248. DO:
  249. {src/adm2/brsscrol.i}
  250. END.
  251. /* _UIB-CODE-BLOCK-END */
  252. &ANALYZE-RESUME
  253. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  254. ON VALUE-CHANGED OF br_table IN FRAME F-Main
  255. DO:
  256. {src/adm2/brschnge.i}
  257. END.
  258. /* _UIB-CODE-BLOCK-END */
  259. &ANALYZE-RESUME
  260. &UNDEFINE SELF-NAME
  261. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK bTableWin
  262. /* *************************** Main Block *************************** */
  263. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  264. RUN initializeObject.
  265. &ENDIF
  266. /* _UIB-CODE-BLOCK-END */
  267. &ANALYZE-RESUME
  268. /* ********************** Internal Procedures *********************** */
  269. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI bTableWin _DEFAULT-DISABLE
  270. PROCEDURE disable_UI :
  271. /*------------------------------------------------------------------------------
  272. Purpose: DISABLE the User Interface
  273. Parameters: <none>
  274. Notes: Here we clean-up the user-interface by deleting
  275. dynamic widgets we have created and/or hide
  276. frames. This procedure is usually called when
  277. we are ready to "clean-up" after running.
  278. ------------------------------------------------------------------------------*/
  279. /* Hide all frames. */
  280. HIDE FRAME F-Main.
  281. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  282. END PROCEDURE.
  283. /* _UIB-CODE-BLOCK-END */
  284. &ANALYZE-RESUME