Rating::prepareQuery

public function prepareQuery($periodSemantic = self::PERIOD_SEMANTIC_CURRENT)
{
	$query = DealTable::query();

	$filterParameters = $this->getFilterParameters();
	$this->addToQueryFilterCase($query, $filterParameters);
	$this->addTimePeriodToQuery($query, $filterParameters['TIME_PERIOD'], $periodSemantic);
	$this->addPermissionsCheck($query);

	$query
		->addSelect("ASSIGNED_BY_ID", "USER_ID")
		->addSelect(Query::expr()->count("ID"), "DEAL_COUNT")
		->addSelect(Query::expr()->sum("OPPORTUNITY_ACCOUNT"), "DEAL_AMOUNT");

	return $query;
}