匹配和按日期分组

Question

I have a mysql query, need to convert into mongodb for latest version Driver\Manager mongodb.so using php executeCommand or executeQuery.

SELECT created_time, count(id) AS total
FROM `tweets`
WHERE created_time >= (NOW() - INTERVAL 10 DAY) AND active = 1 
GROUP BY DATE(created_time)

Tried so far is:

$manager = new MongoDB\Driver\Manager("mongodb://".$_SERVER['HTTP_HOST'].":27017");
    $cond = [ 'created_time' => ['$gte' => '(NOW() - INTERVAL 10 DAY'], 'active' => 1 ];
    $command = new MongoDB\Driver\Command([
        'aggregate' => 'collection_name',
        'pipeline' => [
            ['$match' => $cond],
            ['$group' => ['_id' => '$created_time', 'total' => ['$sum' => '$_id']]],
        ],
        'cursor' => new stdClass,
    ]);
    $cursor = $manager->executeCommand('db_name', $command);
    $result = array();
    foreach ($cursor as $document) {
        $result[] = $document;
    }

Answer 1

You are close.

Update your $cond with below. Rest looks fine.

$date = new DateTime();
$date->sub(new DateInterval('P10D'));
$cond = [ 'created_time' => ['$gte' => $date], 'active' => 1 ];             

Update grouping key _id to include date part only.

['$dateToString' => ['format' => "%Y-%m-%d", 'date' => '$created_time']]