base_from_ths_http.go 10 KB

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