ins_cxtj_dm.sql

公务员工资系统软件工程文档及源代码——JAVA编写（包括整个分析设计代码实现全过程）

			,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 = ''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$zxjc','c1','7','0','select 7 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 = ''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$zxjc','c1','8','0','select 8 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 = ''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$zxjc','c1','9','0','select 9 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 = ''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','a3','2','0','select 2 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(qttg) col3,sum(jydjk) col4,sum(qtwdg) col5
			,sum(bqht) col6,sum(fxdyjrs) col7,sum(fxdyjje) col8,sum(jfgzrs) col9,sum(jfgzje) col10
			,sum(decode(dc_flag,''01'',dc_hs,0)) col11,sum(decode(dc_flag,''01'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col12
			,sum(decode(dc_flag,''01'',nvl(shy_je,0)+nvl(yx_je,0)+nvl(gs_je,0)+nvl(sy_je,0)+nvl(yl_je,0),0)) col13,sum(decode(dc_flag,''02'',dc_hs,0)) col14
			,sum(decode(dc_flag,''02'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col15,sum(ffjg) col16
			,sum(msffsd) col17,sum(wfjn) col18,sum(decode(qzjbtj,''04'',1,0)) col19,sum(decode(qzjbtj,''04'',ldzrs,0)) col20
	from v_a3
 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','a3','4','0','select 4 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(qttg) col3,sum(jydjk) col4,sum(qtwdg) col5
			,sum(bqht) col6,sum(fxdyjrs) col7,sum(fxdyjje) col8,sum(jfgzrs) col9,sum(jfgzje) col10
			,sum(decode(dc_flag,''01'',dc_hs,0)) col11,sum(decode(dc_flag,''01'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col12
			,sum(decode(dc_flag,''01'',nvl(shy_je,0)+nvl(yx_je,0)+nvl(gs_je,0)+nvl(sy_je,0)+nvl(yl_je,0),0)) col13,sum(decode(dc_flag,''02'',dc_hs,0)) col14
			,sum(decode(dc_flag,''02'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col15,sum(ffjg) col16
			,sum(msffsd) col17,sum(wfjn) col18,sum(decode(qzjbtj,''04'',1,0)) col19,sum(decode(qzjbtj,''04'',ldzrs,0)) col20
	from v_a3
 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','a3','7','0','select 7 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(qttg) col3,sum(jydjk) col4,sum(qtwdg) col5
			,sum(bqht) col6,sum(fxdyjrs) col7,sum(fxdyjje) col8,sum(jfgzrs) col9,sum(jfgzje) col10
			,sum(decode(dc_flag,''01'',dc_hs,0)) col11,sum(decode(dc_flag,''01'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col12
			,sum(decode(dc_flag,''01'',nvl(shy_je,0)+nvl(yx_je,0)+nvl(gs_je,0)+nvl(sy_je,0)+nvl(yl_je,0),0)) col13,sum(decode(dc_flag,''02'',dc_hs,0)) col14
			,sum(decode(dc_flag,''02'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col15,sum(ffjg) col16
			,sum(msffsd) col17,sum(wfjn) col18,sum(decode(qzjbtj,''04'',1,0)) col19,sum(decode(qzjbtj,''04'',ldzrs,0)) col20
	from v_a3
 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','a3','9','0','select 9 xh,count(distinct(dwid)) col1,sum(ldzrs) col2,sum(qttg) col3,sum(jydjk) col4,sum(qtwdg) col5
			,sum(bqht) col6,sum(fxdyjrs) col7,sum(fxdyjje) col8,sum(jfgzrs) col9,sum(jfgzje) col10
			,sum(decode(dc_flag,''01'',dc_hs,0)) col11,sum(decode(dc_flag,''01'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col12
			,sum(decode(dc_flag,''01'',nvl(shy_je,0)+nvl(yx_je,0)+nvl(gs_je,0)+nvl(sy_je,0)+nvl(yl_je,0),0)) col13,sum(decode(dc_flag,''02'',dc_hs,0)) col14
			,sum(decode(dc_flag,''02'',nvl(shy_rs,0)+nvl(yx_rs,0)+nvl(gs_rs,0)+nvl(sy_rs,0)+nvl(yl_rs,0),0)) col15,sum(ffjg) col16
			,sum(msffsd) col17,sum(wfjn) col18,sum(decode(qzjbtj,''04'',1,0)) col19,sum(decode(qzjbtj,''04'',ldzrs,0)) col20
	from v_a3
 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','1','select 1 xh,count(distinct(decode(jctj,''02'',dwid,''03'',dwid))) raw1,count(distinct(decode(dwxz||jctj,''0102'',dwid,''0103'',dwid))) raw2
			,count(distinct(decode(dwxz||jctj,''0202'',dwid,''0203'',dwid))) raw3,count(distinct(decode(dwxz||jctj,''0302'',dwid,''0303'',dwid))) raw4
			,count(distinct(decode(dwxz||jctj,''0402'',dwid,''0403'',dwid))) raw5,count(distinct(decode(dwxz||jctj,''0502'',dwid,''0503'',dwid))) raw6
			,count(distinct(decode(dwxz||jctj,''0602'',dwid,''0603'',dwid))) raw7,count(distinct(decode(dwxz||jctj,''0702'',dwid,''0703'',dwid))) raw8
			,count(distinct(decode(dwxz||jctj,''0802'',dwid,''0803'',dwid))) raw9
	from v_b2_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','b2','0','11','select 11 xh,sum(decode(dc_flag,''01'',dc_hs,0)) raw1,sum(decode(dwxz,''01'',decode(dc_flag,''01'',dc_hs,0),0)) raw2
			,sum(decode(dwxz,''02'',decode(dc_flag,''01'',dc_hs,0),0)) raw3,sum(decode(dwxz,''03'',decode(dc_flag,''01'',dc_hs,0),0)) raw4
			,sum(decode(dwxz,''04'',decode(dc_flag,''01'',dc_hs,0),0)) raw5,sum(decode(dwxz,''05'',decode(dc_flag,''01'',dc_hs,0),0)) raw6
			,sum(decode(dwxz,''06'',decode(dc_flag,''01'',dc_hs,0),0)) raw7,sum(decode(dwxz,''07'',decode(dc_flag,''01'',dc_hs,0),0)) raw8
			,sum(decode(dwxz,''08'',decode(dc_flag,''01'',dc_hs,0),0)) raw9
	from v_b2_2
 where 1=1
','','01','','11','0');

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

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

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

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


commit;