package residual_analysis_model
import (
"eta/eta_api/global"
"eta/eta_api/utils"
"time"
)
type CalculateResidualAnalysisConfig struct {
CalculateResidualAnalysisConfigId int `orm:"column(calculate_residual_analysis_config_id);pk" gorm:"primaryKey" 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:"修改时间"`
}
// 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" gorm:"primaryKey"`
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 := global.DbMap[utils.DbNameIndex]
sql := "SELECT * FROM calculate_residual_analysis_config WHERE calculate_residual_analysis_config_id=?"
err = o.Raw(sql, configId).First(&residualAnalysisConfig).Error
return residualAnalysisConfig, nil
}
// UpdateResidualAnalysisConfig 更新配置信息
func UpdateResidualAnalysisConfig(config CalculateResidualAnalysisConfig) (err error) {
o := global.DbMap[utils.DbNameIndex]
err = o.Updates(&config).Error
return
}
// SaveResidualAnalysisConfig 保存配置信息
func SaveResidualAnalysisConfig(config CalculateResidualAnalysisConfig) (id int64, err error) {
o := global.DbMap[utils.DbNameIndex]
err = o.Create(&config).Error
if err != nil {
return 0, err
}
id = int64(config.CalculateResidualAnalysisConfigId)
return id, nil
}