package models

import (
	"eta_gn/eta_chart_lib/global"
	"time"
)

//	type ExcelInfoRuleMapping struct {
//		ExcelInfoRuleMappingId int       `orm:"pk" description:"主键"`
//		ExcelInfoId            int       `description:"Excel信息ID"`
//		RuleType               int       `description:"规则类型"`
//		LeftValue              string    `description:"左值"`
//		LeftValueShow          string    `description:"左值前端显示"`
//		LeftValueType          int       `description:"左值类型"`
//		RightValue             string    `description:"右值"`
//		RightValueShow         string    `description:"右值前端显示"`
//		RightValueType         int       `description:"右值类型"`
//		FontColor              string    `description:"字体颜色"`
//		BackgroundColor        string    `description:"背景颜色"`
//		Remark                 string    `description:"预设颜色说明"`
//		RemarkEn               string    `description:"预设颜色英文说明"`
//		Scope                  string    `description:"作用范围"`
//		ScopeCoord             string    `description:"作用范围坐标"`
//		ScopeShow              string    `description:"作用范围坐标前端显示"`
//		CreateTime             time.Time `description:"创建时间"`
//	}
type ExcelInfoRuleMapping struct {
	ExcelInfoRuleMappingId int       `gorm:"column:excel_info_rule_mapping_id;primaryKey" description:"主键"`
	ExcelInfoId            int       `gorm:"column:excel_info_id" description:"Excel信息ID"`
	RuleType               int       `gorm:"column:rule_type" description:"规则类型"`
	LeftValue              string    `gorm:"column:left_value" description:"左值"`
	LeftValueShow          string    `gorm:"column:left_value_show" description:"左值前端显示"`
	LeftValueType          int       `gorm:"column:left_value_type" description:"左值类型"`
	RightValue             string    `gorm:"column:right_value" description:"右值"`
	RightValueShow         string    `gorm:"column:right_value_show" description:"右值前端显示"`
	RightValueType         int       `gorm:"column:right_value_type" description:"右值类型"`
	FontColor              string    `gorm:"column:font_color" description:"字体颜色"`
	BackgroundColor        string    `gorm:"column:background_color" description:"背景颜色"`
	Remark                 string    `gorm:"column:remark" description:"预设颜色说明"`
	RemarkEn               string    `gorm:"column:remark_en" description:"预设颜色英文说明"`
	Scope                  string    `gorm:"column:scope" description:"作用范围"`
	ScopeCoord             string    `gorm:"column:scope_coord" description:"作用范围坐标"`
	ScopeShow              string    `gorm:"column:scope_show" description:"作用范围坐标前端显示"`
	CreateTime             time.Time `gorm:"column:create_time" description:"创建时间"`
}

func (e *ExcelInfoRuleMapping) TableName() string {
	return "excel_info_rule_mapping"
}

// type ExcelInfoRuleMappingView struct {
// 	ExcelInfoRuleMappingId int    `orm:"pk" description:"主键"`
// 	ExcelInfoId            int    `description:"Excel信息ID"`
// 	RuleType               int    `description:"规则类型：1-大于，2-小于，3-介于，4-等于，5-发生日期"`
// 	LeftValue              string `description:"左值"`
// 	LeftValueBack          string `description:"左值前端显示"`
// 	LeftValueType          int    `description:"左值类型"`
// 	RightValue             string `description:"右值"`
// 	RightValueBack         string `description:"右值前端显示"`
// 	RightValueType         int    `description:"右值类型"`
// 	FontColor              string `description:"字体颜色"`
// 	BackgroundColor        string `description:"背景颜色"`
// 	Remark                 string `description:"预设颜色说明"`
// 	RemarkEn               string `description:"预设颜色英文说明"`
// 	Scope                  string `description:"作用范围"`
// 	ScopeCoord             string `description:"作用范围坐标"`
// 	ScopeShow              string `description:"作用范围坐标前端显示"`
// 	CreateTime             string `description:"创建时间"`
// }

