Changeset 4608 for temp/trunk/html/admin/total

Timestamp:

2006/09/11 19:37:56 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/html/admin/total/index.php (modified) (3 diffs)

temp/trunk/html/admin/total/index.php

@@ -548 +548 @@
     $objQuery->setGroupBy("order_sex");
     
-    $tmp_where = $where . " AND customer_id <> 0 AND delete = 0 ";
+    $tmp_where = $where . " AND customer_id <> 0 AND del_flg = 0 ";
     $arrRet = $objQuery->select($col, $from, $tmp_where, $arrval);
     
@@ -559 +559 @@
     
     // Èó²ñ°÷½¸·×¤Î¼èÆÀ
-    $tmp_where = $where . " AND customer_id = 0 AND delete = 0 ";
+    $tmp_where = $where . " AND customer_id = 0 AND del_flg = 0 ";
     $arrRet = $objQuery->select($col, $from, $tmp_where, $arrval);
     // Èó²ñ°÷¹ØÆþ¤Ç¤¢¤ë¤³¤È¤òµ­Ï¿¤¹¤ë¡£
@@ -616 +616 @@
     
     $sql = "SELECT job, count(*) AS order_count, SUM(total) AS total, int8(AVG(total)) AS total_average ";
-    $sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.delete = 0";
+    $sql.= "FROM dtb_customer AS T1 LEFT JOIN dtb_order AS T2 USING ( customer_id ) WHERE $where AND T2.del_flg = 0";
     $sql.= "GROUP BY job ORDER BY total DESC";