wcfsetup/install/files/lib/data/acp/session/log/ACPSessionLogList.class.php

   1 <?php
   2
   3 namespace wcf\data\acp\session\log;
   4
   5 use wcf\data\DatabaseObjectList;
   6
   7 /**
   8  * Represents a list of session log entries.
   9  *
  10  * @author  Marcel Werk
  11  * @copyright   2001-2019 WoltLab GmbH
  12  * @license GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
  13  * @package WoltLabSuite\Core\Data\Acp\Session\Log
  14  *
  15  * @method  ACPSessionLog       current()
  16  * @method  ACPSessionLog[]     getObjects()
  17  * @method  ACPSessionLog|null  search($objectID)
  18  * @property    ACPSessionLog[] $objects
  19  */
  20 class ACPSessionLogList extends DatabaseObjectList
  21 {
  22     /**
  23      * @inheritDoc
  24      */
  25     public $className = ACPSessionLog::class;
  26
  27     /**
  28      * @inheritDoc
  29      */
  30     public function readObjects()
  31     {
  32         if (!empty($this->sqlSelects)) {
  33             $this->sqlSelects .= ',';
  34         }
  35         $this->sqlSelects .= "
  36             user_table.username,
  37             0 AS active,
  38             (
  39                 SELECT  COUNT(*)
  40                 FROM    wcf" . WCF_N . "_acp_session_access_log
  41                 WHERE   sessionLogID = " . $this->getDatabaseTableAlias() . ".sessionLogID
  42             ) AS accesses";
  43
  44         $this->sqlJoins .= "
  45             LEFT JOIN   wcf" . WCF_N . "_user user_table
  46             ON          user_table.userID = " . $this->getDatabaseTableAlias() . ".userID";
  47
  48         parent::readObjects();
  49     }
  50 }