统计图最近6个月的数据
@Override
public R getOrderDurationChart() {
StatisticsMainModel m= baseMapper.getOrderChart();
Map[] s1=new HashMap[6];
String[] time=new String[6];
Date date=new Date();
Calendar calendar=new GregorianCalendar();
for(int i=0;i<6;i++) {
calendar.setTime(date);
calendar.add(calendar.MONTH,-i);
try {
String dateTime=(calendar.get(Calendar.YEAR))+"-"+(calendar.get(Calendar.MONTH)+1);
SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM");
String sfDate =sf.format(sf.parse(dateTime)) ;//格式化后的时间
time[i]=sfDate;
s1[i]=baseMapper.getOrderStatus(sfDate);
} catch (ParseException e) {
e.printStackTrace();
}
}
m.setChartDate(time);
m.setChartData(s1);
return R.ok(m);
}
数据结构如图