求帮忙看下哪里错了${IF(统计条件="OUT","SELECT DISTINCT A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME,SUM(D.UNITSQUANTITY) UNITSQUANTITY,SUM(D.ROUNDREALAMOUNT) ROUNDREALAMOUNT
FROM NEWAY_HIS_HNXX_1210.NBDITEMMAIN A
INNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMMEDPROPERTY B ON A.ITEMID=B.ITEMID
INNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMUNITS C ON B.ITEMID=C.ITEMID AND C.UNITSTYPEID='0401'
INNER JOIN NEWAY_HIS_HNXX_1210.NOP0501B D ON C.ITEMID = D.ITEMID AND C.UNITSSERIAL=D.UNITSSERIAL
INNER JOIN NEWAY_HIS_HNXX_1210.NOP0501A E ON D.SETTLEID = E.SETTLEID
WHERE A.ITEMTYPEID LIKE '01%' AND B.ESSENTIALDRUGTYPEID ='01' AND D.UNITSQUANTITY>0 AND E.SETTLEDATETIME>=TO_DATE('"+开始日期+"','yyyy-mm-dd hh24:mi:ss') AND E.SETTLEDATETIME<TO_DATE('"+结束日期+"','yyyy-mm-dd hh24:mi:ss')
GROUP BY A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME",IF(统计条件="IN","SELECT DISTINCT A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME,SUM(D.UNITSQUANTITY) UNITSQUANTITY,SUM(D.ROUNDREALAMOUNT) ROUNDREALAMOUNT
FROM NEWAY_HIS_HNXX_1210.NBDITEMMAIN A
INNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMMEDPROPERTY B ON A.ITEMID=B.ITEMID
INNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMUNITS C ON B.ITEMID=C.ITEMID AND C.UNITSTYPEID='0401'
INNER JOIN NEWAY_HIS_HNXX_1210.NIP0601B D ON C.ITEMID = D.ITEMID AND C.UNITSSERIAL=D.UNITSSERIAL
INNER JOIN NEWAY_HIS_HNXX_1210.NIP0601A E ON d.CHARGEID = E.CHARGEID
WHERE A.ITEMTYPEID LIKE '01%' AND B.ESSENTIALDRUGTYPEID ='01' AND D.UNITSQUANTITY>0 AND E.CHARGEDATETIME>=TO_DATE('"+开始日期+"','yyyy-mm-dd hh24:mi:ss') AND E.CHARGEDATETIME<TO_DATE('"+结束日期+"','yyyy-mm-dd hh24:mi:ss')
GROUP BY A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME",IF(统计条件="ALL","SELECT DISTINCT A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME,SUM(D.UNITSQUANTITY) UNITSQUANTITY,SUM(D.ROUNDREALAMOUNT) ROUNDREALAMOUNT
FROM NEWAY_HIS_HNXX_1210.NBDITEMMAIN A
INNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMMEDPROPERTY B ON A.ITEMID=B.ITEMID
INNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMUNITS C ON B.ITEMID=C.ITEMID AND C.UNITSTYPEID='0401'
INNER JOIN NEWAY_HIS_HNXX_1210.NOP0501B D ON C.ITEMID = D.ITEMID AND C.UNITSSERIAL=D.UNITSSERIAL
INNER JOIN NEWAY_HIS_HNXX_1210.NOP0501A E ON D.SETTLEID = E.SETTLEID
WHERE A.ITEMTYPEID LIKE '01%' AND B.ESSENTIALDRUGTYPEID ='01' AND D.UNITSQUANTITY>0 AND E.SETTLEDATETIME>=TO_DATE('"+开始日期+"','yyyy-mm-dd hh24:mi:ss') AND E.SETTLEDATETIME<TO_DATE('"+结束日期+"','yyyy-mm-dd hh24:mi:ss')
GROUP BY A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME
UNION ALL
SELECT DISTINCT A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME,SUM(D.UNITSQUANTITY) UNITSQUANTITY,SUM(D.ROUNDREALAMOUNT) ROUNDREALAMOUNT
FROM NEWAY_HIS_HNXX_1210.NBDITEMMAIN A
INNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMMEDPROPERTY B ON A.ITEMID=B.ITEMID
INNER JOIN NEWAY_HIS_HNXX_1210.NBDITEMUNITS C ON B.ITEMID=C.ITEMID AND C.UNITSTYPEID='0401'
INNER JOIN NEWAY_HIS_HNXX_1210.NIP0601B D ON C.ITEMID = D.ITEMID AND C.UNITSSERIAL=D.UNITSSERIAL
INNER JOIN NEWAY_HIS_HNXX_1210.NIP0601A E ON d.CHARGEID = E.CHARGEID
WHERE A.ITEMTYPEID LIKE '01%' AND B.ESSENTIALDRUGTYPEID ='01' AND D.UNITSQUANTITY>0 AND E.CHARGEDATETIME>=TO_DATE('"+开始日期+"','yyyy-mm-dd hh24:mi:ss') AND E.CHARGEDATETIME<TO_DATE('"+结束日期+"','yyyy-mm-dd hh24:mi:ss')
GROUP BY A.ITEMSPEC,A.ITEMID,A.ITEMNAME,C.UNITSNAME","")))}
