<?
	class common_labours
	{				
		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"."labours
			WHERE status = '1' AND account_id = '$account_id'
			";
			$num_labours = $database->getOne($get_contact);		
			
			return $num_labours;
		}
			
		public function get_labours($id='')
		{
			global $database;
			
			 $db_name = DB_CLIENT;
			$account_id = $_SESSION['client_info']['id'];
			$id = $id =='' ? '': ' AND parent_id='.$id;
			$get_labours = "
			SELECT id,labour_name AS name,rate,status,fieldtype
			FROM $db_name"."labours
			WHERE status = '1'  ".$id;
			
			$results = $database->getAll($get_labours);		
			
			$labours = array();
			
			foreach($results AS $result)
				$labours[$result['id']] = $result;
			
			return $labours;
		}
		
		public function get_all_labours()
		{
			global $database;
			
			$db_name = DB_CLIENT;

			$get_all_labours = "
			SELECT id,labour_name AS name,units,rate 
			FROM $db_name"."labours
			WHERE status = '1' and parent_id='0'
			";
			$results = $database->getAll($get_all_labours);			

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;		
		}
		
		
		public function get_all_sublabours($parent_id)
		{
			global $database;
			
			$db_name = DB_CLIENT;

			$get_all_sublabours = "
			SELECT id,labour_name AS name,units,rate 
			FROM $db_name"."labours
			WHERE status = '1' and parent_id='$parent_id'
			";
			$results = $database->getAll($get_all_sublabours);			

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

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

		public function labours_name($labours_id)
		{			
			global $database;
			
			$db_name = DB_CLIENT;			
			
			$get_labours = "
			SELECT labours_name  
			FROM quotes_labour_settingsss
			WHERE id = '$labours_id'
			LIMIT 1
			";							
			$results = $database->getOne($get_labours);
			
			  			
							
			 
			
			return $results;			
		}	
		
		
		public function get_sublabours($id)
		{			
			global $database;
			$db_name = DB_CLIENT;
		
		
			$sql3 = "
			SELECT * 
			FROM quotes_labour_settings 
			WHERE parent_id = '$id' AND status='1'
			";
		$subresults3 = $database->getAll($sql3);
		
			return $subresults3;			
		}	
		
		
		public function get_all_group_user($group_name)
		{					
			global $database;
			
			$db_name = DB_CLIENT_ACCOUNTS;
			
			$group_id = common_labours::get_group_id($group_name);

			$get_all_auditors = "
			SELECT id,	concat(first_name,' ',last_name) AS name
			FROM $db_name"."labours
			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"."labours
			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"."labours
			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"."labours
			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"."labours
			WHERE id='$id'
			LIMIT 1";			
			$location_id = $database->getOne($location);			
						
			return $location_id;
		}
		
		
		public function get_labours_settings($parent_id=0)
		{
			global $database;
		
			$db_name = DB_CLIENT_ACCOUNTS;
						
			/*$sql = "
			SELECT * 
			FROM quotes_labour_settings 
			WHERE parent_id='$parent_id'  
					AND labour_name <> 'Delivery' 
					AND labour_name <> 'Installation' 
					AND labour_name <> 'Alternative Sub Contractor supplied price' 
					AND status=1";*/
			$sql = "
			SELECT *
			FROM quotes_labour_settings
			WHERE parent_id='$parent_id'
			AND labour_name <> 'Delivery'
			AND labour_name <> 'Alternative Sub Contractor supplied price'
			AND status=1";
		
			$results = $database->getAll($sql);			
						
			return $results;
		}
		
		
		public function get_installation_labours_settings($parent_id=0)
		{
			global $database;
		
			$db_name = DB_CLIENT_ACCOUNTS;
						
		  $sql = "
			SELECT * 
			FROM quotes_labour_settings 
			WHERE   
					 
					 labour_name = 'Installation' 
					OR labour_name = 'Alternative Sub Contractor supplied price' 
					AND status=1";
		
			$results = $database->getAll($sql);			
						
			return $results;
		}
		
		
		
		public function get_actual_labours($id)
		{
			global $database;
		
			$db_name = DB_CLIENT_ACCOUNTS;
						
		$sql = "
			SELECT actual_labour AS labours 
			FROM quotes_labour 
			WHERE quote_id = '$id';
			";
			 
			$results = $database->getRow($sql);			
						
			return $results;
		}
		
		
		public function get_actual_install($id)
		{
			global $database;
		
			$db_name = DB_CLIENT_ACCOUNTS;
						
			$sql = "
			SELECT actual_install AS labours 
			FROM quotes_labour 
			WHERE quote_id = '$id';
			";
			 
			$results = $database->getRow($sql);			
						
			return $results;
		}
		
		/** 
		 * Kai 20/11/2012
		 * 
		 * updating quote labour costing without change actual install field
		 * */
		public function update_quote_labour($context=array())
		{

			
			global $database;
			$submitter = $_SESSION['user']['id'];
			$current_date_time = date('Y-m-d G:i:s');
				
			$labourdata = $context['labourdata'];
			$delivery_total = $context['delivery_total'];
			$install_total = $context['install_total'];
			$labour_total = $context['labour_total'];
			$artwork_total = $context['artwork_total'];
			$permit_total = $context['permit_total'];
			$subcontractor_total = $context['subcontractor_total'];
			$dept_id = $context['dept_id'];
			$id = $context['id'];

			$result = self::get_actual_install($id);
			if(!$result['labours']){
				$sql = "
					UPDATE quotes_labour
					SET
					labours = '$labourdata',
					delivery_total = '$delivery_total',
					install_total = '$install_total',
					labour_total = '$labour_total',
					artwork_total = '$artwork_total',
					permit_total = '$permit_total',
					subcontractor_cost = '$subcontractor_total',
					actual_labour ='$labourdata',
					actual_install = '$labourdata',
					status = 1,
					department_id = '$dept_id',
					submitter = '$submitter',
					date_submitted = '$current_date_time'
					WHERE quote_id = '$id'
				";
			}else{
				$sql = "
					UPDATE quotes_labour
					SET
					labours = '$labourdata',
					delivery_total = '$delivery_total',
					install_total = '$install_total',
					labour_total = '$labour_total',
					artwork_total = '$artwork_total',
					permit_total = '$permit_total',
					subcontractor_cost = '$subcontractor_total',
					actual_labour ='$labourdata',
					status = 1,
					department_id = '$dept_id',
					submitter = '$submitter',
					date_submitted = '$current_date_time'
					WHERE quote_id = '$id'
				";
			}
		
			$result=$database->query($sql);
		}
		
		public function update($context=array())
		{
		 	global $database;
			$submitter = $_SESSION['user']['id'];
			$current_date_time = date('Y-m-d G:i:s');
			
			$labourdata = $context['labourdata'];
			$delivery_total = $context['delivery_total'];
			$install_total = $context['install_total'];
			$labour_total = $context['labour_total'];
			$artwork_total = $context['artwork_total'];
			$permit_total = $context['permit_total'];
			$subcontractor_total = $context['subcontractor_total'];
			$dept_id = $context['dept_id'];
			$id = $context['id'];
			
			$sql = "
				UPDATE quotes_labour
				SET  
					labours = '$labourdata',
					delivery_total = '$delivery_total',
					install_total = '$install_total',
					labour_total = '$labour_total',
					artwork_total = '$artwork_total',
					permit_total = '$permit_total',
					subcontractor_cost = '$subcontractor_total', 
					actual_labour ='$labourdata',
					actual_install = '$labourdata',
					status = 1,
					department_id = '$dept_id',
					submitter = '$submitter',
					date_submitted = '$current_date_time'
				WHERE quote_id = '$id'
		 	";
			
			$result=$database->query($sql);
		}	
		
		
		public function save_actual_labour($str,$quote_id)
		{
		
			global $database;
		
			 
		 	$sql_delete ="
						DELETE FROM quotes_production_time WHERE quote_id = '$quote_id'
						";
			$database->query($sql_delete);
			 			
			
		 	$sql ="
					INSERT INTO quotes_production_time
					 (`quote_id`,`production_departments_id`,`hours`,`status`,`date_created`,`submitter`,`date_submitted`)
					VALUES ".$str."
					";
			$result=$database->query($sql);
		
		
		}		
		
		
		public function update_quotes_labour($labourdata,$quote_id)
		{
		
			global $database;
		
			$submitter = $_SESSION['user']['id'];
			$current_date_time = date('Y-m-d G:i:s'); 
		 	
			$sql = "
				UPDATE quotes_labour
				SET  
					actual_labour = '$labourdata',
					submitter = '$submitter',
					date_submitted = '$current_date_time'
				WHERE quote_id = '$quote_id'
			 ";
			$result=$database->query($sql);
		
		
		}
		
		
		public function update_actual_install($labourdata,$quote_id)
		{
		
			global $database;
		
			$submitter = $_SESSION['user']['id'];
			$current_date_time = date('Y-m-d G:i:s'); 
		 	
			$sql = "
				UPDATE quotes_labour
				SET  
					actual_install = '$labourdata',
					submitter = '$submitter',
					date_submitted = '$current_date_time'
				WHERE quote_id = '$quote_id'
			 ";
			$result=$database->query($sql);
			return $result;
		
		}
		
		
		
		
		public function update_labours($context)
		{
		
			global $database;
		
			$labours			= $context['labourdata'];
			$delivery_total 	= $context['delivery_total'];
			$install_total		= $context['install_total'];
			$labour_total		= $context['labour_total'];
			$artwork_total		= $context['artwork_total'];
			$permit_total		= $context['permit_total'];
			$subcontractor_cost	= $context['subcontractor_cost'];
			$department_id		= $context['dept_id'];
			$quote_id			= $context['quote_id'];
		 	$submitter 			= $_SESSION['user']['id'];
			$current_date_time 	= date('Y-m-d G:i:s');
			
			$sql = "
					UPDATE quotes_labour
					SET  
						labours = '$labourdata',
						delivery_total = '$delivery_total',
						install_total = '$install_total',
						labour_total = '$labour_total',
						artwork_total = '$artwork_total',
						permit_total = '$permit_total',
						subcontractor_cost = '$subcontractor_total', 
						actual_install = '$labourdata',
						status = 1,
						department_id = '$dept_id',
						date_submitted = '$current_date_time',
						submitter = '$submitter',
					WHERE quote_id = '$quote_id'
					";		 						
		    
			$result=$database->query($sql);
		}
		
				
		
																									
	}

?>