Ignore:
Timestamp:
2013/08/18 11:39:17 (11 years ago)
Author:
kimoto
Message:

#1931 管理画面の商品選択用ポップアップ画面の商品コード検索が重い

File:
1 edited

Legend:

Unmodified
Added
Removed

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

    r22926 r23084  
    126126                    break; 
    127127                case 'search_product_code': 
    128                     $where .= ' AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? GROUP BY product_id)'; 
     128                    $where .= ' AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ?)'; 
    129129                    $arrWhereVal[] = "$val%"; 
    130130                    break; 
Note: See TracChangeset for help on using the changeset viewer.