Changeset 18777 for branches/version-2_5-dev/data/class/db

Timestamp:

2010/08/06 14:52:59 (16 years ago)

Author:

eccuore

Message:

#792(ダウンロード販売機能) 機能追加

File:

• branches/version-2_5-dev/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php (modified) (6 diffs)

branches/version-2_5-dev/data/class/db/dbfactory/SC_DB_DBFactory_MYSQL.php

@@ -70 +70 @@
         return $sql;
     }
-    
+
     /**
      * 文字コード情報を取得する
@@ -81 +81 @@
         return $arrRet;
     }
-    
+
     /**
      * テーブルの存在チェックを行う SQL 文を返す.
@@ -180 +180 @@
      */
     function sfChangeView($sql){
-        
+
         $arrViewTmp = $this->viewToSubQuery();
-        
+
             // viewのwhereを変換
         foreach($arrViewTmp as $key => $val){
             $arrViewTmp[$key] = strtr($arrViewTmp[$key], $this->getWhereConverter());
         }
-            
+
             // viewを変換
         $changesql = strtr($sql, $arrViewTmp);
-        
+
         return $changesql;
     }
@@ -229 +229 @@
         return $changesql;
     }
-    
+
     /**
      * WHERE 句置換用の配列を返す.
@@ -385 +385 @@
                         dtb_products.update_date,
                         dtb_products.deliv_date_id,
+                        dtb_products.down,
+                        dtb_products.down_filename,
+                        dtb_products.down_realfilename,
                         T4.product_code_min,
                         T4.product_code_max,
@@ -467 +470 @@
                 ON T1.category_id = T2.category_id)
 __EOS__;
+
+            $sql['vw_download_class'] = <<< __EOS__
+                (SELECT p.product_id AS product_id, p.down_realfilename AS down_realfilename , p.down_filename AS down_filename, od.order_id AS order_id, o.customer_id AS customer_id, o.commit_date AS commit_date, o.status AS status FROM
+                    dtb_products p, dtb_order_detail od, dtb_order o
+                WHERE p.product_id = od.product_id AND od.order_id = o.order_id)
+__EOS__;
         }