Automattic\WooCommerce\Admin\API

ProductsLowInStock::add_sitewide_stock_query_str │ private │ WC 1.0

Add sitewide stock query string to base query string.

Method of the class: ProductsLowInStock{}

No Hooks.

Returns

String.

Usage

// private - for code of main (parent) class only
$result = $this->add_sitewide_stock_query_str( $query );

$query(string) (required)

Base query string.

ProductsLowInStock::add_sitewide_stock_query_str() ProductsLowInStock::add sitewide stock query str code ^{WC 10.5.0}

private function add_sitewide_stock_query_str( $query ) {
	global $wpdb;
	$postmeta = array(
		'select' => 'meta.meta_value AS low_stock_amount,',
		'join'   => "LEFT JOIN {$wpdb->postmeta} AS meta ON wp_posts.ID = meta.post_id
		  AND meta.meta_key = '_low_stock_amount'",
		'wheres' => "AND (
		    (
		      meta.meta_value > ''
		      AND wc_product_meta_lookup.stock_quantity <= CAST(
		        meta.meta_value AS SIGNED
		      )
		    )
		    OR (
		      (
		        meta.meta_value IS NULL
		        OR meta.meta_value <= ''
		      )
		      AND wc_product_meta_lookup.stock_quantity <= %d
		    )
	    )",
	);

	return strtr(
		$query,
		array(
			':postmeta_select' => $postmeta['select'],
			':postmeta_join'   => $postmeta['join'],
			':postmeta_wheres' => $postmeta['wheres'],
		)
	);
}