order.go 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312
  1. package services
  2. import (
  3. "context"
  4. "encoding/json"
  5. "errors"
  6. "fmt"
  7. "hongze/hongze_cygx/models/order"
  8. "hongze/hongze_cygx/utils"
  9. "time"
  10. )
  11. // CancelCygxOrder 关闭到期个人用户研选权限
  12. func CancelCygxOrder(cont context.Context) (err error) {
  13. defer func() {
  14. if err != nil {
  15. fmt.Println(err)
  16. go utils.SendAlarmMsg(fmt.Sprint("自动取消十分钟之内没有付款的的订单 CancelCygxOrder ,err:", err.Error()), 2)
  17. }
  18. }()
  19. var condition string
  20. var pars []interface{}
  21. endTime := time.Now().Add(-10 * time.Minute)
  22. condition = ` AND order_status = 1 AND create_time < ? `
  23. pars = append(pars, endTime)
  24. orderList, e := order.GetCygxOrderList(condition, pars, 0, 999)
  25. if e != nil && e.Error() != utils.ErrNoRow() {
  26. err = errors.New("GetCygxOrderList, Err: " + e.Error())
  27. return
  28. }
  29. fmt.Println(len(orderList))
  30. if len(orderList) == 0 {
  31. return
  32. }
  33. //订单量不大,先这么写吧
  34. for _, v := range orderList {
  35. fmt.Println(v.OrderCode)
  36. e = order.CancelCygxOrder(v)
  37. if e != nil && e.Error() != utils.ErrNoRow() {
  38. err = errors.New("CancelCygxOrder, Err: " + e.Error())
  39. return
  40. }
  41. }
  42. return
  43. }
  44. //func init() {
  45. // HandleOrderRefundHandleask()
  46. //}
  47. // GetQueryOrderByOutTradeNoTask 定时任务主动获取订单支付状态
  48. func GetQueryOrderByOutTradeNoTask(cont context.Context) (err error) {
  49. //func GetQueryOrderByOutTradeNoTask() (err error) {
  50. defer func() {
  51. if err != nil {
  52. fmt.Println(err)
  53. go utils.SendAlarmMsg(fmt.Sprint("自动取消十分钟之内没有付款的的订单 CancelCygxOrder ,err:", err.Error()), 2)
  54. }
  55. }()
  56. var condition string
  57. var pars []interface{}
  58. endTime := time.Now().Add(-10 * time.Minute)
  59. condition = ` AND order_status = 1 AND create_time > ? ` //获取十分钟之内待支付的订单
  60. pars = append(pars, endTime)
  61. orderList, e := order.GetCygxOrderList(condition, pars, 0, 999)
  62. if e != nil && e.Error() != utils.ErrNoRow() {
  63. err = errors.New("GetCygxOrderList, Err: " + e.Error())
  64. return
  65. }
  66. fmt.Println(len(orderList))
  67. if len(orderList) == 0 {
  68. return
  69. }
  70. //订单量不大,先这么写吧
  71. for _, v := range orderList {
  72. tradeState, statusCode, itemResp := GetQueryOrderByOutTradeNo(v.OrderCode)
  73. if tradeState == "SUCCESS" && statusCode == 200 {
  74. go HandleOrderHandle(itemResp)
  75. }
  76. }
  77. return
  78. }
  79. // 手动处理支付订单回调
  80. func HandleOrderHandle(itemCallback *Transaction) {
  81. var err error
  82. defer func() {
  83. if err != nil {
  84. fmt.Println(err)
  85. go utils.SendAlarmMsg(fmt.Sprint("手动处理支付订单回调失败 HandleOrderHandle, err:", err.Error()), 2)
  86. }
  87. }()
  88. outTradeNo := itemCallback.OutTradeNo
  89. orderDetail, e := order.GetCygxOrderDetailByOrderCode(outTradeNo)
  90. if e != nil {
  91. err = errors.New("GetCygxOrderDetailByOrderCode, Err: " + e.Error())
  92. return
  93. }
  94. go AddCygxOrderPayment(itemCallback) // 记录支付交易信息
  95. if itemCallback.TradeState != "SUCCESS" { // 回调显示支付不成功,模版消息推送
  96. if e != nil {
  97. err = errors.New("支付失败, OrderCode: " + outTradeNo)
  98. return
  99. }
  100. }
  101. //修改过状态的不再二次处理
  102. if orderDetail.OrderStatus == 2 {
  103. return
  104. }
  105. itemOrder := new(order.CygxOrder)
  106. itemOrder.OrderCode = itemCallback.OutTradeNo
  107. itemOrder.PayTime = itemCallback.SuccessTime
  108. itemOrder.PayMoney = float64(float64(itemCallback.Amount.PayerTotal) / 100) // 金额分转换处理
  109. itemOrder.OrderStatus = 2
  110. itemOrder.OutTradeCode = itemCallback.TransactionId
  111. //文章处理逻辑 OrderType int `comment:"订单类型,1:畅读卡订单,2:单场付费订单"`
  112. if orderDetail.OrderType == 1 {
  113. itemUserCard := new(order.CygxOrderUserCard)
  114. itemUserCard.OrderCode = orderDetail.OrderCode
  115. itemUserCard.UserId = orderDetail.UserId
  116. itemUserCard.Mobile = orderDetail.Mobile
  117. itemUserCard.Email = orderDetail.Email
  118. itemUserCard.CompanyId = orderDetail.CompanyId
  119. itemUserCard.CompanyName = orderDetail.CompanyName
  120. itemUserCard.RealName = orderDetail.RealName
  121. itemUserCard.SellerName = orderDetail.SellerName
  122. itemUserCard.CreateTime = time.Now()
  123. itemUserCard.ModifyTime = time.Now()
  124. itemUserCard.RegisterPlatform = orderDetail.RegisterPlatform
  125. if orderDetail.GoodsId == 1 {
  126. itemUserCard.StartDate = itemOrder.PayTime
  127. itemUserCard.EndDate = itemOrder.PayTime.AddDate(0, 0, 1)
  128. itemUserCard.CardType = "日卡"
  129. } else {
  130. now := time.Now()
  131. itemUserCard.StartDate = time.Date(now.Year(), now.Month(), now.Day(), 0, 0, 0, 0, time.Local)
  132. itemUserCard.EndDate = itemUserCard.StartDate.AddDate(0, 1, 0)
  133. itemUserCard.CardType = "月卡"
  134. }
  135. e = order.AddCygxOrderUserCard(itemUserCard, itemOrder)
  136. if e != nil {
  137. err = errors.New("AddCygxOrderUserCard, Err: " + e.Error())
  138. return
  139. }
  140. } else if orderDetail.OrderType == 2 {
  141. //如果是活动,把单场付费信息的活动写入 用户虚拟资产表
  142. itemOrderVirtualAsset := new(order.CygxOrderVirtualAsset)
  143. itemOrderVirtualAsset.OrderCode = orderDetail.OrderCode
  144. itemOrderVirtualAsset.UserId = orderDetail.UserId
  145. itemOrderVirtualAsset.Mobile = orderDetail.Mobile
  146. itemOrderVirtualAsset.Email = orderDetail.Email
  147. itemOrderVirtualAsset.CompanyId = orderDetail.CompanyId
  148. itemOrderVirtualAsset.CompanyName = orderDetail.CompanyName
  149. itemOrderVirtualAsset.RealName = orderDetail.RealName
  150. itemOrderVirtualAsset.SellerName = orderDetail.SellerName
  151. itemOrderVirtualAsset.Source = orderDetail.Source
  152. itemOrderVirtualAsset.SourceId = orderDetail.SourceId
  153. itemOrderVirtualAsset.CreateTime = time.Now()
  154. itemOrderVirtualAsset.ModifyTime = time.Now()
  155. e = order.AddCygxOrderVirtualAsset(itemOrderVirtualAsset, itemOrder)
  156. if e != nil {
  157. err = errors.New("AddCygxOrderVirtualAsset, Err: " + e.Error())
  158. return
  159. }
  160. }
  161. return
  162. }
  163. // 添加操作记录
  164. func AddCygxOrderPayment(itemCallback *Transaction) {
  165. var err error
  166. defer func() {
  167. if err != nil {
  168. fmt.Println(err)
  169. go utils.SendAlarmMsg(fmt.Sprint("处理订单回调信息失败 HandleOrderHandle, err:", err.Error()), 2)
  170. }
  171. }()
  172. itemPay := new(order.CygxOrderPayment)
  173. itemPay.OrderCode = itemCallback.OutTradeNo
  174. itemPay.OutTradeCode = itemCallback.TransactionId
  175. itemPay.PayBody = itemCallback.TradeStateDesc
  176. jsonData, _ := json.Marshal(itemCallback)
  177. itemPay.PayDetail = string(jsonData)
  178. itemPay.PayMoney = float64(float64(itemCallback.Amount.PayerTotal) / 100) // 金额分转换处理
  179. itemPay.PayStatus = itemCallback.TradeState
  180. itemPay.CreateTime = time.Now()
  181. itemPay.PaymentType = 1
  182. e := order.AddCygxOrderPayment(itemPay)
  183. if e != nil {
  184. err = errors.New("AddCygxOrderPayment, Err: " + e.Error())
  185. return
  186. }
  187. return
  188. }
  189. // 定时任务处理退款回调
  190. func HandleOrderRefundHandleask(cont context.Context) (err error) {
  191. //func HandleOrderRefundHandleask() (err error) {
  192. defer func() {
  193. if err != nil {
  194. fmt.Println(err)
  195. go utils.SendAlarmMsg(fmt.Sprint("自动取消十分钟之内没有付款的的订单 CancelCygxOrder ,err:", err.Error()), 2)
  196. }
  197. }()
  198. var condition string
  199. var pars []interface{}
  200. //endTime := time.Now().Add(-10 * time.Minute)
  201. condition = ` AND order_status = 4 ` //获取十分钟之内待支付的订单
  202. //pars = append(pars, endTime)
  203. orderList, e := order.GetCygxOrderList(condition, pars, 0, 999)
  204. if e != nil && e.Error() != utils.ErrNoRow() {
  205. err = errors.New("GetCygxOrderList, Err: " + e.Error())
  206. return
  207. }
  208. fmt.Println(len(orderList))
  209. if len(orderList) == 0 {
  210. return
  211. }
  212. //订单量不大,先这么写吧
  213. for _, v := range orderList {
  214. tradeState, statusCode, itemResp := GetQueryOrderByOutTradeNo(v.OrderCode)
  215. if tradeState == "REFUND" && statusCode == 200 {
  216. go HandleOrderRefundHandle(itemResp)
  217. }
  218. }
  219. return
  220. }
  221. // 处理退款订单回调
  222. func HandleOrderRefundHandle(itemCallback *Transaction) {
  223. var err error
  224. defer func() {
  225. if err != nil {
  226. fmt.Println(err)
  227. go utils.SendAlarmMsg(fmt.Sprint("处理退款订单回调信息失败 HandleOrderRefundHandle, err:", err.Error()), 2)
  228. }
  229. }()
  230. outTradeNo := itemCallback.OutTradeNo
  231. orderDetail, e := order.GetCygxOrderDetailByOrderCode(outTradeNo)
  232. if e != nil {
  233. err = errors.New("GetCygxOrderDetailByOrderCode, Err: " + e.Error())
  234. return
  235. }
  236. //go AddCygxOrderPayment(itemCallback) // 记录支付交易信息
  237. //修改过状态的不再二次处理
  238. if orderDetail.OrderStatus == 3 {
  239. return
  240. }
  241. itemOrder := new(order.CygxOrder)
  242. itemOrder.OrderCode = itemCallback.OutTradeNo
  243. itemOrder.RefundTime = itemCallback.SuccessTime
  244. itemOrder.RefundMoney = float64(float64(itemCallback.Amount.PayerTotal) / 100) // 金额分转换处理
  245. itemOrder.OrderStatus = 3
  246. //文章处理逻辑 OrderType int `comment:"订单类型,1:畅读卡订单,2:单场付费订单"`
  247. if orderDetail.OrderType == 1 {
  248. itemUserCard := new(order.CygxOrderUserCard)
  249. itemUserCard.OrderCode = orderDetail.OrderCode
  250. itemUserCard.UserId = orderDetail.UserId
  251. itemUserCard.Mobile = orderDetail.Mobile
  252. itemUserCard.Email = orderDetail.Email
  253. itemUserCard.CompanyId = orderDetail.CompanyId
  254. itemUserCard.CompanyName = orderDetail.CompanyName
  255. itemUserCard.RealName = orderDetail.RealName
  256. itemUserCard.SellerName = orderDetail.SellerName
  257. itemUserCard.CreateTime = time.Now()
  258. itemUserCard.ModifyTime = time.Now()
  259. itemUserCard.RegisterPlatform = orderDetail.RegisterPlatform
  260. if orderDetail.GoodsId == 1 {
  261. itemUserCard.CardType = "日卡"
  262. } else {
  263. itemUserCard.CardType = "月卡"
  264. }
  265. e = order.RemoveCygxOrderUserCard(itemUserCard, itemOrder) // 移除用户
  266. if e != nil {
  267. err = errors.New("RemoveCygxOrderUserCard, Err: " + e.Error())
  268. return
  269. }
  270. } else if orderDetail.OrderType == 2 {
  271. //如果是活动,把单场付费信息的活动写入 用户虚拟资产表
  272. itemOrderVirtualAsset := new(order.CygxOrderVirtualAsset)
  273. itemOrderVirtualAsset.OrderCode = orderDetail.OrderCode
  274. itemOrderVirtualAsset.UserId = orderDetail.UserId
  275. itemOrderVirtualAsset.Mobile = orderDetail.Mobile
  276. itemOrderVirtualAsset.Email = orderDetail.Email
  277. itemOrderVirtualAsset.CompanyId = orderDetail.CompanyId
  278. itemOrderVirtualAsset.CompanyName = orderDetail.CompanyName
  279. itemOrderVirtualAsset.RealName = orderDetail.RealName
  280. itemOrderVirtualAsset.SellerName = orderDetail.SellerName
  281. itemOrderVirtualAsset.Source = orderDetail.Source
  282. itemOrderVirtualAsset.SourceId = orderDetail.SourceId
  283. itemOrderVirtualAsset.CreateTime = time.Now()
  284. itemOrderVirtualAsset.ModifyTime = time.Now()
  285. e = order.RemoveCygxOrderVirtualAsset(itemOrderVirtualAsset, itemOrder)
  286. if e != nil {
  287. err = errors.New("AddCygxOrderVirtualAsset, Err: " + e.Error())
  288. return
  289. }
  290. }
  291. fmt.Println(orderDetail.Source)
  292. return
  293. }