$course_item['code'],
'title' => $course_item['title'],
);
}
} else {
$current_course['code'] = $_course['id'];
$course_list = array($current_course);
}
$new_course_select = array();
foreach ($course_list as $data) {
$new_course_select[$data['code']] = $data['title'];
}
$form = new FormValidator('search_simple', 'POST', '', '', null, false);
$form->addElement('select', 'course_code', get_lang('Course'), $new_course_select);
if ($global) {
$form->addElement('hidden', 'view', 'admin');
} else {
//Get exam lists
$course_id = api_get_course_int_id();
$t_quiz = Database::get_course_table(TABLE_QUIZ_TEST);
$sqlExercices = "SELECT quiz.title,id FROM ".$t_quiz." AS quiz
WHERE c_id = $course_id AND active='1'
ORDER BY quiz.title ASC";
$resultExercices = Database::query($sqlExercices);
$exercise_list[0] = get_lang('All');
while ($a_exercices = Database::fetch_array($resultExercices)) {
$exercise_list[$a_exercices['id']] = $a_exercices['title'];
}
$form->addElement('select', 'exercise_id', get_lang('Exercise'), $exercise_list);
}
//$form->addElement('submit','submit',get_lang('Filter'));
$form->addButtonFilter(get_lang('Filter'));
if (!empty($_REQUEST['course_code'])) {
$selected_course = $_REQUEST['course_code'];
}
if (!empty($selected_course)) {
$selected_course = api_get_course_info($selected_course);
$course_list = array($selected_course);
}
if (!$export_to_csv) {
Display :: display_header(get_lang('Reporting'));
echo '';
echo '
';
$form->display();
}
$main_result = array();
$session_id = 0;
$user_list = array();
// Getting course list
foreach ($course_list as $current_course) {
$course_info = api_get_course_info($current_course['code']);
$_course = $course_info;
// Getting LP list
$list = new LearnpathList('', $current_course['code'], $session_id);
$lp_list = $list->get_flat_list();
// Looping LPs
$lps = array();
foreach ($lp_list as $lp_id =>$lp) {
$exercise_list = Event::get_all_exercises_from_lp($lp_id, $course_info['real_id']);
$attempt_result = array();
// Looping Chamilo Exercises in LP
foreach ($exercise_list as $exercise) {
$exercise_stats = Event::get_all_exercise_event_from_lp(
$exercise['path'],
$course_info['real_id'],
$session_id
);
// Looping Exercise Attempts
foreach ($exercise_stats as $stats) {
$attempt_result[$exercise['id']]['users'][$stats['exe_user_id']][$stats['exe_id']] = $stats;
$user_list[$stats['exe_user_id']] = $stats['exe_user_id'];
}
$exercise_list_name[$exercise['id']] = $exercise['title'];
}
$lps[$lp_id] = array('lp_name' =>$lp['lp_name'], 'exercises' =>$attempt_result);
$lp_list_name[$lp_id] = $lp['lp_name'];
}
$main_result[$current_course['code']] = $lps;
}
if (!empty($user_list)) {
foreach ($user_list as $user_id) {
$user_data = api_get_user_info($user_id);
$user_list_name[$user_id] = api_get_person_name(
$user_data['firstname'],
$user_data['lastname']
);
}
}
$export_array = array();
if (!empty($main_result)) {
$html_result .= '';
$html_result .= '| '.get_lang('Course').' | ';
$html_result .= ''.get_lang('LearningPath').' | ';
$html_result .= ''.get_lang('Exercise').' | ';
$html_result .= ''.get_lang('User').' | ';
$html_result .= ''.get_lang('Attempt').' | ';
$html_result .= ''.get_lang('Date').' | ';
$html_result .= ''.get_lang('Results').' | ';
$html_result .= '
|---|
';
foreach ($main_result as $course_code => $lps) {
if (empty($lps)) {
continue;
}
foreach ($lps as $lp_id => $lp_data) {
$exercises = $lp_data['exercises'];
foreach ($exercises as $exercise_id => $exercise_data) {
$users = $exercise_data['users'];
foreach ($users as $user_id => $attempts) {
$attempt = 1;
foreach ($attempts as $exe_id => $attempt_data) {
$html_result .= '';
$html_result .= Display::tag('td', $course_code);
$html_result .= Display::tag('td', $lp_list_name[$lp_id]);
$html_result .= Display::tag('td', $exercise_list_name[$exercise_id]);
$html_result .= Display::tag('td', $user_list_name[$user_id]);
$result = $attempt_data['exe_result'].' / '.$attempt_data['exe_weighting'];
$html_result .= Display::tag('td', $attempt);
$html_result .= Display::tag('td', api_get_local_time($attempt_data['exe_date']));
$html_result .= Display::tag('td', $result);
$html_result .= '
';
$export_array[] = array(
$course_code,
$lp_list_name[$lp_id],
$exercise_list_name[$exercise_id],
$user_list_name[$user_id],
$attempt,
api_get_local_time($attempt_data['exe_date']),
$result,
);
$attempt++;
}
}
}
}
}
$html_result .= '
';
}
if (!$export_to_csv) {
echo $html_result;
}
$filename = 'learning_path_results-'.date('Y-m-d-h:i:s').'.xls';
if ($export_to_csv) {
export_complete_report_csv($filename, $export_array);
exit;
}
function export_complete_report_csv($filename, $array)
{
$header[] = array(
get_lang('Course'),
get_lang('LearningPath'),
get_lang('Exercise'),
get_lang('User'),
get_lang('Attempt'),
get_lang('Date'),
get_lang('Results'),
);
if (!empty($array)) {
$array = array_merge($header, $array);
Export :: arrayToCsv($array, $filename);
}
exit;
}
Display :: display_footer();