]> BookStack Code Mirror - bookstack/blob - app/Entities/Queries/RecentlyViewed.php
DB: Started update of entity loading to avoid global selects
[bookstack] / 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->isGuest()) {
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         $views = $query
27             ->skip(($page - 1) * $count)
28             ->take($count)
29             ->get();
30
31         $this->mixedEntityListLoader()->loadIntoRelations($views->all(), 'viewable', false);
32
33         return $views->pluck('viewable')->filter();
34     }
35 }