<?
	class common_ref_global_client
	{					
		public function get_client_db($sub_domain,$conn,$db_name)
		{																		
			$get_db = "
			SELECT db
			FROM $db_name"."account
			WHERE domain = '$sub_domain'
			LIMIT 1";
			return $conn->getOne($get_db);				
		}	
		
		public function get_all_contact_types()
		{	
			global $database;

			$db_name = DB_CLIENT_SETTINGS;
		
			$query = "
			SELECT *
			FROM $db_name"."contact_types
			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_client_types()
		{	
			global $database;

			$db_name = DB_CLIENT_SETTINGS;
		
			$query = "
			SELECT id,name
			FROM $db_name"."client_types
			ORDER BY name ASC
			";
			$results = $database->getAll($query);
						
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result['name'];	
			
			return $final_results;
		}
					
		public function get_all_packages($status = "")
		{				
			global $database;
			
			$db_name = DB_CLIENT_SETTINGS;
						
			$status_sql = (empty($status)) ? "" : "WHERE status = '$status'";
						
			$sql = "
			SELECT id,name
			FROM $db_name"."packages
			$status_sql
			";
			$results = $database->getAll($sql);			

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;			
		}	

		public function get_package($id)
		{	
			global $database;
			
			$db_name = DB_CLIENT_SETTINGS;
			
			$query = "
			SELECT name
			FROM $db_name"."packages
			WHERE id = '$id'
			LIMIT 1
			";
			$name = $database->getOne($query);			
			
			return $name;
		}											
			
							
		public function get_all_increments()
		{	
			global $database;			

			$db_name = DB_CLIENT_SETTINGS;
							
			$sql = "
			SELECT id, display_name AS name
			FROM $db_name"."increments
			";
			$results = $database->getAll($sql);			

			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;			
		}					

		public function get_all_groups($table)
		{	
			global $database;

			$db_name = DB_CLIENT_SETTINGS;
										
			$query = "
			SELECT *
			FROM $db_name"."$table
			";
			$results = $database->getAll($query);
						
			$final_results = array();
			
			foreach($results AS $result)
				$final_results[$result['id']] = $result;	
			
			return $final_results;
		}											

		public function get_schedule_types()
		{	
			global $database;			

			$db_name = DB_CLIENT_SETTINGS;
							
			$query = "
			SELECT *
			FROM $db_name"."schedule_types
			";
			$results = $database->getAll($query);
			
			$final_results = array();
			
			foreach($results AS $result)
			{
				$final_results[$result['id']] = $result;	
			}
			
			return $final_results;
		}			

		public function get_asset_types()
		{							
			global $database;
			
			$db_name = DB_CLIENT_SETTINGS;

			$sql = "
			SELECT *
			FROM $db_name"."asset_types 
			";			
			$results = $database->getAll($sql);
			
			$final_results = array();
			
			foreach($results AS $result)
			{
				$final_results[$result['id']] = $result['name'];	
			}
			
			return $final_results;		
		}	
		
		public function get_item_types()
		{							
			global $database;
			
			$db_name = DB_CLIENT_SETTINGS;

			$sql = "
			SELECT *
			FROM $db_name"."item_types 
			";			
			$results = $database->getAll($sql);
			
			return $results;			
		}	
		
		public function get_group($id)
		{							
			global $database;
			
			$db_name = DB_CLIENT_SETTINGS;

			$get_group = "
			SELECT name
			FROM $db_name"."groups
			WHERE id = '$id'
			LIMIT 1";			
			$group = $database->getOne($get_group);
			
			return $group;			
		}					
						
		public function get_my_group()
		{			
			global $database;
						
			$db_name = DB_CLIENT_SETTINGS;
			
        	$my_group_id = $_SESSION['user']['group_id'];
						
			$groups_status = common_ref_status::get_status("groups");
			
			$group_status = array();
			
			foreach($groups_status AS $status)
			{
				if($status['login'] == 1)
					$group_status[] = $status['id'];
			}			
						
			$status = "('".implode("','",$group_status)."')";			
												
			$get_current_groups = "
			SELECT groups.id,groups.name,groups.display_name
			FROM $db_name"."groups_add,$db_name"."groups
			WHERE groups_add.group_id = '$my_group_id' AND groups_add.group_add_id = groups.id AND 
			groups.status IN $status";
			$groups_array = $database->GetAll($get_current_groups);			
					
			return $groups_array;
		}					
	}
?>