[{"branch":"0","branchmc":"standard","button":"[]","catalog":"medicalCard","chart":"[]","code":"qrySettlementInquiry","column":"[{\"filter_name\":\"JZDH00\",\"hidden\":false,\"LAY_TABLE_INDEX\":0,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"结算单号\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":0,\"ora_name\":\"JZDH00\",\"field\":\"JZDH00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"JZDH00\"},{\"filter_name\":\"XM0000\",\"hidden\":false,\"LAY_TABLE_INDEX\":1,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"姓名\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":1,\"ora_name\":\"XM0000\",\"field\":\"XM0000\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"XM0000\"},{\"filter_name\":\"XB0000\",\"hidden\":false,\"LAY_TABLE_INDEX\":2,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"性别\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":2,\"ora_name\":\"XB0000\",\"field\":\"XB0000\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"XB0000\"},{\"filter_name\":\"NL0000\",\"hidden\":false,\"LAY_TABLE_INDEX\":3,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"年龄\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":3,\"ora_name\":\"NL0000\",\"field\":\"NL0000\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"NL0000\"},{\"filter_name\":\"YBKH00\",\"hidden\":false,\"LAY_TABLE_INDEX\":4,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"医保卡号\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":4,\"ora_name\":\"YBKH00\",\"field\":\"YBKH00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YBKH00\"},{\"filter_name\":\"GHH000\",\"hidden\":false,\"LAY_TABLE_INDEX\":5,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"挂号号\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":5,\"ora_name\":\"GHH000\",\"field\":\"GHH000\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"GHH000\"},{\"filter_name\":\"JZYSXM\",\"hidden\":false,\"LAY_TABLE_INDEX\":6,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"就诊医生\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":6,\"ora_name\":\"JZYSXM\",\"field\":\"JZYSXM\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"JZYSXM\"},{\"filter_name\":\"JZKSMC\",\"hidden\":false,\"LAY_TABLE_INDEX\":7,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"就诊科室\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":7,\"ora_name\":\"JZKSMC\",\"field\":\"JZKSMC\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"JZKSMC\"},{\"filter_name\":\"FPBH00\",\"hidden\":false,\"LAY_TABLE_INDEX\":8,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"发票编号\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":8,\"ora_name\":\"FPBH00\",\"field\":\"FPBH00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"FPBH00\"},{\"filter_name\":\"JZRQ00\",\"hidden\":false,\"LAY_TABLE_INDEX\":9,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"结算日期\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":9,\"ora_name\":\"JZRQ00\",\"field\":\"JZRQ00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"JZRQ00\"},{\"filter_name\":\"JZSJ00\",\"hidden\":false,\"LAY_TABLE_INDEX\":10,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"结算时间\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":10,\"ora_name\":\"JZSJ00\",\"field\":\"JZSJ00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"JZSJ00\"},{\"filter_name\":\"CZYXM0\",\"hidden\":false,\"LAY_TABLE_INDEX\":11,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"结算员\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":11,\"ora_name\":\"CZYXM0\",\"field\":\"CZYXM0\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"CZYXM0\"},{\"filter_name\":\"YBDJH0\",\"hidden\":false,\"LAY_TABLE_INDEX\":12,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"医保流水号\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":12,\"ora_name\":\"YBDJH0\",\"field\":\"YBDJH0\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YBDJH0\"},{\"filter_name\":\"YBMC00\",\"hidden\":false,\"LAY_TABLE_INDEX\":13,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"医保分中心\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":13,\"ora_name\":\"YBMC00\",\"field\":\"YBMC00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YBMC00\"},{\"sys_hidden\":\"\",\"filter_name\":\"(select BRLBMC from BM_YBBRLB y,IC_YBBRLB i where y.YBZXLB=i.YBZXLB and y.FBBH00=b. FBBH00 and i. YBLB00=b. YBLB00 and y.YBBRLB=b.ybbrlb)\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":14,\"className\":\"\",\"title\":\"病人类别\",\"align\":\"center\",\"ora_name\":\"BRLBMC\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"BRLBMC\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":14,\"round\":\"\",\"trunc\":\"\",\"field\":\"BRLBMC\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"filter_name\":\"TSBZMC\",\"hidden\":false,\"LAY_TABLE_INDEX\":15,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"特殊病种\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":15,\"ora_name\":\"TSBZMC\",\"field\":\"TSBZMC\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"TSBZMC\"},{\"filter_name\":\"HJJE00\",\"hidden\":false,\"LAY_TABLE_INDEX\":16,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"合计金额\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":16,\"ora_name\":\"HJJE00\",\"field\":\"HJJE00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"HJJE00\"},{\"filter_name\":\"ZFJE00\",\"hidden\":false,\"LAY_TABLE_INDEX\":17,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"个人自付\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":17,\"ora_name\":\"ZFJE00\",\"field\":\"ZFJE00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"ZFJE00\"},{\"filter_name\":\"GRZHZF\",\"hidden\":false,\"LAY_TABLE_INDEX\":18,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"个人账户支付\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":18,\"ora_name\":\"GRZHZF\",\"field\":\"GRZHZF\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"GRZHZF\"},{\"filter_name\":\"TCJJZF\",\"hidden\":false,\"LAY_TABLE_INDEX\":19,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"统筹基金\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":19,\"ora_name\":\"TCJJZF\",\"field\":\"TCJJZF\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"TCJJZF\"},{\"filter_name\":\"SBGRZH\",\"hidden\":false,\"LAY_TABLE_INDEX\":20,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"商保账户\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":20,\"ora_name\":\"SBGRZH\",\"field\":\"SBGRZH\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SBGRZH\"},{\"filter_name\":\"SBTCJJ\",\"hidden\":false,\"LAY_TABLE_INDEX\":21,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"商保基金\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":21,\"ora_name\":\"SBTCJJ\",\"field\":\"SBTCJJ\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SBTCJJ\"},{\"filter_name\":\"YBYL01\",\"hidden\":false,\"LAY_TABLE_INDEX\":22,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"民政救助\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":22,\"ora_name\":\"YBYL01\",\"field\":\"YBYL01\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YBYL01\"},{\"filter_name\":\"YBYL24\",\"hidden\":false,\"LAY_TABLE_INDEX\":23,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"大额医疗费用报销金额\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":23,\"ora_name\":\"YBYL24\",\"field\":\"YBYL24\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YBYL24\"},{\"filter_name\":\"JZJE00\",\"hidden\":false,\"LAY_TABLE_INDEX\":24,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"记账金额\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":24,\"ora_name\":\"JZJE00\",\"field\":\"JZJE00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"JZJE00\"},{\"sys_hidden\":\"\",\"filter_name\":\"(select BRZJE0-ZFJE00 from SF_JZB000 where jzdh00=b.JZDH00)\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":25,\"className\":\"\",\"title\":\"目录内费用\",\"align\":\"\",\"ora_name\":\"NLNJE0\",\"headerAlign\":\"\",\"render\":\"\",\"key\":\"NLNJE0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":25,\"round\":\"\",\"trunc\":\"\",\"field\":\"NLNJE0\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"nvl((select sum(XMJE00) from SF_JZMX00 aa where aa.jzdh00=b.jzdh00 and aa.XMBH00 in (1,2,3)),0)\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":26,\"className\":\"\",\"title\":\"药品合计\",\"align\":\"\",\"ora_name\":\"YPHJJE\",\"headerAlign\":\"\",\"render\":\"\",\"key\":\"YPHJJE\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":26,\"round\":\"\",\"trunc\":\"\",\"field\":\"YPHJJE\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"nvl((select sum(XMJE00) from SF_JZMX00 aa where aa.jzdh00=b.jzdh00 and aa.XMBH00  in (8,14,15,16)),0)\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":27,\"className\":\"\",\"title\":\"检查合计\",\"align\":\"\",\"ora_name\":\"JCHJJE\",\"headerAlign\":\"\",\"render\":\"\",\"key\":\"JCHJJE\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":27,\"round\":\"\",\"trunc\":\"\",\"field\":\"JCHJJE\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"},{\"filter_name\":\"YBYL48\",\"hidden\":false,\"LAY_TABLE_INDEX\":28,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"精准慈善救助\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":28,\"ora_name\":\"YBYL48\",\"field\":\"YBYL48\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YBYL48\"},{\"filter_name\":\"YBYL46\",\"hidden\":false,\"LAY_TABLE_INDEX\":29,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"精准扶贫1\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":29,\"ora_name\":\"YBYL46\",\"field\":\"YBYL46\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YBYL46\"},{\"filter_name\":\"YBYL47\",\"hidden\":false,\"LAY_TABLE_INDEX\":30,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"精准扶贫2\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":30,\"ora_name\":\"YBYL47\",\"field\":\"YBYL47\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YBYL47\"},{\"filter_name\":\"YYJC00\",\"hidden\":false,\"LAY_TABLE_INDEX\":31,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"分院名称\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":31,\"ora_name\":\"YYJC00\",\"field\":\"YYJC00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YYJC00\"},{\"sys_hidden\":\"\",\"filter_name\":\"(select ZDMC00 from YS_BRZDXX bb where bb.GHID00=b.GHID00 and bb.ZZDBZ0 in ('3') and rownum=1)\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":32,\"className\":\"\",\"title\":\"诊断名称\",\"align\":\"\",\"ora_name\":\"ZDMC00\",\"headerAlign\":\"\",\"render\":\"\",\"key\":\"ZDMC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":32,\"round\":\"\",\"trunc\":\"\",\"field\":\"ZDMC00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"\",\"fixed\":\"\"}]","condition":"[]","countSql":"select  COUNT(1) as TOTAL,count(*) GHH000,sum(HJJE00) HJJE00,sum(ZFJE00) ZFJE00,sum(GRZHZF) GRZHZF,\nsum(TCJJZF) TCJJZF,sum(SBGRZH) SBGRZH,sum(SBTCJJ) SBTCJJ,sum(YBYL01) YBYL01,sum(YBYL24) YBYL24,\nsum(JZJE00) JZJE00,sum(NLNJE0) NLNJE0,\nsum(YPHJJE) YPHJJE,\nsum(JCHJJE) JCHJJE,\nsum(YBYL48) YBYL48,sum(YBYL46) YBYL46,sum(YBYL47) YBYL47\nfrom (select JZDH00,XM0000,XB0000,NL0000,YBKH00,GHH000,JZYSXM,JZKSMC,FPBH00,JZRQ00,JZSJ00,\nCZYXM0,YBDJH0,YBMC00,TSBZMC,HJJE00,ZFJE00,GRZHZF,TCJJZF,SBGRZH,SBTCJJ,YBYL01,YBYL24,\nJZJE00,YBYL48,YBYL46,YBYL47,YYJC00,\n(select BRZJE0-ZFJE00 from SF_JZB000 where jzdh00=b.JZDH00) NLNJE0,\n nvl((select sum(XMJE00) from SF_JZMX00 aa where aa.jzdh00=b.jzdh00 and aa.XMBH00 in (1,2,3)),0)YPHJJE,\n nvl((select sum(XMJE00) from SF_JZMX00 aa where aa.jzdh00=b.jzdh00 and aa.XMBH00  in (8,14,15,16)),0) as JCHJJE,\n (select ZDMC00 from YS_BRZDXX bb where bb.GHID00=b.GHID00 and bb.ZZDBZ0 in ('3') and rownum=1) ZDMC00\nfrom VW_SF_MZJSCX b where 1=1\nand JZRQ00 between '${BEGINDAY}' and '${ENDDAY}'\nand JZRQ00||JZSJ00 between '${QSSJ00}' and '${ZZSJ00}'\n<#if CZYXM0?default(\"\")?trim?length gt 0>\n       and  CZYXM0 = '${CZYXM0}' \n</#if>\n<#if FBBH00?default(\"\")?trim?length gt 0>\n       and  FBBH00 = '${FBBH00}' \n</#if>\n<#if YBLB00?default(\"\")?trim?length gt 0>\n       and  YBLB00 = '${YBLB00}' \n</#if>\n<#if YBBRLB?default(\"\")?trim?length gt 0>\n       and  YBBRLB = '${YBBRLB}' \n</#if>\n<#if YYID00?default(\"\")?trim?length gt 0>\n       and  YYID00 = '${YYID00}' \n</#if>\n<#if JSFS00?default(\"\")?trim?length gt 0>\n      and b.JSFS00='${JSFS00}' \n</#if>\n<#if TSBZ00 == '1'>\n       and TSBZBH is not null\n</#if>\n)","createTime":1593754277000,"entityVersion":0,"id":"qrySettlementInquiry","isLaypage":"1","module":"mzsf","name":"qrySettlementInquiry","pageSql":"select JZDH00,XM0000,XB0000,NL0000,YBKH00,GHH000,JZYSXM,JZKSMC,FPBH00,JZRQ00,JZSJ00,\nCZYXM0,YBDJH0,YBMC00,TSBZMC,HJJE00,ZFJE00,GRZHZF,TCJJZF,SBGRZH,SBTCJJ,YBYL01,YBYL24,\nJZJE00,YBYL48,YBYL46,YBYL47,YYJC00,\n(select BRZJE0-ZFJE00 from SF_JZB000 where jzdh00=b.JZDH00) NLNJE0,\n nvl((select sum(XMJE00) from SF_JZMX00 aa where aa.jzdh00=b.jzdh00 and aa.XMBH00 in (1,2,3)),0)YPHJJE,\n nvl((select sum(XMJE00) from SF_JZMX00 aa where aa.jzdh00=b.jzdh00 and aa.XMBH00  in (8,14,15,16)),0) as JCHJJE,\n (select ZDMC00 from YS_BRZDXX bb where bb.GHID00=b.GHID00 and bb.ZZDBZ0 in ('3') and rownum=1) ZDMC00,\n (select BRLBMC from BM_YBBRLB y,IC_YBBRLB i where y.YBZXLB=i.YBZXLB and y.FBBH00=b. FBBH00 and i. YBLB00=b. YBLB00 and y.YBBRLB=b.ybbrlb) BRLBMC\nfrom VW_SF_MZJSCX b where 1=1\nand JZRQ00 between '${BEGINDAY}' and '${ENDDAY}'\nand JZRQ00||JZSJ00 between '${QSSJ00}' and '${ZZSJ00}'\n<#if CZYXM0?default(\"\")?trim?length gt 0>\n       and  CZYXM0 = '${CZYXM0}' \n</#if>\n<#if FBBH00?default(\"\")?trim?length gt 0>\n       and  FBBH00 = '${FBBH00}' \n</#if>\n<#if YBLB00?default(\"\")?trim?length gt 0>\n       and  YBLB00 = '${YBLB00}' \n</#if>\n<#if YBBRLB?default(\"\")?trim?length gt 0>\n       and  YBBRLB = '${YBBRLB}' \n</#if>\n<#if YYID00?default(\"\")?trim?length gt 0>\n       and  YYID00 = '${YYID00}' \n</#if>\n<#if JSFS00?default(\"\")?trim?length gt 0>\n      and b.JSFS00='${JSFS00}' \n</#if>\n<#if TSBZ00 == '1'>\n       and TSBZBH is not null\n</#if>\n","procedureCommit":0,"procedureParameter":"[]","remark":"门诊病人结算查询","system":"his","updateTime":1704703487000,"version":2}]