- Timestamp:
- 2011/08/11 19:37:10 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_11-dev/data/class/helper/SC_Helper_Purchase.php
r21182 r21185 275 275 $this->copyFromCustomer($sqlval, $objCustomer); 276 276 $sqlval['order_temp_id'] = $uniqId; 277 $sqlval['create_date'] = "now()";277 $sqlval['create_date'] = 'CURRENT_TIMESTAMP'; 278 278 $objQuery->insert("dtb_order_temp", $sqlval); 279 279 } else { … … 436 436 437 437 $dest['customer_id'] = $objCustomer->getValue('customer_id'); 438 $dest['update_date'] = ' Now()';438 $dest['update_date'] = 'CURRENT_TIMESTAMP'; 439 439 } 440 440 } … … 683 683 } 684 684 $arrValues['order_id'] = $order_id; 685 $arrValues['create_date'] = ' Now()';686 $arrValues['update_date'] = ' Now()';685 $arrValues['create_date'] = 'CURRENT_TIMESTAMP'; 686 $arrValues['update_date'] = 'CURRENT_TIMESTAMP'; 687 687 $objQuery->insert($table, $arrValues); 688 688 } … … 768 768 } 769 769 770 $orderParams['create_date'] = ' Now()';771 $orderParams['update_date'] = ' Now()';770 $orderParams['create_date'] = 'CURRENT_TIMESTAMP'; 771 $orderParams['update_date'] = 'CURRENT_TIMESTAMP'; 772 772 773 773 $this->registerOrder($orderParams['order_id'], $orderParams); … … 833 833 $this->sfUpdateOrderNameCol($order_id); 834 834 835 $arrValues['update_date'] = ' now()';835 $arrValues['update_date'] = 'CURRENT_TIMESTAMP'; 836 836 $objQuery->update($table, $arrValues, $where, array($order_id)); 837 837 } else { … … 849 849 SC_Utils_Ex::isBlank($arrValues['customer_id']) 850 850 ? 0 : $arrValues['customer_id']; 851 $arrValues['create_date'] = ' now()';852 $arrValues['update_date'] = ' now()';851 $arrValues['create_date'] = 'CURRENT_TIMESTAMP'; 852 $arrValues['update_date'] = 'CURRENT_TIMESTAMP'; 853 853 $objQuery->insert($table, $arrValues); 854 854 … … 1119 1119 if ($addCustomerPoint != 0) { 1120 1120 // ▼会員テーブルの更新 1121 $objQuery->update('dtb_customer', array('update_date' => ' Now()'),1121 $objQuery->update('dtb_customer', array('update_date' => 'CURRENT_TIMESTAMP'), 1122 1122 'customer_id = ?', array($arrOrderOld['customer_id']), 1123 1123 array('point' => 'point + ?'), array($addCustomerPoint)); … … 1150 1150 // 対応状況が発送済みに変更の場合、発送日を更新 1151 1151 if ($arrOrderOld['status'] != ORDER_DELIV && $newStatus == ORDER_DELIV) { 1152 $sqlval['commit_date'] = ' Now()';1152 $sqlval['commit_date'] = 'CURRENT_TIMESTAMP'; 1153 1153 } 1154 1154 // 対応状況が入金済みに変更の場合、入金日を更新 1155 1155 elseif ($arrOrderOld['status'] != ORDER_PRE_END && $newStatus == ORDER_PRE_END) { 1156 $sqlval['payment_date'] = ' Now()';1156 $sqlval['payment_date'] = 'CURRENT_TIMESTAMP'; 1157 1157 } 1158 1158 1159 1159 $sqlval['status'] = $newStatus; 1160 $sqlval['update_date'] = ' Now()';1160 $sqlval['update_date'] = 'CURRENT_TIMESTAMP'; 1161 1161 1162 1162 $dest = $objQuery->extractOnlyColsOf('dtb_order', $sqlval);
Note: See TracChangeset
for help on using the changeset viewer.