model

type BaseModel struct {
	CreatedBy string     `json:"created_by" binding:"-"`
	CreatedAt time.Time  `json:"created_at" binding:"-"`
	UpdatedBy string     `json:"updated_by" binding:"-"`
	UpdatedAt time.Time  `json:"updated_at" binding:"-"`
	DeletedAt *time.Time `json:"deleted_at" sql:"index" binding:"-"`
	Remark    string     `json:"remark"`
}

type CasbinModel struct {
	PType  string `json:"p_type" gorm:"column:p_type" description:"策略类型"`
	RoleId int    `json:"role_id" gorm:"column:v0" description:"角色ID"`
	Path   string `json:"path" gorm:"column:v1" description:"api路径"`
	Method string `json:"method" gorm:"column:v2" description:"访问方法"`
}

type SysConfig struct {
	BaseModel
	ConfigId    int
	ConfigName  string
	ConfigKey   string
	ConfigValue string
	ConfigType  string
}

type SysDept struct {
	BaseModel
	DeptId    int
	ParentId  int
	Ancestors string
	DeptName  string
	OrderNum  int
	Leader    string
	Phone     string
	Email     string
	Status    string
	DelFlag   string
}

type SysDictData struct {
	BaseModel
	DictDataId int
	DictSort   int
	DictLabel  string
	DictValue  string
	DictType   string
	CssClass   string
	ListClass  string
	IsDefault  string
	Status     string
}

type SysDictType struct {
	BaseModel
	DictTypeId int
	DictName   string
	DictType   string
	Status     string
}

type SysMenu struct {
	BaseModel
	MenuId    int
	ParentId  int
	MenuName  string
	MenuType  string
	OrderNum  int
	Path      string
	Component string
	Query     string
	IsFrame   int
	IsCache   int
	Visible   string
	Status    string
	Perms     string
	Icon      string
}

type SysRole struct {
	BaseModel
	RoleId            int
	RoleName          string
	RoleKey           string
	RoleSort          int
	DataScope         string
	MenuCheckStrictly int
	DeptCheckStrictly int
}

type SysUser struct {
	BaseModel
	UserId      int       `gorm:"type:bigint(32);primary_key;auto_increment"`
	DeptId      int       `gorm:"type:bigint(32)"`
	UserName    string    `gorm:"type:varchar(32)"`
	NickName    string    `gorm:"type:varchar(32)"`
	UserType    string    `gorm:"type:varchar(2)"`
	Email       string    `gorm:"type:varchar(64)"`
	PhoneNumber string    `gorm:"type:varchar(15)"`
	Sex         int       `gorm:"type:int(1)"`
	Avatar      string    `gorm:"type:varchar(128)"`
	Password    string    `gorm:"type:varchar(64)"`
	Status      string    `gorm:"type:char(1)"`
	LoginIP     string    `gorm:"type:varchar(128)"`
	LoginDate   time.Time `gorm:"type:datetime"`
}

type UserVoucher struct {
	UserId    int
	VoucherId int
}

type Voucher struct {
	BaseModel
	VoucherId         int       `gorm:"primary_key;auto_increment"`   // 票券ID
	MerchantId        int       `gorm:"type:int(20); not null"`       // 票券商家ID
	VoucherName       string    `gorm:"type:varchar(64); not null"`   // 票券名称
	VoucherCode       string    `gorm:"type:varchar(64); not null"`   // 票券编码
	VoucherType       int       `gorm:"type:int(2); not null"`        // 票券类型
	FullLimit         float32   `gorm:"type:decimal(8, 2); not null"` // 满额限制
	DiscountAmount    float32   `gorm:"type:decimal(8, 2); not null"` // 折扣金额
	UseRangeType      int       `gorm:"type:int(2); not null"`        // 使用范围类型
	UseRangeId        int       `gorm:"type:int(2); not null"`        // 使用范围ID
	PublishCount      int       `gorm:"type:int(8); not null"`        // 发行数量
	UseCount          int       `gorm:"type:int(8); not null"`        // 使用数量
	ReceiveCount      int       `gorm:"type:int(8); not null"`        // 领取数量
	StartPeriod       time.Time `gorm:"type:datatime; not null"`      // 其实有效期
	EndPeriod         time.Time `gorm:"type:datatime; not null"`      // 结束有效期
	VoucherStatus     int       `gorm:"type:int(2); not null"`        // 票券状态
	AvailablePlatform int       `gorm:"type:int(2); not null"`        // 可用平台
}