]> BookStack Code Mirror - bookstack/blob - app/Http/Controllers/AuditLogController.php
Added a "skip to content" link.
[bookstack] / app / Http / Controllers / AuditLogController.php
1 <?php
2
3 namespace BookStack\Http\Controllers;
4
5 use BookStack\Actions\Activity;
6 use Illuminate\Http\Request;
7 use Illuminate\Support\Facades\DB;
8
9 class AuditLogController extends Controller
10 {
11
12     public function index(Request $request)
13     {
14         $this->checkPermission('settings-manage');
15         $this->checkPermission('users-manage');
16
17         $listDetails = [
18             'order' => $request->get('order', 'desc'),
19             'event' => $request->get('event', ''),
20             'sort' => $request->get('sort', 'created_at'),
21             'date_from' => $request->get('date_from', ''),
22             'date_to' => $request->get('date_to', ''),
23             'user' => $request->get('user', ''),
24         ];
25
26         $query = Activity::query()
27             ->with([
28                 'entity' => function ($query) {
29                     $query->withTrashed();
30                 },
31                 'user'
32             ])
33             ->orderBy($listDetails['sort'], $listDetails['order']);
34
35         if ($listDetails['event']) {
36             $query->where('type', '=', $listDetails['event']);
37         }
38         if ($listDetails['user']) {
39             $query->where('user_id', '=', $listDetails['user']);
40         }
41
42         if ($listDetails['date_from']) {
43             $query->where('created_at', '>=', $listDetails['date_from']);
44         }
45         if ($listDetails['date_to']) {
46             $query->where('created_at', '<=', $listDetails['date_to']);
47         }
48
49         $activities = $query->paginate(100);
50         $activities->appends($listDetails);
51
52         $types = DB::table('activities')->select('type')->distinct()->pluck('type');
53         $this->setPageTitle(trans('settings.audit'));
54         return view('settings.audit', [
55             'activities' => $activities,
56             'listDetails' => $listDetails,
57             'activityTypes' => $types,
58         ]);
59     }
60 }