hros
hros copied to clipboard
添加用户后在界面不显示
查看后端代码,发现执行获取所有用户的sql语句如下
SELECT
hr.id, hr.name, hr.phone, hr.telephone, hr.address, hr.enabled, hr.username, hr.userface, hr.remark, hr.employee_id, hr.work_date, r.id as rid, r.name as rname, r.namezh as rnamezh
FROM hr left join hr_role hrr on hr.id = hrr.hrid left join role r on hrr.rid = r.id
WHERE hr.id != #{id,jdbcType=INTEGER} AND hr.employee_id is NULL