Subversion-Projekte lars-tiefland.content-management

<?
        session_start();
        require_once "../Online-Shop/connect2.php";     

        $_SESSION[$self] = array_merge($_SESSION[$self], $_GET);

        if ($_POST[action])
        {
                $_SESSION[$self]=$_POST;

                if
                (                               
                                ($_SESSION[$self][shop])
                        and
                                ($_SESSION[$self][agent])
                        and     
                                ($_SESSION[$self][kosten])
                        and
                                ($_SESSION[$self][time])
                )
                {
                        $query="
                                update
                                        shop_log
                                set
                                        shops_ID                =       '".$_SESSION[$self][shop]."',
                                        eintrag1                =       '".$_SESSION[$self][agent]."',
                                        eintrag2                =       '".$_SESSION[$self][kosten]."',
                                        erstellt_am             =       '".$_SESSION[$self][time]."',
                                        erstellt_von    =       '(Preisagenturkosten)'
                                where
                                        shops_ID                =       '".$_SESSION[$self][shop]."'
                                and
                                        eintrag1                =       '".$_SESSION[$self][agent]."'
                                and
                                        erstellt_am             =       '".$_SESSION[$self][time]."'
                                and
                                        erstellt_von    =       '(Preisagenturkosten)'
                                ";
                        $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
                        if (mysql_affected_rows() == 0)
                        {
                                $query="
                                        insert into
                                                shop_log
                                        (
                                                shops_ID,
                                                eintrag1,
                                                eintrag2,
                                                erstellt_am,
                                                erstellt_von
                                        )
                                        values
                                        (
                                                '".$_SESSION[$self][shop]."',
                                                '".$_SESSION[$self][agent]."',
                                                '".$_SESSION[$self][kosten]."',
                                                '".$_SESSION[$self][time]."',
                                                '(Preisagenturkosten)'
                                        )
                                        ";
                                        //pre($query);
                                $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
                        }
                }
                $query="
                        select
                                shops_ID                                                                as shop,
                                eintrag1                                                                as agent,
                                eintrag2                                                                as kosten,
                                date_format(erstellt_am, '%Y-%m-01')    as time
                        from
                                shop_log
                        where
                                shops_ID                =       '".$_SESSION[$self][shop]."'
                        and 
                                eintrag1                =       '".$_SESSION[$self][agent]."'
                        and
                                erstellt_am             =       '".$_SESSION[$self][time]."'
                        and
                                erstellt_von    =       '(Preisagenturkosten)'
                ";
                $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
                if (mysql_num_rows($result) > 0)
                {
                        $_SESSION[$self]=mysql_fetch_assoc($result);
                }
        }
        
        function getOptions($query,$preset)
        {
                $option = array();
        
                $result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
                while($zeile=mysql_fetch_array($result))
                {
                        if ($preset == $zeile[value]) { $selected = " selected"; } else { unset($selected); }
                        $options[]="<option value=\"".$zeile[value]."\"".$selected.">".$zeile[text]."</option>";
                }
                return implode("\n",$options);
        }       
?>
<html>
<head>
<title>Kosten Editor</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
body 
{
        font-family: Arial, Helvetica, sans-serif; font-size: 10pt;
<? if ($webs[font_color_seite])         { ?>color:                              #<? echo $webs[font_color_seite] ?>;<? } ?>
<? if ($webs[bgcolor_seite])            { ?>background-color:   #<? echo $webs[bgcolor_seite] ?>;<? } ?>
<? if ($webs[hintergrundbild])          { ?>background-image: url(../images/hintergrundbild/<? echo $webs[hintergrundbild] ?>);<? } ?>
}

.links
{
font-size: 10pt;
<? if ($webs[font_color_links])         { ?>color:                              #<? echo $webs[font_color_links] ?>;<? } ?>
<? if ($webs[bgcolor_links])            { ?>background-color:   #<? echo $webs[bgcolor_links] ?>;<? } ?>
}

.rechts
{
font-size: 10pt;
<? if ($webs[font_color_rechts])        { ?>color:                              #<? echo $webs[font_color_rechts] ?>;<? } ?>
<? if ($webs[bgcolor_rechts])           { ?>background-color:   #<? echo $webs[bgcolor_rechts] ?>;<? } ?>
}

A:link {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo $webs[font_color_rechts] ?>}
A:visited {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo $webs[font_color_rechts] ?>}
A:active {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo $webs[font_color_rechts] ?>}
A:hover {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo $webs[font_color_rechts] ?>}
</style>

</head>

<script language="JavaScript">
function trigger(obj)
{
        with (obj)
        {
                kosten.value='';
                submit();
        }
}

function killkomma(w)
{
 return w.replace(/,/,'.');
}
</script>

<body bgcolor="#FFFFFF" text="#000000" leftmargin="5" topmargin="5" marginwidth="5" marginheight="5">
<form method="post" action="<?=$self;?>">
  <table border="1" cellpadding="4" cellspacing="0" bordercolor="#000000">
  <tr> 
    <td>Preisagentur:</td>
    <td> 
      <select name="agent" onChange="trigger(this.form)">
        <?
                        echo getOptions
                        (
                                "select trigger_URL as value, Titel as text from Preisagentur where trigger_URL != ''",
                                $_SESSION[$self][agent]
                        );
                ?>
      </select>
    </td>
  </tr>
  <tr> 
    <td>Shop</td>
    <td> 
      <select name="shop" onChange="trigger(this.form)">
        <?
                        echo getOptions
                        (
                                "select ID as value, Name as text from shops",
                                $_SESSION[$self][shop]
                        );
                ?>
      </select>
    </td>
  </tr>
  <tr> 
    <td>Zeitraum</td>
    <td> 
      <select name="time" onChange="trigger(this.form)">
        <?
                        echo getOptions
                        (
                                "SELECT DISTINCT date_format( erstellt_am, '%Y-%m-01' ) as value, date_format( erstellt_am, '%m - %Y' ) as text FROM shop_log order by erstellt_am",
                                $_SESSION[$self][time]
                        );
                ?>
      </select>
      </td>
  </tr>
  <tr> 
    <td>Kosten</td>
    <td>
        <input type="text" name="kosten" value="<?=$_SESSION[$self][kosten]?>" onChange="this.value=killkomma(this.value);">
      </td>
  </tr>
  <tr> 
    <td colspan="2" align="center" nowrap> 
                <input type="hidden" name="action" value="true">
        <input type="submit" value="Abschicken">
        <input type="reset" value="Zur&uuml;cksetzen">
    </td>
  </tr>
</table>
</form>
</body>
</html>