/** * Execute the action * * @return void */ public function execute() { // call parent, this will probably add some general CSS/JS or other required files parent::execute(); // get parameters $questionId = SpoonFilter::getPostValue('questionId', null, '', 'int'); $fromCategoryId = SpoonFilter::getPostValue('fromCategoryId', null, '', 'int'); $toCategoryId = SpoonFilter::getPostValue('toCategoryId', null, '', 'int'); $fromCategorySequence = SpoonFilter::getPostValue('fromCategorySequence', null, '', 'string'); $toCategorySequence = SpoonFilter::getPostValue('toCategorySequence', null, '', 'string'); // invalid question id if (!BackendFaqModel::existsQuestion($questionId)) { $this->output(self::BAD_REQUEST, null, 'question does not exist'); } // list ids $fromCategorySequence = (array) explode(',', ltrim($fromCategorySequence, ',')); $toCategorySequence = (array) explode(',', ltrim($toCategorySequence, ',')); // is the question moved to a new category? if ($fromCategoryId != $toCategoryId) { // build item $item['id'] = $questionId; $item['category_id'] = $toCategoryId; // update the category BackendFaqModel::updateQuestion($item); // loop id's and set new sequence foreach ($toCategorySequence as $i => $id) { // build item $item = array(); $item['id'] = (int) $id; $item['sequence'] = $i + 1; // update sequence if (BackendFaqModel::existsQuestion($item['id'])) { BackendFaqModel::updateQuestion($item); } } } // loop id's and set new sequence foreach ($fromCategorySequence as $i => $id) { // build item $item['id'] = (int) $id; $item['sequence'] = $i + 1; // update sequence if (BackendFaqModel::existsQuestion($item['id'])) { BackendFaqModel::updateQuestion($item); } } // success output $this->output(self::OK, null, 'sequence updated'); }
/** * Validate the form * * @return void */ private function validateForm() { // is the form submitted? if ($this->frm->isSubmitted()) { // cleanup the submitted fields, ignore fields that were added by hackers $this->frm->cleanupFields(); // validate fields $this->frm->getField('question')->isFilled(BL::err('QuestionIsRequired')); $this->frm->getField('answer')->isFilled(BL::err('AnswerIsRequired')); $this->frm->getField('categories')->isFilled(BL::err('CategoryIsRequired')); // no errors? if ($this->frm->isCorrect()) { // build item $item['id'] = $this->id; $item['language'] = $this->record['language']; $item['category_id'] = $this->frm->getField('categories')->getValue(); $item['question'] = $this->frm->getField('question')->getValue(); $item['answer'] = $this->frm->getField('answer')->getValue(true); $item['hidden'] = $this->frm->getField('hidden')->getValue(); // update question values in database BackendFaqModel::updateQuestion($item); // trigger event BackendModel::triggerEvent($this->getModule(), 'after_edit', array('item' => $item)); // everything is saved, so redirect to the overview $this->redirect(BackendModel::createURLForAction('index') . '&report=saved&var=' . urlencode($item['question']) . '&highlight=row-' . $item['id']); } } }