QuestionnaireSpreadsheetView Class Reference

Public Member Functions
	QuestionnaireSpreadsheetView ($mgr)
	getSpreadsheetResponses ($responses, $questionnaireAnswers, $qPk)
	buildTable ($spreadsheetResponses, $questions)
	writeScript ()
	drawView ()

Public Attributes
	$mgr
	$table
	$spreadsheetResponses

Detailed Description

Definition at line 35 of file questionnaire_spreadsheet_view.inc.

Member Function Documentation

buildTable()

QuestionnaireSpreadsheetView::buildTable	(		$spreadsheetResponses,
			$questions
	)

Definition at line 109 of file questionnaire_spreadsheet_view.inc.

     {
          $table = new DataListView($spreadsheetResponses, "questionnaireSpreadsheet");
          $table->column($this->mgr->getRespondentColumnHeading(), $this->mgr->getRespondentColumnFormat(), true, "width: 40px");
 
          $this->mgr->addRespondentAdditionalColumns($table);
          
          if(count($questions) > 0)
          {
               $idx = 1;
               foreach($questions as $question)
               {
                    $title = ($question->question_name) ? ellipsis(stripHTML($question->question_name), 80) :  ellipsis(stripHTML($question->question), 80);
                    $table->column("{$title}", "{answer_$idx}", false, "width: 120px");
                    $idx++;
               }
          }
 
          $width = (120 * $idx )+ 40;
 
          $table->emptyMessage = "There are no responses to this questionnaire.";
          $table->sortable = true;
          $table->paginate = false;
          $table->dragColumnReorder = true;
          $table->filter = false;
          $table->cssStyle = "width: {$width}px; font-size: 10px; white-space: normal;";
          $table->excelFile = "questionnaireSpreadsheet.xls";
 
          return $table;
     }

drawView()

QuestionnaireSpreadsheetView::drawView

(

)

Definition at line 145 of file questionnaire_spreadsheet_view.inc.

     {
          $this->table->drawView();
     }

getSpreadsheetResponses()

QuestionnaireSpreadsheetView::getSpreadsheetResponses	(		$responses,
			$questionnaireAnswers,
			$qPk
	)

Definition at line 55 of file questionnaire_spreadsheet_view.inc.

     {
          if(count($responses) == 0)
          {
               return;
          }
          
          $pk = $responses[0]->primary_key;
          $answers = reindexList($questionnaireAnswers, $pk);
          $responseManager = $this->mgr->getResponseManager($responses[0]);
 
          $view = new QuestionnaireForm($responseManager);
 
          /*
          * Reuse the same view obj for each response, replacing only the response
          * obj and the set of answers, not re-retrieving the question set.
          */
          foreach($responses as $response)
          {
               // Don't reinstantiate the responseManager,
               // just give it the new obj.
               $responseManager->item = $response;
               $responseAnswers = $answers[$response->$pk];
               if(!is_array($responseAnswers))
               $responseAnswers = array($responseAnswers);
               $view->answers = reindexList($responseAnswers, $qPk);
                    
               $idx = 1;
               $spreadsheetResponse = new SpreadsheetResponse();
     
               $fields = $spreadsheetResponse->getFields();
               $values = array();
                    
               $values["name"] = $responseManager->getRespondent();
               $fields[$pk] = Number;
               $values[$pk] = $response->$pk;
                    
               foreach($view->questions as $question)
               {
                    $fields["answer_{$idx}"] = String;
                    $values["answer_{$idx}"] = $question->getSpreadSheetAnswer();
                    $idx++;
               }
               $spreadsheetResponse->fields = $fields;
                    
               // Assign each field its value.
               foreach($spreadsheetResponse->fields as $name => $type)
               $spreadsheetResponse->$name = $values[$name];
 
               $spreadsheetResponses[] = $spreadsheetResponse;
          }
          return $spreadsheetResponses;
     }

QuestionnaireSpreadsheetView()

QuestionnaireSpreadsheetView::QuestionnaireSpreadsheetView

(

$mgr

)

Definition at line 41 of file questionnaire_spreadsheet_view.inc.

     {
          $this->mgr = $mgr;
          $this->spreadsheetResponses = $this->getSpreadsheetResponses($mgr->Responses(), $mgr->getAnswers(), $mgr->getQuestionKey());
          $this->table = $this->buildTable($this->spreadsheetResponses, $mgr->getQuestions());
     }

writeScript()

QuestionnaireSpreadsheetView::writeScript

(

)

Definition at line 140 of file questionnaire_spreadsheet_view.inc.

     {
          return $this->table->writeScript();
     }

Member Data Documentation

$mgr

QuestionnaireSpreadsheetView::$mgr

Definition at line 37 of file questionnaire_spreadsheet_view.inc.

$spreadsheetResponses

QuestionnaireSpreadsheetView::$spreadsheetResponses

Definition at line 39 of file questionnaire_spreadsheet_view.inc.

$table

QuestionnaireSpreadsheetView::$table

Definition at line 38 of file questionnaire_spreadsheet_view.inc.

---

The documentation for this class was generated from the following file:

• C:/code/cms.sonjara.com/cms/components/questionnaire/questionnaire_spreadsheet_view.inc