/** * Function responsible for deleting a question. * * @access public * @param string $action * @param int $surveyid * @param int $gid * @param int $qid * @return void */ public function delete($surveyid, $gid, $qid) { $clang = $this->getController()->lang; $surveyid = sanitize_int($surveyid); $gid = sanitize_int($gid); $qid = sanitize_int($qid); if (hasSurveyPermission($surveyid, 'surveycontent', 'delete')) { if (!isset($qid)) { $qid = returnGlobal('qid'); } LimeExpressionManager::RevertUpgradeConditionsToRelevance(NULL, $qid); // Check if any other questions have conditions which rely on this question. Don't delete if there are. // TMSW Conditions->Relevance: Allow such deletes - can warn about missing relevance separately. $ccresult = Conditions::model()->findAllByAttributes(array('cqid' => $qid)); $cccount = count($ccresult); foreach ($ccresult as $ccr) { $qidarray[] = $ccr->qid; } if (isset($qidarray)) { $qidlist = implode(", ", $qidarray); } // There are conditions dependent on this question if ($cccount) { $this->getController()->error($clang->gT("Question could not be deleted. There are conditions for other questions that rely on this question. You cannot delete this question until those conditions are removed")); } else { $row = Questions::model()->findByAttributes(array('qid' => $qid))->attributes; $gid = $row['gid']; // See if there are any conditions/attributes/answers/defaultvalues for this question, // and delete them now as well Conditions::model()->deleteAllByAttributes(array('qid' => $qid)); Question_attributes::model()->deleteAllByAttributes(array('qid' => $qid)); Answers::model()->deleteAllByAttributes(array('qid' => $qid)); $criteria = new CDbCriteria(); $criteria->addCondition('qid = :qid or parent_qid = :qid'); $criteria->params[':qid'] = $qid; Questions::model()->deleteAll($criteria); Defaultvalues::model()->deleteAllByAttributes(array('qid' => $qid)); Quota_members::model()->deleteAllByAttributes(array('qid' => $qid)); Questions::updateQuestionOrder($gid, $surveyid); $qid = ""; $postqid = ""; $_GET['qid'] = ""; } Yii::app()->session['flashmessage'] = $clang->gT("Question was successfully deleted."); $this->getController()->redirect($this->getController()->createUrl('admin/survey/view/surveyid/' . $surveyid . '/gid/' . $gid)); } else { Yii::app()->session['flashmessage'] = $clang->gT("You are not authorized to delete questions."); $this->getController()->redirect($this->getController()->createUrl('admin/survey/view/surveyid/' . $surveyid . '/gid/' . $gid)); } }