chamilo / chamilo-lms

main/inc/lib/app_view.php

Spacing +4 added lines, -4 removed lines

@@ -16,7 +16,7 @@ 
      * @param string  tool name (optional)
      * @param string $template_path
      */
-    public function __construct($toolname = '', $template_path=null)
+    public function __construct($toolname = '', $template_path = null)
     {
         if (!empty($toolname)) {
             if (isset($template_path)) {
@@ -27,7 +27,7 @@ 
             if (is_dir($path)) {
                 $this->tool_path = $path;
             } else {
-                throw new Exception('View::__construct() $path directory does not exist ' . $path);
+                throw new Exception('View::__construct() $path directory does not exist '.$path);
             }
         }
     }
@@ -39,7 +39,7 @@ 
     public function set_data($data)
     {
         if (!is_array($data)) {
-            throw new Exception('View::set_data() $data must to be an array, you have sent a' . gettype( $data ));
+            throw new Exception('View::set_data() $data must to be an array, you have sent a'.gettype($data));
         }
         $this->data = $data;
     }
@@ -49,7 +49,7 @@ 
      * @param string layout view
      * @param string $layout
      */
-    public function set_layout( $layout )
+    public function set_layout($layout)
     {
         $this->layout = $layout;
     }

main/inc/lib/auth.lib.php

Doc Comments +8 added lines

@@ -183,6 +183,7 @@ 
      * (moving a course to a different course category)
      * @param  int    $courseId
      * @param  int       Category id
+     * @param integer $newcategory
      * @return bool      True if it success
      */
     public function updateCourseCategory($courseId, $newcategory)
@@ -215,6 +216,9 @@ 
      * @param   string    Direction (up/down)
      * @param   string    Course code
      * @param   int       Category id
+     * @param string $direction
+     * @param string $course2move
+     * @param integer $category
      * @return  bool      True if it success
      */
     public function move_course($direction, $course2move, $category)
@@ -285,6 +289,8 @@ 
      * Moves the course one place up or down
      * @param string    Direction up/down
      * @param string    Category id
+     * @param string $direction
+     * @param integer $category2move
      * @return bool     True If it success
      */
     public function move_category($direction, $category2move)
@@ -348,6 +354,8 @@ 
      * Updates the user course category in the chamilo_user database
      * @param   string  Category title
      * @param   int     Category id
+     * @param string $title
+     * @param integer $category_id
      * @return  bool    True if it success
      */
     public function store_edit_course_category($title, $category_id)

Spacing +48 added lines, -48 removed lines

@@ -48,12 +48,12 @@ 
         $special_course_list = array();
         if (Database::num_rows($result) > 0) {
             while ($result_row = Database::fetch_array($result)) {
-                $special_course_list[] = '"' . $result_row['item_id'] . '"';
+                $special_course_list[] = '"'.$result_row['item_id'].'"';
             }
         }
         $without_special_courses = '';
         if (!empty($special_course_list)) {
-            $without_special_courses = ' AND course.id NOT IN (' . implode(',', $special_course_list) . ')';
+            $without_special_courses = ' AND course.id NOT IN ('.implode(',', $special_course_list).')';
         }
 
         // Secondly we select the courses that are in a category (user_course_cat<>0) and sort these according to the sort of the category
@@ -73,8 +73,8 @@ 
                 FROM $TABLECOURS course, $TABLECOURSUSER  course_rel_user
                 WHERE
                     course.id = course_rel_user.c_id AND
-                    course_rel_user.relation_type<>" . COURSE_RELATION_TYPE_RRHH . " AND
-                    course_rel_user.user_id = '" . $user_id . "' $without_special_courses
+                    course_rel_user.relation_type<>".COURSE_RELATION_TYPE_RRHH." AND
+                    course_rel_user.user_id = '" . $user_id."' $without_special_courses
                 ORDER BY course_rel_user.sort ASC";
         $result = Database::query($sql);
         $courses = array();
@@ -106,7 +106,7 @@ 
     {
         $user_id = api_get_user_id();
         $table_category = Database::get_main_table(TABLE_USER_COURSE_CATEGORY);
-        $sql = "SELECT * FROM " . $table_category . "
+        $sql = "SELECT * FROM ".$table_category."
                 WHERE user_id=$user_id
                 ORDER BY sort ASC";
         $result = Database::query($sql);
@@ -148,13 +148,13 @@ 
         $special_course_list = array();
         if (Database::num_rows($result) > 0) {
             while ($result_row = Database::fetch_array($result)) {
-                $special_course_list[] = '"' . $result_row['item_id'] . '"';
+                $special_course_list[] = '"'.$result_row['item_id'].'"';
             }
         }
 
         $without_special_courses = '';
         if (!empty($special_course_list)) {
-            $without_special_courses = ' AND course.id NOT IN (' . implode(',', $special_course_list) . ')';
+            $without_special_courses = ' AND course.id NOT IN ('.implode(',', $special_course_list).')';
         }
 
         $sql = "SELECT
@@ -165,8 +165,8 @@ 
                 $TABLECOURSUSER  course_rel_user
                 WHERE
                     course.id = course_rel_user.c_id AND
-                    course_rel_user.user_id = '" . $user_id . "' AND
-                    course_rel_user.relation_type <> " . COURSE_RELATION_TYPE_RRHH . "
+                    course_rel_user.user_id = '".$user_id."' AND
+                    course_rel_user.relation_type <> " . COURSE_RELATION_TYPE_RRHH."
                     $without_special_courses
                 ORDER BY course_rel_user.user_course_cat, course_rel_user.sort ASC";
         $result = Database::query($sql);
@@ -194,11 +194,11 @@ 
         $TABLECOURSUSER = Database::get_main_table(TABLE_MAIN_COURSE_USER);
         $max_sort_value = api_max_sort_value($newcategory, $current_user);
         $sql = "UPDATE $TABLECOURSUSER SET
-                    user_course_cat='" . $newcategory . "',
-                    sort='" . ($max_sort_value + 1) . "'
+                    user_course_cat='".$newcategory."',
+                    sort='" . ($max_sort_value + 1)."'
                 WHERE
-                    c_id ='" . $courseId . "' AND
-                    user_id='" . $current_user . "' AND
+                    c_id ='" . $courseId."' AND
+                    user_id='" . $current_user."' AND
                     relation_type<>" . COURSE_RELATION_TYPE_RRHH;
         $resultQuery = Database::query($sql);
 
@@ -257,18 +257,18 @@ 
             $targetCourseId = $targetCourseInfo['real_id'];
 
             $sql = "UPDATE $table
-                    SET sort='" . $target_course['sort'] . "'
+                    SET sort='".$target_course['sort']."'
                     WHERE
-                        c_id = '" . $courseId . "' AND
-                        user_id = '" . $current_user_id . "' AND
+                        c_id = '" . $courseId."' AND
+                        user_id = '" . $current_user_id."' AND
                         relation_type<>" . COURSE_RELATION_TYPE_RRHH;
 
             $result1 = Database::query($sql);
 
-            $sql = "UPDATE $table SET sort='" . $source_course['sort'] . "'
+            $sql = "UPDATE $table SET sort='".$source_course['sort']."'
                     WHERE
-                        c_id ='" . $targetCourseId . "' AND
-                        user_id='" . $current_user_id . "' AND
+                        c_id ='" . $targetCourseId."' AND
+                        user_id='" . $current_user_id."' AND
                         relation_type<>" . COURSE_RELATION_TYPE_RRHH;
 
             $result2 = Database::query($sql);
@@ -312,10 +312,10 @@ 
         }
 
         if (count($target_category) > 0 && count($source_category) > 0) {
-            $sql_update1 = "UPDATE $table_user_defined_category SET sort='" . Database::escape_string($target_category['sort']) . "'
-                            WHERE id='" . intval($source_category['id']) . "' AND user_id='" . $current_user_id . "'";
-            $sql_update2 = "UPDATE $table_user_defined_category SET sort='" . Database::escape_string($source_category['sort']) . "'
-                            WHERE id='" . intval($target_category['id']) . "' AND user_id='" . $current_user_id . "'";
+            $sql_update1 = "UPDATE $table_user_defined_category SET sort='".Database::escape_string($target_category['sort'])."'
+                            WHERE id='" . intval($source_category['id'])."' AND user_id='".$current_user_id."'";
+            $sql_update2 = "UPDATE $table_user_defined_category SET sort='".Database::escape_string($source_category['sort'])."'
+                            WHERE id='" . intval($target_category['id'])."' AND user_id='".$current_user_id."'";
 
             $result1 = Database::query($sql_update2);
             $result2 = Database::query($sql_update1);
@@ -334,8 +334,8 @@ 
     {
         $current_user_id = api_get_user_id();
         $table_category = Database::get_main_table(TABLE_USER_COURSE_CATEGORY);
-        $sql = "SELECT * FROM " . $table_category . "
-                WHERE user_id='" . $current_user_id . "'
+        $sql = "SELECT * FROM ".$table_category."
+                WHERE user_id='" . $current_user_id."'
                 ORDER BY sort ASC";
         $result = Database::query($sql);
         while ($row = Database::fetch_array($result)) {
@@ -358,8 +358,8 @@ 
         $result = false;
         $tucc = Database::get_main_table(TABLE_USER_COURSE_CATEGORY);
         $sql = "UPDATE $tucc
-                SET title='" . api_htmlentities($title, ENT_QUOTES, api_get_system_encoding()) . "'
-                WHERE id='" . $category_id . "'";
+                SET title='".api_htmlentities($title, ENT_QUOTES, api_get_system_encoding())."'
+                WHERE id='" . $category_id."'";
         $resultQuery = Database::query($sql);
         if (Database::affected_rows($resultQuery)) {
             $result = true;
@@ -381,8 +381,8 @@ 
         $result = false;
         $sql = "DELETE FROM $tucc
                 WHERE 
-                    id='" . $category_id . "' AND 
-                    user_id='" . $current_user_id . "'";
+                    id='".$category_id."' AND 
+                    user_id='" . $current_user_id."'";
         $resultQuery = Database::query($sql);
        if (Database::affected_rows($resultQuery)) {
             $result = true;
@@ -390,9 +390,9 @@ 
         $sql = "UPDATE $TABLECOURSUSER
                 SET user_course_cat='0'
                 WHERE
-                    user_course_cat='" . $category_id . "' AND
-                    user_id='" . $current_user_id . "' AND
-                    relation_type<>" . COURSE_RELATION_TYPE_RRHH . " ";
+                    user_course_cat='".$category_id."' AND
+                    user_id='" . $current_user_id."' AND
+                    relation_type<>" . COURSE_RELATION_TYPE_RRHH." ";
         Database::query($sql);
 
         return $result;
@@ -426,12 +426,12 @@ 
         if (Database::num_rows($special_course_result) > 0) {
             $special_course_list = array();
             while ($result_row = Database::fetch_array($special_course_result)) {
-                $special_course_list[] = '"' . $result_row['item_id'] . '"';
+                $special_course_list[] = '"'.$result_row['item_id'].'"';
             }
         }
         $without_special_courses = '';
         if (!empty($special_course_list)) {
-            $without_special_courses = ' AND course.code NOT IN (' . implode(',', $special_course_list) . ')';
+            $without_special_courses = ' AND course.code NOT IN ('.implode(',', $special_course_list).')';
         }
 
         $visibilityCondition = $justVisible ? CourseManager::getCourseVisibilitySQLCondition('course') : '';
@@ -439,9 +439,9 @@ 
         $search_term_safe = Database::escape_string($search_term);
         $sql_find = "SELECT * FROM $courseTable
                     WHERE (
-                            code LIKE '%" . $search_term_safe . "%' OR
-                            title LIKE '%" . $search_term_safe . "%' OR
-                            tutor_name LIKE '%" . $search_term_safe . "%'
+                            code LIKE '%".$search_term_safe."%' OR
+                            title LIKE '%" . $search_term_safe."%' OR
+                            tutor_name LIKE '%" . $search_term_safe."%'
                         )
                         $without_special_courses
                         $visibilityCondition
@@ -459,9 +459,9 @@ 
                             ON (url_rel_course.c_id = course.id)
                             WHERE
                                 access_url_id = $url_access_id AND (
-                                    code LIKE '%" . $search_term_safe . "%' OR
-                                    title LIKE '%" . $search_term_safe . "%' OR
-                                    tutor_name LIKE '%" . $search_term_safe . "%'
+                                    code LIKE '%".$search_term_safe."%' OR
+                                    title LIKE '%" . $search_term_safe."%' OR
+                                    tutor_name LIKE '%" . $search_term_safe."%'
                                 )
                                 $without_special_courses
                                 $visibilityCondition
@@ -523,8 +523,8 @@ 
         // (s)he can only delete the course
         $sql = "SELECT * FROM $tbl_course_user
                 WHERE
-                    user_id='" . $current_user_id . "' AND
-                    c_id ='" . $courseId . "' AND
+                    user_id='".$current_user_id."' AND
+                    c_id ='" . $courseId."' AND
                     status='1' ";
         $result_check = Database::query($sql);
         $number_of_rows = Database::num_rows($result_check);
@@ -553,7 +553,7 @@ 
 
         // step 1: we determine the max value of the user defined course categories
         $sql = "SELECT sort FROM $tucc 
-                WHERE user_id='" . $current_user_id . "' 
+                WHERE user_id='".$current_user_id."' 
                 ORDER BY sort DESC";
         $rs_sort = Database::query($sql);
         $maxsort = Database::fetch_array($rs_sort);
@@ -562,13 +562,13 @@ 
         // step 2: we check if there is already a category with this name, if not we store it, else we give an error.
         $sql = "SELECT * FROM $tucc 
                 WHERE 
-                    user_id='" . $current_user_id . "' AND 
-                    title='" . $category_title . "'
+                    user_id='".$current_user_id."' AND 
+                    title='" . $category_title."'
                 ORDER BY sort DESC";
         $rs = Database::query($sql);
         if (Database::num_rows($rs) == 0) {
             $sql = "INSERT INTO $tucc (user_id, title,sort)
-                           VALUES ('" . $current_user_id . "', '" . api_htmlentities($category_title, ENT_QUOTES, api_get_system_encoding()) . "', '" . $nextsort . "')";
+                           VALUES ('".$current_user_id."', '".api_htmlentities($category_title, ENT_QUOTES, api_get_system_encoding())."', '".$nextsort."')";
             $resultQuery = Database::query($sql);
             if (Database::affected_rows($resultQuery)) {
                 $result = true;
@@ -652,10 +652,10 @@ 
             if (isset($_POST['course_registration_code']) && $_POST['course_registration_code'] != $all_course_information['registration_code']) {
                 return false;
             }
-            $message = get_lang('CourseRequiresPassword') . '<br />';
+            $message = get_lang('CourseRequiresPassword').'<br />';
             $message .= $all_course_information['title'].' ('.$all_course_information['visual_code'].') ';
 
-            $action  = api_get_path(WEB_CODE_PATH) . "auth/courses.php?action=subscribe_user_with_password&sec_token=" . $_SESSION['sec_token'];
+            $action  = api_get_path(WEB_CODE_PATH)."auth/courses.php?action=subscribe_user_with_password&sec_token=".$_SESSION['sec_token'];
             $form = new FormValidator('subscribe_user_with_password', 'post', $action);
             $form->addElement('hidden', 'sec_token', $_SESSION['sec_token']);
             $form->addElement('hidden', 'subscribe_user_with_password', $all_course_information['code']);

main/inc/lib/attendance.lib.php

Indentation +1695 added lines, -1695 removed lines

@@ -11,50 +11,50 @@ 
  */
 class Attendance
 {
-	private $session_id;
-	private $course_id;
-	private $date_time;
-	private $name;
-	private $description;
-	private $attendance_qualify_title;
-	private $attendance_weight;
-	private $course_int_id;
-	public $category_id;
-
-	// constants
-	const DONE_ATTENDANCE_LOG_TYPE = 'done_attendance_sheet';
-	const UPDATED_ATTENDANCE_LOG_TYPE = 'updated_attendance_sheet';
-	const LOCKED_ATTENDANCE_LOG_TYPE = 'locked_attendance_sheet';
-
-	/**
-	 * Constructor
-	 */
-	public function __construct()
-	{
-		//$this->course_int_id = api_get_course_int_id();
-	}
-
-	/**
-	 * Get the total number of attendance inside current course and current session
-	 * @see SortableTable#get_total_number_of_items()
-	 */
-	public static function get_number_of_attendances($active = -1)
-	{
-		$tbl_attendance = Database :: get_course_table(TABLE_ATTENDANCE);
-		$session_id = api_get_session_id();
-		$condition_session = api_get_session_condition($session_id);
-		$course_id = api_get_course_int_id();
-		$sql = "SELECT COUNT(att.id) AS total_number_of_items
+    private $session_id;
+    private $course_id;
+    private $date_time;
+    private $name;
+    private $description;
+    private $attendance_qualify_title;
+    private $attendance_weight;
+    private $course_int_id;
+    public $category_id;
+
+    // constants
+    const DONE_ATTENDANCE_LOG_TYPE = 'done_attendance_sheet';
+    const UPDATED_ATTENDANCE_LOG_TYPE = 'updated_attendance_sheet';
+    const LOCKED_ATTENDANCE_LOG_TYPE = 'locked_attendance_sheet';
+
+    /**
+     * Constructor
+     */
+    public function __construct()
+    {
+        //$this->course_int_id = api_get_course_int_id();
+    }
+
+    /**
+     * Get the total number of attendance inside current course and current session
+     * @see SortableTable#get_total_number_of_items()
+     */
+    public static function get_number_of_attendances($active = -1)
+    {
+        $tbl_attendance = Database :: get_course_table(TABLE_ATTENDANCE);
+        $session_id = api_get_session_id();
+        $condition_session = api_get_session_condition($session_id);
+        $course_id = api_get_course_int_id();
+        $sql = "SELECT COUNT(att.id) AS total_number_of_items
 				FROM $tbl_attendance att
 		        WHERE c_id = $course_id $condition_session ";
-		if ($active == 1 || $active == 0) {
-			$sql .= "AND att.active = $active";
-		}
-		$res = Database::query($sql);
-		$obj = Database::fetch_object($res);
+        if ($active == 1 || $active == 0) {
+            $sql .= "AND att.active = $active";
+        }
+        $res = Database::query($sql);
+        $obj = Database::fetch_object($res);
 
-		return $obj->total_number_of_items;
-	}
+        return $obj->total_number_of_items;
+    }
 
     /**
      * Get attendance list only the id, name and attendance_qualify_max fields
@@ -90,36 +90,36 @@ 
         return $data;
     }
 
-	/**
-	 * Get the attendaces to display on the current page (fill the sortable-table)
-	 * @param   int     offset of first user to recover
-	 * @param   int     Number of users to get
-	 * @param   int     Column to sort on
-	 * @param   string  Order (ASC,DESC)
-	 * @see SortableTable#get_table_data($from)
-	 */
-	public static function get_attendance_data($from, $number_of_items, $column, $direction)
-	{
-		$tbl_attendance = Database::get_course_table(TABLE_ATTENDANCE);
-		$course_id = api_get_course_int_id();
-		$session_id = api_get_session_id();
-		$condition_session = api_get_session_condition($session_id);
-		$column = intval($column);
-		$from = intval($from);
-		$number_of_items = intval($number_of_items);
-
-		if (!in_array($direction, array('ASC','DESC'))) {
-			$direction = 'ASC';
-		}
-
-		$active_plus = '';
-		if ((isset($_GET['isStudentView']) && $_GET['isStudentView'] == 'true') ||
-			!api_is_allowed_to_edit(null, true)
-		) {
-			$active_plus = ' AND att.active = 1';
-		}
-
-		$sql = "SELECT
+    /**
+     * Get the attendaces to display on the current page (fill the sortable-table)
+     * @param   int     offset of first user to recover
+     * @param   int     Number of users to get
+     * @param   int     Column to sort on
+     * @param   string  Order (ASC,DESC)
+     * @see SortableTable#get_table_data($from)
+     */
+    public static function get_attendance_data($from, $number_of_items, $column, $direction)
+    {
+        $tbl_attendance = Database::get_course_table(TABLE_ATTENDANCE);
+        $course_id = api_get_course_int_id();
+        $session_id = api_get_session_id();
+        $condition_session = api_get_session_condition($session_id);
+        $column = intval($column);
+        $from = intval($from);
+        $number_of_items = intval($number_of_items);
+
+        if (!in_array($direction, array('ASC','DESC'))) {
+            $direction = 'ASC';
+        }
+
+        $active_plus = '';
+        if ((isset($_GET['isStudentView']) && $_GET['isStudentView'] == 'true') ||
+            !api_is_allowed_to_edit(null, true)
+        ) {
+            $active_plus = ' AND att.active = 1';
+        }
+
+        $sql = "SELECT
                     att.id AS col0,
                     att.name AS col1,
                     att.description AS col2,
@@ -134,327 +134,327 @@ 
 				ORDER BY col$column $direction
 				LIMIT $from,$number_of_items ";
 
-		$res = Database::query($sql);
-		$attendances = array();
-		$user_info = api_get_user_info();
-		$allowDelete = api_get_setting('attendance.allow_delete_attendance');
-
-		while ($attendance = Database::fetch_row($res)) {
-			$student_param = '';
-			if (api_is_drh() && $_GET['student_id']) {
-				$student_param = '&student_id='.intval($_GET['student_id']);
-			}
-
-			$session_star = '';
-			if (api_get_session_id() == $attendance[6]) {
-				$session_star = api_get_session_image(api_get_session_id(), $user_info['status']);
-			}
-			if ($attendance[5] == 1) {
-				$isDrhOfCourse = CourseManager::isUserSubscribedInCourseAsDrh(
-					api_get_user_id(),
-					api_get_course_info()
-				);
-
-				if (api_is_allowed_to_edit(null, true) || $isDrhOfCourse) {
-					// Link to edit
-					$attendance[1] = '<a href="index.php?'.api_get_cidreq().'&action=attendance_sheet_list&attendance_id='.$attendance[0].$student_param.'">'.$attendance[1].'</a>'.$session_star;
-				} else {
-					// Link to view
-					$attendance[1] = '<a href="index.php?'.api_get_cidreq().'&action=attendance_sheet_list_no_edit&attendance_id='.$attendance[0].$student_param.'">'.$attendance[1].'</a>'.$session_star;
-				}
-			} else {
-				$attendance[1] = '<a class="muted" href="index.php?'.api_get_cidreq().'&action=attendance_sheet_list&attendance_id='.$attendance[0].$student_param.'">'.$attendance[1].'</a>'.$session_star;
-			}
-
-			if ($attendance[5] == 1) {
-				$attendance[3] = '<center>'.$attendance[3].'</center>';
-			} else {
-				$attendance[3] = '<center><span class="muted">'.$attendance[3].'</span></center>';
-			}
-
-			$attendance[3] = '<center>'.$attendance[3].'</center>';
-			if (api_is_allowed_to_edit(null, true)) {
-				$actions  = '';
-				$actions .= '<center>';
-
-				if (api_is_platform_admin()) {
-					$actions .= '<a href="index.php?'.api_get_cidreq().'&action=attendance_edit&attendance_id='.$attendance[0].'">'.
-						Display::return_icon('edit.png', get_lang('Edit'), array(), ICON_SIZE_SMALL).'</a>&nbsp;';
-					// Visible
-					if ($attendance[5] == 1) {
-						$actions .= '<a href="index.php?'.api_get_cidreq().'&action=attendance_set_invisible&attendance_id='.$attendance[0].'">'.
-							Display::return_icon('visible.png', get_lang('Hide'), array(), ICON_SIZE_SMALL).'</a>';
-					} else {
-						$actions .= '<a href="index.php?'.api_get_cidreq().'&action=attendance_set_visible&attendance_id='.$attendance[0].'">'.
-							Display::return_icon('invisible.png', get_lang('Show'), array(), ICON_SIZE_SMALL).'</a>';
-						$attendance[2] = '<span class="muted">'.$attendance[2].'</span>';
-					}
-					if ($allowDelete === 'true') {
-						$actions .= '<a href="index.php?' . api_get_cidreq() . '&action=attendance_delete&attendance_id=' . $attendance[0].'">' .
-							Display::return_icon('delete.png', get_lang('Delete'), array(), ICON_SIZE_SMALL) . '</a>';
-					}
-				} else {
-					$is_locked_attendance = self::is_locked_attendance($attendance[0]);
-					if ($is_locked_attendance) {
-						$actions .= Display::return_icon('edit_na.png', get_lang('Edit')).'&nbsp;';
-						$actions .= Display::return_icon('visible.png', get_lang('Hide'));
-					} else {
-						$actions .= '<a href="index.php?'.api_get_cidreq().'&action=attendance_edit&attendance_id='.$attendance[0].'">'.
-							Display::return_icon('edit.png', get_lang('Edit'), array(), ICON_SIZE_SMALL).'</a>&nbsp;';
-
-						if ($attendance[5] == 1) {
-							$actions .= ' <a href="index.php?'.api_get_cidreq().'&action=attendance_set_invisible&attendance_id='.$attendance[0].'">'.
-								Display::return_icon('visible.png', get_lang('Hide'), array(), ICON_SIZE_SMALL).'</a>';
-						} else {
-							$actions .= ' <a href="index.php?'.api_get_cidreq().'&action=attendance_set_visible&attendance_id='.$attendance[0].'">'.
-								Display::return_icon('invisible.png', get_lang('Show'), array(), ICON_SIZE_SMALL).'</a>';
-							$attendance[2] = '<span class="muted">'.$attendance[2].'</span>';
-						}
-						if ($allowDelete === 'true') {
-							$actions .= ' <a href="index.php?' . api_get_cidreq() . '&action=attendance_delete&attendance_id=' . $attendance[0].'">' .
-								Display::return_icon('delete.png', get_lang('Delete'), array(), ICON_SIZE_SMALL) . '</a>';
-						}
-					}
-				}
-
-				// display lock/unlock icon
-				$is_done_all_calendar = self::is_all_attendance_calendar_done($attendance[0]);
-
-				if ($is_done_all_calendar) {
-					$locked   = $attendance[4];
-					if ($locked == 0) {
-						if (api_is_platform_admin()) {
-							$message_alert = get_lang('AreYouSureToLockTheAttendance');
-						} else {
-							$message_alert = get_lang('UnlockMessageInformation');
-						}
-						$actions .= '&nbsp;<a onclick="javascript:if(!confirm(\''.$message_alert.'\')) return false;" href="index.php?'.api_get_cidreq().'&action=lock_attendance&attendance_id='.$attendance[0].'">'.
-								Display::return_icon('unlock.png', get_lang('LockAttendance')).'</a>';
-					} else {
-						if (api_is_platform_admin()) {
-							$actions .= '&nbsp;<a onclick="javascript:if(!confirm(\''.get_lang('AreYouSureToUnlockTheAttendance').'\')) return false;" href="index.php?'.api_get_cidreq().'&action=unlock_attendance&attendance_id='.$attendance[0].'">'.
-									Display::return_icon('locked.png', get_lang('UnlockAttendance')).'</a>';
-						} else {
-							$actions .= '&nbsp;'.Display::return_icon('locked_na.png', get_lang('LockedAttendance'));
-						}
-					}
-				}
-				$actions .= '</center>';
-
-				$attendances[] = array($attendance[0], $attendance[1], $attendance[2], $attendance[3],$actions);
-			} else {
-				$attendance[0] = '&nbsp;';
-				$attendances[] = array($attendance[0], $attendance[1], $attendance[2], $attendance[3]);
-			}
-		}
-
-		return $attendances;
-	}
-
-	/**
-	 * Get the attendances by id to display on the current page
-	 * @param  int     $attendance_id
-	 * @return array   attendance data
-	 */
-	public function get_attendance_by_id($attendance_id)
-	{
-		$tbl_attendance = Database :: get_course_table(TABLE_ATTENDANCE);
-		$attendance_id = intval($attendance_id);
-		$course_id = api_get_course_int_id();
-		$attendance_data = array();
-		$sql = "SELECT * FROM $tbl_attendance
+        $res = Database::query($sql);
+        $attendances = array();
+        $user_info = api_get_user_info();
+        $allowDelete = api_get_setting('attendance.allow_delete_attendance');
+
+        while ($attendance = Database::fetch_row($res)) {
+            $student_param = '';
+            if (api_is_drh() && $_GET['student_id']) {
+                $student_param = '&student_id='.intval($_GET['student_id']);
+            }
+
+            $session_star = '';
+            if (api_get_session_id() == $attendance[6]) {
+                $session_star = api_get_session_image(api_get_session_id(), $user_info['status']);
+            }
+            if ($attendance[5] == 1) {
+                $isDrhOfCourse = CourseManager::isUserSubscribedInCourseAsDrh(
+                    api_get_user_id(),
+                    api_get_course_info()
+                );
+
+                if (api_is_allowed_to_edit(null, true) || $isDrhOfCourse) {
+                    // Link to edit
+                    $attendance[1] = '<a href="index.php?'.api_get_cidreq().'&action=attendance_sheet_list&attendance_id='.$attendance[0].$student_param.'">'.$attendance[1].'</a>'.$session_star;
+                } else {
+                    // Link to view
+                    $attendance[1] = '<a href="index.php?'.api_get_cidreq().'&action=attendance_sheet_list_no_edit&attendance_id='.$attendance[0].$student_param.'">'.$attendance[1].'</a>'.$session_star;
+                }
+            } else {
+                $attendance[1] = '<a class="muted" href="index.php?'.api_get_cidreq().'&action=attendance_sheet_list&attendance_id='.$attendance[0].$student_param.'">'.$attendance[1].'</a>'.$session_star;
+            }
+
+            if ($attendance[5] == 1) {
+                $attendance[3] = '<center>'.$attendance[3].'</center>';
+            } else {
+                $attendance[3] = '<center><span class="muted">'.$attendance[3].'</span></center>';
+            }
+
+            $attendance[3] = '<center>'.$attendance[3].'</center>';
+            if (api_is_allowed_to_edit(null, true)) {
+                $actions  = '';
+                $actions .= '<center>';
+
+                if (api_is_platform_admin()) {
+                    $actions .= '<a href="index.php?'.api_get_cidreq().'&action=attendance_edit&attendance_id='.$attendance[0].'">'.
+                        Display::return_icon('edit.png', get_lang('Edit'), array(), ICON_SIZE_SMALL).'</a>&nbsp;';
+                    // Visible
+                    if ($attendance[5] == 1) {
+                        $actions .= '<a href="index.php?'.api_get_cidreq().'&action=attendance_set_invisible&attendance_id='.$attendance[0].'">'.
+                            Display::return_icon('visible.png', get_lang('Hide'), array(), ICON_SIZE_SMALL).'</a>';
+                    } else {
+                        $actions .= '<a href="index.php?'.api_get_cidreq().'&action=attendance_set_visible&attendance_id='.$attendance[0].'">'.
+                            Display::return_icon('invisible.png', get_lang('Show'), array(), ICON_SIZE_SMALL).'</a>';
+                        $attendance[2] = '<span class="muted">'.$attendance[2].'</span>';
+                    }
+                    if ($allowDelete === 'true') {
+                        $actions .= '<a href="index.php?' . api_get_cidreq() . '&action=attendance_delete&attendance_id=' . $attendance[0].'">' .
+                            Display::return_icon('delete.png', get_lang('Delete'), array(), ICON_SIZE_SMALL) . '</a>';
+                    }
+                } else {
+                    $is_locked_attendance = self::is_locked_attendance($attendance[0]);
+                    if ($is_locked_attendance) {
+                        $actions .= Display::return_icon('edit_na.png', get_lang('Edit')).'&nbsp;';
+                        $actions .= Display::return_icon('visible.png', get_lang('Hide'));
+                    } else {
+                        $actions .= '<a href="index.php?'.api_get_cidreq().'&action=attendance_edit&attendance_id='.$attendance[0].'">'.
+                            Display::return_icon('edit.png', get_lang('Edit'), array(), ICON_SIZE_SMALL).'</a>&nbsp;';
+
+                        if ($attendance[5] == 1) {
+                            $actions .= ' <a href="index.php?'.api_get_cidreq().'&action=attendance_set_invisible&attendance_id='.$attendance[0].'">'.
+                                Display::return_icon('visible.png', get_lang('Hide'), array(), ICON_SIZE_SMALL).'</a>';
+                        } else {
+                            $actions .= ' <a href="index.php?'.api_get_cidreq().'&action=attendance_set_visible&attendance_id='.$attendance[0].'">'.
+                                Display::return_icon('invisible.png', get_lang('Show'), array(), ICON_SIZE_SMALL).'</a>';
+                            $attendance[2] = '<span class="muted">'.$attendance[2].'</span>';
+                        }
+                        if ($allowDelete === 'true') {
+                            $actions .= ' <a href="index.php?' . api_get_cidreq() . '&action=attendance_delete&attendance_id=' . $attendance[0].'">' .
+                                Display::return_icon('delete.png', get_lang('Delete'), array(), ICON_SIZE_SMALL) . '</a>';
+                        }
+                    }
+                }
+
+                // display lock/unlock icon
+                $is_done_all_calendar = self::is_all_attendance_calendar_done($attendance[0]);
+
+                if ($is_done_all_calendar) {
+                    $locked   = $attendance[4];
+                    if ($locked == 0) {
+                        if (api_is_platform_admin()) {
+                            $message_alert = get_lang('AreYouSureToLockTheAttendance');
+                        } else {
+                            $message_alert = get_lang('UnlockMessageInformation');
+                        }
+                        $actions .= '&nbsp;<a onclick="javascript:if(!confirm(\''.$message_alert.'\')) return false;" href="index.php?'.api_get_cidreq().'&action=lock_attendance&attendance_id='.$attendance[0].'">'.
+                                Display::return_icon('unlock.png', get_lang('LockAttendance')).'</a>';
+                    } else {
+                        if (api_is_platform_admin()) {
+                            $actions .= '&nbsp;<a onclick="javascript:if(!confirm(\''.get_lang('AreYouSureToUnlockTheAttendance').'\')) return false;" href="index.php?'.api_get_cidreq().'&action=unlock_attendance&attendance_id='.$attendance[0].'">'.
+                                    Display::return_icon('locked.png', get_lang('UnlockAttendance')).'</a>';
+                        } else {
+                            $actions .= '&nbsp;'.Display::return_icon('locked_na.png', get_lang('LockedAttendance'));
+                        }
+                    }
+                }
+                $actions .= '</center>';
+
+                $attendances[] = array($attendance[0], $attendance[1], $attendance[2], $attendance[3],$actions);
+            } else {
+                $attendance[0] = '&nbsp;';
+                $attendances[] = array($attendance[0], $attendance[1], $attendance[2], $attendance[3]);
+            }
+        }
+
+        return $attendances;
+    }
+
+    /**
+     * Get the attendances by id to display on the current page
+     * @param  int     $attendance_id
+     * @return array   attendance data
+     */
+    public function get_attendance_by_id($attendance_id)
+    {
+        $tbl_attendance = Database :: get_course_table(TABLE_ATTENDANCE);
+        $attendance_id = intval($attendance_id);
+        $course_id = api_get_course_int_id();
+        $attendance_data = array();
+        $sql = "SELECT * FROM $tbl_attendance
 				WHERE c_id = $course_id AND id = '$attendance_id'";
-		$res = Database::query($sql);
-		if (Database::num_rows($res) > 0) {
-			while ($row = Database::fetch_array($res)) {
-				$attendance_data = $row;
-			}
-		}
-		return $attendance_data;
-	}
-
-	/**
-	 * Add attendances sheet inside table. This is the *list of* dates, not
-	 * a specific date in itself.
-	 * @param  bool   true for adding link in gradebook or false otherwise (optional)
-	 * @return int    last attendance id
-	 */
-	public function attendance_add($link_to_gradebook = false)
-	{
-		$_course = api_get_course_info();
-		$tbl_attendance	= Database :: get_course_table(TABLE_ATTENDANCE);
-		$session_id = api_get_session_id();
-		$user_id = api_get_user_id();
-		$course_code = $_course['code'];
-		$course_id = $_course['real_id'];
-		$title_gradebook= $this->attendance_qualify_title;
-		$value_calification = 0;
-		$weight_calification = floatval($this->attendance_weight);
+        $res = Database::query($sql);
+        if (Database::num_rows($res) > 0) {
+            while ($row = Database::fetch_array($res)) {
+                $attendance_data = $row;
+            }
+        }
+        return $attendance_data;
+    }
+
+    /**
+     * Add attendances sheet inside table. This is the *list of* dates, not
+     * a specific date in itself.
+     * @param  bool   true for adding link in gradebook or false otherwise (optional)
+     * @return int    last attendance id
+     */
+    public function attendance_add($link_to_gradebook = false)
+    {
+        $_course = api_get_course_info();
+        $tbl_attendance	= Database :: get_course_table(TABLE_ATTENDANCE);
+        $session_id = api_get_session_id();
+        $user_id = api_get_user_id();
+        $course_code = $_course['code'];
+        $course_id = $_course['real_id'];
+        $title_gradebook= $this->attendance_qualify_title;
+        $value_calification = 0;
+        $weight_calification = floatval($this->attendance_weight);
 
         $em = Database::getManager();
 
-		$params = [
-			'c_id' => $course_id,
-			'name' => $this->name,
-			'description' => $this->description,
-			'attendance_qualify_title' => $title_gradebook,
-			'attendance_weight' => $weight_calification,
-			'session_id' => $session_id,
-			'active' => 1,
-			'attendance_qualify_max' => 0,
-			'locked' => 0
-		];
-		$last_id = Database::insert($tbl_attendance, $params);
-
-		if (!empty($last_id)) {
-
-			$sql = "UPDATE $tbl_attendance SET id = iid WHERE iid = $last_id";
-			Database::query($sql);
-
-			api_item_property_update(
-				$_course,
-				TOOL_ATTENDANCE,
-				$last_id,
-				"AttendanceAdded",
-				$user_id
-			);
-
-		}
-		// add link to gradebook
-		if ($link_to_gradebook && !empty($this->category_id)) {
-			$description = '';
+        $params = [
+            'c_id' => $course_id,
+            'name' => $this->name,
+            'description' => $this->description,
+            'attendance_qualify_title' => $title_gradebook,
+            'attendance_weight' => $weight_calification,
+            'session_id' => $session_id,
+            'active' => 1,
+            'attendance_qualify_max' => 0,
+            'locked' => 0
+        ];
+        $last_id = Database::insert($tbl_attendance, $params);
+
+        if (!empty($last_id)) {
+
+            $sql = "UPDATE $tbl_attendance SET id = iid WHERE iid = $last_id";
+            Database::query($sql);
+
+            api_item_property_update(
+                $_course,
+                TOOL_ATTENDANCE,
+                $last_id,
+                "AttendanceAdded",
+                $user_id
+            );
+
+        }
+        // add link to gradebook
+        if ($link_to_gradebook && !empty($this->category_id)) {
+            $description = '';
             $link_info = GradebookUtils::is_resource_in_course_gradebook(
                 $course_code,
                 7,
                 $last_id,
                 $session_id
             );
-			$link_id = $link_info->getId();
-			if (!$link_info) {
-				GradebookUtils::add_resource_to_course_gradebook(
-					$this->category_id,
-					$course_code,
-					7,
-					$last_id,
-					$title_gradebook,
-					$weight_calification,
-					$value_calification,
-					$description,
-					1,
-					$session_id
-				);
-			} else {
+            $link_id = $link_info->getId();
+            if (!$link_info) {
+                GradebookUtils::add_resource_to_course_gradebook(
+                    $this->category_id,
+                    $course_code,
+                    7,
+                    $last_id,
+                    $title_gradebook,
+                    $weight_calification,
+                    $value_calification,
+                    $description,
+                    1,
+                    $session_id
+                );
+            } else {
                 $gradebookLink = $em->find('ChamiloCoreBundle:GradebookLink', $link_id);
                 $gradebookLink->setWeight($weight_calification);
 
                 $em->persist($gradebookLink);
                 $em-flush();
-			}
-		}
-		return $last_id;
-	}
-
-	/**
-	 * edit attendances inside table
-	 * @param 	int	   attendance id
-	 * @param  	bool   true for adding link in gradebook or false otherwise (optional)
-	 * @return 	int    last id
-	 */
-	public function attendance_edit($attendance_id, $link_to_gradebook = false)
-	{
-		$_course = api_get_course_info();
-		$tbl_attendance = Database:: get_course_table(TABLE_ATTENDANCE);
+            }
+        }
+        return $last_id;
+    }
+
+    /**
+     * edit attendances inside table
+     * @param 	int	   attendance id
+     * @param  	bool   true for adding link in gradebook or false otherwise (optional)
+     * @return 	int    last id
+     */
+    public function attendance_edit($attendance_id, $link_to_gradebook = false)
+    {
+        $_course = api_get_course_info();
+        $tbl_attendance = Database:: get_course_table(TABLE_ATTENDANCE);
 
         $em = Database::getManager();
 
-		$session_id = api_get_session_id();
-		$user_id = api_get_user_id();
-		$attendance_id = intval($attendance_id);
-		$course_code = $_course['code'];
-		$course_id = $_course['real_id'];
-		$title_gradebook = $this->attendance_qualify_title;
-		$value_calification = 0;
-		$weight_calification = floatval($this->attendance_weight);
-
-		if (!empty($attendance_id)) {
-
-			$params = [
-				'name' => $this->name,
-				'description' => $this->description,
-				'attendance_qualify_title' => $title_gradebook,
-				'attendance_weight' => $weight_calification
-			];
-			Database::update(
-				$tbl_attendance,
-				$params,
-				['c_id = ? AND id = ?' => [$course_id, $attendance_id]]
-			);
-
-			api_item_property_update(
-				$_course,
-				TOOL_ATTENDANCE,
-				$attendance_id,
-				"AttendanceUpdated",
-				$user_id
-			);
-
-			// add link to gradebook
-			if ($link_to_gradebook && !empty($this->category_id)) {
-				$description = '';
-				$link = GradebookUtils::is_resource_in_course_gradebook(
-					$course_code,
-					7,
-					$attendance_id,
-					$session_id
-				);
-				if (!$link) {
-					GradebookUtils::add_resource_to_course_gradebook(
-						$this->category_id,
-						$course_code,
-						7,
-						$attendance_id,
-						$title_gradebook,
-						$weight_calification,
-						$value_calification,
-						$description,
-						1,
-						$session_id
-					);
-				} else {
+        $session_id = api_get_session_id();
+        $user_id = api_get_user_id();
+        $attendance_id = intval($attendance_id);
+        $course_code = $_course['code'];
+        $course_id = $_course['real_id'];
+        $title_gradebook = $this->attendance_qualify_title;
+        $value_calification = 0;
+        $weight_calification = floatval($this->attendance_weight);
+
+        if (!empty($attendance_id)) {
+
+            $params = [
+                'name' => $this->name,
+                'description' => $this->description,
+                'attendance_qualify_title' => $title_gradebook,
+                'attendance_weight' => $weight_calification
+            ];
+            Database::update(
+                $tbl_attendance,
+                $params,
+                ['c_id = ? AND id = ?' => [$course_id, $attendance_id]]
+            );
+
+            api_item_property_update(
+                $_course,
+                TOOL_ATTENDANCE,
+                $attendance_id,
+                "AttendanceUpdated",
+                $user_id
+            );
+
+            // add link to gradebook
+            if ($link_to_gradebook && !empty($this->category_id)) {
+                $description = '';
+                $link = GradebookUtils::is_resource_in_course_gradebook(
+                    $course_code,
+                    7,
+                    $attendance_id,
+                    $session_id
+                );
+                if (!$link) {
+                    GradebookUtils::add_resource_to_course_gradebook(
+                        $this->category_id,
+                        $course_code,
+                        7,
+                        $attendance_id,
+                        $title_gradebook,
+                        $weight_calification,
+                        $value_calification,
+                        $description,
+                        1,
+                        $session_id
+                    );
+                } else {
                     $gradebookLink = $em->find('ChamiloCoreBundle:GradebookLink', $this->getId());
                     $gradebookLink->setWeight($weight_calification);
 
                     $em->persist($gradebookLink);
                     $em->flush();
-				}
-			}
-
-			return $attendance_id;
-		}
-
-		return null;
-	}
-
-	/**
-	 * Restore attendance
-	 * @param 	int|array	   one or many attendances id
-	 * @return 	int    		   affected rows
-	 */
-	public function attendance_restore($attendance_id)
-	{
-		$_course = api_get_course_info();
-		$tbl_attendance	= Database :: get_course_table(TABLE_ATTENDANCE);
-		$user_id = api_get_user_id();
-		$course_id = $_course['real_id'];
-		if (is_array($attendance_id)) {
-			foreach ($attendance_id as $id) {
-				$id	= intval($id);
-				$sql = "UPDATE $tbl_attendance SET active = 1
+                }
+            }
+
+            return $attendance_id;
+        }
+
+        return null;
+    }
+
+    /**
+     * Restore attendance
+     * @param 	int|array	   one or many attendances id
+     * @return 	int    		   affected rows
+     */
+    public function attendance_restore($attendance_id)
+    {
+        $_course = api_get_course_info();
+        $tbl_attendance	= Database :: get_course_table(TABLE_ATTENDANCE);
+        $user_id = api_get_user_id();
+        $course_id = $_course['real_id'];
+        if (is_array($attendance_id)) {
+            foreach ($attendance_id as $id) {
+                $id	= intval($id);
+                $sql = "UPDATE $tbl_attendance SET active = 1
 						WHERE c_id = $course_id AND id = '$id'";
-				$result = Database::query($sql);
-				$affected_rows = Database::affected_rows($result);
-				if (!empty($affected_rows)) {
-					// update row item property table
+                $result = Database::query($sql);
+                $affected_rows = Database::affected_rows($result);
+                if (!empty($affected_rows)) {
+                    // update row item property table
                     api_item_property_update(
                         $_course,
                         TOOL_ATTENDANCE,
@@ -462,16 +462,16 @@ 
                         "restore",
                         $user_id
                     );
-				}
-			}
-		} else  {
-			$attendance_id	= intval($attendance_id);
-			$sql = "UPDATE $tbl_attendance SET active = 1
+                }
+            }
+        } else  {
+            $attendance_id	= intval($attendance_id);
+            $sql = "UPDATE $tbl_attendance SET active = 1
 					WHERE c_id = $course_id AND id = '$attendance_id'";
-			$result = Database::query($sql);
-			$affected_rows = Database::affected_rows($result);
-			if (!empty($affected_rows)) {
-				// update row item property table
+            $result = Database::query($sql);
+            $affected_rows = Database::affected_rows($result);
+            if (!empty($affected_rows)) {
+                // update row item property table
                 api_item_property_update(
                     $_course,
                     TOOL_ATTENDANCE,
@@ -479,33 +479,33 @@ 
                     "restore",
                     $user_id
                 );
-			}
-		}
-
-		return $affected_rows;
-	}
-
-	/**
-	 * Delete attendances
-	 * @param 	int|array	$attendance_id   one or many attendances id
-	 * @return 	int    		   affected rows
-	 */
-	public function attendance_delete($attendance_id)
-	{
-		$_course = api_get_course_info();
-		$tbl_attendance	= Database :: get_course_table(TABLE_ATTENDANCE);
+            }
+        }
+
+        return $affected_rows;
+    }
+
+    /**
+     * Delete attendances
+     * @param 	int|array	$attendance_id   one or many attendances id
+     * @return 	int    		   affected rows
+     */
+    public function attendance_delete($attendance_id)
+    {
+        $_course = api_get_course_info();
+        $tbl_attendance	= Database :: get_course_table(TABLE_ATTENDANCE);
         $user_id = api_get_user_id();
         $course_id = $_course['real_id'];
 
-		if (is_array($attendance_id)) {
-			foreach ($attendance_id as $id) {
-				$id	= intval($id);
-				$sql = "UPDATE $tbl_attendance SET active = 2
+        if (is_array($attendance_id)) {
+            foreach ($attendance_id as $id) {
+                $id	= intval($id);
+                $sql = "UPDATE $tbl_attendance SET active = 2
 						WHERE c_id = $course_id AND id = '$id'";
-				$result = Database::query($sql);
-				$affected_rows = Database::affected_rows($result);
-				if (!empty($affected_rows)) {
-					// update row item property table
+                $result = Database::query($sql);
+                $affected_rows = Database::affected_rows($result);
+                if (!empty($affected_rows)) {
+                    // update row item property table
                     api_item_property_update(
                         $_course,
                         TOOL_ATTENDANCE,
@@ -513,142 +513,142 @@ 
                         "delete",
                         $user_id
                     );
-				}
-			}
-		} else  {
-			$attendance_id= intval($attendance_id);
-			$sql = "UPDATE $tbl_attendance SET active = 2
+                }
+            }
+        } else  {
+            $attendance_id= intval($attendance_id);
+            $sql = "UPDATE $tbl_attendance SET active = 2
 					WHERE c_id = $course_id AND id = '$attendance_id'";
 
-			$result = Database::query($sql);
-			$affected_rows = Database::affected_rows($result);
-			if (!empty($affected_rows)) {
-				// update row item property table
-				api_item_property_update(
-					$_course,
-					TOOL_ATTENDANCE,
-					$attendance_id,
-					"delete",
-					$user_id
-				);
-			}
-		}
-
-		return $affected_rows;
-	}
-
-	/**
-	 * Changes visibility
-	 * @param int|array	$attendanceId   one or many attendances id
-	 * @param int status
+            $result = Database::query($sql);
+            $affected_rows = Database::affected_rows($result);
+            if (!empty($affected_rows)) {
+                // update row item property table
+                api_item_property_update(
+                    $_course,
+                    TOOL_ATTENDANCE,
+                    $attendance_id,
+                    "delete",
+                    $user_id
+                );
+            }
+        }
+
+        return $affected_rows;
+    }
+
+    /**
+     * Changes visibility
+     * @param int|array	$attendanceId   one or many attendances id
+     * @param int status
      *
-	 * @return 	int affected rows
-	 */
-	public function changeVisibility($attendanceId, $status = 1)
-	{
-		$_course = api_get_course_info();
-		$tbl_attendance	= Database :: get_course_table(TABLE_ATTENDANCE);
-		$user_id = api_get_user_id();
-		$course_id = $_course['real_id'];
-		$status = intval($status);
-
-		$action = 'visible';
-		if ($status == 0) {
-			$action = 'invisible';
-		}
-
-		if (is_array($attendanceId)) {
-			foreach ($attendanceId as $id) {
-				$id	= intval($id);
-				$sql = "UPDATE $tbl_attendance SET active = $status
+     * @return 	int affected rows
+     */
+    public function changeVisibility($attendanceId, $status = 1)
+    {
+        $_course = api_get_course_info();
+        $tbl_attendance	= Database :: get_course_table(TABLE_ATTENDANCE);
+        $user_id = api_get_user_id();
+        $course_id = $_course['real_id'];
+        $status = intval($status);
+
+        $action = 'visible';
+        if ($status == 0) {
+            $action = 'invisible';
+        }
+
+        if (is_array($attendanceId)) {
+            foreach ($attendanceId as $id) {
+                $id	= intval($id);
+                $sql = "UPDATE $tbl_attendance SET active = $status
 						WHERE c_id = $course_id AND id = '$id'";
-				$result = Database::query($sql);
-				$affected_rows = Database::affected_rows($result);
-				if (!empty($affected_rows)) {
-					// update row item property table
-					api_item_property_update($_course, TOOL_ATTENDANCE, $id, $action, $user_id);
-				}
-			}
-		} else  {
-			$attendanceId	= intval($attendanceId);
-			$sql = "UPDATE $tbl_attendance SET active = $status
+                $result = Database::query($sql);
+                $affected_rows = Database::affected_rows($result);
+                if (!empty($affected_rows)) {
+                    // update row item property table
+                    api_item_property_update($_course, TOOL_ATTENDANCE, $id, $action, $user_id);
+                }
+            }
+        } else  {
+            $attendanceId	= intval($attendanceId);
+            $sql = "UPDATE $tbl_attendance SET active = $status
 					WHERE c_id = $course_id AND id = '$attendanceId'";
-			$result = Database::query($sql);
-			$affected_rows = Database::affected_rows($result);
-			if (!empty($affected_rows)) {
-				// update row item property table
-				api_item_property_update(
-					$_course,
-					TOOL_ATTENDANCE,
-					$attendanceId,
-					$action,
-					$user_id
-				);
-			}
-		}
-
-		return $affected_rows;
-	}
-
-	/**
-	 * Lock or unlock an attendance
-	 * @param   int     attendance id
-	 * @param   bool    True to lock or false otherwise
-	 */
-	public function lock_attendance($attendance_id, $lock = true)
-	{
-		$tbl_attendance = Database::get_course_table(TABLE_ATTENDANCE);
-		$course_id = api_get_course_int_id();
-		$attendance_id = intval($attendance_id);
-		$locked = ($lock)?1:0;
-		$upd = "UPDATE $tbl_attendance SET locked = $locked
+            $result = Database::query($sql);
+            $affected_rows = Database::affected_rows($result);
+            if (!empty($affected_rows)) {
+                // update row item property table
+                api_item_property_update(
+                    $_course,
+                    TOOL_ATTENDANCE,
+                    $attendanceId,
+                    $action,
+                    $user_id
+                );
+            }
+        }
+
+        return $affected_rows;
+    }
+
+    /**
+     * Lock or unlock an attendance
+     * @param   int     attendance id
+     * @param   bool    True to lock or false otherwise
+     */
+    public function lock_attendance($attendance_id, $lock = true)
+    {
+        $tbl_attendance = Database::get_course_table(TABLE_ATTENDANCE);
+        $course_id = api_get_course_int_id();
+        $attendance_id = intval($attendance_id);
+        $locked = ($lock)?1:0;
+        $upd = "UPDATE $tbl_attendance SET locked = $locked
 				WHERE c_id = $course_id AND id = $attendance_id";
-		$result = Database::query($upd);
-		$affected_rows = Database::affected_rows($result);
-		if ($affected_rows && $lock) {
-			// Save attendance sheet log
-			$lastedit_date = api_get_utc_datetime();
-			$lastedit_type = self::LOCKED_ATTENDANCE_LOG_TYPE;
-			$lastedit_user_id = api_get_user_id();
-			$this->save_attendance_sheet_log(
-				$attendance_id,
-				$lastedit_date,
-				$lastedit_type,
-				$lastedit_user_id
-			);
-		}
-		return $affected_rows;
-	}
-
-	/**
-	 * Get registered users inside current course
-	 * @param 	int	   $attendance_id attendance id for showing attendance result field (optional)
-	 * @param int $groupId
-	 * @return 	array  users data
-	 */
-	public function get_users_rel_course($attendance_id = 0, $groupId = null)
-	{
-		$current_session_id = api_get_session_id();
-		$current_course_id  = api_get_course_id();
-		$currentCourseIntId = api_get_course_int_id();
-
-		$studentInGroup = array();
-
-		if (!empty($current_session_id)) {
-			$a_course_users = CourseManager:: get_user_list_from_course_code(
-				$current_course_id,
-				$current_session_id,
-				'',
-				'lastname'
-			);
-		} else {
-			$a_course_users = CourseManager:: get_user_list_from_course_code(
-				$current_course_id,
-				0,
-				'',
-				'lastname'
-			);
-		}
+        $result = Database::query($upd);
+        $affected_rows = Database::affected_rows($result);
+        if ($affected_rows && $lock) {
+            // Save attendance sheet log
+            $lastedit_date = api_get_utc_datetime();
+            $lastedit_type = self::LOCKED_ATTENDANCE_LOG_TYPE;
+            $lastedit_user_id = api_get_user_id();
+            $this->save_attendance_sheet_log(
+                $attendance_id,
+                $lastedit_date,
+                $lastedit_type,
+                $lastedit_user_id
+            );
+        }
+        return $affected_rows;
+    }
+
+    /**
+     * Get registered users inside current course
+     * @param 	int	   $attendance_id attendance id for showing attendance result field (optional)
+     * @param int $groupId
+     * @return 	array  users data
+     */
+    public function get_users_rel_course($attendance_id = 0, $groupId = null)
+    {
+        $current_session_id = api_get_session_id();
+        $current_course_id  = api_get_course_id();
+        $currentCourseIntId = api_get_course_int_id();
+
+        $studentInGroup = array();
+
+        if (!empty($current_session_id)) {
+            $a_course_users = CourseManager:: get_user_list_from_course_code(
+                $current_course_id,
+                $current_session_id,
+                '',
+                'lastname'
+            );
+        } else {
+            $a_course_users = CourseManager:: get_user_list_from_course_code(
+                $current_course_id,
+                0,
+                '',
+                'lastname'
+            );
+        }
 
         if (!empty($groupId)) {
             $groupInfo = GroupManager::get_group_properties($groupId);
@@ -660,192 +660,192 @@ 
             }
         }
 
-		// get registered users inside current course
-		$a_users = array();
-		foreach ($a_course_users as $key => $user_data) {
-			$value = array();
-			$uid = $user_data['user_id'];
-			$userInfo = api_get_user_info($uid);
-
-			$status = $user_data['status'];
-
-			if (!empty($groupId)) {
-				if (!isset($studentInGroup[$uid])) {
-					continue;
-				}
-			}
-
-			$user_status_in_session = null;
-			$user_status_in_course  = null;
-
-			if (api_get_session_id()) {
-				$user_status_in_session = SessionManager::get_user_status_in_course_session(
-					$uid,
-					$currentCourseIntId,
-					$current_session_id
-				);
-			} else {
-				$user_status_in_course = CourseManager::get_user_in_course_status(
-					$uid,
-					$current_course_id
-				);
-			}
-
-			// Not taking into account DRH or COURSEMANAGER
-			if ($uid <= 1 ||
-				$status == DRH ||
-				$user_status_in_course == COURSEMANAGER ||
-				$user_status_in_session == 2
-			) {
-				continue;
-			}
-
-			if (!empty($attendance_id)) {
-				$user_faults = $this->get_faults_of_user($uid, $attendance_id, $groupId);
-				$value['attendance_result'] = $user_faults['faults'].'/'.$user_faults['total'].' ('.$user_faults['faults_porcent'].'%)';
-				$value['result_color_bar'] 	= $user_faults['color_bar'];
-			}
+        // get registered users inside current course
+        $a_users = array();
+        foreach ($a_course_users as $key => $user_data) {
+            $value = array();
+            $uid = $user_data['user_id'];
+            $userInfo = api_get_user_info($uid);
+
+            $status = $user_data['status'];
+
+            if (!empty($groupId)) {
+                if (!isset($studentInGroup[$uid])) {
+                    continue;
+                }
+            }
+
+            $user_status_in_session = null;
+            $user_status_in_course  = null;
+
+            if (api_get_session_id()) {
+                $user_status_in_session = SessionManager::get_user_status_in_course_session(
+                    $uid,
+                    $currentCourseIntId,
+                    $current_session_id
+                );
+            } else {
+                $user_status_in_course = CourseManager::get_user_in_course_status(
+                    $uid,
+                    $current_course_id
+                );
+            }
+
+            // Not taking into account DRH or COURSEMANAGER
+            if ($uid <= 1 ||
+                $status == DRH ||
+                $user_status_in_course == COURSEMANAGER ||
+                $user_status_in_session == 2
+            ) {
+                continue;
+            }
+
+            if (!empty($attendance_id)) {
+                $user_faults = $this->get_faults_of_user($uid, $attendance_id, $groupId);
+                $value['attendance_result'] = $user_faults['faults'].'/'.$user_faults['total'].' ('.$user_faults['faults_porcent'].'%)';
+                $value['result_color_bar'] 	= $user_faults['color_bar'];
+            }
 
             $photo = Display::img($userInfo['avatar_small'], $userInfo['complete_name'], [], false);
 
-			$value['photo'] = $photo;
-			$value['firstname'] = $user_data['firstname'];
-			$value['lastname'] = $user_data['lastname'];
-			$value['username'] = $user_data['username'];
-			$value['user_id'] = $uid;
-
-			//Sending only 5 items in the array instead of 60
-			$a_users[$key] = $value;
-		}
-
-		return $a_users;
-	}
-
-	/**
-	 * add attendances sheet inside table
-	 * @param 	int	   $calendar_id attendance calendar id
-	 * @param  	array  $users_present present users during current class
-	 * @param	int	   $attendance_id
-	 * @return 	int    affected rows
-	 */
-	public function attendance_sheet_add($calendar_id, $users_present, $attendance_id)
-	{
-		$tbl_attendance_sheet 	= Database::get_course_table(TABLE_ATTENDANCE_SHEET);
-		$tbl_attendance_calendar= Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
-
-		$calendar_id = intval($calendar_id);
-		$attendance_id = intval($attendance_id);
-		$users = $this->get_users_rel_course();
-		$course_id = api_get_course_int_id();
-
-		$user_ids = array_keys($users);
-		$users_absent = array_diff($user_ids,$users_present);
-		$affected_rows = 0;
-
-		// get last edit type
-		$calendar_data = $this->get_attendance_calendar_by_id($calendar_id);
-		$lastedit_type = self::DONE_ATTENDANCE_LOG_TYPE;
-		if ($calendar_data['done_attendance']) {
-			$lastedit_type = self::UPDATED_ATTENDANCE_LOG_TYPE;
-		}
-
-		// save users present in class
-		foreach ($users_present as $user_present) {
-			$uid = intval($user_present);
-			// check if user already was registered with the $calendar_id
-			$sql = "SELECT user_id FROM $tbl_attendance_sheet
+            $value['photo'] = $photo;
+            $value['firstname'] = $user_data['firstname'];
+            $value['lastname'] = $user_data['lastname'];
+            $value['username'] = $user_data['username'];
+            $value['user_id'] = $uid;
+
+            //Sending only 5 items in the array instead of 60
+            $a_users[$key] = $value;
+        }
+
+        return $a_users;
+    }
+
+    /**
+     * add attendances sheet inside table
+     * @param 	int	   $calendar_id attendance calendar id
+     * @param  	array  $users_present present users during current class
+     * @param	int	   $attendance_id
+     * @return 	int    affected rows
+     */
+    public function attendance_sheet_add($calendar_id, $users_present, $attendance_id)
+    {
+        $tbl_attendance_sheet 	= Database::get_course_table(TABLE_ATTENDANCE_SHEET);
+        $tbl_attendance_calendar= Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
+
+        $calendar_id = intval($calendar_id);
+        $attendance_id = intval($attendance_id);
+        $users = $this->get_users_rel_course();
+        $course_id = api_get_course_int_id();
+
+        $user_ids = array_keys($users);
+        $users_absent = array_diff($user_ids,$users_present);
+        $affected_rows = 0;
+
+        // get last edit type
+        $calendar_data = $this->get_attendance_calendar_by_id($calendar_id);
+        $lastedit_type = self::DONE_ATTENDANCE_LOG_TYPE;
+        if ($calendar_data['done_attendance']) {
+            $lastedit_type = self::UPDATED_ATTENDANCE_LOG_TYPE;
+        }
+
+        // save users present in class
+        foreach ($users_present as $user_present) {
+            $uid = intval($user_present);
+            // check if user already was registered with the $calendar_id
+            $sql = "SELECT user_id FROM $tbl_attendance_sheet
 					WHERE c_id = $course_id AND user_id='$uid' AND attendance_calendar_id = '$calendar_id'";
-			$rs  = Database::query($sql);
-			if (Database::num_rows($rs) == 0) {
-				$sql = "INSERT INTO $tbl_attendance_sheet SET
+            $rs  = Database::query($sql);
+            if (Database::num_rows($rs) == 0) {
+                $sql = "INSERT INTO $tbl_attendance_sheet SET
 						c_id					= $course_id,
 						user_id 				= '$uid',
 						attendance_calendar_id 	= '$calendar_id',
 						presence 				= 1";
-				$result = Database::query($sql);
+                $result = Database::query($sql);
 
-				$affected_rows += Database::affected_rows($result);
-			} else {
-				$sql = "UPDATE $tbl_attendance_sheet SET presence = 1
+                $affected_rows += Database::affected_rows($result);
+            } else {
+                $sql = "UPDATE $tbl_attendance_sheet SET presence = 1
 						WHERE
 							c_id = $course_id AND
 							user_id ='$uid' AND
 							attendance_calendar_id = '$calendar_id'
 						";
-				$result = Database::query($sql);
-				$affected_rows += Database::affected_rows($result);
-			}
-		}
-
-		// save users absent in class
-		foreach ($users_absent as $user_absent) {
-			$uid = intval($user_absent);
-			// check if user already was registered with the $calendar_id
-			$sql = "SELECT user_id FROM $tbl_attendance_sheet
+                $result = Database::query($sql);
+                $affected_rows += Database::affected_rows($result);
+            }
+        }
+
+        // save users absent in class
+        foreach ($users_absent as $user_absent) {
+            $uid = intval($user_absent);
+            // check if user already was registered with the $calendar_id
+            $sql = "SELECT user_id FROM $tbl_attendance_sheet
 					WHERE c_id = $course_id AND user_id='$uid' AND attendance_calendar_id = '$calendar_id'";
-			$rs  = Database::query($sql);
-			if (Database::num_rows($rs) == 0) {
-				$sql = "INSERT INTO $tbl_attendance_sheet SET
+            $rs  = Database::query($sql);
+            if (Database::num_rows($rs) == 0) {
+                $sql = "INSERT INTO $tbl_attendance_sheet SET
 						c_id = $course_id,
 						user_id ='$uid',
 						attendance_calendar_id = '$calendar_id',
 						presence = 0";
-				$result = Database::query($sql);
+                $result = Database::query($sql);
 
-				Database::insert_id();
+                Database::insert_id();
 
-				$affected_rows += Database::affected_rows($result);
-			} else {
-				$sql = "UPDATE $tbl_attendance_sheet SET presence = 0
+                $affected_rows += Database::affected_rows($result);
+            } else {
+                $sql = "UPDATE $tbl_attendance_sheet SET presence = 0
 						WHERE
 							c_id = $course_id AND
 							user_id ='$uid' AND
 							attendance_calendar_id = '$calendar_id'";
-				$result = Database::query($sql);
-				$affected_rows += Database::affected_rows($result);
-			}
-		}
+                $result = Database::query($sql);
+                $affected_rows += Database::affected_rows($result);
+            }
+        }
 
-		// update done_attendance inside attendance calendar table
-		$sql = "UPDATE $tbl_attendance_calendar SET done_attendance = 1
+        // update done_attendance inside attendance calendar table
+        $sql = "UPDATE $tbl_attendance_calendar SET done_attendance = 1
 				WHERE  c_id = $course_id AND id = '$calendar_id'";
-		Database::query($sql);
-
-		// save users' results
-		$this->update_users_results($user_ids, $attendance_id);
-
-		if ($affected_rows) {
-			//save attendance sheet log
-			$lastedit_date = api_get_utc_datetime();
-			$lastedit_user_id = api_get_user_id();
-			$calendar_date_value = $calendar_data['date_time'];
-			$this->save_attendance_sheet_log(
-				$attendance_id,
-				$lastedit_date,
-				$lastedit_type,
-				$lastedit_user_id,
-				$calendar_date_value
-			);
-		}
-
-		return $affected_rows;
-	}
-
-	/**
-	 * update users' attendance results
-	 * @param 	array  $user_ids registered users inside current course
-	 * @param	int	   $attendance_id
-	 * @return 	void
-	 */
-	public function update_users_results($user_ids, $attendance_id)
-	{
-		$tbl_attendance_sheet = Database::get_course_table(TABLE_ATTENDANCE_SHEET);
-		$tbl_attendance_result = Database::get_course_table(TABLE_ATTENDANCE_RESULT);
-		$tbl_attendance = Database::get_course_table(TABLE_ATTENDANCE);
-		$course_id = api_get_course_int_id();
-
-		$attendance_id = intval($attendance_id);
-		// fill results about presence of students
+        Database::query($sql);
+
+        // save users' results
+        $this->update_users_results($user_ids, $attendance_id);
+
+        if ($affected_rows) {
+            //save attendance sheet log
+            $lastedit_date = api_get_utc_datetime();
+            $lastedit_user_id = api_get_user_id();
+            $calendar_date_value = $calendar_data['date_time'];
+            $this->save_attendance_sheet_log(
+                $attendance_id,
+                $lastedit_date,
+                $lastedit_type,
+                $lastedit_user_id,
+                $calendar_date_value
+            );
+        }
+
+        return $affected_rows;
+    }
+
+    /**
+     * update users' attendance results
+     * @param 	array  $user_ids registered users inside current course
+     * @param	int	   $attendance_id
+     * @return 	void
+     */
+    public function update_users_results($user_ids, $attendance_id)
+    {
+        $tbl_attendance_sheet = Database::get_course_table(TABLE_ATTENDANCE_SHEET);
+        $tbl_attendance_result = Database::get_course_table(TABLE_ATTENDANCE_RESULT);
+        $tbl_attendance = Database::get_course_table(TABLE_ATTENDANCE);
+        $course_id = api_get_course_int_id();
+
+        $attendance_id = intval($attendance_id);
+        // fill results about presence of students
         $attendance_calendar = $this->get_attendance_calendar(
             $attendance_id,
             'all',
@@ -853,82 +853,82 @@ 
             null,
             true
         );
-		$calendar_ids = array();
-		// get all dates from calendar by current attendance
-		foreach ($attendance_calendar as $cal) {
-			$calendar_ids[] = $cal['id'];
-		}
-
-		// get count of presences by users inside current attendance and save like results
-		if (count($user_ids) > 0) {
-			foreach ($user_ids as $uid) {
-				$count_presences = 0;
-				if (count($calendar_ids) > 0) {
-					$sql = "SELECT count(presence) as count_presences
+        $calendar_ids = array();
+        // get all dates from calendar by current attendance
+        foreach ($attendance_calendar as $cal) {
+            $calendar_ids[] = $cal['id'];
+        }
+
+        // get count of presences by users inside current attendance and save like results
+        if (count($user_ids) > 0) {
+            foreach ($user_ids as $uid) {
+                $count_presences = 0;
+                if (count($calendar_ids) > 0) {
+                    $sql = "SELECT count(presence) as count_presences
 							FROM $tbl_attendance_sheet
 					        WHERE
 					        	c_id = $course_id AND
 					        	user_id = '$uid' AND
 					        	attendance_calendar_id IN (".implode(',', $calendar_ids).") AND
 					        	presence = 1";
-					$rs_count  = Database::query($sql);
-					$row_count = Database::fetch_array($rs_count);
-					$count_presences = $row_count['count_presences'];
-				}
+                    $rs_count  = Database::query($sql);
+                    $row_count = Database::fetch_array($rs_count);
+                    $count_presences = $row_count['count_presences'];
+                }
 
-				// save results
-				$sql = "SELECT id FROM $tbl_attendance_result
+                // save results
+                $sql = "SELECT id FROM $tbl_attendance_result
 						WHERE
 							c_id = $course_id AND
 							user_id = '$uid' AND
 							attendance_id = '$attendance_id' ";
-				$rs_check_result = Database::query($sql);
+                $rs_check_result = Database::query($sql);
 
-				if (Database::num_rows($rs_check_result) > 0) {
-					// update result
-					$sql = "UPDATE $tbl_attendance_result SET
+                if (Database::num_rows($rs_check_result) > 0) {
+                    // update result
+                    $sql = "UPDATE $tbl_attendance_result SET
 							score = '$count_presences'
 							WHERE
 								c_id = $course_id AND
 								user_id='$uid' AND
 								attendance_id='$attendance_id'";
-					Database::query($sql);
-				} else {
-					// insert new result
-					$sql = "INSERT INTO $tbl_attendance_result SET
+                    Database::query($sql);
+                } else {
+                    // insert new result
+                    $sql = "INSERT INTO $tbl_attendance_result SET
 							c_id = $course_id ,
 							user_id			= '$uid',
 							attendance_id 	= '$attendance_id',
 							score			= '$count_presences'";
-					Database::query($sql);
+                    Database::query($sql);
 
-					$insertId = Database::insert_id();
+                    $insertId = Database::insert_id();
                     if ($insertId) {
                         $sql = "UPDATE $tbl_attendance_result SET id = iid WHERE iid = $insertId";
                         Database::query($sql);
                     }
-				}
-			}
-		}
+                }
+            }
+        }
 
-		// update attendance qualify max
-		$count_done_calendar = self::get_done_attendance_calendar($attendance_id);
+        // update attendance qualify max
+        $count_done_calendar = self::get_done_attendance_calendar($attendance_id);
 
-		$sql = "UPDATE $tbl_attendance SET
+        $sql = "UPDATE $tbl_attendance SET
 				attendance_qualify_max = '$count_done_calendar'
 				WHERE c_id = $course_id AND id = '$attendance_id'";
-		Database::query($sql);
-	}
-
-	/**
-	 * update attendance_sheet_log table, is used as history of an attendance sheet
-	 * @param   int     Attendance id
-	 * @param   string  Last edit datetime
-	 * @param   string  Event type ('locked_attendance', 'done_attendance_sheet' ...)
-	 * @param   int     Last edit user id
-	 * @param   string  Calendar datetime value (optional, when event type is 'done_attendance_sheet')
-	 * @return  int     Affected rows
-	 */
+        Database::query($sql);
+    }
+
+    /**
+     * update attendance_sheet_log table, is used as history of an attendance sheet
+     * @param   int     Attendance id
+     * @param   string  Last edit datetime
+     * @param   string  Event type ('locked_attendance', 'done_attendance_sheet' ...)
+     * @param   int     Last edit user id
+     * @param   string  Calendar datetime value (optional, when event type is 'done_attendance_sheet')
+     * @return  int     Affected rows
+     */
     public function save_attendance_sheet_log(
         $attendance_id,
         $lastedit_date,
@@ -936,22 +936,22 @@ 
         $lastedit_user_id,
         $calendar_date_value = null
     ) {
-		$course_id = api_get_course_int_id();
+        $course_id = api_get_course_int_id();
 
-		// define table
-		$tbl_attendance_sheet_log = Database::get_course_table(TABLE_ATTENDANCE_SHEET_LOG);
+        // define table
+        $tbl_attendance_sheet_log = Database::get_course_table(TABLE_ATTENDANCE_SHEET_LOG);
 
-		// protect data
-		$attendance_id = intval($attendance_id);
-		$lastedit_user_id = intval($lastedit_user_id);
+        // protect data
+        $attendance_id = intval($attendance_id);
+        $lastedit_user_id = intval($lastedit_user_id);
 
-		if (isset($calendar_date_value)) {
-			$calendar_date_value = $calendar_date_value;
-		} else {
-			$calendar_date_value = '';
-		}
+        if (isset($calendar_date_value)) {
+            $calendar_date_value = $calendar_date_value;
+        } else {
+            $calendar_date_value = '';
+        }
 
-		// save data
+        // save data
         $params = [
             'c_id' => $course_id,
             'attendance_id' => $attendance_id,
@@ -960,228 +960,228 @@ 
             'lastedit_user_id' => $lastedit_user_id,
             'calendar_date_value' => $calendar_date_value,
         ];
-		$insertId = Database::insert($tbl_attendance_sheet_log, $params);
+        $insertId = Database::insert($tbl_attendance_sheet_log, $params);
         if ($insertId) {
             $sql = "UPDATE $tbl_attendance_sheet_log SET id = iid WHERE iid = $insertId";
             Database::query($sql);
         }
 
-		return $insertId;
-	}
-
-	/**
-	 * Get number of done attendances inside current sheet
-	 * @param	int	   attendance id
-	 * @return 	int	   number of done attendances
-	 */
-	public static function get_done_attendance_calendar($attendance_id)
-	{
-		$tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
-		$attendance_id = intval($attendance_id);
-		$course_id = api_get_course_int_id();
-		$sql = "SELECT count(done_attendance) as count
+        return $insertId;
+    }
+
+    /**
+     * Get number of done attendances inside current sheet
+     * @param	int	   attendance id
+     * @return 	int	   number of done attendances
+     */
+    public static function get_done_attendance_calendar($attendance_id)
+    {
+        $tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
+        $attendance_id = intval($attendance_id);
+        $course_id = api_get_course_int_id();
+        $sql = "SELECT count(done_attendance) as count
                 FROM $tbl_attendance_calendar
                 WHERE
                     c_id = $course_id AND
                     attendance_id = '$attendance_id' AND
                     done_attendance = 1
                 ";
-		$rs  = Database::query($sql);
-		$row = Database::fetch_array($rs);
-		$count = $row['count'];
-
-		return $count;
-	}
-
-	/**
-	 * Get results of faults (absents) by user
-	 * @param int $user_id
-	 * @param int $attendance_id
-	 * @param int $groupId
-	 * @return 	array  results containing number of faults, total done attendance,
-	 * percent of faults and color depend on result (red, orange)
-	 */
-	public function get_faults_of_user($user_id, $attendance_id, $groupId = null)
-	{
+        $rs  = Database::query($sql);
+        $row = Database::fetch_array($rs);
+        $count = $row['count'];
+
+        return $count;
+    }
+
+    /**
+     * Get results of faults (absents) by user
+     * @param int $user_id
+     * @param int $attendance_id
+     * @param int $groupId
+     * @return 	array  results containing number of faults, total done attendance,
+     * percent of faults and color depend on result (red, orange)
+     */
+    public function get_faults_of_user($user_id, $attendance_id, $groupId = null)
+    {
         $user_id = intval($user_id);
         $attendance_id = intval($attendance_id);
-		$results = array();
-		$calendar_count = self::get_number_of_attendance_calendar($attendance_id, $groupId, NULL, $user_id);
-		// $total_done_attendance 	= $attendance_data['attendance_qualify_max'];
+        $results = array();
+        $calendar_count = self::get_number_of_attendance_calendar($attendance_id, $groupId, NULL, $user_id);
+        // $total_done_attendance 	= $attendance_data['attendance_qualify_max'];
         $total_done_attendance 	= self::get_number_of_attendance_calendar($attendance_id, $groupId, true, $user_id);
-		$attendance_user_score  = $this->get_user_score($user_id, $attendance_id, $groupId);
+        $attendance_user_score  = $this->get_user_score($user_id, $attendance_id, $groupId);
 
-		//This is the main change of the BT#1381
-		//$total_done_attendance = $calendar_count;
+        //This is the main change of the BT#1381
+        //$total_done_attendance = $calendar_count;
 
-		// calculate results
-		$faults = $total_done_attendance - $attendance_user_score;
+        // calculate results
+        $faults = $total_done_attendance - $attendance_user_score;
 
         if (empty($calendar_count)) {
             $faults = 0;
         }
 
         $faults = $faults > 0 ? $faults : 0;
-		$faults_porcent = $calendar_count > 0 ?round(($faults*100)/$calendar_count,0):0;
+        $faults_porcent = $calendar_count > 0 ?round(($faults*100)/$calendar_count,0):0;
         $results['faults'] = $faults;
         $results['total'] = $calendar_count;
         $results['faults_porcent'] = $faults_porcent;
-		$color_bar = '';
+        $color_bar = '';
 
         if ($faults_porcent > 25) {
             $color_bar = '#f28989';
-		} else if ($faults_porcent > 10) {
-			$color_bar = '#F90';
-		}
-		$results['color_bar'] = $color_bar;
-
-		return $results;
-	}
-
-	/**
-	 * Get results of faults average for all courses by user
-	 * @param	int	   $user_id
-	 * @return 	array  results containing number of faults, total done attendance,
-	 * percentage of faults and color depend on result (red, orange)
-	 */
-	public function get_faults_average_inside_courses($user_id)
-	{
-		// get all courses of current user
-		$courses = CourseManager::get_courses_list_by_user_id($user_id, true);
-
-		$user_id = intval($user_id);
-		$results = array();
-		$total_faults = $total_weight = $porcent = 0;
-		foreach ($courses as $course) {
-			//$course_code = $course['code'];
-			//$course_info = api_get_course_info($course_code);
-			$course_id = $course['real_id'];
-			$tbl_attendance_result 	= Database::get_course_table(TABLE_ATTENDANCE_RESULT);
-
-			$attendances_by_course = $this->get_attendances_list($course_id);
-
-			foreach ($attendances_by_course as $attendance) {
-				// get total faults and total weight
-				$total_done_attendance 	= $attendance['attendance_qualify_max'];
-				$sql = "SELECT score
+        } else if ($faults_porcent > 10) {
+            $color_bar = '#F90';
+        }
+        $results['color_bar'] = $color_bar;
+
+        return $results;
+    }
+
+    /**
+     * Get results of faults average for all courses by user
+     * @param	int	   $user_id
+     * @return 	array  results containing number of faults, total done attendance,
+     * percentage of faults and color depend on result (red, orange)
+     */
+    public function get_faults_average_inside_courses($user_id)
+    {
+        // get all courses of current user
+        $courses = CourseManager::get_courses_list_by_user_id($user_id, true);
+
+        $user_id = intval($user_id);
+        $results = array();
+        $total_faults = $total_weight = $porcent = 0;
+        foreach ($courses as $course) {
+            //$course_code = $course['code'];
+            //$course_info = api_get_course_info($course_code);
+            $course_id = $course['real_id'];
+            $tbl_attendance_result 	= Database::get_course_table(TABLE_ATTENDANCE_RESULT);
+
+            $attendances_by_course = $this->get_attendances_list($course_id);
+
+            foreach ($attendances_by_course as $attendance) {
+                // get total faults and total weight
+                $total_done_attendance 	= $attendance['attendance_qualify_max'];
+                $sql = "SELECT score
 						FROM $tbl_attendance_result
                         WHERE
                         	c_id = $course_id AND
                         	user_id = $user_id AND
                         	attendance_id = ".$attendance['id'];
-				$rs = Database::query($sql);
-				$score = 0;
-				if (Database::num_rows($rs) > 0) {
-					$row = Database::fetch_array($rs);
-					$score = $row['score'];
-				}
-				$faults = $total_done_attendance-$score;
-				$faults = $faults > 0 ? $faults:0;
-				$total_faults += $faults;
-				$total_weight += $total_done_attendance;
-			}
-		}
-
-		$porcent = $total_weight > 0 ?round(($total_faults*100)/$total_weight,0):0;
-		$results['faults'] 	= $total_faults;
-		$results['total']	= $total_weight;
-		$results['porcent'] = $porcent;
-
-		return $results;
-	}
-
-	/**
-	 * Get results of faults average by course
-	 * @param	int	   $user_id
-	 * @param 	string	$course_code
-	 * @param	int	   Session id (optional)
-	 * @return 	array  results containing number of faults,
-	 * total done attendance, porcent of faults and color depend on result (red, orange)
-	 */
-	public function get_faults_average_by_course($user_id, $course_code, $session_id = null)
-	{
-		// Database tables and variables
-		$course_info = api_get_course_info($course_code);
-		$tbl_attendance_result 	= Database::get_course_table(TABLE_ATTENDANCE_RESULT);
-		$user_id = intval($user_id);
-		$results = array();
-		$total_faults = $total_weight = $porcent = 0;
-		$attendances_by_course = $this->get_attendances_list($course_info['real_id'], $session_id);
-
-		foreach ($attendances_by_course as $attendance) {
-			// Get total faults and total weight
-			$total_done_attendance 	= $attendance['attendance_qualify_max'];
-			$sql = "SELECT score FROM $tbl_attendance_result
-					WHERE
+                $rs = Database::query($sql);
+                $score = 0;
+                if (Database::num_rows($rs) > 0) {
+                    $row = Database::fetch_array($rs);
+                    $score = $row['score'];
+                }
+                $faults = $total_done_attendance-$score;
+                $faults = $faults > 0 ? $faults:0;
+                $total_faults += $faults;
+                $total_weight += $total_done_attendance;
+            }
+        }
+
+        $porcent = $total_weight > 0 ?round(($total_faults*100)/$total_weight,0):0;
+        $results['faults'] 	= $total_faults;
+        $results['total']	= $total_weight;
+        $results['porcent'] = $porcent;
+
+        return $results;
+    }
+
+    /**
+     * Get results of faults average by course
+     * @param	int	   $user_id
+     * @param 	string	$course_code
+     * @param	int	   Session id (optional)
+     * @return 	array  results containing number of faults,
+     * total done attendance, porcent of faults and color depend on result (red, orange)
+     */
+    public function get_faults_average_by_course($user_id, $course_code, $session_id = null)
+    {
+        // Database tables and variables
+        $course_info = api_get_course_info($course_code);
+        $tbl_attendance_result 	= Database::get_course_table(TABLE_ATTENDANCE_RESULT);
+        $user_id = intval($user_id);
+        $results = array();
+        $total_faults = $total_weight = $porcent = 0;
+        $attendances_by_course = $this->get_attendances_list($course_info['real_id'], $session_id);
+
+        foreach ($attendances_by_course as $attendance) {
+            // Get total faults and total weight
+            $total_done_attendance 	= $attendance['attendance_qualify_max'];
+            $sql = "SELECT score FROM $tbl_attendance_result
+					WHERE
 						c_id = {$course_info['real_id']} AND
 						user_id = $user_id AND
 						attendance_id=".$attendance['id'];
-			$rs = Database::query($sql);
-			$score = 0;
-			if (Database::num_rows($rs) > 0) {
-				$row = Database::fetch_array($rs);
-				$score = $row['score'];
-			}
-			$faults = $total_done_attendance-$score;
-			$faults = $faults > 0 ? $faults:0;
-			$total_faults += $faults;
-			$total_weight += $total_done_attendance;
-		}
-
-		$porcent = $total_weight > 0 ?round(($total_faults*100)/$total_weight,0):0;
-		$results['faults'] 	= $total_faults;
-		$results['total']	= $total_weight;
-		$results['porcent'] = $porcent;
-
-		return $results;
-	}
-
-	/**
-	 * Get registered users' attendance sheet inside current course
-	 * @param	int	   $attendance_id
-	 * @param	int	   $user_id for showing data for only one user (optional)
-	 * @return 	array  users attendance sheet data
-	 */
-	public function get_users_attendance_sheet($attendance_id, $user_id = 0, $groupId = null)
-	{
-		$tbl_attendance_sheet 	= Database::get_course_table(TABLE_ATTENDANCE_SHEET);
-		$tbl_attendance_calendar= Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
-
-		$attendance_calendar = $this->get_attendance_calendar($attendance_id, 'all', null, $groupId);
-		$calendar_ids = array();
-		// get all dates from calendar by current attendance
-		foreach ($attendance_calendar as $cal) {
-			$calendar_ids[] = $cal['id'];
-		}
-
-		$course_id = api_get_course_int_id();
-
-		$data = array();
-		if (empty($user_id)) {
-			// get all registered users inside current course
-			$users = $this->get_users_rel_course();
-			$user_ids = array_keys($users);
-			if (count($calendar_ids) > 0 && count($user_ids) > 0) {
-				foreach ($user_ids as $uid) {
-					$sql = "SELECT * FROM $tbl_attendance_sheet
+            $rs = Database::query($sql);
+            $score = 0;
+            if (Database::num_rows($rs) > 0) {
+                $row = Database::fetch_array($rs);
+                $score = $row['score'];
+            }
+            $faults = $total_done_attendance-$score;
+            $faults = $faults > 0 ? $faults:0;
+            $total_faults += $faults;
+            $total_weight += $total_done_attendance;
+        }
+
+        $porcent = $total_weight > 0 ?round(($total_faults*100)/$total_weight,0):0;
+        $results['faults'] 	= $total_faults;
+        $results['total']	= $total_weight;
+        $results['porcent'] = $porcent;
+
+        return $results;
+    }
+
+    /**
+     * Get registered users' attendance sheet inside current course
+     * @param	int	   $attendance_id
+     * @param	int	   $user_id for showing data for only one user (optional)
+     * @return 	array  users attendance sheet data
+     */
+    public function get_users_attendance_sheet($attendance_id, $user_id = 0, $groupId = null)
+    {
+        $tbl_attendance_sheet 	= Database::get_course_table(TABLE_ATTENDANCE_SHEET);
+        $tbl_attendance_calendar= Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
+
+        $attendance_calendar = $this->get_attendance_calendar($attendance_id, 'all', null, $groupId);
+        $calendar_ids = array();
+        // get all dates from calendar by current attendance
+        foreach ($attendance_calendar as $cal) {
+            $calendar_ids[] = $cal['id'];
+        }
+
+        $course_id = api_get_course_int_id();
+
+        $data = array();
+        if (empty($user_id)) {
+            // get all registered users inside current course
+            $users = $this->get_users_rel_course();
+            $user_ids = array_keys($users);
+            if (count($calendar_ids) > 0 && count($user_ids) > 0) {
+                foreach ($user_ids as $uid) {
+                    $sql = "SELECT * FROM $tbl_attendance_sheet
 					        WHERE
 					        	c_id = $course_id AND
 					        	user_id = '$uid' AND
 					        	attendance_calendar_id IN(".implode(',',$calendar_ids).")
 							";
-					$res = Database::query($sql);
-					if (Database::num_rows($res) > 0) {
-						while ($row = Database::fetch_array($res)) {
-							$data[$uid][$row['attendance_calendar_id']]['presence'] = $row['presence'];
-						}
-					}
-				}
-			}
-		} else {
-			// Get attendance for current user
-			$user_id = intval($user_id);
-			if (count($calendar_ids) > 0) {
-				$sql = "SELECT cal.date_time, att.presence
+                    $res = Database::query($sql);
+                    if (Database::num_rows($res) > 0) {
+                        while ($row = Database::fetch_array($res)) {
+                            $data[$uid][$row['attendance_calendar_id']]['presence'] = $row['presence'];
+                        }
+                    }
+                }
+            }
+        } else {
+            // Get attendance for current user
+            $user_id = intval($user_id);
+            if (count($calendar_ids) > 0) {
+                $sql = "SELECT cal.date_time, att.presence
                         FROM $tbl_attendance_sheet att
 						INNER JOIN  $tbl_attendance_calendar cal
 						ON cal.id = att.attendance_calendar_id
@@ -1191,89 +1191,89 @@ 
 							att.user_id = '$user_id' AND
 							att.attendance_calendar_id IN (".implode(',',$calendar_ids).")
                         ORDER BY date_time";
-				$res = Database::query($sql);
-				if (Database::num_rows($res) > 0) {
-					while ($row = Database::fetch_array($res)) {
-						$row['date_time'] = api_convert_and_format_date($row['date_time'], null, date_default_timezone_get());
-						$data[$user_id][] = $row;
-					}
-				}
-			}
-		}
-
-		return $data;
-	}
-
-	/**
-	 * Get next attendance calendar without presences (done attendances)
-	 * @param	int	attendance id
-	 * @return 	int attendance calendar id
-	 */
-	public function get_next_attendance_calendar_id($attendance_id)
-	{
-		$tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
-		$attendance_id = intval($attendance_id);
-		$course_id = api_get_course_int_id();
-
-		$sql = "SELECT id FROM $tbl_attendance_calendar
+                $res = Database::query($sql);
+                if (Database::num_rows($res) > 0) {
+                    while ($row = Database::fetch_array($res)) {
+                        $row['date_time'] = api_convert_and_format_date($row['date_time'], null, date_default_timezone_get());
+                        $data[$user_id][] = $row;
+                    }
+                }
+            }
+        }
+
+        return $data;
+    }
+
+    /**
+     * Get next attendance calendar without presences (done attendances)
+     * @param	int	attendance id
+     * @return 	int attendance calendar id
+     */
+    public function get_next_attendance_calendar_id($attendance_id)
+    {
+        $tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
+        $attendance_id = intval($attendance_id);
+        $course_id = api_get_course_int_id();
+
+        $sql = "SELECT id FROM $tbl_attendance_calendar
 		        WHERE
 		        	c_id = $course_id AND
 		        	attendance_id = '$attendance_id' AND
 		        	done_attendance = 0
 		        ORDER BY date_time
 		        LIMIT 1";
-		$rs = Database::query($sql);
-		$next_calendar_id = 0;
-		if (Database::num_rows($rs) > 0) {
-			$row = Database::fetch_array($rs);
-			$next_calendar_id = $row['id'];
-		}
-
-		return $next_calendar_id;
-	}
-
-	/**
-	 * Get next attendance calendar datetime without presences (done attendances)
-	 * @param	int	attendance id
-	 * @return 	int UNIX time format datetime
-	 */
-	public function get_next_attendance_calendar_datetime($attendance_id)
-	{
-		$tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
-		$course_id = api_get_course_int_id();
-		$attendance_id = intval($attendance_id);
-		$sql = "SELECT id, date_time FROM $tbl_attendance_calendar
+        $rs = Database::query($sql);
+        $next_calendar_id = 0;
+        if (Database::num_rows($rs) > 0) {
+            $row = Database::fetch_array($rs);
+            $next_calendar_id = $row['id'];
+        }
+
+        return $next_calendar_id;
+    }
+
+    /**
+     * Get next attendance calendar datetime without presences (done attendances)
+     * @param	int	attendance id
+     * @return 	int UNIX time format datetime
+     */
+    public function get_next_attendance_calendar_datetime($attendance_id)
+    {
+        $tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
+        $course_id = api_get_course_int_id();
+        $attendance_id = intval($attendance_id);
+        $sql = "SELECT id, date_time FROM $tbl_attendance_calendar
 				WHERE
 					c_id = $course_id AND
 					attendance_id = '$attendance_id' AND
 					done_attendance = 0
 				ORDER BY date_time
 				LIMIT 1";
-		$rs = Database::query($sql);
-		$next_calendar_datetime = 0;
-		if (Database::num_rows($rs) > 0) {
-			$row = Database::fetch_array($rs);
-			$next_calendar_datetime = api_get_local_time($row['date_time']);
-		}
-
-		return $next_calendar_datetime;
-	}
-
-	/**
-	 * Get user' score from current attendance
-	 * @param	int	$user_id
-	 * @param	int $attendance_id
-	 * @return	int score
-	 */
-	public function get_user_score($user_id, $attendance_id, $groupId = null)
-	{
-		$tbl_attendance_result 	= Database::get_course_table(TABLE_ATTENDANCE_RESULT);
+        $rs = Database::query($sql);
+        $next_calendar_datetime = 0;
+        if (Database::num_rows($rs) > 0) {
+            $row = Database::fetch_array($rs);
+            $next_calendar_datetime = api_get_local_time($row['date_time']);
+        }
+
+        return $next_calendar_datetime;
+    }
+
+    /**
+     * Get user' score from current attendance
+     * @param	int	$user_id
+     * @param	int $attendance_id
+     * @return	int score
+     */
+    public function get_user_score($user_id, $attendance_id, $groupId = null)
+    {
+        $tbl_attendance_result 	= Database::get_course_table(TABLE_ATTENDANCE_RESULT);
         $tbl_attendance_sheet = Database::get_course_table(TABLE_ATTENDANCE_SHEET);
         $tbl_attendance_cal_rel_group = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR_REL_GROUP);
         $tbl_attendance_cal = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
-		$user_id = intval($user_id);
-		$attendance_id = intval($attendance_id);
-		$course_id = api_get_course_int_id();
+        $user_id = intval($user_id);
+        $attendance_id = intval($attendance_id);
+        $course_id = api_get_course_int_id();
         if (empty($groupId)) {
             $sql = "SELECT score FROM $tbl_attendance_result
                     WHERE
@@ -1297,68 +1297,68 @@ 
                         )
                     ";
         }
-		$rs = Database::query($sql);
-		$score = 0;
-		if (Database::num_rows($rs) > 0) {
-			$row = Database::fetch_array($rs);
-			$score = $row['score'];
-		}
-
-		return $score;
-	}
-
-	/**
-	 * Get attendance calendar data by id
-	 * @param	int	attendance calendar id
-	 * @return	array attendance calendar data
-	 */
-	public function get_attendance_calendar_by_id($calendar_id)
-	{
-		$tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
-		$calendar_id = intval($calendar_id);
-		$course_id = api_get_course_int_id();
-		$sql = "SELECT * FROM $tbl_attendance_calendar
+        $rs = Database::query($sql);
+        $score = 0;
+        if (Database::num_rows($rs) > 0) {
+            $row = Database::fetch_array($rs);
+            $score = $row['score'];
+        }
+
+        return $score;
+    }
+
+    /**
+     * Get attendance calendar data by id
+     * @param	int	attendance calendar id
+     * @return	array attendance calendar data
+     */
+    public function get_attendance_calendar_by_id($calendar_id)
+    {
+        $tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
+        $calendar_id = intval($calendar_id);
+        $course_id = api_get_course_int_id();
+        $sql = "SELECT * FROM $tbl_attendance_calendar
 				WHERE c_id = $course_id AND id = '$calendar_id' ";
-		$rs = Database::query($sql);
-		$data = array();
-		if (Database::num_rows($rs) > 0) {
-			while ($row = Database::fetch_array($rs)) {
-				$row['date_time'] = api_get_local_time($row['date_time']);
-				$data = $row;
-			}
-		}
-
-		return $data;
-	}
-
-	/**
-	 * Get all attendance calendar data inside current attendance
-	 * @param int	$attendance_id
-	 * @param string $type
-	 * @param int $calendar_id
-	 * @param int $groupId
-	 * @param bool $showAll = false show group calendar items or not
-	 *
-	 * @return	array attendance calendar data
-	 */
-	public function get_attendance_calendar(
-		$attendance_id,
-		$type = 'all',
-		$calendar_id = null,
-		$groupId = null,
-		$showAll = false
-	) {
-		$tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
+        $rs = Database::query($sql);
+        $data = array();
+        if (Database::num_rows($rs) > 0) {
+            while ($row = Database::fetch_array($rs)) {
+                $row['date_time'] = api_get_local_time($row['date_time']);
+                $data = $row;
+            }
+        }
+
+        return $data;
+    }
+
+    /**
+     * Get all attendance calendar data inside current attendance
+     * @param int	$attendance_id
+     * @param string $type
+     * @param int $calendar_id
+     * @param int $groupId
+     * @param bool $showAll = false show group calendar items or not
+     *
+     * @return	array attendance calendar data
+     */
+    public function get_attendance_calendar(
+        $attendance_id,
+        $type = 'all',
+        $calendar_id = null,
+        $groupId = null,
+        $showAll = false
+    ) {
+        $tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
         $tbl_acrg = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR_REL_GROUP);
-		$attendance_id = intval($attendance_id);
-		$course_id = api_get_course_int_id();
-		$groupCondition = null;
+        $attendance_id = intval($attendance_id);
+        $course_id = api_get_course_int_id();
+        $groupCondition = null;
 
-		if ($showAll) {
-			$sql = "SELECT * FROM $tbl_attendance_calendar c
+        if ($showAll) {
+            $sql = "SELECT * FROM $tbl_attendance_calendar c
 					WHERE c_id = $course_id AND attendance_id = '$attendance_id'";
-		} else {
-			$sql = "SELECT * FROM $tbl_attendance_calendar c
+        } else {
+            $sql = "SELECT * FROM $tbl_attendance_calendar c
 					WHERE
 						c_id = $course_id AND
 						attendance_id = '$attendance_id' AND
@@ -1367,11 +1367,11 @@ 
 							WHERE c_id = $course_id AND group_id != 0 AND group_id IS NOT NULL
 						)
 					";
-		}
+        }
 
-		if (!empty($groupId)) {
-			$groupId = intval($groupId);
-			$sql = "SELECT c.* FROM $tbl_attendance_calendar c
+        if (!empty($groupId)) {
+            $groupId = intval($groupId);
+            $sql = "SELECT c.* FROM $tbl_attendance_calendar c
 					INNER JOIN $tbl_acrg g
 					ON c.c_id = g.c_id AND c.id = g.calendar_id
 					WHERE
@@ -1379,62 +1379,62 @@ 
 					    g.group_id = '$groupId' AND
 					    c.attendance_id = '$attendance_id'
                    ";
-		}
-
-		if (!in_array($type, array('today', 'all', 'all_done', 'all_not_done','calendar_id'))) {
-			$type = 'all';
-		}
-
-		switch ($type) {
-			case 'calendar_id':
-				$calendar_id = intval($calendar_id);
-				if (!empty($calendar_id)) {
-					$sql.= " AND c.id = $calendar_id";
-				}
-				break;
-			case 'today':
-				//$sql .= ' AND DATE_FORMAT(date_time,"%d-%m-%Y") = DATE_FORMAT("'.api_get_utc_datetime().'", "%d-%m-%Y" )';
-				break;
-			case 'all_done':
-				$sql .= " AND done_attendance = 1 ";
-				break;
-			case 'all_not_done':
-				$sql .= " AND done_attendance = 0 ";
-				break;
-			case 'all':
-			default:
-				break;
-		}
-		$sql .= " ORDER BY date_time ";
+        }
 
-		$rs = Database::query($sql);
-		$data = array();
-		if (Database::num_rows($rs) > 0) {
-			while ($row = Database::fetch_array($rs,'ASSOC')) {
-				$row['db_date_time'] = $row['date_time'];
-				$row['date_time'] = api_get_local_time($row['date_time']);
-				$row['date'] = api_format_date($row['date_time'], DATE_FORMAT_SHORT);
-				$row['time'] = api_format_date($row['date_time'], TIME_NO_SEC_FORMAT);
-				$row['groups'] = $this->getGroupListByAttendanceCalendar($row['id'], $course_id);
-				if ($type == 'today') {
-					if (date('d-m-Y', api_strtotime($row['date_time'], 'UTC')) == date('d-m-Y', time())) {
-						$data[] = $row;
-					}
-				} else {
-					$data[] = $row;
-				}
-			}
-		}
-
-		return $data;
-	}
-
-	/**
-	 * Get number of attendance calendar inside current attendance
-	 * @param	int	$attendance_id
-	 * @param	int	$groupId
-	 * @return	int number of dates in attendance calendar
-	 */
+        if (!in_array($type, array('today', 'all', 'all_done', 'all_not_done','calendar_id'))) {
+            $type = 'all';
+        }
+
+        switch ($type) {
+            case 'calendar_id':
+                $calendar_id = intval($calendar_id);
+                if (!empty($calendar_id)) {
+                    $sql.= " AND c.id = $calendar_id";
+                }
+                break;
+            case 'today':
+                //$sql .= ' AND DATE_FORMAT(date_time,"%d-%m-%Y") = DATE_FORMAT("'.api_get_utc_datetime().'", "%d-%m-%Y" )';
+                break;
+            case 'all_done':
+                $sql .= " AND done_attendance = 1 ";
+                break;
+            case 'all_not_done':
+                $sql .= " AND done_attendance = 0 ";
+                break;
+            case 'all':
+            default:
+                break;
+        }
+        $sql .= " ORDER BY date_time ";
+
+        $rs = Database::query($sql);
+        $data = array();
+        if (Database::num_rows($rs) > 0) {
+            while ($row = Database::fetch_array($rs,'ASSOC')) {
+                $row['db_date_time'] = $row['date_time'];
+                $row['date_time'] = api_get_local_time($row['date_time']);
+                $row['date'] = api_format_date($row['date_time'], DATE_FORMAT_SHORT);
+                $row['time'] = api_format_date($row['date_time'], TIME_NO_SEC_FORMAT);
+                $row['groups'] = $this->getGroupListByAttendanceCalendar($row['id'], $course_id);
+                if ($type == 'today') {
+                    if (date('d-m-Y', api_strtotime($row['date_time'], 'UTC')) == date('d-m-Y', time())) {
+                        $data[] = $row;
+                    }
+                } else {
+                    $data[] = $row;
+                }
+            }
+        }
+
+        return $data;
+    }
+
+    /**
+     * Get number of attendance calendar inside current attendance
+     * @param	int	$attendance_id
+     * @param	int	$groupId
+     * @return	int number of dates in attendance calendar
+     */
     public static function get_number_of_attendance_calendar($attendance_id, $groupId = 0, $done_attendance = NULL, $userId = 0)
     {
         $tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
@@ -1520,113 +1520,113 @@ 
 
 
     /**
-	 * Get count dates inside attendance calendar by attendance id
-	 * @param	int	$attendance_id
-	 * @return	int     count of dates
-	 */
-	public static function get_count_dates_inside_attendance_calendar($attendance_id)
-	{
-		$tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
-		$attendance_id = intval($attendance_id);
-		$course_id = api_get_course_int_id();
-		$sql = "SELECT count(id) FROM $tbl_attendance_calendar
+     * Get count dates inside attendance calendar by attendance id
+     * @param	int	$attendance_id
+     * @return	int     count of dates
+     */
+    public static function get_count_dates_inside_attendance_calendar($attendance_id)
+    {
+        $tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
+        $attendance_id = intval($attendance_id);
+        $course_id = api_get_course_int_id();
+        $sql = "SELECT count(id) FROM $tbl_attendance_calendar
                 WHERE
                 	c_id = $course_id AND
                 	attendance_id = '$attendance_id'";
-		$rs = Database::query($sql);
-		$count = 0;
-		if (Database::num_rows($rs) > 0) {
-			$row = Database::fetch_row($rs);
-			$count = $row[0];
-		}
-		return $count;
-	}
-
-	/**
-	 * check if all calendar of an attendance is done
-	 * @param   int     $attendance_id
-	 * @return  bool    True if all calendar is done, otherwise false
-	 */
-	public static function is_all_attendance_calendar_done($attendance_id)
-	{
-		$attendance_id = intval($attendance_id);
-		$done_calendar = self::get_done_attendance_calendar($attendance_id);
-		$count_dates_in_calendar = self::get_count_dates_inside_attendance_calendar($attendance_id);
-		$number_of_dates = self::get_number_of_attendance_calendar($attendance_id);
-
-		$result = false;
-		if ($number_of_dates && (intval($count_dates_in_calendar) == intval($done_calendar))) {
-			$result = true;
-		}
-		return $result;
-	}
-
-	/**
-	 * check if an attendance is locked
-	 * @param   int $attendance_id
-	 * @param   bool
-	 */
-	public static function is_locked_attendance($attendance_id)
-	{
-		//use gradebook lock
-		$result = api_resource_is_locked_by_gradebook($attendance_id, LINK_ATTENDANCE);
-
-		return $result;
-	}
-
-	/**
-	 * Add new datetime inside attendance calendar table
-	 * @param	int		$attendance_id
-	 * @param 	array 	$groupList
-	 * @return	int affected rows
-	 */
-	public function attendance_calendar_add($attendance_id, $groupList = array())
-	{
-		$tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
-		$affected_rows = 0;
-		$attendance_id = intval($attendance_id);
-		$course_id = api_get_course_int_id();
-		// check if datetime already exists inside the table
-		/*$sql = "SELECT id FROM $tbl_attendance_calendar
+        $rs = Database::query($sql);
+        $count = 0;
+        if (Database::num_rows($rs) > 0) {
+            $row = Database::fetch_row($rs);
+            $count = $row[0];
+        }
+        return $count;
+    }
+
+    /**
+     * check if all calendar of an attendance is done
+     * @param   int     $attendance_id
+     * @return  bool    True if all calendar is done, otherwise false
+     */
+    public static function is_all_attendance_calendar_done($attendance_id)
+    {
+        $attendance_id = intval($attendance_id);
+        $done_calendar = self::get_done_attendance_calendar($attendance_id);
+        $count_dates_in_calendar = self::get_count_dates_inside_attendance_calendar($attendance_id);
+        $number_of_dates = self::get_number_of_attendance_calendar($attendance_id);
+
+        $result = false;
+        if ($number_of_dates && (intval($count_dates_in_calendar) == intval($done_calendar))) {
+            $result = true;
+        }
+        return $result;
+    }
+
+    /**
+     * check if an attendance is locked
+     * @param   int $attendance_id
+     * @param   bool
+     */
+    public static function is_locked_attendance($attendance_id)
+    {
+        //use gradebook lock
+        $result = api_resource_is_locked_by_gradebook($attendance_id, LINK_ATTENDANCE);
+
+        return $result;
+    }
+
+    /**
+     * Add new datetime inside attendance calendar table
+     * @param	int		$attendance_id
+     * @param 	array 	$groupList
+     * @return	int affected rows
+     */
+    public function attendance_calendar_add($attendance_id, $groupList = array())
+    {
+        $tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
+        $affected_rows = 0;
+        $attendance_id = intval($attendance_id);
+        $course_id = api_get_course_int_id();
+        // check if datetime already exists inside the table
+        /*$sql = "SELECT id FROM $tbl_attendance_calendar
 		        WHERE
 		        	c_id = $course_id AND
 		        	date_time='".Database::escape_string($this->date_time)."' AND
 		        	attendance_id = '$attendance_id'";
 		$rs = Database::query($sql);
 		if (Database::num_rows($rs) == 0) {*/
-			$params = array(
-				'c_id' =>  $course_id,
-				'date_time' => $this->date_time,
-				'attendance_id' => $attendance_id,
+            $params = array(
+                'c_id' =>  $course_id,
+                'date_time' => $this->date_time,
+                'attendance_id' => $attendance_id,
                 'done_attendance' => 0
-			);
-			$id = Database::insert($tbl_attendance_calendar, $params);
-
-			if ($id) {
-				$sql = "UPDATE $tbl_attendance_calendar SET id = iid WHERE iid = $id";
-				Database::query($sql);
-				$affected_rows++;
-			}
-			$this->addAttendanceCalendarToGroup($id, $course_id, $groupList);
-		//}
-
-		// update locked attendance
-		$is_all_calendar_done = self::is_all_attendance_calendar_done($attendance_id);
-		if (!$is_all_calendar_done) {
-			self::lock_attendance($attendance_id, false);
-		} else {
-			self::lock_attendance($attendance_id);
-		}
-		return $affected_rows;
-	}
-
-	/**
-	 * @param int   $calendarId
-	 * @param int 	$courseId
-	 * @param array $groupList
-	 */
-	public function addAttendanceCalendarToGroup($calendarId, $courseId, $groupList)
-	{
+            );
+            $id = Database::insert($tbl_attendance_calendar, $params);
+
+            if ($id) {
+                $sql = "UPDATE $tbl_attendance_calendar SET id = iid WHERE iid = $id";
+                Database::query($sql);
+                $affected_rows++;
+            }
+            $this->addAttendanceCalendarToGroup($id, $course_id, $groupList);
+        //}
+
+        // update locked attendance
+        $is_all_calendar_done = self::is_all_attendance_calendar_done($attendance_id);
+        if (!$is_all_calendar_done) {
+            self::lock_attendance($attendance_id, false);
+        } else {
+            self::lock_attendance($attendance_id);
+        }
+        return $affected_rows;
+    }
+
+    /**
+     * @param int   $calendarId
+     * @param int 	$courseId
+     * @param array $groupList
+     */
+    public function addAttendanceCalendarToGroup($calendarId, $courseId, $groupList)
+    {
         if (empty($groupList)) {
             return false;
         }
@@ -1653,507 +1653,507 @@ 
                 Database::insert($table, $params);
             }
         }
-	}
-
-	/**
-	 * @param int $calendarId
-	 * @param int $courseId
-	 * @param int $groupId
-	 * @return array
-	 */
-	public function getGroupListByAttendanceCalendar($calendarId, $courseId)
-	{
-		$table = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR_REL_GROUP);
-		return Database::select(
-			'*',
-			$table,
-			array('where'=>
-				array(
-					'calendar_id = ? AND c_id = ?' => array($calendarId, $courseId)
-				)
-			)
-		);
-	}
-
-	/**
-	 * @param int $calendarId
-	 * @param int $courseId
-	 * @param int $groupId
-	 * @return array
-	 */
-	public function getAttendanceCalendarGroup($calendarId, $courseId, $groupId)
-	{
-		$table = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR_REL_GROUP);
-		return Database::select(
-			'*',
-			$table,
-			array('where'=>
-				array(
-					'calendar_id = ? AND c_id = ? AND group_id = ?' => array($calendarId, $courseId, $groupId)
-				)
-			)
-		);
-	}
-
-	/**
-	 * @param int $calendarId
-	 * @param int $courseId
-	 * @param int $groupId
+    }
+
+    /**
+     * @param int $calendarId
+     * @param int $courseId
+     * @param int $groupId
+     * @return array
+     */
+    public function getGroupListByAttendanceCalendar($calendarId, $courseId)
+    {
+        $table = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR_REL_GROUP);
+        return Database::select(
+            '*',
+            $table,
+            array('where'=>
+                array(
+                    'calendar_id = ? AND c_id = ?' => array($calendarId, $courseId)
+                )
+            )
+        );
+    }
+
+    /**
+     * @param int $calendarId
+     * @param int $courseId
+     * @param int $groupId
+     * @return array
+     */
+    public function getAttendanceCalendarGroup($calendarId, $courseId, $groupId)
+    {
+        $table = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR_REL_GROUP);
+        return Database::select(
+            '*',
+            $table,
+            array('where'=>
+                array(
+                    'calendar_id = ? AND c_id = ? AND group_id = ?' => array($calendarId, $courseId, $groupId)
+                )
+            )
+        );
+    }
+
+    /**
+     * @param int $calendarId
+     * @param int $courseId
+     * @param int $groupId
      *
-	 * @return array
-	 */
-	public function deleteAttendanceCalendarGroup($calendarId, $courseId)
-	{
-		$table = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR_REL_GROUP);
-		Database::delete(
-			$table,
-			array(
-				'calendar_id = ? AND c_id = ?' => array($calendarId, $courseId)
-			)
-		);
-	}
-
-	/**
-	 * save repeated date inside attendance calendar table
-	 * @param int $attendance_id
-	 * @param int $start_date start date in tms
-	 * @param int $end_date end date in tms
-	 * @param string $repeat_type daily, weekly, monthlyByDate
-	 * @param array $groupList
-	 */
-	public function attendance_repeat_calendar_add(
-		$attendance_id,
-		$start_date,
-		$end_date,
-		$repeat_type,
-		$groupList = array()
-	) {
-		$attendance_id = intval($attendance_id);
-		// save start date
-		$datetimezone = api_get_utc_datetime($start_date);
-		$this->set_date_time($datetimezone);
-		$this->attendance_calendar_add($attendance_id, $groupList);
-
-		// 86400 = 24 hours in seconds
-		// 604800 = 1 week in seconds
-		// Saves repeated dates
-		switch ($repeat_type) {
-			case 'daily':
-				$j = 1;
-				for ($i = $start_date + 86400; ($i <= $end_date); $i += 86400) {
-					$datetimezone = api_get_utc_datetime($i);
-					$this->set_date_time($datetimezone);
-					$this->attendance_calendar_add($attendance_id, $groupList);
-					$j++;
-				}
-				break;
-			case 'weekly':
-				$j = 1;
-				for ($i = $start_date + 604800; ($i <= $end_date); $i += 604800) {
-					$datetimezone = api_get_utc_datetime($i);
-					$this->set_date_time($datetimezone);
-					$this->attendance_calendar_add($attendance_id, $groupList);
-					$j++;
-				}
-				break;
-			case 'monthlyByDate':
-				$j = 1;
-				//@todo fix bug with february
-				for ($i = $start_date + 2419200; ($i <= $end_date); $i += 2419200) {
-					$datetimezone = api_get_utc_datetime($i);
-					$this->set_date_time($datetimezone);
-					$this->attendance_calendar_add($attendance_id, $groupList);
-					$j++;
-				}
-				break;
-		}
-	}
-
-	/**
-	 * Adds x months to a UNIX timestamp
-	 * @param   int     The timestamp
-	 * @param   int     The number of years to add
-	 * @return  int     The new timestamp
-	 */
-	private function add_month($timestamp, $num=1)
-	{
-		$values = api_get_utc_datetime($timestamp);
-		$values = str_replace(array(':','-',' '), '/', $values);
-		list($y, $m, $d, $h, $n, $s) = split('/',$values);
-		if($m+$num>12) {
-			$y += floor($num/12);
-			$m += $num%12;
-		} else {
-			$m += $num;
-		}
-		//date_default_timezone_set('UTC');
-		// return mktime($h, $n, $s, $m, $d, $y);
-		$result = api_strtotime($y.'-'.$m.'-'.$d.' '.$h.':'.$n.':'.$s, 'UTC');
-		if (!empty($result)) {
-			return $result;
-		}
-		return false;
-	}
-
-	/**
-	 * edit a datetime inside attendance calendar table
-	 * @param	int	attendance calendar id
-	 * @param	int	attendance id
-	 * @return	int affected rows
-	 */
-	public function attendance_calendar_edit($calendar_id, $attendance_id)
-	{
-		$tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
-		$affected_rows = 0;
-		$attendance_id = intval($attendance_id);
-		$course_id = api_get_course_int_id();
-		// check if datetime already exists inside the table
-		$sql = "SELECT id FROM $tbl_attendance_calendar
+     * @return array
+     */
+    public function deleteAttendanceCalendarGroup($calendarId, $courseId)
+    {
+        $table = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR_REL_GROUP);
+        Database::delete(
+            $table,
+            array(
+                'calendar_id = ? AND c_id = ?' => array($calendarId, $courseId)
+            )
+        );
+    }
+
+    /**
+     * save repeated date inside attendance calendar table
+     * @param int $attendance_id
+     * @param int $start_date start date in tms
+     * @param int $end_date end date in tms
+     * @param string $repeat_type daily, weekly, monthlyByDate
+     * @param array $groupList
+     */
+    public function attendance_repeat_calendar_add(
+        $attendance_id,
+        $start_date,
+        $end_date,
+        $repeat_type,
+        $groupList = array()
+    ) {
+        $attendance_id = intval($attendance_id);
+        // save start date
+        $datetimezone = api_get_utc_datetime($start_date);
+        $this->set_date_time($datetimezone);
+        $this->attendance_calendar_add($attendance_id, $groupList);
+
+        // 86400 = 24 hours in seconds
+        // 604800 = 1 week in seconds
+        // Saves repeated dates
+        switch ($repeat_type) {
+            case 'daily':
+                $j = 1;
+                for ($i = $start_date + 86400; ($i <= $end_date); $i += 86400) {
+                    $datetimezone = api_get_utc_datetime($i);
+                    $this->set_date_time($datetimezone);
+                    $this->attendance_calendar_add($attendance_id, $groupList);
+                    $j++;
+                }
+                break;
+            case 'weekly':
+                $j = 1;
+                for ($i = $start_date + 604800; ($i <= $end_date); $i += 604800) {
+                    $datetimezone = api_get_utc_datetime($i);
+                    $this->set_date_time($datetimezone);
+                    $this->attendance_calendar_add($attendance_id, $groupList);
+                    $j++;
+                }
+                break;
+            case 'monthlyByDate':
+                $j = 1;
+                //@todo fix bug with february
+                for ($i = $start_date + 2419200; ($i <= $end_date); $i += 2419200) {
+                    $datetimezone = api_get_utc_datetime($i);
+                    $this->set_date_time($datetimezone);
+                    $this->attendance_calendar_add($attendance_id, $groupList);
+                    $j++;
+                }
+                break;
+        }
+    }
+
+    /**
+     * Adds x months to a UNIX timestamp
+     * @param   int     The timestamp
+     * @param   int     The number of years to add
+     * @return  int     The new timestamp
+     */
+    private function add_month($timestamp, $num=1)
+    {
+        $values = api_get_utc_datetime($timestamp);
+        $values = str_replace(array(':','-',' '), '/', $values);
+        list($y, $m, $d, $h, $n, $s) = split('/',$values);
+        if($m+$num>12) {
+            $y += floor($num/12);
+            $m += $num%12;
+        } else {
+            $m += $num;
+        }
+        //date_default_timezone_set('UTC');
+        // return mktime($h, $n, $s, $m, $d, $y);
+        $result = api_strtotime($y.'-'.$m.'-'.$d.' '.$h.':'.$n.':'.$s, 'UTC');
+        if (!empty($result)) {
+            return $result;
+        }
+        return false;
+    }
+
+    /**
+     * edit a datetime inside attendance calendar table
+     * @param	int	attendance calendar id
+     * @param	int	attendance id
+     * @return	int affected rows
+     */
+    public function attendance_calendar_edit($calendar_id, $attendance_id)
+    {
+        $tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
+        $affected_rows = 0;
+        $attendance_id = intval($attendance_id);
+        $course_id = api_get_course_int_id();
+        // check if datetime already exists inside the table
+        $sql = "SELECT id FROM $tbl_attendance_calendar
 		        WHERE
 		        	c_id = $course_id AND
 		        	date_time = '".Database::escape_string($this->date_time)."' AND
 		        	attendance_id = '$attendance_id'";
-		$rs = Database::query($sql);
+        $rs = Database::query($sql);
 
-		if (Database::num_rows($rs) == 0) {
-			$sql = "UPDATE $tbl_attendance_calendar
+        if (Database::num_rows($rs) == 0) {
+            $sql = "UPDATE $tbl_attendance_calendar
 					SET date_time='".Database::escape_string($this->date_time)."'
 					WHERE c_id = $course_id AND id = '".intval($calendar_id)."'";
-			Database::query($sql);
-		}
-
-		// update locked attendance
-		$is_all_calendar_done = self::is_all_attendance_calendar_done($attendance_id);
-		if (!$is_all_calendar_done) {
-			self::lock_attendance($attendance_id, false);
-		} else {
-			self::lock_attendance($attendance_id);
-		}
-
-		return $affected_rows;
-	}
-
-	/**
-	 * delete a datetime from attendance calendar table
-	 * @param	int		attendance calendar id
-	 * @param	int		attendance id
-	 * @param	bool	true for removing all calendar inside current attendance, false for removing by calendar id
-	 * @return	int affected rows
-	 */
-	public function attendance_calendar_delete($calendar_id, $attendance_id , $all_delete = false)
-	{
-		$tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
-		$tbl_attendance_sheet = Database::get_course_table(TABLE_ATTENDANCE_SHEET);
-
-		$attendance_id = intval($attendance_id);
-		// get all registered users inside current course
-		$users = $this->get_users_rel_course();
-		$user_ids = array_keys($users);
-		$course_id = api_get_course_int_id();
-		$affected_rows = 0;
-		if ($all_delete) {
-			$attendance_calendar = $this->get_attendance_calendar($attendance_id);
-			// get all dates from calendar by current attendance
-			if (!empty($attendance_calendar)) {
-				foreach ($attendance_calendar as $cal) {
-					// delete all data from attendance sheet
-					$sql = "DELETE FROM $tbl_attendance_sheet
+            Database::query($sql);
+        }
+
+        // update locked attendance
+        $is_all_calendar_done = self::is_all_attendance_calendar_done($attendance_id);
+        if (!$is_all_calendar_done) {
+            self::lock_attendance($attendance_id, false);
+        } else {
+            self::lock_attendance($attendance_id);
+        }
+
+        return $affected_rows;
+    }
+
+    /**
+     * delete a datetime from attendance calendar table
+     * @param	int		attendance calendar id
+     * @param	int		attendance id
+     * @param	bool	true for removing all calendar inside current attendance, false for removing by calendar id
+     * @return	int affected rows
+     */
+    public function attendance_calendar_delete($calendar_id, $attendance_id , $all_delete = false)
+    {
+        $tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
+        $tbl_attendance_sheet = Database::get_course_table(TABLE_ATTENDANCE_SHEET);
+
+        $attendance_id = intval($attendance_id);
+        // get all registered users inside current course
+        $users = $this->get_users_rel_course();
+        $user_ids = array_keys($users);
+        $course_id = api_get_course_int_id();
+        $affected_rows = 0;
+        if ($all_delete) {
+            $attendance_calendar = $this->get_attendance_calendar($attendance_id);
+            // get all dates from calendar by current attendance
+            if (!empty($attendance_calendar)) {
+                foreach ($attendance_calendar as $cal) {
+                    // delete all data from attendance sheet
+                    $sql = "DELETE FROM $tbl_attendance_sheet
 							WHERE c_id = $course_id AND attendance_calendar_id = '".intval($cal['id'])."'";
-					Database::query($sql);
-					// delete data from attendance calendar
-					$sql = "DELETE FROM $tbl_attendance_calendar
+                    Database::query($sql);
+                    // delete data from attendance calendar
+                    $sql = "DELETE FROM $tbl_attendance_calendar
 							WHERE c_id = $course_id AND id = '".intval($cal['id'])."'";
-					Database::query($sql);
-
-					$this->deleteAttendanceCalendarGroup($cal['id'], $course_id);
-					$affected_rows++;
-				}
-			}
-		} else {
-			// delete just one row from attendance sheet by the calendar id
-			$sql = "DELETE FROM $tbl_attendance_sheet
+                    Database::query($sql);
+
+                    $this->deleteAttendanceCalendarGroup($cal['id'], $course_id);
+                    $affected_rows++;
+                }
+            }
+        } else {
+            // delete just one row from attendance sheet by the calendar id
+            $sql = "DELETE FROM $tbl_attendance_sheet
 					WHERE c_id = $course_id AND attendance_calendar_id = '".intval($calendar_id)."'";
-			Database::query($sql);
-			// delete data from attendance calendar
-			$sql = "DELETE FROM $tbl_attendance_calendar
+            Database::query($sql);
+            // delete data from attendance calendar
+            $sql = "DELETE FROM $tbl_attendance_calendar
 					WHERE c_id = $course_id AND id = '".intval($calendar_id)."'";
-			Database::query($sql);
-
-			$this->deleteAttendanceCalendarGroup($calendar_id, $course_id);
-			$affected_rows++;
-		}
-
-		// update users' results
-		$this->update_users_results($user_ids, $attendance_id);
-
-		return $affected_rows;
-	}
-
-	/** Setters for fields of attendances tables **/
-	public function set_session_id($session_id)
-	{
-		$this->session_id = $session_id;
-	}
-
-	public function set_course_id($course_id)
-	{
-		$this->course_id = $course_id;
-	}
-
-	public function set_date_time($datetime)
-	{
-		$this->date_time = $datetime;
-	}
-
-	public function set_name($name)
-	{
-		$this->name = $name;
-	}
-
-	public function set_description($description)
-	{
-		$this->description = $description;
-	}
-
-	public function set_attendance_qualify_title($attendance_qualify_title)
-	{
-		$this->attendance_qualify_title = $attendance_qualify_title;
-	}
-
-	public function set_attendance_weight($attendance_weight)
-	{
-		$this->attendance_weight = $attendance_weight;
-	}
-
-	/** Getters for fields of attendances tables **/
-	public function get_session_id()
-	{
-		return $this->session_id;
-	}
-
-	public function get_course_id()
-	{
-		return $this->course_id;
-	}
-
-	public function get_date_time()
-	{
-		return $this->date_time;
-	}
-
-	public function get_name()
-	{
-		return $this->name;
-	}
-
-	public function get_description()
-	{
-		return $this->description;
-	}
-
-	public function get_attendance_qualify_title()
-	{
-		return $this->attendance_qualify_title;
-	}
-
-	public function get_attendance_weight()
-	{
-		return $this->attendance_weight;
-	}
-
-	/**
-	 * @param string $startDate in UTC time
-	 * @param string $endDate in UTC time
-	 *
-	 * @return array
-	 */
-	public function getAttendanceLogin($startDate, $endDate)
-	{
+            Database::query($sql);
+
+            $this->deleteAttendanceCalendarGroup($calendar_id, $course_id);
+            $affected_rows++;
+        }
+
+        // update users' results
+        $this->update_users_results($user_ids, $attendance_id);
+
+        return $affected_rows;
+    }
+
+    /** Setters for fields of attendances tables **/
+    public function set_session_id($session_id)
+    {
+        $this->session_id = $session_id;
+    }
+
+    public function set_course_id($course_id)
+    {
+        $this->course_id = $course_id;
+    }
+
+    public function set_date_time($datetime)
+    {
+        $this->date_time = $datetime;
+    }
+
+    public function set_name($name)
+    {
+        $this->name = $name;
+    }
+
+    public function set_description($description)
+    {
+        $this->description = $description;
+    }
+
+    public function set_attendance_qualify_title($attendance_qualify_title)
+    {
+        $this->attendance_qualify_title = $attendance_qualify_title;
+    }
+
+    public function set_attendance_weight($attendance_weight)
+    {
+        $this->attendance_weight = $attendance_weight;
+    }
+
+    /** Getters for fields of attendances tables **/
+    public function get_session_id()
+    {
+        return $this->session_id;
+    }
+
+    public function get_course_id()
+    {
+        return $this->course_id;
+    }
+
+    public function get_date_time()
+    {
+        return $this->date_time;
+    }
+
+    public function get_name()
+    {
+        return $this->name;
+    }
+
+    public function get_description()
+    {
+        return $this->description;
+    }
+
+    public function get_attendance_qualify_title()
+    {
+        return $this->attendance_qualify_title;
+    }
+
+    public function get_attendance_weight()
+    {
+        return $this->attendance_weight;
+    }
+
+    /**
+     * @param string $startDate in UTC time
+     * @param string $endDate in UTC time
+     *
+     * @return array
+     */
+    public function getAttendanceLogin($startDate, $endDate)
+    {
         if (
             empty($startDate) || $startDate == '0000-00-00' || $startDate == '0000-00-00 00:00:00' ||
             empty($endDate) || $endDate == '0000-00-00' || $endDate == '0000-00-00 00:00:00'
-		) {
-			return false;
-		}
+        ) {
+            return false;
+        }
 
