function getVotedUsersBirthYear()
{
$votedUsersBirthYear = array();
$votedUsers = $this->getVotedUsers();
foreach ($votedUsers as $votedUserId) {
$user = new UserFunctions();
$user->get_from_db($votedUserId);
array_push($votedUsersBirthYear, $user->getBirthYear());
}
$votedUsersBirthYear = array_unique($votedUsersBirthYear);
asort($votedUsersBirthYear);
return $votedUsersBirthYear;
}
$answer = new Answer();
$answer->get_from_db($question_answer_id);
$cell = divideBy26($columnId) . "2";
$cell_value = $answer->getValue();
// Add some data
$objPHPExcel->setActiveSheetIndex($sheetId)->setCellValue($cell, $cell_value);
$objPHPExcel->getActiveSheet()->getColumnDimension(divideBy26($columnId))->setWidth(15);
$objPHPExcel->getActiveSheet()->getStyle($cell)->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_LEFT);
$columnId++;
}
// list users by survey and group
$row_id = 3;
foreach ($voted_users as $voted_user_id) {
$user = new UserFunctions();
$user->get_from_db($voted_user_id);
if ($user->getBirthYear() == $questionVotedUsersBirthYear) {
$cell = 'A' . $row_id;
$user_number = $row_id - 2;
$cell_value = 'User' . $user_number;
// Add some data
$objPHPExcel->setActiveSheetIndex($sheetId)->setCellValue($cell, $cell_value);
// list votes by user
$columnId = 2;
foreach ($question_answers as $question_answer_id) {
$vote = new Vote();
$vote_id_array = $vote->get_by_user_and_answer($voted_user_id, $question_answer_id);
$cell_value = "";
$answer = new Answer();
$answer->get_from_db($question_answer_id);
if (!empty($vote_id_array)) {
$vote_id = $vote_id_array[0];
