商品の AND 検索

[nanasess]

商品の AND 検索を可能にするパッチ

via.  http://xoops.ec-cube.net/modules/newbb/viewtopic.php?forum=5&post_id=4922&topic_id=1488

ndex: LC_Page_Products_List.php
===================================================================
--- LC_Page_Products_List.php
+++ LC_Page_Products_List.php
@@ -438,11 +438,18 @@
 
         // 商品名をwhere文に
         $name = ereg_replace(",", "", $name);
-        if ( strlen($name) > 0 ){
-            $where .= " AND ( name ILIKE ? OR comment3 ILIKE ?) ";
-            $ret = SC_Utils_Ex::sfManualEscape($name);
-            $arrval[] = "%$ret%";
-            $arrval[] = "%$ret%";
+        //全角スペースを半角スペースに変換
+        $name = str_replace('　', ' ', $name);
+        //スペースでキーワードを分割
+        $names = preg_split("/ +/", $name);
+        //分割したキーワードを一つずつwhere文に追加
+        foreach ($names as $val) {
+            if ( strlen($val) > 0 ){
+                $where .= " AND ( name ILIKE ? OR comment3 ILIKE ?) ";
+                $ret = SC_Utils_Ex::sfManualEscape($val);
+                $arrval[] = "%$ret%";
+                $arrval[] = "%$ret%";
+            }
         }
 
         if (empty($arrval)) {

[adachi]

r17506で反映しました。