MongoDB Laravel - Group By

mdb_laravel_grouby.php

<?php

namespace App\Http\Controllers\Admin;

use App\Appointment;
use Carbon\Carbon;
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use MongoDB\BSON\UTCDateTime;

class DashboardController extends Controller
{
    public function chartAppointments(Request $request)
    {
        $startDate = Carbon::today()->startOfMonth();

        $appointments = Appointment::raw(function ($collection) use ($startDate) {
            return $collection->aggregate([
                [
                    '$match' => [
                        'created_at' => [
                            '$gte' => new UTCDateTime($startDate->timestamp * 1000)
                        ],
                    ]
                ],
                [
                    '$group' => [
//                        '_id' => [
//                            'month'  => ['$month' => '$created_at'],
//                            'day'    => ['$dayOfMonth' => '$created_at'],
//                            'year'   => ['$year' => '$created_at'],
//                        ],
                        '_id' => '$date',
                        'count' => [
                            '$sum' => 1
                        ]
                    ]
                ]
            ]);
        })->pluck('count', '_id');


        return $appointments;
    }

}