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: 723 $
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: logistiker.php 723 2011-09-21 06:34:37Z tiefland $
21 
 
22 
    require_once "../toolbox/common.php";
23 
    require_once "module/weban/weban_utils.class.php";
24 
    require_once "smarty/libs/SmartyPaginate.class.php";
25 
    require_once  "includes/bestellungen/pagination.php";
26 
    $GLOBALS["ui"]->compile_id = "Warenwirtschaft";
27 
    $GLOBALS["ui"]->assign( "web_id", $webs["ID"] );
28 
    $GLOBALS["ui"]->assign( "web_rechte", $web_rechte );
29 
    $GLOBALS["ui"]->assign( "user_rechte", $user_rechte );
30 
    $GLOBALS["ui"]->assign( "site", $site );
31 
    $GLOBALS["ui"]->assign( "webs", $webs );
32 
    switch ( $_GET["action"] )
33 
    {
34 
        case "edit":
35 
            $id = Weban_Utils::clean_global_input( "id", "get", "int" );
36 
            if ( $id )
37 
            {
38 
                $sql = "SELECT
39 
                        *
40 
                    FROM
41 
                        logistiker
42 
                    WHERE
43 
                        id=$id
44 
                ";
45 
                $res = mysql_query( $sql );
46 
                $logistiker = mysql_fetch_assoc( $res );
47 
                getTracking();
48 
            }
49 
            $GLOBALS["ui"]->assign( "tpl_file", "logistiker_edit.tpl" );
50 
            break;
51 
        default:
52 
            if ( $_POST["mode"] == "save" )
53 
            {
54 
                $name = Weban_Utils::clean_global_input( "name" );
55 
                $kname = Weban_Utils::clean_global_input( "kname" );
56 
                $trackinglink = Weban_Utils::clean_global_input( "trackinglink" );
57 
                $returnlink = Weban_Utils::clean_global_input( "returnlink" );
58 
                $id = Weban_Utils::clean_global_input( "id", "post", "int" );
59 
                if ( $id )
60 
                {
61 
                    $sql = "
62 
                        UPDATE
63 
                            logistiker
64 
                        SET
65 
                            name='" . $name . "',
66 
                            kname='" . $kname . "',
67 
                            trackinglink='" . $trackinglink . "',
68 
                            returnlink='" . $returnlink . "'
69 
                        WHERE
70 
                            id=$id
71 
                    ";
72 
                }
73 
                else
74 
                {
75 
                    $sql = "
76 
                        INSERT INTO
77 
                            logistiker
78 
                        SET
79 
                            name='" . $name . "',
80 
                            kname='" . $kname . "',
81 
                            trackinglink='" . $trackinglink . "',
82 
                            returnlink='" . $returnlink . "'
83 
                    ";
84 
                }
85 
                $res = mysql_query( $sql );
86 
                header( "Location:" . $_SERVER["SCRIPT_NAME"] );
87 
            } elseif ( $_POST["mode"] == "delete" )
88 
            {
89 
                foreach ( $_POST["l_ids"] as $l_id )
90 
                {
91 
                    $id = Weban_Utils::clean_input( $l_id, "int" );
92 
                }
93 
                $sql = "DELETE FROM
94 
                        logistiker
95 
                    WHERE
96 
                        id=$id
97 
                ";
98 
                $res = mysql_query( $sql );
99 
                echo mysql_error();
100 
                exit;
101 
                header( "Location:" . $_SERVER["SCRIPT_NAME"] );
102 
            }
103 
            else
104 
            {
105 
                $sql = "SELECT
106 
                        *
107 
                    FROM
108 
                        logistiker
109 
                ";
110 
                $res = mysql_query( $sql );
111 
                while ( $row = mysql_fetch_assoc( $res ) )
112 
                {
113 
                    $logistiker[] = $row;
114 
                }
115 
                $GLOBALS["ui"]->assign( "tpl_file", "logistiker.tpl" );
116 
            }
117 
            break;
118 
    }
119 
    set_time_limit( 0 );
120 
    $GLOBALS["ui"]->assign( "logistiker", $logistiker );
121 
    $GLOBALS["ui"]->display( "page.tpl" );
122 
 
123 
    function getTracking()
124 
    {
125 
        $id = Weban_Utils::clean_global_input( "id", "get", "int" );
126 
        $start = Weban_Utils::clean_global_input( "start", "get", "int" );
127 
        if(!$start)
128 
        {
129 
            $start=1;
130 
        }
131 
        $start-=1;
132 
        $sql = "SELECT
133 
                SQL_CALC_FOUND_ROWS
134 
                l.kname,
135 
                bp.bestellung,
136 
                l.trackinglink,
137 
                bp.paketnummer,
138 
                bp.datum
139 
            FROM
140 
                logistiker l,
141 
                bestellung_paketnummern bp
142 
            WHERE
143 
                bp.logistiker=l.id
144 
            AND
145 
                l.id=$id
146 
            ORDER BY
147 
                datum desc
148 
            LIMIT
149 
                $start, 100
150 
        ";
151 
        $res = mysql_query( $sql );
152 
        while ( $row = mysql_fetch_assoc( $res ) )
153 
        {
154 
            $daten[] = $row;
155 
        }
156 
        $sql = "SELECT
157 
                FOUND_ROWS() AS anz
158 
        ";
159 
        $res = mysql_query( $sql );
160 
        $row = mysql_fetch_assoc( $res );
161 
        $anz = $row["anz"];
162 
        pagination( $anz );
163 
        $GLOBALS["ui"]->assign( "daten", $daten );
164 
    }
165 
?>