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

use app\api\model\doctor\DoctorModel;
use app\api\model\rcontact\RcontactModel;
use app\api\model\scontant\ScontantModel;
use app\api\model\sremote\SremoteModel;
use app\api\model\ZskkDefaultModel;
use app\api\response\ServerResponse;
use think\facade\Log;
use app\api\model\patient\PatientModel;
use app\api\model\ExamModel;


class InstitutionModel extends ZskkDefaultModel {
    protected $table= 'institution';
    protected $logName = "InstitutionModel";
    protected $model = null;

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

    public function getPayType($local,$super)
    {
        $type = RcontactModel::where('hospital_id',$local)->where('super_hospital_id',$super)->value('pay_type');
        return $type;
    }

    public function getSpecialDoctor($id)
    {
        $info = ScontantModel::alias('sc')
            ->join('doctors d', 'sc.did = d.id')
            ->join('institution i', 'sc.hid = i.id')
            ->join('doctor_class dc', 'dc.doctor_id=d.id and find_in_set("7", dc.doctor_class)')
            ->where('sc.sid',$id)
            ->where('sc.status',1)
            ->order('sc.sort asc')
            ->field('sc.id AS scid,sc.sid,sc.did AS id,sc.hid, convert(sc.cost/100,decimal(10,2)) AS cost, sc.describe AS introduce,i.name AS institution_name, d.realname')
            ->select();
        return $info;
    }

    public function getRemoteIns($id)
    {
        $info = RcontactModel::where('hospital_id',$id)->select();
        $data = array_column($info,'super_hospital_id');
        return $data;
    }

    public function getSpecialIns()
    {
        $info = SremoteModel::where('status',1)
            ->order('sort asc')
            ->field('id, name AS hospital_name,1 AS is_special')
            ->select();
        return $info;
    }

    public function getDoctor($id,$class,$remote)
    {
//        $info = DoctorModel::alias('d')
//            ->join('doctor_class dc','dc.doctor_id=d.id and find_in_set("7", dc.doctor_class)')
//            ->join('remote_cost rc',"rc.super_doctor_id=d.id and rc.exam_class='".$class."' and super_hospital_id=d.institution_id and hospital_id='".$remote."'")
//            ->where('d.institution_id',$id)
//            ->where('d.is_admin','1')
//            ->field('d.id,d.institution_id AS hid,d.realname,convert(rc.money/100,decimal(10,2)) AS cost,introduce,null AS scid,null AS sid')
//            ->select();
//        if(empty(json_decode(json_encode($info),true))){
//            $info = DoctorModel::alias('d')
//                ->join('doctor_class dc','dc.doctor_id=d.id and find_in_set("7", dc.doctor_class)')
//                ->join('remote_cost rc',"rc.super_doctor_id=d.id and rc.exam_class='".$class."' and super_hospital_id=d.institution_id and hospital_id='".$remote."'")
//                ->where('d.institution_id',$id)
//                ->field('d.id,d.institution_id AS hid,realname,d.introduce,convert(rc.money/100,decimal(10,2)) AS cost,null AS scid,null AS sid')
//                ->select();
//        }
        $info = DoctorModel::alias('d')
            // 达梦没有 FIND_IN_SET，改用 POSITION 或 LIKE，或提前创建自定义函数
            // 方案1：用 POSITION 替代（推荐，无需创建函数）
            ->join('doctor_class dc', "dc.doctor_id = d.id AND (',' || dc.doctor_class || ',') LIKE '%,7,%'", 'inner')

            ->join('remote_cost rc', "rc.super_doctor_id = d.id AND rc.exam_class = '" . $class . "' AND rc.super_hospital_id = d.institution_id AND rc.hospital_id = '" . $remote . "'", 'inner')

            ->where('d.institution_id', $id)
            ->where('d.is_admin', '1')

            // 达梦 CAST 语法：CAST(value AS DECIMAL(10,2))
            // 注意：达梦整数相除默认取整，需要把分母写成 100.0
            ->field("d.id, d.INSTITUTION_ID AS hid, d.realname, CAST(rc.money / 100.0 AS DECIMAL(10,2)) AS cost, introduce, null AS scid, null AS sid")

            ->select();

        if (empty(json_decode(json_encode($info), true))) {
            $info = DoctorModel::alias('d')
                ->join('doctor_class dc', "dc.doctor_id = d.id AND (',' || dc.doctor_class || ',') LIKE '%,7,%'", 'inner')
                ->join('remote_cost rc', "rc.super_doctor_id = d.id AND rc.exam_class = '" . $class . "' AND rc.super_hospital_id = d.institution_id AND rc.hospital_id = '" . $remote . "'", 'inner')
                ->where('d.institution_id', $id)
                // 达梦 CAST 语法，整数除法用 100.0
                ->field("d.id, d.INSTITUTION_ID AS hid, realname, d.introduce, CAST(rc.money / 100.0 AS DECIMAL(10,2)) AS cost, null AS scid, null AS sid")
                ->select();
        }
        return $info;
    }

}