b-aufko-auftrag.w 21 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691
  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-aufko-auftrag.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_AufkoAuftrag
  41. /* Internal Tables (found by Frame, Query & Browse Queries) */
  42. &Scoped-define INTERNAL-TABLES rowObject
  43. /* Definitions for BROWSE br_AufkoAuftrag */
  44. &Scoped-define FIELDS-IN-QUERY-br_AufkoAuftrag rowObject.Aufnr ~
  45. rowObject.Knr rowObject.Kunde rowObject.Fak_Art rowObject.Lief_Datum ~
  46. rowObject.Lief_Bed rowObject.Tour_Nr1 rowObject.Tour_Nr2 rowObject.Auf_Tot ~
  47. rowObject.Gewicht
  48. &Scoped-define ENABLED-FIELDS-IN-QUERY-br_AufkoAuftrag
  49. &Scoped-define QUERY-STRING-br_AufkoAuftrag FOR EACH rowObject NO-LOCK INDEXED-REPOSITION
  50. &Scoped-define OPEN-QUERY-br_AufkoAuftrag OPEN QUERY br_AufkoAuftrag FOR EACH rowObject NO-LOCK INDEXED-REPOSITION.
  51. &Scoped-define TABLES-IN-QUERY-br_AufkoAuftrag rowObject
  52. &Scoped-define FIRST-TABLE-IN-QUERY-br_AufkoAuftrag rowObject
  53. /* Definitions for FRAME F-Main */
  54. /* Standard List Definitions */
  55. &Scoped-Define ENABLED-OBJECTS RECT-1 br_AufkoAuftrag F_Anzahl CB_Fahrer ~
  56. CB_Lkw F_Gewicht CB_Beifahrer CB_Lieferart Btn_Weiter
  57. &Scoped-Define DISPLAYED-OBJECTS F_Anzahl CB_Fahrer CB_Lkw F_Gewicht ~
  58. CB_Beifahrer CB_Lieferart
  59. /* Custom List Definitions */
  60. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  61. /* _UIB-PREPROCESSOR-BLOCK-END */
  62. &ANALYZE-RESUME
  63. /* ************************ Function Prototypes ********************** */
  64. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD setZeilenfarbe bTableWin
  65. FUNCTION setZeilenfarbe RETURNS LOGICAL
  66. ( ipFarbe AS INT ) FORWARD.
  67. /* _UIB-CODE-BLOCK-END */
  68. &ANALYZE-RESUME
  69. /* *********************** Control Definitions ********************** */
  70. /* Definitions of the field level widgets */
  71. DEFINE BUTTON Btn_Drucken
  72. LABEL "Drucken"
  73. SIZE 15 BY 1.
  74. DEFINE BUTTON Btn_Weiter
  75. LABEL "Weiter"
  76. SIZE 15 BY 1.
  77. DEFINE VARIABLE CB_Beifahrer AS CHARACTER FORMAT "X(256)":U
  78. LABEL "Beifahrer"
  79. VIEW-AS COMBO-BOX INNER-LINES 5
  80. LIST-ITEM-PAIRS "Item 1","Item 1"
  81. DROP-DOWN-LIST
  82. SIZE 40 BY 1
  83. BGCOLOR 15 NO-UNDO.
  84. DEFINE VARIABLE CB_Fahrer AS CHARACTER FORMAT "X(256)":U
  85. LABEL "Fahrer"
  86. VIEW-AS COMBO-BOX INNER-LINES 5
  87. LIST-ITEM-PAIRS "Item 1","Item 1"
  88. DROP-DOWN-LIST
  89. SIZE 40 BY 1
  90. BGCOLOR 15 NO-UNDO.
  91. DEFINE VARIABLE CB_Lieferart AS CHARACTER FORMAT "X(256)":U
  92. LABEL "Lieferart"
  93. VIEW-AS COMBO-BOX INNER-LINES 5
  94. LIST-ITEM-PAIRS "Item 1","Item 1"
  95. DROP-DOWN-LIST
  96. SIZE 40 BY 1
  97. BGCOLOR 15 NO-UNDO.
  98. DEFINE VARIABLE CB_Lkw AS CHARACTER FORMAT "X(256)":U
  99. LABEL "Lkw"
  100. VIEW-AS COMBO-BOX INNER-LINES 5
  101. LIST-ITEM-PAIRS "Item 1","Item 1"
  102. DROP-DOWN-LIST
  103. SIZE 40 BY 1
  104. BGCOLOR 15 NO-UNDO.
  105. DEFINE VARIABLE F_Anzahl AS INTEGER FORMAT "zzz,zz9":U INITIAL 0
  106. LABEL "Anz. Aufträge"
  107. VIEW-AS FILL-IN NATIVE
  108. SIZE 12 BY 1
  109. BGCOLOR 15 NO-UNDO.
  110. DEFINE VARIABLE F_Gewicht AS DECIMAL FORMAT "zzz,zz9-":U INITIAL 0
  111. LABEL "Total Gewicht"
  112. VIEW-AS FILL-IN NATIVE
  113. SIZE 12 BY 1
  114. BGCOLOR 15 NO-UNDO.
  115. DEFINE RECTANGLE RECT-1
  116. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  117. SIZE 156 BY 13.81.
  118. /* Query definitions */
  119. &ANALYZE-SUSPEND
  120. DEFINE TEMP-TABLE RowObject NO-UNDO
  121. {{&DATA-FIELD-DEFS}}
  122. {src/adm2/robjflds.i}.
  123. DEFINE QUERY br_AufkoAuftrag FOR
  124. rowObject SCROLLING.
  125. &ANALYZE-RESUME
  126. /* Browse definitions */
  127. DEFINE BROWSE br_AufkoAuftrag
  128. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_AufkoAuftrag bTableWin _STRUCTURED
  129. QUERY br_AufkoAuftrag NO-LOCK DISPLAY
  130. rowObject.Aufnr FORMAT "9999999":U
  131. rowObject.Knr FORMAT "999999":U
  132. rowObject.Kunde FORMAT "x(60)":U
  133. rowObject.Fak_Art COLUMN-LABEL "Art" FORMAT "99":U WIDTH 4
  134. rowObject.Lief_Datum COLUMN-LABEL "LiefDatum" FORMAT "99.99.9999":U
  135. rowObject.Lief_Bed COLUMN-LABEL "Lieferart" FORMAT "99":U
  136. rowObject.Tour_Nr1 COLUMN-LABEL "Tour" FORMAT "99":U
  137. rowObject.Tour_Nr2 COLUMN-LABEL "Tour" FORMAT "x(20)":U
  138. rowObject.Auf_Tot COLUMN-LABEL "Total" FORMAT "zzz,zzz,zz9.99-":U
  139. rowObject.Gewicht FORMAT "zzz,zz9.999-":U
  140. /* _UIB-CODE-BLOCK-END */
  141. &ANALYZE-RESUME
  142. WITH NO-ASSIGN NO-AUTO-VALIDATE NO-ROW-MARKERS SEPARATORS MULTIPLE SIZE 154 BY 13.33 ROW-HEIGHT-CHARS .67.
  143. /* ************************ Frame Definitions *********************** */
  144. DEFINE FRAME F-Main
  145. br_AufkoAuftrag AT ROW 1.48 COL 3 WIDGET-ID 200
  146. F_Anzahl AT ROW 16 COL 18 COLON-ALIGNED WIDGET-ID 16 NO-TAB-STOP
  147. CB_Fahrer AT ROW 16 COL 58 COLON-ALIGNED WIDGET-ID 4
  148. CB_Lkw AT ROW 16 COL 113 COLON-ALIGNED WIDGET-ID 8
  149. F_Gewicht AT ROW 17 COL 18 COLON-ALIGNED WIDGET-ID 18 NO-TAB-STOP
  150. CB_Beifahrer AT ROW 17 COL 58 COLON-ALIGNED WIDGET-ID 6
  151. CB_Lieferart AT ROW 17 COL 113 COLON-ALIGNED WIDGET-ID 10
  152. Btn_Weiter AT ROW 18.62 COL 60 WIDGET-ID 12
  153. Btn_Drucken AT ROW 18.62 COL 115 WIDGET-ID 14
  154. RECT-1 AT ROW 1.24 COL 2 WIDGET-ID 2
  155. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
  156. SIDE-LABELS NO-UNDERLINE THREE-D
  157. AT COL 1 ROW 1 SCROLLABLE WIDGET-ID 100.
  158. /* *********************** Procedure Settings ************************ */
  159. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  160. /* Settings for THIS-PROCEDURE
  161. Type: SmartDataBrowser
  162. Data Source: "d-aufko-auftrag.w"
  163. Allow: Basic,Browse
  164. Frames: 1
  165. Add Fields to: Neither
  166. Other Settings: PERSISTENT-ONLY COMPILE
  167. */
  168. /* This procedure should always be RUN PERSISTENT. Report the error, */
  169. /* then cleanup and return. */
  170. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  171. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  172. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  173. RETURN.
  174. END.
  175. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  176. /* ************************* Create Window ************************** */
  177. &ANALYZE-SUSPEND _CREATE-WINDOW
  178. /* DESIGN Window definition (used by the UIB)
  179. CREATE WINDOW bTableWin ASSIGN
  180. HEIGHT = 19.67
  181. WIDTH = 158.
  182. /* END WINDOW DEFINITION */
  183. */
  184. &ANALYZE-RESUME
  185. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB bTableWin
  186. /* ************************* Included-Libraries *********************** */
  187. {src/adm2/browser.i}
  188. /* _UIB-CODE-BLOCK-END */
  189. &ANALYZE-RESUME
  190. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  191. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  192. /* SETTINGS FOR WINDOW bTableWin
  193. NOT-VISIBLE,,RUN-PERSISTENT */
  194. /* SETTINGS FOR FRAME F-Main
  195. NOT-VISIBLE FRAME-NAME Size-to-Fit */
  196. /* BROWSE-TAB br_AufkoAuftrag RECT-1 F-Main */
  197. ASSIGN
  198. FRAME F-Main:SCROLLABLE = FALSE
  199. FRAME F-Main:HIDDEN = TRUE.
  200. ASSIGN
  201. rowObject.Gewicht:VISIBLE IN BROWSE br_AufkoAuftrag = FALSE.
  202. /* SETTINGS FOR BUTTON Btn_Drucken IN FRAME F-Main
  203. NO-ENABLE */
  204. ASSIGN
  205. F_Anzahl:READ-ONLY IN FRAME F-Main = TRUE.
  206. ASSIGN
  207. F_Gewicht:READ-ONLY IN FRAME F-Main = TRUE.
  208. /* _RUN-TIME-ATTRIBUTES-END */
  209. &ANALYZE-RESUME
  210. /* Setting information for Queries and Browse Widgets fields */
  211. &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_AufkoAuftrag
  212. /* Query rebuild information for BROWSE br_AufkoAuftrag
  213. _TblList = "rowObject"
  214. _Options = "NO-LOCK INDEXED-REPOSITION"
  215. _FldNameList[1] > _<SDO>.rowObject.Aufnr
  216. "rowObject.Aufnr" ? ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  217. _FldNameList[2] = _<SDO>.rowObject.Knr
  218. _FldNameList[3] = _<SDO>.rowObject.Kunde
  219. _FldNameList[4] > _<SDO>.rowObject.Fak_Art
  220. "rowObject.Fak_Art" "Art" ? "integer" ? ? ? ? ? ? no "?" no no "4" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  221. _FldNameList[5] > _<SDO>.rowObject.Lief_Datum
  222. "rowObject.Lief_Datum" "LiefDatum" ? "date" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  223. _FldNameList[6] > _<SDO>.rowObject.Lief_Bed
  224. "rowObject.Lief_Bed" "Lieferart" ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  225. _FldNameList[7] > _<SDO>.rowObject.Tour_Nr1
  226. "rowObject.Tour_Nr1" "Tour" ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  227. _FldNameList[8] > _<SDO>.rowObject.Tour_Nr2
  228. "rowObject.Tour_Nr2" "Tour" ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  229. _FldNameList[9] > _<SDO>.rowObject.Auf_Tot
  230. "rowObject.Auf_Tot" "Total" ? "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  231. _FldNameList[10] > _<SDO>.rowObject.Gewicht
  232. "rowObject.Gewicht" ? ? "decimal" ? ? ? ? ? ? no ? no no ? no no no "U" "" "" "" "" "" "" 0 no 0 no no
  233. _Query is NOT OPENED
  234. */ /* BROWSE br_AufkoAuftrag */
  235. &ANALYZE-RESUME
  236. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
  237. /* Query rebuild information for FRAME F-Main
  238. _Options = "NO-LOCK"
  239. _Query is NOT OPENED
  240. */ /* FRAME F-Main */
  241. &ANALYZE-RESUME
  242. /* ************************ Control Triggers ************************ */
  243. &Scoped-define BROWSE-NAME br_AufkoAuftrag
  244. &Scoped-define SELF-NAME br_AufkoAuftrag
  245. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_AufkoAuftrag bTableWin
  246. ON CTRL-END OF br_AufkoAuftrag IN FRAME F-Main
  247. DO:
  248. APPLY "END":U TO BROWSE {&BROWSE-NAME}.
  249. END.
  250. /* _UIB-CODE-BLOCK-END */
  251. &ANALYZE-RESUME
  252. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_AufkoAuftrag bTableWin
  253. ON CTRL-HOME OF br_AufkoAuftrag IN FRAME F-Main
  254. DO:
  255. APPLY "HOME":U TO BROWSE {&BROWSE-NAME}.
  256. END.
  257. /* _UIB-CODE-BLOCK-END */
  258. &ANALYZE-RESUME
  259. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_AufkoAuftrag bTableWin
  260. ON DEFAULT-ACTION OF br_AufkoAuftrag IN FRAME F-Main
  261. DO:
  262. {src/adm2/brsdefault.i}
  263. END.
  264. /* _UIB-CODE-BLOCK-END */
  265. &ANALYZE-RESUME
  266. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_AufkoAuftrag bTableWin
  267. ON END OF br_AufkoAuftrag IN FRAME F-Main
  268. DO:
  269. {src/adm2/brsend.i}
  270. END.
  271. /* _UIB-CODE-BLOCK-END */
  272. &ANALYZE-RESUME
  273. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_AufkoAuftrag bTableWin
  274. ON HOME OF br_AufkoAuftrag IN FRAME F-Main
  275. DO:
  276. {src/adm2/brshome.i}
  277. END.
  278. /* _UIB-CODE-BLOCK-END */
  279. &ANALYZE-RESUME
  280. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_AufkoAuftrag bTableWin
  281. ON LEFT-MOUSE-CLICK OF br_AufkoAuftrag IN FRAME F-Main
  282. DO:
  283. APPLY 'ENTRY' TO {&BROWSE-NAME}.
  284. END.
  285. /* _UIB-CODE-BLOCK-END */
  286. &ANALYZE-RESUME
  287. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_AufkoAuftrag bTableWin
  288. ON LEFT-MOUSE-DBLCLICK OF br_AufkoAuftrag IN FRAME F-Main
  289. DO:
  290. IF NOT VALID-HANDLE( hFenster ) THEN RETURN NO-APPLY.
  291. RUN TOOLBAR IN hFenster ( INPUT 'UPDATE' ).
  292. RETURN NO-APPLY.
  293. END.
  294. /* _UIB-CODE-BLOCK-END */
  295. &ANALYZE-RESUME
  296. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_AufkoAuftrag bTableWin
  297. ON OFF-END OF br_AufkoAuftrag IN FRAME F-Main
  298. DO:
  299. {src/adm2/brsoffnd.i}
  300. END.
  301. /* _UIB-CODE-BLOCK-END */
  302. &ANALYZE-RESUME
  303. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_AufkoAuftrag bTableWin
  304. ON OFF-HOME OF br_AufkoAuftrag IN FRAME F-Main
  305. DO:
  306. {src/adm2/brsoffhm.i}
  307. END.
  308. /* _UIB-CODE-BLOCK-END */
  309. &ANALYZE-RESUME
  310. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_AufkoAuftrag bTableWin
  311. ON ROW-ENTRY OF br_AufkoAuftrag IN FRAME F-Main
  312. DO:
  313. {src/adm2/brsentry.i}
  314. END.
  315. /* _UIB-CODE-BLOCK-END */
  316. &ANALYZE-RESUME
  317. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_AufkoAuftrag bTableWin
  318. ON ROW-LEAVE OF br_AufkoAuftrag IN FRAME F-Main
  319. DO:
  320. {src/adm2/brsleave.i}
  321. END.
  322. /* _UIB-CODE-BLOCK-END */
  323. &ANALYZE-RESUME
  324. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_AufkoAuftrag bTableWin
  325. ON SCROLL-NOTIFY OF br_AufkoAuftrag IN FRAME F-Main
  326. DO:
  327. {src/adm2/brsscrol.i}
  328. END.
  329. /* _UIB-CODE-BLOCK-END */
  330. &ANALYZE-RESUME
  331. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_AufkoAuftrag bTableWin
  332. ON START-SEARCH OF br_AufkoAuftrag IN FRAME F-Main
  333. DO:
  334. { incl/brwstartsearch.i }
  335. END.
  336. /* _UIB-CODE-BLOCK-END */
  337. &ANALYZE-RESUME
  338. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_AufkoAuftrag bTableWin
  339. ON VALUE-CHANGED OF br_AufkoAuftrag IN FRAME F-Main
  340. DO:
  341. {src/adm2/brschnge.i}
  342. DEF VAR ix AS INT NO-UNDO.
  343. DEF VAR i1 AS INT NO-UNDO.
  344. DEF VAR iRecid AS RECID NO-UNDO.
  345. DEF BUFFER bAufko FOR Aufko.
  346. i1 = Br_AufkoAuftrag:NUM-SELECTED-ROWS.
  347. F_Anzahl = 0.
  348. F_Gewicht = 0.
  349. DO ix = 1 TO i1 WITH FRAME {&FRAME-NAME}:
  350. Br_AufkoAuftrag:FETCH-SELECTED-ROW(ix).
  351. iRecid = DYNAMIC-FUNCTION('getCurrentRecid':U IN hDaten ) NO-ERROR.
  352. FIND bAufko NO-LOCK WHERE RECID(bAufko) = iRecid.
  353. F_Anzahl = F_Anzahl + 1.
  354. F_Gewicht = F_Gewicht + bAufko.Gewicht.
  355. RELEASE bAufko.
  356. END.
  357. DISPLAY F_Anzahl F_Gewicht WITH FRAME {&FRAME-NAME}.
  358. END.
  359. /* _UIB-CODE-BLOCK-END */
  360. &ANALYZE-RESUME
  361. &Scoped-define SELF-NAME Btn_Weiter
  362. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Weiter bTableWin
  363. ON CHOOSE OF Btn_Weiter IN FRAME F-Main /* Weiter */
  364. DO:
  365. RUN MUTATION.
  366. DYNAMIC-FUNCTION('openQuery':U IN hdaten ) NO-ERROR.
  367. END.
  368. /* _UIB-CODE-BLOCK-END */
  369. &ANALYZE-RESUME
  370. &UNDEFINE SELF-NAME
  371. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK bTableWin
  372. /* *************************** Main Block *************************** */
  373. { incl/brwmainblock.i }
  374. { incl/brwinternproc.i }
  375. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  376. RUN initializeObject.
  377. &ENDIF
  378. /* _UIB-CODE-BLOCK-END */
  379. &ANALYZE-RESUME
  380. /* ********************** Internal Procedures *********************** */
  381. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE destroyObject bTableWin
  382. PROCEDURE destroyObject :
  383. /*------------------------------------------------------------------------------
  384. Purpose: Super Override
  385. Parameters:
  386. Notes:
  387. ------------------------------------------------------------------------------*/
  388. DEF VAR hBrowser AS HANDLE NO-UNDO.
  389. hBrowser = {&BROWSE-NAME}:HANDLE IN FRAME {&FRAME-NAME}.
  390. DYNAMIC-FUNCTION('setBrowserDaten':U, INPUT hBrowser,
  391. INPUT Sektion ) NO-ERROR.
  392. RUN SUPER.
  393. /* Code placed here will execute AFTER standard behavior. */
  394. END PROCEDURE.
  395. /* _UIB-CODE-BLOCK-END */
  396. &ANALYZE-RESUME
  397. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI bTableWin _DEFAULT-DISABLE
  398. PROCEDURE disable_UI :
  399. /*------------------------------------------------------------------------------
  400. Purpose: DISABLE the User Interface
  401. Parameters: <none>
  402. Notes: Here we clean-up the user-interface by deleting
  403. dynamic widgets we have created and/or hide
  404. frames. This procedure is usually called when
  405. we are ready to "clean-up" after running.
  406. ------------------------------------------------------------------------------*/
  407. /* Hide all frames. */
  408. HIDE FRAME F-Main.
  409. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  410. END PROCEDURE.
  411. /* _UIB-CODE-BLOCK-END */
  412. &ANALYZE-RESUME
  413. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject bTableWin
  414. PROCEDURE enableObject :
  415. /*------------------------------------------------------------------------------
  416. Purpose: Super Override
  417. Parameters:
  418. Notes:
  419. ------------------------------------------------------------------------------*/
  420. DO WITH FRAME {&FRAME-NAME}:
  421. RUN COMBO_FAHRER ( CB_Fahrer :HANDLE ).
  422. RUN COMBO_BEIFAHRER ( CB_BeiFahrer:HANDLE ).
  423. RUN COMBO_LKW ( CB_Lkw :HANDLE ).
  424. RUN COMBO_LIEFBEDINGUNG ( CB_Lieferart:HANDLE ).
  425. END.
  426. RUN SUPER.
  427. /* Code placed here will execute AFTER standard behavior. */
  428. END PROCEDURE.
  429. /* _UIB-CODE-BLOCK-END */
  430. &ANALYZE-RESUME
  431. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_BROWSE bTableWin
  432. PROCEDURE ENTRY_BROWSE :
  433. /*------------------------------------------------------------------------------
  434. Purpose:
  435. Parameters: <none>
  436. Notes:
  437. ------------------------------------------------------------------------------*/
  438. APPLY 'ENTRY' TO {&BROWSE-NAME} IN FRAME {&FRAME-NAME}.
  439. RETURN NO-APPLY.
  440. END PROCEDURE.
  441. /* _UIB-CODE-BLOCK-END */
  442. &ANALYZE-RESUME
  443. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject bTableWin
  444. PROCEDURE initializeObject :
  445. /*------------------------------------------------------------------------------
  446. Purpose: Super Override
  447. Parameters:
  448. Notes:
  449. ------------------------------------------------------------------------------*/
  450. { incl/brwinitialize.i }
  451. END PROCEDURE.
  452. /* _UIB-CODE-BLOCK-END */
  453. &ANALYZE-RESUME
  454. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE MUTATION bTableWin
  455. PROCEDURE MUTATION :
  456. /*------------------------------------------------------------------------------
  457. Purpose:
  458. Parameters: <none>
  459. Notes:
  460. ------------------------------------------------------------------------------*/
  461. DEF VAR iFahrer AS INT NO-UNDO.
  462. DEF VAR iBeiFahrer AS INT NO-UNDO.
  463. DEF VAR iLkw AS INT NO-UNDO.
  464. DEF VAR iLiefart AS INT NO-UNDO.
  465. DEF VAR iRecid AS RECID NO-UNDO.
  466. DEF VAR iAufnr AS INT NO-UNDO.
  467. DEF VAR ix AS INT NO-UNDO.
  468. DEF VAR i1 AS INT NO-UNDO.
  469. DEF BUFFER bAufko FOR Aufko.
  470. DO WITH FRAME {&FRAME-NAME}:
  471. DISABLE Btn_Weiter
  472. Btn_Drucken.
  473. ASSIGN iFahrer = INTEGER(CB_Fahrer :SCREEN-VALUE)
  474. iBeiFahrer = INTEGER(CB_BeiFahrer:SCREEN-VALUE)
  475. iLkw = INTEGER(CB_Lkw :SCREEN-VALUE)
  476. iLiefart = INTEGER(CB_Lieferart:SCREEN-VALUE).
  477. i1 = Br_AufkoAuftrag:NUM-SELECTED-ROWS.
  478. DO ix = 1 TO i1 TRANSACTION:
  479. Br_AufkoAuftrag:FETCH-SELECTED-ROW(1).
  480. iRecid = DYNAMIC-FUNCTION('getCurrentRecid':U IN hDaten ) NO-ERROR.
  481. FIND bAufko WHERE RECID(bAufko) = iRecid.
  482. iAufnr = bAufko.Aufnr.
  483. IF bAufko.AlsOfferte THEN DO:
  484. RELEASE bAufko.
  485. MESSAGE 'Auftrag 'iAufnr ' ist Offerte! WEITER geht hier nicht! '
  486. VIEW-AS ALERT-BOX INFORMATION.
  487. Br_AufkoAuftrag:DESELECT-SELECTED-ROW(1).
  488. NEXT.
  489. END.
  490. ASSIGN bAufko.Fahrer = iFahrer
  491. bAufko.BeiFahr = iBeiFahrer
  492. bAufko.LKW = iLKW
  493. bAufko.Lief_Bed = iLiefArt .
  494. RELEASE bAufko.
  495. Br_AufkoAuftrag:DESELECT-SELECTED-ROW(1).
  496. RUN WEITER ( iAufnr ).
  497. END.
  498. ENABLE Btn_Weiter
  499. Btn_Drucken.
  500. F_Anzahl = 0.
  501. F_Gewicht = 0.
  502. END.
  503. END PROCEDURE.
  504. /* _UIB-CODE-BLOCK-END */
  505. &ANALYZE-RESUME
  506. /* ************************ Function Implementations ***************** */
  507. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION setZeilenfarbe bTableWin
  508. FUNCTION setZeilenfarbe RETURNS LOGICAL
  509. ( ipFarbe AS INT ) :
  510. /*------------------------------------------------------------------------------
  511. Purpose:
  512. Notes:
  513. ------------------------------------------------------------------------------*/
  514. { incl/brwsetzeilenfarbe.i }
  515. END FUNCTION.
  516. /* _UIB-CODE-BLOCK-END */
  517. &ANALYZE-RESUME