Changeset 17279

Timestamp:

2008/04/24 13:11:12 (16 years ago)

Author:

Yammy

Message:

http://svn.ec-cube.net/open_trac/ticket/285
受注検索の電話番号項目
修正

File:

• branches/comu-ver2/data/class/pages/admin/order/LC_Page_Admin_Order.php (modified) (1 diff)

branches/comu-ver2/data/class/pages/admin/order/LC_Page_Admin_Order.php

@@ -199 +199 @@
                             case 'search_order_tel':
                                 if(DB_TYPE == "pgsql"){
-                                    $where .= " AND (order_tel01||order_tel02||order_tel03) ILIKE ?";
+                                    $where .= " AND (order_tel01 || order_tel02 || order_tel03 LIKE ?)";
                                 }elseif(DB_TYPE == "mysql"){
-                                    $where .= " AND concat(order_tel01,order_tel02,order_tel03) ILIKE ?";
+                                    $where .= " AND concat(order_tel01,order_tel02,order_tel03) LIKE ?";
                                 }
                                 $nonmark_val = ereg_replace("[()-]+","",$val);
-                                $arrval[] = "$nonmark_val%";
+                                $arrval[] = "%$nonmark_val%";
                                 break;
                             case 'search_order_email':