promotion_upgrade_level.go 2.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798
  1. package app
  2. import (
  3. "go_server/base/core"
  4. model "go_server/model/biz_modules/app"
  5. "go_server/model/common/response"
  6. "go_server/service/base"
  7. "github.com/gin-gonic/gin"
  8. "strings"
  9. )
  10. type PromotionUpgradeLevelService struct {
  11. base.BizCommonService
  12. }
  13. func (s *PromotionUpgradeLevelService) Get(c *gin.Context) {
  14. s.SetDbAlias("app")
  15. base.NewBaseHandler(model.NewPromotionUpgradeLevel()).Get(c, s.DB())
  16. }
  17. func (s *PromotionUpgradeLevelService) Find(c *gin.Context) {
  18. s.SetDbAlias("app")
  19. type request[T any] struct {
  20. base.ListRequest[T]
  21. Id *int64 `form:"id"`
  22. IsExport *bool `form:"isExport"`
  23. Fields *string `form:"fields"` // 指定返回字段 , 分割
  24. BeginTime *int64 `form:"beginTime"`
  25. EndTime *int64 `form:"endTime"`
  26. Uid *string `form:"uid"`
  27. UserId *int64 `form:"userId"`
  28. }
  29. req := new(request[model.PromotionUpgradeLevel])
  30. if err := c.BindQuery(req); err != nil {
  31. response.Resp(c, err.Error())
  32. return
  33. }
  34. db := s.DB()
  35. if req.Id != nil && *req.Id != 0 {
  36. db = db.Where("id", req.Id)
  37. }
  38. if req.UserId != nil && *req.UserId != 0 {
  39. db = db.Where("user_id", req.UserId)
  40. }
  41. if req.Uid != nil && *req.Uid != "" {
  42. db = db.Where("uid", req.Uid)
  43. }
  44. if req.BeginTime != nil && *req.BeginTime > 0 && req.EndTime != nil && *req.EndTime > 0 {
  45. db = db.Where("created_at between ? and ?", *req.BeginTime, *req.EndTime)
  46. }
  47. // 导出处理
  48. fields := make([]string, 0)
  49. if req.Fields != nil {
  50. fields = strings.Split(*req.Fields, ",")
  51. }
  52. var url string
  53. colInfo := s.GetColumnCommentFromStruct(model.PromotionUpgradeLevel{})
  54. var err error
  55. if req.IsExport != nil && *req.IsExport {
  56. if len(fields) == 0 {
  57. for _, col := range colInfo {
  58. fields = append(fields, col.Field)
  59. }
  60. }
  61. core.Log.Infof("导出的字段:%s", fields)
  62. url, err = base.ExportCsv[model.PromotionUpgradeLevel](db, fields, colInfo)
  63. if err != nil {
  64. response.Resp(c, err.Error())
  65. return
  66. }
  67. }
  68. resp, err := base.NewQueryBaseHandler(model.NewPromotionUpgradeLevel()).List(db, req)
  69. if err != nil {
  70. response.Resp(c, err.Error())
  71. return
  72. }
  73. response.Resp(c, map[string]interface{}{
  74. "url": url,
  75. "cols": colInfo,
  76. "list": resp.List,
  77. "paging": resp.Paging,
  78. })
  79. }
  80. func (s *PromotionUpgradeLevelService) Comment(c *gin.Context) {
  81. s.SetDbAlias("app")
  82. dbs, err := s.GetColumnComment("app", model.NewPromotionUpgradeLevel().TableName())
  83. if err != nil {
  84. response.Resp(c, "获取失败")
  85. return
  86. } else {
  87. response.Resp(c, gin.H{"dbs": dbs})
  88. return
  89. }
  90. }