<?
	class common_clients
	{						
		public function get_details($client_id)
		{			
			global $database;
			
			$get_name = "
			SELECT *
			FROM clients
			WHERE id = '$client_id'
			LIMIT 1
			";
			$value = $database->getRow($get_name);
			
			return $value;			
		}	


		public function get_client_name($client_id)
		{			
			global $database;
			
			$get_name = "
			SELECT company_name
			FROM clients
			WHERE id = '$client_id'
			LIMIT 1
			";
			$company_name = $database->getOne($get_name);
			
			return $company_name;			
		}	

		public function get_client_details($client_id)
		{			
			global $database;
						
			$get_client = "
			SELECT 
				clients.id,
				clients.client_type,			
				clients.company_name,			
				clients.submitter,			
				clients.date_submitted,						
				CONCAT(clients_locations.address,', ',clients_locations.suburb,', ',clients_locations.state,', ',clients_locations.post_code) AS address,
				clients_locations.business_phone,
				clients_locations.fax,			
				CONCAT(contacts.first_name,' ',contacts.last_name) AS contact_person,
				contacts.email AS email												
			FROM clients 
					JOIN clients_locations ON clients.primary_location_id = clients_locations.id
					JOIN contacts ON clients.primary_contact_id = contacts.id
			WHERE clients.id = '$client_id'
			";	
			$client = $database->getRow($get_client);
			
			return $client;			
		}	
		
		public function get_clients()
		{
			global $database;
						
			$get_name = "
			SELECT id,company_name as name
			FROM clients
			";
			$results = $database->getAssoc($get_name);

			return $results;			
		}

		public function get_all_clients()
		{
			global $database;
						
			$get_name = "
			SELECT id,company_name as name 
			FROM clients
			";
			$results = $database->getAll($get_name);

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;				
		}
		
		public function get_num($context)													
		{
			global $database;
			
			$status = $context['status'];

			$status_sql = (!empty($status)) ? "AND status IN $status" : "";		
			
			$get_invoice = "
			SELECT count(id)
			FROM clients
			WHERE id != '0' $status_sql
			";
			$num_results = $database->getOne($get_invoice);					
						
			return $num_results;
		}					
		
		public function get_clients_with_status($status)
		{
			global $database;
			 
			  $get_clients = "
					SELECT *
					FROM $db_name"."clients
					WHERE status = '$status' 
					";
			$results = $database->getAll($get_clients);	
		
			return $results;		
		}

		public function get_clients_locations($client_id)
		{
			global $database;
			 
			  $get_clients = "
					SELECT *
					FROM $db_name"."clients_locations
					WHERE client_id = '$client_id'
					";
			$results = $database->getAll($get_clients);	
		
			return $results;		
		}	

		public function get_num_clients_locations($client_id)
		{
			global $database;
			 
			$get_clients = "
			SELECT count(id)
			FROM $db_name"."clients_locations
			WHERE client_id = '$client_id'
			";
			$results = $database->getOne($get_clients);	
		
			return $results;		
		}

		public function get_clients_contacts($client_id)
		{
			global $database;
			 
			  $get_clients = "
					SELECT *
					FROM $db_name"."contacts
					WHERE client_id = '$client_id'
					";
			$results = $database->getAll($get_clients);	
		
			return $results;		
		}	

		public function get_num_clients_contacts($client_id)
		{
			global $database;
			 
			$get_clients = "
			SELECT count(id)
			FROM $db_name"."contacts
			WHERE client_id = '$client_id'
			";
			$results = $database->getOne($get_clients);	
		
			return $results;		
		}																								
	}

?>