Woo Analytics Orders custom filter

// Custom Woo Analytics Orders Advanced Filter
add_action( 'admin_enqueue_scripts', function() {

	$screen = get_current_screen();

	if( ! $screen || strpos( $screen->id, 'woocommerce_page_wc-admin' ) === false ) {
		return;
	}

	wp_enqueue_script( 'wp-hooks' );

	$inline_js = "
		( function() {

			if ( typeof wp === 'undefined' || ! wp.hooks ) {
				return;
			}

			wp.hooks.addFilter(
				'woocommerce_admin_orders_report_advanced_filters',
				'ccom/shipping-country-filter',
				function( advancedFilters ) {

					advancedFilters.filters.shipping_country = {
						labels: {
							add: 'Shipping Country',
							remove: 'Remove country filter',
							rule: 'Select country rule',
							title: '{{title}}Shipping Country is{{/title}} {{filter /}}',
							filter: 'Select shipping country'
						},

						input: {
							component: 'SelectControl',
							options: [
								{
									value: 'US',
									label: 'United States'
								},
								{
									value: 'CA',
									label: 'Canada'
								},
								{
									value: 'GB',
									label: 'United Kingdom'
								},
								{
									value: 'AU',
									label: 'Australia'
								}
							]
						}

					};

					return advancedFilters;
				}
			);

		}() );
	";

	wp_add_inline_script( 'wp-hooks', $inline_js, 'after' );

} );

// Register shipping_country with Analytics
add_filter( 'woocommerce_analytics_orders_query_args', 'ccom_shipping_country_arg' );
add_filter( 'woocommerce_analytics_orders_stats_query_args', 'ccom_shipping_country_arg' );
function ccom_shipping_country_arg( $args ) {

	$country = '';

	if ( isset( $_GET['shipping_country'] ) ) {
		$country = sanitize_text_field(
			wp_unslash( $_GET['shipping_country'] )
		);
	}

	$args['shipping_country'] = $country;

	return $args;
}

// Join the wc_order_addresses table to the Analytics subquery
add_filter( 'woocommerce_analytics_clauses_join_orders_subquery', 'ccom_shipping_country_join' );
add_filter( 'woocommerce_analytics_clauses_join_orders_stats_total', 'ccom_shipping_country_join' );
add_filter( 'woocommerce_analytics_clauses_join_orders_stats_interval', 'ccom_shipping_country_join' );
function ccom_shipping_country_join( $clauses ) {

	global $wpdb;

	$addresses_table = "{$wpdb->prefix}wc_order_addresses";
	$order_stats = "{$wpdb->prefix}wc_order_stats";

	if( strpos( implode( ' ', $clauses ), $addresses_table ) === false ) {
		$clauses[] = "JOIN {$addresses_table}
			ON {$order_stats}.order_id = {$addresses_table}.order_id
			AND {$addresses_table}.address_type = 'shipping'";
	}

	return $clauses;
}

// Add WHERE clause for the selected shipping_country value
add_filter( 'woocommerce_analytics_clauses_where_orders_subquery', 'ccom_shipping_country_where' );
add_filter( 'woocommerce_analytics_clauses_where_orders_stats_total', 'ccom_shipping_country_where' );
add_filter( 'woocommerce_analytics_clauses_where_orders_stats_interval', 'ccom_shipping_country_where' );
function ccom_shipping_country_where( $clauses ) {

	global $wpdb;

	if( empty( $_GET['shipping_country'] ) ) {
		return $clauses;
	}

	$country_code = sanitize_text_field(
		wp_unslash( $_GET['shipping_country'] )
	);

	$clauses[] = $wpdb->prepare(
		" AND {$wpdb->prefix}wc_order_addresses.country = %s",
		$country_code
	);

	return $clauses;
}