gaoyixia/application/api/controller/Datum.php

<?php
namespace app\api\controller;
use app\common\model\ArticleItem;
use app\common\model\DatumCate;
use app\common\model\DatumComment;
use app\common\model\DatumCommentLike;
use app\common\model\DatumIntro;
use app\common\model\DatumLike;
use app\common\model\DatumUrl;
use app\common\model\PlatformSwitch;
use app\common\model\User;
use app\common\model\UserCollect;
use app\common\model\UserDatum;
use app\common\model\UserDownload;
use app\common\model\UserLearn;
use app\common\model\UserLevelRank;
use app\common\model\UserMessage;
use app\common\model\UserSearch;
use app\common\model\UserTrack;
use app\common\service\CheckPower;
use library\tools\Data;
use think\Db;

/**
 * @title 资料
 * @controller Datum
 * @group base
 */
class Datum extends Base
{
    // 需要登录的
    protected $need_login = [
        'datumTransmit',
        'datumDownload',
        'datumRead',
        'datumCollect',
        'datumTags',
        'userReferDatum',
        'getMyDatumList',
        'getUserDatumDetail',
        'delUserDatum',
        'getDownloadDatum',
        'getLearnHistory',
        'getDatumCollect',
        'getBoundList',
        'getFollowUpList',
    ];
    public function initialize()
    {
        parent::initialize();
        parent::setUid();
    }


    /**
     * @title 资料接口说明
     * @desc  资料接口说明
     * @author  qc
     * @url /api/Datum/classIntro
     * @method GET
     * @return name:1 type:string default:-- desc:单一资料与系列资料区别，type值（1是单一，2是系列），数据：url_arr二维数组数据数量不一样（单一的只有一个，系列的可以是多个）【可以将单一资料看做只有一条记录的系列资料！！！！】
     * @return name:2 type:string default:-- desc:单一资料详情的字段（除id）与url_arr数组的第一个同字段名的值相同
     * @return name:3 type:string default:-- desc:系列资料详情的字段（除id）与url_arr数组的其中一个同字段名的值相同
     * @return name:4 type:string default:-- desc:关于是否的字段（0否，1是）
     * @return name:5 type:string default:-- desc:url_id是详情或列表url_arr下的id
     */
    public function classIntro(){ }

    /**
     * @title 获取资料目录
     * @desc  获取资料目录
     * @author  qc
     * @url /api/Datum/getDatumCate
     * @method GET
     * @header name:Authorization require:1 desc:Token
     * @return name:id type:int default:-- desc:id
     * @return name:title type:string default:0 desc:名称
     * @return name:datum_list type:array default:0 desc:目录下的资料
     * @return name:datum_list.id type:int default:0 desc:资料记录
     * @return name:datum_list.title type:int default:0 desc:资料标题
     */
    public function getDatumCate()
    {
        $list = DatumCate::field('id,title')->where('is_deleted',0)->where('status',1)->select()->toArray();
        foreach ($list as &$v) {
            $v['datum_list'] = DatumIntro::field('id,title')
                ->where(['datum_cate'=>$v['id'],'status'=>1,'is_deleted'=>0])->select()->toArray();
        }
        $this->success('ok',['list'=>$list]);
    }


    /**
     * @title 资料推荐
     * @desc 资料推荐
     * @author qc
     * @method GET
     * @url /api/Datum/getRecommendList
     * @header name:Authorization require:1 desc:Token
     * @param  name:page type:int default:0 desc:页数
     * @param  name:page_num type:int default:20 desc:每页数
     * @return name:id type:string default:-- desc:资料item_id
     * @return name:title type:string default:-- desc:标题
     * @return name:datum_id type:string default:-- desc:系列id
     * @return name:is_vip type:int default:-- desc:是否是vip（0否，1是）
     * @return name:read_num type:int default:-- desc:阅读量
     * @return name:down_num type:int default:-- desc:下载量
     * @return name:url type:int default:-- desc:资料路径
     * @return name:app_name type:string default:-- desc:发布者
     * @return name:app_logo type:string default:-- desc:发布者头像
     * @return name:create_at type:string default:-- desc:时间
     * @return name:is_down type:int default:-- desc:是否能下载（0否【pdf加密】1是【pdf未加密】）
     *
     */
    public function getRecommendList()
    {
        $search_log =  UserSearch::getSearchTitle($this->user_id,3);
        $search_arr = [];
        $where_str = 'b.id > 0';
        foreach ($search_log as $t){
            $search_arr[] =  " b.title like '".'%'.$t."%'" .' ';
            $search_arr[] =  " b.label like '".'%'.$t."%'" .' ';
        }
        if(!empty($search_arr)) $where_str  =  implode(' OR ',$search_arr);
        $field = ' a.id,a.title,a.user_id,a.create_at,a.down_num,a.read_num,a.is_vip,a.datum_id,a.url ,IFNULL(is_recommend,0) is_recommend ';
        $table = 'dd_datum_url';
        $order_by_two = 'a.read_num';
        $time_str  = date("Y-m-d H:i:s");
        $sql = "SELECT $field FROM " .$table . " a LEFT JOIN ( SELECT id,IF(id,1,1) is_recommend FROM $table b WHERE ( $where_str )) AS c ON c.id = a.id LEFT JOIN dd_datum_intro as k ON k.id = a.datum_id WHERE a.status = 1 AND a.is_deleted = 0 AND k.status = 1 AND k.is_deleted = 0 AND a.release_time < '". $time_str ."' ORDER BY is_recommend DESC , $order_by_two desc LIMIT {$this->off_set},{$this->page_num}";
        $list = Db::query($sql);
        $list = dispose_recommend($list);
        array_walk($list,function (&$v,$k){
            $v['down_num'] = numTransform($v['down_num']);
            $v['read_num'] = numTransform($v['read_num']);
            $datum_auth = ArticleItem::getArticleAuth($v['user_id'],APPNAME,APPLOGO);
            $v['app_name'] = $datum_auth['app_name'];
            $v['app_logo'] = $datum_auth['app_logo'];
        });
        $sql2 = "SELECT count(a.id) num FROM " .$table . " a LEFT JOIN ( SELECT id,IF(id,1,1) is_recommend FROM $table b WHERE ( $where_str )) AS c ON c.id = a.id LEFT JOIN dd_datum_intro as k ON k.id = a.datum_id WHERE a.status = 1 AND a.is_deleted = 0 AND k.status = 1 AND a.release_time < '". $time_str ."' AND k.is_deleted = 0 " ;
        $total =  Db::query($sql2);
        $this->success('ok',['list'=>$list,'total_count'=>$total[0]['num'],'page_num'=>$this->page_num]);
    }



