Changeset 20792 for branches/version-2_11-dev/data/class/db

Timestamp:

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

Author:

shutta

Message:

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

Location:

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

Files:

• SC_DB_DBFactory_MYSQL.php (modified) (1 diff)
• SC_DB_DBFactory_PGSQL.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)';
     }