First working Spring-based version
[proteocache.git] / server / compbio / controllers / DayStatisticsController.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.List;
8 import java.util.Map;
9
10 import org.springframework.beans.factory.annotation.Autowired;
11 import org.springframework.stereotype.Controller;
12 import org.springframework.validation.BindingResult;
13 import org.springframework.web.bind.WebDataBinder;
14 import org.springframework.web.bind.annotation.InitBinder;
15 import org.springframework.web.bind.annotation.ModelAttribute;
16 import org.springframework.web.bind.annotation.PathVariable;
17 import org.springframework.web.bind.annotation.RequestMapping;
18 import org.springframework.web.bind.annotation.RequestMethod;
19 import org.springframework.web.bind.annotation.RequestParam;
20
21
22 import compbio.cassandra.DataBase;
23 import compbio.statistic.CassandraRequester;
24 import compbio.statistic.StatisticsProt;
25
26 /**
27  * @author Alexander Sherstnev
28  * @author Natasha Sherstneva
29  */
30 @Controller
31 public class DayStatisticsController {
32
33         @RequestMapping(value = "/stat", method = RequestMethod.GET)
34         public String initFindForm(Map<String, Object> model) {
35                 return "QueryJobsByDate";
36         }
37
38         @RequestMapping(value = "/stat/query", method = RequestMethod.GET)
39         public String findJobsInPeriod(@RequestParam("data1") String date1, @RequestParam("data2") String date2,
40                         @RequestParam("option") String option, Map<String, Object> model) {
41                 final long startTime = System.currentTimeMillis();
42
43                 CassandraRequester cr = new CassandraRequester();
44                 if (option.equals("AllDates")) {
45                         Calendar cal = Calendar.getInstance();
46                         date1 = StatisticsProt.DateFormatYYMMDD(cr.earliestDate());
47                         date2 = cal.get(Calendar.YEAR) + "/" + (cal.get(Calendar.MONTH) + 1) + "/" + cal.get(Calendar.DAY_OF_MONTH);
48                 }
49                 model.put("data1", date1);
50                 model.put("data2", date2);
51                 List<DataBase> res = cr.countJobs(date1, date2);
52                 model.put("result", res);
53                 final long endTime = System.currentTimeMillis();
54                 model.put("timeExecution", (endTime - startTime));
55                 model.put("flag", option);
56                 return "/ReportJobsByDate";
57         }
58         
59         @RequestMapping(value = "/stat/oneday", method = RequestMethod.GET)
60         public String findJobsInOneDay(@RequestParam("date") String date, Map<String, Object> model) throws ParseException {
61                 final long startTime = System.currentTimeMillis();
62
63                 final SimpleDateFormat formaterDDMMYY = new SimpleDateFormat("dd/MM/yyyy");
64                 final SimpleDateFormat formaterYYMMDD = new SimpleDateFormat("yyyy/MM/dd");
65                 String date1 = formaterYYMMDD.format(new Date(formaterDDMMYY.parse(date).getTime()));
66         
67                 CassandraRequester cr = new CassandraRequester();
68                 List<DataBase> r1 = cr.countJobs(date1, date1);
69                 List<DataBase> r = cr.readJobByDay(date);
70                 model.put("results", r);
71                 model.put("njobs", r.size());
72                 model.put("date", date1);
73                 final long endTime = System.currentTimeMillis();
74                 model.put("timeExecution", (endTime - startTime));
75                 System.out.println("Request for date = " + date1 + ": " + r.size() + " jobs found");
76                 return "/ReportJobsOfOneDay";
77         }
78 }