Changeset 4712 for temp

Timestamp:

2006/09/14 10:41:54 (20 years ago)

Author:

kakinaka

Message:

blank

Location:

temp/trunk

Files:

• data/class/SC_DbConn.php (modified) (1 diff)
• data/conf/conf.php (modified) (5 diffs)
• data/lib/slib.php (modified) (1 diff)
• html/admin/home.php (modified) (1 diff)
• html/test/kakinaka/mysql.php (modified) (1 diff)

temp/trunk/data/class/SC_DbConn.php

@@ -51 +51 @@
     function getOne($n, $arr = ""){
         
-        sfprintr($n);
+//      sfprintr($n);
         
         // mysql¤Î¾ì¹ç¤Ë¤Ï¥Ó¥å¡¼É½¤òÊÑ´¹¤¹¤ë

temp/trunk/data/conf/conf.php

@@ -757 +757 @@
 $arrView = array(
     "vw_cross_class" => '
-        SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS classcategory_id1, T2.classcategory_id AS classcategory_id2, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2
-        FROM dtb_classcategory AS T1, dtb_classcategory AS T2;
+        (SELECT T1.class_id AS class_id1, T2.class_id AS class_id2, T1.classcategory_id AS classcategory_id1, T2.classcategory_id AS classcategory_id2, T1.name AS name1, T2.name AS name2, T1.rank AS rank1, T2.rank AS rank2
+        FROM dtb_classcategory AS T1, dtb_classcategory AS T2 ) vw_cross_class ',
         
-        CREATE VIEW vw_cross_products_class AS
-        SELECT T1.class_id1, T1.class_id2, T1.classcategory_id1, T1.classcategory_id2, T2.product_id,
+    "vw_cross_products_class" =>'
+        (SELECT T1.class_id1, T1.class_id2, T1.classcategory_id1, T1.classcategory_id2, T2.product_id,
         T1.name1, T1.name2, T2.product_code, T2.stock, T2.price01, T2.price02, T1.rank1, T1.rank2
         FROM vw_cross_class AS T1 LEFT JOIN dtb_products_class AS T2 
-        ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2;
+        ON T1.classcategory_id1 = T2.classcategory_id1 AND T1.classcategory_id2 = T2.classcategory_id2) vw_cross_products_class ',
         
-        CREATE VIEW vw_products_nonclass AS 
-        SELECT * FROM dtb_products AS T1 LEFT JOIN 
+    "vw_products_nonclass" => '
+        (SELECT * FROM dtb_products AS T1 LEFT JOIN 
         (SELECT
         product_id AS product_id_sub,
@@ -779 +779 @@
         FROM dtb_products_class WHERE classcategory_id1 = 0 AND classcategory_id2 = 0) 
         AS T2
-        ON T1.product_id = T2.product_id_sub',
-        
+        ON T1.product_id = T2.product_id_sub) vw_products_nonclass ',
+    
     "vw_products_allclass" => '
-        SELECT product_id,product_code_min,product_code_max,price01_min,price01_max,price02_min,price02_max,stock_min,stock_max,stock_unlimited_min,stock_unlimited_max,
+        (SELECT product_id,product_code_min,product_code_max,price01_min,price01_max,price02_min,price02_max,stock_min,stock_max,stock_unlimited_min,stock_unlimited_max,
         category_rank,category_id,del_flg,status,name,comment1,comment2,comment3,rank,
         main_list_comment,main_image,main_list_image,product_flag,deliv_date_id,sale_limit,point_rate,sale_unlimited,create_date,deliv_fee
@@ -800 +800 @@
         FROM dtb_products_class GROUP BY product_id) AS T2
         ON T1.product_id = T2.product_id_sub) AS T3 LEFT JOIN (SELECT rank AS category_rank, category_id AS sub_category_id FROM dtb_category) AS T4
-        ON T3.category_id = T4.sub_category_id',
+        ON T3.category_id = T4.sub_category_id) vw_products_allclass ',
 
     "vw_products_allclass_detail" => '
-        SELECT product_id,price01_min,price01_max,price02_min,price02_max,stock_min,stock_max,stock_unlimited_min,stock_unlimited_max,
+        (SELECT product_id,price01_min,price01_max,price02_min,price02_max,stock_min,stock_max,stock_unlimited_min,stock_unlimited_max,
         del_flg,status,name,comment1,comment2,comment3,deliv_fee,main_comment,main_image,main_large_image,
         sub_title1,sub_comment1,sub_image1,sub_large_image1,
@@ -824 +824 @@
         FROM dtb_products_class GROUP BY product_id) AS T2
         ON T1.product_id = T2.product_id_sub) AS T3 LEFT JOIN (SELECT rank AS category_rank, category_id AS sub_category_id FROM dtb_category) AS T4
-        ON T3.category_id = T4.sub_category_id',
+        ON T3.category_id = T4.sub_category_id) vw_products_allclass_detail ',
 
     "vw_product_class" => '
-        SELECT * FROM 
+        (SELECT * FROM 
         (SELECT T3.product_class_id, T3.product_id AS product_id_sub, classcategory_id1, classcategory_id2, 
         T3.rank AS rank1, T4.rank AS rank2, T3.class_id AS class_id1, T4.class_id AS class_id2,
@@ -835 +835 @@
         AS T3 LEFT JOIN dtb_classcategory AS T4
         ON T3.classcategory_id2 = T4.classcategory_id) AS T5 LEFT JOIN dtb_products AS T6
-        ON product_id_sub = T6.product_id',
+        ON product_id_sub = T6.product_id) vw_product_class ',
 
     "vw_category_count" => '
-        SELECT T1.category_id, T1.category_name, T1.parent_category_id, T1.level, T1.rank, T2.product_count
+        (SELECT T1.category_id, T1.category_name, T1.parent_category_id, T1.level, T1.rank, T2.product_count
         FROM dtb_category AS T1 LEFT JOIN dtb_category_total_count AS T2
-        ON T1.category_id = T2.category_id'
+        ON T1.category_id = T2.category_id) vw_category_count '
 );
 

temp/trunk/data/lib/slib.php

@@ -2340 +2340 @@
 }
 
-function sfGetFrom(){
+function sfChangeView($sql){
+    global $arrView;
+    
+    sfprintr($arrView);
     
 }

temp/trunk/html/admin/home.php

@@ -17 +17 @@
 // ǧ¾Ú²ÄÈݤÎȽÄê
 sfIsSuccess($objSess);
+
+sfprintr(sfChangeView("ss"));
 
 // ¸½ºß¤Î²ñ°÷¿ô

temp/trunk/html/test/kakinaka/mysql.php

@@ -17 +17 @@
 */
 
-$sql = "SELECT * FROMdtb_baseinfoWHERE";
-$sql = getMailAddress($sql);
-print_r($sql);
-
-print("end");
-
-// ʸ»úÎó¤ÎÃæ¤Ë¸ºß¤¹¤ë¥á¡¼¥ë¥¢¥É¥ì¥¹¤Î¤ß¤ò¼èÆÀ¤·¡¢ÇÛÎó¤È¤·¤ÆÊÖ¤¹
-function getMailAddress($str){
-    $arrMail = array();
-    preg_match_all("/FROM+([a-zA-Z0-9_\.\+\?-]+WHERE)/", $str, $arrMail);
-    return $arrMail[0];
-}
-
 ?>