f-debzahlung.w 73 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312
  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 aDebop NO-UNDO LIKE Debop.
  9. DEFINE TEMP-TABLE tDebop NO-UNDO LIKE Debop.
  10. DEFINE TEMP-TABLE zDebop NO-UNDO LIKE Debop
  11. FIELD SkMax_Frw AS DEC
  12. FIELD SkMax AS DEC
  13. FIELD ZaKonto AS CHAR.
  14. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS fFrameWin
  15. /*------------------------------------------------------------------------
  16. File:
  17. Description: from cntnrfrm.w - ADM2 SmartFrame Template
  18. Input Parameters:
  19. <none>
  20. Output Parameters:
  21. <none>
  22. ------------------------------------------------------------------------*/
  23. /* This .W file was created with the Progress AppBuilder. */
  24. /*----------------------------------------------------------------------*/
  25. /* Create an unnamed pool to store all the widgets created
  26. by this procedure. This is a good default which assures
  27. that this procedure's triggers and internal procedures
  28. will execute in this procedure's storage, and that proper
  29. cleanup will occur on deletion of the procedure. */
  30. CREATE WIDGET-POOL.
  31. /* *************************** Definitions ************************** */
  32. /* Parameters Definitions --- */
  33. /* Local Variable Definitions --- */
  34. DEF VAR SAktiv AS LOG NO-UNDO INIT FALSE.
  35. DEF VAR FMut AS LOG NO-UNDO INIT FALSE.
  36. DEF VAR ProgName AS CHAR NO-UNDO.
  37. DEF VAR Firma AS CHAR NO-UNDO.
  38. DEF VAR D1Firma AS CHAR NO-UNDO.
  39. DEF VAR AdFirma AS CHAR NO-UNDO.
  40. DEF VAR FBFirma AS CHAR NO-UNDO.
  41. DEF VAR GlobFir AS CHAR NO-UNDO.
  42. DEF VAR GlobFil AS CHAR INIT '0000' NO-UNDO.
  43. DEF VAR GlobKon AS CHAR INIT '9999' NO-UNDO.
  44. DEF VAR Eingabe AS CHAR NO-UNDO.
  45. DEF VAR iKnr AS INT NO-UNDO.
  46. DEF VAR FAkt AS LOG NO-UNDO INIT FALSE.
  47. DEF VAR sDatum AS DATE NO-UNDO.
  48. DEF VAR SkTolPr AS DEC NO-UNDO.
  49. DEF VAR SkTolBe AS DEC NO-UNDO.
  50. DEF VAR BasFrw AS CHAR NO-UNDO.
  51. DEF TEMP-TABLE tTotale
  52. FIELD Konto AS CHAR
  53. FIELD Betr AS DEC
  54. FIELD BetrFrw AS DEC.
  55. { incl/tmwstcalc.i }
  56. /* _UIB-CODE-BLOCK-END */
  57. &ANALYZE-RESUME
  58. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  59. /* ******************** Preprocessor Definitions ******************** */
  60. &Scoped-define PROCEDURE-TYPE SmartFrame
  61. &Scoped-define DB-AWARE no
  62. &Scoped-define ADM-CONTAINER FRAME
  63. &Scoped-define ADM-SUPPORTED-LINKS Data-Target,Data-Source,Page-Target,Update-Source,Update-Target
  64. /* Name of designated FRAME-NAME and/or first browse and/or first query */
  65. &Scoped-define FRAME-NAME fMain
  66. &Scoped-define BROWSE-NAME Br_Bezahlt
  67. /* Internal Tables (found by Frame, Query & Browse Queries) */
  68. &Scoped-define INTERNAL-TABLES ADebop
  69. /* Definitions for BROWSE Br_Bezahlt */
  70. &Scoped-define FIELDS-IN-QUERY-Br_Bezahlt ADebop.Knr ADebop.Faknr ~
  71. ADebop.Faellig ADebop.Fakbetr ADebop.Fakbetr_FRW ADebop.Zahdat ~
  72. ADebop.Zahbetr ADebop.Zahbetr_FRW ADebop.Saldo ADebop.Saldo_FRW
  73. &Scoped-define ENABLED-FIELDS-IN-QUERY-Br_Bezahlt
  74. &Scoped-define QUERY-STRING-Br_Bezahlt FOR EACH ADebop NO-LOCK INDEXED-REPOSITION
  75. &Scoped-define OPEN-QUERY-Br_Bezahlt OPEN QUERY Br_Bezahlt FOR EACH ADebop NO-LOCK INDEXED-REPOSITION.
  76. &Scoped-define TABLES-IN-QUERY-Br_Bezahlt ADebop
  77. &Scoped-define FIRST-TABLE-IN-QUERY-Br_Bezahlt ADebop
  78. /* Definitions for FRAME fMain */
  79. &Scoped-define OPEN-BROWSERS-IN-QUERY-fMain ~
  80. ~{&OPEN-QUERY-Br_Bezahlt}
  81. /* Standard List Definitions */
  82. &Scoped-Define ENABLED-FIELDS tDebop.Faknr tDebop.Fakdat tDebop.Faellig ~
  83. tDebop.FRW tDebop.Kurs tDebop.Fakbetr tDebop.Fakbetr_FRW tDebop.Zahbetr ~
  84. tDebop.Zahbetr_FRW tDebop.Skonto tDebop.Skonto_FRW tDebop.Saldo ~
  85. tDebop.Saldo_FRW zDebop.Zahbetr_FRW zDebop.FRW zDebop.Kurs zDebop.Zahbetr ~
  86. zDebop.Skonto_FRW zDebop.Skonto
  87. &Scoped-define ENABLED-TABLES tDebop zDebop
  88. &Scoped-define FIRST-ENABLED-TABLE tDebop
  89. &Scoped-define SECOND-ENABLED-TABLE zDebop
  90. &Scoped-Define ENABLED-OBJECTS Btn_Tot RECT-1 RECT-2 RECT-3 RECT-4 RECT-5 ~
  91. CB_ZAHKONTO F_KumBetr Btn_Kum F_KonBetr Btn_Kon F_TotBetr F_KumFrw F_KonFrw ~
  92. F_TotFrw F_Datum CB_Eingabe F_Faknr F_Knr F_Betr F_ZKnr F_Adresse F_Saldo ~
  93. F_SaldoFrw F_SkMFrw Br_Bezahlt
  94. &Scoped-Define DISPLAYED-FIELDS tDebop.Faknr tDebop.Fakdat tDebop.Faellig ~
  95. tDebop.FRW tDebop.Kurs tDebop.Fakbetr tDebop.Fakbetr_FRW tDebop.Zahbetr ~
  96. tDebop.Zahbetr_FRW tDebop.Skonto tDebop.Skonto_FRW tDebop.Saldo ~
  97. tDebop.Saldo_FRW zDebop.Zahbetr_FRW zDebop.FRW zDebop.Kurs zDebop.Zahbetr ~
  98. zDebop.Skonto_FRW zDebop.Skonto
  99. &Scoped-define DISPLAYED-TABLES tDebop zDebop
  100. &Scoped-define FIRST-DISPLAYED-TABLE tDebop
  101. &Scoped-define SECOND-DISPLAYED-TABLE zDebop
  102. &Scoped-Define DISPLAYED-OBJECTS CB_ZAHKONTO F_KumBetr F_KonBetr F_TotBetr ~
  103. F_KumFrw F_KonFrw F_TotFrw F_Datum F_Faknr F_Knr F_Betr F_ZKnr F_Adresse ~
  104. F_Saldo F_SaldoFrw F_SkMFrw
  105. /* Custom List Definitions */
  106. /* List-1,List-2,List-3,List-4,List-5,List-6 */
  107. &Scoped-define List-4 F_KumBetr F_KonBetr F_TotBetr F_KumFrw F_KonFrw ~
  108. F_TotFrw
  109. &Scoped-define List-5 zDebop.Zahbetr_FRW zDebop.FRW zDebop.Kurs ~
  110. zDebop.Zahbetr zDebop.Skonto_FRW F_SkMFrw zDebop.Skonto
  111. &Scoped-define List-6 F_ZKnr F_Adresse F_Saldo F_SaldoFrw tDebop.Faknr ~
  112. tDebop.Fakdat tDebop.Faellig tDebop.FRW tDebop.Kurs tDebop.Fakbetr ~
  113. tDebop.Fakbetr_FRW tDebop.Zahbetr tDebop.Zahbetr_FRW tDebop.Skonto ~
  114. tDebop.Skonto_FRW tDebop.Saldo tDebop.Saldo_FRW
  115. /* _UIB-PREPROCESSOR-BLOCK-END */
  116. &ANALYZE-RESUME
  117. /* *********************** Control Definitions ********************** */
  118. /* Definitions of the field level widgets */
  119. DEFINE BUTTON Btn_Kon
  120. IMAGE-UP FILE "grafik/deleterec.bmp":U
  121. LABEL "&O"
  122. SIZE 5.2 BY 1.14 TOOLTIP "Löschen Konto-Total".
  123. DEFINE BUTTON Btn_Kum
  124. IMAGE-UP FILE "grafik/deleterec.bmp":U
  125. LABEL "&K"
  126. SIZE 5.2 BY 1.14 TOOLTIP "Löschen Kummulativ".
  127. DEFINE BUTTON Btn_Tot
  128. IMAGE-UP FILE "grafik/deleterec.bmp":U NO-FOCUS
  129. LABEL "&T"
  130. SIZE 5.2 BY 1.14 TOOLTIP "Lösche Gesamt-Total".
  131. DEFINE VARIABLE CB_Eingabe AS CHARACTER FORMAT "X(256)":U INITIAL "1"
  132. LABEL "Eingabe"
  133. VIEW-AS COMBO-BOX INNER-LINES 5
  134. LIST-ITEM-PAIRS "Fakturanummer","1",
  135. "Kundennummer","2",
  136. "Betrag","3"
  137. DROP-DOWN-LIST
  138. SIZE 26.4 BY 1
  139. BGCOLOR 15 NO-UNDO.
  140. DEFINE VARIABLE CB_ZAHKONTO AS CHARACTER FORMAT "X(256)":U
  141. LABEL "Konto"
  142. VIEW-AS COMBO-BOX INNER-LINES 5
  143. LIST-ITEM-PAIRS "Item 1","Item 1"
  144. DROP-DOWN-LIST
  145. SIZE 30 BY 1
  146. BGCOLOR 15 NO-UNDO.
  147. DEFINE VARIABLE F_Adresse AS CHARACTER FORMAT "X(256)":U
  148. VIEW-AS FILL-IN NATIVE
  149. SIZE 66 BY 1
  150. BGCOLOR 8 NO-UNDO.
  151. DEFINE VARIABLE F_Betr AS DECIMAL FORMAT "z,zzz,zz9.99-":U INITIAL 0
  152. LABEL "Rechnungsbetrag"
  153. VIEW-AS FILL-IN NATIVE
  154. SIZE 20 BY 1
  155. BGCOLOR 15 NO-UNDO.
  156. DEFINE VARIABLE F_Datum AS DATE FORMAT "99.99.9999":U
  157. LABEL "Datum"
  158. VIEW-AS FILL-IN NATIVE
  159. SIZE 16 BY 1 TOOLTIP "Zahlungsdatum"
  160. BGCOLOR 15 NO-UNDO.
  161. DEFINE VARIABLE F_Faknr AS DECIMAL FORMAT "9999999":U INITIAL 0
  162. LABEL "Rechnungsnummer"
  163. VIEW-AS FILL-IN NATIVE
  164. SIZE 12 BY 1
  165. BGCOLOR 15 NO-UNDO.
  166. DEFINE VARIABLE F_Knr AS DECIMAL FORMAT "999999":U INITIAL 0
  167. LABEL "Kundennummer"
  168. VIEW-AS FILL-IN NATIVE
  169. SIZE 10 BY 1
  170. BGCOLOR 15 NO-UNDO.
  171. DEFINE VARIABLE F_KonBetr AS DECIMAL FORMAT "zz,zzz,zz9.99-":U INITIAL 0
  172. VIEW-AS FILL-IN NATIVE
  173. SIZE 21 BY 1
  174. BGCOLOR 14 NO-UNDO.
  175. DEFINE VARIABLE F_KonFrw AS DECIMAL FORMAT "zz,zzz,zz9.99-":U INITIAL 0
  176. VIEW-AS FILL-IN NATIVE
  177. SIZE 21 BY 1
  178. BGCOLOR 14 NO-UNDO.
  179. DEFINE VARIABLE F_KumBetr AS DECIMAL FORMAT "zz,zzz,zz9.99-":U INITIAL 0
  180. VIEW-AS FILL-IN NATIVE
  181. SIZE 21 BY 1
  182. BGCOLOR 14 NO-UNDO.
  183. DEFINE VARIABLE F_KumFrw AS DECIMAL FORMAT "zz,zzz,zz9.99-":U INITIAL 0
  184. VIEW-AS FILL-IN NATIVE
  185. SIZE 21 BY 1
  186. BGCOLOR 14 NO-UNDO.
  187. DEFINE VARIABLE F_Saldo AS DECIMAL FORMAT "zzzzz,zz9.99-":U INITIAL 0
  188. LABEL "Saldo"
  189. VIEW-AS FILL-IN NATIVE
  190. SIZE 19 BY 1
  191. BGCOLOR 8 NO-UNDO.
  192. DEFINE VARIABLE F_SaldoFrw AS DECIMAL FORMAT "zzzzz,zz9.99-":U INITIAL 0
  193. VIEW-AS FILL-IN NATIVE
  194. SIZE 19 BY 1
  195. BGCOLOR 8 NO-UNDO.
  196. DEFINE VARIABLE F_SkMFrw AS DECIMAL FORMAT "zzzzzz,zz9.99-":U INITIAL 0
  197. LABEL "/ Max"
  198. VIEW-AS FILL-IN NATIVE
  199. SIZE 22 BY 1
  200. BGCOLOR 8 NO-UNDO.
  201. DEFINE VARIABLE F_TotBetr AS DECIMAL FORMAT "zz,zzz,zz9.99-":U INITIAL 0
  202. VIEW-AS FILL-IN NATIVE
  203. SIZE 21 BY 1
  204. BGCOLOR 14 NO-UNDO.
  205. DEFINE VARIABLE F_TotFrw AS DECIMAL FORMAT "zz,zzz,zz9.99-":U INITIAL 0
  206. VIEW-AS FILL-IN NATIVE
  207. SIZE 21 BY 1
  208. BGCOLOR 14 NO-UNDO.
  209. DEFINE VARIABLE F_ZKnr AS INTEGER FORMAT "999999":U INITIAL 0
  210. LABEL "Kunde"
  211. VIEW-AS FILL-IN NATIVE
  212. SIZE 10 BY 1
  213. BGCOLOR 8 NO-UNDO.
  214. DEFINE RECTANGLE RECT-1
  215. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  216. SIZE 134 BY 3.57.
  217. DEFINE RECTANGLE RECT-2
  218. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  219. SIZE 134 BY 1.62.
  220. DEFINE RECTANGLE RECT-3
  221. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  222. SIZE 134 BY 6.
  223. DEFINE RECTANGLE RECT-4
  224. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  225. SIZE 134 BY 2.57.
  226. DEFINE RECTANGLE RECT-5
  227. EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL
  228. SIZE 134 BY 6.67.
  229. /* Query definitions */
  230. &ANALYZE-SUSPEND
  231. DEFINE QUERY Br_Bezahlt FOR
  232. ADebop SCROLLING.
  233. &ANALYZE-RESUME
  234. /* Browse definitions */
  235. DEFINE BROWSE Br_Bezahlt
  236. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_Bezahlt fFrameWin _STRUCTURED
  237. QUERY Br_Bezahlt NO-LOCK DISPLAY
  238. ADebop.Knr FORMAT "999999":U
  239. ADebop.Faknr FORMAT "zzzzz9":U
  240. ADebop.Faellig FORMAT "99.99.9999":U
  241. ADebop.Fakbetr FORMAT "z,zzz,zz9.99-":U
  242. ADebop.Fakbetr_FRW COLUMN-LABEL "Fakbetr Frw" FORMAT "z,zzz,zz9.99-":U
  243. ADebop.Zahdat COLUMN-LABEL "Zahldatum" FORMAT "99.99.9999":U
  244. ADebop.Zahbetr COLUMN-LABEL "bezahlt" FORMAT "z,zzz,zz9.99-":U
  245. ADebop.Zahbetr_FRW COLUMN-LABEL "bezahlt Frw" FORMAT "z,zzz,zz9.99-":U
  246. ADebop.Saldo FORMAT "z,zzz,zz9.99-":U
  247. ADebop.Saldo_FRW COLUMN-LABEL "Saldo Frw" FORMAT "z,zzz,zz9.99-":U
  248. /* _UIB-CODE-BLOCK-END */
  249. &ANALYZE-RESUME
  250. WITH NO-ROW-MARKERS SEPARATORS NO-TAB-STOP SIZE 126.8 BY 5.91
  251. BGCOLOR 15 .
  252. /* ************************ Frame Definitions *********************** */
  253. DEFINE FRAME fMain
  254. Btn_Tot AT ROW 2.52 COL 129
  255. CB_ZAHKONTO AT ROW 2.52 COL 10 COLON-ALIGNED
  256. F_KumBetr AT ROW 2.52 COL 45 COLON-ALIGNED NO-LABEL NO-TAB-STOP
  257. Btn_Kum AT ROW 2.52 COL 69 NO-TAB-STOP
  258. F_KonBetr AT ROW 2.52 COL 75 COLON-ALIGNED NO-LABEL NO-TAB-STOP
  259. Btn_Kon AT ROW 2.52 COL 99 NO-TAB-STOP
  260. F_TotBetr AT ROW 2.52 COL 105 COLON-ALIGNED NO-LABEL NO-TAB-STOP
  261. F_KumFrw AT ROW 3.52 COL 45 COLON-ALIGNED NO-LABEL NO-TAB-STOP
  262. F_KonFrw AT ROW 3.52 COL 75 COLON-ALIGNED NO-LABEL NO-TAB-STOP
  263. F_TotFrw AT ROW 3.52 COL 105 COLON-ALIGNED NO-LABEL NO-TAB-STOP
  264. F_Datum AT ROW 5.38 COL 10 COLON-ALIGNED
  265. CB_Eingabe AT ROW 5.38 COL 38 COLON-ALIGNED
  266. F_Faknr AT ROW 5.38 COL 88 COLON-ALIGNED
  267. F_Knr AT ROW 5.38 COL 88 COLON-ALIGNED
  268. F_Betr AT ROW 5.38 COL 88 COLON-ALIGNED
  269. F_ZKnr AT ROW 7.38 COL 10 COLON-ALIGNED NO-TAB-STOP
  270. F_Adresse AT ROW 7.38 COL 20.2 COLON-ALIGNED NO-LABEL NO-TAB-STOP
  271. F_Saldo AT ROW 7.38 COL 94 COLON-ALIGNED NO-TAB-STOP
  272. F_SaldoFrw AT ROW 7.38 COL 113 COLON-ALIGNED NO-LABEL NO-TAB-STOP
  273. tDebop.Faknr AT ROW 9.71 COL 10 COLON-ALIGNED NO-LABEL FORMAT "9999999"
  274. VIEW-AS FILL-IN NATIVE
  275. SIZE 12 BY 1
  276. BGCOLOR 8 NO-TAB-STOP
  277. tDebop.Fakdat AT ROW 9.71 COL 25 COLON-ALIGNED NO-LABEL FORMAT "99.99.9999"
  278. VIEW-AS FILL-IN NATIVE
  279. SIZE 16 BY 1
  280. BGCOLOR 8 NO-TAB-STOP
  281. tDebop.Faellig AT ROW 9.71 COL 41 COLON-ALIGNED NO-LABEL FORMAT "99.99.9999"
  282. VIEW-AS FILL-IN NATIVE
  283. SIZE 16 BY 1
  284. BGCOLOR 8 NO-TAB-STOP
  285. tDebop.FRW AT ROW 9.71 COL 65 COLON-ALIGNED NO-LABEL FORMAT "x(03)"
  286. VIEW-AS FILL-IN NATIVE
  287. SIZE 6 BY 1
  288. BGCOLOR 8 NO-TAB-STOP
  289. tDebop.Kurs AT ROW 9.71 COL 71 COLON-ALIGNED NO-LABEL FORMAT "zzz9.9999"
  290. VIEW-AS FILL-IN NATIVE
  291. SIZE 15 BY 1
  292. BGCOLOR 8 NO-TAB-STOP
  293. tDebop.Fakbetr AT ROW 9.71 COL 90 NO-LABEL FORMAT "zzzzzz,zz9.99-"
  294. VIEW-AS FILL-IN NATIVE
  295. SIZE 22 BY 1
  296. BGCOLOR 8 NO-TAB-STOP
  297. tDebop.Fakbetr_FRW AT ROW 9.71 COL 110 COLON-ALIGNED NO-LABEL FORMAT "zzzzzz,zz9.99-"
  298. VIEW-AS FILL-IN NATIVE
  299. SIZE 22 BY 1
  300. BGCOLOR 8 NO-TAB-STOP
  301. tDebop.Zahbetr AT ROW 11.71 COL 10 COLON-ALIGNED NO-LABEL FORMAT "zzz,zzz,zz9.99-"
  302. VIEW-AS FILL-IN NATIVE
  303. SIZE 22 BY 1
  304. BGCOLOR 8 NO-TAB-STOP
  305. tDebop.Zahbetr_FRW AT ROW 11.71 COL 32 COLON-ALIGNED NO-LABEL FORMAT "zzz,zzz,zz9.99-"
  306. VIEW-AS FILL-IN NATIVE
  307. SIZE 22 BY 1
  308. BGCOLOR 8 NO-TAB-STOP
  309. tDebop.Skonto AT ROW 11.71 COL 54 COLON-ALIGNED NO-LABEL FORMAT "zzzzz9.99-"
  310. VIEW-AS FILL-IN NATIVE
  311. SIZE 16 BY 1
  312. BGCOLOR 8 NO-TAB-STOP
  313. tDebop.Skonto_FRW AT ROW 11.71 COL 70 COLON-ALIGNED NO-LABEL FORMAT "zzzzz9.99-"
  314. VIEW-AS FILL-IN NATIVE
  315. SIZE 16 BY 1
  316. BGCOLOR 8 NO-TAB-STOP
  317. tDebop.Saldo AT ROW 11.71 COL 88 COLON-ALIGNED NO-LABEL FORMAT "zzzzzz,zz9.99-"
  318. VIEW-AS FILL-IN NATIVE
  319. SIZE 22 BY 1
  320. BGCOLOR 8 NO-TAB-STOP
  321. tDebop.Saldo_FRW AT ROW 11.71 COL 110 COLON-ALIGNED NO-LABEL FORMAT "zzzzzz,zz9.99-"
  322. VIEW-AS FILL-IN NATIVE
  323. SIZE 22 BY 1
  324. BGCOLOR 8 NO-TAB-STOP
  325. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
  326. SIDE-LABELS NO-UNDERLINE THREE-D
  327. AT COL 1 ROW 1
  328. SIZE 135.6 BY 21.95.
  329. /* DEFINE FRAME statement is approaching 4K Bytes. Breaking it up */
  330. DEFINE FRAME fMain
  331. zDebop.Zahbetr_FRW AT ROW 13.62 COL 14 COLON-ALIGNED
  332. LABEL "Betrag/Frw" FORMAT "zzz,zzz,zz9.99-"
  333. VIEW-AS FILL-IN NATIVE
  334. SIZE 23 BY 1
  335. BGCOLOR 15
  336. zDebop.FRW AT ROW 13.62 COL 37 COLON-ALIGNED NO-LABEL AUTO-RETURN FORMAT "x(03)"
  337. VIEW-AS FILL-IN NATIVE
  338. SIZE 8 BY 1
  339. BGCOLOR 15 NO-TAB-STOP
  340. zDebop.Kurs AT ROW 13.62 COL 52 COLON-ALIGNED
  341. LABEL "Kurs" FORMAT "zzz9.9999"
  342. VIEW-AS FILL-IN NATIVE
  343. SIZE 15 BY 1
  344. BGCOLOR 15
  345. zDebop.Zahbetr AT ROW 13.62 COL 81 COLON-ALIGNED
  346. LABEL "Betrag CHF" FORMAT "zzz,zzz,zz9.99-"
  347. VIEW-AS FILL-IN NATIVE
  348. SIZE 23 BY 1
  349. BGCOLOR 15
  350. zDebop.Skonto_FRW AT ROW 14.62 COL 14 COLON-ALIGNED
  351. LABEL "Skonto/Frw" FORMAT "zzz,zzz,zz9.99-"
  352. VIEW-AS FILL-IN NATIVE
  353. SIZE 23 BY 1
  354. BGCOLOR 15
  355. F_SkMFrw AT ROW 14.62 COL 45 COLON-ALIGNED NO-TAB-STOP
  356. zDebop.Skonto AT ROW 14.62 COL 81 COLON-ALIGNED
  357. LABEL "Skonto CHF" FORMAT "zzz,zzz,zz9.99-"
  358. VIEW-AS FILL-IN NATIVE
  359. SIZE 23 BY 1
  360. BGCOLOR 15
  361. Br_Bezahlt AT ROW 16.48 COL 5.4
  362. "Frw" VIEW-AS TEXT
  363. SIZE 6 BY 1 AT ROW 8.71 COL 67
  364. " Faknr" VIEW-AS TEXT
  365. SIZE 10 BY 1 AT ROW 8.71 COL 12
  366. " Betrag in Frw" VIEW-AS TEXT
  367. SIZE 22 BY 1 AT ROW 8.71 COL 112
  368. " Fakturadatum" VIEW-AS TEXT
  369. SIZE 16 BY 1 AT ROW 8.71 COL 27
  370. " bereits bezahlt" VIEW-AS TEXT
  371. SIZE 22 BY 1 AT ROW 10.71 COL 12
  372. " Skonti" VIEW-AS TEXT
  373. SIZE 16 BY 1 AT ROW 10.71 COL 56
  374. " Saldo/Frw" VIEW-AS TEXT
  375. SIZE 22 BY 1 AT ROW 10.71 COL 112
  376. "Gesamt-Total" VIEW-AS TEXT
  377. SIZE 14 BY 1 AT ROW 1.52 COL 114
  378. "Konto-Total" VIEW-AS TEXT
  379. SIZE 12 BY 1 AT ROW 1.52 COL 85
  380. " Fällig" VIEW-AS TEXT
  381. SIZE 16 BY 1 AT ROW 8.71 COL 43
  382. " Skonti/Frw" VIEW-AS TEXT
  383. SIZE 16 BY 1 AT ROW 10.71 COL 72
  384. " Rechnungsbetrag" VIEW-AS TEXT
  385. SIZE 22 BY 1 AT ROW 8.71 COL 90
  386. " Kurs" VIEW-AS TEXT
  387. SIZE 15 BY 1 AT ROW 8.71 COL 73
  388. "Kummulativ" VIEW-AS TEXT
  389. SIZE 13 BY 1 AT ROW 1.52 COL 55
  390. " Saldo" VIEW-AS TEXT
  391. SIZE 22 BY 1 AT ROW 10.71 COL 90
  392. " bereits bezahlt/Frw" VIEW-AS TEXT
  393. SIZE 22 BY 1 AT ROW 10.71 COL 34
  394. RECT-1 AT ROW 1.24 COL 2
  395. RECT-2 AT ROW 5.05 COL 2
  396. RECT-3 AT ROW 7 COL 2
  397. RECT-4 AT ROW 13.29 COL 2
  398. RECT-5 AT ROW 16.05 COL 2
  399. WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY
  400. SIDE-LABELS NO-UNDERLINE THREE-D
  401. AT COL 1 ROW 1
  402. SIZE 135.6 BY 21.95.
  403. /* *********************** Procedure Settings ************************ */
  404. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  405. /* Settings for THIS-PROCEDURE
  406. Type: SmartFrame
  407. Allow: Basic,Browse,DB-Fields,Query,Smart
  408. Container Links: Data-Target,Data-Source,Page-Target,Update-Source,Update-Target
  409. Other Settings: PERSISTENT-ONLY COMPILE
  410. Temp-Tables and Buffers:
  411. TABLE: aDebop T "?" NO-UNDO AnaDat Debop
  412. TABLE: tDebop T "?" NO-UNDO AnaDat Debop
  413. TABLE: zDebop T "?" NO-UNDO AnaDat Debop
  414. ADDITIONAL-FIELDS:
  415. FIELD SkMax_Frw AS DEC
  416. FIELD SkMax AS DEC
  417. FIELD ZaKonto AS CHAR
  418. END-FIELDS.
  419. END-TABLES.
  420. */
  421. /* This procedure should always be RUN PERSISTENT. Report the error, */
  422. /* then cleanup and return. */
  423. IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  424. MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
  425. VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  426. RETURN.
  427. END.
  428. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  429. /* ************************* Create Window ************************** */
  430. &ANALYZE-SUSPEND _CREATE-WINDOW
  431. /* DESIGN Window definition (used by the UIB)
  432. CREATE WINDOW fFrameWin ASSIGN
  433. HEIGHT = 21.95
  434. WIDTH = 135.6.
  435. /* END WINDOW DEFINITION */
  436. */
  437. &ANALYZE-RESUME
  438. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB fFrameWin
  439. /* ************************* Included-Libraries *********************** */
  440. {src/adm2/containr.i}
  441. /* _UIB-CODE-BLOCK-END */
  442. &ANALYZE-RESUME
  443. /* *********** Runtime Attributes and AppBuilder Settings *********** */
  444. &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
  445. /* SETTINGS FOR WINDOW fFrameWin
  446. VISIBLE,,RUN-PERSISTENT */
  447. /* SETTINGS FOR FRAME fMain
  448. NOT-VISIBLE FRAME-NAME */
  449. /* BROWSE-TAB Br_Bezahlt Skonto fMain */
  450. ASSIGN
  451. FRAME fMain:HIDDEN = TRUE.
  452. /* SETTINGS FOR COMBO-BOX CB_Eingabe IN FRAME fMain
  453. NO-DISPLAY */
  454. /* SETTINGS FOR FILL-IN tDebop.Faellig IN FRAME fMain
  455. 6 EXP-LABEL EXP-FORMAT */
  456. ASSIGN
  457. tDebop.Faellig:READ-ONLY IN FRAME fMain = TRUE.
  458. /* SETTINGS FOR FILL-IN tDebop.Fakbetr IN FRAME fMain
  459. ALIGN-L 6 EXP-LABEL EXP-FORMAT */
  460. ASSIGN
  461. tDebop.Fakbetr:READ-ONLY IN FRAME fMain = TRUE.
  462. /* SETTINGS FOR FILL-IN tDebop.Fakbetr_FRW IN FRAME fMain
  463. 6 EXP-LABEL EXP-FORMAT */
  464. ASSIGN
  465. tDebop.Fakbetr_FRW:READ-ONLY IN FRAME fMain = TRUE.
  466. /* SETTINGS FOR FILL-IN tDebop.Fakdat IN FRAME fMain
  467. 6 EXP-LABEL EXP-FORMAT */
  468. ASSIGN
  469. tDebop.Fakdat:READ-ONLY IN FRAME fMain = TRUE.
  470. /* SETTINGS FOR FILL-IN tDebop.Faknr IN FRAME fMain
  471. 6 EXP-LABEL EXP-FORMAT */
  472. ASSIGN
  473. tDebop.Faknr:READ-ONLY IN FRAME fMain = TRUE.
  474. /* SETTINGS FOR FILL-IN zDebop.FRW IN FRAME fMain
  475. 5 EXP-LABEL EXP-FORMAT */
  476. ASSIGN
  477. zDebop.FRW:READ-ONLY IN FRAME fMain = TRUE.
  478. /* SETTINGS FOR FILL-IN tDebop.FRW IN FRAME fMain
  479. 6 EXP-LABEL EXP-FORMAT */
  480. ASSIGN
  481. tDebop.FRW:READ-ONLY IN FRAME fMain = TRUE.
  482. /* SETTINGS FOR FILL-IN F_Adresse IN FRAME fMain
  483. 6 */
  484. ASSIGN
  485. F_Adresse:READ-ONLY IN FRAME fMain = TRUE.
  486. ASSIGN
  487. F_Faknr:HIDDEN IN FRAME fMain = TRUE.
  488. ASSIGN
  489. F_Knr:HIDDEN IN FRAME fMain = TRUE.
  490. /* SETTINGS FOR FILL-IN F_KonBetr IN FRAME fMain
  491. 4 */
  492. ASSIGN
  493. F_KonBetr:READ-ONLY IN FRAME fMain = TRUE.
  494. /* SETTINGS FOR FILL-IN F_KonFrw IN FRAME fMain
  495. 4 */
  496. ASSIGN
  497. F_KonFrw:READ-ONLY IN FRAME fMain = TRUE.
  498. /* SETTINGS FOR FILL-IN F_KumBetr IN FRAME fMain
  499. 4 */
  500. ASSIGN
  501. F_KumBetr:READ-ONLY IN FRAME fMain = TRUE.
  502. /* SETTINGS FOR FILL-IN F_KumFrw IN FRAME fMain
  503. 4 */
  504. ASSIGN
  505. F_KumFrw:READ-ONLY IN FRAME fMain = TRUE.
  506. /* SETTINGS FOR FILL-IN F_Saldo IN FRAME fMain
  507. 6 */
  508. ASSIGN
  509. F_Saldo:READ-ONLY IN FRAME fMain = TRUE.
  510. /* SETTINGS FOR FILL-IN F_SaldoFrw IN FRAME fMain
  511. 6 */
  512. ASSIGN
  513. F_SaldoFrw:READ-ONLY IN FRAME fMain = TRUE.
  514. /* SETTINGS FOR FILL-IN F_SkMFrw IN FRAME fMain
  515. 5 */
  516. ASSIGN
  517. F_SkMFrw:READ-ONLY IN FRAME fMain = TRUE.
  518. /* SETTINGS FOR FILL-IN F_TotBetr IN FRAME fMain
  519. 4 */
  520. ASSIGN
  521. F_TotBetr:READ-ONLY IN FRAME fMain = TRUE.
  522. /* SETTINGS FOR FILL-IN F_TotFrw IN FRAME fMain
  523. 4 */
  524. ASSIGN
  525. F_TotFrw:READ-ONLY IN FRAME fMain = TRUE.
  526. /* SETTINGS FOR FILL-IN F_ZKnr IN FRAME fMain
  527. 6 */
  528. ASSIGN
  529. F_ZKnr:READ-ONLY IN FRAME fMain = TRUE.
  530. /* SETTINGS FOR FILL-IN zDebop.Kurs IN FRAME fMain
  531. 5 EXP-LABEL EXP-FORMAT */
  532. ASSIGN
  533. zDebop.Kurs:READ-ONLY IN FRAME fMain = TRUE.
  534. /* SETTINGS FOR FILL-IN tDebop.Kurs IN FRAME fMain
  535. 6 EXP-LABEL EXP-FORMAT */
  536. ASSIGN
  537. tDebop.Kurs:READ-ONLY IN FRAME fMain = TRUE.
  538. /* SETTINGS FOR FILL-IN tDebop.Saldo IN FRAME fMain
  539. 6 EXP-LABEL EXP-FORMAT */
  540. ASSIGN
  541. tDebop.Saldo:READ-ONLY IN FRAME fMain = TRUE.
  542. /* SETTINGS FOR FILL-IN tDebop.Saldo_FRW IN FRAME fMain
  543. 6 EXP-LABEL EXP-FORMAT */
  544. ASSIGN
  545. tDebop.Saldo_FRW:READ-ONLY IN FRAME fMain = TRUE.
  546. /* SETTINGS FOR FILL-IN zDebop.Skonto IN FRAME fMain
  547. 5 EXP-LABEL EXP-FORMAT */
  548. ASSIGN
  549. zDebop.Skonto:READ-ONLY IN FRAME fMain = TRUE.
  550. /* SETTINGS FOR FILL-IN tDebop.Skonto IN FRAME fMain
  551. 6 EXP-LABEL EXP-FORMAT */
  552. ASSIGN
  553. tDebop.Skonto:READ-ONLY IN FRAME fMain = TRUE.
  554. /* SETTINGS FOR FILL-IN tDebop.Skonto_FRW IN FRAME fMain
  555. 6 EXP-LABEL EXP-FORMAT */
  556. ASSIGN
  557. tDebop.Skonto_FRW:READ-ONLY IN FRAME fMain = TRUE.
  558. /* SETTINGS FOR FILL-IN zDebop.Skonto_FRW IN FRAME fMain
  559. 5 EXP-LABEL EXP-FORMAT */
  560. ASSIGN
  561. zDebop.Skonto_FRW:READ-ONLY IN FRAME fMain = TRUE.
  562. /* SETTINGS FOR FILL-IN tDebop.Zahbetr IN FRAME fMain
  563. 6 EXP-LABEL EXP-FORMAT */
  564. ASSIGN
  565. tDebop.Zahbetr:READ-ONLY IN FRAME fMain = TRUE.
  566. /* SETTINGS FOR FILL-IN zDebop.Zahbetr IN FRAME fMain
  567. 5 EXP-LABEL EXP-FORMAT */
  568. ASSIGN
  569. zDebop.Zahbetr:READ-ONLY IN FRAME fMain = TRUE.
  570. /* SETTINGS FOR FILL-IN tDebop.Zahbetr_FRW IN FRAME fMain
  571. 6 EXP-LABEL EXP-FORMAT */
  572. ASSIGN
  573. tDebop.Zahbetr_FRW:READ-ONLY IN FRAME fMain = TRUE.
  574. /* SETTINGS FOR FILL-IN zDebop.Zahbetr_FRW IN FRAME fMain
  575. 5 EXP-LABEL EXP-FORMAT */
  576. ASSIGN
  577. zDebop.Zahbetr_FRW:READ-ONLY IN FRAME fMain = TRUE.
  578. /* _RUN-TIME-ATTRIBUTES-END */
  579. &ANALYZE-RESUME
  580. /* Setting information for Queries and Browse Widgets fields */
  581. &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_Bezahlt
  582. /* Query rebuild information for BROWSE Br_Bezahlt
  583. _TblList = "Temp-Tables.ADebop"
  584. _Options = "NO-LOCK INDEXED-REPOSITION"
  585. _FldNameList[1] = Temp-Tables.ADebop.Knr
  586. _FldNameList[2] = Temp-Tables.ADebop.Faknr
  587. _FldNameList[3] = Temp-Tables.ADebop.Faellig
  588. _FldNameList[4] > Temp-Tables.ADebop.Fakbetr
  589. "ADebop.Fakbetr" ? "z,zzz,zz9.99-" "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  590. _FldNameList[5] > Temp-Tables.ADebop.Fakbetr_FRW
  591. "ADebop.Fakbetr_FRW" "Fakbetr Frw" "z,zzz,zz9.99-" "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  592. _FldNameList[6] > Temp-Tables.ADebop.Zahdat
  593. "ADebop.Zahdat" "Zahldatum" ? "date" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  594. _FldNameList[7] > Temp-Tables.ADebop.Zahbetr
  595. "ADebop.Zahbetr" "bezahlt" "z,zzz,zz9.99-" "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  596. _FldNameList[8] > Temp-Tables.ADebop.Zahbetr_FRW
  597. "ADebop.Zahbetr_FRW" "bezahlt Frw" "z,zzz,zz9.99-" "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  598. _FldNameList[9] > Temp-Tables.ADebop.Saldo
  599. "ADebop.Saldo" ? "z,zzz,zz9.99-" "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  600. _FldNameList[10] > Temp-Tables.ADebop.Saldo_FRW
  601. "ADebop.Saldo_FRW" "Saldo Frw" "z,zzz,zz9.99-" "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
  602. _Query is OPENED
  603. */ /* BROWSE Br_Bezahlt */
  604. &ANALYZE-RESUME
  605. &ANALYZE-SUSPEND _QUERY-BLOCK FRAME fMain
  606. /* Query rebuild information for FRAME fMain
  607. _Options = "NO-LOCK INDEXED-REPOSITION KEEP-EMPTY"
  608. _Query is NOT OPENED
  609. */ /* FRAME fMain */
  610. &ANALYZE-RESUME
  611. /* ************************ Control Triggers ************************ */
  612. &Scoped-define SELF-NAME fMain
  613. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL fMain fFrameWin
  614. ON END-ERROR OF FRAME fMain
  615. DO:
  616. APPLY 'END-ERROR' TO {&WINDOW-NAME}.
  617. RETURN NO-APPLY.
  618. END.
  619. /* _UIB-CODE-BLOCK-END */
  620. &ANALYZE-RESUME
  621. &Scoped-define SELF-NAME Btn_Kon
  622. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Kon fFrameWin
  623. ON CHOOSE OF Btn_Kon IN FRAME fMain /* O */
  624. DO:
  625. DEF VAR Konto AS CHAR NO-UNDO.
  626. Konto = CB_ZAHKONTO:SCREEN-VALUE IN FRAME {&FRAME-NAME}.
  627. FIND FIRST tTotale WHERE tTotale.Konto = Konto NO-ERROR.
  628. IF AVAILABLE tTotale THEN
  629. DO:
  630. tTotale.Betr = 0.
  631. tTotale.BetrFrw = 0.
  632. END.
  633. RUN DISPLAY_TOTALE.
  634. APPLY 'ENTRY' TO F_Datum IN FRAME {&FRAME-NAME}.
  635. RETURN NO-APPLY.
  636. END.
  637. /* _UIB-CODE-BLOCK-END */
  638. &ANALYZE-RESUME
  639. &Scoped-define SELF-NAME Btn_Kum
  640. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Kum fFrameWin
  641. ON CHOOSE OF Btn_Kum IN FRAME fMain /* K */
  642. DO:
  643. F_KumBetr = 0.
  644. F_KumFrw = 0.
  645. RUN DISPLAY_TOTALE.
  646. APPLY 'ENTRY' TO F_Datum IN FRAME {&FRAME-NAME}.
  647. RETURN NO-APPLY.
  648. END.
  649. /* _UIB-CODE-BLOCK-END */
  650. &ANALYZE-RESUME
  651. &Scoped-define SELF-NAME Btn_Tot
  652. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Tot fFrameWin
  653. ON CHOOSE OF Btn_Tot IN FRAME fMain /* T */
  654. DO:
  655. F_TotBetr = 0.
  656. F_TotFrw = 0.
  657. RUN DISPLAY_TOTALE.
  658. APPLY 'ENTRY' TO F_Datum IN FRAME {&FRAME-NAME}.
  659. RETURN NO-APPLY.
  660. END.
  661. /* _UIB-CODE-BLOCK-END */
  662. &ANALYZE-RESUME
  663. &Scoped-define SELF-NAME CB_Eingabe
  664. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Eingabe fFrameWin
  665. ON END-ERROR OF CB_Eingabe IN FRAME fMain /* Eingabe */
  666. DO:
  667. APPLY 'ENTRY' TO F_Datum IN FRAME {&FRAME-NAME}.
  668. RETURN NO-APPLY.
  669. END.
  670. /* _UIB-CODE-BLOCK-END */
  671. &ANALYZE-RESUME
  672. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Eingabe fFrameWin
  673. ON ENTRY OF CB_Eingabe IN FRAME fMain /* Eingabe */
  674. DO:
  675. IF FMut THEN
  676. DO:
  677. APPLY 'END-ERROR'.
  678. RETURN NO-APPLY.
  679. END.
  680. END.
  681. /* _UIB-CODE-BLOCK-END */
  682. &ANALYZE-RESUME
  683. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Eingabe fFrameWin
  684. ON RETURN OF CB_Eingabe IN FRAME fMain /* Eingabe */
  685. DO:
  686. APPLY 'TAB' TO SELF.
  687. RETURN NO-APPLY.
  688. END.
  689. /* _UIB-CODE-BLOCK-END */
  690. &ANALYZE-RESUME
  691. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Eingabe fFrameWin
  692. ON VALUE-CHANGED OF CB_Eingabe IN FRAME fMain /* Eingabe */
  693. DO:
  694. RUN ENABLE_DISABLE ( INPUT SELF:SCREEN-VALUE ).
  695. PUT-KEY-VALUE SECTION 'Zahlen' KEY 'Eingabe' VALUE SELF:SCREEN-VALUE.
  696. END.
  697. /* _UIB-CODE-BLOCK-END */
  698. &ANALYZE-RESUME
  699. &Scoped-define SELF-NAME CB_ZAHKONTO
  700. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_ZAHKONTO fFrameWin
  701. ON END-ERROR OF CB_ZAHKONTO IN FRAME fMain /* Konto */
  702. DO:
  703. RETURN.
  704. END.
  705. /* _UIB-CODE-BLOCK-END */
  706. &ANALYZE-RESUME
  707. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_ZAHKONTO fFrameWin
  708. ON ENTRY OF CB_ZAHKONTO IN FRAME fMain /* Konto */
  709. DO:
  710. IF FMut THEN
  711. DO:
  712. APPLY 'END-ERROR'.
  713. RETURN NO-APPLY.
  714. END.
  715. END.
  716. /* _UIB-CODE-BLOCK-END */
  717. &ANALYZE-RESUME
  718. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_ZAHKONTO fFrameWin
  719. ON RETURN OF CB_ZAHKONTO IN FRAME fMain /* Konto */
  720. DO:
  721. APPLY 'ENTRY' TO F_Datum IN FRAME {&FRAME-NAME}.
  722. RETURN NO-APPLY.
  723. END.
  724. /* _UIB-CODE-BLOCK-END */
  725. &ANALYZE-RESUME
  726. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_ZAHKONTO fFrameWin
  727. ON TAB OF CB_ZAHKONTO IN FRAME fMain /* Konto */
  728. DO:
  729. APPLY 'ENTRY' TO F_Datum IN FRAME {&FRAME-NAME}.
  730. RETURN NO-APPLY.
  731. END.
  732. /* _UIB-CODE-BLOCK-END */
  733. &ANALYZE-RESUME
  734. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_ZAHKONTO fFrameWin
  735. ON VALUE-CHANGED OF CB_ZAHKONTO IN FRAME fMain /* Konto */
  736. DO:
  737. RUN DISPLAY_TOTALE.
  738. PUT-KEY-VALUE SECTION 'Zahlen' KEY 'Konto' VALUE SELF:SCREEN-VALUE.
  739. END.
  740. /* _UIB-CODE-BLOCK-END */
  741. &ANALYZE-RESUME
  742. &Scoped-define SELF-NAME zDebop.FRW
  743. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL zDebop.FRW fFrameWin
  744. ON ENTRY OF zDebop.FRW IN FRAME fMain /* FRW */
  745. DO:
  746. IF SELF:SCREEN-VALUE = BasFrw THEN
  747. DO:
  748. APPLY 'TAB' TO SELF.
  749. RETURN NO-APPLY.
  750. END.
  751. END.
  752. /* _UIB-CODE-BLOCK-END */
  753. &ANALYZE-RESUME
  754. &Scoped-define SELF-NAME F_Betr
  755. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Betr fFrameWin
  756. ON END-ERROR OF F_Betr IN FRAME fMain /* Rechnungsbetrag */
  757. DO:
  758. APPLY 'ENTRY' TO F_Datum IN FRAME {&FRAME-NAME}.
  759. RETURN NO-APPLY.
  760. END.
  761. /* _UIB-CODE-BLOCK-END */
  762. &ANALYZE-RESUME
  763. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Betr fFrameWin
  764. ON ENTRY OF F_Betr IN FRAME fMain /* Rechnungsbetrag */
  765. DO:
  766. IF FMut THEN
  767. DO:
  768. APPLY 'END-ERROR'.
  769. RETURN NO-APPLY.
  770. END.
  771. END.
  772. /* _UIB-CODE-BLOCK-END */
  773. &ANALYZE-RESUME
  774. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Betr fFrameWin
  775. ON LEAVE OF F_Betr IN FRAME fMain /* Rechnungsbetrag */
  776. DO:
  777. IF NOT FAkt THEN RETURN.
  778. IF KEYFUNCTION(LASTKEY) = 'END-ERROR' THEN RETURN.
  779. IF KEYFUNCTION(LASTKEY) = 'BACK-TAB' THEN RETURN.
  780. DEF VAR LastEnter AS HANDLE NO-UNDO.
  781. DEF VAR LastLeave AS HANDLE NO-UNDO.
  782. LastEnter = LAST-EVENT:WIDGET-ENTER.
  783. LastLeave = LAST-EVENT:WIDGET-LEAVE.
  784. IF VALID-HANDLE(LastEnter) THEN
  785. DO:
  786. IF LastEnter:NAME = 'CB_Eingabe' THEN RETURN.
  787. IF LastEnter:NAME = 'CB_ZAHKONTO' THEN RETURN.
  788. IF LastEnter:NAME = 'F_Datum' THEN RETURN.
  789. END.
  790. RUN BETRAG.
  791. IF RETURN-VALUE = 'ERROR' THEN
  792. DO:
  793. APPLY 'ENTRY' TO SELF.
  794. RETURN NO-APPLY.
  795. END.
  796. RUN VORBEREITEN.
  797. END.
  798. /* _UIB-CODE-BLOCK-END */
  799. &ANALYZE-RESUME
  800. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Betr fFrameWin
  801. ON RETURN OF F_Betr IN FRAME fMain /* Rechnungsbetrag */
  802. DO:
  803. APPLY 'TAB' TO SELF.
  804. RETURN NO-APPLY.
  805. END.
  806. /* _UIB-CODE-BLOCK-END */
  807. &ANALYZE-RESUME
  808. &Scoped-define SELF-NAME F_Datum
  809. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Datum fFrameWin
  810. ON END-ERROR OF F_Datum IN FRAME fMain /* Datum */
  811. DO:
  812. APPLY 'ENTRY' TO CB_ZAHKONTO IN FRAME {&FRAME-NAME}.
  813. RETURN NO-APPLY.
  814. END.
  815. /* _UIB-CODE-BLOCK-END */
  816. &ANALYZE-RESUME
  817. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Datum fFrameWin
  818. ON ENTRY OF F_Datum IN FRAME fMain /* Datum */
  819. DO:
  820. IF FMut THEN
  821. DO:
  822. APPLY 'END-ERROR'.
  823. RETURN NO-APPLY.
  824. END.
  825. END.
  826. /* _UIB-CODE-BLOCK-END */
  827. &ANALYZE-RESUME
  828. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Datum fFrameWin
  829. ON F11 OF F_Datum IN FRAME fMain /* Datum */
  830. DO:
  831. APPLY 'TAB' TO SELF.
  832. END.
  833. /* _UIB-CODE-BLOCK-END */
  834. &ANALYZE-RESUME
  835. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Datum fFrameWin
  836. ON LEAVE OF F_Datum IN FRAME fMain /* Datum */
  837. DO:
  838. IF KEYFUNCTION(LASTKEY) = 'END-ERROR' THEN RETURN.
  839. IF KEYFUNCTION(LASTKEY) = 'BACK-TAB' THEN RETURN.
  840. DEF VAR LastEnter AS HANDLE NO-UNDO.
  841. DEF VAR LastLeave AS HANDLE NO-UNDO.
  842. LastEnter = LAST-EVENT:WIDGET-ENTER.
  843. LastLeave = LAST-EVENT:WIDGET-LEAVE.
  844. IF VALID-HANDLE(LastEnter) THEN
  845. DO:
  846. IF LastEnter:NAME = 'CB_ZAHKONTO' THEN RETURN.
  847. END.
  848. DO WITH FRAME {&FRAME-NAME}:
  849. ERROR-STATUS:ERROR = FALSE.
  850. F_Datum = DATE(SELF:SCREEN-VALUE) NO-ERROR.
  851. IF ERROR-STATUS:ERROR THEN
  852. DO:
  853. APPLY 'ENTRY' TO SELF.
  854. RETURN NO-APPLY.
  855. END.
  856. IF F_Datum = ? THEN
  857. DO:
  858. F_Datum = TODAY.
  859. DISPLAY F_Datum.
  860. END.
  861. IF F_Datum < sDatum AND
  862. KEYLABEL(LASTKEY) <> 'F11' THEN
  863. DO:
  864. MESSAGE 'Datum nicht erlaubt' VIEW-AS ALERT-BOX.
  865. APPLY 'ENTRY' TO SELF.
  866. RETURN NO-APPLY.
  867. END.
  868. END.
  869. END.
  870. /* _UIB-CODE-BLOCK-END */
  871. &ANALYZE-RESUME
  872. &Scoped-define SELF-NAME F_Faknr
  873. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Faknr fFrameWin
  874. ON END-ERROR OF F_Faknr IN FRAME fMain /* Rechnungsnummer */
  875. DO:
  876. APPLY 'ENTRY' TO F_Datum IN FRAME {&FRAME-NAME}.
  877. RETURN NO-APPLY.
  878. END.
  879. /* _UIB-CODE-BLOCK-END */
  880. &ANALYZE-RESUME
  881. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Faknr fFrameWin
  882. ON ENTRY OF F_Faknr IN FRAME fMain /* Rechnungsnummer */
  883. DO:
  884. IF FMut THEN
  885. DO:
  886. APPLY 'END-ERROR'.
  887. RETURN NO-APPLY.
  888. END.
  889. END.
  890. /* _UIB-CODE-BLOCK-END */
  891. &ANALYZE-RESUME
  892. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Faknr fFrameWin
  893. ON LEAVE OF F_Faknr IN FRAME fMain /* Rechnungsnummer */
  894. DO:
  895. IF NOT FAkt THEN RETURN.
  896. IF KEYFUNCTION(LASTKEY) = 'END-ERROR' THEN RETURN.
  897. IF KEYFUNCTION(LASTKEY) = 'BACK-TAB' THEN RETURN.
  898. DEF VAR LastEnter AS HANDLE NO-UNDO.
  899. DEF VAR LastLeave AS HANDLE NO-UNDO.
  900. LastEnter = LAST-EVENT:WIDGET-ENTER.
  901. LastLeave = LAST-EVENT:WIDGET-LEAVE.
  902. IF VALID-HANDLE(LastEnter) THEN
  903. DO:
  904. IF LastEnter:NAME = 'CB_Eingabe' THEN RETURN.
  905. IF LastEnter:NAME = 'CB_ZAHKONTO' THEN RETURN.
  906. IF LastEnter:NAME = 'F_Datum' THEN RETURN.
  907. END.
  908. RUN FAKTURANUMMER.
  909. IF RETURN-VALUE = 'ERROR' THEN
  910. DO:
  911. APPLY 'ENTRY' TO SELF.
  912. RETURN NO-APPLY.
  913. END.
  914. RUN VORBEREITEN.
  915. END.
  916. /* _UIB-CODE-BLOCK-END */
  917. &ANALYZE-RESUME
  918. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Faknr fFrameWin
  919. ON RETURN OF F_Faknr IN FRAME fMain /* Rechnungsnummer */
  920. DO:
  921. APPLY 'TAB' TO SELF.
  922. RETURN NO-APPLY.
  923. END.
  924. /* _UIB-CODE-BLOCK-END */
  925. &ANALYZE-RESUME
  926. &Scoped-define SELF-NAME F_Knr
  927. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Knr fFrameWin
  928. ON ALT-F OF F_Knr IN FRAME fMain /* Kundennummer */
  929. DO:
  930. DEF VAR cAdresse AS CHAR NO-UNDO.
  931. DEF VAR aRecid AS RECID NO-UNDO.
  932. KUNDENSUCHE:
  933. DO WHILE TRUE:
  934. RUN g-suchen-adresse.w (INPUT '',
  935. INPUT 'Adresse',
  936. OUTPUT aRecid ) NO-ERROR.
  937. IF aRecid = ? THEN RETURN NO-APPLY.
  938. FIND Adresse NO-LOCK WHERE RECID(Adresse) = aRecid NO-ERROR.
  939. LEAVE.
  940. END.
  941. SELF:SCREEN-VALUE = STRING(Adresse.Knr).
  942. APPLY 'ENTRY' TO SELF.
  943. RETURN NO-APPLY.
  944. END.
  945. /* _UIB-CODE-BLOCK-END */
  946. &ANALYZE-RESUME
  947. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Knr fFrameWin
  948. ON END-ERROR OF F_Knr IN FRAME fMain /* Kundennummer */
  949. DO:
  950. APPLY 'ENTRY' TO F_Datum IN FRAME {&FRAME-NAME}.
  951. RETURN NO-APPLY.
  952. END.
  953. /* _UIB-CODE-BLOCK-END */
  954. &ANALYZE-RESUME
  955. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Knr fFrameWin
  956. ON ENTRY OF F_Knr IN FRAME fMain /* Kundennummer */
  957. DO:
  958. IF FMut THEN
  959. DO:
  960. APPLY 'END-ERROR'.
  961. RETURN NO-APPLY.
  962. END.
  963. END.
  964. /* _UIB-CODE-BLOCK-END */
  965. &ANALYZE-RESUME
  966. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Knr fFrameWin
  967. ON LEAVE OF F_Knr IN FRAME fMain /* Kundennummer */
  968. DO:
  969. IF NOT FAkt THEN RETURN.
  970. IF KEYFUNCTION(LASTKEY) = 'END-ERROR' THEN RETURN.
  971. IF KEYFUNCTION(LASTKEY) = 'BACK-TAB' THEN RETURN.
  972. DEF VAR LastEnter AS HANDLE NO-UNDO.
  973. DEF VAR LastLeave AS HANDLE NO-UNDO.
  974. LastEnter = LAST-EVENT:WIDGET-ENTER.
  975. LastLeave = LAST-EVENT:WIDGET-LEAVE.
  976. IF VALID-HANDLE(LastEnter) THEN
  977. DO:
  978. IF LastEnter:NAME = 'CB_Eingabe' THEN RETURN.
  979. IF LastEnter:NAME = 'CB_ZAHKONTO' THEN RETURN.
  980. IF LastEnter:NAME = 'F_Datum' THEN RETURN.
  981. IF LastEnter:NAME = 'F_Knr' THEN RETURN.
  982. END.
  983. RUN KUNDENNUMMER.
  984. IF RETURN-VALUE = 'ERROR' THEN
  985. DO:
  986. APPLY 'ENTRY' TO SELF.
  987. RETURN NO-APPLY.
  988. END.
  989. RUN VORBEREITEN.
  990. END.
  991. /* _UIB-CODE-BLOCK-END */
  992. &ANALYZE-RESUME
  993. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Knr fFrameWin
  994. ON RETURN OF F_Knr IN FRAME fMain /* Kundennummer */
  995. DO:
  996. APPLY 'TAB' TO SELF.
  997. RETURN NO-APPLY.
  998. END.
  999. /* _UIB-CODE-BLOCK-END */
  1000. &ANALYZE-RESUME
  1001. &Scoped-define SELF-NAME zDebop.Kurs
  1002. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL zDebop.Kurs fFrameWin
  1003. ON ENTRY OF zDebop.Kurs IN FRAME fMain /* Kurs */
  1004. DO:
  1005. IF zDebop.FRW:SCREEN-VALUE IN FRAME {&FRAME-NAME} = BasFrw THEN
  1006. DO:
  1007. IF KEYFUNCTION(LASTKEY) = 'BACK-TAB' THEN APPLY 'BACK-TAB' TO SELF.
  1008. ELSE APPLY 'TAB' TO SELF.
  1009. RETURN NO-APPLY.
  1010. END.
  1011. END.
  1012. /* _UIB-CODE-BLOCK-END */
  1013. &ANALYZE-RESUME
  1014. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL zDebop.Kurs fFrameWin
  1015. ON LEAVE OF zDebop.Kurs IN FRAME fMain /* Kurs */
  1016. DO:
  1017. IF NOT FAkt THEN RETURN.
  1018. IF NOT SELF:MODIFIED THEN RETURN.
  1019. IF KEYFUNCTION(LASTKEY) = 'END-ERROR' THEN RETURN.
  1020. RUN RECHNEN ( INPUT 2 ).
  1021. END.
  1022. /* _UIB-CODE-BLOCK-END */
  1023. &ANALYZE-RESUME
  1024. &Scoped-define SELF-NAME zDebop.Skonto
  1025. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL zDebop.Skonto fFrameWin
  1026. ON END-ERROR OF zDebop.Skonto IN FRAME fMain /* Skonto CHF */
  1027. DO:
  1028. APPLY 'ENTRY' TO zDebop.Zahbetr_FRW.
  1029. RETURN NO-APPLY.
  1030. END.
  1031. /* _UIB-CODE-BLOCK-END */
  1032. &ANALYZE-RESUME
  1033. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL zDebop.Skonto fFrameWin
  1034. ON RETURN OF zDebop.Skonto IN FRAME fMain /* Skonto CHF */
  1035. DO:
  1036. APPLY 'TAB' TO SELF.
  1037. RETURN NO-APPLY.
  1038. END.
  1039. /* _UIB-CODE-BLOCK-END */
  1040. &ANALYZE-RESUME
  1041. &Scoped-define SELF-NAME zDebop.Skonto_FRW
  1042. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL zDebop.Skonto_FRW fFrameWin
  1043. ON LEAVE OF zDebop.Skonto_FRW IN FRAME fMain /* Skonto/Frw */
  1044. DO:
  1045. IF NOT FAkt THEN RETURN.
  1046. IF NOT SELF:MODIFIED THEN RETURN.
  1047. IF KEYFUNCTION(LASTKEY) = 'END-ERROR' THEN RETURN.
  1048. RUN RECHNEN ( INPUT 4 ).
  1049. END.
  1050. /* _UIB-CODE-BLOCK-END */
  1051. &ANALYZE-RESUME
  1052. &Scoped-define SELF-NAME zDebop.Zahbetr
  1053. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL zDebop.Zahbetr fFrameWin
  1054. ON ENTRY OF zDebop.Zahbetr IN FRAME fMain /* Betrag CHF */
  1055. DO:
  1056. IF zDebop.FRW:SCREEN-VALUE IN FRAME {&FRAME-NAME} = BasFrw THEN
  1057. DO:
  1058. IF KEYFUNCTION(LASTKEY) = 'BACK-TAB' THEN APPLY 'BACK-TAB' TO SELF.
  1059. ELSE APPLY 'TAB' TO SELF.
  1060. RETURN NO-APPLY.
  1061. END.
  1062. END.
  1063. /* _UIB-CODE-BLOCK-END */
  1064. &ANALYZE-RESUME
  1065. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL zDebop.Zahbetr fFrameWin
  1066. ON LEAVE OF zDebop.Zahbetr IN FRAME fMain /* Betrag CHF */
  1067. DO:
  1068. IF NOT FAkt THEN RETURN.
  1069. IF NOT SELF:MODIFIED THEN RETURN.
  1070. IF KEYFUNCTION(LASTKEY) = 'END-ERROR' THEN RETURN.
  1071. RUN RECHNEN ( INPUT 3 ).
  1072. END.
  1073. /* _UIB-CODE-BLOCK-END */
  1074. &ANALYZE-RESUME
  1075. &Scoped-define SELF-NAME zDebop.Zahbetr_FRW
  1076. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL zDebop.Zahbetr_FRW fFrameWin
  1077. ON ENTRY OF zDebop.Zahbetr_FRW IN FRAME fMain /* Betrag/Frw */
  1078. DO:
  1079. /*
  1080. IF zDebop.FRW = BasFrw THEN DO:
  1081. APPLY 'TAB' TO SELF.
  1082. RETURN NO-APPLY.
  1083. END.
  1084. */
  1085. END.
  1086. /* _UIB-CODE-BLOCK-END */
  1087. &ANALYZE-RESUME
  1088. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL zDebop.Zahbetr_FRW fFrameWin
  1089. ON LEAVE OF zDebop.Zahbetr_FRW IN FRAME fMain /* Betrag/Frw */
  1090. DO:
  1091. IF NOT FAkt THEN RETURN.
  1092. IF NOT SELF:MODIFIED THEN RETURN.
  1093. IF KEYFUNCTION(LASTKEY) = 'END-ERROR' THEN RETURN.
  1094. RUN RECHNEN ( INPUT 1 ).
  1095. END.
  1096. /* _UIB-CODE-BLOCK-END */
  1097. &ANALYZE-RESUME
  1098. &Scoped-define BROWSE-NAME Br_Bezahlt
  1099. &UNDEFINE SELF-NAME
  1100. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK fFrameWin
  1101. /* *************************** Main Block *************************** */
  1102. ProgName = ''.
  1103. sAktiv = DYNAMIC-FUNCTION('getSuperaktiv':U) NO-ERROR.
  1104. IF sAktiv THEN
  1105. DO:
  1106. Firma = DYNAMIC-FUNCTION('getMandant':U ) NO-ERROR.
  1107. D1Firma = DYNAMIC-FUNCTION('getMandant':U ) NO-ERROR.
  1108. AdFirma = DYNAMIC-FUNCTION('getADMandant':U ) NO-ERROR.
  1109. FBFirma = DYNAMIC-FUNCTION('getFBMandant':U ) NO-ERROR.
  1110. GlobFir = D1Firma.
  1111. END.
  1112. IF FBFirma = '' THEN FBFirma = '9999'.
  1113. F_KumBetr = 0.
  1114. F_KumFrw = 0.
  1115. F_TotBetr = 0.
  1116. F_TotFrw = 0.
  1117. EMPTY TEMP-TABLE tTotale.
  1118. IF sAktiv THEN
  1119. DO:
  1120. FIND Steuer USE-INDEX Steuer-k1
  1121. WHERE Steuer.Firma = Firma NO-LOCK NO-ERROR.
  1122. FIND SteuNr USE-INDEX SteuNr-k1
  1123. WHERE SteuNr.Firma = Firma NO-LOCK NO-ERROR.
  1124. ASSIGN
  1125. SkTolPr = SteuNr.Sk_Tol_%
  1126. SkTolBe = SteuNr.Sk_Tol_Max
  1127. BasFrw = DYNAMIC-FUNCTION('getFwFRW':U).
  1128. END.
  1129. SUBSCRIBE TO 'REPOSADRESSE' ANYWHERE.
  1130. SESSION:DATA-ENTRY-RETURN = TRUE.
  1131. /* TRIGGERS */
  1132. ON 'END-ERROR':U OF FRAME {&FRAME-NAME} ANYWHERE
  1133. DO:
  1134. IF FMut THEN
  1135. DO WITH FRAME {&FRAME-NAME}:
  1136. EMPTY TEMP-TABLE zDebop.
  1137. CREATE zDebop.
  1138. DISPLAY {&List-5}.
  1139. zDebop.Zahbetr_Frw:READ-ONLY = TRUE.
  1140. zDebop.Skonto_Frw :READ-ONLY = TRUE.
  1141. zDebop.Zahbetr :READ-ONLY = TRUE.
  1142. zDebop.Skonto :READ-ONLY = TRUE.
  1143. zDebop.Kurs :READ-ONLY = TRUE.
  1144. zDebop.Skonto_Frw :BGCOLOR = 15.
  1145. FMut = FALSE.
  1146. APPLY 'ENTRY' TO F_Datum.
  1147. RETURN NO-APPLY.
  1148. END.
  1149. APPLY 'ENTRY' TO CB_ZAHKONTO.
  1150. RETURN NO-APPLY.
  1151. END.
  1152. ON 'F9':U OF zDebop.Zahbetr_Frw, zDebop.Kurs, zDebop.Zahbetr,
  1153. zDebop.Skonto_Frw , zDebop.Skonto IN FRAME {&FRAME-NAME}
  1154. DO:
  1155. IF NOT FMut THEN RETURN NO-APPLY.
  1156. RUN TEST_EINGABEN.
  1157. IF RETURN-VALUE = '' THEN RETURN.
  1158. ELSE RETURN NO-APPLY.
  1159. END.
  1160. ON 'ALT-S':U OF zDebop.Zahbetr_Frw, zDebop.Kurs, zDebop.Zahbetr,
  1161. zDebop.Skonto_Frw , zDebop.Skonto IN FRAME {&FRAME-NAME}
  1162. DO:
  1163. IF NOT FMut THEN RETURN NO-APPLY.
  1164. RUN TEST_EINGABEN.
  1165. IF RETURN-VALUE = '' THEN RETURN.
  1166. ELSE RETURN NO-APPLY.
  1167. END.
  1168. ON 'LEAVE':U OF zDebop.Skonto IN FRAME {&FRAME-NAME}
  1169. DO:
  1170. IF NOT FAkt THEN RETURN.
  1171. IF NOT FMut THEN RETURN NO-APPLY.
  1172. IF KEYFUNCTION(LASTKEY) = 'BACK-TAB' THEN RETURN.
  1173. DEF VAR LastEnter AS HANDLE NO-UNDO.
  1174. LastEnter = LAST-EVENT:WIDGET-ENTER.
  1175. IF VALID-HANDLE(LastEnter) THEN
  1176. DO:
  1177. IF LastEnter:NAME = 'Zahbetr_Frw' THEN RETURN.
  1178. IF LastEnter:NAME = 'Kurs' THEN RETURN.
  1179. IF LastEnter:NAME = 'Zahbetr' THEN RETURN.
  1180. IF LastEnter:NAME = 'Skonto_Frw' THEN RETURN.
  1181. END.
  1182. RUN TEST_EINGABEN.
  1183. IF RETURN-VALUE = '' THEN RETURN.
  1184. ELSE RETURN NO-APPLY.
  1185. END.
  1186. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN
  1187. /* Now enable the interface if in test mode - otherwise this happens when
  1188. the object is explicitly initialized from its container. */
  1189. RUN initializeObject.
  1190. &ENDIF
  1191. /* _UIB-CODE-BLOCK-END */
  1192. &ANALYZE-RESUME
  1193. /* ********************** Internal Procedures *********************** */
  1194. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ABBRUCH fFrameWin
  1195. PROCEDURE ABBRUCH :
  1196. /*------------------------------------------------------------------------------
  1197. Purpose:
  1198. Parameters: <none>
  1199. Notes:
  1200. ------------------------------------------------------------------------------*/
  1201. DO WITH FRAME {&FRAME-NAME}:
  1202. FAkt = FALSE.
  1203. EMPTY TEMP-TABLE zDebop.
  1204. CREATE zDebop.
  1205. DISPLAY {&List-5}.
  1206. zDebop.Zahbetr_Frw:READ-ONLY = TRUE.
  1207. zDebop.Skonto_Frw :READ-ONLY = TRUE.
  1208. zDebop.Zahbetr :READ-ONLY = TRUE.
  1209. zDebop.Skonto :READ-ONLY = TRUE.
  1210. zDebop.Kurs :READ-ONLY = TRUE.
  1211. zDebop.Skonto_Frw :BGCOLOR = 15.
  1212. FMut = FALSE.
  1213. APPLY 'ENTRY' TO F_Datum.
  1214. RETURN NO-APPLY.
  1215. END.
  1216. END PROCEDURE.
  1217. /* _UIB-CODE-BLOCK-END */
  1218. &ANALYZE-RESUME
  1219. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects fFrameWin _ADM-CREATE-OBJECTS
  1220. PROCEDURE adm-create-objects :
  1221. /*------------------------------------------------------------------------------
  1222. Purpose: Create handles for all SmartObjects used in this procedure.
  1223. After SmartObjects are initialized, then SmartLinks are added.
  1224. Parameters: <none>
  1225. ------------------------------------------------------------------------------*/
  1226. END PROCEDURE.
  1227. /* _UIB-CODE-BLOCK-END */
  1228. &ANALYZE-RESUME
  1229. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE BETRAG fFrameWin
  1230. PROCEDURE BETRAG :
  1231. /*------------------------------------------------------------------------------
  1232. Purpose:
  1233. Parameters: <none>
  1234. Notes:
  1235. ------------------------------------------------------------------------------*/
  1236. DEF VAR opRecid AS RECID NO-UNDO.
  1237. DEF VAR Betrag AS DEC NO-UNDO.
  1238. DEF VAR ii AS INT NO-UNDO.
  1239. DO WITH FRAME {&FRAME-NAME}:
  1240. ASSIGN F_Betr.
  1241. Betrag = F_Betr .
  1242. ii = 0.
  1243. FOR EACH Debop USE-INDEX Debop-k3
  1244. WHERE Debop.Firma = Firma
  1245. AND Debop.Fakbetr_Frw = Betrag
  1246. AND Debop.Saldo_Frw <> 0 NO-LOCK:
  1247. ii = ii + 1.
  1248. opRecid = RECID(Debop).
  1249. IF ii > 1 THEN LEAVE.
  1250. END.
  1251. RELEASE Debop.
  1252. IF ii = 1 THEN
  1253. DO:
  1254. FIND Debop WHERE RECID(Debop) = opRecid NO-LOCK NO-ERROR.
  1255. END.
  1256. DO WHILE TRUE:
  1257. IF AVAILABLE Debop THEN LEAVE.
  1258. RUN g-anzeig-debop.w ( INPUT 3, INPUT F_Betr, OUTPUT opRecid ).
  1259. IF opRecid = ? THEN RETURN 'ERROR'.
  1260. FIND Debop WHERE RECID(Debop) = opRecid NO-LOCK NO-ERROR.
  1261. LEAVE.
  1262. END.
  1263. FIND Adresse USE-INDEX Adresse-k1
  1264. WHERE Adresse.Firma = AdFirma
  1265. AND Adresse.Knr = Debop.Knr NO-LOCK NO-ERROR.
  1266. F_ZKnr = Adresse.Knr.
  1267. F_Adresse = Adresse.Anzeig_Br.
  1268. FIND Debst USE-INDEX Debst-k1
  1269. WHERE Debst.Firma = Firma
  1270. AND Debst.Knr = Debop.Knr NO-LOCK NO-ERROR.
  1271. F_Saldo = Debst.Saldo.
  1272. F_SaldoFrw = Debst.Saldo_Frw.
  1273. FIND FIRST TDebop NO-ERROR.
  1274. IF NOT AVAILABLE TDebop THEN CREATE TDebop.
  1275. BUFFER-COPY Debop TO TDebop.
  1276. DISPLAY {&List-6}.
  1277. F_Betr = Debop.Fakbetr_Frw.
  1278. DISPLAY F_Betr.
  1279. END.
  1280. RETURN ''.
  1281. END PROCEDURE.
  1282. /* _UIB-CODE-BLOCK-END */
  1283. &ANALYZE-RESUME
  1284. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE CREATE_ZAHLUNG fFrameWin
  1285. PROCEDURE CREATE_ZAHLUNG :
  1286. /*------------------------------------------------------------------------------*/
  1287. /* Purpose: Super Override */
  1288. /* Parameters: */
  1289. /* Notes: */
  1290. /*------------------------------------------------------------------------------*/
  1291. DEFINE INPUT PARAMETER iprRecid AS RECID NO-UNDO.
  1292. DEFINE BUFFER bzDebop FOR zDebop.
  1293. DEFINE VARIABLE iTrans AS INTEGER NO-UNDO.
  1294. FIND bzDebop WHERE RECID (bzDebop) = iprRecid.
  1295. FIND LAST Zahlung NO-LOCK
  1296. WHERE Zahlung.Firma = bzDebop.Firma NO-ERROR.
  1297. IF AVAILABLE Zahlung THEN iTrans = Zahlung.Trnr + 1.
  1298. ELSE iTrans = 1.
  1299. CREATE Zahlung.
  1300. ASSIGN
  1301. Zahlung.Trnr = iTrans
  1302. Zahlung.Firma = bzDebop.Firma
  1303. Zahlung.Knr = bzDebop.Knr
  1304. Zahlung.Faknr = TRIM(STRING(bzDebop.Faknr,'>>>>>>9'))
  1305. Zahlung.Datum_1 = bzDebop.Zahdat
  1306. Zahlung.Datum_2 = bzDebop.Zahdat
  1307. Zahlung.Datum_3 = bzDebop.Zahdat
  1308. Zahlung.Frw = bzDebop.FRW
  1309. Zahlung.Kurs = bzDebop.Kurs
  1310. Zahlung.Faktor = bzDebop.Faktor
  1311. Zahlung.Zahl_Art = 09
  1312. Zahlung.Herk = 61
  1313. Zahlung.Konto_S = bzDebop.ZaKonto
  1314. Zahlung.Konto_H = bzDebop.Konto
  1315. Zahlung.Betrag = bzDebop.Zahbetr_FRW
  1316. Zahlung.Skonto = bzDebop.Skonto_FRW
  1317. .
  1318. RUN ZAHLUNGEN_BUCHEN ( bzDebop.Firma, 09).
  1319. .
  1320. END PROCEDURE.
  1321. /* _UIB-CODE-BLOCK-END */
  1322. &ANALYZE-RESUME
  1323. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI fFrameWin _DEFAULT-DISABLE
  1324. PROCEDURE disable_UI :
  1325. /*------------------------------------------------------------------------------
  1326. Purpose: DISABLE the User Interface
  1327. Parameters: <none>
  1328. Notes: Here we clean-up the user-interface by deleting
  1329. dynamic widgets we have created and/or hide
  1330. frames. This procedure is usually called when
  1331. we are ready to "clean-up" after running.
  1332. ------------------------------------------------------------------------------*/
  1333. /* Hide all frames. */
  1334. HIDE FRAME fMain.
  1335. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
  1336. END PROCEDURE.
  1337. /* _UIB-CODE-BLOCK-END */
  1338. &ANALYZE-RESUME
  1339. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DISPLAY_TOTALE fFrameWin
  1340. PROCEDURE DISPLAY_TOTALE :
  1341. /*------------------------------------------------------------------------------
  1342. Purpose:
  1343. Parameters: <none>
  1344. Notes:
  1345. ------------------------------------------------------------------------------*/
  1346. DEF VAR Konto AS CHAR NO-UNDO.
  1347. DO WITH FRAME {&FRAME-NAME}:
  1348. Konto = CB_ZAHKONTO:SCREEN-VALUE.
  1349. FIND FIRST tTotale WHERE tTotale.Konto = Konto NO-ERROR.
  1350. IF NOT AVAILABLE tTotale THEN
  1351. DO:
  1352. CREATE tTotale.
  1353. ASSIGN
  1354. tTotale.Konto = Konto.
  1355. END.
  1356. F_KonBetr = tTotale.Betr.
  1357. F_KonFrw = tTotale.BetrFrw.
  1358. DISPLAY F_KumBetr F_KumFrw
  1359. F_KonBetr F_KonFrw
  1360. F_TotBetr F_TotFrw.
  1361. END.
  1362. END PROCEDURE.
  1363. /* _UIB-CODE-BLOCK-END */
  1364. &ANALYZE-RESUME
  1365. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENABLE_DISABLE fFrameWin
  1366. PROCEDURE ENABLE_DISABLE :
  1367. /*------------------------------------------------------------------------------
  1368. Purpose:
  1369. Parameters: <none>
  1370. Notes:
  1371. ------------------------------------------------------------------------------*/
  1372. DEF INPUT PARAMETER ipFeld AS CHAR NO-UNDO.
  1373. DO WITH FRAME {&FRAME-NAME}:
  1374. CASE ipFeld:
  1375. WHEN '1' THEN
  1376. DO:
  1377. F_Knr :SENSITIVE = FALSE.
  1378. F_Betr :SENSITIVE = FALSE.
  1379. F_Faknr:SENSITIVE = TRUE .
  1380. F_Knr :HIDDEN = TRUE .
  1381. F_Betr :HIDDEN = TRUE .
  1382. F_Faknr:HIDDEN = FALSE.
  1383. END.
  1384. WHEN '2' THEN
  1385. DO:
  1386. F_Betr :SENSITIVE = FALSE.
  1387. F_Faknr:SENSITIVE = FALSE.
  1388. F_Knr :SENSITIVE = TRUE .
  1389. F_Betr :HIDDEN = TRUE .
  1390. F_Faknr:HIDDEN = TRUE .
  1391. F_Knr :HIDDEN = FALSE.
  1392. END.
  1393. WHEN '3' THEN
  1394. DO:
  1395. F_Knr :SENSITIVE = FALSE.
  1396. F_Faknr:SENSITIVE = FALSE.
  1397. F_Betr :SENSITIVE = TRUE .
  1398. F_Knr :HIDDEN = TRUE .
  1399. F_Faknr:HIDDEN = TRUE .
  1400. F_Betr :HIDDEN = FALSE.
  1401. END.
  1402. END CASE.
  1403. END.
  1404. END PROCEDURE.
  1405. /* _UIB-CODE-BLOCK-END */
  1406. &ANALYZE-RESUME
  1407. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI fFrameWin _DEFAULT-ENABLE
  1408. PROCEDURE enable_UI :
  1409. /*------------------------------------------------------------------------------
  1410. Purpose: ENABLE the User Interface
  1411. Parameters: <none>
  1412. Notes: Here we display/view/enable the widgets in the
  1413. user-interface. In addition, OPEN all queries
  1414. associated with each FRAME and BROWSE.
  1415. These statements here are based on the "Other
  1416. Settings" section of the widget Property Sheets.
  1417. ------------------------------------------------------------------------------*/
  1418. DISPLAY CB_ZAHKONTO F_KumBetr F_KonBetr F_TotBetr F_KumFrw F_KonFrw F_TotFrw
  1419. F_Datum F_Faknr F_Knr F_Betr F_ZKnr F_Adresse F_Saldo F_SaldoFrw
  1420. F_SkMFrw
  1421. WITH FRAME fMain.
  1422. IF AVAILABLE tDebop THEN
  1423. DISPLAY tDebop.Faknr tDebop.Fakdat tDebop.Faellig tDebop.FRW tDebop.Kurs
  1424. tDebop.Fakbetr tDebop.Fakbetr_FRW tDebop.Zahbetr tDebop.Zahbetr_FRW
  1425. tDebop.Skonto tDebop.Skonto_FRW tDebop.Saldo tDebop.Saldo_FRW
  1426. WITH FRAME fMain.
  1427. IF AVAILABLE zDebop THEN
  1428. DISPLAY zDebop.Zahbetr_FRW zDebop.FRW zDebop.Kurs zDebop.Zahbetr
  1429. zDebop.Skonto_FRW zDebop.Skonto
  1430. WITH FRAME fMain.
  1431. ENABLE Btn_Tot RECT-1 RECT-2 RECT-3 RECT-4 RECT-5 CB_ZAHKONTO F_KumBetr
  1432. Btn_Kum F_KonBetr Btn_Kon F_TotBetr F_KumFrw F_KonFrw F_TotFrw F_Datum
  1433. CB_Eingabe F_Faknr F_Knr F_Betr F_ZKnr F_Adresse F_Saldo F_SaldoFrw
  1434. tDebop.Faknr tDebop.Fakdat tDebop.Faellig tDebop.FRW tDebop.Kurs
  1435. tDebop.Fakbetr tDebop.Fakbetr_FRW tDebop.Zahbetr tDebop.Zahbetr_FRW
  1436. tDebop.Skonto tDebop.Skonto_FRW tDebop.Saldo tDebop.Saldo_FRW
  1437. zDebop.Zahbetr_FRW zDebop.FRW zDebop.Kurs zDebop.Zahbetr
  1438. zDebop.Skonto_FRW F_SkMFrw zDebop.Skonto Br_Bezahlt
  1439. WITH FRAME fMain.
  1440. {&OPEN-BROWSERS-IN-QUERY-fMain}
  1441. END PROCEDURE.
  1442. /* _UIB-CODE-BLOCK-END */
  1443. &ANALYZE-RESUME
  1444. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE FAKTURANUMMER fFrameWin
  1445. PROCEDURE FAKTURANUMMER :
  1446. /*------------------------------------------------------------------------------
  1447. Purpose:
  1448. Parameters: <none>
  1449. Notes:
  1450. ------------------------------------------------------------------------------*/
  1451. DEF VAR opRecid AS RECID NO-UNDO.
  1452. DEF VAR Faknr AS INT NO-UNDO.
  1453. DO WITH FRAME {&FRAME-NAME}:
  1454. ASSIGN F_Faknr.
  1455. Faknr = F_Faknr.
  1456. FIND Debop NO-LOCK USE-INDEX Debop-k2
  1457. WHERE Debop.Firma = Firma
  1458. AND Debop.Faknr = Faknr NO-ERROR.
  1459. DO WHILE TRUE:
  1460. IF AVAILABLE Debop THEN LEAVE.
  1461. RUN g-anzeig-debop.w ( INPUT 1, INPUT F_Faknr, OUTPUT opRecid ).
  1462. IF opRecid = ? THEN RETURN 'ERROR'.
  1463. FIND Debop WHERE RECID(Debop) = opRecid NO-LOCK NO-ERROR.
  1464. LEAVE.
  1465. END.
  1466. FIND Adresse NO-LOCK USE-INDEX Adresse-k1
  1467. WHERE Adresse.Firma = AdFirma
  1468. AND Adresse.Knr = Debop.Knr NO-ERROR.
  1469. F_ZKnr = Adresse.Knr.
  1470. F_Adresse = Adresse.Anzeig_Br.
  1471. FIND Debst NO-LOCK USE-INDEX Debst-k1
  1472. WHERE Debst.Firma = Firma
  1473. AND Debst.Knr = Debop.Knr NO-ERROR.
  1474. F_Saldo = Debst.Saldo.
  1475. F_SaldoFrw = Debst.Saldo_Frw.
  1476. FIND FIRST tDebop NO-ERROR.
  1477. IF NOT AVAILABLE tDebop THEN CREATE tDebop.
  1478. BUFFER-COPY Debop TO tDebop.
  1479. DISPLAY {&List-6}.
  1480. F_Faknr = Debop.Faknr.
  1481. DISPLAY F_Faknr.
  1482. END.
  1483. RETURN ''.
  1484. END PROCEDURE.
  1485. /* _UIB-CODE-BLOCK-END */
  1486. &ANALYZE-RESUME
  1487. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE FAKTURA_VON_OP fFrameWin
  1488. PROCEDURE FAKTURA_VON_OP :
  1489. /*------------------------------------------------------------------------------
  1490. Purpose:
  1491. Parameters: <none>
  1492. Notes:
  1493. ------------------------------------------------------------------------------*/
  1494. DEF INPUT PARAMETER ipFaknr AS INT NO-UNDO.
  1495. DO WITH FRAME {&FRAME-NAME}:
  1496. CB_Eingabe:SCREEN-VALUE = '1'.
  1497. APPLY 'VALUE-CHANGED' TO CB_Eingabe.
  1498. F_Faknr = ipFaknr.
  1499. DISPLAY F_Faknr.
  1500. END.
  1501. END PROCEDURE.
  1502. /* _UIB-CODE-BLOCK-END */
  1503. &ANALYZE-RESUME
  1504. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE hideObject fFrameWin
  1505. PROCEDURE hideObject :
  1506. /*------------------------------------------------------------------------------
  1507. Purpose: Super Override
  1508. Parameters:
  1509. Notes:
  1510. ------------------------------------------------------------------------------*/
  1511. FAkt = FALSE.
  1512. RUN SUPER.
  1513. /* Code placed here will execute AFTER standard behavior. */
  1514. END PROCEDURE.
  1515. /* _UIB-CODE-BLOCK-END */
  1516. &ANALYZE-RESUME
  1517. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject fFrameWin
  1518. PROCEDURE initializeObject :
  1519. /*------------------------------------------------------------------------------
  1520. Purpose: Super Override
  1521. Parameters:
  1522. Notes:
  1523. ------------------------------------------------------------------------------*/
  1524. DEF VAR cString AS CHAR NO-UNDO.
  1525. DO WITH FRAME {&FRAME-NAME}:
  1526. IF sAktiv THEN
  1527. DO:
  1528. RUN COMBO_ZAHLUNGSART (INPUT CB_ZAHKONTO:HANDLE) NO-ERROR.
  1529. GET-KEY-VALUE SECTION 'Zahlen' KEY 'Konto' VALUE cString.
  1530. IF cString = ? THEN cString = ''.
  1531. IF cString = '' THEN cString = ENTRY(2, CB_ZAHKONTO:LIST-ITEM-PAIRS, ';').
  1532. CB_ZAHKONTO:SCREEN-VALUE = cString NO-ERROR.
  1533. RUN DISPLAY_TOTALE.
  1534. END.
  1535. END.
  1536. RUN SUPER.
  1537. DO WITH FRAME {&FRAME-NAME}:
  1538. GET-KEY-VALUE SECTION 'Zahlen' KEY 'Eingabe' VALUE cString.
  1539. IF cString = ? THEN cString = ''.
  1540. IF cString = '' THEN cString = '1'.
  1541. CB_Eingabe:SCREEN-VALUE = cString NO-ERROR.
  1542. RUN ENABLE_DISABLE ( INPUT CB_Eingabe:SCREEN-VALUE ).
  1543. sDatum = DYNAMIC-FUNCTION('getSperrdatum':U) NO-ERROR.
  1544. END.
  1545. END PROCEDURE.
  1546. /* _UIB-CODE-BLOCK-END */
  1547. &ANALYZE-RESUME
  1548. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE KUNDENNUMMER fFrameWin
  1549. PROCEDURE KUNDENNUMMER :
  1550. /*------------------------------------------------------------------------------
  1551. Purpose:
  1552. Parameters: <none>
  1553. Notes:
  1554. ------------------------------------------------------------------------------*/
  1555. DEF VAR opRecid AS RECID NO-UNDO.
  1556. DEF VAR Knr AS INT NO-UNDO.
  1557. DEF VAR ii AS INT NO-UNDO.
  1558. DO WITH FRAME {&FRAME-NAME}:
  1559. ASSIGN F_Knr .
  1560. Knr = F_Knr .
  1561. ii = 0.
  1562. FOR EACH Debop USE-INDEX Debop-k1
  1563. WHERE Debop.Firma = Firma
  1564. AND Debop.Knr = Knr
  1565. AND Debop.Saldo_Frw <> 0 NO-LOCK:
  1566. ii = ii + 1.
  1567. opRecid = RECID(Debop).
  1568. IF ii > 1 THEN LEAVE.
  1569. END.
  1570. RELEASE Debop.
  1571. IF ii = 1 THEN
  1572. DO:
  1573. FIND Debop WHERE RECID(Debop) = opRecid NO-LOCK NO-ERROR.
  1574. END.
  1575. DO WHILE TRUE:
  1576. IF AVAILABLE Debop THEN LEAVE.
  1577. RUN g-anzeig-debop.w ( INPUT 2, INPUT F_Knr, OUTPUT opRecid ).
  1578. IF opRecid = ? THEN RETURN 'ERROR'.
  1579. FIND Debop WHERE RECID(Debop) = opRecid NO-LOCK NO-ERROR.
  1580. LEAVE.
  1581. END.
  1582. FIND Adresse USE-INDEX Adresse-k1
  1583. WHERE Adresse.Firma = AdFirma
  1584. AND Adresse.Knr = Debop.Knr NO-LOCK NO-ERROR.
  1585. F_ZKnr = Adresse.Knr.
  1586. F_Adresse = Adresse.Anzeig_Br.
  1587. FIND Debst USE-INDEX Debst-k1
  1588. WHERE Debst.Firma = Firma
  1589. AND Debst.Knr = Debop.Knr NO-LOCK NO-ERROR.
  1590. F_Saldo = Debst.Saldo.
  1591. F_SaldoFrw = Debst.Saldo_Frw.
  1592. FIND FIRST TDebop NO-ERROR.
  1593. IF NOT AVAILABLE TDebop THEN CREATE TDebop.
  1594. BUFFER-COPY Debop TO TDebop.
  1595. PUBLISH 'REPOSADRESSE' ( INPUT RECID(Adresse) ).
  1596. DISPLAY {&List-6}.
  1597. F_Knr = Debop.Knr.
  1598. DISPLAY F_Knr.
  1599. END.
  1600. RETURN ''.
  1601. END PROCEDURE.
  1602. /* _UIB-CODE-BLOCK-END */
  1603. &ANALYZE-RESUME
  1604. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE OPENQUERY_ADEBOP fFrameWin
  1605. PROCEDURE OPENQUERY_ADEBOP :
  1606. /*------------------------------------------------------------------------------
  1607. Purpose:
  1608. Parameters: <none>
  1609. Notes:
  1610. ------------------------------------------------------------------------------*/
  1611. OPEN QUERY Br_Bezahlt
  1612. FOR EACH ADebop NO-LOCK.
  1613. END PROCEDURE.
  1614. /* _UIB-CODE-BLOCK-END */
  1615. &ANALYZE-RESUME
  1616. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE RECHNEN fFrameWin
  1617. PROCEDURE RECHNEN :
  1618. /*------------------------------------------------------------------------------
  1619. Purpose:
  1620. Parameters: <none>
  1621. Notes:
  1622. ------------------------------------------------------------------------------*/
  1623. DEF INPUT PARAMETER ipArt AS INT NO-UNDO.
  1624. DEF VAR ZaFrw AS DEC NO-UNDO.
  1625. DEF VAR Za AS DEC NO-UNDO.
  1626. DEF VAR SkFrw AS DEC NO-UNDO.
  1627. DEF VAR Sk AS DEC NO-UNDO.
  1628. DEF VAR Saldo AS DEC NO-UNDO.
  1629. DEF VAR SaldoBW AS DEC NO-UNDO.
  1630. DEF VAR Skonto AS DEC NO-UNDO.
  1631. DEF VAR SkontoBW AS DEC NO-UNDO.
  1632. DEF VAR Kurs AS DEC DECIMALS 8 NO-UNDO.
  1633. DEF VAR Faktor AS INT NO-UNDO.
  1634. DEF VAR PluMin AS INT NO-UNDO.
  1635. DO WITH FRAME {&FRAME-NAME}:
  1636. IF zDebop.Fakbetr_FRW < 0 THEN PluMin = -1.
  1637. ELSE PluMin = +1.
  1638. ZaFrw = DECIMAL(zDebop.Zahbetr_Frw:SCREEN-VALUE).
  1639. Za = DECIMAL(zDebop.Zahbetr :SCREEN-VALUE).
  1640. SkFrw = DECIMAL(zDebop.Skonto_Frw :SCREEN-VALUE).
  1641. Sk = DECIMAL(zDebop.Skonto :SCREEN-VALUE).
  1642. Kurs = DECIMAL(zDebop.Kurs :SCREEN-VALUE).
  1643. Faktor = IF zDebop.Faktor > 0 THEN zDebop.Faktor ELSE 1.
  1644. IF Faktor = ? THEN Faktor = 1.
  1645. IF ZaFrw = 0 AND
  1646. SkFrw = 0 AND
  1647. Za = 0 AND
  1648. Sk = 0 THEN RETURN.
  1649. CASE ipArt:
  1650. WHEN 1 THEN
  1651. Za = ZaFrw * Kurs / Faktor.
  1652. WHEN 2 THEN
  1653. Za = ZaFrw * Kurs / Faktor.
  1654. WHEN 3 THEN
  1655. ZaFrw = Za * Faktor / Kurs .
  1656. WHEN 4 THEN
  1657. Sk = SkFrw * Kurs / Faktor.
  1658. END.
  1659. Saldo = zDebop.Saldo_Frw - ZaFrw.
  1660. Skonto = SkFrw.
  1661. Saldo = Saldo - Skonto.
  1662. SaldoBw = zDebop.Saldo - Za.
  1663. SkontoBw = Sk.
  1664. SaldoBw = SaldoBw - SkontoBw.
  1665. IF Saldo = 0 THEN
  1666. DO:
  1667. IF zDebop.Frw = BasFrw THEN
  1668. DO:
  1669. IF SaldoBW <> 0 THEN Za = Za + SaldoBW.
  1670. END.
  1671. END.
  1672. DO WHILE TRUE:
  1673. IF Saldo = 0 THEN LEAVE.
  1674. IF ipArt = 4 THEN LEAVE.
  1675. IF zDebop.Fakbetr_Frw > 0 AND
  1676. ZaFrw < 0 THEN LEAVE.
  1677. IF zDebop.Fakbetr_Frw < 0 AND
  1678. ZaFrw > 0 THEN LEAVE.
  1679. IF ABS(zDebop.Fakbetr_Frw) = ABS(ZaFrw) THEN LEAVE.
  1680. Skonto = SkFrw + Saldo.
  1681. IF (Skonto * PluMin) > (zDebop.SkMax_Frw * PluMin) THEN
  1682. DO:
  1683. IF SkFrw >= zDebop.SkMax_Frw THEN LEAVE.
  1684. SkFrw = zDebop.SkMax_Frw.
  1685. Sk = SkFrw * Kurs / Faktor.
  1686. END.
  1687. ELSE
  1688. DO:
  1689. SkFrw = SkFrw + Saldo.
  1690. Sk = SkFrw * Kurs / Faktor.
  1691. END.
  1692. LEAVE.
  1693. END.
  1694. zDebop.Zahbetr_Frw:SCREEN-VALUE = STRING(ZaFrw).
  1695. zDebop.Kurs :SCREEN-VALUE = STRING(Kurs).
  1696. zDebop.Zahbetr :SCREEN-VALUE = STRING(Za).
  1697. zDebop.Skonto_Frw :SCREEN-VALUE = STRING(SkFrw).
  1698. zDebop.Skonto :SCREEN-VALUE = STRING(Sk).
  1699. zDebop.Zahbetr_Frw:MODIFIED = FALSE.
  1700. zDebop.Kurs :MODIFIED = FALSE.
  1701. zDebop.Zahbetr :MODIFIED = FALSE.
  1702. zDebop.Skonto_Frw :MODIFIED = FALSE.
  1703. zDebop.Skonto :MODIFIED = FALSE.
  1704. Skonto = (SkFrw + TDebop.Skonto_Frw) * PluMin.
  1705. IF Skonto > (zDebop.SkMax_Frw * PluMin) THEN zDebop.Skonto_Frw:BGCOLOR = 12.
  1706. ELSE zDebop.Skonto_Frw:BGCOLOR = 15.
  1707. END.
  1708. END PROCEDURE.
  1709. /* _UIB-CODE-BLOCK-END */
  1710. &ANALYZE-RESUME
  1711. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE REPOSADRESSE fFrameWin
  1712. PROCEDURE REPOSADRESSE :
  1713. /*------------------------------------------------------------------------------
  1714. Purpose:
  1715. Parameters: <none>
  1716. Notes:
  1717. ------------------------------------------------------------------------------*/
  1718. DEF INPUT PARAMETER ipRecid AS RECID NO-UNDO.
  1719. FIND Adresse WHERE RECID(Adresse) = ipRecid NO-LOCK NO-ERROR.
  1720. IF AVAILABLE Adresse THEN iKnr = Adresse.Knr.
  1721. DO WITH FRAME {&FRAME-NAME}:
  1722. IF F_Knr:HIDDEN = FALSE THEN
  1723. DO:
  1724. F_Knr:SCREEN-VALUE = STRING(iKnr).
  1725. APPLY 'ENTRY' TO F_Knr.
  1726. RETURN NO-APPLY.
  1727. END.
  1728. END.
  1729. END PROCEDURE.
  1730. /* _UIB-CODE-BLOCK-END */
  1731. &ANALYZE-RESUME
  1732. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE TEST_EINGABEN fFrameWin
  1733. PROCEDURE TEST_EINGABEN :
  1734. /*------------------------------------------------------------------------------
  1735. Purpose:
  1736. Parameters: <none>
  1737. Notes:
  1738. ------------------------------------------------------------------------------*/
  1739. DEF VAR ZaFrw AS DEC NO-UNDO.
  1740. DEF VAR Za AS DEC NO-UNDO.
  1741. DEF VAR SkFrw AS DEC NO-UNDO.
  1742. DEF VAR Sk AS DEC NO-UNDO.
  1743. DEF VAR Kurs AS DEC DECIMALS 8 NO-UNDO.
  1744. DEF VAR Faktor AS INT NO-UNDO.
  1745. DEF VAR Saldo AS DEC NO-UNDO.
  1746. DEF VAR SkMax AS DEC NO-UNDO.
  1747. DEF VAR Ja AS LOG NO-UNDO.
  1748. DEF VAR hDebop AS HANDLE NO-UNDO.
  1749. DO WITH FRAME {&FRAME-NAME}:
  1750. ZaFrw = DECIMAL(zDebop.Zahbetr_Frw:SCREEN-VALUE).
  1751. Za = DECIMAL(zDebop.Zahbetr :SCREEN-VALUE).
  1752. SkFrw = DECIMAL(zDebop.Skonto_Frw :SCREEN-VALUE).
  1753. Sk = DECIMAL(zDebop.Skonto :SCREEN-VALUE).
  1754. Kurs = DECIMAL(zDebop.Kurs :SCREEN-VALUE).
  1755. Faktor = zDebop.Faktor.
  1756. IF Faktor = 0 THEN
  1757. DO:
  1758. FIND Waehrung NO-LOCK
  1759. WHERE Waehrung.Firma = zDebop.Firma
  1760. AND Waehrung.Frw = zDebop.Frw NO-ERROR.
  1761. Faktor = Waehrung.Faktor.
  1762. IF Faktor = 0 THEN Faktor = 1.
  1763. zDebop.Faktor = Faktor.
  1764. REPEAT TRANSACTION:
  1765. FIND Debop
  1766. WHERE Debop.Firma = zDebop.Firma
  1767. AND Debop.Knr = zDebop.Knr
  1768. AND Debop.Faknr = zDebop.Faknr.
  1769. Debop.Faktor = Faktor.
  1770. RELEASE Debop.
  1771. LEAVE.
  1772. END.
  1773. END.
  1774. ja = FALSE.
  1775. IF ZaFrw = 0 AND
  1776. SkFrw = 0 THEN
  1777. DO:
  1778. MESSAGE 'Wollen Sie eine "NULL"-Zahlung machen ? '
  1779. VIEW-AS ALERT-BOX QUESTION BUTTONS YES-NO
  1780. UPDATE Ja.
  1781. IF NOT Ja THEN RETURN 'ERROR'.
  1782. END.
  1783. IF NOT Ja THEN
  1784. DO:
  1785. Saldo = tDebop.Saldo_Frw - ZaFrw - SkFrw.
  1786. IF Saldo <> 0 THEN
  1787. DO:
  1788. Ja = FALSE.
  1789. MESSAGE 'Es bleibt ein Restsaldo von '
  1790. tDebop.Frw ' ' Saldo '! '
  1791. VIEW-AS ALERT-BOX QUESTION BUTTONS YES-NO
  1792. UPDATE ja.
  1793. IF NOT Ja THEN RETURN 'ERROR'.
  1794. END.
  1795. END.
  1796. ASSIGN {&List-5}.
  1797. zDebop.ZaKonto = CB_ZAHKONTO:SCREEN-VALUE.
  1798. zDebop.ZahDat = DATE(F_Datum:SCREEN-VALUE).
  1799. hDebop = BUFFER zDebop:HANDLE.
  1800. RUN ZAHLUNG_BUCHEN ( INPUT hDebop, 61 ).
  1801. IF RETURN-VALUE <> '' THEN RETURN 'ERROR'.
  1802. FIND FIRST tTotale WHERE tTotale.Konto = zDebop.ZaKonto NO-ERROR.
  1803. IF NOT AVAILABLE tTotale THEN
  1804. DO:
  1805. CREATE tTotale.
  1806. ASSIGN
  1807. tTotale.Konto = zDebop.ZaKonto.
  1808. END.
  1809. tTotale.BetrFrw = tTotale.BetrFrw + ZaFrw.
  1810. tTotale.Betr = tTotale.Betr + Za.
  1811. F_KumBetr = F_KumBetr + Za.
  1812. F_KumFrw = F_KumFrw + ZaFrw.
  1813. F_TotBetr = F_TotBetr + Za.
  1814. F_TotFrw = F_TotFrw + ZaFrw.
  1815. F_KonBetr = tTotale.Betr.
  1816. F_KonFrw = tTotale.BetrFrw.
  1817. FIND Debop USE-INDEX Debop-k1
  1818. WHERE Debop.Firma = tDebop.Firma
  1819. AND Debop.Knr = tDebop.Knr
  1820. AND Debop.Faknr = tDebop.Faknr NO-LOCK NO-ERROR.
  1821. IF AVAILABLE Debop THEN
  1822. DO:
  1823. FIND ADebop USE-INDEX Debop-k1
  1824. WHERE ADebop.Firma = Debop.Firma
  1825. AND ADebop.Knr = Debop.Knr
  1826. AND ADebop.Faknr = Debop.Faknr NO-ERROR.
  1827. IF AVAILABLE ADebop THEN DELETE ADebop.
  1828. CREATE ADebop.
  1829. BUFFER-COPY Debop TO ADebop.
  1830. RUN OPENQUERY_ADEBOP.
  1831. END.
  1832. EMPTY TEMP-TABLE zDebop.
  1833. CREATE zDebop.
  1834. DISPLAY {&List-5}.
  1835. DISPLAY {&List-4}.
  1836. zDebop.Zahbetr_Frw:READ-ONLY = TRUE.
  1837. zDebop.Skonto_Frw :READ-ONLY = TRUE.
  1838. zDebop.Zahbetr :READ-ONLY = TRUE.
  1839. zDebop.Skonto :READ-ONLY = TRUE.
  1840. zDebop.Kurs :READ-ONLY = TRUE.
  1841. zDebop.Skonto_Frw :BGCOLOR = 15.
  1842. FMut = FALSE.
  1843. APPLY 'ENTRY' TO F_Datum.
  1844. RETURN ''.
  1845. END.
  1846. END PROCEDURE.
  1847. /* _UIB-CODE-BLOCK-END */
  1848. &ANALYZE-RESUME
  1849. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE viewObject fFrameWin
  1850. PROCEDURE viewObject :
  1851. /*------------------------------------------------------------------------------
  1852. Purpose: Super Override
  1853. Parameters:
  1854. Notes:
  1855. ------------------------------------------------------------------------------*/
  1856. /* Code placed here will execute PRIOR to standard behavior. */
  1857. RUN SUPER.
  1858. FAkt = TRUE.
  1859. END PROCEDURE.
  1860. /* _UIB-CODE-BLOCK-END */
  1861. &ANALYZE-RESUME
  1862. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE VORBEREITEN fFrameWin
  1863. PROCEDURE VORBEREITEN :
  1864. /*------------------------------------------------------------------------------
  1865. Purpose:
  1866. Parameters: <none>
  1867. Notes:
  1868. ------------------------------------------------------------------------------*/
  1869. DEF VAR hBuffer AS HANDLE NO-UNDO.
  1870. DO WITH FRAME {&FRAME-NAME}:
  1871. ASSIGN F_Datum.
  1872. FIND FIRST tDebop NO-ERROR.
  1873. IF NOT AVAILABLE tDebop THEN RETURN.
  1874. FIND Waehrung NO-LOCK
  1875. WHERE Waehrung.Firma = tDebop.Firma
  1876. AND Waehrung.Frw = tDebop.Frw NO-ERROR.
  1877. FIND FIRST zDebop NO-ERROR.
  1878. IF NOT AVAILABLE zDebop THEN CREATE zDebop.
  1879. BUFFER-COPY tDebop TO zDebop.
  1880. ASSIGN
  1881. zDebop.Zahdat = F_Datum
  1882. zDebop.Kurs = (IF AVAILABLE Waehrung THEN Waehrung.Kurs ELSE tDebop.Kurs).
  1883. hBuffer = BUFFER zDebop:HANDLE.
  1884. RUN ZAHLBERECHNUNG ( INPUT-OUTPUT hBuffer ).
  1885. F_SkMFrw = zDebop.SkMax_Frw.
  1886. DISPLAY {&List-5}.
  1887. zDebop.Zahbetr_Frw:READ-ONLY = FALSE.
  1888. zDebop.Zahbetr :READ-ONLY = FALSE.
  1889. zDebop.Skonto_Frw :READ-ONLY = FALSE.
  1890. zDebop.Skonto :READ-ONLY = FALSE.
  1891. zDebop.Kurs :READ-ONLY = FALSE.
  1892. zDebop.Skonto_Frw :BGCOLOR = 15.
  1893. FMut = TRUE.
  1894. APPLY 'ENTRY' TO zDebop.Zahbetr_Frw.
  1895. END.
  1896. END PROCEDURE.
  1897. /* _UIB-CODE-BLOCK-END */
  1898. &ANALYZE-RESUME