for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?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;
Illuminate\Database\Eloquent\Factories\HasFactory
$factoryClass
App\Models\ReleaseStat
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();
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
Loading history...