Changeset 20792

Timestamp:

2011/03/29 16:45:10 (12 years ago)

Author:

shutta

Message:

refs #801 DB_TYPE で分岐している箇所の抽象化
売上集計の年代別集計での分岐部分の対応

Location:

branches/version-2_11-dev/data/class

Files:

• db/dbfactory/SC_DB_DBFactory_MYSQL.php (modified) (1 diff)
• db/dbfactory/SC_DB_DBFactory_PGSQL.php (modified) (1 diff)
• pages/admin/total/LC_Page_Admin_Total.php (modified) (1 diff)

branches/version-2_11-dev/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php

@@ -181 +181 @@
             SUM(total) AS total,
             AVG(total) AS total_average";
+    }
+
+    /**
+     * 売上集計の年代別集計の年代抽出部分のSQLを返す
+     *
+     * @return string 年代抽出部分の SQL
+     */
+    function getOrderTotalAgeColSql() {
+        return 'TRUNC((YEAR(create_date) - YEAR(order_birth)) - (RIGHT(create_date, 5) < RIGHT(order_birth, 5)), -1)';
     }
 

branches/version-2_11-dev/data/class/db/dbfactory/SC_DB_DBFactory_PGSQL.php

@@ -164 +164 @@
             SUM(total) AS total,
             AVG(total) AS total_average";
+    }
+
+    /**
+     * 売上集計の年代別集計の年代抽出部分のSQLを返す
+     *
+     * @return string 年代抽出部分の SQL
+     */
+    function getOrderTotalAgeColSql() {
+        return 'TRUNC(CAST(EXTRACT(YEAR FROM AGE(create_date, order_birth)) AS INT), -1)';
     }
 

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

@@ -614 +614 @@
         list($where, $arrval) = $this->lfGetWhereMember('create_date', $sdate, $edate, $type);
 
-        if (DB_TYPE == 'pgsql') {
-            $col = '
-                TRUNC(CAST(EXTRACT(YEAR FROM AGE(create_date, order_birth)) AS INT), -1) AS age,
-                ';
-        } else {
-            $col = '
-                trunc((YEAR(create_date) - YEAR(order_birth)) - (RIGHT(create_date, 5) < RIGHT(order_birth, 5)), -1) as age,
-                ';
-        }
-
-        $col .= '
+        $dbFactory = SC_DB_DBFactory_Ex::getInstance();
+        $col = $dbFactory->getOrderTotalAgeColSql() . ' AS age,
             COUNT(order_id) AS order_count,
             SUM(total) AS total,