b-waehrung.w 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494
  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. { incl/tmpbrowser.i }
  28. {src/adm2/widgetprto.i}
  29. /* _UIB-CODE-BLOCK-END */
  30. &ANALYZE-RESUME
  31. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  32. /* ******************** Preprocessor Definitions ******************** */
  33. &Scoped-define PROCEDURE-TYPE SmartDataBrowser
  34. &Scoped-define DB-AWARE no
  35. &Scoped-define ADM-SUPPORTED-LINKS TableIO-Target,Data-Target,Update-Source
  36. /* Include file with RowObject temp-table definition */
  37. &Scoped-define DATA-FIELD-DEFS "d-waehrung.i"
  38. /* Name of designated FRAME-NAME and/or first browse and/or first query */
  39. &Scoped-define FRAME-NAME F-Main
  40. &Scoped-define BROWSE-NAME br_table
  41. /* Internal Tables (found by Frame, Query & Browse Queries) */
  42. &Scoped-define INTERNAL-TABLES rowObject
  43. /* Definitions for BROWSE br_table */
  44. &Scoped-define FIELDS-IN-QUERY-br_table Frw Bezeichnung Kurs Faktor ~
  45. DebSammKto KredSammKto KursDiffKto SkontoSammKto
  46. &Scoped-define ENABLED-FIELDS-IN-QUERY-br_table
  47. &Scoped-define QUERY-STRING-br_table FOR EACH rowObject
  48. &Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH rowObject.
  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. /* ************************ Function Prototypes ********************** */
  59. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD setZeilenfarbe bTableWin
  60. FUNCTION setZeilenfarbe RETURNS LOGICAL
  61. ( ipFarbe AS INT ) FORWARD.
  62. /* _UIB-CODE-BLOCK-END */
  63. &ANALYZE-RESUME
  64. /* *********************** Control Definitions ********************** */
  65. /* Definitions of the field level widgets */
  66. DEFINE RECTANGLE RECT-1
  67. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  68. SIZE 122 BY 7.14.
  69. /* Query definitions */
  70. &ANALYZE-SUSPEND
  71. DEFINE TEMP-TABLE RowObject NO-UNDO
  72. {{&DATA-FIELD-DEFS}}
  73. {src/adm2/robjflds.i}.
  74. DEFINE QUERY br_table FOR
  75. rowObject SCROLLING.
  76. &ANALYZE-RESUME
  77. /* Browse definitions */
  78. DEFINE BROWSE br_table
  79. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table bTableWin _STRUCTURED
  80. QUERY br_table NO-LOCK DISPLAY
  81. Frw FORMAT "x(03)":U
  82. Bezeichnung FORMAT "x(20)":U
  83. Kurs FORMAT "zz,zz9.99999999":U
  84. Faktor FORMAT "z,zz9":U
  85. DebSammKto COLUMN-LABEL "Debitor!Sammelkonto" FORMAT "x(12)":U
  86. WIDTH 16
  87. KredSammKto COLUMN-LABEL "Kreditor!Sammelkonto" FORMAT "x(12)":U
  88. WIDTH 16
  89. KursDiffKto COLUMN-LABEL "Konto!Kursdifferenzen" FORMAT "x(12)":U
  90. WIDTH 16
  91. SkontoSammKto COLUMN-LABEL "Konto!Skontoabzüge" FORMAT "x(12)":U
  92. WIDTH 16
  93. /* _UIB-CODE-BLOCK-END */
  94. &ANALYZE-RESUME
  95. WITH NO-ASSIGN NO-AUTO-VALIDATE NO-ROW-MARKERS SEPARATORS SIZE 120 BY 6.67.
  96. /* ************************ Frame Definitions *********************** */
  97. DEFINE FRAME F-Main
  98. br_table AT ROW 1.48 COL 3 WIDGET-ID 200
  99. RECT-1 AT ROW 1.24 COL 2 WIDGET-ID 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 WIDGET-ID 100.
  103. /* *********************** Procedure Settings ************************ */
  104. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  105. /* Settings for THIS-PROCEDURE
  106. Type: SmartDataBrowser
  107. Data Source: "d-waehrung.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 = 7.62
  126. WIDTH = 124.
  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. /* _RUN-TIME-ATTRIBUTES-END */
  146. &ANALYZE-RESUME
  147. /* Setting information for Queries and Browse Widgets fields */
  148. &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_table
  149. /* Query rebuild information for BROWSE br_table
  150. _TblList = "rowObject"
  151. _Options = "NO-LOCK INDEXED-REPOSITION"
  152. _FldNameList[1] > _<SDO>.rowObject.Frw
  153. "Frw" ? ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  154. _FldNameList[2] = _<SDO>.rowObject.Bezeichnung
  155. _FldNameList[3] = _<SDO>.rowObject.Kurs
  156. _FldNameList[4] = _<SDO>.rowObject.Faktor
  157. _FldNameList[5] > _<SDO>.rowObject.DebSammKto
  158. "DebSammKto" "Debitor!Sammelkonto" ? "character" ? ? ? ? ? ? no "?" no no "16" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  159. _FldNameList[6] > _<SDO>.rowObject.KredSammKto
  160. "KredSammKto" "Kreditor!Sammelkonto" ? "character" ? ? ? ? ? ? no "?" no no "16" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  161. _FldNameList[7] > _<SDO>.rowObject.KursDiffKto
  162. "KursDiffKto" "Konto!Kursdifferenzen" ? "character" ? ? ? ? ? ? no "?" no no "16" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  163. _FldNameList[8] > _<SDO>.rowObject.SkontoSammKto
  164. "SkontoSammKto" "Konto!Skontoabzüge" ? "character" ? ? ? ? ? ? no "?" no no "16" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  165. _Query is NOT OPENED
  166. */ /* BROWSE br_table */
  167. &ANALYZE-RESUME
  168. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
  169. /* Query rebuild information for FRAME F-Main
  170. _Options = "NO-LOCK"
  171. _Query is NOT OPENED
  172. */ /* FRAME F-Main */
  173. &ANALYZE-RESUME
  174. /* ************************ Control Triggers ************************ */
  175. &Scoped-define BROWSE-NAME br_table
  176. &Scoped-define SELF-NAME br_table
  177. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  178. ON CTRL-END OF br_table IN FRAME F-Main
  179. DO:
  180. APPLY "END":U TO BROWSE {&BROWSE-NAME}.
  181. END.
  182. /* _UIB-CODE-BLOCK-END */
  183. &ANALYZE-RESUME
  184. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  185. ON CTRL-HOME OF br_table IN FRAME F-Main
  186. DO:
  187. APPLY "HOME":U TO BROWSE {&BROWSE-NAME}.
  188. END.
  189. /* _UIB-CODE-BLOCK-END */
  190. &ANALYZE-RESUME
  191. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  192. ON DEFAULT-ACTION OF br_table IN FRAME F-Main
  193. DO:
  194. {src/adm2/brsdefault.i}
  195. END.
  196. /* _UIB-CODE-BLOCK-END */
  197. &ANALYZE-RESUME
  198. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  199. ON END OF br_table IN FRAME F-Main
  200. DO:
  201. {src/adm2/brsend.i}
  202. END.
  203. /* _UIB-CODE-BLOCK-END */
  204. &ANALYZE-RESUME
  205. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  206. ON HOME OF br_table IN FRAME F-Main
  207. DO:
  208. {src/adm2/brshome.i}
  209. END.
  210. /* _UIB-CODE-BLOCK-END */
  211. &ANALYZE-RESUME
  212. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  213. ON LEFT-MOUSE-CLICK OF br_table IN FRAME F-Main
  214. DO:
  215. APPLY 'ENTRY' TO {&BROWSE-NAME}.
  216. END.
  217. /* _UIB-CODE-BLOCK-END */
  218. &ANALYZE-RESUME
  219. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  220. ON LEFT-MOUSE-DBLCLICK OF br_table IN FRAME F-Main
  221. DO:
  222. IF NOT VALID-HANDLE( hFenster ) THEN RETURN NO-APPLY.
  223. RUN TOOLBAR IN hFenster ( INPUT 'UPDATE' ).
  224. RETURN NO-APPLY.
  225. END.
  226. /* _UIB-CODE-BLOCK-END */
  227. &ANALYZE-RESUME
  228. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  229. ON OFF-END OF br_table IN FRAME F-Main
  230. DO:
  231. {src/adm2/brsoffnd.i}
  232. END.
  233. /* _UIB-CODE-BLOCK-END */
  234. &ANALYZE-RESUME
  235. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  236. ON OFF-HOME OF br_table IN FRAME F-Main
  237. DO:
  238. {src/adm2/brsoffhm.i}
  239. END.
  240. /* _UIB-CODE-BLOCK-END */
  241. &ANALYZE-RESUME
  242. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  243. ON ROW-ENTRY OF br_table IN FRAME F-Main
  244. DO:
  245. {src/adm2/brsentry.i}
  246. END.
  247. /* _UIB-CODE-BLOCK-END */
  248. &ANALYZE-RESUME
  249. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  250. ON ROW-LEAVE OF br_table IN FRAME F-Main
  251. DO:
  252. {src/adm2/brsleave.i}
  253. END.
  254. /* _UIB-CODE-BLOCK-END */
  255. &ANALYZE-RESUME
  256. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  257. ON SCROLL-NOTIFY OF br_table IN FRAME F-Main
  258. DO:
  259. {src/adm2/brsscrol.i}
  260. END.
  261. /* _UIB-CODE-BLOCK-END */
  262. &ANALYZE-RESUME
  263. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  264. ON START-SEARCH OF br_table IN FRAME F-Main
  265. DO:
  266. { incl/brwstartsearch.i }
  267. END.
  268. /* _UIB-CODE-BLOCK-END */
  269. &ANALYZE-RESUME
  270. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  271. ON VALUE-CHANGED OF br_table IN FRAME F-Main
  272. DO:
  273. {src/adm2/brschnge.i}
  274. END.
  275. /* _UIB-CODE-BLOCK-END */
  276. &ANALYZE-RESUME
  277. &UNDEFINE SELF-NAME
  278. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK bTableWin
  279. /* *************************** Main Block *************************** */
  280. { incl/brwmainblock.i }
  281. { incl/brwinternproc.i }
  282. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  283. RUN initializeObject.
  284. &ENDIF
  285. /* _UIB-CODE-BLOCK-END */
  286. &ANALYZE-RESUME
  287. /* ********************** Internal Procedures *********************** */
  288. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE destroyObject bTableWin
  289. PROCEDURE destroyObject :
  290. /*------------------------------------------------------------------------------
  291. Purpose: Super Override
  292. Parameters:
  293. Notes:
  294. ------------------------------------------------------------------------------*/
  295. DEF VAR hBrowser AS HANDLE NO-UNDO.
  296. hBrowser = {&BROWSE-NAME}:HANDLE IN FRAME {&FRAME-NAME}.
  297. DYNAMIC-FUNCTION('setBrowserDaten':U, INPUT hBrowser,
  298. INPUT Sektion ) NO-ERROR.
  299. RUN SUPER.
  300. /* Code placed here will execute AFTER standard behavior. */
  301. END PROCEDURE.
  302. /* _UIB-CODE-BLOCK-END */
  303. &ANALYZE-RESUME
  304. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI bTableWin _DEFAULT-DISABLE
  305. PROCEDURE disable_UI :
  306. /*------------------------------------------------------------------------------
  307. Purpose: DISABLE the User Interface
  308. Parameters: <none>
  309. Notes: Here we clean-up the user-interface by deleting
  310. dynamic widgets we have created and/or hide
  311. frames. This procedure is usually called when
  312. we are ready to "clean-up" after running.
  313. ------------------------------------------------------------------------------*/
  314. /* Hide all frames. */
  315. HIDE FRAME F-Main.
  316. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  317. END PROCEDURE.
  318. /* _UIB-CODE-BLOCK-END */
  319. &ANALYZE-RESUME
  320. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_BROWSE bTableWin
  321. PROCEDURE ENTRY_BROWSE :
  322. /*------------------------------------------------------------------------------
  323. Purpose:
  324. Parameters: <none>
  325. Notes:
  326. ------------------------------------------------------------------------------*/
  327. APPLY 'ENTRY' TO {&BROWSE-NAME} IN FRAME {&FRAME-NAME}.
  328. RETURN NO-APPLY.
  329. END PROCEDURE.
  330. /* _UIB-CODE-BLOCK-END */
  331. &ANALYZE-RESUME
  332. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject bTableWin
  333. PROCEDURE initializeObject :
  334. /*------------------------------------------------------------------------------
  335. Purpose: Super Override
  336. Parameters:
  337. Notes:
  338. ------------------------------------------------------------------------------*/
  339. { incl/brwinitialize.i }
  340. END PROCEDURE.
  341. /* _UIB-CODE-BLOCK-END */
  342. &ANALYZE-RESUME
  343. /* ************************ Function Implementations ***************** */
  344. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION setZeilenfarbe bTableWin
  345. FUNCTION setZeilenfarbe RETURNS LOGICAL
  346. ( ipFarbe AS INT ) :
  347. /*------------------------------------------------------------------------------
  348. Purpose:
  349. Notes:
  350. ------------------------------------------------------------------------------*/
  351. { incl/brwsetzeilenfarbe.i }
  352. END FUNCTION.
  353. /* _UIB-CODE-BLOCK-END */
  354. &ANALYZE-RESUME