Sav_FestRechnung.p 77 KB

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