BaseGraph::prepareQuery

public function prepareQuery(Query $query)
{
	$filterParameters = $this->getFilterParameters();
	$this->addToQueryFilterCase($query, $filterParameters);
	$this->addTimePeriodToQuery($query, $filterParameters['TIME_PERIOD'] ?? null);

	$this->addPermissionsCheck($query);

	$query->addSelect(Query::expr()->sum('OPPORTUNITY'), 'SUM');

	$closedDateFormat = $this->getDateGrouping() === static::GROUP_MONTH ? '%%Y-%%m-01' : '%%Y-%%m-%%d';
	$query->addSelect(new ExpressionField("CLOSED", "DATE_FORMAT(%s, '{$closedDateFormat}')", "CLOSEDATE"));

	$query->addSelect("CURRENCY_ID");

	return $query;
}