@Override
protected void createResultTable(Table table, Query.Result result) throws SQLException {
Table.Row row = table.tr();
row.th().text(t8("employees.name")).style(CSS.WIDTH, "100%");
Table.Header h = row.th();
h.img(new URL("/images/email.png")).setAttr(Image.CLASS, "icon");
h.text(t8("users.eMail"));
row.th().text(t8("users.mobilePhone"));
row.th().text(t8("employees.employmentType"));
row.th().text(t8("status"));
row.th().text(t8("pay.slip.latest"));
row.th();
while (result.next()) {
Employee e = Employee.table.loadRec(cx(), result);
row = table.tr();
Table.Data d = row.td();
d.a(e.url(), e.user().fullName());
row.td().a(new URL("mailto: %s", e.user().eMail()), e.user().eMail());
row.td().text(e.user().mobilePhone());
row.td().text(t8(String.format("employmentType.%s", e.employmentType().name())));
d = row.td();
if (!e.isActive()) {
d.text(t8("inactive"));
} else if (result.getInt(assignmentCountQuery) == 0) {
d.text(t8("available"));
} else {
d.text(t8("busy"));
}
d = row.td();
if (!result.isNull(PaySlip.table.END_DATE)) {
PaySlip p = PaySlip.table.loadRec(cx(), result);
PaySlip.table.EMPLOYEE.setValue(p, e);
d.a(p.url(), cx().formatDate(p.endDate()));
}
d = row.td();
d.style(CSS.TEXT_ALIGN, "center");
d.a(e.url()).img(new URL("/images/open.png"));
}
}
