yuanchengpasc/application/inter/controller/Report.php

<?php
namespace app\inter\controller;

use think\Controller;
use think\Db;
use think\Session;
use app\common\library\ResultTools;
use think\Cache;
use think\Log;
use think\Request;

class Report extends Base
{
    /**
     * 科室报告列表
     *
     * @ApiTitle            (科室报告列表)
     * @ApiSummary          (科室报告列表)
     * @ApiSector           (远程诊断)
     * @ApiMethod           (POST)
     * @ApiRoute            (/inter/report/index)
     * @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="page",                 type="string",      required=true,      description="当前页")
     * @ApiParams         (name="num",                 type="string",      required=true,      description="每页显示条数")
     * @ApiParams         (name="param[name]",           type="string",      sample="",          description="患者姓名<选填>")
     * @ApiParams         (name="param[patient_num]",        type="string",      sample="",          description="预约登记exams表id值<选填>")
     * @ApiParams         (name="param[accession_num]",            type="string",      sample="",          description="检查号<选填>")
     * @ApiParams         (name="param[exam_status]",                  type="string",      sample="",          description="检查状态<选填>")
     * @ApiParams         (name="param[exam_class]",            type="string",      sample="",          description="检查类<选填>")
     * @ApiParams         (name="param[exam_datetime]",   type="string",      sample="",          description="申请时间<选填>")
     * @ApiParams         (name="param[urgent]",           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="info",                       type="string",      required=true,      sample="返回成功", description="返回信息")
     * @ApiReturnParams   (name="msg",                       type="string",      required=true,      sample="返回成功", description="返回消息")
     * @ApiReturnParams   (name="sessionid",                      type="object",      sample="{}",        description="缓存的数据key")
     * @ApiReturnParams   (name="count",                      type="object",      sample="{}",        description="总条数")
     * @ApiReturn   (data="
    {
    'status': ok,
    'code': '0000',
    'sessionid': 'a17z7a7a8f9g9rh9d89jio',
    'info' : ''
    'count' : '110'
    }
     *")
     **/
    public function  index(){
        try{
            $sessionid = Request::instance()->param('sessionid');
            $doctor = Cache::get($sessionid);
            if(!$doctor){
                return ResultTools::faile('1008', '您还未登录',$sessionid);
            }
            $eclass = DB::table('doctors')->where('id',$doctor['id'])->field('exam_class')->find();
            if($eclass['exam_class'] != '*'){
                $class = explode(',',$eclass['exam_class']);
                $e_class = implode('\',\'',$class);
                $where = ' and  a.exam_class in (\''.$e_class.'\') ';
            }else{
                $where = '';
            }
//            $is_urgent = $_REQUEST['is_remote'];
//            $table = '';
            $order = ' order by a.urgent desc,a.createdAt desc';
            /*if($is_urgent == 1){
                //是远程报告
                $table = ',remote_application as r ';
                $where = ' and a.is_remote=1';
                $order = ' order by r.is_urgent desc';
            }*/
            log::record('-------------');
            log::record($_REQUEST);
            log::record('-------------');
            if(isset($_REQUEST['param'])){
                $search = $_REQUEST['param'];
                foreach($search as $k => $v){
                    switch($k){
                        case 'name':
                            if(empty($v)){
                                break;
                            }
                            $where .= ' and p.name like \''.$v.'%\'';
                            break;
                        case 'local_institution_id':
                            if(empty($v)){
                                break;
                            }
                            $where .= " and r.".$k."='".$v."' and r.exam_id=a.id";
                            break;
                        case 'urgent':
                            if(empty($v)){
                                break;
                            }
                            if($v == 'true'){
                                $v = 1;
                            }else{
                                break;
                            }
                            $where .= " and a.".$k."='".$v."'";
                            break;
                        case 'report_result':
                            if($v == 2){
                                $where .= " and r.report_result=2";
                            }elseif($v == 1){
                                $where .= " and r.report_result=1";
                            }{
                            break;
                        }
                            break;
                        case 'exam_datetime':
                            if(empty($v)){
                                break;
                            }
                            $data1 = str_replace('-', '',$v[0]);
                            $data2 = str_replace('-', '',$v[1]);
                            if($data1 == $data2){
                                $where .= " and a.exam_datetime='$data1'";
                            }else{
                                $where .= " and a.exam_datetime between '$data1' and '$data2'";
                            }
                            break;
                        case 'exam_status':
                            if($v != 10 && !empty($v)){
                                $where .= " and a.exam_status=".$v;
                            }else{
                                $where .= " and a.exam_status>2";
                            }
                            break;
                        case 'exam_class' :
                            if(empty($v)){
                                break;
                            }
                            $ex = implode('\',\'',$v);
                            $where .= " and a.exam_class in ('".$ex."')";
                            break;
                        case 'report_status':
                            if($v != 10 && !empty($v)){
                                $where .= " and ra.report_status=".$v;
                            }
                            break;
                        default :
                            if(empty($v)){
                                break;
                            }
                            $where .= " and a.".$k."='".$v."'";
                    }
                }
            }
            $page = $_REQUEST['page'];
            $num = $_REQUEST['num'];
            $fnum = ($page-1)*$num;
            $limit = " limit ".$fnum.",".$num;
            /*if(empty($where)){
                // 急诊sql  待处理
                $sql1 = "SELECT a.id,a.urgent,a.is_remote,a.patient_num,a.study_id,a.exam_datetime,a.exam_project,a.exam_status,a.exam_class,p.name,p.sex,p.age FROM exams as a,patient_infos as p where a.institution_id='".$doctor['institution_id']."' and p.id=a.patient_id and a.urgent=1 and a.exam_status in (".$dclass['doctor_class'].")";
                //非急诊 待处理
                $sql2 = "SELECT a.id,a.urgent,a.is_remote,a.patient_num,a.study_id,a.exam_datetime,a.exam_project,a.exam_status,a.exam_class,p.name,p.sex,p.age FROM exams as a,patient_infos as p where a.institution_id='".$doctor['institution_id']."' and p.id=a.patient_id and a.urgent!=1  and a.exam_status in (".$dclass['doctor_class'].")";
                //已处理
                $sql3 = "SELECT a.id,a.urgent,a.is_remote,a.patient_num,a.study_id,a.exam_datetime,a.exam_project,a.exam_status,a.exam_class,p.name,p.sex,p.age FROM exams as a,patient_infos as p where a.institution_id='".$doctor['institution_id']."' and p.id=a.patient_id and a.exam_status  not in (".$dclass['doctor_class'].")";

                $sql = '('.$sql1.') union ('.$sql2.') union ('.$sql3.')'.$limit;
            }else{*/
            $field = 'a.id,a.severe,a.urgent,a.accession_num,a.patient_num,a.report_result,a.study_id,a.exam_datetime,a.exam_project,a.exam_status,a.exam_class,a.application_doctor,a.application_department,p.name,p.sex,p.age,ra.report_status,i.name as report_app_name,ep.name as exam_project_name,r.report_datetime,dr.realname as report_doctor,dv.realname as review_doctor';
            $list = DB::table('exams')
                ->alias('a')
                ->join(['patient+info'=>'p'],'p.id=a.patient_id and a.status=1 and a.exam_status>2')
                ->join(['institution'=>'i'],'i.id=a.institution_id')
                ->join(['report'=>'r'],'a.id=r.exam_id and r.type=1','left')
                ->join(['doctors'=>'dr','dr.id=r.report_doctor_id','left'])
                ->join(['doctors'=>'dv','dv.id=r.review_doctor_id','left'])
                ->join(['remote_application'=>'ra'],'ra.exam_id=a.id','left')
                ->join(['exam_project'=>'ep'],'ep.id=a.exam_project','left')
                ->where('a.institution_id=\''.$doctor['institution_id'].'\'')
                ->where($where)
                ->order('a.createdAt desc')
                ->limit($limit)
                ->buildSql();
            var_dump($list);die;
            $count = DB::table('exams')
                ->alias('a')
                ->join(['patient+info'=>'p'],'p.id=a.patient_id and a.status=1 and a.exam_status>2')
                ->join(['institution'=>'i'],'i.id=a.institution_id')
                ->join(['report'=>'r'],'a.id=r.exam_id and r.type=1','left')
                ->join(['doctors'=>'dr','dr.id=r.report_doctor_id','left'])
                ->join(['doctors'=>'dv','dv.id=r.review_doctor_id','left'])
                ->join(['remote_application'=>'ra'],'ra.exam_id=a.id','left')
                ->join(['exam_project'=>'ep'],'ep.id=a.exam_project','left')
                ->where('a.institution_id=\''.$doctor['institution_id'].'\'')
                ->where($where)
                ->count();
//            $sql = "SELECT a.id,a.severe,a.urgent,a.accession_num,a.patient_num,a.report_result,a.study_id,a.exam_datetime,a.exam_project,a.exam_status,a.exam_class,a.application_doctor,a.application_department,p.name,p.sex,p.age,ra.report_status FROM (exams as a,patient_infos as p) LEFT JOIN remote_application as ra on ra.exam_id=a.id where a.institution_id='".$doctor['institution_id']."' and p.id=a.patient_id and a.status=1 and a.exam_status>2 ".$where." order by a.createdAt desc".$limit;
//            }
            // if($doctor['institution_id'] == '13000003' and $page == 1 and empty($where)){
            //     if(Cache::get('13000003_2')){
            //         $list = Cache::get('13000003_2');
            //     }else{
            //         $list = DB::query($sql);
            //         Cache::set('13000003_2',$list,86400);
            //     }
            // }else{
            //     $list = DB::query($sql);
            // }
//            $list = DB::query($sql);
//            $csql = "SELECT count(1) FROM (exams as a,patient_infos as p) LEFT JOIN remote_application as ra on ra.exam_id=a.id where a.institution_id='".$doctor['institution_id']."' and p.id=a.patient_id and a.status=1  and a.exam_status>2 ".$where;
//            $count = DB::query($csql);
//            log::record('请求的sql语句');
//            log::record($sql);
//            log::record('请求到的数据');
//            log::record($list);
//            foreach ($list as $k => $v) {
//                $cache_key = $doctor['id'].'_'.$v['id'];
//                if(Cache::get($cache_key)){
//                    $list[$k]['status'] = 1;
//                }else{
//                    $list[$k]['status'] = 0;
//                }
//                $remote_name = DB::table('institution')->where('id',$doctor['institution_id'])->field('name')->find();
//                $list[$k]['report_app_name'] = $remote_name['name'];
//                $project = DB::table('exam_project')->where('id',$v['exam_project'])->field('name')->find();
//                $list[$k]['exam_project_name'] = $project['name'];
//                $report = DB::table('report')->where('exam_id',$v['id'])->field('report_datetime,report_doctor_id,review_doctor_id')->find();
//                if($report){
//                    $report_doctor = DB::table('doctors')->where('id',$report['report_doctor_id'])->field('realname')->find();
//                    $review_doctor = DB::table('doctors')->where('id',$report['review_doctor_id'])->field('realname')->find();
//                    $list[$k]['review_doctor'] = $review_doctor['realname'];
//                    $list[$k]['report_doctor'] = $report_doctor['realname'];
//                    $list[$k]['report_datetime'] = $report['report_datetime'];
//                }else{
//                    $list[$k]['report_doctor'] = '';
//                    $list[$k]['report_datetime'] = '';
//                }
//            }
            return json_encode(['status'=>'ok','code'=>'0000','count'=>$count,'info'=>$list,'sessionid'=>$sessionid]);
        }catch(\Exception $e){
            return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
        }

    }

    public function del()
    {
        $id = $_REQUEST['id'];
        $sessionid = Request::instance()->param('sessionid');
        $user = Cache::get($sessionid);
        $info = DB::table('exams')->where('id',$id)->update(['status'=>0,'del_time'=>date('Y-m-d H:i:s',time()),'del_doctor_name'=>$user['realname']]);
        if($info){
            return json_encode(['status'=>'ok','code'=>'0000']);
        }else{
            return json_encode(['status'=>'fail','code'=>'2000','msg'=>'删除失败']);
        }
    }

}