, 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 */ // name of the language file that needs to be included $language_file = 'survey'; // including the global dokeos file require ('../inc/global.inc.php'); // including additional libraries //require_once (api_get_path(LIBRARY_PATH)."/survey.lib.php"); require_once('survey.lib.php'); require_once (api_get_path(LIBRARY_PATH)."course.lib.php"); require_once (api_get_path(LIBRARY_PATH).'formvalidator/FormValidator.class.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()) { Display :: display_header(); 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); // getting the survey information $survey_data = survey_manager::get_survey($_GET['survey_id']); $urlname = substr(strip_tags($survey_data['title']), 0, 40); if (strlen(strip_tags($survey_data['title'])) > 40) { $urlname .= '...'; } // breadcrumbs $interbreadcrumb[] = array ('url' => 'survey_list.php', 'name' => get_lang('SurveyList')); $interbreadcrumb[] = array ('url' => 'survey.php?survey_id='.$_GET['survey_id'], 'name' => $urlname); $tool_name = get_lang('SurveyInvitations'); // Displaying the header Display::display_header($tool_name); // Checking the parameters if (!is_numeric($_GET['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($_GET['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 ' '; echo ' '; $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 WHERE survey_invitation.survey_code = '".Database::escape_string($survey_data['code'])."'"; $res = api_sql_query($sql, __FILE__, __LINE__); while ($row = mysql_fetch_assoc($res)) { if (!$_GET['view'] OR $_GET['view'] == 'invited' OR ($_GET['view'] == 'answered' AND in_array($row['user'], $answered_data)) OR ($_GET['view'] == 'unanswered' AND !in_array($row['user'], $answered_data))) { echo ''; if (is_numeric($row['user'])) { echo ' '; } else { echo ' '; } /** @todo this is temporary to allow the developer to quickly fill a survey as a different user */ // echo ' '; echo ' '; echo ' '; echo ' '; echo ''; } } // closing the table echo '
'.get_lang('User').''.get_lang('InvitationCode').''.get_lang('InvitationDate').''.get_lang('Answered').'
'.$row['firstname'].' '.$row['lastname'].''.$row['user'].''.$row['invitation_code'].''.$row['invitation_code'].''.$row['invitation_date'].''; if (in_array($row['user'], $answered_data)) { echo ''.get_lang('ViewAnswers').''; } else { echo '-'; } echo '
'; // Footer Display :: display_footer(); /** * @todo add the additional parameters */ /* $table = new SortableTable('survey_invitations', 'get_number_of_survey_invitations', 'get_survey_invitations_data',2); $table->set_additional_parameters($parameters); $table->set_header(0, get_lang('User')); $table->set_header(1, get_lang('InvitationCode')); $table->set_header(2, get_lang('InvitationDate')); $table->set_header(3, get_lang('Answered')); $table->set_column_filter(3, 'modify_filter'); $table->display(); */ /** * Get all the information about the invitations of a certain survey * * @return unknown * * @author Patrick Cool , Ghent University * @version January 2007 * * @todo use survey_id parameter instead of $_GET */ function get_survey_invitations_data() { // Database table definition $table_survey_invitation = Database :: get_course_table(TABLE_SURVEY_INVITATION); $table_user = Database :: get_main_table(TABLE_MAIN_USER); $sql = "SELECT survey_invitation.user as col1, survey_invitation.invitation_code as col2, survey_invitation.invitation_date as col3, '' as col4 FROM $table_survey_invitation survey_invitation LEFT JOIN $table_user user ON survey_invitation.user = user.user_id WHERE survey_invitation.survey_id = '".Database::escape_string($_GET['survey_id'])."'"; $res = api_sql_query($sql, __FILE__, __LINE__); while ($row = mysql_fetch_array($res)) { $survey_invitation_data[] = $row; } return $survey_invitation_data; } /** * Get the total number of survey invitations for a given survey (through $_GET['survey_id']) * * @return unknown * * @todo use survey_id parameter instead of $_GET * * @author Patrick Cool , Ghent University * @version January 2007 */ function get_number_of_survey_invitations() { // Database table definition $table_survey_invitation = Database :: get_course_table(TABLE_SURVEY_INVITATION); $sql = "SELECT count(user) AS total FROM $table_survey_invitation WHERE survey_id='".Database::escape_string($_GET['survey_id'])."'"; $res = api_sql_query($sql, __FILE__, __LINE__); $row = mysql_fetch_assoc($res); return $row['total']; } /** * @todo use global array for answered or not * * @author Patrick Cool , Ghent University * @version January 2007 */ function modify_filter() { } ?>