ins_cxtj_dm.sql

公务员管理系统

--清空统计代码表
DELETE FROM TJ_BBXX;
DELETE FROM TJ_BBSQL;

INSERT INTO TJ_BBXX(BBDM,BBMC,LINK,BBLX) VALUES ('a1','劳动保障公务案件统计表','a1.jsp','01');
INSERT INTO TJ_BBXX(BBDM,BBMC,LINK,BBLX) VALUES ('a2','劳动保障公务专项工作统计表','a2.jsp','01');
INSERT INTO TJ_BBXX(BBDM,BBMC,LINK,BBLX) VALUES ('a3','劳动保障公务效果统计表','a3.jsp','01');
INSERT INTO TJ_BBXX(BBDM,BBMC,LINK,BBLX) VALUES ('a4','劳动保障公务组织统计表','a4.jsp','01');
INSERT INTO TJ_BBXX(BBDM,BBMC,LINK,BBLX) VALUES ('b1','劳动保障公务案件统计表','b1.jsp','01');
INSERT INTO TJ_BBXX(BBDM,BBMC,LINK,BBLX) VALUES ('b2','劳动保障公务效果及专项工作统计表','b2.jsp','01');
INSERT INTO TJ_BBXX(BBDM,BBMC,LINK,BBLX) VALUES ('b3','劳动保障公务组织统计表','b3.jsp','01');
INSERT INTO TJ_BBXX(BBDM,BBMC,LINK,BBLX) VALUES ('c1','开展对用人单位参加社会保险执法大检查情况统计表','c1.jsp','02');
INSERT INTO TJ_BBXX(BBDM,BBMC,LINK,BBLX) VALUES ('c2','	群众举报件办理情况汇总表','c2.jsp','02');
INSERT INTO TJ_BBXX(BBDM,BBMC,LINK,BBLX) VALUES ('c3','	群众举报件办理情况明细表','c3.jsp','02');


