g-artpreis-reorg.w 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661
  1. &ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
  2. &ANALYZE-RESUME
  3. &Scoped-define WINDOW-NAME CURRENT-WINDOW
  4. &Scoped-define FRAME-NAME gartpreisreorg
  5. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gartpreisreorg
  6. /*------------------------------------------------------------------------
  7. File:
  8. Description: from cntnrdlg.w - ADM2 SmartDialog Template
  9. Input Parameters:
  10. <none>
  11. Output Parameters:
  12. <none>
  13. Author:
  14. Created:
  15. ------------------------------------------------------------------------*/
  16. /* This .W file was created with the Progress AppBuilder. */
  17. /*----------------------------------------------------------------------*/
  18. /* Create an unnamed pool to store all the widgets created
  19. by this procedure. This is a good default which assures
  20. that this procedure's triggers and internal procedures
  21. will execute in this procedure's storage, and that proper
  22. cleanup will occur on deletion of the procedure. */
  23. CREATE WIDGET-POOL.
  24. /* *************************** Definitions ************************** */
  25. /* Parameters Definitions --- */
  26. /* Local Variable Definitions --- */
  27. DEF VAR MaxPage AS INT NO-UNDO.
  28. DEF VAR AktSeite AS INT NO-UNDO.
  29. DEF VAR FMutFlag AS LOG NO-UNDO.
  30. DEF TEMP-TABLE tArtPreis LIKE ArtPreis
  31. FIELD APRecid AS RECID
  32. FIELD AKRecid AS RECID. .
  33. /* _UIB-CODE-BLOCK-END */
  34. &ANALYZE-RESUME
  35. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  36. /* ******************** Preprocessor Definitions ******************** */
  37. &Scoped-define PROCEDURE-TYPE SmartDialog
  38. &Scoped-define DB-AWARE no
  39. &Scoped-define ADM-CONTAINER DIALOG-BOX
  40. &Scoped-define ADM-SUPPORTED-LINKS Data-Target,Data-Source,Page-Target,Update-Source,Update-Target
  41. /* Name of designated FRAME-NAME and/or first browse and/or first query */
  42. &Scoped-define FRAME-NAME gartpreisreorg
  43. /* Standard List Definitions */
  44. &Scoped-Define ENABLED-OBJECTS Btn_OK Btn_Cancel
  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 a dialog box */
  51. /* Definitions of the field level widgets */
  52. DEFINE BUTTON Btn_Cancel AUTO-END-KEY
  53. LABEL "&Abbrechen"
  54. SIZE 15 BY 1.
  55. DEFINE BUTTON Btn_OK
  56. LABEL "&Start"
  57. SIZE 15 BY 1.
  58. /* ************************ Frame Definitions *********************** */
  59. DEFINE FRAME gartpreisreorg
  60. Btn_OK AT ROW 5 COL 17
  61. Btn_Cancel AT ROW 5 COL 40.2
  62. "Alle alten Preise werden auf ~"inaktiv~" gesetzt" VIEW-AS TEXT
  63. SIZE 60 BY 1 AT ROW 3 COL 9
  64. BGCOLOR 12 FONT 6
  65. SPACE(7.19) SKIP(3.56)
  66. WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER
  67. SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE
  68. TITLE "Artikelpreise reorganisieren"
  69. CANCEL-BUTTON Btn_Cancel.
  70. /* *********************** Procedure Settings ************************ */
  71. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  72. /* Settings for THIS-PROCEDURE
  73. Type: SmartDialog
  74. Allow: Basic,Browse,DB-Fields,Query,Smart
  75. Container Links: Data-Target,Data-Source,Page-Target,Update-Source,Update-Target
  76. Design Page: 1
  77. Other Settings: COMPILE
  78. */
  79. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  80. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB gartpreisreorg
  81. /* ************************* Included-Libraries *********************** */
  82. {src/adm2/containr.i}
  83. /* _UIB-CODE-BLOCK-END */
  84. &ANALYZE-RESUME
  85. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  86. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  87. /* SETTINGS FOR DIALOG-BOX gartpreisreorg
  88. FRAME-NAME */
  89. ASSIGN
  90. FRAME gartpreisreorg:SCROLLABLE = FALSE
  91. FRAME gartpreisreorg:HIDDEN = TRUE.
  92. /* _RUN-TIME-ATTRIBUTES-END */
  93. &ANALYZE-RESUME
  94. /* Setting information for Queries and Browse Widgets fields */
  95. &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gartpreisreorg
  96. /* Query rebuild information for DIALOG-BOX gartpreisreorg
  97. _Options = "SHARE-LOCK"
  98. _Query is NOT OPENED
  99. */ /* DIALOG-BOX gartpreisreorg */
  100. &ANALYZE-RESUME
  101. /* ************************ Control Triggers ************************ */
  102. &Scoped-define SELF-NAME gartpreisreorg
  103. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gartpreisreorg gartpreisreorg
  104. ON END-ERROR OF FRAME gartpreisreorg /* Artikelpreise reorganisieren */
  105. DO:
  106. RUN ENDE.
  107. RETURN NO-APPLY.
  108. END.
  109. /* _UIB-CODE-BLOCK-END */
  110. &ANALYZE-RESUME
  111. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gartpreisreorg gartpreisreorg
  112. ON GO OF FRAME gartpreisreorg /* Artikelpreise reorganisieren */
  113. DO:
  114. RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ) NO-ERROR.
  115. END.
  116. /* _UIB-CODE-BLOCK-END */
  117. &ANALYZE-RESUME
  118. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gartpreisreorg gartpreisreorg
  119. ON WINDOW-CLOSE OF FRAME gartpreisreorg /* Artikelpreise reorganisieren */
  120. DO:
  121. RUN ENDE.
  122. RETURN NO-APPLY.
  123. END.
  124. /* _UIB-CODE-BLOCK-END */
  125. &ANALYZE-RESUME
  126. &Scoped-define SELF-NAME Btn_Cancel
  127. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Cancel gartpreisreorg
  128. ON CHOOSE OF Btn_Cancel IN FRAME gartpreisreorg /* Abbrechen */
  129. DO:
  130. RUN ENDE.
  131. RETURN NO-APPLY.
  132. END.
  133. /* _UIB-CODE-BLOCK-END */
  134. &ANALYZE-RESUME
  135. &Scoped-define SELF-NAME Btn_OK
  136. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_OK gartpreisreorg
  137. ON CHOOSE OF Btn_OK IN FRAME gartpreisreorg /* Start */
  138. DO:
  139. RUN REORG.
  140. RUN ENDE.
  141. RETURN NO-APPLY.
  142. END.
  143. /* _UIB-CODE-BLOCK-END */
  144. &ANALYZE-RESUME
  145. &UNDEFINE SELF-NAME
  146. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gartpreisreorg
  147. /* *************************** Main Block *************************** */
  148. MaxPage = 1.
  149. AktSeite = 1.
  150. SESSION:DATA-ENTRY-RETURN = TRUE.
  151. SUBSCRIBE TO 'TOOLBAR' ANYWHERE.
  152. /* TRIGGERS ------------------------------------------------------ */
  153. ON 'ALT-CURSOR-RIGHT':U OF FRAME {&FRAME-NAME} ANYWHERE
  154. DO:
  155. RUN NEXTPAGE.
  156. END.
  157. ON 'ALT-CURSOR-LEFT':U OF FRAME {&FRAME-NAME} ANYWHERE
  158. DO:
  159. RUN PREVPAGE.
  160. END.
  161. ON 'U1':U OF {&WINDOW-NAME} ANYWHERE
  162. DO:
  163. RUN ENTRY_CURSOR.
  164. END.
  165. /*
  166. ON 'PAGE-DOWN':U OF {&WINDOW-NAME} ANYWHERE
  167. DO:
  168. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'Next':U ).
  169. END.
  170. ON 'PAGE-UP':U OF {&WINDOW-NAME} ANYWHERE
  171. DO:
  172. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'Prev':U ).
  173. END.
  174. ON 'ALT-RETURN':U OF FRAME {&FRAME-NAME} ANYWHERE
  175. DO:
  176. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'UPDATE':U ).
  177. END.
  178. ON 'ALT-INS':U OF FRAME {&FRAME-NAME} ANYWHERE
  179. DO:
  180. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'ADD':U ).
  181. END.
  182. ON 'ALT-DEL':U OF FRAME {&FRAME-NAME} ANYWHERE
  183. DO:
  184. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'DELETE':U ).
  185. END.
  186. ON 'ALT-R':U OF FRAME {&FRAME-NAME} ANYWHERE
  187. DO:
  188. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'RESET':U ).
  189. END.
  190. ON 'F9':U OF FRAME {&FRAME-NAME} ANYWHERE
  191. DO:
  192. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'SAVE':U ).
  193. END.
  194. ON 'ALT-S':U OF FRAME {&FRAME-NAME} ANYWHERE
  195. DO:
  196. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'SAVE':U ).
  197. END.
  198. ON 'ALT-K':U OF FRAME {&FRAME-NAME} ANYWHERE
  199. DO:
  200. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'COPY':U ).
  201. END.
  202. ON 'END-ERROR':U OF FRAME {&FRAME-NAME} ANYWHERE
  203. DO:
  204. FMutFlag = DYNAMIC-FUNCTION('getMutflagAlt':U) NO-ERROR.
  205. IF FMutFlag = FALSE THEN DO:
  206. RUN ENDE.
  207. RETURN NO-APPLY.
  208. END.
  209. RUN TOOLBAR IN h_dyntoolbar ( INPUT 'CANCEL':U ).
  210. RETURN NO-APPLY.
  211. END.
  212. */
  213. /* ------------------------------------------------------------------ */
  214. {src/adm2/dialogmn.i}
  215. /* _UIB-CODE-BLOCK-END */
  216. &ANALYZE-RESUME
  217. /* ********************** Internal Procedures *********************** */
  218. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects gartpreisreorg _ADM-CREATE-OBJECTS
  219. PROCEDURE adm-create-objects :
  220. /*------------------------------------------------------------------------------
  221. Purpose: Create handles for all SmartObjects used in this procedure.
  222. After SmartObjects are initialized, then SmartLinks are added.
  223. Parameters: <none>
  224. ------------------------------------------------------------------------------*/
  225. END PROCEDURE.
  226. /* _UIB-CODE-BLOCK-END */
  227. &ANALYZE-RESUME
  228. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE changePage gartpreisreorg
  229. PROCEDURE changePage :
  230. /*------------------------------------------------------------------------------
  231. Purpose: Super Override
  232. Parameters:
  233. Notes:
  234. ------------------------------------------------------------------------------*/
  235. /* Code placed here will execute PRIOR to standard behavior. */
  236. RUN SUPER.
  237. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
  238. CASE AktSeite:
  239. WHEN 1 THEN DO:
  240. /* RUN addLink ( h_dyntoolbar , 'TableIO':U , h_v-auftr ). */
  241. /* RUN addLink ( h_dyntoolbar , 'Navigation':U , h_d-auftr ). */
  242. /* RUN ToolbarInit ( INPUT h_d-auftr ). */
  243. RUN ENTRY_CURSOR.
  244. END.
  245. WHEN 2 THEN DO:
  246. RUN ENTRY_CURSOR.
  247. END.
  248. END CASE.
  249. END PROCEDURE.
  250. /* _UIB-CODE-BLOCK-END */
  251. &ANALYZE-RESUME
  252. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gartpreisreorg _DEFAULT-DISABLE
  253. PROCEDURE disable_UI :
  254. /*------------------------------------------------------------------------------
  255. Purpose: DISABLE the User Interface
  256. Parameters: <none>
  257. Notes: Here we clean-up the user-interface by deleting
  258. dynamic widgets we have created and/or hide
  259. frames. This procedure is usually called when
  260. we are ready to "clean-up" after running.
  261. ------------------------------------------------------------------------------*/
  262. /* Hide all frames. */
  263. HIDE FRAME gartpreisreorg.
  264. END PROCEDURE.
  265. /* _UIB-CODE-BLOCK-END */
  266. &ANALYZE-RESUME
  267. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gartpreisreorg
  268. PROCEDURE enableObject :
  269. /*------------------------------------------------------------------------------
  270. Purpose: Super Override
  271. Parameters:
  272. Notes:
  273. ------------------------------------------------------------------------------*/
  274. /* Code placed here will execute PRIOR to standard behavior. */
  275. RUN SUPER.
  276. RUN FENSTER_TITEL ( INPUT FRAME {&FRAME-NAME}:HANDLE ) NO-ERROR.
  277. END PROCEDURE.
  278. /* _UIB-CODE-BLOCK-END */
  279. &ANALYZE-RESUME
  280. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gartpreisreorg _DEFAULT-ENABLE
  281. PROCEDURE enable_UI :
  282. /*------------------------------------------------------------------------------
  283. Purpose: ENABLE the User Interface
  284. Parameters: <none>
  285. Notes: Here we display/view/enable the widgets in the
  286. user-interface. In addition, OPEN all queries
  287. associated with each FRAME and BROWSE.
  288. These statements here are based on the "Other
  289. Settings" section of the widget Property Sheets.
  290. ------------------------------------------------------------------------------*/
  291. ENABLE Btn_OK Btn_Cancel
  292. WITH FRAME gartpreisreorg.
  293. VIEW FRAME gartpreisreorg.
  294. {&OPEN-BROWSERS-IN-QUERY-gartpreisreorg}
  295. END PROCEDURE.
  296. /* _UIB-CODE-BLOCK-END */
  297. &ANALYZE-RESUME
  298. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gartpreisreorg
  299. PROCEDURE ENDE :
  300. /*------------------------------------------------------------------------------
  301. Purpose:
  302. Parameters: <none>
  303. Notes:
  304. ------------------------------------------------------------------------------*/
  305. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U) NO-ERROR.
  306. IF AktSeite > 1 THEN DO:
  307. RUN selectPage ( INPUT 1 ).
  308. RETURN NO-APPLY.
  309. END.
  310. RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ).
  311. APPLY 'GO' TO FRAME {&FRAME-NAME}.
  312. RETURN NO-APPLY.
  313. END PROCEDURE.
  314. /* _UIB-CODE-BLOCK-END */
  315. &ANALYZE-RESUME
  316. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_CURSOR gartpreisreorg
  317. PROCEDURE ENTRY_CURSOR :
  318. /*------------------------------------------------------------------------------
  319. Purpose:
  320. Parameters: <none>
  321. Notes:
  322. ------------------------------------------------------------------------------*/
  323. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
  324. CASE AktSeite:
  325. /* WHEN 1 THEN RUN applyEntry IN h_v-adresse ( INPUT ? ). */
  326. /* WHEN 2 THEN RUN applyEntry IN h_f-adrkomm ( INPUT ? ). */
  327. /* WHEN 3 THEN RUN applyEntry IN h_b-auftbb ( INPUT ? ). */
  328. /* WHEN 4 THEN RUN applyEntry IN h_b-aufdet ( INPUT ? ). */
  329. /* WHEN 5 THEN RUN applyEntry IN h_b-aufstreu ( INPUT ? ). */
  330. /* WHEN 6 THEN RUN applyEntry IN h_b-auffak ( INPUT ? ). */
  331. /* WHEN 7 THEN RUN applyEntry IN h_b-position ( INPUT ? ). */
  332. END CASE.
  333. RETURN NO-APPLY.
  334. END PROCEDURE.
  335. /* _UIB-CODE-BLOCK-END */
  336. &ANALYZE-RESUME
  337. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE exitObject gartpreisreorg
  338. PROCEDURE exitObject :
  339. /*------------------------------------------------------------------------------
  340. Purpose: Super Override
  341. Parameters:
  342. Notes:
  343. ------------------------------------------------------------------------------*/
  344. RUN ENDE.
  345. RETURN NO-APPLY.
  346. END PROCEDURE.
  347. /* _UIB-CODE-BLOCK-END */
  348. &ANALYZE-RESUME
  349. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE NEXTPAGE gartpreisreorg
  350. PROCEDURE NEXTPAGE :
  351. /*------------------------------------------------------------------------------
  352. Purpose:
  353. Parameters: <none>
  354. Notes:
  355. ------------------------------------------------------------------------------*/
  356. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
  357. IF AktSeite = MaxPage THEN AktSeite = 1.
  358. ELSE AktSeite = AktSeite + 1.
  359. RUN selectPage ( INPUT AktSeite ).
  360. END PROCEDURE.
  361. /* _UIB-CODE-BLOCK-END */
  362. &ANALYZE-RESUME
  363. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE PREVPAGE gartpreisreorg
  364. PROCEDURE PREVPAGE :
  365. /*------------------------------------------------------------------------------
  366. Purpose:
  367. Parameters: <none>
  368. Notes:
  369. ------------------------------------------------------------------------------*/
  370. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
  371. IF AktSeite = 1 THEN AktSeite = MaxPage.
  372. ELSE AktSeite = AktSeite - 1.
  373. RUN selectPage ( INPUT AktSeite ).
  374. END PROCEDURE.
  375. /* _UIB-CODE-BLOCK-END */
  376. &ANALYZE-RESUME
  377. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE REORG gartpreisreorg
  378. PROCEDURE REORG :
  379. /*------------------------------------------------------------------------------
  380. Purpose:
  381. Parameters: <none>
  382. Notes:
  383. ------------------------------------------------------------------------------*/
  384. DO WITH FRAME {&FRAME-NAME}:
  385. Btn_OK:SENSITIVE = FALSE.
  386. Btn_Cancel:SENSITIVE = FALSE.
  387. DEF VAR Firma AS CHAR NO-UNDO.
  388. Firma = DYNAMIC-FUNCTION('GETMANDANT':U) NO-ERROR.
  389. EMPTY TEMP-TABLE tArtPreis.
  390. FOR EACH ArtPreis
  391. WHERE ArtPreis.Firma = Firma
  392. AND ArtPreis.Ab_Datum <= TODAY
  393. AND ArtPreis.Aktion = FALSE
  394. AND ArtPreis.Aktiv = TRUE NO-LOCK:
  395. CREATE tArtPreis.
  396. BUFFER-COPY ArtPreis TO tArtPreis
  397. ASSIGN tArtPreis.APRecid = RECID(ArtPreis)
  398. tArtPreis.AKRecid = 0.
  399. IF NOT CAN-FIND ( Tabel NO-LOCK USE-INDEX Tabel-k1
  400. WHERE Tabel.Firma = Firma
  401. AND Tabel.RecArt = 'PREGRP'
  402. AND Tabel.CodeC = ''
  403. AND Tabel.CodeI = tArtPreis.Preis_Grp
  404. AND Tabel.Sprcd = 1 )
  405. THEN tArtPreis.Aktiv = FALSE.
  406. END.
  407. FOR EACH tArtPreis BREAK BY tArtPreis.Firma
  408. BY tArtPreis.Artnr
  409. BY tArtPreis.Inhalt
  410. BY tArtPreis.Jahr
  411. BY tArtPreis.Preis_Grp
  412. BY tArtPreis.Ab_Datum DESCENDING:
  413. IF FIRST-OF (tArtPreis.Preis_Grp) THEN NEXT.
  414. tArtPreis.Aktiv = FALSE.
  415. END.
  416. FOR EACH ArtPreis
  417. WHERE ArtPreis.Firma = Firma
  418. AND ArtPreis.Ab_Datum <= TODAY
  419. AND ArtPreis.Aktion = TRUE
  420. AND ArtPreis.Aktiv = TRUE NO-LOCK:
  421. CREATE tArtPreis.
  422. BUFFER-COPY ArtPreis to tArtPreis
  423. ASSIGN tArtPreis.APRecid = RECID(ArtPreis)
  424. tArtPreis.AKRecid = 0.
  425. FIND AktPreis
  426. WHERE AktPreis.Firma = ArtPreis.Firma
  427. AND AktPreis.Artnr = ArtPreis.Artnr
  428. AND AktPreis.Inhalt = ArtPreis.Inhalt
  429. AND AktPreis.Jahr = ArtPreis.Jahr
  430. AND AktPreis.ab_Datum = ArtPreis.ab_Datum
  431. AND AktPreis.Grp = ArtPreis.Preis_Grp NO-ERROR.
  432. IF NOT AVAILABLE AktPreis THEN DO:
  433. ASSIGN tArtPreis.Aktiv = FALSE
  434. tArtPreis.AKRecid = 0.
  435. NEXT.
  436. END.
  437. IF AktPreis.Bis_Datum > TODAY THEN DO:
  438. ASSIGN tArtPreis.AKRecid = 0.
  439. NEXT.
  440. END.
  441. ASSIGN tArtPreis.Aktiv = FALSE
  442. tArtPreis.AKRecid = RECID(AktPreis).
  443. END.
  444. FOR EACH tArtPreis WHERE tArtPreis.Aktiv = FALSE TRANSACTION:
  445. FIND ArtPreis WHERE RECID(ArtPreis) = tArtPreis.APRecid.
  446. IF ArtPreis.Ab_Datum < (TODAY - 730) THEN DO:
  447. IF tArtPreis.AKRecid <> 0 THEN DO:
  448. FIND AktPreis WHERE RECID(AktPreis) = tArtPreis.AKRecid NO-ERROR.
  449. IF AVAILABLE AktPreis THEN DELETE AktPreis.
  450. END.
  451. DELETE ArtPreis.
  452. NEXT.
  453. END.
  454. ASSIGN ArtPreis.Aktiv = tArtPreis.Aktiv.
  455. END.
  456. END.
  457. END PROCEDURE.
  458. /* _UIB-CODE-BLOCK-END */
  459. &ANALYZE-RESUME
  460. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE selectPage gartpreisreorg
  461. PROCEDURE selectPage :
  462. /*------------------------------------------------------------------------------
  463. Purpose: Super Override
  464. Parameters:
  465. Notes:
  466. ------------------------------------------------------------------------------*/
  467. DEF INPUT PARAMETER piPageNum AS INT NO-UNDO.
  468. DEF VAR FMutFlag AS LOG NO-UNDO.
  469. DEF VAR MutProg AS CHAR NO-UNDO.
  470. FMutFlag = DYNAMIC-FUNCTION('getMutflagAlt':U) NO-ERROR.
  471. DO WHILE TRUE:
  472. IF NOT FMutFlag THEN LEAVE.
  473. MutProg = DYNAMIC-FUNCTION('GETMUTPROG':U).
  474. IF MutProg <> THIS-PROCEDURE:FILE-NAME THEN LEAVE.
  475. RETURN NO-APPLY.
  476. END.
  477. CASE piPageNum:
  478. END CASE.
  479. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
  480. CASE AktSeite:
  481. WHEN 1 THEN DO:
  482. /* RUN removeLink ( h_dyntoolbar , 'TableIO':U , h_v-auftr ). */
  483. /* RUN removeLink ( h_dyntoolbar , 'Navigation':U , h_d-auftr ). */
  484. END.
  485. END CASE.
  486. RUN SUPER( INPUT piPageNum).
  487. END PROCEDURE.
  488. /* _UIB-CODE-BLOCK-END */
  489. &ANALYZE-RESUME
  490. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE TOOLBAR gartpreisreorg
  491. PROCEDURE TOOLBAR :
  492. /*------------------------------------------------------------------------------
  493. Purpose:
  494. Parameters: <none>
  495. Notes:
  496. ------------------------------------------------------------------------------*/
  497. DEF INPUT PARAMETER pcAction AS CHAR NO-UNDO.
  498. /*
  499. RUN TOOLBAR IN h_dyntoolbar ( INPUT pcAction ).
  500. */
  501. END PROCEDURE.
  502. /* _UIB-CODE-BLOCK-END */
  503. &ANALYZE-RESUME