{"printBb":[{"branch":"0","branchmc":"standard","code":"printYF_CRMXTJABQ","createTime":1716800596000,"entityVersion":0,"fr3Name":"药房_出入明细统计_按病区.frx","id":"printYF_CRMXTJABQ","inParam":"[{\"name\":\"TJDWBH\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":0},{\"name\":\"gsSFDLSJGL\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":1},{\"name\":\"YFBMBH\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":2},{\"name\":\"YF_SFSYSTYPMXZ1\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":3},{\"name\":\"ChkCKLXCheckFlag\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":4},{\"name\":\"ChkRKLXCheckFlag\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":5},{\"name\":\"checkedRKLXBHs\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":6},{\"name\":\"checkedCKLXBHs\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":7},{\"name\":\"YPFRFlag\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":8},{\"name\":\"SFDJFlag\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":9},{\"name\":\"LBBH00\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":10},{\"name\":\"YLBH00\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":11},{\"name\":\"JXBH00\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":12},{\"name\":\"startDate\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":13},{\"name\":\"endDate\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":14},{\"name\":\"startTime\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":15},{\"name\":\"endTime\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":16},{\"name\":\"YF_SFXSCFTJZY\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":17},{\"name\":\"PXBH00\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":18},{\"name\":\"BYTJID\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":19}]","inParams":[{"deFault":"","fieldType":"String","isRequired":true,"name":"TJDWBH","proceduresParam":"","remark":"","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"gsSFDLSJGL","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":true,"name":"YFBMBH","proceduresParam":"","remark":"","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"YF_SFSYSTYPMXZ1","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"ChkCKLXCheckFlag","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"ChkRKLXCheckFlag","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"checkedRKLXBHs","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"checkedCKLXBHs","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"YPFRFlag","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"SFDJFlag","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"LBBH00","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"YLBH00","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"JXBH00","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":true,"name":"startDate","proceduresParam":"","remark":"","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":true,"name":"endDate","proceduresParam":"","remark":"","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":true,"name":"startTime","proceduresParam":"","remark":"","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":true,"name":"endTime","proceduresParam":"","remark":"","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"YF_SFXSCFTJZY","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"PXBH00","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"BYTJID","proceduresParam":"","remark":"","required":false,"testParam":""}],"name":"printYF_CRMXTJABQ","outParam":"[{\"dataSources\":\"sql\",\"name\":\"tableMain\",\"outfieldType\":\"String\",\"value\":\"tableMain\",\"deFault\":\"SJKCSL\",\"remark\":\"\",\"paramType\":\"tableMain\",\"LAY_TABLE_INDEX\":0},{\"dataSources\":\"inParam\",\"name\":\"printMode\",\"outfieldType\":\"String\",\"value\":\"PRINTMODE\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"parameter\",\"LAY_TABLE_INDEX\":1},{\"dataSources\":\"inParam\",\"name\":\"startDate\",\"outfieldType\":\"String\",\"value\":\"startDate\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"parameter\",\"LAY_TABLE_INDEX\":2},{\"dataSources\":\"inParam\",\"name\":\"endDate\",\"outfieldType\":\"String\",\"value\":\"endDate\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"parameter\",\"LAY_TABLE_INDEX\":3},{\"dataSources\":\"departments\",\"name\":\"YFBMMC\",\"outfieldType\":\"String\",\"value\":\"\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"parameter\",\"LAY_TABLE_INDEX\":4}]","outParams":[{"dataSources":"sql","deFault":"SJKCSL","name":"tableMain","outfieldType":"String","paramType":"tableMain","remark":"","value":"tableMain"},{"dataSources":"inParam","deFault":"","name":"printMode","outfieldType":"String","paramType":"parameter","remark":"","value":"PRINTMODE"},{"dataSources":"inParam","deFault":"","name":"startDate","outfieldType":"String","paramType":"parameter","remark":"","value":"startDate"},{"dataSources":"inParam","deFault":"","name":"endDate","outfieldType":"String","paramType":"parameter","remark":"","value":"endDate"},{"dataSources":"departments","deFault":"","name":"YFBMMC","outfieldType":"String","paramType":"parameter","remark":"","value":""}],"printType":"FRX","sql":"[{\"name\":\"tableMain\",\"sql\":\"select YPMC00,YPGG00,YPBM00,CKBMBH,SJKCSL,CKBMMC,KCDW00,DM0000,KSS000,SCCJZW,BYTJID,FCDJ01,\\nstartYEAR,startMOON,startDAY,startHOUR,startMIN,startSEC,startNIAN,startYUE,startRI,startSHI,startFEN,startMIAO,\\nsum(FCSL01) FCSL01,sum(FCSL02) FCSL02,sum(FCSL03) FCSL03,sum(FCJE01) FCJE01,sum(FCJE02) FCJE02,sum(FCJE03) FCJE03\\nfrom(\\nselect A.YPMC00,A.YPGG00,B.YPBM00,D.CKBMBH,\\nnvl((select SJKCSL   from vw_yf_pckchz where YFBMBH=A.YFBMBH and YPNM00=A.YPNM00),0) SJKCSL,\\n(select BMMC00 from BM_BMBM00 where BMBH00=D.CKBMBH) CKBMMC,\\n<#if TJDWBH=='0'>\\n    B.KCDW00 KCDW00,\\n<#elseif TJDWBH=='1'>\\n    B.MZFYDW KCDW00,\\n<#elseif TJDWBH=='2'>\\n    B.ZYFYDW KCDW00,\\n</#if>\\n( case when  B.MZDJ00<>'0' then '麻醉'  when B.SJDJ00<>'1' and B.SJDJ00<>'0'  then '二类精神药品' when  B.SJDJ00='1' then  '一类精神药品'  when B.DPDJ00<>'0' then '毒品' else '普通' end )  DM0000 ,\\n( select MC0000 from VW_YK_YDKSSJB where BH0000 = B.KSSJB0 ) KSS000,\\n<#if TJDWBH=='0'>\\n    decode(sign(A.FCSL00),-1,round(abs(FCSL00)*a.ZHL000/B.K2J000,3),0) FCSL01,\\n    decode(sign(A.FCSL00),1,round(FCSL00*a.ZHL000/B.K2J000,3),0) FCSL02,\\n    round(FCSL00*a.ZHL000/B.K2J000,3) FCSL03,\\n<#elseif TJDWBH=='1'>\\n    decode(sign(A.FCSL00),-1,round(abs(FCSL00)*a.ZHL000/B.M2J000,3),0) FCSL01,\\n    decode(sign(A.FCSL00),1,round(FCSL00*a.ZHL000/B.M2J000,3),0) FCSL02,\\n    round(FCSL00*a.ZHL000/B.M2J000,3) FCSL03,\\n   \\n<#elseif TJDWBH=='2'>\\n    decode(sign(A.FCSL00),-1,round(abs(FCSL00)*a.ZHL000/B.Z2J000,3),0) FCSL01,\\n    decode(sign(A.FCSL00),1,round(FCSL00*a.ZHL000/B.Z2J000,3),0) FCSL02,\\n    round(FCSL00*a.ZHL000/B.Z2J000,3) FCSL03,\\n</#if>\\na.FCDJ00 FCDJ01,\\ndecode(sign(A.FCSL00),-1,abs(FCJE00),0) FCJE01,\\ndecode(sign(A.FCSL00),1,FCJE00,0) FCJE02,\\na.FCJE00 FCJE03,\\n(select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH ) SCCJZW,\\ndecode(nvl(D.BYTJID,'-1'),'-1',(select BYTJID from YF_YPCKD0 X ,YF_YZYPSQ y,YF_YZYPSQ t where x.CKDH00=t.CKDH00 and y.YPQLPC=a.YPCKPC and t.YPQLPC=y.CXPCID   ),d.BYTJID) BYTJID,\\nsubstr('${startTime}', 1, 4) || '年'startYEAR ,\\n       substr('${startTime}', 5, 2) || '月'startMOON,\\n       substr('${startTime}', 7, 2) || '日' startDAY,\\n       substr('${startTime}', 9, 2) || '时'startHOUR,\\n       substr('${startTime}', 12, 2) || '分'startMIN,\\n       substr('${startTime}', 15, 2) || '秒'startSEC,\\n       substr('${endTime}', 1, 4) || '年'startNIAN ,\\n       substr('${endTime}', 5, 2) || '月'startYUE,\\n       substr('${endTime}', 7, 2) || '日' startRI,\\n       substr('${endTime}', 9, 2) || '时'startSHI,\\n       substr('${endTime}', 12, 2) || '分'startFEN,\\n       substr('${endTime}', 15, 2) || '秒'startMIAO\\nfrom YF_YPMXZ0 A, BM_YD0000 B,YF_YPCKD0 D\\nwhere a.YPNM00=B.YPNM00\\n  and A.YFBMBH=${YFBMBH}\\n  and A.JZRQ00 between '${startDate}' and '${endDate}'\\n  and A.JZRQ00||A.JZSJ00>='${startTime}' and A.JZRQ00||A.JZSJ00<='${endTime}'\\n  and A.DJH000=D.CKDH00 and A.JZRQ00=D.QRRQ00\\n  and B.LBBH00 like '${LBBH00}%'\\n  and B.YLBH00 like '${YLBH00}%'\\n  and B.JXBH00 like '${JXBH00}%'\\n\\n) where 1=1\\n<#if  ( BYTJID?default(\\\"\\\")?trim?length gt 0 && BYTJID !='0')>\\n    and BYTJID=${BYTJID}\\n</#if>\\ngroup by YPMC00,YPGG00,YPBM00,CKBMBH,SJKCSL,CKBMMC,KCDW00,DM0000,KSS000,SCCJZW,BYTJID,FCDJ01,\\nstartYEAR,startMOON,startDAY,startHOUR,startMIN,startSEC,startNIAN,startYUE,startRI,startSHI,startFEN,startMIAO\\norder by CKBMBH,YPMC00\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"LAY_TABLE_INDEX\":0}]","sqls":[{"isCommit":false,"isProcedures":false,"name":"tableMain","remark":"","sql":"select YPMC00,YPGG00,YPBM00,CKBMBH,SJKCSL,CKBMMC,KCDW00,DM0000,KSS000,SCCJZW,BYTJID,FCDJ01,\nstartYEAR,startMOON,startDAY,startHOUR,startMIN,startSEC,startNIAN,startYUE,startRI,startSHI,startFEN,startMIAO,\nsum(FCSL01) FCSL01,sum(FCSL02) FCSL02,sum(FCSL03) FCSL03,sum(FCJE01) FCJE01,sum(FCJE02) FCJE02,sum(FCJE03) FCJE03\nfrom(\nselect A.YPMC00,A.YPGG00,B.YPBM00,D.CKBMBH,\nnvl((select SJKCSL   from vw_yf_pckchz where YFBMBH=A.YFBMBH and YPNM00=A.YPNM00),0) SJKCSL,\n(select BMMC00 from BM_BMBM00 where BMBH00=D.CKBMBH) CKBMMC,\n<#if TJDWBH=='0'>\n    B.KCDW00 KCDW00,\n<#elseif TJDWBH=='1'>\n    B.MZFYDW KCDW00,\n<#elseif TJDWBH=='2'>\n    B.ZYFYDW KCDW00,\n</#if>\n( case when  B.MZDJ00<>'0' then '麻醉'  when B.SJDJ00<>'1' and B.SJDJ00<>'0'  then '二类精神药品' when  B.SJDJ00='1' then  '一类精神药品'  when B.DPDJ00<>'0' then '毒品' else '普通' end )  DM0000 ,\n( select MC0000 from VW_YK_YDKSSJB where BH0000 = B.KSSJB0 ) KSS000,\n<#if TJDWBH=='0'>\n    decode(sign(A.FCSL00),-1,round(abs(FCSL00)*a.ZHL000/B.K2J000,3),0) FCSL01,\n    decode(sign(A.FCSL00),1,round(FCSL00*a.ZHL000/B.K2J000,3),0) FCSL02,\n    round(FCSL00*a.ZHL000/B.K2J000,3) FCSL03,\n<#elseif TJDWBH=='1'>\n    decode(sign(A.FCSL00),-1,round(abs(FCSL00)*a.ZHL000/B.M2J000,3),0) FCSL01,\n    decode(sign(A.FCSL00),1,round(FCSL00*a.ZHL000/B.M2J000,3),0) FCSL02,\n    round(FCSL00*a.ZHL000/B.M2J000,3) FCSL03,\n   \n<#elseif TJDWBH=='2'>\n    decode(sign(A.FCSL00),-1,round(abs(FCSL00)*a.ZHL000/B.Z2J000,3),0) FCSL01,\n    decode(sign(A.FCSL00),1,round(FCSL00*a.ZHL000/B.Z2J000,3),0) FCSL02,\n    round(FCSL00*a.ZHL000/B.Z2J000,3) FCSL03,\n</#if>\na.FCDJ00 FCDJ01,\ndecode(sign(A.FCSL00),-1,abs(FCJE00),0) FCJE01,\ndecode(sign(A.FCSL00),1,FCJE00,0) FCJE02,\na.FCJE00 FCJE03,\n(select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH ) SCCJZW,\ndecode(nvl(D.BYTJID,'-1'),'-1',(select BYTJID from YF_YPCKD0 X ,YF_YZYPSQ y,YF_YZYPSQ t where x.CKDH00=t.CKDH00 and y.YPQLPC=a.YPCKPC and t.YPQLPC=y.CXPCID   ),d.BYTJID) BYTJID,\nsubstr('${startTime}', 1, 4) || '年'startYEAR ,\n       substr('${startTime}', 5, 2) || '月'startMOON,\n       substr('${startTime}', 7, 2) || '日' startDAY,\n       substr('${startTime}', 9, 2) || '时'startHOUR,\n       substr('${startTime}', 12, 2) || '分'startMIN,\n       substr('${startTime}', 15, 2) || '秒'startSEC,\n       substr('${endTime}', 1, 4) || '年'startNIAN ,\n       substr('${endTime}', 5, 2) || '月'startYUE,\n       substr('${endTime}', 7, 2) || '日' startRI,\n       substr('${endTime}', 9, 2) || '时'startSHI,\n       substr('${endTime}', 12, 2) || '分'startFEN,\n       substr('${endTime}', 15, 2) || '秒'startMIAO\nfrom YF_YPMXZ0 A, BM_YD0000 B,YF_YPCKD0 D\nwhere a.YPNM00=B.YPNM00\n  and A.YFBMBH=${YFBMBH}\n  and A.JZRQ00 between '${startDate}' and '${endDate}'\n  and A.JZRQ00||A.JZSJ00>='${startTime}' and A.JZRQ00||A.JZSJ00<='${endTime}'\n  and A.DJH000=D.CKDH00 and A.JZRQ00=D.QRRQ00\n  and B.LBBH00 like '${LBBH00}%'\n  and B.YLBH00 like '${YLBH00}%'\n  and B.JXBH00 like '${JXBH00}%'\n\n) where 1=1\n<#if  ( BYTJID?default(\"\")?trim?length gt 0 && BYTJID !='0')>\n    and BYTJID=${BYTJID}\n</#if>\ngroup by YPMC00,YPGG00,YPBM00,CKBMBH,SJKCSL,CKBMMC,KCDW00,DM0000,KSS000,SCCJZW,BYTJID,FCDJ01,\nstartYEAR,startMOON,startDAY,startHOUR,startMIN,startSEC,startNIAN,startYUE,startRI,startSHI,startFEN,startMIAO\norder by CKBMBH,YPMC00"}],"updateTime":1739773169000,"versions":1}],"printPz":[{"catalog":"Tongji","code":"printYF_CRMXTJABQ","entityVersion":0,"id":"printYF_CRMXTJABQ","module":"yf","name":"printYF_CRMXTJABQ","nowVersions":1,"remark":"药房_出入明细统计_按病区","system":"his"}],"printAll":[{"branch":"0","branchmc":"standard","catalog":"Tongji","code":"printYF_CRMXTJABQ","createTime":1716800596000,"entityVersion":0,"fr3Name":"药房_出入明细统计_按病区.frx","id":"printYF_CRMXTJABQ","inParam":"[{\"name\":\"TJDWBH\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":0},{\"name\":\"gsSFDLSJGL\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":1},{\"name\":\"YFBMBH\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":2},{\"name\":\"YF_SFSYSTYPMXZ1\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":3},{\"name\":\"ChkCKLXCheckFlag\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":4},{\"name\":\"ChkRKLXCheckFlag\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":5},{\"name\":\"checkedRKLXBHs\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":6},{\"name\":\"checkedCKLXBHs\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":7},{\"name\":\"YPFRFlag\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":8},{\"name\":\"SFDJFlag\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":9},{\"name\":\"LBBH00\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":10},{\"name\":\"YLBH00\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":11},{\"name\":\"JXBH00\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":12},{\"name\":\"startDate\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":13},{\"name\":\"endDate\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":14},{\"name\":\"startTime\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":15},{\"name\":\"endTime\",\"isRequired\":true,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":true,\"LAY_TABLE_INDEX\":16},{\"name\":\"YF_SFXSCFTJZY\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":17},{\"name\":\"PXBH00\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":18},{\"name\":\"BYTJID\",\"isRequired\":false,\"deFault\":\"\",\"remark\":\"\",\"fieldType\":\"String\",\"proceduresParam\":\"\",\"testParam\":\"\",\"required\":false,\"LAY_TABLE_INDEX\":19}]","inParams":[{"deFault":"","fieldType":"String","isRequired":true,"name":"TJDWBH","proceduresParam":"","remark":"","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"gsSFDLSJGL","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":true,"name":"YFBMBH","proceduresParam":"","remark":"","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"YF_SFSYSTYPMXZ1","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"ChkCKLXCheckFlag","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"ChkRKLXCheckFlag","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"checkedRKLXBHs","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"checkedCKLXBHs","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"YPFRFlag","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"SFDJFlag","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"LBBH00","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"YLBH00","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"JXBH00","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":true,"name":"startDate","proceduresParam":"","remark":"","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":true,"name":"endDate","proceduresParam":"","remark":"","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":true,"name":"startTime","proceduresParam":"","remark":"","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":true,"name":"endTime","proceduresParam":"","remark":"","required":true,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"YF_SFXSCFTJZY","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"PXBH00","proceduresParam":"","remark":"","required":false,"testParam":""},{"deFault":"","fieldType":"String","isRequired":false,"name":"BYTJID","proceduresParam":"","remark":"","required":false,"testParam":""}],"module":"yf","name":"printYF_CRMXTJABQ","nowVersions":1,"outParam":"[{\"dataSources\":\"sql\",\"name\":\"tableMain\",\"outfieldType\":\"String\",\"value\":\"tableMain\",\"deFault\":\"SJKCSL\",\"remark\":\"\",\"paramType\":\"tableMain\",\"LAY_TABLE_INDEX\":0},{\"dataSources\":\"inParam\",\"name\":\"printMode\",\"outfieldType\":\"String\",\"value\":\"PRINTMODE\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"parameter\",\"LAY_TABLE_INDEX\":1},{\"dataSources\":\"inParam\",\"name\":\"startDate\",\"outfieldType\":\"String\",\"value\":\"startDate\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"parameter\",\"LAY_TABLE_INDEX\":2},{\"dataSources\":\"inParam\",\"name\":\"endDate\",\"outfieldType\":\"String\",\"value\":\"endDate\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"parameter\",\"LAY_TABLE_INDEX\":3},{\"dataSources\":\"departments\",\"name\":\"YFBMMC\",\"outfieldType\":\"String\",\"value\":\"\",\"deFault\":\"\",\"remark\":\"\",\"paramType\":\"parameter\",\"LAY_TABLE_INDEX\":4}]","outParams":[{"dataSources":"sql","deFault":"SJKCSL","name":"tableMain","outfieldType":"String","paramType":"tableMain","remark":"","value":"tableMain"},{"dataSources":"inParam","deFault":"","name":"printMode","outfieldType":"String","paramType":"parameter","remark":"","value":"PRINTMODE"},{"dataSources":"inParam","deFault":"","name":"startDate","outfieldType":"String","paramType":"parameter","remark":"","value":"startDate"},{"dataSources":"inParam","deFault":"","name":"endDate","outfieldType":"String","paramType":"parameter","remark":"","value":"endDate"},{"dataSources":"departments","deFault":"","name":"YFBMMC","outfieldType":"String","paramType":"parameter","remark":"","value":""}],"printType":"FRX","remark":"药房_出入明细统计_按病区","sql":"[{\"name\":\"tableMain\",\"sql\":\"select YPMC00,YPGG00,YPBM00,CKBMBH,SJKCSL,CKBMMC,KCDW00,DM0000,KSS000,SCCJZW,BYTJID,FCDJ01,\\nstartYEAR,startMOON,startDAY,startHOUR,startMIN,startSEC,startNIAN,startYUE,startRI,startSHI,startFEN,startMIAO,\\nsum(FCSL01) FCSL01,sum(FCSL02) FCSL02,sum(FCSL03) FCSL03,sum(FCJE01) FCJE01,sum(FCJE02) FCJE02,sum(FCJE03) FCJE03\\nfrom(\\nselect A.YPMC00,A.YPGG00,B.YPBM00,D.CKBMBH,\\nnvl((select SJKCSL   from vw_yf_pckchz where YFBMBH=A.YFBMBH and YPNM00=A.YPNM00),0) SJKCSL,\\n(select BMMC00 from BM_BMBM00 where BMBH00=D.CKBMBH) CKBMMC,\\n<#if TJDWBH=='0'>\\n    B.KCDW00 KCDW00,\\n<#elseif TJDWBH=='1'>\\n    B.MZFYDW KCDW00,\\n<#elseif TJDWBH=='2'>\\n    B.ZYFYDW KCDW00,\\n</#if>\\n( case when  B.MZDJ00<>'0' then '麻醉'  when B.SJDJ00<>'1' and B.SJDJ00<>'0'  then '二类精神药品' when  B.SJDJ00='1' then  '一类精神药品'  when B.DPDJ00<>'0' then '毒品' else '普通' end )  DM0000 ,\\n( select MC0000 from VW_YK_YDKSSJB where BH0000 = B.KSSJB0 ) KSS000,\\n<#if TJDWBH=='0'>\\n    decode(sign(A.FCSL00),-1,round(abs(FCSL00)*a.ZHL000/B.K2J000,3),0) FCSL01,\\n    decode(sign(A.FCSL00),1,round(FCSL00*a.ZHL000/B.K2J000,3),0) FCSL02,\\n    round(FCSL00*a.ZHL000/B.K2J000,3) FCSL03,\\n<#elseif TJDWBH=='1'>\\n    decode(sign(A.FCSL00),-1,round(abs(FCSL00)*a.ZHL000/B.M2J000,3),0) FCSL01,\\n    decode(sign(A.FCSL00),1,round(FCSL00*a.ZHL000/B.M2J000,3),0) FCSL02,\\n    round(FCSL00*a.ZHL000/B.M2J000,3) FCSL03,\\n   \\n<#elseif TJDWBH=='2'>\\n    decode(sign(A.FCSL00),-1,round(abs(FCSL00)*a.ZHL000/B.Z2J000,3),0) FCSL01,\\n    decode(sign(A.FCSL00),1,round(FCSL00*a.ZHL000/B.Z2J000,3),0) FCSL02,\\n    round(FCSL00*a.ZHL000/B.Z2J000,3) FCSL03,\\n</#if>\\na.FCDJ00 FCDJ01,\\ndecode(sign(A.FCSL00),-1,abs(FCJE00),0) FCJE01,\\ndecode(sign(A.FCSL00),1,FCJE00,0) FCJE02,\\na.FCJE00 FCJE03,\\n(select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH ) SCCJZW,\\ndecode(nvl(D.BYTJID,'-1'),'-1',(select BYTJID from YF_YPCKD0 X ,YF_YZYPSQ y,YF_YZYPSQ t where x.CKDH00=t.CKDH00 and y.YPQLPC=a.YPCKPC and t.YPQLPC=y.CXPCID   ),d.BYTJID) BYTJID,\\nsubstr('${startTime}', 1, 4) || '年'startYEAR ,\\n       substr('${startTime}', 5, 2) || '月'startMOON,\\n       substr('${startTime}', 7, 2) || '日' startDAY,\\n       substr('${startTime}', 9, 2) || '时'startHOUR,\\n       substr('${startTime}', 12, 2) || '分'startMIN,\\n       substr('${startTime}', 15, 2) || '秒'startSEC,\\n       substr('${endTime}', 1, 4) || '年'startNIAN ,\\n       substr('${endTime}', 5, 2) || '月'startYUE,\\n       substr('${endTime}', 7, 2) || '日' startRI,\\n       substr('${endTime}', 9, 2) || '时'startSHI,\\n       substr('${endTime}', 12, 2) || '分'startFEN,\\n       substr('${endTime}', 15, 2) || '秒'startMIAO\\nfrom YF_YPMXZ0 A, BM_YD0000 B,YF_YPCKD0 D\\nwhere a.YPNM00=B.YPNM00\\n  and A.YFBMBH=${YFBMBH}\\n  and A.JZRQ00 between '${startDate}' and '${endDate}'\\n  and A.JZRQ00||A.JZSJ00>='${startTime}' and A.JZRQ00||A.JZSJ00<='${endTime}'\\n  and A.DJH000=D.CKDH00 and A.JZRQ00=D.QRRQ00\\n  and B.LBBH00 like '${LBBH00}%'\\n  and B.YLBH00 like '${YLBH00}%'\\n  and B.JXBH00 like '${JXBH00}%'\\n\\n) where 1=1\\n<#if  ( BYTJID?default(\\\"\\\")?trim?length gt 0 && BYTJID !='0')>\\n    and BYTJID=${BYTJID}\\n</#if>\\ngroup by YPMC00,YPGG00,YPBM00,CKBMBH,SJKCSL,CKBMMC,KCDW00,DM0000,KSS000,SCCJZW,BYTJID,FCDJ01,\\nstartYEAR,startMOON,startDAY,startHOUR,startMIN,startSEC,startNIAN,startYUE,startRI,startSHI,startFEN,startMIAO\\norder by CKBMBH,YPMC00\",\"isProcedures\":false,\"isCommit\":false,\"remark\":\"\",\"LAY_TABLE_INDEX\":0}]","sqls":[{"isCommit":false,"isProcedures":false,"name":"tableMain","remark":"","sql":"select YPMC00,YPGG00,YPBM00,CKBMBH,SJKCSL,CKBMMC,KCDW00,DM0000,KSS000,SCCJZW,BYTJID,FCDJ01,\nstartYEAR,startMOON,startDAY,startHOUR,startMIN,startSEC,startNIAN,startYUE,startRI,startSHI,startFEN,startMIAO,\nsum(FCSL01) FCSL01,sum(FCSL02) FCSL02,sum(FCSL03) FCSL03,sum(FCJE01) FCJE01,sum(FCJE02) FCJE02,sum(FCJE03) FCJE03\nfrom(\nselect A.YPMC00,A.YPGG00,B.YPBM00,D.CKBMBH,\nnvl((select SJKCSL   from vw_yf_pckchz where YFBMBH=A.YFBMBH and YPNM00=A.YPNM00),0) SJKCSL,\n(select BMMC00 from BM_BMBM00 where BMBH00=D.CKBMBH) CKBMMC,\n<#if TJDWBH=='0'>\n    B.KCDW00 KCDW00,\n<#elseif TJDWBH=='1'>\n    B.MZFYDW KCDW00,\n<#elseif TJDWBH=='2'>\n    B.ZYFYDW KCDW00,\n</#if>\n( case when  B.MZDJ00<>'0' then '麻醉'  when B.SJDJ00<>'1' and B.SJDJ00<>'0'  then '二类精神药品' when  B.SJDJ00='1' then  '一类精神药品'  when B.DPDJ00<>'0' then '毒品' else '普通' end )  DM0000 ,\n( select MC0000 from VW_YK_YDKSSJB where BH0000 = B.KSSJB0 ) KSS000,\n<#if TJDWBH=='0'>\n    decode(sign(A.FCSL00),-1,round(abs(FCSL00)*a.ZHL000/B.K2J000,3),0) FCSL01,\n    decode(sign(A.FCSL00),1,round(FCSL00*a.ZHL000/B.K2J000,3),0) FCSL02,\n    round(FCSL00*a.ZHL000/B.K2J000,3) FCSL03,\n<#elseif TJDWBH=='1'>\n    decode(sign(A.FCSL00),-1,round(abs(FCSL00)*a.ZHL000/B.M2J000,3),0) FCSL01,\n    decode(sign(A.FCSL00),1,round(FCSL00*a.ZHL000/B.M2J000,3),0) FCSL02,\n    round(FCSL00*a.ZHL000/B.M2J000,3) FCSL03,\n   \n<#elseif TJDWBH=='2'>\n    decode(sign(A.FCSL00),-1,round(abs(FCSL00)*a.ZHL000/B.Z2J000,3),0) FCSL01,\n    decode(sign(A.FCSL00),1,round(FCSL00*a.ZHL000/B.Z2J000,3),0) FCSL02,\n    round(FCSL00*a.ZHL000/B.Z2J000,3) FCSL03,\n</#if>\na.FCDJ00 FCDJ01,\ndecode(sign(A.FCSL00),-1,abs(FCJE00),0) FCJE01,\ndecode(sign(A.FCSL00),1,FCJE00,0) FCJE02,\na.FCJE00 FCJE03,\n(select SCCJZW from BM_YPSCCJ where SCCJBH=B.SCCJBH ) SCCJZW,\ndecode(nvl(D.BYTJID,'-1'),'-1',(select BYTJID from YF_YPCKD0 X ,YF_YZYPSQ y,YF_YZYPSQ t where x.CKDH00=t.CKDH00 and y.YPQLPC=a.YPCKPC and t.YPQLPC=y.CXPCID   ),d.BYTJID) BYTJID,\nsubstr('${startTime}', 1, 4) || '年'startYEAR ,\n       substr('${startTime}', 5, 2) || '月'startMOON,\n       substr('${startTime}', 7, 2) || '日' startDAY,\n       substr('${startTime}', 9, 2) || '时'startHOUR,\n       substr('${startTime}', 12, 2) || '分'startMIN,\n       substr('${startTime}', 15, 2) || '秒'startSEC,\n       substr('${endTime}', 1, 4) || '年'startNIAN ,\n       substr('${endTime}', 5, 2) || '月'startYUE,\n       substr('${endTime}', 7, 2) || '日' startRI,\n       substr('${endTime}', 9, 2) || '时'startSHI,\n       substr('${endTime}', 12, 2) || '分'startFEN,\n       substr('${endTime}', 15, 2) || '秒'startMIAO\nfrom YF_YPMXZ0 A, BM_YD0000 B,YF_YPCKD0 D\nwhere a.YPNM00=B.YPNM00\n  and A.YFBMBH=${YFBMBH}\n  and A.JZRQ00 between '${startDate}' and '${endDate}'\n  and A.JZRQ00||A.JZSJ00>='${startTime}' and A.JZRQ00||A.JZSJ00<='${endTime}'\n  and A.DJH000=D.CKDH00 and A.JZRQ00=D.QRRQ00\n  and B.LBBH00 like '${LBBH00}%'\n  and B.YLBH00 like '${YLBH00}%'\n  and B.JXBH00 like '${JXBH00}%'\n\n) where 1=1\n<#if  ( BYTJID?default(\"\")?trim?length gt 0 && BYTJID !='0')>\n    and BYTJID=${BYTJID}\n</#if>\ngroup by YPMC00,YPGG00,YPBM00,CKBMBH,SJKCSL,CKBMMC,KCDW00,DM0000,KSS000,SCCJZW,BYTJID,FCDJ01,\nstartYEAR,startMOON,startDAY,startHOUR,startMIN,startSEC,startNIAN,startYUE,startRI,startSHI,startFEN,startMIAO\norder by CKBMBH,YPMC00"}],"system":"his","updateTime":1739773169000,"versions":1}]}