dateTime = $dateTime; } /** * Define resource model * * @return void * @since 100.1.0 */ protected function _construct() { $this->_init( \Magento\Security\Model\AdminSessionInfo::class, \Magento\Security\Model\ResourceModel\AdminSessionInfo::class ); } /** * Update active sessions status except a specific one * * @param int $status * @param int $userId * @param string $sessionIdToExclude * @param int $updateOlderThen * @return int The number of affected rows. * @since 100.1.0 */ public function updateActiveSessionsStatus( $status, $userId, $sessionIdToExclude, $updateOlderThen = null ) { return $this->getResource()->updateStatusByUserId( $status, $userId, [\Magento\Security\Model\AdminSessionInfo::LOGGED_IN], [$sessionIdToExclude], $updateOlderThen ); } /** * Filter by user * * @param int $userId * @param int $status * @param null|string $sessionIdToExclude * @return $this * @since 100.1.0 */ public function filterByUser( $userId, $status = \Magento\Security\Model\AdminSessionInfo::LOGGED_IN, $sessionIdToExclude = null ) { $this->addFieldToFilter('user_id', $userId); $this->addFieldToFilter('status', $status); if (null !== $sessionIdToExclude) { $this->addFieldToFilter('session_id', ['neq' => $sessionIdToExclude]); } return $this; } /** * Filter expired sessions * * @param int $sessionLifeTime * @return $this * @since 100.1.0 */ public function filterExpiredSessions($sessionLifeTime) { $connection = $this->getConnection(); $gmtTimestamp = $this->dateTime->gmtTimestamp(); $this->addFieldToFilter( 'updated_at', ['gt' => $connection->formatDate($gmtTimestamp - $sessionLifeTime)] ); return $this; } /** * Delete sessions older than some value * * @param int $timestamp * @return $this * @since 100.1.0 */ public function deleteSessionsOlderThen($timestamp) { $this->getResource()->deleteSessionsOlderThen((int) $timestamp); return $this; } }