20,359
社区成员
发帖
与我相关
我的任务
分享
/**
* 展示评论列表
*/
public function comment(){
//重置缓存
set_msg(session('uid'), 1, true);
//取出我发的微博的id
$my_uid = session('uid');
$wids = M('weibo')->where(array('uid'=>$my_uid))->field('id')->select();
//取出我参与评论的微博的id
$comment_db = M('comment');
$other_wids = $comment_db->where(array('uid'=>$my_uid))->field('wid AS id')->select();
//合并所有需要取出的微博id
$wids = array_merge_recursive($wids, $other_wids);
foreach($wids as $k=>$v){
$wids[$k] = $v['id'];
}
$wids = array_unique($wids); //合并后去重复
//根据wid取出comment表的id,uid,content,time等信息,再把comment表的id取出
$uids = $comment_db->where(array('wid'=>array('IN', $wids)))->select();
foreach($uids as $k=>$v){
$cids[$k] = $v['id'];
}
//根据comment表的id取出评论
$db = D('CommentView');
$where = array('comment.id'=>array('IN', $cids));
//分页
$count = $db->where($where)->count();
import('ORG.Util.Page');
$page = new Page($count, 10);
$limit = $page->firstRow . ',' . $page->listRows;
$comment = $db->where($where)->order('time DESC')->limit($limit)->select();
//分配变量到模板
$assign = array('count'=>$count, 'comment'=>$comment, 'page'=>$page->show());
$this->assign($assign);
$this->display();
}