[{"branch":"0","branchmc":"standard","button":"[]","catalog":"KuCunGuanLi","chart":"[]","code":"getBatchInventoryDrugs","column":"[{\"filter_name\":\"decode(a.ZTBZ00,'0','有效','1','无效')\",\"hidden\":false,\"LAY_TABLE_INDEX\":0,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"有效\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":0,\"ora_name\":\"ZTBZ00\",\"headerAlign\":\"center\",\"field\":\"ZTBZ00\",\"sortType\":\"asc\",\"width\":\"50\",\"fixed\":\"\",\"render\":\"\",\"key\":\"ZTBZ00\"},{\"filter_name\":\"a.RKDH00\",\"hidden\":false,\"isTotal\":\"true\",\"LAY_TABLE_INDEX\":1,\"totalType\":\"合计记录数：\",\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"入库单号\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":1,\"ora_name\":\"RKDH00\",\"headerAlign\":\"center\",\"field\":\"RKDH00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"RKDH00\"},{\"filter_name\":\"a.YGJDJ0\",\"hidden\":false,\"isTotal\":\"true\",\"LAY_TABLE_INDEX\":2,\"totalType\":\"${COUNT0}\",\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"原购进价\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":2,\"ora_name\":\"YGJDJ0\",\"headerAlign\":\"center\",\"field\":\"YGJDJ0\",\"sortType\":\"asc\",\"width\":\"80\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YGJDJ0\",\"sys_hidden\":\"YK_FSGJGDLCGLSGRWCG=Y\"},{\"title\":\"原带量采购价\",\"key\":\"YGJDJ0\",\"ora_name\":\"YGJDJ0\",\"filter_name\":\"a.YGJDJ0\",\"fatherKey\":\"\",\"width\":\"100\",\"minWidth\":\"\",\"align\":\"center\",\"headerAlign\":\"center\",\"footerAlign\":\"center\",\"className\":\"\",\"fixed\":\"\",\"sortable\":true,\"sortType\":\"asc\",\"hidden\":false,\"sys_hidden\":\"YK_FSGJGDLCGLSGRWCG=N\",\"ellipsis\":true,\"uiType\":\"\",\"isSummary\":\"false\",\"summary\":\"\",\"round\":\"\",\"trunc\":\"\",\"render\":\"\",\"LAY_TABLE_INDEX\":19,\"isTotal\":\"true\",\"totalType\":\"${COUNT0}\",\"sequence\":3,\"field\":\"YGJDJ0\"},{\"sys_hidden\":\"YK_FSGJGDLCGLSGRWCG=Y\",\"filter_name\":\"a.GJDJ00\",\"hidden\":false,\"LAY_TABLE_INDEX\":3,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"购进价\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":4,\"ora_name\":\"GJDJ00\",\"headerAlign\":\"center\",\"field\":\"GJDJ00\",\"sortType\":\"asc\",\"width\":\"80\",\"fixed\":\"\",\"render\":\"\",\"key\":\"GJDJ00\"},{\"sys_hidden\":\"YK_FSGJGDLCGLSGRWCG=N\",\"filter_name\":\"a.GJDJ00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":4,\"className\":\"\",\"title\":\"带量采购价\",\"align\":\"center\",\"ora_name\":\"GJDJ00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"GJDJ00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":true,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":5,\"round\":\"\",\"trunc\":\"\",\"field\":\"GJDJ00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"YK_FSGJGDLCGLSGRWCG=Y\",\"filter_name\":\"a.LSJ000\",\"hidden\":false,\"LAY_TABLE_INDEX\":5,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"零售价\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":6,\"ora_name\":\"LSJ000\",\"headerAlign\":\"center\",\"field\":\"LSJ000\",\"sortType\":\"asc\",\"width\":\"80\",\"fixed\":\"\",\"render\":\"\",\"key\":\"LSJ000\"},{\"sys_hidden\":\"YK_FSGJGDLCGLSGRWCG=N\",\"filter_name\":\"a.LSJ000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":6,\"className\":\"\",\"title\":\"入围采购价\",\"align\":\"center\",\"ora_name\":\"LSJ000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"LSJ000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":true,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":7,\"round\":\"\",\"trunc\":\"\",\"field\":\"LSJ000\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"filter_name\":\"round((a.RKSL00 * b.k2j000 + a.JLRKSL * a.JLZHL0) / b.ZJJL2J, 3) || b.ZJJLDW\",\"hidden\":false,\"LAY_TABLE_INDEX\":7,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"入库数量\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":8,\"ora_name\":\"RKSLXX\",\"headerAlign\":\"center\",\"field\":\"RKSLXX\",\"sortType\":\"asc\",\"width\":\"80\",\"fixed\":\"\",\"render\":\"\",\"key\":\"RKSLXX\"},{\"filter_name\":\"round(a.PCKCSL / b.ZJJL2J, 3) || b.ZJJLDW\",\"hidden\":false,\"LAY_TABLE_INDEX\":8,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"库存数量\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":9,\"ora_name\":\"PCKCXX\",\"headerAlign\":\"center\",\"field\":\"PCKCXX\",\"sortType\":\"asc\",\"width\":\"80\",\"fixed\":\"\",\"render\":\"\",\"key\":\"PCKCXX\"},{\"filter_name\":\"to_char(to_date(a.JHRQ00,'yyyy-mm-dd'),'yyyy-mm-dd')\",\"hidden\":false,\"LAY_TABLE_INDEX\":9,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"进货日期\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":10,\"ora_name\":\"JHRQ00\",\"headerAlign\":\"center\",\"field\":\"JHRQ00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"JHRQ00\"},{\"filter_name\":\"a.SCPH00\",\"hidden\":false,\"LAY_TABLE_INDEX\":10,\"minWidth\":\"150\",\"className\":\"\",\"sortable\":true,\"title\":\"生产批号\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":11,\"ora_name\":\"SCPH00\",\"headerAlign\":\"center\",\"field\":\"SCPH00\",\"sortType\":\"asc\",\"width\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SCPH00\"},{\"filter_name\":\"to_char(to_date(a.YPSXRQ,'yyyy-mm-dd'),'yyyy-mm-dd')\",\"hidden\":false,\"LAY_TABLE_INDEX\":11,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"有效期\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":12,\"ora_name\":\"YPSXRQ\",\"headerAlign\":\"center\",\"field\":\"YPSXRQ\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YPSXRQ\"},{\"filter_name\":\"a.SCCJZW\",\"hidden\":false,\"LAY_TABLE_INDEX\":12,\"minWidth\":\"130\",\"className\":\"\",\"sortable\":true,\"title\":\"生产厂家\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":13,\"ora_name\":\"SCCJZW\",\"headerAlign\":\"center\",\"field\":\"SCCJZW\",\"sortType\":\"asc\",\"width\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SCCJZW\"},{\"filter_name\":\"a.GHDWMC\",\"hidden\":false,\"LAY_TABLE_INDEX\":13,\"minWidth\":\"140\",\"className\":\"\",\"sortable\":true,\"title\":\"供货单位\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":14,\"ora_name\":\"GHDWMC\",\"headerAlign\":\"center\",\"field\":\"GHDWMC\",\"sortType\":\"asc\",\"width\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"GHDWMC\"},{\"filter_name\":\"a.CFWZMC\",\"hidden\":false,\"LAY_TABLE_INDEX\":14,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"存放位置\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":15,\"ora_name\":\"CFWZMC\",\"headerAlign\":\"center\",\"field\":\"CFWZMC\",\"sortType\":\"asc\",\"width\":\"80\",\"fixed\":\"\",\"render\":\"\",\"key\":\"CFWZMC\"},{\"filter_name\":\"a.BZ0000\",\"hidden\":false,\"LAY_TABLE_INDEX\":15,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"备注\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":16,\"ora_name\":\"BZ0000\",\"headerAlign\":\"center\",\"field\":\"BZ0000\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"BZ0000\"},{\"filter_name\":\"decode(sign(nvl(a.ZTCZY0, 0)), -1, '系统', 1, SELECT ZWXM00\\nFROM BM_YGBM00\\nWHERE YGBH00 = a.ZTCZY0, '')\",\"hidden\":false,\"LAY_TABLE_INDEX\":16,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"干预人员\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":17,\"ora_name\":\"ZTCZXM\",\"headerAlign\":\"center\",\"field\":\"ZTCZXM\",\"sortType\":\"asc\",\"width\":\"60\",\"fixed\":\"\",\"render\":\"\",\"key\":\"ZTCZXM\"},{\"filter_name\":\"to_char(to_date(a.ZTRQSJ,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')\",\"hidden\":false,\"LAY_TABLE_INDEX\":17,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"干预操作时间\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":18,\"ora_name\":\"ZTRQSJ\",\"headerAlign\":\"center\",\"field\":\"ZTRQSJ\",\"sortType\":\"asc\",\"width\":\"160\",\"fixed\":\"\",\"render\":\"\",\"key\":\"ZTRQSJ\"},{\"filter_name\":\"a.YPRKPC\",\"hidden\":false,\"LAY_TABLE_INDEX\":18,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"批次\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":19,\"ora_name\":\"YPRKPC\",\"headerAlign\":\"center\",\"field\":\"YPRKPC\",\"sortType\":\"asc\",\"width\":\"80\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YPRKPC\"}]","condition":"[]","createTime":1597393363000,"entityVersion":0,"id":"getBatchInventoryDrugs","isLaypage":"0","module":"yk","name":"getBatchInventoryDrugs","pageSql":"select '1' COUNT0, decode(a.ZTBZ00,'0','有效','1','无效') ZTBZ00,a.RKDH00,a.YGJDJ0,a.GJDJ00,a.LSJ000,\n<#if KCDW00 == '1'>\n       round((a.RKSL00*b.k2j000+a.JLRKSL*a.JLZHL0)/b.ZJJL2J,3)||b.ZJJLDW RKSLXX,\n       round(a.PCKCSL/b.ZJJL2J,3)||b.ZJJLDW PCKCXX,\n<#elseif KCDW00 == '2'>\n       (a.RKSL00*b.k2j000+a.JLRKSL*a.JLZHL0)||b.JLDW00 RKSLXX,\n        a.PCKCSL||b.JLDW00 PCKCXX,\n<#elseif KCDW00 == '3'>\n        a.RKSL01 RKSLXX,a.PCKC01 PCKCXX,\n<#else>\n       round((a.RKSL00*b.k2j000+a.JLRKSL*a.JLZHL0)/b.K2J000,3)||b.KCDW00 RKSLXX,\n       round(a.PCKCSL/b.K2J000,3)||b.KCDW00 PCKCXX,\n</#if>\nto_char(to_date(a.JHRQ00,'yyyy-mm-dd'),'yyyy-mm-dd') JHRQ00,\na.SCPH00,\nto_char(to_date(a.YPSXRQ,'yyyy-mm-dd'),'yyyy-mm-dd') YPSXRQ,a.SCCJZW,a.GHDWMC,a.CFWZMC,a.BZ0000,\ndecode(sign(nvl(a.ZTCZY0,0)),-1,'系统',1,(select ZWXM00 from BM_YGBM00 where YGBH00=a.ZTCZY0),'') ZTCZXM,\nto_char(to_date(a.ZTRQSJ,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss') ZTRQSJ,a.YPRKPC\nfrom VW_YK_YPPCKC a,BM_YD0000 b \nwhere a.YPNM00=b.YPNM00 and a.YPNM00='${YPNM00}' and a.YKBMBH='${YKBMBH}' \n<#if XSLKC1 == '0'>\n       and  a.PCKC00>0\n</#if>\norder by a.QRRQ00 desc","procedureCommit":0,"procedureParameter":"[]","remark":"库存查询-药品批次库存","system":"his","updateTime":1705996347000,"version":1},{"branch":"227049","branchmc":"南平市第一医院","button":"[]","catalog":"KuCunGuanLi","chart":"[]","code":"getBatchInventoryDrugs","column":"[{\"filter_name\":\"decode(a.ZTBZ00,'0','有效','1','无效')\",\"hidden\":false,\"LAY_TABLE_INDEX\":0,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"有效\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":0,\"ora_name\":\"ZTBZ00\",\"headerAlign\":\"center\",\"field\":\"ZTBZ00\",\"sortType\":\"asc\",\"width\":\"50\",\"fixed\":\"\",\"render\":\"\",\"key\":\"ZTBZ00\"},{\"filter_name\":\"a.RKDH00\",\"hidden\":false,\"isTotal\":\"true\",\"LAY_TABLE_INDEX\":1,\"totalType\":\"合计记录数：\",\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"入库单号\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":1,\"ora_name\":\"RKDH00\",\"headerAlign\":\"center\",\"field\":\"RKDH00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"RKDH00\"},{\"sys_hidden\":\"YK_FSGJGDLCGLSGRWCG=Y\",\"filter_name\":\"a.YGJDJ0\",\"hidden\":false,\"isTotal\":\"true\",\"LAY_TABLE_INDEX\":2,\"totalType\":\"${COUNT0}\",\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"原购进价\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":2,\"ora_name\":\"YGJDJ0\",\"headerAlign\":\"center\",\"field\":\"YGJDJ0\",\"sortType\":\"asc\",\"width\":\"80\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YGJDJ0\"},{\"sys_hidden\":\"YK_FSGJGDLCGLSGRWCG=N\",\"filter_name\":\"a.YGJDJ0\",\"hidden\":false,\"isTotal\":\"true\",\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":3,\"totalType\":\"${COUNT0}\",\"className\":\"\",\"title\":\"原带量采购价\",\"align\":\"center\",\"ora_name\":\"YGJDJ0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"YGJDJ0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":true,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":3,\"round\":\"\",\"trunc\":\"\",\"field\":\"YGJDJ0\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"YK_FSGJGDLCGLSGRWCG=Y\",\"filter_name\":\"a.GJDJ00\",\"hidden\":false,\"LAY_TABLE_INDEX\":4,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"购进价\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":4,\"ora_name\":\"GJDJ00\",\"headerAlign\":\"center\",\"field\":\"GJDJ00\",\"sortType\":\"asc\",\"width\":\"80\",\"fixed\":\"\",\"render\":\"\",\"key\":\"GJDJ00\"},{\"sys_hidden\":\"YK_FSGJGDLCGLSGRWCG=N\",\"filter_name\":\"a.GJDJ00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":5,\"className\":\"\",\"title\":\"带量采购价\",\"align\":\"center\",\"ora_name\":\"GJDJ00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"GJDJ00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":true,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":5,\"round\":\"\",\"trunc\":\"\",\"field\":\"GJDJ00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"YK_FSGJGDLCGLSGRWCG=Y\",\"filter_name\":\"a.LSJ000\",\"hidden\":false,\"LAY_TABLE_INDEX\":6,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"零售价\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":6,\"ora_name\":\"LSJ000\",\"headerAlign\":\"center\",\"field\":\"LSJ000\",\"sortType\":\"asc\",\"width\":\"80\",\"fixed\":\"\",\"render\":\"\",\"key\":\"LSJ000\"},{\"sys_hidden\":\"YK_FSGJGDLCGLSGRWCG=N\",\"filter_name\":\"a.LSJ000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":7,\"className\":\"\",\"title\":\"入围采购价\",\"align\":\"center\",\"ora_name\":\"LSJ000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"LSJ000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":true,\"isSummary\":\"false\",\"ellipsis\":true,\"sequence\":7,\"round\":\"\",\"trunc\":\"\",\"field\":\"LSJ000\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"filter_name\":\"round((a.RKSL00 * b.k2j000 + a.JLRKSL * a.JLZHL0) / b.ZJJL2J, 3) || b.ZJJLDW\",\"hidden\":false,\"LAY_TABLE_INDEX\":8,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"入库数量\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":8,\"ora_name\":\"RKSLXX\",\"headerAlign\":\"center\",\"field\":\"RKSLXX\",\"sortType\":\"asc\",\"width\":\"80\",\"fixed\":\"\",\"render\":\"\",\"key\":\"RKSLXX\"},{\"filter_name\":\"round(a.PCKCSL / b.ZJJL2J, 3) || b.ZJJLDW\",\"hidden\":false,\"LAY_TABLE_INDEX\":9,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"库存数量\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":9,\"ora_name\":\"PCKCXX\",\"headerAlign\":\"center\",\"field\":\"PCKCXX\",\"sortType\":\"asc\",\"width\":\"80\",\"fixed\":\"\",\"render\":\"\",\"key\":\"PCKCXX\"},{\"filter_name\":\"to_char(to_date(a.JHRQ00,'yyyy-mm-dd'),'yyyy-mm-dd')\",\"hidden\":false,\"LAY_TABLE_INDEX\":10,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"进货日期\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":10,\"ora_name\":\"JHRQ00\",\"headerAlign\":\"center\",\"field\":\"JHRQ00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"JHRQ00\"},{\"filter_name\":\"a.SCPH00\",\"hidden\":false,\"LAY_TABLE_INDEX\":11,\"minWidth\":\"150\",\"className\":\"\",\"sortable\":true,\"title\":\"生产批号\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":11,\"ora_name\":\"SCPH00\",\"headerAlign\":\"center\",\"field\":\"SCPH00\",\"sortType\":\"asc\",\"width\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SCPH00\"},{\"filter_name\":\"to_char(to_date(a.YPSXRQ,'yyyy-mm-dd'),'yyyy-mm-dd')\",\"hidden\":false,\"LAY_TABLE_INDEX\":12,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"有效期\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":12,\"ora_name\":\"YPSXRQ\",\"headerAlign\":\"center\",\"field\":\"YPSXRQ\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YPSXRQ\"},{\"filter_name\":\"a.SCCJZW\",\"hidden\":false,\"LAY_TABLE_INDEX\":13,\"minWidth\":\"130\",\"className\":\"\",\"sortable\":true,\"title\":\"生产厂家\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":13,\"ora_name\":\"SCCJZW\",\"headerAlign\":\"center\",\"field\":\"SCCJZW\",\"sortType\":\"asc\",\"width\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"SCCJZW\"},{\"filter_name\":\"a.GHDWMC\",\"hidden\":false,\"LAY_TABLE_INDEX\":14,\"minWidth\":\"140\",\"className\":\"\",\"sortable\":true,\"title\":\"供货单位\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":14,\"ora_name\":\"GHDWMC\",\"headerAlign\":\"center\",\"field\":\"GHDWMC\",\"sortType\":\"asc\",\"width\":\"\",\"fixed\":\"\",\"render\":\"\",\"key\":\"GHDWMC\"},{\"filter_name\":\"a.CFWZMC\",\"hidden\":false,\"LAY_TABLE_INDEX\":15,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"存放位置\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":15,\"ora_name\":\"CFWZMC\",\"headerAlign\":\"center\",\"field\":\"CFWZMC\",\"sortType\":\"asc\",\"width\":\"80\",\"fixed\":\"\",\"render\":\"\",\"key\":\"CFWZMC\"},{\"filter_name\":\"a.BZ0000\",\"hidden\":false,\"LAY_TABLE_INDEX\":16,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"备注\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":16,\"ora_name\":\"BZ0000\",\"headerAlign\":\"center\",\"field\":\"BZ0000\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"render\":\"\",\"key\":\"BZ0000\"},{\"filter_name\":\"decode(sign(nvl(a.ZTCZY0, 0)), -1, '系统', 1, SELECT ZWXM00\\nFROM BM_YGBM00\\nWHERE YGBH00 = a.ZTCZY0, '')\",\"hidden\":false,\"LAY_TABLE_INDEX\":17,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"干预人员\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":17,\"ora_name\":\"ZTCZXM\",\"headerAlign\":\"center\",\"field\":\"ZTCZXM\",\"sortType\":\"asc\",\"width\":\"60\",\"fixed\":\"\",\"render\":\"\",\"key\":\"ZTCZXM\"},{\"filter_name\":\"to_char(to_date(a.ZTRQSJ,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss')\",\"hidden\":false,\"LAY_TABLE_INDEX\":18,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"干预操作时间\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":18,\"ora_name\":\"ZTRQSJ\",\"headerAlign\":\"center\",\"field\":\"ZTRQSJ\",\"sortType\":\"asc\",\"width\":\"160\",\"fixed\":\"\",\"render\":\"\",\"key\":\"ZTRQSJ\"},{\"filter_name\":\"a.YPRKPC\",\"hidden\":false,\"LAY_TABLE_INDEX\":19,\"minWidth\":\"\",\"className\":\"\",\"sortable\":true,\"title\":\"批次\",\"align\":\"left\",\"ellipsis\":true,\"sequence\":19,\"ora_name\":\"YPRKPC\",\"headerAlign\":\"center\",\"field\":\"YPRKPC\",\"sortType\":\"asc\",\"width\":\"80\",\"fixed\":\"\",\"render\":\"\",\"key\":\"YPRKPC\"}]","condition":"[]","createTime":1758773028000,"entityVersion":0,"id":"getBatchInventoryDrugs","isLaypage":"0","module":"yk","name":"getBatchInventoryDrugs","pageSql":"select '1' COUNT0, decode(a.ZTBZ00,'0','有效','1','无效') ZTBZ00,a.RKDH00,a.YGJDJ0,a.GJDJ00,a.LSJ000,\n<#if KCDW00 == '1'>\n       round((a.RKSL00*b.k2j000+a.JLRKSL*a.JLZHL0)/b.ZJJL2J,3)||b.ZJJLDW RKSLXX,\n       round(a.PCKCSL/b.ZJJL2J,3)||b.ZJJLDW PCKCXX,\n<#elseif KCDW00 == '2'>\n       (a.RKSL00*b.k2j000+a.JLRKSL*a.JLZHL0)||b.JLDW00 RKSLXX,\n        a.PCKCSL||b.JLDW00 PCKCXX,\n<#elseif KCDW00 == '3'>\n        a.RKSL01 RKSLXX,a.PCKC01 PCKCXX,\n<#else>\n       round((a.RKSL00*b.k2j000+a.JLRKSL*a.JLZHL0)/b.K2J000,3)||b.KCDW00 RKSLXX,\n       round(a.PCKCSL/b.K2J000,3)||b.KCDW00 PCKCXX,\n</#if>\nto_char(to_date(a.JHRQ00,'yyyy-mm-dd'),'yyyy-mm-dd') JHRQ00,\na.SCPH00,\na.YPSXRQ,a.SCCJZW,a.GHDWMC,a.CFWZMC,a.BZ0000,\ndecode(sign(nvl(a.ZTCZY0,0)),-1,'系统',1,(select ZWXM00 from BM_YGBM00 where YGBH00=a.ZTCZY0),'') ZTCZXM,\nto_char(to_date(a.ZTRQSJ,'yyyy-mm-dd hh24:mi:ss'),'yyyy-mm-dd hh24:mi:ss') ZTRQSJ,a.YPRKPC\nfrom VW_YK_YPPCKC a,BM_YD0000 b \nwhere a.YPNM00=b.YPNM00 and a.YPNM00='${YPNM00}' and a.YKBMBH='${YKBMBH}' \n<#if XSLKC1 == '0'>\n       and  a.PCKC00>0\n</#if>\norder by a.QRRQ00 desc","procedureCommit":0,"procedureParameter":"[]","remark":"库存查询-药品批次库存","system":"his","updateTime":1758773028000,"version":1}]