FileMaster

Edit File: where_to_save.php

<?php

if ( ! defined( 'ABSPATH' ) ) exit;                                             // Exit if accessed directly            // FixIn: 9.8.0.4.

// ---------------------------------------------------------------------------------------------------------------------
// Check  where to  save the booking
// ---------------------------------------------------------------------------------------------------------------------

/**
 * Get booking resources for each  selected date, where we can save the booking,  or false if we can not save it
 *
 * @param array $params = [
 *							'resource_id'                 => 2
 *							'skip_booking_id'             => '',            |  125 if edit booking
 *						    'dates_only_sql_arr'          => [ "2023-10-18", "2023-10-25", "2023-11-25" ]
 *							'time_as_seconds_arr'         => [ 36000, 39600 ]
 *                          'how_many_items_to_book'      => 1
 *                          'request_uri'                 => 'http://beta/resource-id2/'            // Optional     default ->  DOING_AJAX  ? $_SERVER['HTTP_REFERER'] : $_SERVER['REQUEST_URI']
 *                          'as_single_resource'          => false,                                 // Optional     default false
 *                        'is_use_booking_recurrent_time' => false                                  // Optional     default ( 'On' === get_bk_option( 'booking_recurrent_time' ) )
 *                       ]
 * @return array       = [ 'result' => 'ok', 'main__resource_id' => 2, 'resources_in_dates' => [  '2023-09-23':[2,10,11],  '2023-09-24':[2,10,11]  ],   'time_to_book' => [ "00:00:00", "24:00:00" ]   ]
 *                              Note.  'main__resource_id'  - it's first booking resource in the list, basically  needed for saving in wp_booking DB table.
 *                              OR
 *                     = [ 'result' => 'error', 'message' => 'Booking can not be saved ...' ]
 */
