ChobPT · November 18, 2025 11:08 · apintocr · Oct 9, 2019 · Ahigh4life · Nov 13, 2019
diff --git a/wc-bookings-availability-search-shortcode.php b/wc-bookings-availability-search-shortcode.php
 <?php 
 /* 
 * This code uses the original function and
 * adds a shortcode functionality to display the product loop with
 * the products that are available adding also another shortcode for
 * products that are unavailable
 *
 * Usage: [bookable_products start="2019-10-10" end="2019-10-15"]
 *	 [unbookable_products start="2019-10-10" end="2019-10-15"]
 *
 * This was meant to use with Accomodation bookings, which work in day blocks.
 * Modification may be needed to search for hour blocks
 *
 * Add this code to the functions.php file of your theme folder
 *
 */


 function checkBookableRooms($bookStart,$bookEnd){
    
    
   /**
    * WooCommerce Bookings Availability Search
    *
    * This is almost pseudo code, it only serves to explain the "how to do it" and does not attempt to be "The Way" to do it.
    * NOTE: This NEEDS to be refined in order to work as expected.
    * 
    * @author  António Pinto <apinto@vanguardly.com>
    * @license http://opensource.org/licenses/gpl-license.php GNU Public License
    * 
    * @var     string   $bookStart (example: '2016-06-14 16:23:00')
    * @var     string   $bookEnd   (example: '2016-06-14 16:23:00')
    */
    // Creating DateTime() objects from the input data.
    $dateTimeStart = new DateTime($bookStart);
    $dateTimeEnd   = new DateTime($bookEnd);
   
    // Get all Bookings in Range
    $bookings = WC_Bookings_Controller::get_bookings_in_date_range(
           $dateTimeStart->getTimestamp(),
           $dateTimeEnd->getTimestamp(),
           '',
           false
         );
         
    // Build Array of all the Booked Products for the given Date-Time interval.
    $exclude[] = 0;
    foreach ($bookings as $booking) {
      $exclude[] = $booking->product_id;
    }
    
    // Do a regular WP_Query using 'post__not_in' with the previous array.
    $args = array (
      'post__not_in'           => $exclude,
      'post_type'              => ['product'],
      'post_status'            => ['published'],
    );
    
     return $args;
 }

 function getProducts( $atts ) {
 	$startDate  = date(strtotime($atts["start"]),"Y-m-d")." 00:00:00";
    	$endDate    = date(strtotime($atts["end"])  ,"Y-m-d")." 23:59:59";
    
    	$wpArgs=checkBookableRooms($startDate,$endDate);
    	$latest = new WP_Query($wpArgs);
    	$post_ids = wp_list_pluck( $latest->posts, 'ID' );

    	return do_shortcode("[products ids='".implode(",", $post_ids)."']");
    
 }
 add_shortcode( 'bookable_products', 'getProducts' );



 function checkUnBookableRooms($bookStart,$bookEnd){
    
    
   /**
    * WooCommerce Bookings Availability Search
    *
    * This is almost pseudo code, it only serves to explain the "how to do it" and does not attempt to be "The Way" to do it.
    * NOTE: This NEEDS to be refined in order to work as expected.
    * 
    * @author  António Pinto <apinto@vanguardly.com>
    * @license http://opensource.org/licenses/gpl-license.php GNU Public License
    * 
    * @var     string   $bookStart (example: '2016-06-14 16:23:00')
    * @var     string   $bookEnd   (example: '2016-06-14 16:23:00')
    */
    // Creating DateTime() objects from the input data.
    $dateTimeStart = new DateTime($bookStart);
    $dateTimeEnd   = new DateTime($bookEnd);
   
    // Get all Bookings in Range
    $bookings = WC_Bookings_Controller::get_bookings_in_date_range(
           $dateTimeStart->getTimestamp(),
           $dateTimeEnd->getTimestamp(),
           '',
           false
         );
         
    // Build Array of all the Booked Products for the given Date-Time interval.
    $exclude[] = 0;
    foreach ($bookings as $booking) {
      	$exclude[] = $booking->product_id;
    }
    
    // Do a regular WP_Query using 'post__not_in' with the previous array.
    $args = array (
      	'post__in'           => $exclude,
      	'post_type'              => ['product'],
      	'post_status'            => ['published'],
    );
    
     return $args;
 }

 function getExcludedProducts( $atts ) {
 	$startDate  = date(strtotime($atts["start"]),"Y-m-d")." 00:00:00";
    	$endDate    = date(strtotime($atts["end"])  ,"Y-m-d")." 23:59:59";
    
    	$wpArgs=checkUnBookableRooms($startDate,$endDate);
    	$latest = new WP_Query($wpArgs);
    	$post_ids = wp_list_pluck( $latest->posts, 'ID' );
    
    	return do_shortcode("[products ids='".implode(",", $post_ids)."']");
    
 }
 add_shortcode( 'unbookable_products', 'getExcludedProducts' );
	<?php
	/*
	* This code uses the original function and
	* adds a shortcode functionality to display the product loop with
	* the products that are available adding also another shortcode for
	* products that are unavailable
	*
	* Usage: [bookable_products start="2019-10-10" end="2019-10-15"]
	* [unbookable_products start="2019-10-10" end="2019-10-15"]
	*
	* This was meant to use with Accomodation bookings, which work in day blocks.
	* Modification may be needed to search for hour blocks
	*
	* Add this code to the functions.php file of your theme folder
	*
	*/


	function checkBookableRooms($bookStart,$bookEnd){


	/**
	* WooCommerce Bookings Availability Search
	*
	* This is almost pseudo code, it only serves to explain the "how to do it" and does not attempt to be "The Way" to do it.
	* NOTE: This NEEDS to be refined in order to work as expected.
	*
	* @author António Pinto <apinto@vanguardly.com>
	* @license http://opensource.org/licenses/gpl-license.php GNU Public License
	*
	* @var string $bookStart (example: '2016-06-14 16:23:00')
	* @var string $bookEnd (example: '2016-06-14 16:23:00')
	*/
	// Creating DateTime() objects from the input data.
	$dateTimeStart = new DateTime($bookStart);
	$dateTimeEnd = new DateTime($bookEnd);

	// Get all Bookings in Range
	$bookings = WC_Bookings_Controller::get_bookings_in_date_range(
	$dateTimeStart->getTimestamp(),
	$dateTimeEnd->getTimestamp(),
	'',
	false
	);

	// Build Array of all the Booked Products for the given Date-Time interval.
	$exclude[] = 0;
	foreach ($bookings as $booking) {
	$exclude[] = $booking->product_id;
	}

	// Do a regular WP_Query using 'post__not_in' with the previous array.
	$args = array (
	'post__not_in' => $exclude,
	'post_type' => ['product'],
	'post_status' => ['published'],
	);

	return $args;
	}

	function getProducts( $atts ) {
	$startDate = date(strtotime($atts["start"]),"Y-m-d")." 00:00:00";
	$endDate = date(strtotime($atts["end"]) ,"Y-m-d")." 23:59:59";

	$wpArgs=checkBookableRooms($startDate,$endDate);
	$latest = new WP_Query($wpArgs);
	$post_ids = wp_list_pluck( $latest->posts, 'ID' );

	return do_shortcode("[products ids='".implode(",", $post_ids)."']");

	}
	add_shortcode( 'bookable_products', 'getProducts' );



	function checkUnBookableRooms($bookStart,$bookEnd){


	/**
	* WooCommerce Bookings Availability Search
	*
	* This is almost pseudo code, it only serves to explain the "how to do it" and does not attempt to be "The Way" to do it.
	* NOTE: This NEEDS to be refined in order to work as expected.
	*
	* @author António Pinto <apinto@vanguardly.com>
	* @license http://opensource.org/licenses/gpl-license.php GNU Public License
	*
	* @var string $bookStart (example: '2016-06-14 16:23:00')
	* @var string $bookEnd (example: '2016-06-14 16:23:00')
	*/
	// Creating DateTime() objects from the input data.
	$dateTimeStart = new DateTime($bookStart);
	$dateTimeEnd = new DateTime($bookEnd);

	// Get all Bookings in Range
	$bookings = WC_Bookings_Controller::get_bookings_in_date_range(
	$dateTimeStart->getTimestamp(),
	$dateTimeEnd->getTimestamp(),
	'',
	false
	);

	// Build Array of all the Booked Products for the given Date-Time interval.
	$exclude[] = 0;
	foreach ($bookings as $booking) {
	$exclude[] = $booking->product_id;
	}

	// Do a regular WP_Query using 'post__not_in' with the previous array.
	$args = array (
	'post__in' => $exclude,
	'post_type' => ['product'],
	'post_status' => ['published'],
	);

	return $args;
	}

	function getExcludedProducts( $atts ) {
	$startDate = date(strtotime($atts["start"]),"Y-m-d")." 00:00:00";
	$endDate = date(strtotime($atts["end"]) ,"Y-m-d")." 23:59:59";

	$wpArgs=checkUnBookableRooms($startDate,$endDate);
	$latest = new WP_Query($wpArgs);
	$post_ids = wp_list_pluck( $latest->posts, 'ID' );

	return do_shortcode("[products ids='".implode(",", $post_ids)."']");

	}
	add_shortcode( 'unbookable_products', 'getExcludedProducts' );
No results found