, UGent Internship * @author Patrick Cool , Ghent University: code cleaning * @author Julio Montoya , MORE code cleaning 2011 * * @abstract The task of the internship was to integrate the 'send messages to specific users' with the * Announcements tool and also add the resource linker here. The database also needed refactoring * as there was no title field (the title was merged into the content field) * * @package chamilo.announcements * multiple functions */ // use anonymous mode when accessing this course tool $use_anonymous = true; // setting the global file that gets the general configuration, the databases, the languages, ... require_once __DIR__.'/../inc/global.inc.php'; api_protect_course_script(true); api_protect_course_group(GroupManager::GROUP_TOOL_ANNOUNCEMENT); $token = Security::get_existing_token(); $courseId = api_get_course_int_id(); $_course = api_get_course_info_by_id($courseId); $group_id = api_get_group_id(); $sessionId = api_get_session_id(); $current_course_tool = TOOL_ANNOUNCEMENT; $this_section = SECTION_COURSES; $nameTools = get_lang('ToolAnnouncement'); $allowToEdit = ( api_is_allowed_to_edit(false, true) || (api_get_course_setting('allow_user_edit_announcement') && !api_is_anonymous()) ); $sessionId = api_get_session_id(); $drhHasAccessToSessionContent = api_drh_can_access_all_session_content(); if (!empty($sessionId) && $drhHasAccessToSessionContent) { $allowToEdit = $allowToEdit || api_is_drh(); } // Configuration settings $display_announcement_list = true; $display_form = false; $display_title_list = true; // Maximum title messages to display $maximum = '12'; // Length of the titles $length = '36'; // Database Table Definitions $tbl_courses = Database::get_main_table(TABLE_MAIN_COURSE); $tbl_sessions = Database::get_main_table(TABLE_MAIN_SESSION); $tbl_announcement = Database::get_course_table(TABLE_ANNOUNCEMENT); $tbl_item_property = Database::get_course_table(TABLE_ITEM_PROPERTY); $isTutor = false; if (!empty($group_id)) { $groupProperties = GroupManager:: get_group_properties($group_id); $interbreadcrumb[] = [ 'url' => api_get_path(WEB_CODE_PATH)."group/group.php?".api_get_cidreq(), 'name' => get_lang('Groups'), ]; $interbreadcrumb[] = [ 'url' => api_get_path(WEB_CODE_PATH)."group/group_space.php?".api_get_cidreq(), 'name' => get_lang('GroupSpace').' '.$groupProperties['name'], ]; if ($allowToEdit === false) { // Check if user is tutor group $isTutor = GroupManager::is_tutor_of_group(api_get_user_id(), $groupProperties, $courseId); if ($isTutor) { $allowToEdit = true; } } } /* Tracking */ Event::event_access_tool(TOOL_ANNOUNCEMENT); $announcement_id = isset($_GET['id']) ? (int) $_GET['id'] : null; $action = isset($_GET['action']) ? Security::remove_XSS($_GET['action']) : 'list'; $announcement_number = AnnouncementManager::getNumberAnnouncements(); $homeUrl = api_get_self().'?action=list&'.api_get_cidreq(); $content = ''; $searchFormToString = ''; $logInfo = [ 'tool' => TOOL_ANNOUNCEMENT, 'tool_id' => 0, 'tool_id_detail' => 0, 'action' => $action, ]; Event::registerLog($logInfo); switch ($action) { case 'move': if (!$allowToEdit) { api_not_allowed(true); } /* Move announcement up/down */ if (!empty($_GET['down'])) { $thisAnnouncementId = intval($_GET['down']); $sortDirection = "DESC"; } if (!empty($_GET['up'])) { $thisAnnouncementId = intval($_GET['up']); $sortDirection = "ASC"; } if (!empty($sortDirection)) { if (!in_array(trim(strtoupper($sortDirection)), ['ASC', 'DESC'])) { $sortDirection = 'ASC'; } $announcementInfo = AnnouncementManager::get_by_id($courseId, $thisAnnouncementId); $sql = "SELECT DISTINCT announcement.id, announcement.display_order FROM $tbl_announcement announcement INNER JOIN $tbl_item_property itemproperty ON (announcement.c_id = itemproperty.c_id) WHERE announcement.c_id = $courseId AND itemproperty.c_id = $courseId AND itemproperty.ref = announcement.id AND itemproperty.tool = '".TOOL_ANNOUNCEMENT."' AND itemproperty.visibility <> 2 ORDER BY display_order $sortDirection"; $result = Database::query($sql); $thisAnnouncementOrderFound = false; $thisAnnouncementOrder = null; while (list($announcementId, $announcementOrder) = Database::fetch_row($result)) { if ($thisAnnouncementOrderFound) { $nextAnnouncementId = $announcementId; $nextAnnouncementOrder = $announcementOrder; $sql = "UPDATE $tbl_announcement SET display_order = '$nextAnnouncementOrder' WHERE c_id = $courseId AND id = $thisAnnouncementId"; Database::query($sql); $sql = "UPDATE $tbl_announcement SET display_order = '$thisAnnouncementOrder' WHERE c_id = $courseId AND id = $nextAnnouncementId"; Database::query($sql); break; } // STEP 1 : FIND THE ORDER OF THE ANNOUNCEMENT if ($announcementId == $thisAnnouncementId) { $thisAnnouncementOrder = $announcementOrder; $thisAnnouncementOrderFound = true; } } Display::addFlash(Display::return_message(get_lang('AnnouncementMoved'))); header('Location: '.$homeUrl); exit; } break; case 'view': $interbreadcrumb[] = [ 'url' => api_get_path(WEB_CODE_PATH).'announcements/announcements.php?'.api_get_cidreq(), 'name' => $nameTools, ]; $nameTools = get_lang('View'); $content = AnnouncementManager::displayAnnouncement($announcement_id); break; case 'list': $htmlHeadXtra[] = api_get_jqgrid_js(); $searchForm = new FormValidator( 'search_simple', 'post', api_get_self().'?'.api_get_cidreq(), '', [], FormValidator::LAYOUT_INLINE ); $searchForm->addElement('text', 'keyword', get_lang('Title')); $users = CourseManager::get_user_list_from_course_code(api_get_course_id(), $sessionId); $userList = ['' => '']; if (!empty($users)) { foreach ($users as $user) { $userList[$user['user_id']] = api_get_person_name($user['firstname'], $user['lastname']); } } $users = []; $searchForm->addElement('select', 'user_id', get_lang('Users'), $userList); $searchForm->addButtonSearch(get_lang('Search')); $filterData = []; $keyword = ''; $userIdToSearch = 0; if ($searchForm->validate()) { $filterData = $searchForm->getSubmitValues(); $keyword = $filterData['keyword']; $userIdToSearch = $filterData['user_id']; } // jqgrid will use this URL to do the selects $url = api_get_path(WEB_AJAX_PATH).'model.ajax.php?a=get_course_announcements&'.api_get_cidreq().'&title_to_search='.$keyword.'&user_id_to_search='.$userIdToSearch; $deleteUrl = api_get_path(WEB_AJAX_PATH).'announcement.ajax.php?a=delete_item&'.api_get_cidreq(); $columns = [ get_lang('Title'), get_lang('By'), get_lang('LastUpdateDate'), get_lang('Actions'), ]; // Column config $columnModel = [ [ 'name' => 'title', 'index' => 'title', 'width' => '300', 'align' => 'left', 'sortable' => 'false', ], [ 'name' => 'username', 'index' => 'username', 'width' => '100', 'align' => 'left', 'sortable' => 'false', ], [ 'name' => 'lastedit_date', 'index' => 'lastedit_date', 'width' => '200', 'align' => 'left', 'sortable' => 'false', ], [ 'name' => 'actions', 'index' => 'actions', 'width' => '150', 'align' => 'left', //'formatter' => 'action_formatter', 'sortable' => 'false', ], ]; // Autowidth $extra_params['autowidth'] = 'true'; // height auto $extra_params['height'] = 'auto'; $editOptions = ''; if (api_is_allowed_to_edit() || $isTutor) { $extra_params['multiselect'] = true; $editOptions = ' $("#announcements").jqGrid( "navGrid", "#announcements_pager", { edit: false, add: false, del: true }, { height:280, reloadAfterSubmit:false }, // edit options { height:280, reloadAfterSubmit:false }, // add options { reloadAfterSubmit:false, url: "'.$deleteUrl.'" }, // del options { width:500 } // search options ); '; } $content = ''; $count = AnnouncementManager::getAnnouncements( $token, $announcement_number, true ); if (empty($count)) { $html = ''; if ($allowToEdit && (empty($_GET['origin']) || $_GET['origin'] !== 'learnpath')) { $html .= '
'; $html .= '