function wpbc__where_to_save_booking( $local_params ){

$server_request_uri = ( ( isset( $_SERVER['REQUEST_URI'] ) ) ? sanitize_text_field( $_SERVER['REQUEST_URI'] ) : '' );  /* phpcs:ignore WordPress.Security.NonceVerification.Missing, WordPress.Security.ValidatedSanitizedInput.MissingUnslash */ /* FixIn: sanitize_unslash */
	$server_http_referer_uri = ( ( isset( $_SERVER['HTTP_REFERER'] ) ) ? sanitize_text_field( $_SERVER['HTTP_REFERER'] ) : '' );  /* phpcs:ignore WordPress.Security.NonceVerification.Missing, WordPress.Security.ValidatedSanitizedInput.MissingUnslash */ /* FixIn: sanitize_unslash */
	$defaults = array(
					'request_uri'                   => ( ( ( defined( 'DOING_AJAX' ) ) && ( DOING_AJAX ) ) ? $server_http_referer_uri : $server_request_uri ), //  front-end: $server_request_uri | ajax: $server_http_referer_uri                      // It different in Ajax requests. It's used for change-over days to detect for exception at specific pages
					'as_single_resource'            => false,
					'is_use_booking_recurrent_time' => ( 'On' === get_bk_option( 'booking_recurrent_time' ) ),
					'aggregate_resource_id_arr'     => array(),
					'custom_form'                   => ''                      //FixIn: 10.0.0.10       // Required for checking all available time-slots and compare with  booked time slots
				);
	$local_params   = wp_parse_args( $local_params, $defaults );

$time_as_seconds_arr    = $local_params['time_as_seconds_arr'];
	$time_as_seconds_arr[0] = ( 0 != $time_as_seconds_arr[0] ) ? $time_as_seconds_arr[0] + 1 : $time_as_seconds_arr[0];                 // +1 s. -- set check  in time with  ended 1 second
	$time_as_seconds_arr[1] = ( ( 24 * 60 * 60 ) != $time_as_seconds_arr[1] ) ? $time_as_seconds_arr[1] + 2 : $time_as_seconds_arr[1];     // +2 s. -- set check out time with  ended 2 seconds
	if ( ( 0 != $time_as_seconds_arr[0] ) && ( ( 24 * 60 * 60 ) == $time_as_seconds_arr[1] ) ) {
		//FixIn: 10.0.0.49  - in case if we have start time != 00:00  and end time as 24:00 then  set  end time as 23:59:52
		$time_as_seconds_arr[1] += - 8;
	}
	$local_params['time_as_his_arr'] = array(
												wpbc_transform__seconds__in__24_hours_his( $time_as_seconds_arr[0] ),
												wpbc_transform__seconds__in__24_hours_his( $time_as_seconds_arr[1] )
										);

// If we are using the unavailable before/after booking dates,  then we need to extend "$local_params['dates_only_sql_arr']" to such  dates.
	if ( function_exists( 'wpbc__extend_checking_dates_range__if_used__extra_seconds__before_after' ) ) {
		$maybe_extended__dates_to_check_arr = wpbc__extend_checking_dates_range__if_used__extra_seconds__before_after( $local_params['dates_only_sql_arr'] );
	} else {
		$maybe_extended__dates_to_check_arr = $local_params['dates_only_sql_arr'];
	}
	// [ "dates": [ "2023-11-05": [ "day_availability":4, ... "2": [ "is_day_unavailable":false, ...]], '2023-11-06':[...] ] ,"resources_id_arr__in_dates":[2,12,10,11]}
	$availability_per_days = wpbc_get_availability_per_days_arr( array(
		'resource_id'         => $local_params['resource_id'],
		'skip_booking_id'     => $local_params['skip_booking_id'],
		'dates_to_check'      => $maybe_extended__dates_to_check_arr,
		'request_uri'         => $local_params['request_uri'],
		'as_single_resource' => $local_params['as_single_resource'],                                                            // default FALSE  ::  get dates as for 'single resource' or 'parent' resource including bookings in all 'child booking resources' .
		'additional_bk_types' => $local_params['aggregate_resource_id_arr'],
		'aggregate_type'      => empty( $local_params['aggregate_type'] ) ? 'bookings_only' : $local_params['aggregate_type'],  //TODO: this parameter does not transfer during saving, so here will be always default value 'bookings_only'        // FixIn: 10.0.0.7.
		'custom_form'         => $local_params['custom_form'],                                                                  // FixIn: 10.0.0.10.
	) );

// Get value of how many  booking resources to  book
	$how_many_items_to_book = $local_params['how_many_items_to_book'];
	// -------------------------------------------------------------------------------------------------------------
	// [ 2023-10-18: [ 0:[ resource_id: 2, is_available: true, booked__seconds: [], booked__readable: [], time_to_book__seconds: [ 36030, 39570 ], time_to_book__readable: "10:00:00", "11:00:00" ] ], 1: [...], 2: [...], 3: [...] ], 2023-10-25: [...], 2023-11-25: [...] ]
	$available_slots = wpbc__get_available_slots__for_selected_dates_times__bl( array(
																					'dates_sql__arr'                => $local_params['dates_only_sql_arr'],
																					'time_as_seconds_arr'           => $local_params['time_as_seconds_arr'],
																					'is_use_booking_recurrent_time' => $local_params['is_use_booking_recurrent_time'],
																					'availability_per_days'         => $availability_per_days
																				) );

$main__resource_id = 0;
	// == In      SAME      'child' booking resources   ============================================================
	if ( 'On' === get_bk_option( 'booking_is_dissbale_booking_for_different_sub_resources' ) ) {

$availability_in_same_child_resources = $availability_per_days['resources_id_arr__in_dates'];

foreach ( $availability_per_days['resources_id_arr__in_dates'] as $child_resource_id ) {
			foreach ( $local_params['dates_only_sql_arr'] as $day_sql_key ) {
				foreach ( $available_slots[ $day_sql_key ] as $available_slot ) {
					if (
						    ( $child_resource_id == $available_slot['resource_id'] )
					     && ( ! $available_slot['is_available'] )
					){
						$availability_in_same_child_resources = array_diff( $availability_in_same_child_resources, array( $child_resource_id ) );       // Remove $child_resource_id from  array
						break;
					}
				}
			}
		}

// Reset  indexes in this array  for ability to  get  first [0]  element in this arr.
		$availability_in_same_child_resources = array_values( $availability_in_same_child_resources );
		$main__resource_id = ( ! empty( $availability_in_same_child_resources ) ) ? $availability_in_same_child_resources[0] : 0;

// [ 2, 12, 11 ]  	<- 		ID of child booking resources, where we can  save our booking in the same child booking resource!
		if ( count( $availability_in_same_child_resources ) >= $how_many_items_to_book ) {

$availability_in_same_child_resources_by_dates = array();
			foreach ( $local_params['dates_only_sql_arr'] as $day_sql_key ) {
				$availability_in_same_child_resources_by_dates[ $day_sql_key ] = $availability_in_same_child_resources;
			}
			// Good Save it
			return array(
							'result'             => 'ok',
							'resources_in_dates' => $availability_in_same_child_resources_by_dates,                 // [ 2023-09-23 = [ 2, 10, 11 ],  2023-09-24 = [  2, 10, 11 ]
							'time_to_book'       => $local_params['time_as_his_arr'],                               // [ "00:00:00", "24:00:00" ]
							'main__resource_id'  => $main__resource_id
						);
		} else {
			// Bad not save
			return array(
							'result'  => 'error',
							'message' => __( 'These dates and times in this calendar are already booked or unavailable.', 'booking' )
							             . ' <br> '
										 . __( 'It is not possible to store this sequence of the dates into the one same resource.' , 'booking' )
							             . ' <br> '
										 . __( 'Please choose alternative date(s), times, or adjust the number of slots booked.' , 'booking' )
										 . ' <a href="javascript:void(0)" onclick="'
							                             .'jQuery( this ).next().toggle();'
							                             .'jQuery( this).hide();'
														 .'jQuery( this ).parents(\'.wpbc_alert_message\').parent().on(\'hide\',function(even){jQuery(this).show();});'
			                                    .'">'
							             .    __( 'Show more details', 'booking' )
							             . '</a>'
							             . ' <div style="display:none;">'
							                    . '<p><hr><code>'
							                    . wp_json_encode( $available_slots )
							                    . '</code></p>'
							             . '</div>'
							             . ' <div style="display:none;">' . wp_json_encode( $available_slots ) . '</div>'
						);
		}

} else {

// == In      ANY      'child' booking resources   =========================================================

$availability_in_any_child_resources = array();
		foreach ( $available_slots as $day_sql_key => $available_slot ) {                           // '2023-09-10': [], '2023-09-14': [],
			$availability_in_any_child_resources[ $day_sql_key ] = array();
			foreach ( $available_slot as $ind => $slot_value ) {                                    // [ 0:{ resource_id: 2,  is_available: false,...} , .... ]
				if ( $slot_value['is_available'] ) {
					if ( empty( $main__resource_id ) ) {
						$main__resource_id = $slot_value['resource_id'];
					}
					$availability_in_any_child_resources[ $day_sql_key ][] = $slot_value['resource_id'];
				}
			}
		}
        /**
         * {    "2023-09-10": [ 2, 10, 11 ]				<- available ID of child resources in this date
                "2023-09-14": [ 4 ]						<- available ID of child resources in this date
           }
         */

foreach ( $availability_in_any_child_resources as $day_sql_key2 => $available_res_in_day_arr ) {
			if ( count( $available_res_in_day_arr ) < $how_many_items_to_book ) {
				// Bad not save
				// We can not store booking in this date  day_sql_key2,  number of available child booking resources less than  required
				return array(
							'result'  => 'error',
							'message' => __( 'These dates and times in this calendar are already booked or unavailable.', 'booking' )
							             . ' <br> '
										 . __( 'Please choose alternative date(s), times, or adjust the number of slots booked.' , 'booking' )
										 . ' <a href="javascript:void(0)" onclick="'
							                             .'jQuery( this ).next().toggle();'
							                             .'jQuery( this).hide();'
														 .'jQuery( this ).parents(\'.wpbc_alert_message\').parent().on(\'hide\',function(even){jQuery(this).show();});'
			                                    .'">'
							             .    __( 'Show more details', 'booking' )
							             . '</a>'
							             . ' <div style="display:none;">'
							                    . '<p><strong>'
									            /* translators: 1: ... */
									            . sprintf( __( 'Booking can not be saved in this date %1$s, number of available (single or child) booking resource(s) (%2$d) less than required (%3$d).', 'booking' )
															, $day_sql_key2, count( $available_res_in_day_arr ), $how_many_items_to_book )
												. '</strong><hr><code>'
							                    . wp_json_encode( $available_slots )
							                    // . wp_json_encode( $local_params, $availability_per_days )
							                    . '</code></p>'
							             . '</div>'

);
			}
		}

// Good Save it
		return  array(
							'result'             => 'ok',
							'resources_in_dates' => $availability_in_any_child_resources,                           // [ 2023-09-23 = [ 2, 10, 11 ],  2023-09-24 = [  2, 10, 11 ]
							'time_to_book'       => $local_params['time_as_his_arr'],                                // [ "00:00:00", "24:00:00" ]
							'main__resource_id'  => $main__resource_id
						);
	}
}

