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

   1 <?php
   2
   3 namespace BookStack\Entities\Queries;
   4
   5 use BookStack\Activity\Models\View;
   6 use BookStack\Entities\EntityProvider;
   7 use BookStack\Entities\Tools\MixedEntityListLoader;
   8 use BookStack\Permissions\PermissionApplicator;
   9 use Illuminate\Support\Collection;
  10 use Illuminate\Support\Facades\DB;
  11
  12 class QueryPopular
  13 {
  14     public function __construct(
  15         protected PermissionApplicator $permissions,
  16         protected EntityProvider $entityProvider,
  17         protected MixedEntityListLoader $listLoader,
  18     ) {
  19     }
  20
  21     public function run(int $count, int $page, array $filterModels): Collection
  22     {
  23         $query = $this->permissions
  24             ->restrictEntityRelationQuery(View::query(), 'views', 'viewable_id', 'viewable_type')
  25             ->select('*', 'viewable_id', 'viewable_type', DB::raw('SUM(views) as view_count'))
  26             ->groupBy('viewable_id', 'viewable_type')
  27             ->orderBy('view_count', 'desc');
  28
  29         if (!empty($filterModels)) {
  30             $query->whereIn('viewable_type', $this->entityProvider->getMorphClasses($filterModels));
  31         }
  32
  33         $views = $query
  34             ->skip($count * ($page - 1))
  35             ->take($count)
  36             ->get();
  37
  38         $this->listLoader->loadIntoRelations($views->all(), 'viewable', true);
  39
  40         return $views->pluck('viewable')->filter();
  41     }
  42 }