f-aufkoberech.w 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872
  1. &ANALYZE-SUSPEND _VERSION-NUMBER UIB_v8r12 GUI ADM1
  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 F-Frame-Win
  8. /*------------------------------------------------------------------------
  9. File:
  10. Description: from cntnrfrm.w - ADM SmartFrame Template
  11. Input Parameters:
  12. <none>
  13. Output Parameters:
  14. <none>
  15. ------------------------------------------------------------------------*/
  16. /* This .W file was created with the Progress UIB. */
  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. { v8/aufkototv.i "NEW" "SHARED" }
  28. DEF VAR ARecid AS RECID NO-UNDO.
  29. DEF VAR VAdresse AS CHAR NO-UNDO.
  30. DEF VAR QOpen AS LOG NO-UNDO.
  31. DEF VAR Vorhanden AS LOG NO-UNDO.
  32. DEF VAR XZahart AS CHAR NO-UNDO.
  33. DEF VAR VZahArt AS INT NO-UNDO.
  34. DEF VAR VKonto AS CHAR NO-UNDO.
  35. DEF VAR xx AS INT NO-UNDO.
  36. DEF VAR OK AS LOG NO-UNDO.
  37. DEF BUFFER BAufko FOR Aufko.
  38. DEF BUFFER BAufze FOR Aufze.
  39. DEF BUFFER BAufGebKo FOR AufGebKo.
  40. DEF BUFFER FDebst FOR Debst.
  41. DEF BUFFER LDebst FOR Debst.
  42. /* ---------- Globale Variablen ---------------------------------- */
  43. { v8/globvar.i" " " " "SHARED" }
  44. { v8/debivar.i " " " " "SHARED" }
  45. { v8/artivar.i " " " " "SHARED" }
  46. { v8/contvar.i " " " " "SHARED" }
  47. /* _UIB-CODE-BLOCK-END */
  48. &ANALYZE-RESUME
  49. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  50. /* ******************** Preprocessor Definitions ******************** */
  51. &Scoped-define PROCEDURE-TYPE SmartFrame
  52. &Scoped-define DB-AWARE no
  53. &Scoped-define ADM-CONTAINER FRAME
  54. /* Name of designated FRAME-NAME and/or first browse and/or first query */
  55. &Scoped-define FRAME-NAME F-Main
  56. &Scoped-define BROWSE-NAME Br_Bezahlen
  57. /* Internal Tables (found by Frame, Query & Browse Queries) */
  58. &Scoped-define INTERNAL-TABLES Aufko Tabel
  59. /* Definitions for BROWSE Br_Bezahlen */
  60. &Scoped-define FIELDS-IN-QUERY-Br_Bezahlen Aufko.Aufnr Aufko.Faknr ~
  61. Aufko.Fak_Art Aufko.Fak_Knr VAdresse @ VAdresse Aufko.Fak_Datum ~
  62. Aufko.Auf_Tot Aufko.Bar_Betr
  63. &Scoped-define ENABLED-FIELDS-IN-QUERY-Br_Bezahlen
  64. &Scoped-define QUERY-STRING-Br_Bezahlen FOR EACH Aufko ~
  65. WHERE Aufko.Firma = GVFirma ~
  66. AND Aufko.Faknr > 0 NO-LOCK, ~
  67. EACH Tabel WHERE TRUE /* Join to Aufko incomplete */ NO-LOCK
  68. &Scoped-define OPEN-QUERY-Br_Bezahlen OPEN QUERY Br_Bezahlen FOR EACH Aufko ~
  69. WHERE Aufko.Firma = GVFirma ~
  70. AND Aufko.Faknr > 0 NO-LOCK, ~
  71. EACH Tabel WHERE TRUE /* Join to Aufko incomplete */ NO-LOCK.
  72. &Scoped-define TABLES-IN-QUERY-Br_Bezahlen Aufko Tabel
  73. &Scoped-define FIRST-TABLE-IN-QUERY-Br_Bezahlen Aufko
  74. &Scoped-define SECOND-TABLE-IN-QUERY-Br_Bezahlen Tabel
  75. /* Definitions for FRAME F-Main */
  76. /* Standard List Definitions */
  77. &Scoped-Define ENABLED-OBJECTS Br_Bezahlen CB-Zahart RECT-35
  78. &Scoped-Define DISPLAYED-OBJECTS CB-Zahart F_WW F_Gebinde F_Recycling ~
  79. F_MWST F_Total F_Skonto F_Netto F_Saldo F_Zahbetr F_Bezahlt E_Adresse ~
  80. F_ZahSko F_Skonto_Bez F_Aufnr
  81. /* Custom List Definitions */
  82. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  83. &Scoped-define List-1 F_WW F_Gebinde F_Recycling F_MWST F_Total F_Skonto ~
  84. F_Netto F_Saldo F_Zahbetr F_Bezahlt E_Adresse F_ZahSko F_Skonto_Bez F_Aufnr
  85. &Scoped-define List-6 F_WW F_Gebinde F_Recycling F_MWST F_Total F_Skonto ~
  86. F_Netto F_Saldo F_Zahbetr F_Bezahlt F_ZahSko F_Skonto_Bez
  87. /* _UIB-PREPROCESSOR-BLOCK-END */
  88. &ANALYZE-RESUME
  89. /* *********************** Control Definitions ********************** */
  90. /* Definitions of the field level widgets */
  91. DEFINE BUTTON Btn_Bezahlt
  92. LABEL "&Bezahlen"
  93. SIZE 14 BY 1.
  94. DEFINE VARIABLE CB-Zahart AS CHARACTER FORMAT "X(256)":U
  95. LABEL "Zahlungsart"
  96. VIEW-AS COMBO-BOX INNER-LINES 5
  97. DROP-DOWN-LIST
  98. SIZE 28 BY 1
  99. BGCOLOR 15 NO-UNDO.
  100. DEFINE VARIABLE E_Adresse AS CHARACTER
  101. VIEW-AS EDITOR NO-WORD-WRAP MAX-CHARS 500
  102. SIZE 50 BY 5.43
  103. BGCOLOR 15 FONT 6 NO-UNDO.
  104. DEFINE VARIABLE F_Aufnr AS INTEGER FORMAT "9999999":U INITIAL 0
  105. LABEL "Auftragsnummer"
  106. VIEW-AS FILL-IN NATIVE
  107. SIZE 10 BY 1
  108. BGCOLOR 15 NO-UNDO.
  109. DEFINE VARIABLE F_Bezahlt AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  110. LABEL "Bezahlt"
  111. VIEW-AS FILL-IN NATIVE
  112. SIZE 18 BY 1
  113. BGCOLOR 14 NO-UNDO.
  114. DEFINE VARIABLE F_Gebinde AS DECIMAL FORMAT "zz,zz9.999-":U INITIAL 0
  115. LABEL "Gebinde"
  116. VIEW-AS FILL-IN NATIVE
  117. SIZE 18 BY 1
  118. BGCOLOR 15 NO-UNDO.
  119. DEFINE VARIABLE F_MWST AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  120. LABEL "Mehrwertsteuer"
  121. VIEW-AS FILL-IN NATIVE
  122. SIZE 18 BY 1
  123. BGCOLOR 15 NO-UNDO.
  124. DEFINE VARIABLE F_Netto AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  125. LABEL "Nettobetrag"
  126. VIEW-AS FILL-IN NATIVE
  127. SIZE 18 BY 1
  128. BGCOLOR 15 NO-UNDO.
  129. DEFINE VARIABLE F_Recycling AS DECIMAL FORMAT "zz,zz9.999-":U INITIAL 0
  130. LABEL "Gebühren"
  131. VIEW-AS FILL-IN NATIVE
  132. SIZE 18 BY 1
  133. BGCOLOR 15 NO-UNDO.
  134. DEFINE VARIABLE F_Saldo AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  135. LABEL "Saldo"
  136. VIEW-AS FILL-IN NATIVE
  137. SIZE 18 BY 1
  138. BGCOLOR 14 NO-UNDO.
  139. DEFINE VARIABLE F_Skonto AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  140. LABEL "Skonto"
  141. VIEW-AS FILL-IN NATIVE
  142. SIZE 18 BY 1
  143. BGCOLOR 15 NO-UNDO.
  144. DEFINE VARIABLE F_Skonto_Bez AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  145. LABEL "Skontoabzug"
  146. VIEW-AS FILL-IN NATIVE
  147. SIZE 18 BY 1
  148. BGCOLOR 14 NO-UNDO.
  149. DEFINE VARIABLE F_Total AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  150. LABEL "Totalbetrag"
  151. VIEW-AS FILL-IN NATIVE
  152. SIZE 18 BY 1
  153. BGCOLOR 15 NO-UNDO.
  154. DEFINE VARIABLE F_WW AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  155. LABEL "Warenwert"
  156. VIEW-AS FILL-IN NATIVE
  157. SIZE 18 BY 1
  158. BGCOLOR 15 NO-UNDO.
  159. DEFINE VARIABLE F_Zahbetr AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  160. LABEL "Zahlbetrag"
  161. VIEW-AS FILL-IN NATIVE
  162. SIZE 18 BY 1
  163. BGCOLOR 15 NO-UNDO.
  164. DEFINE VARIABLE F_ZahSko AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  165. LABEL "Skonto"
  166. VIEW-AS FILL-IN NATIVE
  167. SIZE 18 BY 1
  168. BGCOLOR 15 NO-UNDO.
  169. DEFINE RECTANGLE RECT-35
  170. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  171. SIZE 122.2 BY 21.29.
  172. /* Query definitions */
  173. &ANALYZE-SUSPEND
  174. DEFINE QUERY Br_Bezahlen FOR
  175. Aufko,
  176. Tabel SCROLLING.
  177. &ANALYZE-RESUME
  178. /* Browse definitions */
  179. DEFINE BROWSE Br_Bezahlen
  180. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_Bezahlen F-Frame-Win _STRUCTURED
  181. QUERY Br_Bezahlen NO-LOCK DISPLAY
  182. Aufko.Aufnr FORMAT "9999999":U
  183. Aufko.Faknr COLUMN-LABEL "FakNr" FORMAT "9999999":U
  184. Aufko.Fak_Art COLUMN-LABEL "Art" FORMAT "99":U
  185. Aufko.Fak_Knr COLUMN-LABEL "Knr" FORMAT "999999":U
  186. VAdresse @ VAdresse COLUMN-LABEL "Kunde" FORMAT "x(30)":U
  187. Aufko.Fak_Datum COLUMN-LABEL "Fak.Datum" FORMAT "99.99.9999":U
  188. Aufko.Auf_Tot COLUMN-LABEL "Total" FORMAT "zzz,zz9.99-":U
  189. Aufko.Bar_Betr COLUMN-LABEL "Bezahlt" FORMAT "zzz,zz9.99-":U
  190. /* _UIB-CODE-BLOCK-END */
  191. &ANALYZE-RESUME
  192. WITH NO-ASSIGN NO-ROW-MARKERS SEPARATORS SIZE 98.8 BY 7.52
  193. BGCOLOR 15 .
  194. /* ************************ Frame Definitions *********************** */
  195. DEFINE FRAME F-Main
  196. Br_Bezahlen AT ROW 1.62 COL 3
  197. CB-Zahart AT ROW 18.52 COL 18 COLON-ALIGNED
  198. F_WW AT ROW 10 COL 18 COLON-ALIGNED
  199. F_Gebinde AT ROW 11 COL 18 COLON-ALIGNED
  200. F_Recycling AT ROW 12 COL 18 COLON-ALIGNED
  201. F_MWST AT ROW 13 COL 18 COLON-ALIGNED
  202. F_Total AT ROW 14 COL 18 COLON-ALIGNED
  203. F_Skonto AT ROW 15 COL 18 COLON-ALIGNED
  204. F_Netto AT ROW 16 COL 18 COLON-ALIGNED
  205. F_Saldo AT ROW 17 COL 18 COLON-ALIGNED
  206. F_Zahbetr AT ROW 20 COL 18 COLON-ALIGNED
  207. F_Bezahlt AT ROW 21 COL 18 COLON-ALIGNED
  208. E_Adresse AT ROW 11 COL 50 NO-LABEL
  209. F_ZahSko AT ROW 20 COL 58 COLON-ALIGNED
  210. F_Skonto_Bez AT ROW 21.1 COL 58 COLON-ALIGNED
  211. F_Aufnr AT ROW 10 COL 88 COLON-ALIGNED
  212. Btn_Bezahlt AT ROW 20 COL 86
  213. RECT-35 AT ROW 1.24 COL 2
  214. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
  215. SIDE-LABELS NO-UNDERLINE THREE-D
  216. AT COL 1 ROW 1 SCROLLABLE .
  217. /* *********************** Procedure Settings ************************ */
  218. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  219. /* Settings for THIS-PROCEDURE
  220. Type: SmartFrame
  221. Allow: Basic,Browse,DB-Fields,Query,Smart
  222. Other Settings: PERSISTENT-ONLY COMPILE
  223. */
  224. /* This procedure should always be RUN PERSISTENT. Report the error, */
  225. /* then cleanup and return. */
  226. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  227. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  228. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  229. RETURN.
  230. END.
  231. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  232. /* ************************* Create Window ************************** */
  233. &ANALYZE-SUSPEND _CREATE-WINDOW
  234. /* DESIGN Window definition (used by the UIB)
  235. CREATE WINDOW F-Frame-Win ASSIGN
  236. HEIGHT = 21.62
  237. WIDTH = 123.8.
  238. /* END WINDOW DEFINITION */
  239. */
  240. &ANALYZE-RESUME
  241. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB F-Frame-Win
  242. /* ************************* Included-Libraries *********************** */
  243. {src/adm/method/containr.i}
  244. /* _UIB-CODE-BLOCK-END */
  245. &ANALYZE-RESUME
  246. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  247. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  248. /* SETTINGS FOR WINDOW F-Frame-Win
  249. VISIBLE,,RUN-PERSISTENT */
  250. /* SETTINGS FOR FRAME F-Main
  251. NOT-VISIBLE FRAME-NAME Size-to-Fit Custom */
  252. /* BROWSE-TAB Br_Bezahlen 1 F-Main */
  253. ASSIGN
  254. FRAME F-Main:SCROLLABLE = FALSE.
  255. /* SETTINGS FOR BUTTON Btn_Bezahlt IN FRAME F-Main
  256. NO-ENABLE */
  257. /* SETTINGS FOR EDITOR E_Adresse IN FRAME F-Main
  258. NO-ENABLE 1 */
  259. ASSIGN
  260. E_Adresse:RETURN-INSERTED IN FRAME F-Main = TRUE
  261. E_Adresse:READ-ONLY IN FRAME F-Main = TRUE.
  262. /* SETTINGS FOR FILL-IN F_Aufnr IN FRAME F-Main
  263. NO-ENABLE 1 */
  264. /* SETTINGS FOR FILL-IN F_Bezahlt IN FRAME F-Main
  265. NO-ENABLE 1 6 */
  266. /* SETTINGS FOR FILL-IN F_Gebinde IN FRAME F-Main
  267. NO-ENABLE 1 6 */
  268. /* SETTINGS FOR FILL-IN F_MWST IN FRAME F-Main
  269. NO-ENABLE 1 6 */
  270. /* SETTINGS FOR FILL-IN F_Netto IN FRAME F-Main
  271. NO-ENABLE 1 6 */
  272. /* SETTINGS FOR FILL-IN F_Recycling IN FRAME F-Main
  273. NO-ENABLE 1 6 */
  274. /* SETTINGS FOR FILL-IN F_Saldo IN FRAME F-Main
  275. NO-ENABLE 1 6 */
  276. /* SETTINGS FOR FILL-IN F_Skonto IN FRAME F-Main
  277. NO-ENABLE 1 6 */
  278. /* SETTINGS FOR FILL-IN F_Skonto_Bez IN FRAME F-Main
  279. NO-ENABLE 1 6 */
  280. /* SETTINGS FOR FILL-IN F_Total IN FRAME F-Main
  281. NO-ENABLE 1 6 */
  282. /* SETTINGS FOR FILL-IN F_WW IN FRAME F-Main
  283. NO-ENABLE 1 6 */
  284. /* SETTINGS FOR FILL-IN F_Zahbetr IN FRAME F-Main
  285. NO-ENABLE 1 6 */
  286. /* SETTINGS FOR FILL-IN F_ZahSko IN FRAME F-Main
  287. NO-ENABLE 1 6 */
  288. /* _RUN-TIME-ATTRIBUTES-END */
  289. &ANALYZE-RESUME
  290. /* Setting information for Queries and Browse Widgets fields */
  291. &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_Bezahlen
  292. /* Query rebuild information for BROWSE Br_Bezahlen
  293. _TblList = "AnaDat.Aufko,AnaDat.Tabel WHERE AnaDat.Aufko ..."
  294. _Options = "NO-LOCK"
  295. _Where[1] = "Aufko.Firma = GVFirma
  296. AND Aufko.Faknr > 0"
  297. _FldNameList[1] = AnaDat.Aufko.Aufnr
  298. _FldNameList[2] > AnaDat.Aufko.Faknr
  299. "Aufko.Faknr" "FakNr" ? "integer" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  300. _FldNameList[3] > AnaDat.Aufko.Fak_Art
  301. "Aufko.Fak_Art" "Art" ? "integer" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  302. _FldNameList[4] > AnaDat.Aufko.Fak_Knr
  303. "Aufko.Fak_Knr" "Knr" ? "integer" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  304. _FldNameList[5] > "_<CALC>"
  305. "VAdresse @ VAdresse" "Kunde" "x(30)" ? ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  306. _FldNameList[6] > AnaDat.Aufko.Fak_Datum
  307. "Aufko.Fak_Datum" "Fak.Datum" ? "date" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  308. _FldNameList[7] > AnaDat.Aufko.Auf_Tot
  309. "Aufko.Auf_Tot" "Total" "zzz,zz9.99-" "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  310. _FldNameList[8] > AnaDat.Aufko.Bar_Betr
  311. "Aufko.Bar_Betr" "Bezahlt" "zzz,zz9.99-" "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  312. _Query is NOT OPENED
  313. */ /* BROWSE Br_Bezahlen */
  314. &ANALYZE-RESUME
  315. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
  316. /* Query rebuild information for FRAME F-Main
  317. _Options = ""
  318. _Query is NOT OPENED
  319. */ /* FRAME F-Main */
  320. &ANALYZE-RESUME
  321. /* ************************ Control Triggers ************************ */
  322. &Scoped-define BROWSE-NAME Br_Bezahlen
  323. &Scoped-define SELF-NAME Br_Bezahlen
  324. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Bezahlen F-Frame-Win
  325. ON RETURN OF Br_Bezahlen IN FRAME F-Main
  326. DO:
  327. DO WITH FRAME {&FRAME-NAME}:
  328. ENABLE F_ZahBetr F_ZahSko.
  329. F_ZahBetr = F_Netto.
  330. F_ZahSko = F_Skonto.
  331. DISPLAY F_ZahBetr F_ZahSko.
  332. ENABLE Btn_Bezahlt.
  333. APPLY 'ENTRY' TO F_ZahBetr.
  334. END.
  335. END.
  336. /* _UIB-CODE-BLOCK-END */
  337. &ANALYZE-RESUME
  338. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Bezahlen F-Frame-Win
  339. ON ROW-DISPLAY OF Br_Bezahlen IN FRAME F-Main
  340. DO:
  341. RUN ADRESSE.
  342. END.
  343. /* _UIB-CODE-BLOCK-END */
  344. &ANALYZE-RESUME
  345. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Bezahlen F-Frame-Win
  346. ON VALUE-CHANGED OF Br_Bezahlen IN FRAME F-Main
  347. DO:
  348. RUN ANZEIGE.
  349. END.
  350. /* _UIB-CODE-BLOCK-END */
  351. &ANALYZE-RESUME
  352. &Scoped-define SELF-NAME Btn_Bezahlt
  353. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Bezahlt F-Frame-Win
  354. ON CHOOSE OF Btn_Bezahlt IN FRAME F-Main /* Bezahlen */
  355. DO:
  356. DO TRANSACTION WITH FRAME {&FRAME-NAME}:
  357. ASSIGN {&list-1}.
  358. VKonto = CB-Zahart:SCREEN-VALUE.
  359. IF VKonto = 'XXXXXX' THEN DO:
  360. BELL.
  361. MESSAGE 'Kein Konto gewählt ! ' VIEW-AS ALERT-BOX ERROR.
  362. APPLY 'ENTRY' TO CB-Zahart.
  363. RETURN NO-APPLY.
  364. END.
  365. FIND Aufko WHERE RECID(Aufko) = ARecid.
  366. Aufko.Bar_Betr = F_Zahbetr.
  367. Aufko.Bar_Skonto = F_ZahSko.
  368. Aufko.Bar_Konto = VKonto.
  369. F_Zahbetr = 0.
  370. F_ZahSko = 0.
  371. F_Bezahlt = Aufko.Bar_Betr.
  372. F_Skonto_Bez = Aufko.Bar_Skonto.
  373. DISPLAY {&List-1}.
  374. RELEASE Aufko.
  375. DISABLE Btn_Bezahlt F_ZahBetr F_ZahSko.
  376. Br_Bezahlen:REFRESH().
  377. LEAVE.
  378. END.
  379. FIND Aufko WHERE RECID(Aufko) = ARecid NO-LOCK.
  380. APPLY 'ENTRY' TO Br_Bezahlen.
  381. RETURN NO-APPLY.
  382. END.
  383. /* _UIB-CODE-BLOCK-END */
  384. &ANALYZE-RESUME
  385. &Scoped-define SELF-NAME CB-Zahart
  386. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB-Zahart F-Frame-Win
  387. ON RETURN OF CB-Zahart IN FRAME F-Main /* Zahlungsart */
  388. DO:
  389. APPLY 'TAB' TO SELF.
  390. RETURN NO-APPLY.
  391. END.
  392. /* _UIB-CODE-BLOCK-END */
  393. &ANALYZE-RESUME
  394. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB-Zahart F-Frame-Win
  395. ON VALUE-CHANGED OF CB-Zahart IN FRAME F-Main /* Zahlungsart */
  396. DO:
  397. VKonto = SELF:SCREEN-VALUE.
  398. END.
  399. /* _UIB-CODE-BLOCK-END */
  400. &ANALYZE-RESUME
  401. &UNDEFINE SELF-NAME
  402. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK F-Frame-Win
  403. /* *************************** Main Block *************************** */
  404. SUBSCRIBE TO 'ENDEAUFTRAG' ANYWHERE.
  405. ON END-ERROR OF F_ZahBetr, F_ZahSko, Btn_Bezahlt IN FRAME {&FRAME-NAME}
  406. DO:
  407. DO TRANSACTION WITH FRAME {&FRAME-NAME}:
  408. F_Zahbetr = 0.
  409. F_ZahSko = 0.
  410. F_Bezahlt = Aufko.Bar_Betr.
  411. F_Skonto_Bez = Aufko.Bar_Skonto.
  412. DISPLAY {&List-1}.
  413. DISABLE Btn_Bezahlt F_ZahBetr F_ZahSko.
  414. LEAVE.
  415. END.
  416. END.
  417. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  418. /* Now enable the interface if in test mode - otherwise this happens when
  419. the object is explicitly initialized from its container. */
  420. RUN dispatch IN THIS-PROCEDURE ('initialize':U).
  421. &ENDIF
  422. /* _UIB-CODE-BLOCK-END */
  423. &ANALYZE-RESUME
  424. /* ********************** Internal Procedures *********************** */
  425. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects F-Frame-Win _ADM-CREATE-OBJECTS
  426. PROCEDURE adm-create-objects :
  427. /*------------------------------------------------------------------------------
  428. Purpose: Create handles for all SmartObjects used in this procedure.
  429. After SmartObjects are initialized, then SmartLinks are added.
  430. Parameters: <none>
  431. ------------------------------------------------------------------------------*/
  432. END PROCEDURE.
  433. /* _UIB-CODE-BLOCK-END */
  434. &ANALYZE-RESUME
  435. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-row-available F-Frame-Win _ADM-ROW-AVAILABLE
  436. PROCEDURE adm-row-available :
  437. /*------------------------------------------------------------------------------
  438. Purpose: Dispatched to this procedure when the Record-
  439. Source has a new row available. This procedure
  440. tries to get the new row (or foriegn keys) from
  441. the Record-Source and process it.
  442. Parameters: <none>
  443. ------------------------------------------------------------------------------*/
  444. /* Define variables needed by this internal procedure. */
  445. {src/adm/template/row-head.i}
  446. /* Process the newly available records (i.e. display fields,
  447. open queries, and/or pass records on to any RECORD-TARGETS). */
  448. {src/adm/template/row-end.i}
  449. END PROCEDURE.
  450. /* _UIB-CODE-BLOCK-END */
  451. &ANALYZE-RESUME
  452. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ADRESSE F-Frame-Win
  453. PROCEDURE ADRESSE :
  454. /*------------------------------------------------------------------------------
  455. Purpose:
  456. Parameters: <none>
  457. Notes:
  458. ------------------------------------------------------------------------------*/
  459. VAdresse = ''.
  460. IF NOT AVAILABLE Aufko THEN RETURN NO-APPLY.
  461. FIND Adresse USE-INDEX Adresse-k1
  462. WHERE Adresse.Firma = AdFirma
  463. AND Adresse.Knr = Aufko.Fak_Knr NO-LOCK NO-ERROR.
  464. IF NOT AVAILABLE Adresse THEN VAdresse = FILL('?', 20).
  465. ELSE VAdresse = Adresse.Anzeig_Br.
  466. END PROCEDURE.
  467. /* _UIB-CODE-BLOCK-END */
  468. &ANALYZE-RESUME
  469. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ANZEIGE F-Frame-Win
  470. PROCEDURE ANZEIGE :
  471. /*------------------------------------------------------------------------------
  472. Purpose:
  473. Parameters: <none>
  474. Notes:
  475. ------------------------------------------------------------------------------*/
  476. DEF VAR cString AS CHAR NO-UNDO.
  477. IF NOT AVAILABLE Aufko THEN RETURN NO-APPLY.
  478. XVAufnr = Aufko.Aufnr.
  479. RUN AUFTRAGSTOTAL ( XVAufnr, OUTPUT cString ) NO-ERROR.
  480. DO ix = 1 TO NUM-ENTRIES(cString, CHR(01)):
  481. VTotal[ix] = DECIMAL(ENTRY(ix, cString, CHR(01))).
  482. END.
  483. DO WITH FRAME {&FRAME-NAME}:
  484. F_Aufnr = XVAufnr.
  485. E_Adresse = ''.
  486. FIND Adresse USE-INDEX Adresse-k1
  487. WHERE Adresse.Firma = AdFirma
  488. AND Adresse.Knr = Aufko.Fak_Knr NO-LOCK NO-ERROR.
  489. E_Adresse = Adresse.Anschrift[05] + CHR(10) +
  490. Adresse.Anschrift[06] + CHR(10) +
  491. Adresse.Anschrift[07] + CHR(10) +
  492. Adresse.Anschrift[08] + CHR(10) +
  493. Adresse.Anschrift[09] + CHR(10) +
  494. Adresse.Anschrift[10] + CHR(10) +
  495. Adresse.Anschrift[11] + CHR(10) +
  496. Adresse.Anschrift[12].
  497. F_WW = VTotal[01].
  498. F_Gebinde = VTotal[11].
  499. F_Recycling = VTotal[12].
  500. F_MWST = VTotal[09].
  501. F_Total = VTotal[10].
  502. F_Skonto = 0.
  503. F_ZahBetr = 0.
  504. F_ZahSko = 0.
  505. F_Bezahlt = Aufko.Bar_Betr.
  506. F_Skonto_Bez = Aufko.Bar_Skonto.
  507. VKonto = Aufko.Bar_Konto.
  508. IF VKonto = '' THEN VKonto = 'XXXXXX'.
  509. F_Saldo = F_Total - F_Bezahlt - F_Skonto.
  510. CB-Zahart:SCREEN-VALUE = VKonto NO-ERROR.
  511. ARecid = RECID(Aufko).
  512. FIND Kondi USE-INDEX Kondi-k1
  513. WHERE Kondi.Kond = Aufko.Kond
  514. AND Kondi.Sprcd = Adresse.Sprcd NO-LOCK NO-ERROR.
  515. IF AVAILABLE Kondi THEN DO:
  516. IF Kondi.Skonto[01] <> 0 THEN DO:
  517. Rundbetr = VTotal[02] * Kondi.Skonto[01] / 100.
  518. Rundcode = 1.
  519. RUN "v8/runden.p".
  520. F_Skonto = Rundbetr.
  521. END.
  522. END.
  523. Rundbetr = F_Total - F_Skonto.
  524. Rundcode = 1.
  525. RUN "v8/runden.p".
  526. F_Netto = Rundbetr.
  527. DISPLAY {&List-1}.
  528. APPLY 'ENTRY' TO Br_Bezahlen.
  529. RETURN NO-APPLY.
  530. END.
  531. END PROCEDURE.
  532. /* _UIB-CODE-BLOCK-END */
  533. &ANALYZE-RESUME
  534. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI F-Frame-Win _DEFAULT-DISABLE
  535. PROCEDURE disable_UI :
  536. /*------------------------------------------------------------------------------
  537. Purpose: DISABLE the User Interface
  538. Parameters: <none>
  539. Notes: Here we clean-up the user-interface by deleting
  540. dynamic widgets we have created and/or hide
  541. frames. This procedure is usually called when
  542. we are ready to "clean-up" after running.
  543. ------------------------------------------------------------------------------*/
  544. /* Hide all frames. */
  545. HIDE FRAME F-Main.
  546. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  547. END PROCEDURE.
  548. /* _UIB-CODE-BLOCK-END */
  549. &ANALYZE-RESUME
  550. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI F-Frame-Win _DEFAULT-ENABLE
  551. PROCEDURE enable_UI :
  552. /*------------------------------------------------------------------------------
  553. Purpose: ENABLE the User Interface
  554. Parameters: <none>
  555. Notes: Here we display/view/enable the widgets in the
  556. user-interface. In addition, OPEN all queries
  557. associated with each FRAME and BROWSE.
  558. These statements here are based on the "Other
  559. Settings" section of the widget Property Sheets.
  560. ------------------------------------------------------------------------------*/
  561. DISPLAY CB-Zahart F_WW F_Gebinde F_Recycling F_MWST F_Total F_Skonto F_Netto
  562. F_Saldo F_Zahbetr F_Bezahlt E_Adresse F_ZahSko F_Skonto_Bez F_Aufnr
  563. WITH FRAME F-Main.
  564. ENABLE Br_Bezahlen CB-Zahart RECT-35
  565. WITH FRAME F-Main.
  566. {&OPEN-BROWSERS-IN-QUERY-F-Main}
  567. END PROCEDURE.
  568. /* _UIB-CODE-BLOCK-END */
  569. &ANALYZE-RESUME
  570. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDEAUFTRAG F-Frame-Win
  571. PROCEDURE ENDEAUFTRAG :
  572. /*------------------------------------------------------------------------------
  573. Purpose:
  574. Parameters: <none>
  575. Notes:
  576. ------------------------------------------------------------------------------*/
  577. IF Btn_Bezahlt:SENSITIVE IN FRAME {&FRAME-NAME} = TRUE THEN DO:
  578. ja = TRUE.
  579. APPLY 'ENTRY' TO F_ZahBetr IN FRAME {&FRAME-NAME}.
  580. RETURN NO-APPLY.
  581. END.
  582. END PROCEDURE.
  583. /* _UIB-CODE-BLOCK-END */
  584. &ANALYZE-RESUME
  585. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-initialize F-Frame-Win
  586. PROCEDURE local-initialize :
  587. /*------------------------------------------------------------------------------
  588. Purpose: Override standard ADM method
  589. Notes:
  590. ------------------------------------------------------------------------------*/
  591. DEF VAR cDelim AS CHAR NO-UNDO.
  592. DEF VAR cString AS CHAR NO-UNDO.
  593. DO WITH FRAME {&FRAME-NAME}:
  594. cDelim = '|'.
  595. cString = 'Kein Konto|XXXXXX'.
  596. FOR EACH Tabel USE-INDEX Tabel-k1
  597. WHERE Tabel.Firma = GVFirma
  598. AND Tabel.RecArt = 'ZAHART'
  599. AND Tabel.CodeC = ''
  600. AND Tabel.Sprcd = 1 NO-LOCK:
  601. cString = cString + cDelim + Tabel.Bez1 + '|' + Tabel.Bez2.
  602. cDelim = '|'.
  603. END.
  604. IF cString = '' THEN cString = '|'.
  605. CB-Zahart:DELIMITER = "|".
  606. CB-Zahart:LIST-ITEM-PAIRS = cString.
  607. END.
  608. RUN dispatch IN THIS-PROCEDURE ( INPUT 'initialize':U ) .
  609. END PROCEDURE.
  610. /* _UIB-CODE-BLOCK-END */
  611. &ANALYZE-RESUME
  612. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-view F-Frame-Win
  613. PROCEDURE local-view :
  614. /*------------------------------------------------------------------------------
  615. Purpose: Override standard ADM method
  616. Notes:
  617. ------------------------------------------------------------------------------*/
  618. DEF VAR ok AS LOG NO-UNDO.
  619. RUN dispatch IN THIS-PROCEDURE ( INPUT 'view':U ) .
  620. RUN OPEN_AUFKO.
  621. RUN dispatch IN THIS-PROCEDURE ('apply-entry':U).
  622. END PROCEDURE.
  623. /* _UIB-CODE-BLOCK-END */
  624. &ANALYZE-RESUME
  625. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE OPEN_AUFKO F-Frame-Win
  626. PROCEDURE OPEN_AUFKO :
  627. /*------------------------------------------------------------------------------
  628. Purpose:
  629. Parameters: <none>
  630. Notes:
  631. ------------------------------------------------------------------------------*/
  632. OPEN QUERY Br_Bezahlen
  633. FOR EACH Aufko USE-INDEX Aufko-k1
  634. WHERE Aufko.Firma = GVFirma
  635. AND Aufko.Faknr > 0 NO-LOCK,
  636. FIRST Tabel USE-INDEX Tabel-k1
  637. WHERE Tabel.Firma = GVFirma
  638. AND Tabel.RecArt = 'FAKART'
  639. AND Tabel.CodeC = ''
  640. AND Tabel.CodeI = Aufko.Fak_Art
  641. AND Tabel.Sprcd = 1
  642. AND Tabel.Int_3 = 3 NO-LOCK.
  643. DO WHILE TRUE WITH FRAME {&FRAME-NAME}:
  644. IF NUM-RESULTS('Br_Bezahlen':U) = ? THEN LEAVE.
  645. IF NUM-RESULTS('Br_Bezahlen':U) = 0 THEN LEAVE.
  646. Vorhanden = TRUE.
  647. QOpen = TRUE.
  648. APPLY 'VALUE-CHANGED' TO Br_Bezahlen.
  649. APPLY 'ENTRY' TO Br_Bezahlen.
  650. LEAVE.
  651. END.
  652. END PROCEDURE.
  653. /* _UIB-CODE-BLOCK-END */
  654. &ANALYZE-RESUME
  655. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE send-records F-Frame-Win _ADM-SEND-RECORDS
  656. PROCEDURE send-records :
  657. /*------------------------------------------------------------------------------
  658. Purpose: Send record ROWID's for all tables used by
  659. this file.
  660. Parameters: see template/snd-head.i
  661. ------------------------------------------------------------------------------*/
  662. /* Define variables needed by this internal procedure. */
  663. {src/adm/template/snd-head.i}
  664. /* For each requested table, put it's ROWID in the output list. */
  665. {src/adm/template/snd-list.i "Aufko"}
  666. {src/adm/template/snd-list.i "Tabel"}
  667. /* Deal with any unexpected table requests before closing. */
  668. {src/adm/template/snd-end.i}
  669. END PROCEDURE.
  670. /* _UIB-CODE-BLOCK-END */
  671. &ANALYZE-RESUME
  672. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE state-changed F-Frame-Win
  673. PROCEDURE state-changed :
  674. /* -----------------------------------------------------------
  675. Purpose:
  676. Parameters: <none>
  677. Notes:
  678. -------------------------------------------------------------*/
  679. DEFINE INPUT PARAMETER p-issuer-hdl AS HANDLE NO-UNDO.
  680. DEFINE INPUT PARAMETER p-state AS CHARACTER NO-UNDO.
  681. CASE p-state:
  682. WHEN 'browser_entry' THEN DO:
  683. APPLY 'ENTRY' TO BROWSE Br_Bezahlen.
  684. RETURN NO-APPLY.
  685. END.
  686. END CASE.
  687. END PROCEDURE.
  688. /* _UIB-CODE-BLOCK-END */
  689. &ANALYZE-RESUME