<?php

namespace app\api\controller;

use app\common\controller\Api;
use think\Db;
use fast\Tree;
/**
 * 首页接口
 */
class Index extends Api
{
    protected $noNeedLogin = ['*'];
    protected $noNeedRight = ['*'];

    /**
     * @ApiTitle    (APP启动页)
     * @ApiSummary  (APP启动页)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/index/flash)
     *
     * @ApiReturn({
    "code": 1,
    "msg": "成功",
    "time": "1571492001",
    "data": {
    "image": //启动页图片,
    }
    })
     */
    public function flash()
    {
        $qiniu = get_addon_config('qiniu')['cdnurl'];
        $data = Db::name('flash')->where('id',1)->field('image')->find();
        $data['image'] = $qiniu.$data['image'];
        $this->success('success',$data);

    }

    /**
     * @ApiTitle    (未读消息数量)
     * @ApiSummary  (未读消息数量)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/index/noread_num)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     *
     * @ApiReturn({
    "code": 1,
    "msg": "成功",
    "time": "1571492001",
    "data": {
    "num": //未读数量,
    }
    })
     */
    public function noread_num()
    {
        $user_id = $this->auth->id;
        $data = Db::name('message')
            ->where('user_id',$user_id)
            ->where('is_read',0)
            ->count();
        $ban = Db::name('read')->where('user_id',$user_id)->find();
        if(empty($ban)){
            $info['num'] = $data + 1;
        }else{
            $info['num'] = $data;
        }
        $this->success('success',$info);

    }


    /**
     * @ApiTitle    (我的文件夹)
     * @ApiSummary  (我的文件夹)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/index/index)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="is_up", type="inter", required=false, description="是否上架 为空是全部1已上架2已下架")
     * @ApiParams   (name="keyword", type="string", required=false, description="关键字")
     *
     * @ApiReturn({
    "code": 1,
    "msg": "成功",
    "time": "1571492001",
    "data": {
    "times": //时间,
    "info": [
    {
        "id":           //文件夹id,
        "url":          //分享地址
        "user_id":      //用户id,
        "folder_name":  //文件夹名称,
        "is_open":      //是否公开1公开2私密
        "is_up":        //1上架2下架
        "createtime":   //日期,
        "is_have":   //是否有转存文件1有2没有
        "nowtime":   //文件创建时间
    }
    ]
    }
    })
     */
    public function index()
    {
        $user_id = $this->auth->id;
        $is_up = $this->request->param('is_up');

        $keyword = $this->request->param('keyword');
        if(!empty($keyword)){
            $where['folder_name'] = ['like',"%$keyword%"];
        }

        //判断是否为全部还是 已上架/已下架
        if(!empty($is_up)){
            $where['is_up'] = ['eq',$is_up];
        }else{
            $where = true;
        }


        $data = Db::name('folder')
            ->field('updatetime,pid',true)
            ->where('user_id',$user_id)
            ->where('pid',0)
            ->where($where)
            ->order('is_up asc')
            ->select();
        $tree = Tree::instance();
        $tree->init(Db::name('folder')->select(), 'pid');
        foreach ($data as &$v){
            $list = $tree->getChildrenIds($v['id'],true);
            $is_have = Db::name('rotor')
                ->where('user_id',$user_id)
                ->whereIn('folder_id',$list)
                ->find();
            if(empty($is_have)){
                $v['is_have'] = 2;
            }else{
                $v['is_have'] = 1;
            }
            $v['nowtime'] = date('Y-m-d',$v['createtime']);
            $v['createtime'] = date('m-d',$v['createtime']);
        }
        $times = array_values(array_unique(array_column($data,'createtime')));
        rsort($times);
        //将数据放到对应的时间分段
        $arrs = [];
        foreach ($times as $t_k=> $t_v){
            $arrs[$t_k]['times'] = $t_v;
            $k = 0;
            foreach ($data as $value){
                $k+=0;
                if($t_v == $value['createtime']){
                    $arrs[$t_k]['info'][$k] = $value;
                    $k++;
                }
            }
        }
        $this->success('success',$arrs);
    }

