sys_base_menu.go 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140
  1. package model
  2. import (
  3. "fmt"
  4. "gin-vue-admin/global"
  5. "github.com/jinzhu/gorm"
  6. "github.com/pkg/errors"
  7. )
  8. type SysBaseMenu struct {
  9. gorm.Model
  10. MenuLevel uint `json:"-"`
  11. ParentId string `json:"parentId"`
  12. Path string `json:"path"`
  13. Name string `json:"name"`
  14. Hidden bool `json:"hidden"`
  15. Component string `json:"component"`
  16. Sort string `json:"sort"`
  17. Meta `json:"meta"`
  18. NickName string `json:"nickName"`
  19. SysAuthoritys []SysAuthority `json:"authoritys" gorm:"many2many:sys_authority_menus;"`
  20. Children []SysBaseMenu `json:"children"`
  21. }
  22. type Meta struct {
  23. Title string `json:"title"`
  24. Icon string `json:"icon"`
  25. }
  26. // @title AddBaseMenu
  27. // @description 函数的详细描述
  28. // @auth (2020/04/05 20:22 )
  29. // @param newPassword string
  30. // @return err error
  31. //增加基础路由
  32. func (b *SysBaseMenu) AddBaseMenu() (err error) {
  33. findOne := global.GVA_DB.Where("name = ?", b.Name).Find(&SysBaseMenu{}).Error
  34. if findOne != nil {
  35. b.NickName = b.Title
  36. err = global.GVA_DB.Create(b).Error
  37. } else {
  38. err = errors.New("存在重复name,请修改name")
  39. }
  40. return err
  41. }
  42. // @title DeleteBaseMenu
  43. // @description 删除基础路由
  44. // @auth (2020/04/05 20:22 )
  45. // @param newPassword string
  46. // @return err error
  47. func (b *SysBaseMenu) DeleteBaseMenu(id float64) (err error) {
  48. err = global.GVA_DB.Where("parent_id = ?", id).First(&SysBaseMenu{}).Error
  49. if err != nil {
  50. err = global.GVA_DB.Where("id = ?", id).Delete(&b).Error
  51. err = global.GVA_DB.Where("menu_id = ?", id).Unscoped().Delete(&SysMenu{}).Error
  52. } else {
  53. return errors.New("此菜单存在子菜单不可删除")
  54. }
  55. return err
  56. }
  57. // @title UpdateBaseMenu
  58. // @description 更新路由
  59. // @auth (2020/04/05 20:22 )
  60. // @param newPassword string
  61. // @return err error
  62. func (b *SysBaseMenu) UpdateBaseMenu() (err error) {
  63. upDateMap := make(map[string]interface{})
  64. upDateMap["parent_id"] = b.ParentId
  65. upDateMap["path"] = b.Path
  66. upDateMap["name"] = b.Name
  67. upDateMap["hidden"] = b.Hidden
  68. upDateMap["component"] = b.Component
  69. upDateMap["title"] = b.Title
  70. upDateMap["icon"] = b.Icon
  71. upDateMap["sort"] = b.Sort
  72. upDateMap["nick_name"] = b.Title
  73. err = global.GVA_DB.Where("id = ?", b.ID).Find(&SysBaseMenu{}).Updates(upDateMap).Error
  74. err1 := global.GVA_DB.Where("menu_id = ?", b.ID).Find(&[]SysMenu{}).Updates(upDateMap).Error
  75. fmt.Printf("菜单修改时候,关联菜单err1:%v,err:%v", err1, err)
  76. return err
  77. }
  78. // @title GetBaseMenuById
  79. // @description 当前选中角色所拥有的路由
  80. // @auth (2020/04/05 20:22 )
  81. // @param newPassword string
  82. // @return err error
  83. func (b *SysBaseMenu) GetBaseMenuById(id float64) (err error, menu SysBaseMenu) {
  84. err = global.GVA_DB.Where("id = ?", id).First(&menu).Error
  85. return
  86. }
  87. // @title GetInfoList
  88. // @description 获取路由分页
  89. // @auth (2020/04/05 20:22 )
  90. // @param newPassword string
  91. // @return err error
  92. func (b *SysBaseMenu) GetInfoList(info PageInfo) (err error, list interface{}, total int) {
  93. limit := info.PageSize
  94. offset := info.PageSize * (info.Page - 1)
  95. db := global.GVA_DB
  96. if err != nil {
  97. return
  98. } else {
  99. var menuList []SysBaseMenu
  100. err = db.Limit(limit).Offset(offset).Where("parent_id = 0").Order("sort", true).Find(&menuList).Error
  101. for i := 0; i < len(menuList); i++ {
  102. err = getBaseChildrenList(&menuList[i])
  103. }
  104. return err, menuList, total
  105. }
  106. }
  107. // @title GetBaseMenuTree
  108. // @description 获取基础路由树
  109. // @auth (2020/04/05 20:22 )
  110. // @return err error
  111. // @return menus []SysBaseMenu
  112. func (m *SysBaseMenu) GetBaseMenuTree() (err error, menus []SysBaseMenu) {
  113. err = global.GVA_DB.Where(" parent_id = ?", 0).Order("sort", true).Find(&menus).Error
  114. for i := 0; i < len(menus); i++ {
  115. err = getBaseChildrenList(&menus[i])
  116. }
  117. return err, menus
  118. }
  119. // @title getBaseChildrenList
  120. // @description get children of menu, 获取菜单的子菜单
  121. // @auth (2020/04/05 20:22 )
  122. // @param menu *SysBaseMenu
  123. // @return err error
  124. func getBaseChildrenList(menu *SysBaseMenu) (err error) {
  125. err = global.GVA_DB.Where("parent_id = ?", menu.ID).Order("sort", true).Find(&menu.Children).Error
  126. for i := 0; i < len(menu.Children); i++ {
  127. err = getBaseChildrenList(&menu.Children[i])
  128. }
  129. return err
  130. }