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

Timestamp:

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

Author:

shutta

Message:

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

Location:

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

Files:

• SC_Helper_Customer.php (modified) (2 diffs)
• SC_Helper_DB.php (modified) (3 diffs)
• SC_Helper_Mail.php (modified) (2 diffs)
• SC_Helper_Mobile.php (modified) (1 diff)
• SC_Helper_Purchase.php (modified) (8 diffs)
• SC_Helper_Session.php (modified) (2 diffs)

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

@@ -44 +44 @@
         $objQuery->begin();
 
-        $array["update_date"] = "now()";    // 更新日
+        $array["update_date"] = 'CURRENT_TIMESTAMP';    // 更新日
 
         // salt値の生成(insert時)または取得(update時)。
@@ -103 +103 @@
             // 作成日
             if (is_null($array["create_date"])){
-                $array["create_date"] = "now()";
+                $array["create_date"] = 'CURRENT_TIMESTAMP';
             }
             $objQuery->insert("dtb_customer", $array);

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 ";

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

@@ -234 +234 @@
         $sqlval['order_id'] = $order_id;
         $sqlval['template_id'] = $template_id;
-        $sqlval['send_date'] = "Now()";
+        $sqlval['send_date'] = 'CURRENT_TIMESTAMP';
         if (!isset($_SESSION['member_id'])) $_SESSION['member_id'] = "";
         if($_SESSION['member_id'] != "") {
@@ -454 +454 @@
         // メール全件送信完了後の処理
         $objQuery->update('dtb_send_history',
-                          array('end_date'=>"now()", 'complete_count'=>$complete_count),
+                          array('end_date'=>'CURRENT_TIMESTAMP', 'complete_count'=>$complete_count),
                           'send_id = ?',
                           array($send_id));

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

@@ -373 +373 @@
 
         $arrValues = array('email' => $email);
-        $arrRawValues = array('receive_date' => 'now()');
+        $arrRawValues = array('receive_date' => 'CURRENT_TIMESTAMP');
         $objQuery->update('dtb_mobile_kara_mail', $arrValues, 'kara_mail_id = ?', array($kara_mail_id), $arrRawValues);
 

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

@@ -275 +275 @@
             $this->copyFromCustomer($sqlval, $objCustomer);
             $sqlval['order_temp_id'] = $uniqId;
-            $sqlval['create_date'] = "now()";
+            $sqlval['create_date'] = 'CURRENT_TIMESTAMP';
             $objQuery->insert("dtb_order_temp", $sqlval);
         } else {
@@ -436 +436 @@
 
             $dest['customer_id'] = $objCustomer->getValue('customer_id');
-            $dest['update_date'] = 'Now()';
+            $dest['update_date'] = 'CURRENT_TIMESTAMP';
         }
     }
@@ -683 +683 @@
             }
             $arrValues['order_id'] = $order_id;
-            $arrValues['create_date'] = 'Now()';
-            $arrValues['update_date'] = 'Now()';
+            $arrValues['create_date'] = 'CURRENT_TIMESTAMP';
+            $arrValues['update_date'] = 'CURRENT_TIMESTAMP';
             $objQuery->insert($table, $arrValues);
         }
@@ -768 +768 @@
         }
 
-        $orderParams['create_date'] = 'Now()';
-        $orderParams['update_date'] = 'Now()';
+        $orderParams['create_date'] = 'CURRENT_TIMESTAMP';
+        $orderParams['update_date'] = 'CURRENT_TIMESTAMP';
 
         $this->registerOrder($orderParams['order_id'], $orderParams);
@@ -833 +833 @@
             $this->sfUpdateOrderNameCol($order_id);
 
-            $arrValues['update_date'] = 'now()';
+            $arrValues['update_date'] = 'CURRENT_TIMESTAMP';
             $objQuery->update($table, $arrValues, $where, array($order_id));
         } else {
@@ -849 +849 @@
                     SC_Utils_Ex::isBlank($arrValues['customer_id'])
                     ? 0 : $arrValues['customer_id'];
-            $arrValues['create_date'] = 'now()';
-            $arrValues['update_date'] = 'now()';
+            $arrValues['create_date'] = 'CURRENT_TIMESTAMP';
+            $arrValues['update_date'] = 'CURRENT_TIMESTAMP';
             $objQuery->insert($table, $arrValues);
 
@@ -1119 +1119 @@
             if ($addCustomerPoint != 0) {
                 // ▼会員テーブルの更新
-                $objQuery->update('dtb_customer', array('update_date' => 'Now()'),
+                $objQuery->update('dtb_customer', array('update_date' => 'CURRENT_TIMESTAMP'),
                                   'customer_id = ?', array($arrOrderOld['customer_id']),
                                   array('point' => 'point + ?'), array($addCustomerPoint));
@@ -1150 +1150 @@
         // 対応状況が発送済みに変更の場合、発送日を更新
         if ($arrOrderOld['status'] != ORDER_DELIV && $newStatus == ORDER_DELIV) {
-            $sqlval['commit_date'] = 'Now()';
+            $sqlval['commit_date'] = 'CURRENT_TIMESTAMP';
         }
         // 対応状況が入金済みに変更の場合、入金日を更新
         elseif ($arrOrderOld['status'] != ORDER_PRE_END && $newStatus == ORDER_PRE_END) {
-            $sqlval['payment_date'] = 'Now()';
+            $sqlval['payment_date'] = 'CURRENT_TIMESTAMP';
         }
 
         $sqlval['status'] = $newStatus;
-        $sqlval['update_date'] = 'Now()';
+        $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
 
         $dest = $objQuery->extractOnlyColsOf('dtb_order', $sqlval);

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

@@ -89 +89 @@
              // レコード更新
              $sqlval['sess_data'] = $sess_data;
-             $sqlval['update_date'] = 'Now()';
+             $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
              $objQuery->update("dtb_session", $sqlval, "sess_id = ?", array($id));
          } else {
@@ -96 +96 @@
                  $sqlval['sess_id'] = $id;
                  $sqlval['sess_data'] = $sess_data;
-                 $sqlval['update_date'] = 'Now()';
-                 $sqlval['create_date'] = 'Now()';
+                 $sqlval['update_date'] = 'CURRENT_TIMESTAMP';
+                 $sqlval['create_date'] = 'CURRENT_TIMESTAMP';
                  $objQuery->insert("dtb_session", $sqlval);
              }