base_from_ths_http.go 10 KB

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