sysmodel

Documentation

Index

• Variables
• type SysConfig
• type SysConfigModel
  • func NewSysConfigModel(conn sqlx.SqlConn) SysConfigModel
• type SysDept
• type SysDeptModel
  • func NewSysDeptModel(conn sqlx.SqlConn) SysDeptModel
• type SysDict
• type SysDictModel
  • func NewSysDictModel(conn sqlx.SqlConn) SysDictModel
• type SysJob
• type SysJobModel
  • func NewSysJobModel(conn sqlx.SqlConn) SysJobModel
• type SysLog
• type SysLogModel
  • func NewSysLogModel(conn sqlx.SqlConn) SysLogModel
• type SysLoginLog
• type SysLoginLogModel
  • func NewSysLoginLogModel(conn sqlx.SqlConn) SysLoginLogModel
• type SysMenu
• type SysMenuModel
  • func NewSysMenuModel(conn sqlx.SqlConn) SysMenuModel
• type SysRole
• type SysRoleDept
• type SysRoleDeptModel
  • func NewSysRoleDeptModel(conn sqlx.SqlConn) SysRoleDeptModel
• type SysRoleMenu
• type SysRoleMenuModel
  • func NewSysRoleMenuModel(conn sqlx.SqlConn) SysRoleMenuModel
• type SysRoleModel
  • func NewSysRoleModel(conn sqlx.SqlConn) SysRoleModel
• type SysUser
• type SysUserList
• type SysUserModel
  • func NewSysUserModel(conn sqlx.SqlConn) SysUserModel
• type SysUserRole
• type SysUserRoleModel
  • func NewSysUserRoleModel(conn sqlx.SqlConn) SysUserRoleModel

Variables

var ErrNotFound = sqlx.ErrNotFound

Types

type SysConfig

type SysConfig struct {
	Id          int64          `db:"id"`          // 编号
	Value       string         `db:"value"`       // 数据值
	Label       string         `db:"label"`       // 标签名
	Type        string         `db:"type"`        // 类型
	Description string         `db:"description"` // 描述
	Sort        float64        `db:"sort"`        // 排序（升序）
	CreateBy    sql.NullString `db:"create_by"`   // 创建人
	CreateTime  time.Time      `db:"create_time"` // 创建时间
	UpdateBy    sql.NullString `db:"update_by"`   // 更新人
	UpdateTime  sql.NullTime   `db:"update_time"` // 更新时间
	Remarks     sql.NullString `db:"remarks"`     // 备注信息
	DelFlag     int64          `db:"del_flag"`    // 是否删除  -1：已删除  0：正常
}

type SysConfigModel

type SysConfigModel interface {
	Count(ctx context.Context) (int64, error)
	FindAll(ctx context.Context, Current int64, PageSize int64) (*[]SysConfig, error)
	DeleteByIds(ctx context.Context, ids []int64) error
	// contains filtered or unexported methods
}

SysConfigModel is an interface to be customized, add more methods here, and implement the added methods in customSysConfigModel.

func NewSysConfigModel

func NewSysConfigModel(conn sqlx.SqlConn) SysConfigModel

NewSysConfigModel returns a model for the database table.

type SysDept

type SysDept struct {
	Id         int64          `db:"id"`          // 编号
	Name       string         `db:"name"`        // 机构名称
	ParentId   int64          `db:"parent_id"`   // 上级机构ID，一级机构为0
	OrderNum   int64          `db:"order_num"`   // 排序
	CreateBy   string         `db:"create_by"`   // 创建人
	CreateTime time.Time      `db:"create_time"` // 创建时间
	UpdateBy   sql.NullString `db:"update_by"`   // 更新人
	UpdateTime sql.NullTime   `db:"update_time"` // 更新时间
	DelFlag    int64          `db:"del_flag"`    // 是否删除  -1：已删除  0：正常
	ParentIds  string         `db:"parent_ids"`  // 上级机构IDs，一级机构为0
}

type SysDeptModel

type SysDeptModel interface {
	Count(ctx context.Context) (int64, error)
	FindAll(ctx context.Context, Current int64, PageSize int64) (*[]SysDept, error)
	DeleteByIds(ctx context.Context, ids []int64) error
	// contains filtered or unexported methods
}

SysDeptModel is an interface to be customized, add more methods here, and implement the added methods in customSysDeptModel.

func NewSysDeptModel

func NewSysDeptModel(conn sqlx.SqlConn) SysDeptModel

NewSysDeptModel returns a model for the database table.

type SysDict

