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

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