<?php
namespace app\inter\controller;

use think\Controller;
use think\Db;
use think\Session;
use app\inter\model\TemplateModel;
use app\common\library\ResultTools;
use think\Request;
use app\common\library\CheckTools;
use app\common\library\ErrorConstant;
use app\common\library\UUIDs;
use think\Cache;

class Template extends Base
{

    /*//获取全部模版
    public function getAll(){
        try{
            $sessionid = $_REQUEST['sessionid'];
            $info = Cache::get($sessionid);
            if (!$info){
                $info = ['id'=>'test'];
            }

            $publicTemplates = TemplateModel::all(function($query){
                $query->where('is_public', 1);
            });

            $privateTemplates = TemplateModel::all(function($query) use($info) {
                $query->where('is_public', 2)
                    ->where('create_user', $info['id']);
            });

            return ResultTools::success(['publicTemplates'=>$publicTemplates, 'privateTemplates'=>$privateTemplates],$sessionid);
        }catch(\Exception $e){
            return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
        }

    }

    //     保存模版
    public function save(){
        try{
            $sessionid = $_REQUEST['sessionid'];
            $doctor         = Cache::get($sessionid);
            $param          = Request::instance()->param();

            if (!$doctor){
                $doctor = ['id'=>'test'];
            }

            if (!CheckTools::checkParamsNotNull($param, ['title', 'is_public', 'checkid', 'impression', 'description'])){
                //参数错误
                return ResultTools::faile(ErrorConstant::$PARAM_ERROR['code'], ErrorConstant::$PARAM_ERROR['msg'],$sessionid);
            }

            $template = new TemplateModel([
                'id'=>UUIDs::uuid16(),
                'title'=>$param['title'],
                'is_public'=>$param['is_public'],
                'create_user'=>$doctor['id'],
                'checkid'=>$param['checkid'],
                'impression'=>$param['impression'],
                'description'=>$param['description'],
                'createdAt'=>date("Y-m-d H:i:s",time())
            ]);

            $template->save();
            return ResultTools::success($template,$sessionid);
        }catch(\Exception $e){
            return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
        }

    }

    //更新模版
    public function update(){
        try{
            $sessionid = $_REQUEST['sessionid'];
            $doctor         = Cache::get($sessionid);
            $param          = Request::instance()->param();

            if (!CheckTools::checkParamsNotNull($param, ['id','title', 'is_public', 'checkid', 'impression', 'description'])){
                //参数错误
                return ResultTools::faile(ErrorConstant::$PARAM_ERROR['code'], ErrorConstant::$PARAM_ERROR['msg'],$sessionid);
            }

            $template = TemplateModel::get($param['id']);
            if (!$template){
                return ResultTools::faile(ErrorConstant::$PARAM_ERROR['code'], ErrorConstant::$PARAM_ERROR['msg'],$sessionid);
            }

            $template->title        = $param['title'];
            $template->is_public    = $param['is_public'];
            $template->checkid      = $param['checkid'];
            $template->impression   = $param['impression'];
            $template->description  = $param['description'];

            $template->save();
            return ResultTools::success('OK',$sessionid);
        }catch(\Exception $e){
            return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
        }

    }*/


