ins_cxtj_dm.sql

公务员管理系统

','','01','','05','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','a4','0','7','select 10 xh,sum(pxrs) row1,sum(decode(pxbm,''001'',pxrs,''321'',pxrs,0)) row2
			,sum(decode(pxbm,''001'',0,''321'',0,pxrs)) row3,sum(decode(pxbm,''001'',0,''321'',0,pxrs)) row4
	from v_a4_2
 where 1=1
','','01','','06','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('qx','b3','0','1','select 1 xh,sum(decode(zjlb,''01'',1,0)) row1,sum(decode(zjlb||qx,''01001'',1,0)) row2
			,sum(decode(zjlb,''01'',decode(qx,''001'',0,1),0)) row3
	from v_a4_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('qx','b3','0','2','select 2 xh,sum(decode(zjlb,''02'',1,0)) row1,sum(decode(zjlb||qx,''02001'',1,0)) row2
			,sum(decode(zjlb,''02'',decode(qx,''001'',0,1),0)) row3
	from v_a4_1
 where 1=1
','','01','','02','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','b3','0','3','select 3 xh,sum(1) row1,sum(decode(pxbm,''001'',1,''321'',1,0)) row2,sum(decode(pxbm,''001'',0,''321'',0,1)) row3
	from v_a4_2
 where 1=1
','','01','','03','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','b3','0','4','select 4 xh,sum(pxrs) row1,sum(decode(pxbm,''001'',pxrs,''321'',pxrs,0)) row2,sum(decode(pxbm,''001'',0,''321'',0,pxrs)) row3
	from v_a4_2
 where 1=1
','','01','','04','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','b1','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,''05'',1,0)) col5
			,sum(decode(ajlb,''06'',1,0)) col6,sum(decode(ajlb,''07'',1,0)) col7,sum(decode(ajlb,''08'',1,0)) col8
			,sum(decode(ajlb,''09'',1,0)) col9,sum(decode(ajlb,''10'',1,0)) col10,sum(decode(ajlb,''11'',1,0)) col11
			,sum(decode(ajlb,''12'',1,0)) col12,sum(decode(ajlb,''13'',1,0)) col13,sum(decode(ajlb,''14'',1,0)) col14
			,sum(decode(ajlb,''04'',1,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col15
			,sum(zlgzjs) col16,sum(xzcljs) col17,sum(xzcfjs) col18,sum(jgjs) col19,sum(fkjs) col20
			,sum(qtjs) col21
	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','b1','10','0','select 10 xh,sum(qzzxjs) col1,'''' col2,'''' col3,round(sum(fkje)/10000,3) col4
	from v_a1
 where 1=1
','','01','','10','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','b1','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,''05'',1,0)) col5
			,sum(decode(ajlb,''06'',1,0)) col6,sum(decode(ajlb,''07'',1,0)) col7,sum(decode(ajlb,''08'',1,0)) col8
			,sum(decode(ajlb,''09'',1,0)) col9,sum(decode(ajlb,''10'',1,0)) col10,sum(decode(ajlb,''11'',1,0)) col11
			,sum(decode(ajlb,''12'',1,0)) col12,sum(decode(ajlb,''13'',1,0)) col13,sum(decode(ajlb,''14'',1,0)) col14
			,sum(decode(ajlb,''04'',1,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col15
			,sum(zlgzjs) col16,sum(xzcljs) col17,sum(xzcfjs) col18,sum(jgjs) col19,sum(fkjs) col20
			,sum(qtjs) col21
	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','b1','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,''05'',1,0)) col5
			,sum(decode(ajlb,''06'',1,0)) col6,sum(decode(ajlb,''07'',1,0)) col7,sum(decode(ajlb,''08'',1,0)) col8
			,sum(decode(ajlb,''09'',1,0)) col9,sum(decode(ajlb,''10'',1,0)) col10,sum(decode(ajlb,''11'',1,0)) col11
			,sum(decode(ajlb,''12'',1,0)) col12,sum(decode(ajlb,''13'',1,0)) col13,sum(decode(ajlb,''14'',1,0)) col14
			,sum(decode(ajlb,''04'',1,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col15
			,sum(zlgzjs) col16,sum(xzcljs) col17,sum(xzcfjs) col18,sum(jgjs) col19,sum(fkjs) col20
			,sum(qtjs) col21
	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','b1','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,''05'',1,0)) col5
			,sum(decode(ajlb,''06'',1,0)) col6,sum(decode(ajlb,''07'',1,0)) col7,sum(decode(ajlb,''08'',1,0)) col8
			,sum(decode(ajlb,''09'',1,0)) col9,sum(decode(ajlb,''10'',1,0)) col10,sum(decode(ajlb,''11'',1,0)) col11
			,sum(decode(ajlb,''12'',1,0)) col12,sum(decode(ajlb,''13'',1,0)) col13,sum(decode(ajlb,''14'',1,0)) col14
			,sum(decode(ajlb,''04'',1,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col15
			,sum(zlgzjs) col16,sum(xzcljs) col17,sum(xzcfjs) col18,sum(jgjs) col19,sum(fkjs) col20
			,sum(qtjs) col21
	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','b1','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,''05'',1,0)) col5
			,sum(decode(ajlb,''06'',1,0)) col6,sum(decode(ajlb,''07'',1,0)) col7,sum(decode(ajlb,''08'',1,0)) col8
			,sum(decode(ajlb,''09'',1,0)) col9,sum(decode(ajlb,''10'',1,0)) col10,sum(decode(ajlb,''11'',1,0)) col11
			,sum(decode(ajlb,''12'',1,0)) col12,sum(decode(ajlb,''13'',1,0)) col13,sum(decode(ajlb,''14'',1,0)) col14
			,sum(decode(ajlb,''04'',1,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col15
			,sum(zlgzjs) col16,sum(xzcljs) col17,sum(xzcfjs) col18,sum(jgjs) col19,sum(fkjs) col20
			,sum(qtjs) col21
	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','b1','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,''05'',1,0)) col5
			,sum(decode(ajlb,''06'',1,0)) col6,sum(decode(ajlb,''07'',1,0)) col7,sum(decode(ajlb,''08'',1,0)) col8
			,sum(decode(ajlb,''09'',1,0)) col9,sum(decode(ajlb,''10'',1,0)) col10,sum(decode(ajlb,''11'',1,0)) col11
			,sum(decode(ajlb,''12'',1,0)) col12,sum(decode(ajlb,''13'',1,0)) col13,sum(decode(ajlb,''14'',1,0)) col14
			,sum(decode(ajlb,''04'',1,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col15
			,sum(zlgzjs) col16,sum(xzcljs) col17,sum(xzcfjs) col18,sum(jgjs) col19,sum(fkjs) col20
			,sum(qtjs) col21
	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','b1','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,''05'',1,0)) col5
			,sum(decode(ajlb,''06'',1,0)) col6,sum(decode(ajlb,''07'',1,0)) col7,sum(decode(ajlb,''08'',1,0)) col8
			,sum(decode(ajlb,''09'',1,0)) col9,sum(decode(ajlb,''10'',1,0)) col10,sum(decode(ajlb,''11'',1,0)) col11
			,sum(decode(ajlb,''12'',1,0)) col12,sum(decode(ajlb,''13'',1,0)) col13,sum(decode(ajlb,''14'',1,0)) col14
			,sum(decode(ajlb,''04'',1,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col15
			,sum(zlgzjs) col16,sum(xzcljs) col17,sum(xzcfjs) col18,sum(jgjs) col19,sum(fkjs) col20
			,sum(qtjs) col21
	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','b1','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,''05'',1,0)) col5
			,sum(decode(ajlb,''06'',1,0)) col6,sum(decode(ajlb,''07'',1,0)) col7,sum(decode(ajlb,''08'',1,0)) col8
			,sum(decode(ajlb,''09'',1,0)) col9,sum(decode(ajlb,''10'',1,0)) col10,sum(decode(ajlb,''11'',1,0)) col11
			,sum(decode(ajlb,''12'',1,0)) col12,sum(decode(ajlb,''13'',1,0)) col13,sum(decode(ajlb,''14'',1,0)) col14
			,sum(decode(ajlb,''04'',1,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col15
			,sum(zlgzjs) col16,sum(xzcljs) col17,sum(xzcfjs) col18,sum(jgjs) col19,sum(fkjs) col20
			,sum(qtjs) col21
	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','b1','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,''05'',1,0)) col5
			,sum(decode(ajlb,''06'',1,0)) col6,sum(decode(ajlb,''07'',1,0)) col7,sum(decode(ajlb,''08'',1,0)) col8
			,sum(decode(ajlb,''09'',1,0)) col9,sum(decode(ajlb,''10'',1,0)) col10,sum(decode(ajlb,''11'',1,0)) col11
			,sum(decode(ajlb,''12'',1,0)) col12,sum(decode(ajlb,''13'',1,0)) col13,sum(decode(ajlb,''14'',1,0)) col14
			,sum(decode(ajlb,''04'',1,''15'',1,''16'',1,''17'',1,''18'',1,''19'',1,''20'',1,''21'',1,''22'',1,''23'',1,''24'',1,null,1,0)) col15
			,sum(zlgzjs) col16,sum(xzcljs) col17,sum(xzcfjs) col18,sum(jgjs) col19,sum(fkjs) col20
			,sum(qtjs) col21
	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','b2','0','2','select 2 xh,sum(decode(jctj,''02'',ldzrs,''03'',ldzrs,0)) raw1,sum(decode(dwxz||jctj,''0102'',ldzrs,''0103'',ldzrs,0)) raw2
			,sum(decode(dwxz||jctj,''0202'',ldzrs,''0203'',ldzrs,0)) raw3,sum(decode(dwxz||jctj,''0302'',ldzrs,''0303'',ldzrs,0)) raw4
			,sum(decode(dwxz||jctj,''0402'',ldzrs,''0403'',ldzrs,0)) raw5,sum(decode(dwxz||jctj,''0502'',ldzrs,''0503'',ldzrs,0)) raw6
			,sum(decode(dwxz||jctj,''0602'',ldzrs,''0603'',ldzrs,0)) raw7,sum(decode(dwxz||jctj,''0702'',ldzrs,''0703'',ldzrs,0)) raw8
			,sum(decode(dwxz||jctj,''0802'',ldzrs,''0803'',ldzrs,0)) raw9
	from v_b2_1
 where 1=1
','','01','','02','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','b2','0','3','select 3 xh,sum(decode(jctj,''01'',1,0)) raw1,sum(decode(dwxz||jctj,''0101'',1,0)) raw2
			,sum(decode(dwxz||jctj,''0201'',1,0)) raw3,sum(decode(dwxz||jctj,''0301'',1,0)) raw4
			,sum(decode(dwxz||jctj,''0401'',1,0)) raw5,sum(decode(dwxz||jctj,''0501'',1,0)) raw6
			,sum(decode(dwxz||jctj,''0601'',1,0)) raw7,sum(decode(dwxz||jctj,''0701'',1,0)) raw8
			,sum(decode(dwxz||jctj,''0801'',1,0)) raw9
	from v_b2_2
 where 1=1 and aj_flag in (''03'',''04'')
','','01','','03','0');