-		$sessionId = api_get_session_id();
+        $sessionId = api_get_session_id();
         $courseCode = api_get_course_id();
-		if (!empty($sessionId)) {
-			$users = CourseManager:: get_user_list_from_course_code(
-				$courseCode,
-				$sessionId,
-				'',
-				'lastname',
-				0
-			);
-		} else {
-			$users = CourseManager:: get_user_list_from_course_code(
-				$courseCode,
-				0,
-				'',
-				'lastname',
-				STUDENT
-			);
-		}
-
-		$dateTimeStartOriginal = new DateTime($startDate);
-		$dateTimeStart = new DateTime($startDate);
-		$dateTimeEnd= new DateTime($endDate);
-		$interval = $dateTimeStart->diff($dateTimeEnd);
-		$days = intval($interval->format('%a'));
-
-		$dateList = array($dateTimeStart->format('Y-m-d'));
-		$headers = array(
-			get_lang('User'),
-			$dateTimeStart->format('Y-m-d')
-		);
-
-		for ($i = 0; $i < $days; $i++) {
-			$dateTimeStart = $dateTimeStart->add(new DateInterval('P1D'));
-			$date = $dateTimeStart->format('Y-m-d');
-			$dateList[] = $date;
-			$headers[] = $date;
-		}
-
-		$accessData = CourseManager::getCourseAccessPerCourseAndSession(
-			$courseCode,
-			$sessionId,
-			$dateTimeStartOriginal->format('Y-m-d H:i:s'),
-			$dateTimeEnd->format('Y-m-d H:i:s')
-		);
-
-		$results = array();
-		if (!empty($accessData)) {
-			foreach ($accessData as $data) {
-				$onlyDate = substr($data['login_course_date'], 0, 10);
-				$results[$data['user_id']][$onlyDate] = true;
-			}
-		}
-
-		return array(
-			'users' => $users,
-			'dateList' => $dateList,
-			'headers' => $headers,
-			'results' => $results
-		);
-	}
-
-	/**
-	 * @param string $startDate in UTC time
-	 * @param string $endDate in UTC time
-	 *
-	 * @return string
-	 */
-	public function getAttendanceLoginTable($startDate, $endDate)
-	{
-		$data = $this->getAttendanceLogin($startDate, $endDate);
-
-		if (!$data) {
-			return null;
-		}
-
-		$headers = $data['headers'];
-		$dateList = $data['dateList'];
-		$users = $data['users'];
-		$results = $data['results'];
-
-		$table = new HTML_Table(array('class' => 'data_table'));
-		$row = 0;
-		$column = 0;
-		foreach ($headers as $header) {
-			$table->setHeaderContents($row, $column, $header);
-			$column++;
-		}
-		$row = 1;
-		foreach ($users as $user) {
-			$table->setCellContents(
-				$row,
-				0,
-				$user['lastname'].' '.$user['firstname'].' ('.$user['username'].')'
-			);
-			$row ++;
-		}
-
-		$column = 1;
-		$row = 1;
-		foreach ($users as $user) {
-			foreach ($dateList as $date) {
-				$status = null;
-				if (isset($results[$user['user_id']]) &&
-					isset($results[$user['user_id']][$date])
-				) {
-					$status = 'X';
-				}
-				$table->setCellContents($row, $column, $status);
-				$column++;
-			}
-			$row++;
-			$column = 1;
-		}
-
-		return $table->toHtml();
-	}
-
-	/**
-	 * @param string $startDate in UTC time
-	 * @param string $endDate in UTC time
-	 *
-	 * @return string
-	 */
-	public function exportAttendanceLogin($startDate, $endDate)
-	{
-		$data = $this->getAttendanceLogin($startDate, $endDate);
-
-		if (!$data) {
-			return null;
-		}
-		$users = $data['users'];
-		$results = $data['results'];
-
-		$table = new HTML_Table(array('class' => 'data_table'));
-
-		$table->setHeaderContents(0, 0, get_lang('User'));
-		$table->setHeaderContents(0, 1, get_lang('Date'));
-
-		$row = 1;
-		foreach ($users as $user) {
-			$table->setCellContents(
-				$row,
-				0,
-				$user['lastname'].' '.$user['firstname'].' ('.$user['username'].')'
-			);
-			$row++;
-		}
-		$table->setColAttributes(0, array('style' => 'width:28%'));
-
-		$row = 1;
-		foreach ($users as $user) {
-			if (isset($results[$user['user_id']]) &&
-				!empty($results[$user['user_id']])
-			) {
-				$dates = implode(', ', array_keys($results[$user['user_id']]));
-				$table->setCellContents($row, 1, $dates);
-			}
-			$row++;
-		}
-
-		//$tableToString = null;
-
-		//$sessionInfo = api_get_session_info(api_get_session_id());
-		//if (!empty($sessionInfo)) {
-		/*$tableToString .= '<strong>'.get_lang('PeriodToDisplay').'</strong>: '.
+        if (!empty($sessionId)) {
+            $users = CourseManager:: get_user_list_from_course_code(
+                $courseCode,
+                $sessionId,
+                '',
+                'lastname',
+                0
+            );
+        } else {
+            $users = CourseManager:: get_user_list_from_course_code(
+                $courseCode,
+                0,
+                '',
+                'lastname',
+                STUDENT
+            );
+        }
+
+        $dateTimeStartOriginal = new DateTime($startDate);
+        $dateTimeStart = new DateTime($startDate);
+        $dateTimeEnd= new DateTime($endDate);
+        $interval = $dateTimeStart->diff($dateTimeEnd);
+        $days = intval($interval->format('%a'));
+
+        $dateList = array($dateTimeStart->format('Y-m-d'));
+        $headers = array(
+            get_lang('User'),
+            $dateTimeStart->format('Y-m-d')
+        );
+
+        for ($i = 0; $i < $days; $i++) {
+            $dateTimeStart = $dateTimeStart->add(new DateInterval('P1D'));
+            $date = $dateTimeStart->format('Y-m-d');
+            $dateList[] = $date;
+            $headers[] = $date;
+        }
+
+        $accessData = CourseManager::getCourseAccessPerCourseAndSession(
+            $courseCode,
+            $sessionId,
+            $dateTimeStartOriginal->format('Y-m-d H:i:s'),
+            $dateTimeEnd->format('Y-m-d H:i:s')
+        );
+
+        $results = array();
+        if (!empty($accessData)) {
+            foreach ($accessData as $data) {
+                $onlyDate = substr($data['login_course_date'], 0, 10);
+                $results[$data['user_id']][$onlyDate] = true;
+            }
+        }
+
+        return array(
+            'users' => $users,
+            'dateList' => $dateList,
+            'headers' => $headers,
+            'results' => $results
+        );
+    }
+
+    /**
+     * @param string $startDate in UTC time
+     * @param string $endDate in UTC time
+     *
+     * @return string
+     */
+    public function getAttendanceLoginTable($startDate, $endDate)
+    {
+        $data = $this->getAttendanceLogin($startDate, $endDate);
+
+        if (!$data) {
+            return null;
+        }
+
+        $headers = $data['headers'];
+        $dateList = $data['dateList'];
+        $users = $data['users'];
+        $results = $data['results'];
+
+        $table = new HTML_Table(array('class' => 'data_table'));
+        $row = 0;
+        $column = 0;
+        foreach ($headers as $header) {
+            $table->setHeaderContents($row, $column, $header);
+            $column++;
+        }
+        $row = 1;
+        foreach ($users as $user) {
+            $table->setCellContents(
+                $row,
+                0,
+                $user['lastname'].' '.$user['firstname'].' ('.$user['username'].')'
+            );
+            $row ++;
+        }
+
+        $column = 1;
+        $row = 1;
+        foreach ($users as $user) {
+            foreach ($dateList as $date) {
+                $status = null;
+                if (isset($results[$user['user_id']]) &&
+                    isset($results[$user['user_id']][$date])
+                ) {
+                    $status = 'X';
+                }
+                $table->setCellContents($row, $column, $status);
+                $column++;
+            }
+            $row++;
+            $column = 1;
+        }
+
+        return $table->toHtml();
+    }
+
+    /**
+     * @param string $startDate in UTC time
+     * @param string $endDate in UTC time
+     *
+     * @return string
+     */
+    public function exportAttendanceLogin($startDate, $endDate)
+    {
+        $data = $this->getAttendanceLogin($startDate, $endDate);
+
+        if (!$data) {
+            return null;
+        }
+        $users = $data['users'];
+        $results = $data['results'];
+
+        $table = new HTML_Table(array('class' => 'data_table'));
+
+        $table->setHeaderContents(0, 0, get_lang('User'));
+        $table->setHeaderContents(0, 1, get_lang('Date'));
+
+        $row = 1;
+        foreach ($users as $user) {
+            $table->setCellContents(
+                $row,
+                0,
+                $user['lastname'].' '.$user['firstname'].' ('.$user['username'].')'
+            );
+            $row++;
+        }
+        $table->setColAttributes(0, array('style' => 'width:28%'));
+
+        $row = 1;
+        foreach ($users as $user) {
+            if (isset($results[$user['user_id']]) &&
+                !empty($results[$user['user_id']])
+            ) {
+                $dates = implode(', ', array_keys($results[$user['user_id']]));
+                $table->setCellContents($row, 1, $dates);
+            }
+            $row++;
+        }
+
+        //$tableToString = null;
+
+        //$sessionInfo = api_get_session_info(api_get_session_id());
+        //if (!empty($sessionInfo)) {
+        /*$tableToString .= '<strong>'.get_lang('PeriodToDisplay').'</strong>: '.
 			sprintf(get_lang('FromDateXToDateY'), $startDate, $endDate);*/
-		//}
-
-		$tableToString = $table->toHtml();
-
-		$params = array(
-			'filename' => get_lang('Attendance') . '_' . api_get_utc_datetime(),
-			'pdf_title' => get_lang('Attendance'),
-			'course_code' => api_get_course_id(),
-			'show_real_course_teachers' => true
-		);
-		$pdf = new PDF('A4', null, $params);
-		$pdf->html_to_pdf_with_template($tableToString);
-	}
+        //}
+
+        $tableToString = $table->toHtml();
+
+        $params = array(
+            'filename' => get_lang('Attendance') . '_' . api_get_utc_datetime(),
+            'pdf_title' => get_lang('Attendance'),
+            'course_code' => api_get_course_id(),
+            'show_real_course_teachers' => true
+        );
+        $pdf = new PDF('A4', null, $params);
+        $pdf->html_to_pdf_with_template($tableToString);
+    }
 }

