EmployeesWorkload::getBaseQuery

protected function getBaseQuery($startDate, $finishDate, $filterParameters)
{
	$query = StatisticTable::query();
	$query->addSelect('PORTAL_USER_ID');

	$this->addToQueryFilterCase($query, $filterParameters);
	$this->addCallTypeField($query, CallType::INCOMING, 'CALL_INCOMING');
	$this->addCallTypeField($query, CallType::OUTGOING, 'CALL_OUTGOING');
	$this->addCallTypeField($query, CallType::MISSED, 'CALL_MISSED');
	$this->addCallTypeField($query, CallType::ALL, 'CALL_COUNT');
	$query->whereBetween('CALL_START_DATE', $startDate, $finishDate);

	return $query;
}