Changeset 21793 for branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php
- Timestamp:
- 2012/04/26 20:23:31 (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php
r21743 r21793 57 57 function process() { 58 58 $this->action(); 59 //SC_Utils::sfPrintR( $this ); 59 60 $this->sendResponse(); 60 61 } … … 124 125 $objFormParam->addParam('商品ID', 'search_name', LTEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK')); 125 126 $objFormParam->addParam('商品ID', 'search_category_id', INT_LEN, 'n', array('MAX_LENGTH_CHECK','NUM_CHECK')); 127 $objFormParam->addParam("商品コード", "search_product_code", LTEXT_LEN, 'KVa', array( "MAX_LENGTH_CHECK")); 126 128 $objFormParam->addParam('ページ番号', 'search_pageno', INT_LEN, 'n', array('MAX_LENGTH_CHECK','NUM_CHECK')); 127 129 } … … 165 167 } 166 168 break; 167 169 case 'search_product_code': 170 $where .= " AND alldtl.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? GROUP BY product_id)"; 171 $bind[] = '%'.$val.'%'; 172 break; 168 173 default: 169 174 break; … … 204 209 // 取得範囲の指定(開始行番号、行数のセット) 205 210 $objQuery->setLimitOffset($page_max, $startno); 206 207 211 // 検索結果の取得 208 212 return $objProduct->findProductIdsOrder($objQuery, $bind); … … 221 225 $order = 'update_date DESC, product_id DESC'; 222 226 $objQuery->setOrder($order); 223 224 227 return $objProduct->getListByProductIds($objQuery, $arrProductId); 225 228 }
Note: See TracChangeset
for help on using the changeset viewer.