ins_cxtj_dm.sql

公务员管理系统

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','b2','0','4','select 4 xh,count(distinct(decode(jctj,''04'',dwid))) raw1,count(distinct(decode(dwxz||jctj,''0104'',dwid))) raw2
			,count(distinct(decode(dwxz||jctj,''0204'',dwid))) raw3,count(distinct(decode(dwxz||jctj,''0304'',dwid))) raw4
			,count(distinct(decode(dwxz||jctj,''0404'',dwid))) raw5,count(distinct(decode(dwxz||jctj,''0504'',dwid))) raw6
			,count(distinct(decode(dwxz||jctj,''0604'',dwid))) raw7,count(distinct(decode(dwxz||jctj,''0704'',dwid))) raw8
			,count(distinct(decode(dwxz||jctj,''0804'',dwid))) raw9
	from v_b2_1
 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','b2','0','5','select 5 xh,sum(decode(jctj,''04'',ldzrs,0)) raw1,sum(decode(dwxz||jctj,''0104'',ldzrs,0)) raw2
			,sum(decode(dwxz||jctj,''0204'',ldzrs,0)) raw3,sum(decode(dwxz||jctj,''0304'',ldzrs,0)) raw4
			,sum(decode(dwxz||jctj,''0404'',ldzrs,0)) raw5,sum(decode(dwxz||jctj,''0504'',ldzrs,0)) raw6
			,sum(decode(dwxz||jctj,''0604'',ldzrs,0)) raw7,sum(decode(dwxz||jctj,''0704'',ldzrs,0)) raw8
			,sum(decode(dwxz||jctj,''0804'',ldzrs,0)) raw9
	from v_b2_1
 where 1=1
