未过月份如何计算?你选择3季度后,真实的代入值是多少?
where 1=1
${if(jd="一季度","and 月份字段 in('1','2','3')",if(jd="二季度","and 月份字段 in('4','5','6')",if(jd="三季度","and 月份字段 in('7','8','9')",
"and 月份字段 in('10','11','12')")))}
select
15(${if(jd="一季度",11,if(jd="二季度",8,if(jd="三季度",5,2)))}) as 计算
from 表名称
where 1=1
${if(jd="一季度","and 月份字段 in('1','2','3')",if(jd="二季度","and 月份字段 in('4','5','6')",if(jd="三季度","and 月份字段 in('7','8','9')",
"and 月份字段 in('10','11','12')")))}