WooCommerce: Get Total Sales By Product Category

/**
 * @snippet       Calculate Product Category Sales Amount
 * @how-to        Get CustomizeWoo.com FREE
 * @author        Rodolfo Melogli
 * @compatible    WooCommerce 7
 * @community     https://businessbloomer.com/club/
 */

// 1. ORDERS GETTER

function bbloomer_get_orders_by_product_cat( $cat_slug, $order_status = array( 'wc-completed' ) ) {
    global $wpdb;
	 $args = array(
		 'limit' => -1,
	 	 'status' => 'publish',
		 'return' => 'ids',
		 'category' => array( $cat_slug ),
	 );
	 $product_ids = wc_get_products( $args );
    $results = $wpdb->get_col( "
        SELECT order_items.order_id
        FROM {$wpdb->prefix}woocommerce_order_items as order_items
        LEFT JOIN {$wpdb->prefix}woocommerce_order_itemmeta as order_item_meta ON order_items.order_item_id = order_item_meta.order_item_id
        LEFT JOIN {$wpdb->posts} AS posts ON order_items.order_id = posts.ID
        WHERE posts.post_type = 'shop_order'
        AND posts.post_status IN ( '" . implode( "','", $order_status ) . "' )
        AND order_items.order_item_type = 'line_item'
        AND order_item_meta.meta_key = '_product_id'
        AND order_item_meta.meta_value IN ( '" . implode( "','", $product_ids ) . "' )
    " );
    return $results;
}

// 2. SALES CALCULATOR

function bbloomer_cat_sales( $cat_slug ) {
	$orders = bbloomer_get_orders_by_product_cat( $cat_slug );
	$total = 0;
	foreach ( $orders as $order_id ) {
		foreach ( wc_get_order( $order_id )->get_items() as $key => $item ) {
			$product_id = $item->get_product_id();
			if ( ! $product_id ) continue;
			if ( has_term( $cat_slug, 'product_cat', $product_id ) ) $total += $item->get_total();
		}
	}
   return wc_price( $total );
}

// 3. USAGE
// E.G. YOU COULD PLACE THIS IN THE BACKEND OF FRONTEND:

echo bbloomer_cat_sales( 'tables' );