type SysDict struct {
	Id          int64          `db:"id"`          // 编号
	Value       string         `db:"value"`       // 数据值
	Label       string         `db:"label"`       // 标签名
	Type        string         `db:"type"`        // 类型
	Description string         `db:"description"` // 描述
	Sort        float64        `db:"sort"`        // 排序（升序）
	CreateBy    string         `db:"create_by"`   // 创建人
	CreateTime  time.Time      `db:"create_time"` // 创建时间
	UpdateBy    sql.NullString `db:"update_by"`   // 更新人
	UpdateTime  time.Time      `db:"update_time"` // 更新时间
	Remarks     sql.NullString `db:"remarks"`     // 备注信息
	DelFlag     int64          `db:"del_flag"`    // 是否删除  -1：已删除  0：正常
}

type SysDictModel

type SysDictModel interface {
	Count(ctx context.Context, in *sysclient.DictListReq) (int64, error)
	FindAll(ctx context.Context, in *sysclient.DictListReq) (*[]SysDict, error)
	DeleteByIds(ctx context.Context, ids []int64) error
	// contains filtered or unexported methods
}

SysDictModel is an interface to be customized, add more methods here, and implement the added methods in customSysDictModel.

func NewSysDictModel

func NewSysDictModel(conn sqlx.SqlConn) SysDictModel

NewSysDictModel returns a model for the database table.

type SysJob

type SysJob struct {
	Id         int64          `db:"id"`          // 编号
	JobName    string         `db:"job_name"`    // 职位名称
	OrderNum   int64          `db:"order_num"`   // 排序
	CreateBy   string         `db:"create_by"`   // 创建人
	CreateTime time.Time      `db:"create_time"` // 创建时间
	UpdateBy   sql.NullString `db:"update_by"`   // 更新人
	UpdateTime sql.NullTime   `db:"update_time"` // 更新时间
	DelFlag    int64          `db:"del_flag"`    // 是否删除  -1：已删除  0：正常
	Remarks    sql.NullString `db:"remarks"`     // 备注
}

type SysJobModel

type SysJobModel interface {
	Count(ctx context.Context, in *sysclient.JobListReq) (int64, error)
	FindAll(ctx context.Context, in *sysclient.JobListReq) (*[]SysJob, error)
	DeleteByIds(ctx context.Context, ids []int64) error
	// contains filtered or unexported methods
}

SysJobModel is an interface to be customized, add more methods here, and implement the added methods in customSysJobModel.

func NewSysJobModel

func NewSysJobModel(conn sqlx.SqlConn) SysJobModel

NewSysJobModel returns a model for the database table.

type SysLog

type SysLog struct {
	Id             int64          `db:"id"`              // 编号
	UserName       string         `db:"user_name"`       // 用户名
	Operation      string         `db:"operation"`       // 用户操作
	Method         string         `db:"method"`          // 请求方法
	RequestParams  string         `db:"request_params"`  // 请求参数
	ResponseParams sql.NullString `db:"response_params"` // 响应参数
	Time           int64          `db:"time"`            // 执行时长(毫秒)
	Ip             sql.NullString `db:"ip"`              // IP地址
	OperationTime  time.Time      `db:"operation_time"`  // 操作时间
}

type SysLogModel

type SysLogModel interface {
	Count(ctx context.Context, in *sysclient.SysLogListReq) (int64, error)
	FindAll(ctx context.Context, in *sysclient.SysLogListReq) (*[]SysLog, error)
	DeleteByIds(ctx context.Context, ids []int64) error
	// contains filtered or unexported methods
}

SysLogModel is an interface to be customized, add more methods here, and implement the added methods in customSysLogModel.

func NewSysLogModel

func NewSysLogModel(conn sqlx.SqlConn) SysLogModel

NewSysLogModel returns a model for the database table.

type SysLoginLog

type SysLoginLog struct {
	Id         int64     `db:"id"`          // 编号
	UserName   string    `db:"user_name"`   // 用户名
	Status     string    `db:"status"`      // 登录状态（online:在线，登录初始状态，方便统计在线人数；login:退出登录后将online置为login；logout:退出登录）
	Ip         string    `db:"ip"`          // IP地址
	CreateBy   string    `db:"create_by"`   // 创建人
	CreateTime time.Time `db:"create_time"` // 创建时间
}

type SysLoginLogModel

type SysLoginLogModel interface {
	Count(ctx context.Context, in *sysclient.LoginLogListReq) (int64, error)
	FindAll(ctx context.Context, in *sysclient.LoginLogListReq) (*[]SysLoginLog, error)
	DeleteByIds(ctx context.Context, ids []int64) error
	StatisticsLoginLog(ctx context.Context, flag int64) (int32, error)
	// contains filtered or unexported methods
}

SysLoginLogModel is an interface to be customized, add more methods here, and implement the added methods in customSysLoginLogModel.

func NewSysLoginLogModel

func NewSysLoginLogModel(conn sqlx.SqlConn) SysLoginLogModel

