| 1 |
lars |
1 |
<ORDER_LIST>
|
|
|
2 |
<?
|
|
|
3 |
static $stime;
|
|
|
4 |
$stime = date("Y-m-d H:i:s");
|
|
|
5 |
|
|
|
6 |
$query="
|
|
|
7 |
select
|
|
|
8 |
Bestellung.*,
|
|
|
9 |
Logins.Vorname,
|
|
|
10 |
Logins.Name1,
|
|
|
11 |
Logins.Name2,
|
|
|
12 |
Logins.Anrede,
|
|
|
13 |
Logins.Strasse,
|
|
|
14 |
Logins.Hausnummer,
|
|
|
15 |
Logins.PLZ,
|
|
|
16 |
Logins.ORT,
|
|
|
17 |
Logins.Land,
|
|
|
18 |
Logins.E_Mail,
|
|
|
19 |
Logins.Telefon,
|
|
|
20 |
Logins.Fax,
|
|
|
21 |
";
|
|
|
22 |
if ($_GET[time])
|
|
|
23 |
{ $query.=" date_format('".$_GET[time]."', '%Y-%m%-%dT%H:%i:%s') as exportet_am "; }
|
|
|
24 |
else
|
|
|
25 |
{ $query.=" date_format(now(), '%Y-%m%-%dT%H:%i:%s') as exportet_am "; }
|
|
|
26 |
|
|
|
27 |
$query.="
|
|
|
28 |
,date_format(Bestellung.erstellt_am, '%Y-%m%-%dT%H:%i:%s') as erstellt_am
|
|
|
29 |
from
|
|
|
30 |
Bestellung,
|
|
|
31 |
artikel_to_Bestellung,
|
|
|
32 |
Logins
|
|
|
33 |
where
|
|
|
34 |
Logins.ID = Bestellung.Login
|
|
|
35 |
and
|
|
|
36 |
artikel_to_Bestellung.Bestellung = Bestellung.ID
|
|
|
37 |
";
|
|
|
38 |
|
|
|
39 |
if ($_GET[time])
|
|
|
40 |
{ $query.=" and (artikel_to_Bestellung.exported_lieferschein = '".$_GET[time]."')"; }
|
|
|
41 |
else
|
|
|
42 |
{ $query.=" and artikel_to_Bestellung.lieferscheinStatus = 'schreiben'"; }
|
|
|
43 |
|
|
|
44 |
$query.=" group by artikel_to_Bestellung.Bestellung";
|
|
|
45 |
|
|
|
46 |
$result = mysql_query ($query) or die (mysql_errno().": ".mysql_error()."<hr>$query<hr>");
|
|
|
47 |
while($order=mysql_fetch_assoc($result))
|
|
|
48 |
{
|
|
|
49 |
foreach($order as $key => $value)
|
|
|
50 |
{
|
|
|
51 |
$order[$key] = str_replace("&", "&", $value);
|
|
|
52 |
}
|
|
|
53 |
|
|
|
54 |
require "includes/lexware2006/order.php";
|
|
|
55 |
|
|
|
56 |
if (($itemcount > 0) and (!$_GET[time]))
|
|
|
57 |
{
|
|
|
58 |
$query_exported="update artikel_to_Bestellung set exported_lieferschein='$stime', lieferscheinStatus='geschrieben' where Bestellung=".$order[ID]." and lieferscheinStatus='schreiben'";
|
|
|
59 |
mysql_query ($query_exported) or die (mysql_errno().": ".mysql_error()."<hr>$query<hr>");
|
|
|
60 |
}
|
|
|
61 |
}
|
|
|
62 |
?>
|
|
|
63 |
</ORDER_LIST>
|