/**
* Executes a search on the list of users and
* returns the users
*
* @return array Array of users
*/
public static function getUsers()
{
$conditional = self::buildConditional();
$limit = self::buildLimit();
$query = new \TaskerMAN\Core\DBQuery("SELECT \r\n\t\t\t`users`.`id`,\r\n\t\t\t`users`.`name`,\r\n\t\t\t`users`.`email`,\r\n\t\t\t`users`.`admin`\r\n\r\n\t\t\tFROM `users`\r\n\r\n\t\t\t{$conditional}\r\n\r\n\t\t\t" . self::$sort . "\r\n\r\n\t\t\t{$limit}\r\n\t\t");
// Bind any conditional parameters
if (!is_null($conditional)) {
foreach (self::$search_criteria as $key => $criteria) {
if ($criteria['enabled']) {
$query->bindValue($criteria['parameter'], $criteria['value']);
}
}
}
$query->execute();
return $query->results();
}
/**
* Returns an array of steps associated with this task
*
* @return array $steps
*/
public function getSteps()
{
if (!empty($this->steps)) {
return $this->steps;
}
$query = new \TaskerMAN\Core\DBQuery("SELECT `id`, `title`, `comment`\r\n\t\t\tFROM `steps`\r\n\t\t\tWHERE `task_id` = ?\r\n\t\t");
$query->execute($this->id);
$this->steps = $query->results();
return $this->steps;
}
/**
* Returns number of tasks assigned to each user
*
* @return array statistics
*/
public static function getTaskDistribution()
{
$query = new \TaskerMAN\Core\DBQuery("SELECT \r\n\t\t\t`tasks`.`assignee_uid`,\r\n\t\t\tCOUNT(*) AS `count`,\r\n\t\t\t`users`.`name`\r\n\t\t\tFROM `tasks` \r\n\t\t\tJOIN `users` ON `users`.`id` = `tasks`.`assignee_uid`\r\n\t\t\tGROUP BY `tasks`.`assignee_uid`\r\n\t\t");
$query->execute();
return $query->results();
}
