<?php

namespace api\home\controller;

use api\home\model\ToolsModel;
use api\home\service\ToolsService;
use cmf\controller\RestBaseController;
use think\Db;

/**
 * @title 教练端-授课日历
 */
class CoachPlanController extends RestBaseController
{

    /**
     * @title 首页
     * @description 授课日历首页接口
     * @author Pan Haowen
     * @url /home/coach_plan/index
     * @method POST
     * @header name:XX-Token require:1 default: desc:token
     * @param name:time type:int require:0  desc:时间搜索条件
     * @return data:授课日历
     */
    public function index(){
        $userId = $this->getUserId();
        $coach=Db::name('coach')->where('user_id',$userId)->find();
        $param = $this->request->param();
        $where=[];
        if (!empty($param['time'])) {
            $where['c.start_time'] = [['>= time', intval($param['time'])], ['<= time', strtotime('+1 month', $param['time'])]];
        } else {
            $where['c.start_time'] = [['>= time', strtotime('+1 month', strtotime(date('Y-m', time())))], ['<= time', strtotime('+2 month', strtotime(date('Y-m', time())))]];
        }
        $data=Db::name('coach_class_apply')
            ->alias('cca')
            ->join('class c','cca.class_id=c.id')
            ->join('product p','c.product_id=p.id')
            ->join('room r','c.room_id=r.id')
            ->where(['c.delete_time'=>null,'c.status'=>1,'cca.coach_id'=>$coach['id']])
            ->where($where)
            ->field('p.name as pname,c.*,cca.status,r.name as rname,cca.coach_id')
            ->select()
            ->each(function ($item) {
                if ($item['type']==1){
                    $item['plan'] = Db::name('coach_class')
                        ->alias('cc')
                        ->join('coach c', 'cc.coach_id=c.id')
                        ->where(['cc.status' => 0, 'cc.class_id' => $item['id'],'cc.coach_id'=>$item['coach_id']])
                        ->field('cc.*,c.name')
                        ->select();
                }elseif ($item['type']==2) {
                    $item['plan'] = Db::name('coach_class')
                        ->alias('cc')
                        ->join('coach c', 'cc.coach_id=c.id')
                        ->where(['cc.status' => 0, 'cc.class_id' => $item['id']])
                        ->field('cc.*,c.name')
                        ->select();
                }
                $item['count']=Db::name('coach_class')->where(['class_id'=>$item['id'],'status'=>0,'coach_id'=>$item['coach_id']])->count();
                return $item;
            });
        $this->success("获取数据成功", $data);
    }

    /**
     * @title 课程计划管理
     * @description 课程计划管理接口
     * @author Pan Haowen
     * @url /home/coach_plan/CoachClass
     * @method POST
     * @header name:XX-Token require:1 default: desc:token
     * @param name:class_id type:int require:1  desc:课程id
     * @return status:0=>正常,1=>已取消,2=>已结束
     * @return people:总人数
     * @return star_people:评分人数
     * @return people_name:学员名称
     * @return id:课程id
     * @return ccid:课时id
     */
    public function CoachClass(){
        $userId = $this->getUserId();
        $coach=Db::name('coach')->where('user_id',$userId)->find();
        $param=$this->request->param();
        $data=Db::name('coach_class')
            ->alias('cc')
            ->join('class c','cc.class_id=c.id')
            ->join('product p','c.product_id=p.id')
            ->join('room r','c.room_id=r.id')
            ->where(['c.id'=>$param['class_id'],'cc.coach_id'=>$coach['id']])
            ->field('p.name as pname,c.id,cc.status,r.name as rname,cc.coach_id,cc.start_time,cc.end_time,cc.id as ccid,p.id as pid,r.id as rid')
            ->select()
            ->each(function ($item) {
                if ($item['end_time']<time()){
                    $item['status']=2;
                    $item['star_people']=Db::name('user_coach_class')->where(['coach_class_id'=>$item['ccid'],'status'=>1])->whereNotNull('star')->count();
                    $item['star']=Db::name('user_coach_class')->where(['coach_class_id'=>$item['ccid'],'status'=>1])->avg('star');
                }
                $item['start_time']=date('m月d日 H:i',$item['start_time']);
                $item['end_time']=date('m月d日 H:i',$item['end_time']);
                $item['people']=Db::name('user_class_apply')->where(['class_id'=>$item['id'],'status'=>1])->count();
                $re=Db::name('user_class_apply')->where(['class_id'=>$item['id'],'status'=>1])->find();
                $item['people_name']=Db::name('user')->where('id',$re['user_id'])->find()['user_nickname'];
                return $item;
            });
        $this->success('获取数据成功',$data);
    }