    /**
     * @title 获取资料系列列表(平台发布)
     * @desc 系列--全部
     * @author qc
     * @method GET
     * @url /api/Datum/getDatumList
     * @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:每页数
     * @param  name:sort_type type:int default:1 desc:1默认2时间升序3时间降序
     * @return name:id type:int default:-- desc:[请求/api/Datum/getDatumDetail用，请求资料模块其他接口参数：url_id]
     * @return name:title type:string default:-- desc:标题
     * @return name:type type:int default:0 desc:类型1单个2系列
     * @return name:datum_url type:string default:-- desc:资料地址
     * @return name:is_vip type:int default:-- desc:是否是vip（0否，1是）
     * @return name:is_over type:int default:-- desc:是否完结（0否，1是）
     * @return name:label type:string default:-- desc:标签
     * @return name:is_collect type:int default:-- desc:是否收藏
     * @return name:url_arr type:array default:-- desc:资料
     * @return name:url_arr.title type:string default:-- desc:资料标题
     * @return name:url_arr.is_vip type:int default:-- desc:是否是vip
     * @return name:url_arr.url type:string default:-- desc:资料地址
     * @return name:url_arr.is_down type:int default:-- desc:是否能下载（0否【pdf加密】1是【pdf未加密】）
     */
    public function getDatumList()
    {
        $sel_where = [];
        $title = input('get.title');
        $type = input('get.type',2);
        $is_tj = input('get.is_tj',0);
        $sort_type = input('get.sort_type',1);
        $sel_where[]  = ['is_deleted','=',0];
        $sel_where[]  = ['status','=',1];
        $sel_where[] = ['url_num','>',0];
        if($title)  $sel_where[]  = ['title|label','like','%'.$title.'%'];
        if($type)  $sel_where[]  = ['type','=',$type];

        switch ($sort_type) {
            case 1:
                $order =  ['sort'=>'desc','read_num'=>'desc'];
                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,3);
        $where_str = 'id > 0';
        $list = DatumIntro::where($sel_where)->with('urlArr')
            ->limit($this->off_set,$this->page_num)
            ->where($where_str)
            ->order($order)
            ->select()->toArray();
        array_walk($list,function (&$v,$k){
            $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,2,$v['id']);
            $v['down_num']  = array_sum(array_column($v['url_arr'],'down_num'));
            $v['down_num'] = numTransform($v['down_num']);
        });
        $total_num = DatumIntro::where($sel_where)->where($where_str)->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }

    /**
     * @title 获取资料系列详情(【合集列表】平台)
     * @desc 获取资料系列详情
     * @author qc
     * @method GET
     * @url /api/Datum/getDatumDetail
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:0 desc:资料id
     * @param name:sort_type type:int default:1 desc:1正序2倒序
     * @return name:title type:string default:-- desc:标题
     * @return name:datum_url type:string default:-- desc:资料地址
     * @return name:down_num type:string default:-- desc:下载量

     * @return name:follow_switch type:int default:-- desc:订阅开关状态【0关闭1开启】
     * @return name:switch_open type:int default:-- desc:通知开关【0关闭1开启】
     * @return name:video_id type:int default:-- desc:视频id
     * @return name:video_item type:int default:-- desc:item_id
     * @return name:goods_id type:int default:-- desc:商品id

     * @return name:url_arr type:array default:-- desc:资料
     * @return name:url_arr.id type:int default:-- desc:[请求/api/Datum/getDatumItemInfo用，请求资料模块其他接口参数：url_id]
     * @return name:url_arr.title type:string default:-- desc:资料标题
     * @return name:url_arr.is_vip type:int default:-- desc:是否是vip
     * @return name:url_arr.url type:string default:-- desc:资料地址
     * @return name:url_arr.is_collect type:int default:-- desc:是否收藏
     * @return name:url_arr.collect_num type:int default:-- desc:收藏量
     * @return name:url_arr.down_num type:int default:-- desc:下载量
     * @return name:url_arr.read_num type:int default:-- desc:阅读量

     * @return name:url_arr.is_recently type:int default:-- desc:是否最近观看【0否1是】
     */
    public function getDatumDetail()
    {
        $sel_where  = [];
        $sel_where[]  = ['id','=',input('get.id')];
        $sort_type = input('sort_type',1);
        $detail = DatumIntro::where($sel_where)->with(['urlArr'=>function($query)use($sort_type){
            return $query->order('id',$sort_type == 1 ? 'asc' : 'desc');
        }])->find()->toArray();
        if($detail['is_deleted'] == 1 || $detail['status'] == 0)$this->error('该资料已下线');
        $level_id = UserLevelRank::getUserVip($this->user_id);
        $detail['read_num']  = numTransform(array_sum(array_column($detail['url_arr'],'read_num')));
        $detail['down_num']  = numTransform(array_sum(array_column($detail['url_arr'],'down_num')));
        $detail['follow_switch'] =  PlatformSwitch::checkSwitch($this->user_id,$detail['id'],4);
        $detail['switch_open'] =  PlatformSwitch::checkSwitch($this->user_id,$detail['id'],9);
        $detail['h5_url'] =$this->request->root(true).'/#/information-collection-list?id='.$detail['id'];
        $recently_id = UserTrack::getRecentlyTrack($this->user_id,2,$detail['id']);
        foreach ($detail['url_arr'] as &$dv) {
            if($dv['is_vip'] && !$level_id) $dv['url'] = '';
            $dv['is_collect'] = UserCollect::checkCollectByType($this->user_id,2,$detail['id'],$dv['id']);
            $dv['collect_num'] = UserCollect::where(['user_id'=>$this->user_id,'coll_type'=>1,'coll_id'=>$detail['id'],'children_id'=>$dv['id']])->count();
            $dv['collect_num'] = numTransform($dv['collect_num']);
            $dv['down_num'] = numTransform($dv['down_num']);
            $dv['is_recently'] = $dv['id'] == $recently_id ? 1 : 0;
            $datum_auth = ArticleItem::getArticleAuth($dv['user_id'],APPNAME,APPLOGO);
            $dv['app_name'] = $datum_auth['app_name'];
            $dv['app_logo'] = $datum_auth['app_logo'];
        }
        $this->success('ok',['detail'=>$detail]);
    }


    /**
     * @title 获取资料ITEM详情(平台)
     * @desc 获取资料ITEM详情
     * @author qc
     * @method GET
     * @url /api/Datum/getDatumItemInfo
     * @header name:Authorization require:1 desc:Token
     * @param  name:url_id type:int default:0 desc:url_id
     * @return name:title type:string default:-- desc:资料标题
     * @return name:is_vip type:int default:-- desc:是否是vip
     * @return name:cover type:string default:-- desc:封面
     * @return name:images type:int default:-- desc:图片
     * @return name:content type:int default:-- desc:内容
     * @return name:transmit_num type:int default:-- desc:转发量
     * @return name:read_num type:int default:-- desc:阅读量
     * @return name:collect_num type:int default:-- desc:收藏量
     * @return name:down_num type:int default:-- desc:下载量
     * @return name:comment_num type:int default:-- desc:评论量
     * @return name:is_collect type:int default:-- desc:是否收藏
     * @return name:follow_switch type:int default:-- desc:订阅开关状态【0关闭1开启】
     * @return name:switch_open type:int default:-- desc:通知开关【0关闭1开启】
     * @return name:praise_num type:int default:-- desc:点赞量
     * @return name:is_praise type:int default:-- desc:是否点赞
     * @return name:is_down type:int default:-- desc:是否可以下载【0否1是】
     */
    public function getDatumItemInfo()
    {
        $url_id = input('get.url_id');
        $detail = DatumUrl::where('id',$url_id)->find()->toArray();
        if($detail['is_deleted'] == 1 || $detail['status'] == 0) $this->error('该资料已下架');
        $detail['series_title'] =DatumIntro::where('id',$detail['datum_id'])->value('title');
        $detail['follow_switch'] = PlatformSwitch::checkSwitch($this->user_id,$detail['datum_id'],4);
        $detail['collect_num']  = UserCollect::where(['coll_type'=>2,'coll_id'=>$detail['datum_id'],'children_id'=>$detail['id']])->count();
        $detail['is_collect']   = UserCollect::checkCollectByType($this->user_id,2,$detail['datum_id'],$detail['id']);
        $detail['collect_num']  = numTransform($detail['collect_num']);
        $detail['down_num']     = numTransform($detail['down_num']);
        $detail['read_num']     = numTransform($detail['read_num']);
        $detail['transmit_num'] = numTransform($detail['transmit_num']);
        $detail['comment_num'] = DatumComment::getDatumCommentNum($detail['id']);
        $detail['follow_switch'] =  PlatformSwitch::checkSwitch($this->user_id,$detail['id'],4);
        $detail['switch_open'] =  PlatformSwitch::checkSwitch($this->user_id,$detail['id'],9);
        $detail['praise_num']= DatumLike::where([['url_id','=',$url_id]])->count();
        $detail['is_praise']= DatumLike::where([['user_id','=',$this->user_id],['url_id','=',$url_id]])->count();
        UserTrack::crateTrack($this->user_id,2,$detail['datum_id'],$url_id);
        $this->success('ok',['detail'=>$detail]);
    }
    

    /**
     * @title 资料转发（转发数量统计）
     * @desc 转发成功后调用
     * @author qc
     * @method POST
     * @url /api/Datum/datumTransmit
     * @header name:Authorization require:1 desc:Token
     * @param name:datum_id type:int default:-- desc:资料id
     *
     * @param name:url_id type:int default:-- desc:url_id
     */
    public function datumTransmit()
    {
        $datum_id= input('post.datum_id');
        $url_id = input('post.url_id',0);
        DatumUrl::where('id',$url_id)->setInc('transmit_num');
        $this->success('ok');
    }



    /**
     * @title 资料下载（资料下载数量统计）
     * @desc 资料下载
     * @author qc
     * @method POST
     * @url /api/Datum/datumDownload
     * @header name:Authorization require:1 desc:Token
     * @param name:datum_id type:int default:-- desc:资料id
     * @param name:url_id type:int default:-- desc:url_id
     */
    public function datumDownload()
    {
        $datum_id= input('post.datum_id');
        $url_id = input('post.url_id',0);
        Data::save('UserDownload',['user_id'=>$this->user_id,'first_id'=>$datum_id,'second_id'=>$url_id]);
        DatumUrl::where('id',$url_id)->setInc('down_num');
        $this->success('ok');
    }

    /**
     * @title 资料阅读（阅读数量统计）
     * @desc 资料阅读
     * @author qc
     * @method POST
     * @url /api/Datum/datumRead
     * @header name:Authorization require:1 desc:Token
     * @param name:url_id type:int default:-- desc:url_arr的id
     */
    public function datumRead()
    {
        $url_id = input('post.url_id',0);
        $datum_id =  DatumUrl::where('id',$url_id)->value('datum_id');
        DatumUrl::where('id',$url_id)->setInc('read_num');
        DatumIntro::where('id',$datum_id)->setInc('read_num');
        $this->success('ok');
    }

    /**
     * @title 资料收藏||取消收藏
     * @desc 用户收藏
     * @author qc
     * @method POST
     * @url /api/Datum/datumCollect
     * @header name:Authorization require:1 desc:Token
     * @param name:datum_id type:int require:1 default:-- desc:记录id[资料id]
     * @param name:url_id type:int default:1 desc:url_id
     * @return  name:status type:int default:0 desc:收藏状态（0取消收藏【未收藏】，1收藏）
     */
    public function datumCollect()
    {
        $coll_type  = input('post.coll_type',2);
        $coll_id    = input('post.datum_id',0);
        $url_id   = input('post.url_id',0);
        if(!$coll_id || !$url_id) $this->error('参数错误');
        $collect_check = UserCollect::checkCollectByType($this->user_id,$coll_type,$coll_id,$url_id);
        if($collect_check) {
            UserCollect::where(['user_id'=>$this->user_id,'coll_type'=>$coll_type,'coll_id'=>$coll_id,'children_id'=>$url_id])->delete();
            $this->success('取消收藏成功',['status'=>0]);
        }else{
            Data::save('UserCollect', [
                'user_id'=>$this->user_id,
                'coll_type'=>$coll_type,
                'coll_id'=>$coll_id,
                'children_id'=>$url_id,
                'create_int'=>time()],'user_id',['user_id'=>$this->user_id,'coll_type'=>$coll_type, 'coll_id'=>$coll_id,'children_id'=>$url_id]);
            $this->success('收藏成功',['status'=>1]);
        }
    }


    /**
     * @title 资料点赞||取消点赞
     * @desc 点赞||取消点赞
     * @author qc
     * @method POST
     * @url /api/Datum/datumTags
     * @header name:Authorization require:1 desc:Token
     * @param name:datum_id type:int default:1 desc:资料系列id
     * @param name:url_id type:int default:1 desc:资料url_id
     * @return name:tags type:int default:1 desc:0取消成功，1点赞成功
     */
    public function datumTags()
    {
        $datum_id = input('post.datum_id');
        $url_id = input('post.url_id');
        $ret_val = 0;
        $check_tags =  DatumLike::where(['user_id'=>$this->user_id,'datum_id'=>$datum_id,'url_id'=>$url_id])->value('id');
        if($check_tags) {
            DatumLike::where(['user_id'=>$this->user_id,'datum_id'=>$datum_id,'url_id'=>$url_id])->delete();
        }else{
            Data::save('DatumLike',
                ['user_id'=>$this->user_id,'datum_id'=>$datum_id,'url_id'=>$url_id],'user_id',
                ['user_id'=>$this->user_id,'datum_id'=>$datum_id,'url_id'=>$url_id]);
            $ret_val = 1;
        }
        $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
    }
    
    /**
     * @title 用户提交或修改资料【个人】
     * @desc 用户提交或修改资料【个人】
     * @author qc
     * @method POST
     * @url /api/Datum/userReferDatum
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:-- desc:id(修改时必传)
     * @param name:title type:string default:-- desc:标题
     * @param name:datum_url type:string default:-- desc:资料地址
     * @param name:desc type:string default:-- desc:简介
     * @param name:label type:string default:-- desc:资料标签id(多个用逗号隔开)
     */
    public function userReferDatum()
    {
        $id = input('post.id',0);
        $title = input('post.title');
        $desc = input('post.desc');
        $datum_url = input('post.datum_url');
        $label = input('post.label');
        if(!$datum_url) $this->error('请上传资料');
        if($id){
            $check_status = UserDatum::where('id',$id)->value('status');
            if($check_status == 1) $this->error('已审核通过，不允许修改');
        }
        $data = [
            'title' => $title,
            'user_id' => $this->user_id,
            'desc' => $desc,
            'datum_url' => $datum_url,
            'label' => $label,
            'status' => 0,
            'remark' => '',
        ];
        if($id) $data['id'] =  $id;
        if($id){
            UserDatum::where('id',$id)->update($data);
        }else{
            $res= UserDatum::create($data) ;
        }
        UserMessage::sendUserMessage($this->user_id,'datum',1,0,0,$id ? $id:$res->id);
        $this->success('提交成功，请等待审核',['id'=> $id ? :$res->id]);
    }

    /**
     * @title 我的发布--其他【个人】
     * @desc 获取我的资料列表【个人】
     * @author qc
     * @method GET
     * @url /api/Datum/getMyDatumList
     * @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:desc type:string default:-- desc:简介
     * @return name:datum_url type:string default:-- desc:资料地址
     * @return name:status type:int default:-- desc:0待审核1审核通过2审核未通过
     * @return name:remark type:string default:-- desc:审核备注
     * @return name:label type:string default:-- desc:标签
     */
    public function getMyDatumList()
    {
        $sel_where  = [];
        $sel_where[]  = ['is_deleted','=',0];
        $sel_where[]  = ['user_id','=',$this->user_id];
        $title = input('get.title');
        if($title)  $sel_where[]  = ['title|label','like','%'.$title.'%'];
        $list = UserDatum::where($sel_where)
            ->field('id,title,desc,datum_url,status,remark,label')
            ->order('id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        $total_num = UserDatum::where($sel_where)->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }

    /**
     * @title 获取我的资料详情【个人】
     * @desc 获取我的资料列表【个人】
     * @author qc
     * @method GET
     * @url /api/Datum/getUserDatumDetail
     * @header name:Authorization require:1 desc:Token
     * @param  name:id type:string default:-- desc:记录id
     * @return name:title type:string default:-- desc:标题
     * @return name:desc type:string default:-- desc:简介
     * @return name:datum_url type:string default:-- desc:资料地址
     * @return name:status type:int default:-- desc:0待审核1审核通过2审核未通过
     * @return name:remark type:string default:-- desc:审核备注
     * @return name:label type:string default:-- desc:标签
     * @return name:label_name type:array default:-- desc:标签数组
     */
    public function getUserDatumDetail()
    {
        $detail =UserDatum::where('id',input('get.id'))->field('id,title,desc,datum_url,status,remark,label')->find();
        if(!$detail) $this->error('资料有误');
        $detail['label_name'] =$detail['label'] ? $detail['label_name'] = explode(',',trim($detail['label'],',')) : null;
        $this->success('ok',['detail'=>$detail->toArray()]);
    }

    /**
     * @title 用户删除资料记录【个人】
     * @desc 用户删除资料记录【个人】
     * @author qc
     * @method POST
     * @url /api/Datum/delUserDatum
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:-- desc:id
     */
    public function delUserDatum()
    {
        UserDatum::where(['user_id'=>$this->user_id,'id'=>input('post.id')])->delete();
        $this->success('删除成功');
    }


    /**
     * @title 我的下载
     * @desc 获取下载资料列表
     * @author qc
     * @method GET
     * @url /api/Datum/getDownloadDatum
     * @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:datum_id type:int default:-- desc:资料id
     * @return name:url_id type:int default:-- desc:item_id
     * @return name:is_vip type:int default:-- desc:是否vip[0否1是]
     * @return name:url type:string default:-- desc:资料路径
     * @return name:read_num type:string default:-- desc:阅读量
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     * @return name:app_name type:string default:-- desc:发布者
     * @return name:app_logo type:string default:-- desc:发布者头像
     */
    public function getDownloadDatum()
    {
        $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 = UserDownload::where($sel_where)
            ->alias('t')
            ->field('t.id,t.create_at,t.first_id datum_id,t.second_id url_id,i.read_num,i.title,i.is_vip,i.url,i.user_id')
            ->leftJoin('DatumUrl i','t.second_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['datum_id'],$v['url_id'],$this->request->controller());
            $datum_auth = DatumUrl::getDatumAuth($v['user_id'],APPNAME,APPLOGO);
            $v['app_name'] = $datum_auth['app_name'];
            $v['app_logo'] = $datum_auth['app_logo'];
        }
        $total_num = UserDownload::where($sel_where)->alias('t')->leftJoin('DatumUrl i','t.second_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/Datum/getLearnHistory
     * @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:datum_id type:int default:-- desc:资料id
     * @return name:url_id type:int default:-- desc:item_id
     * @return name:is_vip type:int default:-- desc:是否vip[0否1是]
     * @return name:read_num type:int default:-- desc:阅读量
     * @return name:url type:string default:-- desc:资料路径
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     * @return name:app_name type:string default:-- desc:发布者
     * @return name:app_logo type:string default:-- desc:发布者头像
     * @return name:is_down type:int default:-- desc:是否能下载（0否【pdf加密】1是【pdf未加密】）
     */
    public function getLearnHistory()
    {
        $sel_where  = [];
        $sel_where[]  = ['t.user_id','=',$this->user_id];
        $sel_where[]  = ['t.type','=',2];
        $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 datum_id,t.second_id url_id,i.title,i.url,i.is_vip,i.user_id,i.read_num,i.is_down')
            ->leftJoin('DatumUrl i','t.second_id = i.id')
            ->order('update_int desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        foreach ($list as &$v) {
            $v['time'] = date("Y-m-d H:i:s",$v['update_int']);
            $v['is_normal'] = CheckPower::checkModulesPower($v['datum_id'],$v['url_id'],$this->request->controller());
            $datum_auth = DatumUrl::getDatumAuth($v['user_id'],APPNAME,APPLOGO);
            $v['app_name'] = $datum_auth['app_name'];
            $v['app_logo'] = $datum_auth['app_logo'];
        }
        $total_num = UserTrack::where($sel_where)->alias('t')->leftJoin('DatumUrl i','t.second_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/Datum/getDatumCollect
     * @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:datum_id type:string default:-- desc:资料id
     * @return name:url_id type:string default:-- desc:url_id
     * @return name:url type:string default:-- desc:资料路径
     * @return name:create_at type:string default:-- desc:时间
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     * @return name:app_name type:string default:-- desc:发布者
     * @return name:app_logo type:string default:-- desc:发布者头像
     * @return name:is_down type:int default:-- desc:是否能下载（0否【pdf加密】1是【pdf未加密】）
     * @return name:switch_open type:int default:-- desc:通知开关【0关闭1开启】
     * @return name:transmit_num type:int default:-- desc:转发量
     * @return name:read_num type:int default:-- desc:阅读量
     * @return name:collect_num type:int default:-- desc:收藏量
     * @return name:down_num type:int default:-- desc:下载量
     * @return name:comment_num type:int default:-- desc:评论量
     * @return name:is_collect type:int default:-- desc:是否收藏
     * @return name:like_num type:int default:-- desc:点赞数量
     * @return name:is_like type:int default:-- desc:是否点赞（0否1是）
     */
    public function getDatumCollect()
    {
        $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','=',2];
        $list = UserCollect::where($sel_where)
            ->alias('t')
            ->field('t.id,t.create_at,t.coll_id datum_id,t.children_id url_id,i.title,i.url,i.is_vip,i.user_id,i.is_down')
            ->leftJoin('DatumUrl i','t.children_id = i.id')
            ->order('id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        array_walk($list,function (&$v){
            $v['switch_open'] =  PlatformSwitch::checkSwitch($this->user_id,$v['datum_id'],9);
            $v['is_normal'] = CheckPower::checkModulesPower($v['datum_id'],$v['url_id'],$this->request->controller());
            $datum_auth = DatumUrl::getDatumAuth($v['user_id'],APPNAME,APPLOGO);
            $v['app_name'] = $datum_auth['app_name'];
            $v['app_logo'] = $datum_auth['app_logo'];
            $v['down_num']     = numTransform($v['down_num']);
            $v['read_num']     = numTransform($v['read_num']);
            $v['transmit_num'] = numTransform($v['transmit_num']);
            $v['is_collect'] = UserCollect::checkCollectByType($this->user_id,2,$v['datum_id'],$v['url_id']);
            $v['collect_num'] = UserCollect::where(['user_id'=>$this->user_id,'coll_type'=>1,'coll_id'=>$v['datum_id'],'children_id'=>$v['url_id']])->count();
            $v['collect_num'] = numTransform($v['collect_num']);
            $v['like_num'] = DatumLike::where('url_id',$v['url_id'])->count();
            $v['like_num'] = numTransform($v['like_num']);
        });
        $total_num =UserCollect::where($sel_where)->leftJoin('DatumUrl i','t.children_id = i.id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }



    /**
     * @title 以下接口为二期需求
     * @desc  以下接口为二期需求
     * @author  qc
     * @url /api/Datum/secondPhase
     * @method
     * @return name:1 type:string default:-- desc:以下接口为二期需求
     */
    public function secondPhase(){}


    /**
     * @title 我的发布--审核成功【后台资料绑定该会员】
     * @desc 后台资料绑定该会员
     * @author qc
     * @method GET
     * @url /api/Datum/getBoundList
     * @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:id type:string default:-- desc:记录id【url_id】
     * @return name:title type:string default:-- desc:标题
     * @return name:datum_id type:string default:-- desc:资料id
     * @return name:create_at type:string default:-- desc:时间
     * @return name:url type:string default:-- desc:文件路径
     * @return name:is_vip type:int default:-- desc:是否是vip[0否1是]
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     * @return name:is_down type:int default:-- desc:是否能下载（0否【pdf加密】1是【pdf未加密】）
     */
    public function getBoundList()
    {
        $sel_where  = [];
        $title = input('get.title');
        $sel_where[] = ['user_id','=',$this->user_id];
        $sel_where[] = ['is_deleted','=',0];
        if($title)  $sel_where[]  = ['title|label','like','%'.$title.'%'];
        $list = DatumUrl::where($sel_where)
            ->alias('t')
            ->field('id,title,is_vip,url,datum_id,create_at,label,is_down')
            ->order('id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        foreach ($list as &$v) {
            $v['is_normal'] = CheckPower::checkModulesPower($v['datum_id'],$v['id'],$this->request->controller());
        }
        $total_num= DatumUrl::where($sel_where) ->alias('t')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }



    /**
     * @title 我的订阅--资料
     * @desc 我的订阅列表
     * @author qc
     * @method GET
     * @url /api/Datum/getFollowUpList
     * @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:create_at type:string default:-- desc:追更设置时间
     * @return name:datum_id type:int default:-- desc:资料id
     * @return name:title type:string default:-- desc:标题
     * @return name:recently_title type:int default:-- desc:上次观看title
     * @return name:is_deleted type:int default:-- desc:是否删除【0否1是】
     * @return name:total_sequel type:int default:-- desc:期数
     * @return name:is_deleted type:int default:-- desc:
     *
     */
    public function getFollowUpList()
    {
        $sel_where  = [];
        $sel_where[] = ['p.user_id','=',$this->user_id];
        $sel_where[] = ['p.type','=',4];
        $sel_where[] = ['p.switch_value','=',1];
        $field = 'p.id,p.switch_id as datum_id,p.create_at,a.title,a.is_deleted';
        $list  = PlatformSwitch::field($field)
            ->alias('p')->leftJoin('DatumIntro a','p.switch_id = a.id')
            ->where($sel_where)->limit($this->off_set,$this->page_num)
            ->order('p.id desc')->select()->toArray();
        array_walk($list,function ($v){
            $v['recently_title'] = UserTrack::getRecentlyTitle($this->user_id,2,$v['datum_id']);
        });
        $total_num = PlatformSwitch::field($field)->alias('p')->leftJoin('DatumIntro a','p.switch_id = a.id')->where($sel_where)->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }


    /**
     * @title 资料评论
     * @desc 资料评论
     * @author qc
     * @method POST
     * @url /api/Datum/datumComment
     * @header name:Authorization require:1 desc:Token
     * @param name:datum_id type:int default:1 desc:资料系列id
     * @param name:url_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:内容
     */
    public function datumComment()
    {
        $datum_id = input('post.datum_id');
        $url_id = input('post.url_id');
        $content = input('post.content',0);
        if(!$content) $this->error('请输入评论内容');
        $res = DatumComment::create(['user_id'=>$this->user_id,'content'=>$content,'datum_id'=>$datum_id,'url_id'=>$url_id]);
        $detail  =DatumComment::where('c.id',$res->id)
            ->alias('c')
            ->field('c.id,c.content,c.create_at,u.name,u.headimg')
            ->leftJoin('store_member u','u.id = c.user_id')
            ->find()->toArray();
        $send_user = ArticleItem::where('id',$url_id)->value('user_id');
        $user_info = $this->userInfo('name');
        if($send_user) UserMessage:: sendUserMessage($send_user,'datum',4,0,$this->user_id,$url_id,$user_info['name'].'评论了您的资料');
        $this->success('评论成功',['detail'=>$detail]);
    }


    /**
     * @title 删除评论
     * @desc 删除评论
     * @author qc
     * @method POST
     * @url /api/Datum/delComment
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:1 desc:评论id
     */
    public function delComment(){
        DatumComment::where(['id'=>input('post.id'),'user_id'=>$this->user_id])->update(['is_deleted'=>1]);
        $this->success('删除成功');
    }

    /**
     * @title 资料二级评论
     * @desc 资料二级评论
     * @author qc
     * @method POST
     * @url /api/Datum/secondCommend
     * @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:内容
     */
    public function secondCommend()
    {
        $comment = DatumComment::where('id',input('post.id'))->find()->toArray();
        $user_info = $this->userInfo('name');
        UserMessage:: sendUserMessage($comment['user_id'],'datum',3,0,$this->user_id,$comment['id'],$user_info['name'].'回复了您的评论');
        $send_user = DatumUrl::where('id',$comment['url_id'])->value('user_id');
        if($send_user) UserMessage:: sendUserMessage($send_user,'datum',4,0,$this->user_id,$comment['url_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 = DatumComment::create($comment);
        $detail  = DatumComment::where('c.id',$res->id)
            ->alias('c')->field('c.id,c.content,c.create_at,u.name,u.headimg')
            ->leftJoin('store_member u','u.id = c.user_id')->find()->toArray();
        $this->success('评论成功',['detail'=>$detail]);
    }

    /**
     * @title 资料评论列表
     * @desc 资料评论列表
     * @author qc
     * @method GET
     * @url /api/Datum/getDatumCommentList
     * @header name:Authorization require:1 desc:Token
     * @param name:url_id type:int default:-- desc:资料id
     * @param name:sort_type type:int default:1 desc:排序1最新2最热
     * @param name:page 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: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:is_top type:int default:-- desc:是否置顶（0否1是）
     * @return name:can_delete type:int default:-- desc:是否可以删除（0否1是）
     * @return name:total_num type:int default:-- desc:总评论数（仅一级）
     */
    public function getDatumCommentList()
    {
        $where = [];
        $where[] = ['c.url_id','=',input('get.url_id')];
        $where[] = ['c.is_deleted','=',0];
        $user_id = $this->user_id;
        $sort_type= input('sort_type',1);
        switch ($sort_type) {
            case 1:
                $order =  ['is_top'=>'desc','id'=>'desc'];
                break;
            default:
                $order =  ['is_top'=>'desc','like_times'=>'desc'];
                break;
        }
        $list  =DatumComment::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 = DatumComment::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;
            $val['like_num'] = DatumCommentLike::where('like_id',$val['id'])->count();
            $val['like_num'] = numTransform($val['like_num']);
            $val['is_like'] =  DatumCommentLike::where(['like_id'=>$val['id'],'user_id'=>$user_id])->count();
            $parent  = DatumComment::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;
            $val['can_delete']  = $val['user_id'] == $this->user_id ? 1 :0;
        });
        $total_num  = DatumComment::where($where)->alias('c')->count();
        $this->success('ok',['list'=>$list,'total_num'=>numTransform($total_num),'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }


    /**
     * @title 批量删除||批量取消
     * @desc 删除||取消
     * @author qc
     * @method POST
     * @url /api/Datum/batchesDel
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:int default:1 desc:记录id【多个用逗号隔开=>'1,2'】
     * @param name:type type:string default:1 desc:消息类型【1我的评论,2评论我的,3我的回复,4我的已购,5用户资料删除,6订阅记录,7订阅消息,8我的点赞-资料,9我的点赞-评论,10回复我的,11点赞我的--资料，12点赞我的--评论，13我的收藏，14我的下载，】
     */

    public function batchesDel(){
        $type = input('post.type',1);
        $del_where = [];
        $del_where[] = ['id','in',input('post.id')];
        if(in_array($type,[1,3,4,5,6,7,8,9,13,14]))   $del_where[] = ['user_id','=',$this->user_id];
        if(in_array($type,[1,2,3,10])) DatumComment::where($del_where)->update(['is_deleted'=>1]);
        if(in_array($type,[4]))  UserLearn::where($del_where)->update(['is_deleted'=>1]);
        if(in_array($type,[5]))  UserDatum::where($del_where)->update(['is_deleted'=>1]);
        if(in_array($type,[6]))  UserLearn::where($del_where)->update(['is_deleted'=>1]);
        if(in_array($type,[7]))  UserMessage::where($del_where)->update(['is_deleted'=>1]);
        if(in_array($type,[8,11]))  DatumLike::where($del_where)->delete();
        if(in_array($type,[9,12]))  DatumCommentLike::where($del_where)->delete();
        if(in_array($type,[13]))  UserCollect::where($del_where)->delete();
        if(in_array($type,[14]))  UserDownload::where($del_where)->delete();
        $this->success('删除成功');
    }



    /**
     * @title 评论点赞||取消点赞
     * @desc 评论
     * @author qc
     * @method POST
     * @url /api/Datum/commentTags
     * @header name:Authorization require:1 desc:Token
     * @param name:comment_id type:int default:1 desc:评论记录id
     * @return name:tags type:int default:1 desc:0取消成功，1点赞成功
     */
    public function commentTags()
    {
        $comment_id = input('post.comment_id');
        $ret_val = 0;
        $check_tags =  DatumCommentLike::where(['user_id'=>$this->user_id,'like_id'=>$comment_id])->value('id');
        if($check_tags) {
            DatumCommentLike::where(['user_id'=>$this->user_id,'like_id'=>$comment_id])->delete();
            // ArticleItem::where('id',$comment_id)->setDec('like_times');
        }else{
            Data::save('DatumCommentLike',
                ['user_id'=>$this->user_id,'like_id'=>$comment_id,],'user_id',
                ['user_id'=>$this->user_id,'like_id'=>$comment_id]);
            $ret_val = 1;
            //  ArticleItem::where('id',$comment_id)->setInc('like_times');
        }
        $this->success($ret_val == 1 ?'点赞成功':'取消成功',['tags'=>$ret_val]);
    }





    /**
     * @title 我的订阅---消息
     * @desc 订阅消息
     * @author qc
     * @method GET
     * @url /api/Datum/getFollowUpMessage
     * @header name:Authorization require:1 desc:Token

     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数
     *
     * @return name:id type:int default:-- desc:记录id
     * @return name:title type:string default:-- desc:标题
     * @return name:content type:string default:-- desc:内容
     * @return name:create_at type:string default:-- desc:时间
     * @return name:is_read type:int default:-- desc:是否已读【0否1是】
     * @return name:datum_title type:string default:-- desc:系列标题
     */
    public function getFollowUpMessage()
    {
        $list = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'datum','m.type_id'=>5])
            ->alias('m')->field('m.id,v.create_at,m.is_read,m.content,m.relation_id datum_id,m.module,v.title datum_title')
            ->leftJoin('DatumIntro v','v.id= m.relation_id')
            ->limit($this->off_set,$this->page_num)
            ->order(['m.id'=>'desc'])
            ->select()->toArray();
        $total_num = UserMessage::where(['m.user_id'=>$this->user_id,'m.is_deleted'=>0,'m.module'=>'datum','m.type_id'=>5])
            ->alias('m')->leftJoin('DatumIntro v','v.id= m.relation_id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }



    /**
     * @title 获取角标数量
     * @desc 获取角标数量
     * @author qc
     * @method GET
     * @url /api/Datum/getMarkNum
     * @header name:Authorization require:1 desc:Token
     * @return name:reply_num type:int default:-- desc:未读量--回复我的
     * @return name:comment_num type:int default:-- desc:未读量--评论我的
     * @return name:praise_num type:int default:-- desc:点赞我的【包含视频点赞和评论点赞】
     * @return name:datum_praise_num type:int default:-- desc:-视频点赞
     * @return name:comment_praise_num type:int default:-- desc:评论点赞
     * @return name:follow_num type:int default:-- desc:订阅
     */
    public function getMarkNum()
    {
        // 评论我的
        $comment_num = DatumComment::where([['t.is_deleted','=',0],['i.user_id','=',$this->user_id],['is_read','=',0]])
            ->leftJoin('DatumUrl i','t.datum_id = i.id')
            ->alias('t')->count();
        // 回复我的
        $all_comment = DatumComment::where(['user_id'=>$this->user_id,'is_deleted'=>0])->column('id');
        $reply_num =  DatumComment::where([['t.is_deleted','=',0],['t.lev','>=',2],['is_read','=',0],['t.pid','in',implode(',',$all_comment)]])->alias('t')->count();
        // 点赞我的
        $all_datum = DatumUrl::where('user_id',$this->user_id)->where('is_deleted',0)->column('id');

        $datum_praise_num = DatumCommentLike::where([['is_read','=',0],['like_id','in',$all_datum]])->count();
        $comment_praise_num = DatumLike::where([['is_read','=',0],['datum_id','in',$all_comment]])->count();
        $praise_num =  $datum_praise_num + $comment_praise_num;
        $follow_num = UserMessage::getUnreadNum($this->user_id,'datum',5);
        $this->success('ok',compact(['reply_num','comment_num','praise_num','datum_praise_num','comment_praise_num','follow_num']));
    }



    /**
     * @title 点赞我的--评论
     * @desc 点赞我的--评论
     * @author qc
     * @method GET
     * @url /api/Datum/praiseMyComment
     * @header name:Authorization require:1 desc:Token

     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数
     *
     * @return name:id type:int default:-- desc:记录id
     * @return name:title type:string default:-- desc:标题
     * @return name:create_at type:string default:-- desc:时间
     * @return name:read_num type:int default:-- desc:播放量
     * @return name:user_name type:string default:-- desc:会员名称
     * @return name:headimg type:string default:-- desc:会员头像
     * @return name:url type:string default:-- desc:文件路径
     */
    public function praiseMyComment()
    {
        $user_info = $this->userInfo('name,headimg');
        $list =  DatumCommentLike::where([['c.user_id','=',$this->user_id]])
            ->alias('l')
            ->field('l.id,l.user_id,m.name user_name,m.headimg,l.create_at,v.url,v.title,v.read_num')
            ->leftJoin('StoreMember m','m.id  = l.user_id')
            ->leftJoin('DatumComment c','c.id  = l.like_id')
            ->join('DatumUrl v','v.id  = c.url_id')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        array_walk($list,function (&$v,$k)use ($user_info){
            $v['app_name']  = $user_info['name'] ;
            $v['app_logo']  = $user_info['headimg'];
            $v['read_num']  = numTransform($v['read_num']);
        });
        $total_num =   DatumCommentLike::where([['c.user_id','=',$this->user_id]])
            ->alias('l')->leftJoin('StoreMember m','m.id  = l.user_id')
                ->leftJoin('DatumComment c','c.id  = l.like_id')
                ->join('DatumUrl v','v.id  = c.url_id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }


    /**
     * @title 点赞我的--资料
     * @desc 点赞我的--资料
     * @author qc
     * @method GET
     * @url /api/Datum/praiseMyDatumList
     * @header name:Authorization require:1 desc:Token

     * @param name:page type:int default:-- desc:页数
     * @param name:page_num type:int default:-- desc:每页数
     *
     * @return name:id type:int default:-- desc:记录id
     * @return name:title type:string default:-- desc:标题
     * @return name:create_at type:string default:-- desc:时间
     * @return name:read_num type:int default:-- desc:阅读量
     * @return name:user_name type:string default:-- desc:会员名称
     * @return name:headimg type:string default:-- desc:会员头像
     * @return name:url type:string default:-- desc:文件路径
     */
    public function praiseMyDatumList()
    {
        $all_list = DatumUrl::where('user_id',$this->user_id)->where('is_deleted',0)->column('id');
        $user_info = $this->userInfo('name,headimg');
        $list =  DatumLike::where([['url_id','in',$all_list]])
            ->alias('l')
            ->field('l.id,l.user_id,m.name user_name,m.headimg,l.create_at,v.url,v.title,v.read_num')
            ->leftJoin('StoreMember m','m.id  = l.user_id')
            ->join('DatumUrl v','v.id  = l.url_id')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        array_walk($list,function (&$v,$k)use ($user_info){
            $v['app_name']  = $user_info['name'] ;
            $v['app_logo']  = $user_info['headimg'];
            $v['read_num']  = numTransform($v['read_num']);
        });
        $total_num = DatumLike::where([['url_id','in',$all_list]])
            ->alias('l')
            ->leftJoin('StoreMember m','m.id  = l.user_id')
            ->join('DatumUrl v','v.id  = l.url_id')
            ->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }




    /**
     * @title 回复我的【回复我的--回复过我的评论】
     * @desc 回复我的
     * @author qc
     * @method GET
     * @url /api/Datum/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:datum_id type:string default:-- desc:资料系列id
     * @return name:url_id type:string default:-- desc:资料id
     * @return name:url 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:is_deleted type:int default:-- desc:0未删除
     *
     * @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.datum_id type:string default:-- desc:资料系列id
     * @return name:parent_comment.url_id type:string default:-- desc:资料id
     * @return name:parent_comment.is_deleted type:int default:-- desc:0未删除
     */
    public function getReplyComment()
    {
        $all_comment = DatumComment::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 = DatumComment::where($sel_where)
            ->alias('t')
            ->field('t.id,t.is_read,t.datum_id,t.is_top,t.is_deleted,t.url_id,t.create_at,t.lev,t.content,t.pid,u.name user_name,u.headimg,i.url')
            ->leftJoin('store_member u','t.user_id = u.id')
            ->leftJoin('DatumUrl i','t.url_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['is_normal'] = CheckPower::checkModulesPower($v['datum_id'],$v['datum_id'],$this->request->controller());
            $parent_comment = DatumComment::where([['t.id','=',$v['pid']]])
                ->field('t.id,t.datum_id,t.is_top,t.url_id,t.content,i.title,i.url,t.pid,u.name,t.is_deleted')
                ->alias('t')
                ->leftJoin('DatumUrl i','t.url_id = i.id')
                ->leftJoin('store_member u','t.user_id = u.id')
                ->find()->toArray();
            $v['parent_comment'] = $parent_comment;
        }
        $total_num = DatumComment::where($sel_where)->alias('t')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);
    }


    /**
     * @title 评论我的【学习服务--评论我的】
     * @desc 评论我的
     * @author qc
     * @method GET
     * @url /api/Datum/commentMyDatum
     * @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:datum_id type:string default:-- desc:资料系列id
     * @return name:url_id type:string default:-- desc:资料id
     * @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:url type:string default:-- desc:资料路径
     * @return name:user_name type:string default:-- desc:用户名
     * @return name:headimg type:string default:-- desc:用户头像
     * @return name:read_num type:int default:-- desc:阅读量
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     * @return name:app_name type:string default:-- desc:发布者
     * @return name:app_logo type:string default:-- desc:发布者头像
     */
    public function commentMyDatum()
    {
        $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 = DatumComment::where($sel_where)->alias('t')
            ->field('t.id,t.is_read,t.is_top,t.create_at,i.read_num,t.datum_id,t.url_id,t.lev,t.content,i.title,i.url,u.name user_name,u.headimg')
            ->leftJoin('DatumUrl i','t.url_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();
        $user_info = $this->userInfo('name,headimg');
        array_walk($list,function (&$v)use ($user_info){
            $v['is_normal'] = CheckPower::checkModulesPower($v['datum_id'],$v['url_id'],$this->request->controller());
            $v['read_num'] =  numTransform($v['read_num']);
            $v['app_name'] = $user_info['name'];
            $v['app_log'] = $user_info['headimg'];
        });
        $total_num= DatumComment::where($sel_where)->alias('t')  ->leftJoin('DatumUrl i','t.url_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 POST
     * @url /api/Datum/unreadChange
     * @header name:Authorization require:1 desc:Token
     * @param name:id type:string default:-- desc:记录id（多个逗号隔开）
     * @param name:type type:string default:1 desc:消息类型【1评论我的，2回复我的,3订阅消息】
     * @param name:is_read type:int default:1 desc:变更类型【0消息变更为未读，1变更为已读】
     *
     */
    public function unreadChange()
    {
        $type = input('post.type',1);
        switch ($type) {
            case 3:
                UserMessage::where('id','in',input('post.id'))->update(['is_read'=>input('post.is_read')]);
                break;
            default :
                DatumComment::where('id','in',input('post.id'))->update(['is_read'=>input('post.is_read')]);
                break;
        }
        $this->success('消息变更成功');
    }


    /**
     * @title 我的点赞--资料
     * @desc 我的点赞
     * @author qc
     * @method GET
     * @url /api/Datum/getTagsDatum
     * @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:datum_id type:string default:-- desc:系列id
     * @return name:url_id type:string default:-- desc:资料id
     * @return name:like_num type:string default:-- desc:点赞量
     * @return name:is_like type:string default:-- desc:是否点赞[0否1是]
     * @return name:url type:string default:-- desc:文件路径
     * @return name:is_vip type:int default:-- desc:是否vip[0否1是]
     * @return name:create_at type:string default:-- desc:时间
     * @return name:read_num type:int default:-- desc:阅读量
     * @return name:switch_open type:int default:-- desc:通知开关【0关闭1开启】
     * @return name:app_name type:string default:-- desc:发布方名称
     * @return name:app_logo type:string default:-- desc:发布方头像
     * @return name:is_normal type:int default:-- desc:是否是正常记录（0已删除或是已禁用1可以正常跳转详情）
     *
     * @return name:transmit_num type:int default:-- desc:转发量
     * @return name:comment_num type:int default:-- desc:评论量

     * @return name:is_collect type:int default:-- desc:是否收藏
     * @return name:collect_num type:int default:-- desc:收藏量
     */
    public function getTagsDatum()
    {
        $sel_where  = [];
        $title = input('get.title');
        if($title)  $sel_where[]  = ['i.title|i.label','like','%'.$title.'%'];
        $sel_where[]  = ['t.user_id','=',$this->user_id];
        $list = DatumLike::where($sel_where)
            ->alias('t')
            ->field('t.id,t.create_at,t.datum_id,t.url_id,i.title,i.url,i.is_vip,i.read_num,i.user_id,i.transmit_num')
            ->leftJoin('DatumUrl i','t.url_id = i.id')
            ->order('id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        foreach ($list as &$v) {
            $v['switch_open'] =  PlatformSwitch::checkSwitch($this->user_id,$v['datum_id'],9);
            $v['like_num'] = DatumLike::where(['datum_id'=>$v['datum_id'],'url_id'=>$v['url_id']])->count();
            $v['like_num'] = numTransform($v['like_num']);
            $v['read_num'] = numTransform($v['read_num']);
            $v['is_like'] = DatumLike::where(['user_id'=>$this->user_id,'datum_id'=>$v['datum_id'],'url_id'=>$v['url_id']])->count();
            $v['is_normal'] = CheckPower::checkModulesPower($v['datum_id'],$v['url_id'],$this->request->controller());
            $article_auth = ArticleItem::getArticleAuth($v['user_id'],APPNAME,APPLOGO);
            $v['app_name'] = $article_auth['app_name'];
            $v['app_logo'] = $article_auth['app_logo'];
            $v['is_collect'] =  UserCollect::checkCollectByType($this->user_id,2,$v['datum_id'],$v['url_id']);
            $v['collect_num'] =  UserCollect::getCollectNum(3,$v['datum_id'],$v['url_id']);
            $v['comment_num'] = DatumComment::getDatumCommentNum($v['url_id']);
        }
        $total_num = DatumLike::where($sel_where)->alias('t')->leftJoin('DatumUrl i','t.url_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/Datum/getTagsComment
     * @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:create_at type:string default:-- desc:时间
     * @return name:user_name type:string default:-- desc:会员名称
     * @return name:headimg type:string default:-- desc:会员头像
     * @return name:content type:string default:-- desc:评论内容
     * @return name:url type:string default:-- desc:资料url
     * @return name:title type:string default:-- desc:标题
     * @return name:read_num type:string default:-- desc:阅读量
     * @return name:app_name type:string default:-- desc:发布者
     * @return name:app_logo type:string default:-- desc:发布者头像
     */
    public function getTagsComment()
    {
        $list = DatumCommentLike::field('l.*,i.read_num,c.content,i.read_num,i.title,i.url,u.name user_name,u.headimg,i.user_id buid')
            ->alias('l')
            ->where(['l.user_id'=>$this->user_id,'l.type'=>1])
            ->leftJoin('DatumComment c','l.like_id = c.id')
            ->leftJoin('DatumUrl i','i.id = c.url_id')
            ->leftJoin('store_member u','u.id = c.user_id')
            ->order('l.id desc')
            ->limit($this->off_set,$this->page_num)
            ->select()->toArray();
        array_walk($list,function (&$v){
            $article_auth = ArticleItem::getArticleAuth($v['buid'],APPNAME,APPLOGO);
            $v['app_name'] = $article_auth['app_name'];
            $v['app_logo'] = $article_auth['app_logo'];
        });
        $total_num =DatumCommentLike::where(['l.user_id'=>$this->user_id,'l.type'=>1])
            ->alias('l')
            ->leftJoin('DatumComment c','l.like_id = c.id')
            ->leftJoin('DatumUrl i','i.id = c.url_id')
            ->leftJoin('store_member u','u.id = c.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/Datum/getReplyDatum
     * @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:datum_id type:string default:-- desc:系列id
     * @return name:url_id type:string default:-- desc:资料url_id
     * @return name:url type:string 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.datum_id type:string default:-- desc:系列id
     * @return name:parent_comment.url_id type:string default:-- desc:url_id
     */
    public function getReplyDatum()
    {
        $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 = DatumComment::where($sel_where)
            ->alias('t')
            ->field('t.id,t.datum_id,t.is_top,t.url_id,t.create_at,t.lev,t.content,i.title,t.pid,i.url')
            ->leftJoin('DatumUrl i','t.url_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['user_name'] = $user_info['name'];
            $v['headimg'] = $user_info['headimg'];
            $v['is_normal'] = CheckPower::checkModulesPower($v['datum_id'],$v['url_id'],$this->request->controller());
            $parent_comment = DatumComment::where([['t.id','=',$v['pid']]])
                ->field('t.id,t.datum_id,t.is_top,t.url_id,t.content,i.title,i.url,t.pid,u.name')
                ->alias('t')
                ->leftJoin('DatumUrl i','t.url_id = i.id')
                ->leftJoin('store_member u','t.user_id = u.id')
                ->find()->toArray();
            $v['parent_comment'] = $parent_comment;
        }
        $total_num = DatumComment::where($sel_where)->alias('t')->leftJoin('DatumUrl i','t.url_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/Datum/getCommentDatum
     * @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:datum_id type:string default:-- desc:系列id
     * @return name:url_id type:string default:-- desc:资料url_id
     * @return name:url type:string default:-- desc:路径
     * @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 getCommentDatum()
    {
        $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','=',1];
        $list = DatumComment::where($sel_where)
            ->alias('t')
            ->field('t.id,t.create_at,t.datum_id,t.url_id,t.is_top,t.lev,t.content,i.title,i.url,i.read_num')
            ->leftJoin('DatumUrl i','t.url_id = i.id')
            ->order('t.is_top desc,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['is_normal'] = CheckPower::checkModulesPower($v['datum_id'],$v['url_id'],$this->request->controller());
        }
        $total_num =  DatumComment::where($sel_where)->alias('t') ->leftJoin('DatumUrl i','t.url_id = i.id')->count();
        $this->success('ok',['list'=>$list,'total_count'=>$total_num,'page_num'=>$this->page_num]);

    }

}