Automattic\WooCommerce\Admin\API\Reports

DataStore::format_join_selections() │ protected │ WC 1.0

Returns a comma separated list of the field names prepared to be used for a selection after a join with default_results.

Method of the class: DataStore{}

No Hooks.

Return

String.

Usage

// protected - for code of main (parent) or child class
$result = $this->format_join_selections( $fields, $default_results_fields, $outer_selections );

$fields(array) (required)

Array of fields name.

$default_results_fields(array) (required)

Fields to load from default_results table.

$outer_selections(array)

Array of fields that are not selected in the inner query.
Default: array()

DataStore::format_join_selections() DataStore::format join selections code ^{WC 8.7.0}

protected function format_join_selections( $fields, $default_results_fields, $outer_selections = array() ) {
	foreach ( $fields as $i => $field ) {
		foreach ( $default_results_fields as $default_results_field ) {
			if ( $field === $default_results_field ) {
				$field        = esc_sql( $field );
				$fields[ $i ] = "default_results.{$field} AS {$field}";
			}
		}
		if ( in_array( $field, $outer_selections, true ) && array_key_exists( $field, $this->report_columns ) ) {
			$fields[ $i ] = $this->report_columns[ $field ];
		}
	}
	return implode( ', ', $fields );
}