private function loadSurveyResponses(){ $c=$this->getCollectionObject(); $db = Loader::db(); $tempMiniSurvey = new MiniSurvey(); $pageBase=DIR_REL.'/' . DISPATCHER_FILENAME . '?cID='.$c->getCollectionID(); if( $_REQUEST['action'] == 'deleteForm' ){ $this->deleteForm($_REQUEST['bID'], $_REQUEST['qsID']); } if( $_REQUEST['action'] == 'deleteResponse' ){ $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( strlen($_REQUEST['qsid'])>0 ){ $questionSet=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( intval($_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); }