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

Timestamp:

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

Author:

shutta

Message:

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

File:

• branches/version-2_11-dev/data/class/db/dbfactory/SC_DB_DBFactory_PGSQL.php (modified) (1 diff)

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)';
     }