'; if (isset($_GET['action']) && in_array($_GET['action'], array('add', 'modify', 'view'))) { echo "".Display::return_icon( 'back.png', get_lang('Back'), '', ICON_SIZE_MEDIUM ).""; } else { echo "".Display::return_icon( 'new_announce.png', get_lang('AddAnnouncement'), '', ICON_SIZE_MEDIUM ).""; } $show_actions = true; } else { if (isset($_GET['action']) && in_array($_GET['action'], array('view'))) { echo ''; } } if (api_is_allowed_to_edit() && $announcement_number > 1) { if ($group_id == 0) { if (!$show_actions) { echo ''; } // ANNOUNCEMENTS LIST if ($message) { Display::display_confirmation_message($message); $display_announcement_list = true; $display_form = false; } if (!empty($error_message)) { Display::display_error_message($error_message); $display_announcement_list = false; $display_form = true; } /* DISPLAY FORM */ if ($display_form) { $content_to_modify = stripslashes($content_to_modify); $title_to_modify = stripslashes($title_to_modify); // DISPLAY ADD ANNOUNCEMENT COMMAND //echo '

'; $id = isset($_GET['id']) ? intval($_GET['id']) : 0; echo ''; if (empty($_GET['id'])) { $form_name = get_lang('AddAnnouncement'); } else { $form_name = get_lang('ModifyAnnouncement'); } echo '

'.$form_name.'

'; //this variable defines if the course administrator can send a message to a specific user / group or not //@todo use formvalidator if (empty($group_id)) { echo '

'. Display::return_icon( 'group.png', get_lang('ModifyRecipientList'), array('align' => 'absmiddle'), ICON_SIZE_SMALL ).''.get_lang('SentTo').'

'; if (isset($_GET['id']) && is_array($to)) { echo ' '; } elseif (isset($_GET['remind_inactive'])) { $email_ann = '1'; $_SESSION['select_groupusers'] = "show"; $content_to_modify = sprintf(get_lang('RemindInactiveLearnersMailContent'), api_get_setting('siteName'), 7); $title_to_modify = sprintf(get_lang('RemindInactiveLearnersMailSubject'), api_get_setting('siteName')); } elseif (isset($_GET['remindallinactives']) && $_GET['remindallinactives'] == 'true') { // we want to remind inactive users. The $_GET['since'] parameter determines which users have to be warned (i.e the users who have been inactive for x days or more $since = isset($_GET['since']) ? intval($_GET['since']) : 6; // getting the users who have to be reminded $to = Tracking :: get_inactives_students_in_course(api_get_course_int_id(), $since, api_get_session_id()); // setting the variables for the form elements: the users who need to receive the message foreach ($to as &$user) { $user = 'USER:'.$user; } // setting the variables for the form elements: the 'visible to' form element has to be expanded $_SESSION['select_groupusers'] = "show"; // setting the variables for the form elements: the message has to be sent by email $email_ann = '1'; // setting the variables for the form elements: the title of the email $title_to_modify = sprintf(get_lang('RemindInactiveLearnersMailSubject'), api_get_setting('siteName')); // setting the variables for the form elements: the message of the email $content_to_modify = sprintf( get_lang('RemindInactiveLearnersMailContent'), api_get_setting('siteName'), $since ); // when we want to remind the users who have never been active then we have a different subject and content for the announcement if ($_GET['since'] == 'never') { $title_to_modify = sprintf(get_lang('RemindInactiveLearnersMailSubject'), api_get_setting('siteName')); $content_to_modify = get_lang('YourAccountIsActiveYouCanLoginAndCheckYourCourses'); } } else { echo ''.get_lang('Everybody').''; } AnnouncementManager::show_to_form($to); echo '

'; if (!isset($announcement_to_modify)) { $announcement_to_modify = ''; } ($email_ann == '1') ? $checked = 'checked' : $checked = ''; echo '

'.get_lang( 'EmailOption' ).'

'; } else { if (!isset($announcement_to_modify)) { $announcement_to_modify = ""; } ($email_ann == '1') ? $checked = 'checked' : $checked = ''; echo '

'.get_lang('EmailOption').': '.Display::label( get_lang('MyGroup'), 'success' ).' '.get_lang('ModifyRecipientList').''; AnnouncementManager::show_to_form_group($group_id, $to); echo '

