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; }
foreach ($question_answers as $question_answer_id) { $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 (in_array($surveyGroupId, $user->getAllGroupsArray())) { $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)) {