api_get_path(WEB_COURSE_PATH).urlencode($course_path).'/index.php', 'name' => Security::remove_XSS($_GET['courseCode'])); } // this loads the javascript that is needed for the date popup selection // showing the header Display::display_header(get_lang('MyAgenda')); function display_mymonthcalendar_2($agendaitems, $month, $year, $weekdaynames=array(), $monthName, $session_id) { 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']:''); $backwardsURL = api_get_self()."?coursePath=".urlencode($course_path)."&session=".Security::remove_XSS($session_id)."&courseCode=".Security::remove_XSS($g_cc)."&action=view&view=month&month=". ($month == 1 ? 12 : $month -1)."&year=". ($month == 1 ? $year -1 : $year); $forewardsURL = api_get_self()."?coursePath=".urlencode($course_path)."&session=".Security::remove_XSS($session_id)."&courseCode=".Security::remove_XSS($g_cc)."&action=view&view=month&month=". ($month == 12 ? 1 : $month +1)."&year=". ($month == 12 ? $year +1 : $year); echo "\n", "\n", "\n", "\n", "\n", "\n"; echo "\n"; for ($ii = 1; $ii < 8; $ii ++) { echo "\n"; } echo "\n"; $curday = -1; $today = getdate(); while ($curday <= $numberofdays[$month]) { echo "\n"; for ($ii = 0; $ii < 7; $ii ++) { if (($curday == -1) && ($ii == $startdayofweek)) { $curday = 1; } if (($curday > 0) && ($curday <= $numberofdays[$month])) { $bgcolor = $ii < 5 ? $class = "class=\"days_week\" style=\"width:10%;\"" : $class = "class=\"days_weekend\" style=\"width:10%;\""; $dayheader = "$curday
"; if (($curday == $today['mday']) && ($year == $today['year']) && ($month == $today['mon'])) { $dayheader = "$curday - ".get_lang("Today")."
"; $class = "class=\"days_today\" style=\"width:10%;\""; } echo "\n"; $curday ++; } else { echo "\n"; } } echo "\n"; } echo "

«	", $monthName, " ", $year, "	»
", $DaysShort[$ii % 7], "
", "".$dayheader; if (!empty($agendaitems[$curday])) { echo "".$agendaitems[$curday].""; } echo "

\n"; } function get_agenda_items_by_course_list($course_list, $month, $year, $session_id = 0) { global $setting_agenda_link; //echo $sql = 'SELECT name FROM chamilo_main.class WHERE name = "'.$grado.'" ORDER BY name ASC'; //$result = Database::query($sql); //while ($row = Database::fetch_array($result, 'ASSOC')) { $agendaitems = array (); $course_name_list = array(); foreach ($course_list as $course) { $db_name = $course['db_name']; $code = $course['code']; $title = $course['title']; $course_name_list[] = $title; //$sql2 = 'SELECT code, db_name, title FROM chamilo_main.course WHERE category_code = "'.$course_name.'" '; // $courses_dbs = Database::query($sql2); $items = array (); // $courses_dbs = array(); // get agenda-items for every course //while($row2 = Database::fetch_array($courses_dbs, 'ASSOC')) { //$db_name = $row2['db_name']; //$code = $row2['code']; //$title = $row2['title']; //echo "

".$db_name."

"; //databases of the courses $TABLEAGENDA = Database :: get_course_table(TABLE_AGENDA, $db_name); $TABLE_ITEMPROPERTY = Database :: get_course_table(TABLE_ITEM_PROPERTY, $db_name); //$group_memberships = GroupManager :: get_group_ids($array_course_info["db"], $_user['user_id']); // if the user is administrator of that course we show all the agenda items $session_condition = ''; if ($session_id != 0) { $session_id = intval($session_id); $session_condition = "AND session_id = $session_id"; } $sqlquery = "SELECT DISTINCT agenda.*, item_property.* FROM ".$TABLEAGENDA." agenda, ".$TABLE_ITEMPROPERTY." item_property WHERE agenda.id = item_property.ref AND MONTH(agenda.start_date)='".$month."' AND YEAR(agenda.start_date)='".$year."' AND item_property.tool='".TOOL_CALENDAR_EVENT."' AND item_property.visibility='1' $session_condition GROUP BY agenda.id ORDER BY start_date "; $result = Database::query($sqlquery); while ($item = Database::fetch_array($result,'ASSOC')) { //taking the day $agendaday = date("j",strtotime($item['start_date'])); if(!isset($items[$agendaday])){$items[$agendaday]=array();} //taking the time $time = date("H:i",strtotime($item['start_date'])); $end_time= date("H:i",strtotime($item['end_date'])); $URL = api_get_path(WEB_PATH)."main/calendar/allagendas.php?cidReq=".urlencode($code)."&sort=asc&view=list&day=$agendaday&month=$month&year=$year#$agendaday"; // RH //Patrick Cool: to highlight the relevant agenda item if ($setting_agenda_link == 'coursecode') { //$title=$array_course_info['title']; $agenda_link = api_substr($title, 0, 14); } else { $agenda_link = Display::return_icon('course_home.gif'); } if(!isset($items[$agendaday][$item['start_date']])) { $items[$agendaday][$item['start_date']] = ''; } $items[$agendaday][$item['start_date']] .= "".get_lang('StartTimeWindow')." ".$time.""." - ".get_lang("EndTimeWindow")." ".$end_time." "; $items[$agendaday][$item['start_date']] .= '
'."".$agenda_link." ".Security::remove_XSS($item['title'])."
"; $items[$agendaday][$item['start_date']] .= '
'; } if (is_array($items) && count($items) > 0) { while (list ($agendaday, $tmpitems) = each($items)) { if(!isset($agendaitems[$agendaday])) { $agendaitems[$agendaday] = ''; } sort($tmpitems); while (list ($key, $val) = each($tmpitems)) { $agendaitems[$agendaday] .= $val; } } } } echo "

