<?
	class common_ref_status
	{		
		public function get_object_status($table,$id,$db_name = "")
		{	
			global $database;
		
			$query = "
			SELECT status
			FROM $db_name$table
			WHERE id = '$id'
			";
			$status = $database->getOne($query);
			
			return $status;
		}

		public function get_department_status($id )
		{	
			global $database;
		
			$query = "
			SELECT id,department_id
			FROM  `departments_status`
			WHERE status_id = '$id'
			";
			$results = $database->getAll($query);
			
			$final_results = array();
			
			if(is_array($results))
				foreach($results AS $result)
					$final_results[$result['department_id']] = $result;	
			
			return $final_results;
		}	
	
			
		public function get_status($table)
		{	
			global $database;			
						
			$db_client_status = DB_CLIENT_STATUS;
															
		 	$query = "
			SELECT *
			FROM $db_client_status$table
			 
			";
			$results = $database->getAll($query);
									
			$final_results = array();
			
			if(is_array($results))
				foreach($results AS $result)
					$final_results[$result['id']] = $result;	
						
			return $final_results;
		}
		
		public function get_quote_status($table)
		{	
			global $database;
						
			$db_client_status = DB_CLIENT_STATUS;
															
		 	$query = "
			SELECT *
			FROM $db_client_status$table
			 WHERE id > 3 ORDER BY `name` ASC
			";
			$results = $database->getAll($query);
						
			$final_results = array();
			
			if(is_array($results))
				foreach($results AS $result)
					$final_results[$result['id']] = $result;	
			
			return $final_results;
		}

		public function check_access($table,$status_id,$permission)
		{
			$status_table = $_SESSION['status'][$table];
			
			return ($results > 0) ? acl::permission($permission) : false;					
		}


		public function check_edit($table,$status_id,$permission)
		{	
			global $database;
						
			$db_client_status = DB_CLIENT_STATUS;			
							
			$query = "
			SELECT count(id)
			FROM $db_client_status$table
			WHERE id = '$status_id' AND `edit` = '1'
			";
			$results = $database->getOne($query);						
									
			return ($results > 0) ? acl::permission($permission) : false;			
		}	
		
		public function get_deleted($table)
		{	
			global $database;
			
			$db_client_status = DB_CLIENT_STATUS;			
							
			$query = "
			SELECT id
			FROM $db_client_status$table
			WHERE `delete` = '1'
			";
			$result = $database->getOne($query);						
			
			return $result;
		}		
				
		public function get_status_complete($table,$state)
		{	
			global $database;
			
			$db_client_status = DB_CLIENT_STATUS;			
							
			$query = "
			SELECT *
			FROM $db_client_status$table
			WHERE complete = '$state'
			";
			$results = $database->getAll($query);
						
			$final_results = array();
			
			$final_results = "";
			
			foreach($results AS $result)
				$final_results .= $result['id']."','";	
			
			return "('".substr($final_results,0,strlen($final_results) - 2).")";
		}			

		public function get_status_active($table,$state)
		{				
			global $database;
			
			$db_client_status = DB_CLIENT_STATUS;			
			
			$query = "
			SELECT *
			FROM $db_client_status$table
			WHERE active = '$state'
			";
			$results = $database->getAll($query);
						
			$final_results = array();
			
			$final_results = "";
			
			foreach($results AS $result)
				$final_results .= $result['id']."','";	
			
			return "('".substr($final_results,0,strlen($final_results) - 2).")";
		}

		public function get_status_login($table,$state)
		{	
			global $database;
			
			$db_client_status = DB_CLIENT_STATUS;			
							
			  $query = "
			SELECT *
			FROM $db_client_status$table
			WHERE login = '$state'
			";
			$results = $database->getAll($query);
						
			$final_results = array();
			
			$final_results = "";
			
			foreach($results AS $result)
				$final_results .= $result['id']."','";	
			
			return "('".substr($final_results,0,strlen($final_results) - 2).")";
		}
		
				
		public function display_connections($table,$status_id)
		{				
			global $database;
			
			$db_client_status = DB_CLIENT_STATUS;
			
			$table_con = $table."_con";
							
            $get_connections = "
            SELECT $table.action_name
            FROM $db_client_status$table,$db_client_status$table_con
            WHERE $table.id = $table_con.con_id AND $table_con.id = '$status_id'
            ";
            $results_conn = $database->getAll($get_connections);
            
            $connection = "";
            
            foreach($results_conn As $result_conn)
                $connection .= $result_conn['action_name'].", ";
            
            $connection = substr($connection,0,strlen($connection)-2);
			
			return $connection;
		}			

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

		public function get_status_name($table,$id)
		{	
			global $database;		
			
			 		
			$db_client_status= DB_CLIENT_STATUS; 
							
		 	 $query = "
			SELECT name
			FROM $db_client_status$table
			WHERE id = '$id'  
			";					
			$results = $database->getOne($query);
						
			  
			return $results ;
		}																													
	}

?>