Changeset 20017 for branches/version-2_5-dev/data
- Timestamp:
- 2011/01/20 16:52:48 (13 years ago)
- Location:
- branches/version-2_5-dev/data
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/Smarty/templates/admin/products/index.tpl
r19972 r20017 70 70 <tr> 71 71 <th>商品ID</th> 72 <td >72 <td colspan="3"> 73 73 <!--{if $arrErr.search_product_id}--> 74 74 <span class="attention"><!--{$arrErr.search_product_id}--></span> 75 75 <!--{/if}--> 76 76 <input type="text" name="search_product_id" value="<!--{$arrForm.search_product_id|h}-->" size="30" class="box30" style="<!--{$arrErr.search_product_id|sfGetErrorColor}-->"/> 77 </td>78 <th>規格名称</th>79 <td>80 <!--{if $arrErr.search_product_class_name}-->81 <span class="attention"><!--{$arrErr.search_product_class_name}--></span>82 <!--{/if}-->83 <input type="text" name="search_product_class_name" value="<!--{$arrForm.search_product_class_name|h}-->" size="30" class="box30"style="<!--{$arrErr.search_product_class_name|sfGetErrorColor}-->" />84 77 </td> 85 78 </tr> -
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.