ReleaseStat::getRecentlyAdded() - Code Metrics - NNTmux/newznab-tmux - Measure and Improve Code Quality continuously with Scrutinizer

ReleaseStat::getRecentlyAdded() A
last analyzed 2025-07-01 20:51 UTC

↳ Parent: ReleaseStat

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
eloc	1
dl	0
loc	3
c	0
b	0
f	0
rs	10
cc	1
nc	1
nop	0

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;

class ReleaseStat extends Model
{
    use HasFactory;


    protected $guarded = [];

    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();
            'categories.id')->groupBy('title')->orderByDesc(/** @scrutinizer ignore-type */ 'count')->get();

        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]);
        }
    }

    public static function getRecentlyAdded(): array
    {
        return self::query()->select(['category', 'count'])->get()->toArray();
    }
}


NNTmux / newznab-tmux

ReleaseStat::getRecentlyAdded() A last analyzed 2025-07-01 20:51 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

ReleaseStat::getRecentlyAdded() A
last analyzed 2025-07-01 20:51 UTC