b-savgebko.w 38 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112
  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 B-table-Win
  8. /*------------------------------------------------------------------------
  9. File:
  10. Description: from BROWSER.W - Basic SmartBrowser Object 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. &Scoped-define ERSTES-FELD Menge
  26. &Scoped-define ZWEITES-FELD Menge
  27. &Scoped-define LETZTES-FELD Menge
  28. &Scoped-define INPUT-FELDER SavGebKo.Menge
  29. &Scoped-define DATEI-NAME SavGebKo
  30. &Scoped-define Zahl_Felder F_ZahBetr,F_ZahSko,CB-ZahARt,Btn_Bezahlt
  31. /* *************************** Definitions ************************** */
  32. /* Parameters Definitions --- */
  33. /* Local Variable Definitions --- */
  34. /* --------------------------------------------------------------------------- */
  35. DEF VAR VUpdate AS LOG INIT FALSE NO-UNDO.
  36. DEF VAR VSpeichern AS LOG INIT FALSE NO-UNDO.
  37. DEF VAR VNeu AS LOG INIT FALSE NO-UNDO.
  38. DEF VAR FErfassen AS LOG INIT FALSE NO-UNDO.
  39. DEF VAR PHandle AS HANDLE NO-UNDO.
  40. DEF VAR XHandle AS HANDLE NO-UNDO.
  41. DEF VAR LHandle AS HANDLE NO-UNDO.
  42. DEF VAR ch AS CHAR NO-UNDO.
  43. DEF VAR VText AS CHAR FORMAT "x(30)" NO-UNDO.
  44. DEF VAR QOpen AS LOG INIT FALSE NO-UNDO.
  45. DEF VAR FQOpen AS LOG INIT FALSE NO-UNDO.
  46. DEF VAR Vorhanden AS LOG NO-UNDO.
  47. DEF VAR VROWID AS ROWID NO-UNDO.
  48. DEF VAR Feldname AS CHAR NO-UNDO.
  49. DEF VAR FeldInhalt AS CHAR NO-UNDO.
  50. DEF VAR BStatus AS INT INIT 0 NO-UNDO.
  51. DEF BUFFER B{&DATEI-NAME} FOR {&DATEI-NAME}.
  52. /* --------------------------------------------------------------------------- */
  53. /* Parameters Definitions --- */
  54. /* Local Variable Definitions --- */
  55. DEF VAR XZahart AS CHAR NO-UNDO.
  56. DEF VAR VZahArt AS INT NO-UNDO.
  57. DEF VAR VKonto AS CHAR NO-UNDO.
  58. DEF VAR xx AS INT NO-UNDO.
  59. DEF VAR VBetrag AS DEC NO-UNDO.
  60. DEF VAR ok AS LOG NO-UNDO.
  61. DEF VAR ARecid AS RECID NO-UNDO.
  62. DEF VAR FCuDw AS LOG NO-UNDO.
  63. DEF BUFFER BSavko FOR Savko.
  64. /* ---------- Globale Variablen ---------------------------------- */
  65. { v8/globvar.i" " " " "SHARED" }
  66. { v8/debivar.i " " " " "SHARED" }
  67. { v8/artivar.i " " " " "SHARED" }
  68. { v8/contvar.i " " " " "SHARED" }
  69. { v8/aufkototv.i "NEW" "SHARED" }
  70. /* _UIB-CODE-BLOCK-END */
  71. &ANALYZE-RESUME
  72. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  73. /* ******************** Preprocessor Definitions ******************** */
  74. &Scoped-define PROCEDURE-TYPE SmartBrowser
  75. &Scoped-define DB-AWARE no
  76. &Scoped-define ADM-SUPPORTED-LINKS Record-Source,Record-Target,TableIO-Target
  77. /* Name of first Frame and/or Browse and/or first Query */
  78. &Scoped-define FRAME-NAME F-Main
  79. &Scoped-define BROWSE-NAME br_table
  80. /* Internal Tables (found by Frame, Query & Browse Queries) */
  81. &Scoped-define INTERNAL-TABLES SavGebKo
  82. /* Define KEY-PHRASE in case it is used by any query. */
  83. &Scoped-define KEY-PHRASE TRUE
  84. /* Definitions for BROWSE br_table */
  85. &Scoped-define FIELDS-IN-QUERY-br_table SavGebKo.Menge VText @ VText ~
  86. VBetrag @ VBetrag
  87. &Scoped-define ENABLED-FIELDS-IN-QUERY-br_table SavGebKo.Menge
  88. &Scoped-define ENABLED-TABLES-IN-QUERY-br_table SavGebKo
  89. &Scoped-define FIRST-ENABLED-TABLE-IN-QUERY-br_table SavGebKo
  90. &Scoped-define QUERY-STRING-br_table FOR EACH SavGebKo WHERE ~{&KEY-PHRASE} ~
  91. AND SavGebKo.Firma = GVFirma ~
  92. AND SavGebKo.Aufnr = XVAufnr NO-LOCK ~
  93. ~{&SORTBY-PHRASE}
  94. &Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH SavGebKo WHERE ~{&KEY-PHRASE} ~
  95. AND SavGebKo.Firma = GVFirma ~
  96. AND SavGebKo.Aufnr = XVAufnr NO-LOCK ~
  97. ~{&SORTBY-PHRASE}.
  98. &Scoped-define TABLES-IN-QUERY-br_table SavGebKo
  99. &Scoped-define FIRST-TABLE-IN-QUERY-br_table SavGebKo
  100. /* Definitions for FRAME F-Main */
  101. /* Standard List Definitions */
  102. &Scoped-Define ENABLED-OBJECTS RECT-38 RECT-9 br_table E_Adresse F_WW ~
  103. F_Gebinde F_Recycling F_MWST F_Total CB-Zahart F_Skonto F_Netto F_Saldo ~
  104. F_Bezahlt F_Skonto_Bez
  105. &Scoped-Define DISPLAYED-OBJECTS F_Aufnr E_Adresse F_WW F_Gebinde ~
  106. F_Recycling F_MWST F_Total CB-Zahart F_Skonto F_Netto F_Saldo F_Zahbetr ~
  107. F_ZahSko F_Bezahlt F_Skonto_Bez
  108. /* Custom List Definitions */
  109. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  110. &Scoped-define List-1 F_WW F_Gebinde F_Recycling F_MWST F_Total F_Skonto ~
  111. F_Netto F_Saldo F_Zahbetr F_ZahSko F_Bezahlt F_Skonto_Bez
  112. &Scoped-define List-5 SavKo.Fahrer SavKo.BeiFahrer SavKo.LKW
  113. &Scoped-define List-6 F_WW F_Gebinde F_Recycling F_MWST F_Total F_Skonto ~
  114. F_Netto F_Saldo F_Zahbetr F_ZahSko F_Bezahlt F_Skonto_Bez
  115. /* _UIB-PREPROCESSOR-BLOCK-END */
  116. &ANALYZE-RESUME
  117. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _XFTR "Foreign Keys" B-table-Win _INLINE
  118. /* Actions: ? adm/support/keyedit.w ? ? ? */
  119. /* STRUCTURED-DATA
  120. <KEY-OBJECT>
  121. &BROWSE-NAME
  122. </KEY-OBJECT>
  123. <FOREIGN-KEYS>
  124. </FOREIGN-KEYS>
  125. <EXECUTING-CODE>
  126. **************************
  127. * Set attributes related to FOREIGN KEYS
  128. */
  129. RUN set-attribute-list (
  130. 'Keys-Accepted = "",
  131. Keys-Supplied = ""':U).
  132. /**************************
  133. </EXECUTING-CODE> */
  134. /* _UIB-CODE-BLOCK-END */
  135. &ANALYZE-RESUME
  136. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _XFTR "Advanced Query Options" B-table-Win _INLINE
  137. /* Actions: ? adm/support/advqedit.w ? ? ? */
  138. /* STRUCTURED-DATA
  139. <KEY-OBJECT>
  140. &BROWSE-NAME
  141. </KEY-OBJECT>
  142. <SORTBY-OPTIONS>
  143. </SORTBY-OPTIONS>
  144. <SORTBY-RUN-CODE>
  145. ************************
  146. * Set attributes related to SORTBY-OPTIONS */
  147. RUN set-attribute-list (
  148. 'SortBy-Options = ""':U).
  149. /************************
  150. </SORTBY-RUN-CODE>
  151. <FILTER-ATTRIBUTES>
  152. </FILTER-ATTRIBUTES> */
  153. /* _UIB-CODE-BLOCK-END */
  154. &ANALYZE-RESUME
  155. /* *********************** Control Definitions ********************** */
  156. /* Definitions of the field level widgets */
  157. DEFINE VARIABLE CB-Zahart AS CHARACTER FORMAT "X(256)":U
  158. LABEL "Zahlungsart"
  159. VIEW-AS COMBO-BOX INNER-LINES 5
  160. DROP-DOWN-LIST
  161. SIZE 32 BY 1
  162. BGCOLOR 15 NO-UNDO.
  163. DEFINE VARIABLE E_Adresse AS CHARACTER
  164. VIEW-AS EDITOR NO-WORD-WRAP MAX-CHARS 500
  165. SIZE 83.8 BY 6.57
  166. BGCOLOR 15 FONT 6 NO-UNDO.
  167. DEFINE VARIABLE F_Aufnr AS INTEGER FORMAT "9999999":U INITIAL 0
  168. LABEL "Auftragsnummer"
  169. VIEW-AS FILL-IN NATIVE
  170. SIZE 10 BY 1
  171. BGCOLOR 15 NO-UNDO.
  172. DEFINE VARIABLE F_Bezahlt AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  173. LABEL "Bezahlt"
  174. VIEW-AS FILL-IN NATIVE
  175. SIZE 17 BY 1
  176. BGCOLOR 14 NO-UNDO.
  177. DEFINE VARIABLE F_Gebinde AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  178. LABEL "Gebinde"
  179. VIEW-AS FILL-IN NATIVE
  180. SIZE 17 BY 1
  181. BGCOLOR 15 NO-UNDO.
  182. DEFINE VARIABLE F_MWST AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  183. LABEL "Mehrwertst."
  184. VIEW-AS FILL-IN NATIVE
  185. SIZE 17 BY 1
  186. BGCOLOR 15 NO-UNDO.
  187. DEFINE VARIABLE F_Netto AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  188. LABEL "Nettobetrag"
  189. VIEW-AS FILL-IN NATIVE
  190. SIZE 17 BY 1
  191. BGCOLOR 15 NO-UNDO.
  192. DEFINE VARIABLE F_Recycling AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  193. LABEL "Gebühren"
  194. VIEW-AS FILL-IN NATIVE
  195. SIZE 17 BY 1
  196. BGCOLOR 15 NO-UNDO.
  197. DEFINE VARIABLE F_Saldo AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  198. LABEL "Saldo"
  199. VIEW-AS FILL-IN NATIVE
  200. SIZE 17 BY 1
  201. BGCOLOR 14 NO-UNDO.
  202. DEFINE VARIABLE F_Skonto AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  203. LABEL "Skonto"
  204. VIEW-AS FILL-IN NATIVE
  205. SIZE 17 BY 1
  206. BGCOLOR 15 NO-UNDO.
  207. DEFINE VARIABLE F_Skonto_Bez AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  208. LABEL "Skontoabzug"
  209. VIEW-AS FILL-IN NATIVE
  210. SIZE 17 BY 1
  211. BGCOLOR 14 NO-UNDO.
  212. DEFINE VARIABLE F_Total AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  213. LABEL "Totalbetrag"
  214. VIEW-AS FILL-IN NATIVE
  215. SIZE 17 BY 1
  216. BGCOLOR 8 NO-UNDO.
  217. DEFINE VARIABLE F_WW AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  218. LABEL "Warenwert"
  219. VIEW-AS FILL-IN NATIVE
  220. SIZE 17 BY 1
  221. BGCOLOR 15 NO-UNDO.
  222. DEFINE VARIABLE F_Zahbetr AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  223. LABEL "Zahlbetrag"
  224. VIEW-AS FILL-IN NATIVE
  225. SIZE 17 BY 1
  226. BGCOLOR 15 NO-UNDO.
  227. DEFINE VARIABLE F_ZahSko AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0
  228. LABEL "Skonto"
  229. VIEW-AS FILL-IN NATIVE
  230. SIZE 17 BY 1
  231. BGCOLOR 15 NO-UNDO.
  232. DEFINE RECTANGLE RECT-38
  233. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  234. SIZE 49.6 BY 2.67.
  235. DEFINE RECTANGLE RECT-9
  236. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  237. SIZE 148 BY 21.43.
  238. /* Query definitions */
  239. &ANALYZE-SUSPEND
  240. DEFINE QUERY br_table FOR
  241. SavGebKo SCROLLING.
  242. &ANALYZE-RESUME
  243. /* Browse definitions */
  244. DEFINE BROWSE br_table
  245. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table B-table-Win _STRUCTURED
  246. QUERY br_table NO-LOCK DISPLAY
  247. SavGebKo.Menge FORMAT "zz,zz9-":U
  248. VText @ VText COLUMN-LABEL "Bezeichnung" FORMAT "x(30)":U
  249. VBetrag @ VBetrag COLUMN-LABEL "Betrag" FORMAT "zzz,zz9.99-":U
  250. ENABLE
  251. SavGebKo.Menge
  252. /* _UIB-CODE-BLOCK-END */
  253. &ANALYZE-RESUME
  254. WITH NO-ASSIGN NO-ROW-MARKERS SEPARATORS SIZE 58 BY 20.95
  255. BGCOLOR 15 .
  256. /* ************************ Frame Definitions *********************** */
  257. DEFINE FRAME F-Main
  258. br_table AT ROW 1.48 COL 3
  259. F_Aufnr AT ROW 1.76 COL 130.6 COLON-ALIGNED
  260. E_Adresse AT ROW 3.29 COL 62.6 NO-LABEL
  261. F_WW AT ROW 11 COL 73 COLON-ALIGNED
  262. F_Gebinde AT ROW 12 COL 73 COLON-ALIGNED
  263. SavKo.Fahrer AT ROW 12.67 COL 98 COLON-ALIGNED NO-LABEL FORMAT "99"
  264. VIEW-AS FILL-IN NATIVE
  265. SIZE 5 BY 1
  266. BGCOLOR 15
  267. SavKo.BeiFahrer AT ROW 12.67 COL 106 COLON-ALIGNED NO-LABEL FORMAT "99"
  268. VIEW-AS FILL-IN NATIVE
  269. SIZE 5 BY 1
  270. BGCOLOR 15
  271. SavKo.LKW AT ROW 12.67 COL 114 COLON-ALIGNED NO-LABEL FORMAT "99"
  272. VIEW-AS FILL-IN NATIVE
  273. SIZE 5 BY 1
  274. BGCOLOR 15
  275. F_Recycling AT ROW 13 COL 73 COLON-ALIGNED
  276. F_MWST AT ROW 14 COL 73 COLON-ALIGNED
  277. F_Total AT ROW 15 COL 73 COLON-ALIGNED
  278. CB-Zahart AT ROW 15.86 COL 112 COLON-ALIGNED
  279. F_Skonto AT ROW 16 COL 73 COLON-ALIGNED
  280. F_Netto AT ROW 17 COL 73 COLON-ALIGNED
  281. F_Saldo AT ROW 18 COL 73 COLON-ALIGNED
  282. F_Zahbetr AT ROW 19 COL 73 COLON-ALIGNED
  283. F_ZahSko AT ROW 19 COL 112 COLON-ALIGNED
  284. F_Bezahlt AT ROW 20 COL 73 COLON-ALIGNED
  285. F_Skonto_Bez AT ROW 20 COL 112 COLON-ALIGNED
  286. "Fahrer BeiFa LKW" VIEW-AS TEXT
  287. SIZE 25.4 BY .81 AT ROW 11.67 COL 100
  288. RECT-38 AT ROW 11.38 COL 97.8
  289. RECT-9 AT ROW 1.24 COL 2
  290. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
  291. SIDE-LABELS NO-UNDERLINE THREE-D
  292. AT COL 1 ROW 1 SCROLLABLE .
  293. /* *********************** Procedure Settings ************************ */
  294. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  295. /* Settings for THIS-PROCEDURE
  296. Type: SmartBrowser
  297. Allow: Basic,Browse
  298. Frames: 1
  299. Add Fields to: EXTERNAL-TABLES
  300. Other Settings: PERSISTENT-ONLY COMPILE
  301. */
  302. /* This procedure should always be RUN PERSISTENT. Report the error, */
  303. /* then cleanup and return. */
  304. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  305. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  306. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  307. RETURN.
  308. END.
  309. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  310. /* ************************* Create Window ************************** */
  311. &ANALYZE-SUSPEND _CREATE-WINDOW
  312. /* DESIGN Window definition (used by the UIB)
  313. CREATE WINDOW B-table-Win ASSIGN
  314. HEIGHT = 21.91
  315. WIDTH = 150.
  316. /* END WINDOW DEFINITION */
  317. */
  318. &ANALYZE-RESUME
  319. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB B-table-Win
  320. /* ************************* Included-Libraries *********************** */
  321. {src/adm/method/browser.i}
  322. /* _UIB-CODE-BLOCK-END */
  323. &ANALYZE-RESUME
  324. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  325. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  326. /* SETTINGS FOR WINDOW B-table-Win
  327. NOT-VISIBLE,,RUN-PERSISTENT */
  328. /* SETTINGS FOR FRAME F-Main
  329. NOT-VISIBLE Size-to-Fit */
  330. /* BROWSE-TAB br_table RECT-9 F-Main */
  331. ASSIGN
  332. FRAME F-Main:SCROLLABLE = FALSE
  333. FRAME F-Main:HIDDEN = TRUE
  334. FRAME F-Main:RESIZABLE = TRUE.
  335. /* SETTINGS FOR FILL-IN SavKo.BeiFahrer IN FRAME F-Main
  336. NO-DISPLAY NO-ENABLE 5 EXP-LABEL EXP-FORMAT */
  337. ASSIGN
  338. E_Adresse:RETURN-INSERTED IN FRAME F-Main = TRUE
  339. E_Adresse:READ-ONLY IN FRAME F-Main = TRUE.
  340. /* SETTINGS FOR FILL-IN SavKo.Fahrer IN FRAME F-Main
  341. NO-DISPLAY NO-ENABLE 5 EXP-LABEL EXP-FORMAT */
  342. /* SETTINGS FOR FILL-IN F_Aufnr IN FRAME F-Main
  343. NO-ENABLE */
  344. /* SETTINGS FOR FILL-IN F_Bezahlt IN FRAME F-Main
  345. 1 6 */
  346. /* SETTINGS FOR FILL-IN F_Gebinde IN FRAME F-Main
  347. 1 6 */
  348. /* SETTINGS FOR FILL-IN F_MWST IN FRAME F-Main
  349. 1 6 */
  350. /* SETTINGS FOR FILL-IN F_Netto IN FRAME F-Main
  351. 1 6 */
  352. /* SETTINGS FOR FILL-IN F_Recycling IN FRAME F-Main
  353. 1 6 */
  354. /* SETTINGS FOR FILL-IN F_Saldo IN FRAME F-Main
  355. 1 6 */
  356. /* SETTINGS FOR FILL-IN F_Skonto IN FRAME F-Main
  357. 1 6 */
  358. /* SETTINGS FOR FILL-IN F_Skonto_Bez IN FRAME F-Main
  359. 1 6 */
  360. /* SETTINGS FOR FILL-IN F_Total IN FRAME F-Main
  361. 1 6 */
  362. /* SETTINGS FOR FILL-IN F_WW IN FRAME F-Main
  363. 1 6 */
  364. /* SETTINGS FOR FILL-IN F_Zahbetr IN FRAME F-Main
  365. NO-ENABLE 1 6 */
  366. /* SETTINGS FOR FILL-IN F_ZahSko IN FRAME F-Main
  367. NO-ENABLE 1 6 */
  368. /* SETTINGS FOR FILL-IN SavKo.LKW IN FRAME F-Main
  369. NO-DISPLAY NO-ENABLE 5 EXP-LABEL EXP-FORMAT */
  370. /* _RUN-TIME-ATTRIBUTES-END */
  371. &ANALYZE-RESUME
  372. /* Setting information for Queries and Browse Widgets fields */
  373. &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_table
  374. /* Query rebuild information for BROWSE br_table
  375. _TblList = "AnaDat.SavGebKo"
  376. _Options = "NO-LOCK KEY-PHRASE SORTBY-PHRASE"
  377. _Where[1] = "SavGebKo.Firma = GVFirma
  378. AND SavGebKo.Aufnr = XVAufnr"
  379. _FldNameList[1] > AnaDat.SavGebKo.Menge
  380. "SavGebKo.Menge" ? ? "decimal" ? ? ? ? ? ? yes ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  381. _FldNameList[2] > "_<CALC>"
  382. "VText @ VText" "Bezeichnung" "x(30)" ? ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  383. _FldNameList[3] > "_<CALC>"
  384. "VBetrag @ VBetrag" "Betrag" "zzz,zz9.99-" ? ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  385. _Query is NOT OPENED
  386. */ /* BROWSE br_table */
  387. &ANALYZE-RESUME
  388. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
  389. /* Query rebuild information for FRAME F-Main
  390. _Options = "NO-LOCK"
  391. _Query is NOT OPENED
  392. */ /* FRAME F-Main */
  393. &ANALYZE-RESUME
  394. /* ************************ Control Triggers ************************ */
  395. &Scoped-define BROWSE-NAME br_table
  396. &Scoped-define SELF-NAME br_table
  397. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table B-table-Win
  398. ON ROW-DISPLAY OF br_table IN FRAME F-Main
  399. DO:
  400. IF NOT AVAILABLE SavGebKo THEN RETURN.
  401. RUN ANZEIGE.
  402. IF SavGebKo.Menge <> 0 THEN DO:
  403. SavGebKo.Menge:BGCOLOR IN BROWSE {&BROWSE-NAME} = 8.
  404. VText:BGCOLOR IN BROWSE {&BROWSE-NAME} = 8.
  405. VBetrag:BGCOLOR IN BROWSE {&BROWSE-NAME} = 8.
  406. END.
  407. ELSE DO:
  408. SavGebKo.Menge:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15.
  409. VText:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15.
  410. VBetrag:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15.
  411. END.
  412. END.
  413. /* _UIB-CODE-BLOCK-END */
  414. &ANALYZE-RESUME
  415. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table B-table-Win
  416. ON ROW-ENTRY OF br_table IN FRAME F-Main
  417. DO:
  418. {src/adm/template/brsentry.i}
  419. END.
  420. /* _UIB-CODE-BLOCK-END */
  421. &ANALYZE-RESUME
  422. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table B-table-Win
  423. ON VALUE-CHANGED OF br_table IN FRAME F-Main
  424. DO:
  425. RUN ANZEIGE.
  426. {src/adm/template/brschnge.i}
  427. END.
  428. /* _UIB-CODE-BLOCK-END */
  429. &ANALYZE-RESUME
  430. &Scoped-define SELF-NAME CB-Zahart
  431. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB-Zahart B-table-Win
  432. ON VALUE-CHANGED OF CB-Zahart IN FRAME F-Main /* Zahlungsart */
  433. DO:
  434. DO WITH FRAME {&FRAME-NAME}:
  435. ix = LOOKUP(SELF:SCREEN-VALUE, SELF:LIST-ITEMS, '|').
  436. VZahart = INTEGER(ENTRY(ix, XZahart, "|")).
  437. FIND Tabel USE-INDEX Tabel-k1
  438. WHERE Tabel.Firma = GVFirma
  439. AND Tabel.RecArt = 'ZAHART'
  440. AND Tabel.CodeC = ''
  441. AND Tabel.CodeI = VZahart
  442. AND Tabel.Sprcd = 1 NO-LOCK.
  443. VKonto = Tabel.Bez2.
  444. END.
  445. END.
  446. /* _UIB-CODE-BLOCK-END */
  447. &ANALYZE-RESUME
  448. &UNDEFINE SELF-NAME
  449. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK B-table-Win
  450. /* *************************** Main Block *************************** */
  451. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  452. RUN dispatch IN THIS-PROCEDURE ('initialize':U).
  453. &ENDIF
  454. FCuDw = FALSE.
  455. /* ------ Triggers ---------------------------------------------------- */
  456. ON END-ERROR OF {&INPUT-FELDER} IN BROWSE {&BROWSE-NAME}
  457. OR END-ERROR OF BROWSE {&BROWSE-NAME}
  458. DO:
  459. VSpeichern = FALSE.
  460. IF NOT VUpdate THEN DO:
  461. RUN new-state ( INPUT 'ENDE, MAIN':U ).
  462. RETURN NO-APPLY.
  463. END.
  464. END.
  465. ON LEFT-MOUSE-DOWN, RIGHT-MOUSE-DOWN, MIDDLE-MOUSE-DOWN OF BROWSE {&BROWSE-NAME}
  466. DO:
  467. DO WHILE TRUE:
  468. IF NOT VUpdate THEN LEAVE.
  469. XHandle = {&BROWSE-NAME}:CURRENT-COLUMN IN FRAME {&FRAME-NAME}.
  470. IF NOT VALID-HANDLE(XHandle) THEN XHandle = LAST-EVENT:WIDGET-LEAVE.
  471. IF VALID-HANDLE(XHandle) THEN DO:
  472. APPLY 'LEAVE' TO XHandle.
  473. RETURN.
  474. END.
  475. LEAVE.
  476. END.
  477. END.
  478. /* _UIB-CODE-BLOCK-END */
  479. &ANALYZE-RESUME
  480. /* ********************** Internal Procedures *********************** */
  481. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-row-available B-table-Win _ADM-ROW-AVAILABLE
  482. PROCEDURE adm-row-available :
  483. /*------------------------------------------------------------------------------
  484. Purpose: Dispatched to this procedure when the Record-
  485. Source has a new row available. This procedure
  486. tries to get the new row (or foriegn keys) from
  487. the Record-Source and process it.
  488. Parameters: <none>
  489. ------------------------------------------------------------------------------*/
  490. /* Define variables needed by this internal procedure. */
  491. {src/adm/template/row-head.i}
  492. /* Process the newly available records (i.e. display fields,
  493. open queries, and/or pass records on to any RECORD-TARGETS). */
  494. {src/adm/template/row-end.i}
  495. END PROCEDURE.
  496. /* _UIB-CODE-BLOCK-END */
  497. &ANALYZE-RESUME
  498. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ANZEIGE B-table-Win
  499. PROCEDURE ANZEIGE :
  500. /*------------------------------------------------------------------------------
  501. Purpose:
  502. Parameters: <none>
  503. Notes:
  504. ------------------------------------------------------------------------------*/
  505. VText = ''.
  506. IF AVAILABLE {&DATEI-NAME} THEN DO:
  507. VRecid = RECID({&DATEI-NAME}).
  508. VROWID = ROWID({&DATEI-NAME}).
  509. FIND GebRueck USE-INDEX GebRueck-k1
  510. WHERE GebRueck.Firma = GVFirma
  511. AND GebRueck.Geb_Cd = SavGebKo.Geb_Cd NO-LOCK NO-ERROR.
  512. IF AVAILABLE GebRueck THEN VText = GebRueck.Bez.
  513. ELSE VText = FILL('?', 20).
  514. VBetrag = SavGebKo.Betrag_1 + SavGebKo.Betrag_2 + SavGebKo.Betrag_3.
  515. END.
  516. END PROCEDURE.
  517. /* _UIB-CODE-BLOCK-END */
  518. &ANALYZE-RESUME
  519. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ANZEIGE_DETAIL B-table-Win
  520. PROCEDURE ANZEIGE_DETAIL :
  521. /*------------------------------------------------------------------------------
  522. Purpose:
  523. Parameters: <none>
  524. Notes:
  525. ------------------------------------------------------------------------------*/
  526. DO WITH FRAME {&FRAME-NAME}:
  527. F_Aufnr = XVAufnr.
  528. E_Adresse = ''.
  529. FIND Adresse USE-INDEX Adresse-k1
  530. WHERE Adresse.Firma = AdFirma
  531. AND Adresse.Knr = Savko.Knr NO-LOCK NO-ERROR.
  532. E_Adresse = Adresse.Anschrift[05] + CHR(10) +
  533. Adresse.Anschrift[06] + CHR(10) +
  534. Adresse.Anschrift[07] + CHR(10) +
  535. Adresse.Anschrift[08] + CHR(10) +
  536. Adresse.Anschrift[09] + CHR(10) +
  537. Adresse.Anschrift[10] + CHR(10) +
  538. Adresse.Anschrift[11] + CHR(10) +
  539. Adresse.Anschrift[12].
  540. DISPLAY F_Aufnr E_Adresse
  541. {&List-5}.
  542. F_WW = VTotal[01].
  543. F_Gebinde = VTotal[11].
  544. F_Recycling = VTotal[12].
  545. F_MWST = VTotal[09].
  546. F_Total = VTotal[10].
  547. F_Skonto = 0.
  548. F_ZahBetr = 0.
  549. F_ZahSko = 0.
  550. F_Bezahlt = Savko.Bar_Betr.
  551. F_Skonto_Bez = Savko.Bar_Skonto.
  552. F_Saldo = F_Total - F_Bezahlt - F_Skonto.
  553. ARecid = RECID(Savko).
  554. FIND Kondi USE-INDEX Kondi-k1
  555. WHERE Kondi.Kond = Savko.Kond
  556. AND Kondi.Sprcd = Adresse.Sprcd NO-LOCK NO-ERROR.
  557. IF AVAILABLE Kondi THEN DO:
  558. IF Kondi.Skonto[01] <> 0 THEN DO:
  559. Rundbetr = VTotal[02] * Kondi.Skonto[01] / 100.
  560. Rundcode = 1.
  561. RUN "v8/runden.p".
  562. F_Skonto = Rundbetr.
  563. END.
  564. END.
  565. Rundbetr = F_Total - F_Skonto.
  566. Rundcode = 1.
  567. RUN "v8/runden.p".
  568. F_Netto = Rundbetr.
  569. DISPLAY {&List-1}.
  570. END.
  571. END PROCEDURE.
  572. /* _UIB-CODE-BLOCK-END */
  573. &ANALYZE-RESUME
  574. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI B-table-Win _DEFAULT-DISABLE
  575. PROCEDURE disable_UI :
  576. /*------------------------------------------------------------------------------
  577. Purpose: DISABLE the User Interface
  578. Parameters: <none>
  579. Notes: Here we clean-up the user-interface by deleting
  580. dynamic widgets we have created and/or hide
  581. frames. This procedure is usually called when
  582. we are ready to "clean-up" after running.
  583. ------------------------------------------------------------------------------*/
  584. /* Hide all frames. */
  585. HIDE FRAME F-Main.
  586. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  587. END PROCEDURE.
  588. /* _UIB-CODE-BLOCK-END */
  589. &ANALYZE-RESUME
  590. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE GEBINDE_KONTO B-table-Win
  591. PROCEDURE GEBINDE_KONTO :
  592. /*------------------------------------------------------------------------------
  593. Purpose:
  594. Parameters: <none>
  595. Notes:
  596. ------------------------------------------------------------------------------*/
  597. DEF VAR MW AS INT.
  598. DEF INPUT PARAMETER Art AS INT.
  599. DO WHILE SavGebKo.Kto_Cd1 <> '':
  600. IF SavGebKo.Anz_1 = 0 THEN LEAVE.
  601. FIND GebKonto USE-INDEX GebKonto-k1
  602. WHERE GebKonto.Firma = GVFirma
  603. AND GebKonto.Geb_Cd = SavGebKo.Kto_Cd1 NO-LOCK.
  604. IF GebKonto.MWST_Art = 0 THEN MW = 11.
  605. IF GebKonto.MWST_Art = 2 THEN MW = GebKonto.MWST_Cd.
  606. IF GebKonto.MWST_Art = 1 THEN DO:
  607. FIND FIRST AufGKon USE-INDEX AufGKon-k1
  608. WHERE AufGKon.Firma = GVFirma
  609. AND AufGKon.Aufnr = SavGebKo.Aufnr
  610. AND AufGKon.Geb_Cd = GebKonto.Geb_Cd NO-LOCK NO-ERROR.
  611. IF AVAILABLE AufGKon THEN MW = AufGKon.MWSt_Cd.
  612. ELSE MW = 11.
  613. END.
  614. FIND AufGKon USE-INDEX AufGKon-k1
  615. WHERE AufGKon.Firma = GVFirma
  616. AND AufGKon.Aufnr = SavGebKo.Aufnr
  617. AND AufGKon.Geb_Cd = GebKonto.Geb_Cd
  618. AND AufGKon.MWSt_Cd = MW NO-ERROR.
  619. IF NOT AVAILABLE AufGKon THEN DO:
  620. CREATE AufGKon.
  621. ASSIGN AufGKon.Firma = SavGebKo.Firma
  622. AufGKon.Aufnr = SavGebKo.Aufnr
  623. AufGKon.Geb_Cd = GebKonto.Geb_Cd
  624. AufGKon.MWSt_Cd = MW
  625. AufGKon.Gebuehr = GebKonto.Gebuehr
  626. AufGKon.Depot = GebKonto.Depot
  627. AufGKon.Sort_Cd = GebKonto.Sort_Cd.
  628. END.
  629. IF Art = 1 THEN AufGKon.Eingang = AufGKon.Eingang + (SavGebKo.Anz_1 * SavGebKo.Menge).
  630. IF Art = 2 THEN AufGKon.Eingang = AufGKon.Eingang - (SavGebKo.Anz_1 * SavGebKo.Menge).
  631. AufGKon.Betrag = (AufGKon.Ausgang - AufGKon.Eingang)
  632. * (AufGKon.Depot + AufGKon.Gebuehr).
  633. LEAVE.
  634. END.
  635. DO WHILE SavGebKo.Kto_Cd2 <> '':
  636. IF SavGebKo.Anz_2 = 0 THEN LEAVE.
  637. FIND GebKonto USE-INDEX GebKonto-k1
  638. WHERE GebKonto.Firma = GVFirma
  639. AND GebKonto.Geb_Cd = SavGebKo.Kto_Cd2 NO-LOCK.
  640. IF GebKonto.MWST_Art = 0 THEN MW = 11.
  641. IF GebKonto.MWST_Art = 2 THEN MW = GebKonto.MWST_Cd.
  642. IF GebKonto.MWST_Art = 1 THEN DO:
  643. FIND FIRST AufGKon USE-INDEX AufGKon-k1
  644. WHERE AufGKon.Firma = GVFirma
  645. AND AufGKon.Aufnr = SavGebKo.Aufnr
  646. AND AufGKon.Geb_Cd = GebKonto.Geb_Cd NO-LOCK NO-ERROR.
  647. IF AVAILABLE AufGKon THEN MW = AufGKon.MWSt_Cd.
  648. ELSE MW = 11.
  649. END.
  650. FIND AufGKon USE-INDEX AufGKon-k1
  651. WHERE AufGKon.Firma = GVFirma
  652. AND AufGKon.Aufnr = SavGebKo.Aufnr
  653. AND AufGKon.Geb_Cd = GebKonto.Geb_Cd
  654. AND AufGKon.MWSt_Cd = MW NO-ERROR.
  655. IF NOT AVAILABLE AufGKon THEN DO:
  656. CREATE AufGKon.
  657. ASSIGN AufGKon.Firma = SavGebKo.Firma
  658. AufGKon.Aufnr = SavGebKo.Aufnr
  659. AufGKon.Geb_Cd = GebKonto.Geb_Cd
  660. AufGKon.MWSt_Cd = MW
  661. AufGKon.Gebuehr = GebKonto.Gebuehr
  662. AufGKon.Depot = GebKonto.Depot
  663. AufGKon.Sort_Cd = GebKonto.Sort_Cd.
  664. END.
  665. IF Art = 1 THEN AufGKon.Eingang = AufGKon.Eingang + (SavGebKo.Anz_2 * SavGebKo.Menge).
  666. IF Art = 2 THEN AufGKon.Eingang = AufGKon.Eingang - (SavGebKo.Anz_2 * SavGebKo.Menge).
  667. AufGKon.Betrag = (AufGKon.Ausgang - AufGKon.Eingang)
  668. * (AufGKon.Depot + AufGKon.Gebuehr).
  669. LEAVE.
  670. END.
  671. DO WHILE SavGebKo.Kto_Cd3 <> '':
  672. IF SavGebKo.Anz_3 = 0 THEN LEAVE.
  673. FIND GebKonto USE-INDEX GebKonto-k1
  674. WHERE GebKonto.Firma = GVFirma
  675. AND GebKonto.Geb_Cd = SavGebKo.Kto_Cd3 NO-LOCK.
  676. IF GebKonto.MWST_Art = 0 THEN MW = 11.
  677. IF GebKonto.MWST_Art = 2 THEN MW = GebKonto.MWST_Cd.
  678. IF GebKonto.MWST_Art = 1 THEN DO:
  679. FIND FIRST AufGKon USE-INDEX AufGKon-k1
  680. WHERE AufGKon.Firma = GVFirma
  681. AND AufGKon.Aufnr = SavGebKo.Aufnr
  682. AND AufGKon.Geb_Cd = GebKonto.Geb_Cd NO-LOCK NO-ERROR.
  683. IF AVAILABLE AufGKon THEN MW = AufGKon.MWSt_Cd.
  684. ELSE MW = 11.
  685. END.
  686. FIND AufGKon USE-INDEX AufGKon-k1
  687. WHERE AufGKon.Firma = GVFirma
  688. AND AufGKon.Aufnr = SavGebKo.Aufnr
  689. AND AufGKon.Geb_Cd = GebKonto.Geb_Cd
  690. AND AufGKon.MWSt_Cd = MW NO-ERROR.
  691. IF NOT AVAILABLE AufGKon THEN DO:
  692. CREATE AufGKon.
  693. ASSIGN AufGKon.Firma = SavGebKo.Firma
  694. AufGKon.Aufnr = SavGebKo.Aufnr
  695. AufGKon.Geb_Cd = GebKonto.Geb_Cd
  696. AufGKon.MWSt_Cd = MW
  697. AufGKon.Gebuehr = GebKonto.Gebuehr
  698. AufGKon.Depot = GebKonto.Depot
  699. AufGKon.Sort_Cd = GebKonto.Sort_Cd.
  700. END.
  701. IF Art = 1 THEN AufGKon.Eingang = AufGKon.Eingang + (SavGebKo.Anz_3 * SavGebKo.Menge).
  702. IF Art = 2 THEN AufGKon.Eingang = AufGKon.Eingang - (SavGebKo.Anz_3 * SavGebKo.Menge).
  703. AufGKon.Betrag = (AufGKon.Ausgang - AufGKon.Eingang)
  704. * (AufGKon.Depot + AufGKon.Gebuehr).
  705. LEAVE.
  706. END.
  707. RETURN.
  708. END PROCEDURE.
  709. /* _UIB-CODE-BLOCK-END */
  710. &ANALYZE-RESUME
  711. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-assign-record B-table-Win
  712. PROCEDURE local-assign-record :
  713. /*------------------------------------------------------------------------------
  714. Purpose: Override standard ADM method
  715. Notes:
  716. ------------------------------------------------------------------------------*/
  717. RUN GEBINDE_KONTO ( INPUT 2 ).
  718. RUN dispatch IN THIS-PROCEDURE ( INPUT 'assign-record':U ) .
  719. RUN GEBINDE_KONTO ( INPUT 1 ).
  720. XVAufnr = SavGebKo.Aufnr.
  721. RUN "v8/savkotot.p".
  722. IF VNeu THEN DO:
  723. END.
  724. ELSE DO:
  725. END.
  726. ASSIGN SavGebKo.Betrag_1 = SavGebKo.Anz_1 * SavGebKo.Wert_1 * SavGebKo.Menge
  727. SavGebKo.Betrag_2 = SavGebKo.Anz_2 * SavGebKo.Wert_2 * SavGebKo.Menge
  728. SavGebKo.Betrag_3 = SavGebKo.Anz_3 * SavGebKo.Wert_3 * SavGebKo.Menge.
  729. VBetrag = SavGebKo.Betrag_1 + SavGebKo.Betrag_2 + SavGebKo.Betrag_3.
  730. RUN dispatch IN THIS-PROCEDURE ('display-fields':U).
  731. RUN ANZEIGE_DETAIL.
  732. END PROCEDURE.
  733. /* _UIB-CODE-BLOCK-END */
  734. &ANALYZE-RESUME
  735. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-display-fields B-table-Win
  736. PROCEDURE local-display-fields :
  737. /*------------------------------------------------------------------------------
  738. Purpose: Override standard ADM method
  739. Notes:
  740. ------------------------------------------------------------------------------*/
  741. RUN dispatch IN THIS-PROCEDURE ( INPUT 'display-fields':U ) .
  742. IF SavGebKo.Menge <> 0 THEN DO:
  743. SavGebKo.Menge:BGCOLOR IN BROWSE {&BROWSE-NAME} = 8.
  744. VText:BGCOLOR IN BROWSE {&BROWSE-NAME} = 8.
  745. VBetrag:BGCOLOR IN BROWSE {&BROWSE-NAME} = 8.
  746. END.
  747. ELSE DO:
  748. SavGebKo.Menge:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15.
  749. VText:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15.
  750. VBetrag:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15.
  751. END.
  752. END PROCEDURE.
  753. /* _UIB-CODE-BLOCK-END */
  754. &ANALYZE-RESUME
  755. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-hide B-table-Win
  756. PROCEDURE local-hide :
  757. /*------------------------------------------------------------------------------
  758. Purpose: Override standard ADM method
  759. Notes:
  760. ------------------------------------------------------------------------------*/
  761. RUN dispatch IN THIS-PROCEDURE ( INPUT 'hide':U ) .
  762. FQOpen = FALSE.
  763. END PROCEDURE.
  764. /* _UIB-CODE-BLOCK-END */
  765. &ANALYZE-RESUME
  766. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-initialize B-table-Win
  767. PROCEDURE local-initialize :
  768. /*------------------------------------------------------------------------------
  769. Purpose: Override standard ADM method
  770. Notes:
  771. ------------------------------------------------------------------------------*/
  772. RUN dispatch IN THIS-PROCEDURE ( INPUT 'initialize':U ) .
  773. DO WITH FRAME {&FRAME-NAME}:
  774. CB-Zahart:DELIMITER = "|".
  775. XZahart = ''.
  776. ok = TRUE.
  777. xx = 0.
  778. DO WHILE ok:
  779. ok = CB-Zahart:DELETE(1).
  780. END.
  781. FOR EACH Tabel USE-INDEX Tabel-k1
  782. WHERE Tabel.Firma = GVFirma
  783. AND Tabel.RecArt = 'ZAHART'
  784. AND Tabel.CodeC = ''
  785. AND Tabel.Sprcd = 1 NO-LOCK:
  786. ok = CB-Zahart:ADD-LAST(Tabel.Bez1).
  787. XZahart = XZahart + STRING(Tabel.CodeI,"999|").
  788. END.
  789. ix = 1.
  790. CB-Zahart:SCREEN-VALUE = CB-Zahart:ENTRY(ix).
  791. VZahart = INTEGER(ENTRY(ix, XZahart, "|")).
  792. FIND Tabel USE-INDEX Tabel-k1
  793. WHERE Tabel.Firma = GVFirma
  794. AND Tabel.RecArt = 'ZAHART'
  795. AND Tabel.CodeC = ''
  796. AND Tabel.CodeI = VZahart
  797. AND Tabel.Sprcd = 1 NO-LOCK.
  798. VKonto = Tabel.Bez2.
  799. END.
  800. END PROCEDURE.
  801. /* _UIB-CODE-BLOCK-END */
  802. &ANALYZE-RESUME
  803. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-open-query B-table-Win
  804. PROCEDURE local-open-query :
  805. /*------------------------------------------------------------------------------
  806. Purpose: Override standard ADM method
  807. Notes:
  808. ------------------------------------------------------------------------------*/
  809. QOpen = FALSE.
  810. Vorhanden = FALSE.
  811. RUN dispatch IN THIS-PROCEDURE ( INPUT 'open-query':U ).
  812. QOpen = TRUE.
  813. DO WHILE TRUE WITH FRAME {&FRAME-NAME}:
  814. IF NUM-RESULTS("{&BROWSE-NAME}":U) = ? THEN LEAVE.
  815. IF NUM-RESULTS("{&BROWSE-NAME}":U) = 0 THEN LEAVE.
  816. Vorhanden = TRUE.
  817. LEAVE.
  818. END.
  819. DO WITH FRAME {&FRAME-NAME}:
  820. IF Vorhanden THEN DO:
  821. APPLY 'VALUE-CHANGED' TO BROWSE {&BROWSE-NAME}.
  822. END.
  823. END.
  824. END PROCEDURE.
  825. /* _UIB-CODE-BLOCK-END */
  826. &ANALYZE-RESUME
  827. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-view B-table-Win
  828. PROCEDURE local-view :
  829. /*------------------------------------------------------------------------------
  830. Purpose: Override standard ADM method
  831. Notes:
  832. ------------------------------------------------------------------------------*/
  833. IF XVAufnr = 0 THEN DO:
  834. RUN new-state ( INPUT 'seite_1, MAIN':U ).
  835. RETURN NO-APPLY.
  836. END.
  837. FIND Savko USE-INDEX Savko-k1
  838. WHERE Savko.Firma = GVFirma
  839. AND Savko.Aufnr = XVAufnr NO-LOCK NO-ERROR.
  840. IF NOT AVAILABLE Savko THEN DO:
  841. RUN new-state ( INPUT 'seite_1, MAIN':U ).
  842. RETURN NO-APPLY.
  843. END.
  844. RUN "v8/savkotot.p".
  845. RUN dispatch IN THIS-PROCEDURE ( INPUT 'view':U ) .
  846. FQOpen = TRUE.
  847. DO WITH FRAME {&FRAME-NAME}:
  848. RUN dispatch IN THIS-PROCEDURE ('open-query':U).
  849. RUN dispatch IN THIS-PROCEDURE ('disable-fields':U).
  850. RUN ANZEIGE_DETAIL.
  851. IF NUM-RESULTS("{&BROWSE-NAME}":U) = ? THEN LEAVE.
  852. IF NUM-RESULTS("{&BROWSE-NAME}":U) = 0 THEN LEAVE.
  853. {&BROWSE-NAME}:SELECT-FOCUSED-ROW().
  854. APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
  855. RETURN NO-APPLY.
  856. END.
  857. END PROCEDURE.
  858. /* _UIB-CODE-BLOCK-END */
  859. &ANALYZE-RESUME
  860. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE send-records B-table-Win _ADM-SEND-RECORDS
  861. PROCEDURE send-records :
  862. /*------------------------------------------------------------------------------
  863. Purpose: Send record ROWID's for all tables used by
  864. this file.
  865. Parameters: see template/snd-head.i
  866. ------------------------------------------------------------------------------*/
  867. /* Define variables needed by this internal procedure. */
  868. {src/adm/template/snd-head.i}
  869. /* For each requested table, put it's ROWID in the output list. */
  870. {src/adm/template/snd-list.i "SavGebKo"}
  871. /* Deal with any unexpected table requests before closing. */
  872. {src/adm/template/snd-end.i}
  873. END PROCEDURE.
  874. /* _UIB-CODE-BLOCK-END */
  875. &ANALYZE-RESUME
  876. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE state-changed B-table-Win
  877. PROCEDURE state-changed :
  878. /* -----------------------------------------------------------
  879. Purpose:
  880. Parameters: <none>
  881. Notes:
  882. -------------------------------------------------------------*/
  883. DEFINE INPUT PARAMETER p-issuer-hdl AS HANDLE NO-UNDO.
  884. DEFINE INPUT PARAMETER p-state AS CHARACTER NO-UNDO.
  885. CASE p-state:
  886. WHEN 'first-record' THEN DO:
  887. RUN ANZEIGE.
  888. RUN set-attribute-list('Query-Position=':U + p-state).
  889. RETURN NO-APPLY.
  890. END.
  891. WHEN 'browser_entry' THEN DO:
  892. APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
  893. RETURN NO-APPLY.
  894. END.
  895. {src/adm/template/bstates.i}
  896. END CASE.
  897. END PROCEDURE.
  898. /* _UIB-CODE-BLOCK-END */
  899. &ANALYZE-RESUME