<?
	class common_search
	{
		public function search($value)
		{
			global $database;
			
			$value = trim($value);
			
			$extensions = array();
			
			if(!is_numeric($value))
			{
				$data_clients = self::search_clients($value);
				
				if((count($data_clients) > 0) && is_array($data_clients))
				{
					$client_ids_sql = "";
				
					foreach($data_clients AS $val)
						$client_ids_sql .= "'".$val['id']."',";
						
					$client_ids_sql = " OR client_id IN (".substr($client_ids_sql,0, strlen($client_ids_sql) - 1).")";
				}

				$data_locations = self::search_clients_location($value);
												
				if((count($data_locations) > 0) && is_array($data_locations))
				{										
					$locations_ids_sql = "";
				
					foreach($data_locations AS $val)
						$locations_ids_sql .= "'".$val['id']."',";

					echo $locations_ids_sql."<br />";
						
					$locations_ids_sql = " OR location_id IN (".substr($locations_ids_sql,0, strlen($locations_ids_sql) - 1).")";
				}				

				$data_contacts = self::search_contacts($value);
				
				if((count($data_contacts) > 0) && is_array($data_contacts))
				{
					$contacts_ids_sql = "";
				
					foreach($data_contacts AS $val)
						$contacts_ids_sql .= "'".$val['id']."',";
										
					$contacts_ids_sql = " OR contact_id  IN (".substr($contacts_ids_sql,0, strlen($contacts_ids_sql) - 1).")";
				}			

				$data_sign_types = self::search_sign_types($value);
				
				if((count($data_sign_types) > 0) && is_array($data_sign_types))
				{
					$sign_types_ids_sql = "";
				
					foreach($data_sign_types AS $val)
						$sign_types_ids_sql .= " OR `jobtype` like '%\"".$val['id']."\"%'";										
				}			
											
				$extensions = array(
						"client_ids_sql" => $client_ids_sql,
						"locations_ids_sql" => $locations_ids_sql,
						"contacts_ids_sql" => $contacts_ids_sql,
						"sign_types_ids_sql" => $sign_types_ids_sql
						
				);					
			}
			
			$data_quotes = self::search_quotes($value,$extensions);
			$data_jobs = self::search_jobs($value,$extensions);
			
			return array("data_quotes" => $data_quotes, "data_jobs" => $data_jobs);
		}
		
		public function search_quotes($value,$extensions = array())
		{
			global $database;
						
			$client_ids_sql = $extensions['client_ids_sql'];
			$locations_ids_sql = $extensions['locations_ids_sql'];
			$sign_types_ids_sql = $extensions['sign_types_ids_sql'];
						
			$data = array();			
			
			if(is_numeric($value))
				$id_sql = "id = '$value' OR ";
					
			$sql = "
			SELECT id
			FROM quotes
			WHERE 
				$id_sql
				job_name like '%$value%' OR
				description like '%$value%' OR
				myob_number like '%$value%' OR
				other_note like '%$value%'
				$client_ids_sql
				$locations_ids_sql				
				$sign_types_ids_sql								
			";				
			$data = $database->getAll($sql);
													
			return $data;			
		}

		public function search_jobs($value,$extensions = array())
		{
			global $database;

			$client_ids_sql = $extensions['client_ids_sql'];
			$locations_ids_sql = $extensions['locations_ids_sql'];
									
			$data = array();

			if(is_numeric($value))
				$id_sql = "id = '$value' OR ";
							
			$sql = "
			SELECT id
			FROM jobs
			WHERE 
				$id_sql
				job_name like '%$value%' OR
				description like '%$value%' OR
				myob_number like '%$value%'
				$client_ids_sql
				$locations_ids_sql				
			";
			$data = $database->getAll($sql);
									
			return $data;			
		}

		public function search_sign_types($value)
		{
			global $database;

			$data = array();
					
			$sql = "
			SELECT id
			FROM job_types
			WHERE 
				job_name like '%$value%' AND
				sign_type = '1'
			";
			$data = $database->getAll($sql);		

			return $data;			
		}	
						
		public function search_clients($value)
		{
			global $database;

			$data = array();
					
			$sql = "
			SELECT id
			FROM clients
			WHERE 
				company_name  like '%$value%' OR
				website like '%$value%'
			";
			$data = $database->getAll($sql);		

			return $data;			
		}					  

		public function search_clients_location($value)
		{
			global $database;

			$data = array();
					
			$sql = "
			SELECT id
			FROM clients_locations
			WHERE 
				address like '%$value%' OR
				suburb like '%$value%' OR				
				post_code = '$value' OR
				business_phone like '%$value%' OR				
				fax like '%$value%' OR				
				alt_contact  like '%$value%' OR				
				alt_phone  like '%$value%'							
			";
			$data = $database->getAll($sql);	

			return $data;				
		}	

		public function search_contacts($value)
		{
			global $database;

			$data = array();
					
			$sql = "
			SELECT id
			FROM contacts
			WHERE 
				first_name like '%$value%' OR
				last_name like '%$value%' OR				
				job_title like '$value' OR
				title like '%$value%' OR				
				business_phone like '%$value%' OR				
				home_phone like '%$value%' OR				
				fax like '%$value%' OR				
				email like '%$value%' OR				
				mobile_phone   like '%$value%'							
			";
			$data = $database->getAll($sql);		
			
			return $data;			
		}	

		public function search_attachments($value)
		{
			global $database;

			$data = array();
					
			$sql = "
			SELECT *
			FROM attachments
			WHERE 
				filename like '%$value%'			
			";
			$data = $database->getAll($sql);	
			
			return $data;	
		}									  		
	}