public static function GetProjectForms($caller, $sessionProject)
{
$result = array();
if ($sessionProject !== NULL) {
$projectForm = new \Applications\PMTool\Models\Dao\Project_form();
$projectId = $sessionProject[\Library\Enums\SessionKeys::ProjectObject]->project_id();
$projectForm->setProject_id($projectId);
$manager = $caller->managers()->getManagerOf("ProjectForm");
$result = $sessionProject[\Library\Enums\SessionKeys::ProjectForms] = $manager->selectMany($projectForm, "project_id");
\Applications\PMTool\Helpers\ProjectHelper::SetCurrentSessionProject($caller->user(), $sessionProject);
}
return $result;
}
public static function SetCurrentProjectIfPmHasOnlyOneAndReturnProjects(\Library\User $user)
{
$projects = \Applications\PMTool\Helpers\ProjectHelper::GetSessionProjects($user);
$pm = \Applications\PMTool\Helpers\PmHelper::GetCurrentSessionPm($user);
$project_ids = count($pm[\Library\Enums\SessionKeys::PmProjectIds]) > 0 ? $pm[\Library\Enums\SessionKeys::PmProjectIds] : FALSE;
if (count($projects) === 1 && $project_ids !== FALSE) {
\Applications\PMTool\Helpers\ProjectHelper::SetCurrentSessionProject($user, $projects[\Library\Enums\SessionKeys::ProjectKey . $project_ids[0]]);
} else {
if (count($projects) > 1 && $project_ids !== FALSE) {
$project_objects = \Applications\PMTool\Helpers\CommonHelper::GetListObjectsInSessionByKey($user, \Library\Enums\SessionKeys::ProjectObject);
$project = \Applications\PMTool\Helpers\CommonHelper::FindObjectByIntValue(1, 'project_is_default', $project_objects);
if ($project !== false) {
\Applications\PMTool\Helpers\ProjectHelper::SetCurrentSessionProject($user, $projects[\Library\Enums\SessionKeys::ProjectKey . $project->project_id()]);
}
}
}
return $projects;
}
public function executeDelete(\Library\HttpRequest $rq)
{
// Init result
$result = $this->InitResponseWS();
$pm = \Applications\PMTool\Helpers\PmHelper::GetCurrentSessionPm($this->user());
$sessionProject = \Applications\PMTool\Helpers\ProjectHelper::GetCurrentSessionProject($this->app()->user());
$sessionTask = \Applications\PMTool\Helpers\TaskHelper::GetCurrentSessionTask($this->user());
$db_result = FALSE;
$form_id = intval($this->dataPost["form_id"]);
if ($this->dataPost["form_type"] == "user_form") {
//Check if the service to be deleted is the Project manager's
$form_selected = \Applications\PMTool\Helpers\FormHelper::GetAUserForm($this->user(), $form_id);
//Load interface to query the database
if ($form_selected !== NULL) {
$manager = $this->managers->getManagerOf("UserForm");
$manager->setRootDirectory($this->app()->config()->get(\Library\Enums\AppSettingKeys::RootDocumentUpload));
$manager->setWebDirectory($this->app()->config()->get(\Library\Enums\AppSettingKeys::BaseUrl) . $this->app()->config()->get(\Library\Enums\AppSettingKeys::RootUploadsFolderPath));
$db_result = $manager->deleteWithFile($form_selected, "form_id");
if ($db_result) {
//since we don't have foreign keys set because this is a relationship between 3 tables we must manually delete all project_form records, we also need to manually remove task forms
//remove project forms from session
$relationProjectForms = \Applications\PMTool\Helpers\FormHelper::GetProjectForms($this, $sessionProject);
$filteredProjectForms = \Applications\PMTool\Helpers\FormHelper::FilterFormsByGivenId($relationProjectForms, 'user_form_id', $form_id);
$sessionProject[\Library\Enums\SessionKeys::ProjectForms] = $filteredProjectForms;
if ($sessionTask !== FALSE) {
$relationTaskForms = \Applications\PMTool\Helpers\FormHelper::GetTaskForms($this, $sessionTask);
$filteredTaskForms = \Applications\PMTool\Helpers\FormHelper::FilterFormsByGivenId($relationTaskForms, 'user_form_id', $form_id);
$sessionTask[\Library\Enums\SessionKeys::TaskForms] = $filteredTaskForms;
\Applications\PMTool\Helpers\TaskHelper::SetCurrentSessionTask($this->user(), $sessionTask);
}
//delete from db
$projectForm = new \Applications\PMTool\Models\Dao\Project_form();
$projectForm->setUser_form_id($form_id);
$manager = $this->managers->getManagerOf("ProjectForm");
$manager->delete($projectForm, "user_form_id");
$taskForm = new \Applications\PMTool\Models\Dao\Task_template_form();
$taskForm->setUser_form_id($form_id);
$manager = $this->managers->getManagerOf("TaskForm");
$manager->delete($taskForm, "user_form_id");
//remove user forms from session
$match = \Applications\PMTool\Helpers\CommonHelper::FindIndexInObjectListById($form_selected->form_id(), "form_id", $sessionProject[\Library\Enums\SessionKeys::ProjectAvailableForms], \Library\Enums\SessionKeys::ProjectUserForms);
unset($sessionProject[\Library\Enums\SessionKeys::ProjectAvailableForms][\Library\Enums\SessionKeys::ProjectUserForms][$match["key"]]);
\Applications\PMTool\Helpers\ProjectHelper::SetCurrentSessionProject($this->user(), $sessionProject);
}
}
} elseif ($this->dataPost["form_type"] == "master_form") {
//delete from db
//Project form
$projectForm = new \Applications\PMTool\Models\Dao\Project_form();
$projectForm->setMaster_form_id($form_id);
$manager = $this->managers->getManagerOf("ProjectForm");
$manager->delete($projectForm, "master_form_id");
//Task template form
$taskForm = new \Applications\PMTool\Models\Dao\Task_template_form();
$taskForm->setMaster_form_id($form_id);
$manager = $this->managers->getManagerOf("TaskForm");
$manager->delete($taskForm, "master_form_id");
//Now for the master form
$masterFormDAO = new \Applications\PMTool\Models\Dao\Master_form();
$masterFormDAO->setForm_id($form_id);
$dal = $this->managers()->getManagerOf("MasterForm");
$matchingForms = $dal->selectMany($masterFormDAO, "form_id");
$db_result = $dal->deleteWithFileV2($matchingForms[0], "form_id");
}
$this->SendResponseWS($result, array("resx_file" => \Applications\PMTool\Resources\Enums\ResxFileNameKeys::Form, "resx_key" => $this->action(), "step" => $db_result !== FALSE ? "success" : "error"));
}
