system_service.go 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642
  1. package backend
  2. import (
  3. "context"
  4. "errors"
  5. "fmt"
  6. "kpt-tmr-group/model"
  7. "kpt-tmr-group/pkg/jwt"
  8. "kpt-tmr-group/pkg/tool"
  9. "kpt-tmr-group/pkg/xerr"
  10. operationPb "kpt-tmr-group/proto/go/backend/operation"
  11. "net/http"
  12. "strconv"
  13. "strings"
  14. "gorm.io/gorm"
  15. )
  16. // Auth 用户登录
  17. func (s *StoreEntry) Auth(ctx context.Context, auth *operationPb.UserAuthData) (*operationPb.SystemToken, error) {
  18. systemUser := &model.SystemUser{}
  19. if err := s.DB.Where("name = ?", auth.UserName).Find(systemUser).Error; err != nil {
  20. return nil, xerr.WithStack(err)
  21. }
  22. if systemUser.Password != auth.Password {
  23. return nil, xerr.Customf("密码错误,来自用户:%s", auth.UserName)
  24. }
  25. token, err := jwt.GenerateToken(systemUser.Name, systemUser.Password)
  26. if err != nil {
  27. return nil, xerr.WithStack(err)
  28. }
  29. if token == "" {
  30. return nil, xerr.Custom("获取token错误")
  31. }
  32. return &operationPb.SystemToken{
  33. Code: http.StatusOK,
  34. Msg: "ok",
  35. Data: &operationPb.TokenData{Token: token},
  36. }, nil
  37. }
  38. // GetUserInfo 获取用户信息
  39. func (s *StoreEntry) GetUserInfo(ctx context.Context, token string) (*operationPb.UserAuth, error) {
  40. systemUser := &model.SystemUser{}
  41. claims, err := jwt.ParseToken(token)
  42. if err != nil {
  43. return nil, xerr.WithStack(err)
  44. }
  45. if claims.Username == "" {
  46. return nil, xerr.Custom("token解析失败")
  47. }
  48. if err = s.DB.Where("name = ?", claims.Username).First(systemUser).Error; err != nil {
  49. return nil, xerr.WithStack(err)
  50. }
  51. systemRole := make([]*model.SystemRole, 0)
  52. pastureList := make([]*operationPb.UserPasture, 0)
  53. roleIdStr := strings.Split(systemUser.RoleIds, ",")
  54. if len(roleIdStr) > 0 {
  55. roleIds := make([]int, 0)
  56. for _, v := range roleIdStr {
  57. roleId, _ := strconv.Atoi(v)
  58. roleIds = append(roleIds, roleId)
  59. }
  60. if err = s.DB.Model(new(model.SystemGroupPasturePermissions)).Select("DISTINCT(group_pasture.id) AS did, group_pasture.id as id,group_pasture.name as name").
  61. Where("system_group_pasture_permissions.role_id IN ?", roleIds).Where("system_group_pasture_permissions.is_show = ?", operationPb.IsShow_OK).
  62. Joins("right join group_pasture on system_group_pasture_permissions.pasture_id = group_pasture.id").Find(&pastureList).Debug().Error; err != nil {
  63. }
  64. if err = s.DB.Find(&systemRole, roleIds).Error; err != nil {
  65. return nil, xerr.WithStack(err)
  66. }
  67. }
  68. return systemUser.SystemUserFormat(systemRole, pastureList), nil
  69. }
  70. // CreateSystemUser 创建系统用户
  71. func (s *StoreEntry) CreateSystemUser(ctx context.Context, req *operationPb.AddSystemUser) error {
  72. systemUsers := &model.SystemUser{
  73. Name: req.Name,
  74. EmployeeName: req.EmployeeName,
  75. Phone: req.Phone,
  76. Password: tool.Md5String(model.InitManagerPassword),
  77. CreateUser: req.CreateUser,
  78. IsShow: operationPb.IsShow_OK,
  79. IsDelete: operationPb.IsShow_OK,
  80. }
  81. systemUsers.SystemUserRoleFormat(req)
  82. if err := s.DB.Create(systemUsers).Error; err != nil {
  83. return xerr.WithStack(err)
  84. }
  85. return nil
  86. }
  87. // SearchSystemUserList 查询系统用户
  88. func (s *StoreEntry) SearchSystemUserList(ctx context.Context, req *operationPb.SearchUserRequest) (*operationPb.SearchUserResponse, error) {
  89. systemUserList := make([]*model.SystemUser, 0)
  90. var count int64 = 0
  91. pref := s.DB.Model(new(model.SystemUser)).Where("is_delete = ?", operationPb.IsShow_OK)
  92. if req.Name != "" {
  93. pref.Where("name like ?", fmt.Sprintf("%s%s%s", "%", req.Name, "%"))
  94. }
  95. if req.EmployeeName != "" {
  96. pref.Where("employee_name like ?", fmt.Sprintf("%s%s%s", "%", req.EmployeeName, "%"))
  97. }
  98. if req.IsShow > 0 {
  99. pref.Where("is_show = ?", req.IsShow)
  100. }
  101. if req.CreatedStartTime > 0 && req.CreatedEndTime > 0 && req.CreatedStartTime <= req.CreatedEndTime {
  102. pref.Where("created_at BETWEEN ? AND ?", req.CreatedStartTime, req.CreatedEndTime)
  103. }
  104. if err := pref.Order("id desc").Count(&count).Limit(int(req.Pagination.PageSize)).Offset(int(req.Pagination.PageOffset)).
  105. Find(&systemUserList).Debug().Error; err != nil {
  106. return nil, xerr.WithStack(err)
  107. }
  108. roleList, err := s.SearchSystemRoleListByIds(ctx, []int64{})
  109. if err != nil {
  110. return nil, xerr.WithStack(err)
  111. }
  112. return &operationPb.SearchUserResponse{
  113. Code: http.StatusOK,
  114. Msg: "ok",
  115. Data: &operationPb.SearchUserData{
  116. Page: req.Pagination.Page,
  117. Total: int32(count),
  118. PageSize: req.Pagination.PageSize,
  119. List: model.SystemUserSlice(systemUserList).ToPB(roleList),
  120. },
  121. }, nil
  122. }
  123. // EditSystemUser 编辑用户
  124. func (s *StoreEntry) EditSystemUser(ctx context.Context, req *operationPb.AddSystemUser) error {
  125. systemUser := &model.SystemUser{Id: int64(req.Id)}
  126. if err := s.DB.First(systemUser).Error; err != nil {
  127. if errors.Is(err, gorm.ErrRecordNotFound) {
  128. return xerr.Custom("该数据不存在!")
  129. }
  130. return xerr.WithStack(err)
  131. }
  132. updateData := &model.SystemUser{
  133. Name: req.Name,
  134. EmployeeName: req.EmployeeName,
  135. Phone: req.Phone,
  136. CreateUser: req.CreateUser,
  137. }
  138. updateData.SystemUserRoleFormat(req)
  139. if err := s.DB.Model(new(model.SystemUser)).Omit("is_show", "password", "is_delete").
  140. Where("id = ?", systemUser.Id).
  141. Updates(updateData).Error; err != nil {
  142. return xerr.WithStack(err)
  143. }
  144. return nil
  145. }
  146. // DeleteSystemUser 删除系统用户
  147. func (s *StoreEntry) DeleteSystemUser(ctx context.Context, userId int64) error {
  148. systemUser := &model.SystemUser{
  149. Id: userId,
  150. }
  151. if err := s.DB.First(systemUser).Error; err != nil {
  152. if errors.Is(err, gorm.ErrRecordNotFound) {
  153. return xerr.Custom("该用户不存在")
  154. }
  155. return xerr.WithStack(err)
  156. }
  157. if err := s.DB.Model(systemUser).Update("is_delete", operationPb.IsShow_NO).Error; err != nil {
  158. return xerr.WithStack(err)
  159. }
  160. return nil
  161. }
  162. // ResetPasswordSystemUser 重置系统用户密码
  163. func (s *StoreEntry) ResetPasswordSystemUser(ctx context.Context, userId int64) error {
  164. systemUser := &model.SystemUser{
  165. Id: userId,
  166. }
  167. if err := s.DB.First(systemUser).Error; err != nil {
  168. if errors.Is(err, gorm.ErrRecordNotFound) {
  169. return xerr.Custom("该用户不存在")
  170. }
  171. return xerr.WithStack(err)
  172. }
  173. if err := s.DB.Model(systemUser).Update("password", tool.Md5String(model.InitManagerPassword)).Error; err != nil {
  174. return xerr.WithStack(err)
  175. }
  176. return nil
  177. }
  178. // DetailsSystemUser 系统用户详情
  179. func (s *StoreEntry) DetailsSystemUser(ctx context.Context, userId int64) (*operationPb.UserDetails, error) {
  180. systemUser := &model.SystemUser{
  181. Id: userId,
  182. }
  183. if err := s.DB.First(systemUser).Error; err != nil {
  184. if errors.Is(err, gorm.ErrRecordNotFound) {
  185. return nil, xerr.Custom("该用户不存在")
  186. }
  187. return nil, xerr.WithStack(err)
  188. }
  189. return &operationPb.UserDetails{
  190. Code: http.StatusOK,
  191. Msg: "ok",
  192. Data: systemUser.ToPb(),
  193. }, nil
  194. }
  195. // IsShowSystemUser 用户是否启用
  196. func (s *StoreEntry) IsShowSystemUser(ctx context.Context, req *operationPb.IsShowSystemUserRequest) error {
  197. systemUser := &model.SystemUser{
  198. Id: int64(req.UserId),
  199. }
  200. if err := s.DB.First(systemUser).Error; err != nil {
  201. if errors.Is(err, gorm.ErrRecordNotFound) {
  202. return xerr.Custom("该用户不存在")
  203. }
  204. return xerr.WithStack(err)
  205. }
  206. if err := s.DB.Model(systemUser).Update("is_show", req.IsShow).Error; err != nil {
  207. return xerr.WithStack(err)
  208. }
  209. return nil
  210. }
  211. // GetSystemUserPermissions 返回系统用户相关菜单权限
  212. func (s *StoreEntry) GetSystemUserPermissions(ctx context.Context, token string) (*operationPb.SystemUserMenuPermissions, error) {
  213. // 解析token
  214. claims, err := jwt.ParseToken(token)
  215. if err != nil {
  216. return nil, xerr.WithStack(err)
  217. }
  218. if err = claims.Valid(); err != nil {
  219. return nil, xerr.WithStack(err)
  220. }
  221. // 根据用户token获取用户数据
  222. systemUser := &model.SystemUser{Name: claims.Username}
  223. if err = s.DB.Where("name = ?", claims.Username).First(systemUser).Error; err != nil {
  224. if errors.Is(err, gorm.ErrRecordNotFound) {
  225. return nil, xerr.Custom("该用户数据不存在")
  226. }
  227. return nil, xerr.WithStack(err)
  228. }
  229. roleIds := systemUser.SystemUserRoleToSlice()
  230. // 获取用户角色数据
  231. systemRoles := make([]*model.SystemRole, 0)
  232. if err = s.DB.Where("is_show = ?", operationPb.IsShow_OK).Find(&systemRoles, roleIds).Error; err != nil {
  233. return nil, xerr.WithStack(err)
  234. }
  235. systemAllPermissionsList := &SystemAllPermissionsList{
  236. PastureList: make([]*model.SystemGroupPasturePermissions, 0),
  237. MenuList: make([]*model.SystemMenuPermissions, 0),
  238. MobileList: make([]*model.SystemMobilePermissions, 0),
  239. }
  240. for _, role := range systemRoles {
  241. item := s.GetSystemAllPermissionsList(ctx, role.Id)
  242. systemAllPermissionsList.PastureList = append(systemAllPermissionsList.PastureList, item.PastureList...)
  243. systemAllPermissionsList.MenuList = append(systemAllPermissionsList.MenuList, item.MenuList...)
  244. systemAllPermissionsList.MobileList = append(systemAllPermissionsList.MobileList, item.MobileList...)
  245. }
  246. systemAllPermissionsList.SystemUserMenuPermissionsUnDuplicate()
  247. groupPastureList, err := s.GetPastureList(ctx, systemAllPermissionsList.PastureList)
  248. if err != nil {
  249. return nil, xerr.WithStack(err)
  250. }
  251. menuList, err := s.GetMenuList(ctx, systemAllPermissionsList.MenuList)
  252. if err != nil {
  253. return nil, xerr.WithStack(err)
  254. }
  255. mobileList, err := s.GetMobileList(ctx, systemAllPermissionsList.MobileList)
  256. if err != nil {
  257. return nil, xerr.WithStack(err)
  258. }
  259. return s.SystemPermissionsFormatPb(groupPastureList, mobileList, menuList), nil
  260. }
  261. // CreateSystemRole 添加角色
  262. func (s *StoreEntry) CreateSystemRole(ctx context.Context, req *operationPb.AddRoleRequest) error {
  263. if err := s.DB.Transaction(func(tx *gorm.DB) error {
  264. // 创建角色数据
  265. role := model.NewSystemRole(req)
  266. if err := tx.Create(role).Error; err != nil {
  267. return xerr.WithStack(err)
  268. }
  269. // 创建角色菜单权限数据
  270. if len(req.MenuId) > 0 {
  271. menuPermissions := model.NewSystemMenuPermissions(role.Id, req.MenuId)
  272. if err := tx.Create(menuPermissions).Error; err != nil {
  273. return xerr.WithStack(err)
  274. }
  275. }
  276. // 创建角色移动端权限数据
  277. if len(req.MobileId) > 0 {
  278. mobilePermissions := model.NewSystemMobilePermissions(role.Id, req.MobileId)
  279. if err := tx.Create(mobilePermissions).Error; err != nil {
  280. return xerr.WithStack(err)
  281. }
  282. }
  283. // 创建角色牧场端权限数据
  284. if len(req.PastureId) > 0 {
  285. pasturePermissions := model.NewSystemGroupPasturePermissions(role.Id, req.PastureId)
  286. if err := tx.Create(pasturePermissions).Error; err != nil {
  287. return xerr.WithStack(err)
  288. }
  289. }
  290. return nil
  291. }); err != nil {
  292. return xerr.WithStack(err)
  293. }
  294. return nil
  295. }
  296. // EditSystemRole 编辑角色
  297. func (s *StoreEntry) EditSystemRole(ctx context.Context, req *operationPb.AddRoleRequest) error {
  298. role := &model.SystemRole{Id: int64(req.Id)}
  299. if err := s.DB.First(role).Error; err != nil {
  300. if errors.Is(err, gorm.ErrRecordNotFound) {
  301. return xerr.Custom("该数据不存在")
  302. }
  303. return xerr.WithStack(err)
  304. }
  305. if err := s.DB.Transaction(func(tx *gorm.DB) error {
  306. updateSystemRole := model.NewSystemRole(req)
  307. if err := tx.Omit("is_show").
  308. Where("id = ?", role.Id).
  309. Updates(updateSystemRole).Error; err != nil {
  310. return xerr.WithStack(err)
  311. }
  312. // 更新牧场权限关系表
  313. pastureIds := req.PastureId
  314. if err := tx.Model(new(model.SystemGroupPasturePermissions)).
  315. Where("role_id = ?", req.Id).Update("is_show", operationPb.IsShow_NO).Error; err != nil {
  316. return xerr.WithStack(err)
  317. }
  318. newSystemGroupPasturePermissions := model.NewSystemGroupPasturePermissions(int64(req.Id), pastureIds)
  319. if err := tx.Create(newSystemGroupPasturePermissions).Error; err != nil {
  320. return xerr.WithStack(err)
  321. }
  322. // 更新菜单权限关系表
  323. menuIds := req.MenuId
  324. if err := tx.Model(new(model.SystemMenuPermissions)).
  325. Where("role_id = ?", req.Id).Update("is_show", operationPb.IsShow_NO).Error; err != nil {
  326. return xerr.WithStack(err)
  327. }
  328. newSystemMenuPermissions := model.NewSystemMenuPermissions(int64(req.Id), menuIds)
  329. if err := tx.Create(newSystemMenuPermissions).Error; err != nil {
  330. return xerr.WithStack(err)
  331. }
  332. // 更新移动端权限关系表
  333. mobileIds := req.MobileId
  334. if err := tx.Model(new(model.SystemMobilePermissions)).
  335. Where("role_id = ?", req.Id).Update("is_show", operationPb.IsShow_NO).Error; err != nil {
  336. return xerr.WithStack(err)
  337. }
  338. newSystemMobilePermissions := model.NewSystemMobilePermissions(int64(req.Id), mobileIds)
  339. if err := tx.Create(newSystemMobilePermissions).Error; err != nil {
  340. return xerr.WithStack(err)
  341. }
  342. return nil
  343. }); err != nil {
  344. return xerr.WithStack(err)
  345. }
  346. return nil
  347. }
  348. // DeleteSystemRole 删除系统角色
  349. func (s *StoreEntry) DeleteSystemRole(ctx context.Context, roleId int64) error {
  350. systemRole := &model.SystemRole{
  351. Id: roleId,
  352. }
  353. if err := s.DB.First(systemRole).Error; err != nil {
  354. if errors.Is(err, gorm.ErrRecordNotFound) {
  355. return xerr.Custom("该数据不存在")
  356. }
  357. return xerr.WithStack(err)
  358. }
  359. if err := s.DB.Model(systemRole).Update("is_show", operationPb.IsShow_NO).Error; err != nil {
  360. return xerr.WithStack(err)
  361. }
  362. return nil
  363. }
  364. // SearchSystemRoleList 查询系统角色
  365. func (s *StoreEntry) SearchSystemRoleList(ctx context.Context, req *operationPb.SearchRoleRequest) (*operationPb.SearchRoleResponse, error) {
  366. systemRole := make([]*model.SystemRole, 0)
  367. var count int64 = 0
  368. pref := s.DB.Model(new(model.SystemRole)).Where("is_show = ?", operationPb.IsShow_OK)
  369. if req.Name != "" {
  370. pref.Where("name like ?", fmt.Sprintf("%s%s%s", "%", req.Name, "%"))
  371. }
  372. if err := pref.Order("id desc").Count(&count).Limit(int(req.Pagination.PageSize)).Offset(int(req.Pagination.PageOffset)).
  373. Find(&systemRole).Debug().Error; err != nil {
  374. return nil, xerr.WithStack(err)
  375. }
  376. return &operationPb.SearchRoleResponse{
  377. Code: http.StatusOK,
  378. Msg: "ok",
  379. Data: &operationPb.SearchRoleData{
  380. Page: req.Pagination.Page,
  381. Total: int32(count),
  382. PageSize: req.Pagination.PageSize,
  383. List: model.SystemRoleSlice(systemRole).ToPB(),
  384. },
  385. }, nil
  386. }
  387. // SearchSystemRoleListByIds 根据id查询角色列表
  388. func (s *StoreEntry) SearchSystemRoleListByIds(ctx context.Context, ids []int64) ([]*model.SystemRole, error) {
  389. systemRoleList := make([]*model.SystemRole, 0)
  390. if err := s.DB.Model(new(model.SystemRole)).Where("is_show = ?", operationPb.IsShow_OK).Find(&systemRoleList, ids).Error; err != nil {
  391. return nil, xerr.WithStack(err)
  392. }
  393. return systemRoleList, nil
  394. }
  395. // GetRolePermissions 查询系统角色权限
  396. func (s *StoreEntry) GetRolePermissions(ctx context.Context, roleId int64) (*operationPb.RolePermissionsList, error) {
  397. systemRole := &model.SystemRole{
  398. Id: roleId,
  399. }
  400. if err := s.DB.First(systemRole).Error; err != nil {
  401. if errors.Is(err, gorm.ErrRecordNotFound) {
  402. return nil, xerr.Custom("该数据不存在")
  403. }
  404. return nil, xerr.WithStack(err)
  405. }
  406. systemAllPermissionsList := &SystemAllPermissionsList{
  407. PastureList: make([]*model.SystemGroupPasturePermissions, 0),
  408. MenuList: make([]*model.SystemMenuPermissions, 0),
  409. MobileList: make([]*model.SystemMobilePermissions, 0),
  410. }
  411. item := s.GetSystemAllPermissionsList(ctx, systemRole.Id)
  412. systemAllPermissionsList.PastureList = append(systemAllPermissionsList.PastureList, item.PastureList...)
  413. systemAllPermissionsList.MenuList = append(systemAllPermissionsList.MenuList, item.MenuList...)
  414. systemAllPermissionsList.MobileList = append(systemAllPermissionsList.MobileList, item.MobileList...)
  415. return s.AllPermissionsListToRolePermissions(systemAllPermissionsList), nil
  416. }
  417. // CreateSystemMenu 添加系统菜单权限
  418. func (s *StoreEntry) CreateSystemMenu(ctx context.Context, req *operationPb.AddMenuRequest) error {
  419. systemMenu := model.NewSystemMenu(req)
  420. if err := s.DB.Create(systemMenu).Error; err != nil {
  421. return xerr.WithStack(err)
  422. }
  423. return nil
  424. }
  425. // EditSystemMenu 编辑系统菜单权限
  426. func (s *StoreEntry) EditSystemMenu(ctx context.Context, req *operationPb.AddMenuRequest) error {
  427. systemMenu := &model.SystemMenu{Id: int64(req.Id)}
  428. if err := s.DB.First(systemMenu).Error; err != nil {
  429. if errors.Is(err, gorm.ErrRecordNotFound) {
  430. return xerr.Custom("该数据不存在!")
  431. }
  432. return xerr.WithStack(err)
  433. }
  434. updateData := &model.SystemMenu{
  435. Name: req.Name,
  436. MenuType: req.MenuType,
  437. Title: req.Title,
  438. Path: req.Path,
  439. Component: req.Component,
  440. Icon: req.Icon,
  441. Sort: req.Sort,
  442. Redirect: req.Redirect,
  443. ParentId: int64(req.ParentId),
  444. }
  445. if err := s.DB.Model(new(model.SystemMenu)).Omit("is_show").
  446. Where("id = ?", systemMenu.Id).
  447. Updates(updateData).Error; err != nil {
  448. return xerr.WithStack(err)
  449. }
  450. return nil
  451. }
  452. // IsShowSystemMenu 菜单是否启用
  453. func (s *StoreEntry) IsShowSystemMenu(ctx context.Context, req *operationPb.IsShowSystemMenuRequest) error {
  454. systemMenu := &model.SystemMenu{Id: int64(req.MenuId)}
  455. if err := s.DB.First(systemMenu).Error; err != nil {
  456. if errors.Is(err, gorm.ErrRecordNotFound) {
  457. return xerr.Custom("该数据不存在")
  458. }
  459. return xerr.WithStack(err)
  460. }
  461. if err := s.DB.Model(systemMenu).Update("is_show", req.IsShow).Error; err != nil {
  462. return xerr.WithStack(err)
  463. }
  464. return nil
  465. }
  466. // SearchSystemMenuList 菜单列表查询
  467. func (s *StoreEntry) SearchSystemMenuList(ctx context.Context, req *operationPb.SearchMenuRequest) (*operationPb.SearchMenuResponse, error) {
  468. systemMenuLevel1 := make([]*model.SystemMenu, 0)
  469. var count int64 = 0
  470. pref := s.DB.Model(new(model.SystemMenu)).Where("is_delete = ? and level = ?", operationPb.IsShow_OK, model.Level1)
  471. if req.Name != "" {
  472. pref.Where("name like ?", fmt.Sprintf("%s%s%s", "%", req.Name, "%"))
  473. }
  474. if err := pref.Order("sort desc").Count(&count).Limit(int(req.Pagination.PageSize)).Offset(int(req.Pagination.PageOffset)).
  475. Find(&systemMenuLevel1).Debug().Error; err != nil {
  476. return nil, xerr.WithStack(err)
  477. }
  478. systemMenuLevel1 = append(systemMenuLevel1, s.searchMenuLevel23ByLevel1(ctx, systemMenuLevel1)...)
  479. return &operationPb.SearchMenuResponse{
  480. Code: http.StatusOK,
  481. Msg: "ok",
  482. Data: &operationPb.SearchMenuData{
  483. Page: req.Pagination.Page,
  484. Total: int32(count),
  485. List: model.SystemMenuSlice(systemMenuLevel1).ToPB(),
  486. },
  487. }, nil
  488. }
  489. // searchMenuLevel23ByLevel1 根据一级菜单返回对应二三级菜单
  490. func (s *StoreEntry) searchMenuLevel23ByLevel1(ctx context.Context, res []*model.SystemMenu) []*model.SystemMenu {
  491. systemMenuLevel23 := make([]*model.SystemMenu, 0)
  492. if len(res) <= 0 {
  493. return systemMenuLevel23
  494. }
  495. ids1 := make([]int64, 0)
  496. for _, v := range res {
  497. ids1 = append(ids1, v.Id)
  498. }
  499. if err := s.DB.Model(new(model.SystemMenu)).Where("is_delete = ? and level = ?", operationPb.IsShow_OK, model.Level2).
  500. Where("parent_id IN ?", ids1).Order("sort desc").
  501. Find(&systemMenuLevel23).Error; err != nil {
  502. return systemMenuLevel23
  503. }
  504. ids2 := make([]int64, 0)
  505. for _, v := range systemMenuLevel23 {
  506. ids2 = append(ids2, v.Id)
  507. }
  508. systemMenuLevel3 := make([]*model.SystemMenu, 0)
  509. if err := s.DB.Model(new(model.SystemMenu)).Where("is_delete = ? and level = ?", operationPb.IsShow_OK, model.Level3).
  510. Where("parent_id IN ?", ids2).Order("sort desc").
  511. Find(&systemMenuLevel3).Error; err != nil {
  512. return systemMenuLevel23
  513. }
  514. if len(systemMenuLevel3) > 0 {
  515. systemMenuLevel23 = append(systemMenuLevel23, systemMenuLevel3...)
  516. }
  517. return systemMenuLevel23
  518. }
  519. // DeleteSystemMenu 删除系统菜单
  520. func (s *StoreEntry) DeleteSystemMenu(ctx context.Context, menuId int64) error {
  521. systemMenu := &model.SystemMenu{Id: menuId}
  522. if err := s.DB.First(systemMenu).Error; err != nil {
  523. if errors.Is(err, gorm.ErrRecordNotFound) {
  524. return xerr.Custom("该数据不存在")
  525. }
  526. return xerr.WithStack(err)
  527. }
  528. if err := s.DB.Model(systemMenu).Update("is_delete", operationPb.IsShow_NO).Error; err != nil {
  529. return xerr.WithStack(err)
  530. }
  531. return nil
  532. }
  533. // SearchMobileList 查询移动端角色
  534. func (s *StoreEntry) SearchMobileList(ctx context.Context, req *operationPb.SearchMobileRequest) (*operationPb.SearchMobileResponse, error) {
  535. systemMobile := make([]*model.SystemMobile, 0)
  536. var count int64 = 0
  537. pref := s.DB.Model(new(model.SystemMobile)).Where("is_show = ?", operationPb.IsShow_OK)
  538. if req.Name != "" {
  539. pref.Where("name like ?", fmt.Sprintf("%s%s%s", "%", req.Name, "%"))
  540. }
  541. if err := pref.Order("id desc").Count(&count).Limit(int(req.Pagination.PageSize)).Offset(int(req.Pagination.PageOffset)).
  542. Find(&systemMobile).Debug().Error; err != nil {
  543. return nil, xerr.WithStack(err)
  544. }
  545. return &operationPb.SearchMobileResponse{
  546. Code: http.StatusOK,
  547. Msg: "ok",
  548. Data: &operationPb.SearchMobileData{
  549. Page: req.Pagination.Page,
  550. Total: int32(count),
  551. PageSize: req.Pagination.PageSize,
  552. List: model.SystemMobileSlice(systemMobile).ToPB(),
  553. },
  554. }, nil
  555. }