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 OsBookingHelper {


	/**
	 * @param OsBookingModel $booking
	 *
	 * @return mixed|void
	 *
	 * Returns full amount to charge in database format 1999.0000
	 *
	 */
	public static function calculate_full_amount_for_booking( OsBookingModel $booking ) {
		if ( ! $booking-&gt;service_id ) {
			return 0;
		}
		$amount = self::calculate_full_amount_for_service( $booking );
		$amount = apply_filters( &#039;latepoint_calculate_full_amount_for_booking&#039;, $amount, $booking );
		$amount = OsMoneyHelper::pad_to_db_format( $amount );

		return $amount;
	}


	/**
	 * @param OsBookingModel $booking
	 *
	 * @return mixed|void
	 *
	 */
	public static function calculate_full_amount_for_service( OsBookingModel $booking ) {
		if ( ! $booking-&gt;service_id ) {
			return 0;
		}
		$service            = new OsServiceModel( $booking-&gt;service_id );
		$amount_for_service = $service-&gt;get_full_amount_for_duration( $booking-&gt;duration );
		$amount_for_service = apply_filters( &#039;latepoint_full_amount_for_service&#039;, $amount_for_service, $booking );

		return $amount_for_service;
	}


	/**
	 * @param OsBookingModel $booking
	 *
	 * @return mixed|void
	 *
	 * Returns deposit amount to charge in database format 1999.0000
	 *
	 */
	public static function calculate_deposit_amount_to_charge( OsBookingModel $booking ) {
		if ( ! $booking-&gt;service_id ) {
			return 0;
		}
		$service            = new OsServiceModel( $booking-&gt;service_id );
		$amount = $service-&gt;get_deposit_amount_for_duration( $booking-&gt;duration );
		$amount = apply_filters( &#039;latepoint_deposit_amount_for_service&#039;, $amount, $booking );
		$amount             = OsMoneyHelper::pad_to_db_format( $amount );

		return $amount;
	}


	/**
	 * @param array $item_data
	 *
	 * @return OsBookingModel
	 */
	public static function build_booking_model_from_item_data( array $item_data ): OsBookingModel {
		$booking = new OsBookingModel();
		if ( $item_data[&#039;id&#039;] ) {
			$booking = $booking-&gt;load_by_id( $item_data[&#039;id&#039;] );
			if ( ! $booking ) {
				$booking = new OsBookingModel();
			}
		}
		$booking-&gt;set_data( $item_data );
		// get buffers from service and set to booking object
		if ( ! isset( $item_data[&#039;buffer_before&#039;] ) &amp;&amp; ! isset( $item_data[&#039;buffer_after&#039;] ) ) {
			$booking-&gt;set_buffers();
		}
		if ( empty( $booking-&gt;end_time ) ) {
			$booking-&gt;calculate_end_date_and_time();
		}
		if ( empty( $booking-&gt;end_date ) ) {
			$booking-&gt;calculate_end_date();
		}
		$booking-&gt;set_utc_datetimes();

		return $booking;
	}

	public static function get_booking_id_and_manage_ability_by_key( string $key ) {
		$booking_id = OsMetaHelper::get_booking_id_by_meta_value( &quot;key_to_manage_for_agent&quot;, $key );
		if ( $booking_id ) {
			return [ &#039;booking_id&#039; =&gt; $booking_id, &#039;for&#039; =&gt; &#039;agent&#039; ];
		}

		$booking_id = OsMetaHelper::get_booking_id_by_meta_value( &quot;key_to_manage_for_customer&quot;, $key );
		if ( $booking_id ) {
			return [ &#039;booking_id&#039; =&gt; $booking_id, &#039;for&#039; =&gt; &#039;customer&#039; ];
		}

		return false;
	}

	public static function is_action_allowed( string $action, OsBookingModel $booking, string $key = &#039;&#039; ) {
		$is_allowed = false;
		if ( empty( $booking-&gt;id ) ) {
			return false;
		}
		if ( ! in_array( $action, [ &#039;cancel&#039;, &#039;reschedule&#039; ] ) ) {
			return false;
		}
		$action_result = false;
		switch ( $action ) {
			case &#039;cancel&#039;:
				$action_result = OsCustomerHelper::can_cancel_booking( $booking );
				break;
			case &#039;reschedule&#039;:
				$action_result = OsCustomerHelper::can_reschedule_booking( $booking );
				break;
		}
		if ( ! empty( $key ) ) {
			// key is passed, check if allowed through key
			$agent_key_meta    = OsMetaHelper::get_booking_meta_by_key( &#039;key_to_manage_for_agent&#039;, $booking-&gt;id );
			$customer_key_meta = OsMetaHelper::get_booking_meta_by_key( &#039;key_to_manage_for_customer&#039;, $booking-&gt;id );
			if ( $key == $agent_key_meta ) {
				// agent can do everything, no need to check for action
				$is_allowed = true;
			} elseif ( $key == $customer_key_meta ) {
				// customer
				$is_allowed = $action_result;
			}
		} elseif ( OsAuthHelper::get_logged_in_customer_id() == $booking-&gt;customer_id ) {
			$is_allowed = $action_result;
		}

		return $is_allowed;
	}

	public static function generate_add_to_calendar_links( OsBookingModel $booking, $key = false ): string {
		$html = &#039;&lt;div class=&quot;add-to-calendar-types&quot;&gt;
							&lt;div class=&quot;atc-heading-wrapper&quot;&gt;
								&lt;div class=&quot;atc-heading&quot;&gt;&#039; . esc_html__( &#039;Calendar Type&#039;, &#039;latepoint&#039; ) . &#039;&lt;/div&gt;
								&lt;div class=&quot;close-calendar-types&quot;&gt;&lt;/div&gt;
							&lt;/div&gt;
							&lt;a href=&quot;&#039; . esc_url($booking-&gt;get_ical_download_link( $key )) . &#039;&quot; target=&quot;_blank&quot; class=&quot;atc-type atc-type-apple&quot;&gt;
								&lt;div class=&quot;atc-type-image&quot;&gt;&lt;/div&gt;
								&lt;div class=&quot;atc-type-name&quot;&gt;&#039; . esc_html__( &#039;Apple Calendar&#039;, &#039;latepoint&#039; ) . &#039;&lt;/div&gt;
							&lt;/a&gt;
							&lt;a href=&quot;&#039; . esc_url($booking-&gt;get_url_for_add_to_calendar_button( &#039;google&#039; )) . &#039;&quot; target=&quot;_blank&quot; class=&quot;atc-type atc-type-google&quot;&gt;
								&lt;div class=&quot;atc-type-image&quot;&gt;&lt;/div&gt;
								&lt;div class=&quot;atc-type-name&quot;&gt;&#039; . esc_html__( &#039;Google Calendar&#039;, &#039;latepoint&#039; ) . &#039;&lt;/div&gt;
							&lt;/a&gt;
							&lt;a href=&quot;&#039; . esc_url($booking-&gt;get_url_for_add_to_calendar_button( &#039;outlook&#039; )) . &#039;&quot; target=&quot;_blank&quot; class=&quot;atc-type atc-type-outlook&quot;&gt;
								&lt;div class=&quot;atc-type-image&quot;&gt;&lt;/div&gt;
								&lt;div class=&quot;atc-type-name&quot;&gt;&#039; . esc_html__( &#039;Outlook.com&#039;, &#039;latepoint&#039; ) . &#039;&lt;/div&gt;
							&lt;/a&gt;
							&lt;a href=&quot;&#039; . esc_url($booking-&gt;get_url_for_add_to_calendar_button( &#039;outlook&#039; )) . &#039;&quot; target=&quot;_blank&quot; class=&quot;atc-type atc-type-office-365&quot;&gt;
								&lt;div class=&quot;atc-type-image&quot;&gt;&lt;/div&gt;
								&lt;div class=&quot;atc-type-name&quot;&gt;&#039; . esc_html__( &#039;Microsoft 365&#039;, &#039;latepoint&#039; ) . &#039;&lt;/div&gt;
							&lt;/a&gt;
						&lt;/div&gt;&#039;;

		return $html;
	}


	public static function get_bookings_for_select( $should_be_in_future = false ) {
		$bookings = new OsBookingModel();
		if ( $should_be_in_future ) {
			$bookings = $bookings-&gt;should_be_in_future();
		}
		$bookings         = $bookings-&gt;order_by( &#039;id desc&#039; )-&gt;set_limit( 100 )-&gt;get_results_as_models();
		$bookings_options = [];
		foreach ( $bookings as $booking ) {
			$name               = $booking-&gt;service-&gt;name . &#039;, &#039; . $booking-&gt;agent-&gt;full_name . &#039;, &#039; . $booking-&gt;customer-&gt;full_name . &#039; [&#039; . $booking-&gt;booking_code . &#039; : &#039; . $booking-&gt;id . &#039;]&#039;;
			$bookings_options[] = [ &#039;value&#039; =&gt; $booking-&gt;id, &#039;label&#039; =&gt; esc_html( $name ) ];
		}

		return $bookings_options;
	}

	/**
	 *
	 * Determine whether to show
	 *
	 * @param $rows
	 *
	 * @return bool
	 */
	public static function is_breakdown_free( $rows ) {
		return ( ( empty( $rows[&#039;subtotal&#039;][&#039;raw_value&#039;] ) || ( (float) $rows[&#039;subtotal&#039;][&#039;raw_value&#039;] &lt;= 0 ) ) &amp;&amp; ( empty( $rows[&#039;total&#039;][&#039;raw_value&#039;] ) || ( (float) $rows[&#039;total&#039;][&#039;raw_value&#039;] &lt;= 0 ) ) );
	}

	public static function output_price_breakdown( $rows ) {
		foreach ( $rows[&#039;before_subtotal&#039;] as $row ) {
			self::output_price_breakdown_row( $row );
		}
		// if there is nothing between subtotal and total - don&#039;t show subtotal as it will be identical to total
		if ( ! empty( $rows[&#039;after_subtotal&#039;] ) ) {
			if ( ! empty( $rows[&#039;subtotal&#039;] ) ) {
				echo &#039;&lt;div class=&quot;subtotal-separator&quot;&gt;&lt;/div&gt;&#039;;
				self::output_price_breakdown_row( $rows[&#039;subtotal&#039;] );
			}
			foreach ( $rows[&#039;after_subtotal&#039;] as $row ) {
				self::output_price_breakdown_row( $row );
			}
		}
		if ( ! empty( $rows[&#039;total&#039;] ) ) {
			self::output_price_breakdown_row( $rows[&#039;total&#039;] );
		}
		if ( ! empty( $rows[&#039;payments&#039;] ) ) {
			foreach ( $rows[&#039;payments&#039;] as $row ) {
				self::output_price_breakdown_row( $row );
			}
		}
		if ( ! empty( $rows[&#039;balance&#039;] ) ) {
			self::output_price_breakdown_row( $rows[&#039;balance&#039;] );
		}
	}

	public static function output_price_breakdown_row( $row ) {
		if ( ! empty( $row[&#039;items&#039;] ) ) {
			if ( ! empty( $row[&#039;heading&#039;] ) ) {
				echo &#039;&lt;div class=&quot;summary-box-heading&quot;&gt;&lt;div class=&quot;sbh-item&quot;&gt;&#039; . esc_html($row[&#039;heading&#039;]) . &#039;&lt;/div&gt;&lt;div class=&quot;sbh-line&quot;&gt;&lt;/div&gt;&lt;/div&gt;&#039;;
			}
			foreach ( $row[&#039;items&#039;] as $row_item ) {
				self::output_price_breakdown_row( $row_item );
			}
		} else {
			$extra_class = &#039;&#039;;
			if ( isset( $row[&#039;style&#039;] ) &amp;&amp; $row[&#039;style&#039;] == &#039;strong&#039; ) {
				$extra_class .= &#039; spi-strong&#039;;
			}
			if ( isset( $row[&#039;style&#039;] ) &amp;&amp; $row[&#039;style&#039;] == &#039;total&#039; ) {
				$extra_class .= &#039; spi-total&#039;;
			}
			if ( isset( $row[&#039;type&#039;] ) &amp;&amp; $row[&#039;type&#039;] == &#039;credit&#039; ) {
				$extra_class .= &#039; spi-positive&#039;;
			}
			?&gt;
            &lt;div class=&quot;summary-price-item-w &lt;?php echo esc_attr($extra_class); ?&gt;&quot;&gt;
                &lt;div class=&quot;spi-name&quot;&gt;
					&lt;?php echo $row[&#039;label&#039;]; ?&gt;
					&lt;?php if ( ! empty( $row[&#039;note&#039;] ) ) {
						echo &#039;&lt;span class=&quot;pi-note&quot;&gt;&#039; . esc_html($row[&#039;note&#039;]) . &#039;&lt;/span&gt;&#039;;
					} ?&gt;
					&lt;?php if ( ! empty( $row[&#039;badge&#039;] ) ) {
						echo &#039;&lt;span class=&quot;pi-badge&quot;&gt;&#039; . esc_html($row[&#039;badge&#039;]) . &#039;&lt;/span&gt;&#039;;
					} ?&gt;
                &lt;/div&gt;
                &lt;div class=&quot;spi-price&quot;&gt;&lt;?php echo esc_html($row[&#039;value&#039;]); ?&gt;&lt;/div&gt;
            &lt;/div&gt;
			&lt;?php
		}
	}

	public static function output_price_breakdown_row_as_input_field( $row, $base_name ) {
		$field_name = $base_name . &#039;[&#039; . OsUtilHelper::random_text( &#039;alnum&#039;, 8 ) . &#039;]&#039;;
		if ( ! empty( $row[&#039;items&#039;] ) ) {
			echo OsFormHelper::hidden_field( $field_name . &#039;[heading]&#039;, $row[&#039;heading&#039;] ?? &#039;&#039; );
			foreach ( $row[&#039;items&#039;] as $row_item ) {
				self::output_price_breakdown_row_as_input_field( $row_item, $field_name . &#039;[items]&#039; );
			}
		} else {
			$wrapper_class = ( $row[&#039;raw_value&#039;] &lt; 0 ) ? [ &#039;class&#039; =&gt; &#039;green-value-input&#039; ] : [];
			$label         = $row[&#039;label&#039;] ?? &#039;&#039;;
			if ( ! empty( $row[&#039;note&#039;] ) ) {
				$label .= &#039; &#039; . $row[&#039;note&#039;];
			}
			echo OsFormHelper::money_field( $field_name . &#039;[value]&#039;, $label, $row[&#039;raw_value&#039;], [ &#039;theme&#039; =&gt; &#039;right-aligned&#039; ], [], $wrapper_class );
			echo OsFormHelper::hidden_field( $field_name . &#039;[label]&#039;, $row[&#039;label&#039;] ?? &#039;&#039; );
			echo OsFormHelper::hidden_field( $field_name . &#039;[style]&#039;, $row[&#039;style&#039;] ?? &#039;&#039; );
			echo OsFormHelper::hidden_field( $field_name . &#039;[type]&#039;, $row[&#039;type&#039;] ?? &#039;&#039; );
			echo OsFormHelper::hidden_field( $field_name . &#039;[note]&#039;, $row[&#039;note&#039;] ?? &#039;&#039; );
			echo OsFormHelper::hidden_field( $field_name . &#039;[badge]&#039;, $row[&#039;badge&#039;] ?? &#039;&#039; );
		}
		if ( ! empty( $row[&#039;sub_items&#039;] ) ) {
			foreach ( $row[&#039;sub_items&#039;] as $row_item ) {
				self::output_price_breakdown_row_as_input_field( $row_item, $field_name . &#039;[sub_items]&#039; );
			}
		}
	}

	/**
	 * @param \LatePoint\Misc\Filter $filter
	 * @param bool $accessed_from_backend
	 *
	 * @return array
	 */
	public static function get_blocked_periods_grouped_by_day( \LatePoint\Misc\Filter $filter, bool $accessed_from_backend = false ): array {
		$grouped_blocked_periods = [];

		if ( $filter-&gt;date_from ) {
			$date_from = OsWpDateTime::os_createFromFormat( &#039;Y-m-d&#039;, $filter-&gt;date_from );
			$date_to   = ( $filter-&gt;date_to ) ? OsWpDateTime::os_createFromFormat( &#039;Y-m-d&#039;, $filter-&gt;date_to ) : OsWpDateTime::os_createFromFormat( &#039;Y-m-d&#039;, $filter-&gt;date_from );

			# Loop through days to fill in days that might have no bookings
			for ( $day = clone $date_from; $day-&gt;format( &#039;Y-m-d&#039; ) &lt;= $date_to-&gt;format( &#039;Y-m-d&#039; ); $day-&gt;modify( &#039;+1 day&#039; ) ) {
				$grouped_blocked_periods[ $day-&gt;format( &#039;Y-m-d&#039; ) ] = [];
			}
		}
		if ( ! $accessed_from_backend ) {
			$today                     = new OsWpDateTime( &#039;today&#039; );
            $earliest_possible_booking = OsSettingsHelper::get_earliest_possible_booking_restriction($filter-&gt;service_id);

			$block_end_datetime        = OsTimeHelper::now_datetime_object();
			if ( $earliest_possible_booking ) {
				try {
					$block_end_datetime-&gt;modify( $earliest_possible_booking );
				} catch ( Exception $e ) {
					$block_end_datetime = OsTimeHelper::now_datetime_object();
				}
			}
			for ( $day = clone $today; $day-&gt;format( &#039;Y-m-d&#039; ) &lt;= $block_end_datetime-&gt;format( &#039;Y-m-d&#039; ); $day-&gt;modify( &#039;+1 day&#039; ) ) {
				// loop days from now to the earliest possible booking and block timeslots if these days were actually requested
				if ( isset( $grouped_blocked_periods[ $day-&gt;format( &#039;Y-m-d&#039; ) ] ) ) {
					$grouped_blocked_periods[ $day-&gt;format( &#039;Y-m-d&#039; ) ][] = new \LatePoint\Misc\BlockedPeriod( [
						&#039;start_time&#039; =&gt; 0,
						&#039;end_time&#039;   =&gt; ( $day-&gt;format( &#039;Y-m-d&#039; ) &lt; $block_end_datetime-&gt;format( &#039;Y-m-d&#039; ) ) ? 24 * 60 : OsTimeHelper::convert_datetime_to_minutes( $block_end_datetime ),
						&#039;start_date&#039; =&gt; $day-&gt;format( &#039;Y-m-d&#039; ),
						&#039;end_date&#039;   =&gt; $day-&gt;format( &#039;Y-m-d&#039; )
					] );
				}
			}
            $latest_possible_booking = OsSettingsHelper::get_latest_possible_booking_restriction($filter-&gt;service_id);
			if ( $latest_possible_booking ) {
				try {
					$latest_booking_datetime = OsTimeHelper::now_datetime_object();
					$latest_booking_datetime-&gt;modify( $latest_possible_booking );
				} catch ( Exception $e ) {
					$latest_booking_datetime = null;
				}
                if ( $latest_booking_datetime &amp;&amp; $filter-&gt;date_from) {
                    $date_to   = ( $filter-&gt;date_to ) ? OsWpDateTime::os_createFromFormat( &#039;Y-m-d&#039;, $filter-&gt;date_to ) : OsWpDateTime::os_createFromFormat( &#039;Y-m-d&#039;, $filter-&gt;date_from );
                    // Start from the latest_booking_datetime day
                    for ( $day = clone $latest_booking_datetime; $day-&gt;format( &#039;Y-m-d&#039; ) &lt;= $date_to-&gt;format( &#039;Y-m-d&#039; ); $day-&gt;modify( &#039;+1 day&#039; ) ) {
                        if ( isset( $grouped_blocked_periods[ $day-&gt;format( &#039;Y-m-d&#039; ) ] ) ) {
	                        $grouped_blocked_periods[ $day-&gt;format( &#039;Y-m-d&#039; ) ][] = new \LatePoint\Misc\BlockedPeriod( [
		                        &#039;start_time&#039; =&gt; ( $day-&gt;format( &#039;Y-m-d&#039; ) == $latest_booking_datetime-&gt;format( &#039;Y-m-d&#039; ) ) ? OsTimeHelper::convert_datetime_to_minutes( $latest_booking_datetime ) : 0,
		                        &#039;end_time&#039;   =&gt; 24 * 60,
		                        &#039;start_date&#039; =&gt; $day-&gt;format( &#039;Y-m-d&#039; ),
		                        &#039;end_date&#039;   =&gt; $day-&gt;format( &#039;Y-m-d&#039; )
	                        ] );
                        }
                    }
                }
			}

		}

		$grouped_blocked_periods = apply_filters( &#039;latepoint_blocked_periods_for_range&#039;, $grouped_blocked_periods, $filter );

		return $grouped_blocked_periods;
	}

	/**
	 * @param \LatePoint\Misc\Filter $filter
	 *
	 * @return array
	 */
	public static function get_booked_periods_grouped_by_day( \LatePoint\Misc\Filter $filter ): array {
		$booked_periods = self::get_booked_periods( $filter );

		$grouped_booked_periods = [];
		if ( $filter-&gt;date_from ) {
			$date_from = OsWpDateTime::os_createFromFormat( &#039;Y-m-d&#039;, $filter-&gt;date_from );
			$date_to   = ( $filter-&gt;date_to ) ? OsWpDateTime::os_createFromFormat( &#039;Y-m-d&#039;, $filter-&gt;date_to ) : OsWpDateTime::os_createFromFormat( &#039;Y-m-d&#039;, $filter-&gt;date_from );

			# Loop through days to fill in days that might have no bookings
			for ( $day = clone $date_from; $day-&gt;format( &#039;Y-m-d&#039; ) &lt;= $date_to-&gt;format( &#039;Y-m-d&#039; ); $day-&gt;modify( &#039;+1 day&#039; ) ) {
				$grouped_booked_periods[ $day-&gt;format( &#039;Y-m-d&#039; ) ] = [];
			}
			foreach ( $booked_periods as $booked_period ) {
				$grouped_booked_periods[ $booked_period-&gt;start_date ][] = $booked_period;
				// if event spans multiple days - add to other days as well
				if ( $booked_period-&gt;end_date &amp;&amp; ( $booked_period-&gt;start_date != $booked_period-&gt;end_date ) ) {
					$grouped_booked_periods[ $booked_period-&gt;end_date ][] = $booked_period;
				}
			}
		}

		return $grouped_booked_periods;
	}

	/**
	 * @param \LatePoint\Misc\Filter $filter
	 *
	 * @return \LatePoint\Misc\BookedPeriod[]
	 */
	public static function get_booked_periods( \LatePoint\Misc\Filter $filter ): array {


		$bookings       = self::get_bookings( $filter, true );
		$booked_periods = [];

		foreach ( $bookings as $booking ) {
			$booked_periods[] = \LatePoint\Misc\BookedPeriod::create_from_booking_model( $booking );
		}


        if($filter-&gt;consider_cart_items){
            $cart = OsCartsHelper::get_or_create_cart();
            $bookings_in_cart = $cart-&gt;get_bookings_from_cart_items();

            foreach ( $bookings_in_cart as $cart_booking ) {
                $booked_periods[] = \LatePoint\Misc\BookedPeriod::create_from_booking_model( $cart_booking );
            }
        }

		// TODO Update all filters to accept new &quot;filter&quot; variable (In Google Calendar addon)
		$booked_periods = apply_filters( &#039;latepoint_get_booked_periods&#039;, $booked_periods, $filter );

		return $booked_periods;
	}


	/**
	 * @param \LatePoint\Misc\Filter $filter
	 * @param bool $as_models
	 *
	 * @return array
	 */
	public static function get_bookings( \LatePoint\Misc\Filter $filter, bool $as_models = false ): array {
		$bookings = new OsBookingModel();
		if ( $filter-&gt;date_from ) {
			if ( $filter-&gt;date_from &amp;&amp; $filter-&gt;date_to ) {
				# both start and end date provided - means it&#039;s a range
				$bookings-&gt;where( [ &#039;start_date &gt;=&#039; =&gt; $filter-&gt;date_from, &#039;start_date &lt;=&#039; =&gt; $filter-&gt;date_to ] );
			} else {
				# only start_date provided - means it&#039;s a specific date requested
				$bookings-&gt;where( [ &#039;start_date&#039; =&gt; $filter-&gt;date_from ] );
			}
		}


		if ( $filter-&gt;connections ) {
			$connection_conditions = [];
			foreach ( $filter-&gt;connections as $connection ) {
				$connection_conditions[] = [
					&#039;AND&#039; =&gt;
						[
							&#039;agent_id&#039;    =&gt; $connection-&gt;agent_id,
							&#039;service_id&#039;  =&gt; $connection-&gt;service_id,
							&#039;location_id&#039; =&gt; $connection-&gt;location_id
						]
				];
			}
			$bookings-&gt;where( [ &#039;OR&#039; =&gt; $connection_conditions ] );
		} else {
			if ( $filter-&gt;agent_id ) {
				$bookings-&gt;where( [ &#039;agent_id&#039; =&gt; $filter-&gt;agent_id ] );
			}
			if ( $filter-&gt;location_id ) {
				$bookings-&gt;where( [ &#039;location_id&#039; =&gt; $filter-&gt;location_id ] );
			}
			if ( $filter-&gt;service_id ) {
				$bookings-&gt;where( [ &#039;service_id&#039; =&gt; $filter-&gt;service_id ] );
			}
		}
		if ( $filter-&gt;statuses ) {
			$bookings-&gt;where( [ &#039;status&#039; =&gt; $filter-&gt;statuses ] );
		}
		if ( $filter-&gt;exclude_booking_ids ) {
			$bookings-&gt;where( [ &#039;id NOT IN&#039; =&gt; $filter-&gt;exclude_booking_ids ] );
		}
		$bookings-&gt;order_by( &#039;start_time asc, end_time asc, service_id asc&#039; );
		$bookings = ( $as_models ) ? $bookings-&gt;get_results_as_models() : $bookings-&gt;get_results();

		// make sure to return empty array if nothing is found
		if ( empty( $bookings ) ) {
			$bookings = [];
		}

		return $bookings;
	}

	public static function generate_ical_event_string( $booking ) {
        // translators: %1$s is agent name, %2$s is service name
		$booking_description = sprintf( __( &#039;Appointment with %1$s for %2$s&#039;, &#039;latepoint&#039; ), $booking-&gt;agent-&gt;full_name, $booking-&gt;service-&gt;name );

		$ics = new ICS( array(
			&#039;location&#039;    =&gt; $booking-&gt;location-&gt;full_address,
			&#039;description&#039; =&gt; &#039;&#039;,
			&#039;dtstart&#039;     =&gt; $booking-&gt;format_start_date_and_time_for_google(),
			&#039;dtend&#039;       =&gt; $booking-&gt;format_end_date_and_time_for_google(),
			&#039;summary&#039;     =&gt; $booking_description,
			&#039;url&#039;         =&gt; get_site_url()
		) );

		return $ics-&gt;to_string();
	}

	/**
	 * @param \LatePoint\Misc\BookingRequest $booking_request
	 *
	 * @return bool
	 *
	 * Checks if requested booking slot is available, loads work periods and booked periods from database and checks availability against them
	 */
	public static function is_booking_request_available( \LatePoint\Misc\BookingRequest $booking_request, $settings = [] ): bool {
        try{
            $requested_date = new OsWpDateTime( $booking_request-&gt;start_date );
        }catch(Exception $e){
            return false;
        }
		$resources      = OsResourceHelper::get_resources_grouped_by_day( $booking_request, $requested_date, $requested_date, $settings );
		if ( empty( $resources[ $requested_date-&gt;format( &#039;Y-m-d&#039; ) ] ) ) {
			return false;
		}
		$is_available = false;


        // check if satisfies earliest and latest bookings - check per-service settings first, then global
        $earliest_possible_booking = OsSettingsHelper::get_earliest_possible_booking_restriction($booking_request-&gt;service_id);
        $latest_possible_booking = OsSettingsHelper::get_latest_possible_booking_restriction($booking_request-&gt;service_id);


        if($earliest_possible_booking || $latest_possible_booking){
            // check earliest
            if(!empty($earliest_possible_booking)) {
	            try {
		            $earliest_possible_booking_date = new OsWpDateTime( $earliest_possible_booking );
		            if ( $earliest_possible_booking_date &gt; $booking_request-&gt;get_start_datetime() ) {
			            return false;
		            }
	            } catch ( Exception $e ) {

	            }
            }
            if(!empty($latest_possible_booking)) {
	            // check latest
	            try {
		            $latest_possible_booking_date = new OsWpDateTime( $latest_possible_booking );
		            if ( $latest_possible_booking_date &lt; $booking_request-&gt;get_start_datetime() ) {
			            return false;
		            }
	            } catch ( Exception $e ) {

	            }
            }
        }

		foreach ( $resources[ $requested_date-&gt;format( &#039;Y-m-d&#039; ) ] as $resource ) {
			foreach ( $resource-&gt;slots as $slot ) {
				if ( $slot-&gt;start_time == $booking_request-&gt;start_time &amp;&amp; $slot-&gt;can_accomodate( $booking_request-&gt;total_attendees ) ) {
					$is_available = true;
				}
				if ( $is_available ) {
					break;
				}
			}
			if ( $is_available ) {
				break;
			}
		}

		return $is_available;
	}

	/**
	 *
	 * Checks if two bookings are part of the same group appointment
	 *
	 * @param bool|OsBookingModel $booking
	 * @param bool|OsBookingModel $compare_booking
	 *
	 * @return bool
	 */
	public static function check_if_group_bookings( $booking, $compare_booking ): bool {
		if ( $booking &amp;&amp; $compare_booking &amp;&amp; ( $compare_booking-&gt;start_time == $booking-&gt;start_time ) &amp;&amp; ( $compare_booking-&gt;end_time == $booking-&gt;end_time ) &amp;&amp; ( $compare_booking-&gt;service_id == $booking-&gt;service_id ) &amp;&amp; ( $compare_booking-&gt;location_id == $booking-&gt;location_id ) ) {
			return true;
		} else {
			return false;
		}
	}


	public static function process_actions_after_save( $booking_id ) {
	}

	/**
	 * @param DateTime $start_date
	 * @param DateTime $end_date
	 * @param \LatePoint\Misc\BookingRequest $booking_request
	 * @param \LatePoint\Misc\BookingResource[] $resources
	 * @param array $settings
	 *
	 * @return string
	 * @throws Exception
	 */
	public static function get_quick_availability_days( DateTime $start_date, DateTime $end_date, \LatePoint\Misc\BookingRequest $booking_request, array $resources = [], array $settings = [] ) {
		$default_settings = [
			&#039;work_boundaries&#039;     =&gt; false,
			&#039;exclude_booking_ids&#039; =&gt; []
		];
		$settings         = array_merge( $default_settings, $settings );

		$html = &#039;&#039;;

		if ( ! $resources ) {
			$resources = OsResourceHelper::get_resources_grouped_by_day( $booking_request, $start_date, $end_date, $settings );
		}
		if ( ! $settings[&#039;work_boundaries&#039;] ) {
			$settings[&#039;work_boundaries&#039;] = OsResourceHelper::get_work_boundaries_for_groups_of_resources( $resources );
		}

        if ( $start_date-&gt;format( &#039;j&#039; ) != &#039;1&#039; ) {
            $html .= &#039;&lt;div class=&quot;ma-month-label&quot;&gt;&#039; . OsUtilHelper::get_month_name_by_number( $start_date-&gt;format( &#039;n&#039; ) ) . &#039;&lt;/div&gt;&#039;;
        }

		for ( $day_date = clone $start_date; $day_date &lt;= $end_date; $day_date-&gt;modify( &#039;+1 day&#039; ) ) {
			// first day of month, output month name
			if ( $day_date-&gt;format( &#039;j&#039; ) == &#039;1&#039; ) {
				$html .= &#039;&lt;div class=&quot;ma-month-label&quot;&gt;&#039; . OsUtilHelper::get_month_name_by_number( $day_date-&gt;format( &#039;n&#039; ) ) . &#039;&lt;/div&gt;&#039;;
			}
			$html .= &#039;&lt;div class=&quot;ma-day ma-day-number-&#039; . $day_date-&gt;format( &#039;N&#039; ) . &#039;&quot;&gt;&#039;;
			$html .= &#039;&lt;div class=&quot;ma-day-info&quot;&gt;&#039;;
			$html .= &#039;&lt;span class=&quot;ma-day-number&quot;&gt;&#039; . $day_date-&gt;format( &#039;j&#039; ) . &#039;&lt;/span&gt;&#039;;
			$html .= &#039;&lt;span class=&quot;ma-day-weekday&quot;&gt;&#039; . OsUtilHelper::get_weekday_name_by_number( $day_date-&gt;format( &#039;N&#039; ), true ) . &#039;&lt;/span&gt;&#039;;
			$html .= &#039;&lt;/div&gt;&#039;;
			$html .= OsTimelineHelper::availability_timeline( $booking_request, $settings[&#039;work_boundaries&#039;], $resources[ $day_date-&gt;format( &#039;Y-m-d&#039; ) ], [ &#039;book_on_click&#039; =&gt; false ] );
			$html .= &#039;&lt;/div&gt;&#039;;
		}

		return $html;
	}

	public static function count_pending_bookings() {
		$bookings = new OsBookingModel();

		return $bookings-&gt;filter_allowed_records()-&gt;where( [ &#039;status IN&#039; =&gt; OsBookingHelper::get_booking_statuses_for_pending_page() ] )-&gt;count();
	}


	public static function generate_bundles_folder(): void {
		$bundles_model = new OsBundleModel();
		$bundles       = $bundles_model-&gt;should_be_active()-&gt;should_not_be_hidden()-&gt;get_results_as_models();

		if ( $bundles ) {
			?&gt;
            &lt;div class=&quot;os-item-category-w os-items os-as-rows os-animated-child&quot;&gt;
                &lt;div class=&quot;os-item-category-info-w os-item os-animated-self with-plus&quot;&gt;
                    &lt;div class=&quot;os-item-category-info os-item-i&quot; tabindex=&quot;0&quot;&gt;
                        &lt;div class=&quot;os-item-img-w&quot;&gt;&lt;i class=&quot;latepoint-icon latepoint-icon-shopping-bag&quot;&gt;&lt;/i&gt;&lt;/div&gt;
                        &lt;div class=&quot;os-item-name-w&quot;&gt;
                            &lt;div class=&quot;os-item-name&quot;&gt;&lt;?php echo esc_html__( &#039;Bundle &amp; Save&#039;, &#039;latepoint&#039; ); ?&gt;&lt;/div&gt;
                        &lt;/div&gt;
						&lt;?php if (OsSettingsHelper::is_on(&#039;show_service_categories_count&#039;) &amp;&amp; count( $bundles ) ) { ?&gt;
                            &lt;div class=&quot;os-item-child-count&quot;&gt;
                                &lt;span&gt;&lt;?php echo count( $bundles ); ?&gt;&lt;/span&gt; &lt;?php esc_html_e( &#039;Bundles&#039;, &#039;latepoint&#039; ); ?&gt;
                            &lt;/div&gt;
						&lt;?php } ?&gt;
                    &lt;/div&gt;
                &lt;/div&gt;
                &lt;div class=&quot;os-bundles os-animated-parent os-items os-as-rows os-selectable-items&quot;&gt;
					&lt;?php
					foreach ( $bundles as $bundle ) { ?&gt;
                        &lt;div class=&quot;os-animated-child os-item os-selectable-item &lt;?php echo ( $bundle-&gt;charge_amount ) ? &#039;os-priced-item&#039; : &#039;&#039;; ?&gt; &lt;?php if ( $bundle-&gt;short_description ) { echo &#039;with-description&#039;; } ?&gt;&quot;
                                tabindex=&quot;0&quot;
                                data-item-price=&quot;&lt;?php echo esc_attr($bundle-&gt;charge_amount); ?&gt;&quot;
                                data-priced-item-type=&quot;bundle&quot;
                                data-summary-field-name=&quot;bundle&quot;
                                data-summary-value=&quot;&lt;?php echo esc_attr( $bundle-&gt;name ); ?&gt;&quot;
                                data-item-id=&quot;&lt;?php echo esc_attr($bundle-&gt;id); ?&gt;&quot;
                                data-cart-item-item-data-key=&quot;bundle_id&quot;
                                data-os-call-func=&quot;latepoint_bundle_selected&quot;&gt;
                            &lt;div class=&quot;os-service-selector os-item-i os-animated-self&quot;
                                 data-bundle-id=&quot;&lt;?php echo esc_attr($bundle-&gt;id); ?&gt;&quot;&gt;
                                &lt;span class=&quot;os-item-img-w&quot;&gt;&lt;i class=&quot;latepoint-icon latepoint-icon-shopping-bag&quot;&gt;&lt;/i&gt;&lt;/span&gt;
                                &lt;span class=&quot;os-item-name-w&quot;&gt;
		                &lt;span class=&quot;os-item-name&quot;&gt;&lt;?php echo esc_html($bundle-&gt;name); ?&gt;&lt;/span&gt;
		                &lt;?php if ( $bundle-&gt;short_description ) { ?&gt;
                            &lt;span class=&quot;os-item-desc&quot;&gt;&lt;?php echo wp_kses_post($bundle-&gt;short_description); ?&gt;&lt;/span&gt;
		                &lt;?php } ?&gt;
		              &lt;/span&gt;

							&lt;?php if ( $bundle-&gt;charge_amount &gt; 0 ) { ?&gt;
                                &lt;span class=&quot;os-item-price-w&quot;&gt;
                  &lt;span class=&quot;os-item-price&quot;&gt;
                    &lt;?php echo esc_html(OsMoneyHelper::format_price($bundle-&gt;charge_amount)); ?&gt;
                  &lt;/span&gt;
                &lt;/span&gt;
							&lt;?php } ?&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
						&lt;?php
					}
					?&gt;
                &lt;/div&gt;
            &lt;/div&gt;
			&lt;?php
		}
	}

	public static function generate_services_list( $services = false, $preselected_service = false ) {
		if ( $services &amp;&amp; is_array( $services ) &amp;&amp; ! empty( $services ) ) { ?&gt;
            &lt;div class=&quot;os-services os-animated-parent os-items os-as-rows os-selectable-items&quot;&gt;
				&lt;?php foreach ( $services as $service ) {
					// if service is preselected - only output that service, skip the rest
					if ( $preselected_service &amp;&amp; $service-&gt;id != $preselected_service-&gt;id ) {
						continue;
					}
					$service_durations = $service-&gt;get_all_durations_arr();
					$is_priced         = ( ! ( count( $service_durations ) &gt; 1 ) &amp;&amp; $service-&gt;charge_amount ) ? true : false;
					?&gt;
                    &lt;div class=&quot;os-animated-child os-item os-selectable-item &lt;?php echo ( $preselected_service &amp;&amp; $service-&gt;id == $preselected_service-&gt;id ) ? &#039;selected is-preselected&#039; : &#039;&#039;; ?&gt; &lt;?php echo ( $is_priced ) ? &#039;os-priced-item&#039; : &#039;&#039;; ?&gt; &lt;?php if ( $service-&gt;short_description ) { echo &#039;with-description&#039;; } ?&gt;&quot;
                            tabindex=&quot;0&quot;
                            data-item-price=&quot;&lt;?php echo esc_attr($service-&gt;charge_amount); ?&gt;&quot;
                            data-priced-item-type=&quot;service&quot;
                            data-summary-field-name=&quot;service&quot;
                            data-summary-value=&quot;&lt;?php echo esc_attr( $service-&gt;name ); ?&gt;&quot;
                            data-item-id=&quot;&lt;?php echo esc_attr($service-&gt;id); ?&gt;&quot;
                            data-cart-item-item-data-key=&quot;service_id&quot;
                            data-os-call-func=&quot;latepoint_service_selected&quot;
                            data-id-holder=&quot;.latepoint_service_id&quot;&gt;
                        &lt;div class=&quot;os-service-selector os-item-i os-animated-self&quot; data-service-id=&quot;&lt;?php echo esc_attr($service-&gt;id); ?&gt;&quot;&gt;
							&lt;?php if ( $service-&gt;selection_image_id ) { ?&gt;
                                &lt;span class=&quot;os-item-img-w&quot; style=&quot;background-image: url(&lt;?php echo esc_url($service-&gt;selection_image_url); ?&gt;);&quot;&gt;&lt;/span&gt;
							&lt;?php } ?&gt;
                            &lt;span class=&quot;os-item-name-w&quot;&gt;
                &lt;span class=&quot;os-item-name&quot;&gt;&lt;?php echo esc_html($service-&gt;name); ?&gt;&lt;/span&gt;
                &lt;?php if ( $service-&gt;short_description ) { ?&gt;
                    &lt;span class=&quot;os-item-desc&quot;&gt;&lt;?php echo wp_kses_post($service-&gt;short_description); ?&gt;&lt;/span&gt;
                &lt;?php } ?&gt;
              &lt;/span&gt;
							&lt;?php if ( $service-&gt;price_min &gt; 0 ) { ?&gt;
                                &lt;span class=&quot;os-item-price-w&quot;&gt;
                  &lt;span class=&quot;os-item-price&quot;&gt;
                    &lt;?php
                    /**
                     * Filters the display price value shown on the service tile on a booking form
                     *
                     * @since 5.1.94
                     * @hook latepoint_booking_form_display_service_price
                     *
                     * @param {string} $price displayed price that will be outputted
                     * @param {OsServiceModel} $service Service that the price is displayed for
                     *
                     * @returns {string} Filtered displayed price
                     */
                    $display_price = apply_filters(&#039;latepoint_booking_form_display_service_price&#039;, $service-&gt;price_min_formatted, $service);
                      echo esc_html($display_price) ?&gt;
                  &lt;/span&gt;
                  &lt;?php if ( $service-&gt;price_min != $service-&gt;price_max ) { ?&gt;
                      &lt;span class=&quot;os-item-price-label&quot;&gt;&lt;?php esc_html_e( &#039;Starts From&#039;, &#039;latepoint&#039; ); ?&gt;&lt;/span&gt;
                  &lt;?php } ?&gt;
                &lt;/span&gt;
							&lt;?php } ?&gt;
                        &lt;/div&gt;
                    &lt;/div&gt;
				&lt;?php } ?&gt;
            &lt;/div&gt;
		&lt;?php }
	}

	public static function generate_services_bundles_and_categories_list( $parent_id = false, array $settings = [] ) {
		$default_settings = [
			&#039;show_service_categories_arr&#039; =&gt; false,
			&#039;show_services_arr&#039;           =&gt; false,
			&#039;preselected_service&#039;         =&gt; false,
			&#039;preselected_category&#039;        =&gt; false,
		];
		$settings         = array_merge( $default_settings, $settings );

		if ( $settings[&#039;preselected_service&#039;] ) {
			OsBookingHelper::generate_services_list( [ $settings[&#039;preselected_service&#039;] ], $settings[&#039;preselected_service&#039;] );

			return;
		}

		$service_categories = new OsServiceCategoryModel();
		$args               = array();
		if ( $settings[&#039;show_service_categories_arr&#039;] &amp;&amp; is_array( $settings[&#039;show_service_categories_arr&#039;] ) ) {
			if ( $parent_id ) {
				$service_categories-&gt;where( [ &#039;parent_id&#039; =&gt; $parent_id ] );
			} else {
				if ( $settings[&#039;preselected_category&#039;] ) {
					$service_categories-&gt;where( [ &#039;id&#039; =&gt; $settings[&#039;preselected_category&#039;] ] );
				} else {
					$service_categories-&gt;where_in( &#039;id&#039;, $settings[&#039;show_service_categories_arr&#039;] );
					$service_categories-&gt;where( [
						&#039;parent_id&#039; =&gt; [
							&#039;OR&#039; =&gt; [
								&#039;IS NULL&#039;,
								&#039; NOT IN&#039; =&gt; $settings[&#039;show_service_categories_arr&#039;]
							]
						]
					] );
				}
			}
		} else {
			if ( $settings[&#039;preselected_category&#039;] ) {
				$service_categories-&gt;where( [ &#039;id&#039; =&gt; $settings[&#039;preselected_category&#039;] ] );
			} else {
				$args[&#039;parent_id&#039;] = $parent_id ? $parent_id : &#039;IS NULL&#039;;
			}
		}
		$service_categories = $service_categories-&gt;where( $args )-&gt;order_by( &#039;order_number asc&#039; )-&gt;get_results_as_models();

		$main_parent_class = ( $parent_id ) ? &#039;os-animated-parent&#039; : &#039;os-item-categories-main-parent os-animated-parent&#039;;
		if ( ! $settings[&#039;preselected_category&#039;] ) {
			echo &#039;&lt;div class=&quot;os-item-categories-holder &#039; . esc_attr($main_parent_class) . &#039;&quot;&gt;&#039;;
		}

		// generate services that have no category
		if ( $parent_id == false &amp;&amp; $settings[&#039;preselected_category&#039;] == false ) { ?&gt;
			&lt;?php
			$services_without_category = new OsServiceModel();
			if ( $settings[&#039;show_services_arr&#039;] ) {
				$services_without_category-&gt;where_in( &#039;id&#039;, $settings[&#039;show_services_arr&#039;] );
			}
			$services_without_category = $services_without_category-&gt;where( [ &#039;category_id&#039; =&gt; 0 ] )-&gt;should_be_active()-&gt;get_results_as_models();
			if ( $services_without_category ) {
				OsBookingHelper::generate_services_list( $services_without_category, false );
			}
		}

		if ( is_array( $service_categories ) ) {
			foreach ( $service_categories as $service_category ) { ?&gt;
				&lt;?php
				$services          = [];
				$category_services = $service_category-&gt;get_active_services();
				if ( is_array( $category_services ) ) {
					// if show selected services restriction is set - filter
					if ( $settings[&#039;show_services_arr&#039;] ) {
						foreach ( $category_services as $category_service ) {
							if ( in_array( $category_service-&gt;id, $settings[&#039;show_services_arr&#039;] ) ) {
								$services[] = $category_service;
							}
						}
					} else {
						$services = $category_services;
					}
				}
				$child_categories       = new OsServiceCategoryModel();
				$count_child_categories = $child_categories-&gt;where( [ &#039;parent_id&#039; =&gt; $service_category-&gt;id ] )-&gt;count();
				// show only if it has either at least one child category or service
				if ( $count_child_categories || count( $services ) ) {
					// preselected category, just show contents, not the wrapper
					if ( $service_category-&gt;id == $settings[&#039;preselected_category&#039;] ) {
						OsBookingHelper::generate_services_list( $services, false );
						OsBookingHelper::generate_services_bundles_and_categories_list( $service_category-&gt;id, array_merge( $settings, [ &#039;preselected_category&#039; =&gt; false ] ) );
					} else { ?&gt;
                    &lt;div class=&quot;os-item-category-w os-items os-as-rows os-animated-child&quot;
                         data-id=&quot;&lt;?php echo esc_attr($service_category-&gt;id); ?&gt;&quot;&gt;
                        &lt;div class=&quot;os-item-category-info-w os-item os-animated-self with-plus&quot;&gt;
                            &lt;div class=&quot;os-item-category-info os-item-i&quot;&gt;
                                &lt;div class=&quot;os-item-img-w&quot;
                                     style=&quot;background-image: url(&lt;?php echo esc_url($service_category-&gt;selection_image_url); ?&gt;);&quot;&gt;&lt;/div&gt;
                                &lt;div class=&quot;os-item-name-w&quot;&gt;
                                    &lt;div class=&quot;os-item-name&quot;&gt;&lt;?php echo esc_html($service_category-&gt;name); ?&gt;&lt;/div&gt;
                                    &lt;?php if (!empty($service_category-&gt;short_description)) { ?&gt;
                                        &lt;div class=&quot;os-item-desc&quot;&gt;&lt;?php echo $service_category-&gt;short_description; ?&gt;&lt;/div&gt;
                                    &lt;?php } ?&gt;
                                &lt;/div&gt;
								&lt;?php if (OsSettingsHelper::is_on(&#039;show_service_categories_count&#039;) &amp;&amp; count( $services ) ) { ?&gt;
                                    &lt;div class=&quot;os-item-child-count&quot;&gt;
                                        &lt;span&gt;&lt;?php echo count( $services ); ?&gt;&lt;/span&gt; &lt;?php esc_html_e( &#039;Services&#039;, &#039;latepoint&#039; ); ?&gt;
                                    &lt;/div&gt;
								&lt;?php } ?&gt;
                            &lt;/div&gt;
                        &lt;/div&gt;
						&lt;?php OsBookingHelper::generate_services_list( $services, false ); ?&gt;
						&lt;?php OsBookingHelper::generate_services_bundles_and_categories_list( $service_category-&gt;id, array_merge( $settings, [ &#039;preselected_category&#039; =&gt; false ] ) ); ?&gt;
                        &lt;/div&gt;&lt;?php
					}
				}
			}
		}
		if ( ! $settings[&#039;preselected_category&#039;] &amp;&amp; ! $parent_id ) {
			OsBookingHelper::generate_bundles_folder();
		}
		if ( ! $settings[&#039;preselected_category&#039;] ) {
			echo &#039;&lt;/div&gt;&#039;;
		}
	}

	public static function group_booking_btn_html( $booking_id = false ) {
		$html = &#039;data-os-params=&quot;&#039; . esc_attr(http_build_query( [ &#039;booking_id&#039; =&gt; $booking_id ] )) . &#039;&quot; 
                  data-os-action=&quot;&#039; . esc_attr(OsRouterHelper::build_route_name( &#039;bookings&#039;, &#039;grouped_bookings_quick_view&#039; )) . &#039;&quot; 
                  data-os-output-target=&quot;lightbox&quot;
                  data-os-lightbox-classes=&quot;width-500&quot;
                  data-os-after-call=&quot;latepoint_init_grouped_bookings_form&quot;&#039;;

		return $html;
	}

	public static function quick_booking_btn_html( $booking_id = false, $params = array() ) {
		$html = &#039;&#039;;
		if ( $booking_id ) {
			$params[&#039;booking_id&#039;] = $booking_id;
		}
		$route = OsRouterHelper::build_route_name( &#039;orders&#039;, &#039;quick_edit&#039; );

		$params_str = http_build_query( $params );
		$html       = &#039;data-os-params=&quot;&#039; . esc_attr($params_str) . &#039;&quot; 
    data-os-action=&quot;&#039; . esc_attr($route) . &#039;&quot; 
    data-os-output-target=&quot;side-panel&quot;
    data-os-after-call=&quot;latepoint_init_quick_order_form&quot;&#039;;

		return $html;
	}


	/**
	 * @param OsBookingModel $booking
	 *
	 * @return false|mixed
	 *
	 * Search for available location based on booking requirements. Will return false if no available location found.
	 */
	public static function get_any_location_for_booking_by_rule( OsBookingModel $booking ) {
		// ANY LOCATION SELECTED
		// get available locations
		$connected_ids = OsLocationHelper::get_location_ids_for_service_and_agent( $booking-&gt;service_id, $booking-&gt;agent_id );

		// If date/time is selected - filter locations who are available at that time
		if ( $booking-&gt;start_date &amp;&amp; $booking-&gt;start_time ) {
			$available_location_ids = [];
			$booking_request        = \LatePoint\Misc\BookingRequest::create_from_booking_model( $booking );
			foreach ( $connected_ids as $location_id ) {
				$booking_request-&gt;location_id = $location_id;
				if ( OsBookingHelper::is_booking_request_available( $booking_request ) ) {
					$available_location_ids[] = $location_id;
				}
			}
			$connected_ids = array_intersect( $available_location_ids, $connected_ids );
		}


		$locations_model = new OsLocationModel();
		if ( ! empty( $connected_ids ) ) {
			$locations_model-&gt;where_in( &#039;id&#039;, $connected_ids );
			$locations = $locations_model-&gt;should_be_active()-&gt;get_results_as_models();
		} else {
			$locations = [];
		}

		if ( empty( $locations ) ) {
			return false;
		}

		$selected_location_id = $connected_ids[ wp_rand( 0, count( $connected_ids ) - 1 ) ];
		$booking-&gt;location_id = $selected_location_id;

		return $selected_location_id;
	}

	/**
	 * @param OsBookingModel $booking
	 *
	 * @return false|mixed
	 *
	 * Search for available agent based on booking requirements and agent picking preferences. Will return false if no available agent found.
	 */
	public static function get_any_agent_for_booking_by_rule( OsBookingModel $booking ) {
		// ANY AGENT SELECTED
		// get available agents
		$connected_ids = OsAgentHelper::get_agent_ids_for_service_and_location( $booking-&gt;service_id, $booking-&gt;location_id );

		// If date/time is selected - filter agents who are available at that time
		if ( $booking-&gt;start_date &amp;&amp; $booking-&gt;start_time ) {
			$available_agent_ids = [];
			$booking_request     = \LatePoint\Misc\BookingRequest::create_from_booking_model( $booking );
			foreach ( $connected_ids as $agent_id ) {
				$booking_request-&gt;agent_id = $agent_id;
				if ( OsBookingHelper::is_booking_request_available( $booking_request ) ) {
					$available_agent_ids[] = $agent_id;
				}
			}
			$connected_ids = array_intersect( $available_agent_ids, $connected_ids );
		}


		/**
		 * Get IDs of agents that are eligible to be assigned a booking that has &quot;ANY&quot; agent pre-selected
		 *
		 * @param {array} $connected_ids Array of eligible Agent IDs
		 * @param {OsBookingModel} $booking Booking that needs agent ID
		 *
		 * @returns {array} Filtered array of IDs of eligible agents
		 * @since 4.7.6
		 * @hook latepoint_agent_ids_assignable_to_any_agent_booking
		 *
		 */
		$connected_ids = apply_filters( &#039;latepoint_agent_ids_assignable_to_any_agent_booking&#039;, $connected_ids, $booking );

		if ( ! empty( $connected_ids ) ) {
			$agents_model = new OsAgentModel();
			$agents_model-&gt;where_in( &#039;id&#039;, $connected_ids );
			$agents = $agents_model-&gt;should_be_active()-&gt;get_results_as_models();
		} else {
			$agents = [];
		}

		if ( empty( $agents ) ) {
			return false;
		}


		$selected_agent_id = false;
		$agent_order_rule  = OsSettingsHelper::get_any_agent_order();
		switch ( $agent_order_rule ) {
			case LATEPOINT_ANY_AGENT_ORDER_RANDOM:
				$selected_agent_id = $connected_ids[ wp_rand( 0, count( $connected_ids ) - 1 ) ];
				break;
			case LATEPOINT_ANY_AGENT_ORDER_PRICE_HIGH:
				$highest_price = false;
				foreach ( $agents as $agent ) {
					$booking-&gt;agent_id = $agent-&gt;id;
					$price             = OsBookingHelper::calculate_full_amount_for_booking( $booking );
					if ( $highest_price === false &amp;&amp; $selected_agent_id === false ) {
						$highest_price     = $price;
						$selected_agent_id = $agent-&gt;id;
					} else {
						if ( $highest_price &lt; $price ) {
							$highest_price     = $price;
							$selected_agent_id = $agent-&gt;id;
						}
					}
				}
				break;
			case LATEPOINT_ANY_AGENT_ORDER_PRICE_LOW:
				$lowest_price = false;
				foreach ( $agents as $agent ) {
					$booking-&gt;agent_id = $agent-&gt;id;
					$price             = OsBookingHelper::calculate_full_amount_for_booking( $booking );
					if ( $lowest_price === false &amp;&amp; $selected_agent_id === false ) {
						$lowest_price      = $price;
						$selected_agent_id = $agent-&gt;id;
					} else {
						if ( $lowest_price &gt; $price ) {
							$lowest_price      = $price;
							$selected_agent_id = $agent-&gt;id;
						}
					}
				}
				break;
			case LATEPOINT_ANY_AGENT_ORDER_BUSY_HIGH:
				$max_bookings = false;
				foreach ( $agents as $agent ) {
					$agent_total_bookings = OsBookingHelper::get_total_bookings_for_date( $booking-&gt;start_date, [ &#039;agent_id&#039; =&gt; $agent-&gt;id ] );
					if ( $max_bookings === false &amp;&amp; $selected_agent_id === false ) {
						$max_bookings      = $agent_total_bookings;
						$selected_agent_id = $agent-&gt;id;
					} else {
						if ( $max_bookings &lt; $agent_total_bookings ) {
							$max_bookings      = $agent_total_bookings;
							$selected_agent_id = $agent-&gt;id;
						}
					}
				}
				break;
			case LATEPOINT_ANY_AGENT_ORDER_BUSY_LOW:
				$min_bookings = false;
				foreach ( $agents as $agent ) {
					$agent_total_bookings = OsBookingHelper::get_total_bookings_for_date( $booking-&gt;start_date, [ &#039;agent_id&#039; =&gt; $agent-&gt;id ] );
					if ( $min_bookings === false &amp;&amp; $selected_agent_id === false ) {
						$min_bookings      = $agent_total_bookings;
						$selected_agent_id = $agent-&gt;id;
					} else {
						if ( $min_bookings &gt; $agent_total_bookings ) {
							$min_bookings      = $agent_total_bookings;
							$selected_agent_id = $agent-&gt;id;
						}
					}
				}
				break;
		}
		/**
		 * Get ID of agent that will be assigned to a booking, depending on order rules, where agent is set to ANY
		 *
		 * @param {integer} $selected_agent_id Currently selected agent ID
		 * @param {OsAgentModel[]} $agents Array of eligible agent models to pick from
		 * @param {OsBookingModel} $booking Booking that needs agent ID
		 * @param {string} $agent_order_rule Rule of agent ordering
		 *
		 * @returns {integer} ID of the agent that will be assigned to this booking
		 * @since 4.7.6
		 * @hook latepoint_get_any_agent_id_for_booking_by_rule
		 *
		 */
		$selected_agent_id = apply_filters( &#039;latepoint_get_any_agent_id_for_booking_by_rule&#039;, $selected_agent_id, $agents, $booking, $agent_order_rule );
		$booking-&gt;agent_id = $selected_agent_id;

		return $selected_agent_id;
	}


	public static function get_total_bookings_for_date( $date, $conditions = [], $grouped = false ) {
		$args = [ &#039;start_date&#039; =&gt; $date ];
		if ( isset( $conditions[&#039;agent_id&#039;] ) &amp;&amp; $conditions[&#039;agent_id&#039;] ) {
			$args[&#039;agent_id&#039;] = $conditions[&#039;agent_id&#039;];
		}
		if ( isset( $conditions[&#039;service_id&#039;] ) &amp;&amp; $conditions[&#039;service_id&#039;] ) {
			$args[&#039;service_id&#039;] = $conditions[&#039;service_id&#039;];
		}
		if ( isset( $conditions[&#039;location_id&#039;] ) &amp;&amp; $conditions[&#039;location_id&#039;] ) {
			$args[&#039;location_id&#039;] = $conditions[&#039;location_id&#039;];
		}


		$bookings = new OsBookingModel();
		if ( $grouped ) {
			$bookings-&gt;group_by( &#039;start_date, start_time, end_time, service_id, location_id&#039; );
		}
		$bookings = $bookings-&gt;where( $args );

		return $bookings-&gt;count();
	}


	/**
	 *
	 * Get list of statuses that block timeslot availability
	 *
	 * @return array
	 */
	public static function get_timeslot_blocking_statuses(): array {
		$statuses = explode( &#039;,&#039;, OsSettingsHelper::get_settings_value( &#039;timeslot_blocking_statuses&#039;, &#039;&#039; ) );

		/**
		 * Get list of statuses that block timeslot availability
		 *
		 * @param {array} $statuses array of status codes that block timeslot availability
		 * @returns {array} The filtered array of status codes
		 *
		 * @since 4.7.0
		 * @hook latepoint_get_timeslot_blocking_statuses
		 *
		 */
		return apply_filters( &#039;latepoint_get_timeslot_blocking_statuses&#039;, $statuses );
	}


	/**
	 *
	 * Get list of statuses that appear on pending page
	 *
	 * @return array
	 */
	public static function get_booking_statuses_for_pending_page(): array {
		$statuses = explode( &#039;,&#039;, OsSettingsHelper::get_settings_value( &#039;need_action_statuses&#039;, &#039;&#039; ) );

		/**
		 * Get list of statuses that appear on pending page
		 *
		 * @param {array} $statuses array of status codes that appear on pending page
		 * @returns {array} The filtered array of status codes
		 *
		 * @since 4.7.0
		 * @hook latepoint_get_booking_statuses_for_pending_page
		 *
		 */
		return apply_filters( &#039;latepoint_get_booking_statuses_for_pending_page&#039;, $statuses );
	}

	/**
	 *
	 * Get list of statuses that are not cancelled
	 *
	 * @return array
	 */
	public static function get_non_cancelled_booking_statuses(): array {
		$statuses = self::get_statuses_list();
        if(isset($statuses[LATEPOINT_BOOKING_STATUS_CANCELLED])) unset($statuses[LATEPOINT_BOOKING_STATUS_CANCELLED]);
        $statuses = array_keys($statuses);

		/**
		 * Get list of statuses that are not cancelled
		 *
		 * @param {array} $statuses array of status codes that are not cancelled
		 * @returns {array} The filtered array of status codes
		 *
		 * @since 5.0.5
		 * @hook get_non_cancelled_booking_statuses
		 *
		 */
		return apply_filters( &#039;get_non_cancelled_booking_statuses&#039;, $statuses );
	}


	public static function get_default_booking_status( $service_id = false ) {
		if ( $service_id ) {
			$service = new OsServiceModel( $service_id );
			if ( $service &amp;&amp; ! empty( $service-&gt;id ) ) {
				return $service-&gt;get_default_booking_status();
			}
		}
		$default_status = OsSettingsHelper::get_settings_value( &#039;default_booking_status&#039; );
		if ( $default_status ) {
			return $default_status;
		} else {
			return LATEPOINT_BOOKING_STATUS_APPROVED;
		}
	}


	public static function change_booking_status( $booking_id, $new_status ) {
		$booking = new OsBookingModel( $booking_id );
		if ( ! $booking_id || ! $booking ) {
			return false;
		}

		if ( $new_status == $booking-&gt;status ) {
			return true;
		} else {
			$old_booking = clone $booking;
			if ( $booking-&gt;update_status( $new_status ) ) {
				do_action( &#039;latepoint_booking_updated&#039;, $booking, $old_booking );

				return true;
			} else {
				return false;
			}
		}
	}


	/**
	 * @param \LatePoint\Misc\BookingRequest $booking_request
	 * @param \LatePoint\Misc\BookedPeriod[]
	 * @param int $capacity
	 *
	 * @return bool
	 */
	public static function is_timeframe_in_booked_periods( \LatePoint\Misc\BookingRequest $booking_request, array $booked_periods, OsServiceModel $service ): bool {
		if ( empty( $booked_periods ) ) {
			return false;
		}
		$count_existing_attendees = 0;
		foreach ( $booked_periods as $period ) {
			if ( self::is_period_overlapping( $booking_request-&gt;get_start_time_with_buffer(), $booking_request-&gt;get_end_time_with_buffer(), $period-&gt;start_time_with_buffer(), $period-&gt;end_time_with_buffer() ) ) {
				// if it&#039;s the same service overlapping - count how many times
				// TODO maybe add an option to toggle on/off ability to share a timeslot capacity between two different services
				if ( $booking_request-&gt;service_id == $period-&gt;service_id ) {
					$count_existing_attendees += $period-&gt;total_attendees;
				} else {
					return true;
				}
			}
		}
		if ( $count_existing_attendees &gt; 0 ) {
			// if there are attendees, check if they are below minimum need for timeslot to be blocked, if they are - then the slot is considered booked
			if ( ( $count_existing_attendees + $booking_request-&gt;total_attendees ) &lt;= $service-&gt;get_capacity_needed_before_slot_is_blocked() ) {
				return false;
			} else {
				return true;
			}
		} else {
			// no attendees in the overlapping booked periods yet, just check if the requested number of attendees is within the service capacity
			if ( $booking_request-&gt;total_attendees &lt;= $service-&gt;capacity_max ) {
				return false;
			} else {
				return true;
			}
		}
	}


	public static function is_period_overlapping( $period_one_start, $period_one_end, $period_two_start, $period_two_end ) {
		// https://stackoverflow.com/questions/325933/determine-whether-two-date-ranges-overlap/
		return ( ( $period_one_start &lt; $period_two_end ) &amp;&amp; ( $period_two_start &lt; $period_one_end ) );
	}

	public static function is_period_inside_another( $period_one_start, $period_one_end, $period_two_start, $period_two_end ) {
		return ( ( $period_one_start &gt;= $period_two_start ) &amp;&amp; ( $period_one_end &lt;= $period_two_end ) );
	}

	// args = [agent_id, &#039;service_id&#039;, &#039;location_id&#039;]
	public static function get_bookings_for_date( $date, $args = [] ) {
		$bookings           = new OsBookingModel();
		$args[&#039;start_date&#039;] = $date;
		// if any of these are false or 0 - remove it from arguments list
		if ( isset( $args[&#039;location_id&#039;] ) &amp;&amp; empty( $args[&#039;location_id&#039;] ) ) {
			unset( $args[&#039;location_id&#039;] );
		}
		if ( isset( $args[&#039;agent_id&#039;] ) &amp;&amp; empty( $args[&#039;agent_id&#039;] ) ) {
			unset( $args[&#039;agent_id&#039;] );
		}
		if ( isset( $args[&#039;service_id&#039;] ) &amp;&amp; empty( $args[&#039;service_id&#039;] ) ) {
			unset( $args[&#039;service_id&#039;] );
		}

		$bookings-&gt;where( $args )-&gt;order_by( &#039;start_time asc, end_time asc, service_id asc&#039; );

		return $bookings-&gt;get_results_as_models();
	}

	/**
	 * @param \LatePoint\Misc\Filter $filter
	 *
	 * @return int
	 */
	public static function count_bookings( \LatePoint\Misc\Filter $filter ) {
		$bookings   = new OsBookingModel();
		$query_args = [];
		if ( $filter-&gt;date_from ) {
			$query_args[&#039;start_date&#039;] = $filter-&gt;date_from;
		}
		if ( $filter-&gt;location_id ) {
			$query_args[&#039;location_id&#039;] = $filter-&gt;location_id;
		}
		if ( $filter-&gt;agent_id ) {
			$query_args[&#039;agent_id&#039;] = $filter-&gt;agent_id;
		}
		if ( $filter-&gt;service_id ) {
			$query_args[&#039;service_id&#039;] = $filter-&gt;service_id;
		}

		return $bookings-&gt;should_not_be_cancelled()-&gt;where( $query_args )-&gt;count();
	}


	public static function get_nice_status_name( $status ) {
		$statuses_list = OsBookingHelper::get_statuses_list();
		if ( $status &amp;&amp; isset( $statuses_list[ $status ] ) ) {
			return $statuses_list[ $status ];
		} else {
			return __( &#039;Undefined Status&#039;, &#039;latepoint&#039; );
		}
	}


	public static function get_statuses_list() {
		$statuses            = [
			LATEPOINT_BOOKING_STATUS_APPROVED  =&gt; __( &#039;Approved&#039;, &#039;latepoint&#039; ),
			LATEPOINT_BOOKING_STATUS_PENDING   =&gt; __( &#039;Pending Approval&#039;, &#039;latepoint&#039; ),
			LATEPOINT_BOOKING_STATUS_CANCELLED =&gt; __( &#039;Cancelled&#039;, &#039;latepoint&#039; ),
			LATEPOINT_BOOKING_STATUS_NO_SHOW   =&gt; __( &#039;No Show&#039;, &#039;latepoint&#039; ),
			LATEPOINT_BOOKING_STATUS_COMPLETED =&gt; __( &#039;Completed&#039;, &#039;latepoint&#039; ),
		];
		$additional_statuses = array_map( &#039;trim&#039;, explode( &#039;,&#039;, OsSettingsHelper::get_settings_value( &#039;additional_booking_statuses&#039;, &#039;&#039; ) ) );
		if ( ! empty( $additional_statuses ) ) {
			foreach ( $additional_statuses as $status ) {
				if ( ! empty( $status ) ) {
					$statuses[ str_replace( &#039; &#039;, &#039;_&#039;, strtolower( $status ) ) ] = $status;
				}
			}
		}
		$statuses = apply_filters( &#039;latepoint_booking_statuses&#039;, $statuses );

		return $statuses;
	}


	public static function get_weekdays_arr( $full_name = false ) {
		if ( $full_name ) {
			$weekdays = array(
				__( &#039;Monday&#039;, &#039;latepoint&#039; ),
				__( &#039;Tuesday&#039;, &#039;latepoint&#039; ),
				__( &#039;Wednesday&#039;, &#039;latepoint&#039; ),
				__( &#039;Thursday&#039;, &#039;latepoint&#039; ),
				__( &#039;Friday&#039;, &#039;latepoint&#039; ),
				__( &#039;Saturday&#039;, &#039;latepoint&#039; ),
				__( &#039;Sunday&#039;, &#039;latepoint&#039; )
			);
		} else {
			$weekdays = array(
				__( &#039;Mon&#039;, &#039;latepoint&#039; ),
				__( &#039;Tue&#039;, &#039;latepoint&#039; ),
				__( &#039;Wed&#039;, &#039;latepoint&#039; ),
				__( &#039;Thu&#039;, &#039;latepoint&#039; ),
				__( &#039;Fri&#039;, &#039;latepoint&#039; ),
				__( &#039;Sat&#039;, &#039;latepoint&#039; ),
				__( &#039;Sun&#039;, &#039;latepoint&#039; )
			);
		}

		return $weekdays;
	}

	public static function get_weekday_name_by_number( $weekday_number, $full_name = false ) {
		$weekdays = OsBookingHelper::get_weekdays_arr( $full_name );
		if ( ! isset( $weekday_number ) || $weekday_number &lt; 1 || $weekday_number &gt; 7 ) {
			return &#039;&#039;;
		} else {
			return $weekdays[ $weekday_number - 1 ];
		}
	}

	public static function get_stat( $stat, $args = [] ) {
		if ( ! in_array( $stat, [ &#039;duration&#039;, &#039;price&#039;, &#039;bookings&#039; ] ) ) {
			return false;
		}
		$defaults   = [
			&#039;customer_id&#039;    =&gt; false,
			&#039;agent_id&#039;       =&gt; false,
			&#039;service_id&#039;     =&gt; false,
			&#039;location_id&#039;    =&gt; false,
			&#039;date_from&#039;      =&gt; false,
			&#039;date_to&#039;        =&gt; false,
			&#039;group_by&#039;       =&gt; false,
			&#039;exclude_status&#039; =&gt; false
		];
		$args       = array_merge( $defaults, $args );
		$bookings   = new OsBookingModel();
		$query_args = array( $args[&#039;date_from&#039;], $args[&#039;date_to&#039;] );
		switch ( $stat ) {
			case &#039;duration&#039;:
				$stat_query = &#039;SUM(end_time - start_time)&#039;;
				break;
			case &#039;price&#039;:
				$stat_query = &#039;sum(total)&#039;;
				break;
			case &#039;bookings&#039;:
				$stat_query = &#039;count(id)&#039;;
				break;
		}
		$select_query = $stat_query . &#039; as stat&#039;;
		if ( $args[&#039;group_by&#039;] ) {
			$select_query .= &#039;,&#039; . $args[&#039;group_by&#039;];
		}
		$bookings-&gt;select( $select_query );


		if ( $args[&#039;date_from&#039;] ) {
			$bookings-&gt;where( [ &#039;start_date &gt;=&#039; =&gt; $args[&#039;date_from&#039;] ] );
		}
		if ( $args[&#039;date_to&#039;] ) {
			$bookings-&gt;where( [ &#039;start_date &lt;=&#039; =&gt; $args[&#039;date_to&#039;] ] );
		}
		if ( $args[&#039;service_id&#039;] ) {
			$bookings-&gt;where( [ &#039;service_id&#039; =&gt; $args[&#039;service_id&#039;] ] );
		}
		if ( $args[&#039;agent_id&#039;] ) {
			$bookings-&gt;where( [ &#039;agent_id&#039; =&gt; $args[&#039;agent_id&#039;] ] );
		}
		if ( $args[&#039;location_id&#039;] ) {
			$bookings-&gt;where( [ &#039;location_id&#039; =&gt; $args[&#039;location_id&#039;] ] );
		}
		if ( $args[&#039;customer_id&#039;] ) {
			$bookings-&gt;where( [ &#039;customer_id&#039; =&gt; $args[&#039;customer_id&#039;] ] );
		}
		if ( $args[&#039;group_by&#039;] ) {
			$bookings-&gt;group_by( $args[&#039;group_by&#039;] );
		}
		// TODO, need to support custom status exclusions
		if ( $args[&#039;exclude_status&#039;] == LATEPOINT_BOOKING_STATUS_CANCELLED ) {
			$bookings-&gt;should_not_be_cancelled();
		}

		$stat_total = $bookings-&gt;get_results( ARRAY_A );
		if ( $args[&#039;group_by&#039;] ) {
			return $stat_total;
		} else {
			return isset( $stat_total[0][&#039;stat&#039;] ) ? $stat_total[0][&#039;stat&#039;] : 0;
		}
	}

	public static function get_new_customer_stat_for_period( DateTime $date_from, DateTime $date_to, \LatePoint\Misc\Filter $filter ) {
		// TODO make sure filter is respected
		$customers = new OsCustomerModel();

		return $customers-&gt;filter_allowed_records()-&gt;where( [
			&#039;created_at &gt;=&#039; =&gt; $date_from-&gt;format( &#039;Y-m-d&#039; ),
			&#039;created_at &lt;=&#039; =&gt; $date_to-&gt;format( &#039;Y-m-d&#039; )
		] )-&gt;count();
	}

	public static function get_stat_for_period( $stat, $date_from, $date_to, \LatePoint\Misc\Filter $filter, $group_by = false ) {
		if ( ! in_array( $stat, [ &#039;duration&#039;, &#039;price&#039;, &#039;bookings&#039; ] ) ) {
			return false;
		}
		if ( ! in_array( $group_by, [ false, &#039;agent_id&#039;, &#039;service_id&#039;, &#039;location_id&#039; ] ) ) {
			return false;
		}
		$bookings = new OsBookingModel();
		switch ( $stat ) {
			case &#039;duration&#039;:
				$stat_query = &#039;SUM(end_time - start_time)&#039;;
				break;
			case &#039;price&#039;:
				$stat_query = &#039;sum(&#039; . LATEPOINT_TABLE_ORDER_ITEMS . &#039;.subtotal)&#039;;
				$bookings-&gt;join( LATEPOINT_TABLE_ORDER_ITEMS, [ &#039;id&#039; =&gt; $bookings-&gt;table_name . &#039;.order_item_id&#039; ] );
				$bookings-&gt;join( LATEPOINT_TABLE_ORDERS, [ &#039;id&#039; =&gt; LATEPOINT_TABLE_ORDER_ITEMS . &#039;.order_id&#039; ] );
				break;
			case &#039;bookings&#039;:
				$stat_query = &#039;count(id)&#039;;
				break;
		}
		$select_query = $stat_query . &#039; as stat&#039;;
		if ( $group_by ) {
			$select_query .= &#039;,&#039; . $group_by;
		}
		$bookings-&gt;select( $select_query )-&gt;where( [ &#039;start_date &gt;=&#039; =&gt; $date_from, &#039;start_date &lt;= &#039; =&gt; $date_to ] );

		if ( $filter-&gt;service_id ) {
			$bookings-&gt;where( [ &#039;service_id&#039; =&gt; $filter-&gt;service_id ] );
		}
		if ( $filter-&gt;agent_id ) {
			$bookings-&gt;where( [ &#039;agent_id&#039; =&gt; $filter-&gt;agent_id ] );
		}
		if ( $filter-&gt;location_id ) {
			$bookings-&gt;where( [ &#039;location_id&#039; =&gt; $filter-&gt;location_id ] );
		}

		$bookings-&gt;should_not_be_cancelled();

		if ( $group_by ) {
			$bookings-&gt;group_by( $group_by );
		}

		$stat_total = $bookings-&gt;get_results( ARRAY_A );
		if ( $group_by ) {
			return $stat_total;
		} else {
			return isset( $stat_total[0][&#039;stat&#039;] ) ? $stat_total[0][&#039;stat&#039;] : 0;
		}
	}

	public static function get_total_bookings_per_day_for_period( $date_from, $date_to, \LatePoint\Misc\Filter $filter ) {
		$bookings = new OsBookingModel();
		$bookings-&gt;select( &#039;count(id) as bookings_per_day, start_date&#039; )
		         -&gt;where( [ &#039;start_date &gt;=&#039; =&gt; $date_from, &#039;start_date &lt;=&#039; =&gt; $date_to ] )
		         -&gt;where( [ &#039;status NOT IN&#039; =&gt; OsCalendarHelper::get_booking_statuses_hidden_from_calendar() ] );
		if ( $filter-&gt;service_id ) {
			$bookings-&gt;where( [ &#039;service_id&#039; =&gt; $filter-&gt;service_id ] );
		}
		if ( $filter-&gt;agent_id ) {
			$bookings-&gt;where( [ &#039;agent_id&#039; =&gt; $filter-&gt;agent_id ] );
		}
		if ( $filter-&gt;location_id ) {
			$bookings-&gt;where( [ &#039;location_id&#039; =&gt; $filter-&gt;location_id ] );
		}
		$bookings-&gt;group_by( &#039;start_date&#039; );

		return $bookings-&gt;get_results();
	}


	public static function get_min_max_work_periods( $specific_weekdays = false, $service_id = false, $agent_id = false ) {
		$select_string = &#039;MIN(start_time) as start_time, MAX(end_time) as end_time&#039;;
		$work_periods  = new OsWorkPeriodModel();
		$work_periods  = $work_periods-&gt;select( $select_string );
		$query_args    = array( &#039;service_id&#039; =&gt; 0, &#039;agent_id&#039; =&gt; 0 );
		if ( $service_id ) {
			$query_args[&#039;service_id&#039;] = $service_id;
		}
		if ( $agent_id ) {
			$query_args[&#039;agent_id&#039;] = $agent_id;
		}
		if ( $specific_weekdays &amp;&amp; ! empty( $specific_weekdays ) ) {
			$query_args[&#039;week_day&#039;] = $specific_weekdays;
		}
		$results = $work_periods-&gt;set_limit( 1 )-&gt;where( $query_args )-&gt;get_results( ARRAY_A );
		if ( ( $service_id || $agent_id ) &amp;&amp; empty( $results[&#039;min_start_time&#039;] ) ) {
			if ( $service_id &amp;&amp; empty( $results[&#039;min_start_time&#039;] ) ) {
				$query_args[&#039;service_id&#039;] = 0;
				$work_periods             = new OsWorkPeriodModel();
				$work_periods             = $work_periods-&gt;select( $select_string );
				$results                  = $work_periods-&gt;set_limit( 1 )-&gt;where( $query_args )-&gt;get_results( ARRAY_A );
			}
			if ( $agent_id &amp;&amp; empty( $results[&#039;min_start_time&#039;] ) ) {
				$query_args[&#039;agent_id&#039;] = 0;
				$work_periods           = new OsWorkPeriodModel();
				$work_periods           = $work_periods-&gt;select( $select_string );
				$results                = $work_periods-&gt;set_limit( 1 )-&gt;where( $query_args )-&gt;get_results( ARRAY_A );
			}
		}
		if ( $results ) {
			return array( $results[&#039;start_time&#039;], $results[&#039;end_time&#039;] );
		} else {
			return false;
		}
	}


	public static function get_work_start_end_time_for_multiple_dates( $dates = false, $service_id = false, $agent_id = false ) {
		$specific_weekdays = array();
		if ( $dates ) {
			foreach ( $dates as $date ) {
				$target_date = new OsWpDateTime( $date );
				$weekday     = $target_date-&gt;format( &#039;N&#039; );
				if ( ! in_array( $weekday, $specific_weekdays ) ) {
					$specific_weekdays[] = $weekday;
				}
			}
		}
		$work_minmax_start_end = self::get_min_max_work_periods( $specific_weekdays, $service_id, $agent_id );

		return $work_minmax_start_end;
	}

	/**
	 * @param int $minute
	 * @param \LatePoint\Misc\WorkPeriod[] $work_periods_arr
	 *
	 * @return bool
	 */
	public static function is_minute_in_work_periods( int $minute, array $work_periods_arr ): bool {
		// print_r($work_periods_arr);
		if ( empty( $work_periods_arr ) ) {
			return false;
		}
		foreach ( $work_periods_arr as $work_period ) {
			// end of period does not count because we cant make appointment with 0 duration
			if ( $work_period-&gt;start_time &lt;= $minute &amp;&amp; $work_period-&gt;end_time &gt; $minute ) {
				return true;
			}
		}

		return false;
	}

	public static function get_calendar_start_end_time( $bookings, $work_start_minutes, $work_end_minutes ) {
		$calendar_start_minutes = $work_start_minutes;
		$calendar_end_minutes   = $work_end_minutes;
		if ( $bookings ) {
			foreach ( $bookings as $bookings_for_agent ) {
				if ( $bookings_for_agent ) {
					foreach ( $bookings_for_agent as $booking ) {
						if ( $booking-&gt;start_time &lt; $calendar_start_minutes ) {
							$calendar_start_minutes = $booking-&gt;start_time;
						}
						if ( $booking-&gt;end_time &gt; $calendar_end_minutes ) {
							$calendar_end_minutes = $booking-&gt;end_time;
						}
					}
				}
			}
		}

		return [ $calendar_start_minutes, $calendar_end_minutes ];
	}

	public static function generate_direct_manage_booking_url( OsBookingModel $booking, string $for ): string {
		if ( ! in_array( $for, [ &#039;agent&#039;, &#039;customer&#039; ] ) ) {
			return &#039;&#039;;
		}
		$key = $booking-&gt;get_key_to_manage_for($for);
		$url = OsRouterHelper::build_admin_post_link( [ &#039;manage_booking_by_key&#039;, &#039;show&#039; ], [ &#039;key&#039; =&gt; $key ] );

		return $url;
	}

    public static function generate_summary_actions_for_booking(OsBookingModel $booking, ?string $key = null){
        ?&gt;
        &lt;div class=&quot;booking-full-summary-actions&quot;&gt;
		  &lt;div class=&quot;add-to-calendar-wrapper&quot;&gt;
		    &lt;a href=&quot;#&quot; class=&quot;open-calendar-types booking-summary-action-btn&quot;&gt;&lt;i class=&quot;latepoint-icon latepoint-icon-calendar&quot;&gt;&lt;/i&gt;&lt;span&gt;&lt;?php esc_html_e(&#039;Add to Calendar&#039;, &#039;latepoint&#039;); ?&gt;&lt;/span&gt;&lt;/a&gt;
			  &lt;?php echo OsBookingHelper::generate_add_to_calendar_links($booking, $key ?? $booking-&gt;get_key_to_manage_for(&#039;customer&#039;)); ?&gt;
		  &lt;/div&gt;
	    &lt;a href=&quot;&lt;?php echo esc_url($booking-&gt;get_print_link($key ?? $booking-&gt;get_key_to_manage_for(&#039;customer&#039;))); ?&gt;&quot; class=&quot;print-booking-btn booking-summary-action-btn&quot; target=&quot;_blank&quot;&gt;&lt;i class=&quot;latepoint-icon latepoint-icon-printer&quot;&gt;&lt;/i&gt;&lt;span&gt;&lt;?php esc_html_e(&#039;Print&#039;, &#039;latepoint&#039;); ?&gt;&lt;/span&gt;&lt;/a&gt;
          &lt;?php
			if($booking-&gt;is_upcoming()){
				if(OsCustomerHelper::can_reschedule_booking($booking)){ ?&gt;
					&lt;a href=&quot;#&quot; class=&quot;latepoint-request-booking-reschedule booking-summary-action-btn&quot; data-os-after-call=&quot;latepoint_init_reschedule&quot; data-os-lightbox-classes=&quot;width-450 reschedule-calendar-wrapper&quot; data-os-action=&quot;&lt;?php echo esc_attr(OsRouterHelper::build_route_name(&#039;manage_booking_by_key&#039;, &#039;request_reschedule_calendar&#039;)); ?&gt;&quot; data-os-params=&quot;&lt;?php echo esc_attr(OsUtilHelper::build_os_params([&#039;key&#039; =&gt; $key ?? $booking-&gt;get_key_to_manage_for(&#039;customer&#039;)])); ?&gt;&quot; data-os-output-target=&quot;lightbox&quot;&gt;
						&lt;i class=&quot;latepoint-icon latepoint-icon-calendar&quot;&gt;&lt;/i&gt;
						&lt;span&gt;&lt;?php esc_html_e(&#039;Reschedule&#039;, &#039;latepoint&#039;); ?&gt;&lt;/span&gt;
					&lt;/a&gt;
					&lt;?php
				}
				if(OsCustomerHelper::can_cancel_booking($booking)){ ?&gt;
					&lt;a href=&quot;#&quot; class=&quot;booking-summary-action-btn cancel-appointment-btn&quot;
					   data-os-prompt=&quot;&lt;?php esc_attr_e(&#039;Are you sure you want to cancel this appointment?&#039;, &#039;latepoint&#039;); ?&gt;&quot;
					   data-os-success-action=&quot;reload&quot;
					   data-os-action=&quot;&lt;?php echo esc_attr(OsRouterHelper::build_route_name(&#039;manage_booking_by_key&#039;, &#039;request_cancellation&#039;)); ?&gt;&quot;
					   data-os-params=&quot;&lt;?php echo esc_attr(OsUtilHelper::build_os_params([&#039;key&#039; =&gt; $key ?? $booking-&gt;get_key_to_manage_for(&#039;customer&#039;)])); ?&gt;&quot;&gt;
						&lt;i class=&quot;latepoint-icon latepoint-icon-ui-24&quot;&gt;&lt;/i&gt;
						&lt;span&gt;&lt;?php esc_html_e(&#039;Cancel&#039;, &#039;latepoint&#039;); ?&gt;&lt;/span&gt;
					&lt;/a&gt;
					&lt;?php
				}
			}
            do_action(&#039;latepoint_booking_summary_after_booking_actions&#039;, $booking);
            ?&gt;
	  &lt;/div&gt;
        &lt;?php
    }

	public static function generate_summary_for_booking( OsBookingModel $booking, $cart_item_id = false, ?string $viewer = &#039;customer&#039; ): string {
        $summary_html = &#039;&#039;;
        $summary_html.= apply_filters( &#039;latepoint_booking_summary_before_summary_box&#039;, &#039;&#039;, $booking );
		$summary_html.= &#039;&lt;div class=&quot;summary-box main-box&quot; &#039; . ( ( $cart_item_id ) ? &#039;data-cart-item-id=&quot;&#039; . $cart_item_id . &#039;&quot;&#039; : &#039;&#039; ) . &#039;&gt;&#039;;
        $output_timezone_name = $viewer == &#039;customer&#039; ? $booking-&gt;get_customer_timezone_name() : OsTimeHelper::get_wp_timezone_name();
        if(!empty($booking-&gt;start_datetime_utc)) {
	        $summary_html .= &#039;&lt;div class=&quot;summary-box-booking-date-box&quot;&gt;&#039;;
	        $summary_html .= &#039;&lt;div class=&quot;summary-box-booking-date-day&quot;&gt;&#039; . $booking-&gt;start_datetime_in_format( &#039;j&#039;, $output_timezone_name ) . &#039;&lt;/div&gt;&#039;;
	        $summary_html .= &#039;&lt;div class=&quot;summary-box-booking-date-month&quot;&gt;&#039; . OsUtilHelper::get_month_name_by_number( $booking-&gt;start_datetime_in_format( &#039;n&#039;, $output_timezone_name ), true ) . &#039;&lt;/div&gt;&#039;;
            $summary_html .= &#039;&lt;/div&gt;&#039;;
        }
        $summary_html.= &#039;&lt;div class=&quot;summary-box-inner&quot;&gt;&#039;;
		$service_headings = [];
		$service_headings = apply_filters( &#039;latepoint_booking_summary_service_headings&#039;, $service_headings, $booking );
		if ( $service_headings ) {
			$summary_html .= &#039;&lt;div class=&quot;summary-box-heading&quot;&gt;&#039;;
			foreach ( $service_headings as $heading ) {
				$summary_html .= &#039;&lt;div class=&quot;sbh-item&quot;&gt;&#039; . $heading . &#039;&lt;/div&gt;&#039;;
			}
			$summary_html .= &#039;&lt;div class=&quot;sbh-line&quot;&gt;&lt;/div&gt;&#039;;
			$summary_html .= &#039;&lt;/div&gt;&#039;;
		}
		$summary_html .= &#039;&lt;div class=&quot;summary-box-content os-cart-item&quot;&gt;&#039;;
		if ( $cart_item_id &amp;&amp; OsCartsHelper::can_checkout_multiple_items() ) {
			$summary_html .= &#039;&lt;div class=&quot;os-remove-item-from-cart&quot; role=&quot;button&quot; tabindex=&quot;0&quot; data-confirm-text=&quot;&#039; . __( &#039;Are you sure you want to remove this item from your cart?&#039;, &#039;latepoint&#039; ) . &#039;&quot; data-cart-item-id=&quot;&#039; . $cart_item_id . &#039;&quot; data-route=&quot;&#039; . OsRouterHelper::build_route_name( &#039;carts&#039;, &#039;remove_item_from_cart&#039; ) . &#039;&quot;&gt;
															&lt;div class=&quot;os-remove-from-cart-icon&quot;&gt;&lt;/div&gt;
														&lt;/div&gt;&#039;;
		}
		$summary_html .= &#039;&lt;div class=&quot;sbc-big-item&quot;&gt;&#039; . $booking-&gt;get_service_name_for_summary() . &#039;&lt;/div&gt;&#039;;
		if ( $booking-&gt;start_date ) {
            $summary_html .= &#039;&lt;div class=&quot;sbc-highlighted-item&quot;&gt;&#039; . $booking-&gt;get_nice_datetime_for_summary($viewer) . &#039;&lt;/div&gt;&#039;;
		}
        /**
         * Output summary of the booking data after a start date and time
         *
         * @since 5.2.0
         * @hook latepoint_summary_booking_info_after_start_date
         *
         * @param {string} $summary_html HTML of the summary
         * @param {OsBookingModel} $booking Booking object that is being outputted
         * @param {string} $cart_item_id ID of a cart item this booking belongs to
         * @param {string} $viewer determines who is viewing this summary, can be customer or agent
         *
         * @returns {string} Filtered HTML
         */
        $summary_html = apply_filters(&#039;latepoint_summary_booking_info_after_start_date&#039;, $summary_html, $booking, $cart_item_id, $viewer);
		$summary_html .= &#039;&lt;/div&gt;&#039;;

		$service_attributes = [];
		$service_attributes = apply_filters( &#039;latepoint_booking_summary_service_attributes&#039;, $service_attributes, $booking );
		if ( $service_attributes ) {
			$summary_html .= &#039;&lt;div class=&quot;summary-attributes sa-clean&quot;&gt;&#039;;
			foreach ( $service_attributes as $attribute ) {
				$summary_html .= &#039;&lt;span&gt;&#039; . $attribute[&#039;label&#039;] . &#039;: &lt;strong&gt;&#039; . $attribute[&#039;value&#039;] . &#039;&lt;/strong&gt;&lt;/span&gt;&#039;;
			}
			$summary_html .= &#039;&lt;/div&gt;&#039;;
		}
		$summary_html .= &#039;&lt;/div&gt;&#039;;
		$summary_html .= apply_filters( &#039;latepoint_booking_summary_after_summary_box_inner&#039;, &#039;&#039;, $booking );
		$summary_html .= &#039;&lt;/div&gt;&#039;;
        $summary_html.= apply_filters( &#039;latepoint_booking_summary_after_summary_box&#039;, &#039;&#039;, $booking );

		return $summary_html;
	}


	/**
	 * @param OsBookingModel[] $bookings
	 *
	 * @return bool
	 */
	public static function bookings_have_same_agent( array $bookings ): bool {
		return ( count( array_unique( array_column( $bookings, &#039;agent_id&#039; ) ) ) == 1 );
	}

	/**
	 * @param OsBookingModel[] $bookings
	 *
	 * @return bool
	 */
	public static function bookings_have_same_location( array $bookings ): bool {
		return ( count( array_unique( array_column( $bookings, &#039;location_id&#039; ) ) ) == 1 );
	}

	/**
	 * @param OsBookingModel[] $bookings
	 *
	 * @return bool
	 */
	public static function bookings_have_same_service( array $bookings ): bool {
		return ( count( array_unique( array_column( $bookings, &#039;service_id&#039; ) ) ) == 1 );
	}

	public static function prepare_new_from_params( array $params ): OsBookingModel {
		$booking = new OsBookingModel();

		$services = OsServiceHelper::get_allowed_active_services();
		$agents   = OsAgentHelper::get_allowed_active_agents();

		// LOAD FROM PASSED PARAMS
		$booking-&gt;order_item_id = $params[&#039;order_item_id&#039;] ?? &#039;&#039;;
		$booking-&gt;service_id    = ! empty( $params[&#039;service_id&#039;] ) ? OsUtilHelper::first_value_if_array( $params[&#039;service_id&#039;] ) : &#039;&#039;;
		if ( empty( $booking-&gt;service_id ) &amp;&amp; ! empty( $services ) ) {
			$booking-&gt;service_id = $services[0]-&gt;id;
		}

		$booking-&gt;agent_id = ! empty( $params[&#039;agent_id&#039;] ) ? OsUtilHelper::first_value_if_array( $params[&#039;agent_id&#039;] ) : &#039;&#039;;
		if ( empty( $booking-&gt;agent_id ) &amp;&amp; ! empty( $agents ) ) {
			$booking-&gt;agent_id = $agents[0]-&gt;id;
		}

		if ( ! empty( $params[&#039;order_id&#039;] ) ) {
			$order                = new OsOrderModel( $params[&#039;order_id&#039;] );
			$booking-&gt;customer_id = $order-&gt;customer_id;
		} else {
			$booking-&gt;customer_id = ! empty( $params[&#039;customer_id&#039;] ) ? OsUtilHelper::first_value_if_array( $params[&#039;customer_id&#039;] ) : &#039;&#039;;
		}

		$booking-&gt;location_id = ! empty( $params[&#039;location_id&#039;] ) ? OsUtilHelper::first_value_if_array( $params[&#039;location_id&#039;] ) : OsLocationHelper::get_default_location_id( true );
		$booking-&gt;start_date  = $params[&#039;start_date&#039;] ?? OsTimeHelper::today_date( &#039;Y-m-d&#039; );
		$booking-&gt;start_time  = $params[&#039;start_time&#039;] ?? 600;

		$booking-&gt;end_time      = ( $booking-&gt;service_id ) ? $booking-&gt;calculate_end_time() : $booking-&gt;start_time + 60;
		$booking-&gt;end_date      = $booking-&gt;calculate_end_date();
		$booking-&gt;buffer_before = ( $booking-&gt;service_id ) ? $booking-&gt;service-&gt;buffer_before : 0;
		$booking-&gt;buffer_after  = ( $booking-&gt;service_id ) ? $booking-&gt;service-&gt;buffer_after : 0;
		$booking-&gt;status        = LATEPOINT_BOOKING_STATUS_APPROVED;

		return $booking;
	}


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