Sav_SammelRechnung.p 74 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131
  1. &ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12
  2. &ANALYZE-RESUME
  3. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS Procedure
  4. /*------------------------------------------------------------------------
  5. File :
  6. Purpose :
  7. Syntax :
  8. Description :
  9. Author(s) :
  10. Created :
  11. Notes :
  12. ----------------------------------------------------------------------*/
  13. /* This .W file was created with the Progress AppBuilder. */
  14. /*----------------------------------------------------------------------*/
  15. /* *************************** Definitions ************************** */
  16. DEFINE INPUT PARAMETER iphParam AS HANDLE NO-UNDO.
  17. DEFINE OUTPUT PARAMETER opcResult AS CHARACTER NO-UNDO.
  18. DEFINE VARIABLE iSeite AS INTEGER NO-UNDO.
  19. DEFINE VARIABLE iAnzDok AS INTEGER NO-UNDO.
  20. DEFINE VARIABLE iLauf AS INTEGER NO-UNDO.
  21. DEFINE VARIABLE lFirst AS LOG INIT FALSE NO-UNDO.
  22. DEFINE VARIABLE lLast AS LOG INIT FALSE NO-UNDO.
  23. DEFINE VARIABLE lPreis AS LOG NO-UNDO.
  24. DEFINE VARIABLE cFirma AS CHARACTER NO-UNDO.
  25. DEFINE VARIABLE AdFirma AS CHARACTER NO-UNDO.
  26. DEFINE VARIABLE nFakBetr AS DECIMAL NO-UNDO.
  27. DEFINE VARIABLE dFakDatum AS DATE NO-UNDO.
  28. DEFINE VARIABLE iFaknr AS INTEGER NO-UNDO.
  29. DEFINE VARIABLE iSprcd AS INTEGER NO-UNDO.
  30. DEFINE VARIABLE nTotale AS DECIMAL EXTENT 15 NO-UNDO.
  31. DEFINE VARIABLE cFormtext AS CHARACTER EXTENT 30 NO-UNDO.
  32. DEFINE VARIABLE cRabText AS CHARACTER NO-UNDO.
  33. DEFINE VARIABLE cZusText AS CHARACTER NO-UNDO.
  34. DEFINE VARIABLE cEpzText AS CHARACTER NO-UNDO.
  35. DEFINE VARIABLE cBesrKopf AS CHARACTER EXTENT 12 NO-UNDO.
  36. DEFINE VARIABLE lDebIncl AS LOG NO-UNDO.
  37. DEFINE VARIABLE Rundbetr AS DECIMAL DECIMALS 4 NO-UNDO.
  38. DEFINE VARIABLE RundCode AS INTEGER INIT 1 NO-UNDO.
  39. DEFINE VARIABLE htTabTexte AS HANDLE NO-UNDO.
  40. DEFINE VARIABLE hSavko AS HANDLE NO-UNDO.
  41. DEFINE VARIABLE cInstallation AS CHARACTER NO-UNDO.
  42. DEFINE VARIABLE iBesrArt AS INTEGER NO-UNDO.
  43. DEFINE VARIABLE iMaxPos AS INTEGER INIT 2650 NO-UNDO.
  44. DEFINE VARIABLE cvpr_Dokument AS CHARACTER NO-UNDO.
  45. DEFINE VARIABLE iArtZeile AS INTEGER NO-UNDO.
  46. DEFINE VARIABLE iVPagePos AS INTEGER NO-UNDO.
  47. DEFINE VARIABLE iVGroupPos AS INTEGER NO-UNDO.
  48. DEFINE BUFFER bSavko FOR Savko .
  49. DEFINE BUFFER bSavze FOR Savze .
  50. DEFINE BUFFER FDebst FOR Debst . /* Fakturaadresse */
  51. DEFINE BUFFER LDebst FOR Debst . /* Lieferadresse */
  52. DEFINE BUFFER bDebst FOR Debst . /* BesrArt/Verband */
  53. DEFINE BUFFER LAdresse FOR Adresse .
  54. DEFINE BUFFER bAdresse FOR Adresse .
  55. DEFINE BUFFER bWust FOR Wust .
  56. DEFINE BUFFER bSteuer FOR Steuer .
  57. { incl/properties.i }
  58. { incl/ttdruckparam.i }
  59. { swissqr/propertiesSwissQR.i }
  60. DEFINE TEMP-TABLE tDokument
  61. FIELD cGruppe AS CHARACTER
  62. FIELD iZeile AS INTEGER
  63. FIELD cFeld AS CHARACTER
  64. FIELD cInhalt AS CHARACTER
  65. INDEX tDokument-k1 IS PRIMARY
  66. cGruppe
  67. iZeile
  68. cFeld
  69. .
  70. DEFINE TEMP-TABLE tTotale
  71. FIELD nMwstPfl AS DECIMAL EXTENT 12
  72. FIELD nMwstBet AS DECIMAL EXTENT 12
  73. FIELD nSammTot AS DECIMAL
  74. FIELD nSkBer AS DECIMAL
  75. FIELD nWW AS DECIMAL
  76. .
  77. DEFINE TEMP-TABLE sSavko
  78. FIELD cFirma AS CHARACTER
  79. FIELD iAufnr AS INTEGER
  80. FIELD iFak_Knr AS INTEGER
  81. FIELD iKnr AS INTEGER
  82. FIELD iSamm_Nr AS INTEGER
  83. FIELD iRecid AS RECID
  84. FIELD iFaknr AS INTEGER
  85. .
  86. DEFINE TEMP-TABLE tSavko LIKE Savko
  87. FIELD iRecid AS RECID
  88. FIELD lBetrag AS LOGICAL
  89. .
  90. DEFINE TEMP-TABLE tSavze
  91. FIELD Aufnr AS INTEGER
  92. FIELD Sort1 AS CHARACTER
  93. FIELD Sort2 AS CHARACTER
  94. FIELD Sort3 AS CHARACTER
  95. FIELD Artnr AS INTEGER
  96. FIELD Inhalt AS INTEGER
  97. FIELD Jahr AS INTEGER
  98. FIELD Pos AS INTEGER
  99. FIELD Zeile AS RECID
  100. FIELD Preis AS DECIMAL DECIMALS 4
  101. FIELD Aktion AS LOG
  102. FIELD LagOrt AS CHARACTER
  103. FIELD MGeli AS DECIMAL
  104. FIELD MRuek AS DECIMAL
  105. INDEX tSavze-k1 IS PRIMARY
  106. Aufnr
  107. Sort1
  108. Sort2
  109. Sort3
  110. .
  111. DEFINE TEMP-TABLE tSpeRab
  112. FIELD Rab_Grp AS INTEGER
  113. FIELD Auf_Betr AS DECIMAL DECIMALS 4
  114. .
  115. DEFINE TEMP-TABLE tGebKto
  116. FIELD Sort_Cd AS CHARACTER
  117. FIELD Geb_Cd AS CHARACTER
  118. FIELD Bez AS CHARACTER
  119. FIELD Preis AS DECIMAL
  120. FIELD A_Anz AS DECIMAL
  121. FIELD A_Betrag AS DECIMAL
  122. FIELD E_Anz AS DECIMAL
  123. FIELD E_Betrag AS DECIMAL
  124. FIELD MWST_Art AS INTEGER
  125. FIELD MWST_Cd AS INTEGER
  126. .
  127. DEFINE TEMP-TABLE tRabSumm
  128. FIELD Rab_Summ AS INTEGER
  129. FIELD Bez AS CHARACTER
  130. FIELD F_Rab_Art AS INTEGER
  131. FIELD F_Wert AS DECIMAL DECIMALS 4
  132. FIELD A_Rab_Art AS INTEGER
  133. FIELD A_Wert AS DECIMAL DECIMALS 4
  134. FIELD Auf_Rab AS DECIMAL DECIMALS 4
  135. FIELD Abh_Rab AS DECIMAL DECIMALS 4
  136. .
  137. DEFINE TEMP-TABLE tUmsGrp
  138. FIELD Ums_Grp AS INTEGER
  139. FIELD Mwst AS INTEGER
  140. FIELD Ansatz AS DECIMAL
  141. FIELD Bez AS CHARACTER
  142. FIELD lInkl AS LOG
  143. FIELD Ums_Betr AS DECIMAL DECIMALS 4
  144. .
  145. DEFINE TEMP-TABLE tTabTexte
  146. FIELD cRecArt AS CHARACTER
  147. FIELD iZeile AS INTEGER
  148. FIELD cFeld1 AS CHARACTER
  149. FIELD cFeld2 AS CHARACTER
  150. FIELD cFeld3 AS CHARACTER
  151. FIELD iFeld1 AS INTEGER
  152. FIELD iFeld2 AS INTEGER
  153. FIELD iFeld3 AS INTEGER
  154. INDEX tTabTexte-k1 IS PRIMARY
  155. cRecArt
  156. iZeile.
  157. /* _UIB-CODE-BLOCK-END */
  158. &ANALYZE-RESUME
  159. &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
  160. /* ******************** Preprocessor Definitions ******************** */
  161. &Scoped-define PROCEDURE-TYPE Procedure
  162. &Scoped-define DB-AWARE no
  163. /* _UIB-PREPROCESSOR-BLOCK-END */
  164. &ANALYZE-RESUME
  165. /* *********************** Procedure Settings ************************ */
  166. &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
  167. /* Settings for THIS-PROCEDURE
  168. Type: Procedure
  169. Allow:
  170. Frames: 0
  171. Add Fields to: Neither
  172. Other Settings: CODE-ONLY COMPILE
  173. */
  174. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
  175. /* ************************* Create Window ************************** */
  176. &ANALYZE-SUSPEND _CREATE-WINDOW
  177. /* DESIGN Window definition (used by the UIB)
  178. CREATE WINDOW Procedure ASSIGN
  179. HEIGHT = 41.05
  180. WIDTH = 100.4.
  181. /* END WINDOW DEFINITION */
  182. */
  183. &ANALYZE-RESUME
  184. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK Procedure
  185. /* *************************** Main Block *************************** */
  186. opcResult = ''.
  187. CREATE tParam.
  188. htParam:BUFFER-COPY(iphParam).
  189. ASSIGN
  190. cFirma = tParam.cFirma
  191. iAnzDok = tParam.Anzahl
  192. cInstallation = DYNAMIC-FUNCTION ('getInstallation':U)
  193. cERPDokumente = DYNAMIC-FUNCTION ('getFehlwert':U, tParam.cFirma, 'GEMIS_ERPDOKUMENTE')
  194. cPathQRCodes = DYNAMIC-FUNCTION ('getFehlwert':U, tParam.cFirma, 'GEMIS_QRCODE' ) NO-ERROR.
  195. FIND bSteuer NO-LOCK WHERE bSteuer.Firma = cFirma.
  196. AdFirma = bSteuer.AdFirma.
  197. RUN AUFTRAG_ERMITTELN.
  198. IF opcResult <> '' THEN RETURN.
  199. FOR EACH sSavko
  200. BY sSavko.iFak_Knr:
  201. FIND bAdresse NO-LOCK
  202. WHERE bAdresse.Firma = AdFirma
  203. AND bAdresse.Knr = sSavko.iFak_Knr.
  204. iSprcd = bAdresse.Sprcd.
  205. RUN GET_FORMTEXT ( tParam.cInstall, tParam.cDokument, iSprcd,
  206. OUTPUT cFormText ) NO-ERROR.
  207. cRabText = TRIM(SUBSTRING(cFormText[21],01,20)).
  208. cZusText = TRIM(SUBSTRING(cFormText[21],21,20)).
  209. cEpzText = TRIM(SUBSTRING(cFormText[21],41,20)).
  210. RELEASE bAdresse.
  211. { vpr.i INIT }
  212. { vpr.i START }
  213. DO iLauf = 1 TO iAnzDok:
  214. dFakDatum = tParam.dFakDatum.
  215. iSeite = 0.
  216. iFaknr = sSavko.iFaknr.
  217. lFirst = TRUE.
  218. lPreis = TRUE.
  219. lLast = FALSE.
  220. EMPTY TEMP-TABLE tUmsGrp .
  221. EMPTY TEMP-TABLE tTotale .
  222. EMPTY TEMP-TABLE tDokument .
  223. CREATE tTotale.
  224. FOR EACH bSavko NO-LOCK
  225. WHERE bSavko.Firma = sSavko.cFirma
  226. AND bSavko.Fak_Knr = sSavko.iFak_Knr
  227. AND bSavko.Samm_Nr = sSavko.iSamm_Nr
  228. AND bSavko.Faknr = sSavko.iFaknr
  229. BREAK BY bSavko.Fak_Knr
  230. BY bSavko.Samm_Nr
  231. BY bSavko.Knr
  232. BY bSavko.Aufnr :
  233. EMPTY TEMP-TABLE tSavze .
  234. EMPTY TEMP-TABLE tGebKto .
  235. EMPTY TEMP-TABLE tRabSumm .
  236. EMPTY TEMP-TABLE tSpeRab .
  237. EMPTY TEMP-TABLE tTabTexte .
  238. FIND bAdresse NO-LOCK USE-INDEX Adresse-k1
  239. WHERE bAdresse.Firma = AdFirma
  240. AND bAdresse.Knr = bSavko.Fak_Knr NO-ERROR.
  241. FIND LDebst NO-LOCK USE-INDEX Debst-k1
  242. WHERE LDebst.Firma = cFirma
  243. AND LDebst.Knr = bSavko.Knr NO-ERROR.
  244. FIND FDebst NO-LOCK USE-INDEX Debst-k1
  245. WHERE FDebst.Firma = cFirma
  246. AND FDebst.Knr = bSavko.Fak_Knr NO-ERROR.
  247. FIND bWust NO-LOCK USE-INDEX Wust-k1
  248. WHERE bWust.CodeK = LDebst.MWST
  249. AND bWust.CodeA = 99 NO-ERROR.
  250. lDebIncl = FALSE.
  251. IF AVAILABLE bWust THEN lDebIncl = bWust.Incl.
  252. hSavko = BUFFER bSavko:HANDLE.
  253. htTabTexte = TEMP-TABLE tTabTexte:DEFAULT-BUFFER-HANDLE.
  254. /* Texte und Werte aus Tabelle 'Tabel' laden für RecArt */
  255. /* FAKART, AUFSTATUS, LIEFART, FAHRER, WISO, ABLAD */
  256. RUN CREATE_TABTEXTE ( hSavko, INPUT-OUTPUT htTabTexte ) NO-ERROR.
  257. RUN FUELLEN_tSavze ( bSavko.Aufnr ) NO-ERROR.
  258. FOR EACH tSavze
  259. WHERE tSavze.Artnr > 0:
  260. FIND bSavze NO-LOCK WHERE RECID(bSavze) = tSavze.Zeile.
  261. /* Spezial-Auftragsrabatt pro Lieferschein bilden */
  262. IF bSavze.Auf_Sp_Grp > 0 THEN
  263. DO:
  264. FIND FIRST tSpeRab
  265. WHERE tSpeRab.Rab_Grp = bSavze.Auf_Sp_Grp NO-ERROR.
  266. IF NOT AVAILABLE tSpeRab THEN
  267. DO:
  268. CREATE tSpeRab.
  269. ASSIGN
  270. tSpeRab.Rab_Grp = bSavze.Auf_Sp_Grp.
  271. END.
  272. tSpeRab.Auf_Betr = tSpeRab.Auf_Betr + bSavze.Auf_Sp_Rab.
  273. END.
  274. /* Summengruppen-Totale pro Lieferschein bilden */
  275. DO WHILE bSavze.Rab_Su_Grp > 0:
  276. FIND FIRST tRabSumm
  277. WHERE tRabSumm.Rab_Summ = bSavze.Rab_Su_Grp NO-ERROR.
  278. IF NOT AVAILABLE tRabSumm THEN
  279. DO:
  280. FIND FIRST RabSumm NO-LOCK
  281. WHERE RabSumm.Firma = bSavze.Firma
  282. AND RabSumm.Rab_Summ = bSavze.Rab_Su_Grp NO-ERROR.
  283. IF NOT AVAILABLE RabSumm THEN LEAVE.
  284. CREATE tRabSumm.
  285. ASSIGN
  286. tRabSumm.Rab_Summ = bSavze.Rab_Su_Grp
  287. tRabSumm.Bez = RabSumm.Bez
  288. tRabSumm.Auf_Rab = 0
  289. tRabSumm.Abh_Rab = 0.
  290. END.
  291. LEAVE.
  292. END.
  293. END.
  294. IF LAST-OF ( bSavko.Samm_Nr ) THEN lLast = TRUE.
  295. iArtZeile = 0.
  296. RUN DRUCKEN.
  297. /* Auftragskopf mutieren */
  298. REPEAT TRANSACTION:
  299. IF iLauf < iAnzDok THEN LEAVE.
  300. FIND FIRST tTabTexte NO-LOCK
  301. WHERE tTabTexte.cRecArt = 'FAKART'
  302. AND tTabTexte.iZeile = 1.
  303. FIND Savko WHERE RECID(Savko) = RECID(bSavko).
  304. Savko.Gedruckt = TRUE.
  305. IF tTabTexte.iFeld1 > Savko.Fak_Art THEN Savko.Fak_Art = tTabTexte.iFeld1.
  306. IF tTabTexte.iFeld2 > Savko.Auf_Sta THEN Savko.Auf_Sta = tTabTexte.iFeld2.
  307. RELEASE Savko.
  308. LEAVE.
  309. END.
  310. END.
  311. END.
  312. { vpr.i STOP }
  313. END.
  314. PROCEDURE ShellExecuteA EXTERNAL "shell32.dll" :
  315. DEFINE INPUT PARAMETER lphwnd AS LONG.
  316. DEFINE INPUT PARAMETER lpOperation AS CHARACTER.
  317. DEFINE INPUT PARAMETER lpFile AS CHARACTER.
  318. DEFINE INPUT PARAMETER lpParameters AS CHARACTER.
  319. DEFINE INPUT PARAMETER lpDirectory AS CHARACTER.
  320. DEFINE INPUT PARAMETER nShowCmd AS LONG.
  321. DEFINE RETURN PARAMETER hInstance AS LONG.
  322. END PROCEDURE.
  323. /* _UIB-CODE-BLOCK-END */
  324. &ANALYZE-RESUME
  325. &IF DEFINED(EXCLUDE-DRUCKEN_QRCODE) = 0 &THEN
  326. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DRUCKEN_QRCODE Procedure
  327. PROCEDURE DRUCKEN_QRCODE:
  328. /*------------------------------------------------------------------------------*/
  329. /* Purpose: */
  330. /* Parameters: <none> */
  331. /* Notes: */
  332. /*------------------------------------------------------------------------------*/
  333. DEFINE VARIABLE cFileName AS CHARACTER NO-UNDO.
  334. DEFINE VARIABLE cString AS CHARACTER NO-UNDO.
  335. DEFINE VARIABLE hSavko AS HANDLE NO-UNDO.
  336. DEFINE VARIABLE cBesrTemplate AS CHARACTER NO-UNDO INIT 'viper/oswald/BESR_QR.vfr'.
  337. DEFINE VARIABLE cWerbung AS CHARACTER NO-UNDO.
  338. DEFINE VARIABLE cConString AS CHARACTER NO-UNDO.
  339. DEFINE VARIABLE i1 AS INTEGER NO-UNDO.
  340. FIND FIRST tSavko.
  341. hSavko = TEMP-TABLE tSavko:DEFAULT-BUFFER-HANDLE.
  342. FIND FIRST Debop NO-LOCK
  343. WHERE Debop.Firma = tSavko.Firma
  344. AND Debop.Knr = tSavko.Fak_Knr
  345. AND Debop.Faknr = tSavko.Faknr NO-ERROR.
  346. tSavko.Auf_Tot = Debop.Fakbetr.
  347. FIND FIRST tParam.
  348. FIND FIRST ViperDoc NO-LOCK
  349. WHERE ViperDoc.Firma = tSavko.Firma
  350. AND ViperDoc.Benutzer = ''
  351. AND ViperDoc.Formular = 'BESR_QR'
  352. AND ViperDoc.DokArt = 0 NO-ERROR.
  353. IF NOT AVAILABLE ViperDoc THEN RETURN.
  354. RUN vpr_LoadVFR (cBesrTemplate).
  355. RUN vpr_ActivateReport ('BESR_QR').
  356. RUN vpr_SelectPrinter (ViperDoc.Drucker).
  357. RUN vpr_SetDocAttrib ('PAPERSIZE=A4').
  358. RUN vpr_SetPreviewMode ('Direct').
  359. RUN vpr_InitGroups ("").
  360. RUN vpr_initGraphObj.
  361. RUN vpr_SetCurrentPageProperties("Papertray", ViperDoc.Schacht_BESR).
  362. cFileName = SUBSTITUTE('&1&2_&3', cPathQRCodes, 'QR_CODE', STRING(bSavko.Aufnr,'9999999')).
  363. RUN 'SwissQR/SwissQRCode.p' ( hSavko, cFileName ).
  364. cFilename = cFileName + '.jpg'.
  365. IF SEARCH(cFileName) <> ? THEN
  366. DO:
  367. cFileName = 'FILENAME=' + cFileName.
  368. RUN vpr_setGraphObjAttrib ( 'QRCode', 'QRCODE', cFileName ).
  369. END.
  370. cWerbung = SUBSTITUTE(cPathWerbung, tParam.cInstall).
  371. cWerbung = SUBSTITUTE('&1Werbung_&2.jpg', cWerbung, tSavko.Firma).
  372. IF SEARCH(cWerbung) <> ? THEN
  373. DO:
  374. cWerbung = SUBSTITUTE('FILENAME=&1', cWerbung).
  375. RUN vpr_setGraphObjAttrib ( 'Werbung', 'QRCODE', cWerbung ).
  376. END.
  377. RUN vpr_InitGraphObj.
  378. RUN vpr_flushGroup('QRCODE').
  379. END PROCEDURE.
  380. /* _UIB-CODE-BLOCK-END */
  381. &ANALYZE-RESUME
  382. &ENDIF
  383. /* ********************** Internal Procedures *********************** */
  384. &IF DEFINED(EXCLUDE-ARTIKELZEILE) = 0 &THEN
  385. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ARTIKELZEILE Procedure
  386. PROCEDURE ARTIKELZEILE :
  387. /*------------------------------------------------------------------------------
  388. Purpose:
  389. Parameters: <none>
  390. Notes:
  391. ------------------------------------------------------------------------------*/
  392. DEFINE INPUT PARAMETER ipRecid AS RECID NO-UNDO.
  393. DEFINE VARIABLE cString AS CHARACTER NO-UNDO.
  394. DEFINE VARIABLE nRabWert AS DECIMAL NO-UNDO.
  395. DEFINE VARIABLE xRabText AS CHARACTER NO-UNDO.
  396. FIND tSavze WHERE RECID(tSavze) = ipRecid NO-LOCK.
  397. FIND Savze WHERE RECID(Savze) = tSavze.Zeile NO-LOCK.
  398. iArtZeile = iArtZeile + 1.
  399. DO WHILE Savze.Artnr = 0:
  400. cString = Savze.Bez1.
  401. IF Savze.Bez1 <> '' THEN
  402. DO:
  403. cString = cString
  404. + (IF cString = '' THEN '' ELSE CHR(10))
  405. + Savze.Bez2.
  406. END.
  407. CREATE tDokument.
  408. ASSIGN
  409. tDokument.cGruppe = 'ArtikelZeile1'
  410. tDokument.iZeile = iArtZeile
  411. tDokument.cFeld = 'Bez1'
  412. tDokument.cInhalt = cString.
  413. RETURN.
  414. END.
  415. FIND Artst OF Savze NO-LOCK.
  416. FIND GGebinde NO-LOCK
  417. WHERE GGebinde.Firma = cFirma
  418. AND GGebinde.Geb_Cd = Savze.GGeb_Cd NO-ERROR.
  419. FIND VGebinde NO-LOCK
  420. WHERE VGebinde.Firma = cFirma
  421. AND VGebinde.Geb_Cd = Savze.VGeb_Cd NO-ERROR.
  422. FIND KGebinde NO-LOCK
  423. WHERE KGebinde.Firma = cFirma
  424. AND KGebinde.Geb_Cd = Savze.KGeb_Cd NO-ERROR.
  425. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Artnr' , STRING(Savze.Artnr ,"999999") ).
  426. IF Savze.VGeb_Me <> 0 THEN
  427. DO:
  428. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Menge_VGeb', TRIM(STRING(Savze.VGeb_Me,'->>>>>9')) ).
  429. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'VGebinde' , VGebinde.KBez ).
  430. END.
  431. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'KGebinde', KGebinde.Kbez ).
  432. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Menge' , TRIM(STRING(Savze.MGeli,'->>,>>9')) ).
  433. cString = Savze.Bez1.
  434. IF Savze.Bez2 <> '' THEN
  435. DO:
  436. cString = cString
  437. + (IF cString = '' THEN '' ELSE CHR(10))
  438. + Savze.Bez2.
  439. END.
  440. IF Savze.Aktion THEN
  441. DO:
  442. cString = cString
  443. + (IF cString = '' THEN '' ELSE CHR(10))
  444. + '\b ' + Savze.Aktion_Text + ' \b0'.
  445. END.
  446. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', cString ).
  447. IF Savze.Alk_Gehalt <> 0 THEN
  448. DO:
  449. cString = STRING(Savze.Alk_Gehalt,"zz9.9%").
  450. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Alk%', cString ).
  451. END.
  452. IF Savze.Jahr > 9 THEN
  453. DO:
  454. cString = STRING(Savze.Jahr,"9999").
  455. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'JG', cString ).
  456. END.
  457. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis' , STRING(Savze.Preis ,'>,>>9.99') ).
  458. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', STRING(Savze.Bru_Betr,'->>>,>>9.99') ).
  459. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'MC' , STRING(Savze.WuCd ,'z9') ).
  460. IF Savze.Rab_Betr <> 0 THEN
  461. DO:
  462. iArtZeile = iArtZeile + 1.
  463. nRabWert = ABSOLUTE(Savze.Rab_Wert).
  464. IF Savze.Rab_Art = 3 THEN xRabText = cEpzText.
  465. ELSE
  466. DO:
  467. IF Savze.Rab_Betr < 0 THEN xRabText = cZusText.
  468. IF Savze.Rab_Betr > 0 THEN xRabText = cRabText.
  469. END.
  470. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', TRIM(xRabText) ).
  471. IF Savze.Rab_Art = 1 THEN cString = STRING(nRabWert,"->9.9%").
  472. IF Savze.Rab_Art = 2 OR
  473. Savze.Rab_Art = 3 THEN cString = STRING(nRabWert,"-9.99").
  474. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis', cString ).
  475. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(- Savze.Rab_Betr,"->>>,>>9.99")) ).
  476. END.
  477. DO WHILE TRUE:
  478. IF Savze.Zus_Betr = 0 THEN LEAVE.
  479. iArtZeile = iArtZeile + 1.
  480. nRabWert = ABSOLUTE(Savze.Zus_Wert).
  481. IF Savze.Zus_Art = 3 THEN xRabText = cEpzText.
  482. ELSE
  483. DO:
  484. IF Savze.Zus_Betr < 0 THEN xRabText = cRabText.
  485. IF Savze.Zus_Betr > 0 THEN xRabText = cZusText.
  486. END.
  487. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', TRIM(xRabText) ).
  488. IF Savze.Zus_Art = 1 THEN cString = STRING(nRabWert,"->9.9%").
  489. IF Savze.Zus_Art = 2 OR
  490. Savze.Zus_Art = 3 THEN cString = STRING(nRabWert,"-9.99").
  491. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis', cString ).
  492. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(+ Savze.Zus_Betr,"->>>,>>9.99")) ).
  493. LEAVE.
  494. END.
  495. /* ---- Summengruppen-Total -------------------------------------------- */
  496. IF Savze.Rab_Su_Grp <> 0 THEN
  497. DO:
  498. FIND FIRST TRabSumm WHERE TRabSumm.Rab_Summ = Savze.Rab_Su_Grp NO-ERROR.
  499. IF AVAILABLE TRabSumm THEN
  500. DO:
  501. TRabSumm.Auf_Rab = TRabSumm.Auf_Rab + Savze.Auf_Rab.
  502. TRabSumm.Abh_Rab = TRabSumm.Abh_Rab + Savze.Abh_Rab.
  503. END.
  504. END.
  505. /* ---- Warengruppen-Totale -------------------------------------------- */
  506. FIND FIRST TUmsGrp WHERE TUmsGrp.Ums_Grp = Artst.Wg_Grp
  507. AND TUmsGrp.MWst = Savze.WuCd
  508. AND TUmsGrp.Ansatz = Savze.Mwst% NO-ERROR.
  509. IF NOT AVAILABLE TUmsGrp THEN
  510. DO:
  511. FIND WarenGrp NO-LOCK USE-INDEX WarenGrp-k1
  512. WHERE WarenGrp.Firma = cFirma
  513. AND WarenGrp.Wgr = Artst.Wg_Grp NO-ERROR.
  514. CREATE TUmsGrp.
  515. ASSIGN
  516. TUmsGrp.Ums_Grp = Artst.Wg_Grp
  517. TUmsGrp.Mwst = Savze.WuCd
  518. TUmsGrp.Ansatz = Savze.MWST%
  519. tUmsGrp.lInkl = Savze.MWSt_Inkl.
  520. IF AVAILABLE WarenGrp THEN TUmsGrp.Bez = WarenGrp.Bez1.
  521. ELSE TUmsGrp.Bez = "??????????".
  522. END.
  523. TUmsGrp.Ums_Betr = TUmsGrp.Ums_Betr
  524. + Savze.Net_Betr
  525. - Savze.Auf_Rab
  526. - Savze.Abh_Rab.
  527. END PROCEDURE.
  528. /* _UIB-CODE-BLOCK-END */
  529. &ANALYZE-RESUME
  530. &ENDIF
  531. &IF DEFINED(EXCLUDE-AUFTRAG_ERMITTELN) = 0 &THEN
  532. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE AUFTRAG_ERMITTELN Procedure
  533. PROCEDURE AUFTRAG_ERMITTELN :
  534. /*------------------------------------------------------------------------------
  535. Purpose:
  536. Parameters: <none>
  537. Notes:
  538. ------------------------------------------------------------------------------*/
  539. DEFINE VARIABLE iAufnr AS INTEGER NO-UNDO.
  540. DEFINE BUFFER bDebst FOR Debst.
  541. FIND FIRST tParam.
  542. EMPTY TEMP-TABLE sSavko.
  543. /* Sammeln aller Aufträge pro Sammelnummer */
  544. FOR EACH Savko NO-LOCK USE-INDEX Savko-k5
  545. WHERE Savko.Firma = tParam.cFirma
  546. AND Savko.Faknr = tParam.iFaknr
  547. BREAK BY Savko.Fak_Knr
  548. BY Savko.Samm_Nr
  549. BY Savko.Faknr DESCENDING:
  550. IF NOT FIRST-OF ( Savko.Samm_Nr ) THEN NEXT.
  551. IF tParam.iVerband <> 999999 THEN
  552. DO:
  553. FIND bDebst NO-LOCK
  554. WHERE bDebst.Firma = Savko.Firma
  555. AND bDebst.Knr = Savko.Fak_Knr NO-ERROR.
  556. IF NOT AVAILABLE bDebst THEN NEXT.
  557. IF bDebst.Verband_Grp <> tParam.iVerband THEN NEXT.
  558. RELEASE bDebst.
  559. END.
  560. CREATE sSavko.
  561. ASSIGN
  562. sSavko.cFirma = Savko.Firma
  563. sSavko.iAufnr = Savko.Aufnr
  564. sSavko.iFak_Knr = Savko.Fak_Knr
  565. sSavko.iKnr = Savko.Knr
  566. sSavko.iSamm_Nr = Savko.Samm_Nr
  567. sSavko.iRecid = RECID(Savko)
  568. sSavko.iFaknr = Savko.Faknr
  569. tParam.dFakDatum = Savko.Fak_Datum.
  570. END.
  571. END PROCEDURE.
  572. /* _UIB-CODE-BLOCK-END */
  573. &ANALYZE-RESUME
  574. &ENDIF
  575. &IF DEFINED(EXCLUDE-AUSGABE_ARTIKELZEILE) = 0 &THEN
  576. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE AUSGABE_ARTIKELZEILE Procedure
  577. PROCEDURE AUSGABE_ARTIKELZEILE :
  578. /*------------------------------------------------------------------------------
  579. Purpose:
  580. Parameters: <none>
  581. Notes:
  582. ------------------------------------------------------------------------------*/
  583. DEFINE VARIABLE cZellen AS CHARACTER NO-UNDO.
  584. DEFINE VARIABLE cWerte AS CHARACTER NO-UNDO.
  585. DEFINE VARIABLE iPos AS INTEGER NO-UNDO.
  586. FOR EACH tDokument
  587. WHERE tDokument.cGruppe = 'ArtikelZeile1'
  588. BREAK BY tDokument.cGruppe
  589. BY tDokument.iZeile:
  590. IF FIRST-OF ( tDokument.cGruppe ) THEN
  591. DO:
  592. iVPagePos = vpr_getPageVPos() + 20.
  593. RUN vpr_setPageVPos ( iVPagePos ).
  594. RUN vpr_setGroupVPos ( 'ArtikelZeile1', iVPagePos ).
  595. END.
  596. IF FIRST-OF ( tDokument.iZeile ) THEN
  597. DO:
  598. cZellen = ''.
  599. cWerte = ''.
  600. END.
  601. IF tDokument.cFeld = 'Bez1' THEN
  602. DO:
  603. tDokument.cInhalt = REPLACE(tDokument.cInhalt, CHR(10), ' \par ') NO-ERROR.
  604. END.
  605. cWerte = cWerte
  606. + (IF cWerte = '' THEN '' ELSE CHR(01))
  607. + tDokument.cInhalt.
  608. cZellen = cZellen
  609. + (IF cZellen = '' THEN '' ELSE ',')
  610. + tDokument.cFeld.
  611. IF NOT LAST-OF ( tDokument.iZeile ) THEN NEXT.
  612. RUN vpr_SetDelimiter (CHR(01)).
  613. RUN vpr_setGroupText ('ArtikelZeile1', cZellen, cWerte).
  614. iVPagePos = vpr_getPageVPos().
  615. iPos = iVPagePos + vpr_getGroupHeight('ArtikelZeile1').
  616. IF iPos > iMaxPos THEN
  617. DO:
  618. RUN VIPER_NEUE_SEITE.
  619. RUN DRUCKEN_ADRESSE.
  620. iVPagePos = vpr_getPageVPos() + 20.
  621. RUN vpr_setPageVPos ( iVPagePos ).
  622. RUN vpr_setGroupText ('ArtikelZeile1', cZellen, cWerte).
  623. END.
  624. RUN vpr_FlushGroup ('ArtikelZeile1').
  625. iVPagePos = vpr_getPageVPos().
  626. IF LAST-OF ( tDokument.cGruppe ) THEN LEAVE.
  627. iVPagePos = vpr_getPageVPos().
  628. RUN vpr_setGroupVPos ( 'ArtikelZeile1', iVPagePos ).
  629. END.
  630. FOR EACH tDokument
  631. WHERE tDokument.cGruppe = 'ArtikelZeile1':
  632. DELETE tDokument.
  633. END.
  634. END PROCEDURE.
  635. /* _UIB-CODE-BLOCK-END */
  636. &ANALYZE-RESUME
  637. &ENDIF
  638. &IF DEFINED(EXCLUDE-AUSGABE_GRUPPE) = 0 &THEN
  639. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE AUSGABE_GRUPPE Procedure
  640. PROCEDURE AUSGABE_GRUPPE :
  641. /*------------------------------------------------------------------------------
  642. Purpose:
  643. Parameters: <none>
  644. Notes:
  645. ------------------------------------------------------------------------------*/
  646. DEFINE INPUT PARAMETER ipGruppe AS CHARACTER NO-UNDO.
  647. DEFINE VARIABLE cZellen AS CHARACTER NO-UNDO.
  648. DEFINE VARIABLE cWerte AS CHARACTER NO-UNDO.
  649. DEFINE VARIABLE iSpace AS INTEGER NO-UNDO.
  650. iSpace = vpr_getPageVPos().
  651. FOR EACH tDokument NO-LOCK
  652. WHERE tDokument.cGruppe = ipGruppe
  653. BREAK BY tDokument.cGruppe
  654. BY tDokument.iZeile:
  655. IF FIRST-OF ( tDokument.iZeile ) THEN iSpace = iSpace + 40.
  656. END.
  657. IF iSpace > iMaxPos THEN
  658. DO:
  659. RUN vpr_NewPage.
  660. RUN vpr_InitGroups('').
  661. /* IF tParam.lCreatePDF THEN RUN vpr_initGraphObj.*/
  662. RUN vpr_initGraphObj.
  663. iSeite = iSeite + 1.
  664. RUN DRUCKEN_ADRESSE.
  665. END.
  666. iVPagePos = vpr_getPageVPos().
  667. CASE ipGruppe:
  668. WHEN 'Gebindeabrechnung' THEN
  669. DO:
  670. iVPagePos = iVPagePos + 20.
  671. RUN vpr_setGroupVPos ( 'GebindeabrechnungTitel', iVPagePos ).
  672. RUN vpr_FlushGroup ( 'GebindeabrechnungTitel').
  673. iVPagePos = vpr_getPageVPos().
  674. END.
  675. OTHERWISE
  676. DO:
  677. END.
  678. END CASE.
  679. FOR EACH tDokument
  680. WHERE tDokument.cGruppe = ipGruppe
  681. BREAK BY tDokument.cGruppe
  682. BY tDokument.iZeile:
  683. IF FIRST-OF ( tDokument.cGruppe ) THEN
  684. DO:
  685. IF ipGruppe <> 'Kondition' AND
  686. ipGruppe <> 'BESR' AND
  687. ipGruppe <> 'ADRESSE' THEN
  688. DO:
  689. iVPagePos = vpr_getPageVPos().
  690. RUN vpr_setGroupVPos ( ipGruppe, iVPagePos ).
  691. END.
  692. END.
  693. IF FIRST-OF ( tDokument.iZeile ) THEN
  694. DO:
  695. cZellen = ''.
  696. cWerte = ''.
  697. END.
  698. cWerte = cWerte
  699. + tDokument.cInhalt.
  700. cZellen = cZellen
  701. + tDokument.cFeld.
  702. IF NOT LAST-OF ( tDokument.iZeile ) THEN
  703. DO:
  704. ASSIGN
  705. cWerte = cWerte + CHR(01)
  706. cZellen = cZellen + ','.
  707. NEXT.
  708. END.
  709. RUN vpr_SetDelimiter (CHR(01)).
  710. RUN vpr_setGroupText (ipGruppe, cZellen, cWerte).
  711. RUN vpr_FlushGroup (ipGruppe).
  712. END.
  713. FOR EACH tDokument
  714. WHERE tDokument.cGruppe = ipGruppe:
  715. DELETE tDokument.
  716. END.
  717. END PROCEDURE.
  718. /* _UIB-CODE-BLOCK-END */
  719. &ANALYZE-RESUME
  720. &ENDIF
  721. &IF DEFINED(EXCLUDE-DRUCKEN) = 0 &THEN
  722. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DRUCKEN Procedure
  723. PROCEDURE DRUCKEN :
  724. /*------------------------------------------------------------------------------
  725. Purpose:
  726. Parameters: <none>
  727. Notes:
  728. ------------------------------------------------------------------------------*/
  729. DEFINE VARIABLE xString AS CHARACTER NO-UNDO.
  730. DEFINE VARIABLE cLAdresse AS CHARACTER NO-UNDO.
  731. DEFINE VARIABLE RText AS CHARACTER NO-UNDO.
  732. DEFINE VARIABLE WText AS CHARACTER NO-UNDO.
  733. DEFINE VARIABLE ii AS INTEGER NO-UNDO.
  734. DEFINE VARIABLE i1 AS INTEGER NO-UNDO.
  735. DEFINE VARIABLE nRabWert AS DECIMAL NO-UNDO.
  736. DEFINE VARIABLE iMwstCd AS INTEGER NO-UNDO.
  737. DEFINE VARIABLE nZeiTot AS DECIMAL DECIMALS 4 NO-UNDO.
  738. FIND FIRST tParam.
  739. nFakBetr = 0.
  740. IF iSeite = 0 THEN RUN VIPER_INIT.
  741. FIND bDebst NO-LOCK
  742. WHERE bDebst.Firma = bSavko.Firma
  743. AND bDebst.Knr = bSavko.Fak_Knr.
  744. iBesrArt = bDebst.BESR_Art.
  745. RUN DRUCKEN_KOPF.
  746. iVPagePos = vpr_getPageVPos().
  747. RUN vpr_setGroupVPos ( 'FetteZeile', iVPagePos ).
  748. iArtZeile = 1.
  749. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_LSText', ' ' ).
  750. xString = TRIM(SUBSTRING(cFormText[17],21,20)) + ' / '
  751. + TRIM(SUBSTRING(cFormText[19],01,20)) + ' '
  752. + TRIM(STRING(bSavko.Aufnr,"zzzzzzzzz9")) + ' / '
  753. + TRIM(STRING(bSavko.Lief_Datum,"99.99.9999")).
  754. iArtZeile = 2.
  755. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_LSText', xString ).
  756. DO WHILE TRUE:
  757. lFirst = TRUE.
  758. cLAdresse = ''.
  759. IF bSavko.Knr = bSavko.Fak_Knr AND
  760. NOT FDebst.Passant THEN LEAVE.
  761. iArtZeile = iArtZeile + 1.
  762. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_LSText', ' ' ).
  763. DO ii = 1 TO 5:
  764. IF bSavko.Adresse[ii] = '' THEN NEXT.
  765. iArtZeile = iArtZeile + 1.
  766. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_LSText', bSavko.Adresse[ii] ).
  767. lFirst = FALSE.
  768. END.
  769. IF NOT lFirst THEN LEAVE.
  770. IF bSavko.Knr = bSavko.Fak_Knr THEN LEAVE.
  771. FIND LAdresse NO-LOCK
  772. WHERE LAdresse.Firma = AdFirma
  773. AND LAdresse.Knr = bSavko.Knr NO-ERROR.
  774. IF NOT AVAILABLE LAdresse THEN LEAVE.
  775. DO ii = 1 TO 12:
  776. IF LAdresse.Anschrift[ii] = '' THEN NEXT.
  777. iArtZeile = iArtZeile + 1.
  778. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_LSText', LAdresse.Anschrift[ii] ).
  779. lFirst = FALSE.
  780. END.
  781. LEAVE.
  782. END.
  783. IF NOT lFirst THEN
  784. DO:
  785. iArtZeile = iArtZeile + 1.
  786. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_LSText', ' ' ).
  787. END.
  788. RUN AUSGABE_GRUPPE ( 'FetteZeile' ).
  789. iArtZeile = 0.
  790. FOR EACH tSavze NO-LOCK
  791. BY tSavze.Aufnr
  792. BY tSavze.Sort1
  793. BY tSavze.LagOrt
  794. BY tSavze.Sort2
  795. BY tSavze.Pos :
  796. FIND Savze NO-LOCK WHERE RECID(Savze) = tSavze.Zeile.
  797. RUN ARTIKELZEILE ( RECID(tSavze) ).
  798. nFakBetr = nFakBetr + Savze.Net_Betr.
  799. RELEASE Savze.
  800. END.
  801. RUN AUSGABE_ARTIKELZEILE.
  802. iArtZeile = iArtZeile + 1.
  803. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_1_Fett' , TRIM(SUBSTRING(cFormText[10],41,20)) ).
  804. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Betrag_Fett', TRIM(STRING(nFakBetr,'->>>,>>9.99')) ).
  805. iArtZeile = iArtZeile + 1.
  806. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_1_Fett' , ' ' ).
  807. RUN AUSGABE_GRUPPE ( 'FetteZeile' ).
  808. /* Auftragsrabatt ---------------------------------------------------- */
  809. iArtZeile = 0.
  810. FOR EACH tRabSumm
  811. WHERE tRabSumm.Auf_Rab <> 0
  812. BY tRabSumm.Rab_Summ:
  813. Rundbetr = tRabSumm.Auf_Rab.
  814. nFakBetr = nFakBetr - Rundbetr.
  815. IF Rundbetr < 0 THEN RText = cZusText.
  816. ELSE RText = cRabText.
  817. xString = RText
  818. + " "
  819. + tRabSumm.Bez.
  820. iArtZeile = iArtZeile + 1.
  821. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', xString ).
  822. FIND FIRST SavRabSu NO-LOCK USE-INDEX SavRabSu-k1
  823. WHERE SavRabSu.Firma = bSavko.Firma
  824. AND SavRabSu.Aufnr = bSavko.Aufnr
  825. AND SavRabSu.Rab_Summ = tRabSumm.Rab_Summ.
  826. nRabWert = ABSOLUT(SavRabSu.F_Wert).
  827. IF SavRabSu.F_Proz_Betr THEN WText = "%".
  828. ELSE WText = "Fr.".
  829. xString = STRING(nRabWert,"z9.99-")
  830. + WText.
  831. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis', xString ).
  832. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(- Rundbetr,'->>>,>>9.99')) ).
  833. END.
  834. /* Abholrabatt ------------------------------------------------------- */
  835. FOR EACH tRabSumm WHERE tRabSumm.Abh_Rab <> 0
  836. BY tRabSumm.Rab_Summ:
  837. Rundbetr = tRabSumm.Abh_Rab.
  838. nFakBetr = nFakBetr - Rundbetr.
  839. IF Rundbetr < 0 THEN RText = cZusText.
  840. ELSE RText = cRabText.
  841. xString = RText
  842. + " "
  843. + tRabSumm.Bez.
  844. iArtZeile = iArtZeile + 1.
  845. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', xString ).
  846. FIND FIRST SavRabSu NO-LOCK USE-INDEX SavRabSu-k1
  847. WHERE SavRabSu.Firma = bSavko.Firma
  848. AND SavRabSu.Aufnr = bSavko.Aufnr
  849. AND SavRabSu.Rab_Summ = tRabSumm.Rab_Summ.
  850. nRabWert = ABSOLUT(SavRabSu.A_Wert).
  851. IF SavRabSu.A_Proz_Betr THEN WText = "%".
  852. ELSE WText = "Fr.".
  853. xString = STRING(nRabWert,"z9.99-")
  854. + WText.
  855. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis', xString ).
  856. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(- Rundbetr,'->>>,>>9.99')) ).
  857. END.
  858. /* Spezialpreis-Auftragsrabatte ---------------------------------------- */
  859. FOR EACH tSpeRab WHERE tSpeRab.Auf_Betr <> 0
  860. BY tSpeRab.Rab_Grp:
  861. FIND Tabel USE-INDEX Tabel-k1
  862. WHERE Tabel.Firma = cFirma
  863. AND Tabel.RecArt = 'ARABGRP'
  864. AND Tabel.CodeC = ''
  865. AND Tabel.CodeI = tSpeRab.Rab_Grp
  866. AND Tabel.Sprcd = 1 NO-LOCK.
  867. Rundbetr = tSpeRab.Auf_Betr.
  868. nFakBetr = nFakBetr - Rundbetr.
  869. IF Rundbetr < 0 THEN RText = cZusText.
  870. ELSE RText = cRabText.
  871. xString = RText
  872. + " "
  873. + Tabel.Bez1.
  874. iArtZeile = iArtZeile + 1.
  875. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', xString ).
  876. FIND FIRST SavSpRab USE-INDEX SavSpRab-k1
  877. WHERE SavSpRab.Firma = bSavko.Firma
  878. AND SavSpRab.Aufnr = bSavko.Aufnr
  879. AND SavSpRab.Rab_Grp = tSpeRab.Rab_Grp NO-LOCK.
  880. nRabWert = ABSOLUT(SavSpRab.Auf_Wert).
  881. IF SavSpRab.Auf_Proz_Betr THEN WText = "%".
  882. ELSE WText = "Fr.".
  883. xString = STRING(nRabWert,"z9.99-")
  884. + WText.
  885. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis', xString ).
  886. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(- Rundbetr,'->>>,>>9.99')) ).
  887. END.
  888. IF iArtZeile > 0 THEN
  889. DO:
  890. iArtZeile = iArtZeile + 1.
  891. xString = TRIM(SUBSTRING(cFormText[14],21,20)).
  892. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', xString ).
  893. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(nFakBetr,'->>>,>>9.99')) ).
  894. iArtZeile = iArtZeile + 1.
  895. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', ' ' ).
  896. END.
  897. RUN AUSGABE_GRUPPE ('ArtikelZeile1').
  898. /* Recycling-Gebuehren ----------------------------------------------- */
  899. iArtZeile = 0.
  900. FOR EACH SavGKon USE-INDEX SavGKon-k1
  901. WHERE SavGKon.Firma = bSavko.Firma
  902. AND SavGKon.Aufnr = bSavko.Aufnr
  903. AND SavGKon.Gebuehr <> 0
  904. AND SavGKon.Betrag <> 0 NO-LOCK:
  905. FIND GebKonto OF SavGKon NO-LOCK NO-ERROR.
  906. IF NOT AVAILABLE GebKonto THEN xString = TRIM(SUBSTRING(cFormText[11],41,20)).
  907. ELSE xString = GebKonto.Bez.
  908. iMwstCd = SavGKon.MWST_Cd.
  909. nFakBetr = nFakBetr + SavGKon.Betrag.
  910. FIND LAST MwstAns NO-LOCK
  911. WHERE MwstAns.Mwst_Cd = iMwstCd
  912. AND MwstAns.Datum <= bSavko.Fak_Datum NO-ERROR.
  913. iArtZeile = iArtZeile + 1.
  914. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', xString ).
  915. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(SavGKon.Betrag,'->>>,>>9.99')) ).
  916. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'MC', STRING(SavGKon.MWSt_Cd,'z9') ).
  917. FIND FIRST tUmsGrp
  918. WHERE tUmsGrp.Ums_Grp = 1000
  919. AND tUmsGrp.Mwst = iMwstCd
  920. AND tUmsGrp.Ansatz = MwstAns.Ansatz NO-ERROR.
  921. IF NOT AVAILABLE tUmsGrp THEN
  922. DO:
  923. FIND WarenGrp USE-INDEX WarenGrp-k1
  924. WHERE WarenGrp.Firma = cFirma
  925. AND WarenGrp.Wgr = 1000 NO-LOCK NO-ERROR.
  926. CREATE tUmsGrp.
  927. ASSIGN
  928. tUmsGrp.Ums_Grp = 1000
  929. tUmsGrp.Mwst = iMwstCd
  930. tUmsGrp.Ansatz = MwstAns.Ansatz
  931. tUmsGrp.lInkl = lDebIncl
  932. tUmsGrp.Bez = (IF AVAILABLE WarenGrp THEN WarenGrp.Bez1 ELSE 'Recyclinggebühren').
  933. END.
  934. tUmsGrp.Ums_Betr = tUmsGrp.Ums_Betr + SavGKon.Betrag.
  935. END.
  936. IF iArtZeile > 0 THEN
  937. DO:
  938. iArtZeile = iArtZeile + 1.
  939. xString = TRIM(SUBSTRING(cFormText[14],41,20)).
  940. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', xString ).
  941. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(nFakBetr,'->>>,>>9.99')) ).
  942. iArtZeile = iArtZeile + 1.
  943. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', ' ' ).
  944. END.
  945. RELEASE SavGKon.
  946. RUN AUSGABE_GRUPPE ('ArtikelZeile1').
  947. /* Gebindelieferungen ------------------------------------------------ */
  948. nZeiTot = 0.
  949. iArtZeile = 0.
  950. FOR EACH SavGKon USE-INDEX SavGKon-k1
  951. WHERE SavGKon.Firma = bSavko.Firma
  952. AND SavGKon.Aufnr = bSavko.Aufnr
  953. AND SavGKon.Depot <> 0
  954. AND (SavGKon.Eingang <> 0 OR
  955. SavGKon.Ausgang <> 0) NO-LOCK:
  956. iMwstCd = SavGKon.MWSt_Cd.
  957. FIND LAST MwstAns NO-LOCK
  958. WHERE MwstAns.Mwst_Cd = iMwstCd
  959. AND MwstAns.Datum <= bSavko.Fak_Datum NO-ERROR.
  960. FIND FIRST tUmsGrp
  961. WHERE tUmsGrp.Ums_Grp = 1001
  962. AND tUmsGrp.Mwst = iMwstCd
  963. AND tUmsGrp.Ansatz = MwstAns.Ansatz NO-ERROR.
  964. IF NOT AVAILABLE tUmsGrp THEN
  965. DO:
  966. FIND WarenGrp NO-LOCK USE-INDEX WarenGrp-k1
  967. WHERE WarenGrp.Firma = cFirma
  968. AND WarenGrp.Wgr = 1001 NO-ERROR.
  969. CREATE tUmsGrp.
  970. ASSIGN
  971. tUmsGrp.Ums_Grp = 1001
  972. tUmsGrp.Mwst = iMwstCd
  973. tUmsGrp.Ansatz = MwstAns.Ansatz
  974. tUmsGrp.lInkl = lDebIncl
  975. tUmsGrp.Bez = (IF AVAILABLE WarenGrp THEN WarenGrp.Bez1 ELSE 'Gebindesaldo').
  976. END.
  977. tUmsGrp.Ums_Betr = tUmsGrp.Ums_Betr + SavGKon.Betrag.
  978. FIND GebKonto NO-LOCK USE-INDEX GebKonto-k1
  979. WHERE GebKonto.Firma = cFirma
  980. AND GebKonto.Geb_Cd = SavGKon.Geb_Cd.
  981. i1 = SavGKon.Ausgang - SavGKon.Eingang.
  982. Rundbetr = SavGKon.Betrag.
  983. nZeiTot = nZeiTot + Rundbetr.
  984. iArtZeile = iArtZeile + 1.
  985. RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'Gebindetext' , GebKonto.Bez ).
  986. RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'GebindeGel' , TRIM(STRING(SavGKon.Ausgang,"->>,>>9")) ).
  987. RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'GebindeRet' , TRIM(STRING(SavGKon.Eingang,"->>,>>9")) ).
  988. RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'GebindeSaldo', TRIM(STRING(i1 ,"->>,>>9")) ).
  989. RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'GebindeBetr' , TRIM(STRING(Rundbetr ,"->>,>>9.99")) ).
  990. RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'MC' , TRIM(STRING(SavGKon.MWSt_Cd,"z9")) ).
  991. END.
  992. IF iArtZeile > 0 THEN RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'GebindeTot' , TRIM(STRING(nZeiTot,"->>,>>9.99")) ).
  993. nFakBetr = nFakBetr + nZeiTot.
  994. IF iArtZeile > 0 THEN RUN AUSGABE_GRUPPE ('Gebindeabrechnung').
  995. FIND FIRST tTotale.
  996. DO ii = 1 TO 12:
  997. tTotale.nMwstPfl[ii] = tTotale.nMwstPfl[ii] + bSavko.Wpfl[ii].
  998. tTotale.nMwstBet[ii] = tTotale.nMwstBet[ii] + bSavko.Wust[ii].
  999. END.
  1000. tTotale.nSammTot = tTotale.nSammTot + nFakBetr.
  1001. tTotale.nSkBer = tTotale.nSkBer + bSavko.Sk_Ber.
  1002. iArtZeile = 1.
  1003. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_1_Fett' , TRIM(SUBSTRING(cFormText[15],21,20)) ).
  1004. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Betrag_Fett', TRIM(STRING(nFakBetr,"->>>,>>9.99")) ).
  1005. IF lLast THEN
  1006. DO:
  1007. iArtZeile = iArtZeile + 1.
  1008. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_1_Fett' , ' ' ).
  1009. iArtZeile = iArtZeile + 1.
  1010. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_1_Fett' , TRIM(SUBSTRING(cFormText[14],01,20)) ).
  1011. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Betrag_Fett', TRIM(STRING(tTotale.nSammTot,"->>>,>>9.99")) ).
  1012. END.
  1013. iArtZeile = iArtZeile + 1.
  1014. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_1_Fett' , ' ' ).
  1015. RUN AUSGABE_GRUPPE ( 'FetteZeile' ).
  1016. IF lLast THEN RUN DRUCKEN_ENDE.
  1017. END PROCEDURE.
  1018. /* _UIB-CODE-BLOCK-END */
  1019. &ANALYZE-RESUME
  1020. &ENDIF
  1021. &IF DEFINED(EXCLUDE-DRUCKEN_ADRESSE) = 0 &THEN
  1022. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DRUCKEN_ADRESSE Procedure
  1023. PROCEDURE DRUCKEN_ADRESSE :
  1024. /*------------------------------------------------------------------------------
  1025. Purpose:
  1026. Parameters: <none>
  1027. Notes:
  1028. ------------------------------------------------------------------------------*/
  1029. DEFINE VARIABLE cZellen AS CHARACTER NO-UNDO.
  1030. DEFINE VARIABLE cWerte AS CHARACTER NO-UNDO.
  1031. FIND FIRST tParam.
  1032. FIND FIRST tDokument
  1033. WHERE tDokument.cGruppe = 'KOPF'
  1034. AND tDokument.iZeile = 1
  1035. AND tDokument.cFeld = 'Seite' NO-ERROR.
  1036. IF NOT AVAILABLE tDokument THEN
  1037. DO:
  1038. CREATE tDokument.
  1039. ASSIGN
  1040. tDokument.cGruppe = 'KOPF'
  1041. tDokument.iZeile = 1
  1042. tDokument.cFeld = 'Seite'.
  1043. END.
  1044. tDokument.cInhalt = STRING(iSeite,'z9').
  1045. cZellen = ''.
  1046. cWerte = ''.
  1047. FOR EACH tDokument
  1048. WHERE tDokument.cGruppe = 'Kopf'
  1049. BREAK BY tDokument.cGruppe
  1050. BY tDokument.cFeld:
  1051. cWerte = cWerte
  1052. + tDokument.cInhalt.
  1053. cZellen = cZellen
  1054. + tDokument.cFeld.
  1055. IF NOT LAST-OF ( tDokument.cGruppe ) THEN ASSIGN cWerte = cWerte + CHR(01)
  1056. cZellen = cZellen + ','.
  1057. END.
  1058. RUN vpr_SetDelimiter (CHR(01)).
  1059. RUN vpr_setGroupText ('Kopf', cZellen, cWerte).
  1060. RUN vpr_FlushGroup ('Kopf').
  1061. RUN vpr_FlushGroup ('Ueberschrift').
  1062. END PROCEDURE.
  1063. /* _UIB-CODE-BLOCK-END */
  1064. &ANALYZE-RESUME
  1065. &ENDIF
  1066. &IF DEFINED(EXCLUDE-DRUCKEN_BESR) = 0 &THEN
  1067. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DRUCKEN_BESR Procedure
  1068. PROCEDURE DRUCKEN_BESR :
  1069. /*------------------------------------------------------------------------------
  1070. Purpose:
  1071. Parameters: <none>
  1072. Notes:
  1073. ------------------------------------------------------------------------------*/
  1074. DEFINE INPUT PARAMETER ipDokument AS CHARACTER NO-UNDO.
  1075. DEFINE VARIABLE ix AS INTEGER NO-UNDO.
  1076. DEFINE VARIABLE i1 AS INTEGER NO-UNDO.
  1077. DEFINE VARIABLE cFeld AS CHARACTER NO-UNDO.
  1078. DEFINE VARIABLE cInhalt AS CHARACTER NO-UNDO.
  1079. DEFINE VARIABLE cVorlage AS CHARACTER NO-UNDO.
  1080. DEFINE VARIABLE iKopfZeile AS INTEGER NO-UNDO.
  1081. DEFINE VARIABLE PZBetrag AS CHARACTER NO-UNDO.
  1082. DEFINE VARIABLE PZReferenz AS CHARACTER NO-UNDO.
  1083. DEFINE VARIABLE PZTNNummer AS CHARACTER NO-UNDO.
  1084. DEFINE VARIABLE cReferenz AS CHARACTER NO-UNDO.
  1085. FIND FIRST tParam.
  1086. /* IF Rundbetr < 0 THEN RETURN. */
  1087. RUN vpr_NewPage.
  1088. cVorlage = tParam.cInstall + '/' + ipDokument + '.vfr'.
  1089. RUN vpr_LoadVFR (cVorlage).
  1090. RUN vpr_ActivateReport (ipDokument).
  1091. RUN vpr_setPrinterAttrib("duplex=1").
  1092. RUN vpr_SetDocAttrib ("PAPERSIZE=A4").
  1093. RUN vpr_SetPrinterAttrib("copies=1").
  1094. RUN vpr_InitGroups ("").
  1095. /* IF tParam.lCreatePDF THEN RUN vpr_initGraphObj.*/
  1096. RUN vpr_initGraphObj.
  1097. IF tParam.Schacht_Besr > 0 THEN RUN vpr_SetCurrentPageProperties ( "Papertray", tParam.Schacht_Besr ).
  1098. RUN vpr_SetGroupAttrib ("ADRESSE", "Fixed=true").
  1099. RUN vpr_SetGroupAttrib ("BESR" , "Fixed=true").
  1100. FIND Adresse NO-LOCK USE-INDEX Adresse-k1
  1101. WHERE Adresse.Firma = AdFirma
  1102. AND Adresse.Knr = bSavko.Fak_Knr NO-ERROR.
  1103. iKopfZeile = 1.
  1104. cBesrKopf = ''.
  1105. IF bSavko.Adresse[05] <> '' THEN
  1106. DO:
  1107. i1 = 6.
  1108. DO ix = 1 TO 5:
  1109. /* CREATE tDokument. */
  1110. /* ASSIGN tDokument.cGruppe = 'ADRESSE' */
  1111. /* tDokument.iZeile = 1 */
  1112. /* tDokument.cFeld = 'Adresse_' + STRING((6 + ix),'99') */
  1113. /* tDokument.cInhalt = bSavko.Adresse[ix]. */
  1114. i1 = i1 + 1.
  1115. cBesrKopf[i1] = bSavko.Adresse[ix].
  1116. END.
  1117. END.
  1118. ELSE
  1119. DO:
  1120. DO ix = 6 TO 11:
  1121. /* CREATE tDokument. */
  1122. /* ASSIGN tDokument.cGruppe = 'ADRESSE' */
  1123. /* tDokument.iZeile = 1 */
  1124. /* tDokument.cFeld = 'Adresse_' + STRING(ix,'99') */
  1125. /* tDokument.cInhalt = Adresse.Anschrift[ix]. */
  1126. cBesrKopf[ix] = Adresse.Anschrift[ix].
  1127. END.
  1128. END.
  1129. DO ix = 6 TO 11:
  1130. CREATE tDokument.
  1131. ASSIGN
  1132. tDokument.cGruppe = 'BESR'
  1133. tDokument.iZeile = 1
  1134. tDokument.cFeld = 'Adresse_R_' + STRING(ix,'99')
  1135. tDokument.cInhalt = cBesrKopf[ix].
  1136. IF ix < 7 THEN NEXT.
  1137. CREATE tDokument.
  1138. ASSIGN
  1139. tDokument.cGruppe = 'BESR'
  1140. tDokument.iZeile = 1
  1141. tDokument.cFeld = 'Adresse_L_' + STRING(ix,'99')
  1142. tDokument.cInhalt = cBesrKopf[ix].
  1143. END.
  1144. IF Rundbetr > 0.00 THEN
  1145. DO:
  1146. cFeld = STRING(Rundbetr,'zzzzzz9.99').
  1147. cFeld = REPLACE(cFeld, '.', ' ').
  1148. cFeld = STRING(cFeld,'X X X X X X X X X X').
  1149. END.
  1150. ELSE cFeld = ''.
  1151. RUN VIPER_CREATE_DOKUMENT ( 'BESR', iKopfZeile, 'Betrag_L', cFeld ).
  1152. RUN VIPER_CREATE_DOKUMENT ( 'BESR', iKopfZeile, 'Betrag_R', cFeld ).
  1153. IF Rundbetr > 0 THEN PZBetrag = '01' + STRING(Rundbetr * 100,'9999999999 ').
  1154. ELSE PZBetrag = ' 04 '.
  1155. PZReferenz = '996665000000'
  1156. + STRING(bSavko.Fak_Knr,'999999')
  1157. + '0'
  1158. + STRING(bSavko.Faknr ,'9999999')
  1159. + ' '.
  1160. PZTNNummer = '01000530'.
  1161. RUN PRUEFZIFFER ( INPUT-OUTPUT PZBetrag, INPUT-OUTPUT PZReferenz, INPUT-OUTPUT PZTNNummer, OUTPUT cReferenz ).
  1162. RUN VIPER_CREATE_DOKUMENT ( 'BESR', iKopfZeile, 'Referenz_OCRB', cReferenz ).
  1163. RUN VIPER_CREATE_DOKUMENT ( 'BESR', iKopfZeile, 'Referenz_R', STRING(PZReferenz,'XX XXXXX XXXXX XXXXX XXXXX XXXXX') ).
  1164. RUN VIPER_CREATE_DOKUMENT ( 'BESR', iKopfZeile, 'Referenz_L', STRING(PZReferenz,'XX XXXXX XXXXX XXXXX XXXXX XXXXX') ).
  1165. RUN AUSGABE_GRUPPE ( 'ADRESSE' ).
  1166. RUN AUSGABE_GRUPPE ( 'BESR' ).
  1167. END PROCEDURE.
  1168. /* _UIB-CODE-BLOCK-END */
  1169. &ANALYZE-RESUME
  1170. &ENDIF
  1171. &IF DEFINED(EXCLUDE-DRUCKEN_ENDE) = 0 &THEN
  1172. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DRUCKEN_ENDE Procedure
  1173. PROCEDURE DRUCKEN_ENDE :
  1174. /*------------------------------------------------------------------------------
  1175. Purpose:
  1176. Parameters: <none>
  1177. Notes:
  1178. ------------------------------------------------------------------------------*/
  1179. DEFINE VARIABLE cPDFName AS CHARACTER INIT '' NO-UNDO.
  1180. DEFINE VARIABLE iSpace AS INTEGER INIT 0 NO-UNDO.
  1181. DEFINE VARIABLE iPos AS INTEGER NO-UNDO.
  1182. DEFINE VARIABLE iKopie AS INTEGER NO-UNDO.
  1183. DEFINE VARIABLE ix AS INTEGER NO-UNDO.
  1184. DEFINE VARIABLE lJa AS LOG NO-UNDO.
  1185. DEFINE VARIABLE nNetto AS DECIMAL NO-UNDO.
  1186. DEFINE VARIABLE nMwst AS DECIMAL NO-UNDO.
  1187. DEFINE VARIABLE nBrutto AS DECIMAL NO-UNDO.
  1188. DEFINE VARIABLE nTNetto AS DECIMAL NO-UNDO.
  1189. DEFINE VARIABLE nTMwst AS DECIMAL NO-UNDO.
  1190. DEFINE VARIABLE nTBrutto AS DECIMAL NO-UNDO.
  1191. FIND FIRST tParam.
  1192. FIND FIRST tTotale.
  1193. iPos = vpr_getPageVPos().
  1194. iArtZeile = 1.
  1195. iSpace = iSpace + 40.
  1196. RUN VIPER_CREATE_DOKUMENT ( 'Mehrwertsteuer', iArtZeile, 'MwstBez' , ' ' ).
  1197. FIND FIRST tTotale.
  1198. DO ix = 1 TO 11:
  1199. IF tTotale.nMwstPfl[ix] = 0 THEN NEXT.
  1200. tTotale.nSammTot = tTotale.nSammTot + tTotale.nMwstBet[ix].
  1201. FIND LAST MWSTAns USE-INDEX MWSTAns-k1
  1202. WHERE MWSTAns.MWST_Cd = ix
  1203. AND MWSTAns.Datum <= bSavko.Kond_Datum NO-LOCK.
  1204. iArtZeile = iArtZeile + 1.
  1205. iSpace = iSpace + 40.
  1206. RUN VIPER_CREATE_DOKUMENT ( 'Mehrwertsteuer', iArtZeile, 'MwstBez' , MWStAns.Bez ).
  1207. RUN VIPER_CREATE_DOKUMENT ( 'Mehrwertsteuer', iArtZeile, 'MwstPfl' , TRIM(STRING(tTotale.nMwstPfl[ix],"->>,>>9.99")) ).
  1208. RUN VIPER_CREATE_DOKUMENT ( 'Mehrwertsteuer', iArtZeile, 'MwstBetr', TRIM(STRING(tTotale.nMwstBet[ix],"->>>,>>9.99")) ).
  1209. RUN VIPER_CREATE_DOKUMENT ( 'Mehrwertsteuer', iArtZeile, 'MwstCd' , TRIM(STRING(ix ,">>9")) ).
  1210. END.
  1211. IF (iSpace + iPos + 80) >= iMaxPos THEN
  1212. DO:
  1213. RUN vpr_NewPage.
  1214. RUN vpr_InitGroups('').
  1215. /* IF tParam.lCreatePDF THEN RUN vpr_initGraphObj.*/
  1216. RUN vpr_initGraphObj.
  1217. iSeite = iSeite + 1.
  1218. RUN DRUCKEN_ADRESSE.
  1219. END.
  1220. RUN AUSGABE_GRUPPE ( 'Mehrwertsteuer' ).
  1221. Rundbetr = tTotale.nSammTot.
  1222. Rundcode = 1.
  1223. RUN RUNDEN ( Rundcode, INPUT-OUTPUT Rundbetr ).
  1224. tTotale.nSammTot = Rundbetr.
  1225. iArtZeile = 1.
  1226. RUN VIPER_CREATE_DOKUMENT ( 'RechnungsTotal', iArtZeile, 'EndBetrag' , TRIM(STRING(tTotale.nSammTot,"->,>>>,>>9.99")) ).
  1227. iArtZeile = 2.
  1228. RUN VIPER_CREATE_DOKUMENT ( 'RechnungsTotal', iArtZeile, 'EndBetrag' , '' ).
  1229. RUN AUSGABE_GRUPPE ( 'RechnungsTotal' ).
  1230. iArtZeile = 1.
  1231. RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_LSText' , TRIM(SUBSTRING(cFormText[15],41,20)) ).
  1232. RUN AUSGABE_GRUPPE ( 'FetteZeile' ).
  1233. ASSIGN
  1234. nTNetto = 0
  1235. nTMwst = 0
  1236. nTBrutto = 0.
  1237. FOR EACH TUmsGrp NO-LOCK
  1238. BY TUmsGrp.Ums_Grp
  1239. BY TUmsGrp.Mwst :
  1240. IF tUmsGrp.lInkl THEN
  1241. DO:
  1242. nNetto = tUmsGrp.Ums_Betr * 100 / (100 + tUmsGrp.Ansatz).
  1243. nBrutto = tUmsGrp.Ums_Betr.
  1244. nMwst = nBrutto - nNetto.
  1245. END.
  1246. ELSE
  1247. DO:
  1248. nNetto = tUmsGrp.Ums_Betr.
  1249. nBrutto = tUmsGrp.Ums_Betr * (100 + tUmsGrp.Ansatz) / 100.
  1250. nMwst = nBrutto - nNetto.
  1251. END.
  1252. ASSIGN
  1253. nTNetto = nTNetto + nNetto
  1254. nTMwst = nTMwst + nMwst
  1255. nTBrutto = nTBrutto + nBrutto.
  1256. iArtZeile = iArtZeile + 1.
  1257. RUN VIPER_CREATE_DOKUMENT ( 'Umsatzverteilung', iArtZeile, 'Umsatzgruppe' , TUmsGrp.Bez ).
  1258. RUN VIPER_CREATE_DOKUMENT ( 'Umsatzverteilung', iArtZeile, 'Frw' , BSteuer.Fwc03 ).
  1259. RUN VIPER_CREATE_DOKUMENT ( 'Umsatzverteilung', iArtZeile, 'Netto' , TRIM(STRING(nNetto ,"->>>,>>9.99")) ).
  1260. RUN VIPER_CREATE_DOKUMENT ( 'Umsatzverteilung', iArtZeile, 'Ansatz' , TRIM(STRING(TUmsGrp.Ansatz,">9.99%")) ).
  1261. RUN VIPER_CREATE_DOKUMENT ( 'Umsatzverteilung', iArtZeile, 'Mwst' , TRIM(STRING(nMwst ,"->>>,>>9.99")) ).
  1262. RUN VIPER_CREATE_DOKUMENT ( 'Umsatzverteilung', iArtZeile, 'Brutto' , TRIM(STRING(nBrutto ,"->>>,>>9.99")) ).
  1263. RUN VIPER_CREATE_DOKUMENT ( 'Umsatzverteilung', iArtZeile, 'MC' , TRIM(STRING(tUmsGrp.Mwst ,"z9")) ).
  1264. END.
  1265. iArtZeile = iArtZeile + 1.
  1266. RUN VIPER_CREATE_DOKUMENT ( 'Umsatzverteilung', iArtZeile, 'Umsatzgruppe' , 'Total' ).
  1267. RUN VIPER_CREATE_DOKUMENT ( 'Umsatzverteilung', iArtZeile, 'Netto' , TRIM(STRING(nTNetto ,"->>>,>>9.99")) ).
  1268. RUN VIPER_CREATE_DOKUMENT ( 'Umsatzverteilung', iArtZeile, 'Mwst' , TRIM(STRING(nTMwst ,"->>>,>>9.99")) ).
  1269. RUN VIPER_CREATE_DOKUMENT ( 'Umsatzverteilung', iArtZeile, 'Brutto' , TRIM(STRING(nTBrutto,"->>>,>>9.99")) ).
  1270. RUN AUSGABE_GRUPPE ( 'Umsatzverteilung' ).
  1271. /* Zahlungskondition ------------------------------------------------- */
  1272. FIND Kondi NO-LOCK USE-INDEX Kondi-k1
  1273. WHERE Kondi.Kond = bSavko.Kond
  1274. AND Kondi.Sprcd = iSprcd NO-ERROR.
  1275. IF AVAILABLE Kondi THEN
  1276. DO:
  1277. iArtZeile = 1.
  1278. RUN VIPER_CREATE_DOKUMENT ( 'Kondition', iArtZeile, 'Zahkond', Kondi.KoText ).
  1279. RUN VIPER_CREATE_DOKUMENT ( 'Kondition', iArtZeile, 'Faellig', STRING((dFakDatum + Kondi.Faellig),"99.99.9999") ).
  1280. IF Kondi.Skonto[01] <> 0 THEN
  1281. DO:
  1282. Rundbetr = tTotale.nSkBer * Kondi.Skonto[01] / 100.
  1283. Rundcode = 1.
  1284. RUN RUNDEN ( Rundcode, INPUT-OUTPUT Rundbetr ).
  1285. RUN VIPER_CREATE_DOKUMENT ( 'Kondition', iArtZeile, 'Skonto', TRIM(STRING(Rundbetr,"->>>,>>9.99")) ).
  1286. END.
  1287. END.
  1288. ELSE
  1289. DO:
  1290. iArtZeile = 1.
  1291. RUN VIPER_CREATE_DOKUMENT ( 'Kondition', iArtZeile, 'Zahkond', FILL('?', 29) ).
  1292. END.
  1293. RUN VIPER_CREATE_DOKUMENT ( 'Kondition', iArtZeile, 'Netto', TRIM(STRING(tTotale.nSammTot,"->>>,>>9.99")) ).
  1294. RUN AUSGABE_GRUPPE ( 'Kondition' ).
  1295. nFakBetr = tTotale.nSammTot.
  1296. IF nFakBetr = 0 THEN Rundbetr = -1.
  1297. ELSE Rundbetr = nFakBetr.
  1298. IF AVAILABLE Kondi AND
  1299. Kondi.Skonto[01] <> 0 THEN Rundbetr = 0.
  1300. /* Abschluss und Druck ----------------------------------------------- */
  1301. IF iLauf < iAnzDok THEN RETURN.
  1302. FIND Bankst NO-LOCK
  1303. WHERE Bankst.Bank = iBESRArt NO-ERROR.
  1304. IF NOT AVAILABLE Bankst THEN
  1305. DO:
  1306. FIND FIRST Bankst NO-ERROR.
  1307. END.
  1308. IF AVAILABLE Bankst AND
  1309. Bankst.QR-IBAN <> '' THEN
  1310. DO:
  1311. FIND FIRST Debop NO-LOCK
  1312. WHERE Debop.Firma = bSavko.Firma
  1313. AND Debop.Knr = bSavko.Fak_Knr
  1314. AND Debop.Faknr = bSavKo.Faknr NO-ERROR.
  1315. FIND FIRST tSavko NO-ERROR.
  1316. IF NOT AVAILABLE tSavko THEN CREATE tSavko.
  1317. BUFFER-COPY bSavko TO tSavko
  1318. ASSIGN
  1319. tSavko.Auf_Tot = (IF AVAILABLE Debop THEN Debop.Fakbetr ELSE Rundbetr)
  1320. tSavko.lBetrag = TRUE.
  1321. RUN vpr_newPage.
  1322. RUN DRUCKEN_QRCODE.
  1323. END.
  1324. ELSE
  1325. DO:
  1326. RUN DRUCKEN_BESR ( 'BESR' ).
  1327. END.
  1328. /* ------------------------------------------------------ */
  1329. /* Druckausgabe */
  1330. /* ------------------------------------------------------ */
  1331. RUN vpr_EndDoc.
  1332. cvpr_Dokument = SUBSTITUTE(cERPDokumente,
  1333. cInstallation,
  1334. 'Rechnungen',
  1335. STRING(bSavko.Knr ,'999999'),
  1336. STRING(bSavko.Faknr,'9999999'),
  1337. tParam.cDokument ).
  1338. RUN vpr_SaveDoc ( cvpr_Dokument ).
  1339. DO WHILE tParam.lDokDruck:
  1340. SESSION:PRINTER-NAME = tParam.Drucker NO-ERROR.
  1341. IF SESSION:PRINTER-NAME <> tParam.Drucker THEN
  1342. DO:
  1343. RUN vpr_printerDialog ( OUTPUT lJa ).
  1344. IF NOT lJa THEN LEAVE.
  1345. END.
  1346. RUN vpr_printDoc (0, 0).
  1347. LEAVE.
  1348. END.
  1349. IF tParam.lCreatePDF THEN
  1350. DO:
  1351. cPDFName = REPLACE(cvpr_Dokument, '.vpr', '.pdf').
  1352. RUN vpr_printPDF (0, 0, INPUT-OUTPUT cPDFName ).
  1353. END.
  1354. IF tParam.lOpenPDF THEN
  1355. DO:
  1356. DEFINE VARIABLE o-i AS i NO-UNDO.
  1357. FILE-INFO:FILE-NAME = cPDFName.
  1358. cPDFName = FILE-INFO:FULL-PATHNAME.
  1359. RUN shellExecuteA (0,
  1360. "open",
  1361. cPDFName,
  1362. "",
  1363. "",
  1364. 0,
  1365. OUTPUT o-i).
  1366. END.
  1367. END PROCEDURE.
  1368. /* _UIB-CODE-BLOCK-END */
  1369. &ANALYZE-RESUME
  1370. &ENDIF
  1371. &IF DEFINED(EXCLUDE-DRUCKEN_KOPF) = 0 &THEN
  1372. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DRUCKEN_KOPF Procedure
  1373. PROCEDURE DRUCKEN_KOPF :
  1374. /*------------------------------------------------------------------------------
  1375. Purpose:
  1376. Parameters: <none>
  1377. Notes:
  1378. ------------------------------------------------------------------------------*/
  1379. DEFINE VARIABLE cString AS CHARACTER NO-UNDO.
  1380. DEFINE VARIABLE ii AS INTEGER NO-UNDO.
  1381. DEFINE VARIABLE i1 AS INTEGER NO-UNDO.
  1382. DEFINE VARIABLE iOldSeite AS INTEGER NO-UNDO.
  1383. FIND FIRST tParam.
  1384. iOldSeite = iSeite.
  1385. RUN VIPER_NEUE_SEITE.
  1386. IF iSeite = 1 /* OR
  1387. iSeite > iOldSeite */ THEN
  1388. DO:
  1389. FIND bSteuer NO-LOCK WHERE bSteuer.Firma = cFirma.
  1390. RUN VIPER_CREATE_DOKUMENT ( 'Kopf', 1, 'MWST_T', Steuer.Mwst_Nr ).
  1391. cBesrKopf = ''.
  1392. IF bSavko.Adresse[05] <> '' THEN
  1393. DO:
  1394. i1 = 6.
  1395. DO ii = 1 TO 5:
  1396. CREATE tDokument.
  1397. ASSIGN
  1398. tDokument.cGruppe = 'KOPF'
  1399. tDokument.iZeile = 1
  1400. tDokument.cFeld = 'Adresse_' + STRING((6 + ii),'99')
  1401. tDokument.cInhalt = bSavko.Adresse[ii].
  1402. i1 = i1 + 1.
  1403. cBesrKopf[i1] = bSavko.Adresse[ii].
  1404. END.
  1405. END.
  1406. ELSE
  1407. DO:
  1408. DO ii = 5 TO 11:
  1409. CREATE tDokument.
  1410. ASSIGN
  1411. tDokument.cGruppe = 'KOPF'
  1412. tDokument.iZeile = 1
  1413. tDokument.cFeld = 'Adresse_' + STRING(ii,'99')
  1414. tDokument.cInhalt = bAdresse.Anschrift[ii].
  1415. cBesrKopf[ii] = bAdresse.Anschrift[ii].
  1416. END.
  1417. END.
  1418. CREATE tDokument.
  1419. ASSIGN
  1420. tDokument.cGruppe = 'KOPF'
  1421. tDokument.iZeile = 1
  1422. tDokument.cFeld = 'Ort_Datum'
  1423. tDokument.cInhalt = TRIM(SUBSTRING(cFormText[07],01,20))
  1424. + " "
  1425. + STRING(dFakDatum,"99.99.9999").
  1426. cString = (IF bSavko.Auf_Tot >= 0
  1427. THEN TRIM(SUBSTRING(cFormText[02],01,20))
  1428. ELSE TRIM(SUBSTRING(cFormText[02],21,20))).
  1429. cString = cString
  1430. + ' '
  1431. + TRIM(STRING(bSavko.Faknr,'>>>>>>9')).
  1432. CREATE tDokument.
  1433. ASSIGN
  1434. tDokument.cGruppe = 'KOPF'
  1435. tDokument.iZeile = 1
  1436. tDokument.cFeld = 'T_Dokument'
  1437. tDokument.cInhalt = cString.
  1438. CREATE tDokument.
  1439. ASSIGN
  1440. tDokument.cGruppe = 'KOPF'
  1441. tDokument.iZeile = 1
  1442. tDokument.cFeld = 'Knr'
  1443. tDokument.cInhalt = STRING(bSavko.Fak_Knr,'999999').
  1444. END.
  1445. IF iSeite > iOldSeite THEN RUN DRUCKEN_ADRESSE.
  1446. END PROCEDURE.
  1447. /* _UIB-CODE-BLOCK-END */
  1448. &ANALYZE-RESUME
  1449. &ENDIF
  1450. &IF DEFINED(EXCLUDE-FUELLEN_tSavze) = 0 &THEN
  1451. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE FUELLEN_tSavze Procedure
  1452. PROCEDURE FUELLEN_tSavze :
  1453. /*------------------------------------------------------------------------------
  1454. Purpose:
  1455. Parameters: <none>
  1456. Notes:
  1457. ------------------------------------------------------------------------------*/
  1458. DEFINE INPUT PARAMETER ipAufnr AS INTEGER NO-UNDO.
  1459. DEFINE VARIABLE minPos AS INTEGER NO-UNDO.
  1460. DEFINE VARIABLE maxPos AS INTEGER NO-UNDO.
  1461. DEFINE VARIABLE jPlatz AS INTEGER NO-UNDO.
  1462. DEFINE VARIABLE cLagOrt AS CHARACTER NO-UNDO.
  1463. DEFINE VARIABLE iRuestArt AS INTEGER NO-UNDO.
  1464. DEFINE VARIABLE iPlusMinus AS INTEGER NO-UNDO.
  1465. DEFINE VARIABLE lArtikel AS LOG NO-UNDO.
  1466. DEFINE VARIABLE cSort AS CHARACTER NO-UNDO.
  1467. EMPTY TEMP-TABLE tSavze.
  1468. FIND Steuer NO-LOCK
  1469. WHERE Steuer.Firma = cFirma NO-ERROR.
  1470. IF AVAILABLE Steuer THEN iRuestArt = Steuer.RuestArt.
  1471. ASSIGN
  1472. minPos = 0
  1473. maxPos = 9999
  1474. iPlusMinus = 0.
  1475. /* Kommentar zu Beginn eines Auftrages */
  1476. lArtikel = FALSE.
  1477. FOR EACH Savze NO-LOCK
  1478. WHERE Savze.Firma = cFirma
  1479. AND Savze.Aufnr = ipAufnr
  1480. AND Savze.Pos > minPos:
  1481. IF Savze.Artnr > 0 THEN
  1482. DO:
  1483. lArtikel = TRUE.
  1484. LEAVE.
  1485. END.
  1486. minPos = Savze.Pos.
  1487. CREATE tSavze.
  1488. ASSIGN
  1489. tSavze.Aufnr = Savze.Aufnr
  1490. tSavze.Artnr = Savze.Artnr
  1491. tSavze.Inhalt = Savze.Inhalt
  1492. tSavze.Jahr = Savze.Jahr
  1493. tSavze.Pos = Savze.Pos
  1494. tSavze.Zeile = RECID(Savze)
  1495. tSavze.Aktion = Savze.Aktion
  1496. tSavze.Preis = Savze.Preis
  1497. tSavze.MGeli = Savze.MGeli
  1498. tSavze.MRuek = Savze.MRuek.
  1499. ASSIGN
  1500. tSavze.Sort1 = ''
  1501. tSavze.Sort2 = ''
  1502. tSavze.Sort3 = STRING(tSavze.Artnr ,'999999')
  1503. + STRING(tSavze.Inhalt,'9999')
  1504. + STRING(tSavze.Jahr ,'9999')
  1505. + STRING(iPlusMinus ,'9')
  1506. + STRING(tSavze.Pos ,'9999').
  1507. tSavze.LagOrt = ''.
  1508. END.
  1509. /* Kommentar am Ende eines Auftrages */
  1510. IF lArtikel THEN
  1511. DO:
  1512. FOR EACH Savze NO-LOCK
  1513. WHERE Savze.Firma = cFirma
  1514. AND Savze.Aufnr = ipAufnr
  1515. BY Savze.Pos DESCENDING:
  1516. IF Savze.Artnr > 0 THEN LEAVE.
  1517. maxPos = Savze.Pos.
  1518. CREATE tSavze.
  1519. ASSIGN
  1520. tSavze.Aufnr = Savze.Aufnr
  1521. tSavze.Artnr = Savze.Artnr
  1522. tSavze.Inhalt = Savze.Inhalt
  1523. tSavze.Jahr = Savze.Jahr
  1524. tSavze.Pos = Savze.Pos
  1525. tSavze.Zeile = RECID(Savze)
  1526. tSavze.Aktion = Savze.Aktion
  1527. tSavze.Preis = Savze.Preis
  1528. tSavze.MGeli = Savze.MGeli
  1529. tSavze.MRuek = Savze.MRuek.
  1530. ASSIGN
  1531. tSavze.Sort1 = 'ZZZ'
  1532. tSavze.Sort2 = ''
  1533. tSavze.Sort3 = STRING(tSavze.Artnr ,'999999')
  1534. + STRING(tSavze.Inhalt,'9999')
  1535. + STRING(tSavze.Jahr ,'9999')
  1536. + STRING(iPlusMinus ,'9')
  1537. + STRING(tSavze.Pos ,'9999').
  1538. tSavze.LagOrt = ''.
  1539. END.
  1540. END.
  1541. /* Artikelzeilen nach WarenGruppe/ProdGruppen/Artikelgruppen */
  1542. cLagOrt = ''.
  1543. cSort = ''.
  1544. FOR EACH Savze NO-LOCK
  1545. WHERE Savze.Firma = cFirma
  1546. AND Savze.Aufnr = ipAufnr
  1547. AND Savze.Pos > minPos
  1548. AND Savze.Pos < MaxPos
  1549. BY Savze.Pos DESCENDING:
  1550. IF Savze.Artnr > 0 THEN
  1551. DO:
  1552. FIND Artst NO-LOCK
  1553. WHERE Artst.Firma = Savze.Firma
  1554. AND Artst.Artnr = Savze.Artnr
  1555. AND Artst.Inhalt = Savze.Inhalt
  1556. AND Artst.Jahr = Savze.Jahr NO-ERROR.
  1557. IF AVAILABLE Artst THEN cSort = STRING(Artst.Wg_Grp ,'9999')
  1558. + STRING(Artst.Prod_Grp,'9999')
  1559. + STRING(Artst.Art_Grp ,'9999').
  1560. END.
  1561. iPlusMinus = (IF Savze.MGeli < 0 THEN 1 ELSE 0).
  1562. CREATE tSavze.
  1563. ASSIGN
  1564. tSavze.Aufnr = Savze.Aufnr
  1565. tSavze.Artnr = Savze.Artnr
  1566. tSavze.Inhalt = Savze.Inhalt
  1567. tSavze.Jahr = Savze.Jahr
  1568. tSavze.Pos = Savze.Pos
  1569. tSavze.Zeile = RECID(Savze)
  1570. tSavze.Aktion = Savze.Aktion
  1571. tSavze.Preis = Savze.Preis
  1572. tSavze.MGeli = Savze.MGeli
  1573. tSavze.MRuek = Savze.MRuek.
  1574. ASSIGN
  1575. tSavze.Sort1 = cSort
  1576. tSavze.Sort2 = ''
  1577. tSavze.Sort3 = STRING(tSavze.Artnr ,'999999')
  1578. + STRING(tSavze.Inhalt,'9999')
  1579. + STRING(tSavze.Jahr ,'9999')
  1580. + STRING(iPlusMinus ,'9')
  1581. + STRING(tSavze.Pos ,'9999').
  1582. tSavze.LagOrt = cLagort.
  1583. END.
  1584. END PROCEDURE.
  1585. /* _UIB-CODE-BLOCK-END */
  1586. &ANALYZE-RESUME
  1587. &ENDIF
  1588. &IF DEFINED(EXCLUDE-PRUEFZIFFER) = 0 &THEN
  1589. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE PRUEFZIFFER Procedure
  1590. PROCEDURE PRUEFZIFFER :
  1591. /*------------------------------------------------------------------------------
  1592. Purpose:
  1593. Parameters: <none>
  1594. Notes:
  1595. ------------------------------------------------------------------------------*/
  1596. /* ------------------------------------------------------------------------- */
  1597. /* Prufziffer MODULO 10, Rekursiv (27 Stellig Ref.-Nr.) */
  1598. /* ------------------------------------------------------------------------- */
  1599. /* */
  1600. /* Uebergabe Variable: 1. String Betrag (12-stellig) */
  1601. /* 2. String Referenz (27-stellig) */
  1602. /* 3. String Teilnehmernummer ( 9-stellig) */
  1603. /* */
  1604. /* Erstellung der VESR-Codierzeile */
  1605. /* */
  1606. /*---------------------------------------------------------------------------*/
  1607. DEFINE INPUT-OUTPUT PARAMETER PZBetrag AS CHARACTER FORMAT "x(13)".
  1608. DEFINE INPUT-OUTPUT PARAMETER PZReferenz AS CHARACTER FORMAT "x(27)".
  1609. DEFINE INPUT-OUTPUT PARAMETER PZTNummer AS CHARACTER FORMAT "x(09)".
  1610. DEFINE OUTPUT PARAMETER VSZeile AS CHARACTER FORMAT "x(58)".
  1611. DEFINE VARIABLE l1 AS INTEGER.
  1612. DEFINE VARIABLE l2 AS INTEGER.
  1613. DEFINE VARIABLE l3 AS INTEGER.
  1614. DEFINE VARIABLE PZ AS INTEGER.
  1615. DEFINE VARIABLE x1 AS INTEGER.
  1616. DEFINE VARIABLE x2 AS INTEGER.
  1617. DEFINE VARIABLE x3 AS INTEGER.
  1618. DEFINE VARIABLE VMOD10 AS CHARACTER FORMAT "x(11)" EXTENT 11.
  1619. VMOD10[01] = "09468271350".
  1620. VMOD10[02] = "94682713509".
  1621. VMOD10[03] = "46827135098".
  1622. VMOD10[04] = "68271350947".
  1623. VMOD10[05] = "82713509466".
  1624. VMOD10[06] = "27135094685".
  1625. VMOD10[07] = "71350946824".
  1626. VMOD10[08] = "13509468273".
  1627. VMOD10[09] = "35094682712".
  1628. VMOD10[10] = "50946827131".
  1629. l1 = 12.
  1630. l2 = 26.
  1631. l3 = 08.
  1632. DO WHILE SUBSTRING(PZBetrag,01,01) <> " ": /* Mit Betrag */
  1633. x2 = 1.
  1634. x1 = INT(SUBSTRING(PZBetrag ,01 ,01)).
  1635. x2 = INT(SUBSTRING(VMOD10[x2],x1 + 1,01)).
  1636. DO x3 = 2 TO 12:
  1637. x1 = INT(SUBSTRING(PZBetrag ,x3 ,01)).
  1638. x2 = INT(SUBSTRING(VMOD10[x2 + 1],x1 + 1,01)).
  1639. END.
  1640. PZ = INT(SUBSTRING(VMOD10[x2 + 1],11,1)).
  1641. SUBSTRING(PZBetrag,13) = STRING(PZ,"9").
  1642. LEAVE.
  1643. END.
  1644. DO WHILE SUBSTRING(PZBetrag,01,01) = " ": /* Ohne Betrag */
  1645. x2 = 11.
  1646. x1 = INT(SUBSTRING(PZBetrag ,01 ,01)).
  1647. x2 = INT(SUBSTRING(VMOD10[x2],x1 + 1,01)).
  1648. DO x3 = 12 TO 12:
  1649. x1 = INT(SUBSTRING(PZBetrag ,x3 ,01)).
  1650. x2 = INT(SUBSTRING(VMOD10[x2 + 1],x1 + 1,01)).
  1651. END.
  1652. PZ = INT(SUBSTRING(VMOD10[x2 + 1],11,1)).
  1653. SUBSTRING(PZBetrag,13) = STRING(PZ,"9").
  1654. LEAVE.
  1655. END.
  1656. DO WHILE l2 = 26:
  1657. x2 = 1.
  1658. x1 = INT(SUBSTRING(PZReferenz,01 ,01)).
  1659. x2 = INT(SUBSTRING(VMOD10[x2],x1 + 1,01)).
  1660. DO x3 = 2 TO 26:
  1661. x1 = INT(SUBSTRING(PZReferenz ,x3 ,01)).
  1662. x2 = INT(SUBSTRING(VMOD10[x2 + 1],x1 + 1,01)).
  1663. END.
  1664. PZ = INT(SUBSTRING(VMOD10[x2 + 1],11,1)).
  1665. SUBSTRING(PZReferenz,27) = STRING(PZ,"9").
  1666. LEAVE.
  1667. END.
  1668. DO WHILE l3 = 08:
  1669. x2 = 1.
  1670. x1 = INT(SUBSTRING(PZTNummer ,01 ,01)).
  1671. x2 = INT(SUBSTRING(VMOD10[x2],x1 + 1,01)).
  1672. DO x3 = 2 TO 08:
  1673. x1 = INT(SUBSTRING(PZTNummer ,x3 ,01)).
  1674. x2 = INT(SUBSTRING(VMOD10[x2 + 1],x1 + 1,01)).
  1675. END.
  1676. PZ = INT(SUBSTRING(VMOD10[x2 + 1],11,1)).
  1677. SUBSTRING(PZTNummer,09) = STRING(PZ,"9").
  1678. LEAVE.
  1679. END.
  1680. VSZeile = "".
  1681. SUBSTRING(VSZeile,01) = PZBetrag.
  1682. SUBSTRING(VSZeile,14) = ">".
  1683. SUBSTRING(VSZeile,15) = PZReferenz.
  1684. SUBSTRING(VSZeile,42) = "+ ".
  1685. SUBSTRING(VSZeile,44) = PZTNummer.
  1686. SUBSTRING(VSZeile,53) = ">".
  1687. /*
  1688. SUBSTRING(VSZeile,58) = "H".
  1689. */
  1690. END PROCEDURE.
  1691. /* _UIB-CODE-BLOCK-END */
  1692. &ANALYZE-RESUME
  1693. &ENDIF
  1694. &IF DEFINED(EXCLUDE-VIPER_CREATE_DOKUMENT) = 0 &THEN
  1695. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE VIPER_CREATE_DOKUMENT Procedure
  1696. PROCEDURE VIPER_CREATE_DOKUMENT :
  1697. /*------------------------------------------------------------------------------
  1698. Purpose:
  1699. Parameters: <none>
  1700. Notes:
  1701. ------------------------------------------------------------------------------*/
  1702. DEFINE INPUT PARAMETER ipGruppe AS CHARACTER NO-UNDO.
  1703. DEFINE INPUT PARAMETER ipZeile AS INTEGER NO-UNDO.
  1704. DEFINE INPUT PARAMETER ipFeld AS CHARACTER NO-UNDO.
  1705. DEFINE INPUT PARAMETER ipInhalt AS CHARACTER NO-UNDO.
  1706. CREATE tDokument.
  1707. ASSIGN
  1708. tDokument.cGruppe = ipGruppe
  1709. tDokument.iZeile = ipZeile
  1710. tDokument.cFeld = ipFeld
  1711. tDokument.cInhalt = ipInhalt.
  1712. END PROCEDURE.
  1713. /* _UIB-CODE-BLOCK-END */
  1714. &ANALYZE-RESUME
  1715. &ENDIF
  1716. &IF DEFINED(EXCLUDE-VIPER_INIT) = 0 &THEN
  1717. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE VIPER_INIT Procedure
  1718. PROCEDURE VIPER_INIT :
  1719. /*------------------------------------------------------------------------------
  1720. Purpose:
  1721. Parameters: <none>
  1722. Notes:
  1723. ------------------------------------------------------------------------------*/
  1724. DEFINE VARIABLE cTemplate AS CHARACTER NO-UNDO.
  1725. DEFINE VARIABLE cDokument AS CHARACTER NO-UNDO.
  1726. DEFINE VARIABLE cZellen AS CHARACTER NO-UNDO.
  1727. DEFINE VARIABLE cZelle AS CHARACTER NO-UNDO.
  1728. DEFINE VARIABLE cGruppe AS CHARACTER NO-UNDO.
  1729. DEFINE VARIABLE ii AS INTEGER NO-UNDO.
  1730. FIND FIRST tParam.
  1731. IF iLauf = 1 THEN
  1732. DO:
  1733. IF tParam.lCreatePDF THEN cDokument = tParam.cInstall + '/' + tParam.cDokument + '_logo.vfr'.
  1734. ELSE cDokument = tParam.cInstall + '/' + tParam.cDokument + '.vfr'.
  1735. RUN vpr_ResetDoc.
  1736. RUN vpr_LoadVFR (cDokument).
  1737. RUN vpr_ActivateReport (tParam.cDokument).
  1738. RUN vpr_SelectPrinter (tParam.Drucker).
  1739. RUN vpr_setPrinterAttrib('duplex=1').
  1740. RUN vpr_SetPrinterAttrib('copies=1').
  1741. RUN vpr_ResetDoc.
  1742. RUN vpr_SetDocAttrib ('PAPERSIZE=A4').
  1743. RUN vpr_SetPreviewMode ('Direct').
  1744. RUN vpr_setDocTitle (tParam.cDokument).
  1745. IF tParam.Schacht_Original > 0 THEN RUN vpr_SetCurrentPageProperties ( "Papertray", tParam.Schacht_Original ).
  1746. END.
  1747. ELSE
  1748. DO:
  1749. RUN vpr_NewPage.
  1750. IF tParam.Schacht_Kopie > 0 THEN RUN vpr_SetCurrentPageProperties ( "Papertray", tParam.Schacht_Kopie ).
  1751. END.
  1752. RUN vpr_InitGroups("").
  1753. RUN vpr_InitGraphObj.
  1754. RUN vpr_SetGroupAttrib ("Kopf" , "Fixed=true").
  1755. RUN vpr_SetGroupAttrib ("Fusstext" , "Fixed=true").
  1756. RUN vpr_SetGroupAttrib ("Kondition", "Fixed=true").
  1757. iMaxPos = 2600.
  1758. END PROCEDURE.
  1759. /* _UIB-CODE-BLOCK-END */
  1760. &ANALYZE-RESUME
  1761. &ENDIF
  1762. &IF DEFINED(EXCLUDE-VIPER_NEUE_SEITE) = 0 &THEN
  1763. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE VIPER_NEUE_SEITE Procedure
  1764. PROCEDURE VIPER_NEUE_SEITE :
  1765. /*------------------------------------------------------------------------------
  1766. Purpose:
  1767. Parameters: <none>
  1768. Notes:
  1769. ------------------------------------------------------------------------------*/
  1770. DEFINE VARIABLE iPos AS INTEGER NO-UNDO.
  1771. FIND FIRST tParam.
  1772. DO WHILE TRUE:
  1773. IF iSeite = 0 THEN
  1774. DO:
  1775. RUN vpr_InitGroups('').
  1776. /* IF tParam.lCreatePDF THEN RUN vpr_initGraphObj.*/
  1777. RUN vpr_initGraphObj.
  1778. iSeite = iSeite + 1.
  1779. LEAVE.
  1780. END.
  1781. iPos = vpr_getPageVPos().
  1782. IF (iPos + 160) < iMaxPos THEN
  1783. DO:
  1784. iPos = iPos + 20.
  1785. RUN vpr_setPageVPos ( iPos ).
  1786. LEAVE.
  1787. END.
  1788. RUN vpr_NewPage.
  1789. RUN vpr_InitGroups('').
  1790. IF tParam.Schacht_Original > 0 AND
  1791. iLauf = 1 THEN RUN vpr_SetCurrentPageProperties ( "Papertray", tParam.Schacht_Original ).
  1792. IF tParam.Schacht_Kopie > 0 AND
  1793. iLauf > 1 THEN RUN vpr_SetCurrentPageProperties ( "Papertray", tParam.Schacht_Kopie ).
  1794. RUN vpr_initGraphObj.
  1795. iSeite = iSeite + 1.
  1796. LEAVE.
  1797. END.
  1798. END PROCEDURE.
  1799. /* _UIB-CODE-BLOCK-END */
  1800. &ANALYZE-RESUME
  1801. &ENDIF