123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683 |
- package data
- import (
- "context"
- "errors"
- "fmt"
- "github.com/rdlucklib/rdluck_tools/http"
- "hongze/hongze_task/models/data_manage"
- "hongze/hongze_task/services/alarm_msg"
- "hongze/hongze_task/utils"
- "sync"
- )
- //刷新同花顺数据
- func RefreshDataFromThs(wg *sync.WaitGroup) (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)
- go alarm_msg.SendAlarmMsg("RefreshDataFromThs ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_THS)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- err = errors.New("GetEdbInfoByCondition:" + err.Error())
- return
- }
- //var endDate string
- //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDate)
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- //err = SyncEdbDataByThs(int64(v.EdbInfoId), v.EdbCode, startDate, endDate)
- //if err != nil {
- // err = errors.New("SyncEdbDataByThs Err:" + err.Error())
- // return err
- //}
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
- //if err != nil {
- // err = errors.New("GetEdbInfoMaxAndMinInfo Err:" + err.Error())
- // return err
- //}
- //if item != nil {
- // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
- // if err != nil {
- // err = errors.New("ModifyEdbInfoMaxAndMinInfo Err:" + err.Error())
- // return err
- // }
- //}
- }
- return err
- }
- //刷新万得数据
- func RefreshDataFromWind(wg *sync.WaitGroup) (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)
- go alarm_msg.SendAlarmMsg("RefreshDataFromWind ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += ` AND source=? AND no_update = 0 `
- pars = append(pars, utils.DATA_SOURCE_WIND)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return err
- }
- //var endDate string
- //endDate = time.Now().Format(utils.FormatDate)
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- //err = SyncEdbDataByWind(int64(v.EdbInfoId), v.EdbCode, startDate, endDate)
- //if err != nil {
- // return err
- //}
- //edbInfoId, source int, edbCode, startDate string) (resp *models.BaseResponse, err error) {
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //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(wg *sync.WaitGroup) (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)
- go alarm_msg.SendAlarmMsg("RefreshDataFromPb ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_PB)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- //var endDate string
- //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- //err = SyncEdbDataByPb(int64(v.EdbInfoId), v.EdbCode, startDate, endDate)
- //if err != nil {
- // return errors.New("SyncEdbDataByPb:" + err.Error())
- //}
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //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.GetEdbDataPbMaxOrMinDate(v.EdbInfoId)
- //if err != nil {
- // return errors.New("GetEdbDataThsMaxOrMinDate:" + err.Error())
- //}
- //fmt.Println("minDate:" + minDate + ";maxDate:" + maxDate)
- //err = data.ModifyEdbDataInfoDate(v.EdbInfoId, maxDate)
- //if err != nil {
- // return errors.New("ModifyEdbDataInfoDate:" + err.Error())
- //}
- }
- return err
- }
- // RefreshDataFromPbFinance 刷新彭博财务指标数据
- func RefreshDataFromPbFinance(wg *sync.WaitGroup) (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)
- go alarm_msg.SendAlarmMsg("RefreshDataFromPb ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_PB_FINANCE)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- //var endDate string
- //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- //err = SyncEdbDataByPb(int64(v.EdbInfoId), v.EdbCode, startDate, endDate)
- //if err != nil {
- // return errors.New("SyncEdbDataByPb:" + err.Error())
- //}
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //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.GetEdbDataPbMaxOrMinDate(v.EdbInfoId)
- //if err != nil {
- // return errors.New("GetEdbDataThsMaxOrMinDate:" + err.Error())
- //}
- //fmt.Println("minDate:" + minDate + ";maxDate:" + maxDate)
- //err = data.ModifyEdbDataInfoDate(v.EdbInfoId, maxDate)
- //if err != nil {
- // return errors.New("ModifyEdbDataInfoDate:" + err.Error())
- //}
- }
- return err
- }
- 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)
- msg := "检测彭博数据服务器失败:CheckPbDataInterface ErrMsg:" + err.Error()
- go alarm_msg.SendAlarmMsg(msg, 3)
- } else {
- result := string(body)
- if result != "1" {
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "CheckPbDataInterface ErrMsg:"+string(body), utils.EmailSendToUsers)
- msg := "检测彭博数据服务器失败:CheckPbDataInterface ErrMsg:" + string(body)
- go alarm_msg.SendAlarmMsg(msg, 3)
- }
- }
- }()
- return
- }
- // CheckLtDataInterface 检测路透数据服务器
- func CheckLtDataInterface(cont context.Context) (err error) {
- go func() {
- checkUrl := utils.Hz_Data_LT_Url + `hz_server`
- body, err := http.Get(checkUrl)
- if err != nil {
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "检测路透数据服务器失败:CheckLtDataInterface ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- msg := "检测路透数据服务器失败:CheckLtDataInterface ErrMsg:" + err.Error()
- go alarm_msg.SendAlarmMsg(msg, 3)
- } else {
- result := string(body)
- if result != `"ek true"` {
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "检测路透数据服务器失败:CheckLtDataInterface ErrMsg:"+string(body), utils.EmailSendToUsers)
- msg := "检测路透数据服务器失败:CheckLtDataInterface ErrMsg:" + string(body)
- go alarm_msg.SendAlarmMsg(msg, 3)
- }
- }
- }()
- return
- }
- // CheckThsDataInterface 检测同花顺数据服务器
- func CheckThsDataInterface(cont context.Context) (err error) {
- go func() {
- checkUrl := utils.Hz_Server_Data_Url + `hz_server`
- body, err := http.Get(checkUrl)
- if err != nil {
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "CheckPbDataInterface ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- msg := "检测同花顺数据服务器失败:CheckThsDataInterface ErrMsg:" + err.Error()
- go alarm_msg.SendAlarmMsg(msg, 3)
- } else {
- result := string(body)
- if result != "1" {
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "CheckPbDataInterface ErrMsg:"+string(body), utils.EmailSendToUsers)
- msg := "检测同花顺数据服务器失败:CheckThsDataInterface ErrMsg:" + string(body)
- go alarm_msg.SendAlarmMsg(msg, 3)
- }
- }
- }()
- return
- }
- ////刷新所有计算指标
- //func RefreshDataFromCalculateAll() (err error) {
- // defer func() {
- // if err != nil {
- // utils.FileLog.Info("RefreshDataFromCalculateAll Err:" + err.Error())
- // go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromCalculateAll ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- // }
- // }()
- // var condition string
- // var pars []interface{}
- // condition += " AND edb_type=? "
- // pars = append(pars, 2)
- //
- // //condition += " AND is_update=1 "
- //
- // items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- // if err != nil {
- // return err
- // }
- // for _, v := range items {
- // edbInfoId := v.EdbInfoId
- // edbCode := v.EdbCode
- // source := v.Source
- // fmt.Println(v.EdbInfoId, v.EdbCode, v.EdbName, v.SourceName, source)
- // if source == utils.DATA_SOURCE_CALCULATE {
- // startDate := ""
- // if v.Frequency == "日度" {
- // startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- // } else if v.Frequency == "周度" {
- // startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- // } else if v.Frequency == "月度" {
- // startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- // } else if v.Frequency == "季度" {
- // startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- // } else if v.Frequency == "年度" {
- // startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- // } else {
- // startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- // }
- // endDate := time.Now().Format(utils.FormatDate)
- // var edbInfoIdBytes []string
- // calculateMap, err := data_manage.GetEdbInfoCalculateDetail(int(v.EdbInfoId))
- // if err != nil {
- // return errors.New("GetEdbInfoCalculateDetail Err:" + err.Error())
- // }
- // 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)
- // }
- // //endDate = ""
- // err = RefreshCalculate(edbInfoList, edbInfoId, edbCode, v.CalculateFormula, startDate, endDate, edbInfoIdBytes)
- // if err != nil {
- // return errors.New("RefreshCalculate Err:" + err.Error())
- // }
- // } else if source == utils.DATA_SOURCE_CALCULATE_LJZZY {
- // calculateLjzzy, err := data_manage.GetEdbInfoCalculateLjzzyDetail(edbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoCalculateLjzzyDetail Err:" + err.Error())
- // }
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateLjzzy.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoById Err:" + err.Error())
- // }
- // year := time.Now().Year() - 1
- // startDate := strconv.Itoa(year) + "-01" + "-01"
- // endDate := "" //time.Now().Format(utils.FormatDate)
- // err = data_manage.RefreshCalculateLjzzy(edbInfoId, fromEdbInfo, edbCode, startDate, endDate)
- // if err != nil {
- // return errors.New("RefreshCalculateLjzzy Err:" + err.Error())
- // }
- // } else if source == utils.DATA_SOURCE_CALCULATE_TBZ {
- // calculateTbz, err := data_manage.GetEdbInfoCalculateTbzDetail(edbInfoId)
- // if err != nil {
- // return errors.New("GetEdbInfoCalculateTbzDetail Err:" + err.Error())
- // }
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateTbz.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoById Err:" + err.Error())
- // }
- // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
- // endDate := "" //time.Now().Format(utils.FormatDate)
- // err = data_manage.RefreshCalculateTbz(edbInfoId, fromEdbInfo, calculateTbz.EdbCode, startDate, endDate)
- // if err != nil {
- // return errors.New("RefreshCalculateTbz Err:" + err.Error())
- // }
- // } else if source == utils.DATA_SOURCE_CALCULATE_TCZ {
- // calculateTcz, err := data_manage.GetEdbInfoCalculateTczDetail(edbInfoId)
- // if err != nil {
- // return errors.New("GetEdbInfoCalculateTczDetail Err:" + err.Error())
- // }
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateTcz.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoById Err:" + err.Error())
- // }
- // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
- // endDate := "" //time.Now().Format(utils.FormatDate)
- // err = data_manage.RefreshCalculateTcz(edbInfoId, fromEdbInfo, calculateTcz.EdbCode, startDate, endDate)
- // if err != nil {
- // return errors.New("RefreshCalculateTcz Err:" + err.Error())
- // }
- // } else if source == utils.DATA_SOURCE_CALCULATE_NSZYDPJJS {
- // calculateNszydpjjs, err := data_manage.GetEdbInfoCalculateNszydpjjsDetail(edbInfoId)
- // if err != nil {
- // return errors.New("GetEdbInfoCalculateNszydpjjsDetail Err:" + err.Error())
- // }
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateNszydpjjs.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoById Err:" + err.Error())
- // }
- // formulaInt, _ := strconv.Atoi(v.CalculateFormula)
- // err = data_manage.RefreshCalculateNszydpjjs(edbInfoId, v.Source, formulaInt, fromEdbInfo, calculateNszydpjjs.EdbCode)
- // if err != nil {
- // return errors.New("RefreshCalculateNszydpjjs Err:" + err.Error())
- // }
- // } else if source == utils.DATA_SOURCE_CALCULATE_HBZ {
- // calculateHbz, err := data_manage.GetEdbInfoCalculateHbzDetail(edbInfoId)
- // if err != nil {
- // return errors.New("GetEdbInfoCalculateHbzDetail Err:" + err.Error())
- // }
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateHbz.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoById Err:" + err.Error())
- // }
- // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
- // endDate := "" //time.Now().Format(utils.FormatDate)
- // formulaInt, _ := strconv.Atoi(v.CalculateFormula)
- // err = data_manage.RefreshCalculateHbz(edbInfoId, source, fromEdbInfo, calculateHbz.EdbCode, startDate, endDate, formulaInt)
- // if err != nil {
- // return errors.New("RefreshCalculateTbz Err:" + err.Error())
- // }
- // } else if source == utils.DATA_SOURCE_CALCULATE_HCZ {
- // calculateHcz, err := data_manage.GetEdbInfoCalculateHczDetail(edbInfoId)
- // if err != nil {
- // return errors.New("GetEdbInfoCalculateHczDetail Err:" + err.Error())
- // }
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateHcz.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoById Err:" + err.Error())
- // }
- // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
- // endDate := "" //time.Now().Format(utils.FormatDate)
- // err = data_manage.RefreshCalculateHcz(edbInfoId, source, fromEdbInfo, calculateHcz.EdbCode, startDate, endDate)
- // if err != nil {
- // return errors.New("RefreshCalculateTbz Err:" + err.Error())
- // }
- // } else if source == utils.DATA_SOURCE_CALCULATE_BP {
- // calculateBp, err := data_manage.GetEdbInfoCalculateBpDetail(edbInfoId)
- // if err != nil && err.Error() != utils.ErrNoRow() {
- // return errors.New("GetEdbInfoCalculateBpDetail Err:" + err.Error())
- // }
- // if calculateBp != nil {
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateBp.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoById Err:" + err.Error())
- // }
- // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
- // endDate := "" //time.Now().Format(utils.FormatDate)
- // err = data_manage.RefreshCalculateBp(edbInfoId, fromEdbInfo, calculateBp.EdbCode, startDate, endDate)
- // if err != nil {
- // return errors.New("RefreshCalculateTbz Err:" + err.Error())
- // }
- // }
- // } else if source == utils.DATA_SOURCE_CALCULATE_TIME_SHIFT {
- // calculate, err := data_manage.GetEdbInfoCalculateMappingDetail(edbInfoId)
- // if err != nil {
- // return fmt.Errorf("GetEdbInfoCalculateTbzDetail Err:" + err.Error())
- // }
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculate.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return fmt.Errorf("GetEdbInfoById Err:" + err.Error())
- // }
- // //startDate := v.StartDate.Format(utils.FormatDate)
- // //endDate := time.Now().Format(utils.FormatDate)
- // formulaInt, _ := strconv.Atoi(calculate.CalculateFormula)
- // err = data_manage.RefreshAllCalculateTimeShift(edbInfoId, source, formulaInt, calculate.MoveType, fromEdbInfo, calculate.EdbCode, calculate.MoveFrequency)
- // if err != nil {
- // return fmt.Errorf("RefreshAllCalculateTimeShift Err:" + err.Error())
- // }
- //
- // } else if source == utils.DATA_SOURCE_CALCULATE_ZJPJ { //刷新直接拼接
- // tmpEdbInfo, err := data_manage.GetEdbInfoById(v.EdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return fmt.Errorf("GetEdbInfoById Err:" + err.Error())
- // }
- // err = data_manage.RefreshAllCalculateZjpj(tmpEdbInfo)
- // if err != nil {
- // return fmt.Errorf("RefreshAllCalculateZjpj Err:" + err.Error())
- // }
- // } else if source == utils.DATA_SOURCE_CALCULATE_LJZTBPJ { //刷新累计值同比拼接
- // tmpEdbInfo, err := data_manage.GetEdbInfoById(v.EdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return fmt.Errorf("GetEdbInfoById Err:" + err.Error())
- // }
- // err = data_manage.RefreshAllCalculateLjztbpj(tmpEdbInfo)
- // if err != nil {
- // return fmt.Errorf("RefreshAllCalculateLjztbpj Err:" + err.Error())
- // }
- // } else {
- // msg := "刷新失败,无效的指标渠道:source:" + strconv.Itoa(source) + " EdbCode:" + v.EdbCode
- // err = errors.New(msg)
- // return err
- // }
- //
- // maxAndMinItem, err := data_manage.GetEdbInfoMaxAndMinInfo(source, edbCode)
- // if err != nil {
- // fmt.Println("GetEdbInfoMaxAndMinInfo Err:" + err.Error() + ";source:" + strconv.Itoa(source) + ";edbCode:" + edbCode)
- // err = errors.New("GetEdbInfoMaxAndMinInfo Err:" + err.Error() + ";source:" + strconv.Itoa(source) + ";edbCode:" + edbCode)
- // return err
- // }
- // if maxAndMinItem != nil {
- // err = data_manage.ModifyEdbInfoMaxAndMinInfo(edbInfoId, maxAndMinItem)
- // if err != nil {
- // return err
- // }
- // }
- // }
- // return err
- //}
- //刷新所有计算指标
- func RefreshDataFromCalculateAll() (err error) {
- defer func() {
- if err != nil {
- utils.FileLog.Info("RefreshDataFromCalculateAll Err:" + err.Error())
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromCalculateAll ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- go alarm_msg.SendAlarmMsg("RefreshDataFromCalculateAll ErrMsg:"+err.Error(), 3)
- }
- }()
- var condition string
- var pars []interface{}
- // 查询 普通指标的计算指标
- condition += " AND edb_type=? AND edb_info_type=? "
- pars = append(pars, 2, 0)
- //condition += " AND modify_time<? "
- //pars = append(pars, "2022-03-02 17:03:52")
- //condition += " AND is_update=1 "
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return err
- }
- for _, v := range items {
- //edbInfoId := v.EdbInfoId
- //edbCode := v.EdbCode
- source := v.Source
- startDate := v.StartDate.Format(utils.FormatDate)
- if startDate == "0001-01-01" {
- continue
- }
- fmt.Println(v.EdbInfoId, v.EdbCode, v.EdbName, v.SourceName, source)
- //if source == utils.DATA_SOURCE_CALCULATE {
- // startDate := ""
- // if v.Frequency == "日度" {
- // startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- // } else if v.Frequency == "周度" {
- // startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- // } else if v.Frequency == "月度" {
- // startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- // } else if v.Frequency == "季度" {
- // startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- // } else if v.Frequency == "年度" {
- // startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- // } else {
- // startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- // }
- // endDate := time.Now().Format(utils.FormatDate)
- // var edbInfoIdBytes []string
- // calculateMap, err := data_manage.GetEdbInfoCalculateDetail(int(v.EdbInfoId))
- // if err != nil {
- // return errors.New("GetEdbInfoCalculateDetail Err:" + err.Error())
- // }
- // 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)
- // }
- // //endDate = ""
- // err = RefreshCalculate(edbInfoList, edbInfoId, edbCode, v.CalculateFormula, startDate, endDate, edbInfoIdBytes)
- // if err != nil {
- // return errors.New("RefreshCalculate Err:" + err.Error())
- // }
- //} else if source == utils.DATA_SOURCE_CALCULATE_LJZZY {
- // calculateLjzzy, err := data_manage.GetEdbInfoCalculateLjzzyDetail(edbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoCalculateLjzzyDetail Err:" + err.Error())
- // }
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateLjzzy.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoById Err:" + err.Error())
- // }
- // year := time.Now().Year() - 1
- // startDate := strconv.Itoa(year) + "-01" + "-01"
- // endDate := "" //time.Now().Format(utils.FormatDate)
- // err = data_manage.RefreshCalculateLjzzy(edbInfoId, fromEdbInfo, edbCode, startDate, endDate)
- // if err != nil {
- // return errors.New("RefreshCalculateLjzzy Err:" + err.Error())
- // }
- //} else if source == utils.DATA_SOURCE_CALCULATE_TBZ {
- // calculateTbz, err := data_manage.GetEdbInfoCalculateTbzDetail(edbInfoId)
- // if err != nil {
- // return errors.New("GetEdbInfoCalculateTbzDetail Err:" + err.Error())
- // }
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateTbz.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoById Err:" + err.Error())
- // }
- // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
- // endDate := "" //time.Now().Format(utils.FormatDate)
- // err = data_manage.RefreshCalculateTbz(edbInfoId, fromEdbInfo, calculateTbz.EdbCode, startDate, endDate)
- // if err != nil {
- // return errors.New("RefreshCalculateTbz Err:" + err.Error())
- // }
- //} else if source == utils.DATA_SOURCE_CALCULATE_TCZ {
- // calculateTcz, err := data_manage.GetEdbInfoCalculateTczDetail(edbInfoId)
- // if err != nil {
- // return errors.New("GetEdbInfoCalculateTczDetail Err:" + err.Error())
- // }
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateTcz.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoById Err:" + err.Error())
- // }
- // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
- // endDate := "" //time.Now().Format(utils.FormatDate)
- // err = data_manage.RefreshCalculateTcz(edbInfoId, fromEdbInfo, calculateTcz.EdbCode, startDate, endDate)
- // if err != nil {
- // return errors.New("RefreshCalculateTcz Err:" + err.Error())
- // }
- //} else if source == utils.DATA_SOURCE_CALCULATE_NSZYDPJJS {
- // calculateNszydpjjs, err := data_manage.GetEdbInfoCalculateNszydpjjsDetail(edbInfoId)
- // if err != nil {
- // return errors.New("GetEdbInfoCalculateNszydpjjsDetail Err:" + err.Error())
- // }
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateNszydpjjs.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoById Err:" + err.Error())
- // }
- // formulaInt, _ := strconv.Atoi(v.CalculateFormula)
- // err = data_manage.RefreshCalculateNszydpjjs(edbInfoId, v.Source, formulaInt, fromEdbInfo, calculateNszydpjjs.EdbCode)
- // if err != nil {
- // return errors.New("RefreshCalculateNszydpjjs Err:" + err.Error())
- // }
- //} else if source == utils.DATA_SOURCE_CALCULATE_HBZ {
- // calculateHbz, err := data_manage.GetEdbInfoCalculateHbzDetail(edbInfoId)
- // if err != nil {
- // return errors.New("GetEdbInfoCalculateHbzDetail Err:" + err.Error())
- // }
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateHbz.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoById Err:" + err.Error())
- // }
- // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
- // endDate := "" //time.Now().Format(utils.FormatDate)
- // formulaInt, _ := strconv.Atoi(v.CalculateFormula)
- // err = data_manage.RefreshCalculateHbz(edbInfoId, source, fromEdbInfo, calculateHbz.EdbCode, startDate, endDate, formulaInt)
- // if err != nil {
- // return errors.New("RefreshCalculateTbz Err:" + err.Error())
- // }
- //} else if source == utils.DATA_SOURCE_CALCULATE_HCZ {
- // calculateHcz, err := data_manage.GetEdbInfoCalculateHczDetail(edbInfoId)
- // if err != nil {
- // return errors.New("GetEdbInfoCalculateHczDetail Err:" + err.Error())
- // }
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateHcz.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoById Err:" + err.Error())
- // }
- // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
- // endDate := "" //time.Now().Format(utils.FormatDate)
- // err = data_manage.RefreshCalculateHcz(edbInfoId, source, fromEdbInfo, calculateHcz.EdbCode, startDate, endDate)
- // if err != nil {
- // return errors.New("RefreshCalculateTbz Err:" + err.Error())
- // }
- //} else if source == utils.DATA_SOURCE_CALCULATE_BP {
- // calculateBp, err := data_manage.GetEdbInfoCalculateBpDetail(edbInfoId)
- // if err != nil && err.Error() != utils.ErrNoRow() {
- // return errors.New("GetEdbInfoCalculateBpDetail Err:" + err.Error())
- // }
- // if calculateBp != nil {
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateBp.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return errors.New("GetEdbInfoById Err:" + err.Error())
- // }
- // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
- // endDate := "" //time.Now().Format(utils.FormatDate)
- // err = data_manage.RefreshCalculateBp(edbInfoId, fromEdbInfo, calculateBp.EdbCode, startDate, endDate)
- // if err != nil {
- // return errors.New("RefreshCalculateTbz Err:" + err.Error())
- // }
- // }
- //} else if source == utils.DATA_SOURCE_CALCULATE_TIME_SHIFT {
- // calculate, err := data_manage.GetEdbInfoCalculateMappingDetail(edbInfoId)
- // if err != nil {
- // return fmt.Errorf("GetEdbInfoCalculateTbzDetail Err:" + err.Error())
- // }
- // fromEdbInfo, err := data_manage.GetEdbInfoById(calculate.FromEdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return fmt.Errorf("GetEdbInfoById Err:" + err.Error())
- // }
- // //startDate := v.StartDate.Format(utils.FormatDate)
- // //endDate := time.Now().Format(utils.FormatDate)
- // formulaInt, _ := strconv.Atoi(calculate.CalculateFormula)
- // err = data_manage.RefreshAllCalculateTimeShift(edbInfoId, source, formulaInt, calculate.MoveType, fromEdbInfo, calculate.EdbCode, calculate.MoveFrequency)
- // if err != nil {
- // return fmt.Errorf("RefreshAllCalculateTimeShift Err:" + err.Error())
- // }
- //
- //} else if source == utils.DATA_SOURCE_CALCULATE_ZJPJ { //刷新直接拼接
- // tmpEdbInfo, err := data_manage.GetEdbInfoById(v.EdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return fmt.Errorf("GetEdbInfoById Err:" + err.Error())
- // }
- // err = data_manage.RefreshAllCalculateZjpj(tmpEdbInfo)
- // if err != nil {
- // return fmt.Errorf("RefreshAllCalculateZjpj Err:" + err.Error())
- // }
- //} else if source == utils.DATA_SOURCE_CALCULATE_LJZTBPJ { //刷新累计值同比拼接
- // tmpEdbInfo, err := data_manage.GetEdbInfoById(v.EdbInfoId)
- // if err != nil {
- // if err.Error() == utils.ErrNoRow() {
- // continue
- // }
- // return fmt.Errorf("GetEdbInfoById Err:" + err.Error())
- // }
- // err = data_manage.RefreshAllCalculateLjztbpj(tmpEdbInfo)
- // if err != nil {
- // return fmt.Errorf("RefreshAllCalculateLjztbpj Err:" + err.Error())
- // }
- //} else {
- // msg := "刷新失败,无效的指标渠道:source:" + strconv.Itoa(source) + " EdbCode:" + v.EdbCode
- // err = errors.New(msg)
- // return err
- //}
- fmt.Println("RefreshEdbCalculateData", v.EdbInfoId, v.EdbCode, startDate)
- result, err := RefreshEdbCalculateData(v.EdbInfoId, v.EdbCode, startDate)
- if err != nil {
- err = errors.New("RefreshEdbCalculateData Err:" + err.Error())
- return err
- }
- if result.Ret != 200 {
- err = errors.New("RefreshEdbCalculateData err;msg:" + result.Msg + ";errMsg:" + result.ErrMsg)
- return err
- }
- //maxAndMinItem, err := data_manage.GetEdbInfoMaxAndMinInfo(source, edbCode)
- //if err != nil {
- // fmt.Println("GetEdbInfoMaxAndMinInfo Err:" + err.Error() + ";source:" + strconv.Itoa(source) + ";edbCode:" + edbCode)
- // err = errors.New("GetEdbInfoMaxAndMinInfo Err:" + err.Error() + ";source:" + strconv.Itoa(source) + ";edbCode:" + edbCode)
- // return err
- //}
- //if maxAndMinItem != nil {
- // err = data_manage.ModifyEdbInfoMaxAndMinInfo(edbInfoId, maxAndMinItem)
- // if err != nil {
- // return err
- // }
- //}
- }
- return err
- }
- //刷新手工指标数据
- func RefreshDataFromManual(wg *sync.WaitGroup) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromManual Err:" + err.Error())
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromManual ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- go alarm_msg.SendAlarmMsg("RefreshDataFromManual ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_MANUAL)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- for _, v := range items {
- //err = data_manage.RefreshManual(v)
- //if err != nil {
- // return errors.New("RefreshManual:edbCode:" + v.EdbCode + ":" + err.Error())
- //}
- startDate := v.StartDate.Format(utils.FormatDate)
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
- //if err != nil {
- // if err.Error() != utils.ErrNoRow() {
- // return err
- // } else {
- // err = nil
- // }
- //} else {
- // if item != nil {
- // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
- // if err != nil {
- // return err
- // }
- // }
- //}
- }
- return err
- }
- //刷新隆众数据
- func RefreshDataFromLz(wg *sync.WaitGroup) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromLz Err:" + err.Error())
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromLz ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- go alarm_msg.SendAlarmMsg("RefreshDataFromLz ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_LZ)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- //var endDate string
- //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- //fmt.Println(startDate, endDate)
- //err = data_manage.RefreshEdbDataByLz(v.EdbInfoId, v.EdbCode, startDate, endDate)
- //if err != nil {
- // return errors.New("RefreshEdbDataByLz:" + err.Error())
- //}
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //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 RefreshDataFromYs(wg *sync.WaitGroup) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromYs Err:" + err.Error())
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromYs ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- go alarm_msg.SendAlarmMsg("RefreshDataFromYs ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_YS)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- //var endDate string
- //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- //fmt.Println(startDate, endDate)
- //err = data_manage.RefreshEdbDataByYs(v.EdbInfoId, v.EdbCode, startDate, endDate)
- //if err != nil {
- // return errors.New("RefreshEdbDataByYs:" + err.Error())
- //}
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //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 RefreshDataFromGl(wg *sync.WaitGroup) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromGl Err:" + err.Error())
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromGl ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- go alarm_msg.SendAlarmMsg("RefreshDataFromGl ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_GL)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- //var endDate string
- //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- //fmt.Println(startDate, endDate)
- //err = data_manage.RefreshEdbDataByGl(v.EdbInfoId, v.EdbCode, startDate, endDate)
- //if err != nil {
- // return errors.New("RefreshEdbDataByGl:" + err.Error())
- //}
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //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
- }
- // RefreshDataFromSh 刷新上期所数据
- func RefreshDataFromSh(wg *sync.WaitGroup) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromSh Err:" + err.Error())
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromSh ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- go alarm_msg.SendAlarmMsg("RefreshDataFromSh ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_SH)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- //var endDate string
- //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- //fmt.Println(startDate, endDate)
- //err = data_manage.RefreshEdbDataBySh(v.EdbInfoId, v.EdbCode, startDate, endDate)
- //if err != nil {
- // return errors.New("RefreshEdbDataBySh:" + err.Error())
- //}
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //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
- }
- // RefreshDataFromDl 刷新大商所数据
- func RefreshDataFromDl(wg *sync.WaitGroup) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromDl Err:" + err.Error())
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromDl ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- go alarm_msg.SendAlarmMsg("RefreshDataFromDl ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_DL)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- //var endDate string
- //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- //fmt.Println(startDate, endDate)
- //err = data_manage.RefreshEdbDataByDl(v.EdbInfoId, v.EdbCode, startDate, endDate)
- //if err != nil {
- // return errors.New("RefreshEdbDataByDl:" + err.Error())
- //}
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //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
- }
- // RefreshDataFromShfe 刷新上期能源数据
- func RefreshDataFromShfe(wg *sync.WaitGroup) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromShfe Err:" + err.Error())
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromShfe ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- go alarm_msg.SendAlarmMsg("RefreshDataFromShfe ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_SHFE)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- //var endDate string
- //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- //fmt.Println(startDate, endDate)
- //err = data_manage.RefreshEdbDataByShfe(v.EdbInfoId, v.EdbCode, startDate, endDate)
- //if err != nil {
- // return errors.New("RefreshEdbDataByShfe:" + err.Error())
- //}
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //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
- }
- // RefreshDataFromCffex 刷新中金所数据
- func RefreshDataFromCffex(wg *sync.WaitGroup) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromCffex Err:" + err.Error())
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromCffex ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- go alarm_msg.SendAlarmMsg("RefreshDataFromCffex ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_CFFEX)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- //var endDate string
- //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- //fmt.Println(startDate, endDate)
- //err = data_manage.RefreshEdbDataByCffex(v.EdbInfoId, v.EdbCode, startDate, endDate)
- //if err != nil {
- // return errors.New("RefreshEdbDataByCffex:" + err.Error())
- //}
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //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
- }
- // RefreshDataFromZz 刷新郑商所数据
- func RefreshDataFromZz(wg *sync.WaitGroup) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromZz Err:" + err.Error())
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromZz ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- go alarm_msg.SendAlarmMsg("RefreshDataFromZz ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_ZZ)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- //var endDate string
- //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- //fmt.Println(startDate, endDate)
- //err = data_manage.RefreshEdbDataByZz(v.EdbInfoId, v.EdbCode, startDate, endDate)
- //if err != nil {
- // return errors.New("RefreshEdbDataByZz:" + err.Error())
- //}
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //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
- }
- // RefreshDataFromLt 刷新路透数据
- func RefreshDataFromLt(wg *sync.WaitGroup) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromLt Err:" + err.Error())
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromLt ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- go alarm_msg.SendAlarmMsg("RefreshDataFromLt ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_LT)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- //endDate := time.Now().Format(utils.FormatDate)
- for _, v := range items {
- startDate := v.StartDate.Format(utils.FormatDate)
- //err = data_manage.RefreshAllEdbDataByLt(v.EdbInfoId, utils.DATA_SOURCE_LT, v.EdbCode, startDate, endDate)
- //if err != nil {
- // return errors.New("RefreshEdbDataByLt:" + err.Error())
- //}
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //更新指标的最新数据
- //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 ResetEdbInfoIsUpdate(cont context.Context) (err error) {
- go data_manage.ResetEdbInfoIsUpdate()
- return nil
- }
- // CheckWindDataInterface 检测wind数据服务器
- func CheckWindDataInterface(cont context.Context) (err error) {
- for _, hzDataWindUrl := range utils.Hz_Data_WIND_Url_List {
- go func(urlStr string) {
- checkUrl := urlStr + `hz_server`
- body, err := http.Get(checkUrl)
- if err != nil {
- msg := fmt.Sprintf("检测:%s ;失败:CheckWindDataInterface ErrMsg:%s", checkUrl, err.Error())
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "检测路透数据服务器失败:CheckLtDataInterface ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- go alarm_msg.SendAlarmMsg(msg, 3)
- } else {
- result := string(body)
- if result != `1` {
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "检测路透数据服务器失败:CheckLtDataInterface ErrMsg:"+string(body), utils.EmailSendToUsers)
- //msg := "检测Wind数据服务器2失败:CheckWindDataInterface ErrMsg:" + string(body)
- msg := fmt.Sprintf("检测%s ;失败:CheckWindDataInterface ErrMsg:%s", checkUrl, string(body))
- go alarm_msg.SendAlarmMsg(msg, 3)
- }
- }
- }(hzDataWindUrl)
- }
- return
- }
- // RefreshDataFromCoal 刷新煤炭网数据
- func RefreshDataFromCoal(wg *sync.WaitGroup) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromCoal Err:" + err.Error())
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromCoal ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- go alarm_msg.SendAlarmMsg("RefreshDataFromCoal ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_COAL)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- //var endDate string
- //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- //fmt.Println(startDate, endDate)
- //err = data_manage.RefreshEdbDataByZz(v.EdbInfoId, v.EdbCode, startDate, endDate)
- //if err != nil {
- // return errors.New("RefreshEdbDataByZz:" + err.Error())
- //}
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //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
- }
- // RefreshDataFromEic 刷欧洲天然气数据
- func RefreshDataFromEic(wg *sync.WaitGroup) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromEic Err:" + err.Error())
- //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromCoal ErrMsg:"+err.Error(), utils.EmailSendToUsers)
- go alarm_msg.SendAlarmMsg("RefreshDataFromEic ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_GIE)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- //var endDate string
- //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- //fmt.Println(startDate, endDate)
- //err = data_manage.RefreshEdbDataByZz(v.EdbInfoId, v.EdbCode, startDate, endDate)
- //if err != nil {
- // return errors.New("RefreshEdbDataByZz:" + err.Error())
- //}
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //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
- }
- // RefreshDataFromEic 刷新谷歌出行数据
- func RefreshDataFromGoogleTravel(wg *sync.WaitGroup) (err error) {
- defer func() {
- if err != nil {
- fmt.Println("RefreshDataFromGoogleTravel Err:" + err.Error())
- go alarm_msg.SendAlarmMsg("RefreshDataFromGoogleTravel ErrMsg:"+err.Error(), 3)
- }
- wg.Done()
- }()
- var condition string
- var pars []interface{}
- condition += " AND source=? "
- pars = append(pars, utils.DATA_SOURCE_GOOGLE_TRAVEL)
- items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
- if err != nil {
- return errors.New("GetEdbInfoByCondition:" + err.Error())
- }
- for _, v := range items {
- startDate := ""
- if v.Frequency == "日度" {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- } else if v.Frequency == "周度" {
- startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
- } else if v.Frequency == "月度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
- } else if v.Frequency == "季度" {
- startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
- } else if v.Frequency == "年度" {
- startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
- } else {
- startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
- }
- resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
- if err != nil {
- return errors.New("RefreshEdbData Err:" + err.Error())
- }
- if resp.Ret != 200 {
- return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
- }
- //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
- }
|