Changeset 17263 for branches/comu-ver2/data/class/pages/products/LC_Page_Products_List.php

Timestamp:

2008/04/16 20:13:17 (16 years ago)

Author:

Yammy

Message:

メーカー検索機能
http://svn.ec-cube.net/open_trac/ticket/273
実装

File:

• branches/comu-ver2/data/class/pages/products/LC_Page_Products_List.php (modified) (5 diffs)

branches/comu-ver2/data/class/pages/products/LC_Page_Products_List.php

@@ -125 +125 @@
 
             // 商品一覧の表示処理
-            $this->lfDispProductsList($arrCategory_id[0], $_GET['name'], $this->disp_number, $_POST['orderby']);
+            $this->lfDispProductsList($arrCategory_id[0], $_GET['name'], $_GET['maker_id'], $this->disp_number, $_POST['orderby']);
 
             // 検索条件を画面に表示
@@ -134 +134 @@
                 $arrCat = $conn->getOne("SELECT category_name FROM dtb_category WHERE category_id = ?", $arrCategory_id);
                 $arrSearch['category'] = $arrCat;
+            }
+
+            // メーカー検索条件
+            if (strlen($_GET['maker_id']) == 0) {
+                $arrSearch['maker'] = "指定なし";
+            }else{
+                $arrSearch['maker'] = $name = $conn->getOne("SELECT name FROM dtb_maker WHERE maker_id = ?", $_GET['maker_id']);
             }
 
@@ -269 +276 @@
 
             // 商品一覧の表示処理
-            $this->lfDispProductsList($arrCategory_id[0], $_GET['name'], $this->disp_number, $_REQUEST['orderby']);
+            $this->lfDispProductsList($arrCategory_id[0], $_GET['name'], $_GET['maker_id'], $this->disp_number, $_REQUEST['orderby']);
 
             // 検索条件を画面に表示
@@ -371 +378 @@
 
     /* 商品一覧の表示 */
-    function lfDispProductsList($category_id, $name, $disp_num, $orderby) {
+    function lfDispProductsList($category_id, $name, $maker_id, $disp_num, $orderby) {
 
         $objQuery = new SC_Query();
@@ -446 +453 @@
         }
 
+        // メーカーらのWHERE文字列取得
+        if ( $maker_id ) {
+            $where .= " AND maker_id = ? ";
+            $arrval[] = $maker_id;
+        }
+
         if (empty($arrval)) {
             $arrval = array();