WebSVN – lars-tiefland.content-management – /trunk/Warenwirtschaft/bestellung_formular.php

<?php

    /**
     * @package   Kein Projekt geladen
     * @author     <>
     * @copyright 2009 
     * @license   propietary http://www.weban.de
     * @version   $Rev: 4258 $
     * @filesource
     * 
     */

    /**
     * 
     * @package   Kein Projekt geladen
     * @author     <>
     * @copyright 2009 
     */

    define( "FROM_BESTELLUNG", true );
    // SVN: $Id: bestellung_formular.php 4258 2012-03-30 10:33:23Z tiefland $

    if ( stristr( $_SERVER["HTTP_USER_AGENT"], "ipad" ) || stristr( $_SERVER["HTTP_USER_AGENT"],
        "iphone" ) )
    {
        $GLOBALS["ui"]->assign( "ipad", true );
    }

    require_once "includes/bestellungen/system/artikelDatabase.php";
    require_once "../Online-Shop/connect2.php";
    require_once "../includes/system/functions.lagerwirtschaft.php"; //PL

    $preise_anzeigen = 1;
    $preise_nicht_drucken = 0;
    $d_colspan = "";

    if ( isset( $web_rechte[modul_name][tool_name]["preise_anzeigen"] ) )
    {
        if ( !isset( $user_rechte[modul_name][tool_name]["preise_anzeigen"] ) )
        {
            // "<br>für bestimmte user preis verbergen";
            $preise_anzeigen = 0;
        }
    }
    if ( isset( $_POST["Bestellung"] ) )
    {
        $b_id = $_POST["Bestellung"];
    }
    else
    {
        $b_id = $_GET["Bestellung"];
    }
    bestellung_puffern( $b_id );



    //weban_debug(isset( $web_rechte["Warenwirtschaft"]["bestellung"]["adressbuch"] ));
    if ( isset( $web_rechte["Warenwirtschaft"]["bestellung"]["adressbuch"] ) )
    {
        $sql = "SELECT
                ship_addr_id,
                bill_addr_id
            FROM
                Bestellung AS b
            WHERE
                b.ID=$b_id
        ";
        $res = mysql_query( $sql );
        $row = mysql_fetch_assoc( $res );
        $bill_addr_id = $row["bill_addr_id"];
        $ship_addr_id = $row["ship_addr_id"];
        if ( $bill_addr_id )
        {
            $sql = "SELECT
                    Anrede,
                    Vorname,
                    Nachname AS Name1,
                    Firma AS Name2,
                    Strasse1 AS Strasse,
                    Str_Nr1 AS Hausnummer,
                    strasse2,
                    PLZ,
                    Ort AS ORT,
                    country AS Land,
                    comment
                FROM
                    adresse AS a
                JOIN
                    countries AS c
                ON
                    c.ID=a.Land
                WHERE
                    a.id = $bill_addr_id
            ";
            $res = mysql_query( $sql );
            $bill_addr = mysql_fetch_assoc( $res );
        }
        if ( $ship_addr_id )
        {
            $sql = "SELECT
                    Anrede AS liefer_Anrede,
                    Vorname AS liefer_Vorname,
                    Nachname AS liefer_Name,
                    Firma AS liefer_Firma,
                    Strasse1 AS liefer_Strasse,
                    Str_Nr1 AS liefer_Str_Nr,
                    strasse2 AS liefer_strasse2,
                    PLZ AS liefer_PLZ,
                    Ort AS liefer_Ort,
                    country AS liefer_Land,
                    comment AS liefer_comment
                FROM
                    adresse AS a
                JOIN
                    countries AS c
                ON
                    c.ID=a.Land
                WHERE
                    a.id = $ship_addr_id
            ";
            $res = mysql_query( $sql );
            $ship_addr = mysql_fetch_assoc( $res );
        }
    }
    $sql = "
            SELECT
                b.*,
                                -- l.Status,
                                -- l.user,
                                -- l.passwd,
                                l.Telefon,
                                l.Fax,
                                l.E_Mail,
    ";
    if ( !isset( $web_rechte["Warenwirtschaft"]["bestellung"]["adressbuch"] ) )
    {
        $sql .= "        
                                l.Anrede,
                                l.Vorname,
                                l.Name1,
                                l.Name2,
                                l.Strasse,
                                l.Hausnummer,
                                l.PLZ,
                                l.ORT,
                                l.Land,
                                l.AP_Name,
                                l.AP_Handy,
                                l.AP_Bemerkung,
        ";
    }
    if ( isset( $web_rechte["Warenwirtschaft"]["bestellung"]["waehrung"] ) )
    {
        $sql .= "
                c.locale,
        ";
    }
    if ( $bestellarten )
    {
        $sql .= "
                ba.name AS Bestellart,
        ";
    }
    $sql .= "
                s.Name AS shop,
                s.ID AS shops_ID,
                b.gesamtsumme_buffer
            FROM
                                Bestellung AS b,
    ";
    if ( $bestellarten )
    {
        $sql .= "
                bestellart AS ba,
        ";
    }
    if ( isset( $web_rechte["Warenwirtschaft"]["bestellung"]["waehrung"] ) )
    {
        $sql .= "
                currencies c,
        ";
    }
    $sql .= "
                                Logins AS l,
                shops AS s
    ";
    $sql .= "
            WHERE
                                b.ID = $Bestellung
            AND
                                l.ID = b.Login
            AND
                s.ID = b.shops_ID
    ";
    if ( isset( $web_rechte["Warenwirtschaft"]["bestellung"]["waehrung"] ) )
    {
        $sql .= "
            AND
                c.id=b.currency
        ";
    }
    if ( $bestellarten )
    {
        $sql .= "
            AND
                ba.ID=b.bestellart_id
        ";
    }
    $res = mysql_query( $sql );
    if ( !$res )
    {
        echo weban_debug( mysql_error() . "<br>$sql" );
    }
    $row = mysql_fetch_assoc( $res );
    $zeile = $row;
    if ( isset( $web_rechte["Warenwirtschaft"]["bestellung"]["adressbuch"] ) )
    {
        $row = array_merge( $row, $bill_addr, $ship_addr );
    }
    /*if ( isset( $user_rechte["Warenwirtschaft"]["bestellung"]["fremd_id"] ) &&
    $zeile["fremd_id"] )
    {*/
    $d_colspan = "colspan=\"2\"";
    //}
    $row["kk_info"] = unserialize( $row["kk_info"] );
    $row["kk_summe"] = $row["gesamtsumme_buffer"] * 100;
    $daten["Bestellung"] = $row;
    $daten["Bestellung"]["artikel"] = array();
    $Userdata = $zeile;
    $bufferLand = $row["liefer_Land"];
    if ( empty( $bufferLand ) )
    {
        $bufferLand = $row["Land"];
    }

    $versandItems = getVersandItems( $row["shops_ID"], $row["Language"], $bufferLand );

    //var_dump($versandItems);

    if ( $versandItems != array() )
    {
        $daten["Versand"] = array();
        $daten["Versand"][] = "";
        foreach ( $versandItems as $versandOption )
        {
            $daten["Versand"][base64_encode( serialize( $versandOption ) )] = $versandOption["kurz"];
        }
    }

    $erstellt_am = datetime2human( $zeile["erstellt_am"] );
    $Datum = $erstellt_am["Datum"];
    $Zeit = $erstellt_am["Zeit"];
    $Username = $_SERVER["PHP_AUTH_USER"];
    $Username_text = $_SESSION["USERNAME"];
    $Auftragsnummer = $Bestellung;
    $Heute = date( "d.m.Y" );
    $jetzt = date( "H:i" );

    $BestellID = $row["ID"];
    $shops_ID = $row["shops_ID"];
    $Artikelliste = createOrderText( $BestellID, $shops_ID );
    $Artikelliste_html = createOrderText_html( $BestellID, $shops_ID );
    $Artikelliste_html_v2 = createOrderText_html_v2( $BestellID, $shops_ID );
    $Bestellwert_brutto = Bestellwert_brutto( $BestellID, $shops_ID );

    if ( $bestellart )
    {
        $query = "
            SELECT 
                * 
            FROM 
                $settings_table 
            WHERE 
                bestellart_id=" . $zeile["bestellart_id"] . " 
            AND
                shops_ID = $shops_ID
            ORDER BY 
                Rang";
    }
    else
    {
        $query = "
            SELECT 
                * 
            FROM 
                $settings_table 
            WHERE
                shops_ID = $shops_ID
            ORDER BY 
                Rang";
    }

    $result_w = mysql_query_logged( $query ) or die( mysql_errno() . ": " .
        mysql_error() . "<hr>$query<hr>" );
    if ( !mysql_num_rows( $result_w ) && $bestellart )
    {
        $query = "SELECT 
                * 
            FROM 
                $settings_table 
            WHERE
                shops_ID = $shops_ID
            AND
                bestellart_id=1
            ORDER BY 
                Rang
        ";
        $result_w = mysql_query_logged( $query ) or die( mysql_errno() . ": " .
            mysql_error() . "<hr>$query<hr>" );
    }
    while ( $zeile_w = mysql_fetch_assoc( $result_w ) )
    {
        //        $web_settings[$zeile_w["shops_ID"]][$zeile_w["ID"]] = $zeile_w["Inhalt"];
        $buffer = $zeile_w["Inhalt"];
        $wsID = $zeile_w["ID"];
        if ( $wsID != 1000 )
        {
            if ( strpos( $buffer, '"' ) !== false )
            {
                $buffer = str_replace( '"', "***", $buffer );
            }
            @eval( "\$buffer=\"$buffer\";" );
            if ( strpos( $buffer, '***' ) !== false )
            {

                $buffer = str_replace( '***', '"', $buffer );
            }
        }
        $web_settings[$shops_ID][$wsID] = rawurlencode( $buffer );
    }

    $summe = 0;
    $runner = 0;
    $mahnungStatus = 0;
    $garantieStatus = 0;
    if ( isset( $web_rechte['Warenwirtschaft']['bestellung']['mahnungStatus'] ) &&
        $web_rechte['Warenwirtschaft']['bestellung']['mahnungStatus'] )
    {
        $mahnungStatus = 1;
    }
    if ( isset( $web_rechte['Warenwirtschaft']['bestellung']['garantieStatus'] ) &&
        $web_rechte['Warenwirtschaft']['bestellung']['garantieStatus'] )
    {
        $garantieStatus = 1;
    }


    $cmd_buttons = array(
        array(
            'O',
            'offen',
            'status_red',
            'artikelStatus',
            0 ),
        array(
            'B',
            'in Bearbeitung',
            'status_yellow',
            'artikelStatus',
            0 ),
        array(
            'R',
            'reserviert',
            'status_blue',
            'artikelStatus',
            0 ),
        array(
            'E',
            'erledigt',
            'status_green',
            'artikelStatus',
            0 ),
        array(
            'A',
            'abgeschlossen',
            'status_white',
            'artikelStatus',
            0 ),
        str_repeat( "&nbsp;", 3 ),
        array(
            'S',
            'schreiben',
            'status_red',
            'rechnungStatus',
            6 ),
        array(
            'G',
            'geschrieben',
            'status_yellow',
            'rechnungStatus',
            6 ),
        array(
            'B',
            'bezahlt',
            'status_green',
            'rechnungStatus',
            6 ),
        str_repeat( "&nbsp;", 3 ),
        array(
            'S',
            'schreiben',
            'status_yellow',
            'lieferscheinStatus',
            0 ),
        array(
            'G',
            'geschrieben',
            'status_green',
            'lieferscheinStatus',
            0 ),
        array(
            'O',
            'offen',
            'status_red',
            'lieferscheinStatus',
            0 ),
        str_repeat( "&nbsp;", 3 ),
        array(
            '1',
            'mahnung1',
            'status_green',
            'mahnungStatus',
            0 ),
        array(
            '2',
            'mahnung2',
            'status_yellow',
            'mahnungStatus',
            0 ),
        array(
            '3',
            'mahnung3',
            'status_red',
            'mahnungStatus',
            0 ),
        str_repeat( "&nbsp;", 3 ),
        array(
            'E',
            'eingereicht',
            'status_red',
            'garantieStatus',
            0 ),
        array(
            'A',
            'abgeschlossen',
            'status_green',
            'garantieStatus',
            0 ),
        );


    $user_rechte[modul_name][tool_name]["artikelStatus"] = &$user_rechte[modul_name][tool_name]["status"];


    foreach ( array_keys( $cmd_buttons ) as $buttonIndex )
    {
        if ( ( !isset( $user_rechte[modul_name][tool_name][$cmd_buttons[$buttonIndex][3]] ) ) and
            ( is_array( $cmd_buttons[$buttonIndex] ) ) )
        {
            unset( $cmd_buttons[$buttonIndex] );
        }
    }

    if ( !isset( $filter["shops_ID"] ) )
    {
        $filter["shops_ID"] = "alle";
    }
    if ( $filter["shops_ID"] != "alle" )
    {
        $shopsIDaddOn = " and s.ID = " . $filter["shops_ID"];
    }


    // ME:
    //existiert das Feld 'option_eingabe'?
    $fields = mysql_list_fields( $webs['datenbank'], 'artikel_to_Bestellung' );
    $columns = mysql_num_fields( $fields );
    for ( $i = 0; $i < $columns; $i++ )
    {
        $field_array[] = mysql_field_name( $fields, $i );
    }
    if ( in_array( 'option_eingabe', $field_array ) )
    {
        $option_eingabe = "ab.option_eingabe,";
    }

    $fields = mysql_list_fields( $webs['datenbank'], 'artikel_to_Bestellung' );
    $columns = mysql_num_fields( $fields );
    for ( $i = 0; $i < $columns; $i++ )
    {
        $field_array[] = mysql_field_name( $fields, $i );
    }
    if ( in_array( 'option_eingabe', $field_array ) )
    {
        $option_eingabe = "ab.option_eingabe,";
    }

    if ( isset( $web_rechte["Warenwirtschaft"]["bestellung"]["artikel_sortieren"] ) )
    {


        $sql_a = "SELECT
                ab.ID as ab_id,
                $option_eingabe
                ab.status,
                ab.Preis_pro_Stueck,
                ab.Menge,
                ab.Bezeichnung,
                ab.Bestellung,
                ab.rechnungstatus,
                ab.lieferscheinStatus,
                b.gesamtsumme_buffer,
                a.short_line_1,
        ";
        if ( $option_eingabe )
        {
            $sql_a .= $option_eingabe;
        }
        if ( $mahnungStatus )
        {
            $sql_a .= "ab.mahnungStatus,";
        }
        if ( $garantieStatus )
        {
            $sql_a .= "ab.garantieStatus,";
        }
        $sql_a .= "
                a.kennung,
                ab.artikel,
                ifnull(a.Father, 1) as Father,
                a.kurzbezeichnung,
                ab.Rang as ab_Rang
            FROM
                shops AS s
            JOIN
                artikel_to_Bestellung AS ab
            JOIN
                Bestellung AS b
            LEFT JOIN
                " . artikelDatabase( $daten["Bestellung"]["shops_ID"] ) . " AS a
            ON
                ab.artikel=a.ID
            AND
                a.language=b.Language
            WHERE
                b.ID = " . $daten["Bestellung"]["ID"] . "
            AND
                ab.Bestellung = b.ID
            AND
                s.ID = b.shops_ID
            ORDER BY
                Father desc,
                ab.Rang,
                a.Kennung
        ";
    }
    else
    {
        $sql_a = "SELECT
                ab.ID as ab_id,
                ab.status,
                ab.Preis_pro_Stueck,
                ab.Menge,
                ab.Bezeichnung,
                ab.Bestellung,
                ab.rechnungstatus,
                ab.lieferscheinStatus,
                b.gesamtsumme_buffer,
                a.short_line_1,
                b.language,
        ";

        if ( $option_eingabe )
        {
            $sql_a .= $option_eingabe;
        }
        if ( $mahnungStatus )
        {
            $sql_a .= "ab.mahnungStatus,";
        }
        if ( $garantieStatus )
        {
            $sql_a .= "ab.garantieStatus,";
        }

        $sql_a .= "
                a.kennung,
                $option_eingabe
                ab.artikel,
                ifnull(a.Father, 1) as Father,
                a.kurzbezeichnung,
                a.preis1,
                b.erstellt_am
            FROM
                shops AS s
            JOIN
                artikel_to_Bestellung AS ab
            JOIN
                Bestellung AS b
            LEFT JOIN
                " . artikelDatabase( $daten["Bestellung"]["shops_ID"] ) . " AS a
            ON
                ab.artikel=a.ID
            AND
                a.language=b.Language
            WHERE
                b.ID = " . $daten["Bestellung"]["ID"] . "
            AND 
                ab.Bestellung = b.ID
            AND
                s.ID = b.shops_ID
            ORDER BY
                Father desc,
                a.Kennung
        ";
    }

    $itemList = array();
    unset( $Versand_Artikel );
    $res_a = mysql_query( $sql_a ) or die( mysql_errno() . ": " . mysql_error() .
        "<hr>" . nl2br( $sql_a ) . "<hr>" );
    $count = mysql_num_rows( $res_a );
    while ( $row_a = mysql_fetch_assoc( $res_a ) )
    {
        if ( $row_a['option_eingabe'] )
        {
            $row_a["option_eingabe"] = unserialize( $row_a['option_eingabe'] );
            $row_a["option_eingabe"] = buildCustomTextEmail( $row_a["option_eingabe"],
                1 );
        }
        $sql_h = "SELECT
                hk.Name
            FROM
                " . artikelDatabase( $daten["Bestellung"]["shops_ID"] ) . " a
            LEFT JOIN
                Herstellerkatalog AS hk
            ON
                hk.ID=a.Hersteller
            WHERE
                a.ID=" . $row_a["artikel"] . "
            AND
                a.languge='" . $row_a["language"] . "'
        ";
        $res_h = mysql_query( $sql_h );
        if ( $res_h )
        {
            $row_h = mysql_fetch_assoc( $res_h );
            $row_a["hersteller"] = $row_h["Name"];
        }

        $sql_e2 = "
            SHOW 
                COLUMNS 
            FROM
                eBay_Bestellung
        ";
        $res_e2 = mysql_query( $sql_e2 );
        if ( $res_e2 )
        {
            for ( $i = 0; $row_e2 = mysql_fetch_assoc( $res_e2 ); $i++ )
            {
                $felder_eb[$i] = $row_e2['Field'];
            }

            if ( in_array( 'a2b_ID', $felder_eb ) )
            {
                $sql_e = "SELECT
                        eb.eBay_Auktionen_ID AS ebay_art_id
                    FROM
                        eBay_Bestellung AS eb
                    JOIN
                        artikel_to_Bestellung AS a2b
                    ON
                        eb.a2b_ID = a2b.ID
                    WHERE
                        eb.a2b_ID=" . $row_a["ab_id"] . "
                    AND
                        a2b.artikel != 1
                        ";

                $res_e = mysql_query( $sql_e );
                if ( $res_e )
                {
                    $row_e = mysql_fetch_assoc( $res_e );
                    $row_a["ebay_art_id"] = $row_e["ebay_art_id"];
                }
            }
            else
            {
                $sql_e = "SELECT
                        eBay_Auktionen_ID AS ebay_art_id
                    FROM
                        eBay_Bestellung,
                        artikel_to_Bestellung
                    WHERE
                        Bestellung_ID =" . $row_a["Bestellung"] . "
                    AND
                        artikel_to_Bestellung.artikel != 1
                ";

                $res_e = mysql_query( $sql_e );
                if ( $res_e )
                {
                    $row_e = mysql_fetch_assoc( $res_e );
                    $row_a["ebay_art_id"] = $row_e["ebay_art_id"];
                }
            }

        }



        if ( $row_a["Father"] <= 0 || @stristr( $row_a["kurzbezeichnung"], $row_a["hersteller"] ) )
        {
            unset( $row_a["hersteller"] );
        }

        // PL: Bestandskennzeichnung
        if ( isset( $web_rechte['Warenwirtschaft']['lagerwirtschaft']['lagerwirtschaft'] ) )
        {
            $row_a['bestandsmenge'] = getBestandsmenge( $row_a["artikel"] );
        }
        $daten["Bestellung"]["artikel"][] = $row_a;

    }

    $sql_g = "SELECT
            ab.*,
            b.erstellt_am,
            a.short_line_2   
        FROM
            artikel_to_Bestellung ab
        LEFT JOIN
                                " . artikelDatabase( $daten["Bestellung"]["shops_ID"] ) . " AS a
        ON
            ab.artikel = a.ID
        LEFT JOIN
            Bestellung b
        ON
            b.ID = ab.Bestellung                                                    
        WHERE
            ab.Bestellung = " . $daten["Bestellung"]["ID"] . "
        AND
            a.Father = -5
        AND
            ab.status IN ('offen','in Bearbeitung')
        LIMIT 1                                                            
    ";
    $res_g = mysql_query( $sql_g );
    $row_g = mysql_fetch_assoc( $res_g );
    if ( $row_g )
    {
        $gs = true;
        $gutschein["name"] = $row_g["Bezeichnung"];
        $days = 1905;
        if ( $row_g["short_line_2"] )
        {
            $days = $row_g["short_line_2"];
        }
        $gutschein["gueltig"] = date( "d.m.Y", strtotime( $days . " days",
            strtotime( $row_g["erstellt_am"] ) ) );
        $gutschein["anfangswert"] = $row_g["Preis_pro_Stueck"];
        $GLOBALS["ui"]->assign( "gs", $gs );
        $gutschein["gs_artikel"] = $row_g["ID"];
        $gutschein["gs_a_status"] = $row_g["status"];
        $gutschein["gs_a_status_k"] = ( $row_g["status"] == "offen" ) ? "O" :
            "B";
        $GLOBALS["ui"]->assign( "gutschein", $gutschein );
    }
    //var_dump( $daten );
    $daten["artikel_stati"] = array(
        array(
            "name" => "offen",
            "short" => "O",
            "class" => "status_red" ),
        array(
            "name" => "in Bearbeitung",
            "short" => "B",
            "class" => "status_yellow",
            ),
        array(
            "name" => "reserviert",
            "short" => "R",
            "class" => "status_blue",
            ),
        array(
            "name" => "erledigt",
            "short" => "E",
            "class" => "status_green",
            ),
        array(
            "name" => "abgeschlossen",
            "short" => "A",
            "class" => "status_white",
            ),
        );
    $daten["rechnung_stati"] = array(
        array(
            "name" => "schreiben",
            "short" => "S",
            "class" => "status_red" ),
        array(
            "name" => "geschrieben",
            "short" => "G",
            "class" => "status_yellow",
            ),
        array(
            "name" => "bezahlt",
            "short" => "B",
            "class" => "status_green",
            ),
        );
    $daten["lieferschein_stati"] = array(
        array(
            "name" => "schreiben",
            "short" => "S",
            "class" => "status_yellow" ),
        array(
            "name" => "geschrieben",
            "short" => "G",
            "class" => "status_green",
            ),
        array(
            "name" => "offen",
            "short" => "O",
            "class" => "status_red",
            ),
        );
    $daten["mahnung_stati"] = array(
        array(
            "name" => "mahnung1",
            "short" => "1",
            "class" => "status_green" ),
        array(
            "name" => "mahnung2",
            "short" => "2",
            "class" => "status_yellow",
            ),
        array(
            "name" => "mahnung3",
            "short" => "3",
            "class" => "status_red",
            ),
        );
    $daten["garantie_stati"] = array(
        array(
            "name" => "eingereicht",
            "short" => "E",
            "class" => "status_red" ),
        array(
            "name" => "abgeschlossen",
            "short" => "A",
            "class" => "status_green",
            ),
        );

    // Modul dokumente
    $Feld = "dokument";

    // Modconf => Bestellung
    $moduleTyp[tool_name] = array(
        "table_foreign" => "Bestellung",
        "row_foreign" => "ID",
        "data_foreign" => "ID" );

    $interneModulRechte = array(
        0 => "_read",
        1 => "_delete",
        2 => "_add" );

    $daten["dokPath"] = "http://www.$site/images/dokumente/";
    $uploadPath = $webs['verzeichnis'] . "/images/dokumente/";

    if ( isset( $user_rechte[modul_name][tool_name][$Feld . $interneModulRechte[0]] ) )
    {
        $docCount = 1;
        $sql_d = "
            SELECT 
                * 
            FROM 
                dokumente 
            WHERE 
                table_foreign = 'Bestellung' 
            AND 
                row_foreign = 'ID' 
            AND 
                data_foreign = '" . $row['ID'] . "' 
            AND 
                hidden=0 
            ORDER BY 
                letzte_aenderung_am
        ";
        $result_d = mysql_query_logged( $sql_d ) or die( mysql_errno() . ": " .
            mysql_error() . "<hr>" . nl2br( $sql_d ) . "<hr>" );
        $daten["add_document"] =
            "window.open('../dokumente/index.php?table_foreign=" . $moduleTyp[tool_name]['table_foreign'] .
            "&row_foreign=" . $moduleTyp[tool_name]['row_foreign'] .
            "&data_foreign=" . $row[$moduleTyp[tool_name]['data_foreign']] .
            "#', 'DokumentUpload', 'status, menubar, height=110, width=500');return false;";
        if ( mysql_num_rows( $result_d ) > 0 )
        {
            while ( $zeile_d = mysql_fetch_array( $result_d ) )
            {
                // Dateityp Icon definieren
                $fTmpName = $zeile_d['document'];
                $daten["dokumente"][$docCount - 1]["nr"] = $docCount;
                $daten["dokumente"][$docCount - 1]["id"] = $zeile_d['id'];
                $daten["dokumente"][$docCount - 1]["name"] = $fTmpName;
                $daten["dokumente"][$docCount - 1]["date"] = $zeile_d["letzte_aenderung_am"];
                $author = $zeile_d["letzte_aenderung_von"];
                $pos = strpos( $author, "@" );
                if ( $pos !== false )
                {
                    $author = substr( $zeile_d["letzte_aenderung_von"], 0, $pos );
                }

                $daten["dokumente"][$docCount - 1]["author"] = $author;
                $daten["dokumente"][$docCount - 1]["add_document"] =
                    "window.open('../dokumente/index.php?table_foreign=" . $moduleTyp[tool_name]['table_foreign'] .
                    "&row_foreign=" . $moduleTyp[tool_name]['row_foreign'] .
                    "&data_foreign=" . $row[$moduleTyp[tool_name]['data_foreign']] .
                    "#', 'DokumentUpload', 'status, menubar, height=110, width=500');return false;";
                $daten["dokumente"][$docCount - 1]["del_document"] =
                    "window.open('../dokumente/index.php?action=unlink&id=" . $zeile_d['id'] .
                    "&table_foreign=" . $moduleTyp[tool_name]['table_foreign'] .
                    "&row_foreign=" . $moduleTyp[tool_name]['row_foreign'] .
                    "&data_foreign=" . $row[$moduleTyp[tool_name]['data_foreign']] .
                    "#', 'DokumentUpload', 'status, menubar, height=110, width=500');return false;";

                $daten["dokumente"][$docCount - 1]["type"] = strtolower( substr
                    ( $fTmpName, strrpos( $fTmpName, "." ) + 1, strlen( $fTmpName ) ) );
                $start = substr( $zeile_d['document'], 0, 1 );
                $no_delete = array( "R", "L" );
                if ( in_array( $start, $no_delete ) )
                {
                    $daten["dokumente"][$docCount - 1]["deleteable"] = false;
                }
                else
                {
                    $daten["dokumente"][$docCount - 1]["deleteable"] = true;
                }
                $fTmpLinkIcon = "../dokumente/gfx/fileicons/" . $daten["dokumente"][$docCount -
                    1]["type"] . ".gif";
                $fTmpIcon =
                    "/web/apache/content-management/dokumente/gfx/fileicons/" .
                    $daten["dokumente"][$docCount - 1]["type"] . ".gif";
                $daten["dokumente"][$docCount - 1]["size"] = @filesize( $uploadPath .
                    $fTmpName );
                $daten["dokumente"][$docCount - 1]["icon"] = file_exists( $fTmpIcon ) ?
                    $fTmpLinkIcon : "../dokumente/gfx/fileicons/default.gif";
                $docCount++;
            }
        }
    }
    if ( isset( $web_rechte["Warenwirtschaft"]["bestellung"]["mail_client"] ) )
    {
        $i = 0;
        $mailData[$zeile["ID"]][$i]['mailto'] = $zeile["E_Mail"];
        $FelddatenII = explode( ";", $web_rechte["Warenwirtschaft"]["bestellung"]["mail_client"] );
        if ( $FelddatenII[0] == "websettingid" )
        {
            $mailData[$zeile["ID"]][$i]['mailfrom'] = $web_settings[$zeile["shops_ID"]][$FelddatenII[1]];
        }
        if ( isset( $web_settings[$zeile["shops_ID"]][198] ) )
        {
            $mailData[$zeile["ID"]][$i]['subject'] = $web_settings[$zeile["shops_ID"]][198];
        }
        if ( isset( $web_settings[$zeile["shops_ID"]][199] ) )
        {
            $mailData[$zeile["ID"]][$i]['body'] = $web_settings[$zeile["shops_ID"]][199];
        }
        $mailData[$zeile["ID"]][$i]['inTextField'] = "Sonstige E-Mail von " . $_SERVER["PHP_AUTH_USER"] .
            " am " . date( "d.m.Y" ) . " um " . date( "H:i" ) . " Uhr veschickt" .
            '\n';
    }
    for ( $i = 1; $i <= 15; $i++ )
    {
        if ( isset( $web_rechte[modul_name][tool_name]["button" . $i] ) )
        {
            $Felddaten = explode( ";", $web_rechte[modul_name][tool_name]["button" .
                $i] );
            if ( isset( $user_rechte[modul_name][tool_name]["button" . $i] ) and
                ( $web_settings[$zeile["shops_ID"]][$Felddaten[1]] ) )
            {
                // Mail Client dazuschalten (Markus 02.07.207)
                $buttonType = isset( $web_rechte["Warenwirtschaft"]["bestellung"]["mail_client"] ) ?
                    "button" : "submit";
                if ( isset( $web_rechte["Warenwirtschaft"]["bestellung"]["mail_client"] ) )
                {
                    $mailData[$zeile["ID"]][$i]['subject'] = $web_settings[$zeile["shops_ID"]][$Felddaten[1]];
                    $mailData[$zeile["ID"]][$i]['body'] = $web_settings[$zeile["shops_ID"]][$Felddaten[2]];
                    $mailData[$zeile["ID"]][$i]['inTextField'] = rawurldecode( $web_settings[$zeile["shops_ID"]][$Felddaten[3]] );
                    $mailData[$zeile["ID"]][$i]['mailto'] = $zeile["E_Mail"];
                    $FelddatenII = explode( ";", $web_rechte["Warenwirtschaft"]["bestellung"]["mail_client"] );
                    if ( $FelddatenII[0] == "websettingid" )
                    {
                        $mailData[$zeile["ID"]][$i]['mailfrom'] = $web_settings[$zeile["shops_ID"]][$FelddatenII[1]];
                    }

                    $_SESSION['mailData'] = $mailData;

                    if ( $_SERVER["REMOTE_ADDR"] == "89.245.130.99" )
                    {
                        //print_r($web_settings[1]);
                    }

                    /*$onClick = "window.open('MailClient/index.php?mailto=" . $zeile[E_Mail] .
                    "&subject=" . $web_settings[$zeile[shops_ID]][$Felddaten[1]] . "&body=" . $web_settings[$zeile[shops_ID]][$Felddaten[2]] .
                    "&inTextField=" . $web_settings[$zeile[shops_ID]][$Felddaten[3]] .
                    "', 'MailClient', 'status, menubar, height=600, width=900');";*/
                    $onSubmit = "window.open('MailClient/index.php?id=$i&Bestellung=" .
                        $zeile["ID"] . "&shop=" . $zeile["shops_ID"] .
                        "&button=" . $Felddaten[0] .
                        "', 'MailClient', 'status, menubar, height=600, width=900, scrollbars=yes');";
                    $onClick = $onSubmit;
                }
                else
                {
                    $onClick = "MM_goToURL('parent','mailto:" . $zeile["E_Mail"] .
                        "?subject=" . $web_settings[$zeile["shops_ID"]][$Felddaten[1]] .
                        "&body=" . $web_settings[$zeile["shops_ID"]][$Felddaten[2]] .
                        "'); inTextfeld('" . rawurldecode( $web_settings[$zeile["shops_ID"]][$Felddaten[3]] ) .
                        "');";
                }
                $daten["buttons"][] = array(
                    "type" => $buttonType,
                    "name" => "update[list]",
                    "class" => "status_red",
                    "onClick" => $onClick,
                    "value" => $Felddaten[0] );
            }
        }
    }

    $GLOBALS["ui"]->assign( "user_rechte", $user_rechte );
    $GLOBALS["ui"]->assign( "web_rechte", $web_rechte );
    $shops = getShops();
    foreach ( $shops as $s_id => $shop )
    {
        $c_shops[$shop["ID"]] = $shop["Name"];
        $d_shops[$shop["ID"]] = $shop;
    }

    $Feld = "shortline1";
    if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
    {
        $fname_f = $web_rechte[modul_name][tool_name][$Feld];
        $pos = strpos( $fname_f, ";" );
        $daten["sl1"]["name"] = substr( $fname_f, 0, $pos );
        $daten["sl1"]["size"] = substr( $fname_f, $pos + 1 );
    }
    $Feld = "shortline2";
    if ( isset( $user_rechte[modul_name][tool_name][$Feld] ) )
    {
        $fname_f = $web_rechte[modul_name][tool_name][$Feld];
        $pos = strpos( $fname_f, ";" );
        $daten["sl2"]["name"] = substr( $fname_f, 0, $pos );
        $daten["sl2"]["size"] = substr( $fname_f, $pos + 1 );
    }
    if ( isset( $user_rechte["Warenwirtschaft"]["logistiker"]["logistiker"] ) )
    {
        $logistiker[] = "Bitte wählen";
        $sql_l = "SELECT
                id,
                name
            FROM
                logistiker
        ";
        $res_l = mysql_query( $sql_l );
        while ( $row_l = mysql_fetch_assoc( $res_l ) )
        {
            $logistiker[$row_l["id"]] = $row_l["name"];
        }
        $sql_bl = "SELECT
                logistiker
            FROM
                bestellung_logistiker bl
            WHERE
                bl.bestellung=" . $row["ID"] . "
        ";
        $res_bl = mysql_query( $sql_bl );

        $row_bl = mysql_fetch_assoc( $res_bl );
        $GLOBALS["ui"]->assign( "logistiker", $logistiker );

        $GLOBALS["ui"]->assign( "logistiker_sel", $row_bl["logistiker"] );
    }
    if ( isset( $user_rechte["Warenwirtschaft"]["bestellung"]["tracking"] ) )
    {
        if ( $web_rechte["Warenwirtschaft"]["bestellung"]["tracking"] )
        {
            $daten_p = explode( ";", $web_rechte["Warenwirtschaft"]["bestellung"]["tracking"] );
            $daten["paketdienst"]["name"] = $daten_p[0];
            $daten["paketdienst"]["url"] = $daten_p[1];
            $sql = "
                SELECT
                    *
                FROM
                    bestellung_paketnummern
                WHERE
                    Bestellung=" . $row["ID"] . "
                ORDER BY
                    datum
            ";
            $res = mysql_query( $sql );
            while ( $row_p = mysql_fetch_assoc( $res ) )
            {
                $daten["paketdienst"]["nummern"][] = array( "nummer" => $row_p["paketnummer"],
                        "datum" => $row_p["datum"] );
            }
        }
    }
    elseif ( isset( $user_rechte["Warenwirtschaft"]["logistiker"]["logistiker"] ) )
    {
        $sql = "
                SELECT
                    bp.*,
                    l.name AS logistiker_name,
                    l.trackinglink
                FROM
                    bestellung_paketnummern bp,
                    logistiker l
                WHERE
                    Bestellung=" . $row["ID"] . "
                AND
                    l.id=bp.logistiker
                ORDER BY
                    datum
            ";
        $res = mysql_query( $sql );
        while ( $row_p = mysql_fetch_assoc( $res ) )
        {
            $daten["paketdienst"]["nummern"][] = array(
                "nummer" => $row_p["paketnummer"],
                "datum" => $row_p["datum"],
                "name" => $row_p["logistiker_name"],
                "url" => $row_p["trackinglink"],
                );
        }
    }
    $rowspan = count( $daten["Bestellung"]["artikel"] ) + 4;
    $tpl_file = ( $filter_maske === false ) ? "bestellungen_formular_pdf.tpl" :
        "bestellungen_formular.tpl";

    $GLOBALS["ui"]->assign( "c_shops", $c_shops );
    $GLOBALS["ui"]->assign( "d_shops", $d_shops );
    $GLOBALS["ui"]->assign( "preise_anzeigen", $preise_anzeigen );
    $GLOBALS["ui"]->assign( "daten", $daten );
    $GLOBALS["ui"]->assign( "rowspan", $rowspan );
    $GLOBALS["ui"]->assign( "d_colspan", $d_colspan );
    if ( isset( $web_rechte['Warenwirtschaft']['lagerwirtschaft']['bestandskennzeichnung'] ) )
    {
        $GLOBALS["ui"]->assign( "bestandskennzeichnungsfarbe",
            getBestandskennzeichnung( $web_rechte['Warenwirtschaft']['lagerwirtschaft']['bestandskennzeichnung'] ) );
    }
    if ( isset( $web_rechte["Warenwirtschaft"]["bestellung"]["online_retoure"] ) )
    {
        $sql_l = "SELECT
                id,
                kname,
                returnlink
            FROM
                logistiker
            WHERE
                returnlink <> ''
        ";
        $res_l = mysql_query( $sql_l );
        while ( $row_l = mysql_fetch_assoc( $res_l ) )
        {
            $link = $row_l["returnlink"];
            $first_name = rawurlencode( $zeile["Vorname"] );
            $last_name = rawurlencode( $zeile["Name1"] );
            $street = rawurlencode( $zeile["Strasse"] . " " . $zeile["Hausnummer"] );
            $email = rawurlencode( $zeile["E_Mail"] );
            $city = rawurlencode( $zeile["ORT"] );
            $zip = rawurlencode( $zeile["PLZ"] );
            $link = str_replace( "###ref###", $Bestellung, $link );
            $link = str_replace( "###email###", $email, $link );
            $link = str_replace( "###first_name###", $first_name, $link );
            $link = str_replace( "###last_name###", $last_name, $link );
            $link = str_replace( "###street###", $street, $link );
            $link = str_replace( "###zip###", $zip, $link );
            $link = str_replace( "###city###", $city, $link );
            $row_l["returnlink"] = $link;
            $logistiker[$row_l["id"]] = $row_l;
        }
        $GLOBALS["ui"]->assign( "logistiker", $logistiker );
    }
    // type = 0 normaler E-Mail Text mit \n
    // type = 1 Ausgabetext für RS (Bestellung) mit <br> statt \n
    function buildCustomTextEmail( $get, $type = 0 )
    {
        if ( $type == 1 )
        {
            $cont = "<br>Details:";
        }
        else
        {
            $cont = "\nDetails:";
        }
        for ( $i = 0; $i < $get['ct_zeilen']; $i++ )
        {
            $opt = array();
            $align = "zentriert";
            $bold = "";
            $italic = "";
            $underline = "";
            $file = "";
            if ( $get['ct_left_' . $i . ''] == "left" )
                $align = "linksbündig";
            if ( $get['ct_center_' . $i . ''] == "center" )
                $align = "zentriert";
            if ( $get['ct_right_' . $i . ''] == "right" )
                $align = "rechtsbündig";
            if ( $get['ct_bold_' . $i . ''] == "on" )
                $bold = "fett";
            if ( $get['ct_italic_' . $i . ''] == "on" )
                $italic = "kursiv";
            if ( $get['ct_underline_' . $i . ''] == "on" )
                $underline = "unterstrichen";
            if ( $get['ct_font_' . $i] . '' )
                $font = $get['ct_font_' . $i . ''];
            if ( $get['ct_file'] )
                $file = "Bilddatei: " . $get['ct_file'];
            if ( $font )
                $opt[] = $font;
            if ( $align )
                $opt[] = $align;
            if ( $bold )
                $opt[] = $bold;
            if ( $italic )
                $opt[] = $italic;
            if ( $underline )
                $opt[] = $underline;
            if ( $file )
                $opt[] = $file;

            if ( $type == 1 )
            {
                $cont .= "<br> " . ( $i + 1 ) . ". Zeile: " . $get['ct_text_' .
                    $i . ''] . " (" . $get['ct_fontsize_' . $i . ''] . ", " .
                    implode( ", ", $opt ) . ")";
            }
            else
            {
                $cont .= "\n" . ( $i + 1 ) . ". Zeile: " . $get['ct_text_' . $i .
                    ''] . " (" . $get['ct_fontsize_' . $i . ''] . ", " . implode( ", ",
                    $opt ) . ")";
            }
        }
        return $cont;
    }
?>
Subversion-Projekte lars-tiefland.content-management

(root)/trunk/Warenwirtschaft/bestellung_formular.php – Revision 2
