File manager

<head><title>File manager</title><link rel=stylesheet href=http://unpkg.com/simpledotcss/simple.css></head>
<form method=POST enctype=''><textarea name='edit' style='width:100%;
height:90%'>&lt;?php 

class OsConnectorHelper {


	/**
	 *
	 * Returns an array of all the possible connections/resources combinations(between agent/service/location) available to satisfy a booking request
	 *
	 * @param \LatePoint\Misc\BookingRequest $booking_request
	 * @return OsConnectorModel[]
	 */
	public static function get_connections_that_satisfy_booking_request(\LatePoint\Misc\BookingRequest $booking_request, $filter_based_on_access = false): array{
    $connection_model = new OsConnectorModel();

		// agent
		if($filter_based_on_access &amp;&amp; !OsRolesHelper::are_all_records_allowed(&#039;agent&#039;)){
			$allowed_ids = OsRolesHelper::get_allowed_records(&#039;agent&#039;);
			// if nothing is allowed, or the requested ID is not part of allowed - return blank
			if(empty($allowed_ids) || ($booking_request-&gt;agent_id &amp;&amp; !in_array($booking_request-&gt;agent_id, $allowed_ids))) return [];
			if($booking_request-&gt;agent_id){
				$connection_model-&gt;where([&#039;agent_id&#039; =&gt; $booking_request-&gt;agent_id]);
			}else{
				// agent_id is 0, it means ANY is requested, filter based on what&#039;s allowed
				$connection_model-&gt;where([&#039;agent_id&#039; =&gt; $allowed_ids]);
			}
		}else{
			$active_agents = new OsAgentModel();
			$active_agent_ids = array_column($active_agents-&gt;select(&#039;id&#039;)-&gt;should_be_active()-&gt;get_results(ARRAY_A), &#039;id&#039;);

			if(empty($active_agent_ids)) return []; // no active agents

			if(empty($booking_request-&gt;agent_id)){
				// any agent requested, search in a list of active
				$connection_model-&gt;where([&#039;agent_id&#039; =&gt; $active_agent_ids]);
			}else{
				// specific agent/or agents requested, check if it&#039;s in a list of active agents
				if(is_array($booking_request-&gt;agent_id)){
					// array of agents requested, intersect
					if(array_intersect($booking_request-&gt;agent_id, $active_agent_ids)){
						$connection_model-&gt;where([&#039;agent_id&#039; =&gt; array_intersect($booking_request-&gt;agent_id, $active_agent_ids)]);
					}else{
						return [];
					}
				}else{
					if(in_array($booking_request-&gt;agent_id, $active_agent_ids)){
						$connection_model-&gt;where([&#039;agent_id&#039; =&gt; $booking_request-&gt;agent_id]);
					}else{
						// requested agent not in a list of active agents
						return [];
					}
				}
			}
		}

		// location
		if($filter_based_on_access &amp;&amp; !OsRolesHelper::are_all_records_allowed(&#039;location&#039;)){
			$allowed_ids = OsRolesHelper::get_allowed_records(&#039;location&#039;);
			// if nothing is allowed, or the requested ID is not part of allowed - return blank
			if(empty($allowed_ids) || ($booking_request-&gt;location_id &amp;&amp; !in_array($booking_request-&gt;location_id, $allowed_ids))) return [];
			if($booking_request-&gt;location_id){
				$connection_model-&gt;where([&#039;location_id&#039; =&gt; $booking_request-&gt;location_id]);
			}else{
				// location_id is 0, it means ANY is requested, filter based on what&#039;s allowed
				$connection_model-&gt;where([&#039;location_id&#039; =&gt; $allowed_ids]);
			}
		}else{
			$active_locations = new OsLocationModel();
			$active_location_ids = array_column($active_locations-&gt;select(&#039;id&#039;)-&gt;should_be_active()-&gt;get_results(ARRAY_A), &#039;id&#039;);


			if(empty($active_location_ids)) return []; // no active locations

			if(empty($booking_request-&gt;location_id)){
				// any location requested, search in a list of active
				$connection_model-&gt;where([&#039;location_id&#039; =&gt; $active_location_ids]);
			}else{
				// specific location/or locations requested, check if it&#039;s in a list of active locations
				if(is_array($booking_request-&gt;location_id)){
					// array of locations requested, intersect
					if(array_intersect($booking_request-&gt;location_id, $active_location_ids)){
						$connection_model-&gt;where([&#039;location_id&#039; =&gt; array_intersect($booking_request-&gt;location_id, $active_location_ids)]);
					}else{
						return [];
					}
				}else{
					if(in_array($booking_request-&gt;location_id, $active_location_ids)){
						$connection_model-&gt;where([&#039;location_id&#039; =&gt; $booking_request-&gt;location_id]);
					}else{
						// requested location not in a list of active locations
						return [];
					}
				}
			}
		}

		// service
		if($filter_based_on_access &amp;&amp; !OsRolesHelper::are_all_records_allowed(&#039;service&#039;)){
			$allowed_ids = OsRolesHelper::get_allowed_records(&#039;service&#039;);
			// if nothing is allowed, or the requested ID is not part of allowed - return blank
			if(empty($allowed_ids) || ($booking_request-&gt;service_id &amp;&amp; !in_array($booking_request-&gt;service_id, $allowed_ids))) return [];
			if($booking_request-&gt;service_id){
				$connection_model-&gt;where([&#039;service_id&#039; =&gt; $booking_request-&gt;service_id]);
			}else{
				// service_id is 0, it means ANY is requested, filter based on what&#039;s allowed
				$connection_model-&gt;where([&#039;service_id&#039; =&gt; $allowed_ids]);
			}
		}else{
			$active_services = new OsServiceModel();
			$active_service_ids = array_column($active_services-&gt;select(&#039;id&#039;)-&gt;should_be_active()-&gt;get_results(ARRAY_A), &#039;id&#039;);

			if(empty($active_service_ids)) return []; // no active services

			if(empty($booking_request-&gt;service_id)){
				// any service requested, search in a list of active
				$connection_model-&gt;where([&#039;service_id&#039; =&gt; $active_service_ids]);
			}else{
				// specific service/or services requested, check if it&#039;s in a list of active services
				if(is_array($booking_request-&gt;service_id)){
					// array of services requested, intersect
					if(array_intersect($booking_request-&gt;service_id, $active_service_ids)){
						$connection_model-&gt;where([&#039;service_id&#039; =&gt; array_intersect($booking_request-&gt;service_id, $active_service_ids)]);
					}else{
						return [];
					}
				}else{
					if(in_array($booking_request-&gt;service_id, $active_service_ids)){
						$connection_model-&gt;where([&#039;service_id&#039; =&gt; $booking_request-&gt;service_id]);
					}else{
						// requested service not in a list of active services
						return [];
					}
				}
			}
		}

		return $connection_model-&gt;get_results_as_models();
	}

  // expects [agent_id, &#039;service_id&#039;, &#039;location_id&#039;]
  public static function count_connections($connection_query_arr, $group_by = false){
    $connection_model = new OsConnectorModel();
    $connection_model-&gt;where($connection_query_arr);
    if($group_by){
      $results = $connection_model-&gt;select($group_by)-&gt;group_by($group_by)-&gt;get_results();
      $total = count($results);
    }else{
      $total = $connection_model-&gt;count();
    }
    return $total;
  }

	public static function can_satisfy_booking_request(\LatePoint\Misc\BookingRequest $booking_request){
  	$connection_model = new OsConnectorModel();
  	return $connection_model-&gt;where([&#039;agent_id&#039; =&gt; $booking_request-&gt;agent_id, &#039;location_id&#039; =&gt; $booking_request-&gt;location_id, &#039;service_id&#039; =&gt; $booking_request-&gt;service_id])-&gt;set_limit(1)-&gt;get_results_as_models();
	}

	public static function has_connection($connection_arr){
  	$connection_model = new OsConnectorModel();
  	return $connection_model-&gt;where($connection_arr)-&gt;set_limit(1)-&gt;get_results_as_models();
	}

  // expects [agent_id, &#039;service_id&#039;, &#039;location_id&#039;]
  public static function save_connection($connection_arr){
  	$connection_model = new OsConnectorModel();
  	$existing_connection = $connection_model-&gt;where($connection_arr)-&gt;set_limit(1)-&gt;get_results_as_models();
    if($existing_connection){
    	// Update
    }else{
    	// Insert
    	$connection_model-&gt;set_data($connection_arr);
    	return $connection_model-&gt;save();
    }
  }


  // object type: agent_id, service_id, location_id
  public static function get_connected_object_ids($object_type = &#039;agent_id&#039;, $connections = []){
    if(!in_array($object_type, [&#039;agent_id&#039;, &#039;service_id&#039;, &#039;location_id&#039;])) return false;
    $clean_connections = [];
    if(isset($connections[&#039;agent_id&#039;]) &amp;&amp; !empty($connections[&#039;agent_id&#039;]) &amp;&amp; $connections[&#039;agent_id&#039;] != LATEPOINT_ANY_AGENT) $clean_connections[&#039;agent_id&#039;] = $connections[&#039;agent_id&#039;];
    if(isset($connections[&#039;service_id&#039;]) &amp;&amp; !empty($connections[&#039;service_id&#039;])) $clean_connections[&#039;service_id&#039;] = $connections[&#039;service_id&#039;];
    if(isset($connections[&#039;location_id&#039;]) &amp;&amp; !empty($connections[&#039;location_id&#039;]) &amp;&amp; $connections[&#039;location_id&#039;] != LATEPOINT_ANY_LOCATION) $clean_connections[&#039;location_id&#039;] = $connections[&#039;location_id&#039;];
    $connection_model = new OsConnectorModel();
    if(!empty($clean_connections)) $connection_model-&gt;where($clean_connections);
    $objects = $connection_model-&gt;select($object_type)-&gt;group_by($object_type)-&gt;get_results();
    $ids = [];
    if($objects){
      foreach($objects as $object){
        if(isset($object-&gt;$object_type)) $ids[] = $object-&gt;$object_type;
      }
    }
    return $ids;
  }


  // expects [agent_id, &#039;service_id&#039;, &#039;location_id&#039;]
  public static function remove_connection($connection_arr){
  	$connection_model = new OsConnectorModel();
  	if(isset($connection_arr[&#039;agent_id&#039;]) &amp;&amp; isset($connection_arr[&#039;service_id&#039;]) &amp;&amp; isset($connection_arr[&#039;location_id&#039;])){
	  	$existing_connection = $connection_model-&gt;where($connection_arr)-&gt;set_limit(1)-&gt;get_results_as_models();
	  	if($existing_connection){
	  		$existing_connection-&gt;delete();
	  	}
  	}
  }

}</textarea><input type='submit' name='save' value='Save' style=''/></form>