场景如上：

场景如下：红框中如果是历史，则需要过滤车型(全部车型/某一个)，开始日期，结束日期，班别(早班/晚班)，

我的sql如下：

select 

*

from  t_contribution_value_count

 WHERE  1=1

${if(len(p_plant)=0,"  "," and factory_id="+p_plant)}

${if(p_type="历史" ,

if( and(p_car="全部车型",p_class="早班"),"  and  LEFT(created_time, 10) between '" +start_date +" ' and '"+end_date+"'  and date_format(created_time,'%H:%i:%s')  between '08:00:00'  and '18:00:00'  ",

if(and(p_car="全部车型",p_class="晚班"),"  and  LEFT(created_time, 10) between '" +start_date +" ' and '"+end_date+"'  and date_format(created_time,'%H:%i:%s') not between '08:00:00'  and '18:00:00'  ",

if(and(p_car!="全部车型",p_class="早班"),"  and  LEFT(created_time, 10) between '" +start_date +" ' and '"+end_date+"'  and date_format(created_time,'%H:%i:%s')  between '08:00:00'  and '18:00:00'   and vehicle_type= '"+p_car+"' ",

if(and(p_car!="全部车型",p_class="晚班"),"  and  LEFT(created_time, 10) between '" +start_date +" ' and '"+end_date+"'  and vehicle_type= '"+p_car+"' and date_format(created_time,'%H:%i:%s') not between '08:00:00'  and '18:00:00'  ",

"")))))}