FileMaster

Edit File: wpbc-dates.php

<?php 
/**
 * @version 1.0
 * @package Booking Calendar 
 * @subpackage Dates Functions
 * @category Functions
 * 
 * @author wpdevelop
 * @link https://wpbookingcalendar.com/
 * @email info@wpbookingcalendar.com
 *
 * @modified 29.09.2015
 */

if ( ! defined( 'ABSPATH' ) ) exit;                                             // Exit if accessed directly

/**
		 * Get the dates in different formats
	 *
	 * @param type $str_dates__dd_mm_yyyy
	 * @param type $booking_type
	 * @param type $booking_form_data
	 * @return
	            array(
	                      'string' => "30.02.2014, 31.02.2014, 01.03.2014"
	                    , 'array'  => array("2014-02-30", "2014-02-31", ....
	                    , 'start_time'  => array('00','00','00');
	                    , 'end_time'    => array('00','00','00');
	                );
	 */
	function wpbc_get_dates_in_diff_formats( $str_dates__dd_mm_yyyy, $booking_type, $booking_form_data ){

$str_dates__dd_mm_yyyy = str_replace( '|', ',', $str_dates__dd_mm_yyyy);    // Check  this for some old versions of plugin

if ( strpos($str_dates__dd_mm_yyyy,' - ') !== false ) {                     // Recheck for any type of Range Days Formats
	        $arr_check_in_out_dates = explode(' - ', $str_dates__dd_mm_yyyy );
	        $str_dates__dd_mm_yyyy = wpbc_get_comma_seprated_dates_from_to_day( $arr_check_in_out_dates[0], $arr_check_in_out_dates[1] );
	    }

$days_array = explode( ',', $str_dates__dd_mm_yyyy );                         // Create dates Array
	    $only_days  = array();

foreach ($days_array as $new_day) {

if ( ! empty($new_day) ) {

$new_day = trim( $new_day );

$new_day = str_replace( '-', '.', $new_day);

$new_day = explode( '.', $new_day);

$only_days[] = sprintf( "%04d-%02d-%02d", intval( $new_day[2] ), intval( $new_day[1] ), intval( $new_day[0] ) );
	        }
	    }
	    sort($only_days);                                                           // Sort Dates

// Get Times from booking form if these fields exist
	    $start_end_time = wpbc_get_times_in_form( $booking_form_data, $booking_type );

if ( $start_end_time !== false ) {
			$start_time = $start_end_time[0];                                       // array('00','00','01');
			$end_time   = $start_end_time[1];                                       // array('00','00','01');

if ( ( '00' == $start_time[0] ) && ( '00' == $start_time[1] ) ) {       // FixIn: 8.7.8.8.
				$start_time = array( '00', '00', '00' );
				$end_time   = array( '00', '00', '00' );
			} else {
				if ( count( $only_days ) == 1 ) {         // add end date if selected 1 day only and times is exist
					$only_days[] = $only_days[0];
				}
			}
		} else {
			$start_time = array( '00', '00', '00' );
			$end_time   = array( '00', '00', '00' );
		}

return array(
					    'string'     => $str_dates__dd_mm_yyyy                          // dd_mm_yyyy
				    ,   'array'      => $only_days
				    ,   'start_time' => $start_time
				    ,   'end_time'   => $end_time
			    );
	}

/**
	 * Check  for minimum  and maximum  available times,  and restrict value to  these limits.
	 *
	 * @param string $time          24:00
	 * @param string $min_time      00:01
	 * @param string $max_time      23:59
	 *
	 * @return string               23:59
	 */
	function wpbc_check_min_max_available_times( $time = '00:00', $min_time = '00:00', $max_time = '23:59' ) {

// Time in minutes
		$time_m = explode( ':', trim( $time ) );
		$time_m = intval( $time_m[0] ) * 60 + intval( $time_m[1] );

// Min time in minutes
		$min_time_m = explode( ':', trim( $min_time ) );
		$min_time_m = intval( $min_time_m[0] ) * 60 + intval( $min_time_m[1] );

// Max time in minutes
		$max_time_m = explode( ':', trim( $max_time ) );
		$max_time_m = intval( $max_time_m[0] ) * 60 + intval( $max_time_m[1] );

if ( $time_m < $min_time_m ) {
			$time_m = $min_time_m;
		}

if ( $time_m > $max_time_m ) {
			$time_m = $max_time_m;
		}

// Convert time in minutes back  to  string HH:MM
		$time_m_h = floor( $time_m / 60 );
		$time_m_m = $time_m - $time_m_h * 60;

// Check leading 0
		if ( $time_m_h < 10 ) {
			$time_m_h = '0' . $time_m_h;
		}
		if ( $time_m_m < 10 ) {
			$time_m_m = '0' . $time_m_m;
		}

return $time_m_h . ':' . $time_m_m;
	}

