*/ class Agenda { public $events = array(); /** @var string Current type */ public $type = 'personal'; public $types = array('personal', 'admin', 'course'); public $sessionId = 0; public $senderId; /** @var array */ public $course; /** @var array */ private $sessionInfo; /** @var string */ public $comment; /** @var bool */ private $isAllowedToEdit; public $eventStudentPublicationColor; /** * Constructor * @param string $type * @param int $senderId Optional The user sender ID * @param int $courseId Opitonal. The course ID * @param int $sessionId Optional The session ID */ public function __construct( $type, $senderId = 0, $courseId = 0, $sessionId = 0 ) { // Table definitions $this->tbl_global_agenda = Database::get_main_table(TABLE_MAIN_SYSTEM_CALENDAR); $this->tbl_personal_agenda = Database::get_main_table(TABLE_PERSONAL_AGENDA); $this->tbl_course_agenda = Database::get_course_table(TABLE_AGENDA); $this->table_repeat = Database::get_course_table(TABLE_AGENDA_REPEAT); $this->setType($type); $this->setSenderId($senderId ?: api_get_user_id()); $isAllowToEdit = false; switch ($type) { case 'course': $sessionId = $sessionId ?: api_get_session_id(); $sessionInfo = api_get_session_info($sessionId); $this->setSessionId($sessionId); $this->setSessionInfo($sessionInfo); // Setting the course object if we are in a course $courseInfo = api_get_course_info_by_id($courseId); if (!empty($courseInfo)) { $this->set_course($courseInfo); } // Check if teacher if (empty($sessionId)) { $isAllowToEdit = api_is_allowed_to_edit(false, true); } else { $isAllowToEdit = api_is_allowed_to_session_edit( false, true ); } // Check if (api_get_course_setting('allow_user_edit_agenda') && api_is_allowed_in_course()) { $isAllowToEdit = true; } $groupId = api_get_group_id(); if (!empty($groupId)) { $groupInfo = GroupManager::get_group_properties($groupId); $userHasAccess = GroupManager::user_has_access( api_get_user_id(), $groupInfo['iid'], GroupManager::GROUP_TOOL_CALENDAR ); $isTutor = GroupManager::is_tutor_of_group( api_get_user_id(), $groupInfo ); $isGroupAccess = $userHasAccess || $isTutor; if ($isGroupAccess) { $isAllowToEdit = true; } else { $isAllowToEdit = false; } } break; case 'admin': $isAllowToEdit = api_is_platform_admin(); break; case 'personal': $isAllowToEdit = !api_is_anonymous(); break; } $this->setIsAllowedToEdit($isAllowToEdit); $this->events = []; // Event colors $this->event_platform_color = 'red'; //red $this->event_course_color = '#458B00'; //green $this->event_group_color = '#A0522D'; //siena $this->event_session_color = '#00496D'; // kind of green $this->eventOtherSessionColor = '#999'; $this->event_personal_color = 'steel blue'; //steel blue $this->eventStudentPublicationColor = '#FF8C00'; //DarkOrange } /** * @param int $senderId */ public function setSenderId($senderId) { $this->senderId = intval($senderId); } /** * @return int */ public function getSenderId() { return $this->senderId; } /** * @param string $type can be 'personal', 'admin' or 'course' */ public function setType($type) { $typeList = $this->getTypes(); if (in_array($type, $typeList)) { $this->type = $type; } } /** * @param int $id */ public function setSessionId($id) { $this->sessionId = intval($id); } /** * @param array $sessionInfo */ public function setSessionInfo($sessionInfo) { $this->sessionInfo = $sessionInfo; } /** * @return int $id */ public function getSessionId() { return $this->sessionId; } /** * @param array $courseInfo */ public function set_course($courseInfo) { $this->course = $courseInfo; } /** * @return array */ public function getTypes() { return $this->types; } /** * Adds an event to the calendar * @param string $start datetime format: 2012-06-14 09:00:00 * @param string $end datetime format: 2012-06-14 09:00:00 * @param string $allDay (true, false) * @param string $title * @param string $content * @param array $usersToSend array('everyone') or a list of user/group ids * @param bool $addAsAnnouncement event as a *course* announcement * @param int $parentEventId * @param array $attachmentArray array of $_FILES[''] * @param array $attachmentCommentList * @param string $eventComment * @param string $color * * @return int */ public function addEvent( $start, $end, $allDay, $title, $content, $usersToSend = array(), $addAsAnnouncement = false, $parentEventId = null, $attachmentArray = array(), $attachmentCommentList = array(), $eventComment = null, $color = '' ) { $start = api_get_utc_datetime($start); $end = api_get_utc_datetime($end); $allDay = isset($allDay) && $allDay === 'true' ? 1 : 0; $id = null; switch ($this->type) { case 'personal': $attributes = array( 'user' => api_get_user_id(), 'title' => $title, 'text' => $content, 'date' => $start, 'enddate' => $end, 'all_day' => $allDay, 'color' => $color ); $id = Database::insert( $this->tbl_personal_agenda, $attributes ); break; case 'course': $attributes = array( 'title' => $title, 'content' => $content, 'start_date' => $start, 'end_date' => $end, 'all_day' => $allDay, 'session_id' => $this->getSessionId(), 'c_id' => $this->course['real_id'], 'comment' => $eventComment, 'color' => $color ); if (!empty($parentEventId)) { $attributes['parent_event_id'] = $parentEventId; } $senderId = $this->getSenderId(); $sessionId = $this->getSessionId(); // Simple course event. $id = Database::insert($this->tbl_course_agenda, $attributes); if ($id) { $sql = "UPDATE ".$this->tbl_course_agenda." SET id = iid WHERE iid = $id"; Database::query($sql); $groupId = api_get_group_id(); $groupInfo = []; if ($groupId) { $groupInfo = GroupManager::get_group_properties( $groupId ); } if (!empty($usersToSend)) { $sendTo = $this->parseSendToArray($usersToSend); if ($sendTo['everyone']) { api_item_property_update( $this->course, TOOL_CALENDAR_EVENT, $id, 'AgendaAdded', $senderId, $groupInfo, '', $start, $end, $sessionId ); api_item_property_update( $this->course, TOOL_CALENDAR_EVENT, $id, 'visible', $senderId, $groupInfo, '', $start, $end, $sessionId ); } else { // Storing the selected groups if (!empty($sendTo['groups'])) { foreach ($sendTo['groups'] as $group) { $groupInfoItem = []; if ($group) { $groupInfoItem = GroupManager::get_group_properties( $group ); if ($groupInfoItem) { $groupIidItem = $groupInfoItem['iid']; } } api_item_property_update( $this->course, TOOL_CALENDAR_EVENT, $id, 'AgendaAdded', $senderId, $groupInfoItem, 0, $start, $end, $sessionId ); api_item_property_update( $this->course, TOOL_CALENDAR_EVENT, $id, 'visible', $senderId, $groupInfoItem, 0, $start, $end, $sessionId ); } } // storing the selected users if (!empty($sendTo['users'])) { foreach ($sendTo['users'] as $userId) { api_item_property_update( $this->course, TOOL_CALENDAR_EVENT, $id, 'AgendaAdded', $senderId, $groupInfo, $userId, $start, $end, $sessionId ); api_item_property_update( $this->course, TOOL_CALENDAR_EVENT, $id, 'visible', $senderId, $groupInfo, $userId, $start, $end, $sessionId ); } } } } // Add announcement. if ($addAsAnnouncement) { $this->storeAgendaEventAsAnnouncement( $id, $usersToSend ); } // Add attachment. if (isset($attachmentArray) && !empty($attachmentArray)) { $counter = 0; foreach ($attachmentArray as $attachmentItem) { $this->addAttachment( $id, $attachmentItem, $attachmentCommentList[$counter], $this->course ); $counter++; } } } break; case 'admin': if (api_is_platform_admin()) { $attributes = array( 'title' => $title, 'content' => $content, 'start_date' => $start, 'end_date' => $end, 'all_day' => $allDay, 'access_url_id' => api_get_current_access_url_id() ); $id = Database::insert( $this->tbl_global_agenda, $attributes ); } break; } return $id; } /** * @param int $eventId * @param int $courseId * * @return array */ public function getRepeatedInfoByEvent($eventId, $courseId) { $repeatTable = Database::get_course_table(TABLE_AGENDA_REPEAT); $eventId = intval($eventId); $courseId = intval($courseId); $sql = "SELECT * FROM $repeatTable WHERE c_id = $courseId AND cal_id = $eventId"; $res = Database::query($sql); $repeatInfo = array(); if (Database::num_rows($res) > 0) { $repeatInfo = Database::fetch_array($res, 'ASSOC'); } return $repeatInfo; } /** * @param int $eventId * @param string $type * @param string $end in local time * @param array $sentTo * * @return bool */ public function addRepeatedItem($eventId, $type, $end, $sentTo = array()) { $t_agenda = Database::get_course_table(TABLE_AGENDA); $t_agenda_r = Database::get_course_table(TABLE_AGENDA_REPEAT); if (empty($this->course)) { return false; } $course_id = $this->course['real_id']; $eventId = intval($eventId); $sql = "SELECT title, content, start_date, end_date, all_day FROM $t_agenda WHERE c_id = $course_id AND id = $eventId"; $res = Database::query($sql); if (Database::num_rows($res) !== 1) { return false; } $row = Database::fetch_array($res); $origStartDate = api_strtotime($row['start_date'], 'UTC'); $origEndDate = api_strtotime($row['end_date'], 'UTC'); $diff = $origEndDate - $origStartDate; $title = $row['title']; $content = $row['content']; $allDay = $row['all_day']; $now = time(); $type = Database::escape_string($type); $end = api_strtotime($end); if (1 <= $end && $end <= 500) { // We assume that, with this type of value, the user actually gives a count of repetitions //and that he wants us to calculate the end date with that (particularly in case of imports from ical) switch ($type) { case 'daily': $end = $origStartDate + (86400 * $end); break; case 'weekly': $end = $this->addWeek($origStartDate, $end); break; case 'monthlyByDate': $end = $this->addMonth($origStartDate, $end); break; case 'monthlyByDay': //TODO break; case 'monthlyByDayR': //TODO break; case 'yearly': $end = $this->addYear($origStartDate, $end); break; } } $typeList = array( 'daily', 'weekly', 'monthlyByDate', 'monthlyByDay', 'monthlyByDayR', 'yearly' ); // The event has to repeat *in the future*. We don't allow repeated // events in the past if ($end > $now && in_array($type, $typeList)) { $sql = "INSERT INTO $t_agenda_r (c_id, cal_id, cal_type, cal_end) VALUES ($course_id, '$eventId', '$type', '$end')"; Database::query($sql); switch ($type) { // @todo improve loop. case 'daily': for ($i = $origStartDate + 86400; $i <= $end; $i += 86400) { $start = date('Y-m-d H:i:s', $i); $repeatEnd = date('Y-m-d H:i:s', $i + $diff); $this->addEvent( $start, $repeatEnd, $allDay, $title, $content, $sentTo, false, $eventId ); } break; case 'weekly': for ($i = $origStartDate + 604800; $i <= $end; $i += 604800) { $start = date('Y-m-d H:i:s', $i); $repeatEnd = date('Y-m-d H:i:s', $i + $diff); $this->addEvent( $start, $repeatEnd, $allDay, $title, $content, $sentTo, false, $eventId ); } break; case 'monthlyByDate': $next_start = $this->addMonth($origStartDate); while ($next_start <= $end) { $start = date('Y-m-d H:i:s', $next_start); $repeatEnd = date('Y-m-d H:i:s', $next_start + $diff); $this->addEvent( $start, $repeatEnd, $allDay, $title, $content, $sentTo, false, $eventId ); $next_start = $this->addMonth($next_start); } break; case 'monthlyByDay': //not yet implemented break; case 'monthlyByDayR': //not yet implemented break; case 'yearly': $next_start = $this->addYear($origStartDate); while ($next_start <= $end) { $start = date('Y-m-d H:i:s', $next_start); $repeatEnd = date('Y-m-d H:i:s', $next_start + $diff); $this->addEvent( $start, $repeatEnd, $allDay, $title, $content, $sentTo, false, $eventId ); $next_start = $this->addYear($next_start); } break; } } return true; } /** * @param int $item_id * @param array $sentTo * @return int */ public function storeAgendaEventAsAnnouncement($item_id, $sentTo = array()) { $table_agenda = Database::get_course_table(TABLE_AGENDA); $course_id = api_get_course_int_id(); // Check params if (empty($item_id) || $item_id != strval(intval($item_id))) { return -1; } // Get the agenda item. $item_id = intval($item_id); $sql = "SELECT * FROM $table_agenda WHERE c_id = $course_id AND id = ".$item_id; $res = Database::query($sql); if (Database::num_rows($res) > 0) { $row = Database::fetch_array($res, 'ASSOC'); // Sending announcement if (!empty($sentTo)) { $id = AnnouncementManager::add_announcement( api_get_course_info(), api_get_session_id(), $row['title'], $row['content'], $sentTo, null, null, $row['end_date'] ); AnnouncementManager::sendEmail( api_get_course_info(), api_get_session_id(), $id ); return $id; } } return -1; } /** * Edits an event * * @param int $id * @param string $start datetime format: 2012-06-14 09:00:00 * @param string $end datetime format: 2012-06-14 09:00:00 * @param int $allDay is all day 'true' or 'false' * @param string $title * @param string $content * @param array $usersToSend * @param array $attachmentArray * @param array $attachmentCommentList * @param string $comment * @param string $color * @param bool $addAnnouncement * @param bool $updateContent * @param int $authorId * * @return bool */ public function editEvent( $id, $start, $end, $allDay, $title, $content, $usersToSend = array(), $attachmentArray = array(), $attachmentCommentList = array(), $comment = null, $color = '', $addAnnouncement = false, $updateContent = true, $authorId = 0 ) { $start = api_get_utc_datetime($start); $end = api_get_utc_datetime($end); $allDay = isset($allDay) && $allDay == 'true' ? 1 : 0; $authorId = empty($authorId) ? api_get_user_id() : (int) $authorId; switch ($this->type) { case 'personal': $eventInfo = $this->get_event($id); if ($eventInfo['user'] != api_get_user_id()) { break; } $attributes = array( 'title' => $title, 'date' => $start, 'enddate' => $end, 'all_day' => $allDay, ); if ($updateContent) { $attributes['text'] = $content; } if (!empty($color)) { $attributes['color'] = $color; } Database::update( $this->tbl_personal_agenda, $attributes, array('id = ?' => $id) ); break; case 'course': $eventInfo = $this->get_event($id); if (empty($eventInfo)) { return false; } $groupId = api_get_group_id(); $groupIid = 0; $groupInfo = []; if ($groupId) { $groupInfo = GroupManager::get_group_properties($groupId); if ($groupInfo) { $groupIid = $groupInfo['iid']; } } $course_id = $this->course['real_id']; if (empty($course_id)) { return false; } if ($this->getIsAllowedToEdit()) { $attributes = array( 'title' => $title, 'start_date' => $start, 'end_date' => $end, 'all_day' => $allDay, 'comment' => $comment ); if ($updateContent) { $attributes['content'] = $content; } if (!empty($color)) { $attributes['color'] = $color; } Database::update( $this->tbl_course_agenda, $attributes, array( 'id = ? AND c_id = ? AND session_id = ? ' => array( $id, $course_id, $this->sessionId ) ) ); if (!empty($usersToSend)) { $sendTo = $this->parseSendToArray($usersToSend); $usersToDelete = array_diff( $eventInfo['send_to']['users'], $sendTo['users'] ); $usersToAdd = array_diff( $sendTo['users'], $eventInfo['send_to']['users'] ); $groupsToDelete = array_diff( $eventInfo['send_to']['groups'], $sendTo['groups'] ); $groupToAdd = array_diff( $sendTo['groups'], $eventInfo['send_to']['groups'] ); if ($sendTo['everyone']) { // Delete all from group if (isset($eventInfo['send_to']['groups']) && !empty($eventInfo['send_to']['groups']) ) { foreach ($eventInfo['send_to']['groups'] as $group) { $groupIidItem = 0; if ($group) { $groupInfoItem = GroupManager::get_group_properties( $group ); if ($groupInfoItem) { $groupIidItem = $groupInfoItem['iid']; } } api_item_property_delete( $this->course, TOOL_CALENDAR_EVENT, $id, 0, $groupIidItem, $this->sessionId ); } } // Storing the selected users. if (isset($eventInfo['send_to']['users']) && !empty($eventInfo['send_to']['users']) ) { foreach ($eventInfo['send_to']['users'] as $userId) { api_item_property_delete( $this->course, TOOL_CALENDAR_EVENT, $id, $userId, $groupIid, $this->sessionId ); } } // Add to everyone only. api_item_property_update( $this->course, TOOL_CALENDAR_EVENT, $id, 'visible', $authorId, $groupInfo, null, $start, $end, $this->sessionId ); } else { // Delete "everyone". api_item_property_delete( $this->course, TOOL_CALENDAR_EVENT, $id, 0, 0, $this->sessionId ); // Add groups if (!empty($groupToAdd)) { foreach ($groupToAdd as $group) { $groupInfoItem = []; if ($group) { $groupInfoItem = GroupManager::get_group_properties( $group ); } api_item_property_update( $this->course, TOOL_CALENDAR_EVENT, $id, 'visible', $authorId, $groupInfoItem, 0, $start, $end, $this->sessionId ); } } // Delete groups. if (!empty($groupsToDelete)) { foreach ($groupsToDelete as $group) { $groupIidItem = 0; $groupInfoItem = []; if ($group) { $groupInfoItem = GroupManager::get_group_properties( $group ); if ($groupInfoItem) { $groupIidItem = $groupInfoItem['iid']; } } api_item_property_delete( $this->course, TOOL_CALENDAR_EVENT, $id, 0, $groupIidItem, $this->sessionId ); } } // Add users. if (!empty($usersToAdd)) { foreach ($usersToAdd as $userId) { api_item_property_update( $this->course, TOOL_CALENDAR_EVENT, $id, 'visible', $authorId, $groupInfo, $userId, $start, $end, $this->sessionId ); } } // Delete users. if (!empty($usersToDelete)) { foreach ($usersToDelete as $userId) { api_item_property_delete( $this->course, TOOL_CALENDAR_EVENT, $id, $userId, $groupInfo, $this->sessionId ); } } } } // Add announcement. if (isset($addAnnouncement) && !empty($addAnnouncement)) { $this->storeAgendaEventAsAnnouncement( $id, $usersToSend ); } // Add attachment. if (isset($attachmentArray) && !empty($attachmentArray)) { $counter = 0; foreach ($attachmentArray as $attachmentItem) { $this->updateAttachment( $attachmentItem['id'], $id, $attachmentItem, $attachmentCommentList[$counter], $this->course ); $counter++; } } return true; } else { return false; } break; case 'admin': case 'platform': if (api_is_platform_admin()) { $attributes = array( 'title' => $title, 'start_date' => $start, 'end_date' => $end, 'all_day' => $allDay ); if ($updateContent) { $attributes['content'] = $content; } Database::update( $this->tbl_global_agenda, $attributes, array('id = ?' => $id) ); } break; } } /** * @param int $id * @param bool $deleteAllItemsFromSerie */ public function deleteEvent($id, $deleteAllItemsFromSerie = false) { switch ($this->type) { case 'personal': $eventInfo = $this->get_event($id); if ($eventInfo['user'] == api_get_user_id()) { Database::delete( $this->tbl_personal_agenda, array('id = ?' => $id) ); } break; case 'course': $course_id = api_get_course_int_id(); if (!empty($course_id) && api_is_allowed_to_edit(null, true)) { // Delete $eventInfo = $this->get_event($id); if ($deleteAllItemsFromSerie) { /* This is one of the children. Getting siblings and delete 'Em all + the father! */ if (isset($eventInfo['parent_event_id']) && !empty($eventInfo['parent_event_id'])) { // Removing items. $events = $this->getAllRepeatEvents( $eventInfo['parent_event_id'] ); if (!empty($events)) { foreach ($events as $event) { $this->deleteEvent($event['id']); } } // Removing parent. $this->deleteEvent($eventInfo['parent_event_id']); } else { // This is the father looking for the children. $events = $this->getAllRepeatEvents($id); if (!empty($events)) { foreach ($events as $event) { $this->deleteEvent($event['id']); } } } } // Removing from events. Database::delete( $this->tbl_course_agenda, array('id = ? AND c_id = ?' => array($id, $course_id)) ); api_item_property_update( $this->course, TOOL_CALENDAR_EVENT, $id, 'delete', api_get_user_id() ); // Removing from series. Database::delete( $this->table_repeat, array( 'cal_id = ? AND c_id = ?' => array( $id, $course_id ) ) ); if (isset($eventInfo['attachment']) && !empty($eventInfo['attachment'])) { foreach ($eventInfo['attachment'] as $attachment) { self::deleteAttachmentFile( $attachment['id'], $this->course ); } } } break; case 'admin': if (api_is_platform_admin()) { Database::delete( $this->tbl_global_agenda, array('id = ?' => $id) ); } break; } } /** * Get agenda events * @param int $start * @param int $end * @param int $course_id * @param int $groupId * @param int $user_id * @param string $format * * @return array|string */ public function getEvents( $start, $end, $course_id = null, $groupId = null, $user_id = 0, $format = 'json' ) { switch ($this->type) { case 'admin': $this->getPlatformEvents($start, $end); break; case 'course': $courseInfo = api_get_course_info_by_id($course_id); // Session coach can see all events inside a session. if (api_is_coach()) { // Own course $this->getCourseEvents( $start, $end, $courseInfo, $groupId, $this->sessionId, $user_id ); // Others $this->getSessionEvents( $start, $end, $this->sessionId, $user_id, $this->eventOtherSessionColor ); } else { $this->getCourseEvents( $start, $end, $courseInfo, $groupId, $this->sessionId, $user_id ); } break; case 'personal': default: $sessionFilterActive = false; if (!empty($this->sessionId)) { $sessionFilterActive = true; } if ($sessionFilterActive == false) { // Getting personal events $this->getPersonalEvents($start, $end); // Getting platform/admin events $this->getPlatformEvents($start, $end); } $ignoreVisibility = api_get_configuration_value('personal_agenda_show_all_session_events'); // Getting course events $my_course_list = array(); if (!api_is_anonymous()) { $session_list = SessionManager::get_sessions_by_user( api_get_user_id(), $ignoreVisibility ); $my_course_list = CourseManager::get_courses_list_by_user_id( api_get_user_id(), false ); } if (api_is_drh()) { if (api_drh_can_access_all_session_content()) { $session_list = array(); $sessionList = SessionManager::get_sessions_followed_by_drh( api_get_user_id(), null, null, null, true, false ); if (!empty($sessionList)) { foreach ($sessionList as $sessionItem) { $sessionId = $sessionItem['id']; $courses = SessionManager::get_course_list_by_session_id( $sessionId ); $sessionInfo = array( 'session_id' => $sessionId, 'courses' => $courses ); $session_list[] = $sessionInfo; } } } } if (!empty($session_list)) { foreach ($session_list as $session_item) { if ($sessionFilterActive) { if ($this->sessionId != $session_item['session_id']) { continue; } } $my_courses = $session_item['courses']; $my_session_id = $session_item['session_id']; if (!empty($my_courses)) { foreach ($my_courses as $course_item) { $courseInfo = api_get_course_info_by_id( $course_item['real_id'] ); $this->getCourseEvents( $start, $end, $courseInfo, 0, $my_session_id ); } } } } if (!empty($my_course_list) && $sessionFilterActive == false) { foreach ($my_course_list as $courseInfoItem) { $courseInfo = api_get_course_info_by_id( $courseInfoItem['real_id'] ); if (isset($course_id) && !empty($course_id)) { if ($courseInfo['real_id'] == $course_id) { $this->getCourseEvents( $start, $end, $courseInfo ); } } else { $this->getCourseEvents( $start, $end, $courseInfo ); } } } break; } switch ($format) { case 'json': if (empty($this->events)) { return ''; } return json_encode($this->events); break; case 'array': if (empty($this->events)) { return []; } return $this->events; break; } } /** * @param int $id * @param int $minute_delta * @return int */ public function resizeEvent($id, $minute_delta) { $id = (int) $id; $delta = intval($minute_delta); $event = $this->get_event($id); if (!empty($event)) { switch ($this->type) { case 'personal': $sql = "UPDATE $this->tbl_personal_agenda SET enddate = DATE_ADD(enddate, INTERVAL $delta MINUTE) WHERE id = ".$id; Database::query($sql); break; case 'course': $sql = "UPDATE $this->tbl_course_agenda SET end_date = DATE_ADD(end_date, INTERVAL $delta MINUTE) WHERE c_id = ".$this->course['real_id']." AND id = ".$id; Database::query($sql); break; case 'admin': $sql = "UPDATE $this->tbl_global_agenda SET end_date = DATE_ADD(end_date, INTERVAL $delta MINUTE) WHERE id = ".$id; Database::query($sql); break; } } return 1; } /** * @param int $id * @param int $minute_delta minutes * @param int $allDay * @return int */ public function move_event($id, $minute_delta, $allDay) { $id = (int) $id; $event = $this->get_event($id); if (empty($event)) { return false; } // we convert the hour delta into minutes and add the minute delta $delta = intval($minute_delta); $allDay = intval($allDay); if (!empty($event)) { switch ($this->type) { case 'personal': $sql = "UPDATE $this->tbl_personal_agenda SET all_day = $allDay, date = DATE_ADD(date, INTERVAL $delta MINUTE), enddate = DATE_ADD(enddate, INTERVAL $delta MINUTE) WHERE id=".$id; Database::query($sql); break; case 'course': $sql = "UPDATE $this->tbl_course_agenda SET all_day = $allDay, start_date = DATE_ADD(start_date, INTERVAL $delta MINUTE), end_date = DATE_ADD(end_date, INTERVAL $delta MINUTE) WHERE c_id = ".$this->course['real_id']." AND id=".$id; Database::query($sql); break; case 'admin': $sql = "UPDATE $this->tbl_global_agenda SET all_day = $allDay, start_date = DATE_ADD(start_date,INTERVAL $delta MINUTE), end_date = DATE_ADD(end_date, INTERVAL $delta MINUTE) WHERE id=".$id; Database::query($sql); break; } } return 1; } /** * Gets a single event * * @param int $id event id * @return array */ public function get_event($id) { // make sure events of the personal agenda can only be seen by the user himself $id = intval($id); $event = null; switch ($this->type) { case 'personal': $sql = "SELECT * FROM ".$this->tbl_personal_agenda." WHERE id = $id AND user = ".api_get_user_id(); $result = Database::query($sql); if (Database::num_rows($result)) { $event = Database::fetch_array($result, 'ASSOC'); $event['description'] = $event['text']; $event['content'] = $event['text']; $event['start_date'] = $event['date']; $event['end_date'] = $event['enddate']; } break; case 'course': if (!empty($this->course['real_id'])) { $sql = "SELECT * FROM ".$this->tbl_course_agenda." WHERE c_id = ".$this->course['real_id']." AND id = ".$id; $result = Database::query($sql); if (Database::num_rows($result)) { $event = Database::fetch_array($result, 'ASSOC'); $event['description'] = $event['content']; // Getting send to array $event['send_to'] = $this->getUsersAndGroupSubscribedToEvent( $id, $this->course['real_id'], $this->sessionId ); // Getting repeat info $event['repeat_info'] = $this->getRepeatedInfoByEvent( $id, $this->course['real_id'] ); if (!empty($event['parent_event_id'])) { $event['parent_info'] = $this->get_event( $event['parent_event_id'] ); } $event['attachment'] = $this->getAttachmentList( $id, $this->course ); } } break; case 'admin': case 'platform': $sql = "SELECT * FROM ".$this->tbl_global_agenda." WHERE id = $id"; $result = Database::query($sql); if (Database::num_rows($result)) { $event = Database::fetch_array($result, 'ASSOC'); $event['description'] = $event['content']; } break; } return $event; } /** * Gets personal events * @param int $start * @param int $end * @return array */ public function getPersonalEvents($start, $end) { $start = intval($start); $end = intval($end); $startCondition = ''; $endCondition = ''; if ($start !== 0) { $start = api_get_utc_datetime($start); $startCondition = "AND date >= '".$start."'"; } if ($start !== 0) { $end = api_get_utc_datetime($end); $endCondition = "AND (enddate <= '".$end."' OR enddate IS NULL)"; } $user_id = api_get_user_id(); $sql = "SELECT * FROM ".$this->tbl_personal_agenda." WHERE user = $user_id $startCondition $endCondition"; $result = Database::query($sql); $my_events = array(); if (Database::num_rows($result)) { while ($row = Database::fetch_array($result, 'ASSOC')) { $event = array(); $event['id'] = 'personal_'.$row['id']; $event['title'] = $row['title']; $event['className'] = 'personal'; $event['borderColor'] = $event['backgroundColor'] = $this->event_personal_color; $event['editable'] = true; $event['sent_to'] = get_lang('Me'); $event['type'] = 'personal'; if (!empty($row['date'])) { $event['start'] = $this->formatEventDate($row['date']); $event['start_date_localtime'] = api_get_local_time( $row['date'] ); } if (!empty($row['enddate'])) { $event['end'] = $this->formatEventDate($row['enddate']); $event['end_date_localtime'] = api_get_local_time( $row['enddate'] ); } $event['description'] = $row['text']; $event['allDay'] = isset($row['all_day']) && $row['all_day'] == 1 ? $row['all_day'] : 0; $event['parent_event_id'] = 0; $event['has_children'] = 0; $my_events[] = $event; $this->events[] = $event; } } return $my_events; } /** * Get user/group list per event. * * @param int $eventId * @param int $courseId * @param integer $sessionId * @paraĆ¹ int $sessionId * * @return array */ public function getUsersAndGroupSubscribedToEvent( $eventId, $courseId, $sessionId ) { $eventId = intval($eventId); $courseId = intval($courseId); $sessionId = intval($sessionId); $sessionCondition = "ip.session_id = $sessionId"; if (empty($sessionId)) { $sessionCondition = " (ip.session_id = 0 OR ip.session_id IS NULL) "; } $tlb_course_agenda = Database::get_course_table(TABLE_AGENDA); $tbl_property = Database::get_course_table(TABLE_ITEM_PROPERTY); // Get sent_tos $sql = "SELECT DISTINCT to_user_id, to_group_id FROM $tbl_property ip INNER JOIN $tlb_course_agenda agenda ON ( ip.ref = agenda.id AND ip.c_id = agenda.c_id AND ip.tool = '".TOOL_CALENDAR_EVENT."' ) WHERE ref = $eventId AND ip.visibility = '1' AND ip.c_id = $courseId AND $sessionCondition "; $result = Database::query($sql); $users = array(); $groups = array(); $everyone = false; while ($row = Database::fetch_array($result, 'ASSOC')) { if (!empty($row['to_group_id'])) { $groups[] = $row['to_group_id']; } if (!empty($row['to_user_id'])) { $users[] = $row['to_user_id']; } if (empty($groups) && empty($users)) { if ($row['to_group_id'] == 0) { $everyone = true; } } } return array( 'everyone' => $everyone, 'users' => $users, 'groups' => $groups ); } /** * @param int $start * @param int $end * @param int $sessionId * @param int $userId * @param string $color * * @return array */ public function getSessionEvents( $start, $end, $sessionId = 0, $userId = 0, $color = '' ) { $courses = SessionManager::get_course_list_by_session_id($sessionId); if (!empty($courses)) { foreach ($courses as $course) { $this->getCourseEvents( $start, $end, $course, 0, $sessionId, 0, $color ); } } } /** * @param int $start * @param int $end * @param array $courseInfo * @param int $groupId * @param int $session_id * @param int $user_id * @param string $color * * @return array */ public function getCourseEvents( $start, $end, $courseInfo, $groupId = 0, $session_id = 0, $user_id = 0, $color = '' ) { $start = isset($start) && !empty($start) ? api_get_utc_datetime(intval($start)) : null; $end = isset($end) && !empty($end) ? api_get_utc_datetime(intval($end)) : null; if (empty($courseInfo)) { return array(); } $course_id = $courseInfo['real_id']; if (empty($course_id)) { return array(); } $session_id = intval($session_id); $user_id = intval($user_id); $groupList = GroupManager::get_group_list(null, $courseInfo['code']); $group_name_list = array(); if (!empty($groupList)) { foreach ($groupList as $group) { $group_name_list[$group['id']] = $group['name']; } } $group_memberships = []; if (!empty($groupId)) { $group_memberships = array($groupId); } else { if (api_is_allowed_to_edit()) { // Getting all groups $groupList = GroupManager::get_group_list(null, $courseInfo['code']); if (!empty($groupList)) { $group_memberships = array_column($groupList, 'id'); } } else { // get only related groups from user $group_memberships = GroupManager::get_group_ids( $course_id, $user_id ); } } $tlb_course_agenda = Database::get_course_table(TABLE_AGENDA); $tbl_property = Database::get_course_table(TABLE_ITEM_PROPERTY); if (!empty($groupId)) { if (empty($user_id)) { $where_condition = "( ip.to_group_id IN (0, ".implode(", ", $group_memberships).") ) "; } else { $where_condition = "( ip.to_user_id = $user_id OR ip.to_user_id IS NULL OR (ip.to_group_id IN (0, ".implode(", ", $group_memberships).")) ) "; } if (empty($session_id)) { $sessionCondition = " ( agenda.session_id = 0 AND (ip.session_id IS NULL OR ip.session_id = 0) ) "; } else { $sessionCondition = " ( agenda.session_id = $session_id AND ip.session_id = $session_id ) "; } $sql = "SELECT DISTINCT agenda.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.ref, to_user_id FROM $tlb_course_agenda agenda INNER JOIN $tbl_property ip ON ( agenda.id = ip.ref AND agenda.c_id = ip.c_id AND ip.tool = '".TOOL_CALENDAR_EVENT."' ) WHERE $where_condition AND ip.visibility = '1' AND agenda.c_id = $course_id AND $sessionCondition "; } else { $visibilityCondition = " ip.visibility='1' AND "; if (api_is_allowed_to_edit()) { if (empty($user_id)) { $where_condition = ''; } else { $where_condition = " (ip.to_user_id = ".$user_id.") AND (ip.to_group_id IS NULL OR ip.to_group_id = 0) AND "; } $visibilityCondition = " (ip.visibility IN ('1', '0')) AND "; } else { // Show my items and also items sent to everyone $where_condition = " ( (ip.to_user_id = ".api_get_user_id()." OR (ip.to_user_id = 0 or ip.to_user_id is NULL)) AND (ip.to_group_id IS NULL OR ip.to_group_id = 0)) AND "; } if (empty($session_id)) { $sessionCondition = " ( agenda.session_id = 0 AND (ip.session_id IS NULL OR ip.session_id = 0) ) "; } else { $sessionCondition = " ( agenda.session_id = $session_id AND ip.session_id = $session_id ) "; } $sql = "SELECT DISTINCT agenda.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.ref, to_user_id FROM $tlb_course_agenda agenda INNER JOIN $tbl_property ip ON (agenda.id = ip.ref AND agenda.c_id = ip.c_id AND ip.tool='".TOOL_CALENDAR_EVENT."' ) WHERE $where_condition $visibilityCondition agenda.c_id = $course_id AND $sessionCondition "; } $dateCondition = null; if (!empty($start) && !empty($end)) { $dateCondition .= "AND ( agenda.start_date BETWEEN '".$start."' AND '".$end."' OR agenda.end_date BETWEEN '".$start."' AND '".$end."' OR ( agenda.start_date IS NOT NULL AND agenda.end_date IS NOT NULL AND YEAR(agenda.start_date) = YEAR(agenda.end_date) AND MONTH('$start') BETWEEN MONTH(agenda.start_date) AND MONTH(agenda.end_date) ) )"; } $sql .= $dateCondition; $result = Database::query($sql); $coachCanEdit = false; if (!empty($session_id)) { $coachCanEdit = api_is_coach($session_id, $course_id) || api_is_platform_admin(); } if (Database::num_rows($result)) { $eventsAdded = array_column($this->events, 'unique_id'); while ($row = Database::fetch_array($result, 'ASSOC')) { $event = array(); $event['id'] = 'course_'.$row['id']; $event['unique_id'] = $row['iid']; // To avoid doubles if (in_array($event['unique_id'], $eventsAdded)) { continue; } $eventsAdded[] = $event['unique_id']; $eventId = $row['ref']; $items = $this->getUsersAndGroupSubscribedToEvent( $eventId, $course_id, $this->sessionId ); $group_to_array = $items['groups']; $user_to_array = $items['users']; $attachmentList = $this->getAttachmentList( $row['id'], $courseInfo ); $event['attachment'] = ''; if (!empty($attachmentList)) { foreach ($attachmentList as $attachment) { $has_attachment = Display::return_icon( 'attachment.gif', get_lang('Attachment') ); $user_filename = $attachment['filename']; $url = api_get_path(WEB_CODE_PATH).'calendar/download.php?file='.$attachment['path'].'&course_id='.$course_id.'&'.api_get_cidreq(); $event['attachment'] .= $has_attachment. Display::url( $user_filename, $url ).'
'; } } $event['title'] = $row['title']; $event['className'] = 'course'; $event['allDay'] = 'false'; $event['course_id'] = $course_id; $event['borderColor'] = $event['backgroundColor'] = $this->event_course_color; $sessionInfo = []; if (isset($row['session_id']) && !empty($row['session_id'])) { $sessionInfo = api_get_session_info($session_id); $event['borderColor'] = $event['backgroundColor'] = $this->event_session_color; } $event['session_name'] = isset($sessionInfo['name']) ? $sessionInfo['name'] : ''; $event['course_name'] = isset($courseInfo['title']) ? $courseInfo['title'] : ''; if (isset($row['to_group_id']) && !empty($row['to_group_id'])) { $event['borderColor'] = $event['backgroundColor'] = $this->event_group_color; } if (!empty($color)) { $event['borderColor'] = $event['backgroundColor'] = $color; } if (isset($row['color']) && !empty($row['color'])) { $event['borderColor'] = $event['backgroundColor'] = $row['color']; } $event['editable'] = false; if ($this->getIsAllowedToEdit() && $this->type == 'course') { $event['editable'] = true; if (!empty($session_id)) { if ($coachCanEdit == false) { $event['editable'] = false; } } } if (!empty($row['start_date'])) { $event['start'] = $this->formatEventDate( $row['start_date'] ); $event['start_date_localtime'] = api_get_local_time( $row['start_date'] ); } if (!empty($row['end_date'])) { $event['end'] = $this->formatEventDate($row['end_date']); $event['end_date_localtime'] = api_get_local_time( $row['end_date'] ); } $event['sent_to'] = ''; $event['type'] = 'course'; if ($row['session_id'] != 0) { $event['type'] = 'session'; } // Event Sent to a group? if (isset($row['to_group_id']) && !empty($row['to_group_id'])) { $sent_to = array(); if (!empty($group_to_array)) { foreach ($group_to_array as $group_item) { $sent_to[] = $group_name_list[$group_item]; } } $sent_to = implode('@@', $sent_to); $sent_to = str_replace( '@@', '
', $sent_to ); $event['sent_to'] = '
'.$sent_to.'
'; $event['type'] = 'group'; } // Event sent to a user? if (isset($row['to_user_id'])) { $sent_to = array(); if (!empty($user_to_array)) { foreach ($user_to_array as $item) { $user_info = api_get_user_info($item); // Add username as tooltip for $event['sent_to'] - ref #4226 $username = api_htmlentities( sprintf( get_lang('LoginX'), $user_info['username'] ), ENT_QUOTES ); $sent_to[] = "".$user_info['complete_name'].""; } } $sent_to = implode('@@', $sent_to); $sent_to = str_replace( '@@', '
', $sent_to ); $event['sent_to'] = '
'.$sent_to.'
'; } //Event sent to everyone! if (empty($event['sent_to'])) { $event['sent_to'] = '
'.get_lang( 'Everyone' ).'
'; } $event['description'] = $row['content']; $event['visibility'] = $row['visibility']; $event['real_id'] = $row['id']; $event['allDay'] = isset($row['all_day']) && $row['all_day'] == 1 ? $row['all_day'] : 0; $event['parent_event_id'] = $row['parent_event_id']; $event['has_children'] = $this->hasChildren( $row['id'], $course_id ) ? 1 : 0; $event['comment'] = $row['comment']; $this->events[] = $event; } } return $this->events; } /** * @param int $start tms * @param int $end tms * @return array */ public function getPlatformEvents($start, $end) { $start = isset($start) && !empty($start) ? api_get_utc_datetime( intval($start) ) : null; $end = isset($end) && !empty($end) ? api_get_utc_datetime( intval($end) ) : null; $dateCondition = ''; if (!empty($start) && !empty($end)) { $dateCondition .= "AND ( start_date BETWEEN '".$start."' AND '".$end."' OR end_date BETWEEN '".$start."' AND '".$end."' OR ( start_date IS NOT NULL AND end_date IS NOT NULL AND YEAR(start_date) = YEAR(end_date) AND MONTH('$start') BETWEEN MONTH(start_date) AND MONTH(end_date) ) )"; } $access_url_id = api_get_current_access_url_id(); $sql = "SELECT * FROM ".$this->tbl_global_agenda." WHERE access_url_id = $access_url_id $dateCondition"; $result = Database::query($sql); $my_events = array(); if (Database::num_rows($result)) { while ($row = Database::fetch_array($result, 'ASSOC')) { $event = array(); $event['id'] = 'platform_'.$row['id']; $event['title'] = $row['title']; $event['className'] = 'platform'; $event['allDay'] = 'false'; $event['borderColor'] = $event['backgroundColor'] = $this->event_platform_color; $event['editable'] = false; $event['type'] = 'admin'; if (api_is_platform_admin() && $this->type == 'admin') { $event['editable'] = true; } if (!empty($row['start_date'])) { $event['start'] = $this->formatEventDate( $row['start_date'] ); $event['start_date_localtime'] = api_get_local_time( $row['start_date'] ); } if (!empty($row['end_date'])) { $event['end'] = $this->formatEventDate($row['end_date']); $event['end_date_localtime'] = api_get_local_time( $row['end_date'] ); } $event['description'] = $row['content']; $event['allDay'] = isset($row['all_day']) && $row['all_day'] == 1 ? $row['all_day'] : 0; $event['parent_event_id'] = 0; $event['has_children'] = 0; $my_events[] = $event; $this->events[] = $event; } } return $my_events; } /** * Format needed for the Fullcalendar js lib * * @param string $utcTime * @return bool|string */ private function formatEventDate($utcTime) { $utcTimeZone = new DateTimeZone('UTC'); $platformTimeZone = new DateTimeZone(api_get_timezone()); $eventDate = new DateTime($utcTime, $utcTimeZone); $eventDate->setTimezone($platformTimeZone); return $eventDate->format(DateTime::ISO8601); } /** * @param FormValidator $form * @param array $groupList * @param array $userList * @param array $sendTo array('users' => [1, 2], 'groups' => [3, 4]) * @param array $attributes * @param bool $addOnlyItemsInSendTo * @param bool $required */ public function setSendToSelect( $form, $groupList = [], $userList = [], $sendTo = [], $attributes = [], $addOnlyItemsInSendTo = false, $required = false ) { $params = array( 'id' => 'users_to_send_id', 'data-placeholder' => get_lang('Select'), 'multiple' => 'multiple', 'class' => 'multiple-select' ); if (!empty($attributes)) { $params = array_merge($params, $attributes); if (empty($params['multiple'])) { unset($params['multiple']); } } $sendToGroups = isset($sendTo['groups']) ? $sendTo['groups'] : array(); $sendToUsers = isset($sendTo['users']) ? $sendTo['users'] : array(); /** @var HTML_QuickForm_select $select */ $select = $form->addSelect( 'users_to_send', get_lang('To'), null, $params ); if ($required) { $form->setRequired($select); } $selectedEveryoneOptions = array(); if (isset($sendTo['everyone']) && $sendTo['everyone']) { $selectedEveryoneOptions = array('selected'); $sendToUsers = array(); } $select->addOption( get_lang('Everyone'), 'everyone', $selectedEveryoneOptions ); $options = array(); if (is_array($groupList)) { foreach ($groupList as $group) { $count_users = isset($group['count_users']) ? $group['count_users'] : $group['userNb']; $count_users = " – $count_users ".get_lang('Users'); $option = array( 'text' => $group['name'].$count_users, 'value' => "GROUP:".$group['id'] ); $selected = in_array( $group['id'], $sendToGroups ) ? true : false; if ($selected) { $option['selected'] = 'selected'; } if ($addOnlyItemsInSendTo) { if ($selected) { $options[] = $option; } } else { $options[] = $option; } } $select->addOptGroup($options, get_lang('Groups')); } // adding the individual users to the select form if (is_array($userList)) { $options = array(); foreach ($userList as $user) { if ($user['status'] == ANONYMOUS) { continue; } $option = array( 'text' => api_get_person_name( $user['firstname'], $user['lastname'] ).' ('.$user['username'].')', 'value' => "USER:".$user['user_id'] ); $selected = in_array( $user['user_id'], $sendToUsers ) ? true : false; if ($selected) { $option['selected'] = 'selected'; } if ($addOnlyItemsInSendTo) { if ($selected) { $options[] = $option; } } else { $options[] = $option; } } $select->addOptGroup($options, get_lang('Users')); } } /** * Separates the users and groups array * users have a value USER:XXX (with XXX the user id * groups have a value GROUP:YYY (with YYY the group id) * use the 'everyone' key * @author Julio Montoya based in separate_users_groups in agenda.inc.php * @param array $to * @return array */ public function parseSendToArray($to) { $groupList = array(); $userList = array(); $sendTo = null; $sendTo['everyone'] = false; if (is_array($to) && count($to) > 0) { foreach ($to as $item) { if ($item == 'everyone') { $sendTo['everyone'] = true; } else { list($type, $id) = explode(':', $item); switch ($type) { case 'GROUP': $groupList[] = $id; break; case 'USER': $userList[] = $id; break; } } } $sendTo['groups'] = $groupList; $sendTo['users'] = $userList; } return $sendTo; } /** * @param array $params * @return FormValidator */ public function getForm($params = []) { $action = isset($params['action']) ? Security::remove_XSS($params['action']) : null; $id = isset($params['id']) ? intval($params['id']) : null; if ($this->type == 'course') { $url = api_get_self().'?'.api_get_cidreq().'&action='.$action.'&id='.$id.'&type='.$this->type; } else { $url = api_get_self().'?action='.$action.'&id='.$id.'&type='.$this->type; } $form = new FormValidator( 'add_event', 'post', $url, null, array('enctype' => 'multipart/form-data') ); $idAttach = isset($params['id_attach']) ? intval( $params['id_attach'] ) : null; $groupId = api_get_group_id(); if ($id) { $form_title = get_lang('ModifyCalendarItem'); } else { $form_title = get_lang('AddCalendarItem'); } $form->addElement('header', $form_title); $form->addElement('hidden', 'id', $id); $form->addElement('hidden', 'action', $action); $form->addElement('hidden', 'id_attach', $idAttach); $isSubEventEdition = false; $isParentFromSerie = false; $showAttachmentForm = true; if ($this->type == 'course') { // Edition mode. if (!empty($id)) { $showAttachmentForm = false; if (isset($params['parent_event_id']) && !empty($params['parent_event_id'])) { $isSubEventEdition = true; } if (!empty($params['repeat_info'])) { $isParentFromSerie = true; } } } if ($isSubEventEdition) { $form->addElement( 'label', null, Display::return_message( get_lang('EditingThisEventWillRemoveItFromTheSerie'), 'warning' ) ); } $form->addElement('text', 'title', get_lang('ItemTitle')); if (isset($groupId) && !empty($groupId)) { $form->addElement( 'hidden', 'users_to_send[]', "GROUP:$groupId" ); $form->addElement('hidden', 'to', 'true'); } else { $sendTo = isset($params['send_to']) ? $params['send_to'] : ['everyone' => true]; if ($this->type == 'course') { $this->showToForm($form, $sendTo, array(), false, true); } } $form->addDateRangePicker( 'date_range', get_lang('DateRange'), false, array('id' => 'date_range') ); $form->addElement('checkbox', 'all_day', null, get_lang('AllDay')); if ($this->type == 'course') { $repeat = $form->addElement( 'checkbox', 'repeat', null, get_lang('RepeatEvent'), array('onclick' => 'return plus_repeated_event();') ); $form->addElement( 'html', ''); } if (!empty($id)) { if (empty($params['end_date'])) { $params['date_range'] = $params['end_date']; } $params['date_range'] = substr(api_get_local_time($params['start_date']), 0, 16).' / '. substr(api_get_local_time($params['end_date']), 0, 16); } if (!api_is_allowed_to_edit(null, true)) { $toolbar = 'AgendaStudent'; } else { $toolbar = 'Agenda'; } $form->addElement( 'html_editor', 'content', get_lang('Description'), null, array( 'ToolbarSet' => $toolbar, 'Width' => '100%', 'Height' => '200' ) ); if ($this->type == 'course') { $form->addElement('textarea', 'comment', get_lang('Comment')); $form->addLabel( get_lang('FilesAttachment'), '

'.get_lang('Description').'  

' ); $form->addLabel( '', ' '. get_lang('AddOneMoreFile').'  ('.sprintf( get_lang('MaximunFileSizeX'), format_file_size( api_get_setting('message_max_upload_filesize') ) ).')' ); if (isset($params['attachment']) && !empty($params['attachment'])) { $attachmentList = $params['attachment']; foreach ($attachmentList as $attachment) { $params['file_comment'] = $attachment['comment']; if (!empty($attachment['path'])) { $form->addElement( 'checkbox', 'delete_attachment['.$attachment['id'].']', null, get_lang( 'DeleteAttachment' ).': '.$attachment['filename'] ); } } } $form->addElement( 'textarea', 'file_comment', get_lang('FileComment') ); } if (empty($id)) { $form->addElement( 'checkbox', 'add_announcement', null, get_lang('AddAnnouncement').' ('.get_lang('SendMail').')' ); } if ($id) { $form->addButtonUpdate(get_lang('ModifyEvent')); } else { $form->addButtonSave(get_lang('AgendaAdd')); } $form->setDefaults($params); $form->addRule( 'date_range', get_lang('ThisFieldIsRequired'), 'required' ); $form->addRule('title', get_lang('ThisFieldIsRequired'), 'required'); return $form; } /** * @param FormValidator $form * @param array $sendTo array('everyone' => false, 'users' => [1, 2], 'groups' => [3, 4]) * @param array $attributes * @param bool $addOnlyItemsInSendTo * @param bool $required * @return bool */ public function showToForm( $form, $sendTo = array(), $attributes = array(), $addOnlyItemsInSendTo = false, $required = false ) { if ($this->type != 'course') { return false; } $order = 'lastname'; if (api_is_western_name_order()) { $order = 'firstname'; } $userList = CourseManager::get_user_list_from_course_code( api_get_course_id(), $this->sessionId, null, $order ); $groupList = CourseManager::get_group_list_of_course( api_get_course_id(), $this->sessionId ); $this->setSendToSelect( $form, $groupList, $userList, $sendTo, $attributes, $addOnlyItemsInSendTo, $required ); return true; } /** * @param int $id * @param int $visibility 0= invisible, 1 visible * @param array $courseInfo * @param int $userId */ public static function changeVisibility( $id, $visibility, $courseInfo, $userId = null ) { $id = intval($id); if (empty($userId)) { $userId = api_get_user_id(); } else { $userId = intval($userId); } if ($visibility == 0) { api_item_property_update( $courseInfo, TOOL_CALENDAR_EVENT, $id, 'invisible', $userId ); } else { api_item_property_update( $courseInfo, TOOL_CALENDAR_EVENT, $id, 'visible', $userId ); } } /** * Get repeat types * @return array */ public static function getRepeatTypes() { return array( 'daily' => get_lang('RepeatDaily'), 'weekly' => get_lang('RepeatWeekly'), 'monthlyByDate' => get_lang('RepeatMonthlyByDate'), //monthlyByDay"> get_lang('RepeatMonthlyByDay'); //monthlyByDayR' => get_lang('RepeatMonthlyByDayR'), 'yearly' => get_lang('RepeatYearly') ); } /** * Show a list with all the attachments according to the post's id * @param int $eventId * @param array $courseInfo * @return array with the post info */ public function getAttachmentList($eventId, $courseInfo) { $tableAttachment = Database::get_course_table(TABLE_AGENDA_ATTACHMENT); $courseId = intval($courseInfo['real_id']); $eventId = intval($eventId); $sql = "SELECT id, path, filename, comment FROM $tableAttachment WHERE c_id = $courseId AND agenda_id = $eventId"; $result = Database::query($sql); $list = array(); if (Database::num_rows($result) != 0) { $list = Database::store_result($result, 'ASSOC'); } return $list; } /** * Show a list with all the attachments according to the post's id * @param int $attachmentId * @param int $eventId * @param array $courseInfo * @return array with the post info */ public function getAttachment($attachmentId, $eventId, $courseInfo) { $tableAttachment = Database::get_course_table(TABLE_AGENDA_ATTACHMENT); $courseId = intval($courseInfo['real_id']); $eventId = intval($eventId); $attachmentId = intval($attachmentId); $row = array(); $sql = "SELECT id, path, filename, comment FROM $tableAttachment WHERE c_id = $courseId AND agenda_id = $eventId AND id = $attachmentId "; $result = Database::query($sql); if (Database::num_rows($result) != 0) { $row = Database::fetch_array($result, 'ASSOC'); } return $row; } /** * Add an attachment file into agenda * @param int $eventId * @param array $fileUserUpload ($_FILES['user_upload']) * @param string $comment about file * @param array $courseInfo * @return string */ public function addAttachment( $eventId, $fileUserUpload, $comment, $courseInfo ) { $agenda_table_attachment = Database::get_course_table( TABLE_AGENDA_ATTACHMENT ); $eventId = intval($eventId); // Storing the attachments $upload_ok = false; if (!empty($fileUserUpload['name'])) { $upload_ok = process_uploaded_file($fileUserUpload); } if (!empty($upload_ok)) { $courseDir = $courseInfo['directory'].'/upload/calendar'; $sys_course_path = api_get_path(SYS_COURSE_PATH); $uploadDir = $sys_course_path.$courseDir; // Try to add an extension to the file if it hasn't one $new_file_name = add_ext_on_mime( stripslashes($fileUserUpload['name']), $fileUserUpload['type'] ); // user's file name $file_name = $fileUserUpload['name']; if (!filter_extension($new_file_name)) { return Display::return_message( get_lang('UplUnableToSaveFileFilteredExtension'), 'error' ); } else { $new_file_name = uniqid(''); $new_path = $uploadDir.'/'.$new_file_name; $result = @move_uploaded_file( $fileUserUpload['tmp_name'], $new_path ); $course_id = api_get_course_int_id(); $size = intval($fileUserUpload['size']); // Storing the attachments if any if ($result) { $params = [ 'c_id' => $course_id, 'filename' => $file_name, 'comment' => $comment, 'path' => $new_file_name, 'agenda_id' => $eventId, 'size' => $size ]; $id = Database::insert($agenda_table_attachment, $params); if ($id) { $sql = "UPDATE $agenda_table_attachment SET id = iid WHERE iid = $id"; Database::query($sql); api_item_property_update( $courseInfo, 'calendar_event_attachment', $id, 'AgendaAttachmentAdded', api_get_user_id() ); } } } } } /** * @param int $attachmentId * @param int $eventId * @param array $fileUserUpload * @param string $comment * @param array $courseInfo */ public function updateAttachment( $attachmentId, $eventId, $fileUserUpload, $comment, $courseInfo ) { $attachment = $this->getAttachment( $attachmentId, $eventId, $courseInfo ); if (!empty($attachment)) { $this->deleteAttachmentFile($attachmentId, $courseInfo); } $this->addAttachment($eventId, $fileUserUpload, $comment, $courseInfo); } /** * This function delete a attachment file by id * @param int $attachmentId * @param array $courseInfo * @return string */ public function deleteAttachmentFile($attachmentId, $courseInfo) { $agenda_table_attachment = Database::get_course_table( TABLE_AGENDA_ATTACHMENT ); $attachmentId = intval($attachmentId); $courseId = $courseInfo['real_id']; if (empty($courseId) || empty($attachmentId)) { return false; } $sql = "DELETE FROM $agenda_table_attachment WHERE c_id = $courseId AND id = ".$attachmentId; $result = Database::query($sql); // update item_property api_item_property_update( $courseInfo, 'calendar_event_attachment', $attachmentId, 'AgendaAttachmentDeleted', api_get_user_id() ); if (!empty($result)) { return Display::return_message( get_lang("AttachmentFileDeleteSuccess"), 'confirmation' ); } } /** * Adds x weeks to a UNIX timestamp * @param int The timestamp * @param int The number of weeks to add * @param integer $timestamp * @return int The new timestamp */ public function addWeek($timestamp, $num = 1) { return $timestamp + $num * 604800; } /** * Adds x months to a UNIX timestamp * @param int The timestamp * @param int The number of years to add * @param integer $timestamp * @return int The new timestamp */ public function addMonth($timestamp, $num = 1) { list($y, $m, $d, $h, $n, $s) = split( '/', date('Y/m/d/h/i/s', $timestamp) ); if ($m + $num > 12) { $y += floor($num / 12); $m += $num % 12; } else { $m += $num; } return mktime($h, $n, $s, $m, $d, $y); } /** * Adds x years to a UNIX timestamp * @param int The timestamp * @param int The number of years to add * @param integer $timestamp * @return int The new timestamp */ public function addYear($timestamp, $num = 1) { list($y, $m, $d, $h, $n, $s) = split( '/', date('Y/m/d/h/i/s', $timestamp) ); return mktime($h, $n, $s, $m, $d, $y + $num); } /** * @param int $eventId * @return array */ public function getAllRepeatEvents($eventId) { $events = array(); switch ($this->type) { case 'personal': break; case 'course': if (!empty($this->course['real_id'])) { $sql = "SELECT * FROM ".$this->tbl_course_agenda." WHERE c_id = ".$this->course['real_id']." AND parent_event_id = ".$eventId; $result = Database::query($sql); if (Database::num_rows($result)) { while ($row = Database::fetch_array($result, 'ASSOC')) { $events[] = $row; } } } break; } return $events; } /** * @param int $eventId * @param int $courseId * * @return bool */ public function hasChildren($eventId, $courseId) { $eventId = intval($eventId); $courseId = intval($courseId); $sql = "SELECT count(DISTINCT(id)) as count FROM ".$this->tbl_course_agenda." WHERE c_id = $courseId AND parent_event_id = $eventId"; $result = Database::query($sql); if (Database::num_rows($result)) { $row = Database::fetch_array($result, 'ASSOC'); return $row['count'] > 0; } return false; } /** * @param int $filter * @param string $view * @return string */ public function displayActions($view, $filter = 0) { $courseInfo = api_get_course_info(); $groupInfo = GroupManager::get_group_properties(api_get_group_id()); $groupIid = isset($groupInfo['iid']) ? $groupInfo['iid'] : 0; $courseCondition = ''; if (!empty($courseInfo)) { $courseCondition = api_get_cidreq(); } $actionsLeft = ''; $actionsLeft .= "". Display::return_icon( 'calendar.png', get_lang('Calendar'), '', ICON_SIZE_MEDIUM ).""; $actionsLeft .= "". Display::return_icon( 'week.png', get_lang('AgendaList'), '', ICON_SIZE_MEDIUM ).""; $form = ''; if (api_is_allowed_to_edit(false, true) || (api_get_course_setting('allow_user_edit_agenda') && !api_is_anonymous()) && api_is_allowed_to_session_edit(false, true) || (GroupManager::user_has_access( api_get_user_id(), $groupIid, GroupManager::GROUP_TOOL_CALENDAR ) && GroupManager::is_tutor_of_group(api_get_user_id(), $groupInfo)) ) { $actionsLeft .= Display::url( Display::return_icon( 'new_event.png', get_lang('AgendaAdd'), '', ICON_SIZE_MEDIUM ), api_get_path(WEB_CODE_PATH)."calendar/agenda.php?".api_get_cidreq()."&action=add&type=".$this->type ); $actionsLeft .= Display::url( Display::return_icon( 'import_calendar.png', get_lang('ICalFileImport'), '', ICON_SIZE_MEDIUM ), api_get_path(WEB_CODE_PATH)."calendar/agenda.php?".api_get_cidreq()."&action=importical&type=".$this->type ); if ($this->type === 'course') { if (!isset($_GET['action'])) { $form = new FormValidator( 'form-search', 'post', '', '', array(), FormValidator::LAYOUT_INLINE ); $attributes = array( 'multiple' => false, 'id' => 'select_form_id_search' ); $selectedValues = $this->parseAgendaFilter($filter); $this->showToForm($form, $selectedValues, $attributes); $form = $form->returnForm(); } } } if (api_is_platform_admin() || api_is_teacher() || api_is_student_boss() || api_is_drh() || api_is_session_admin() || api_is_coach() ) { if ($this->type == 'personal') { $form = null; if (!isset($_GET['action'])) { $form = new FormValidator( 'form-search', 'get', api_get_self().'?type=personal&', '', array(), FormValidator::LAYOUT_INLINE ); $sessions = SessionManager::get_sessions_by_user( api_get_user_id() ); $form->addHidden('type', 'personal'); $sessions = array_column( $sessions, 'session_name', 'session_id' ); $sessions = ['0' => get_lang('SelectAnOption')] + $sessions; $form->addSelect( 'session_id', get_lang('Session'), $sessions, ['id' => 'session_id', 'onchange' => 'submit();'] ); $form->addButtonReset(get_lang('Reset')); $form = $form->returnForm(); } } } $actionsRight = ''; if ($view == 'calendar') { $actionsRight .= $form; } $toolbar = Display::toolbarAction( 'toolbar-agenda', array($actionsLeft, $actionsRight) ); return $toolbar; } /** * @return FormValidator */ public function getImportCalendarForm() { $form = new FormValidator( 'frm_import_ical', 'post', api_get_self().'?action=importical&type='.$this->type, array('enctype' => 'multipart/form-data') ); $form->addElement('header', get_lang('ICalFileImport')); $form->addElement('file', 'ical_import', get_lang('ICalFileImport')); $form->addRule( 'ical_import', get_lang('ThisFieldIsRequired'), 'required' ); $form->addButtonImport(get_lang('Import'), 'ical_submit'); return $form; } /** * @param array $courseInfo * @param $file * @return false|string */ public function importEventFile($courseInfo, $file) { $charset = api_get_system_encoding(); $filepath = api_get_path(SYS_ARCHIVE_PATH).$file['name']; $messages = array(); if (!@move_uploaded_file($file['tmp_name'], $filepath)) { error_log( 'Problem moving uploaded file: '.$file['error'].' in '.__FILE__.' line '.__LINE__ ); return false; } $data = file_get_contents($filepath); $trans = array( 'DAILY' => 'daily', 'WEEKLY' => 'weekly', 'MONTHLY' => 'monthlyByDate', 'YEARLY' => 'yearly' ); $sentTo = array('everyone' => true); $calendar = Sabre\VObject\Reader::read($data); $currentTimeZone = api_get_timezone(); if (!empty($calendar->VEVENT)) { foreach ($calendar->VEVENT as $event) { $start = $event->DTSTART->getDateTime(); $end = $event->DTEND->getDateTime(); //Sabre\VObject\DateTimeParser::parseDateTime(string $dt, \Sabre\VObject\DateTimeZone $tz) $startDateTime = api_get_local_time( $start->format('Y-m-d H:i:s'), $currentTimeZone, $start->format('e') ); $endDateTime = api_get_local_time( $end->format('Y-m-d H:i'), $currentTimeZone, $end->format('e') ); $title = api_convert_encoding( (string) $event->summary, $charset, 'UTF-8' ); $description = api_convert_encoding( (string) $event->description, $charset, 'UTF-8' ); $id = $this->addEvent( $startDateTime, $endDateTime, 'false', $title, $description, $sentTo ); $messages[] = " $title - ".$startDateTime." - ".$endDateTime; //$attendee = (string)$event->attendee; /** @var Sabre\VObject\Property\ICalendar\Recur $repeat */ $repeat = $event->RRULE; if ($id && !empty($repeat)) { $repeat = $repeat->getParts(); $freq = $trans[$repeat['FREQ']]; if (isset($repeat['UNTIL']) && !empty($repeat['UNTIL'])) { // Check if datetime or just date (strlen == 8) if (strlen($repeat['UNTIL']) == 8) { // Fix the datetime format to avoid exception in the next step $repeat['UNTIL'] .= 'T000000'; } $until = Sabre\VObject\DateTimeParser::parseDateTime( $repeat['UNTIL'], new DateTimeZone($currentTimeZone) ); $until = $until->format('Y-m-d H:i'); //$res = agenda_add_repeat_item($courseInfo, $id, $freq, $until, $attendee); $this->addRepeatedItem( $id, $freq, $until, $sentTo ); } if (!empty($repeat['COUNT'])) { /*$count = $repeat['COUNT']; $interval = $repeat['INTERVAL']; $endDate = null; switch($freq) { case 'daily': $start = api_strtotime($startDateTime); $date = new DateTime($startDateTime); $days = $count * $interval; var_dump($days); $date->add(new DateInterval("P".$days."D")); $endDate = $date->format('Y-m-d H:i'); //$endDate = $count * for ($i = 0; $i < $count; $i++) { $days = 86400 * 7 } } }*/ //$res = agenda_add_repeat_item($courseInfo, $id, $freq, $count, $attendee); /*$this->addRepeatedItem( $id, $freq, $endDate, $sentTo );*/ } } } } if (!empty($messages)) { $messages = implode('
', $messages); } else { $messages = get_lang('NoAgendaItems'); } return $messages; } /** * Parse filter turns USER:12 to ['users' => [12])] or G:1 ['groups' => [1]] * @param integer $filter * @return array */ public function parseAgendaFilter($filter) { $everyone = false; $groupId = null; $userId = null; if ($filter == 'everyone') { $everyone = true; } else { if (substr($filter, 0, 1) == 'G') { $groupId = str_replace('GROUP:', '', $filter); } else { $userId = str_replace('USER:', '', $filter); } } if (empty($userId) && empty($groupId)) { $everyone = true; } return array( 'everyone' => $everyone, 'users' => array($userId), 'groups' => array($groupId) ); } /** * This function retrieves all the agenda items of all the courses the user is subscribed to */ public static function get_myagendaitems( $user_id, $courses_dbs, $month, $year ) { $user_id = intval($user_id); $items = array(); $my_list = array(); // get agenda-items for every course foreach ($courses_dbs as $key => $array_course_info) { //databases of the courses $TABLEAGENDA = Database::get_course_table(TABLE_AGENDA); $TABLE_ITEMPROPERTY = Database::get_course_table( TABLE_ITEM_PROPERTY ); $group_memberships = GroupManager::get_group_ids( $array_course_info['real_id'], $user_id ); $course_user_status = CourseManager::getUserInCourseStatus( $user_id, $array_course_info['real_id'] ); // if the user is administrator of that course we show all the agenda items if ($course_user_status == '1') { //echo "course admin"; $sqlquery = "SELECT DISTINCT agenda.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.ref FROM ".$TABLEAGENDA." agenda, ".$TABLE_ITEMPROPERTY." ip WHERE agenda.id = ip.ref AND MONTH(agenda.start_date)='".$month."' AND YEAR(agenda.start_date)='".$year."' AND ip.tool='".TOOL_CALENDAR_EVENT."' AND ip.visibility='1' GROUP BY agenda.id ORDER BY start_date "; } else { // if the user is not an administrator of that course if (is_array($group_memberships) && count( $group_memberships ) > 0 ) { $sqlquery = "SELECT agenda.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.ref FROM ".$TABLEAGENDA." agenda, ".$TABLE_ITEMPROPERTY." ip WHERE agenda.id = ip.ref AND MONTH(agenda.start_date)='".$month."' AND YEAR(agenda.start_date)='".$year."' AND ip.tool='".TOOL_CALENDAR_EVENT."' AND ( ip.to_user_id='".$user_id."' OR (ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".implode( ", ", $group_memberships ).")) ) AND ip.visibility='1' ORDER BY start_date "; } else { $sqlquery = "SELECT agenda.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.ref FROM ".$TABLEAGENDA." agenda, ".$TABLE_ITEMPROPERTY." ip WHERE agenda.id = ip.ref AND MONTH(agenda.start_date)='".$month."' AND YEAR(agenda.start_date)='".$year."' AND ip.tool='".TOOL_CALENDAR_EVENT."' AND ( ip.to_user_id='".$user_id."' OR ip.to_group_id='0' OR ip.to_group_id IS NULL) AND ip.visibility='1' ORDER BY start_date "; } } $result = Database::query($sqlquery); while ($item = Database::fetch_array($result, 'ASSOC')) { $agendaday = -1; if (!empty($item['start_date'])) { $item['start_date'] = api_get_local_time( $item['start_date'] ); $item['start_date_tms'] = api_strtotime( $item['start_date'] ); $agendaday = date("j", $item['start_date_tms']); } if (!empty($item['end_date'])) { $item['end_date'] = api_get_local_time($item['end_date']); } $url = api_get_path( WEB_CODE_PATH )."calendar/agenda.php?cidReq=".urlencode( $array_course_info["code"] )."&day=$agendaday&month=$month&year=$year#$agendaday"; $item['url'] = $url; $item['course_name'] = $array_course_info['title']; $item['calendar_type'] = 'course'; $item['course_id'] = $array_course_info['course_id']; $my_list[$agendaday][] = $item; } } // sorting by hour for every day $agendaitems = array(); while (list ($agendaday, $tmpitems) = each($items)) { if (!isset($agendaitems[$agendaday])) { $agendaitems[$agendaday] = ''; } sort($tmpitems); while (list ($key, $val) = each($tmpitems)) { $agendaitems[$agendaday] .= $val; } } return $my_list; } /** * This function retrieves one personal agenda item returns it. * @param array The array containing existing events. We add to this array. * @param int Day * @param int Month * @param int Year (4 digits) * @param int Week number * @param string Type of view (month_view, week_view, day_view) * @return array The results of the database query, or null if not found */ public static function get_global_agenda_items( $agendaitems, $day = "", $month = "", $year = "", $week = "", $type ) { $tbl_global_agenda = Database::get_main_table( TABLE_MAIN_SYSTEM_CALENDAR ); $month = intval($month); $year = intval($year); $week = intval($week); $day = intval($day); // 1. creating the SQL statement for getting the personal agenda items in MONTH view $current_access_url_id = api_get_current_access_url_id(); if ($type == "month_view" or $type == "") { // We are in month view $sql = "SELECT * FROM ".$tbl_global_agenda." WHERE MONTH(start_date) = ".$month." AND YEAR(start_date) = ".$year." AND access_url_id = $current_access_url_id ORDER BY start_date ASC"; } // 2. creating the SQL statement for getting the personal agenda items in WEEK view if ($type == "week_view") { // we are in week view $start_end_day_of_week = self::calculate_start_end_of_week( $week, $year ); $start_day = $start_end_day_of_week['start']['day']; $start_month = $start_end_day_of_week['start']['month']; $start_year = $start_end_day_of_week['start']['year']; $end_day = $start_end_day_of_week['end']['day']; $end_month = $start_end_day_of_week['end']['month']; $end_year = $start_end_day_of_week['end']['year']; // in sql statements you have to use year-month-day for date calculations $start_filter = $start_year."-".$start_month."-".$start_day." 00:00:00"; $start_filter = api_get_utc_datetime($start_filter); $end_filter = $end_year."-".$end_month."-".$end_day." 23:59:59"; $end_filter = api_get_utc_datetime($end_filter); $sql = " SELECT * FROM ".$tbl_global_agenda." WHERE start_date>='".$start_filter."' AND start_date<='".$end_filter."' AND access_url_id = $current_access_url_id "; } // 3. creating the SQL statement for getting the personal agenda items in DAY view if ($type == "day_view") { // we are in day view // we could use mysql date() function but this is only available from 4.1 and higher $start_filter = $year."-".$month."-".$day." 00:00:00"; $start_filter = api_get_utc_datetime($start_filter); $end_filter = $year."-".$month."-".$day." 23:59:59"; $end_filter = api_get_utc_datetime($end_filter); $sql = " SELECT * FROM ".$tbl_global_agenda." WHERE start_date>='".$start_filter."' AND start_date<='".$end_filter."' AND access_url_id = $current_access_url_id"; } $result = Database::query($sql); while ($item = Database::fetch_array($result)) { if (!empty($item['start_date'])) { $item['start_date'] = api_get_local_time($item['start_date']); $item['start_date_tms'] = api_strtotime($item['start_date']); } if (!empty($item['end_date'])) { $item['end_date'] = api_get_local_time($item['end_date']); } // we break the date field in the database into a date and a time part $agenda_db_date = explode(" ", $item['start_date']); $date = $agenda_db_date[0]; $time = $agenda_db_date[1]; // we divide the date part into a day, a month and a year $agendadate = explode("-", $date); $year = intval($agendadate[0]); $month = intval($agendadate[1]); $day = intval($agendadate[2]); // we divide the time part into hour, minutes, seconds $agendatime = explode(":", $time); $hour = $agendatime[0]; $minute = $agendatime[1]; $second = $agendatime[2]; if ($type == 'month_view') { $item['calendar_type'] = 'global'; $agendaitems[$day][] = $item; continue; } $start_time = api_format_date( $item['start_date'], TIME_NO_SEC_FORMAT ); $end_time = ''; if (!empty($item['end_date'])) { $end_time = ' - '.api_format_date( $item['end_date'], DATE_TIME_FORMAT_LONG ); } // if the student has specified a course we a add a link to that course if ($item['course'] <> "") { $url = api_get_path( WEB_CODE_PATH )."admin/agenda.php?cidReq=".urlencode( $item['course'] )."&day=$day&month=$month&year=$year#$day"; // RH //Patrick Cool: to highlight the relevant agenda item $course_link = "".$item['course'].""; } else { $course_link = ""; } // Creating the array that will be returned. If we have week or month view we have an array with the date as the key // if we have a day_view we use a half hour as index => key 33 = 16h30 if ($type !== "day_view") { // This is the array construction for the WEEK or MONTH view //Display the Agenda global in the tab agenda (administrator) $agendaitems[$day] .= "$start_time $end_time - "; $agendaitems[$day] .= "".get_lang('GlobalEvent').""; $agendaitems[$day] .= "
".$item['title']."

"; } else { // this is the array construction for the DAY view $halfhour = 2 * $agendatime['0']; if ($agendatime['1'] >= '30') { $halfhour = $halfhour + 1; } if (!is_array($agendaitems[$halfhour])) { $content = $agendaitems[$halfhour]; } $agendaitems[$halfhour] = $content."
$hour:$minute ".get_lang( 'GlobalEvent' ).": ".$item['title']."
"; } } return $agendaitems; } /** * This function retrieves all the personal agenda items and add them to the agenda items found by the other functions. */ public static function get_personal_agenda_items( $user_id, $agendaitems, $day = "", $month = "", $year = "", $week = "", $type ) { $tbl_personal_agenda = Database::get_main_table(TABLE_PERSONAL_AGENDA); $user_id = intval($user_id); // 1. creating the SQL statement for getting the personal agenda items in MONTH view if ($type == "month_view" or $type == "") { // we are in month view $sql = "SELECT * FROM ".$tbl_personal_agenda." WHERE user='".$user_id."' and MONTH(date)='".$month."' AND YEAR(date) = '".$year."' ORDER BY date ASC"; } // 2. creating the SQL statement for getting the personal agenda items in WEEK view // we are in week view if ($type == "week_view") { $start_end_day_of_week = self::calculate_start_end_of_week( $week, $year ); $start_day = $start_end_day_of_week['start']['day']; $start_month = $start_end_day_of_week['start']['month']; $start_year = $start_end_day_of_week['start']['year']; $end_day = $start_end_day_of_week['end']['day']; $end_month = $start_end_day_of_week['end']['month']; $end_year = $start_end_day_of_week['end']['year']; // in sql statements you have to use year-month-day for date calculations $start_filter = $start_year."-".$start_month."-".$start_day." 00:00:00"; $start_filter = api_get_utc_datetime($start_filter); $end_filter = $end_year."-".$end_month."-".$end_day." 23:59:59"; $end_filter = api_get_utc_datetime($end_filter); $sql = " SELECT * FROM ".$tbl_personal_agenda." WHERE user='".$user_id."' AND date>='".$start_filter."' AND date<='".$end_filter."'"; } // 3. creating the SQL statement for getting the personal agenda items in DAY view if ($type == "day_view") { // we are in day view // we could use mysql date() function but this is only available from 4.1 and higher $start_filter = $year."-".$month."-".$day." 00:00:00"; $start_filter = api_get_utc_datetime($start_filter); $end_filter = $year."-".$month."-".$day." 23:59:59"; $end_filter = api_get_utc_datetime($end_filter); $sql = " SELECT * FROM ".$tbl_personal_agenda." WHERE user='".$user_id."' AND date>='".$start_filter."' AND date<='".$end_filter."'"; } $result = Database::query($sql); while ($item = Database::fetch_array($result, 'ASSOC')) { $time_minute = api_convert_and_format_date( $item['date'], TIME_NO_SEC_FORMAT ); $item['date'] = api_get_local_time($item['date']); $item['start_date_tms'] = api_strtotime($item['date']); $item['content'] = $item['text']; // we break the date field in the database into a date and a time part $agenda_db_date = explode(" ", $item['date']); $date = $agenda_db_date[0]; $time = $agenda_db_date[1]; // we divide the date part into a day, a month and a year $agendadate = explode("-", $item['date']); $year = intval($agendadate[0]); $month = intval($agendadate[1]); $day = intval($agendadate[2]); // we divide the time part into hour, minutes, seconds $agendatime = explode(":", $time); $hour = $agendatime[0]; $minute = $agendatime[1]; $second = $agendatime[2]; if ($type == 'month_view') { $item['calendar_type'] = 'personal'; $item['start_date'] = $item['date']; $agendaitems[$day][] = $item; continue; } // if the student has specified a course we a add a link to that course if ($item['course'] <> "") { $url = api_get_path( WEB_CODE_PATH )."calendar/agenda.php?cidReq=".urlencode( $item['course'] )."&day=$day&month=$month&year=$year#$day"; // RH //Patrick Cool: to highlight the relevant agenda item $course_link = "".$item['course'].""; } else { $course_link = ""; } // Creating the array that will be returned. If we have week or month view we have an array with the date as the key // if we have a day_view we use a half hour as index => key 33 = 16h30 if ($type !== "day_view") { // This is the array construction for the WEEK or MONTH view //Display events in agenda $agendaitems[$day] .= "
$time_minute $course_link ".$item['title']."

"; } else { // this is the array construction for the DAY view $halfhour = 2 * $agendatime['0']; if ($agendatime['1'] >= '30') { $halfhour = $halfhour + 1; } //Display events by list $agendaitems[$halfhour] .= "
$time_minute $course_link ".$item['title']."
"; } } return $agendaitems; } /** * Show the monthcalender of the given month * @param array Agendaitems * @param int Month number * @param int Year number * @param array Array of strings containing long week day names (deprecated, you can send an empty array instead) * @param string The month name * @return void Direct output */ public static function display_mymonthcalendar( $user_id, $agendaitems, $month, $year, $weekdaynames = array(), $monthName, $show_content = true ) { global $DaysShort, $course_path; //Handle leap year $numberofdays = array( 0, 31, 28, 31, 30, 31, 30, 31, 31, 30, 31, 30, 31 ); if (($year % 400 == 0) or ($year % 4 == 0 and $year % 100 <> 0)) { $numberofdays[2] = 29; } //Get the first day of the month $dayone = getdate(mktime(0, 0, 0, $month, 1, $year)); //Start the week on monday $startdayofweek = $dayone['wday'] <> 0 ? ($dayone['wday'] - 1) : 6; $g_cc = (isset($_GET['courseCode']) ? $_GET['courseCode'] : ''); $next_month = ($month == 1 ? 12 : $month - 1); $prev_month = ($month == 12 ? 1 : $month + 1); $next_year = ($month == 1 ? $year - 1 : $year); $prev_year = ($month == 12 ? $year + 1 : $year); if ($show_content) { $back_url = Display::url( get_lang('Previous'), api_get_self()."?coursePath=".urlencode( $course_path )."&courseCode=".Security::remove_XSS( $g_cc )."&action=view&view=month&month=".$next_month."&year=".$next_year ); $next_url = Display::url( get_lang('Next'), api_get_self()."?coursePath=".urlencode( $course_path )."&courseCode=".Security::remove_XSS( $g_cc )."&action=view&view=month&month=".$prev_month."&year=".$prev_year ); } else { $back_url = Display::url( get_lang('Previous'), '', array( 'onclick' => "load_calendar('".$user_id."','".$next_month."', '".$next_year."'); ", 'class' => 'btn ui-button ui-widget ui-state-default' ) ); $next_url = Display::url( get_lang('Next'), '', array( 'onclick' => "load_calendar('".$user_id."','".$prev_month."', '".$prev_year."'); ", 'class' => 'pull-right btn ui-button ui-widget ui-state-default' ) ); } $html = ''; $html .= '
'; $html .= '
'; $html .= '
'.$back_url.'
'; $html .= '

'.$monthName." ".$year.'

'; $html .= '
'.$next_url.'
'; $html .= '
'; $html .= '
'; $html .= ''; $html .= ''; for ($ii = 1; $ii < 8; $ii++) { $html .= ''; } $html .= ''; $curday = -1; $today = getdate(); while ($curday <= $numberofdays[$month]) { $html .= ""; for ($ii = 0; $ii < 7; $ii++) { if (($curday == -1) && ($ii == $startdayofweek)) { $curday = 1; } if (($curday > 0) && ($curday <= $numberofdays[$month])) { $bgcolor = $class = 'class="days_week"'; $dayheader = Display::div( $curday, array('class' => 'agenda_day') ); if (($curday == $today['mday']) && ($year == $today['year']) && ($month == $today['mon'])) { $class = "class=\"days_today\" style=\"width:10%;\""; } $html .= ""; $curday++; } else { $html .= ""; } } $html .= ""; } $html .= "
'.$DaysShort[$ii % 7].'
".$dayheader; if (!empty($agendaitems[$curday])) { $items = $agendaitems[$curday]; $items = msort($items, 'start_date_tms'); foreach ($items as $value) { $value['title'] = Security::remove_XSS( $value['title'] ); $start_time = api_format_date( $value['start_date'], TIME_NO_SEC_FORMAT ); $end_time = ''; if (!empty($value['end_date'])) { $end_time = '- '.api_format_date( $value['end_date'], DATE_TIME_FORMAT_LONG ).''; } $complete_time = ''.api_format_date( $value['start_date'], DATE_TIME_FORMAT_LONG ).' '.$end_time; $time = ''.$start_time.''; switch ($value['calendar_type']) { case 'personal': $bg_color = '#D0E7F4'; $icon = Display::return_icon( 'user.png', get_lang('MyAgenda'), array(), ICON_SIZE_SMALL ); break; case 'global': $bg_color = '#FFBC89'; $icon = Display::return_icon( 'view_remove.png', get_lang('GlobalEvent'), array(), ICON_SIZE_SMALL ); break; case 'course': $bg_color = '#CAFFAA'; $icon_name = 'course.png'; if (!empty($value['session_id'])) { $icon_name = 'session.png'; } if ($show_content) { $icon = Display::url( Display::return_icon( $icon_name, $value['course_name'].' '.get_lang( 'Course' ), array(), ICON_SIZE_SMALL ), $value['url'] ); } else { $icon = Display::return_icon( $icon_name, $value['course_name'].' '.get_lang( 'Course' ), array(), ICON_SIZE_SMALL ); } break; default: break; } $result = '
'; if ($show_content) { //Setting a personal event to green $icon = Display::div( $icon, array('style' => 'float:right') ); $link = $value['calendar_type'].'_'.$value['id'].'_'.$value['course_id'].'_'.$value['session_id']; //Link to bubble $url = Display::url( cut($value['title'], 40), '#', array('id' => $link, 'class' => 'opener') ); $result .= $time.' '.$icon.' '.Display::div( $url ); //Hidden content $content = Display::div( $icon.Display::tag( 'h2', $value['course_name'] ).'
'.Display::tag( 'h3', $value['title'] ).$complete_time.'
'.Security::remove_XSS( $value['content'] ) ); //Main div $result .= Display::div( $content, array( 'id' => 'main_'.$link, 'class' => 'dialog', 'style' => 'display:none' ) ); $result .= '
'; $html .= $result; //echo Display::div($content, array('id'=>'main_'.$value['calendar_type'].'_'.$value['id'], 'class' => 'dialog')); } else { $html .= $result .= $icon.''; } } } $html .= "
"; echo $html; } /** * Get personal agenda items between two dates (=all events from all registered courses) * @param int user ID of the user * @param string Optional start date in datetime format (if no start date is given, uses today) * @param string Optional end date in datetime format (if no date is given, uses one year from now) * @param integer $user_id * @return array Array of events ordered by start date, in * [0]('datestart','dateend','title'),[1]('datestart','dateend','title','link','coursetitle') format, * where datestart and dateend are in yyyyMMddhhmmss format. * @deprecated use agenda events */ public static function get_personal_agenda_items_between_dates( $user_id, $date_start = '', $date_end = '' ) { $items = array(); if ($user_id != strval(intval($user_id))) { return $items; } if (empty($date_start)) { $date_start = date('Y-m-d H:i:s'); } if (empty($date_end)) { $date_end = date( 'Y-m-d H:i:s', mktime(0, 0, 0, date("m"), date("d"), date("Y") + 1) ); } $expr = '/\d{4}-\d{2}-\d{2}\ \d{2}:\d{2}:\d{2}/'; if (!preg_match($expr, $date_start)) { return $items; } if (!preg_match($expr, $date_end)) { return $items; } // get agenda-items for every course $courses = api_get_user_courses($user_id, false); foreach ($courses as $id => $course) { $c = api_get_course_info_by_id($course['real_id']); //databases of the courses $t_a = Database::get_course_table(TABLE_AGENDA, $course['db']); $t_ip = Database::get_course_table( TABLE_ITEM_PROPERTY, $course['db'] ); // get the groups to which the user belong $group_memberships = GroupManager:: get_group_ids( $course['db'], $user_id ); // if the user is administrator of that course we show all the agenda items if ($course['status'] == '1') { //echo "course admin"; $sqlquery = "SELECT ". " DISTINCT agenda.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.ref ". " FROM ".$t_a." agenda, ". $t_ip." ip ". " WHERE agenda.id = ip.ref ". " AND agenda.start_date>='$date_start' ". " AND agenda.end_date<='$date_end' ". " AND ip.tool='".TOOL_CALENDAR_EVENT."' ". " AND ip.visibility='1' ". " GROUP BY agenda.id ". " ORDER BY start_date "; } else { // if the user is not an administrator of that course, then... if (is_array($group_memberships) && count( $group_memberships ) > 0 ) { $sqlquery = "SELECT ". "DISTINCT agenda.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.ref ". " FROM ".$t_a." agenda, ". $t_ip." ip ". " WHERE agenda.id = ip.ref ". " AND agenda.start_date>='$date_start' ". " AND agenda.end_date<='$date_end' ". " AND ip.tool='".TOOL_CALENDAR_EVENT."' ". " AND ( ip.to_user_id='".$user_id."' OR (ip.to_group_id IS NULL OR ip.to_group_id IN (0, ".implode( ", ", $group_memberships ).")) ) ". " AND ip.visibility='1' ". " ORDER BY start_date "; } else { $sqlquery = "SELECT ". "DISTINCT agenda.*, ip.visibility, ip.to_group_id, ip.insert_user_id, ip.ref ". " FROM ".$t_a." agenda, ". $t_ip." ip ". " WHERE agenda.id = ip.ref ". " AND agenda.start_date>='$date_start' ". " AND agenda.end_date<='$date_end' ". " AND ip.tool='".TOOL_CALENDAR_EVENT."' ". " AND ( ip.to_user_id='".$user_id."' OR ip.to_group_id='0' OR ip.to_group_id IS NULL) ". " AND ip.visibility='1' ". " ORDER BY start_date "; } } $result = Database::query($sqlquery); while ($item = Database::fetch_array($result)) { $agendaday = date("j", strtotime($item['start_date'])); $month = date("n", strtotime($item['start_date'])); $year = date("Y", strtotime($item['start_date'])); $URL = api_get_path( WEB_PATH )."main/calendar/agenda.php?cidReq=".urlencode( $course["code"] )."&day=$agendaday&month=$month&year=$year#$agendaday"; list($year, $month, $day, $hour, $min, $sec) = split( '[-: ]', $item['start_date'] ); $start_date = $year.$month.$day.$hour.$min; list($year, $month, $day, $hour, $min, $sec) = split( '[-: ]', $item['end_date'] ); $end_date = $year.$month.$day.$hour.$min; $items[] = array( 'datestart' => $start_date, 'dateend' => $end_date, 'title' => $item['title'], 'link' => $URL, 'coursetitle' => $c['name'], ); } } return $items; } /** * This function retrieves one personal agenda item returns it. * @param int $id The agenda item ID * @return array The results of the database query, or null if not found */ public static function get_personal_agenda_item($id) { $tbl_personal_agenda = Database::get_main_table(TABLE_PERSONAL_AGENDA); $id = intval($id); // make sure events of the personal agenda can only be seen by the user himself $user = api_get_user_id(); $sql = " SELECT * FROM ".$tbl_personal_agenda." WHERE id=".$id." AND user = ".$user; $result = Database::query($sql); if (Database::num_rows($result) == 1) { $item = Database::fetch_array($result); } else { $item = null; } return $item; } /** * This function calculates the startdate of the week (monday) * and the enddate of the week (sunday) * and returns it as an array */ public static function calculate_start_end_of_week($week_number, $year) { // determine the start and end date // step 1: we calculate a timestamp for a day in this week $random_day_in_week = mktime( 0, 0, 0, 1, 1, $year ) + ($week_number) * (7 * 24 * 60 * 60); // we calculate a random day in this week // step 2: we which day this is (0=sunday, 1=monday, ...) $number_day_in_week = date('w', $random_day_in_week); // step 3: we calculate the timestamp of the monday of the week we are in $start_timestamp = $random_day_in_week - (($number_day_in_week - 1) * 24 * 60 * 60); // step 4: we calculate the timestamp of the sunday of the week we are in $end_timestamp = $random_day_in_week + ((7 - $number_day_in_week + 1) * 24 * 60 * 60) - 3600; // step 5: calculating the start_day, end_day, start_month, end_month, start_year, end_year $start_day = date('j', $start_timestamp); $start_month = date('n', $start_timestamp); $start_year = date('Y', $start_timestamp); $end_day = date('j', $end_timestamp); $end_month = date('n', $end_timestamp); $end_year = date('Y', $end_timestamp); $start_end_array['start']['day'] = $start_day; $start_end_array['start']['month'] = $start_month; $start_end_array['start']['year'] = $start_year; $start_end_array['end']['day'] = $end_day; $start_end_array['end']['month'] = $end_month; $start_end_array['end']['year'] = $end_year; return $start_end_array; } /** * @return bool */ public function getIsAllowedToEdit() { return $this->isAllowedToEdit; } /** * @param bool $isAllowedToEdit */ public function setIsAllowedToEdit($isAllowedToEdit) { $this->isAllowedToEdit = $isAllowedToEdit; } /** * @param int $userId * @param array $event * * @return bool */ public function sendEmail($userId, $event) { $userInfo = api_get_user_info($userId); if (!empty($this->sessionInfo)) { $courseTitle = $this->course['name'].' ('.$this->sessionInfo['title'].')'; } else { $courseTitle = $this->course['name']; } api_mail_html( $userInfo['complete_name'], $userInfo['mail'], $subject, $emailBody ); return true; } }