Changeset 23034


Ignore:
Timestamp:
2013/08/06 19:45:34 (7 years ago)
Author:
nanasess
Message:

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

  • del_flg を条件に追加
File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_13-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php

    r22926 r23034  
    292292            // 商品コード 
    293293            case 'search_product_code': 
    294                 $where .= ' AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ?)'; 
     294                $where .= ' AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? AND del_flg = 0)'; 
    295295                $arrValues[] = sprintf('%%%s%%', $objFormParam->getValue($key)); 
    296296                break; 
Note: See TracChangeset for help on using the changeset viewer.