Echart 作图java程序最近一周交易记录
直接上代码
//页面隐藏域获取后台controller传的值
页面js代码
页面完成
controller里的某方法的代码获取countsStr
以下是controller某方法
String countsStr = "";
Calendar calendar = Calendar.getInstance();
while (calendar.get(Calendar.DAY_OF_WEEK) != Calendar.MONDAY) {
calendar.add(Calendar.DAY_OF_WEEK, -1);
}
for (int i = 0; i < 7; i++) {
String dateStr = sff.format(calendar.getTime());
Integer count = Db.queryInt("SELECT COUNT(id) FROM shop_order WHERE createDate>='"+dateStr
+" 00:00:00' AND createDate<='"+dateStr+" 23:59:59' AND status!='"+CommonAttribute.ORDER_STATUS_CANCELED
+"'");
count += Db.queryInt("SELECT COUNT(id) FROM shop_pointorder WHERE createDate>='"+dateStr+"
00:00:00' AND createDate<='"+dateStr+" 23:59:59' AND status!='"+CommonAttribute.ORDER_STATUS_CANCELED+"'");
if("".equals(countsStr)){
countsStr = count.toString();
}else{
countsStr += ","+count.toString();
}
calendar.add(Calendar.DATE, 1);
}
setAttr("countsStr", countsStr);//把数据返回页面