ris_dm/server/application/api/model/application/ApplicationModel.php

<?php
namespace app\api\model\application;

use app\api\model\bbs\BbsModel;
use app\api\model\department\DepartmentModel;
use app\api\model\doctor\DoctorModel;
use app\api\model\doctorclass\DoctorClassModel;
use app\api\model\exam\ExamModel;
use app\api\model\institution\InstitutionModel;
use app\api\model\message\MessageModel;
use app\api\model\order\OrderModel;
use app\api\model\patient\PatientModel;
use app\api\model\payprogresslog\PayprogresslogModel;
use app\api\model\rcontact\RcontactModel;
use app\api\model\register\RegisterModel;
use app\api\model\rcost\RcostModel;
use app\api\model\remote\RemoteModel;
use app\api\model\report\PublicReportModel;
use app\api\model\report\ReportModel;
use app\api\model\scontant\ScontantModel;
use app\api\model\water\WaterModel;
use app\api\model\ZskkDefaultModel;
use app\api\model\inspect\InspectModel;
use think\facade\Log;

class ApplicationModel extends ZskkDefaultModel {
    protected $table= 'remote_application';
    protected $logName = "ApplicationModel";
    protected $connection = 'db_config_public';


    public function getTemplateInfo($patientId,$institution){
        $patient = ExamModel::where('patient_id',$patientId)->field('patient_num AS pnum,name AS pname,SEX AS sex,AGE AS age')->find();
        $institutionInfo = InstitutionModel::where('id',$institution)->field('NAME AS institution_name')->find();
        $info = array_merge((json_decode(json_encode($patient),true)) ?? [],(json_decode(json_encode($institutionInfo),true)) ?? []);
        return $info;
    }

    public function checkApply($id)
    {
        $info = DoctorClassModel::where('doctor_id',$id)->value('doctor_class');
        return $info;
    }

    public function getPatientId($id)
    {
        $info = ExamModel::where('id',$id)->value('patient_id');
        return $info;
    }

    public function getExam($id,$examField){
        $info = ExamModel::where('id',$id)->field($examField)->find();
        return $info;
    }

    public function getRegister($id,$field)
    {
        $info = RegisterModel::where ('exam_id',$id)->field($field)->find();
        return $info;
    }

    public function getRemoteApplication($id)
    {
        try{
            $info = RemoteModel::alias('r')
                ->join(['remote_order'=>'ro'],'r.id=ro.application_id')
                ->where('r.exam_id',$id)
                ->field('r.id,exam_id')
                ->order('ro.createdAt desc')
                ->find();
            if(empty(json_decode(json_encode($info),true))){
                // 为空 代表没有已发起申请的数据
                $info['is_apply'] = '0';
                $info['exam_id'] = $id;
            }else{
                $info['is_apply'] = '1';
            }
            return $info;
        }catch(\Exception $e){
            $this->throwError($e->getMessage(),0001);
        }
    }

    public function getApplication($id)
    {
        $info = $this->where('id',$id)->find();
        $info['application_id'] = $id;
        return $info;
    }

    public function updateExam($id,$phone)
    {
        ExamModel::where('id',$id)->update(['phone'=>$phone]);
        $patient_id = ExamModel::where('id',$id)->value('patient_id');
        PatientModel::where ('id',$patient_id)->update(['phone'=>$phone]);
        return true;
    }

    public function updateOrder($id,$update)
    {
        $data = OrderModel::where('id',$id)->update($update);
        return $data;
    }

    public function getStep1Data($id,$field)
    {
        $info = ExamModel::alias('e')
            ->join(['register'=>'r'],'r.exam_id=e.id','LEFT')
            ->where('e.id',$id)
            ->field($field)
            ->find();
        return $info;
    }

    public function getPatient($patientId,$patientField){
        $info = PatientModel::where('id',$patientId)->field($patientField)->find();
        return $info;
    }

    public function getApplicationId($examId)
    {
        $id = $this->where('exam_id',$examId)->where('report_status','in','2,3')->value('id');
        return $id;
    }

    public function updateApplication($info,$id){
        $data = $this->where('id',$id)->update($info);
        return $data;
    }

    public function insertRemoteWater($data)
    {
        WaterModel::insert($data);
    }

    public function insertRemoteOrder($data)
    {
        OrderModel::insert($data);
    }

    public function getInstitution($id,$field)
    {
        $info = InstitutionModel::where('id',$id)->field($field)->find();
        return $info;
    }

