Laravel : How to get object in column with query builder

Question

I want to display what kind of data I have described below, but I don't know the keywords.

For now, this is my data:

And this is the result I want:

This is, my controller:

$data = DB::table('tr_doctor_schedules as sch')
    ->select('sch.id as schedule_id','doctor_name','hospital_name','estimated_practice_time','day','from_time','until_time')
    ->join('mst_hospitals as hos', 'hos.id', '=', 'sch.hospital_id')
    ->join('mst_doctors as doc', 'doc.id', '=', 'sch.doctor_id')
    ->join('tr_doctor_schedule_details as dtl', 'dtl.doctor_schedule_id', '=', 'sch.id')
    ->where('sch.hospital_id', $hosId)
    ->where('sch.doctor_id', $docId)
    ->first();

if ($data) {
    return response()->json([
        'success' => true,
        'message' =>'success',
        'data'    => $data
    ], 200);
} else {
    return response()->json([
        'success' => false,
        'message' => 'Data not found.',
    ], 400);
}

Thanks

why the from time is 8 not 9, and until time is 18 not 19 , is there a logic for it? — Andy Song
– Andy Song, Commented Aug 31, 2020 at 5:29
from line 9 to the end, no logic there, but I just added the response too — Fenz
– Fenz, Commented Aug 31, 2020 at 6:47

Zar Ni Ko Ko · Accepted Answer · 2020-08-31 05:30:15Z

1

Try this

   $data = DB::table('tr_doctor_schedules as sch')
        ->selectRaw('sch.id as schedule_id,doctor_name,hospital_name,estimated_practice_time,GROUP_CONCAT(day) as day,from_time,until_time')
        ->join('mst_hospitals as hos', 'hos.id', '=', 'sch.hospital_id')
        ->join('mst_doctors as doc', 'doc.id', '=', 'sch.doctor_id')
        ->join('tr_doctor_schedule_details as dtl', 'dtl.doctor_schedule_id', '=', 'sch.id')
        ->where('sch.hospital_id', $hosId)
        ->where('sch.doctor_id', $docId)
        ->groupBy('sch.id')
        ->first();

answered Aug 31, 2020 at 5:30

Zar Ni Ko Ko

3522 silver badges7 bronze badges

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

2 Comments

Fenz Over a year ago

thanks a lot, its solved. In postgres i used array_agg()

Zar Ni Ko Ko Over a year ago

yeah .. my pleasure

Collectives™ on Stack Overflow

Laravel : How to get object in column with query builder

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related