App\Models\RoleStat

Complexity

Total Complexity

3

Size/Duplication

Total Lines	17
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getUsersByRole()	0	3	1
A	insertUsersByRole()	0	5	2

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Spatie\Permission\Models\Role;

class RoleStat extends Model
{
    use HasFactory;

    protected $guarded = [];

    public static function insertUsersByRole(): void
    {
        $roles = Role::query()->select(['name'])->withCount('users')->groupBy('name')->having('users_count', '>', 0)->orderByDesc('users_count')->get();

'users_count' of type string is incompatible with the type Closure|Illuminate\Database\Eloquent\Builder|Illuminate\Database\Query\Builder expected by parameter $column of Illuminate\Database\Query\Builder::orderByDesc().

        foreach ($roles as $role) {
            self::updateOrCreate(['role' => $role->name, 'users' => $role->users_count]);
        }
    }

    public static function getUsersByRole(): array
    {
        return self::query()->select(['role', 'users'])->get()->toArray();
    }
}