    /**
     * @title 课程计划取消
     * @description 课程计划管理取消接口
     * @author Pan Haowen
     * @url /home/coach_plan/cancel
     * @method POST
     * @header name:XX-Token require:1 default: desc:token
     * @param name:coach_class_id type:int require:1  desc:课时id
     */
    public function cancel(){
        $this->getUserId();
        $param=$this->request->param();
        if (Db::name('coach_class')->where('id',$param['coach_class_id'])->find(['end_time'])<time()){
            $this->error(['code'=>'400001','msg'=>'已结束课程不能取消']);
        }
        $re=Db::name('coach_class')->where('id',$param['coach_class_id'])->update(['status'=>1]);
        if ($re){
            $this->success('操作成功');
        }else{
            $this->error('操作失败');
        }
    }


    /**
     * @title 课时详情
     * @description 课时详情接口
     * @author Pan Haowen
     * @url /home/coach_plan/Class
     * @method POST
     * @header name:XX-Token require:1 default: desc:token
     * @param name:product_id type:int require:1  desc:产品id
     * @param name:room_id type:int require:1  desc:场所id
     * @param name:class_id type:int require:1  desc:课程id
     * @param name:coach_class_id type:int require:1  desc:课时id
     * @return room:场所信息
     * @return product:产品信息
     * @return config:教学内容与激励政策
     * @return coach_class:课程信息
     * @return assess:目标评估
     * @return filter:功能筛查
     * @return train:协同训练
     */
    public function Class()
    {
        $userId = $this->getUserId();
        $param = $this->request->param();
        //场所信息
        $data['room'] = Db::name('room')->where('id', $param['room_id'])->field('id,name,lat,lng,location')->find();
        $user = Db::name('user')->where('id', $userId)->find();
        $distance=new ToolsService();
        $data['room']['distance'] = $distance->distance($user['jing'],$user['wei'],$data['room']['lng'],$data['room']['lat']);

        //产品信息
        $data['product'] = Db::name('product')->where('id', $param['product_id'])->find();
        $data['product']['thumbnail'] = cmf_get_image_preview_url($data['product']['thumbnail']);

        //教学内容与激励信息
        $data['config'] = Db::name('config')->where('id', 1)->field('jiaoxue')->find();
        $data['config']['jiaoxue']=cmf_replace_content_file_url(htmlspecialchars_decode($data['config']['jiaoxue']));



        //课程状态
        $data['coach_class']=Db::name('coach_class')->where('id',$param['coach_class_id'])->find();
        if ($data['coach_class']['status']==1){
            $data['coach_class']['status']=1;
        }elseif (time()<$data['coach_class']['start_time']){
            $data['coach_class']['status']=2;
        }elseif (time()<$data['coach_class']['start_time'] && time()<$data['coach_class']['end_time']){
            $data['coach_class']['status']=3;
        }elseif (time()>$data['coach_class']['end_time']){
            $data['coach_class']['status']=4;
        }
        $data['coach_class']['start_time']=date('Y年m月d日 H:i',$data['coach_class']['start_time']);
        $data['coach_class']['end_time']=date('Y年m月d日 H:i',$data['coach_class']['end_time']);



        //目标评估
        $assess=explode(',',$data['coach_class']['assess_id']);
        $data['assess']=Db::name('assess')->where('id','in',$assess)->select()->each(function ($item) {
            $item['thumbnail'] = cmf_get_image_preview_url($item['thumbnail']);
            return $item;
        });

        //功能筛查
        $filter=explode(',',$data['coach_class']['filter_id']);
        $data['filter']=Db::name('filter')->where('id','in',$filter)->select()->each(function ($item) {
            $item['thumbnail'] = cmf_get_image_preview_url($item['thumbnail']);
            return $item;
        });

        //协同训练
        $train=explode(',',$data['coach_class']['train_id']);
        $data['train']=Db::name('train')->where('id','in',$train)->select()->each(function ($item) {
            $item['thumbnail'] = cmf_get_image_preview_url($item['thumbnail']);
            return $item;
        });

        //上课会员
        $data['user']=Db::name('user_coach_class')
            ->where(['status'=>1,'coach_class_id'=>$param['coach_class_id']])
            ->count();

        $this->success("获取数据成功", $data);
    }

