场景如上:场景如下:红框中如果是历史,则需要过滤车型(全部车型/某一个),开始日期,结束日期,班别(早班/晚班),我的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' ","")))))}