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.Name1),l.Name1),'')))                                        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>" );

    }

?>