chamilo / chamilo-lms

main/inc/lib/course_category.lib.php

Spacing +32 added lines, -34 removed lines

@@ -68,7 +68,7 @@ 
 
     $parentIdCondition = " AND (t1.parent_id IS NULL OR t1.parent_id = '' )";
     if (!empty($category)) {
-        $parentIdCondition =  " AND t1.parent_id  = '$category' ";
+        $parentIdCondition = " AND t1.parent_id  = '$category' ";
     }
 
     $sql = "SELECT
@@ -99,7 +99,7 @@ 
 
     $categories = Database::store_result($result);
     foreach ($categories as $category) {
-        $category['nbr_courses'] =  1;
+        $category['nbr_courses'] = 1;
     }
 
     return $categories;
@@ -196,13 +196,13 @@ 
     if ($row = Database::fetch_array($result)) {
         if (!empty($row['parent_id'])) {
             Database::query("UPDATE $tbl_course SET category_code = '".$row['parent_id']."' WHERE category_code='$node'");
-            Database::query("UPDATE $tbl_category SET parent_id='" . $row['parent_id'] . "' WHERE parent_id='$node'");
+            Database::query("UPDATE $tbl_category SET parent_id='".$row['parent_id']."' WHERE parent_id='$node'");
         } else {
             Database::query("UPDATE $tbl_course SET category_code='' WHERE category_code='$node'");
             Database::query("UPDATE $tbl_category SET parent_id=NULL WHERE parent_id='$node'");
         }
 
-        Database::query("UPDATE $tbl_category SET tree_pos=tree_pos-1 WHERE tree_pos > '" . $row['tree_pos'] . "'");
+        Database::query("UPDATE $tbl_category SET tree_pos=tree_pos-1 WHERE tree_pos > '".$row['tree_pos']."'");
         Database::query("DELETE FROM $tbl_category WHERE code='$node'");
 
         if (!empty($row['parent_id'])) {
@@ -291,13 +291,13 @@ 
     }
 
     $sql = "UPDATE $tbl_category
-            SET tree_pos ='" . $row['tree_pos'] . "'
+            SET tree_pos ='".$row['tree_pos']."'
             WHERE code='$code'";
     Database::query($sql);
 
     $sql = "UPDATE $tbl_category
             SET tree_pos = '$tree_pos'
-            WHERE code= '" . $row['code'] . "'";
+            WHERE code= '".$row['code']."'";
     Database::query($sql);
 
     return true;
@@ -424,12 +424,12 @@ 
 
         $editIcon = Display::return_icon('edit.png', get_lang('EditNode'), null, ICON_SIZE_SMALL);
         $deleteIcon = Display::return_icon('delete.png', get_lang('DeleteNode'), null, ICON_SIZE_SMALL);
-        $moveIcon =  Display::return_icon('up.png', get_lang('UpInSameLevel'), null, ICON_SIZE_SMALL);
+        $moveIcon = Display::return_icon('up.png', get_lang('UpInSameLevel'), null, ICON_SIZE_SMALL);
 
         foreach ($categories as $category) {
 
             $editUrl = $mainUrl.'&id='.$category['code'].'&action=edit';
-            $moveUrl  = $mainUrl.'&id='.$category['code'].'&action=moveUp&tree_pos='.$category['tree_pos'];
+            $moveUrl = $mainUrl.'&id='.$category['code'].'&action=moveUp&tree_pos='.$category['tree_pos'];
             $deleteUrl = $mainUrl.'&id='.$category['code'].'&action=delete';
 
             $actions = Display::url($editIcon, $editUrl).Display::url($moveIcon, $moveUrl).Display::url($deleteIcon, $deleteUrl);
@@ -563,12 +563,12 @@ 
 
     $count_courses = countCoursesInCategory();
 
-    $categories[0][count($categories[0])+1] = array(
+    $categories[0][count($categories[0]) + 1] = array(
         'id' =>0,
         'name' => get_lang('None'),
         'code' => 'NONE',
         'parent_id' => null,
-        'tree_pos' => $row['tree_pos']+1,
+        'tree_pos' => $row['tree_pos'] + 1,
         'children_count' => 0,
         'auth_course_child' => true,
         'auth_cat_child' => true,
@@ -583,7 +583,7 @@ 
  * @param string $searchTerm
  * @return int
  */
-function countCoursesInCategory($category_code="", $searchTerm = '')
+function countCoursesInCategory($category_code = "", $searchTerm = '')
 {
     $tbl_course = Database::get_main_table(TABLE_MAIN_COURSE);
     $categoryCode = Database::escape_string($category_code);
@@ -595,7 +595,7 @@ 
 
     $without_special_courses = '';
     if (!empty($specialCourseList)) {
-        $without_special_courses = ' AND course.code NOT IN ("' . implode('","', $specialCourseList) . '")';
+        $without_special_courses = ' AND course.code NOT IN ("'.implode('","', $specialCourseList).'")';
     }
 
     $visibilityCondition = null;
@@ -609,15 +609,15 @@ 
     if ($categoryCode == 'ALL') {
         // Nothing to do
     } elseif ($categoryCode == 'NONE') {
-        $categoryFilter =  ' AND category_code = "" ';
+        $categoryFilter = ' AND category_code = "" ';
     } else {
-        $categoryFilter =  ' AND category_code = "' . $categoryCode . '" ';
+        $categoryFilter = ' AND category_code = "'.$categoryCode.'" ';
     }
 
     if (!empty($searchTerm)) {
-        $searchFilter = ' AND (code LIKE "%' . $searchTerm . '%"
-            OR title LIKE "%' . $searchTerm . '%"
-            OR tutor_name LIKE "%' . $searchTerm . '%") ';
+        $searchFilter = ' AND (code LIKE "%'.$searchTerm.'%"
+            OR title LIKE "%' . $searchTerm.'%"
+            OR tutor_name LIKE "%' . $searchTerm.'%") ';
     }
 
     $sql = "SELECT * FROM $tbl_course
@@ -668,7 +668,7 @@ 
 
     $without_special_courses = '';
     if (!empty($specialCourseList)) {
-        $without_special_courses = ' AND course.code NOT IN ("' . implode('","', $specialCourseList) . '")';
+        $without_special_courses = ' AND course.code NOT IN ("'.implode('","', $specialCourseList).'")';
     }
     $visibilityCondition = null;
     $hidePrivate = api_get_setting('course_catalog_hide_private');
@@ -716,7 +716,7 @@ 
         $id_in = null;
         while (list($id) = Database::fetch_row($result)) {
             if ($id_in) {
-                $id_in.=",$id";
+                $id_in .= ",$id";
             } else {
                 $id_in = "$id";
             }
@@ -937,11 +937,9 @@ 
 function getLimitArray()
 {
     $pageCurrent = isset($_REQUEST['pageCurrent']) ?
-        intval($_GET['pageCurrent']) :
-        1;
+        intval($_GET['pageCurrent']) : 1;
     $pageLength = isset($_REQUEST['pageLength']) ?
-        intval($_GET['pageLength']) :
-        10;
+        intval($_GET['pageLength']) : 10;
     return array(
         'start' => ($pageCurrent - 1) * $pageLength,
         'current' => $pageCurrent,
@@ -960,7 +958,7 @@ 
     if (!empty($limit) && is_array($limit)) {
         $limitStart = isset($limit['start']) ? $limit['start'] : 0;
         $limitLength = isset($limit['length']) ? $limit['length'] : 10;
-        $limitFilter = 'LIMIT ' . $limitStart . ', ' . $limitLength;
+        $limitFilter = 'LIMIT '.$limitStart.', '.$limitLength;
     }
 
     return $limitFilter;
@@ -977,7 +975,7 @@ 
 {
     // Start empty html
     $pageDiv = '';
-    $html='';
+    $html = '';
     $pageBottom = max(1, $pageCurrent - 3);
     $pageTop = min($pageTotal, $pageCurrent + 3);
 
@@ -1052,21 +1050,21 @@ 
     $hiddenLinks = isset($hiddenLinks) ? Security::remove_XSS($hiddenLinksRequest) : $categoryCodeRequest;
 
         // Start URL with params
-    $pageUrl = api_get_self() .
-        '?action=' . $action .
-        '&category_code=' .$categoryCode.
-        '&hidden_links=' .$hiddenLinks.
-        '&pageCurrent=' . $pageCurrent .
-        '&pageLength=' . $pageLength
+    $pageUrl = api_get_self().
+        '?action='.$action.
+        '&category_code='.$categoryCode.
+        '&hidden_links='.$hiddenLinks.
+        '&pageCurrent='.$pageCurrent.
+        '&pageLength='.$pageLength
     ;
 
     switch ($action) {
         case 'subscribe' :
             // for search
             $pageUrl .=
-                '&search_term=' . $searchTerm .
-                '&search_course=1' .
-                '&sec_token=' . $_SESSION['sec_token'];
+                '&search_term='.$searchTerm.
+                '&search_course=1'.
+                '&sec_token='.$_SESSION['sec_token'];
             break;
         case 'display_courses' :
             // No break