Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?php
2 
 
3 
    /**
4 
     * @package   Content-management
5 
     * @author    Webagentur Niewerth <tiefland@weban.de>
6 
     * @copyright 2011 Webagentur Niewerth
7 
     * @license   propietary http://www.weban.de
8 
     * @version   $Rev: 3931 $
9 
     * @filesource
10 
     *
11 
     */
12 
 
13 
    /**
14 
     *
15 
     * @package   Content-management
16 
     * @author    Webagentur Niewerth <tiefland@weban.de>
17 
     * @copyright 2011 Webagentur Niewerth
18 
     */
19 
 
20 
    // SVN: $Id: lager.php 3931 2011-09-16 08:17:57Z tiefland $
21 
 
22 
    require_once "../toolbox/common.php";
23 
    require_once "module/weban/weban_utils.class.php";
24 
 
25 
    $mode = Weban_Utils::clean_global_input( "mode" );
26 
    $id = Weban_Utils::clean_global_input( "l_id", "post", "int" );
27 
    $d_l_id = Weban_Utils::clean_global_input( "d_l_id", "post", "int" );
28 
    $rang = Weban_Utils::clean_global_input( "l_rang", "post", "int" );
29 
    $lieferant_id = Weban_Utils::clean_global_input( "l_lieferant_id",
30 
        "post", "int" );
31 
    $name = Weban_Utils::clean_global_input( "l_name" );
32 
    $bestellbar = Weban_Utils::clean_global_input( "l_bestellbar", "post",
33 
        "int" );
34 
 
35 
    if ( $rang == false )
36 
    {
37 
        $rang = 0;
38 
    }
39 
    switch ( $mode )
40 
    {
41 
        case "delete":
42 
            $sql = "DELETE FROM
43 
                        lieferanten_lager
44 
                    WHERE
45 
                        id=$d_l_id
46 
                ";
47 
            $res = mysql_query( $sql );
48 
            break;
49 
        case "save":
50 
            $verf_codes = serialize( $_POST["code"] );
51 
            $sql = "INSERT INTO
52 
                    lieferanten_lager
53 
                SET
54 
                    name='" . $name . "',
55 
                    rang=$rang,
56 
                    lieferanten_id=" . $lieferant_id . ",
57 
                    bestellbar=" . $bestellbar . ",
58 
                    verf_codes='" . $verf_codes . "',
59 
                    erstellt_am=NOW(),
60 
                    erstellt_von='" . $_SERVER["PHP_AUTH_USER"] . "',
61 
                    letzte_aenderung_von='" . $_SERVER["PHP_AUTH_USER"] . "'
62 
            ";
63 
            $res = mysql_query( $sql );
64 
            break;
65 
        case "update":
66 
            foreach ( $_POST["code"] as $i => $code )
67 
            {
68 
                $_POST["code"][$i]["value"] = utf8_decode( $code["value"] );
69 
            }
70 
            $verf_codes = serialize( $_POST["code"] );
71 
            $sql = "UPDATE
72 
                    lieferanten_lager
73 
                SET
74 
                    name='" . $name . "',
75 
                    rang=$rang,
76 
                    bestellbar=" . $bestellbar . ",
77 
                    verf_codes='" . $verf_codes . "',
78 
                    letzte_aenderung_von='" . $_SERVER["PHP_AUTH_USER"] . "'
79 
                WHERE
80 
                    id=$id
81 
            ";
82 
            $res = mysql_query( $sql );
83 
            exit;
84 
            break;
85 
        case "":
86 
        case "edit":
87 
            if ( $id )
88 
            {
89 
                $sql = "SELECT
90 
                        *
91 
                    FROM
92 
                        lieferanten_lager
93 
                    WHERE
94 
                        id=$id
95 
                ";
96 
                $res = mysql_query( $sql );
97 
                $row = mysql_fetch_assoc( $res );
98 
                $row["verf_codes"] = unserialize( $row["verf_codes"] );
99 
                $GLOBALS["ui"]->assign( "lager", $row );
100 
            }
101 
            $GLOBALS["ui"]->display( "lager_edit.tpl" );
102 
            break;
103 
    }
104 
?>