# booking-manager/2.1.21/core/wpbc/wpbm-bc-import.php

Booking Manager – Sync WP Booking Calendar – Import Events, Export Bookings to ICS Calendar, version 2.1.21. 1,500 lines.

- Page: https://pluginprobe.com/plugins/booking-manager/2.1.21/code/core/wpbc/wpbm-bc-import.php
- Raw: https://pluginprobe.com/plugins/booking-manager/2.1.21/raw/core/wpbc/wpbm-bc-import.php
- Modified: 2026-09-15T12:44:28+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/booking-manager/2.1.21/code/core/wpbc/wpbm-bc-import.php#L10-L20`.

```php
<?php 
/**
 * @version 1.0
 * @description Booking Calendar integration - Import bookings from ICS events
 * 
 * @author wpdevelop
 * @link https://oplugins.com/
 * @email info@oplugins.com
 *
 * @modified 2017-06-28
 */

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


/**
 * Move All imported bookings into the Trash
 *
 * @return bool
 */
function wpbm_delete_all_imported_bookings( $params ){		//FixIn: 2.0.10.3

	$booking_ics_force_trash_before_import = get_bk_option( 'booking_ics_force_trash_before_import' );    //FixIn: 2.0.10.1	<- available in Booking Calendar since update 2.0.10

	if ( 'Off' == $booking_ics_force_trash_before_import ) {
		return false;
	}

	global $wpdb;

	$resource_id = $params['resource_id'];
	$is_trash    = 1;

	//FixIn: 2.0.24.1		//FixIn: 9.1.2.6
	if (
			( 'On' == $booking_ics_force_trash_before_import )
		 || ( 'trash' == $booking_ics_force_trash_before_import )
	) {
		// Trash bookings
		$my_sql = "UPDATE {$wpdb->prefix}booking AS bk SET bk.trash = {$is_trash} WHERE sync_gid != '' AND trash != 1 AND booking_type = {$resource_id}";

		if ( false === $wpdb->query( $my_sql ) ) {
			?> <script type="text/javascript"> var my_message = '<?php echo html_entity_decode( esc_js( get_debuge_error( 'Error during trash booking in DB', __FILE__, __LINE__ ) ), ENT_QUOTES ); ?>'; wpbc_admin_show_message( my_message, 'error', 30000 ); </script> <?php
			return false;
		}

	} else { // Permanently delete bookings

		$bookings_obj_arr = $wpdb->get_results( "SELECT booking_id as ID FROM {$wpdb->prefix}booking WHERE sync_gid != '' AND trash != 1 AND booking_type = {$resource_id} LIMIT 0, 1000" );

			$id_arr = array();
			foreach ( $bookings_obj_arr as $booking_obj ) {
				$id_arr[] = $booking_obj->ID;
			}
			$string_id = implode( ',', $id_arr );

		if ( $string_id != '' ) {

			// D E L E T E     Dates
			if ( false === $wpdb->query( "DELETE FROM {$wpdb->prefix}bookingdates WHERE booking_id IN ({$string_id})"  ) ) { ?> <script type="text/javascript"> document.getElementById('ajax_working').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php debuge_error('Error during updating exist booking for deleting dates in BD' ,__FILE__,__LINE__); ?></div>'; </script> <?php die(); }
			// D E L E T E     Bookings
			if ( false === $wpdb->query( "DELETE FROM {$wpdb->prefix}booking WHERE booking_id IN ({$string_id})" ) ){ ?> <script type="text/javascript"> document.getElementById('ajax_working').innerHTML = '<div style=&quot;height:20px;width:100%;text-align:center;margin:15px auto;&quot;><?php debuge_error('Error during deleting booking at DB',__FILE__,__LINE__ ); ?></div>'; </script> <?php die(); }
		}

	}

	return true;
}


/**
 * Append one extra day after the currently last imported booking date.
 *
 * This is an opt-in extension for sites that want to block one additional day
 * after the imported iCalendar checkout boundary.
 *
 * @param array $booking_dates Dates in MySQL format.
 *
 * @return array
 */
function wpbm_ics_import_append_extra_checkout_day( $booking_dates ) {

	if ( empty( $booking_dates ) || ! is_array( $booking_dates ) ) {
		return $booking_dates;
	}

	$last_date = $booking_dates[ count( $booking_dates ) - 1 ];
	$last_date = strtotime( $last_date );
	$last_date = strtotime( '+1 day', $last_date );

	$booking_dates[] = date_i18n( 'Y-m-d H:i:s', $last_date );

	return $booking_dates;
}

////////////////////////////////////////////////////////////////////////////////////////////
// I M P O R T
////////////////////////////////////////////////////////////////////////////////////////////

/**	Import ICS feed and create bookings .in Booking Calendar
 *
 * @param array $attr = array(
								'url' => ''
							  , 'resource_id' => 1
							  , 'import_conditions' => '' | 'if_dates_free'				// maybe rename ???		if_dates_booked_then_not_import
							)
 * @return int|bool		number of imported bookings or FALSE if error
 */
function wpbm_ics_import_start( $attr ) {

	if ( ! wpbm_is_wpbc_supported() ) {
//		echo 'Booking Manager require Booking Calendar 9.8 or newer';
		return wpbm_ics_import_start_legacy( $attr );

	}

	//                                                                              <editor-fold   defaultstate="collapsed"   desc=" Parse / validate  parameters " >
	/////////////////////////////////////////////////////////////////////
	// Parse / validate  parameters
	/////////////////////////////////////////////////////////////////////
	$defaults = array(
						'url' => ''
					  , 'resource_id' => 1
					  , 'delete' => 0
					  , 'import_conditions' => ''
					  , 'from' => 'any'				// 'today'		// '00:00 today'
					  , 'from_offset' => ''
					  , 'until' => 'any'			// 'year-end'
					  , 'until_offset' => ''
					  , 'max' => ''
					  , 'is_all_dates_in' => true	// Conditional of Dates checking.  TRUE - Remove event if al least 1 day not in conditional interval,  FALSE - save event, if at leat one date in conditional interval
	);
	$shortcode = array();

	foreach ( $attr as $param_name => $param_value ) {

		switch ( $param_name) {							// Validate Params

			case 'url':
				$shortcode[ $param_name ] = esc_url_raw( $param_value );		// $shortcode[ 'url' ]
				$shortcode[ $param_name ] = str_replace( '&amp;', '&', $shortcode[ $param_name ] );    //FixIn: 2.0.14.2
				break;

			case 'import_conditions':
				$shortcode[ $param_name ] = esc_attr( $param_value );				// $shortcode[ 'resource_id' ]
				break;

			case 'resource_id':
				$shortcode[ $param_name ] = intval($param_value );				// $shortcode[ 'resource_id' ]
				break;

			case 'from':										// 'now', 'today', 'week', 'month-start', 'month-end', 'year-start', 'any', 'date' = 2017-08-07
				$shortcode[ $param_name ] = $param_value;
				break;

			case 'from_offset':									// 5d,  10h, 5m, 30s	--	if  from: { 'now', 'today', 'week', 'month-start', 'month-end', 'year-start' }
				$shortcode[ $param_name ] = $param_value;
				break;

			case 'until':										// 'now', 'today', 'week', 'month-start', 'month-end', 'year-end', 'any', 'date' = 2017-08-07
				$shortcode[ $param_name ] = $param_value;
				break;

			case 'until_offset':								// 5d,  10h, 5m, 30s	--	if  until: { 'now', 'today', 'week', 'month-start', 'month-end', 'year-end' }
				$shortcode[ $param_name ] = $param_value;
				break;

			case 'max':
				$shortcode[ $param_name ] = intval( $param_value );
				break;

			case 'is_all_dates_in':								// Conditional of Dates checking.  TRUE - Remove event if al least 1 day not in conditional interval,  FALSE - save event, if at leat one date in conditional interval
				$shortcode[ $param_name ] = intval( $param_value );
				break;


			default:
				$shortcode[ $param_name ] = $param_value;
				break;
		}
	}
	$shortcode = wp_parse_args( $shortcode, $defaults );
	//                                                                              </editor-fold>

	//                                                                              <editor-fold   defaultstate="collapsed"   desc=" Notice - Import Parameters  |  Error No URL" >

	do_action( 'wpbc_show_debug', array( 'Import Parameters' , $shortcode ) );											//  S_Y_S_T_E_M    L_O_G

	if ( empty( $shortcode[ 'url' ] ) ) {
		do_action( 'wpbc_admin_show_top_notice', __( 'No ics url feed', 'booking-manager' ), 'error', 5000 );					// N_O_T_I_C_E  in  H_E_A_D_E_R
		return  false;
	}
	//                                                                              </editor-fold>

	/////////////////////////////////////////////////////////////////////	-	Get, Parse ICS Feed

	$ics_array = wpbm_ics_file_to_array( $shortcode[ 'url' ] );

	//                                                                              <editor-fold   defaultstate="collapsed"   desc=" Notice - feed contain N events  |  Error Importing " >
	do_action( 'wpbc_show_debug', array( 'Imported data' , $ics_array) );												//  S_Y_S_T_E_M    L_O_G

	// If Error
	if ( is_wp_error( $ics_array ) ) {

		$error_message = $ics_array->get_error_message();
		do_action( 'wpbc_admin_show_top_notice', $error_message, 'error', 5000 );										// N_O_T_I_C_E  in  H_E_A_D_E_R
		return  false;
	}

	//FixIn: 2.0.7.3
	$ics_array_events_num = 0;
	if (  ( ! empty( $ics_array  ) )  &&   ( ! empty( $ics_array[ 'events' ]  ) )  &&   ( is_array( $ics_array[ 'events' ]  ) )  ) {
		$ics_array_events_num = count( $ics_array[ 'events' ] );
	}
	do_action( 'wpbc_admin_show_top_notice'																				// N_O_T_I_C_E  in  H_E_A_D_E_R
			, sprintf ( __( '.ics feed contain %s events at URL %s', 'booking-manager' ), '<b>' . $ics_array_events_num . '</b>', '<b><a href="'. $shortcode[ 'url' ] .'">' . $shortcode[ 'url' ] . '</a></b>' )
			, 'info', 5000 );
	//                                                                              </editor-fold>

	if ( 'skip' != $shortcode['delete'] ) {
		wpbm_delete_all_imported_bookings( array( 'resource_id' => $shortcode['resource_id'] ) );		//FixIn: 2.0.18.3		//FixIn: 2.0.10.3
	}


	$bk_array = array();
	// Get Only '_BOOKING...' field from  ICS array
	if ( $ics_array !== false ) {
		$bk_array = wpbm_get_booking_fields_from_ics_array( $ics_array[ 'events' ] );
	}

	do_action( 'wpbc_show_debug', array( 'Imported Events', $bk_array ) );												//  S_Y_S_T_E_M    L_O_G


	//FixIn: 2.0.6.1 - Set timezone frrom  Booking > Settings > Sync  page for booking listing shortcode
	$tzid = get_bk_option( 'booking_gcal_timezone' );
	if ( ! empty( $tzid ) ) {
		foreach ( $bk_array as $bk_k => $bk_ics_data_arr ) {


			//apply  our timezone from  the Booking > Settings > Search page
			foreach ( $bk_array[ $bk_k ]['_BOOKING_DATES'] as $dk => $day ) {
				//$bk_array[ $bk_k ][ '_BOOKING_DATES' ][ $dk ]  = ZDateHelper::toLocalDateTime( get_gmt_from_date( $day ), $tzid );

				//FixIn: 2.0.7.4	-	Skip adding Timezone to "middle" days,  if days start with  time 00:00:00 - its means event for full day, not the start/end time
				// 						Apply  timezone only to fist and last days in a list, if the change over days activated in the Booking Calendar
				$ics_time_in_day = substr( $day, -8);
				if ( '00:00:00' == $ics_time_in_day ) {
					continue;
				}
				//FixIn: 2.0.7.4	-	Skip adding Timezone to "middle" days, if Booking Calendar use change over days, to prevent of having clock icon in middle days.
				if ( 	( class_exists( 'wpdev_bk_biz_s' ) )
					 && ( get_bk_option( 'booking_range_selection_time_is_active')  == 'On' )
					 && ( get_bk_option( 'booking_ics_import_add_change_over_time' )  !== 'Off' )
				) {    //FixIn: 2.0.5.1
					$days_number = count( $bk_array[ $bk_k ]['_BOOKING_DATES'] );
					if ( ( 0 != $dk ) && ( ( $days_number - 1) != $dk )  ) {
						continue;
					}
					// We are append one day  to  the booking,  so  skip this day  for timezone,  as well
					if ( ( get_bk_option( 'booking_ics_import_append_checkout_day' ) !== 'Off' )  && ( ( $days_number - 1) == $dk )  ) {
						continue;
					}
				}

				$bk_array[ $bk_k ]['_BOOKING_DATES'][ $dk ] = ZDateHelper::toLocalDateTime( $day, $tzid );
			}
		}
	}

	/////////////////////////////////////////////////////////////////////	-	Check if these EVENTS was imported before or NOT

	$booking_ics_force_import = get_bk_option( 'booking_ics_force_import' );    //FixIn: 2.0.10.1
	$booking_condition_import_only_new = get_bk_option( 'booking_condition_import_only_new' );        //FixIn: 9.8.15.8
	if ( false === $booking_condition_import_only_new ) {
		// OLD:
		if ( 'On' !== $booking_ics_force_import ) {
			$bk_array = wpbm_clear_events_from_exist_bookings( $bk_array );
		}
	} else {
		// NEW
		if ( 'On' === $booking_condition_import_only_new ) {
			$bk_array = wpbm_clear_events_from_exist_bookings( $bk_array );
		}
	}


	//                                                                              <editor-fold   defaultstate="collapsed"   desc=" Notice - if events was imported previously  |  Already ALL Imported " >
	do_action( 'wpbc_show_debug', array( 'Check, if events was imported previously. New events: ', $bk_array ) );		//  S_Y_S_T_E_M    L_O_G

	if ( empty( $bk_array ) ) {

		do_action( 'wpbc_admin_show_top_notice'																			// N_O_T_I_C_E  in  H_E_A_D_E_R
			, '<strong>' . __( 'Warning', 'booking' ) . '!</strong> '
			  . sprintf( __( 'No any new events to import! These events was import previously, already.', 'booking-manager' ), '<strong>' . count( $bk_array ) . '</strong>' )
			, 'warning', 3000 );
		return 0;
	}
	//                                                                              </editor-fold>


	/////////////////////////////////////////////////////////////////////	-	Skip events that  does not fit to filter parameters: FROM - UNTIL

	// Sort Events
	$bk_array = wpbm_sort_events_by( $bk_array );

	// Filter By Dates		-	"From - Until"
	$bk_array = wpbm_clear_events_by_dates( $bk_array, $shortcode );

	// Filter events by		-	"Max"
	$bk_array = wpbm_clear_events_by_count( $bk_array, $shortcode );


	//                                                                              <editor-fold   defaultstate="collapsed"   desc=" Notice - Creation of N bookings " >
	do_action( 'wpbc_admin_show_top_notice'																				// N_O_T_I_C_E  in  H_E_A_D_E_R
			, sprintf( __( 'Imported of %s bookings', 'booking-manager' ), '<strong>' . count( $bk_array ) . '</strong>' )
			, 'info', 3000 );

	do_action( 'wpbc_show_debug', array( 'Create bookings after filtering', $bk_array ) );								//  S_Y_S_T_E_M    L_O_G
	//                                                                              </editor-fold>

	/////////////////////////////////////////////////////////////////////	-	Loop events  >  C r e a t e    B o o k i n g s

	// Get assigning fields  for  SUMMARY, DESCRIPTION, LOCATION
	$assigned_fields_arr = WPBM_create_bookings_from_events::get_assigned_form_fields();

	$booking_added_num = 0;

	foreach ( $bk_array as $ics_event) {

		//FixIn: 2.1.3
		if (
			   ( 'On' == get_bk_option( 'booking_ics_import_append_checkout_day' ) )
			|| (
					( class_exists( 'wpdev_bk_biz_s' ) )
				 && ( get_bk_option( 'booking_range_selection_time_is_active')  == 'On' )
				 && ( get_bk_option( 'booking_ics_import_add_change_over_time' )  !== 'Off' )
				 && ( count( $ics_event[ '_BOOKING_DATES' ] ) == 1 )
			   )
		) {                                      //FixIn: 2.0.27.1		//FixIn: 9.5.4.1
			// Add one additional  day  to .ics event (useful in some cases for bookings with  change-over days),  if the imported .ics dates is coming without check  in/our times
			// Later system is adding check  in/out times from  Booking Calendar to  this event
			$ics_event_check_out = $ics_event['_BOOKING_DATES'][ ( count( $ics_event['_BOOKING_DATES'] ) - 1 ) ];

			//FixIn Start: 2.0.28.1 ------------------------------------------------------------------------------------
			// Is check in/out dates in this event it's the same date
			$test_check_in  = substr( $ics_event['_BOOKING_DATES'][0], 0, 10 );
			$test_check_out = substr( $ics_event['_BOOKING_DATES'][ ( count( $ics_event['_BOOKING_DATES'] ) - 1 ) ], 0, 10 );
			if ( count( $ics_event['_BOOKING_DATES'] ) > 1 ) {		//FixIn: 2.1.3
				if ( $test_check_in === $test_check_out ) {
					// It is the same date, like 2024-02-12 10:00:01, 2024-02-12 14:59:52, then remove this date, because we will add new date
					unset( $ics_event['_BOOKING_DATES'][ ( count( $ics_event['_BOOKING_DATES'] ) - 1 ) ] );
					// Important! Reindex array, after unset operation.
					$ics_event['_BOOKING_DATES'] = array_values( $ics_event['_BOOKING_DATES'] );
				} else {
					// It is other date, in this case,  we need to  define other time:
					$ics_event['_BOOKING_DATES'][ ( count( $ics_event['_BOOKING_DATES'] ) - 1 ) ] = $test_check_out . ' 00:00:00';
				}
			}
			//FixIn End: 2.0.28.1 --------------------------------------------------------------------------------------

			$ics_event_check_out = strtotime( $ics_event_check_out );
			$ics_event_check_out = strtotime( '+1 day', $ics_event_check_out );
			$ics_event_check_out = date_i18n( "Y-m-d H:i:s", $ics_event_check_out );                //FixIn: 2.0.28.1       //$ics_event_check_out = date_i18n( "Y-m-d 00:00:00", $ics_event_check_out );
			$ics_event['_BOOKING_DATES'][] = $ics_event_check_out;

			if (
				   ( 'On' === get_bk_option( 'booking_ics_import_append_checkout_day' ) )
				&& ( 'On' === get_bk_option( 'booking_ics_import_append_extra_checkout_day' ) )
			) {
				$ics_event['_BOOKING_DATES'] = wpbm_ics_import_append_extra_checkout_day( $ics_event['_BOOKING_DATES'] );
			}
		}

		$booking_data = array();

		if ( 	( class_exists( 'wpdev_bk_biz_s' ) )
			 && ( get_bk_option( 'booking_range_selection_time_is_active')  == 'On' )
			 && ( get_bk_option( 'booking_ics_import_add_change_over_time' )  !== 'Off' )
			 && ( count( $ics_event[ '_BOOKING_DATES' ] )  > 1 )
		) {
			$dates_formats = array_fill( 0, count( $ics_event[ '_BOOKING_DATES' ] ), "Y-m-d" );								// Array ( [0] => Y-m-d [1] => Y-m-d	...  )
		} else {
			$dates_formats = array_fill( 0, count( $ics_event[ '_BOOKING_DATES' ] ), "Y-m-d H:i:s" );                    //FixIn: 2.0.15.4
		}
		$booking_dates_unix   = array_map( 'strtotime', $ics_event[ '_BOOKING_DATES' ] );									// Array ( [0] => 1498262400 [1] => 1498348800 )
		$simple_booking_dates = array_map( 'date_i18n', $dates_formats , $booking_dates_unix );							// Array ( '2017-06-23', '2017-06-24', '2017-06-25', '2017-06-26' )


		//Add check  in/out times to full day  events																	//FixIn: 8.1.3.29
		if ( 	( class_exists( 'wpdev_bk_biz_s' ) )
			 && ( get_bk_option( 'booking_range_selection_time_is_active')  == 'On' )
			 && ( get_bk_option( 'booking_ics_import_add_change_over_time' )  !== 'Off' )
		) {    																											//FixIn: 2.0.5.1

			if ( ( is_array( $simple_booking_dates ) ) && ( count( $simple_booking_dates )  > 1 ) ) {                   //FixIn: 2.0.10.4
				$wpbc_check_in  = ' ' . get_bk_option( 'booking_range_selection_start_time') . ':01';									// ' 14:00:01'
				$wpbc_check_out = ' ' . get_bk_option( 'booking_range_selection_end_time')   . ':02';									// ' 10:00:02';
				$simple_booking_dates[0]                                               = $simple_booking_dates[0] . $wpbc_check_in;
				$simple_booking_dates[ ( count( $simple_booking_dates ) - 1 ) ]        = $simple_booking_dates[ ( count( $simple_booking_dates ) - 1 ) ] . $wpbc_check_out;
				$ics_event['_BOOKING_DATES'][0]                                        = $simple_booking_dates[0];
				$ics_event['_BOOKING_DATES'][ ( count( $simple_booking_dates ) - 1 ) ] = $simple_booking_dates[ ( count( $simple_booking_dates ) - 1 ) ];
			}
		}


		WPBM_create_bookings_from_events::set_ics_dates( $ics_event[ '_BOOKING_DATES' ] );

		$booking = array(
						  'dates'		=> $simple_booking_dates														// array( '2017-06-24', '2017-06-24', '2017-06-25', '2017-06-26' )
						, 'data'		=> array()
						, 'resource_id' => $shortcode[ 'resource_id' ]
		);


		$bk_data = array();
		foreach ( $assigned_fields_arr as $assigned_field ) {

			switch ( $assigned_field[ 'ics_field_name' ] ) {

				case 'title':
					$bk_data [ $assigned_field[ 'name' ] ]= array( 'type' => $assigned_field[ 'type' ], 'value' => trim( $ics_event[ '_BOOKING_SUMMARY' ] ) );
					break;

				case 'description':
					$bk_data [ $assigned_field[ 'name' ] ]= array( 'type' => $assigned_field[ 'type' ], 'value' => trim( $ics_event[ '_BOOKING_DESCRIPTION' ] ) );
					break;

				case 'where':
					$bk_data [ $assigned_field[ 'name' ] ]= array( 'type' => $assigned_field[ 'type' ], 'value' => trim( $ics_event[ '_BOOKING_LOCATION' ] ) );
					break;

				default:
					break;
			}
		}

		// Email
		$email = 'blank@wpbookingmanager.com';																						//get_option ( 'admin_email' );
		if ( ! empty( $ics_event['_BOOKING_ATTENDEE'] ) ) {
			$email = str_replace( 'mailto:', '', $ics_event['_BOOKING_ATTENDEE'] );
			if ( ! is_email( $email ) ) {
				$email = 'blank@wpbookingmanager.com';
			}
		}
		$bk_data [ 'email' ] = array( 'value' => $email, 'type' => 'email' );

		// Optional Start  and End times
		$start_time = substr( $ics_event[ '_BOOKING_DATES' ][ 0 ], 11 );
		$end_time	= $ics_event[ '_BOOKING_DATES' ][ ( count( $ics_event[ '_BOOKING_DATES' ] ) - 1 ) ];
		$end_time	= substr( $end_time, 11 );

		// Convert times H:i:s to  seconds +1 +2 seconds and convert back  to  H:i   -----------------------------------
		$in_seconds               = wpbc_transform__24_hours_his__in__seconds( $start_time );
		$is_check_in_out__or_full = $in_seconds % 10;                                                                       // 0, 1, 2
		if ( 1 === $is_check_in_out__or_full ) {
			$in_seconds = $in_seconds - 1;
		}
		$start_time = wpbc_transform__seconds__in__24_hours_his( $in_seconds );
		$start_time = substr( $start_time, 0, 5 );

		$in_seconds               = wpbc_transform__24_hours_his__in__seconds( $end_time );
		$is_check_in_out__or_full = $in_seconds % 10;                                                                       // 0, 1, 2
		if ( 2 === $is_check_in_out__or_full ) {
			$in_seconds = $in_seconds + 8;
		}
		$end_time = wpbc_transform__seconds__in__24_hours_his( $in_seconds );
		$end_time = substr( $end_time, 0, 5 );
		// -------------------------------------------------------------------------------------------------------------

		//Add check  in/out times																						//FixIn: 8.1.3.29
		if ( 	( class_exists( 'wpdev_bk_biz_s' ) )
			 && ( get_bk_option( 'booking_range_selection_time_is_active')  == 'On' )
			 && ( get_bk_option( 'booking_ics_import_add_change_over_time' )  !== 'Off' )
			){    																										//FixIn: 2.0.5.1

			$start_time  = get_bk_option( 'booking_range_selection_start_time' );                                   	// ' 14:00'
			$end_time    = get_bk_option( 'booking_range_selection_end_time' );                                     	// ' 10:00'
		}


		if ( ( $start_time !== '00:00' ) || ( $end_time !== '00:00' ) ) {
			$bk_data [ 'rangetime' ] = array( 'value' => $start_time . ' - ' . $end_time, 'type' => 'select-one' );
		}

		$booking['data'] = $bk_data;

		$additional_params = array( 'sync_gid' => $ics_event['_BOOKING_UID'], 'is_send_emeils' => 0 );                  //FixIn: 2.0.10.2

		/**
		 *
		 *
			//		$ics_event[ '_BOOKING_DATES' ];			// array ( [0] => 2014-09-16 05:00:01		[1] => 2014-09-16 12:00:02 )
			//		$ics_event[ '_BOOKING_SUMMARY' ];		// Event (timezone Pacific GMT-07:00)
			//		$ics_event[ '_BOOKING_DESCRIPTION' ];	// 8/7/2017 1:00pm  TO   3:30pm  8/8/2017  (GMT-07:00) Pacific Time
			//		$ics_event[ '_BOOKING_LOCATION' ];		// Pacific Coast Highway, Pacific Coast Hwy, Los Angeles, CA, USA
			//		$ics_event[ '_BOOKING_UID' ];			// 5t3ogfsb3tqj09po7fiou6hh60@google.com
			//      $ics_event[ '_BOOKING_MODIFIED' ];		// 2017-06-28 10:12:35
		*/

		add_filter( 'wpbc_get_insert_sql_for_dates', 'wpbm_get_insert_sql_for_dates', 10, 5 );


		if ( ( function_exists( 'get_bk_option' ) ) && ( get_bk_option( 'booking_auto_approve_bookings_when_import' ) == 'On' ) ) {
			$additional_params ['is_approve_booking'] = 1;
		}


		// Check dates availability and process  only  if dates available in specific booking resource!
		if (
			   ( $shortcode[ 'import_conditions' ] == 'if_dates_free' )
			|| (  'On' == get_bk_option( 'booking_condition_import_if_available' ) )                					//FixIn: 9.8.15.8     -  'Import only, if days are available'
		) {													//FixIn: 2.0.15.2

			$is_dates_booked = wpbc_api_is_dates_booked( $ics_event['_BOOKING_DATES'], $booking['resource_id']
														, array(
																'is_use_booking_recurrent_time' => false				// If we import bookings, all  the times defined in dates,  so  no need to use it
														   )
								);
		} else{
			$is_dates_booked = false;
			$additional_params['save_booking_even_if_unavailable'] = 1;
		}
		// $additional_params['is_use_booking_recurrent_time'] = false;  // FixIn: 2.1.17.1.
		$additional_params['is_use_booking_recurrent_time'] = ( 'On' === get_bk_option( 'booking_recurrent_time' ) );

		if ( ! $is_dates_booked ) {

			$booking_id = wpbc_api_booking_add_new( $booking[ 'dates' ], $booking[ 'data' ], $booking[ 'resource_id' ] , $additional_params );

			if ( ( is_int( $booking_id ) ) && ( $booking_id > 0 ) ) {

				$booking_added_num++;

				// Add notes to the booking relative source of imported booking											// FixIn: 2.0.7.2
				$import_url = parse_url( $shortcode[ 'url' ] );
				if (
					   ( false !== $import_url )
					&& ( ! empty( $import_url[ "host" ]))
					&& ( class_exists('wpdev_bk_personal') )
				){
					$remark_text = '[' . date_i18n( 'Y-m-d H:i:s' ) . '] ' . sprintf( __( 'Imported from %s ', 'booking-manager' ), $import_url["host"] );
					$remark_text = str_replace( '%', '&#37;', $remark_text );
					$remark_text = str_replace( array( '"', "'" ), '', $remark_text );
					$remark_text = trim( $remark_text );

					$is_append = true;
					make_bk_action( 'wpdev_make_update_of_remark', $booking_id, $remark_text, $is_append );
				}

				do_action( 'wpbc_show_debug', sprintf ( 'Added new booking ID:<strong>%d</strong> ', $booking_id ) );						//  S_Y_S_T_E_M    L_O_G
			}

			if ( is_wp_error( $booking_id ) ) {
				do_action( 'wpbc_show_debug', implode( ' ', $booking_id->get_error_messages()) );

				do_action( 'wpbc_admin_show_top_notice'																				// N_O_T_I_C_E  in  H_E_A_D_E_R
							, implode( ' ', $booking_id->get_error_messages())
							, 'warning', 30000 );
			}

		} else {

			do_action( 'wpbc_show_debug',																				//  S_Y_S_T_E_M    L_O_G
				sprintf ( 'Event was not create becausse dates %s already booked in booking resource ID = %d'
						, implode( ', ', $booking[ 'dates' ] ) , $booking[ 'resource_id' ] ) );
		}

		remove_filter( 'wpbc_get_insert_sql_for_dates',				'wpbm_get_insert_sql_for_dates', 10 );


		// Remove previously saved dates to our 'Static' class.
		WPBM_create_bookings_from_events::erase_ics_dates();
	}

	return $booking_added_num;
}
add_action( 'wpbm_ics_import_start', 'wpbm_ics_import_start', 10, 1 );


// Legacy Import

/**	Import ICS feed and create bookings .in Booking Calendar
 *
 * @param array $attr = array(
								'url' => ''
							  , 'resource_id' => 1
							  , 'import_conditions' => '' | 'if_dates_free'				// maybe rename ???		if_dates_booked_then_not_import
							)
 * @return int|bool		number of imported bookings or FALSE if error
 */
function wpbm_ics_import_start_legacy( $attr ) {

	//                                                                              <editor-fold   defaultstate="collapsed"   desc=" Parse / validate  parameters " >
	/////////////////////////////////////////////////////////////////////
	// Parse / validate  parameters
	/////////////////////////////////////////////////////////////////////
	$defaults = array(
						'url' => ''
					  , 'resource_id' => 1
					  , 'delete' => 0
					  , 'import_conditions' => ''
					  , 'from' => 'any'				// 'today'		// '00:00 today'
					  , 'from_offset' => ''
					  , 'until' => 'any'			// 'year-end'
					  , 'until_offset' => ''
					  , 'max' => ''
					  , 'is_all_dates_in' => true	// Conditional of Dates checking.  TRUE - Remove event if al least 1 day not in conditional interval,  FALSE - save event, if at leat one date in conditional interval
	);
	$shortcode = array();

	foreach ( $attr as $param_name => $param_value ) {

		switch ( $param_name) {							// Validate Params

			case 'url':
				$shortcode[ $param_name ] = esc_url_raw( $param_value );		// $shortcode[ 'url' ]
				$shortcode[ $param_name ] = str_replace( '&amp;', '&', $shortcode[ $param_name ] );    //FixIn: 2.0.14.2
				break;

			case 'import_conditions':
				$shortcode[ $param_name ] = esc_attr( $param_value );				// $shortcode[ 'resource_id' ]
				break;

			case 'resource_id':
				$shortcode[ $param_name ] = intval($param_value );				// $shortcode[ 'resource_id' ]
				break;

			case 'from':										// 'now', 'today', 'week', 'month-start', 'month-end', 'year-start', 'any', 'date' = 2017-08-07
				$shortcode[ $param_name ] = $param_value;
				break;

			case 'from_offset':									// 5d,  10h, 5m, 30s	--	if  from: { 'now', 'today', 'week', 'month-start', 'month-end', 'year-start' }
				$shortcode[ $param_name ] = $param_value;
				break;

			case 'until':										// 'now', 'today', 'week', 'month-start', 'month-end', 'year-end', 'any', 'date' = 2017-08-07
				$shortcode[ $param_name ] = $param_value;
				break;

			case 'until_offset':								// 5d,  10h, 5m, 30s	--	if  until: { 'now', 'today', 'week', 'month-start', 'month-end', 'year-end' }
				$shortcode[ $param_name ] = $param_value;
				break;

			case 'max':
				$shortcode[ $param_name ] = intval( $param_value );
				break;

			case 'is_all_dates_in':								// Conditional of Dates checking.  TRUE - Remove event if al least 1 day not in conditional interval,  FALSE - save event, if at leat one date in conditional interval
				$shortcode[ $param_name ] = intval( $param_value );
				break;


			default:
				$shortcode[ $param_name ] = $param_value;
				break;
		}
	}
	$shortcode = wp_parse_args( $shortcode, $defaults );
	//                                                                              </editor-fold>

//debuge($shortcode);
	//                                                                              <editor-fold   defaultstate="collapsed"   desc=" Notice - Import Parameters  |  Error No URL" >

	do_action( 'wpbc_show_debug', array( 'Import Parameters' , $shortcode ) );											//  S_Y_S_T_E_M    L_O_G

	if ( empty( $shortcode[ 'url' ] ) ) {
		do_action( 'wpbc_admin_show_top_notice', __( 'No ics url feed', 'booking-manager' ), 'error', 5000 );					// N_O_T_I_C_E  in  H_E_A_D_E_R
		return  false;
	}
	//                                                                              </editor-fold>

	/////////////////////////////////////////////////////////////////////	-	Get, Parse ICS Feed

	$ics_array = wpbm_ics_file_to_array( $shortcode[ 'url' ] );

	//                                                                              <editor-fold   defaultstate="collapsed"   desc=" Notice - feed contain N events  |  Error Importing " >
	do_action( 'wpbc_show_debug', array( 'Imported data' , $ics_array) );												//  S_Y_S_T_E_M    L_O_G

	// If Error
	if ( is_wp_error( $ics_array ) ) {

		$error_message = $ics_array->get_error_message();
		do_action( 'wpbc_admin_show_top_notice', $error_message, 'error', 5000 );										// N_O_T_I_C_E  in  H_E_A_D_E_R
		return  false;
	}

	//FixIn: 2.0.7.3
	$ics_array_events_num = 0;
	if (  ( ! empty( $ics_array  ) )  &&   ( ! empty( $ics_array[ 'events' ]  ) )  &&   ( is_array( $ics_array[ 'events' ]  ) )  ) {
		$ics_array_events_num = count( $ics_array[ 'events' ] );
	}
	do_action( 'wpbc_admin_show_top_notice'																				// N_O_T_I_C_E  in  H_E_A_D_E_R
			, sprintf ( __( '.ics feed contain %s events at URL %s', 'booking-manager' ), '<b>' . $ics_array_events_num . '</b>', '<b><a href="'. $shortcode[ 'url' ] .'">' . $shortcode[ 'url' ] . '</a></b>' )
			, 'info', 5000 );
	//                                                                              </editor-fold>

	//FixIn: 2.0.18.3
	if ( 'skip' != $shortcode['delete'] ) {
		wpbm_delete_all_imported_bookings( array( 'resource_id' => $shortcode['resource_id'] ) );                           //FixIn: 2.0.10.3
	}

	$bk_array = array();
	// Get Only '_BOOKING...' field from  ICS array
	if ( $ics_array !== false ) {
		$bk_array = wpbm_get_booking_fields_from_ics_array( $ics_array[ 'events' ] );
	}

	do_action( 'wpbc_show_debug', array( 'Imported Events', $bk_array ) );												//  S_Y_S_T_E_M    L_O_G


	//FixIn: 2.0.6.1 - Set timezone frrom  Booking > Settings > Sync  page for booking listing shortcode
	$tzid = get_bk_option( 'booking_gcal_timezone' );
	if ( ! empty( $tzid ) ) {
		foreach ( $bk_array as $bk_k => $bk_ics_data_arr ) {


			//apply  our timezone from  the Booking > Settings > Search page
			foreach ( $bk_array[ $bk_k ]['_BOOKING_DATES'] as $dk => $day ) {
				//$bk_array[ $bk_k ][ '_BOOKING_DATES' ][ $dk ]  = ZDateHelper::toLocalDateTime( get_gmt_from_date( $day ), $tzid );

				//FixIn: 2.0.7.4	-	Skip adding Timezone to "middle" days,  if days start with  time 00:00:00 - its means event for full day, not the start/end time
				// 						Apply  timezone only to fist and last days in a list, if the change over days activated in the Booking Calendar
				$ics_time_in_day = substr( $day, -8);
				if ( '00:00:00' == $ics_time_in_day ) {
					continue;
				}
				//FixIn: 2.0.7.4	-	Skip adding Timezone to "middle" days, if Booking Calendar use change over days, to prevent of having clock icon in middle days.
				if ( 	( class_exists( 'wpdev_bk_biz_s' ) )
					 && ( get_bk_option( 'booking_range_selection_time_is_active')  == 'On' )
					 && ( get_bk_option( 'booking_ics_import_add_change_over_time' )  !== 'Off' )
				) {    //FixIn: 2.0.5.1
					$days_number = count( $bk_array[ $bk_k ]['_BOOKING_DATES'] );
					if ( ( 0 != $dk ) && ( ( $days_number - 1) != $dk )  ) {
						continue;
					}
					// We are append one day  to  the booking,  so  skip this day  for timezone,  as well
					if ( ( get_bk_option( 'booking_ics_import_append_checkout_day' ) !== 'Off' )  && ( ( $days_number - 1) == $dk )  ) {
						continue;
					}
				}

				$bk_array[ $bk_k ]['_BOOKING_DATES'][ $dk ] = ZDateHelper::toLocalDateTime( $day, $tzid );
			}
		}
	}

	/////////////////////////////////////////////////////////////////////	-	Check if these EVENTS was imported before or NOT

	$booking_ics_force_import = get_bk_option( 'booking_ics_force_import' );    //FixIn: 2.0.10.1
	$booking_condition_import_only_new = get_bk_option( 'booking_condition_import_only_new' );        //FixIn: 9.8.15.8
	if ( false === $booking_condition_import_only_new ) {
		// OLD:
		if ( 'On' !== $booking_ics_force_import ) {
			$bk_array = wpbm_clear_events_from_exist_bookings( $bk_array );
		}
	} else {
		// NEW:
		if ( 'On' === $booking_condition_import_only_new ) {
			$bk_array = wpbm_clear_events_from_exist_bookings( $bk_array );
		}
	}

	//                                                                              <editor-fold   defaultstate="collapsed"   desc=" Notice - if events was imported previously  |  Already ALL Imported " >
	do_action( 'wpbc_show_debug', array( 'Check, if events was imported previously. New events: ', $bk_array ) );		//  S_Y_S_T_E_M    L_O_G

	if ( empty( $bk_array ) ) {

		do_action( 'wpbc_admin_show_top_notice'																			// N_O_T_I_C_E  in  H_E_A_D_E_R
			, '<strong>' . __( 'Warning', 'booking' ) . '!</strong> '
			  . sprintf( __( 'No any new events to import! These events was import previously, already.', 'booking-manager' ), '<strong>' . count( $bk_array ) . '</strong>' )
			, 'warning', 3000 );
		return 0;
	}
	//                                                                              </editor-fold>


	/////////////////////////////////////////////////////////////////////	-	Skip events that  does not fit to filter parameters: FROM - UNTIL

	// $bk_array = wpbm_clear_events_by_dates( $bk_array, $shortcode );


	// Sort Events
	$bk_array = wpbm_sort_events_by( $bk_array );

	// Filter By Dates		-	"From - Until"
	$bk_array = wpbm_clear_events_by_dates( $bk_array, $shortcode );

	// Filter events by		-	"Max"
	$bk_array = wpbm_clear_events_by_count( $bk_array, $shortcode );


	//                                                                              <editor-fold   defaultstate="collapsed"   desc=" Notice - Creation of N bookings " >
	do_action( 'wpbc_admin_show_top_notice'																				// N_O_T_I_C_E  in  H_E_A_D_E_R
			, sprintf( __( 'Imported of %s bookings', 'booking-manager' ), '<strong>' . count( $bk_array ) . '</strong>' )
			, 'info', 3000 );

	do_action( 'wpbc_show_debug', array( 'Create bookings after filtering', $bk_array ) );								//  S_Y_S_T_E_M    L_O_G
	//                                                                              </editor-fold>

	/////////////////////////////////////////////////////////////////////	-	Loop events  >  C r e a t e    B o o k i n g s

	// Get assigning fields  for  SUMMARY, DESCRIPTION, LOCATION
	$assigned_fields_arr = WPBM_create_bookings_from_events::get_assigned_form_fields();

	$booking_added_num = 0;

	foreach ( $bk_array as $ics_event) {

		//FixIn: 2.0.5.2
		//FixIn: 8.1.3.29
//		if (   ( class_exists( 'wpdev_bk_biz_s' ) )
//			&& ( get_bk_option( 'booking_range_selection_time_is_active')  == 'On' )
//			&& ( get_bk_option( 'booking_ics_import_add_change_over_time' ) !== 'Off' )
//			&& ( get_bk_option( 'booking_ics_import_append_checkout_day' ) !== 'Off' )
//		) {
		if ( 'On' == get_bk_option( 'booking_ics_import_append_checkout_day' ) ) {                                      //FixIn: 2.0.27.1		//FixIn: 9.5.4.1
			// Add one additional  day  to .ics event (useful in some cases for bookings with  change-over days),  if the imported .ics dates is coming without check  in/our times
			// Later system is adding check  in/out times from  Booking Calendar to  this event
			$ics_event_check_out = $ics_event['_BOOKING_DATES'][ ( count( $ics_event['_BOOKING_DATES'] ) - 1 ) ];

			//FixIn Start: 2.0.28.1 ------------------------------------------------------------------------------------
			// Is check in/out dates in this event it's the same date
			$test_check_in  = substr( $ics_event['_BOOKING_DATES'][0], 0, 10 );
			$test_check_out = substr( $ics_event['_BOOKING_DATES'][ ( count( $ics_event['_BOOKING_DATES'] ) - 1 ) ], 0, 10 );
			if ( $test_check_in === $test_check_out ) {
				// It is the same date, like 2024-02-12 10:00:01, 2024-02-12 14:59:52, then remove this date, because we will add new date
				unset( $ics_event['_BOOKING_DATES'][ ( count( $ics_event['_BOOKING_DATES'] ) - 1 ) ] );
				// Important! Reindex array, after unset operation.
				$ics_event['_BOOKING_DATES'] = array_values( $ics_event['_BOOKING_DATES'] );
			} else {
				// It is other date, in this case,  we need to  define other time:
				$ics_event['_BOOKING_DATES'][ ( count( $ics_event['_BOOKING_DATES'] ) - 1 ) ] = $test_check_out . ' 00:00:00';
			}
			//FixIn End: 2.0.28.1 --------------------------------------------------------------------------------------

			$ics_event_check_out = strtotime( $ics_event_check_out );
			$ics_event_check_out = strtotime( '+1 day', $ics_event_check_out );
			$ics_event_check_out = date_i18n( "Y-m-d H:i:s", $ics_event_check_out );                //FixIn: 2.0.28.1       //$ics_event_check_out = date_i18n( "Y-m-d 00:00:00", $ics_event_check_out );
			$ics_event['_BOOKING_DATES'][] = $ics_event_check_out;

			if (
				   ( 'On' === get_bk_option( 'booking_ics_import_append_checkout_day' ) )
				&& ( 'On' === get_bk_option( 'booking_ics_import_append_extra_checkout_day' ) )
			) {
				$ics_event['_BOOKING_DATES'] = wpbm_ics_import_append_extra_checkout_day( $ics_event['_BOOKING_DATES'] );
			}
		}

		$booking_data = array();

		if ( 	( class_exists( 'wpdev_bk_biz_s' ) )
			 && ( get_bk_option( 'booking_range_selection_time_is_active')  == 'On' )
			 && ( get_bk_option( 'booking_ics_import_add_change_over_time' )  !== 'Off' )
			 && ( count( $ics_event[ '_BOOKING_DATES' ] )  > 1 )
		) {
			$dates_formats = array_fill( 0, count( $ics_event[ '_BOOKING_DATES' ] ), "Y-m-d" );								// Array ( [0] => Y-m-d [1] => Y-m-d	...  )
		} else {
			$dates_formats = array_fill( 0, count( $ics_event[ '_BOOKING_DATES' ] ), "Y-m-d H:i:s" );                    //FixIn: 2.0.15.4
		}
		$booking_dates_unix = array_map( 'strtotime', $ics_event[ '_BOOKING_DATES' ] );									// Array ( [0] => 1498262400 [1] => 1498348800 )
		$simple_booking_dates = array_map( 'date_i18n', $dates_formats , $booking_dates_unix );							// Array ( '2017-06-23', '2017-06-24', '2017-06-25', '2017-06-26' )


		//FixIn: 8.1.3.29
		if ( 	( class_exists( 'wpdev_bk_biz_s' ) )
			 && ( get_bk_option( 'booking_range_selection_time_is_active')  == 'On' )
			 && ( get_bk_option( 'booking_ics_import_add_change_over_time' )  !== 'Off' )
		) {    //FixIn: 2.0.5.1
			//Add check  in/out times to full day  events
			if ( ( is_array( $simple_booking_dates ) ) && ( count( $simple_booking_dates )  > 1 ) ) {                    //FixIn: 2.0.10.4
				$wpbc_check_in  = ' ' . get_bk_option( 'booking_range_selection_start_time') . ':01';									// ' 14:00:01'
				$wpbc_check_out = ' ' . get_bk_option( 'booking_range_selection_end_time')   . ':02';									// ' 10:00:02';
				$simple_booking_dates[0]                                               = $simple_booking_dates[0] . $wpbc_check_in;
				$simple_booking_dates[ ( count( $simple_booking_dates ) - 1 ) ]        = $simple_booking_dates[ ( count( $simple_booking_dates ) - 1 ) ] . $wpbc_check_out;
				$ics_event['_BOOKING_DATES'][0]                                        = $simple_booking_dates[0];
				$ics_event['_BOOKING_DATES'][ ( count( $simple_booking_dates ) - 1 ) ] = $simple_booking_dates[ ( count( $simple_booking_dates ) - 1 ) ];
			}
		}

//debuge($ics_event[ '_BOOKING_DATES' ]);die;
		// Tempoary save our dates

//		if( count( $ics_event['_BOOKING_DATES'] ) > 2 ) {
//			unset( $ics_event['_BOOKING_DATES'][ ( count( $ics_event['_BOOKING_DATES'] ) - 1 ) ] );                        //Remove last  imported date
//			if ( count( $ics_event['_BOOKING_DATES'] ) > 2 ) {                // Add one date if number of days in booking more than 2
//				$ics_event['_BOOKING_DATES'][ ( count( $ics_event['_BOOKING_DATES'] ) - 1 ) ] = $simple_booking_dates[ ( count( $ics_event['_BOOKING_DATES'] ) - 1 ) ] . $wpbc_check_out;
//			} else if ( count( $ics_event['_BOOKING_DATES'] ) == 1 ) {        // Add one date,  if we are having only  1 day  in booking (previously  was having 2 dates
//				$ics_event['_BOOKING_DATES'][] = $simple_booking_dates[ ( count( $ics_event['_BOOKING_DATES'] ) - 1 ) ] . $wpbc_check_out;
//			}
//		}
		WPBM_create_bookings_from_events::set_ics_dates( $ics_event[ '_BOOKING_DATES' ] );

		$booking = array(
						  'dates'		=> $simple_booking_dates														// array( '2017-06-24', '2017-06-24', '2017-06-25', '2017-06-26' )
						, 'data'		=> array()
						, 'resource_id' => $shortcode[ 'resource_id' ]
		);


		$bk_data = array();
		foreach ( $assigned_fields_arr as $assigned_field ) {

			switch ( $assigned_field[ 'ics_field_name' ] ) {

				case 'title':
					$bk_data [ $assigned_field[ 'name' ] ]= array( 'type' => $assigned_field[ 'type' ], 'value' => trim( $ics_event[ '_BOOKING_SUMMARY' ] ) );
					break;

				case 'description':
					$bk_data [ $assigned_field[ 'name' ] ]= array( 'type' => $assigned_field[ 'type' ], 'value' => trim( $ics_event[ '_BOOKING_DESCRIPTION' ] ) );
					break;

				case 'where':
					$bk_data [ $assigned_field[ 'name' ] ]= array( 'type' => $assigned_field[ 'type' ], 'value' => trim( $ics_event[ '_BOOKING_LOCATION' ] ) );
					break;

				default:
					break;
			}
		}

		// Email
		$home_url = explode( '://', home_url() );
		//if (count($home_url>0))                                                                                       //FixIn: 2.0.3.2
		//	$email = 'ics@' . $home_url[1];
		//else
		$email = get_option ( 'admin_email' );
		$bk_data [ 'email' ] = array( 'value' => $email, 'type' => 'email' );

		// Optional Start  and End times
		$start_time = substr( $ics_event[ '_BOOKING_DATES' ][ 0 ], 11, 5 );
		$end_time	= $ics_event[ '_BOOKING_DATES' ][ ( count( $ics_event[ '_BOOKING_DATES' ] ) - 1 ) ];
		$end_time	= substr( $end_time, 11, 5 );

		//FixIn: 8.1.3.29
		if ( 	( class_exists( 'wpdev_bk_biz_s' ) )
			 && ( get_bk_option( 'booking_range_selection_time_is_active')  == 'On' )
			 && ( get_bk_option( 'booking_ics_import_add_change_over_time' )  !== 'Off' )
			){    //FixIn: 2.0.5.1
			//Add check  in/out times
			$start_time  = get_bk_option( 'booking_range_selection_start_time' );                                   // ' 14:00'
			$end_time    = get_bk_option( 'booking_range_selection_end_time' );                                     // ' 10:00'
		}


		if ( ( $start_time !== '00:00' ) || ( $end_time !== '00:00' ) ) {
			$bk_data [ 'rangetime' ] = array( 'value' => $start_time . ' - ' . $end_time, 'type' => 'select-one' );
		}

		$booking['data'] = $bk_data;

		$additional_params = array( 'sync_gid' => $ics_event['_BOOKING_UID'], 'is_send_emeils' => 0 );                  //FixIn: 2.0.10.2

		/**
		//		$ics_event[ '_BOOKING_DATES' ];			// array ( [0] => 2014-09-16 05:00:01		[1] => 2014-09-16 12:00:02 )
		//		$ics_event[ '_BOOKING_SUMMARY' ];		// Event (timezone Pacific GMT-07:00)
		//		$ics_event[ '_BOOKING_DESCRIPTION' ];	// 8/7/2017 1:00pm  TO   3:30pm  8/8/2017  (GMT-07:00) Pacific Time
		//		$ics_event[ '_BOOKING_LOCATION' ];		// Pacific Coast Highway, Pacific Coast Hwy, Los Angeles, CA, USA
		//		$ics_event[ '_BOOKING_UID' ];			// 5t3ogfsb3tqj09po7fiou6hh60@google.com
		// $ics_event[ '_BOOKING_MODIFIED' ];			// 2017-06-28 10:12:35
		*/

		add_filter( 'wpbc_get_insert_sql_for_dates',			 'wpbm_get_insert_sql_for_dates', 10, 5 );

		// Do  not overupdate "child booking resources" when  saving bookings to  parent booking resource. Just skip  this checking
		add_filter( 'wpbc_is_reupdate_dates_to_child_resources', 'wpbm_is_reupdate_dates_to_child_resources', 10, 7 );

		// Check dates availability and process
		// only  if dates available in specific booking resource!
		if (
			   ( $shortcode[ 'import_conditions' ] == 'if_dates_free' )
			|| (  'On' == get_bk_option( 'booking_condition_import_if_available' ) )                					//FixIn: 9.8.15.8     -  'Import only, if days are available'
		){
			$is_dates_booked = wpbc_api_is_dates_booked( $ics_event['_BOOKING_DATES'], $booking['resource_id'] );       //FixIn: 2.0.15.2
			//$is_dates_booked = wpbc_api_is_dates_booked( $booking['dates'], $booking['resource_id'] );
		} else{
			$is_dates_booked = false;
		}


		if ( ! $is_dates_booked ) {

			$booking_id = wpbc_api_booking_add_new( $booking[ 'dates' ], $booking[ 'data' ], $booking[ 'resource_id' ] , $additional_params );
			$booking_added_num++;

            //if (  ( defined( 'WP_BK_AUTO_APPROVE_WHEN_IMPORT_GCAL' ) ) && ( WP_BK_AUTO_APPROVE_WHEN_IMPORT_GCAL )  ){   // Auto  approve booking if imported
			if ( ( function_exists( 'get_bk_option' )) && ( get_bk_option( 'booking_auto_approve_bookings_when_import' ) == 'On' ) ) {		//FixIn: 8.1.3.27
                // Auto  approve booking,  when  imported.                                      //FixIn:7.0.1.59
                global $wpdb;
                if ( false === $wpdb->query( $wpdb->prepare( "UPDATE {$wpdb->prefix}bookingdates SET approved = %s WHERE booking_id IN ({$booking_id})", '1' ) ) ){
                    ?> <script type="text/javascript">
                        var my_message = '<?php echo html_entity_decode( esc_js( get_debuge_error('Error during updating to DB' ,__FILE__,__LINE__) ),ENT_QUOTES) ; ?>';
                        wpbc_admin_show_message( my_message, 'error', 30000 );
                       </script> <?php
                    die();
                }
            }

			//FixIn: 2.0.7.2	- add notes to the booking relative source of imported booking
			$import_url = parse_url( $shortcode[ 'url' ] );
			if ( ( false !== $import_url ) && ( ! empty( $import_url[ "host" ])) && ( class_exists('wpdev_bk_personal') )  ) {

				$remark_text = str_replace('%','&#37;', '[' . date_i18n('Y-m-d H:i:s') . '] ' . sprintf( __( 'Imported from %s ', 'booking-manager'), $import_url[ "host" ] ) );
				$my_remark   = str_replace( array( '"', "'" ),'',$remark_text);
				$my_remark   = trim( $my_remark );

				global $wpdb;

				$update_sql =  $wpdb->prepare( "UPDATE {$wpdb->prefix}booking AS bk SET bk.remark= %s WHERE bk.booking_id= %d ", $remark_text, $booking_id );
				if ( false === $wpdb->query( $update_sql ) ) {
					?> <script type="text/javascript">
							var my_message = '<?php echo html_entity_decode( esc_js( get_debuge_error('Error during updating notes in DB' ,__FILE__,__LINE__) ),ENT_QUOTES) ; ?>';
							wpbc_admin_show_message( my_message, 'error', 30000 );
					</script> <?php
					die();
				}
			}

			do_action( 'wpbc_show_debug', sprintf ( 'Added new booking ID:<strong>%d</strong> ', $booking_id ) );						//  S_Y_S_T_E_M    L_O_G
		} else {

			do_action( 'wpbc_show_debug',																				//  S_Y_S_T_E_M    L_O_G
				sprintf ( 'Event was not create becausse dates %s already booked in booking resource ID = %d'
						, implode( ', ', $booking[ 'dates' ] ) , $booking[ 'resource_id' ] ) );
		}

		remove_filter( 'wpbc_get_insert_sql_for_dates',				'wpbm_get_insert_sql_for_dates', 10 );
		remove_filter( 'wpbc_is_reupdate_dates_to_child_resources', 'wpbm_is_reupdate_dates_to_child_resources', 10 );

		// Remove previously saved dates to our 'Static' class.
		WPBM_create_bookings_from_events::erase_ics_dates();
	}

	return $booking_added_num;
}



////////////////////////////////////////////////////////////////////////////////////////////
// Booking Calendar support functions
////////////////////////////////////////////////////////////////////////////////////////////


/** Clear array  of Events from events that  already  exist  in Booking table
 *  Check UID and GUID sync paramaters
 *
 * @param array $bk_array		- array of events
 * @return array				- trimmed array
 */
function wpbm_clear_events_from_exist_bookings( $bk_array ) {

	$bk_uid = $bk_guid = array();
	// GET array of UID for imported bookings
	foreach ( $bk_array as $ics_key => $ics_event) {

		$bk_uid[ $ics_key ] = $ics_event[ '_BOOKING_UID' ];

		if ( strpos( $ics_event[ '_BOOKING_UID' ], '@google.com') !== false ) {
			// 15ig8t0i739kajgjc8ekc386dt@google.com	-  ID of event from  ICS
			// 15ig8t0i739kajgjc8ekc386dt_20170815		-  ID of event during import from Google Calendar  (probabaly  created by ID before @ + first  date)

			$bk_guid[ $ics_key ] = str_replace( '@google.com'
									, date_i18n( '_Ymd', strtotime( $ics_event[ '_BOOKING_DATES' ][0] ) )
									,  $ics_event[ '_BOOKING_UID' ]
								);
		}
	}
	$bookings_check_uid = array_merge( $bk_uid,$bk_guid );

	$bookings_exit_uid = wpbm_get_exist_bookings_gid(  $bookings_check_uid );

	// Remove events which already  exist
	foreach ( $bk_uid as $ics_key => $ics_uid ) {

		// If exist UID remove it from  event
		if ( in_array( $ics_uid, $bookings_exit_uid ) ) {
			unset( $bk_array[ $ics_key ] );
		}

		// If we are having such  GUID and it exist, then  remove ir
		if ( isset( $bk_guid[ $ics_key ] ) ) {
			$ics_gid = $bk_guid[ $ics_key ];
			if ( in_array( $ics_uid, $bookings_exit_uid ) ) {
				unset( $bk_array[ $ics_key ] );
			}
		}
	}
	////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

	return $bk_array;
}


/**
 * Return existing non-trashed Booking Calendar synchronization UIDs.
 *
 * Event UIDs originate in remote iCalendar content. Each UID is therefore
 * bound through a separate SQL placeholder instead of being interpolated into
 * the dynamic IN clause.
 *
 * @global wpdb $wpdb WordPress database abstraction object.
 *
 * @param array $uid_arr Event UIDs to check.
 *
 * @return array Existing synchronization UIDs.
 */
function wpbm_get_exist_bookings_gid( $uid_arr ) {
	if ( empty( $uid_arr ) || ! is_array( $uid_arr ) ) {
		return array();
	}

	$uid_values = array();
	foreach ( $uid_arr as $uid_value ) {
		if ( ! is_scalar( $uid_value ) ) {
			continue;
		}

		$uid_values[] = (string) $uid_value;
	}

	if ( empty( $uid_values ) ) {
		return array();
	}

	global $wpdb;

	$uid_placeholders = implode( ', ', array_fill( 0, count( $uid_values ), '%s' ) );
	$query_values     = array_merge( $uid_values, array( 1 ) );

	// The placeholder list contains only fixed %s tokens; the table name uses WordPress's trusted prefix.
	$sql = $wpdb->prepare( // phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
		"SELECT sync_gid FROM {$wpdb->prefix}booking WHERE sync_gid IN ({$uid_placeholders}) AND trash != %d",
		$query_values
	);

	if ( ! is_string( $sql ) ) {
		return array();
	}

	$existing_booking_uids = $wpdb->get_col( $sql );

	return is_array( $existing_booking_uids ) ? $existing_booking_uids : array();
}


/** Trim  number of events in array
 *
 * @param array $bk_array
 * @param array $shortcode
 * @return array
 */
function wpbm_clear_events_by_count( $bk_array, $shortcode ) {

	if ( empty( $shortcode['max'] ) ) {
		return $bk_array;
	} else {
		$max = intval( $shortcode['max'] );
	}

	$bk_count= count( $bk_array );
	if ( $max > $bk_count )
		return $bk_array;

	$cnt = 0;
	$events_arr = array();

	foreach ( $bk_array as $ev_key => $ev_arr ) {

		$events_arr[] = $ev_arr;

		$cnt++;
		if ( $cnt >= $max )
			break;
	}

	return $events_arr;
}




/** Remove ONLY dates from event(s) that  does not fit to filter parameters: FROM - UNTIL -- All events will exist here
 *
 * @param array $bk_array		- array of events
 * @param array $shortcode
 * @return array				- trimmed array
 */
function wpbm_remove_dates_from_event_not_in_condition( $bk_array, $shortcode ) {

	if ( ( ! isset( $shortcode['from'] ) ) && ( ! isset( $shortcode['until'] ) ) ) {
		return $bk_array;
	}

	//                                                                              <editor-fold   defaultstate="collapsed"   desc=" F R O M    C o n d " >

	// F R O M
	$offset = wpbm_get_offset_unix_from_param( $shortcode[ 'from_offset' ] );

	if ( $shortcode['from'] == 'any' )		$shortcode['from'] = 'any-start';
	if ( $shortcode['from'] == 'week' )		$shortcode['from'] = 'week-start';

	$condition_from = wpbm_get_time_unix_from_param_offset( $shortcode['from'], $offset );

	//                                                                              </editor-fold>


	//                                                                              <editor-fold   defaultstate="collapsed"   desc=" U N T I L   C o n d " >

	//  U N T I L
	$offset = wpbm_get_offset_unix_from_param( $shortcode[ 'until_offset' ] );

	if ( $shortcode['until'] == 'any' )		$shortcode['until'] = 'any-end';
	if ( $shortcode['until'] == 'week' )	$shortcode['until'] = 'week-end';

	$condition_until = wpbm_get_time_unix_from_param_offset( $shortcode['until'], $offset );

	//                                                                              </editor-fold>


	foreach ( $bk_array as $e_key => $ics_event ) {

		$new_dates = array();
//debuge($ics_event[ '_BOOKING_DATES' ] );
		foreach ( $ics_event[ '_BOOKING_DATES' ] as $d_key => $ics_date ) {

			$ics_date_unix = strtotime( $ics_date );
//debuge( $d_key, $ics_date , array( $condition_from, $condition_until ) );
			if ( ( $condition_from <= $ics_date_unix ) && ( $condition_until >= $ics_date_unix ) ) {

				$new_dates[] = $ics_date;
			}
		}
//debuge( $new_dates ); die;
		$bk_array[ $e_key ][ '_BOOKING_DATES' ] = $new_dates;
	}

	return $bk_array;
}


/** Skip events that  does not fit to filter parameters: FROM - UNTIL
 *
 * @param array $bk_array		- array of events
 * @param array $shortcode
 * @return array				- trimmed array
 */
function wpbm_clear_events_by_dates( $bk_array, $shortcode ) {

	if ( ( ! isset( $shortcode['from'] ) ) && ( ! isset( $shortcode['until'] ) ) ) {
		return $bk_array;
	}

	//                                                                              <editor-fold   defaultstate="collapsed"   desc=" F R O M    C o n d " >

	// F R O M
	$offset = wpbm_get_offset_unix_from_param( $shortcode[ 'from_offset' ] );

	if ( $shortcode['from'] == 'any' )		$shortcode['from'] = 'any-start';
	if ( $shortcode['from'] == 'week' )		$shortcode['from'] = 'week-start';

	$condition_from = wpbm_get_time_unix_from_param_offset( $shortcode['from'], $offset );

	//                                                                              </editor-fold>


	//                                                                              <editor-fold   defaultstate="collapsed"   desc=" U N T I L   C o n d " >

	//  U N T I L
	$offset = wpbm_get_offset_unix_from_param( $shortcode[ 'until_offset' ] );

	if ( $shortcode['until'] == 'any' )		$shortcode['until'] = 'any-end';
	if ( $shortcode['until'] == 'week' )	$shortcode['until'] = 'week-end';

	$condition_until = wpbm_get_time_unix_from_param_offset( $shortcode['until'], $offset );

	//                                                                              </editor-fold>

	// Conditional of Dates checking.  TRUE - Remove event if al least 1 day not in conditional interval,  FALSE - save event, if at leat one date in conditional interval
	if ( ! isset( $shortcode['is_all_dates_in'] ) )
		$is_all_dates_in_condition = true;
	else
		$is_all_dates_in_condition = (bool) $shortcode['is_all_dates_in'];

//debuge($condition_from, date_i18n('Y-m-d H:is',$condition_from));
//debuge($condition_until, date_i18n('Y-m-d H:is',$condition_until));
//debuge( (int) $is_all_dates_in_condition );
//die;
	// Remove some events,  that does not inside From | End time
	$remove_events_keys = array();
	foreach ( $bk_array as $e_key => $ics_event ) {
		foreach ( $ics_event[ '_BOOKING_DATES' ] as $d_key => $ics_date ) {
			$ics_date = strtotime( $ics_date );

			if ( $is_all_dates_in_condition ) {
				// STRICT - ALL DATES
				if ( ( $condition_from > $ics_date ) || ($condition_until < $ics_date ) ) {

					$remove_events_keys[] = $e_key;
					continue;
				}
			} else {
				// AT LEAST 1 DATE
				if ( ( $condition_from <= $ics_date ) && ( $condition_until >= $ics_date ) ) {

					$remove_events_keys = array_diff( $remove_events_keys, array( $e_key ) );	// Remove values "$e_key" from array
					break;
				} else {
					if ( ! in_array( $e_key, $remove_events_keys ) ) {
						$remove_events_keys[] = $e_key;
					}
				}

			}

		}
	}

	// Remove them
	$remove_events_keys = array_unique( $remove_events_keys );

//debuge( $bk_array, $remove_events_keys);
	foreach ( $remove_events_keys as $evnt_key ) {
		unset( $bk_array[ $evnt_key ] );
	}

	return $bk_array;
}


/** Get time offset in seconds based on parameter
 *
 * @param string $offset_param		30s | 5m | 2h | 7d | just seconds
 * @return int
 */
function wpbm_get_offset_unix_from_param( $offset_param ) {

	$offset = 0;
	if ( ! empty( $offset_param ) ) {

		$offset_type  = substr( $offset_param, -1 );
		$offset_value = substr( $offset_param, 0, -1 );

		switch ( $offset_type ) {
			case "s":  // Seconds
				$offset = intval( $offset_value );
				break;
			case "m":  // Minutes
				$offset = intval( $offset_value ) * 60 ;
				break;
			case "h":  // Hours
				$offset = intval( $offset_value ) * 3600 ;
				break;
			case "d":  // Days
				$offset = intval( $offset_value ) * 86400 ;
				break;
			default:
				$offset = intval( $offset_value );
		}
	}
	return $offset;
}


/** Get Unix Time based on date parameter / condition and offset in seconds
 *
 * @param string $check_day		- date type:			// 'now' | 'today' | 'week' == 'week-start' | 'week-end' | 'month-start' | 'month-end' | 'year-start' | 'year-end' | 'any' == 'any-end' | 'any-start' | '2017-08-07'
 * @param int $offset_unix		- offset in seconds
 * @return int					- Unix time in seconds
 */
function wpbm_get_time_unix_from_param_offset( $check_day, $offset_unix ) {

//		$condition_end = strtotime ( $shortcode['until'] . ' +1 day - 1 second' );

	$check_sql_day = explode( '-', $check_day );
	if ( count( $check_sql_day ) == 3 ) {
		$check_day = 'date';
	}

	switch ( $check_day ) {
		// Don't just use time() for 'now', as this will effectively make cache duration 1 second.
		// Instead set to previous minute. Events in Google Calendar cannot be set to precision of seconds anyway
		case 'now':

			//$time_unix = strtotime( date_i18n( 'Y-m-d H:i:s' ) ) + $offset_unix;		// "Now" in "Timezone" from WordPress > Settings
			$time_unix = mktime( date_i18n( 'H' ), date_i18n( 'i' ), 0, date_i18n( 'm' ), date_i18n( 'j' ), date_i18n( 'Y' ) ) + $offset_unix ;
			break;
		case 'today':
			//$time_unix = strtotime( date_i18n( 'Y-m-d 00:00:00' ) ) + $offset_unix;		// "Today 00:00" in "Timezone" from WordPress > Settings
			$time_unix = mktime( 0, 0, 0, date_i18n( 'm' ), date_i18n( 'j' ), date_i18n( 'Y' ) ) + $offset_unix ;
			break;
		case 'week':
		case 'week-start':

			$start_of_week = get_wpbm_option( 'wpbm_start_day_weeek' ); //get_option( 'start_of_week' );
			if ( empty( $start_of_week ) )
				$start_of_week = 0;

			$start_day = date_i18n( 'w' ) - $start_of_week ;
			if ( $start_day < 0 )
				$start_day = 7 + $start_day;

			$time_unix = mktime( 0, 0, 0, date_i18n( 'm' ), (   date_i18n( 'j' ) - $start_day ), date_i18n( 'Y' ) ) + $offset_unix ;
			break;
		case 'week-end':

			$start_of_week = get_wpbm_option( 'wpbm_start_day_weeek' ); //get_option( 'start_of_week' );
			if ( empty( $start_of_week ) )
				$start_of_week = 0;

			$start_day = date_i18n( 'w' ) - $start_of_week ;
			if ( $start_day < 0 )
				$start_day = 7 + $start_day;
																														// minus 1 second -- prevent of events exactly ==  start Next period
			$time_unix = mktime( 0, 0, 0, date_i18n( 'm' ), (   date_i18n( 'j' ) - $start_day + 7 ), date_i18n( 'Y' ) ) + $offset_unix - 1;
			break;
		case 'month-start':
			$time_unix =  mktime( 0, 0, 0, date_i18n( 'm' ), 1, date_i18n( 'Y' ) ) + $offset_unix ;
			break;
		case 'month-end':
			$time_unix =  mktime( 0, 0, 0, date_i18n( 'm' ) + 1, 1, date_i18n( 'Y' ) ) + $offset_unix - 1;				// minus 1 second -- prevent of events exactly ==  start Next period
			break;
		case 'year-start':
			$time_unix =  mktime( 0, 0, 0, 1, 1, date_i18n( 'Y' ) ) + $offset_unix ;
			break;
		case 'year-end':
			$time_unix =  mktime( 0, 0, 0, 1, 1, date_i18n( 'Y' ) + 1 ) + $offset_unix - 1;								// minus 1 second -- prevent of events exactly ==  start Next period
			break;
		case 'date':

			if ( intval( $check_sql_day[0] ) - intval( date('Y') ) > 15 ) {                                             //FixIn m.2.0.1
				$time_unix =2145916800;
			} else {
				$time_unix = mktime( 0, 0, 0, intval( $check_sql_day[1] ), intval( $check_sql_day[2] ), intval( $check_sql_day[0] ) );
			}
			break;
		case 'any-start':
			$time_unix =  0;													// any - 1970-01-01 00:00
			break;
		case 'any-end':
			$time_unix =  2145916800;											//any - 2038-01-01 00:00
			break;
		default:
			$time_unix =  2145916800;											//any  END - 2038-01-01 00:00
	}

//debuge($time_unix, date_i18n('Y-m-d H:i:s (D)',$time_unix));


	return $time_unix;
}


//FixIn: 2.0.11.4
/**
 * Get booking ID,  by searching in Booking Calendar by UID
 * @param string $uid
 *
 * @return empty string | int  $booking_id
 */
function wpbm_get_booking_id_by_UID( $uid ){

	$booking_id = array();  //FixIn:  2.0.14.1

	if ( function_exists( 'wpbc_api_get_bookings_arr' ) ) {

/*
		$param = array(
			'wh_booking_datenext'       => 1,
			'wh_booking_dateprior'      => 1,
			'wh_booking_date'           => 3,
			'wh_trash'                  => 'any',
			'wh_modification_dateprior' => 1,
			'wh_modification_date'      => 3,
			'wh_pay_status'             => 'all',

			'wh_booking_type'           => '-999',
			'wh_keyword'                => $uid
		);

		$bookings_arr = wpbc_api_get_bookings_arr( $param );
*/
		global $wpdb;

		$sql = "SELECT booking_id FROM {$wpdb->prefix}booking as bk WHERE bk.sync_gid LIKE '%%" . wpbc_clean_like_string_for_db( $uid ) . "%%'";

		//$sql_escaped = $wpdb->prepare( "SELECT * FROM {$wpdb->prefix}booking as bk WHERE bk.sync_gid LIKE '%%%s%%'", $uid );

		$res = $wpdb->get_results( $sql );

		foreach ( $res as $booking_obj ) {
			$booking_id[] = $booking_obj->booking_id;
		}

//debuge('$bookings_arr',$res);

	}

	return implode( ',', $booking_id );
}

```