/** * @author: jason * @date: 2010-12-20上午09:48:22 * @todo: 获得热门日志 * @params:cate_id=9为日志类型 */ public function getBlogList($limit = 4) { $cate_id = 9; $model = new Show(); $model->cate_id = $cate_id; $cache_key = $model->getShowListCacheKey(); $resource = Yii::app()->cache->get($cache_key); if (!$resource === false) { return $resource; } $blog_list = $relate_arr = array(); $rows = $this->getShowList($limit, $cate_id); if (!empty($rows)) { foreach ($rows as $value) { $show_id = $value['id']; // 先判断id值不为空 if (!empty($show_id)) { $relate_arr[] = $show_id; } $show_arr[$show_id]['icon'] = $value['icon']; $show_arr[$show_id]['target_type'] = $value['target_type']; } } if (!empty($relate_arr)) { $imp_ids = implode(",", $relate_arr); $connection = Yii::app()->db_uchome; $sql = " SELECT a.*,b.message FROM uchome_blog a\n\t\t\t\tLEFT JOIN uchome_blogfield b on a.blogid = b.blogid\n\t\t\t\twhere a.blogid in ({$imp_ids}) ORDER BY a.blogid LIMIT {$limit} "; $command = $connection->createCommand($sql); $rows = $command->queryAll(); if (!empty($rows)) { foreach ($rows as $value) { //if(empty($value['icon'])) $value['icon'] = 'image/nologo.jpg'; $value['icon'] = $show_arr[$value['blogid']]['icon']; $value['target_type'] = $show_arr[$value['blogid']]['target_type']; $value['name'] = YiicmsUchome::getUchomeRealname($value['uid']); $blog_list[$value['blogid']] = $value; } } foreach ($relate_arr as $key => $id) { $source[$key] = $blog_list[$id]; } Yii::app()->cache->set($cache_key, $source); } //array_multisort($relate_arr, SORT_ASC, $source); return $source; }