b-kondi.w 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365
  1. &ANALYZE-SUSPEND _VERSION-NUMBER AB_v9r12 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-kondi.i"
  36. /* Name of first Frame and/or 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.Kond rowObject.Anzeige ~
  43. rowObject.Faellig rowObject.Mahnen rowObject.Tage1 rowObject.Skonto1 ~
  44. rowObject.Tage2 rowObject.Skonto2
  45. &Scoped-define ENABLED-FIELDS-IN-QUERY-br_table
  46. &Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION.
  47. &Scoped-define TABLES-IN-QUERY-br_table rowObject
  48. &Scoped-define FIRST-TABLE-IN-QUERY-br_table rowObject
  49. /* Definitions for FRAME F-Main */
  50. /* Standard List Definitions */
  51. &Scoped-Define ENABLED-OBJECTS br_table RECT-1
  52. /* Custom List Definitions */
  53. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  54. /* _UIB-PREPROCESSOR-BLOCK-END */
  55. &ANALYZE-RESUME
  56. /* *********************** Control Definitions ********************** */
  57. /* Definitions of the field level widgets */
  58. DEFINE RECTANGLE RECT-1
  59. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  60. SIZE 84 BY 7.14.
  61. /* Query definitions */
  62. &ANALYZE-SUSPEND
  63. DEFINE TEMP-TABLE RowObject
  64. {{&DATA-FIELD-DEFS}}
  65. {src/adm2/robjflds.i}.
  66. DEFINE QUERY br_table FOR
  67. rowObject SCROLLING.
  68. &ANALYZE-RESUME
  69. /* Browse definitions */
  70. DEFINE BROWSE br_table
  71. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table bTableWin _STRUCTURED
  72. QUERY br_table NO-LOCK DISPLAY
  73. rowObject.Kond FORMAT "99":U
  74. rowObject.Anzeige FORMAT "x(30)":U
  75. rowObject.Faellig FORMAT "zz9":U WIDTH 5
  76. rowObject.Mahnen FORMAT "zz9":U WIDTH 8
  77. rowObject.Tage1 FORMAT "zz9":U
  78. rowObject.Skonto1 FORMAT "z9.9":U WIDTH 7
  79. rowObject.Tage2 FORMAT "zz9":U
  80. rowObject.Skonto2 FORMAT "z9.9":U WIDTH 7
  81. /* _UIB-CODE-BLOCK-END */
  82. &ANALYZE-RESUME
  83. WITH NO-ASSIGN NO-AUTO-VALIDATE NO-ROW-MARKERS SEPARATORS SIZE 82 BY 6.67
  84. BGCOLOR 15 EXPANDABLE.
  85. /* ************************ Frame Definitions *********************** */
  86. DEFINE FRAME F-Main
  87. br_table AT ROW 1.48 COL 3
  88. RECT-1 AT ROW 1.24 COL 2
  89. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
  90. SIDE-LABELS NO-UNDERLINE THREE-D
  91. AT COL 1 ROW 1 SCROLLABLE .
  92. /* *********************** Procedure Settings ************************ */
  93. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  94. /* Settings for THIS-PROCEDURE
  95. Type: SmartDataBrowser
  96. Data Source: "d-kondi.w"
  97. Allow: Basic,Browse
  98. Frames: 1
  99. Add Fields to: Neither
  100. Other Settings: PERSISTENT-ONLY COMPILE
  101. */
  102. /* This procedure should always be RUN PERSISTENT. Report the error, */
  103. /* then cleanup and return. */
  104. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  105. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  106. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  107. RETURN.
  108. END.
  109. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  110. /* ************************* Create Window ************************** */
  111. &ANALYZE-SUSPEND _CREATE-WINDOW
  112. /* DESIGN Window definition (used by the UIB)
  113. CREATE WINDOW bTableWin ASSIGN
  114. HEIGHT = 7.91
  115. WIDTH = 87.4.
  116. /* END WINDOW DEFINITION */
  117. */
  118. &ANALYZE-RESUME
  119. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB bTableWin
  120. /* ************************* Included-Libraries *********************** */
  121. {src/adm2/browser.i}
  122. /* _UIB-CODE-BLOCK-END */
  123. &ANALYZE-RESUME
  124. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  125. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  126. /* SETTINGS FOR WINDOW bTableWin
  127. NOT-VISIBLE,,RUN-PERSISTENT */
  128. /* SETTINGS FOR FRAME F-Main
  129. NOT-VISIBLE Size-to-Fit */
  130. /* BROWSE-TAB br_table 1 F-Main */
  131. ASSIGN
  132. FRAME F-Main:SCROLLABLE = FALSE
  133. FRAME F-Main:HIDDEN = TRUE.
  134. /* _RUN-TIME-ATTRIBUTES-END */
  135. &ANALYZE-RESUME
  136. /* Setting information for Queries and Browse Widgets fields */
  137. &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_table
  138. /* Query rebuild information for BROWSE br_table
  139. _TblList = "rowObject"
  140. _Options = "NO-LOCK INDEXED-REPOSITION"
  141. _FldNameList[1] > _<SDO>.rowObject.Kond
  142. "rowObject.Kond" ? ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" ""
  143. _FldNameList[2] > _<SDO>.rowObject.Anzeige
  144. "rowObject.Anzeige" ? ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" ""
  145. _FldNameList[3] > _<SDO>.rowObject.Faellig
  146. "rowObject.Faellig" ? ? "integer" ? ? ? ? ? ? no "?" no no "5" yes no no "U" "" ""
  147. _FldNameList[4] > _<SDO>.rowObject.Mahnen
  148. "rowObject.Mahnen" ? ? "integer" ? ? ? ? ? ? no "?" no no "8" yes no no "U" "" ""
  149. _FldNameList[5] > _<SDO>.rowObject.Tage1
  150. "rowObject.Tage1" ? ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" ""
  151. _FldNameList[6] > _<SDO>.rowObject.Skonto1
  152. "rowObject.Skonto1" ? ? "decimal" ? ? ? ? ? ? no "?" no no "7" yes no no "U" "" ""
  153. _FldNameList[7] > _<SDO>.rowObject.Tage2
  154. "rowObject.Tage2" ? ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" ""
  155. _FldNameList[8] > _<SDO>.rowObject.Skonto2
  156. "rowObject.Skonto2" ? ? "decimal" ? ? ? ? ? ? no ? no no "7" yes no no "U" "" ""
  157. _Query is NOT OPENED
  158. */ /* BROWSE br_table */
  159. &ANALYZE-RESUME
  160. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
  161. /* Query rebuild information for FRAME F-Main
  162. _Options = "NO-LOCK"
  163. _Query is NOT OPENED
  164. */ /* FRAME F-Main */
  165. &ANALYZE-RESUME
  166. /* ************************ Control Triggers ************************ */
  167. &Scoped-define BROWSE-NAME br_table
  168. &Scoped-define SELF-NAME br_table
  169. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  170. ON CTRL-END OF br_table IN FRAME F-Main
  171. DO:
  172. APPLY "END":U TO BROWSE {&BROWSE-NAME}.
  173. END.
  174. /* _UIB-CODE-BLOCK-END */
  175. &ANALYZE-RESUME
  176. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  177. ON CTRL-HOME OF br_table IN FRAME F-Main
  178. DO:
  179. APPLY "HOME":U TO BROWSE {&BROWSE-NAME}.
  180. END.
  181. /* _UIB-CODE-BLOCK-END */
  182. &ANALYZE-RESUME
  183. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  184. ON END OF br_table IN FRAME F-Main
  185. DO:
  186. {src/adm2/brsend.i}
  187. END.
  188. /* _UIB-CODE-BLOCK-END */
  189. &ANALYZE-RESUME
  190. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  191. ON HOME OF br_table IN FRAME F-Main
  192. DO:
  193. {src/adm2/brshome.i}
  194. END.
  195. /* _UIB-CODE-BLOCK-END */
  196. &ANALYZE-RESUME
  197. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  198. ON OFF-END OF br_table IN FRAME F-Main
  199. DO:
  200. {src/adm2/brsoffnd.i}
  201. END.
  202. /* _UIB-CODE-BLOCK-END */
  203. &ANALYZE-RESUME
  204. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  205. ON OFF-HOME OF br_table IN FRAME F-Main
  206. DO:
  207. {src/adm2/brsoffhm.i}
  208. END.
  209. /* _UIB-CODE-BLOCK-END */
  210. &ANALYZE-RESUME
  211. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  212. ON ROW-ENTRY OF br_table IN FRAME F-Main
  213. DO:
  214. {src/adm2/brsentry.i}
  215. END.
  216. /* _UIB-CODE-BLOCK-END */
  217. &ANALYZE-RESUME
  218. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  219. ON ROW-LEAVE OF br_table IN FRAME F-Main
  220. DO:
  221. {src/adm2/brsleave.i}
  222. END.
  223. /* _UIB-CODE-BLOCK-END */
  224. &ANALYZE-RESUME
  225. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  226. ON SCROLL-NOTIFY OF br_table IN FRAME F-Main
  227. DO:
  228. {src/adm2/brsscrol.i}
  229. END.
  230. /* _UIB-CODE-BLOCK-END */
  231. &ANALYZE-RESUME
  232. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  233. ON VALUE-CHANGED OF br_table IN FRAME F-Main
  234. DO:
  235. {src/adm2/brschnge.i}
  236. END.
  237. /* _UIB-CODE-BLOCK-END */
  238. &ANALYZE-RESUME
  239. &UNDEFINE SELF-NAME
  240. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK bTableWin
  241. /* *************************** Main Block *************************** */
  242. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  243. RUN initializeObject.
  244. &ENDIF
  245. /* _UIB-CODE-BLOCK-END */
  246. &ANALYZE-RESUME
  247. /* ********************** Internal Procedures *********************** */
  248. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI bTableWin _DEFAULT-DISABLE
  249. PROCEDURE disable_UI :
  250. /*------------------------------------------------------------------------------
  251. Purpose: DISABLE the User Interface
  252. Parameters: <none>
  253. Notes: Here we clean-up the user-interface by deleting
  254. dynamic widgets we have created and/or hide
  255. frames. This procedure is usually called when
  256. we are ready to "clean-up" after running.
  257. ------------------------------------------------------------------------------*/
  258. /* Hide all frames. */
  259. HIDE FRAME F-Main.
  260. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  261. END PROCEDURE.
  262. /* _UIB-CODE-BLOCK-END */
  263. &ANALYZE-RESUME