base_from_wind.go 6.0 KB

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