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