system_service.go 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670
  1. package backend
  2. import (
  3. "context"
  4. "errors"
  5. "fmt"
  6. "kpt-pasture/model"
  7. "kpt-pasture/util"
  8. "net/http"
  9. "time"
  10. "gitee.com/xuyiping_admin/pkg/logger/zaplog"
  11. "go.uber.org/zap"
  12. pasturePb "gitee.com/xuyiping_admin/go_proto/proto/go/backend/cow"
  13. operationPb "gitee.com/xuyiping_admin/go_proto/proto/go/backend/operation"
  14. "gitee.com/xuyiping_admin/pkg/jwt"
  15. "gitee.com/xuyiping_admin/pkg/xerr"
  16. "gorm.io/gorm"
  17. )
  18. const (
  19. CurrentUserName = "userName"
  20. CurrentFarmId = "FarmId"
  21. )
  22. // Login 用户登录
  23. func (s *StoreEntry) Login(ctx context.Context, req *pasturePb.SearchUserRequest) (*pasturePb.SystemUserResponse, error) {
  24. systemUser := &model.SystemUser{}
  25. if err := s.DB.Where("name = ?", req.Name).
  26. First(systemUser).Error; err != nil {
  27. return nil, xerr.WithStack(err)
  28. }
  29. if systemUser.Password != req.Password {
  30. return nil, xerr.Customf("密码错误,来自用户:%s", req.Name)
  31. }
  32. if systemUser.IsShow == pasturePb.IsShow_No {
  33. return nil, xerr.Customf("该账号已被禁用,请联系管理员")
  34. }
  35. if systemUser.IsDelete == pasturePb.IsShow_No {
  36. return nil, xerr.Customf("该账号已被删除,请联系管理员")
  37. }
  38. systemRole := &model.SystemRole{Id: systemUser.RoleId}
  39. if err := s.DB.Where("is_show = ? and is_delete = ?", pasturePb.IsShow_Ok, pasturePb.IsShow_Ok).
  40. First(systemRole).Error; err != nil {
  41. zaplog.Error("Login", zap.Any("systemRole", err))
  42. }
  43. jwtToken := jwt.NewJWTTokenGen(s.Cfg.AppName, s.Cfg.JwtTokenKeyConfig.PrivateKey)
  44. token, err := jwtToken.GenerateToken(systemUser.Name, s.Cfg.JwtExpireTime)
  45. if err != nil {
  46. return nil, xerr.WithStack(err)
  47. }
  48. if token == "" {
  49. return nil, xerr.Custom("获取token错误")
  50. }
  51. expires := time.Now().Add(time.Duration(s.Cfg.JwtExpireTime) * time.Second).Format(util.LayoutTime)
  52. farmList, err := s.FindPastureList(ctx, systemUser.PastureIds)
  53. if err != nil || len(farmList) == 0 {
  54. return nil, xerr.Custom("牧场信息错误")
  55. }
  56. return &pasturePb.SystemUserResponse{
  57. Code: http.StatusOK,
  58. Msg: "ok",
  59. Data: &pasturePb.SystemUserData{
  60. AccessToken: token,
  61. Expires: expires,
  62. RefreshToken: token,
  63. Username: systemUser.Name,
  64. Roles: []string{systemRole.Name},
  65. Avatar: systemUser.Avatar,
  66. FarmId: farmList[0].FarmId,
  67. },
  68. }, nil
  69. }
  70. // SearchSystemUserList 查询系统用户
  71. func (s *StoreEntry) SearchSystemUserList(ctx context.Context, req *pasturePb.SearchUserRequest, pagination *pasturePb.PaginationModel) (*pasturePb.SearchUserResponse, error) {
  72. systemUserList := make([]*model.SystemUser, 0)
  73. var count int64 = 0
  74. pref := s.DB.Model(new(model.SystemUser)).Where("is_delete = ?", operationPb.IsShow_OK)
  75. if req.Name != "" {
  76. pref.Where("name like ?", fmt.Sprintf("%s%s%s", "%", req.Name, "%"))
  77. }
  78. if req.Mobile != "" {
  79. pref.Where("mobile = ?", req.Mobile)
  80. }
  81. if req.DeptId > 0 {
  82. pref.Where("dept_id = ?", req.DeptId)
  83. }
  84. if req.IsShow > 0 {
  85. pref.Where("is_show = ?", req.IsShow)
  86. }
  87. if err := pref.Order("is_show asc,id desc").Count(&count).Limit(int(pagination.PageSize)).Offset(int(pagination.PageOffset)).
  88. Find(&systemUserList).Debug().Error; err != nil {
  89. return nil, xerr.WithStack(err)
  90. }
  91. roleList, err := s.SearchSystemRoleListByIds(ctx, []int64{})
  92. if err != nil {
  93. return nil, xerr.WithStack(err)
  94. }
  95. deptList, err := s.SearchSystemDeptListByIds(ctx, []int64{})
  96. if err != nil {
  97. return nil, xerr.WithStack(err)
  98. }
  99. return &pasturePb.SearchUserResponse{
  100. Code: http.StatusOK,
  101. Msg: "ok",
  102. Data: &pasturePb.SearchUserData{
  103. List: model.SystemUserSlice(systemUserList).ToPB(deptList, roleList),
  104. Total: int32(count),
  105. PageSize: pagination.PageSize,
  106. Page: pagination.Page,
  107. },
  108. }, nil
  109. }
  110. func (s *StoreEntry) SystemUserList(ctx context.Context) ([]*model.SystemUser, error) {
  111. systemUserList := make([]*model.SystemUser, 0)
  112. if err := s.DB.Where("is_delete = ?", pasturePb.IsShow_Ok).
  113. Where("is_show = ? ", pasturePb.IsShow_Ok).
  114. Find(&systemUserList).Error; err != nil {
  115. return nil, xerr.WithStack(err)
  116. }
  117. return systemUserList, nil
  118. }
  119. // DeleteSystemUser 删除系统用户
  120. func (s *StoreEntry) DeleteSystemUser(ctx context.Context, userId int64) error {
  121. systemUser := &model.SystemUser{
  122. Id: userId,
  123. }
  124. if err := s.DB.First(systemUser).Error; err != nil {
  125. if errors.Is(err, gorm.ErrRecordNotFound) {
  126. return xerr.Custom("该用户不存在")
  127. }
  128. return xerr.WithStack(err)
  129. }
  130. if err := s.DB.Model(systemUser).Update("is_delete", operationPb.IsShow_NO).Error; err != nil {
  131. return xerr.WithStack(err)
  132. }
  133. return nil
  134. }
  135. // IsShowSystemUser 用户是否启用
  136. func (s *StoreEntry) IsShowSystemUser(ctx context.Context, userId int64) error {
  137. systemUser := &model.SystemUser{
  138. Id: userId,
  139. }
  140. if err := s.DB.First(systemUser).Error; err != nil {
  141. if errors.Is(err, gorm.ErrRecordNotFound) {
  142. return xerr.Custom("该用户不存在")
  143. }
  144. return xerr.WithStack(err)
  145. }
  146. isShow := pasturePb.IsShow_No
  147. if systemUser.IsShow == pasturePb.IsShow_No {
  148. isShow = pasturePb.IsShow_Ok
  149. }
  150. if err := s.DB.Model(systemUser).Update("is_show", isShow).Error; err != nil {
  151. return xerr.WithStack(err)
  152. }
  153. return nil
  154. }
  155. // SystemUserCreateOrUpdate 创建或者更新系统用户
  156. func (s *StoreEntry) SystemUserCreateOrUpdate(ctx context.Context, req *pasturePb.SearchUserRequest) error {
  157. systemUser := &model.SystemUser{}
  158. if req.Id > 0 {
  159. systemUser.Id = int64(req.Id)
  160. if err := s.DB.First(systemUser).Error; err != nil {
  161. return xerr.WithStack(err)
  162. }
  163. req.Password = systemUser.Password
  164. } else {
  165. if err := s.DB.Where("name = ?", req.Name).First(systemUser).Error; err != nil {
  166. if !errors.Is(err, gorm.ErrRecordNotFound) {
  167. return xerr.WithStack(err)
  168. }
  169. } else if systemUser.Id > 0 {
  170. return xerr.Custom("该用户名称已经存在")
  171. }
  172. }
  173. if err := s.DB.Model(&model.SystemUser{}).Where(map[string]interface{}{
  174. "id": req.Id,
  175. }).Assign(map[string]interface{}{
  176. "name": req.Name,
  177. "nick_name": req.NickName,
  178. "mobile": req.Mobile,
  179. "gender": req.Gender,
  180. "password": req.Password,
  181. "dept_id": req.DeptId,
  182. "remarks": req.Remarks,
  183. "is_delete": operationPb.IsShow_OK,
  184. "is_show": req.IsShow,
  185. }).FirstOrCreate(&model.SystemUser{}).Error; err != nil {
  186. return xerr.WithStack(err)
  187. }
  188. return nil
  189. }
  190. // ResetPasswordSystemUser 重置系统用户密码
  191. func (s *StoreEntry) ResetPasswordSystemUser(ctx context.Context, req *pasturePb.ResetUserPasswordRequest) error {
  192. systemUser := &model.SystemUser{
  193. Id: int64(req.Id),
  194. }
  195. if err := s.DB.First(systemUser).Error; err != nil {
  196. if errors.Is(err, gorm.ErrRecordNotFound) {
  197. return xerr.Custom("该用户不存在")
  198. }
  199. return xerr.WithStack(err)
  200. }
  201. if err := s.DB.Model(systemUser).Update("password", req.Password).Error; err != nil {
  202. return xerr.WithStack(err)
  203. }
  204. return nil
  205. }
  206. func (s *StoreEntry) SystemUserRole(ctx context.Context, userId int64) (*pasturePb.SystemUserRoleResponse, error) {
  207. systemUser := &model.SystemUser{Id: userId}
  208. if err := s.DB.First(systemUser).Error; err != nil {
  209. if errors.Is(err, gorm.ErrRecordNotFound) {
  210. return nil, xerr.Custom("该用户不存在")
  211. }
  212. return nil, xerr.WithStack(err)
  213. }
  214. return &pasturePb.SystemUserRoleResponse{
  215. Code: http.StatusOK,
  216. Msg: "ok",
  217. Data: int32(systemUser.RoleId),
  218. }, nil
  219. }
  220. func (s *StoreEntry) SystemUserRoleSave(ctx context.Context, req *pasturePb.SystemUserRoleRequest) error {
  221. systemUser := &model.SystemUser{Id: int64(req.UserId)}
  222. if err := s.DB.First(systemUser).Error; err != nil {
  223. if errors.Is(err, gorm.ErrRecordNotFound) {
  224. return xerr.Custom("该用户不存在")
  225. }
  226. return xerr.WithStack(err)
  227. }
  228. systemRole := &model.SystemRole{Id: int64(req.RoleId)}
  229. if err := s.DB.First(systemRole).Error; err != nil {
  230. if errors.Is(err, gorm.ErrRecordNotFound) {
  231. return xerr.Custom("该角色不存在")
  232. }
  233. return xerr.WithStack(err)
  234. }
  235. if err := s.DB.Model(systemUser).Update("role_id", systemRole.Id).Error; err != nil {
  236. return xerr.WithStack(err)
  237. }
  238. return nil
  239. }
  240. // GetSystemUserMenu 返回系统用户相关菜单权限
  241. func (s *StoreEntry) GetSystemUserMenu(ctx context.Context) (*pasturePb.SystemUserMenuTreeResponse, error) {
  242. // 根据用户token获取用户数据
  243. systemUser, err := s.GetCurrentSystemUser(ctx)
  244. if err != nil {
  245. return nil, xerr.Custom("该用户数据不存在")
  246. }
  247. if systemUser.RoleId <= 0 {
  248. return nil, xerr.Custom("该用户没有角色")
  249. }
  250. // 获取用户角色数据
  251. systemRole := &model.SystemRole{}
  252. if err = s.DB.Where("id = ?", systemUser.RoleId).First(systemRole).Error; err != nil {
  253. if errors.Is(err, gorm.ErrRecordNotFound) {
  254. return nil, xerr.Custom("该用户角色不存在")
  255. }
  256. return nil, xerr.WithStack(err)
  257. }
  258. // 获取用户菜单
  259. systemMenuList := make([]*model.SystemMenu, 0)
  260. if err = s.DB.Table(fmt.Sprintf("%s as a", new(model.SystemRoleMenu).TableName())).
  261. Select("b.*").
  262. Joins("LEFT JOIN system_menu AS b ON a.menu_id = b.id").
  263. Where("a.role_id = ? and b.is_delete = ?", systemRole.Id, pasturePb.IsShow_Ok).
  264. Find(&systemMenuList).Error; err != nil {
  265. return nil, xerr.WithStack(err)
  266. }
  267. // 获取菜单权限
  268. return &pasturePb.SystemUserMenuTreeResponse{
  269. Code: http.StatusOK,
  270. Msg: "ok",
  271. Data: model.SystemMenuSlice(systemMenuList).ToTree(),
  272. }, nil
  273. }
  274. // SystemRoleCreateOrUpdate 添加角色
  275. func (s *StoreEntry) SystemRoleCreateOrUpdate(ctx context.Context, req *pasturePb.SearchRoleRequest) error {
  276. isShow := pasturePb.IsShow_Ok
  277. if req.Id > 0 {
  278. isShow = req.IsShow
  279. }
  280. if err := s.DB.Model(&model.SystemRole{}).Where(map[string]interface{}{
  281. "id": req.Id,
  282. }).Assign(map[string]interface{}{
  283. "name": req.Name,
  284. "remarks": req.Remarks,
  285. "is_delete": operationPb.IsShow_OK,
  286. "is_show": isShow,
  287. }).FirstOrCreate(&model.SystemRole{}).Error; err != nil {
  288. return xerr.WithStack(err)
  289. }
  290. return nil
  291. }
  292. // DeleteSystemRole 删除系统角色
  293. func (s *StoreEntry) DeleteSystemRole(ctx context.Context, roleId int64) error {
  294. systemRole := &model.SystemRole{
  295. Id: roleId,
  296. }
  297. if err := s.DB.First(systemRole).Error; err != nil {
  298. if errors.Is(err, gorm.ErrRecordNotFound) {
  299. return xerr.Custom("该数据不存在")
  300. }
  301. return xerr.WithStack(err)
  302. }
  303. if err := s.DB.Model(systemRole).Update("is_delete", pasturePb.IsShow_No).Error; err != nil {
  304. return xerr.WithStack(err)
  305. }
  306. return nil
  307. }
  308. // IsShowSystemRole 角色是否启用
  309. func (s *StoreEntry) IsShowSystemRole(ctx context.Context, roleId int64) error {
  310. systemRole := &model.SystemRole{
  311. Id: roleId,
  312. }
  313. if err := s.DB.First(systemRole).Error; err != nil {
  314. if errors.Is(err, gorm.ErrRecordNotFound) {
  315. return xerr.Custom("该角色不存在")
  316. }
  317. return xerr.WithStack(err)
  318. }
  319. isShow := pasturePb.IsShow_No
  320. if systemRole.IsShow == pasturePb.IsShow_No {
  321. isShow = pasturePb.IsShow_Ok
  322. }
  323. if err := s.DB.Model(systemRole).Update("is_show", isShow).Error; err != nil {
  324. return xerr.WithStack(err)
  325. }
  326. return nil
  327. }
  328. // SearchSystemRoleList 查询系统角色
  329. func (s *StoreEntry) SearchSystemRoleList(ctx context.Context, req *pasturePb.SearchRoleRequest, pagination *pasturePb.PaginationModel) (*pasturePb.SearchRoleResponse, error) {
  330. systemRoleList := make([]*model.SystemRole, 0)
  331. var count int64 = 0
  332. pref := s.DB.Model(new(model.SystemRole)).Where("is_delete = ?", operationPb.IsShow_OK)
  333. if req.Name != "" {
  334. pref.Where("name like ?", fmt.Sprintf("%s%s%s", "%", req.Name, "%"))
  335. }
  336. if req.IsShow > 0 {
  337. pref.Where("is_show = ?", req.IsShow)
  338. }
  339. if err := pref.Order("id desc").Count(&count).Limit(int(pagination.PageSize)).
  340. Offset(int(pagination.PageOffset)).Find(&systemRoleList).Error; err != nil {
  341. return nil, xerr.WithStack(err)
  342. }
  343. return &pasturePb.SearchRoleResponse{
  344. Code: http.StatusOK,
  345. Msg: "ok",
  346. Data: &pasturePb.SearchRoleData{
  347. Page: pagination.Page,
  348. Total: int32(count),
  349. PageSize: pagination.PageSize,
  350. List: model.SystemRoleSlice(systemRoleList).ToPB(),
  351. },
  352. }, nil
  353. }
  354. // SearchSystemRoleListByIds 根据id查询角色列表
  355. func (s *StoreEntry) SearchSystemRoleListByIds(ctx context.Context, ids []int64) ([]*model.SystemRole, error) {
  356. systemRoleList := make([]*model.SystemRole, 0)
  357. if err := s.DB.Model(new(model.SystemRole)).
  358. Where("is_show = ?", operationPb.IsShow_OK).
  359. Find(&systemRoleList, ids).Error; err != nil {
  360. return nil, xerr.WithStack(err)
  361. }
  362. return systemRoleList, nil
  363. }
  364. // GetRoleMenuList 查询系统角色对应的菜单数据
  365. func (s *StoreEntry) GetRoleMenuList(ctx context.Context, roleId int64) (*pasturePb.SystemRoleMenuResponse, error) {
  366. systemRole := &model.SystemRole{
  367. Id: roleId,
  368. }
  369. if err := s.DB.First(systemRole).Error; err != nil {
  370. if errors.Is(err, gorm.ErrRecordNotFound) {
  371. return nil, xerr.Custom("该数据不存在")
  372. }
  373. return nil, xerr.WithStack(err)
  374. }
  375. if systemRole.IsDelete == pasturePb.IsShow_No {
  376. return nil, xerr.Custom("该数据已被删除")
  377. }
  378. menuList := make([]*model.SystemRoleMenu, 0)
  379. if err := s.DB.Where("role_id = ?", systemRole.Id).Find(&menuList).Error; err != nil {
  380. zaplog.Error("GetSystemRoleMenuList", zap.Any("Err", err))
  381. }
  382. return &pasturePb.SystemRoleMenuResponse{
  383. Code: http.StatusOK,
  384. Msg: "ok",
  385. Data: model.SystemRoleMenuSlice(menuList).ToPB(),
  386. }, nil
  387. }
  388. // RoleMenuSave 保存系统角色对应的菜单数据
  389. func (s *StoreEntry) RoleMenuSave(ctx context.Context, res *pasturePb.SystemRoleMenuRequest) error {
  390. if len(res.MenuIds) <= 0 {
  391. return xerr.Custom("请选择菜单")
  392. }
  393. systemRole := &model.SystemRole{
  394. Id: int64(res.RoleId),
  395. }
  396. if err := s.DB.First(systemRole).Error; err != nil {
  397. if errors.Is(err, gorm.ErrRecordNotFound) {
  398. return xerr.Custom("该数据不存在")
  399. }
  400. return xerr.WithStack(err)
  401. }
  402. if err := s.DB.Transaction(func(tx *gorm.DB) error {
  403. if err := tx.Model(new(model.SystemRoleMenu)).Where("role_id = ?", systemRole.Id).Delete(&model.SystemRoleMenu{}).Error; err != nil {
  404. return xerr.WithStack(err)
  405. }
  406. for _, menuId := range res.MenuIds {
  407. if err := tx.Create(&model.SystemRoleMenu{
  408. RoleId: systemRole.Id,
  409. MenuId: int64(menuId),
  410. }).Error; err != nil {
  411. return xerr.WithStack(err)
  412. }
  413. }
  414. return nil
  415. }); err != nil {
  416. return xerr.WithStack(err)
  417. }
  418. return nil
  419. }
  420. func (s *StoreEntry) SystemRoleList(ctx context.Context) (*pasturePb.GetRoleListResponse, error) {
  421. systemRoleList := make([]*model.SystemRole, 0)
  422. if err := s.DB.Model(new(model.SystemRole)).
  423. Where("is_delete = ? and is_show = ?", pasturePb.IsShow_Ok, pasturePb.IsShow_Ok).
  424. Find(&systemRoleList).Error; err != nil {
  425. return nil, xerr.WithStack(err)
  426. }
  427. return &pasturePb.GetRoleListResponse{
  428. Code: http.StatusOK,
  429. Msg: "ok",
  430. Data: model.SystemRoleSlice(systemRoleList).ToPB(),
  431. }, nil
  432. }
  433. // CreateOrUpdateSystemMenu 添加或者更新系统菜单权限
  434. func (s *StoreEntry) CreateOrUpdateSystemMenu(ctx context.Context, req *pasturePb.SearchMenuRequest) error {
  435. if req.Id > 0 {
  436. systemMenu := &model.SystemMenu{Id: int64(req.Id)}
  437. if err := s.DB.Model(&model.SystemMenu{}).First(systemMenu).Error; err != nil {
  438. if !errors.Is(err, gorm.ErrRecordNotFound) {
  439. return xerr.WithStack(err)
  440. }
  441. }
  442. }
  443. if err := s.DB.Model(&model.SystemMenu{}).Where(map[string]interface{}{
  444. "id": req.Id,
  445. }).Assign(map[string]interface{}{
  446. "name": req.Name,
  447. "path": req.Path,
  448. "title": req.Title,
  449. "menu_type": req.MenuType,
  450. "parent_id": req.ParentId,
  451. "frame_src": req.FrameSrc,
  452. "frame_loading": model.BooleanToIsShow(req.FrameLoading),
  453. "keepalive": model.BooleanToIsShow(req.Keepalive),
  454. "hidden_tag": model.BooleanToIsShow(req.HiddenTag),
  455. "show_link": model.BooleanToIsShow(req.ShowLink),
  456. "show_parent": model.BooleanToIsShow(req.ShowParent),
  457. "icon": req.Icon,
  458. "component": req.Component,
  459. "redirect": req.Redirect,
  460. "auths": req.Auths,
  461. "rank": req.Rank,
  462. "extra_icon": req.ExtraIcon,
  463. "enter_transition": req.EnterTransition,
  464. "leave_transition": req.LeaveTransition,
  465. "active_path": req.ActivePath,
  466. "is_delete": pasturePb.IsShow_Ok,
  467. "is_show": pasturePb.IsShow_Ok,
  468. }).FirstOrCreate(&model.SystemMenu{}).Error; err != nil {
  469. return xerr.WithStack(err)
  470. }
  471. return nil
  472. }
  473. func (s *StoreEntry) SystemMenuTree(ctx context.Context) (*pasturePb.SystemMenuTreeResponse, error) {
  474. systemMenuList := make([]*model.SystemMenu, 0)
  475. if err := s.DB.Model(new(model.SystemMenu)).Where("is_delete = ?", pasturePb.IsShow_Ok).
  476. Where("is_show = ?", pasturePb.IsShow_Ok).Find(&systemMenuList).Error; err != nil {
  477. return nil, xerr.WithStack(err)
  478. }
  479. return &pasturePb.SystemMenuTreeResponse{
  480. Code: http.StatusOK,
  481. Msg: "ok",
  482. Data: model.SystemMenuSlice(systemMenuList).ToPB(),
  483. }, nil
  484. }
  485. // SearchSystemMenuList 菜单列表查询
  486. func (s *StoreEntry) SearchSystemMenuList(ctx context.Context, req *pasturePb.SearchMenuRequest, pagination *pasturePb.PaginationModel) (*pasturePb.SearchMenuResponse, error) {
  487. systemMenuList := make([]*model.SystemMenu, 0)
  488. var count int64 = 0
  489. if err := s.DB.Model(new(model.SystemMenu)).
  490. Where("is_delete = ? ", operationPb.IsShow_OK).
  491. Order("parent_id").Count(&count).
  492. Find(&systemMenuList).Error; err != nil {
  493. return nil, xerr.WithStack(err)
  494. }
  495. return &pasturePb.SearchMenuResponse{
  496. Code: http.StatusOK,
  497. Msg: "ok",
  498. Data: &pasturePb.SearchMenuData{
  499. Page: pagination.Page,
  500. Total: int32(count),
  501. PageSize: pagination.PageSize,
  502. List: model.SystemMenuSlice(systemMenuList).ToPB(),
  503. },
  504. }, nil
  505. }
  506. // DeleteSystemMenu 删除系统菜单
  507. func (s *StoreEntry) DeleteSystemMenu(ctx context.Context, menuId int64) error {
  508. systemMenu := &model.SystemMenu{Id: menuId}
  509. if err := s.DB.First(systemMenu).Error; err != nil {
  510. if errors.Is(err, gorm.ErrRecordNotFound) {
  511. return xerr.Custom("该数据不存在")
  512. }
  513. return xerr.WithStack(err)
  514. }
  515. if err := s.DB.Model(systemMenu).Update("is_delete", pasturePb.IsShow_No).Error; err != nil {
  516. return xerr.WithStack(err)
  517. }
  518. return nil
  519. }
  520. func (s *StoreEntry) SearchSystemDeptList(ctx context.Context, req *pasturePb.SearchDeptRequest, pagination *pasturePb.PaginationModel) (*pasturePb.SearchDeptResponse, error) {
  521. deptList := make([]*model.SystemDept, 0)
  522. var count int64 = 0
  523. pref := s.DB.Model(new(model.SystemDept)).Where("is_delete = ?", operationPb.IsShow_OK)
  524. if req.Name != "" {
  525. pref.Where("name like ?", fmt.Sprintf("%s%s%s", "%", req.Name, "%"))
  526. }
  527. if req.IsShow > 0 {
  528. pref.Where("is_show = ?", req.IsShow)
  529. }
  530. if err := pref.Order("sort desc").Count(&count).Limit(int(pagination.PageSize)).Offset(int(pagination.PageOffset)).
  531. Find(&deptList).Error; err != nil {
  532. return nil, xerr.WithStack(err)
  533. }
  534. systemUserList, _ := s.SystemUserList(ctx)
  535. return &pasturePb.SearchDeptResponse{
  536. Code: http.StatusOK,
  537. Msg: "ok",
  538. Data: model.SystemDeptSlice(deptList).ToPB(systemUserList),
  539. }, nil
  540. }
  541. func (s *StoreEntry) SystemDepDelete(ctx context.Context, id int64) error {
  542. dept := &model.SystemDept{Id: id}
  543. if err := s.DB.First(dept).Error; err != nil {
  544. return xerr.WithStack(err)
  545. }
  546. if dept.IsShow == pasturePb.IsShow_No {
  547. return nil
  548. }
  549. if err := s.DB.Model(dept).Update("is_delete", operationPb.IsShow_NO).Error; err != nil {
  550. return xerr.WithStack(err)
  551. }
  552. return nil
  553. }
  554. func (s *StoreEntry) SystemDeptCreateOrUpdate(ctx context.Context, req *pasturePb.SearchDeptRequest) error {
  555. if req.Id > 0 {
  556. barn := &model.SystemDept{Id: int64(req.Id)}
  557. if err := s.DB.Model(&model.SystemDept{}).First(barn).Error; err != nil {
  558. if !errors.Is(err, gorm.ErrRecordNotFound) {
  559. return xerr.WithStack(err)
  560. }
  561. }
  562. }
  563. if err := s.DB.Model(&model.SystemDept{}).Where(map[string]interface{}{
  564. "id": req.Id,
  565. }).Assign(map[string]interface{}{
  566. "name": req.Name,
  567. "sort": req.Sort,
  568. "parent_id": req.ParentId,
  569. "remarks": req.Remarks,
  570. "is_delete": operationPb.IsShow_OK,
  571. "is_show": req.IsShow,
  572. "dept_type": pasturePb.Depth_Department,
  573. "leader_id": req.LeaderId,
  574. }).FirstOrCreate(&model.SystemDept{}).Error; err != nil {
  575. return xerr.WithStack(err)
  576. }
  577. return nil
  578. }
  579. func (s *StoreEntry) SearchUserPastureList(ctx context.Context) (*pasturePb.SystemUserPastureListResponse, error) {
  580. currentUser, err := s.GetCurrentSystemUser(ctx)
  581. if err != nil {
  582. return nil, xerr.WithStack(err)
  583. }
  584. farmList, err := s.FindPastureList(ctx, currentUser.PastureIds)
  585. if err != nil {
  586. return nil, xerr.WithStack(err)
  587. }
  588. return &pasturePb.SystemUserPastureListResponse{
  589. Code: http.StatusOK,
  590. Msg: "ok",
  591. Data: model.AppPastureListSlice(farmList).ToPB(),
  592. }, err
  593. }