<?
	class common_leaves
	{		
		public function get_all_leaves()
		{			
			global $database;
			
			$get_all_leave = "
			SELECT *
			FROM leaves
			";
			$all_leave = $database->getAll($get_all_leave);
			
			return $all_leave;			
		}	
		
		public function get_all_leaves_by_status($status)
		{			
			global $database;
			
			$get_all_leave = "
			SELECT *
			FROM leaves
			WHERE status = '$status'
			";
			$all_leave = $database->getAll($get_all_leave);
			
			return $all_leave;			
		}	
		
		public function get_leave($id)
		{			
			global $database;
			
			$get_leave = "
			SELECT *
			FROM leaves
			WHERE id = '$id'
			";
			$leave = $database->getRow($get_leave);
			
			if($leave['type'] == 0)
			{
				$leave['type_id'] = $leave['type'];
				$leave['type'] = "Annual Leave";
			}
			else if($leave['type'] == 1)
			{
				$leave['type_id'] = $leave['type'];
				if ( $leave['certificate'] == 0 )
				{
					$leave['type'] = "Personal (No Cert)";
				}
				else
				{
					$leave['type'] = "Personal (With Cert)";
				}
			}
			if($leave['type'] == 2)
			{
				$leave['type_id'] = $leave['type'];
				$leave['type'] = "Trade School";
			}

			$leave['description_clean'] = nl2br( stripslashes( htmlentities( $leave['description'], ENT_QUOTES, 'UTF-8' ) ) );	
			
			return $leave;			
		}
		
		public function get_all_coming_leaves()
		{			
			global $database;

			$current_date = date('Y-m-d');
			
			$get_all_coming_leave = "
			SELECT *
			FROM leaves
			WHERE start_date >= '$current_date'
			";
			$all_coming_leave = $database->getAll($get_all_coming_leave);
			
			return $all_coming_leave;			
		}
		
		public function get_all_archive_leaves()
		{			
			global $database;

			$current_date = date('Y-m-d');
			
			$get_all_archive_leave = "
			SELECT *
			FROM leaves
			WHERE start_date < '$current_date'
			";
			$all_archive_leave = $database->getAll($get_all_archive_leave);
			
			return $all_archive_leave;			
		}
						
		public function get_user_coming_leaves($user_id)
		{			
			global $database;
			
			$current_date = date('Y-m-d');
			
			//$database->debug = true;
			
			$get_user_coming_leave = "
			SELECT *
			FROM leaves
			WHERE start_date >= '$current_date'
				AND user_id = '$user_id'
				AND status = '1'
			";
			$user_coming_leave = $database->getAll($get_user_coming_leave);
			
			return $user_coming_leave;			
		}		
		
		public function get_user_archive_leaves($user_id)
		{			
			global $database;
			
			$current_date = date('Y-m-d');
			
			//$database->debug = true;
			
			$get_user_archive_leave = "
			SELECT *
			FROM leaves
			WHERE start_date < '$current_date'
				AND user_id = '$user_id'
				AND status = '4'
			";
			$user_archive_leave = $database->getAll($get_user_archive_leave);
			
			return $user_archive_leave;
		}	
		
		public function get_user_approved_leaves($user_id)
		{			
			global $database;
			
			//$database->debug = true;
			
			$get_user_approved_leave = "
			SELECT *
			FROM leaves
			WHERE status = '4'
				AND user_id = '$user_id'
				AND start_date >= '$current_date'
			";
			$user_approved_leave = $database->getAll($get_user_approved_leave);
			
			return $user_approved_leave;
		}	
		
		public function get_user_notify_leaves($user_id)
		{			
			global $database;
			
			//$database->debug = true;
			
			$get_user_notify_leave = "
			SELECT *
			FROM leaves
			WHERE status = '4'
				AND user_id = '$user_id'
				AND start_date >= '$current_date'
				AND notify = '0'
			";
			$user_notify_leave = $database->getAll($get_user_notify_leave);
			
			return $user_notify_leave;
		}	
		
		public function convert_time($time)
		{
			if($time > 12)
			{
				if($time == 24)
				{
					$time = "12 AM";
				}
				else
				{
					$time = ($time-12)." PM";
				}
			}
			else
			{
				if($time == 12)
				{
					$time = "12 PM";
				}
				else
				{
					$time = $time." AM";
				}
			}
			return $time;
		}	
		
		public function convert_time_split($time)
		{
			$time_split[] = "";
			if($time > 12)
			{
				if($time == 24)
				{
					$time_split['hour'] = 12;
					$time_split['ampm'] = "AM";
				}
				else
				{
					$time_split['hour'] = ($time-12);
					$time_split['ampm'] = "PM";
				}
			}
			else
			{
				if($time == 12)
				{
					$time_split['hour'] = 12;
					$time_split['ampm'] = "PM";
				}
				else
				{
					$time_split['hour'] = $time;
					$time_split['ampm'] = "AM";
				}
			}
			return $time_split;
		}	
		
		public function change_date_format($date)
		{
			$split_date = explode("-", $date);
			$date = $split_date[2]."-".$split_date[1]."-".$split_date[0];
			return $date;
		}
		
		
		public function update_leave($context )
		{
			global $database;
			
			$submitter = $_SESSION['user']['id'];
			$current_date_time = date('Y-m-d G:i:s');			
			
			$start_date = $context['start_date'];
			$end_date = $context['end_date'];
			$start_time = $context['start_time'];
			$end_time = $context['end_time'];
			$description = $context['description'];
			$certificate = $context['certificate'];
			$type = $context['type'];
			$id = $context['id'];
			$user_id = $context['user_id'];
			 
			 
			 
			
			$update_leave = "
			UPDATE leaves
			SET
				user_id = '$user_id',
				start_date = '$start_date',
				end_date = '$end_date',
				start_time = '$start_time',
				end_time = '$end_time',
				description = '$description',
				certificate = '$certificate',
				type = '$type',
				status = '1',
				submitter = '$submitter',
				date_submitted = '$current_date_time'
			WHERE id = '$id'
			";
			$results = $database->query($update_leave);
			 
			
			return $results;
		}	
		
		
		public function insert_leave($context )
		{
			global $database;
			
			$submitter = $_SESSION['user']['id'];
			$current_date_time = date('Y-m-d G:i:s');			
			
			$start_date = $context['start_date'];
			$end_date = $context['end_date'];
			$start_time = $context['start_time'];
			$end_time = $context['end_time'];
			$description = $context['description'];
			$certificate = $context['certificate'];
			$type = $context['type'];
			$user_id = $context['user_id'];
			 
			 			
			$insert_leave = "
			INSERT INTO leaves
			SET
				user_id = '$user_id',
				start_date = '$start_date',
				end_date = '$end_date',
				start_time = '$start_time',
				end_time = '$end_time',
				description = '$description',
				certificate = '$certificate',
				type = '$type',
				status = '1',
				creator = '$submitter',
				date_created = '$current_date_time',
				submitter = '$submitter',
				date_submitted = '$current_date_time'
			";
			$results = $database->query($insert_leave);
			 
			
			return $results;
		}
													
	}

?>