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

     /**
      * @package   Kein Projekt geladen
      * @author     <>
      * @copyright 2009
      * @license   propietary http://www.weban.de
-     * @version   $Rev: 3980 $
+     * @version   $Rev: 4258 $
      * @filesource
+     *
      */
      * @author     <>
      * @copyright 2009
      */
     define( "FROM_BESTELLUNG", true );
-    // SVN: $Id: bestellung_formular.php 3980 2011-10-10 06:53:08Z erling $
+    // 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" ) )
+    {
         $daten["Versand"] = array();
         $daten["Versand"][] = "";
         foreach ( $versandItems as $versandOption )
+        {
-            $daten["Versand"][base64_encode( serialize( $versandOption ) )] =
+            $daten["Versand"][base64_encode( serialize( $versandOption ) )] = $versandOption["kurz"];
-                $versandOption["kurz"];
+        }
+    }
     $erstellt_am = datetime2human( $zeile["erstellt_am"] );
             AND
                 bestellart_id=1
             ORDER BY
                 Rang
         ";
-        $result_w = mysql_query_logged( $query ) or die( mysql_errno() .
+        $result_w = mysql_query_logged( $query ) or die( mysql_errno() . ": " .
-            ": " . mysql_error() . "<hr>$query<hr>" );
+            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"];
+    {
         $garantieStatus = 1;
+    }
+    $cmd_buttons = array(
+        array(
+            'O',
+            'offen',
+            'status_red',
+            'artikelStatus',
+),
+        array(
+            'B',
+            'in Bearbeitung',
+            'status_yellow',
+            'artikelStatus',
+),
+        array(
+            'R',
-    $cmd_buttons = array( array( 'O', 'offen', 'status_red', 'artikelStatus',
+            'reserviert',
+            'status_blue',
+            'artikelStatus',
+),
+        array(
+            'E',
-), array( 'B', 'in Bearbeitung', 'status_yellow', 'artikelStatus',
+            'erledigt',
+            'status_green',
+            'artikelStatus',
+),
+        array(
+            'A',
-), array( 'R', 'reserviert', 'status_blue', 'artikelStatus', 0 ),
+            'abgeschlossen',
+            'status_white',
-        array( 'E', 'erledigt', 'status_green', 'artikelStatus', 0 ), array
+            'artikelStatus',
+),
+        str_repeat( "&nbsp;", 3 ),
+        array(
+            'S',
+            'schreiben',
+            'status_red',
+            'rechnungStatus',
+),
+        array(
-        ( 'A', 'abgeschlossen', 'status_white', 'artikelStatus', 0 ),
+            'G',
+            'geschrieben',
+            'status_yellow',
+            'rechnungStatus',
+),
+        array(
-        str_repeat( "&nbsp;", 3 ), array( 'S', 'schreiben', 'status_red',
+            'B',
+            'bezahlt',
+            'status_green',
-        'rechnungStatus', 6 ), array( 'G', 'geschrieben', 'status_yellow',
+            'rechnungStatus',
+),
+        str_repeat( "&nbsp;", 3 ),
+        array(
+            'S',
-        'rechnungStatus', 6 ), array( 'B', 'bezahlt', 'status_green',
+            'schreiben',
+            'status_yellow',
+            'lieferscheinStatus',
+),
+        array(
+            'G',
-        'rechnungStatus', 6 ), str_repeat( "&nbsp;", 3 ), array( 'S',
+            'geschrieben',
+            'status_green',
+            'lieferscheinStatus',
+),
+        array(
+            'O',
-        'schreiben', 'status_yellow', 'lieferscheinStatus', 0 ), array( 'G',
+            'offen',
+            'status_red',
+            'lieferscheinStatus',
+),
+        str_repeat( "&nbsp;", 3 ),
+        array(
+            '1',
-        'geschrieben', 'status_green', 'lieferscheinStatus', 0 ), array( 'O',
+            'mahnung1',
+            'status_green',
+            'mahnungStatus',
+),
+        array(
+            '2',
-        'offen', 'status_red', 'lieferscheinStatus', 0 ), str_repeat( "&nbsp;",
+            'mahnung2',
+            'status_yellow',
+            'mahnungStatus',
+),
+        array(
+            '3',
-), array( '1', 'mahnung1', 'status_green', 'mahnungStatus', 0 ),
+            'mahnung3',
+            'status_red',
+            'mahnungStatus',
+),
+        str_repeat( "&nbsp;", 3 ),
+        array(
+            'E',
-        array( '2', 'mahnung2', 'status_yellow', 'mahnungStatus', 0 ), array
+            'eingereicht',
+            'status_red',
+            'garantieStatus',
+),
+        array(
+            'A',
-        ( '3', 'mahnung3', 'status_red', 'mahnungStatus', 0 ), str_repeat( "&nbsp;",
+            'abgeschlossen',
+            'status_green',
+            'garantieStatus',
-), array( 'E', 'eingereicht', 'status_red', 'garantieStatus', 0 ),
+),
             JOIN
                 artikel_to_Bestellung AS ab
             JOIN
                 Bestellung AS b
             LEFT JOIN
-                " . artikelDatabase( $daten["Bestellung"]["shops_ID"] ) .
+                " . artikelDatabase( $daten["Bestellung"]["shops_ID"] ) . " AS a
-            " AS a
             ON
                 ab.artikel=a.ID
             AND
                 a.language=b.Language
             WHERE
             JOIN
                 artikel_to_Bestellung AS ab
             JOIN
                 Bestellung AS b
             LEFT JOIN
-                " . artikelDatabase( $daten["Bestellung"]["shops_ID"] ) .
+                " . artikelDatabase( $daten["Bestellung"]["shops_ID"] ) . " AS a
-            " AS a
             ON
                 ab.artikel=a.ID
             AND
                 a.language=b.Language
             WHERE
         ";
+    }
     $itemList = array();
     unset( $Versand_Artikel );
-    $res_a = mysql_query( $sql_a ) or die( mysql_errno() . ": " .
+    $res_a = mysql_query( $sql_a ) or die( mysql_errno() . ": " . mysql_error() .
-        mysql_error() . "<hr>" . nl2br( $sql_a ) . "<hr>" );
+        "<hr>" . nl2br( $sql_a ) . "<hr>" );
     $count = mysql_num_rows( $res_a );
     while ( $row_a = mysql_fetch_assoc( $res_a ) )
+    {
         if ( $row_a['option_eingabe'] )
 );
+        }
         $sql_h = "SELECT
                 hk.Name
             FROM
-                " . artikelDatabase( $daten["Bestellung"]["shops_ID"] ) .
+                " . artikelDatabase( $daten["Bestellung"]["shops_ID"] ) . " a
-            " a
             LEFT JOIN
                 Herstellerkatalog AS hk
             ON
                 hk.ID=a.Hersteller
             WHERE
         $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" =>
+    $daten["artikel_stati"] = array(
+        array(
+            "name" => "offen",
+            "short" => "O",
+            "class" => "status_red" ),
+        array(
-        "O", "class" => "status_red" ), array( "name" => "in Bearbeitung",
+            "name" => "in Bearbeitung",
+            "short" => "B",
-        "short" => "B", "class" => "status_yellow", ), array( "name" =>
+            "class" => "status_yellow",
+            ),
+        array(
+            "name" => "reserviert",
+            "short" => "R",
-        "reserviert", "short" => "R", "class" => "status_blue", ), array( "name" =>
+            "class" => "status_blue",
+            ),
+        array(
+            "name" => "erledigt",
+            "short" => "E",
-        "erledigt", "short" => "E", "class" => "status_green", ), array( "name" =>
+            "class" => "status_green",
+            ),
+        array(
+            "name" => "abgeschlossen",
+            "short" => "A",
-        "abgeschlossen", "short" => "A", "class" => "status_white", ), );
+            "class" => "status_white",
+            ),
+        );
-    $daten["rechnung_stati"] = array( array( "name" => "schreiben", "short" =>
+    $daten["rechnung_stati"] = array(
+        array(
+            "name" => "schreiben",
+            "short" => "S",
+            "class" => "status_red" ),
+        array(
-        "S", "class" => "status_red" ), array( "name" => "geschrieben",
+            "name" => "geschrieben",
+            "short" => "G",
-        "short" => "G", "class" => "status_yellow", ), array( "name" =>
+            "class" => "status_yellow",
+            ),
+        array(
+            "name" => "bezahlt",
+            "short" => "B",
-        "bezahlt", "short" => "B", "class" => "status_green", ), );
+            "class" => "status_green",
+            ),
+        );
-    $daten["lieferschein_stati"] = array( array( "name" => "schreiben",
+    $daten["lieferschein_stati"] = array(
+        array(
+            "name" => "schreiben",
+            "short" => "S",
-        "short" => "S", "class" => "status_yellow" ), array( "name" =>
+            "class" => "status_yellow" ),
+        array(
+            "name" => "geschrieben",
+            "short" => "G",
-        "geschrieben", "short" => "G", "class" => "status_green", ), array( "name" =>
+            "class" => "status_green",
+            ),
+        array(
+            "name" => "offen",
+            "short" => "O",
-        "offen", "short" => "O", "class" => "status_red", ), );
+            "class" => "status_red",
+            ),
+        );
-    $daten["mahnung_stati"] = array( array( "name" => "mahnung1", "short" =>
+    $daten["mahnung_stati"] = array(
+        array(
+            "name" => "mahnung1",
+            "short" => "1",
-        "1", "class" => "status_green" ), array( "name" => "mahnung2",
+            "class" => "status_green" ),
+        array(
+            "name" => "mahnung2",
+            "short" => "2",
-        "short" => "2", "class" => "status_yellow", ), array( "name" =>
+            "class" => "status_yellow",
+            ),
+        array(
+            "name" => "mahnung3",
+            "short" => "3",
-        "mahnung3", "short" => "3", "class" => "status_red", ), );
+            "class" => "status_red",
+            ),
+        );
-    $daten["garantie_stati"] = array( array( "name" => "eingereicht",
+    $daten["garantie_stati"] = array(
+        array(
+            "name" => "eingereicht",
+            "short" => "E",
-        "short" => "E", "class" => "status_red" ), array( "name" =>
+            "class" => "status_red" ),
+        array(
+            "name" => "abgeschlossen",
+            "short" => "A",
-        "abgeschlossen", "short" => "A", "class" => "status_green", ), );
+            "class" => "status_green",
+            ),
+        );
     // Modul dokumente
     $Feld = "dokument";
