App\Models\GrabStat

Complexity

Total Complexity

3

Size/Duplication

Total Lines	18
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	insertTopGrabbers()	0	6	2
A	getTopGrabbers()	0	3	1

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class GrabStat extends Model
{
    use HasFactory;

The trait Illuminate\Database\Eloquent\Factories\HasFactory requires the property $factoryClass which is not provided by App\Models\GrabStat.

    protected $guarded = [];

    public static function insertTopGrabbers(): void
    {
        $users = User::query()->selectRaw('id, username, SUM(grabs) as grabs')->groupBy('id', 'username')->having('grabs', '>', 0)->orderByDesc('grabs')->limit(10)->get();

'grabs' 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().

        // Insert data into the grab_stats table
        foreach ($users as $user) {
            self::updateOrCreate(['username' => $user->username], ['grabs' => $user->grabs]);
        }
    }

    public static function getTopGrabbers(): array
    {
        return self::query()->select(['username', 'grabs'])->get()->toArray();
    }
}