示例#1
0
 public function loadRelatedData()
 {
     if (IS_POST) {
         $items = $this->todo_model->select();
         $items = DBUtil::loadRelatedData($items, 'user_id', 'user', 'id', array('userName' => 'user_name'));
         //$items = DBUtil::loadRelatedData($items,'user_id','user','id',array('userName'=>'user_name'));
         print_r($items);
     }
 }
示例#2
0
 public function get_pieces()
 {
     $user_id = I('post.user_id') ? I('post.user_id') : $this->user_id;
     $page = I('post.page');
     $page = $page ? $page : 0;
     //$page = $page?$page-1:0;
     $visible = $user_id == $this->user_id ? '' : ' AND p.visible=1';
     $piece_model = D('Piece');
     /*$sql = "select count(c.comment_id) as comments_num,u.userName,u.avatar,p.piece_id,p.user_id,p.date,p.tag,p.content from hs_piece as p 
       join hs_user as u on p.user_id=u.id left join hs_piece_comment as c on p.piece_id=c.piece_id where p.user_id=".$user_id.$visible." group by p.piece_id order by p.date desc limit ".
       $page*$this->piece_nums_per_page.",".$this->piece_nums_per_page;
       $pieces = $piece_model->query($sql);
       $pieces = $piece_model->alias('p')->where('p.user_id='.$user_id.$visible)
       ->field('u.id,u.userName,u.avatar,p.piece_id,p.date,p.tag,p.content')
       ->join('hs_user as u on u.id=p.user_id')
       ->order('p.date desc')->limit($page*$this->piece_nums_per_page,$this->piece_nums_per_page)->select();*/
     $cached_pieces = S('User_pieces_' . $page . '_' . $user_id);
     //是否已有缓存
     if (0) {
         $this->ajaxReturn(array('error' => 0, 'cached' => true, 'pieces' => $cached_pieces), 'json');
     } else {
         $pieces = $piece_model->where('user_id=' . $user_id)->field('piece_id,user_id,date,tag,content,visible,visible_tag')->order('date desc')->select();
         if ($pieces !== false) {
             //关联用户表
             $pieces = DBUtil::loadRelatedData($pieces, 'user_id', 'user', 'id', array('userName', 'avatar'));
             //关联评论表
             $pieces = DBUtil::loadRelatedData($pieces, 'piece_id', 'piece_comment', 'piece_id', array('count(comment_id) as comments_num'));
             $pieces = A('Auth')->filter_invisible_piece($pieces);
             //进行分页并缓存结果
             $pieces = Util::pageOfArray($pieces, $page, $this->piece_nums_per_page);
             S('User_pieces_' . $page . '_' . $user_id, $pieces, array('type' => 'file', 'expire' => 5 * 60));
             //缓存该用户第n页的碎片,5分钟
             $this->ajaxReturn(array('error' => 0, 'pieces' => $pieces), 'json');
         } else {
             $this->ajaxReturn(array('error' => 1, 'msg' => C('SITE_LANG.QUERY_FAILED')), 'json');
         }
     }
 }
示例#3
0
 public function ng_view()
 {
     /**
      * 如果是公开文章则游客有浏览权限
      * 私有文章则只能是登陆用户且是作者本身
      */
     $id = I('get.id');
     /*$essay = $this->essay_model->field('hs_user.userName,hs_essay.user_id,hs_essay.essay_id,hs_essay.title,hs_essay.date,hs_essay.tag,hs_essay.content,hs_essay.visible')->
       join('hs_user ON hs_user.id=hs_essay.user_id AND hs_essay.essay_id='.$id)->find(); 
       if($essay === false){$this->ajaxReturn(array('error'=>1,'msg'=>C('SITE_LANG.QUERY_FAILED')),'json');}//查询失败
       else if($essay == NULL){$this->ajaxReturn(array('error'=>2,'msg'=>C('SITE_LANG.ESSAY_NOT_EXIST')),'json');}//文章不存在
       else{
           if($essay['visible'] == 0 && $essay['user_id'] != $this->user_id)
               $this->ajaxReturn(array('error'=>1,'msg'=>C('SITE_LANG.ESSAY_VIEW_ACCESS_DENIED')),'json');//没有查看的权限
           else if($essay['visible'] == 1 || ($essay['visible'] == 0 && $essay['user_id'] == $this->user_id)){//公开的文章
               //check if essay comment open
               $user_config = A('User')->get_user_config($essay['user_id']);
               $privacy_essay_comment = $user_config['privacy_essay_comment']==1?true:false;
               $essay_comment_on = $privacy_essay_comment && C('ESSAY_COMMENT_ON');//是否开启了评论
               //get essay comments
               if(empty($_SESSION['USER_ID'])){//如果未登录
                   $comments = array();
                   $comments_num = count($comments);
                   //$essay_comment_on = false;
               }else{
                   $comments = A('Comment')->get_essay_comments($essay['essay_id']);
                   $comments_num = count($comments);
               }
               
               $res = array('error'=>0,'essay'=>$essay,'comments'=>$comments,'comments_num'=>$comments_num,'essay_comment_on'=>$essay_comment_on,'is_logined'=>empty($_SESSION['USER_ID'])?0:1);
               $this->ajaxReturn($res,'json');
           }
       }*/
     $essays = $this->essay_model->where('essay_id=' . $id)->field('user_id,essay_id,title,date,tag,content,visible,visible_tag')->select();
     //$this->ajaxReturn(array('error'=>1,'essay'=>$essays),'json');
     if ($essays !== false) {
         if ($essays == NULL) {
             $this->ajaxReturn(array('error' => 2, 'msg' => C('SITE_LANG.ESSAY_NOT_EXIST')), 'json');
         }
         //文章不存在
         $essays = A('Auth')->filter_invisible_essay($essays);
         //可见性验证
         if (count($essays)) {
             //关联用户表
             $essay = DBUtil::loadRelatedData($essays, 'user_id', 'user', 'id', array('userName'))[0];
             //检查是否开启了文章评论,若开启则获取文章评论
             $user_config = A('User')->get_user_config($essay['user_id']);
             $essay_comment_on = $user_config['privacy_essay_comment'] == 1 && C('ESSAY_COMMENT_ON');
             //是否开启了评论
             //获取文章评论
             if (empty($_SESSION['USER_ID'])) {
                 //如果未登录
                 $comments = array();
                 $comments_num = 0;
             } else {
                 $comments = A('Comment')->get_essay_comments($essay['essay_id']);
                 $comments_num = count($comments);
             }
             $res = array('error' => 0, 'essay' => $essay, 'comments' => $comments, 'comments_num' => $comments_num, 'essay_comment_on' => $essay_comment_on, 'is_logined' => empty($_SESSION['USER_ID']) ? 0 : 1);
             $this->ajaxReturn($res, 'json');
         } else {
             $this->ajaxReturn(array('error' => 1, 'msg' => C('SITE_LANG.ESSAY_VIEW_ACCESS_DENIED')), 'json');
         }
         //没有查看的权限
     } else {
         $this->ajaxReturn(array('error' => 1, 'msg' => C('SITE_LANG.QUERY_FAILED')), 'json');
     }
     //查询失败
 }