eta_api/models/residual_analysis_model/calculate_residual_analysis_config.go

package residual_analysis_model

import (
	"github.com/beego/beego/v2/client/orm"
	"time"
)

type CalculateResidualAnalysisConfig struct {
	CalculateResidualAnalysisConfigId int       `orm:"column(calculate_residual_analysis_config_id);pk;auto" description:"自增id"`
	Config                            string    `orm:"column(config)" description:"计算参数配置"`
	SysUserId                         int       `orm:"column(sys_user_id)" description:"操作人id"`
	CreateTime                        time.Time `orm:"column(create_time)" description:"创建时间"`
	ModifyTime                        time.Time `orm:"column(modify_time)" description:"修改时间"`
}

func init() {
	orm.RegisterModel(new(CalculateResidualAnalysisConfig))
}

// ResidualAnalysisReq 残差分析预览请求
type ResidualAnalysisReq struct {
	EdbInfoIdA       int     `description:"指标A"`
	EdbInfoIdB       int     `description:"指标B"`
	EdbInfoId        int     `description:"残差指标id"`
	ConfigId         int     `description:"配置id"`
	QueryType        int     `description:"查询类型区分 避免查询过慢 1-查询第一个表格 2-查询需要计算的表格"`
	ResidualType     int     `description:"残差类型: 1-映射残差 2-拟合残差"`
	DateType         int     `description:"时间类型 -1-自定义时间 0-至今 n-枚举时间（近n年）"`
	StartDate        string  `description:"自定义开始日期"`
	EndDate          string  `description:"自定义结束日期"`
	IsOrder          bool    `description:"true:正序,false:逆序"`
	IndexType        int     `description:"1-标准指标 2-领先指标"`
	LeadValue        int     `description:"领先值"`
	LeadFrequency    string  `description:"领先频度"`
	LeftIndexMin     float64 `description:"指标A左侧下限"`
	LeftIndexMax     float64 `description:"指标A左侧上限"`
	RightIndexMin    float64 `description:"指标B右侧下限"`
	RightIndexMax    float64 `description:"指标B右侧上限"`
	ResidualIndexMin float64 `description:"残差指标下限"`
	ResidualIndexMax float64 `description:"残差指标上限"`
	ContrastIndexMin float64 `description:"对比指标下限"`
	ContrastIndexMax float64 `description:"对比指标上限"`
}

// ResidualAnalysisResp 残差分析预览响应
type ResidualAnalysisResp struct {
	OriginalChartData ChartResp `description:"原始图数据"`
	MappingChartData  ChartResp `description:"映射图数据"`
	ResidualChartData ChartResp `description:"残差图数据"`
	A                 float64   `description:"斜率"`
	B                 float64   `description:"截距"`
	R                 float64   `description:"相关系数"`
	R2                float64   `description:"决定系数"`
}

type ChartResp struct {
	ChartInfo   ResidualAnalysisChartInfo
	EdbInfoList []ResidualAnalysisChartEdbInfoMapping
}

type ResidualAnalysisChartInfo struct {
	ChartName     string  `description:"来源名称"`
	ChartNameEn   string  `description:"英文图表名称"`
	Unit          string  `description:"中文单位名称"`
	UnitEn        string  `description:"英文单位名称"`
	UniqueCode    string  `description:"图表唯一编码"`
	DateType      int     `description:"时间类型 0-自定义时间 1-至今 n-枚举时间（近n年）"`
	StartDate     string  `description:"自定义开始日期"`
	EndDate       string  `description:"自定义结束日期"`
	ChartType     int     `description:"生成样式:1:曲线图,2:季节性图"`
	ChartWidth    float64 `description:"线条大小"`
	Calendar      string  `description:"公历/农历"`
	Disabled      int     `description:"是否禁用，0：启用，1：禁用，默认：0"`
	Source        int     `description:"1：ETA图库；2：商品价格曲线；3：相关性图表"`
	ChartSource   string  `description:"图表来源str"`
	ChartSourceEn string  `description:"图表来源（英文）"`
	SourcesFrom   string  `description:"图表来源"`
	Instructions  string  `description:"图表说明"`
}

type ResidualAnalysisChartEdbInfoMapping struct {
	EdbInfoId           int     `description:"指标id"`
	SourceName          string  `description:"来源名称"`
	Source              int     `description:"来源id"`
	EdbCode             string  `description:"指标编码"`
	EdbName             string  `description:"指标名称"`
	EdbNameEn           string  `description:"英文指标名称"`
	EdbType             int     `description:"指标类型:1:基础指标,2:计算指标"`
	Frequency           string  `description:"频率"`
	FrequencyEn         string  `description:"英文频率"`
	Unit                string  `description:"单位"`
	UnitEn              string  `description:"英文单位"`
	StartDate           string  `description:"起始日期"`
	EndDate             string  `description:"终止日期"`
	ModifyTime          string  `description:"指标最后更新时间"`
	MaxData             float64 `description:"上限"`
	MinData             float64 `description:"下限"`
	IsOrder             bool    `description:"true:逆序:,false:正序"`
	IsAxis              int     `description:"1:左轴,0:右轴"`
	EdbInfoType         int     `description:"1:标准指标,0:领先指标"`
	EdbInfoCategoryType int     `description:"0:普通指标,1:预测指标"`
	LeadValue           int     `description:"领先值"`
	LeadUnit            string  `description:"领先单位"`
	LeadUnitEn          string  `description:"领先英文单位"`
	ChartStyle          string  `description:"图表类型"`
	ChartColor          string  `description:"颜色"`
	PredictChartColor   string  `description:"预测数据的颜色"`
	ChartWidth          float64 `description:"线条大小"`
	ChartType           int     `description:"生成样式:1:曲线图,2:季节性图,3:面积图，4：柱状图，5：散点图，6：组合图，7：柱方图，8：商品价格曲线图，9：相关性图"`
	LatestDate          string  `description:"数据最新日期"`
	LatestValue         float64 `description:"数据最新值"`
	MinValue            float64 `description:"最小值"`
	MaxValue            float64 `description:"最大值"`
	DataList            interface{}

	LeftIndexMin     float64 `description:"指标A左侧下限"`
	LeftIndexMax     float64 `description:"指标A左侧上限"`
	RightIndexMin    float64 `description:"指标B右侧下限"`
	RightIndexMax    float64 `description:"指标B右侧上限"`
	ResidualIndexMin float64 `description:"残差指标下限"`
	ResidualIndexMax float64 `description:"残差指标上限"`
	ContrastIndexMin float64 `description:"对比指标下限"`
	ContrastIndexMax float64 `description:"对比指标上限"`
}

