- Timestamp:
- 2010/09/27 11:49:29 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php
r18820 r18824 142 142 * @return string 検索条件の SQL 143 143 */ 144 function getDownloadableDaysWhereSql( $dtb_order_alias) {145 return "(SELECT IF((SELECT d1.downloadable_days_unlimited FROM dtb_baseinfo d1)=1, 1, DATE(NOW()) <= DATE(DATE_ADD( " . $dtb_order_alias . ".commit_date, INTERVAL (SELECT downloadable_days FROM dtb_baseinfo) DAY))))";144 function getDownloadableDaysWhereSql() { 145 return "(SELECT IF((SELECT d1.downloadable_days_unlimited FROM dtb_baseinfo d1)=1, 1, DATE(NOW()) <= DATE(DATE_ADD(o.payment_date, INTERVAL (SELECT downloadable_days FROM dtb_baseinfo) DAY))))"; 146 146 } 147 147 … … 415 415 ) 416 416 __EOS__; 417 418 $sql['vw_download_class'] = <<< __EOS__419 (SELECT420 pc.product_id AS product_id,421 pc.classcategory_id1 AS classcategory_id1,422 pc.classcategory_id2 AS classcategory_id2,423 pc.down_realfilename AS down_realfilename ,424 pc.down_filename AS down_filename,425 o.order_id AS order_id,426 o.customer_id AS customer_id,427 o.payment_date AS payment_date,428 o.status AS status429 FROM430 dtb_products_class pc,431 dtb_order_detail od,432 dtb_order o433 WHERE434 pc.product_id = od.product_id AND435 pc.classcategory_id1 = od.classcategory_id1 AND436 pc.classcategory_id2 = od.classcategory_id2 AND437 od.order_id = o.order_id438 )439 __EOS__;440 441 417 } 442 418
Note: See TracChangeset
for help on using the changeset viewer.