/**
	 * Get available slots per each date in each slot (child resource). It's checking times as well.
	 *
	 * @param $params       [
	 *							dates_sql__arr        = [ "2023-10-18", "2023-10-25", "2023-11-25" ]
	 *							time_as_seconds_arr   = [ 36030,  39570 ]
	 *							availability_per_days = [ dates = [...], resources_id_arr__in_dates = [...] ]
	 *                      ]
	 *
	 * @return array        [
	 *							2023-10-18 = [
	 *											 0 = [
	 *												  resource_id = 2
	 *												  is_available = true
	 *												  booked__seconds = []
	 *												  booked__readable = []
	 *												  time_to_book__seconds = [ 36030,  39570 ]
	 *												  time_to_book__readable =  "10:00:00",  "11:00:00" ]
	 *												]
	 *											 1 = [...]
	 *											 2 = [...]
	 *											 3 = [...]
	 *                                       ]
	 *							2023-10-25 = [...]
	 *							2023-11-25 = [...]
	 *                       ]
	 */
	function wpbc__get_available_slots__for_selected_dates_times__bl( $params ) {

$defaults = array(
							'dates_sql__arr'         => array(),
							'time_as_seconds_arr'    => array(),
							'availability_per_days'  => array(),
							'is_use_booking_recurrent_time' => ( 'On' === get_bk_option( 'booking_recurrent_time' ) )
						);
		$params   = wp_parse_args( $params, $defaults );

$time_as_seconds_arr = $params['time_as_seconds_arr'];

// Shift time interval  in 30 seconds
		$shift__30sec = array( 30, 30 );
        $time_as_seconds_arr[ 0 ] = $time_as_seconds_arr[ 0 ] + $shift__30sec[0];
        $time_as_seconds_arr[ 1 ] = $time_as_seconds_arr[ 1 ] - $shift__30sec[1];

$available_resources_arr = array();

foreach ( $params['dates_sql__arr'] as $sql_class_day_number => $sql_class_day ) {
			$available_resources_arr[ $sql_class_day ] = array();
			$date_shift__30sec = $shift__30sec;

if ( isset( $params['availability_per_days']['dates'][ $sql_class_day ] ) ) {

$this_date_time_as_seconds_arr = $time_as_seconds_arr;

//TODO: debug   this checking in  biz_l.js   2023-09-05 16:40    ---   If we are using not time slot but the check in/out times ?

// +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
				// Duplicated part of code, as in        ../do_search.php       //FixIn: 2024-05-12_11:58
				// +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
				if (
					   ( ! $params['is_use_booking_recurrent_time'] )
					&& ( count( $params['dates_sql__arr'] ) > 1 )
				) {
					if ( 0 == $sql_class_day_number ) {                                                             // check in
						$this_date_time_as_seconds_arr[1] = 24 * 60 * 60;
						$date_shift__30sec[1]             = 0;
					} else if ( ( count( $params['dates_sql__arr'] ) - 1 ) == $sql_class_day_number ) {             // check out
						$this_date_time_as_seconds_arr[0] = 0;
						$date_shift__30sec[0]             = 0;
					} else {
						$this_date_time_as_seconds_arr = array( 0, 24 * 60 * 60 );
						$date_shift__30sec             = array( 0, 0 );
					}
				}
				// +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

$date_bookings_obj = $params['availability_per_days']['dates'][ $sql_class_day ];

foreach ( $params['availability_per_days']['resources_id_arr__in_dates'] as $child_resource_id ) {

$merged_seconds_arr = wpbc_get__booking_obj__merged_seconds_arr( $date_bookings_obj[ $child_resource_id ] );

$is_intersect       = wpbc_is_intersect__merged_seconds_arr__and__seconds_arr( $merged_seconds_arr['merged_seconds'], $this_date_time_as_seconds_arr );

$this_date_available_resource = array(
									                        'resource_id'           => $child_resource_id,
									                        'is_available'          => (! $is_intersect),
									                        'booked__seconds'       => $merged_seconds_arr['merged_seconds'],
									                        'booked__readable'      => $merged_seconds_arr['merged_readable'],
									                        'time_to_book__seconds' => $this_date_time_as_seconds_arr,
									                        'time_to_book__readable'=> array()
									                    );
					$this_date_available_resource['time_to_book__readable'][] = wpbc_transform__seconds__in__24_hours_his(
																					 (
																						    ( ( $this_date_time_as_seconds_arr[0] - $date_shift__30sec[0] ) < 0 )
																							? 0
																						    : ( $this_date_time_as_seconds_arr[0] - $date_shift__30sec[0] )
																					 )
					                                                            );
					$this_date_available_resource['time_to_book__readable'][] = wpbc_transform__seconds__in__24_hours_his(
																					(
																							( ( $this_date_time_as_seconds_arr[1] + $date_shift__30sec[1] ) > 86400 )
																							? 86400
																							: ( $this_date_time_as_seconds_arr[1] + $date_shift__30sec[1] )
																					)
																				);

$available_resources_arr[ $sql_class_day ][] = $this_date_available_resource;
				 }
			}
		}

return $available_resources_arr;
	}