    /**
     * @ApiTitle    (首页其他文件)
     * @ApiSummary  (首页其他文件)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/index/folderlist)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="is_up", type="inter", required=false, description="是否上架 为空是全部1已上架2已下架")
     * @ApiParams   (name="keyword", type="string", required=false, description="关键词")
     * @ApiParams   (name="fenlei", type="inter", required=true, description="分类id  为空或者0是全部 笔记1 图片2 视频3")
     *
     * @ApiReturn({
    "code": 1,
    "msg": "成功",
    "time": "1571492001",
    "data": {
    "note": [
    {
    "times": //时间,
    "info": [
    {
        "id": //文件id,
        "user_id": //用户id,
        "type": //类型1笔记2图片3视频,
        "name": //文件名称,
        "share_url": //文件分享地址,
        "images": //图片地址,
        "video": //视频地址,
        "content": //笔记内容,
        "is_open": //是否公开1公开2私密,
        "is_up": //是否上架 1上架2下架,
        "createtime": //创建时间,
        "is_white": //是否白名单 1是2否,
        "is_real": //是否是自己的 1是2否,
        "is_zhuan": //是否是转存的 1是2否,
        "nowtime": //时间,
        "video_image": //视频首帧图
    }
    ]
    }
    ],
    }
    })
     */
    public function folderlist()
    {
        $user_id = $this->auth->id;

        $keyword = $this->request->param('keyword');
        //判断是否有关键字搜索
        if(!empty($keyword)){
            $where['name'] = ['like',"%$keyword%"];
            $tiao['b.name'] = ['like',"%$keyword%"];
            $history = Db::name('keyword')->where('user_id',$user_id)->where('keyword',$keyword)->find();
            if(empty($history)){
                //添加历史记录表
                $tiao['b.name'] = ['like',"%$keyword%"];
                $key['user_id'] = $user_id;
                $key['keyword'] = $keyword;
                $key['createtime'] = time();
                $key['updatetime'] = time();
                Db::name('keyword')->insertGetId($key);
            }
        }

        $is_up = $this->request->param('is_up');
        //判断是否为全部还是 已上架/已下架
        if(!empty($is_up)){
            //已上架
            if($is_up == 1){
                $where['is_up'] = ['eq',1];
                $tiao['b.is_up'] = ['eq',1];
            }
            //已下架
            if($is_up == 2){
               $where['is_up'] = ['eq',2];
               $tiao['b.is_up'] = [['neq',1],['neq',2]];
            }
        }else{
            $tiao['b.is_up'] = ['eq',1];
        }

        $where['user_id'] = $user_id;
        $where['folder_id'] = 0;

        $tiao['a.folder_id'] = 0;
        $tiao['a.user_id'] = $user_id;

        //判断分类 1笔记2图片3视频
        $fenlei = $this->request->param('fenlei');
        if($fenlei == 1){
            $note = $this->myfile(1,$where);
            $rotor = $this->zhuan(1,$tiao);
            $arr = $this->gong(1,$note,$rotor);
            $Info['note'] = $this->sundry($arr);
            $this->success('success',$Info);
        }elseif ($fenlei == 2){
            $pic = $this->myfile(2,$where);
            $rotor_pic = $this->zhuan(2,$tiao);
            $arr_pic = $this->gong(2,$pic,$rotor_pic);
            $Info['pic'] = $this->sundry($arr_pic);
            $this->success('success',$Info);
        }elseif ($fenlei == 3){
            $video = $this->myfile(3,$where);
            $rotor_video = $this->zhuan(3,$tiao);
            $arr_video = $this->gong(3,$video,$rotor_video);
            $Info['video'] = $this->sundry($arr_video);
            $this->success('success',$Info);
        }

        //自己的笔记文件
        $note = $this->myfile(1,$where);
        //自己的图片文件
        $pic = $this->myfile(2,$where);
        //自己的视频文件
        $video = $this->myfile(3,$where);

        //转存的笔记文件
        $rotor = $this->zhuan(1,$tiao);
        //转存的图片文件
        $rotor_pic = $this->zhuan(2,$tiao);
        //转存的视频文件
        $rotor_video = $this->zhuan(3,$tiao);

        //笔记
        $arr = $this->gong(1,$note,$rotor);
        //图片
        $arr_pic = $this->gong(2,$pic,$rotor_pic);
        //视频
        $arr_video = $this->gong(3,$video,$rotor_video);


        $Info['note'] = $this->sundry($arr);
        $Info['pic'] = $this->sundry($arr_pic);
        $Info['video'] = $this->sundry($arr_video);
        $this->success('success',$Info);
    }

