Sav_Faktura.p 74 KB

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