Changeset 13415
- Timestamp:
- 2007/05/25 10:40:53 (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/dev/html/admin/total/index.php
r13414 r13415 659 659 660 660 $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, (AVG(total)) AS total_average "; 661 $sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.del_flg = 0 ";661 $sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.del_flg = 0 and T2.status <> " . ORDER_CANCEL; 662 662 $sql.= "GROUP BY job ORDER BY total DESC"; 663 663 664 664 $objQuery = new SC_Query(); 665 665 $objPage->arrResults = $objQuery->getall($sql, $arrval); 666 667 668 sfprintr($objQuery->getlastquery(false)); 666 669 667 670 $max = count($objPage->arrResults);
Note: See TracChangeset
for help on using the changeset viewer.