Jalle19\StatusManager\Database\UserQuery

Complexity

Total Complexity

4

Size/Duplication

Total Lines	59
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	1

Test Coverage

Coverage

29.4%

Importance

Changes	6
Bugs	0	Features	2

3 Methods

Rating	Name	Duplication	Size	Complexity
A	hasUser()	0	4	1
A	filterIgnoredUsers()	0	10	2
A	getMostActiveWatchersQuery()	0	16	1

<?php

namespace Jalle19\StatusManager\Database;

use Jalle19\StatusManager\Database\Base\UserQuery as BaseUserQuery;
use Propel\Runtime\ActiveQuery\Criteria;

/**
 * @package   Jalle19\StatusManager\Database
 * @copyright Copyright &copy; Sam Stenvall 2015-
 * @license   https://www.gnu.org/licenses/gpl.html The GNU General Public License v2.0
 */
class UserQuery extends BaseUserQuery

There is one abstract method limit in this class; you could implement it, or declare this class as abstract.

{

	use LimitTrait;


	/**
	 * @param string $instanceName
	 * @param string $userName
	 *
	 * @return bool
	 */
	public function hasUser($instanceName, $userName)
	{
		return $this->filterByInstanceName($instanceName)->filterByName($userName)->findOne() !== null;
	}


	/**
	 * @param array $ignoredUsers
	 *
	 * @return UserQuery
	 */
	public function filterIgnoredUsers(array $ignoredUsers)
	{
		// Always ignore system users
		$ignoredUsers[] = User::NAME_DVR;

		foreach ($ignoredUsers as $ignoredUser)
			$this->filterByName($ignoredUser, Criteria::NOT_EQUAL);

		return $this;
	}


	/**
	 * @param Instance $instance
	 *
	 * @return UserQuery
	 * @throws \Propel\Runtime\Exception\PropelException
	 */
	public function getMostActiveWatchersQuery($instance)
	{
		$this->withColumn('user.name', 'userName');
		$this->withColumn('SUM((julianday(subscription.stopped) - julianday(subscription.started)) * 86400)',
			'totalTimeSeconds');

		$this->select(['userName', 'totalTimeSeconds']);

		$this->useSubscriptionQuery()->filterByStopped(null, Criteria::NOT_EQUAL)->endUse();
		$this->filterByInstance($instance);

		$this->groupBy('userName');
		$this->orderBy('totalTimeSeconds', Criteria::DESC);

		return $this;
	}

}