Automattic\WooCommerce\Admin\API\Reports

DataStore::add_order_status_clause() │ protected │ WC 1.0

Add order status SQL clauses if included in query.

Method of the class: DataStore{}

No Hooks.

Return

null. Nothing (null).

Usage

// protected - for code of main (parent) or child class
$result = $this->add_order_status_clause( $query_args, $table_name, $sql_query );
$query_args(array) (required)
Parameters supplied by the user.
$table_name(string) (required)
Database table name.
$sql_query(SqlQuery) (required) (passed by reference — &)
Query object.

DataStore::add_order_status_clause() code WC 8.7.0

woocommerce/src/Admin/API/Reports/DataStore.php 
protected function add_order_status_clause( $query_args, $table_name, &$sql_query ) {
	global $wpdb;
	$order_status_filter = $this->get_status_subquery( $query_args );
	if ( $order_status_filter ) {
		$sql_query->add_sql_clause( 'join', "JOIN {$wpdb->prefix}wc_order_stats ON {$table_name}.order_id = {$wpdb->prefix}wc_order_stats.order_id" );
		$sql_query->add_sql_clause( 'where', "AND ( {$order_status_filter} )" );
	}
}