/**
* Outputs a certificate for some sort of completion element
*
* @param string $person_fullname The full name of the certificate recipient
* @param string $entity_name The name of the entity that is compelted
* @param string $certificatecode The unique certificate code
* @param string $date_string Date /time the certification was achieved
* @param string $curriculum_frequency the curriculum frequency
* @param string $expirydate A string representing the time that the
* certificate expires (optional).
*/
function certificate_output_completion($person_fullname, $entity_name, $certificatecode = '', $date_string, $expirydate = '', $curriculum_frequency = '', $border = '', $seal = '', $template = '')
{
global $CFG, $COURSE;
//use the TCPDF library
require_once $CFG->libdir . '/pdflib.php';
//global settings
$borders = 0;
$font = 'FreeSerif';
$large_font_size = 30;
$small_font_size = 16;
//create pdf
$pdf = new pdf('L', 'in', 'Letter');
//prevent the pdf from printing black bars
$pdf->print_header = false;
$pdf->print_footer = false;
//add main (only) page
$pdf->AddPage();
//draw the border
cm_certificate_check_data_path('borders');
if (file_exists($CFG->dirroot . '/curriculum/pix/certificate/borders/' . $border)) {
$pdf->Image($CFG->dirroot . '/curriculum/pix/certificate/borders/' . $border, 0.25, 0.25, 10.5, 8.0);
} else {
if (file_exists($CFG->dataroot . '/' . $COURSE->id . '/curriculum/pix/certificate/borders/' . $border)) {
$pdf->Image($CFG->dataroot . '/' . $COURSE->id . '/curriculum/pix/certificate/borders/' . $border, 0.25, 0.25, 10.5, 8.0);
}
}
//draw the seal
cm_certificate_check_data_path('seals');
if (file_exists($CFG->dirroot . '/curriculum/pix/certificate/seals/' . $seal)) {
$pdf->Image($CFG->dirroot . '/curriculum/pix/certificate/seals/' . $seal, 8.0, 5.8);
} else {
if (file_exists($CFG->dataroot . '/' . $COURSE->id . '/curriculum/pix/certificate/seals/' . $seal)) {
$pdf->Image($CFG->dataroot . '/' . $COURSE->id . '/curriculum/pix/certificate/seals/' . $seal, 8.0, 5.8);
}
}
//include template
cm_certificate_check_data_path('templates');
if (file_exists($CFG->dirroot . '/curriculum/pix/certificate/templates/' . $template)) {
include $CFG->dirroot . '/curriculum/pix/certificate/templates/' . $template;
} else {
if (file_exists($CFG->dataroot . '/' . $COURSE->id . '/curriculum/pix/certificate/templates/' . $template)) {
include $CFG->dirroot . '/curriculum/pix/certificate/templates/' . $template;
}
}
$pdf->Output();
}
/**
* displayResults builds html output to display the actual results from a survey
*
* @param mixed $outputs
* @param INT $results The number of results being displayed overall
* @param mixed $rt
* @param mixed $outputType
* @param mixed $surveyid
* @param mixed $sql
* @param mixed $usegraph
*/
protected function displayResults($outputs, $results, $rt, $outputType, $surveyid, $sql, $usegraph, $browse, $sLanguage)
{
/* Set up required variables */
$TotalCompleted = 0;
//Count of actually completed answers
$statisticsoutput = "";
$sDatabaseType = Yii::app()->db->getDriverName();
$tempdir = Yii::app()->getConfig("tempdir");
$tempurl = Yii::app()->getConfig("tempurl");
$firstletter = substr($rt, 0, 1);
$astatdata = array();
if ($usegraph == 1) {
//for creating graphs we need some more scripts which are included here
require_once APPPATH . '/third_party/pchart/pchart/pChart.class';
require_once APPPATH . '/third_party/pchart/pchart/pData.class';
require_once APPPATH . '/third_party/pchart/pchart/pCache.class';
$MyCache = new pCache($tempdir . '/');
}
switch ($outputType) {
case 'xls':
$xlsTitle = sprintf(gT("Field summary for %s"), html_entity_decode($outputs['qtitle'], ENT_QUOTES, 'UTF-8'));
$xlsDesc = html_entity_decode($outputs['qquestion'], ENT_QUOTES, 'UTF-8');
$this->xlsRow++;
$this->xlsRow++;
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $xlsTitle);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $xlsDesc);
$footXLS = array();
break;
case 'pdf':
$sPDFQuestion = flattenText($outputs['qquestion'], false, true);
$pdfTitle = $this->pdf->delete_html(sprintf(gT("Field summary for %s"), html_entity_decode($outputs['qtitle'], ENT_QUOTES, 'UTF-8')));
$titleDesc = $sPDFQuestion;
$this->pdf->AddPage('P', 'A4');
$this->pdf->Bookmark($sPDFQuestion, 1, 0);
$this->pdf->titleintopdf($pdfTitle, $sPDFQuestion);
$tablePDF = array();
$footPDF = array();
break;
case 'html':
//output
$statisticsoutput .= "<table class='statisticstable'>\n" . "\t<thead><tr><th colspan='4' align='center'><strong>" . sprintf(gT("Field summary for %s"), $outputs['qtitle']) . "</strong>" . "</th></tr>\n" . "\t<tr><th colspan='4' align='center'><strong>" . $outputs['qquestion'] . "</strong></th></tr>\n" . "\t<tr>\n\t\t<th width='50%' align='center' >";
break;
default:
break;
}
//loop though the array which contains all answer data
$ColumnName_RM = array();
foreach ($outputs['alist'] as $al) {
//picks out answer list ($outputs['alist']/$al)) that come from the multiple list above
if (isset($al[2]) && $al[2]) {
//handling for "other" option
if ($al[0] == gT("Other")) {
if ($outputs['qtype'] == '!' || $outputs['qtype'] == 'L') {
// It is better for single choice question types to filter on the number of '-oth-' entries, than to
// just count the number of 'other' values - that way with failing Javascript the statistics don't get messed up
/* This query selects a count of responses where "other" has been selected */
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE " . Yii::app()->db->quoteColumnName(substr($al[2], 0, strlen($al[2]) - 5)) . "='-oth-'";
} else {
//get data - select a count of responses where no answer is provided
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ";
$query .= $sDatabaseType == "mysql" ? Yii::app()->db->quoteColumnName($al[2]) . " != ''" : "NOT (" . Yii::app()->db->quoteColumnName($al[2]) . " LIKE '')";
}
} elseif ($outputs['qtype'] == "U" || $outputs['qtype'] == "T" || $outputs['qtype'] == "S" || $outputs['qtype'] == "Q" || $outputs['qtype'] == ";") {
$sDatabaseType = Yii::app()->db->getDriverName();
//free text answers
if ($al[0] == "Answer") {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ";
$query .= $sDatabaseType == "mysql" ? Yii::app()->db->quoteColumnName($al[2]) . " != ''" : "NOT (" . Yii::app()->db->quoteColumnName($al[2]) . " LIKE '')";
} elseif ($al[0] == "NoAnswer") {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ( ";
$query .= $sDatabaseType == "mysql" ? Yii::app()->db->quoteColumnName($al[2]) . " = '')" : " (" . Yii::app()->db->quoteColumnName($al[2]) . " LIKE ''))";
}
} elseif ($outputs['qtype'] == "O") {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ( ";
$query .= $sDatabaseType == "mysql" ? Yii::app()->db->quoteColumnName($al[2]) . " <> '')" : " (" . Yii::app()->db->quoteColumnName($al[2]) . " NOT LIKE ''))";
// all other question types
} else {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE " . Yii::app()->db->quoteColumnName($al[2]) . " =";
//ranking question?
if (substr($rt, 0, 1) == "R") {
$query .= " '{$al['0']}'";
} else {
$query .= " 'Y'";
}
}
} else {
if ($al[0] != "") {
//get more data
$sDatabaseType = Yii::app()->db->getDriverName();
if ($sDatabaseType == 'mssql' || $sDatabaseType == 'sqlsrv' || $sDatabaseType == 'dblib') {
// mssql cannot compare text blobs so we have to cast here
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE cast(" . Yii::app()->db->quoteColumnName($rt) . " as varchar)= '{$al['0']}'";
} else {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE " . Yii::app()->db->quoteColumnName($rt) . " = '{$al['0']}'";
}
} else {
// This is for the 'NoAnswer' case
// We need to take into account several possibilities
// * NoAnswer cause the participant clicked the NoAnswer radio
// ==> in this case value is '' or ' '
// * NoAnswer in text field
// ==> value is ''
// * NoAnswer due to conditions, or a page not displayed
// ==> value is NULL
if ($sDatabaseType == 'mssql' || $sDatabaseType == 'sqlsrv' || $sDatabaseType == 'dblib') {
// mssql cannot compare text blobs so we have to cast here
//$query = "SELECT count(*) FROM {{survey_$surveyid}} WHERE (".sanitize_int($rt)." IS NULL "
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ( " . "cast(" . Yii::app()->db->quoteColumnName($rt) . " as varchar) = '' " . "OR cast(" . Yii::app()->db->quoteColumnName($rt) . " as varchar) = ' ' )";
} else {
// $query = "SELECT count(*) FROM {{survey_$surveyid}} WHERE (".sanitize_int($rt)." IS NULL "
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ( " . " " . Yii::app()->db->quoteColumnName($rt) . " = '' " . "OR " . Yii::app()->db->quoteColumnName($rt) . " = ' ') ";
}
}
}
//check filter option
if (incompleteAnsFilterState() == "incomplete") {
$query .= " AND submitdate is null";
} elseif (incompleteAnsFilterState() == "complete") {
$query .= " AND submitdate is not null";
}
//check for any "sql" that has been passed from another script
if (!empty($sql)) {
$query .= " AND {$sql}";
}
//get data
$row = Yii::app()->db->createCommand($query)->queryScalar();
// $statisticsoutput .= "\n<!-- ($sql): $query -->\n\n";
//store temporarily value of answer count of question type '5' and 'A'.
$tempcount = -1;
//count can't be less han zero
//increase counter
$TotalCompleted += $row;
//"no answer" handling
if ($al[0] === "") {
$fname = gT("No answer");
} elseif ($al[0] === gT("Other") || $al[0] === "Answer" || $outputs['qtype'] === "O" && $al[0] === gT("Comments") || $outputs['qtype'] === "P") {
if ($outputs['qtype'] == "P") {
$sColumnName = $al[2] . "comment";
} else {
$sColumnName = $al[2];
}
$ColumnName_RM[] = $sColumnName;
if ($outputs['qtype'] == 'O') {
$TotalCompleted -= $row;
}
$fname = "{$al['1']}";
if ($browse === true) {
$fname .= " <input type='button' class='statisticsbrowsebutton' value='" . gT("Browse") . "' id='{$sColumnName}' />";
}
if ($browse === true && isset($_POST['showtextinline']) && $outputType == 'pdf') {
$headPDF2 = array();
$headPDF2[] = array(gT("ID"), gT("Response"));
$tablePDF2 = array();
$result2 = $this->_listcolumn($surveyid, $sColumnName);
foreach ($result2 as $row2) {
$tablePDF2[] = array($row2['id'], $row2['value']);
}
}
if ($browse === true && isset($_POST['showtextinline']) && $outputType == 'xls') {
$headXLS = array();
$tableXLS = array();
$headXLS[] = array(gT("ID"), gT("Response"));
$result2 = $this->_listcolumn($surveyid, $sColumnName);
foreach ($result2 as $row2) {
$tableXLS[] = array($row2['id'], $row2['value']);
}
}
} elseif ($outputs['qtype'] == "S" || $outputs['qtype'] == "U" || $outputs['qtype'] == "T" || $outputs['qtype'] == "Q") {
$headPDF = array();
$headPDF[] = array(gT("Answer"), gT("Count"), gT("Percentage"));
//show free text answers
if ($al[0] == "Answer") {
$fname = "{$al['1']}";
if ($browse === true) {
$fname .= " <input type='button' class='statisticsbrowsebutton' value='" . gT("Browse") . "' id='{$sColumnName}' />";
}
} elseif ($al[0] == "NoAnswer") {
$fname = "{$al['1']}";
}
$statisticsoutput .= "</th>\n" . "\t\t<th width='25%' align='center' >" . "<strong>" . gT("Count") . "</strong></th>\n" . "\t\t<th width='25%' align='center' >" . "<strong>" . gT("Percentage") . "</strong></th>\n" . "\t</tr></thead>\n";
if ($browse === true && isset($_POST['showtextinline']) && $outputType == 'pdf') {
$headPDF2 = array();
$headPDF2[] = array(gT("ID"), gT("Response"));
$tablePDF2 = array();
$result2 = $this->_listcolumn($surveyid, $sColumnName);
foreach ($result2 as $row2) {
$tablePDF2[] = array($row2['id'], $row2['value']);
}
}
} elseif (Yii::app()->getConfig('showaggregateddata') == 1) {
if (!isset($showheadline) || $showheadline != false) {
if ($outputs['qtype'] == "5" || $outputs['qtype'] == "A") {
switch ($outputType) {
case 'xls':
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Answer"));
$this->sheet->write($this->xlsRow, 1, gT("Count"));
$this->sheet->write($this->xlsRow, 2, gT("Percentage"));
$this->sheet->write($this->xlsRow, 3, gT("Sum"));
break;
case 'pdf':
$headPDF = array();
$headPDF[] = array(gT("Answer"), gT("Count"), gT("Percentage"), gT("Sum"));
break;
case 'html':
//four columns
$statisticsoutput .= "<strong>" . gT("Answer") . "</strong></th>\n" . "\t\t<th width='15%' align='center' >" . "<strong>" . gT("Count") . "</strong></th>\n" . "\t\t<th width='20%' align='center' >" . "<strong>" . gT("Percentage") . "</strong></th>\n" . "\t\t<th width='15%' align='center' >" . "<strong>" . gT("Sum") . "</strong></th>\n" . "\t</tr></thead>\n";
break;
default:
break;
}
$showheadline = false;
} else {
switch ($outputType) {
case 'xls':
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Answer"));
$this->sheet->write($this->xlsRow, 1, gT("Count"));
$this->sheet->write($this->xlsRow, 2, gT("Percentage"));
break;
case 'pdf':
$headPDF = array();
$headPDF[] = array(gT("Answer"), gT("Count"), gT("Percentage"));
break;
case 'html':
//three columns
$statisticsoutput .= "<strong>" . gT("Answer") . "</strong></td>\n" . "\t\t<th width='25%' align='center' >" . "<strong>" . gT("Count") . "</strong></th>\n" . "\t\t<th width='25%' align='center' >" . "<strong>" . gT("Percentage") . "</strong></th>\n" . "\t</tr></thead>\n";
break;
default:
break;
}
$showheadline = false;
}
}
//text for answer column is always needed
$fname = "{$al['1']} ({$al['0']})";
} else {
if (!isset($showheadline) || $showheadline != false) {
switch ($outputType) {
case 'xls':
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Answer"));
$this->sheet->write($this->xlsRow, 1, gT("Count"));
$this->sheet->write($this->xlsRow, 2, gT("Percentage"));
break;
case 'pdf':
$headPDF = array();
$headPDF[] = array(gT("Answer"), gT("Count"), gT("Percentage"));
break;
case 'html':
//three columns
$statisticsoutput .= "<strong>" . gT("Answer") . "</strong></th>\n" . "\t\t<th width='25%' align='center' >" . "<strong>" . gT("Count") . "</strong></th>\n" . "\t\t<th width='25%' align='center' >" . "<strong>" . gT("Percentage") . "</strong></th>\n" . "\t</tr></thead>\n";
break;
default:
break;
}
$showheadline = false;
}
//answer text
$fname = "{$al['1']} ({$al['0']})";
}
//are there some results to play with?
if ($results > 0) {
//calculate percentage
$gdata[] = $row / $results * 100;
} else {
//no data!
$gdata[] = "N/A";
}
//put absolute data into array
$grawdata[] = $row;
//put question title and code into array
$label[] = $fname;
//put only the code into the array
$justcode[] = $al[0];
//edit labels and put them into antoher array
//first check if $tempcount is > 0. If yes, $row has been modified and $tempcount has the original count.
if ($tempcount > -1) {
$lbl[wordwrap(FlattenText("{$al['1']}"), 25, "\n")] = $tempcount;
} else {
$lbl[wordwrap(FlattenText("{$al['1']}"), 25, "\n")] = $row;
}
}
//end foreach -> loop through answer data
//no filtering of incomplete answers and NO multiple option questions
//if ((incompleteAnsFilterState() != "complete") and ($outputs['qtype'] != "M") and ($outputs['qtype'] != "P"))
//error_log("TIBO ".print_r($showaggregated_indice_table,true));
if ($outputs['qtype'] != "M" and $outputs['qtype'] != "P") {
//is the checkbox "Don't consider NON completed responses (only works when Filter incomplete answers is Disable)" checked?
//if (isset($_POST[''noncompleted']) and ($_POST['noncompleted'] == "on") && (isset(Yii::app()->getConfig('showaggregateddata')) && Yii::app()->getConfig('showaggregateddata') == 0))
// TIBO: TODO WE MUST SKIP THE FOLLOWING SECTION FOR TYPE A and 5 when
// showaggreagated data is set and set to 1
if (isset($_POST['noncompleted']) and $_POST['noncompleted'] == "on") {
//counter
$i = 0;
while (isset($gdata[$i])) {
if (isset($showaggregated_indice_table[$i]) && $showaggregated_indice_table[$i] == "aggregated") {
// do nothing, we don't rewrite aggregated results
// or at least I don't know how !!! (lemeur)
} else {
//we want to have some "real" data here
if ($gdata[$i] != "N/A") {
//calculate percentage
$gdata[$i] = $grawdata[$i] / $TotalCompleted * 100;
}
}
//increase counter
$i++;
}
//end while (data available)
} else {
//calculate total number of incompleted records
$TotalIncomplete = $results - $TotalCompleted;
//output
if (incompleteAnsFilterState() != "complete") {
$fname = gT("Not completed or Not displayed");
} else {
$fname = gT("Not displayed");
}
//we need some data
if ($results > 0) {
//calculate percentage
$gdata[] = $TotalIncomplete / $results * 100;
} else {
$gdata[] = "N/A";
}
//put data of incompleted records into array
$grawdata[] = $TotalIncomplete;
//put question title ("Not completed") into array
$label[] = $fname;
//put the code ("Not completed") into the array
$justcode[] = $fname;
//edit labels and put them into another array
if (incompleteAnsFilterState() != "complete") {
$lbl[wordwrap(flattenText(gT("Not completed or Not displayed")), 20, "\n")] = $TotalIncomplete;
} else {
$lbl[wordwrap(flattenText(gT("Not displayed")), 20, "\n")] = $TotalIncomplete;
}
}
//end else -> noncompleted NOT checked
}
// For multi question type, we have to check non completed with ALL sub question set to NULL
if ($outputs['qtype'] == "M" or $outputs['qtype'] == "P") {
$criteria = new CDbCriteria();
foreach ($outputs['alist'] as $al) {
$criteria->addCondition(Yii::app()->db->quoteColumnName($al[2]) . " IS NULL");
}
if (incompleteAnsFilterState() == "incomplete") {
$criteria->addCondition("submitdate IS NULL");
} elseif (incompleteAnsFilterState() == "complete") {
$criteria->addCondition("submitdate IS NOT NULL");
}
$multiNotDisplayed = SurveyDynamic::model($surveyid)->count($criteria);
if (isset($_POST['noncompleted']) and $_POST['noncompleted'] == "on") {
//counter
$i = 0;
while (isset($gdata[$i])) {
//we want to have some "real" data here
if ($gdata[$i] != "N/A") {
//calculate percentage
if ($results > $multiNotDisplayed) {
$gdata[$i] = $grawdata[$i] / ($results - $multiNotDisplayed) * 100;
} else {
$gdata[$i] = "N/A";
}
}
$i++;
}
} else {
// Add a line with not displayed %
if ($multiNotDisplayed > 0) {
if (incompleteAnsFilterState() != "complete") {
$fname = gT("Not completed or Not displayed");
} else {
$fname = gT("Not displayed");
}
$label[] = $fname;
//we need some data
if ($results > 0) {
//calculate percentage
$gdata[] = $multiNotDisplayed / $results * 100;
} else {
$gdata[] = "N/A";
}
//put data of incompleted records into array
$grawdata[] = $multiNotDisplayed;
}
}
}
//counter
$i = 0;
//we need to know which item we are editing
$itemcounter = 1;
//loop through all available answers
while (isset($gdata[$i])) {
//repeat header (answer, count, ...) for each new question
unset($showheadline);
/*
* there are 3 colums:
*
* 1 (50%) = answer (title and code in brackets)
* 2 (25%) = count (absolute)
* 3 (25%) = percentage
*/
$statisticsoutput .= "\t<tr>\n\t\t<td align='center' >" . $label[$i] . "\n" . "\t\t</td>\n";
/*
* If there is a "browse" button in this label, let's make sure there's an extra row afterwards
* to store the columnlist
*
* */
if (strpos($label[$i], "class='statisticsbrowsebutton'")) {
$extraline = "<tr><td class='statisticsbrowsecolumn' colspan='3' style='display: none'>";
if ($outputs['qtype'] == 'P') {
$extraline .= "<div class='statisticsbrowsecolumn' id='columnlist_{$ColumnName_RM[$i]}'></div></td></tr>\n";
} else {
$extraline .= "<div class='statisticsbrowsecolumn' id='columnlist_{$sColumnName}'></div></td></tr>\n";
}
}
//output absolute number of records
$statisticsoutput .= "\t\t<td align='center' >" . $grawdata[$i] . "\n</td>";
//no data
if ($gdata[$i] === "N/A") {
switch ($outputType) {
case 'xls':
$label[$i] = flattenText($label[$i]);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $label[$i]);
$this->sheet->writeNumber($this->xlsRow, 1, $grawdata[$i]);
$this->sheet->writeNumber($this->xlsRow, 2, $gdata[$i] / 100, $this->xlsPercents);
break;
case 'pdf':
$tablePDF[] = array(flattenText($label[$i]), $grawdata[$i], sprintf("%01.2f", $gdata[$i]) . "%", "");
break;
case 'html':
//output when having no data
$statisticsoutput .= "\t\t<td align='center' >";
//percentage = 0
$statisticsoutput .= sprintf("%01.2f", $gdata[$i]) . "%";
$gdata[$i] = 0;
//check if we have to adjust ouput due to Yii::app()->getConfig('showaggregateddata') setting
if (Yii::app()->getConfig('showaggregateddata') == 1 && ($outputs['qtype'] == "5" || $outputs['qtype'] == "A")) {
$statisticsoutput .= "\t\t</td>";
} elseif ($outputs['qtype'] == "S" || $outputs['qtype'] == "U" || $outputs['qtype'] == "T" || $outputs['qtype'] == "Q") {
$statisticsoutput .= "</td>\n\t";
}
$statisticsoutput .= "</tr>\n";
//Close the row
if (isset($extraline)) {
$statisticsoutput .= $extraline;
}
break;
default:
break;
}
} else {
//check if data should be aggregated
if (Yii::app()->getConfig('showaggregateddata') == 1 && ($outputs['qtype'] == "5" || $outputs['qtype'] == "A")) {
//mark that we have done soemthing special here
$aggregated = true;
if ($results - $grawdata[5] > 0) {
$percentage = $grawdata[$i] / ($results - $grawdata[5]) * 100;
// Only answered
} else {
$percentage = 0;
}
switch ($itemcounter) {
case 1:
if ($results - $grawdata[5] > 0) {
$aggregatedPercentage = ($grawdata[0] + $grawdata[1]) / ($results - $grawdata[5]) * 100;
} else {
$aggregatedPercentage = 0;
}
break;
case 3:
$aggregatedPercentage = $percentage;
break;
case 5:
if ($results - $grawdata[5] > 0) {
$aggregatedPercentage = ($grawdata[3] + $grawdata[4]) / ($results - $grawdata[5]) * 100;
} else {
$aggregatedPercentage = 0;
}
break;
case 6:
case 7:
if ($results - $grawdata[5] > 0) {
$percentage = $grawdata[$i] / $results * 100;
// All results
} else {
$percentage = 0;
}
default:
$aggregatedPercentage = 'na';
break;
}
switch ($outputType) {
case 'xls':
$label[$i] = flattenText($label[$i]);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $label[$i]);
$this->sheet->writeNumber($this->xlsRow, 1, $grawdata[$i]);
$this->sheet->writeNumber($this->xlsRow, 2, $percentage / 100, $this->xlsPercents);
if ($aggregatedPercentage !== 'na') {
$this->sheet->writeNumber($this->xlsRow, 3, $aggregatedPercentage / 100, $this->xlsPercents);
}
break;
case 'pdf':
$label[$i] = flattenText($label[$i]);
if ($aggregatedPercentage !== 'na') {
$tablePDF[] = array($label[$i], $grawdata[$i], sprintf("%01.2f", $percentage) . "%", sprintf("%01.2f", $aggregatedPercentage) . "%");
} else {
$tablePDF[] = array($label[$i], $grawdata[$i], sprintf("%01.2f", $percentage) . "%", "");
}
break;
case 'html':
//output percentage
$statisticsoutput .= "\t\t<td align='center' >";
$statisticsoutput .= sprintf("%01.2f", $percentage) . "%</td>";
$statisticsoutput .= "\t\t<td align='center' >";
if ($aggregatedPercentage !== 'na') {
$statisticsoutput .= sprintf("%01.2f", $aggregatedPercentage) . "%";
} else {
$statisticsoutput .= ' ';
}
$statisticsoutput .= "</td>\t\t";
break;
default:
break;
}
if ($itemcounter == 5) {
// create new row "sum"
//calculate sum of items 1-5
$sumitems = $grawdata[0] + $grawdata[1] + $grawdata[2] + $grawdata[3] + $grawdata[4];
//special treatment for zero values
if ($sumitems > 0) {
$sumpercentage = "100.00";
} else {
$sumpercentage = "0";
}
//special treatment for zero values
if ($TotalCompleted > 0) {
$casepercentage = "100.00";
} else {
$casepercentage = "0";
}
switch ($outputType) {
case 'xls':
$footXLS[] = array(gT("Sum") . " (" . gT("Answers") . ")", $sumitems, $sumpercentage . "%", $sumpercentage . "%");
$footXLS[] = array(gT("Number of cases"), $TotalCompleted, $casepercentage . "%", "");
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Sum") . " (" . gT("Answers") . ")");
$this->sheet->writeNumber($this->xlsRow, 1, $sumitems);
$this->sheet->writeNumber($this->xlsRow, 2, $sumpercentage / 100, $this->xlsPercents);
$this->sheet->writeNumber($this->xlsRow, 3, $sumpercentage / 100, $this->xlsPercents);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Number of cases"));
$this->sheet->writeNumber($this->xlsRow, 1, $TotalCompleted);
$this->sheet->writeNumber($this->xlsRow, 2, $casepercentage / 100, $this->xlsPercents);
break;
case 'pdf':
$footPDF[] = array(gT("Sum") . " (" . gT("Answers") . ")", $sumitems, $sumpercentage . "%", $sumpercentage . "%");
$footPDF[] = array(gT("Number of cases"), $TotalCompleted, $casepercentage . "%", "");
break;
case 'html':
$statisticsoutput .= "\t\t \n\t</tr>\n";
$statisticsoutput .= "<tr><td align='center'><strong>" . gT("Sum") . " (" . gT("Answers") . ")</strong></td>";
$statisticsoutput .= "<td align='center' ><strong>" . $sumitems . "</strong></td>";
$statisticsoutput .= "<td align='center' ><strong>{$sumpercentage}%</strong></td>";
$statisticsoutput .= "<td align='center' ><strong>{$sumpercentage}%</strong></td>";
$statisticsoutput .= "\t\t \n\t</tr>\n";
$statisticsoutput .= "<tr><td align='center'>" . gT("Number of cases") . "</td>";
//German: "Fallzahl"
$statisticsoutput .= "<td align='center' >" . $TotalCompleted . "</td>";
$statisticsoutput .= "<td align='center' >{$casepercentage}%</td>";
//there has to be a whitespace within the table cell to display correctly
$statisticsoutput .= "<td align='center' > </td></tr>";
break;
default:
break;
}
}
} else {
switch ($outputType) {
case 'xls':
$label[$i] = flattenText($label[$i]);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $label[$i]);
$this->sheet->writeNumber($this->xlsRow, 1, $grawdata[$i]);
$this->sheet->writeNumber($this->xlsRow, 2, $gdata[$i] / 100, $this->xlsPercents);
break;
case 'pdf':
$label[$i] = flattenText($label[$i]);
$tablePDF[] = array($label[$i], $grawdata[$i], sprintf("%01.2f", $gdata[$i]) . "%", "");
break;
case 'html':
//output percentage
$statisticsoutput .= "\t\t<td align='center' >";
$statisticsoutput .= sprintf("%01.2f", $gdata[$i]) . "%";
$statisticsoutput .= "\t\t";
//end output per line. there has to be a whitespace within the table cell to display correctly
$statisticsoutput .= "\t\t </td>\n\t</tr>\n";
if (isset($extraline)) {
$statisticsoutput .= $extraline;
}
break;
default:
break;
}
}
}
//end else -> $gdata[$i] != "N/A"
//increase counter
$i++;
$itemcounter++;
//Clear extraline
unset($extraline);
}
//end while
//only show additional values when this setting is enabled
if (Yii::app()->getConfig('showaggregateddata') == 1) {
//it's only useful to calculate standard deviation and arithmetic means for question types
//5 = 5 Point Scale
//A = Array (5 Point Choice)
if ($outputs['qtype'] == "5" || $outputs['qtype'] == "A") {
$stddev = 0;
$stddevarray = array_slice($grawdata, 0, 5, true);
$am = 0;
//calculate arithmetic mean
if (isset($sumitems) && $sumitems > 0) {
//calculate and round results
//there are always 5 items
for ($x = 0; $x < 5; $x++) {
//create product of item * value
$am += ($x + 1) * $stddevarray[$x];
}
//prevent division by zero
if (isset($stddevarray) && array_sum($stddevarray) > 0) {
$am = round($am / array_sum($stddevarray), 2);
} else {
$am = 0;
}
//calculate standard deviation -> loop through all data
/*
* four steps to calculate the standard deviation
* 1 = calculate difference between item and arithmetic mean and multiply with the number of elements
* 2 = create sqaure value of difference
* 3 = sum up square values
* 4 = multiply result with 1 / (number of items)
* 5 = get root
*/
for ($j = 0; $j < 5; $j++) {
//1 = calculate difference between item and arithmetic mean
$diff = $j + 1 - $am;
//2 = create square value of difference
$squarevalue = square($diff);
//3 = sum up square values and multiply them with the occurence
//prevent divison by zero
if ($squarevalue != 0 && $stddevarray[$j] != 0) {
$stddev += $squarevalue * $stddevarray[$j];
}
}
//4 = multiply result with 1 / (number of items (=5))
//There are two different formulas to calculate standard derivation
//$stddev = $stddev / array_sum($stddevarray); //formula source: http://de.wikipedia.org/wiki/Standardabweichung
//prevent division by zero
if (array_sum($stddevarray) - 1 != 0 && $stddev != 0) {
$stddev = $stddev / (array_sum($stddevarray) - 1);
//formula source: http://de.wikipedia.org/wiki/Empirische_Varianz
} else {
$stddev = 0;
}
//5 = get root
$stddev = sqrt($stddev);
$stddev = round($stddev, 2);
}
switch ($outputType) {
case 'xls':
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Arithmetic mean"));
$this->sheet->writeNumber($this->xlsRow, 1, $am);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Standard deviation"));
$this->sheet->writeNumber($this->xlsRow, 1, $stddev);
break;
case 'pdf':
$tablePDF[] = array(gT("Arithmetic mean"), $am, '', '');
$tablePDF[] = array(gT("Standard deviation"), $stddev, '', '');
break;
case 'html':
//calculate standard deviation
$statisticsoutput .= "<tr><td align='center'>" . gT("Arithmetic mean") . "</td>";
//German: "Fallzahl"
$statisticsoutput .= "<td> </td><td align='center'> {$am}</td><td> </td></tr>";
$statisticsoutput .= "<tr><td align='center'>" . gT("Standard deviation") . "</td>";
//German: "Fallzahl"
$statisticsoutput .= "<td> </td><td align='center'>{$stddev}</td><td> </td></tr>";
break;
default:
break;
}
}
}
if ($outputType == 'pdf') {
//$tablePDF = array();
$tablePDF = array_merge_recursive($tablePDF, $footPDF);
$this->pdf->headTable($headPDF, $tablePDF);
//$this->pdf->tableintopdf($tablePDF);
// if(isset($footPDF))
// foreach($footPDF as $foot)
// {
// $footA = array($foot);
// $this->pdf->tablehead($footA);
// }
if (isset($headPDF2)) {
$this->pdf->headTable($headPDF2, $tablePDF2);
}
}
if ($outputType == 'xls' && (isset($headXLS) || isset($tableXLS))) {
if (isset($headXLS)) {
$this->xlsRow++;
$this->xlsRow++;
foreach ($headXLS as $aRow) {
$this->xlsRow++;
$iColumn = 0;
foreach ($aRow as $sValue) {
$this->sheet->write($this->xlsRow, $iColumn, $sValue, $this->formatBold);
$iColumn++;
}
}
}
if (isset($tableXLS)) {
foreach ($tableXLS as $aRow) {
$this->xlsRow++;
$iColumn = 0;
foreach ($aRow as $sValue) {
$this->sheet->write($this->xlsRow, $iColumn, $sValue);
$iColumn++;
}
}
}
}
if ($outputType == 'html') {
$statisticsoutput .= "<tr><td colspan='4' style=\"text-align:center\" id='statzone_{$rt}'>";
}
//-------------------------- PCHART OUTPUT ----------------------------
list($qsid, $qgid, $qqid) = explode("X", $rt, 3);
$qsid = $surveyid;
$aattr = getQuestionAttributeValues($outputs['parentqid'], substr($rt, 0, 1));
//PCHART has to be enabled and we need some data
if ($usegraph == 1) {
$bShowGraph = $aattr["statistics_showgraph"] == "1";
$bAllowPieChart = $outputs['qtype'] != "M" && $outputs['qtype'] != "P";
$bAllowMap = isset($aattr["location_mapservice"]) && $aattr["location_mapservice"] == "1";
$bShowMap = $bAllowMap && $aattr["statistics_showmap"] == "1";
$bShowPieChart = $bAllowPieChart && (isset($aattr["statistics_graphtype"]) && $aattr["statistics_graphtype"] == "1");
$astatdata[$rt] = array('id' => $rt, 'sg' => $bShowGraph, 'ap' => $bAllowPieChart, 'am' => $bAllowMap, 'sm' => $bShowMap, 'sp' => $bShowPieChart);
$stats = Yii::app()->session['stats'];
$stats[$rt] = array('lbl' => $lbl, 'gdata' => $gdata, 'grawdata' => $grawdata);
Yii::app()->session['stats'] = $stats;
if ($bShowGraph == true) {
$cachefilename = createChart($qqid, $qsid, $bShowPieChart, $lbl, $gdata, $grawdata, $MyCache, $sLanguage, $outputs['qtype']);
if ($cachefilename) {
//introduce new counter
if (!isset($ci)) {
$ci = 0;
}
//increase counter, start value -> 1
$ci++;
switch ($outputType) {
case 'xls':
/**
* No Image for Excel...
*/
break;
case 'pdf':
$this->pdf->AddPage('P', 'A4');
$this->pdf->titleintopdf($pdfTitle, $titleDesc);
$this->pdf->Image($tempdir . "/" . $cachefilename, 0, 70, 180, 0, '', Yii::app()->getController()->createUrl("admin/survey/sa/view/surveyid/" . $surveyid), 'B', true, 150, 'C', false, false, 0, true);
break;
case 'html':
$statisticsoutput .= "<img src=\"{$tempurl}/" . $cachefilename . "\" border='1' />";
$aattr = getQuestionAttributeValues($qqid, $firstletter);
if ($bShowMap) {
$statisticsoutput .= "<div id=\"statisticsmap_{$rt}\" class=\"statisticsmap\"></div>";
$agmapdata[$rt] = array("coord" => getQuestionMapData(substr($rt, 1), $qsid), "zoom" => $aattr['location_mapzoom'], "width" => $aattr['location_mapwidth'], "height" => $aattr['location_mapheight']);
}
break;
default:
break;
}
}
}
}
//close table/output
if ($outputType == 'html') {
// show this block only when we show graphs and are not in the public statics controller
// this is because the links don't work from that controller
if ($usegraph == 1 && get_class(Yii::app()->getController()) !== 'Statistics_userController') {
$sImgUrl = Yii::app()->getConfig('adminimageurl');
$statisticsoutput .= "</td></tr><tr><td colspan='4'><div id='stats_{$rt}' class='graphdisplay' style=\"text-align:center\">" . "<img class='stats-hidegraph' src='{$sImgUrl}/chart_disabled.png' title='" . gT("Disable chart") . "' />" . "<img class='stats-showgraph' src='{$sImgUrl}/chart.png' title='" . gT("Enable chart") . "' />" . "<img class='stats-showbar' src='{$sImgUrl}/chart_bar.png' title='" . gT("Display as bar chart") . "' />" . "<img class='stats-showpie' src='{$sImgUrl}/chart_pie.png' title='" . gT("Display as pie chart") . "' />" . "<img class='stats-showmap' src='{$sImgUrl}/map_disabled.png' title='" . gT("Disable map display") . "' />" . "<img class='stats-hidemap' src='{$sImgUrl}/map.png' title='" . gT("Enable map display") . "' />" . "</div></td></tr>";
}
$statisticsoutput .= "</td></tr></table><br /> \n";
}
return array("statisticsoutput" => $statisticsoutput, "pdf" => $this->pdf, "astatdata" => $astatdata);
}
/**
* displayResults builds html output to display the actual results from a survey
*
* @param mixed $outputs
* @param INT $results The number of results being displayed overall
* @param mixed $rt
* @param mixed $outputType
* @param mixed $surveyid
* @param mixed $sql
* @param mixed $usegraph
*
*
*/
protected function displayResults($outputs, $results, $rt, $outputType, $surveyid, $sql, $usegraph, $browse, $sLanguage)
{
/* Set up required variables */
$TotalCompleted = 0;
//Count of actually completed answers
$statisticsoutput = "";
$sDatabaseType = Yii::app()->db->getDriverName();
$tempdir = Yii::app()->getConfig("tempdir");
$tempurl = Yii::app()->getConfig("tempurl");
$firstletter = substr($rt, 0, 1);
$astatdata = array();
if ($usegraph == 1 && $outputType != 'html') {
//for creating graphs we need some more scripts which are included here
require_once APPPATH . '/third_party/pchart/pchart/pChart.class';
require_once APPPATH . '/third_party/pchart/pchart/pData.class';
require_once APPPATH . '/third_party/pchart/pchart/pCache.class';
$MyCache = new pCache($tempdir . '/');
}
switch ($outputType) {
case 'xls':
$xlsTitle = sprintf(gT("Field summary for %s"), html_entity_decode($outputs['qtitle'], ENT_QUOTES, 'UTF-8'));
$xlsDesc = html_entity_decode($outputs['qquestion'], ENT_QUOTES, 'UTF-8');
$this->xlsRow++;
$this->xlsRow++;
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $xlsTitle);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $xlsDesc);
$footXLS = array();
break;
case 'pdf':
$sPDFQuestion = flattenText($outputs['qquestion'], false, true);
$pdfTitle = $this->pdf->delete_html(sprintf(gT("Field summary for %s"), html_entity_decode($outputs['qtitle'], ENT_QUOTES, 'UTF-8')));
$titleDesc = $sPDFQuestion;
$this->pdf->AddPage('P', 'A4');
$this->pdf->Bookmark($sPDFQuestion, 1, 0);
$this->pdf->titleintopdf($pdfTitle, $sPDFQuestion);
$tablePDF = array();
$footPDF = array();
break;
case 'html':
// output now generated in subview _statisticsoutuput_header
break;
default:
break;
}
//loop though the array which contains all answer data
$ColumnName_RM = array();
//echo '<pre>'; var_dump($outputs['alist']); echo '</pre>';die;
foreach ($outputs['alist'] as $al) {
//picks out answer list ($outputs['alist']/$al)) that come from the multiple list above
if (isset($al[2]) && $al[2]) {
//handling for "other" option
if ($al[0] == gT("Other")) {
if ($outputs['qtype'] == '!' || $outputs['qtype'] == 'L') {
// It is better for single choice question types to filter on the number of '-oth-' entries, than to
// just count the number of 'other' values - that way with failing Javascript the statistics don't get messed up
/* This query selects a count of responses where "other" has been selected */
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE " . Yii::app()->db->quoteColumnName(substr($al[2], 0, strlen($al[2]) - 5)) . "='-oth-'";
} else {
//get data - select a count of responses where no answer is provided
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ";
$query .= $sDatabaseType == "mysql" ? Yii::app()->db->quoteColumnName($al[2]) . " != ''" : "NOT (" . Yii::app()->db->quoteColumnName($al[2]) . " LIKE '')";
}
} elseif ($outputs['qtype'] == "U" || $outputs['qtype'] == "T" || $outputs['qtype'] == "S" || $outputs['qtype'] == "Q" || $outputs['qtype'] == ";") {
$sDatabaseType = Yii::app()->db->getDriverName();
//free text answers
if ($al[0] == "Answer") {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ";
$query .= $sDatabaseType == "mysql" ? Yii::app()->db->quoteColumnName($al[2]) . " != ''" : "NOT (" . Yii::app()->db->quoteColumnName($al[2]) . " LIKE '')";
} elseif ($al[0] == "NoAnswer") {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ( ";
$query .= $sDatabaseType == "mysql" ? Yii::app()->db->quoteColumnName($al[2]) . " = '')" : " (" . Yii::app()->db->quoteColumnName($al[2]) . " LIKE ''))";
}
} elseif ($outputs['qtype'] == "O") {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ( ";
$query .= $sDatabaseType == "mysql" ? Yii::app()->db->quoteColumnName($al[2]) . " <> '')" : " (" . Yii::app()->db->quoteColumnName($al[2]) . " NOT LIKE ''))";
// all other question types
} else {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE " . Yii::app()->db->quoteColumnName($al[2]) . " =";
//ranking question?
if (substr($rt, 0, 1) == "R") {
$query .= " '{$al['0']}'";
} else {
$query .= " 'Y'";
}
}
} else {
if ($al[0] != "") {
//get more data
$sDatabaseType = Yii::app()->db->getDriverName();
if ($sDatabaseType == 'mssql' || $sDatabaseType == 'sqlsrv' || $sDatabaseType == 'dblib') {
// mssql cannot compare text blobs so we have to cast here
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE cast(" . Yii::app()->db->quoteColumnName($rt) . " as varchar)= '{$al['0']}'";
} else {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE " . Yii::app()->db->quoteColumnName($rt) . " = '{$al['0']}'";
}
} else {
// This is for the 'NoAnswer' case
// We need to take into account several possibilities
// * NoAnswer cause the participant clicked the NoAnswer radio
// ==> in this case value is '' or ' '
// * NoAnswer in text field
// ==> value is ''
// * NoAnswer due to conditions, or a page not displayed
// ==> value is NULL
if ($sDatabaseType == 'mssql' || $sDatabaseType == 'sqlsrv' || $sDatabaseType == 'dblib') {
// mssql cannot compare text blobs so we have to cast here
//$query = "SELECT count(*) FROM {{survey_$surveyid}} WHERE (".sanitize_int($rt)." IS NULL "
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ( " . "cast(" . Yii::app()->db->quoteColumnName($rt) . " as varchar) = '' " . "OR cast(" . Yii::app()->db->quoteColumnName($rt) . " as varchar) = ' ' )";
} elseif ($sDatabaseType == 'pgsql') {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ( " . " " . Yii::app()->db->quoteColumnName($rt) . "::text = '' " . "OR " . Yii::app()->db->quoteColumnName($rt) . "::text = ' ') ";
} else {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ( " . " " . Yii::app()->db->quoteColumnName($rt) . " = '' " . "OR " . Yii::app()->db->quoteColumnName($rt) . " = ' ') ";
}
}
}
//check filter option
if (incompleteAnsFilterState() == "incomplete") {
$query .= " AND submitdate is null";
} elseif (incompleteAnsFilterState() == "complete") {
$query .= " AND submitdate is not null";
}
//check for any "sql" that has been passed from another script
if (!empty($sql)) {
$query .= " AND {$sql}";
}
//get data
$row = Yii::app()->db->createCommand($query)->queryScalar();
//store temporarily value of answer count of question type '5' and 'A'.
$tempcount = -1;
//count can't be less han zero
//increase counter
$TotalCompleted += $row;
//"no answer" handling
if ($al[0] === "") {
$fname = gT("No answer");
} elseif ($al[0] === gT("Other") || $al[0] === "Answer" || $outputs['qtype'] === "O" && $al[0] === gT("Comments") || $outputs['qtype'] === "P") {
if ($outputs['qtype'] == "P") {
$sColumnName = $al[2] . "comment";
} else {
$sColumnName = $al[2];
}
$ColumnName_RM[] = $sColumnName;
if ($outputs['qtype'] == 'O') {
$TotalCompleted -= $row;
}
$fname = "{$al['1']}";
if ($browse === true) {
$fname .= " <input type='button' class='statisticsbrowsebutton btn btn-default btn-large' value='" . gT("Browse") . "' id='{$sColumnName}' />";
}
if ($browse === true && isset($_POST['showtextinline']) && $outputType == 'pdf') {
$headPDF2 = array();
$headPDF2[] = array(gT("ID"), gT("Response"));
$tablePDF2 = array();
$result2 = $this->_listcolumn($surveyid, $sColumnName);
foreach ($result2 as $row2) {
$tablePDF2[] = array($row2['id'], $row2['value']);
}
}
if ($browse === true && isset($_POST['showtextinline']) && $outputType == 'xls') {
$headXLS = array();
$tableXLS = array();
$headXLS[] = array(gT("ID"), gT("Response"));
$result2 = $this->_listcolumn($surveyid, $sColumnName);
foreach ($result2 as $row2) {
$tableXLS[] = array($row2['id'], $row2['value']);
}
}
} elseif ($outputs['qtype'] == "S" || $outputs['qtype'] == "U" || $outputs['qtype'] == "T" || $outputs['qtype'] == "Q") {
$headPDF = array();
$headPDF[] = array(gT("Answer"), gT("Count"), gT("Percentage"));
//show free text answers
if ($al[0] == "Answer") {
$fname = "{$al['1']}";
if ($browse === true) {
$fname .= " <input type='button' class='statisticsbrowsebutton btn btn-default btn-large' value='" . gT("Browse") . "' id='{$sColumnName}' />";
}
} elseif ($al[0] == "NoAnswer") {
$fname = "{$al['1']}";
}
$bShowCount = true;
$bShowPercentage = true;
$bAnswer = true;
// For view
$bSum = false;
if ($browse === true && isset($_POST['showtextinline']) && $outputType == 'pdf') {
$headPDF2 = array();
$headPDF2[] = array(gT("ID"), gT("Response"));
$tablePDF2 = array();
$result2 = $this->_listcolumn($surveyid, $sColumnName);
foreach ($result2 as $row2) {
$tablePDF2[] = array($row2['id'], $row2['value']);
}
}
} elseif (Yii::app()->getConfig('showaggregateddata') == 1) {
if (!isset($showheadline) || $showheadline != false) {
if ($outputs['qtype'] == "5" || $outputs['qtype'] == "A") {
switch ($outputType) {
case 'xls':
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Answer"));
$this->sheet->write($this->xlsRow, 1, gT("Count"));
$this->sheet->write($this->xlsRow, 2, gT("Percentage"));
$this->sheet->write($this->xlsRow, 3, gT("Sum"));
break;
case 'pdf':
$headPDF = array();
$headPDF[] = array(gT("Answer"), gT("Count"), gT("Percentage"), gT("Sum"));
break;
case 'html':
//four columns
$bShowCount = true;
$bShowPercentage = true;
$bAnswer = true;
$bSum = true;
break;
default:
break;
}
$showheadline = false;
} else {
switch ($outputType) {
case 'xls':
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Answer"));
$this->sheet->write($this->xlsRow, 1, gT("Count"));
$this->sheet->write($this->xlsRow, 2, gT("Percentage"));
break;
case 'pdf':
$headPDF = array();
$headPDF[] = array(gT("Answer"), gT("Count"), gT("Percentage"));
break;
case 'html':
//three columns
$bAnswer = true;
// For view
$bSum = false;
$bShowCount = true;
$bShowPercentage = true;
break;
default:
break;
}
$showheadline = false;
}
}
//text for answer column is always needed
$fname = "{$al['1']} ({$al['0']})";
} else {
if (!isset($showheadline) || $showheadline != false) {
switch ($outputType) {
case 'xls':
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Answer"));
$this->sheet->write($this->xlsRow, 1, gT("Count"));
$this->sheet->write($this->xlsRow, 2, gT("Percentage"));
break;
case 'pdf':
$headPDF = array();
$headPDF[] = array(gT("Answer"), gT("Count"), gT("Percentage"));
break;
case 'html':
//three columns
$bAnswer = true;
// For view
$bSum = false;
$bShowCount = true;
$bShowPercentage = true;
break;
default:
break;
}
$showheadline = false;
}
//answer text
$fname = "{$al['1']} ({$al['0']})";
}
//are there some results to play with?
if ($results > 0) {
//calculate percentage
$gdata[] = $row / $results * 100;
} else {
//no data!
$gdata[] = "N/A";
}
//put absolute data into array
$grawdata[] = $row;
if (!(in_array('is_comment', $al) || in_array('is_no_answer', $al))) {
$grawdata_percents[] = $row;
}
//var_dump($grawdata); die();
//put question title and code into array
$label[] = $fname;
//put only the code into the array
$justcode[] = $al[0];
//edit labels and put them into antoher array
//first check if $tempcount is > 0. If yes, $row has been modified and $tempcount has the original count.
if ($tempcount > -1) {
$flatLabel = wordwrap(FlattenText("{$al['1']}"), 25, "\n");
// If the flatten label is empty (like for picture, or HTML, etc.)
// We replace it by the subquestion code
if ($flatLabel == '') {
$flatLabel = $al[0];
}
// For legend
$lbl[$flatLabel] = $tempcount;
} else {
$flatLabel = wordwrap(FlattenText("{$al['1']}"), 25, "\n");
// If the flatten label is empty (like for picture, or HTML, etc.)
// We replace it by the subquestion code
if ($flatLabel == '') {
$flatLabel = $al[0];
}
$lbl[$flatLabel] = $row;
}
// For Graph labels
switch ($_POST['graph_labels']) {
case 'qtext':
$aGraphLabels[] = $sFlatLabel = $flatLabel;
break;
case 'both':
$aGraphLabels[] = $sFlatLabel = $al[0] . ': ' . $flatLabel;
break;
default:
$aGraphLabels[] = $sFlatLabel = $al[0];
break;
}
if (!(in_array('is_comment', $al) || in_array('is_no_answer', $al))) {
$aGraphLabelsPercent[] = $sFlatLabel;
$lblPercent[$flatLabel] = $lbl[$flatLabel];
}
}
//end foreach -> loop through answer data
//no filtering of incomplete answers and NO multiple option questions
//if ((incompleteAnsFilterState() != "complete") and ($outputs['qtype'] != "M") and ($outputs['qtype'] != "P"))
//error_log("TIBO ".print_r($showaggregated_indice_table,true));
if ($outputs['qtype'] != "M" and $outputs['qtype'] != "P") {
//is the checkbox "Don't consider NON completed responses (only works when Filter incomplete answers is Disable)" checked?
//if (isset($_POST[''noncompleted']) and ($_POST['noncompleted'] == 1) && (isset(Yii::app()->getConfig('showaggregateddata')) && Yii::app()->getConfig('showaggregateddata') == 0))
// TIBO: TODO WE MUST SKIP THE FOLLOWING SECTION FOR TYPE A and 5 when
// showaggreagated data is set and set to 1
if (isset($_POST['noncompleted']) and $_POST['noncompleted'] == 1) {
//counter
$i = 0;
while (isset($gdata[$i])) {
if (isset($showaggregated_indice_table[$i]) && $showaggregated_indice_table[$i] == "aggregated") {
// do nothing, we don't rewrite aggregated results
// or at least I don't know how !!! (lemeur)
} else {
//we want to have some "real" data here
if ($gdata[$i] != "N/A") {
//calculate percentage
$gdata[$i] = $grawdata[$i] / $TotalCompleted * 100;
}
}
//increase counter
$i++;
}
//end while (data available)
} else {
//calculate total number of incompleted records
$TotalIncomplete = $results - $TotalCompleted;
//output
if (incompleteAnsFilterState() != "complete") {
$fname = gT("Not completed or Not displayed");
} else {
$fname = gT("Not displayed");
}
//we need some data
if ($results > 0) {
//calculate percentage
$gdata[] = $TotalIncomplete / $results * 100;
} else {
$gdata[] = "N/A";
}
//put data of incompleted records into array
$grawdata[] = $TotalIncomplete;
//put question title ("Not completed") into array
$label[] = $fname;
//put the code ("Not completed") into the array
$justcode[] = $fname;
//edit labels and put them into another array
if (incompleteAnsFilterState() != "complete") {
$flatLabel = gT("Not completed or Not displayed");
// If the flatten label is empty (like for picture, or HTML, etc.)
// We replace it by the subquestion code
if ($flatLabel == '') {
$flatLabel = $al[0];
}
$lbl[$flatLabel] = $TotalIncomplete;
} else {
$flatLabel = gT("Not displayed");
// If the flatten label is empty (like for picture, or HTML, etc.)
// We replace it by the subquestion code
if ($flatLabel == '') {
$flatLabel = $al[0];
}
$lbl[$flatLabel] = $TotalIncomplete;
}
}
//end else -> noncompleted NOT checked
}
// For multi question type, we have to check non completed with ALL sub question set to NULL
if ($outputs['qtype'] == "M" or $outputs['qtype'] == "P") {
$criteria = new CDbCriteria();
foreach ($outputs['alist'] as $al) {
$criteria->addCondition(Yii::app()->db->quoteColumnName($al[2]) . " IS NULL");
}
if (incompleteAnsFilterState() == "incomplete") {
$criteria->addCondition("submitdate IS NULL");
} elseif (incompleteAnsFilterState() == "complete") {
$criteria->addCondition("submitdate IS NOT NULL");
}
$multiNotDisplayed = SurveyDynamic::model($surveyid)->count($criteria);
if (isset($_POST['noncompleted']) and $_POST['noncompleted'] == 1) {
//counter
$i = 0;
while (isset($gdata[$i])) {
//we want to have some "real" data here
if ($gdata[$i] != "N/A") {
//calculate percentage
if ($results > $multiNotDisplayed) {
$gdata[$i] = $grawdata[$i] / ($results - $multiNotDisplayed) * 100;
} else {
$gdata[$i] = "N/A";
}
}
$i++;
}
} else {
// Add a line with not displayed %
if ($multiNotDisplayed > 0) {
if (incompleteAnsFilterState() != "complete") {
$fname = gT("Not completed or Not displayed");
} else {
$fname = gT("Not displayed");
}
$label[] = $fname;
$lbl[$fname] = $multiNotDisplayed;
//we need some data
if ($results > 0) {
//calculate percentage
$gdata[] = $multiNotDisplayed / $results * 100;
} else {
$gdata[] = "N/A";
}
//put data of incompleted records into array
$grawdata[] = $multiNotDisplayed;
}
}
}
// Columns
$statsColumns = $_POST['stats_columns'];
switch ($statsColumns) {
case "1":
$nbcols = "12";
$canvaWidth = "1150";
$canvaHeight = "800";
break;
case "3":
$nbcols = "4";
$canvaWidth = "333";
$canvaHeight = "500";
break;
default:
$nbcols = "6";
$canvaWidth = "500";
$canvaHeight = "500";
break;
}
//
//counter
$i = 0;
//we need to know which item we are editing
$itemcounter = 1;
$aData['nbcols'] = $nbcols;
$aData['canvaWidth'] = $canvaWidth;
$aData['canvaHeight'] = $canvaHeight;
$aData['outputs'] = isset($outputs) ? $outputs : '';
$aData['bSum'] = isset($bSum) ? $bSum : false;
$aData['bAnswer'] = isset($bAnswer) ? $bAnswer : false;
$aData['bShowCount'] = isset($bShowCount) ? $bShowCount : false;
$aData['bShowPercentage'] = isset($bShowPercentage) ? $bShowPercentage : false;
$statisticsoutput = Yii::app()->getController()->renderPartial('/admin/export/generatestats/_statisticsoutput_header', $aData, true);
//loop through all available answers
////
while (isset($gdata[$i])) {
$aData['i'] = $i;
///// We'll render at the end of this loop statisticsoutput_answer
//repeat header (answer, count, ...) for each new question
unset($showheadline);
/*
* there are 3 colums:
*
* 1 (50%) = answer (title and code in brackets)
* 2 (25%) = count (absolute)
* 3 (25%) = percentage
*/
/*
* If there is a "browse" button in this label, let's make sure there's an extra row afterwards
* to store the columnlist
*
* */
if (strpos($label[$i], "statisticsbrowsebutton")) {
$extraline = "<tr><td class='statisticsbrowsecolumn' colspan='3' style='display: none'>";
if ($outputs['qtype'] == 'P') {
$extraline .= "<div class='statisticsbrowsecolumn' id='columnlist_{$ColumnName_RM[$i]}'></div></td></tr>\n";
$sColumnNameForView = $ColumnName_RM[$i];
} else {
$extraline .= "<div class='statisticsbrowsecolumn' id='columnlist_{$sColumnName}'></div></td></tr>\n";
$sColumnNameForView = $sColumnName;
}
}
//no data
if ($gdata[$i] === "N/A") {
switch ($outputType) {
case 'xls':
$label[$i] = flattenText($label[$i]);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $label[$i]);
$this->sheet->writeNumber($this->xlsRow, 1, $grawdata[$i]);
$this->sheet->writeNumber($this->xlsRow, 2, $gdata[$i] / 100, $this->xlsPercents);
break;
case 'pdf':
$tablePDF[] = array(flattenText($label[$i]), $grawdata[$i], sprintf("%01.2f", $gdata[$i]) . "%", "");
break;
case 'html':
//output when having no data
/// _statisticsoutput_answer
$bNAgData = true;
if (isset($extraline)) {
$bNAgDataExtraLine = $extraline;
}
break;
default:
break;
}
} else {
//check if data should be aggregated
if (Yii::app()->getConfig('showaggregateddata') == 1 && ($outputs['qtype'] == "5" || $outputs['qtype'] == "A")) {
//mark that we have done soemthing special here
$aggregated = true;
if ($results - $grawdata[5] > 0) {
$percentage = $grawdata[$i] / ($results - $grawdata[5]) * 100;
// Only answered
} else {
$percentage = 0;
}
switch ($itemcounter) {
case 1:
if ($results - $grawdata[5] > 0) {
$aggregatedPercentage = ($grawdata[0] + $grawdata[1]) / ($results - $grawdata[5]) * 100;
} else {
$aggregatedPercentage = 0;
}
break;
case 3:
$aggregatedPercentage = $percentage;
break;
case 5:
if ($results - $grawdata[5] > 0) {
$aggregatedPercentage = ($grawdata[3] + $grawdata[4]) / ($results - $grawdata[5]) * 100;
} else {
$aggregatedPercentage = 0;
}
break;
case 6:
case 7:
if ($results - $grawdata[5] > 0) {
$percentage = $grawdata[$i] / $results * 100;
// All results
} else {
$percentage = 0;
}
default:
$aggregatedPercentage = 'na';
break;
}
switch ($outputType) {
case 'xls':
$label[$i] = flattenText($label[$i]);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $label[$i]);
$this->sheet->writeNumber($this->xlsRow, 1, $grawdata[$i]);
$this->sheet->writeNumber($this->xlsRow, 2, $percentage / 100, $this->xlsPercents);
if ($aggregatedPercentage !== 'na') {
$this->sheet->writeNumber($this->xlsRow, 3, $aggregatedPercentage / 100, $this->xlsPercents);
}
break;
case 'pdf':
$label[$i] = flattenText($label[$i]);
if ($aggregatedPercentage !== 'na') {
$tablePDF[] = array($label[$i], $grawdata[$i], sprintf("%01.2f", $percentage) . "%", sprintf("%01.2f", $aggregatedPercentage) . "%");
} else {
$tablePDF[] = array($label[$i], $grawdata[$i], sprintf("%01.2f", $percentage) . "%", "");
}
break;
case 'html':
//output percentage
$bNAgData = true;
if ($aggregatedPercentage !== 'na') {
$showAggregatedPercentage = true;
} else {
$showEmptyAggregatedPercentage = true;
}
break;
default:
break;
}
if ($itemcounter == 5) {
// new row "sum"
//calculate sum of items 1-5
$sumitems = $grawdata[0] + $grawdata[1] + $grawdata[2] + $grawdata[3] + $grawdata[4];
//special treatment for zero values
if ($sumitems > 0) {
$sumpercentage = "100.00";
} else {
$sumpercentage = "0";
}
//special treatment for zero values
if ($TotalCompleted > 0) {
$casepercentage = "100.00";
} else {
$casepercentage = "0";
}
switch ($outputType) {
case 'xls':
$footXLS[] = array(gT("Sum") . " (" . gT("Answers") . ")", $sumitems, $sumpercentage . "%", $sumpercentage . "%");
$footXLS[] = array(gT("Number of cases"), $TotalCompleted, $casepercentage . "%", "");
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Sum") . " (" . gT("Answers") . ")");
$this->sheet->writeNumber($this->xlsRow, 1, $sumitems);
$this->sheet->writeNumber($this->xlsRow, 2, $sumpercentage / 100, $this->xlsPercents);
$this->sheet->writeNumber($this->xlsRow, 3, $sumpercentage / 100, $this->xlsPercents);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Number of cases"));
$this->sheet->writeNumber($this->xlsRow, 1, $TotalCompleted);
$this->sheet->writeNumber($this->xlsRow, 2, $casepercentage / 100, $this->xlsPercents);
break;
case 'pdf':
$footPDF[] = array(gT("Sum") . " (" . gT("Answers") . ")", $sumitems, $sumpercentage . "%", $sumpercentage . "%");
$footPDF[] = array(gT("Number of cases"), $TotalCompleted, $casepercentage . "%", "");
break;
case 'html':
$bShowSumAnswer = true;
break;
default:
break;
}
}
} else {
switch ($outputType) {
case 'xls':
$label[$i] = flattenText($label[$i]);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $label[$i]);
$this->sheet->writeNumber($this->xlsRow, 1, $grawdata[$i]);
$this->sheet->writeNumber($this->xlsRow, 2, $gdata[$i] / 100, $this->xlsPercents);
break;
case 'pdf':
$label[$i] = flattenText($label[$i]);
$tablePDF[] = array($label[$i], $grawdata[$i], sprintf("%01.2f", $gdata[$i]) . "%", "");
break;
case 'html':
//output percentage
$bNAgData = true;
if (isset($extraline)) {
$bNAgDataExtraLine = $extraline;
}
break;
default:
break;
}
}
}
//end else -> $gdata[$i] != "N/A"
//increase counter
$i++;
$itemcounter++;
//Clear extraline
unset($extraline);
// Convert grawdata_percent to percent
if (isset($grawdata_percents)) {
$pTotal = array_sum($grawdata_percents);
if ($pTotal > 0) {
foreach ($grawdata_percents as $key => $data) {
$grawdata_percents[$key] = round($data / $pTotal * 100, 2);
}
}
} else {
$grawdata_percents = array();
}
///// HERE RENDER statisticsoutput_answer
$aData['label'] = $label;
$aData['grawdata'] = $grawdata;
$aData['grawdata_percent'] = $grawdata_percents;
$aData['gdata'] = $gdata;
$aData['extraline'] = isset($extraline) ? $extraline : false;
$aData['aggregated'] = isset($aggregated) ? $aggregated : false;
$aData['aggregatedPercentage'] = isset($aggregatedPercentage) ? $aggregatedPercentage : false;
$aData['sumitems'] = isset($sumitems) ? $sumitems : false;
$aData['sumpercentage'] = isset($sumpercentage) ? $sumpercentage : false;
$aData['TotalCompleted'] = isset($TotalCompleted) ? $TotalCompleted : false;
$aData['casepercentage'] = isset($casepercentage) ? $casepercentage : false;
$aData['bNAgData'] = isset($bNAgData) ? $bNAgData : false;
$aData['bNAgDataExtraLine'] = isset($bNAgDataExtraLine) ? $bNAgDataExtraLine : false;
$aData['showAggregatedPercentage'] = isset($showAggregatedPercentage) ? $showAggregatedPercentage : false;
$aData['showEmptyAggregatedPercentage'] = isset($showEmptyAggregatedPercentage) ? $showEmptyAggregatedPercentage : false;
$aData['bShowSumAnswer'] = isset($bShowSumAnswer) ? $bShowSumAnswer : false;
// Generate answer
// _statisticsoutput_answer
$statisticsoutput .= Yii::app()->getController()->renderPartial('/admin/export/generatestats/_statisticsoutput_answer', $aData, true);
$extraline = false;
$aggregated = false;
$aggregatedPercentage = false;
$sumitems = false;
$sumpercentage = false;
$TotalCompleted = false;
$casepercentage = false;
$bNAgData = false;
$bNAgDataExtraLine = false;
$showAggregatedPercentage = false;
$showEmptyAggregatedPercentage = false;
$bShowSumAnswer = false;
}
//end while
$aData['showaggregateddata'] = false;
//only show additional values when this setting is enabled
if (Yii::app()->getConfig('showaggregateddata') == 1) {
//it's only useful to calculate standard deviation and arithmetic means for question types
//5 = 5 Point Scale
//A = Array (5 Point Choice)
if ($outputs['qtype'] == "5" || $outputs['qtype'] == "A") {
$stddev = 0;
$stddevarray = array_slice($grawdata, 0, 5, true);
$am = 0;
//calculate arithmetic mean
if (isset($sumitems) && $sumitems > 0) {
//calculate and round results
//there are always 5 items
for ($x = 0; $x < 5; $x++) {
//create product of item * value
$am += ($x + 1) * $stddevarray[$x];
}
//prevent division by zero
if (isset($stddevarray) && array_sum($stddevarray) > 0) {
$am = round($am / array_sum($stddevarray), 2);
} else {
$am = 0;
}
//calculate standard deviation -> loop through all data
/*
* four steps to calculate the standard deviation
* 1 = calculate difference between item and arithmetic mean and multiply with the number of elements
* 2 = create sqaure value of difference
* 3 = sum up square values
* 4 = multiply result with 1 / (number of items)
* 5 = get root
*/
for ($j = 0; $j < 5; $j++) {
//1 = calculate difference between item and arithmetic mean
$diff = $j + 1 - $am;
//2 = create square value of difference
$squarevalue = square($diff);
//3 = sum up square values and multiply them with the occurence
//prevent divison by zero
if ($squarevalue != 0 && $stddevarray[$j] != 0) {
$stddev += $squarevalue * $stddevarray[$j];
}
}
//4 = multiply result with 1 / (number of items (=5))
//There are two different formulas to calculate standard derivation
//$stddev = $stddev / array_sum($stddevarray); //formula source: http://de.wikipedia.org/wiki/Standardabweichung
//prevent division by zero
if (array_sum($stddevarray) - 1 != 0 && $stddev != 0) {
$stddev = $stddev / (array_sum($stddevarray) - 1);
//formula source: http://de.wikipedia.org/wiki/Empirische_Varianz
} else {
$stddev = 0;
}
//5 = get root
$stddev = sqrt($stddev);
$stddev = round($stddev, 2);
}
switch ($outputType) {
case 'xls':
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Arithmetic mean"));
$this->sheet->writeNumber($this->xlsRow, 1, $am);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Standard deviation"));
$this->sheet->writeNumber($this->xlsRow, 1, $stddev);
break;
case 'pdf':
$tablePDF[] = array(gT("Arithmetic mean"), $am, '', '');
$tablePDF[] = array(gT("Standard deviation"), $stddev, '', '');
break;
case 'html':
//calculate standard deviation
$aData['am'] = $am;
$aData['stddev'] = $stddev;
$statisticsoutput .= Yii::app()->getController()->renderPartial('/admin/export/generatestats/_statisticsoutput_arithmetic', $aData, true);
break;
default:
break;
}
}
}
if ($outputType == 'pdf') {
//$tablePDF = array();
$tablePDF = array_merge_recursive($tablePDF, $footPDF);
if (!isset($headPDF)) {
// TODO: Why is $headPDF sometimes undefined here?
$headPDF = array();
}
$this->pdf->headTable($headPDF, $tablePDF);
//$this->pdf->tableintopdf($tablePDF);
// if(isset($footPDF))
// foreach($footPDF as $foot)
// {
// $footA = array($foot);
// $this->pdf->tablehead($footA);
// }
if (isset($headPDF2)) {
$this->pdf->headTable($headPDF2, $tablePDF2);
}
}
if ($outputType == 'xls' && (isset($headXLS) || isset($tableXLS))) {
if (isset($headXLS)) {
$this->xlsRow++;
$this->xlsRow++;
foreach ($headXLS as $aRow) {
$this->xlsRow++;
$iColumn = 0;
foreach ($aRow as $sValue) {
$this->sheet->write($this->xlsRow, $iColumn, $sValue, $this->formatBold);
$iColumn++;
}
}
}
if (isset($tableXLS)) {
foreach ($tableXLS as $aRow) {
$this->xlsRow++;
$iColumn = 0;
foreach ($aRow as $sValue) {
$this->sheet->write($this->xlsRow, $iColumn, $sValue);
$iColumn++;
}
}
}
}
if ($outputType == 'html') {
}
// _statisticsoutput_graphs.php
//-------------------------- PCHART OUTPUT ----------------------------
list($qsid, $qgid, $qqid) = explode("X", $rt, 3);
$qsid = $surveyid;
$aattr = getQuestionAttributeValues($outputs['parentqid'], substr($rt, 0, 1));
//PCHART has to be enabled and we need some data
//
if ($usegraph == 1) {
$bShowGraph = $aattr["statistics_showgraph"] == "1";
$bAllowPieChart = $outputs['qtype'] != "M" && $outputs['qtype'] != "P";
$bAllowMap = isset($aattr["location_mapservice"]) && $aattr["location_mapservice"] == "1";
$bShowMap = $bAllowMap && $aattr["statistics_showmap"] == "1";
$bShowPieChart = $bAllowPieChart && (isset($aattr["statistics_graphtype"]) && $aattr["statistics_graphtype"] == "1");
$astatdata[$rt] = array('id' => $rt, 'sg' => $bShowGraph, 'ap' => $bAllowPieChart, 'am' => $bAllowMap, 'sm' => $bShowMap, 'sp' => $bShowPieChart);
$stats = Yii::app()->session['stats'];
$stats[$rt] = array('lbl' => $lbl, 'gdata' => $gdata, 'grawdata' => $grawdata);
Yii::app()->session['stats'] = $stats;
if ($bShowGraph == true) {
$cachefilename = '';
if ($outputType == 'xls' || $outputType == 'pdf') {
$cachefilename = createChart($qqid, $qsid, $bShowPieChart, $lbl, $gdata, $grawdata, $MyCache, $sLanguage, $outputs['qtype']);
}
if ($cachefilename || $outputType == 'html') {
//introduce new counter
if (!isset($ci)) {
$ci = 0;
}
//increase counter, start value -> 1
$ci++;
switch ($outputType) {
case 'xls':
/**
* No Image for Excel...
*/
break;
case 'pdf':
$this->pdf->AddPage('P', 'A4');
$this->pdf->titleintopdf($pdfTitle, $titleDesc);
$this->pdf->Image($tempdir . "/" . $cachefilename, 0, 70, 180, 0, '', Yii::app()->getController()->createUrl("admin/survey/sa/view/surveyid/" . $surveyid), 'B', true, 150, 'C', false, false, 0, true);
break;
case 'html':
if (isset($aattr["statistics_graphtype"])) {
$req_chart_type = $aattr["statistics_graphtype"];
}
//// If user forced the chartype from statistics_view
if (isset($_POST['charttype']) && $_POST['charttype'] != 'default') {
$req_chart_type = $_POST['charttype'];
}
//// The value of the select box in the question advanced setting is numerical. So we need to translate it.
if (isset($req_chart_type)) {
switch ($req_chart_type) {
case '1':
$charttype = "Pie";
break;
case '2':
$charttype = "Radar";
break;
case '3':
$charttype = "Line";
break;
case '4':
$charttype = "PolarArea";
break;
case '5':
$charttype = "Doughnut";
break;
default:
$charttype = "Bar";
break;
}
}
//// Here the 72 colors of the original limesurvey palette.
//// This could be change by some user palette coming from database.
$COLORS_FOR_SURVEY = array('20,130,200', '232,95,51', '34,205,33', '210,211,28', '134,179,129', '201,171,131', '251,231,221', '23,169,161', '167,187,213', '211,151,213', '147,145,246', '147,39,90', '250,250,201', '201,250,250', '94,0,94', '250,125,127', '0,96,201', '201,202,250', '0,0,127', '250,0,250', '250,250,0', '0,250,250', '127,0,127', '127,0,0', '0,125,127', '0,0,250', '0,202,250', '201,250,250', '201,250,201', '250,250,151', '151,202,250', '251,149,201', '201,149,250', '250,202,151', '45,96,250', '45,202,201', '151,202,0', '250,202,0', '250,149,0', '250,96,0', '184,230,115', '102,128,64', '220,230,207', '134,191,48', '184,92,161', '128,64,112', '230,207,224', '191,48,155', '230,138,115', '128,77,64', '230,211,207', '191,77,48', '80,161,126', '64,128,100', '207,230,220', '48,191,130', '25,25,179', '18,18,125', '200,200,255', '145,145,255', '255,178,0', '179,125,0', '255,236,191', '255,217,128', '255,255,0', '179,179,0', '255,255,191', '255,255,128', '102,0,153', '71,0,107', '234,191,255', '213,128,255');
//// $lbl is generated somewhere upthere by the original code. We translate it for chartjs.
$labels = array();
foreach ($lbl as $name => $lb) {
$labels[] = $name;
}
if (isset($lblPercent)) {
foreach ($lblPercent as $name => $lb) {
$labels_percent[] = $name;
}
} else {
$labels_percent = array();
}
break;
default:
break;
}
}
}
}
//close table/output
if ($outputType == 'html') {
// show this block only when we show graphs and are not in the public statics controller
if ($usegraph == 1 && $bShowGraph && get_class(Yii::app()->getController()) !== 'Statistics_userController') {
// We clean the labels
$iMaxLabelLength = 0;
// We clean the labels
// Labels for graphs
$iMaxLabelLength = 0;
foreach ($aGraphLabels as $key => $label) {
$cleanLabel = $label;
$cleanLabel = viewHelper::flatEllipsizeText($cleanLabel, true, 20);
$graph_labels[$key] = $cleanLabel;
$iMaxLabelLength = strlen($cleanLabel) > $iMaxLabelLength ? strlen($cleanLabel) : $iMaxLabelLength;
}
if (isset($aGraphLabelsPercent)) {
foreach ($aGraphLabelsPercent as $key => $label) {
$cleanLabel = $label;
$cleanLabel = viewHelper::flatEllipsizeText($cleanLabel, true, 20);
$graph_labels_percent[$key] = $cleanLabel;
}
} else {
$graph_labels_percent = array();
}
$iCanvaHeight = $iMaxLabelLength * 3;
$aData['iCanvaHeight'] = $iCanvaHeight > 150 ? $iCanvaHeight : 150;
$qqid = str_replace('#', '_', $qqid);
$aData['rt'] = $rt;
$aData['qqid'] = $qqid;
$aData['graph_labels'] = $graph_labels;
$aData['graph_labels_percent'] = $labels_percent;
$aData['labels'] = $labels;
//$aData['COLORS_FOR_SURVEY'] = COLORS_FOR_SURVEY;
$aData['charttype'] = isset($charttype) ? $charttype : 'Bar';
$aData['sChartname'] = '';
$aData['grawdata'] = $grawdata;
$aData['color'] = rand(0, 70);
$aData['COLORS_FOR_SURVEY'] = $COLORS_FOR_SURVEY;
$aData['lbl'] = $lbl;
///
$statisticsoutput .= Yii::app()->getController()->renderPartial('/admin/export/generatestats/_statisticsoutput_graphs', $aData, true);
}
$statisticsoutput .= "</table></div> <!-- in statistics helper --> \n";
}
return array("statisticsoutput" => $statisticsoutput, "pdf" => $this->pdf, "astatdata" => $astatdata);
}
/**
* Handles rendering the element on the pdf.
*
* @param pdf $pdf the pdf object
* @param bool $preview true if it is a preview, false otherwise
*/
public function render($pdf, $preview)
{
global $CFG;
// If there is no element data, we have nothing to display.
if (empty($this->element->data)) {
return;
}
$imageinfo = json_decode($this->element->data);
// Get the image.
$fs = get_file_storage();
if ($file = $fs->get_file_by_hash($imageinfo->pathnamehash)) {
$contenthash = $file->get_contenthash();
$l1 = $contenthash[0] . $contenthash[1];
$l2 = $contenthash[2] . $contenthash[3];
$location = $CFG->dataroot . '/filedir' . '/' . $l1 . '/' . $l2 . '/' . $contenthash;
$pdf->Image($location, $this->element->posx, $this->element->posy, $imageinfo->width, $imageinfo->height);
}
}
function ma2_pdf($id){
$return="";
$db=new datenbank();
$query="select * from rechnungen,mahnungen where rechnungen.renr=mahnungen.renr and mahnungen.manr='$id'";
$result=$db->query($query);
$rechnung=$db->get_object($result);
$result_kunde=$db->query("select * from kunden where kdnr=$rechnung->kunde");
$kunde=$db->get_object($result_kunde);
$pdf=new pdf('P', 'mm', 'A4');
$pdf->Open();
$pdf->AddPage();
$pdf->empfaenger($kunde->firma, $kunde->strasse." ".$kunde->hausnummer, $kunde->plz." ".$kunde->ort, $rechnung->manr, $rechnung->datum);
$pdf->SetFont('Arial','B',12);
$pdf->Cell(80,5,"Mahnung");
$pdf->Ln(10);
$pdf->SetFont("Arial", "", 10);
$pdf->Write(5, "Sehr geehrte Damen und Herren,\nleider konnte ich noch keinen Zahlungseingang zur Rechnung $rechnung->renr feststellen. Hier die Auflistung der aufgrund dieser Rechnung unbezahlten Posten::\n\n");
$query="select posten.datum as Datum, posten.kommentar as Beschreibung, posten.anzahl as Anzahl, produkte.name as Artikel, produkte.preis as Preis, (produkte.preis*posten.anzahl) as Summe from posten, produkte where posten.rechnung='$rechnung->renr' and produkte.id=posten.produkt";
$result=$db->query($query);
$header=array("Datum", "Beschreibung", "Anzahl", "Artikel", "Preis", "Summe");
while($data[]=$db->get_row($result))
{
}
$gammel=array_pop($data);
$pdf->table($header, $data);
$pdf->Ln();
$result=$db->query("SELECT Sum( posten.anzahl * produkte.preis ) AS Gesamt, Sum( posten.anzahl * produkte.preis * mwst.satz / 100 ) AS MWST, mwst.satz FROM posten, produkte, mwst WHERE produkte.id = posten.produkt AND mwst.id = produkte.mwst AND posten.rechnung = '$rechnung->renr' AND produkte.id!='3' AND produkte.id!='4' GROUP BY mwst.satz");
$betrag=$db->get_object($result);
$result=$db->query("SELECT Sum( posten.anzahl * produkte.preis ) AS Gesamt, Sum( posten.anzahl * produkte.preis * mwst.satz / 100 ) AS MWST, mwst.satz FROM posten, produkte, mwst WHERE produkte.id = posten.produkt AND mwst.id = produkte.mwst AND posten.rechnung = '$rechnung->renr' AND produkte.id ='3' GROUP BY mwst.satz");
$betrag2=$db->get_object($result);
$result=$db->query("SELECT Sum( posten.anzahl * produkte.preis ) AS Gesamt, Sum( posten.anzahl * produkte.preis * mwst.satz / 100 ) AS MWST, mwst.satz FROM posten, produkte, mwst WHERE produkte.id = posten.produkt AND mwst.id = produkte.mwst AND posten.rechnung = '$rechnung->renr' AND produkte.id ='4' GROUP BY mwst.satz");
$betrag3=$db->get_object($result);
$pdf->Cell(100,5,"", 0, 0, 'L');
$pdf->Cell(35,5,"Gesamt:",0,0,'L');
$pdf->Cell(20,5,number_format(($betrag->Gesamt+$betrag2->Gesamt+$betrag3->Gesamt),2,",",".").EURO, 0, 1, 'R');
$pdf->Cell(100,5,"", 0, 0, 'L');
$pdf->Cell(35,5,"Mehrwertsteuer (".number_format($betrag->satz)."%):", 0, 0, 'L');
$pdf->Cell(20,5,number_format($betrag->MWST,2,",",".").EURO, 0, 1, 'R');
$pdf->Ln();
$pdf->Cell(100,5,"", 0, 0, 'L');
$pdf->Cell(35,5,"Mahnbetrag:", 0, 0, 'L');
$pdf->Cell(20,5,number_format($betrag2->Gesamt+$betrag->Gesamt+$betrag3->Gesamt+$betrag->MWST,2,",",".").EURO, 0, 1, 'R');
$pdf->Ln();
$pdf->Write(5, "Bitte überweisen Sie den oben genannten Betrag bis spätestens zum $rechnung->faellig auf das unten aufgeführte Konto.\nÜber eine weitere Zusammenarbeit mit Ihnen würde ich mich sehr freuen und verbleibe mit freundlichen Grüßen\n");
$pdf->Ln(15);
$pdf->Write(5, $GLOBALS["conf"]["rechnung"]["adresse"]["name"]);
$pdf->Image($GLOBALS["conf"]["rechnung"]["unterschrift"],25,$pdf->GetY()-10,50);
$this->output=0;
$pdf->Output();
return $return;
}
/**
* Refactored code from @see certificate_output_completion()
* an array of parameters is passed and used by the certificate
* template file. It is up to the certificate template file to
* use whatever parameters are available
*
* @param array $params: An array of parameters (example: array('student_name' => 'some value'))
* Here are a list of values that can be used
* 'student_name', 'course_name', 'class_idnumber', 'class_enrol_time', 'class_enddate', 'class_grade',
* 'cert_timeissued', 'cert_code', 'class_instructor_name', 'course_description_name'
* (there will most likely be more when other entity types are added)
* @param string $border: A custom border image to use
* @param string $seal: A custom seal image to use
* @param string $template: A custom template to use
* @return string - pdf output
*/
function certificate_output_entity_completion($params, $border = '', $seal = '', $template = '')
{
global $CFG;
// Use the TCPDF library.
require_once $CFG->libdir . '/pdflib.php';
// Global settings.
$borders = 0;
$font = 'FreeSerif';
$largefontsize = 30;
$smallfontsize = 16;
// Create pdf.
$pdf = new pdf('L', 'in', 'Letter');
// Prevent the pdf from printing black bars.
$pdf->setPrintHeader(false);
$pdf->setPrintFooter(false);
$pdf->SetAutoPageBreak(false);
$pdf->SetMargins(0, 0, 0, false);
$pdf->AddPage();
$pagewidth = $pdf->getPageWidth();
$pageheight = $pdf->getPageHeight();
// Draw the border.
cm_certificate_check_data_path('borders');
if (!empty($border)) {
if (file_exists($CFG->dirroot . '/local/elisprogram/pix/certificate/borders/' . $border)) {
$pdf->Image($CFG->dirroot . '/local/elisprogram/pix/certificate/borders/' . $border, 0, 0, $pagewidth, $pageheight);
} else {
if (file_exists($CFG->dataroot . '/local/elisprogram/pix/certificate/borders/' . $border)) {
$pdf->Image($CFG->dataroot . '/local/elisprogram/pix/certificate/borders/' . $border, 0, 0, $pagewidth, $pageheight);
}
}
}
// Draw the seal.
cm_certificate_check_data_path('seals');
if (!empty($seal)) {
if (file_exists($CFG->dirroot . '/local/elisprogram/pix/certificate/seals/' . $seal)) {
$pdf->Image($CFG->dirroot . '/local/elisprogram/pix/certificate/seals/' . $seal, 8.0, 5.8);
} else {
if (file_exists($CFG->dataroot . '/local/elisprogram/pix/certificate/seals/' . $seal)) {
$pdf->Image($CFG->dataroot . '/local/elisprogram/pix/certificate/seals/' . $seal, 8.0, 5.8);
}
}
}
// Include the certificate template.
cm_certificate_check_data_path('templates');
if (file_exists($CFG->dirroot . '/local/elisprogram/pix/certificate/templates/' . $template)) {
include $CFG->dirroot . '/local/elisprogram/pix/certificate/templates/' . $template;
} else {
if (file_exists($CFG->dataroot . '/local/elisprogram/pix/certificate/templates/' . $template)) {
include $CFG->dataroot . '/local/elisprogram/pix/certificate/templates/' . $template;
}
}
$pdf->Output();
}
/**
* displayResults builds html output to display the actual results from a survey
*
* @param mixed $outputs
* @param INT $results The number of results being displayed overall
* @param mixed $rt
* @param mixed $outputType
* @param mixed $surveyid
* @param mixed $sql
* @param mixed $usegraph
*
*
*/
protected function displayResults($outputs, $results, $rt, $outputType, $surveyid, $sql, $usegraph, $browse, $sLanguage)
{
/* Set up required variables */
$TotalCompleted = 0;
//Count of actually completed answers
$statisticsoutput = "";
$sDatabaseType = Yii::app()->db->getDriverName();
$tempdir = Yii::app()->getConfig("tempdir");
$tempurl = Yii::app()->getConfig("tempurl");
$firstletter = substr($rt, 0, 1);
$astatdata = array();
if ($usegraph == 1) {
//for creating graphs we need some more scripts which are included here
require_once APPPATH . '/third_party/pchart/pchart/pChart.class';
require_once APPPATH . '/third_party/pchart/pchart/pData.class';
require_once APPPATH . '/third_party/pchart/pchart/pCache.class';
$MyCache = new pCache($tempdir . '/');
}
switch ($outputType) {
case 'xls':
$xlsTitle = sprintf(gT("Field summary for %s"), html_entity_decode($outputs['qtitle'], ENT_QUOTES, 'UTF-8'));
$xlsDesc = html_entity_decode($outputs['qquestion'], ENT_QUOTES, 'UTF-8');
$this->xlsRow++;
$this->xlsRow++;
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $xlsTitle);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $xlsDesc);
$footXLS = array();
break;
case 'pdf':
$sPDFQuestion = flattenText($outputs['qquestion'], false, true);
$pdfTitle = $this->pdf->delete_html(sprintf(gT("Field summary for %s"), html_entity_decode($outputs['qtitle'], ENT_QUOTES, 'UTF-8')));
$titleDesc = $sPDFQuestion;
$this->pdf->AddPage('P', 'A4');
$this->pdf->Bookmark($sPDFQuestion, 1, 0);
$this->pdf->titleintopdf($pdfTitle, $sPDFQuestion);
$tablePDF = array();
$footPDF = array();
break;
case 'html':
//output
$statisticsoutput .= "<table class='statisticstable table table-bordered'>\n" . "\t<thead><tr class='success'><th colspan='4' align='center' style='text-align: center; '><strong>" . sprintf(gT("Field summary for %s"), $outputs['qtitle']) . "</strong>" . "</th></tr>\n" . "\t<tr><th colspan='4' align='center' style='text-align: center; '><strong>" . $outputs['qquestion'] . "</strong></th></tr>\n" . "\t<tr>\n\t\t<th width='50%' align='center' >";
break;
default:
break;
}
//loop though the array which contains all answer data
$ColumnName_RM = array();
foreach ($outputs['alist'] as $al) {
//picks out answer list ($outputs['alist']/$al)) that come from the multiple list above
if (isset($al[2]) && $al[2]) {
//handling for "other" option
if ($al[0] == gT("Other")) {
if ($outputs['qtype'] == '!' || $outputs['qtype'] == 'L') {
// It is better for single choice question types to filter on the number of '-oth-' entries, than to
// just count the number of 'other' values - that way with failing Javascript the statistics don't get messed up
/* This query selects a count of responses where "other" has been selected */
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE " . Yii::app()->db->quoteColumnName(substr($al[2], 0, strlen($al[2]) - 5)) . "='-oth-'";
} else {
//get data - select a count of responses where no answer is provided
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ";
$query .= $sDatabaseType == "mysql" ? Yii::app()->db->quoteColumnName($al[2]) . " != ''" : "NOT (" . Yii::app()->db->quoteColumnName($al[2]) . " LIKE '')";
}
} elseif ($outputs['qtype'] == "U" || $outputs['qtype'] == "T" || $outputs['qtype'] == "S" || $outputs['qtype'] == "Q" || $outputs['qtype'] == ";") {
$sDatabaseType = Yii::app()->db->getDriverName();
//free text answers
if ($al[0] == "Answer") {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ";
$query .= $sDatabaseType == "mysql" ? Yii::app()->db->quoteColumnName($al[2]) . " != ''" : "NOT (" . Yii::app()->db->quoteColumnName($al[2]) . " LIKE '')";
} elseif ($al[0] == "NoAnswer") {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ( ";
$query .= $sDatabaseType == "mysql" ? Yii::app()->db->quoteColumnName($al[2]) . " = '')" : " (" . Yii::app()->db->quoteColumnName($al[2]) . " LIKE ''))";
}
} elseif ($outputs['qtype'] == "O") {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ( ";
$query .= $sDatabaseType == "mysql" ? Yii::app()->db->quoteColumnName($al[2]) . " <> '')" : " (" . Yii::app()->db->quoteColumnName($al[2]) . " NOT LIKE ''))";
// all other question types
} else {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE " . Yii::app()->db->quoteColumnName($al[2]) . " =";
//ranking question?
if (substr($rt, 0, 1) == "R") {
$query .= " '{$al['0']}'";
} else {
$query .= " 'Y'";
}
}
} else {
if ($al[0] != "") {
//get more data
$sDatabaseType = Yii::app()->db->getDriverName();
if ($sDatabaseType == 'mssql' || $sDatabaseType == 'sqlsrv' || $sDatabaseType == 'dblib') {
// mssql cannot compare text blobs so we have to cast here
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE cast(" . Yii::app()->db->quoteColumnName($rt) . " as varchar)= '{$al['0']}'";
} else {
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE " . Yii::app()->db->quoteColumnName($rt) . " = '{$al['0']}'";
}
} else {
// This is for the 'NoAnswer' case
// We need to take into account several possibilities
// * NoAnswer cause the participant clicked the NoAnswer radio
// ==> in this case value is '' or ' '
// * NoAnswer in text field
// ==> value is ''
// * NoAnswer due to conditions, or a page not displayed
// ==> value is NULL
if ($sDatabaseType == 'mssql' || $sDatabaseType == 'sqlsrv' || $sDatabaseType == 'dblib') {
// mssql cannot compare text blobs so we have to cast here
//$query = "SELECT count(*) FROM {{survey_$surveyid}} WHERE (".sanitize_int($rt)." IS NULL "
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ( " . "cast(" . Yii::app()->db->quoteColumnName($rt) . " as varchar) = '' " . "OR cast(" . Yii::app()->db->quoteColumnName($rt) . " as varchar) = ' ' )";
} else {
// $query = "SELECT count(*) FROM {{survey_$surveyid}} WHERE (".sanitize_int($rt)." IS NULL "
$query = "SELECT count(*) FROM {{survey_{$surveyid}}} WHERE ( " . " " . Yii::app()->db->quoteColumnName($rt) . " = '' " . "OR " . Yii::app()->db->quoteColumnName($rt) . " = ' ') ";
}
}
}
//check filter option
if (incompleteAnsFilterState() == "incomplete") {
$query .= " AND submitdate is null";
} elseif (incompleteAnsFilterState() == "complete") {
$query .= " AND submitdate is not null";
}
//check for any "sql" that has been passed from another script
if (!empty($sql)) {
$query .= " AND {$sql}";
}
//get data
$row = Yii::app()->db->createCommand($query)->queryScalar();
// $statisticsoutput .= "\n<!-- ($sql): $query -->\n\n";
//store temporarily value of answer count of question type '5' and 'A'.
$tempcount = -1;
//count can't be less han zero
//increase counter
$TotalCompleted += $row;
//"no answer" handling
if ($al[0] === "") {
$fname = gT("No answer");
} elseif ($al[0] === gT("Other") || $al[0] === "Answer" || $outputs['qtype'] === "O" && $al[0] === gT("Comments") || $outputs['qtype'] === "P") {
if ($outputs['qtype'] == "P") {
$sColumnName = $al[2] . "comment";
} else {
$sColumnName = $al[2];
}
$ColumnName_RM[] = $sColumnName;
if ($outputs['qtype'] == 'O') {
$TotalCompleted -= $row;
}
$fname = "{$al['1']}";
if ($browse === true) {
$fname .= " <input type='button' class='statisticsbrowsebutton btn btn-default btn-large' value='" . gT("Browse") . "' id='{$sColumnName}' />";
}
if ($browse === true && isset($_POST['showtextinline']) && $outputType == 'pdf') {
$headPDF2 = array();
$headPDF2[] = array(gT("ID"), gT("Response"));
$tablePDF2 = array();
$result2 = $this->_listcolumn($surveyid, $sColumnName);
foreach ($result2 as $row2) {
$tablePDF2[] = array($row2['id'], $row2['value']);
}
}
if ($browse === true && isset($_POST['showtextinline']) && $outputType == 'xls') {
$headXLS = array();
$tableXLS = array();
$headXLS[] = array(gT("ID"), gT("Response"));
$result2 = $this->_listcolumn($surveyid, $sColumnName);
foreach ($result2 as $row2) {
$tableXLS[] = array($row2['id'], $row2['value']);
}
}
} elseif ($outputs['qtype'] == "S" || $outputs['qtype'] == "U" || $outputs['qtype'] == "T" || $outputs['qtype'] == "Q") {
$headPDF = array();
$headPDF[] = array(gT("Answer"), gT("Count"), gT("Percentage"));
//show free text answers
if ($al[0] == "Answer") {
$fname = "{$al['1']}";
if ($browse === true) {
$fname .= " <input type='button' class='statisticsbrowsebutton btn btn-default btn-large' value='" . gT("Browse") . "' id='{$sColumnName}' />";
}
} elseif ($al[0] == "NoAnswer") {
$fname = "{$al['1']}";
}
$statisticsoutput .= "</th>\n" . "\t\t<th width='25%' align='center' >" . "<strong>" . gT("Count") . "</strong></th>\n" . "\t\t<th width='25%' align='center' >" . "<strong>" . gT("Percentage") . "</strong></th>\n" . "\t</tr></thead>\n";
if ($browse === true && isset($_POST['showtextinline']) && $outputType == 'pdf') {
$headPDF2 = array();
$headPDF2[] = array(gT("ID"), gT("Response"));
$tablePDF2 = array();
$result2 = $this->_listcolumn($surveyid, $sColumnName);
foreach ($result2 as $row2) {
$tablePDF2[] = array($row2['id'], $row2['value']);
}
}
} elseif (Yii::app()->getConfig('showaggregateddata') == 1) {
if (!isset($showheadline) || $showheadline != false) {
if ($outputs['qtype'] == "5" || $outputs['qtype'] == "A") {
switch ($outputType) {
case 'xls':
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Answer"));
$this->sheet->write($this->xlsRow, 1, gT("Count"));
$this->sheet->write($this->xlsRow, 2, gT("Percentage"));
$this->sheet->write($this->xlsRow, 3, gT("Sum"));
break;
case 'pdf':
$headPDF = array();
$headPDF[] = array(gT("Answer"), gT("Count"), gT("Percentage"), gT("Sum"));
break;
case 'html':
//four columns
$statisticsoutput .= "<strong>" . gT("Answer") . "</strong></th>\n" . "\t\t<th width='15%' align='center' >" . "<strong>" . gT("Count") . "</strong></th>\n" . "\t\t<th width='20%' align='center' >" . "<strong>" . gT("Percentage") . "</strong></th>\n" . "\t\t<th width='15%' align='center' >" . "<strong>" . gT("Sum") . "</strong></th>\n" . "\t</tr></thead>\n";
break;
default:
break;
}
$showheadline = false;
} else {
switch ($outputType) {
case 'xls':
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Answer"));
$this->sheet->write($this->xlsRow, 1, gT("Count"));
$this->sheet->write($this->xlsRow, 2, gT("Percentage"));
break;
case 'pdf':
$headPDF = array();
$headPDF[] = array(gT("Answer"), gT("Count"), gT("Percentage"));
break;
case 'html':
//three columns
$statisticsoutput .= "<strong>" . gT("Answer") . "</strong></td>\n" . "\t\t<th width='25%' align='center' >" . "<strong>" . gT("Count") . "</strong></th>\n" . "\t\t<th width='25%' align='center' >" . "<strong>" . gT("Percentage") . "</strong></th>\n" . "\t</tr></thead>\n";
break;
default:
break;
}
$showheadline = false;
}
}
//text for answer column is always needed
$fname = "{$al['1']} ({$al['0']})";
} else {
if (!isset($showheadline) || $showheadline != false) {
switch ($outputType) {
case 'xls':
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Answer"));
$this->sheet->write($this->xlsRow, 1, gT("Count"));
$this->sheet->write($this->xlsRow, 2, gT("Percentage"));
break;
case 'pdf':
$headPDF = array();
$headPDF[] = array(gT("Answer"), gT("Count"), gT("Percentage"));
break;
case 'html':
//three columns
$statisticsoutput .= "<strong>" . gT("Answer") . "</strong></th>\n" . "\t\t<th width='25%' align='center' >" . "<strong>" . gT("Count") . "</strong></th>\n" . "\t\t<th width='25%' align='center' >" . "<strong>" . gT("Percentage") . "</strong></th>\n" . "\t</tr></thead>\n";
break;
default:
break;
}
$showheadline = false;
}
//answer text
$fname = "{$al['1']} ({$al['0']})";
}
//are there some results to play with?
if ($results > 0) {
//calculate percentage
$gdata[] = $row / $results * 100;
} else {
//no data!
$gdata[] = "N/A";
}
//put absolute data into array
$grawdata[] = $row;
//put question title and code into array
$label[] = $fname;
//put only the code into the array
$justcode[] = $al[0];
//edit labels and put them into antoher array
//first check if $tempcount is > 0. If yes, $row has been modified and $tempcount has the original count.
if ($tempcount > -1) {
$lbl[wordwrap(FlattenText("{$al['1']}"), 25, "\n")] = $tempcount;
} else {
$lbl[wordwrap(FlattenText("{$al['1']}"), 25, "\n")] = $row;
}
}
//end foreach -> loop through answer data
//no filtering of incomplete answers and NO multiple option questions
//if ((incompleteAnsFilterState() != "complete") and ($outputs['qtype'] != "M") and ($outputs['qtype'] != "P"))
//error_log("TIBO ".print_r($showaggregated_indice_table,true));
if ($outputs['qtype'] != "M" and $outputs['qtype'] != "P") {
//is the checkbox "Don't consider NON completed responses (only works when Filter incomplete answers is Disable)" checked?
//if (isset($_POST[''noncompleted']) and ($_POST['noncompleted'] == "on") && (isset(Yii::app()->getConfig('showaggregateddata')) && Yii::app()->getConfig('showaggregateddata') == 0))
// TIBO: TODO WE MUST SKIP THE FOLLOWING SECTION FOR TYPE A and 5 when
// showaggreagated data is set and set to 1
if (isset($_POST['noncompleted']) and $_POST['noncompleted'] == "on") {
//counter
$i = 0;
while (isset($gdata[$i])) {
if (isset($showaggregated_indice_table[$i]) && $showaggregated_indice_table[$i] == "aggregated") {
// do nothing, we don't rewrite aggregated results
// or at least I don't know how !!! (lemeur)
} else {
//we want to have some "real" data here
if ($gdata[$i] != "N/A") {
//calculate percentage
$gdata[$i] = $grawdata[$i] / $TotalCompleted * 100;
}
}
//increase counter
$i++;
}
//end while (data available)
} else {
//calculate total number of incompleted records
$TotalIncomplete = $results - $TotalCompleted;
//output
if (incompleteAnsFilterState() != "complete") {
$fname = gT("Not completed or Not displayed");
} else {
$fname = gT("Not displayed");
}
//we need some data
if ($results > 0) {
//calculate percentage
$gdata[] = $TotalIncomplete / $results * 100;
} else {
$gdata[] = "N/A";
}
//put data of incompleted records into array
$grawdata[] = $TotalIncomplete;
//put question title ("Not completed") into array
$label[] = $fname;
//put the code ("Not completed") into the array
$justcode[] = $fname;
//edit labels and put them into another array
if (incompleteAnsFilterState() != "complete") {
$lbl[wordwrap(flattenText(gT("Not completed or Not displayed")), 20, "\n")] = $TotalIncomplete;
} else {
$lbl[wordwrap(flattenText(gT("Not displayed")), 20, "\n")] = $TotalIncomplete;
}
}
//end else -> noncompleted NOT checked
}
// For multi question type, we have to check non completed with ALL sub question set to NULL
if ($outputs['qtype'] == "M" or $outputs['qtype'] == "P") {
$criteria = new CDbCriteria();
foreach ($outputs['alist'] as $al) {
$criteria->addCondition(Yii::app()->db->quoteColumnName($al[2]) . " IS NULL");
}
if (incompleteAnsFilterState() == "incomplete") {
$criteria->addCondition("submitdate IS NULL");
} elseif (incompleteAnsFilterState() == "complete") {
$criteria->addCondition("submitdate IS NOT NULL");
}
$multiNotDisplayed = SurveyDynamic::model($surveyid)->count($criteria);
if (isset($_POST['noncompleted']) and $_POST['noncompleted'] == "on") {
//counter
$i = 0;
while (isset($gdata[$i])) {
//we want to have some "real" data here
if ($gdata[$i] != "N/A") {
//calculate percentage
if ($results > $multiNotDisplayed) {
$gdata[$i] = $grawdata[$i] / ($results - $multiNotDisplayed) * 100;
} else {
$gdata[$i] = "N/A";
}
}
$i++;
}
} else {
// Add a line with not displayed %
if ($multiNotDisplayed > 0) {
if (incompleteAnsFilterState() != "complete") {
$fname = gT("Not completed or Not displayed");
} else {
$fname = gT("Not displayed");
}
$label[] = $fname;
//we need some data
if ($results > 0) {
//calculate percentage
$gdata[] = $multiNotDisplayed / $results * 100;
} else {
$gdata[] = "N/A";
}
//put data of incompleted records into array
$grawdata[] = $multiNotDisplayed;
}
}
}
//counter
$i = 0;
//we need to know which item we are editing
$itemcounter = 1;
//loop through all available answers
while (isset($gdata[$i])) {
//repeat header (answer, count, ...) for each new question
unset($showheadline);
/*
* there are 3 colums:
*
* 1 (50%) = answer (title and code in brackets)
* 2 (25%) = count (absolute)
* 3 (25%) = percentage
*/
$statisticsoutput .= "\t<tr>\n\t\t<td align='center' >" . $label[$i] . "\n" . "\t\t</td>\n";
/*
* If there is a "browse" button in this label, let's make sure there's an extra row afterwards
* to store the columnlist
*
* */
if (strpos($label[$i], "statisticsbrowsebutton")) {
$extraline = "<tr><td class='statisticsbrowsecolumn' colspan='3' style='display: none'>";
if ($outputs['qtype'] == 'P') {
$extraline .= "<div class='statisticsbrowsecolumn' id='columnlist_{$ColumnName_RM[$i]}'></div></td></tr>\n";
} else {
$extraline .= "<div class='statisticsbrowsecolumn' id='columnlist_{$sColumnName}'></div></td></tr>\n";
}
}
//output absolute number of records
$statisticsoutput .= "\t\t<td align='center' >" . $grawdata[$i] . "\n</td>";
//no data
if ($gdata[$i] === "N/A") {
switch ($outputType) {
case 'xls':
$label[$i] = flattenText($label[$i]);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $label[$i]);
$this->sheet->writeNumber($this->xlsRow, 1, $grawdata[$i]);
$this->sheet->writeNumber($this->xlsRow, 2, $gdata[$i] / 100, $this->xlsPercents);
break;
case 'pdf':
$tablePDF[] = array(flattenText($label[$i]), $grawdata[$i], sprintf("%01.2f", $gdata[$i]) . "%", "");
break;
case 'html':
//output when having no data
$statisticsoutput .= "\t\t<td align='center' >";
//percentage = 0
$statisticsoutput .= sprintf("%01.2f", $gdata[$i]) . "%";
$gdata[$i] = 0;
//check if we have to adjust ouput due to Yii::app()->getConfig('showaggregateddata') setting
if (Yii::app()->getConfig('showaggregateddata') == 1 && ($outputs['qtype'] == "5" || $outputs['qtype'] == "A")) {
$statisticsoutput .= "\t\t</td>";
} elseif ($outputs['qtype'] == "S" || $outputs['qtype'] == "U" || $outputs['qtype'] == "T" || $outputs['qtype'] == "Q") {
$statisticsoutput .= "</td>\n\t";
}
$statisticsoutput .= "</tr>\n";
//Close the row
if (isset($extraline)) {
$statisticsoutput .= $extraline;
}
break;
default:
break;
}
} else {
//check if data should be aggregated
if (Yii::app()->getConfig('showaggregateddata') == 1 && ($outputs['qtype'] == "5" || $outputs['qtype'] == "A")) {
//mark that we have done soemthing special here
$aggregated = true;
if ($results - $grawdata[5] > 0) {
$percentage = $grawdata[$i] / ($results - $grawdata[5]) * 100;
// Only answered
} else {
$percentage = 0;
}
switch ($itemcounter) {
case 1:
if ($results - $grawdata[5] > 0) {
$aggregatedPercentage = ($grawdata[0] + $grawdata[1]) / ($results - $grawdata[5]) * 100;
} else {
$aggregatedPercentage = 0;
}
break;
case 3:
$aggregatedPercentage = $percentage;
break;
case 5:
if ($results - $grawdata[5] > 0) {
$aggregatedPercentage = ($grawdata[3] + $grawdata[4]) / ($results - $grawdata[5]) * 100;
} else {
$aggregatedPercentage = 0;
}
break;
case 6:
case 7:
if ($results - $grawdata[5] > 0) {
$percentage = $grawdata[$i] / $results * 100;
// All results
} else {
$percentage = 0;
}
default:
$aggregatedPercentage = 'na';
break;
}
switch ($outputType) {
case 'xls':
$label[$i] = flattenText($label[$i]);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $label[$i]);
$this->sheet->writeNumber($this->xlsRow, 1, $grawdata[$i]);
$this->sheet->writeNumber($this->xlsRow, 2, $percentage / 100, $this->xlsPercents);
if ($aggregatedPercentage !== 'na') {
$this->sheet->writeNumber($this->xlsRow, 3, $aggregatedPercentage / 100, $this->xlsPercents);
}
break;
case 'pdf':
$label[$i] = flattenText($label[$i]);
if ($aggregatedPercentage !== 'na') {
$tablePDF[] = array($label[$i], $grawdata[$i], sprintf("%01.2f", $percentage) . "%", sprintf("%01.2f", $aggregatedPercentage) . "%");
} else {
$tablePDF[] = array($label[$i], $grawdata[$i], sprintf("%01.2f", $percentage) . "%", "");
}
break;
case 'html':
//output percentage
$statisticsoutput .= "\t\t<td align='center' >";
$statisticsoutput .= sprintf("%01.2f", $percentage) . "%</td>";
$statisticsoutput .= "\t\t<td align='center' >";
if ($aggregatedPercentage !== 'na') {
$statisticsoutput .= sprintf("%01.2f", $aggregatedPercentage) . "%";
} else {
$statisticsoutput .= ' ';
}
$statisticsoutput .= "</td>\t\t";
break;
default:
break;
}
if ($itemcounter == 5) {
// create new row "sum"
//calculate sum of items 1-5
$sumitems = $grawdata[0] + $grawdata[1] + $grawdata[2] + $grawdata[3] + $grawdata[4];
//special treatment for zero values
if ($sumitems > 0) {
$sumpercentage = "100.00";
} else {
$sumpercentage = "0";
}
//special treatment for zero values
if ($TotalCompleted > 0) {
$casepercentage = "100.00";
} else {
$casepercentage = "0";
}
switch ($outputType) {
case 'xls':
$footXLS[] = array(gT("Sum") . " (" . gT("Answers") . ")", $sumitems, $sumpercentage . "%", $sumpercentage . "%");
$footXLS[] = array(gT("Number of cases"), $TotalCompleted, $casepercentage . "%", "");
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Sum") . " (" . gT("Answers") . ")");
$this->sheet->writeNumber($this->xlsRow, 1, $sumitems);
$this->sheet->writeNumber($this->xlsRow, 2, $sumpercentage / 100, $this->xlsPercents);
$this->sheet->writeNumber($this->xlsRow, 3, $sumpercentage / 100, $this->xlsPercents);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Number of cases"));
$this->sheet->writeNumber($this->xlsRow, 1, $TotalCompleted);
$this->sheet->writeNumber($this->xlsRow, 2, $casepercentage / 100, $this->xlsPercents);
break;
case 'pdf':
$footPDF[] = array(gT("Sum") . " (" . gT("Answers") . ")", $sumitems, $sumpercentage . "%", $sumpercentage . "%");
$footPDF[] = array(gT("Number of cases"), $TotalCompleted, $casepercentage . "%", "");
break;
case 'html':
$statisticsoutput .= "\t\t \n\t</tr>\n";
$statisticsoutput .= "<tr><td align='center'><strong>" . gT("Sum") . " (" . gT("Answers") . ")</strong></td>";
$statisticsoutput .= "<td align='center' ><strong>" . $sumitems . "</strong></td>";
$statisticsoutput .= "<td align='center' ><strong>{$sumpercentage}%</strong></td>";
$statisticsoutput .= "<td align='center' ><strong>{$sumpercentage}%</strong></td>";
$statisticsoutput .= "\t\t \n\t</tr>\n";
$statisticsoutput .= "<tr><td align='center'>" . gT("Number of cases") . "</td>";
//German: "Fallzahl"
$statisticsoutput .= "<td align='center' >" . $TotalCompleted . "</td>";
$statisticsoutput .= "<td align='center' >{$casepercentage}%</td>";
//there has to be a whitespace within the table cell to display correctly
$statisticsoutput .= "<td align='center' > </td></tr>";
break;
default:
break;
}
}
} else {
switch ($outputType) {
case 'xls':
$label[$i] = flattenText($label[$i]);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, $label[$i]);
$this->sheet->writeNumber($this->xlsRow, 1, $grawdata[$i]);
$this->sheet->writeNumber($this->xlsRow, 2, $gdata[$i] / 100, $this->xlsPercents);
break;
case 'pdf':
$label[$i] = flattenText($label[$i]);
$tablePDF[] = array($label[$i], $grawdata[$i], sprintf("%01.2f", $gdata[$i]) . "%", "");
break;
case 'html':
//output percentage
$statisticsoutput .= "\t\t<td align='center' >";
$statisticsoutput .= sprintf("%01.2f", $gdata[$i]) . "%";
$statisticsoutput .= "\t\t";
//end output per line. there has to be a whitespace within the table cell to display correctly
$statisticsoutput .= "\t\t </td>\n\t</tr>\n";
if (isset($extraline)) {
$statisticsoutput .= $extraline;
}
break;
default:
break;
}
}
}
//end else -> $gdata[$i] != "N/A"
//increase counter
$i++;
$itemcounter++;
//Clear extraline
unset($extraline);
}
//end while
//only show additional values when this setting is enabled
if (Yii::app()->getConfig('showaggregateddata') == 1) {
//it's only useful to calculate standard deviation and arithmetic means for question types
//5 = 5 Point Scale
//A = Array (5 Point Choice)
if ($outputs['qtype'] == "5" || $outputs['qtype'] == "A") {
$stddev = 0;
$stddevarray = array_slice($grawdata, 0, 5, true);
$am = 0;
//calculate arithmetic mean
if (isset($sumitems) && $sumitems > 0) {
//calculate and round results
//there are always 5 items
for ($x = 0; $x < 5; $x++) {
//create product of item * value
$am += ($x + 1) * $stddevarray[$x];
}
//prevent division by zero
if (isset($stddevarray) && array_sum($stddevarray) > 0) {
$am = round($am / array_sum($stddevarray), 2);
} else {
$am = 0;
}
//calculate standard deviation -> loop through all data
/*
* four steps to calculate the standard deviation
* 1 = calculate difference between item and arithmetic mean and multiply with the number of elements
* 2 = create sqaure value of difference
* 3 = sum up square values
* 4 = multiply result with 1 / (number of items)
* 5 = get root
*/
for ($j = 0; $j < 5; $j++) {
//1 = calculate difference between item and arithmetic mean
$diff = $j + 1 - $am;
//2 = create square value of difference
$squarevalue = square($diff);
//3 = sum up square values and multiply them with the occurence
//prevent divison by zero
if ($squarevalue != 0 && $stddevarray[$j] != 0) {
$stddev += $squarevalue * $stddevarray[$j];
}
}
//4 = multiply result with 1 / (number of items (=5))
//There are two different formulas to calculate standard derivation
//$stddev = $stddev / array_sum($stddevarray); //formula source: http://de.wikipedia.org/wiki/Standardabweichung
//prevent division by zero
if (array_sum($stddevarray) - 1 != 0 && $stddev != 0) {
$stddev = $stddev / (array_sum($stddevarray) - 1);
//formula source: http://de.wikipedia.org/wiki/Empirische_Varianz
} else {
$stddev = 0;
}
//5 = get root
$stddev = sqrt($stddev);
$stddev = round($stddev, 2);
}
switch ($outputType) {
case 'xls':
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Arithmetic mean"));
$this->sheet->writeNumber($this->xlsRow, 1, $am);
$this->xlsRow++;
$this->sheet->write($this->xlsRow, 0, gT("Standard deviation"));
$this->sheet->writeNumber($this->xlsRow, 1, $stddev);
break;
case 'pdf':
$tablePDF[] = array(gT("Arithmetic mean"), $am, '', '');
$tablePDF[] = array(gT("Standard deviation"), $stddev, '', '');
break;
case 'html':
//calculate standard deviation
$statisticsoutput .= "<tr><td align='center'>" . gT("Arithmetic mean") . "</td>";
//German: "Fallzahl"
$statisticsoutput .= "<td> </td><td align='center'> {$am}</td><td> </td></tr>";
$statisticsoutput .= "<tr><td align='center'>" . gT("Standard deviation") . "</td>";
//German: "Fallzahl"
$statisticsoutput .= "<td> </td><td align='center'>{$stddev}</td><td> </td></tr>";
break;
default:
break;
}
}
}
if ($outputType == 'pdf') {
//$tablePDF = array();
$tablePDF = array_merge_recursive($tablePDF, $footPDF);
$this->pdf->headTable($headPDF, $tablePDF);
//$this->pdf->tableintopdf($tablePDF);
// if(isset($footPDF))
// foreach($footPDF as $foot)
// {
// $footA = array($foot);
// $this->pdf->tablehead($footA);
// }
if (isset($headPDF2)) {
$this->pdf->headTable($headPDF2, $tablePDF2);
}
}
if ($outputType == 'xls' && (isset($headXLS) || isset($tableXLS))) {
if (isset($headXLS)) {
$this->xlsRow++;
$this->xlsRow++;
foreach ($headXLS as $aRow) {
$this->xlsRow++;
$iColumn = 0;
foreach ($aRow as $sValue) {
$this->sheet->write($this->xlsRow, $iColumn, $sValue, $this->formatBold);
$iColumn++;
}
}
}
if (isset($tableXLS)) {
foreach ($tableXLS as $aRow) {
$this->xlsRow++;
$iColumn = 0;
foreach ($aRow as $sValue) {
$this->sheet->write($this->xlsRow, $iColumn, $sValue);
$iColumn++;
}
}
}
}
if ($outputType == 'html') {
$statisticsoutput .= "<tr><td colspan='4' style=\"text-align:center\" id='statzone_{$rt}'>";
}
//-------------------------- PCHART OUTPUT ----------------------------
list($qsid, $qgid, $qqid) = explode("X", $rt, 3);
$qsid = $surveyid;
$aattr = getQuestionAttributeValues($outputs['parentqid'], substr($rt, 0, 1));
//PCHART has to be enabled and we need some data
if ($usegraph == 1) {
$bShowGraph = $aattr["statistics_showgraph"] == "1";
$bAllowPieChart = $outputs['qtype'] != "M" && $outputs['qtype'] != "P";
$bAllowMap = isset($aattr["location_mapservice"]) && $aattr["location_mapservice"] == "1";
$bShowMap = $bAllowMap && $aattr["statistics_showmap"] == "1";
$bShowPieChart = $bAllowPieChart && (isset($aattr["statistics_graphtype"]) && $aattr["statistics_graphtype"] == "1");
$astatdata[$rt] = array('id' => $rt, 'sg' => $bShowGraph, 'ap' => $bAllowPieChart, 'am' => $bAllowMap, 'sm' => $bShowMap, 'sp' => $bShowPieChart);
$stats = Yii::app()->session['stats'];
$stats[$rt] = array('lbl' => $lbl, 'gdata' => $gdata, 'grawdata' => $grawdata);
Yii::app()->session['stats'] = $stats;
if ($bShowGraph == true) {
$cachefilename = createChart($qqid, $qsid, $bShowPieChart, $lbl, $gdata, $grawdata, $MyCache, $sLanguage, $outputs['qtype']);
if ($cachefilename) {
//introduce new counter
if (!isset($ci)) {
$ci = 0;
}
//increase counter, start value -> 1
$ci++;
switch ($outputType) {
case 'xls':
/**
* No Image for Excel...
*/
break;
case 'pdf':
$this->pdf->AddPage('P', 'A4');
$this->pdf->titleintopdf($pdfTitle, $titleDesc);
$this->pdf->Image($tempdir . "/" . $cachefilename, 0, 70, 180, 0, '', Yii::app()->getController()->createUrl("admin/survey/sa/view/surveyid/" . $surveyid), 'B', true, 150, 'C', false, false, 0, true);
break;
case 'html':
//// This QD code generate the chart.js.
//// It's mixing PHP, JS and painfull from hell.
//// for more details, read : http://goo.gl/ylbikt
//// TODO : this is a rest of the first cycle of dev
//// Should be possible to use only one canvas now...
$pie_visibility = $radar_visibility = $line_visibility = $polar__visibility = $doughnut_visibility = $bar_visibility = 'hidden';
if (isset($aattr["statistics_graphtype"])) {
$req_chart_type = $aattr["statistics_graphtype"];
}
//// If user forced the chartype from statistics_view
if ($_POST['charttype'] != 'default') {
$req_chart_type = $_POST['charttype'];
}
//// The value of the select box in the question advanced setting is numerical. So we need to translate it.
if (isset($req_chart_type)) {
switch ($req_chart_type) {
case '1':
$charttype = "Pie";
$pie_visibility = ' active ';
break;
case '2':
$charttype = "Radar";
$radar_visibility = ' active ';
break;
case '3':
$charttype = "Line";
$line_visibility = ' active ';
break;
case '4':
$charttype = "PolarArea";
$polar__visibility = ' active ';
break;
case '5':
$charttype = "Doughnut";
$doughnut_visibility = ' active ';
break;
default:
$charttype = "Bar";
$bar_visibility = ' active ';
break;
}
}
//// Here the 72 colors of the original limesurvey palette.
//// This could be change by some user palette coming from database.
$COLORS_FOR_SURVEY = array('20,130,200', '232,95,51', '34,205,33', '210,211,28', '134,179,129', '201,171,131', '251,231,221', '23,169,161', '167,187,213', '211,151,213', '147,145,246', '147,39,90', '250,250,201', '201,250,250', '94,0,94', '250,125,127', '0,96,201', '201,202,250', '0,0,127', '250,0,250', '250,250,0', '0,250,250', '127,0,127', '127,0,0', '0,125,127', '0,0,250', '0,202,250', '201,250,250', '201,250,201', '250,250,151', '151,202,250', '251,149,201', '201,149,250', '250,202,151', '45,96,250', '45,202,201', '151,202,0', '250,202,0', '250,149,0', '250,96,0', '184,230,115', '102,128,64', '220,230,207', '134,191,48', '184,92,161', '128,64,112', '230,207,224', '191,48,155', '230,138,115', '128,77,64', '230,211,207', '191,77,48', '80,161,126', '64,128,100', '207,230,220', '48,191,130', '25,25,179', '18,18,125', '200,200,255', '145,145,255', '255,178,0', '179,125,0', '255,236,191', '255,217,128', '255,255,0', '179,179,0', '255,255,191', '255,255,128', '102,0,153', '71,0,107', '234,191,255', '213,128,255');
//// $lbl is generated somewhere upthere by the original code. We translate it for chartjs.
$labels = array();
foreach ($lbl as $name => $lb) {
$labels[] = $name;
}
//// As said before, one canva should be enough now. Just need to modify the init_chart functions, and to remove the visibility logic.
$statisticsoutput .= '<div class="col-sm-12">
<div class="col-sm-10 vcenter" id="chartjs-container-' . $qqid . '">
<canvas class="canvas-chart ' . $bar_visibility . '" id="chartjs-Bar-' . $qqid . '" width="400" height="150"></canvas>
<canvas class="canvas-chart ' . $pie_visibility . '" id="chartjs-Pie-' . $qqid . '" width="400" height="150"></canvas>
<canvas class="canvas-chart ' . $radar_visibility . '" id="chartjs-Radar-' . $qqid . '" width="400" height="150"></canvas>
<canvas class="canvas-chart ' . $line_visibility . '" id="chartjs-Line-' . $qqid . '" width="400" height="150"></canvas>
<canvas class="canvas-chart ' . $polar__visibility . '" id="chartjs-PolarArea-' . $qqid . '" width="400" height="150"></canvas>
<canvas class="canvas-chart ' . $doughnut_visibility . '" id="chartjs-Doughnut-' . $qqid . '" width="400" height="150"></canvas>
</div>';
$statisticsoutput .= $this->get_chartjs_legend($labels, $COLORS_FOR_SURVEY);
////TODO : animate on scroll
//// Here, we directly insert a <script> generating the chart for $qqid. Of course, this chart is generated on page load.
//// So, it could be hard for navigator if hundreds of charts are loaded... A lazy load, with nice animation on scroll will be needed
//// See : http://stackoverflow.com/questions/18772547/how-to-make-the-chart-js-animate-when-scrolled-to-that-section
$statisticsoutput .= $this->init_chart_js_graph($charttype, $labels, $qqid, $grawdata, $COLORS_FOR_SURVEY, false);
//// This is from the old code. Don't know if still used.
$aattr = getQuestionAttributeValues($qqid, $firstletter);
if ($bShowMap) {
$statisticsoutput .= "<div id=\"statisticsmap_{$rt}\" class=\"statisticsmap\"></div>";
$agmapdata[$rt] = array("coord" => getQuestionMapData(substr($rt, 1), $qsid), "zoom" => $aattr['location_mapzoom'], "width" => $aattr['location_mapwidth'], "height" => $aattr['location_mapheight']);
}
break;
default:
break;
}
}
}
}
//close table/output
if ($outputType == 'html') {
// show this block only when we show graphs and are not in the public statics controller
// this is because the links don't work from that controller
if ($usegraph == 1 && get_class(Yii::app()->getController()) !== 'Statistics_userController') {
$sImgUrl = Yii::app()->getConfig('adminimageurl');
$statisticsoutput .= "</td></tr><tr><td colspan='4'>";
//// The buttons to switch the graph type
$statisticsoutput .= '<div class="chartjs-buttons" style=\\"text-align:center\\">';
//// Bar chart
$statisticsoutput .= ' <button type="button" id="button-chartjs-Bar-' . $qqid . '" class="btn btn-default chart-type-control" data-canva-id="chartjs-Bar-' . $qqid . '" aria-label="Left Align">
<i class="fa fa-bar-chart"></i>
' . gT('Bar chart') . '
</button>';
//// Pie chart
$statisticsoutput .= ' <button type="button" id="button-chartjs-Pie-' . $qqid . '" class="btn btn-default chart-type-control" data-canva-id="chartjs-Pie-' . $qqid . '" aria-label="Left Align">
<i class="fa fa-pie-chart"></i>
' . gT('Pie chart') . '
</button>';
//// Radar chart
$statisticsoutput .= ' <button type="button" id="button-chartjs-Radar-' . $qqid . '" class="btn btn-default chart-type-control" data-canva-id="chartjs-Radar-' . $qqid . '" aria-label="Left Align">
<i class="fa fa-crosshairs"></i>
' . gT('Radar chart') . '
</button>';
//// Line chart
$statisticsoutput .= ' <button type="button" id="button-chartjs-Line-' . $qqid . '" class="btn btn-default chart-type-control" data-canva-id="chartjs-Line-' . $qqid . '" aria-label="Left Align">
<i class="fa fa-line-chart"></i>
' . gT('Line chart') . '
</button>';
//// Polar chart
$statisticsoutput .= ' <button type="button" id="button-chartjs-PolarArea-' . $qqid . '" class="btn btn-default chart-type-control" data-canva-id="chartjs-PolarArea-' . $qqid . '" aria-label="Left Align">
<i class="fa fa-sun-o"></i>
' . gT('Polar chart') . '
</button>';
//// Doughnut chart
$statisticsoutput .= ' <button type="button" id="button-chartjs-Doughnut-' . $qqid . '" class="btn btn-default chart-type-control" data-canva-id="chartjs-Doughnut-' . $qqid . '" aria-label="Left Align">
<i class="fa fa fa-circle-o"></i>
' . gT('Doughnut chart') . '
</button>';
//// Here, we directly insert the script to handle each button.
//// Sure, we could have use statistic.js, to get the click on chart-type-control, etc etc : but we did it the fast way
//// TODO : refactore that on a jQuery plugin, more general.
$statisticsoutput .= '<script>/*<![CDATA[*/';
$statisticsoutput .= '$(document).ready(function(){';
//// each button will have its own 'onclick' event, wich generate a new chartjs object
//// the hidden and active class togle should be replaced by a single canva being cleared.
foreach (array('Bar', 'Radar', 'Line', 'Doughnut', 'PolarArea', 'Pie') as $ctype) {
$statisticsoutput .= ' $("#button-chartjs-' . $ctype . '-' . $qqid . '").click(function(){
$("#chartjs-container-' . $qqid . ' .active").addClass("hidden").removeClass("active");
$("#chartjs-' . $ctype . '-' . $qqid . '").removeClass("hidden");
$("#chartjs-' . $ctype . '-' . $qqid . '").addClass("active");
$("#chartjs-' . $ctype . '-' . $qqid . '").width("100%");
$("#chartjs-' . $ctype . '-' . $qqid . '").height("441px");';
//// We call the PHP function wich will build the javascript wich will build the js object.
//// for details, see : http://goo.gl/JtnOsZ
$statisticsoutput .= $this->init_chart_js_graph($ctype, $labels, $qqid, $grawdata, $COLORS_FOR_SURVEY, true);
$statisticsoutput .= '});';
}
$statisticsoutput .= '})';
$statisticsoutput .= ' /*]]>*/ </script></div>';
$statisticsoutput .= "<div id='stats_{$rt}' class='graphdisplay' style=\"text-align:center\">";
$statisticsoutput .= "</div></td></tr>";
/*
$statisticsoutput .= "</td></tr><tr><td colspan='4'><div id='stats_$rt' class='graphdisplay' style=\"text-align:center\">"
."<img class='stats-hidegraph' src='$sImgUrl/chart_disabled.png' title='". gT("Disable chart") ."' />"
."<img class='stats-showgraph' src='$sImgUrl/chart.png' title='". gT("Enable chart") ."' />"
."<img class='stats-showbar' src='$sImgUrl/chart_bar.png' title='". gT("Display as bar chart") ."' />"
."<img class='stats-showpie' src='$sImgUrl/chart_pie.png' title='". gT("Display as pie chart") ."' />"
."<img class='stats-showmap' src='$sImgUrl/map_disabled.png' title='". gT("Disable map display") ."' />"
."<img class='stats-hidemap' src='$sImgUrl/map.png' title='". gT("Enable map display") ."' />"
."</div></td></tr>";
*/
}
$statisticsoutput .= "</td></tr></table><br /> \n";
}
return array("statisticsoutput" => $statisticsoutput, "pdf" => $this->pdf, "astatdata" => $astatdata);
}