Subversion-Projekte lars-tiefland.content-management

<?php

    /**
     * @package   Content-management
     * @author    Lars Tiefland <tiefland@weban.de>
     * @copyright 2009 Webagentur Niewerth
     * @license   propietary
     * @version   $Rev: 3931 $
     * @filesource
     * 
     */

    /**
     * 
     * @package   Content-management
     * @author    Lars Tiefland <tiefland@weban.de>
     * @copyright 2009 Webagentur Niewerth
     */

    // SVN: $Id: change_lieferadresse.php 3931 2011-09-16 08:17:57Z tiefland $

    require_once  "../Online-Shop/connect2.php";
    require_once  "Weban_Smarty.class.php";
    $GLOBALS["ui"] = new Weban_Smarty();
    $GLOBALS["ui"]->compile_dir = $_SERVER["DOCUMENT_ROOT"] . "/templates_c/";
    $GLOBALS["ui"]->compile_id = "Warenwirtschaft|bestellungen";
    $GLOBALS["ui"]->use_sub_dirs = true;

    $anreden = array( -1 => "--- Bitte wählen! --- ", 1 => "Herr", 2 =>
        "Frau", 3 => "Firma" );

    $Laender = array( "Deutschland", "Niederlande", "&Ouml;sterreich",
        "Belgien", "Luxemburg", "D&auml;nemark", "Schweiz", "Frankreich",
        "Gro&szlig;britannien", "Italien", "Spanien", "Portugal", "Schweden",
        "Finnland", "Norwegen", "Irland", "Griechenland", "Estland",
        "Lettland", "Malta", "Litauen", "Polen", "Slowenien",
        "Tschechien/Slowakei", "Türkei", "Ungarn", "Zypern", "Kanada", 
                "USA", "Kroatien", "Bulgarien", "Rumänien" );
    $countries["-1"] = "--- Bitte wählen! --- ";
    foreach ( $Laender as $counter => $Land )
    {
        $code = 1 << $counter;
        $countries[$code] = $Land;
    }

    if ( $_POST )
    {
        foreach ( $_POST as $key => $val )
        {
            if ( preg_match( "/^liefer_/i", $key ) )
            {
                switch ( $key )
                {
                    case "liefer_Anrede":
                        $val = $anreden[$val];
                        break;
                    case "liefer_Land":
                        $val = $countries[$val];
                        break;
                }
                $arr[] = $key . '="' . $val . '"';
            }
        }
        $msg = "Lieferadresse von " . $_SERVER["PHP_AUTH_USER"] . " am " .
            date( "d.m.Y" ) . " um " . date( "H:i" ) . " Uhr geändert\n";
        $sql = "
            UPDATE
                Bestellung
            SET
            " . implode( ", ", $arr ) . ",
            Bemerkung=CONCAT(Bemerkung,'" . mysql_real_escape_string( $msg ) .
            "')
            WHERE
                ID=" . $_POST["b_id"] . "
        ";
        $res = mysql_query( $sql );
?>
            <script>
                opener.location.reload();
                self.close();
            </script>
        <?php
    }
    else
    {
        $sql = "
            SELECT
                *
            FROM
                Bestellung
            WHERE
                ID=" . $_GET["b_id"] . "
        ";
        $res = mysql_query( $sql );
        $row = mysql_fetch_assoc( $res );
        $GLOBALS["ui"]->assign( "Liefer_Adresse", $row );

        $GLOBALS["ui"]->assign( "land", array_search( $row["liefer_Land"], $countries ) );
        $GLOBALS["ui"]->assign( "Laender", $countries );
        $GLOBALS["ui"]->assign( "anreden", $anreden );
        $GLOBALS["ui"]->assign( "anrede", array_search( $row["liefer_Anrede"], $anreden ) );
        $GLOBALS["ui"]->assign( "b_id", $_GET["b_id"] );
        $GLOBALS["ui"]->display( "change_lieferadresse.tpl" );
    }

?>