NewSysLoginLogModel returns a model for the database table.

type SysMenu

type SysMenu struct {
	Id            int64          `db:"id"`        // 编号
	Name          string         `db:"name"`      // 菜单名称
	ParentId      int64          `db:"parent_id"` // 父菜单ID，一级菜单为0
	Url           sql.NullString `db:"url"`
	Perms         sql.NullString `db:"perms"`          // 授权(多个用逗号分隔，如：sys:user:add,sys:user:edit)
	Type          int64          `db:"type"`           // 类型   0：目录   1：菜单   2：按钮
	Icon          sql.NullString `db:"icon"`           // 菜单图标
	OrderNum      sql.NullInt64  `db:"order_num"`      // 排序
	CreateBy      string         `db:"create_by"`      // 创建人
	CreateTime    time.Time      `db:"create_time"`    // 创建时间
	UpdateBy      sql.NullString `db:"update_by"`      // 更新人
	UpdateTime    sql.NullTime   `db:"update_time"`    // 更新时间
	DelFlag       int64          `db:"del_flag"`       // 是否删除  -1：已删除  0：正常
	VuePath       sql.NullString `db:"vue_path"`       // vue系统的path
	VueComponent  sql.NullString `db:"vue_component"`  // vue的页面
	VueIcon       sql.NullString `db:"vue_icon"`       // vue的图标
	VueRedirect   sql.NullString `db:"vue_redirect"`   // vue的路由重定向
	BackgroundUrl string         `db:"background_url"` // 后台地址
}

type SysMenuModel

type SysMenuModel interface {
	Count(ctx context.Context) (int64, error)
	FindAll(ctx context.Context, Current int64, PageSize int64) (*[]SysMenu, error)
	DeleteByIds(ctx context.Context, ids []int64) error
	FindAllByUserId(ctx context.Context, userId int64) (*[]SysMenu, error)
	// contains filtered or unexported methods
}

SysMenuModel is an interface to be customized, add more methods here, and implement the added methods in customSysMenuModel.

func NewSysMenuModel

func NewSysMenuModel(conn sqlx.SqlConn) SysMenuModel

NewSysMenuModel returns a model for the database table.

type SysRole

type SysRole struct {
	Id         int64          `db:"id"`          // 编号
	Name       string         `db:"name"`        // 角色名称
	Remark     sql.NullString `db:"remark"`      // 备注
	CreateBy   string         `db:"create_by"`   // 创建人
	CreateTime time.Time      `db:"create_time"` // 创建时间
	UpdateBy   sql.NullString `db:"update_by"`   // 更新人
	UpdateTime sql.NullTime   `db:"update_time"` // 更新时间
	DelFlag    int64          `db:"del_flag"`    // 是否删除  -1：已删除  0：正常
	Status     int64          `db:"status"`      // 状态  1:启用,0:禁用
}

type SysRoleDept

type SysRoleDept struct {
	Id         int64     `db:"id"`          // 编号
	RoleId     int64     `db:"role_id"`     // 角色ID
	DeptId     int64     `db:"dept_id"`     // 机构ID
	CreateBy   string    `db:"create_by"`   // 创建人
	CreateTime time.Time `db:"create_time"` // 创建时间
}

type SysRoleDeptModel

type SysRoleDeptModel interface {
	Count(ctx context.Context) (int64, error)
	FindAll(ctx context.Context, Current int64, PageSize int64) (*[]SysRoleDept, error)
	DeleteByIds(ctx context.Context, ids []int64) error
	// contains filtered or unexported methods
}

SysRoleDeptModel is an interface to be customized, add more methods here, and implement the added methods in customSysRoleDeptModel.

func NewSysRoleDeptModel

func NewSysRoleDeptModel(conn sqlx.SqlConn) SysRoleDeptModel

NewSysRoleDeptModel returns a model for the database table.

type SysRoleMenu

type SysRoleMenu struct {
	Id         int64     `db:"id"`          // 编号
	RoleId     int64     `db:"role_id"`     // 角色ID
	MenuId     int64     `db:"menu_id"`     // 菜单ID
	CreateBy   string    `db:"create_by"`   // 创建人
	CreateTime time.Time `db:"create_time"` // 创建时间
}

type SysRoleMenuModel

type SysRoleMenuModel interface {
	Count(ctx context.Context) (int64, error)
	FindAll(ctx context.Context, Current int64, PageSize int64) (*[]SysRoleMenu, error)
	DeleteByRoleId(ctx context.Context, RoleId int64) error
	FindByRoleId(ctx context.Context, RoleId int64) (*[]SysRoleMenu, error)
	// contains filtered or unexported methods
}

SysRoleMenuModel is an interface to be customized, add more methods here, and implement the added methods in customSysRoleMenuModel.

