| 1 |
lars |
1 |
<?
|
|
|
2 |
$sButtons= array
|
|
|
3 |
(
|
|
|
4 |
array("statusO", "status_red"),
|
|
|
5 |
array("statusB", "status_yellow"),
|
|
|
6 |
array("statusR", "status_blue"),
|
|
|
7 |
array("statusE", "status_green"),
|
|
|
8 |
array("statusA", "status_white")
|
|
|
9 |
);
|
|
|
10 |
$sButtons2= array
|
|
|
11 |
(
|
|
|
12 |
array("rechnungS", "status_red"),
|
|
|
13 |
array("rechnungG", "status_yellow"),
|
|
|
14 |
array("rechnungB", "status_green")
|
|
|
15 |
);
|
|
|
16 |
$sButtons3= array
|
|
|
17 |
(
|
|
|
18 |
array("lieferscheinS", "status_yellow"),
|
|
|
19 |
array("lieferscheinG", "status_green"),
|
|
|
20 |
array("lieferscheinO", "status_red"),
|
|
|
21 |
);
|
|
|
22 |
function page_select($count, $page)
|
|
|
23 |
{
|
|
|
24 |
global $self;
|
|
|
25 |
global $order;
|
|
|
26 |
|
|
|
27 |
$page_select="<select onChange=\"location.href='$self?action=select_edit&order=$order&page='+(this.selectedIndex+1)\">\n";
|
|
|
28 |
$end=ceil($count/Range);
|
|
|
29 |
for ($i=1; $i<=$end; $i++)
|
|
|
30 |
{
|
|
|
31 |
$page_select.="\t<option";
|
|
|
32 |
if ($page==$i) {$page_select.=" selected";}
|
|
|
33 |
$page_select.=">Seite: $i </option>\n";
|
|
|
34 |
}
|
|
|
35 |
$page_select.="</select> von $end\n";
|
|
|
36 |
if ($end == 0) { $page_select = ""; }
|
|
|
37 |
|
|
|
38 |
return $page_select;
|
|
|
39 |
}
|
|
|
40 |
if(($filter["page"]-1)*Range > $count)
|
|
|
41 |
{
|
|
|
42 |
$filter["page"]=1;
|
|
|
43 |
}
|
|
|
44 |
$page_select = page_select($count, $filter["page"]);
|
|
|
45 |
?>
|
|
|
46 |
<table width="100%" border="1" cellspacing="0" cellpadding="3" bordercolorlight="#FFFFFF" bordercolordark="#999999">
|
|
|
47 |
<? if ($page_select != "") { ?>
|
|
|
48 |
<tr>
|
|
|
49 |
<td align="center" colspan="7">
|
|
|
50 |
<table width="100%" border="0" cellspacing="0" cellpadding="0">
|
|
|
51 |
<tr>
|
|
|
52 |
<td width="10%" class="rechts"><a href="<?=$self?>?action=select_edit&order=<?=$order ?>&page=<? if ($filter[page] > 1) {echo $filter[page]-1;} else {echo "1";} ?>">zurück</a></td>
|
|
|
53 |
<td width="85%" align="center" class="rechts"><?=$page_select;?></td>
|
|
|
54 |
<td width="10%" align="right" class="rechts"><a href="<?=$self?>?action=select_edit&order=<?=$order ?>&page=<? if (($filter[page]) * Range < $count) {echo $filter[page]+1;} else {echo $filter[page];} ?>">weiter</a></td>
|
|
|
55 |
</tr>
|
|
|
56 |
</table>
|
|
|
57 |
</td>
|
|
|
58 |
</tr>
|
|
|
59 |
<? } ?>
|
|
|
60 |
<tr>
|
|
|
61 |
<td align="center" class="rechts"><a href="<?=$self ?>?order=<? if ($order == "Bestellnummer") {echo "_"; }?>Bestellnummer">BestellNr.</a></td>
|
|
|
62 |
<td width="11%" align="center" class="rechts"><a href="<?=$self ?>?order=<? if ($order == "Bestelldatum") {echo "_"; }?>Bestelldatum">Best.datum</a></td>
|
|
|
63 |
<td width="9%" align="center" class="rechts">Status</td>
|
|
|
64 |
<?
|
|
|
65 |
if (isset($user_rechte[modul_name][tool_name][rechnungStatus]))
|
|
|
66 |
{
|
|
|
67 |
?><td width="9%" align="center" class="rechts">Rechnung</td><?
|
|
|
68 |
}
|
|
|
69 |
?>
|
|
|
70 |
<?
|
|
|
71 |
if (isset($user_rechte[modul_name][tool_name][lieferscheinStatus]))
|
|
|
72 |
{
|
|
|
73 |
?><td width="9%" align="center" class="rechts">Lieferschein</td><?
|
|
|
74 |
}
|
|
|
75 |
?>
|
|
|
76 |
<td width="9%" align="center" class="rechts">Betrag</td>
|
|
|
77 |
<td width="72%" class="rechts"><a href="<?=$self ?>?order=<? if ($order == "Kunde") {echo "_"; }?>Kunde">Kunde</a>,
|
|
|
78 |
<a href="<?=$self ?>?order=<? if ($order == "PLZ") {echo "_"; }?>PLZ">PLZ</a>/<a href="<?=$self ?>?order=<? if ($order == "ORT") {echo "_"; }?>ORT">Ort</a>
|
|
|
79 |
, <a href="<?=$self ?>?order=<? if ($order == "Land") {echo "_"; }?>Land">Land</a>
|
|
|
80 |
- <a href="<?=$self ?>?order=<? if ($order == "Language") {echo "_"; }?>Language">Shop</a></td>
|
|
|
81 |
</tr>
|
|
|
82 |
<?
|
|
|
83 |
$query2.=" limit ".($filter["page"]-1)*Range.", ".Range;
|
|
|
84 |
//mail ( "niewerth@weban.de", "Fehler in bestellung_liste.php ".$PHP_AUTH_USER, mysql_errno().": ".mysql_error()." in File: ".__FILE__." at line: ".__LINE__."<hr>$query2<hr>", "from: content-management.de");
|
|
|
85 |
//echo $query2;
|
|
|
86 |
$result = mysql_query_logged ($query2) or die (mysql_errno().": ".mysql_error()."<hr>$query<hr>");
|
|
|
87 |
$time2=microtime_float();
|
|
|
88 |
while ($zeile=mysql_fetch_assoc($result))
|
|
|
89 |
{
|
|
|
90 |
/* echo "<pre>";
|
|
|
91 |
var_dump($zeile);
|
|
|
92 |
echo "</pre>";
|
|
|
93 |
*/
|
|
|
94 |
/*
|
|
|
95 |
$zeile=array_merge($zeile, getBestellungStatus($zeile[ID]));
|
|
|
96 |
$zeile=array_merge($zeile, getBestellungSumme($zeile[ID]));
|
|
|
97 |
if (isset($user_rechte[modul_name][tool_name][rechnungStatus]))
|
|
|
98 |
{
|
|
|
99 |
$zeile=array_merge($zeile, getBestellungRechnungStatus($zeile[ID]));
|
|
|
100 |
}
|
|
|
101 |
*/
|
|
|
102 |
|
|
|
103 |
/* if ($zeile[artikelstatus_buffer] != "")
|
|
|
104 |
{
|
|
|
105 |
//$zeile=array_merge($zeile, unserialize($zeile[artikelstatus_buffer]));
|
|
|
106 |
$zeile2=unserialize($zeile[artikelstatus_buffer]);
|
|
|
107 |
}
|
|
|
108 |
else
|
|
|
109 |
{
|
|
|
110 |
//$zeile=array_merge($zeile, getBestellungStatus($zeile[ID]));
|
|
|
111 |
$zeile2=getBestellungStatus($zeile[ID]);
|
|
|
112 |
}
|
|
|
113 |
|
|
|
114 |
|
|
|
115 |
|
|
|
116 |
if ($zeile[rechnungsstatus_buffer] != "")
|
|
|
117 |
{
|
|
|
118 |
// $zeile=array_merge($zeile, unserialize($zeile[rechnungsstatus_buffer]));
|
|
|
119 |
$zeile3=unserialize($zeile[rechnungsstatus_buffer]);
|
|
|
120 |
}
|
|
|
121 |
else
|
|
|
122 |
{
|
|
|
123 |
//$zeile=array_merge($zeile, getBestellungRechnungStatus($zeile[ID]));
|
|
|
124 |
$zeile3=getBestellungRechnungStatus($zeile[ID]);
|
|
|
125 |
}
|
|
|
126 |
|
|
|
127 |
|
|
|
128 |
|
|
|
129 |
if (isset($user_rechte[modul_name][tool_name][lieferscheinStatus]))
|
|
|
130 |
{
|
|
|
131 |
if ($zeile[lieferscheinStatus_buffer] != "")
|
|
|
132 |
{
|
|
|
133 |
//$zeile=array_merge($zeile, unserialize($zeile[lieferscheinStatus_buffer]));
|
|
|
134 |
$zeile4=unserialize($zeile[lieferscheinStatus_buffer]);
|
|
|
135 |
}
|
|
|
136 |
else
|
|
|
137 |
{
|
|
|
138 |
//$zeile=array_merge($zeile, getBestellungLieferscheinStatus($zeile[ID]));
|
|
|
139 |
$zeile4=getBestellungLieferscheinStatus($zeile[ID]);
|
|
|
140 |
}
|
|
|
141 |
}
|
|
|
142 |
|
|
|
143 |
|
|
|
144 |
|
|
|
145 |
if ($zeile[gesamtsumme_buffer] > 0)
|
|
|
146 |
{
|
|
|
147 |
$zeile[Gesamtsumme]=$zeile[gesamtsumme_buffer];
|
|
|
148 |
}
|
|
|
149 |
else
|
|
|
150 |
{
|
|
|
151 |
//$zeile=array_merge($zeile, getBestellungSumme($zeile[ID]));
|
|
|
152 |
$zeile["Gesamtsumme"]=getBestellungSumme($zeile[ID]);
|
|
|
153 |
}*/
|
|
|
154 |
?>
|
|
|
155 |
<tr>
|
|
|
156 |
<td align="center">
|
|
|
157 |
<table width="75%" border="0" cellspacing="0" cellpadding="0">
|
|
|
158 |
<tr>
|
|
|
159 |
<td align="right"> <a name="<?=$zeile[Bestellung] ?>" href="<?=$self ?>?Bestellung=<?=$zeile[Bestellung] ?>">
|
|
|
160 |
<span style="color:#000000"><?=$zeile[Bestellung] ?></span>
|
|
|
161 |
</a> </td>
|
|
|
162 |
</tr>
|
|
|
163 |
</table>
|
|
|
164 |
</td>
|
|
|
165 |
<td width="11%" align="center"> <a href="javascript:alert('<?=$zeile[bestellZeit];?> Uhr')" title="<?=$zeile[bestellZeit];?> Uhr">
|
|
|
166 |
<span style="color:#000000"><?=$zeile[bestellDatum] ?></span>
|
|
|
167 |
</a> </td>
|
|
|
168 |
<td width="9%" align="center" style="padding:0; margin:0">
|
|
|
169 |
<table cellpadding="0" cellspacing="0" style="border:1px solid #999999;">
|
|
|
170 |
<tr>
|
|
|
171 |
<?
|
|
|
172 |
foreach($sButtons as $sButton)
|
|
|
173 |
{
|
|
|
174 |
if ($zeile[$sButton[0]])
|
|
|
175 |
{
|
|
|
176 |
?><td valign="top" nowrap class="<?=$sButton[1];?>"> <?=$zeile[$sButton[0]];?> </td><?
|
|
|
177 |
}
|
|
|
178 |
}
|
|
|
179 |
?>
|
|
|
180 |
</tr>
|
|
|
181 |
</table>
|
|
|
182 |
|
|
|
183 |
</td>
|
|
|
184 |
<?
|
|
|
185 |
if (isset($user_rechte[modul_name][tool_name][rechnungStatus]))
|
|
|
186 |
{
|
|
|
187 |
?>
|
|
|
188 |
<td width="9%" align="center" style="padding:0; margin:0">
|
|
|
189 |
<table cellpadding="0" cellspacing="0" style="border:1px solid #999999;">
|
|
|
190 |
<tr>
|
|
|
191 |
<?
|
|
|
192 |
|
|
|
193 |
foreach($sButtons2 as $sButton)
|
|
|
194 |
{
|
|
|
195 |
if ($zeile[$sButton[0]])
|
|
|
196 |
{
|
|
|
197 |
?><td valign="top" nowrap class="<?=$sButton[1];?>"> <?=$zeile[$sButton[0]];?> </td><?
|
|
|
198 |
}
|
|
|
199 |
}
|
|
|
200 |
?>
|
|
|
201 |
</tr>
|
|
|
202 |
</table>
|
|
|
203 |
</td>
|
|
|
204 |
<? } ?>
|
|
|
205 |
<?
|
|
|
206 |
if (isset($user_rechte[modul_name][tool_name][lieferscheinStatus]))
|
|
|
207 |
{
|
|
|
208 |
?>
|
|
|
209 |
<td width="9%" align="center" style="padding:0; margin:0">
|
|
|
210 |
<table cellpadding="0" cellspacing="0" style="border:1px solid #999999;">
|
|
|
211 |
<tr>
|
|
|
212 |
<?
|
|
|
213 |
|
|
|
214 |
foreach($sButtons3 as $sButton)
|
|
|
215 |
{
|
|
|
216 |
if ($zeile[$sButton[0]])
|
|
|
217 |
{
|
|
|
218 |
?><td valign="top" nowrap class="<?=$sButton[1];?>"> <?=$zeile[$sButton[0]];?> </td><?
|
|
|
219 |
}
|
|
|
220 |
}
|
|
|
221 |
?>
|
|
|
222 |
</tr>
|
|
|
223 |
</table>
|
|
|
224 |
</td>
|
|
|
225 |
<? } ?>
|
|
|
226 |
<td width="9%" align="right" nowrap>
|
|
|
227 |
<?=number_format($zeile[Betrag],2,',','.'). '€';?>
|
|
|
228 |
</td>
|
|
|
229 |
<td width="72%" nowrap>
|
|
|
230 |
<?php
|
|
|
231 |
// <!-- Highlight Funktion -->
|
|
|
232 |
// <!-- Markus Niewerth 23.04.2004 -->
|
|
|
233 |
$Firma = (!empty($filter["kundensuche"]))
|
|
|
234 |
? str_replace($filter["kundensuche"],"<b>".$filter["kundensuche"]."</b>",$zeile["Name2"])
|
|
|
235 |
: $zeile["Name2"];
|
|
|
236 |
$Name1 = (!empty($filter["kundensuche"]))
|
|
|
237 |
? str_replace($filter["kundensuche"],"<b>".$filter["kundensuche"]."</b>",$zeile["Name1"])
|
|
|
238 |
: $zeile["Name1"];
|
|
|
239 |
$Vorname = (!empty($filter["kundensuche"]))
|
|
|
240 |
? str_replace($filter["kundensuche"],"<b>".$filter["kundensuche"]."</b>",$zeile["Vorname"])
|
|
|
241 |
: $zeile["Vorname"];
|
|
|
242 |
|
|
|
243 |
$PLZ = (!empty($filter[kundensuche]))
|
|
|
244 |
? str_replace($filter[kundensuche],"<b>".$filter[kundensuche]."</b>",$zeile[PLZ])
|
|
|
245 |
: $zeile[PLZ];
|
|
|
246 |
|
|
|
247 |
$ORT = (!empty($filter[kundensuche]))
|
|
|
248 |
? str_replace($filter[kundensuche],"<b>".$filter[kundensuche]."</b>",$zeile[ORT])
|
|
|
249 |
: $zeile[ORT];
|
|
|
250 |
|
|
|
251 |
$Land = (!empty($filter[kundensuche]))
|
|
|
252 |
? str_replace($filter[kundensuche],"<b>".$filter[kundensuche]."</b>",$zeile[Land])
|
|
|
253 |
: $zeile[Land];
|
|
|
254 |
|
|
|
255 |
$Language = (!empty($filter[kundensuche]))
|
|
|
256 |
? str_replace($filter[kundensuche],"<b>".$filter[kundensuche]."</b>",$zeile[Language])
|
|
|
257 |
: $zeile[Language];
|
|
|
258 |
// <!-- Ende Highlight Funktion -->
|
|
|
259 |
if ($Firma)
|
|
|
260 |
{
|
|
|
261 |
echo "$Firma, ";
|
|
|
262 |
}
|
|
|
263 |
?>
|
|
|
264 |
<?=$Vorname." ".$Name1 ?>
|
|
|
265 |
,
|
|
|
266 |
<?=$PLZ ?>
|
|
|
267 |
<?=$ORT ?>
|
|
|
268 |
,
|
|
|
269 |
<?=$Land ?>
|
|
|
270 |
-
|
|
|
271 |
<?=$_SESSION[shops][$zeile[shops_ID]][Name];?>
|
|
|
272 |
</td>
|
|
|
273 |
</tr>
|
|
|
274 |
<?
|
|
|
275 |
}
|
|
|
276 |
?>
|
|
|
277 |
<? if ($page_select != "") { ?>
|
|
|
278 |
<tr>
|
|
|
279 |
<td align="center" colspan="7">
|
|
|
280 |
<table width="100%" border="0" cellspacing="0" cellpadding="0">
|
|
|
281 |
<tr>
|
|
|
282 |
<td width="10%" class="rechts"><a href="<?=$self?>?action=select_edit&order=<?=$order ?>&page=<? if ($filter[page] > 1) {echo $filter[page]-1;} else {echo "1";} ?>">zurück</a></td>
|
|
|
283 |
<td width="85%" align="center" class="rechts"><?=$page_select;?></td>
|
|
|
284 |
<td width="10%" align="right" class="rechts"><a href="<?=$self?>?action=select_edit&order=<?=$order ?>&page=<? if (($filter[page]) * Range < $count) {echo $filter[page]+1;} else {echo $filter[page];} ?>">weiter</a></td>
|
|
|
285 |
</tr>
|
|
|
286 |
</table>
|
|
|
287 |
</td>
|
|
|
288 |
</tr>
|
|
|
289 |
<? }
|
|
|
290 |
$time2=microtime_float();
|
|
|
291 |
?>
|
|
|
292 |
</table>
|