- Timestamp:
- 2011/01/20 16:52:48 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/class/pages/admin/products/LC_Page_Admin_Products.php
r20016 r20017 163 163 $arrval[] = $val; 164 164 break; 165 case 'search_product_class_name': //規格名称166 $where_in = " (SELECT classcategory_id FROM dtb_classcategory WHERE class_id IN (SELECT class_id FROM dtb_class WHERE name LIKE ?)) ";167 $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE classcategory_id1 IN " . $where_in;168 $where .= " OR classcategory_id2 IN" . $where_in . ")";169 $view_where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE classcategory_id1 IN " . $where_in;170 $view_where .= " OR classcategory_id2 IN" . $where_in . ")";171 $arrval[] = "%$val%";172 $arrval[] = "%$val%";173 $view_where = $where;174 break;175 165 case 'search_name': // 商品名 176 166 $where .= " AND name ILIKE ?";
Note: See TracChangeset
for help on using the changeset viewer.