/** * 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()) {