Automattic\WooCommerce\Internal\Admin\Reports

HposLegacyOrderReportQueryBuilder::build_address_join │ private │ WC 1.0

Build the JOIN onto wc_order_addresses for one address type.

Method of the class: HposLegacyOrderReportQueryBuilder{}

No Hooks.

Returns

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

Usage

// private - for code of main (parent) class only
$result = $this->build_address_join( $address_type, $order_alias, $alias_prefix ): array;

$address_type(string) (required)

'billing' or 'shipping'.

$order_alias(string)

Orders-table alias to join from.
Default: 'orders'

$alias_prefix(string)

Prefix for the address-table alias.
Default: 'address'

HposLegacyOrderReportQueryBuilder::build_address_join() HposLegacyOrderReportQueryBuilder::build address join code ^{WC 11.1.2}

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}' )",
	);
}