App\Models\DownloadStat::insertTopDownloads()

Complexity

Conditions	2
Paths	2

Size

Total Lines	18
Code Lines	15

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public static function insertTopDownloads(): void
    {
        $releases = Release::query()
            ->where('grabs', '>', 0)
            ->select(['id', 'searchname', 'guid', 'adddate'])
            ->selectRaw('SUM(grabs) as grabs')
            ->groupBy('id', 'searchname', 'adddate')
            ->havingRaw('SUM(grabs) > 0')
            ->orderByDesc('grabs')

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

            ->limit(10)
            ->get();

        foreach ($releases as $release) {
            self::updateOrCreate([
                'searchname' => $release->searchname,
                'guid' => $release->guid,
                'adddate' => $release->adddate,
                'grabs' => $release->grabs,
            ]);