base_from_wind.go 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182
  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. //wind
  12. type WindController struct {
  13. BaseAuthController
  14. }
  15. // @Title 新增wind指标接口
  16. // @Description 新增wind指标接口
  17. // @Success 200 {object} models.AddEdbInfoReq
  18. // @router /add [post]
  19. func (this *WindController) Add() {
  20. br := new(models.BaseResponse).Init()
  21. var cacheKey string
  22. defer func() {
  23. utils.Rc.Delete(cacheKey)
  24. this.Data["json"] = br
  25. this.ServeJSON()
  26. }()
  27. source := utils.DATA_SOURCE_WIND
  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. //期货数据,就默认到今天,特殊处理下
  44. endDate := utils.BASE_END_DATE
  45. if strings.Contains(req.EdbCode, ".") {
  46. endDate = time.Now().Format(utils.FormatDate)
  47. }
  48. windUrl, err := GetServerUrl()
  49. if err != nil {
  50. br.Msg = "获取使用的wind地址失败!"
  51. br.ErrMsg = "获取使用的wind地址失败,err:" + err.Error()
  52. return
  53. }
  54. dataItem, errCode, err := services.GetEdbDataFromWindUrl(windUrl, req.EdbCode, utils.BASE_START_DATE, endDate)
  55. //dataItem, errCode, err := services.GetEdbDataFromWind(req.EdbCode, utils.BASE_START_DATE, endDate)
  56. if errCode == 421 { //指标超限
  57. br.Ret = 421
  58. }
  59. if err != nil {
  60. br.Msg = "获取指标信息失败!"
  61. br.ErrMsg = "获取指标信息失败 GetEdbDataFromWind,Err:" + err.Error()
  62. return
  63. }
  64. err = models.AddEdbDataFromWind(req.EdbCode, dataItem)
  65. if err != nil {
  66. br.Msg = "获取指标信息失败!"
  67. br.ErrMsg = "获取指标信息失败 AddEdbDataFromWind,Err:" + err.Error()
  68. return
  69. }
  70. br.Ret = 200
  71. br.Success = true
  72. br.Msg = "获取成功"
  73. } else {
  74. br.Ret = 501
  75. br.Success = true
  76. br.Msg = "系统处理中,请稍后重试"
  77. }
  78. }
  79. // @Title 刷新wind指标接口
  80. // @Description 刷新wind指标接口
  81. // @Success 200 {object} models.RefreshEdbInfoReq
  82. // @router /refresh [post]
  83. func (this *WindController) Refresh() {
  84. br := new(models.BaseResponse).Init()
  85. var cacheKey string
  86. defer func() {
  87. utils.Rc.Delete(cacheKey)
  88. this.Data["json"] = br
  89. this.ServeJSON()
  90. }()
  91. source := utils.DATA_SOURCE_WIND
  92. var req models.RefreshEdbInfoReq
  93. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  94. if err != nil {
  95. br.Msg = "参数解析异常!"
  96. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  97. return
  98. }
  99. if req.EdbCode == "" {
  100. br.Msg = "请输入指标编码!"
  101. br.ErrMsg = "请输入指标编码,指标编码为空"
  102. return
  103. }
  104. if req.EdbInfoId <= 0 {
  105. br.Msg = "请输入指标ID!"
  106. br.ErrMsg = "请输入指标ID"
  107. return
  108. }
  109. cacheKey = utils.CACHE_EDB_DATA_REFRESH + strconv.Itoa(source) + "_" + req.EdbCode
  110. if !utils.Rc.IsExist(cacheKey) {
  111. utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
  112. //获取指标信息
  113. edbInfo, err := models.GetEdbInfoById(req.EdbInfoId)
  114. if err != nil {
  115. br.Msg = "查询指标信息失败!"
  116. br.ErrMsg = "查询指标信息失败 Err:" + err.Error()
  117. return
  118. }
  119. //期货数据,就默认到今天,特殊处理下
  120. endDate := utils.BASE_END_DATE
  121. if strings.Contains(req.EdbCode, ".") {
  122. endDate = time.Now().Format(utils.FormatDate)
  123. }
  124. dataItem, errCode, err := services.GetEdbDataFromWindUrl(edbInfo.ServerUrl, req.EdbCode, req.StartDate, endDate)
  125. if errCode == 421 { //指标超限
  126. br.Ret = 421
  127. }
  128. if err != nil {
  129. br.Msg = "获取指标信息失败!"
  130. br.ErrMsg = "获取指标信息失败 GetEdbDataFromWind,Err:" + err.Error()
  131. return
  132. }
  133. err = models.RefreshEdbDataFromWind(req.EdbInfoId, req.EdbCode, req.StartDate, dataItem)
  134. if err != nil && err.Error() != utils.ErrNoRow() {
  135. br.Msg = "刷新指标信息失败!"
  136. br.ErrMsg = "刷新指标信息失败 RefreshEdbDataFromWind,Err:" + err.Error()
  137. return
  138. }
  139. br.Ret = 200
  140. br.Success = true
  141. br.Msg = "获取成功"
  142. } else {
  143. br.Ret = 501
  144. br.Success = true
  145. br.Msg = "系统处理中,请稍后重试"
  146. }
  147. }
  148. // GetServerUrl 获取服务器地址
  149. func GetServerUrl() (windUrl string, err error) {
  150. list, err := models.GetServerUrlCountGroupByServerUrl()
  151. if err != nil {
  152. return
  153. }
  154. windUrlNum := 0
  155. //现有系统的wind数据服务地址分配
  156. windUrlMap := make(map[string]int)
  157. for _, v := range list {
  158. windUrlMap[v.ServerUrl] = v.Total
  159. }
  160. for _, tmpWind := range utils.Hz_Wind_Data_Url_LIST {
  161. tmpWindUrl := tmpWind.Url
  162. tmpNum := windUrlMap[tmpWindUrl]
  163. if windUrl == `` || (windUrl != `` && tmpNum < windUrlNum) {
  164. windUrl = tmpWindUrl
  165. windUrlNum = tmpNum
  166. }
  167. }
  168. return
  169. }