/**
		 * Get Merged Seconds Array from   object ->  $params['availability_per_days']['dates'][ $sql_class_day ][ $child_resource_id ]
		 *
		 * @param $date_booking_obj - date_bookings_obj  from   $params['availability_per_days']['dates']
		 *
		 * @return array            -  [
		 *                                    'merged_seconds'  => $merged_seconds,
		 *                                    'merged_readable' => $merged_readable
		 *                             ]
		 */
		function wpbc_get__booking_obj__merged_seconds_arr( $date_booking_obj ) {

if ( $date_booking_obj->is_day_unavailable ){
				$merged_seconds  = array( array( 0, 24 * 60 * 60 ) );                                            // Unavailable
				$merged_readable = array( wpbc_transform_timerange__seconds_arr__in__formated_hours( array( 0, 24 * 60 * 60 ) ) );
			} else {
				$merged_seconds  = $date_booking_obj->booked_time_slots['merged_seconds'];       // [  [ 25211, 27002 ], [ 36011, 86400 ]  ]    // Time slots or Available
				$merged_readable = $date_booking_obj->booked_time_slots['merged_readable'];
			}

return array(
							'merged_seconds'  => $merged_seconds,
							'merged_readable' => $merged_readable
						);
		}

/**
		 * Check if  merged_seconds in  $params['availability_per_days']['dates'][ $sql_class_day ][ $child_resource_id ]     intersect   with    $time_as_seconds_arr
		 *
		 * @param $merged_seconds                       - [  [ 0, 86400 ]   ]

* @param $this_date_time_as_seconds_arr        - [ 36030,  39570 ]      |   [ 0, 24*60*60 ]
		 *
		 * @return bool
		 */
		function wpbc_is_intersect__merged_seconds_arr__and__seconds_arr( $merged_seconds, $this_date_time_as_seconds_arr ) {

$is_intersect = wpbc_is_intersect__range_time_interval(
                                                                    array(
                                                                        array(
                                                                          intval( $this_date_time_as_seconds_arr[ 0 ] ) + 20
                                                                        , intval( $this_date_time_as_seconds_arr[ 1 ] ) - 20
                                                                        )
                                                                    )
                                                                 , $merged_seconds );
			return $is_intersect;
		}

/**
	 * Is these array of intervals intersected ?    -   overlay of Math function
	 *
	 * @param array $time_interval_A		array( array( 21600, 23400 )                         )
	 * @param array $time_interval_B		array( array( 25211, 27002 ), array( 36011, 86400 )  )
	 *
	 * @return bool
	 */
	function wpbc_is_intersect__range_time_interval( $time_interval_A, $time_interval_B ){

for ( $i = 0; $i < count($time_interval_A); $i++ ){

for ( $j = 0; $j < count($time_interval_B); $j++ ){

$is_intersect = wpbc_is__intervals__intersected( $time_interval_A[ $i ], $time_interval_B[ $j ] );

if ( $is_intersect ){
					return true;
				}
			}
		}

return false;
	}

Back