SELECT

 ifnull(sys_com.org_name,'未填写责任单位') as 单位,

 vehicle_type_name as 车型,

 SUM(case when DATE_FORMAT(vr.reshipment_date, '%Y-%m')='${format(years,"yyyy-MM")}' then vr.total_reshipment end ) AS '本月运输量',

 SUM(case when DATE_FORMAT(vr.reshipment_date, '%Y-%m')='${format(YEARDELTA(years,-1),'yyyy-MM')}' then vr.total_reshipment end ) AS '同期运输量',

 SUM(case when DATE_FORMAT(vr.reshipment_date, '%Y-%m')<='${format(years,"yyyy-MM")}' and year(vr.reshipment_date)='${year(years)}' then vr.total_reshipment end ) AS '本年累计运输量',

 SUM(case when DATE_FORMAT(vr.reshipment_date, '%Y-%m')='${format(years,"yyyy-MM")}' then vr.run_mile end ) AS '本月行驶里程',

 SUM(case when DATE_FORMAT(vr.reshipment_date, '%Y-%m')='${format(YEARDELTA(years,-1),'yyyy-MM')}' then vr.run_mile end ) AS '同期行驶里程',

 SUM(case when DATE_FORMAT(vr.reshipment_date, '%Y-%m')<='${format(years,"yyyy-MM")}' and year(vr.reshipment_date)='${year(years)}' then vr.run_mile end ) AS '本年行驶里程',

 SUM(case when DATE_FORMAT(vr.reshipment_date, '%Y-%m')='${format(years,"yyyy-MM")}' then vr.turnover end ) AS '本月周转量',

 SUM(case when DATE_FORMAT(vr.reshipment_date, '%Y-%m')='${format(YEARDELTA(years,-1),'yyyy-MM')}' then vr.turnover end ) AS '同期周转量',

 SUM(case when DATE_FORMAT(vr.reshipment_date, '%Y-%m')<='${format(years,"yyyy-MM")}' and year(vr.reshipment_date)='${year(years)}' then vr.turnover end ) AS '本年周转量'

 FROM vehicle_material_reshipment vr

 LEFT JOIN sys_company sys_com ON vr.org_id = sys_com.org_id 

 left join (SELECT vehicle_id,vehicle_license,vehicle_type_name 

FROM vehicle_info a left join vehicle_type b on a.vehicle_type_code=b.vehicle_type_code) b ON vr.vehicle_id=b.vehicle_id

where vr.deleted !=1

 AND 1=1 ${IF(len(org_name)=0,'',"AND sys_com.org_name in ('"+org_name+"')")}

GROUP BY sys_com.org_name,vehicle_type_name

order by org_name desc,vehicle_type_name

就比如说我要查询7月份的数据  就是从6月29日---7月28日