WonLostAmount::prepareQuery

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

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

	$query->whereIn('STAGE_SEMANTIC_ID', [PhaseSemantics::SUCCESS, PhaseSemantics::FAILURE]);

	return $query;
}