Automattic\WooCommerce\Internal\DataStores\Orders

OrdersTableSearchQuery::generate_where() │ private │ WC 1.0

Generates the necessary WHERE clauses for the order search to be performed.

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

Хуков нет.

Возвращает

Строку.

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

// private - только в коде основоного (родительского) класса
$result = $this->generate_where(): string;

Код OrdersTableSearchQuery::generate_where() WC 8.7.0

woocommerce/src/Internal/DataStores/Orders/OrdersTableSearchQuery.php 
private function generate_where(): string {
	$where             = array();
	$possible_order_id = (string) absint( $this->search_term );
	$order_table       = $this->query->get_table_name( 'orders' );

	// Support the passing of an order ID as the search term.
	if ( (string) $this->query->get( 's' ) === $possible_order_id ) {
		$where[] = "`$order_table`.id = $possible_order_id";
	}

	foreach ( $this->search_filters as $search_filter ) {
		$search_where = $this->generate_where_for_search_filter( $search_filter );
		if ( ! empty( $search_where ) ) {
			$where[] = $search_where;
		}
	}

	$where_statement = implode( ' OR ', $where );

	return " ( $where_statement ) ";
}