eta_api/models/data_manage/edb_data_ths.go

package data_manage

import (
	"eta_gn/eta_api/global"
	"time"
)

type EdbDataThs struct {
	EdbDataId     int `gorm:"primaryKey" `
	EdbInfoId     int
	EdbCode       string
	DataTime      string
	Value         float64
	Status        int
	CreateTime    time.Time
	ModifyTime    time.Time
	DataTimestamp int64
}

func GetEdbDataThsMaxOrMinDate(edbCode string) (minDate, maxDate string, err error) {
	sql := ` SELECT MIN(data_time) AS min_date,MAX(data_time) AS max_date FROM edb_data_ths WHERE edb_code=? `

	var tmpDate SmmMaxOrMinDate
	err = global.DmSQL["data"].Raw(sql, edbCode).Scan(&tmpDate).Error
	if err != nil {
		return
	}

	minDate = tmpDate.MinDate
	maxDate = tmpDate.MaxDate

	return
}