<?php defined('C5_EXECUTE') or die("Access Denied."); use Concrete\Block\Form\MiniSurvey; //$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); ?> <script> <?php if (is_object($b->getProxyBlock())) { ?> var thisbID=parseInt(<?php echo $b->getProxyBlock()->getBlockID(); ?> ); <?php } else { ?> var thisbID=parseInt(<?php echo $b->getBlockID(); ?> ); <?php } ?> var thisbtID=parseInt(<?php
public function delete() { $db = Database::connection(); $deleteData['questionsIDs'] = []; $deleteData['strandedAnswerSetIDs'] = []; $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 $strandedAnswer) { $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; }