From 35a0aeb84acd8f45fb201fdc0eaea85b379e51b6 Mon Sep 17 00:00:00 2001
From: Vadimon <Vadimon@mail.ru>
Date: Sat, 30 Jan 2010 00:59:36 +0700
Subject: [PATCH] Sub-categories management for users with non-global admin rights

---
 course/category.php     |  208 ++++++++++++++++++++++++++++++++++++++++++-----
 lang/en_utf8/moodle.php |    1 +
 2 files changed, 188 insertions(+), 21 deletions(-)

diff --git a/course/category.php b/course/category.php
index 1f0cb5f..70ec80a 100644
--- a/course/category.php
+++ b/course/category.php
@@ -16,6 +16,11 @@
     $movedown = optional_param('movedown', 0, PARAM_INT);
     $moveto = optional_param('moveto', 0, PARAM_INT);
     $resort = optional_param('resort', 0, PARAM_BOOL);
+    $hidesubcategory = optional_param('hidesubcategory', 0, PARAM_INT);
+    $showsubcategory = optional_param('showsubcategory', 0, PARAM_INT);
+    $movecategoryup = optional_param('movecategoryup', 0, PARAM_INT);
+    $movecategorydown = optional_param('movecategorydown', 0, PARAM_INT);
+    $resortsubcategories = optional_param('resortsubcategories', 0, PARAM_BOOL);
 
     if ($CFG->forcelogin) {
         require_login();
@@ -53,6 +58,20 @@
 
     // Process any category actions.
     if (has_capability('moodle/category:manage', $context)) {
+        /// Resort subcategories if requested
+        if ($resortsubcategories and confirm_sesskey()) {
+            if ($subcategories = get_records('course_categories', 'parent', $category->id, 'name ASC')) {
+                // move it off the range
+                $count = 1;
+                begin_sql();
+                foreach ($subcategories as $subcategory) {
+                    set_field('course_categories', 'sortorder', $count, 'id', $subcategory->id);
+                    $count++;
+                }
+                commit_sql();
+            }
+        }
+
         /// Resort the category if requested
         if ($resort and confirm_sesskey()) {
             if ($courses = get_courses($category->id, "fullname ASC", 'c.id,c.fullname,c.sortorder')) {
@@ -70,8 +89,51 @@
             }
         }
     }
+    if ($editingon) {
+    /// Hide or show subcategory
+        if ((!empty($hidesubcategory) or !empty($showsubcategory)) and confirm_sesskey()) {
+            if (!empty($hidesubcategory)) {
+                $subcategory = get_record('course_categories', 'id', $hidesubcategory);
+                $visible = 0;
+            } else {
+                $subcategory = get_record('course_categories', 'id', $showsubcategory);
+                $visible = 1;
+            }
+
+            if ($subcategory) {
+                $subcategorycontext = get_context_instance(CONTEXT_COURSECAT, $subcategory->id);
+                require_capability('moodle/category:manage', $subcategorycontext);
+                if (!set_field('course_categories', 'visible', $visible, 'id', $subcategory->id)) {
+                    notify('Could not update that course!');
+                }
+            }
+        }
 
-    if(!empty($CFG->allowcategorythemes) && isset($category->theme)) {
+    /// Move a sub-category up or down
+        if ((!empty($movecategoryup) or !empty($movecategorydown)) and confirm_sesskey()) {
+            require_capability('moodle/category:manage', $context);
+            if ($subcategories = get_records('course_categories', 'parent', $category->id, 'sortorder ASC')) {
+                // move it off the range
+                $count = 2;
+                begin_sql();
+                foreach ($subcategories as $subcategory) {
+                    set_field('course_categories', 'sortorder', $count * 2, 'id', $subcategory->id);
+                    if (!empty($movecategoryup) && ($subcategory->id == $movecategoryup)) {
+                        set_field('course_categories', 'sortorder', $count * 2 - 3, 'id', $subcategory->id);
+                    } elseif (!empty($movecategorydown) && ($subcategory->id == $movecategorydown)) {
+                        set_field('course_categories', 'sortorder', $count * 2 + 3, 'id', $subcategory->id);
+                    } else {
+                        set_field('course_categories', 'sortorder', $count * 2, 'id', $subcategory->id);
+                    }
+                    $count++;
+                }
+                commit_sql();
+            }
+        }
+
+    } // End of subcategory editing
+
+if(!empty($CFG->allowcategorythemes) && isset($category->theme)) {
         // specifying theme here saves us some dbqs
         theme_setup($category->theme);
     }
@@ -232,10 +294,6 @@
         $options = array('id' => $category->id);
         print_single_button($CFG->wwwroot.'/course/editcategory.php', $options, get_string('editcategorythis'), 'get');
 
-        // Print button for creating new categories
-        $options = array('parent' => $category->id);
-        print_single_button($CFG->wwwroot.'/course/editcategory.php', $options, get_string('addsubcategory'), 'get');
-
         // Print button to delete this category
         $options = array('id' => $category->id);
         print_single_button($CFG->wwwroot.'/course/deletecategory.php', $options, get_string('deletecategorythis'), 'get');
@@ -245,28 +303,136 @@
 
 /// 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 || has_capability('moodle/category:viewhiddencategories', $context)) {
-                $subcategorieswereshown = true;
-                if ($firstentry) {
-                    echo '<table border="0" cellspacing="2" cellpadding="4" class="generalbox boxaligncenter">';
-                    echo '<tr><th scope="col">'.get_string('subcategories').'</th></tr>';
+        if (!$editingon) {
+        //display simply sub-categories list
+            $firstentry = true;
+            foreach ($subcategories as $subcategory) {
+                if ($subcategory->visible || has_capability('moodle/category:viewhiddencategories', $context)) {
+                    $subcategorieswereshown = true;
+                    if ($firstentry) {
+                        echo '<table border="0" cellspacing="2" cellpadding="4" class="generalbox boxaligncenter">';
+                        echo '<tr><th scope="col">'.get_string('subcategories').'</th></tr>';
+                        echo '<tr><td style="white-space: nowrap">';
+                        $firstentry = false;
+                    }
+                    $catlinkcss = $subcategory->visible ? '' : 'class="dimmed" ';
+                    echo '<a '.$catlinkcss.' href="category.php?id='.$subcategory->id.'">'.
+                         format_string($subcategory->name).'</a><br />';
+                }
+            }
+            if (!$firstentry) {
+                echo '</td></tr></table>';
+                echo '<br />';
+            }
+        } else {
+            // display tho-column sub-categories list with editing buttons in second column
+            $firstentry = true;
+            $count=0;
+            $numcategories=count($subcategories);
+            foreach ($subcategories as $subcategory) {
+                $count++;
+                $up = ($count > 1);
+                $down = ($count < $numcategories);
+                if ($subcategory->visible || has_capability('moodle/category:viewhiddencategories', $context)) {
+                    $subcategorieswereshown = true;
+                    if ($firstentry) {
+                        echo '<table border="0" cellspacing="2" cellpadding="4" class="generalbox boxaligncenter">';
+                        echo '<tr><th class="header" scope="col">'.get_string('subcategories').'</th>';
+                        echo '<th class="header" scope="col">'.get_string('edit').'</th></tr>';
+                        $firstentry = false;
+                    }
                     echo '<tr><td style="white-space: nowrap">';
-                    $firstentry = false;
+                    $catlinkcss = $subcategory->visible ? '' : 'class="dimmed" ';
+                    echo '<a '.$catlinkcss.' href="category.php?id='.$subcategory->id.'">'.
+                         format_string($subcategory->name).'</a>';
+                    echo '</td><td>';
+                    
+                    $subcategorycontext = get_context_instance(CONTEXT_COURSECAT, $subcategory->id);
+                    $spacer = '<img src="'.$CFG->wwwroot.'/pix/spacer.gif" class="iconsmall" alt="" /> ';
+
+                    if (has_capability('moodle/category:manage', $subcategorycontext)) {
+                        echo '<a title="'.get_string('edit').'" href="'.$CFG->wwwroot.'/course/editcategory.php?id='.$subcategory->id.'">'.
+                                '<img src="'.$CFG->pixpath.'/t/edit.gif" class="iconsmall" alt="'.get_string('edit').'" /></a> ';
+                    } else {
+                        echo $spacer;
+                    }
+
+                    if (has_capability('moodle/role:assign', $subcategorycontext)) {
+                        echo '<a title="'.get_string('assignroles', 'role').'" href="'.$CFG->wwwroot.'/'.$CFG->admin.'/roles/assign.php?contextid='.$subcategorycontext->id.'">'.
+                                '<img src="'.$CFG->pixpath.'/i/roles.gif" class="iconsmall" alt="'.get_string('assignroles', 'role').'" /></a> ';
+                    } else {
+                        echo $spacer;
+                    }
+
+                    $childcat = get_child_categories($subcategory->id);
+                    $courses =  get_courses($subcategory->id);
+                    if (has_capability('moodle/category:manage', $context) && has_capability('moodle/category:manage', $subcategorycontext) &&
+                        empty($childcat) && empty($courses)) {
+                        echo '<a title="'.get_string('delete').'" href="deletecategory.php?id='.$subcategory->id.'">'.
+                                '<img src="'.$CFG->pixpath.'/t/delete.gif" class="iconsmall" alt="'.get_string('delete').'" /></a> ';
+                    } else {
+                        echo $spacer;
+                    }
+
+                    if (has_capability('moodle/category:viewhiddencategories', $context) && has_capability('moodle/category:manage', $subcategorycontext)) {
+                        if ($subcategory->visible) {
+                            echo '<a title="'.get_string('hide').'" href="category.php?id='.$category->id.'&amp;page='.$page.
+                                '&amp;perpage='.$perpage.'&amp;hidesubcategory='.$subcategory->id.'&amp;sesskey='.$USER->sesskey.'">'.
+                                '<img src="'.$CFG->pixpath.'/t/hide.gif" class="iconsmall" alt="'.get_string('hide').'" /></a> ';
+                        } else {
+                            echo '<a title="'.get_string('show').'" href="category.php?id='.$category->id.'&amp;page='.$page.
+                                '&amp;perpage='.$perpage.'&amp;showsubcategory='.$subcategory->id.'&amp;sesskey='.$USER->sesskey.'">'.
+                                '<img src="'.$CFG->pixpath.'/t/show.gif" class="iconsmall" alt="'.get_string('show').'" /></a> ';
+                        }
+                    } else {
+                        echo $spacer;
+                    }
+
+                    if (has_capability('moodle/category:manage', $context)) {
+                        if ($up) {
+                            echo '<a title="'.get_string('moveup').'" href="category.php?id='.$category->id.'&amp;page='.$page.
+                                 '&amp;perpage='.$perpage.'&amp;movecategoryup='.$subcategory->id.'&amp;sesskey='.$USER->sesskey.'">'.
+                                 '<img src="'.$CFG->pixpath.'/t/up.gif" class="iconsmall" alt="'.get_string('moveup').'" /></a> ';
+                        } else {
+                            echo $spacer;
+                        }
+
+                        if ($down) {
+                            echo '<a title="'.get_string('movedown').'" href="category.php?id='.$category->id.'&amp;page='.$page.
+                                 '&amp;perpage='.$perpage.'&amp;movecategorydown='.$subcategory->id.'&amp;sesskey='.$USER->sesskey.'">'.
+                                 '<img src="'.$CFG->pixpath.'/t/down.gif" class="iconsmall" alt="'.get_string('movedown').'" /></a> ';
+                        } else {
+                            echo $spacer;
+                        }
+                    } else {
+                        echo $spacer, $spacer;
+                    }
+
+                    echo '</td></tr>';
                 }
-                $catlinkcss = $subcategory->visible ? '' : 'class="dimmed" ';
-                echo '<a '.$catlinkcss.' href="category.php?id='.$subcategory->id.'">'.
-                     format_string($subcategory->name).'</a><br />';
+            }
+            if (!$firstentry) {
+                echo '</table>';
             }
         }
-        if (!$firstentry) {
-            echo '</td></tr></table>';
-            echo '<br />';
-        }
-    }
+        
+    }/// end of sub-categories form
 
+    if (has_capability('moodle/category:manage', $context)) {
+        echo '<div class="buttons">';
+        $numcategories=count($subcategories);
+        if ($numcategories > 1) {
+            unset($options);
+            $options['id'] = $category->id;
+            $options['resortsubcategories'] = 'name';
+            $options['sesskey'] = $USER->sesskey;
+            print_single_button('category.php', $options, get_string('resortcategoriesbyname'), 'get');
+        }
 
+        $options = array('parent' => $category->id);
+        print_single_button($CFG->wwwroot.'/course/editcategory.php', $options, get_string('addsubcategory'), 'get');
+        echo '</div>';
+    }
 /// Print out all the courses
     $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',
diff --git a/lang/en_utf8/moodle.php b/lang/en_utf8/moodle.php
index 1ae46f6..e592f7f 100644
--- a/lang/en_utf8/moodle.php
+++ b/lang/en_utf8/moodle.php
@@ -1305,6 +1305,7 @@ $string['resetcourse'] = 'Reset course';
 $string['resetinfo'] = 'This page allows you to empty a course of user data, while retaining the activities and other settings.  Please be warned that by choosing items below and submitting this page you will delete your chosen user data from this course forever!';
 $string['resetstartdate'] = 'Reset start date';
 $string['resettodefaults'] = 'Reset to defaults';
+$string['resortcategoriesbyname'] = 'Re-sort sub-categories by name';
 $string['resortcoursesbyname'] = 'Re-sort courses by name';
 $string['resource'] = 'Resource';
 $string['resources'] = 'Resources';
-- 
1.6.5.1.1367.gcd48