Changeset 8386 for temp

Timestamp:

2006/11/16 17:15:53 (20 years ago)

Author:

uehara

Message:

* empty log message *

File:

• temp/trunk/html/admin/contents/recommend.php (modified) (5 diffs)

temp/trunk/html/admin/contents/recommend.php

@@ -19 +19 @@
 
 $conn = new SC_DBConn();
+$objQuery = new SC_Query();
 $objPage = new LC_Page();
 $objView = new SC_AdminView();
@@ -55 +56 @@
         $objPage->arrForm['create_date'] = "NOW()";
         
-        $objQuery = new SC_Query();
         $objQuery->insert("dtb_best_products", $objPage->arrForm );
-//      $conn->autoExecute("dtb_best_products", $objPage->arrForm );
     }   
 
@@ -66 +65 @@
     $conn->query($sql, array($_POST['category_id'] ,$_POST['rank']));
     
-}
-
-// ¥«¥Æ¥´¥êID¼èÆÀ ̵¤¤¤È¤­¤Ï¥È¥Ã¥×¥Ú¡¼¥¸
-if ( sfCheckNumLength($_POST['category_id']) ){
-    $objPage->category_id = $_POST['category_id'];
-} else {
-    $objPage->category_id = 0;
-}
-
-// ´û¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤ëÆâÍƤò¼èÆÀ¤¹¤ë
-$sql = "SELECT B.name, B.main_list_image, A.* FROM dtb_best_products as A INNER JOIN dtb_products as B USING (product_id)
-         WHERE A.category_id = ? AND A.del_flg = 0 ORDER BY rank";
-$arrItems = $conn->getAll($sql, array($objPage->category_id));
-foreach( $arrItems as $data ){
-    $objPage->arrItems[$data['rank']] = $data;
 }
 
@@ -97 +81 @@
 }
 
+// ¥ª¥¹¥¹¥á¾¦ÉʼèÆÀ
+lfGetRecommentdProduct();
+
 //³Æ¥Ú¡¼¥¸¶¦ÄÌ
 $objPage->cnt_question = 6;
 $objPage->arrActive = $arrActive;
 $objPage->arrQuestion = $arrQuestion;
-
-// ¥«¥Æ¥´¥ê¼èÆÀ
-$objPage->arrCatList = sfGetCategoryList("level = 1");
 
 //----¡¡¥Ú¡¼¥¸É½¼¨
@@ -140 +124 @@
 }
 
+/* ¾¦ÉʤΰìÍ÷¤ò¼èÆÀ */
+function lfGetRecommentdProduct() {
+    
+    global $objQuery;
+    global $objPage;
+    
+    // ´û¤ËÅÐÏ¿¤µ¤ì¤Æ¤¤¤ëÆâÍƤò¼èÆÀ¤¹¤ë
+    $sql = "SELECT B.name, B.main_list_image, A.* FROM dtb_best_products as A INNER JOIN dtb_products as B USING (product_id)
+             WHERE A.del_flg = 0 ORDER BY rank";
+    $arrItems = $objQuery->getAll($sql, array($objPage->category_id));
+    foreach( $arrItems as $data ){
+        $objPage->arrItems[$data['rank']] = $data;
+    }
+}
 ?>