- 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_PGSQL.php
r18820 r18824 122 122 * @return string 検索条件の SQL 123 123 */ 124 function getDownloadableDaysWhereSql( $dtb_order_alias) {124 function getDownloadableDaysWhereSql() { 125 125 $baseinfo = SC_Helper_DB_Ex::sf_getBasisData(); 126 126 //downloadable_daysにNULLが入っている場合(無期限ダウンロード可能時)もあるので、NULLの場合は0日に補正 127 127 $downloadable_days = $baseinfo['downloadable_days']; 128 128 if($downloadable_days ==null || $downloadable_days == "")$downloadable_days=0; 129 return "(SELECT CASE WHEN (SELECT d1.downloadable_days_unlimited FROM dtb_baseinfo d1) = 1 AND " . $dtb_order_alias . ".payment_date IS NOT NULL THEN 1 WHEN DATE(NOW()) <= DATE(" . $dtb_order_alias . ".payment_date + '". $downloadable_days ." days') THEN 1 ELSE 0 END)";129 return "(SELECT CASE WHEN (SELECT d1.downloadable_days_unlimited FROM dtb_baseinfo d1) = 1 AND o.payment_date IS NOT NULL THEN 1 WHEN DATE(NOW()) <= DATE(o.payment_date + '". $downloadable_days ." days') THEN 1 ELSE 0 END)"; 130 130 } 131 131
Note: See TracChangeset
for help on using the changeset viewer.