func NewSysRoleMenuModel

func NewSysRoleMenuModel(conn sqlx.SqlConn) SysRoleMenuModel

NewSysRoleMenuModel returns a model for the database table.

type SysRoleModel

type SysRoleModel interface {
	Count(ctx context.Context, in *sysclient.RoleListReq) (int64, error)
	FindAll(ctx context.Context, in *sysclient.RoleListReq) (*[]SysRole, error)
	DeleteByIds(ctx context.Context, ids []int64) error
	// contains filtered or unexported methods
}

SysRoleModel is an interface to be customized, add more methods here, and implement the added methods in customSysRoleModel.

func NewSysRoleModel

func NewSysRoleModel(conn sqlx.SqlConn) SysRoleModel

NewSysRoleModel returns a model for the database table.

type SysUser

type SysUser struct {
	Id         int64          `db:"id"`          // 编号
	Name       string         `db:"name"`        // 用户名
	NickName   sql.NullString `db:"nick_name"`   // 昵称
	Avatar     sql.NullString `db:"avatar"`      // 头像
	Password   string         `db:"password"`    // 密码
	Salt       string         `db:"salt"`        // 加密盐
	Email      sql.NullString `db:"email"`       // 邮箱
	Mobile     sql.NullString `db:"mobile"`      // 手机号
	Status     int64          `db:"status"`      // 状态  0：禁用   1：正常
	DeptId     int64          `db:"dept_id"`     // 机构ID
	CreateBy   string         `db:"create_by"`   // 创建人
	CreateTime time.Time      `db:"create_time"` // 创建时间
	UpdateBy   sql.NullString `db:"update_by"`   // 更新人
	UpdateTime sql.NullTime   `db:"update_time"` // 更新时间
	DelFlag    int64          `db:"del_flag"`    // 是否删除  -1：已删除  0：正常
	JobId      int64          `db:"job_id"`      // 岗位Id
}

type SysUserList

type SysUserList struct {
	Id         int64          `db:"id"`          // 编号
	Name       string         `db:"name"`        // 用户名
	NickName   sql.NullString `db:"nick_name"`   // 昵称
	Avatar     sql.NullString `db:"avatar"`      // 头像
	Password   string         `db:"password"`    // 密码
	Salt       string         `db:"salt"`        // 加密盐
	Email      sql.NullString `db:"email"`       // 邮箱
	Mobile     sql.NullString `db:"mobile"`      // 手机号
	Status     int64          `db:"status"`      // 状态  0：禁用   1：正常
	DeptId     int64          `db:"dept_id"`     // 机构ID
	CreateBy   string         `db:"create_by"`   // 创建人
	CreateTime time.Time      `db:"create_time"` // 创建时间
	UpdateBy   sql.NullString `db:"update_by"`   // 更新人
	UpdateTime sql.NullTime   `db:"update_time"` // 更新时间
	DelFlag    int64          `db:"del_flag"`    // 是否删除  -1：已删除  0：正常
	JobId      int64          `db:"job_id"`      // 岗位Id
	JobName    string         `db:"job_name"`
	DeptName   string         `db:"dept_name"`
	RoleName   string         `db:"role_name"`
	RoleId     int64          `db:"role_id"`
}

type SysUserModel

type SysUserModel interface {
	Count(ctx context.Context, in *sysclient.UserListReq) (int64, error)
	FindAll(ctx context.Context, in *sysclient.UserListReq) (*[]SysUserList, error)
	DeleteByIds(ctx context.Context, ids []int64) error
	// contains filtered or unexported methods
}

SysUserModel is an interface to be customized, add more methods here, and implement the added methods in customSysUserModel.

func NewSysUserModel

func NewSysUserModel(conn sqlx.SqlConn) SysUserModel

NewSysUserModel returns a model for the database table.

type SysUserRole

type SysUserRole struct {
	Id         int64     `db:"id"`          // 编号
	UserId     int64     `db:"user_id"`     // 用户ID
	RoleId     int64     `db:"role_id"`     // 角色ID
	CreateBy   string    `db:"create_by"`   // 创建人
	CreateTime time.Time `db:"create_time"` // 创建时间
}

type SysUserRoleModel

type SysUserRoleModel interface {
	Count(ctx context.Context) (int64, error)
	FindAll(ctx context.Context, Current int64, PageSize int64) (*[]SysUserRole, error)
	DeleteByUserId(ctx context.Context, UserId int64) error
	// contains filtered or unexported methods
}

SysUserRoleModel is an interface to be customized, add more methods here, and implement the added methods in customSysUserRoleModel.

func NewSysUserRoleModel

func NewSysUserRoleModel(conn sqlx.SqlConn) SysUserRoleModel

NewSysUserRoleModel returns a model for the database table.