dwijitsolutions / laraadmin

LaraAdmin is a Open source Laravel Admin Panel / CMS which can be used as Admin Backend, Data Management Tool or CRM boilerplate for Laravel with features like Advanced CRUD Generation, Module Manager, Backups and many more.
http://laraadmin.com
MIT License
1.58k stars 537 forks source link

Model table within a different model #310

Open nickkecooper opened 5 years ago

nickkecooper commented 5 years ago

Hey guys I wanted to know if anyone could point me in the right direction to include a table from one model into another. So if I make a model that has a relationship to a customer and it has many I would like to phrase the table out with the ones that compare to that user. I was able to get that information into it by `
$equipment = DB::table('equipment')->where('customer', '=', $customer['id'])->get();

    <table id="example1" class="table table-bordered">
    <thead>
    <tr class="success">
        @foreach( $equipment as $col )
        <th>{{ $col->type }}</th>
        @endforeach

        <th>Actions</th>

    </tr>
    </thead>
    <tbody>

    </tbody>
    </table>

`

But this method seems to not work great. If the customer does not have a relation it will show blank rows in the table. The table also doesn't display the title of the rows of the table properly.

leopinzon commented 5 years ago

You can use the ORM relationships that's already built on Laravel: https://laravel.com/docs/5.3/eloquent-relationships

For your use case it will look something like:

@foreach( $customer->equipments as $e )
<th>{{ $e->type }}</th>
@endforeach

Hope it helps