Getting two fields or more as "attribute" in relations

[adbmdp]

Is it possible to concat two fields for the attribute (foreign key attribute that is shown to user) ?
For example i can display the name of the user with the relation below but i would like to display first + name.

$this->crud->addField([
            'label' => "User",
            'type' => 'select2_multiple',
            'name' => 'users',
            'entity' => 'users',
            'attribute' => 'name',
            'model' => "App\Models\User",
            'pivot' => true
]);

Something like :
'attribute' => 'firstname' . 'name',

Thanks.

[tabacitu]

Sure, just create an accesor on your User model, something like:

public function getFullNameAttribute($value) {
   return $this->firstname.' '.$this->name;
}

You'll then be able to use full_name for the attribute, both in CRUD and anywhere else in your app ($user->full_name).

Hope it helps.

Cheers!

[adbmdp]

Awesome. Thank you!

[singeryo]

For those who come accross this post and are in my situation:

If you wan't to load the full_name attribute in ajax queries with a select2_ajax type field (for example), you need to add the attribute name to the $appends model attribute like so:

    /**
     * Appends to JSON
     *
     * @var string[]
     */
    protected $appends = [
        'full_name'
    ];

Otherwise the loaded data will not have this attribute in the response on frontend, and thus cannot display results in the select2 result box.

[pxpm]

Thanks @singeryo it's definitely helpful. And not only for ajax queries, for any scenario where you want to add something else to the model you should use Laravel model $appends .
Cheers

[kushsha]

 #define into user model
 public function getFullNameAttribute($value) {
        return $this->first_name.' '.$this->last_name;
    }

#use in controller
$this->crud->addcolumn([
            // role list
            'label' => 'Primary program manager',
            'name' => 'priorityProgramManger.full_name', // the method that defines the relationship in your Model
        ]);

[altayevrim]

This is also helpful when you want to use relations with Ajax.

# on Model
protected $appends = [
    'full_title'
];

public function getFullTitleAttribute():string
{
    return $this->company_number . ' - ' . $this->title;
}

# on CrudController
CRUD::field('company')->type('relationship')->label('Şirket')->attribute('full_title')->ajax(true);

In case someone (or me) needs it for later.