Java实现MongoDB的日期（Date）分组功能

death114

public String getCTOStatistic() throws Exception {　　String ctoTaskType = getParameterValue("ctoTaskType").toString();
　　String startDate = getParameterValue("startDate").toString();
　　String endDate = getParameterValue("endDate").toString();
　　DBObject initial = new BasicDBObject();
　　DBObject index = new BasicDBObject();
　　BasicDBObject cond = new BasicDBObject();
　　BasicDBObject dateCondition = new BasicDBObject();
　　index.put("count", 0);
　　index.put("ctoPerson", "");
　　initial.put("ctoPerson", index);
　　cond.put("ctoStatus", "Finished");
　　if(StringUtils.isNotEmpty(ctoTaskType)){
　　cond.put("taskId", ctoTaskType);
　　}
　　if(StringUtils.isNotEmpty(startDate)){
　　dateCondition.append("$gte", DateUtil.toDate(startDate));
　　}
　　if(StringUtils.isNotEmpty(endDate)){
　　dateCondition.append("$lt", DateUtil.toDate(endDate));
　　}
　　cond.put("jobCreateTime",dateCondition);
　　String reduce = "function (doc, out) { "
　　+ " out.ctoPerson.count = out.ctoPerson.count+=1; "
　　+ " out.ctoPerson.ctoPerson = doc.ctoPerson;"
　　+ "}";
　　BasicDBList group = (BasicDBList) ctoJobService.group(
　　new String[] { "ctoPerson"}, cond, initial, reduce, null);
　　this.jsonResult = group.toString();
　　return SUCCESS;
　　}