Changeset 23034 for branches/version-2_13-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php

Timestamp:

2013/08/06 19:45:34 (11 years ago)

Author:

nanasess

Message:

#2315 (管理画面−> 商品管理-> 商品コードの検索で削除した規格が検索される)

• del_flg を条件に追加

File:

• branches/version-2_13-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php (modified) (1 diff)

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

@@ -292 +292 @@
             // 商品コード
             case 'search_product_code':
-                $where .= ' AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ?)';
+                $where .= ' AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? AND del_flg = 0)';
                 $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key));
                 break;