/**
* Creates a link button with contextual JS list within all the documents
*
* @modified 2010.10.12 - adding css classes and simple a tag
* @return string
*/
function get_documents()
{
global $_course, $charset;
$tbl_doc = Database::get_course_table(TABLE_DOCUMENT);
$sql_doc = "\n\t\t\t\t\tSELECT *\n\t\t\t\t\tFROM " . $tbl_doc . "\n\t\t\t\t\tWHERE\n\t\t\t\t\t\tpath NOT LIKE '%_DELETED_%'\n\t\t\t\t\tORDER BY filetype DESC";
$res_doc = api_sql_query($sql_doc, __FILE__, __LINE__);
$document_lang_var = api_convert_encoding(get_lang('LpSelectDocument'), $charset, api_get_system_encoding());
$return = '<a href="#" onclick="javascript:popup(\'popUpDiv0\');" class="big_button four_buttons rounded grey_border select_doc_button">' . $document_lang_var . '</a>';
$doc_lang_var = api_convert_encoding(get_lang('Documents'), $charset, api_get_system_encoding());
$close_lang_var = api_convert_encoding(get_lang('Close'), $charset, api_get_system_encoding());
$nodocuments_lang_var = api_convert_encoding(get_lang('NoDocuments'), $charset, api_get_system_encoding());
$return .= '<div id="popUpDiv0" class="popUpDiv author_popup gradient rounded_10 grey_border" style="display:none;">' . '<span class="title">' . $doc_lang_var . '</span>' . '<a href="#" class="close" onclick="popup(\'popUpDiv0\')">' . $close_lang_var . '</a>';
$return .= '<div id="resDoc" class="content">';
$resources = api_store_result($res_doc);
$resources_sorted = array();
// if you want to debug it, I advise you to do "echo" on the eval statements
foreach ($resources as $resource) {
$resource_paths = explode('/', $resource['path']);
array_shift($resource_paths);
$path_to_eval = $last_path = '';
$is_file = false;
foreach ($resource_paths as $key => $resource_path) {
if (strpos($resource_path, '.') === false && $key != count($resource_paths) - 1) {
// it's a folder
$path_to_eval .= '["' . $resource_path . '"]["files"]';
} else {
if (strpos($resource_path, '.') !== false) {
$is_file = true;
}
}
$last_path = $resource_path;
}
if ($is_file) {
eval('$resources_sorted' . $path_to_eval . '[' . $resource['id'] . '] = "' . $last_path . '";');
} else {
eval('$resources_sorted' . $path_to_eval . '["' . $last_path . '"]["id"]=' . $resource['id'] . ';');
}
}
$resources_sorted = array_reverse($resources_sorted, true);
$return .= $this->write_resources_tree($resources_sorted);
$return .= '</div>';
if (Database::num_rows($res_doc) == 0) {
$return .= '<div class="lp_resource_element">' . $nodocuments_lang_var . '</div>';
}
$return .= '</div>';
// end of div#popUpDiv0
return $return;
}
$isCoach = api_is_coach();
$isPlatformAdmin = api_is_platform_admin();
$view = isset($_GET['view']) ? $_GET['view'] : 'teacher';
$menu_items = array();
global $_configuration;
if (api_is_allowed_to_create_course()) {
$sqlNbCours = "\tSELECT course_rel_user.course_code, course.title\r\n\t\t\t\t\tFROM {$tbl_course_user} as course_rel_user\r\n\t\t\t\t\tINNER JOIN {$tbl_course} as course\r\n\t\t\t\t\t\tON course.code = course_rel_user.course_code\r\n\t\t\t\t \tWHERE course_rel_user.user_id='" . $_user['user_id'] . "' AND course_rel_user.status='1'\r\n\t\t\t\t \tORDER BY course.title";
if ($_configuration['multiple_access_urls'] == true) {
$tbl_course_rel_access_url = Database::get_main_table(TABLE_MAIN_ACCESS_URL_REL_COURSE);
$access_url_id = api_get_current_access_url_id();
if ($access_url_id != -1) {
$sqlNbCours = "\tSELECT course_rel_user.course_code, course.title\r\n\t\t\t\tFROM {$tbl_course_user} as course_rel_user\r\n\t\t\t\tINNER JOIN {$tbl_course} as course\r\n\t\t\t\tON course.code = course_rel_user.course_code\r\n\t\t\t \tINNER JOIN {$tbl_course_rel_access_url} course_rel_url\r\n\t\t\t\tON (course_rel_url.course_code= course.code)\t \t\r\n\t\t\t \tWHERE access_url_id = {$access_url_id} AND course_rel_user.user_id='" . $_user['user_id'] . "' AND course_rel_user.status='1'\r\n\t\t\t \tORDER BY course.title";
}
}
$resultNbCours = api_sql_query($sqlNbCours, __FILE__, __LINE__);
$a_courses = api_store_result($resultNbCours);
$nb_teacher_courses = count($a_courses);
if ($nb_teacher_courses) {
if (!$isCoach && !api_is_platform_admin()) {
$view = 'teacher';
}
if ($view == 'teacher') {
$menu_items[] = get_lang('TeacherInterface');
$title = get_lang('YourCourseList');
} else {
$menu_items[] = '<a href="' . api_get_self() . '?view=teacher">' . get_lang('TeacherInterface') . '</a>';
}
}
}
if ($isCoach) {
if ($nb_teacher_courses == 0 && !api_is_platform_admin()) {
