base_from_wind.go 7.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "errors"
  5. "eta/eta_index_lib/logic"
  6. "eta/eta_index_lib/models"
  7. "eta/eta_index_lib/services"
  8. "eta/eta_index_lib/utils"
  9. "strconv"
  10. "strings"
  11. "time"
  12. )
  13. // wind
  14. type WindController struct {
  15. BaseAuthController
  16. }
  17. // @Title 新增wind指标接口
  18. // @Description 新增wind指标接口
  19. // @Success 200 {object} models.AddEdbInfoReq
  20. // @router /add [post]
  21. func (this *WindController) Add() {
  22. br := new(models.BaseResponse).Init()
  23. var cacheKey string
  24. defer func() {
  25. utils.Rc.Delete(cacheKey)
  26. this.Data["json"] = br
  27. this.ServeJSON()
  28. }()
  29. source := utils.DATA_SOURCE_WIND
  30. var req models.AddEdbInfoReq
  31. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  32. if err != nil {
  33. br.Msg = "参数解析异常!"
  34. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  35. return
  36. }
  37. if req.EdbCode == "" {
  38. br.Msg = "请输入指标编码!"
  39. br.ErrMsg = "请输入指标编码,指标编码为空"
  40. return
  41. }
  42. cacheKey = utils.CACHE_EDB_DATA_ADD + strconv.Itoa(source) + "_" + req.EdbCode
  43. if !utils.Rc.IsExist(cacheKey) {
  44. utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
  45. //期货数据,就默认到今天,特殊处理下
  46. endDate := utils.BASE_END_DATE
  47. if strings.Contains(req.EdbCode, ".") {
  48. endDate = time.Now().Format(utils.FormatDate)
  49. }
  50. windUrl := ``
  51. terminalCode := ""
  52. // 试用平台的话,需要额外从弘则这边获取下地址
  53. if utils.BusinessCode == utils.HZ_TRIAL_BUSSINESS_CODE {
  54. // todo 从体验版中获取对应的终端信息
  55. tmpWindUrl, err, errMsg := services.GetHzWindUrl(req.EdbCode, source)
  56. if err != nil {
  57. br.Msg = "添加失败!"
  58. br.ErrMsg = "添加失败,Err:" + err.Error()
  59. if errMsg != `` {
  60. br.Msg = errMsg
  61. }
  62. return
  63. }
  64. windUrl = tmpWindUrl
  65. }
  66. if windUrl == `` {
  67. terminalInfo, err := services.GetTerminal(utils.DATA_SOURCE_WIND, "")
  68. if err != nil {
  69. br.Msg = "获取可以使用的wind地址失败!"
  70. br.ErrMsg = "获取可以使用的wind地址失败,err:" + err.Error()
  71. return
  72. }
  73. windUrl = terminalInfo.ServerUrl
  74. terminalCode = terminalInfo.TerminalCode
  75. }
  76. if windUrl == `` {
  77. br.Msg = "没有配置wind地址!"
  78. br.ErrMsg = "没有配置wind地址"
  79. return
  80. }
  81. // 设置指标与终端关系的缓存
  82. windUrlCacheKey := utils.CACHE_WIND_URL + ":" + req.EdbCode
  83. _ = utils.Rc.SetNX(windUrlCacheKey, windUrl, utils.GetTodayLastSecond())
  84. // 设置指标与终端关系的缓存
  85. terminalCodeCacheKey := utils.CACHE_EDB_TERMINAL_CODE_URL + req.EdbCode
  86. _ = utils.Rc.SetNX(terminalCodeCacheKey, terminalCode, utils.GetTodayLastSecond())
  87. //windUrl = utils.Hz_Wind_Data_Url_LIST[1].Url
  88. dataItem, errCode, err := services.GetEdbDataFromWindUrl(windUrl, req.EdbCode, utils.BASE_START_DATE, endDate)
  89. //dataItem, errCode, err := services.GetEdbDataFromWind(req.EdbCode, utils.BASE_START_DATE, endDate)
  90. if errCode == 421 { //指标超限
  91. br.Ret = 421
  92. br.Msg = "指标超限!"
  93. return
  94. }
  95. // 指标下架
  96. if errCode == services.WindNoAuthCode {
  97. br.Ret = 4052
  98. br.Msg = "指标已下架"
  99. return
  100. }
  101. if err != nil {
  102. br.Msg = "获取指标信息失败!"
  103. br.ErrMsg = "获取指标信息失败 GetEdbDataFromWind,Err:" + err.Error()
  104. return
  105. }
  106. err = models.AddEdbDataFromWind(req.EdbCode, dataItem)
  107. if err != nil {
  108. br.Msg = "获取指标信息失败!"
  109. br.ErrMsg = "获取指标信息失败 AddEdbDataFromWind,Err:" + err.Error()
  110. return
  111. }
  112. br.Ret = 200
  113. br.Success = true
  114. br.Msg = "获取成功"
  115. } else {
  116. br.Ret = 501
  117. br.Success = true
  118. br.Msg = "系统处理中,请稍后重试"
  119. }
  120. }
  121. // @Title 刷新wind指标接口
  122. // @Description 刷新wind指标接口
  123. // @Success 200 {object} models.RefreshEdbInfoReq
  124. // @router /refresh [post]
  125. func (this *WindController) Refresh() {
  126. br := new(models.BaseResponse).Init()
  127. var cacheKey string
  128. defer func() {
  129. this.Data["json"] = br
  130. this.ServeJSON()
  131. }()
  132. source := utils.DATA_SOURCE_WIND
  133. var req models.RefreshEdbInfoReq
  134. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  135. if err != nil {
  136. br.Msg = "参数解析异常!"
  137. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  138. return
  139. }
  140. if req.EdbCode == "" {
  141. br.Msg = "请输入指标编码!"
  142. br.ErrMsg = "请输入指标编码,指标编码为空"
  143. return
  144. }
  145. if req.EdbInfoId <= 0 {
  146. br.Msg = "请输入指标ID!"
  147. br.ErrMsg = "请输入指标ID"
  148. return
  149. }
  150. cacheKey = utils.CACHE_EDB_DATA_REFRESH + strconv.Itoa(source) + "_" + req.EdbCode
  151. if utils.Rc.IsExist(cacheKey) {
  152. br.Ret = 501
  153. br.Success = true
  154. br.Msg = "系统处理中,请稍后重试"
  155. return
  156. }
  157. utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
  158. defer func() {
  159. utils.Rc.Delete(cacheKey)
  160. }()
  161. //获取指标信息
  162. edbInfo, err := models.GetEdbInfoById(req.EdbInfoId)
  163. if err != nil {
  164. br.Msg = "查询指标信息失败!"
  165. br.ErrMsg = "查询指标信息失败 Err:" + err.Error()
  166. return
  167. }
  168. //期货数据,就默认到今天,特殊处理下
  169. endDate := utils.BASE_END_DATE
  170. if strings.Contains(req.EdbCode, ".") {
  171. endDate = time.Now().Format(utils.FormatDate)
  172. }
  173. dataItem, errCode, err := services.GetEdbDataFromWindUrl(edbInfo.ServerUrl, req.EdbCode, req.StartDate, endDate)
  174. if errCode == 421 { //指标超限
  175. br.Ret = 421
  176. br.Msg = "指标超限!"
  177. return
  178. }
  179. // 忽略掉指标下架的错误, 并更新指标为停止更新
  180. if errCode == services.WindNoAuthCode {
  181. edbInfo.NoUpdate = 1
  182. edbInfo.ModifyTime = time.Now().Local()
  183. if e := edbInfo.Update([]string{"NoUpdate", "ModifyTime"}); e != nil {
  184. br.Msg = "刷新失败"
  185. br.ErrMsg = "更新wind指标停更失败, Err: " + e.Error()
  186. return
  187. }
  188. br.Ret = 200
  189. br.Msg = "操作成功"
  190. return
  191. }
  192. if err != nil {
  193. br.Msg = "获取指标信息失败!"
  194. br.ErrMsg = "获取指标信息失败 GetEdbDataFromWind,Err:" + err.Error()
  195. return
  196. }
  197. err = models.RefreshEdbDataFromWind(req.EdbInfoId, req.EdbCode, req.StartDate, dataItem)
  198. if err != nil && err.Error() != utils.ErrNoRow() {
  199. br.Msg = "刷新指标信息失败!"
  200. br.ErrMsg = "刷新指标信息失败 RefreshEdbDataFromWind,Err:" + err.Error()
  201. return
  202. }
  203. // 更新指标最大最小值
  204. err, errMsg := models.UnifiedModifyEdbInfoMaxAndMinInfo(edbInfo)
  205. if err != nil {
  206. br.Msg = errMsg
  207. br.ErrMsg = err.Error()
  208. return
  209. }
  210. // 更新ES
  211. go logic.UpdateEs(edbInfo.EdbInfoId)
  212. br.Ret = 200
  213. br.Success = true
  214. br.Msg = "获取成功"
  215. }
  216. // GetServerUrl 获取服务器地址
  217. func GetServerUrl() (windUrl string, terminalCode string, err error) {
  218. // 先配置中获取,如果有指定配置的话,那么取配置中的数据
  219. tmpConfig, err := models.GetConfigDetailByCode("wind_data_url")
  220. if err != nil && err.Error() != utils.ErrNoRow() {
  221. err = errors.New("获取配置的wind地址失败,err:" + err.Error())
  222. return
  223. }
  224. err = nil
  225. if tmpConfig != nil {
  226. windUrl = tmpConfig.ConfigValue
  227. return
  228. }
  229. // 配置中没有的话,那么就从分组获取, todo 改成从edb_info指标库里根据终端码进行分组的指标数据统计
  230. list, err := models.GetServerUrlCountGroupByServerUrl()
  231. if err != nil {
  232. return
  233. }
  234. //windUrlNum := 0
  235. //获取对应的配置url
  236. terminalNumMap := make(map[string]int)
  237. for _, v := range list {
  238. terminalNumMap[v.ServerUrl] = v.Total
  239. }
  240. /*for _, tmpWind := range utils.Hz_Wind_Data_Url_LIST {
  241. tmpWindUrl := tmpWind.Url
  242. tmpNum := windUrlMap[tmpWindUrl]
  243. if windUrl == `` || (windUrl != `` && tmpNum < windUrlNum) {
  244. windUrl = tmpWindUrl
  245. windUrlNum = tmpNum
  246. }
  247. }*/
  248. terminalList, err := models.GetEdbTerminalListBySource(utils.DATA_SOURCE_WIND)
  249. if err != nil {
  250. return
  251. }
  252. num := 0
  253. edbTerminal := new(models.EdbTerminal)
  254. for _, v := range terminalList {
  255. tmpNum := terminalNumMap[v.TerminalCode]
  256. if edbTerminal == nil {
  257. edbTerminal = v
  258. num = tmpNum
  259. } else if tmpNum < num {
  260. edbTerminal = v
  261. num = tmpNum
  262. }
  263. }
  264. if edbTerminal != nil {
  265. windUrl = edbTerminal.ServerUrl
  266. terminalCode = edbTerminal.TerminalCode
  267. }
  268. return
  269. }