App\Models\RoleStat::insertUsersByRole()

Complexity

Conditions	3
Paths	3

Size

Total Lines	11
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    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) {
            // Check if we already have the information and if we do just update the count
            if (self::query()->where('role', $role->name)->exists()) {
                self::query()->where('role', $role->name)->update(['users' => $role->users_count]);

                continue;
            }
            self::query()->create(['role' => $role->name, 'users' => $role->users_count]);
        }