base_from_pb_finance.go 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "hongze/hongze_edb_lib/models"
  5. "hongze/hongze_edb_lib/services"
  6. "hongze/hongze_edb_lib/utils"
  7. "strconv"
  8. "strings"
  9. "time"
  10. )
  11. // PbFinanceController 彭博财务
  12. type PbFinanceController struct {
  13. BaseAuthController
  14. }
  15. // @Title 新增彭博指标接口
  16. // @Description 新增彭博指标接口
  17. // @Success 200 {object} models.AddEdbInfoReq
  18. // @router /add [post]
  19. func (this *PbFinanceController) Add() {
  20. br := new(models.BaseResponse).Init()
  21. var cacheKey string
  22. defer func() {
  23. this.Data["json"] = br
  24. this.ServeJSON()
  25. }()
  26. source := utils.DATA_SOURCE_PB_FINANCE
  27. var req models.AddEdbInfoReq
  28. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  29. if err != nil {
  30. br.Msg = "参数解析异常!"
  31. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  32. return
  33. }
  34. if req.EdbCode == "" {
  35. br.Msg = "请输入指标编码!"
  36. br.ErrMsg = "请输入指标编码,指标编码为空"
  37. return
  38. }
  39. cacheKey = utils.CACHE_EDB_DATA_ADD + strconv.Itoa(source) + "_" + req.EdbCode
  40. if !utils.Rc.IsExist(cacheKey) {
  41. utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
  42. defer func() {
  43. utils.Rc.Delete(cacheKey)
  44. }()
  45. //指标编码处理,将指标编码拆分成 company_code和edb_code
  46. edbCode := req.EdbCode
  47. edbCodeArr := strings.Split(edbCode, "&&")
  48. if len(edbCodeArr) != 2 {
  49. br.Msg = "指标编码异常,请传入客户编码!"
  50. br.ErrMsg = "指标编码异常,请传入客户编码"
  51. return
  52. }
  53. dataItem, err := services.GetEdbDataFromPbFinance(edbCodeArr[0], edbCodeArr[1], utils.BASE_START_DATE_UnSpace, utils.BASE_END_DATE_UnSpace)
  54. if err != nil {
  55. br.Msg = "获取指标信息失败!"
  56. br.ErrMsg = "获取指标信息失败 GetEdbDataFromPb,Err:" + err.Error()
  57. return
  58. }
  59. err = models.AddEdbDataFromPbFinance(req.EdbCode, dataItem)
  60. if err != nil {
  61. br.Msg = "获取指标信息失败!"
  62. br.ErrMsg = "获取指标信息失败 AddEdbDataFromPb,Err:" + err.Error()
  63. return
  64. }
  65. br.Ret = 200
  66. br.Success = true
  67. br.Msg = "获取成功"
  68. } else {
  69. br.Ret = 501
  70. br.Success = true
  71. br.Msg = "系统处理中,请稍后重试"
  72. }
  73. }
  74. // @Title 刷新彭博指标接口
  75. // @Description 刷新彭博指标接口
  76. // @Success 200 {object} models.RefreshEdbInfoReq
  77. // @router /refresh [post]
  78. func (this *PbFinanceController) Refresh() {
  79. br := new(models.BaseResponse).Init()
  80. var cacheKey string
  81. defer func() {
  82. this.Data["json"] = br
  83. this.ServeJSON()
  84. }()
  85. source := utils.DATA_SOURCE_PB_FINANCE
  86. var req models.RefreshEdbInfoReq
  87. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  88. if err != nil {
  89. br.Msg = "参数解析异常!"
  90. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  91. return
  92. }
  93. if req.EdbCode == "" {
  94. br.Msg = "请输入指标编码!"
  95. br.ErrMsg = "请输入指标编码,指标编码为空"
  96. return
  97. }
  98. if req.EdbInfoId <= 0 {
  99. br.Msg = "请输入指标ID!"
  100. br.ErrMsg = "请输入指标ID"
  101. return
  102. }
  103. cacheKey = utils.CACHE_EDB_DATA_REFRESH + strconv.Itoa(source) + "_" + req.EdbCode
  104. if !utils.Rc.IsExist(cacheKey) {
  105. utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
  106. defer func() {
  107. utils.Rc.Delete(cacheKey)
  108. }()
  109. //开始日期格式化
  110. startDateTime, _ := time.Parse(utils.FormatDate, req.StartDate)
  111. //指标编码处理,将指标编码拆分成 company_code和edb_code
  112. edbCode := req.EdbCode
  113. edbCodeArr := strings.Split(edbCode, "&&")
  114. if len(edbCodeArr) != 2 {
  115. br.Msg = "指标编码异常,请传入客户编码!"
  116. br.ErrMsg = "指标编码异常,请传入客户编码"
  117. return
  118. }
  119. dataItem, err := services.GetEdbDataFromPbFinance(edbCodeArr[0], edbCodeArr[1], startDateTime.Format(utils.FormatDateUnSpace), utils.BASE_END_DATE_UnSpace)
  120. if err != nil {
  121. br.Msg = "获取指标信息失败!"
  122. br.ErrMsg = "获取指标信息失败 GetEdbDataFromPb,Err:" + err.Error()
  123. return
  124. }
  125. err = models.RefreshEdbDataFromPbFinance(req.EdbInfoId, req.EdbCode, req.StartDate, dataItem)
  126. if err != nil && err.Error() != utils.ErrNoRow() {
  127. br.Msg = "刷新指标信息失败!"
  128. br.ErrMsg = "刷新指标信息失败 RefreshEdbDataFromPb,Err:" + err.Error()
  129. return
  130. }
  131. br.Ret = 200
  132. br.Success = true
  133. br.Msg = "获取成功"
  134. } else {
  135. br.Ret = 501
  136. br.Success = true
  137. br.Msg = "系统处理中,请稍后重试"
  138. }
  139. }