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
if ( ! defined( &#039;ABSPATH&#039; ) ) {
  exit; // Exit if accessed directly.
}


if ( ! class_exists( &#039;OsDashboardController&#039; ) ) :


  class OsDashboardController extends OsController {

    private $booking;


    function __construct(){
      parent::__construct();

      $this-&gt;views_folder = LATEPOINT_VIEWS_ABSPATH . &#039;dashboard/&#039;;
      $this-&gt;vars[&#039;page_header&#039;] = __(&#039;Dashboard&#039;, &#039;latepoint&#039;);

    }


		public function pro_agents(){

		}

	  /*
			Index
		*/

    public function index(){
      $this-&gt;vars[&#039;page_header&#039;] = false;

      ob_start();
      $this-&gt;widget_bookings_and_availability_timeline();
      $this-&gt;vars[&#039;widget_bookings_and_availability_timeline&#039;] = ob_get_clean();

      ob_start();
      $this-&gt;widget_daily_bookings_chart();
      $this-&gt;vars[&#039;widget_daily_bookings_chart&#039;] = ob_get_clean();

      ob_start();
      $this-&gt;widget_upcoming_appointments(3);
      $this-&gt;vars[&#039;widget_upcoming_appointments&#039;] = ob_get_clean();

      $this-&gt;set_layout(&#039;admin&#039;);
      $this-&gt;format_render(__FUNCTION__);
    }

    public function widget_upcoming_appointments($limit = 3){
      $agents = new OsAgentModel();
      $services = new OsServiceModel();
      $bookings = new OsBookingModel();
      $locations = new OsLocationModel();

      $selected_agent_id = isset($this-&gt;params[&#039;agent_id&#039;]) ? OsAuthHelper::get_current_user()-&gt;check_if_allowed_record_id($this-&gt;params[&#039;agent_id&#039;], &#039;agent&#039;) : false;
      $selected_service_id = isset($this-&gt;params[&#039;service_id&#039;]) ? OsAuthHelper::get_current_user()-&gt;check_if_allowed_record_id($this-&gt;params[&#039;service_id&#039;], &#039;service&#039;) : false;
      $selected_location_id = isset($this-&gt;params[&#039;location_id&#039;]) ? OsAuthHelper::get_current_user()-&gt;check_if_allowed_record_id($this-&gt;params[&#039;location_id&#039;], &#039;location&#039;) : false;

      $this-&gt;vars[&#039;upcoming_bookings&#039;] = $bookings-&gt;get_upcoming_bookings($selected_agent_id, false, $selected_service_id, $selected_location_id, $limit);

      $this-&gt;vars[&#039;agents&#039;] = $agents-&gt;should_be_active()-&gt;filter_allowed_records()-&gt;get_results_as_models();
      $this-&gt;vars[&#039;services&#039;] = $services-&gt;should_be_active()-&gt;filter_allowed_records()-&gt;get_results_as_models();
      $this-&gt;vars[&#039;locations&#039;] = $locations-&gt;should_be_active()-&gt;filter_allowed_records()-&gt;get_results_as_models();

      $this-&gt;vars[&#039;selected_agent_id&#039;] = $selected_agent_id;
      $this-&gt;vars[&#039;selected_service_id&#039;] = $selected_service_id;
      $this-&gt;vars[&#039;selected_location_id&#039;] = $selected_location_id;


      $this-&gt;set_layout(&#039;none&#039;);
      $this-&gt;format_render(__FUNCTION__);
    }


    public function widget_daily_bookings_chart($date_from = false, $date_to = false){
      if($date_from == false){
        $date_from = isset($this-&gt;params[&#039;date_from&#039;]) ? OsWpDateTime::os_createFromFormat(&#039;Y-m-d&#039;, $this-&gt;params[&#039;date_from&#039;]) : new OsWpDateTime(&#039;-1 week&#039;);
      }
      if($date_to == false){
        $date_to = isset($this-&gt;params[&#039;date_to&#039;]) ? OsWpDateTime::os_createFromFormat(&#039;Y-m-d&#039;, $this-&gt;params[&#039;date_to&#039;]) : new OsWpDateTime(&#039;now&#039;);
      }


			$filter = new \LatePoint\Misc\Filter();
			$filter = OsRolesHelper::filter_allowed_records_from_arguments_or_filter($filter);

      if(!empty($this-&gt;params[&#039;agent_id&#039;])) $filter-&gt;agent_id = $this-&gt;params[&#039;agent_id&#039;];
      if(!empty($this-&gt;params[&#039;service_id&#039;])) $filter-&gt;service_id = $this-&gt;params[&#039;service_id&#039;];
      if(!empty($this-&gt;params[&#039;location_id&#039;])) $filter-&gt;location_id = $this-&gt;params[&#039;location_id&#039;];

			if(!OsRolesHelper::are_all_records_allowed()){
				if(!OsRolesHelper::are_all_records_allowed(&#039;agent&#039;)) $agent_id = OsRolesHelper::get_allowed_records(&#039;agent&#039;);
			}


      $daily_bookings = OsBookingHelper::get_total_bookings_per_day_for_period($date_from-&gt;format(&#039;Y-m-d&#039;), $date_to-&gt;format(&#039;Y-m-d&#039;), $filter);

      $daily_chart_data = [];
      // fill data array with all the days
      for($day_date=clone $date_from; $day_date&lt;=$date_to; $day_date-&gt;modify(&#039;+1 day&#039;)){
        $daily_chart_data[OsTimeHelper::get_nice_date_with_optional_year($day_date-&gt;format(&#039;Y-m-d&#039;), false, true)] = 0;
      }
      // update the days with count of bookings
      foreach($daily_bookings as $bookings_for_day){
        $daily_chart_data[OsTimeHelper::get_nice_date_with_optional_year(gmdate( &#039;Y-m-d&#039;, strtotime($bookings_for_day-&gt;start_date)), false, true)] = $bookings_for_day-&gt;bookings_per_day;
      }

      $this-&gt;vars[&#039;total_bookings&#039;] = OsBookingHelper::get_stat_for_period(&#039;bookings&#039;, $date_from-&gt;format(&#039;Y-m-d&#039;), $date_to-&gt;format(&#039;Y-m-d&#039;), $filter);
      $this-&gt;vars[&#039;total_price&#039;] = OsBookingHelper::get_stat_for_period(&#039;price&#039;, $date_from-&gt;format(&#039;Y-m-d&#039;), $date_to-&gt;format(&#039;Y-m-d&#039;), $filter);
      $this-&gt;vars[&#039;total_duration&#039;] = OsBookingHelper::get_stat_for_period(&#039;duration&#039;, $date_from-&gt;format(&#039;Y-m-d&#039;), $date_to-&gt;format(&#039;Y-m-d&#039;), $filter);
      $this-&gt;vars[&#039;total_new_customers&#039;] = OsBookingHelper::get_new_customer_stat_for_period($date_from, $date_to, $filter);

      $day_difference = $date_from-&gt;diff($date_to);
      $day_difference = ($day_difference-&gt;d &gt; 0) ? $day_difference-&gt;d : 1;

      $prev_date_from = clone $date_from;
      $prev_date_from-&gt;modify(&#039;-&#039;.$day_difference.&#039; days&#039;);
      $prev_date_to = clone $date_to;
      $prev_date_to-&gt;modify(&#039;-&#039;.$day_difference.&#039; days&#039;);

      $this-&gt;vars[&#039;prev_total_bookings&#039;] = OsBookingHelper::get_stat_for_period(&#039;bookings&#039;, $prev_date_from-&gt;format(&#039;Y-m-d&#039;), $prev_date_to-&gt;format(&#039;Y-m-d&#039;), $filter);
      $this-&gt;vars[&#039;prev_total_price&#039;] = OsBookingHelper::get_stat_for_period(&#039;price&#039;, $prev_date_from-&gt;format(&#039;Y-m-d&#039;), $prev_date_to-&gt;format(&#039;Y-m-d&#039;), $filter);
      $this-&gt;vars[&#039;prev_total_duration&#039;] = OsBookingHelper::get_stat_for_period(&#039;duration&#039;, $prev_date_from-&gt;format(&#039;Y-m-d&#039;), $prev_date_to-&gt;format(&#039;Y-m-d&#039;), $filter);
      $this-&gt;vars[&#039;prev_total_new_customers&#039;] = OsBookingHelper::get_new_customer_stat_for_period($prev_date_from, $prev_date_to, $filter);


      $agents = new OsAgentModel();
      $services = new OsServiceModel();
      $locations = new OsLocationModel();

      $this-&gt;vars[&#039;agents&#039;] = $agents-&gt;should_be_active()-&gt;filter_allowed_records()-&gt;get_results_as_models();
      $this-&gt;vars[&#039;services&#039;] = $services-&gt;should_be_active()-&gt;filter_allowed_records()-&gt;get_results_as_models();
      $this-&gt;vars[&#039;locations&#039;] = $locations-&gt;should_be_active()-&gt;filter_allowed_records()-&gt;get_results_as_models();

      $this-&gt;vars[&#039;filter&#039;] = $filter;

      $this-&gt;vars[&#039;date_from&#039;] = $date_from-&gt;format(&#039;Y-m-d&#039;);
      $this-&gt;vars[&#039;date_to&#039;] = $date_to-&gt;format(&#039;Y-m-d&#039;);

      $this-&gt;vars[&#039;daily_bookings_chart_labels_string&#039;] = implode(&#039;,&#039;, array_keys($daily_chart_data));
      $this-&gt;vars[&#039;daily_bookings_chart_data_values_string&#039;] = implode(&#039;,&#039;, array_values($daily_chart_data));

      $pie_labels = [];
      $pie_colors = [];
      $pie_values = [];
      $pie_chart_data = OsBookingHelper::get_stat_for_period(&#039;bookings&#039;, $date_from-&gt;format(&#039;Y-m-d&#039;), $date_to-&gt;format(&#039;Y-m-d&#039;), $filter,&#039;service_id&#039;);
      foreach($pie_chart_data as $pie_data){
        $service = new OsServiceModel($pie_data[&#039;service_id&#039;]);
        $pie_labels[] = $service-&gt;name;
        $pie_colors[] = $service-&gt;bg_color;
        $pie_values[] = $pie_data[&#039;stat&#039;];
      }

      $this-&gt;vars[&#039;pie_chart_data&#039;] = [&#039;labels&#039; =&gt; $pie_labels, &#039;colors&#039; =&gt; $pie_colors, &#039;values&#039; =&gt; $pie_values];

      $this-&gt;vars[&#039;date_period_string&#039;] = OsTimeHelper::format_date_with_locale(OsSettingsHelper::get_readable_date_format(true, true), $date_from).&#039; - &#039;.OsTimeHelper::format_date_with_locale(OsSettingsHelper::get_readable_date_format(true, true), $date_to);

      $this-&gt;set_layout(&#039;none&#039;);
      $this-&gt;format_render(__FUNCTION__);
    }


    public function widget_bookings_and_availability_timeline(){
      $target_date = isset($this-&gt;params[&#039;date_from&#039;]) ? OsWpDateTime::os_createFromFormat(&#039;Y-m-d&#039;, $this-&gt;params[&#039;date_from&#039;]) : new OsWpDateTime(&#039;now&#039;);

      $services = new OsServiceModel();
      $agents = new OsAgentModel();
      $locations = new OsLocationModel();

      $agents_models = $agents-&gt;should_be_active()-&gt;filter_allowed_records()-&gt;get_results_as_models();
      $services_models = $services-&gt;should_be_active()-&gt;filter_allowed_records()-&gt;get_results_as_models();
      $locations_models = $locations-&gt;should_be_active()-&gt;filter_allowed_records()-&gt;get_results_as_models();

      $this-&gt;vars[&#039;services&#039;]   = $services_models;
      $this-&gt;vars[&#039;locations&#039;]  = $locations_models;
      $this-&gt;vars[&#039;agents&#039;]     = $agents_models;

      if($services_models &amp;&amp; !empty($this-&gt;params[&#039;service_id&#039;])){
        $selected_service = $services-&gt;load_by_id($this-&gt;params[&#039;service_id&#039;]);
      }else{
        $selected_service = false;
      }


      if($locations_models){
        // show all locations option if agent can only be present at one place - because it means he does not have overlapping appointments on the calendar
        $default_location_id = OsSettingsHelper::is_on(&#039;one_location_at_time&#039;) ? false : $locations_models[0]-&gt;id;
        $selected_location_id = !empty($this-&gt;params[&#039;location_id&#039;]) ? $this-&gt;params[&#039;location_id&#039;] : $default_location_id;
      }else{
        $selected_location_id = false;
      }

      $this-&gt;vars[&#039;selected_location&#039;] = $selected_location_id ? new OsLocationModel($selected_location_id) : false;
      $this-&gt;vars[&#039;selected_location_id&#039;] = $selected_location_id;

      $timeblock_interval = OsSettingsHelper::get_default_timeblock_interval();
      $selected_service_id = ($selected_service) ? $selected_service-&gt;id : false;

      $this-&gt;vars[&#039;selected_service&#039;] = $selected_service;
      $this-&gt;vars[&#039;selected_service_id&#039;] = $selected_service_id;


			// we are using two separate booking requests because the calendar on top has to generate availability timeline,
	    // which can only be generated if we know service to check for. The second booking request is used to retrieve
	    // shared resources for all services and locations (unless specific location is selected)
			$availability_booking_request = new \LatePoint\Misc\BookingRequest([&#039;start_date&#039; =&gt; $target_date-&gt;format(&#039;Y-m-d&#039;)]);
			$general_booking_request = new \LatePoint\Misc\BookingRequest([&#039;start_date&#039; =&gt; $target_date-&gt;format(&#039;Y-m-d&#039;)]);
			if($selected_location_id){
				$availability_booking_request-&gt;location_id = $selected_location_id;
				$general_booking_request-&gt;location_id = $selected_location_id;
			}
			if($selected_service){
				$availability_booking_request-&gt;service_id = $selected_service-&gt;id;
				// TODO add capacity and duration select box and POST params if multiple durations in a service
				$availability_booking_request-&gt;duration = $selected_service-&gt;duration;
				$timeblock_interval = $selected_service-&gt;get_timeblock_interval();
			}

      if(count($agents_models) == 1) {
				$availability_booking_request-&gt;agent_id = $agents_models[0]-&gt;id;
				$general_booking_request-&gt;agent_id = $agents_models[0]-&gt;id;
      }

			$settings = [&#039;accessed_from_backend&#039; =&gt; true];
			$resources = OsResourceHelper::get_resources_grouped_by_day($general_booking_request, $target_date, $target_date, $settings);
			$availability_resources = OsResourceHelper::get_resources_grouped_by_day($availability_booking_request, $target_date, $target_date, $settings);
			$work_boundaries = OsResourceHelper::get_work_boundaries_for_resources($resources[$target_date-&gt;format(&#039;Y-m-d&#039;)]);
			$work_total_minutes = $work_boundaries-&gt;end_time - $work_boundaries-&gt;start_time;

      $this-&gt;vars[&#039;timeblock_interval&#039;] = $timeblock_interval;

      $bookings = [];
			$agent_work_time_periods = [];
      if($agents_models){
        foreach($agents_models as $agent){
					$agent_work_time_periods[$agent-&gt;id] = [];
          $args = [&#039;agent_id&#039; =&gt; $agent-&gt;id];
          if($selected_location_id) $args[&#039;location_id&#039;] = $selected_location_id;
					$args[&#039;status&#039;] = OsCalendarHelper::get_booking_statuses_to_display_on_calendar();
					$args = OsRolesHelper::filter_allowed_records_from_arguments_or_filter($args);
          $bookings[$agent-&gt;id] = OsBookingHelper::get_bookings_for_date($target_date-&gt;format(&#039;Y-m-d&#039;), $args);
        }
				foreach($availability_resources[$target_date-&gt;format(&#039;Y-m-d&#039;)] as $resource){
					if(isset($agent_work_time_periods[$resource-&gt;agent_id])) $agent_work_time_periods[$resource-&gt;agent_id] = array_merge($agent_work_time_periods[$resource-&gt;agent_id], $resource-&gt;work_time_periods);
				}
      }


      $this-&gt;vars[&#039;agent_work_time_periods&#039;] = $agent_work_time_periods;

			$this-&gt;vars[&#039;availability_booking_request&#039;] = $availability_booking_request;
			$this-&gt;vars[&#039;general_booking_request&#039;] = $general_booking_request;

			$agents_resources = [];
			foreach ($agents_models as $agent) {
				$agent_booking_request = clone $availability_booking_request;
				$agent_booking_request-&gt;agent_id = $agent-&gt;id;
				$daily_resources = OsResourceHelper::get_resources_grouped_by_day($agent_booking_request, $target_date, null, $settings);
				$agents_resources[&#039;agent_&#039; . $agent-&gt;id] = $daily_resources[$target_date-&gt;format(&#039;Y-m-d&#039;)];
			}
			$this-&gt;vars[&#039;agents_resources&#039;] = $agents_resources;
			$this-&gt;vars[&#039;timeline_boundaries&#039;] = OsResourceHelper::get_work_boundaries_for_groups_of_resources($agents_resources);

			$this-&gt;vars[&#039;work_total_minutes&#039;] = $work_total_minutes;
      $this-&gt;vars[&#039;work_boundaries&#039;] = $work_boundaries;
      $this-&gt;vars[&#039;show_day_info&#039;] = OsAuthHelper::is_admin_logged_in();
      $this-&gt;vars[&#039;target_date_obj&#039;] = $target_date;
      $this-&gt;vars[&#039;target_date&#039;] = $target_date-&gt;format(&#039;Y-m-d&#039;);
      $this-&gt;vars[&#039;target_date_string&#039;] = OsTimeHelper::get_readable_date($target_date);

			$this-&gt;vars[&#039;what_to_show&#039;] = isset($this-&gt;params[&#039;what_to_show&#039;]) ? $this-&gt;params[&#039;what_to_show&#039;] : &#039;appointments&#039;;


      $today_date = new OsWpDateTime(&#039;today&#039;);

			if($target_date-&gt;format(&#039;Y-m-d&#039;) == $today_date-&gt;format(&#039;Y-m-d&#039;)){
				$time_now = OsTimeHelper::now_datetime_object();
				$time_now_in_minutes = OsTimeHelper::convert_datetime_to_minutes($time_now);
				if(($time_now_in_minutes&lt;=$work_boundaries-&gt;end_time &amp;&amp; $time_now_in_minutes&gt;=$work_boundaries-&gt;start_time)){
					$this-&gt;vars[&#039;time_now_label&#039;] = $time_now-&gt;format(OsTimeHelper::get_time_format());
					// agents row with avatars and margin below - offset that needs to be accounted for when calculating &quot;time now&quot; indicator position
					$this-&gt;vars[&#039;time_now_indicator_left_offset&#039;] = ($time_now_in_minutes - $work_boundaries-&gt;start_time) / $work_total_minutes * 100;
					$this-&gt;vars[&#039;show_today_indicator&#039;] = true;
				}else{
					$this-&gt;vars[&#039;show_today_indicator&#039;] = false;
				}
			}else{
				$this-&gt;vars[&#039;show_today_indicator&#039;] = false;
			}

      $this-&gt;set_layout(&#039;none&#039;);

      $this-&gt;format_render(__FUNCTION__);
    }


  }

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