select p.ORIGINAL_NUMBER,
p.CREATE_DATE,
p.HANDLE_DATE, --处理日期
p.DESTROY_DATE, --销毁日期
p.DESTROY_USER,
nvl(p.DESTROY_DATE,sysdate) -p.HANDLE_DATE as days
from JNETTMS.T_RETURN_PACKAGE p
where p.STATUS = 5
${if(len(销毁日期_起始)=0,"and p.HANDLE_DATE>=TRUNC(SYSDATE)-7"," and to_char(a.HANDLE_DATE,'yyyy-MM-dd')>='"+销毁日期_起始+"'")}
${if(len(销毁日期_结束)=0,"and a.HANDLE_DATE<TRUNC(SYSDATE)+1"," and to_char(a.HANDLE_DATE,'yyyy-MM-dd')<='"+销毁日期_结束+"'")}
${if(len(执行销毁日期_起始)=0,"and p.DESTROY_DATE>=TRUNC(SYSDATE)-7"," and to_char(a.DESTROY_DATE,'yyyy-MM-dd')>='"+执行销毁日期_起始+"'")}
${if(len(执行销毁日期_结束)=0,"and a.DESTROY_DATE<TRUNC(SYSDATE)+1"," and to_char(a.DESTROY_DATE,'yyyy-MM-dd')<='"+执行销毁日期_结束+"'")}