Automattic\WooCommerce\Internal\DataStores\Orders

OrdersTableDataStore::get_refund_orders_batch_join_clause │ protected │ WC 10.7.0

Returns a prepared SQL JOIN clause for finding refund orders belonging to multiple parent orders.

Overrides the CPT version to use the HPOS orders table.

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

Хуков нет.

Возвращает

string. Prepared SQL JOIN fragment.

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

// protected - в коде основоного (родительского) или дочернего класса
$result = $this->get_refund_orders_batch_join_clause( $order_ids ): string;
$order_ids(массив) (обязательный)
List of order IDs.

Список изменений

С версии 10.7.0 Введена.

Код OrdersTableDataStore::get_refund_orders_batch_join_clause() WC 11.1.1

woocommerce/src/Internal/DataStores/Orders/OrdersTableDataStore.php 
protected function get_refund_orders_batch_join_clause( array $order_ids ): string {
	global $wpdb;
	$id_list = implode( ', ', array_map( 'absint', $order_ids ) );
	// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared -- $id_list is sanitized via absint above.
	return $wpdb->prepare( "%i AS refunds ON ( refunds.type = %s AND refunds.parent_order_id IN ( $id_list ) )", self::get_orders_table_name(), 'shop_order_refund' );
}