Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?php
2 
 
3 
    //$Id$
4 
 
5 
    /**
6 
     * @author Lars Tiefland <tiefland@weban.de>
7 
     * @copyright 2008 Webagentur Niewerth
8 
     * @package Content-management
9 
     * @subpackage Toolbox
10 
     * @version $Rev$
11 
     * @license propietary
12 
     * @filesource
13 
     *
14 
     */
15 
 
16 
    /**
17 
     *
18 
     * @author Lars Tiefland <tiefland@weban.de>
19 
     * @copyright 2008 Webagentur Niewerth
20 
     */
21 
 
22 
    require_once "common.php";
23 
 
24 
    if ( $_POST["mode"] == "update" )
25 
    {
26 
        $sql = "TRUNCATE star_garantie";
27 
        $res = mysql_query( $sql );
28 
        foreach ( $_POST["daten"] as $stufe => $kat )
29 
        {
30 
            foreach ( $kat as $id => $werte )
31 
            {
32 
                $t_sql[] = $id . "," . implode( ",", $werte );
33 
            }
34 
        }
35 
        $value_sql = implode( "),(", $t_sql );
36 
        $sql = "
37 
            INSERT INTO
38 
                star_garantie
39 
            (
40 
                kategorie,
41 
                von,
42 
                bis,
43 
                betrag
44 
            )
45 
            VALUES
46 
            (
47 
                $value_sql
48 
            )
49 
        ";
50 
        $res = mysql_query( $sql );
51 
    }
52 
    $sql_k = "
53 
        SELECT
54 
            *
55 
        FROM
56 
            star_garantie_kategorie
57 
        WHERE
58 
            id >-1
59 
    ";
60 
    $res_k = mysql_query( $sql_k );
61 
    while ( $row_k = mysql_fetch_assoc( $res_k ) )
62 
    {
63 
        $id = 0;
64 
        $stufen = array();
65 
        for ( $i = 0; $i < $row_k["stufen"]; $i++ )
66 
        {
67 
            $stufen[$i] = $i;
68 
        }
69 
        $sql_w = "
70 
            SELECT
71 
                von,
72 
                bis,
73 
                betrag
74 
            FROM
75 
                star_garantie
76 
            WHERE
77 
                kategorie=" . $row_k["id"] . "
78 
            ORDER BY von
79 
        ";
80 
        $res_w = mysql_query( $sql_w );
81 
        while ( $row_w = mysql_fetch_assoc( $res_w ) )
82 
        {
83 
            $werte[$id++] = $row_w;
84 
        }
85 
 
86 
        $warengruppen[] = array( "name" => $row_k["k_name"], "id" => $row_k["id"],
87 
            "stufen" => $stufen, "werte" => $werte );
88 
    }
89 
    $GLOBALS["ui"]->assign( "colspan", count( $warengruppen ) );
90 
    $GLOBALS["ui"]->assign( "Warengruppen", $warengruppen );
91 
    $GLOBALS["ui"]->assign( "file", "common/" . basename( $_SERVER["SCRIPT_NAME"],
92 
        "php" ) . "tpl" );
93 
    $GLOBALS["ui"]->display( "common/page.tpl" );
94 
?>