, Ghent University: cleanup, refactoring and rewriting large parts of the code * @version $Id: survey_invite.php 10680 2007-01-11 21:26:23Z pcool $ * * @todo the answered column */ // Language file that needs to be included $language_file = 'survey'; // Including the global initialization file require '../inc/global.inc.php'; // Including additional libraries require_once 'survey.lib.php'; require_once api_get_path(LIBRARY_PATH).'mail.lib.inc.php'; /** @todo this has to be moved to a more appropriate place (after the display_header of the code)*/ if (!api_is_allowed_to_edit(false, true)) { Display :: display_header(get_lang('ToolSurvey')); Display :: display_error_message(get_lang('NotAllowed'), false); Display :: display_footer(); exit; } // Database table definitions $table_survey = Database :: get_course_table(TABLE_SURVEY); $table_survey_question = Database :: get_course_table(TABLE_SURVEY_QUESTION); $table_survey_question_option = Database :: get_course_table(TABLE_SURVEY_QUESTION_OPTION); $table_course = Database :: get_main_table(TABLE_MAIN_COURSE); $table_user = Database :: get_main_table(TABLE_MAIN_USER); $table_survey_invitation = Database :: get_course_table(TABLE_SURVEY_INVITATION); $tool_name = get_lang('SurveyInvitations'); // Getting the survey information // We exit here if ther is no valid $_GET parameter if (!isset($_GET['survey_id']) OR !is_numeric($_GET['survey_id'])) { Display :: display_header($tool_name); Display :: display_error_message(get_lang('InvallidSurvey'), false); Display :: display_footer(); exit; } $survey_id = Security::remove_XSS($_GET['survey_id']); $survey_data = survey_manager::get_survey($survey_id); if (empty($survey_data)) { Display :: display_header($tool_name); Display :: display_error_message(get_lang('InvallidSurvey'), false); Display :: display_footer(); exit; } $urlname = strip_tags(api_substr(api_html_entity_decode($survey_data['title'], ENT_QUOTES), 0, 40)); if (api_strlen(strip_tags($survey_data['title'])) > 40) { $urlname .= '...'; } // Breadcrumbs $interbreadcrumb[] = array('url' => api_get_path(WEB_CODE_PATH).'survey/survey_list.php', 'name' => get_lang('SurveyList')); $interbreadcrumb[] = array('url' => api_get_path(WEB_CODE_PATH).'survey/survey.php?survey_id='.$survey_id, 'name' => $urlname); // Displaying the header Display::display_header($tool_name); // Checking the parameters if (!is_numeric($survey_id)) { Display::display_error_message(get_lang('Error'), false); Display::display_footer(); exit; } // Getting all the people who have filled this survey $answered_data = survey_manager::get_people_who_filled_survey($survey_id); if ($survey_data['anonymous'] == 1) { Display::display_normal_message(get_lang('AnonymousSurveyCannotKnowWhoAnswered').' '.count($answered_data).' '.get_lang('PeopleAnswered')); $answered_data = array(); } if (!isset($_GET['view']) OR $_GET['view'] == 'invited') { echo get_lang('ViewInvited'). ' | '; } else { echo ' '.get_lang('ViewInvited').' |'; } if ($_GET['view'] == 'answered') { echo get_lang('ViewAnswered').' | '; } else { echo ' '.get_lang('ViewAnswered').' |'; } if ($_GET['view'] == 'unanswered') { echo get_lang('ViewUnanswered'); } else { echo ' '.get_lang('ViewUnanswered').''; } // Table header echo ''; echo ' '; echo ' '; echo ' '; echo ' '; echo ' '; $course_id = api_get_course_int_id(); $sql = "SELECT survey_invitation.*, user.firstname, user.lastname, user.email FROM $table_survey_invitation survey_invitation LEFT JOIN $table_user user ON (survey_invitation.user = user.user_id AND survey_invitation.c_id = $course_id) WHERE survey_invitation.survey_code = '".Database::escape_string($survey_data['code'])."' "; $res = Database::query($sql); while ($row = Database::fetch_assoc($res)) { if (!$_GET['view'] || $_GET['view'] == 'invited' || ($_GET['view'] == 'answered' && in_array($row['user'], $answered_data)) || ($_GET['view'] == 'unanswered' && !in_array($row['user'], $answered_data))) { echo ''; if (is_numeric($row['user'])) { echo ' '; } else { echo ' '; } echo ' '; echo ' '; echo ''; } } // Closing the table echo '

'.get_lang('User').'	'.get_lang('InvitationDate').'	'.get_lang('Answered').'
'.api_get_person_name($row['firstname'], $row['lastname']).'	'.$row['user'].'	'.$row['invitation_date'].'	'; if (in_array($row['user'], $answered_data)) { echo ''.get_lang('ViewAnswers').''; } else { echo '-'; } echo '

'; // Footer Display :: display_footer();