v-kubessta.w 41 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261
  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. /* Temp-Table and Buffer definitions */
  8. DEFINE TEMP-TABLE RowObject
  9. {"d-kubessta.i"}.
  10. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS vTableWin
  11. /*------------------------------------------------------------------------
  12. File:
  13. Description: from viewer.w - Template for SmartDataViewer objects
  14. Input Parameters:
  15. <none>
  16. Output Parameters:
  17. <none>
  18. ------------------------------------------------------------------------*/
  19. /* This .W file was created with the Progress AppBuilder. */
  20. /*----------------------------------------------------------------------*/
  21. /* Create an unnamed pool to store all the widgets created
  22. by this procedure. This is a good default which assures
  23. that this procedure's triggers and internal procedures
  24. will execute in this procedure's storage, and that proper
  25. cleanup will occur on deletion of the procedure. */
  26. CREATE WIDGET-POOL.
  27. /* *************************** Definitions ************************** */
  28. /* Komma-Trennzeichen */
  29. /* Keyfelder werden beim Mutieren nicht "Enabled" */
  30. &Scoped-define ERSTES_FELD CB_Vertreter
  31. &Scoped-define LETZTES_FELD FremdLief5
  32. &Scoped-define KEY_FELDER
  33. &Scoped-define NUR_LESEN AnzHaben,LetztBesuch
  34. /* Parameters Definitions --- */
  35. /* Local Variable Definitions --- */
  36. DEF VAR SAktiv AS LOG NO-UNDO INIT FALSE.
  37. DEF VAR FNeu AS LOG NO-UNDO INIT FALSE.
  38. DEF VAR FMut AS LOG NO-UNDO INIT FALSE.
  39. DEF VAR FCopy AS LOG NO-UNDO INIT FALSE.
  40. DEF VAR FDisp AS LOG NO-UNDO INIT TRUE .
  41. DEF VAR Fenster AS HANDLE NO-UNDO.
  42. DEF VAR oldColValues AS CHAR NO-UNDO.
  43. DEF VAR oldColList AS CHAR NO-UNDO.
  44. DEF VAR Firma AS CHAR NO-UNDO.
  45. DEF VAR Knr AS INT NO-UNDO.
  46. DEF VAR fVertr AS LOG NO-UNDO INIT FALSE.
  47. DEF VAR fBier AS LOG NO-UNDO INIT FALSE.
  48. DEF VAR fWiSo AS LOG NO-UNDO INIT FALSE.
  49. DEF VAR cvKuBes AS CHAR INIT 'v-kubes.w' NO-UNDO.
  50. DEF VAR cvKuBesSta AS CHAR INIT 'v-kubessta.w' NO-UNDO.
  51. DEF VAR hKontainer AS HANDLE NO-UNDO.
  52. DEF VAR hDaten AS HANDLE NO-UNDO.
  53. DEF WORKFILE WDebst LIKE Debst.
  54. /* _UIB-CODE-BLOCK-END */
  55. &ANALYZE-RESUME
  56. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  57. /* ******************** Preprocessor Definitions ******************** */
  58. &Scoped-define PROCEDURE-TYPE SmartDataViewer
  59. &Scoped-define DB-AWARE no
  60. &Scoped-define ADM-CONTAINER FRAME
  61. &Scoped-define ADM-SUPPORTED-LINKS Data-Target,Update-Source,TableIO-Target,GroupAssign-Source,GroupAssign-Target
  62. /* Include file with RowObject temp-table definition */
  63. &Scoped-define DATA-FIELD-DEFS "d-kubessta.i"
  64. /* Name of designated FRAME-NAME and/or first browse and/or first query */
  65. &Scoped-define FRAME-NAME KunBesSta
  66. /* Standard List Definitions */
  67. &Scoped-Define ENABLED-FIELDS RowObject.AnzSoll RowObject.AnzHaben ~
  68. RowObject.LetztBesuch RowObject.FremdLief1 RowObject.FremdLief2 ~
  69. RowObject.FremdLief3 RowObject.FremdLief4 RowObject.FremdLief5
  70. &Scoped-define ENABLED-TABLES RowObject
  71. &Scoped-define FIRST-ENABLED-TABLE RowObject
  72. &Scoped-Define ENABLED-OBJECTS Btn_Update CB_Vertreter CB_Biergruppe ~
  73. CB_Wirtesonntag CB_Warengruppe-1 CB_Warengruppe-2 CB_Warengruppe-3 ~
  74. CB_Warengruppe-4 CB_Warengruppe-5 RECT-6
  75. &Scoped-Define DISPLAYED-FIELDS RowObject.AnzSoll RowObject.AnzHaben ~
  76. RowObject.LetztBesuch RowObject.FremdLief1 RowObject.Firma ~
  77. RowObject.FremdLief2 RowObject.Knr RowObject.FremdLief3 ~
  78. RowObject.FremdLief4 RowObject.FremdWgr1 RowObject.FremdLief5 ~
  79. RowObject.FremdWgr4 RowObject.FremdWgr3 RowObject.FremdWgr5 ~
  80. RowObject.FremdWgr2
  81. &Scoped-define DISPLAYED-TABLES RowObject
  82. &Scoped-define FIRST-DISPLAYED-TABLE RowObject
  83. &Scoped-Define DISPLAYED-OBJECTS CB_Vertreter CB_Biergruppe CB_Wirtesonntag ~
  84. CB_Warengruppe-1 CB_Warengruppe-2 CB_Warengruppe-3 CB_Warengruppe-4 ~
  85. CB_Warengruppe-5
  86. /* Custom List Definitions */
  87. /* ADM-ASSIGN-FIELDS,List-2,List-3,List-4,List-5,List-6 */
  88. /* _UIB-PREPROCESSOR-BLOCK-END */
  89. &ANALYZE-RESUME
  90. /* *********************** Control Definitions ********************** */
  91. /* Menu Definitions */
  92. DEFINE MENU POPUP-MENU-F-Main
  93. MENU-ITEM m_Fehlwerte_fllen LABEL "Fehlwerte füllen"
  94. MENU-ITEM m_Fehlwerte_schreiben LABEL "Fehlwerte schreiben".
  95. DEFINE MENU POPUP-MENU-LetztBesuch
  96. MENU-ITEM m_Datum_lschen LABEL "Datum löschen" .
  97. /* Definitions of the field level widgets */
  98. DEFINE BUTTON Btn_Cancel
  99. IMAGE-UP FILE "grafik/cancel.bmp":U
  100. LABEL "Sichern"
  101. SIZE 4.8 BY 1.14.
  102. DEFINE BUTTON Btn_Save
  103. IMAGE-UP FILE "grafik/saverec.bmp":U
  104. LABEL "Sichern"
  105. SIZE 4.8 BY 1.14.
  106. DEFINE BUTTON Btn_Update
  107. IMAGE-UP FILE "grafik/update.bmp":U
  108. LABEL "Aendern"
  109. SIZE 4.8 BY 1.14.
  110. DEFINE VARIABLE CB_Biergruppe AS CHARACTER FORMAT "X(256)":U
  111. LABEL "Biervertrag"
  112. VIEW-AS COMBO-BOX INNER-LINES 5
  113. LIST-ITEM-PAIRS "Item 1","Item 1"
  114. DROP-DOWN-LIST
  115. SIZE 30 BY 1
  116. BGCOLOR 15 NO-UNDO.
  117. DEFINE VARIABLE CB_Vertreter AS CHARACTER FORMAT "X(256)":U
  118. LABEL "Vertreter"
  119. VIEW-AS COMBO-BOX INNER-LINES 5
  120. LIST-ITEM-PAIRS "Item 1","Item 1"
  121. DROP-DOWN-LIST
  122. SIZE 30 BY 1
  123. BGCOLOR 15 NO-UNDO.
  124. DEFINE VARIABLE CB_Warengruppe-1 AS CHARACTER FORMAT "X(256)":U
  125. LABEL "Fremdlieferant bei"
  126. VIEW-AS COMBO-BOX INNER-LINES 5
  127. LIST-ITEM-PAIRS "Item 1","Item 1"
  128. DROP-DOWN-LIST
  129. SIZE 30 BY 1
  130. BGCOLOR 15 NO-UNDO.
  131. DEFINE VARIABLE CB_Warengruppe-2 AS CHARACTER FORMAT "X(256)":U
  132. LABEL "Fremdlieferant bei"
  133. VIEW-AS COMBO-BOX INNER-LINES 5
  134. LIST-ITEM-PAIRS "Item 1","Item 1"
  135. DROP-DOWN-LIST
  136. SIZE 30 BY 1
  137. BGCOLOR 15 NO-UNDO.
  138. DEFINE VARIABLE CB_Warengruppe-3 AS CHARACTER FORMAT "X(256)":U
  139. LABEL "Fremdlieferant bei"
  140. VIEW-AS COMBO-BOX INNER-LINES 5
  141. LIST-ITEM-PAIRS "Item 1","Item 1"
  142. DROP-DOWN-LIST
  143. SIZE 30 BY 1
  144. BGCOLOR 15 NO-UNDO.
  145. DEFINE VARIABLE CB_Warengruppe-4 AS CHARACTER FORMAT "X(256)":U
  146. LABEL "Fremdlieferant bei"
  147. VIEW-AS COMBO-BOX INNER-LINES 5
  148. LIST-ITEM-PAIRS "Item 1","Item 1"
  149. DROP-DOWN-LIST
  150. SIZE 30 BY 1
  151. BGCOLOR 15 NO-UNDO.
  152. DEFINE VARIABLE CB_Warengruppe-5 AS CHARACTER FORMAT "X(256)":U
  153. LABEL "Fremdlieferant bei"
  154. VIEW-AS COMBO-BOX INNER-LINES 5
  155. LIST-ITEM-PAIRS "Item 1","Item 1"
  156. DROP-DOWN-LIST
  157. SIZE 30 BY 1
  158. BGCOLOR 15 NO-UNDO.
  159. DEFINE VARIABLE CB_Wirtesonntag AS CHARACTER FORMAT "X(256)":U
  160. LABEL "Wirtesonntag"
  161. VIEW-AS COMBO-BOX INNER-LINES 5
  162. LIST-ITEM-PAIRS "Item 1","Item 1"
  163. DROP-DOWN-LIST
  164. SIZE 30 BY 1
  165. BGCOLOR 15 NO-UNDO.
  166. DEFINE RECTANGLE RECT-6
  167. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  168. SIZE 150 BY 8.95.
  169. /* ************************ Frame Definitions *********************** */
  170. DEFINE FRAME KunBesSta
  171. Btn_Update AT ROW 1.52 COL 22 NO-TAB-STOP
  172. CB_Vertreter AT ROW 2.86 COL 20 COLON-ALIGNED
  173. RowObject.AnzSoll AT ROW 2.86 COL 70 COLON-ALIGNED HELP
  174. ""
  175. LABEL "Besuche Soll" FORMAT "zz9"
  176. VIEW-AS FILL-IN NATIVE
  177. SIZE 6.6 BY 1
  178. BGCOLOR 15
  179. RowObject.AnzHaben AT ROW 2.86 COL 93 COLON-ALIGNED HELP
  180. ""
  181. LABEL "Besuche Ist" FORMAT "zz9"
  182. VIEW-AS FILL-IN NATIVE
  183. SIZE 6.6 BY 1
  184. BGCOLOR 15 NO-TAB-STOP
  185. RowObject.LetztBesuch AT ROW 2.86 COL 118 COLON-ALIGNED HELP
  186. ""
  187. LABEL "Letzter Besuch" FORMAT "99.99.9999"
  188. VIEW-AS FILL-IN NATIVE
  189. SIZE 16 BY 1 TOOLTIP "mit der rechten Maustaste zum löschen"
  190. BGCOLOR 15 NO-TAB-STOP
  191. CB_Biergruppe AT ROW 3.86 COL 20 COLON-ALIGNED
  192. CB_Wirtesonntag AT ROW 3.86 COL 70 COLON-ALIGNED
  193. CB_Warengruppe-1 AT ROW 4.86 COL 20 COLON-ALIGNED
  194. RowObject.FremdLief1 AT ROW 4.86 COL 51 COLON-ALIGNED HELP
  195. "" NO-LABEL FORMAT "x(100)"
  196. VIEW-AS FILL-IN NATIVE
  197. SIZE 83 BY 1
  198. BGCOLOR 15
  199. CB_Warengruppe-2 AT ROW 5.86 COL 20 COLON-ALIGNED
  200. RowObject.Firma AT ROW 4.33 COL 118 COLON-ALIGNED
  201. VIEW-AS FILL-IN
  202. SIZE 4 BY 1 NO-TAB-STOP
  203. RowObject.FremdLief2 AT ROW 5.86 COL 51 COLON-ALIGNED HELP
  204. "" NO-LABEL FORMAT "x(100)"
  205. VIEW-AS FILL-IN NATIVE
  206. SIZE 83 BY 1
  207. BGCOLOR 15
  208. CB_Warengruppe-3 AT ROW 6.86 COL 20 COLON-ALIGNED
  209. RowObject.Knr AT ROW 4.33 COL 118 COLON-ALIGNED
  210. VIEW-AS FILL-IN
  211. SIZE 4 BY 1 NO-TAB-STOP
  212. RowObject.FremdLief3 AT ROW 6.86 COL 51 COLON-ALIGNED HELP
  213. "" NO-LABEL FORMAT "x(100)"
  214. VIEW-AS FILL-IN NATIVE
  215. SIZE 83 BY 1
  216. BGCOLOR 15
  217. CB_Warengruppe-4 AT ROW 7.86 COL 20 COLON-ALIGNED
  218. RowObject.FremdLief4 AT ROW 7.86 COL 51 COLON-ALIGNED HELP
  219. "" NO-LABEL FORMAT "x(100)"
  220. VIEW-AS FILL-IN NATIVE
  221. SIZE 83 BY 1
  222. BGCOLOR 15
  223. RowObject.FremdWgr1 AT ROW 4.33 COL 118 COLON-ALIGNED HELP
  224. ""
  225. LABEL "FremdWgr1" FORMAT "999999"
  226. VIEW-AS FILL-IN
  227. SIZE 4 BY 1 NO-TAB-STOP
  228. CB_Warengruppe-5 AT ROW 8.86 COL 20 COLON-ALIGNED
  229. RowObject.FremdLief5 AT ROW 8.86 COL 51 COLON-ALIGNED HELP
  230. "" NO-LABEL FORMAT "x(100)"
  231. VIEW-AS FILL-IN NATIVE
  232. SIZE 83 BY 1
  233. BGCOLOR 15
  234. RowObject.FremdWgr4 AT ROW 4.33 COL 118 COLON-ALIGNED HELP
  235. ""
  236. LABEL "FremdWgr4" FORMAT "999999"
  237. VIEW-AS FILL-IN
  238. SIZE 4 BY 1 NO-TAB-STOP
  239. Btn_Save AT ROW 1.52 COL 28 NO-TAB-STOP
  240. RowObject.FremdWgr3 AT ROW 4.33 COL 118 COLON-ALIGNED HELP
  241. ""
  242. LABEL "FremdWgr3" FORMAT "999999"
  243. VIEW-AS FILL-IN
  244. SIZE 4 BY 1 NO-TAB-STOP
  245. Btn_Cancel AT ROW 1.52 COL 34 NO-TAB-STOP
  246. RowObject.FremdWgr5 AT ROW 4.33 COL 118 COLON-ALIGNED HELP
  247. ""
  248. LABEL "FremdWgr5" FORMAT "999999"
  249. VIEW-AS FILL-IN
  250. SIZE 4 BY 1 NO-TAB-STOP
  251. RowObject.FremdWgr2 AT ROW 4.33 COL 118 COLON-ALIGNED HELP
  252. ""
  253. LABEL "FremdWgr2" FORMAT "999999"
  254. VIEW-AS FILL-IN
  255. SIZE 4 BY 1 NO-TAB-STOP
  256. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY USE-DICT-EXPS
  257. SIDE-LABELS NO-UNDERLINE THREE-D NO-AUTO-VALIDATE
  258. AT COL 1 ROW 1 SCROLLABLE .
  259. /* DEFINE FRAME statement is approaching 4K Bytes. Breaking it up */
  260. DEFINE FRAME KunBesSta
  261. RECT-6 AT ROW 1.24 COL 2
  262. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY USE-DICT-EXPS
  263. SIDE-LABELS NO-UNDERLINE THREE-D NO-AUTO-VALIDATE
  264. AT COL 1 ROW 1 SCROLLABLE .
  265. /* *********************** Procedure Settings ************************ */
  266. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  267. /* Settings for THIS-PROCEDURE
  268. Type: SmartDataViewer
  269. Data Source: "d-kubessta.w"
  270. Allow: Basic,DB-Fields,Smart
  271. Container Links: Data-Target,Update-Source,TableIO-Target,GroupAssign-Source,GroupAssign-Target
  272. Frames: 1
  273. Add Fields to: Neither
  274. Other Settings: PERSISTENT-ONLY COMPILE
  275. Temp-Tables and Buffers:
  276. TABLE: RowObject D "?" ?
  277. ADDITIONAL-FIELDS:
  278. {d-kubessta.i}
  279. END-FIELDS.
  280. END-TABLES.
  281. */
  282. /* This procedure should always be RUN PERSISTENT. Report the error, */
  283. /* then cleanup and return. */
  284. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  285. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  286. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  287. RETURN.
  288. END.
  289. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  290. /* ************************* Create Window ************************** */
  291. &ANALYZE-SUSPEND _CREATE-WINDOW
  292. /* DESIGN Window definition (used by the UIB)
  293. CREATE WINDOW vTableWin ASSIGN
  294. HEIGHT = 9.43
  295. WIDTH = 152.
  296. /* END WINDOW DEFINITION */
  297. */
  298. &ANALYZE-RESUME
  299. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB vTableWin
  300. /* ************************* Included-Libraries *********************** */
  301. {src/adm2/viewer.i}
  302. /* _UIB-CODE-BLOCK-END */
  303. &ANALYZE-RESUME
  304. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  305. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  306. /* SETTINGS FOR WINDOW vTableWin
  307. VISIBLE,,RUN-PERSISTENT */
  308. /* SETTINGS FOR FRAME KunBesSta
  309. NOT-VISIBLE FRAME-NAME Size-to-Fit Custom */
  310. ASSIGN
  311. FRAME KunBesSta:SCROLLABLE = FALSE
  312. FRAME KunBesSta:HIDDEN = TRUE
  313. FRAME KunBesSta:POPUP-MENU = MENU POPUP-MENU-F-Main:HANDLE.
  314. /* SETTINGS FOR FILL-IN RowObject.AnzHaben IN FRAME KunBesSta
  315. EXP-LABEL EXP-FORMAT EXP-HELP */
  316. /* SETTINGS FOR FILL-IN RowObject.AnzSoll IN FRAME KunBesSta
  317. EXP-LABEL EXP-FORMAT EXP-HELP */
  318. /* SETTINGS FOR BUTTON Btn_Cancel IN FRAME KunBesSta
  319. NO-ENABLE */
  320. /* SETTINGS FOR BUTTON Btn_Save IN FRAME KunBesSta
  321. NO-ENABLE */
  322. /* SETTINGS FOR FILL-IN RowObject.Firma IN FRAME KunBesSta
  323. NO-ENABLE */
  324. ASSIGN
  325. RowObject.Firma:HIDDEN IN FRAME KunBesSta = TRUE
  326. RowObject.Firma:READ-ONLY IN FRAME KunBesSta = TRUE.
  327. /* SETTINGS FOR FILL-IN RowObject.FremdLief1 IN FRAME KunBesSta
  328. EXP-LABEL EXP-FORMAT EXP-HELP */
  329. /* SETTINGS FOR FILL-IN RowObject.FremdLief2 IN FRAME KunBesSta
  330. EXP-LABEL EXP-FORMAT EXP-HELP */
  331. /* SETTINGS FOR FILL-IN RowObject.FremdLief3 IN FRAME KunBesSta
  332. EXP-LABEL EXP-FORMAT EXP-HELP */
  333. /* SETTINGS FOR FILL-IN RowObject.FremdLief4 IN FRAME KunBesSta
  334. EXP-LABEL EXP-FORMAT EXP-HELP */
  335. /* SETTINGS FOR FILL-IN RowObject.FremdLief5 IN FRAME KunBesSta
  336. EXP-LABEL EXP-FORMAT EXP-HELP */
  337. /* SETTINGS FOR FILL-IN RowObject.FremdWgr1 IN FRAME KunBesSta
  338. NO-ENABLE EXP-LABEL EXP-FORMAT EXP-HELP */
  339. ASSIGN
  340. RowObject.FremdWgr1:HIDDEN IN FRAME KunBesSta = TRUE
  341. RowObject.FremdWgr1:READ-ONLY IN FRAME KunBesSta = TRUE.
  342. /* SETTINGS FOR FILL-IN RowObject.FremdWgr2 IN FRAME KunBesSta
  343. NO-ENABLE EXP-LABEL EXP-FORMAT EXP-HELP */
  344. ASSIGN
  345. RowObject.FremdWgr2:HIDDEN IN FRAME KunBesSta = TRUE
  346. RowObject.FremdWgr2:READ-ONLY IN FRAME KunBesSta = TRUE.
  347. /* SETTINGS FOR FILL-IN RowObject.FremdWgr3 IN FRAME KunBesSta
  348. NO-ENABLE EXP-LABEL EXP-FORMAT EXP-HELP */
  349. ASSIGN
  350. RowObject.FremdWgr3:HIDDEN IN FRAME KunBesSta = TRUE
  351. RowObject.FremdWgr3:READ-ONLY IN FRAME KunBesSta = TRUE.
  352. /* SETTINGS FOR FILL-IN RowObject.FremdWgr4 IN FRAME KunBesSta
  353. NO-ENABLE EXP-LABEL EXP-FORMAT EXP-HELP */
  354. ASSIGN
  355. RowObject.FremdWgr4:HIDDEN IN FRAME KunBesSta = TRUE
  356. RowObject.FremdWgr4:READ-ONLY IN FRAME KunBesSta = TRUE.
  357. /* SETTINGS FOR FILL-IN RowObject.FremdWgr5 IN FRAME KunBesSta
  358. NO-ENABLE EXP-LABEL EXP-FORMAT EXP-HELP */
  359. ASSIGN
  360. RowObject.FremdWgr5:HIDDEN IN FRAME KunBesSta = TRUE
  361. RowObject.FremdWgr5:READ-ONLY IN FRAME KunBesSta = TRUE.
  362. /* SETTINGS FOR FILL-IN RowObject.Knr IN FRAME KunBesSta
  363. NO-ENABLE */
  364. ASSIGN
  365. RowObject.Knr:HIDDEN IN FRAME KunBesSta = TRUE
  366. RowObject.Knr:READ-ONLY IN FRAME KunBesSta = TRUE.
  367. /* SETTINGS FOR FILL-IN RowObject.LetztBesuch IN FRAME KunBesSta
  368. EXP-LABEL EXP-FORMAT EXP-HELP */
  369. ASSIGN
  370. RowObject.LetztBesuch:POPUP-MENU IN FRAME KunBesSta = MENU POPUP-MENU-LetztBesuch:HANDLE.
  371. /* _RUN-TIME-ATTRIBUTES-END */
  372. &ANALYZE-RESUME
  373. /* Setting information for Queries and Browse Widgets fields */
  374. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME KunBesSta
  375. /* Query rebuild information for FRAME KunBesSta
  376. _Options = "NO-LOCK"
  377. _Query is NOT OPENED
  378. */ /* FRAME KunBesSta */
  379. &ANALYZE-RESUME
  380. /* ************************ Control Triggers ************************ */
  381. &Scoped-define SELF-NAME KunBesSta
  382. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL KunBesSta vTableWin
  383. ON END-ERROR OF FRAME KunBesSta
  384. DO:
  385. APPLY 'CHOOSE' TO Btn_Cancel.
  386. RETURN NO-APPLY.
  387. END.
  388. /* _UIB-CODE-BLOCK-END */
  389. &ANALYZE-RESUME
  390. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL KunBesSta vTableWin
  391. ON ENDKEY OF FRAME KunBesSta
  392. DO:
  393. APPLY 'CHOOSE' TO Btn_Cancel.
  394. RETURN NO-APPLY.
  395. END.
  396. /* _UIB-CODE-BLOCK-END */
  397. &ANALYZE-RESUME
  398. &Scoped-define SELF-NAME Btn_Cancel
  399. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Cancel vTableWin
  400. ON CHOOSE OF Btn_Cancel IN FRAME KunBesSta /* Sichern */
  401. DO:
  402. RUN TOOLBAR IN hKontainer ( 'CANCEL' ).
  403. RETURN NO-APPLY.
  404. END.
  405. /* _UIB-CODE-BLOCK-END */
  406. &ANALYZE-RESUME
  407. &Scoped-define SELF-NAME Btn_Save
  408. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Save vTableWin
  409. ON CHOOSE OF Btn_Save IN FRAME KunBesSta /* Sichern */
  410. DO:
  411. RUN TOOLBAR IN hKontainer ( 'SAVE' ).
  412. RETURN NO-APPLY.
  413. END.
  414. /* _UIB-CODE-BLOCK-END */
  415. &ANALYZE-RESUME
  416. &Scoped-define SELF-NAME Btn_Update
  417. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Update vTableWin
  418. ON CHOOSE OF Btn_Update IN FRAME KunBesSta /* Aendern */
  419. DO:
  420. DYNAMIC-FUNCTION('setTableIOLink':U IN hKontainer, cvKuBesSta ).
  421. RUN TOOLBAR IN hKontainer ( 'UPDATE' ).
  422. RETURN NO-APPLY.
  423. END.
  424. /* _UIB-CODE-BLOCK-END */
  425. &ANALYZE-RESUME
  426. &Scoped-define SELF-NAME CB_Biergruppe
  427. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Biergruppe vTableWin
  428. ON VALUE-CHANGED OF CB_Biergruppe IN FRAME KunBesSta /* Biervertrag */
  429. DO:
  430. FIND FIRST WDebst.
  431. IF NOT FMut THEN SELF:SCREEN-VALUE = STRING(WDebst.Bier_Cd,'999999') NO-ERROR.
  432. ELSE fBier = TRUE.
  433. WDebst.Bier_Cd = INTEGER(SELF:SCREEN-VALUE).
  434. END.
  435. /* _UIB-CODE-BLOCK-END */
  436. &ANALYZE-RESUME
  437. &Scoped-define SELF-NAME CB_Vertreter
  438. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Vertreter vTableWin
  439. ON VALUE-CHANGED OF CB_Vertreter IN FRAME KunBesSta /* Vertreter */
  440. DO:
  441. FIND FIRST WDebst.
  442. IF NOT FMut THEN SELF:SCREEN-VALUE = STRING(WDebst.Vertr,'999999') NO-ERROR.
  443. ELSE fVertr = TRUE.
  444. WDebst.Vertr = INTEGER(SELF:SCREEN-VALUE).
  445. END.
  446. /* _UIB-CODE-BLOCK-END */
  447. &ANALYZE-RESUME
  448. &Scoped-define SELF-NAME CB_Wirtesonntag
  449. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Wirtesonntag vTableWin
  450. ON VALUE-CHANGED OF CB_Wirtesonntag IN FRAME KunBesSta /* Wirtesonntag */
  451. DO:
  452. FIND FIRST WDebst.
  453. IF NOT FMut THEN SELF:SCREEN-VALUE = STRING(WDebst.Wirt_So,'999999') NO-ERROR.
  454. ELSE fWiSo = TRUE.
  455. WDebst.Wirt_So = INTEGER(SELF:SCREEN-VALUE).
  456. END.
  457. /* _UIB-CODE-BLOCK-END */
  458. &ANALYZE-RESUME
  459. &Scoped-define SELF-NAME m_Datum_lschen
  460. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL m_Datum_lschen vTableWin
  461. ON CHOOSE OF MENU-ITEM m_Datum_lschen /* Datum löschen */
  462. DO:
  463. DO WITH FRAME {&FRAME-NAME}:
  464. rowObject.LetztBesuch:SCREEN-VALUE = ?.
  465. END.
  466. END.
  467. /* _UIB-CODE-BLOCK-END */
  468. &ANALYZE-RESUME
  469. &Scoped-define SELF-NAME m_Fehlwerte_fllen
  470. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL m_Fehlwerte_fllen vTableWin
  471. ON CHOOSE OF MENU-ITEM m_Fehlwerte_fllen /* Fehlwerte füllen */
  472. DO:
  473. IF NOT FMut THEN RETURN NO-APPLY.
  474. RUN LESENFEHLWERTE.
  475. END.
  476. /* _UIB-CODE-BLOCK-END */
  477. &ANALYZE-RESUME
  478. &Scoped-define SELF-NAME m_Fehlwerte_schreiben
  479. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL m_Fehlwerte_schreiben vTableWin
  480. ON CHOOSE OF MENU-ITEM m_Fehlwerte_schreiben /* Fehlwerte schreiben */
  481. DO:
  482. RUN SCHREIBENFEHLWERTE.
  483. END.
  484. /* _UIB-CODE-BLOCK-END */
  485. &ANALYZE-RESUME
  486. &UNDEFINE SELF-NAME
  487. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK vTableWin
  488. /* *************************** Main Block *************************** */
  489. SAktiv = DYNAMIC-FUNCTION('getSuperAktiv':U) NO-ERROR.
  490. IF SAktiv THEN DO:
  491. Firma = DYNAMIC-FUNCTION('GETMANDANT':U) NO-ERROR.
  492. END.
  493. FOR EACH WDebst:
  494. DELETE WDebst.
  495. END.
  496. CREATE WDebst.
  497. /* Triggers ------------------------------------------------------ */
  498. ON 'RETURN':U OF FRAME {&FRAME-NAME} ANYWHERE
  499. DO:
  500. RUN RETURN_FELD ( INPUT SELF:HANDLE ).
  501. IF RETURN-VALUE = 'TAB' THEN DO:
  502. APPLY 'TAB' TO SELF.
  503. RETURN NO-APPLY.
  504. END.
  505. END.
  506. ON 'ENTRY':U OF FRAME {&FRAME-NAME} ANYWHERE
  507. DO:
  508. RUN ENTRY_FELD_TEST ( INPUT SELF:HANDLE ).
  509. IF RETURN-VALUE = 'ERROR' THEN DO:
  510. APPLY 'ENTRY' TO SELF.
  511. RETURN NO-APPLY.
  512. END.
  513. IF RETURN-VALUE = 'APPLY' THEN DO:
  514. RETURN NO-APPLY.
  515. END.
  516. END.
  517. ON 'LEAVE':U OF FRAME {&FRAME-NAME} ANYWHERE
  518. DO:
  519. RUN LEAVE_FELD_TEST ( INPUT SELF:HANDLE ).
  520. IF RETURN-VALUE = 'ERROR' THEN DO:
  521. APPLY 'ENTRY' TO SELF.
  522. RETURN NO-APPLY.
  523. END.
  524. IF RETURN-VALUE = 'APPLY' THEN DO:
  525. RETURN NO-APPLY.
  526. END.
  527. END.
  528. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  529. RUN initializeObject.
  530. &ENDIF
  531. /************************ INTERNAL PROCEDURES ********************/
  532. /* _UIB-CODE-BLOCK-END */
  533. &ANALYZE-RESUME
  534. /* ********************** Internal Procedures *********************** */
  535. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE addRecord vTableWin
  536. PROCEDURE addRecord :
  537. /*------------------------------------------------------------------------------
  538. Purpose: Super Override
  539. Parameters:
  540. Notes:
  541. ------------------------------------------------------------------------------*/
  542. DYNAMIC-FUNCTION('setFlagAbbruchAlt', INPUT TRUE) NO-ERROR.
  543. PUBLISH 'TOOLBAR' ( INPUT 'CANCEL':U ).
  544. RETURN NO-APPLY.
  545. END PROCEDURE.
  546. /* _UIB-CODE-BLOCK-END */
  547. &ANALYZE-RESUME
  548. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE cancelRecord vTableWin
  549. PROCEDURE cancelRecord :
  550. /*------------------------------------------------------------------------------
  551. Purpose: Super Override
  552. Parameters:
  553. Notes:
  554. ------------------------------------------------------------------------------*/
  555. /* Code placed here will execute PRIOR to standard behavior. */
  556. RUN SUPER.
  557. /* Code placed here will execute AFTER standard behavior. */
  558. END PROCEDURE.
  559. /* _UIB-CODE-BLOCK-END */
  560. &ANALYZE-RESUME
  561. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE copyRecord vTableWin
  562. PROCEDURE copyRecord :
  563. /*------------------------------------------------------------------------------
  564. Purpose: Super Override
  565. Parameters:
  566. Notes:
  567. ------------------------------------------------------------------------------*/
  568. DYNAMIC-FUNCTION('setFlagAbbruchAlt', INPUT TRUE) NO-ERROR.
  569. PUBLISH 'TOOLBAR' ( INPUT 'CANCEL':U ).
  570. RETURN NO-APPLY.
  571. END PROCEDURE.
  572. /* _UIB-CODE-BLOCK-END */
  573. &ANALYZE-RESUME
  574. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE deleteRecord vTableWin
  575. PROCEDURE deleteRecord :
  576. /*------------------------------------------------------------------------------
  577. Purpose: Super Override
  578. Parameters:
  579. Notes:
  580. ------------------------------------------------------------------------------*/
  581. DYNAMIC-FUNCTION('setFlagAbbruchAlt', INPUT TRUE) NO-ERROR.
  582. PUBLISH 'TOOLBAR' ( INPUT 'CANCEL':U ).
  583. RETURN NO-APPLY.
  584. END PROCEDURE.
  585. /* _UIB-CODE-BLOCK-END */
  586. &ANALYZE-RESUME
  587. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disableFields vTableWin
  588. PROCEDURE disableFields :
  589. /*------------------------------------------------------------------------------
  590. Purpose: Super Override
  591. Parameters:
  592. Notes:
  593. ------------------------------------------------------------------------------*/
  594. DEFINE INPUT PARAMETER pcFieldType AS CHARACTER NO-UNDO.
  595. DO WITH FRAME {&FRAME-NAME}:
  596. END.
  597. RUN SUPER( INPUT pcFieldType).
  598. IF NOT VALID-HANDLE(Fenster) THEN Fenster = FRAME {&FRAME-NAME}:CURRENT-ITERATION.
  599. RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&ENABLED-FIELDS}', INPUT TRUE ).
  600. IF NUM-ENTRIES('{&KEY_FELDER}', ',') > 0 THEN DO:
  601. RUN FARBE_FELDER ( INPUT Fenster, INPUT '{&KEY_FELDER}', INPUT 15 ).
  602. END.
  603. DO WITH FRAME {&FRAME-NAME}:
  604. END.
  605. END PROCEDURE.
  606. /* _UIB-CODE-BLOCK-END */
  607. &ANALYZE-RESUME
  608. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI vTableWin _DEFAULT-DISABLE
  609. PROCEDURE disable_UI :
  610. /*------------------------------------------------------------------------------
  611. Purpose: DISABLE the User Interface
  612. Parameters: <none>
  613. Notes: Here we clean-up the user-interface by deleting
  614. dynamic widgets we have created and/or hide
  615. frames. This procedure is usually called when
  616. we are ready to "clean-up" after running.
  617. ------------------------------------------------------------------------------*/
  618. /* Hide all frames. */
  619. HIDE FRAME KunBesSta.
  620. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  621. END PROCEDURE.
  622. /* _UIB-CODE-BLOCK-END */
  623. &ANALYZE-RESUME
  624. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE displayFields vTableWin
  625. PROCEDURE displayFields :
  626. /*------------------------------------------------------------------------------
  627. Purpose: Super Override
  628. Parameters:
  629. Notes:
  630. ------------------------------------------------------------------------------*/
  631. DEFINE INPUT PARAMETER pcColValues AS CHARACTER NO-UNDO.
  632. IF NOT FDisp THEN DO:
  633. FDisp = TRUE.
  634. RETURN.
  635. END.
  636. OldColValues = pcColValues.
  637. OldColList = DYNAMIC-FUNCTION('getDisplayedFields':U).
  638. IF FNeu THEN RUN FEHLWERTE ( INPUT-OUTPUT pcColValues ).
  639. DO WITH FRAME {&FRAME-NAME}:
  640. END.
  641. RUN SUPER( INPUT pcColValues).
  642. DO WITH FRAME {&FRAME-NAME}:
  643. CB_Warengruppe-1:SCREEN-VALUE = rowObject.FremdWgr1:SCREEN-VALUE NO-ERROR.
  644. CB_Warengruppe-2:SCREEN-VALUE = rowObject.FremdWgr2:SCREEN-VALUE NO-ERROR.
  645. CB_Warengruppe-3:SCREEN-VALUE = rowObject.FremdWgr3:SCREEN-VALUE NO-ERROR.
  646. CB_Warengruppe-4:SCREEN-VALUE = rowObject.FremdWgr4:SCREEN-VALUE NO-ERROR.
  647. CB_Warengruppe-5:SCREEN-VALUE = rowObject.FremdWgr5:SCREEN-VALUE NO-ERROR.
  648. Knr = INTEGER(rowObject.Knr:SCREEN-VALUE).
  649. FIND FIRST WDebst.
  650. FIND Debst USE-INDEX Debst-k1
  651. WHERE Debst.Firma = Firma
  652. AND Debst.Knr = Knr NO-LOCK NO-ERROR.
  653. IF AVAILABLE Debst THEN DO:
  654. BUFFER-COPY Debst TO WDebst.
  655. CB_Vertreter :SCREEN-VALUE = STRING(WDebst.Vertr ,'999999') NO-ERROR.
  656. CB_Biergruppe :SCREEN-VALUE = STRING(WDebst.Bier_Cd,'999999') NO-ERROR.
  657. CB_Wirtesonntag:SCREEN-VALUE = STRING(WDebst.Wirt_So,'999999') NO-ERROR.
  658. END.
  659. ELSE DO:
  660. WDebst.Knr = 0.
  661. END.
  662. END.
  663. END PROCEDURE.
  664. /* _UIB-CODE-BLOCK-END */
  665. &ANALYZE-RESUME
  666. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableFields vTableWin
  667. PROCEDURE enableFields :
  668. /*------------------------------------------------------------------------------
  669. Purpose: Super Override
  670. Parameters:
  671. Notes:
  672. ------------------------------------------------------------------------------*/
  673. /* Code placed here will execute PRIOR to standard behavior. */
  674. /*
  675. RUN SUPER.
  676. */
  677. IF NOT VALID-HANDLE(Fenster) THEN Fenster = FRAME {&FRAME-NAME}:CURRENT-ITERATION.
  678. RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&ENABLED-FIELDS}', INPUT FALSE ).
  679. IF NUM-ENTRIES('{&NUR_LESEN}', ',') > 0 THEN DO:
  680. RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&NUR_LESEN}', INPUT TRUE ).
  681. END.
  682. DO WITH FRAME {&FRAME-NAME}:
  683. END.
  684. IF FNeu THEN RETURN.
  685. IF NUM-ENTRIES('{&KEY_FELDER}', ',') > 0 THEN DO:
  686. RUN SCHUETZE_FELDER ( INPUT Fenster, INPUT '{&KEY_FELDER}', INPUT TRUE ).
  687. END.
  688. END PROCEDURE.
  689. /* _UIB-CODE-BLOCK-END */
  690. &ANALYZE-RESUME
  691. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject vTableWin
  692. PROCEDURE enableObject :
  693. /*------------------------------------------------------------------------------
  694. Purpose: Super Override
  695. Parameters:
  696. Notes:
  697. ------------------------------------------------------------------------------*/
  698. DEF VAR cString AS CHAR NO-UNDO.
  699. hKontainer = DYNAMIC-FUNCTION('getContainerSource':U) NO-ERROR.
  700. hDaten = DYNAMIC-FUNCTION('getDataSource':U) NO-ERROR.
  701. DO WITH FRAME {&FRAME-NAME}:
  702. RUN COMBO_VERTRETER ( INPUT CB_Vertreter :HANDLE ).
  703. RUN COMBO_BIERGRP ( INPUT CB_Biergruppe :HANDLE ).
  704. RUN COMBO_WIRTESO ( INPUT CB_Wirtesonntag :HANDLE ).
  705. RUN COMBO_WARENGRUPPE ( INPUT CB_Warengruppe-1 :HANDLE ).
  706. RUN COMBO_WARENGRUPPE ( INPUT CB_Warengruppe-2 :HANDLE ).
  707. RUN COMBO_WARENGRUPPE ( INPUT CB_Warengruppe-3 :HANDLE ).
  708. RUN COMBO_WARENGRUPPE ( INPUT CB_Warengruppe-4 :HANDLE ).
  709. RUN COMBO_WARENGRUPPE ( INPUT CB_Warengruppe-5 :HANDLE ).
  710. cString = CB_Biergruppe:LIST-ITEM-PAIRS.
  711. cString = cString + ';Keine Zuteilung;000000'.
  712. CB_Biergruppe:LIST-ITEM-PAIRS = cString.
  713. cString = CB_Wirtesonntag:LIST-ITEM-PAIRS.
  714. cString = cString + ';Keine Zuteilung;000000'.
  715. CB_Wirtesonntag:LIST-ITEM-PAIRS = cString.
  716. cString = CB_Warengruppe-1:LIST-ITEM-PAIRS.
  717. cString = cString + ';Keine Zuteilung;000000'.
  718. CB_Warengruppe-1:LIST-ITEM-PAIRS = cString.
  719. cString = CB_Warengruppe-2:LIST-ITEM-PAIRS.
  720. cString = cString + ';Keine Zuteilung;000000'.
  721. CB_Warengruppe-2:LIST-ITEM-PAIRS = cString.
  722. cString = CB_Warengruppe-3:LIST-ITEM-PAIRS.
  723. cString = cString + ';Keine Zuteilung;000000'.
  724. CB_Warengruppe-3:LIST-ITEM-PAIRS = cString.
  725. cString = CB_Warengruppe-4:LIST-ITEM-PAIRS.
  726. cString = cString + ';Keine Zuteilung;000000'.
  727. CB_Warengruppe-4:LIST-ITEM-PAIRS = cString.
  728. cString = CB_Warengruppe-5:LIST-ITEM-PAIRS.
  729. cString = cString + ';Keine Zuteilung;000000'.
  730. CB_Warengruppe-5:LIST-ITEM-PAIRS = cString.
  731. END.
  732. RUN SUPER.
  733. IF NOT VALID-HANDLE(Fenster) THEN Fenster = FRAME {&FRAME-NAME}:CURRENT-ITERATION.
  734. IF SAktiv THEN DO:
  735. RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&ENABLED-FIELDS}', INPUT TRUE ).
  736. END.
  737. END PROCEDURE.
  738. /* _UIB-CODE-BLOCK-END */
  739. &ANALYZE-RESUME
  740. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_FELD_TEST vTableWin
  741. PROCEDURE ENTRY_FELD_TEST :
  742. /*------------------------------------------------------------------------------
  743. Purpose:
  744. Parameters: <none>
  745. Notes:
  746. ------------------------------------------------------------------------------*/
  747. DEF INPUT PARAMETER ipHandle AS HANDLE NO-UNDO.
  748. DEF VAR FeldName AS CHAR NO-UNDO.
  749. DEF VAR FeldInhalt AS CHAR NO-UNDO.
  750. FeldName = ''.
  751. FeldInhalt = ''.
  752. IF NOT VALID-HANDLE(ipHandle) THEN RETURN ''.
  753. IF ipHandle:TYPE = 'FRAME' THEN RETURN ''.
  754. IF ipHandle:TYPE = 'WINDOW' THEN RETURN ''.
  755. FeldName = ipHandle:NAME.
  756. IF ipHandle:TYPE = 'FILL-IN' OR
  757. ipHandle:TYPE = 'COMBO-BOX' OR
  758. ipHandle:TYPE = 'TOGGLE-BOX' THEN FeldInhalt = ipHandle:SCREEN-VALUE.
  759. IF NOT FMut THEN RETURN ''.
  760. DO WITH FRAME {&FRAME-NAME}:
  761. CASE FeldName:
  762. END CASE.
  763. END.
  764. RETURN ''.
  765. END PROCEDURE.
  766. /* _UIB-CODE-BLOCK-END */
  767. &ANALYZE-RESUME
  768. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE FEHLWERTE vTableWin
  769. PROCEDURE FEHLWERTE :
  770. /*------------------------------------------------------------------------------
  771. Purpose:
  772. Parameters: <none>
  773. Notes:
  774. ------------------------------------------------------------------------------*/
  775. DEF INPUT-OUTPUT PARAMETER pcColValues AS CHAR NO-UNDO.
  776. DEF VAR FwFelder AS CHAR NO-UNDO.
  777. DEF VAR FwFeld AS CHAR NO-UNDO.
  778. DEF VAR FwValue AS CHAR NO-UNDO.
  779. DEF VAR ix AS INT NO-UNDO.
  780. DEF VAR i1 AS INT NO-UNDO.
  781. GET-KEY-VALUE SECTION 'Fw???????' KEY ? VALUE FwFelder.
  782. IF NOT FCopy THEN DO:
  783. DO ix = 1 TO NUM-ENTRIES(FwFelder, ','):
  784. FwFeld = ENTRY (ix , FwFelder , ',').
  785. i1 = LOOKUP(FwFeld, oldColList, ',') + 1.
  786. IF i1 < 2 THEN NEXT.
  787. GET-KEY-VALUE SECTION 'Fw???????' KEY FwFeld VALUE FwValue.
  788. ENTRY(i1, pcColValues, CHR(1)) = FwValue NO-ERROR.
  789. END.
  790. END.
  791. IF FCopy THEN DO:
  792. END.
  793. OldColValues = pcColValues.
  794. END PROCEDURE.
  795. /* _UIB-CODE-BLOCK-END */
  796. &ANALYZE-RESUME
  797. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE LEAVE_FELD_TEST vTableWin
  798. PROCEDURE LEAVE_FELD_TEST :
  799. /*------------------------------------------------------------------------------
  800. Purpose:
  801. Parameters: <none>
  802. Notes:
  803. ------------------------------------------------------------------------------*/
  804. DEF INPUT PARAMETER ipHandle AS HANDLE NO-UNDO.
  805. DEF VAR FeldName AS CHAR NO-UNDO.
  806. DEF VAR FeldInhalt AS CHAR NO-UNDO.
  807. DEF VAR ix AS INT NO-UNDO.
  808. DEF VAR LKY AS INT NO-UNDO.
  809. DEF VAR hLEAVE AS HANDLE NO-UNDO.
  810. DEF VAR hENTER AS HANDLE NO-UNDO.
  811. DEF VAR Daten AS CHAR NO-UNDO.
  812. IF FMut = FALSE THEN RETURN ''.
  813. LKY = LASTKEY.
  814. hENTER = LAST-EVENT:WIDGET-ENTER.
  815. hLEAVE = LAST-EVENT:WIDGET-LEAVE.
  816. FeldName = ''.
  817. FeldInhalt = ''.
  818. IF NOT VALID-HANDLE(ipHandle) THEN RETURN ''.
  819. IF ipHandle:TYPE = 'FRAME' THEN RETURN ''.
  820. IF ipHandle:TYPE = 'WINDOW' THEN RETURN ''.
  821. FeldName = ipHandle:NAME.
  822. IF ipHandle:TYPE = 'FILL-IN' OR
  823. ipHandle:TYPE = 'COMBO-BOX' OR
  824. ipHandle:TYPE = 'TOGGLE-BOX' THEN FeldInhalt = ipHandle:SCREEN-VALUE.
  825. DO WHILE FNeu:
  826. CASE FeldName:
  827. END CASE.
  828. LEAVE.
  829. END.
  830. IF LOOKUP(FeldName, '{&LETZTES_FELD}', ',') > 0 THEN DO:
  831. DO WHILE TRUE:
  832. IF KEYFUNCTION(LKY) = 'TAB' THEN LEAVE.
  833. IF KEYFUNCTION(LKY) = 'RETURN' THEN LEAVE.
  834. IF KEYFUNCTION(LKY) = 'F9' THEN LEAVE.
  835. RETURN ''.
  836. END.
  837. APPLY 'ALT-S'.
  838. RETURN 'APPLY'.
  839. END.
  840. RETURN ''.
  841. END PROCEDURE.
  842. /* _UIB-CODE-BLOCK-END */
  843. &ANALYZE-RESUME
  844. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE LESENFEHLWERTE vTableWin
  845. PROCEDURE LESENFEHLWERTE :
  846. /*------------------------------------------------------------------------------
  847. Purpose:
  848. Parameters: <none>
  849. Notes:
  850. ------------------------------------------------------------------------------*/
  851. DEF VAR cValue AS CHAR NO-UNDO.
  852. DEF VAR ii AS INT NO-UNDO.
  853. GET-KEY-VALUE SECTION 'Kundenbesuche'
  854. KEY 'Fehlwerte'
  855. VALUE cValue.
  856. IF cValue = ? THEN RETURN.
  857. DO ii = 1 TO NUM-ENTRIES(cValue, ';') WITH FRAME {&FRAME-NAME}:
  858. CASE ii:
  859. WHEN 1 THEN CB_Warengruppe-1:SCREEN-VALUE = STRING(INTEGER(ENTRY(ii, cValue, ';')),'999999') NO-ERROR.
  860. WHEN 2 THEN CB_Warengruppe-2:SCREEN-VALUE = STRING(INTEGER(ENTRY(ii, cValue, ';')),'999999') NO-ERROR.
  861. WHEN 3 THEN CB_Warengruppe-3:SCREEN-VALUE = STRING(INTEGER(ENTRY(ii, cValue, ';')),'999999') NO-ERROR.
  862. WHEN 4 THEN CB_Warengruppe-4:SCREEN-VALUE = STRING(INTEGER(ENTRY(ii, cValue, ';')),'999999') NO-ERROR.
  863. WHEN 5 THEN CB_Warengruppe-5:SCREEN-VALUE = STRING(INTEGER(ENTRY(ii, cValue, ';')),'999999') NO-ERROR.
  864. END CASE.
  865. END.
  866. END PROCEDURE.
  867. /* _UIB-CODE-BLOCK-END */
  868. &ANALYZE-RESUME
  869. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE RETURN_FELD vTableWin
  870. PROCEDURE RETURN_FELD :
  871. /*------------------------------------------------------------------------------
  872. Purpose:
  873. Parameters: <none>
  874. Notes:
  875. ------------------------------------------------------------------------------*/
  876. DEF INPUT PARAMETER ipHandle AS HANDLE NO-UNDO.
  877. DEF VAR FeldName AS CHAR NO-UNDO.
  878. IF FMut = FALSE THEN RETURN ''.
  879. IF NOT VALID-HANDLE(ipHandle) THEN RETURN ''.
  880. IF ipHandle:TYPE = 'FRAME' THEN RETURN ''.
  881. IF ipHandle:TYPE = 'WINDOW' THEN RETURN ''.
  882. FeldName = ipHandle:NAME.
  883. IF LOOKUP(FeldName, '{&ENABLED-FIELDS}', ' ') > 0 THEN DO:
  884. RETURN 'TAB'.
  885. END.
  886. IF LOOKUP(FeldName, '{&ENABLED-OBJECTS}', ' ') > 0 THEN DO:
  887. RETURN 'TAB'.
  888. END.
  889. FeldName = 'rowObject.' + FeldName.
  890. IF LOOKUP(FeldName, '{&ENABLED-FIELDS}', ' ') > 0 THEN DO:
  891. RETURN 'TAB'.
  892. END.
  893. IF LOOKUP(FeldName, '{&ENABLED-OBJECTS}', ' ') > 0 THEN DO:
  894. RETURN 'TAB'.
  895. END.
  896. RETURN ''.
  897. END PROCEDURE.
  898. /* _UIB-CODE-BLOCK-END */
  899. &ANALYZE-RESUME
  900. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SCHREIBENFEHLWERTE vTableWin
  901. PROCEDURE SCHREIBENFEHLWERTE :
  902. /*------------------------------------------------------------------------------
  903. Purpose:
  904. Parameters: <none>
  905. Notes:
  906. ------------------------------------------------------------------------------*/
  907. DEF VAR cValue AS CHAR NO-UNDO.
  908. DO WITH FRAME {&FRAME-NAME}:
  909. cValue = CB_Warengruppe-1:SCREEN-VALUE + ';'
  910. + CB_Warengruppe-2:SCREEN-VALUE + ';'
  911. + CB_Warengruppe-3:SCREEN-VALUE + ';'
  912. + CB_Warengruppe-4:SCREEN-VALUE + ';'
  913. + CB_Warengruppe-5:SCREEN-VALUE.
  914. END.
  915. PUT-KEY-VALUE SECTION 'Kundenbesuche'
  916. KEY 'Fehlwerte'
  917. VALUE cValue.
  918. END PROCEDURE.
  919. /* _UIB-CODE-BLOCK-END */
  920. &ANALYZE-RESUME
  921. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE updateMode vTableWin
  922. PROCEDURE updateMode :
  923. /*------------------------------------------------------------------------------
  924. Purpose: Super Override
  925. Parameters:
  926. Notes:
  927. ------------------------------------------------------------------------------*/
  928. DEFINE INPUT PARAMETER pcMode AS CHARACTER NO-UNDO.
  929. CASE pcMode:
  930. WHEN 'updateBegin' THEN DO:
  931. END.
  932. WHEN 'updateEnd' THEN DO:
  933. END.
  934. END.
  935. RUN SUPER( INPUT pcMode).
  936. DO WITH FRAME {&FRAME-NAME}:
  937. CASE pcMode:
  938. WHEN 'updateBegin' THEN DO:
  939. FMut = TRUE.
  940. Btn_Update:SENSITIVE = FALSE.
  941. Btn_Save :SENSITIVE = TRUE .
  942. Btn_Cancel:SENSITIVE = TRUE .
  943. END.
  944. WHEN 'updateEnd' THEN DO:
  945. Btn_Update:SENSITIVE = TRUE .
  946. Btn_Save :SENSITIVE = FALSE.
  947. Btn_Cancel:SENSITIVE = FALSE.
  948. DYNAMIC-FUNCTION('setTableIOLink':U IN hKontainer, cvKuBes ).
  949. FNeu = FALSE.
  950. FMut = FALSE.
  951. FCopy = FALSE.
  952. END.
  953. END.
  954. END.
  955. END PROCEDURE.
  956. /* _UIB-CODE-BLOCK-END */
  957. &ANALYZE-RESUME
  958. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE updateRecord vTableWin
  959. PROCEDURE updateRecord :
  960. /*------------------------------------------------------------------------------
  961. Purpose: Super Override
  962. Parameters:
  963. Notes:
  964. ------------------------------------------------------------------------------*/
  965. FIND FIRST WDebst NO-LOCK NO-ERROR.
  966. DO WITH FRAME {&FRAME-NAME}:
  967. rowObject.FremdWgr1:SCREEN-VALUE = CB_Warengruppe-1:SCREEN-VALUE.
  968. rowObject.FremdWgr2:SCREEN-VALUE = CB_Warengruppe-2:SCREEN-VALUE.
  969. rowObject.FremdWgr3:SCREEN-VALUE = CB_Warengruppe-3:SCREEN-VALUE.
  970. rowObject.FremdWgr4:SCREEN-VALUE = CB_Warengruppe-4:SCREEN-VALUE.
  971. rowObject.FremdWgr5:SCREEN-VALUE = CB_Warengruppe-5:SCREEN-VALUE.
  972. WDebst.Vertr = INTEGER(CB_Vertreter :SCREEN-VALUE).
  973. WDebst.Bier_Cd = INTEGER(CB_Biergruppe :SCREEN-VALUE).
  974. WDebst.Wirt_So = INTEGER(CB_Wirtesonntag:SCREEN-VALUE).
  975. END.
  976. REPEAT TRANSACTION:
  977. IF WDebst.Knr = 0 THEN LEAVE.
  978. IF fVertr = FALSE AND
  979. fBier = FALSE AND
  980. fWiSo = FALSE THEN LEAVE.
  981. FOR EACH Debst USE-INDEX Debst-k2
  982. WHERE Debst.Knr = Knr :
  983. IF fVertr THEN Debst.Vertr = WDebst.Vertr.
  984. IF fBier THEN Debst.Bier_Cd = WDebst.Bier_Cd.
  985. IF fWiSo THEN Debst.Wirt_So = WDebst.Wirt_So.
  986. END.
  987. RELEASE Debst.
  988. LEAVE.
  989. END.
  990. FNeu = FALSE.
  991. FCopy = FALSE.
  992. fVertr = FALSE.
  993. fBier = FALSE.
  994. fWiSo = FALSE.
  995. RUN SUPER.
  996. END PROCEDURE.
  997. /* _UIB-CODE-BLOCK-END */
  998. &ANALYZE-RESUME