{"printBb":[{"branch":"0","branchmc":"standard","code":"printYJ_JMCFD","createTime":1719559777000,"entityVersion":0,"fr3Name":"麻醉处方.frx","id":"printYJ_JMCFD","inParam":"[{\"name\":\"CFH000\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"处方号\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":0},{\"name\":\"MZZYBZ\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":1}]","inParams":[{"deFault":"","fieldType":"String","isRequired":true,"name":"CFH000","proceduresParam":"","remark":"处方号","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":true,"name":"MZZYBZ","proceduresParam":"","remark":"","required":true,"testParam":""}],"name":"printYJ_JMCFD","outParam":"[{\"dataSources\":\"sql\",\"name\":\"tableMain\",\"outfieldType\":\"String\",\"value\":\"tableMain\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"tableMain\",\"LAY_TABLE_INDEX\":0},{\"dataSources\":\"sql\",\"name\":\"tableChild\",\"outfieldType\":\"String\",\"value\":\"tableChild\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"tableChild\",\"LAY_TABLE_INDEX\":1}]","outParams":[{"dataSources":"sql","deFault":"","name":"tableMain","outfieldType":"String","paramType":"tableMain","remark":"","value":"tableMain"},{"dataSources":"sql","deFault":"","name":"tableChild","outfieldType":"String","paramType":"tableChild","remark":"","value":"tableChild"}],"printType":"FRX","sql":"[{\"name\":\"tableMain\",\"sql\":\"<#if MZZYBZ == '1'>\\nselect y.YPMC00,\\n       y.YPGG00,\\n       y.PCMC00,\\n       y.YPYFMC,\\n       y.BZ0000,\\n       y.YPZSL0,\\n       to_number(y.CSL000) CSL000,\\n       y.JLDW00,\\n       Y.YYSJ00,\\n       Y.YYSJDW,\\n       Y.PCMC00 PC0000,\\n       Y.YFSMMC YYZF00\\nfrom YF_YZYPSQ y,BM_YD0000 b\\nwhere TQDJH0 = '${CFH000}' \\nand y.YPNM00 = b.YPNM00\\nand (b.MZDJ00 <> '0' or b.SJDJ00 = '1')\\n<#else>\\nselect y.YPMC00,\\n       y.YPGG00,\\n       y.PCMC00,\\n       y.YPYFMC,\\n       y.BZ0000,\\n       y.YPZSL0,\\n       to_number(y.CSL000) CSL000,\\n       y.JLDW00,\\n       Y.YYSJ00,\\n       Y.YYSJDW,\\n       Y.PCMC00 PC0000,\\n       Y.YFSMMC YYZF00\\nfrom YF_MZCFMX y,BM_YD0000 b\\nwhere CFLSH0 = '${CFH000}'\\nand y.YPNM00 = b.YPNM00\\nand (b.MZDJ00 <> '0' or b.SJDJ00 = '1')\\n</#if>\\n\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"LAY_TABLE_INDEX\":0},{\"name\":\"tableChild\",\"sql\":\"<#if MZZYBZ == '1'>\\n  select y.BRXM00,\\n\\ty.ZYH000 BLH000,\\n\\tz.BRID00,\\n\\tz.XB0000,\\n\\ty.SRRQ00, \\n\\tb.BRZJBH,\\n\\ty.CH0000,\\n\\tz.RYZDMC ZDMC00,\\n\\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\\n\\t(select b.BMMC00 from BM_BMBM00 b where b.BMBH00=z.RZKS00) BMMC00,\\n\\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\\n\\t(select FBMC00 from BM_BRFBB0 where FBBH00 = z.FBBH00) FBMC00,\\n\\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\\n\\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\\n    ,'1' as ZYBZ00,\\n    Y.DBRXM0,\\n    '' DBRXB0,\\n    Y.DBRZJH DBRSFZ,\\n    sum(Y.HJJE00) YPFY00,\\n    nvl(B.BRLXDZ,B.BRJTDZ) DZ0000\\n  from YF_YZYPSQ y,ZY_BRXXB0 z,BM_BRXXB0 b \\n  where y.TQDJH0='${CFH000}'\\n\\tand y.ZYH000 = z.ZYH000\\n\\tand z.BRID00 = b.BRID00\\n\\tgroup by y.BRXM00,y.ZYH000,z.BRID00,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,y.CH0000,z.RYZDMC,DYRQ00,z.FBBH00,z.RZKS00,z.CSRQ00,y.YSGZH0,Y.DBRXM0,Y.DBRZJH,B.BRLXDZ,B.BRJTDZ\\n<#else>\\n  select y.BRXM00,\\n\\tz.brid00,\\n\\ty.GHH000 BLH000,\\n\\tz.BRID00,\\n\\tz.XB0000,\\n\\ty.SRRQ00, \\n\\tb.BRZJBH,\\n\\tx.ZDMC00,\\n\\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\\n\\t(select b.BMMC00 from BM_BMBM00 b where b.BMBH00=x.JZKS00) BMMC00,\\n\\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\\n\\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\\n\\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\\n    ,'1' as MZBZ00,\\n    '' as CH0000,\\nY.DBRXM0,\\n'' DBRXB0,\\nY.DBRZJH DBRSFZ,\\nsum(Y.CFZJE0) YPFY00,\\nnvl(B.BRLXDZ,B.BRJTDZ) DZ0000\\n  from YF_MZCF00 y,SF_BRXXB0 z,BM_BRXXB0 b,YS_BRZDXX x\\n  where y.CFLSH0='${CFH000}'\\n\\tand y.GHH000 = z.GHH000\\n    and y.GHH000 = x.GHH000\\n\\tand z.BRID00 = b.BRID00\\n\\tand x.GHID00 = y.GHID00\\n  group by y.BRXM00,z.BRID00,y.GHH000,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,z.CSRQ00,y.YSGZH0,x.ZDMC00,x.JZKS00,Y.DBRXM0,Y.DBRZJH,B.BRLXDZ,B.BRJTDZ\\n</#if>\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"LAY_TABLE_INDEX\":1}]","sqls":[{"isCommit":false,"isProcedures":false,"name":"tableMain","remark":"","sql":"<#if MZZYBZ == '1'>\nselect y.YPMC00,\n       y.YPGG00,\n       y.PCMC00,\n       y.YPYFMC,\n       y.BZ0000,\n       y.YPZSL0,\n       to_number(y.CSL000) CSL000,\n       y.JLDW00,\n       Y.YYSJ00,\n       Y.YYSJDW,\n       Y.PCMC00 PC0000,\n       Y.YFSMMC YYZF00\nfrom YF_YZYPSQ y,BM_YD0000 b\nwhere TQDJH0 = '${CFH000}' \nand y.YPNM00 = b.YPNM00\nand (b.MZDJ00 <> '0' or b.SJDJ00 = '1')\n<#else>\nselect y.YPMC00,\n       y.YPGG00,\n       y.PCMC00,\n       y.YPYFMC,\n       y.BZ0000,\n       y.YPZSL0,\n       to_number(y.CSL000) CSL000,\n       y.JLDW00,\n       Y.YYSJ00,\n       Y.YYSJDW,\n       Y.PCMC00 PC0000,\n       Y.YFSMMC YYZF00\nfrom YF_MZCFMX y,BM_YD0000 b\nwhere CFLSH0 = '${CFH000}'\nand y.YPNM00 = b.YPNM00\nand (b.MZDJ00 <> '0' or b.SJDJ00 = '1')\n</#if>\n"},{"isCommit":false,"isProcedures":false,"name":"tableChild","remark":"","sql":"<#if MZZYBZ == '1'>\n  select y.BRXM00,\n\ty.ZYH000 BLH000,\n\tz.BRID00,\n\tz.XB0000,\n\ty.SRRQ00, \n\tb.BRZJBH,\n\ty.CH0000,\n\tz.RYZDMC ZDMC00,\n\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\n\t(select b.BMMC00 from BM_BMBM00 b where b.BMBH00=z.RZKS00) BMMC00,\n\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\n\t(select FBMC00 from BM_BRFBB0 where FBBH00 = z.FBBH00) FBMC00,\n\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\n\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\n    ,'1' as ZYBZ00,\n    Y.DBRXM0,\n    '' DBRXB0,\n    Y.DBRZJH DBRSFZ,\n    sum(Y.HJJE00) YPFY00,\n    nvl(B.BRLXDZ,B.BRJTDZ) DZ0000\n  from YF_YZYPSQ y,ZY_BRXXB0 z,BM_BRXXB0 b \n  where y.TQDJH0='${CFH000}'\n\tand y.ZYH000 = z.ZYH000\n\tand z.BRID00 = b.BRID00\n\tgroup by y.BRXM00,y.ZYH000,z.BRID00,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,y.CH0000,z.RYZDMC,DYRQ00,z.FBBH00,z.RZKS00,z.CSRQ00,y.YSGZH0,Y.DBRXM0,Y.DBRZJH,B.BRLXDZ,B.BRJTDZ\n<#else>\n  select y.BRXM00,\n\tz.brid00,\n\ty.GHH000 BLH000,\n\tz.BRID00,\n\tz.XB0000,\n\ty.SRRQ00, \n\tb.BRZJBH,\n\tx.ZDMC00,\n\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\n\t(select b.BMMC00 from BM_BMBM00 b where b.BMBH00=x.JZKS00) BMMC00,\n\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\n\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\n\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\n    ,'1' as MZBZ00,\n    '' as CH0000,\nY.DBRXM0,\n'' DBRXB0,\nY.DBRZJH DBRSFZ,\nsum(Y.CFZJE0) YPFY00,\nnvl(B.BRLXDZ,B.BRJTDZ) DZ0000\n  from YF_MZCF00 y,SF_BRXXB0 z,BM_BRXXB0 b,YS_BRZDXX x\n  where y.CFLSH0='${CFH000}'\n\tand y.GHH000 = z.GHH000\n    and y.GHH000 = x.GHH000\n\tand z.BRID00 = b.BRID00\n\tand x.GHID00 = y.GHID00\n  group by y.BRXM00,z.BRID00,y.GHH000,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,z.CSRQ00,y.YSGZH0,x.ZDMC00,x.JZKS00,Y.DBRXM0,Y.DBRZJH,B.BRLXDZ,B.BRJTDZ\n</#if>"}],"updateTime":1722479783000,"versions":1}],"printPz":[{"catalog":"XiangMuGuanLi","code":"printYJ_JMCFD","entityVersion":0,"id":"printYJ_JMCFD","module":"yj","name":"printYJ_JMCFD","nowVersions":1,"remark":"医技-零散处方维护-精麻处方单","system":"his"}],"printAll":[{"branch":"0","branchmc":"standard","catalog":"XiangMuGuanLi","code":"printYJ_JMCFD","createTime":1719559777000,"entityVersion":0,"fr3Name":"麻醉处方.frx","id":"printYJ_JMCFD","inParam":"[{\"name\":\"CFH000\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"处方号\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":0},{\"name\":\"MZZYBZ\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":1}]","inParams":[{"deFault":"","fieldType":"String","isRequired":true,"name":"CFH000","proceduresParam":"","remark":"处方号","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":true,"name":"MZZYBZ","proceduresParam":"","remark":"","required":true,"testParam":""}],"module":"yj","name":"printYJ_JMCFD","nowVersions":1,"outParam":"[{\"dataSources\":\"sql\",\"name\":\"tableMain\",\"outfieldType\":\"String\",\"value\":\"tableMain\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"tableMain\",\"LAY_TABLE_INDEX\":0},{\"dataSources\":\"sql\",\"name\":\"tableChild\",\"outfieldType\":\"String\",\"value\":\"tableChild\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"tableChild\",\"LAY_TABLE_INDEX\":1}]","outParams":[{"dataSources":"sql","deFault":"","name":"tableMain","outfieldType":"String","paramType":"tableMain","remark":"","value":"tableMain"},{"dataSources":"sql","deFault":"","name":"tableChild","outfieldType":"String","paramType":"tableChild","remark":"","value":"tableChild"}],"printType":"FRX","remark":"医技-零散处方维护-精麻处方单","sql":"[{\"name\":\"tableMain\",\"sql\":\"<#if MZZYBZ == '1'>\\nselect y.YPMC00,\\n       y.YPGG00,\\n       y.PCMC00,\\n       y.YPYFMC,\\n       y.BZ0000,\\n       y.YPZSL0,\\n       to_number(y.CSL000) CSL000,\\n       y.JLDW00,\\n       Y.YYSJ00,\\n       Y.YYSJDW,\\n       Y.PCMC00 PC0000,\\n       Y.YFSMMC YYZF00\\nfrom YF_YZYPSQ y,BM_YD0000 b\\nwhere TQDJH0 = '${CFH000}' \\nand y.YPNM00 = b.YPNM00\\nand (b.MZDJ00 <> '0' or b.SJDJ00 = '1')\\n<#else>\\nselect y.YPMC00,\\n       y.YPGG00,\\n       y.PCMC00,\\n       y.YPYFMC,\\n       y.BZ0000,\\n       y.YPZSL0,\\n       to_number(y.CSL000) CSL000,\\n       y.JLDW00,\\n       Y.YYSJ00,\\n       Y.YYSJDW,\\n       Y.PCMC00 PC0000,\\n       Y.YFSMMC YYZF00\\nfrom YF_MZCFMX y,BM_YD0000 b\\nwhere CFLSH0 = '${CFH000}'\\nand y.YPNM00 = b.YPNM00\\nand (b.MZDJ00 <> '0' or b.SJDJ00 = '1')\\n</#if>\\n\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"LAY_TABLE_INDEX\":0},{\"name\":\"tableChild\",\"sql\":\"<#if MZZYBZ == '1'>\\n  select y.BRXM00,\\n\\ty.ZYH000 BLH000,\\n\\tz.BRID00,\\n\\tz.XB0000,\\n\\ty.SRRQ00, \\n\\tb.BRZJBH,\\n\\ty.CH0000,\\n\\tz.RYZDMC ZDMC00,\\n\\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\\n\\t(select b.BMMC00 from BM_BMBM00 b where b.BMBH00=z.RZKS00) BMMC00,\\n\\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\\n\\t(select FBMC00 from BM_BRFBB0 where FBBH00 = z.FBBH00) FBMC00,\\n\\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\\n\\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\\n    ,'1' as ZYBZ00,\\n    Y.DBRXM0,\\n    '' DBRXB0,\\n    Y.DBRZJH DBRSFZ,\\n    sum(Y.HJJE00) YPFY00,\\n    nvl(B.BRLXDZ,B.BRJTDZ) DZ0000\\n  from YF_YZYPSQ y,ZY_BRXXB0 z,BM_BRXXB0 b \\n  where y.TQDJH0='${CFH000}'\\n\\tand y.ZYH000 = z.ZYH000\\n\\tand z.BRID00 = b.BRID00\\n\\tgroup by y.BRXM00,y.ZYH000,z.BRID00,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,y.CH0000,z.RYZDMC,DYRQ00,z.FBBH00,z.RZKS00,z.CSRQ00,y.YSGZH0,Y.DBRXM0,Y.DBRZJH,B.BRLXDZ,B.BRJTDZ\\n<#else>\\n  select y.BRXM00,\\n\\tz.brid00,\\n\\ty.GHH000 BLH000,\\n\\tz.BRID00,\\n\\tz.XB0000,\\n\\ty.SRRQ00, \\n\\tb.BRZJBH,\\n\\tx.ZDMC00,\\n\\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\\n\\t(select b.BMMC00 from BM_BMBM00 b where b.BMBH00=x.JZKS00) BMMC00,\\n\\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\\n\\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\\n\\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\\n    ,'1' as MZBZ00,\\n    '' as CH0000,\\nY.DBRXM0,\\n'' DBRXB0,\\nY.DBRZJH DBRSFZ,\\nsum(Y.CFZJE0) YPFY00,\\nnvl(B.BRLXDZ,B.BRJTDZ) DZ0000\\n  from YF_MZCF00 y,SF_BRXXB0 z,BM_BRXXB0 b,YS_BRZDXX x\\n  where y.CFLSH0='${CFH000}'\\n\\tand y.GHH000 = z.GHH000\\n    and y.GHH000 = x.GHH000\\n\\tand z.BRID00 = b.BRID00\\n\\tand x.GHID00 = y.GHID00\\n  group by y.BRXM00,z.BRID00,y.GHH000,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,z.CSRQ00,y.YSGZH0,x.ZDMC00,x.JZKS00,Y.DBRXM0,Y.DBRZJH,B.BRLXDZ,B.BRJTDZ\\n</#if>\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"LAY_TABLE_INDEX\":1}]","sqls":[{"isCommit":false,"isProcedures":false,"name":"tableMain","remark":"","sql":"<#if MZZYBZ == '1'>\nselect y.YPMC00,\n       y.YPGG00,\n       y.PCMC00,\n       y.YPYFMC,\n       y.BZ0000,\n       y.YPZSL0,\n       to_number(y.CSL000) CSL000,\n       y.JLDW00,\n       Y.YYSJ00,\n       Y.YYSJDW,\n       Y.PCMC00 PC0000,\n       Y.YFSMMC YYZF00\nfrom YF_YZYPSQ y,BM_YD0000 b\nwhere TQDJH0 = '${CFH000}' \nand y.YPNM00 = b.YPNM00\nand (b.MZDJ00 <> '0' or b.SJDJ00 = '1')\n<#else>\nselect y.YPMC00,\n       y.YPGG00,\n       y.PCMC00,\n       y.YPYFMC,\n       y.BZ0000,\n       y.YPZSL0,\n       to_number(y.CSL000) CSL000,\n       y.JLDW00,\n       Y.YYSJ00,\n       Y.YYSJDW,\n       Y.PCMC00 PC0000,\n       Y.YFSMMC YYZF00\nfrom YF_MZCFMX y,BM_YD0000 b\nwhere CFLSH0 = '${CFH000}'\nand y.YPNM00 = b.YPNM00\nand (b.MZDJ00 <> '0' or b.SJDJ00 = '1')\n</#if>\n"},{"isCommit":false,"isProcedures":false,"name":"tableChild","remark":"","sql":"<#if MZZYBZ == '1'>\n  select y.BRXM00,\n\ty.ZYH000 BLH000,\n\tz.BRID00,\n\tz.XB0000,\n\ty.SRRQ00, \n\tb.BRZJBH,\n\ty.CH0000,\n\tz.RYZDMC ZDMC00,\n\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\n\t(select b.BMMC00 from BM_BMBM00 b where b.BMBH00=z.RZKS00) BMMC00,\n\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\n\t(select FBMC00 from BM_BRFBB0 where FBBH00 = z.FBBH00) FBMC00,\n\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\n\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\n    ,'1' as ZYBZ00,\n    Y.DBRXM0,\n    '' DBRXB0,\n    Y.DBRZJH DBRSFZ,\n    sum(Y.HJJE00) YPFY00,\n    nvl(B.BRLXDZ,B.BRJTDZ) DZ0000\n  from YF_YZYPSQ y,ZY_BRXXB0 z,BM_BRXXB0 b \n  where y.TQDJH0='${CFH000}'\n\tand y.ZYH000 = z.ZYH000\n\tand z.BRID00 = b.BRID00\n\tgroup by y.BRXM00,y.ZYH000,z.BRID00,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,y.CH0000,z.RYZDMC,DYRQ00,z.FBBH00,z.RZKS00,z.CSRQ00,y.YSGZH0,Y.DBRXM0,Y.DBRZJH,B.BRLXDZ,B.BRJTDZ\n<#else>\n  select y.BRXM00,\n\tz.brid00,\n\ty.GHH000 BLH000,\n\tz.BRID00,\n\tz.XB0000,\n\ty.SRRQ00, \n\tb.BRZJBH,\n\tx.ZDMC00,\n\t(select SF_XT_CSRQTONL_EX(z.CSRQ00,'00:00:00') from dual) BRNL00,\n\t(select b.BMMC00 from BM_BMBM00 b where b.BMBH00=x.JZKS00) BMMC00,\n\t(select to_char(sysdate,'YYYY-MM-DD') from dual) DYRQ00,\n\t(select XKH000 from BM_YGBM00 where YGBH00 = y.ysgzh0) XKH000,\n\t(select ZWXM00 from BM_YGBM00 where YGBH00 = y.Ysgzh0) YSXM00\n    ,'1' as MZBZ00,\n    '' as CH0000,\nY.DBRXM0,\n'' DBRXB0,\nY.DBRZJH DBRSFZ,\nsum(Y.CFZJE0) YPFY00,\nnvl(B.BRLXDZ,B.BRJTDZ) DZ0000\n  from YF_MZCF00 y,SF_BRXXB0 z,BM_BRXXB0 b,YS_BRZDXX x\n  where y.CFLSH0='${CFH000}'\n\tand y.GHH000 = z.GHH000\n    and y.GHH000 = x.GHH000\n\tand z.BRID00 = b.BRID00\n\tand x.GHID00 = y.GHID00\n  group by y.BRXM00,z.BRID00,y.GHH000,z.XB0000,BMMC00,y.SRRQ00,b.BRZJBH,z.CSRQ00,y.YSGZH0,x.ZDMC00,x.JZKS00,Y.DBRXM0,Y.DBRZJH,B.BRLXDZ,B.BRJTDZ\n</#if>"}],"system":"his","updateTime":1722479783000,"versions":1}]}