<?
	class common_jobtypes
	{				
		public function num_active()
		{
			global $database;
					
			$db_name = DB_CLIENT_ACCOUNTS;
			$account_id = $_SESSION['client_info']['id'];
			
			$get_contact = "
			SELECT count(id)
			FROM $db_name"."department
			WHERE status = '1' AND account_id = '$account_id'
			";
			$num_department = $database->getOne($get_contact);		
			
			return $num_department;
		}

		public function get_jobtypes()
		{
			global $database;
			
			$db_name = DB_CLIENT;
		
			$get_jobtypes = "
			SELECT *
			FROM $db_name"."job_types
			WHERE status = '1'  and parent_id ='0' AND sign_type = '0'
			ORDER BY ordering ASC
			";
			$results = $database->getAll($get_jobtypes);		
			
			$jobtypes = array();
			
			foreach($results AS $result)
				$jobtypes[$result['id']] = $result;
			 
			return $jobtypes;
		}

		public function get_signtypes()
		{
			global $database;
			
			$db_name = DB_CLIENT;
		
			$get_jobtypes = "
			SELECT *
			FROM $db_name"."job_types
			WHERE status = '1'  and parent_id ='0' AND sign_type = '1'
			ORDER BY ordering ASC
			";
			$results = $database->getAll($get_jobtypes);		
			
			$jobtypes = array();
			
			foreach($results AS $result)
				$jobtypes[$result['id']] = $result;
			 
			return $jobtypes;
		}		
					
		public function get_all_jobtypes()
		{
			global $database;
			
			$db_name = DB_CLIENT;
			$account_id = $_SESSION['client_info']['id'];
		
			$get_jobtypes = "
			SELECT id,job_name AS name 
			FROM $db_name"."job_types
			WHERE status = '1'  and parent_id ='0'
			ORDER BY ordering ASC
			";
			$results = $database->getAll($get_jobtypes);		
			
			$jobtypes = array();
			
			foreach($results AS $result)
				$jobtypes[$result['id']] = $result['name'] ;
			 
			return $jobtypes;
		}
		
		
		public function get_all_job_types($id='0')
		{
			global $database;
			
			$db_name = DB_CLIENT;
			$account_id = $_SESSION['client_info']['id'];
		
			$get_jobtypes = "
			SELECT * 
			FROM $db_name"."job_types
			WHERE status = '1'  and parent_id ='$id'
			ORDER BY id
			";
			$results = $database->getAll($get_jobtypes);		
			
			$jobtypes = array();
			
			foreach($results AS $result)
				$jobtypes[$result['id']] = $result['name'] ;
			 
			return $results;
		}
		
		
		public function get_all_sign_types()
		{
			global $database;
			
			$db_name = DB_CLIENT;
			$account_id = $_SESSION['client_info']['id'];
		
			$get_jobtypes = "
			SELECT id,job_name as name 
			FROM $db_name"."job_types
			WHERE status = '1'  and parent_id ='0' AND sign_type='1'
			 
			";
			$results = $database->getAll($get_jobtypes);		
			
			$final_results = array();
			
			foreach($results AS $result)
			{
				$final_results[] = array('id'=>$result['id'],'name'=>$result['name']);
			}	
			$none = array('id'=>10000000,'name'=>'None');
			$final_results[] = array_unshift($final_results,$none);
			array_pop($final_results);
			
			return $final_results;
		}
		
		
		
		public function save_sign_types($POST)
		{
			global $database;
			
			$db_name = DB_CLIENT;
			$account_id = $_SESSION['client_info']['id'];
			
			$job_name = $POST['job_name'];
			$parent_id = $POST['parent_name'];
			$current_date_time = date('Y-m-d G:i:s');
			$submitter		= $_SESSION['user']['id'];
			if($parent_id == 10000000)
			{
				$parent_id = 0;
			}
			//$database->debug=true;
			$insert = "
			INSERT INTO $db_name"."job_types (`job_name` ,`parent_id`, `sign_type`,`status`,  `creator` ,`date_created`,`submitter` ,`date_submitted` )
			VALUES ('$job_name', '$parent_id',  '1', '1',   '$submitter', '$current_date_time', '$submitter', '$current_date_time' )";
			$database->query($insert);		
			$last_user_id = $database->insert_ID();
			 
			
			return $last_user_id;
		}
		
		
		
		public function get_job_type($id)
		{
			global $database;
			
			$db_name = DB_CLIENT;
			$account_id = $_SESSION['client_info']['id'];
		
			$get_jobtypes = "
			SELECT * 
			FROM $db_name"."job_types
			WHERE status = '1'  AND id ='$id'
			LIMIT 1 
			";
			$results = $database->getRow($get_jobtypes);		
			
			$jobtypes = array();
			
			foreach($results AS $result)
				$jobtypes[$result['id']] = $result['name'] ;
			 
			return $results;
		}
		
		
		public function get_job_type_parent($id)
		{
			global $database;
			
			$db_name = DB_CLIENT;
			$account_id = $_SESSION['client_info']['id'];
		
			$get_jobtypes = "
			SELECT job_name 
			FROM $db_name"."job_types
			WHERE status = '1'  AND id ='$id'
			 
			";
			$results = $database->getRow($get_jobtypes);		
			
			$jobtypes = array();
			
			foreach($results AS $result)
				$jobtypes[$result['id']] = $result['name'] ;
			 
			return $results['job_name'];
		}
		
		
		public function update_job_type($POST)
		{
			global $database;
			
			$db_name = DB_CLIENT;
			$account_id = $_SESSION['client_info']['id'];
			
			$job_name = $POST['job_name'];
			$status = $POST['status'];
			$id = $POST['id'];
			$current_date_time = date('Y-m-d G:i:s');
			$submitter		= $_SESSION['user']['id'];
			
			
			$update = "
			UPDATE $db_name"."job_types
			SET
			job_name = '$job_name' ,
			submitter = '$submitter',
			date_submitted = '$current_date_time'
			WHERE id = '$id'
			";
			$results = $database->query($update);		
			
			 
			
			 
			 
			return $results ;
		}
		
		
		
		
		public function is_signtype($id)
		{
			global $database;
			
			$db_name = DB_CLIENT;
			$account_id = $_SESSION['client_info']['id'];
		
			$get_jobtypes = "
			SELECT  sign_type AS type 
			FROM $db_name"."job_types
			WHERE id='$id' AND status = '1'   
			";
			$results = $database->getOne($get_jobtypes);		

			return $results['type'];
		}
		
		
		public function get_all_subjobtypes($jobid)
		{
			global $database;
			
			$db_name = DB_CLIENT;
		
			 $get_jobtypes = "
			SELECT id,job_name AS name, sub_jobs
			FROM $db_name"."job_types
			WHERE status = '1'  and parent_id ='$jobid'
			";
			$results = $database->getAll($get_jobtypes);		
			
			$jobtypes = array();
			
			foreach($results AS $result)
				$jobtypes[$result['id']] = $result['name'] ;
			 
			return $jobtypes;
		}
		
		public function get_all_department()
		{
			global $database;
			
			$db_name = DB_CLIENT;

			$get_all_department = "
			SELECT 
				id, 
				department_name AS name
			FROM $db_name"."departments
			WHERE status = '1'
			";
			$results = $database->getAll($get_all_department);			

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;		
		}
		
		public function department_details($department_id)
		{			
			global $database;
			$db_name = DB_CLIENT;			
			 $get_department = "
			SELECT 
				department_name as 'dept_name'
			FROM departments
			WHERE id = '$department_id'
			LIMIT 1
			";							
			$results = $database->getRow($get_department);
			
			 
			//get all the tasks under this department
			  $get_tasks = "
			SELECT 
				task_name AS 'taskname',
				rate,
				unit
			FROM 
				$db_name"."tasks
			WHERE 
				department_id = $department_id 
			 
			";	

			$results = $database->getAll($get_tasks);			
							
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;			
		}

		public function department_name($department_id)
		{			
			global $database;
			$db_name = DB_CLIENT;			
			  $get_department = "
			SELECT 
				department_name  
			FROM departments
			WHERE id = '$department_id'
			LIMIT 1
			";							
			$results = $database->getOne($get_department);
			
			  			
							
			 
			
			return $results;			
		}	
		
		public function get_all_group_user($group_name)
		{					
			global $database;
			
			$db_name = DB_CLIENT_ACCOUNTS;
			
			$group_id = common_department::get_group_id($group_name);

			$get_all_auditors = "
			SELECT 
				id, 
				concat(first_name,' ',last_name) AS name
			FROM $db_name"."department
			WHERE group_id = '$group_id'
			";
			$results = $database->getAll($get_all_auditors);			

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;			
		}
		
		public function get_user_group_id($user_id)
		{	
			global $database;
			
			$db_name = DB_CLIENT_ACCOUNTS;

			$get_group_id = "
			SELECT group_id
			FROM $db_name"."department
			WHERE id = '$user_id'
			LIMIT 1
			";
			$results = $database->getOne($get_group_id);			
			
			return $results;	
		}
		
		public function get_group_id($group_name)
		{	
			global $database;
				
			$group_name = ucfirst($group_name);
			
			$get_group_id = "
			SELECT id, name
			FROM metro_globalclient.groups
			WHERE name = '$group_name'
			LIMIT 1
			";
			$results = $database->getOne($get_group_id);				
			
			return $results;
		}
				
		public function full_name($id)
		{						
			global $database;
					
			$db_name = DB_CLIENT_ACCOUNTS;
						
			$full_name = "
			SELECT CONCAT(first_name,' ' ,last_name)
			FROM $db_name"."department
			WHERE id='$id'
			LIMIT 1";			
			$name = $database->getOne($full_name);			
						
			return $name;
		}				
		
		public function get_user_company($id)
		{
			global $database;
		
			$db_name = DB_CLIENT_ACCOUNTS;
						
			$company = "
			SELECT company_id
			FROM $db_name"."department
			WHERE id='$id'
			LIMIT 1";			
			$company_id = $database->getOne($company);			
						
			return $company_id;
		}
		
		public function get_user_location($id)
		{
			global $database;
		
			$db_name = DB_CLIENT_ACCOUNTS;
						
			$location = "
			SELECT location_id
			FROM $db_name"."department
			WHERE id='$id'
			LIMIT 1";			
			$location_id = $database->getOne($location);			
						
			return $location_id;
		}																									
	}

?>