xinyi_admin/application/common/model/DoctorGuideModel.php

<?php
namespace app\common\model;

/**
 * 医生导购信息表
 * Class DoctorGuideModel
 * @package app\common\model
 */

class DoctorGuideModel extends BaseModel
{
    protected $table = 'doctor_guide';

    public function getDoctorGuidePage($page,$pageSize,$condition=[],$is_count = false,$order=''){
        $join=[
            ['product product','product.product_no=doctor_guide.product_no','LEFT'],
            ['doctor doctor','doctor.doctor_no=doctor_guide.doctor_no','LEFT'],
            ['hospital hospital','hospital.hospital_id=doctor.hospital_id','LEFT'],
            ['department department','department.department_id=doctor.department_id','LEFT'],
        ];

        $this->alias('doctor_guide')
            ->field('doctor_guide.*,product.product_name,doctor.name doctor_name,
                hospital.name hospital_name,department_name
            ')
            ->join($join);
        if($condition){
            $this->where($condition);
        }
        if($is_count){
            return $this->count();
        }

        if($order){
            $this->order($order);
        }

        return $this->BaseModel($this->page($page,$pageSize)->select());
    }

    //获取多条数据
    public function getDoctorGuideList($condition=[]){
        $join=[
            ['product product','product.product_no=doctor_guide.product_no','LEFT'],
            ['doctor doctor','doctor.doctor_no=doctor_guide.doctor_no','LEFT'],
        ];
        $this->alias('doctor_guide')
            ->field('doctor_guide.*,product.product_name,doctor.name,doctor.hospital_id,doctor.department_id')
            ->join($join);

        if($condition){
            $this->where($condition);
        }
        return $this->BaseModel($this->select());
    }

    //获取一条数据
    public function getDoctorGuideOne($condition=[]){
        $join=[
            ['product product','product.product_no=doctor_guide.product_no','LEFT'],
            ['doctor doctor','doctor.doctor_no=doctor_guide.doctor_no','LEFT'],
        ];
        $this->alias('doctor_guide')
            ->field('doctor_guide.*,product.product_name,doctor.name,doctor.hospital_id,doctor.department_id')
            ->join($join);

        if($condition){
            $this->where($condition);
        }
        return $this->BaseModel($this->find());
    }


}