<?
	class common_ref_client
	{		
		public function get_all_staff()
		{			
			global $database;
									
			$account_id = $_SESSION['client_info']['id'];
			$db_name = DB_CLIENT_ACCOUNTS;			
			
			$query = "
			SELECT *
			FROM $db_name"."users
			WHERE account_id = '$account_id'
			ORDER BY first_name ASC
			";
			$results = $database->getAll($query);
									
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;
		}	

/*		public function get_object_status($table,$id)
		{	
			global $database;
		
			$query = "
			SELECT status
			FROM $table
			WHERE id = '$id'
			";
			$status = $database->getOne($query);
			
			return $status;
		}	*/
		
		public function get_all_clients()
		{	
			global $database;
		
			$query = "
			SELECT *
			FROM clients
			ORDER BY company_name ASC
			";
			$results = $database->getAll($query);
						
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;
		}	

		public function get_all_suppliers()
		{	
			global $database;
		
			$query = "
			SELECT *
			FROM suppliers
			ORDER BY name ASC			
			";
			$results = $database->getAll($query);
						
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;
		}			

		public function get_all_taxes()
		{	
			global $database;
		
			$query = "
			SELECT *
			FROM taxes
			ORDER BY name ASC
			";
			$results = $database->getAll($query);
						
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;
		}					

		public function get_client($id)
		{	
			global $database;
						
			$sql = "
			SELECT *
			FROM clients
			WHERE id = '$id'
			LIMIT 1
			";
			$result = $database->getRow($sql);
			
			return $result;
		}
		
		public function get_client_name($id)
		{	
			global $database;			
			
			$sql = "
			SELECT company_name
			FROM clients
			WHERE id = '$id'
			LIMIT 1
			";
			$result = $database->getOne($sql);
			
			return $result;
		}
		
		public function get_client_location($id)
		{	
			global $database;			
			
			$sql = "
			SELECT *
			FROM clients_locations
			WHERE id = '$id'
			LIMIT 1
			";
			$result = $database->getRow($sql);
			
			return $result;
		}	

		public function get_contact($id)
		{	
			global $database;
						
			$sql = "
			SELECT *
			FROM contacts
			WHERE id = '$id'
			LIMIT 1
			";
			$result = $database->getRow($sql);
			
			return $result;
		}		

		public function get_materials($id)
		{			
			global $database;
			
			$get_assigned = "
			SELECT sum(price * quantity)
			FROM quotes_items
			WHERE quote_id = '$id' AND item_type = '2'
			";
			$materials = $database->getOne($get_assigned);
			
			return $materials;	
		}

		public function get_labour($id)
		{			
			global $database;			
			
			$get_assigned = "
			SELECT sum(price * quantity)
			FROM quotes_items
			WHERE quote_id = '$id' AND item_type = '1'
			";
			$materials = $database->getOne($get_assigned);
			
			return $materials;	
		}			
	}

?>