Subversion-Projekte lars-tiefland.content-management

Revision

Zur aktuellen 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: lagerbestand.php 3931 2011-09-16 08:17:57Z tiefland $
21 
    require_once "../toolbox/common.php";
22 
    require_once "includes/bestellungen/system/artikelDatabase.php";
23 
    require_once "module/weban/weban_utils.class.php";
24 
    $item = Weban_Utils::clean_global_input( "item", "post", "int" );
25 
    $order_id = Weban_Utils::clean_global_input( "order_id", "post", "int" );
26 
    $shop_id = Weban_Utils::clean_global_input( "shop_id", "post", "int" );
27 
    $GLOBALS["db_name"] = shopDatabase( $shop_id );
28 
    $lieferanten = getArtikelLieferanten( $item );
29 
    foreach ( $lieferanten as $id => $lieferant )
30 
    {
31 
        $sql_l = "SELECT
32 
                id,
33 
                name,
34 
                bestellbar,
35 
                bestand,
36 
                status,
37 
                verf_codes,
38 
                ek_preis,
39 
                vk_preis
40 
            FROM
41 
                " . $GLOBALS["db_name"] . "lieferanten_lager ll
42 
            JOIN
43 
                " . $GLOBALS["db_name"] . "artikel_lagerbestand al
44 
            ON
45 
                al.artikel_id=$item
46 
            AND
47 
                al.lager_id=ll.id
48 
            WHERE
49 
                lieferanten_id=" . $lieferant["id"] . "
50 
            ORDER BY
51 
                rang,
52 
                name
53 
        ";
54 
        $res_l = mysql_query( $sql_l );
55 
        while ( $row_l = mysql_fetch_assoc( $res_l ) )
56 
        {
57 
            $verf_codes = unserialize( $row_l["verf_codes"] );
58 
            unset( $row_l["verf_codes"] );
59 
            foreach ( $verf_codes as $verf_code )
60 
            {
61 
                $row_l["verf_codes"][$verf_code["key"]]["name"] = $verf_code["value"];
62 
                $row_l["verf_codes"][$verf_code["key"]]["image"] = $verf_code["image"];
63 
            }
64 
            $lieferanten[$id]["lager"][] = $row_l;
65 
        }
66 
        $id++;
67 
    }
68 
    $GLOBALS["ui"]->assign( "item_id", $item );
69 
    $GLOBALS["ui"]->assign( "order_id", $order_id );
70 
    $GLOBALS["ui"]->assign( "shop_id", $shop_id );
71 
    $GLOBALS["ui"]->assign( "lieferanten", $lieferanten );
72 
    $GLOBALS["ui"]->display( "lagerbestand.tpl" );
73 
 
74 
    function getArtikelLieferanten( $item )
75 
    {
76 
        $id = 0;
77 
        $ret = array();
78 
        $sql = "SELECT
79 
                l.id,
80 
                l.name
81 
            FROM
82 
                " . $GLOBALS["db_name"] . "artikel_to_lieferanten al,
83 
                " . $GLOBALS["db_name"] . "lieferanten l
84 
            WHERE
85 
                al.lieferanten_id=l.id
86 
            AND
87 
                al.artikel_id=$item
88 
            AND
89 
                al.lieferanten_artnr !=''
90 
            ORDER BY
91 
                rang,
92 
                name
93 
        ";
94 
        $res = mysql_query( $sql );
95 
        while ( $row = mysql_fetch_assoc( $res ) )
96 
        {
97 
            $ret[$id++] = $row;
98 
        }
99 
        return $ret;
100 
    }
101 
?>