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