背景:1.当mendian参数为空的时候,如果参数yuefen也为空,返回《"group by left(年月,4),一级,价格段"》,参数yuefen不为空,返回《"group by left(年月,7),一级,价格段"》2.当mendian参数不为空的时候,如果参数yuefen为空,返回《"group by left(年月,4),门店,一级,价格段"》,参数yuefen不为空,返回《"group by left(年月,7),门店,一级,价格段"》完整SQL:select ${if(len(mendian) == 0,if(len(yuefen) == 0,"left(年月,4) 时间,一级,价格段,","left(年月,7) 时间,一级,价格段,"),if(len(yuefen) == 0,"left(年月,4) 时间,门店,一级,价格段,","left(年月,7) 时间,门店,一级,价格段,"))} sum(销售收入)/10000 销售收入, sum(销售成本)/10000 销售成本, sum(销售毛利)/10000 销售毛利, sum(优惠金额)/10000 优惠金额from dw_品类价格段数据where left(年月,4)='${shijian}' and 一级='${pinlei}'${if(len(yuefen) == 0,"","and right(年月,2) in ('" + yuefen + "')")}${if(len(mendian) == 0,"","and 门店 in ('" + mendian + "')")}${if(len(jiageduan) == 0,"","and 价格段 in ('" + jiageduan + "')")}${if(len(mendian) == 0,if(len(yuefen) == 0,"group by left(年月,4),一级,价格段","group by left(年月,7),一级,价格段"),if(len(yuefen) == 0,"group by left(年月,4),门店,一级,价格段"),"group by left(年月,7),门店,一级,价格段"))}