sys_role_admin.go 8.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255
  1. package system
  2. import (
  3. "eta/eta_api/global"
  4. "eta/eta_api/utils"
  5. "time"
  6. )
  7. type SysRoleAdmin struct {
  8. Id int `orm:"column(id);pk" gorm:"primaryKey" description:"自增ID"`
  9. AdminId int `orm:"column(admin_id);" description:"系统用户id"`
  10. RoleId int `orm:"column(role_id);" description:"角色ID"`
  11. CreateTime time.Time `orm:"column(create_time);" description:"创建时间"`
  12. }
  13. type RoleAdminItem struct {
  14. SysRoleAdminId int `description:"管理员账号和角色映射表id"`
  15. AdminId int `description:"系统用户id"`
  16. AdminName string `description:"系统用户名称"`
  17. RealName string `description:"系统用户姓名"`
  18. Enabled int `description:"1:有效,0:禁用"`
  19. Mobile string `description:"手机号"`
  20. RoleId int `description:"角色Id"`
  21. RoleTypeCode string `description:"角色编码"`
  22. DepartmentId int `description:"部门id"`
  23. DepartmentName string `description:"部门名称"`
  24. DepartmentGroup string `description:"部门分组"`
  25. TeamId int `description:"小组id"`
  26. GroupId int `description:"分组id"`
  27. GroupName string `description:"分组名称"`
  28. Authority int `description:"管理权限,0:无,1:部门负责人,2:小组负责人,或者ficc销售主管,4:ficc销售组长"`
  29. LabelVal int `description:"标签:1:超级管理员,2:管理员,3:部门经理,4:组长,5:ficc销售主管"`
  30. }
  31. func (sa *SysRoleAdmin) TableName() string {
  32. return "sys_role_admin"
  33. }
  34. // GetRoleIdsByAdminId 根据管理员账号查询角色ID
  35. func GetRoleIdsByAdminId(adminId int) (items []*SysRoleAdmin, err error) {
  36. sql := `SELECT * from sys_role_admin where admin_id = ?`
  37. err = global.DbMap[utils.DbNameMaster].Raw(sql, adminId).Find(&items).Error
  38. return
  39. }
  40. // GetRoleIdsByAdminIdRoleId 根据管理员账号和角色查询
  41. func GetRoleIdsByAdminIdRoleId(adminId int, roleId int) (item *SysRoleAdmin, err error) {
  42. sql := `SELECT * from sys_role_admin where admin_id = ? and role_id=?`
  43. err = global.DbMap[utils.DbNameMaster].Raw(sql, adminId, roleId).First(&item).Error
  44. return
  45. }
  46. // GetRoleAdminList 查询对应角色绑定的管理员列表
  47. func GetRoleAdminList(condition string, pars []interface{}, startSize, pageSize int) (list []*RoleAdminItem, err error) {
  48. sql := `SELECT
  49. s.id as sys_role_admin_id,
  50. a.admin_id,
  51. a.admin_name,
  52. a.real_name,
  53. a.mobile,
  54. a.department_id,
  55. a.department_name,
  56. a.enabled,
  57. a.role_id,
  58. a.role_type_code ,
  59. a.group_id,
  60. a.authority,
  61. a.group_name
  62. FROM
  63. sys_role_admin s
  64. INNER JOIN "admin" a ON s.admin_id = a.admin_id
  65. where 1=1`
  66. if condition != "" {
  67. sql += condition
  68. }
  69. sql += ` ORDER BY s.id DESC limit ?, ?`
  70. pars = append(pars, startSize, pageSize)
  71. err = global.DbMap[utils.DbNameMaster].Raw(sql, pars...).Find(&list).Error
  72. return
  73. }
  74. // GetRoleAdminListTotal 查询对应角色绑定的管理员列表总数
  75. func GetRoleAdminListTotal(condition string, pars []interface{}) (total int64, err error) {
  76. sql := `SELECT
  77. count(*)
  78. FROM
  79. sys_role_admin s
  80. INNER JOIN "admin" a ON s.admin_id = a.admin_id
  81. where 1=1`
  82. if condition != "" {
  83. sql += condition
  84. }
  85. err = global.DbMap[utils.DbNameMaster].Raw(sql, pars...).Scan(&total).Error
  86. return
  87. }
  88. // CheckRoleAdminByAdminIds 判断是否已经绑定过该角色
  89. func CheckRoleAdminByAdminIds(adminIds string, roleId int) (list []*SysRoleAdmin, err error) {
  90. sql := `SELECT
  91. s.*
  92. FROM
  93. sys_role_admin s
  94. LEFT JOIN "admin" a ON s.admin_id = a.admin_id
  95. where s.role_id=? and s.admin_id in (` + adminIds + `)`
  96. err = global.DbMap[utils.DbNameMaster].Raw(sql, roleId).Find(&list).Error
  97. return
  98. }
  99. // AddRoleAdminBatch 批量新增留言版管理员
  100. func AddRoleAdminBatch(admins []*SysRoleAdmin) (err error) {
  101. o := global.DbMap[utils.DbNameMaster]
  102. err = o.CreateInBatches(admins, utils.MultiAddNum).Error
  103. return
  104. }
  105. // DeleteRoleAdmin 删除管理员和角色的绑定
  106. func DeleteRoleAdmin(SysRoleAdminId int) (err error) {
  107. sql := `DELETE FROM sys_role_admin WHERE id=? `
  108. o := global.DbMap[utils.DbNameMaster]
  109. err = o.Exec(sql, SysRoleAdminId).Error
  110. return
  111. }
  112. // GetRoleAdminById 根据ID查询绑定记录
  113. func GetRoleAdminById(SysRoleAdminId int) (item *SysRoleAdmin, err error) {
  114. sql := `SELECT
  115. *
  116. FROM
  117. sys_role_admin
  118. where id=?`
  119. err = global.DbMap[utils.DbNameMaster].Raw(sql, SysRoleAdminId).First(&item).Error
  120. return
  121. }
  122. // GetEnglishAuthRoleAdminList 查询英文权限管理员列表
  123. func GetEnglishAuthRoleAdminList(condition string, pars []interface{}, startSize, pageSize int) (total int, list []*RoleAdminItem, err error) {
  124. o := global.DbMap[utils.DbNameMaster]
  125. sql := `SELECT
  126. s.id as sys_role_admin_id,
  127. a.admin_id,
  128. a.admin_name,
  129. a.real_name,
  130. a.mobile,
  131. a.department_id,
  132. a.department_name,
  133. a.enabled,
  134. a.role_id,
  135. a.role_type_code ,
  136. a.group_id,
  137. a.authority,
  138. a.group_name
  139. FROM
  140. sys_role_admin AS s
  141. JOIN sys_role AS r ON s.role_id = r.role_id
  142. JOIN "admin" AS a ON s.admin_id = a.admin_id
  143. WHERE
  144. 1 = 1 `
  145. sql += condition
  146. sql += ` GROUP BY s.admin_id `
  147. totalSQl := `SELECT COUNT(1) total FROM (` + sql + `) z`
  148. if err = o.Raw(totalSQl, pars...).Scan(&total).Error; err != nil {
  149. return
  150. }
  151. sql += ` ORDER BY s.create_time DESC,s.admin_id ASC LIMIT ?,? `
  152. pars = append(pars, startSize, pageSize)
  153. err = o.Raw(sql, pars...).Find(&list).Error
  154. return
  155. }
  156. // DeleteRoleAdminByAdminIdAndRoleIds 通过管理员ID及角色IDs删除绑定
  157. func DeleteRoleAdminByAdminIdAndRoleIds(adminId int, roleIds []int) (err error) {
  158. if len(roleIds) == 0 {
  159. return
  160. }
  161. o := global.DbMap[utils.DbNameMaster]
  162. sql := `DELETE FROM sys_role_admin WHERE admin_id = ? AND role_id IN (` + utils.GetOrmInReplace(len(roleIds)) + `) `
  163. err = o.Exec(sql, adminId, roleIds).Error
  164. return
  165. }
  166. // CheckEnglishAuthRoleAdminByAdminIds 通过管理员IDs判断是否已经绑定过英文权限角色
  167. func CheckEnglishAuthRoleAdminByAdminIds(adminIds []int, roleCodes []string) (list []*SysRoleAdmin, err error) {
  168. if len(adminIds) == 0 || len(roleCodes) == 0 {
  169. return
  170. }
  171. o := global.DbMap[utils.DbNameMaster]
  172. sql := `SELECT
  173. s.*
  174. FROM
  175. sys_role_admin AS s
  176. JOIN sys_role AS r ON s.role_id = r.role_id
  177. JOIN "admin" AS a ON s.admin_id = a.admin_id
  178. WHERE
  179. s.admin_id IN (` + utils.GetOrmInReplace(len(adminIds)) + `) AND r.role_type_code IN (` + utils.GetOrmInReplace(len(roleCodes)) + `)
  180. GROUP BY
  181. s.admin_id`
  182. err = o.Raw(sql, adminIds, roleCodes).Find(&list).Error
  183. return
  184. }
  185. // EnglishAuthRoleDetail 英文权限角色详情
  186. type EnglishAuthRoleDetail struct {
  187. AdminId int `description:"用户ID"`
  188. RoleTypeCode string `description:"角色类型编码"`
  189. }
  190. // GetAdminEnglishAuthRoleDetail 获取用户英文权限详情
  191. func GetAdminEnglishAuthRoleDetail(adminId int, roleCodes []string) (list []*EnglishAuthRoleDetail, err error) {
  192. if len(roleCodes) == 0 {
  193. return
  194. }
  195. o := global.DbMap[utils.DbNameMaster]
  196. sql := `SELECT
  197. s.admin_id, r.role_type_code
  198. FROM
  199. sys_role_admin AS s
  200. JOIN sys_role AS r ON s.role_id = r.role_id
  201. JOIN "admin" AS a ON s.admin_id = a.admin_id
  202. WHERE
  203. s.admin_id = ? AND r.role_type_code IN (` + utils.GetOrmInReplace(len(roleCodes)) + `)`
  204. err = o.Raw(sql, adminId, roleCodes).Find(&list).Error
  205. return
  206. }
  207. // EditEnglishAuthRoleAdmin 编辑管理员英文权限
  208. func EditEnglishAuthRoleAdmin(adminId int, englishRoleIds []int, roleAdmins []*SysRoleAdmin) (err error) {
  209. o := global.DbMap[utils.DbNameMaster]
  210. tx := o.Begin()
  211. defer func() {
  212. if err != nil {
  213. _ = tx.Rollback()
  214. } else {
  215. _ = tx.Commit()
  216. }
  217. }()
  218. // 删除原绑定关系
  219. sql := `DELETE FROM sys_role_admin WHERE admin_id = ? AND role_id IN (` + utils.GetOrmInReplace(len(englishRoleIds)) + `)`
  220. err = tx.Exec(sql, adminId, englishRoleIds).Error
  221. if err != nil {
  222. return
  223. }
  224. // 新增绑定关系
  225. err = tx.CreateInBatches(roleAdmins, utils.MultiAddNum).Error
  226. return
  227. }
  228. // SyncAdminEnRole 同步用户英文角色
  229. type SyncAdminEnRole struct {
  230. AdminName string `description:"用户名"`
  231. RoleCodes []string `description:"角色Codes"`
  232. }