代码拉取完成，页面将自动刷新
/*
Create Date: 2022-04-04
Update Date: 2022-04-06
Blog：https://gitee.com/dbkuaizi/tpamis
author: dbkuaizi
blog: https://www.dbkuaizi.com
Tpamis 项目的数据库初始化文件，要求数据库版本不低于 MySQL 5.7 / MariaDB 10.1
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for admin_log
-- ----------------------------
DROP TABLE IF EXISTS `admin_log`;
CREATE TABLE `admin_log` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`method` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请求方式',
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请求模块',
`uid` int(11) UNSIGNED NOT NULL COMMENT '操作用户',
`path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请求地址',
`ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请求ip',
`ua` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户代理',
`param` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '请求参数',
`function` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '调用方法',
`datetime` datetime NOT NULL COMMENT '操作时间',
`desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '请求描述',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_func`(`function`(250)) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of admin_log
-- ----------------------------
-- ----------------------------
-- Table structure for admin_menu
-- ----------------------------
DROP TABLE IF EXISTS `admin_menu`;
CREATE TABLE `admin_menu` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '菜单id',
`parent_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '父级菜单',
`label` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '菜单标题',
`type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '菜单类型 (menu\\link\\op)',
`icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '菜单图标',
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '菜单路由',
`path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '菜单地址',
`sort` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '菜单排序',
`visible` tinyint(1) NOT NULL COMMENT '是否可见',
`verify` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否校验',
`log` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '是否记录日志',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_time` datetime NOT NULL COMMENT '修改时间',
`delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '后端菜单表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of admin_menu
-- ----------------------------
INSERT INTO `admin_menu` VALUES (1, 0, '控制台', 'menu', 'ri-computer-line', '/view/index', '/com/get/index', 0, 0, 0, 0, '2021-12-22 21:36:52', '2021-12-26 00:18:39', NULL);
INSERT INTO `admin_menu` VALUES (2, 0, '系统管理', 'dir', 'ri-apps-line', '', '', 2, 0, 0, 0, '2021-12-23 23:01:53', '2022-01-21 00:41:25', NULL);
INSERT INTO `admin_menu` VALUES (3, 2, '组件管理', 'menu', 'ri-collage-fill', '/view/com', '/com/get/com_list', 0, 0, 1, 0, '2021-12-23 23:03:04', '2022-02-06 05:06:16', NULL);
INSERT INTO `admin_menu` VALUES (4, 1, '系统管理', 'menu', 'ri-apps-line', '', '', 0, 0, 1, 0, '2021-12-23 23:03:24', '2021-12-23 23:03:24', '2021-12-23 23:03:38');
INSERT INTO `admin_menu` VALUES (5, 2, '组件管理', 'menu', 'ri-collage-fill', '/sys/com', '/com/com_list', 0, 0, 1, 0, '2021-12-23 23:04:11', '2021-12-23 23:04:11', '2021-12-23 23:04:20');
INSERT INTO `admin_menu` VALUES (6, 0, 'AMIS 文档', 'link', 'ri-baidu-line', '', 'https://baidu.gitee.io/amis/zh-CN/components/index', 1, 0, 1, 0, '2021-12-25 01:14:06', '2022-02-06 05:03:08', NULL);
INSERT INTO `admin_menu` VALUES (7, 2, '字典管理', 'menu', 'ri-book-read-fill', '/view/map', '/com/get/com_map', 0, 0, 1, 0, '2021-12-25 01:33:34', '2021-12-25 17:55:45', NULL);
INSERT INTO `admin_menu` VALUES (8, 2, '组件管理 - 编辑', 'menu', '', '/view/com_save', '/com/get/com_save', 0, 2, 1, 0, '2021-12-25 01:34:34', '2021-12-26 00:50:55', NULL);
INSERT INTO `admin_menu` VALUES (9, 2, '接口管理', 'menu', 'ri-rocket-2-fill', '/view/api', '/com/get/admin_sqldata', 0, 0, 1, 0, '2021-12-25 02:06:53', '2022-02-06 05:05:15', NULL);
INSERT INTO `admin_menu` VALUES (10, 2, '菜单管理', 'menu', 'ri-list-check', '/view/menu', '/com/get/admin_menu', 0, 0, 1, 0, '2021-12-25 02:22:08', '2021-12-25 17:55:55', NULL);
INSERT INTO `admin_menu` VALUES (11, 2, '用户管理', 'menu', 'ri-admin-fill', '/view/admin_user', '/com/get/admin_user', 0, 0, 1, 0, '2021-12-25 15:44:48', '2021-12-25 17:55:59', NULL);
INSERT INTO `admin_menu` VALUES (12, 2, '角色管理', 'menu', 'ri-contacts-fill', '/view/admin_role', '/com/get/admin_role', 0, 0, 1, 0, '2021-12-25 15:47:34', '2021-12-26 00:06:36', NULL);
INSERT INTO `admin_menu` VALUES (13, 2, '操作日志', 'menu', 'ri-survey-line', '/view/sys_log', '/com/get/sys_log', 0, 0, 0, 0, '2021-12-29 00:02:04', '2022-01-21 00:39:28', NULL);
INSERT INTO `admin_menu` VALUES (14, 0, '基础权限', 'dir', '', '', '', 0, 2, 1, 0, '2022-02-01 20:32:51', '2022-02-04 06:25:21', NULL);
INSERT INTO `admin_menu` VALUES (15, 14, '个人信息', 'menu', '', '/view/user_info', '/com/get/sys_user_info', 0, 2, 1, 0, '2022-02-01 20:33:51', '2022-02-01 21:02:18', NULL);
INSERT INTO `admin_menu` VALUES (16, 14, '菜单', 'action', '', '', '/sys/menu', 0, 0, 0, 0, '2022-02-01 23:06:14', '2022-02-01 23:06:14', NULL);
INSERT INTO `admin_menu` VALUES (17, 14, '个人重置密码', 'action', '', '', '/admin_user/reset_pwd', 0, 2, 0, 1, '2022-02-02 01:46:07', '2022-02-07 00:53:55', NULL);
INSERT INTO `admin_menu` VALUES (18, 14, '获取个人信息', 'action', '', '', '/api/sys_user_info', 0, 0, 0, 0, '2022-02-03 00:56:00', '2022-02-03 00:56:00', NULL);
INSERT INTO `admin_menu` VALUES (19, 14, '通用上传', 'action', '', '', '/upload', 0, 0, 0, 0, '2022-02-04 06:25:43', '2022-02-04 06:25:43', NULL);
INSERT INTO `admin_menu` VALUES (20, 2, '文件管理', 'menu', 'ri-folder-2-fill', '/view/sys_upload', '/com/get/sys_upload', 9, 0, 1, 0, '2022-02-05 00:09:37', '2022-02-05 00:09:37', NULL);
INSERT INTO `admin_menu` VALUES (21, 11, '用户保存', 'action', '', '', '/admin_user/save', 0, 0, 1, 1, '2022-02-06 04:39:58', '2022-02-07 23:33:52', NULL);
INSERT INTO `admin_menu` VALUES (22, 12, '保存角色', 'action', '', '', '/save/admin_role_dialog', 0, 0, 1, 0, '2022-02-06 04:59:32', '2022-02-07 23:26:56', NULL);
INSERT INTO `admin_menu` VALUES (23, 12, '角色删除', 'action', '', '', '/api/admin_role_dialog/*', 0, 0, 1, 1, '2022-02-06 05:00:06', '2022-02-07 23:28:35', NULL);
INSERT INTO `admin_menu` VALUES (24, 10, '菜单保存', 'action', '', '', '/save/admin_menu_dialog', 0, 0, 1, 0, '2022-02-06 05:04:11', '2022-02-06 05:04:59', NULL);
INSERT INTO `admin_menu` VALUES (25, 10, '获取菜单列表', 'action', '', '', '/api/sys_menu', 0, 0, 1, 0, '2022-02-07 00:34:30', '2022-02-07 00:34:30', NULL);
INSERT INTO `admin_menu` VALUES (26, 14, '修改个人信息', 'action', '', '', '/admin_user/edit', 0, 0, 0, 1, '2022-02-07 00:55:47', '2022-02-07 00:55:47', NULL);
INSERT INTO `admin_menu` VALUES (27, 3, '获取组件列表', 'action', '', '', '/api/com_list', 0, 0, 1, 0, '2022-02-07 00:57:16', '2022-02-12 05:36:50', NULL);
INSERT INTO `admin_menu` VALUES (28, 8, '组件保存接口', 'action', '', '', '/save/com_save', 0, 0, 1, 1, '2022-02-07 00:58:16', '2022-02-07 23:22:04', NULL);
INSERT INTO `admin_menu` VALUES (29, 3, '获取组件数据表', 'action', '', '', '/api/sys_tables_option', 0, 0, 1, 0, '2022-02-07 00:58:54', '2022-02-07 00:58:54', NULL);
INSERT INTO `admin_menu` VALUES (30, 3, '获取组件字段列表', 'action', '', '', '/api/sys_table_column', 0, 0, 1, 0, '2022-02-07 00:59:52', '2022-02-07 00:59:52', NULL);
INSERT INTO `admin_menu` VALUES (31, 3, '组件删除', 'action', '', '', '/api/com_list/*', 0, 0, 1, 1, '2022-02-07 01:16:07', '2022-02-07 01:16:07', NULL);
INSERT INTO `admin_menu` VALUES (32, 7, '字典树获取', 'action', '', '', '/api/map_tree', 0, 0, 1, 0, '2022-02-07 22:00:50', '2022-02-07 22:00:50', NULL);
INSERT INTO `admin_menu` VALUES (33, 7, '字典列表获取', 'action', '', '', '/api/sys_map_list', 0, 0, 1, 0, '2022-02-07 22:01:27', '2022-02-07 22:01:27', NULL);
INSERT INTO `admin_menu` VALUES (34, 7, '字典排序修改', 'action', '', '', '/sort/com_map', 0, 0, 1, 1, '2022-02-07 22:13:56', '2022-02-07 23:22:38', NULL);
INSERT INTO `admin_menu` VALUES (35, 7, '字典保存权限', 'action', '', '', '/save/com_map', 0, 0, 1, 1, '2022-02-07 22:15:01', '2022-02-07 23:01:38', NULL);
INSERT INTO `admin_menu` VALUES (36, 8, '组件详情获取', 'action', '', '', '/api/com_save', 0, 0, 1, 0, '2022-02-07 22:59:19', '2022-02-07 23:01:04', NULL);
INSERT INTO `admin_menu` VALUES (37, 9, '获取接口列表', 'action', '', '', '/api/sqllist', 0, 0, 1, 0, '2022-02-07 23:04:21', '2022-02-07 23:04:21', NULL);
INSERT INTO `admin_menu` VALUES (38, 9, '接口保存', 'action', '', '', '/save/admin_sqldata_form', 0, 0, 1, 1, '2022-02-07 23:06:01', '2022-02-07 23:06:01', NULL);
INSERT INTO `admin_menu` VALUES (39, 9, '接口查询类型获取', 'action', '', '', '/api/curd_search_type_option', 0, 0, 0, 0, '2022-02-07 23:11:37', '2022-02-07 23:11:37', NULL);
INSERT INTO `admin_menu` VALUES (40, 9, '接口删除', 'action', '', '', '/api/admin_sqldata_form/*', 0, 0, 1, 1, '2022-02-07 23:12:56', '2022-02-07 23:23:33', NULL);
INSERT INTO `admin_menu` VALUES (41, 10, '菜单删除', 'action', '', '', '/api/admin_menu_dialog/*', 0, 0, 1, 0, '2022-02-07 23:14:52', '2022-02-07 23:14:52', NULL);
INSERT INTO `admin_menu` VALUES (42, 7, '字典删除', 'action', '', '', '/api/com_map/*', 0, 0, 1, 1, '2022-02-07 23:19:41', '2022-02-07 23:20:09', NULL);
INSERT INTO `admin_menu` VALUES (43, 3, '组件添加', 'action', '', '', '/save/com_add_dialog', 0, 0, 1, 1, '2022-02-07 23:21:41', '2022-02-07 23:21:41', NULL);
INSERT INTO `admin_menu` VALUES (44, 11, '用户列表获取', 'action', '', '', '/api/admin_user_list', 0, 0, 1, 0, '2022-02-07 23:24:54', '2022-02-07 23:24:54', NULL);
INSERT INTO `admin_menu` VALUES (45, 11, '用户删除', 'action', '', '', '/api/admin_user_dialog/*', 0, 0, 1, 1, '2022-02-07 23:25:48', '2022-02-07 23:25:48', NULL);
INSERT INTO `admin_menu` VALUES (46, 12, '角色列表获取', 'action', '', '', '/api/admin_role_list', 0, 0, 1, 0, '2022-02-07 23:26:35', '2022-02-07 23:26:35', NULL);
INSERT INTO `admin_menu` VALUES (47, 20, '文件列表获取', 'action', '', '', '/api/sys_upload_list', 0, 0, 1, 0, '2022-02-07 23:29:40', '2022-02-07 23:29:40', NULL);
INSERT INTO `admin_menu` VALUES (48, 13, '日志列表', 'action', '', '', '/api/admin_log_list', 0, 0, 1, 0, '2022-02-07 23:30:39', '2022-02-08 00:37:03', NULL);
INSERT INTO `admin_menu` VALUES (49, 11, '角色下拉', 'action', '', '', '/api/admin_role_option', 0, 0, 0, 0, '2022-02-07 23:31:46', '2022-02-07 23:31:46', NULL);
INSERT INTO `admin_menu` VALUES (50, 14, '退出登录', 'action', '', '', '/login/out', 0, 0, 0, 0, '2022-02-08 03:31:27', '2022-02-08 03:31:27', NULL);
-- ----------------------------
-- Table structure for admin_role
-- ----------------------------
DROP TABLE IF EXISTS `admin_role`;
CREATE TABLE `admin_role` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '角色主键',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '角色名称',
`status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '角色状态',
`permissions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色权限',
`desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '角色备注',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_time` datetime NOT NULL COMMENT '修改时间',
`delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '后台角色表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of admin_role
-- ----------------------------
INSERT INTO `admin_role` VALUES (1, '管理员', 1, '14,15,16,17,18,19,26,50,1,6,2,3,7,8,9,10,11,12,13,20,27,29,30,31,43,32,33,34,35,42,28,36,37,38,39,40,24,25,41,21,44,45,49,22,23,46,48,47', '管理员的权限', '2021-12-28 23:31:16', '2022-04-06 21:25:58', NULL);
INSERT INTO `admin_role` VALUES (2, '普通用户', 1, '1,32', '普通用户', '2021-12-29 20:58:19', '2022-04-06 21:24:00', NULL);
-- ----------------------------
-- Table structure for admin_user
-- ----------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
`id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户id',
`username` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名',
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户密码',
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户头像',
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '邮箱',
`phone` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '管理员手机号',
`status` tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '账号状态',
`super_admin` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否是超级管理员',
`roles` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户角色',
`login_time` datetime NOT NULL COMMENT '上次登录时间',
`login_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '上次登录ip',
`create_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL COMMENT '修改时间',
`delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_username`(`username`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '后端用户表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of admin_user
-- ----------------------------
INSERT INTO `admin_user` VALUES (1, 'admin', '$2y$10$L6bMXHawYx2vOQEWeCSg2OxCw58zMR8r9aBow.q9bZk6B4pt3dIpq', NULL, 'dbkuaizi@foxmail.com', '15330000000', 1, 1, '1', '2022-04-06 20:58:43', '127.0.0.1', '2022-04-06 21:05:56', '2022-04-06 21:00:48', NULL);
INSERT INTO `admin_user` VALUES (2, 'dbkuaizi', '$2y$10$yBu5fcLgMhicE2eObQ7kye0PjSu8IDLXXNopmIxySTd8lYtS9JlN6', NULL, '', '', 1, 0, '1', '2022-04-06 21:10:04', '127.0.0.1', '2022-04-06 21:10:04', '2022-04-06 21:10:05', NULL);
-- ----------------------------
-- Table structure for sys_api
-- ----------------------------
DROP TABLE IF EXISTS `sys_api`;
CREATE TABLE `sys_api` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'SQL编码',
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '接口名称',
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT 'list' COMMENT '数据类型',
`sql_string` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '数据SQL',
`sql_total` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '统计SQL',
`config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '接口配置',
`desc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '组件描述',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_time` datetime NOT NULL COMMENT '修改时间',
`delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '组件数据接口表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_api
-- ----------------------------
INSERT INTO `sys_api` VALUES (9, 'com_list', '组件列表', 'curd', 'SELECT temp_table.*,\r\n-- 获取父组件名称\r\nIF(parent_code <> \'\',(SELECT title FROM sys_com WHERE code = temp_table.parent_code),\'\') as parent_name,\r\nCONCAT(\'/com/get/\',code) as path\r\n FROM `sys_com` as temp_table WHERE delete_time IS NULL', '', '{\"curd\":{\"search\":[{\"field\":\"type\",\"type\":\"=\"},{\"field\":\"title\",\"type\":\"like\"},{\"field\":\"code\",\"type\":\"like\"},{\"field\":\"parent_code\",\"type\":\"like\"}]}}', '组件列表', '2021-08-24 18:06:26', '2022-07-18 23:42:36', NULL);
INSERT INTO `sys_api` VALUES (10, 'sqllist', '数据接口', 'curd', 'SELECT * FROM `sys_api` WHERE delete_time IS NULL', '', '{\"curd\":{\"jsonto\":\"config\",\"search\":[{\"field\":\"type\",\"type\":\"=\"},{\"field\":\"code\",\"type\":\"like\"},{\"field\":\"title\",\"type\":\"like\"}]}}', '数据接口', '2021-08-24 18:06:26', '2022-02-12 04:41:46', NULL);
INSERT INTO `sys_api` VALUES (11, 'com_save', '获取组件数据接口', 'find', 'SELECT * FROM sys_com WHERE id = {$Request.get.id}', NULL, NULL, '获取组件数据接口', '2021-08-24 18:06:26', '2021-08-24 18:06:26', NULL);
INSERT INTO `sys_api` VALUES (12, 'map_tree', '枚举字典树', 'tree', 'SELECT * FROM sys_map WHERE map_code = \'SysMapTree\' ORDER BY sort', '', '{\"tree\":{\"parent_key\":\"parent_val\",\"primary_key\":\"map_val\",\"list\":false}}', '枚举字典树', '2021-08-24 18:06:26', '2022-02-01 04:57:23', NULL);
INSERT INTO `sys_api` VALUES (13, 'sys_map_list', '系统枚举列表', 'curd', 'SELECT * FROM sys_map WHERE map_code = \'{$Request.get.map_tree}\' ORDER BY sort', NULL, '{\"curd\":{\"search\":[{\"field\":\"map_name\",\"type\":\"like\"},{\"field\":\"map_val\",\"type\":\"like\"},{\"field\":\"parent_val\",\"type\":\"like\"}]}}', '系统枚举列表', '2021-08-24 18:06:26', '2022-02-12 04:36:56', NULL);
INSERT INTO `sys_api` VALUES (15, 'admin_user_list', '后台用户列表', 'curd', '/* 为了安全考虑,用户查询不查询密码列 */\r\nSELECT id,username,phone,super_admin,login_time,login_ip,email,status,\r\n/* 查出角色数组 */\r\n(SELECT JSON_ARRAYAGG(name) FROM `admin_role` WHERE FIND_IN_SET(admin_role.id,admin_user.roles)) AS role_arr,\r\nadmin_user.roles \r\nFROM admin_user WHERE delete_time IS NULL', NULL, '{\"curd\":{\"jsonto\":\"role_arr\",\"search\":[{\"field\":\"username\",\"type\":\"like\"},{\"field\":\"phone\",\"type\":\"like\"},{\"field\":\"email\",\"type\":\"like\"}]}}', '后台用户列表', '2021-12-11 23:19:56', '2022-02-02 01:20:11', NULL);
INSERT INTO `sys_api` VALUES (17, 'sys_tables_option', '数据表动态下拉接口', 'option', 'SELECT TABLE_NAME as `label`,TABLE_NAME as `value` \r\nFROM information_schema.tables WHERE `TABLE_SCHEMA` in (select database())', NULL, NULL, '数据表动态下拉接口', '2021-12-19 02:10:03', '2022-02-12 06:28:20', NULL);
INSERT INTO `sys_api` VALUES (18, 'sys_table_column', '获取数据表字段', 'option', 'SELECT COLUMN_NAME as `label`,COLUMN_NAME as `value` FROM information_schema.`COLUMNS` WHERE `TABLE_SCHEMA` in (select database()) AND FIND_IN_SET(TABLE_NAME,\'{$Request.get.tables}\')', NULL, NULL, '根据传递的表名称获取该表的数据', '2021-12-19 02:32:27', '2021-12-21 22:03:10', NULL);
INSERT INTO `sys_api` VALUES (19, 'sys_menu', '菜单列表接口', 'tree', 'SELECT * FROM admin_menu WHERE delete_time IS NULL ORDER BY sort', NULL, '{\"tree\":{\"list\":true,\"primary_key\":\"id\",\"parent_key\":\"parent_id\"}}', '后台菜单列表', '2021-12-23 21:37:29', '2021-12-28 23:29:58', NULL);
INSERT INTO `sys_api` VALUES (20, 'admin_role_list', '管理员角色列表接口', 'curd', 'SELECT * FROM admin_role WHERE delete_time IS NULL', NULL, '{\"curd\":{\"search\":[{\"field\":\"name\",\"type\":\"like\"},{\"field\":\"status\",\"type\":\"=\"}]}}', '管理员角色列表接口', '2021-12-28 22:48:43', '2022-01-02 01:25:56', NULL);
INSERT INTO `sys_api` VALUES (21, 'admin_role_option', '角色选项接口', 'option', 'SELECT `name` as label,id as `value`, !status as disabled FROM admin_role WHERE delete_time IS NULL', NULL, NULL, '角色选项接口', '2021-12-29 22:22:24', '2021-12-29 22:24:05', NULL);
INSERT INTO `sys_api` VALUES (22, 'curd_search_type_option', '接口CURD查询字段类型', 'option', 'SELECT map_name as label,map_val as `value`,map_desc FROM sys_map WHERE map_code = \'ApiCurdSearchType\' order by sort', NULL, NULL, '接口CURD查询字段类型下拉选项', '2022-01-02 16:21:43', '2022-01-02 16:25:02', NULL);
INSERT INTO `sys_api` VALUES (23, 'sys_user_info', '当前用户信息', 'find', 'SELECT id,username,email,phone,super_admin,login_time,login_ip,\r\n-- 用户角色\r\n(SELECT GROUP_CONCAT(name) FROM `admin_role` WHERE FIND_IN_SET(admin_role.id,admin_user.roles)) AS role_arr,\r\n-- 如果用户头像为空就使用缺省头像\r\nIFNULL(avatar,\'/avatar.jpg\') as avatar \r\nFROM admin_user WHERE id = {$Request.session.admin_uid}', NULL, NULL, '获取当前登录用户的信息', '2022-02-03 00:30:16', '2022-04-04 01:03:02', NULL);
INSERT INTO `sys_api` VALUES (24, 'sys_upload_list', '附件管理列表', 'curd', 'SELECT sys_upload.type,sys_upload.mime,sys_upload.md5,sys_upload.path,sys_upload.name,\r\nsys_upload.upload_time,sys_upload.upload_url,\r\n-- 四舍五入 算kb\r\nROUND(sys_upload.size/1024,2) as size,admin_user.username\r\nFROM sys_upload \r\nLEFT JOIN admin_user ON sys_upload.uid = admin_user.id ', NULL, '{\"curd\":{\"search\":[{\"field\":\"type\",\"type\":\"=\"},{\"field\":\"mime\",\"type\":\"like\"},{\"field\":\"username\",\"type\":\"like\"},{\"field\":\"upload_time\",\"type\":\"between\"}]}}', '附件管理页面列表接口', '2022-02-05 01:40:43', '2022-02-08 02:02:33', NULL);
INSERT INTO `sys_api` VALUES (25, 'admin_log_list', '操作日志获取接口', 'curd', 'SELECT admin_log.*,admin_user.username FROM admin_log \r\nLEFT JOIN admin_user ON admin_log.uid = admin_user.id \r\nWHERE [curd_where]\r\nORDER BY `datetime` DESC', NULL, '{\"curd\":{\"search\":[{\"field\":\"method\",\"type\":\"=\"},{\"field\":\"title\",\"type\":\"like\"},{\"field\":\"username\",\"type\":\"like\"},{\"field\":\"path\",\"type\":\"like\"},{\"field\":\"ip\",\"type\":\"=\"},{\"field\":\"datetime\",\"type\":\"between\"}]}}', NULL, '2022-02-08 00:36:36', '2022-02-08 02:47:36', NULL);
-- ----------------------------
-- Table structure for sys_com
-- ----------------------------
DROP TABLE IF EXISTS `sys_com`;
CREATE TABLE `sys_com` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '组件编码',
`parent_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '父组件编码',
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '组件标题',
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'page' COMMENT '组件类型',
`tables` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '组件操作表',
`pri_field` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '操作字段',
`body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '组件Body体',
`desc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '组件描述',
`create_time` datetime NOT NULL COMMENT '创建时间',
`update_time` datetime NOT NULL COMMENT '修改时间',
`delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '组件实例表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_com
-- ----------------------------
INSERT INTO `sys_com` VALUES (1, 'index', '', '后台首页', 'page', '', '', '{\r\n \"type\": \"page\",\r\n \"body\": [\r\n {com:slot code=\"admin_index_grid\" /},\r\n {\r\n \"type\": \"grid\",\r\n \"columns\": [\r\n {\r\n \"type\": \"panel\",\r\n \"title\": \"本地配置示例 支持交互\",\r\n \"name\": \"chart-local\",\r\n \"body\": [\r\n {\r\n \"type\": \"chart\",\r\n \"config\": {\r\n \"title\": {\r\n \"text\": \"极坐标双数值轴\"\r\n },\r\n \"legend\": {\r\n \"data\": [\r\n \"line\"\r\n ]\r\n },\r\n \"polar\": {\r\n \"center\": [\r\n \"50%\",\r\n \"54%\"\r\n ]\r\n },\r\n \"tooltip\": {\r\n \"trigger\": \"axis\",\r\n \"axisPointer\": {\r\n \"type\": \"cross\"\r\n }\r\n },\r\n \"angleAxis\": {\r\n \"type\": \"value\",\r\n \"startAngle\": 0\r\n },\r\n \"radiusAxis\": {\r\n \"min\": 0\r\n },\r\n \"series\": [\r\n {\r\n \"coordinateSystem\": \"polar\",\r\n \"name\": \"line\",\r\n \"type\": \"line\",\r\n \"showSymbol\": false,\r\n \"data\": [\r\n [\r\n 0,\r\n 0\r\n ],\r\n [\r\n 0.03487823687206265,\r\n 1\r\n ],\r\n [\r\n 0.06958655048003272,\r\n 2\r\n ],\r\n [\r\n 0.10395584540887964,\r\n 3\r\n ],\r\n [\r\n 0.13781867790849958,\r\n 4\r\n ],\r\n [\r\n 0.17101007166283433,\r\n 5\r\n ],\r\n [\r\n 0.2033683215379001,\r\n 6\r\n ],\r\n [\r\n 0.2347357813929454,\r\n 7\r\n ],\r\n [\r\n 0.26495963211660245,\r\n 8\r\n ],\r\n [\r\n 0.2938926261462365,\r\n 9\r\n ],\r\n [\r\n 0.3213938048432697,\r\n 10\r\n ]\r\n ]\r\n }\r\n ],\r\n \"animationDuration\": 2000\r\n },\r\n \"clickAction\": {\r\n \"actionType\": \"dialog\",\r\n \"dialog\": {\r\n \"title\": \"详情\",\r\n \"body\": [\r\n {\r\n \"type\": \"tpl\",\r\n \"tpl\": \"<span>当前选中值 ${value|json}<span>\"\r\n },\r\n {\r\n \"type\": \"chart\",\r\n \"api\": \"https://3xsw4ap8wah59.cfc-execute.bj.baidubce.com/api/amis-mock/mock2/chart/chart1\"\r\n }\r\n ]\r\n }\r\n }\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"panel\",\r\n \"title\": \"远程图表示例(返回值带function)\",\r\n \"name\": \"chart-remote\",\r\n \"body\": [\r\n {\r\n \"type\": \"chart\",\r\n \"api\": \"https://3xsw4ap8wah59.cfc-execute.bj.baidubce.com/api/amis-mock/mock2/chart/chart1\"\r\n }\r\n ]\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"panel\",\r\n \"title\": \"Form+chart组合\",\r\n \"body\": [\r\n {\r\n \"type\": \"form\",\r\n \"title\": \"过滤条件\",\r\n \"target\": \"chart1,chart2\",\r\n \"submitOnInit\": true,\r\n \"className\": \"m-b\",\r\n \"wrapWithPanel\": false,\r\n \"mode\": \"inline\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-date\",\r\n \"label\": \"开始日期\",\r\n \"name\": \"starttime\",\r\n \"value\": \"-8days\",\r\n \"maxDate\": \"${endtime}\"\r\n },\r\n {\r\n \"type\": \"input-date\",\r\n \"label\": \"结束日期\",\r\n \"name\": \"endtime\",\r\n \"value\": \"-1days\",\r\n \"minDate\": \"${starttime}\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"label\": \"条件\",\r\n \"name\": \"name\",\r\n \"addOn\": {\r\n \"type\": \"submit\",\r\n \"label\": \"搜索\",\r\n \"visible\": {com:auth path=\"/api/com_list\"\r\n },\r\n \"level\": \"primary\"\r\n }\r\n }\r\n ],\r\n \"actions\": []\r\n },\r\n {\r\n \"type\": \"divider\"\r\n },\r\n {\r\n \"type\": \"grid\",\r\n \"className\": \"m-t-lg\",\r\n \"columns\": [\r\n {\r\n \"type\": \"chart\",\r\n \"name\": \"chart1\",\r\n \"initFetch\": false,\r\n \"api\": \"https://3xsw4ap8wah59.cfc-execute.bj.baidubce.com/api/amis-mock/mock2/chart/chart?name=$name&starttime=${starttime}&endtime=${endtime}\"\r\n },\r\n {\r\n \"type\": \"chart\",\r\n \"name\": \"chart2\",\r\n \"initFetch\": false,\r\n \"api\": \"https://3xsw4ap8wah59.cfc-execute.bj.baidubce.com/api/amis-mock/mock2/chart/chart2?name=$name\"\r\n }\r\n ]\r\n }\r\n ]\r\n }\r\n ]\r\n}', '后台首页 [不可删除]', '2021-11-14 22:56:22', '2022-02-12 05:58:44', NULL);
INSERT INTO `sys_com` VALUES (2, 'sys_com_empty', 'sys_com', '页面不存在', 'page', '', '', '{\r\n \"type\": \"alert\",\r\n \"body\": \"[code] 组件不存在\",\r\n \"level\": \"warning\",\r\n \"showIcon\": true,\r\n \"className\": \"m-3\"\r\n}', '当访问的组件不存在时，将显示当前组件 [不可删除]', '2021-11-14 22:56:22', '2021-12-13 22:50:40', NULL);
INSERT INTO `sys_com` VALUES (3, 'com_list', '', '组件列表', 'page', 'sys_com', 'id', '{\r\n \"type\": \"page\",\r\n \"body\": {\r\n \"type\": \"crud\",\r\n \"api\": \"/api/com_list\",\r\n \"name\": \"crud_com\",\r\n \"syncLocation\": false,\r\n \"className\": \"h-full\",\r\n \"perPageAvailable\": {com:pageSize /},\r\n \"perPage\": {com:page /},\r\n \"filter\": {\r\n \"title\": \"组件查询\",\r\n \"submitText\": \"\",\r\n \"mode\": \"inline\",\r\n \"body\": [\r\n {\r\n \"type\": \"select\",\r\n \"name\": \"type\",\r\n \"label\": \"组件类型\",\r\n \"size\":\"sm\",\r\n \"clearable\": true,\r\n \"options\": {map:option code=\"SysComMap\"}\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"title\",\r\n \"size\": \"sm\",\r\n \"label\": \"组件名称\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"code\",\r\n \"size\": \"sm\",\r\n \"label\": \"组件编码：\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"parent_code\",\r\n \"size\": \"sm\",\r\n \"label\": \"父组件编码：\"\r\n },\r\n {\r\n \"label\": \"搜索\",\r\n \"type\": \"submit\"\r\n }\r\n ]\r\n },\r\n \"filterDefaultVisible\":false,\r\n \"filterTogglable\": true,\r\n \"headerToolbar\": [\r\n {\r\n \"label\": \"添加页面\",\r\n \"type\": \"button\",\r\n \"level\": \"primary\",\r\n \"actionType\": \"dialog\",\r\n \"dialog\": {com:slot code=\"com_add_dialog\" /\r\n }\r\n },\r\n {\r\n \"type\": \"columns-toggler\",\r\n \"align\": \"right\"\r\n },\r\n {\r\n \"type\":\"filter-toggler\",\r\n \"align\":\"right\"\r\n }\r\n ],\r\n \"footerToolbar\": [\r\n \"statistics\",\r\n \"switch-per-page\",\r\n \"pagination\"\r\n ],\r\n \"columns\": [\r\n {\r\n \"name\": \"id\",\r\n \"label\": \"ID\",\r\n \"width\": 50\r\n },\r\n {\r\n \"name\": \"type\",\r\n \"label\": \"组件类型\",\r\n \"width\": 70,\r\n \"type\": \"mapping\",\r\n \"map\": {map:colnum code=\"SysComMap\" field=\"map_val2\" key=\"map_val\" /\r\n }\r\n },\r\n {\r\n \"name\": \"parent_code\",\r\n \"label\": \"父组件编码\",\r\n \"width\": 150\r\n },\r\n {\r\n \"name\": \"parent_name\",\r\n \"label\": \"父组件名称\",\r\n \"width\": 200\r\n },\r\n {\r\n \"name\": \"code\",\r\n \"label\": \"组件编码\",\r\n \"width\": 150\r\n },\r\n {\r\n \"name\": \"title\",\r\n \"label\": \"组件名称\",\r\n \"width\": 200\r\n },\r\n {\r\n \"name\": \"desc\",\r\n \"label\": \"组件描述\"\r\n },\r\n {\r\n \"type\": \"operation\",\r\n \"label\": \"操作\",\r\n \"align\": \"right\",\r\n \"width\": 150,\r\n \"buttons\": [\r\n {\r\n \"label\": \"添加子组件\",\r\n \"hiddenOn\": \"this.parent_code != \'\'\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"dialog\",\r\n \"dialog\": {com:slot code=\"com_add_dialog\" type=\"sub\" /\r\n }\r\n },\r\n {\r\n \"label\": \"编辑\",\r\n \"level\": \"primary\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"link\",\r\n \"link\": \"/view/com_save?id=${id}\"\r\n },\r\n {\r\n \"label\": \"删除\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"ajax\",\r\n \"title\": \"确认操作\",\r\n \"level\": \"danger\",\r\n \"confirmText\": \"确认要删除 ${code} ？\",\r\n \"api\": \"delete:/api/com_list/${id}\"\r\n }\r\n ]\r\n }\r\n ]\r\n }\r\n}', '组件管理', '2021-11-14 22:56:22', '2022-02-12 04:25:36', NULL);
INSERT INTO `sys_com` VALUES (4, 'admin_menu', '', '菜单管理', 'page', 'admin_menu', 'id', '{\r\n \"type\": \"page\",\r\n \"body\": {\r\n \"type\": \"crud\",\r\n \"name\": \"admin_menu\",\r\n \"filterTogglable\": true,\r\n \"syncLocation\": false,\r\n \"filterDefaultVisible\": false,\r\n \"headerToolbar\": [\r\n {\r\n \"label\": \"添加菜单\",\r\n \"type\": \"button\",\r\n \"level\": \"primary\",\r\n \"actionType\": \"dialog\",\r\n \"dialog\": {com:slot code=\"admin_menu_dialog\" type=\"add\"/\r\n }\r\n },\r\n {\r\n \"type\": \"columns-toggler\",\r\n \"align\": \"right\"\r\n },\r\n {\r\n \"type\": \"reload\",\r\n \"align\": \"right\"\r\n }\r\n ],\r\n \"footerToolbar\": [],\r\n \"api\": {\r\n \"method\":\"get\",\r\n \"url\":\"/api/sys_menu\",\r\n \"data\": {\r\n \"response_key\": \"items\"\r\n }\r\n },\r\n \"columns\": [\r\n {\r\n \"name\": \"id\",\r\n \"label\": \"ID\"\r\n },\r\n {\r\n \"label\": \"图标\",\r\n \"width\": 50,\r\n \"type\": \"tpl\",\r\n \"align\":\"center\",\r\n \"tpl\":\"<i class=\'text-base ${icon}\'> </i>\"\r\n },\r\n {\r\n \"name\": \"label\",\r\n \"label\": \"菜单名称\"\r\n },\r\n {\r\n \"name\": \"url\",\r\n \"label\": \"路由地址\"\r\n },\r\n {\r\n \"name\": \"path\",\r\n \"label\": \"路径\"\r\n },\r\n {\r\n \"name\": \"sort\",\r\n \"label\": \"排序\",\r\n \"width\": 50\r\n },\r\n {\r\n \"name\": \"visible\",\r\n \"label\": \"显示\",\r\n \"type\": \"mapping\",\r\n \"map\": {map:colnum code=\"SysMenuVisible\" field=\"map_name\" key=\"map_val\" /\r\n },\r\n \"width\": 80\r\n },\r\n {\r\n \"name\": \"verify\",\r\n \"label\": \"是否校验\",\r\n \"width\": 80,\r\n \"type\": \"mapping\",\r\n \"map\": {map:colnum code=\"SysMenuVerify\" field=\"map_val2\" key=\"map_val\" /\r\n }\r\n },\r\n {\r\n \"name\": \"type\",\r\n \"label\": \"菜单类型\",\r\n \"width\": 80,\r\n \"type\": \"mapping\",\r\n \"map\": {map:colnum code=\"SysMenuType\" field=\"map_val2\" key=\"map_val\" /\r\n }\r\n },\r\n {\r\n \"name\": \"create_time\",\r\n \"label\": \"创建时间\",\r\n \"width\": 130\r\n },\r\n {\r\n \"type\": \"operation\",\r\n \"label\": \"操作\",\r\n \"align\": \"right\",\r\n \"width\": 150,\r\n \"buttons\": [\r\n {\r\n \"label\": \"添加\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"dialog\",\r\n \"dialog\": {com:slot code=\"admin_menu_dialog\" type=\"add\"/\r\n }\r\n },\r\n {\r\n \"label\": \"编辑\",\r\n \"level\": \"primary\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"dialog\",\r\n \"dialog\": {com:slot code=\"admin_menu_dialog\" type=\"edit\"/\r\n }\r\n },\r\n {\r\n \"label\": \"删除\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"ajax\",\r\n \"title\": \"确认操作\",\r\n \"level\": \"danger\",\r\n \"confirmText\": \"确认要删除 ${code} ？\",\r\n \"api\": \"delete:/api/{$code}/${id}\"\r\n }\r\n ]\r\n }\r\n ]\r\n }\r\n}', '菜单管理页面', '2021-11-14 22:56:22', '2022-02-05 00:26:44', NULL);
INSERT INTO `sys_com` VALUES (5, 'admin_sqldata', '', '数据接口管理', 'page', 'sys_api', 'id', '{\r\n \"type\": \"page\",\r\n \"body\": {\r\n \"type\": \"crud\",\r\n \"api\": \"/api/sqllist\",\r\n \"name\": \"crud_com\",\r\n \"syncLocation\": false,\r\n \"affixHeader\": false,\r\n \"className\": \"h-full\",\r\n \"perPageAvailable\": {com:pageSize /\r\n },\r\n \"perPage\": {com:page /\r\n },\r\n \"filter\": {\r\n \"title\": \"接口查询\",\r\n \"submitText\": \"\",\r\n \"mode\": \"inline\",\r\n \"body\": [\r\n {\r\n \"type\": \"select\",\r\n \"name\": \"type\",\r\n \"label\": \"接口类型\",\r\n \"size\": \"sm\",\r\n \"clearable\": true,\r\n \"options\": {map:option code=\"SysApiType\"\r\n }\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"title\",\r\n \"size\": \"sm\",\r\n \"label\": \"接口名称\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"code\",\r\n \"size\": \"sm\",\r\n \"label\": \"接口编码\"\r\n },\r\n {\r\n \"label\": \"搜索\",\r\n \"type\": \"submit\"\r\n }\r\n ]\r\n },\r\n \"filterDefaultVisible\": false,\r\n \"filterTogglable\": true,\r\n \"headerToolbar\": [\r\n {\r\n \"label\": \"新接口\",\r\n \"type\": \"button\",\r\n \"actionType\": \"dialog\",\r\n \"level\": \"primary\",\r\n \"dialog\": {com:slot code=\"admin_sqldata_form\" /\r\n }\r\n },\r\n {\r\n \"type\": \"columns-toggler\",\r\n \"align\": \"right\"\r\n },\r\n {\r\n \"type\": \"filter-toggler\",\r\n \"align\": \"right\"\r\n }\r\n ],\r\n \"footerToolbar\": [\r\n \"switch-per-page\",\r\n \"pagination\"\r\n ],\r\n \"columns\": [\r\n {\r\n \"name\": \"id\",\r\n \"width\": 70,\r\n \"label\": \"ID\"\r\n },\r\n {\r\n \"name\": \"type\",\r\n \"label\": \"接口类型\",\r\n \"width\": 70,\r\n \"type\": \"mapping\",\r\n \"map\": {map:colnum code=\"SysApiType\" field=\"map_name\" key=\"map_val\" /\r\n }\r\n },\r\n {\r\n \"name\": \"code\",\r\n \"label\": \"接口编码\",\r\n \"width\": 180\r\n },\r\n {\r\n \"name\": \"title\",\r\n \"label\": \"接口名称\",\r\n \"width\": 180\r\n },\r\n {\r\n \"name\": \"desc\",\r\n \"label\": \"接口描述\"\r\n },\r\n {\r\n \"type\": \"operation\",\r\n \"label\": \"操作\",\r\n \"width\": 100,\r\n \"buttons\": [\r\n {\r\n \"label\": \"修改\",\r\n \"level\": \"primary\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"dialog\",\r\n \"dialog\": {com:slot code=\"admin_sqldata_form\" /\r\n }\r\n },\r\n {\r\n \"label\": \"删除\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"ajax\",\r\n \"title\": \"确认操作\",\r\n \"level\": \"danger\",\r\n \"confirmText\": \"确认要删除 ${code} ？\",\r\n \"api\": \"delete:/api/{$code}/${id}\"\r\n }\r\n ]\r\n }\r\n ]\r\n }\r\n}', '数据接口管理', '2021-11-14 22:56:22', '2022-02-12 04:42:07', NULL);
INSERT INTO `sys_com` VALUES (6, 'admin_sqldata_form', 'admin_sqldata', '接口管理表单', 'form', 'sys_api', 'id', '{\r\n \"title\": false,\r\n \"size\": \"lg\",\r\n \"body\": {\r\n \"type\": \"form\",\r\n \"reload\": \"crud_com\",\r\n \"mode\": \"horizontal\",\r\n \"horizontal\": {\r\n \"left\": 1\r\n },\r\n \"api\": \"post:/save/{$code}\",\r\n \"data\": {\r\n \"id\": \"${id}\"\r\n },\r\n \"body\": [\r\n {\r\n \"type\": \"fieldSet\",\r\n \"title\": \"基本配置\",\r\n \"body\": [\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"code\",\r\n \"required\": true,\r\n \"label\": \"接口编码\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"title\",\r\n \"required\": true,\r\n \"label\": \"接口名称\"\r\n },\r\n {\r\n \"type\": \"button-group-select\",\r\n \"name\": \"type\",\r\n \"label\": \"接口类型\",\r\n \"required\": true,\r\n \"options\": {map:option code=\"SysApiType\" /\r\n }\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"textarea\",\r\n \"name\": \"desc\",\r\n \"label\": \"接口描述\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"fieldSet\",\r\n \"hiddenOn\":\"this.type != \'curd\'\",\r\n \"title\": \"CURD 配置\",\r\n \"body\": [\r\n {\r\n \"name\": \"config.curd.jsonto\",\r\n \"type\": \"input-tag\",\r\n \"label\": \"JSON 转换\",\r\n \"description\": \"接口返回数据时将指定字段使用 JSON_DECODE() 转换，输入后 Enter\"\r\n },\r\n {\r\n \"type\": \"combo\",\r\n \"name\": \"config.curd.search\",\r\n \"label\": \"查询条件\",\r\n \"description\": \"构建查询条件关键字，多个字段使用 AND 拼接\",\r\n \"multiple\": true,\r\n \"items\": [\r\n {\r\n \"name\": \"field\",\r\n \"label\": \"查询字段\",\r\n \"type\": \"input-text\"\r\n },\r\n {\r\n \"name\": \"type\",\r\n \"label\": \"查询类型\",\r\n \"type\": \"select\",\r\n \"selectMode\": \"table\",\r\n \"columns\": [\r\n {\r\n \"name\": \"label\",\r\n \"label\": \"名称\",\r\n \"width\":100\r\n },\r\n {\r\n \"name\": \"map_desc\",\r\n \"label\": \"语法\"\r\n }\r\n ],\r\n \"source\": \"/api/curd_search_type_option\"\r\n }\r\n ]\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"fieldSet\",\r\n \"hiddenOn\": \"this.type != \'tree\'\",\r\n \"title\": \"Tree 配置\",\r\n \"body\": [\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"name\": \"config.tree.parent_key\",\r\n \"type\": \"input-text\",\r\n \"label\": \"父节点字段\",\r\n \"requiredOn\": \"this.type === \'tree\'\",\r\n \"description\":\"组装树形结构的父节点字段\"\r\n },\r\n {\r\n \"name\": \"config.tree.primary_key\",\r\n \"type\": \"input-text\",\r\n \"label\": \"子节点字段\",\r\n \"requiredOn\": \"this.type === \'tree\'\",\r\n \"description\": \"组装树形结构的子节点字段\"\r\n },\r\n {\r\n }\r\n ]\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"fieldSet\",\r\n \"title\": \"查询SQL\",\r\n \"body\": [\r\n {\r\n \"type\": \"editor\",\r\n \"language\": \"sql\",\r\n \"name\": \"sql_string\",\r\n \"allowFullscreen\": true,\r\n \"size\": \"xxl\",\r\n \"label\": \"查询SQL\"\r\n },\r\n {\r\n \"type\": \"editor\",\r\n \"language\": \"sql\",\r\n \"name\": \"sql_total\",\r\n \"hiddenOn\": \"this.type != \'curd\'\",\r\n \"allowFullscreen\": true,\r\n \"size\": \"sm\",\r\n \"label\": \"统计SQL\"\r\n }\r\n ]\r\n }\r\n ]\r\n }\r\n}', '接口管理表单', '2021-11-14 22:56:22', '2022-02-12 06:20:42', NULL);
INSERT INTO `sys_com` VALUES (7, 'com_map', '', '系统组件_字典管理', 'page', 'sys_map', 'id', '{\r\n \"type\": \"page\",\r\n \"asideResizor\": true,\r\n \"asideMinWidth\": 200,\r\n \"aside\": [\r\n {\r\n \"type\": \"form\",\r\n \"wrapWithPanel\": false,\r\n \"target\": \"window\",\r\n \"submitOnInit\": true,\r\n \"body\": [\r\n {\r\n \"type\": \"input-tree\",\r\n \"name\": \"map_tree\",\r\n \"treeContainerClassName\": \"h-full\",\r\n \"inputClassName\": \"no-border\",\r\n \"submitOnChange\": true,\r\n \"showOutline\": true,\r\n \"showIcon\": false,\r\n \"selectFirst\": true,\r\n \"labelField\": \"map_name\",\r\n \"valueField\": \"map_val\",\r\n \"source\": \"/api/map_tree\"\r\n }\r\n ]\r\n }\r\n ],\r\n \"body\": [\r\n {\r\n \"type\": \"crud\",\r\n \"draggable\": true,\r\n \"api\": {\r\n \"url\": \"/api/sys_map_list\",\r\n \"sendOn\": \"this.map_tree\"\r\n },\r\n \"saveOrderApi\": \"/sort/{$code}\",\r\n \"perPageAvailable\": {com:pageSize /\r\n },\r\n \"perPage\": {com:page /\r\n },\r\n \"filter\": {\r\n \"title\": \"字典查询\",\r\n \"submitText\": \"\",\r\n \"mode\": \"inline\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"map_name\",\r\n \"size\": \"sm\",\r\n \"label\": \"字典名称\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"map_val\",\r\n \"size\": \"sm\",\r\n \"label\": \"字典值\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"parent_val\",\r\n \"size\": \"sm\",\r\n \"label\": \"父级值\"\r\n },\r\n {\r\n \"label\": \"搜索\",\r\n \"type\": \"submit\"\r\n }\r\n ]\r\n },\r\n \"filterDefaultVisible\": false,\r\n \"filterTogglable\": true,\r\n \"headerToolbar\": [\r\n {\r\n \"label\": \"新增字典\",\r\n \"type\": \"button\",\r\n \"level\": \"primary\",\r\n \"actionType\": \"dialog\",\r\n \"dialog\": {\r\n \"title\": \"新增字典\",\r\n \"size\": \"md\",\r\n \"body\": {\r\n \"type\": \"form\",\r\n \"mode\": \"horizontal\",\r\n \"horizontal\": {\r\n \"leftFixed\": \"sm\"\r\n },\r\n \"data\": {\r\n \"map_code\": \"$map_tree\"\r\n },\r\n \"reload\": \"crud_com\",\r\n \"api\": \"post:/save/{$code}\",\r\n \"body\": [\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"tree-select\",\r\n \"name\": \"map_code\",\r\n \"required\": true,\r\n \"labelField\": \"map_name\",\r\n \"valueField\": \"map_val\",\r\n \"source\": \"/api/map_tree\",\r\n \"label\": \"字典分组\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"parent_val\",\r\n \"label\": \"父级值\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"map_name\",\r\n \"required\": true,\r\n \"label\": \"字典名称\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"map_val\",\r\n \"required\": true,\r\n \"label\": \"字典值\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"map_val2\",\r\n \"label\": \"字典值2\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"map_val3\",\r\n \"label\": \"字典值3\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"textarea\",\r\n \"name\": \"map_desc\",\r\n \"label\": \"字典描述\"\r\n }\r\n ]\r\n }\r\n }\r\n },\r\n {\r\n \"type\": \"columns-toggler\",\r\n \"align\": \"right\"\r\n },\r\n {\r\n \"type\": \"drag-toggler\",\r\n \"align\": \"right\"\r\n },\r\n {\r\n \"type\": \"filter-toggler\",\r\n \"align\": \"right\"\r\n }\r\n ],\r\n \"columns\": [\r\n {\r\n \"name\": \"map_code\",\r\n \"label\": \"分组编码\",\r\n \"width\": 100\r\n },\r\n {\r\n \"name\": \"parent_val\",\r\n \"label\": \"父级值\",\r\n \"width\": 100\r\n },\r\n {\r\n \"name\": \"map_name\",\r\n \"label\": \"字典名称\",\r\n \"width\": 100\r\n },\r\n {\r\n \"name\": \"map_val\",\r\n \"label\": \"字典值\",\r\n \"width\": 100\r\n },\r\n {\r\n \"name\": \"map_val2\",\r\n \"label\": \"字典值2\",\r\n \"width\": 100\r\n },\r\n {\r\n \"name\": \"map_val3\",\r\n \"label\": \"字典值3\",\r\n \"width\": 100\r\n },\r\n {\r\n \"name\": \"sort\",\r\n \"label\": \"排序值\",\r\n \"width\": 100\r\n },\r\n {\r\n \"name\": \"map_default\",\r\n \"label\": \"缺省\",\r\n \"width\": 70,\r\n \"quickEdit\": {\r\n \"mode\": \"inline\",\r\n \"type\": \"switch\",\r\n \"saveImmediately\": {\r\n \"api\": {\r\n \"method\": \"POST\",\r\n \"url\": \"/save/{$code}\",\r\n \"data\": {\r\n \"id\": \"$id\",\r\n \"map_default\": \"$map_default\"\r\n }\r\n }\r\n }\r\n }\r\n },\r\n {\r\n \"name\": \"map_desc\",\r\n \"label\": \"字典描述\"\r\n },\r\n {\r\n \"type\": \"operation\",\r\n \"label\": \"操作\",\r\n \"width\": 80,\r\n \"buttons\": [\r\n {\r\n \"label\": \"编辑\",\r\n \"level\": \"primary\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"dialog\",\r\n \"dialog\": {\r\n \"title\": \"编辑字典\",\r\n \"size\": \"md\",\r\n \"body\": {\r\n \"type\": \"form\",\r\n \"mode\": \"horizontal\",\r\n \"horizontal\": {\r\n \"leftFixed\": \"sm\"\r\n },\r\n \"reload\": \"crud_com\",\r\n \"api\": \"post:/save/{$code}\",\r\n \"body\": [\r\n {\r\n \"type\": \"hidden\",\r\n \"name\": \"id\",\r\n \"value\": \"$id\"\r\n },\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"tree-select\",\r\n \"name\": \"map_code\",\r\n \"required\": true,\r\n \"labelField\": \"map_name\",\r\n \"valueField\": \"map_val\",\r\n \"source\": \"/api/map_tree\",\r\n \"label\": \"字典分组\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"parent_val\",\r\n \"label\": \"父级值\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"map_name\",\r\n \"required\": true,\r\n \"label\": \"字典名称\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"map_val\",\r\n \"required\": true,\r\n \"label\": \"字典值\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"map_val2\",\r\n \"label\": \"字典值2\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"map_val3\",\r\n \"label\": \"字典值3\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"textarea\",\r\n \"name\": \"map_desc\",\r\n \"label\": \"字典描述\"\r\n }\r\n ]\r\n }\r\n }\r\n },\r\n {\r\n \"label\": \"删除\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"ajax\",\r\n \"title\": \"确认操作\",\r\n \"level\": \"danger\",\r\n \"confirmText\": \"确认要删除 ${code} ？\",\r\n \"api\": \"delete:/api/{$code}/${id}\"\r\n }\r\n ]\r\n }\r\n ]\r\n }\r\n ]\r\n}', '用于存储字典映射关系', '2021-11-14 22:56:22', '2022-02-12 04:38:13', NULL);
INSERT INTO `sys_com` VALUES (8, 'com_save', 'com_list', '组件编辑', 'page', 'sys_com', 'id', '{\r\n \"type\": \"page\",\r\n \"body\": {\r\n \"type\": \"form\",\r\n \"title\": \"组件编辑\",\r\n \"mode\": \"horizontal\",\r\n \"actions\": [\r\n {\r\n \"type\": \"submit\",\r\n \"label\": \"保存修改\",\r\n \"level\": \"primary\",\r\n \"hotKey\": \"command+s,ctrl+s\"\r\n },\r\n {\r\n \"type\": \"button\",\r\n \"label\": \"放弃修改\",\r\n \"onClick\": \"window.history.go(-1);\"\r\n }\r\n ],\r\n \"horizontal\": {\r\n \"leftFixed\": \"sm\"\r\n },\r\n \"reload\": \"crud_com\",\r\n \"initApi\": \"get:/api/com_save?id=${id}\",\r\n \"api\": \"post:/save/{$code}\",\r\n \"body\": [\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"code\",\r\n \"label\": \"组件编码{$Request.get.id}\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"title\",\r\n \"label\": \"组件名称\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"select\",\r\n \"name\": \"tables\",\r\n \"label\": \"组件数据表\",\r\n \"clearable\":true,\r\n \"source\":\"/api/sys_tables_option\"\r\n },\r\n {\r\n \"type\": \"select\",\r\n \"name\": \"pri_field\",\r\n \"label\": \"组件主字段\",\r\n \"clearable\": true,\r\n \"source\": \"/api/sys_table_column?tables={$tables}\"\r\n },\r\n {\r\n \"label\": \"组件类型\",\r\n \"type\": \"select\",\r\n \"name\": \"type\",\r\n \"options\": {map:option code=\"SysComMap\" /}\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"desc\",\r\n \"label\": \"组件描述\"\r\n },\r\n {\r\n \"type\": \"json-editor\",\r\n \"language\": \"json\",\r\n \"className\":\"edit-test\",\r\n \"name\": \"body\",\r\n \"size\": \"xxl\",\r\n \"label\": \"组件Body\"\r\n }\r\n ]\r\n }\r\n}', '组件编辑页面', '2021-11-14 22:56:22', '2022-02-07 22:32:37', NULL);
INSERT INTO `sys_com` VALUES (9, 'admin_index_grid', 'index', '后台首页上方卡片', 'form', '', '', '{\n \"type\": \"service\",\n \"data\": {\n \"total_sales\": \"233.00\",\n \"day_sales\": \"23.33\",\n \"conversion\": 83.33,\n \"pv\": 2333\n },\n \"body\": {\n \"type\": \"grid\",\n \"className\": \"pc:mb-5\",\n \"columns\": [\n {\n \"type\": \"page\",\n \"title\": \"销售额\",\n \"className\": \"shadow m:mb-5\",\n \"body\": [\n {\n \"type\": \"tpl\",\n \"tpl\": \"￥ ${total_sales} \",\n \"className\": \"text-2xl leading-10\"\n },\n {\n \"type\": \"tpl\",\n \"tpl\": \" 元\"\n },\n {\n \"type\": \"wrapper\",\n \"body\": \"今日销售额：${day_sales} 元\",\n \"size\": \"none\",\n \"className\": \"text-gray-600\",\n \"style\": {\n \"height\": \"40px\",\n \"display\": \"table-cell\",\n \"vertical-align\": \"bottom\"\n }\n }\n ]\n },\n {\n \"type\": \"page\",\n \"title\": \"支付笔数\",\n \"className\": \"shadow m:mb-5\",\n \"body\": [\n {\n \"type\": \"tpl\",\n \"tpl\": \"${total_sales}\",\n \"className\": \"text-2xl leading-10\"\n },\n {\n \"type\": \"tpl\",\n \"tpl\": \" 笔\"\n },\n {\n \"type\": \"chart\",\n \"style\": {\n \"mergin-top\": \"30px\",\n \"min-height\": \"40px\"\n },\n \"config\": {\n \"xAxis\": {\n \"type\": \"category\",\n \"show\": false\n },\n \"yAxis\": {\n \"show\": false,\n \"type\": \"value\"\n },\n \"series\": [\n {\n \"data\": [\n 30,\n 40,\n 30,\n 40,\n 50,\n 60,\n 55,\n 70,\n 99,\n 40,\n 30,\n 40,\n 50,\n 60,\n 55,\n 70,\n 99,\n 50,\n 30,\n 40,\n 50,\n 60,\n 55,\n 70,\n 99\n ],\n \"type\": \"bar\"\n }\n ],\n \"tooltip\": {\n \"trigger\": \"axis\",\n \"formatter\": \"{c}\"\n },\n \"grid\": {\n \"left\": \"0\",\n \"right\": 0\n }\n }\n }\n ]\n },\n {\n \"type\": \"page\",\n \"title\": \"访问量\",\n \"className\": \"shadow m:mb-5\",\n \"body\": [\n {\n \"type\": \"tpl\",\n \"tpl\": \"${pv}\",\n \"className\": \"text-2xl leading-10\"\n },\n {\n \"type\": \"tpl\",\n \"tpl\": \" 次\"\n },\n {\n \"type\": \"chart\",\n \"style\": {\n \"mergin-top\": \"30px\",\n \"min-height\": \"40px\"\n },\n \"config\": {\n \"xAxis\": {\n \"type\": \"category\",\n \"boundaryGap\": false,\n \"show\": false\n },\n \"yAxis\": {\n \"show\": false,\n \"type\": \"value\"\n },\n \"series\": [\n {\n \"data\": [\n 5,\n 8,\n 4,\n 6,\n 4,\n 2,\n 7,\n 6,\n 9,\n 4,\n 5,\n 2,\n 6\n ],\n \"type\": \"line\",\n \"smooth\": true,\n \"showSymbol\": false,\n \"areaStyle\": {\n \"color\": {\n \"type\": \"linear\",\n \"x\": 0,\n \"y\": 0,\n \"x2\": 0,\n \"y2\": 1,\n \"colorStops\": [\n {\n \"offset\": 0,\n \"color\": \"rgba(154, 100, 227,0.9)\"\n },\n {\n \"offset\": 1,\n \"color\": \"rgba(154, 100, 227,0.1)\"\n }\n ]\n }\n },\n \"itemStyle\": {\n \"color\": \"rgb(154, 100, 227)\"\n }\n }\n ],\n \"tooltip\": {\n \"trigger\": \"axis\",\n \"formatter\": \"{c} 次\"\n },\n \"grid\": {\n \"left\": 0,\n \"height\": \"40px\",\n \"bottom\": 0,\n \"right\": 0\n }\n }\n }\n ]\n },\n {\n \"type\": \"page\",\n \"title\": \"KPI完成度\",\n \"className\": \"shadow m:mb-5\",\n \"body\": [\n {\n \"type\": \"tpl\",\n \"tpl\": \"${conversion}\",\n \"className\": \"text-2xl leading-10\"\n },\n {\n \"type\": \"tpl\",\n \"tpl\": \" %\"\n },\n {\n \"type\": \"static-progress\",\n \"name\": \"conversion\",\n \"showLabel\": false\n }\n ]\n }\n ]\n }\n}', '后台首页上方的卡片', '2021-11-14 22:56:22', '2022-02-08 00:26:14', NULL);
INSERT INTO `sys_com` VALUES (10, 'admin_role', '', '系统管理_角色管理', 'page', 'admin_role', 'id', '{\r\n \"type\": \"page\",\r\n \"body\": {\r\n \"type\": \"crud\",\r\n \"name\": \"admin_user\",\r\n \"filterTogglable\": true,\r\n \"filterDefaultVisible\": false,\r\n \"headerToolbar\": [\r\n {\r\n \"label\": \"添加角色\",\r\n \"type\": \"button\",\r\n \"level\": \"primary\",\r\n \"actionType\": \"dialog\",\r\n \"dialog\": {com:slot code=\"admin_role_dialog\" type=\"add\"/\r\n }\r\n },\r\n {\r\n \"type\": \"columns-toggler\",\r\n \"align\": \"right\"\r\n },\r\n {\r\n \"type\": \"filter-toggler\",\r\n \"align\": \"right\"\r\n }\r\n ],\r\n \"filter\": {com:slot code=\"admin_role_filter\" /\r\n },\r\n \"perPageAvailable\": {map:config name=\'SysComConfig.PageSize\' /\r\n },\r\n \"perPage\": {map:config name=\'SysComConfig.PageSizeDefault\' /\r\n },\r\n \"footerToolbar\": [\r\n \"statistics\",\r\n \"switch-per-page\",\r\n \"pagination\"\r\n ],\r\n \"api\": \"/api/admin_role_list\",\r\n \"columns\": [\r\n {\r\n \"name\": \"id\",\r\n \"label\": \"ID\"\r\n },\r\n {\r\n \"name\": \"name\",\r\n \"label\": \"角色名\"\r\n },\r\n {\r\n \"name\": \"status\",\r\n \"label\": \"角色状态\",\r\n \"type\": \"mapping\",\r\n \"map\": {\r\n \"0\": \"停用\",\r\n \"1\": \"启用\"\r\n }\r\n },\r\n {\r\n \"name\": \"desc\",\r\n \"label\": \"描述\"\r\n },\r\n {\r\n \"name\": \"create_time\",\r\n \"label\": \"创建时间\"\r\n },\r\n {\r\n \"type\": \"operation\",\r\n \"label\": \"操作\",\r\n \"align\": \"right\",\r\n \"width\": 150,\r\n \"buttons\": [\r\n {\r\n \"label\": \"编辑\",\r\n \"level\": \"primary\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"dialog\",\r\n \"dialog\": {com:slot code=\"admin_role_dialog\" type=\"edit\"/\r\n }\r\n },\r\n {\r\n \"label\": \"删除\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"ajax\",\r\n \"title\": \"确认操作\",\r\n \"level\": \"danger\",\r\n \"confirmText\": \"确认要删除 ${code} ？\",\r\n \"api\": \"delete:/api/{$code}/${id}\"\r\n }\r\n ]\r\n }\r\n ]\r\n }\r\n}', '我是角色管理组件', '2021-11-14 22:56:22', '2022-01-02 00:59:21', NULL);
INSERT INTO `sys_com` VALUES (12, 'admin_user', '', '系统管理_用户管理', 'page', 'admin_user', 'id', '{\r\n \"type\": \"page\",\r\n \"body\": {\r\n \"type\": \"crud\",\r\n \"name\":\"admin_user\",\r\n \"filterTogglable\": true,\r\n \"filterDefaultVisible\":false,\r\n \"headerToolbar\": [\r\n {\r\n \"label\": \"添加用户\",\r\n \"type\": \"button\",\r\n \"level\": \"primary\",\r\n \"actionType\": \"dialog\",\r\n \"dialog\": {com:slot code=\"admin_user_dialog\" type=\"add\"/\r\n }\r\n },\r\n {\r\n \"type\": \"columns-toggler\",\r\n \"align\": \"right\"\r\n },\r\n {\r\n \"type\": \"filter-toggler\",\r\n \"align\": \"right\"\r\n }\r\n ],\r\n \"filter\": {com:slot code=\"admin_user_filter\" /},\r\n \"perPageAvailable\": {map:config name=\'SysComConfig.PageSize\' /\r\n },\r\n \"perPage\": {map:config name=\'SysComConfig.PageSizeDefault\' /\r\n },\r\n \"footerToolbar\": [\r\n \"statistics\",\r\n \"switch-per-page\",\r\n \"pagination\"\r\n ],\r\n \"api\": \"/api/admin_user_list\",\r\n \"columns\": [\r\n {\r\n \"name\": \"id\",\r\n \"label\": \"ID\"\r\n },\r\n {\r\n \"name\": \"username\",\r\n \"label\": \"用户名\"\r\n },\r\n {\r\n \"name\": \"phone\",\r\n \"label\": \"手机号\"\r\n },\r\n {\r\n \"name\": \"email\",\r\n \"label\": \"邮箱\"\r\n },\r\n {\r\n \"name\": \"super_admin\",\r\n \"label\": \"管理员\",\r\n \"type\": \"mapping\",\r\n \"map\":{\r\n \"0\": \"<span class=\'label label-info\'>普通用户</span>\",\r\n \"1\": \"<span class=\'label label-success\'>管理员</span>\"\r\n }\r\n },\r\n {\r\n \"name\": \"status\",\r\n \"width\":100,\r\n \"label\": \"账号状态\",\r\n \"type\": \"mapping\",\r\n \"map\": {\r\n \"0\": \"<span class=\'text-danger\'>冻结</span>\",\r\n \"1\": \"<span class=\'text-success\'>正常</span>\"\r\n }\r\n },\r\n {\r\n \"name\": \"role_arr\",\r\n \"label\": \"角色\",\r\n \"type\": \"each\",\r\n \"placeholder\": \"无角色\",\r\n \"items\": {\r\n \"type\": \"tpl\",\r\n \"tpl\": \"<span class=\'label label-info m-l-xs\'><%= this.item %></span>\"\r\n }\r\n },\r\n {\r\n \"name\": \"login_time\",\r\n \"label\": \"上次登录时间\"\r\n },\r\n {\r\n \"name\": \"login_ip\",\r\n \"label\": \"上次登录IP\"\r\n },\r\n {\r\n \"type\": \"operation\",\r\n \"label\": \"操作\",\r\n \"align\": \"right\",\r\n \"width\": 150,\r\n \"buttons\": [\r\n {\r\n \"label\": \"编辑\",\r\n \"level\": \"primary\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"dialog\",\r\n \"dialog\": {com:slot code=\"admin_user_dialog\" type=\"edit\"/}\r\n },\r\n {\r\n \"label\": \"删除\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"ajax\",\r\n \"title\": \"确认操作\",\r\n \"level\": \"danger\",\r\n \"confirmText\": \"确认要删除 ${code} ？\",\r\n \"api\": \"delete:/api/{$code}/${id}\"\r\n }\r\n ]\r\n }\r\n ]\r\n }\r\n}', '系统管理_用户管理', '2021-11-14 22:56:22', '2022-02-02 01:23:59', NULL);
INSERT INTO `sys_com` VALUES (13, 'com_add_dialog', 'com_list', '组件添加表单项', 'dialog', 'sys_com', 'id', '{\r\n \"title\": \"{eq name=\"type\" value=\"sub\"} 新增子组件 {else/} 新增组件 {/eq}\",\r\n \"size\": \"sm\",\r\n \"body\": {\r\n \"type\": \"form\",\r\n \"mode\": \"horizontal\",\r\n \"horizontal\": {\r\n \"leftFixed\": \"sm\"\r\n },\r\n \"data\": {\r\n \"pri_field\": \"id\",\r\n \"parent_code\": \"${code}\",\r\n \"code\": \"\",\r\n \"title\": \"\",\r\n \"desc\": \"\"\r\n },\r\n \"reload\": \"crud_com\",\r\n \"api\": \"post:/save/{$code}\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-text\",\r\n \"disabled\": true,\r\n \"name\": \"parent_code\",\r\n \"label\": \"父组件\",\r\n \"hidden\":\"{$type !== \'sub\'}\"\r\n },\r\n {\r\n \"label\": \"组件类型\",\r\n \"type\": \"select\",\r\n \"name\": \"type\",\r\n \"options\": {map:option code=\"SysComMap\" /\r\n }\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"code\",\r\n \"label\": \"组件编码\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"title\",\r\n \"label\": \"组件名称\"\r\n },\r\n {\r\n \"type\": \"textarea\",\r\n \"name\": \"desc\",\r\n \"label\": \"组件描述\"\r\n }\r\n ]\r\n }\r\n}', '组件添加表单项', '2021-11-30 23:33:09', '2022-02-07 22:32:13', NULL);
INSERT INTO `sys_com` VALUES (14, 'admin_user_dialog', 'admin_user', '系统管理_用户管理_弹窗', 'dialog', 'admin_user', 'id', '{\r\n \"title\": {eq name=\"type\" value=\"add\"} \"新增用户\" {else/} \"修改用户\" {/eq},\r\n \"body\": {\r\n \"type\": \"form\",\r\n \"api\": \"post:/admin_user/save\",\r\n \"mode\": \"horizontal\",\r\n \"reload\":\"admin_user\",\r\n \"horizontal\": {\r\n \"leftFixed\": \"sm\"\r\n },\r\n \"data\": {\r\n \"id\": \"${id}\"\r\n },\r\n \"body\": [\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"username\",\r\n \"label\": \"用户名\",\r\n \"required\": true\r\n },\r\n {\r\n \"type\": \"input-password\",\r\n \"name\": \"password\",\r\n \"label\": \"密码\",\r\n \"required\": \"{$type == \'add\'}\",\r\n \"description\": \"编辑用户时，为空则不修改密码\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"email\",\r\n \"label\": \"邮箱\",\r\n \"validations\":{\r\n \"isEmail\": \"validate.isEmail\"\r\n }\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"phone\",\r\n \"label\": \"手机号\",\r\n \"validations\": {\r\n \"isPhoneNumber\": \"validate.isPhoneNumber\"\r\n }\r\n },\r\n {\r\n \"name\": \"super_admin\",\r\n \"type\": \"switch\",\r\n \"label\": \"管理员\",\r\n \"inline\": true,\r\n \"trueValue\": 1,\r\n \"falseValue\": 0,\r\n \"remark\": \"管理员不校验任何权限\"\r\n },\r\n {\r\n \"name\": \"status\",\r\n \"type\": \"radios\",\r\n \"label\": \"账号状态\",\r\n \"options\": [\r\n {\r\n \"label\": \"正常\",\r\n \"value\": \"1\"\r\n },\r\n {\r\n \"label\": \"冻结\",\r\n \"value\": \"0\"\r\n }\r\n ]\r\n },\r\n {\r\n \"label\": \"角色\",\r\n \"type\": \"select\",\r\n \"name\": \"roles\",\r\n \"disabledOn\": \"this.super_admin\",\r\n \"multiple\": true,\r\n \"columns\": [\r\n {\r\n \"name\":\"label\",\r\n \"label\":\"用户组名称\"\r\n }\r\n ],\r\n \"source\": \"/api/admin_role_option\"\r\n }\r\n ]\r\n}\r\n}', '系统管理_用户管理_弹窗', '2021-12-12 00:08:29', '2022-02-02 01:30:30', NULL);
INSERT INTO `sys_com` VALUES (15, 'admin_user_filter', 'admin_user', '用户管理过滤表单', 'form', '', 'id', '{\r\n \"title\": \"查询用户\",\r\n \"submitText\": \"\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"username\",\r\n \"label\": \"用户名\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"phone\",\r\n \"label\": \"手机\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"email\",\r\n \"label\": \"邮箱\"\r\n },\r\n {\r\n \"label\": \"查询\",\r\n \"type\": \"action\",\r\n \"level\": \"primary\",\r\n \"actionType\": \"submit\"\r\n },\r\n {\r\n \"label\": \"重置\",\r\n \"type\": \"action\",\r\n \"actionType\": \"reset\"\r\n }\r\n ]\r\n}', '后台用户列表的查询表单', '2021-12-12 18:22:40', '2021-12-12 18:24:53', NULL);
INSERT INTO `sys_com` VALUES (16, 'sys_com', '', '系统组件', 'page', '', 'id', '', '系统组件，（仅有子组件）', '2021-12-12 18:47:21', '2021-12-13 21:59:53', NULL);
INSERT INTO `sys_com` VALUES (17, 'sys_header_pc', 'sys_com', '系统组件header头', 'page', '', 'id', '{\n \"type\": \"page\",\n \"initApi\": \"/api/sys_user_info\",\n \"body\": {\n \"type\": \"flex\",\n \"justify\": \"flex-end\",\n \"items\": [\n {\n \"size\": 30,\n \"type\": \"avatar\",\n \"fit\": \"contain\",\n \"src\": \"${avatar}\"\n },\n {\n \"type\": \"dropdown-button\",\n \"label\": \"$username\",\n \"className\": \"header-menu\",\n \"buttons\": [\n {\n \"type\": \"button\",\n \"label\": \"个人信息\",\n \"actionType\": \"link\",\n \"link\": \"/view/user_info\"\n },\n {\n \"type\": \"button\",\n \"actionType\": \"url\",\n \"url\": \"/login/out\",\n \"blank\": false,\n \"confirmText\": \"确定要退出吗\",\n \"label\": \"退出登录\"\n }\n ]\n }\n ]\n }\n}', '系统组件header头', '2021-12-12 18:48:50', '2022-02-03 01:00:52', NULL);
INSERT INTO `sys_com` VALUES (18, 'sys_user_info', 'sys_com', '个人信息页面', 'page', 'admin_user', 'id', '{\n \"type\": \"page\",\n \"name\":\"user_info_page\",\n \"initApi\": \"/api/sys_user_info\",\n \"body\": [\n {\n \"type\": \"grid\",\n \"columns\": [\n {\n \"md\": 4,\n \"body\": {\n \"type\": \"panel\",\n \"title\": \"\",\n \"body\": {\n \"type\": \"form\",\n \"wrapWithPanel\": false,\n \"mode\": \"horizontal\",\n \"body\": [\n {\n \"type\": \"static-image\",\n \"name\": \"avatar\",\n \"label\": \"头像\"\n },\n {\n \"type\": \"divider\"\n },\n {\n \"type\": \"static\",\n \"label\": \"用户名\",\n \"name\": \"username\"\n },\n {\n \"type\": \"divider\"\n },\n {\n \"type\": \"static-tpl\",\n \"label\": \"身份\",\n \"tpl\": \"${super_admin?\'超级管理员\':\'普通用户\'}\"\n },\n {\n \"type\": \"divider\"\n },\n {\n \"type\": \"static\",\n \"label\": \"角色\",\n \"name\": \"role_arr\"\n },\n {\n \"type\": \"divider\"\n },\n {\n \"type\": \"static\",\n \"label\": \"邮箱\",\n \"name\": \"email\"\n },\n {\n \"type\": \"divider\"\n },\n {\n \"type\": \"static\",\n \"label\": \"手机\",\n \"name\": \"phone\"\n },\n {\n \"type\": \"divider\"\n },\n {\n \"type\": \"static\",\n \"label\": \"上次登录时间\",\n \"name\": \"login_time\"\n },\n {\n \"type\": \"divider\"\n },\n {\n \"type\": \"static\",\n \"label\": \"上次登录 IP\",\n \"name\": \"login_ip\"\n }\n ]\n }\n }\n },\n {\n \"md\": 8,\n \"body\": {\n \"type\": \"panel\",\n \"title\": \"\",\n \"body\": {\n \"type\": \"tabs\",\n \"mode\": \"line\",\n \"tabs\": [\n {\n \"title\": \"基础资料\",\n \"tab\": {\n \"type\": \"form\",\n \"api\": \"/admin_user/edit\",\n \"data\": {\n \"avatar\": \"https://portrait.gitee.com/uploads/avatars/user/528/1585602_dbkuaizi_1635601042.png\"\n },\n \"reload\":\"user_info_page\",\n \"wrapWithPanel\": false,\n \"mode\": \"horizontal\",\n \"body\": [\n {\n \"type\": \"input-image\",\n \"name\": \"avatar\",\n \"label\": \"个人头像\",\n \"receiver\": \"/upload?type=avatar\",\n \"required\": true\n },\n {\n \"type\": \"input-text\",\n \"name\": \"phone\",\n \"label\": \"手机号\",\n \"required\": true,\n \"size\": \"md\",\n \"validations\": {\n \"isPhoneNumber\": \"validate.isPhoneNumber\"\n }\n },\n {\n \"type\": \"input-email\",\n \"name\": \"email\",\n \"size\": \"md\",\n \"label\": \"邮箱\",\n \"required\": true\n },\n {\n \"label\": \"确认修改\",\n \"type\": \"action\",\n \"actionType\": \"submit\",\n \"level\": \"primary\"\n }\n ]\n }\n },\n {\n \"title\": \"修改密码\",\n \"tab\": {\n \"type\": \"form\",\n \"title\": \"\",\n \"mode\": \"horizontal\",\n \"api\": \"/admin_user/reset_pwd\",\n \"wrapWithPanel\": false,\n \"body\": [\n {\n \"type\": \"input-password\",\n \"name\": \"old_pwd\",\n \"label\": \"旧密码\",\n \"size\": \"md\",\n \"required\": true\n },\n {\n \"type\": \"input-password\",\n \"name\": \"new_pwd\",\n \"size\": \"md\",\n \"label\": \"新密码\",\n \"required\": true\n },\n {\n \"type\": \"input-password\",\n \"name\": \"repeat_pwd\",\n \"size\": \"md\",\n \"label\": \"确认新密码\",\n \"required\": true\n },\n {\n \"label\": \"确认修改\",\n \"type\": \"action\",\n \"actionType\": \"submit\",\n \"level\": \"primary\"\n }\n ]\n }\n }\n ]\n }\n }\n }\n ]\n }\n ]\n}', '个人信息修改表单', '2021-12-13 22:01:06', '2022-02-04 04:38:14', NULL);
INSERT INTO `sys_com` VALUES (19, 'admin_menu_dialog', 'admin_menu', '菜单编辑弹窗', 'dialog', 'admin_menu', 'id', '{\r\n \"title\": {eq name=\"type\" value=\"add\"} \"新增菜单\" {else/} \"修改菜单\" {/eq},\r\n \"size\": \"md\",\r\n \"body\": {\r\n \"type\": \"form\",\r\n \"api\": \"post:/save/{$code}\",\r\n \"mode\": \"horizontal\",\r\n \"reload\": \"admin_user\",\r\n \"horizontal\": {\r\n \"leftFixed\": \"sm\"\r\n },\r\n \"data\": {\r\n {eq name=\"type\" value=\"add\"}\r\n \"id\": \"\",\r\n \"parent_id\":\"${id}\",\r\n \"type\":\"menu\",\r\n \"label\":\"\",\r\n \"visible\":\"0\",\r\n \"icon\":\"\",\r\n \"verify\":\"1\",\r\n \"sort\":\"0\",\r\n \"url\":\"\",\r\n \"path\":\"\"\r\n {else/}\r\n \"id\": \"${id}\"\r\n {/eq}\r\n },\r\n \"body\": [\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"tree-select\",\r\n \"name\": \"parent_id\",\r\n \"labelField\": \"label\",\r\n \"valueField\": \"id\",\r\n \"source\": \"/api/sys_menu\",\r\n \"label\": \"父级菜单\"\r\n },\r\n {\r\n \"name\": \"type\",\r\n \"type\": \"radios\",\r\n \"label\": \"菜单类型\",\r\n \"value\": \"menu\",\r\n \"required\": true,\r\n \"options\": {map:option code=\"SysMenuType\" /\r\n }\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"label\",\r\n \"required\": true,\r\n \"label\": \"菜单名称\"\r\n },\r\n {\r\n \"name\": \"visible\",\r\n \"type\": \"radios\",\r\n \"label\": \"是否显示\",\r\n \"value\": \"0\",\r\n \"required\": true,\r\n \"disabledOn\": \"-1 !== [\'action\'].indexOf(this.type)\",\r\n \"options\": {map:option code=\"SysMenuVisible\" /\r\n }\r\n }\r\n \r\n ]\r\n },\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-group\",\r\n \"label\": \"菜单图标\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-text\",\r\n \"placeholder\": \"输入图标class\",\r\n \"name\": \"icon\"\r\n },\r\n {\r\n \"type\": \"button\",\r\n \"url\": \"https://remixicon.com\",\r\n \"actionType\": \"url\",\r\n \"blank\":true,\r\n \"label\": \"选择图标\"\r\n }\r\n ]\r\n },\r\n {\r\n \"name\": \"verify\",\r\n \"type\": \"radios\",\r\n \"label\": \"权限校验\",\r\n \"value\": \"1\",\r\n \"required\": true,\r\n \"disabledOn\":\"this.type == \'dir\'\",\r\n \"options\": {map:option code=\"SysMenuVerify\" /\r\n }\r\n }\r\n ]\r\n },{\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-number\",\r\n \"name\": \"sort\",\r\n \"value\":\"0\",\r\n \"min\": \"0\",\r\n \"label\": \"菜单排序\"\r\n },\r\n {\r\n \"name\": \"log\",\r\n \"type\": \"radios\",\r\n \"label\": \"操作日志\",\r\n \"value\": \"1\",\r\n \"required\": true,\r\n \"disabledOn\": \"this.type != \'action\'\",\r\n \"options\": [\r\n {\r\n \"label\":\"记录\",\r\n \"value\": \"1\"\r\n },\r\n {\r\n \"label\": \"不记录\",\r\n \"value\": \"0\"\r\n }\r\n ]\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"divider\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"url\",\r\n \"label\": \"菜单路由\",\r\n \"requiredOn\":\"this.type == \'menu\'\",\r\n \"disabledOn\":\"-1 === [\'menu\'].indexOf(this.type)\"\r\n },\r\n {\r\n \"type\": \"picker\",\r\n \"name\": \"path\",\r\n \"size\": \"lg\",\r\n \"label\": \"页面组件\",\r\n \"requiredOn\": \"this.type == \'menu\'\",\r\n \"placeholder\": \"请点击图标选择菜单组件\",\r\n \"hiddenOn\": \"this.type != \'menu\'\",\r\n \"source\": {\r\n \"method\": \"get\",\r\n \"url\": \"/api/com_list\",\r\n \"data\": {\r\n \"type\": \"page\",\r\n \"page\":\"${page}\",\r\n \"perPage\": \"15\"\r\n }\r\n },\r\n \"labelField\": \"title\",\r\n \"valueField\": \"path\",\r\n \"pickerSchema\": {\r\n \"title\":\"请选择 “${label}” 菜单对应的页面组件\",\r\n \"mode\": \"table\",\r\n \"name\": \"thelist\",\r\n \"footerToolbar\": [\r\n \"statistics\",\r\n \"pagination\"\r\n ],\r\n \"columns\": [\r\n {\r\n \"name\": \"id\",\r\n \"label\": \"ID\",\r\n \"width\": 50\r\n },\r\n {\r\n \"name\": \"type\",\r\n \"label\": \"组件类型\",\r\n \"width\": 70,\r\n \"type\": \"mapping\",\r\n \"map\": {map:colnum code=\"SysComMap\" field=\"map_val2\" key=\"map_val\" /\r\n }\r\n },\r\n {\r\n \"name\": \"code\",\r\n \"label\": \"组件编码\"\r\n },\r\n {\r\n \"name\": \"title\",\r\n \"label\": \"组件名称\"\r\n },\r\n {\r\n \"name\": \"desc\",\r\n \"label\": \"组件描述\"\r\n }\r\n ]\r\n }\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"path\",\r\n \"label\": \"URL地址\",\r\n \"requiredOn\": \"-1 !== [\'link\',\'action\'].indexOf(this.type)\",\r\n \"hiddenOn\": \"this.type == \'menu\'\",\r\n \"disabledOn\": \"-1 === [\'link\',\'action\'].indexOf(this.type)\"\r\n }\r\n ]\r\n }\r\n}', '菜单新增/编辑的弹窗表单', '2021-12-14 22:27:43', '2022-04-06 20:59:51', NULL);
INSERT INTO `sys_com` VALUES (20, 'admin_role_dialog', 'admin_role', '角色弹窗', 'dialog', 'admin_role', 'id', '{\r\n \"title\": {eq name=\"type\" value=\"add\"} \"新增角色\" {else/} \"修改角色\" {/eq},\r\n \"body\": {\r\n \"type\": \"form\",\r\n \"api\": \"post:/save/{$code}\",\r\n \"mode\": \"horizontal\",\r\n \"reload\": \"admin_user\",\r\n \"horizontal\": {\r\n \"leftFixed\": \"sm\"\r\n },\r\n \"data\": {\r\n \"id\": \"${id}\"\r\n },\r\n \"body\": [\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"name\",\r\n \"required\": true,\r\n \"label\": \"角色名称\"\r\n },\r\n {\r\n \"type\": \"radios\",\r\n \"name\": \"status\",\r\n \"value\":\"1\",\r\n \"required\": true,\r\n \"label\": \"角色状态\",\r\n \"options\": [\r\n {\r\n \"label\": \"启用\",\r\n \"value\": \"1\"\r\n },\r\n {\r\n \"label\":\"停用\",\r\n \"value\":\"0\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"textarea\",\r\n \"name\": \"desc\",\r\n \"required\": true,\r\n \"label\": \"角色描述\",\r\n \"showCounter\": true,\r\n \"maxLength\": 255\r\n },\r\n {\r\n \"type\": \"input-tree\",\r\n \"name\": \"permissions\",\r\n \"label\": \"分配权限\",\r\n \"multiple\": true,\r\n \"delimeter\":\",\",\r\n \"withChildren\": true,\r\n \"valueField\":\"id\",\r\n \"source\":\"/api/sys_menu\"\r\n }\r\n ]\r\n }\r\n}', '角色的新增或编辑表单弹窗', '2021-12-28 23:06:50', '2022-02-07 23:27:43', NULL);
INSERT INTO `sys_com` VALUES (21, 'sys_log', '', '操作日志', 'page', '', 'id', '{\r\n \"type\":\"page\",\r\n \"body\": {\r\n \"type\": \"crud\",\r\n \"name\": \"sys_log\",\r\n \"filterTogglable\": true,\r\n \"syncLocation\": false,\r\n \"filterDefaultVisible\": false,\r\n \"headerToolbar\": [\r\n {\r\n \"type\": \"form\",\r\n \"target\": \"sys_log\",\r\n \"wrapWithPanel\": false,\r\n \"mode\": \"inline\",\r\n \"body\": [\r\n {\r\n \"type\": \"select\",\r\n \"label\": \"请求方式\",\r\n \"name\": \"method\",\r\n \"clearable\": true,\r\n \"size\": \"sm\",\r\n \"options\": [\r\n {\r\n \"label\":\"GET\",\r\n \"value\": \"GET\"\r\n },\r\n {\r\n \"label\": \"POST\",\r\n \"value\": \"POST\"\r\n },\r\n {\r\n \"label\": \"DELETE\",\r\n \"value\": \"DELETE\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"label\": \"操作模块\",\r\n \"name\": \"title\",\r\n \"size\": \"sm\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"label\": \"操作用户\",\r\n \"name\": \"username\",\r\n \"size\": \"sm\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"label\": \"请求地址\",\r\n \"name\": \"path\",\r\n \"size\": \"sm\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"label\": \"请求IP\",\r\n \"name\": \"ip\",\r\n \"size\": \"sm\"\r\n },\r\n {\r\n \"type\": \"input-datetime-range\",\r\n \"label\": \"操作时间\",\r\n \"name\": \"datetime\",\r\n \"format\": \"YYYY-MM-DD HH:mm:ss\",\r\n \"timeFormat\": \"HH:mm:ss\"\r\n },\r\n {\r\n \"type\": \"submit\",\r\n \"level\": \"primary\",\r\n \"label\": \"查询\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"columns-toggler\",\r\n \"align\": \"right\"\r\n }\r\n ],\r\n \"perPageAvailable\": {map:config name=\'SysComConfig.PageSize\' /\r\n },\r\n \"perPage\": {map:config name=\'SysComConfig.PageSizeDefault\' /\r\n },\r\n \"footerToolbar\": [\r\n \"statistics\",\r\n \"switch-per-page\",\r\n \"pagination\"\r\n ],\r\n \"api\": \"/api/admin_log_list\",\r\n \"columns\": [\r\n {\r\n \"name\": \"id\",\r\n \"label\": \"ID\",\r\n \"width\": 100\r\n },\r\n {\r\n \"name\": \"username\",\r\n \"label\": \"操作用户\",\r\n \"width\": 150\r\n },\r\n {\r\n \"name\": \"method\",\r\n \"label\": \"请求方式\",\r\n \"width\": 50\r\n },\r\n {\r\n \"name\": \"title\",\r\n \"label\": \"操作模块\",\r\n \"width\": 100\r\n },\r\n {\r\n \"name\": \"path\",\r\n \"label\": \"请求地址\",\r\n \"width\": 300\r\n },\r\n {\r\n \"name\": \"ip\",\r\n \"label\": \"请求IP\",\r\n \"width\": 100\r\n },\r\n {\r\n \"name\": \"datetime\",\r\n \"label\": \"请求时间\",\r\n \"width\": 150\r\n },\r\n {\r\n \"name\": \"desc\",\r\n \"label\": \"日志描述\"\r\n },\r\n {\r\n \"type\": \"operation\",\r\n \"label\": \"操作\",\r\n \"align\": \"right\",\r\n \"width\": 150,\r\n \"buttons\": [\r\n {\r\n \"label\": \"详情\",\r\n \"level\": \"primary\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"dialog\",\r\n \"dialog\": {com:slot code=\"sys_log_dialog\"/}\r\n }\r\n ]\r\n }\r\n ]\r\n }\r\n}', '后端操作日志', '2021-12-28 23:48:45', '2022-02-08 02:52:32', NULL);
INSERT INTO `sys_com` VALUES (22, 'admin_index_chart', 'index', '后台首页的统计图', 'page', '', 'id', '{\r\n \"type\": \"page\",\r\n \"body\": {\r\n \"type\": \"chart\",\r\n \"config\": {\r\n \"title\": {\r\n \"text\": \"Stacked Line\"\r\n },\r\n \"tooltip\": {\r\n \"trigger\": \"axis\"\r\n },\r\n \"legend\": {\r\n \"data\": [\r\n \"Email\",\r\n \"Union Ads\",\r\n \"Video Ads\",\r\n \"Direct\",\r\n \"Search Engine\"\r\n ]\r\n },\r\n \"grid\": {\r\n \"left\": \"3%\",\r\n \"right\": \"4%\",\r\n \"bottom\": \"3%\",\r\n \"containLabel\": true\r\n },\r\n \"toolbox\": {\r\n \"feature\": {\r\n \"saveAsImage\": {}\r\n }\r\n },\r\n \"xAxis\": {\r\n \"type\": \"category\",\r\n \"boundaryGap\": false,\r\n \"data\": [\r\n \"Mon\",\r\n \"Tue\",\r\n \"Wed\",\r\n \"Thu\",\r\n \"Fri\",\r\n \"Sat\",\r\n \"Sun\"\r\n ]\r\n },\r\n \"yAxis\": {\r\n \"type\": \"value\"\r\n },\r\n \"series\": [\r\n {\r\n \"name\": \"Email\",\r\n \"type\": \"line\",\r\n \"stack\": \"Total\",\r\n \"data\": [\r\n 120,\r\n 132,\r\n 101,\r\n 134,\r\n 90,\r\n 230,\r\n 210\r\n ]\r\n },\r\n {\r\n \"name\": \"Union Ads\",\r\n \"type\": \"line\",\r\n \"stack\": \"Total\",\r\n \"data\": [\r\n 220,\r\n 182,\r\n 191,\r\n 234,\r\n 290,\r\n 330,\r\n 310\r\n ]\r\n },\r\n {\r\n \"name\": \"Video Ads\",\r\n \"type\": \"line\",\r\n \"stack\": \"Total\",\r\n \"data\": [\r\n 150,\r\n 232,\r\n 201,\r\n 154,\r\n 190,\r\n 330,\r\n 410\r\n ]\r\n },\r\n {\r\n \"name\": \"Direct\",\r\n \"type\": \"line\",\r\n \"stack\": \"Total\",\r\n \"data\": [\r\n 320,\r\n 332,\r\n 301,\r\n 334,\r\n 390,\r\n 330,\r\n 320\r\n ]\r\n },\r\n {\r\n \"name\": \"Search Engine\",\r\n \"type\": \"line\",\r\n \"stack\": \"Total\",\r\n \"data\": [\r\n 820,\r\n 932,\r\n 901,\r\n 934,\r\n 1290,\r\n 1330,\r\n 1320\r\n ]\r\n }\r\n ]\r\n }}\r\n}', '', '2021-12-30 21:47:03', '2021-12-30 21:56:54', '2022-02-02 02:03:08');
INSERT INTO `sys_com` VALUES (23, 'sys_userinfo_mobile', 'sys_com', '移动端用户信息', 'page', '', 'id', '{\n \"type\": \"service\",\n \"className\": \"bg-none p-3\",\n \"api\": \"/api/sys_user_info\",\n \"body\": [\n {\n \"type\": \"button-group\",\n \"tiled\": true,\n \"buttons\": [\n {\n \"type\": \"button\",\n \"label\": \"${username}\",\n \"level\": \"dark\",\n \"actionType\": \"link\",\n \"link\": \"/view/user_info\"\n },\n {\n \"type\": \"button\",\n \"label\": \"退出\",\n \"actionType\": \"url\",\n \"confirmText\": \"确定要退出吗\",\n \"url\": \"/login/out\",\n \"blank\": false,\n \"level\": \"dark\"\n }\n ]\n }\n ]\n}', '移动端用户信息组件，用于修改个人信息、修改密码、退出登录等', '2022-01-01 22:52:22', '2022-02-08 00:24:56', NULL);
INSERT INTO `sys_com` VALUES (24, 'admin_role_filter', 'admin_role', '角色筛选条件', 'form', '', 'id', '{\r\n \"title\": false,\r\n \"submitText\": \"\",\r\n \"body\": [\r\n {\r\n \"type\": \"input-text\",\r\n \"name\": \"name\",\r\n \"label\": \"角色名\"\r\n },\r\n {\r\n \"type\": \"select\",\r\n \"name\": \"status\",\r\n \"label\": \"角色状态\",\r\n \"size\": \"sm\",\r\n \"options\": [\r\n {\r\n \"label\": \"启用\",\r\n \"value\": \"1\"\r\n },\r\n {\r\n \"label\": \"停用\",\r\n \"value\": \"0\"\r\n }\r\n ]\r\n },\r\n {\r\n \"label\": \"查询\",\r\n \"type\": \"action\",\r\n \"level\": \"primary\",\r\n \"actionType\": \"submit\"\r\n },\r\n {\r\n \"label\": \"重置\",\r\n \"type\": \"action\",\r\n \"actionType\": \"reset\"\r\n }\r\n ]\r\n}', '角色筛选条件', '2022-01-02 01:00:57', '2022-02-12 04:43:19', NULL);
INSERT INTO `sys_com` VALUES (25, 'sys_page_not_permission', 'sys_com', '组件无权限提示', 'page', '', 'id', '{\r\n \"type\": \"alert\",\r\n \"body\": \"没有权限访问该页面\",\r\n \"level\": \"warning\",\r\n \"showIcon\": true,\r\n \"className\": \"m-3\"\r\n}', '页面无权限提示', '2022-02-01 04:15:31', '2022-02-01 04:16:19', NULL);
INSERT INTO `sys_com` VALUES (26, 'sys_upload', '', '附件管理', 'page', '', 'id', '{\r\n \"type\": \"page\",\r\n \"body\": {\r\n \"type\": \"crud\",\r\n \"name\": \"sys_upload\",\r\n \"filterTogglable\": true,\r\n \"syncLocation\": false,\r\n \"filterDefaultVisible\": false,\r\n \"headerToolbar\": [\r\n {\r\n \"type\": \"form\",\r\n \"target\":\"sys_upload\",\r\n \"wrapWithPanel\": false,\r\n \"mode\": \"inline\",\r\n \"body\": [\r\n {\r\n \"type\": \"select\",\r\n \"label\": \"分类\",\r\n \"name\": \"type\",\r\n \"clearable\":true,\r\n \"size\": \"sm\",\r\n \"options\": {map:option code=\"SysUploadsType\"/}\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"label\": \"MIME类型\",\r\n \"name\": \"mime\",\r\n \"size\": \"sm\"\r\n },\r\n {\r\n \"type\": \"input-text\",\r\n \"label\": \"上传用户\",\r\n \"name\": \"username\",\r\n \"size\": \"sm\"\r\n },\r\n {\r\n \"type\": \"input-datetime-range\",\r\n \"label\": \"上传时间\",\r\n \"name\": \"upload_time\",\r\n \"format\": \"YYYY-MM-DD HH:mm:ss\",\r\n \"timeFormat\": \"HH:mm:ss\"\r\n },\r\n {\r\n \"type\": \"submit\",\r\n \"level\": \"primary\",\r\n \"label\": \"查询\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"columns-toggler\",\r\n \"align\": \"right\"\r\n }\r\n ],\r\n \"perPageAvailable\": {map:config name=\'SysComConfig.PageSize\' /\r\n },\r\n \"perPage\": {map:config name=\'SysComConfig.PageSizeDefault\' /\r\n },\r\n \"footerToolbar\": [\r\n \"statistics\",\r\n \"switch-per-page\",\r\n \"pagination\"\r\n ],\r\n \"api\": \"/api/sys_upload_list\",\r\n \"columns\": [\r\n {\r\n \"name\": \"type\",\r\n \"width\": 100,\r\n \"label\": \"文件类别\",\r\n \"type\": \"mapping\",\r\n \"map\": {map:colnum code=\"SysUploadsType\" / field=\"map_name\" key=\"map_val\"}\r\n },\r\n {\r\n \"name\": \"mime\",\r\n \"label\": \"MIME类型\"\r\n },\r\n {\r\n \"name\": \"name\",\r\n \"label\": \"文件名\"\r\n },\r\n {\r\n \"name\": \"size\",\r\n \"label\": \"文件大小(KB)\"\r\n },\r\n {\r\n \"name\": \"path\",\r\n \"label\": \"存储路径\"\r\n },\r\n {\r\n \"name\": \"upload_url\",\r\n \"label\": \"上传页面\"\r\n },\r\n {\r\n \"name\": \"name\",\r\n \"label\": \"文件名\"\r\n },\r\n {\r\n \"name\": \"upload_time\",\r\n \"label\": \"上传时间\",\r\n \"sortable\": true\r\n },\r\n {\r\n \"name\": \"username\",\r\n \"label\": \"用户名\"\r\n },\r\n {\r\n \"type\": \"operation\",\r\n \"label\": \"操作\",\r\n \"align\": \"right\",\r\n \"width\": 150,\r\n \"buttons\": [\r\n {\r\n \"label\": \"查看附件\",\r\n \"level\": \"primary\",\r\n \"type\": \"button\",\r\n \"size\": \"xs\",\r\n \"actionType\": \"url\",\r\n \"url\":\"${path}\"\r\n \r\n }\r\n ]\r\n }\r\n ]\r\n }\r\n}', '附件管理页面', '2022-02-05 00:08:14', '2022-02-07 23:43:52', NULL);
INSERT INTO `sys_com` VALUES (27, 'sys_log_dialog', 'sys_log', '操作日志详情弹窗', 'dialog', '', 'id', '{\r\n \"title\":\"详情\",\r\n \"size\": \"md\",\r\n \"body\": {\r\n \"type\": \"form\",\r\n \"mode\": \"horizontal\",\r\n \"horizontal\": {\r\n \"leftFixed\": \"sm\"\r\n },\r\n \"body\": [\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"static\",\r\n \"name\": \"username\",\r\n \"label\": \"操作用户\"\r\n },\r\n {\r\n \"type\": \"static\",\r\n \"name\": \"ip\",\r\n \"label\": \"请求IP\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"static\",\r\n \"name\": \"method\",\r\n \"label\": \"请求方式\"\r\n },\r\n {\r\n \"type\": \"static\",\r\n \"name\": \"title\",\r\n \"label\": \"操作模块\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"group\",\r\n \"body\": [\r\n {\r\n \"type\": \"static\",\r\n \"name\": \"datetime\",\r\n \"label\": \"请求时间\"\r\n },\r\n {\r\n \"type\": \"static\",\r\n \"name\": \"function\",\r\n \"label\": \"请求方法\"\r\n }\r\n ]\r\n },\r\n {\r\n \"type\": \"divider\"\r\n },\r\n {\r\n \"type\": \"static\",\r\n \"name\": \"path\",\r\n \"label\": \"请求地址\"\r\n },\r\n {\r\n \"type\": \"static\",\r\n \"name\": \"ua\",\r\n \"label\": \"用户代理\"\r\n },\r\n {\r\n \"type\": \"static\",\r\n \"name\": \"param\",\r\n \"label\": \"请求参数\"\r\n },\r\n {\r\n \"type\": \"static\",\r\n \"name\": \"desc\",\r\n \"label\": \"日志描述\"\r\n }\r\n\r\n ] \r\n }\r\n}', '操作日志详情弹窗', '2022-02-08 00:51:29', '2022-02-08 01:50:40', NULL);
-- ----------------------------
-- Table structure for sys_map
-- ----------------------------
DROP TABLE IF EXISTS `sys_map`;
CREATE TABLE `sys_map` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id',
`map_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '分组编码',
`parent_val` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '父级编码',
`map_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字典名称',
`map_val` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字典值1',
`map_val2` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '字典值2',
`map_val3` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '字典值3',
`sort` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '字典排序',
`map_default` tinyint(1) UNSIGNED NULL DEFAULT 0 COMMENT '缺省选择',
`map_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '字典描述',
PRIMARY KEY (`id`) USING BTREE,
INDEX `idx_code_val`(`map_code`, `map_val`) USING BTREE COMMENT '字典编码、字典值组合字段'
) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '系统字典表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_map
-- ----------------------------
INSERT INTO `sys_map` VALUES (1, 'SysMapTree', '', '字典树', 'SysMapTree', '', NULL, 0, 1, '字典树，字典列表左边的树来自这个枚举');
INSERT INTO `sys_map` VALUES (2, 'SysMapTree', '', '系统字典', 'SysMap', '', NULL, 1, 0, '');
INSERT INTO `sys_map` VALUES (3, 'SysMapTree', 'SysMap', '组件类型', 'SysComMap', '', NULL, 3, 0, '组件类型枚举');
INSERT INTO `sys_map` VALUES (4, 'SysComMap', '', '页面', 'page', '<span class=\'label label-info\'>页面</span>', NULL, 0, 0, '页面组件');
INSERT INTO `sys_map` VALUES (5, 'SysMapTree', 'SysMap', '接口类型', 'SysApiType', '', NULL, 4, 0, '用于管理接口的几个类型');
INSERT INTO `sys_map` VALUES (6, 'SysApiType', '', '单条', 'find', '', NULL, 0, 1, '用于返回单条数据');
INSERT INTO `sys_map` VALUES (7, 'SysApiType', '', '选项', 'option', '', NULL, 3, 0, '用于返回一个选项值，例如 下拉框，映射、按钮单选等');
INSERT INTO `sys_map` VALUES (8, 'SysApiType', '', '树形', 'tree', '', NULL, 2, 0, '返回一个树结构的数据');
INSERT INTO `sys_map` VALUES (9, 'SysComMap', '', '表单', 'form', '<span class=\'label label-success\'>表单</span>', NULL, 1, 0, '');
INSERT INTO `sys_map` VALUES (10, 'SysApiType', '', 'CURD', 'curd', '', NULL, 1, 0, '获取CURD 格式的数据');
INSERT INTO `sys_map` VALUES (11, 'SysMapTree', '', '系统配置', 'SysConfig', '', NULL, 5, 0, '');
INSERT INTO `sys_map` VALUES (13, 'SysComConfig', '', '分页选项', 'PageSize', '[5,10,15,20,50,100]', NULL, 0, 1, '用于控制后台CURD 分页选项');
INSERT INTO `sys_map` VALUES (14, 'SysComConfig', '', '默认显示多少条', 'PageSizeDefault', '15', NULL, 0, 0, '该值与 PageSize 对应，必须是 PageSize 列表值');
INSERT INTO `sys_map` VALUES (15, 'SysMapTree', 'SysConfig', '组件配置', 'SysComConfig', '', NULL, 6, 0, '系统组件的配置项');
INSERT INTO `sys_map` VALUES (16, 'SysComMap', '', '弹窗', 'dialog', '<span class=\'label label-success\'>弹窗</span>', NULL, 2, 0, '弹窗组件');
INSERT INTO `sys_map` VALUES (17, 'SysMapTree', 'SysMap', '菜单类型', 'SysMenuType', '', NULL, 7, 0, '菜单的类型');
INSERT INTO `sys_map` VALUES (18, 'SysMenuType', '', '菜单', 'menu', '<span class=\'label label-info\'>菜单</span>', NULL, 0, 0, '可点击的菜单');
INSERT INTO `sys_map` VALUES (19, 'SysMenuType', '', '外链', 'link', '<span class=\'label label-success\'>外链</span>', NULL, 2, 0, '外部链接');
INSERT INTO `sys_map` VALUES (20, 'SysMenuType', '', '行为', 'action', '<span class=\'label label-danger\'>行为</span>', NULL, 3, 0, '按钮/接口等');
INSERT INTO `sys_map` VALUES (22, 'SysMapTree', 'SysMap', '菜单隐藏方式', 'SysMenuVisible', '', NULL, 8, 0, '');
INSERT INTO `sys_map` VALUES (23, 'SysMapTree', 'SysMap', '菜单权限校验', 'SysMenuVerify', '', NULL, 9, 0, '');
INSERT INTO `sys_map` VALUES (24, 'SysMenuVisible', '', '显示', '0', '', NULL, 0, 0, '');
INSERT INTO `sys_map` VALUES (25, 'SysMenuVisible', '', 'PC隐藏', '1', '', NULL, 1, 0, '');
INSERT INTO `sys_map` VALUES (26, 'SysMenuVisible', '', '隐藏', '2', '', NULL, 2, 0, '');
INSERT INTO `sys_map` VALUES (27, 'SysMenuVerify', '', '校验', '1', '<i class=\"ri-check-line text-success text-base\"></i>', NULL, 0, 0, '');
INSERT INTO `sys_map` VALUES (28, 'SysMenuVerify', '', '不校验', '0', '<i class=\"ri-close-line text-danger text-base\"></i>', NULL, 0, 0, '');
INSERT INTO `sys_map` VALUES (29, 'SysMenuType', '', '目录', 'dir', '<span class=\'label label-warning\'>目录</span>', NULL, 1, 0, '没有url的菜单目录');
INSERT INTO `sys_map` VALUES (30, 'SysMapTree', 'SysMap', 'CURD查询类型', 'ApiCurdSearchType', '', NULL, 9, 0, '');
INSERT INTO `sys_map` VALUES (31, 'ApiCurdSearchType', '', '等于', '=', '', NULL, 0, 0, 'field = value');
INSERT INTO `sys_map` VALUES (32, 'ApiCurdSearchType', '', '大于', '>', '', NULL, 3, 0, 'field > value');
INSERT INTO `sys_map` VALUES (33, 'ApiCurdSearchType', '', '小于', '<', '', NULL, 4, 0, 'field < value');
INSERT INTO `sys_map` VALUES (34, 'ApiCurdSearchType', '', '大于等于', '>=', '', NULL, 5, 0, 'field >= value');
INSERT INTO `sys_map` VALUES (35, 'ApiCurdSearchType', '', '小于等于', '<=', '', NULL, 6, 0, 'field <= value');
INSERT INTO `sys_map` VALUES (36, 'ApiCurdSearchType', '', '不等于', '<>', '', NULL, 1, 0, 'field <> value');
INSERT INTO `sys_map` VALUES (37, 'ApiCurdSearchType', '', '列表', 'in', '', NULL, 8, 0, 'field in (value1,value2.value3)');
INSERT INTO `sys_map` VALUES (38, 'ApiCurdSearchType', '', '模糊', 'like', '', NULL, 2, 0, 'field like \'%value%\'');
INSERT INTO `sys_map` VALUES (40, 'SysMapTree', 'SysMap', '上传文件类型', 'SysUploadsType', '', NULL, 2, 0, '上传文件类型');
INSERT INTO `sys_map` VALUES (41, 'SysUploadsType', '', '缺省', 'uploads', '', NULL, 0, 0, '');
INSERT INTO `sys_map` VALUES (42, 'SysUploadsType', '', '头像上传', 'avatar', '', NULL, 0, 0, '');
INSERT INTO `sys_map` VALUES (43, 'ApiCurdSearchType', '', '区间', 'between', '', NULL, 7, 0, 'filed BETWEEN value1 AND value2');
-- ----------------------------
-- Table structure for sys_upload
-- ----------------------------
DROP TABLE IF EXISTS `sys_upload`;
CREATE TABLE `sys_upload` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键id',
`type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文件类别',
`mime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文件的mime类型',
`size` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文件大小字节',
`md5` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '上传文件的md5',
`path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '文件保存路径',
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '上传文件名称',
`upload_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '上传页面',
`uid` int(10) UNSIGNED NOT NULL COMMENT '上传用户',
`upload_time` datetime NOT NULL COMMENT '上传时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '附件表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of sys_upload
-- ----------------------------
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。