[{"branch":"0","branchmc":"standard","button":"[]","catalog":"ChaXun","chart":"[]","code":"queryYptjxxList","column":"[{\"sys_hidden\":\"\",\"filter_name\":\"YPTJPC\",\"hidden\":false,\"isTotal\":\"true\",\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":0,\"totalType\":\"合计\",\"className\":\"\",\"title\":\"调价单号\",\"align\":\"center\",\"ora_name\":\"YPTJPC\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"YPTJPC\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":0,\"round\":\"\",\"trunc\":\"\",\"field\":\"YPTJPC\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"QRRQ01\",\"hidden\":false,\"isTotal\":\"true\",\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":1,\"totalType\":\"${COUNT0}\",\"className\":\"\",\"title\":\"调价日期\",\"align\":\"center\",\"ora_name\":\"QRRQ01\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"QRRQ01\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":1,\"round\":\"\",\"trunc\":\"\",\"field\":\"QRRQ01\",\"sortType\":\"asc\",\"width\":\"110\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"QRSJ00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":2,\"className\":\"\",\"title\":\"调价时间\",\"align\":\"center\",\"ora_name\":\"QRSJ00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"QRSJ00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":2,\"round\":\"\",\"trunc\":\"\",\"field\":\"QRSJ00\",\"sortType\":\"asc\",\"width\":\"110\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"YPMC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":3,\"className\":\"\",\"title\":\"药品名称\",\"align\":\"center\",\"ora_name\":\"YPMC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"YPMC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":3,\"round\":\"\",\"trunc\":\"\",\"field\":\"YPMC00\",\"sortType\":\"asc\",\"width\":\"130\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"YPGG00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":4,\"className\":\"\",\"title\":\"规格\",\"align\":\"center\",\"ora_name\":\"YPGG00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"YPGG00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":4,\"round\":\"\",\"trunc\":\"\",\"field\":\"YPGG00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"TJDW00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":5,\"className\":\"\",\"title\":\"单位\",\"align\":\"center\",\"ora_name\":\"TJDW00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"TJDW00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":5,\"round\":\"\",\"trunc\":\"\",\"field\":\"TJDW00\",\"sortType\":\"asc\",\"width\":\"80\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":6,\"className\":\"\",\"title\":\"购进价\",\"align\":\"center\",\"ora_name\":\"\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"GJJ\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":6,\"round\":\"\",\"trunc\":\"\",\"field\":\"GJJ\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"YPFDJ0\",\"hidden\":false,\"fatherKey\":\"GJJ\",\"LAY_TABLE_INDEX\":7,\"className\":\"\",\"title\":\"原价\",\"align\":\"center\",\"ora_name\":\"YPFDJ0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"YPFDJ0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":7,\"round\":\"\",\"trunc\":\"\",\"field\":\"YPFDJ0\",\"sortType\":\"asc\",\"width\":\"80\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"XPFDJ0\",\"hidden\":false,\"fatherKey\":\"GJJ\",\"LAY_TABLE_INDEX\":8,\"className\":\"\",\"title\":\"现价\",\"align\":\"center\",\"ora_name\":\"XPFDJ0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"XPFDJ0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":8,\"round\":\"\",\"trunc\":\"\",\"field\":\"XPFDJ0\",\"sortType\":\"asc\",\"width\":\"80\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"GJCJ00\",\"hidden\":false,\"fatherKey\":\"GJJ\",\"LAY_TABLE_INDEX\":9,\"className\":\"\",\"title\":\"差价\",\"align\":\"center\",\"ora_name\":\"GJCJ00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"GJCJ00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":9,\"round\":\"\",\"trunc\":\"\",\"field\":\"GJCJ00\",\"sortType\":\"asc\",\"width\":\"80\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":10,\"className\":\"\",\"title\":\"零售价\",\"align\":\"center\",\"ora_name\":\"\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"LSJ\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":10,\"round\":\"\",\"trunc\":\"\",\"field\":\"LSJ\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"YLSDJ0\",\"hidden\":false,\"fatherKey\":\"LSJ\",\"LAY_TABLE_INDEX\":11,\"className\":\"\",\"title\":\"原价\",\"align\":\"center\",\"ora_name\":\"YLSDJ0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"YLSDJ0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":11,\"round\":\"\",\"trunc\":\"\",\"field\":\"YLSDJ0\",\"sortType\":\"asc\",\"width\":\"80\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"XLSDJ0\",\"hidden\":false,\"fatherKey\":\"LSJ\",\"LAY_TABLE_INDEX\":12,\"className\":\"\",\"title\":\"现价\",\"align\":\"center\",\"ora_name\":\"XLSDJ0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"XLSDJ0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":12,\"round\":\"\",\"trunc\":\"\",\"field\":\"XLSDJ0\",\"sortType\":\"asc\",\"width\":\"80\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"LSCJ00\",\"hidden\":false,\"fatherKey\":\"LSJ\",\"LAY_TABLE_INDEX\":13,\"className\":\"\",\"title\":\"差价\",\"align\":\"center\",\"ora_name\":\"LSCJ00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"LSCJ00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":13,\"round\":\"\",\"trunc\":\"\",\"field\":\"LSCJ00\",\"sortType\":\"asc\",\"width\":\"80\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"ZMKC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":14,\"className\":\"\",\"title\":\"账面库存\",\"align\":\"center\",\"ora_name\":\"ZMKC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"ZMKC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":14,\"round\":\"\",\"trunc\":\"\",\"field\":\"ZMKC00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"SJKC00\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":15,\"className\":\"\",\"title\":\"实际库存\",\"align\":\"center\",\"ora_name\":\"SJKC00\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"SJKC00\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":15,\"round\":\"\",\"trunc\":\"\",\"field\":\"SJKC00\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":16,\"className\":\"\",\"title\":\"调价损益\",\"align\":\"center\",\"ora_name\":\"\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"TJSY\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":16,\"round\":\"\",\"trunc\":\"\",\"field\":\"TJSY\",\"sortType\":\"asc\",\"width\":\"\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"GJJECJ\",\"hidden\":false,\"isTotal\":\"true\",\"fatherKey\":\"TJSY\",\"LAY_TABLE_INDEX\":17,\"totalType\":\"${GJJECJ,2}\",\"className\":\"\",\"title\":\"购进金额\",\"align\":\"center\",\"ora_name\":\"GJJECJ\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"GJJECJ\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":17,\"round\":\"\",\"trunc\":\"\",\"field\":\"GJJECJ\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"LSJECJ\",\"hidden\":false,\"isTotal\":\"true\",\"fatherKey\":\"TJSY\",\"LAY_TABLE_INDEX\":18,\"totalType\":\"${LSJECJ,2}\",\"className\":\"\",\"title\":\"零售金额\",\"align\":\"center\",\"ora_name\":\"LSJECJ\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"LSJECJ\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":18,\"round\":\"\",\"trunc\":\"\",\"field\":\"LSJECJ\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"CZYXM0\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":19,\"className\":\"\",\"title\":\"操作员\",\"align\":\"center\",\"ora_name\":\"CZYXM0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"CZYXM0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":19,\"round\":\"\",\"trunc\":\"\",\"field\":\"CZYXM0\",\"sortType\":\"asc\",\"width\":\"80\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"QRRXM0\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":20,\"className\":\"\",\"title\":\"确认员\",\"align\":\"center\",\"ora_name\":\"QRRXM0\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"QRRXM0\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":20,\"round\":\"\",\"trunc\":\"\",\"field\":\"QRRXM0\",\"sortType\":\"asc\",\"width\":\"80\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"BZ0000\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":21,\"className\":\"\",\"title\":\"备注\",\"align\":\"center\",\"ora_name\":\"BZ0000\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"BZ0000\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":21,\"round\":\"\",\"trunc\":\"\",\"field\":\"BZ0000\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"},{\"sys_hidden\":\"\",\"filter_name\":\"YPMLBZ\",\"hidden\":false,\"fatherKey\":\"\",\"LAY_TABLE_INDEX\":22,\"className\":\"\",\"title\":\"药品目录备注\",\"align\":\"center\",\"ora_name\":\"YPMLBZ\",\"headerAlign\":\"center\",\"render\":\"\",\"key\":\"YPMLBZ\",\"summary\":\"\",\"minWidth\":\"\",\"sortable\":false,\"isSummary\":\"false\",\"ellipsis\":true,\"disabledCheckboxColumn\":false,\"sequence\":22,\"round\":\"\",\"trunc\":\"\",\"field\":\"YPMLBZ\",\"sortType\":\"asc\",\"width\":\"100\",\"uiType\":\"\",\"footerAlign\":\"center\",\"fixed\":\"\"}]","condition":"[]","createTime":1705390935000,"entityVersion":0,"id":"queryYptjxxList","isLaypage":"0","module":"yf","name":"queryYptjxxList","pageSql":"select * from (\nselect '1' COUNT0,A.*,B.LBBH00,B.YPMLBZ \nfrom VW_YF_YPTJCX A,\n(select LBBH00,YPNM00,YPMLBZ from BM_YD0000) B \nwhere A.YPNM00=B.YPNM00 \n  and A.YXBMBH=${YXBMBH}\n<#if  (LBBH00?default(\"\")?trim?length gt 0)>\n   and B.LBBH00='${LBBH00}'\n</#if>\n  and A.QRRQ00>='${beginDate}'\n  and A.QRRQ00<='${endDate}'\n  and A.QRRQ00||A.QRSJ00>='${beginTime}' and A.QRRQ00||A.QRSJ00<='${endTime}'\n<#if checkTj=='0'>\n  and A.SJKC00<>0 AND (A.YLSDJ0<>A.XLSDJ0 OR A.YPFDJ0<>A.XPFDJ0)\n</#if>\nunion all\nselect '1' COUNT0,C.*,D.LBBH00,D.YPMLBZ \nfrom\n(select\n  '' YPTJPC,\n  YFBMBH YXBMBH,\n  JZDW00 TJDWH0,\n  max(JZRQ00) SWRQ00,\n  '' ZXRQ00,\n  max(JZRQ00) TJRQ00,\n  max(JZSJ00) TJSJ00,\n  max(JZRQ00) QRRQ00,\n  max(JZSJ00) QRSJ00,\n  'Y' SFQR00,\n  0 QRRBH0,\n  '' QRRXM0,\n  0 CZYBH0,\n  '' CZYXM0,\n  YPNM00,\n  YPMC00,\n  YPGG00,\n  JZDW00 TJDW00,\n  ZHL000,\n  0 ZMKC00,\n  0 SJKC00,\n  0 YPFDJ0,\n  0 XPFDJ0,\n  0 GJPJDJ,\n  0 YLSDJ0,\n  0 XLSDJ0,\n  ZY0000 BZ0000,\n  to_char(to_date(max(JZRQ00),'YYYYMMDD'),'YYYY-MM-DD')  QRRQ01,\n  0 GJCJ00,\n  nvl(FCDJ00,0) LSCJ00,\n --to_char(sum(NVL(GJSLJE,0)-NVL(GJFCJE,0))) GJJECJ,\n --to_char(sum(NVL(SLJE00,0)-NVL(FCDJ00,0))) LSJECJ\nto_char(sum(NVL(GJSLJE,0)-NVL(GJFCJE,0)), 'FM999999990.00') GJJECJ,\nto_char(sum(NVL(SLJE00,0)-NVL(FCDJ00,0)), 'FM999999990.00') LSJECJ\nfrom YF_YPMXZ0 where CRBMBH in ('66666')\nand YFBMBH=${YXBMBH}\nand JZRQ00>='${beginDate}'\nand JZRQ00<='${endDate}'\nand JZRQ00||JZSJ00>='${beginTime}' and JZRQ00||JZSJ00<='${endTime}'\ngroup by YFBMBH,JZDW00,YPNM00,YPMC00,YPGG00,JZDW00,ZHL000,FCDJ00,ZY0000) C,\n(select LBBH00,YPNM00,YPMLBZ from BM_YD0000) D \nwhere C.YPNM00 = D.YPNM00\n<#if  (LBBH00?default(\"\")?trim?length gt 0)>\n   and D.LBBH00='${LBBH00}'\n</#if>\n) E\norder by E.QRRQ00,E.YPTJPC,E.YPNM00","procedureCommit":0,"procedureParameter":"[]","remark":"药品调价信息查询","system":"his","updateTime":1759025342000,"version":0}]