+    // Modconf => Bestellung
+    $moduleTyp[tool_name] = array(
-    // Modconf => Bestellung
+        "table_foreign" => "Bestellung",
-    $moduleTyp[tool_name] = array( "table_foreign" => "Bestellung",
+        "row_foreign" => "ID",
-        "row_foreign" => "ID", "data_foreign" => "ID" );
+        "data_foreign" => "ID" );
+    $interneModulRechte = array(
+=> "_read",
 => "_delete",
-    $interneModulRechte = array( 0 => "_read", 1 => "_delete", 2 => "_add" );
+=> "_add" );
             AND
                 hidden=0
             ORDER BY
                 letzte_aenderung_am
         ";
-        $result_d = mysql_query_logged( $sql_d ) or die( mysql_errno() .
+        $result_d = mysql_query_logged( $sql_d ) or die( mysql_errno() . ": " .
-            ": " . mysql_error() . "<hr>" . nl2br( $sql_d ) . "<hr>" );
+            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;";
                     "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=" .
+                    "window.open('../dokumente/index.php?action=unlink&id=" . $zeile_d['id'] .
-                    $zeile_d['id'] . "&table_foreign=" . $moduleTyp[tool_name]['table_foreign'] .
+                    "&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 ( 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 " .
+        $mailData[$zeile["ID"]][$i]['inTextField'] = "Sonstige E-Mail von " . $_SERVER["PHP_AUTH_USER"] .
-            $_SERVER["PHP_AUTH_USER"] . " am " . date( "d.m.Y" ) . " um " .
+            " am " . date( "d.m.Y" ) . " um " . date( "H:i" ) . " Uhr veschickt" .
-            date( "H:i" ) . " Uhr veschickt" . '\n';
+            '\n';
+    }
     for ( $i = 1; $i <= 15; $i++ )
