Changeset 21516 for branches/version-2_12-dev/data/class/db

Timestamp:

2012/02/15 20:52:51 (12 years ago)

Author:

Seasoft

Message:

#1625 (typo修正・ソース整形・ソースコメントの改善)

• 主に長い行の改善

File:

• branches/version-2_12-dev/data/class/db/dbfactory/SC_DB_DBFactory_PGSQL.php (modified) (1 diff)

branches/version-2_12-dev/data/class/db/dbfactory/SC_DB_DBFactory_PGSQL.php

@@ -123 +123 @@
         $downloadable_days = $baseinfo['downloadable_days'];
         if($downloadable_days ==null || $downloadable_days == '')$downloadable_days=0;
-        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(CURRENT_TIMESTAMP) <= DATE(' . $dtb_order_alias . ".payment_date + '". $downloadable_days ." days') THEN 1 ELSE 0 END)";
+        $sql = <<< __EOS__
+            (
+                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(CURRENT_TIMESTAMP) <= DATE($dtb_order_alias.payment_date + '$downloadable_days days') THEN 1
+                        ELSE 0
+                    END
+            )
+__EOS__;
+        return $sql;
     }