/**
	 * Get Times from booking Form, if these times fields exist
 * 
 * @param type $booking_form_data
 * @param type $booking_type
 * @return mixed
                    array ( array('00','00','01'), array('00','00','01') )
                      ||
                    false
 */
function wpbc_get_times_in_form( $booking_form_data, $booking_type ){

$is_time_exist = false;

$start_time = $end_time = '00:00:00';

if ( strpos( $booking_form_data, 'rangetime' . $booking_type ) !== false ) {

// ~checkbox^mymultiple4^~checkbox^rangetime4^ ~checkbox^rangetime4^12:00 - 13:00~ checkbox^rangetime4^~checkbox^rangetime4^~text^name4^Jonny~

// Types of the conditions
        $f_type =  '[^\^]*';     
        $f_name =  'rangetime[\d]*[\[\]]{0,2}';     
        $f_value =  '[\s]*([0-9:]*)[\s]*\-[\s]*([0-9:]*)[\s]*[^~]*';

$pattern_to_search='%[~]?'.$f_type.'\^'.$f_name.'\^'.$f_value.'[~]?%';

preg_match_all($pattern_to_search, $booking_form_data, $matches, PREG_SET_ORDER);

/**
	     * Example of $matches: [  [    [0] => '~checkbox^rangetime4^13:00 - 14:00~'
	                                    [1] => '13:00'
	                                    [2] => '14:00'
								] ]
        */

if (count($matches)>0){

$start_time    = wpbc_get_time_in_24_hours_format( trim( $matches[0][1] ) );
	        $start_time[2] = '01';

$end_time    = wpbc_get_time_in_24_hours_format( trim( $matches[0][2] ) );
	        $end_time[2] = '02';

$is_time_exist = true;

} else {
            $start_time = array('00','00','01');
            $end_time   = array('00','00','02');
        }

} else {

if ( strpos( $booking_form_data, 'starttime' . $booking_type ) !== false ) {      // Get START TIME From form request
		    $pos1 = strpos( $booking_form_data, 'starttime' . $booking_type );            // Find start time pos
		    $pos1 = strpos( $booking_form_data, '^', $pos1 ) + 1;                             // Find TIME pos
		    $pos2 = strpos( $booking_form_data, '~', $pos1 );                               // Find TIME length
		    if ( $pos2 === false ) {
			    $pos2 = strlen( $booking_form_data );
		    }
		    $pos2       = $pos2 - $pos1;
		    $start_time = substr( $booking_form_data, $pos1, $pos2 );
		    if ( $start_time == '' ) {
			    $start_time = '00:00';
		    }

$start_time = wpbc_check_min_max_available_times( $start_time, '00:01', '23:59' );                          // FixIn: 8.7.11.1.

$start_time = explode( ':', $start_time );

$start_time[2] = '01';
	    } else {
		    $start_time = explode( ':', $start_time );
	    }

if ( strpos( $booking_form_data, 'endtime' . $booking_type ) !== false ) {    // Get END TIME From form request
		    $pos1 = strpos( $booking_form_data, 'endtime' . $booking_type );          // Find start time pos
		    $pos1 = strpos( $booking_form_data, '^', $pos1 ) + 1;                         // Find TIME pos
		    $pos2 = strpos( $booking_form_data, '~', $pos1 );                           // Find TIME length
		    if ( $pos2 === false ) {
			    $pos2 = strlen( $booking_form_data );
		    }
		    $pos2     = $pos2 - $pos1;
		    $end_time = substr( $booking_form_data, $pos1, $pos2 );
		    if ( $end_time == '' ) {
			    $end_time = '00:00';
		    }

$end_time = wpbc_check_min_max_available_times( $end_time, '00:01', '23:59' );                              // FixIn: 8.7.11.1.

$is_time_exist = true;

$end_time    = explode( ':', $end_time );
		    $end_time[2] = '02';
	    } else {
		    $end_time = explode( ':', $end_time );
	    }

if ( strpos( $booking_form_data, 'durationtime' . $booking_type ) !== false ) {   // Get END TIME From form request
		    $pos1 = strpos( $booking_form_data, 'durationtime' . $booking_type );         // Find start time pos
		    $pos1 = strpos( $booking_form_data, '^', $pos1 ) + 1;                             // Find TIME pos
		    $pos2 = strpos( $booking_form_data, '~', $pos1 );                               // Find TIME length
		    if ( $pos2 === false ) {
			    $pos2 = strlen( $booking_form_data );
		    }
		    $pos2     = $pos2 - $pos1;
		    $end_time = substr( $booking_form_data, $pos1, $pos2 );

$is_time_exist = true;

$end_time = explode( ':', $end_time );

// Here we are get start time and add duration for end time
		    $new_end_time = mktime( intval( $start_time[0] ), intval( $start_time[1] ) );
		    $new_end_time = $new_end_time + $end_time[0] * 60 * 60 + $end_time[1] * 60;
		    $end_time     = gmdate( 'H:i', $new_end_time );

if ( $end_time == '00:00' ) {
			    $end_time = '23:59';
		    }
		    $end_time    = explode( ':', $end_time );
		    $end_time[2] = '02';
	    }

}

if ( $is_time_exist ) {
		return array( $start_time, $end_time );
	} else {
		return false;
	}
}

