${ if (len(S_year)=0, "", " and xx in ('"+S_year+"')")}
想要书写的逻辑是,当月份的变量>5时,年份只包含S_year ,如果当月份变量<5 时,年份包含S_year 和 S_year-1
如何书写?
S_year是多选?
如果当月份变量<5 时,年份包含S_year 和 S_year-1 这个举个例子 :S_year为2022,2023 时是不是 年份就应该包含 2021,2022,2023?
--------------------
SELECT * FROM 表 WHERE 1=1 ${if(len(S_year)==0,"",if(月份的变量>5," and XX ='"+S_year+"'"," and (XX='"+S_year+"' OR XX ='"+S_year-1+"'"))}
${if(s_month > 5 ,"and xx in ('"+S_year+"') " ,"and xx in ('"+S_year+"') or xx in ('"+S_year-1+"') ")}