Changeset 20242

Timestamp:

2011/02/20 07:04:03 (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) (1 diff)

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

@@ -592 +592 @@
         list($where, $arrval) = $this->lfGetWhereMember('create_date', $sdate, $edate, $type);
 
-        // todo postgres
-        $col    = '
-            trunc((YEAR(create_date) - YEAR(order_birth)) - (RIGHT(create_date, 5) < RIGHT(order_birth, 5)), -1) as age,
+        if (DB_TYPE == 'pgsql') {
+            $col = '
+                EXTRACT(YEAR FROM AGE(create_date, order_birth)) AS age,
+                ';
+        } else {
+            $col = '
+                trunc((YEAR(create_date) - YEAR(order_birth)) - (RIGHT(create_date, 5) < RIGHT(order_birth, 5)), -1) as age,
+                ';
+        }
+
+        $col .= '
             COUNT(order_id) AS order_count,
             SUM(total) AS total,