Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?
2 
	session_start();
3 
	require_once "../Online-Shop/connect2.php";
4 
 
5 
	$_SESSION[$self] = array_merge($_SESSION[$self], $_GET);
6 
 
7 
	if ($_POST[action])
8 
	{
9 
		$_SESSION[$self]=$_POST;
10 
 
11 
		if
12 
		(
13 
				($_SESSION[$self][shop])
14 
			and
15 
				($_SESSION[$self][agent])
16 
			and
17 
				($_SESSION[$self][kosten])
18 
			and
19 
				($_SESSION[$self][time])
20 
		)
21 
		{
22 
			$query="
23 
				update
24 
					shop_log
25 
				set
26 
					shops_ID		=	'".$_SESSION[$self][shop]."',
27 
					eintrag1		=	'".$_SESSION[$self][agent]."',
28 
					eintrag2		=	'".$_SESSION[$self][kosten]."',
29 
					erstellt_am		=	'".$_SESSION[$self][time]."',
30 
					erstellt_von	=	'(Preisagenturkosten)'
31 
				where
32 
					shops_ID		=	'".$_SESSION[$self][shop]."'
33 
				and
34 
					eintrag1		=	'".$_SESSION[$self][agent]."'
35 
				and
36 
					erstellt_am		=	'".$_SESSION[$self][time]."'
37 
				and
38 
					erstellt_von	=	'(Preisagenturkosten)'
39 
				";
40 
			$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
41 
			if (mysql_affected_rows() == 0)
42 
			{
43 
				$query="
44 
					insert into
45 
						shop_log
46 
					(
47 
						shops_ID,
48 
						eintrag1,
49 
						eintrag2,
50 
						erstellt_am,
51 
						erstellt_von
52 
					)
53 
					values
54 
					(
55 
						'".$_SESSION[$self][shop]."',
56 
						'".$_SESSION[$self][agent]."',
57 
						'".$_SESSION[$self][kosten]."',
58 
						'".$_SESSION[$self][time]."',
59 
						'(Preisagenturkosten)'
60 
					)
61 
					";
62 
					//pre($query);
63 
				$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
64 
			}
65 
		}
66 
		$query="
67 
			select
68 
				shops_ID								as shop,
69 
				eintrag1								as agent,
70 
				eintrag2								as kosten,
71 
				date_format(erstellt_am, '%Y-%m-01')	as time
72 
			from
73 
				shop_log
74 
			where
75 
				shops_ID		=	'".$_SESSION[$self][shop]."'
76 
			and
77 
				eintrag1		=	'".$_SESSION[$self][agent]."'
78 
			and
79 
				erstellt_am		=	'".$_SESSION[$self][time]."'
80 
			and
81 
				erstellt_von	=	'(Preisagenturkosten)'
82 
		";
83 
		$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
84 
		if (mysql_num_rows($result) > 0)
85 
		{
86 
			$_SESSION[$self]=mysql_fetch_assoc($result);
87 
		}
88 
	}
89 
 
90 
	function getOptions($query,$preset)
91 
	{
92 
		$option = array();
93 
 
94 
		$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error());
95 
		while($zeile=mysql_fetch_array($result))
96 
		{
97 
			if ($preset == $zeile[value]) { $selected = " selected"; } else { unset($selected); }
98 
			$options[]="<option value=\"".$zeile[value]."\"".$selected.">".$zeile[text]."</option>";
99 
		}
100 
		return implode("\n",$options);
101 
	}
