public function allLeader($group_id, $type)
{
$type = $type ? 1 : 0;
$user_groups = new USVN_Db_Table_UsersToGroups();
$links = $user_groups->fetchAll(array('groups_id = ?' => $group_id, '(CASE WHEN is_leader THEN 1 ELSE 0 END) = ?' => $type));
if (count($links) === 0) {
return array();
}
$users = new USVN_Db_Table_Users();
$leaders = array();
foreach ($links as $link) {
array_push($leaders, $link->users_id);
}
return $users->find($leaders);
}
/**
* Create and save a user
*
* @return USVN_Db_Table_Row_User
*/
protected function createUser($login, $password = "******")
{
$table = new USVN_Db_Table_Users();
try {
$user = $table->insert(array("users_login" => $login, "users_password" => USVN_Crypt::crypt($password), 'users_firstname' => 'firstname', 'users_lastname' => 'lastname', 'users_email' => '*****@*****.**'));
$user = $table->find($user)->current();
return $user;
} catch (Exception $e) {
$this->fail($login . " : " . $e->getMessage());
}
}
public function test_edit()
{
$users = new USVN_Db_Table_Users();
$user = $users->find(3)->current();
$this->request->setParam('login', 'Indochine');
$this->runAction('edit');
$this->assertContains('Indochine', $this->getBody(), $this->getBody());
}
public function testUserUpdateOk()
{
$table = new USVN_Db_Table_Users();
$obj = $table->fetchNew();
$obj->setFromArray(array('users_login' => 'UpdateOk', 'users_password' => 'password', 'users_firstname' => 'firstname', 'users_lastname' => 'lastname', 'users_email' => '*****@*****.**'));
$id = $obj->save();
$obj = $table->find($id)->current();
$obj->setFromArray(array('users_login' => 'newUpdateOk', 'users_password' => 'newPassword', 'users_firstname' => 'newFirstname', 'users_lastname' => 'newLastname', 'users_email' => '*****@*****.**'));
$obj->save();
$this->assertFalse($table->isAUser('UpdateOk'));
$this->assertTrue($table->isAUser('newUpdateOk'));
}
