Automattic\WooCommerce\Admin\API\Reports\Products

DataStore::add_from_sql_params() │ protected │ WC 1.0

Fills FROM clause of SQL request based on user supplied parameters.

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

Хуков нет.

Возвращает

null. Ничего (null).

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

// protected - в коде основоного (родительского) или дочернего класса
$result = $this->add_from_sql_params( $query_args, $arg_name, $id_cell );
$query_args(массив) (обязательный)
Parameters supplied by the user.
$arg_name(строка) (обязательный)
Target of the JOIN sql param.
$id_cell(строка) (обязательный)
ID cell identifier, like table_name.id_column_name.

Код DataStore::add_from_sql_params() WC 8.7.0

woocommerce/src/Admin/API/Reports/Products/DataStore.php 
protected function add_from_sql_params( $query_args, $arg_name, $id_cell ) {
	global $wpdb;

	$type = 'join';
	// Order by product name requires extra JOIN.
	switch ( $query_args['orderby'] ) {
		case 'product_name':
			$join = " JOIN {$wpdb->posts} AS _products ON {$id_cell} = _products.ID";
			break;
		case 'sku':
			$join = " LEFT JOIN {$wpdb->postmeta} AS postmeta ON {$id_cell} = postmeta.post_id AND postmeta.meta_key = '_sku'";
			break;
		case 'variations':
			$type = 'left_join';
			$join = "LEFT JOIN ( SELECT post_parent, COUNT(*) AS variations FROM {$wpdb->posts} WHERE post_type = 'product_variation' GROUP BY post_parent ) AS _variations ON {$id_cell} = _variations.post_parent";
			break;
		default:
			$join = '';
			break;
	}
	if ( $join ) {
		if ( 'inner' === $arg_name ) {
			$this->subquery->add_sql_clause( $type, $join );
		} else {
			$this->add_sql_clause( $type, $join );
		}
	}
}