How to get Laravel group array data total count?

Question

Hi, I am trying to get Laravel group array data total can anyone help me ?

controller code

public function last_10_days_reports()
    {
        $day_10 = Carbon::today()->subDays(10)->format('Y-m-d');
        $leads = Lead::whereDate('created_at', '>=', $day_10)
            ->get()
            ->sortBy('created_at')
            ->groupBy(function ($item) {
                return $item->created_at->format('Y-m-d');
            })->toArray();

        return $leads;
    }

I get like below screenshot data but I want to total array number. can anyone help me ?

http://prntscr.com/159d9fu

$leads = Lead::whereDate('created_at', '>=', $day_10)->groupBy('created_at') ->get() what about this — John Lobo
– John Lobo, Commented Jun 13, 2021 at 12:10
Do you need result, like ['2021-06-12' => 5, '2021-06-11' => 4, ...] ? — Andrew Markhai
– Andrew Markhai, Commented Jun 13, 2021 at 12:14

Andrew Markhai · Accepted Answer · 2021-06-13 12:28:29Z

2

Try this:

Lead::query()
            ->selectRaw('date(created_at) as date, count(*) as count')
            ->where('created_at', '>=', $day_10)
            ->orderByRaw('date(created_at)')
            ->groupByRaw('date(created_at)')
            ->get()
            ->pluck('count', 'date')
            ->toArray();

answered Jun 13, 2021 at 12:28

Andrew Markhai

1942 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get Laravel group array data total count?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related