'; } // the announcement title echo '

* '.get_lang('EmailTitle').'

'; unset($title_to_modify); $title_to_modify = null; if (!isset($announcement_to_modify)) { $announcement_to_modify = ""; } if (!isset($content_to_modify)) { $content_to_modify = ""; } if (!isset($title_to_modify)) { $title_to_modify = ""; } echo ''; $oFCKeditor = new FCKeditor('newContent'); $oFCKeditor->Width = '100%'; $oFCKeditor->Height = '300'; if (!api_is_allowed_to_edit()) { $oFCKeditor->ToolbarSet = "AnnouncementsStudent"; } else { $oFCKeditor->ToolbarSet = "Announcements"; } $oFCKeditor->Value = $content_to_modify; echo '

'; echo Display::display_normal_message( get_lang('Tags').'

'.implode('
', AnnouncementManager::get_tags()), false ); echo $oFCKeditor->CreateHtml(); echo '

'; //File attachment echo '

'.$showImg.' '.get_lang( 'AddAnAttachment' ).'

'.get_lang('FileName').'

'.get_lang('FileComment').'

'; echo'
'; echo '

'; if (empty($group_id)) { echo ''; echo ''; echo ''.get_lang( 'ButtonPublishAnnouncement' ).'

'; } else { echo ''; echo ''; echo ''.get_lang( 'ButtonPublishAnnouncement' ).'

'; } echo '

'; echo '

