Changeset 10225 for temp/trunk/data/conf/conf.php

Timestamp:

2006/12/05 21:27:25 (20 years ago)

Author:

kaki

Message:

 

File:

• temp/trunk/data/conf/conf.php (modified) (2 diffs)

temp/trunk/data/conf/conf.php

@@ -761 +761 @@
 );
 
+
+// View¤ÎWhere¶çÃÖ´¹ÍÑ
+$arrViewWhere = array(
+    "&&crscls_where&&" => "",
+    "&&crsprdcls_where&&" =>"",
+    "&&noncls_where&&" => "",
+    "&&allcls_where&&" => "",
+    "&&allclsdtl_where&&" => "",
+    "&&prdcls_where&&" => "",
+    "&&catcnt_where&&" => ""
+);
+
 // ViewÊÑ´¹ÍÑ(MySQLÂбþ)
 $arrView = array(
@@ -775 +787 @@
 
     "vw_products_nonclass" => '
-        (SELECT * FROM dtb_products AS T1 LEFT JOIN 
+        (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,