where 1=1 ${if(day(pdate)>=25," and 字段>='"+FORMAT(pdate,"yyyy-MM-25")+"' and 字段<'"+FORMAT(MONTHDELTA(pdate,1),"yyyy-MM-26")+"'"," and 字段>='"+FORMAT(MONTHDELTA(pdate,-1),"yyyy-MM-25")+"' and 字段<='"+FORMAT(pdate,"yyyy-MM-24")+"'")}
帆软用户W0HmaWtan0(提问者)SELECT
r.`name` as 指标名称,
d.report_date as 日期,
r.level_type as 级别,
SUM(d.result_value) as 结果
FROM
report_data d
LEFT JOIN report_indicator r ON r.id = d.report_indicator_id
WHERE
1=1
${if(day(pdate)>=25," and d.report_date>='"+FORMAT(pdate,"yyyy-MM-25")+"' and d.report_date='"+FORMAT(MONTHDELTA(pdate,-1),"yyyy-MM-25")+"' and d.report_date<'"+pdate+"'")}
AND r.date_type = '1'
AND r.value_type = '0'
AND r.data_type = '10'
GROUP BY
r.`name`,
r.level_type,
d.report_date