in('"+等级+"')

if(len(等级)==0,

${if(len(等级)=0,

"select 

roast_season,

smoke_area,

smoke_type,

AVG(standard_slice_rate) as 出片率,

AVG(standard_stem_rate) as 含梗率,

AVG(avg_slice_water) AS 含水率

from physics_check 

group by roast_season,smoke_area,smoke_type 

order by roast_season",

"select 

roast_season,

smoke_area,

smoke_type,

AVG(standard_slice_rate) as 出片率,

AVG(standard_stem_rate) as 含梗率,

AVG(avg_slice_water) AS 含水率

from physics_check 

where smoke_level in('"+等级 +"') group by roast_season,smoke_area,smoke_type 

order by roast_season")}

改成这样：

select 

roast_season,smoke_area,smoke_level,smoke_type,

AVG(standard_slice_rate) as 出片率,

AVG(standard_stem_rate) as 含梗率,

AVG(avg_slice_water) AS 含水率 

from physics_check 

where 1=1

${if(len(等级)=0,""," and smoke_level in ('"+等级+"')")}

group by roast_season,smoke_area,smoke_level,smoke_type 

order by roast_season