EmployeesWorkload::getQueryForReport

protected function getQueryForReport($startDate, $finishDate, $previousStartDate, $previousFinishDate, $filterParameters): Query;

/**
 * Creates a basic query to sample the workload of employees.
 *
 * @param $startDate
 * @param $finishDate
 * @param $filterParameters
 *
 * @return Query
 * @throws ArgumentException
 * @throws SystemException
 */
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;
}