done time execution for queries, query by counter of job, total in column in query...
[proteocache.git] / website / ReportNew.jsp
1 <%@page import="java.util.ArrayList"%>
2 <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
3 <%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn" %>
4 <%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt" %>
5 <%@ taglib uri="http://displaytag.sf.net" prefix="dt" %>
6 <c:choose>
7 <c:when test="${flag == 'AllDate'}">
8 <h3>Jobs statistics for the whole period</h3>
9 </c:when>
10 <c:otherwise>
11 <h3>Jobs statistics for the Period: 
12 <c:out value = "${data1}"/> to <c:out value = "${data2}"/> </h3>
13 </c:otherwise>
14 </c:choose>
15 <h3>Time execution: ${timeExecution} ms</h3>
16 <table border="1" style = "border-collapse: collapse; white-space: nowrap"> 
17 <thead>
18 <tr>
19 <th rowspan="2"style="text-align: centre">Date</th>
20 <th colspan="4" style="text-align: centre">Number of Proteins</th>
21 </tr>
22 <tr>
23 <th style="text-align: centre">Total</th>
24 <th style="text-align: centre">Failed</th>
25 <th style="text-align: centre">Cancelled</th>
26 <th style="text-align: centre">Abandoned</th>
27 </tr>
28 </thead>
29 <tbody>
30 <c:set var="sum"  value="0" />
31 <c:forEach items="${result}" var="res">
32 <tr>
33 <td>${res.date}</td>
34 <c:set var="tot"  value="${res.total}" />
35 <c:set var="sum"  value="${sum + tot}" />
36 <td style="text-align: right"><c:out value = "${res.total}" /></td>
37 <td style="text-align: right">0</td>
38 <td style="text-align: right">0</td>
39 <td style="text-align: right">0</td>
40 </tr>
41 </c:forEach>
42 <tr style="font-weight: bolder;">
43 <td>Total:</td>
44 <td style="text-align: right">${sum}</td>
45 <td style="text-align: right">0</td>
46 <td style="text-align: right">0</td>
47 <td style="text-align: right">0</td>
48 </tr>
49 </tbody>
50 </table>