One To Many (Latest)

[cheadevit]

Hello Guys.

I have a database that contains the table as below,

in case 1 Asset has many conditions, example asset_1 can have asset_con_1, asset_con_2, asset_con_3 and etc...
and the problem is when I tried to use the field type relationship, the field showed select2_muliple

here is the model function

public function conditionHasOne()
    {
        return $this->belongsToMany(Condition::class, 'asset_conditions', 'asset_id', 'condition_id')->orderBy('asset_conditions.id', 'desc')->limit(1)->withTimestamps();
    }

here is the field in the update operation

$this->crud->addField([
            'label'     => 'Condition',
            'type'      => 'relationship',
            'name'      => 'condition_id',
            'entity'    => 'conditionHasOne',
            'attribute' => 'name',
            'wrapper' => [
                'class' => 'form-group col-md-6'
            ],
            'model'     => "App\Models\Condition",
            'options'   => (function ($query) {
                return $query->where('lookup_type_id', LookupConstant::ASSET_CONDITION)->get();
            }),
        ]);

here is the result

The question is how to achieve this UI

[pxpm]

Hey @cheadevit

The field shows multiple because ... it's a multiple relation. (BelongsToMany)

You can try multiple => false in your field, but not sure if you don't need to overwrite the saving process because Backpack is expecting an array for a multiple relation, even if it's an array with only one element.

Let me know how it goes.

Cheers

[cheadevit]

@pxpm it works now, I appreciated it.
Thank you.

Cheers

[cheadevit]

@here is the code

$this->crud->addField([
            'label'     => 'Condition',
            'type'      => 'relationship',
            'name'      => 'condition_id',
            'entity'    => 'conditionLatest',
            'attribute' => 'name',
            'wrapper'   => [
                'class' => 'form-group col-md-6'
            ],
            'multiple'  => false,
            'model'     => "App\Models\Condition",
            'options'   => (function ($query) {
                return $query->where('lookup_type_id', LookupConstant::ASSET_CONDITION)->get();
            }),
       ]);

[pxpm]

Thanks for sharing back your solution, it will help others in future with the same problem. 🙏

Cheers