select ZYH000,brxm00,cykbmc,cyrq00,ZYYSMC,zzysmc,kzrmc0,qsrq00,qssj00,ccts00+fjts ccts00,100 jlje00,0.5 jlzkf0
                                        from (
                                              select a.LSH000,a.zyh000, a.brxm00,a.cykbmc, a.ryrq00,a.cyrq00,a.ZYYSMC,a.zzysmc, a.kzrmc0,
                                              SF_ZS_ComputeJSGZRQ(a.cyrq00,a.qsrq00) ccts00,  a.qsrq00,a.qssj00
                                              ,decode(sign(to_date(a.qssj00,'hh24:mi:ss')-TO_date('17:30:00','hh24:mi:ss')),1,1,0) fjts--过滤时间的附加天数
                                              from ba_brzyxx a
                                              where  A.CYRQ00 BETWEEN 20210701 AND 20210730
                                              and CYKB00 in ( select bmbh00 from bm_bmbm00 where bmxz00='0' and czbz00 in ('0','1') and flag00='1')   
                                              and a.lsh000 not in (select lsh000 from  BA_JLGLMD where zt0000 =1)  ) 
                                              where  to_date(qsrq00, 'YYYYMMDD')+fjts-to_date(SF_ZS_ComputeGdtjrq(cyrq00,3),'YYYYMMDD')<=0  ---+fjts +过滤时间的附加天数
                                              order by cykbmc, CYRQ00