13 - Roles/Permissions: Manage Employees

Next on our list - separating user roles. In our system, we need admins to manage the system settings and employees, while the employees themselves can only manage customers and nothing else:

In this lesson, we will do the following:

Create roles Model and Database structure
Create a user management page (CRUD)
Add employees to our Customers' table and form for admins to manage
Add employee changes to our customer history
Add an additional tab in Customers for My Customers - customers assigned to the employee

Creating Roles Model and Database structure

Let's start by creating our migration file:

Migration

Schema::create('roles', function (Blueprint $table) {
    $table->id();
    $table->string('name');
    $table->timestamps();
});

Then, we can fill out our Model:

app/Models/Role.php

class Role extends Model
{
    protected $fillable = ['name'];
}

Of course, we should also...

The Full Lesson is Only for Premium Members

Want to access all of our courses? (36 h 00 min)

You also get:

61 courses

Premium tutorials

Access to repositories

Private Discord

Get Premium for $129/year or $29/month

Already a member? Login here

Roman Zelenin 2 years ago

app/Models/Customer.php

if ($customer->employee_id !== $lastLog) {

Looks like this line should be:

if ($customer->employee_id !== $lastLog->employee_id) {

app/Filament/Resources/CustomerResource/Pages/ListCustomers.php

with filter query:

if (!auth()->user()->isAdmin()) {
    $tabs['my'] = Tab::make('My Customers')
        ->badge(Customer::where('employee_id', auth()->id())->count())
        ->modifyQueryUsing(function ($query) {
            return $query->where('employee_id', auth()->id());
        });
}

👍 1

Modestas 2 years ago

Correct, updated it! Sorry about that

Rick Zimmermans 2 years ago

Hi! Thank you and the team for the amazing work! Just a quick questions if i may.

in the following example, shouldn't the code be:

// From
if ($customer->employee_id !== $lastLog->employee_id) {
// To
if ($customer->employee_id !== $lastLog?->employee_id) {

Since we're only looking for records where employee_id is not null which may result in $lastLog being null.

Maybe im wrong tho. Keep up the good work!

👍 1

Modestas 2 years ago

Hi, this was updated yesterday as indeed - there was a mistake on our end!

We also fixed My Customers tab filtration

Rick Zimmermans 2 years ago

Oh for me it still says "$lastLog->employee_id" without the nullsafe operator. But thank you for confirming!

Modestas 2 years ago

Hm, did you encounter an issue with nullsafe? I have not seen it, so did not add it! But definitely can add a check for it

Rick Zimmermans 2 years ago

i did encounter a problem without using the nullsafe on $lastLog->employee_id. In the course it says to use "$lastLog->employee_id" but i think it should say "$lastLog?->employee_id"

self::updated(function (Customer $customer) {
    // this could return null
        $lastLog = $customer->pipelineStageLogs()->whereNotNull('employee_id')->latest()->first();
 
    // in the case that $lastLog is null, employee_id is not accessible.
    // this is why i added a nullsafe ($lastLog?->employee_id)
        if ($customer->employee_id !== $lastLog->employee_id) {
            $customer->pipelineStageLogs()->create([
            //
        }
    });

But maybe i did something wrong before this.

Modestas 2 years ago

Hm... Maybe I had a different structure there and didn't see the issue. In any case, added a check! Thanks for reporting

Blue_Moonie 2 years ago

Could we simplify using:

self::updated(function (Customer $customer) {
    if ($customer->wasChanged('employee_id')) {
        $customer->pipelineStageLogs()->create([
            //
        }
});

vpinti 1 year ago

I choose Blue_Moonie solution, is more clear and work. The alternative is to modify the seeder and associate, during the creation of the customer, an employee (a solution I do not like)

Roles/Permissions: Manage Employees

Creating Roles Model and Database structure

The Full Lesson is Only for Premium Members

We'd Love Your Feedback

Thank You!