package models

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

type CalculateResidualAnalysisConfigMapping struct {
	CalculateResidualAnalysisConfigMappingId int       `orm:"column(calculate_residual_analysis_config_mapping_id);pk;auto" description:"自增id"`
	CalculateResidualAnalysisConfigId        int       `orm:"column(calculate_residual_analysis_config_id)" description:"残差分析配置id"`
	EdbInfoId                                int64     `orm:"column(edb_info_id)" description:"指标id"`
	ResidualType                             int       `orm:"column(residual_type)" description:"残差类型: 1-映射残差 2-拟合残差"`
	IndexType                                int       `orm:"column(index_type)" description:"指标类型：1-映射指标 2-残差指标 3-因变量指标 4-自变量指标"`
	CreateTime                               time.Time `orm:"column(create_time)" description:"创建时间"`
	ModifyTime                               time.Time `orm:"column(modify_time)" description:"修改时间"`
}

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

// GetConfigMappingListByConfigId 根据配置配置id查询配置信息
func GetConfigMappingListByConfigId(configId int) (items []CalculateResidualAnalysisConfigMapping, err error) {
	o := orm.NewOrmUsingDB("data")
	sql := `select * from calculate_residual_analysis_config_mapping where calculate_residual_analysis_config_id = ?`

	_, err = o.Raw(sql, configId).QueryRows(&items)
	return items, nil
}

// GetConfigMappingListByCondition 通过条件查询指标配置映射
func GetConfigMappingListByCondition(condition string, pars []interface{}) (items []CalculateResidualAnalysisConfigMapping, err error) {
	o := orm.NewOrmUsingDB("data")
	sql := `select * from calculate_residual_analysis_config_mapping where 1=1 `

	sql += condition

	_, err = o.Raw(sql, pars).QueryRows(&items)
	return items, nil
}

// GetConfigMappingListByConditionNotBase 查询非基础指标的配置映射
func GetConfigMappingListByConditionNotBase(edbInfoId int) (configMapping []CalculateResidualAnalysisConfigMapping, err error) {
	o := orm.NewOrmUsingDB("data")
	sql := `select * from calculate_residual_analysis_config_mapping where 1=1 and edb_info_id in (select edb_info_id from edb_info where index_type != 3 and index_type != 4 and edb_info_id = ?) `
	_, err = o.Raw(sql, edbInfoId).QueryRows(&configMapping)
	if err != nil {
		return nil, fmt.Errorf("查询数据时出错: %v", err)
	}
	return configMapping, nil
}