BookStack Code Mirror - bookstack/blob - app/Entities/Queries/Popular.php

   1 <?php
   2
   3 namespace BookStack\Entities\Queries;
   4
   5 use BookStack\Activity\Models\View;
   6 use Illuminate\Support\Facades\DB;
   7
   8 class Popular extends EntityQuery
   9 {
  10     public function run(int $count, int $page, array $filterModels = null)
  11     {
  12         $query = $this->permissionService()
  13             ->restrictEntityRelationQuery(View::query(), 'views', 'viewable_id', 'viewable_type')
  14             ->select('*', 'viewable_id', 'viewable_type', DB::raw('SUM(views) as view_count'))
  15             ->groupBy('viewable_id', 'viewable_type')
  16             ->orderBy('view_count', 'desc');
  17
  18         if ($filterModels) {
  19             $query->whereIn('viewable_type', $this->entityProvider()->getMorphClasses($filterModels));
  20         }
  21
  22         return $query->with('viewable')
  23             ->skip($count * ($page - 1))
  24             ->take($count)
  25             ->get()
  26             ->pluck('viewable')
  27             ->filter();
  28     }
  29 }