Automattic\WooCommerce\Internal\DataStores\Orders

OrdersTableQuery::map_gmt_and_post_keys_to_hpos_keys │ private │ WC 1.0

Helper function to map posts and gmt based keys to HPOS keys.

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

Хуков нет.

Возвращает

array|mixed. Date query argument with modified keys.

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

// private - только в коде основоного (родительского) класса
$result = $this->map_gmt_and_post_keys_to_hpos_keys( $query );
$query(массив) (обязательный)
Date query argument.

Код OrdersTableQuery::map_gmt_and_post_keys_to_hpos_keys() WC 11.3.0

private function map_gmt_and_post_keys_to_hpos_keys( $query ) {
	if ( ! is_array( $query ) ) {
		return $query;
	}

	$post_to_hpos_mappings = array(
		'post_date'         => 'date_created',
		'post_date_gmt'     => 'date_created_gmt',
		'post_modified'     => 'date_updated',
		'post_modified_gmt' => 'date_updated_gmt',
		'_date_completed'   => 'date_completed',
		'_date_paid'        => 'date_paid',
		'date_modified'     => 'date_updated',
		'date_modified_gmt' => 'date_updated_gmt',
	);

	$local_to_gmt_date_keys = array(
		'date_created'   => 'date_created_gmt',
		'date_updated'   => 'date_updated_gmt',
		'date_paid'      => 'date_paid_gmt',
		'date_completed' => 'date_completed_gmt',
	);

	array_walk(
		$query,
		function ( &$sub_query ) {
			$sub_query = $this->map_gmt_and_post_keys_to_hpos_keys( $sub_query );
		}
	);

	if ( ! isset( $query['column'] ) ) {
		return $query;
	}

	if ( isset( $post_to_hpos_mappings[ $query['column'] ] ) ) {
		$query['column'] = $post_to_hpos_mappings[ $query['column'] ];
	}

	// Convert any local dates to GMT.
	if ( isset( $local_to_gmt_date_keys[ $query['column'] ] ) ) {
		$query['column']  = $local_to_gmt_date_keys[ $query['column'] ];
		$op               = isset( $query['after'] ) ? 'after' : 'before';
		$date_value_local = $query[ $op ];
		// date_create() honors an offset in the string; wc_string_to_datetime() re-applies the site offset to formats like "10:00:00.500Z" or "+02".
		$parsed_date    = is_string( $date_value_local ) && ! is_numeric( $date_value_local ) ? date_create( $date_value_local, wp_timezone() ) : false;
		$date_value_gmt = $parsed_date ? $parsed_date->getTimestamp() : wc_string_to_timestamp( get_gmt_from_date( wc_string_to_datetime( $date_value_local ) ) );
		$query[ $op ]   = $this->date_to_date_query_arg( $date_value_gmt );
	}

	return $query;
}