commit;
insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a1','1','0','select 1 xh,sum(decode(aj_flag,''03'',1,''04'',1,0)) col1,sum(decode(ajlb,''01'',1,0)) col2,sum(decode(ajlb,''02'',1,0)) col3
			,sum(decode(ajlb,''03'',1,0)) col4,sum(decode(ajlb,''04'',1,0)) col5,sum(decode(ajlb,''05'',1,0)) col6
			,sum(decode(ajlb,''06'',1,0)) col7,sum(decode(ajlb,''07'',1,0)) col8,sum(decode(ajlb,''08'',1,0)) col9
			,sum(decode(ajlb,''09'',1,0)) col10,sum(decode(ajlb,''10'',1,0)) col11,sum(decode(ajlb,''11'',1,0)) col12
			,sum(decode(ajlb,''12'',1,0)) col13,sum(decode(ajlb,''13'',1,0)) col14,sum(decode(ajlb,''14'',1,0)) col15
			,sum(decode(ajlb,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col16
			,sum(zlgzjs) col17,sum(xzcljs) col18,sum(xzcfjs) col19,sum(jgjs) col20,sum(fkjs) col21,sum(fkje) col22
			,sum(qtjs) col23,sum(qzzxjs) col24,'''' col25,'''' col26
	from v_a1 where 1=1
','','01','','01','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a1','2','0','select 2 xh,sum(decode(aj_flag,''03'',1,''04'',1,0)) col1,sum(decode(ajlb,''01'',1,0)) col2,sum(decode(ajlb,''02'',1,0)) col3
			,sum(decode(ajlb,''03'',1,0)) col4,sum(decode(ajlb,''04'',1,0)) col5,sum(decode(ajlb,''05'',1,0)) col6
			,sum(decode(ajlb,''06'',1,0)) col7,sum(decode(ajlb,''07'',1,0)) col8,sum(decode(ajlb,''08'',1,0)) col9
			,sum(decode(ajlb,''09'',1,0)) col10,sum(decode(ajlb,''10'',1,0)) col11,sum(decode(ajlb,''11'',1,0)) col12
			,sum(decode(ajlb,''12'',1,0)) col13,sum(decode(ajlb,''13'',1,0)) col14,sum(decode(ajlb,''14'',1,0)) col15
			,sum(decode(ajlb,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col16
			,sum(zlgzjs) col17,sum(xzcljs) col18,sum(xzcfjs) col19,sum(jgjs) col20,sum(fkjs) col21,sum(fkje) col22
			,sum(qtjs) col23,sum(qzzxjs) col24,'''' col25,'''' col26
	from v_a1
 where 1=1 and dwxz = ''01''
','','01','','02','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a1','3','0','select 3 xh,sum(decode(aj_flag,''03'',1,''04'',1,0)) col1,sum(decode(ajlb,''01'',1,0)) col2,sum(decode(ajlb,''02'',1,0)) col3
			,sum(decode(ajlb,''03'',1,0)) col4,sum(decode(ajlb,''04'',1,0)) col5,sum(decode(ajlb,''05'',1,0)) col6
			,sum(decode(ajlb,''06'',1,0)) col7,sum(decode(ajlb,''07'',1,0)) col8,sum(decode(ajlb,''08'',1,0)) col9
			,sum(decode(ajlb,''09'',1,0)) col10,sum(decode(ajlb,''10'',1,0)) col11,sum(decode(ajlb,''11'',1,0)) col12
			,sum(decode(ajlb,''12'',1,0)) col13,sum(decode(ajlb,''13'',1,0)) col14,sum(decode(ajlb,''14'',1,0)) col15
			,sum(decode(ajlb,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col16
			,sum(zlgzjs) col17,sum(xzcljs) col18,sum(xzcfjs) col19,sum(jgjs) col20,sum(fkjs) col21,sum(fkje) col22
			,sum(qtjs) col23,sum(qzzxjs) col24,'''' col25,'''' col26
	from v_a1
 where 1=1 and dwxz = ''02''
','','01','','03','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a1','4','0','select 4 xh,sum(decode(aj_flag,''03'',1,''04'',1,0)) col1,sum(decode(ajlb,''01'',1,0)) col2,sum(decode(ajlb,''02'',1,0)) col3
			,sum(decode(ajlb,''03'',1,0)) col4,sum(decode(ajlb,''04'',1,0)) col5,sum(decode(ajlb,''05'',1,0)) col6
			,sum(decode(ajlb,''06'',1,0)) col7,sum(decode(ajlb,''07'',1,0)) col8,sum(decode(ajlb,''08'',1,0)) col9
			,sum(decode(ajlb,''09'',1,0)) col10,sum(decode(ajlb,''10'',1,0)) col11,sum(decode(ajlb,''11'',1,0)) col12
			,sum(decode(ajlb,''12'',1,0)) col13,sum(decode(ajlb,''13'',1,0)) col14,sum(decode(ajlb,''14'',1,0)) col15
			,sum(decode(ajlb,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col16
			,sum(zlgzjs) col17,sum(xzcljs) col18,sum(xzcfjs) col19,sum(jgjs) col20,sum(fkjs) col21,sum(fkje) col22
			,sum(qtjs) col23,sum(qzzxjs) col24,'''' col25,'''' col26
	from v_a1
 where 1=1 and dwxz = ''03''
','','01','','04','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a1','5','0','select 5 xh,sum(decode(aj_flag,''03'',1,''04'',1,0)) col1,sum(decode(ajlb,''01'',1,0)) col2,sum(decode(ajlb,''02'',1,0)) col3
			,sum(decode(ajlb,''03'',1,0)) col4,sum(decode(ajlb,''04'',1,0)) col5,sum(decode(ajlb,''05'',1,0)) col6
			,sum(decode(ajlb,''06'',1,0)) col7,sum(decode(ajlb,''07'',1,0)) col8,sum(decode(ajlb,''08'',1,0)) col9
			,sum(decode(ajlb,''09'',1,0)) col10,sum(decode(ajlb,''10'',1,0)) col11,sum(decode(ajlb,''11'',1,0)) col12
			,sum(decode(ajlb,''12'',1,0)) col13,sum(decode(ajlb,''13'',1,0)) col14,sum(decode(ajlb,''14'',1,0)) col15
			,sum(decode(ajlb,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col16
			,sum(zlgzjs) col17,sum(xzcljs) col18,sum(xzcfjs) col19,sum(jgjs) col20,sum(fkjs) col21,sum(fkje) col22
			,sum(qtjs) col23,sum(qzzxjs) col24,'''' col25,'''' col26
	from v_a1
 where 1=1 and dwxz = ''04''
','','01','','05','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a1','6','0','select 6 xh,sum(decode(aj_flag,''03'',1,''04'',1,0)) col1,sum(decode(ajlb,''01'',1,0)) col2,sum(decode(ajlb,''02'',1,0)) col3
			,sum(decode(ajlb,''03'',1,0)) col4,sum(decode(ajlb,''04'',1,0)) col5,sum(decode(ajlb,''05'',1,0)) col6
			,sum(decode(ajlb,''06'',1,0)) col7,sum(decode(ajlb,''07'',1,0)) col8,sum(decode(ajlb,''08'',1,0)) col9
			,sum(decode(ajlb,''09'',1,0)) col10,sum(decode(ajlb,''10'',1,0)) col11,sum(decode(ajlb,''11'',1,0)) col12
			,sum(decode(ajlb,''12'',1,0)) col13,sum(decode(ajlb,''13'',1,0)) col14,sum(decode(ajlb,''14'',1,0)) col15
			,sum(decode(ajlb,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col16
			,sum(zlgzjs) col17,sum(xzcljs) col18,sum(xzcfjs) col19,sum(jgjs) col20,sum(fkjs) col21,sum(fkje) col22
			,sum(qtjs) col23,sum(qzzxjs) col24,'''' col25,'''' col26
	from v_a1
 where 1=1 and dwxz = ''05''
','','01','','06','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a1','7','0','select 7 xh,sum(decode(aj_flag,''03'',1,''04'',1,0)) col1,sum(decode(ajlb,''01'',1,0)) col2,sum(decode(ajlb,''02'',1,0)) col3
			,sum(decode(ajlb,''03'',1,0)) col4,sum(decode(ajlb,''04'',1,0)) col5,sum(decode(ajlb,''05'',1,0)) col6
			,sum(decode(ajlb,''06'',1,0)) col7,sum(decode(ajlb,''07'',1,0)) col8,sum(decode(ajlb,''08'',1,0)) col9
			,sum(decode(ajlb,''09'',1,0)) col10,sum(decode(ajlb,''10'',1,0)) col11,sum(decode(ajlb,''11'',1,0)) col12
			,sum(decode(ajlb,''12'',1,0)) col13,sum(decode(ajlb,''13'',1,0)) col14,sum(decode(ajlb,''14'',1,0)) col15
			,sum(decode(ajlb,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col16
			,sum(zlgzjs) col17,sum(xzcljs) col18,sum(xzcfjs) col19,sum(jgjs) col20,sum(fkjs) col21,sum(fkje) col22
			,sum(qtjs) col23,sum(qzzxjs) col24,'''' col25,'''' col26
	from v_a1
 where 1=1 and dwxz = ''06''
','','01','','07','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a1','8','0','select 8 xh,sum(decode(aj_flag,''03'',1,''04'',1,0)) col1,sum(decode(ajlb,''01'',1,0)) col2,sum(decode(ajlb,''02'',1,0)) col3
			,sum(decode(ajlb,''03'',1,0)) col4,sum(decode(ajlb,''04'',1,0)) col5,sum(decode(ajlb,''05'',1,0)) col6
			,sum(decode(ajlb,''06'',1,0)) col7,sum(decode(ajlb,''07'',1,0)) col8,sum(decode(ajlb,''08'',1,0)) col9
			,sum(decode(ajlb,''09'',1,0)) col10,sum(decode(ajlb,''10'',1,0)) col11,sum(decode(ajlb,''11'',1,0)) col12
			,sum(decode(ajlb,''12'',1,0)) col13,sum(decode(ajlb,''13'',1,0)) col14,sum(decode(ajlb,''14'',1,0)) col15
			,sum(decode(ajlb,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col16
			,sum(zlgzjs) col17,sum(xzcljs) col18,sum(xzcfjs) col19,sum(jgjs) col20,sum(fkjs) col21,sum(fkje) col22
			,sum(qtjs) col23,sum(qzzxjs) col24,'''' col25,'''' col26
	from v_a1
 where 1=1 and dwxz = ''07''
','','01','','08','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a1','9','0','select 9 xh,sum(decode(aj_flag,''03'',1,''04'',1,0)) col1,sum(decode(ajlb,''01'',1,0)) col2,sum(decode(ajlb,''02'',1,0)) col3
			,sum(decode(ajlb,''03'',1,0)) col4,sum(decode(ajlb,''04'',1,0)) col5,sum(decode(ajlb,''05'',1,0)) col6
			,sum(decode(ajlb,''06'',1,0)) col7,sum(decode(ajlb,''07'',1,0)) col8,sum(decode(ajlb,''08'',1,0)) col9
			,sum(decode(ajlb,''09'',1,0)) col10,sum(decode(ajlb,''10'',1,0)) col11,sum(decode(ajlb,''11'',1,0)) col12
			,sum(decode(ajlb,''12'',1,0)) col13,sum(decode(ajlb,''13'',1,0)) col14,sum(decode(ajlb,''14'',1,0)) col15
			,sum(decode(ajlb,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col16
			,sum(zlgzjs) col17,sum(xzcljs) col18,sum(xzcfjs) col19,sum(jgjs) col20,sum(fkjs) col21,sum(fkje) col22
			,sum(qtjs) col23,sum(qzzxjs) col24,'''' col25,'''' col26
	from v_a1
 where 1=1 and dwxz = ''08''
','','01','','09','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a2','2','0','select 2 xh,count(distinct(decode(jctj,''02'',dwid,''03'',dwid))) col1,sum(decode(jctj,''02'',ldzrs,''03'',ldzrs,0)) col2
			,sum(decode(jctj,''01'',1,0)) col3,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)) col4
			,sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0)) col5,sum(decode(jctj,''01'',ldzrs,0)) col6
			,sum(decode(jctj,''01'',decode(aj_flag,''02'',1,0),0)) col7
			,round((sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0))*100/decode(sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)),0,null,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)))),2) col8
			,'''' col9,count(distinct(decode(jctj,''04'',dwid))) col10,sum(decode(jctj,''04'',ldzrs,0)) col11,'''' col12
			,'''' col13,count(distinct(dwid)) col14,sum(decode(jzcs,null,0,jzcs)) col15
	from v_a2_1
 where 1=1 and dwxz = ''01''
','','01','','02','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a2','1','0','select 1 xh,count(distinct(decode(jctj,''02'',dwid,''03'',dwid))) col1,sum(decode(jctj,''02'',ldzrs,''03'',ldzrs,0)) col2
			,sum(decode(jctj,''01'',1,0)) col3,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)) col4
			,sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0)) col5,sum(decode(jctj,''01'',ldzrs,0)) col6
			,sum(decode(jctj,''01'',decode(aj_flag,''02'',1,0),0)) col7
			,round((sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0))*100/decode(sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)),0,null,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)))),2) col8
			,'''' col9,count(distinct(decode(jctj,''04'',dwid))) col10,sum(decode(jctj,''04'',ldzrs,0)) col11,'''' col12
			,'''' col13,count(distinct(dwid)) col14,sum(decode(jzcs,null,0,jzcs)) col15
	from v_a2_1
 where 1=1
','','01','','01','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a2','3','0','select 3 xh,count(distinct(decode(jctj,''02'',dwid,''03'',dwid))) col1,sum(decode(jctj,''02'',ldzrs,''03'',ldzrs,0)) col2
			,sum(decode(jctj,''01'',1,0)) col3,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)) col4
			,sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0)) col5,sum(decode(jctj,''01'',ldzrs,0)) col6
			,sum(decode(jctj,''01'',decode(aj_flag,''02'',1,0),0)) col7
			,round((sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0))*100/decode(sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)),0,null,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)))),2) col8
			,'''' col9,count(distinct(decode(jctj,''04'',dwid))) col10,sum(decode(jctj,''04'',ldzrs,0)) col11,'''' col12
			,'''' col13,count(distinct(dwid)) col14,sum(decode(jzcs,null,0,jzcs)) col15
	from v_a2_1
 where 1=1 and dwxz = ''02''
','','01','','03','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a2','4','0','select 4 xh,count(distinct(decode(jctj,''02'',dwid,''03'',dwid))) col1,sum(decode(jctj,''02'',ldzrs,''03'',ldzrs,0)) col2
			,sum(decode(jctj,''01'',1,0)) col3,sum(decode(jctj,''01'',decode(ajid,''0'',0,1),0)) col4
			,sum(decode(jctj,''01'',decode(aj_flag,''04'',1,''03'',1,0),0)) col5,sum(decode(jctj,''01'',ldzrs,0)) col6