public function mapSection($filters)
{
$section_map = $this->toMap();
$repository = new SapphireAnswerSurveyRepository();
$questions = array();
foreach ($this->Graphs()->sort('Order') as $graph) {
$values = array();
$extra_label = '';
$answers = $repository->getByQuestionAndFilters($graph->Question()->ID, $filters);
$total_answers = $answers['total'];
$answers = $answers['answers'];
foreach ($answers as $answer) {
if (!$answer) {
continue;
}
if ($graph->Question()->ClassName == 'SurveyRadioButtonMatrixTemplateQuestion') {
$col = $answer->col;
$row = $answer->row;
if (!isset($values[$row])) {
$values[$row] = array();
}
if (!isset($values[$row][$col])) {
$values[$row][$col] = 0;
}
$values[$row][$col]++;
} else {
if (!isset($values[$answer])) {
$values[$answer] = 0;
}
$values[$answer]++;
}
}
if ($graph->Question()->Name == 'NetPromoter') {
$promoter_perc = round($values['Promoter'] / $total_answers * 100);
$detractor_perc = round($values['Detractor'] / $total_answers * 100);
$extra_label = 'NPS: ' . ($promoter_perc - $detractor_perc) . '%';
}
//sort results
arsort($values);
// hide answers if less than 10
if ($total_answers <= 10) {
$values = array();
$total_answers = 0;
}
if ($graph->Type == 'pie' && count($values) > 10) {
$other_values = array_slice($values, 13);
$values = array_slice($values, 0, 12);
$values['Other'] = 0;
foreach ($other_values as $val) {
$values['Other'] += $val;
}
}
$questions[] = array('ID' => $graph->Question()->ID, 'Graph' => $graph->Type, 'Title' => $graph->Label, 'Values' => $values, 'Total' => $total_answers, 'ExtraLabel' => $extra_label);
}
$section_map['Questions'] = $questions;
return $section_map;
}
public function mapSection($filters)
{
$section_map = $this->toMap();
$repository = new SapphireAnswerSurveyRepository();
$questions = array();
foreach ($this->Graphs()->sort('Order') as $graph) {
$values = array();
$extra_label = '';
$answers = $repository->getByQuestionAndFilters($graph->Question()->ID, $filters);
$total_answers = $answers['total'];
$answers = $answers['answers'];
// set labels for multibars
if ($graph->Type == 'multibars') {
//fill up template
$row_values_array = array();
foreach ($graph->Question()->Rows() as $row_value) {
$row_values_array[$row_value->Value] = 0;
}
foreach ($graph->Question()->Columns() as $col_value) {
$values[$col_value->Value] = $row_values_array;
}
} else {
if ($graph->Question()->Name == 'NetPromoter') {
$values = array('Detractor' => 0, 'Neutral' => 0, 'Promoter' => 0);
} else {
foreach ($graph->Question()->Values() as $value_temp) {
$values[$value_temp->Value] = 0;
}
}
}
if (count($answers)) {
foreach ($answers as $answer) {
if (!$answer) {
continue;
}
if ($graph->Type == 'multibars') {
$col = $answer->col;
$row = $answer->row;
if (!isset($values[$row]) || !isset($values[$row][$col])) {
continue;
}
$values[$row][$col]++;
} else {
if (!isset($values[$answer])) {
continue;
}
$values[$answer]++;
}
}
// hide answers if less than 10
if ($total_answers < 10) {
$values = array();
$total_answers = 0;
} else {
if ($graph->Type == 'multibars') {
// show as percentage
foreach ($values as $key => $val) {
foreach ($val as $key2 => $val2) {
$values[$key][$key2] = round($val2 / $total_answers * 100);
}
}
} else {
if ($graph->Type == 'bars') {
// show as percentage
foreach ($values as $key => $val) {
$values[$key] = round($val / $total_answers * 100);
}
} else {
if ($graph->Type == 'pie') {
// extra label for net promoter
if ($graph->Question()->Name == 'NetPromoter') {
$promoter_perc = round($values['Promoter'] / $total_answers * 100);
$detractor_perc = round($values['Detractor'] / $total_answers * 100);
$extra_label = 'NPS: ' . ($promoter_perc - $detractor_perc);
}
arsort($values);
// group lower values into 'Other' tag
if (count($values) > 10) {
$other_values = array_slice($values, 13);
$values = array_slice($values, 0, 12);
$values['Other'] = 0;
foreach ($other_values as $val) {
$values['Other'] += $val;
}
}
}
}
}
}
}
$questions[] = array('ID' => $graph->Question()->ID, 'Graph' => $graph->Type, 'Title' => $graph->Label, 'Values' => $values, 'Total' => $total_answers, 'ExtraLabel' => $extra_label);
}
$section_map['Questions'] = $questions;
return $section_map;
}
