123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215 |
- package data_manage
- import (
- "errors"
- "fmt"
- "hongze/hongze_task/models/data_manage"
- "hongze/hongze_task/utils"
- "rdluck_tools/http"
- "time"
- "context"
- )
- //刷新同花顺数据
- func RefreshDataFromThs() (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromThs Err:" + err.Error())
- go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromThs ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- }
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_THS)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- for _, v := range items {
- startDate := v.EndDate.AddDate(0, 0, -3).Format(utils.FormatDate)
- endDate := time.Now().Format(utils.FormatDate)
- err = SyncEdbDataByThs(int64(v.EdbInfoId), v.EdbCode, startDate, endDate)
- if err != nil {
- return errors.New("SyncEdbDataByThs:" + err.Error())
- }
- item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
- if err != nil {
- return err
- }
- if item != nil {
- err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
- if err != nil {
- return err
- }
- }
- //minDate, maxDate, err := data_manage.GetEdbDataThsMaxOrMinDate(v.EdbInfoId)
- //if err != nil {
- // return errors.New("GetEdbDataThsMaxOrMinDate:" + err.Error())
- //}
- //fmt.Println("minDate:" + minDate + ";maxDate:" + maxDate)
- //err = data_manage.ModifyEdbDataInfoDate(v.EdbInfoId, maxDate)
- //if err != nil {
- // return errors.New("ModifyEdbDataInfoDate:" + err.Error())
- //}
- }
- return err
- }
- //刷新万得数据
- func RefreshDataFromWind() (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromWind Err:" + err.Error())
- go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromWind ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- }
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_WIND)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars)
- if err != nil {
- return err
- }
- for k, v := range items {
- fmt.Println("line 67:", k, v.EdbCode)
- startDate := v.EndDate.AddDate(0, 0, -3).Format(utils.FormatDate)
- endDate := time.Now().Format(utils.FormatDate)
- err = SyncEdbDataByWind(int64(v.EdbInfoId), v.EdbCode, startDate, endDate)
- if err != nil {
- return err
- }
- item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
- if err != nil {
- return err
- }
- if item != nil {
- err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
- if err != nil {
- return err
- }
- }
- }
- return err
- }
- //刷新彭博数据
- func RefreshDataFromPb() (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromPb Err:" + err.Error())
- go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromPb ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- }
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_PB)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- for _, v := range items {
- startDate := v.EndDate.AddDate(0, 0, -3).Format(utils.FormatDateUnSpace)
- endDate := time.Now().Format(utils.FormatDateUnSpace)
- fmt.Println(startDate, endDate)
- err = SyncEdbDataByPb(int64(v.EdbInfoId), v.EdbCode, startDate, endDate)
- if err != nil {
- return errors.New("SyncEdbDataByPb:" + err.Error())
- }
- item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
- if err != nil {
- return err
- }
- if item != nil {
- err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
- if err != nil {
- return err
- }
- }
- //minDate, maxDate, err := data_manage.GetEdbDataPbMaxOrMinDate(v.EdbInfoId)
- //if err != nil {
- // return errors.New("GetEdbDataThsMaxOrMinDate:" + err.Error())
- //}
- //fmt.Println("minDate:" + minDate + ";maxDate:" + maxDate)
- //err = data_manage.ModifyEdbDataInfoDate(v.EdbInfoId, maxDate)
- //if err != nil {
- // return errors.New("ModifyEdbDataInfoDate:" + err.Error())
- //}
- }
- return err
- }
- func CheckDataInterface() (err error) {
- go func() {
- checkUrl := utils.Hz_Data_Url + `hz_server`
- body, err := http.Get(checkUrl)
- if err != nil {
- go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "CheckDataInterface ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- }
- result := string(body)
- if result != "1" {
- go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "CheckDataInterface ErrMsg:"+string(body), utils.EmailSendToUsers)
- }
- }()
- return
- }
- func CheckPbDataInterface(cont context.Context) (err error) {
- go func() {
- checkUrl := utils.Hz_Data_PB_Url + `hz_server`
- body, err := http.Get(checkUrl)
- if err != nil {
- go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "CheckPbDataInterface ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- }
- result := string(body)
- if result != "1" {
- go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "CheckPbDataInterface ErrMsg:"+string(body), utils.EmailSendToUsers)
- }
- }()
- return
- }
- //刷新计算指标数据
- func RefreshDataFromCalculate() (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromCalculate Err:" + err.Error())
- go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromCalculate ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- }
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_CALCULATE)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars)
- if err != nil {
- return err
- }
- for _, v := range items {
- startDate := v.EndDate.AddDate(0, 0, -3).Format(utils.FormatDate)
- endDate := time.Now().Format(utils.FormatDate)
- var edbInfoIdBytes []string
- calculateMap, err := data_manage.GetEdbInfoCalculateDetail(int(v.EdbInfoId))
- if err != nil {
- return err
- }
- var formulaStr string
- edbInfoList := make([]*data_manage.EdbInfo, 0)
- for _, v := range calculateMap {
- formulaStr += v.FromTag + ","
- edbInfoIdBytes = append(edbInfoIdBytes, v.FromTag)
- edbInfo, _ := data_manage.GetEdbInfoById(v.FromEdbInfoId)
- edbInfoList = append(edbInfoList, edbInfo)
- }
- err = RefreshCalculate(edbInfoList, v.EdbInfoId, v.EdbCode, v.CalculateFormula, startDate, endDate, edbInfoIdBytes)
- if err != nil {
- return err
- }
- }
- return err
- }
|