数据统计，包括mysql和MongoDB

select ct.dt, COUNT(DISTINCT c.id)
from tms_service_customer c, tms_dispatch_details d, (select DISTINCT FROM_UNIXTIME(c.create_time/1000,'%Y%m') as dt from tms_service_customer c
where FROM_UNIXTIME(c.create_time/1000,'%Y%m') BETWEEN '201803' and '201804') ct
where FROM_UNIXTIME(c.create_time/1000,'%Y%m') <= ct.dt
and c.id = d.consigner_id
GROUP BY ct.dt;

 

select ct.dt, COUNT(DISTINCT c.id)
from tms_service_customer c, tms_dispatch_details d, (select DISTINCT FROM_UNIXTIME(c.create_time/1000,'%Y%m') as dt from tms_service_customer c
where FROM_UNIXTIME(c.create_time/1000,'%Y%m') BETWEEN '201803' and '201804') ct
where FROM_UNIXTIME(c.create_time/1000,'%Y%m') <= ct.dt
and c.id = d.receive_id
GROUP BY ct.dt;

 

db.dispatch.group({
keyf : function(doc){
var date = new Date(doc.orderCreateTime);
var dateKey = ""+date.getFullYear()+"-"+(date.getMonth()+1);
return {'year':dateKey};
},
initial : {"collectionPayment":0, "transportCharge" : 0, "count":0},
reduce : function Reduce(doc, out) {
if(doc.collectionPayment){
out.collectionPayment += Number(doc.collectionPayment);
}
if(doc.transportCharge){
out.transportCharge += Number(doc.transportCharge);
}
out.count++;
}
});