/**
* Gets all inactive Users and returns an array of Userobjects
* @return array
*/
public function getAllInactiveUsers()
{
$sql = new Sql($this->dbAdapter);
$select = $sql->select('tbluser');
$select->where('freigeschaltet = 0')->order('timestamp ASC');
$stmt = $sql->prepareStatementForSqlObject($select);
$result = $stmt->execute();
if ($result instanceof ResultInterface && $result->isQueryResult() && $result->getAffectedRows()) {
$array = array();
$user = new User();
$user->exchangeArray($result->current());
array_push($array, $user);
// Minus 1 Because we already pushed 1 UserObject into the Array
for ($count = $result->count() - 1; $count > 0; $count--) {
$user = new User();
$user->exchangeArray($result->next());
array_push($array, $user);
}
return $array;
}
}
/**
* Get current User as Object
* @param int $id
* @return User
*/
protected function getUser($id)
{
$sql = new Sql($this->dbAdapter);
$select = $sql->select('tbluser');
$select->where(array('id = ?' => $id));
$stmt = $sql->prepareStatementForSqlObject($select);
$result = $stmt->execute();
$user = new User();
$user->exchangeArray($result->current());
return $user;
}
