App\Models\ReleaseStat::insertRecentlyAdded()

Complexity

Conditions	3
Paths	3

Size

Total Lines	15
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public static function insertRecentlyAdded(): void
    {
        $categories = Category::query()->with('parent')->where('r.adddate', '>', now()->subWeek())->select([
            'root_categories_id', DB::raw('COUNT(r.id) as count'), 'title',
        ])->join('releases as r', 'r.categories_id', '=',
            'categories.id')->groupBy('title')->orderByDesc('count')->get();

'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 ($categories as $category) {
            // Check if we already have the information and if we do just update the count
            if (self::query()->where('category', $category->title)->exists()) {
                self::query()->where('category', $category->title)->update(['count' => $category->count]);

                continue;
            }
            self::query()->create(['category' => $category->title, 'count' => $category->count]);
        }