[{"branch":"0","branchmc":"standard","button":"[]","catalog":"Tongji","chart":"[]","code":"ChargesItemsStatistics","column":"[{\"sys_hidden\":\"\",\"filter_name\":\"XMMC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":0,\"className\":\"\",\"title\":\"收费项目简称\",\"align\":\"left\",\"ora_name\":\"XMMC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"XMMC00\",\"summary\":\"\",\"minWidth\":\"180\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":0,\"round\":\"\",\"trunc\":\"\",\"field\":\"XMMC00\",\"sortType\":\"asc\",\"width\":\"206\",\"uiType\":\"\",\"footerAlign\":\"left\",\"fixed\":\"\",\"_VCUID\":\"row_132\"},{\"sys_hidden\":\"\",\"filter_name\":\"SL0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":1,\"className\":\"\",\"title\":\"数量\",\"align\":\"left\",\"ora_name\":\"SL0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SL0000\",\"summary\":\"\",\"minWidth\":\"80\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":1,\"round\":\"\",\"trunc\":\"\",\"field\":\"SL0000\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"left\",\"fixed\":\"\",\"_VCUID\":\"row_133\"},{\"sys_hidden\":\"\",\"filter_name\":\"JE0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":2,\"className\":\"\",\"title\":\"金额\",\"align\":\"left\",\"ora_name\":\"JE0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"JE0000\",\"summary\":\"\",\"minWidth\":\"80\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":2,\"round\":\"\",\"trunc\":\"\",\"field\":\"JE0000\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"left\",\"fixed\":\"\",\"_VCUID\":\"row_134\"},{\"sys_hidden\":\"\",\"filter_name\":\"BZ0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":3,\"className\":\"\",\"title\":\"备注\",\"align\":\"left\",\"ora_name\":\"BZ0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"BZ0000\",\"summary\":\"\",\"minWidth\":\"160\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":3,\"round\":\"\",\"trunc\":\"\",\"field\":\"BZ0000\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"left\",\"fixed\":\"\",\"_VCUID\":\"row_135\"},{\"sys_hidden\":\"\",\"filter_name\":\"HS.HSXMMC\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":4,\"className\":\"\",\"title\":\"核算项目\",\"align\":\"center\",\"ora_name\":\"HSXMMC\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"HSXMMC\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":4,\"round\":\"\",\"trunc\":\"\",\"field\":\"HSXMMC\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\",\"_VCUID\":\"row_136\"}]","condition":"[]","countSql":"\n<#assign ZYBR00 = myDirective.getParam(\"ZYBR00\")>\n<#assign MZBR00 = myDirective.getParam(\"MZBR00\")>\n\nselect \n count(*) as TOTAL, '合计' as xmmc00,sum(JE0000) as JE0000,sum(SL0000) as SL0000,'' as bz0000,'' as hsxmmc\nfrom (\n select SFXMID,--收费项目ID\n decode('${DZJEDDLC}','Y',JMBZ00,null) TYPE01,--是否为折扣\n sum(JE0000)JE0000, --项目金额\n sum(SL0000)SL0000 --项目数量\n from (\n /* 入参[DZJEDDLC]对应系统参数[YJ_TJDZDDFKLC]科室收费项目统计是否把打折的金额单独列出;Y:列出,默认值为N */\n select 0 JE0000,0 SL0000,-1 SFXMID,'0' JMBZ00, null XMGG00,null XMMC00,null BZ0000 from dual\n <#if (MZBR00 = \"1\") || (MZBR00 = \"0\" && ZYBR00 = \"0\")>\n union all\n select sum(a.HJJE00) JE0000,\n sum(a.XMSL00) SL0000, \n a.XMBH00 SFXMID,\n decode(nvl(a.JMBZ00,'0'),'0','0','2') JMBZ00 , --减免标志 2是减免\n a.XMGG00,\n b.XMMC00,\n b.BZ0000\n from SF_FYMX00 a,BM_YYSFXM b\n where a.Xmbh00=b.SFXMID\n and a.CZRQ00 between replace('${TJKSRQ}','-') and replace('${TJJSRQ}','-')\n and a.CZRQ00||a.CZSJ00 between replace('${TJKSRQ}','-')||'${TJKSSJ}' and replace('${TJJSRQ}','-')||'${TJJSSJ}'\n <#if BMBH00?default(\"\")?trim?length gt 0>\n and a.ZXKS00 =${BMBH00}\n \n <#if SFXMMC?default(\"\")?trim?length gt 0>\n and b.XMMC00 ='${SFXMMC}'\n \n group by a.XMBH00,decode(nvl(a.JMBZ00,'0'),'0','0','2'),a.XMGG00,b.XMMC00,b.BZ0000\n \n --勾选了住院病人或者都没有勾选\n <#if (ZYBR00 = \"1\") || (MZBR00 = \"0\" && ZYBR00 = \"0\")>\n union all\n select sum(a.HJJE00) JE0000, \n sum(a.XMSL00) SL0000, \n a.XMBH00 SFXMID, \n decode(nvl(a.JMBZ00,'0'),'0','0','2') JMBZ00, --减免标志 2是减免\n a.XMGG00,\n b.XMMC00,\n b.BZ0000\n from ZY_FYMX00 a,BM_YYSFXM b\n where a.xmbh00=b.SFXMID\n and a.CZRQ00 between replace('${TJKSRQ}','-') and replace('${TJJSRQ}','-')\n and a.CZRQ00||a.CZSJ00 between replace('${TJKSRQ}','-')||'${TJKSSJ}' and replace('${TJJSRQ}','-')||'${TJJSSJ}'\n <#if BMBH00?default(\"\")?trim?length gt 0>\n and a.ZXKS00 =${BMBH00}\n \n <#if SFXMMC?default(\"\")?trim?length gt 0>\n and b.XMMC00 ='${SFXMMC}'\n \n group by a.XMBH00,decode(nvl(a.JMBZ00,'0'),'0','0','2'),a.XMGG00,b.XMMC00,b.BZ0000\n \n )\n group by SFXMID ,decode('${DZJEDDLC}','Y',JMBZ00,null)\n--) R\n--where R.SFXMID >0\n\n)R,BM_YYSFXM S,BM_YYHSXM HS\nwhere R.SFXMID = S.SFXMID and S.HSXMID=HS.HSXMID(+)","createTime":1704426134000,"entityVersion":0,"id":"ChargesItemsStatistics","isLaypage":"0","module":"yj","name":"ChargesItemsStatistics","pageSql":"<#assign ZYBR00 = myDirective.getParam(\"ZYBR00\")>\n<#assign MZBR00 = myDirective.getParam(\"MZBR00\")>\n\nselect \n(s.XMMC00||decode(R.TYPE01,'2','折扣',''))XMMC00, -- 项目名称\ns.BZ0000,--备注\nHS.HSXMMC hsxmmc,--核算项目名称\nR.* \nfrom (\n select SFXMID,--收费项目ID\n decode('${DZJEDDLC}','Y',JMBZ00,null) TYPE01,--是否为折扣\n sum(JE0000)JE0000, --项目金额\n sum(SL0000)SL0000 --项目数量\n from (\n /* 入参[DZJEDDLC]对应系统参数[YJ_TJDZDDFKLC]科室收费项目统计是否把打折的金额单独列出;Y:列出,默认值为N */\n select 0 JE0000,0 SL0000,-1 SFXMID,'0' JMBZ00,null XMGG00,null XMMC00,null BZ0000 from dual\n <#if (MZBR00 = \"1\") || (MZBR00 = \"0\" && ZYBR00 = \"0\")>\n union all\n select sum(a.HJJE00) JE0000,\n sum(a.XMSL00) SL0000, \n a.XMBH00 SFXMID,\n decode(nvl(a.JMBZ00,'0'),'0','0','2') JMBZ00 , --减免标志 2是减免\n a.XMGG00,\n b.XMMC00,\n b.BZ0000\n from SF_FYMX00 a,BM_YYSFXM b\n where a.Xmbh00=b.SFXMID\n and a.CZRQ00 between replace('${TJKSRQ}','-') and replace('${TJJSRQ}','-')\n and a.CZRQ00||a.CZSJ00 between replace('${TJKSRQ}','-')||'${TJKSSJ}' and replace('${TJJSRQ}','-')||'${TJJSSJ}'\n <#if BMBH00?default(\"\")?trim?length gt 0>\n and a.ZXKS00 =${BMBH00}\n \n <#if SFXMMC?default(\"\")?trim?length gt 0>\n and b.XMMC00 ='${SFXMMC}'\n \n group by a.XMBH00,decode(nvl(a.JMBZ00,'0'),'0','0','2'),a.XMGG00,b.XMMC00,b.BZ0000\n \n --勾选了住院病人或者都没有勾选\n <#if (ZYBR00 = \"1\") || (MZBR00 = \"0\" && ZYBR00 = \"0\")>\n union all\n select sum(a.HJJE00) JE0000, \n sum(a.XMSL00) SL0000, \n a.XMBH00 SFXMID, \n decode(nvl(a.JMBZ00,'0'),'0','0','2') JMBZ00, --减免标志 2是减免\n a.XMGG00,\n b.XMMC00,\n b.BZ0000\n from ZY_FYMX00 a,BM_YYSFXM b\n where a.xmbh00=b.SFXMID\n and CZRQ00 between replace('${TJKSRQ}','-') and replace('${TJJSRQ}','-')\n and CZRQ00||CZSJ00 between replace('${TJKSRQ}','-')||'${TJKSSJ}' and replace('${TJJSRQ}','-')||'${TJJSSJ}'\n <#if BMBH00?default(\"\")?trim?length gt 0>\n and a.ZXKS00 =${BMBH00}\n \n <#if SFXMMC?default(\"\")?trim?length gt 0>\n and b.XMMC00 ='${SFXMMC}'\n \n group by a.XMBH00,decode(nvl(a.JMBZ00,'0'),'0','0','2'),a.XMGG00,b.XMMC00,b.BZ0000\n \n )\n group by SFXMID ,decode('${DZJEDDLC}','Y',JMBZ00,null)\n) R,BM_YYSFXM S,BM_YYHSXM HS\nwhere R.SFXMID = S.SFXMID and S.HSXMID=HS.HSXMID(+)\norder by S.SFXMID","procedureCommit":0,"procedureParameter":"[]","remark":"医技系统-收费项目统计","system":"his","updateTime":1764231145000,"version":2},{"branch":"227049","branchmc":"南平市第一医院","button":"[]","catalog":"Tongji","chart":"[]","code":"ChargesItemsStatistics","column":"[{\"sys_hidden\":\"\",\"filter_name\":\"XMMC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":0,\"className\":\"\",\"title\":\"收费项目简称\",\"align\":\"left\",\"ora_name\":\"XMMC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"XMMC00\",\"summary\":\"\",\"minWidth\":\"180\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":0,\"round\":\"\",\"trunc\":\"\",\"field\":\"XMMC00\",\"sortType\":\"asc\",\"width\":\"206\",\"uiType\":\"\",\"footerAlign\":\"left\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SL0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":1,\"className\":\"\",\"title\":\"数量\",\"align\":\"left\",\"ora_name\":\"SL0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SL0000\",\"summary\":\"\",\"minWidth\":\"80\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":1,\"round\":\"\",\"trunc\":\"\",\"field\":\"SL0000\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"left\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"JE0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":2,\"className\":\"\",\"title\":\"金额\",\"align\":\"left\",\"ora_name\":\"JE0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"JE0000\",\"summary\":\"\",\"minWidth\":\"80\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":2,\"round\":\"\",\"trunc\":\"\",\"field\":\"JE0000\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"left\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"BZ0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":3,\"className\":\"\",\"title\":\"备注\",\"align\":\"left\",\"ora_name\":\"BZ0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"BZ0000\",\"summary\":\"\",\"minWidth\":\"160\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":3,\"round\":\"\",\"trunc\":\"\",\"field\":\"BZ0000\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"left\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"HS.HSXMMC\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":4,\"className\":\"\",\"title\":\"核算项目\",\"align\":\"center\",\"ora_name\":\"HSXMMC\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"HSXMMC\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":4,\"round\":\"\",\"trunc\":\"\",\"field\":\"HSXMMC\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"}]","condition":"[]","countSql":"\n<#assign ZYBR00 = myDirective.getParam(\"ZYBR00\")>\n<#assign MZBR00 = myDirective.getParam(\"MZBR00\")>\n\nselect \n count(*) as TOTAL, '合计' as xmmc00,sum(JE0000) as JE0000,sum(SL0000) as SL0000,'' as bz0000\nfrom (\n select SFXMID,--收费项目ID\n decode('${DZJEDDLC}','Y',JMBZ00,null) TYPE01,--是否为折扣\n sum(JE0000)JE0000, --项目金额\n sum(SL0000)SL0000 --项目数量\n from (\n /* 入参[DZJEDDLC]对应系统参数[YJ_TJDZDDFKLC]科室收费项目统计是否把打折的金额单独列出;Y:列出,默认值为N */\n select 0 JE0000,0 SL0000,-1 SFXMID,'0' JMBZ00, null XMGG00,null XMMC00,null BZ0000 from dual\n <#if (MZBR00 = \"1\") || (MZBR00 = \"0\" && ZYBR00 = \"0\")>\n union all\n select sum(a.HJJE00) JE0000,\n sum(a.XMSL00) SL0000, \n a.XMBH00 SFXMID,\n decode(nvl(a.JMBZ00,'0'),'0','0','2') JMBZ00 , --减免标志 2是减免\n a.XMGG00,\n b.XMMC00,\n b.BZ0000\n from SF_FYMX00 a,BM_YYSFXM b\n where a.Xmbh00=b.SFXMID\n and a.CZRQ00 between replace('${TJKSRQ}','-') and replace('${TJJSRQ}','-')\n and a.CZRQ00||a.CZSJ00 between replace('${TJKSRQ}','-')||'${TJKSSJ}' and replace('${TJJSRQ}','-')||'${TJJSSJ}'\n <#if BMBH00?default(\"\")?trim?length gt 0>\n and a.ZXKS00 =${BMBH00}\n \n <#if SFXMMC?default(\"\")?trim?length gt 0>\n and b.XMMC00 ='${SFXMMC}'\n \n group by a.XMBH00,decode(nvl(a.JMBZ00,'0'),'0','0','2'),a.XMGG00,b.XMMC00,b.BZ0000\n \n --勾选了住院病人或者都没有勾选\n <#if (ZYBR00 = \"1\") || (MZBR00 = \"0\" && ZYBR00 = \"0\")>\n union all\n select sum(a.HJJE00) JE0000, \n sum(a.XMSL00) SL0000, \n a.XMBH00 SFXMID, \n decode(nvl(a.JMBZ00,'0'),'0','0','2') JMBZ00, --减免标志 2是减免\n a.XMGG00,\n b.XMMC00,\n b.BZ0000\n from ZY_FYMX00 a,BM_YYSFXM b\n where a.xmbh00=b.SFXMID\n and a.CZRQ00 between replace('${TJKSRQ}','-') and replace('${TJJSRQ}','-')\n and a.CZRQ00||a.CZSJ00 between replace('${TJKSRQ}','-')||'${TJKSSJ}' and replace('${TJJSRQ}','-')||'${TJJSSJ}'\n <#if BMBH00?default(\"\")?trim?length gt 0>\n and a.ZXKS00 =${BMBH00}\n \n <#if SFXMMC?default(\"\")?trim?length gt 0>\n and b.XMMC00 ='${SFXMMC}'\n \n group by a.XMBH00,decode(nvl(a.JMBZ00,'0'),'0','0','2'),a.XMGG00,b.XMMC00,b.BZ0000\n \n )\n group by SFXMID ,decode('${DZJEDDLC}','Y',JMBZ00,null)\n) R\nwhere R.SFXMID >0","createTime":1757585820000,"entityVersion":0,"id":"ChargesItemsStatistics","isLaypage":"0","module":"yj","name":"ChargesItemsStatistics","pageSql":"<#assign ZYBR00 = myDirective.getParam(\"ZYBR00\")>\n<#assign MZBR00 = myDirective.getParam(\"MZBR00\")>\n\nselect \n(s.XMMC00||decode(R.TYPE01,'2','折扣',''))XMMC00, -- 项目名称\ns.BZ0000,--备注\nHS.HSXMMC,--核算项目名称\nR.* \nfrom (\n select SFXMID,--收费项目ID\n decode('${DZJEDDLC}','Y',JMBZ00,null) TYPE01,--是否为折扣\n sum(JE0000)JE0000, --项目金额\n sum(SL0000)SL0000 --项目数量\n from (\n /* 入参[DZJEDDLC]对应系统参数[YJ_TJDZDDFKLC]科室收费项目统计是否把打折的金额单独列出;Y:列出,默认值为N */\n select 0 JE0000,0 SL0000,-1 SFXMID,'0' JMBZ00,null XMGG00,null XMMC00,null BZ0000 from dual\n <#if (MZBR00 = \"1\") || (MZBR00 = \"0\" && ZYBR00 = \"0\")>\n union all\n select sum(a.HJJE00) JE0000,\n sum(a.XMSL00) SL0000, \n a.XMBH00 SFXMID,\n decode(nvl(a.JMBZ00,'0'),'0','0','2') JMBZ00 , --减免标志 2是减免\n a.XMGG00,\n b.XMMC00,\n b.BZ0000\n from SF_FYMX00 a,BM_YYSFXM b\n where a.Xmbh00=b.SFXMID\n and a.CZRQ00 between replace('${TJKSRQ}','-') and replace('${TJJSRQ}','-')\n and a.CZRQ00||a.CZSJ00 between replace('${TJKSRQ}','-')||'${TJKSSJ}' and replace('${TJJSRQ}','-')||'${TJJSSJ}'\n <#if BMBH00?default(\"\")?trim?length gt 0>\n and a.ZXKS00 =${BMBH00}\n \n <#if SFXMMC?default(\"\")?trim?length gt 0>\n and b.XMMC00 ='${SFXMMC}'\n \n group by a.XMBH00,decode(nvl(a.JMBZ00,'0'),'0','0','2'),a.XMGG00,b.XMMC00,b.BZ0000\n \n --勾选了住院病人或者都没有勾选\n <#if (ZYBR00 = \"1\") || (MZBR00 = \"0\" && ZYBR00 = \"0\")>\n union all\n select sum(a.HJJE00) JE0000, \n sum(a.XMSL00) SL0000, \n a.XMBH00 SFXMID, \n decode(nvl(a.JMBZ00,'0'),'0','0','2') JMBZ00, --减免标志 2是减免\n a.XMGG00,\n b.XMMC00,\n b.BZ0000\n from ZY_FYMX00 a,BM_YYSFXM b\n where a.xmbh00=b.SFXMID\n and CZRQ00 between replace('${TJKSRQ}','-') and replace('${TJJSRQ}','-')\n and CZRQ00||CZSJ00 between replace('${TJKSRQ}','-')||'${TJKSSJ}' and replace('${TJJSRQ}','-')||'${TJJSSJ}'\n <#if BMBH00?default(\"\")?trim?length gt 0>\n and a.ZXKS00 =${BMBH00}\n \n <#if SFXMMC?default(\"\")?trim?length gt 0>\n and b.XMMC00 ='${SFXMMC}'\n \n group by a.XMBH00,decode(nvl(a.JMBZ00,'0'),'0','0','2'),a.XMGG00,b.XMMC00,b.BZ0000\n \n )\n group by SFXMID ,decode('${DZJEDDLC}','Y',JMBZ00,null)\n) R,BM_YYSFXM S,BM_YYHSXM HS\nwhere R.SFXMID = S.SFXMID and S.HSXMID=HS.HSXMID(+)\norder by S.HSXMID,S.SFXMID","procedureCommit":0,"procedureParameter":"[]","remark":"医技系统-收费项目统计","system":"his","updateTime":1757585820000,"version":2}]