//FixIn: TimeFreeGenerator
	/**
	 * Convert timeslot "10:00 - 12:00" to  specfic timeformat,  like "10:00 AM - 12:00 PM"
	 * @param string $timeslot 		- "10:00 - 12:00"
	 * @param string $time_format	= "g:i A"
	 */
	function wpbc_time_slot_in_format( $timeslot, $time_format = false ){

// FixIn: 8.9.3.1.
		if ( ( empty( $timeslot ) ) ) {
			return '';
		}
		$value_times = explode( '-', $timeslot );
		$value_times[0] = trim( $value_times[0] );
		$value_times[1] = trim( $value_times[1] );

$s_tm = wpbc_time_localized( $value_times[0] , $time_format);
		$e_tm = wpbc_time_localized( $value_times[1] , $time_format);

$t_delimeter = ' - ';

return $s_tm . $t_delimeter . $e_tm ;
	}

//FixIn: 8.4.2.11       Deprecated, use this: wpbc_time_localized
	/**
	 * Convert timeslot "10:00" to  specfic timeformat,  like "10:00 AM"
	 * @param string $timeslot 		- "10:00"
	 * @param string $time_format	= "g:i A"
	 */
	function wpbc_time_in_format( $timeslot, $time_format = false ){

$s_tm = wpbc_time_localized( $timeslot, $time_format );
		return $s_tm;
	}

/**
	 * Get dates from DB of specific booking                -> '2023-10-09 12:00:01, 2023-10-09 20:00:02'
	 *
	 * @global type $wpdb
	 * @param  type $booking_id_str - booking ID
	 * @return string - comma separated dates in SQL format     -> '2023-10-09 12:00:01, 2023-10-09 20:00:02'
	 */
	function wpbc_db__get_sql_dates__in_booking__as_str( $booking_id_str ) {

global $wpdb;

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared
		$dates_result = $wpdb->get_results( "SELECT DISTINCT booking_date FROM {$wpdb->prefix}bookingdates WHERE booking_id IN ({$booking_id_str}) ORDER BY booking_date" );

$dates_str = array();

foreach ( $dates_result as $my_date ) {

$dates_str[] = $my_date->booking_date;
	    }
	    $dates_str = implode( ', ', $dates_str );

return $dates_str;
	}

/**
	 * Get Only Dates array   from  Dates Dimes string with  comma seperated values
	 *
	 * @param $dates_ymd_his_csv        -> '2023-10-09 12:00:01, 2023-10-09 20:00:02'
	 *
	 * @return array|string[]           -> '2023-10-09, 2023-10-09'
	 *
	 *
	 * Usually it called like in this Example:
	 *                                          $dates_ymd_his_csv = wpbc_db__get_sql_dates__in_booking__as_str( $booking_id_str );                 // '100' | '10,7' - booking ID
	 *                                          $dates_only_arr    = wpbc_get_only_dates__from_dates_ymd_his_csv__as_arr( $dates_ymd_his_csv );     // -> '2023-10-09, 2023-10-09'
	 */
	function wpbc_get_only_dates__from_dates_ymd_his_csv__as_arr( $dates_ymd_his_csv ){

// FixIn: 10.1.5.6.
		$dates_only_arr = wpbc_get_dates_arr__from_dates_comma_separated( array(
																				'dates_separator' => ', ',                  //  ', '
																				'dates'           => $dates_ymd_his_csv,    	// '2023-04-04 12:03:00, 2023-04-07 2024-06-30:00'
																			) );
		// Get Only Dates
		$dates_only_arr =  array_map(	function ( $date_sql_ymd_his ) {
											$date_sql_ymd_his = trim( $date_sql_ymd_his );
											$date_sql_ymd_his = substr( $date_sql_ymd_his, 0, 10 );
											return $date_sql_ymd_his;
										}
										, $dates_only_arr
									);
		$dates_only_arr = array_unique( $dates_only_arr );
		return $dates_only_arr;
	}

