laravel - How to group retrieved rows by months?

Question

I working on an app that involves grouping selected rows by month. How do I go about it?

  $data = Medicals::where("patient_referral.referred_by", "like", "%" .  $searchitem . "%")
        ->leftJoin("patients", "medicals.patients_id", "=", "patients.id")
        ->join("patient_referral", "medicals.trx_id", "=", "patient_referral.trx_id")
        ->join("tests", "medicals.tests_id", "=", "tests.id")
        ->groupBy(function (Medicals $item) {
            return $item->created_at->format('Y-m');
        })
        ->get();

This is the error am getting

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

question from:https://stackoverflow.com/questions/65898309/how-to-group-retrieved-rows-by-months

Answer 1

The way you are calling groupBy is for Collections, not a query. You need to move that groupBy after the get so you are trying to group the resulting Collection.

    ...
    ->get()
    ->groupBy(function ($item) {
        return $item->created_at->format('Y-m');
    });