I want to show the child Model items inside the Parent setupShowOperation()

[andresrl]

This is My Parent Model

Order.php

namespace App\Models;

use Backpack\CRUD\app\Models\Traits\CrudTrait;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

use Illuminate\Support\Str;

use App\Http\Controllers\Orders\OrderController;

class Order extends Model
{
    use CrudTrait;
    use HasFactory;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'order_number',
        'event_id',
        'event_name',
    ];

    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'id' => 'integer',
        'event_id' => 'integer',
    ];

     public function orderlines()
    {
        return $this->hasMany(OrderLine::class);
    }

    }
}

This is My Child Model
OrderLine.php

<?php

namespace App\Models;

use Backpack\CRUD\app\Models\Traits\CrudTrait;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class OrderLine extends Model
{
    use CrudTrait;
    use HasFactory;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'order_id',
        'event_product_id',
        'event_product_name',
        'price',
        'quantity',
    ];

    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'id' => 'integer',
        'order_id' => 'integer',
        'event_product_id' => 'integer',
        'price' => 'decimal:2',
    ];

    public function order()
    {
        return $this->belongsTo(Order::class);
    }
}

I wanted to show the OrderLine Items that are related to an Order inside the setupShowOperation()

I'm doing like This

<?php
...
protected function setupShowOperation()
    {
        $this->crud->set('show.setFromDb', false);
        // Aquí se definen las columnas que se mostrarán en el show view para el modelo Order
        CRUD::column('order_number')->label('Número de Pedido');
        CRUD::column('event_name')->label('Nombre Evento');
        
        // Agregamos una columna personalizada para mostrar las líneas de pedido
        CRUD::addColumn([
            'name' => 'orderlines', // The db column name
            'label' => "Líneas de pedido", // Table column heading
            'type' => 'closure',
            'function' => function ($entry) {
                // Aquí puedes retornar cualquier HTML válido que quieras mostrar
                return view('admin.order-lines', ['orderlines' => $entry->orderlines]);
            },
        ]);
        $this->crud->setShowView('vendor.backpack.crud.orders.show');
    }

And in show.blade.php

@extends('crud::show')

@section('content')
<div class="row">
    <div class="col-md-12">
        @include('crud::inc.show_fields', ['fields' => $crud->columns()])
    </div>
</div>

<div class="row">
    <div class="col-md-12">
        <table class="table table-bordered table-striped">
            <thead>
                <tr>
                    <th>Product</th>
                    <th>Quantity</th>
                    <th>Price</th>
                    <th>Subtotal</th>
                    <th>Action</th>
                </tr>
            </thead>
            <tbody>
                @foreach ($orderlines as $orderline)
                    <tr>
                        <td>{{ $orderline->product->name }}</td>
                        <td>{{ $orderline->quantity }}</td>
                        <td>{{ $orderline->price }}</td>
                        <td>{{ $orderline->subtotal }}</td>
                        <td>
                            <a href="{{ route('orderline.edit', $orderline->id) }}" class="btn btn-xs btn-default"><i class="fa fa-edit"></i> Edit</a>
                        </td>
                    </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@endsection

But it shows me an ERROR 500
Cannot find 'closure' field view in any of the regular locations.

[christmex]

Hi @andresrl

This is my setupShowOperation inside my BookCrudController, so I have a book that has many locations, is that something you want to achieve? like my case, I show many locations from my BookCrudController?

[karandatwani92]

Duplicate of #605