- Timestamp:
- 2012/05/14 00:54:43 (14 years ago)
- Location:
- branches/version-2_12-dev/data/class/pages/admin/contents
- Files:
-
- 2 edited
-
LC_Page_Admin_Contents_Recommend.php (modified) (1 diff)
-
LC_Page_Admin_Contents_RecommendSearch.php (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_Recommend.php
r21809 r21829 78 78 switch ($this->getMode()) { 79 79 case 'down': //商品の並び替えをする。おすすめはデータベースの登録が昇順なので、Modeを逆にする。 80 $arrRet = $objQuery->select( "best_id", "dtb_best_products", "rank = ?", array($_POST["rank"])); //おすすめidの取得81 $best_id = $arrRet[0][ "best_id"];80 $arrRet = $objQuery->select('best_id', 'dtb_best_products', 'rank = ?', array($_POST['rank'])); //おすすめidの取得 81 $best_id = $arrRet[0]['best_id']; 82 82 $objDb->sfRankUp('dtb_best_products','best_id',$best_id); 83 83 $arrPost = $objFormParam->getHashArray(); 84 84 $arrItems = $this->getRecommendProducts(); 85 85 break; 86 86 87 87 case 'up': //商品の並び替えをする。おすすめのみデータベースの登録が昇順なので、Modeを逆にする。 88 $arrRet = $objQuery->select( "best_id", "dtb_best_products", "rank = ?", array($_POST["rank"])); //おすすめidの取得89 $best_id = $arrRet[0][ "best_id"];88 $arrRet = $objQuery->select('best_id', 'dtb_best_products', 'rank = ?', array($_POST['rank'])); //おすすめidの取得 89 $best_id = $arrRet[0]['best_id']; 90 90 $objDb->sfRankDown('dtb_best_products','best_id',$best_id); 91 91 $arrPost = $objFormParam->getHashArray(); -
branches/version-2_12-dev/data/class/pages/admin/contents/LC_Page_Admin_Contents_RecommendSearch.php
r21793 r21829 57 57 function process() { 58 58 $this->action(); 59 //SC_Utils::sfPrintR( $this );60 59 $this->sendResponse(); 61 60 } … … 125 124 $objFormParam->addParam('商品ID', 'search_name', LTEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK')); 126 125 $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 $objFormParam->addParam('商品コード', 'search_product_code', LTEXT_LEN, 'KVa', array('MAX_LENGTH_CHECK')); 128 127 $objFormParam->addParam('ページ番号', 'search_pageno', INT_LEN, 'n', array('MAX_LENGTH_CHECK','NUM_CHECK')); 129 128 } … … 168 167 break; 169 168 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)";169 $where .= ' AND alldtl.product_id IN (SELECT product_id FROM dtb_products_class WHERE product_code LIKE ? GROUP BY product_id)'; 171 170 $bind[] = '%'.$val.'%'; 172 171 break;
Note: See TracChangeset
for help on using the changeset viewer.
