get_var( $wpdb->prepare(
"SELECT COUNT(DISTINCT wcbookings.ID) AS count
FROM {$wpdb->posts} AS wcbookings
INNER JOIN {$wpdb->prefix}wc_orders AS wcorder
ON wcbookings.post_parent = wcorder.id
WHERE wcbookings.post_type IN ( 'wc_booking' )
AND wcorder.status IN ( 'wc-completed', 'wc-processing', 'wc-on-hold', 'wc-refunded' )
AND wcorder.date_created_gmt >= %s
AND wcorder.date_created_gmt < %s",
date( 'Y-m-01', current_time( 'timestamp', true ) ),
date( 'Y-m-d H:i:s', current_time( 'timestamp', true ) )
) );
} else {
$new_bookings = $wpdb->get_var( $wpdb->prepare(
"SELECT COUNT(DISTINCT wcbookings.ID) AS count
FROM {$wpdb->posts} AS wcbookings
INNER JOIN {$wpdb->posts} AS wcorder
ON wcbookings.post_parent = wcorder.ID
WHERE wcorder.post_type IN ( 'shop_order' )
AND wcbookings.post_type IN ( 'wc_booking' )
AND wcorder.post_status IN ( 'wc-completed', 'wc-processing', 'wc-on-hold', 'wc-refunded' )
AND wcorder.post_date >= %s
AND wcorder.post_date < %s",
date( 'Y-m-01', current_time( 'timestamp' ) ),
date( 'Y-m-d H:i:s', current_time( 'timestamp' ) )
) );
}
$require_confirmation = $wpdb->get_var( "SELECT COUNT(DISTINCT wcbookings.ID) AS count
FROM {$wpdb->posts} AS wcbookings
WHERE wcbookings.post_type IN ( 'wc_booking' )
AND wcbookings.post_status = 'pending-confirmation'" );
?>
%s booking(s) new bookings this month', '%s booking(s) new bookings this month', $new_bookings, 'woocommerce-bookings' ) ), esc_html( $new_bookings ) );
?>
%s booking(s) require confirmation', '%s booking(s) require confirmation', $require_confirmation, 'woocommerce-bookings' ) ), esc_html( $require_confirmation ) );
?>