    public function getDoctorMoney($hospital_id,$super_hospital_id,$super_doctor_id,$exam_class)
    {
        $money = RcostModel::where('hospital_id',$hospital_id)->where('super_hospital_id',$super_hospital_id)->where('super_doctor_id',$super_doctor_id)->where('exam_class',$exam_class)->value('money');
        if(empty($money)){
            $money = 0;
            // $this->throwError('未配置相应类型的花费，请与管理员联系','9000');
        }
        return $money;
    }

    public function updateInstitutionInfo($id,$update)
    {
        $info = InstitutionModel::where('id',$id)->update($update);
        return $info;
    }

    public function getContactType($local,$remote)
    {
        $info = RcontactModel::where('hospital_id', $local)
            ->where('super_hospital_id', $remote)
            ->value('pay_type');
        return $info;
    }

    public function getRemoteOrder($application_id,$cancel,$reduce)
    {
        $info = OrderModel::where('application_id', $application_id)
            ->where('status', 'neq', $cancel)
            ->where('status', 'neq', $reduce)
            ->field('id')
            ->find();
        return $info;
    }

    public function getRemoteOrderInfo($id,$field)
    {
        $info = OrderModel::where('id',$id)->field($field)->find();
        return $info;
    }

    public function insertAplication($info)
    {
        $data = $this->insert($info);
        return $data;
    }

    public function getApplyingInfo($id)
    {
        $data = $this->where('exam_id',$id)->where('report_status','in','2,3')->find();
        return $data;
    }

    public function saveInspect($info)
    {
        $data = InspectModel::insert($info);
        return $data;
    }

    public function getReport($applicationId){
        $data = ReportModel::where('remote_application_id',$applicationId)->find();
        return $data;
    }

    public function getApplicationInfo($examId,$field)
    {
        $data = $this->where('exam_id',$examId)->field($field)->find();
        return $data;
    }

    public function getApplicationById($id,$field)
    {
        $data = $this->where('id',$id)->field($field)->find();
        return $data;
    }

    public function getDoctorInfo($id)
    {
        $info = DoctorModel::where('id',$id)->find();
        return $info;
    }

    public function getOrderStatus($id)
    {
        $status = OrderModel::where('application_id',$id)->value('status');
        return $status;
    }

    public function getInspect($id)
    {
        $data = InspectModel::where('remote_id',$id)->find();
        return $data;
    }

    public function getDoctorName($id)
    {
        $name = DoctorModel::where('id',$id)->value('realname');
        return $name;
    }

    public function getPay($id)
    {
        $pay = InstitutionModel::where('id',$id)->value('is_pay');
        return $pay;
    }

    public function saveReport($info)
    {
        $data =  PublicReportModel::insert($info);
        return $data;
    }

    public function checkStatus($id)
    {
        $status = $this->where('id',$id)->value('report_status');
        return $status;
    }

    public function updateStatus($id,$status,$doctor)
    {
        if(in_array($status,['5','6'])){
            $info = $this->where('id',$id)->update(['report_status'=>$status,'remote_doctor_id'=>$doctor['id'],'remote_doctor_name'=>$doctor['realname']]);
        }else{
            $info = $this->where('id',$id)->update(['report_status'=>$status]);
        }
        MessageModel::where('application_id',$id)->where('type',1)->update(['notice'=>1]);
        $examId = $this->where('id',$id)->value('exam_id');
        ExamModel::where('id',$examId)->update(['report_status'=>$status]);
        return $info;
    }

    public function getContact($id)
    {
        $info = ScontantModel::where('id',$id)->find();
        return $info;
    }

    public function getInstitutionName($id)
    {
        $name = InstitutionModel::where('id',$id)->value('name');
        return $name;
    }

    public function saveBbs($info)
    {
        $data = BbsModel::insert($info);
        return $data;
    }

    public function readMessage($aid,$uid)
    {
        $info = MessageModel::where('application_id',$aid)->where('doctor_id',$uid)->update(['is_read'=>1]);
        return $info;
    }

    public function getBbsByApp($id)
    {
        $info = BbsModel::alias('b')
            ->join(['doctors'=>'d'],'d.id=b.initiator','LEFT')
            ->where('remote_application_id',$id)
            ->field('b.*,d.realname')
            ->order('createdAt desc')
            ->select();
        return $info;
    }

    public function insertMessage($data)
    {
        $info = MessageModel::insert($data);
        return $info;
    }

    public function getInsId($id)
    {
        $data = DoctorModel::where('id',$id)->field('institution_id,department_id')->find();
        return $data;
    }

    public function savePregressLog($log)
    {
        PayprogresslogModel::insert($log);
    }
}