<?
	class common_ref_select
	{					
		public function get_all_clients($status)
		{	
			global $database;
			
			$sql_where = "";
			
			if(!empty($status))
				$sql_where .= "WHERE status IN $status";
			
			$query = "
			SELECT *, company_name AS name
			FROM clients
			$sql_where
			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($status)
		{	
			global $database;
			
			$sql_where = "";
			
			if(!empty($status))
				$sql_where .= "WHERE status IN $status";
			
			$query = "
			SELECT *
			FROM suppliers
			$sql_where
			ORDER BY name ASC
			";
			$results = $database->getAll($query);
						
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;
		}							
	}

?>