Automattic\WooCommerce\Internal\Admin\Reports

HposLegacyOrderReportQueryBuilder::build_address_join │ private │ WC 1.0

Build the JOIN onto wc_order_addresses for one address type.

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

Хуков нет.

Возвращает

array<string,string>. JOIN keyed by alias.

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

// private - только в коде основоного (родительского) класса
$result = $this->build_address_join( $address_type, $order_alias, $alias_prefix ): array;
$address_type(строка) (обязательный)
'billing' or 'shipping'.
$order_alias(строка)
Orders-table alias to join from.
По умолчанию: 'orders'
$alias_prefix(строка)
Prefix for the address-table alias.
По умолчанию: 'address'

Код HposLegacyOrderReportQueryBuilder::build_address_join() WC 11.2.2

woocommerce/src/Internal/Admin/Reports/HposLegacyOrderReportQueryBuilder.php 
private function build_address_join( string $address_type, string $order_alias = 'orders', string $alias_prefix = 'address' ): array {
	$alias = "{$alias_prefix}_{$address_type}";
	return array(
		$alias => 'LEFT JOIN ' . OrdersTableDataStore::get_addresses_table_name() . " AS {$alias} ON ( {$order_alias}.id = {$alias}.order_id AND {$alias}.address_type = '{$address_type}' )",
	);
}