database - all grouped retrieved rows are in the first month

Question

I am trying to group retrieved rows from database using by months laravel but all the rows are grouped on the the first month.

$data = Medicals::join("patient_referral", "medicals.trx_id", "=", "patient_referral.trx_id")
    ->where(function ($q) use ($startdate, $enddate) {
        $q->whereBetween('medicals.created_at', [$startdate, $enddate])->get();
    })
    ->leftJoin("patients", "medicals.patients_id", "=", "patients.id")
    ->join("tests", "medicals.tests_id", "=", "tests.id")
    ->get()
    ->groupBy(function (Medicals $item) {
        return Carbon::parse($item->creted_at)->format('m');;
    });

Output

Database (Medicals table)

Please help!!!

question from:https://stackoverflow.com/questions/65909846/all-grouped-retrieved-rows-are-in-the-first-month

Answer 1

You are joining multiple tables. By default, all fields/columns from those tables will be included. We don't really know what created_at field from which table is used.

Medicals::join("patient_referral", "medicals.trx_id", "=", "patient_referral.trx_id")
    ->where(function ($q) use ($startdate, $enddate) {
        $q->whereBetween('medicals.created_at', [$startdate, $enddate])->get();
    })
    // I select all fields from medicals table. You might want to update this later.
    ->selectRaw('medicals.*')
    ->leftJoin("patients", "medicals.patients_id", "=", "patients.id")
    ->join("tests", "medicals.tests_id", "=", "tests.id")
    ->get()
    ->groupBy(function (Medicals $item) {
        return Carbon::parse($item->created_at)->format('m');;
    });