Subversion-Projekte lars-tiefland.content-management

<?
    header( 'Content-Type: text/x-csv' );
    header( 'Content-Disposition: attachment; filename="logistik.txt"' );
    header( 'Expires: 0' );
    //header('Content-Type: application/editor');
    //$filename="logistik"; //.date("Ymd-His");
    //$ext="txt";
    //header('Content-Disposition: inline; filename="' . $filename . '.' . $ext . '"');
    //header('Expires: 0');
    //header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    //header('Pragma: public');

    define( "modul_name", "Warenwirtschaft" );
    define( "tool_name", "bestellung" );
    include "../Online-Shop/connect2.php";
    $POOL_VERTRAG_Inland = 1;
    $POOL_VERTRAG_Ausland = 53;
    if ( $web_rechte[modul_name]["bestellexport_dhl"]["dhl"] )
    {
        $inhalt = explode( ";", $web_rechte[modul_name]["bestellexport_dhl"]["dhl"] );
        foreach ( $inhalt as $row )
        {
            $zeile = explode( ":", $row );
            $name = $zeile[0];
            if ( $name == "POOL_VERTRAG" )
            {
                $POOL_VERTRAG_Inland = $zeile[1];
                $POOL_VERTRAG_Ausland = $zeile[2];
            }

        }
    }

    $query = "
                select
                        b.ID                                                                                                                    as POOL_REFNR,
                        b.shops_ID                                                                                                              as POOL_V_ABS_REFNR,
                        substring(b.Bemerkung,locate('\n',b.Bemerkung)+1)                               as POOL_V_ABS_BEMERKUNG,
                        '464338'                                                                                                                as POOL_V_MAND_REFNR,
                        if (b.liefer_Land!='',(if (b.liefer_Land='Deutschland','$POOL_VERTRAG_Inland','$POOL_VERTRAG_Ausland')),(if (l.Land='Deutschland','$POOL_VERTRAG_Inland','$POOL_VERTRAG_Ausland')))
                                                                                                                                                        as POOL_VERTRAG,
                        if (b.liefer_Str_Nr!='',b.liefer_Str_Nr,l.Hausnummer)                   as POOL_EMPF_HAUSNUMMER,
                        floor(a.short_line_2)                                                                                   as POOL_V_PRODUKT_CN,
                        a.short_line_2                                                                                                  as POOL_V_xxxxx,
                        'EUR'                                                                                                                   as POOL_V_NN_WAEHRUNG,
                        'EUR'                                                                                                                   as POOL_WERT_WAEHRUNG,
                        l.ID                                                                                                                    as POOL_EMPF_REFNR,
                        if (b.liefer_Name!='',(if (b.liefer_Firma='',if(b.liefer_Vorname!='',concat(b.liefer_Vorname,' ', b.liefer_Name),b.liefer_Name),b.liefer_Firma)),(if (l.Name2='',trim(concat(l.Vorname,' ',l.Name1)),l.Name2)))                                 as POOL_EMPF_NAME1,
                        if (b.liefer_Firma!='',b.liefer_Name,(if(l.Name2='',if(l.Vorname!='',concat(l.Vorname,' ',l.Name2),l.Name2),'')))                                                       as POOL_EMPF_NAME2,
                        if (b.liefer_PLZ!='',b.liefer_PLZ,l.PLZ)                                                as POOL_EMPF_PLZ,
                        if (b.liefer_Ort!='',b.liefer_Ort,l.ORT)                                                as POOL_EMPF_ORT,
                        if (b.liefer_Strasse!='',b.liefer_Strasse,l.Strasse)                    as POOL_EMPF_STRASSE,
                        if (b.liefer_Land!='',b.liefer_Land,l.Land)                                             as POOL_EMPF_LANDCODE,
                        l.E_Mail                                                                                                                as POOL_EMPF_MAIL,
                        ab.ID                                                                                                                   as ID,
                        IF (ab.Bezeichnung LIKE '%Nachnahme%', CONCAT('134=',b.gesamtsumme_buffer),'') as POOL_V_EXTRASLST,
                        l.Telefon                                                                                                               as POOL_EMPF_TEL
                        
                from
                        Bestellung AS b,
                        artikel_to_Bestellung AS ab,
                        artikel AS a,
                        Logins AS l
                where
                        (a.Father =-3)
                        and
                        (a.ID=ab.artikel)
                        and
                        (ab.Bestellung = b.ID)
                        and
                        (b.Login = l.ID)
                        and
                        (b.Language = a.Language)
                ";
    if ( $_GET[time] )
    {
        $query .= " and (ab.exported  = '" . $_GET[time] . "')";
    }
    else
    {
        $query .= " and (ab.status  = 'freigegeben')";
    }
    $firstline = false;
    $trenner = "|";
    $result = mysql_query( $query ) or die( mysql_errno() . ": " .
        mysql_error() . "<hr>$query<hr>" );

    $elements = array();

    while ( $zeile = mysql_fetch_assoc( $result ) )
    {
        $elements[] = $zeile[ID];
        unset( $zeile[ID] );

        if ( $firstline )
        {
            echo implode( array_keys( $zeile ), $trenner ) . "\n\n ";
            $firstline = false;
        }

        $result_gesBetrag = mysql_query( "
                        select
                                artikel_to_Bestellung.*,
                                (Menge * Preis_pro_Stueck) as gesBetrag,
                (Menge * gewicht) as gesGewicht,
                                artikel.kurzbezeichnung,
                                artikel.Father
                        from
                                artikel_to_Bestellung,
                                artikel
                        where
                                artikel_to_Bestellung.Bestellung=$zeile[POOL_REFNR]
                                and
                                artikel_to_Bestellung.artikel = artikel.ID
                                and
                                artikel.Language = 'DE'
                        order by artikel.Father desc
                " ) or die( mysql_errno() . ": " . mysql_error() . "<hr>$query<hr>" );
        $gesBetrag = 0;
        $gesGewicht = 0;
        $buffer = array();
        while ( $zeile_gesBetrag = mysql_fetch_assoc( $result_gesBetrag ) )
        {
            if ( $zeile_gesBetrag["Bezeichnung"] )
            {
                $zeile_gesBetrag["kurzbezeichnung"] = $zeile_gesBetrag["Bezeichnung"];
            }

            if ( $zeile_gesBetrag["Father"] > -3 )
            {
                $buffer[] = $zeile_gesBetrag["Menge"] . "x " . strip_tags( $zeile_gesBetrag["kurzbezeichnung"] );
            }
            $gesBetrag += $zeile_gesBetrag["gesBetrag"];
            $gesGewicht += $zeile_gesBetrag["gesGewicht"];
        }
        $gesBetrag = number_format( $gesBetrag, 2, ',', '.' );
        $gesGewicht = number_format( $gesGewicht, 2, ',', '.' );
        $zeile["POOL_EMPF_BEMERKUNG"] = implode( ", ", $buffer ) . "|" . $gesBetrag .
            "|" . $gesGewicht;

        eval( "\$zeile[POOL_V_EXTRASLST]=\"$zeile[POOL_V_EXTRASLST]\";" );

        /*
        $translate['Deutschland']               ="DE";
        $translate['Niederlande']               ="NL";
        $translate['Österreich']               ="AT";
        $translate['Belgien']                   ="BE";
        $translate['Luxemburg']                 ="LU";
        $translate['Dänemark']                 ="DK";
        $translate['Schweiz']                   ="CH";
        $translate['Frankreich']                ="FR";
        $translate['Großbritannien']   ="GB";
        $translate['Italien']                   ="IT";
        $translate['Spanien']                   ="ES";
        $translate['Portugal']                  ="PT";
        $translate['Schweden']                  ="SE";
        $translate['Finnland']                  ="FI";
        $translate['Norwegen']                  ="NO";
        $translate['Irland']                    ="IE";
        $translate['Griechenland']              ="GR";
        $translate['Nederland']                 ="NL";
        $zeile[POOL_EMPF_LANDCODE]=$translate[$zeile[POOL_EMPF_LANDCODE]];
        */

        echo preg_replace( "/[\r\n]/", " ", implode( $zeile, $trenner ) ) .
            "\n";
    }

    if ( ( count( $elements ) > 0 ) and ( !$_GET[time] ) )
    {
        $query =
            "update artikel_to_Bestellung set exported=NOW(), status='versand' where ID=" .
            implode( $elements, " or ID=" ) . "";
        $result = mysql_query( $query ) or die( mysql_errno() . ": " .
            mysql_error() . "<hr>$query<hr>" );
    }
?>