Changeset 22595
- Timestamp:
- 2013/03/01 22:21:08 (11 years ago)
- Location:
- branches/version-2_12-dev/data/class
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_12-dev/data/class/helper/SC_Helper_Category.php
r22594 r22595 41 41 { 42 42 $this->count_check = $count_check; 43 } 44 45 /** 46 * カテゴリーの情報を取得. 47 * 48 * @param integer $category_id カテゴリーID 49 * @return array 50 */ 51 public function get($category_id) 52 { 53 $objQuery =& SC_Query_Ex::getSingletonInstance(); 54 $col = '*'; 55 $from = 'dtb_category left join dtb_category_total_count ON dtb_category.category_id = dtb_category_total_count.category_id'; 56 $where = 'dtb_category.category_id = ? AND del_flg = 0'; 57 // 登録商品数のチェック 58 if ($this->count_check) { 59 $where .= ' AND product_count > 0'; 60 } 61 $arrRet = $objQuery->getRow($col, $from, $where, array($category_id)); 62 return $arrRet; 43 63 } 44 64 … … 88 108 return $arrTree; 89 109 } 110 111 /** 112 * 親カテゴリーIDの配列を取得. 113 * 114 * @param integer $category_id 起点のカテゴリーID 115 * @return array 116 */ 117 public function getTreeTrail($category_id) 118 { 119 $arrCategory = $this->getList(); 120 $arrTrailID = SC_Utils_Ex::getTreeTrail($category_id, 'category_id', 'parent_category_id', $arrCategory); 121 return $arrTrailID; 122 } 90 123 } -
branches/version-2_12-dev/data/class/helper/SC_Helper_DB.php
r22590 r22595 461 461 462 462 /** 463 * 指定したカテゴリIDのカテゴリを取得する.464 *465 * @param integer $category_id カテゴリID466 * @return array 指定したカテゴリIDのカテゴリ467 */468 function sfGetCat($category_id)469 {470 $objQuery =& SC_Query_Ex::getSingletonInstance();471 472 // カテゴリを取得する473 $arrVal = array($category_id);474 $res = $objQuery->select('category_id AS id, category_name AS name', 'dtb_category', 'category_id = ?', $arrVal);475 476 return $res[0];477 }478 479 /**480 463 * 指定したカテゴリIDの大カテゴリを取得する. 481 464 * -
branches/version-2_12-dev/data/class/pages/admin/products/LC_Page_Admin_Products_Category.php
r22567 r22595 240 240 $category_id = $objFormParam->getValue('category_id'); 241 241 242 $objQuery =& SC_Query_Ex::getSingletonInstance(); 243 244 // 編集対象のカテゴリ名をDBより取得する 245 $where = 'category_id = ?'; 246 $arrRes = $objQuery->getRow('*', 'dtb_category', $where, array($category_id)); 242 $objCategory = new SC_Helper_Category_Ex(); 243 $arrRes = $objCategory->get($category_id); 247 244 248 245 $objFormParam->setParam($arrRes); -
branches/version-2_12-dev/data/class/pages/frontparts/bloc/LC_Page_FrontParts_Bloc_Category.php
r22590 r22595 135 135 $arrCategory = $objCategory->getList(); 136 136 foreach ($arrParentCategoryId as $category_id) { 137 $arrParentID = SC_Utils_Ex::getTreeTrail($category_id, 'category_id', 'parent_category_id', $arrCategory);137 $arrParentID = $objCategory->getTreeTrail($category_id); 138 138 $arrBrothersID = SC_Utils_Ex::sfGetBrothersArray( 139 139 $arrCategory, -
branches/version-2_12-dev/data/class/pages/products/LC_Page_Products_List.php
r22578 r22595 294 294 return '全商品'; 295 295 } else { 296 $arrCat = SC_Helper_DB_Ex::sfGetCat($category_id); 297 return $arrCat['name']; 296 $objCategory = new SC_Helper_Category_Ex(); 297 $arrCat = $objCategory->get($category_id); 298 return $arrCat['category_name']; 298 299 } 299 300 }
Note: See TracChangeset
for help on using the changeset viewer.