1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
-- ----------------------------
-- 会议记录菜单 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_menu` VALUES (null, '会议记录', '/metting/record/list', 0,'', 1, 1, 0, 0,'',NULL, NULL, NULL, 0, 0, 1, NULL, NULL, NULL);
-- ----------------------------
-- 会议记录资源路径 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_resource` VALUES (null, '会议记录-菜单管理-查看', '/metting/record/list,/metting/record/view,/metting/record/info,/metting/record/export,/metting/record/exportExcel,/metting/record/downloadTemplate,/metting/record/download', 3, 0, NULL, NULL, NULL, 0);
INSERT INTO `mortals_xhx_resource` VALUES (null, '会议记录-菜单管理-维护', '/metting/record/add,/metting/record/edit,/metting/record/delete,/metting/record/logicDelete,/metting/record/save,/metting/record/importData', 3, 0, NULL, NULL, NULL, 0);
-- ----------------------------
-- 会议记录参数 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_param` VALUES (null, '会议状态', 'MettingRecord', 'meetStatus', '0', '等待中', 1, 4, 0, 'meetStatus', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '会议状态', 'MettingRecord', 'meetStatus', '1', '进行中', 1, 4, 0, 'meetStatus', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '会议状态', 'MettingRecord', 'meetStatus', '2', '已结束', 1, 4, 0, 'meetStatus', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '会议结束方式', 'MettingRecord', 'finishMethod', '0', '自动结束', 1, 4, 0, 'finishMethod', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '会议结束方式', 'MettingRecord', 'finishMethod', '1', '手动结束', 1, 4, 0, 'finishMethod', NULL, NULL, NULL);
-- ----------------------------
-- 来往记录菜单 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_menu` VALUES (null, '来往记录', '/gocome/record/list', 0,'', 1, 1, 0, 0,'',NULL, NULL, NULL, 0, 0, 1, NULL, NULL, NULL);
-- ----------------------------
-- 来往记录资源路径 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_resource` VALUES (null, '来往记录-菜单管理-查看', '/gocome/record/list,/gocome/record/view,/gocome/record/info,/gocome/record/export,/gocome/record/exportExcel,/gocome/record/downloadTemplate,/gocome/record/download', 3, 0, NULL, NULL, NULL, 0);
INSERT INTO `mortals_xhx_resource` VALUES (null, '来往记录-菜单管理-维护', '/gocome/record/add,/gocome/record/edit,/gocome/record/delete,/gocome/record/logicDelete,/gocome/record/save,/gocome/record/importData', 3, 0, NULL, NULL, NULL, 0);
-- ----------------------------
-- 来往记录参数 SQL
-- ----------------------------
-- ----------------------------
-- 房间管理菜单 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_menu` VALUES (null, '房间管理', '/room/list', 0,'', 1, 1, 0, 0,'',NULL, NULL, NULL, 0, 0, 1, NULL, NULL, NULL);
-- ----------------------------
-- 房间管理资源路径 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_resource` VALUES (null, '房间管理-菜单管理-查看', '/room/list,/room/view,/room/info,/room/export,/room/exportExcel,/room/downloadTemplate,/room/download', 3, 0, NULL, NULL, NULL, 0);
INSERT INTO `mortals_xhx_resource` VALUES (null, '房间管理-菜单管理-维护', '/room/add,/room/edit,/room/delete,/room/logicDelete,/room/save,/room/importData', 3, 0, NULL, NULL, NULL, 0);
-- ----------------------------
-- 房间管理参数 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_param` VALUES (null, '房间类型', 'Room', 'roomType', '0', '会议室', 1, 4, 0, 'roomType', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '房间类型', 'Room', 'roomType', '1', '办公室', 1, 4, 0, 'roomType', NULL, NULL, NULL);
-- ----------------------------
-- 房间工作人员信息菜单 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_menu` VALUES (null, '房间工作人员信息', '/room/workman/list', 0,'', 1, 1, 0, 0,'',NULL, NULL, NULL, 0, 0, 1, NULL, NULL, NULL);
-- ----------------------------
-- 房间工作人员信息资源路径 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_resource` VALUES (null, '房间工作人员信息-菜单管理-查看', '/room/workman/list,/room/workman/view,/room/workman/info,/room/workman/export,/room/workman/exportExcel,/room/workman/downloadTemplate,/room/workman/download', 3, 0, NULL, NULL, NULL, 0);
INSERT INTO `mortals_xhx_resource` VALUES (null, '房间工作人员信息-菜单管理-维护', '/room/workman/add,/room/workman/edit,/room/workman/delete,/room/workman/logicDelete,/room/workman/save,/room/workman/importData', 3, 0, NULL, NULL, NULL, 0);
-- ----------------------------
-- 房间工作人员信息参数 SQL
-- ----------------------------
-- ----------------------------
-- 工作人员菜单 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_menu` VALUES (null, '工作人员', '/workman/list', 0,'', 1, 1, 0, 0,'',NULL, NULL, NULL, 0, 0, 1, NULL, NULL, NULL);
-- ----------------------------
-- 工作人员资源路径 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_resource` VALUES (null, '工作人员-菜单管理-查看', '/workman/list,/workman/view,/workman/info,/workman/export,/workman/exportExcel,/workman/downloadTemplate,/workman/download', 3, 0, NULL, NULL, NULL, 0);
INSERT INTO `mortals_xhx_resource` VALUES (null, '工作人员-菜单管理-维护', '/workman/add,/workman/edit,/workman/delete,/workman/logicDelete,/workman/save,/workman/importData', 3, 0, NULL, NULL, NULL, 0);
-- ----------------------------
-- 工作人员参数 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_param` VALUES (null, '性别', 'Workman', 'sex', '0', '男', 1, 4, 0, 'sex', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '性别', 'Workman', 'sex', '1', '女', 1, 4, 0, 'sex', NULL, NULL, NULL);
-- ----------------------------
-- 设备管理菜单 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_menu` VALUES (null, '设备管理', '/device/list', 0,'', 1, 1, 0, 0,'',NULL, NULL, NULL, 0, 0, 1, NULL, NULL, NULL);
-- ----------------------------
-- 设备管理资源路径 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_resource` VALUES (null, '设备管理-菜单管理-查看', '/device/list,/device/view,/device/info,/device/export,/device/exportExcel,/device/downloadTemplate,/device/download', 3, 0, NULL, NULL, NULL, 0);
INSERT INTO `mortals_xhx_resource` VALUES (null, '设备管理-菜单管理-维护', '/device/add,/device/edit,/device/delete,/device/logicDelete,/device/save,/device/importData', 3, 0, NULL, NULL, NULL, 0);
-- ----------------------------
-- 设备管理参数 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_param` VALUES (null, '分辨率', 'Device', 'resolution', '0', '1920*1080', 1, 4, 0, 'resolution', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '分辨率', 'Device', 'resolution', '1', '1366*768', 1, 4, 0, 'resolution', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '分辨率', 'Device', 'resolution', '2', '1080*1920', 1, 4, 0, 'resolution', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '设备状态 ', 'Device', 'deviceStatus', '0', '未激活', 1, 4, 0, 'deviceStatus', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '设备状态 ', 'Device', 'deviceStatus', '1', '离线', 1, 4, 0, 'deviceStatus', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '设备状态 ', 'Device', 'deviceStatus', '2', '在线', 1, 4, 0, 'deviceStatus', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '启用状态 ', 'Device', 'enabled', '0', '停止', 1, 4, 0, 'enabled', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '启用状态 ', 'Device', 'enabled', '1', '启用', 1, 4, 0, 'enabled', NULL, NULL, NULL);
-- ----------------------------
-- 基础设置菜单 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_menu` VALUES (null, '基础设置', '/basic/set/list', 0,'', 1, 1, 0, 0,'',NULL, NULL, NULL, 0, 0, 1, NULL, NULL, NULL);
-- ----------------------------
-- 基础设置资源路径 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_resource` VALUES (null, '基础设置-菜单管理-查看', '/basic/set/list,/basic/set/view,/basic/set/info,/basic/set/export,/basic/set/exportExcel,/basic/set/downloadTemplate,/basic/set/download', 3, 0, NULL, NULL, NULL, 0);
INSERT INTO `mortals_xhx_resource` VALUES (null, '基础设置-菜单管理-维护', '/basic/set/add,/basic/set/edit,/basic/set/delete,/basic/set/logicDelete,/basic/set/save,/basic/set/importData', 3, 0, NULL, NULL, NULL, 0);
-- ----------------------------
-- 基础设置参数 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_param` VALUES (null, '是否显示照片', 'BasicSet', 'showPhoto', '0', '否', 1, 4, 0, 'showPhoto', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '是否显示照片', 'BasicSet', 'showPhoto', '1', '是', 1, 4, 0, 'showPhoto', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '是否显示姓名 ', 'BasicSet', 'showName', '0', '否', 1, 4, 0, 'showName', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '是否显示姓名 ', 'BasicSet', 'showName', '1', '是', 1, 4, 0, 'showName', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '是否显示职位', 'BasicSet', 'showPost', '0', '否', 1, 4, 0, 'showPost', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '是否显示职位', 'BasicSet', 'showPost', '1', '是', 1, 4, 0, 'showPost', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '是否显示在岗状态', 'BasicSet', 'showWork', '0', '否', 1, 4, 0, 'showWork', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '是否显示在岗状态', 'BasicSet', 'showWork', '1', '是', 1, 4, 0, 'showWork', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '是否显示电话', 'BasicSet', 'showPhone', '0', '否', 1, 4, 0, 'showPhone', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '是否显示电话', 'BasicSet', 'showPhone', '1', '是', 1, 4, 0, 'showPhone', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '是否显示电话', 'BasicSet', 'showPhone', '0', '否', 1, 4, 0, 'showPhone', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '是否显示电话', 'BasicSet', 'showPhone', '1', '是', 1, 4, 0, 'showPhone', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '显示电子门牌信息', 'BasicSet', 'showElect', '0', '显示时间', 1, 4, 0, 'showElect', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '显示电子门牌信息', 'BasicSet', 'showElect', '1', '自定义内容', 1, 4, 0, 'showElect', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '显示会议室门牌信息', 'BasicSet', 'showMeet', '0', '显示时间', 1, 4, 0, 'showMeet', NULL, NULL, NULL);
INSERT INTO `mortals_xhx_param` VALUES (null, '显示会议室门牌信息', 'BasicSet', 'showMeet', '1', '自定义内容', 1, 4, 0, 'showMeet', NULL, NULL, NULL);
-- ----------------------------
-- 状态设置菜单 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_menu` VALUES (null, '状态设置', '/basic/status/list', 0,'', 1, 1, 0, 0,'',NULL, NULL, NULL, 0, 0, 1, NULL, NULL, NULL);
-- ----------------------------
-- 状态设置资源路径 SQL
-- ----------------------------
INSERT INTO `mortals_xhx_resource` VALUES (null, '状态设置-菜单管理-查看', '/basic/status/list,/basic/status/view,/basic/status/info,/basic/status/export,/basic/status/exportExcel,/basic/status/downloadTemplate,/basic/status/download', 3, 0, NULL, NULL, NULL, 0);
INSERT INTO `mortals_xhx_resource` VALUES (null, '状态设置-菜单管理-维护', '/basic/status/add,/basic/status/edit,/basic/status/delete,/basic/status/logicDelete,/basic/status/save,/basic/status/importData', 3, 0, NULL, NULL, NULL, 0);
-- ----------------------------
-- 状态设置参数 SQL
-- ----------------------------