base_from_wind.go 5.5 KB

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