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')); }