public function executeManageForms(\Library\HttpRequest $rq)
{
// Set $current_project for breadcrumb
$sessionProject = \Applications\PMTool\Helpers\ProjectHelper::GetCurrentSessionProject($this->app()->user());
$sessionTask = \Applications\PMTool\Helpers\TaskHelper::GetCurrentSessionTask($this->user());
//Task tab status
$tab_status_arr = \Applications\PMTool\Helpers\TaskHelper::TabStatusFor($sessionTask);
$this->page->addVar(\Applications\PMTool\Resources\Enums\ViewVariables\Task::task_tab_status_keys, $tab_status_arr);
//Task tab status
//Analyte Matrix tab status
$showLabMatrixTabs = \Applications\PMTool\Helpers\TaskAnalyteMatrixHelper::DoesAnalytesAndLocationsExistsFor($sessionTask, $this, 'Lab');
$showFieldMatrixTabs = \Applications\PMTool\Helpers\TaskAnalyteMatrixHelper::DoesAnalytesAndLocationsExistsFor($sessionTask, $this, 'Field');
$this->page->addVar(\Applications\PMTool\Resources\Enums\ViewVariables\Task::task_show_lab_matrix, $showLabMatrixTabs);
$this->page->addVar(\Applications\PMTool\Resources\Enums\ViewVariables\Task::task_show_field_matrix, $showFieldMatrixTabs);
//Analyte Matrix tab status
\Applications\PMTool\Helpers\TaskHelper::SetActiveTab($this->user(), \Applications\PMTool\Resources\Enums\TaskTabKeys::FormsTab);
$sessionPm = \Applications\PMTool\Helpers\PmHelper::GetCurrentSessionPm($this->user());
//$pm_services = \Applications\PMTool\Helpers\ServiceHelper::GetPmServices($this, $sessionPm);
$masterForms = \Applications\PMTool\Helpers\FormHelper::GetMasterForms($this, $sessionProject);
$sessionProject = \Applications\PMTool\Helpers\ProjectHelper::GetCurrentSessionProject($this->app()->user());
$userForms = \Applications\PMTool\Helpers\FormHelper::GetUserForms($this, $sessionProject);
$sessionProject = \Applications\PMTool\Helpers\ProjectHelper::GetCurrentSessionProject($this->app()->user());
\Applications\PMTool\Helpers\FormHelper::GetProjectForms($this, $sessionProject);
$sessionProject = \Applications\PMTool\Helpers\ProjectHelper::GetCurrentSessionProject($this->app()->user());
$projectForms = \Applications\PMTool\Helpers\FormHelper::GetFormsFromProjectForms($this->user(), $sessionProject);
$taskForms = \Applications\PMTool\Helpers\FormHelper::GetTaskForms($this, $sessionTask);
$sessionTask = \Applications\PMTool\Helpers\TaskHelper::GetCurrentSessionTask($this->user());
if (isset($projectForms[\Applications\PMTool\Resources\Enums\ViewVariablesKeys::master_forms]) && !empty($projectForms[\Applications\PMTool\Resources\Enums\ViewVariablesKeys::master_forms])) {
$filteredMasterForms = \Applications\PMTool\Helpers\FormHelper::FilterFormsToExclude($projectForms[\Applications\PMTool\Resources\Enums\ViewVariablesKeys::master_forms], $taskForms, 'master_form_id');
}
if (isset($projectForms[\Applications\PMTool\Resources\Enums\ViewVariablesKeys::user_forms]) && !empty($projectForms[\Applications\PMTool\Resources\Enums\ViewVariablesKeys::user_forms])) {
$filteredUserForms = \Applications\PMTool\Helpers\FormHelper::FilterFormsToExclude($projectForms[\Applications\PMTool\Resources\Enums\ViewVariablesKeys::user_forms], $taskForms, 'user_form_id');
}
$taskForms = \Applications\PMTool\Helpers\FormHelper::GetFormsFromTaskForms($this->user(), $sessionProject, $sessionTask);
//$this->page->addVar("HasItemsToDisplay", \Applications\PMTool\Helpers\PmHelper::DoesPmHaveActiveServices($this->user()));
if (!empty($filteredMasterForms)) {
$filteredMasterForms = array(\Applications\PMTool\Resources\Enums\ViewVariablesKeys::master_forms => $filteredMasterForms);
} else {
$filteredMasterForms = array();
}
if (!empty($filteredUserForms)) {
$filteredUserForms = array(\Applications\PMTool\Resources\Enums\ViewVariablesKeys::user_forms => $filteredUserForms);
} else {
$filteredUserForms = array();
}
$templateForms = array_merge($filteredUserForms, $filteredMasterForms);
$data = array(\Applications\PMTool\Resources\Enums\ViewVariablesKeys::module => strtolower($this->module()), \Applications\PMTool\Resources\Enums\ViewVariablesKeys::categorized_list_right => $templateForms, \Applications\PMTool\Resources\Enums\ViewVariablesKeys::categorized_list_left => $taskForms, \Applications\PMTool\Resources\Enums\ViewVariablesKeys::properties_right => \Applications\PMTool\Helpers\FormHelper::SetPropertyNamesForDualList(), \Applications\PMTool\Resources\Enums\ViewVariablesKeys::properties_left => \Applications\PMTool\Helpers\FormHelper::SetPropertyNamesForDualList());
$this->page->addVar(\Applications\PMTool\Resources\Enums\ViewVariablesKeys::data, $data);
//tab status
$this->page->addVar(\Applications\PMTool\Resources\Enums\ViewVariablesKeys::tabStatus, \Applications\PMTool\Helpers\TaskHelper::GetTabsStatus($this->user()));
//form modules
$this->page->addVar(\Applications\PMTool\Resources\Enums\ViewVariablesKeys::form_modules, $this->app()->router()->selectedRoute()->phpModules());
$this->page->addVar(\Applications\PMTool\Resources\Enums\ViewVariablesKeys::currentProject, $sessionProject[\Library\Enums\SessionKeys::ProjectObject]);
$this->page->addVar(\Applications\PMTool\Resources\Enums\ViewVariablesKeys::currentPm, $sessionPm[\Library\Enums\SessionKeys::PmObject]);
$this->page->addVar(\Applications\PMTool\Resources\Enums\ViewVariablesKeys::currentTask, $sessionTask[\Library\Enums\SessionKeys::TaskObj]);
}
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"));
}