    /**
     * @title 上课会员
     * @description 上课会员接口
     * @author Pan Haowen
     * @url /home/coach_plan/user
     * @method POST
     * @header name:XX-Token require:1 default: desc:token
     * @param name:class_id type:int require:1  desc:课程id
     * @param name:coach_class_id type:int require:1  desc:课时id
     * @return status:1=>打卡,2=>缺勤,3=>无记录
     */
    public function user(){
        $this->getUserId();
        $param=$this->request->param();
        $data=Db::name('user_class_apply')
            ->alias('uca')
            ->join('user u','uca.user_id=u.id')
            ->where(['uca.class_id'=>$param['class_id'],'uca.status'=>1])
            ->field('u.user_nickname,u.avatar,u.id,uca.status')
            ->select()
            ->toArray();
        foreach ($data as $k=>$v){
            $re=Db::name('user_coach_class')->where(['user_id'=>$data[$k]['id'],'coach_class_id'=>$param['coach_class_id']])->find();
            if (!$re){
                $data[$k]['status']=3;
            }
        }
        $this->success("获取数据成功", $data);
    }

    /**
     * @title 打卡/缺勤
     * @description 上课会员操作接口
     * @author Pan Haowen
     * @url /home/coach_plan/userEdit
     * @method POST
     * @header name:XX-Token require:1 default: desc:token
     * @param name:user_id type:int require:1  desc:用户id
     * @param name:coach_class_id type:int require:1  desc:课时id
     * @param name:status type:int require:1  desc:1=>打卡,2=>缺勤
     */
    public function userEdit(){
        $this->getUserId();
        $param=$this->request->param();
        $re=Db::name('coach_class')->where('id',$param['coach_class_id'])->find();
        if ($re['end_time']>time()){
            $this->error(['code'=>'400001','msg'=>'未结束课程不能操作']);
        }
        $re2=Db::name('user_coach_class')->where(['coach_class_id'=>$param['coach_class_id'],'user_id'=>$param['user_id']])->find();
        if (!$re2){
            $param['create_time']=time();
            Db::name('user_coach_class')->insert($param);
        }else{
            Db::name('user_coach_class')->where(['coach_class_id'=>$param['coach_class_id'],'user_id'=>$param['user_id']])->update(['status'=>$param['status']]);
        }
        $this->success("操作成功");
    }

    /**
     * @title 添加目标评估课程
     * @description 添加目标评估课程接口
     * @author Pan Haowen
     * @url /home/coach_plan/assess
     * @method POST
     * @header name:XX-Token require:1 default: desc:token
     * @param name:coach_class_id type:int require:1  desc:课时id
     */
    public function assess(){
        $this->getUserId();
        $param=$this->request->param();
        $coach_class=Db::name('coach_class')->where('id',$param['coach_class_id'])->find();
        $data=Db::name('assess')->select()->each(function ($item) {
                $item['thumbnail'] = cmf_get_image_preview_url($item['thumbnail']);
                return $item;
            })->toArray();
        foreach ($data as $k=>$v){
            if (in_array($data[$k]['id'],explode(',',$coach_class['assess_id']))){
                $data[$k]['selected']=1;
            }else{
                $data[$k]['selected']=0;
            }
        }
        $this->success("获取数据成功",$data);
    }

    /**
     * @title 添加目标评估课程提交
     * @description 添加目标评估课程提交
     * @author Pan Haowen
     * @url /home/coach_plan/assessPost
     * @method POST
     * @header name:XX-Token require:1 default: desc:token
     * @param name:coach_class_id type:int require:1  desc:课时id
     * @param name:assess_id type:varchar require:1  desc:目标评估课程id(多个目标评估课程用,隔开)
     */
    public function assessPost(){
        $this->getUserId();
        $param=$this->request->param();
        $re=Db::name('coach_class')->where('id',$param['coach_class_id'])->update(['assess_id',$param['assess_id']]);
        $this->success("操作成功");
    }

    /**
     * @title 添加功能筛查课程
     * @description 添加功能筛查课程接口
     * @author Pan Haowen
     * @url /home/coach_plan/filter
     * @method POST
     * @header name:XX-Token require:1 default: desc:token
     * @param name:coach_class_id type:int require:1  desc:课时id
     */
    public function filter(){
        $this->getUserId();
        $param=$this->request->param();
        $coach_class=Db::name('coach_class')->where('id',$param['coach_class_id'])->find();
        $data=Db::name('filter')->select()->each(function ($item) {
            $item['thumbnail'] = cmf_get_image_preview_url($item['thumbnail']);
            return $item;
        })->toArray();
        foreach ($data as $k=>$v){
            if (in_array($data[$k]['id'],explode(',',$coach_class['filter_id']))){
                $data[$k]['selected']=1;
            }else{
                $data[$k]['selected']=0;
            }
        }
        $this->success("获取数据成功",$data);
    }

