1 15:14:04 SQL Execute: ORACLE - Insert into XT_MKDLRZ(DLID00,YGBH00,YGXM00,JSJIP0,JSJMAC,XTDM00,MKNBMC,JCID00) values(SQ_XT_MKDLRZ_DLID00.NEXTVAL,4960,'管理员','129.1.77.2','00-50-56-C0-00-08','5','ACT_ZYSF_SFZHCX','132614372') 2 15:14:04 SQL Data In: ORACLE - Rows affected = 1 3 15:14:04 SQL Execute: ORACLE - Commit 4 15:14:04 SQL Data In: ORACLE - Rows affected = 0 5 15:14:06 SQL Execute: ORACLE - Select userenv('SESSIONID') PROCESS from dual where rownum = 1 6 15:14:06 SQL Execute: ORACLE - select * from XT_YYXX00 where YYID00 in (select YYID00 from BM_BMBM00 where BMBH00=2112) 7 15:14:06 SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where YGBH00 = 4960 and NAME00 = 'RTNRUM' 8 15:14:06 SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where YGBH00 = 4960 and NAME00 = 'IPTDRT' 9 15:14:06 SQL Execute: ORACLE - select VALUE0 from XT_YHCS00 where YGBH00 = 4960 and NAME00 = 'FZSRF0' 10 15:14:06 SQL Execute: ORACLE - select * from VW_BB_MBLX00 a order by MBXH00,SJMBLX,MBLX00 11 15:14:07 SQL Execute: ORACLE - select MBLX00,MBMC00,SJMBLX,MBXH00,BBID00,BBBH00,BBNAME,BBSM00,SMCJR0,SMCJXM,CXQR00 from VW_PT_YHFR3BB0 where YGBH00 = 4960 order by MBXH00,MBBH00,BBBH00,BBID00 12 15:14:07 SQL Execute: ORACLE - select * from VW_PT_YGJSB0 where YGBH00 =4960 and jslx00='1' 13 15:14:09 SQL Execute: ORACLE - select * from BB_FR3BB0 WHERE BBID00= 10915 14 15:14:09 SQL Execute: ORACLE - select * from BB_CSMX00 where BBID00= 10915 order by WBXH00,XH0000 15 15:14:09 SQL Execute: ORACLE - select SQL000 from BB_SQL000 where BBID00 = 10915 16 15:14:09 SQL Execute: ORACLE - select * from (select t.bmmc00, t.cnt, A, B, C, D, total, decode (total ,0,100,ROUND(nvl(A, 0) * 100 / total,2)) || '%' A占比,decode( total ,0,100, ROUND((D + B + C) * 100 / total,2)) || '%' as "BCD占比",decode( total ,0,100, ROUND((D + C) * 100 / total,2)) || '%' as "CD占比" from (select (select bm.bmmc00 from bm_bmbm00 bm where bm.bmbh00 = zy.dqks00) bmmc00, count(*) cnt, sum(decode(blfx00, 'A', 1, 0)) A, sum(decode(blfx00, 'B', 1, 0)) B, sum(decode(blfx00, 'C', 1, 0)) C, sum(decode(blfx00, 'D', 1, 0)) D, sum(decode(blfx00, 'A', 1, 'B', 1, 'C', 1, 'D', 1, 0)) total --, --sum(decode(blfx00,'B',1,'C',1,'D',1,0)/sum(nvl(blfx00,0))) as "BCD型占比" from zy_brxxb0 zy, ba_brzyxx ba where zy.zyh000 = ba.zyh000 and ba.lsh000 = zy.zyid00 and zy.cyrq00 >= '20210405' and zy.cyrq00 <= '20210405' and zy.brzt00 = '4' group by zy.dqks00 union all select '总计' bmmc00, count(*) cnt, sum(decode(blfx00, 'A', 1, 0)) A, sum(decode(blfx00, 'B', 1, 0)) B, sum(decode(blfx00, 'C', 1, 0)) C, sum(decode(blfx00, 'D', 1, 0)) D, sum(decode(blfx00, 'A', 1, 'B', 1, 'C', 1, 'D', 1, 0)) total from zy_brxxb0 zy, ba_brzyxx ba where zy.zyh000 = ba.zyh000 and ba.lsh000 = zy.zyid00 and zy.cyrq00 >= '20210405' and zy.cyrq00 <= '20210405' and zy.brzt00 = '4') t ) where 1=2 17 15:14:09 SQL Execute: ORACLE - select '2021-04-05' as 开始日期 , '2021-04-05' as 结束日期 , '18053101' as 报表号,10915 as 报表ID,'管理员' as 操作员姓名,'10087' as 操作员胸卡号,'福建中医药大学附属人民医院' as 医院名称,'收费处' as 操作员部门,2112 as 操作员部门ID,'220006' as 操作员登录院区ID,'福建中医药大学附属人民医院' as 操作员登录院区名称 from dual 18 15:14:10 SQL Execute: ORACLE - select * from BB_SQL000 where BBID00= 10915 order by XH0000 19 15:14:10 SQL Execute: ORACLE - select t.bmmc00, t.cnt, A, B, C, D, total, decode (total ,0,100,ROUND(nvl(A, 0) * 100 / total,2)) || '%' A占比,decode( total ,0,100, ROUND((D + B + C) * 100 / total,2)) || '%' as "BCD占比",decode( total ,0,100, ROUND((D + C) * 100 / total,2)) || '%' as "CD占比" from (select (select bm.bmmc00 from bm_bmbm00 bm where bm.bmbh00 = zy.dqks00) bmmc00, count(*) cnt, sum(decode(blfx00, 'A', 1, 0)) A, sum(decode(blfx00, 'B', 1, 0)) B, sum(decode(blfx00, 'C', 1, 0)) C, sum(decode(blfx00, 'D', 1, 0)) D, sum(decode(blfx00, 'A', 1, 'B', 1, 'C', 1, 'D', 1, 0)) total --, --sum(decode(blfx00,'B',1,'C',1,'D',1,0)/sum(nvl(blfx00,0))) as "BCD型占比" from zy_brxxb0 zy, ba_brzyxx ba where zy.zyh000 = ba.zyh000 and ba.lsh000 = zy.zyid00 and zy.cyrq00 >= '20210405' and zy.cyrq00 <= '20210405' and zy.brzt00 = '4' group by zy.dqks00 union all select '总计' bmmc00, count(*) cnt, sum(decode(blfx00, 'A', 1, 0)) A, sum(decode(blfx00, 'B', 1, 0)) B, sum(decode(blfx00, 'C', 1, 0)) C, sum(decode(blfx00, 'D', 1, 0)) D, sum(decode(blfx00, 'A', 1, 'B', 1, 'C', 1, 'D', 1, 0)) total from zy_brxxb0 zy, ba_brzyxx ba where zy.zyh000 = ba.zyh000 and ba.lsh000 = zy.zyid00 and zy.cyrq00 >= '20210405' and zy.cyrq00 <= '20210405' and zy.brzt00 = '4') t 20 15:14:10 SQL Execute: ORACLE - Insert into BB_CZRZ00(RZID00,YGBH00,YGXM00,BMBH00,BBID00,JSJIP0,JSJMAC,JCID00,BZ0000) values(SQ_BB_CZRZ00_RZID00.NEXTVAL,4960,'管理员',2112,10915,'129.1.77.2','00-50-56-C0-00-08','132614372','开始日期:2021-04-05 结束日期:2021-04-05 ') 21 15:14:10 SQL Data In: ORACLE - Rows affected = 1 22 15:14:10 SQL Execute: ORACLE - Commit 23 15:14:10 SQL Data In: ORACLE - Rows affected = 0 24 15:14:10 SQL Execute: ORACLE - select '2021-04-05' as 开始日期,'2021-04-05' as 结束日期, '18053101' as 报表号,10915 as 报表ID, '管理员' as 操作员姓名,'10087' as 操作员胸卡号,'福建中医药大学附属人民医院' as 医院名称,'收费处' as 操作员部门,2112 as 操作员部门ID,'220006' as 操作员登录院区ID,'福建中医药大学附属人民医院' as 操作员登录院区名称 from dual 25 15:14:11 SQL Execute: ORACLE - select * from VW_BB_GLMB00 where (BMBH00 = 2112 or CJR000 = 4960 ) 26 15:14:11 SQL Execute: ORACLE - select * from BB_GLMBMX where MBID00 = 219 order by MXXH00,MXID00