xinyi_admin/application/common/model/AdminModel.php

<?php
namespace app\common\model;
/**
 * 陈伟 2017-12-12
 * Class AdminModel
 * @package app\common\model
 */
class AdminModel extends BaseModel
{
    protected $table='admin';

    public function getAdminListPage($page,$pageSize,$condition=[],$is_count = false,$order=''){
        $join=[
            ['role role','role.id=admin.role_id','LEFT'],
        ];
        $this->alias('admin');
        $field=['admin.*,role.name role_name'];

        if($is_count){
            $res=$this->where($condition)->page($page,$pageSize)->count();
        }else{
            if($order){
                $this->order($order);
            }
            if(empty($condition)){
                $this->where($condition);
            }
            $res=$this->join($join)->where($condition)->page($page,$pageSize)->column($field);
        }
        return $res;
    }

    public function getAdminInfo($condition){
        $join=[
            ['role role','role.id=admin.role_id','LEFT'],
        ];
        $this->alias('admin')->field('admin.*,role.name role_name')->join($join);
        if($condition){
            $this->where($condition);
        }
        return $this->find();
    }
}