${if(len(start_date)==0,""," and rs.count_date >= '"+start_date+"'||' 00:00:00'")}

${if(len(end_date)==0,""," and rs.count_date <= '"+end_date+"'||' 23:59:59'")}

${if(len(ldt_commitTimeBg)==0,""," and to_date(to_char(rdnc.commit_date,'yyyy-MM-dd'),'yyyy-MM-dd') =

to_date('"+ldt_commitTimeBg+" ', 'yyyy-mm-dd ')")}

${if(len(ldt_commitTimeBg)==0,""," and to_date(t.return_time,'YYYY-MM-DD hh24:mi:ss') >=

to_date('"+ldt_commitTimeBg+"'||' 00:00:00', 'YYYY-MM-DD hh24:mi:ss')")}

${if(len(ldt_commitTimeEd)==0,""," and to_date(t.return_time,'YYYY-MM-DD hh24:mi:ss') <=

to_date('"+ldt_commitTimeEd+"'||' 23:59:59', 'YYYY-MM-DD hh24:mi:ss')")}

${if(len(ldt_commitTimeBg)==0,""," and t.order_date>=to_date('"+ldt_commitTimeBg+"','YYYY/MM/DD')")}

${if(len(ldt_commitTimeEd)==0,""," and t.order_date<=to_date('"+ldt_commitTimeEd+"','YYYY/MM/DD')")}

${if(len(ldt_commitTimeBg)==0,""," and t.order_date>=to_date('"+ldt_commitTimeBg+"','YYYY/MM/DD')")}

${if(len(ldt_commitTimeEd)==0,""," and t.order_date<=to_date('"+ldt_commitTimeEd+"','YYYY/MM/DD')")}

${if(len(commitStartTime)==0,""," and to_date(oif.finish_time,'YYYY-MM-DD hh24:mi:ss') >=

to_date('"+commitStartTime+"'||' 00:00:00', 'YYYY-MM-DD hh24:mi:ss')")}

${if(len(commitEndTime)==0,""," and to_date(oif.finish_time,'YYYY-MM-DD hh24:mi:ss') <=

to_date('"+commitEndTime+"'||' 23:59:59', 'YYYY-MM-DD hh24:mi:ss')")}

${if(len(start_date) ==0,""," and  substr(oif.commit_time,1,7) = '" +start_date +"'")}

${if(len(ldt_commitTimeBg)==0,""," and to_date(o.commit_time,'YYYY-MM-DD hh24:mi:ss') >=

to_date('"+ldt_commitTimeBg+"'||' 00:00:00', 'YYYY-MM-DD hh24:mi:ss')")}

${if(len(ldt_commitTimeEd)==0,""," and to_date(o.commit_time,'YYYY-MM-DD hh24:mi:ss') <=

to_date('"+ldt_commitTimeEd+"'||' 23:59:59', 'YYYY-MM-DD hh24:mi:ss')")}

${if(len(ldt_commitTimeBg)==0,""," and o.commit_time >= '"+ldt_commitTimeBg+"'||' 00:00:00'" )}

${if(len(ldt_commitTimeEd)==0,""," and o.commit_time <= '"+ldt_commitTimeEd+"'||' 23:59:59'" )}

${if(len(start_date)==0,""," and substr(vsms.order_commit_date,1,7) >= '"+start_date+"'")}

and oit.is_delete='N'

${if(len(queryCommitTimeBg)==0,""," and o.commit_time>='"+queryCommitTimeBg+"' || ' 00:00:00'")}

${if(len(queryCommitTimeEd)==0,""," and o.commit_time<= '"+queryCommitTimeEd+"' || ' 23:59:59'")}

${if(len(ldt_commitTimeBg)==0,""," and t.order_date>=to_date('"+ldt_commitTimeBg+"','YYYY/MM/DD')")}

${if(len(ldt_commitTimeEd)==0,""," and t.order_date<=to_date('"+ldt_commitTimeEd+"','YYYY/MM/DD')")}

${if(len(ldt_commitTimeBg)==0,""," and o.commit_time >= '"+ldt_commitTimeBg+"'||' 00:00:00'" )}

${if(len(ldt_commitTimeEd)==0,""," and o.commit_time <= '"+ldt_commitTimeEd+"'||' 23:59:59'" )}