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>" );
    }
?>