Subversion-Projekte lars-tiefland.content-management

Revision

Revision 1 | Ganze Datei anzeigen | Leerzeichen ignorieren | Details | Blame | Letzte Änderung | Log anzeigen | RSS feed

Revision 1 Revision 2
Zeile 1... Zeile 1...
1 
<?php
 1 
<?php
2 
    //$Id: best_manu.php 4024 2011-10-24 10:38:11Z tiefland $
 2 
    //$Id: best_manu.php 4249 2012-03-23 15:42:14Z tiefland $
Zeile 3... Zeile 3...
3 
 
 3 
 
4 
    /**
 4 
    /**
5 
     * @author Patrick Lautsch <lautsch@weban.de>
 5 
     * @author Patrick Lautsch <lautsch@weban.de>
6 
     * @author Lars Tiefland <tiefland@weban.de>
 6 
     * @author Lars Tiefland <tiefland@weban.de>
7 
     * @copyright 2008 Webagentur Niewerth
 7 
     * @copyright 2008 Webagentur Niewerth
8 
     * @package Content-management
 8 
     * @package Content-management
9 
     * @subpackage manuelle Bestellerfassung
 9 
     * @subpackage manuelle Bestellerfassung
10 
     * @version $Rev: 4024 $
 10 
     * @version $Rev: 4249 $
11 
     * @license propietary
 11 
     * @license propietary
12 
     * @filesource
 12 
     * @filesource
13 
     *
13 
     *
Zeile 25... Zeile 25...
25 
    // Connect-Datei einbinden
 25 
    // Connect-Datei einbinden
26 
    define( "modul_name", "Warenwirtschaft" );
 26 
    define( "modul_name", "Warenwirtschaft" );
27 
    define( "tool_name", "bestellung" );
 27 
    define( "tool_name", "bestellung" );
28 
    define( "F_NAME", basename( $_SERVER["PHP_SELF"] ) );
 28 
    define( "F_NAME", basename( $_SERVER["PHP_SELF"] ) );
29 
    require_once "../Online-Shop/connect2.php";
 29 
    require_once "../Online-Shop/connect2.php";
- 
 
 30 
    $GLOBALS["web_rechte"] = $web_rechte;
30 
    //////////////////////////
 31 
    //////////////////////////
Zeile -... Zeile 32...
- 
 
 32 
 
- 
 
 33 
    $Laender = array(
- 
 
 34 
        "Deutschland",
31 
 
 35 
        "Niederlande",
- 
 
 36 
        "&Ouml;sterreich",
- 
 
 37 
        "Belgien",
32 
    $Laender = array( "Deutschland", "Niederlande", "&Ouml;sterreich", "Belgien",
 38 
        "Luxemburg",
- 
 
 39 
        "D&auml;nemark",
- 
 
 40 
        "Schweiz",
33 
        "Luxemburg", "D&auml;nemark", "Schweiz", "Frankreich",
 41 
        "Frankreich",
- 
 
 42 
        "Gro&szlig;britannien",
- 
 
 43 
        "Italien",
- 
 
 44 
        "Spanien",
- 
 
 45 
        "Portugal",
- 
 
 46 
        "Schweden",
- 
 
 47 
        "Finnland",
- 
 
 48 
        "Norwegen",
34 
        "Gro&szlig;britannien", "Italien", "Spanien", "Portugal", "Schweden",
 49 
        "Irland",
- 
 
 50 
        "Griechenland",
- 
 
 51 
        "Estland",
- 
 
 52 
        "Lettland",
- 
 
 53 
        "Malta",
- 
 
 54 
        "Litauen",
- 
 
 55 
        "Polen",
35 
        "Finnland", "Norwegen", "Irland", "Griechenland", "Estland", "Lettland",
 56 
        "Slowenien",
- 
 
 57 
        "Tschechien/Slowakei",
- 
 
 58 
        "Türkei",
- 
 
 59 
        "Ungarn",
- 
 
 60 
        "Zypern",
- 
 
 61 
        "Kanada",
- 
 
 62 
        "USA",
36 
        "Malta", "Litauen", "Polen", "Slowenien", "Tschechien/Slowakei",
 63 
        "Kroatien",
37 
        "Türkei", "Ungarn", "Zypern", "Kanada", "USA", "Kroatien", "Bulgarien",
 64 
        "Bulgarien",
Zeile 38... Zeile 65...
38 
        "Rumänien" );
 65 
        "Rumänien" );
39 
 
 66 
 
Zeile 101... Zeile 128...
101 
    // artikelDatabase einbinden für die Funktion: artikelDatabase()
 128 
    // artikelDatabase einbinden für die Funktion: artikelDatabase()
102 
    require_once "./includes/bestellungen/system/artikelDatabase.php";
 129 
    require_once "./includes/bestellungen/system/artikelDatabase.php";
103 
    ////////////////////////////////////////////////////////////////
 130 
    ////////////////////////////////////////////////////////////////
Zeile 104... Zeile 131...
104 
 
 131 
 
105 
    // Felder
 132 
    // Felder
- 
 
 133 
    $Eingabefelder = array(
- 
 
 134 
        "Name1",
- 
 
 135 
        "Vorname",
- 
 
 136 
        "Name2",
- 
 
 137 
        "Strasse",
- 
 
 138 
        "Hausnummer",
- 
 
 139 
        "PLZ_Ort",
- 
 
 140 
        "Land",
- 
 
 141 
        "Telefon",
106 
    $Eingabefelder = array( "Name1", "Vorname", "Name2", "Strasse", "Hausnummer",
 142 
        "Fax",
107 
        "PLZ_Ort", "Land", "Telefon", "Fax", "E_Mail" );
 143 
        "E_Mail" );
108 
    $i = 0;
 144 
    $i = 0;
109 
    foreach ( $Eingabefelder as $Feld )
 145 
    foreach ( $Eingabefelder as $Feld )
Zeile 110... Zeile 146...
110 
    {
 146 
    {
Zeile 123... Zeile 159...
123 
            //$eingabefelder[$i]["pflicht"] = ( $Feld == "Name1" ) ? 1 : 0;
 159 
            //$eingabefelder[$i]["pflicht"] = ( $Feld == "Name1" ) ? 1 : 0;
124 
            $eingabefelder[$i]["f_name"] = $Feld;
 160 
            $eingabefelder[$i]["f_name"] = $Feld;
125 
            $i++;
 161 
            $i++;
126 
        }
 162 
        }
127 
    }
 163 
    }
128 
    $Suchfelder = array( "Name1", "Vorname", "Name2", "Strasse", "Hausnummer",
 164 
    $Suchfelder = array(
- 
 
 165 
        "Name1",
- 
 
 166 
        "Vorname",
- 
 
 167 
        "Name2",
- 
 
 168 
        "Strasse",
- 
 
 169 
        "Hausnummer",
- 
 
 170 
        "PLZ_Ort",
129 
        "PLZ_Ort", "E_Mail" );
 171 
        "E_Mail" );
130 
    $i = 0;
 172 
    $i = 0;
131 
    foreach ( $Suchfelder as $Feld )
 173 
    foreach ( $Suchfelder as $Feld )
132 
    {
 174 
    {
Zeile 133... Zeile 175...
133 
 
 175 
 
Zeile 321... Zeile 363...
321 
        $_SESSION[F_NAME]['Ort'] = mysql_real_escape_string( $_POST['Ort'] );
 363 
        $_SESSION[F_NAME]['Ort'] = mysql_real_escape_string( $_POST['Ort'] );
322 
        $_SESSION[F_NAME]['E_Mail'] = mysql_real_escape_string( $_POST['E_Mail'] );
 364 
        $_SESSION[F_NAME]['E_Mail'] = mysql_real_escape_string( $_POST['E_Mail'] );
323 
        $_SESSION[F_NAME]['Land'] = mysql_real_escape_string( $_POST['Land'] );
 365 
        $_SESSION[F_NAME]['Land'] = mysql_real_escape_string( $_POST['Land'] );
324 
        $_SESSION[F_NAME]['Telefon'] = mysql_real_escape_string( $_POST['Telefon'] );
 366 
        $_SESSION[F_NAME]['Telefon'] = mysql_real_escape_string( $_POST['Telefon'] );
325 
        $_SESSION[F_NAME]['Fax'] = mysql_real_escape_string( $_POST['Fax'] );
 367 
        $_SESSION[F_NAME]['Fax'] = mysql_real_escape_string( $_POST['Fax'] );
326 
        $_SESSION[F_NAME]['AP_Bemerkung'] = mysql_real_escape_string( $_POST['AP_Bemerkung'] );
 368 
        $bemerkung_tmp = mysql_real_escape_string( $_POST['AP_Bemerkung'] );
- 
 
 369 
        $bemerkung_tmp = str_replace( '\\n', "\n", $bemerkung_tmp );
- 
 
 370 
        $bemerkung_tmp = str_replace( '\\r', "\r", $bemerkung_tmp );
- 
 
 371 
        $_SESSION[F_NAME]['AP_Bemerkung'] = $bemerkung_tmp;
- 
 
 372 
        unset( $bemerkung_tmp );
327 
        if ( $_POST['neukunde'] == 1 )
 373 
        if ( $_POST['neukunde'] == 1 )
328 
        {
 374 
        {
329 
            $sql = "INSERT INTO Logins
375 
            $sql = "INSERT INTO Logins
330 
                (
 376 
                (
331 
                    Anrede,
 377 
                    Anrede,
Zeile 366... Zeile 412...
366 
                )
 412 
                )
367 
            ";
 413 
            ";
368 
            mysql_query( $sql ) or die( $site . ": " . mysql_error() . "<hr />" .
 414 
            mysql_query( $sql ) or die( $site . ": " . mysql_error() . "<hr />" .
369 
                $sql );
 415 
                $sql );
370 
            $_SESSION[F_NAME]['kunden_id'] = mysql_insert_id();
 416 
            $_SESSION[F_NAME]['kunden_id'] = mysql_insert_id();
- 
 
 417 
        }
371 
        } elseif ( !$_POST['neukunde'] && !isset( $_POST["fertigstellen"] ) && !isset( $_POST["hinzufuegen"] ) &&
 418 
        elseif ( !$_POST['neukunde'] && !isset( $_POST["fertigstellen"] ) && !
372 
        !$deleted && !isset( $_POST["daten"] ) && !isset( $_POST["submit_manueller_artikel"] ) &&
 419 
            isset( $_POST["hinzufuegen"] ) && !$deleted && !isset( $_POST["daten"] ) &&
373 
            !isset( $_POST["artikel"] ) && !isset( $_POST['gasbestellung'] ) )
 420 
            !isset( $_POST["submit_manueller_artikel"] ) && !isset( $_POST["artikel"] ) &&
- 
 
 421 
            !isset( $_POST['gasbestellung'] ) )
374 
        {
 422 
        {
375 
            //$_SESSION[F_NAME]["kunden_id"] = $_POST["kunden_id"];
 423 
            //$_SESSION[F_NAME]["kunden_id"] = $_POST["kunden_id"];
376 
            $sql = "
 424 
            $sql = "
377 
                UPDATE
 425 
                UPDATE
378 
                    Logins
 426 
                    Logins
379 
                SET
 427 
                SET
380 
            ";
 428 
            ";
- 
 
 429 
            $felder = array(
381 
            $felder = array( "Anrede" => $_SESSION[F_NAME]["Anrede"], "Name1" =>
 430 
                "Anrede" => $_SESSION[F_NAME]["Anrede"],
- 
 
 431 
                "Name1" => $_SESSION[F_NAME]["Name1"],
382 
                $_SESSION[F_NAME]["Name1"], "Vorname" => $_SESSION[F_NAME]["Vorname"],
 432 
                "Vorname" => $_SESSION[F_NAME]["Vorname"],
- 
 
 433 
                "Name2" => $_SESSION[F_NAME]["Name2"],
383 
                "Name2" => $_SESSION[F_NAME]["Name2"], "Strasse" => $_SESSION[F_NAME]["Strasse"],
 434 
                "Strasse" => $_SESSION[F_NAME]["Strasse"],
384 
                "Hausnummer" => $_SESSION[F_NAME]["Hausnummer"], "PLZ" => $_SESSION[F_NAME]["PLZ"],
 435 
                "Hausnummer" => $_SESSION[F_NAME]["Hausnummer"],
- 
 
 436 
                "PLZ" => $_SESSION[F_NAME]["PLZ"],
- 
 
 437 
                "Ort" => $_SESSION[F_NAME]["Ort"],
385 
                "Ort" => $_SESSION[F_NAME]["Ort"], "Telefon" => $_SESSION[F_NAME]["Telefon"],
 438 
                "Telefon" => $_SESSION[F_NAME]["Telefon"],
- 
 
 439 
                "Fax" => $_SESSION[F_NAME]["Fax"],
386 
                "Fax" => $_SESSION[F_NAME]["Fax"], "E_Mail" => $_SESSION[F_NAME]["E_Mail"],
 440 
                "E_Mail" => $_SESSION[F_NAME]["E_Mail"],
387 
                "AP_Bemerkung" => $_SESSION[F_NAME]['AP_Bemerkung'], );
 441 
                "AP_Bemerkung" => $_SESSION[F_NAME]['AP_Bemerkung'],
- 
 
 442 
                );
388 
            foreach ( $felder as $feld => $value )
 443 
            foreach ( $felder as $feld => $value )
389 
            {
 444 
            {
390 
                $value = mysql_real_escape_string( $value );
 445 
                $value = mysql_real_escape_string( $value );
391 
                $fields[] = $feld . "='" . $value . "'";
 446 
                $fields[] = $feld . "='" . $value . "'";
392 
            }
 447 
            }
Zeile 681... Zeile 736...
681 
        $_REQUEST['action'] = "step4";
 736 
        $_REQUEST['action'] = "step4";
682 
    }
 737 
    }
683 
    ///////////////////////////////
 738 
    ///////////////////////////////
Zeile 684... Zeile 739...
684 
 
 739 
 
- 
 
 740 
    // Kundennamen zur Ausgabe holen
- 
 
 741 
    $sql = "SELECT
- 
 
 742 
            Vorname,
- 
 
 743 
            Name1,
- 
 
 744 
            Name2,
685 
    // Kundennamen zur Ausgabe holen
 745 
            ORT,
- 
 
 746 
            AP_Bemerkung
- 
 
 747 
        FROM
- 
 
 748 
            Logins
686 
    $sql = "SELECT Vorname, Name1, Name2, ORT, AP_Bemerkung FROM Logins WHERE ID = '" .
 749 
        WHERE
- 
 
 750 
            ID = '" . $_SESSION[F_NAME]['kunden_id'] . "'
687 
        $_SESSION[F_NAME]['kunden_id'] . "'";
 751 
    ";
688 
    $result = mysql_query( $sql ) or die( $site . ": " . mysql_error() .
 752 
    $result = mysql_query( $sql ) or die( $site . ": " . mysql_error() .
Zeile 689... Zeile 753...
689 
        "<hr />" . $sql );
 753 
        "<hr />" . $sql );
690 
 
 754 
 
Zeile 717... Zeile 781...
717 
            $Land = $row["Land"];
 781 
            $Land = $row["Land"];
718 
            $bemerkungen = $row['AP_Bemerkung'];
 782 
            $bemerkungen = $row['AP_Bemerkung'];
719 
        }
 783 
        }
Zeile 720... Zeile 784...
720 
 
 784 
 
- 
 
 785 
        if ( !$_SESSION[F_NAME]['Anrede'] )
721 
        if ( !$_SESSION[F_NAME]['Anrede'] )
 786 
        {
- 
 
 787 
            $_SESSION[F_NAME]['Anrede'] = $anrede;
722 
            $_SESSION[F_NAME]['Anrede'] = $anrede;
 788 
        }
- 
 
 789 
        if ( !$_SESSION[F_NAME]['Vorname'] )
723 
        if ( !$_SESSION[F_NAME]['Vorname'] )
 790 
        {
- 
 
 791 
            $_SESSION[F_NAME]['Vorname'] = $vorname;
724 
            $_SESSION[F_NAME]['Vorname'] = $vorname;
 792 
        }
- 
 
 793 
        if ( !$_SESSION[F_NAME]['Name1'] )
725 
        if ( !$_SESSION[F_NAME]['Name1'] )
 794 
        {
- 
 
 795 
            $_SESSION[F_NAME]['Name1'] = $nachname;
726 
            $_SESSION[F_NAME]['Name1'] = $nachname;
 796 
        }
- 
 
 797 
        if ( !$_SESSION[F_NAME]['Strasse'] )
727 
        if ( !$_SESSION[F_NAME]['Strasse'] )
 798 
        {
- 
 
 799 
            $_SESSION[F_NAME]['Strasse'] = $strasse;
728 
            $_SESSION[F_NAME]['Strasse'] = $strasse;
 800 
        }
- 
 
 801 
        if ( !$_SESSION[F_NAME]['PLZ'] )
729 
        if ( !$_SESSION[F_NAME]['PLZ'] )
 802 
        {
- 
 
 803 
            $_SESSION[F_NAME]['PLZ'] = $plz;
730 
            $_SESSION[F_NAME]['PLZ'] = $plz;
 804 
        }
- 
 
 805 
        if ( !$_SESSION[F_NAME]['Ort'] )
731 
        if ( !$_SESSION[F_NAME]['Ort'] )
 806 
        {
- 
 
 807 
            $_SESSION[F_NAME]['Ort'] = $ort;
732 
            $_SESSION[F_NAME]['Ort'] = $ort;
 808 
        }
- 
 
 809 
        if ( !$_SESSION[F_NAME]['E_Mail'] )
733 
        if ( !$_SESSION[F_NAME]['E_Mail'] )
 810 
        {
- 
 
 811 
            $_SESSION[F_NAME]['E_Mail'] = $email;
734 
            $_SESSION[F_NAME]['E_Mail'] = $email;
 812 
        }
- 
 
 813 
        if ( !$_SESSION[F_NAME]['Telefon'] )
735 
        if ( !$_SESSION[F_NAME]['Telefon'] )
 814 
        {
- 
 
 815 
            $_SESSION[F_NAME]['Telefon'] = $telefon;
736 
            $_SESSION[F_NAME]['Telefon'] = $telefon;
 816 
        }
- 
 
 817 
        if ( !$_SESSION[F_NAME]['Fax'] )
737 
        if ( !$_SESSION[F_NAME]['Fax'] )
 818 
        {
- 
 
 819 
            $_SESSION[F_NAME]['Fax'] = $fax;
738 
            $_SESSION[F_NAME]['Fax'] = $fax;
 820 
        }
- 
 
 821 
        if ( !$_SESSION[F_NAME]['Land'] )
739 
        if ( !$_SESSION[F_NAME]['Land'] )
 822 
        {
- 
 
 823 
            $_SESSION[F_NAME]['Land'] = $land;
740 
            $_SESSION[F_NAME]['Land'] = $land;
 824 
        }
- 
 
 825 
        if ( !$_SESSION[F_NAME]['AP_Bemerkung'] )
741 
        if ( !$_SESSION[F_NAME]['AP_Bemerkung'] )
 826 
        {
- 
 
 827 
            $_SESSION[F_NAME]['AP_Bemerkung'] = $bemerkungen;
742 
            $_SESSION[F_NAME]['AP_Bemerkung'] = $bemerkungen;
 828 
        }
743 
    }
 829 
    }
Zeile 744... Zeile 830...
744 
    ///////////////////////////////////////////////////////////
 830 
    ///////////////////////////////////////////////////////////
745 
 
 831