JeeSite（2）：导入数据，进入系统

本文的原文连接是: http://blog.csdn.net/freewebsys/article/details/50954485 未经博主允许不得转载。
博主地址是：http://blog.csdn.net/freewebsys

1，关于数据

上次运行jeesite的时候发现数据没有初始化成功。
系统都进入不去。而且在执行初始化的时候报错。
在db/sys/jeesite_data.xls这个excel里面是要初始化的数据。
我感觉windows可能能跑通，我的是Mac，里面还有mysql的大小写问题呢。
在maven执行dbunit 的时候读excel的时候报错了，没有初始化成功。
最近要研究python，发现了一个读excel的工具，想到了解决方案。

2，使用python xlrd工具

git网站：https://github.com/python-excel/xlrd，这个包很奇怪没有pip安装。
只能下载源文件进行install。

#进入文件夹。sudo python setup.py install

然后编写python代码读取jeesite_data文件：

#!/usr/bin/python# -*- coding: utf-8 -*-################import xlrdimport typessql = '''INSERT INTO `%s` (%s) VALUES (%s);'''##处理sheet工作.def merge_sheet(sheet):    # print(sheet.name, sheet.nrows, sheet.ncols)    nrows = int(sheet.nrows)    ncols = int(sheet.ncols)    # 循环行和列.    col_names = ""    table_name = sheet.name    for row in range(nrows):        if row == 0:            # 找到列名称.            for col in range(ncols):                cell = sheet.cell(row, col)                if col == 0:                    col_names += "`" + cell.value + "`"                else:                    col_names += ",`" + cell.value + "`"                value = cell.value                if 'date' in value:                    print(value)        else:            col_values = ""            for col in range(ncols):                cell = sheet.cell(row, col)                value = unicode(cell.value)                # print(type(cell.value), value)                # 如果是float类型,转换成整形.                if type(cell.value) == types.FloatType:                    value = str(int(cell.value))                if col == 0:                    col_values += "'" + value + "'"                else:                    col_values += ",'" + value + "'"            print(sql % (table_name, col_names, col_values))    passbook = xlrd.open_workbook('/Users/yhy/FreeWebSys/jeesite/db/sys/jeesite_data.xls')sheet_names = book.sheet_names()print(len(sheet_names))for sheet_name in sheet_names:    # 循环每一个工作簿.    print("#####################################" + sheet_name + "#####################################")    sheet = book.sheet_by_name(sheet_name)    merge_sheet(sheet)

这个python程序很简单，将工作簿里面的数据读出来，然后拼接成insert的sql。
在excel中的int类型都变成了float，需要单独出来下，再有里面的创建日期，更新日期。
变成一个41586这样的5位数字。不知道是啥，转换不过去，只能写个update语句了。

3，初始化sys模块sql

