FileMaster

Edit File: wpbc-sql.php

<?php /**
 * @version 1.0
 * @package Booking Calendar 
 * @category Data Engine for Booking Listing / Calendar Overview pages
 * @author wpdevelop
 *
 * @web-site https://wpbookingcalendar.com/
 * @email info@wpbookingcalendar.com 
 * 
 * @modified 2015-12-08
 */

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

/** Trick here to  overload default REQUST parameters before page is loading */
function wpbc_define_listing_page_parameters( $page_tag ) {

// $page_tag - here can be all defined in plugin menu pages
    // So  we need to  check activated page. By default its inside of $_GET['page'],

// Execute it only  for Booking Listing & Timeline admin pages.
    //if (  ( isset( $_GET[ 'page' ] ) ) && ( $_GET[ 'page' ] == 'wpbc' )  ) {

if ( wpbc_is_bookings_page() ) {                                            // We are inside of this page. Menu item selected.

// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	    if ( ( isset( $_REQUEST['tab'] ) ) && ( 'vm_booking_listing' === $_REQUEST['tab'] ) ) {             //FixIn: 9.2.0
		    return;
	    }

$booking_default_view_mode = wpbc_get_default_saved_view_mode_for_wpbc_page();
		// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
		if ( ! isset( $_REQUEST['tab'] ) ) {
			$_REQUEST['tab'] = $booking_default_view_mode;                        // Set to REQUEST
		}

// Get saved filters set, (if its not set in request yet), like "tab"  & "view_mode" and overload $_REQUEST
        wpbc_set_default_saved_params_to_request_for_booking_listing( 'default' );
    }
}
// We are set  9  to  execute earlier than hook in WPBC_Admin_Menus
add_action('wpbc_define_nav_tabs', 'wpbc_define_listing_page_parameters', 1  );             // This Hook fire in the class WPBC_Admin_Menus for showing page content of specific menu

////////////////////////////////////////////////////////////////////////////////
// R e q u e s t     S u p p o r t
////////////////////////////////////////////////////////////////////////////////

/**
	 * Get here default View mode saved in a General Booking Settings page or From REQUEST view_mode
 * 
 * @return string = 'vm_calendar' | 'vm_booking_listing'
 */
function wpbc_get_default_saved_view_mode_for_wpbc_page() {

// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	if ( ! isset( $_REQUEST['tab'] ) ) {
		$booking_default_view_mode = get_bk_option( 'booking_listing_default_view_mode' );
	} else {
		$booking_default_view_mode = sanitize_text_field( wp_unslash( $_REQUEST['tab'] ) );  /* phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing */ /* FixIn: sanitize_unslash */
	}

// TODO:2023-05-20 remove it!!.  'vm_booking_listing';.
	if ( ! in_array( $booking_default_view_mode, array( 'vm_calendar', 'vm_booking_listing' ), true ) ) {
		$booking_default_view_mode = 'vm_booking_listing';                                                              // FixIn: 9.2.1 // FixIn: 9.6.3.5.
	}

$booking_default_view_mode = ( 'vm_listing' === $booking_default_view_mode ) ? 'vm_booking_listing' : $booking_default_view_mode;        // FixIn: 9.6.3.5.

return $booking_default_view_mode;             // 'vm_calendar' / 'vm_booking_listing'.
}

/**
	 * Get from SETTINGS (if its not set in request yet) the "tab"  & "view_mode" and set to $_REQUEST
    If we have the "saved" filter set so LOAD it and set to REQUEST, if REQUEST was not set previously
    & skip "wh_booking_type" from the saved filter set
 * 
 * @param string $filter_name - name of saved filter set. Currntly  is using only  one "Default"
 */
function wpbc_set_default_saved_params_to_request_for_booking_listing( $filter_name ) {

// Exclude some parameters from the saved Default parameters - the values of these parameters are loading from General Booking Settings page or from the request.
	$exclude_options_from_saved_params = array(
		'tab',  // Default.
		'page', // From plugin.
		'wh_booking_type', // Default.
		'view_days_num',   // Default.
		'blank_field__this_field_only_for_formatting_buttons',  // Skip this, this parameter for formating purpose in toolbar.
	);

$wpdevbk_filter_params = array();

// Get here default View mode saved in a General Booking Settings page.
	$booking_default_view_mode = wpbc_get_default_saved_view_mode_for_wpbc_page();
	// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	if ( ! isset( $_REQUEST['tab'] ) ) {
		$wpdevbk_filter_params['tab'] = $booking_default_view_mode;
	}
	// 'vm_calendar' / 'vm_booking_listing' ;.
	$_REQUEST['tab'] = $booking_default_view_mode;

// Get here default view_days_num.
	// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	if ( ! isset( $_REQUEST['view_days_num'] ) ) {
		$booking_view_days_num = get_bk_option( 'booking_view_days_num' );
		if ( false !== $booking_view_days_num ) {
			$wpdevbk_filter_params['view_days_num'] = $booking_view_days_num;   // '30'.
			$_REQUEST['view_days_num']              = $booking_view_days_num;
		} else {
			$_REQUEST['view_days_num'] = '365';
		}
	}
}

/**
	 * Clean Request Parameters
 * 
 */
function wpbc_check_request_paramters() {                                       // FixIn: 6.2.1.4.
    
//debuge($_REQUEST);
    $clean_params = array();

$clean_params['wh_booking_id']                  = 'digit_or_csd';
	// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	if ( ( ! empty( $_REQUEST['wh_booking_type'] ) ) && ( 'lost' == $_REQUEST['wh_booking_type'] ) ) {          // FixIn: 8.5.2.19.
		$clean_params['wh_booking_type'] = 'checked_skip_it';
	} else {
		$clean_params['wh_booking_type'] =  'digit_or_csd';
	}
	// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	if ( ( ! empty( $_REQUEST['booking_type'] ) ) && ( 'lost' == $_REQUEST['booking_type'] ) ) {                // FixIn: 8.9.2.1.
		$clean_params['booking_type'] = 'checked_skip_it';
	} else {
		$clean_params['booking_type'] =  'digit_or_csd';
	}

$clean_params['wh_approved']                    = 'digit_or_csd';       // '0' | '1' | ''

$clean_params['wh_booking_date']                = 'digit_or_date';      // number | date 2016-07-20
    $clean_params['wh_booking_date2']               = 'digit_or_date';      // number | date 2016-07-20
    $clean_params['wh_booking_datenext']            = 'd';                  // '1' | '2' ....
    $clean_params['wh_booking_dateprior']           = 'd';                  // '1' | '2' ....
    $clean_params['wh_booking_datefixeddates']      = 'digit_or_date';      // number | date 2016-07-20
    $clean_params['wh_booking_date2fixeddates']     = 'digit_or_date';      // number | date 2016-07-20

$clean_params['wh_is_new']                      = 'd';                  // '1' | ''

$clean_params['wh_modification_date']           = 'digit_or_date';      // number | date 2016-07-20
    $clean_params['wh_modification_date2']          = 'digit_or_date';      // number | date 2016-07-20
    $clean_params['wh_modification_dateprior']      = 'd';                  // '1' | '2' ....
    $clean_params['wh_modification_datefixeddates'] = 'digit_or_date';      // number | date 2016-07-20
    $clean_params['wh_modification_date2fixeddates']= 'digit_or_date';      // number | date 2016-07-20

$clean_params['wh_keyword']                     = 's';                  //string

$clean_params['wh_pay_statuscustom']            = 's';                      //string   !!! LIKE  !!!
    $clean_params['wh_pay_status']                  = array('all', 'group_ok', 'group_unknown', 'group_pending', 'group_failed');

