where条件筛选，未生效${if(len(para7)==0,nofilter,"and DATE_FORMAT(dbrk.in_stock_time, '%Y-%m-%d') >= ('"+para11+"')")}${if(len(para7)==0,nofilter,"and DATE_FORMAT(dbrk.in_stock_time, '%Y-%m-%d') <= ('"+para12+"')")}
where 1=1
${if(len(para7)==0,"","and DATE_FORMAT(dbrk.in_stock_time, '%Y-%m-%d') >= ('"+para11+"')")}
${if(len(para7)==0,"","and DATE_FORMAT(dbrk.in_stock_time, '%Y-%m-%d') <= ('"+para12+"')")}
para7要有值，后面的时间过滤才会生效
你是数据库吧
${if(len(para7)==0,"","and DATE_FORMAT(dbrk.in_stock_time, '%Y-%m-%d') >= '"+para11+"'")}${if(len(para7)==0,"","and DATE_FORMAT(dbrk.in_stock_time, '%Y-%m-%d') <= '"+para12+"'")}
1min目标场景问卷
立即参与
