Abstract_WC_Order_Data_Store_CPT::get_refund_orders_join_clause │ protected │ WC 10.7.0

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

The clause aliases the refund table as refunds. Subclasses should override this to use a different table (e.g. the HPOS orders table).

Method of the class: Abstract_WC_Order_Data_Store_CPT{}

No Hooks.

Returns

string. Prepared SQL JOIN fragment.

Usage

// protected - for code of main (parent) or child class
$result = $this->get_refund_orders_join_clause( $order_id ): string;

$order_id(int) (required)

Parent order ID.

Changelog

Abstract_WC_Order_Data_Store_CPT::get_refund_orders_join_clause() Abstract WC Order Data Store CPT::get refund orders join clause code ^{WC 11.1.2}

protected function get_refund_orders_join_clause( int $order_id ): string {
	global $wpdb;
	return $wpdb->prepare( '%i AS refunds ON ( refunds.post_type = %s AND refunds.post_parent = %d )', $wpdb->posts, 'shop_order_refund', $order_id );
}