<?php
declare(strict_types=1);

/**
 * 用户模型，对应 admin_user 表
 */
class Users extends Model
{
    /**
     * 查询用户列表，关联部门中文名称
     */
    public function listWithDepa(): array
    {
        return $this->db->select('admin_user (u)', [
            '[><]admin_depa (d)' => ['admin_depa_id' => 'admin_depa_id'],
        ], [
            'u.admin_id',
            'u.admin_username',
            'u.admin_name',
            'd.admin_depa_cn_name',
            'u.admin_email',
            'u.admin_mobile',
            'u.admin_allow',
            'u.admin_create_time',
        ], [
            'ORDER' => ['u.admin_id' => 'ASC'],
        ]);
    }
}