102 
?>
103 
<html>
104 
<head>
105 
<title>Kosten Editor</title>
106 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
107 
<style type="text/css">
108 
body
109 
{
110 
	font-family: Arial, Helvetica, sans-serif; font-size: 10pt;
111 
<? if ($webs[font_color_seite])		{ ?>color:				#<? echo $webs[font_color_seite] ?>;<? } ?>
112 
<? if ($webs[bgcolor_seite])		{ ?>background-color:	#<? echo $webs[bgcolor_seite] ?>;<? } ?>
113 
<? if ($webs[hintergrundbild]) 		{ ?>background-image: url(../images/hintergrundbild/<? echo $webs[hintergrundbild] ?>);<? } ?>
114 
}
115 
 
116 
.links
117 
{
118 
font-size: 10pt;
119 
<? if ($webs[font_color_links])		{ ?>color:				#<? echo $webs[font_color_links] ?>;<? } ?>
120 
<? if ($webs[bgcolor_links])		{ ?>background-color:	#<? echo $webs[bgcolor_links] ?>;<? } ?>
121 
}
122 
 
123 
.rechts
124 
{
125 
font-size: 10pt;
126 
<? if ($webs[font_color_rechts])	{ ?>color:				#<? echo $webs[font_color_rechts] ?>;<? } ?>
127 
<? if ($webs[bgcolor_rechts])		{ ?>background-color:	#<? echo $webs[bgcolor_rechts] ?>;<? } ?>
128 
}
129 
 
130 
A:link {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo $webs[font_color_rechts] ?>}
131 
A:visited {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo $webs[font_color_rechts] ?>}
132 
A:active {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo $webs[font_color_rechts] ?>}
133 
A:hover {font-family: Arial, Helvetica, sans-serif; font-size: 10pt; color: #<? echo $webs[font_color_rechts] ?>}
134 
</style>
135 
 
136 
</head>
137 
 
138 
<script language="JavaScript">
139 
function trigger(obj)
140 
{
141 
	with (obj)
142 
	{
143 
		kosten.value='';
144 
		submit();
145 
	}
146 
}
147 
 
148 
function killkomma(w)
149 
{
150 
 return w.replace(/,/,'.');
151 
}
152 
</script>
153 
 
154 
<body bgcolor="#FFFFFF" text="#000000" leftmargin="5" topmargin="5" marginwidth="5" marginheight="5">
155 
<form method="post" action="<?=$self;?>">
156 
  <table border="1" cellpadding="4" cellspacing="0" bordercolor="#000000">
157 
  <tr>
158 
    <td>Preisagentur:</td>
159 
    <td>
160 
      <select name="agent" onChange="trigger(this.form)">
161 
        <?
162 
			echo getOptions
163 
			(
164 
				"select trigger_URL as value, Titel as text from Preisagentur where trigger_URL != ''",
165 
				$_SESSION[$self][agent]
166 
			);
167 
		?>
168 
      </select>
169 
    </td>
170 
  </tr>
171 
  <tr>
172 
    <td>Shop</td>
173 
    <td>
174 
      <select name="shop" onChange="trigger(this.form)">
175 
        <?
176 
			echo getOptions
177 
			(
178 
				"select ID as value, Name as text from shops",
179 
				$_SESSION[$self][shop]
180 
			);
181 
		?>
182 
      </select>
183 
    </td>
184 
  </tr>
185 
  <tr>
186 
    <td>Zeitraum</td>
187 
    <td>
188 
      <select name="time" onChange="trigger(this.form)">
189 
        <?
190 
			echo getOptions
191 
			(
192 
				"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",
193 
				$_SESSION[$self][time]
194 
			);
195 
		?>
196 
      </select>
197 
      </td>
198 
  </tr>
199 
  <tr>
200 
    <td>Kosten</td>
201 
    <td>
202 
        <input type="text" name="kosten" value="<?=$_SESSION[$self][kosten]?>" onChange="this.value=killkomma(this.value);">
203 
      </td>
204 
  </tr>
205 
  <tr>
206 
    <td colspan="2" align="center" nowrap>
207 
		<input type="hidden" name="action" value="true">
208 
        <input type="submit" value="Abschicken">
209 
        <input type="reset" value="Zur&uuml;cksetzen">
210 
    </td>
211 
  </tr>
212 
</table>
213 
</form>
214 
</body>
215 
</html>