$clean_params['wh_cost']                        = 'd';                  // '1' | ''
    $clean_params['wh_cost2']                       = 'd';                  // '1' | ''
    
    $clean_params['or_sort']                        = array('', 'sort_date', 'booking_type', 'cost', 'booking_id_asc', 'sort_date_asc', 'booking_type_asc', 'cost_asc');
    $clean_params['wh_trash']                       = array('0' , 'trash', 'any');

$clean_params['page_num']                       = 'd';                  // '' | '1' ...         // does not exist  in 6.2.1.4
    $clean_params['page_items_count']               = 'd';                  // '' | '1' ...         // does not exist  in 6.2.1.4
    $clean_params['view_days_num']               = 'd';                  // '' | '1' ...         // does not exist  in 6.2.1.4

// FixIn: 8.9.2.1.
	$clean_params['scroll_start_date']     = 'digit_or_date';
	$clean_params['scroll_day']            = 'd';
	$clean_params['scroll_month']          = 'd';
	$clean_params['limit_hours']           = 'digit_or_csd';
	$clean_params['only_booked_resources'] = 'd';

foreach ( $clean_params as $request_key => $clean_type ) {
        
        // elements only listed in array::
        if (  is_array( $clean_type ) ) {                                       // check  only values from  the list  in this array
            
            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
            if ( ( isset( $_REQUEST[ $request_key ] ) ) &&  ( ! in_array( $_REQUEST[ $request_key ], $clean_type ) ) )
                $clean_type = 's';    
            else 
                $clean_type = 'checked_skip_it';
        } 
        
        switch ( $clean_type ) {

case 'checked_skip_it':

break;

case 'digit_or_date':                                            // digit or comma separated digit
				// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( isset( $_REQUEST[ $request_key ] ) ) {
					$_REQUEST[ $request_key ] = wpbc_clean_digit_or_date( $_REQUEST[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Missing, WordPress.Security.NonceVerification.Recommended, WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
	            }
	            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( isset( $_GET[ $request_key ] ) ) {
		            $_GET[ $request_key ] = wpbc_clean_digit_or_date( $_GET[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Missing, WordPress.Security.NonceVerification.Recommended, WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
	            }
	            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( isset( $_POST[ $request_key ] ) ) {
		            $_POST[ $request_key ] = wpbc_clean_digit_or_date( $_POST[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Missing, WordPress.Security.NonceVerification.Recommended, WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
	            }

break;

case 'digit_or_csd':                                            // digit or comma separated digit
	            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( isset( $_REQUEST[ $request_key ] ) ) {
		            $_REQUEST[ $request_key ] = wpbc_clean_digit_or_csd( $_REQUEST[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Missing, WordPress.Security.NonceVerification.Recommended, WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
	            }
	            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( isset( $_GET[ $request_key ] ) ) {
		            $_GET[ $request_key ] = wpbc_clean_digit_or_csd( $_GET[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Missing, WordPress.Security.NonceVerification.Recommended, WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
	            }
	            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( isset( $_POST[ $request_key ] ) ) {
		            $_POST[ $request_key ] = wpbc_clean_digit_or_csd( $_POST[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Missing, WordPress.Security.NonceVerification.Recommended, WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
	            }

break;

case 's':                                                       // string
	            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( isset( $_REQUEST[ $request_key ] ) ) {
		            $_REQUEST[ $request_key ] = wpbc_clean_like_string_for_db( $_REQUEST[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Missing, WordPress.Security.NonceVerification.Recommended, WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
	            }
	            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( isset( $_GET[ $request_key ] ) ) {
		            $_GET[ $request_key ] = wpbc_clean_like_string_for_db( $_GET[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Missing, WordPress.Security.NonceVerification.Recommended, WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
	            }
	            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( isset( $_POST[ $request_key ] ) ) {
		            $_POST[ $request_key ] = wpbc_clean_like_string_for_db( $_POST[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Missing, WordPress.Security.NonceVerification.Recommended, WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
	            }

break;

case 'd':                                                       // digit
	            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( ( isset( $_REQUEST[ $request_key ] ) ) && ( $_REQUEST[ $request_key ] !== '' ) ) {
		            $_REQUEST[ $request_key ] = intval( $_REQUEST[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            }
	            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( ( isset( $_GET[ $request_key ] ) ) && ( $_GET[ $request_key ] !== '' ) ) {
		            $_GET[ $request_key ] = intval( $_GET[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            }
	            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( ( isset( $_POST[ $request_key ] ) ) && ( $_POST[ $request_key ] !== '' ) ) {
		            $_POST[ $request_key ] = intval( $_POST[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            }

break;

default:
	            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( isset( $_REQUEST[ $request_key ] ) ) {
		            $_REQUEST[ $request_key ] = intval( $_REQUEST[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            }
	            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( isset( $_GET[ $request_key ] ) ) {
		            $_GET[ $request_key ] = intval( $_GET[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            }
	            // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            if ( isset( $_POST[ $request_key ] ) ) {
		            $_POST[ $request_key ] = intval( $_POST[ $request_key ] );  // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	            }
                break;
        }

}

//debuge($_REQUEST);
}

// FixIn: 9.6.3.5.

/**
	 * Get array of cleaned (limited number) paramas from REQUEST
 * 
 * @return array
 */
function wpbc_get_clean_paramas_from_request_for_timeline() {
  
    
        // Reset
        $start_year = gmdate("Y");            //2012
        $start_month = gmdate("m");           //09
        $start_day = 1;//date("d");//1;     //31
        // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
        if (! empty($_REQUEST['scroll_start_date'])) {   // scroll_start_date=2013-07-01
			$scroll_start_date = explode( '-', $_REQUEST['scroll_start_date'] );  // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing, WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
            
            $start_year     = $scroll_start_date[0];            //2012
            $start_month    = $scroll_start_date[1];           //09
            $start_day      = $scroll_start_date[2];    //date("d");//1;     //31
        } 
        
        $scroll_day     = 0;
        $scroll_month   = 0;

// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
        if (isset($_REQUEST['view_days_num']))  $view_days_num = sanitize_text_field( wp_unslash( $_REQUEST['view_days_num'] ) );  /* phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing */ /* FixIn: sanitize_unslash */
        else                                    $view_days_num = get_bk_option( 'booking_view_days_num');
        
          // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing, WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
        if  ((isset($_REQUEST['wh_booking_type'])) && ( strpos($_REQUEST['wh_booking_type'], ',') !== false ) )
                $is_show_resources_matrix = true;
        else    $is_show_resources_matrix = false;

if ($is_show_resources_matrix) {
            
            switch ($view_days_num) {
                
                case '1':
                    // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
                    if (empty($_REQUEST['scroll_start_date']))  $start_day = gmdate("d");
                    // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
                    if (isset($_REQUEST['scroll_day'])) $scroll_day = sanitize_text_field( wp_unslash( $_REQUEST['scroll_day'] ) );  /* phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing */ /* FixIn: sanitize_unslash */

$real_date = mktime( 0, 0, 0, intval( $start_month ), ( intval( $start_day ) + intval( $scroll_day ) ), intval( $start_year ) );
                    $wh_booking_date  = gmdate("Y-m-d", $real_date);                          // '2012-11-29';

$real_date = mktime( 0, 0, 0, intval( $start_month ), ( intval( $start_day ) + intval( $scroll_day ) ), intval( $start_year ) );
                    $wh_booking_date2 = gmdate("Y-m-d", $real_date);                          // '2013-12-3';
                    break;
                    
                case '7':
                    // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
                    if (empty($_REQUEST['scroll_start_date']))  $start_day = gmdate("d");
                    $start_week_day_num = gmdate("w");
                    $start_day_weeek  = esc_js(get_bk_option( 'booking_start_day_weeek' )); //[0]:Sun .. [6]:Sut
                    if ($start_week_day_num != $start_day_weeek) {
                        for ($d_inc = 1; $d_inc < 8; $d_inc++) {                // Just get week  back
	                        $real_date = mktime( 0, 0, 0, intval( $start_month ), ( intval( $start_day ) - intval( $d_inc ) ), intval( $start_year ) );
                            $start_week_day_num = gmdate("w", $real_date);
                            if ($start_week_day_num == $start_day_weeek) {
                                $start_day = gmdate("d", $real_date);
                                $start_year = gmdate("Y", $real_date);
                                $start_month = gmdate("m", $real_date);
                                $d_inc=9;
                            }
                        }
                    }
                    
                    // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
                    if (isset($_REQUEST['scroll_day'])) $scroll_day = sanitize_text_field( wp_unslash( $_REQUEST['scroll_day'] ) );  /* phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing */ /* FixIn: sanitize_unslash */

$real_date = mktime( 0, 0, 0, intval( $start_month ), ( intval( $start_day ) + 7 + intval( $scroll_day ) ), intval( $start_year ) );
                    $wh_booking_date2 = gmdate("Y-m-d", $real_date);                          // '2012-12-7';
                    break;
                    
                case '30':
                    // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
                    if (isset($_REQUEST['scroll_month'])) $scroll_month = sanitize_text_field( wp_unslash( $_REQUEST['scroll_month'] ) );  /* phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing */ /* FixIn: sanitize_unslash */

$real_date = mktime( 0, 0, 0, ( intval( $start_month ) + intval( $scroll_month ) ), intval( $start_day ), intval( $start_year ) );
                    $wh_booking_date  = gmdate("Y-m-d", $real_date);                          // '2012-12-01';

$real_date = mktime( 0, 0, 0, ( intval( $start_month ) + 1 + intval( $scroll_month ) ), ( intval( $start_day ) - 1 ), intval( $start_year ) );
                    $wh_booking_date2 = gmdate("Y-m-d", $real_date);                          // '2012-12-31';
                    break;
                    
                case '60':
                    // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
                    if (isset($_REQUEST['scroll_month'])) $scroll_month = sanitize_text_field( wp_unslash( $_REQUEST['scroll_month'] ) );  /* phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing */ /* FixIn: sanitize_unslash */

$real_date = mktime( 0, 0, 0, ( intval( $start_month ) + 2 + intval( $scroll_month ) ), ( intval( $start_day ) - 1 ), intval( $start_year ) );
                    $wh_booking_date2 = gmdate("Y-m-d", $real_date);                          // '2013-02-31';
                    break;
                    
////////////////////////////////////////////////////////////////////////////////
                default:  // 30 - default
                    // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
                    if (isset($_REQUEST['scroll_month'])) $scroll_month = sanitize_text_field( wp_unslash( $_REQUEST['scroll_month'] ) );  /* phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing */ /* FixIn: sanitize_unslash */

// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
                    if (empty($_REQUEST['scroll_start_date'])) $start_day = gmdate("d");
                    $start_week_day_num = gmdate("w");
                    $start_day_weeek  = esc_js(get_bk_option( 'booking_start_day_weeek' )); //[0]:Sun .. [6]:Sut

if ($start_week_day_num != $start_day_weeek) {
                        for ($d_inc = 1; $d_inc < 8; $d_inc++) {                // Just get week  back
	                        $real_date = mktime( 0, 0, 0, intval( $start_month ), ( intval( $start_day ) - intval( $d_inc ) ), intval( $start_year ) );
                            $start_week_day_num = gmdate("w", $real_date);
                            if ($start_week_day_num == $start_day_weeek) {
                                $start_day = gmdate("d", $real_date);
                                $start_year = gmdate("Y", $real_date);
                                $start_month = gmdate("m", $real_date);
                                $d_inc=9;
                                //break;
                            }
                        }
                    }

// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
                    if (isset($_REQUEST['scroll_day'])) $scroll_day = sanitize_text_field( wp_unslash( $_REQUEST['scroll_day'] ) );  /* phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing */ /* FixIn: sanitize_unslash */

$real_date = mktime( 0, 0, 0, intval( $start_month ), ( intval( $start_day ) + 7 * 12 + 7 + intval( $scroll_day ) ), intval( $start_year ) );
                    $wh_booking_date2 = gmdate("Y-m-d", $real_date);                          // '2013-12-31';
                    break;

case '30':
                    // phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
                    if (empty($_REQUEST['scroll_start_date'])) $start_day = gmdate("d");

$real_date = mktime( 0, 0, 0, intval( $start_month ), ( intval( $start_day ) + 31 + intval( $scroll_day ) ), intval( $start_year ) );
                    $wh_booking_date2 = gmdate("Y-m-d", $real_date);                          // '2013-12-31';
                    break;

default:  // 365

// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
                    if (isset($_REQUEST['scroll_month'])) $scroll_month = sanitize_text_field( wp_unslash( $_REQUEST['scroll_month'] ) );  /* phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing */ /* FixIn: sanitize_unslash */
                    else $scroll_month = 0;

$real_date = mktime( 0, 0, 0, ( intval( $start_month ) + intval( $scroll_month ) + 13 ), ( intval( $start_day ) - 1 ), intval( $start_year ) );
                    $wh_booking_date2 = gmdate("Y-m-d", $real_date);                          // '2013-12-31';

break;
            }
        }
        
        
        $or_sort = '' ;

$args = array(
		// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing, WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
		'wh_booking_type'       => ( isset( $_REQUEST['wh_booking_type'] ) ) ? $_REQUEST['wh_booking_type'] : '',
		'wh_approved'           => '', // Any.
		'wh_booking_id'         => '', // Any.
		'wh_is_new'             => '', // (isset($_REQUEST['wh_is_new']))?$_REQUEST['wh_is_new']:'',                   ?.
		'wh_pay_status'         => 'all', // (isset($_REQUEST['wh_pay_status']))?$_REQUEST['wh_pay_status']:'',          // ?.
		'wh_keyword'            => '', // (isset($_REQUEST['wh_keyword']))?$_REQUEST['wh_keyword']:'',                // ?.
		'wh_booking_date'       => $wh_booking_date,
		'wh_booking_date2'      => $wh_booking_date2,
		'wh_modification_date'  => '3', // (isset($_REQUEST['wh_modification_date']))?$_REQUEST['wh_modification_date']:'',     // ?
		'wh_modification_date2' => '', // (isset($_REQUEST['wh_modification_date2']))?$_REQUEST['wh_modification_date2']:'',   // ?
		'wh_cost'               => '', // (isset($_REQUEST['wh_cost']))?$_REQUEST['wh_cost']:'',                      // ?
		'wh_cost2'              => '', // (isset($_REQUEST['wh_cost2']))?$_REQUEST['wh_cost2']:'',                    // ?
		'or_sort'               => $or_sort,
		'page_num'              => '1',
		'page_items_count'      => '100000',
	);

return $args;
}

/** Set initial $_REQUEST['view_days_num'] depend on from selected booking resources  */
function wpbc_set_request_params_for_timeline() {

// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing, WordPress.Security.ValidatedSanitizedInput.MissingUnslash, WordPress.Security.ValidatedSanitizedInput.InputNotSanitized
	if ( ( isset( $_REQUEST['wh_booking_type'] ) ) && ( strpos( $_REQUEST['wh_booking_type'], ',' ) !== false ) ) {
		$is_show_resources_matrix = true;
	} else {
		$is_show_resources_matrix = false;
	}

// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	if ( ! isset( $_REQUEST['view_days_num'] ) ) {
		$_REQUEST['view_days_num'] = get_bk_option( 'booking_view_days_num' );
	}

// We do not have the Year (365) and (90) view modes in the Matrix mode so  we are set to the closest variant. And the same backward.
	if ( ( $is_show_resources_matrix ) ) { // Switching from the Single to Matrix mode.
		// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
		if ( isset( $_REQUEST['view_days_num'] ) && ( $_REQUEST['view_days_num']  == '365' ) ) {
			$_REQUEST['view_days_num'] = 60;
		}
		// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
		if ( isset( $_REQUEST['view_days_num'] ) && ( $_REQUEST['view_days_num']  == '90' ) ) {
			$_REQUEST['view_days_num'] = 7;
		}
	} else { // Switching from the Matrix to Single  mode.
		// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
		if ( isset( $_REQUEST['view_days_num'] ) && ( $_REQUEST['view_days_num']  == '60' ) ) {
			$_REQUEST['view_days_num'] = 365;
		}
		// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
		if ( ( $_REQUEST['view_days_num'] == '7' ) || ( $_REQUEST['view_days_num'] == '1' ) ) {
			$_REQUEST['view_days_num'] = 30;
		}
	}
}

/** Define default booking resource to $_GET request and check if user can  be here in MU version. */
function wpbc_set_default_resource_to__get() {

// phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing
	if ( isset( $_GET['booking_type'] ) ) {

// Check if User can be here in MultiUser version for this booking resource (is this user owner of this resource or not).
		if ( class_exists( 'wpdev_bk_multiuser' ) ) {

$default_booking_resource = sanitize_text_field( wp_unslash( $_GET['booking_type'] ) );  /* phpcs:ignore WordPress.Security.NonceVerification.Recommended, WordPress.Security.NonceVerification.Missing */ /* FixIn: sanitize_unslash */

// Check if this MU user activated or superadmin,  otherwise show warning.
			if ( ! wpbc_is_mu_user_can_be_here( 'activated_user' ) ) {
				return false;
			}

// Check if this MU user owner of this resource or superadmin,  otherwise show warning.
			if ( ! wpbc_is_mu_user_can_be_here( 'resource_owner', $default_booking_resource ) ) {
				return false;
			}
		}
	} else {                                                                    // Set default booking resource to  $_GET.

// Get ID of default booking resource, or return false (in case if user have no access to  this resource and show some warnings).
		$default_booking_resource = wpbc_get_default_resource();

if ( empty( $default_booking_resource ) ) {

return false;                                                      // User can  not be here, Warnings have shown.

} else {

$_GET['booking_type'] = $default_booking_resource;
		}

// Check if this resource parent and has some additional childs, if yes then assign $_ GET['parent_res'] = 1  only  in case,  if its for loading default booking resource.
		make_bk_action( 'check_if_bk_res_parent_with_childs_set_parent_res', $default_booking_resource );
	}

return true;
}

/**
 * Get ID of default booking resource, or return false (in case if user have no access to  this resource and show some warnings).
 *
 * @return boolean|int
 */
function wpbc_get_default_resource() {

if ( ! class_exists( 'wpdev_bk_personal' ) ) {
		return 1;
	}                                                                                       // Free, i.e., default 1.

// Get assigned default booking resource from  General Booking Settings page.
	$default_booking_resource = get_bk_option( 'booking_default_booking_resource' );        // If empty, i.e., "" - its all  resources - no default booking resource.

if ( empty( $default_booking_resource ) ) { // We do  not have default resource.

// Get first resource in a list.
		// If its MU, then  for superadmin get first resource in a list OR if user DO NOT have resources get FIRST resource in LIST FROM ALL resources.
		$default_booking_resource = get__default_type();
	}

// MU.
	if ( class_exists( 'wpdev_bk_multiuser' ) ) {

// Check if this MU user activated or superadmin,  otherwise show warning.
		if ( ! wpbc_is_mu_user_can_be_here( 'activated_user' ) ) {
			return false;
		}

// Check if this MU user owner of this resource or superadmin,  otherwise show warning.
		if ( ! wpbc_is_mu_user_can_be_here( 'resource_owner', $default_booking_resource ) ) {
			return false;
		}
	}

return $default_booking_resource;
}

/** Get list of all booking resources.
 *
 * @return array (
		            [1] => Array (
				                    [title] => Default [parent resource]
				                    [attr] => Array (
		                                                [class] => wpbc_parent_resource
		                                            )
		                )
		            [5] => Array (
		                            [title] =>      Default-1
		                            [attr] => Array (
						                            [class] => wpbc_child_resource
						                        )
		                )
		            [6] => Array (  ...
 */
function wpbc_get_all_booking_resources_list(){                                                                         //FixIn: 8.1.3.5.2

if ( ! class_exists( 'wpdev_bk_personal' ) ) {
		return array();
	}

$resources_cache = wpbc_br_cache();                                     // Get booking resources from  cache

$resource_objects = $resources_cache->get_resources();
	// $resource_objects = $resources_cache->get_single_parent_resources();

//$resource_options = $params['resources'];
	$resource_options = array();    // FixIn: 8.2.1.12.

foreach ( $resource_objects as $br ) {

$br_option          = array();
		$br_option['title'] = wpbc_lang( $br['title'] );

if ( ( isset( $br['parent'] ) ) && ( $br['parent'] == 0 ) && ( isset( $br['count'] ) ) && ( $br['count'] > 1 ) ) {
			$br_option['title'] .= ' [' . __( 'parent resource', 'booking' ) . ']';
		}

$br_option['attr']          = array();
		$br_option['attr']['class'] = 'wpbc_single_resource';
		if ( isset( $br['parent'] ) ) {
			if ( $br['parent'] == 0 ) {
				if ( ( isset( $br['count'] ) ) && ( $br['count'] > 1 ) ) {
					$br_option['attr']['class'] = 'wpbc_parent_resource';
				}
			} else {
				$br_option['attr']['class'] = 'wpbc_child_resource';
			}
		}

$sufix = '';

$resource_options[ $br['id'] . $sufix ] = $br_option;

if ( $resource_options[ $br['id'] ]['attr']['class'] === 'wpbc_child_resource' ) {
			$resource_options[ $br['id'] ]['title'] = ' &nbsp;&nbsp;&nbsp; ' . $resource_options[ $br['id'] ]['title'];
		}
	}

return $resource_options;
}

//////////////////////////////////////////////////////////////////////////////// 
//   S u p p o r t 
////////////////////////////////////////////////////////////////////////////////

/**
	 * Check if current WP user can be here
 * Checking if the user activated,  and booking resource belong to  specific user
 * 
 * @param string $check_condition   'activated_user' | 'resource_owner' | 'only_super_admin'
 * @param string $booking_resource - Optional. ID of booking resource for 'resource_owner' condition
 * @return boolean
 */
function wpbc_is_mu_user_can_be_here( $check_condition,  $booking_resource  = '' ) {
    
    $is_can = true;
    
    if ( $check_condition == 'activated_user' )
        $is_can = apply_bk_filter( 'multiuser_is_user_can_be_here', true, 'check_for_active_users' );
    
    if ( $check_condition == 'only_super_admin' )
        $is_can = apply_bk_filter( 'multiuser_is_user_can_be_here', true, 'only_super_admin' );
            
    if ( $check_condition == 'resource_owner' )        
        $is_can = apply_bk_filter( 'multiuser_is_user_can_be_here', true, $booking_resource );
    
    return $is_can;

}

////////////////////////////////////////////////////////////////////////////////
// E n g i n e     B o o k i n g    L i s t i n g
////////////////////////////////////////////////////////////////////////////////

/**
	 * E n g i n e   for getting Bookings objects for Booking Listing pages
 * 
 * @param array $args  - Request paramters from filters
 * @return array(
                    'bookings' => $bookings
                    , 'resources' => $booking_types
                    , 'bookings_count' => $bookings_count
                    , 'page_num' => $page_num
                    , 'count_per_page' => $page_items_count
                );     
 */
function wpbc_get_bookings_objects( $args ){
    
    global $wpdb;

// Initial  variables //////////////////////////////////////////////////////

$sql_boking_listing = wpbc_get_sql_for_booking_listing( $args );
    $sql_start_count    = $sql_boking_listing[ 'sql_start_count' ];
    $sql_start_select   = $sql_boking_listing[ 'sql_start_select' ];
    $sql                = $sql_boking_listing[ 'sql' ];
    $sql_where          = $sql_boking_listing[ 'where' ];
    $sql_order          = $sql_boking_listing[ 'order' ];
    $sql_limit          = $sql_boking_listing[ 'limit' ];

$num_per_page_check = 10;
    $defaults = array(
          'wh_booking_type' => ''
        , 'wh_approved' => ''
        , 'wh_booking_id' => ''
        , 'wh_is_new' => ''
        , 'wh_pay_status' => ''
        , 'wh_keyword' => ''
        , 'wh_booking_date' => ''
        , 'wh_booking_date2' => ''
        , 'wh_modification_date' => ''
        , 'wh_modification_date2' => ''
        , 'wh_cost' => ''
        , 'wh_cost2' => ''
        , 'or_sort' => ''
        , 'page_num' => '1'
        , 'wh_trash' => ''                                                      // FixIn: 6.1.1.10.
        , 'page_items_count' => ( ( empty( $num_per_page_check ) ) ? '10' : $num_per_page_check )
    );

$r = wp_parse_args( $args, $defaults );
    
    $r = apply_filters( 'wpbc_request_params_for_get_booking_obj', $r );               // FixIn: 7.0.1.41.

extract( $r, EXTR_SKIP );

$page_start = ( $page_num - 1 ) * $page_items_count;

//debuge( $sql_start_select . $sql . $sql_where . $sql_order . $sql_limit );
    
	// -----------------------------------------------------------------------------------------------------------------
	// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared
	$bookings_res = $wpdb->get_results( $sql_start_select . $sql . $sql_where . $sql_order . $sql_limit );              // Get Bookings.

// phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery, WordPress.DB.DirectDatabaseQuery.NoCaching, WordPress.DB.PreparedSQL.NotPrepared
	$bookings_count = $wpdb->get_results( $sql_start_count . $sql . $sql_where );                                       // Get Number of bookings.

$bookings_count = ( ( count( $bookings_count ) > 0 ) ? $bookings_count[0]->count : 0 );
    
    $booking_types = apply_bk_filter( 'wpdebk_get_keyed_all_bk_resources', array() );                           // Get Resources

// -----------------------------------------------------------------------------------------------------------------
    $booking_id_list    = array();                                              // ID list of ALL bookings
    $bookings           = array();
    $short_days         = array();
    $short_days_type_id = array();

foreach ( $bookings_res as $booking ) {

if ( ! in_array( $booking->booking_id, $booking_id_list ) )
            $booking_id_list[] = $booking->booking_id;

$bookings[$booking->booking_id] = $booking;
        $bookings[$booking->booking_id]->dates = array();
        $bookings[$booking->booking_id]->dates_short = array();

$bk_list_type = (isset( $booking->booking_type )) ? $booking->booking_type : '1';

if ( ( isset( $booking->sync_gid ) ) && (!empty( $booking->sync_gid )) ) {
            $booking->form .= "~text^sync_gid{$booking->booking_type}^{$booking->sync_gid}";
        }

$cont = wpbc__legacy__get_form_content_arr(   $booking->form
                                    , $bk_list_type
                                    , ''
                                    , array( 
                                            'booking_id'     => $booking->booking_id
                                          , 'resource_title' => (isset( $booking_types[$booking->booking_type] )) ? $booking_types[$booking->booking_type] : ''
                                        )
                                );

$search  = array( "'(<br[ ]?[/]?>)+'si", "'(<[/]?p[ ]?>)+'si"/*, "'(<[/]?div[ ]?>)+'si"*/ );                        // FixIn: 8.8.1.6.
        $replace = array( "&nbsp;&nbsp;", " &nbsp; ", " &nbsp; " );
        $cont['content'] = preg_replace( $search, $replace, $cont['content'] );

$bookings[$booking->booking_id]->form_show = $cont['content'];
        unset( $cont['content'] );
        $bookings[$booking->booking_id]->form_data = $cont;
    }
    $booking_id_list = implode( ",", $booking_id_list );
    $booking_id_list = wpbc_clean_like_string_for_db( $booking_id_list );

// -----------

if ( ! empty( $booking_id_list ) ) {                                                                                // Get Dates for all our Bookings.
		$sql = "SELECT *
                FROM {$wpdb->prefix}bookingdates as dt
                WHERE dt.booking_id in ( {$booking_id_list} ) ";

if ( class_exists( 'wpdev_bk_biz_l' ) ) {
			$sql .= ' ORDER BY booking_id, type_id, booking_date ';
		} else {
			$sql .= ' ORDER BY booking_id, booking_date ';
		}

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

} else {
		$booking_dates = array();
	}

// -------------

$last_booking_id = '';
    
    foreach ( $booking_dates as $date ) {                                       // Add Dates to Bookings array
        
        $bookings[ $date->booking_id ]->dates[] = $date;

if ( $date->booking_id != $last_booking_id ) {
            if ( !empty( $last_booking_id ) ) {
                if ( $last_show_day != $dte ) {
                    $short_days[] = $dte;
                    $short_days_type_id[] = $last_day_id;
                }

$bookings[$last_booking_id]->dates_short = $short_days;
                $bookings[$last_booking_id]->dates_short_id = $short_days_type_id;
            }
            $last_day = '';
            $last_day_id = '';
            $last_show_day = '';
            $short_days = array();
            $short_days_type_id = array();
        }

$last_booking_id = $date->booking_id;
        $dte = $date->booking_date;

if ( empty( $last_day ) ) { // First date
            $short_days[] = $dte;
            $short_days_type_id[] = (isset( $date->type_id )) ? $date->type_id : '';
            $last_show_day = $dte;
        } else {                // All other days
            //if ( wpbc_is_next_day( $dte, $last_day ) ) {
			$next_day_if__check_in__then__check_out = true;
			if ( wpbc_is_less_than_next_day( $dte, $last_day, $next_day_if__check_in__then__check_out ) ) {
                if ( $last_show_day != '-' ) {
                    $short_days[] = '-';
                    $short_days_type_id[] = '';
                }
                $last_show_day = '-';
            } else {
                if ( $last_show_day != $last_day ) {
                    $short_days[] = $last_day;
                    $short_days_type_id[] = $last_day_id;
                }
                $short_days[] = ',';
                $short_days_type_id[] = '';
                $short_days[] = $dte;
                $short_days_type_id[] = (isset( $date->type_id )) ? $date->type_id : '';
                $last_show_day = $dte;
            }
        }
        $last_day = $dte;
        $last_day_id = (isset( $date->type_id )) ? $date->type_id : '';
    }

if ( isset( $dte ) )
        if ( $last_show_day != $dte ) {
            $short_days[] = $dte;
            $short_days_type_id[] = (isset( $date->type_id )) ? $date->type_id : '';
        }
    if ( isset( $bookings[$last_booking_id] ) ) {
        $bookings[$last_booking_id]->dates_short = $short_days;
        $bookings[$last_booking_id]->dates_short_id = $short_days_type_id;
    }

//debuge( 'Before filtering:',  gmdate('Y-m-d', time() +86400 ), $_REQUEST, $bookings ) ;

// -----------------------------------------------------------------------------------------------------------------
    // Filter some bookings
	// -----------------------------------------------------------------------------------------------------------------
    // Showing only  bookings that starting or ending during "Today"            ( Today check in/out )
    if ( (isset( $args['wh_booking_date'] )) && ($args['wh_booking_date'] == '9') ) {

$today_mysql_format = date_i18n( 'Y-m-d', time() + ( get_option( 'gmt_offset' ) * HOUR_IN_SECONDS ) + 0 * DAY_IN_SECONDS ); // Today day with gmt offset
        
        foreach ( $bookings as $bc_id => $bc_value ) {

$check_in_date = $bc_value->dates_short[0];
            $check_in_date = explode( ' ', $check_in_date );
            $check_in_date = $check_in_date[0];                                 // 2014-02-25

if ( count( $bc_value->dates_short ) == 1 )
                $check_out_date = $bc_value->dates_short[0];
            else
                $check_out_date = $bc_value->dates_short[2];
            $check_out_date = explode( ' ', $check_out_date );
            $check_out_date = $check_out_date[0];                               // 2014-02-25

if ( ( $today_mysql_format != $check_in_date ) && ( $today_mysql_format != $check_out_date ) ) {
                unset( $bookings[$bc_id] );
                $bookings_count--;
            }
        }
    }

// If we selected the Dates as "Check In - Today/Tommorow", then show only the bookings, where check in date is Today 
    if ( (isset( $args['wh_booking_date'] )) && ($args['wh_booking_date'] == '7') ) {
        //$today_mysql_format = gmdate('Y-m-d');
        //$today_mysql_format = gmdate('Y-m-d', time() +86400 );                  // 1 Day = 24*60*60 = 86400
        $today_mysql_format = date_i18n( 'Y-m-d', time() + ( get_option( 'gmt_offset' ) * HOUR_IN_SECONDS ) + DAY_IN_SECONDS ); // Tommorow day with gmt offset
        foreach ( $bookings as $bc_id => $bc_value ) {
            $check_in_date = $bc_value->dates_short[0];
            $check_in_date = explode( ' ', $check_in_date );
            $check_in_date = $check_in_date[0]; // 2014-02-25
            if ( $today_mysql_format != $check_in_date ) {
                unset( $bookings[$bc_id] );
                $bookings_count--;
            }
        }
    }

// If we selected the Dates as "Check Out - Tomorow", then show only the bookings, where check out date is Tomorrow .
	if ( ( isset( $args['wh_booking_date'] ) ) && ( 8 === intval( $args['wh_booking_date'] ) ) ) {

$tomorrow_mysql_format = date_i18n( 'Y-m-d', time() + ( get_option( 'gmt_offset' ) * HOUR_IN_SECONDS ) + DAY_IN_SECONDS ); // Tommorow day with gmt offset.
		foreach ( $bookings as $bc_id => $bc_value ) {
			if ( count( $bc_value->dates_short ) === 1 ) {
				$check_out_date = $bc_value->dates_short[0];
			} else {
				$check_out_date = $bc_value->dates_short[2];
			}
			$check_out_date = explode( ' ', $check_out_date );
			$check_out_date = $check_out_date[0];                               // 2014-02-25
			if ( $tomorrow_mysql_format !== $check_out_date ) {
				unset( $bookings[ $bc_id ] );
				--$bookings_count;
			}
		}
	}

$return_booking_structure = array(
		'bookings'       => $bookings,
		'resources'      => $booking_types,
		'bookings_count' => $bookings_count,
		'page_num'       => $page_num,
		'count_per_page' => $page_items_count,
	);

return $return_booking_structure;
}

////////////////////////////////////////////////////////////////////////////////
// S Q L 
////////////////////////////////////////////////////////////////////////////////

/**
	 * Get   S Q L    for bookings at Booking Listing page
 * 
 * @param array $args   - Request paramters from filters
 * @return array        - Get array with SQL for getting bookings
 */
function wpbc_get_sql_for_booking_listing( $args ){

global $wpdb;
    
    $num_per_page_check = 10;

$defaults = array(
          'wh_booking_type' => ''
        , 'wh_approved' => ''
        , 'wh_booking_id' => ''
        , 'wh_is_new' => ''
        , 'wh_pay_status' => ''
        , 'wh_keyword' => ''
        , 'wh_booking_date' => ''
        , 'wh_booking_date2' => ''
        , 'wh_modification_date' => ''
        , 'wh_modification_date2' => ''
        , 'wh_cost' => ''
        , 'wh_cost2' => ''
        , 'or_sort' => ''
        , 'page_num' => '1'
        , 'wh_trash' => ''                                                      // FixIn: 6.1.1.10.
        , 'wh_sync_gid' => ''                                       // '' | 'imported' | 'plugin'                       // FixIn: 8.8.3.19.
        , 'page_items_count' => $num_per_page_check
    );
    $r = wp_parse_args( $args, $defaults );
    extract( $r, EXTR_SKIP );

$page_start = ( $page_num - 1 ) * $page_items_count;

$posible_sorts = array( 'booking_id_asc', 'sort_date', 'sort_date_asc', 'booking_type', 'booking_type_asc', 'cost', 'cost_asc' );
    
    if ( ($or_sort == '') || ($or_sort == 'id') || ( !in_array( $or_sort, $posible_sorts ) ) ) 
            $or_sort = 'booking_id';

////////////////////////////////////////////////////////////////////////
    // S Q L
    ////////////////////////////////////////////////////////////////////////    
    $sql_start_select = " SELECT * ";
    $sql_start_count  = " SELECT COUNT(*) as count";
    $sql              = " FROM {$wpdb->prefix}booking as bk";                   // GET ONLY ROWS OF THE     B o o k i n g s    - So we can limit the requests
    
//debuge($wh_trash);        
                                                                                //FixIn: 6.1.1.10  - check also  below usage of {$trash_bookings}
    $trash_bookings = " AND bk.trash = 0 ";
    if ( isset( $wh_trash ) ) {

if ( $wh_trash == "trash" )    $trash_bookings = " AND bk.trash = 1 ";            
        else if ( $wh_trash == "any" ) $trash_bookings = '';   
    }
//debuge($trash_bookings);
    
    if ( empty( $wh_booking_id ) ) {
        
        $sql_where =    " WHERE " .                                             // Date (single) connection (Its required for the correct Pages in SQL: LIMIT Keyword)
                                " EXISTS (
                                           SELECT *
                                           FROM {$wpdb->prefix}bookingdates as dt
                                           WHERE  bk.booking_id = dt.booking_id ";

if ( 'lost' == $wh_booking_type ) {     // FixIn: 8.5.2.19.

$sql_where.=                  " AND bk.booking_type NOT IN ( SELECT DISTINCT booking_type_id FROM {$wpdb->prefix}bookingtypes ) ";
	    	$sql_where.=                  " ) ";
			$wh_booking_type = '';

} else {

if ( $wh_approved !== '' )
	            $sql_where.=                       " AND approved = $wh_approved ";             // Approved or Pending

$sql_where .= wpbc_set_sql_where_for_dates( $wh_booking_date, $wh_booking_date2 );

$sql_where.=                   " ) ";

$sql_where .= " {$trash_bookings} ";                                    // FixIn: 6.1.1.10.

// FixIn: 8.8.3.19.
	        if ( 'imported' === $wh_sync_gid ) {
		        $sql_where .= " AND  bk.sync_gid != '' ";
	        }
	        if ( 'plugin' === $wh_sync_gid ) {
		        $sql_where .= " AND  bk.sync_gid = '' ";
	        }

if ( $wh_is_new !== '' )
	            $sql_where .=       " AND  bk.is_new = " . $wh_is_new . " ";

$sql_where .= apply_bk_filter( 'get_bklist_sql_keyword', '', $wh_keyword );             // P

$sql_where .= wpbc_set_sql_where_for_modification_date( $wh_modification_date, $wh_modification_date2 );

$sql_where .= apply_bk_filter( 'get_bklist_sql_paystatus', '', $wh_pay_status );        // BS
	        $sql_where .= apply_bk_filter( 'get_bklist_sql_cost', '', $wh_cost, $wh_cost2 );        // BS

$sql_where .= apply_bk_filter( 'get_bklist_sql_resources', '', $wh_booking_type, $wh_approved, $wh_booking_date, $wh_booking_date2 );   // P  || BL
        }

} else {

// FixIn: 8.7.7.10.
    	if ( strpos( $wh_booking_id, '<' ) !== false ) {
		    $wh_booking_id = str_replace( '<', '', $wh_booking_id );
		    $wh_booking_id = intval( $wh_booking_id );
		    $sql_where = " WHERE bk.booking_id < " . $wh_booking_id . " ";
	    }

else if ( strpos( $wh_booking_id, '>' ) !== false ) {
		    $wh_booking_id = str_replace( '>', '', $wh_booking_id );
		    $wh_booking_id = intval( $wh_booking_id );
		    $sql_where = " WHERE bk.booking_id > " . $wh_booking_id . " ";

}

else if ( strpos( $wh_booking_id, ',' ) !== false ) {
		    $sql_where = " WHERE bk.booking_id IN (" . $wh_booking_id . ") ";

} else {
		    $sql_where = " WHERE bk.booking_id = " . $wh_booking_id . " ";
	    }

// Check  if searching booking is belonging to specific user in  Booking Calendar MultiUser version 
        $sql_where = apply_bk_filter('update_where_sql_for_getting_bookings_in_multiuser', $sql_where );

}

if ( strpos( $or_sort, '_asc' ) !== false ) {                               // Order
        $or_sort = str_replace( '_asc', '', $or_sort );
        $sql_order = " ORDER BY " . $or_sort . " ASC ";
    } else
        $sql_order = " ORDER BY " . $or_sort . " DESC ";

$sql_limit = $wpdb->prepare( " LIMIT %d, %d ", $page_start, $page_items_count );

$return_res = array(
                      'sql_start_count'  => $sql_start_count
                    , 'sql_start_select' => $sql_start_select
                    , 'sql'   => $sql
                    , 'where' => $sql_where
                    , 'order' => $sql_order
                    , 'limit' => $sql_limit 
                );

//debuge($return_res);
    return $return_res;
}

////////////////////////////////////////////////////////////////////////////////
// S Q L     W H E R E
////////////////////////////////////////////////////////////////////////////////

/**
	 * Get SQL   W H E R E   conditions for   D a t e s   of  bookings
 * 
 * @param string $wh_booking_date     - Parameter from Booking Listing request (usually  its number)
 * @param string $wh_booking_date2    - Parameter from Booking Listing request (usually  its number)
 * @param string $pref                - Optional. Prefix for table.
 * @return string - WHERE conditions for SQL
 */
function wpbc_set_sql_where_for_dates( $wh_booking_date, $wh_booking_date2, $pref = 'dt.' ) {

$sql_where= '';
    if ($pref == 'dt.')  { $and_pre = ' AND '; $and_suf = ''; }
    else                 { $and_pre = ''; $and_suf = ' AND '; }

// Actual
    if (  ( ( $wh_booking_date  === '' ) && ( $wh_booking_date2  === '' ) ) || ($wh_booking_date  === '0') ) {
        $sql_where =               $and_pre."( ".$pref."booking_date >= (" . wpbc_sql_date_math_expr_explicit( "- INTERVAL '00:00:01' HOUR_SECOND", 'curdate' ) . ") ) ".$and_suf ;      // FixIn: 8.5.2.14.

} else  if ($wh_booking_date  === '1') {                                    // Today								// FixIn: 7.1.2.8.
        $sql_where  =               $and_pre."( ".$pref."booking_date <= (" . wpbc_sql_date_math_expr_explicit( "+ INTERVAL '23:59:59' HOUR_SECOND", 'curdate' ) . ") ) ".$and_suf ;
        $sql_where .=               $and_pre."( ".$pref."booking_date >= (" . wpbc_sql_date_math_expr_explicit( "- INTERVAL '00:00:01' HOUR_SECOND", 'curdate' ) . ") ) ".$and_suf ;     // FixIn: 8.4.7.21.

} else if ($wh_booking_date  === '2') {                                     // Previous
        $sql_where =               $and_pre."( ".$pref."booking_date <= (" . wpbc_sql_date_math_expr_explicit( "- INTERVAL '00:00:01' HOUR_SECOND", 'curdate' ) . ") ) ".$and_suf ;      // FixIn: 8.5.2.16.

} else if ($wh_booking_date  === '3') {                                     // All
        $sql_where =  '';

} else if ($wh_booking_date  === '4') {                                     // Next
        $sql_where  =               $and_pre."( ".$pref."booking_date <= (" . wpbc_sql_date_math_expr_explicit( "+ INTERVAL ". $wh_booking_date2 . " DAY", 'curdate' ) . ") ) ".$and_suf ;
        // $sql_where .=               $and_pre."( ".$pref."booking_date >= (" . wpbc_sql_date_math_expr_explicit( "- INTERVAL 1 DAY", 'curdate' ) . ") ) ".$and_suf ;
	    $sql_where .=               $and_pre."( ".$pref."booking_date > ( " . wpbc_sql_date_math_expr_explicit('', 'curdate') . " ) ) ".$and_suf ;                    // FixIn: 8.0.1.1.

} else if ($wh_booking_date  === '5') {                                     // Prior
        $wh_booking_date2 = str_replace('-', '', $wh_booking_date2);
        $sql_where  =               $and_pre."( ".$pref."booking_date >= (" . wpbc_sql_date_math_expr_explicit( "- INTERVAL ". $wh_booking_date2 . " DAY", 'curdate' ) . ") ) ".$and_suf ;
        $sql_where .=               $and_pre."( ".$pref."booking_date <= (" . wpbc_sql_date_math_expr_explicit( "+ INTERVAL 1 DAY", 'curdate' ) . ") ) ".$and_suf ;

} else  if ($wh_booking_date  === '7') {                                    // Check In date - Today/Tomorrow
          $sql_where  =               $and_pre."( ".$pref."booking_date <= ( " . wpbc_sql_date_math_expr_explicit( "+ INTERVAL '47:59:59' HOUR_SECOND", 'curdate' ) . " ) ) ".$and_suf ;
          $sql_where .=               $and_pre."( ".$pref."booking_date >= (" . wpbc_sql_date_math_expr_explicit( "+ INTERVAL 1 DAY", 'curdate' ) . ") ) ".$and_suf ;

} else  if ($wh_booking_date  === '8') {                                    // Check Out date - Tomorrow
		$sql_where  =               $and_pre."( ".$pref."booking_date <= ( " . wpbc_sql_date_math_expr_explicit( "+ INTERVAL '47:59:59' HOUR_SECOND", 'curdate' ) . " ) ) ".$and_suf ;
        $sql_where .=               $and_pre."( ".$pref."booking_date >= (" . wpbc_sql_date_math_expr_explicit( "+ INTERVAL 1 DAY", 'curdate' ) . ") ) ".$and_suf ;

} else  if ($wh_booking_date  === '9') {                                    // Today check in/out
        $sql_where  =               $and_pre."( ".$pref."booking_date <= (" . wpbc_sql_date_math_expr_explicit( "+ INTERVAL 1 DAY", 'curdate' ) . ") ) ".$and_suf ;
        $sql_where .=               $and_pre."( ".$pref."booking_date >= (" . wpbc_sql_date_math_expr_explicit( "- INTERVAL 1 DAY", 'curdate' ) . ") ) ".$and_suf ;

} else {                                                                    // Fixed

if ( $wh_booking_date  !== '' )
            if ( strpos($wh_booking_date,':')===false )                         // we are do not have the time in this date, so  set it
                 $sql_where.= $and_pre."( ".$pref."booking_date >= '" . $wh_booking_date . " 00:00:00' ) ".$and_suf;
            else $sql_where.= $and_pre."( ".$pref."booking_date >= '" . $wh_booking_date . "' ) ".$and_suf;

if ( $wh_booking_date2  !== '' )
            if ( strpos($wh_booking_date2,':')===false )                        // we are do not have the time in this date, so  set it
                 $sql_where.=               $and_pre."( ".$pref."booking_date <= '" . $wh_booking_date2 . " 23:59:59' ) ".$and_suf;
            else $sql_where.=               $and_pre."( ".$pref."booking_date <= '" . $wh_booking_date2 . "' ) ".$and_suf;
    }

return $sql_where;
}

/**
	 * Get SQL   W H E R E   conditions for   M o d i f i c a t i o n    D a t e   of  bookings
 * 
 * @param type $wh_modification_date    - Parameter from Booking Listing request (usually  its number)
 * @param type $wh_modification_date2   - Parameter from Booking Listing request (usually  its number)
 * @param string $pref                  - Optional. Prefix for table.
 * @return string - WHERE conditions for SQL
 */
function wpbc_set_sql_where_for_modification_date( $wh_modification_date, $wh_modification_date2, $pref = 'bk.' ) {

$sql_where = '';
    
    if ($pref == 'bk.')  { $and_pre = ' AND '; $and_suf = ''; }
    else                 { $and_pre = ''; $and_suf = ' AND '; }

if ($wh_modification_date  === '1') {                                       // Today
        $sql_where  =               $and_pre."( ".$pref."modification_date <= (" . wpbc_sql_date_math_expr_explicit( "+ INTERVAL '23:59:59' HOUR_SECOND", 'curdate' ) . ") ) ".$and_suf ;    // FixIn: 8.4.7.22.
        $sql_where .=               $and_pre."( ".$pref."modification_date >= (" . wpbc_sql_date_math_expr_explicit( "- INTERVAL '00:00:01' HOUR_SECOND", 'curdate' ) . ") ) ".$and_suf ;    // FixIn: 8.4.7.22.

} else if ($wh_modification_date  === '3') {                                // All
        $sql_where =  '';

} else if ($wh_modification_date  === '5') {                                // Prior
        $wh_modification_date2 = str_replace('-', '', $wh_modification_date2);
        $sql_where  =               $and_pre."( ".$pref."modification_date >= (" . wpbc_sql_date_math_expr_explicit( "- INTERVAL ". $wh_modification_date2 . " DAY", 'curdate' ) . ") ) ".$and_suf ;
        $sql_where .=               $and_pre."( ".$pref."modification_date <= (" . wpbc_sql_date_math_expr_explicit( "+ INTERVAL 1 DAY", 'curdate' ) . ") ) ".$and_suf ;

} else {                                                                    // Fixed

if ( $wh_modification_date  !== '' )
            $sql_where.=               $and_pre."( ".$pref."modification_date >= '" . $wh_modification_date . "' ) ".$and_suf;

if ( $wh_modification_date2  !== '' )
            $sql_where.=               $and_pre."( ".$pref."modification_date <= '" . $wh_modification_date2 . "' ) ".$and_suf;
    }

return $sql_where;
}

/**
 * Generate SQL-compatible datetime/date expression based on explicit base function and optional interval.
 *
 * @param string $mysql_expr  - MySQL-style interval expression. Examples: "- INTERVAL '00:00:01' HOUR_SECOND", "+ INTERVAL 5 DAY", etc.
 * @param string $base_func   - 'curdate'|'now' Either 'curdate' (default) for CURDATE() / date('now'), or 'now' for NOW() / datetime('now').
 *
 * @return string  SQL expression (unquoted), adapted for MySQL or SQLite.
 *
 * Exmaples:
 *           wpbc_sql_date_math_expr_explicit("- INTERVAL '00:00:01' HOUR_SECOND", 'curdate')    | MySQL:  CURDATE() - INTERVAL '00:00:01' HOUR_SECOND    # SQLite: datetime('now', '-1 seconds') (auto-upgraded)
 *           wpbc_sql_date_math_expr_explicit("+ INTERVAL 2 DAY", 'curdate')                     | MySQL:  CURDATE() + INTERVAL 2 DAY                     # SQLite: date('now', '+2 days')
 *           wpbc_sql_date_math_expr_explicit('', 'now');                                        | MySQL: NOW()                                           # SQLite: datetime('now') |.
 *           wpbc_sql_date_math_expr_explicit();                                                 | MySQL: CURDATE()                                       # SQLite: date('now')
 *           wpbc_sql_date_math_expr_explicit("+ INTERVAL 30 MINUTE", 'curdate')                 | MySQL: CURDATE() + INTERVAL 30 MINUTE                  # SQLite: datetime('now', '+1800 seconds') (auto-upgraded)
 */
function wpbc_sql_date_math_expr_explicit( $mysql_expr = '', $base_func = 'curdate' ) {
	global $wpdb;

$is_sqlite          = ( get_class( $wpdb ) === 'WP_SQLite_DB' );
	$original_base_func = strtolower( $base_func );
	$base_func          = $original_base_func;

// Fallback if invalid.
	if ( ! in_array( $base_func, array( 'curdate', 'now' ), true ) ) {
		$base_func = 'curdate';
	}

// Promote to datetime() if base is 'curdate' and delta is time-based.
	$has_time_delta = ( false !== stripos( $mysql_expr, 'HOUR' ) ||
						false !== stripos( $mysql_expr, 'MINUTE' ) ||
						false !== stripos( $mysql_expr, 'SECOND' ) ||
						false !== strpos( $mysql_expr, ':' ) );

if ( $is_sqlite && 'curdate' === $base_func && $has_time_delta ) {
		$base_func = 'now';  // auto-promote for SQLite.
	}

$mysql_base_func  = ( 'curdate' === $base_func ) ? 'CURDATE()' : 'NOW()';
	$sqlite_base_func = ( 'curdate' === $base_func ) ? 'date' : 'datetime';

if ( empty( $mysql_expr ) ) {
		return $is_sqlite ? "{$sqlite_base_func}('now')" : $mysql_base_func;
	}

if ( ! $is_sqlite ) {
		return "{$mysql_base_func} {$mysql_expr}";
	}

$modifiers = wpbc__convert_mysql_interval_to_sqlite_modifiers( $mysql_expr );

// Fix: anchor to midnight if original func was 'curdate' with time math.
	if ( 'curdate' === $original_base_func && $has_time_delta ) {
		return "datetime('now','start of day'{$modifiers})";
	}

return "{$sqlite_base_func}('now'{$modifiers})";
}

/**
 * Convert MySQL-style interval expression to SQLite-compatible modifier(s)
 *
 * @param string $expr  - expression.
 *
 * @return string
 *
 * Supports:
 * - INTERVAL 5 DAY
 * - INTERVAL '00:00:01' HOUR_SECOND
 * - Multiple modifiers if needed (returns ', '+X unit', '+Y unit'...')
 */
function wpbc__convert_mysql_interval_to_sqlite_modifiers( $expr ) {

$expr = trim( $expr );

if ( preg_match( '/([+-])?\s*INTERVAL\s+(\'?)([^\'\s]+)\2\s+([A-Z_]+)/i', $expr, $m ) ) {
		$sign  = ( '-' === $m[1] ) ? '-' : '+';
		$value = $m[3];
		$type  = strtoupper( $m[4] );

switch ( $type ) {
			case 'DAY':
				return ", '{$sign}{$value} days'";

case 'HOUR_SECOND':
			case 'SECOND':
				$seconds = 0;
				if ( strpos( $value, ':' ) !== false ) {
					$parts = array_map( 'intval', explode( ':', $value ) );
					if ( count( $parts ) === 3 ) {
						$seconds = $parts[0] * 3600 + $parts[1] * 60 + $parts[2];
					} elseif ( count( $parts ) === 2 ) {
						$seconds = $parts[0] * 60 + $parts[1];
					}
				} else {
					$seconds = intval( $value );
				}

return ", '{$sign}{$seconds} seconds'";

default:
				return ", '{$sign}{$value} " . strtolower( $type ) . "'";
		}
	}

return '';
}

Back