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 OsServiceModel extends OsModel{
  public $id,
      $name = &#039;&#039;,
      $short_description,
      $selection_image_id,
      $description_image_id,
      $is_price_variable,
      $price_min,
      $price_max,
      $charge_amount,
      $deposit_amount,
	    $duration_name = &#039;&#039;,
      $duration = 60,
      $buffer_before,
      $buffer_after,
      $category_id,
	  $override_default_booking_status = false,
      $status,
      $bg_color,
      $order_number,
      $visibility = LATEPOINT_SERVICE_VISIBILITY_VISIBLE,
      $capacity_min = 1,
      $capacity_max = 1,
      $timeblock_interval,
      $is_custom_price = false,
      $is_custom_hours = false,
      $is_custom_duration = false,
	  $meta_class = &#039;OsServiceMetaModel&#039;,
		$services_agents_table_name,
	  $is_deposit_required,
	  $earliest_possible_booking,
	  $latest_possible_booking,
	  $deposit_value,
      $updated_at,
      $created_at;

  function __construct($id = false){
    parent::__construct();
    $this-&gt;table_name = LATEPOINT_TABLE_SERVICES;
    $this-&gt;services_agents_table_name = LATEPOINT_TABLE_AGENTS_SERVICES;
    $this-&gt;nice_names = array(
                              &#039;name&#039; =&gt; __(&#039;Service Name&#039;, &#039;latepoint&#039;),
                              &#039;short_description&#039; =&gt; __(&#039;Service Short Description&#039;, &#039;latepoint&#039;),
                              &#039;selection_image_id&#039; =&gt; __(&#039;Service Selection Image&#039;, &#039;latepoint&#039;),
                              &#039;description_image_id&#039; =&gt; __(&#039;Service Description Image&#039;, &#039;latepoint&#039;),
                              &#039;is_price_variable&#039; =&gt; __(&#039;Variable Price&#039;, &#039;latepoint&#039;),
                              &#039;price_min&#039; =&gt; __(&#039;Minimum Price&#039;, &#039;latepoint&#039;),
                              &#039;price_max&#039; =&gt; __(&#039;Maximum Price&#039;, &#039;latepoint&#039;),
                              &#039;charge_amount&#039; =&gt; __(&#039;Charge Amount&#039;, &#039;latepoint&#039;),
                              &#039;deposit_amount&#039; =&gt; __(&#039;Deposit Amount&#039;, &#039;latepoint&#039;),
                              &#039;duration_name&#039; =&gt; __(&#039;Duration Name&#039;, &#039;latepoint&#039;),
                              &#039;duration&#039; =&gt; __(&#039;Service Duration&#039;, &#039;latepoint&#039;),
                              &#039;buffer_before&#039; =&gt; __(&#039;Buffer Before&#039;, &#039;latepoint&#039;),
                              &#039;buffer_after&#039; =&gt; __(&#039;Buffer After&#039;, &#039;latepoint&#039;),
                              &#039;bg_color&#039; =&gt; __(&#039;Background Color&#039;, &#039;latepoint&#039;),
                              &#039;category_id&#039; =&gt; __(&#039;Service Category&#039;, &#039;latepoint&#039;));

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

  protected function params_to_save($role = &#039;admin&#039;){
    $params_to_save = array(&#039;id&#039;, 
                            &#039;name&#039;, 
                            &#039;short_description&#039;, 
                            &#039;category_id&#039;,
                            &#039;selection_image_id&#039;,
                            &#039;is_price_variable&#039;,
                            &#039;price_min&#039;,
                            &#039;price_max&#039;,
                            &#039;charge_amount&#039;,
                            &#039;deposit_amount&#039;,
                            &#039;duration_name&#039;,
                            &#039;duration&#039;,
                            &#039;buffer_before&#039;,
                            &#039;buffer_after&#039;,
                            &#039;bg_color&#039;,
                            &#039;timeblock_interval&#039;,
                            &#039;override_default_booking_status&#039;,
                            &#039;order_number&#039;,
                            &#039;visibility&#039;,
                            &#039;status&#039;,
							&#039;earliest_possible_booking&#039;,
							&#039;latest_possible_booking&#039;,
                            &#039;capacity_min&#039;,
                            &#039;capacity_max&#039;,
                            &#039;description_image_id&#039;);
    return $params_to_save;
  }

  protected function allowed_params($role = &#039;admin&#039;){
    $allowed_params = array(&#039;id&#039;, 
                            &#039;name&#039;, 
                            &#039;short_description&#039;, 
                            &#039;category_id&#039;,
                            &#039;selection_image_id&#039;,
                            &#039;is_price_variable&#039;,
                            &#039;price_min&#039;,
                            &#039;price_max&#039;,
                            &#039;charge_amount&#039;,
                            &#039;deposit_amount&#039;,
                            &#039;duration_name&#039;,
                            &#039;duration&#039;,
                            &#039;buffer_before&#039;,
                            &#039;buffer_after&#039;,
                            &#039;bg_color&#039;,
                            &#039;timeblock_interval&#039;,
                            &#039;override_default_booking_status&#039;,
                            &#039;order_number&#039;,
                            &#039;visibility&#039;,
							&#039;earliest_possible_booking&#039;,
							&#039;latest_possible_booking&#039;,
                            &#039;status&#039;,
                            &#039;capacity_min&#039;,
                            &#039;capacity_max&#039;,
                            &#039;description_image_id&#039;);
    return $allowed_params;
  }


	public function prepare_data_before_it_is_set( $data ) {
		if ( isset( $data[&#039;name&#039;] ) ) {
			$data[&#039;name&#039;] = sanitize_text_field( $data[&#039;name&#039;] );
		}
		if ( isset( $data[&#039;short_description&#039;] ) ) {
			$data[&#039;short_description&#039;] = wp_kses_post( $data[&#039;short_description&#039;] );
		}


		return $data;
	}

	public function get_default_booking_status(){
		if(!empty($this-&gt;override_default_booking_status)){
			$all_statuses = OsBookingHelper::get_statuses_list();
			if(isset($all_statuses[$this-&gt;override_default_booking_status])) return $this-&gt;override_default_booking_status;
		}
		return OsBookingHelper::get_default_booking_status();
	}

  public function get_category_name(){
    if($this-&gt;category_id){
      $category = new OsServiceCategoryModel($this-&gt;category_id);
      if($category-&gt;exists()){
        return $category-&gt;name;
      }
    }
    return &#039;&#039;;
  }


  // determine how much capacity service can accept before the slot is blocked
  public function get_capacity_needed_before_slot_is_blocked(): int{
    $capacity_min = $this-&gt;capacity_min ? $this-&gt;capacity_min : 1;
    $capacity_max = $this-&gt;capacity_max ? $this-&gt;capacity_max : 1;
    return ($this-&gt;get_meta_by_key(&#039;block_timeslot_when_minimum_capacity_met&#039;, &#039;off&#039;) == &#039;on&#039;) ? $capacity_min : $capacity_max;
  }

  public function get_timeblock_interval(){
    if(!$this-&gt;timeblock_interval){
      $this-&gt;timeblock_interval = OsSettingsHelper::get_default_timeblock_interval();
    }
    return $this-&gt;timeblock_interval;
  }

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


  protected function before_create(){
  }

  public function should_show_capacity_selector(){
    return (($this-&gt;capacity_max != $this-&gt;capacity_min) &amp;&amp; ($this-&gt;get_meta_by_key(&#039;fixed_total_attendees&#039;, &#039;off&#039;) != &#039;on&#039;));
  }

	public function is_group_service(){
		return ($this-&gt;capacity_max &gt; 1);
	}

  public function get_all_durations_arr(){
    $durations = [[&#039;id&#039; =&gt; &#039;default&#039;, &#039;name&#039; =&gt; $this-&gt;duration_name, &#039;duration&#039; =&gt; $this-&gt;duration, &#039;charge_amount&#039; =&gt; $this-&gt;charge_amount, &#039;deposit_amount&#039; =&gt; $this-&gt;deposit_amount]];
    $durations = array_merge($durations, $this-&gt;get_extra_durations());
    return $durations;
  }

  public function get_extra_durations(){
    $durations = [];
    $extra_durations = $this-&gt;get_meta_by_key(&#039;durations&#039;, false);
    if($extra_durations){
      $extra_durations_arr = json_decode($extra_durations, true);
      if(!empty($extra_durations_arr)){
        foreach($extra_durations_arr as $duration_id =&gt; $extra_duration){
          $durations[] = [&#039;id&#039; =&gt; $duration_id, &#039;name&#039; =&gt; ($extra_duration[&#039;name&#039;] ?? &#039;&#039;), &#039;duration&#039; =&gt; $extra_duration[&#039;duration&#039;], &#039;charge_amount&#039; =&gt; $extra_duration[&#039;charge_amount&#039;], &#039;deposit_amount&#039; =&gt; $extra_duration[&#039;deposit_amount&#039;]];
        }
      }
    }
    return $durations;
  }

  public function get_full_amount_for_duration($duration = false){
    if($duration &amp;&amp; $duration != $this-&gt;duration){
      $extra_durations = $this-&gt;get_extra_durations();
      foreach($extra_durations as $extra_duration){
        if($extra_duration[&#039;duration&#039;] == $duration) return $extra_duration[&#039;charge_amount&#039;];
      }
    }
    return $this-&gt;charge_amount;
  }

  public function get_deposit_amount_for_duration($duration = false){
    if($duration &amp;&amp; $duration != $this-&gt;duration){
      $extra_durations = $this-&gt;get_extra_durations();
      foreach($extra_durations as $extra_duration){
        if($extra_duration[&#039;duration&#039;] == $duration) return $extra_duration[&#039;deposit_amount&#039;];
      }
    }
    return $this-&gt;deposit_amount;
  }

  protected function set_defaults(){
    if(empty($this-&gt;category_id)) $this-&gt;category_id = 0;
    if(empty($this-&gt;buffer_before)) $this-&gt;buffer_before = 0;
    if(empty($this-&gt;buffer_after)) $this-&gt;buffer_after = 0;
    if(empty($this-&gt;price_min)) $this-&gt;price_min = 0;
    if(empty($this-&gt;price_max)) $this-&gt;price_max = 0;
    if(empty($this-&gt;charge_amount)) $this-&gt;charge_amount = 0;
    if(empty($this-&gt;deposit_amount)) $this-&gt;deposit_amount = 0;
    if(empty($this-&gt;is_deposit_required)) $this-&gt;is_deposit_required = false;
    if(empty($this-&gt;status)) $this-&gt;status = LATEPOINT_SERVICE_STATUS_ACTIVE;
    if(empty($this-&gt;bg_color)) $this-&gt;bg_color = $this-&gt;generate_new_bg_color();
  }

  public function save_custom_schedule($work_periods){
    foreach($work_periods as &amp;$work_period){
      $work_period[&#039;service_id&#039;] = $this-&gt;id;
    }
    unset($work_period);
    OsWorkPeriodsHelper::save_work_periods($work_periods);
  }

  public function delete_custom_schedule(){
    $work_periods_model = new OsWorkPeriodModel();
    $work_periods = $work_periods_model-&gt;where(array(&#039;service_id&#039; =&gt; $this-&gt;id, &#039;agent_id&#039; =&gt; 0, &#039;location_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 generate_new_bg_color(){
    $services = new OsServiceModel();
    $service_colors_results = $services-&gt;select(&#039;bg_color&#039;)-&gt;group_by(&#039;bg_color&#039;)-&gt;get_results(ARRAY_A);
    $services_used_colors = array_map(function($service){ return $service[&#039;bg_color&#039;]; }, $service_colors_results);
    $default_colors = OsServiceHelper::get_default_colors();
    $colors_left = array_diff($default_colors, $services_used_colors);
    if(!empty($colors_left)){
      // reset array
      $colors_left = array_values($colors_left);
      $bg_color = $colors_left[0];
    }else{
      $bg_color = &#039;#3d52ea&#039;;
    }
    return $bg_color;
  }


  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;service_id&#039; =&gt; $id), array( &#039;%d&#039; ) );
      $this-&gt;db-&gt;delete(LATEPOINT_TABLE_WORK_PERIODS, array(&#039;service_id&#039; =&gt; $id), array( &#039;%d&#039; ) );
      $this-&gt;db-&gt;delete(LATEPOINT_TABLE_SERVICE_META, array(&#039;object_id&#039; =&gt; $id), array( &#039;%d&#039; ) );
      $this-&gt;db-&gt;delete(LATEPOINT_TABLE_BOOKINGS, array(&#039;service_id&#039; =&gt; $id), array( &#039;%d&#039; ) );
      do_action(&#039;latepoint_service_deleted&#039;, $id);
      return true;
    }else{
      return false;
    }
  }

	protected function params_to_sanitize(){
		return [&#039;charge_amount&#039; =&gt; &#039;money&#039;,
						&#039;deposit_amount&#039; =&gt; &#039;money&#039;,
			&#039;price_min&#039; =&gt; &#039;money&#039;,
			&#039;price_max&#039; =&gt; &#039;money&#039;,
			];
	}

  public function is_hidden(){
    return ($this-&gt;visibility == LATEPOINT_SERVICE_VISIBILITY_HIDDEN);
  }

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

  public function should_not_be_hidden(){
    return $this-&gt;where([&#039;visibility !=&#039; =&gt; LATEPOINT_SERVICE_VISIBILITY_HIDDEN]);
  }

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


  protected function get_price_min_formatted(){
    if($this-&gt;price_min &gt; 0){
      return OsMoneyHelper::format_price($this-&gt;price_min);
    }else{
      return OsMoneyHelper::format_price(0);
    }
  }


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

  public function get_description_image_url(){
    $default_service_image_url = LATEPOINT_IMAGES_URL . &#039;service-image.png&#039;;
    return OsImageHelper::get_image_url_by_id($this-&gt;description_image_id, &#039;full&#039;, $default_service_image_url);
  }


  public function connect_to_agent($agent_id, $location_id){
    $agent_connection_row = $this-&gt;db-&gt;get_row($this-&gt;db-&gt;prepare(&#039;SELECT id FROM &#039;.$this-&gt;services_agents_table_name.&#039; WHERE service_id = %d AND agent_id = %d AND location_id = %d&#039;, array($this-&gt;id, $agent_id, $location_id)));
    if($agent_connection_row){
      // update
    }else{
      $insert_data = array(&#039;agent_id&#039; =&gt; $agent_id, &#039;service_id&#039; =&gt; $this-&gt;id, &#039;location_id&#039; =&gt; $location_id);
      if($this-&gt;db-&gt;insert($this-&gt;services_agents_table_name, $insert_data)){
        return $this-&gt;db-&gt;insert_id;
      }
    }
  }

  public function save_durations($durations){
		foreach($durations as &amp;$duration){
			$duration[&#039;charge_amount&#039;] = OsParamsHelper::sanitize_param($duration[&#039;charge_amount&#039;], &#039;money&#039;);
			$duration[&#039;deposit_amount&#039;] = OsParamsHelper::sanitize_param($duration[&#039;deposit_amount&#039;], &#039;money&#039;);
		}
		unset($duration);
    $this-&gt;save_meta_by_key(&#039;durations&#039;, wp_json_encode($durations));
    return true;
  }


  public function delete_meta_by_key($meta_key){
    if($this-&gt;is_new_record()) return false;

    $meta = new OsServiceMetaModel();
    return $meta-&gt;delete_by_key($meta_key, $this-&gt;id);
  }

  public function get_meta_by_key($meta_key, $default = false){
    if($this-&gt;is_new_record()) return $default;

    $meta = new OsServiceMetaModel();
    return $meta-&gt;get_by_key($meta_key, $this-&gt;id, $default);
  }

  public function save_meta_by_key($meta_key, $meta_value){
    if($this-&gt;is_new_record()) return false;

    $meta = new OsServiceMetaModel();
    return $meta-&gt;save_by_key($meta_key, $meta_value, $this-&gt;id);
  }

  public function save_agents(){
    foreach($this-&gt;agents as $agent){
      $agent_connection_row = $this-&gt;db-&gt;get_row($this-&gt;db-&gt;prepare(&#039;SELECT id FROM &#039;.$this-&gt;services_agents_table_name.&#039; WHERE service_id = %d AND agent_id = %d&#039;, array($this-&gt;id, $agent-&gt;id)));
      if($agent_connection_row){
        $update_data = array(&#039;is_custom_hours&#039; =&gt; $agent-&gt;is_custom_hours, &#039;is_custom_price&#039; =&gt; $agent-&gt;is_custom_price, &#039;is_custom_duration&#039; =&gt; $agent-&gt;is_custom_duration);
        $this-&gt;db-&gt;update($this-&gt;services_agents_table_name, $update_data, array(&#039;id&#039; =&gt; $agent_connection_row-&gt;id));
      }else{
        $insert_data = array(&#039;agent_id&#039; =&gt; $agent-&gt;id, &#039;service_id&#039; =&gt; $this-&gt;id, &#039;is_custom_hours&#039; =&gt; $agent-&gt;is_custom_hours, &#039;is_custom_price&#039; =&gt; $agent-&gt;is_custom_price, &#039;is_custom_duration&#039; =&gt; $agent-&gt;is_custom_duration);
        if($this-&gt;db-&gt;insert($this-&gt;services_agents_table_name, $insert_data)){
          $agent_connection_row_id = $this-&gt;db-&gt;insert_id;
        }
      }
    }
    return true;
  }


  public function remove_agents_by_ids($ids_to_remove = array()){
    if($ids_to_remove){
      $query = $this-&gt;db-&gt;prepare(&#039;DELETE FROM %i WHERE service_id = %d AND agent_id IN &#039; . OsModel::where_in_array_to_string($ids_to_remove), [$this-&gt;services_agents_table_name, $this-&gt;id]);
      $this-&gt;db-&gt;query( $query );
    }
  }


  public function get_agent_ids_to_remove($new_agents = array()){
    $current_agent_ids = $this-&gt;get_current_agent_ids_from_db();
    $new_agent_ids = array();
    foreach($new_agents as $agent){
      if($agent[&#039;connected&#039;] == &quot;yes&quot;) $new_agent_ids[] = $agent[&#039;id&#039;];
    }
    $agent_ids_to_remove = array_diff($current_agent_ids, $new_agent_ids);
    return $agent_ids_to_remove;
  }


  public function save_agents_and_locations($agents){
    if(!$agents) return true;
    $connections_to_save = [];
    $connections_to_remove = [];
    foreach($agents as $agent_key =&gt; $locations){
      $agent_id = str_replace(&#039;agent_&#039;, &#039;&#039;, $agent_key);
      foreach($locations as $location_key =&gt; $location){
        $location_id = str_replace(&#039;location_&#039;, &#039;&#039;, $location_key);
        $connection = [&#039;service_id&#039; =&gt; $this-&gt;id, &#039;agent_id&#039; =&gt; $agent_id, &#039;location_id&#039; =&gt; $location_id];
        if($location[&#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 get_current_agent_ids_from_db(){
    $query = $this-&gt;db-&gt;prepare(&#039;SELECT agent_id FROM &#039;.$this-&gt;services_agents_table_name.&#039; WHERE service_id = %d&#039;, $this-&gt;id);
    $agent_rows = $this-&gt;db-&gt;get_results( $query );

    $agent_ids = array();

    if($agent_rows){
      foreach($agent_rows as $agent_row){
        $agent_ids[] = $agent_row-&gt;agent_id;
      }
    }
    return $agent_ids;
  }


  public function get_current_agent_ids(){
    $agent_ids = array();
    foreach($this-&gt;agents as $agent){
      $agent_ids[] = $agent-&gt;id;
    }
    return $agent_ids;
  }


  public function get_agents(){
    if(!isset($this-&gt;agents)){
      $query = &#039;SELECT * FROM &#039;.$this-&gt;services_agents_table_name.&#039; WHERE service_id = %d GROUP BY agent_id&#039;;
      $query_args = array($this-&gt;id);
      $agents_rows = $this-&gt;get_query_results( $query, $query_args );

      $this-&gt;agents = array();

      if($agents_rows){
        foreach($agents_rows as $agent_row){
          $agent = new OsAgentModel($agent_row-&gt;agent_id);
          $agent-&gt;is_custom_hours = $agent_row-&gt;is_custom_hours;
          $agent-&gt;is_custom_price = $agent_row-&gt;is_custom_price;
          $agent-&gt;is_custom_duration = $agent_row-&gt;is_custom_duration;
          $this-&gt;agents[] = $agent;
        }
      }
    }
    return $this-&gt;agents;
  }

  public function set_agents($agent_datas){
    $this-&gt;agents = array();

    foreach($agent_datas as $agent_data){
      if($agent_data[&#039;connected&#039;] == &quot;yes&quot;){
        $agent = new OsAgentModel();
        $agent-&gt;id = $agent_data[&#039;id&#039;];
        $agent-&gt;is_custom_hours = $agent_data[&#039;is_custom_hours&#039;];
        $agent-&gt;is_custom_price = $agent_data[&#039;is_custom_price&#039;];
        $agent-&gt;is_custom_duration = $agent_data[&#039;is_custom_duration&#039;];
        $this-&gt;agents[] = $agent;
      }
    }
    return $this;
  }


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

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

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


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