public function OrderItemsReport::buildQuery in Commerce Reporting 8

Builds the aggregate query.

Report type plugins should add their field columns, aggregates, and groupBy statements here.

Parameters

\Drupal\Core\Entity\Query\QueryAggregateInterface $query: The aggregate query.

Overrides ReportTypeInterface::buildQuery

File

src/Plugin/Commerce/ReportType/OrderItemsReport.php, line 145

Class

OrderItemsReport

Provides the Order Items Report.

Namespace

Drupal\commerce_reports\Plugin\Commerce\ReportType

Code

public function buildQuery(QueryAggregateInterface $query) {
  $query
    ->aggregate('title', 'COUNT');
  $query
    ->aggregate('quantity', 'SUM');
  $query
    ->aggregate('unit_price.number', 'SUM');
  $query
    ->aggregate('total_price.number', 'SUM');
  $query
    ->aggregate('adjusted_unit_price.number', 'SUM');
  $query
    ->aggregate('adjusted_total_price.number', 'SUM');
  $query
    ->groupBy('title');
  $query
    ->groupBy('unit_price.currency_code');
}