/**
		 * Get Time in 24 hours (military) format,  from  possible AM/PM format
	 *
	 * @param string $time_str  - '01:20 PM'
	 * @return string           - '13:20'
	 */
	function wpbc_get_time_in_24_hours_format( $time_str ) {

$time_str = trim( $time_str );
	    $time_str_plus = 0;

if ( strpos( strtolower( $time_str) ,'am' ) !== false ) {
	        $time_str = str_replace('am', '',  $time_str );
	        $time_str = str_replace('AM', '',  $time_str );
	    }

if ( strpos( strtolower( $time_str) ,'pm' ) !== false ) {
	        $time_str = str_replace('pm', '',  $time_str );
	        $time_str = str_replace('PM', '',  $time_str );
	        $time_str_plus = 12;
	    }

$time_str = explode( ':', trim( $time_str ) );
		// FixIn: 9.9.0.4.
		$time_str[0] = intval( $time_str[0] ) + $time_str_plus;
		$time_str[1] = intval( $time_str[1] );

if ($time_str[0] < 10 ) $time_str[0] = '0' . $time_str[0];
	 if ($time_str[1] < 10 ) $time_str[1] = '0' . $time_str[1];

return $time_str;
	}

/**
	 * Get number of days between 2 dates (dates in mySQL format)
	 *
	 * @param string $day1 - Day  in MySQL format
	 * @param string $day2 - Day  in MySQL format
	 *
	 * @return int - number of days
	 */
	function wpbc_get_difference_in_days( $day1, $day2 ) {
		return floor( ( strtotime( $day1 ) - strtotime( $day2 ) ) / 86400 );        // FixIn: 8.2.1.11.
	}

/**
	 * Get sorted sql dates array, like:  [ '2023-10-18 00:00:00', '2023-10-19 00:00:00', '2023-10-20 00:00:00' ]
	 *
	 * @param string $booking_days  '19.10.2023,18.10.2023,20.10.2023'                                      - comma separated dates:
	 * @return array -              [ '2023-10-18 00:00:00', '2023-10-19 00:00:00', '2023-10-20 00:00:00' ]      - sorted dates array
	 */
	function wpbc_get_sorted_days_array( $booking_days ) {

if ( strpos($booking_days,' - ') !== false ) {
	        $booking_days = explode(' - ', $booking_days );
	        $booking_days = wpbc_get_comma_seprated_dates_from_to_day($booking_days[0],$booking_days[1]);
	    }

$days_array = explode(',', $booking_days);
	    $only_days  = array();

foreach ($days_array as $new_day) {
	        if ( ! empty( $new_day ) ) {
	            $new_day = trim( $new_day );
	            if ( strpos( $new_day, '.' ) !== false ) $new_day = explode('.',$new_day);
	            else                                     $new_day = explode('-',$new_day);
	            $only_days[] = $new_day[2] .'-' . $new_day[1] .'-' . $new_day[0] . ' 00:00:00';
	        }
	    }

if ( ! empty( $only_days ) ) {
	        sort($only_days);
	    }

return $only_days;
	}

/**
	 * Get Dates in Comma seperated format, based on start and end dates.
 * 
 * @param string $date_str_from - start date: 06.04.2015
 * @param string $date_str_to   - end date:   08.04.2015 
 * @return string               - comma seperated dates: 06.04.2015, 07.04.2015, 08.04.2015
 */
function wpbc_get_comma_seprated_dates_from_to_day( $date_str_from, $date_str_to ) {
    
    $date_str_from = explode('.', $date_str_from);
    $date_str_to   = explode('.', $date_str_to);
	$iDateFrom = mktime( 1, 0, 0, ( intval( $date_str_from[1] ) ), ( intval( $date_str_from[0] ) ), ( intval( $date_str_from[2] ) ) );
	$iDateTo   = mktime( 1, 0, 0, ( intval(   $date_str_to[1] ) ), (   intval( $date_str_to[0] ) ), (   intval( $date_str_to[2] ) ) );
    
    $aryRange=array();
    
    if ( $iDateTo >= $iDateFrom ) {
        array_push( $aryRange, gmdate( 'd.m.Y', $iDateFrom ) );                   // first entry

while ($iDateFrom<$iDateTo) {
 $iDateFrom+=86400; // add 24 hours
 array_push( $aryRange, gmdate( 'd.m.Y', $iDateFrom ) );
 }
 }
 
 $aryRange = implode(', ', $aryRange);
 
 return $aryRange;
}

/**
	 * Get dates array based on start and end dates.
 * 
 * @param string $sStartDate - start date: 2015-04-06
 * @param string $sEndDate   - end date:   2015-04-08 
 * @return array             - array( 2015-04-06, 2015-04-07, 2015-04-08 )   
 */
