WooCommerce Bookings Availability Search

wc-bookings-availability-search.php

<?php
/**
 * 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 <[email protected]>
 * @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'],
);