    /**
     * 删除私有模板
     *
     * @ApiTitle            (删除私有模板)
     * @ApiSummary          (删除私有模板)
     * @ApiSector           (远程诊断)
     * @ApiMethod           (POST)
     * @ApiRoute            (/inter/template/delete_template)
     * @ApiHeaders        (name="sign", type="string", required=true, description="请求头-校验key")
     * @ApiHeaders        (name="nonce", type="string", required=true, description="请求头-随机数")
     * @ApiHeaders        (name="timestamp", type=string, required=true, description="请求头-时间戳s")
     * @ApiParams         (name="sessionid",                 type="string",      required=true,      description="参数json字符串")
     * @ApiParams         (name="param",                     type="string",      required=true,      description="参数json字符串")
     * @ApiParams         (name="param[id]",        type="string",      sample="",          description="模板id<必填>")
     * @ApiReturnParams   (name="status",                      type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
     * @ApiReturnParams   (name="code",                      type="integer",     required=true,      sample="0", description="返回状态码")
     * @ApiReturnParams   (name="info",                       type="string",      required=true,      sample="返回成功", description="返回信息")
     * @ApiReturnParams   (name="sessionid",                      type="object",      sample="{}",        description="缓存的数据key")
     * @ApiReturn   (data="
    {
    'status': ok,
    'code': '0000',
    'sessionid': 'a17z7a7a8f9g9rh9d89jio',
    'info' : ''
    }
     *")
     **/
    public function delete_template(){
        try{
            $sessionid = $_REQUEST['sessionid'];
            $id          = Request::instance()->param('id');
            DB::table('templates')->where('id',$id)->delete();
            return ResultTools::success('OK',$sessionid);
        }catch(\Exception $e){
            return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
        }

    }
    /**
     * 新增私有模板
     *
     * @ApiTitle            (新增私有模板)
     * @ApiSummary          (新增私有模板)
     * @ApiSector           (远程诊断)
     * @ApiMethod           (POST)
     * @ApiRoute            (/inter/template/add_template)
     * @ApiHeaders        (name="sign", type="string", required=true, description="请求头-校验key")
     * @ApiHeaders        (name="nonce", type="string", required=true, description="请求头-随机数")
     * @ApiHeaders        (name="timestamp", type=string, required=true, description="请求头-时间戳s")
     * @ApiParams         (name="sessionid",                 type="string",      required=true,      description="参数json字符串")
     * @ApiParams         (name="param",                     type="string",      required=true,      description="参数json字符串")
     * @ApiParams         (name="param[label]",        type="string",      sample="",          description="模板标题<必填>")
     * @ApiParams         (name="param[id]",        type="string",      sample="",          description="模板id<二级模板必填>")
     * @ApiParams         (name="param[impression]",        type="string",      sample="",          description="影响所见<二级模板必填>")
     * @ApiParams         (name="param[description]",        type="string",      sample="",          description="意见建议<二级模板必填>")
     * @ApiParams         (name="param[exam_class_id]",        type="string",      sample="",          description="模板归属检查类id<必填>")
     * @ApiReturnParams   (name="status",                      type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
     * @ApiReturnParams   (name="code",                      type="integer",     required=true,      sample="0", description="返回状态码")
     * @ApiReturnParams   (name="info",                       type="string",      required=true,      sample="返回成功", description="返回信息")
     * @ApiReturnParams   (name="sessionid",                      type="object",      sample="{}",        description="缓存的数据key")
     * @ApiReturn   (data="
    {
    'status': ok,
    'code': '0000',
    'sessionid': 'a17z7a7a8f9g9rh9d89jio',
    'info' : ''
    }
     *")
     **/
    public function add_template(){
        $param = $_REQUEST['param'];
        $sessionid = $_REQUEST['sessionid'];
        $doctor = Cache::get($sessionid);
        $info = array();
        $info['id'] = UUIDs::uuid16();
        $info['title'] = $param['label'];
        $info['createdAt'] = date('Y-m-d H:i:s',time());
        $info['is_public'] = 2;
        $info['create_user'] = $doctor['id'];
        if(isset($param['id']) && !empty($param['id'])){
            $t = DB::table('templates')->where('title',$param['label'])->where('is_public',2)->where('parent_id',$param['id'])->find();
            if($t){
                return json_encode(['status'=>'fail','code'=>'1013','msg'=>'已存在相同的模板标题，请重新填写']);
            }
            //存在id值  则为添加二级类
            $exam = DB::table('templates')->where('id',$param['id'])->field('exam_class_id')->find();
            $info['exam_class_id'] = $exam['exam_class_id'];
            $info['parent_id'] = $param['id'];
            $info['impression'] = $param['impression'];
            $info['description'] = $param['description'];
        }else{
            $t = DB::table('templates')->where('title',$param['label'])->where('is_public',2)->where('parent_id',0)->find();
            if($t){
                return json_encode(['status'=>'fail','code'=>'1013','msg'=>'已存在相同的模板标题，请重新填写']);
            }
            //添加一级类
            $info['exam_class_id'] = $param['exam_class_id'];
            $info['parent_id'] = 0;
        }
        DB::table('templates')->insert($info);
        return json_encode(['status'=>'ok','code'=>'0000','info'=>$info['id'],'msg'=>'新增成功']);
    }
    /**
     * 修改模板内容
     *
     * @ApiTitle            (修改模板内容)
     * @ApiSummary          (修改模板内容)
     * @ApiSector           (远程诊断)
     * @ApiMethod           (POST)
     * @ApiRoute            (/inter/template/update_template)
     * @ApiHeaders        (name="sign", type="string", required=true, description="请求头-校验key")
     * @ApiHeaders        (name="nonce", type="string", required=true, description="请求头-随机数")
     * @ApiHeaders        (name="timestamp", type=string, required=true, description="请求头-时间戳s")
     * @ApiParams         (name="sessionid",                 type="string",      required=true,      description="参数json字符串")
     * @ApiParams         (name="param",                     type="string",      required=true,      description="参数json字符串")
     * @ApiParams         (name="param[id]",        type="string",      sample="",          description="模板id<必填>")
     * @ApiParams         (name="param[label]",        type="string",      sample="",          description="模板标题<必填>")
     * @ApiReturnParams   (name="status",                      type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
     * @ApiReturnParams   (name="code",                      type="integer",     required=true,      sample="0", description="返回状态码")
     * @ApiReturnParams   (name="msg",                       type="string",      required=true,      sample="返回成功", description="返回消息")
     * @ApiReturn   (data="
    {
    'status': ok,
    'code': '0000',
    'msg': '修改成功',
    'info' : ''
    }
     *")
     **/
    public function update_template(){
        $param = $_REQUEST['param'];
        $param['title'] = $param['label'];
        unset($param['label']);
        $a = DB::table('templates')->where('id',$param['id'])->update($param);
        if($a){
            return json_encode(['status'=>'ok','code'=>'0000','msg'=>'修改成功']);
        }
    }

