base_from_pb_finance.go 5.7 KB

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