guochanhua/server/application/api/model/institution/InstitutionModel.php

<?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)->column('super_hospital_id');
        return $info;
    }

    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();
        }
        return $info;
    }

}