and ros_date between To_Date('${SDATE}', 'YYYY-MM-DD') and To_Date('${EDATE}', 'YYYY-MM-DD') ------业务日期
and dtbegindate between To_Date('${SKKDATE}', 'YYYY-MM-DD') and To_Date('${EKKDATE}', 'YYYY-MM-DD') ------开课日期
and ros_date between add_months(to_date('${SDATE}','yyyy/mm/dd'),-12) and add_months(to_date('${EDATE}','yyyy/mm/dd'),-12)------业务日期
and dtbegindate between add_months (To_Date('${SKKDATE}', 'YYYY/MM/DD'),-12) and add_months(To_Date('${EKKDATE}', 'YYYY/MM/DD'),-12) ------开课日期
${if(dimflag==1,"and ros_date between '"+SINDATE+"' and '"+EINDATE+"'","")}-----业务日期当期
${if(dimflag==2,"and dtbegindate between '"+SKKDATE+"' and '"+EKKDATE+"'","")}-----开课日期当期
${if(dimflag==1,"and ros_date between add_months('"+SINDATE+"',-12) and add_months('"+EINDATE+"',-12)","")}-----业务日期同期
${if(dimflag==2,"and dtbegindate between add_months('"+SKKDATE+"',-12) and add_months('"+EKKDATE+"',-12)","")}-----开课日期同期