type ResidualAnalysisIndexSaveReq struct {
	EdbInfoIdA   int                       `description:"指标A"`
	EdbInfoIdB   int                       `description:"指标B"`
	Source       int                       `description:"99-映射残差 100-拟合残差"`
	EdbCode      string                    `description:"指标编码"`
	EdbName      string                    `description:"指标名称"`
	EdbNameEn    string                    `description:"英文指标名称"`
	EdbType      int                       `description:"指标类型:1:基础指标,2:计算指标"`
	Frequency    string                    `description:"频率"`
	FrequencyEn  string                    `description:"英文频率"`
	Unit         string                    `description:"单位"`
	UnitEn       string                    `description:"英文单位"`
	Calendar     string                    `description:"公历/农历"`
	ClassifyId   int                       `description:"分类id"`
	ConfigId     int                       `description:"残差配置id"`
	ResidualType int                       `orm:"column(residual_type)" description:"残差类型: 1-映射残差 2-拟合残差"`
	IndexType    int                       `orm:"column(index_type)" description:"指标类型：1-映射指标 2-残差指标 3-因变量指标 4-自变量指标"`
	DataList     []edbDataResidualAnalysis `description:"指标数据"`
}

// ResidualAnalysisConfigVo 残差分析配置vo
type ResidualAnalysisConfigVo struct {
	ResidualType     int     `description:"残差类型: 1-映射残差 2-拟合残差"`
	DateType         int     `description:"时间类型 -1-自定义时间 0-至今 n-枚举时间（近n年）"`
	StartDate        string  `description:"自定义开始日期"`
	EndDate          string  `description:"自定义结束日期"`
	IsOrder          bool    `description:"true:正序,false:逆序"`
	IndexType        int     `description:"1-标准指标 2-领先指标"`
	LeadValue        int     `description:"领先值"`
	LeadFrequency    string  `description:"领先频度"`
	LeftIndexMin     float64 `description:"指标A左侧下限"`
	LeftIndexMax     float64 `description:"指标A左侧上限"`
	RightIndexMin    float64 `description:"指标B右侧下限"`
	RightIndexMax    float64 `description:"指标B右侧上限"`
	ResidualIndexMin float64 `description:"残差指标下限"`
	ResidualIndexMax float64 `description:"残差指标上限"`
	ContrastIndexMin float64 `description:"对比指标下限"`
	ContrastIndexMax float64 `description:"对比指标上限"`
}

type DetailEdbInfoList struct {
	EdbInfoId   int    `orm:"column(edb_info_id);pk"`
	EdbInfoType int    `description:"指标类型，0：普通指标，1：预测指标"`
	IndexType   int    `orm:"column(index_type)" description:"指标类型：1-映射指标 2-残差指标 3-因变量指标 4-自变量指标"`
	SourceName  string `description:"来源名称"`
	Source      int    `description:"来源id"`
	EdbCode     string `description:"指标编码"`
	EdbNameEn   string `description:"英文指标名称"`
	EdbName     string `description:"指标名称"`
	Frequency   string `description:"频率"`
	FrequencyEn string `description:"英文频率"`
	Unit        string `description:"单位"`
	UnitEn      string `description:"英文单位"`
	ClassifyId  int    `description:"分类id"`
}

// ResidualAnalysisDetailResp 详情响应接口
type ResidualAnalysisDetailResp struct {
	ConfigInfo   *CalculateResidualAnalysisConfig
	EdbInfoList  []*DetailEdbInfoList
	ResidualType int `description:"残差类型: 1-映射残差 2-拟合残差"`
}

// GetResidualAnalysisConfigById 根据配置id查询配置信息
func GetResidualAnalysisConfigById(configId int) (residualAnalysisConfig CalculateResidualAnalysisConfig, err error) {
	o := orm.NewOrmUsingDB("data")
	sql := "SELECT * FROM calculate_residual_analysis_config WHERE calculate_residual_analysis_config_id=?"
	err = o.Raw(sql, configId).QueryRow(&residualAnalysisConfig)
	return residualAnalysisConfig, nil
}

// UpdateResidualAnalysisConfig 更新配置信息
func UpdateResidualAnalysisConfig(config CalculateResidualAnalysisConfig) (err error) {
	o := orm.NewOrmUsingDB("data")
	_, err = o.Update(&config)
	if err != nil {
		return err
	}
	return nil
}

// SaveResidualAnalysisConfig 保存配置信息
func SaveResidualAnalysisConfig(config CalculateResidualAnalysisConfig) (id int64, err error) {
	o := orm.NewOrmUsingDB("data")
	id, err = o.Insert(&config)
	if err != nil {
		return 0, err
	}
	return id, nil
}