hongze_yb/models/tables/factor_edb_series_mapping/model.go

package factor_edb_series_mapping

import (
	"hongze/hongze_yb/global"
	"time"
)

// FactorEdbSeriesMapping 因子指标系列-指标关联表
type FactorEdbSeriesMapping struct {
	FactorEdbSeriesMappingId int       `orm:"column(factor_edb_series_mapping_id);pk"`
	FactorEdbSeriesId        int       `description:"因子指标系列ID"`
	EdbInfoId                int       `description:"指标ID"`
	EdbCode                  string    `description:"指标编码"`
	CalculateData            string    `description:"计算数据-JSON（如相关性矩阵等等）"`
	CreateTime               time.Time `description:"创建时间"`
	ModifyTime               time.Time `description:"修改时间"`
}

// GetChartUsedFactorSeriesEdb 获取图表引用的系列指标
func GetChartUsedFactorSeriesEdb(chartId int) (items []*FactorEdbSeriesMapping, err error) {
	sql := `SELECT b.* FROM factor_edb_series_chart_mapping AS a
	JOIN factor_edb_series_mapping AS b ON a.factor_edb_series_id = b.factor_edb_series_id AND a.edb_info_id = b.edb_info_id
	WHERE a.chart_info_id = ? ORDER BY factor_edb_series_id ASC`
	err = global.MYSQL["data"].Raw(sql, chartId).Scan(&items).Error
	return
}