'; if ((isset($_GET['action']) && isset($_GET['id']) && is_array( $to )) || isset($_GET['remindallinactives']) || isset($_GET['remind_inactive']) ) { echo ''; } } // displayform /* DISPLAY ANNOUNCEMENT LIST */ if ($display_announcement_list) { $user_id = api_get_user_id(); $group_id = api_get_group_id(); $group_memberships = GroupManager::get_group_ids($course_id, api_get_user_id()); if (api_is_allowed_to_edit(false, true) OR (api_get_course_setting( 'allow_user_edit_announcement' ) && !api_is_anonymous()) ) { // A.1. you are a course admin with a USER filter // => see only the messages of this specific user + the messages of the group (s)he is member of. if (!empty($_SESSION['user'])) { if (is_array($group_memberships) && count($group_memberships) > 0) { $sql = "SELECT announcement.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.insert_date FROM $tbl_announcement announcement, $tbl_item_property ip WHERE announcement.c_id = $course_id AND ip.c_id = $course_id AND announcement.id = ip.ref AND ip.tool = 'announcement' AND (ip.to_user_id = $user_id OR ip.to_group_id IN (0, ".implode(", ", $group_memberships).") ) $condition_session ORDER BY display_order DESC"; } else { $sql = "SELECT announcement.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.insert_date FROM $tbl_announcement announcement, $tbl_item_property ip WHERE announcement.c_id = $course_id AND ip.c_id = $course_id AND announcement.id = ip.ref AND ip.tool ='announcement' AND (ip.to_user_id = $user_id OR ip.to_group_id='0') AND ip.visibility='1' $condition_session ORDER BY display_order DESC"; } } elseif (api_get_group_id() != 0) { // A.2. you are a course admin with a GROUP filter // => see only the messages of this specific group $sql = "SELECT announcement.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.insert_date FROM $tbl_announcement announcement, $tbl_item_property ip WHERE announcement.c_id = $course_id AND ip.c_id = $course_id AND announcement.id = ip.ref AND ip.tool='announcement' AND ip.visibility<>'2' AND (ip.to_group_id = $group_id OR ip.to_group_id='0') $condition_session GROUP BY ip.ref ORDER BY display_order DESC"; } else { // A.3 you are a course admin without any group or user filter // A.3.a you are a course admin without user or group filter but WITH studentview // => see all the messages of all the users and groups without editing possibilities if (isset($isStudentView) and $isStudentView == "true") { $sql = "SELECT announcement.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.insert_date FROM $tbl_announcement announcement, $tbl_item_property ip WHERE announcement.c_id = $course_id AND ip.c_id = $course_id AND announcement.id = ip.ref AND ip.tool='announcement' AND ip.visibility='1' $condition_session GROUP BY ip.ref ORDER BY display_order DESC"; } else { // A.3.a you are a course admin without user or group filter and WITHOUT studentview (= the normal course admin view) // => see all the messages of all the users and groups with editing possibilities $sql = "SELECT announcement.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.insert_date FROM $tbl_announcement announcement, $tbl_item_property ip WHERE announcement.c_id = $course_id AND ip.c_id = $course_id AND announcement.id = ip.ref AND ip.tool='announcement' AND (ip.visibility='0' or ip.visibility='1') AND to_group_id = 0 $condition_session GROUP BY ip.ref ORDER BY display_order DESC"; } } } else { //STUDENT if (is_array($group_memberships) && count($group_memberships) > 0) { if (AnnouncementManager::user_can_edit_announcement()) { if (api_get_group_id() == 0) { //No group $cond_user_id = " AND (ip.lastedit_user_id = '".api_get_user_id( )."' OR ( ip.to_user_id='".$_user['user_id']."'". " OR ip.to_group_id IN (0, ".implode(", ", $group_memberships)."))) "; } else { $cond_user_id = " AND ( ip.lastedit_user_id = '".api_get_user_id()."' OR ip.to_group_id IN (".api_get_group_id().") )"; } } else { if (api_get_group_id() == 0) { $cond_user_id = " AND (ip.to_user_id=$user_id OR ip.to_group_id IN (0, ".implode( ", ", $group_memberships ).")) "; } else { $cond_user_id = " AND ( (ip.to_user_id = $user_id AND ip.to_group_id = ".api_get_group_id().") OR (ip.to_group_id IN (".api_get_group_id().") AND ip.to_user_id = 0 ) )"; } } $visibility_condition = " ip.visibility='1'"; if (GroupManager::is_tutor_of_group(api_get_user_id(), $group_id)) { $visibility_condition = " ip.visibility IN ('0', '1') "; } $sql = "SELECT announcement.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.insert_date FROM $tbl_announcement announcement, $tbl_item_property ip WHERE announcement.c_id = $course_id AND ip.c_id = $course_id AND announcement.id = ip.ref AND ip.tool='announcement' $cond_user_id $condition_session AND $visibility_condition ORDER BY display_order DESC"; } else { if ($_user['user_id']) { if ((api_get_course_setting('allow_user_edit_announcement') && !api_is_anonymous())) { $cond_user_id = " AND (ip.lastedit_user_id = '".api_get_user_id( )."' OR (ip.to_user_id='".$_user['user_id']."' OR ip.to_group_id='0')) "; } else { $cond_user_id = " AND (ip.to_user_id='".$_user['user_id']."' OR ip.to_group_id='0') "; } $sql = "SELECT announcement.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.insert_date FROM $tbl_announcement announcement, $tbl_item_property ip WHERE announcement.c_id = $course_id AND ip.c_id = $course_id AND announcement.id = ip.ref AND ip.tool='announcement' $cond_user_id $condition_session AND ip.visibility='1' AND announcement.session_id IN(0,".api_get_session_id().") ORDER BY display_order DESC"; } else { if ((api_get_course_setting('allow_user_edit_announcement') && !api_is_anonymous())) { $cond_user_id = " AND (ip.lastedit_user_id = '".api_get_user_id()."' OR ip.to_group_id='0' ) "; } else { $cond_user_id = " AND ip.to_group_id='0' "; } $sql = "SELECT announcement.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.insert_date FROM $tbl_announcement announcement, $tbl_item_property ip WHERE announcement.c_id = $course_id AND ip.c_id = $course_id AND announcement.id = ip.ref AND ip.tool='announcement' $cond_user_id $condition_session AND ip.visibility='1' AND announcement.session_id IN(0,".api_get_session_id().")"; } } } $result = Database::query($sql); $num_rows = Database::num_rows($result); // DISPLAY: NO ITEMS if (!isset($_GET['action']) || !in_array($_GET['action'], array('add', 'modify', 'view'))) { if ($num_rows == 0) { if ((api_is_allowed_to_edit(false, true) OR (api_get_course_setting( 'allow_user_edit_announcement' ) && !api_is_anonymous())) and (empty($_GET['origin']) or $_GET['origin'] !== 'learnpath') ) { echo ''; } else { Display::display_warning_message(get_lang('NoAnnouncements')); } } else { $iterator = 1; $bottomAnnouncement = $announcement_number; echo ''; $ths = Display::tag('th', get_lang('Title')); $ths .= Display::tag('th', get_lang('By')); $ths .= Display::tag('th', get_lang('LastUpdateDate')); if (api_is_allowed_to_edit(false, true) OR (api_is_course_coach() && api_is_element_in_the_session( TOOL_ANNOUNCEMENT, $myrow['id'] )) OR (api_get_course_setting('allow_user_edit_announcement') && !api_is_anonymous()) ) { $ths .= Display::tag('th', get_lang('Modify')); } echo Display::tag('tr', $ths); $displayed = array(); while ($myrow = Database::fetch_array($result, 'ASSOC')) { if (!in_array($myrow['id'], $displayed)) { $sent_to_icon = ''; // the email icon if ($myrow['email_sent'] == '1') { $sent_to_icon = ' '.Display::return_icon('email.gif', get_lang('AnnounceSentByEmail')); } $title = $myrow['title'].$sent_to_icon; $item_visibility = api_get_item_visibility( $_course, TOOL_ANNOUNCEMENT, $myrow['id'], $session_id ); $myrow['visibility'] = $item_visibility; // the styles if ($myrow['visibility'] == '0') { $style = 'invisible'; } else { $style = ''; } echo ""; // show attachment list $attachment_list = AnnouncementManager::get_attachment($myrow['id']); $attachment_icon = ''; if (count($attachment_list) > 0) { $attachment_icon = ' '.Display::return_icon('attachment.gif', get_lang('Attachment')); } /* TITLE */ $title = Display::url($title.$attachment_icon, '?action=view&id='.$myrow['id']); echo Display::tag('td', Security::remove_XSS($title), array('class' => $style)); $user_info = api_get_user_info($myrow['insert_user_id']); $username = sprintf(get_lang("LoginX"), $user_info['username']); $username_span = Display::tag( 'span', api_get_person_name($user_info['firstName'], $user_info['lastName']), array('title' => $username) ); echo Display::tag('td', $username_span); echo Display::tag( 'td', api_convert_and_format_date($myrow['insert_date'], DATE_TIME_FORMAT_LONG) ); // we can edit if : we are the teacher OR the element belongs to the session we are coaching OR the option to allow users to edit is on $modify_icons = ''; if (api_is_allowed_to_edit(false, true) OR (api_is_course_coach() && api_is_element_in_the_session( TOOL_ANNOUNCEMENT, $myrow['id'] )) OR (api_get_course_setting('allow_user_edit_announcement') && !api_is_anonymous()) ) { $modify_icons = "".Display::return_icon( 'edit.png', get_lang('Edit'), '', ICON_SIZE_SMALL ).""; if ($myrow['visibility'] == 1) { $image_visibility = "visible"; $alt_visibility = get_lang('Hide'); } else { $image_visibility = "invisible"; $alt_visibility = get_lang('Visible'); } $modify_icons .= "". Display::return_icon( $image_visibility.'.png', $alt_visibility, '', ICON_SIZE_SMALL ).""; // DISPLAY MOVE UP COMMAND only if it is not the top announcement if ($iterator != 1) { $modify_icons .= "".Display::return_icon( 'up.gif', get_lang('Up') ).""; } else { $modify_icons .= Display::return_icon('up_na.gif', get_lang('Up')); } if ($iterator < $bottomAnnouncement) { $modify_icons .= "".Display::return_icon( 'down.gif', get_lang('Down') ).""; } else { $modify_icons .= Display::return_icon('down_na.gif', get_lang('Down')); } if (api_is_allowed_to_edit(false, true)) { $modify_icons .= "". Display::return_icon('delete.png', get_lang('Delete'), '', ICON_SIZE_SMALL). ""; } $iterator++; echo Display::tag('td', $modify_icons); } echo ""; } $displayed[] = $myrow['id']; } // end while echo ""; } } } // end: if ($displayAnnoucementList) if (isset($_GET['action']) && $_GET['action'] == 'view') { AnnouncementManager::display_announcement($announcement_id); } /* FOOTER */ if (empty($_GET['origin']) or $_GET['origin'] !== 'learnpath') { //we are not in learnpath tool Display::display_footer(); }