1 package compbio.controllers;
3 import java.text.ParseException;
4 import java.text.SimpleDateFormat;
5 import java.util.Calendar;
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;
15 import compbio.cassandra.DateBean;
16 import compbio.cassandra.TotalJobsStatisticBean;
17 import compbio.statistic.CassandraRequester;
20 * @author Alexander Sherstnev
21 * @author Natasha Sherstneva
24 public class DailyStatisticsController {
26 @RequestMapping(value = "/stat", method = RequestMethod.GET)
27 public String initFindForm(Map<String, Object> model) {
28 Calendar cal = Calendar.getInstance();
29 String date2 = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DATE);
30 cal.add(Calendar.DATE, -3);
31 String date1 = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DATE);
33 model.put("date1", date1);
34 model.put("date2", date2);
36 return "queryJobStatistics";
39 @RequestMapping(value = "/stat/query", method = RequestMethod.GET)
40 public String findJobsInPeriod(@RequestParam("date1") String date1, @RequestParam("date2") String date2,
41 @RequestParam("option") String option, Map<String, Object> model) {
42 final long startTime = System.currentTimeMillis();
44 CassandraRequester cr = new CassandraRequester();
45 if (option.equals("AllDates,off")) {
46 Calendar cal = Calendar.getInstance();
47 date1 = cr.earliestDateString();
48 date2 = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DAY_OF_MONTH);
50 model.put("date1", date1);
51 model.put("date2", date2);
52 TotalJobsStatisticBean res = cr.countJobs(date1, date2);
53 model.put("result", res);
54 final long endTime = System.currentTimeMillis();
55 model.put("timeExecution", (endTime - startTime));
56 model.put("option", option);
57 return "/reportJobStatistics";
60 @RequestMapping(value = "/stat/oneday", method = RequestMethod.GET)
61 public String findJobsInOneDay(@RequestParam("date") String date, Map<String, Object> model) throws ParseException {
62 final long startTime = System.currentTimeMillis();
65 final SimpleDateFormat formaterDDMMYY = new SimpleDateFormat("dd/MM/yyyy");
66 final SimpleDateFormat formaterYYMMDD = new SimpleDateFormat("yyyy/MM/dd");
68 long thetime = formaterYYMMDD.parse(date).getTime();
72 realdate = formaterDDMMYY.format(new Date(thetime));
74 } catch (ParseException e) {
78 CassandraRequester cr = new CassandraRequester();
79 // IMPORTANT: input should be suppied in the format: DD/MM/YYYY
80 DateBean r = cr.readJobByDay(realdate);
81 model.put("results", r);
83 model.put("njobs", r.getJobidAndSeq().size());
84 model.put("date", realdate);
85 final long endTime = System.currentTimeMillis();
86 model.put("timeExecution", (endTime - startTime));
87 return "/reportJobStatisticsOneDay";