base_from_pb_finance.go 5.1 KB

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