package data_manage

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

type OilchemData struct {
	InputValue string `orm:"column(DATA_VALUE)" description:"日期"`
	DataTime   string `orm:"column(DATA_DATE)" description:"值"`
}

func GetEdbDataOilchemMaxOrMinDate(edbCode string) (minDate, maxDate string, err error) {
	sql := ` SELECT MIN(data_time) AS minDate,MAX(data_time) AS maxDate FROM edb_data_oilchem 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
}

type BaseFromOilchemIndexItem struct {
	BaseFromSciIndexId int    `orm:"column(base_from_oilchem_index_id);pk"` // 主键，自动递增
	IndexCode          string // 指标编码
	IndexName          string // 指标名称
	ClassifyId         int    // 分类Id
	Unit               string // 单位
	Frequency          string // 频度
	Describe           string // 指标描述
	CreateTime         string // 创建时间
	ModifyTime         string // 修改时间
}

// GetBaseInfoFromOilchemByIndexCode 获取指标信息
func GetBaseInfoFromOilchemByIndexCode(indexCode string) (item *BaseFromOilchemIndexItem, err error) {
	o := global.DmSQL["data"]
	sql := `SELECT * FROM base_from_oilchem_index WHERE index_code=? `
	sql = fmt.Sprintf(sql)
	err = o.Raw(sql, indexCode).Scan(&item).Error

	return
}