Changeset 13426 for branches/rel

Timestamp:

2007/05/25 10:56:40 (16 years ago)

Author:

kakinaka

Message:

職業別集計にキャンセル商品は含まないように修正

File:

• branches/rel/html/admin/total/index.php (modified) (1 diff)

branches/rel/html/admin/total/index.php

@@ -653 +653 @@
     
     $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, (AVG(total)) AS total_average ";
-    $sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.del_flg = 0 ";
+    $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;
     $sql.= "GROUP BY job ORDER BY total DESC";