| 123456789101112131415161718 |
- package models
- //删除用户角色
- var SqlDeleteUserRoles = `delete from sys_user_role where user_id=?`
- //获取用户角色
- var SqlSelectUserRoles = `select
- sys_user_role.*,
- GROUP_CONCAT(sys_role.name) role_name,
- GROUP_CONCAT(sys_role.id) user_role
- from
- sys_user_role
- LEFT JOIN
- sys_role
- on
- sys_user_role.role_id = sys_role.id
- where sys_user_role.user_id = ?
- and sys_user_role.del_flag = 0 `
|
