package synchro
import (
"fmt"
"github.com/druidcaesa/gotool"
"time"
"ulink-admin/modules/system/models/model"
"ulink-admin/modules/system/models/req"
"ulink-admin/pkg/base"
)
func init() {
err := base.SqlDB.Sync2(
new(model.SysAttachment),
new(model.SysNotice),
new(model.SysOperLog),
new(model.SysRoleMenu),
//new(model.SysMember),
new(model.SysDept),
)
if err != nil {
fmt.Printf("数据库[sys_]前缀表批量同步出错:%s", err.Error())
}
}
func init() {
cfg := new(model.SysConfig)
err := base.SqlDB.Sync2(cfg)
if err != nil {
fmt.Printf("数据库表[%s]同步出错:%s", cfg.TableName(), err.Error())
} else {
empty, _ := base.SqlDB.IsTableEmpty(cfg)
if empty {
everyone := []model.SysConfig{
{Id: 1, ConfigName: "主框架页-默认皮肤样式名称", ConfigKey: "sys.index.skinName", ConfigValue: "skin-blue", ConfigType: "Y", CreateBy: "admin", CreateTime: time.Now(), Remark: "蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow"},
{Id: 2, ConfigName: "用户管理-账号初始密码", ConfigKey: "sys.user.initPassword", ConfigValue: "123456", ConfigType: "Y", CreateBy: "admin", CreateTime: time.Now(), Remark: "初始化密码 123456"},
{Id: 3, ConfigName: "主框架页-侧边栏主题", ConfigKey: "sys.index.sideTheme", ConfigValue: "theme-dark", ConfigType: "Y", CreateBy: "admin", CreateTime: time.Now(), Remark: "深色主题theme-dark，浅色主题theme-light"},
}
session := base.SqlDB.NewSession()
_ = session.Begin()
_, err = session.Table(cfg.TableName()).Insert(&everyone)
if err != nil {
fmt.Printf("数据库表[%s]插入默认数据出错:%s", cfg.TableName(), err.Error())
_ = session.Rollback()
}
_ = session.Commit()
}
}
}
func init() {
data := new(model.SysDictData)
err := base.SqlDB.Sync2(data)
if err != nil {
fmt.Printf("数据库表[%s]同步出错:%s", data.TableName(), err.Error())
} else {
empty, _ := base.SqlDB.IsTableEmpty(data)
if empty {
everyone := []model.SysDictData{
{
Id: 1,
DictSort: 1,
DictLabel: "男",
DictValue: "0",
DictType: "sys_user_sex",
IsDefault: "Y",
Status: 0,
Remark: "性别男",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2,
DictSort: 2,
DictLabel: "女",
DictValue: "1",
DictType: "sys_user_sex",
IsDefault: "N",
Status: 0,
Remark: "性别女",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 3,
DictSort: 3,
DictLabel: "未知",
DictValue: "2",
DictType: "sys_user_sex",
IsDefault: "N",
Status: 0,
Remark: "性别未知",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 4,
DictSort: 1,
DictLabel: "显示",
DictValue: "0",
DictType: "sys_show_hide",
IsDefault: "Y",
Status: 0,
Remark: "显示菜单",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 5,
DictSort: 2,
DictLabel: "隐藏",
DictValue: "1",
DictType: "sys_show_hide",
IsDefault: "N",
Status: 0,
Remark: "隐藏菜单",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 6,
DictSort: 1,
DictLabel: "正常",
DictValue: "0",
DictType: "sys_normal_disable",
IsDefault: "Y",
Status: 0,
Remark: "正常状态",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 7,
DictSort: 2,
DictLabel: "停用",
DictValue: "1",
DictType: "sys_normal_disable",
IsDefault: "N",
Status: 0,
Remark: "停用状态",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 8,
DictSort: 1,
DictLabel: "正常",
DictValue: "0",
DictType: "sys_job_status",
IsDefault: "Y",
Status: 0,
Remark: "正常状态",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 9,
DictSort: 2,
DictLabel: "暂停",
DictValue: "1",
DictType: "sys_job_status",
IsDefault: "N",
Status: 0,
Remark: "停用状态",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 10,
DictSort: 1,
DictLabel: "默认",
DictValue: "DEFAULT",
DictType: "sys_job_group",
IsDefault: "Y",
Status: 0,
Remark: "默认分组",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 11,
DictSort: 2,
DictLabel: "系统",
DictValue: "SYSTEM",
DictType: "sys_job_group",
IsDefault: "N",
Status: 0,
Remark: "系统分组",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 12,
DictSort: 1,
DictLabel: "是",
DictValue: "Y",
DictType: "sys_yes_no",
IsDefault: "Y",
Status: 0,
Remark: "系统默认是",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 13,
DictSort: 2,
DictLabel: "否",
DictValue: "N",
DictType: "sys_yes_no",
IsDefault: "N",
Status: 0,
Remark: "系统默认否",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 14,
DictSort: 1,
DictLabel: "通知",
DictValue: "1",
DictType: "sys_notice_type",
IsDefault: "Y",
Status: 0,
Remark: "通知",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 15,
DictSort: 2,
DictLabel: "公告",
DictValue: "2",
DictType: "sys_notice_type",
IsDefault: "N",
Status: 0,
Remark: "公告",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 16,
DictSort: 1,
DictLabel: "正常",
DictValue: "0",
DictType: "sys_notice_status",
IsDefault: "Y",
Status: 0,
Remark: "正常状态",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 17,
DictSort: 2,
DictLabel: "关闭",
DictValue: "1",
DictType: "sys_notice_status",
IsDefault: "N",
Status: 0,
Remark: "关闭状态",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 18,
DictSort: 1,
DictLabel: "新增",
DictValue: "1",
DictType: "sys_oper_type",
IsDefault: "N",
Status: 0,
Remark: "新增操作",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 19,
DictSort: 2,
DictLabel: "修改",
DictValue: "2",
DictType: "sys_oper_type",
IsDefault: "N",
Status: 0,
Remark: "修改操作",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 20,
DictSort: 3,
DictLabel: "删除",
DictValue: "3",
DictType: "sys_oper_type",
IsDefault: "N",
Status: 0,
Remark: "删除操作",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 21,
DictSort: 4,
DictLabel: "授权",
DictValue: "4",
DictType: "sys_oper_type",
IsDefault: "N",
Status: 0,
Remark: "授权操作",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 22,
DictSort: 5,
DictLabel: "导出",
DictValue: "5",
DictType: "sys_oper_type",
IsDefault: "N",
Status: 0,
Remark: "导出操作",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 23,
DictSort: 6,
DictLabel: "导入",
DictValue: "6",
DictType: "sys_oper_type",
IsDefault: "N",
Status: 0,
Remark: "导入操作",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 24,
DictSort: 7,
DictLabel: "强退",
DictValue: "7",
DictType: "sys_oper_type",
IsDefault: "N",
Status: 0,
Remark: "强退操作",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 25,
DictSort: 8,
DictLabel: "生成代码",
DictValue: "8",
DictType: "sys_oper_type",
IsDefault: "N",
Status: 0,
Remark: "生成操作",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 26,
DictSort: 9,
DictLabel: "清空数据",
DictValue: "9",
DictType: "sys_oper_type",
IsDefault: "N",
Status: 0,
Remark: "清空操作",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 27,
DictSort: 1,
DictLabel: "成功",
DictValue: "0",
DictType: "sys_common_status",
IsDefault: "N",
Status: 0,
Remark: "正常状态",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 28,
DictSort: 2,
DictLabel: "失败",
DictValue: "1",
DictType: "sys_common_status",
IsDefault: "N",
Status: 0,
Remark: "停用状态",
CreateTime: time.Now(),
CreateBy: "admin",
},
}
session := base.SqlDB.NewSession()
_ = session.Begin()
_, err = session.Table(data.TableName()).Insert(&everyone)
if err != nil {
fmt.Printf("数据库表[%s]插入默认数据出错:%s", data.TableName(), err.Error())
_ = session.Rollback()
}
_ = session.Commit()
}
}
}
func init() {
data := new(model.SysDictType)
err := base.SqlDB.Sync2(data)
if err != nil {
fmt.Printf("数据库表[%s]同步出错:%s", data.TableName(), err.Error())
} else {
empty, _ := base.SqlDB.IsTableEmpty(data)
if empty {
everyone := []model.SysDictType{
{
Id: 1,
DictName: "用户性别",
DictType: "sys_user_sex",
Status: 0,
Remark: "用户性别列表",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2,
DictName: "菜单状态",
DictType: "sys_show_hide",
Status: 0,
Remark: "菜单状态列表",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 3,
DictName: "系统开关",
DictType: "sys_normal_disable",
Status: 0,
Remark: "系统开关列表",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 4,
DictName: "任务状态",
DictType: "sys_job_status",
Status: 0,
Remark: "任务状态列表",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 5,
DictName: "任务分组",
DictType: "sys_job_group",
Status: 0,
Remark: "任务分组列表",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 6,
DictName: "系统是否",
DictType: "sys_yes_no",
Status: 0,
Remark: "系统是否列表",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 7,
DictName: "通知类型",
DictType: "sys_notice_type",
Status: 0,
Remark: "通知类型列表",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 8,
DictName: "通知状态",
DictType: "sys_notice_status",
Status: 0,
Remark: "通知状态列表",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 9,
DictName: "操作类型",
DictType: "sys_oper_type",
Status: 0,
Remark: "操作类型列表",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 10,
DictName: "系统状态",
DictType: "sys_common_status",
Status: 0,
Remark: "登录状态列表",
CreateTime: time.Now(),
CreateBy: "admin",
},
}
session := base.SqlDB.NewSession()
_ = session.Begin()
_, err = session.Table(data.TableName()).Insert(&everyone)
if err != nil {
fmt.Printf("数据库表[%s]插入默认数据出错:%s", data.TableName(), err.Error())
_ = session.Rollback()
}
_ = session.Commit()
}
}
}
func init() {
data := new(model.SysInfo)
err := base.SqlDB.Sync2(data)
if err != nil {
fmt.Printf("数据库表[%s]同步出错:%s", data.TableName(), err.Error())
} else {
empty, _ := base.SqlDB.IsTableEmpty(data)
if empty {
data = &model.SysInfo{
Id: 1,
Label: "智汇外卖系统",
Image: "",
IsDel: "0",
CreateBy: "admin",
UpdateBy: "admin",
CreateTime: time.Now(),
UpdateTime: time.Now(),
}
session := base.SqlDB.NewSession()
_ = session.Begin()
_, err = session.Table(data.TableName()).Insert(data)
if err != nil {
fmt.Printf("数据库表[%s]插入默认数据出错:%s", data.TableName(), err.Error())
_ = session.Rollback()
}
_ = session.Commit()
}
}
}
func init() {
data := new(model.SysMenu)
err := base.SqlDB.Sync2(data)
if err != nil {
fmt.Printf("数据库表[%s]同步出错:%s", data.TableName(), err.Error())
} else {
empty, _ := base.SqlDB.IsTableEmpty(data)
everyone := []model.SysMenu{
{
Id: 1,
ParentId: 0,
MenuName: "系统管理",
OrderNum: 99,
Path: "system",
MenuType: "M",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "",
Icon: "system",
Remark: "系统管理目录",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 100,
ParentId: 1,
MenuName: "员工管理",
OrderNum: 1,
Path: "user",
MenuType: "C",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:user:list",
Icon: "user",
Remark: "用户管理菜单",
Status: "0",
Component: "system/user/index",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 101,
ParentId: 1,
MenuName: "角色管理",
OrderNum: 2,
Path: "role",
MenuType: "C",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:role:list",
Icon: "peoples",
Remark: "角色管理菜单",
Status: "0",
Component: "system/role/index",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 102,
ParentId: 1,
MenuName: "菜单管理",
OrderNum: 3,
Path: "menu",
MenuType: "C",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:menu:list",
Icon: "tree-table",
Remark: "菜单管理菜单",
Status: "0",
Component: "system/menu/index",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 103,
ParentId: 1,
MenuName: "部门管理",
OrderNum: 4,
Path: "dept",
MenuType: "C",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:dept:list",
Icon: "tree",
Remark: "部门管理菜单",
Status: "0",
Component: "system/dept/index",
CreateBy: "系统生成",
},
{
Id: 105,
ParentId: 1,
MenuName: "字典管理",
OrderNum: 6,
Path: "dict",
MenuType: "C",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:dict:list",
Icon: "dict",
Remark: "字典管理菜单",
Status: "0",
Component: "system/dict/index",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 106,
ParentId: 1,
MenuName: "参数设置",
OrderNum: 7,
Path: "config",
MenuType: "C",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:config:list",
Icon: "edit",
Remark: "参数设置菜单",
Status: "0",
Component: "system/config/index",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 107,
ParentId: 1,
MenuName: "通知公告",
OrderNum: 8,
Path: "notice",
MenuType: "C",
Visible: false,
IsFrame: 1,
IsCache: 1,
Perms: "system:notice:list",
Icon: "message",
Remark: "通知公告菜单",
Status: "0",
Component: "system/notice/index",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1001,
ParentId: 100,
MenuName: "用户查询",
OrderNum: 1,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:user:list",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1002,
ParentId: 100,
MenuName: "用户新增",
OrderNum: 2,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:user:add",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1003,
ParentId: 100,
MenuName: "用户修改",
OrderNum: 3,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:user:edit",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1004,
ParentId: 100,
MenuName: "用户删除",
OrderNum: 4,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:user:remove",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1005,
ParentId: 100,
MenuName: "用户导出",
OrderNum: 5,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:user:export",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1006,
ParentId: 100,
MenuName: "用户导入",
OrderNum: 6,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:user:import",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1007,
ParentId: 100,
MenuName: "重置密码",
OrderNum: 7,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:user:resetPwd",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1008,
ParentId: 101,
MenuName: "角色查询",
OrderNum: 1,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:role:query",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1009,
ParentId: 101,
MenuName: "角色新增",
OrderNum: 2,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:role:add",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1010,
ParentId: 101,
MenuName: "角色修改",
OrderNum: 3,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:role:edit",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1011,
ParentId: 101,
MenuName: "角色删除",
OrderNum: 4,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:role:remove",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1012,
ParentId: 101,
MenuName: "角色导出",
OrderNum: 5,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:role:export",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1013,
ParentId: 102,
MenuName: "菜单查询",
OrderNum: 1,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:menu:query",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1014,
ParentId: 102,
MenuName: "菜单新增",
OrderNum: 2,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:menu:add",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1015,
ParentId: 102,
MenuName: "菜单修改",
OrderNum: 3,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:menu:edit",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1016,
ParentId: 102,
MenuName: "菜单删除",
OrderNum: 4,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:menu:remove",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1017,
ParentId: 103,
MenuName: "部门查询",
OrderNum: 1,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:dept:query",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateBy: "系统生成",
},
{
Id: 1018,
ParentId: 103,
MenuName: "部门新增",
OrderNum: 2,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:dept:add",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateBy: "系统生成",
},
{
Id: 1019,
ParentId: 103,
MenuName: "部门修改",
OrderNum: 3,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:dept:edit",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateBy: "系统生成",
},
{
Id: 1020,
ParentId: 103,
MenuName: "部门删除",
OrderNum: 4,
Path: "",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:dept:remove",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateBy: "系统生成",
},
{
Id: 1026,
ParentId: 105,
MenuName: "字典查询",
OrderNum: 1,
Path: "#",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:dict:query",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1027,
ParentId: 105,
MenuName: "字典新增",
OrderNum: 2,
Path: "#",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:dict:add",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1028,
ParentId: 105,
MenuName: "字典修改",
OrderNum: 3,
Path: "#",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:dict:edit",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1029,
ParentId: 105,
MenuName: "字典删除",
OrderNum: 4,
Path: "#",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:dict:remove",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1030,
ParentId: 105,
MenuName: "字典导出",
OrderNum: 5,
Path: "#",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:dict:export",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1031,
ParentId: 106,
MenuName: "参数查询",
OrderNum: 1,
Path: "#",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:config:query",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1032,
ParentId: 106,
MenuName: "参数新增",
OrderNum: 2,
Path: "#",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:config:add",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1033,
ParentId: 106,
MenuName: "参数修改",
OrderNum: 3,
Path: "#",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:config:edit",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1034,
ParentId: 106,
MenuName: "参数删除",
OrderNum: 4,
Path: "#",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:config:remove",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1035,
ParentId: 106,
MenuName: "参数导出",
OrderNum: 5,
Path: "#",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:config:export",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1036,
ParentId: 107,
MenuName: "公告查询",
OrderNum: 1,
Path: "#",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:notice:query",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1037,
ParentId: 107,
MenuName: "公告新增",
OrderNum: 2,
Path: "#",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:notice:add",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1038,
ParentId: 107,
MenuName: "公告修改",
OrderNum: 3,
Path: "#",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:notice:edit",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 1039,
ParentId: 107,
MenuName: "公告删除",
OrderNum: 4,
Path: "#",
MenuType: "F",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:notice:remove",
Icon: "#",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2000,
ParentId: 0,
MenuName: "工具管理",
OrderNum: 98,
Path: "tool",
MenuType: "M",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "",
Icon: "tool",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2001,
ParentId: 2000,
MenuName: "代码生成",
OrderNum: 1,
Path: "gen",
MenuType: "C",
Visible: true,
IsFrame: 1,
IsCache: 0,
Perms: "tool:gen:list",
Icon: "code",
Remark: "",
Status: "0",
Component: "tool/gen",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2003,
ParentId: 1,
MenuName: "日志管理",
OrderNum: 2,
Path: "log",
MenuType: "C",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:sysOperLog:list",
Icon: "bug",
Remark: "",
Status: "0",
Component: "system/sys-oper-log/index",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2147,
ParentId: 1,
MenuName: "会员列表",
OrderNum: 0,
Path: "sysMember",
MenuType: "C",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:sysMember:list",
Icon: "peoples",
Remark: "",
Status: "0",
Component: "system/sys-member/index",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2148,
ParentId: 2147,
MenuName: "查询",
OrderNum: 1,
Path: "sysMember/list:get",
MenuType: "F",
Visible: false,
IsFrame: 0,
IsCache: 0,
Perms: "system:sysMember:list",
Icon: "",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2149,
ParentId: 2147,
MenuName: "新增",
OrderNum: 2,
Path: "sysMember/list/add:post",
MenuType: "F",
Visible: false,
IsFrame: 0,
IsCache: 0,
Perms: "system:sysMember:add",
Icon: "",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2150,
ParentId: 2147,
MenuName: "修改",
OrderNum: 3,
Path: "sysMember/:put",
MenuType: "F",
Visible: false,
IsFrame: 0,
IsCache: 0,
Perms: "system:sysMember:edit",
Icon: "",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2151,
ParentId: 2147,
MenuName: "删除",
OrderNum: 4,
Path: "sysMember/:delete",
MenuType: "F",
Visible: false,
IsFrame: 0,
IsCache: 0,
Perms: "system:sysMember:remove",
Icon: "",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2152,
ParentId: 2147,
MenuName: "详情",
OrderNum: 5,
Path: "sysMember/list:detail;",
MenuType: "F",
Visible: false,
IsFrame: 0,
IsCache: 0,
Perms: "system:sysMember:detail",
Icon: "",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2153,
ParentId: 2147,
MenuName: "导出",
OrderNum: 6,
Path: "sysMember/list:export",
MenuType: "F",
Visible: false,
IsFrame: 0,
IsCache: 0,
Perms: "system:sysMember:export",
Icon: "",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2161,
ParentId: 1,
MenuName: "系统配置",
OrderNum: 0,
Path: "sysInfo",
MenuType: "C",
Visible: false,
IsFrame: 1,
IsCache: 0,
Perms: "system:sysInfo:list",
Icon: "server",
Remark: "",
Status: "0",
Component: "system/sys-info/index",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2162,
ParentId: 2161,
MenuName: "查询",
OrderNum: 1,
Path: "sysInfo/list:get",
MenuType: "F",
Visible: false,
IsFrame: 0,
IsCache: 0,
Perms: "system:sysInfo:list",
Icon: "",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2163,
ParentId: 2161,
MenuName: "新增",
OrderNum: 2,
Path: "sysInfo/list/add:post",
MenuType: "F",
Visible: false,
IsFrame: 0,
IsCache: 0,
Perms: "system:sysInfo:add",
Icon: "",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2164,
ParentId: 2161,
MenuName: "修改",
OrderNum: 3,
Path: "sysInfo/:put",
MenuType: "F",
Visible: false,
IsFrame: 0,
IsCache: 0,
Perms: "system:sysInfo:edit",
Icon: "",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2165,
ParentId: 2161,
MenuName: "删除",
OrderNum: 4,
Path: "sysInfo/:delete",
MenuType: "F",
Visible: false,
IsFrame: 0,
IsCache: 0,
Perms: "system:sysInfo:remove",
Icon: "",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2166,
ParentId: 2161,
MenuName: "详情",
OrderNum: 5,
Path: "sysInfo/list:detail;",
MenuType: "F",
Visible: false,
IsFrame: 0,
IsCache: 0,
Perms: "system:sysInfo:detail",
Icon: "",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
{
Id: 2167,
ParentId: 2161,
MenuName: "导出",
OrderNum: 6,
Path: "sysInfo/list:export",
MenuType: "F",
Visible: false,
IsFrame: 0,
IsCache: 0,
Perms: "system:sysInfo:export",
Icon: "",
Remark: "",
Status: "0",
Component: "",
CreateTime: time.Now(),
CreateBy: "admin",
},
}
if empty {
session := base.SqlDB.NewSession()
_ = session.Begin()
_, err = session.Table(data.TableName()).Insert(&everyone)
if err != nil {
fmt.Printf("数据库表[%s]插入默认数据出错:%s", data.TableName(), err.Error())
_ = session.Rollback()
}
_ = session.Commit()
} else {
list := make([]model.SysMenu, 0)
err = base.SqlDB.Table(data.TableName()).Asc("id").Find(&list)
if err != nil {
fmt.Printf("数据库表[%s]查询数据出错:%s", data.TableName(), err.Error())
} else {
addList := make([]model.SysMenu, 0)
/* for index, menu := range everyone {
if index < length {
sysMenu := list[index]
if menu.Id == sysMenu.Id && menu.IsDifferent(sysMenu) {
_, err = base.SqlDB.Table(menu.TableName()).ID(menu.Id).Update(menu)
if err != nil {
fmt.Printf("数据库表[%s]更新[Id=%v]的数据出错:%s", menu.TableName(), menu.Id, err.Error())
}
}
} else {
addList = append(addList, menu)
}
}*/
for _, newMenu := range everyone {
isHave := false
for _, oldMenu := range list {
if newMenu.Id == oldMenu.Id {
isHave = true
break
}
}
if !isHave {
addList = append(addList, newMenu)
}
}
if len(addList) > 0 {
session := base.SqlDB.NewSession()
_ = session.Begin()
fmt.Printf("model.SysMenu.addList:%+v\n", addList)
_, err = session.Table(data.TableName()).Insert(&addList)
if err != nil {
fmt.Printf("数据库表[%s]插入新增默认数据出错:%s", data.TableName(), err.Error())
_ = session.Rollback()
}
_ = session.Commit()
}
}
}
}
}
func init() {
user := new(model.SysUser)
err := base.SqlDB.Sync2(user)
if err != nil {
fmt.Printf("数据库表[%s]同步出错:%s", user.TableName(), err.Error())
} else {
empty, _ := base.SqlDB.IsTableEmpty(user)
if empty {
user.Id = 1
user.UserName = "admin"
user.NickName = "超级管理员"
user.UserType = req.SystemUserType
user.Sex = "0"
user.Avatar = "/defaultAvatar"
user.Password = gotool.BcryptUtils.Generate("admin123")
user.Status = "0"
user.DelFlag = "0"
user.NewVoucherFlag = "0"
user.CreateBy = user.UserName
user.UpdateBy = user.UserName
user.CreateTime = time.Now()
user.UpdateTime = time.Now()
session := base.SqlDB.NewSession()
_ = session.Begin()
_, err = session.Table(user.TableName()).
Cols("user_name", "nick_name", "user_type",
"sex", "avatar", "password", "status", "del_flag",
"new_voucher_flag", "create_by", "create_time").Insert(user)
if err != nil {
fmt.Printf("数据库表[%s]插入默认数据出错:%s", user.TableName(), err.Error())
_ = session.Rollback()
}
_ = session.Commit()
}
}
}
func init() {
role := new(model.SysRole)
err := base.SqlDB.Sync2(role)
if err != nil {
fmt.Printf("数据库表[%s]同步出错:%s", role.TableName(), err.Error())
} else {
empty, _ := base.SqlDB.IsTableEmpty(role)
if empty {
role.RoleName = "超级管理员"
role.RoleKey = "admin"
role.RoleSort = 1
role.DataScope = "1"
role.MenuCheckStrictly = true
role.DeptCheckStrictly = true
role.Status = "0"
role.DelFlag = "0"
role.CreateBy = role.RoleKey
role.UpdateBy = role.RoleKey
role.CreateTime = time.Now()
role.UpdateTime = time.Now()
role.Remark = role.RoleName
session := base.SqlDB.NewSession()
_ = session.Begin()
_, err = session.Table(role.TableName()).Insert(role)
if err != nil {
fmt.Printf("数据库表[%s]插入默认数据出错:%s", role.TableName(), err.Error())
_ = session.Rollback()
}
_ = session.Commit()
}
}
}
func init() {
userRole := new(model.SysUserRole)
err := base.SqlDB.Sync2(userRole)
if err != nil {
fmt.Printf("数据库表[%s]同步出错:%s", userRole.TableName(), err.Error())
} else {
empty, _ := base.SqlDB.IsTableEmpty(userRole)
if empty {
userRole.Id = 1
userRole.UserId = 1
userRole.RoleId = 1
session := base.SqlDB.NewSession()
_ = session.Begin()
_, err = session.Table(userRole.TableName()).Insert(userRole)
if err != nil {
fmt.Printf("数据库表[%s]插入默认数据出错:%s", userRole.TableName(), err.Error())
_ = session.Rollback()
}
_ = session.Commit()
}
}
}