How to get the last record of a day of date range

$records = Traffic::whereDate('created_at', '>=', $startDate)->whereDate('created_at', '<=',         $endDate)->get()->groupBy(function($item) {
                    return $item->created_at->format('Y-m-d');
                })->toArray();
        

foreach ($records as $key => $record){
       $records[$key] = array_slice($record, -1);
}

It works very well with an array, but how to do the same with Object, not array ? Could you please advice how to pluck the last record for each day without conversion to an array.

I'm just trying to learn how to write code correctly to have it possible to get an Object in my View, but not as an array.

        $records = Traffic::whereDate('created_at', '>=', $startDate)->whereDate('created_at', '<=', $endDate)->get()->groupBy(function($item) {
        return $item->created_at->format('Y-m-d');
    });


        foreach ($records as $record){
            $arrayLength = count($record);
            $counter = 0;
            foreach ($record as $key => $item){
                $counter++;
                if ($counter != $arrayLength){
                    unset ($record[$key]);
                }
            }
        }

        $arrayResult = [];

        foreach ($records as $record){
            foreach ($record as $item){
                array_push($arrayResult, $item);
            }
        }

And now I send $arrayResult to my View.

Could you advise me how did the code should look like? This is confused me by this excessive rotation, and it seems that the code looks like a newbie code.

Could you tell me how to get these ids via Builder ?

$records = Traffic::select('created_at')->whereBetween('created_at', [$startDate, $endDate])->get()->groupBy(function($item) {
            return $item->created_at->format('Y-m-d');
        });

I tried like this, but have no idea how to get max id of each date

Try this:

Traffic::query()
            ->selectRaw('max(id) as id, created_at')
            ->whereBetween('created_at', ['2020-01-01', '2020-01-31'])
            ->groupBy('created_at')
            ->get()
			->pluck('id')
			->toArray()

It's just show me all 25 records of the table

array:25 [▼
  0 => 1
  1 => 2
  2 => 3
  3 => 4
  4 => 5
  5 => 6
  6 => 7
  7 => 8
  8 => 9
  9 => 10
  10 => 11
  11 => 12
  12 => 13
  13 => 15
  14 => 16
  15 => 17
  16 => 18
  17 => 19
  18 => 20
  19 => 21
  20 => 22
  21 => 23
  22 => 24
  23 => 25
  24 => 26
]

If I do groupBy with created_at->format('Y-m-d'), it shows me an error

ErrorException stripos() expects parameter 1 to be string, object given

in Query \ Grammars \ Grammar :1163

$records = Traffic::query()
            ->selectRaw('max(id) as id, created_at')
            ->whereBetween('created_at', [$startDate, $endDate])
            ->groupBy(function($item) {
                return $item->created_at->format('Y-m-d');
            })
            ->get()
            ->pluck('id')
            ->toArray();

Oh, yes, created_at is datetime, not date. Try casting:

Traffic::query()
            ->selectRaw('max(id) as id, CAST(created_at AS DATE) as date')
            ->whereBetween('created_at', ['2020-01-01', '2020-01-31'])
            ->groupByRaw('CAST(created_at AS DATE)')
            ->get()
            ->toArray();