v-prodgrp.w 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910
  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-prodgrp.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 Prod_Grp
  31. &Scoped-define LETZTES_FELD Sort_B2C
  32. &Scoped-define KEY_FELDER Prod_Grp
  33. &Scoped-define NUR_LESEN
  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 FCancel AS LOG NO-UNDO INIT FALSE.
  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. /* _UIB-CODE-BLOCK-END */
  46. &ANALYZE-RESUME
  47. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  48. /* ******************** Preprocessor Definitions ******************** */
  49. &Scoped-define PROCEDURE-TYPE SmartDataViewer
  50. &Scoped-define DB-AWARE no
  51. &Scoped-define ADM-CONTAINER FRAME
  52. &Scoped-define ADM-SUPPORTED-LINKS Data-Target,Update-Source,TableIO-Target,GroupAssign-Source,GroupAssign-Target
  53. /* Include file with RowObject temp-table definition */
  54. &Scoped-define DATA-FIELD-DEFS "d-prodgrp.i"
  55. /* Name of designated FRAME-NAME and/or first browse and/or first query */
  56. &Scoped-define FRAME-NAME F-Main
  57. /* Standard List Definitions */
  58. &Scoped-Define ENABLED-FIELDS RowObject.Prod_Grp RowObject.Bez1 ~
  59. RowObject.Bez2 RowObject.Sort_Preisliste RowObject.Titel_Druck ~
  60. RowObject.lShopB2B RowObject.Sort_B2B RowObject.lShopB2C RowObject.Sort_B2C
  61. &Scoped-define ENABLED-TABLES RowObject
  62. &Scoped-define FIRST-ENABLED-TABLE RowObject
  63. &Scoped-Define ENABLED-OBJECTS RECT-5 CB_Verkauf
  64. &Scoped-Define DISPLAYED-FIELDS RowObject.Prod_Grp RowObject.Dec_1 ~
  65. RowObject.Dec_2 RowObject.BezL RowObject.Wgr RowObject.Firma ~
  66. RowObject.Int_2 RowObject.Int_1 RowObject.Bez1 RowObject.Bez2 ~
  67. RowObject.Sort_Preisliste RowObject.Titel_Druck RowObject.lShopB2B ~
  68. RowObject.Sort_B2B RowObject.lShopB2C RowObject.Sort_B2C
  69. &Scoped-define DISPLAYED-TABLES RowObject
  70. &Scoped-define FIRST-DISPLAYED-TABLE RowObject
  71. &Scoped-Define DISPLAYED-OBJECTS CB_Verkauf
  72. /* Custom List Definitions */
  73. /* ADM-ASSIGN-FIELDS,List-2,List-3,List-4,List-5,List-6 */
  74. /* _UIB-PREPROCESSOR-BLOCK-END */
  75. &ANALYZE-RESUME
  76. /* *********************** Control Definitions ********************** */
  77. /* Definitions of the field level widgets */
  78. DEFINE VARIABLE CB_Verkauf AS CHARACTER FORMAT "X(256)":U
  79. LABEL "Verkauf als"
  80. VIEW-AS COMBO-BOX INNER-LINES 5
  81. LIST-ITEM-PAIRS "Verkaufsgebinde","000000",
  82. "Kleingebinde","000001"
  83. DROP-DOWN-LIST
  84. SIZE 36 BY 1
  85. BGCOLOR 15 NO-UNDO.
  86. DEFINE RECTANGLE RECT-5
  87. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  88. SIZE 58 BY 10.95.
  89. /* ************************ Frame Definitions *********************** */
  90. DEFINE FRAME F-Main
  91. RowObject.Prod_Grp AT ROW 1.52 COL 16 COLON-ALIGNED
  92. LABEL "Gruppe"
  93. VIEW-AS FILL-IN NATIVE
  94. SIZE 6 BY 1
  95. BGCOLOR 15
  96. RowObject.Dec_1 AT ROW 2 COL 43 COLON-ALIGNED
  97. VIEW-AS FILL-IN
  98. SIZE 4 BY 1 NO-TAB-STOP
  99. RowObject.Dec_2 AT ROW 2 COL 43 COLON-ALIGNED
  100. VIEW-AS FILL-IN
  101. SIZE 4 BY 1 NO-TAB-STOP
  102. RowObject.BezL AT ROW 2 COL 43 COLON-ALIGNED
  103. VIEW-AS FILL-IN
  104. SIZE 4 BY 1 NO-TAB-STOP
  105. RowObject.Wgr AT ROW 2 COL 43 COLON-ALIGNED
  106. VIEW-AS FILL-IN
  107. SIZE 4 BY 1 NO-TAB-STOP
  108. RowObject.Firma AT ROW 2 COL 43 COLON-ALIGNED
  109. VIEW-AS FILL-IN
  110. SIZE 4 BY 1 NO-TAB-STOP
  111. RowObject.Int_2 AT ROW 2 COL 43 COLON-ALIGNED FORMAT "999999"
  112. VIEW-AS FILL-IN
  113. SIZE 4 BY 1 NO-TAB-STOP
  114. RowObject.Int_1 AT ROW 2 COL 43 COLON-ALIGNED
  115. VIEW-AS FILL-IN
  116. SIZE 4 BY 1 NO-TAB-STOP
  117. RowObject.Bez1 AT ROW 2.52 COL 16 COLON-ALIGNED
  118. LABEL "Bezeichnung" FORMAT "x(35)"
  119. VIEW-AS FILL-IN NATIVE
  120. SIZE 37 BY 1
  121. BGCOLOR 15
  122. RowObject.Bez2 AT ROW 3.52 COL 16 COLON-ALIGNED
  123. LABEL "Internet"
  124. VIEW-AS FILL-IN NATIVE
  125. SIZE 37 BY 1
  126. BGCOLOR 15
  127. CB_Verkauf AT ROW 4.52 COL 16 COLON-ALIGNED WIDGET-ID 6
  128. RowObject.Sort_Preisliste AT ROW 5.52 COL 16 COLON-ALIGNED WIDGET-ID 2
  129. LABEL "Sort Preisliste"
  130. VIEW-AS FILL-IN NATIVE
  131. SIZE 13.6 BY 1
  132. BGCOLOR 15
  133. RowObject.Titel_Druck AT ROW 6.52 COL 18 WIDGET-ID 4
  134. LABEL "Titel_Druck"
  135. VIEW-AS TOGGLE-BOX
  136. SIZE 16 BY 1
  137. RowObject.lShopB2B AT ROW 8 COL 18 WIDGET-ID 8
  138. LABEL "B2B-Shop ?"
  139. VIEW-AS TOGGLE-BOX
  140. SIZE 16 BY 1
  141. RowObject.Sort_B2B AT ROW 9 COL 16 COLON-ALIGNED WIDGET-ID 12
  142. LABEL "Sort B2B"
  143. VIEW-AS FILL-IN NATIVE
  144. SIZE 14 BY 1
  145. BGCOLOR 15
  146. RowObject.lShopB2C AT ROW 10 COL 18 WIDGET-ID 10
  147. LABEL "B2C-Shop"
  148. VIEW-AS TOGGLE-BOX
  149. SIZE 16 BY 1
  150. RowObject.Sort_B2C AT ROW 11 COL 16 COLON-ALIGNED WIDGET-ID 14
  151. LABEL "Sort B2C"
  152. VIEW-AS FILL-IN NATIVE
  153. SIZE 14 BY 1
  154. BGCOLOR 15
  155. RECT-5 AT ROW 1.24 COL 2
  156. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY USE-DICT-EXPS
  157. SIDE-LABELS NO-UNDERLINE THREE-D NO-AUTO-VALIDATE
  158. AT COL 1 ROW 1 SCROLLABLE .
  159. /* *********************** Procedure Settings ************************ */
  160. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  161. /* Settings for THIS-PROCEDURE
  162. Type: SmartDataViewer
  163. Data Source: "d-prodgrp.w"
  164. Allow: Basic,DB-Fields,Smart
  165. Container Links: Data-Target,Update-Source,TableIO-Target,GroupAssign-Source,GroupAssign-Target
  166. Frames: 1
  167. Add Fields to: Neither
  168. Other Settings: PERSISTENT-ONLY COMPILE
  169. Temp-Tables and Buffers:
  170. TABLE: RowObject D "?" ?
  171. ADDITIONAL-FIELDS:
  172. {d-prodgrp.i}
  173. END-FIELDS.
  174. END-TABLES.
  175. */
  176. /* This procedure should always be RUN PERSISTENT. Report the error, */
  177. /* then cleanup and return. */
  178. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  179. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  180. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  181. RETURN.
  182. END.
  183. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  184. /* ************************* Create Window ************************** */
  185. &ANALYZE-SUSPEND _CREATE-WINDOW
  186. /* DESIGN Window definition (used by the UIB)
  187. CREATE WINDOW vTableWin ASSIGN
  188. HEIGHT = 11.43
  189. WIDTH = 60.
  190. /* END WINDOW DEFINITION */
  191. */
  192. &ANALYZE-RESUME
  193. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB vTableWin
  194. /* ************************* Included-Libraries *********************** */
  195. {src/adm2/viewer.i}
  196. /* _UIB-CODE-BLOCK-END */
  197. &ANALYZE-RESUME
  198. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  199. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  200. /* SETTINGS FOR WINDOW vTableWin
  201. VISIBLE,,RUN-PERSISTENT */
  202. /* SETTINGS FOR FRAME F-Main
  203. NOT-VISIBLE FRAME-NAME Size-to-Fit */
  204. ASSIGN
  205. FRAME F-Main:SCROLLABLE = FALSE
  206. FRAME F-Main:HIDDEN = TRUE.
  207. /* SETTINGS FOR FILL-IN RowObject.Bez1 IN FRAME F-Main
  208. EXP-LABEL EXP-FORMAT */
  209. /* SETTINGS FOR FILL-IN RowObject.Bez2 IN FRAME F-Main
  210. EXP-LABEL */
  211. /* SETTINGS FOR FILL-IN RowObject.BezL IN FRAME F-Main
  212. NO-ENABLE */
  213. ASSIGN
  214. RowObject.BezL:HIDDEN IN FRAME F-Main = TRUE
  215. RowObject.BezL:READ-ONLY IN FRAME F-Main = TRUE.
  216. /* SETTINGS FOR FILL-IN RowObject.Dec_1 IN FRAME F-Main
  217. NO-ENABLE */
  218. ASSIGN
  219. RowObject.Dec_1:HIDDEN IN FRAME F-Main = TRUE
  220. RowObject.Dec_1:READ-ONLY IN FRAME F-Main = TRUE.
  221. /* SETTINGS FOR FILL-IN RowObject.Dec_2 IN FRAME F-Main
  222. NO-ENABLE */
  223. ASSIGN
  224. RowObject.Dec_2:HIDDEN IN FRAME F-Main = TRUE
  225. RowObject.Dec_2:READ-ONLY IN FRAME F-Main = TRUE.
  226. /* SETTINGS FOR FILL-IN RowObject.Firma IN FRAME F-Main
  227. NO-ENABLE */
  228. ASSIGN
  229. RowObject.Firma:HIDDEN IN FRAME F-Main = TRUE
  230. RowObject.Firma:READ-ONLY IN FRAME F-Main = TRUE.
  231. /* SETTINGS FOR FILL-IN RowObject.Int_1 IN FRAME F-Main
  232. NO-ENABLE */
  233. ASSIGN
  234. RowObject.Int_1:HIDDEN IN FRAME F-Main = TRUE
  235. RowObject.Int_1:READ-ONLY IN FRAME F-Main = TRUE.
  236. /* SETTINGS FOR FILL-IN RowObject.Int_2 IN FRAME F-Main
  237. NO-ENABLE EXP-FORMAT */
  238. ASSIGN
  239. RowObject.Int_2:HIDDEN IN FRAME F-Main = TRUE
  240. RowObject.Int_2:READ-ONLY IN FRAME F-Main = TRUE.
  241. /* SETTINGS FOR TOGGLE-BOX RowObject.lShopB2B IN FRAME F-Main
  242. EXP-LABEL */
  243. /* SETTINGS FOR TOGGLE-BOX RowObject.lShopB2C IN FRAME F-Main
  244. EXP-LABEL */
  245. /* SETTINGS FOR FILL-IN RowObject.Prod_Grp IN FRAME F-Main
  246. EXP-LABEL */
  247. /* SETTINGS FOR FILL-IN RowObject.Sort_B2B IN FRAME F-Main
  248. EXP-LABEL */
  249. /* SETTINGS FOR FILL-IN RowObject.Sort_B2C IN FRAME F-Main
  250. EXP-LABEL */
  251. /* SETTINGS FOR FILL-IN RowObject.Sort_Preisliste IN FRAME F-Main
  252. EXP-LABEL */
  253. /* SETTINGS FOR TOGGLE-BOX RowObject.Titel_Druck IN FRAME F-Main
  254. EXP-LABEL */
  255. /* SETTINGS FOR FILL-IN RowObject.Wgr IN FRAME F-Main
  256. NO-ENABLE */
  257. ASSIGN
  258. RowObject.Wgr:HIDDEN IN FRAME F-Main = TRUE
  259. RowObject.Wgr:READ-ONLY IN FRAME F-Main = TRUE.
  260. /* _RUN-TIME-ATTRIBUTES-END */
  261. &ANALYZE-RESUME
  262. /* Setting information for Queries and Browse Widgets fields */
  263. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
  264. /* Query rebuild information for FRAME F-Main
  265. _Options = "NO-LOCK"
  266. _Query is NOT OPENED
  267. */ /* FRAME F-Main */
  268. &ANALYZE-RESUME
  269. /* ************************ Control Triggers ************************ */
  270. &Scoped-define SELF-NAME CB_Verkauf
  271. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Verkauf vTableWin
  272. ON VALUE-CHANGED OF CB_Verkauf IN FRAME F-Main /* Verkauf als */
  273. DO:
  274. DO WITH FRAME {&FRAME-NAME}:
  275. IF NOT FMut THEN SELF:SCREEN-VALUE = rowObject.Int_2:SCREEN-VALUE NO-ERROR.
  276. rowObject.Int_2:SCREEN-VALUE = SELF:SCREEN-VALUE.
  277. IF FMut THEN rowObject.Int_2:MODIFIED = TRUE.
  278. END.
  279. END.
  280. /* _UIB-CODE-BLOCK-END */
  281. &ANALYZE-RESUME
  282. &Scoped-define SELF-NAME RowObject.Titel_Druck
  283. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL RowObject.Titel_Druck vTableWin
  284. ON VALUE-CHANGED OF RowObject.Titel_Druck IN FRAME F-Main /* Titel_Druck */
  285. DO:
  286. IF NOT FMut THEN DO:
  287. IF ENTRY(LOOKUP(oldColList, SELF:NAME, ',') + 1, oldColValues, CHR(01)) BEGINS 'n'
  288. THEN SELF:SCREEN-VALUE = STRING(FALSE).
  289. ELSE SELF:SCREEN-VALUE = STRING(TRUE).
  290. END.
  291. END.
  292. /* _UIB-CODE-BLOCK-END */
  293. &ANALYZE-RESUME
  294. &UNDEFINE SELF-NAME
  295. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK vTableWin
  296. /* *************************** Main Block *************************** */
  297. SAktiv = DYNAMIC-FUNCTION('getSuperAktiv':U) NO-ERROR.
  298. IF SAktiv THEN DO:
  299. Firma = DYNAMIC-FUNCTION('GETMANDANT':U) NO-ERROR.
  300. END.
  301. /* Triggers ------------------------------------------------------ */
  302. ON 'RETURN':U OF FRAME {&FRAME-NAME} ANYWHERE
  303. DO:
  304. RUN RETURN_FELD ( INPUT SELF:HANDLE ).
  305. IF RETURN-VALUE = 'TAB' THEN DO:
  306. APPLY 'TAB' TO SELF.
  307. RETURN NO-APPLY.
  308. END.
  309. END.
  310. ON 'ENTRY':U OF FRAME {&FRAME-NAME} ANYWHERE
  311. DO:
  312. RUN ENTRY_FELD_TEST ( INPUT SELF:HANDLE ).
  313. IF RETURN-VALUE = 'ERROR' THEN DO:
  314. APPLY 'ENTRY' TO SELF.
  315. RETURN NO-APPLY.
  316. END.
  317. IF RETURN-VALUE = 'APPLY' THEN DO:
  318. RETURN NO-APPLY.
  319. END.
  320. END.
  321. ON 'LEAVE':U OF FRAME {&FRAME-NAME} ANYWHERE
  322. DO:
  323. RUN LEAVE_FELD_TEST ( INPUT SELF:HANDLE ).
  324. IF RETURN-VALUE = 'ERROR' THEN DO:
  325. APPLY 'ENTRY' TO SELF.
  326. RETURN NO-APPLY.
  327. END.
  328. IF RETURN-VALUE = 'APPLY' THEN DO:
  329. RETURN NO-APPLY.
  330. END.
  331. END.
  332. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  333. RUN initializeObject.
  334. &ENDIF
  335. /************************ INTERNAL PROCEDURES ********************/
  336. /* _UIB-CODE-BLOCK-END */
  337. &ANALYZE-RESUME
  338. /* ********************** Internal Procedures *********************** */
  339. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE addRecord vTableWin
  340. PROCEDURE addRecord :
  341. /*------------------------------------------------------------------------------
  342. Purpose: Super Override
  343. Parameters:
  344. Notes:
  345. ------------------------------------------------------------------------------*/
  346. FNeu = TRUE.
  347. FMut = TRUE.
  348. RUN SUPER.
  349. END PROCEDURE.
  350. /* _UIB-CODE-BLOCK-END */
  351. &ANALYZE-RESUME
  352. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE cancelRecord vTableWin
  353. PROCEDURE cancelRecord :
  354. /*------------------------------------------------------------------------------
  355. Purpose: Super Override
  356. Parameters:
  357. Notes:
  358. ------------------------------------------------------------------------------*/
  359. /* Code placed here will execute PRIOR to standard behavior. */
  360. FCancel = TRUE.
  361. RUN SUPER.
  362. /* Code placed here will execute AFTER standard behavior. */
  363. END PROCEDURE.
  364. /* _UIB-CODE-BLOCK-END */
  365. &ANALYZE-RESUME
  366. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE copyRecord vTableWin
  367. PROCEDURE copyRecord :
  368. /*------------------------------------------------------------------------------
  369. Purpose: Super Override
  370. Parameters:
  371. Notes:
  372. ------------------------------------------------------------------------------*/
  373. FNeu = TRUE.
  374. FMut = TRUE.
  375. FCopy = TRUE.
  376. RUN SUPER.
  377. END PROCEDURE.
  378. /* _UIB-CODE-BLOCK-END */
  379. &ANALYZE-RESUME
  380. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE deleteRecord vTableWin
  381. PROCEDURE deleteRecord :
  382. /*------------------------------------------------------------------------------
  383. Purpose: Super Override
  384. Parameters:
  385. Notes:
  386. ------------------------------------------------------------------------------*/
  387. DEF VAR Ja AS LOG NO-UNDO.
  388. DEF VAR iWgr AS INT NO-UNDO.
  389. DEF VAR iPgr AS INT NO-UNDO.
  390. Ja = DYNAMIC-FUNCTION( 'ANTWORT_JA':U, INPUT 1000 ).
  391. IF NOT Ja THEN DO:
  392. PUBLISH 'TOOLBAR' ( INPUT 'CANCEL':U ).
  393. RETURN NO-APPLY.
  394. END.
  395. iWgr = INTEGER(rowObject.Wgr :SCREEN-VALUE IN FRAME {&FRAME-NAME}).
  396. iPgr = INTEGER(rowObject.Prod_Grp:SCREEN-VALUE IN FRAME {&FRAME-NAME}).
  397. REPEAT TRANSACTION:
  398. RUN SUPER.
  399. FOR EACH ArtikGrp
  400. WHERE ArtikGrp.Firma = Firma
  401. AND ArtikGrp.Wgr = iWgr
  402. AND ArtikGrp.Prod_Grp = iPgr:
  403. DELETE ArtikGrp.
  404. END.
  405. RELEASE ArtikGrp.
  406. LEAVE.
  407. END.
  408. RUN SUPER.
  409. /* Code placed here will execute AFTER standard behavior. */
  410. END PROCEDURE.
  411. /* _UIB-CODE-BLOCK-END */
  412. &ANALYZE-RESUME
  413. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disableFields vTableWin
  414. PROCEDURE disableFields :
  415. /*------------------------------------------------------------------------------
  416. Purpose: Super Override
  417. Parameters:
  418. Notes:
  419. ------------------------------------------------------------------------------*/
  420. DEFINE INPUT PARAMETER pcFieldType AS CHARACTER NO-UNDO.
  421. DO WITH FRAME {&FRAME-NAME}:
  422. END.
  423. RUN SUPER( INPUT pcFieldType).
  424. IF NOT VALID-HANDLE(Fenster) THEN Fenster = FRAME {&FRAME-NAME}:CURRENT-ITERATION.
  425. RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&ENABLED-FIELDS}', INPUT TRUE ).
  426. IF NUM-ENTRIES('{&KEY_FELDER}', ',') > 0 THEN DO:
  427. RUN FARBE_FELDER ( INPUT Fenster, INPUT '{&KEY_FELDER}', INPUT 15 ).
  428. END.
  429. DO WITH FRAME {&FRAME-NAME}:
  430. END.
  431. END PROCEDURE.
  432. /* _UIB-CODE-BLOCK-END */
  433. &ANALYZE-RESUME
  434. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI vTableWin _DEFAULT-DISABLE
  435. PROCEDURE disable_UI :
  436. /*------------------------------------------------------------------------------
  437. Purpose: DISABLE the User Interface
  438. Parameters: <none>
  439. Notes: Here we clean-up the user-interface by deleting
  440. dynamic widgets we have created and/or hide
  441. frames. This procedure is usually called when
  442. we are ready to "clean-up" after running.
  443. ------------------------------------------------------------------------------*/
  444. /* Hide all frames. */
  445. HIDE FRAME F-Main.
  446. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  447. END PROCEDURE.
  448. /* _UIB-CODE-BLOCK-END */
  449. &ANALYZE-RESUME
  450. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE displayFields vTableWin
  451. PROCEDURE displayFields :
  452. /*------------------------------------------------------------------------------
  453. Purpose: Super Override
  454. Parameters:
  455. Notes:
  456. ------------------------------------------------------------------------------*/
  457. DEFINE INPUT PARAMETER pcColValues AS CHARACTER NO-UNDO.
  458. IF FCancel THEN pcColValues = OldColValues.
  459. IF NOT FNeu THEN OldColValues = pcColValues.
  460. OldColList = DYNAMIC-FUNCTION('getDisplayedFields':U).
  461. IF FNeu THEN RUN FEHLWERTE ( INPUT-OUTPUT pcColValues ).
  462. DO WITH FRAME {&FRAME-NAME}:
  463. END.
  464. RUN SUPER( INPUT pcColValues).
  465. FCancel = FALSE.
  466. DO WITH FRAME {&FRAME-NAME}:
  467. CB_Verkauf:SCREEN-VALUE = rowObject.Int_2:SCREEN-VALUE NO-ERROR.
  468. END.
  469. END PROCEDURE.
  470. /* _UIB-CODE-BLOCK-END */
  471. &ANALYZE-RESUME
  472. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableFields vTableWin
  473. PROCEDURE enableFields :
  474. /*------------------------------------------------------------------------------
  475. Purpose: Super Override
  476. Parameters:
  477. Notes:
  478. ------------------------------------------------------------------------------*/
  479. /* Code placed here will execute PRIOR to standard behavior. */
  480. /*
  481. RUN SUPER.
  482. */
  483. IF NOT VALID-HANDLE(Fenster) THEN Fenster = FRAME {&FRAME-NAME}:CURRENT-ITERATION.
  484. RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&ENABLED-FIELDS}', INPUT FALSE ).
  485. IF NUM-ENTRIES('{&NUR_LESEN}', ',') > 0 THEN DO:
  486. RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&NUR_LESEN}', INPUT TRUE ).
  487. END.
  488. DO WITH FRAME {&FRAME-NAME}:
  489. END.
  490. IF FNeu THEN RETURN.
  491. IF NUM-ENTRIES('{&KEY_FELDER}', ',') > 0 THEN DO:
  492. RUN SCHUETZE_FELDER ( INPUT Fenster, INPUT '{&KEY_FELDER}', INPUT TRUE ).
  493. END.
  494. END PROCEDURE.
  495. /* _UIB-CODE-BLOCK-END */
  496. &ANALYZE-RESUME
  497. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject vTableWin
  498. PROCEDURE enableObject :
  499. /*------------------------------------------------------------------------------
  500. Purpose: Super Override
  501. Parameters:
  502. Notes:
  503. ------------------------------------------------------------------------------*/
  504. RUN SUPER.
  505. IF NOT VALID-HANDLE(Fenster) THEN Fenster = FRAME {&FRAME-NAME}:CURRENT-ITERATION.
  506. IF SAktiv THEN DO:
  507. RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&ENABLED-FIELDS}', INPUT TRUE ).
  508. END.
  509. END PROCEDURE.
  510. /* _UIB-CODE-BLOCK-END */
  511. &ANALYZE-RESUME
  512. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_FELD_TEST vTableWin
  513. PROCEDURE ENTRY_FELD_TEST :
  514. /*------------------------------------------------------------------------------
  515. Purpose:
  516. Parameters: <none>
  517. Notes:
  518. ------------------------------------------------------------------------------*/
  519. DEF INPUT PARAMETER ipHandle AS HANDLE NO-UNDO.
  520. DEF VAR FeldName AS CHAR NO-UNDO.
  521. DEF VAR FeldInhalt AS CHAR NO-UNDO.
  522. FeldName = ''.
  523. FeldInhalt = ''.
  524. IF NOT VALID-HANDLE(ipHandle) THEN RETURN ''.
  525. IF ipHandle:TYPE = 'FRAME' THEN RETURN ''.
  526. IF ipHandle:TYPE = 'WINDOW' THEN RETURN ''.
  527. FeldName = ipHandle:NAME.
  528. IF ipHandle:TYPE = 'FILL-IN' OR
  529. ipHandle:TYPE = 'COMBO-BOX' OR
  530. ipHandle:TYPE = 'TOGGLE-BOX' THEN FeldInhalt = ipHandle:SCREEN-VALUE.
  531. RETURN ''.
  532. END PROCEDURE.
  533. /* _UIB-CODE-BLOCK-END */
  534. &ANALYZE-RESUME
  535. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE FEHLWERTE vTableWin
  536. PROCEDURE FEHLWERTE :
  537. /*------------------------------------------------------------------------------
  538. Purpose:
  539. Parameters: <none>
  540. Notes:
  541. ------------------------------------------------------------------------------*/
  542. DEF INPUT-OUTPUT PARAMETER pcColValues AS CHAR NO-UNDO.
  543. DEF VAR FwFelder AS CHAR NO-UNDO.
  544. DEF VAR FwFeld AS CHAR NO-UNDO.
  545. DEF VAR FwValue AS CHAR NO-UNDO.
  546. DEF VAR ix AS INT NO-UNDO.
  547. DEF VAR i1 AS INT NO-UNDO.
  548. DEF VAR Wgr AS INT NO-UNDO.
  549. IF FCancel = TRUE THEN RETURN.
  550. GET-KEY-VALUE SECTION 'Fw???????' KEY ? VALUE FwFelder.
  551. IF NOT FCopy THEN DO:
  552. DO ix = 1 TO NUM-ENTRIES(FwFelder, ','):
  553. FwFeld = ENTRY (ix , FwFelder , ',').
  554. i1 = LOOKUP(FwFeld, oldColList, ',') + 1.
  555. IF i1 < 2 THEN NEXT.
  556. GET-KEY-VALUE SECTION 'Fw???????' KEY FwFeld VALUE FwValue.
  557. ENTRY(i1, pcColValues, CHR(1)) = FwValue NO-ERROR.
  558. END.
  559. i1 = LOOKUP ('Wgr' , oldColList, ',') + 1.
  560. Wgr = INTEGER(ENTRY(i1, pcColValues, CHR(1))) NO-ERROR.
  561. DO ix = 1 TO 999:
  562. IF CAN-FIND ( Prodgrp WHERE Prodgrp.Firma = Firma
  563. AND Prodgrp.Wgr = Wgr
  564. AND Prodgrp.Prod_Grp = ix NO-LOCK )
  565. THEN NEXT.
  566. i1 = LOOKUP('Prod_Grp', oldColList, ',') + 1.
  567. ENTRY(i1, pcColValues, CHR(1)) = STRING(ix) NO-ERROR.
  568. LEAVE.
  569. END.
  570. END.
  571. IF FCopy THEN DO:
  572. END.
  573. END PROCEDURE.
  574. /* _UIB-CODE-BLOCK-END */
  575. &ANALYZE-RESUME
  576. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE LEAVE_FELD_TEST vTableWin
  577. PROCEDURE LEAVE_FELD_TEST :
  578. /*------------------------------------------------------------------------------
  579. Purpose:
  580. Parameters: <none>
  581. Notes:
  582. ------------------------------------------------------------------------------*/
  583. DEF INPUT PARAMETER ipHandle AS HANDLE NO-UNDO.
  584. DEF VAR FeldName AS CHAR NO-UNDO.
  585. DEF VAR FeldInhalt AS CHAR NO-UNDO.
  586. DEF VAR ix AS INT NO-UNDO.
  587. DEF VAR LKY AS INT NO-UNDO.
  588. DEF VAR hLEAVE AS HANDLE NO-UNDO.
  589. DEF VAR hENTER AS HANDLE NO-UNDO.
  590. DEF VAR Daten AS CHAR NO-UNDO.
  591. IF FMut = FALSE THEN RETURN ''.
  592. LKY = LASTKEY.
  593. hENTER = LAST-EVENT:WIDGET-ENTER.
  594. hLEAVE = LAST-EVENT:WIDGET-LEAVE.
  595. FeldName = ''.
  596. FeldInhalt = ''.
  597. IF NOT VALID-HANDLE(ipHandle) THEN RETURN ''.
  598. IF ipHandle:TYPE = 'FRAME' THEN RETURN ''.
  599. IF ipHandle:TYPE = 'WINDOW' THEN RETURN ''.
  600. FeldName = ipHandle:NAME.
  601. IF ipHandle:TYPE = 'FILL-IN' OR
  602. ipHandle:TYPE = 'COMBO-BOX' OR
  603. ipHandle:TYPE = 'TOGGLE-BOX' THEN FeldInhalt = ipHandle:SCREEN-VALUE.
  604. DO WHILE FNeu WITH FRAME {&FRAME-NAME}:
  605. CASE FeldName:
  606. WHEN 'Prod_Grp' THEN DO:
  607. RUN FIND_PRODGRP ( INPUT INTEGER(rowObject.Wgr:SCREEN-VALUE),
  608. INPUT INTEGER(FeldInhalt),
  609. OUTPUT Daten ).
  610. IF Daten <> '?' THEN DO:
  611. RUN FEHLER ( INPUT 1023 ).
  612. RETURN 'ERROR'.
  613. END.
  614. END.
  615. END CASE.
  616. LEAVE.
  617. END.
  618. IF LOOKUP(FeldName, '{&LETZTES_FELD}', ',') > 0 THEN DO:
  619. DO WHILE TRUE:
  620. IF KEYFUNCTION(LKY) = 'TAB' THEN LEAVE.
  621. IF KEYFUNCTION(LKY) = 'RETURN' THEN LEAVE.
  622. IF KEYFUNCTION(LKY) = 'F9' THEN LEAVE.
  623. RETURN ''.
  624. END.
  625. APPLY 'ALT-S'.
  626. RETURN 'APPLY'.
  627. END.
  628. RETURN ''.
  629. END PROCEDURE.
  630. /* _UIB-CODE-BLOCK-END */
  631. &ANALYZE-RESUME
  632. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE RETURN_FELD vTableWin
  633. PROCEDURE RETURN_FELD :
  634. /*------------------------------------------------------------------------------
  635. Purpose:
  636. Parameters: <none>
  637. Notes:
  638. ------------------------------------------------------------------------------*/
  639. DEF INPUT PARAMETER ipHandle AS HANDLE NO-UNDO.
  640. DEF VAR FeldName AS CHAR NO-UNDO.
  641. IF FMut = FALSE THEN RETURN ''.
  642. IF NOT VALID-HANDLE(ipHandle) THEN RETURN ''.
  643. IF ipHandle:TYPE = 'FRAME' THEN RETURN ''.
  644. IF ipHandle:TYPE = 'WINDOW' THEN RETURN ''.
  645. FeldName = ipHandle:NAME.
  646. IF LOOKUP(FeldName, '{&ENABLED-FIELDS}', ' ') > 0 THEN DO:
  647. RETURN 'TAB'.
  648. END.
  649. IF LOOKUP(FeldName, '{&ENABLED-OBJECTS}', ' ') > 0 THEN DO:
  650. RETURN 'TAB'.
  651. END.
  652. FeldName = 'rowObject.' + FeldName.
  653. IF LOOKUP(FeldName, '{&ENABLED-FIELDS}', ' ') > 0 THEN DO:
  654. RETURN 'TAB'.
  655. END.
  656. IF LOOKUP(FeldName, '{&ENABLED-OBJECTS}', ' ') > 0 THEN DO:
  657. RETURN 'TAB'.
  658. END.
  659. RETURN ''.
  660. END PROCEDURE.
  661. /* _UIB-CODE-BLOCK-END */
  662. &ANALYZE-RESUME
  663. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE updateMode vTableWin
  664. PROCEDURE updateMode :
  665. /*------------------------------------------------------------------------------
  666. Purpose: Super Override
  667. Parameters:
  668. Notes:
  669. ------------------------------------------------------------------------------*/
  670. DEFINE INPUT PARAMETER pcMode AS CHARACTER NO-UNDO.
  671. CASE pcMode:
  672. WHEN 'updateBegin' THEN DO:
  673. END.
  674. WHEN 'updateEnd' THEN DO:
  675. END.
  676. END.
  677. RUN SUPER( INPUT pcMode).
  678. CASE pcMode:
  679. WHEN 'updateBegin' THEN DO:
  680. FMut = TRUE.
  681. END.
  682. WHEN 'updateEnd' THEN DO:
  683. FNeu = FALSE.
  684. FMut = FALSE.
  685. FCopy = FALSE.
  686. END.
  687. END.
  688. END PROCEDURE.
  689. /* _UIB-CODE-BLOCK-END */
  690. &ANALYZE-RESUME
  691. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE updateRecord vTableWin
  692. PROCEDURE updateRecord :
  693. /*------------------------------------------------------------------------------
  694. Purpose: Super Override
  695. Parameters:
  696. Notes:
  697. ------------------------------------------------------------------------------*/
  698. DO WITH FRAME {&FRAME-NAME}:
  699. rowObject.Firma:SCREEN-VALUE = Firma.
  700. rowObject.Int_2:SCREEN-VALUE = CB_Verkauf:SCREEN-VALUE.
  701. IF rowObject.Sort_Preisliste:SCREEN-VALUE = ''
  702. THEN rowObject.Sort_Preisliste:SCREEN-VALUE = STRING(INTEGER(rowObject.Prod_Grp:SCREEN-VALUE),'9999').
  703. END.
  704. RUN SUPER.
  705. /* Code placed here will execute AFTER standard behavior. */
  706. END PROCEDURE.
  707. /* _UIB-CODE-BLOCK-END */
  708. &ANALYZE-RESUME