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

use app\api\model\api\ApiModel;
use app\api\model\bodypart\DictbodyModel;
use app\api\model\doctor\DoctorModel;
use app\api\model\exam\ExamModel;
use app\api\model\image\ImageModel;
use app\api\model\imagenode\ImagenodeModel;
use app\api\model\institution\InstitutionModel;
use app\api\model\moneywater\MoneywaterModel;
use app\api\model\patient\PatientModel;
use app\api\model\patientsearch\PatientsearchModel;
use app\api\model\remote\RemoteModel;
use app\api\model\report\ReportModel;
use app\api\model\share\ShareModel;
use app\api\model\speciallog\SpeciallogModel;
use app\api\model\user\UserModel;
use app\api\model\ZskkDefaultModel;
use think\Exception;
use think\facade\Log;
use app\api\model\studies\StudiesModel;

class XzModel extends ZskkDefaultModel {
    protected $table= 'xz';
    protected $logName = "XzModel";

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

    public function checkXz($where)
    {
        $data = $this->where($where)->find();
        return $data;
    }

    public function insertStudies($data)
    {
        $info = StudiesModel::insert($data);
        return $info;
    }

    public function insertPatient($data)
    {
        $info = PatientModel::insert($data);
        return $info;
    }

    public function insertExam($data)
    {
        $info = ExamModel::insert($data);
        return $info;
    }

    public function saveMoneyWater($data)
    {
        $info = MoneywaterModel::insert($data);
        return $info;
    }

    public function updateStatus($where,$status)
    {
        $info = $this->where($where)
            ->update(['exam_status'=>$status]);
        return  $info;
    }

    public function getXzData($id)
    {
        $info = $this->where('exam_id',$id)
            ->find();
        return $info;
    }

    public function getExamData($id)
    {
        $info = ExamModel::where('id',$id)->select();
        return $info;
    }

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

    public function getReport($id)
    {
        $info = ReportModel::where('exam_id',$id)
            ->where('type',1)
            ->find();
        return $info;
    }

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

    public function updateStudies($id,$examId)
    {
        StudiesModel::where('id',$id)->update(['exam_id'=>$examId]);
    }

    public function updateXz($where,$updateXz)
    {
        $this->where($where)->update($updateXz);
    }

    public function getUid($id)
    {
        $uid = StudiesModel::where('exam_id',$id)->value('studyuid');
        return $uid;
    }

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

    public function getWaterLog($examId,$insId)
    {
        $id = MoneywaterModel::where('exam_id',$examId)->where('institution_id',$insId)->value('id');
        return $id;
    }

    public function getPushInfo($id)
    {
        $ids = PatientsearchModel::where('exam_id',$id)->distinct(true)->column('patient_uid');
        return $ids;
    }

    public function getOpenId($ids)
    {
        $openids = UserModel::where('id','in',$ids)->column('wx_openid');
        return $openids;
    }

    public function check($studyId,$studyUid,$institution)
    {
        if(empty($studyUid))
        {
            $info = ExamModel::where('study_id',$studyId)->find();
        }else{
            $info = ExamModel::where('studyuid',$studyUid)->where('institution_id',$institution)->find();
        }
        return $info;
    }

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

    public function getBodyText($body)
    {
        $info = DictbodyModel::where('en',$body)->value('zh');
        return $info;
    }
    public function getExam($key,$value,$institutionId)
    {
        $id = ExamModel::where($key,$value)->where('institution_id',$institutionId)->find();
        return $id;
    }

    public function updateExam($data,$id)
    {
        $info = ExamModel::where('id',$id)->update($data);
        return $info;
    }

    public function getStudyUid($id)
    {
        $studyuid = StudiesModel::where('id',$id)->value('studyuid');
        return $studyuid;
    }

    public function getApiAction($id,$action)
    {
        $method = ApiModel::where('hid',$id)->where('action',$action)->value('method');
        return $method;
    }

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

    public function getApi($id)
    {
        $apiIds = InstitutionModel::where('id',$id)->value('api_ids');
        return $apiIds;
    }

    public function getInterface($ids)
    {
        $info = ApiModel::whereIn('id',$ids)->select();
        return $info;
    }

    public function getApis($institution,$action)
    {
        $data = ApiModel::where('hid',$institution)->where('action',$action)->find();
        return $data;
    }

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

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

    public function getImageInfo($study)
    {
        $info = ImageModel::alias('i')
            ->join(['series'=>'s'],'s.id=i.series_id')
            ->where('s.study_id',$study)
            ->field(['i.id','i.url','i.sopUid','s.id AS series_id','s.study_id','i.sopUid'])
            ->select()
            ->toArray();
        return $info;
    }

    public function saveImageNode($data)
    {
        $info = ImagenodeModel::insertAll($data);
        return $info;
    }

    public function getImageNode($where)
    {
        $info = ImagenodeModel::where($where)->field('image_node,image_id,sop_uid')->select()->toArray();
        return $info;
    }

    public function getWjwData()
    {
        $data  = ReportModel::alias('r')
            ->join(['exams'=>'e'],'e.id=r.exam_id')
            ->where('e.exam_status',9)
            ->where("DATEDIFF(r.createdAt,NOW())=-1")
            ->where("e.institution_id like '730900%'")
            ->where("r.impression is not null")
            ->field('r.*,e.studyuid,e.institution_id,e.name')
            ->select()
            ->toArray();
        return $data;
    }

    public function saveSms($data)
    {
        $info = ShareModel::insert($data);
        return $info;
    }

    public function insertSpecialLog($url, $diff)
    {
        return SpeciallogModel::insert(['url'=>$url,'timeDiff'=>$diff]);
    }

    public function getRemoteCount()
    {
        $num = RemoteModel::where("local_institution_id like '73090%'")->count();
        return $num;
    }

    public function getYjRemote($page,$num)
    {
        $report = RemoteModel::alias('a')
            ->join(['report'=>'r'],'r.remote_application_id=a.id','left')
            ->where("a.local_institution_id like '73090%'")
            ->page($page,$num)
            ->field('r.*,a.*,r.id AS rid')
            ->select()
            ->toArray();
        return $report;
    }

    public function getYjDoctor()
    {
        $data = DoctorModel::where("institution_id like '73090%'")->select();
        return $data;
    }
}