<?php defined('C5_EXECUTE') or die("Access Denied."); //$miniSurveyInfo['surveyName']= $bs->surveyName; $miniSurvey = new MiniSurvey($b); $miniSurveyInfo = $miniSurvey->getMiniSurveyBlockInfo($b->getBlockID()); MiniSurvey::questionCleanup(intval($miniSurveyInfo['questionSetId']), $b->getBlockID()); $u = new User(); $ui = UserInfo::getByID($u->uID); if (strlen(trim($miniSurveyInfo['recipientEmail'])) == 0) { $miniSurveyInfo['recipientEmail'] = $ui->uEmail; } ?> <script> var thisbID=parseInt(<?php echo $b->getBlockID(); ?> ); var thisbtID=parseInt(<?php echo $b->getBlockTypeID(); ?> ); </script> <?php $this->inc('styles_include.php', array('c' => $c, 'b' => $b, 'miniSurveyInfo' => $miniSurveyInfo, 'miniSurvey' => $miniSurvey, 'a' => $a, 'bt' => $bt)); $this->inc('form_setup_html.php', array('c' => $c, 'b' => $b, 'miniSurveyInfo' => $miniSurveyInfo, 'miniSurvey' => $miniSurvey, 'a' => $a, 'bt' => $bt));
function delete() { $db = Loader::db(); $deleteData['questionsIDs'] = array(); $deleteData['strandedAnswerSetIDs'] = array(); $miniSurvey = new MiniSurvey(); $info = $miniSurvey->getMiniSurveyBlockInfo($this->bID); //get all answer sets $q = "SELECT asID FROM {$this->btAnswerSetTablename} WHERE questionSetId = " . intval($info['questionSetId']); $answerSetsRS = $db->query($q); //delete the questions $deleteData['questionsIDs'] = $db->getAll("SELECT qID FROM {$this->btQuestionsTablename} WHERE questionSetId = " . intval($info['questionSetId']) . ' AND bID=' . intval($this->bID)); foreach ($deleteData['questionsIDs'] as $questionData) { $db->query("DELETE FROM {$this->btQuestionsTablename} WHERE qID=" . intval($questionData['qID'])); } //delete left over answers $strandedAnswerIDs = $db->getAll('SELECT fa.aID FROM `btFormAnswers` AS fa LEFT JOIN btFormQuestions as fq ON fq.msqID=fa.msqID WHERE fq.msqID IS NULL'); foreach ($strandedAnswerIDs as $strandedAnswerIDs) { $db->query('DELETE FROM `btFormAnswers` WHERE aID=' . intval($strandedAnswer['aID'])); } //delete the left over answer sets $deleteData['strandedAnswerSetIDs'] = $db->getAll('SELECT aset.asID FROM btFormAnswerSet AS aset LEFT JOIN btFormAnswers AS fa ON aset.asID=fa.asID WHERE fa.asID IS NULL'); foreach ($deleteData['strandedAnswerSetIDs'] as $strandedAnswerSetIDs) { $db->query('DELETE FROM btFormAnswerSet WHERE asID=' . intval($strandedAnswerSetIDs['asID'])); } //delete the form block $q = "delete from {$this->btTable} where bID = '{$this->bID}'"; $r = $db->query($q); parent::delete(); return $deleteData; }
function delete() { $db = Loader::db(); $miniSurvey = new MiniSurvey(); $info = $miniSurvey->getMiniSurveyBlockInfo($this->bID); //get all answer sets $q = "SELECT asID FROM {$this->btAnswerSetTablename} WHERE questionSetId = " . intval($info['questionSetId']); $answerSetsRS = $db->query($q); //delete the answers while ($answerSet = $answerSetsRS->fetchRow()) { $q = "delete from {$this->btAnswersTablename} where asID = " . intval($answerSet['asID']); $r = $db->query($q); } //delete the answer sets $q = "delete from {$this->btAnswerSetTablename} where questionSetId = " . intval($info['questionSetId']); $r = $db->query($q); //delete the questions $q = "delete from {$this->btQuestionsTablename} where questionSetId = " . intval($info['questionSetId']); $r = $db->query($q); //delete the form block $q = "delete from {$this->btTable} where bID = '{$this->bID}'"; $r = $db->query($q); }