    /**
     * @title 添加功能筛查课程提交
     * @description 添加功能筛查课程提交
     * @author Pan Haowen
     * @url /home/coach_plan/filterPost
     * @method POST
     * @header name:XX-Token require:1 default: desc:token
     * @param name:coach_class_id type:int require:1  desc:课时id
     * @param name:filter_id type:varchar require:1  desc:功能筛查课程id(多个功能筛查课程用,隔开)
     */
    public function filterPost(){
        $this->getUserId();
        $param=$this->request->param();
        $re=Db::name('coach_class')->where('id',$param['coach_class_id'])->update(['filter_id',$param['filter_id']]);
        $this->success("操作成功");
    }

    /**
     * @title 添加协同训练课程
     * @description 添加协同训练课程接口
     * @author Pan Haowen
     * @url /home/coach_plan/train
     * @method POST
     * @header name:XX-Token require:1 default: desc:token
     * @param name:coach_class_id type:int require:1  desc:课时id
     */
    public function train(){
        $this->getUserId();
        $param=$this->request->param();
        $coach_class=Db::name('coach_class')->where('id',$param['train_class_id'])->find();
        $data=Db::name('train')->select()->each(function ($item) {
            $item['thumbnail'] = cmf_get_image_preview_url($item['thumbnail']);
            return $item;
        })->toArray();
        foreach ($data as $k=>$v){
            if (in_array($data[$k]['id'],explode(',',$coach_class['train_id']))){
                $data[$k]['selected']=1;
            }else{
                $data[$k]['selected']=0;
            }
        }
        $this->success("获取数据成功",$data);
    }

    /**
     * @title 添加协同训练课程提交
     * @description 添加协同训练课程提交
     * @author Pan Haowen
     * @url /home/coach_plan/trainPost
     * @method POST
     * @header name:XX-Token require:1 default: desc:token
     * @param name:coach_class_id type:int require:1  desc:课时id
     * @param name:train_id type:varchar require:1  desc:协同训练课程id(多个协同训练课程用,隔开)
     */
    public function trainPost(){
        $this->getUserId();
        $param=$this->request->param();
        $re=Db::name('coach_class')->where('id',$param['coach_class_id'])->update(['train_id',$param['train_id']]);
        $this->success("操作成功");
    }


    /**
     * @title 授课表现
     * @description 授课表现接口
     * @author Pan Haowen
     * @url /home/coach_plan/PlanClass
     * @method POST
     * @header name:XX-Token require:1 default: desc:token
     * @param name:time type:int require:0  desc:时间搜索条件
     */
    public function PlanClass(){
        $userId = $this->getUserId();
        $coach=Db::name('coach')->where('user_id',$userId)->find();
        $param = $this->request->param();
        $where=[];
        if (!empty($param['time'])) {
            $where['c.start_time'] = [['>= time', intval($param['time'])], ['<= time', strtotime('+1 month', $param['time'])]];
        } else {
            $where['c.start_time'] = [['>= time', strtotime('+1 month', strtotime(date('Y-m', time())))], ['<= time', strtotime('+2 month', strtotime(date('Y-m', time())))]];
        }
        $data=Db::name('coach_class_apply')
            ->alias('cca')
            ->join('class c','cca.class_id=c.id')
            ->join('product p','c.product_id=p.id')
            ->where($where)
            ->where(['cca.status'=>1,'cca.coach_id'=>$coach['id'],'p.delete_time'=>null,'c.delete_time'=>null,'c.status'=>1])
            ->field('p.name as pname,c.type,cca.coach_id,c.id as cid')
            ->select()
            ->each(function ($item) {
                $item['times']=Db::name('coach_class')->where(['status'=>0,'coach_id'=>$item['coach_id'],'class_id'=>$item['cid']])->count();
                $item['star']=Db::name('user_coach_class')
                    ->alias('ucc')
                    ->join('coach_class cc','ucc.coach_class_id=cc.id')
                    ->where(['cc.status'=>0,'cc.coach_id'=>$item['coach_id'],'cc.class_id'=>$item['cid'],'ucc.status'=>1])
                    ->avg('star');
                return $item;
            });

        $new_arr=array();
        foreach($data as $k=>$v ){
            $new_arr[$v['pname']][] = $v;
        }
        $this->success('获取数据成功',$new_arr);
    }

}