Changeset 18824 for branches/version-2_5-dev/data/class/pages/mypage/LC_Page_Mypage_DownLoad.php

Timestamp:

2010/09/27 11:49:29 (14 years ago)

Author:

eccuore

Message:

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

File:

• branches/version-2_5-dev/data/class/pages/mypage/LC_Page_Mypage_DownLoad.php (modified) (4 diffs)

branches/version-2_5-dev/data/class/pages/mypage/LC_Page_Mypage_DownLoad.php

@@ -58 +58 @@
         $order_id = $_GET['order_id'];
         $product_id = $_GET['product_id'];
-        $classcategory_id1 = $_GET['classcategory_id1'];
-        $classcategory_id2 = $_GET['classcategory_id2'];
+        $product_class_id = $_GET['product_class_id'];
 
         // ID の数値チェック
@@ -66 +65 @@
             || !is_numeric($order_id)
             || !is_numeric($product_id)
-            || !is_numeric($classcategory_id1)
-            || !is_numeric($classcategory_id2)) {
+            || !is_numeric($product_class_id)) {
             SC_Utils_Ex::sfDispSiteError("");
         }
@@ -79 +77 @@
             //DBから商品情報の読込
 
-            $arrForm = $this->lfGetRealFileName($customer_id, $order_id, $product_id, $classcategory_id1, $classcategory_id2);
+            $arrForm = $this->lfGetRealFileName($customer_id, $order_id, $product_id, $product_class_id);
 
             //ステータスが支払済み以上である事
@@ -125 +123 @@
      * @param integer $order_id 受注ID
      * @param integer $product_id 商品ID
+     * @param integer $product_class_id 商品規格ID
      * @return array 商品情報の配列
      */
-    function lfGetRealFileName($customer_id, $order_id, $product_id, $classcategory_id1, $classcategory_id2) {
+    function lfGetRealFileName($customer_id, $order_id, $product_id, $product_class_id) {
         $objQuery = new SC_Query();
-        $col = "*";
-        $table = "vw_download_class AS T1";
+        $col = <<< __EOS__
+            pc.product_id AS product_id,
+            pc.product_class_id AS product_class_id,
+            pc.down_realfilename AS down_realfilename,
+            pc.down_filename AS down_filename,
+            o.order_id AS order_id,
+            o.customer_id AS customer_id,
+            o.payment_date AS payment_date,
+            o.status AS status
+__EOS__;
+
+        $table = <<< __EOS__
+            dtb_products_class pc,
+            dtb_order_detail od,
+            dtb_order o
+__EOS__;
+
         $dbFactory = SC_DB_DBFactory_Ex::getInstance();
-        $where = "T1.customer_id = ? AND T1.order_id = ? AND T1.product_id = ? AND T1.classcategory_id1 = ? AND T1.classcategory_id2 = ?";
-        $where .= " AND " . $dbFactory->getDownloadableDaysWhereSql("T1");
+        $where = "o.customer_id = ? AND o.order_id = ? AND pc.product_id = ? AND pc.product_class_id = ?";
+        $where .= " AND " . $dbFactory->getDownloadableDaysWhereSql();
         $where .= " = 1";
         $arrRet = $objQuery->select($col, $table, $where,
-                                    array($customer_id, $order_id, $product_id, $classcategory_id1, $classcategory_id2));
+                                    array($customer_id, $order_id, $product_id, $product_class_id));
         return $arrRet[0];
     }