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);
}
