有分页、有计算、有排序
db.app_task.aggregate([
{
$match:{ "user_code" : "UID2020200646361111", "statistics_time" : { "$gte" : 0, "$lt" : 1660990400000}}
},
{ "$addFields" : { "number" : {$add:["$calls_length",{$multiply:["$calls_count",4]}]}}},
{
"$group" : { "_id" : "$staff_code", "staffCode" : { "$first" : "$staff_code"}, "m_index" : { "$first" : "$number"}, "value" : { "$sum" : "$calls_length"}}
},
{
"$sort" : { "m_index" : -1, "staffCode" : -1}
},
{ "$skip" : 0},
{ "$limit" : 10255}
])