Changeset 8390 for temp

Timestamp:

2006/11/16 17:38:49 (20 years ago)

Author:

uehara

Message:

* empty log message *

File:

• temp/trunk/html/admin/contents/recommend.php (modified) (6 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();
@@ -48 +47 @@
     if ( ! $objPage->arrErr[$objPage->arrForm['rank']]) {
         // ¸Å¤¤¤Î¤ò¾Ã¤¹
-        $sql = "DELETE FROM dtb_best_products WHERE product_id = ?";
-        $conn->query($sql, array($objPage->arrForm['product_id']));
+        $sql = "DELETE FROM dtb_best_products WHERE category_id = ? AND rank = ?";
+        $conn->query($sql, array($objPage->arrForm['category_id'] ,$objPage->arrForm['rank']));
     
         // £Ä£ÂÅÐÏ¿
@@ -56 +55 @@
         $objPage->arrForm['create_date'] = "NOW()";
         
+        $objQuery = new SC_Query();
         $objQuery->insert("dtb_best_products", $objPage->arrForm );
+//      $conn->autoExecute("dtb_best_products", $objPage->arrForm );
     }   
 
@@ -62 +63 @@
 // ºï½ü»þ
 
-    $sql = "DELETE FROM dtb_best_products WHERE product_id = ?";
-    $conn->query($sql, array($_POST['product_id']));
+    $sql = "DELETE FROM dtb_best_products WHERE category_id = ? AND rank = ?";
+    $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.del_flg = 0 ORDER BY rank";
+$arrItems = $conn->getAll($sql, array($objPage->category_id));
+foreach( $arrItems as $data ){
+    $objPage->arrItems[$data['rank']] = $data;
 }
 
@@ -81 +97 @@
 }
 
-// ¥ª¥¹¥¹¥á¾¦ÉʼèÆÀ
-lfGetRecommentdProduct();
-
 //³Æ¥Ú¡¼¥¸¶¦ÄÌ
 $objPage->cnt_question = 6;
 $objPage->arrActive = $arrActive;
 $objPage->arrQuestion = $arrQuestion;
+
+// ¥«¥Æ¥´¥ê¼èÆÀ
+$objPage->arrCatList = sfGetCategoryList("level = 1");
 
 //----¡¡¥Ú¡¼¥¸É½¼¨
@@ -124 +140 @@
 }
 
-/* ¾¦ÉʤΰìÍ÷¤ò¼èÆÀ */
-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);
-    foreach( $arrItems as $data ){
-        $objPage->arrItems[$data['rank']] = $data;
-    }
-}
 ?>