qq已沟通解决；

${IF(DAY(endtime)>7,

"

SELECT a.city_new,COUNT(a.id) amount

FROM `fact_gongdan_outlets` a 

WHERE 1=1 ${IF(len(city) == 0,"","and a.city_new in ('" + city + "')")}

AND a.create_date>= '"+ DATEINMONTH(endtime,1) +"'

AND a.create_date<= '"+ DATEDELTA(endtime,-7)+"'

"+if(len(city)==0,"","and a.city in ('" + city + "')")+"

AND a.state!='confirmed_done'

AND a.wancheng_time<=168

AND a.`city_new` IS NOT NULL

GROUP BY a.city_new

UNION ALL

SELECT '全国',COUNT(a.id) amount

FROM `fact_gongdan_outlets` a 

WHERE a.create_date>='"+ DATEINMONTH(endtime,1) +"'

AND a.create_date<='"+ DATEDELTA(endtime,-7)+"'

"+if(len(city)==0,"","and a.city in ('" + city + "')")+"

AND a.state='confirmed_done'

AND a.wancheng_time<=168

AND a.`city_new` IS NOT NULL

",

"

SELECT a.city_new,COUNT(a.id) amount

FROM `fact_gongdan_outlets` a 

WHERE 1=1 ${IF(len(city) == 0,"","and a.city_new in ('" + city + "')")}

AND a.create_date>= '"+ DATEINMONTH(MONTHDELTA(endtime,-1),1) +"'

AND a.create_date<= '"+ DATEDELTA(endtime,-7) +"'

"+if(len(city)==0,"","and a.city in ('" + city + "')")+"

AND a.state='confirmed_done'

AND a.wancheng_time<=168

AND a.`city_new` IS NOT NULL

GROUP BY a.city_new

UNION ALL

SELECT '全国',COUNT(a.id) amount

FROM `fact_gongdan_outlets` a 

WHERE a.create_date>= '"+ DATEINMONTH(MONTHDELTA(endtime,-1),1) +"'

AND a.create_date<= '"+ DATEDELTA(endtime,-7) +"'

"+if(len(city)==0,"","and a.city in ('" + city + "')")+"

AND a.state='confirmed_done'

AND a.wancheng_time<=168

AND a.`city_new` IS NOT NULL

")}

用存储过程是否可以解决

把两个sql都整出来，做成两个数据集，然后再做成关联数据集，把当月天数做成参数（帆软内置公式好像有计算当前日期当前月天数的，没有就用公式读取数据集筛的结果），然后用参数绝对用哪个数据集