WCF/wcfsetup/install/files/lib/system/gridView/admin/ACPSessionLogGridView.class.php at 435c4839f89ca66159baa70a9563a433f4a9fe2b · WoltLab/WCF · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
<?php

namespace wcf\system\gridView\admin;

use wcf\acp\form\UserEditForm;
use wcf\acp\page\ACPSessionLogPage;
use wcf\data\acp\session\log\ACPSessionLog;
use wcf\data\acp\session\log\ACPSessionLogList;
use wcf\event\gridView\admin\ACPSessionLogGridViewInitialized;
use wcf\system\gridView\AbstractGridView;
use wcf\system\gridView\filter\IpAddressFilter;
use wcf\system\gridView\filter\TextFilter;
use wcf\system\gridView\filter\TimeFilter;
use wcf\system\gridView\filter\UserFilter;
use wcf\system\gridView\GridViewColumn;
use wcf\system\gridView\GridViewRowLink;
use wcf\system\gridView\renderer\IpAddressColumnRenderer;
use wcf\system\gridView\renderer\NumberColumnRenderer;
use wcf\system\gridView\renderer\ObjectIdColumnRenderer;
use wcf\system\gridView\renderer\TimeColumnRenderer;
use wcf\system\gridView\renderer\TruncatedTextColumnRenderer;
use wcf\system\gridView\renderer\UserLinkColumnRenderer;
use wcf\system\WCF;

/**
 * Grid view for the list of logged admin session.
 *
 * @author      Marcel Werk
 * @copyright   2001-2024 WoltLab GmbH
 * @license     GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
 * @since       6.2
 *
 * @extends AbstractGridView<ACPSessionLog, ACPSessionLogList>
 */
final class ACPSessionLogGridView extends AbstractGridView
{
    public function __construct()
    {
        $this->addColumns([
            GridViewColumn::for('sessionLogID')
                ->label('wcf.global.objectID')
                ->renderer(new ObjectIdColumnRenderer())
                ->sortable(),
            GridViewColumn::for('userID')
                ->label('wcf.user.username')
                ->sortable(true, 'user_table.username')
                ->titleColumn()
                ->renderer(new UserLinkColumnRenderer(UserEditForm::class))
                ->filter(new UserFilter()),
            GridViewColumn::for('ipAddress')
                ->label('wcf.user.ipAddress')
                ->sortable()
                ->renderer(new IpAddressColumnRenderer())
                ->filter(new IpAddressFilter()),
            GridViewColumn::for('userAgent')
                ->label('wcf.user.userAgent')
                ->sortable()
                ->valueEncoding(false)
                ->renderer(new TruncatedTextColumnRenderer(50))
                ->filter(new TextFilter()),
            GridViewColumn::for('time')
                ->label('wcf.acp.sessionLog.time')
                ->sortable()
                ->renderer(new TimeColumnRenderer())
                ->filter(new TimeFilter()),
            GridViewColumn::for('lastActivityTime')
                ->label('wcf.acp.sessionLog.lastActivityTime')
                ->sortable()
                ->renderer(new TimeColumnRenderer())
                ->filter(new TimeFilter()),
            GridViewColumn::for('accesses')
                ->label('wcf.acp.sessionLog.actions')
                ->sortable(true, 'accesses')
                ->renderer(new NumberColumnRenderer()),
        ]);

        $this->addRowLink(new GridViewRowLink(ACPSessionLogPage::class));
        $this->setDefaultSortField('lastActivityTime');
        $this->setDefaultSortOrder('DESC');
    }

    #[\Override]
    public function isAccessible(): bool
    {
        return WCF::getSession()->getPermission('admin.management.canViewLog');
    }

    #[\Override]
    protected function createObjectList(): ACPSessionLogList
    {
        $list = new ACPSessionLogList();
        $list->sqlSelects .= "
            user_table.username,
            0 AS active,
            (
                SELECT  COUNT(*)
                FROM    wcf1_acp_session_access_log
                WHERE   sessionLogID = " . $list->getDatabaseTableAlias() . ".sessionLogID
            ) AS accesses";
        $list->sqlJoins = $list->sqlConditionJoins .= " LEFT JOIN wcf" . WCF_N . "_user user_table ON (user_table.userID = " . $list->getDatabaseTableAlias() . ".userID)";

        return $list;
    }

    #[\Override]
    protected function getInitializedEvent(): ACPSessionLogGridViewInitialized
    {
        return new ACPSessionLogGridViewInitialized($this);
    }
}