How to find the amount by a unique value (date and id) in the database?

Question

Laravel

I need to find the amount for each day in the database by date and unique id.

Here is my code, but I can't figure out how to find the sum by date, for each day.

$data = HistoryWeightRecord::get();

$date = [];

foreach ($data as $allDate) {
    $date[] = Carbon::parse($allDate->datetime)->format('Y-m-d');
}

$uniqueDate = collect($date)->unique();

$uniqueEquipment = $data->unique('equipment_id');

$sumArr = [];

foreach ($uniqueEquipment as $eqId) {

    foreach ($uniqueDate as $day) {
        $sum = HistoryWeightRecord::whereDate('datetime', $day)->sum('mass');
        $sumArr[$eqId->equipment_id] = $sum;
    }
}

I want to get this result

$arr = [
            '122' => [
                '2021-01-08' => 207,6
            ],
            '123' => [
                '2021-01-08' => 434,6,
                '2021-01-09' => 233,6,
                '2021-01-10' => 523,6,
            ]
        ];

Answer 1

Understood.

$data = HistoryWeightRecord::get();

        $date = [];
        foreach ($data as $allDate) {
            $date[] = Carbon::parse($allDate->datetime)->format('Y-m-d');
        }
        $uniqueDate = collect($date)->unique();

        $uniqueEquipment = $data->unique('equipment_id');

        $sumArr = [];
        foreach ($uniqueEquipment as $eqId) {
            foreach ($uniqueDate as $day) {
                $sum = HistoryWeightRecord::whereDate('datetime', $day)->where('equipment_id', $eqId->equipment_id)->sum('mass');
                $sumArr[$eqId->equipment_id][$day] = $sum;
            };
        }
        return $sumArr;