sys_base_menu.go 4.4 KB

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