    /**
     * @ApiTitle    (他人主页)
     * @ApiSummary  (他人主页)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/index/other)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="user_id", type="inter", required=true, description="他人用户id")
     *
     * @ApiReturn({
    "code": 1,
    "msg": "成功",
    "time": "1571492001",
    "data": {
    "is_ding"://是否订阅 1已订阅2未订阅
    "avatar"://他人头像
    "username"://昵称
    "is_real": //是否本人打开1是2否,
    "url"://分享地址
    "folder": [
    {
    "id":           //文件夹id,
    "user_id":      //用户id,
    "folder_name":  //文件夹名称,
    "is_open":      //是否公开1公开2私密
    "is_up":        //1上架2下架
    "createtime":   //日期,
    "is_have":   //是否有转存文件1有2没有
    "nowtime":   //文件创建时间
    }
    ],
    "other": {
    "oneself": [
    {
    "id": //文件id,
    "user_id": //用户id,
    "type": //文件类型1笔记2图片3视频,
    "name": //文件名称,
    "images": //图片地址,
    "video": //视频地址,
    "content": //笔记内容,
    "is_open": //是否公开1公开2私密,
    "is_up": //是否上架1上架2下架,
    "createtime": //创建时间
    }
    ],
    "dump": [
    {
    "id": //转存记录id,
    "dump_user_id": //转存人id,
    "savemes_id": //文件名称,
    "createtime": //创建时间,
    "type": //类型1笔记2图片3视频,
    "name": //文件名,
    "images": //图片地址,
    "video": //视频地址,
    "content": //笔记内容,
    "is_open": //是否公开1公开2私密,
    "is_up": //是否上架1上架2下架
    }
    ]
    }
    })
     */
    public function other()
    {
        $uid = $this->auth->id;
        $qiniu = get_addon_config('qiniu')['cdnurl'];
        $user_id = $this->request->param('user_id');
        if(empty($user_id)){
            $this->error('缺少必要参数');
        }

        //文件夹
        $data = Db::name('folder')
            ->field('updatetime,pid',true)
            ->where('user_id',$user_id)
            ->where('pid',0)
            ->where('is_up',1)
            ->order('is_up asc')
            ->select();
        $tree = Tree::instance();
        $tree->init(Db::name('folder')->select(), 'pid');
        foreach ($data as &$v){

            $user_info = Db::name('user')->where('id',$v['user_id'])->find();


            //查询白名单
            if(!empty($user_info['whiteip_ids'])){
                $user_info['whiteip_ids'] = explode(',',$user_info['whiteip_ids']);
                if($v['user_id'] == $uid || in_array($uid,$user_info['whiteip_ids'])){
                    $v['is_white'] = 1;
                }else{
                    $v['is_white'] = 2;
                }
            }else{
                $v['is_white'] = 2;
            }


            $v['url'] = request()->domain().'/index/index/filedetail/user_id/'.$v['user_id'].'/file_id/'.$v['id'];
            $list = $tree->getChildrenIds($v['id'],true);
            $is_have = Db::name('rotor')
                ->where('user_id',$user_id)
                ->whereIn('folder_id',$list)
                ->find();
            if(empty($is_have)){
                $v['is_have'] = 2;
            }else{
                $v['is_have'] = 1;
            }
            $v['nowtime'] = date('Y-m-d',$v['createtime']);
            $v['createtime'] = date('m-d',$v['createtime']);
        }
        $times = array_values(array_unique(array_column($data,'createtime')));
        rsort($times);
        //将数据放到对应的时间分段
        $arrs = [];
        foreach ($times as $t_k=> $t_v){
            $arrs[$t_k]['times'] = $t_v;
            $k = 0;
            foreach ($data as $value){
                $k+=0;
                if($t_v == $value['createtime']){
                    $arrs[$t_k]['info'][$k] = $value;
                    $k++;
                }
            }
        }

        $where['is_up'] = 1;
        $where['user_id'] = $user_id;
        $where['folder_id'] = 0;

        $tiao['b.is_up'] = 1;
        $tiao['a.folder_id'] = 0;
        $tiao['a.user_id'] = $user_id;

        //自己的笔记文件
        $note = $this->myfile(1,$where);

        foreach ($note as &$v){
            $user_info = Db::name('user')->where('id',$v['user_id'])->find();


            //查询白名单
            if(!empty($user_info['whiteip_ids'])){
                $user_info['whiteip_ids'] = explode(',',$user_info['whiteip_ids']);
                if($v['user_id'] == $uid || in_array($uid,$user_info['whiteip_ids'])){
                    $v['is_white'] = 1;
                }else{
                    $v['is_white'] = 2;
                }
            }else{
                $v['is_white'] = 2;
            }
        }

        //自己的图片文件
        $pic = $this->myfile(2,$where);
        foreach ($pic as &$v){
            $user_info = Db::name('user')->where('id',$v['user_id'])->find();
            if($v['user_id'] == $uid){
                $v['is_white'] = 1;
            }else{
                if(empty($user_info['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $whiteip_ids = explode(',',$user_info['whiteip_ids']);
                    if(in_array($uid,$whiteip_ids)){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }
        }
        //自己的视频文件
        $video = $this->myfile(3,$where);
        foreach ($video as &$v){
            $user_info = Db::name('user')->where('id',$v['user_id'])->find();
            if($v['user_id'] == $uid){
                $v['is_white'] = 1;
            }else{
                if(empty($user_info['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $whiteip_ids = explode(',',$user_info['whiteip_ids']);
                    if(in_array($uid,$whiteip_ids)){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }
        }


        //转存的笔记文件
        $rotor = $this->zhuan(1,$tiao);
        foreach ($rotor as &$v){
            $user_info = Db::name('user')->where('id',$v['user_id'])->find();
            if($v['user_id'] == $uid){
                $v['is_white'] = 1;
            }else{
                if(empty($user_info['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $whiteip_ids = explode(',',$user_info['whiteip_ids']);
                    if(in_array($uid,$whiteip_ids)){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }
        }
        //转存的图片文件
        $rotor_pic = $this->zhuan(2,$tiao);
        foreach ($rotor_pic as &$v){
            $user_info = Db::name('user')->where('id',$v['user_id'])->find();
            if($v['user_id'] == $uid){
                $v['is_white'] = 1;
            }else{
                if(empty($user_info['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $whiteip_ids = explode(',',$user_info['whiteip_ids']);
                    if(in_array($uid,$whiteip_ids)){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }
        }
        //转存的视频文件
        $rotor_video = $this->zhuan(3,$tiao);
        foreach ($rotor_video as &$v){
            $user_info = Db::name('user')->where('id',$v['user_id'])->find();
            if($v['user_id'] == $uid){
                $v['is_white'] = 1;
            }else{
                if(empty($user_info['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $whiteip_ids = explode(',',$user_info['whiteip_ids']);
                    if(in_array($uid,$whiteip_ids)){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }
        }
        //笔记
        $arr = $this->gong(1,$note,$rotor);
        //图片
        $arr_pic = $this->gong(2,$pic,$rotor_pic);
        //视频
        $arr_video = $this->gong(3,$video,$rotor_video);

       $user_info = Db::name('user')->where('id',$user_id)->find();
        $Info['username'] = $user_info['username'];
        if(empty($user_info['avatar'])){
            $Info['avatar'] = '';
        }else{
            $Info['avatar'] = $qiniu.$user_info['avatar'];
        }

        //查看用户是否订阅过该用户
        $is_ding = Db::name('subscribe')->where('user_id',$uid)->where('to_user_id',$user_id)->find();
        if(empty($is_ding)){
            $Info['is_ding'] = 2;
        }else{
            $Info['is_ding'] = 1;
        }




        $Info['foleder'] = $arrs;
        $Info['note'] = $this->sundry($arr);
        $Info['pic'] = $this->sundry($arr_pic);
        $Info['video'] = $this->sundry($arr_video);
        $this->success('success',$Info);

    }



    //通过传入类型获取我自己的不同文件
    public function myfile($type,$where){
        $data = Db::name('savemes')
            ->where($where)
            ->where('type',$type)
            ->field('id,user_id,type,name,share_url,images,video,content,is_open,is_up,createtime')
            ->order('createtime desc')
            ->select();
        foreach ($data as &$v){
            $v['is_white'] = 1;
            $v['is_real'] = 1;
            $v['is_zhuan'] = 2;
        }
        return $data;
    }
    //通过传入类型获取转存的不同文件
    public function zhuan($type,$tiao){
        $rotor = Db::name('rotor')
            ->alias('a')
            ->join('savemes b','a.savemes_id = b.id')
            ->field('a.id,a.user_id as unloading_user_id,a.savemes_id,a.folder_id,b.user_id,b.share_url,b.name,b.type,b.images,b.video,b.content,b.is_open,b.is_up,a.createtime')
            ->where('b.type',$type)
            ->where($tiao)
            ->order('a.createtime desc')
            ->select();
        if(!empty($rotor)){
            foreach ($rotor as &$v){
                $user = Db::name('user')->where('id',$v['user_id'])->find();
                if(empty($user['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $whiteip_ids = explode(',',$user['whiteip_ids']);
                    if(in_array($v['unloading_user_id'],$whiteip_ids)){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }
        }
        return $rotor;
    }

    //各种类型的文件  转存以及自己的文件
    public function gong($type,$arr1,$arr2){
        $qiniu = get_addon_config('qiniu')['cdnurl'];
        if(!empty($arr2)){
            foreach ($arr2 as &$v_1){
                $v_1['is_zhuan'] = 1;
                $v_1['is_real'] = 2;
            }
            $arr = array_merge($arr1,$arr2);
        }else{
            $arr = $arr1;
        }

        //笔记类型
        if($type == 1){
            foreach ($arr as &$v){
                $v['nowtime'] = date('Y-m-d',$v['createtime']);
                $v['createtime'] = date('m-d',$v['createtime']);
                $v['images'] = '';
                $v['video'] = '';
                $v['video_image'] = '';
            }
        } elseif ($type == 2){
            //图片类型
            foreach ($arr as &$v){
                $v['nowtime'] = date('Y-m-d',$v['createtime']);
                $v['createtime'] = date('m-d',$v['createtime']);
                $v['images'] = $qiniu.$v['images'];
                $v['video'] = '';
                $v['video_image'] = '';
                $v['content'] = '';
            }
        }elseif ($type == 3){
            //视频类型
            foreach ($arr as &$v){
                $v['nowtime'] = date('Y-m-d',$v['createtime']);
                $v['createtime'] = date('m-d',$v['createtime']);
                $v['video'] = $qiniu.$v['video'];
                // 获取视频第一帧图片
                $video_info = json_decode(file_get_contents($v['video'] . '?avinfo'), true);
                $v['video_image'] = $this->get_video_first_image($v['video'], $video_info);
                $v['images'] = '';
                $v['content'] = '';
            }
        }
        return $arr;
    }


    //合并完数据按时间分段
    public function sundry($arr){
        $times = array_values(array_unique(array_column($arr,'createtime')));
        //将数据放到对应的时间分段
        $arrs = [];
        foreach ($times as $t_k=> $t_v){
            $arrs[$t_k]['times'] = $t_v;
            $k = 0;
            foreach ($arr as $value){
                $k+=0;
                if($t_v == $value['createtime']){
                    $arrs[$t_k]['info'][$k] = $value;
                    $k++;
                }
            }
        }
        return $arrs;

    }


    /**
     * @ApiTitle    (文件列表)
     * @ApiSummary  (文件列表)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/index/filedetail)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="folder_id", type="inter", required=true, description="文件夹id")
     * @ApiParams   (name="user_id", type="inter", required=false, description="用户id")
     *
     * @ApiReturn({
    "code": 1,
    "msg": "成功",
    "time": "1571492001",
    "data": {
    "folder": [
    {
    "times": "2020-08-13",
    "info": [
    {
    "id": 26,
    "folder_name": "20200813203909",
    "is_up": 1,
    "user_id": 3,
    "leavel": 2,
    "createtime": "2020-08-13",
    "share_url": "http://cloud.w.brotop.cn/index/index/filedetail/user_id/3/file_id/26",
    "is_open": 1,
    "is_real": 1,
    "is_white": 1
    "is_subscribe"://是否订阅 1订阅2未订阅
    }
    ]
    }
    ],
    "note": [
    {
    "times": "08-12",
    "info": [
    {
    "id": 73,
    "user_id": 3,
    "type": 1,
    "name": "20200812173653",
    "share_url": null,
    "images": "",
    "video": "",
    "content": "<p>哦哦婆婆送😊1名摸摸摸看了看家具都做摸摸摸摸摸摸可口可乐了酷兔兔突突突</p>",
    "is_open": 1,
    "is_up": 1,
    "createtime": "08-12",
    "is_white": 1,
    "is_real": 1,
    "is_zhuan": 2,
    "nowtime": "2020-08-12",
    "video_image": ""
    }
    ]
    }
    ],
    "pic": [
    {
    "times": "08-12",
    "info": [
    {
    "id": 66,
    "user_id": 3,
    "type": 2,
    "name": "20200812173523",
    "share_url": null,
    "images": "http://cloud.caiyunpan.brotop.cn/uploads/20200812/b72563f3b0e1c610fea2b5fec5c04211.png",
    "video": "",
    "content": "",
    "is_open": 1,
    "is_up": 1,
    "createtime": "08-12",
    "is_white": 1,
    "is_real": 1,
    "is_zhuan": 2,
    "nowtime": "2020-08-12",
    "video_image": ""
    },
    ]
    }
    ],
    "video": [
    {
    "times": //时间,
    "info": [
    {
        "id": //id,
        "user_id": 3,
        "type": 3,
        "name": "20200812173616",
        "share_url": null,
        "images": "",
        "video": "http://cloud.caiyunpan.brotop.cn/uploads/20200812/edadf76bea6ce8c58b6ad9a8a2d88e4a.mp4",
        "content": "",
        "is_open": 1,
        "is_up": 1,
        "createtime": "08-12",
        "is_white": 1,
        "is_real": 1,
        "is_zhuan": 2,
        "nowtime": "2020-08-12",
        "video_image": "http://cloud.caiyunpan.brotop.cn/uploads/20200812/edadf76bea6ce8c58b6ad9a8a2d88e4a.mp4?vframe/jpg/offset/1/w/720/h/1280"
    },
    ]
    }
    ]
    }
    })
     */
    public function filedetail()
    {
        $qiniu = get_addon_config('qiniu')['cdnurl'];
        $user_id = $this->auth->id;
        $folder_id = $this->request->param('folder_id');

        $folder_info = Db::name('folder')->where('id',$folder_id)->find();
        if($folder_info['user_id'] == $user_id){
            $data['is_mine'] = 1;
        }else{
            $data['is_mine'] = 2;
        }
        $other_user_id = $this->request->param('user_id');
        if(empty($folder_id)){
            $this->error('缺少必要参数');
        }
        //文件夹
        $folder = Db::name('folder')
            ->where('pid',$folder_id)
            ->field('id,folder_name,is_up,user_id,leavel,createtime,share_url,is_open,share_url')
            ->select();
        foreach ($folder as &$v){

            //判断是否为本人打开文件夹
            $is_real = Db::name('folder')->where('id',$v['id'])->find();
            if($is_real['user_id'] == $user_id){
                //是本人打开
                $v['is_real'] = 1;
            }else{
                //不是本人打开
                $v['is_real'] = 2;
            }

            $user_info = Db::name('user')->where('id',$v['user_id'])->find();
            if($v['user_id'] == $user_id){
                $v['is_white'] = 1;
            }else{
                if(empty($user_info['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $whiteip_ids = explode(',',$user_info['whiteip_ids']);
                    if(in_array($user_id,$whiteip_ids)){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }
            $v['createtime'] = date('Y-m-d',$v['createtime']);
        }

        $times = array_values(array_unique(array_column($folder,'createtime')));
        //将数据放到对应的时间分段
        $arrs = [];
        foreach ($times as $t_k=> $t_v){
            $arrs[$t_k]['times'] = $t_v;
            $k = 0;
            foreach ($folder as $value){
                $k+=0;
                if($t_v == $value['createtime']){
                    $arrs[$t_k]['info'][$k] = $value;
                    $k++;
                }
            }
        }
        $data['folder'] = $arrs;

        //笔记
        $note['folder_id'] = ['eq',$folder_id];
        $z_tiao['a.folder_id'] = ['eq',$folder_id];
        $note = $this->myfile(1,$note);
        foreach ($note as &$v){
            //判断是否为本人打开文件夹
            $is_real = Db::name('savemes')->where('id',$v['id'])->find();
            if($is_real['user_id'] == $user_id){
                //是本人打开
                $v['is_real'] = 1;
            }else{
                //不是本人打开
                $v['is_real'] = 2;
            }

            $user_info = Db::name('user')->where('id',$v['user_id'])->find();
            if($v['user_id'] == $user_id){
                $v['is_white'] = 1;
            }else{
                if(empty($user_info['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $whiteip_ids = explode(',',$user_info['whiteip_ids']);
                    if(in_array($user_id,$whiteip_ids)){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }
        }
        $zhuan_note = $this->zhuan(1,$z_tiao);
        foreach ($zhuan_note as &$v){
            //判断是否为本人打开文件夹
            $is_real = Db::name('savemes')->where('id',$v['id'])->find();
            if($is_real['user_id'] == $user_id){
                //是本人打开
                $v['is_real'] = 1;
            }else{
                //不是本人打开
                $v['is_real'] = 2;
            }

            $user_info = Db::name('user')->where('id',$v['user_id'])->find();
            if($v['user_id'] == $user_id){
                $v['is_white'] = 1;
            }else{
                if(empty($user_info['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $whiteip_ids = explode(',',$user_info['whiteip_ids']);
                    if(in_array($user_id,$whiteip_ids)){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }
        }
        $gong = $this->gong(1,$note,$zhuan_note);
        $data['note'] = $this->sundry($gong);

        //图片
        $pic['folder_id'] = ['eq',$folder_id];
        $pic_tiao['a.folder_id'] = ['eq',$folder_id];
        $pic = $this->myfile(2,$pic);
        foreach ($pic as &$v){
            //判断是否为本人打开文件夹
            $is_real = Db::name('savemes')->where('id',$v['id'])->find();
            if($is_real['user_id'] == $user_id){
                //是本人打开
                $v['is_real'] = 1;
            }else{
                //不是本人打开
                $v['is_real'] = 2;
            }

            $user_info = Db::name('user')->where('id',$v['user_id'])->find();
            if($v['user_id'] == $user_id){
                $v['is_white'] = 1;
            }else{
                if(empty($user_info['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $whiteip_ids = explode(',',$user_info['whiteip_ids']);
                    if(in_array($user_id,$whiteip_ids)){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }
        }
        $zhuan_pic = $this->zhuan(2,$pic_tiao);
        foreach ($zhuan_pic as &$v){
            //判断是否为本人打开文件夹
            $is_real = Db::name('savemes')->where('id',$v['id'])->find();
            if($is_real['user_id'] == $user_id){
                //是本人打开
                $v['is_real'] = 1;
            }else{
                //不是本人打开
                $v['is_real'] = 2;
            }

            $user_info = Db::name('user')->where('id',$v['user_id'])->find();
            if($v['user_id'] == $user_id){
                $v['is_white'] = 1;
            }else{
                if(empty($user_info['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $whiteip_ids = explode(',',$user_info['whiteip_ids']);
                    if(in_array($user_id,$whiteip_ids)){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }
        }
        $gong1 = $this->gong(2,$pic,$zhuan_pic);
        $data['pic'] = $this->sundry($gong1);

        //视频
        $video['folder_id'] = ['eq',$folder_id];
        $video_tiao['a.folder_id'] = ['eq',$folder_id];
        $video = $this->myfile(3,$video);
        foreach ($video as &$v){
            //判断是否为本人打开文件夹
            $is_real = Db::name('savemes')->where('id',$v['id'])->find();
            if($is_real['user_id'] == $user_id){
                //是本人打开
                $v['is_real'] = 1;
            }else{
                //不是本人打开
                $v['is_real'] = 2;
            }

            $user_info = Db::name('user')->where('id',$v['user_id'])->find();
            if($v['user_id'] == $user_id){
                $v['is_white'] = 1;
            }else{
                if(empty($user_info['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $whiteip_ids = explode(',',$user_info['whiteip_ids']);
                    if(in_array($user_id,$whiteip_ids)){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }
        }
        $zhuan_video = $this->zhuan(3,$video_tiao);
        foreach ($zhuan_video as &$v){
            //判断是否为本人打开文件夹
            $is_real = Db::name('savemes')->where('id',$v['id'])->find();
            if($is_real['user_id'] == $user_id){
                //是本人打开
                $v['is_real'] = 1;
            }else{
                //不是本人打开
                $v['is_real'] = 2;
            }

            $user_info = Db::name('user')->where('id',$v['user_id'])->find();
            if($v['user_id'] == $user_id){
                $v['is_white'] = 1;
            }else{
                if(empty($user_info['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $whiteip_ids = explode(',',$user_info['whiteip_ids']);
                    if(in_array($user_id,$whiteip_ids)){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }
        }
        $gong2 = $this->gong(3,$video,$zhuan_video);
        $data['video'] = $this->sundry($gong2);

        if(!empty($other_user_id)){
            $res_userinfo = Db::name('user')->where('id',$other_user_id)->field('username,avatar')->find();
            $data['username'] = $res_userinfo['username'];
            if(!empty($res_userinfo['avatar'])){
                $data['avatar'] = $qiniu.$res_userinfo['avatar'];
            }else{
                $data['avatar'] = '';
            }

            //是否订阅
            $is_subscribe = Db::name('subscribe')->where('user_id',$user_id)->where('to_user_id',$other_user_id)->find();
            if(empty($is_subscribe)){
                $data['is_subscribe'] = 2;
            }else{
                $data['is_subscribe'] = 1;
            }
        }
        $data['leavel'] = $folder_info['leavel'];
        $data['share_url'] = $folder_info['share_url'];

        $this->success('success',$data);
    }


    /**
     * @ApiTitle    (通过文件夹id获取图片列表)
     * @ApiSummary  (通过文件夹id获取图片列表)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/index/get_list)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="folder_id", type="inter", required=true, description="文件夹id")
     *
     * @ApiReturn({
    "code": 1,
    "msg": "成功",
    "time": "1571492001",
    "data": {
    "folder": [
    {
    "times": "2020-08-13",
    "info": [
    {
    "id": 26,
    "folder_name": "20200813203909",
    "is_up": 1,
    "user_id": 3,
    "leavel": 2,
    "createtime": "2020-08-13",
    "share_url": "http://cloud.w.brotop.cn/index/index/filedetail/user_id/3/file_id/26",
    "is_open": 1,
    "is_real": 1,
    "is_white": 1
    "is_subscribe"://是否订阅 1订阅2未订阅
    }
    ]
    }
    ],
    "note": [
    {
    "times": "08-12",
    "info": [
    {
    "id": 73,
    "user_id": 3,
    "type": 1,
    "name": "20200812173653",
    "share_url": null,
    "images": "",
    "video": "",
    "content": "<p>哦哦婆婆送😊1名摸摸摸看了看家具都做摸摸摸摸摸摸可口可乐了酷兔兔突突突</p>",
    "is_open": 1,
    "is_up": 1,
    "createtime": "08-12",
    "is_white": 1,
    "is_real": 1,
    "is_zhuan": 2,
    "nowtime": "2020-08-12",
    "video_image": ""
    }
    ]
    }
    ],
    "pic": [
    {
    "times": "08-12",
    "info": [
    {
    "id": 66,
    "user_id": 3,
    "type": 2,
    "name": "20200812173523",
    "share_url": null,
    "images": "http://cloud.caiyunpan.brotop.cn/uploads/20200812/b72563f3b0e1c610fea2b5fec5c04211.png",
    "video": "",
    "content": "",
    "is_open": 1,
    "is_up": 1,
    "createtime": "08-12",
    "is_white": 1,
    "is_real": 1,
    "is_zhuan": 2,
    "nowtime": "2020-08-12",
    "video_image": ""
    },
    ]
    }
    ],
    "video": [
    {
    "times": //时间,
    "info": [
    {
    "id": //id,
    "user_id": 3,
    "type": 3,
    "name": "20200812173616",
    "share_url": null,
    "images": "",
    "video": "http://cloud.caiyunpan.brotop.cn/uploads/20200812/edadf76bea6ce8c58b6ad9a8a2d88e4a.mp4",
    "content": "",
    "is_open": 1,
    "is_up": 1,
    "createtime": "08-12",
    "is_white": 1,
    "is_real": 1,
    "is_zhuan": 2,
    "nowtime": "2020-08-12",
    "video_image": "http://cloud.caiyunpan.brotop.cn/uploads/20200812/edadf76bea6ce8c58b6ad9a8a2d88e4a.mp4?vframe/jpg/offset/1/w/720/h/1280"
    },
    ]
    }
    ]
    }
    })
     */
    public function get_list()
    {
        $qiniu = get_addon_config('qiniu')['cdnurl'];
        $user_id = $this->auth->id;
        $folder_id = $this->request->param('folder_id');


        //自己的图片文件
        $data = Db::name('savemes')
            ->where('user_id',$user_id)
            ->where('type',2)
            ->where('folder_id',$folder_id)
            ->select();
        foreach ($data as &$v){
            $v['is_zhuan'] = 2;

            if($v['is_open'] == 2){
                $user_info = Db::name('user')->where('id',$v['user_id'])->field('id,whiteip_ids')->find();
                if(empty($user_info['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $user_info['whiteip_ids'] = explode(',',$user_info['whiteip_ids']);
                    if(in_array($user_id,$user_info['whiteip_ids'])){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }else{
                $v['is_white'] = 1;
            }
        }

        //自己转存的图片文件
        $rotor = Db::name('rotor')
            ->alias('a')
            ->join('savemes b','a.savemes_id = b.id')
            ->where('a.user_id',$user_id)
            ->where('b.type',2)
            ->field('a.id as zhuan_id,a.savemes_id,a.user_id as zhuan_user_id,a.folder_id as zhuan_folder_id,b.id,b.user_id,b.type,b.folder_id,b.name,b.images,b.is_open,b.is_up,b.share_url,b.collect_num')
            ->select();
        foreach ($rotor as &$v){
            $v['is_zhuan'] = 1;

            if($v['is_open'] == 2){
                $user_info = Db::name('user')->where('id',$v['user_id'])->field('id,whiteip_ids')->find();
                if(empty($user_info['whiteip_ids'])){
                    $v['is_white'] = 2;
                }else{
                    $user_info['whiteip_ids'] = explode(',',$user_info['whiteip_ids']);
                    if(in_array($user_id,$user_info['whiteip_ids'])){
                        $v['is_white'] = 1;
                    }else{
                        $v['is_white'] = 2;
                    }
                }
            }else{
                $v['is_white'] = 1;
            }
        }

        $res = array_merge($data,$rotor);
        foreach ($res as &$val){
            $val['images'] = $qiniu.$val['images'];
        }
        $this->success('success',$res);

    }



    /**
     * @ApiTitle    (广告图)
     * @ApiSummary  (广告图)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/index/advertise)
     *
     * @ApiReturn({
    "code": 1,
    "msg": "成功",
    "time": "1571492001",
    "data": {
        "id"://id,
        "image": //图片地址,
        "url":  //跳转地址
    }
    })
     */
    public function advertise()
    {
        $qiniu = get_addon_config('qiniu')['cdnurl'];
        $data = Db::name('advertise')->field('id,image,url')->limit(5)->select();
        if(!empty($data)){
            foreach ($data as &$v){
                $v['image'] = $qiniu.$v['image'];
            }
        }else{
            $data = [];
        }
        $this->success('success',$data);
    }


    /**
     * @ApiTitle    (历史记录)
     * @ApiSummary  (历史记录)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/index/keyword)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     *
     * @ApiReturn({
    "code": 1,
    "msg": "成功",
    "time": "1571492001",
    "data": {
        "id": //id,
        "keyword": //历史记录
    }
    })
     */
    public function keyword()
    {
        $user_id = $this->auth->id;
        $data = Db::name('keyword')->where('user_id',$user_id)->field('id,keyword')->limit(20)->select();
        $this->success('success',$data);
    }

    /**
     * @ApiTitle    (清空历史记录)
     * @ApiSummary  (清空历史记录)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/index/del_keyword)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     *
     * @ApiReturn({
    "code": 1,
    "msg": "成功",
    "time": "1571492001",
    "data": {
    }
    })
     */
    public function del_keyword()
    {
        $user_id = $this->auth->id;
        $data = Db::name('keyword')->where('user_id',$user_id)->delete();
        if(empty($data)){
            $this->error('清空失败');
        }else{
            $this->success('success');
        }

    }





    /**
     * @ApiTitle    (消息列表)
     * @ApiSummary  (消息列表)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/index/message)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     *
     * @ApiReturn({
    "code": 1,
    "msg": "成功",
    "time": "1571492001",
    "data": {
    "id": //id,
    "title": //标题,
    "content": //内容,
    "url": 更新链接,
    "createtime": //创建时间,
    "updatetime": //修改时间,
    "is_read": //是否已读0未读1已读,
    "type": 类型1普通消息2客服消息3版本更新
    }
    })
     */
    public function message()
    {
        $user_id = $this->auth->id;

        //消息列表
        $message = Db::name('message')
            ->where('user_id',$user_id)
            ->order('createtime desc')
            ->select();

        //版本更新
        $data = Db::name('renewal')->where('id',1)->find();
        if(!empty($data)){
            $read = Db::name('read')->where('user_id',$user_id)->where('renewal_id',1)->find();
            if(empty($read)){
                $data['is_read'] = 0;
            }else{
                $data['is_read'] = 1;
            }
            $data['type'] = 3;
            array_push($message,$data);
        }
        $a = array_column($message,'createtime');

        array_multisort($a,SORT_DESC,$message);

        foreach ($message as &$value){
            $value['createtime'] = date('Y-m-d H:i:s',$value['createtime']);
            $value['content'] = strip_tags($value['content']);
            unset($value['updatetime']);
        }
        $this->success('success',$message);

    }


    /**
     * @ApiTitle    (消息详情)
     * @ApiSummary  (消息详情)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/index/messagedetail)
     *
     * @ApiHeaders  (name=token, type=string, required=true, description="请求的Token")
     * @ApiParams   (name="message_id", type="inter", required=true, description="消息id")
     * @ApiParams   (name="type", type="inter", required=true, description="消息类型1普通信息2客服消息3版本消息")
     *
     * @ApiReturn({
    "code": 1,
    "msg": "成功",
    "time": "1571492001",
    "data": {
    "id": //id,
    "title": //标题,
    "content": //内容,
    "url": 更新链接,
    "createtime": //创建时间,
    "updatetime": //修改时间,
    }
    })
     */
    public function messagedetail()
    {
        $user_id = $this->auth->id;
        $message_id  = $this->request->param('message_id');
        $type = $this->request->param('type');
        if(empty($message_id) || empty($type)){
            $this->error('缺少必要参数');
        }
        if($type == 3){
            $info = Db::name('read')->where('user_id',$user_id)->find();
            if(empty($info)){
                $res['user_id'] = $user_id;
                $res['renewal_id'] = $message_id;
                $res['createtime'] = time();
                Db::name('read')->insertGetId($res);
            }
            $data = Db::name('renewal')->where('id',$message_id)->find();
        }else{
            Db::name('message')->where('id',$message_id)->update(['is_read'=>1]);
            $data = Db::name('message')->where('id',$message_id)->find();
        }
        $data['createtime'] = date('Y-m-d H:i:s',$data['createtime']);
        $data['content'] = strip_tags($data['content']);
        $this->success('success',$data);
    }


    /**
     * @ApiTitle    (开关)
     * @ApiSummary  (开关)
     * @ApiMethod   (POST)
     * @ApiRoute    (/api/index/kai)
     *
     *
     * @ApiReturn({
    "code": 1,
    "msg": "成功",
    "time": "1571492001",
    "data": {
       "switch"://开关1开0关
    }
    })
     */
    public function kai(){
        $data = Db::name('open')->where('id',1)->find();
        $this->success('success',$data);
    }




































    public function get_video_first_image($video_url,$video_info){
        if(empty($video_info['streams'][0]['width'])) {
            $width = $video_info['streams'][1]['width'];
            $height = $video_info['streams'][1]['height'];
        } else {
            $width = $video_info['streams'][0]['width'];
            $height = $video_info['streams'][0]['height'];
        }
        return $video_url.'?vframe/jpg/offset/1/w/'.$width.'/h/'.$height;
    }
}