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: 4249 $
     * @filesource
     * 
     */

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

    // SVN: $Id: lagerbestand.php 4249 2012-03-23 15:42:14Z tiefland $
    require_once "../toolbox/common.php";
    require_once "includes/bestellungen/system/artikelDatabase.php";
    require_once "module/weban/weban_utils.class.php";
    $item = Weban_Utils::clean_global_input( "item", "post", "int" );
    $order_id = Weban_Utils::clean_global_input( "order_id", "post", "int" );
    $shop_id = Weban_Utils::clean_global_input( "shop_id", "post", "int" );
    $GLOBALS["db_name"] = shopDatabase( $shop_id );
    $artikel = getArtikel( $item );
    $lieferanten = getArtikelLieferanten( $item );
    foreach ( $lieferanten as $id => $lieferant )
    {
        $sql_l = "SELECT
                id,
                name,
                bestellbar,
                bestand,
                status,
                verf_codes,
                ek_preis,
                vk_preis,
                import_date
            FROM
                " . $GLOBALS["db_name"] . "lieferanten_lager ll
            JOIN
                " . $GLOBALS["db_name"] . "artikel_lagerbestand al
            ON
                al.artikel_id=$item
            AND
                al.lager_id=ll.id
            WHERE
                lieferanten_id=" . $lieferant["id"] . "
            ORDER BY
                rang,
                name
        ";
        $res_l = mysql_query( $sql_l );
        while ( $row_l = mysql_fetch_assoc( $res_l ) )
        {
            $verf_codes = unserialize( $row_l["verf_codes"] );
            unset( $row_l["verf_codes"] );
            foreach ( $verf_codes as $verf_code )
            {
                $row_l["verf_codes"][$verf_code["key"]]["name"] = $verf_code["value"];
                $row_l["verf_codes"][$verf_code["key"]]["image"] = $verf_code["image"];
            }
            $lieferanten[$id]["lager"][] = $row_l;
        }
        $id++;
    }
    $GLOBALS["ui"]->assign( "artikel", $artikel );
    $GLOBALS["ui"]->assign( "item_id", $item );
    $GLOBALS["ui"]->assign( "order_id", $order_id );
    $GLOBALS["ui"]->assign( "shop_id", $shop_id );
    $GLOBALS["ui"]->assign( "lieferanten", $lieferanten );
    $GLOBALS["ui"]->display( "lagerbestand.tpl" );

    function getArtikelLieferanten( $item )
    {
        $id = 0;
        $ret = array();
        $sql = "SELECT
                l.id,
                l.name
            FROM
                " . $GLOBALS["db_name"] . "artikel_to_lieferanten al,
                " . $GLOBALS["db_name"] . "lieferanten l
            WHERE
                al.lieferanten_id=l.id
            AND
                al.artikel_id=$item
            AND
                al.lieferanten_artnr !=''
            ORDER BY
                rang,
                name
        ";
        $res = mysql_query( $sql );
        while ( $row = mysql_fetch_assoc( $res ) )
        {
            $ret[$id++] = $row;
        }
        return $ret;
    }

    function getArtikel( $item )
    {
        $sql = "SELECT
                a.kurzbezeichnung,
                al.lieferanten_artnr
            FROM
                " . $GLOBALS["db_name"] . "artikel a
            JOIN
                " . $GLOBALS["db_name"] . "artikel_to_lieferanten al
            ON
                al.artikel_id=a.id
            AND
                a.id=$item
        ";
        $res = mysql_query( $sql );
        $row = mysql_fetch_assoc( $res );
        //var_dump($row);
        return $row;
    }
?>