base_from_ths_http.go 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342
  1. package services
  2. import (
  3. "encoding/json"
  4. "errors"
  5. "eta/eta_index_lib/models"
  6. "eta/eta_index_lib/models/future_good"
  7. "eta/eta_index_lib/services/alarm_msg"
  8. "eta/eta_index_lib/utils"
  9. "fmt"
  10. "github.com/shopspring/decimal"
  11. "io"
  12. netHttp "net/http"
  13. "reflect"
  14. "strings"
  15. "time"
  16. )
  17. var tokenRedisKey = `THS_SERVER_ACCESS_TOKEN`
  18. // getEdbDataFromThsHttp 通过url获取同花顺的普通数据
  19. func getEdbDataFromThsHttp(edbCode, startDate, endDate, thsRefreshToken, token string) (item models.EdbDataFromThs, apiErrMsg string, err error) {
  20. thsUrl := `https://quantapi.51ifind.com/api/v1/edb_service`
  21. //indicators 是 半角逗号分隔的所有指标,宏观指标过多,推荐使用Windows超级命令生成。 "indicators":"M001620326,M002822183"
  22. //functionpara 否 key-value格式,省略时不进行更新时间筛选。两个时间控件更新起始时间(startrtime)和更新结束时间(endrtime),不勾选时省略见下方代码块
  23. //startdate 是 开始日期,支持”YYYYMMDD"”YYYY-MM-DD"”YYYY/MM/DD"三种时间格式 "startdate":"2018-01-01"
  24. //enddate 是 结束日期,支持”YYYYMMDD"”YYYY-MM-DD"”YYYY/MM/DD"三种日期格式 "enddate":"2018-01-01
  25. //发送创建请求
  26. dataMap := map[string]interface{}{
  27. "indicators": edbCode,
  28. "startdate": startDate,
  29. "enddate": endDate,
  30. }
  31. body, err, _ := postCurl(thsUrl, dataMap, 0, thsRefreshToken, token)
  32. if err != nil {
  33. // 返回接口报错的实际原因
  34. apiErrMsg = err.Error()
  35. return
  36. }
  37. tmpItems := new(EdbDataFromThsInterface)
  38. err = json.Unmarshal(body, &tmpItems)
  39. if err != nil {
  40. err = errors.New("GetEdbDataFromThs json.Unmarshal Err:" + err.Error())
  41. return
  42. }
  43. if tmpItems.Errorcode != 0 {
  44. err = errors.New(tmpItems.Errmsg)
  45. apiErrMsg = fmt.Sprintf("%d:%s", tmpItems.Errorcode, tmpItems.Errmsg)
  46. return
  47. }
  48. // 因为table里面的value有的时候返回的是string,有的是float64,所以需要用interface来反射取值
  49. tablesList := make([]models.Tables, 0)
  50. for _, table := range tmpItems.Tables {
  51. tableIdList := make([]string, 0)
  52. tableTimeList := make([]string, 0)
  53. tableValueList := make([]float64, 0)
  54. for _, tableId := range table.ID {
  55. tableIdList = append(tableIdList, tableId)
  56. }
  57. for _, tableTime := range table.Time {
  58. tableTimeList = append(tableTimeList, tableTime)
  59. }
  60. //指标数据
  61. for _, tmpValue := range table.Value {
  62. var tableValue float64
  63. if reflect.TypeOf(tmpValue).Kind() == reflect.Float64 {
  64. tableValue = reflect.ValueOf(tmpValue).Float()
  65. } else if reflect.TypeOf(tmpValue).Kind() == reflect.String {
  66. tmpTableValue, tmpErr := decimal.NewFromString(reflect.ValueOf(tmpValue).String())
  67. if tmpErr != nil {
  68. err = tmpErr
  69. return
  70. }
  71. tableValue, _ = tmpTableValue.Truncate(4).Float64()
  72. } else {
  73. err = errors.New("错误的数据类型" + reflect.TypeOf(tmpValue).String())
  74. return
  75. }
  76. tableValueList = append(tableValueList, tableValue)
  77. }
  78. tmpTable := models.Tables{
  79. ID: tableIdList,
  80. Time: tableTimeList,
  81. Value: tableValueList,
  82. }
  83. tablesList = append(tablesList, tmpTable)
  84. }
  85. item = models.EdbDataFromThs{
  86. DataVol: tmpItems.DataVol,
  87. Errmsg: tmpItems.Errmsg,
  88. Errorcode: tmpItems.Errorcode,
  89. Perf: tmpItems.Perf,
  90. Tables: tablesList,
  91. }
  92. return
  93. }
  94. // getFutureGoodDataFromThsHttp 通过url获取同花顺的商品数据
  95. func getFutureGoodDataFromThsHttp(edbCode, startDate, endDate, thsRefreshToken, token string) (item future_good.FutureGoodDataFromThs, err error) {
  96. thsUrl := `https://quantapi.51ifind.com/api/v1/cmd_history_quotation`
  97. //codes 是 半角逗号分隔的所有代码 "codes":"300033.SZ,600030.SH"
  98. //indicators 是 半角逗号分隔的所有指标 "indicators":"preClose,open"
  99. //functionpara 否 /key-value格式。所有key均取默认时,functionpara省略。 见下方说明
  100. //startdate 是 开始日期,支持"YYYYMMDD""YYYY-MMDD""YYYY/MM/DD"三种日期格式
  101. //"startdate":"2018-01-01"
  102. //enddate 是 结束日期,支持"YYYYMMDD""YYYY-MMDD""YYYY/MM/DD"三种日期格式
  103. //发送创建请求
  104. dataMap := map[string]interface{}{
  105. "codes": edbCode,
  106. "indicators": `lastclose,open,high,low,close,avgprice,change,changeper,volume,amount,hsl,lastsettlement,settlement,zdsettlement,zdfsettlement,ccl,ccbd,zf,zjlx,zjcd`,
  107. "startdate": startDate,
  108. "enddate": endDate,
  109. }
  110. body, err, _ := postCurl(thsUrl, dataMap, 0, thsRefreshToken, token)
  111. if err != nil {
  112. return
  113. }
  114. tmpItems := new(FutureGoodDataFromThsInterface)
  115. err = json.Unmarshal(body, &tmpItems)
  116. if err != nil {
  117. err = errors.New("GetEdbDataFromThs json.Unmarshal Err:" + err.Error())
  118. return
  119. }
  120. if tmpItems.Errorcode != 0 {
  121. err = errors.New(tmpItems.Errmsg)
  122. return
  123. }
  124. if len(tmpItems.Tables) <= 0 {
  125. return
  126. }
  127. table := tmpItems.Tables[0]
  128. item = future_good.FutureGoodDataFromThs{
  129. DataVol: tmpItems.DataVol,
  130. Errmsg: tmpItems.Errmsg,
  131. Errorcode: tmpItems.Errorcode,
  132. Perf: tmpItems.Perf,
  133. Tables: future_good.FutureGoodDataTables{
  134. Time: table.Time,
  135. Open: table.Table.Open,
  136. High: table.Table.High,
  137. Low: table.Table.Low,
  138. Close: table.Table.Close,
  139. Volume: table.Table.Volume,
  140. Amount: table.Table.Amount,
  141. Ccl: table.Table.Ccl,
  142. Settlement: table.Table.Settlement,
  143. },
  144. }
  145. return
  146. }
  147. // BaseThsInterface 同花顺基础返回
  148. type BaseThsInterface struct {
  149. ErrMsg string `json:"errmsg"`
  150. ErrorCode int64 `json:"errorcode"`
  151. Tables interface{} `json:"tables"`
  152. }
  153. // postCurl post请求同花顺接口
  154. func postCurl(urlStr string, dataMap map[string]interface{}, num int, thsRefreshToken, token string) (body []byte, err error, errMsg string) {
  155. logMsg := ``
  156. defer func() {
  157. if err != nil {
  158. if logMsg != `` {
  159. errMsg = logMsg
  160. go alarm_msg.SendAlarmMsg("post请求同花顺接口失败,ERR:"+err.Error()+";errMsg:"+errMsg, 3)
  161. }
  162. }
  163. }()
  164. jsonStrByte, err := json.Marshal(dataMap)
  165. if err != nil {
  166. return
  167. }
  168. reqStr := string(jsonStrByte)
  169. req, _ := netHttp.NewRequest("POST", urlStr, strings.NewReader(reqStr))
  170. req.Header.Add("Content-Type", "application/json")
  171. req.Header.Add("access_token", token)
  172. res, err := netHttp.DefaultClient.Do(req)
  173. if err != nil {
  174. return
  175. }
  176. defer res.Body.Close()
  177. //解析resp并且存入关联表
  178. body, err = io.ReadAll(res.Body)
  179. if err != nil {
  180. logMsg = fmt.Sprint("post err; request:", reqStr, "; errMsg:", err.Error())
  181. utils.FileLog.Info(logMsg)
  182. return
  183. }
  184. //logMsg = fmt.Sprint("post request:", reqStr, "; response:", string(body))
  185. //utils.FileLog.Info(logMsg)
  186. logMsg = fmt.Sprint("post request url:", urlStr, ";token:", token, ";params:", reqStr, ";response:", string(body))
  187. var response BaseThsInterface
  188. err = json.Unmarshal(body, &response)
  189. if err != nil {
  190. utils.FileLog.Info("post Err:", err.Error(), ";url:", urlStr, ";params:", reqStr, ";response:", string(body))
  191. err = errors.New("Unmarshal Err:" + err.Error())
  192. return
  193. }
  194. utils.FileLog.Info(fmt.Sprint("post request url:", urlStr, ";token:", token, ";params:", reqStr, ";response:", string(body)))
  195. //如果是token失效,同时只是第一次请求(没有尝试强制刷新token,那么重新请求)
  196. if utils.InArrayByInt([]int{-1010, -1302}, int(response.ErrorCode)) && num <= 0 {
  197. //token失效
  198. token, err = refreshAccessToken(thsRefreshToken)
  199. if err != nil {
  200. return
  201. }
  202. num++
  203. return postCurl(urlStr, dataMap, num, thsRefreshToken, token)
  204. } else if response.ErrorCode != 0 {
  205. utils.FileLog.Info(fmt.Sprint("post data err:", response.ErrMsg, ";url:", urlStr, ";params:", reqStr, ";response:", string(body)))
  206. err = errors.New(response.ErrMsg)
  207. return
  208. }
  209. return
  210. }
  211. // GetAccessToken 获取accessToken
  212. func GetAccessToken(isRefresh bool, thsRefreshToken string) (token string, err error) {
  213. defer func() {
  214. if err != nil {
  215. go alarm_msg.SendAlarmMsg("获取同花顺的token失败,ERR:"+err.Error(), 3)
  216. }
  217. }()
  218. redisKey := utils.CACHE_EDB_THS_SERVER_TOKEN + thsRefreshToken + ":"
  219. token, redisErr := utils.Rc.RedisString(redisKey)
  220. //如果从redis中accessToken 获取失败或者token为空了,再或者需要强制刷新了,那么重新获取accessToken
  221. if redisErr != nil || token == `` || isRefresh {
  222. token, _ = refreshAccessToken(thsRefreshToken)
  223. return
  224. }
  225. return
  226. }
  227. // refreshAccessToken 强制刷新获取accessToken
  228. func refreshAccessToken(thsRefreshToken string) (token string, err error) {
  229. defer func() {
  230. if err != nil {
  231. go alarm_msg.SendAlarmMsg("刷新同花顺的token失败;ERR:"+err.Error(), 3)
  232. }
  233. }()
  234. tokenInfo, tmpErr := getAccessToken(thsRefreshToken)
  235. if tmpErr != nil {
  236. err = tmpErr
  237. return
  238. }
  239. token = tokenInfo.AccessToken
  240. expireTime, err := time.ParseInLocation(utils.FormatDateTime, tokenInfo.ExpiredTime, time.Local)
  241. if err != nil {
  242. err = fmt.Errorf("获取同花顺的token失败;同花顺token截止日期转换失败,ERR:%s", err.Error())
  243. return
  244. }
  245. //token存入redis
  246. //err = utils.Rc.Put(tokenRedisKey, token, time.Duration(expireTime.Unix()-600)*time.Second)
  247. // 本来是要设置下600s的过期时间,但因为不是强制刷新token,就不获取了
  248. redisKey := utils.CACHE_EDB_THS_SERVER_TOKEN + thsRefreshToken + ":"
  249. err = utils.Rc.Put(redisKey, token, time.Duration(expireTime.Unix())*time.Second)
  250. if err != nil {
  251. err = fmt.Errorf("获取同花顺的token成功;同花顺token存入redis失败,ERR:%s", err.Error())
  252. return
  253. }
  254. return
  255. }
  256. type GetTokenResp struct {
  257. ErrorCode int `json:"errorcode"`
  258. ErrMsg string `json:"errmsg"`
  259. Data TokenData `json:"data"`
  260. }
  261. type TokenData struct {
  262. AccessToken string `json:"access_token"`
  263. //ExpireIn int `json:"expire_in"`
  264. ExpiredTime string `json:"expired_time"`
  265. }
  266. // getAccessToken token内部请求接口
  267. func getAccessToken(thsRefreshToken string) (tokenData TokenData, err error) {
  268. /*if utils.ThsRefreshToken == `` {
  269. err = errors.New("同花顺token未配置")
  270. return
  271. }*/
  272. defer func() {
  273. if err != nil {
  274. go alarm_msg.SendAlarmMsg("更新同花顺的token失败;ERR:"+err.Error(), 3)
  275. }
  276. }()
  277. if thsRefreshToken == "" {
  278. err = errors.New("同花顺token未配置")
  279. return
  280. }
  281. //getUrl := `https://quantapi.51ifind.com/api/v1/update_access_token` // 强制刷新token;目前因为生产和测试都是使用的一个账号,所以token不能因为环境的不同而改变
  282. getUrl := `https://quantapi.51ifind.com/api/v1/get_access_token` // 获取当前token
  283. req, _ := netHttp.NewRequest("GET", getUrl, nil)
  284. req.Header.Add("Content-Type", "application/json")
  285. req.Header.Add("refresh_token", thsRefreshToken)
  286. res, err := netHttp.DefaultClient.Do(req)
  287. if err != nil {
  288. return
  289. }
  290. defer res.Body.Close()
  291. body, err := io.ReadAll(res.Body)
  292. if err != nil {
  293. err = errors.New("NewRequest Err:" + err.Error())
  294. return
  295. }
  296. utils.FileLog.Info("同花顺刷新token:" + string(body))
  297. var tokenResp GetTokenResp
  298. err = json.Unmarshal(body, &tokenResp)
  299. if err != nil {
  300. err = errors.New("Unmarshal Err:" + err.Error())
  301. return
  302. }
  303. if tokenResp.ErrorCode != 0 {
  304. err = errors.New("getAccessToken err:" + tokenResp.ErrMsg)
  305. return
  306. }
  307. tokenData = tokenResp.Data
  308. return
  309. }