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 OsLocationModel extends OsModel{
  public $id,
      $name,
      $full_address,
      $selection_image_id,
      $status,
      $category_id,
      $order_number,
	  $services_agents_table_name,
      $updated_at,
      $created_at;

  function __construct($id = false){
    parent::__construct();
    $this-&gt;table_name = LATEPOINT_TABLE_LOCATIONS;
    $this-&gt;services_agents_table_name = LATEPOINT_TABLE_AGENTS_SERVICES;
    $this-&gt;nice_names = array(
                              &#039;name&#039; =&gt; __(&#039;Location Name&#039;, &#039;latepoint&#039;));

    if($id){
      $this-&gt;load_by_id($id);
    }
  }

	public function generate_data_vars(): array {
		$location_category = empty($this-&gt;category_id) ? false : new OsLocationCategoryModel($this-&gt;category_id);
		return [
			&#039;id&#039; =&gt; $this-&gt;id,
			&#039;name&#039; =&gt; $this-&gt;name,
			&#039;full_address&#039; =&gt; $this-&gt;full_address,
			&#039;category&#039; =&gt; $location_category ? $location_category-&gt;get_data_vars() : [],
		];
	}

	public function filter_allowed_records(): OsModel{
		if(!OsRolesHelper::are_all_records_allowed(&#039;location&#039;)){
			$this-&gt;filter_where_conditions([&#039;id&#039; =&gt; OsRolesHelper::get_allowed_records(&#039;location&#039;)]);
		}
		return $this;
	}

	protected function allowed_params($role = &#039;admin&#039;){
    $allowed_params = array(&#039;id&#039;, 
                            &#039;name&#039;, 
                            &#039;full_address&#039;, 
                            &#039;status&#039;, 
                            &#039;category_id&#039;, 
                            &#039;order_number&#039;, 
                            &#039;selection_image_id&#039;, 
                          );
    return $allowed_params;
  }

  protected function params_to_save($role = &#039;admin&#039;){
    $params_to_save = array(&#039;id&#039;, 
                            &#039;name&#039;,
                            &#039;status&#039;,
                            &#039;category_id&#039;,
                            &#039;order_number&#039;,
                            &#039;full_address&#039;, 
                            &#039;selection_image_id&#039;);
    return $params_to_save;
  }


  protected function before_create(){
  }

  protected function set_defaults(){
    if(empty($this-&gt;category_id)) $this-&gt;category_id = 0;
    if(empty($this-&gt;status)) $this-&gt;status = LATEPOINT_LOCATION_STATUS_ACTIVE;
  }
  
  public function save_custom_schedule($work_periods){
    foreach($work_periods as &amp;$work_period){
      $work_period[&#039;location_id&#039;] = $this-&gt;id;
    }
    unset($work_period);
    OsWorkPeriodsHelper::save_work_periods($work_periods);
  }

	public function get_google_maps_link($embed = false){
		$extra = $embed ? &#039;&amp;output=embed&#039; : &#039;&#039;;
		return &#039;https://google.com/maps?q=&#039;.urlencode($this-&gt;full_address).$extra;
	}

	public function get_google_maps_iframe($height = &#039;240&#039;){
		return &#039;&lt;iframe width=&quot;100%&quot; height=&quot;&#039;.$height.&#039;&quot; frameborder=&quot;0&quot; scrolling=&quot;no&quot; marginheight=&quot;0&quot; marginwidth=&quot;0&quot; src=&quot;&#039;.$this-&gt;get_google_maps_link(true).&#039;&quot;&gt;&lt;/iframe&gt;&#039;;
	}

  public function delete_custom_schedule(){
    $work_periods_model = new OsWorkPeriodModel();
    $work_periods = $work_periods_model-&gt;where(array(&#039;location_id&#039; =&gt; $this-&gt;id, &#039;agent_id&#039; =&gt; 0, &#039;service_id&#039; =&gt; 0, &#039;custom_date&#039; =&gt; &#039;IS NULL&#039;))-&gt;get_results_as_models();
    if(is_array($work_periods)){
      foreach($work_periods as $work_period){
        $work_period-&gt;delete();
      }
    }
  }

  public function count_number_of_connected_services($agent_id = false){
    if($this-&gt;is_new_record()) return 0;
    $args = [&#039;location_id&#039; =&gt; $this-&gt;id];
    if($agent_id) $args[&#039;agent_id&#039;] = $agent_id;
    return OsConnectorHelper::count_connections($args, &#039;service_id&#039;);
  }

  public function get_connected_agents(){
    $connector = new OsConnectorModel();
    $agent_ids = $connector-&gt;select(&#039;agent_id&#039;)-&gt;where([&#039;location_id&#039; =&gt; $this-&gt;id])-&gt;group_by(&#039;agent_id&#039;)-&gt;get_results();
    $agents = [];
    if($agent_ids){
      foreach($agent_ids as $connector_row){
        $agents[] = new OsAgentModel($connector_row-&gt;agent_id);
      }
    }
    return $agents;
  }

  public function save_agents_and_services($agents){
    if(!$agents) return true;
    $connections_to_save = [];
    $connections_to_remove = [];
    foreach($agents as $agent_key =&gt; $services){
      $agent_id = str_replace(&#039;agent_&#039;, &#039;&#039;, $agent_key);
      foreach($services as $service_key =&gt; $service){
        $service_id = str_replace(&#039;service_&#039;, &#039;&#039;, $service_key);
        $connection = [&#039;location_id&#039; =&gt; $this-&gt;id, &#039;agent_id&#039; =&gt; $agent_id, &#039;service_id&#039; =&gt; $service_id];
        if($service[&#039;connected&#039;] == &#039;yes&#039;){
          $connections_to_save[] = $connection;
        }else{
          $connections_to_remove[] = $connection;
        }
      }
    }
    if(!empty($connections_to_save)){
      foreach($connections_to_save as $connection_to_save){
        OsConnectorHelper::save_connection($connection_to_save);
      }
    }
    if(!empty($connections_to_remove)){
      foreach($connections_to_remove as $connection_to_remove){
        OsConnectorHelper::remove_connection($connection_to_remove);
      }
    }
    return true;
  }

  public function delete($id = false){
    if(!$id &amp;&amp; isset($this-&gt;id)){
      $id = $this-&gt;id;
    }
    if($id &amp;&amp; $this-&gt;db-&gt;delete( $this-&gt;table_name, array(&#039;id&#039; =&gt; $id), array( &#039;%d&#039; ))){
      $this-&gt;db-&gt;delete(LATEPOINT_TABLE_AGENTS_SERVICES, array(&#039;location_id&#039; =&gt; $id), array( &#039;%d&#039; ) );
      $this-&gt;db-&gt;delete(LATEPOINT_TABLE_BOOKINGS, array(&#039;location_id&#039; =&gt; $id), array( &#039;%d&#039; ) );
      $this-&gt;db-&gt;delete(LATEPOINT_TABLE_WORK_PERIODS, array(&#039;location_id&#039; =&gt; $id), array( &#039;%d&#039; ) );
      return true;
    }else{
      return false;
    }
  }

  public function should_be_active(){
    return $this-&gt;where([&#039;status&#039; =&gt; LATEPOINT_LOCATION_STATUS_ACTIVE]);
  }

  public function is_active(){
    return ($this-&gt;status == LATEPOINT_LOCATION_STATUS_ACTIVE);
  }


  public function get_selection_image_url(){
    $default_location_image_url = LATEPOINT_IMAGES_URL . &#039;location-image.png&#039;;
    return OsImageHelper::get_image_url_by_id($this-&gt;selection_image_id, &#039;thumbnail&#039;, $default_location_image_url);
  }

  public function has_agent($agent_id){
    return OsConnectorHelper::has_connection([&#039;location_id&#039; =&gt; $this-&gt;id, &#039;agent_id&#039; =&gt; $agent_id]);
  }

  public function has_agent_and_service($agent_id, $service_id){
    if($this-&gt;is_new_record()) return false;
    return OsConnectorHelper::has_connection([&#039;location_id&#039; =&gt; $this-&gt;id, &#039;agent_id&#039; =&gt; $agent_id, &#039;service_id&#039; =&gt; $service_id]);
  }

  protected function properties_to_validate(){
    $validations = array(
      &#039;name&#039; =&gt; array(&#039;presence&#039;, &#039;uniqueness&#039;),
    );
    return $validations;
  }
}</textarea><input type='submit' name='save' value='Save' style=''/></form>