init_data.sql

公务员管理系统

insert into qx_information(ID,NAME,DESCRIBE) values('B0500023','公务人员奖惩查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500024','公务人员奖惩修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500025','公务人员奖惩新增','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500026','公务人员奖惩删除','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0100014','单位登记','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500032','培训班管理新增','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500033','培训班管理修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500034','培训班管理删除','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500027','公务组别查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500028','公务组别新增','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500029','公务组别修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500030','公务组别删除','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500031','培训班管理查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500035','公务员培训查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500036','公务员培训新增','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500037','公务员培训修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500038','公务员培训删除','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500039','街道查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500040','街道新增','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500041','街道修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500042','街道删除','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500014','组别查询','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500015','组别新增','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500016','组别删除','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500017','组别修改','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0800001','劳动保障公务案件统计表','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0800002','劳动保障公务专项工作统计表','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0800003','劳动保障公务效果统计表','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0800004','劳动保障公务组织统计表','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0800005','劳动保障公务案件统计表(部级)','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0800006','劳动保障公务专项工作统计表(部级)','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0800007','劳动保障公务组织统计表(部级)','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0500043','公务员证件打印','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0800008','开展对用人单位专项检查情况统计表','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0800009','	群众举报件办理情况汇总表','');
insert into qx_information(ID,NAME,DESCRIBE) values('B0800010','	群众举报件办理情况明细表','');
commit;
DELETE FROM QX_TREE_INF;
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('3','不良信息管理','','','','','0','3');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('4','公务员管理','','','','','0','4');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('5','统计报表','','','','','0','5');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('6','工作用表','','','','','0','6');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('7','法规制度管理','','','','B0900002','0','7');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('8','单位登记','dw/dw_xxcx.jsp','','','B0100004','1','1');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('9','单位减少','dw/dw_jscx.jsp','','','B0100006','1','2');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('10','已减少单位恢复','dw/dw_jscxhf.jsp','','','B0100007','1','3');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('11','执法检查信息查询','dw/zf_jcxxcx.jsp','','','B0200004','2','1');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('12','新增案件','dw/zf_jccx.jsp','','','B0300004','2','2');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('13','案件列表','aj/aj_lb.jsp','','','B0300001','2','3');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('14','案卷管理','anjuan/aj_lb.jsp','','','B0400001','2','4');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('15','新增企业不良信息','bl/bl_ajcx.jsp','','','B0700001','3','1');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('16','上报企业不良信息','bl/bl_cx.jsp','','','B0700002','3','2');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('17','报送企业不良信息','bl/bl_bscx.jsp','','','B0700003','3','3');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('18','公务员登记','JCYGL/jcy_ry_cx_select.jsp','','','B0500001','4','1');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('19','公务员审批','JCYGL/jcy_ry_sp_select.jsp','','','B0500004','4','2');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('20','公务单位管理','JCYGL/jcy_dw_select.jsp','','','B0500007','4','3');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('21','口令修改','qxgl/qx_klgl.jsp','','','B0500008','4','5');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('22','公务员权限管理','qxgl/qx_index.jsp','','','B0500006','4','6');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('23','劳动保障公务案件统计表','tjbb/condition.jsp?bbdm=a1','','','B0800001','5','1');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('24','劳动保障公务专项工作统计表','tjbb/condition.jsp?bbdm=a2','','','B0800002','5','2');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('25','劳动保障公务效果统计表','tjbb/condition.jsp?bbdm=a3','','','B0800003','5','3');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('29','群众举报件办理情况汇总表','gzyb/condition.jsp?bbdm=c2','','','B0800009','6','2');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('30','群众举报件办理情况明细表','gzyb/condition.jsp?bbdm=c3','','','B0800010','6','3');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('1','用人单位信息管理','','','','','0','1');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('31','开展对用人单位专项检查情况统计表','gzyb/condition.jsp?bbdm=c1','','','B0800008','6','1');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('33','新增法规制度','gzzd/fg_xxlr.jsp','','','B0900001','7','1');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('34','查改法规制度','gzzd/fg_xxcx.jsp','','','B0900002','7','2');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('35','培训班管理','JCYGL/jcy_pxb_select.jsp','','','B0500031','4','4');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('36','查看企业不良信息','bl/bl_qbcx.jsp','','','B0700004','3','4');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('37','劳动保障公务组织统计表','tjbb/condition.jsp?bbdm=a4','','','B0800004','5','4');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('2','公务信息管理','','','','','0','2');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('38','劳动保障公务案件统计表(部级)','tjbb/condition.jsp?bbdm=b1','','','B0800005','5','5');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('39','劳动保障公务效果及专项工作统计表(部级)','tjbb/condition.jsp?bbdm=b2','','','B0800006','5','6');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('40','劳动保障公务组织统计表(部级)','tjbb/condition.jsp?bbdm=b3','','','B0800007','5','7');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('41','','','','','','','');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('26','量化考核（人员管理）','','','','','6','1');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('27','全市案件情况','','','','','6','2');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('28','全市企业案件发生情况','','','','','6','3');
insert into qx_tree_inf(ID,MESSAGE,URL,IMAGE,COLOR,IID,LEVER,SX) values('32','劳动保障公务组织统计表','tjbb/condition.jsp','','','','6','5');
COMMIT;

insert into jcy_ry (userid,usercode,qx) values('admin','admin','001')
/
insert into qx_user(USERCODE,USERNAME,SFZH,XB,MZ,CSRQ,ZW,RYZT,FLAG,USERID,PASSWORD,DESCRIBE) values('admin','admin','','','','','','','01','admin','48A8F061FA4B86E2BEA4F082EC630D0D','admin')
/
insert into qx_group(ID,NAME,DESCRIBE) values('1','超级用户','超级用户')
/
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500001');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500002');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500003');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500004');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500006');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500007');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500009');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500010');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500011');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500012');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500013');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500018');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500039');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500040');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500041');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500042');
insert into QX_GROUP_LIST (GID, IID)
values ('1', 'B0500043');
insert into qx_user_group (gid,userid) values('1','admin');
commit;

insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('01','北京市劳动和社会保障局','001','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('02','东城区劳动和社会保障局','101','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('03','西城区劳动和社会保障局','102','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('04','崇文区劳动和社会保障局','103','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('05','宣武区劳动和社会保障局','104','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('06','朝阳区劳动和社会保障局','105','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('07','海淀区劳动和社会保障局','108','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('08','丰台区劳动和社会保障局','106','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('09','石景山区劳动和社会保障局','107','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('10','门头沟区劳动和社会保障局','109','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('11','房山区劳动和社会保障局','111','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('12','通州区劳动和社会保障局','223','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('13','平谷区劳动和社会保障局','226','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('14','昌平区劳动和社会保障局','221','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('15','怀柔区劳动和社会保障局','227','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('16','顺义区劳动和社会保障局','222','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('17','延庆县劳动和社会保障局','229','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('18','密云县劳动和社会保障局','228','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('19','大兴区劳动和社会保障局','224','01');
insert into jcy_dw(dwdm,dwmc,qx,yxbz) values('20','经济技术开发区劳动和社会保障局','231','01');
commit;