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
/*
 * Copyright (c) 2021 LatePoint LLC. All rights reserved.
 */

namespace LatePoint\Misc;

class Filter {
	public $service_id = 0;
	public $agent_id = 0;
	public $location_id = 0;

	public $connections = [];

	public ?int $week_day = null;
	public ?string $date_from = null;
	public ?string $date_to = null;

	public ?int $start_time = null;
	public ?int $end_time = null;

	public array $statuses = [];
	public array $exclude_booking_ids = [];
	public bool $consider_cart_items = false;
	public bool $exact_match = false;

	function __construct( array $args = [] ) {
		$allowed_args = [
			&#039;service_id&#039;,
			&#039;agent_id&#039;,
			&#039;location_id&#039;,
			&#039;connections&#039;,
			&#039;date_from&#039;,
			&#039;date_to&#039;,
			&#039;start_time&#039;,
			&#039;end_time&#039;,
			&#039;week_day&#039;,
			&#039;statuses&#039;,
			&#039;exclude_booking_ids&#039;,
			&#039;exact_match&#039;
		];
		foreach ( $args as $key =&gt; $arg ) {
			if ( in_array( $key, $allowed_args ) ) {
				$this-&gt;$key = $arg;
			}
		}
	}

	public function build_query_args_for_blocked_periods(): array {

		$query_args = [];

		// if connections are passed - query by connection
		if ( $this-&gt;connections ) {
			$connection_conditions = [];
			foreach ( $this-&gt;connections as $connection ) {
				$connection_conditions[] = [ &#039;AND&#039; =&gt; [ &#039;agent_id&#039;    =&gt; [ 0, $connection-&gt;agent_id ],
				                                        &#039;service_id&#039;  =&gt; [ 0, $connection-&gt;service_id ],
				                                        &#039;location_id&#039; =&gt; [ 0, $connection-&gt;location_id ]
				]
				];
			}
			$query_args[&#039;AND&#039;][] = [ &#039;OR&#039; =&gt; $connection_conditions ];
		} else {
			// Service query
			if ( $this-&gt;exact_match ) {
				// search only for schedules that belong to passed service_id
				$query_args[&#039;service_id&#039;] = $this-&gt;service_id;
			} else {
				$query_args[&#039;service_id&#039;] = array_unique( is_array( $this-&gt;service_id ) ? array_merge( $this-&gt;service_id, [ 0 ] ) : [ $this-&gt;service_id, 0 ] );
			}

			// Location query
			if ( $this-&gt;exact_match ) {
				// search only for schedules that belong to passed location_id
				$query_args[&#039;location_id&#039;] = $this-&gt;location_id;
			} else {
				$query_args[&#039;location_id&#039;] = array_unique( is_array( $this-&gt;location_id ) ? array_merge( $this-&gt;location_id, [ 0 ] ) : [ $this-&gt;location_id, 0 ] );
			}

			// Agent query
			if ( $this-&gt;exact_match ) {
				// search only for schedules that belong to passed agent_id
				$query_args[&#039;agent_id&#039;] = $this-&gt;agent_id;
			} else {
				$query_args[&#039;agent_id&#039;] = array_unique( is_array( $this-&gt;agent_id ) ? array_merge( $this-&gt;agent_id, [ 0 ] ) : [ $this-&gt;agent_id, 0 ] );
			}
		}


		if ( $this-&gt;date_from ) {
			$query_args[&#039;start_date &gt;=&#039;] = $this-&gt;date_from;
			$query_args[&#039;start_date &lt;=&#039;] = $this-&gt;date_to;
		}

		return $query_args;
	}

	public static function create_from_booking_request( BookingRequest $booking_request ): Filter {
		return new self( [
			&#039;date_from&#039;   =&gt; $booking_request-&gt;start_date,
			&#039;start_time&#039;  =&gt; $booking_request-&gt;start_time,
			&#039;end_time&#039;    =&gt; $booking_request-&gt;end_time,
			&#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
		] );
	}

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