Subversion-Projekte lars-tiefland.content-management

<?php

    //$Id$

    /**
     * @author Lars Tiefland <tiefland@weban.de>
     * @copyright 2008 Webagentur Niewerth
     * @package Content-management
     * @subpackage Toolbox
     * @version $Rev$
     * @license propietary
     * @filesource
     * 
     */

    /**
     * 
     * @author Lars Tiefland <tiefland@weban.de>
     * @copyright 2008 Webagentur Niewerth
     */

    require_once "common.php";

    if ( $_POST["mode"] == "update" )
    {
        $sql = "TRUNCATE star_garantie";
        $res = mysql_query( $sql );
        foreach ( $_POST["daten"] as $stufe => $kat )
        {
            foreach ( $kat as $id => $werte )
            {
                $t_sql[] = $id . "," . implode( ",", $werte );
            }
        }
        $value_sql = implode( "),(", $t_sql );
        $sql = "
            INSERT INTO 
                star_garantie 
            (
                kategorie, 
                von, 
                bis, 
                betrag
            )
            VALUES 
            (
                $value_sql
            )
        ";
        $res = mysql_query( $sql );
    }
    $sql_k = "
        SELECT 
            * 
        FROM 
            star_garantie_kategorie 
        WHERE 
            id >-1
    ";
    $res_k = mysql_query( $sql_k );
    while ( $row_k = mysql_fetch_assoc( $res_k ) )
    {
        $id = 0;
        $stufen = array();
        for ( $i = 0; $i < $row_k["stufen"]; $i++ )
        {
            $stufen[$i] = $i;
        }
        $sql_w = "
            SELECT 
                von,
                bis,
                betrag 
            FROM 
                star_garantie 
            WHERE 
                kategorie=" . $row_k["id"] . " 
            ORDER BY von
        ";
        $res_w = mysql_query( $sql_w );
        while ( $row_w = mysql_fetch_assoc( $res_w ) )
        {
            $werte[$id++] = $row_w;
        }

        $warengruppen[] = array( "name" => $row_k["k_name"], "id" => $row_k["id"],
            "stufen" => $stufen, "werte" => $werte );
    }
    $GLOBALS["ui"]->assign( "colspan", count( $warengruppen ) );
    $GLOBALS["ui"]->assign( "Warengruppen", $warengruppen );
    $GLOBALS["ui"]->assign( "file", "common/" . basename( $_SERVER["SCRIPT_NAME"],
        "php" ) . "tpl" );
    $GLOBALS["ui"]->display( "common/page.tpl" );
?>