Hello all,

Background:

I have an Order table which contains 'user_id' as a foreign key to defined who is the order owner or creator.
I used recorderfinder to allows the website admin to choose a user at the backend when creating an order.

The problem is the column name must be same as the relation's name: For example:
In the Model:

$belongsTo = [
     'user' => \RainLab\User\Models\User::class
];

In column.yaml:

user:
    label: User
    type: recordfinder
    list: $/rainlab/user/models/user/columns.yaml
    prompt: Click the %s button to find a user
    nameFrom: name
    descriptionFrom: email

so when I submitting the form, it is posting user instead of 'user_id', so the model does not allows me to save.

What is the best way to achieve this?

Cheers, David

Last updated 8 years ago

Ok. Problem Solved. The reason is that I have defined incorrect model relationships so OctoberCMS cannot pick the value correctly.

Last updated 8 years ago

You can also customize and fetch relation by using Attributes in model.

// Model: Customer
public function getFullNameAttribute()
{
        return $this->backendUser->first_name.' '.$this->backendUser->last_name;
}

Last updated 7 years ago