Laravel livewire How to merge multiple rows with single row and display result

Question

I'm new for laravel I tried some eloquent collections but not get required result help me to solve. I have data like this TABLE NAME (attendance):

id  |     name      |student_id   |  date_of_attendance |   attendance |
1   |    john       |    STD_01   |     2024-01-01      |       P      |
2   |    john       |    STD_01   |     2024-01-02      |       P      |
3   |    sean       |    STD_02   |     2024-01-01      |       P      |
4   |    sean       |    STD_02   |     2024-01-02      |       A      |

How to merge it to become like this? I want to show only one rows of each student in the views.

livewire controller code

$this->StudenAttendance = Attendance::get();

Jon White · Accepted Answer · 2024-01-12 08:49:28Z

1

I think the simplest approach would be to use the Eloquent Collection's groupBy method.

Your call to the model to get attendance returns an Eloquent Collection

$this->StudenAttendance = Attendance::get();

You can simply chain on groupBy('student_id') which will turn your student attendance collection into a collection for each student. Then you can create your table rows by looping through each student and putting the attendance for each date into your table.

See docs: https://laravel.com/docs/10.x/collections#method-groupby

answered Jan 12, 2024 at 8:49

Jon White

1,0206 silver badges15 bronze badges

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

3 Comments

Ramu Ramu Over a year ago

can you post your answer what you telling for better understanding

Ramu Ramu Over a year ago

I Googled this same problem, thay used left join, I tried to integrate with my code but I failed. If you have any idea using left joint please share code, and which one better according you groupBy or left join

Jon White Over a year ago

You could do the same with a join but the groupBy method on the collection would be simpler. The documentation tells you how to apply the groupBy method, if you need to see what the result looks like, you can make use of the dump() and dd() methods

Collectives™ on Stack Overflow

Laravel livewire How to merge multiple rows with single row and display result

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related