EmployeesWorkloadGraph::getQueryForReport

protected function getQueryForReport($startDate, $finishDate, $previousStartDate, $previousFinishDate, $filterParameters): Query
{
	$subQuery = $this->getBaseQuery($previousStartDate, $previousFinishDate, $filterParameters);
	$query = $this->getBaseQuery($startDate, $finishDate, $filterParameters);

	$query->registerRuntimeField(new ReferenceField(
		'previous',
		Base::getInstanceByQuery($subQuery),
		Join::on('this.PORTAL_USER_ID', 'ref.PORTAL_USER_ID')
	));

	$this->addCallTypeCompareField($query, 'CALL_INCOMING');
	$this->addCallTypeCompareField($query, 'CALL_OUTGOING');
	$this->addCallTypeCompareField($query, 'CALL_MISSED');

	return $query;
}