edb_data_gz.go 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. package data_manage
  2. import (
  3. "eta/eta_api/global"
  4. "eta/eta_api/utils"
  5. "fmt"
  6. "github.com/beego/beego/v2/client/orm"
  7. )
  8. type GzData struct {
  9. InputValue string `orm:"column(DATA_VALUE)" description:"日期"`
  10. DataTime string `orm:"column(DATA_DATE)" description:"值"`
  11. }
  12. func GetEdbDataGzMaxOrMinDate(edbCode string) (minDate, maxDate string, err error) {
  13. //o := orm.NewOrmUsingDB("data")
  14. sql := ` SELECT MIN(data_time) AS minDate,MAX(data_time) AS maxDate FROM edb_data_gz WHERE edb_code=? `
  15. //err = o.Raw(sql, edbCode).QueryRow(&minDate, &maxDate)
  16. var maxAndMinDate MaxAndMinDate
  17. err = global.DbMap[utils.DbNameIndex].Raw(sql, edbCode).First(&maxAndMinDate).Error
  18. if err != nil {
  19. return
  20. }
  21. minDate = maxAndMinDate.MinDate.Format(utils.FormatDate)
  22. maxDate = maxAndMinDate.MaxDate.Format(utils.FormatDate)
  23. return
  24. }
  25. type GzIndexView struct {
  26. BaseFromTradeGuangzhouIndexId int `description:"指标id"`
  27. BaseFromTradeGuangzhouClassifyId int `description:"分类id"`
  28. IndexCode string `description:"指标编码"`
  29. IndexName string `description:"指标名称"`
  30. Frequency string `description:"频率"`
  31. Unit string `description:"单位"`
  32. StartDate string `description:"开始日期"`
  33. EndDate string `description:"结束日期"`
  34. Value float64 `description:"数据"`
  35. }
  36. // GetBaseInfoFromShByIndexCode 获取指标信息
  37. func GetBaseInfoFromGzByIndexCode(indexCode string) (item *GzIndexView, err error) {
  38. o := orm.NewOrmUsingDB("data")
  39. sql := `SELECT * FROM base_from_trade_guangzhou_index WHERE index_code=? `
  40. sql = fmt.Sprintf(sql)
  41. err = o.Raw(sql, indexCode).QueryRow(&item)
  42. return
  43. }