| 1 |
lars |
1 |
<?
|
|
|
2 |
function getBestellungen( $ID, $cond = "", $cond2 = "" )
|
|
|
3 |
{
|
|
|
4 |
global $time2;
|
|
|
5 |
global $time3;
|
|
|
6 |
$buffer = array();
|
|
|
7 |
$query = "
|
|
|
8 |
select
|
|
|
9 |
Bestellung.ID,
|
|
|
10 |
sum( IF (artikel.status = 'offen'), 1, 0) ) AS statusO,
|
|
|
11 |
sum( IF (artikel.status = 'in Bearbeitung', 1, 0) ) AS statusB,
|
|
|
12 |
sum( IF (artikel.status = 'reserviert', 1, 0) ) AS statusR,
|
|
|
13 |
sum( IF (artikel.status = 'erledigt', 1, 0) ) AS statusE,
|
|
|
14 |
sum( IF (artikel.status = 'abgeschlossen', 1, 0) ) AS statusA,
|
|
|
15 |
sum( IF (artikel.status = 'freigegeben', 1, 0) ) AS statusF,
|
|
|
16 |
sum( IF (artikel.status = 'versand', 1, 0) ) AS statusV,
|
|
|
17 |
sum( IF (artikel.status = 'storniert', 1, 0) ) AS statusS,
|
|
|
18 |
sum( IF (artikel.status = '', 1, 0) ) AS statusLeer,
|
|
|
19 |
sum( IF (rechnungStatus = 'schreiben', 1, 0) ) AS rechnungS,
|
|
|
20 |
sum( IF (rechnungStatus = 'geschrieben', 1, 0) ) AS rechnungG,
|
|
|
21 |
sum( IF (rechnungStatus = 'bezahlt', 1, 0) ) AS rechnungB,
|
|
|
22 |
sum( IF (rechnungStatus = '', 1, 0) ) AS rechnungLeer,
|
|
|
23 |
sum( IF (lieferscheinStatus = 'offen', 1, 0) ) AS lieferscheinO,
|
|
|
24 |
sum( IF (lieferscheinStatus = 'schreiben', 1, 0) ) AS lieferscheinS,
|
|
|
25 |
sum( IF (lieferscheinStatus = 'geschrieben', 1, 0) ) AS lieferscheinG,
|
|
|
26 |
sum( IF (lieferscheinStatus = '', 1, 0) ) AS lieferscheinLeer,
|
|
|
27 |
sum(artikel_to_Bestellung.Menge) as Menge
|
|
|
28 |
from
|
|
|
29 |
artikel_to_Bestellung,
|
|
|
30 |
" . artikelDatabase() . ",
|
|
|
31 |
Bestellung,
|
|
|
32 |
Logins
|
|
|
33 |
where
|
|
|
34 |
artikel_to_Bestellung.Bestellung = Bestellung.ID
|
|
|
35 |
and
|
|
|
36 |
artikel_to_Bestellung.artikel = " . artikelDatabase() . ".ID
|
|
|
37 |
and
|
|
|
38 |
Bestellung.Language = " . artikelDatabase() . ".Language
|
|
|
39 |
and
|
|
|
40 |
Logins.ID = Bestellung.Login
|
|
|
41 |
and
|
|
|
42 |
artikel_to_Bestellung.artikel = $ID
|
|
|
43 |
$cond
|
|
|
44 |
group by Bestellung.ID
|
|
|
45 |
HAVING 1
|
|
|
46 |
$cond2";
|
|
|
47 |
|
|
|
48 |
$result = mysql_query_logged( $query ) or die( mysql_errno() . ": " .
|
|
|
49 |
mysql_error() . "<hr>$query<hr>" );
|
|
|
50 |
while ( $zeile = mysql_fetch_assoc( $result ) )
|
|
|
51 |
{
|
|
|
52 |
$buffer[] = $zeile["ID"];
|
|
|
53 |
}
|
|
|
54 |
$time2 = microtime_float();
|
|
|
55 |
return $buffer;
|
|
|
56 |
}
|
|
|
57 |
?>
|