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

Timestamp:

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

Author:

shutta

Message:

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

File:

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

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