b-fahrer.w 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523
  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. DEF VAR cEtiketten AS CHAR NO-UNDO.
  28. { incl/tmpbrowser.i }
  29. {src/adm2/widgetprto.i}
  30. /* _UIB-CODE-BLOCK-END */
  31. &ANALYZE-RESUME
  32. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  33. /* ******************** Preprocessor Definitions ******************** */
  34. &Scoped-define PROCEDURE-TYPE SmartDataBrowser
  35. &Scoped-define DB-AWARE no
  36. &Scoped-define ADM-SUPPORTED-LINKS TableIO-Target,Data-Target,Update-Source
  37. /* Include file with RowObject temp-table definition */
  38. &Scoped-define DATA-FIELD-DEFS "d-fahrer.i"
  39. /* Name of designated FRAME-NAME and/or first browse and/or first query */
  40. &Scoped-define FRAME-NAME F-Main
  41. &Scoped-define BROWSE-NAME br_table
  42. /* Internal Tables (found by Frame, Query & Browse Queries) */
  43. &Scoped-define INTERNAL-TABLES rowObject
  44. /* Definitions for BROWSE br_table */
  45. &Scoped-define FIELDS-IN-QUERY-br_table rowObject.CodeI rowObject.Bez1 ~
  46. rowObject.Bez2
  47. &Scoped-define ENABLED-FIELDS-IN-QUERY-br_table
  48. &Scoped-define QUERY-STRING-br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION
  49. &Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION.
  50. &Scoped-define TABLES-IN-QUERY-br_table rowObject
  51. &Scoped-define FIRST-TABLE-IN-QUERY-br_table rowObject
  52. /* Definitions for FRAME F-Main */
  53. /* Standard List Definitions */
  54. &Scoped-Define ENABLED-OBJECTS RECT-1 br_table
  55. /* Custom List Definitions */
  56. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  57. /* _UIB-PREPROCESSOR-BLOCK-END */
  58. &ANALYZE-RESUME
  59. /* ************************ Function Prototypes ********************** */
  60. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD setZeilenfarbe bTableWin
  61. FUNCTION setZeilenfarbe RETURNS LOGICAL
  62. ( ipFarbe AS INT ) FORWARD.
  63. /* _UIB-CODE-BLOCK-END */
  64. &ANALYZE-RESUME
  65. /* *********************** Control Definitions ********************** */
  66. /* Menu Definitions */
  67. DEFINE MENU POPUP-MENU-br_table
  68. MENU-ITEM X_Strichcode LABEL "Fahrer als Strichcode".
  69. /* Definitions of the field level widgets */
  70. DEFINE RECTANGLE RECT-1
  71. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  72. SIZE 80 BY 7.14.
  73. /* Query definitions */
  74. &ANALYZE-SUSPEND
  75. DEFINE TEMP-TABLE RowObject NO-UNDO
  76. {{&DATA-FIELD-DEFS}}
  77. {src/adm2/robjflds.i}.
  78. DEFINE QUERY br_table FOR
  79. rowObject SCROLLING.
  80. &ANALYZE-RESUME
  81. /* Browse definitions */
  82. DEFINE BROWSE br_table
  83. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table bTableWin _STRUCTURED
  84. QUERY br_table NO-LOCK DISPLAY
  85. rowObject.CodeI COLUMN-LABEL "Fahrer" FORMAT "999999":U
  86. rowObject.Bez1 COLUMN-LABEL "Name" FORMAT "x(30)":U
  87. rowObject.Bez2 COLUMN-LABEL "Zusatz" FORMAT "x(30)":U
  88. /* _UIB-CODE-BLOCK-END */
  89. &ANALYZE-RESUME
  90. WITH NO-ASSIGN NO-AUTO-VALIDATE NO-ROW-MARKERS SEPARATORS SIZE 78 BY 6.67.
  91. /* ************************ Frame Definitions *********************** */
  92. DEFINE FRAME F-Main
  93. br_table AT ROW 1.48 COL 3 WIDGET-ID 200
  94. RECT-1 AT ROW 1.24 COL 2 WIDGET-ID 2
  95. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
  96. SIDE-LABELS NO-UNDERLINE THREE-D
  97. AT COL 1 ROW 1 SCROLLABLE WIDGET-ID 100.
  98. /* *********************** Procedure Settings ************************ */
  99. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  100. /* Settings for THIS-PROCEDURE
  101. Type: SmartDataBrowser
  102. Data Source: "d-fahrer.w"
  103. Allow: Basic,Browse
  104. Frames: 1
  105. Add Fields to: Neither
  106. Other Settings: PERSISTENT-ONLY COMPILE
  107. */
  108. /* This procedure should always be RUN PERSISTENT. Report the error, */
  109. /* then cleanup and return. */
  110. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  111. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  112. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  113. RETURN.
  114. END.
  115. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  116. /* ************************* Create Window ************************** */
  117. &ANALYZE-SUSPEND _CREATE-WINDOW
  118. /* DESIGN Window definition (used by the UIB)
  119. CREATE WINDOW bTableWin ASSIGN
  120. HEIGHT = 7.62
  121. WIDTH = 82.
  122. /* END WINDOW DEFINITION */
  123. */
  124. &ANALYZE-RESUME
  125. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB bTableWin
  126. /* ************************* Included-Libraries *********************** */
  127. {src/adm2/browser.i}
  128. /* _UIB-CODE-BLOCK-END */
  129. &ANALYZE-RESUME
  130. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  131. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  132. /* SETTINGS FOR WINDOW bTableWin
  133. NOT-VISIBLE,,RUN-PERSISTENT */
  134. /* SETTINGS FOR FRAME F-Main
  135. NOT-VISIBLE FRAME-NAME Size-to-Fit */
  136. /* BROWSE-TAB br_table RECT-1 F-Main */
  137. ASSIGN
  138. FRAME F-Main:SCROLLABLE = FALSE
  139. FRAME F-Main:HIDDEN = TRUE.
  140. ASSIGN
  141. br_table:POPUP-MENU IN FRAME F-Main = MENU POPUP-MENU-br_table:HANDLE.
  142. /* _RUN-TIME-ATTRIBUTES-END */
  143. &ANALYZE-RESUME
  144. /* Setting information for Queries and Browse Widgets fields */
  145. &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_table
  146. /* Query rebuild information for BROWSE br_table
  147. _TblList = "rowObject"
  148. _Options = "NO-LOCK INDEXED-REPOSITION"
  149. _FldNameList[1] > _<SDO>.rowObject.CodeI
  150. "rowObject.CodeI" "Fahrer" ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  151. _FldNameList[2] > _<SDO>.rowObject.Bez1
  152. "rowObject.Bez1" "Name" ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  153. _FldNameList[3] > _<SDO>.rowObject.Bez2
  154. "rowObject.Bez2" "Zusatz" ? "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  155. _Query is NOT OPENED
  156. */ /* BROWSE br_table */
  157. &ANALYZE-RESUME
  158. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
  159. /* Query rebuild information for FRAME F-Main
  160. _Options = "NO-LOCK"
  161. _Query is NOT OPENED
  162. */ /* FRAME F-Main */
  163. &ANALYZE-RESUME
  164. /* ************************ Control Triggers ************************ */
  165. &Scoped-define BROWSE-NAME br_table
  166. &Scoped-define SELF-NAME br_table
  167. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  168. ON CTRL-END OF br_table IN FRAME F-Main
  169. DO:
  170. APPLY "END":U TO BROWSE {&BROWSE-NAME}.
  171. END.
  172. /* _UIB-CODE-BLOCK-END */
  173. &ANALYZE-RESUME
  174. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  175. ON CTRL-HOME OF br_table IN FRAME F-Main
  176. DO:
  177. APPLY "HOME":U TO BROWSE {&BROWSE-NAME}.
  178. END.
  179. /* _UIB-CODE-BLOCK-END */
  180. &ANALYZE-RESUME
  181. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  182. ON DEFAULT-ACTION OF br_table IN FRAME F-Main
  183. DO:
  184. {src/adm2/brsdefault.i}
  185. END.
  186. /* _UIB-CODE-BLOCK-END */
  187. &ANALYZE-RESUME
  188. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  189. ON END OF br_table IN FRAME F-Main
  190. DO:
  191. {src/adm2/brsend.i}
  192. END.
  193. /* _UIB-CODE-BLOCK-END */
  194. &ANALYZE-RESUME
  195. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  196. ON HOME OF br_table IN FRAME F-Main
  197. DO:
  198. {src/adm2/brshome.i}
  199. END.
  200. /* _UIB-CODE-BLOCK-END */
  201. &ANALYZE-RESUME
  202. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  203. ON LEFT-MOUSE-CLICK OF br_table IN FRAME F-Main
  204. DO:
  205. APPLY 'ENTRY' TO {&BROWSE-NAME}.
  206. END.
  207. /* _UIB-CODE-BLOCK-END */
  208. &ANALYZE-RESUME
  209. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  210. ON LEFT-MOUSE-DBLCLICK OF br_table IN FRAME F-Main
  211. DO:
  212. IF NOT VALID-HANDLE( hFenster ) THEN RETURN NO-APPLY.
  213. RUN TOOLBAR IN hFenster ( INPUT 'UPDATE' ).
  214. RETURN NO-APPLY.
  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 START-SEARCH OF br_table IN FRAME F-Main
  255. DO:
  256. { incl/brwstartsearch.i }
  257. END.
  258. /* _UIB-CODE-BLOCK-END */
  259. &ANALYZE-RESUME
  260. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  261. ON VALUE-CHANGED OF br_table IN FRAME F-Main
  262. DO:
  263. {src/adm2/brschnge.i}
  264. END.
  265. /* _UIB-CODE-BLOCK-END */
  266. &ANALYZE-RESUME
  267. &UNDEFINE SELF-NAME
  268. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK bTableWin
  269. /* *************************** Main Block *************************** */
  270. { incl/brwmainblock.i }
  271. { incl/brwinternproc.i }
  272. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  273. RUN initializeObject.
  274. &ENDIF
  275. /* _UIB-CODE-BLOCK-END */
  276. &ANALYZE-RESUME
  277. /* ********************** Internal Procedures *********************** */
  278. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE destroyObject bTableWin
  279. PROCEDURE destroyObject :
  280. /*------------------------------------------------------------------------------
  281. Purpose: Super Override
  282. Parameters:
  283. Notes:
  284. ------------------------------------------------------------------------------*/
  285. DEF VAR hBrowser AS HANDLE NO-UNDO.
  286. hBrowser = {&BROWSE-NAME}:HANDLE IN FRAME {&FRAME-NAME}.
  287. DYNAMIC-FUNCTION('setBrowserDaten':U, INPUT hBrowser,
  288. INPUT Sektion ) NO-ERROR.
  289. RUN SUPER.
  290. /* Code placed here will execute AFTER standard behavior. */
  291. END PROCEDURE.
  292. /* _UIB-CODE-BLOCK-END */
  293. &ANALYZE-RESUME
  294. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI bTableWin _DEFAULT-DISABLE
  295. PROCEDURE disable_UI :
  296. /*------------------------------------------------------------------------------
  297. Purpose: DISABLE the User Interface
  298. Parameters: <none>
  299. Notes: Here we clean-up the user-interface by deleting
  300. dynamic widgets we have created and/or hide
  301. frames. This procedure is usually called when
  302. we are ready to "clean-up" after running.
  303. ------------------------------------------------------------------------------*/
  304. /* Hide all frames. */
  305. HIDE FRAME F-Main.
  306. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  307. END PROCEDURE.
  308. /* _UIB-CODE-BLOCK-END */
  309. &ANALYZE-RESUME
  310. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_BROWSE bTableWin
  311. PROCEDURE ENTRY_BROWSE :
  312. /*------------------------------------------------------------------------------
  313. Purpose:
  314. Parameters: <none>
  315. Notes:
  316. ------------------------------------------------------------------------------*/
  317. APPLY 'ENTRY' TO {&BROWSE-NAME} IN FRAME {&FRAME-NAME}.
  318. RETURN NO-APPLY.
  319. END PROCEDURE.
  320. /* _UIB-CODE-BLOCK-END */
  321. &ANALYZE-RESUME
  322. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject bTableWin
  323. PROCEDURE initializeObject :
  324. /*------------------------------------------------------------------------------
  325. Purpose: Super Override
  326. Parameters:
  327. Notes:
  328. ------------------------------------------------------------------------------*/
  329. { incl/brwinitialize.i }
  330. cEtiketten = DYNAMIC-FUNCTION('getEtikettenPfad':U) NO-ERROR.
  331. END PROCEDURE.
  332. /* _UIB-CODE-BLOCK-END */
  333. &ANALYZE-RESUME
  334. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE STRICHCODE bTableWin
  335. PROCEDURE STRICHCODE :
  336. /*------------------------------------------------------------------------------
  337. Purpose:
  338. Parameters: <none>
  339. Notes:
  340. ------------------------------------------------------------------------------*/
  341. DEF VAR iRecid AS RECID NO-UNDO.
  342. DEF VAR hDaten AS HANDLE NO-UNDO.
  343. DEF VAR cDateiName AS CHAR NO-UNDO.
  344. IF NOT VALID-HANDLE ( hDaten ) THEN hDaten = DYNAMIC-FUNCTION('getDataSource':U).
  345. iRecid = DYNAMIC-FUNCTION('getCurrentRecid':U IN hDaten ) NO-ERROR.
  346. IF iRecid = ? OR
  347. iRecid = 0 THEN RETURN NO-APPLY.
  348. FIND Tabel NO-LOCK WHERE RECID(Tabel) = iRecid.
  349. cDateiName = cEtiketten + 'Templates\LoginDaten.eti'.
  350. OUTPUT TO VALUE(cDateiName) NO-MAP NO-CONVERT.
  351. PUT CONTROL 'anzeigeName$userName$password' CHR(10).
  352. PUT CONTROL Tabel.Bez1 '$'
  353. STRING(Tabel.CodeI,'999999') '$'
  354. Tabel.Bez2 CHR(10).
  355. OUTPUT CLOSE.
  356. RETURN NO-APPLY.
  357. END PROCEDURE.
  358. /* _UIB-CODE-BLOCK-END */
  359. &ANALYZE-RESUME
  360. /* ************************ Function Implementations ***************** */
  361. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION setZeilenfarbe bTableWin
  362. FUNCTION setZeilenfarbe RETURNS LOGICAL
  363. ( ipFarbe AS INT ) :
  364. /*------------------------------------------------------------------------------
  365. Purpose:
  366. Notes:
  367. ------------------------------------------------------------------------------*/
  368. { incl/brwsetzeilenfarbe.i }
  369. END FUNCTION.
  370. /* _UIB-CODE-BLOCK-END */
  371. &ANALYZE-RESUME