Automattic\WooCommerce\Admin\API\Reports\Products\Stats

Segmenter::get_segment_selections_product_level() │ protected │ WC 1.0

Returns column => query mapping to be used for product-related product-level segmenting query (e.g. products sold, revenue from product X when segmenting by category).

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

Хуков нет.

Возвращает

Массив. Column => SELECT query mapping.

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

// protected - в коде основоного (родительского) или дочернего класса
$result = $this->get_segment_selections_product_level( $products_table );
$products_table(строка) (обязательный)
Name of SQL table containing the product-level segmenting info.

Код Segmenter::get_segment_selections_product_level() WC 9.8.2

woocommerce/src/Admin/API/Reports/Products/Stats/Segmenter.php 
protected function get_segment_selections_product_level( $products_table ) {
	$columns_mapping = array(
		'items_sold'       => "SUM($products_table.product_qty) as items_sold",
		'net_revenue'      => "SUM($products_table.product_net_revenue ) AS net_revenue",
		'orders_count'     => "COUNT( DISTINCT $products_table.order_id ) AS orders_count",
		'products_count'   => "COUNT( DISTINCT $products_table.product_id ) AS products_count",
		'variations_count' => "COUNT( DISTINCT $products_table.variation_id ) AS variations_count",
	);

	return $columns_mapping;
}