1 package compbio.controllers;
3 import java.text.ParseException;
4 import java.text.SimpleDateFormat;
5 import java.util.Calendar;
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;
14 import compbio.engine.JobStatus;
15 import compbio.cassandra.CassandraReader;
16 import compbio.cassandra.DateBean;
17 import compbio.cassandra.DateFormatter;
18 import compbio.cassandra.TotalJobsStatisticBean;
19 import compbio.statistic.CassandraRequester;
23 * @author Alexander Sherstnev
24 * @author Natasha Sherstneva
27 public class DailyStatisticsController extends BasicController {
28 Calendar cal = Calendar.getInstance();
29 final SimpleDateFormat formaterDDMMYY = DateFormatter.getFormatDDMMYY();
30 final SimpleDateFormat formaterYYMMDD = DateFormatter.getFormatYYMMDD();
31 String theEaerlistDate = DateFormatter.DateLongToString(CassandraReader.earliestDate(), formaterYYMMDD);
32 String theCurrentDate = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DAY_OF_MONTH);
34 @RequestMapping(value = "/stat/jobs/query", method = RequestMethod.GET)
35 public String initFindForm(Map<String, Object> model) {
36 model.put("username", getPrincipalName());
37 String date2 = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DATE);
38 cal.add(Calendar.DATE, -3);
39 String date1 = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DATE);
40 model.put("date1", date1);
41 model.put("date2", date2);
42 return "query/JobStatistics";
45 @RequestMapping(value = "/stat/jobsdaily/results", method = RequestMethod.GET)
46 public String findJobsInPeriod(@RequestParam("date1") String date1, @RequestParam("date2") String date2,
47 @RequestParam("option") String option, Map<String, Object> model) {
48 model.put("username", getPrincipalName());
49 final long startTime = System.currentTimeMillis();
50 CassandraRequester cr = new CassandraRequester();
51 if (option.equals("AllDates,off")) {
52 date1 = theEaerlistDate;
53 date2 = theCurrentDate;
56 // dates in string format
57 String trimmeddate1 = date1.replaceAll("\\s", "");
58 String trimmeddate2 = date2.replaceAll("\\s", "");
59 // dates in long format
60 long longDate1 = DateFormatter.DateParsing(date1,formaterYYMMDD);
61 long longDate2 = DateFormatter.DateParsing(date2, formaterYYMMDD);
62 String error = DateChecking(trimmeddate1, trimmeddate2, longDate1, longDate2);
64 model.put("error", error);
65 model.put("date1", date1);
66 model.put("date2", date2);
67 return "query/JobStatistics";
70 if (longDate1 < CassandraReader.earliestDate())
71 longDate1 = CassandraReader.earliestDate();
72 if (longDate2 > cal.getTimeInMillis())
73 longDate2 = cal.getTimeInMillis();
75 date1 = DateFormatter.DateLongToString(longDate1, formaterYYMMDD);
76 date2 = DateFormatter.DateLongToString(longDate2, formaterYYMMDD);
77 model.put("date1", date1);
78 model.put("date2", date2);
79 TotalJobsStatisticBean res = cr.countJobs(date1, date2);
80 model.put("result", res);
81 model.put("ndays", res.getDateTotal().size());
82 final long endTime = System.currentTimeMillis();
83 model.put("timeExecution", (endTime - startTime));
84 model.put("option", option);
85 return "/reportJobStatistics";
88 @RequestMapping(value = "/stat/jobsoneday/results", method = RequestMethod.GET)
89 public String findJobsInOneDay(@RequestParam("date") String date, @RequestParam("status") String status, Map<String, Object> model)
90 throws ParseException {
91 model.put("username", getPrincipalName());
92 final long startTime = System.currentTimeMillis();
96 long thetime = formaterYYMMDD.parse(date).getTime();
100 realdate = formaterDDMMYY.format(new Date(thetime));
102 } catch (ParseException e) {
106 if (null == JobStatus.getJobStatus(status)) {
107 return "support/Notimplemented";
110 CassandraRequester cr = new CassandraRequester();
111 // IMPORTANT: input should be suppied in the format: DD/MM/YYYY
112 DateBean r = cr.readJobByDay(realdate, JobStatus.getJobStatus(status));
113 model.put("results", r);
115 model.put("njobs", r.getJobidAndSeq().size());
116 model.put("date", realdate);
117 model.put("status", status);
118 final long endTime = System.currentTimeMillis();
119 model.put("timeExecution", (endTime - startTime));
120 return "/reportJobStatisticsOneDay";
123 private String DateChecking(String trimmeddate1, String trimmeddate2, long longDate1, long longDate2) {
125 if (trimmeddate1.equalsIgnoreCase("") || trimmeddate2.equalsIgnoreCase(""))
126 return "The date cann't be empty";
127 else if (!DateFormatter.isThisDateValid(trimmeddate1, formaterYYMMDD) || !DateFormatter.isThisDateValid(trimmeddate2, formaterYYMMDD))
128 return "The date format in invalid. Try format yyyy/mm/dd";
129 else if (longDate2 < CassandraReader.earliestDate())
130 return "The date2 is after the earlestDate " + theEaerlistDate;
131 else if (longDate1 > cal.getTimeInMillis())
132 return "The date1 is before the current date " + theCurrentDate;
133 else if (longDate1 > longDate2)
134 return "Wrong date's diaposon. The date1 is more than date2.";