Changeset 20241

Timestamp:

2011/02/20 06:51:07 (13 years ago)

Author:

shutta

Message:

refs #1013
会員別集計のPostgreSQLでのエラーを修正。

File:

• branches/version-2_5-dev/data/class/pages/admin/total/LC_Page_Admin_Total.php (modified) (2 diffs)

branches/version-2_5-dev/data/class/pages/admin/total/LC_Page_Admin_Total.php

@@ -490 +490 @@
             AVG(total) AS total_average,
             CASE
-                WHEN customer_id <> 0 AND order_sex = 1 THEN 1
-                WHEN customer_id <> 0 AND order_sex = 2 THEN 2
-                WHEN customer_id = 0 AND order_sex = 1 THEN 3
-                WHEN customer_id = 0 AND order_sex = 2 THEN 4
+                WHEN customer_id <> 0 THEN 1
                 ELSE 0
             END AS member,
-            order_sex,
-            customer_id
+            order_sex
                 ";
         $from       = "dtb_order";
 
-        $objQuery->setGroupBy("member");
+        $objQuery->setGroupBy("member, order_sex");
 
         $arrTotalResults = $objQuery->select($col, $from, $where, $arrval);
@@ -508 +504 @@
             $member_key = $arrResult['order_sex'];
             if($member_key != "") {
-                $arrResult['member_name'] = (($arrResult['customer_id']) ? '会員' : '非会員') . $this->arrSex[$member_key];
+                $arrResult['member_name'] = (($arrResult['member']) ? '会員' : '非会員') . $this->arrSex[$member_key];
             } else {
                 $arrResult['member_name'] = "未回答";