Automattic\WooCommerce\Admin\API

ProductsLowInStock::get_products_with_custom_stock_threshold_count_query_str │ private │ WC 1.0

Get a query string for products with a custom stock threshold.

Метод класса: ProductsLowInStock{}

Хуков нет.

Возвращает

Строку.

Использование

// private - только в коде основоного (родительского) класса
$result = $this->get_products_with_custom_stock_threshold_count_query_str();

Код ProductsLowInStock::get_products_with_custom_stock_threshold_count_query_str() ProductsLowInStock::get products with custom stock threshold count query str ^{WC 10.0.2}

private function get_products_with_custom_stock_threshold_count_query_str() {
	global $wpdb;
	$query    = $this->get_base_query(
		array(
			':selects'       => 'count(*) as total',
			':orderAndLimit' => '',
		)
	);
	$postmeta = array(
		'select' => 'meta.meta_value AS low_stock_amount,',
		'join'   => "JOIN {$wpdb->postmeta} AS meta ON wp_posts.ID = meta.post_id AND meta.meta_key = '_low_stock_amount' AND meta.meta_value > ''",
		'wheres' => 'AND wc_product_meta_lookup.stock_quantity <= CAST(meta.meta_value AS SIGNED)',
	);

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