| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165 |
- &ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS Procedure
- /*------------------------------------------------------------------------
- File :
- Purpose :
- Syntax :
- Description :
- Author(s) :
- Created :
- Notes :
- ----------------------------------------------------------------------*/
- /* This .W file was created with the Progress AppBuilder. */
- /*----------------------------------------------------------------------*/
- /* *************************** Definitions ************************** */
- DEFINE INPUT PARAMETER iphParam AS HANDLE NO-UNDO.
- DEFINE OUTPUT PARAMETER opcResult AS CHARACTER NO-UNDO.
- DEFINE VARIABLE iSeite AS INTEGER NO-UNDO.
- DEFINE VARIABLE iAnzDok AS INTEGER NO-UNDO.
- DEFINE VARIABLE iLauf AS INTEGER NO-UNDO.
- DEFINE VARIABLE lFirst AS LOG INIT FALSE NO-UNDO.
- DEFINE VARIABLE lLast AS LOG INIT FALSE NO-UNDO.
- DEFINE VARIABLE lPreis AS LOG NO-UNDO.
- DEFINE VARIABLE cFirma AS CHARACTER NO-UNDO.
- DEFINE VARIABLE AdFirma AS CHARACTER NO-UNDO.
- DEFINE VARIABLE nFakBetr AS DECIMAL NO-UNDO.
- DEFINE VARIABLE dFakDatum AS DATE NO-UNDO.
- DEFINE VARIABLE iFaknr AS INTEGER NO-UNDO.
- DEFINE VARIABLE iSprcd AS INTEGER NO-UNDO.
- DEFINE VARIABLE nTotale AS DECIMAL EXTENT 15 NO-UNDO.
- DEFINE VARIABLE cFormtext AS CHARACTER EXTENT 30 NO-UNDO.
- DEFINE VARIABLE cRabText AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cZusText AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cEpzText AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cBesrKopf AS CHARACTER EXTENT 12 NO-UNDO.
- DEFINE VARIABLE lDebIncl AS LOG NO-UNDO.
- DEFINE VARIABLE Rundbetr AS DECIMAL DECIMALS 4 NO-UNDO.
- DEFINE VARIABLE RundCode AS INTEGER INIT 1 NO-UNDO.
- DEFINE VARIABLE htTabTexte AS HANDLE NO-UNDO.
- DEFINE VARIABLE hSavko AS HANDLE NO-UNDO.
- DEFINE VARIABLE cInstallation AS CHARACTER NO-UNDO.
- DEFINE VARIABLE iBesrArt AS INTEGER NO-UNDO.
- DEFINE VARIABLE iMaxPos AS INTEGER INIT 2650 NO-UNDO.
- DEFINE VARIABLE cvpr_Dokument AS CHARACTER NO-UNDO.
- DEFINE VARIABLE iArtZeile AS INTEGER NO-UNDO.
- DEFINE VARIABLE iVPagePos AS INTEGER NO-UNDO.
- DEFINE VARIABLE iVGroupPos AS INTEGER NO-UNDO.
- DEFINE BUFFER bSavko FOR Savko .
- DEFINE BUFFER bSavze FOR Savze .
- DEFINE BUFFER FDebst FOR Debst . /* Fakturaadresse */
- DEFINE BUFFER LDebst FOR Debst . /* Lieferadresse */
- DEFINE BUFFER bDebst FOR Debst . /* BesrArt/Verband */
- DEFINE BUFFER LAdresse FOR Adresse .
- DEFINE BUFFER bAdresse FOR Adresse .
- DEFINE BUFFER bWust FOR Wust .
- DEFINE BUFFER bSteuer FOR Steuer .
- { incl/properties.i }
- { incl/ttdruckparam.i }
- { swissqr/propertiesSwissQR.i }
- DEFINE TEMP-TABLE tDokument
- FIELD cGruppe AS CHARACTER
- FIELD iZeile AS INTEGER
- FIELD cFeld AS CHARACTER
- FIELD cInhalt AS CHARACTER
-
- INDEX tDokument-k1 IS PRIMARY
- cGruppe
- iZeile
- cFeld
- .
- DEFINE TEMP-TABLE tTotale
- FIELD nMwstPfl AS DECIMAL EXTENT 12
- FIELD nMwstBet AS DECIMAL EXTENT 12
- FIELD nSammTot AS DECIMAL
- FIELD nSkBer AS DECIMAL
- FIELD nWW AS DECIMAL
- .
- DEFINE TEMP-TABLE sSavko
- FIELD cFirma AS CHARACTER
- FIELD iAufnr AS INTEGER
- FIELD iFak_Knr AS INTEGER
- FIELD iKnr AS INTEGER
- FIELD iSamm_Nr AS INTEGER
- FIELD iRecid AS RECID
- FIELD iFaknr AS INTEGER
- FIELD dFakDat AS DATE
- .
- DEFINE TEMP-TABLE tSavko LIKE Savko
- FIELD iRecid AS RECID
- FIELD lBetrag AS LOGICAL
- .
- DEFINE TEMP-TABLE tSavze
- FIELD Aufnr AS INTEGER
- FIELD Sort1 AS CHARACTER
- FIELD Sort2 AS CHARACTER
- FIELD Sort3 AS CHARACTER
- FIELD Artnr AS INTEGER
- FIELD Inhalt AS INTEGER
- FIELD Jahr AS INTEGER
- FIELD Pos AS INTEGER
- FIELD Zeile AS RECID
- FIELD Preis AS DECIMAL DECIMALS 4
- FIELD Aktion AS LOG
- FIELD LagOrt AS CHARACTER
- FIELD MGeli AS DECIMAL
- FIELD MRuek AS DECIMAL
-
- INDEX tSavze-k1 IS PRIMARY
- Aufnr
- Sort1
- Sort2
- Sort3
- .
- DEFINE TEMP-TABLE tRueckst LIKE tSavze
- .
- DEFINE TEMP-TABLE tSpeRab
- FIELD Rab_Grp AS INTEGER
- FIELD Auf_Betr AS DECIMAL DECIMALS 4
- .
- DEFINE TEMP-TABLE tGebKto
- FIELD Sort_Cd AS CHARACTER
- FIELD Geb_Cd AS CHARACTER
- FIELD Bez AS CHARACTER
- FIELD Preis AS DECIMAL
- FIELD A_Anz AS DECIMAL
- FIELD A_Betrag AS DECIMAL
- FIELD E_Anz AS DECIMAL
- FIELD E_Betrag AS DECIMAL
- FIELD MWST_Art AS INTEGER
- FIELD MWST_Cd AS INTEGER
- .
- DEFINE TEMP-TABLE tRabSumm
- FIELD Rab_Summ AS INTEGER
- FIELD Bez AS CHARACTER
- FIELD F_Rab_Art AS INTEGER
- FIELD F_Wert AS DECIMAL DECIMALS 4
- FIELD A_Rab_Art AS INTEGER
- FIELD A_Wert AS DECIMAL DECIMALS 4
- FIELD Auf_Rab AS DECIMAL DECIMALS 4
- FIELD Abh_Rab AS DECIMAL DECIMALS 4
- .
- DEFINE TEMP-TABLE tUmsGrp
- FIELD Ums_Grp AS INTEGER
- FIELD Mwst AS INTEGER
- FIELD Ansatz AS DECIMAL
- FIELD Bez AS CHARACTER
- FIELD lInkl AS LOG
- FIELD Ums_Betr AS DECIMAL DECIMALS 4
- .
- DEFINE TEMP-TABLE tTabTexte
- FIELD cRecArt AS CHARACTER
- FIELD iZeile AS INTEGER
- FIELD cFeld1 AS CHARACTER
- FIELD cFeld2 AS CHARACTER
- FIELD cFeld3 AS CHARACTER
- FIELD iFeld1 AS INTEGER
- FIELD iFeld2 AS INTEGER
- FIELD iFeld3 AS INTEGER
-
- INDEX tTabTexte-k1 IS PRIMARY
- cRecArt
- iZeile.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK
- /* ******************** Preprocessor Definitions ******************** */
- &Scoped-define PROCEDURE-TYPE Procedure
- &Scoped-define DB-AWARE no
- /* _UIB-PREPROCESSOR-BLOCK-END */
- &ANALYZE-RESUME
- /* *********************** Procedure Settings ************************ */
- &ANALYZE-SUSPEND _PROCEDURE-SETTINGS
- /* Settings for THIS-PROCEDURE
- Type: Procedure
- Allow:
- Frames: 0
- Add Fields to: Neither
- Other Settings: CODE-ONLY COMPILE
- */
- &ANALYZE-RESUME _END-PROCEDURE-SETTINGS
- /* ************************* Create Window ************************** */
- &ANALYZE-SUSPEND _CREATE-WINDOW
- /* DESIGN Window definition (used by the UIB)
- CREATE WINDOW Procedure ASSIGN
- HEIGHT = 18.62
- WIDTH = 59.4.
- /* END WINDOW DEFINITION */
- */
- &ANALYZE-RESUME
-
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK Procedure
- /* *************************** Main Block *************************** */
- opcResult = ''.
- CREATE tParam.
- htParam:BUFFER-COPY(iphParam).
- ASSIGN
- cFirma = tParam.cFirma
- iAnzDok = tParam.Anzahl
- lPreis = TRUE
- cInstallation = DYNAMIC-FUNCTION ('getInstallation':U)
- cERPDokumente = DYNAMIC-FUNCTION ('getFehlwert':U, tParam.cFirma, 'GEMIS_ERPDOKUMENTE')
- cPathQRCodes = DYNAMIC-FUNCTION ('getFehlwert':U, tParam.cFirma, 'GEMIS_QRCODE' ) NO-ERROR.
-
- FIND bSteuer NO-LOCK WHERE bSteuer.Firma = cFirma.
- AdFirma = bSteuer.AdFirma.
- RUN AUFTRAG_ERMITTELN.
- IF opcResult <> '' THEN RETURN.
- FOR EACH sSavko
- BY sSavko.iFak_Knr:
- FIND bAdresse NO-LOCK
- WHERE bAdresse.Firma = AdFirma
- AND bAdresse.Knr = sSavko.iFak_Knr.
- iSprcd = bAdresse.Sprcd.
- RUN GET_FORMTEXT ( tParam.cInstall, tParam.Template, iSprcd,
- OUTPUT cFormText ) NO-ERROR.
- cRabText = TRIM(SUBSTRING(cFormText[21],01,20)).
- cZusText = TRIM(SUBSTRING(cFormText[21],21,20)).
- cEpzText = TRIM(SUBSTRING(cFormText[21],41,20)).
- RELEASE bAdresse.
-
- { vpr.i INIT }
- { vpr.i START }
-
- DO iLauf = 1 TO iAnzDok:
-
- dFakDatum = sSavko.dFakDat.
- iSeite = 0.
- iFaknr = sSavko.iFaknr.
- lFirst = TRUE.
- lLast = FALSE.
-
- EMPTY TEMP-TABLE tUmsGrp .
- EMPTY TEMP-TABLE tTotale .
-
- CREATE tTotale.
-
- FOR EACH bSavko NO-LOCK
- WHERE bSavko.Firma = sSavko.cFirma
- AND bSavko.Aufnr = sSavko.iAufnr
-
- BREAK BY bSavko.Firma
- BY bSavko.Aufnr :
- EMPTY TEMP-TABLE tSavze .
- EMPTY TEMP-TABLE tGebKto .
- EMPTY TEMP-TABLE tRabSumm .
- EMPTY TEMP-TABLE tSpeRab .
- EMPTY TEMP-TABLE tTabTexte .
- EMPTY TEMP-TABLE tRueckst .
-
- FIND bAdresse NO-LOCK USE-INDEX Adresse-k1
- WHERE bAdresse.Firma = AdFirma
- AND bAdresse.Knr = bSavko.Fak_Knr NO-ERROR.
- FIND LDebst NO-LOCK USE-INDEX Debst-k1
- WHERE LDebst.Firma = cFirma
- AND LDebst.Knr = bSavko.Knr NO-ERROR.
- FIND FDebst NO-LOCK USE-INDEX Debst-k1
- WHERE FDebst.Firma = cFirma
- AND FDebst.Knr = bSavko.Fak_Knr NO-ERROR.
- FIND bWust NO-LOCK USE-INDEX Wust-k1
- WHERE bWust.CodeK = LDebst.MWST
- AND bWust.CodeA = 99 NO-ERROR.
- lDebIncl = FALSE.
- IF AVAILABLE bWust THEN lDebIncl = bWust.Incl.
-
- hSavko = BUFFER bSavko:HANDLE.
- htTabTexte = TEMP-TABLE tTabTexte:DEFAULT-BUFFER-HANDLE.
-
- /* Texte und Werte aus Tabelle 'Tabel' laden für RecArt */
- /* FAKART, AUFSTATUS, LIEFART, FAHRER, WISO, ABLAD */
-
- RUN CREATE_TABTEXTE ( hSavko, INPUT-OUTPUT htTabTexte ) NO-ERROR.
-
- RUN FUELLEN_tSavze ( bSavko.Aufnr ) NO-ERROR.
-
- FOR EACH tSavze
- WHERE tSavze.Artnr > 0:
-
- FIND bSavze NO-LOCK WHERE RECID(bSavze) = tSavze.Zeile.
-
- /* Spezial-Auftragsrabatt pro Lieferschein bilden */
-
- IF bSavze.Auf_Sp_Grp > 0 THEN
- DO:
- FIND FIRST tSpeRab
- WHERE tSpeRab.Rab_Grp = bSavze.Auf_Sp_Grp NO-ERROR.
- IF NOT AVAILABLE tSpeRab THEN
- DO:
- CREATE tSpeRab.
- ASSIGN
- tSpeRab.Rab_Grp = bSavze.Auf_Sp_Grp.
- END.
- tSpeRab.Auf_Betr = tSpeRab.Auf_Betr + bSavze.Auf_Sp_Rab.
- END.
-
- /* Summengruppen-Totale pro Lieferschein bilden */
-
- DO WHILE bSavze.Rab_Su_Grp > 0:
- FIND FIRST tRabSumm
- WHERE tRabSumm.Rab_Summ = bSavze.Rab_Su_Grp NO-ERROR.
- IF NOT AVAILABLE tRabSumm THEN
- DO:
- FIND FIRST RabSumm NO-LOCK
- WHERE RabSumm.Firma = bSavze.Firma
- AND RabSumm.Rab_Summ = bSavze.Rab_Su_Grp NO-ERROR.
- IF NOT AVAILABLE RabSumm THEN LEAVE.
- CREATE tRabSumm.
- ASSIGN
- tRabSumm.Rab_Summ = bSavze.Rab_Su_Grp
- tRabSumm.Bez = RabSumm.Bez
- tRabSumm.Auf_Rab = 0
- tRabSumm.Abh_Rab = 0.
- END.
- LEAVE.
- END.
- END.
-
- IF LAST-OF ( bSavko.Aufnr ) THEN lLast = TRUE.
-
- RUN DRUCKEN.
- /* Auftragskopf mutieren */
- REPEAT TRANSACTION:
- IF iLauf < iAnzDok THEN LEAVE.
- FIND Savko WHERE RECID(Savko) = RECID(bSavko).
- ASSIGN
- Savko.Fak_Datum = dFakDat
- Savko.Gedruckt = TRUE.
- RELEASE Savko.
- RUN AUFTRAG_GEDRUCKT ( bSavko.Aufnr ).
- LEAVE.
- END.
- END.
- END.
- { vpr.i STOP }
- END.
- PROCEDURE ShellExecuteA EXTERNAL "shell32.dll" :
- DEFINE INPUT PARAMETER lphwnd AS LONG.
- DEFINE INPUT PARAMETER lpOperation AS CHARACTER.
- DEFINE INPUT PARAMETER lpFile AS CHARACTER.
- DEFINE INPUT PARAMETER lpParameters AS CHARACTER.
- DEFINE INPUT PARAMETER lpDirectory AS CHARACTER.
- DEFINE INPUT PARAMETER nShowCmd AS LONG.
- DEFINE RETURN PARAMETER hInstance AS LONG.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &IF DEFINED(EXCLUDE-DRUCKEN_QRCODE) = 0 &THEN
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DRUCKEN_QRCODE Procedure
- PROCEDURE DRUCKEN_QRCODE:
- /*------------------------------------------------------------------------------*/
- /* Purpose: */
- /* Parameters: <none> */
- /* Notes: */
- /*------------------------------------------------------------------------------*/
-
- DEFINE VARIABLE cFileName AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cString AS CHARACTER NO-UNDO.
- DEFINE VARIABLE hSavko AS HANDLE NO-UNDO.
- DEFINE VARIABLE cBesrTemplate AS CHARACTER NO-UNDO INIT 'viper/oswald/BESR_QR.vfr'.
- DEFINE VARIABLE cWerbung AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cConString AS CHARACTER NO-UNDO.
- DEFINE VARIABLE i1 AS INTEGER NO-UNDO.
- FIND FIRST tSavko.
- hSavko = TEMP-TABLE tSavko:DEFAULT-BUFFER-HANDLE.
-
- FIND FIRST Debop NO-LOCK
- WHERE Debop.Firma = tSavko.Firma
- AND Debop.Knr = tSavko.Fak_Knr
- AND Debop.Faknr = tSavko.Faknr NO-ERROR.
- tSavko.Auf_Tot = Debop.Fakbetr.
-
- FIND FIRST tParam.
-
- FIND FIRST ViperDoc NO-LOCK
- WHERE ViperDoc.Firma = tSavko.Firma
- AND ViperDoc.Benutzer = ''
- AND ViperDoc.Formular = 'BESR_QR'
- AND ViperDoc.DokArt = 0 NO-ERROR.
- IF NOT AVAILABLE ViperDoc THEN RETURN.
-
- RUN vpr_LoadVFR (cBesrTemplate).
- RUN vpr_ActivateReport ('BESR_QR').
- RUN vpr_SelectPrinter (ViperDoc.Drucker).
- RUN vpr_SetDocAttrib ('PAPERSIZE=A4').
- RUN vpr_SetPreviewMode ('Direct').
- RUN vpr_InitGroups ("").
- RUN vpr_initGraphObj.
- RUN vpr_SetCurrentPageProperties("Papertray", ViperDoc.Schacht_BESR).
- cFileName = SUBSTITUTE('&1&2_&3', cPathQRCodes, 'QR_CODE', STRING(bSavko.Aufnr,'9999999')).
- RUN 'SwissQR/SwissQRCode.p' ( hSavko, cFileName ).
-
- cFilename = cFileName + '.jpg'.
- IF SEARCH(cFileName) <> ? THEN
- DO:
- cFileName = 'FILENAME=' + cFileName.
- RUN vpr_setGraphObjAttrib ( 'QRCode', 'QRCODE', cFileName ).
- END.
- cWerbung = SUBSTITUTE(cPathWerbung, tParam.cInstall).
- cWerbung = SUBSTITUTE('&1Werbung_&2.jpg', cWerbung, tSavko.Firma).
- IF SEARCH(cWerbung) <> ? THEN
- DO:
- cWerbung = SUBSTITUTE('FILENAME=&1', cWerbung).
- RUN vpr_setGraphObjAttrib ( 'Werbung', 'QRCODE', cWerbung ).
- END.
-
- RUN vpr_InitGraphObj.
- RUN vpr_flushGroup('QRCODE').
- END PROCEDURE.
-
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ENDIF
- /* ********************** Internal Procedures *********************** */
- &IF DEFINED(EXCLUDE-ARTIKELZEILE) = 0 &THEN
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ARTIKELZEILE Procedure
- PROCEDURE ARTIKELZEILE :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEFINE INPUT PARAMETER ipRecid AS RECID NO-UNDO.
-
- DEFINE VARIABLE cString AS CHARACTER NO-UNDO.
- DEFINE VARIABLE nRabWert AS DECIMAL NO-UNDO.
- DEFINE VARIABLE xRabText AS CHARACTER NO-UNDO.
-
- FIND tSavze WHERE RECID(tSavze) = ipRecid NO-LOCK.
- FIND Savze WHERE RECID(Savze) = tSavze.Zeile NO-LOCK.
- iArtZeile = iArtZeile + 1.
- DO WHILE Savze.Artnr = 0:
- cString = Savze.Bez1.
- IF Savze.Bez1 <> '' THEN
- DO:
- cString = cString
- + (IF cString = '' THEN '' ELSE CHR(10))
- + Savze.Bez2.
- END.
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'ArtikelZeile1'
- tDokument.iZeile = iArtZeile
- tDokument.cFeld = 'Bez1'
- tDokument.cInhalt = cString.
- RETURN.
- END.
- FIND Artst OF Savze NO-LOCK.
-
- FIND GGebinde NO-LOCK
- WHERE GGebinde.Firma = cFirma
- AND GGebinde.Geb_Cd = Savze.GGeb_Cd NO-ERROR.
- FIND VGebinde NO-LOCK
- WHERE VGebinde.Firma = cFirma
- AND VGebinde.Geb_Cd = Savze.VGeb_Cd NO-ERROR.
- FIND KGebinde NO-LOCK
- WHERE KGebinde.Firma = cFirma
- AND KGebinde.Geb_Cd = Savze.KGeb_Cd NO-ERROR.
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Artnr' , STRING(Savze.Artnr ,"999999") ).
-
- IF Savze.VGeb_Me <> 0 THEN
- DO:
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Menge_VGeb', TRIM(STRING(Savze.VGeb_Me,'->>>>>9')) ).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'VGebinde' , VGebinde.KBez ).
- END.
-
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'KGebinde', KGebinde.Kbez ).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Menge' , TRIM(STRING(Savze.MGeli,'->>,>>9')) ).
-
- cString = Savze.Bez1.
- IF Savze.Bez2 <> '' THEN
- DO:
- cString = cString
- + (IF cString = '' THEN '' ELSE CHR(10))
- + Savze.Bez2.
- END.
- IF Savze.Aktion THEN
- DO:
- cString = cString
- + (IF cString = '' THEN '' ELSE CHR(10))
- + '\b ' + Savze.Aktion_Text + ' \b0'.
- END.
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', cString ).
-
- IF Savze.Alk_Gehalt <> 0 THEN
- DO:
- cString = STRING(Savze.Alk_Gehalt,"zz9.9%").
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Alk%', cString ).
- END.
- IF Savze.Jahr > 9 THEN
- DO:
- cString = STRING(Savze.Jahr,"9999").
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'JG', cString ).
- END.
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis' , STRING(Savze.Preis ,'>,>>9.99') ).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', STRING(Savze.Bru_Betr,'->>>,>>9.99') ).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'MC' , STRING(Savze.WuCd ,'z9') ).
-
-
- IF Savze.Rab_Betr <> 0 THEN
- DO:
- iArtZeile = iArtZeile + 1.
- nRabWert = ABSOLUTE(Savze.Rab_Wert).
- IF Savze.Rab_Art = 3 THEN xRabText = cEpzText.
- ELSE
- DO:
- IF Savze.Rab_Betr < 0 THEN xRabText = cZusText.
- IF Savze.Rab_Betr > 0 THEN xRabText = cRabText.
- END.
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', TRIM(xRabText) ).
-
- IF Savze.Rab_Art = 1 THEN cString = STRING(nRabWert,"->9.9%").
- IF Savze.Rab_Art = 2 OR
- Savze.Rab_Art = 3 THEN cString = STRING(nRabWert,"-9.99").
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis', cString ).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(- Savze.Rab_Betr,"->>>,>>9.99")) ).
- END.
-
- DO WHILE TRUE:
- IF Savze.Zus_Betr = 0 THEN LEAVE.
-
- iArtZeile = iArtZeile + 1.
- nRabWert = ABSOLUTE(Savze.Zus_Wert).
- IF Savze.Zus_Art = 3 THEN xRabText = cEpzText.
- ELSE
- DO:
- IF Savze.Zus_Betr < 0 THEN xRabText = cRabText.
- IF Savze.Zus_Betr > 0 THEN xRabText = cZusText.
- END.
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', TRIM(xRabText) ).
-
- IF Savze.Zus_Art = 1 THEN cString = STRING(nRabWert,"->9.9%").
- IF Savze.Zus_Art = 2 OR
- Savze.Zus_Art = 3 THEN cString = STRING(nRabWert,"-9.99").
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis', cString ).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(+ Savze.Zus_Betr,"->>>,>>9.99")) ).
- LEAVE.
- END.
-
- /* ---- Summengruppen-Total -------------------------------------------- */
-
- IF Savze.Rab_Su_Grp <> 0 THEN
- DO:
- FIND FIRST TRabSumm WHERE TRabSumm.Rab_Summ = Savze.Rab_Su_Grp NO-ERROR.
- IF AVAILABLE TRabSumm THEN
- DO:
- TRabSumm.Auf_Rab = TRabSumm.Auf_Rab + Savze.Auf_Rab.
- TRabSumm.Abh_Rab = TRabSumm.Abh_Rab + Savze.Abh_Rab.
- END.
- END.
-
- /* ---- Warengruppen-Totale -------------------------------------------- */
-
- FIND FIRST TUmsGrp WHERE TUmsGrp.Ums_Grp = Artst.Wg_Grp
- AND TUmsGrp.MWst = Savze.WuCd
- AND TUmsGrp.Ansatz = Savze.Mwst% NO-ERROR.
- IF NOT AVAILABLE TUmsGrp THEN
- DO:
- FIND WarenGrp NO-LOCK USE-INDEX WarenGrp-k1
- WHERE WarenGrp.Firma = cFirma
- AND WarenGrp.Wgr = Artst.Wg_Grp NO-ERROR.
- CREATE TUmsGrp.
- ASSIGN
- TUmsGrp.Ums_Grp = Artst.Wg_Grp
- TUmsGrp.Mwst = Savze.WuCd
- TUmsGrp.Ansatz = Savze.MWST%
- tUmsGrp.lInkl = Savze.MWSt_Inkl.
- IF AVAILABLE WarenGrp THEN TUmsGrp.Bez = WarenGrp.Bez1.
- ELSE TUmsGrp.Bez = "??????????".
- END.
-
- TUmsGrp.Ums_Betr = TUmsGrp.Ums_Betr
- + Savze.Net_Betr
- - Savze.Auf_Rab
- - Savze.Abh_Rab.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ENDIF
- &IF DEFINED(EXCLUDE-AUFTRAG_ERMITTELN) = 0 &THEN
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE AUFTRAG_ERMITTELN Procedure
- PROCEDURE AUFTRAG_ERMITTELN :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEFINE VARIABLE iAufnr AS INTEGER NO-UNDO.
-
- DEFINE BUFFER bDebst FOR Debst.
- FIND FIRST tParam.
-
- EMPTY TEMP-TABLE sSavko.
-
- /* Sammeln aller Aufträge */
-
- FOR EACH Savko NO-LOCK USE-INDEX Savko-k5
- WHERE Savko.Firma = tParam.cFirma
- AND Savko.Faknr = tParam.iFaknr :
- IF tParam.iVerband <> 999999 THEN
- DO:
- FIND bDebst NO-LOCK
- WHERE bDebst.Firma = Savko.Firma
- AND bDebst.Knr = Savko.Fak_Knr NO-ERROR.
- IF NOT AVAILABLE bDebst THEN NEXT.
- IF bDebst.Verband_Grp <> tParam.iVerband THEN NEXT.
- RELEASE bDebst.
- END.
- iFaknr = Savko.Faknr.
- CREATE sSavko.
- ASSIGN
- sSavko.cFirma = Savko.Firma
- sSavko.iAufnr = Savko.Aufnr
- sSavko.iFak_Knr = Savko.Fak_Knr
- sSavko.iKnr = Savko.Knr
- sSavko.iSamm_Nr = 0
- sSavko.iRecid = RECID(Savko)
- sSavko.iFaknr = iFaknr
- sSavko.dFakDat = Savko.Fak_Datum.
- END.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ENDIF
- &IF DEFINED(EXCLUDE-AUSGABE_ARTIKELZEILE) = 0 &THEN
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE AUSGABE_ARTIKELZEILE Procedure
- PROCEDURE AUSGABE_ARTIKELZEILE :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEFINE VARIABLE cZellen AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cWerte AS CHARACTER NO-UNDO.
- DEFINE VARIABLE iPos AS INTEGER NO-UNDO.
-
- FOR EACH tDokument
- WHERE tDokument.cGruppe = 'ArtikelZeile1'
- BREAK BY tDokument.cGruppe
- BY tDokument.iZeile:
- IF FIRST-OF ( tDokument.cGruppe ) THEN
- DO:
- iVPagePos = vpr_getPageVPos() + 20.
- RUN vpr_setPageVPos ( iVPagePos ).
- RUN vpr_setGroupVPos ( 'ArtikelZeile1', iVPagePos ).
- END.
- IF FIRST-OF ( tDokument.iZeile ) THEN
- DO:
- cZellen = ''.
- cWerte = ''.
- END.
- IF tDokument.cFeld = 'Bez1' THEN
- DO:
- tDokument.cInhalt = REPLACE(tDokument.cInhalt, CHR(10), ' \par ') NO-ERROR.
- END.
- cWerte = cWerte
- + (IF cWerte = '' THEN '' ELSE CHR(01))
- + tDokument.cInhalt.
- cZellen = cZellen
- + (IF cZellen = '' THEN '' ELSE ',')
- + tDokument.cFeld.
- IF NOT LAST-OF ( tDokument.iZeile ) THEN NEXT.
-
- RUN vpr_SetDelimiter (CHR(01)).
- RUN vpr_setGroupText ('ArtikelZeile1', cZellen, cWerte).
- iVPagePos = vpr_getPageVPos().
- iPos = iVPagePos + vpr_getGroupHeight('ArtikelZeile1').
- IF iPos > iMaxPos THEN
- DO:
- RUN VIPER_NEUE_SEITE.
- RUN DRUCKEN_ADRESSE.
- iVPagePos = vpr_getPageVPos() + 20.
- RUN vpr_setPageVPos ( iVPagePos ).
- RUN vpr_setGroupText ('ArtikelZeile1', cZellen, cWerte).
- END.
- RUN vpr_FlushGroup ('ArtikelZeile1').
- iVPagePos = vpr_getPageVPos().
- IF LAST-OF ( tDokument.cGruppe ) THEN LEAVE.
-
- iVPagePos = vpr_getPageVPos().
- RUN vpr_setGroupVPos ( 'ArtikelZeile1', iVPagePos ).
- END.
- FOR EACH tDokument
- WHERE tDokument.cGruppe = 'ArtikelZeile1':
- DELETE tDokument.
- END.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ENDIF
- &IF DEFINED(EXCLUDE-AUSGABE_GRUPPE) = 0 &THEN
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE AUSGABE_GRUPPE Procedure
- PROCEDURE AUSGABE_GRUPPE :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEFINE INPUT PARAMETER ipGruppe AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cZellen AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cWerte AS CHARACTER NO-UNDO.
- DEFINE VARIABLE iSpace AS INTEGER NO-UNDO.
-
- FIND FIRST tParam.
-
- iSpace = vpr_getPageVPos().
- FOR EACH tDokument NO-LOCK
- WHERE tDokument.cGruppe = ipGruppe
- BREAK BY tDokument.cGruppe
- BY tDokument.iZeile:
- IF FIRST-OF ( tDokument.iZeile ) THEN iSpace = iSpace + 40.
- END.
- IF iSpace > iMaxPos THEN
- DO:
- RUN vpr_NewPage.
- RUN vpr_InitGroups('').
- /* IF tParam.lCreatePDF THEN RUN vpr_initGraphObj.*/
- RUN vpr_initGraphObj.
- iSeite = iSeite + 1.
- RUN DRUCKEN_ADRESSE.
- END.
-
- iVPagePos = vpr_getPageVPos().
- CASE ipGruppe:
- WHEN 'Gebindeabrechnung' THEN
- DO:
- iVPagePos = iVPagePos + 20.
- RUN vpr_setGroupVPos ( 'GebindeabrechnungTitel', iVPagePos ).
- RUN vpr_FlushGroup ( 'GebindeabrechnungTitel').
- iVPagePos = vpr_getPageVPos().
- END.
- OTHERWISE
- DO:
- END.
- END CASE.
-
- FOR EACH tDokument
- WHERE tDokument.cGruppe = ipGruppe
- BREAK BY tDokument.cGruppe
- BY tDokument.iZeile:
- IF FIRST-OF ( tDokument.cGruppe ) THEN
- DO:
- IF ipGruppe <> 'Kondition' AND
- ipGruppe <> 'BESR' AND
- ipGruppe <> 'ADRESSE' THEN
- DO:
- iVPagePos = vpr_getPageVPos().
- RUN vpr_setGroupVPos ( ipGruppe, iVPagePos ).
- END.
- END.
- IF FIRST-OF ( tDokument.iZeile ) THEN
- DO:
- cZellen = ''.
- cWerte = ''.
- END.
- cWerte = cWerte
- + tDokument.cInhalt.
- cZellen = cZellen
- + tDokument.cFeld.
- IF NOT LAST-OF ( tDokument.iZeile ) THEN
- DO:
- ASSIGN
- cWerte = cWerte + CHR(01)
- cZellen = cZellen + ','.
- NEXT.
- END.
- RUN vpr_SetDelimiter (CHR(01)).
- RUN vpr_setGroupText (ipGruppe, cZellen, cWerte).
- RUN vpr_FlushGroup (ipGruppe).
- END.
- FOR EACH tDokument
- WHERE tDokument.cGruppe = ipGruppe:
- DELETE tDokument.
- END.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ENDIF
- &IF DEFINED(EXCLUDE-DRUCKEN) = 0 &THEN
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DRUCKEN Procedure
- PROCEDURE DRUCKEN :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEFINE VARIABLE cText AS CHARACTER NO-UNDO.
- DEFINE VARIABLE xString AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cLAdresse AS CHARACTER NO-UNDO.
- DEFINE VARIABLE RText AS CHARACTER NO-UNDO.
- DEFINE VARIABLE WText AS CHARACTER NO-UNDO.
- DEFINE VARIABLE ii AS INTEGER NO-UNDO.
- DEFINE VARIABLE i1 AS INTEGER NO-UNDO.
- DEFINE VARIABLE nBetrag AS DECIMAL NO-UNDO.
- DEFINE VARIABLE nRabWert AS DECIMAL NO-UNDO.
- DEFINE VARIABLE iMwstCd AS INTEGER NO-UNDO.
- DEFINE VARIABLE nZeiTot AS DECIMAL DECIMALS 4 NO-UNDO.
- DEFINE VARIABLE lJa AS LOG NO-UNDO.
- DEFINE VARIABLE cPDFName AS CHARACTER INIT '' NO-UNDO.
- DEFINE VARIABLE nPfli AS DECIMAL EXTENT 12 NO-UNDO.
- DEFINE VARIABLE nMwst AS DECIMAL EXTENT 12 NO-UNDO.
- DEFINE VARIABLE nZNetto AS DECIMAL NO-UNDO.
- DEFINE VARIABLE nZMwst AS DECIMAL NO-UNDO.
- DEFINE VARIABLE nZBrutto AS DECIMAL NO-UNDO.
- DEFINE VARIABLE nTNetto AS DECIMAL NO-UNDO.
- DEFINE VARIABLE nTMwst AS DECIMAL NO-UNDO.
- DEFINE VARIABLE nTBrutto AS DECIMAL NO-UNDO.
- FIND FIRST tParam.
- nFakBetr = 0.
- IF iSeite = 0 THEN
- DO:
- RUN VIPER_INIT.
- SESSION:PRINTER-NAME = tParam.Drucker.
- END.
- FIND bDebst NO-LOCK
- WHERE bDebst.Firma = bSavko.Firma
- AND bDebst.Knr = bSavko.Fak_Knr.
- iBesrArt = bDebst.BESR_Art.
-
- RUN DRUCKEN_KOPF.
- iArtZeile = 1.
- RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_LSText', ' ' ).
- xString = TRIM(SUBSTRING(cFormText[17],21,20)) + ' / '
- + TRIM(SUBSTRING(cFormText[19],01,20)) + ' '
- + TRIM(STRING(bSavko.Aufnr,"zzzzzzzzz9")) + ' / '
- + TRIM(STRING(bSavko.Lief_Datum,"99.99.9999")).
- iArtZeile = 2.
- RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_LSText', xString ).
- RUN AUSGABE_GRUPPE ( 'FetteZeile' ).
- iArtZeile = 0.
- iVPagePos = vpr_getPageVPos() + 50.
- RUN vpr_setGroupVPos ( 'ArtikelZeile1', iVPagePos ).
-
- FOR EACH tSavze NO-LOCK
- BY tSavze.Aufnr
- BY tSavze.Sort1
- BY tSavze.LagOrt
- BY tSavze.Sort2
- BY tSavze.Pos :
-
- FIND Savze NO-LOCK WHERE RECID(Savze) = tSavze.Zeile.
-
- RUN ARTIKELZEILE ( RECID(tSavze) ).
- nFakBetr = nFakBetr + Savze.Net_Betr.
- RELEASE Savze.
- END.
- RUN AUSGABE_ARTIKELZEILE.
- iArtZeile = iArtZeile + 1.
- RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_1_Fett' , TRIM(SUBSTRING(cFormText[10],41,20)) ).
- RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Betrag_Fett', TRIM(STRING(nFakBetr,'->>>,>>9.99')) ).
- iArtZeile = iArtZeile + 1.
- RUN VIPER_CREATE_DOKUMENT ( 'FetteZeile', iArtZeile, 'Bez_1_Fett' , ' ' ).
- RUN AUSGABE_GRUPPE ( 'FetteZeile' ).
- /* Auftragsrabatt ---------------------------------------------------- */
-
- iArtZeile = 0.
- FOR EACH tRabSumm
- WHERE tRabSumm.Auf_Rab <> 0
- BY tRabSumm.Rab_Summ:
- Rundbetr = tRabSumm.Auf_Rab.
- nFakBetr = nFakBetr - Rundbetr.
- IF Rundbetr < 0 THEN RText = cZusText.
- ELSE RText = cRabText.
- xString = RText
- + " "
- + tRabSumm.Bez.
- iArtZeile = iArtZeile + 1.
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', xString ).
- FIND FIRST SavRabSu NO-LOCK USE-INDEX SavRabSu-k1
- WHERE SavRabSu.Firma = bSavko.Firma
- AND SavRabSu.Aufnr = bSavko.Aufnr
- AND SavRabSu.Rab_Summ = tRabSumm.Rab_Summ.
- nRabWert = ABSOLUT(SavRabSu.F_Wert).
- IF SavRabSu.F_Proz_Betr THEN WText = "%".
- ELSE WText = "Fr.".
- xString = STRING(nRabWert,"z9.99-")
- + WText.
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis', xString ).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(- Rundbetr,'->>>,>>9.99')) ).
- END.
- /* Abholrabatt ------------------------------------------------------- */
-
- FOR EACH tRabSumm WHERE tRabSumm.Abh_Rab <> 0
- BY tRabSumm.Rab_Summ:
- Rundbetr = tRabSumm.Abh_Rab.
- nFakBetr = nFakBetr - Rundbetr.
- IF Rundbetr < 0 THEN RText = cZusText.
- ELSE RText = cRabText.
- xString = RText
- + " "
- + tRabSumm.Bez.
- iArtZeile = iArtZeile + 1.
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', xString ).
- FIND FIRST SavRabSu NO-LOCK USE-INDEX SavRabSu-k1
- WHERE SavRabSu.Firma = bSavko.Firma
- AND SavRabSu.Aufnr = bSavko.Aufnr
- AND SavRabSu.Rab_Summ = tRabSumm.Rab_Summ.
- nRabWert = ABSOLUT(SavRabSu.A_Wert).
- IF SavRabSu.A_Proz_Betr THEN WText = "%".
- ELSE WText = "Fr.".
- xString = STRING(nRabWert,"z9.99-")
- + WText.
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis', xString ).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(- Rundbetr,'->>>,>>9.99')) ).
- END.
-
- /* Spezialpreis-Auftragsrabatte ---------------------------------------- */
-
- FOR EACH tSpeRab WHERE tSpeRab.Auf_Betr <> 0
- BY tSpeRab.Rab_Grp:
- FIND Tabel USE-INDEX Tabel-k1
- WHERE Tabel.Firma = cFirma
- AND Tabel.RecArt = 'ARABGRP'
- AND Tabel.CodeC = ''
- AND Tabel.CodeI = tSpeRab.Rab_Grp
- AND Tabel.Sprcd = 1 NO-LOCK.
- Rundbetr = tSpeRab.Auf_Betr.
- nFakBetr = nFakBetr - Rundbetr.
- IF Rundbetr < 0 THEN RText = cZusText.
- ELSE RText = cRabText.
- xString = RText
- + " "
- + Tabel.Bez1.
- iArtZeile = iArtZeile + 1.
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', xString ).
- FIND FIRST SavSpRab USE-INDEX SavSpRab-k1
- WHERE SavSpRab.Firma = bSavko.Firma
- AND SavSpRab.Aufnr = bSavko.Aufnr
- AND SavSpRab.Rab_Grp = tSpeRab.Rab_Grp NO-LOCK.
- nRabWert = ABSOLUT(SavSpRab.Auf_Wert).
- IF SavSpRab.Auf_Proz_Betr THEN WText = "%".
- ELSE WText = "Fr.".
- xString = STRING(nRabWert,"z9.99-")
- + WText.
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis', xString ).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(- Rundbetr,'->>>,>>9.99')) ).
- END.
-
- IF iArtZeile > 0 THEN
- DO:
- iArtZeile = iArtZeile + 1.
- xString = TRIM(SUBSTRING(cFormText[14],21,20)).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', xString ).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(nFakBetr,'->>>,>>9.99')) ).
- iArtZeile = iArtZeile + 1.
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', ' ' ).
- END.
- RUN AUSGABE_GRUPPE ('ArtikelZeile1').
-
- /* Recycling-Gebuehren ----------------------------------------------- */
- iArtZeile = 0.
- FOR EACH SavGKon NO-LOCK
- WHERE SavGKon.Firma = bSavko.Firma
- AND SavGKon.Aufnr = bSavko.Aufnr
- AND SavGKon.Gebuehr <> 0
- AND SavGKon.Betrag <> 0 :
- FIND GebKonto OF SavGKon NO-LOCK NO-ERROR.
- IF NOT AVAILABLE GebKonto THEN xString = TRIM(SUBSTRING(cFormText[11],41,20)).
- ELSE xString = GebKonto.Bez.
- iMwstCd = SavGKon.MWST_Cd.
- nFakBetr = nFakBetr + SavGKon.Betrag.
- FIND LAST MwstAns NO-LOCK
- WHERE MwstAns.Mwst_Cd = iMwstCd
- AND MwstAns.Datum <= bSavko.Fak_Datum NO-ERROR.
-
- iArtZeile = iArtZeile + 1.
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', xString ).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(SavGKon.Betrag,'->>>,>>9.99')) ).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'MC', STRING(SavGKon.MWSt_Cd,'z9') ).
-
- FIND FIRST tUmsGrp
- WHERE tUmsGrp.Ums_Grp = 1000
- AND tUmsGrp.Mwst = iMwstCd
- AND tUmsGrp.Ansatz = MwstAns.Ansatz NO-ERROR.
- IF NOT AVAILABLE tUmsGrp THEN
- DO:
- FIND WarenGrp USE-INDEX WarenGrp-k1
- WHERE WarenGrp.Firma = cFirma
- AND WarenGrp.Wgr = 1000 NO-LOCK NO-ERROR.
- CREATE tUmsGrp.
- ASSIGN
- tUmsGrp.Ums_Grp = 1000
- tUmsGrp.Mwst = iMwstCd
- tUmsGrp.Ansatz = MwstAns.Ansatz
- tUmsGrp.lInkl = lDebIncl
- tUmsGrp.Bez = (IF AVAILABLE WarenGrp THEN WarenGrp.Bez1 ELSE 'Recyclinggebühren').
- END.
- tUmsGrp.Ums_Betr = tUmsGrp.Ums_Betr + SavGKon.Betrag.
- END.
- IF iArtZeile > 0 THEN
- DO:
- iArtZeile = iArtZeile + 1.
- cText = TRIM(SUBSTRING(cFormText[14],41,20)).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', cText ).
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(nFakBetr,'->>>,>>9.99')) ).
- iArtZeile = iArtZeile + 1.
- RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', '' ).
- END.
- RELEASE SavGKon.
- RUN AUSGABE_GRUPPE ('ArtikelZeile1').
-
- /* Gebinde Aus- und Eingänge ---------------------------------------- */
- FOR EACH SavGKon NO-LOCK
- WHERE SavGKon.Firma = bSavko.Firma
- AND SavGKon.Aufnr = bSavko.Aufnr
- AND SavGKon.Depot <> 0
- AND SavGKon.Betrag <> 0 :
- FIND FIRST tGebKto WHERE tGebKto.Geb_Cd = SavGKon.Geb_Cd NO-ERROR.
- IF NOT AVAILABLE tGebKto THEN
- DO:
- FIND GebKonto NO-LOCK
- WHERE GebKonto.Firma = SavGKon.Firma
- AND GebKonto.Geb_Cd = SavGKon.Geb_Cd.
- CREATE tGebKto.
- ASSIGN
- tGebKto.Sort_Cd = GebKonto.Sort_Cd
- tGebKto.Geb_Cd = GebKonto.Geb_Cd
- tGebKto.Bez = GebKonto.Bez
- tGebKto.Preis = SavGKon.Depot
- tGebKto.MWST_Cd = SavGKon.MWSt_Cd.
- END.
- tGebKto.A_Anz = tGebKto.A_Anz + SavGKon.Ausgang.
- tGebKto.A_Betrag = tGebKto.A_Anz * tGebKto.Preis.
- tGebKto.E_Anz = tGebKto.E_Anz + SavGKon.Eingang.
- tGebKto.E_Betrag = tGebKto.E_Anz * tGebKto.Preis.
- END.
- RELEASE SavGKon.
-
- /* Gebindelieferungen ------------------------------------------------ */
- nBetrag = 0.
- iArtZeile = 0.
- FOR EACH SavGKon NO-LOCK
- WHERE SavGKon.Firma = bSavko.Firma
- AND SavGKon.Aufnr = bSavko.Aufnr
- AND SavGKon.Depot <> 0
- AND (SavGKon.Eingang <> 0 OR
- SavGKon.Ausgang <> 0)
-
- BREAK BY SavGKon.Firma
- BY SavGKon.Aufnr:
- iMwstCd = SavGKon.MWSt_Cd.
- FIND LAST MwstAns NO-LOCK
- WHERE MwstAns.Mwst_Cd = iMwstCd
- AND MwstAns.Datum <= bSavko.Fak_Datum NO-ERROR.
- FIND FIRST tUmsGrp
- WHERE tUmsGrp.Ums_Grp = 1001
- AND tUmsGrp.Mwst = iMwstCd
- AND tUmsGrp.Ansatz = MwstAns.Ansatz NO-ERROR.
- IF NOT AVAILABLE tUmsGrp THEN
- DO:
- FIND WarenGrp NO-LOCK USE-INDEX WarenGrp-k1
- WHERE WarenGrp.Firma = cFirma
- AND WarenGrp.Wgr = 1001 NO-ERROR.
- CREATE tUmsGrp.
- ASSIGN
- tUmsGrp.Ums_Grp = 1001
- tUmsGrp.Mwst = iMwstCd
- tUmsGrp.Ansatz = MwstAns.Ansatz
- tUmsGrp.lInkl = lDebIncl
- tUmsGrp.Bez = (IF AVAILABLE WarenGrp THEN WarenGrp.Bez1 ELSE 'Gebindesaldo').
- END.
- tUmsGrp.Ums_Betr = tUmsGrp.Ums_Betr + SavGKon.Betrag.
-
- FIND GebKonto NO-LOCK
- WHERE GebKonto.Firma = cFirma
- AND GebKonto.Geb_Cd = SavGKon.Geb_Cd.
- i1 = SavGKon.Ausgang - SavGKon.Eingang.
- Rundbetr = SavGKon.Betrag.
- iMwstCd = SavGKon.MWSt_Cd.
- nBetrag = nBetrag + Rundbetr.
- iArtZeile = iArtZeile + 1.
- RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'Gebindetext' , GebKonto.Bez ).
- RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'GebindeGel' , TRIM(STRING(SavGKon.Ausgang,"->>,>>9")) ).
- RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'GebindeRet' , TRIM(STRING(SavGKon.Eingang,"->>,>>9")) ).
- RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'GebindeSaldo', TRIM(STRING(i1 ,"->>,>>9")) ).
- RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'GebindeBetr' , TRIM(STRING(Rundbetr ,"->>,>>9.99")) ).
- RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'MC' , TRIM(STRING(SavGKon.MWSt_Cd,"z9")) ).
- END.
- RELEASE SavGKon.
- RELEASE GebKonto.
-
- IF iArtZeile > 0 THEN RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'GebindeTot', TRIM(STRING(nBetrag,"->>>,>>9.99")) ).
- nFakBetr = nFakBetr + nBetrag.
- IF iArtZeile > 0 THEN RUN AUSGABE_GRUPPE ('Gebindeabrechnung').
-
- /* Mehrwertsteuer ---------------------------------------------------- */
- nPfli = 0.
- nMwst = 0.
- i1 = 2.
- DO ii = 1 TO 11:
- IF bSavko.WPfl[ii] = 0 THEN NEXT.
- nPfli[ii] = bSavko.Wpfl[ii].
- nMwst[ii] = bSavko.Wust[ii].
- nFakBetr = nFakBetr + nMwst[ii].
- i1 = i1 + 1.
- END.
-
- iVPagePos = vpr_getPageVPos().
- IF (iVPagePos + (i1 * 40)) > iMaxPos THEN
- DO:
- RUN VIPER_NEUE_SEITE.
- RUN DRUCKEN_ADRESSE.
- END.
-
- iArtZeile = 1.
- RUN VIPER_CREATE_DOKUMENT ( 'Mehrwertsteuer', 1, 'MwstBez' , ' ' ).
- DO ii = 1 TO 11:
- IF nPfli[ii] = 0 THEN NEXT.
- FIND LAST MWSTAns USE-INDEX MWSTAns-k1
- WHERE MWSTAns.MWST_Cd = ii
- AND MWSTAns.Datum <= bSavko.Kond_Datum NO-LOCK.
- iArtZeile = iArtZeile + 1.
- RUN VIPER_CREATE_DOKUMENT ( 'Mehrwertsteuer', iArtZeile, 'MwstBez' , MWStAns.Bez ).
- RUN VIPER_CREATE_DOKUMENT ( 'Mehrwertsteuer', iArtZeile, 'MwstPfl' , TRIM(STRING(nPfli[ii],"->>,>>9.99")) ).
- RUN VIPER_CREATE_DOKUMENT ( 'Mehrwertsteuer', iArtZeile, 'MwstBetr', TRIM(STRING(nMwst[ii],"->>>,>>9.99")) ).
- RUN VIPER_CREATE_DOKUMENT ( 'Mehrwertsteuer', iArtZeile, 'MwstCd' , TRIM(STRING(ii ,"->>,>>9")) ).
- END.
- RUN AUSGABE_GRUPPE ( 'Mehrwertsteuer' ).
-
- /* Rechnungsbetrag --------------------------------------------------- */
- Rundbetr = nFakBetr.
- Rundcode = 1.
- RUN RUNDEN ( Rundcode, INPUT-OUTPUT Rundbetr ).
- nFakBetr = Rundbetr.
-
- iArtZeile = 1.
- RUN VIPER_CREATE_DOKUMENT ( 'RechnungsTotal', iArtZeile, 'EndBetrag', TRIM(STRING(nFakBetr,"->>>,>>9.99")) ).
- iArtZeile = 2.
- RUN VIPER_CREATE_DOKUMENT ( 'RechnungsTotal', iArtZeile, 'EndBetrag', ' ' ).
- RUN AUSGABE_GRUPPE ( 'RechnungsTotal' ).
- /* Zahlungskondition ------------------------------------------------- */
- FIND Kondi USE-INDEX Kondi-k1
- WHERE Kondi.Kond = bSavko.Kond
- AND Kondi.Sprcd = iSprcd NO-LOCK NO-ERROR.
- IF AVAILABLE Kondi THEN
- DO:
- iArtZeile = 1.
- RUN VIPER_CREATE_DOKUMENT ( 'Kondition', iArtZeile, 'Zahkond', Kondi.KoText ).
- RUN VIPER_CREATE_DOKUMENT ( 'Kondition', iArtZeile, 'Faellig', STRING((dFakDatum + Kondi.Faellig),"99.99.9999") ).
- IF Kondi.Skonto[01] <> 0 THEN
- DO:
- Rundbetr = bSavko.Sk_Ber * Kondi.Skonto[01] / 100.
- Rundcode = 1.
- RUN RUNDEN ( Rundcode, INPUT-OUTPUT Rundbetr ).
- RUN VIPER_CREATE_DOKUMENT ( 'Kondition', iArtZeile, 'Skonto', TRIM(STRING(Rundbetr,"->>>,>>9.99")) ).
- END.
- END.
- ELSE
- DO:
- iArtZeile = 1.
- RUN VIPER_CREATE_DOKUMENT ( 'Kondition', iArtZeile, 'Zahkond', FILL('?', 29) ).
- END.
- IF bSavko.Bar_Betr <> 0.00 THEN
- DO:
- RUN VIPER_CREATE_DOKUMENT ( 'Kondition', iArtZeile, 'Barbetrag', TRIM(STRING(bSavko.Bar_Betr ,"->>>,>>9.99")) ).
- RUN VIPER_CREATE_DOKUMENT ( 'Kondition', iArtZeile, 'Skonto' , TRIM(STRING(bSavko.Bar_Skonto,"->>>,>>9.99")) ).
- END.
- nFakBetr = nFakBetr - bSavko.Bar_Betr - bSavko.Bar_Skonto.
- RUN VIPER_CREATE_DOKUMENT ( 'Kondition', iArtZeile, 'Netto', TRIM(STRING(nFakBetr,"->>>,>>9.99")) ).
- RUN AUSGABE_GRUPPE ( 'Kondition' ).
-
- IF nFakBetr = 0 THEN Rundbetr = -1.
- ELSE Rundbetr = nFakBetr.
- IF AVAILABLE Kondi AND
- Kondi.Skonto[01] <> 0 THEN Rundbetr = 0.
- IF iLauf < iAnzDok THEN RETURN.
-
- /* BESR DRUCKEN ---------------------------- */
- FIND Bankst NO-LOCK
- WHERE Bankst.Bank = iBESRArt NO-ERROR.
- IF NOT AVAILABLE Bankst THEN
- DO:
- FIND FIRST Bankst NO-ERROR.
- END.
- IF AVAILABLE Bankst AND
- Bankst.QR-IBAN <> '' THEN
- DO:
- EMPTY TEMP-TABLE tSavko.
- CREATE tSavko.
- FIND FIRST Debop NO-LOCK
- WHERE Debop.Firma = bSavko.Firma
- AND Debop.Knr = bSavko.Fak_Knr
- AND Debop.Faknr = bSavKo.Faknr NO-ERROR.
- BUFFER-COPY bSavko TO tSavko
- ASSIGN
- tSavko.Auf_Tot = (IF AVAILABLE Debop THEN Debop.Fakbetr ELSE Rundbetr)
- tSavko.lBetrag = TRUE.
- RUN vpr_newPage.
- RUN DRUCKEN_QRCODE.
- END.
- ELSE
- DO:
- RUN DRUCKEN_BESR ( 'BESR' ).
- END.
-
-
- /* ------------------------------------------------------ */
- /* Druckausgabe */
- /* ------------------------------------------------------ */
-
- RUN vpr_EndDoc.
- cvpr_Dokument = SUBSTITUTE(cERPDokumente,
- cInstallation,
- 'Rechnungen',
- STRING(bSavko.Knr ,'999999'),
- STRING(bSavko.Faknr,'9999999'),
- tParam.cDokument ).
- RUN vpr_SaveDoc ( cvpr_Dokument ).
- DO WHILE tParam.lDokDruck:
- SESSION:PRINTER-NAME = tParam.Drucker NO-ERROR.
- IF SESSION:PRINTER-NAME <> tParam.Drucker THEN
- DO:
- RUN vpr_printerDialog ( OUTPUT lJa ).
- IF NOT lJa THEN LEAVE.
- END.
- RUN vpr_printDoc (0, 0).
- RUN vpr_resetDoc.
-
- LEAVE.
- END.
-
- IF tParam.lCreatePDF THEN
- DO:
- cPDFName = REPLACE(cvpr_Dokument, '.vpr', '.pdf').
- RUN vpr_openDoc ( cvpr_Dokument ).
- RUN vpr_printPDF ( 0, 0, INPUT-OUTPUT cPDFName ).
- END.
- IF tParam.lOpenPDF THEN
- DO:
- DEFINE VARIABLE o-i AS i NO-UNDO.
- FILE-INFO:FILE-NAME = cPDFName.
- cPDFName = FILE-INFO:FULL-PATHNAME.
- RUN ShellExecuteA (0,
- "open",
- cPDFName,
- "",
- "",
- 0,
- OUTPUT o-i).
- END.
-
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ENDIF
- &IF DEFINED(EXCLUDE-DRUCKEN_ADRESSE) = 0 &THEN
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DRUCKEN_ADRESSE Procedure
- PROCEDURE DRUCKEN_ADRESSE :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEFINE VARIABLE cZellen AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cWerte AS CHARACTER NO-UNDO.
-
- FIND FIRST tParam.
- FIND FIRST tDokument
- WHERE tDokument.cGruppe = 'KOPF'
- AND tDokument.iZeile = 1
- AND tDokument.cFeld = 'Seite' NO-ERROR.
- IF NOT AVAILABLE tDokument THEN
- DO:
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'KOPF'
- tDokument.iZeile = 1
- tDokument.cFeld = 'Seite'.
- END.
- tDokument.cInhalt = STRING(iSeite,'z9').
- cZellen = ''.
- cWerte = ''.
- FOR EACH tDokument
- WHERE tDokument.cGruppe = 'Kopf'
- BREAK BY tDokument.cGruppe
- BY tDokument.cFeld:
- cWerte = cWerte
- + tDokument.cInhalt.
- cZellen = cZellen
- + tDokument.cFeld.
- IF NOT LAST-OF ( tDokument.cGruppe ) THEN ASSIGN cWerte = cWerte + CHR(01)
- cZellen = cZellen + ','.
- END.
- RUN vpr_SetDelimiter (CHR(01)).
- RUN vpr_setGroupText ('Kopf', cZellen, cWerte).
- RUN vpr_FlushGroup ('Kopf').
- iVPagePos = vpr_getPageVPos().
- IF iSeite = 1 THEN
- DO:
- cZellen = ''.
- cWerte = ''.
- FOR EACH tDokument
- WHERE tDokument.cGruppe = 'KopfDetail'
- BREAK BY tDokument.cGruppe
- BY tDokument.cFeld:
- cWerte = cWerte
- + tDokument.cInhalt.
- cZellen = cZellen
- + tDokument.cFeld.
- IF NOT LAST-OF ( tDokument.cGruppe ) THEN ASSIGN cWerte = cWerte + CHR(01)
- cZellen = cZellen + ','.
- END.
- RUN vpr_SetDelimiter (CHR(01)).
- RUN vpr_setGroupText ('KopfDetail', cZellen, cWerte).
- RUN vpr_FlushGroup ('KopfDetail').
- RUN vpr_FlushGroup ('Ueberschrift').
- END.
- ELSE
- DO:
- iVPagePos = 930.
- RUN vpr_setGroupVPos ('Ueberschrift', iVPagePos).
- RUN vpr_FlushGroup ('Ueberschrift').
- END.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ENDIF
- &IF DEFINED(EXCLUDE-DRUCKEN_BESR) = 0 &THEN
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DRUCKEN_BESR Procedure
- PROCEDURE DRUCKEN_BESR :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEFINE INPUT PARAMETER ipDokument AS CHARACTER NO-UNDO.
- DEFINE VARIABLE ix AS INTEGER NO-UNDO.
- DEFINE VARIABLE i1 AS INTEGER NO-UNDO.
- DEFINE VARIABLE cFeld AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cInhalt AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cVorlage AS CHARACTER NO-UNDO.
- DEFINE VARIABLE iKopfZeile AS INTEGER NO-UNDO.
-
- DEFINE VARIABLE PZBetrag AS CHARACTER NO-UNDO.
- DEFINE VARIABLE PZReferenz AS CHARACTER NO-UNDO.
- DEFINE VARIABLE PZTNNummer AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cReferenz AS CHARACTER NO-UNDO.
-
- DEFINE BUFFER bViperDoc FOR ViperDoc.
-
- FIND FIRST tParam.
-
- /* IF Rundbetr < 0 THEN RETURN. */
-
- RUN vpr_NewPage.
-
- FIND bViperDoc NO-LOCK
- WHERE bViperDoc.Firma = bSavko.Firma
- AND bViperDoc.Benutzer = ''
- AND bViperDoc.Formular = ipDokument
- AND bViperDoc.DokArt = 0 NO-ERROR.
-
- cVorlage = tParam.cInstall + '/' + ipDokument + '.vfr'.
- RUN vpr_LoadVFR (cVorlage).
- RUN vpr_ActivateReport (ipDokument).
- RUN vpr_setPrinterAttrib("duplex=1").
- RUN vpr_SetDocAttrib ("PAPERSIZE=A4").
- RUN vpr_SetPrinterAttrib("copies=1").
- RUN vpr_InitGroups ("").
- /* IF tParam.lCreatePDF THEN RUN vpr_initGraphObj.*/
- RUN vpr_initGraphObj.
- IF bViperDoc.Schacht_Besr > 0 THEN RUN vpr_SetCurrentPageProperties ( "Papertray", bViperDoc.Schacht_Besr ).
-
- RELEASE bViperDoc.
- RUN vpr_SetGroupAttrib ("ADRESSE", "Fixed=true").
- RUN vpr_SetGroupAttrib ("BESR" , "Fixed=true").
-
- FIND Adresse NO-LOCK USE-INDEX Adresse-k1
- WHERE Adresse.Firma = AdFirma
- AND Adresse.Knr = bSavko.Fak_Knr NO-ERROR.
- iKopfZeile = 1.
- cBesrKopf = ''.
- IF bSavko.Adresse[05] <> '' THEN
- DO:
- i1 = 6.
- DO ix = 1 TO 5:
- /* CREATE tDokument. */
- /* ASSIGN tDokument.cGruppe = 'ADRESSE' */
- /* tDokument.iZeile = 1 */
- /* tDokument.cFeld = 'Adresse_' + STRING((6 + ix),'99') */
- /* tDokument.cInhalt = bSavko.Adresse[ix]. */
- i1 = i1 + 1.
- cBesrKopf[i1] = bSavko.Adresse[ix].
- END.
- END.
- ELSE
- DO:
- DO ix = 6 TO 11:
- /* CREATE tDokument. */
- /* ASSIGN tDokument.cGruppe = 'ADRESSE' */
- /* tDokument.iZeile = 1 */
- /* tDokument.cFeld = 'Adresse_' + STRING(ix,'99') */
- /* tDokument.cInhalt = Adresse.Anschrift[ix]. */
- cBesrKopf[ix] = Adresse.Anschrift[ix].
- END.
- END.
- DO ix = 6 TO 11:
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'BESR'
- tDokument.iZeile = 1
- tDokument.cFeld = 'Adresse_R_' + STRING(ix,'99')
- tDokument.cInhalt = cBesrKopf[ix].
- IF ix < 7 THEN NEXT.
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'BESR'
- tDokument.iZeile = 1
- tDokument.cFeld = 'Adresse_L_' + STRING(ix,'99')
- tDokument.cInhalt = cBesrKopf[ix].
- END.
- cFeld = ''.
- IF Rundbetr > 0.00 THEN
- DO:
- cFeld = STRING(Rundbetr,'zzzzzz9.99').
- cFeld = REPLACE(cFeld, '.', ' ').
- cFeld = STRING(cFeld,'X X X X X X X X X X').
- END.
- ELSE cFeld = ''.
- RUN VIPER_CREATE_DOKUMENT ( 'BESR', iKopfZeile, 'Betrag_L', cFeld ).
- RUN VIPER_CREATE_DOKUMENT ( 'BESR', iKopfZeile, 'Betrag_R', cFeld ).
-
- IF Rundbetr > 0 THEN PZBetrag = '01' + STRING(Rundbetr * 100,'9999999999 ').
- ELSE PZBetrag = ' 04 '.
- PZReferenz = '996665000000'
- + STRING(bSavko.Fak_Knr,'999999')
- + '0'
- + STRING(bSavko.Faknr ,'9999999')
- + ' '.
- PZTNNummer = '01000530'.
- RUN PRUEFZIFFER ( INPUT-OUTPUT PZBetrag, INPUT-OUTPUT PZReferenz, INPUT-OUTPUT PZTNNummer, OUTPUT cReferenz ).
- RUN VIPER_CREATE_DOKUMENT ( 'BESR', iKopfZeile, 'Referenz_OCRB', cReferenz ).
- RUN VIPER_CREATE_DOKUMENT ( 'BESR', iKopfZeile, 'Referenz_R', STRING(PZReferenz,'XX XXXXX XXXXX XXXXX XXXXX XXXXX') ).
- RUN VIPER_CREATE_DOKUMENT ( 'BESR', iKopfZeile, 'Referenz_L', STRING(PZReferenz,'XX XXXXX XXXXX XXXXX XXXXX XXXXX') ).
-
- RUN AUSGABE_GRUPPE ( 'ADRESSE' ).
- RUN AUSGABE_GRUPPE ( 'BESR' ).
-
- /* RUN vpr_EndDoc. */
- /* RUN vpr_printDoc (0, 0). */
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ENDIF
- &IF DEFINED(EXCLUDE-DRUCKEN_KOPF) = 0 &THEN
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DRUCKEN_KOPF Procedure
- PROCEDURE DRUCKEN_KOPF :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEFINE VARIABLE cText AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cString AS CHARACTER NO-UNDO.
- DEFINE VARIABLE ii AS INTEGER NO-UNDO.
- DEFINE VARIABLE i1 AS INTEGER NO-UNDO.
-
- FIND FIRST tParam.
- iFaknr = bSavko.Faknr.
- RUN VIPER_NEUE_SEITE.
- IF iSeite = 1 THEN
- DO:
- REPEAT WHILE bSavko.Faknr = 0 TRANSACTION:
- iFaknr = DYNAMIC-FUNCTION('createFaknr', bSavko.Firma ) NO-ERROR.
- IF RETURN-VALUE <> '' THEN NEXT.
- FIND Savko WHERE RECID(Savko) = RECID(bSavko).
- Savko.Faknr = iFaknr.
- RELEASE Savko.
- LEAVE.
- END.
-
- FIND bSteuer NO-LOCK WHERE bSteuer.Firma = cFirma.
-
- RUN VIPER_CREATE_DOKUMENT ( 'Kopf', 1, 'MWST_T', Steuer.Mwst_Nr ).
-
- cBesrKopf = ''.
- IF bSavko.Adresse[05] <> '' THEN
- DO:
- i1 = 6.
- DO ii = 1 TO 5:
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'KOPF'
- tDokument.iZeile = 1
- tDokument.cFeld = 'Adresse_' + STRING((6 + ii),'99')
- tDokument.cInhalt = bSavko.Adresse[ii].
- i1 = i1 + 1.
- cBesrKopf[i1] = bSavko.Adresse[ii].
- END.
- END.
- ELSE
- DO:
- DO ii = 5 TO 11:
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'KOPF'
- tDokument.iZeile = 1
- tDokument.cFeld = 'Adresse_' + STRING(ii,'99')
- tDokument.cInhalt = bAdresse.Anschrift[ii].
- cBesrKopf[ii] = bAdresse.Anschrift[ii].
- END.
- END.
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'KOPF'
- tDokument.iZeile = 1
- tDokument.cFeld = 'Ort_Datum'
- tDokument.cInhalt = TRIM(SUBSTRING(cFormText[07],01,20))
- + " "
- + STRING(dFakDatum,"99.99.9999").
- cString = (IF bSavko.Auf_Tot >= 0
- THEN TRIM(SUBSTRING(cFormText[02],01,20))
- ELSE TRIM(SUBSTRING(cFormText[02],21,20))).
- cString = cString
- + ' '
- + TRIM(STRING(iFaknr,'>>>>>>9')).
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'KOPF'
- tDokument.iZeile = 1
- tDokument.cFeld = 'T_Dokument'
- tDokument.cInhalt = cString.
-
- /* FIND FIRST tTabTexte WHERE tTabTexte.cRecArt = 'ABLAD' NO-ERROR. */
- /* CREATE tDokument. */
- /* ASSIGN tDokument.cGruppe = 'KOPFDETAIL' */
- /* tDokument.iZeile = 1 */
- /* tDokument.cFeld = 'Ablade' */
- /* tDokument.cInhalt = (IF AVAILABLE tTabTexte THEN tTabTexte.cFeld3 ELSE ' '). */
- /* */
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'KOPFDETAIL'
- tDokument.iZeile = 1
- tDokument.cFeld = 'Auf_Datum'
- tDokument.cInhalt = STRING(bSavko.Auf_Datum,'99.99.9999').
-
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'KOPFDETAIL'
- tDokument.iZeile = 1
- tDokument.cFeld = 'Lief_Datum'
- tDokument.cInhalt = STRING(bSavko.Lief_Datum,'99.99.9999').
-
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'KOPFDETAIL'
- tDokument.iZeile = 1
- tDokument.cFeld = 'U_Ref'
- tDokument.cInhalt = bSavko.U_Ref.
-
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'KOPFDETAIL'
- tDokument.iZeile = 1
- tDokument.cFeld = 'Knr'
- tDokument.cInhalt = STRING(bSavko.Knr,'999999').
-
- cText = ''.
- cText = (IF bAdresse.Tel-1 <> '' THEN bAdresse.Tel-1 ELSE bAdresse.Tel-2).
- IF bAdresse.Natel <> '' THEN cText = cText
- + (IF cText = '' THEN '' ELSE ' / ')
- + bAdresse.Natel.
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'KOPFDETAIL'
- tDokument.iZeile = 1
- tDokument.cFeld = 'Telefon'
- tDokument.cInhalt = cText.
-
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'KOPFDETAIL'
- tDokument.iZeile = 1
- tDokument.cFeld = 'Gewicht'
- tDokument.cInhalt = TRIM(STRING(bSavko.Gewicht,'->>>,>>9.999')).
- END.
-
- RUN DRUCKEN_ADRESSE.
-
- IF iSeite <> 1 THEN RETURN.
-
- cText = ''.
- IF bSavko.Abh_Text <> '' THEN
- DO:
- cText = bSavko.Abh_Text.
- END.
- IF bSavko.Auf_Text <> '' THEN
- DO:
- cText = cText
- + (IF cText <> '' THEN CHR(10) + CHR(10) ELSE '')
- + bSavko.Auf_Text.
- END.
- IF cText = '' THEN RETURN.
-
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = 'ZusatzText'
- tDokument.iZeile = 1
- tDokument.cFeld = 'Bemerkung_1'
- tDokument.cInhalt = cText.
-
- iVPagePos = vpr_getPageVPos() + 100.
- RUN vpr_setGroupVPos ( 'ZusatzText' , iVPagePos ).
- RUN AUSGABE_GRUPPE ( 'ZusatzText' ).
-
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ENDIF
- &IF DEFINED(EXCLUDE-FUELLEN_tSavze) = 0 &THEN
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE FUELLEN_tSavze Procedure
- PROCEDURE FUELLEN_tSavze :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEFINE INPUT PARAMETER ipAufnr AS INTEGER NO-UNDO.
- DEFINE VARIABLE minPos AS INTEGER NO-UNDO.
- DEFINE VARIABLE maxPos AS INTEGER NO-UNDO.
- DEFINE VARIABLE jPlatz AS INTEGER NO-UNDO.
- DEFINE VARIABLE cLagOrt AS CHARACTER NO-UNDO.
- DEFINE VARIABLE iRuestArt AS INTEGER NO-UNDO.
- DEFINE VARIABLE iPlusMinus AS INTEGER NO-UNDO.
- DEFINE VARIABLE lArtikel AS LOG NO-UNDO.
- DEFINE VARIABLE cSort AS CHARACTER NO-UNDO.
- EMPTY TEMP-TABLE tSavze.
-
- FIND Steuer NO-LOCK
- WHERE Steuer.Firma = cFirma NO-ERROR.
- IF AVAILABLE Steuer THEN iRuestArt = Steuer.RuestArt.
-
- ASSIGN
- minPos = 0
- maxPos = 9999
- iPlusMinus = 0
- jPlatz = 0.
-
- /* Kommentar zu Beginn eines Auftrages */
- lArtikel = FALSE.
- FOR EACH Savze NO-LOCK
- WHERE Savze.Firma = cFirma
- AND Savze.Aufnr = ipAufnr
- AND Savze.Pos > minPos:
- IF Savze.Artnr > 0 THEN
- DO:
- lArtikel = TRUE.
- LEAVE.
- END.
-
- minPos = Savze.Pos.
- CREATE tSavze.
- ASSIGN
- tSavze.Aufnr = Savze.Aufnr
- tSavze.Artnr = Savze.Artnr
- tSavze.Inhalt = Savze.Inhalt
- tSavze.Jahr = Savze.Jahr
- tSavze.Pos = Savze.Pos
- tSavze.Zeile = RECID(Savze)
- tSavze.Aktion = Savze.Aktion
- tSavze.Preis = Savze.Preis
- tSavze.MGeli = Savze.MGeli
- tSavze.MRuek = Savze.MRuek.
-
- ASSIGN
- tSavze.Sort1 = ''
- tSavze.Sort2 = ''
- tSavze.Sort3 = STRING(tSavze.Artnr ,'999999')
- + STRING(tSavze.Inhalt,'9999')
- + STRING(tSavze.Jahr ,'9999')
- + STRING(iPlusMinus ,'9')
- + STRING(tSavze.Pos ,'9999').
- tSavze.LagOrt = ''.
- END.
-
- /* Kommentar am Ende eines Auftrages */
- IF lArtikel THEN
- DO:
- FOR EACH Savze NO-LOCK
- WHERE Savze.Firma = cFirma
- AND Savze.Aufnr = ipAufnr
- BY Savze.Pos DESCENDING:
- IF Savze.Artnr > 0 THEN LEAVE.
-
- maxPos = Savze.Pos.
- CREATE tSavze.
- ASSIGN
- tSavze.Aufnr = Savze.Aufnr
- tSavze.Artnr = Savze.Artnr
- tSavze.Inhalt = Savze.Inhalt
- tSavze.Jahr = Savze.Jahr
- tSavze.Pos = Savze.Pos
- tSavze.Zeile = RECID(Savze)
- tSavze.Aktion = Savze.Aktion
- tSavze.Preis = Savze.Preis
- tSavze.MGeli = Savze.MGeli
- tSavze.MRuek = Savze.MRuek.
-
- ASSIGN
- tSavze.Sort1 = 'ZZZ'
- tSavze.Sort2 = ''
- tSavze.Sort3 = STRING(tSavze.Artnr ,'999999')
- + STRING(tSavze.Inhalt,'9999')
- + STRING(tSavze.Jahr ,'9999')
- + STRING(iPlusMinus ,'9')
- + STRING(tSavze.Pos ,'9999').
- tSavze.LagOrt = ''.
- END.
- END.
-
- /* Artikelzeilen nach WarenGruppe/ProdGruppen/Artikelgruppen */
- cLagOrt = ''.
- cSort = ''.
- FOR EACH Savze NO-LOCK
- WHERE Savze.Firma = cFirma
- AND Savze.Aufnr = ipAufnr
- AND Savze.Pos > minPos
- AND Savze.Pos < MaxPos
- BY Savze.Pos DESCENDING:
-
- IF Savze.Artnr > 0 THEN
- DO:
- FIND Artst NO-LOCK
- WHERE Artst.Firma = Savze.Firma
- AND Artst.Artnr = Savze.Artnr
- AND Artst.Inhalt = Savze.Inhalt
- AND Artst.Jahr = Savze.Jahr NO-ERROR.
- IF AVAILABLE Artst THEN cSort = STRING(Artst.Wg_Grp ,'9999')
- + STRING(Artst.Prod_Grp,'9999')
- + STRING(Artst.Art_Grp ,'9999').
- END.
- iPlusMinus = (IF Savze.MGeli < 0 THEN 1 ELSE 0).
- CREATE tSavze.
- ASSIGN
- tSavze.Aufnr = Savze.Aufnr
- tSavze.Artnr = Savze.Artnr
- tSavze.Inhalt = Savze.Inhalt
- tSavze.Jahr = Savze.Jahr
- tSavze.Pos = Savze.Pos
- tSavze.Zeile = RECID(Savze)
- tSavze.Aktion = Savze.Aktion
- tSavze.Preis = Savze.Preis
- tSavze.MGeli = Savze.MGeli
- tSavze.MRuek = Savze.MRuek.
-
- ASSIGN
- tSavze.Sort1 = cSort
- tSavze.Sort2 = ''
- tSavze.Sort3 = STRING(tSavze.Artnr ,'999999')
- + STRING(tSavze.Inhalt,'9999')
- + STRING(tSavze.Jahr ,'9999')
- + STRING(iPlusMinus ,'9')
- + STRING(tSavze.Pos ,'9999').
- tSavze.LagOrt = cLagort.
- END.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ENDIF
- &IF DEFINED(EXCLUDE-PRUEFZIFFER) = 0 &THEN
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE PRUEFZIFFER Procedure
- PROCEDURE PRUEFZIFFER :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- /* ------------------------------------------------------------------------- */
- /* Prufziffer MODULO 10, Rekursiv (27 Stellig Ref.-Nr.) */
- /* ------------------------------------------------------------------------- */
- /* */
- /* Uebergabe Variable: 1. String Betrag (12-stellig) */
- /* 2. String Referenz (27-stellig) */
- /* 3. String Teilnehmernummer ( 9-stellig) */
- /* */
- /* Erstellung der VESR-Codierzeile */
- /* */
- /*---------------------------------------------------------------------------*/
- DEFINE INPUT-OUTPUT PARAMETER PZBetrag AS CHARACTER FORMAT "x(13)".
- DEFINE INPUT-OUTPUT PARAMETER PZReferenz AS CHARACTER FORMAT "x(27)".
- DEFINE INPUT-OUTPUT PARAMETER PZTNummer AS CHARACTER FORMAT "x(09)".
- DEFINE OUTPUT PARAMETER VSZeile AS CHARACTER FORMAT "x(58)".
-
- DEFINE VARIABLE l1 AS INTEGER.
- DEFINE VARIABLE l2 AS INTEGER.
- DEFINE VARIABLE l3 AS INTEGER.
- DEFINE VARIABLE PZ AS INTEGER.
- DEFINE VARIABLE x1 AS INTEGER.
- DEFINE VARIABLE x2 AS INTEGER.
- DEFINE VARIABLE x3 AS INTEGER.
- DEFINE VARIABLE VMOD10 AS CHARACTER FORMAT "x(11)" EXTENT 11.
- VMOD10[01] = "09468271350".
- VMOD10[02] = "94682713509".
- VMOD10[03] = "46827135098".
- VMOD10[04] = "68271350947".
- VMOD10[05] = "82713509466".
- VMOD10[06] = "27135094685".
- VMOD10[07] = "71350946824".
- VMOD10[08] = "13509468273".
- VMOD10[09] = "35094682712".
- VMOD10[10] = "50946827131".
- l1 = 12.
- l2 = 26.
- l3 = 08.
- DO WHILE SUBSTRING(PZBetrag,01,01) <> " ": /* Mit Betrag */
- x2 = 1.
- x1 = INT(SUBSTRING(PZBetrag ,01 ,01)).
- x2 = INT(SUBSTRING(VMOD10[x2],x1 + 1,01)).
- DO x3 = 2 TO 12:
- x1 = INT(SUBSTRING(PZBetrag ,x3 ,01)).
- x2 = INT(SUBSTRING(VMOD10[x2 + 1],x1 + 1,01)).
- END.
- PZ = INT(SUBSTRING(VMOD10[x2 + 1],11,1)).
- SUBSTRING(PZBetrag,13) = STRING(PZ,"9").
- LEAVE.
- END.
- DO WHILE SUBSTRING(PZBetrag,01,01) = " ": /* Ohne Betrag */
- x2 = 11.
- x1 = INT(SUBSTRING(PZBetrag ,01 ,01)).
- x2 = INT(SUBSTRING(VMOD10[x2],x1 + 1,01)).
- DO x3 = 12 TO 12:
- x1 = INT(SUBSTRING(PZBetrag ,x3 ,01)).
- x2 = INT(SUBSTRING(VMOD10[x2 + 1],x1 + 1,01)).
- END.
- PZ = INT(SUBSTRING(VMOD10[x2 + 1],11,1)).
- SUBSTRING(PZBetrag,13) = STRING(PZ,"9").
- LEAVE.
- END.
- DO WHILE l2 = 26:
- x2 = 1.
- x1 = INT(SUBSTRING(PZReferenz,01 ,01)).
- x2 = INT(SUBSTRING(VMOD10[x2],x1 + 1,01)).
- DO x3 = 2 TO 26:
- x1 = INT(SUBSTRING(PZReferenz ,x3 ,01)).
- x2 = INT(SUBSTRING(VMOD10[x2 + 1],x1 + 1,01)).
- END.
- PZ = INT(SUBSTRING(VMOD10[x2 + 1],11,1)).
- SUBSTRING(PZReferenz,27) = STRING(PZ,"9").
- LEAVE.
- END.
- DO WHILE l3 = 08:
- x2 = 1.
- x1 = INT(SUBSTRING(PZTNummer ,01 ,01)).
- x2 = INT(SUBSTRING(VMOD10[x2],x1 + 1,01)).
- DO x3 = 2 TO 08:
- x1 = INT(SUBSTRING(PZTNummer ,x3 ,01)).
- x2 = INT(SUBSTRING(VMOD10[x2 + 1],x1 + 1,01)).
- END.
- PZ = INT(SUBSTRING(VMOD10[x2 + 1],11,1)).
- SUBSTRING(PZTNummer,09) = STRING(PZ,"9").
- LEAVE.
- END.
- VSZeile = "".
- SUBSTRING(VSZeile,01) = PZBetrag.
- SUBSTRING(VSZeile,14) = ">".
- SUBSTRING(VSZeile,15) = PZReferenz.
- SUBSTRING(VSZeile,42) = "+ ".
- SUBSTRING(VSZeile,44) = PZTNummer.
- SUBSTRING(VSZeile,53) = ">".
- /*
- SUBSTRING(VSZeile,58) = "H".
- */
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ENDIF
- &IF DEFINED(EXCLUDE-VIPER_CREATE_DOKUMENT) = 0 &THEN
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE VIPER_CREATE_DOKUMENT Procedure
- PROCEDURE VIPER_CREATE_DOKUMENT :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEFINE INPUT PARAMETER ipGruppe AS CHARACTER NO-UNDO.
- DEFINE INPUT PARAMETER ipZeile AS INTEGER NO-UNDO.
- DEFINE INPUT PARAMETER ipFeld AS CHARACTER NO-UNDO.
- DEFINE INPUT PARAMETER ipInhalt AS CHARACTER NO-UNDO.
-
- CREATE tDokument.
- ASSIGN
- tDokument.cGruppe = ipGruppe
- tDokument.iZeile = ipZeile
- tDokument.cFeld = ipFeld
- tDokument.cInhalt = ipInhalt.
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ENDIF
- &IF DEFINED(EXCLUDE-VIPER_INIT) = 0 &THEN
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE VIPER_INIT Procedure
- PROCEDURE VIPER_INIT :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEFINE VARIABLE cTemplate AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cDokument AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cZellen AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cZelle AS CHARACTER NO-UNDO.
- DEFINE VARIABLE cGruppe AS CHARACTER NO-UNDO.
- DEFINE VARIABLE ii AS INTEGER NO-UNDO.
- DEFINE VARIABLE cString AS CHARACTER NO-UNDO.
-
- FIND FIRST tParam.
- IF iLauf = 1 THEN
- DO:
- IF tParam.lCreatePDF THEN cDokument = tParam.cInstall + '/' + tParam.cDokument + '_logo.vfr'.
- ELSE cDokument = tParam.cInstall + '/' + tParam.cDokument + '.vfr'.
- RUN vpr_ResetDoc.
- RUN vpr_LoadVFR (cDokument).
- RUN vpr_ActivateReport (tParam.Template).
- RUN vpr_SelectPrinter (tParam.Drucker).
- RUN vpr_setPrinterAttrib('duplex=1').
- RUN vpr_SetPrinterAttrib('copies=1').
- RUN vpr_ResetDoc.
- RUN vpr_SetDocAttrib ('PAPERSIZE=A4').
- RUN vpr_SetPreviewMode ('Direct').
- RUN vpr_setDocTitle (tParam.cDokument).
- IF tParam.Schacht_Original > 0 THEN RUN vpr_SetCurrentPageProperties ( "Papertray", tParam.Schacht_Original ).
- END.
- ELSE
- DO:
- RUN vpr_NewPage.
- IF tParam.Schacht_Kopie > 0 THEN RUN vpr_SetCurrentPageProperties ( "Papertray", tParam.Schacht_Kopie ).
- END.
- RUN vpr_InitGroups("").
- RUN vpr_InitGraphObj.
-
- RUN vpr_SetGroupAttrib ("Kopf" , "Fixed=true").
- RUN vpr_SetGroupAttrib ("Fusstext" , "Fixed=true").
- RUN vpr_SetGroupAttrib ("Kondition", "Fixed=true").
-
- iMaxPos = 2600.
-
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ENDIF
- &IF DEFINED(EXCLUDE-VIPER_NEUE_SEITE) = 0 &THEN
- &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE VIPER_NEUE_SEITE Procedure
- PROCEDURE VIPER_NEUE_SEITE :
- /*------------------------------------------------------------------------------
- Purpose:
- Parameters: <none>
- Notes:
- ------------------------------------------------------------------------------*/
- DEFINE VARIABLE iPos AS INTEGER NO-UNDO.
-
- FIND FIRST tParam.
- DO WHILE TRUE:
- IF iSeite = 0 THEN
- DO:
- RUN vpr_InitGroups('').
- /* IF tParam.lCreatePDF THEN RUN vpr_initGraphObj.*/
- RUN vpr_initGraphObj.
- iSeite = iSeite + 1.
- LEAVE.
- END.
-
- RUN vpr_NewPage.
- RUN vpr_InitGroups('').
- IF iLauf = 1 THEN RUN vpr_SetCurrentPageProperties ( "Papertray", tParam.Schacht_Original ).
- ELSE RUN vpr_SetCurrentPageProperties ( "Papertray", tParam.Schacht_Kopie ).
- RUN vpr_InitGraphObj.
- iSeite = iSeite + 1.
- LEAVE.
- END.
-
- END PROCEDURE.
- /* _UIB-CODE-BLOCK-END */
- &ANALYZE-RESUME
- &ENDIF
|