yuanchengpasc/application/inter/controller/Application.php

<?php
namespace app\inter\controller;

use think\Controller;
use think\Db;
use think\Session;
use app\common\library\UUIDs;
use think\Cache;
use think\Log;
use app\common\library\Verify;
use think\File;
class Application extends Base
{
    public function  index(){
        try{
            $sessionid = $_REQUEST['sessionid'];
            $param = $_REQUEST['param'];
            $id = $param['id'];
            $is_remote = 0;
            if(isset($_REQUEST['is_remote']) && $_REQUEST['is_remote']==1){
                $is_remote = 1;
            }
            $info = DB::table('exams')->where('id',$id)->field('id,study_id,patient_id,register_datetime,exam_class,exam_sub_class,exam_project,device,exam_datetime')->find();
            $exam_class = DB::table('constant')->where('id',$info['exam_class'])->field('constant_value')->find();
            $exam_subclass = DB::table('exam_subclass')->where('id',$info['exam_sub_class'])->cache(300)->find();
            $exam_project = DB::table('exam_project')->where('id',$info['exam_project'])->cache(300)->find();
            $device = DB::table('device')->where('id',$info['device'])->cache(300)->find();
            $info['exam_class_name'] = $exam_class['constant_value'];
            $info['exam_subclass_name'] = $exam_subclass['name'];
            $info['exam_project_name'] = $exam_project['name'];
            $info['device_name'] = $device['name'];
            $patient_info = DB::table('patient_infos')->where('id',$info['patient_id'])->field(['id','name','sex','age','birthday'])->find();
            $info['pid'] = $patient_info['id'];
            $info['name'] = $patient_info['name'];
            $info['sex'] = $patient_info['sex'];
            $info['age'] = $patient_info['age'];
            if(!empty($patient_info['birthday'])){
                $info['birthday'] = $patient_info['birthday'];
            }
            $doctor = Cache::get($sessionid);
            $institution_id = $doctor['institution_id'];
            $hospital = DB::table('institution')->where('id',$institution_id)->find();
            $parent_hosp = explode(',',$hospital['parent_institution']);
            $parent_name = array();
            foreach($parent_hosp as $v){
                $phname = DB::table("institution")->where('id',$v)->cache(300)->field(['id','name'])->find();
                $doctor_info = DB::table('doctors')->where('institution_id',$v)->field('id,realname')->select();
                $phname['doctor'] = $doctor_info;
                $parent_name[] =$phname;
            }
            $info['parent_hospital'] = $parent_name;
            //申请信息
            $application = DB::table('remote_application')->where('exam_id',$id)->field(['req_doctor_id','illness_desc','phys_sign','clin_symp','anamnesis','family_ill','remark','clin_diag'])->find();
            if($is_remote == 1){
                //远程申请点击进入
                $dinfo = DB::table('doctors')->where('id',$application['req_doctor_id'])->field('department_id')->find();
                $dep = DB::table('department')->where('id',$dinfo['department_id'])->field('department_name')->find();
            }else{
                //本地远程申请中
                $dep = DB::table('department')->where('id',$doctor['department_id'])->field('department_name')->find();
            }
            $info['department_name'] = $dep['department_name'];
            if(empty($application)){
                $exam_application = DB::table('exams')->where('id',$id)->field(['illness_desc','phys_sign','clin_symp','remark','clin_diag','anamnesis','family_ill'])->find();
                $exam_application['anamnesis'] = explode(',',$exam_application['anamnesis']);
                $exam_application['family_ill'] = explode(',',$exam_application['family_ill']);
                $info['application'] = $exam_application;
            }else{
                $application['anamnesis'] = explode(',',$application['anamnesis']);
                $application['family_ill'] = explode(',',$application['family_ill']);
                $info['application'] = $application;
            }
            return json_encode(['status'=>'ok','code'=>'0000','info'=>$info,'sessionid'=>$sessionid,'is_remote'=>$is_remote]);
        }catch(\Exception $e){
            return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
        }
    }