function wpbc_get_dates_array_from_start_end_days( $sStartDate, $sEndDate ){
    // Firstly, format the provided dates.
    // This function works best with YYYY-MM-DD
    // but other date formats will work thanks
    // to strtotime().
    $sStartDate = gmdate("Y-m-d", strtotime($sStartDate));
    $sEndDate = gmdate("Y-m-d", strtotime($sEndDate));

// Start the variable off with the start date 
    $aDays[] = $sStartDate;

// Set a 'temp' variable, sCurrentDate, with
    // the start date - before beginning the loop
    $sCurrentDate = $sStartDate;

// While the current date is less than the end date
 while($sCurrentDate < $sEndDate){
 // Add a day to the current date
 $sCurrentDate = gmdate("Y-m-d", strtotime("+1 day", strtotime($sCurrentDate)));

// Add this new day to the aDays array
        $aDays[] = $sCurrentDate;
    }
    // Once the loop has finished, return the
    // array of days.
    return $aDays;
}

/**
 * Get dates array,  from range days selection
 *
 * @param $params       = array(
									* 'dates_separator' => ' ~ ',                         // Dates separator
									* 'dates'           => '2023-04-04 ~ 2023-04-07'      // Dates in 'Y-m-d' format: '2023-01-31'
								* )
 *
 * @return array        = array(
								    * [0] => 2023-04-04
								    * [1] => 2023-04-05
								    * [2] => 2023-04-06
								    * [3] => 2023-04-07
								* )
 *
 * Example #1:  wpbc_get_dates_arr__from_dates_range(  array(  'dates_separator' => ' ~ ', 'dates' => '2023-04-04 ~ 2023-04-07'  )  );
 * Example #2:  wpbc_get_dates_arr__from_dates_range(  array(  'dates_separator' => ' - ', 'dates' => '2023-04-04 - 2023-04-07'  )  );
 */
function wpbc_get_dates_arr__from_dates_range( $params ){

$defaults = array(
		'dates_separator' => ' ~ ',                 //  ' ~ '
		'dates'           => '',                    // '2023-04-04 ~ 2023-04-07'
	);
	$params   = wp_parse_args( $params, $defaults );

$dates_arr = array();

if ( ! empty( $params['dates'] ) ) {

list( $check_in_date_ymd, $check_out_date_ymd ) = explode( $params['dates_separator'], $params['dates'] );

if ( ( ! empty( $check_in_date_ymd ) ) && ( ! empty( $check_out_date_ymd ) ) ) {

$dates_arr = wpbc_get_dates_array_from_start_end_days( $check_in_date_ymd, $check_out_date_ymd );
		}
	}
	return $dates_arr;
}

/**
 * Get dates array,  from comma separated dates
 *
 * @param $params       = array(
									* 'dates_separator' => ', ',                                        // Dates separator
									* 'dates'           => '2023-04-04, 2023-04-07, 2023-04-05'         // Dates in 'Y-m-d' format: '2023-01-31'
								* )
 *
 * @return array        = array(
								    * [0] => 2023-04-04
								    * [1] => 2023-04-05
								    * [2] => 2023-04-06
								    * [3] => 2023-04-07
								* )
 *
 * Example #1:  wpbc_get_dates_arr__from_dates_comma_separated(  array(  'dates_separator' => ', ', 'dates' => '2023-04-04, 2023-04-07, 2023-04-05'  )  );
 */
function wpbc_get_dates_arr__from_dates_comma_separated( $params ){

$defaults = array(
		'dates_separator' => ', ',                 //  ' ~ '
		'dates'           => '',                    // ''2023-04-04, 2023-04-07, 2023-04-05'
	);
	$params   = wp_parse_args( $params, $defaults );

$dates_arr = array();

if ( ! empty( $params['dates'] ) ) {

$dates_arr = explode( $params['dates_separator'], $params['dates'] );

sort( $dates_arr );
	}
	return $dates_arr;
}

/**
	 * Get tommorow day from  input value
 * 
 * @param string $nowday    : 2015-02-29
 * @return int              : Unix timestamp for a date like this 2015-02-30
 */
function wpbc_get_tommorow_day( $nowday ){

$nowday_d = gmdate( 'm.d.Y', mysql2date( 'U', $nowday ) );
    $previos_array = explode( '.', $nowday_d );
    $tommorow_day = mktime( 0, 0, 0, intval($previos_array[0]), ( intval($previos_array[1]) + 1 ), intval($previos_array[2]) ) ;
    return $tommorow_day;
}

/**
	 * Check if this date is today day
 * 
 * @param string $some_day  : '2015-05-29'
 * @return boolean          : true | false
 */