','','01','','05','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','b2','0','6','select 6 xh,sum(decode(qzjbtj,''04'',1,0)) raw1,sum(decode(dwxz||qzjbtj,''0104'',1,0)) raw2
			,sum(decode(dwxz||qzjbtj,''0204'',1,0)) raw3,sum(decode(dwxz||qzjbtj,''0304'',1,0)) raw4
			,sum(decode(dwxz||qzjbtj,''0404'',1,0)) raw5,sum(decode(dwxz||qzjbtj,''0504'',1,0)) raw6
			,sum(decode(dwxz||qzjbtj,''0604'',1,0)) raw7,sum(decode(dwxz||qzjbtj,''0704'',1,0)) raw8
			,sum(decode(dwxz||qzjbtj,''0804'',1,0)) raw9
	from v_b2_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('sj$qx','b2','0','7','select 7 xh,sum(decode(qzjbtj,''04'',ldzrs,0)) raw1,sum(decode(dwxz||qzjbtj,''0104'',ldzrs,0)) raw2
			,sum(decode(dwxz||qzjbtj,''0204'',ldzrs,0)) raw3,sum(decode(dwxz||qzjbtj,''0304'',ldzrs,0)) raw4
			,sum(decode(dwxz||qzjbtj,''0404'',ldzrs,0)) raw5,sum(decode(dwxz||qzjbtj,''0504'',ldzrs,0)) raw6
			,sum(decode(dwxz||qzjbtj,''0604'',ldzrs,0)) raw7,sum(decode(dwxz||qzjbtj,''0704'',ldzrs,0)) raw8
			,sum(decode(dwxz||qzjbtj,''0804'',ldzrs,0)) raw9
	from v_b2_2
 where 1=1
','','01','','07','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','b2','0','8','select 8 xh,sum(bqht) raw1,sum(decode(dwxz,''01'',bqht,0)) raw2
			,sum(decode(dwxz,''02'',bqht,0)) raw3,sum(decode(dwxz,''03'',bqht,0)) raw4
			,sum(decode(dwxz,''04'',bqht,0)) raw5,sum(decode(dwxz,''05'',bqht,0)) raw6
			,sum(decode(dwxz,''06'',bqht,0)) raw7,sum(decode(dwxz,''07'',bqht,0)) raw8
			,sum(decode(dwxz,''08'',bqht,0)) raw9
	from v_b2_2
 where 1=1
','','01','','08','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','b2','0','9','select 9 xh,sum(zfgzrs) raw1,sum(decode(dwxz,''01'',zfgzrs,0)) raw2
			,sum(decode(dwxz,''02'',zfgzrs,0)) raw3,sum(decode(dwxz,''03'',zfgzrs,0)) raw4
			,sum(decode(dwxz,''04'',zfgzrs,0)) raw5,sum(decode(dwxz,''05'',zfgzrs,0)) raw6
			,sum(decode(dwxz,''06'',zfgzrs,0)) raw7,sum(decode(dwxz,''07'',zfgzrs,0)) raw8
			,sum(decode(dwxz,''08'',zfgzrs,0)) raw9
	from v_b2_2
 where 1=1
','','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','10','select 10 xh,sum(zfgzje) raw1,sum(decode(dwxz,''01'',zfgzje,0)) raw2
			,sum(decode(dwxz,''02'',zfgzje,0)) raw3,sum(decode(dwxz,''03'',zfgzje,0)) raw4
			,sum(decode(dwxz,''04'',zfgzje,0)) raw5,sum(decode(dwxz,''05'',zfgzje,0)) raw6
			,sum(decode(dwxz,''06'',zfgzje,0)) raw7,sum(decode(dwxz,''07'',zfgzje,0)) raw8
			,sum(decode(dwxz,''08'',zfgzje,0)) raw9
	from v_b2_2
 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','b2','10','0','select 10 xh,sum(ffjg) col1,sum(qttg) col2,round(sum(jydjk)/10000,4) col3,sum(qtwdg) col4,count(decode(zypx||zyzg,null,null,''00'',null,ajid)) col5,round(sum(fxdyjrs)/10000,4) col6
			,round(sum(fxdyjje)/10000,4) col7,'''' col8,sum(decode(jctj,''01'',1,0)) col9,sum(decode(jctj,''01'',decode(aj_flag,''02'',1,0),0)) col10
			,'''' col11,'''' col12,'''' col13,'''' col14
	from v_b2_2
 where 1=1
','','01','','16','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','b2','10','8','select sum(decode(jctj,''01'',1,0)) col8	
	from v_b2_1
 where 1=1
','','01','','17','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','b2','10','12','select round(count(distinct(dwid))/10000,4)  col12
  from v_a2_2
 where 1=1 and sfhg = ''02''
','','01','','18','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','b2','10','13','select round(count(distinct(dwid))/10000,4)  col13
  from v_a2_1
 where 1=1
','','01','','19','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx','b2','10','14','select sum(jzcs)  col14
  from v_a2_1
 where 1=1
','','01','','20','0');

insert into tj_bbsql(SQL_WHERE,BBDM,ROW_ID,COLMUN_ID,SQL,ORDER_BY,TJFS,JSFF,XH,JD) values('sj$qx$zxjc','c1','1','0','select 1 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(decode(ajid,null,0,1)) col3
			,sum(decode(aj_flag,''03'',1,''04'',1,0)) col4,sum(zlgzjs) col5,sum(xzcljs) col6
			,sum(xzcfjs) col7,sum(fkje) col8,count(distinct(decode(ctfs,''01'',dwid))) col9
			,sum(decode(ctfs,''01'',ldzrs,0)) col10,sum(decode(ctfs,''01'',ylje,0)) col11,sum(decode(ctfs,''01'',syje,0)) col12
			,sum(decode(ctfs,''01'',yxje,0)) col13,sum(decode(ctfs,''01'',gsje,0)) col14,count(distinct(decode(ctfs,''02'',dwid))) col15
			,sum(decode(ctfs,''02'',ldzrs,0)) col16,sum(decode(ctfs,''02'',ylje,0)) col17,sum(decode(ctfs,''02'',syje,0)) col18
			,sum(decode(ctfs,''02'',yxje,0)) col19,sum(decode(ctfs,''02'',gsje,0)) col20,count(distinct(decode(ctfs,''03'',dwid))) col21
			,sum(decode(ctfs,''03'',ldzrs,0)) col22,sum(decode(ctfs,''03'',ylje,0)) col23,sum(decode(ctfs,''03'',syje,0)) col24
			,sum(decode(ctfs,''03'',yxje,0)) col25,sum(decode(ctfs,''03'',gsje,0)) col26,sum(qzzxjs) col27
	from v_c1
 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$zxjc','c1','2','0','select 2 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(decode(ajid,null,0,1)) col3
			,sum(decode(aj_flag,''03'',1,''04'',1,0)) col4,sum(zlgzjs) col5,sum(xzcljs) col6
			,sum(xzcfjs) col7,sum(fkje) col8,count(distinct(decode(ctfs,''01'',dwid))) col9
			,sum(decode(ctfs,''01'',ldzrs,0)) col10,sum(decode(ctfs,''01'',ylje,0)) col11,sum(decode(ctfs,''01'',syje,0)) col12
			,sum(decode(ctfs,''01'',yxje,0)) col13,sum(decode(ctfs,''01'',gsje,0)) col14,count(distinct(decode(ctfs,''02'',dwid))) col15
			,sum(decode(ctfs,''02'',ldzrs,0)) col16,sum(decode(ctfs,''02'',ylje,0)) col17,sum(decode(ctfs,''02'',syje,0)) col18
			,sum(decode(ctfs,''02'',yxje,0)) col19,sum(decode(ctfs,''02'',gsje,0)) col20,count(distinct(decode(ctfs,''03'',dwid))) col21
			,sum(decode(ctfs,''03'',ldzrs,0)) col22,sum(decode(ctfs,''03'',ylje,0)) col23,sum(decode(ctfs,''03'',syje,0)) col24
			,sum(decode(ctfs,''03'',yxje,0)) col25,sum(decode(ctfs,''03'',gsje,0)) col26,sum(qzzxjs) col27
	from v_c1
 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$zxjc','c1','3','0','select 3 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(decode(ajid,null,0,1)) col3
			,sum(decode(aj_flag,''03'',1,''04'',1,0)) col4,sum(zlgzjs) col5,sum(xzcljs) col6
			,sum(xzcfjs) col7,sum(fkje) col8,count(distinct(decode(ctfs,''01'',dwid))) col9
			,sum(decode(ctfs,''01'',ldzrs,0)) col10,sum(decode(ctfs,''01'',ylje,0)) col11,sum(decode(ctfs,''01'',syje,0)) col12
			,sum(decode(ctfs,''01'',yxje,0)) col13,sum(decode(ctfs,''01'',gsje,0)) col14,count(distinct(decode(ctfs,''02'',dwid))) col15
			,sum(decode(ctfs,''02'',ldzrs,0)) col16,sum(decode(ctfs,''02'',ylje,0)) col17,sum(decode(ctfs,''02'',syje,0)) col18
			,sum(decode(ctfs,''02'',yxje,0)) col19,sum(decode(ctfs,''02'',gsje,0)) col20,count(distinct(decode(ctfs,''03'',dwid))) col21
			,sum(decode(ctfs,''03'',ldzrs,0)) col22,sum(decode(ctfs,''03'',ylje,0)) col23,sum(decode(ctfs,''03'',syje,0)) col24
			,sum(decode(ctfs,''03'',yxje,0)) col25,sum(decode(ctfs,''03'',gsje,0)) col26,sum(qzzxjs) col27
	from v_c1
 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$zxjc','c1','4','0','select 4 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(decode(ajid,null,0,1)) col3
			,sum(decode(aj_flag,''03'',1,''04'',1,0)) col4,sum(zlgzjs) col5,sum(xzcljs) col6
			,sum(xzcfjs) col7,sum(fkje) col8,count(distinct(decode(ctfs,''01'',dwid))) col9
			,sum(decode(ctfs,''01'',ldzrs,0)) col10,sum(decode(ctfs,''01'',ylje,0)) col11,sum(decode(ctfs,''01'',syje,0)) col12
			,sum(decode(ctfs,''01'',yxje,0)) col13,sum(decode(ctfs,''01'',gsje,0)) col14,count(distinct(decode(ctfs,''02'',dwid))) col15
			,sum(decode(ctfs,''02'',ldzrs,0)) col16,sum(decode(ctfs,''02'',ylje,0)) col17,sum(decode(ctfs,''02'',syje,0)) col18
			,sum(decode(ctfs,''02'',yxje,0)) col19,sum(decode(ctfs,''02'',gsje,0)) col20,count(distinct(decode(ctfs,''03'',dwid))) col21
			,sum(decode(ctfs,''03'',ldzrs,0)) col22,sum(decode(ctfs,''03'',ylje,0)) col23,sum(decode(ctfs,''03'',syje,0)) col24
			,sum(decode(ctfs,''03'',yxje,0)) col25,sum(decode(ctfs,''03'',gsje,0)) col26,sum(qzzxjs) col27
	from v_c1
 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$zxjc','c1','5','0','select 5 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(decode(ajid,null,0,1)) col3
			,sum(decode(aj_flag,''03'',1,''04'',1,0)) col4,sum(zlgzjs) col5,sum(xzcljs) col6
			,sum(xzcfjs) col7,sum(fkje) col8,count(distinct(decode(ctfs,''01'',dwid))) col9
			,sum(decode(ctfs,''01'',ldzrs,0)) col10,sum(decode(ctfs,''01'',ylje,0)) col11,sum(decode(ctfs,''01'',syje,0)) col12
			,sum(decode(ctfs,''01'',yxje,0)) col13,sum(decode(ctfs,''01'',gsje,0)) col14,count(distinct(decode(ctfs,''02'',dwid))) col15
			,sum(decode(ctfs,''02'',ldzrs,0)) col16,sum(decode(ctfs,''02'',ylje,0)) col17,sum(decode(ctfs,''02'',syje,0)) col18
			,sum(decode(ctfs,''02'',yxje,0)) col19,sum(decode(ctfs,''02'',gsje,0)) col20,count(distinct(decode(ctfs,''03'',dwid))) col21
			,sum(decode(ctfs,''03'',ldzrs,0)) col22,sum(decode(ctfs,''03'',ylje,0)) col23,sum(decode(ctfs,''03'',syje,0)) col24
			,sum(decode(ctfs,''03'',yxje,0)) col25,sum(decode(ctfs,''03'',gsje,0)) col26,sum(qzzxjs) col27
	from v_c1
 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$zxjc','c1','6','0','select 6 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(decode(ajid,null,0,1)) col3
			,sum(decode(aj_flag,''03'',1,''04'',1,0)) col4,sum(zlgzjs) col5,sum(xzcljs) col6
			,sum(xzcfjs) col7,sum(fkje) col8,count(distinct(decode(ctfs,''01'',dwid))) col9
			,sum(decode(ctfs,''01'',ldzrs,0)) col10,sum(decode(ctfs,''01'',ylje,0)) col11,sum(decode(ctfs,''01'',syje,0)) col12