chamilo / chamilo-lms

main/inc/lib/internationalization_database/transliteration/x02.php

Indentation +1 added lines, -1 removed lines

@@ -2,7 +2,7 @@
 // $Id: x02.php,v 1.1.8.1 2008/06/12 20:34:31 smk Exp $
 
 return array(
-  'en' => array('A', 'a', 'A', 'a', 'E', 'e', 'E', 'e', 'I', 'i', 'I', 'i', 'O', 'o', 'O', 'o',
+    'en' => array('A', 'a', 'A', 'a', 'E', 'e', 'E', 'e', 'I', 'i', 'I', 'i', 'O', 'o', 'O', 'o',
     'R', 'r', 'R', 'r', 'U', 'u', 'U', 'u', 'S', 's', 'T', 't', 'Y', 'y', 'H', 'h',
     'N', 'd', 'OU', 'ou', 'Z', 'z', 'A', 'a', 'E', 'e', 'O', 'o', 'O', 'o', 'O', 'o',
     'O', 'o', 'Y', 'y', 'l', 'n', 't', 'j', 'db', 'qp', 'A', 'C', 'c', 'L', 'T', 's',

main/inc/lib/internationalization_database/transliteration/x16.php

Indentation +1 added lines, -1 removed lines

@@ -2,7 +2,7 @@
 // $Id: x16.php,v 1.1.8.1 2008/06/12 20:34:31 smk Exp $
 
 return array(
-  'en' => array('kka', 'kk', 'nu', 'no', 'ne', 'nee', 'ni', 'na', 'mu', 'mo', 'me', 'mee', 'mi', 'ma', 'yu', 'yo',
+    'en' => array('kka', 'kk', 'nu', 'no', 'ne', 'nee', 'ni', 'na', 'mu', 'mo', 'me', 'mee', 'mi', 'ma', 'yu', 'yo',
     'ye', 'yee', 'yi', 'ya', 'ju', 'ju', 'jo', 'je', 'jee', 'ji', 'ji', 'ja', 'jju', 'jjo', 'jje', 'jjee',
     'jji', 'jja', 'lu', 'lo', 'le', 'lee', 'li', 'la', 'dlu', 'dlo', 'dle', 'dlee', 'dli', 'dla', 'lhu', 'lho',
     'lhe', 'lhee', 'lhi', 'lha', 'tlhu', 'tlho', 'tlhe', 'tlhee', 'tlhi', 'tlha', 'tlu', 'tlo', 'tle', 'tlee', 'tli', 'tla',

main/inc/lib/internationalization_database/transliteration/x6c.php

Indentation +1 added lines, -1 removed lines

@@ -2,7 +2,7 @@
 // $Id: x6c.php,v 1.1.8.1 2008/06/12 20:34:31 smk Exp $
 
 return array(
-  'en' => array('Lu ', 'Mu ', 'Li ', 'Tong ', 'Rong ', 'Chang ', 'Pu ', 'Luo ', 'Zhan ', 'Sao ', 'Zhan ', 'Meng ', 'Luo ', 'Qu ', 'Die ', 'Shi ',
+    'en' => array('Lu ', 'Mu ', 'Li ', 'Tong ', 'Rong ', 'Chang ', 'Pu ', 'Luo ', 'Zhan ', 'Sao ', 'Zhan ', 'Meng ', 'Luo ', 'Qu ', 'Die ', 'Shi ',
     'Di ', 'Min ', 'Jue ', 'Mang ', 'Qi ', 'Pie ', 'Nai ', 'Qi ', 'Dao ', 'Xian ', 'Chuan ', 'Fen ', 'Ri ', 'Nei ', NULL, 'Fu ',
     'Shen ', 'Dong ', 'Qing ', 'Qi ', 'Yin ', 'Xi ', 'Hai ', 'Yang ', 'An ', 'Ya ', 'Ke ', 'Qing ', 'Ya ', 'Dong ', 'Dan ', 'Lu ',
     'Qing ', 'Yang ', 'Yun ', 'Yun ', 'Shui ', 'San ', 'Zheng ', 'Bing ', 'Yong ', 'Dang ', 'Shitamizu ', 'Le ', 'Ni ', 'Tun ', 'Fan ', 'Gui ',

main/inc/lib/internationalization_database/transliteration/xb8.php

Indentation +1 added lines, -1 removed lines

@@ -2,7 +2,7 @@
 // $Id: xb8.php,v 1.1.8.1 2008/06/12 20:34:32 smk Exp $
 
 return array(
-  'en' => array('reoss', 'reong', 'reoj', 'reoc', 'reok', 'reot', 'reop', 'reoh', 're', 'reg', 'regg', 'regs', 'ren', 'renj', 'renh', 'red',
+    'en' => array('reoss', 'reong', 'reoj', 'reoc', 'reok', 'reot', 'reop', 'reoh', 're', 'reg', 'regg', 'regs', 'ren', 'renj', 'renh', 'red',
     'rel', 'relg', 'relm', 'relb', 'rels', 'relt', 'relp', 'relh', 'rem', 'reb', 'rebs', 'res', 'ress', 'reng', 'rej', 'rec',
     'rek', 'ret', 'rep', 'reh', 'ryeo', 'ryeog', 'ryeogg', 'ryeogs', 'ryeon', 'ryeonj', 'ryeonh', 'ryeod', 'ryeol', 'ryeolg', 'ryeolm', 'ryeolb',
     'ryeols', 'ryeolt', 'ryeolp', 'ryeolh', 'ryeom', 'ryeob', 'ryeobs', 'ryeos', 'ryeoss', 'ryeong', 'ryeoj', 'ryeoc', 'ryeok', 'ryeot', 'ryeop', 'ryeoh',

main/inc/lib/internationalization_database/transliteration/xbd.php

Indentation +1 added lines, -1 removed lines

@@ -2,7 +2,7 @@
 // $Id: xbd.php,v 1.1.8.1 2008/06/12 20:34:32 smk Exp $
 
 return array(
-  'en' => array('bols', 'bolt', 'bolp', 'bolh', 'bom', 'bob', 'bobs', 'bos', 'boss', 'bong', 'boj', 'boc', 'bok', 'bot', 'bop', 'boh',
+    'en' => array('bols', 'bolt', 'bolp', 'bolh', 'bom', 'bob', 'bobs', 'bos', 'boss', 'bong', 'boj', 'boc', 'bok', 'bot', 'bop', 'boh',
     'bwa', 'bwag', 'bwagg', 'bwags', 'bwan', 'bwanj', 'bwanh', 'bwad', 'bwal', 'bwalg', 'bwalm', 'bwalb', 'bwals', 'bwalt', 'bwalp', 'bwalh',
     'bwam', 'bwab', 'bwabs', 'bwas', 'bwass', 'bwang', 'bwaj', 'bwac', 'bwak', 'bwat', 'bwap', 'bwah', 'bwae', 'bwaeg', 'bwaegg', 'bwaegs',
     'bwaen', 'bwaenj', 'bwaenh', 'bwaed', 'bwael', 'bwaelg', 'bwaelm', 'bwaelb', 'bwaels', 'bwaelt', 'bwaelp', 'bwaelh', 'bwaem', 'bwaeb', 'bwaebs', 'bwaes',

main/inc/lib/getid3/module.audio-video.flv.php

Indentation +401 added lines, -401 removed lines

@@ -39,12 +39,12 @@ 
 //
 // $Id: module.audio-video.flv.php,v 1.7 2006/11/10 11:20:12 ah Exp $
 /**
- * @package chamilo.include.flv
- */
+     * @package chamilo.include.flv
+     */
 /**
- * Class
- * @package chamilo.include.flv
- */
+     * Class
+     * @package chamilo.include.flv
+     */
 class getid3_flv extends getid3_handler {
 
     const TAG_AUDIO    =  8;
@@ -56,522 +56,522 @@ 
     const VIDEO_VP6    = 4;
 
 
-	public function Analyze()
-	{
-	    $info = &$this->getid3->info;
+    public function Analyze()
+    {
+        $info = &$this->getid3->info;
 
-	    $info['flv'] = array ();
-	    $info_flv = &$info['flv'];
+        $info['flv'] = array ();
+        $info_flv = &$info['flv'];
 
-		fseek($this->getid3->fp, $info['avdataoffset'], SEEK_SET);
+        fseek($this->getid3->fp, $info['avdataoffset'], SEEK_SET);
 
-		$flv_data_length = $info['avdataend'] - $info['avdataoffset'];
-		$flv_header = fread($this->getid3->fp, 5);
-
-		$info['fileformat'] = 'flv';
-		$info_flv['header']['signature'] =                           substr($flv_header, 0, 3);
-		$info_flv['header']['version']   = getid3_lib::BigEndian2Int(substr($flv_header, 3, 1));
-		$type_flags                      = getid3_lib::BigEndian2Int(substr($flv_header, 4, 1));
+        $flv_data_length = $info['avdataend'] - $info['avdataoffset'];
+        $flv_header = fread($this->getid3->fp, 5);
+
+        $info['fileformat'] = 'flv';
+        $info_flv['header']['signature'] =                           substr($flv_header, 0, 3);
+        $info_flv['header']['version']   = getid3_lib::BigEndian2Int(substr($flv_header, 3, 1));
+        $type_flags                      = getid3_lib::BigEndian2Int(substr($flv_header, 4, 1));
 
-		$info_flv['header']['hasAudio'] = (bool) ($type_flags & 0x04);
-		$info_flv['header']['hasVideo'] = (bool) ($type_flags & 0x01);
+        $info_flv['header']['hasAudio'] = (bool) ($type_flags & 0x04);
+        $info_flv['header']['hasVideo'] = (bool) ($type_flags & 0x01);
 
-		$frame_size_data_length = getid3_lib::BigEndian2Int(fread($this->getid3->fp, 4));
-		$flv_header_frame_length = 9;
-		if ($frame_size_data_length > $flv_header_frame_length) {
-			fseek($this->getid3->fp, $frame_size_data_length - $flv_header_frame_length, SEEK_CUR);
-		}
-
-		$duration = 0;
-		while ((ftell($this->getid3->fp) + 1) < $info['avdataend']) {
-
-			$this_tag_header = fread($this->getid3->fp, 16);
-
-			$previous_tag_length = getid3_lib::BigEndian2Int(substr($this_tag_header,  0, 4));
-			$tag_type            = getid3_lib::BigEndian2Int(substr($this_tag_header,  4, 1));
-			$data_length         = getid3_lib::BigEndian2Int(substr($this_tag_header,  5, 3));
-			$timestamp           = getid3_lib::BigEndian2Int(substr($this_tag_header,  8, 3));
-			$last_header_byte    = getid3_lib::BigEndian2Int(substr($this_tag_header, 15, 1));
-			$next_offset         = ftell($this->getid3->fp) - 1 + $data_length;
-
-			switch ($tag_type) {
-
-				case getid3_flv::TAG_AUDIO:
-					if (!isset($info_flv['audio']['audioFormat'])) {
-						$info_flv['audio']['audioFormat']     =  $last_header_byte & 0x07;
-						$info_flv['audio']['audioRate']       = ($last_header_byte & 0x30) / 0x10;
-						$info_flv['audio']['audioSampleSize'] = ($last_header_byte & 0x40) / 0x40;
-						$info_flv['audio']['audioType']       = ($last_header_byte & 0x80) / 0x80;
-					}
-					break;
-
-
-				case getid3_flv::TAG_VIDEO:
-					if (!isset($info_flv['video']['videoCodec'])) {
-						$info_flv['video']['videoCodec'] = $last_header_byte & 0x07;
-
-						$flv_video_header = fread($this->getid3->fp, 11);
-
-						if ($info_flv['video']['videoCodec'] != getid3_flv::VIDEO_VP6) {
-
-							$picture_size_type = (getid3_lib::BigEndian2Int(substr($flv_video_header, 3, 2))) >> 7;
-							$picture_size_type = $picture_size_type & 0x0007;
-							$info_flv['header']['videoSizeType'] = $picture_size_type;
-
-							switch ($picture_size_type) {
-								case 0:
-									$picture_size_enc = getid3_lib::BigEndian2Int(substr($flv_video_header, 5, 2));
-									$picture_size_enc <<= 1;
-									$info['video']['resolution_x'] = ($picture_size_enc & 0xFF00) >> 8;
-									$picture_size_enc = getid3_lib::BigEndian2Int(substr($flv_video_header, 6, 2));
-									$picture_size_enc <<= 1;
-									$info['video']['resolution_y'] = ($picture_size_enc & 0xFF00) >> 8;
-									break;
-
-								case 1:
-									$picture_size_enc = getid3_lib::BigEndian2Int(substr($flv_video_header, 5, 4));
-									$picture_size_enc <<= 1;
-									$info['video']['resolution_x'] = ($picture_size_enc & 0xFFFF0000) >> 16;
-
-									$picture_size_enc = getid3_lib::BigEndian2Int(substr($flv_video_header, 7, 4));
-									$picture_size_enc <<= 1;
-									$info['video']['resolution_y'] = ($picture_size_enc & 0xFFFF0000) >> 16;
-									break;
-
-								case 2:
-									$info['video']['resolution_x'] = 352;
-									$info['video']['resolution_y'] = 288;
-									break;
-
-								case 3:
-									$info['video']['resolution_x'] = 176;
-									$info['video']['resolution_y'] = 144;
-									break;
-
-								case 4:
-									$info['video']['resolution_x'] = 128;
-									$info['video']['resolution_y'] = 96;
-									break;
-
-								case 5:
-									$info['video']['resolution_x'] = 320;
-									$info['video']['resolution_y'] = 240;
-									break;
-
-								case 6:
-									$info['video']['resolution_x'] = 160;
-									$info['video']['resolution_y'] = 120;
-									break;
-
-								default:
-									$info['video']['resolution_x'] = 0;
-									$info['video']['resolution_y'] = 0;
-									break;
-							}
-						}
-					}
-					break;
-
-
-				// Meta tag
-				case getid3_flv::TAG_META:
-
-					fseek($this->getid3->fp, -1, SEEK_CUR);
-					$reader = new AMFReader(new AMFStream(fread($this->getid3->fp, $data_length)));
-					$event_name = $reader->readData();
-					$info['meta'][$event_name] = $reader->readData();
-					unset($reader);
-
-					$info['video']['frame_rate']   = @$info['meta']['onMetaData']['framerate'];
-					$info['video']['resolution_x'] = @$info['meta']['onMetaData']['width'];
-					$info['video']['resolution_y'] = @$info['meta']['onMetaData']['height'];
-					break;
-
-				default:
-					// noop
-					break;
-			}
-
-			if ($timestamp > $duration) {
-				$duration = $timestamp;
-			}
-
-			fseek($this->getid3->fp, $next_offset, SEEK_SET);
-		}
-
-		if ($info['playtime_seconds'] = $duration / 1000) {
-		    $info['bitrate'] = ($info['avdataend'] - $info['avdataoffset']) / $info['playtime_seconds'];
-		}
-
-		if ($info_flv['header']['hasAudio']) {
-			$info['audio']['codec']           = $this->FLVaudioFormat($info_flv['audio']['audioFormat']);
-			$info['audio']['sample_rate']     = $this->FLVaudioRate($info_flv['audio']['audioRate']);
-			$info['audio']['bits_per_sample'] = $this->FLVaudioBitDepth($info_flv['audio']['audioSampleSize']);
-
-			$info['audio']['channels']   = $info_flv['audio']['audioType'] + 1; // 0=mono,1=stereo
-			$info['audio']['lossless']   = ($info_flv['audio']['audioFormat'] ? false : true); // 0=uncompressed
-			$info['audio']['dataformat'] = 'flv';
-		}
-		if (@$info_flv['header']['hasVideo']) {
-			$info['video']['codec']      = $this->FLVvideoCodec($info_flv['video']['videoCodec']);
-			$info['video']['dataformat'] = 'flv';
-			$info['video']['lossless']   = false;
-		}
-
-		return true;
-	}
-
-
-	public static function FLVaudioFormat($id) {
-
-		static $lookup = array(
-			0 => 'uncompressed',
-			1 => 'ADPCM',
-			2 => 'mp3',
-			5 => 'Nellymoser 8kHz mono',
-			6 => 'Nellymoser',
-		);
-		return (@$lookup[$id] ? @$lookup[$id] : false);
-	}
-
-
-	public static function FLVaudioRate($id) {
-
-		static $lookup = array(
-			0 =>  5500,
-			1 => 11025,
-			2 => 22050,
-			3 => 44100,
-		);
-		return (@$lookup[$id] ? @$lookup[$id] : false);
-	}
-
-
-	public static function FLVaudioBitDepth($id) {
-
-		static $lookup = array(
-			0 =>  8,
-			1 => 16,
-		);
-		return (@$lookup[$id] ? @$lookup[$id] : false);
-	}
-
-
-	public static function FLVvideoCodec($id) {
-
-		static $lookup = array(
-			getid3_flv::VIDEO_H263   => 'Sorenson H.263',
-			getid3_flv::VIDEO_SCREEN => 'Screen video',
-			getid3_flv::VIDEO_VP6    => 'On2 VP6',
-		);
-		return (@$lookup[$id] ? @$lookup[$id] : false);
-	}
+        $frame_size_data_length = getid3_lib::BigEndian2Int(fread($this->getid3->fp, 4));
+        $flv_header_frame_length = 9;
+        if ($frame_size_data_length > $flv_header_frame_length) {
+            fseek($this->getid3->fp, $frame_size_data_length - $flv_header_frame_length, SEEK_CUR);
+        }
+
+        $duration = 0;
+        while ((ftell($this->getid3->fp) + 1) < $info['avdataend']) {
+
+            $this_tag_header = fread($this->getid3->fp, 16);
+
+            $previous_tag_length = getid3_lib::BigEndian2Int(substr($this_tag_header,  0, 4));
+            $tag_type            = getid3_lib::BigEndian2Int(substr($this_tag_header,  4, 1));
+            $data_length         = getid3_lib::BigEndian2Int(substr($this_tag_header,  5, 3));
+            $timestamp           = getid3_lib::BigEndian2Int(substr($this_tag_header,  8, 3));
+            $last_header_byte    = getid3_lib::BigEndian2Int(substr($this_tag_header, 15, 1));
+            $next_offset         = ftell($this->getid3->fp) - 1 + $data_length;
+
+            switch ($tag_type) {
+
+                case getid3_flv::TAG_AUDIO:
+                    if (!isset($info_flv['audio']['audioFormat'])) {
+                        $info_flv['audio']['audioFormat']     =  $last_header_byte & 0x07;
+                        $info_flv['audio']['audioRate']       = ($last_header_byte & 0x30) / 0x10;
+                        $info_flv['audio']['audioSampleSize'] = ($last_header_byte & 0x40) / 0x40;
+                        $info_flv['audio']['audioType']       = ($last_header_byte & 0x80) / 0x80;
+                    }
+                    break;
+
+
+                case getid3_flv::TAG_VIDEO:
+                    if (!isset($info_flv['video']['videoCodec'])) {
+                        $info_flv['video']['videoCodec'] = $last_header_byte & 0x07;
+
+                        $flv_video_header = fread($this->getid3->fp, 11);
+
+                        if ($info_flv['video']['videoCodec'] != getid3_flv::VIDEO_VP6) {
+
+                            $picture_size_type = (getid3_lib::BigEndian2Int(substr($flv_video_header, 3, 2))) >> 7;
+                            $picture_size_type = $picture_size_type & 0x0007;
+                            $info_flv['header']['videoSizeType'] = $picture_size_type;
+
+                            switch ($picture_size_type) {
+                                case 0:
+                                    $picture_size_enc = getid3_lib::BigEndian2Int(substr($flv_video_header, 5, 2));
+                                    $picture_size_enc <<= 1;
+                                    $info['video']['resolution_x'] = ($picture_size_enc & 0xFF00) >> 8;
+                                    $picture_size_enc = getid3_lib::BigEndian2Int(substr($flv_video_header, 6, 2));
+                                    $picture_size_enc <<= 1;
+                                    $info['video']['resolution_y'] = ($picture_size_enc & 0xFF00) >> 8;
+                                    break;
+
+                                case 1:
+                                    $picture_size_enc = getid3_lib::BigEndian2Int(substr($flv_video_header, 5, 4));
+                                    $picture_size_enc <<= 1;
+                                    $info['video']['resolution_x'] = ($picture_size_enc & 0xFFFF0000) >> 16;
+
+                                    $picture_size_enc = getid3_lib::BigEndian2Int(substr($flv_video_header, 7, 4));
+                                    $picture_size_enc <<= 1;
+                                    $info['video']['resolution_y'] = ($picture_size_enc & 0xFFFF0000) >> 16;
+                                    break;
+
+                                case 2:
+                                    $info['video']['resolution_x'] = 352;
+                                    $info['video']['resolution_y'] = 288;
+                                    break;
+
+                                case 3:
+                                    $info['video']['resolution_x'] = 176;
+                                    $info['video']['resolution_y'] = 144;
+                                    break;
+
+                                case 4:
+                                    $info['video']['resolution_x'] = 128;
+                                    $info['video']['resolution_y'] = 96;
+                                    break;
+
+                                case 5:
+                                    $info['video']['resolution_x'] = 320;
+                                    $info['video']['resolution_y'] = 240;
+                                    break;
+
+                                case 6:
+                                    $info['video']['resolution_x'] = 160;
+                                    $info['video']['resolution_y'] = 120;
+                                    break;
+
+                                default:
+                                    $info['video']['resolution_x'] = 0;
+                                    $info['video']['resolution_y'] = 0;
+                                    break;
+                            }
+                        }
+                    }
+                    break;
+
+
+                // Meta tag
+                case getid3_flv::TAG_META:
+
+                    fseek($this->getid3->fp, -1, SEEK_CUR);
+                    $reader = new AMFReader(new AMFStream(fread($this->getid3->fp, $data_length)));
+                    $event_name = $reader->readData();
+                    $info['meta'][$event_name] = $reader->readData();
+                    unset($reader);
+
+                    $info['video']['frame_rate']   = @$info['meta']['onMetaData']['framerate'];
+                    $info['video']['resolution_x'] = @$info['meta']['onMetaData']['width'];
+                    $info['video']['resolution_y'] = @$info['meta']['onMetaData']['height'];
+                    break;
+
+                default:
+                    // noop
+                    break;
+            }
+
+            if ($timestamp > $duration) {
+                $duration = $timestamp;
+            }
+
+            fseek($this->getid3->fp, $next_offset, SEEK_SET);
+        }
+
+        if ($info['playtime_seconds'] = $duration / 1000) {
+            $info['bitrate'] = ($info['avdataend'] - $info['avdataoffset']) / $info['playtime_seconds'];
+        }
+
+        if ($info_flv['header']['hasAudio']) {
+            $info['audio']['codec']           = $this->FLVaudioFormat($info_flv['audio']['audioFormat']);
+            $info['audio']['sample_rate']     = $this->FLVaudioRate($info_flv['audio']['audioRate']);
+            $info['audio']['bits_per_sample'] = $this->FLVaudioBitDepth($info_flv['audio']['audioSampleSize']);
+
+            $info['audio']['channels']   = $info_flv['audio']['audioType'] + 1; // 0=mono,1=stereo
+            $info['audio']['lossless']   = ($info_flv['audio']['audioFormat'] ? false : true); // 0=uncompressed
+            $info['audio']['dataformat'] = 'flv';
+        }
+        if (@$info_flv['header']['hasVideo']) {
+            $info['video']['codec']      = $this->FLVvideoCodec($info_flv['video']['videoCodec']);
+            $info['video']['dataformat'] = 'flv';
+            $info['video']['lossless']   = false;
+        }
+
+        return true;
+    }
+
+
+    public static function FLVaudioFormat($id) {
+
+        static $lookup = array(
+            0 => 'uncompressed',
+            1 => 'ADPCM',
+            2 => 'mp3',
+            5 => 'Nellymoser 8kHz mono',
+            6 => 'Nellymoser',
+        );
+        return (@$lookup[$id] ? @$lookup[$id] : false);
+    }
+
+
+    public static function FLVaudioRate($id) {
+
+        static $lookup = array(
+            0 =>  5500,
+            1 => 11025,
+            2 => 22050,
+            3 => 44100,
+        );
+        return (@$lookup[$id] ? @$lookup[$id] : false);
+    }
+
+
+    public static function FLVaudioBitDepth($id) {
+
+        static $lookup = array(
+            0 =>  8,
+            1 => 16,
+        );
+        return (@$lookup[$id] ? @$lookup[$id] : false);
+    }
+
+
+    public static function FLVvideoCodec($id) {
+
+        static $lookup = array(
+            getid3_flv::VIDEO_H263   => 'Sorenson H.263',
+            getid3_flv::VIDEO_SCREEN => 'Screen video',
+            getid3_flv::VIDEO_VP6    => 'On2 VP6',
+        );
+        return (@$lookup[$id] ? @$lookup[$id] : false);
+    }
 }
 
 
 
 class AMFStream
 {
-	public $bytes;
-	public $pos;
+    public $bytes;
+    public $pos;
 
 
-	public function AMFStream($bytes) {
+    public function AMFStream($bytes) {
 
-		$this->bytes = $bytes;
-		$this->pos = 0;
-	}
+        $this->bytes = $bytes;
+        $this->pos = 0;
+    }
 
 
-	public function readByte() {
+    public function readByte() {
 
-		return getid3_lib::BigEndian2Int(substr($this->bytes, $this->pos++, 1));
-	}
+        return getid3_lib::BigEndian2Int(substr($this->bytes, $this->pos++, 1));
+    }
 
 
-	public function readInt() {
+    public function readInt() {
 
-		return ($this->readByte() << 8) + $this->readByte();
-	}
+        return ($this->readByte() << 8) + $this->readByte();
+    }
 
 
-	public function readLong() {
+    public function readLong() {
 
-		return ($this->readByte() << 24) + ($this->readByte() << 16) + ($this->readByte() << 8) + $this->readByte();
-	}
+        return ($this->readByte() << 24) + ($this->readByte() << 16) + ($this->readByte() << 8) + $this->readByte();
+    }
 
 
-	public function readDouble() {
+    public function readDouble() {
 
-		return getid3_lib::BigEndian2Float($this->read(8));
-	}
+        return getid3_lib::BigEndian2Float($this->read(8));
+    }
 
 
-	public function readUTF() {
+    public function readUTF() {
 
-		$length = $this->readInt();
-		return $this->read($length);
-	}
+        $length = $this->readInt();
+        return $this->read($length);
+    }
 
 
-	public function readLongUTF() {
+    public function readLongUTF() {
 
-		$length = $this->readLong();
-		return $this->read($length);
-	}
+        $length = $this->readLong();
+        return $this->read($length);
+    }
 
 
-	public function read($length) {
+    public function read($length) {
 
-		$val = substr($this->bytes, $this->pos, $length);
-		$this->pos += $length;
-		return $val;
-	}
+        $val = substr($this->bytes, $this->pos, $length);
+        $this->pos += $length;
+        return $val;
+    }
 
 
-	public function peekByte() {
+    public function peekByte() {
 
-		$pos = $this->pos;
-		$val = $this->readByte();
-		$this->pos = $pos;
-		return $val;
-	}
+        $pos = $this->pos;
+        $val = $this->readByte();
+        $this->pos = $pos;
+        return $val;
+    }
 
 
-	public function peekInt() {
+    public function peekInt() {
 
-		$pos = $this->pos;
-		$val = $this->readInt();
-		$this->pos = $pos;
-		return $val;
-	}
+        $pos = $this->pos;
+        $val = $this->readInt();
+        $this->pos = $pos;
+        return $val;
+    }
 
 
-	public function peekLong() {
+    public function peekLong() {
 
-		$pos = $this->pos;
-		$val = $this->readLong();
-		$this->pos = $pos;
-		return $val;
-	}
+        $pos = $this->pos;
+        $val = $this->readLong();
+        $this->pos = $pos;
+        return $val;
+    }
 
 
-	public function peekDouble() {
+    public function peekDouble() {
 
-		$pos = $this->pos;
-		$val = $this->readDouble();
-		$this->pos = $pos;
-		return $val;
-	}
+        $pos = $this->pos;
+        $val = $this->readDouble();
+        $this->pos = $pos;
+        return $val;
+    }
 
 
-	public function peekUTF() {
+    public function peekUTF() {
 
-		$pos = $this->pos;
-		$val = $this->readUTF();
-		$this->pos = $pos;
-		return $val;
-	}
+        $pos = $this->pos;
+        $val = $this->readUTF();
+        $this->pos = $pos;
+        return $val;
+    }
 
 
-	public function peekLongUTF() {
+    public function peekLongUTF() {
 
-		$pos = $this->pos;
-		$val = $this->readLongUTF();
-		$this->pos = $pos;
-		return $val;
-	}
+        $pos = $this->pos;
+        $val = $this->readLongUTF();
+        $this->pos = $pos;
+        return $val;
+    }
 }
 
 
 
 class AMFReader
 {
-	public $stream;
+    public $stream;
 
-	public function __construct($stream) {
+    public function __construct($stream) {
 
-		$this->stream = $stream;
-	}
+        $this->stream = $stream;
+    }
 
 
-	public function readData() {
+    public function readData() {
 
-		$value = null;
+        $value = null;
 
-		$type = $this->stream->readByte();
+        $type = $this->stream->readByte();
 
-		switch($type) {
-			// Double
-			case 0:
-				$value = $this->readDouble();
-			break;
+        switch($type) {
+            // Double
+            case 0:
+                $value = $this->readDouble();
+            break;
 
-			// Boolean
-			case 1:
-				$value = $this->readBoolean();
-				break;
+            // Boolean
+            case 1:
+                $value = $this->readBoolean();
+                break;
 
-			// String
-			case 2:
-				$value = $this->readString();
-				break;
+            // String
+            case 2:
+                $value = $this->readString();
+                break;
 
-			// Object
-			case 3:
-				$value = $this->readObject();
-				break;
+            // Object
+            case 3:
+                $value = $this->readObject();
+                break;
 
-			// null
-			case 6:
-				return null;
-				break;
+            // null
+            case 6:
+                return null;
+                break;
 
-			// Mixed array
-			case 8:
-				$value = $this->readMixedArray();
-				break;
+            // Mixed array
+            case 8:
+                $value = $this->readMixedArray();
+                break;
 
-			// Array
-			case 10:
-				$value = $this->readArray();
-				break;
+            // Array
+            case 10:
+                $value = $this->readArray();
+                break;
 
-			// Date
-			case 11:
-				$value = $this->readDate();
-				break;
+            // Date
+            case 11:
+                $value = $this->readDate();
+                break;
 
-			// Long string
-			case 13:
-				$value = $this->readLongString();
-				break;
+            // Long string
+            case 13:
+                $value = $this->readLongString();
+                break;
 
-			// XML (handled as string)
-			case 15:
-				$value = $this->readXML();
-				break;
+            // XML (handled as string)
+            case 15:
+                $value = $this->readXML();
+                break;
 
-			// Typed object (handled as object)
-			case 16:
-				$value = $this->readTypedObject();
-				break;
+            // Typed object (handled as object)
+            case 16:
+                $value = $this->readTypedObject();
+                break;
 
-			// Long string
-			default:
-				$value = '(unknown or unsupported data type)';
-			break;
-		}
+            // Long string
+            default:
+                $value = '(unknown or unsupported data type)';
+            break;
+        }
 
-		return $value;
-	}
+        return $value;
+    }
 
 
-	public function readDouble() {
+    public function readDouble() {
 
-		return $this->stream->readDouble();
-	}
+        return $this->stream->readDouble();
+    }
 
 
-	public function readBoolean() {
+    public function readBoolean() {
 
-		return $this->stream->readByte() == 1;
-	}
+        return $this->stream->readByte() == 1;
+    }
 
 
-	public function readString() {
+    public function readString() {
 
-		return $this->stream->readUTF();
-	}
+        return $this->stream->readUTF();
+    }
 
 
-	public function readObject() {
+    public function readObject() {
 
-		// Get highest numerical index - ignored
-		$highestIndex = $this->stream->readLong();
+        // Get highest numerical index - ignored
+        $highestIndex = $this->stream->readLong();
 
-		$data = array();
+        $data = array();
 
-		while ($key = $this->stream->readUTF()) {
-			// Mixed array record ends with empty string (0x00 0x00) and 0x09
-			if (($key == '') && ($this->stream->peekByte() == 0x09)) {
-				// Consume byte
-				$this->stream->readByte();
-				break;
-			}
+        while ($key = $this->stream->readUTF()) {
+            // Mixed array record ends with empty string (0x00 0x00) and 0x09
+            if (($key == '') && ($this->stream->peekByte() == 0x09)) {
+                // Consume byte
+                $this->stream->readByte();
+                break;
+            }
 
-			$data[$key] = $this->readData();
-		}
+            $data[$key] = $this->readData();
+        }
 
-		return $data;
-	}
+        return $data;
+    }
 
 
-	public function readMixedArray() {
+    public function readMixedArray() {
 
-		// Get highest numerical index - ignored
-		$highestIndex = $this->stream->readLong();
+        // Get highest numerical index - ignored
+        $highestIndex = $this->stream->readLong();
 
-		$data = array();
+        $data = array();
 
-		while ($key = $this->stream->readUTF()) {
-			// Mixed array record ends with empty string (0x00 0x00) and 0x09
-			if (($key == '') && ($this->stream->peekByte() == 0x09)) {
-				// Consume byte
-				$this->stream->readByte();
-				break;
-			}
+        while ($key = $this->stream->readUTF()) {
+            // Mixed array record ends with empty string (0x00 0x00) and 0x09
+            if (($key == '') && ($this->stream->peekByte() == 0x09)) {
+                // Consume byte
+                $this->stream->readByte();
+                break;
+            }
 
-			if (is_numeric($key)) {
-				$key = (float) $key;
-			}
+            if (is_numeric($key)) {
+                $key = (float) $key;
+            }
 
-			$data[$key] = $this->readData();
-		}
+            $data[$key] = $this->readData();
+        }
 
-		return $data;
-	}
+        return $data;
+    }
 
 
-	public function readArray() {
+    public function readArray() {
 
-		$length = $this->stream->readLong();
+        $length = $this->stream->readLong();
 
-		$data = array();
+        $data = array();
 
-		for ($i = 0; $i < count($length); $i++) {
-			$data[] = $this->readData();
-		}
+        for ($i = 0; $i < count($length); $i++) {
+            $data[] = $this->readData();
+        }
 
-		return $data;
-	}
+        return $data;
+    }
 
 
-	public function readDate() {
+    public function readDate() {
 
-		$timestamp = $this->stream->readDouble();
-		$timezone = $this->stream->readInt();
-		return $timestamp;
-	}
+        $timestamp = $this->stream->readDouble();
+        $timezone = $this->stream->readInt();
+        return $timestamp;
+    }
 
 
-	public function readLongString() {
+    public function readLongString() {
 
-		return $this->stream->readLongUTF();
-	}
+        return $this->stream->readLongUTF();
+    }
 
 
-	public function readXML() {
+    public function readXML() {
 
-		return $this->stream->readLongUTF();
-	}
+        return $this->stream->readLongUTF();
+    }
 
 
-	public function readTypedObject() {
+    public function readTypedObject() {
 
-		$className = $this->stream->readUTF();
-		return $this->readObject();
-	}
+        $className = $this->stream->readUTF();
+        return $this->readObject();
+    }
 }
 
 ?>

main/inc/lib/getid3/getid3.php

Indentation +165 added lines, -165 removed lines

@@ -300,7 +300,7 @@ 
         $class = new $class_name($this);
 
         try {
-             $this->option_analyze and $class->Analyze();
+                $this->option_analyze and $class->Analyze();
             }
         catch (getid3_exception $e) {
             throw $e;
@@ -383,7 +383,7 @@ 
             // CalculateReplayGain() {
             if (@$this->info['replay_gain']) {
                 if (!@$this->info['replay_gain']['reference_volume']) {
-                     $this->info['replay_gain']['reference_volume'] = 89;
+                        $this->info['replay_gain']['reference_volume'] = 89;
                 }
                 if (isset($this->info['replay_gain']['track']['adjustment'])) {
                     $this->info['replay_gain']['track']['volume'] = $this->info['replay_gain']['reference_volume'] - $this->info['replay_gain']['track']['adjustment'];
@@ -403,7 +403,7 @@ 
 
             // ProcessAudioStreams() {
             if (@!$this->info['audio']['streams'] && (@$this->info['audio']['bitrate'] || @$this->info['audio']['channels'] || @$this->info['audio']['sample_rate'])) {
-                  foreach ($this->info['audio'] as $key => $value) {
+                    foreach ($this->info['audio'] as $key => $value) {
                     if ($key != 'streams') {
                         $this->info['audio']['streams'][0][$key] = $value;
                     }
@@ -544,7 +544,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'ac3',
                             'mime_type' => 'audio/ac3',
-                          ),
+                            ),
 
                 // AAC  - audio       - Advanced Audio Coding (AAC) - ADIF format
                 'adif' => array (
@@ -553,7 +553,7 @@ 
                             'module'    => 'aac_adif',
                             'mime_type' => 'application/octet-stream',
                             'fail_ape'  => 'WARNING',
-                          ),
+                            ),
 
 
                 // AAC  - audio       - Advanced Audio Coding (AAC) - ADTS format (very similar to MP3)
@@ -563,7 +563,7 @@ 
                             'module'    => 'aac_adts',
                             'mime_type' => 'application/octet-stream',
                             'fail_ape'  => 'WARNING',
-                          ),
+                            ),
 
 
                 // AU   - audio       - NeXT/Sun AUdio (AU)
@@ -572,7 +572,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'au',
                             'mime_type' => 'audio/basic',
-                          ),
+                            ),
 
                 // AVR  - audio       - Audio Visual Research
                 'avr'  => array (
@@ -580,7 +580,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'avr',
                             'mime_type' => 'application/octet-stream',
-                          ),
+                            ),
 
                 // BONK - audio       - Bonk v0.9+
                 'bonk' => array (
@@ -588,15 +588,15 @@ 
                             'group'     => 'audio',
                             'module'    => 'bonk',
                             'mime_type' => 'audio/xmms-bonk',
-                          ),
+                            ),
 
                 // DTS  - audio       - Dolby Theatre System
-				'dts'  => array(
-							'pattern'   => '^\x7F\xFE\x80\x01',
-							'group'     => 'audio',
-							'module'    => 'dts',
-							'mime_type' => 'audio/dts',
-						),
+                'dts'  => array(
+                            'pattern'   => '^\x7F\xFE\x80\x01',
+                            'group'     => 'audio',
+                            'module'    => 'dts',
+                            'mime_type' => 'audio/dts',
+                        ),
 
                 // FLAC - audio       - Free Lossless Audio Codec
                 'flac' => array (
@@ -604,7 +604,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'xiph',
                             'mime_type' => 'audio/x-flac',
-                          ),
+                            ),
 
                 // LA   - audio       - Lossless Audio (LA)
                 'la'   => array (
@@ -612,7 +612,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'la',
                             'mime_type' => 'application/octet-stream',
-                          ),
+                            ),
 
                 // LPAC - audio       - Lossless Predictive Audio Compression (LPAC)
                 'lpac' => array (
@@ -620,7 +620,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'lpac',
                             'mime_type' => 'application/octet-stream',
-                          ),
+                            ),
 
                 // MIDI - audio       - MIDI (Musical Instrument Digital Interface)
                 'midi' => array (
@@ -628,7 +628,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'midi',
                             'mime_type' => 'audio/midi',
-                          ),
+                            ),
 
                 // MAC  - audio       - Monkey's Audio Compressor
                 'mac'  => array (
@@ -636,31 +636,31 @@ 
                             'group'     => 'audio',
                             'module'    => 'monkey',
                             'mime_type' => 'application/octet-stream',
-                          ),
+                            ),
 
                 // MOD  - audio       - MODule (assorted sub-formats)
                 'mod'  => array (
                             'pattern'   => '^.{1080}(M.K.|[5-9]CHN|[1-3][0-9]CH)',
                             'mime_type' => 'audio/mod',
-                          ),
+                            ),
 
                 // MOD  - audio       - MODule (Impulse Tracker)
                 'it'   => array (
                             'pattern'   => '^IMPM',
                             'mime_type' => 'audio/it',
-                          ),
+                            ),
 
                 // MOD  - audio       - MODule (eXtended Module, various sub-formats)
                 'xm'   => array (
                             'pattern'   => '^Extended Module',
                             'mime_type' => 'audio/xm',
-                          ),
+                            ),
 
                 // MOD  - audio       - MODule (ScreamTracker)
                 's3m'  => array (
                             'pattern'   => '^.{44}SCRM',
                             'mime_type' => 'audio/s3m',
-                          ),
+                            ),
 
                 // MPC  - audio       - Musepack / MPEGplus SV7+
                 'mpc'  => array (
@@ -668,7 +668,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'mpc',
                             'mime_type' => 'audio/x-musepack',
-                          ),
+                            ),
 
                 // MPC  - audio       - Musepack / MPEGplus SV4-6
                 'mpc_old' => array (
@@ -676,7 +676,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'mpc_old',
                             'mime_type' => 'application/octet-stream',
-                          ),
+                            ),
 
 
                 // MP3  - audio       - MPEG-audio Layer 3 (very similar to AAC-ADTS)
@@ -685,7 +685,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'mp3',
                             'mime_type' => 'audio/mpeg',
-                          ),
+                            ),
 
                 // OFR  - audio       - OptimFROG
                 'ofr'  => array (
@@ -693,7 +693,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'optimfrog',
                             'mime_type' => 'application/octet-stream',
-                          ),
+                            ),
 
                 // RKAU - audio       - RKive AUdio compressor
                 'rkau' => array (
@@ -701,7 +701,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'rkau',
                             'mime_type' => 'application/octet-stream',
-                          ),
+                            ),
 
                 // SHN  - audio       - Shorten
                 'shn'  => array (
@@ -711,7 +711,7 @@ 
                             'mime_type' => 'audio/xmms-shn',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
 
                 // TTA  - audio       - TTA Lossless Audio Compressor (http://tta.corecodec.org)
                 'tta'  => array (
@@ -719,7 +719,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'tta',
                             'mime_type' => 'application/octet-stream',
-                          ),
+                            ),
 
                 // VOC  - audio       - Creative Voice (VOC)
                 'voc'  => array (
@@ -727,7 +727,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'voc',
                             'mime_type' => 'audio/voc',
-                          ),
+                            ),
 
                 // VQF  - audio       - transform-domain weighted interleave Vector Quantization Format (VQF)
                 'vqf'  => array (
@@ -735,7 +735,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'vqf',
                             'mime_type' => 'application/octet-stream',
-                          ),
+                            ),
 
                 // WV  - audio        - WavPack (v4.0+)
                 'vw'  => array(
@@ -743,7 +743,7 @@ 
                             'group'     => 'audio',
                             'module'    => 'wavpack',
                             'mime_type' => 'application/octet-stream',
-                          ),
+                            ),
 
 
                 // Audio-Video formats