function wpbc_is_today_date( $some_day ) {

$some_day_d = gmdate( 'm.d.Y',  mysql2date( 'U', $some_day ) );
    $today_day = gmdate( 'm.d.Y' );

if ( $today_day == $some_day_d ) {
		return true;
	} else {
		return false;
	}
}

/**
 * Check if this date is Tomorrow day
 *
 * @param string $some_day  : '2024-08-18'
 * @return boolean          : true | false
 */
function wpbc_is_tomorrow_date( $some_day ) {

$some_day_d   = gmdate( 'Y-m-d 00:00:00', mysql2date( 'U', $some_day ) );
	$today_day    = gmdate( 'Y-m-d 00:00:00' );
	$tomorrow_day = gmdate( 'Y-m-d 00:00:00', strtotime( '+1 day', strtotime( $today_day ) ) );

if ( $tomorrow_day == $some_day_d ) {
		return true;
	} else {
		return false;
	}
}

// FixIn: 8.8.1.2.
/**
 * Check if this date in past
 *
 * @param string $some_day  : '2015-05-29'
 * @return boolean          : true | false
 */
function wpbc_is_date_in_past( $some_day ) {

$some_day_d = gmdate( 'm.d.Y', mysql2date( 'U', $some_day ) );
	$some_array = explode( '.', $some_day_d );
	$some_day   = mktime( 0, 0, 0, intval($some_array[0]), ( intval($some_array[1]) + 1 ), intval($some_array[2]) );

$today_day = time();

if ( $today_day > $some_day ) {
		return true;
	} else {
		return false;
	}
}

//TODO: refactor it,  by  replacig date_i18n to wp_loc_date... (check depndencies of this function in other usage functions...)
/**
	 * Change date / time format
 * 
 * @param string $dt        - MySQL Date - '2015-11-21 00:00:00'
 * @param type $date_format - Optional. Date format
 * @param type $time_format - Optional. Time format
 * @return array( 'DATE in custom Format', 'TIME in custom Format' )
 */
function wpbc_get_date_in_correct_format( $dt, $date_format = false, $time_format = false ) {

if ( $date_format === false )   $date_format = get_bk_option( 'booking_date_format');
    if ( empty( $date_format ) )    $date_format = "m / d / Y, D";
    
    if ( $time_format === false )   $time_format = get_bk_option( 'booking_time_format');        
    if ( empty( $time_format ) )    $time_format = get_option( 'time_format' );       //'h:i a';                        //FixIn:  TimeFree 2    -  in Booking Calendar Free version  show by  default times hints in AM/PM format
    
    $my_time = gmdate( 'H:i:s' , mysql2date( 'U', $dt ) );
    if ( $my_time == '00:00:00' )   $time_format = '';
    
    $bk_date = date_i18n( $date_format, mysql2date( 'U', $dt ) );
    $bk_time = date_i18n( ' ' . $time_format  , mysql2date( 'U', $dt ) );
    
    if ( $bk_time == ' ' ) $bk_time = '';

return array($bk_date, $bk_time);
}

/**
	 * Get SHORT Dates showing data
 * 
 * @param array $bk_dates_short - Array of dates
 * @param bool $is_approved - is dates approved or not
 * @param type $bk_dates_short_id
 * @param type $booking_types
 * @return string
 */ 
function wpbc_get_short_dates_formated_to_show( $bk_dates_short, $is_approved = false, $bk_dates_short_id = array() , $booking_types = array() ){
 
 $short_dates_content = '';
 $dcnt = 0;
 foreach ( $bk_dates_short as $dt ) {
 if ( $dt == '-' ) {
 $short_dates_content .= ' - ';
 } elseif ( $dt == ',' ) {
 $short_dates_content .= ', ';
 } else {
 $short_dates_content .= '<a href="javascript:void(0)" class="field-booking-date label flex-label ';
 if ( $is_approved )
 $short_dates_content .= ' approved';
 $short_dates_content .= '">';

$bk_date = wpbc_get_date_in_correct_format( $dt );
 $short_dates_content .= $bk_date[0];
 $short_dates_content .= '' . $bk_date[1] . '';
 
 if ( class_exists( 'wpdev_bk_biz_l' ) ) { // BL
 if ( ( !empty( $bk_dates_short_id[$dcnt] ) ) && ( isset( $booking_types[$bk_dates_short_id[$dcnt]] ) ) ){
 $bk_booking_type_name_date = $booking_types[$bk_dates_short_id[$dcnt]]->title; // Default
 
 if ( strlen( $bk_booking_type_name_date ) > 19 )
 $bk_booking_type_name_date = substr( $bk_booking_type_name_date, 0, 13 ) 
 . '...' 
 . substr( $bk_booking_type_name_date, -3 );

$short_dates_content .= ' ' . $bk_booking_type_name_date . '';
 }
 }
 $short_dates_content .= '</a>';
 }
 $dcnt++;
 }
 return $short_dates_content; 
}

