";
// =========== Ãåíåðèì òàáëèöó ===========
$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']).")";
}
$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
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 ".$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,30,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"
';
// =========== Ãåíåðèì òàáëèöó ===========
$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);
echo"
';
}
$i1++;
} print"
";
print"
";
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"
![](http://".$_SERVER[)
";
// ëåãåíäà
echo"