[{"branch":"0","branchmc":"standard","button":"[]","catalog":"KuCun","chart":"[]","code":"queryCLYPSMRKZSMCL","column":"[{\"sys_hidden\":\"\",\"filter_name\":\"A.ZSM000\",\"hidden\":false,\"isTotal\":\"true\",\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":0,\"totalType\":\"追溯码数量：${COUNT0}\",\"className\":\"\",\"title\":\"追溯码\",\"align\":\"left\",\"ora_name\":\"ZSM000\",\"headerAlign\":\"center\",\"_VCUID\":\"row_981\",\"render\":\"\",\"key\":\"ZSM000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":0,\"round\":\"\",\"trunc\":\"\",\"field\":\"ZSM000\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"A.JLZSL0||B.JLDW00\",\"hidden\":false,\"isTotal\":\"\",\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":1,\"totalType\":\"\",\"className\":\"\",\"title\":\"剂量总数量\",\"align\":\"left\",\"ora_name\":\"JLSLDW\",\"headerAlign\":\"center\",\"_VCUID\":\"row_982\",\"render\":\"\",\"key\":\"JLSLDW\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":1,\"round\":\"\",\"trunc\":\"\",\"field\":\"JLSLDW\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SYSL00\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":2,\"className\":\"\",\"title\":\"SYSL00\",\"align\":\"center\",\"ora_name\":\"SYSL00\",\"headerAlign\":\"center\",\"_VCUID\":\"row_983\",\"render\":\"\",\"key\":\"SYSL00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":2,\"round\":\"\",\"trunc\":\"\",\"field\":\"SYSL00\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"decode(substrb(A.SYJLSL/B.ZSMZHL,1,1),'.',0||to_char(A.SYJLSL/B.ZSMZHL),to_char(A.SYJLSL/B.ZSMZHL))||B.ZSMDW0\",\"hidden\":false,\"isTotal\":\"true\",\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":3,\"totalType\":\"${SYSL00,4}\",\"className\":\"\",\"title\":\"剩余最小追溯码单位数量\",\"align\":\"left\",\"ora_name\":\"SYSLDW\",\"headerAlign\":\"center\",\"_VCUID\":\"row_984\",\"render\":\"\",\"key\":\"SYSLDW\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":3,\"round\":\"\",\"trunc\":\"\",\"field\":\"SYSLDW\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"left\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"to_char(to_date(A.CZRQ00||A.CZSJ00,'YYYYMMDD hh24:mi:ss'),'YYYY-MM-DD hh24:mi:ss')\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":4,\"className\":\"\",\"title\":\"扫码时间\",\"align\":\"left\",\"ora_name\":\"to_char(to_date(A.CZRQ00||A.CZSJ00,'YYYYMMDD hh24:mi:ss'),'YYYY-MM-DD hh24:mi:ss')\",\"headerAlign\":\"center\",\"_VCUID\":\"row_985\",\"render\":\"\",\"key\":\"CZRQSJ\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":4,\"round\":\"\",\"trunc\":\"\",\"field\":\"CZRQSJ\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"filter_name\":\"A.CLLSH0\",\"hidden\":true,\"LAY_TABLE_INDEX\":5,\"sortable\":false,\"isSummary\":\"false\",\"title\":\"拆零流水号\",\"ellipsis\":true,\"ora_name\":\"CLLSH0\",\"disabledCheckboxColumn\":false,\"sequence\":5,\"field\":\"CLLSH0\",\"sortType\":\"asc\",\"_VCUID\":\"row_1193\",\"render\":\"\",\"key\":\"CLLSH0\"},{\"filter_name\":\"A.SYJLSL\",\"hidden\":true,\"LAY_TABLE_INDEX\":6,\"sortable\":false,\"isSummary\":\"false\",\"title\":\"实际剂量数量\",\"ellipsis\":true,\"ora_name\":\"SYJLSL\",\"disabledCheckboxColumn\":false,\"sequence\":6,\"field\":\"SYJLSL\",\"sortType\":\"asc\",\"_VCUID\":\"row_1283\",\"render\":\"\",\"key\":\"SYJLSL\"},{\"sys_hidden\":\"\",\"filter_name\":\"(select ZWXM00 from BM_YGBM00 where YGBH00 = A.CZY000)\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":7,\"className\":\"\",\"title\":\"操作员\",\"align\":\"center\",\"ora_name\":\"CZYXM0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"CZYXM0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":7,\"round\":\"\",\"trunc\":\"\",\"field\":\"CZYXM0\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"}]","condition":"[]","createTime":1743586553000,"entityVersion":0,"id":"queryCLYPSMRKZSMCL","isLaypage":"0","module":"yf","name":"queryCLYPSMRKZSMCL","pageSql":"select \nA.CLLSH0,\nA.ZSM000,\nA.JLZSL0||B.JLDW00 JLSLDW,\ndecode(substrb(A.SYJLSL/B.ZSMZHL,1,1),'.',0||to_char(round(A.SYJLSL/B.ZSMZHL,4)),to_char(round(A.SYJLSL/B.ZSMZHL,4)))||B.ZSMDW0 SYSLDW ,\nB.JLDW00 ,\n'1' COUNT0,\nto_char(to_date(A.CZRQ00||A.CZSJ00,'YYYYMMDD hh24:mi:ss'),'YYYY-MM-DD hh24:mi:ss') CZRQSJ,\nround(A.SYJLSL/B.ZSMZHL,4) SYSL00,\nB.ZSMDW0,\nA.JLZSL0,\n--A.JLSLDW,\nA.SYJLSL,\n(select ZWXM00 from BM_YGBM00 where YGBH00 = A.CZY000) CZYXM0\nfrom YF_RKZSM0 A,BM_YD0000 B \nwhere A.YPNM00 = B.YPNM00 AND A.YFBMBH = '${DLBMBH}'\nand A.YPNM00 = '${YPNM00}' \n<#if SFXZYP?default(\"\")?trim?length gt 0 && SFXZYP == '0'>\n     and A.CZRQ00 between '${KSRQ00}' and '${JSRQ00}'\n     and A.CZRQ00>= '${KSRQ00}' and A.CZRQ00 <= '${JSRQ00}'\n</#if>\n<#if XSLKC0?default(\"\")?trim?length gt 0 && XSLKC0 == '0'>\n    and A.SYJLSL>0\n</#if>\norder by A.CZRQ00||A.CZSJ00 desc ,A.ZSM000\n\n","procedureCommit":0,"procedureParameter":"[]","remark":"拆零药品扫码入库-追溯码拆零","system":"his","updateTime":1761633243000,"version":0},{"branch":"227049","branchmc":"南平市第一医院","button":"[]","catalog":"KuCun","chart":"[]","code":"queryCLYPSMRKZSMCL","column":"[{\"sys_hidden\":\"\",\"filter_name\":\"A.ZSM000\",\"hidden\":false,\"isTotal\":\"true\",\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":0,\"totalType\":\"追溯码数量：${COUNT0}\",\"className\":\"\",\"title\":\"追溯码\",\"align\":\"left\",\"ora_name\":\"ZSM000\",\"headerAlign\":\"center\",\"_VCUID\":\"row_981\",\"render\":\"\",\"key\":\"ZSM000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":0,\"round\":\"\",\"trunc\":\"\",\"field\":\"ZSM000\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"A.JLZSL0||B.JLDW00\",\"hidden\":false,\"isTotal\":\"\",\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":1,\"totalType\":\"\",\"className\":\"\",\"title\":\"剂量总数量\",\"align\":\"left\",\"ora_name\":\"JLSLDW\",\"headerAlign\":\"center\",\"_VCUID\":\"row_982\",\"render\":\"\",\"key\":\"JLSLDW\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":1,\"round\":\"\",\"trunc\":\"\",\"field\":\"JLSLDW\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SYSL00\",\"hidden\":true,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":2,\"className\":\"\",\"title\":\"SYSL00\",\"align\":\"center\",\"ora_name\":\"SYSL00\",\"headerAlign\":\"center\",\"_VCUID\":\"row_983\",\"render\":\"\",\"key\":\"SYSL00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":2,\"round\":\"\",\"trunc\":\"\",\"field\":\"SYSL00\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"decode(substrb(A.SYJLSL/B.ZSMZHL,1,1),'.',0||to_char(A.SYJLSL/B.ZSMZHL),to_char(A.SYJLSL/B.ZSMZHL))||B.ZSMDW0\",\"hidden\":false,\"isTotal\":\"true\",\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":3,\"totalType\":\"${SYSL00,4}\",\"className\":\"\",\"title\":\"剩余最小追溯码单位数量\",\"align\":\"left\",\"ora_name\":\"SYSLDW\",\"headerAlign\":\"center\",\"_VCUID\":\"row_984\",\"render\":\"\",\"key\":\"SYSLDW\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":3,\"round\":\"\",\"trunc\":\"\",\"field\":\"SYSLDW\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"left\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"to_char(to_date(A.CZRQ00||A.CZSJ00,'YYYYMMDD hh24:mi:ss'),'YYYY-MM-DD hh24:mi:ss')\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":4,\"className\":\"\",\"title\":\"扫码时间\",\"align\":\"left\",\"ora_name\":\"to_char(to_date(A.CZRQ00||A.CZSJ00,'YYYYMMDD hh24:mi:ss'),'YYYY-MM-DD hh24:mi:ss')\",\"headerAlign\":\"center\",\"_VCUID\":\"row_985\",\"render\":\"\",\"key\":\"CZRQSJ\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":4,\"round\":\"\",\"trunc\":\"\",\"field\":\"CZRQSJ\",\"sortType\":\"asc\",\"width\":\"150\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"filter_name\":\"A.CLLSH0\",\"hidden\":true,\"LAY_TABLE_INDEX\":5,\"sortable\":false,\"isSummary\":\"false\",\"title\":\"拆零流水号\",\"ellipsis\":true,\"ora_name\":\"CLLSH0\",\"disabledCheckboxColumn\":false,\"sequence\":5,\"field\":\"CLLSH0\",\"sortType\":\"asc\",\"_VCUID\":\"row_1193\",\"render\":\"\",\"key\":\"CLLSH0\"},{\"filter_name\":\"A.SYJLSL\",\"hidden\":true,\"LAY_TABLE_INDEX\":6,\"sortable\":false,\"isSummary\":\"false\",\"title\":\"实际剂量数量\",\"ellipsis\":true,\"ora_name\":\"SYJLSL\",\"disabledCheckboxColumn\":false,\"sequence\":6,\"field\":\"SYJLSL\",\"sortType\":\"asc\",\"_VCUID\":\"row_1283\",\"render\":\"\",\"key\":\"SYJLSL\"},{\"sys_hidden\":\"\",\"filter_name\":\"(select ZWXM00 from BM_YGBM00 where YGBH00 = A.CZY000)\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":7,\"className\":\"\",\"title\":\"操作员\",\"align\":\"center\",\"ora_name\":\"CZYXM0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"CZYXM0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":7,\"round\":\"\",\"trunc\":\"\",\"field\":\"CZYXM0\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"}]","condition":"[]","createTime":1757066158000,"entityVersion":0,"id":"queryCLYPSMRKZSMCL","isLaypage":"0","module":"yf","name":"queryCLYPSMRKZSMCL","pageSql":"select \nA.CLLSH0,\nA.ZSM000,\nA.JLZSL0||B.JLDW00 JLSLDW,\ndecode(substrb(A.SYJLSL/B.ZSMZHL,1,1),'.',0||to_char(round(A.SYJLSL/B.ZSMZHL,4)),to_char(round(A.SYJLSL/B.ZSMZHL,4)))||B.ZSMDW0 SYSLDW ,\nB.JLDW00 ,\n'1' COUNT0,\nto_char(to_date(A.CZRQ00||A.CZSJ00,'YYYYMMDD hh24:mi:ss'),'YYYY-MM-DD hh24:mi:ss') CZRQSJ,\nround(A.SYJLSL/B.ZSMZHL,4) SYSL00,\nB.ZSMDW0,\nA.JLZSL0,\n--A.JLSLDW,\nA.SYJLSL,\n(select ZWXM00 from BM_YGBM00 where YGBH00 = A.CZY000) CZYXM0\nfrom YF_RKZSM0 A,BM_YD0000 B \nwhere A.YPNM00 = B.YPNM00 AND A.YFBMBH = '${DLBMBH}'\nand A.YPNM00 = '${YPNM00}' \n<#if SFXZYP?default(\"\")?trim?length gt 0>\n     and A.CZRQ00 between '${KSRQ00}' and '${JSRQ00}'\n     and A.CZRQ00||A.CZSJ00 >= '${KSRQ00}${KSSJ00}' and A.CZRQ00||A.CZSJ00 <= '${JSRQ00}${JSSJ00}'\n</#if>\n<#if XSLKC0?default(\"\")?trim?length gt 0 && XSLKC0 == '0'>\n    and A.SYJLSL>0\n</#if>\norder by A.CZRQ00||A.CZSJ00 desc ,A.ZSM000\n\n","procedureCommit":0,"procedureParameter":"[]","remark":"拆零药品扫码入库-追溯码拆零","system":"his","updateTime":1758195495000,"version":0}]