package data_manage

import (
	"eta/eta_task/global"
	"eta/eta_task/utils"
	"time"
)

type BaseFromKplerIndex struct {
	BaseFromKplerIndexId int `gorm:"column:base_from_kpler_index_id;primaryKey"`
	ClassifyId    int
	IndexCode     string
	IndexName     string
	Frequency     string
	Unit          string
	Sort          int
	StartDate     string `description:"开始日期"`
	EndDate       string `description:"结束日期"`
	EndValue      float64
	CreateTime    time.Time
	ModifyTime    time.Time
	BaseFileName  string `description:"文件目录"`
	TerminalCode  string `description:"所属终端编码"`
	ApiQueryUrl   string `description:"API查询URL"`
	ExcelQueryUrl string `description:"Excel查询URL"`
	ProductNames  string `description:"产品名称"`
	FromZoneId    int    `description:"区域ID"`
	FromZoneName  string `description:"区域名称"`
	ToZoneId      int    `description:"区域ID"`
	ToZoneName    string `description:"区域名称"`
	FlowDirection string `description:"流向"`
	Granularity   string `description:"粒度"`
	Split         string `description:"拆分类型"`
}

func (m *BaseFromKplerIndex) GetApiNum() (num int64, err error) {
	o := global.DbMap[utils.DbNameIndex]
	err = o.Model(m).Where("api_query_url != ''").Count(&num).Error
	return
}