order.go 4.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152
  1. package cygx
  2. import (
  3. "github.com/rdlucklib/rdluck_tools/paging"
  4. "hongze/hz_crm_api/controllers"
  5. "hongze/hz_crm_api/models"
  6. "hongze/hz_crm_api/models/cygx"
  7. "hongze/hz_crm_api/utils"
  8. "strconv"
  9. "time"
  10. )
  11. // 产品内测
  12. type OrderController struct {
  13. controllers.BaseAuthController
  14. }
  15. // @Title 列表
  16. // @Description 列表接口
  17. // @Param PageSize query int true "每页数据条数"
  18. // @Param CurrentIndex query int true "当前页页码,从1开始"
  19. // @Param StartDate query string false "开始时间 ,列如2021-03-06 "
  20. // @Param EndDate query string false "结束时间,列如2021-03-06 "
  21. // @Param AdminId query string false "销售ID "
  22. // @Param OrderType query int false "订单类型 1:畅读卡订单,2:单场付费订单"
  23. // @Param PaymentProject query string false "付款项目"
  24. // @Param OrderCode query string false "订单编号"
  25. // @Param KeyWord query string false "搜索关键词"
  26. // @Success Ret=200 {object} cygx.GetCygxTacticsTimeLineResp
  27. // @router /order/list [get]
  28. func (this *OrderController) OrderList() {
  29. br := new(models.BaseResponse).Init()
  30. defer func() {
  31. this.Data["json"] = br
  32. this.ServeJSON()
  33. }()
  34. sysUser := this.SysUser
  35. if sysUser == nil {
  36. br.Msg = "请登录"
  37. br.ErrMsg = "请登录,SysUser Is Empty"
  38. br.Ret = 408
  39. return
  40. }
  41. resp := new(cygx.UserOrderListResp)
  42. pageSize, _ := this.GetInt("PageSize")
  43. currentIndex, _ := this.GetInt("CurrentIndex")
  44. orderType, _ := this.GetInt("OrderType", 1)
  45. startDate := this.GetString("StartDate")
  46. endDate := this.GetString("EndDate")
  47. adminId := this.GetString("AdminId")
  48. orderCode := this.GetString("OrderCode")
  49. keyWord := this.GetString("KeyWord")
  50. var startSize int
  51. if pageSize <= 0 {
  52. pageSize = utils.PageSize20
  53. }
  54. if currentIndex <= 0 {
  55. currentIndex = 1
  56. }
  57. startSize = utils.StartIndex(currentIndex, pageSize)
  58. var condition string
  59. var pars []interface{}
  60. if orderType > 0 { //订单类型 1:畅读卡订单,2:单场付费订单
  61. condition += ` AND order_type = ? `
  62. pars = append(pars, orderType)
  63. }
  64. if startDate != "" && endDate != "" { //时间范围
  65. condition += ` AND create_time BETWEEN ? AND ? `
  66. pars = append(pars, startDate, endDate)
  67. }
  68. if adminId != "" { //所属销售筛选
  69. condition += ` AND seller_id IN (` + adminId + `) `
  70. }
  71. if orderCode != "" { //订单编号
  72. orderCode = "%" + orderCode + "%"
  73. condition += ` AND order_code LIKE ? `
  74. pars = append(pars, orderCode)
  75. }
  76. if keyWord != "" { //用户姓名,手机号
  77. keyWord = "%" + keyWord + "%"
  78. condition += ` AND (mobile LIKE ? OR real_name LIKE ? ) `
  79. pars = append(pars, keyWord, keyWord)
  80. }
  81. total, err := cygx.GetCygxOrderCount(condition, pars)
  82. if err != nil {
  83. br.Msg = "获取失败"
  84. br.ErrMsg = "获取失败,Err:" + err.Error()
  85. return
  86. }
  87. condition += " ORDER BY order_id DESC "
  88. list, err := cygx.GetCygxOrderList(condition, pars, startSize, pageSize)
  89. if err != nil {
  90. br.Msg = "获取失败"
  91. br.ErrMsg = "获取失败,Err:" + err.Error()
  92. return
  93. }
  94. for _, v := range list {
  95. item := new(cygx.OrderListResp)
  96. item.OrderCode = v.OrderCode
  97. item.OrderMoney = v.OrderMoney
  98. item.SourceId = v.SourceId
  99. item.Source = v.Source
  100. item.SourceTitle = v.SourceTitle
  101. switch v.Source {
  102. case "article": //文章详情
  103. item.HttpUrl = utils.CYGX_WEB_URL + "/material/info/" + strconv.Itoa(v.SourceId)
  104. case "activity": //活动详情
  105. item.HttpUrl = utils.CYGX_WEB_URL + "/activity/detail/" + strconv.Itoa(v.SourceId)
  106. }
  107. item.OrderStatus = v.OrderStatus
  108. if v.OrderStatus == 0 {
  109. item.OrderStatusText = "已取消"
  110. } else if v.OrderStatus == 1 {
  111. item.OrderStatusText = "待支付"
  112. } else if v.OrderStatus == 2 {
  113. item.OrderStatusText = "已支付"
  114. }
  115. item.UserId = v.UserId
  116. item.RealName = v.RealName
  117. item.Mobile = v.Mobile
  118. item.Email = v.Email
  119. item.CompanyId = v.CompanyId
  120. item.CompanyName = v.CompanyName
  121. item.SellerName = v.SellerName
  122. item.InviteName = "推荐人"
  123. item.PaymentProject = v.GoodsName
  124. if v.OrderStatus == 2 {
  125. item.PayTime = v.PayTime.Format(utils.FormatDateTime)
  126. }
  127. if orderType == 1 {
  128. item.StartDate = time.Now().Format(utils.FormatDateTime)
  129. item.EndDate = time.Now().AddDate(0, 0, 3).Format(utils.FormatDateTime)
  130. }
  131. item.CreateTime = v.CreateTime.Format(utils.FormatDateTime)
  132. resp.List = append(resp.List, item)
  133. }
  134. page := paging.GetPaging(currentIndex, pageSize, total)
  135. resp.Paging = page
  136. br.Ret = 200
  137. br.Success = true
  138. br.Msg = "获取成功"
  139. br.Data = resp
  140. }