1,747
社区成员
发帖
与我相关
我的任务
分享
db.order_report.aggregate([{
"$match": {
"userId": 2
}
}, {
"$unwind": "$content"
}, {
"$project": {
"userId": 1,
"createTime": 1,
"content": [
{
"pageId": "$content.pageId",
"sop2": {
"send": {
"$sum": "$content.sop2.send"
},
"read": {
"$sum": "$content.sop2.read"
},
"delivery": {
"$sum": "$content.sop2.delivery"
},
"orderCount": {
"$sum": "$content.sop2.orderCount"
}
},
"workFlow": {
"send": {
"$sum": "$content.workFlow.send"
},
"read": {
"$sum": "$content.workFlow.read"
},
"delivery": {
"$sum": "$content.workFlow.delivery"
},
"orderCount": {
"$sum": "$content.workFlow.orderCount"
}
},
"broadcast": {
"send": {
"$sum": "$content.broadcast.send"
},
"read": {
"$sum": "$content.broadcast.read"
},
"delivery": {
"$sum": "$content.broadcast.delivery"
},
"orderCount": {
"$sum": "$content.broadcast.orderCount"
}
}
}
]
}
}, {
"$unwind": "$content"
}, {
"$group": {
"_id": {
"createTime": "$createTime",
"userId": "$userId"
},
"content": {
"$push": "$content"
},
}
}, {
"$project": {
"_id": false,
"userId": "$_id.userId",
"createTime": "$_id.createTime",
"content": "$content"
}
}])