package models

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

// SysConfig 系统配置表
type SysConfig struct {
	ConfigId    int       `orm:"column(config_id);pk"`
	ConfigCode  string    `description:"配置编码"`
	ConfigValue string    `description:"配置值"`
	Remark      string    `description:"备注信息"`
	CreateTime  time.Time `description:"创建时间"`
	ModifyTime  time.Time `description:"更新时间"`
}

func (m *SysConfig) TableName() string {
	return "sys_config"
}

type SysConfigCols struct {
	PrimaryId   string
	ConfigCode  string
	ConfigValue string
	Remark      string
	CreateTime  string
	ModifyTime  string
}

func (m *SysConfig) Cols() SysConfigCols {
	return SysConfigCols{
		PrimaryId:   "config_id",
		ConfigCode:  "config_code",
		ConfigValue: "config_value",
		Remark:      "remark",
		CreateTime:  "create_time",
		ModifyTime:  "modify_time",
	}
}

func (m *SysConfig) GetConfigByCode(code string) (item *SysConfig, err error) {
	o := orm.NewOrm()
	sql := fmt.Sprintf(`SELECT * FROM %s WHERE %s = ? LIMIT 1`, m.TableName(), m.Cols().ConfigCode)
	err = o.Raw(sql, code).QueryRow(&item)
	return
}