'; echo'

Çàêàçû

'; echo'

'; // Òàáñ $sql = "SELECT * FROM zlo_book_status WHERE id IN (1)"; $result = mysql_query($sql) or die(mysql_error()); if (mysql_affected_rows()!=0) { echo"

"; while ($row=mysql_fetch_assoc($result)) { // Ïîäñ÷åò êîëè÷åñòâà çàêàçîâ ïî ñòàòóñó $sql2 = "SELECT count(`id`) AS calc FROM catalogs_orders WHERE status='".$row['id']."' AND user_id='".$_SESSION['user']['id']."'"; $result2 = mysql_query($sql2) or die(mysql_error()); $row2=mysql_fetch_assoc($result2); if (mysql_affected_rows()!=0) { echo"".$row['title']."(".$row2['calc'].")"; } } echo"

"; } // =========== Ãåíåðèì òàáëèöó =========== if (!isset($GET['status'])) {$GET['status']=1;} $sql = "SELECT o.*, o.id as order_id, o.`mktime` as order_date FROM catalogs_orders as o LEFT JOIN zlo_users as u on u.id=o.user_id WHERE o.user_id=".$_SESSION['user']['id']." AND o.`status`='".$GET['status']."' ORDER BY mktime DESC "; $pager['sql']= $sql; $pager=pagerGetRun($pager,10,15); $result = mysql_query($pager['sql']) or die(mysql_error()); if (mysql_affected_rows()!=0) { while ($order=mysql_fetch_assoc($result)) { echo"

"; // Èíôîðìàöèÿ î çàêàçå echo"

Çàêàç #".$order['order_id']."
Ñòàòóñ: ".viewBook('zlo_book_status', $order['status'], 'id', 'title')."
Äàòà: ".date('Y-m-d H:i:s',$order['order_date'])."

Äîñòàâêà Äîñòàâêà:

".viewBook('zlo_book_delivery', $order['delivery'], 'id', 'title')."

Ãîðîä:

".$order['city']."

Àäðåñ:

".$order['adress']."

"; echo"

"; // Òàáëèöà òîâàðîâ $sql3 = "SELECT * FROM catalogs_orders_products WHERE `order_id`='".$order['order_id']."' "; $result3 = mysql_query($sql3) or die(mysql_error()); if (mysql_affected_rows()!=0) { $i=0; echo"

Òîâàðû"; echo""; while ($item_id=mysql_fetch_assoc($result3)) { $i++; $sql4 = "select * from catalogs_modifications left join catalogs_products on catalogs_products.id=catalogs_modifications.product_id where catalogs_modifications.id='".$item_id['product_id']."' "; $result4 = mysql_query($sql4) or die(mysql_error()); if (mysql_affected_rows()!=0) { while ($item=mysql_fetch_assoc($result4)) { echo""; } } } echo"

¹	Àðòèêóë	Áðåíä	Íàçâàíèå	Êîë.	Öåíà	Ñóììà
$i .	".$item['id']."	".viewBook('catalogs_brends', $item['brend_id'], 'id', 'name')."	".$item['name']."	".$item_id['count']."	".$item['cine']."	".($item['cine']*$item_id['count'])."

Îáùàÿ ñóììà: ".$order['total']." ãðí.

"; } echo"

"; echo"

"; } // === Pager if($pager['TotalRows']>$pager['Size']) { echo""; } } else { echo "

"; echo "Ó Âàñ íåò çàêàçîâ"; } echo"

"; echo"

Çàêàç #".$order['order_id']." Ñòàòóñ: ".viewBook('zlo_book_status', $order['status'], 'id', 'title')." Äàòà: ".date('Y-m-d H:i:s',$order['order_date'])."

Çàêàç #".$order['order_id']."
Ñòàòóñ: ".viewBook('zlo_book_status', $order['status'], 'id', 'title')."
Äàòà: ".date('Y-m-d H:i:s',$order['order_date'])."