@@ -754,13 +754,13 @@ 
                             'group'     => 'audio-video',
                             'module'    => 'asf',
                             'mime_type' => 'video/x-ms-asf',
-                          ),
+                            ),
 
                 // BINK  - audio/video - Bink / Smacker
                 'bink' => array(
                             'pattern'   => '^(BIK|SMK)',
                             'mime_type' => 'application/octet-stream',
-                          ),
+                            ),
 
                 // FLV  - audio/video - FLash Video
                 'flv' => array(
@@ -768,13 +768,13 @@ 
                             'group'     => 'audio-video',
                             'module'    => 'flv',
                             'mime_type' => 'video/x-flv',
-                          ),
+                            ),
 
                 // MKAV - audio/video - Mastroka
                 'matroska' => array (
                             'pattern'   => '^\x1A\x45\xDF\xA3',
                             'mime_type' => 'application/octet-stream',
-                          ),
+                            ),
 
                 // MPEG - audio/video - MPEG (Moving Pictures Experts Group)
                 'mpeg' => array (
@@ -782,7 +782,7 @@ 
                             'group'     => 'audio-video',
                             'module'    => 'mpeg',
                             'mime_type' => 'video/mpeg',
-                          ),
+                            ),
 
                 // NSV  - audio/video - Nullsoft Streaming Video (NSV)
                 'nsv'  => array (
@@ -790,7 +790,7 @@ 
                             'group'     => 'audio-video',
                             'module'    => 'nsv',
                             'mime_type' => 'application/octet-stream',
-                          ),
+                            ),
 
                 // Ogg  - audio/video - Ogg (Ogg Vorbis, OggFLAC, Speex, Ogg Theora(*), Ogg Tarkin(*))
                 'ogg'  => array (
@@ -800,7 +800,7 @@ 
                             'mime_type' => 'application/ogg',
                             'fail_id3'  => 'WARNING',
                             'fail_ape'  => 'WARNING',
-                          ),
+                            ),
 
                 // QT   - audio/video - Quicktime
                 'quicktime' => array (
@@ -808,7 +808,7 @@ 
                             'group'     => 'audio-video',
                             'module'    => 'quicktime',
                             'mime_type' => 'video/quicktime',
-                          ),
+                            ),
 
                 // RIFF - audio/video - Resource Interchange File Format (RIFF) / WAV / AVI / CD-audio / SDSS = renamed variant used by SmartSound QuickTracks (www.smartsound.com) / FORM = Audio Interchange File Format (AIFF)
                 'riff' => array (
@@ -817,7 +817,7 @@ 
                             'module'    => 'riff',
                             'mime_type' => 'audio/x-wave',
                             'fail_ape'  => 'WARNING',
-                          ),
+                            ),
 
                 // Real - audio/video - RealAudio, RealVideo
                 'real' => array (
@@ -825,7 +825,7 @@ 
                             'group'     => 'audio-video',
                             'module'    => 'real',
                             'mime_type' => 'audio/x-realaudio',
-                          ),
+                            ),
 
                 // SWF - audio/video - ShockWave Flash
                 'swf' => array (
@@ -833,7 +833,7 @@ 
                             'group'     => 'audio-video',
                             'module'    => 'swf',
                             'mime_type' => 'application/x-shockwave-flash',
-                          ),
+                            ),
 
 
                 // Still-Image formats