    /**
     * 修改详情页信息
     *
     * @ApiTitle            (修改详情页信息)
     * @ApiSummary          (修改详情页信息)
     * @ApiSector           (远程诊断)
     * @ApiMethod           (POST)
     * @ApiRoute            (/inter/template/save_info)
     * @ApiHeaders        (name="sign", type="string", required=true, description="请求头-校验key")
     * @ApiHeaders        (name="nonce", type="string", required=true, description="请求头-随机数")
     * @ApiHeaders        (name="timestamp", type=string, required=true, description="请求头-时间戳s")
     * @ApiParams         (name="sessionid",                 type="string",      required=true,      description="参数json字符串")
     * @ApiParams         (name="id",        type="string",      sample="",          description="模板id<必填>")
     * @ApiReturnParams   (name="status",                      type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
     * @ApiReturnParams   (name="code",                      type="integer",     required=true,      sample="0", description="返回状态码")
     * @ApiReturnParams   (name="info",                       type="string",      required=true,      sample="返回成功", description="返回信息")
     * @ApiReturn   (data="
    {
    'status': ok,
    'code': '0000',
    'info' : ''
    }
     *")
     **/
    public function save_info(){
        $id = $_REQUEST['id'];
        $info = DB::table('templates')->where('id',$id)->field('title as label,impression,description,exam_class_id,parent_id')->find();
        if($info['parent_id'] != 0){
            $p = DB::table('templates')->where('id',$info['parent_id'])->field('title')->find();
            $info['title'] = $p['title'];
        }
        unset($info['parent_id']);
        return json_encode(['status'=>'ok','code'=>'0000','info'=>$info]);
    }


    /**
     * 一级菜单下拉  私有模板
     *
     * @ApiTitle            (一级菜单下拉  私有模板)
     * @ApiSummary          (一级菜单下拉  私有模板)
     * @ApiSector           (远程诊断)
     * @ApiMethod           (POST)
     * @ApiRoute            (/inter/template/private_menu)
     * @ApiHeaders        (name="sign", type="string", required=true, description="请求头-校验key")
     * @ApiHeaders        (name="nonce", type="string", required=true, description="请求头-随机数")
     * @ApiHeaders        (name="timestamp", type=string, required=true, description="请求头-时间戳s")
     * @ApiParams         (name="sessionid",                 type="string",      required=true,      description="参数json字符串")
     * @ApiParams         (name="exam_class",        type="string",      sample="",          description="检查类id<必填>")
     * @ApiReturnParams   (name="status",                      type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
     * @ApiReturnParams   (name="code",                      type="integer",     required=true,      sample="0", description="返回状态码")
     * @ApiReturnParams   (name="info",                       type="string",      required=true,      sample="返回成功", description="返回信息")
     * @ApiReturn   (data="
    {
    'status': ok,
    'code': '0000',
    'info' : ''
    }
     *")
     **/
    public function private_menu(){
        $sessionid = $_REQUEST['sessionid'];
        $doctor = Cache::get($sessionid);
//        $exam = $_REQUEST['exam_class'];
        $exam = DB::table('constant')->where('id',$_REQUEST['exam_class'])->field('constant as name')->find();
        $template = DB::table('templates')->where('exam_class_id',$exam['name'])->where('create_user',$doctor['id'])->where('is_public',2)->where('parent_id',0)->select();
        return json_encode(['status'=>'ok','code'=>'0000','info'=>$template]);
    }
    /**
     * 模板内检查类下拉列表
     *
     * @ApiTitle            (模板内检查类下拉列表)
     * @ApiSummary          (模板内检查类下拉列表)
     * @ApiSector           (远程诊断)
     * @ApiMethod           (POST)
     * @ApiRoute            (/inter/template/exam)
     * @ApiHeaders        (name="sign", type="string", required=true, description="请求头-校验key")
     * @ApiHeaders        (name="nonce", type="string", required=true, description="请求头-随机数")
     * @ApiHeaders        (name="timestamp", type=string, required=true, description="请求头-时间戳s")
     * @ApiParams         (name="sessionid",                 type="string",      required=true,      description="参数json字符串")
     * @ApiReturnParams   (name="status",                      type="integer", required=true, sample="0", description="返回码 fail 失败 ok成功"))
     * @ApiReturnParams   (name="code",                      type="integer",     required=true,      sample="0", description="返回状态码")
     * @ApiReturnParams   (name="info",                       type="string",      required=true,      sample="返回成功", description="返回信息")
     * @ApiReturn   (data="
    {
    'status': ok,
    'code': '0000',
    'info' : ''
    }
     *")
     **/
    public function exam(){
//        $sessionid = $_REQUEST['sessionid'];
//        $doctor = Cache::get($sessionid);
        $exam = DB::table('constant')->where('parent_id','exam_class')->field(['id','constant_value as name'])->select();
        return json_encode(['status'=>'ok','code'=>'0000','info'=>$exam]);
    }
}