package data_manage

import (
	"eta/eta_api/global"
	"eta/eta_api/utils"
)

// GetEdbDataMysteelChemicalMaxOrMinDate 根据钢联化工指标code获取最大、最小日期
func GetEdbDataMysteelChemicalMaxOrMinDate(edbCode string) (minDate, maxDate string, err error) {
	//o := orm.NewOrmUsingDB("data")
	sql := ` SELECT MIN(data_time) AS minDate,MAX(data_time) AS maxDate FROM edb_data_mysteel_chemical WHERE edb_code=? `
	//err = o.Raw(sql, edbCode).QueryRow(&minDate, &maxDate)
	var maxAndMinDate MaxAndMinDate
	err = global.DbMap[utils.DbNameIndex].Raw(sql, edbCode).First(&maxAndMinDate).Error
	if err != nil {
		return
	}
	minDate = maxAndMinDate.MinDate.Format(utils.FormatDate)
	maxDate = maxAndMinDate.MaxDate.Format(utils.FormatDate)
	return
}

// 更新钢联化工指标的刷新状态
func UpdateMysteelChemicalRefreshStatus(edbCode string, isStop int) (err error) {
	//o := orm.NewOrmUsingDB("data")
	sql := ` UPDATE base_from_mysteel_chemical_index SET is_stop = ? WHERE index_code =? and is_stop=1`
	//_, err = o.Raw(sql, isStop, edbCode).Exec()
	err = global.DbMap[utils.DbNameIndex].Exec(sql, isStop, edbCode).Error
	return
}