#####################################sys_area#####################################INSERT INTO `sys_area` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`code`,`type`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('1','0','0,','中国','10','100000','1','','1','41421','1','41421','0');INSERT INTO `sys_area` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`code`,`type`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('2','1','0,1,','山东省','20','110000','2','','1','41421','1','41421','0');INSERT INTO `sys_area` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`code`,`type`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('3','2','0,1,2,','济南市','30','110101','3','','1','41421','1','41421','0');INSERT INTO `sys_area` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`code`,`type`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('4','3','0,1,2,3,','历城区','40','110102','4','','1','41421','1','41421','0');INSERT INTO `sys_area` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`code`,`type`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('5','3','0,1,2,3,','历下区','50','110104','4','','1','41421','1','41421','0');INSERT INTO `sys_area` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`code`,`type`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('6','3','0,1,2,3,','高新区','60','110105','4','','1','41421','1','41421','0');#####################################sys_office#####################################INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('1','0','0,','山东省总公司','10','2','100000','1','1','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('2','1','0,1,','公司领导','10','2','100001','2','1','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('3','1','0,1,','综合部','20','2','100002','2','1','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('4','1','0,1,','市场部','30','2','100003','2','1','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('5','1','0,1,','技术部','40','2','100004','2','1','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('6','1','0,1,','研发部','50','2','100005','2','1','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('7','1','0,1,','济南市分公司','20','3','200000','1','2','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('8','7','0,1,7,','公司领导','10','3','200001','2','2','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('9','7','0,1,7,','综合部','20','3','200002','2','2','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('10','7','0,1,7,','市场部','30','3','200003','2','2','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('11','7','0,1,7,','技术部','40','3','200004','2','2','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('12','7','0,1,7,','历城区分公司','0','4','201000','1','3','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('13','12','0,1,7,12,','公司领导','10','4','201001','2','3','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('14','12','0,1,7,12,','综合部','20','4','201002','2','3','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('15','12','0,1,7,12,','市场部','30','4','201003','2','3','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('16','12','0,1,7,12,','技术部','40','4','201004','2','3','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('17','7','0,1,7,','历下区分公司','40','5','201010','1','3','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('18','17','0,1,7,17,','公司领导','10','5','201011','2','3','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('19','17','0,1,7,17,','综合部','20','5','201012','2','3','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('20','17','0,1,7,17,','市场部','30','5','201013','2','3','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('21','17','0,1,7,17,','技术部','40','5','201014','2','3','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('22','7','0,1,7,','高新区分公司','50','6','201010','1','3','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('23','22','0,1,7,22,','公司领导','10','6','201011','2','3','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('24','22','0,1,7,22,','综合部','20','6','201012','2','3','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('25','22','0,1,7,22,','市场部','30','6','201013','2','3','','','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_office` (`id`,`parent_id`,`parent_ids`,`name`,`sort`,`area_id`,`code`,`type`,`grade`,`address`,`zip_code`,`master`,`phone`,`fax`,`email`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('26','22','0,1,7,22,','技术部','40','6','201014','2','3','','','','','','','','1','1','41421','1','41421','0');#####################################sys_menu#####################################INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('1','0','0,','功能菜单','','','','0','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('2','1','0,1,','系统设置','','','','900','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('3','2','0,1,2,','系统设置','','','','980','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('4','3','0,1,2,3,','菜单管理','/sys/menu/','','list-alt','30','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('5','4','0,1,2,3,4,','查看','','','','30','0','sys:menu:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('6','4','0,1,2,3,4,','修改','','','','40','0','sys:menu:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('7','3','0,1,2,3,','角色管理','/sys/role/','','lock','50','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('8','7','0,1,2,3,7,','查看','','','','30','0','sys:role:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('9','7','0,1,2,3,7,','修改','','','','40','0','sys:role:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('10','3','0,1,2,3,','字典管理','/sys/dict/','','th-list','60','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('11','10','0,1,2,3,10,','查看','','','','30','0','sys:dict:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('12','10','0,1,2,3,10,','修改','','','','40','0','sys:dict:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('13','2','0,1,2,','机构用户','','','','970','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('14','13','0,1,2,13,','区域管理','/sys/area/','','th','50','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('15','14','0,1,2,13,14,','查看','','','','30','0','sys:area:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('16','14','0,1,2,13,14,','修改','','','','40','0','sys:area:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('17','13','0,1,2,13,','机构管理','/sys/office/','','th-large','40','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('18','17','0,1,2,13,17,','查看','','','','30','0','sys:office:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('19','17','0,1,2,13,17,','修改','','','','40','0','sys:office:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('20','13','0,1,2,13,','用户管理','/sys/user/index','','user','30','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('21','20','0,1,2,13,20,','查看','','','','30','0','sys:user:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('22','20','0,1,2,13,20,','修改','','','','40','0','sys:user:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('23','2','0,1,2,','关于帮助','','','','990','0','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('24','23','0,1,2,23','官方首页','http://jeesite.com','_blank','','30','0','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('25','23','0,1,2,23','项目支持','http://jeesite.com/donation.html','_blank','','50','0','','','1','41421','1','41421','1');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('26','23','0,1,2,23','论坛交流','http://bbs.jeesite.com','_blank','','80','0','','','1','41421','1','41421','1');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('27','1','0,1,','我的面板','','','','100','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('28','27','0,1,27,','个人信息','','','','30','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('29','28','0,1,27,28,','个人信息','/sys/user/info','','user','30','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('30','28','0,1,27,28,','修改密码','/sys/user/modifyPwd','','lock','40','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('31','1','0,1,','内容管理','','','','500','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('32','31','0,1,31,','栏目设置','','','','990','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('33','32','0,1,31,32','栏目管理','/cms/category/','','align-justify','30','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('34','33','0,1,31,32,33,','查看','','','','30','0','cms:category:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('35','33','0,1,31,32,33,','修改','','','','40','0','cms:category:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('36','32','0,1,31,32','站点设置','/cms/site/','','certificate','40','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('37','36','0,1,31,32,36,','查看','','','','30','0','cms:site:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('38','36','0,1,31,32,36,','修改','','','','40','0','cms:site:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('39','32','0,1,31,32','切换站点','/cms/site/select','','retweet','50','1','cms:site:select','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('40','31','0,1,31,','内容管理','','','','500','1','cms:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('41','40','0,1,31,40,','内容发布','/cms/','','briefcase','30','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('42','41','0,1,31,40,41,','文章模型','/cms/article/','','file','40','0','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('43','42','0,1,31,40,41,42,','查看','','','','30','0','cms:article:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('44','42','0,1,31,40,41,42,','修改','','','','40','0','cms:article:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('45','42','0,1,31,40,41,42,','审核','','','','50','0','cms:article:audit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('46','41','0,1,31,40,41,','链接模型','/cms/link/','','random','60','0','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('47','46','0,1,31,40,41,46,','查看','','','','30','0','cms:link:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('48','46','0,1,31,40,41,46,','修改','','','','40','0','cms:link:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('49','46','0,1,31,40,41,46,','审核','','','','50','0','cms:link:audit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('50','40','0,1,31,40,','评论管理','/cms/comment/?status=2','','comment','40','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('51','50','0,1,31,40,50,','查看','','','','30','0','cms:comment:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('52','50','0,1,31,40,50,','审核','','','','40','0','cms:comment:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('53','40','0,1,31,40,','公共留言','/cms/guestbook/?status=2','','glass','80','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('54','53','0,1,31,40,53,','查看','','','','30','0','cms:guestbook:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('55','53','0,1,31,40,53,','审核','','','','40','0','cms:guestbook:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('56','71','0,1,27,71,','文件管理','/../static/ckfinder/ckfinder.html','','folder-open','90','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('57','56','0,1,27,40,56,','查看','','','','30','0','cms:ckfinder:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('58','56','0,1,27,40,56,','上传','','','','40','0','cms:ckfinder:upload','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('59','56','0,1,27,40,56,','修改','','','','50','0','cms:ckfinder:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('60','31','0,1,31,','统计分析','','','','600','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('61','60','0,1,31,60,','信息量统计','/cms/stats/article','','tasks','30','1','cms:stats:article','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('62','1','0,1,','在线办公','','','','200','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('63','62','0,1,62,','个人办公','','','','30','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('64','63','0,1,62,63,','请假办理','/oa/leave','','leaf','300','0','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('65','64','0,1,62,63,64,','查看','','','','30','0','oa:leave:view','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('66','64','0,1,62,63,64,','修改','','','','40','0','oa:leave:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('67','2','0,1,2,','日志查询','','','','985','1','','','1','41428','1','41428','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('68','67','0,1,2,67,','日志查询','/sys/log','','pencil','30','1','sys:log:view','','1','41428','1','41428','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('69','62','0,1,62,','流程管理','','','','300','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('70','69','0,1,62,69,','流程管理','/act/process','','road','50','1','act:process:edit','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('71','27','0,1,27,','文件管理','','','','90','1','','','1','41421','1','41421','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('72','69','0,1,62,69,','模型管理','/act/model','','road','100','1','act:model:edit','','1','41537','1','41537','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('73','63','0,1,62,63,','我的任务','/act/task/todo/','','tasks','50','1','','','1','41541','1','41541','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('74','63','0,1,62,63,','审批测试','/oa/testAudit','','','100','1','oa:testAudit:view,oa:testAudit:edit','','1','41541','1','41541','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('75','1','0,1,','在线演示','','','','3000','1','','','1','41555','1','41555','1');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('79','1','0,1,','代码生成','','','','5000','1','','','1','41563','1','41563','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('80','79','0,1,79,','代码生成','','','','50','1','','','1','41563','1','41563','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('81','80','0,1,79,80,','生成方案配置','/gen/genScheme','','','30','1','gen:genScheme:view,gen:genScheme:edit','','1','41563','1','41563','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('82','80','0,1,79,80,','业务表配置','/gen/genTable','','','20','1','gen:genTable:view,gen:genTable:edit,gen:genTableColumn:view,gen:genTableColumn:edit','','1','41563','1','41563','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('83','80','0,1,79,80,','代码模板管理','/gen/genTemplate','','','90','1','gen:genTemplate:view,gen:genTemplate:edit','','1','41563','1','41563','1');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('84','67','0,1,2,67,','连接池监视','/../druid','','','40','1','','','1','41565','1','41565','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('85','76','0,1,75,76,','行政区域','/../static/map/map-city.html','','','80','1','','','1','41569','1','41569','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('86','75','0,1,75,','组件演示','','','','50','1','','','1','41569','1','41569','1');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('87','86','0,1,75,86,','组件演示','/test/test/form','','','30','1','test:test:view,test:test:edit','','1','41569','1','41569','1');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('88','62','0,1,62,','通知通告','','','','20','1','','','1','41586','1','41586','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('89','88','0,1,62,88,','我的通告','/oa/oaNotify/self','','','30','1','','','1','41586','1','41586','0');INSERT INTO `sys_menu` (`id`,`parent_id`,`parent_ids`,`name`,`href`,`target`,`icon`,`sort`,`is_show`,`permission`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('90','88','0,1,62,88,','通告管理','/oa/oaNotify','','','50','1','oa:oaNotify:view,oa:oaNotify:edit','','1','41586','1','41586','0');#####################################sys_role#####################################INSERT INTO `sys_role` (`id`,`office_id`,`name`,`enname`,`role_type`,`data_scope`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('1','1','系统管理员','dept','assignment','1','','1','1','41421','1','41421','0');INSERT INTO `sys_role` (`id`,`office_id`,`name`,`enname`,`role_type`,`data_scope`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('2','1','公司管理员','hr','assignment','2','','1','1','41421','1','41421','0');INSERT INTO `sys_role` (`id`,`office_id`,`name`,`enname`,`role_type`,`data_scope`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('3','1','本公司管理员','a','assignment','3','','1','1','41421','1','41421','0');INSERT INTO `sys_role` (`id`,`office_id`,`name`,`enname`,`role_type`,`data_scope`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('4','1','部门管理员','b','assignment','4','','1','1','41421','1','41421','0');INSERT INTO `sys_role` (`id`,`office_id`,`name`,`enname`,`role_type`,`data_scope`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('5','1','本部门管理员','c','assignment','5','','1','1','41421','1','41421','0');INSERT INTO `sys_role` (`id`,`office_id`,`name`,`enname`,`role_type`,`data_scope`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('6','1','普通用户','d','assignment','8','','1','1','41421','1','41421','0');INSERT INTO `sys_role` (`id`,`office_id`,`name`,`enname`,`role_type`,`data_scope`,`remarks`,`useable`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('7','7','济南市管理员','e','assignment','9','','1','1','41421','1','41421','0');#####################################sys_role_menu#####################################INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','1');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','2');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','3');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','4');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','5');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','6');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','7');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','8');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','9');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','10');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','11');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','12');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','13');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','14');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','15');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','16');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','17');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','18');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','19');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','20');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','21');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','22');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','23');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','24');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','25');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','26');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','27');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','28');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','29');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','30');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','31');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','32');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','33');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','34');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','35');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','36');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','37');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','38');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','39');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','40');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','41');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','42');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','43');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','44');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','45');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','46');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','47');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','48');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','49');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','50');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','51');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','52');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','53');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','54');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','55');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','56');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','57');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','58');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','59');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','60');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','61');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','62');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','63');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','64');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','65');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','66');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','67');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','68');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','69');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','70');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','71');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','72');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','73');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','74');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','75');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','76');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','77');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','78');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','79');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','80');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','81');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','82');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','83');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','84');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','85');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','86');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','87');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','88');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','89');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('1','90');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','1');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','2');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','3');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','4');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','5');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','6');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','7');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','8');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','9');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','10');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','11');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','12');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','13');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','14');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','15');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','16');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','17');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','18');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','19');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','20');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','21');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','22');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','23');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','24');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','25');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','26');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','27');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','28');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','29');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','30');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','31');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','32');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','33');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','34');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','35');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','36');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','37');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','38');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','39');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','40');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','41');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','42');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','43');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','44');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','45');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','46');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','47');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','48');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','49');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','50');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','51');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','52');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','53');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','54');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','55');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','56');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','57');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','58');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','59');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','60');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','61');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','62');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','63');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','64');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','65');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','66');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','67');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','68');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','69');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','70');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','71');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','72');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','73');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','74');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','75');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','76');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','77');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','78');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','79');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','80');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','81');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','82');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','83');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','84');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','85');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','86');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','87');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','88');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','89');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('2','90');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','1');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','2');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','3');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','4');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','5');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','6');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','7');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','8');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','9');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','10');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','11');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','12');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','13');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','14');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','15');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','16');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','17');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','18');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','19');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','20');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','21');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','22');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','23');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','24');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','25');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','26');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','27');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','28');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','29');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','30');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','31');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','32');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','33');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','34');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','35');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','36');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','37');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','38');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','39');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','40');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','41');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','42');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','43');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','44');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','45');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','46');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','47');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','48');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','49');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','50');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','51');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','52');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','53');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','54');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','55');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','56');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','57');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','58');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','59');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','60');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','61');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','62');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','63');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','64');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','65');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','66');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','67');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','68');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','69');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','70');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','71');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','72');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','73');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','74');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','75');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','76');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','77');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','78');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','79');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','80');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','81');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','82');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','83');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','84');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','85');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','86');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','87');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','88');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','89');INSERT INTO `sys_role_menu` (`role_id`,`menu_id`) VALUES ('3','90');#####################################sys_role_office#####################################INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','7');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','8');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','9');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','10');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','11');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','12');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','13');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','14');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','15');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','16');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','17');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','18');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','19');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','20');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','21');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','22');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','23');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','24');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','25');INSERT INTO `sys_role_office` (`role_id`,`office_id`) VALUES ('7','26');#####################################sys_user#####################################INSERT INTO `sys_user` (`id`,`company_id`,`office_id`,`login_name`,`password`,`no`,`name`,`email`,`phone`,`mobile`,`user_type`,`remarks`,`login_flag`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('1','1','2','thinkgem','02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032','0001','系统管理员','[e-mail]','8675','8675','','最高管理员','1','1','41421','1','41421','0');INSERT INTO `sys_user` (`id`,`company_id`,`office_id`,`login_name`,`password`,`no`,`name`,`email`,`phone`,`mobile`,`user_type`,`remarks`,`login_flag`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('2','1','2','sd_admin','02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032','0002','管理员','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_user` (`id`,`company_id`,`office_id`,`login_name`,`password`,`no`,`name`,`email`,`phone`,`mobile`,`user_type`,`remarks`,`login_flag`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('3','1','3','sd_zhb','02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032','0003','综合部','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_user` (`id`,`company_id`,`office_id`,`login_name`,`password`,`no`,`name`,`email`,`phone`,`mobile`,`user_type`,`remarks`,`login_flag`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('4','1','4','sd_scb','02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032','0004','市场部','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_user` (`id`,`company_id`,`office_id`,`login_name`,`password`,`no`,`name`,`email`,`phone`,`mobile`,`user_type`,`remarks`,`login_flag`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('5','1','5','sd_jsb','02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032','0005','技术部','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_user` (`id`,`company_id`,`office_id`,`login_name`,`password`,`no`,`name`,`email`,`phone`,`mobile`,`user_type`,`remarks`,`login_flag`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('6','1','6','sd_yfb','02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032','0006','研发部','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_user` (`id`,`company_id`,`office_id`,`login_name`,`password`,`no`,`name`,`email`,`phone`,`mobile`,`user_type`,`remarks`,`login_flag`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('7','7','8','jn_admin','02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032','0007','济南领导','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_user` (`id`,`company_id`,`office_id`,`login_name`,`password`,`no`,`name`,`email`,`phone`,`mobile`,`user_type`,`remarks`,`login_flag`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('8','7','9','jn_zhb','02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032','0008','济南综合部','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_user` (`id`,`company_id`,`office_id`,`login_name`,`password`,`no`,`name`,`email`,`phone`,`mobile`,`user_type`,`remarks`,`login_flag`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('9','7','10','jn_scb','02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032','0009','济南市场部','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_user` (`id`,`company_id`,`office_id`,`login_name`,`password`,`no`,`name`,`email`,`phone`,`mobile`,`user_type`,`remarks`,`login_flag`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('10','7','11','jn_jsb','02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032','0010','济南技术部','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_user` (`id`,`company_id`,`office_id`,`login_name`,`password`,`no`,`name`,`email`,`phone`,`mobile`,`user_type`,`remarks`,`login_flag`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('11','12','13','lc_admin','02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032','0011','济南历城领导','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_user` (`id`,`company_id`,`office_id`,`login_name`,`password`,`no`,`name`,`email`,`phone`,`mobile`,`user_type`,`remarks`,`login_flag`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('12','12','18','lx_admin','02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032','0012','济南历下领导','','','','','','1','1','41421','1','41421','0');INSERT INTO `sys_user` (`id`,`company_id`,`office_id`,`login_name`,`password`,`no`,`name`,`email`,`phone`,`mobile`,`user_type`,`remarks`,`login_flag`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('13','22','23','gx_admin','02a3f0772fcca9f415adc990734b45c6f059c7d33ee28362c4852032','0013','济南高新领导','','','','','','1','1','41421','1','41421','0');#####################################sys_user_role#####################################INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('1','1');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('2','1');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('3','2');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('4','3');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('5','4');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('6','5');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('7','2');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('7','7');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('8','2');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('9','1');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('10','2');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('11','3');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('12','4');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('13','5');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('14','6');INSERT INTO `sys_user_role` (`user_id`,`role_id`) VALUES ('1','2');#####################################sys_dict#####################################INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('1','正常','0','del_flag','删除标记','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('2','删除','1','del_flag','删除标记','20','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('3','显示','1','show_hide','显示/隐藏','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('4','隐藏','0','show_hide','显示/隐藏','20','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('5','是','1','yes_no','是/否','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('6','否','0','yes_no','是/否','20','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('7','红色','red','color','颜色值','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('8','绿色','green','color','颜色值','20','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('9','蓝色','blue','color','颜色值','30','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('10','黄色','yellow','color','颜色值','40','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('11','橙色','orange','color','颜色值','50','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('12','默认主题','default','theme','主题方案','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('13','天蓝主题','cerulean','theme','主题方案','20','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('14','橙色主题','readable','theme','主题方案','30','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('15','红色主题','united','theme','主题方案','40','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('16','Flat主题','flat','theme','主题方案','60','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('17','国家','1','sys_area_type','区域类型','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('18','省份、直辖市','2','sys_area_type','区域类型','20','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('19','地市','3','sys_area_type','区域类型','30','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('20','区县','4','sys_area_type','区域类型','40','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('21','公司','1','sys_office_type','机构类型','60','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('22','部门','2','sys_office_type','机构类型','70','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('23','小组','3','sys_office_type','机构类型','80','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('24','其它','4','sys_office_type','机构类型','90','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('25','综合部','1','sys_office_common','快捷通用部门','30','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('26','开发部','2','sys_office_common','快捷通用部门','40','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('27','人力部','3','sys_office_common','快捷通用部门','50','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('28','一级','1','sys_office_grade','机构等级','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('29','二级','2','sys_office_grade','机构等级','20','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('30','三级','3','sys_office_grade','机构等级','30','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('31','四级','4','sys_office_grade','机构等级','40','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('32','所有数据','1','sys_data_scope','数据范围','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('33','所在公司及以下数据','2','sys_data_scope','数据范围','20','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('34','所在公司数据','3','sys_data_scope','数据范围','30','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('35','所在部门及以下数据','4','sys_data_scope','数据范围','40','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('36','所在部门数据','5','sys_data_scope','数据范围','50','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('37','仅本人数据','8','sys_data_scope','数据范围','90','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('38','按明细设置','9','sys_data_scope','数据范围','100','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('39','系统管理','1','sys_user_type','用户类型','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('40','部门经理','2','sys_user_type','用户类型','20','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('41','普通用户','3','sys_user_type','用户类型','30','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('42','基础主题','basic','cms_theme','站点主题','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('43','蓝色主题','blue','cms_theme','站点主题','20','','1','41421','1','41421','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('44','红色主题','red','cms_theme','站点主题','30','','1','41421','1','41421','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('45','文章模型','article','cms_module','栏目模型','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('46','图片模型','picture','cms_module','栏目模型','20','','1','41421','1','41421','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('47','下载模型','download','cms_module','栏目模型','30','','1','41421','1','41421','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('48','链接模型','link','cms_module','栏目模型','40','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('49','专题模型','special','cms_module','栏目模型','50','','1','41421','1','41421','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('50','默认展现方式','0','cms_show_modes','展现方式','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('51','首栏目内容列表','1','cms_show_modes','展现方式','20','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('52','栏目第一条内容','2','cms_show_modes','展现方式','30','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('53','发布','0','cms_del_flag','内容状态','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('54','删除','1','cms_del_flag','内容状态','20','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('55','审核','2','cms_del_flag','内容状态','15','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('56','首页焦点图','1','cms_posid','推荐位','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('57','栏目页文章推荐','2','cms_posid','推荐位','20','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('58','咨询','1','cms_guestbook','留言板分类','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('59','建议','2','cms_guestbook','留言板分类','20','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('60','投诉','3','cms_guestbook','留言板分类','30','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('61','其它','4','cms_guestbook','留言板分类','40','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('62','公休','1','oa_leave_type','请假类型','10','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('63','病假','2','oa_leave_type','请假类型','20','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('64','事假','3','oa_leave_type','请假类型','30','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('65','调休','4','oa_leave_type','请假类型','40','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('66','婚假','5','oa_leave_type','请假类型','60','','1','41421','1','41421','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('67','接入日志','1','sys_log_type','日志类型','30','','1','41428','1','41428','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('68','异常日志','2','sys_log_type','日志类型','40','','1','41428','1','41428','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('69','请假流程','leave','act_type','流程类型','10','','1','41428','1','41428','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('70','审批测试流程','test_audit','act_type','流程类型','20','','1','41428','1','41428','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('71','分类1','1','act_category','流程分类','10','','1','41428','1','41428','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('72','分类2','2','act_category','流程分类','20','','1','41428','1','41428','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('73','增删改查','crud','gen_category','代码生成分类','10','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('74','增删改查（包含从表）','crud_many','gen_category','代码生成分类','20','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('75','树结构','tree','gen_category','代码生成分类','30','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('76','=','=','gen_query_type','查询方式','10','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('77','!=','!=','gen_query_type','查询方式','20','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('78','>','>','gen_query_type','查询方式','30','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('79','<','<','gen_query_type','查询方式','40','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('80','Between','between','gen_query_type','查询方式','50','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('81','Like','like','gen_query_type','查询方式','60','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('82','Left Like','left_like','gen_query_type','查询方式','70','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('83','Right Like','right_like','gen_query_type','查询方式','80','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('84','文本框','input','gen_show_type','字段生成方案','10','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('85','文本域','textarea','gen_show_type','字段生成方案','20','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('86','下拉框','select','gen_show_type','字段生成方案','30','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('87','复选框','checkbox','gen_show_type','字段生成方案','40','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('88','单选框','radiobox','gen_show_type','字段生成方案','50','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('89','日期选择','dateselect','gen_show_type','字段生成方案','60','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('90','人员选择','userselect','gen_show_type','字段生成方案','70','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('91','部门选择','officeselect','gen_show_type','字段生成方案','80','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('92','区域选择','areaselect','gen_show_type','字段生成方案','90','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('93','String','String','gen_java_type','Java类型','10','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('94','Long','Long','gen_java_type','Java类型','20','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('95','仅持久层','dao','gen_category','代码生成分类','40','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('96','男','1','sex','性别','10','','1','41575','1','41575','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('97','女','2','sex','性别','20','','1','41575','1','41575','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('98','Integer','Integer','gen_java_type','Java类型','30','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('99','Double','Double','gen_java_type','Java类型','40','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('100','Date','java.util.Date','gen_java_type','Java类型','50','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('101','User','com.thinkgem.jeesite.modules.sys.entity.User','gen_java_type','Java类型','60','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('102','Office','com.thinkgem.jeesite.modules.sys.entity.Office','gen_java_type','Java类型','70','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('103','Area','com.thinkgem.jeesite.modules.sys.entity.Area','gen_java_type','Java类型','80','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('104','Custom','Custom','gen_java_type','Java类型','90','','1','41575','1','41575','1');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('105','会议通告','1','oa_notify_type','通知通告类型','10','','1','41586','1','41586','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('106','奖惩通告','2','oa_notify_type','通知通告类型','20','','1','41586','1','41586','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('107','活动通告','3','oa_notify_type','通知通告类型','30','','1','41586','1','41586','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('108','草稿','0','oa_notify_status','通知通告状态','10','','1','41586','1','41586','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('109','发布','1','oa_notify_status','通知通告状态','20','','1','41586','1','41586','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('110','未读','0','oa_notify_read','通知通告状态','10','','1','41586','1','41586','0');INSERT INTO `sys_dict` (`id`,`label`,`value`,`type`,`description`,`sort`,`remarks`,`create_by`,`create_date`,`update_by`,`update_date`,`del_flag`) VALUES ('111','已读','1','oa_notify_read','通知通告状态','20','','1','41586','1','41586','0');#####################################sys_mdict#####################################

解决时间问题。更新字段：

SET SQL_SAFE_UPDATES=0;update sys_area set create_date = now() ,update_date = now();update sys_office set create_date = now() ,update_date = now();update sys_menu set create_date = now() ,update_date = now();update sys_role set create_date = now() ,update_date = now();update sys_user set create_date = now() ,update_date = now();update sys_dict set create_date = now() ,update_date = now();update sys_mdict set create_date = now() ,update_date = now();

4，终于启动成功了

使用管理员登陆：（最高管理员默认账号：thinkgem 密码：admin）。

登陆之后可以看到菜单：
可以看到我的任务里面菜单：

最厉害的是自带代码生成：

可以自己生成代码。

5，总结

本文的原文连接是: http://blog.csdn.net/freewebsys/article/details/50954485 未经博主允许不得转载。
博主地址是：http://blog.csdn.net/freewebsys

JeeSite非常不错，不错的开源项目。
SpringSide是 基于hibernate的，功能比较简单。
这个是基于mybatis，而且直接可以跑的程序项目。
继续学习，看看代码。