xinyi_admin/application/common/model/DoctorModel.php

<?php
namespace app\common\model;
/**
 * 员工信息表
 * Class StaffModel
 * @package app\common\model
 */

class DoctorModel extends BaseModel
{
    protected $table = 'doctor';

    /**
	*添加医生
	*@param array 医院信息
	*@return int 医院id
	*/
	public function doctor_add($params){
		return $this->kuyun_insert($params,'');
	}

	/**
	*查询医生单条信息
	*@param array 查询条件
	*@return array 医生信息
	*/
	public function doctor_find($where){
		return $this->kuyun_find($where,'','');
	}

	/**
	*查询所有的医生
	*@param array 联合查询
	*@param string 查询字段
	*@param int 页码
	*@param bull 是否查数量
	*@return array 医生信息
	*/
	public function doctor_select($join,$field,$page,$is_count){
		return $this->kuyun_select('',$join,'',$field,'',$page,$is_count);
	}

	/**
	*编辑医生
	*@param array 添加的数据
	*@param array 条件
	*@return int
	*/
	public function doctor_edit($data,$where){
		return $this->kuyun_insert($data,$where);
	}

	/**
	*删除医生
	*@param array 删除条件
	*@return int 返回删除id
	*/
	public function doctor_delete($where){
		return $this->kuyun_delete($where);
	}


    public function getDoctorPage($page,$pageSize,$condition=[],$is_count = false,$order=''){
        $join=[
            ['hospital h','doctor.hospital_id=h.hospital_id','LEFT'],
            ['department d','doctor.department_id = d.department_id','LEFT']
        ];
        $this->alias('doctor')
            ->field('doctor.*,h.name as hospital_name,d.department_name')
            ->join($join);
        if($condition){
            $this->where($condition);
        }
        if($is_count){
            return $this->count();
        }
        if($order){
            $this->order($order);
        }
        return $this->select();
    }


    //获取医生列表信息
    public function getDoctorList($condition=[],$order=''){
        $join=[
            ['hospital hospital','hospital.hospital_id=doctor.hospital_id','LEFT'],
            ['department department','department.department_id = doctor.department_id','LEFT']
        ];
        $this->alias('doctor')
            ->field('doctor.*,hospital.hospital_id,department.department_id')
            ->join($join);
        if(!empty($condition)){
            $this->where($condition);
        }
        if(!empty($order)){
            $this->order($order);
        }
        return $this->select();
    }

    /**
     * 获取医生一条信息
     * @param array $condition
     * @return mixed
     */
    public function getDoctorOne($condition=[]){
        $join=[
            ['department department','department.department_id=doctor.department_id','LEFT'],
            ['hospital hospital','hospital.hospital_id=doctor.hospital_id','LEFT'],
        ];
        $this->alias('doctor')
            ->field('doctor.*,department.department_name,hospital.name hospital_name')
            ->join($join);
        if($condition){
            $this->where($condition);
        }
        return $this->BaseModel($this->find());
    }




}