1234567891011121314151617181920212223242526272829303132333435 |
- package data_manage
- import (
- "eta/eta_api/global"
- "eta/eta_api/utils"
- "time"
- )
- type EdbDataThs struct {
-
- EdbDataId int `gorm:"column:edb_data_id;primaryKey"`
- EdbInfoId int
- EdbCode string
- DataTime string
- Value float64
- Status int
- CreateTime time.Time
- ModifyTime time.Time
- DataTimestamp int64 `gorm:"column:data_timestamp"`
- }
- func GetEdbDataThsMaxOrMinDate(edbCode string) (min_date, max_date string, err error) {
-
-
-
- sql := ` SELECT MIN(data_time) AS minDate,MAX(data_time) AS maxDate FROM edb_data_ths WHERE edb_code=? `
- var maxAndMinDate MaxAndMinDate
- err = global.DbMap[utils.DbNameIndex].Raw(sql, edbCode).First(&maxAndMinDate).Error
- if err != nil {
- return
- }
- min_date = maxAndMinDate.MinDate.Format(utils.FormatDate)
- max_date = maxAndMinDate.MaxDate.Format(utils.FormatDate)
- return
- }
|