+    {
         if ( isset( $web_rechte[modul_name][tool_name]["button" . $i] ) )
+        {
                     "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]['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]];
                         "?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" =>
+                $daten["buttons"][] = array(
+                    "type" => $buttonType,
+                    "name" => "update[list]",
-                    "update[list]", "class" => "status_red", "onClick" => $onClick,
+                    "class" => "status_red",
+                    "onClick" => $onClick,
                     "value" => $Felddaten[0] );
+            }
+        }
+    }
         $res_l = mysql_query( $sql_l );
         while ( $row_l = mysql_fetch_assoc( $res_l ) )
+        {
             $logistiker[$row_l["id"]] = $row_l["name"];
+        }
-        $sql_bl="SELECT
+        $sql_bl = "SELECT
                 logistiker
             FROM
                 bestellung_logistiker bl
             WHERE
-                bl.bestellung=".$row["ID"]."
+                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"] )
             ";
             $res = mysql_query( $sql );
             while ( $row_p = mysql_fetch_assoc( $res ) )
+            {
                 $daten["paketdienst"]["nummern"][] = array( "nummer" => $row_p["paketnummer"],
-                    "datum" => $row_p["datum"] );
+                        "datum" => $row_p["datum"] );
+            }
+        }
+    }
-    } elseif ( isset( $user_rechte["Warenwirtschaft"]["logistiker"]["logistiker"] ) )
+    elseif ( isset( $user_rechte["Warenwirtschaft"]["logistiker"]["logistiker"] ) )
+    {
         $sql = "
                 SELECT
                     bp.*,
                     l.name AS logistiker_name,
                     datum
             ";
         $res = mysql_query( $sql );
         while ( $row_p = mysql_fetch_assoc( $res ) )
+        {
-            $daten["paketdienst"]["nummern"][] = array( "nummer" => $row_p["paketnummer"],
+            $daten["paketdienst"]["nummern"][] = array(
+                "nummer" => $row_p["paketnummer"],
+                "datum" => $row_p["datum"],
-                "datum" => $row_p["datum"], "name" => $row_p["logistiker_name"],
+                "name" => $row_p["logistiker_name"],
-                "url" => $row_p["trackinglink"], );
+                "url" => $row_p["trackinglink"],
+                );
+        }
+    }
     $rowspan = count( $daten["Bestellung"]["artikel"] ) + 4;
-    $tpl_file = ( $filter_maske === false ) ?
+    $tpl_file = ( $filter_maske === false ) ? "bestellungen_formular_pdf.tpl" :
-        "bestellungen_formular_pdf.tpl" : "bestellungen_formular.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 );
     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 )
                     $i . ''] . " (" . $get['ct_fontsize_' . $i . ''] . ", " .
                     implode( ", ", $opt ) . ")";
+            }
             else
+            {
-                $cont .= "\n" . ( $i + 1 ) . ". Zeile: " . $get['ct_text_' .
+                $cont .= "\n" . ( $i + 1 ) . ". Zeile: " . $get['ct_text_' . $i .
-                    $i . ''] . " (" . $get['ct_fontsize_' . $i . ''] . ", " .
+                    ''] . " (" . $get['ct_fontsize_' . $i . ''] . ", " . implode( ", ",
-                    implode( ", ", $opt ) . ")";
+                    $opt ) . ")";
+            }
+        }
         return $cont;
+    }
 ?>

Subversion-Projekte lars-tiefland.content-management

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