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

   1 <?php
   2
   3 namespace BookStack\Entities\Queries;
   4
   5 use BookStack\Activity\Models\View;
   6 use Illuminate\Support\Collection;
   7
   8 class RecentlyViewed extends EntityQuery
   9 {
  10     public function run(int $count, int $page): Collection
  11     {
  12         $user = user();
  13         if ($user === null || $user->isDefault()) {
  14             return collect();
  15         }
  16
  17         $query = $this->permissionService()->restrictEntityRelationQuery(
  18             View::query(),
  19             'views',
  20             'viewable_id',
  21             'viewable_type'
  22         )
  23             ->orderBy('views.updated_at', 'desc')
  24             ->where('user_id', '=', user()->id);
  25
  26         return $query->with('viewable')
  27             ->skip(($page - 1) * $count)
  28             ->take($count)
  29             ->get()
  30             ->pluck('viewable')
  31             ->filter();
  32     }
  33 }