单元格中还做了过滤
WHERE 1=1
${if(len(starttime)=0,""," and DATE_FORMAT(SettlementDate,'%Y-%m-%d') >= '"+starttime+"'")}
${if(len(endtime)=0,""," and DATE_FORMAT(SettlementDate,'%Y-%m-%d') <= '"+endtime+"'")}
用这串吧,这串是可以的