Spacing +60 added lines, -60 removed lines

@@ -73,7 +73,7 @@ 
             $course_id = intval($course_id);
         }
 
-        $session_id = isset($session_id)?intval($session_id):api_get_session_id();
+        $session_id = isset($session_id) ? intval($session_id) : api_get_session_id();
         $condition_session = api_get_session_condition($session_id);
 
         // Get attendance data
@@ -108,7 +108,7 @@ 
 		$from = intval($from);
 		$number_of_items = intval($number_of_items);
 
-		if (!in_array($direction, array('ASC','DESC'))) {
+		if (!in_array($direction, array('ASC', 'DESC'))) {
 			$direction = 'ASC';
 		}
 
@@ -190,8 +190,8 @@ 
 						$attendance[2] = '<span class="muted">'.$attendance[2].'</span>';
 					}
 					if ($allowDelete === 'true') {
-						$actions .= '<a href="index.php?' . api_get_cidreq() . '&action=attendance_delete&attendance_id=' . $attendance[0].'">' .
-							Display::return_icon('delete.png', get_lang('Delete'), array(), ICON_SIZE_SMALL) . '</a>';
+						$actions .= '<a href="index.php?'.api_get_cidreq().'&action=attendance_delete&attendance_id='.$attendance[0].'">'.
+							Display::return_icon('delete.png', get_lang('Delete'), array(), ICON_SIZE_SMALL).'</a>';
 					}
 				} else {
 					$is_locked_attendance = self::is_locked_attendance($attendance[0]);
@@ -211,8 +211,8 @@ 
 							$attendance[2] = '<span class="muted">'.$attendance[2].'</span>';
 						}
 						if ($allowDelete === 'true') {
-							$actions .= ' <a href="index.php?' . api_get_cidreq() . '&action=attendance_delete&attendance_id=' . $attendance[0].'">' .
-								Display::return_icon('delete.png', get_lang('Delete'), array(), ICON_SIZE_SMALL) . '</a>';
+							$actions .= ' <a href="index.php?'.api_get_cidreq().'&action=attendance_delete&attendance_id='.$attendance[0].'">'.
+								Display::return_icon('delete.png', get_lang('Delete'), array(), ICON_SIZE_SMALL).'</a>';
 						}
 					}
 				}