type ExcelInfoRuleMappingView struct {
	ExcelInfoRuleMappingId int    `gorm:"column:excel_info_rule_mapping_id;primaryKey" description:"主键"`
	ExcelInfoId            int    `gorm:"column:excel_info_id" description:"Excel信息ID"`
	RuleType               int    `gorm:"column:rule_type" description:"规则类型：1-大于，2-小于，3-介于，4-等于，5-发生日期"`
	LeftValue              string `gorm:"column:left_value" description:"左值"`
	LeftValueBack          string `gorm:"column:left_value_back" description:"左值前端显示"`
	LeftValueType          int    `gorm:"column:left_value_type" description:"左值类型"`
	RightValue             string `gorm:"column:right_value" description:"右值"`
	RightValueBack         string `gorm:"column:right_value_back" description:"右值前端显示"`
	RightValueType         int    `gorm:"column:right_value_type" description:"右值类型"`
	FontColor              string `gorm:"column:font_color" description:"字体颜色"`
	BackgroundColor        string `gorm:"column:background_color" description:"背景颜色"`
	Remark                 string `gorm:"column:remark" description:"预设颜色说明"`
	RemarkEn               string `gorm:"column:remark_en" description:"预设颜色英文说明"`
	Scope                  string `gorm:"column:scope" description:"作用范围"`
	ScopeCoord             string `gorm:"column:scope_coord" description:"作用范围坐标"`
	ScopeShow              string `gorm:"column:scope_show" description:"作用范围坐标前端显示"`
	CreateTime             string `gorm:"column:create_time" description:"创建时间"`
}

func (e *ExcelInfoRuleMapping) Insert() (insertId int64, err error) {
	o := global.DmSQL["data"]
	err = o.Create(e).Error
	insertId = int64(e.ExcelInfoRuleMappingId)
	return
}

func (e *ExcelInfoRuleMapping) Update(cols []string) (err error) {
	o := global.DmSQL["data"]
	err = o.Model(e).Select(cols).Updates(e).Error
	return
}

// GetExcelRuleMappingByExcelInfoId 根据excelInfoId获取规则映射信息
func GetExcelRuleMappingByExcelInfoId(id int) (items []*ExcelInfoRuleMappingView, err error) {
	o := global.DmSQL["data"]
	sql := `SELECT * FROM excel_info_rule_mapping WHERE excel_info_id = ? ORDER BY create_time ASC`
	err = o.Raw(sql, id).Scan(&items).Error
	return
}

// GetExcelRuleMappingById 根据主键Id获取规则映射信息
func GetExcelRuleMappingById(id int) (item *ExcelInfoRuleMappingView, err error) {
	o := global.DmSQL["data"]
	sql := `SELECT * FROM excel_info_rule_mapping WHERE excel_info_rule_mapping_id = ?`
	err = o.Raw(sql, id).First(&item).Error
	return
}

func DeleteExcelRuleMappingById(id int) (err error) {
	o := global.DmSQL["data"]
	sql := `DELETE FROM excel_info_rule_mapping WHERE excel_info_rule_mapping_id = ?`
	err = o.Exec(sql, id).Error
	return
}

// func (e *ExcelInfoRuleMapping) Insert() (insertId int64, err error) {
// 	o := orm.NewOrmUsingDB("data")
// 	insertId, err = o.Insert(e)
// 	return
// }

// func (e *ExcelInfoRuleMapping) Update(cols []string) (err error) {
// 	o := orm.NewOrmUsingDB("data")
// 	_, err = o.Update(e, cols...)
// 	return
// }

// // GetExcelRuleMappingByExcelInfoId 根据excelInfoId获取规则映射信息
// func GetExcelRuleMappingByExcelInfoId(id int) (items []*ExcelInfoRuleMappingView, err error) {
// 	o := orm.NewOrmUsingDB("data")
// 	sql := `SELECT * FROM excel_info_rule_mapping WHERE excel_info_id = ? ORDER BY create_time ASC`
// 	_, err = o.Raw(sql, id).QueryRows(&items)
// 	return
// }

// // GetExcelRuleMappingById 根据主键Id获取规则映射信息
// func GetExcelRuleMappingById(id int) (item *ExcelInfoRuleMappingView, err error) {
// 	o := orm.NewOrmUsingDB("data")
// 	sql := `SELECT * FROM excel_info_rule_mapping WHERE excel_info_rule_mapping_id = ?`
// 	err = o.Raw(sql, id).QueryRow(&item)
// 	return
// }

// func DeleteExcelRuleMappingById(id int) (err error) {
// 	o := orm.NewOrmUsingDB("data")
// 	sql := `DELETE FROM excel_info_rule_mapping WHERE excel_info_rule_mapping_id = ?`
// 	_, err = o.Raw(sql, id).Exec()
// 	return
// }