EmploymentSite/doc/待更新脚本.txt

INSERT INTO sys_function_code VALUES ('T010506', '驿站统计报表', 'T0105', 6);
INSERT INTO `sys_menu` VALUES ('T010506', 6, '驿站统计报表', NULL, 'views/statistics/SiteStatistics', '/siteStatistics', 'T0105', NULL, 0, 1, 1, 'T010506', 1, NULL, NULL);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T010506');

INSERT INTO sys_function_code VALUES ('T010507', '企业统计报表', 'T0105', 7);
INSERT INTO `sys_menu` VALUES ('T010507', 7, '企业统计报表', NULL, 'views/statistics/CompanyStatistics', '/companyStatistics', 'T0105', NULL, 0, 1, 1, 'T010507', 1, NULL, NULL);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T010507');

INSERT INTO `sys_function_code` (`FunctionCode`, `FunctionName`, `ParentFunctionCode`, `OrderNo`) VALUES ('T010203', '零工市场管理', 'T0102', 3);
INSERT INTO `sys_function_code` (`FunctionCode`, `FunctionName`, `ParentFunctionCode`, `OrderNo`) VALUES ('T01020301', '查看', 'T010203', 1);
INSERT INTO `sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`, `IsBlank`) VALUES ('T010203', 3, '零工市场管理', NULL, '', '/gigMarket', 'T0102', '零工市场管理', 0, 1, 1, 'T010203', 1, NULL, NULL);
INSERT INTO `sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`, `IsBlank`) VALUES ('T01020301', 1, '零工市场', NULL, 'companyService/gigMarket/index', '/index', 'T010203', '', 0, 0, 1, 'T010203', 1, NULL, NULL);
INSERT INTO `sys_menu` (`MenuNo`, `OrderNo`, `MenuName`, `Icon`, `ViewPath`, `Url`, `ParentMenuNo`, `Description`, `IsTopMenu`, `IsVisible`, `IsLeaf`, `FunctionCode`, `RecordStatus`, `ShortcutIcon`, `IsBlank`) VALUES ('T01020302', 2, '零工市场详情', NULL, 'companyService/gigMarket/detail', '/detail', 'T010203', '', 0, 0, 1, 'T010203', 1, NULL, NULL);
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T010203');
insert into sys_role_sys_function_code (`RoleID`, `FunctionCode`) values('20afde90-a81a-11ed-a6c5-7085c2a9999e','T01020301');