- Timestamp:
- 2010/09/22 13:23:00 (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/db/dbfactory/SC_DB_DBFactory_PGSQL.php
r18793 r18819 124 124 function getDownloadableDaysWhereSql($dtb_order_alias) { 125 125 $baseinfo = SC_Helper_DB_Ex::sf_getBasisData(); 126 return "(SELECT CASE WHEN (SELECT d1.downloadable_days_unlimited FROM dtb_baseinfo d1) = 1 THEN 1 WHEN DATE(NOW()) <= DATE(" . $dtb_order_alias . ".commit_date + '". $baseinfo['downloadable_days'] ." days') THEN 1 ELSE 0 END)"; 126 //downloadable_daysにNULLが入っている場合(無期限ダウンロード可能時)もあるので、NULLの場合は0日に補正 127 $downloadable_days = $baseinfo['downloadable_days']; 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)"; 127 130 } 128 131 … … 199 202 /** 200 203 * 文字コード情報を取得する 201 * 204 * 202 205 * @return array 文字コード情報 203 206 */
Note: See TracChangeset
for help on using the changeset viewer.