mirror of
https://github.com/openmhz/trunk-server.git
synced 2026-11-09 15:27:30 -05:00
29 lines
556 B
JavaScript
29 lines
556 B
JavaScript
db = db.getMongo().getDB( "scanner" );
|
|
var results = db.calls.aggregate(
|
|
[ {
|
|
$project: {
|
|
len: true,
|
|
year: {$year: "$time"},
|
|
month: {$month: "$time"},
|
|
dayOfMonth: {$dayOfMonth: "$time"}
|
|
}
|
|
},
|
|
{
|
|
$group:
|
|
{
|
|
_id: {
|
|
year: '$year',
|
|
month: '$month',
|
|
dayOfMonth: '$dayOfMonth'
|
|
},
|
|
totalAudio: { $sum: "$len" },
|
|
count: { $sum: 1 }
|
|
}
|
|
}
|
|
]
|
|
)
|
|
|
|
results.forEach(function(document) {
|
|
printjson(document);
|
|
});
|