'.get_lang('Announcements').'

'; $html .= Display::return_icon('valves.png', '', [], 64); $html .= '
'; $html .= Display::url( get_lang('AddAnnouncement'), api_get_self()."?".api_get_cidreq()."&action=add", ['class' => 'btn btn-primary'] ); $html .= '
'; $html .= '
'; } else { $html = Display::return_message(get_lang('NoAnnouncements'), 'warning'); } $content = $html; } else { $content .= Display::grid_html('announcements'); } break; case 'delete': /* Delete announcement */ $id = intval($_GET['id']); if ($sessionId != 0 && api_is_allowed_to_session_edit(false, true) == false) { api_not_allowed(); } $delete = false; if (api_is_platform_admin()) { $delete = true; } if (!api_is_session_general_coach() || api_is_element_in_the_session(TOOL_ANNOUNCEMENT, $id)) { $delete = true; } if ($delete) { AnnouncementManager::delete_announcement($_course, $id); Display::addFlash(Display::return_message(get_lang('AnnouncementDeleted'))); } header('Location: '.$homeUrl); exit; break; case 'delete_all': if (api_is_allowed_to_edit()) { $allow = api_get_configuration_value('disable_delete_all_announcements'); if ($allow === false) { AnnouncementManager::delete_all_announcements($_course); Display::addFlash(Display::return_message(get_lang('AnnouncementDeletedAll'))); } header('Location: '.$homeUrl); exit; } break; case 'delete_attachment': $id = (int) $_GET['id_attach']; if (api_is_allowed_to_edit()) { AnnouncementManager::delete_announcement_attachment_file($id); } header('Location: '.$homeUrl); exit; break; case 'showhide': if (!isset($_GET['isStudentView']) || $_GET['isStudentView'] != 'false') { if (isset($_GET['id']) && $_GET['id']) { if ($sessionId != 0 && api_is_allowed_to_session_edit(false, true) == false ) { api_not_allowed(); } if (!$allowToEdit) { api_not_allowed(true); } if (!api_is_session_general_coach() || api_is_element_in_the_session(TOOL_ANNOUNCEMENT, $_GET['id']) ) { AnnouncementManager::change_visibility_announcement( $_course, $_GET['id'] ); Display::addFlash(Display::return_message(get_lang('VisibilityChanged'))); header('Location: '.$homeUrl); exit; } } } break; case 'add': case 'modify': if ($sessionId != 0 && api_is_allowed_to_session_edit(false, true) == false ) { api_not_allowed(true); } if (!$allowToEdit) { api_not_allowed(true); } // DISPLAY ADD ANNOUNCEMENT COMMAND $id = isset($_GET['id']) ? (int) $_GET['id'] : 0; $url = api_get_self().'?action='.$action.'&id='.$id.'&'.api_get_cidreq(); $form = new FormValidator( 'announcement', 'post', $url, null, ['enctype' => 'multipart/form-data'] ); $form_name = get_lang('ModifyAnnouncement'); if (empty($id)) { $form_name = get_lang('AddAnnouncement'); } $interbreadcrumb[] = [ 'url' => api_get_path(WEB_CODE_PATH).'announcements/announcements.php?'.api_get_cidreq(), 'name' => $nameTools, ]; $nameTools = $form_name; $form->addHeader($form_name); $form->addButtonAdvancedSettings( 'choose_recipients', [get_lang('ChooseRecipients')] ); $form->addHtml(''); $form->addCheckBox('email_ann', '', get_lang('EmailOption')); if (!isset($announcement_to_modify)) { $announcement_to_modify = ''; } $announcementInfo = []; if (!empty($id)) { $announcementInfo = AnnouncementManager::get_by_id($courseId, $id); } $showSubmitButton = true; if (!empty($announcementInfo)) { $to = AnnouncementManager::loadEditUsers('announcement', $id); if (!empty($group_id)) { $separated = CourseManager::separateUsersGroups($to); if (isset($separated['groups']) && count($separated['groups']) > 1) { $form->freeze(); Display::addFlash(Display::return_message(get_lang('LockByTeacher'))); $showSubmitButton = false; } } $defaults = [ 'title' => $announcementInfo['title'], 'content' => $announcementInfo['content'], 'id' => $announcementInfo['id'], 'users' => $to, ]; } else { $defaults = []; if (!empty($to)) { $defaults['users'] = $to; } } $ajaxUrl = api_get_path(WEB_AJAX_PATH).'announcement.ajax.php?'.api_get_cidreq().'&a=preview'; $form->addHtml(" "); if (isset($defaults['users'])) { foreach ($defaults['users'] as $value) { $parts = explode(':', $value); if (!isset($parts[1]) || empty($parts[1])) { continue; } $form->addHtml( " "); break; } } $defaults['email_ann'] = true; $form->addElement( 'text', 'title', get_lang('EmailTitle'), ['onkeypress' => 'return event.keyCode != 13;'] ); $form->addRule('title', get_lang('ThisFieldIsRequired'), 'required'); $form->addElement('hidden', 'id'); $htmlTags = ''; $tags = AnnouncementManager::getTags(); foreach ($tags as $tag) { $htmlTags .= "$tag
"; } $form->addButtonAdvancedSettings('tags', get_lang('Tags')); $form->addElement('html', ''); $form->addHtmlEditor( 'content', get_lang('Description'), true, false, ['ToolbarSet' => 'Announcements'] ); $form->addElement('file', 'user_upload', get_lang('AddAnAttachment')); $form->addElement('textarea', 'file_comment', get_lang('FileComment')); $form->addHidden('sec_token', $token); if (empty($sessionId)) { $form->addCheckBox('send_to_users_in_session', null, get_lang('SendToUsersInSessions')); } $config = api_get_configuration_value('announcements_hide_send_to_hrm_users'); if ($config === false) { $form->addCheckBox( 'send_to_hrm_users', null, get_lang('SendAnnouncementCopyToDRH'), ['id' => 'send_to_hrm_users'] ); } $form->addCheckBox('send_me_a_copy_by_email', null, get_lang('SendAnnouncementCopyToMyself')); $defaults['send_me_a_copy_by_email'] = true; if ($showSubmitButton) { $form->addLabel('', Display::url( get_lang('Preview'), 'javascript:void(0)', ['class' => 'btn btn-default', 'id' => 'announcement_preview'] ).'' ); $form->addHtml(''); } $form->setDefaults($defaults); if ($form->validate()) { $data = $form->getSubmitValues(); $data['users'] = isset($data['users']) ? $data['users'] : []; $sendToUsersInSession = isset($data['send_to_users_in_session']) ? true : false; $sendMeCopy = isset($data['send_me_a_copy_by_email']) ? true : false; if (isset($id) && $id) { // there is an Id => the announcement already exists => update mode if (Security::check_token('post')) { $file_comment = $_POST['file_comment']; $file = $_FILES['user_upload']; AnnouncementManager::edit_announcement( $id, $data['title'], $data['content'], $data['users'], $file, $file_comment, $sendToUsersInSession ); // Send mail $messageSentTo = []; if (isset($_POST['email_ann']) && empty($_POST['onlyThoseMails'])) { $messageSentTo = AnnouncementManager::sendEmail( api_get_course_info(), api_get_session_id(), $id, $sendToUsersInSession, isset($data['send_to_hrm_users']) ); } if ($sendMeCopy && !in_array(api_get_user_id(), $messageSentTo)) { $email = new AnnouncementEmail(api_get_course_info(), api_get_session_id(), $id); $email->sendAnnouncementEmailToMySelf(); } Display::addFlash( Display::return_message( get_lang('AnnouncementModified'), 'success' ) ); Security::clear_token(); header('Location: '.$homeUrl); exit; } } else { // Insert mode if (Security::check_token('post')) { $file = $_FILES['user_upload']; $file_comment = $data['file_comment']; if (empty($group_id)) { $insert_id = AnnouncementManager::add_announcement( api_get_course_info(), api_get_session_id(), $data['title'], $data['content'], $data['users'], $file, $file_comment, null, $sendToUsersInSession ); } else { $insert_id = AnnouncementManager::addGroupAnnouncement( $data['title'], $data['content'], $group_id, $data['users'], $file, $file_comment, $sendToUsersInSession ); } if ($insert_id) { Display::addFlash( Display::return_message( get_lang('AnnouncementAdded'), 'success' ) ); // Send mail $messageSentTo = []; if (isset($data['email_ann']) && $data['email_ann']) { $messageSentTo = AnnouncementManager::sendEmail( api_get_course_info(), api_get_session_id(), $insert_id, $sendToUsersInSession ); } if ($sendMeCopy && !in_array(api_get_user_id(), $messageSentTo)) { $email = new AnnouncementEmail(api_get_course_info(), api_get_session_id(), $insert_id); $email->sendAnnouncementEmailToMySelf(); } Security::clear_token(); header('Location: '.$homeUrl); exit; } api_not_allowed(true); } // end condition token } } $content = $form->returnForm(); break; } if (!empty($_GET['remind_inactive'])) { $to[] = 'USER:'.intval($_GET['remind_inactive']); } if (empty($_GET['origin']) or $_GET['origin'] !== 'learnpath') { // We are not in the learning path Display::display_header($nameTools, get_lang('Announcements')); } // Tool introduction if (empty($_GET['origin']) || $_GET['origin'] !== 'learnpath') { Display::display_introduction_section(TOOL_ANNOUNCEMENT); } // Actions $show_actions = false; $actionsLeft = ''; if ($allowToEdit && (empty($_GET['origin']) || $_GET['origin'] !== 'learnpath')) { if (in_array($action, ['add', 'modify', 'view'])) { $actionsLeft .= "". Display::return_icon('back.png', get_lang('Back'), '', ICON_SIZE_MEDIUM). ""; } else { $actionsLeft .= "". Display::return_icon('new_announce.png', get_lang('AddAnnouncement'), '', ICON_SIZE_MEDIUM). ""; } $show_actions = true; } else { if (in_array($action, ['view'])) { $actionsLeft .= "". Display::return_icon('back.png', get_lang('Back'), '', ICON_SIZE_MEDIUM).""; } } if ($allowToEdit && api_get_group_id() == 0) { $allow = api_get_configuration_value('disable_delete_all_announcements'); if ($allow === false) { if (!isset($_GET['action']) || isset($_GET['action']) && $_GET['action'] == 'list' ) { $actionsLeft .= "". Display::return_icon( 'delete_announce.png', get_lang('AnnouncementDeleteAll'), '', ICON_SIZE_MEDIUM ).""; } } } if ($show_actions) { echo Display::toolbarAction('toolbar', [$actionsLeft, $searchFormToString]); } echo $content; if (empty($_GET['origin']) || $_GET['origin'] !== 'learnpath') { //we are not in learnpath tool Display::display_footer(); }