";
// =========== Ãåíåðèì òàáëèöó ===========
$sql = "SELECT o.*, o.name as username, o.adress as address, o.phone as tel, o.phonemob as tel2, u.group, o.id as order_id, m.*, m.product_id as mod_id, op.* , p.*, g.color as group_color
FROM catalogs_orders as o
LEFT JOIN catalogs_orders_products as op ON op.order_id=o.id
LEFT JOIN catalogs_modifications AS m ON m.id = op.product_id
LEFT JOIN catalogs_products AS p ON p.id = m.product_id
LEFT JOIN zlo_users as u ON u.id=o.user_id
LEFT JOIN zlo_users_group as g ON g.id=u.group
WHERE o.status='".$_GET['status']."' $AND GROUP BY o.id ORDER BY o.mktime DESC ";
$pager['sql']= $sql;
$pager=pagerGetRun($pager,10,15);
// echo$pager['sql'];
$result = mysql_query($pager['sql']) or die(mysql_error());
if (mysql_affected_rows()!=0) {
// =============
// === Òàáñ ====
// =============
echo"";
echo"
";
$sql0 = "SELECT * FROM zlo_book_status WHERE id IN (1,2,4,5)";
$result0 = mysql_query($sql0) or die(mysql_error());
if (mysql_affected_rows()!=0) {
while ($rows=mysql_fetch_assoc($result0)) {
// Ïîäñ÷åò êîëè÷åñòâà çàêàçîâ ïî ñòàòóñó
$sql2 = "
SELECT count(o.`id`) AS calc, o . * , m.*, m.product_id as mod_id, op.* , p.*
FROM catalogs_orders as o
LEFT JOIN catalogs_orders_products as op ON op.order_id=o.id
LEFT JOIN catalogs_modifications AS m ON m.id = op.product_id
LEFT JOIN catalogs_products AS p ON p.id = m.product_id
LEFT JOIN zlo_users as u ON u.id=o.user_id
LEFT JOIN zlo_users_group as g ON g.id=u.group
WHERE status='".$rows['id']."' $AND";
$result2 = mysql_query($sql2) or die(mysql_error());
$row2=mysql_fetch_assoc($result2);
echo"
";
echo"";
// Ñìåíà ñòàòóñà
if ($order['status']!=6) {
echo "
Ïåðåâåñòè
";
}
echo"
";
}
echo"";
// === Pager
echo"
".pagerGetShow($pager)."
";
}
}
// ===============
// ===== show ====
// ===============
if (isset($_GET['action']) && $_GET['action']=='show') {
// Òàáñ
echo"
";
$sql = "SELECT * FROM zlo_book_status WHERE id IN (1,2,4,5)";
$result = mysql_query($sql) or die(mysql_error());
if (mysql_affected_rows()!=0) {
while ($row=mysql_fetch_assoc($result)) {
// Ïîäñ÷åò êîëè÷åñòâà çàêàçîâ ïî ñòàòóñó
$sql2 = "SELECT count(`id`) AS calc FROM catalogs_orders WHERE status='".$row['id']."' AND user_id=".$_GET['user']."";
$result2 = mysql_query($sql2) or die(mysql_error());
$row2=mysql_fetch_assoc($result2);
echo"
".$row['title']."(".$row2['calc'].")
";
}
}
echo"
";
if(!isset($_GET['status'])) {$_GET['status']=1;}
// =========== Ãåíåðèì òàáëèöó ===========
$sql = "SELECT o.*, o.name as username, o.adress as address, o.phone as tel, o.phonemob as tel2, u.group, o.id as order_id
FROM catalogs_orders as o
LEFT JOIN zlo_users as u on u.id=o.user_id
WHERE u.id=".$_GET['user']." AND o.status=".$_GET['status']." ORDER BY mktime DESC ";
$pager['sql']= $sql;
$pager=pagerGetRun($pager,10,15); //echo$pager['sql'];
$result = mysql_query($pager['sql']) or die(mysql_error());
if (mysql_affected_rows()!=0) {
// ===================
// === ÏÐÎÄÎËÆÅÍÈÅ ===
// ===================
while ($order=mysql_fetch_assoc($result)) {
echo"
";
$sql = "SELECT * FROM zlo_book_status WHERE id IN (1,2,4,5)";
$result = mysql_query($sql) or die(mysql_error());
if (mysql_affected_rows()!=0) {
while ($row=mysql_fetch_assoc($result)) {
// Ïîäñ÷åò êîëè÷åñòâà çàêàçîâ ïî ñòàòóñó
$sql2 = "SELECT count(`id`) AS calc FROM catalogs_orders WHERE status='".$row['id']."' AND user_id=".$_GET['user']."";
$result2 = mysql_query($sql2) or die(mysql_error());
$row2=mysql_fetch_assoc($result2);
echo"
".$row['title']."(".$row2['calc'].")
";
}
}
echo"
";
// =========== Ãåíåðèì òàáëèöó ===========
$sql = "SELECT o.*, o.name as username, o.adress as address, o.phone as tel, o.phonemob as tel2, u.group, o.id as order_id, o.adress as address, g.color
FROM catalogs_orders as o
LEFT JOIN zlo_users as u ON u.id=o.user_id
LEFT JOIN zlo_users_group as g ON g.id=u.group
WHERE o.id='".$_GET['order']."'";
$result = mysql_query($sql) or die(mysql_error());
if (mysql_affected_rows()!=0) {
$order=mysql_fetch_assoc($result);
echo"