[{"branch":"0","branchmc":"standard","button":"[]","catalog":"ChaXun","chart":"[]","code":"queryToxicPrescriptionDetail","column":"[{\"filter_name\":\"CFID00\",\"hidden\":true,\"LAY_TABLE_INDEX\":0,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":0,\"ora_name\":\"CFID00\",\"field\":\"CFID00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_930\",\"render\":\"\",\"key\":\"CFID00\"},{\"filter_name\":\"CFLSH0\",\"hidden\":true,\"LAY_TABLE_INDEX\":1,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":1,\"ora_name\":\"CFLSH0\",\"field\":\"CFLSH0\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_931\",\"render\":\"\",\"key\":\"CFLSH0\"},{\"filter_name\":\"YPMC00\",\"hidden\":false,\"LAY_TABLE_INDEX\":2,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"药品名称\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":2,\"ora_name\":\"YPMC00\",\"field\":\"YPMC00\",\"sortType\":\"asc\",\"width\":\"180\",\"fixed\":\"\",\"_VCUID\":\"row_932\",\"render\":\"\",\"key\":\"YPMC00\"},{\"filter_name\":\"YPGG00\",\"hidden\":false,\"LAY_TABLE_INDEX\":3,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"规格\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":3,\"ora_name\":\"YPGG00\",\"field\":\"YPGG00\",\"sortType\":\"asc\",\"width\":\"108\",\"fixed\":\"\",\"_VCUID\":\"row_933\",\"render\":\"\",\"key\":\"YPGG00\"},{\"filter_name\":\"LSDJ00\",\"hidden\":false,\"LAY_TABLE_INDEX\":4,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"单价\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":4,\"ora_name\":\"LSDJ00\",\"field\":\"LSDJ00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_934\",\"render\":\"\",\"key\":\"LSDJ00\"},{\"filter_name\":\"YPZSL0\",\"hidden\":false,\"LAY_TABLE_INDEX\":5,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"数量\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":5,\"ora_name\":\"YPZSL0\",\"field\":\"YPZSL0\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_935\",\"render\":\"\",\"key\":\"YPZSL0\"},{\"filter_name\":\"CFDW00\",\"hidden\":false,\"LAY_TABLE_INDEX\":6,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"单位\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":6,\"ora_name\":\"CFDW00\",\"field\":\"CFDW00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_936\",\"render\":\"\",\"key\":\"CFDW00\"},{\"filter_name\":\"to_char(CSL000,'fm999999990.0999')||JLDW00\",\"hidden\":false,\"LAY_TABLE_INDEX\":7,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"单剂量\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":7,\"ora_name\":\"DJL000\",\"headerAlign\":\"center\",\"field\":\"DJL000\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_937\",\"render\":\"\",\"key\":\"DJL000\"},{\"filter_name\":\"PCMC00\",\"hidden\":false,\"LAY_TABLE_INDEX\":8,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"频次\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":8,\"ora_name\":\"PCMC00\",\"field\":\"PCMC00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_938\",\"render\":\"\",\"key\":\"PCMC00\"},{\"filter_name\":\"CXBZ00\",\"hidden\":true,\"LAY_TABLE_INDEX\":9,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":9,\"ora_name\":\"CXBZ00\",\"field\":\"CXBZ00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_939\",\"render\":\"\",\"key\":\"CXBZ00\"},{\"filter_name\":\"YFSMMC || YPYFMC || ZJYFMC || XMYFMC\",\"hidden\":false,\"LAY_TABLE_INDEX\":10,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"用法\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":10,\"ora_name\":\"YYFF00\",\"field\":\"YYFF00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_940\",\"render\":\"\",\"key\":\"YYFF00\"},{\"filter_name\":\"YYSJ00 || YYSJDW\",\"hidden\":false,\"LAY_TABLE_INDEX\":11,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"天数\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":11,\"ora_name\":\"YYTS00\",\"field\":\"YYTS00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_941\",\"render\":\"\",\"key\":\"YYTS00\"},{\"filter_name\":\"YPSCCJ\",\"hidden\":false,\"LAY_TABLE_INDEX\":12,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"厂家\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":12,\"ora_name\":\"YPSCCJ\",\"field\":\"YPSCCJ\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_942\",\"render\":\"\",\"key\":\"YPSCCJ\"},{\"filter_name\":\"nvl(KPHSS0, YPZSL0)\",\"hidden\":false,\"LAY_TABLE_INDEX\":13,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"空瓶回收数\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":13,\"ora_name\":\"KPHSS0\",\"field\":\"KPHSS0\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_943\",\"render\":\"\",\"key\":\"KPHSS0\"},{\"filter_name\":\"nvl(HSKPPH,(select SCPH00 from YF_PCCKMX H,YF_PCKCMX K where LYDJH0=to_char(a.CFID00) and H.MZZYBZ='0' and K.KCLSH0=H.KCLSH0))\",\"hidden\":false,\"LAY_TABLE_INDEX\":14,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"回收空瓶批号\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":14,\"ora_name\":\"HSKPPH\",\"field\":\"HSKPPH\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_944\",\"render\":\"\",\"key\":\"HSKPPH\"},{\"filter_name\":\"YPZSL0 - JYSL00\",\"hidden\":false,\"LAY_TABLE_INDEX\":15,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"实际数量\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":15,\"ora_name\":\"SJSL00\",\"field\":\"SJSL00\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_945\",\"render\":\"\",\"key\":\"SJSL00\"},{\"filter_name\":\"nvl(HSKPRQ, to_char(com.alibaba.druid.sql.dialect.oracle.ast.expr.OracleSysdateExpr@2627e5ac, 'YYYYMMDD'))\",\"hidden\":false,\"LAY_TABLE_INDEX\":16,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"回收日期\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":16,\"ora_name\":\"HSKPRQ\",\"field\":\"HSKPRQ\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_946\",\"render\":\"\",\"key\":\"HSKPRQ\"},{\"filter_name\":\"(select SCPH00 from YF_PCCKMX H,YF_PCKCMX K where LYDJH0=to_char(a.CFID00) and H.MZZYBZ='0' and K.KCLSH0=H.KCLSH0)\",\"hidden\":false,\"LAY_TABLE_INDEX\":17,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"批号\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":17,\"ora_name\":\"YPSCPH\",\"field\":\"YPSCPH\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_947\",\"render\":\"\",\"key\":\"YPSCPH\"},{\"filter_name\":\"a.KPHSR0\",\"hidden\":false,\"LAY_TABLE_INDEX\":18,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"回收人\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":18,\"ora_name\":\"KPHSR0\",\"field\":\"KPHSR0\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_948\",\"render\":\"\",\"key\":\"KPHSR0\"},{\"filter_name\":\"SELECT zwxm00\\nFROM bm_ygbm00\\nWHERE ygbh00 = a.KPHSR0\\n\\tAND rownum = 1\",\"hidden\":true,\"LAY_TABLE_INDEX\":19,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"\",\"align\":\"center\",\"ellipsis\":true,\"sequence\":19,\"ora_name\":\"KPHSRM\",\"field\":\"KPHSRM\",\"sortType\":\"asc\",\"width\":\"100\",\"fixed\":\"\",\"_VCUID\":\"row_949\",\"render\":\"\",\"key\":\"KPHSRM\"},{\"sys_hidden\":\"\",\"filter_name\":\"C_YPJE\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":20,\"minWidth\":\"\",\"className\":\"\",\"sortable\":false,\"title\":\"金额\",\"align\":\"right\",\"ellipsis\":true,\"sequence\":20,\"ora_name\":\"C_YPJE\",\"round\":\"\",\"trunc\":\"\",\"field\":\"C_YPJE\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"fixed\":\"\",\"_VCUID\":\"row_950\",\"render\":\"\",\"key\":\"C_YPJE\"},{\"filter_name\":\"SELECT 1 FROM YF_MZCF00 WHERE CFLSH0 = A.CFLSH0 AND SFJG00\",\"hidden\":false,\"LAY_TABLE_INDEX\":21,\"sortable\":false,\"isSummary\":\"false\",\"title\":\"审方结果\",\"align\":\"left\",\"ellipsis\":true,\"ora_name\":\"SFJG00\",\"disabledCheckboxColumn\":false,\"sequence\":21,\"field\":\"SFJG00\",\"sortType\":\"asc\",\"width\":\"80\",\"_VCUID\":\"row_951\",\"render\":\"\",\"key\":\"SFJG00\"}]","condition":"[]","countSql":"SELECT COUNT(1) as TOTAL,sum(nvl(LSDJ00*YPZSL0,0)) sumC_YPJE\nFROM YF_MZCFMX a\nWHERE  CFLSH0='${CFLSH0}' AND SFZBY0='N'\nORDER BY ZB0000\n","createTime":1618483628000,"entityVersion":0,"id":"queryToxicPrescriptionDetail","isLaypage":"0","module":"yf","name":"queryToxicPrescriptionDetail","pageSql":"SELECT CFID00,CFLSH0,YPMC00,YPGG00,LSDJ00,YPZSL0,CFDW00,nvl((LSDJ00*YPZSL0),0) C_YPJE,\n       to_char(CSL000,'fm999999990.0999')||JLDW00\n       AS DJL000,PCMC00,CXBZ00,\n       YFSMMC||YPYFMC||ZJYFMC||XMYFMC as YYFF00,\n       YYSJ00||YYSJDW AS YYTS00,YPSCCJ,nvl(KPHSS0,YPZSL0) KPHSS0,\n--nvl(HSKPPH,(select i.scph00 from yf_ypmxz0 h,yk_yprkmx i where h.djh000=a.cflsh0 and h.RCLXMC='门诊处方' and h.ypnm00+0=a.ypnm00 and h.ykrkpc=i.yprkpc and rownum=1)) as HSKPPH,\nnvl(HSKPPH,(select SCPH00 from YF_PCCKMX H,YF_PCKCMX K where LYDJH0=to_char(a.CFID00) and H.MZZYBZ='0' and K.KCLSH0=H.KCLSH0 and rownum=1) ) HSKPPH,\n       YPZSL0-JYSL00 SJSL00,nvl(HSKPRQ,to_char(sysdate,'YYYYMMDD')) as HSKPRQ,\n     -- (select i.scph00 from yf_ypmxz0 h,yk_yprkmx i where h.djh000=a.cflsh0 and h.RCLXMC='门诊处方' and h.ypnm00+0=a.ypnm00 and h.ykrkpc=i.yprkpc and rownum=1) as YPSCPH,\n     (select SCPH00 from YF_PCCKMX H,YF_PCKCMX K where LYDJH0=to_char(a.CFID00) and H.MZZYBZ='0' and K.KCLSH0=H.KCLSH0 and rownum=1 ) YPSCPH,\n       a.KPHSR0,\n      (select zwxm00 from bm_ygbm00 where ygbh00=a.KPHSR0 and rownum=1) KPHSRM,\n      (SELECT SFJG00 FROM YF_MZCF00 WHERE CFLSH0 = A.CFLSH0 and rownum=1) SFJG00\nFROM YF_MZCFMX a\nWHERE  CFLSH0='${CFLSH0}' AND SFZBY0='N'\nORDER BY ZB0000\n","procedureCommit":0,"procedureParameter":"[]","remark":"处方查询-门诊毒麻处方查询-查询毒麻处方药品明细","system":"his","updateTime":1749459724000,"version":0}]