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.DateBean;
16 import compbio.cassandra.TotalJobsStatisticBean;
17 import compbio.statistic.CassandraRequester;
20 * @author Alexander Sherstnev
21 * @author Natasha Sherstneva
24 public class DailyStatisticsController extends BasicController {
26 @RequestMapping(value = "/stat/jobs/query", method = RequestMethod.GET)
27 public String initFindForm(Map<String, Object> model) {
28 model.put("username", getPrincipalName());
29 Calendar cal = Calendar.getInstance();
30 String date2 = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DATE);
31 cal.add(Calendar.DATE, -3);
32 String date1 = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DATE);
34 model.put("date1", date1);
35 model.put("date2", date2);
37 return "query/JobStatistics";
40 @RequestMapping(value = "/stat/jobsdaily/results", method = RequestMethod.GET)
41 public String findJobsInPeriod(@RequestParam("date1") String date1, @RequestParam("date2") String date2,
42 @RequestParam("option") String option, Map<String, Object> model) {
43 model.put("username", getPrincipalName());
44 final long startTime = System.currentTimeMillis();
46 CassandraRequester cr = new CassandraRequester();
47 if (option.equals("AllDates,off")) {
48 Calendar cal = Calendar.getInstance();
49 date1 = DateFormatYYMMDD(cr.earliestDate());
50 date2 = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DAY_OF_MONTH);
52 model.put("date1", date1);
53 model.put("date2", date2);
54 TotalJobsStatisticBean res = cr.countJobs(date1, date2);
55 model.put("result", res);
56 model.put("ndays", res.getDateTotal().size());
57 final long endTime = System.currentTimeMillis();
58 model.put("timeExecution", (endTime - startTime));
59 model.put("option", option);
60 return "/reportJobStatistics";
63 @RequestMapping(value = "/stat/jobsoneday/results", method = RequestMethod.GET)
64 public String findJobsInOneDay(@RequestParam("date") String date, @RequestParam("status") String status, Map<String, Object> model)
65 throws ParseException {
66 model.put("username", getPrincipalName());
67 final long startTime = System.currentTimeMillis();
70 final SimpleDateFormat formaterDDMMYY = new SimpleDateFormat("dd/MM/yyyy");
71 final SimpleDateFormat formaterYYMMDD = new SimpleDateFormat("yyyy/MM/dd");
73 long thetime = formaterYYMMDD.parse(date).getTime();
77 realdate = formaterDDMMYY.format(new Date(thetime));
79 } catch (ParseException e) {
83 if (null == JobStatus.getJobStatus(status)) {
84 return "support/Notimplemented";
87 CassandraRequester cr = new CassandraRequester();
88 // IMPORTANT: input should be suppied in the format: DD/MM/YYYY
89 DateBean r = cr.readJobByDay(realdate, JobStatus.getJobStatus(status));
90 model.put("results", r);
92 model.put("njobs", r.getJobidAndSeq().size());
93 model.put("date", realdate);
94 model.put("status", status);
95 final long endTime = System.currentTimeMillis();
96 model.put("timeExecution", (endTime - startTime));
97 return "/reportJobStatisticsOneDay";
103 private String DateFormatYYMMDD(long indate) {
104 SimpleDateFormat datformat = new SimpleDateFormat("yyyy/MM/dd");
105 String dateString = datformat.format(new Date(indate));