db.msds_accessrecord.group({
keyf : function(doc){
var date = new Date(doc.addtime);
var dateKey = ""+date.getFullYear()+"-"+(date.getMonth()
+1)+"-"+date.getDate();
return {'day':dateKey}; //33
},
initial : {"count":0},
reduce : function Reduce(doc, out) {
if(doc.url){
out.count +=1;
}
}
});
DBObject condition = new BasicDBObject();
BasicDBObject dateCondition = new
BasicDBObject();
if (null != qudaoID&&""!=qudaoID) {
condition.put("user.clientFrom", new
BasicDBObject("$eq", qudaoID));
}
dateCondition.append("$gte", cdate_begin);
dateCondition.append("$lte", cdate_end);
condition.put("createtime", dateCondition);
condition.put("bsData.from", "hotNews");
DBObject initial = new BasicDBObject();
initial.put("count", 0);
String reduce = "function (doc, out) { " +
"if(doc.createtime){"
+ " out.count +=1; " + "}" + "}";
String keyf;
keyf = "function(doc){"
+ "var date =
doc.createtime.substr(0,10);"
+ "var code=doc.user.clientFrom;"
+ " var
chanelCode=doc.bsData.chanelCode;"
+ " return
{'createtime':date,'user.clientFrom':code,'bsData.chanelCode':chan
elCode};"
+ "}";
String jsonStr = MongoDBUtil.getInstance().keyfGroup(keyf,
condition,
评论0