&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 NO-UNDO INIT FALSE. DEFINE VARIABLE lLast AS LOG NO-UNDO INIT FALSE. DEFINE VARIABLE lPreis AS LOG NO-UNDO. DEFINE VARIABLE lEnde AS LOG NO-UNDO INIT FALSE. 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 iWgr AS INTEGER NO-UNDO. DEFINE VARIABLE iPgr AS INTEGER NO-UNDO. DEFINE VARIABLE iAgr AS INTEGER NO-UNDO. DEFINE VARIABLE iArtnr AS INTEGER NO-UNDO. DEFINE VARIABLE iInhalt AS INTEGER NO-UNDO. DEFINE VARIABLE iJahr 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 VARIABLE VWg_Grp AS INTEGER INIT 0 NO-UNDO. DEFINE VARIABLE VProd_Grp AS INTEGER INIT 0 NO-UNDO. DEFINE VARIABLE VArt_Grp AS INTEGER INIT 0 NO-UNDO. DEFINE VARIABLE AArtnr AS INTEGER INIT 0 NO-UNDO. DEFINE VARIABLE AInhalt AS INTEGER INIT 0 NO-UNDO. DEFINE VARIABLE AJahr AS INTEGER INIT 0 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 LAdresse FOR Adresse . DEFINE BUFFER bAdresse FOR Adresse . DEFINE BUFFER bWust FOR Wust . DEFINE BUFFER bSteuer FOR Steuer . { incl/ttdruckparam.i } { incl/properties.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 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 /* ************************ Function Prototypes ********************** */ &IF DEFINED(EXCLUDE-calculateBlock) = 0 &THEN &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD calculateBlock Procedure FUNCTION calculateBlock RETURNS INTEGER (ipGruppe AS CHARACTER) FORWARD. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ENDIF /* *********************** 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 = 15 WIDTH = 60. /* END WINDOW DEFINITION */ */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK Procedure /* *************************** Main Block *************************** */ opcResult = ''. CREATE tParam. htParam:BUFFER-COPY(iphParam). IF tParam.lSendMail THEN ASSIGN tParam.lDokDruck = FALSE tParam.lCreatePDF = TRUE tParam.lOpenPDF = FALSE. ASSIGN cFirma = tParam.cFirma iAnzDok = tParam.Anzahl lPreis = TRUE. 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.cDokument, 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. 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-FUELLEN_UEBERSCHRIFT) = 0 &THEN &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE FUELLEN_UEBERSCHRIFT Procedure PROCEDURE FUELLEN_UEBERSCHRIFT: /*------------------------------------------------------------------------------ Purpose: Notes: ------------------------------------------------------------------------------*/ DEFINE VARIABLE cZellen AS CHARACTER NO-UNDO. DEFINE VARIABLE cWerte AS CHARACTER NO-UNDO. CREATE tDokument. ASSIGN tDokument.cGruppe = 'UEBERSCHRIFT' tDokument.iZeile = 1 tDokument.cFeld = 'Artnr_T' tDokument.cInhalt = ENTRY(1, cFormText[23], ';'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'UEBERSCHRIFT' tDokument.iZeile = 1 tDokument.cFeld = 'VGeb_Menge_T' tDokument.cInhalt = ENTRY(2, cFormText[23], ';'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'UEBERSCHRIFT' tDokument.iZeile = 1 tDokument.cFeld = 'VGeb_T' tDokument.cInhalt = ENTRY(3, cFormText[23], ';'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'UEBERSCHRIFT' tDokument.iZeile = 1 tDokument.cFeld = 'KGeb_Menge_T' tDokument.cInhalt = ENTRY(4, cFormText[23], ';'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'UEBERSCHRIFT' tDokument.iZeile = 1 tDokument.cFeld = 'KGeb_T' tDokument.cInhalt = ENTRY(5, cFormText[23], ';'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'UEBERSCHRIFT' tDokument.iZeile = 1 tDokument.cFeld = 'Bez_T' tDokument.cInhalt = ENTRY(6, cFormText[23], ';'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'UEBERSCHRIFT' tDokument.iZeile = 1 tDokument.cFeld = 'Alk%_T' tDokument.cInhalt = ENTRY(7, cFormText[23], ';'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'UEBERSCHRIFT' tDokument.iZeile = 1 tDokument.cFeld = 'JG_T' tDokument.cInhalt = ENTRY(8, cFormText[23], ';'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'UEBERSCHRIFT' tDokument.iZeile = 1 tDokument.cFeld = 'Preis_T' tDokument.cInhalt = ENTRY(9, cFormText[23], ';'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'UEBERSCHRIFT' tDokument.iZeile = 1 tDokument.cFeld = 'Betrag_T' tDokument.cInhalt = ENTRY(10, cFormText[23], ';'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'UEBERSCHRIFT' tDokument.iZeile = 1 tDokument.cFeld = 'MC_T' tDokument.cInhalt = ENTRY(11, cFormText[23], ';'). cZellen = ''. cWerte = ''. FOR EACH tDokument WHERE tDokument.cGruppe = 'Ueberschrift' 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 ('Ueberschrift', cZellen, cWerte). 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: 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.Bez2 <> '' 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', STRING(Savze.VGeb_Me,'->>,>>9') ). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'VGebinde' , VGebinde.KBez ). END. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Menge' , STRING(Savze.MGeli,'->>,>>9') ). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'KGebinde', KGebinde.KBez ). 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)) + Savze.Aktion_Text. END. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', cString ). IF Savze.Jahr > 9 THEN DO: cString = STRING(Savze.Jahr,"9999"). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'JG', cString ). END. IF Savze.Alk_Gehalt <> 0 THEN DO: cString = STRING(Savze.Alk_Gehalt,"zz9.9%"). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Alk%', cString ). END. DO WHILE lPreis : 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 LEAVE. 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")) ). LEAVE. END. DO WHILE lPreis: 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%. 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: Notes: ------------------------------------------------------------------------------*/ DEFINE VARIABLE iAufnr AS INTEGER NO-UNDO. 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.Aufnr = tParam.iAufnr : iFaknr = Savko.Faknr. tParam.iFaknr = iFaknr. CREATE sSavko. ASSIGN sSavko.cFirma = Savko.Firma sSavko.iAufnr = Savko.Aufnr sSavko.iFak_Knr = Savko.Fak_Knr sSavko.iKnr = Savko.Knr sSavko.iKnr = Savko.Knr sSavko.iSamm_Nr = 0 sSavko.iRecid = RECID(Savko) sSavko.iFaknr = iFaknr sSavko.dFakDat = Savko.Fak_Datum. RELEASE Savko. RELEASE bSavko. 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: 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(). 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 RUN vpr_Asc2RTF ( tDokument.cInhalt, '', OUTPUT tDokument.cInhalt).*/ IF tDokument.cFeld = 'Bez1' THEN tDokument.cInhalt = REPLACE(tDokument.cInhalt, CHR(10), '\par '). 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 ('ArtikelZeile1', cZellen, cWerte). iVPagePos = vpr_getPageVPos(). iPos = iVPagePos + vpr_getGroupHeight('ArtikelZeile1'). IF iPos > iMaxPos THEN DO: RUN VIPER_NEUE_SEITE. 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: 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 VIPER_NEUE_SEITE. /* iVPagePos = vpr_getPageVPos(). */ /* RUN vpr_setPageVPos ( iVPagePos ).*/ 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: Notes: ------------------------------------------------------------------------------*/ DEFINE VARIABLE cText 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. FIND FIRST tParam. IF tParam.lBatch THEN DO: ASSIGN tParam.lOpenPDF = FALSE. END. lEnde = FALSE. FIND FIRST tSavko NO-ERROR. IF NOT AVAILABLE tSavko THEN CREATE tSavko. BUFFER-COPY bSavko TO tSavko ASSIGN tSavko.iRecid = RECID(bSavko) tSavko.lBetrag = FALSE. nFakBetr = 0. IF iSeite = 0 THEN RUN VIPER_INIT. RUN DRUCKEN_KOPF. 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. iArtZeile = iArtZeile + 1. cText = TRIM(SUBSTRING(cFormText[10],41,20)). RUN vpr_asc2rtf ( cText, 'bold', OUTPUT cText). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1' , cText ). cText = TRIM(STRING(nFakBetr,'->>>,>>9.99')). RUN vpr_asc2rtf ( cText, 'bold', OUTPUT cText). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', cText ). iArtZeile = iArtZeile + 1. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1' , ' ' ). RUN AUSGABE_ARTIKELZEILE. /* Auftragsrabatt ---------------------------------------------------- */ iArtZeile = 0. ii = 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. cText = RText + " " + tRabSumm.Bez. iArtZeile = iArtZeile + 1. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', cText ). 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.". cText = STRING(nRabWert,"z9.99-") + WText. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis', cText ). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(- Rundbetr,'->>>,>>9.99')) ). ii = ii + 1. END. IF ii > 0 THEN RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis', ' ' ). /* Abholrabatt ------------------------------------------------------- */ ii = 0. 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. cText = RText + " " + tRabSumm.Bez. iArtZeile = iArtZeile + 1. ii = ii + 1. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', cText ). 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.". cText = STRING(nRabWert,"z9.99-") + WText. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis', cText ). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(- Rundbetr,'->>>,>>9.99')) ). END. /* Spezialpreis-Auftragsrabatte ---------------------------------------- */ ii = 0. 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. cText = RText + " " + Tabel.Bez1. iArtZeile = iArtZeile + 1. ii = ii + 1. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', cText ). 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.". cText = STRING(nRabWert,"z9.99-") + WText. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Preis', cText ). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(- Rundbetr,'->>>,>>9.99')) ). END. /* Total nach Abzug des Auftrag- / Abhol-Rabattes --------------------- */ IF iArtZeile > 0 THEN DO: iArtZeile = iArtZeile + 1. cText = TRIM(SUBSTRING(cFormText[14],21,20)). RUN vpr_asc2rtf ( cText, 'bold', OUTPUT cText). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', cText ). cText = TRIM(STRING(nFakBetr,'->>>,>>9.99')). RUN vpr_asc2rtf ( cText, 'bold', OUTPUT cText). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', cText ). iArtZeile = iArtZeile + 1. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', ' ' ). END. IF iArtZeile > 0 THEN DO: ii = DYNAMIC-FUNCTION ('calculateBlock':U, 'ArtikelZeile1') NO-ERROR. ii = ii + vpr_getPageVPos() + 50. IF ii > (iMaxPos) THEN DO: RUN VIPER_NEUE_SEITE. END. RUN AUSGABE_ARTIKELZEILE. END. /* 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 cText = TRIM(SUBSTRING(cFormText[11],41,20)). ELSE cText = GebKonto.Bez. iMwstCd = SavGKon.MWST_Cd. nFakBetr = nFakBetr + SavGKon.Betrag. iArtZeile = iArtZeile + 1. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', cText ). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', TRIM(STRING(SavGKon.Betrag,'->>>,>>9.999')) ). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'MC', STRING(SavGKon.MWSt_Cd,'z9') ). END. IF iArtZeile > 0 THEN DO: iArtZeile = iArtZeile + 1. cText = TRIM(SUBSTRING(cFormText[14],41,20)). RUN vpr_asc2rtf ( cText, 'bold', OUTPUT cText). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', cText ). cText = TRIM(STRING(nFakBetr,'->>>,>>9.999')). RUN vpr_asc2rtf ( cText, 'bold', OUTPUT cText). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', cText ). iArtZeile = iArtZeile + 1. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', ' ' ). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Betrag', ' ' ). END. RELEASE SavGKon. /* Gebinde Aus- und Eingänge ---------------------------------------- */ IF FDebst.Geb_Rg THEN DO: 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. 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: 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")) ). IF lPreis THEN RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'GebindeBetr' , TRIM(STRING(Rundbetr ,"->>,>>9.999")) ). END. RELEASE SavGKon. RELEASE GebKonto. IF lPreis AND iArtZeile > 0 THEN DO: RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'GebindeTot' , TRIM(STRING(nBetrag ,"->>>,>>9.999")) ). iArtZeile = iArtZeile + 1. RUN VIPER_CREATE_DOKUMENT ( 'Gebindeabrechnung', iArtZeile, 'GebindeTot' , ' ' ). END. nFakBetr = nFakBetr + nBetrag. END. IF iArtZeile > 0 THEN DO: ii = DYNAMIC-FUNCTION ('calculateBlock':U, 'ArtikelZeile1') NO-ERROR. ii = ii + DYNAMIC-FUNCTION ('calculateBlock':U, 'Gebindeabrechnung') NO-ERROR. ii = ii + vpr_getPageVPos() + 50. IF ii > (iMaxPos) THEN DO: RUN VIPER_NEUE_SEITE. END. RUN AUSGABE_GRUPPE ( 'ArtikelZeile1' ). RUN AUSGABE_GRUPPE ( 'Gebindeabrechnung' ). END. /* 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. iArtZeile = 0. 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, 'Rechnungsbetrag_T', 'Rechnungsbetrag inkl. Mehrwertsteuer' ). RUN VIPER_CREATE_DOKUMENT ( 'RechnungsTotal', iArtZeile, 'EndBetrag', TRIM(STRING(nFakBetr,"->>>,>>9.99")) ). FIND FIRST Kondi NO-LOCK WHERE Kondi.Kond = bSavko.Kond. IF Kondi.Skonto[01] <> 0 THEN DO: Rundbetr = bSavko.Sk_Ber * Kondi.Skonto[01] / 100. Rundcode = 1. RUN RUNDEN ( Rundcode, INPUT-OUTPUT Rundbetr ). iArtZeile = iArtZeile + 1. RUN VIPER_CREATE_DOKUMENT ( 'RechnungsTotal', iArtZeile, 'Rechnungsbetrag_T', ' ' ). iArtZeile = iArtZeile + 1. RUN VIPER_CREATE_DOKUMENT ( 'RechnungsTotal', iArtZeile, 'Rechnungsbetrag_T', 'Skontoabzug' ). RUN VIPER_CREATE_DOKUMENT ( 'RechnungsTotal', iArtZeile, 'EndBetrag', TRIM(STRING(Rundbetr,"->>>,>>9.99")) ). Rundbetr = nFakBetr - Rundbetr. iArtZeile = iArtZeile + 1. RUN VIPER_CREATE_DOKUMENT ( 'RechnungsTotal', iArtZeile, 'Rechnungsbetrag_T', 'Barzahlungsbetrag' ). RUN VIPER_CREATE_DOKUMENT ( 'RechnungsTotal', iArtZeile, 'EndBetrag', TRIM(STRING(Rundbetr,"->>>,>>9.99")) ). END. iArtZeile = iArtZeile + 1. RUN VIPER_CREATE_DOKUMENT ( 'RechnungsTotal', iArtZeile, 'Rechnungsbetrag_T', Kondi.KoText ). RUN AUSGABE_GRUPPE ( 'RechnungsTotal' ). /* /* Gebinderücknahmetabelle ------------------------------------------- */ */ /* */ /* DEFINE VARIABLE xString AS CHARACTER NO-UNDO. */ /* */ /* iArtZeile = 0. */ /* xString = SUBSTITUTE('GEBINDERETOUR&1', STRING(bSavko.Fak_Art,'99')). */ /* cText = ''. */ /* */ /* FIND TabTexte NO-LOCK USE-INDEX TabTexte-k1 */ /* WHERE TabTexte.Firma = bSavko.Firma */ /* AND TabTexte.TextArt = xString */ /* AND TabTexte.Sprcd = iSprcd NO-ERROR. */ /* IF NOT AVAILABLE TabTexte THEN */ /* DO: */ /* FIND TabTexte NO-LOCK USE-INDEX TabTexte-k1 */ /* WHERE TabTexte.Firma = bSavko.Firma */ /* AND TabTexte.TextArt = xString */ /* AND TabTexte.Sprcd = 1 NO-ERROR. */ /* END. */ /* IF NOT AVAILABLE TabTexte THEN */ /* DO: */ /* xString = 'GEBINDERETOUR'. */ /* FIND TabTexte NO-LOCK USE-INDEX TabTexte-k1 */ /* WHERE TabTexte.Firma = bSavko.Firma */ /* AND TabTexte.TextArt = xString */ /* AND TabTexte.Sprcd = iSprcd NO-ERROR. */ /* END. */ /* IF NOT AVAILABLE TabTexte THEN */ /* DO: */ /* FIND TabTexte NO-LOCK USE-INDEX TabTexte-k1 */ /* WHERE TabTexte.Firma = bSavko.Firma */ /* AND TabTexte.TextArt = xString */ /* AND TabTexte.Sprcd = 1 NO-ERROR. */ /* END. */ /* IF AVAILABLE TabTexte THEN cText = TabTexte.Inhalt. */ /* */ /* IF cText <> '' THEN */ /* DO: */ /* RUN vpr_asc2rtf ( cText, '', OUTPUT cText ). */ /* RUN VIPER_CREATE_DOKUMENT ( 'GebindeRuecknahme', 1, 'GebindeRuecknahme_T' , cText ).*/ /* ii = DYNAMIC-FUNCTION ('calculateBlock':U, 'GebindeRuecknahme') NO-ERROR. */ /* ii = ii + vpr_getPageVPos() + 150. */ /* IF ii > (iMaxPos) THEN */ /* DO: */ /* RUN VIPER_NEUE_SEITE. */ /* iVPagePos = vpr_getPageVPos() + 75. */ /* END. */ /* ELSE iVPagePos = vpr_getPageVPos() + 150. */ /* */ /* RUN vpr_setPageVPos ( iVPagePos ). */ /* RUN vpr_setGroupVPos ( 'GebindeRuecknahme', iVPagePos ). */ /* RUN AUSGABE_GRUPPE ( 'GebindeRuecknahme' ). */ /* END. */ /* */ lEnde = TRUE. RUN VIPER_NEUE_SEITE. IF iLauf < iAnzDok THEN DO: RUN vpr_EndDoc. /* IF tParam.lDokDruck THEN RUN vpr_PrintDoc ( 0, 0 ).*/ RETURN. END. /* ------------------------------------------------------ */ /* Druckausgabe */ /* ------------------------------------------------------ */ IF bSavko.Auf_Tot > 0 THEN DO: RUN vpr_newPage. RUN DRUCKEN_QRCODE. END. RUN vpr_EndDoc. /* IF tParam.lDokDruck THEN RUN vpr_printDoc ( 0, 0 ).*/ cvpr_Dokument = SUBSTITUTE(cERPDokumente, tParam.cInstall, 'Rechnungen', SUBSTITUTE('&1-&2_&3.vpr', STRING(bSavko.Knr ,'999999'), STRING(bSavko.Faknr,'9999999'), tParam.cDokument) ). RUN vpr_SaveDoc ( cvpr_Dokument ). IF tParam.lCreatePDF THEN DO: cPDFName = REPLACE(cvpr_Dokument, '.vpr', '.pdf'). 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: Notes: ------------------------------------------------------------------------------*/ DEFINE VARIABLE cZellen AS CHARACTER NO-UNDO. DEFINE VARIABLE cWerte AS CHARACTER NO-UNDO. DEFINE VARIABLE iPos AS INTEGER 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'). 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'). END. iPos = vpr_getGroupVPos('KopfDetail'). iVPagePos = vpr_getCellVPos('Seite_T', 'Kopf') + vpr_getCellHeight('Seite_T', 'Kopf'). IF iPos > iVPagePos THEN iVPagePos = iPos. iVPagePos = iVPagePos + 20. RUN vpr_setGroupVPos ( 'Ueberschrift', iVPagePos ). RUN vpr_FlushGroup ( 'Ueberschrift' ). iPos = vpr_getGroupVPos('Ueberschrift') + vpr_getGroupHeight('Ueberschrift'). RUN vpr_setPageVPos ( iPos ). 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_QRCODE : /*------------------------------------------------------------------------------*/ /* Purpose: */ /* Parameters: */ /* 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/wiederkehr/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. tSavko.lBetrag = FALSE. 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. /* FILE-INFO:FILE-NAME = cFileName. */ /* cFileName = FILE-INFO:FULL-PATHNAME.*/ 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'). RUN vpr_printdoc ( vpr_getPageNo(), vpr_getPageNo() ). /* RUN vpr_ActivateReport (tParam.cDokument).*/ 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: Notes: ------------------------------------------------------------------------------*/ DEFINE VARIABLE cText AS CHARACTER NO-UNDO. DEFINE VARIABLE ii AS INTEGER NO-UNDO. DEFINE VARIABLE i1 AS INTEGER NO-UNDO. FIND FIRST tParam. RUN VIPER_NEUE_SEITE. IF iSeite = 1 THEN DO: iFaknr = tParam.iFaknr. 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 = 'T_Dokument' tDokument.cInhalt = (IF bSavko.Auf_Tot >= 0 THEN TRIM(SUBSTRING(cFormText[02],01,20)) ELSE TRIM(SUBSTRING(cFormText[02],21,20))). tDokument.cInhalt = tDokument.cInhalt + ' ' + STRING(iFaknr,'z999999'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'KOPF' tDokument.iZeile = 1 tDokument.cFeld = 'Ort_Datum' tDokument.cInhalt = TRIM(SUBSTRING(cFormText[07],01,20)) + " " + STRING(TODAY,"99.99.9999"). /* Kundennummer */ CREATE tDokument. ASSIGN tDokument.cGruppe = 'KOPFDETAIL' tDokument.iZeile = 1 tDokument.cFeld = 'Knr_T' tDokument.cInhalt = ENTRY(1, cFormText[24], ';'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'KOPFDETAIL' tDokument.iZeile = 1 tDokument.cFeld = 'Knr' tDokument.cInhalt = STRING(bSavko.Knr,'999999'). /* Gewicht */ CREATE tDokument. ASSIGN tDokument.cGruppe = 'KOPFDETAIL' tDokument.iZeile = 1 tDokument.cFeld = 'Gewicht_T' tDokument.cInhalt = ENTRY(3, cFormText[19], ';'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'KOPFDETAIL' tDokument.iZeile = 1 tDokument.cFeld = 'Gewicht' tDokument.cInhalt = TRIM(STRING(bSavko.Gewicht,'->>>,>>9.999')). /* Bestellt am */ CREATE tDokument. ASSIGN tDokument.cGruppe = 'KOPFDETAIL' tDokument.iZeile = 1 tDokument.cFeld = 'Bestellt_T' tDokument.cInhalt = ENTRY(2, cFormText[20], ';'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'KOPFDETAIL' tDokument.iZeile = 1 tDokument.cFeld = 'Auf_Datum' tDokument.cInhalt = STRING(bSavko.Auf_Datum,'99.99.9999'). /* Lieferdatum */ CREATE tDokument. ASSIGN tDokument.cGruppe = 'KOPFDETAIL' tDokument.iZeile = 1 tDokument.cFeld = 'Geliefert_T' tDokument.cInhalt = ENTRY(3, cFormText[20], ';'). CREATE tDokument. ASSIGN tDokument.cGruppe = 'KOPFDETAIL' tDokument.iZeile = 1 tDokument.cFeld = 'Lief_Datum' tDokument.cInhalt = STRING(bSavko.Lief_Datum,'99.99.9999'). /* Auftragstext, Abladevorschrift, Abholtext */ cText = ''. IF bSavko.Auf_Text <> '' THEN cText = cText + (IF cText = '' THEN '' ELSE CHR(10) ) + bSavko.Auf_Text. FIND FIRST tTabTexte WHERE tTabTexte.cRecArt = 'ABLAD' NO-ERROR. IF AVAILABLE tTabTexte THEN DO: IF tTabTexte.cFeld3 <> '' THEN cText = cText + (IF cText = '' THEN '' ELSE CHR(10) + CHR(10) ) + tTabTexte.cFeld3. END. IF bSavko.Abh_Text <> '' THEN cText = cText + (IF cText = '' THEN '' ELSE CHR(10) + CHR(10) ) + bSavko.Abh_Text. IF cText <> '' THEN DO: RUN vpr_asc2rtf ( cText, '', OUTPUT cText). CREATE tDokument. ASSIGN tDokument.cGruppe = 'KOPFDETAIL' tDokument.iZeile = 1 tDokument.cFeld = 'Kopftexte' tDokument.cInhalt = cText. END. /* Seitentext */ CREATE tDokument. ASSIGN tDokument.cGruppe = 'KOPF' tDokument.iZeile = 1 tDokument.cFeld = 'Seite_T' tDokument.cInhalt = ENTRY(2, cFormText[24], ';'). END. RUN DRUCKEN_ADRESSE. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ENDIF &IF DEFINED(EXCLUDE-DRUCKEN_RUECKSTAND) = 0 &THEN &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE DRUCKEN_RUECKSTAND Procedure PROCEDURE DRUCKEN_RUECKSTAND : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEFINE INPUT PARAMETER ipRecid AS RECID NO-UNDO. DEFINE VARIABLE cString AS CHARACTER NO-UNDO. FIND tRueckst WHERE RECID(tRueckst) = ipRecid NO-LOCK. FIND Savze WHERE RECID(Savze) = tRueckst.Zeile NO-LOCK. iArtZeile = iArtZeile + 1. DO WHILE Savze.Artnr = 0: CREATE tDokument. ASSIGN tDokument.cGruppe = 'ArtikelZeile1' tDokument.iZeile = iArtZeile tDokument.cFeld = 'Bez1' tDokument.cInhalt = Savze.Bez1. IF Savze.Bez2 <> '' THEN DO: iArtZeile = iArtZeile + 1. CREATE tDokument. ASSIGN tDokument.cGruppe = 'ArtikelZeile1' tDokument.iZeile = iArtZeile tDokument.cFeld = 'Bez1' tDokument.cInhalt = Savze.Bez2. END. RETURN. END. FIND Artst OF Savze NO-LOCK. 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, 'KGebinde', KGebinde.Kbez ). IF Savze.VGeb_Ru <> 0 THEN DO: cString = STRING(Savze.VGeb_Ru,'->>>>') + 'x ' + VGebinde.KBez. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'VGebinde', cString ). END. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Menge', STRING(Savze.MRuek,'->>,>>9') ). cString = Savze.Bez1. IF Savze.Bez2 <> '' THEN cString = cString + (IF cString = '' THEN '' ELSE CHR(10)) + Savze.Bez2. IF Savze.Aktion THEN cString = cString + (IF cString = '' THEN '' ELSE CHR(10)) + Savze.Aktion_Text. RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Bez1', cString ). IF Savze.Jahr > 9 THEN DO: cString = STRING(Savze.Jahr,"9999"). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'JG', cString ). END. IF Savze.Alk_Gehalt <> 0 THEN DO: cString = STRING(Savze.Alk_Gehalt,"zz9.9%"). RUN VIPER_CREATE_DOKUMENT ( 'ArtikelZeile1', iArtZeile, 'Alk%', cString ). END. RUN AUSGABE_GRUPPE ( 'ArtikelZeile1' ). RELEASE Savze . RELEASE Artst . RELEASE VGebinde. RELEASE KGebinde. 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: 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 INIT 1. 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. /* 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 = STRING(0,'99') tSavze.Sort2 = '' tSavze.Sort3 = STRING(tSavze.Artnr ,'999999') + STRING(tSavze.Inhalt,'9999') + STRING(tSavze.Jahr ,'9999') + STRING(iPlusMinus ,'9') + STRING(tSavze.Pos ,'99999') 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 ,'99999') tSavze.LagOrt = ''. END. END. /* Artikelzeilen nach Lagerort/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. FIND ArtLager NO-LOCK WHERE ArtLager.Firma = Savze.Firma AND ArtLager.Artnr = Savze.Artnr AND ArtLager.Inhalt = Savze.Inhalt AND ArtLager.Jahr = Savze.Jahr AND ArtLager.Lager = Savze.Lager NO-ERROR. IF AVAILABLE ArtLager THEN cLagOrt = ArtLager.Ort. ASSIGN iWgr = Artst.Wg_Grp iPgr = Artst.Prod_Grp iAgr = Artst.Art_Grp iArtnr = Artst.Artnr iInhalt = Artst.Inhalt iJahr = Artst.Jahr. END. cSort = STRING(iWgr,'9999') + STRING(iPgr,'9999') + STRING(iAgr,'9999'). 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 = cLagOrt tSavze.Sort2 = cSort tSavze.Sort3 = STRING(iArtnr ,'999999') + STRING(iInhalt ,'9999') + STRING(iJahr ,'9999') + STRING(iPlusMinus,'9') + STRING(tSavze.Pos,'99999') 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: 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-SEND_MAIL) = 0 &THEN &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SEND_MAIL Procedure PROCEDURE SEND_MAIL : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEFINE INPUT PARAMETER ipAttachment AS CHARACTER NO-UNDO. FIND FIRST tParam. DEFINE VARIABLE cTo AS CHARACTER NO-UNDO. DEFINE VARIABLE cCc AS CHARACTER NO-UNDO. DEFINE VARIABLE lRetValue AS LOG NO-UNDO. DEFINE VARIABLE cMeldung AS CHARACTER NO-UNDO. DEFINE VARIABLE cSubject AS CHARACTER NO-UNDO. DEFINE VARIABLE cBody AS CHARACTER NO-UNDO. DEFINE VARIABLE cQuittung AS CHARACTER NO-UNDO. DEFINE VARIABLE cName AS CHARACTER NO-UNDO. DEFINE VARIABLE ii AS INTEGER NO-UNDO. DEFINE VARIABLE iInd AS INTEGER NO-UNDO. DEFINE VARIABLE cNamen AS CHARACTER NO-UNDO. FIND FIRST tParam. FIND Adresse NO-LOCK WHERE Adresse.Firma = AdFirma AND Adresse.Knr = tParam.iKnr NO-ERROR. cTo = Adresse.Mail. cTo = 'rs@adprime.ch'. cCc = 'wr@adprime.ch'. IF cTo = '' THEN RETURN. IF INDEX(cTo, '@') = 0 THEN RETURN. cSubject = SUBSTITUTE('Rechnung &1 vom &2', tParam.iFaknr, STRING(TODAY,'99.99.9999') ). cBody = SUBSTITUTE('Im Anhang die Rechnung von der Lieferung vom &1 ', STRING(TODAY,'99.99.9999') ). cQuittung = SUBSTITUTE('&1&2-&3-Quittung.pdf', cPathQuittung, STRING(tParam.iKnr,'999999'), STRING(tParam.iAufnr,'9999999')). FILE-INFO:FILE-NAME = cQuittung. cQuittung = FILE-INFO:FULL-PATHNAME NO-ERROR. IF cQuittung = ? THEN cQuittung = ''. IF cQuittung <> '' THEN DO: ipAttachment = ipAttachment + (IF ipAttachment = '' THEN '' ELSE ';') + cQuittung. END. DO ii = 1 TO NUM-ENTRIES(ipAttachment, ';'): cName = ENTRY(ii, ipAttachment, ';'). cName = REPLACE(cName, '\', '/'). IF R-INDEX(cName, '/') > 0 THEN cName = SUBSTRING(cName, R-INDEX(cName, '/') + 1). cNamen = cNamen + (IF cNamen = '' THEN '' ELSE ';') + cName. END. /* EMPTY TEMP-TABLE ttSendMail. */ /* CREATE ttSendMail. */ /* ASSIGN */ /* ttSendMail.cFrom = cMailFromFreigabe */ /* ttSendMail.cTo = cTo */ /* ttSendMail.cCC = cCC /* cMailCCFreigabe*/ */ /* ttSendMail.cSubject = cSubject */ /* ttSendMail.cBody = cBody */ /* ttSendMail.cAttachedName = cNamen */ /* ttSendMail.cAttachedFile = ipAttachment */ /* ttSendMail.cMailServer = cMailServer */ /* ttSendMail.cMailPort = cMailPort */ /* ttSendMail.cMailKonto = cMailKonto */ /* ttSendMail.cMailPassw = cMailPassw */ /* ttSendMail.cDomaine = cMailDomaine */ /* ttsendmail.lAuth = lMailAuth */ /* ttSendMail.lSSLEnabled = lSSLEnabled. */ /* */ /* RUN sendsmtpmail.p ( httSendMail, OUTPUT cMeldung, OUTPUT lRetValue ).*/ RETURN cMeldung. 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: 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: 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 = iAnzDok AND tParam.lCreatePDF THEN DO: cDokument = tParam.cInstall + '/' + tParam.cDokument + '_pdf.vfr'. cTemplate = tParam.cDokument + '_pdf'. END. ELSE DO: cDokument = tParam.cInstall + '/' + tParam.cDokument + '.vfr'. cTemplate = tParam.cDokument. END. RUN vpr_LoadVFR (cDokument). RUN vpr_ActivateReport (cTemplate). IF iLauf = 1 THEN DO: 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"). iMaxPos = 2800. 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: Notes: ------------------------------------------------------------------------------*/ DEFINE VARIABLE iPos AS INTEGER NO-UNDO. DEFINE VARIABLE cTempDateiName AS CHARACTER NO-UNDO. FIND FIRST tParam. DO WHILE TRUE: IF iSeite = 0 THEN DO: RUN vpr_InitGroups(''). iSeite = iSeite + 1. RUN FUELLEN_UEBERSCHRIFT. LEAVE. END. IF tParam.lDokDruck THEN DO: RUN vpr_SetCurrentPageProperties ( "Papertray", tParam.Schacht_Original ). RUN vpr_printdoc ( iSeite, iSeite ). PAUSE 0.2 NO-MESSAGE. RUN vpr_SetCurrentPageProperties ( "Papertray", tParam.Schacht_Kopie ). RUN vpr_printdoc ( iSeite, iSeite ). END. IF NOT lEnde THEN DO: RUN vpr_NewPage. RUN vpr_InitGroups(''). iSeite = iSeite + 1. RUN DRUCKEN_ADRESSE. END. LEAVE. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ENDIF /* ************************ Function Implementations ***************** */ &IF DEFINED(EXCLUDE-calculateBlock) = 0 &THEN &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION calculateBlock Procedure FUNCTION calculateBlock RETURNS INTEGER ( ipGruppe AS CHARACTER ): /*------------------------------------------------------------------------------ Purpose: Notes: ------------------------------------------------------------------------------*/ DEF VAR cZellen AS CHAR NO-UNDO. DEF VAR cWerte AS CHAR NO-UNDO. DEF VAR iSpace AS INT NO-UNDO. DEF VAR iGrpHo AS INT NO-UNDO. FOR EACH tDokument WHERE tDokument.cGruppe = ipGruppe BREAK BY tDokument.cGruppe BY tDokument.iZeile : 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_setGroupText (ipGruppe, cZellen, cWerte). iGrpHo = vpr_getGroupHeight ( ipGruppe ). iSpace = iSpace + iGrpHo. END. /* RUN vpr_InitGroups(ipGruppe).*/ RETURN iSpace. END FUNCTION. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ENDIF