private void checkHubsAndFacilities_facilityInfo(Workbook workbook) { final Sheet facilities = workbook.getSheetAt(1); assertThat(facilities.getPhysicalNumberOfRows()).isEqualTo(2); final List<String> facilityInfo = getDataFromRow(facilities, 1); assertThat(facilityInfo) .containsSequence( facility1.name.fi, String.join(", ", facility1.aliases), hub.name.fi, operator1.name.fi, translationService.translate(facility1.status), facility1.statusDescription.fi, String.format(Locale.ENGLISH, "%.4f", facility1.location.getCentroid().getX()), String.format(Locale.ENGLISH, "%.4f", facility1.location.getCentroid().getY()), "", "08:00 - 18:00", "08:00 - 18:00", facility1.openingHours.info.fi, "" + facility1 .builtCapacity .entrySet() .stream() .filter(entry -> asList(motorCapacities).contains(entry.getKey())) .mapToInt(entry -> entry.getValue()) .sum(), "" + facility1 .builtCapacity .entrySet() .stream() .filter(entry -> asList(bicycleCapacities).contains(entry.getKey())) .mapToInt(entry -> entry.getValue()) .sum(), "" + facility1.builtCapacity.getOrDefault(CAR, 0), "" + facility1.builtCapacity.getOrDefault(DISABLED, 0), "" + facility1.builtCapacity.getOrDefault(ELECTRIC_CAR, 0), "" + facility1.builtCapacity.getOrDefault(MOTORCYCLE, 0), "" + facility1.builtCapacity.getOrDefault(BICYCLE, 0), "" + facility1.builtCapacity.getOrDefault(BICYCLE_SECURE_SPACE, 0)); }
private void checkMaxUtilization_rows(Workbook workbook) { /* EXAMPLE: Hubi Helsinki X-Park Liityntä Henkilöauto Toiminnassa 50 Arkipäivä 100 % Hubi Helsinki X-Park Liityntä Henkilöauto Toiminnassa 50 Lauantai 100 % Hubi Helsinki X-Park Liityntä Henkilöauto Toiminnassa 50 Sunnuntai 100 % */ final Sheet utilization = workbook.getSheetAt(0); assertThat(utilization.getPhysicalNumberOfRows()).isEqualTo(4); final List<String> businessDay = getDataFromRow(utilization, 1); assertThat(businessDay) .containsExactly( hub.name.fi, "Helsinki", // The region name operator1.name.fi, translationService.translate(facility1.usages.first()), translationService.translate(CAR), translationService.translate(facility1.status), "" + facility1.builtCapacity.get(CAR), translationService.translate(DayType.BUSINESS_DAY), "100%"); final List<String> saturday = getDataFromRow(utilization, 2); assertThat(saturday) .containsExactly( hub.name.fi, "Helsinki", // The region name operator1.name.fi, translationService.translate(facility1.usages.first()), translationService.translate(CAR), translationService.translate(facility1.status), "" + facility1.builtCapacity.get(CAR), translationService.translate(DayType.SATURDAY), "50%"); final List<String> sunday = getDataFromRow(utilization, 3); assertThat(sunday) .containsExactly( hub.name.fi, "Helsinki", // The region name operator1.name.fi, translationService.translate(facility1.usages.first()), translationService.translate(CAR), translationService.translate(facility1.status), "" + facility1.builtCapacity.get(CAR), translationService.translate(DayType.SUNDAY), "20%"); }