// FixIn: 9.6.3.5.

/**
 * Get booking dates from DB for specific calendar
 *
 * @param array $params         array(
					                  'approved'    => ''                           // '' - all | '0' - pending | '1' - approved
									, 'resource_id' => 1                            // int or dcv
									, 'skip_booking_id' => ''                       // int or dcv

)
 *
 * @return array                array(  [1-7-2023] => array(
												                [sec_0] => stdClass Object
														                (
														                    [booking_date] => 2023-01-07 00:00:00
														                    [approved] => 0
														                    [booking_id] => 96
														                )

)
									    [1-8-2023] => Array(
													            [sec_0] => stdClass Object
														                (
														                    [booking_date] => 2023-01-08 00:00:00
														                    [approved] => 0
														                    [booking_id] => 42
														                )
									                        )
							             ...

*/
function wpbc__sql__get_booked_dates( $params ){

$defaults = array(
	                  'approved'    => ''                           // '' - all | '0' - pending | '1' - approved
					, 'resource_id' => 1                            // int or dcv
					, 'skip_booking_id' => ''                       // int or dcv
				);
	$params   = wp_parse_args( $params, $defaults );

// S a n i t i z e
	$params['approved']        = ( '' != $params['approved'] )          ? intval( $params['approved'] )                             : '';
	$params['skip_booking_id'] = ( '' != $params['skip_booking_id'] )   ? wpbc_sanitize_digit_or_csd( $params['skip_booking_id'] )  : '';
	$params['resource_id']     = ( '' != $params['resource_id'] )       ? wpbc_sanitize_digit_or_csd( $params['resource_id'] )      : 1;

// S Q L
	global $wpdb;
	$sql = "SELECT DISTINCT dt.booking_date, dt.approved, bk.booking_id

FROM {$wpdb->prefix}bookingdates as dt

INNER JOIN {$wpdb->prefix}booking as bk
	
				ON  bk.booking_id = dt.booking_id

WHERE ( 1 = 1 )";

// W H E R E
	$sql_where  = '';
	$sql_where .= ( '' != $params['approved'] ) ? " AND ( dt.approved = {$params['approved']} ) " : '';                 // Approved (1) or Pending (0) or All       // int
	$sql_where .= " AND dt.booking_date >= " . wpbc_sql_date_math_expr_explicit('', 'curdate') . " ";                                                                 // Only actual bookings
	$sql_where .= " AND bk.trash != 1 ";                                                                                // Not in Trash                             // int
	$sql_where .= " AND bk.booking_type IN ( {$params['resource_id']} ) ";                                              // For specific calendar (booking resource) // int
	$sql_where .= ( '' != $params['skip_booking_id'] ) ? " AND dt.booking_id NOT IN ( {$params['skip_booking_id']} ) " : '' ;   // Skip  some bookings ?  Usually, during booking edit.

// O R D E R
    $sql_order = " ORDER BY dt.booking_date";                                                                           // Order by booking dates & times

/**
	 * Array(   [0] => stdClass Object ( [booking_date] => 2022-12-27 00:00:00,  [approved] => 0,  [booking_id] => 187 )
                [1] => stdClass Object ( [booking_date] => 2022-12-28 00:00:00,  [approved] => 1,  [booking_id] => 26 )
	            ...
	 */

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared
	$result_arr = $wpdb->get_results( $sql . $sql_where . $sql_order );

// P A R S E
	$prior_check_out_date = false;
	$dates_arr = array();
	foreach ( $result_arr as $sql_date ) {

$blocked_days_range = array( $sql_date->booking_date );
		$resource_id = explode( ',', $params['resource_id'] );
		$resource_id = $resource_id[0];
        if (
				( ! class_exists( 'wpdev_bk_biz_l' ) )
             || ( ( class_exists( 'wpdev_bk_biz_l' ) ) && ( ! wpbc_is_this_parent_resource( $resource_id ) ) )
        ){                                                                                                      // FixIn: 9.1.2.7.
            list( $blocked_days_range, $prior_check_out_date ) = apply_filters( 'wpbc_get_extended_block_dates_filter', array( $blocked_days_range, $prior_check_out_date ) );
		}

foreach ( $blocked_days_range as $date_ymd_his ) {

$sql_date->booking_date = $date_ymd_his;

$date_as_int = strtotime( $sql_date->booking_date );

$date_key = gmdate( 'Y-m-d', $date_as_int );
				$date_seconds = $date_as_int - strtotime( $date_key );

// Transform '2022-09-01' to  9-1-2022
				$date_key__for_calendar = gmdate( 'n-j-Y', $date_as_int );                    // j -	Day of the month without leading zeros 	1 to 31 ;      n -	Number of month, without leading zeros 	1 to 12

if ( empty( $dates_arr[ $date_key__for_calendar ] ) ) {
					$dates_arr[ $date_key__for_calendar ] = array();
				}

/**
				 *  Important info about  [ 'sec_' . $date_seconds ]
				 *
				 *  We need to have 'sec_0' instead of simple 0
				 *
				 *  for having JavaScript Objects (object property  'sec_o') instead of Array (index 0),  after  sending Ajax response and JSON decode!
				 */
				$dates_arr[ $date_key__for_calendar ][ 'sec_' . $date_seconds] = $sql_date;
		}

}

return $dates_arr;
}

