--正常检验结果
--项目列表
select t.SQ0000||' '||t.SQSJ00 SQRQ00,t.*,''SectionNo,''ItemNo ,JYLX00 type,''SerialNo,''Prec,''TestTypeNo,(select SFCJJZ from VW_JY_JYJG00_ZYDZBL a where a.JYYWID=t.JYYWID and rownum=1 and a.SFCJJZ ='Y') JGZCBZ  from VW_JY_YW0000_ZYDZBL t,YJ_YW0000 t2 where t.YJDJH0=t2.YJDJH0  and  t.brid00 in (select brid00 from BM_BRXXB0 where brzjbh= '350500196612253522') and  ( SQRQ00 >= '20250713' and SQRQ00 <= '20250814' ) and (sfbz00='3' or jgzt00 in ('6','8','9')) and bg0000 is not null   order by t.BBSDRQ desc 

--查询结果
select t.* from VW_JY_JYJG00_ZYDZBL t where 1=1 and JYYWID ='13166298' order by dysx00
--查询检验人员，审核人员，报告日期
select (select ZWXM00 from BM_YGBM00 where b.bgr000 = YGBH00) jyr000,
                                 (select ZWXM00  from BM_YGBM00  where t.shr000 = YGBH00) shr000,
                                    b.cbgrq0||' '||b.cbgsj0 cbgrq0,b.BBBZ00,b.JYJS00,b.DYBZ00
                                  from jy_jyjg00 t, JY_YW0000 b
                                 where t.jyywid = b.jyywid  and t.JYYWID ='13166298'

--查询细菌结果
select *  from JY_XJJGPY where YBH000 = 'AD0022' and PYRQ00 = '20250809'


--细菌类的检验
--细菌结果
SELECT distinct  PYRQ00,YBH000,XJID00,XJYWMC,ZWMC00,XJJG00,BBBZ00,JGZT00,XJMS00 FROM VW_JY_XJJG00 WHERE 1=1 and JYYWID='13166307' 

--细菌结果里面的具体情况
select rownum, JG.* from (select * from (select B.ZWMC00, B.MCSX00, a.YMJG00,
                       a.YMJGKB, a.YMSM00, a.JGBZ00, a.bgjgid, A.KSSID0, A.XJJG00, A.XJKSID, XJID00,  decode(nvl((select XH0000
                                    from VW_JY_XJBZXH
                                   where xjid00 = a.xjid00
                                     and kssid0 = a.kssid0
                                     and rownum = 1),
                                  0),
                              0,
                              b.xh0000,
                              nvl((select XH0000
                                    from VW_JY_XJBZXH
                                   where xjid00 = a.xjid00
                                     and kssid0 = a.kssid0
                                     and rownum = 1),
                                  0)) XH0000
                  from JY_XJBGJG a, JY_KSSZD0 B
                 where B.KSSID0 = A.KSSID0
                  and  JYYWID='13166307' and XJID00='6856') ORDER BY XH0000) JG

--检验人，审核人，报告日期，备注
select (select ZWXM00 from BM_YGBM00 where b.bgr000 = YGBH00) jyr000,
                                 (select ZWXM00  from BM_YGBM00  where t.shr000 = YGBH00) shr000,b.cbgrq0||' '||b.cbgsj0 cbgrq0,b.DYBZ00,b.BBBZ00,b.JYJS00
                                  from jy_XJBGjg t, JY_YW0000 b
                                 where t.jyywid = b.jyywid  and t.JYYWID ='13166307'
 --排样日期与样本号                                
select *  from JY_XJJGPY where YBH000 = '000901' and PYRQ00 = '20250809'