- Timestamp:
- 2011/09/25 13:15:51 (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_11-dev/data/class/pages/mypage/LC_Page_Mypage_Favorite.php
r21255 r21256 121 121 122 122 $objQuery->setOrder('create_date DESC'); 123 $arrProduct _id = $objQuery->getCol('product_id', 'dtb_customer_favorite_products', 'customer_id = ?', array($customer_id));123 $arrProductId = $objQuery->getCol('product_id', 'dtb_customer_favorite_products', 'customer_id = ?', array($customer_id)); 124 124 125 125 $objQuery =& SC_Query_Ex::getSingletonInstance(); 126 $objQuery->setWhere($this->lfMakeWhere('alldtl.', $arrProduct _id));126 $objQuery->setWhere($this->lfMakeWhere('alldtl.', $arrProductId)); 127 127 $linemax = $objProduct->findProductCount($objQuery); 128 128 … … 137 137 //$objQuery->setLimitOffset(SEARCH_PMAX, $startno); 138 138 // 取得範囲の指定(開始行番号、行数のセット) 139 $arrProduct _id = array_slice($arrProduct_id, $startno, SEARCH_PMAX);139 $arrProductId = array_slice($arrProductId, $startno, SEARCH_PMAX); 140 140 141 $where = $this->lfMakeWhere('', $arrProduct _id);141 $where = $this->lfMakeWhere('', $arrProductId); 142 142 $where .= ' AND del_flg = 0'; 143 $objQuery->setWhere($where );144 $arrProducts = $objProduct->lists($objQuery , $arrProduct_id);143 $objQuery->setWhere($where, $arrProductId); 144 $arrProducts = $objProduct->lists($objQuery); 145 145 146 146 //取得している並び順で並び替え … … 150 150 } 151 151 $arrProductsList = array(); 152 foreach($arrProduct _id as $product_id) {152 foreach($arrProductId as $product_id) { 153 153 $arrProductsList[] = $arrProducts2[$product_id]; 154 154 } … … 158 158 159 159 /* 仕方がない処理。。 */ 160 function lfMakeWhere ($tablename, $arrProduct _id) {160 function lfMakeWhere ($tablename, $arrProductId) { 161 161 162 162 // 取得した表示すべきIDだけを指定して情報を取得。 163 163 $where = ""; 164 if (is_array($arrProduct _id) && !empty($arrProduct_id)) {165 $where = $tablename . 'product_id IN (' . implode(',', $arrProduct _id) . ')';164 if (is_array($arrProductId) && !empty($arrProductId)) { 165 $where = $tablename . 'product_id IN (' . implode(',', $arrProductId) . ')'; 166 166 } else { 167 167 // 一致させない
Note: See TracChangeset
for help on using the changeset viewer.