private void addEmployeeRow(final ExportSheet sheet, final EmployeeDO employee, final BigDecimal numberOfWorkingDays, final BigDecimal totalDuration,
final MonthlyEmployeeReport report)
{
final PFUserDO user = getUserGroupCache().getUser(employee.getUserId());
final ExportRow row = sheet.addRow();
row.addCell(0, user.getFullname());
row.addCell(1, employee.getWeeklyWorkingHours(), "STUNDEN");
BigDecimal wochenstunden = employee.getWeeklyWorkingHours();
if (wochenstunden == null) {
wochenstunden = BigDecimal.ZERO;
}
final BigDecimal soll = wochenstunden.multiply(numberOfWorkingDays).divide(new BigDecimal(5), 2,
RoundingMode.HALF_UP);
row.addCell(2, soll, "STUNDEN");
final BigDecimal total = totalDuration.divide(new BigDecimal(3600000), 2, RoundingMode.HALF_UP);
row.addCell(3, total, "STUNDEN");
final BigDecimal differenz = total.subtract(soll);
row.addCell(4, differenz, "STUNDEN");
row.addCell(5, report.getUnbookedDays().size());
row.addCell(6, report.getFormattedUnbookedDays());
}