b-artpreis.w 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644
  1. &ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
  2. &ANALYZE-RESUME
  3. /* Connected Databases
  4. anadat PROGRESS
  5. */
  6. &Scoped-define WINDOW-NAME CURRENT-WINDOW
  7. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS bTableWin
  8. /*------------------------------------------------------------------------
  9. File: adm2\src\browser.w
  10. Description: SmartDataBrowser Object
  11. Input Parameters:
  12. <none>
  13. Output Parameters:
  14. <none>
  15. ------------------------------------------------------------------------*/
  16. /* This .W file was created with the Progress AppBuilder. */
  17. /*----------------------------------------------------------------------*/
  18. /* Create an unnamed pool to store all the widgets created
  19. by this procedure. This is a good default which assures
  20. that this procedure's triggers and internal procedures
  21. will execute in this procedure's storage, and that proper
  22. cleanup will occur on deletion of the procedure. */
  23. CREATE WIDGET-POOL.
  24. /* *************************** Definitions ************************** */
  25. /* Parameters Definitions --- */
  26. /* Local Variable Definitions --- */
  27. DEF VAR lInaktiv AS LOG NO-UNDO.
  28. DEF VAR hInaktiv AS HANDLE NO-UNDO.
  29. DEF VAR dMinMarge AS DEC DECIMALS 3 NO-UNDO.
  30. { incl/tmpbrowser.i }
  31. {src/adm2/widgetprto.i}
  32. /* _UIB-CODE-BLOCK-END */
  33. &ANALYZE-RESUME
  34. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  35. /* ******************** Preprocessor Definitions ******************** */
  36. &Scoped-define PROCEDURE-TYPE SmartDataBrowser
  37. &Scoped-define DB-AWARE no
  38. &Scoped-define ADM-SUPPORTED-LINKS TableIO-Target,Data-Target,Update-Source
  39. /* Include file with RowObject temp-table definition */
  40. &Scoped-define DATA-FIELD-DEFS "d-artpreis.i"
  41. /* Name of designated FRAME-NAME and/or first browse and/or first query */
  42. &Scoped-define FRAME-NAME F-Main
  43. &Scoped-define BROWSE-NAME br_table
  44. /* Internal Tables (found by Frame, Query & Browse Queries) */
  45. &Scoped-define INTERNAL-TABLES rowObject
  46. /* Definitions for BROWSE br_table */
  47. &Scoped-define FIELDS-IN-QUERY-br_table rowObject.MinMarge rowObject.ArtID ~
  48. rowObject.Preis_Grp rowObject.Preisgruppe rowObject.Ab_Datum ~
  49. rowObject.VK_Netto rowObject.VK_Brutto rowObject.Marge rowObject.AktName
  50. &Scoped-define ENABLED-FIELDS-IN-QUERY-br_table
  51. &Scoped-define QUERY-STRING-br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION
  52. &Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH rowObject NO-LOCK INDEXED-REPOSITION.
  53. &Scoped-define TABLES-IN-QUERY-br_table rowObject
  54. &Scoped-define FIRST-TABLE-IN-QUERY-br_table rowObject
  55. /* Definitions for FRAME F-Main */
  56. /* Standard List Definitions */
  57. &Scoped-Define ENABLED-OBJECTS RECT-1 br_table
  58. /* Custom List Definitions */
  59. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  60. /* _UIB-PREPROCESSOR-BLOCK-END */
  61. &ANALYZE-RESUME
  62. /* ************************ Function Prototypes ********************** */
  63. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD setZeilenfarbe bTableWin
  64. FUNCTION setZeilenfarbe RETURNS LOGICAL
  65. ( ipFarbe AS INT ) FORWARD.
  66. /* _UIB-CODE-BLOCK-END */
  67. &ANALYZE-RESUME
  68. /* *********************** Control Definitions ********************** */
  69. /* Menu Definitions */
  70. DEFINE MENU POPUP-MENU-br_table
  71. MENU-ITEM X_INAKTIVE_EINAUS LABEL "inaktive anzeigen ?".
  72. /* Definitions of the field level widgets */
  73. DEFINE RECTANGLE RECT-1
  74. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  75. SIZE 106 BY 10.
  76. /* Query definitions */
  77. &ANALYZE-SUSPEND
  78. DEFINE TEMP-TABLE RowObject NO-UNDO
  79. {{&DATA-FIELD-DEFS}}
  80. {src/adm2/robjflds.i}.
  81. DEFINE QUERY br_table FOR
  82. rowObject SCROLLING.
  83. &ANALYZE-RESUME
  84. /* Browse definitions */
  85. DEFINE BROWSE br_table
  86. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table bTableWin _STRUCTURED
  87. QUERY br_table NO-LOCK DISPLAY
  88. rowObject.MinMarge FORMAT "->>,>>9.999":U WIDTH .2
  89. rowObject.ArtID FORMAT "->,>>>,>>9":U WIDTH .2
  90. rowObject.Preis_Grp COLUMN-LABEL "PGrp" FORMAT "99":U
  91. rowObject.Preisgruppe FORMAT "x(20)":U
  92. rowObject.Ab_Datum COLUMN-LABEL "Gültig ab" FORMAT "99.99.9999":U
  93. rowObject.VK_Netto COLUMN-LABEL "Netto (exkl)" FORMAT "zzz,zz9.9999":U
  94. rowObject.VK_Brutto COLUMN-LABEL "Brutto (inkl)" FORMAT "zzz,zz9.9999":U
  95. rowObject.Marge FORMAT "zz9.9999-":U
  96. rowObject.AktName COLUMN-LABEL "Aktion" FORMAT "x(20)":U
  97. /* _UIB-CODE-BLOCK-END */
  98. &ANALYZE-RESUME
  99. WITH NO-ASSIGN NO-AUTO-VALIDATE NO-ROW-MARKERS SEPARATORS SIZE 104 BY 9.52.
  100. /* ************************ Frame Definitions *********************** */
  101. DEFINE FRAME F-Main
  102. br_table AT ROW 1.48 COL 3 WIDGET-ID 200
  103. RECT-1 AT ROW 1.24 COL 2 WIDGET-ID 2
  104. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
  105. SIDE-LABELS NO-UNDERLINE THREE-D
  106. AT COL 1 ROW 1 SCROLLABLE WIDGET-ID 100.
  107. /* *********************** Procedure Settings ************************ */
  108. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  109. /* Settings for THIS-PROCEDURE
  110. Type: SmartDataBrowser
  111. Data Source: "d-artpreis.w"
  112. Allow: Basic,Browse
  113. Frames: 1
  114. Add Fields to: Neither
  115. Other Settings: PERSISTENT-ONLY COMPILE
  116. */
  117. /* This procedure should always be RUN PERSISTENT. Report the error, */
  118. /* then cleanup and return. */
  119. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  120. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  121. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  122. RETURN.
  123. END.
  124. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  125. /* ************************* Create Window ************************** */
  126. &ANALYZE-SUSPEND _CREATE-WINDOW
  127. /* DESIGN Window definition (used by the UIB)
  128. CREATE WINDOW bTableWin ASSIGN
  129. HEIGHT = 10.48
  130. WIDTH = 108.
  131. /* END WINDOW DEFINITION */
  132. */
  133. &ANALYZE-RESUME
  134. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB bTableWin
  135. /* ************************* Included-Libraries *********************** */
  136. {src/adm2/browser.i}
  137. /* _UIB-CODE-BLOCK-END */
  138. &ANALYZE-RESUME
  139. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  140. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  141. /* SETTINGS FOR WINDOW bTableWin
  142. NOT-VISIBLE,,RUN-PERSISTENT */
  143. /* SETTINGS FOR FRAME F-Main
  144. NOT-VISIBLE FRAME-NAME Size-to-Fit */
  145. /* BROWSE-TAB br_table RECT-1 F-Main */
  146. ASSIGN
  147. FRAME F-Main:SCROLLABLE = FALSE
  148. FRAME F-Main:HIDDEN = TRUE.
  149. ASSIGN
  150. br_table:POPUP-MENU IN FRAME F-Main = MENU POPUP-MENU-br_table:HANDLE.
  151. ASSIGN
  152. rowObject.MinMarge:VISIBLE IN BROWSE br_table = FALSE
  153. rowObject.ArtID:VISIBLE IN BROWSE br_table = FALSE.
  154. /* _RUN-TIME-ATTRIBUTES-END */
  155. &ANALYZE-RESUME
  156. /* Setting information for Queries and Browse Widgets fields */
  157. &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_table
  158. /* Query rebuild information for BROWSE br_table
  159. _TblList = "rowObject"
  160. _Options = "NO-LOCK INDEXED-REPOSITION"
  161. _FldNameList[1] > _<SDO>.rowObject.MinMarge
  162. "rowObject.MinMarge" ? ? "decimal" ? ? ? ? ? ? no "?" no no ".2" no no no "U" "" "" "" "" "" "" 0 no 0 no no
  163. _FldNameList[2] > _<SDO>.rowObject.ArtID
  164. "rowObject.ArtID" ? ? "integer" ? ? ? ? ? ? no "?" no no ".2" no no no "U" "" "" "" "" "" "" 0 no 0 no no
  165. _FldNameList[3] > _<SDO>.rowObject.Preis_Grp
  166. "rowObject.Preis_Grp" "PGrp" ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  167. _FldNameList[4] > _<SDO>.rowObject.Preisgruppe
  168. "rowObject.Preisgruppe" ? ? "character" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  169. _FldNameList[5] > _<SDO>.rowObject.Ab_Datum
  170. "rowObject.Ab_Datum" "Gültig ab" ? "date" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  171. _FldNameList[6] > _<SDO>.rowObject.VK_Netto
  172. "rowObject.VK_Netto" "Netto (exkl)" ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  173. _FldNameList[7] > _<SDO>.rowObject.VK_Brutto
  174. "rowObject.VK_Brutto" "Brutto (inkl)" ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  175. _FldNameList[8] > _<SDO>.rowObject.Marge
  176. "rowObject.Marge" ? ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  177. _FldNameList[9] > _<SDO>.rowObject.AktName
  178. "rowObject.AktName" "Aktion" ? "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  179. _Query is NOT OPENED
  180. */ /* BROWSE br_table */
  181. &ANALYZE-RESUME
  182. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
  183. /* Query rebuild information for FRAME F-Main
  184. _Options = "NO-LOCK"
  185. _Query is NOT OPENED
  186. */ /* FRAME F-Main */
  187. &ANALYZE-RESUME
  188. /* ************************ Control Triggers ************************ */
  189. &Scoped-define BROWSE-NAME br_table
  190. &Scoped-define SELF-NAME br_table
  191. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  192. ON CTRL-END OF br_table IN FRAME F-Main
  193. DO:
  194. APPLY "END":U TO BROWSE {&BROWSE-NAME}.
  195. END.
  196. /* _UIB-CODE-BLOCK-END */
  197. &ANALYZE-RESUME
  198. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  199. ON CTRL-HOME OF br_table IN FRAME F-Main
  200. DO:
  201. APPLY "HOME":U TO BROWSE {&BROWSE-NAME}.
  202. END.
  203. /* _UIB-CODE-BLOCK-END */
  204. &ANALYZE-RESUME
  205. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  206. ON DEFAULT-ACTION OF br_table IN FRAME F-Main
  207. DO:
  208. {src/adm2/brsdefault.i}
  209. END.
  210. /* _UIB-CODE-BLOCK-END */
  211. &ANALYZE-RESUME
  212. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  213. ON END OF br_table IN FRAME F-Main
  214. DO:
  215. {src/adm2/brsend.i}
  216. END.
  217. /* _UIB-CODE-BLOCK-END */
  218. &ANALYZE-RESUME
  219. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  220. ON HOME OF br_table IN FRAME F-Main
  221. DO:
  222. {src/adm2/brshome.i}
  223. END.
  224. /* _UIB-CODE-BLOCK-END */
  225. &ANALYZE-RESUME
  226. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  227. ON LEFT-MOUSE-CLICK OF br_table IN FRAME F-Main
  228. DO:
  229. APPLY 'ENTRY' TO {&BROWSE-NAME}.
  230. END.
  231. /* _UIB-CODE-BLOCK-END */
  232. &ANALYZE-RESUME
  233. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  234. ON LEFT-MOUSE-DBLCLICK OF br_table IN FRAME F-Main
  235. DO:
  236. IF NOT VALID-HANDLE( hFenster ) THEN RETURN NO-APPLY.
  237. RUN TOOLBAR IN hFenster ( INPUT 'UPDATE' ).
  238. RETURN NO-APPLY.
  239. END.
  240. /* _UIB-CODE-BLOCK-END */
  241. &ANALYZE-RESUME
  242. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  243. ON OFF-END OF br_table IN FRAME F-Main
  244. DO:
  245. {src/adm2/brsoffnd.i}
  246. END.
  247. /* _UIB-CODE-BLOCK-END */
  248. &ANALYZE-RESUME
  249. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  250. ON OFF-HOME OF br_table IN FRAME F-Main
  251. DO:
  252. {src/adm2/brsoffhm.i}
  253. END.
  254. /* _UIB-CODE-BLOCK-END */
  255. &ANALYZE-RESUME
  256. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  257. ON RETURN OF br_table IN FRAME F-Main
  258. DO:
  259. DO WITH FRAME {&FRAME-NAME}:
  260. IF {&BROWSE-NAME}:NUM-SELECTED-ROWS = 0 THEN RETURN NO-APPLY.
  261. {&BROWSE-NAME}:FETCH-SELECTED-ROW(1).
  262. RUN PREISMUTATION ( INTEGER(rowObject.ArtID:SCREEN-VALUE IN BROWSE {&BROWSE-NAME}) ).
  263. APPLY 'U1' TO hDaten.
  264. RETURN NO-APPLY.
  265. END.
  266. END.
  267. /* _UIB-CODE-BLOCK-END */
  268. &ANALYZE-RESUME
  269. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  270. ON ROW-DISPLAY OF br_table IN FRAME F-Main
  271. DO:
  272. dMinMarge = rowObject.MinMarge.
  273. IF dMinMarge = ? THEN dMinMarge = 10.
  274. IF dMinMarge = 0 THEN dMinMarge = 10.
  275. Farbe = 15.
  276. IF rowObject.Ab_Datum > TODAY THEN Farbe = 8.
  277. IF rowObject.Aktion = TRUE THEN Farbe = 14.
  278. IF rowObject.Aktiv = FALSE THEN Farbe = 12.
  279. DYNAMIC-FUNCTION('setZeilenFarbe':U, Farbe ).
  280. DO WITH FRAME {&FRAME-NAME}:
  281. IF rowObject.Marge < dMinMarge THEN DO:
  282. rowObject.Marge:BGCOLOR IN BROWSE {&BROWSE-NAME} = 12.
  283. END.
  284. END.
  285. END.
  286. /* _UIB-CODE-BLOCK-END */
  287. &ANALYZE-RESUME
  288. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  289. ON ROW-ENTRY OF br_table IN FRAME F-Main
  290. DO:
  291. {src/adm2/brsentry.i}
  292. END.
  293. /* _UIB-CODE-BLOCK-END */
  294. &ANALYZE-RESUME
  295. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  296. ON ROW-LEAVE OF br_table IN FRAME F-Main
  297. DO:
  298. {src/adm2/brsleave.i}
  299. END.
  300. /* _UIB-CODE-BLOCK-END */
  301. &ANALYZE-RESUME
  302. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  303. ON SCROLL-NOTIFY OF br_table IN FRAME F-Main
  304. DO:
  305. {src/adm2/brsscrol.i}
  306. END.
  307. /* _UIB-CODE-BLOCK-END */
  308. &ANALYZE-RESUME
  309. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  310. ON START-SEARCH OF br_table IN FRAME F-Main
  311. DO:
  312. { incl/brwstartsearch.i }
  313. END.
  314. /* _UIB-CODE-BLOCK-END */
  315. &ANALYZE-RESUME
  316. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table bTableWin
  317. ON VALUE-CHANGED OF br_table IN FRAME F-Main
  318. DO:
  319. {src/adm2/brschnge.i}
  320. END.
  321. /* _UIB-CODE-BLOCK-END */
  322. &ANALYZE-RESUME
  323. &UNDEFINE SELF-NAME
  324. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK bTableWin
  325. /* *************************** Main Block *************************** */
  326. { incl/brwmainblock.i }
  327. { incl/brwinternproc.i }
  328. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  329. RUN initializeObject.
  330. &ENDIF
  331. /* _UIB-CODE-BLOCK-END */
  332. &ANALYZE-RESUME
  333. /* ********************** Internal Procedures *********************** */
  334. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE destroyObject bTableWin
  335. PROCEDURE destroyObject :
  336. /*------------------------------------------------------------------------------
  337. Purpose: Super Override
  338. Parameters:
  339. Notes:
  340. ------------------------------------------------------------------------------*/
  341. DEF VAR hBrowser AS HANDLE NO-UNDO.
  342. hBrowser = {&BROWSE-NAME}:HANDLE IN FRAME {&FRAME-NAME}.
  343. DYNAMIC-FUNCTION('setBrowserDaten':U, INPUT hBrowser,
  344. INPUT Sektion ) NO-ERROR.
  345. RUN SUPER.
  346. /* Code placed here will execute AFTER standard behavior. */
  347. END PROCEDURE.
  348. /* _UIB-CODE-BLOCK-END */
  349. &ANALYZE-RESUME
  350. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI bTableWin _DEFAULT-DISABLE
  351. PROCEDURE disable_UI :
  352. /*------------------------------------------------------------------------------
  353. Purpose: DISABLE the User Interface
  354. Parameters: <none>
  355. Notes: Here we clean-up the user-interface by deleting
  356. dynamic widgets we have created and/or hide
  357. frames. This procedure is usually called when
  358. we are ready to "clean-up" after running.
  359. ------------------------------------------------------------------------------*/
  360. /* Hide all frames. */
  361. HIDE FRAME F-Main.
  362. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  363. END PROCEDURE.
  364. /* _UIB-CODE-BLOCK-END */
  365. &ANALYZE-RESUME
  366. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_BROWSE bTableWin
  367. PROCEDURE ENTRY_BROWSE :
  368. /*------------------------------------------------------------------------------
  369. Purpose:
  370. Parameters: <none>
  371. Notes:
  372. ------------------------------------------------------------------------------*/
  373. APPLY 'ENTRY' TO {&BROWSE-NAME} IN FRAME {&FRAME-NAME}.
  374. RETURN NO-APPLY.
  375. END PROCEDURE.
  376. /* _UIB-CODE-BLOCK-END */
  377. &ANALYZE-RESUME
  378. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE INAKTIVE_EINAUS bTableWin
  379. PROCEDURE INAKTIVE_EINAUS :
  380. /*------------------------------------------------------------------------------
  381. Purpose:
  382. Parameters: <none>
  383. Notes:
  384. ------------------------------------------------------------------------------*/
  385. DO WITH FRAME {&FRAME-NAME}:
  386. lInaktiv = NOT lInaktiv.
  387. DYNAMIC-FUNCTION('setAnzeigePreisInaktiv':U, lInaktiv) NO-ERROR.
  388. DYNAMIC-FUNCTION('openQuery':U IN hDaten) NO-ERROR.
  389. RETURN NO-APPLY.
  390. END.
  391. END PROCEDURE.
  392. /* _UIB-CODE-BLOCK-END */
  393. &ANALYZE-RESUME
  394. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject bTableWin
  395. PROCEDURE initializeObject :
  396. /*------------------------------------------------------------------------------
  397. Purpose: Super Override
  398. Parameters:
  399. Notes:
  400. ------------------------------------------------------------------------------*/
  401. DEF VAR cName AS CHAR NO-UNDO.
  402. { incl/brwinitialize.i }
  403. hMenu = {&BROWSE-NAME}:HANDLE IN FRAME {&FRAME-NAME}.
  404. hMenu = hMenu:POPUP-MENU NO-ERROR.
  405. hMenu = hMenu:FIRST-CHILD NO-ERROR.
  406. DO WHILE VALID-HANDLE (hMenu):
  407. cName = hMenu:NAME NO-ERROR.
  408. IF cName <> ? AND
  409. INDEX(cName, 'inakt') > 0 THEN DO:
  410. hInaktiv = hMenu.
  411. LEAVE.
  412. END.
  413. hMenu = hMenu:NEXT-SIBLING.
  414. END.
  415. lInaktiv = DYNAMIC-FUNCTION('getAnzeigePreisInaktiv':U) NO-ERROR.
  416. hInaktiv:CHECKED = lInaktiv NO-ERROR.
  417. END PROCEDURE.
  418. /* _UIB-CODE-BLOCK-END */
  419. &ANALYZE-RESUME
  420. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE PREISMUTATION bTableWin
  421. PROCEDURE PREISMUTATION :
  422. /*------------------------------------------------------------------------------
  423. Purpose:
  424. Parameters: <none>
  425. Notes:
  426. ------------------------------------------------------------------------------*/
  427. DEF INPUT PARAMETER ipRecid AS RECID NO-UNDO.
  428. DEF VAR dNetto AS DEC DECIMALS 4 NO-UNDO.
  429. DEF VAR dBrutto AS DEC DECIMALS 4 NO-UNDO.
  430. DEF VAR dMarge AS DEC DECIMALS 4 NO-UNDO.
  431. DEF VAR AbDatum AS DATE NO-UNDO.
  432. FIND ArtPreis WHERE RECID(ArtPreis) = ipRecid NO-LOCK NO-ERROR.
  433. IF NOT AVAILABLE ArtPreis THEN RETURN 'NOT AVAILABLE'.
  434. IF ArtPreis.Aktion = TRUE THEN RETURN 'AKTION'.
  435. dNetto = ArtPreis.VK_Netto.
  436. dBrutto = ArtPreis.VK_Brutto.
  437. dMarge = ArtPreis.Marge.
  438. AbDatum = ArtPreis.Ab_Datum.
  439. RUN 'g-artpreismut.w':U ( INPUT-OUTPUT dNetto ,
  440. INPUT-OUTPUT dBrutto ,
  441. INPUT-OUTPUT dMarge ,
  442. INPUT-OUTPUT AbDatum ).
  443. DO WHILE TRUE:
  444. IF dNetto = ? THEN RETURN 'KEINE MUTATION'.
  445. IF ArtPreis.VK_Netto <> dNetto THEN LEAVE.
  446. IF ArtPreis.VK_Brutto <> dBrutto THEN LEAVE.
  447. IF ArtPreis.Marge <> dMarge THEN LEAVE.
  448. RETURN 'KEINE MUTATION'.
  449. END.
  450. REPEAT TRANSACTION:
  451. FIND ArtPreis WHERE RECID(ArtPreis) = ipRecid.
  452. ASSIGN ArtPreis.VK_Netto = dNetto
  453. ArtPreis.VK_Brutto = dBrutto
  454. ArtPreis.Marge = dMarge.
  455. RELEASE ArtPreis.
  456. LEAVE.
  457. END.
  458. RUN refreshRow IN hDaten.
  459. RETURN ''.
  460. END PROCEDURE.
  461. /* _UIB-CODE-BLOCK-END */
  462. &ANALYZE-RESUME
  463. /* ************************ Function Implementations ***************** */
  464. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION setZeilenfarbe bTableWin
  465. FUNCTION setZeilenfarbe RETURNS LOGICAL
  466. ( ipFarbe AS INT ) :
  467. /*------------------------------------------------------------------------------
  468. Purpose:
  469. Notes:
  470. ------------------------------------------------------------------------------*/
  471. { incl/brwsetzeilenfarbe.i }
  472. END FUNCTION.
  473. /* _UIB-CODE-BLOCK-END */
  474. &ANALYZE-RESUME