WooCommerce: Check if User Has Bought Product in the Last 365 Days

/**
 * @snippet       "wc_customer_bought_product" last 365 days
 * @how-to        businessbloomer.com/woocommerce-customization
 * @author        Rodolfo Melogli, Business Bloomer
 * @compatible    WooCommerce 9
 * @community     https://businessbloomer.com/club/
 */

function wc_customer_bought_product_last_365( $customer_email, $user_id, $product_id ) {
	global $wpdb;

	$result = apply_filters( 'woocommerce_pre_customer_bought_product_last_365', null, $customer_email, $user_id, $product_id );

	if ( null !== $result ) {
		return $result;
	}

	$transient_name = 'wc_customer_bought_product_last_365_' . md5( $customer_email . $user_id );
	$transient_version = WC_Cache_Helper::get_transient_version( 'woocommerce_reports' );
	$transient_value = get_transient( $transient_name );

	if ( isset( $transient_value['value'], $transient_value['version'] ) && $transient_value['version'] === $transient_version ) {
		$result = $transient_value['value'];
	} else {
		$customer_data = array( $user_id );

		if ( $user_id ) {
			$user = get_user_by( 'id', $user_id );
			if ( isset( $user->user_email ) ) {
				$customer_data[] = $user->user_email;
			}
		}

		if ( is_email( $customer_email ) ) {
			$customer_data[] = $customer_email;
		}

		$customer_data = array_map( 'esc_sql', array_filter( array_unique( $customer_data ) ) );
		$statuses = array_map( 'esc_sql', wc_get_is_paid_statuses() );

		if ( count( $customer_data ) === 0 ) {
			return false;
		}

		$date_limit = date( 'Y-m-d H:i:s', strtotime( '-365 days' ) );

		if ( 'yes' === get_option( 'woocommerce_custom_orders_table_enabled' ) ) {
			$statuses = array_map( function ( $status ) { return "wc-$status"; }, $statuses );
			$order_table = $wpdb->prefix . 'wc_orders';
			$user_id_clause = $user_id ? 'OR o.customer_id = ' . absint( $user_id ) : '';
			$sql = "
SELECT DISTINCT product_or_variation_id FROM (
SELECT CASE WHEN product_id != 0 THEN product_id ELSE variation_id END AS product_or_variation_id
FROM {$wpdb->prefix}wc_order_product_lookup lookup
INNER JOIN $order_table AS o ON lookup.order_id = o.ID
WHERE o.status IN ('" . implode( "','", $statuses ) . "')
AND ( o.billing_email IN ('" . implode( "','", $customer_data ) . "') $user_id_clause )
AND o.date_created_gmt >= '$date_limit'
) AS subquery
WHERE product_or_variation_id != 0
";
			$result = $wpdb->get_col( $sql );
		} else {
			$result = $wpdb->get_col(
				"
SELECT DISTINCT product_or_variation_id FROM (
SELECT CASE WHEN lookup.product_id != 0 THEN lookup.product_id ELSE lookup.variation_id END AS product_or_variation_id
FROM {$wpdb->prefix}wc_order_product_lookup AS lookup
INNER JOIN {$wpdb->posts} AS p ON p.ID = lookup.order_id
INNER JOIN {$wpdb->postmeta} AS pm ON p.ID = pm.post_id
WHERE p.post_status IN ( 'wc-" . implode( "','wc-", $statuses ) . "' )
AND pm.meta_key IN ( '_billing_email', '_customer_user' )
AND pm.meta_value IN ( '" . implode( "','", $customer_data ) . "' )
AND p.post_date >= '$date_limit'
) AS subquery
WHERE product_or_variation_id != 0
"
			);
		}

		$result = array_map( 'absint', $result );

		$transient_value = array(
			'version' => $transient_version,
			'value'   => $result,
		);

		set_transient( $transient_name, $transient_value, DAY_IN_SECONDS * 30 );
	}

	return in_array( absint( $product_id ), $result, true );
}

if ( wc_customer_bought_product_last_365( 'info@example.com', 1, 246642 ) ) {
   // do something if has purchased in the last 365 days
} else {
   // do something else
}

if ( wc_customer_bought_product_last_365( 'info@example.com', '', 246642 ) )

if ( wc_customer_bought_product_last_365( '', 1, 246642 ) )

if ( wc_customer_bought_product_last_365( 'info@example.com', 246642 ) )

if ( wc_customer_bought_product_last_365( 1, 246642 ) )