Subversion-Projekte lars-tiefland.content-management

<?php

    /**
     * @package   Content-management
     * @author    Webagentur Niewerth <tiefland@weban.de>
     * @copyright 2011 Webagentur Niewerth
     * @license   propietary http://www.weban.de
     * @version   $Rev: 723 $
     * @filesource
     * 
     */

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

    // SVN: $Id: logistiker.php 723 2011-09-21 06:34:37Z tiefland $

    require_once "../toolbox/common.php";
    require_once "module/weban/weban_utils.class.php";
    require_once "smarty/libs/SmartyPaginate.class.php";
    require_once  "includes/bestellungen/pagination.php";
    $GLOBALS["ui"]->compile_id = "Warenwirtschaft";
    $GLOBALS["ui"]->assign( "web_id", $webs["ID"] );
    $GLOBALS["ui"]->assign( "web_rechte", $web_rechte );
    $GLOBALS["ui"]->assign( "user_rechte", $user_rechte );
    $GLOBALS["ui"]->assign( "site", $site );
    $GLOBALS["ui"]->assign( "webs", $webs );
    switch ( $_GET["action"] )
    {
        case "edit":
            $id = Weban_Utils::clean_global_input( "id", "get", "int" );
            if ( $id )
            {
                $sql = "SELECT
                        *
                    FROM
                        logistiker
                    WHERE
                        id=$id
                ";
                $res = mysql_query( $sql );
                $logistiker = mysql_fetch_assoc( $res );
                getTracking();
            }
            $GLOBALS["ui"]->assign( "tpl_file", "logistiker_edit.tpl" );
            break;
        default:
            if ( $_POST["mode"] == "save" )
            {
                $name = Weban_Utils::clean_global_input( "name" );
                $kname = Weban_Utils::clean_global_input( "kname" );
                $trackinglink = Weban_Utils::clean_global_input( "trackinglink" );
                $returnlink = Weban_Utils::clean_global_input( "returnlink" );
                $id = Weban_Utils::clean_global_input( "id", "post", "int" );
                if ( $id )
                {
                    $sql = "
                        UPDATE
                            logistiker
                        SET
                            name='" . $name . "',
                            kname='" . $kname . "',
                            trackinglink='" . $trackinglink . "',
                            returnlink='" . $returnlink . "'
                        WHERE
                            id=$id                    
                    ";
                }
                else
                {
                    $sql = "
                        INSERT INTO
                            logistiker
                        SET
                            name='" . $name . "',
                            kname='" . $kname . "',
                            trackinglink='" . $trackinglink . "',
                            returnlink='" . $returnlink . "'
                    ";
                }
                $res = mysql_query( $sql );
                header( "Location:" . $_SERVER["SCRIPT_NAME"] );
            } elseif ( $_POST["mode"] == "delete" )
            {
                foreach ( $_POST["l_ids"] as $l_id )
                {
                    $id = Weban_Utils::clean_input( $l_id, "int" );
                }
                $sql = "DELETE FROM
                        logistiker
                    WHERE
                        id=$id
                ";
                $res = mysql_query( $sql );
                echo mysql_error();
                exit;
                header( "Location:" . $_SERVER["SCRIPT_NAME"] );
            }
            else
            {
                $sql = "SELECT
                        *
                    FROM
                        logistiker
                ";
                $res = mysql_query( $sql );
                while ( $row = mysql_fetch_assoc( $res ) )
                {
                    $logistiker[] = $row;
                }
                $GLOBALS["ui"]->assign( "tpl_file", "logistiker.tpl" );
            }
            break;
    }
    set_time_limit( 0 );
    $GLOBALS["ui"]->assign( "logistiker", $logistiker );
    $GLOBALS["ui"]->display( "page.tpl" );

    function getTracking()
    {
        $id = Weban_Utils::clean_global_input( "id", "get", "int" );
        $start = Weban_Utils::clean_global_input( "start", "get", "int" );
        if(!$start)
        {
            $start=1;
        }
        $start-=1;
        $sql = "SELECT
                SQL_CALC_FOUND_ROWS
                l.kname,
                bp.bestellung,
                l.trackinglink,
                bp.paketnummer,
                bp.datum
            FROM
                logistiker l,
                bestellung_paketnummern bp
            WHERE
                bp.logistiker=l.id
            AND
                l.id=$id
            ORDER BY
                datum desc
            LIMIT
                $start, 100            
        ";
        $res = mysql_query( $sql );
        while ( $row = mysql_fetch_assoc( $res ) )
        {
            $daten[] = $row;
        }
        $sql = "SELECT
                FOUND_ROWS() AS anz
        ";
        $res = mysql_query( $sql );
        $row = mysql_fetch_assoc( $res );
        $anz = $row["anz"];
        pagination( $anz );
        $GLOBALS["ui"]->assign( "daten", $daten );
    }
?>