- Timestamp:
- 2012/02/17 02:42:21 (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/helper/SC_Helper_Purchase.php
r21526 r21527 234 234 function getOrderTemp($uniqId) { 235 235 $objQuery =& SC_Query_Ex::getSingletonInstance(); 236 return $objQuery->getRow('*', 'dtb_order_temp', 'order_temp_id = ?', 237 array($uniqId)); 236 return $objQuery->getRow('*', 'dtb_order_temp', 'order_temp_id = ?', array($uniqId)); 238 237 } 239 238 … … 246 245 function getOrderTempByOrderId($order_id) { 247 246 $objQuery =& SC_Query_Ex::getSingletonInstance(); 248 return $objQuery->getRow('*', 'dtb_order_temp', 'order_id = ?', 249 array($order_id)); 247 return $objQuery->getRow('*', 'dtb_order_temp', 'order_id = ?', array($order_id)); 250 248 } 251 249 … … 284 282 $objQuery->insert('dtb_order_temp', $sqlval); 285 283 } else { 286 $objQuery->update('dtb_order_temp', $sqlval, 'order_temp_id = ?', 287 array($uniqId)); 284 $objQuery->update('dtb_order_temp', $sqlval, 'order_temp_id = ?', array($uniqId)); 288 285 } 289 286 } … … 418 415 */ 419 416 function copyFromCustomer(&$dest, &$objCustomer, $prefix = 'order', 420 $keys = array('name01', 'name02', 'kana01', 'kana02',421 'sex', 'zip01', 'zip02', 'pref',422 'addr01', 'addr02',423 'tel01', 'tel02', 'tel03', 'job',424 'birth', 'email')) {417 $keys = array('name01', 'name02', 'kana01', 'kana02', 418 'sex', 'zip01', 'zip02', 'pref', 'addr01', 'addr02', 419 'tel01', 'tel02', 'tel03', 'job', 'birth', 'email', 420 ) 421 ) { 425 422 if ($objCustomer->isLoginSuccess(true)) { 426 423 … … 462 459 */ 463 460 function copyFromOrder(&$dest, $src, 464 $prefix = 'shipping', $src_prefix = 'order', 465 $keys = array('name01', 'name02', 'kana01', 'kana02', 466 'sex', 'zip01', 'zip02', 'pref', 467 'addr01', 'addr02', 468 'tel01', 'tel02', 'tel03')) { 461 $prefix = 'shipping', $src_prefix = 'order', 462 $keys = array( 463 'name01', 'name02', 'kana01', 'kana02', 464 'sex', 'zip01', 'zip02', 'pref', 'addr01', 'addr02', 465 'tel01', 'tel02', 'tel03', 466 ) 467 ) { 469 468 if (!SC_Utils_Ex::isBlank($prefix)) { 470 469 $prefix = $prefix . '_'; … … 523 522 $arrPayment[] = $data; 524 523 } 525 }524 } 526 525 return $arrPayment; 527 526 } … … 941 940 } 942 941 $col .= <<< __EOS__ 943 944 CASE WHENEXISTS(942 CASE WHEN 943 EXISTS( 945 944 SELECT * FROM dtb_products 946 WHERE product_id = T3.product_id 947 AND del_flg = 0 948 AND status = 1) 949 THEN '1' ELSE '0' 950 END AS enable, 945 WHERE product_id = T3.product_id 946 AND del_flg = 0 947 AND status = 1 948 ) 949 THEN '1' 950 ELSE '0' 951 END AS enable, 951 952 __EOS__; 952 953 $col .= $dbFactory->getDownloadableDaysWhereSql('T1') . ' AS effective'; 953 954 $from = <<< __EOS__ 954 dtb_order T1955 JOIN dtb_order_detail T2956 ON T1.order_id = T2.order_id955 dtb_order T1 956 JOIN dtb_order_detail T2 957 ON T1.order_id = T2.order_id 957 958 LEFT JOIN dtb_products_class T3 958 ON T2.product_class_id = T3.product_class_id959 ON T2.product_class_id = T3.product_class_id 959 960 __EOS__; 960 961 $objQuery->setOrder('T2.order_detail_id');
Note: See TracChangeset
for help on using the changeset viewer.
