Changeset 14563

Timestamp:

2007/06/08 21:14:43 (17 years ago)

Author:

naka

Message:

 

File:

• branches/dev/data/conf/conf.php (modified) (3 diffs)

branches/dev/data/conf/conf.php

@@ -922 +922 @@
 
 // ViewÊÑ´¹ÍÑ(MySQLÂбþ)
+
 $arrView = array(
     "vw_cross_class" => '
@@ -933 +934 @@
         FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ) AS T1 LEFT JOIN dtb_products_class AS T2 
         ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2) ',
-
-    "vw_products_nonclass" => '
-        (SELECT 
-            T1.product_id,
-            T1.name,
-            T1.deliv_fee,
-            T1.sale_limit,
-            T1.sale_unlimited,
-            T1.category_id,
-            T1.rank,
-            T1.status,
-            T1.product_flag,
-            T1.point_rate,
-            T1.comment1,
-            T1.comment2,
-            T1.comment3,
-            T1.comment4,
-            T1.comment5,
-            T1.comment6,
-            T1.file1,
-            T1.file2,
-            T1.file3,
-            T1.file4,
-            T1.file5,
-            T1.file6,
-            T1.main_list_comment,
-            T1.main_list_image,
-            T1.main_comment,
-            T1.main_image,
-            T1.main_large_image,
-            T1.sub_title1,
-            T1.sub_comment1,
-            T1.sub_image1,
-            T1.sub_large_image1,
-            T1.sub_title2,
-            T1.sub_comment2,
-            T1.sub_image2,
-            T1.sub_large_image2,
-            T1.sub_title3,
-            T1.sub_comment3,
-            T1.sub_image3,
-            T1.sub_large_image3,
-            T1.sub_title4,
-            T1.sub_comment4,
-            T1.sub_image4,
-            T1.sub_large_image4,
-            T1.sub_title5,
-            T1.sub_comment5,
-            T1.sub_image5,
-            T1.sub_large_image5,
-            T1.sub_title6,
-            T1.sub_comment6,
-            T1.sub_image6,
-            T1.sub_large_image6,
-            T1.del_flg,
-            T1.creator_id,
-            T1.create_date,
-            T1.update_date,
-            T1.deliv_date_id,
-            T2.product_id_sub,
-            T2.product_code,
-            T2.price01,
-            T2.price02,
-            T2.stock,
-            T2.stock_unlimited,
-            T2.classcategory_id1,
-            T2.classcategory_id2
-        FROM (SELECT * FROM dtb_products &&noncls_where&&) AS T1 LEFT JOIN 
-        (SELECT
-        product_id AS product_id_sub,
-        product_code,
-        price01,
-        price02,
-        stock,
-        stock_unlimited,
-        classcategory_id1,
-        classcategory_id2
-        FROM dtb_products_class WHERE classcategory_id1 = 0 AND classcategory_id2 = 0) 
-        AS T2
-        ON T1.product_id = T2.product_id_sub) ',
 
     "vw_products_allclass" => '
@@ -1102 +1023 @@
         ON T1.category_id = T2.category_id) '
 );
+
+$vw_products_nonclass = "
+        (SELECT 
+            T1.product_id,
+            T1.name,
+            T1.deliv_fee,
+            T1.sale_limit,
+            T1.sale_unlimited,
+            T1.category_id,
+            T1.rank,
+            T1.status,
+            T1.product_flag,
+            T1.point_rate,
+            T1.comment1,
+            T1.comment2,
+            T1.comment3,
+            T1.comment4,
+            T1.comment5,
+            T1.comment6,
+            T1.file1,
+            T1.file2,
+            T1.file3,
+            T1.file4,
+            T1.file5,
+            T1.file6,
+            T1.main_list_comment,
+            T1.main_list_image,
+            T1.main_comment,
+            T1.main_image,
+            T1.main_large_image,";
+            
+for ($cnt = 1; $cnt <= PRODUCTSUB_MAX; $cnt++) {
+            $vw_products_nonclass.= "
+            T1.sub_title$cnt,
+            T1.sub_comment$cnt,
+            T1.sub_image$cnt,
+            T1.sub_large_image$cnt,";
+}
+
+$vw_products_nonclass.= "
+            T1.del_flg,
+            T1.creator_id,
+            T1.create_date,
+            T1.update_date,
+            T1.deliv_date_id,
+            T2.product_id_sub,
+            T2.product_code,
+            T2.price01,
+            T2.price02,
+            T2.stock,
+            T2.stock_unlimited,
+            T2.classcategory_id1,
+            T2.classcategory_id2
+        FROM (SELECT * FROM dtb_products &&noncls_where&&) AS T1 LEFT JOIN 
+        (SELECT
+        product_id AS product_id_sub,
+        product_code,
+        price01,
+        price02,
+        stock,
+        stock_unlimited,
+        classcategory_id1,
+        classcategory_id2
+        FROM dtb_products_class WHERE classcategory_id1 = 0 AND classcategory_id2 = 0) 
+        AS T2
+        ON T1.product_id = T2.product_id_sub) ";
+
+$arrView['vw_products_nonclass'] = $vw_products_nonclass;
 ?>