user_id = $user_id;
$this->path = 'block_course';
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 = [];
$content = $this->get_content_html();
$html = '
'.get_lang('CoursesInformation').'
'.$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 = ''.get_lang('YourCourseList').'
';
$data_table = null;
if (!empty($course_data)) {
$data_table .= '';
$data_table .= '
'.get_lang('CourseTitle').' |
'.get_lang('NbStudents').' |
'.get_lang('AvgTimeSpentInTheCourse').' |
'.get_lang('ThematicAdvance').' |
';
$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[2])) {
$course[2] = '0:00:00';
}
foreach ($course as $cell) {
$data_table .= ''.$cell.' | ';
}
$data_table .= '
';
$i++;
}
$data_table .= '
';
} else {
$data_table .= get_lang('ThereIsNoInformationAboutYourCourses');
}
$content .= $data_table;
if (!empty($course_data)) {
$content .= '';
}
//$content .= '';
return $content;
}
/**
* Get number of courses.
*
* @return int
*/
public function get_number_of_courses()
{
return count($this->courses);
}
/**
* Get course information data.
*
* @return array
*/
public function get_course_information_data()
{
$tbl_course_user = Database::get_main_table(TABLE_MAIN_COURSE_USER);
$course_data = [];
$courses = $this->courses;
$thematic = new Thematic();
foreach ($courses as $row_course) {
$course_code = $row_course['code'];
$courseInfo = api_get_course_info($course_code);
$courseId = $courseInfo['real_id'];
$nb_students_in_course = $avg_progress_in_course = $avg_score_in_course = $avg_time_spent_in_course = $avg_score_in_exercise = 0;
// students directly subscribed to the course
$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 = [];
while ($row = Database::fetch_array($rs)) {
$users[] = $row['user_id'];
}
if (count($users) > 0) {
$nb_students_in_course = count($users);
$avg_time_spent_in_course = api_time_to_hms(
Tracking::get_time_spent_on_the_course($users, $courseId) / $nb_students_in_course
);
} else {
$avg_time_spent_in_course = null;
}
$tematic_advance = $thematic->get_total_average_of_thematic_advances(
$course_code,
0
);
if (!empty($tematic_advance)) {
$tematic_advance_progress = ''.$tematic_advance.'%';
} else {
$tematic_advance_progress = '0%';
}
$table_row = [];
$table_row[] = $row_course['title'];
$table_row[] = $nb_students_in_course;
$table_row[] = $avg_time_spent_in_course;
$table_row[] = $tematic_advance_progress;
$course_data[] = $table_row;
}
return $course_data;
}
}