user_id = $user_id; $this->path = 'block_daily'; if ($this->is_block_visible_for_user($user_id)) { /*if (api_is_platform_admin()) { $this->courses = CourseManager::get_real_course_list(); } else {*/ $this->courses = CourseManager::get_courses_followed_by_drh($user_id); //} } } /** * This method check if a user is allowed to see the block inside dashboard interface * @param int User id * @return bool Is block visible for user */ public function is_block_visible_for_user($user_id) { $user_info = api_get_user_info($user_id); $user_status = $user_info['status']; $is_block_visible_for_user = false; if (UserManager::is_admin($user_id) || in_array($user_status, $this->permission)) { $is_block_visible_for_user = true; } return $is_block_visible_for_user; } /** * This method return content html containing information about courses and its position for showing it inside dashboard interface * it's important to use the name 'get_block' for beeing used from dashboard controller * @return array column and content html */ public function get_block() { global $charset; $column = 2; $data = array(); $content = ''; $data_table = ''; $content = $this->get_content_html(); $html = ' '; $data['column'] = $column; $data['content_html'] = $html; return $data; } /** * This method return a content html, it's used inside get_block method for showing it inside dashboard interface * @return string content html */ public function get_content_html() { $course_data = $this->get_course_information_data(); $content = '

'; $content .= '

'.get_lang('YourCourseList').'

'; $data_table = null; if (!empty($course_data)) { $data_table .= ''; $data_table .= ''; $i = 1; foreach ($course_data as $course) { if ($i%2 == 0) { $class_tr = 'row_odd'; } else { $class_tr = 'row_even'; } $data_table .= ''; if (!isset($course[3])) { $course[3] = get_lang('NotAvailable'); } foreach ($course as $cell) { $data_table .= ''; } $data_table .= ''; $i++; } $data_table .= '

'.get_lang('CourseTitle').'	'.get_lang('NbStudents').'	'.get_lang('Evaluation').'	'.get_lang('ToolAttendance').'
'.$cell.'

'; } else { $data_table .= get_lang('ThereIsNoInformationAboutYourCourses'); } $content .= $data_table; if (!empty($course_data)) { $content .= '

'.get_lang('SeeMore').'

'; } $content .= '

'; return $content; } /** * Get number of courses * @return int */ function get_number_of_courses() { return count($this->courses); } /** * Get course information data * @return array */ function get_course_information_data() { $tbl_course = Database::get_main_table(TABLE_MAIN_COURSE); $tbl_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER); $a_course_students = array(); $course_data = array(); $courses = $this->courses; foreach ($courses as $row_course) { $score = null; $course_code = $row_course['code']; $course_info = api_get_course_info($course_code); if (empty($course_info)) { continue; } // Attendance table $table_course = Database::get_course_table(TABLE_ATTENDANCE); $sql = "SELECT id, name, attendance_qualify_max FROM $table_course WHERE c_id = ".$course_info['real_id']." AND active = 1 AND session_id = 0"; $rs = Database::query($sql); $attendance = array(); $attendances = array(); $param_gradebook = ''; if (isset($_SESSION['gradebook'])) { $param_gradebook = '&gradebook='.$_SESSION['gradebook']; } while ($row = Database::fetch_array($rs,'ASSOC')) { $attendance['done'] = $row['attendance_qualify_max']; $attendance['id'] = $row['id']; //$attendance['name'] = $row['name']; $attendance['course_code'] = $course_code; if ($attendance['done'] != '0') $attendances[] = ''.Display::return_icon('printmgr.gif',get_lang('Print')).''; else $attendances[] = get_lang("NotAvailable"); } $sql = "SELECT user_id FROM $tbl_course_user as course_rel_user WHERE course_rel_user.status=".STUDENT." AND course_rel_user.c_id = ".$course_info['real_id']; $rs = Database::query($sql); $users = array(); while ($row = Database::fetch_array($rs)) { $users[] = $row['user_id']; } if (count($users) > 0) { $nb_students_in_course = count($users); } if (!empty($tematic_advance)) { $tematic_advance_progress = ''.$tematic_advance.'%'; } else { $tematic_advance_progress = '0%'; } // Score $tbl_grade_categories = Database :: get_main_table(TABLE_MAIN_GRADEBOOK_CATEGORY); $sql = "SELECT id from " . $tbl_grade_categories ." WHERE course_code ='".$course_code."'"; $rs = Database::query($sql); $category = null; while ($row = Database::fetch_array($rs)) { $category = $row['id']; } if (!empty($category)) { $cat = Category::load($category); $eval = $cat[0]->get_evaluations(); if (count($eval) > 0){ $i = 0; foreach ($eval as $item) { $score .= ''.$item->get_name().''; if (count($eval)-1 != $i) { $score .= ', '; } $i++; } } else { $score = get_lang("NotAvailable"); } } else { $score = get_lang("NotAvailable"); } $table_row = array(); $table_row[] = $row_course['title']; $table_row[] = $nb_students_in_course; $table_row[] = $score; $table_row[] = $attendances[0]; $course_data[] = $table_row; } return $course_data; } }

'.get_lang('GradebookAndAttendances').'

'.get_lang('YourCourseList').'