ScheduleRepository::findDepartmentAssignmentsByIds

public function findDepartmentAssignmentsByIds($departmentIds, $exceptScheduleId = null)
{
	if (empty($departmentIds))
	{
		return [];
	}
	$departmentAssignmentsResult = ScheduleDepartmentTable::query()
		->addSelect('*')
		->registerRuntimeField(new Reference('SCHEDULE', ScheduleTable::class, ['this.SCHEDULE_ID' => 'ref.ID']))
		->whereIn('DEPARTMENT_ID', $departmentIds)
		->where('SCHEDULE.DELETED', ScheduleTable::DELETED_NO);
	if ($exceptScheduleId > 0)
	{
		$departmentAssignmentsResult->whereNot('SCHEDULE_ID', $exceptScheduleId);
	}
	$departmentAssignmentsResult->setCacheTtl(3600 * 12);
	$departmentAssignmentsResult->cacheJoins(true);
	return $departmentAssignmentsResult
		->exec()
		->fetchCollection();
}