Changeset 17506

Timestamp:

2008/08/07 18:21:53 (15 years ago)

Author:

adachi

Message:

#200 商品の AND 検索のパッチ適応(nanasess, pineray)

File:

• branches/version-2/data/class/pages/products/LC_Page_Products_List.php (modified) (1 diff)

branches/version-2/data/class/pages/products/LC_Page_Products_List.php

@@ -446 +446 @@
 
         // 商品名をwhere文に
-        $name = ereg_replace(",", "", $name);
-        if ( strlen($name) > 0 ){
-            $name = trim(mb_convert_kana($name, 's')); // 半角/全角スペースを削除
-            $where .= " AND ( name ILIKE ? OR comment3 ILIKE ?) ";
-            $ret = SC_Utils_Ex::sfManualEscape($name);
-            $arrval[] = "%$ret%";
-            $arrval[] = "%$ret%";
+        $name = ereg_replace(",", "", $name);// XXX
+        // 全角スペースを半角スペースに変換
+        $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%";
+            }
         }