gaoyixia/application/api/controller/Press.php

<?php
namespace app\api\controller;
use app\common\model\PressComment;
use app\common\model\PlatformLike;
use app\common\model\User;
use app\common\model\UserCollect;
use app\common\model\UserMessage;
use app\common\model\UserReport;
use app\common\model\UserSearch;
use app\common\model\UserTrack;
use app\common\service\CheckPower;
use library\tools\Data;
/**
 * @title 新闻
 * @controller Press
 * @group base
 */
class Press extends Base
{
    // 需要登录的
    protected $need_login = [
        'pressCollect',
        'pressTransmit',
        'pressReport',
        'pressRead',
        'PressTags',
        'pressCommentTags',
        'pressComment',
        'pressSecondComment',
        'getReplyComment',
        'commentMyPress',
        'getMyPressComment',
        'getReplyPress',
        'getPressCollect',
        'getTagsPress',
        'delComment',
    ];
    public function initialize()
    {
        parent::initialize();
        parent::setUid();
    }

    /**
     * @title 新闻接口说明
     * @desc  新闻接口说明
     * @author  qc
     * @url /api/Press/classIntro
     * @method GET
     * @return name:1 type:string default:-- desc:该模块没有视频！！
     */
     public function classIntro(){}

    /**
     * @title 获取新闻列表
     * @desc 获取新闻列表
     * @author qc
     * @method GET
     * @url /api/Press/getPressList
     * @header name:Authorization require:1 desc:Token
     * @param  name:title type:string default:-- desc:标题
     * @param  name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @return name:title type:string default:-- desc:标题
     * @return name:images type:string default:-- desc:图片多张|隔开
     * @return name:images_arr type:array default:-- desc:图片多张[数组]
     * @return name:content type:string default:-- desc:详情
     * @return name:create_at type:string default:-- desc:时间
     * @return name:read_num type:int default:-- desc:阅读
     * @return name:is_collect type:int default:-- desc:是否收藏
     * @return name:transmit_num type:int default:-- desc:转发量
     * @return name:collect_num type:int default:-- desc:收藏量
     * @return name:praise_num type:int default:-- desc:点赞量
     * @return name:is_praise type:int default:-- desc:是否点赞
     * @return name:comment_num type:int default:-- desc:评论量
     */
    public function getPressList(){
        $title = input('get.title');

        $sort_type = input('get.sort_type',1);
        switch ($sort_type) {
            case 1:
                $order =   ['sort'=>'desc','read_num'=>'desc','id'=>'asc'];
                break;
            case 2:
                $order =   ['id'=>'asc','sort'=>'desc'];
                break;
            case 3:
                $order =   ['id'=>'desc','sort'=>'desc'];
                break;
        }

        if($title && $this->user_id) UserSearch::saveSearchTitle($this->user_id,$title,4);
        $list = \app\common\model\Press::where(['is_deleted'=>0])
            ->field('id,images,title,content,read_num,create_at,transmit_num')
            ->when($title,function ($query)use($title){
            if($title) $query->where('title|label','like','%'.$title.'%');
        })->order($order)->limit($this->off_set,$this->page_num)->select()->toArray();
        foreach ($list as &$v) {
            $v['comment_num'] = PressComment::where(['first_id'=>$v['id'],'type'=>1,'is_deleted'=>0])->count();
            $v['comment_num'] = numTransform($v['comment_num']);
            $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,4,$v['id']);
            $v['collect_num'] = UserCollect::getCollectNum(4,$v['id']);
            $v['is_praise'] = PlatformLike::checkTags($this->user_id,$v['id'],1);
            $v['praise_num'] = PlatformLike::getPraiseNum($v['id'],1);
            $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
        }
        $total_num = \app\common\model\Press::where(['is_deleted'=>0])
            ->field('id,images,title,content,read_num,create_at,transmit_num')
            ->when($title,function ($query)use($title){
                if($title) $query->where('title|label','like','%'.$title.'%');
            })->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }

    /**
     * @title 获取新闻详情
     * @desc 获取新闻详情
     * @author qc
     * @method GET
     * @url /api/Press/getPressDetail
     * @header name:Authorization require:1 desc:Token
     * @param  name:id type:int default:0 desc:新闻id
     * @return name:title type:string default:-- desc:标题
     * @return name:images type:string default:-- desc:图片多张|隔开
     * @return name:images_arr type:array default:-- desc:图片多张[数组]
     * @return name:content type:string default:-- desc:详情
     * @return name:create_at type:string default:-- desc:时间
     * @return name:read_num type:int default:-- desc:阅读
     * @return name:is_collect type:int default:-- desc:是否收藏
     * @return name:transmit_num type:int default:-- desc:转发量
     * @return name:collect_num type:int default:-- desc:收藏量
     * @return name:praise_num type:int default:-- desc:点赞量
     * @return name:is_praise type:int default:-- desc:是否点赞
     * @return name:comment_num type:int default:-- desc:评论量
     * @return name:app_name type:string default:-- desc:发布方名称
     * @return name:app_logo type:string default:-- desc:发布方头像
     */
    public function getPressDetail()
    {
        $sel_where[]  = ['id','=',input('get.id')];
        $detail = \app\common\model\Press::field('id,images,title,content,read_num,create_at,transmit_num,user_id,is_deleted,status')->where($sel_where)->find()->toArray();
        if($detail['is_deleted'] == 1 || $detail['status'] == 0) $this->error('该新闻已下架');
        $detail['comment_num'] = PressComment::where(['first_id'=>$detail['id'],'type'=>1,'is_deleted'=>0])->count();
        $detail['comment_num'] = numTransform($detail['comment_num']);
        $detail['transmit_num'] = numTransform($detail['transmit_num']);
        $detail['is_collect'] = UserCollect::checkCollectByType($this->user_id,4,$detail['id']);
        $detail['collect_num'] = UserCollect::getCollectNum(4,$detail['id']);
        $detail['is_praise'] = PlatformLike::checkTags($this->user_id,$detail['id'],1);
        $detail['praise_num'] = PlatformLike::getPraiseNum($detail['id'],1);
        $app_name = sysconf('app_name');
        $app_logo = sysconf('app_logo');
        if(!$detail['user_id']){
            $detail['app_name']  = $app_name;
            $detail['app_logo']  = $app_logo;
        }else{
            $user_info = User::where('id',$detail['user_id'])->field('name,headimg')->find();
            $detail['app_name']  = $user_info ? $user_info->name : '';
            $detail['app_logo']  = $user_info ? $user_info->headimg : '';
        }

      //  \app\common\model\Press::where('id',$detail['id'])->setInc('read_num');
        UserTrack::crateTrack($this->user_id,4,input('get.id'),0);
        $this->success('ok',['detail'=>$detail]);
    }

    /**
     * @title 获取新闻评论列表
     * @desc 获取新闻评论列表
     * @author qc
     * @method GET
     * @url /api/Press/getPressCommentList
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:-- desc:新闻id
     * @param name:sort_type type:int default:1 desc:排序规则1时间2热点
     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数量
     * @return name:name type:string default:-- desc:会员名称
     * @return name:headimg type:string default:-- desc:会员头像
     * @return name:content type:string default:-- desc:内容
     * @return name:is_top type:int default:-- desc:是否置顶（0否1是）
     * @return name:parent type:array default:-- desc:评论上一级（数据同上【一维数组】）
     * @return name:children type:array default:-- desc:二级评论（数据同上【二维数组】）
     * @return name:like_num type:int default:-- desc:点赞数量
     * @return name:is_like type:int default:-- desc:是否点赞（0否1是）
     * @return name:total_num type:int default:-- desc:总评论数（仅一级）
     */
    public function getPressCommentList()
    {
        $where = [];
        $where[] = ['c.first_id','=',input('get.id')];
        $where[] = ['c.is_deleted','=',0];
        $where[] = ['c.type','=',1];
        $user_id = $this->user_id;
        $sort_type= input('sort_type',1);
        switch ($sort_type) {
            case 1:
                $order =  ['c.is_top'=>'desc','c.id'=>'desc'];
                break;
            default:
                $order =  ['c.is_top'=>'desc','c.like_times'=>'desc'];
                break;
        }
        $list  =PressComment::where($where)
            ->alias('c')
            ->field('c.*,u.name,u.headimg')
            ->leftJoin('store_member u','u.id = c.user_id')
            ->order($order)
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();

        array_walk($list,function (&$val,$k)use($user_id){
            $children = PressComment::where(['c.pid'=>$val['id'],'c.is_deleted'=>0])
                ->alias('c')->field('c.*,u.name,u.headimg')
                ->leftJoin('store_member u','u.id = c.user_id')
                ->order('c.is_top desc,c.id asc')
                ->select()->toArray();
            $val['children'] =  $children ? $children : null;
            $val['like_num'] = PlatformLike::getPraiseNum($val['id'],2);
            $val['is_like'] =  PlatformLike::checkTags($user_id,$val['id'],2);
            $parent  = PressComment::where(['c.id'=>$val['pid'],'c.is_deleted'=>0])
                ->alias('c')->field('c.*,u.name,u.headimg')
                ->leftJoin('store_member u','u.id = c.user_id')
                ->find();
            $val['parent']  = $parent ? $parent->toArray() : null;
        });
        $total_num  = PressComment::where($where)   ->leftJoin('store_member u','u.id = c.user_id')->alias('c')->count();
        $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }


    
    /**
     * @title 以下接口调用验证登录【需要header传Authorization】
     * @desc 以下接口调用验证登录
     * @author qc
     * @method
     * @url /api/Press/needLogin()
     */
    public function needLogin(){}

    /**
     * @title 删除评论
     * @desc 删除评论
     * @author qc
     * @method POST
     * @url /api/Press/delComment
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:1 desc:评论id
     */
    public function delComment(){
        PressComment::where(['id'=>input('post.id'),'user_id'=>$this->user_id])->update(['is_deleted'=>1]);
        $this->success('删除成功');
    }
    /**
     * @title 收藏||取消收藏
     * @desc 用户收藏
     * @author qc
     * @method POST
     * @url /api/Press/pressCollect
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int require:1 default:-- desc:新闻id
     * @param name:status type:int default:0 desc:收藏状态（0取消收藏【未收藏】，1收藏）
     */
    public function pressCollect(){
        $coll_status = UserCollect::plateCollect($this->user_id,4,input('post.id',0));
        $coll_status ?  $this->success('收藏成功',['status'=>1]) :    $this->success('取消收藏成功',['status'=>0]);
    }

    /**
     * @title 新闻转发（转发数量统计）
     * @desc 转发成功后调用
     * @author qc
     * @method POST
     * @url /api/Press/pressTransmit
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:-- desc:新闻id
     */
    public function pressTransmit()
    {
        $press_id = input('post.id',0);
        \app\common\model\Press::where('id',$press_id)->setInc('transmit_num');
        $this->success('ok');
    }


    /**
     * @title 新闻举报
     * @desc  新闻举报
     * @author  qc
     * @url /api/Press/pressReport
     * @method POST
     * @header name:Authorization require:1 desc:Token
     * @param name:report_id type:int default:-- desc:举报内容的id
     * @param name:case_ids type:string default:-- desc:举报类目id串（逗号隔开）
     */
    public function pressReport()
    {
        $report_id= input('post.report_id');
        $case_ids= input('post.case_ids');
        if(!$report_id) $this->error('请现在举报内容');
        if(!$case_ids) $this->error('请选择举报原因');
        UserReport::report($this->user_id,7,$report_id,$case_ids);
        $this->success('举报成功');
    }



    /**
     * @title 新闻阅读（阅读数量统计）
     * @desc 新闻阅读
     * @author qc
     * @method POST
     * @url /api/Press/pressRead
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:-- desc:新闻id
     */
    public function pressRead()
    {
        $press_id = input('post.id',0);
        \app\common\model\Press::where('id',$press_id)->setInc('read_num');
        $this->success('ok');
    }

    /**
     * @title 新闻点赞||取消点赞
     * @desc 点赞||取消点赞
     * @author qc
     * @method POST
     * @url /api/Press/PressTags
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:1 desc:新闻id
     * @return name:tags type:int default:1 desc:0取消成功，1点赞成功
     */
    public function pressTags()
    {
        $ret_val = PlatformLike::userTags($this->user_id,input('post.id'),1);
        $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
    }


    /**
     * @title 新闻评论点赞||取消点赞
     * @desc 新闻评论点赞
     * @author qc
     * @method POST
     * @url /api/Press/pressCommentTags
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:1 desc:评论id
     * @return name:tags type:int default:1 desc:0取消成功，1点赞成功
     */
    public function pressCommentTags()
    {
        $ret_val = PlatformLike::userTags($this->user_id,input('post.id'),2);
        $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
    }



    /**
     * @title 新闻评论
     * @desc 新闻评论
     * @author qc
     * @method POST
     * @url /api/Press/pressComment
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:1 desc:新闻id
     * @param name:content type:string default:-- desc:内容
     * @return name:name type:string default:-- desc:会员名称
     * @return name:headimg type:string default:-- desc:会员头像
     * @return name:content type:string default:-- desc:内容
     * @return name:create_at type:string default:-- desc:时间
     */
    public function pressComment()
    {
        $id = input('post.id');
        $content = input('post.content',0);
        if(!$content) $this->error('请输入评论内容');
        $res = PressComment::create(['user_id'=>$this->user_id,'content'=>$content,'first_id'=>$id,'type'=>1]);
        $detail  =PressComment::where('p.id',$res->id)
            ->alias('p')
            ->field('p.id,p.content,p.create_at,u.name,u.headimg')
            ->leftJoin('store_member u','u.id = p.user_id')
            ->find()->toArray();
        $this->success('评论成功',['detail'=>$detail]);
    }

    /**
     * @title 新闻二级评论
     * @desc 新闻二级评论
     * @author qc
     * @method POST
     * @url /api/Press/pressSecondComment
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:1 desc:评论id
     * @param name:content type:string default:-- desc:内容
     * @return name:name type:string default:-- desc:会员名称
     * @return name:headimg type:string default:-- desc:会员头像
     * @return name:content type:string default:-- desc:内容
     * @return name:is_top type:int default:-- desc:是否置顶（0否1是）
     */
    public function pressSecondComment()
    {
        $comment = PressComment::where('id',input('post.id'))->find()->toArray();

        $user_info = $this->userInfo('name');
        UserMessage:: sendUserMessage($comment['user_id'],'press',1,0,$this->user_id,$comment['id'],$user_info['name'].'回复了您的评论');

        unset($comment['id']);
        unset($comment['create_at']);
        $comment['pid'] = input('post.id');
        $comment['user_id'] = $this->user_id;
        $comment['content'] = input('post.content');
        $comment['lev']++;
        if(!$comment['source_id']) $comment['source_id'] = input('post.id');
        $res = PressComment::create($comment);
        $detail  = PressComment::where('p.id',$res->id)
            ->alias('p')
            ->field('p.id,p.content,p.is_top,p.create_at,u.name,u.headimg')
            ->leftJoin('store_member u','u.id = p.user_id')
            ->find()->toArray();
        $this->success('评论成功',['detail'=>$detail]);
    }


    /**
     * @title 获取角标数量
     * @desc 获取角标数量
     * @author qc
     * @method GET
     * @url /api/Press/getMarkNum
     * @header name:Authorization require:1 desc:Token
     * @return name:reply_num type:int default:-- desc:未读量--回复我的
     * @return name:comment_num type:int default:-- desc:未读量--评论我的
     */
    public function getMarkNum()
    {
        // 回复我的
        $all_comment = PressComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
        $reply_num =  PressComment::where([['t.is_deleted','=',0],['t.lev','>=',2],['is_read','=',0],['t.pid','in',implode(',',$all_comment)]])->alias('t')->count();
        // 评论我的
        $comment_num = PressComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['is_read','=',0]])
            ->leftJoin('Press i','t.first_id = i.id')
            ->alias('t')->count();
        $this->success('ok',compact(['reply_num','comment_num']));
    }

    /**
     * @title 消息已读
     * @desc 消息已读
     * @author qc
     * @method POST
     * @url /api/Press/unreadChange
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:string default:-- desc:记录id【不区分类型】
     */
    public function unreadChange()
    {
        PressComment::where('id',input('post.id'))->update(['is_read'=>1]);
        $this->success('ok');
    }


    /**
     * @title 回复我的【回复我的--回复过我的评论】
     * @desc 回复我的
     * @author qc
     * @method GET
     * @url /api/Press/getReplyComment
     * @header name:Authorization require:1 desc:Token
     * @param  name:title type:string default:-- desc:标题
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @return name:title type:string default:-- desc:标题
     * @return name:cover type:string default:-- desc:封面
     * @return name:is_read type:int default:-- desc:是否已读（0未读1已读）
     * @return name:iamges_arr type:array default:-- desc:图片【多张】
     * @return name:create_at type:string default:-- desc:时间
     * @return name:is_top type:int default:-- desc:是否置顶（0否1是）
     * @return name:user_name type:string default:-- desc:用户名【其他会员】
     * @return name:headimg type:string default:-- desc:用户头【其他会员】
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     * @return name:parent_comment type:array default:-- desc:你的评论内容【别人回复的那个评论】
     * @return name:parent_comment.content type:string default:-- desc:内容
     * @return name:parent_comment.name type:string default:-- desc:会员名称
     * @return name:parent_comment.title type:string default:-- desc:标题
     * @return name:parent_comment.press_id type:string default:-- desc:新闻id
     */
    public function getReplyComment()
    {
        $all_comment = PressComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
        if(empty($all_comment)) $this->success('ok',['list'=>null]);
        $sel_where  = [];
        $title = input('get.title');
        if($title)  $sel_where[]  = ['i.title|i.label','like','%'.$title.'%'];
        $sel_where[]  = ['t.is_deleted','=',0];
        $sel_where[]  = ['t.lev','>=',2];
        //$sel_where[]  = ['t.user_id','<>',$this->user_id];
        $sel_where[]  = ['t.pid','in',implode(',',$all_comment)];
        $list = PressComment::where($sel_where)
            ->alias('t')
            ->field('t.id,t.is_top,t.is_read,t.create_at,t.first_id press_id,t.lev,t.content,t.pid,u.name user_name,u.headimg,i.cover,i.images')
            ->leftJoin('store_member u','t.user_id = u.id')
            ->leftJoin('Press i','t.first_id = i.id')
            ->order('t.is_top desc,t.id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        foreach ($list as &$v) {
            $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
            $v['cover'] =   $v['images_arr'] ? $v['images_arr'][0] : null;
            $v['is_normal'] = CheckPower::checkModulesPower($v['press_id'],0,$this->request->controller());
            $parent_comment = PressComment::where([['t.id','=',$v['pid']]])
                ->field('t.id,t.first_id press_id,t.is_top,t.content,i.title,i.cover,t.pid,u.name')
                ->alias('t')
                ->leftJoin('Press i','t.first_id = i.id')
                ->leftJoin('store_member u','t.user_id = u.id')
                ->find()->toArray();
            $v['parent_comment'] = $parent_comment;
        }
        $total_num = PressComment::where($sel_where)->alias('t')->leftJoin('store_member u','t.user_id = u.id')->leftJoin('Press i','t.first_id = i.id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }

    /**
     * @title 评论我的
     * @desc 评论我的
     * @author qc
     * @method GET
     * @url /api/Press/commentMyPress
     * @header name:Authorization require:1 desc:Token

     * @param name:title type:string default:-- desc:标题
     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数
     *
     * @return name:title type:string default:-- desc:标题
     * @return name:press_id type:string default:-- desc:新闻id
     * @return name:cover type:string default:-- desc:封面
     * @return name:is_read type:int default:-- desc:是否已读（0未读1已读）
     * @return name:is_top type:int default:-- desc:是否置顶（0否1是）
     * @return name:create_at type:string default:-- desc:时间
     * @return name:user_name type:string default:-- desc:用户名
     * @return name:headimg type:string default:-- desc:用户头像
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     */
    public function commentMyPress()
    {
        $sel_where  = [];
        $title = input('get.title');
        if($title)  $sel_where[]  = ['i.title|i.label','like','%'.$title.'%'];
        $sel_where[]  = ['t.is_deleted','=',0];
        $sel_where[]  = ['i.user_id','=',$this->user_id];
        $list = PressComment::where($sel_where)
            ->alias('t')
            ->field('t.id,t.is_read,t.is_top,t.create_at,t.first_id press_id,t.content,i.images,i.title,i.cover,u.name user_name,u.headimg')
            ->leftJoin('Press i','t.first_id = i.id')
            ->leftJoin('store_member u','t.user_id = u.id')
            ->order('t.is_top desc,t.id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        array_walk($list,function (&$v){
            $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
            $v['cover'] =   $v['images_arr'] ? $v['images_arr'][0] : null;
            $v['is_normal'] = CheckPower::checkModulesPower($v['press_id'],0,$this->request->controller());
        });
        $total_num = PressComment::where($sel_where)->alias('t') ->leftJoin('Press i','t.first_id = i.id')
            ->leftJoin('store_member u','t.user_id = u.id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }

    /**
     * @title 我的评论
     * @desc 我的评论
     * @author qc
     * @method GET
     * @url /api/Press/getMyPressComment
     * @header name:Authorization require:1 desc:Token

     * @param name:title type:string default:-- desc:标题
     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数
     *
     * @return name:title type:string default:-- desc:标题
     * @return name:press_id type:string default:-- desc:新闻id
     * @return name:cover type:string default:-- desc:封面
     * @return name:images_arr type:array default:-- desc:封面
     * @return name:create_at type:string default:-- desc:时间
     * @return name:user_name type:string default:-- desc:用户名【用户自己的】
     * @return name:headimg type:string default:-- desc:用户头像【用户自己的】
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     */
    public function getMyPressComment()
    {
        $where = [];
        $where[] = ['t.is_deleted','=',0];
        $where[] = ['t.type','=',1];
        $where[] = ['t.user_id','=',$this->user_id];
        $list = PressComment::where($where)
            ->alias('t')
            ->field('t.id,t.is_top,t.create_at,t.first_id press_id,i.images,t.content,i.title,i.cover,u.name user_name,u.headimg')
            ->leftJoin('Press i','t.first_id = i.id')
            ->leftJoin('store_member u','u.id = t.user_id')
            ->order('t.is_top desc,id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        foreach ($list as &$v) {
            $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
            $v['cover'] =   $v['images_arr'] ? $v['images_arr'][0] : null;
            $v['is_normal'] = CheckPower::checkModulesPower($v['press_id'],0,$this->request->controller());
        }
        $total_num = PressComment::where($where)
            ->alias('t')  ->leftJoin('Press i','t.first_id = i.id')
            ->leftJoin('store_member u','u.id = t.user_id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);

    }


    /**
     * @title 我的回复【我的回复--我回复过的评论】
     * @desc 我的评论
     * @author qc
     * @method GET
     * @url /api/Press/getReplyPress
     * @header name:Authorization require:1 desc:Token
     * @param  name:title type:string default:-- desc:标题
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @return name:title type:string default:-- desc:标题
     * @return name:press_id type:int default:-- desc:新闻id
     * @return name:cover type:string default:-- desc:封面
     * @return name:images_arr type:array default:-- desc:图片多张[数组]
     * @return name:create_at type:string default:-- desc:时间
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     * @return name:user_name type:string default:-- desc:用户名【用户自己的】
     * @return name:headimg type:string default:-- desc:用户头像【用户自己的】
     * @return name:parent_comment type:array default:-- desc:上级评论内容【你评论的那个评论】
     * @return name:parent_comment.content type:string default:-- desc:内容
     * @return name:parent_comment.name type:string default:-- desc:会员名称
     * @return name:parent_comment.title type:string default:-- desc:新闻标题
     * @return name:parent_comment.press_id type:string default:-- desc:新闻id
     */
    public function getReplyPress()
    {
        $user_info = $this->userInfo();
        $sel_where  = [];
        $title = input('get.title');
        if($title)  $sel_where[]  = ['i.title|i.label','like','%'.$title.'%'];
        $sel_where[]  = ['t.user_id','=',$this->user_id];
        $sel_where[]  = ['t.is_deleted','=',0];
        $sel_where[]  = ['t.lev','>=',2];
        $list = PressComment::where($sel_where)
            ->alias('t')
            ->field('t.id,t.is_top,t.create_at,t.first_id press_id,t.lev,t.content,t.pid,i.title,i.cover,images')
            ->leftJoin('Press i','t.first_id = i.id')
            ->order('t.is_top,t.id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        foreach ($list as &$v) {
            $v['user_name'] = $user_info['name'];
            $v['headimg'] = $user_info['headimg'];
            $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
            $v['cover'] =   $v['images_arr'] ? $v['images_arr'][0] : null;
            $v['is_normal'] = CheckPower::checkModulesPower($v['press_id'],0,$this->request->controller());
            $parent_comment = PressComment::where([['t.id','=',$v['pid']]])
                ->field('t.id,t.is_top,t.first_id press_id,t.content,i.title,i.cover,i.images,t.pid,u.name')
                ->alias('t')
                ->leftJoin('Press i','t.first_id = i.id')
                ->leftJoin('store_member u','t.user_id = u.id')
                ->find()->toArray();
            $parent_comment['images_arr'] = $parent_comment['images'] ? explode('|',$parent_comment['images']) : null;
            $v['parent_comment'] = $parent_comment;
        }
        $total_num = PressComment::where($sel_where)->alias('t')->leftJoin('Press i','t.first_id = i.id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }


    /**
     * @title 我的收藏【新闻】
     * @desc 我的收藏
     * @author qc
     * @method GET
     * @url /api/Press/getPressCollect
     * @header name:Authorization require:1 desc:Token

     * @param name:title type:string default:-- desc:标题
     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数
     *
     * @return name:title type:string default:-- desc:标题
     * @return name:press_id type:string default:-- desc:新闻id
     * @return name:cover type:string default:-- desc:封面
     * @return name:create_at type:string default:-- desc:时间
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     */
    public function getPressCollect()
    {
        $sel_where  = [];
        $title = input('get.title');
        if($title)  $sel_where[]  = ['i.title|i.label','like','%'.$title.'%'];
        $sel_where[]  = ['t.user_id','=',$this->user_id];
        $sel_where[]  = ['t.coll_type','=',4];
        $list = UserCollect::where($sel_where)
            ->alias('t')
            ->field('t.id,t.create_at,t.coll_id press_id,i.title,i.cover,images')
            ->leftJoin('Press i','t.coll_id = i.id')
            ->order('id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        foreach ($list as &$v) {
            $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
            $v['cover'] =   $v['images_arr'] ? $v['images_arr'][0] : null;
            $v['is_normal'] = CheckPower::checkModulesPower($v['press_id'],0,$this->request->controller());
           /* $v['comment_num'] = PressComment::where(['first_id'=>$v['press_id'],'type'=>1,'is_deleted'=>0])->count();
            $v['collect_num'] = UserCollect::getCollectNum(4,$v['press_id']);
            $v['praise_num'] = PlatformLike::getPraiseNum($v['press_id'],1);*/
        }
        $total_num =  UserCollect::where($sel_where)->alias('t')
            ->leftJoin('Press i','t.coll_id = i.id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }

    /**
     * @title 我的点赞列表【新闻】
     * @desc 我的点赞
     * @author qc
     * @method GET
     * @url /api/Press/getTagsPress
     * @header name:Authorization require:1 desc:Token

     * @param name:title type:string default:-- desc:标题
     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数
     *
     * @return name:title type:string default:-- desc:标题
     * @return name:press_id type:string default:-- desc:新闻id
     * @return name:cover type:string default:-- desc:封面
     * @return name:create_at type:string default:-- desc:时间
     *
     * @return name:is_collect type:int default:-- desc:是否收藏
     * @return name:transmit_num type:int default:-- desc:转发量
     * @return name:collect_num type:int default:-- desc:收藏量
     * @return name:praise_num type:int default:-- desc:点赞量
     * @return name:comment_num type:int default:-- desc:评论量
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     */
    public function getTagsPress()
    {
        $sel_where  = [];
        $title = input('get.title');
        if($title)  $sel_where[]  = ['i.title|i.label','like','%'.$title.'%'];
        $sel_where[]  = ['t.user_id','=',$this->user_id];
        $sel_where[]  = ['t.type','=',1];
        $list = PlatformLike::where($sel_where)
            ->alias('t')
            ->field('t.id,t.create_at,t.like_id press_id,i.title,i.cover,images')
            ->leftJoin('Press i','t.like_id = i.id')
            ->order('id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        foreach ($list as &$v) {
            $v['is_normal'] = CheckPower::checkModulesPower($v['press_id'],0,$this->request->controller());
            $v['comment_num'] = PressComment::where(['first_id'=>$v['press_id'],'type'=>1,'is_deleted'=>0])->count();
            $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,4,$v['press_id']);
            $v['collect_num'] = UserCollect::getCollectNum(4,$v['press_id']);
            $v['is_praise'] = PlatformLike::checkTags($this->user_id,$v['press_id'],1);
            $v['praise_num'] = PlatformLike::getPraiseNum($v['press_id'],1);
            $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
            $v['cover'] =   $v['images_arr'] ? $v['images_arr'][0] : null;
        }
        $total_num = PlatformLike::where($sel_where)->alias('t')->leftJoin('Press i','t.like_id = i.id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }

    /**
     * @title 我的浏览历史【新闻】
     * @desc 我的浏览历史
     * @author qc
     * @method GET
     * @url /api/Press/getPressTrack
     * @header name:Authorization require:1 desc:Token

     * @param name:title type:string default:-- desc:标题
     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数
     *
     * @return name:title type:string default:-- desc:标题
     * @return name:press_id type:string default:-- desc:新闻id
     * @return name:cover type:string default:-- desc:封面
     * @return name:create_at type:string default:-- desc:时间
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     */
    public function getPressTrack()
    {
        $sel_where  = [];
        $sel_where[]  = ['t.user_id','=',$this->user_id];
        $sel_where[]  = ['t.type','=',4];
        $title = input('get.title');
        if($title)  $sel_where[]  = ['i.title|i.label','like','%'.$title.'%'];
        $list = UserTrack::where($sel_where)
            ->alias('t')
            ->field('t.id,t.update_int,t.first_id press_id,i.title,i.cover,i.images')
            ->leftJoin('Press i','t.first_id = i.id')
            ->order('update_int desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        foreach ($list as &$v) {
            $v['is_normal'] = CheckPower::checkModulesPower($v['press_id'],0,$this->request->controller());
            $v['images_arr'] = $v['images'] ? explode('|',$v['images']) : null;
            $v['cover'] =   $v['images_arr'] ? $v['images_arr'][0] : null;
            $v['time'] = date("Y-m-d H:i:s",$v['update_int']);
            /* $v['comment_num'] = PressComment::where(['first_id'=>$v['press_id'],'type'=>1,'is_deleted'=>0])->count();
         $v['collect_num'] = UserCollect::getCollectNum(4,$v['press_id']);
         $v['praise_num'] = PlatformLike::getPraiseNum($v['press_id'],1);*/
        }
        $total_num = UserTrack::where($sel_where)->alias('t')->leftJoin('Press i','t.first_id = i.id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }











}