Changeset 17144 for branches/comu-ver2/data/class/pages/admin/LC_Page_Admin_Home.php

Timestamp:

2008/03/13 03:15:22 (16 years ago)

Author:

shutta

Message:

チケット #194 の修正。
(PostgreSQL 8.3 で、substring()で切り出すには、text型でないとエラーになる不具合の修正。)

File:

• branches/comu-ver2/data/class/pages/admin/LC_Page_Admin_Home.php (modified) (2 diffs)

branches/comu-ver2/data/class/pages/admin/LC_Page_Admin_Home.php

@@ -138 +138 @@
             }else if (DB_TYPE == "mysql") {
                 $sql = "SELECT ".$method."(total) FROM dtb_order
-                         WHERE del_flg = 0 AND cast(substring(create_date,1, 10) as date) = DATE_ADD(current_date, interval -1 day) AND status <> " . ORDER_CANCEL;
+                         WHERE del_flg = 0 AND cast(create_date as date) = DATE_ADD(current_date, interval -1 day) AND status <> " . ORDER_CANCEL;
             }
             $return = $conn->getOne($sql);
@@ -182 +182 @@
         }else if (DB_TYPE == "mysql") {
             $sql = "SELECT COUNT(*) FROM dtb_review AS A LEFT JOIN dtb_products AS B ON A.product_id = B.product_id
-                     WHERE A.del_flg = 0 AND B.del_flg = 0 AND cast(substring(A.create_date,1, 10) as date) = DATE_ADD(current_date, interval -1 day)
-                     AND cast(substring(A.create_date,1, 10) as date) != cast(substring(now(),1, 10) as date)";
+                     WHERE A.del_flg = 0 AND B.del_flg = 0 AND cast(A.create_date as date) = DATE_ADD(current_date, interval -1 day)
+                     AND cast(A.create_date as date) != current_date";
         }
         $return = $conn->getOne($sql);