/* Formatted on 2021/08/20 09:17 (Formatter Plus v4.8.7) */
SELECT   c.ybmc00, COUNT (DISTINCT f.zyid00) rs0000, SUM (d.zfje00) zfje00,
         SUM (DECODE (SIGN (INSTRB (',' || TRIM (c.ybbhsb) || ',', ',14,')),
                      1, d.grzhzf,
                      d.grzhzf + d.sbgrzh
                     )
             ) grzhzf,
         SUM (DECODE (SIGN (INSTRB (',' || TRIM (c.ybbhsb) || ',', ',14,')),
                      1, d.tcjjzf,
                      d.sbtcjj + d.tcjjzf
                     )
             ) tcjjzf,
         SUM (jjzfe0) jjzfe0, SUM (sybxzf) sybxzf, SUM (d.brzje0) hjje00,
         SUM (d.jzje00) jzje00, SUM (d.gfje00) jmje00, SUM (sbgrzh) sbgrzh,
         SUM (sbtcjj) sbtcjj, SUM (d.brzje0 - d.zfje00) ybxj00,
         SUM (sbzfe0) sbzfe0, SUM (bjzfe0) bjzfe0, SUM (d.gwybz0) gwybz0,
         e.zwxm00
    FROM ic_ybbrlb c,
         zy_jzb000 d,
         bm_ygbm00 e,
         zy_brxxb0 f,
         bm_bmbm00 k,
         bm_bmbm00 g
   WHERE d.yblb00 = c.yblb00
     AND d.fbbh00 = c.fbbh00
     AND c.fbbh00 <> 1
     AND d.jzy000 = e.ygbh00
     AND d.zyid00 = f.zyid00
     AND d.czyks0 = g.bmbh00
     AND f.dqbq00 = k.bmbh00
     AND d.jzrq00 >= :开始
     AND d.jzrq00 <= :结束
     AND d.jzrq00 || d.jzsj00 >= :开始
     AND d.jzrq00 || d.jzsj00 <= :结束
     AND d.jzdh00 NOT IN (SELECT cxjzdh
                            FROM zy_jzb000
                           WHERE jzrq00 >= :开始 AND jzrq00 <= :结束)
     AND d.hjje00 > 0
GROUP BY c.ybmc00, e.zwxm00
  HAVING SUM (d.brzje0) <> 0
UNION ALL
SELECT   '合计', COUNT (DISTINCT f.zyid00) rs0000, SUM (d.zfje00) zfje00,
         SUM (DECODE (SIGN (INSTRB (',' || TRIM (c.ybbhsb) || ',', ',14,')),
                      1, d.grzhzf,
                      d.grzhzf + d.sbgrzh
                     )
             ) grzhzf,
         SUM (DECODE (SIGN (INSTRB (',' || TRIM (c.ybbhsb) || ',', ',14,')),
                      1, d.tcjjzf,
                      d.sbtcjj + d.tcjjzf
                     )
             ) tcjjzf,
         SUM (jjzfe0) jjzfe0, SUM (sybxzf) sybxzf, SUM (d.brzje0) hjje00,
         SUM (d.jzje00) jzje00, SUM (d.gfje00) jmje00, SUM (sbgrzh) sbgrzh,
         SUM (sbtcjj) sbtcjj, SUM (d.brzje0 - d.zfje00) ybxj00,
         SUM (sbzfe0) sbzfe0, SUM (bjzfe0) bjzfe0, SUM (d.gwybz0) gwybz0,
         e.zwxm00
    FROM ic_ybbrlb c,
         zy_jzb000 d,
         bm_ygbm00 e,
         zy_brxxb0 f,
         bm_bmbm00 k,
         bm_bmbm00 g
   WHERE d.yblb00 = c.yblb00
     AND d.fbbh00 = c.fbbh00
     AND c.fbbh00 <> 1
     AND d.jzy000 = e.ygbh00
     AND d.zyid00 = f.zyid00
     AND d.czyks0 = g.bmbh00
     AND f.dqbq00 = k.bmbh00
     AND d.jzrq00 >= :开始
     AND d.jzrq00 <= :结束
     AND d.jzrq00 || d.jzsj00 >= :开始
     AND d.jzrq00 || d.jzsj00 <= :结束
     AND d.jzdh00 NOT IN (SELECT cxjzdh
                            FROM zy_jzb000
                           WHERE jzrq00 >= :开始 AND jzrq00 <= :结束)
     AND d.hjje00 > 0
GROUP BY e.zwxm00