<?php
+
namespace wcf\data\acp\session\log;
+
use wcf\data\DatabaseObjectList;
/**
* Represents a list of session log entries.
- *
- * @author Marcel Werk
- * @copyright 2001-2018 WoltLab GmbH
- * @license GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
- * @package WoltLabSuite\Core\Data\Acp\Session\Log
*
- * @method ACPSessionLog current()
- * @method ACPSessionLog[] getObjects()
- * @method ACPSessionLog|null search($objectID)
- * @property ACPSessionLog[] $objects
+ * @author Marcel Werk
+ * @copyright 2001-2019 WoltLab GmbH
+ * @license GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
+ * @package WoltLabSuite\Core\Data\Acp\Session\Log
+ *
+ * @method ACPSessionLog current()
+ * @method ACPSessionLog[] getObjects()
+ * @method ACPSessionLog|null getSingleObject()
+ * @method ACPSessionLog|null search($objectID)
+ * @property ACPSessionLog[] $objects
*/
-class ACPSessionLogList extends DatabaseObjectList {
- /**
- * @inheritDoc
- */
- public $className = ACPSessionLog::class;
-
- /**
- * @inheritDoc
- */
- public function readObjects() {
- if (!empty($this->sqlSelects)) $this->sqlSelects .= ',';
- $this->sqlSelects .= " user_table.username, acp_session.sessionID AS active,
- (SELECT COUNT(*) FROM wcf".WCF_N."_acp_session_access_log WHERE sessionLogID = ".$this->getDatabaseTableAlias().".sessionLogID) AS accesses";
-
- $this->sqlJoins .= " LEFT JOIN wcf".WCF_N."_user user_table ON (user_table.userID = ".$this->getDatabaseTableAlias().".userID)
- LEFT JOIN wcf".WCF_N."_acp_session acp_session ON (acp_session.sessionID = ".$this->getDatabaseTableAlias().".sessionID)";
-
- parent::readObjects();
- }
+class ACPSessionLogList extends DatabaseObjectList
+{
+ /**
+ * @inheritDoc
+ */
+ public $className = ACPSessionLog::class;
+
+ /**
+ * @inheritDoc
+ */
+ public function readObjects()
+ {
+ if (!empty($this->sqlSelects)) {
+ $this->sqlSelects .= ',';
+ }
+ $this->sqlSelects .= "
+ user_table.username,
+ 0 AS active,
+ (
+ SELECT COUNT(*)
+ FROM wcf" . WCF_N . "_acp_session_access_log
+ WHERE sessionLogID = " . $this->getDatabaseTableAlias() . ".sessionLogID
+ ) AS accesses";
+
+ $this->sqlJoins .= "
+ LEFT JOIN wcf" . WCF_N . "_user user_table
+ ON user_table.userID = " . $this->getDatabaseTableAlias() . ".userID";
+
+ parent::readObjects();
+ }
}