php - How to create dynamic rowspan in table in laravel

Question

I am newbie in laravel, i'm trying to show the table like image below

https://i.stack.imgur.com/l52Vo.jpg

@foreach($report_data as $index => $item)
<tbody class="table-content">
    <tr>

        <td>{{ $index+1 }}</td>
        <td style="text-align:left;">{{ $item->customer_fullName }}</td>
        <td>{{ $item->customer_phone }}</td>
        <td>{{ $item->customer_detail_licensePlate }}</td>
        <td>{{ $item->vehicle_brand_name }}</td>
        <td>{{ $item->vehicle_model_name }}</td>

    </tr>
</tbody>
@endforeach

but the output is like image below https://i.stack.imgur.com/rSktI.png

Thanks!!

Answer 1

I would do it as so:

In the controller, select the customers eager loading the vehicles.

$customers = Customer::with('vehicles')->get();
return view('customers')->with('customers', $customers);

In the view:

<table>
    @foreach($customers as $index => $customer)
        <tr>
            <td rowspan="$customer->vehicles->count()">
               {{ $index+1 }}
            </td>
            <td rowspan="$customer->vehicles->count()">
               {{ $customer->fullName }}
            </td>
            <td rowspan="$customer->vehicles->count()">
               {{ $customer->phone }}
            </td>
            <td> {{$customer->vehicles[0]->licensePlate }} </td>
            <td> {{$customer->vehicles[0]->brandName }} </td>
            <td> {{$customer->vehicles[0]->modelName }} </td>
        </tr>
        @for($i=1;$i<$customer->vehicles->count())
        <tr>
            <td> {{$customer->vehicles[$i]->licensePlate }} </td>
            <td> {{$customer->vehicles[$i]->brandName }} </td>
            <td> {{$customer->vehicles[$i]->modelName }} </td>
        </tr>
        @endfor
    @endforeach
</table>