Changeset 21185 for branches/version-2_11-dev/data/class/helper/SC_Helper_DB.php

Timestamp:

2011/08/11 19:37:10 (15 years ago)

Author:

shutta

Message:

refs #800 (SQL標準関数を使用する)
CURRENT_TIMESTAMP を使用するように now() を置換。

File:

• branches/version-2_11-dev/data/class/helper/SC_Helper_DB.php (modified) (3 diffs)

branches/version-2_11-dev/data/class/helper/SC_Helper_DB.php

@@ -729 +729 @@
         foreach($arrDiffCategory_id as $cid) {
             $sqlval = array();
-            $sqlval['create_date'] = 'Now()';
+            $sqlval['create_date'] = 'CURRENT_TIMESTAMP';
             $sqlval['product_count'] = (string)$arrNew[$cid];
             if($sqlval['product_count'] =="") {
@@ -780 +780 @@
         foreach($arrUpdateData as $cid => $count) {
             $sqlval = array();
-            $sqlval['create_date'] = 'Now()';
+            $sqlval['create_date'] = 'CURRENT_TIMESTAMP';
             $sqlval['product_count'] = $count;
             if($sqlval['product_count'] =="") {
@@ -1271 +1271 @@
         //各メーカーの商品数を数えて格納
         $sql = " INSERT INTO dtb_maker_count(maker_id, product_count, create_date) ";
-        $sql .= " SELECT T1.maker_id, count(T2.maker_id), now() ";
+        $sql .= " SELECT T1.maker_id, count(T2.maker_id), CURRENT_TIMESTAMP ";
         $sql .= " FROM dtb_maker AS T1 LEFT JOIN dtb_products AS T2";
         $sql .= " ON T1.maker_id = T2.maker_id ";