";
// =========== Ãåíåðèì òàáëèöó ===========
$eshka = "";
$eshka2 = "";
$eshka3 = "";
$lll = "";
/*
* if(trim(@$_REQUEST['da'])=='1'){
* $eshka = "o.mktime<'1341090000' AND ";
* $eshka2 = "o.mktime<'1341090000' AND ";
* $lll = "font-weight:bold;";
* }else{
* $eshka = "o.mktime>'1341090000' AND ";
* $eshka2 = "o.mktime>'1341090000' AND ";
* $lll = "";
* }
*/
if (trim (@$_REQUEST['pr']) == '1')
{
$tim = (time () - 86400);
$eshka3 = "o.upd<'" . date ("Y-m-d H:i:s", $tim) . "' AND ";
}
else
{
$eshka3 = "";
}
if (trim (@$_REQUEST['prs']) == '1')
{
$tim = (time () - 172800);
$eshka4 = "o.upd<'" . date ("Y-m-d H:i:s", $tim) . "' AND ";
}
else
{
$eshka4 = "";
}
$order = ((isset ($_GET['order'])) ? $_GET['order'] : 'mktime');
$type = ((isset ($_GET['type'])) ? $_GET['type'] : 'DESC');
if (isset ($_GET['stat']) && $_GET['stat'] == 1)
{
$AND .= " AND o.status IN(4,5) AND o.mktime<'" . mktime (0, 0, 0, "01", "01", "2013") . "' ";
}
else
{
// $mk_and = $AND = "AND o.mktime>='".mktime(0, 0, 0, date("m"), date("d"), date("Y"))."' and o.mktime<='".mktime(0, 0, 0, date("m"), date("d")+1, date("Y"))."' ";
$AND .= " AND o.status IN(1,2) AND o.mktime>='" . mktime (0, 0, 0, "01", "01", "2013") . "' ";
$mk_and = " AND o.status IN(1,2) AND o.mktime>='" . mktime (0, 0, 0, "01", "01", "2013") . "' ";
}
if (isset ($_GET['sort_label']) && $_GET['sort_label'] != '')
{
$AND .= " AND o.label='" . $_GET['sort_label'] . "' ";
}
if (isset ($_GET['lab']))
{
$AND .= " AND o.label IN(" . implode (',', $_GET['lab']) . ")";
}
if (isset ($_GET['delivery']))
{
$AND .= " AND o.delivery IN(" . implode (',', $_GET['delivery']) . ")";
}
if (isset ($_GET['meneger']) && $_GET['meneger'] > 0)
{
$AND .= " AND o.meneger='" . $_GET['meneger'] . "'";
}
$sql = "SELECT o.*, o.name as username, o.adress as address, o.phone as tel, o.phonemob as tel2, o.`mktime` as order_date, u.group, o.id as order_id, m.*, m.product_id as mod_id, op.* , p.*, g.color as group_color,za.username as meneger_name
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
LEFT JOIN zlo_admin as za ON za.id=o.meneger
WHERE " . $eshka3 . $eshka4 . $eshka./*((!isset($_GET['search']))?"o.status='".$_GET['status']."'":"o.status>'0'").*/"1=1 $AND GROUP BY o.id ORDER BY o.$order $type ";
$pager['sql'] = $sql;
// echo $pager['sql'];
$pager = pagerGetRun ($pager, 50, 15);
$result = mysql_query ($pager['sql']) or die (mysql_error ());
if (mysql_affected_rows () != 90800)
{
// =============
// === Òàáñ ====
// =============
echo "";
echo "
";
// ////$eshka2.$eshka
$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))
{
// $AND
// Ïîäñ÷åò êîëè÷åñòâà çàêàçîâ ïî ñòàòóñó
$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 " . $eshka2 . "o.status='" . $rows['id'] . "' $AND";
// if(trim($_REQUEST['test'])=="1") echo $sql2;
/*
* $sql2 = "SELECT count(o.id) AS calc FROM catalogs_orders as o WHERE ".$eshka2."o.status='".$rows['id']."'";
*
*
* $result2 = mysql_query($sql2) or die(mysql_error());
* $row2=mysql_fetch_assoc($result2);
* $yyyyyy = str_replace("prs=1","prs=0",str_replace("pr=1","pr=0",urlQueryChange2('status',$rows['id'])));
* echo"
";
$sql4 = "SELECT * FROM zlo_book_status WHERE id IN ({$order['status']})";
$result4 = mysql_query ($sql4) or die (mysql_error ());
if (mysql_affected_rows () != 0)
{
while ($row4 = mysql_fetch_assoc ($result4))
{
if ($row4['id'] != "5")
echo $row4['title'];
}
}
echo "
";
if ($order['order_id'] == $_GET['order_ID'])
{
print '
';
// =========== Ãåíåðèì òàáëèöó ===========
$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.name as user_group, g.color as user_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_ID'] . "'";
$result1 = mysql_query ($sql) or die (mysql_error ());
if (mysql_affected_rows () != 0)
{
$order = mysql_fetch_assoc ($result1);
$r = mysql_query ("select * from card where user_id='" . $order['user_id'] . "'") or die (mysql_error ());
$c = mysql_fetch_assoc ($r);
$order['cards'] = $c['card'];
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 "
![](http://".$_SERVER[)
";
*
* // ëåãåíäà
* echo"