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.DateBean;
  16 import compbio.cassandra.TotalJobsStatisticBean;
  17 import compbio.statistic.CassandraRequester;
  18
  19 /**
  20  * @author Alexander Sherstnev
  21  * @author Natasha Sherstneva
  22  */
  23 @Controller
  24 public class DailyStatisticsController extends BasicController {
  25
  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);
  33
  34                 model.put("date1", date1);
  35                 model.put("date2", date2);
  36
  37                 return "query/JobStatistics";
  38         }
  39
  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();
  45
  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);
  51                 }
  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";
  61         }
  62
  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();
  68
  69                 String realdate;
  70                 final SimpleDateFormat formaterDDMMYY = new SimpleDateFormat("dd/MM/yyyy");
  71                 final SimpleDateFormat formaterYYMMDD = new SimpleDateFormat("yyyy/MM/dd");
  72                 try {
  73                         long thetime = formaterYYMMDD.parse(date).getTime();
  74                         if (thetime < 0) {
  75                                 realdate = date;
  76                         } else {
  77                                 realdate = formaterDDMMYY.format(new Date(thetime));
  78                         }
  79                 } catch (ParseException e) {
  80                         realdate = date;
  81                 }
  82
  83                 if (null == JobStatus.getJobStatus(status)) {
  84                         return "support/Notimplemented";
  85                 }
  86
  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);
  91                 if (r != null)
  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";
  98         }
  99
 100         /*
 101          * convert ???
 102          */
 103         private String DateFormatYYMMDD(long indate) {
 104                 SimpleDateFormat datformat = new SimpleDateFormat("yyyy/MM/dd");
 105                 String dateString = datformat.format(new Date(indate));
 106                 return dateString;
 107         }
 108
 109 }