Changeset 16824 for branches


Ignore:
Timestamp:
2007/11/28 14:11:55 (15 years ago)
Author:
satou
Message:

#190
修正しました。

Location:
branches/feature-module-update/data
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • branches/feature-module-update/data/Smarty/templates/default/admin/products/product_select.tpl

    r16821 r16824  
    3030<meta http-equiv="content-script-type" content="text/javascript" /> 
    3131<meta http-equiv="content-style-type" content="text/css" /> 
     32<link rel="stylesheet" href="<!--{$smarty.const.URL_ADMIN_CSS}-->common.css" type="text/css" media="all" /> 
    3233<script type="text/javascript" src="<!--{$TPL_DIR}-->js/css.js"></script> 
    3334<script type="text/javascript" src="<!--{$TPL_DIR}-->js/navi.js"></script> 
     
    132133        <!--{/section}--> 
    133134    </table> 
     135    <br /> 
     136    <br /> 
    134137    <!--{/if}--> 
    135138    <!--▲検索結果表示--> 
  • branches/feature-module-update/data/class/pages/admin/products/LC_Page_Admin_Products_ProductSelect.php

    r16741 r16824  
    8585                switch ($key) { 
    8686                case 'search_name': 
    87                     $where .= " AND name ILIKE ?"; 
     87                    $where .= " AND name LIKE ?"; 
    8888                    $arrval[] = "%$val%"; 
    8989                    break; 
    9090                case 'search_category_id': 
    91                     // 子カテゴリIDの取得 
    92                     $arrRet = $objDb->sfGetChildsID("dtb_category", "parent_category_id", "category_id", $val); 
    93                     $tmp_where = ""; 
    94                     foreach ($arrRet as $val) { 
    95                         if($tmp_where == "") { 
    96                             $tmp_where.= " AND ( category_id = ?"; 
    97                         } else { 
    98                             $tmp_where.= " OR category_id = ?"; 
    99                         } 
    100                         $arrval[] = $val; 
     91                    list($tmp_where, $tmp_arrval) = $objDb->sfGetCatWhere($val); 
     92                    if($tmp_where != "") { 
     93                        $where.= " AND product_id IN (SELECT product_id FROM dtb_product_categories WHERE " . $tmp_where . ")"; 
     94                        $arrval = array_merge((array)$arrval, (array)$tmp_arrval); 
    10195                    } 
    102                     $where.= $tmp_where . " )"; 
    10396                    break; 
    10497                case 'search_product_code': 
    105                     $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code ILIKE ? GROUP BY product_id)"; 
     98                    $where .= " AND product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? GROUP BY product_id)"; 
    10699                    $arrval[] = "$val%"; 
    107100                    break; 
Note: See TracChangeset for help on using the changeset viewer.