@@ -221,7 +221,7 @@ 
 				$is_done_all_calendar = self::is_all_attendance_calendar_done($attendance[0]);
 
 				if ($is_done_all_calendar) {
-					$locked   = $attendance[4];
+					$locked = $attendance[4];
 					if ($locked == 0) {
 						if (api_is_platform_admin()) {
 							$message_alert = get_lang('AreYouSureToLockTheAttendance');
@@ -241,7 +241,7 @@ 
 				}
 				$actions .= '</center>';
 
-				$attendances[] = array($attendance[0], $attendance[1], $attendance[2], $attendance[3],$actions);
+				$attendances[] = array($attendance[0], $attendance[1], $attendance[2], $attendance[3], $actions);
 			} else {
 				$attendance[0] = '&nbsp;';
 				$attendances[] = array($attendance[0], $attendance[1], $attendance[2], $attendance[3]);
@@ -282,12 +282,12 @@ 
 	public function attendance_add($link_to_gradebook = false)
 	{
 		$_course = api_get_course_info();
-		$tbl_attendance	= Database :: get_course_table(TABLE_ATTENDANCE);
+		$tbl_attendance = Database :: get_course_table(TABLE_ATTENDANCE);
 		$session_id = api_get_session_id();
 		$user_id = api_get_user_id();
 		$course_code = $_course['code'];
 		$course_id = $_course['real_id'];
-		$title_gradebook= $this->attendance_qualify_title;
+		$title_gradebook = $this->attendance_qualify_title;
 		$value_calification = 0;
 		$weight_calification = floatval($this->attendance_weight);
 
@@ -348,7 +348,7 @@ 
                 $gradebookLink->setWeight($weight_calification);
 
                 $em->persist($gradebookLink);
-                $em-flush();
+                $em - flush();
 			}
 		}
 		return $last_id;
@@ -443,12 +443,12 @@ 
 	public function attendance_restore($attendance_id)
 	{
 		$_course = api_get_course_info();
-		$tbl_attendance	= Database :: get_course_table(TABLE_ATTENDANCE);
+		$tbl_attendance = Database :: get_course_table(TABLE_ATTENDANCE);
 		$user_id = api_get_user_id();
 		$course_id = $_course['real_id'];
 		if (is_array($attendance_id)) {
 			foreach ($attendance_id as $id) {
-				$id	= intval($id);
+				$id = intval($id);
 				$sql = "UPDATE $tbl_attendance SET active = 1
 						WHERE c_id = $course_id AND id = '$id'";
 				$result = Database::query($sql);
@@ -464,8 +464,8 @@ 
                     );
 				}
 			}
-		} else  {
-			$attendance_id	= intval($attendance_id);
+		} else {
+			$attendance_id = intval($attendance_id);
 			$sql = "UPDATE $tbl_attendance SET active = 1
 					WHERE c_id = $course_id AND id = '$attendance_id'";
 			$result = Database::query($sql);
@@ -493,13 +493,13 @@ 
 	public function attendance_delete($attendance_id)
 	{
 		$_course = api_get_course_info();
-		$tbl_attendance	= Database :: get_course_table(TABLE_ATTENDANCE);
+		$tbl_attendance = Database :: get_course_table(TABLE_ATTENDANCE);
         $user_id = api_get_user_id();
         $course_id = $_course['real_id'];
 
 		if (is_array($attendance_id)) {
 			foreach ($attendance_id as $id) {
-				$id	= intval($id);
+				$id = intval($id);
 				$sql = "UPDATE $tbl_attendance SET active = 2
 						WHERE c_id = $course_id AND id = '$id'";
 				$result = Database::query($sql);
@@ -515,8 +515,8 @@ 
                     );
 				}
 			}
-		} else  {
-			$attendance_id= intval($attendance_id);
+		} else {
+			$attendance_id = intval($attendance_id);
 			$sql = "UPDATE $tbl_attendance SET active = 2
 					WHERE c_id = $course_id AND id = '$attendance_id'";
 
@@ -547,7 +547,7 @@ 
 	public function changeVisibility($attendanceId, $status = 1)
 	{
 		$_course = api_get_course_info();
-		$tbl_attendance	= Database :: get_course_table(TABLE_ATTENDANCE);
+		$tbl_attendance = Database :: get_course_table(TABLE_ATTENDANCE);
 		$user_id = api_get_user_id();
 		$course_id = $_course['real_id'];
 		$status = intval($status);
@@ -559,7 +559,7 @@ 
 
 		if (is_array($attendanceId)) {
 			foreach ($attendanceId as $id) {
-				$id	= intval($id);
+				$id = intval($id);
 				$sql = "UPDATE $tbl_attendance SET active = $status
 						WHERE c_id = $course_id AND id = '$id'";
 				$result = Database::query($sql);
@@ -569,8 +569,8 @@ 
 					api_item_property_update($_course, TOOL_ATTENDANCE, $id, $action, $user_id);
 				}
 			}
-		} else  {
-			$attendanceId	= intval($attendanceId);
+		} else {
+			$attendanceId = intval($attendanceId);
 			$sql = "UPDATE $tbl_attendance SET active = $status
 					WHERE c_id = $course_id AND id = '$attendanceId'";
 			$result = Database::query($sql);
@@ -600,7 +600,7 @@ 
 		$tbl_attendance = Database::get_course_table(TABLE_ATTENDANCE);
 		$course_id = api_get_course_int_id();
 		$attendance_id = intval($attendance_id);
-		$locked = ($lock)?1:0;
+		$locked = ($lock) ? 1 : 0;
 		$upd = "UPDATE $tbl_attendance SET locked = $locked
 				WHERE c_id = $course_id AND id = $attendance_id";
 		$result = Database::query($upd);
@@ -730,8 +730,8 @@ 
 	 */
 	public function attendance_sheet_add($calendar_id, $users_present, $attendance_id)
 	{
-		$tbl_attendance_sheet 	= Database::get_course_table(TABLE_ATTENDANCE_SHEET);
-		$tbl_attendance_calendar= Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
+		$tbl_attendance_sheet = Database::get_course_table(TABLE_ATTENDANCE_SHEET);
+		$tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
 
 		$calendar_id = intval($calendar_id);
 		$attendance_id = intval($attendance_id);
@@ -739,7 +739,7 @@ 
 		$course_id = api_get_course_int_id();
 
 		$user_ids = array_keys($users);
-		$users_absent = array_diff($user_ids,$users_present);
+		$users_absent = array_diff($user_ids, $users_present);
 		$affected_rows = 0;
 
 		// get last edit type
@@ -1008,8 +1008,8 @@ 
 		$results = array();
 		$calendar_count = self::get_number_of_attendance_calendar($attendance_id, $groupId, NULL, $user_id);
 		// $total_done_attendance 	= $attendance_data['attendance_qualify_max'];
-        $total_done_attendance 	= self::get_number_of_attendance_calendar($attendance_id, $groupId, true, $user_id);
-		$attendance_user_score  = $this->get_user_score($user_id, $attendance_id, $groupId);
+        $total_done_attendance = self::get_number_of_attendance_calendar($attendance_id, $groupId, true, $user_id);
+		$attendance_user_score = $this->get_user_score($user_id, $attendance_id, $groupId);
 
 		//This is the main change of the BT#1381
 		//$total_done_attendance = $calendar_count;
@@ -1022,7 +1022,7 @@ 
         }
 
         $faults = $faults > 0 ? $faults : 0;
-		$faults_porcent = $calendar_count > 0 ?round(($faults*100)/$calendar_count,0):0;
+		$faults_porcent = $calendar_count > 0 ? round(($faults * 100) / $calendar_count, 0) : 0;
         $results['faults'] = $faults;
         $results['total'] = $calendar_count;
         $results['faults_porcent'] = $faults_porcent;
@@ -1056,13 +1056,13 @@ 
 			//$course_code = $course['code'];
 			//$course_info = api_get_course_info($course_code);
 			$course_id = $course['real_id'];
-			$tbl_attendance_result 	= Database::get_course_table(TABLE_ATTENDANCE_RESULT);
+			$tbl_attendance_result = Database::get_course_table(TABLE_ATTENDANCE_RESULT);
 
 			$attendances_by_course = $this->get_attendances_list($course_id);
 
 			foreach ($attendances_by_course as $attendance) {
 				// get total faults and total weight
-				$total_done_attendance 	= $attendance['attendance_qualify_max'];
+				$total_done_attendance = $attendance['attendance_qualify_max'];
 				$sql = "SELECT score
 						FROM $tbl_attendance_result
                         WHERE
@@ -1075,16 +1075,16 @@ 
 					$row = Database::fetch_array($rs);
 					$score = $row['score'];
 				}
-				$faults = $total_done_attendance-$score;
-				$faults = $faults > 0 ? $faults:0;
+				$faults = $total_done_attendance - $score;
+				$faults = $faults > 0 ? $faults : 0;
 				$total_faults += $faults;
 				$total_weight += $total_done_attendance;
 			}
 		}
 
