server/compbio/controllers/DailyStatisticsController.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.Map;
   8
   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;
  13
  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;
  20
  21
  22 /**
  23  * @author Alexander Sherstnev
  24  * @author Natasha Sherstneva
  25  */
  26 @Controller
  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);
  33
  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";
  43         }
  44
  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;
  54                 }
  55
  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);
  63                 if (error != null) {
  64                         model.put("error", error);
  65                         model.put("date1", date1);
  66                         model.put("date2", date2);
  67                         return "query/JobStatistics";
  68                 }
  69
  70                 if (longDate1 < CassandraReader.earliestDate())
  71                         longDate1 = CassandraReader.earliestDate();
  72                 if (longDate2 > cal.getTimeInMillis())
  73                         longDate2 =  cal.getTimeInMillis();
  74
  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";
  86         }
  87
  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();
  93
  94                 String realdate;
  95                 try {
  96                         long thetime = formaterYYMMDD.parse(date).getTime();
  97                         if (thetime < 0) {
  98                                 realdate = date;
  99                         } else {
 100                                 realdate = formaterDDMMYY.format(new Date(thetime));
 101                         }
 102                 } catch (ParseException e) {
 103                         realdate = date;
 104                 }
 105
 106                 if (null == JobStatus.getJobStatus(status)) {
 107                         return "support/Notimplemented";
 108                 }
 109
 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);
 114                 if (r != null)
 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";
 121         }
 122
 123         private String DateChecking(String trimmeddate1, String trimmeddate2, long longDate1, long longDate2) {
 124
 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.";
 135                 else
 136                         return null;
 137         }
 138 }