pageSize=100000; $_REQUEST['page']=1; } $this->loadSurveyResponses(); } public function excel(){ $dateHelper = Loader::helper('date'); $this->pageSize=0; $this->loadSurveyResponses(); $textHelper = Loader::helper('text'); $questionSet=$this->get('questionSet'); $answerSets=$this->get('answerSets'); $questions=$this->get('questions'); $surveys=$this->get('surveys'); $fileName=$textHelper->filterNonAlphaNum($surveys[$questionSet]['surveyName']); header("Content-Type: application/vnd.ms-excel"); header("Cache-control: private"); header("Pragma: public"); $date = date('Ymd'); header("Content-Disposition: inline; filename=".$fileName."_form_data_{$date}.xls"); header("Content-Title: ".$surveys[$questionSet]['surveyName']." Form Data Output - Run on {$date}"); echo "\r\n"; echo "\r\n"; echo "\r\n"; echo "\r\n"; $hasCBRow = false; foreach($questions as $questionId=>$question){ if ($question['inputType'] == 'checkboxlist') { $hasCBRow = true; } } echo ""; echo "\t\t\r\n"; echo "\r\n"; foreach($questions as $questionId=>$question){ if ($question['inputType'] == 'checkboxlist') { $options = explode('%%', $question['options']); echo "\t\t".'\r\n"; } echo ""; // checkbox row if ($hasCBRow) { echo ""; foreach($questions as $questionId=>$question){ if ($question['inputType'] == 'checkboxlist') { $options = explode('%%', $question['options']); foreach($options as $opt) { echo ""; } } } echo ""; } foreach($answerSets as $answerSetId=>$answerSet){ $questionNumber=0; $numQuestionsToShow=2; echo "\t\r\n"; echo "\t\t\r\n"; echo "\t\t\r\n"; foreach($questions as $questionId=>$question){ $questionNumber++; if ($question['inputType'] == 'checkboxlist'){ $options = explode('%%', $question['options']); $subanswers = explode(',', $answerSet['answers'][$questionId]['answer']); for ($i = 1; $i <= count($options); $i++) { echo "\t\t\r\n"; } }elseif($question['inputType']=='fileupload'){ echo "\t\t\r\n"; }else{ echo "\t\t\r\n"; } } echo "\t\r\n"; } echo "

Submitted Date	User	'."\r\n"; } else { echo "\t\t	"; } echo "\r\n"; } echo "\t\t\t".$questions[$questionId]['question']."\r\n"; echo "\t\t
{$opt}
". $dateHelper->getSystemDateTime($answerSet['created'])."	"; if ($answerSet['uID'] > 0) { $ui = UserInfo::getByID($answerSet['uID']); if (is_object($ui)) { echo $ui->getUserName(); } } echo "	\r\n"; if (in_array(trim($options[$i-1]), $subanswers)) { // echo "\t\t\t".$options[$i-1]."\r\n"; echo "x"; } else { echo "\t\t\t \r\n"; } echo "\t\t	\r\n"; $fID=intval($answerSet['answers'][$questionId]['answer']); $file=File::getByID($fID); if($fID && $file){ $fileVersion=$file->getApprovedVersion(); echo "\t\t\t".''.$fileVersion->getFileName().''."\r\n"; }else{ echo "\t\t\t".t('File not found')."\r\n"; } echo "\t\t	\r\n"; echo "\t\t\t".$answerSet['answers'][$questionId]['answer'].$answerSet['answers'][$questionId]['answerLong']."\r\n"; echo "\t\t

\r\n"; echo "\r\n"; echo "\r\n"; die; } private function loadSurveyResponses(){ $c=$this->getCollectionObject(); $db = Loader::db(); $tempMiniSurvey = new MiniSurvey(); $pageBase = DIR_REL . '/' . DISPATCHER_FILENAME . '?cID=' . $c->getCollectionID(); if( $_REQUEST['action'] == 'deleteForm' ){ if (!Loader::helper('validation/token')->validate('deleteForm')) { $this->error->add(t('Invalid Token.')); } else { $this->deleteForm($_REQUEST['bID'], $_REQUEST['qsID']); } } if( $_REQUEST['action'] == 'deleteFormAnswers' ){ if (!Loader::helper('validation/token')->validate('deleteFormAnswers')) { $this->error->add(t('Invalid Token.')); } else { $this->deleteFormAnswers($_REQUEST['qsID']); $this->redirect('/dashboard/reports/forms'); } } if( $_REQUEST['action'] == 'deleteResponse' ){ if (!Loader::helper('validation/token')->validate('deleteResponse')) { $this->error->add(t('Invalid Token.')); } else { $this->deleteAnswers($_REQUEST['asid']); } } //load surveys $surveysRS=FormBlockStatistics::loadSurveys($tempMiniSurvey); //index surveys by question set id $surveys=array(); while($survey=$surveysRS->fetchRow()){ //get Survey Answers $survey['answerSetCount'] = MiniSurvey::getAnswerCount( $survey['questionSetId'] ); $surveys[ $survey['questionSetId'] ] = $survey; } //load requested survey response if (!empty($_REQUEST['qsid'])) { $questionSet = intval(preg_replace('/[^[:alnum:]]/','',$_REQUEST['qsid'])); //get Survey Questions $questionsRS = MiniSurvey::loadQuestions($questionSet); $questions = array(); while( $question = $questionsRS->fetchRow() ){ $questions[$question['msqID']]=$question; } //get Survey Answers $answerSetCount = MiniSurvey::getAnswerCount($questionSet); //pagination $pageBaseSurvey = $pageBase.'&qsid='.$questionSet; $paginator = Loader::helper('pagination'); $sortBy = $_REQUEST['sortBy']; $paginator->init( (int) $_REQUEST['page'], $answerSetCount, $pageBaseSurvey.'&page=%pageNum%&sortBy='.$sortBy, $this->pageSize ); if ($this->pageSize>0) { $limit = $paginator->getLIMIT(); } else { $limit = ''; } $answerSets = FormBlockStatistics::buildAnswerSetsArray( $questionSet, $sortBy, $limit ); } $this->set('questions',$questions); $this->set('answerSets',$answerSets); $this->set('paginator',$paginator); $this->set('questionSet',$questionSet); $this->set('surveys',$surveys); } // SET UP DELETE FUNCTIONS HERE // DELETE SUBMISSIONS private function deleteAnswers($asID){ $db = Loader::db(); $v = array(intval($asID)); $q = 'DELETE FROM btFormAnswers WHERE asID = ?'; $r = $db->query($q, $v); $q = 'DELETE FROM btFormAnswerSet WHERE asID = ?'; $r = $db->query($q, $v); } //DELETE A FORM ANSWERS private function deleteFormAnswers($qsID){ $db = Loader::db(); $v = array(intval($qsID)); $q = 'SELECT asID FROM btFormAnswerSet WHERE questionSetId = ?'; $r = $db->query($q, $v); while ($row = $r->fetchRow()) { $asID = $row['asID']; $this->deleteAnswers($asID); } } //DELETE FORMS AND ALL SUBMISSIONS private function deleteForm($bID, $qsID){ $db = Loader::db(); $this->deleteFormAnswers($qsID); $v = array(intval($bID)); $q = 'DELETE FROM btFormQuestions WHERE bID = ?'; $r = $db->query($q, $v); $q = 'DELETE FROM btForm WHERE bID = ?'; $r = $db->query($q, $v); $q = 'DELETE FROM Blocks WHERE bID = ?'; $r = $db->query($q, $v); } }