w-tabellen.w 31 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947
  1. &ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
  2. &ANALYZE-RESUME
  3. &Scoped-define WINDOW-NAME wTabellen
  4. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS wTabellen
  5. /*------------------------------------------------------------------------
  6. File:
  7. Description: from cntnrwin.w - ADM SmartWindow Template
  8. Input Parameters:
  9. <none>
  10. Output Parameters:
  11. <none>
  12. History: New V9 Version - January 15, 1998
  13. ------------------------------------------------------------------------*/
  14. /* This .W file was created with the Progress AB. */
  15. /*----------------------------------------------------------------------*/
  16. /* Create an unnamed pool to store all the widgets created
  17. by this procedure. This is a good default which assures
  18. that this procedure's triggers and internal procedures
  19. will execute in this procedure's storage, and that proper
  20. cleanup will occur on deletion of the procedure. */
  21. CREATE WIDGET-POOL.
  22. /* *************************** Definitions ************************** */
  23. /* Parameters Definitions --- */
  24. /* Local Variable Definitions --- */
  25. DEF VAR MaxPage AS INT NO-UNDO.
  26. DEF VAR AktSeite AS INT NO-UNDO.
  27. DEF VAR Fenster AS HANDLE NO-UNDO.
  28. DEF VAR FMutFlag AS LOG NO-UNDO INIT FALSE.
  29. DEF VAR SAktiv AS LOG NO-UNDO INIT FALSE.
  30. DEF VAR Firma AS CHAR NO-UNDO.
  31. DEF VAR Sprcd AS INT NO-UNDO INIT 1.
  32. DEF VAR RecArt AS CHAR NO-UNDO.
  33. DEF VAR Art AS INT NO-UNDO INIT 1.
  34. DEF VAR cParam AS CHAR NO-UNDO.
  35. /* _UIB-CODE-BLOCK-END */
  36. &ANALYZE-RESUME
  37. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  38. /* ******************** Preprocessor Definitions ******************** */
  39. &Scoped-define PROCEDURE-TYPE SmartWindow
  40. &Scoped-define DB-AWARE no
  41. &Scoped-define ADM-CONTAINER WINDOW
  42. &Scoped-define ADM-SUPPORTED-LINKS Data-Target,Data-Source,Page-Target,Update-Source,Update-Target,Filter-target,Filter-Source
  43. /* Name of designated FRAME-NAME and/or first browse and/or first query */
  44. &Scoped-define FRAME-NAME fMain
  45. /* Custom List Definitions */
  46. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  47. /* _UIB-PREPROCESSOR-BLOCK-END */
  48. &ANALYZE-RESUME
  49. /* *********************** Control Definitions ********************** */
  50. /* Define the widget handle for the window */
  51. DEFINE VAR wTabellen AS WIDGET-HANDLE NO-UNDO.
  52. /* Definitions of handles for SmartObjects */
  53. DEFINE VARIABLE h_b-tabel AS HANDLE NO-UNDO.
  54. DEFINE VARIABLE h_d-tabel AS HANDLE NO-UNDO.
  55. DEFINE VARIABLE h_dyntoolbar AS HANDLE NO-UNDO.
  56. DEFINE VARIABLE h_v-tabel AS HANDLE NO-UNDO.
  57. /* ************************ Frame Definitions *********************** */
  58. DEFINE FRAME fMain
  59. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
  60. SIDE-LABELS NO-UNDERLINE THREE-D
  61. AT COL 1 ROW 1
  62. SIZE 113.6 BY 15.71.
  63. /* *********************** Procedure Settings ************************ */
  64. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  65. /* Settings for THIS-PROCEDURE
  66. Type: SmartWindow
  67. Allow: Basic,Browse,DB-Fields,Query,Smart,Window
  68. Container Links: Data-Target,Data-Source,Page-Target,Update-Source,Update-Target,Filter-target,Filter-Source
  69. Design Page: 1
  70. Other Settings: COMPILE
  71. */
  72. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  73. /* ************************* Create Window ************************** */
  74. &ANALYZE-SUSPEND _CREATE-WINDOW
  75. IF SESSION:DISPLAY-TYPE = "GUI":U THEN
  76. CREATE WINDOW wTabellen ASSIGN
  77. HIDDEN = YES
  78. TITLE = "Tabellen"
  79. HEIGHT = 15.71
  80. WIDTH = 113.6
  81. MAX-HEIGHT = 46.52
  82. MAX-WIDTH = 256
  83. VIRTUAL-HEIGHT = 46.52
  84. VIRTUAL-WIDTH = 256
  85. RESIZE = NO
  86. SCROLL-BARS = NO
  87. STATUS-AREA = NO
  88. BGCOLOR = ?
  89. FGCOLOR = ?
  90. THREE-D = YES
  91. MESSAGE-AREA = NO
  92. SENSITIVE = YES.
  93. ELSE {&WINDOW-NAME} = CURRENT-WINDOW.
  94. /* END WINDOW DEFINITION */
  95. &ANALYZE-RESUME
  96. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB wTabellen
  97. /* ************************* Included-Libraries *********************** */
  98. {src/adm2/containr.i}
  99. /* _UIB-CODE-BLOCK-END */
  100. &ANALYZE-RESUME
  101. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  102. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  103. /* SETTINGS FOR WINDOW wTabellen
  104. VISIBLE,,RUN-PERSISTENT */
  105. /* SETTINGS FOR FRAME fMain
  106. FRAME-NAME */
  107. IF SESSION:DISPLAY-TYPE = "GUI":U AND VALID-HANDLE(wTabellen)
  108. THEN wTabellen:HIDDEN = YES.
  109. /* _RUN-TIME-ATTRIBUTES-END */
  110. &ANALYZE-RESUME
  111. /* ************************ Control Triggers ************************ */
  112. &Scoped-define SELF-NAME wTabellen
  113. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL wTabellen wTabellen
  114. ON END-ERROR OF wTabellen /* Tabellen */
  115. OR ENDKEY OF {&WINDOW-NAME} ANYWHERE DO:
  116. IF THIS-PROCEDURE:PERSISTENT THEN RETURN NO-APPLY.
  117. RUN ENDE.
  118. RETURN NO-APPLY.
  119. END.
  120. /* _UIB-CODE-BLOCK-END */
  121. &ANALYZE-RESUME
  122. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL wTabellen wTabellen
  123. ON WINDOW-CLOSE OF wTabellen /* Tabellen */
  124. DO:
  125. RUN ENDE.
  126. RETURN NO-APPLY.
  127. END.
  128. /* _UIB-CODE-BLOCK-END */
  129. &ANALYZE-RESUME
  130. &UNDEFINE SELF-NAME
  131. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK wTabellen
  132. /* *************************** Main Block *************************** */
  133. MaxPage = 1.
  134. AktSeite = 1.
  135. SAktiv = DYNAMIC-FUNCTION('getSuperAktiv':U) NO-ERROR.
  136. IF SAktiv THEN DO:
  137. Firma = DYNAMIC-FUNCTION('GETMANDANT':U) NO-ERROR.
  138. RecArt = DYNAMIC-FUNCTION('GETTABELLE':U) NO-ERROR.
  139. RUN CREATE_PARAMETER.
  140. END.
  141. SESSION:DATA-ENTRY-RETURN = TRUE.
  142. SUBSCRIBE TO 'TOOLBAR' ANYWHERE.
  143. /* TRIGGERS ------------------------------------------------------ */
  144. ON 'ALT-CURSOR-RIGHT':U OF {&WINDOW-NAME} ANYWHERE
  145. DO:
  146. RUN NEXTPAGE.
  147. END.
  148. ON 'ALT-CURSOR-LEFT':U OF {&WINDOW-NAME} ANYWHERE
  149. DO:
  150. RUN PREVPAGE.
  151. END.
  152. ON 'U1':U OF {&WINDOW-NAME} ANYWHERE
  153. DO:
  154. RUN ENTRY_CURSOR.
  155. END.
  156. ON 'PAGE-DOWN':U OF {&WINDOW-NAME} ANYWHERE
  157. DO:
  158. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'Next':U ).
  159. RETURN NO-APPLY.
  160. END.
  161. ON 'PAGE-UP':U OF {&WINDOW-NAME} ANYWHERE
  162. DO:
  163. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'Prev':U ).
  164. RETURN NO-APPLY.
  165. END.
  166. ON 'ALT-RETURN':U OF {&WINDOW-NAME} ANYWHERE
  167. DO:
  168. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'UPDATE':U ).
  169. END.
  170. ON 'ALT-INS':U OF {&WINDOW-NAME} ANYWHERE
  171. DO:
  172. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'ADD':U ).
  173. END.
  174. ON 'ALT-DEL':U OF {&WINDOW-NAME} ANYWHERE
  175. DO:
  176. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'DELETE':U ).
  177. END.
  178. ON 'ALT-R':U OF {&WINDOW-NAME} ANYWHERE
  179. DO:
  180. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'RESET':U ).
  181. END.
  182. ON 'F9':U OF {&WINDOW-NAME} ANYWHERE
  183. DO:
  184. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'SAVE':U ).
  185. END.
  186. ON 'ALT-S':U OF {&WINDOW-NAME} ANYWHERE
  187. DO:
  188. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'SAVE':U ).
  189. END.
  190. ON 'ALT-K':U OF {&WINDOW-NAME} ANYWHERE
  191. DO:
  192. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'COPY':U ).
  193. END.
  194. ON 'END-ERROR':U OF {&WINDOW-NAME} ANYWHERE
  195. DO:
  196. FMutFlag = DYNAMIC-FUNCTION('getMutflagAlt':U) NO-ERROR.
  197. IF FMutFlag = FALSE THEN DO:
  198. RUN ENDE.
  199. RETURN NO-APPLY.
  200. END.
  201. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'CANCEL':U ).
  202. RETURN NO-APPLY.
  203. END.
  204. /* Include custom Main Block code for SmartWindows. */
  205. {src/adm2/windowmn.i}
  206. /* _UIB-CODE-BLOCK-END */
  207. &ANALYZE-RESUME
  208. /* ********************** Internal Procedures *********************** */
  209. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects wTabellen _ADM-CREATE-OBJECTS
  210. PROCEDURE adm-create-objects :
  211. /*------------------------------------------------------------------------------
  212. Purpose: Create handles for all SmartObjects used in this procedure.
  213. After SmartObjects are initialized, then SmartLinks are added.
  214. Parameters: <none>
  215. ------------------------------------------------------------------------------*/
  216. DEFINE VARIABLE currentPage AS INTEGER NO-UNDO.
  217. ASSIGN currentPage = getCurrentPage().
  218. CASE currentPage:
  219. WHEN 0 THEN DO:
  220. RUN constructObject (
  221. INPUT 'd-tabel.wDB-AWARE':U ,
  222. INPUT FRAME fMain:HANDLE ,
  223. INPUT 'AppServiceASInfoASUsePrompt?CacheDuration0CheckCurrentChangedyesDestroyStatelessnoDisconnectAppServernoServerOperatingModeNONEShareDatanoUpdateFromSourcenoForeignFieldsObjectNamed-tabelOpenOnInityesPromptColumns(NONE)PromptOnDeletenoRowsToBatch20RebuildOnReposyesToggleDataTargetsyes':U ,
  224. OUTPUT h_d-tabel ).
  225. RUN repositionObject IN h_d-tabel ( 3.29 , 16.60 ) NO-ERROR.
  226. /* Size in AB: ( 4.10 , 16.00 ) */
  227. RUN constructObject (
  228. INPUT 'src_dlcv91c/adm2/dyntoolbar.w':U ,
  229. INPUT FRAME fMain:HANDLE ,
  230. INPUT 'EdgePixels2DeactivateTargetOnHidenoDisabledActionsFlatButtonsyesMenunoShowBorderyesToolbaryesActionGroupsTableio,NavigationTableIOTypeUpdateSupportedLinksNavigation-source,Tableio-sourceToolbarBandsToolbarAutoSizenoToolbarDrawDirectionhorizontalLogicalObjectNameDisabledActionsHiddenActionsResetHiddenToolbarBandsHiddenMenuBandsMenuMergeOrder0RemoveMenuOnHidenoCreateSubMenuOnConflictyesNavigationTargetNameHideOnInitnoDisableOnInitnoObjectLayout':U ,
  231. OUTPUT h_dyntoolbar ).
  232. RUN repositionObject IN h_dyntoolbar ( 1.00 , 2.00 ) NO-ERROR.
  233. RUN resizeObject IN h_dyntoolbar ( 1.33 , 56.40 ) NO-ERROR.
  234. /* Links to SmartDataObject h_d-tabel. */
  235. RUN addLink ( h_dyntoolbar , 'Navigation':U , h_d-tabel ).
  236. END. /* Page 0 */
  237. WHEN 1 THEN DO:
  238. RUN constructObject (
  239. INPUT 'b-tabel.w':U ,
  240. INPUT FRAME fMain:HANDLE ,
  241. INPUT 'ScrollRemotenoNumDown0CalcWidthnoMaxWidth80FetchOnReposToEndyesUseSortIndicatoryesSearchFieldDataSourceNamesUpdateTargetNamesLogicalObjectNameHideOnInitnoDisableOnInitnoObjectLayout':U ,
  242. OUTPUT h_b-tabel ).
  243. RUN repositionObject IN h_b-tabel ( 2.43 , 1.00 ) NO-ERROR.
  244. RUN resizeObject IN h_b-tabel ( 7.52 , 112.00 ) NO-ERROR.
  245. RUN constructObject (
  246. INPUT 'v-tabel.w':U ,
  247. INPUT FRAME fMain:HANDLE ,
  248. INPUT 'EnabledObjFldsToDisable?ModifyFields(All)DataSourceNamesUpdateTargetNamesLogicalObjectNameLogicalObjectNamePhysicalObjectNameDynamicObjectnoRunAttributeHideOnInitnoDisableOnInitnoObjectLayout':U ,
  249. OUTPUT h_v-tabel ).
  250. RUN repositionObject IN h_v-tabel ( 10.24 , 1.00 ) NO-ERROR.
  251. /* Size in AB: ( 6.00 , 111.00 ) */
  252. /* Links to SmartDataBrowser h_b-tabel. */
  253. RUN addLink ( h_d-tabel , 'Data':U , h_b-tabel ).
  254. /* Links to SmartDataViewer h_v-tabel. */
  255. RUN addLink ( h_d-tabel , 'Data':U , h_v-tabel ).
  256. RUN addLink ( h_v-tabel , 'Update':U , h_d-tabel ).
  257. RUN addLink ( h_dyntoolbar , 'TableIO':U , h_v-tabel ).
  258. /* Adjust the tab order of the smart objects. */
  259. RUN adjustTabOrder ( h_b-tabel ,
  260. h_dyntoolbar , 'AFTER':U ).
  261. RUN adjustTabOrder ( h_v-tabel ,
  262. h_d-tabel , 'AFTER':U ).
  263. END. /* Page 1 */
  264. END CASE.
  265. /* Select a Startup page. */
  266. IF currentPage EQ 0
  267. THEN RUN selectPage IN THIS-PROCEDURE ( 1 ).
  268. END PROCEDURE.
  269. /* _UIB-CODE-BLOCK-END */
  270. &ANALYZE-RESUME
  271. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE changePage wTabellen
  272. PROCEDURE changePage :
  273. /*------------------------------------------------------------------------------
  274. Purpose: Super Override
  275. Parameters:
  276. Notes:
  277. ------------------------------------------------------------------------------*/
  278. RUN SUPER.
  279. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
  280. CASE AktSeite:
  281. WHEN 1 THEN DO:
  282. /* RUN addLink ( h_dyntoolbar , 'TableIO':U , h_v-auftr ). */
  283. /* RUN addLink ( h_dyntoolbar , 'Navigation':U , h_d-auftr ). */
  284. /* RUN ToolbarInit ( INPUT h_d-auftr ). */
  285. RUN ENTRY_CURSOR.
  286. END.
  287. WHEN 2 THEN DO:
  288. RUN ENTRY_CURSOR.
  289. END.
  290. END CASE.
  291. END PROCEDURE.
  292. /* _UIB-CODE-BLOCK-END */
  293. &ANALYZE-RESUME
  294. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE CREATE_PARAMETER wTabellen
  295. PROCEDURE CREATE_PARAMETER :
  296. /*------------------------------------------------------------------------------
  297. Purpose:
  298. Parameters: <none>
  299. Notes:
  300. ------------------------------------------------------------------------------*/
  301. /* Parameter Feldname, Label, Format; ....... */
  302. /* Art = 1 (CodeI) */
  303. /* Art = 2 (CodeC) */
  304. CASE RecArt:
  305. WHEN 'VERTR' THEN DO:
  306. Sprcd = 1.
  307. Art = 1.
  308. cParam = 'CodeI,Code,999;'
  309. + 'Bez1,Vertreter;'
  310. + 'Bez2,Zusatz;'
  311. + 'Int_1,Lager,z99;'
  312. + 'Dec_1,P-Spesen,zz9.99;'
  313. + 'Dec_2,Z-Spesen,zz9.99;'.
  314. {&WINDOW-NAME}:TITLE = 'Vertreter'.
  315. END.
  316. WHEN 'KUNDGRP' THEN DO:
  317. Sprcd = 1.
  318. Art = 1.
  319. cParam = 'CodeI,Code,999;'
  320. + 'Bez1,Bezeichnung;'
  321. + 'Int_1,Preisgruppe,zz9'.
  322. {&WINDOW-NAME}:TITLE = 'Kundengruppen'.
  323. END.
  324. WHEN 'PREGRP' THEN DO:
  325. Sprcd = 1.
  326. Art = 1.
  327. cParam = 'CodeI,Code,999;'
  328. + 'Bez1,Bezeichnung;'
  329. + 'Int_1,Netto(0)/Brutto(1),z9;'
  330. + 'Int_2,Aktiv(1)/Inaktiv(0),z9'.
  331. {&WINDOW-NAME}:TITLE = 'Preisgruppen'.
  332. END.
  333. WHEN 'BONUS' THEN DO:
  334. Sprcd = 1.
  335. Art = 1.
  336. cParam = 'CodeI,Code,999;'
  337. + 'Bez1,Bezeichnung'.
  338. {&WINDOW-NAME}:TITLE = 'Bonusgruppen'.
  339. END.
  340. WHEN 'RABGRP' THEN DO:
  341. Sprcd = 1.
  342. Art = 1.
  343. cParam = 'CodeI,Code,999;'
  344. + 'Bez1,Bezeichnung'.
  345. {&WINDOW-NAME}:TITLE = 'Rabattgruppen'.
  346. END.
  347. WHEN 'ABCGRP' THEN DO:
  348. Sprcd = 1.
  349. Art = 1.
  350. cParam = 'CodeI,Code,999;'
  351. + 'Bez1,Bezeichnung'.
  352. {&WINDOW-NAME}:TITLE = 'ABC-Gruppen'.
  353. END.
  354. WHEN 'FAKART' THEN DO:
  355. Sprcd = 1.
  356. Art = 1.
  357. cParam = 'CodeI,Code,999;'
  358. + 'Bez1,Bezeichnung'.
  359. {&WINDOW-NAME}:TITLE = 'Fakturaarten'.
  360. END.
  361. WHEN 'BIER' THEN DO:
  362. Sprcd = 1.
  363. Art = 1.
  364. cParam = 'CodeI,Code,999;'
  365. + 'Bez1,Bezeichnung'.
  366. {&WINDOW-NAME}:TITLE = 'Biergruppen-/Verträge'.
  367. END.
  368. WHEN 'LAGER' THEN DO:
  369. Sprcd = 1.
  370. Art = 1.
  371. cParam = 'CodeI,Lager,99;'
  372. + 'Bez1,Bezeichnung'.
  373. {&WINDOW-NAME}:TITLE = 'Lager'.
  374. END.
  375. WHEN 'LAGERART' THEN DO:
  376. Sprcd = 1.
  377. Art = 1.
  378. cParam = 'CodeI,Lager,99;'
  379. + 'Bez1,Bezeichnung'.
  380. {&WINDOW-NAME}:TITLE = 'Lagerarten'.
  381. END.
  382. WHEN 'AVIS' THEN DO:
  383. Sprcd = 1.
  384. Art = 1.
  385. cParam = 'CodeI,Code,999;'
  386. + 'Bez1,Bezeichnung'.
  387. {&WINDOW-NAME}:TITLE = 'AVIS-Arten'.
  388. END.
  389. WHEN 'LIEFBED' THEN DO:
  390. Sprcd = 1.
  391. Art = 1.
  392. cParam = 'CodeI,Code,999;'
  393. + 'Bez1,Bezeichnung'.
  394. {&WINDOW-NAME}:TITLE = 'Lieferbedingungen'.
  395. END.
  396. WHEN 'WISO' THEN DO:
  397. Sprcd = 1.
  398. Art = 1.
  399. cParam = 'CodeI,Code,999;'
  400. + 'Bez1,Bezeichnung'.
  401. {&WINDOW-NAME}:TITLE = 'Wirtesonntage'.
  402. END.
  403. WHEN 'ABLAD' THEN DO:
  404. Sprcd = 1.
  405. Art = 1.
  406. cParam = 'CodeI,Code,999;'
  407. + 'Bez1,Bezeichnung'.
  408. {&WINDOW-NAME}:TITLE = 'Abladevorschriften'.
  409. END.
  410. WHEN 'TOUR1' THEN DO:
  411. Sprcd = 1.
  412. Art = 1.
  413. cParam = 'CodeI,Code,999;'
  414. + 'Bez1,Bezeichnung'.
  415. {&WINDOW-NAME}:TITLE = 'Tourenpläne'.
  416. END.
  417. WHEN 'ABONUS' THEN DO:
  418. Sprcd = 1.
  419. Art = 1.
  420. cParam = 'CodeI,Code,999;'
  421. + 'Bez1,Bezeichnung'.
  422. {&WINDOW-NAME}:TITLE = 'Bonusgruppen'.
  423. END.
  424. WHEN 'ARABGRP' THEN DO:
  425. Sprcd = 1.
  426. Art = 1.
  427. cParam = 'CodeI,Code,999;'
  428. + 'Bez1,Bezeichnung'.
  429. {&WINDOW-NAME}:TITLE = 'Rabattgruppen'.
  430. END.
  431. WHEN 'AREG' THEN DO:
  432. Sprcd = 1.
  433. Art = 1.
  434. cParam = 'CodeI,Code,999;'
  435. + 'Bez1,Bezeichnung'.
  436. {&WINDOW-NAME}:TITLE = 'Regionen'.
  437. END.
  438. WHEN 'TRAUB' THEN DO:
  439. Sprcd = 1.
  440. Art = 1.
  441. cParam = 'CodeI,Code,999;'
  442. + 'Bez1,Bezeichnung'.
  443. {&WINDOW-NAME}:TITLE = 'Traubensorten'.
  444. END.
  445. WHEN 'FARB' THEN DO:
  446. Sprcd = 1.
  447. Art = 1.
  448. cParam = 'CodeI,Code,999;'
  449. + 'Bez1,Bezeichnung'.
  450. {&WINDOW-NAME}:TITLE = 'Weinfarben'.
  451. END.
  452. WHEN 'HERST' THEN DO:
  453. Sprcd = 1.
  454. Art = 1.
  455. cParam = 'CodeI,Code,999;'
  456. + 'Bez1,Bezeichnung;'
  457. + 'Bez2,GLN'.
  458. {&WINDOW-NAME}:TITLE = 'Hersteller'.
  459. END.
  460. WHEN 'UMSGRP' THEN DO:
  461. Sprcd = 1.
  462. Art = 1.
  463. cParam = 'CodeI,Code,999;'
  464. + 'Bez1,Bezeichnung'.
  465. {&WINDOW-NAME}:TITLE = 'Umsatzgruppen'.
  466. END.
  467. WHEN 'LAGKORR' THEN DO:
  468. Sprcd = 1.
  469. Art = 1.
  470. cParam = 'CodeI,Code,999;'
  471. + 'Bez1,Bezeichnung;Int_1,Faktor,-9'.
  472. {&WINDOW-NAME}:TITLE = 'Lagertransaktionen'.
  473. END.
  474. WHEN 'LKW' THEN DO:
  475. Sprcd = 1.
  476. Art = 1.
  477. cParam = 'CodeI,Code,999;'
  478. + 'Bez1,Bezeichnung'.
  479. {&WINDOW-NAME}:TITLE = 'LKW/Fahrzeuge'.
  480. END.
  481. WHEN 'LIEFART' THEN DO:
  482. Sprcd = 1.
  483. Art = 1.
  484. cParam = 'CodeI,Cd,999;'
  485. + 'Bez1,Bezeichnung'.
  486. {&WINDOW-NAME}:TITLE = 'Lieferart'.
  487. END.
  488. WHEN 'ZAHART' THEN DO:
  489. Sprcd = 1.
  490. Art = 1.
  491. cParam = 'CodeI,Code,999;'
  492. + 'Bez1,Zahlungsart;Bez2,Konto,x(12)'.
  493. {&WINDOW-NAME}:TITLE = 'Zahlungsarten'.
  494. END.
  495. WHEN 'IBEST' THEN DO:
  496. Sprcd = 1.
  497. Art = 2.
  498. cParam = 'CodeC,Code,x(08);'
  499. + 'Bez1,Ihre Bestellung'.
  500. {&WINDOW-NAME}:TITLE = 'Ihre Bestellung'.
  501. END.
  502. WHEN 'BEIFAHR' THEN DO:
  503. Sprcd = 1.
  504. Art = 1.
  505. cParam = 'CodeI,Code,999;'
  506. + 'Bez1,Beifahrer;Bez2,Zusatz'.
  507. {&WINDOW-NAME}:TITLE = 'Beifahrer'.
  508. END.
  509. WHEN 'FAHRER' THEN DO:
  510. Sprcd = 1.
  511. Art = 1.
  512. cParam = 'CodeI,Code,999;'
  513. + 'Bez1,Fahrer;Bez2,Fahrzeug'.
  514. {&WINDOW-NAME}:TITLE = 'Fahrer'.
  515. END.
  516. WHEN 'BESUCH' THEN DO:
  517. Sprcd = 1.
  518. Art = 2.
  519. cParam = 'CodeC,Code,x(04);'
  520. + 'Bez1,Besuchsart;'
  521. + 'Int_1,Besuch ?,zz9'.
  522. {&WINDOW-NAME}:TITLE = 'Besuchsart'.
  523. END.
  524. WHEN 'VERBAND' THEN DO:
  525. Sprcd = 1.
  526. Art = 1.
  527. cParam = 'CodeI,Code,999;'
  528. + 'Bez1,Verband'.
  529. {&WINDOW-NAME}:TITLE = 'Verbandsgruppen'.
  530. END.
  531. WHEN 'BESTAT' THEN DO:
  532. Sprcd = 1.
  533. Art = 1.
  534. cParam = 'CodeI,Code,999;'
  535. + 'Bez1,Bestellstatus'.
  536. {&WINDOW-NAME}:TITLE = 'Bestellstatus'.
  537. END.
  538. WHEN 'STYLE' THEN DO:
  539. Sprcd = 1.
  540. Art = 1.
  541. cParam = 'CodeI,Code,999;'
  542. + 'Bez1,Weinstyle'.
  543. {&WINDOW-NAME}:TITLE = 'Style'.
  544. END.
  545. END CASE.
  546. END PROCEDURE.
  547. /* _UIB-CODE-BLOCK-END */
  548. &ANALYZE-RESUME
  549. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI wTabellen _DEFAULT-DISABLE
  550. PROCEDURE disable_UI :
  551. /*------------------------------------------------------------------------------
  552. Purpose: DISABLE the User Interface
  553. Parameters: <none>
  554. Notes: Here we clean-up the user-interface by deleting
  555. dynamic widgets we have created and/or hide
  556. frames. This procedure is usually called when
  557. we are ready to "clean-up" after running.
  558. ------------------------------------------------------------------------------*/
  559. /* Delete the WINDOW we created */
  560. IF SESSION:DISPLAY-TYPE = "GUI":U AND VALID-HANDLE(wTabellen)
  561. THEN DELETE WIDGET wTabellen.
  562. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  563. END PROCEDURE.
  564. /* _UIB-CODE-BLOCK-END */
  565. &ANALYZE-RESUME
  566. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject wTabellen
  567. PROCEDURE enableObject :
  568. /*------------------------------------------------------------------------------
  569. Purpose: Super Override
  570. Parameters:
  571. Notes:
  572. ------------------------------------------------------------------------------*/
  573. DEF VAR wx AS INT NO-UNDO.
  574. DEF VAR wy AS INT NO-UNDO.
  575. DEF VAR xString AS CHAR NO-UNDO.
  576. DEF VAR xSection AS CHAR NO-UNDO.
  577. DEF VAR MaxBreite AS DEC NO-UNDO.
  578. DEF VAR MaxHoehe AS DEC NO-UNDO.
  579. DEF VAR Breite AS DEC NO-UNDO.
  580. DEF VAR Hoehe AS DEC NO-UNDO.
  581. xSection = 'Tabelle-' + RecArt.
  582. GET-KEY-VALUE SECTION XSection
  583. KEY 'TabellenFenster'
  584. VALUE xString.
  585. IF xString = ? THEN xString = '30;30'.
  586. IF xString = '' THEN xString = '30;30'.
  587. wx = INTEGER(ENTRY(1, xString, ';')).
  588. wy = INTEGER(ENTRY(2, xString, ';')).
  589. IF wx < 0 THEN wx = 1.
  590. IF wy < 0 THEN wy = 1.
  591. {&WINDOW-NAME}:X = wx.
  592. {&WINDOW-NAME}:Y = wy.
  593. RUN FORMAT_BROWSER IN h_b-tabel ( INPUT cParam ).
  594. MaxBreite = DECIMAL(RETURN-VALUE).
  595. RUN FORMAT_VIEWER IN h_v-tabel ( INPUT cParam,
  596. INPUT Firma ,
  597. INPUT Sprcd ).
  598. Breite = DECIMAL(ENTRY(1, RETURN-VALUE, ';')).
  599. Hoehe = DECIMAL(ENTRY(2, RETURN-VALUE, ';')).
  600. IF Breite > MaxBreite THEN MaxBreite = Breite.
  601. IF MaxBreite < 57 THEN MaxBreite = 57.
  602. PUBLISH 'SETRECTBREITE' ( INPUT MaxBreite ).
  603. {&WINDOW-NAME}:WIDTH-CHAR = MaxBreite + 2.
  604. {&WINDOW-NAME}:HEIGHT-CHAR = Hoehe + 10.
  605. RUN SETBREITE IN h_dyntoolbar ( INPUT MaxBreite ).
  606. RUN SET_QUERY_STRING IN h_d-tabel ( INPUT Firma ,
  607. INPUT Sprcd ,
  608. INPUT RecArt,
  609. INPUT Art ).
  610. RUN SUPER.
  611. RUN FENSTER_TITEL ( INPUT {&WINDOW-NAME}:HANDLE ) NO-ERROR.
  612. END PROCEDURE.
  613. /* _UIB-CODE-BLOCK-END */
  614. &ANALYZE-RESUME
  615. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI wTabellen _DEFAULT-ENABLE
  616. PROCEDURE enable_UI :
  617. /*------------------------------------------------------------------------------
  618. Purpose: ENABLE the User Interface
  619. Parameters: <none>
  620. Notes: Here we display/view/enable the widgets in the
  621. user-interface. In addition, OPEN all queries
  622. associated with each FRAME and BROWSE.
  623. These statements here are based on the "Other
  624. Settings" section of the widget Property Sheets.
  625. ------------------------------------------------------------------------------*/
  626. VIEW FRAME fMain IN WINDOW wTabellen.
  627. {&OPEN-BROWSERS-IN-QUERY-fMain}
  628. VIEW wTabellen.
  629. END PROCEDURE.
  630. /* _UIB-CODE-BLOCK-END */
  631. &ANALYZE-RESUME
  632. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE wTabellen
  633. PROCEDURE ENDE :
  634. /*------------------------------------------------------------------------------
  635. Purpose:
  636. Parameters: <none>
  637. Notes:
  638. ------------------------------------------------------------------------------*/
  639. DEF VAR wx AS INT NO-UNDO.
  640. DEF VAR wy AS INT NO-UNDO.
  641. DEF VAR xString AS CHAR NO-UNDO.
  642. DEF VAR xSection AS CHAR NO-UNDO.
  643. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U) NO-ERROR.
  644. IF AktSeite > 1 THEN DO:
  645. RUN selectPage ( INPUT 1 ).
  646. RETURN NO-APPLY.
  647. END.
  648. RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ).
  649. wx = {&WINDOW-NAME}:X NO-ERROR.
  650. wy = {&WINDOW-NAME}:Y NO-ERROR.
  651. xString = STRING(wx) + ';' + STRING(wy).
  652. xSection = 'Tabelle-' + RecArt.
  653. PUT-KEY-VALUE SECTION xSection
  654. KEY 'Fenster'
  655. VALUE xString.
  656. APPLY "CLOSE":U TO THIS-PROCEDURE.
  657. END PROCEDURE.
  658. /* _UIB-CODE-BLOCK-END */
  659. &ANALYZE-RESUME
  660. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_CURSOR wTabellen
  661. PROCEDURE ENTRY_CURSOR :
  662. /*------------------------------------------------------------------------------
  663. Purpose:
  664. Parameters: <none>
  665. Notes:
  666. ------------------------------------------------------------------------------*/
  667. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
  668. FMutFlag = DYNAMIC-FUNCTION('getMutflagAlt':U).
  669. CASE AktSeite:
  670. WHEN 1 THEN DO:
  671. IF FMutFlag THEN RUN applyEntry IN h_v-tabel ( INPUT ? ).
  672. ELSE RUN applyEntry IN h_b-tabel ( INPUT ? ).
  673. END.
  674. /* WHEN 1 THEN RUN applyEntry IN h_v-adresse ( INPUT ? ). */
  675. /* WHEN 2 THEN RUN applyEntry IN h_f-adrkomm ( INPUT ? ). */
  676. /* WHEN 3 THEN RUN applyEntry IN h_b-auftbb ( INPUT ? ). */
  677. /* WHEN 4 THEN RUN applyEntry IN h_b-aufdet ( INPUT ? ). */
  678. /* WHEN 5 THEN RUN applyEntry IN h_b-aufstreu ( INPUT ? ). */
  679. /* WHEN 6 THEN RUN applyEntry IN h_b-auffak ( INPUT ? ). */
  680. /* WHEN 7 THEN RUN applyEntry IN h_b-position ( INPUT ? ). */
  681. END CASE.
  682. RETURN NO-APPLY.
  683. END PROCEDURE.
  684. /* _UIB-CODE-BLOCK-END */
  685. &ANALYZE-RESUME
  686. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE exitObject wTabellen
  687. PROCEDURE exitObject :
  688. /*------------------------------------------------------------------------------
  689. Purpose: Window-specific override of this procedure which destroys
  690. its contents and itself.
  691. Notes:
  692. ------------------------------------------------------------------------------*/
  693. RUN ENDE.
  694. RETURN NO-APPLY.
  695. END PROCEDURE.
  696. /* _UIB-CODE-BLOCK-END */
  697. &ANALYZE-RESUME
  698. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE NEXTPAGE wTabellen
  699. PROCEDURE NEXTPAGE :
  700. /*------------------------------------------------------------------------------
  701. Purpose:
  702. Parameters: <none>
  703. Notes:
  704. ------------------------------------------------------------------------------*/
  705. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
  706. IF AktSeite = MaxPage THEN AktSeite = 1.
  707. ELSE AktSeite = AktSeite + 1.
  708. RUN selectPage ( INPUT AktSeite ).
  709. END PROCEDURE.
  710. /* _UIB-CODE-BLOCK-END */
  711. &ANALYZE-RESUME
  712. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE PREVPAGE wTabellen
  713. PROCEDURE PREVPAGE :
  714. /*------------------------------------------------------------------------------
  715. Purpose:
  716. Parameters: <none>
  717. Notes:
  718. ------------------------------------------------------------------------------*/
  719. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
  720. IF AktSeite = 1 THEN AktSeite = MaxPage.
  721. ELSE AktSeite = AktSeite - 1.
  722. RUN selectPage ( INPUT AktSeite ).
  723. END PROCEDURE.
  724. /* _UIB-CODE-BLOCK-END */
  725. &ANALYZE-RESUME
  726. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE selectPage wTabellen
  727. PROCEDURE selectPage :
  728. /*------------------------------------------------------------------------------
  729. Purpose: Super Override
  730. Parameters:
  731. Notes:
  732. ------------------------------------------------------------------------------*/
  733. DEF INPUT PARAMETER piPageNum AS INT NO-UNDO.
  734. DEF VAR FMutFlag AS LOG NO-UNDO.
  735. DEF VAR MutProg AS CHAR NO-UNDO.
  736. FMutFlag = DYNAMIC-FUNCTION('getMutflagAlt':U) NO-ERROR.
  737. DO WHILE TRUE:
  738. IF NOT FMutFlag THEN LEAVE.
  739. MutProg = DYNAMIC-FUNCTION('GETMUTPROG':U).
  740. IF MutProg <> THIS-PROCEDURE:FILE-NAME THEN LEAVE.
  741. RETURN NO-APPLY.
  742. END.
  743. CASE piPageNum:
  744. END CASE.
  745. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
  746. CASE AktSeite:
  747. WHEN 1 THEN DO:
  748. /* RUN removeLink ( h_dyntoolbar , 'TableIO':U , h_v-auftr ). */
  749. /* RUN removeLink ( h_dyntoolbar , 'Navigation':U , h_d-auftr ). */
  750. END.
  751. END CASE.
  752. RUN SUPER( INPUT piPageNum).
  753. END PROCEDURE.
  754. /* _UIB-CODE-BLOCK-END */
  755. &ANALYZE-RESUME
  756. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE TOOLBAR wTabellen
  757. PROCEDURE TOOLBAR :
  758. /*------------------------------------------------------------------------------
  759. Purpose:
  760. Parameters: <none>
  761. Notes:
  762. ------------------------------------------------------------------------------*/
  763. DEF INPUT PARAMETER pcAction AS CHAR NO-UNDO.
  764. RUN TOOLBAR IN h_dyntoolbar ( INPUT pcAction ).
  765. END PROCEDURE.
  766. /* _UIB-CODE-BLOCK-END */
  767. &ANALYZE-RESUME
  768. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE viewObject wTabellen
  769. PROCEDURE viewObject :
  770. /*------------------------------------------------------------------------------
  771. Purpose: Super Override
  772. Parameters:
  773. Notes:
  774. ------------------------------------------------------------------------------*/
  775. RUN SUPER.
  776. RUN ENTRY_CURSOR.
  777. END PROCEDURE.
  778. /* _UIB-CODE-BLOCK-END */
  779. &ANALYZE-RESUME