How to enable relationship function in free version?

[YaffarOmarOZIL]

Hi, I would like to ask if it is not a bother.
I am working with the free version and I would like to know if there is a way to place the view or how the relationships work when adding items. I am leaving a photo of the demo to show what it is:

I tried to replicate it but even with all the configuration I only get this with my table:

The table fields don't appear, not even the button to add a new item :(

I leave the code here to see if something is wrong with it, or if I should put something else, or if it is simply a PRO function with the relationship

VentaCrudController.php

<?php

namespace App\Http\Controllers\Admin;

use App\Http\Requests\VentaRequest;
use Backpack\CRUD\app\Http\Controllers\CrudController;
use Backpack\CRUD\app\Library\CrudPanel\CrudPanelFacade as CRUD;

/**
 * Class VentaCrudController
 * @package App\Http\Controllers\Admin
 * @property-read \Backpack\CRUD\app\Library\CrudPanel\CrudPanel $crud
 */
class VentaCrudController extends CrudController
{
    use \Backpack\CRUD\app\Http\Controllers\Operations\ListOperation;
    use \Backpack\CRUD\app\Http\Controllers\Operations\CreateOperation;
    use \Backpack\CRUD\app\Http\Controllers\Operations\UpdateOperation;
    use \Backpack\CRUD\app\Http\Controllers\Operations\DeleteOperation;
    use \Backpack\CRUD\app\Http\Controllers\Operations\ShowOperation;

    /**
     * Configure the CrudPanel object. Apply settings to all operations.
     * 
     * @return void
     */
    public function setup()
    {
        CRUD::setModel(\App\Models\Venta::class);
        CRUD::setRoute(config('backpack.base.route_prefix') . '/venta');
        CRUD::setEntityNameStrings('venta', 'ventas');
    }

    /**
     * Define what happens when the List operation is loaded.
     * 
     * @see  https://backpackforlaravel.com/docs/crud-operation-list-entries
     * @return void
     */
    protected function setupListOperation()
    {
        //CRUD::setFromDb(); // set columns from db columns.
        // Columna para mostrar el nombre del cliente en lugar del ID
        CRUD::column([
            'name'      => 'cliente_id', // Columna en la base de datos
            'label'     => 'Cliente', // Encabezado en la tabla
            'type'      => 'select', // Tipo de columna para relaciones
            'entity'    => 'cliente', // Nombre de la relación en el modelo
            'attribute' => 'nombre', // Atributo que quieres mostrar en la lista (nombre del cliente)
            'model'     => 'App\\Models\\Cliente', // Modelo relacionado
        ]);
        CRUD::column([
            'name'  => 'fecha',
            'label' => 'Fecha de Venta',
            'type'  => 'datetime',
        ]);

        CRUD::column([
            'name'     => 'total',
            'label'    => 'Total',
            'type'     => 'number',
            'prefix'   => 'Bs', // Símbolo de moneda
            'decimals' => 2,   // Número de decimales
        ]);
        /**
         * Columns can be defined using the fluent syntax:
         * - CRUD::column('price')->type('number');
         */
    }

    /**
     * Define what happens when the Create operation is loaded.
     * 
     * @see https://backpackforlaravel.com/docs/crud-operation-create
     * @return void
     */
    protected function setupCreateOperation()
    {
        CRUD::setValidation(VentaRequest::class);
        //CRUD::setFromDb(); // set fields from db columns.
        CRUD::setOperationSetting('contentClass', 'col-md-12');
        // Cliente
        CRUD::field([
            'name'        => 'cliente_id',
            'label'       => 'Cliente',
            'type'        => 'select',
            'entity'      => 'cliente',
            'attribute'   => 'nombre',
            'model'       => 'App\\Models\\Cliente',
            'placeholder' => 'Selecciona un cliente',
            'options'     => (function ($query) {
                return $query->orderBy('nombre', 'ASC')->get();
            }),
        ]);

        // Fecha de la Venta
        CRUD::field([
            'name'    => 'fecha',
            'label'   => 'Fecha de Venta',
            'type'    => 'datetime',
            'default' => now(),
        ]);

        // Campo de solo lectura para el Total de la Venta
        CRUD::field([
            'name'        => 'total',
            'label'       => 'Total',
            'type'        => 'number',
            //'attributes'  => ['readonly' => 'readonly'],
            'prefix'      => 'Bs',
        ]);

        // Detalles de la Venta usando 'detalleventas' con subcampos
        CRUD::field('detalleventas')->subfields([
            [
                'name'    => 'montura_id',
                'label'   => 'Montura',
                'type'    => 'select',
                'entity'  => 'montura',
                'attribute' => 'modelo',
                'model'   => 'App\\Models\\Montura',
                'wrapper' => ['class' => 'form-group col-md-3'],
            ],
            [
                'name'    => 'lente_id',
                'label'   => 'Lente',
                'type'    => 'select',
                'entity'  => 'lente',
                'attribute' => 'tipo',
                'model'   => 'App\\Models\\Lente',
                'wrapper' => ['class' => 'form-group col-md-3'],
            ],
            [
                'name'       => 'cantidad',
                'label'      => 'Cantidad',
                'type'       => 'number',
                'wrapper'    => ['class' => 'form-group col-md-2'],
                'attributes' => ['step' => 1, 'min' => 1],
            ],
            [
                'name'       => 'precio_unitario',
                'label'      => 'Precio Unitario',
                'type'       => 'number',
                'prefix'     => 'Bs',
                'decimals'   => 2,
                'wrapper'    => ['class' => 'form-group col-md-2'],
                'attributes' => ['step' => 0.01, 'min' => 0],
            ],
        ])->reorder('order')->label('Detalles de la Venta')->hint('Agrega varios detalles a la venta.');
    }