-		$porcent = $total_weight > 0 ?round(($total_faults*100)/$total_weight,0):0;
+		$porcent = $total_weight > 0 ? round(($total_faults * 100) / $total_weight, 0) : 0;
 		$results['faults'] 	= $total_faults;
-		$results['total']	= $total_weight;
+		$results['total'] = $total_weight;
 		$results['porcent'] = $porcent;
 
 		return $results;
@@ -1102,7 +1102,7 @@ 
 	{
 		// Database tables and variables
 		$course_info = api_get_course_info($course_code);
-		$tbl_attendance_result 	= Database::get_course_table(TABLE_ATTENDANCE_RESULT);
+		$tbl_attendance_result = Database::get_course_table(TABLE_ATTENDANCE_RESULT);
 		$user_id = intval($user_id);
 		$results = array();
 		$total_faults = $total_weight = $porcent = 0;
@@ -1110,7 +1110,7 @@ 
 
 		foreach ($attendances_by_course as $attendance) {
 			// Get total faults and total weight
-			$total_done_attendance 	= $attendance['attendance_qualify_max'];
+			$total_done_attendance = $attendance['attendance_qualify_max'];
 			$sql = "SELECT score FROM $tbl_attendance_result
 					WHERE
 						c_id = {$course_info['real_id']} AND
@@ -1122,15 +1122,15 @@ 
 				$row = Database::fetch_array($rs);
 				$score = $row['score'];
 			}
-			$faults = $total_done_attendance-$score;
-			$faults = $faults > 0 ? $faults:0;
+			$faults = $total_done_attendance - $score;
+			$faults = $faults > 0 ? $faults : 0;
 			$total_faults += $faults;
 			$total_weight += $total_done_attendance;
 		}
 
