Unable to associate role to a user for one to many relationship

I have a one to many relationship between users and roles. I am unable to associate a role to a user while saving or updating a user. Please spare some time to have a look below. Thank you for your time.

Database Structure

Users
----------
* id
* name
* email
* password
* role_id
* created_at

Roles
----------
* id
* name
* slug
* created_at

User Model

public function role() {
    return $this->belongsTo(Role::class);
}

Role Model

public function users() {
    return $this->hasMany(User::class);
}

User Controller

public $showUserUpdationModal = false;
public $role;
public User $user;

protected $rules = [
    'user.name' => 'required|string|max:255',
    'user.email' => 'required|string|email|max:255',
    'role' => 'required',
];

public function storeUser()
{
    $this->validate();
    $this->validate([
        'user.email' => 'unique:users,email,'.$this->user->id,
    ]);
    $this->user->save();
    $this->user->role()->associate($this->role);
    $this->showUserUpdationModal = false;

    $this->dispatchBrowserEvent('notify', $this->user->name.' Updated Successfully');
    $this->emit('sectionRefresh');
}

frankielee

5 years ago

Best Answer

Level 29

https://laravel.com/docs/8.x/eloquent-relationships#updating-belongs-to-relationships

Based on the documentation, you should call the save method after the associate

1 like

ToxifiedM

5 years ago

Level 1

@frankielee Mate, when I'm doing that, I'm getting the following error.

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '[2]' for column management.users.role_id at row 1 (SQL: update users set role_id = [2], users.updated_at = 2021-01-29 04:30:07 where id = 2)

What can be this about, please help me here.

frankielee

5 years ago

Level 29

Try to debug your $this->role, seems like it is an array but the column is expecting an integer.

Would you mind to show your blade file?

ToxifiedM

5 years ago

Level 1

Yes mate, surely. I have updated the user controller code block as well, as I have added the public function updateUser method which mounts the user and his role as well.

User Update Modal Blade Component

<div>
    <form wire:submit.prevent="storeUser">
        @csrf
        <x-modal.dialog wire:model.defer="showUserUpdationModal">
            <x-slot name="title">Update User</x-slot>
            <x-slot name="content">
                <x-input.group for="name" label="Name" :error="$errors->first('user.name')">
                    <x-input.text wire:model="user.name" type="text" id="name" placeholder="Enter Name" />
                </x-input.group>
                <x-input.group for="email" label="Email" :error="$errors->first('user.email')">
                    <x-input.text wire:model="user.email" type="email" id="email" placeholder="Enter Email" />
                </x-input.group>
                <x-input.group for="role" label="Role" :error="$errors->first('role')">
                    <x-input.select wire:model="role" id="role">
                        @foreach ($roles as $role)
                            <option value="{{ $role->id }}">{{ $role->name }}</option>
                        @endforeach
                    </x-input.select>
                </x-input.group>
            </x-slot>
            <x-slot name="footer">
                <x-button.secondary wire:click="$set('showUserUpdationModal', false)">Cancel</x-button.secondary>
                <x-button.primary type="submit">Save</x-button.primary>
            </x-slot>
        </x-modal.dialog>
    </form>
</div>

User Controller

public $showUserUpdationModal = false;
public $role;
public User $user;

protected $rules = [
    'user.name' => 'required|string|max:255',
    'user.email' => 'required|string|email|max:255',
    'role' => 'required',
];

public function updateUser(User $user)
{
    $this->resetValidation();
        
    $this->user = $user;
    $this->role = $user->role()->pluck('id');
    $this->showUserUpdationModal = true;
}

public function storeUser()
{
    $this->validate();
    $this->validate([
        'user.email' => 'unique:users,email,'.$this->user->id,
    ]);
    $this->user->role()->associate($this->role);
    $this->user->save();
    $this->showUserUpdationModal = false;

    $this->dispatchBrowserEvent('notify', $this->user->name.' Updated Successfully');
    $this->emit('sectionRefresh');
}

frankielee

5 years ago

Level 29

If not mistaken, you are using livewire right?

Try to add this function to debug the $this->role value

    public function updating($name, $value)
    {
        if ($name == 'role') {
            dd($name, $value);
        }

    }

ToxifiedM

5 years ago

Level 1

Actually, when I was mounting the role input for the modal component, I had called for $this->role = $user->role()->pluck('id') which was causing the problem, as it was passing the ids as an array. As I am type hinting model properties, here is my approach which I just implied.

Its working now as I wanted it to be. Thanks for your time and effort. :)

User Controller

    public User $user;

    protected $listeners = ['updateUser'];

    protected $rules = [
        'user.name' => 'required|string|max:255',
        'user.email' => 'required|string|email|max:255',
        'user.role_id' => 'required',
    ];

    public function updateUser(User $user)
    {
        $this->useCachedRows();
        $this->resetValidation();
    
        $this->user = $user;
        $this->showUserUpdationModal = true;
    }

    public function storeUser()
    {
        $this->validate();
        $this->validate([
            'user.email' => 'unique:users,email,'.$this->user->id,
        ]);
        $this->user->role()->associate($this->user->role_id);
        $this->user->save();
        $this->showUserUpdationModal = false;

        $this->dispatchBrowserEvent('notify', $this->user->name.' Updated Successfully');
        $this->emit('sectionRefresh');
    }

1 like

Please or to participate in this conversation.