public function testInsertUserToProjects()
{
$table = new USVN_Db_Table_Users();
$obj = $table->fetchNew();
$obj->setFromArray(array('users_login' => 'TestOk', 'users_password' => 'password', 'users_firstname' => 'firstname', 'users_lastname' => 'lastname', 'users_email' => '*****@*****.**'));
$obj->save();
$users = $table->findByName("TestOk");
$table = new USVN_Db_Table_Projects();
$project = $table->fetchNew();
$project->setFromArray(array('projects_name' => 'InsertProjectOk', 'projects_start_date' => '1984-12-03 00:00:00'));
$project->save();
$projects = $table->findByName("InsertProjectOk");
$table->AddUserToProject($users, $projects);
$UserToProject = new USVN_Db_Table_UsersToProjects();
$this->assertEquals(count($UserToProject->fetchRow(array('users_id = ?' => $users->users_id, 'projects_id = ?' => $projects->projects_id))), 1);
$table->DeleteUserToProject($users, $projects);
$this->assertEquals(count($UserToProject->fetchRow(array('users_id = ?' => $users->users_id, 'projects_id = ?' => $projects->projects_id))), 0);
}
public function updateAction()
{
$data = $this->getProjectData($_POST);
if (empty($data)) {
$this->_redirect("/admin/project/new");
}
$table = new USVN_Db_Table_Projects();
$project = $table->fetchRow(array("projects_name = ?" => str_replace(USVN_URL_SEP, '/', $this->getRequest()->getParam('name'))));
if ($project === null) {
$this->_redirect("/admin/project/");
}
$identity = Zend_Auth::getInstance()->getIdentity();
$user_table = new USVN_Db_Table_Users();
$users = $user_table->fetchRow(array('users_login = ?' => $identity['username']));
if (isset($_POST['admin'])) {
$table->AddUserToProject($users, $project);
} else {
$table->DeleteUserToProject($users, $project);
}
$project->setFromArray($data);
try {
$project->save();
$this->_redirect("/admin/project/");
} catch (Exception $e) {
$this->view->project = $project;
$this->view->message = nl2br($e->getMessage());
$this->render('edit');
}
}