    // 提交申请
    public function apply(){
        try{
            log::record($_REQUEST);
            $sessionid = $_REQUEST['sessionid'];
            $doctor = Cache::get($sessionid);
            //  远程申请权限 6
            $return  = Verify::check_role($sessionid,6);
            if($return != 1){
                return json_encode(['status'=>'fail','code'=>'1029','msg'=>'没有操作权限']);
            }
            $param = $_REQUEST['param'];
            $exam_info =  DB::table('exams')->where('id',$param['id'])->field('exam_status')->find();
            if($exam_info['exam_status'] != 3 && $exam_info['exam_status'] != 5){
                // 3 检查完毕 5已驳回
//                 return json_encode(['status'=>'fail','code'=>'1029','msg'=>'未到达申请的步骤，没有操作权限']);
            }
            Verify::applicationCheck($param);
            $application_info = array();
            $application_info['exam_id'] = isset($param['id']) ? $param['id'] : '';
            $application_info['illness_desc'] = isset($param['illness']) ? $param['illness'] : '';
            $application_info['phys_sign'] = isset($param['phys_sign']) ? $param['phys_sign'] : '';
            $application_info['clin_symp'] = isset($param['clin_symp']) ? $param['clin_symp'] : '';
            if(!empty($param['anamnesis'])){
                $application_info['anamnesis'] = implode(',',$param['anamnesis']);
            }
            if(!empty($param['family_ill'])){
                $application_info['family_ill'] = implode(',',$param['family_ill']);
            }
            $application_info['remark'] = isset($param['remark']) ? $param['remark'] : '';
            $application_info['local_institution_id'] = $doctor['institution_id'];
            $application_info['req_date_time'] = date('Y-m-d H:i:s',time());
            $application_info['clin_diag'] = isset($param['clin_diag']) ? $param['clin_diag'] : '';
            $application_info['remote_institution_id'] = isset($param['remote_institution']) ? $param['remote_institution'] : '';
            if(isset($param['is_urgent']) && $param['is_urgent'] == 'true' ){
                $application_info['is_urgent'] = 1;
            }else{
                $application_info['is_urgent'] = 0;
            }
            $application_info['application_desc'] = isset($param['description']) ? $param['description'] : '';
            $application_info['req_doctor_id'] = $doctor['id'];
            $application_info['remote_doctor_id'] = isset($param['remote_doctor_id']) ? $param['remote_doctor_id'] : '';
            $application_info['attachment'] = isset($param['attachment']) ? $param['attachment'] : '';
            if(isset($param['apply']) && !empty($param['apply'])){
                //保存  未申请
                DB::table('exams')->where('id',$param['id'])->update(['status'=>4,'updatedAt'=>date('Y-m-d H:i:s',time())]);
            }
            $remote_application = DB::table('remote_application')->where('exam_id',$param['id'])->select();
            // 申请远程
            if(empty($remote_application)){
                log::record('新增远程申请');
                $application_info['id'] = UUIDs::uuid16();
                $application_info['createdAt'] = date('Y-m-d H:i:s',time());
                DB::table('remote_application')->insert($application_info);
                $report = array();
                $report['id'] = UUIDs::uuid16();
                $report['exam_id'] = $param['id'];
                DB::table('report')->insert($report);
            }else{
                log::record('修改远程申请');
                DB::table('remote_application')->where('exam_id',$param['id'])->update($application_info);
            }
            DB::table('exams')->where('id',$param['id'])->update(['exam_status'=>4,'updatedAt'=>date('Y-m-d H:i:s',time())]);
            return json_encode(['status'=>'ok','code'=>'0000','sessionid'=>$sessionid]);
        }catch(\Exception $e){
            return json_encode(['status'=>'fail','code'=>'2000','msg'=>$e->getMessage()]);
        }
    }

    //上传附件
    public function upload(){
        // 获取表单上传文件 例如上传了001.jpg
        $file = request()->file('file');
        log::record('----------上传的文件-----------');
        log::record($file);
        // 移动到框架应用根目录/public/uploads/ 目录下
        if($file){
            $info = $file->move(ROOT_PATH . 'public' . DS . 'uploads');
            log::record($info);
            if($info){
                return json_encode(['status'=>'ok','code'=>'0000','info'=>'/'.$_SERVER["SERVER_NAME"]. '/' . 'uploads'. '/' .$info->getSaveName()]);
            }else{
                // 上传失败获取错误信息
                return json_encode(['status'=>'fail','code'=>'1040','info'=>$file->getError()]);
            }
        }
    }


    //驳回 7
    public function reject(){
        $sessionid = $_REQUEST['sessionid'];
        $doctor = Cache::get($sessionid);
        $param = $_REQUEST['param'];
        $id = $param['id'];
        $report = DB::table('report')->where('exam_id',$id)->field('id')->find();
        $info = array();
        $info['id'] = UUIDs::uuid16();
        $info['report_id'] = $report['id'];
        $info['description'] = $param['description'];
        $info['createdAt'] = date('Y-m-d H:i:s',time());
        $info['type'] = 4;
        $info['doctor_id'] = $doctor['id'];
        DB::table('report_record')->insert($info);
        $message = array();
        $message['id'] = UUIDs::uuid16();
        $message['title'] = '申请单驳回';
        $message['content'] = $param['description'];
        $message['createdAt'] = date('Y-m-d H:i:s',time());
        $did = DB::table('remote_application')->where('exam_id',$id)->field('req_doctor_id,local_institution_id')->find();
        $message['doctor_id'] = $did['req_doctor_id'];
        $message['institution_id'] = $did['local_institution_id'];
        DB::table('exams')->where('id',$id)->update(['exam_status'=>5]);
        return json_encode(['status'=>'ok','code'=>'0000','sessionid'=>$sessionid]);
    }

    public function recive(){
        $sessionid = $_REQUEST['sessionid'];
//        $doctor = Cache::get($sessionid);
        $id = $_REQUEST['id'];
        DB::table('exams')->where('id',$id)->update(['exam_status'=>6]);
        return json_encode(['status'=>'ok','code'=>'0000','sessionid'=>$sessionid]);
    }
}