日期参数为年月日型,只取年月
where
1=1
${if(len(日期)==0,""," and substr(日期,1,7)='" + 日期 + "' " )}
${if(len(公司)==0,""," and 公司='" + 公司 + "' " )}
参考下拉框参数为空选择全部-https://help.fanruan.com/finereport/doc-view-2394.html
日期参数只取年月
设置下,如下图
多个参数,下面格式多写几个就可
${if(len(area) == 0,"","and 货主地区 = '" + area + "'")}
${if(len(日期)==0,""," and 日期='" + 日期 + "' " )}