1. Move query jsps into a separate directory
[proteocache.git] / server / compbio / controllers / DailyStatisticsController.java
1 package compbio.controllers;
2
3 import java.text.ParseException;
4 import java.text.SimpleDateFormat;
5 import java.util.Calendar;
6 import java.util.Date;
7 import java.util.Map;
8
9 import org.springframework.stereotype.Controller;
10 import org.springframework.web.bind.annotation.RequestMapping;
11 import org.springframework.web.bind.annotation.RequestMethod;
12 import org.springframework.web.bind.annotation.RequestParam;
13
14 import compbio.engine.JobStatus;
15 import compbio.cassandra.DateBean;
16 import compbio.cassandra.TotalJobsStatisticBean;
17 import compbio.statistic.CassandraRequester;
18 import compbio.statistic.StatisticsProt;
19
20 /**
21  * @author Alexander Sherstnev
22  * @author Natasha Sherstneva
23  */
24 @Controller
25 public class DailyStatisticsController extends BasicController {
26
27         @RequestMapping(value = "/stat/jobs/query", method = RequestMethod.GET)
28         public String initFindForm(Map<String, Object> model) {
29                 model.put("username", getPrincipalName());
30                 Calendar cal = Calendar.getInstance();
31                 String date2 = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DATE);
32                 cal.add(Calendar.DATE, -3);
33                 String date1 = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DATE);
34
35                 model.put("date1", date1);
36                 model.put("date2", date2);
37
38                 return "query/JobStatistics";
39         }
40
41         @RequestMapping(value = "/stat/jobsdaily/results", method = RequestMethod.GET)
42         public String findJobsInPeriod(@RequestParam("date1") String date1, @RequestParam("date2") String date2,
43                         @RequestParam("option") String option, Map<String, Object> model) {
44                 model.put("username", getPrincipalName());
45                 final long startTime = System.currentTimeMillis();
46
47                 CassandraRequester cr = new CassandraRequester();
48                 if (option.equals("AllDates,off")) {
49                         Calendar cal = Calendar.getInstance();
50                         date1 = StatisticsProt.DateFormatYYMMDD(cr.earliestDate());
51                         date2 = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DAY_OF_MONTH);
52                 }
53                 model.put("date1", date1);
54                 model.put("date2", date2);
55                 TotalJobsStatisticBean res = cr.countJobs(date1, date2);
56                 model.put("result", res);
57                 model.put("ndays", res.getDateTotal().size());
58                 final long endTime = System.currentTimeMillis();
59                 model.put("timeExecution", (endTime - startTime));
60                 model.put("option", option);
61                 return "/reportJobStatistics";
62         }
63
64         @RequestMapping(value = "/stat/jobsoneday/results", method = RequestMethod.GET)
65         public String findJobsInOneDay(@RequestParam("date") String date, @RequestParam("status") String status, Map<String, Object> model)
66                         throws ParseException {
67                 model.put("username", getPrincipalName());
68                 final long startTime = System.currentTimeMillis();
69
70                 String realdate;
71                 final SimpleDateFormat formaterDDMMYY = new SimpleDateFormat("dd/MM/yyyy");
72                 final SimpleDateFormat formaterYYMMDD = new SimpleDateFormat("yyyy/MM/dd");
73                 try {
74                         long thetime = formaterYYMMDD.parse(date).getTime();
75                         if (thetime < 0) {
76                                 realdate = date;
77                         } else {
78                                 realdate = formaterDDMMYY.format(new Date(thetime));
79                         }
80                 } catch (ParseException e) {
81                         realdate = date;
82                 }
83
84                 if (null == JobStatus.getJobStatus(status)) {
85                         return "support/Notimplemented";
86                 }
87
88                 CassandraRequester cr = new CassandraRequester();
89                 // IMPORTANT: input should be suppied in the format: DD/MM/YYYY
90                 DateBean r = cr.readJobByDay(realdate, JobStatus.getJobStatus(status));
91                 model.put("results", r);
92                 if (r != null)
93                         model.put("njobs", r.getJobidAndSeq().size());
94                 model.put("date", realdate);
95                 model.put("status", status);
96                 final long endTime = System.currentTimeMillis();
97                 model.put("timeExecution", (endTime - startTime));
98                 return "/reportJobStatisticsOneDay";
99         }
100 }