查询近半年前订单

来源：互联网发布：统计图用什么呈现数据编辑：程序博客网时间：2024/04/29 07:20

前台点击：

相应事件：

function tianshu(timestamp) {

window.location.href = "${app('Regist.Publish.URL')}myCapital.ftl?timestamp="+timestamp;

}

后台代码：

public String myCapital(){

init();

String userName = user.getUserName();

try {

//排序

LinkedHashMap<String,String> orderby = new LinkedHashMap<String,String>();

orderby.put("collectionTime", "desc");

//获取前台参数

// timestamp = this.getRequest().getParameter("timestamp");

if (timestamp != null && !"".equals(timestamp)) {

// 时间段查询处理(这里是按照collectionTime匹配时间段)

DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm");

Calendar theCa = Calendar.getInstance();

theCa.setTime(new Date());

String str = "";

if (timestamp.equals("aa")) {// 查询近30天的

theCa.add(theCa.DATE, -30);

}

if (timestamp.equals("bb")) {//查询近60天的

theCa.add(theCa.DATE, -(30 * 2));

}

if (timestamp.equals("cc")) {// 查询近6个月的

theCa.add(theCa.DATE, -(30 * 6));

}

if (timestamp.equals("dd")) {// 查询超过6个月的

theCa.add(theCa.DATE, -(30 * 6));

}

Date date = theCa.getTime();

str = df.format(date);

if(timestamp.equals("dd")){//查询六个月之前订单

qr =tradeOrderService.getPagerByHql(" from TTradeOrder o where o.companyAccount=? and o.collectionState= 1 and collectionTime<?", new Object[]{userName,DateUtil.parseDateTime(str, "yyyy-MM-dd HH:mm")}, qr.getCurrentPage(), qr.getPageSize(), orderby);

}else if(timestamp.equals("aa")||timestamp.equals("bb")||timestamp.equals("cc")){//近六个月

qr =tradeOrderService.getPagerByHql(" from TTradeOrder o where o.companyAccount=? and o.collectionState= 1 and collectionTime>=?", new Object[]{userName,DateUtil.parseDateTime(str, "yyyy-MM-dd HH:mm")}, qr.getCurrentPage(), qr.getPageSize(), orderby);

}

} else {

qr = tradeOrderService.getPagerByHql(" from TTradeOrder o where o.companyAccount=? and o.collectionState= 1 ", new Object[] {userName}, qr.getCurrentPage(), qr.getPageSize(), orderby);

}

} catch (Exception e) {

e.printStackTrace();

LogUtil.error("EmissionOrderAction==>myCapital()" + e);

}

return "myCapital";

}

0 0