Changeset 20016 for branches/version-2_5-dev/data

Timestamp:

2011/01/20 16:32:23 (13 years ago)

Author:

kotani

Message:

管理画面＞商品管理　「ステータス」を指定して検索するとDBエラーが発生する不具合改修

File:

• branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php (modified) (2 diffs)

branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php

@@ -30 +30 @@
  * @package Page
  * @author LOCKON CO.,LTD.
- * @version $Id:LC_Page_Admin_Products.php 15532 2007-08-31 14:39:46Z nanasess $
+ * @version $Id$
  */
 class LC_Page_Admin_Products extends LC_Page_Admin {
@@ -206 +206 @@
                             break;
                         case 'search_product_flag': //種別
-                            global $arrSTATUS;
-                            $search_product_flag = SC_Utils_Ex::sfSearchCheckBoxes($val);
-                            if($search_product_flag != "") {
-                                $where.= " AND product_flag LIKE ?";
-                                $view_where.= " AND product_flag LIKE ?";
-                                $arrval[] = $search_product_flag;
+                            if(count($val) > 0) {
+                                $where .= " AND product_id IN (SELECT product_id FROM dtb_product_status WHERE product_status_id IN (";
+                                $view_where .= " AND product_id IN (SELECT product_id FROM dtb_product_status WHERE product_status_id IN (";
+                                foreach($val as $param) {
+                                    $where .= "?,";
+                                    $view_where .= "?,";
+                                    $arrval[] = $param;
+                                }
+                                $where = preg_replace("/,$/", "))", $where);
+                                $view_where = preg_replace("/,$/", "))", $where);
                             }
                             break;