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

/**
 * @property string $full_name
 */
class OsAgentModel extends OsModel {
	public $id,
		$first_name = &#039;&#039;,
		$last_name = &#039;&#039;,
		$display_name,
		$email,
		$phone,
		$password,
		$avatar_image_id,
		$bio_image_id,
		$is_custom_price = false,
		$is_custom_hours = false,
		$is_custom_duration = false,
		$custom_hours,
		$wp_user_id,
		$title,
		$bio,
		$features,
		$extra_emails,
		$extra_phones,
		$status,
		$meta_class = &#039;OsAgentMetaModel&#039;,
		$updated_at,
		$created_at,
		$services_agents_table_name;

	function __construct($id = false) {
		parent::__construct();
		$this-&gt;table_name = LATEPOINT_TABLE_AGENTS;
		$this-&gt;services_agents_table_name = LATEPOINT_TABLE_AGENTS_SERVICES;
		$this-&gt;nice_names = array(
			&#039;first_name&#039; =&gt; __(&#039;First Name&#039;, &#039;latepoint&#039;),
			&#039;password&#039; =&gt; __(&#039;Password&#039;, &#039;latepoint&#039;),
			&#039;email&#039; =&gt; __(&#039;Email Address&#039;, &#039;latepoint&#039;),
			&#039;wp_user_id&#039; =&gt; __(&#039;Connected WordPress User&#039;, &#039;latepoint&#039;),
			&#039;last_name&#039; =&gt; __(&#039;Last Name&#039;, &#039;latepoint&#039;));

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


	public function get_initials(){
		return mb_substr($this-&gt;first_name,0,1).mb_substr($this-&gt;last_name,0,1);
	}

	public function get_edit_link(){
		return OsRouterHelper::build_link([&#039;agents&#039;, &#039;edit_form&#039;], [&#039;id&#039; =&gt; $this-&gt;id] );
	}

	public function generate_data_vars(): array {
		return [
			&#039;id&#039; =&gt; $this-&gt;id,
			&#039;full_name&#039; =&gt; $this-&gt;full_name,
			&#039;email&#039; =&gt; $this-&gt;email,
			&#039;phone&#039; =&gt; $this-&gt;phone
		];
	}

	protected function params_to_save($role = &#039;admin&#039;) {
		$params_to_save = array(&#039;id&#039;,
			&#039;first_name&#039;,
			&#039;last_name&#039;,
			&#039;display_name&#039;,
			&#039;email&#039;,
			&#039;phone&#039;,
			&#039;password&#039;,
			&#039;wp_user_id&#039;,
			&#039;bio_image_id&#039;,
			&#039;title&#039;,
			&#039;bio&#039;,
			&#039;features&#039;,
			&#039;status&#039;,
			&#039;extra_emails&#039;,
			&#039;extra_phones&#039;,
			&#039;avatar_image_id&#039;,
			&#039;custom_hours&#039;);
		return $params_to_save;
	}

	protected function allowed_params($role = &#039;admin&#039;) {
		$allowed_params = array(&#039;id&#039;,
			&#039;first_name&#039;,
			&#039;last_name&#039;,
			&#039;display_name&#039;,
			&#039;email&#039;,
			&#039;phone&#039;,
			&#039;password&#039;,
			&#039;wp_user_id&#039;,
			&#039;bio_image_id&#039;,
			&#039;title&#039;,
			&#039;bio&#039;,
			&#039;features&#039;,
			&#039;extra_emails&#039;,
			&#039;extra_phones&#039;,
			&#039;status&#039;,
			&#039;avatar_image_id&#039;,
			&#039;custom_hours&#039;);
		return $allowed_params;
	}


	protected function properties_to_validate() {
		$validations = array(
			&#039;email&#039; =&gt; array(&#039;presence&#039;),
			&#039;wp_user_id&#039; =&gt; array(&#039;uniqueness&#039;),
		);
		return $validations;
	}


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

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

		$meta = new OsAgentMetaModel();
		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 OsAgentMetaModel();
		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 OsAgentMetaModel();
		return $meta-&gt;save_by_key($meta_key, $meta_value, $this-&gt;id);
	}

	protected function set_defaults() {
		if (empty($this-&gt;status)) $this-&gt;status = LATEPOINT_AGENT_STATUS_ACTIVE;
	}

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


	protected function get_total_future_bookings() {
		$bookings = new OsBookingModel();
		$total = $bookings-&gt;where([&#039;agent_id&#039; =&gt; $this-&gt;id])-&gt;should_be_in_future()-&gt;count();
		return $total;
	}

	protected function get_total_synced_future_bookings() {
		$bookings = new OsBookingModel();
		$total = $bookings-&gt;where([&#039;agent_id&#039; =&gt; $this-&gt;id, LATEPOINT_TABLE_BOOKING_META.&#039;.meta_key&#039; =&gt; &#039;google_calendar_event_id&#039;])
			-&gt;join(LATEPOINT_TABLE_BOOKING_META, [&#039;object_id&#039; =&gt; LATEPOINT_TABLE_BOOKINGS . &#039;.id&#039;])
			-&gt;should_be_in_future()
			-&gt;count();
		return $total;
	}

	protected function get_future_bookings($limit = false) {
		$bookings = new OsBookingModel();
		if ($limit) {
			$bookings = $bookings-&gt;set_limit($limit);
		}
		return $bookings-&gt;order_by(&#039;start_date, start_time asc&#039;)-&gt;where([&#039;agent_id&#039; =&gt; $this-&gt;id])-&gt;should_be_in_future()-&gt;get_results_as_models();
	}

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

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

	public function get_features_arr() {
		$features_arr = [];
		if (!empty($this-&gt;features)) {
			$features = json_decode($this-&gt;features, true);
			if(!empty($features)){
				foreach ($features as $feature) {
					if ($feature[&#039;value&#039;] &amp;&amp; $feature[&#039;label&#039;]) $features_arr[] = $feature;
				}
			}
		}
		return $features_arr;
	}

	public function save_custom_schedule($work_periods) {
		foreach ($work_periods as &amp;$work_period) {
			$work_period[&#039;agent_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;agent_id&#039; =&gt; $this-&gt;id, &#039;service_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 has_service($service_id) {
		foreach ($this-&gt;services as $service) {
			if ($service-&gt;id == $service_id) return true;
		}
		return false;
	}


	public function save_services() {
		foreach ($this-&gt;services as $service) {
			$service_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 agent_id = %d AND service_id = %d&#039;, array($this-&gt;id, $service-&gt;id)));
			if ($service_connection_row) {
				$update_data = array(&#039;is_custom_hours&#039; =&gt; $service-&gt;is_custom_hours, &#039;is_custom_price&#039; =&gt; $service-&gt;is_custom_price, &#039;is_custom_duration&#039; =&gt; $service-&gt;is_custom_duration);
				$this-&gt;db-&gt;update($this-&gt;services_agents_table_name, $update_data, array(&#039;id&#039; =&gt; $service_connection_row-&gt;id));
			} else {
				$insert_data = array(&#039;service_id&#039; =&gt; $service-&gt;id, &#039;agent_id&#039; =&gt; $this-&gt;id, &#039;is_custom_hours&#039; =&gt; $service-&gt;is_custom_hours, &#039;is_custom_price&#039; =&gt; $service-&gt;is_custom_price, &#039;is_custom_duration&#039; =&gt; $service-&gt;is_custom_duration);
				if ($this-&gt;db-&gt;insert($this-&gt;services_agents_table_name, $insert_data)) {
					$service_connection_row_id = $this-&gt;db-&gt;insert_id;
				}
			}
		}
		return true;
	}


	public function remove_services_by_ids($ids_to_remove = array()) {
		if ($ids_to_remove) {
			$query = $this-&gt;db-&gt;prepare(&#039;DELETE FROM %i WHERE agent_id = %d AND service_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_service_ids_to_remove($new_services = array()) {
		$current_service_ids = $this-&gt;get_current_service_ids_from_db();
		$new_service_ids = array();
		foreach ($new_services as $service) {
			if ($service[&#039;connected&#039;] == &quot;yes&quot;) $new_service_ids[] = $service[&#039;id&#039;];
		}
		$service_ids_to_remove = array_diff($current_service_ids, $new_service_ids);
		return $service_ids_to_remove;
	}


	public function save_locations_and_services($services) {
		if (!$services) return true;
		$connections_to_save = [];
		$connections_to_remove = [];
		foreach ($services as $service_key =&gt; $locations) {
			$service_id = str_replace(&#039;service_&#039;, &#039;&#039;, $service_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; $service_id, &#039;agent_id&#039; =&gt; $this-&gt;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 set_features($features) {
		$this-&gt;features = wp_json_encode($features);
	}

	public function get_current_service_ids_from_db() {
		$query = $this-&gt;db-&gt;prepare(&#039;SELECT service_id FROM &#039; . $this-&gt;services_agents_table_name . &#039; WHERE agent_id = %d&#039;, $this-&gt;id);
		$service_rows = $this-&gt;db-&gt;get_results($query);

		$service_ids = array();

		if ($service_rows) {
			foreach ($service_rows as $service_row) {
				$service_ids[] = $service_row-&gt;service_id;
			}
		}
		return $service_ids;
	}


	public function get_current_service_ids() {
		$service_ids = array();
		foreach ($this-&gt;services as $service) {
			$service_ids[] = $service-&gt;id;
		}
		return $service_ids;
	}

	public function set_services($service_datas) {
		$this-&gt;services = array();

		foreach ($service_datas as $service_data) {
			if ($service_data[&#039;connected&#039;] == &quot;yes&quot;) {
				$service = new OsserviceModel();
				$service-&gt;id = $service_data[&#039;id&#039;];
				$service-&gt;is_custom_hours = $service_data[&#039;is_custom_hours&#039;];
				$service-&gt;is_custom_price = $service_data[&#039;is_custom_price&#039;];
				$service-&gt;is_custom_duration = $service_data[&#039;is_custom_duration&#039;];
				$this-&gt;services[] = $service;
			}
		}
		return $this;
	}

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

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

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

			if ($services_rows) {
				foreach ($services_rows as $service_row) {
					$service = new OsServiceModel($service_row-&gt;service_id);
					$service-&gt;is_custom_hours = $service_row-&gt;is_custom_hours;
					$service-&gt;is_custom_price = $service_row-&gt;is_custom_price;
					$service-&gt;is_custom_duration = $service_row-&gt;is_custom_duration;
					$this-&gt;services[] = $service;
				}
			}
		}
		return $this-&gt;services;
	}


	protected function before_create() {
		if (empty($this-&gt;password)) $this-&gt;password = wp_hash_password(bin2hex(openssl_random_pseudo_bytes(8)));
	}

	protected function before_save() {
	}

	public function get_full_name() {
		$full_name = trim(join(&#039; &#039;, array($this-&gt;first_name, $this-&gt;last_name)));
		return  empty($full_name) ? __(&#039;Agent&#039;, &#039;latepoint&#039;) : $full_name;
	}

	protected function get_name_for_front() {
		if (isset($this-&gt;display_name) &amp;&amp; !empty($this-&gt;display_name)) {
			return $this-&gt;display_name;
		} else {
			return $this-&gt;get_full_name();
		}
	}

	public function get_avatar_url() {
		return OsAgentHelper::get_avatar_url($this);
	}

	public function get_avatar_image() {
		return &#039;&lt;img src=&quot;&#039; . $this-&gt;get_avatar_url() . &#039;&quot;/&gt;&#039;;
	}

	public function get_bio_image_url() {
		return OsAgentHelper::get_bio_image_url($this);
	}

	public function get_bio_image() {
		return &#039;&lt;img src=&quot;&#039; . $this-&gt;get_bio_image_url() . &#039;&quot;/&gt;&#039;;
	}


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


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