Ignore:
Timestamp:
2010/09/27 11:49:29 (14 years ago)
Author:
eccuore
Message:

#792(ダウンロード販売機能) vw_download_class削除、product_class_id対応(規格構成変更と並行作業中なので、作業途中の部分有)

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_5-dev/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php

    r18820 r18824  
    142142     * @return string 検索条件の SQL 
    143143     */ 
    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))))"; 
    146146    } 
    147147 
     
    415415                ) 
    416416__EOS__; 
    417  
    418             $sql['vw_download_class'] = <<< __EOS__ 
    419                 (SELECT 
    420                     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 status 
    429                 FROM 
    430                     dtb_products_class pc, 
    431                     dtb_order_detail od, 
    432                     dtb_order o 
    433                 WHERE 
    434                     pc.product_id = od.product_id AND 
    435                     pc.classcategory_id1 = od.classcategory_id1 AND 
    436                     pc.classcategory_id2 = od.classcategory_id2 AND 
    437                     od.order_id = o.order_id 
    438                 ) 
    439 __EOS__; 
    440  
    441417        } 
    442418 
Note: See TracChangeset for help on using the changeset viewer.