Automattic\WooCommerce\Internal\ProductFilters

FilterData::get_stock_status_counts │ public │ WC 1.0

Get stock status counts for the current products.

Method of the class: FilterData{}

Returns

Array. status=>count pairs.

Usage

$FilterData = new FilterData();
$FilterData->get_stock_status_counts( $query_vars, $statuses );

$query_vars(array) (required)

The WP_Query arguments.

$statuses(array) (required)

Array of stock status values to count.

FilterData::get_stock_status_counts() FilterData::get stock status counts code ^{WC 10.3.3}

public function get_stock_status_counts( array $query_vars, array $statuses ) {
	/**
	 * Filter the data. @see get_filtered_price() for full documentation.
	 */
	$pre_filter_counts = apply_filters( 'woocommerce_pre_product_filter_data', null, 'stock', $query_vars, array() ); // phpcs:ignore WooCommerce.Commenting.CommentHooks.MissingSinceComment

	if ( is_array( $pre_filter_counts ) ) {
		return $pre_filter_counts;
	}

	$transient_key = $this->get_transient_key( $query_vars, 'stock' );
	$cached_data   = $this->get_cache( $transient_key );

	if ( ! empty( $cached_data ) ) {
		return $cached_data;
	}

	$results     = array();
	$product_ids = $this->get_cached_product_ids( $query_vars );

	if ( $product_ids ) {
		global $wpdb;

		foreach ( $statuses as $status ) {
			$stock_status_count_sql = "
				SELECT COUNT( DISTINCT posts.ID ) as status_count
				FROM {$wpdb->posts} as posts
				INNER JOIN {$wpdb->postmeta} as postmeta ON posts.ID = postmeta.post_id
				AND postmeta.meta_key = '_stock_status'
				AND postmeta.meta_value = '" . esc_sql( $status ) . "'
				WHERE posts.ID IN ( {$product_ids} )
			";

			/**
			* We can't use $wpdb->prepare() here because using %s with
			* $wpdb->prepare() for a subquery won't work as it will escape the
			* SQL query.
			* We're using the query as is, same as Core does.
			*/
			// phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
			$result             = $wpdb->get_row( $stock_status_count_sql );
			$results[ $status ] = $result->status_count;
		}
	}

	/**
	 * Filter the results. @see get_filtered_price() for full documentation.
	 */
	$results = apply_filters( 'woocommerce_product_filter_data', $results, 'stock', $query_vars, array() ); // phpcs:ignore WooCommerce.Commenting.CommentHooks.MissingSinceComment

	$this->set_cache( $transient_key, $results );

	return $results;
}