Courses:

".implode(', ',$course_name_list)."

"; return $agendaitems; } /* SETTING SOME VARIABLES */ // the variables for the days and the months // Defining the shorts for the days $DaysShort = api_get_week_days_short(); // Defining the days of the week to allow translation of the days $DaysLong = api_get_week_days_long(); // Defining the months of the year to allow translation of the months $MonthsLong = api_get_months_long(); /* TREATING THE URL PARAMETERS 1. The default values 2. storing it in the session 3. possible view 3.a Month view 3.b Week view 3.c day view 3.d personal view (only the personal agenda items) */ // 1. The default values. if there is no session yet, we have by default the month view if (empty($_SESSION['view'])) { $_SESSION['view'] = 'month'; } // 2. Storing it in the session. If we change the view by clicking on the links left, we change the session if (!empty($_GET['view'])) { $_SESSION['view'] = Security::remove_XSS($_GET['view']); } // 3. The views: (month, week, day, personal) if ($_SESSION['view']) { switch ($_SESSION['view']) { // 3.a Month view case "month" : $process = "month_view"; break; // 3.a Week view case "week" : $process = "week_view"; break; // 3.a Day view case "day" : $process = "day_view"; break; // 3.a Personal view case "personal" : $process = "personal_view"; break; } } $my_course_id = intval($_GET['course']); $my_session_id = intval($_GET['session']); $my_course_list = array(); if(!empty($my_session_id)) { $_SESSION['my_course_list'] = array(); $my_course_list = array(); } else { $my_course_list = $_SESSION['my_course_list']; $my_course_list_keys = array_keys($my_course_list); if (!in_array($my_course_id, $my_course_list_keys)) { $course_info = api_get_course_info_by_id($my_course_id); $_SESSION['my_course_list'][$my_course_id] = $course_info; $my_course_list = $_SESSION['my_course_list']; //echo $my_course_id.'added '; } if (isset($_GET['delete_course_option'])) { $course_id_to_delete = intval($_GET['delete_course_option']); unset($_SESSION['my_course_list'][$course_id_to_delete]); $my_course_list = $_SESSION['my_course_list']; } //clean the array $my_course_list = array_filter($my_course_list); } /* OUTPUT */ if (isset ($_user['user_id'])) { // getting all the courses that this user is subscribed to $courses_dbs = get_all_courses_of_user(); if (!is_array($courses_dbs)) { // this is for the special case if the user has no courses (otherwise you get an error) $courses_dbs = array (); } // setting and/or getting the year, month, day, week $today = getdate(); $year = (!empty($_GET['year'])? (int)$_GET['year'] : NULL); if ($year == NULL) { $year = $today['year']; } $month = (!empty($_GET['month'])? (int)$_GET['month']:NULL); if ($month == NULL) { $month = $today['mon']; } $day = (!empty($_GET['day']) ? (int)$_GET['day']:NULL); if ($day == NULL) { $day = $today['mday']; } $week = (!empty($_GET['week']) ?(int)$_GET['week']:NULL); if ($week == NULL) { $week = date("W"); } // The name of the current Month $monthName = $MonthsLong[$month -1]; if (api_is_platform_admin()) { $courses = array(); $sessions = SessionManager::get_sessions_list(); } elseif(api_is_drh()) { $courses = CourseManager::get_courses_followed_by_drh(api_get_user_id()); $sessions = SessionManager::get_sessions_followed_by_drh(api_get_user_id()); } echo ''; echo ''; // output: the small calendar item on the left and the view / add links echo ''; // the divider // OlivierB : the image has a white background, which causes trouble if the portal has another background color. Image should be transparent. ----> echo ""; echo ""; // the main area: day, week, month view echo '

'; echo '
'; if (count($courses) > 0) { echo '

'.get_lang('SelectACourse').'

'; foreach ($courses as $row_course) { $course_code = $row_course['id']; $title = $row_course['title']; $my_course_list_keys = array_keys($my_course_list); if (!in_array($course_code, $my_course_list_keys)) { echo ''.$title.'
'; } else { echo ''.$title.' Delete
'; } } } if (count($sessions) > 0) { echo '

'.get_lang('SelectASession').'

'; foreach ($sessions as $session) { $id = $session['id']; $name = $session['name']; echo ''.$name.'
'; } } echo '

'; //@todo hardcoding option $process = 'month_view'; switch ($process) { case "month_view" : $session_id = 0; //By courses if (is_array($my_course_list) && count($my_course_list) > 0) { $course_list = $my_course_list; } else { //session $course_list = SessionManager::get_course_list_by_session_id($my_session_id); $session_id = $my_session_id; echo '

'.$sessions[$session_id]['name'].'

'; } if (is_array($course_list) && count($course_list) > 0) { $agendaitems = get_agenda_items_by_course_list($course_list, $month, $year, $session_id); display_mymonthcalendar_2($agendaitems, $month, $year, array(), $monthName, $session_id); } else { Display::display_warning_message(get_lang('PleaseSelectACourseOrASessionInTheLeftColumn')); } break; } } echo "

"; Display :: display_footer();