1 | <?php |
||||
2 | |||||
3 | namespace App\Models; |
||||
4 | |||||
5 | use Illuminate\Database\Eloquent\Factories\HasFactory; |
||||
6 | use Illuminate\Database\Eloquent\Model; |
||||
7 | |||||
8 | class DownloadStat extends Model |
||||
9 | { |
||||
10 | use HasFactory; |
||||
0 ignored issues
–
show
Bug
introduced
by
![]() |
|||||
11 | |||||
12 | protected $guarded = []; |
||||
13 | |||||
14 | public static function insertTopDownloads(): void |
||||
15 | { |
||||
16 | $releases = Release::query() |
||||
17 | ->where('grabs', '>', 0) |
||||
18 | ->select(['id', 'searchname', 'guid', 'adddate']) |
||||
19 | ->selectRaw('SUM(grabs) as grabs') |
||||
20 | ->groupBy('id', 'searchname', 'adddate') |
||||
21 | ->havingRaw('SUM(grabs) > 0') |
||||
22 | ->orderByDesc('grabs') |
||||
0 ignored issues
–
show
'grabs' of type string is incompatible with the type Closure|Illuminate\Datab...\Database\Query\Builder expected by parameter $column of Illuminate\Database\Query\Builder::orderByDesc() .
(
Ignorable by Annotation
)
If this is a false-positive, you can also ignore this issue in your code via the
![]() |
|||||
23 | ->limit(10) |
||||
24 | ->get(); |
||||
25 | |||||
26 | foreach ($releases as $release) { |
||||
27 | self::updateOrCreate([ |
||||
28 | 'searchname' => $release->searchname, |
||||
29 | 'guid' => $release->guid, |
||||
30 | 'adddate' => $release->adddate, |
||||
31 | 'grabs' => $release->grabs, |
||||
32 | ]); |
||||
33 | } |
||||
34 | } |
||||
35 | |||||
36 | public static function getTopDownloads(): array |
||||
37 | { |
||||
38 | return self::query()->select(['searchname', 'guid', 'adddate', 'grabs'])->get()->toArray(); |
||||
39 | } |
||||
40 | } |
||||
41 |