Changeset 16745

Timestamp:

2007/11/08 12:49:50 (15 years ago)

Author:

satou

Message:

「売上集計＞会員別集計」にてキャンセルの売上も計上されるバグを修正。

File:

• branches/feature-module-update/data/class/pages/admin/total/LC_Page_Admin_Total.php (modified) (2 diffs)

branches/feature-module-update/data/class/pages/admin/total/LC_Page_Admin_Total.php

@@ -643 +643 @@
         $objQuery->setGroupBy("order_sex");
 
-        $tmp_where = $where . " AND customer_id <> 0 AND del_flg = 0 ";
+        $tmp_where = $where . " AND customer_id <> 0 AND del_flg = 0 AND status <> " . ORDER_CANCEL;
         $arrRet = $objQuery->select($col, $from, $tmp_where, $arrval);
 
@@ -654 +654 @@
 
         // 非会員集計の取得
-        $tmp_where = $where . " AND customer_id = 0 AND del_flg = 0 ";
+        $tmp_where = $where . " AND customer_id = 0 AND del_flg = 0 AND status <> " . ORDER_CANCEL;
         $arrRet = $objQuery->select($col, $from, $tmp_where, $arrval);
         // 非会員購入であることを記録する。