forcelogin) { require_login(); } if (!$category = get_record("course_categories", "id", $id)) { error("Category not known!"); } if (iscreator()) { if (isset($_GET['edit']) and confirm_sesskey()) { if ($edit == "on") { $USER->categoryediting = true; } else if ($edit == "off") { $USER->categoryediting = false; } } $navbaritem = update_category_button($category->id); $creatorediting = !empty($USER->categoryediting); $adminediting = (isadmin() and $creatorediting); } else { if (!$category->visible) { error(get_string('notavailable', 'error')); } $navbaritem = print_course_search("", true, "navbar"); $adminediting = false; $creatorediting = false; } if (isadmin()) { /// Rename the category if requested if (!empty($_POST['rename']) and confirm_sesskey()) { $category->name = $_POST['rename']; if (! set_field("course_categories", "name", $category->name, "id", $category->id)) { notify("An error occurred while renaming the category"); } } /// Resort the category if requested if (!empty($_GET['resort']) and confirm_sesskey()) { if ($courses = get_courses($category->id, "fullname ASC", 'c.id,c.fullname,c.sortorder')) { // move it off the range $count = get_record_sql('SELECT MAX(sortorder) AS max, 1 FROM ' . $CFG->prefix . 'course WHERE category=' . $category->id); $count = $count->max + 100; begin_sql(); foreach ($courses as $course) { set_field('course', 'sortorder', $count, 'id', $course->id); $count++; } commit_sql(); fix_course_sortorder($category->id); } } } /// Print headings $numcategories = count_records("course_categories"); $stradministration = get_string("administration"); $strcategories = get_string("categories"); $strcategory = get_string("category"); $strcourses = get_string("courses"); if ($creatorediting) { if ($adminediting) { print_header("$site->shortname: $category->name", "$site->fullname: $strcourses", "admin/index.php\">$stradministration -> ". "$strcategories -> $category->name", "", "", true, $navbaritem); } else { print_header("$site->shortname: $category->name", "$site->fullname: $strcourses", "$strcategories -> $category->name", "", "", true, $navbaritem); } } else { print_header("$site->shortname: $category->name", "$site->fullname: $strcourses", "$strcategories -> $category->name", "", "", true, $navbaritem); } /// Print the category selector $displaylist = array(); $parentlist = array(); make_categories_list($displaylist, $parentlist, ""); echo '

'; echo "

$strcategories:

"; echo "

"; popup_form("category.php?id=", $displaylist, "switchcategory", "$category->id", "", "", "", false); echo "

"; /// Editing functions if ($adminediting) { /// Move a specified course to a new category if (isset($moveto) and $data = data_submitted() and confirm_sesskey()) { // Some courses are being moved if (! $destcategory = get_record("course_categories", "id", $data->moveto)) { error("Error finding the category"); } unset($data->moveto); unset($data->id); unset($data->sesskey); if ($data) { foreach ($data as $code => $junk) { $courseid = substr($code, 1); if (! record_exists('course', 'id', $courseid)) { notify('Error finding a course'); } else { // figure out a sortorder that we can use in the destination category $sortorder = get_field_sql('SELECT MIN(sortorder)-1 AS min FROM ' . $CFG->prefix . 'course WHERE category=' . $destcategory->id); if ($sortorder === false) { // the category is empty // rather than let the db default to 0 // set it to > 100 and avoid extra work in fix_coursesortorder() $sortorder = 200; } else if ($sortorder < 10) { fix_course_sortorder($categoryid); } $newcourse = new stdClass; $newcourse->id = $courseid; $newcourse->category = $destcategory->id; $newcourse->sortorder = $sortorder; if (!update_record('course', $newcourse)) { notify("An error occurred - course not moved!"); } fix_course_sortorder(); } } $category = get_record('course_categories', 'id', $category->id); // Refresh it } } /// Hide or show a course if ((isset($hide) or isset($show)) and confirm_sesskey()) { if (isset($hide)) { $course = get_record("course", "id", $hide); $visible = 0; } else { $course = get_record("course", "id", $show); $visible = 1; } if ($course) { if (! set_field("course", "visible", $visible, "id", $course->id)) { notify("Could not update that course!"); } } } /// Move a course up or down if ((isset($moveup) or isset($movedown)) and confirm_sesskey()) { $movecourse = NULL; $swapcourse = NULL; // ensure the course order has no gaps // and isn't at 0 fix_course_sortorder($category->id); // we are going to need to know the range $max = get_record_sql('SELECT MAX(sortorder) AS max, 1 FROM ' . $CFG->prefix . 'course WHERE category=' . $category->id); $max = $max->max + 100; if (isset($moveup)) { $movecourse = get_record('course', 'id', $moveup); $swapcourse = get_record('course', 'category', $category->id, 'sortorder', $movecourse->sortorder - 1); } else { $movecourse = get_record('course', 'id', $movedown); $swapcourse = get_record('course', 'category', $category->id, 'sortorder', $movecourse->sortorder + 1); } if ($swapcourse and $movecourse) { // Renumber everything for robustness begin_sql(); if (!( set_field("course", "sortorder", $max, "id", $swapcourse->id) && set_field("course", "sortorder", $swapcourse->sortorder, "id", $movecourse->id) && set_field("course", "sortorder", $movecourse->sortorder, "id", $swapcourse->id) )) { notify("Could not update that course!"); } commit_sql(); } } } // End of editing stuff /// Print out all the sub-categories if ($subcategories = get_records("course_categories", "parent", $category->id, "sortorder ASC")) { $firstentry = true; foreach ($subcategories as $subcategory) { if ($subcategory->visible or iscreator()) { $subcategorieswereshown = true; if ($firstentry) { echo ''; echo ''; echo '

'.get_string('subcategories').'
'; $firstentry = false; } $catlinkcss = $subcategory->visible ? "" : " class=\"dimmed\" "; echo ''. $subcategory->name.' '; } } if (!$firstentry) { echo "

"; echo "
"; } } /// Print out all the courses unset($course); // To avoid unwanted language effects later $courses = get_courses_page($category->id, 'c.sortorder ASC', 'c.id,c.sortorder,c.shortname,c.fullname,c.summary,c.visible,c.teacher,c.guest,c.password', $totalcount, $page*$perpage, $perpage); $numcourses = count($courses); if (!$courses) { if (empty($subcategorieswereshown)) { print_heading(get_string("nocoursesyet")); } } else if ($numcourses <= COURSE_MAX_SUMMARIES_PER_PAGE and !$page and !$creatorediting) { print_courses($category, "80%"); } else { print_paging_bar($totalcount, $page, $perpage, "category.php?id=$category->id&perpage=$perpage&"); $strcourses = get_string("courses"); $strselect = get_string("select"); $stredit = get_string("edit"); $strdelete = get_string("delete"); $strbackup = get_string("backup"); $strrestore = get_string("restore"); $strmoveup = get_string("moveup"); $strmovedown = get_string("movedown"); $strupdate = get_string("update"); $strhide = get_string("hide"); $strshow = get_string("show"); $strsummary = get_string("summary"); $strsettings = get_string("settings"); $strassignteachers = get_string("assignteachers"); $strallowguests = get_string("allowguests"); $strrequireskey = get_string("requireskey"); echo '

'; echo ''; echo ''; echo ''; if ($creatorediting) { echo ''; if ($adminediting) { echo ''; } } else { echo ''; } echo ''; $count = 0; $abletomovecourses = false; // for now // Checking if we are at the first or at the last page, to allow courses to // be moved up and down beyond the paging border if ($totalcount > $perpage) { $atfirstpage = ($page == 0); $atlastpage = (($page + 1) == ceil($totalcount / $perpage)); } else { $atfirstpage = true; $atlastpage = true; } foreach ($courses as $acourse) { $count++; $up = ($count > 1 || !$atfirstpage); $down = ($count < $numcourses || !$atlastpage); $linkcss = $acourse->visible ? "" : ' class="dimmed" '; echo ''; echo ''; if ($creatorediting) { if ($adminediting) { echo "'; echo ''; } else { echo '"; } echo ""; } if ($abletomovecourses) { echo ''; } echo '

'.$strcourses.'	'.$stredit.'	'.$strselect.'
'.$acourse->fullname.'	"; echo ''. ' '; echo ''. ' '; echo ''. ' '; if (!empty($acourse->visible)) { echo ''. ' '; } else { echo ''. ' '; } echo ''. ' '; echo ''. ' '; if ($up) { echo ''. ' '; } else { echo ' '; } if ($down) { echo ''. ' '; } else { echo ' '; } echo '	'; echo ''; $abletomovecourses = true; } else if (isteacheredit($acourse->id)) { echo '	'; echo ''. ' '; echo ''. ' '; } echo '	'; if (!empty($acourse->guest)) { echo ''; } if (!empty($acourse->password)) { echo ''; } if (!empty($acourse->summary)) { link_to_popup_window ("/course/info.php?id=$acourse->id", "courseinfo", '', 400, 500, $strsummary); } echo "
'; echo ' '; unset($displaylist[$category->id]); choose_from_menu ($displaylist, "moveto", "", get_string("moveselectedcoursesto"), "javascript:document.movecourses.submit()"); echo ''; echo '

'; echo '

'; echo '
'; } echo ''; if (isadmin() and $numcourses > 1) { /// Print button to re-sort courses by name unset($options); $options['id'] = $category->id; $options['resort'] = 'name'; $options['sesskey'] = $USER->sesskey; print_single_button('category.php', $options, get_string('resortcoursesbyname'), 'get'); } if (iscreator()) { /// Print button to create a new course unset($options); $options['category'] = $category->id; print_single_button('edit.php', $options, get_string('addnewcourse'), 'get'); echo '
'; } if (isadmin()) { /// Print form to rename the category $strrename= get_string('rename'); echo '"; echo "
"; } echo ""; print_footer(); ?>