b-mwst-ansatz.w 9.8 KB

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