    /**
     * Define what happens when the Update operation is loaded.
     * 
     * @see https://backpackforlaravel.com/docs/crud-operation-update
     * @return void
     */
    protected function setupUpdateOperation()
    {
        $this->setupCreateOperation();
    }
}

Model - Venta.php

<?php

namespace App\Models;

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

class Venta extends Model
{
    use CrudTrait;
    use HasFactory;
    protected $fillable = ['cliente_id', 'fecha', 'total'];
    public function cliente()
    {
        return $this->belongsTo(Cliente::class);
    }
    // Relación con el modelo Detalleventa
    public function detalleventas()
    {
        return $this->hasMany(Detalleventa::class);
    }
}

Model - Detalleventa.php

<?php

namespace App\Models;

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

class Detalleventa extends Model
{
    use CrudTrait;
    use HasFactory;
    protected $fillable = ['venta_id', 'montura_id', 'lente_id', 'cantidad', 'precio_unitario'];

    public function venta()
    {
        return $this->belongsTo(Venta::class, 'id');
    }

    // Relación con el modelo Montura
    public function montura()
    {
        return $this->belongsTo(Montura::class);
    }

    // Relación con el modelo Lente
    public function lente()
    {
        return $this->belongsTo(Lente::class);
    }
}

Migrations

Ventas

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('ventas', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->foreignId('cliente_id')->constrained('clientes');
            $table->timestamp('fecha')->useCurrent(); // Usar CURRENT_TIMESTAMP sin DB::raw
            $table->decimal('total', 10, 2);
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::dropIfExists('ventas');
    }
};

Detalle Ventas

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('detalles_ventas', function (Blueprint $table) {
            $table->id(); // Crea el campo 'id' con incremento automático
            $table->foreignId('venta_id')->constrained('ventas'); // Llave foránea a 'ventas'
            $table->foreignId('montura_id')->constrained('monturas'); // Llave foránea a 'monturas'
            $table->foreignId('lente_id')->constrained('lentes'); // Llave foránea a 'lentes'
            $table->integer('cantidad'); // Campo para la cantidad
            $table->decimal('precio_unitario', 10, 2); // Campo para el precio unitario
            $table->timestamps(); // Campos para 'created_at' y 'updated_at'
        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::dropIfExists('detalleventas');
    }
};

I think that would be all, as I mentioned from what I saw, the 2 options that there are would be the "relationship" and the "repeater" and they are PRO functions if I'm not mistaken or should I import something? If so, would there be a free alternative? I apologize in advance also for my knowledge, is not so extensive and I am just getting familiar with the use of backpack :3

[jcastroa87]

Hello @YaffarOmarOZIL

As you say, the "relationship" and the "repeatable" are field from the PRO package, there is no way you can use this amazing fields without a license.

The only small alternative to try to do something similar will be using custom_html and Javascript API, but will take a lot of time and effort and maybe will not be possible to replicate everything.

The PRO package will save you a lot of time and effort.

Cheers.

[YaffarOmarOZIL]

Oh it's okay, thank you very much for the info :3

[jcastroa87]

Super great news @YaffarOmarOZIL we have Black Week DISCOUNTS so hurry up if you need any feature of pro package :)