public function processPageRightEdit($params) { $this->formHelper = new FormHelper(FormHelper::METHOD_POST); $pageID = isset($params[0]) ? $params[0] : null; $rightGroupModel = new RightGroupModel($this->cmsController->getDB()); $optsRightGroups = array(); foreach ($rightGroupModel->getRightGroups() as $g) { if ($g->isRoot() === true) { continue; } $optsRightGroups[$g->getID()] = $g->getGroupName(); } $this->formHelper->addField('rightgroup', null, FormHelper::TYPE_OPTION, true, array('missingError' => 'Please choose a group', 'invalidError' => 'Please choose a valid group', 'options' => $optsRightGroups)); $this->formHelper->addField('rights', null, FormHelper::TYPE_MULTIOPTIONS, false, array('missingError' => 'Please choose one or more rights', 'invalidError' => 'Please choose one or more valid rights', 'options' => array('read' => 'read', 'write' => 'write'))); $this->formHelper->addField('date_from', null, FormHelper::TYPE_DATE, true, array('missingError' => 'Please enter a date from where the group should have access', 'invalidError' => 'Please enter a valid date from where the group should habe acess')); $this->formHelper->addField('date_to', null, FormHelper::TYPE_DATE, false, array('invalidError' => 'Please enter a valid date till when the group should habe acess')); if (!$this->formHelper->sent() || !$this->formHelper->validate()) { return $this->getPageRightEdit($params); } $dateFrom = $this->formHelper->getFieldValue('date_from'); $dateTo = $this->formHelper->getFieldValue('date_to'); if ($dateFrom !== null) { $dtFrom = new \DateTime($this->formHelper->getFieldValue('date_from')); } if ($dateTo !== null) { $dtTo = new \DateTime($this->formHelper->getFieldValue('date_to')); } $rights = $this->formHelper->getFieldValue('rights'); try { $stmntSaveRightGroup = $this->cmsController->getDB()->prepare("\n\t\t\t\tINSERT INTO page_has_rightgroup SET page_IDFK = ?, rightgroup_IDFK = ?, start_date = ?, end_date = ?, rights = ?\n\t\t\t\tON DUPLICATE KEY UPDATE start_date = ?, end_date = ?, rights = ?\n\t\t\t"); $this->cmsController->getDB()->insert($stmntSaveRightGroup, array($pageID, $this->formHelper->getFieldValue('rightgroup'), $dateFrom !== null ? $dtFrom->format('Y-m-d H:i:s') : null, $dateTo !== null ? $dtTo->format('Y-m-d H:i:s') : null, CmsUtils::getRightsAsDec(in_array('read', $rights) ? '1' : '0', in_array('write', $rights) ? '1' : '0'), $dateFrom !== null ? $dtFrom->format('Y-m-d H:i:s') : null, $dateTo !== null ? $dtTo->format('Y-m-d H:i:s') : null, CmsUtils::getRightsAsDec(in_array('read', $rights) ? '1' : '0', in_array('write', $rights) ? '1' : '0'))); } catch (\Exception $e) { $this->formHelper->addError(null, 'Could not save right information'); } if ($this->formHelper->hasErrors()) { return $this->getPageRightEdit($params); } RequestHandler::redirect($this->baseLink . '/page/' . $pageID); }
public function postEditNavHasEntry($params) { $this->formHelper = $this->generateFormEditNavHasEntry(); if (!$this->formHelper->sent() || $this->formHelper->validate() === false) { return $this->getEditNav($params); } try { $this->cmsController->getDB()->beginTransaction(); $navID = $params[0]; $entryID = $params[1]; // Get old hidden states $stmntHidden = $this->cmsController->getDB()->prepare("\n\t\t\t\tSELECT navigation_entry_IDFK, hidden FROM navigation_has_entry WHERE navigation_IDFK = ? AND parent_navigation_entry_IDFK = ?\n\t\t\t"); $resHidden = $this->cmsController->getDB()->select($stmntHidden, array($navID, $entryID)); $hiddenStates = array(); foreach ($resHidden as $h) { $hiddenStates[$h->navigation_entry_IDFK] = $h->hidden; } $stmntDelete = $this->cmsController->getDB()->prepare("\n\t\t\t\tDELETE FROM navigation_has_entry WHERE navigation_IDFK = ? AND parent_navigation_entry_IDFK = ?\n\t\t\t"); $this->cmsController->getDB()->delete($stmntDelete, array($navID, $entryID)); $stmntInsert = $this->cmsController->getDB()->prepare("\n\t\t\t\tINSERT INTO navigation_has_entry SET navigation_IDFK = ?, navigation_entry_IDFK = ?, parent_navigation_entry_IDFK = ?, sort = ?, hidden = ?\n\t\t\t"); foreach ($this->formHelper->getFieldValue('entries') as $i => $e) { $this->cmsController->getDB()->insert($stmntInsert, array($navID, $e, $entryID, $i + 1, isset($hiddenStates[$e]) && $hiddenStates[$e] == 1 ? 1 : 0)); } $stmntUpdateThisEntry = $this->cmsController->getDB()->prepare("\n\t\t\t\tUPDATE navigation_has_entry SET hidden = ? WHERE navigation_IDFK = ? AND navigation_entry_IDFK = ?\n\t\t\t"); $this->cmsController->getDB()->update($stmntUpdateThisEntry, array($this->formHelper->getFieldValue('hidden'), $navID, $entryID)); $this->cmsController->getDB()->commit(); } catch (\Exception $e) { if ($e->getCode() === 23000) { $errorMsg = 'The navigation entry <b>#' . $entryID . '</b> is already used in this navigation. Each navigation entry can only be used once per navigation.'; } else { $errorMsg = 'Could not save navigation: ' . $e->getMessage(); } $this->formHelper->addError(null, $errorMsg); $this->cmsController->getDB()->rollBack(); return $this->getEditNavHasEntry($params); } RequestHandler::redirect($this->baseLink . '/nav/' . $navID . '/edit'); }