Changeset 21424


Ignore:
Timestamp:
2012/01/30 09:36:15 (9 years ago)
Author:
Seasoft
Message:

#1619 (受注管理>受注登録 商品コード検索で条件外の商品が抽出される)

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/version-2_12-dev/data/class/pages/admin/order/LC_Page_Admin_Order_ProductSelect.php

    r21420 r21424  
    222222                    break; 
    223223                case 'search_product_code': 
    224                     $where .=    " AND alldtl.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? GROUP BY product_id)"; 
     224                    $where .=    " AND alldtl.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? AND del_flg = 0 GROUP BY product_id)"; 
    225225                    $bind[] = '%'.$val.'%'; 
    226226                    break; 
Note: See TracChangeset for help on using the changeset viewer.