/**
	 * Get season availability based on booking resource and seasons from Booking > Resources > Availability page
	 *
	 * @param array $params array(
				                      'resource_id' => 1                            // int or dcv
									, 'from' => 'NOW'                               // any  value that  is possible to  use in strtotime()
									, 'count'  => 365                               // int
								)
	 *
	 * @return array Array (
					    [2023-01-09] => 1
					    [2023-01-10] => 1
					    [2023-01-11] => 1
					    [2023-01-12] => 1
					    [2023-01-13] => 1
					    [2023-01-14] =>
					    [2023-01-15] =>
					    [2023-01-16] => 1
					    [2023-01-17] => 1
					    [2023-01-18] => 1
					    [2023-01-19] => 1
					    ...
	 */
	function wpbc__sql__get_season_availability( $params ){

// FixIn: 9.5.4.4.
		$max_days_count = 365;
		$max_monthes_in_calendar = get_bk_option( 'booking_max_monthes_in_calendar' );

if ( strpos( $max_monthes_in_calendar, 'm' ) !== false ) {
			$max_days_count = intval( str_replace( 'm', '', $max_monthes_in_calendar ) ) * 31 + 5;                          // FixIn: 9.6.1.1.
		} else {
			$max_days_count = intval( str_replace( 'y', '', $max_monthes_in_calendar ) ) * 365 + 15;                        // FixIn: 9.6.1.1.
		}

$defaults = array(
	                      'resource_id' => 1                            // int or dcv
						, 'from' => 'NOW'                               // any  value that  is possible to  use in strtotime()
						, 'count'  => $max_days_count                   // int
					);
		$params   = wp_parse_args( $params, $defaults );

// S a n i t i z e
		$params['resource_id']     = ( '' != $params['resource_id'] )       ? wpbc_sanitize_digit_or_csd( $params['resource_id'] )      : 1;

$is_all_days_available = true;

$season_filters_id_arr = array();

if ( ( class_exists( 'wpdev_bk_biz_m' ) ) && ( function_exists( 'wpbc_get_resource_meta' ) ) ) {                // BM and higher        // FixIn: 9.9.0.13.

// S Q L
			$availability_res = wpbc_get_resource_meta( $params['resource_id'], 'availability' );

if ( ! empty( $availability_res ) ) {

/**
				 * Array (    [general] => On,    [filter] => Array (        [1] => On, ...
				 * [2] => Off
				 * ...
				 * [8] => Off
				 * [9] => On
				 * )
				 * )
				 */
				$availability = maybe_unserialize( $availability_res[0]->value );

$is_all_days_available = ( 'On' === $availability['general'] ) ? true : false;
				$season_filter         = $availability['filter'];

// Get ID of only activated Seasons
				if ( is_array( $season_filter ) ) {
					foreach ( $season_filter as $key => $value ) {
						if ( $value == 'On' ) {
							$season_filters_id_arr[] = intval( $key );          // Sanitize booking_filter_id for future SQL
						}
					}
				}

}

$days_availability = array();

for( $i = 0; $i < $params['count']; $i++) {

$date_y_m_d = gmdate( 'Y-m-d', strtotime( '+' . $i . 'days', strtotime( $params['from'] ) ) );

$days_availability[ $date_y_m_d ] = $is_all_days_available;

$date_arr = explode( '-', $date_y_m_d );

foreach ( $season_filters_id_arr as $filter_id ) {

$day   = intval( $date_arr[2] );
				$month = intval( $date_arr[1] );
				$year  = intval( $date_arr[0] );

if ( wpbc_is_day_inside_of_filter( $day, $month, $year, $filter_id ) ){
					$days_availability[ $date_y_m_d ] = ! $days_availability[ $date_y_m_d ];
					break;
				}
			}

}

return $days_availability;
	}

Back