/**
* @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;
}