@@ -846,7 +846,7 @@ 
                             'mime_type' => 'image/bmp',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
 
                 // GIF  - still image - Graphics Interchange Format
                 'gif'  => array (
@@ -856,7 +856,7 @@ 
                             'mime_type' => 'image/gif',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
 
                 // JPEG - still image - Joint Photographic Experts Group (JPEG)
                 'jpeg'  => array (
@@ -866,7 +866,7 @@ 
                             'mime_type' => 'image/jpeg',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
 
                 // PCD  - still image - Kodak Photo CD
                 'pcd'  => array (
@@ -876,7 +876,7 @@ 
                             'mime_type' => 'image/x-photo-cd',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
 
 
                 // PNG  - still image - Portable Network Graphics (PNG)
@@ -887,16 +887,16 @@ 
                             'mime_type' => 'image/png',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
 
 
                 // SVG  - still image - Scalable Vector Graphics (SVG)
-				'svg'  => array(
-							'pattern'   => '<!DOCTYPE svg PUBLIC ',
-							'mime_type' => 'image/svg+xml',
-							'fail_id3'  => 'ERROR',
-							'fail_ape'  => 'ERROR',
-						),
+                'svg'  => array(
+                            'pattern'   => '<!DOCTYPE svg PUBLIC ',
+                            'mime_type' => 'image/svg+xml',
+                            'fail_id3'  => 'ERROR',
+                            'fail_ape'  => 'ERROR',
+                        ),
 
 
                 // TIFF  - still image - Tagged Information File Format (TIFF)
@@ -907,7 +907,7 @@ 
                             'mime_type' => 'image/tiff',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
 
 
                 // Data formats
@@ -917,7 +917,7 @@ 
                             'mime_type' => 'application/octet-stream',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
 
                 // ISO  - data        - International Standards Organization (ISO) CD-ROM Image
                 'iso'  => array (
@@ -927,7 +927,7 @@ 
                             'mime_type' => 'application/octet-stream',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
 
                 // RAR  - data        - RAR compressed data
                 'rar'  => array(
@@ -935,7 +935,7 @@ 
                             'mime_type' => 'application/octet-stream',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
 
                 // SZIP - audio       - SZIP compressed data
                 'szip' => array (
@@ -945,7 +945,7 @@ 
                             'mime_type' => 'application/octet-stream',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
 
                 // TAR  - data        - TAR compressed data
                 'tar'  => array(
@@ -955,7 +955,7 @@ 
                             'mime_type' => 'application/x-tar',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
 
                 // GZIP  - data        - GZIP compressed data
                 'gz'  => array(
@@ -965,7 +965,7 @@ 
                             'mime_type' => 'application/x-gzip',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
 
 
                 // ZIP  - data        - ZIP compressed data
@@ -976,33 +976,33 @@ 
                             'mime_type' => 'application/zip',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
 
 
                 // PAR2 - data        - Parity Volume Set Specification 2.0
                 'par2' => array (
-                			'pattern'   => '^PAR2\x00PKT',
-							'mime_type' => 'application/octet-stream',
-							'fail_id3'  => 'ERROR',
-							'fail_ape'  => 'ERROR',
-						),
+                            'pattern'   => '^PAR2\x00PKT',
+                            'mime_type' => 'application/octet-stream',
+                            'fail_id3'  => 'ERROR',
+                            'fail_ape'  => 'ERROR',
+                        ),
 
 
-                 // PDF  - data       - Portable Document Format
-                 'pdf' => array(
+                    // PDF  - data       - Portable Document Format
+                    'pdf' => array(
                             'pattern'   => '^\x25PDF',
                             'mime_type' => 'application/pdf',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                           ),
+                            ),
 
-                 // DOC  - data       - Microsoft Word
-                 'msoffice' => array(
+                    // DOC  - data       - Microsoft Word
+                    'msoffice' => array(
                             'pattern'   => '^\xD0\xCF\x11\xE0', // D0CF11E == DOCFILE == Microsoft Office Document
                             'mime_type' => 'application/octet-stream',
                             'fail_id3'  => 'ERROR',
                             'fail_ape'  => 'ERROR',
-                          ),
+                            ),
             );
 
         return $format_info;
@@ -1393,99 +1393,99 @@ 
 
     public static function BigEndian2Float($byte_word) {
 
-		// ANSI/IEEE Standard 754-1985, Standard for Binary Floating Point Arithmetic
-		// http://www.psc.edu/general/software/packages/ieee/ieee.html
-		// http://www.scri.fsu.edu/~jac/MAD3401/Backgrnd/ieee.html
+        // ANSI/IEEE Standard 754-1985, Standard for Binary Floating Point Arithmetic
+        // http://www.psc.edu/general/software/packages/ieee/ieee.html
+        // http://www.scri.fsu.edu/~jac/MAD3401/Backgrnd/ieee.html
 
-		$bit_word = getid3_lib::BigEndian2Bin($byte_word);
-		if (!$bit_word) {
+        $bit_word = getid3_lib::BigEndian2Bin($byte_word);
+        if (!$bit_word) {
             return 0;
         }
-		$sign_bit = $bit_word{0};
-
-		switch (strlen($byte_word) * 8) {
-			case 32:
-				$exponent_bits = 8;
-				$fraction_bits = 23;
-				break;
-
-			case 64:
-				$exponent_bits = 11;
-				$fraction_bits = 52;
-				break;
-
-			case 80:
-				// 80-bit Apple SANE format
-				// http://www.mactech.com/articles/mactech/Vol.06/06.01/SANENormalized/
-				$exponent_string = substr($bit_word, 1, 15);
-				$is_normalized = intval($bit_word{16});
-				$fraction_string = substr($bit_word, 17, 63);
-				$exponent = pow(2, getid3_lib::Bin2Dec($exponent_string) - 16383);
-				$fraction = $is_normalized + getid3_lib::DecimalBinary2Float($fraction_string);
-				$float_value = $exponent * $fraction;
-				if ($sign_bit == '1') {
-					$float_value *= -1;
-				}
-				return $float_value;
-				break;
-
-			default:
-				return false;
-				break;
-		}
-		$exponent_string = substr($bit_word, 1, $exponent_bits);
-		$fraction_string = substr($bit_word, $exponent_bits + 1, $fraction_bits);
-		$exponent = bindec($exponent_string);
-		$fraction = bindec($fraction_string);
-
-		if (($exponent == (pow(2, $exponent_bits) - 1)) && ($fraction != 0)) {
-			// Not a Number
-			$float_value = false;
-		} elseif (($exponent == (pow(2, $exponent_bits) - 1)) && ($fraction == 0)) {
-			if ($sign_bit == '1') {
-				$float_value = '-infinity';
-			} else {
-				$float_value = '+infinity';
-			}
-		} elseif (($exponent == 0) && ($fraction == 0)) {
-			if ($sign_bit == '1') {
-				$float_value = -0;
-			} else {
-				$float_value = 0;
-			}
-			$float_value = ($sign_bit ? 0 : -0);
-		} elseif (($exponent == 0) && ($fraction != 0)) {
-			// These are 'unnormalized' values
-			$float_value = pow(2, (-1 * (pow(2, $exponent_bits - 1) - 2))) * getid3_lib::DecimalBinary2Float($fraction_string);
-			if ($sign_bit == '1') {
-				$float_value *= -1;
-			}
-		} elseif ($exponent != 0) {
-			$float_value = pow(2, ($exponent - (pow(2, $exponent_bits - 1) - 1))) * (1 + getid3_lib::DecimalBinary2Float($fraction_string));
-			if ($sign_bit == '1') {
-				$float_value *= -1;
-			}
-		}
-		return (float) $float_value;
-	}
-
-
-
-	public static function LittleEndian2Float($byte_word) {
-
-		return getid3_lib::BigEndian2Float(strrev($byte_word));
-	}
-
-
-
-	public static function DecimalBinary2Float($binary_numerator) {
-		$numerator   = bindec($binary_numerator);
-		$denominator = bindec('1'.str_repeat('0', strlen($binary_numerator)));
-		return ($numerator / $denominator);
-	}
-
-
-	public static function PrintHexBytes($string, $hex=true, $spaces=true, $html_safe=true) {
+        $sign_bit = $bit_word{0};
+
+        switch (strlen($byte_word) * 8) {
+            case 32:
+                $exponent_bits = 8;
+                $fraction_bits = 23;
+                break;
+
+            case 64:
+                $exponent_bits = 11;
+                $fraction_bits = 52;
+                break;
+
+            case 80:
+                // 80-bit Apple SANE format
+                // http://www.mactech.com/articles/mactech/Vol.06/06.01/SANENormalized/
+                $exponent_string = substr($bit_word, 1, 15);
+                $is_normalized = intval($bit_word{16});
+                $fraction_string = substr($bit_word, 17, 63);
+                $exponent = pow(2, getid3_lib::Bin2Dec($exponent_string) - 16383);
+                $fraction = $is_normalized + getid3_lib::DecimalBinary2Float($fraction_string);
+                $float_value = $exponent * $fraction;
+                if ($sign_bit == '1') {
+                    $float_value *= -1;
+                }
+                return $float_value;
+                break;
+
+            default:
+                return false;
+                break;
+        }
+        $exponent_string = substr($bit_word, 1, $exponent_bits);
+        $fraction_string = substr($bit_word, $exponent_bits + 1, $fraction_bits);
+        $exponent = bindec($exponent_string);
+        $fraction = bindec($fraction_string);
+
+        if (($exponent == (pow(2, $exponent_bits) - 1)) && ($fraction != 0)) {
+            // Not a Number
+            $float_value = false;
+        } elseif (($exponent == (pow(2, $exponent_bits) - 1)) && ($fraction == 0)) {
+            if ($sign_bit == '1') {
+                $float_value = '-infinity';
+            } else {
+                $float_value = '+infinity';
+            }
+        } elseif (($exponent == 0) && ($fraction == 0)) {
+            if ($sign_bit == '1') {
+                $float_value = -0;
+            } else {
+                $float_value = 0;
+            }
+            $float_value = ($sign_bit ? 0 : -0);
+        } elseif (($exponent == 0) && ($fraction != 0)) {
+            // These are 'unnormalized' values
+            $float_value = pow(2, (-1 * (pow(2, $exponent_bits - 1) - 2))) * getid3_lib::DecimalBinary2Float($fraction_string);
+            if ($sign_bit == '1') {
+                $float_value *= -1;
+            }
+        } elseif ($exponent != 0) {
+            $float_value = pow(2, ($exponent - (pow(2, $exponent_bits - 1) - 1))) * (1 + getid3_lib::DecimalBinary2Float($fraction_string));
+            if ($sign_bit == '1') {
+                $float_value *= -1;
+            }
+        }
+        return (float) $float_value;
+    }
+
+
+
+    public static function LittleEndian2Float($byte_word) {
+
+        return getid3_lib::BigEndian2Float(strrev($byte_word));
+    }
+
+
+
+    public static function DecimalBinary2Float($binary_numerator) {
+        $numerator   = bindec($binary_numerator);
+        $denominator = bindec('1'.str_repeat('0', strlen($binary_numerator)));
+        return ($numerator / $denominator);
+    }
+
+
+    public static function PrintHexBytes($string, $hex=true, $spaces=true, $html_safe=true) {
 
         $return_string = '';
         for ($i = 0; $i < strlen($string); $i++) {

main/inc/lib/sessionmanager.lib.php

Indentation +1 added lines, -1 removed lines

@@ -6022,7 +6022,7 @@
         ]);
     }
 
-	/**
+    /**
      * Get the count of user courses in session
      * @param int $sessionId The session id
      * @return array

main/inc/lib/attendance.lib.php

Indentation +1704 added lines, -1704 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,318 +134,318 @@ 
 				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('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].'">'.
+        $res = Database::query($sql);
+        $attendances = array ();
+        $user_info = api_get_user_info();
+        $allowDelete = api_get_setting('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
+                    } 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);
-		$table_link = Database:: get_main_table(TABLE_MAIN_GRADEBOOK_LINK);
-		$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);
-
-		$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 = '';
+        $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);
+        $table_link = Database:: get_main_table(TABLE_MAIN_GRADEBOOK_LINK);
+        $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);
+
+        $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['id'];
-			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 {
-				Database::query('UPDATE '.$table_link.' SET weight='.$weight_calification.' WHERE id='.$link_id.'');
-			}
-		}
-		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);
-		$table_link = Database:: get_main_table(TABLE_MAIN_GRADEBOOK_LINK);
-
-		$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_info = GradebookUtils::is_resource_in_course_gradebook(
-					$course_code,
-					7,
-					$attendance_id,
-					$session_id
-				);
-				if (!$link_info) {
-					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 {
-					Database::query('UPDATE '.$table_link.' SET weight='.$weight_calification.' WHERE id='.$link_info['id'].'');
-				}
-			}
-			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
+            $link_id = $link_info['id'];
+            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 {
+                Database::query('UPDATE '.$table_link.' SET weight='.$weight_calification.' WHERE id='.$link_id.'');
+            }
+        }
+        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);
+        $table_link = Database:: get_main_table(TABLE_MAIN_GRADEBOOK_LINK);
+
+        $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_info = GradebookUtils::is_resource_in_course_gradebook(
+                    $course_code,
+                    7,
+                    $attendance_id,
+                    $session_id
+                );
+                if (!$link_info) {
+                    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 {
+                    Database::query('UPDATE '.$table_link.' SET weight='.$weight_calification.' WHERE id='.$link_info['id'].'');
+                }
+            }
+            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,
@@ -453,16 +453,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,
@@ -470,33 +470,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,
@@ -504,142 +504,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)) {
             $students = GroupManager::getStudents($groupId);
@@ -650,192 +650,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',
@@ -843,82 +843,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,
@@ -926,22 +926,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,
@@ -950,228 +950,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)
-	{
-		// initializing database table and variables
-		$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'];
+        $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)
+    {
+        // initializing database table and variables
+        $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'];
         $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
@@ -1181,87 +1181,87 @@ 
 							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
@@ -1285,68 +1285,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
@@ -1355,11 +1355,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
@@ -1367,62 +1367,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);
@@ -1508,111 +1508,111 @@ 
 
 
     /**
-	 * 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
-			);
-			$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)
-	{
+            $params = array(
+                'c_id' =>  $course_id,
+                'date_time' => $this->date_time,
+                'attendance_id' => $attendance_id
+            );
+            $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;
         }
@@ -1640,506 +1640,506 @@ 
                 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)
-	{
-		if (empty($startDate) || $startDate == '0000-00-00' ||
-			empty($endDate) || $endDate == '0000-00-00'
-		) {
-			return false;
-		}
-
-		$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>: '.
+            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' ||
+            empty($endDate) || $endDate == '0000-00-00'
+        ) {
+            return false;
+        }
+
+        $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>: '.
 			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);
+    }
 }