user_id = $user_id; $this->path = 'block_daily'; if ($this->is_block_visible_for_user($user_id)) { $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 = $this->get_content_html(); $html = '
' . get_lang('GradebookAndAttendances') . '
' . $content . '
'; $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_user = Database::get_main_table(TABLE_MAIN_COURSE_USER); $course_data = array(); $courses = $this->courses; foreach ($courses as $row_course) { $score = null; $courseId = $row_course['c_id']; $course_info = api_get_course_info_by_id($courseId); $course_code = $course_info['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(); 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_info['code']; if ($attendance['done'] != '0') { $attendances[] = '' . Display::return_icon('printmgr.gif', get_lang('Print')).''; } else { $attendances[] = get_lang("NotAvailable"); } } if (count($attendances) == 0) { $attendances[] = get_lang("NotAvailable"); } // Number of students $sql = "SELECT user_id FROM $tbl_course_user as course_rel_user WHERE course_rel_user.status=" . STUDENT . " AND course_rel_user.c_id=$courseId"; $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; } }