/**
* @author: jason
* @date: 2010-12-15下午01:51:35
* @todo: 获得专家列表
* @params:
*/
public function getExpertList($limit = 5)
{
$expert_list = array();
$expert_cate = Expert::model()->getCateList();
// 先判断是否存在缓存，从缓存读取数据
$model = new Expert();
$key = $model->getExpertListCacheKey();
$resource = Yii::app()->cache->get($key);
if ($resource === false) {
$connection = Yii::app()->db;
$sql = " SELECT * FROM {{main_expert}} where is_delete = '0' and status= '1' ORDER BY is_top desc,sort desc LIMIT {$limit} ";
$command = $connection->createCommand($sql);
$resource = $command->queryAll();
// 设置缓存
Yii::app()->cache->set($key, $resource);
}
if (!empty($resource)) {
foreach ($resource as $one) {
$id = $one['expert_id'];
$expert_list[$id] = $one;
$expert_list[$id]['cate'] = $expert_cate[$one['cate_id']];
$expert_list[$id]['expert_intro'] = cutString($one['expert_intro'], 26);
$model = new Show();
$blog_link = $model->createCommendUrl('', 'home', $one['uid']);
$expert_list[$id]['blog_link'] = empty($one['blog_link']) ? $blog_link : $one['blog_link'];
}
}
return $expert_list;
}