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')<='"+执行销毁日期_结束+"'")}