-		$porcent = $total_weight > 0 ?round(($total_faults*100)/$total_weight,0):0;
+		$porcent = $total_weight > 0 ? round(($total_faults * 100) / $total_weight, 0) : 0;
 		$results['faults'] 	= $total_faults;
-		$results['total']	= $total_weight;
+		$results['total'] = $total_weight;
 		$results['porcent'] = $porcent;
 
 		return $results;
@@ -1144,8 +1144,8 @@ 
 	 */
 	public function get_users_attendance_sheet($attendance_id, $user_id = 0, $groupId = null)
 	{
-		$tbl_attendance_sheet 	= Database::get_course_table(TABLE_ATTENDANCE_SHEET);
-		$tbl_attendance_calendar= Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
+		$tbl_attendance_sheet = Database::get_course_table(TABLE_ATTENDANCE_SHEET);
+		$tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
 
 		$attendance_calendar = $this->get_attendance_calendar($attendance_id, 'all', null, $groupId);
 		$calendar_ids = array();
@@ -1167,7 +1167,7 @@ 
 					        WHERE
 					        	c_id = $course_id AND
 					        	user_id = '$uid' AND
-					        	attendance_calendar_id IN(".implode(',',$calendar_ids).")
+					        	attendance_calendar_id IN(".implode(',', $calendar_ids).")
 							";
 					$res = Database::query($sql);
 					if (Database::num_rows($res) > 0) {
@@ -1189,7 +1189,7 @@ 
 							att.c_id = $course_id AND
 							cal.c_id =  $course_id AND
 							att.user_id = '$user_id' AND
-							att.attendance_calendar_id IN (".implode(',',$calendar_ids).")
+							att.attendance_calendar_id IN (".implode(',', $calendar_ids).")
                         ORDER BY date_time";
 				$res = Database::query($sql);
 				if (Database::num_rows($res) > 0) {
@@ -1267,7 +1267,7 @@ 
 	 */
 	public function get_user_score($user_id, $attendance_id, $groupId = null)
 	{
-		$tbl_attendance_result 	= Database::get_course_table(TABLE_ATTENDANCE_RESULT);
+		$tbl_attendance_result = Database::get_course_table(TABLE_ATTENDANCE_RESULT);
         $tbl_attendance_sheet = Database::get_course_table(TABLE_ATTENDANCE_SHEET);
         $tbl_attendance_cal_rel_group = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR_REL_GROUP);
         $tbl_attendance_cal = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
@@ -1381,7 +1381,7 @@ 
                    ";
 		}
 
-		if (!in_array($type, array('today', 'all', 'all_done', 'all_not_done','calendar_id'))) {
+		if (!in_array($type, array('today', 'all', 'all_done', 'all_not_done', 'calendar_id'))) {
 			$type = 'all';
 		}
 
@@ -1389,7 +1389,7 @@ 
 			case 'calendar_id':
 				$calendar_id = intval($calendar_id);
 				if (!empty($calendar_id)) {
-					$sql.= " AND c.id = $calendar_id";
+					$sql .= " AND c.id = $calendar_id";
 				}
 				break;
 			case 'today':
@@ -1410,7 +1410,7 @@ 
 		$rs = Database::query($sql);
 		$data = array();
 		if (Database::num_rows($rs) > 0) {
-			while ($row = Database::fetch_array($rs,'ASSOC')) {
+			while ($row = Database::fetch_array($rs, 'ASSOC')) {
 				$row['db_date_time'] = $row['date_time'];
 				$row['date_time'] = api_get_local_time($row['date_time']);
 				$row['date'] = api_format_date($row['date_time'], DATE_FORMAT_SHORT);
@@ -1775,14 +1775,14 @@ 
 	 * @param   int     The number of years to add
 	 * @return  int     The new timestamp
 	 */
-	private function add_month($timestamp, $num=1)
+	private function add_month($timestamp, $num = 1)
 	{
 		$values = api_get_utc_datetime($timestamp);
-		$values = str_replace(array(':','-',' '), '/', $values);
-		list($y, $m, $d, $h, $n, $s) = split('/',$values);
-		if($m+$num>12) {
-			$y += floor($num/12);
-			$m += $num%12;
+		$values = str_replace(array(':', '-', ' '), '/', $values);
+		list($y, $m, $d, $h, $n, $s) = split('/', $values);
+		if ($m + $num > 12) {
+			$y += floor($num / 12);
+			$m += $num % 12;
 		} else {
 			$m += $num;
 		}
@@ -1840,7 +1840,7 @@ 
 	 * @param	bool	true for removing all calendar inside current attendance, false for removing by calendar id
 	 * @return	int affected rows
 	 */
-	public function attendance_calendar_delete($calendar_id, $attendance_id , $all_delete = false)
+	public function attendance_calendar_delete($calendar_id, $attendance_id, $all_delete = false)
 	{
 		$tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);
 		$tbl_attendance_sheet = Database::get_course_table(TABLE_ATTENDANCE_SHEET);
@@ -1998,7 +1998,7 @@ 
 
 		$dateTimeStartOriginal = new DateTime($startDate);
 		$dateTimeStart = new DateTime($startDate);
-		$dateTimeEnd= new DateTime($endDate);
+		$dateTimeEnd = new DateTime($endDate);
 		$interval = $dateTimeStart->diff($dateTimeEnd);
 		$days = intval($interval->format('%a'));
 
@@ -2071,7 +2071,7 @@ 
 				0,
 				$user['lastname'].' '.$user['firstname'].' ('.$user['username'].')'
 			);
-			$row ++;
+			$row++;
 		}
 
 		$column = 1;
@@ -2148,7 +2148,7 @@ 
 		$tableToString = $table->toHtml();
 
 		$params = array(
-			'filename' => get_lang('Attendance') . '_' . api_get_utc_datetime(),
+			'filename' => get_lang('Attendance').'_'.api_get_utc_datetime(),
 			'pdf_title' => get_lang('Attendance'),
 			'course_code' => api_get_course_id(),
 			'show_real_course_teachers' => true