List of usage examples for org.joda.time Months monthsBetween
public static Months monthsBetween(ReadablePartial start, ReadablePartial end)
Months representing the number of whole months between the two specified partial datetimes. From source file:ar.com.zir.utils.DateUtils.java
License:Open Source License
/** * Method that uses Joda Library to obtain the difference between two dates * in the specified date part//from www. j a va2 s. c o m * * @param datePart the datePart to use in the calculation * @param date1 first Date object * @param date2 second Date object * @return the result from date1 - date2 or -1 if specified datePart is not supported * @see java.util.Calendar */ public static int dateDiff(int datePart, Date date1, Date date2) { Calendar cal1 = Calendar.getInstance(); cal1.setTime(date1); Calendar cal2 = Calendar.getInstance(); cal2.setTime(date2); switch (datePart) { case DATE_PART_SECOND: return Seconds .secondsBetween(new DateTime(cal2.getTimeInMillis()), new DateTime(cal1.getTimeInMillis())) .getSeconds(); case DATE_PART_MINUTE: return Minutes .minutesBetween(new DateTime(cal2.getTimeInMillis()), new DateTime(cal1.getTimeInMillis())) .getMinutes(); case DATE_PART_HOUR: return Hours.hoursBetween(new DateTime(cal2.getTimeInMillis()), new DateTime(cal1.getTimeInMillis())) .getHours(); case DATE_PART_DAY: return Days.daysBetween(new DateTime(cal2.getTimeInMillis()), new DateTime(cal1.getTimeInMillis())) .getDays(); case DATE_PART_MONTH: return Months.monthsBetween(new DateTime(cal2.getTimeInMillis()), new DateTime(cal1.getTimeInMillis())) .getMonths(); case DATE_PART_YEAR: return Years.yearsBetween(new DateTime(cal2.getTimeInMillis()), new DateTime(cal1.getTimeInMillis())) .getYears(); default: return -1; } }
From source file:co.malm.mglam_reads.backend.util.DateDiffUtil.java
License:Apache License
/** * Calculates time differences using two dates, and stores it into a * {@linkplain java.util.Map} object.// w w w . j ava2s.c om * * @param map calculations data * @param dt1 first date for diff * @param dt2 second date for diff * @see org.joda.time.DateTime * @see org.joda.time.Years * @see org.joda.time.Months * @see org.joda.time.Weeks * @see org.joda.time.Days * @see org.joda.time.Hours * @see org.joda.time.Minutes * @see org.joda.time.Seconds */ private void calculate(HashMap<String, Integer> map, DateTime dt1, DateTime dt2) { final int SECONDS_IN_MINUTE = 60; final int MINUTES_IN_HOUR = 60; final int HOURS_IN_DAY = 24; final int DAYS_IN_MONTH = 31; final int MONTHS_IN_YEAR = 12; final int WEEKS_IN_DAY = 7; int diffYears = Years.yearsBetween(dt1, dt2).getYears(); if (diffYears > 0) { map.put("years", diffYears); } int diffMonths = Months.monthsBetween(dt1, dt2).getMonths(); if (diffMonths >= 1 && diffMonths < MONTHS_IN_YEAR) { map.put("months", diffMonths); } int diffWeeks = Weeks.weeksBetween(dt1, dt2).getWeeks(); if (diffWeeks >= 1 && diffWeeks < WEEKS_IN_DAY) { map.put("weeks", diffWeeks); } int diffDays = Days.daysBetween(dt1, dt2).getDays(); if (diffDays >= 1 && diffDays < DAYS_IN_MONTH) { map.put("days", diffDays); } int diffHours = Hours.hoursBetween(dt1, dt2).getHours(); if (diffHours >= 1 && diffHours < HOURS_IN_DAY) { map.put("hours", diffHours); } int diffMinutes = Minutes.minutesBetween(dt1, dt2).getMinutes(); if (diffMinutes >= 1 && diffMinutes < MINUTES_IN_HOUR) { map.put("minutes", diffMinutes); } int diffSeconds = Seconds.secondsBetween(dt1, dt2).getSeconds(); if (diffSeconds >= 1 && diffSeconds < SECONDS_IN_MINUTE) { map.put("seconds", diffSeconds); } }
From source file:com.axelor.apps.tool.date.Period.java
License:Open Source License
public int getMonths() { if (this.days360) { return DateTool.days360MonthsBetween(this.from, this.to); } else {/*from w w w.java 2 s . c o m*/ return Months.monthsBetween(this.from, this.to).getMonths(); } }
From source file:com.billing.ng.entities.CurrentBillingCycle.java
License:Open Source License
/** * Calculates the number of complete cycles between the given billing start date and * the given "today's" date./*from ww w . j a v a2 s . c o m*/ * * @param period billing period * @param billingStart billing cycle start * @param today end date * @return number of complete cycles */ public static Integer calculateCycleNumber(BillingPeriod period, DateMidnight billingStart, DateMidnight today) { Integer interval = period.getInterval(); switch (period.getType()) { case DAY: return Days.daysBetween(billingStart, today).getDays() / interval; case WEEK: return Weeks.weeksBetween(billingStart, today).getWeeks() / interval; case MONTH: return Months.monthsBetween(billingStart, today).getMonths() / interval; case YEAR: return Years.yearsBetween(billingStart, today).getYears() / interval; } return null; }
From source file:com.c2a.vie.managedbeans.deces.ContratgroupeManagedBean.java
public int dureecontrat() { LocalDate dateeffet = new LocalDate(formContrat.getDateeffet().getTime()); LocalDate datefin = new LocalDate(formContrat.getDateexp().getTime()); return (Months.monthsBetween(dateeffet, datefin).getMonths()); }
From source file:com.c2a.vie.managedbeans.deces.ContratgroupeManagedBean.java
public int dureecontratren() { LocalDate dateeffet = new LocalDate(formrenvlmntcontrat.getDateeffet().getTime()); LocalDate datefin = new LocalDate(formrenvlmntcontrat.getDateexp().getTime()); return (Months.monthsBetween(dateeffet, datefin).getMonths()); }
From source file:com.c2a.vie.managedbeans.deces.ContratgroupeManagedBean.java
public int dureristourne() { LocalDate dateeffet = new LocalDate(new Date().getTime()); LocalDate datefin = new LocalDate(formrenvlmntcontrat.getDateexp().getTime()); return (Months.monthsBetween(dateeffet, datefin).getMonths()); }
From source file:com.cisco.dvbu.ps.utils.date.DateDiffDate.java
License:Open Source License
/** * Called to invoke the stored procedure. Will only be called a * single time per instance. Can throw CustomProcedureException or * SQLException if there is an error during invoke. *//* w w w . jav a 2s . co m*/ public void invoke(Object[] inputValues) throws CustomProcedureException, SQLException { java.util.Date startDate = null; java.util.Date endDate = null; Calendar startCal = null; Calendar endCal = null; DateTime startDateTime = null; DateTime endDateTime = null; String datePart = null; long dateLength = 0; try { result = null; if (inputValues[0] == null) { result = new Long(dateLength); return; } if (inputValues[1] == null) { result = new Long(dateLength); return; } if (inputValues[2] == null) { result = new Long(dateLength); return; } datePart = (String) inputValues[0]; startDate = (java.util.Date) inputValues[1]; startCal = Calendar.getInstance(); startCal.setTime(startDate); endDate = (java.util.Date) inputValues[2]; endCal = Calendar.getInstance(); endCal.setTime(endDate); startDateTime = new DateTime(startCal.get(Calendar.YEAR), startCal.get(Calendar.MONTH) + 1, startCal.get(Calendar.DAY_OF_MONTH), 0, 0, 0, 0); endDateTime = new DateTime(endCal.get(Calendar.YEAR), endCal.get(Calendar.MONTH) + 1, endCal.get(Calendar.DAY_OF_MONTH), 0, 0, 0, 0); if (datePart.equalsIgnoreCase("second")) { Seconds seconds = Seconds.secondsBetween(startDateTime, endDateTime); dateLength = seconds.getSeconds(); } if (datePart.equalsIgnoreCase("minute")) { Minutes minutes = Minutes.minutesBetween(startDateTime, endDateTime); dateLength = minutes.getMinutes(); } if (datePart.equalsIgnoreCase("hour")) { Hours hours = Hours.hoursBetween(startDateTime, endDateTime); dateLength = hours.getHours(); } if (datePart.equalsIgnoreCase("day")) { Days days = Days.daysBetween(startDateTime, endDateTime); dateLength = days.getDays(); } if (datePart.equalsIgnoreCase("week")) { Weeks weeks = Weeks.weeksBetween(startDateTime, endDateTime); dateLength = weeks.getWeeks(); } if (datePart.equalsIgnoreCase("month")) { Months months = Months.monthsBetween(startDateTime, endDateTime); dateLength = months.getMonths(); } if (datePart.equalsIgnoreCase("year")) { Years years = Years.yearsBetween(startDateTime, endDateTime); dateLength = years.getYears(); } result = new Long(dateLength); } catch (Throwable t) { throw new CustomProcedureException(t); } }
From source file:com.eucalyptus.portal.Ec2ReportsService.java
License:Open Source License
public ViewInstanceUsageReportResponseType viewInstanceUsageReport(final ViewInstanceUsageReportType request) throws Ec2ReportsServiceException { final ViewInstanceUsageReportResponseType response = request.getReply(); final Context context = checkAuthorized(); try {/*from www .ja v a 2s . c o m*/ final Function<ViewInstanceUsageReportType, Optional<Ec2ReportsServiceException>> requestVerifier = ( req) -> { if (req.getGranularity() == null) return Optional.of(new Ec2ReportsInvalidParameterException("Granularity must be specified")); final String granularity = req.getGranularity().toLowerCase(); if (request.getTimeRangeStart() == null || request.getTimeRangeEnd() == null) return Optional.of( new Ec2ReportsInvalidParameterException("time range start and end must be specified")); if (!Sets.newHashSet("hourly", "hour", "daily", "day", "monthly", "month").contains(granularity)) { return Optional.of(new Ec2ReportsInvalidParameterException( "Can't recognize granularity. Valid values are hourly, daily and monthly")); } if (granularity.equals("hourly") || granularity.equals("hour")) { // AWS: time range up to 7 days when using an hourly data granularity if (Days.daysBetween(new DateTime(request.getTimeRangeStart().getTime()), new DateTime(request.getTimeRangeEnd().getTime())).getDays() > 7) { return Optional.of(new Ec2ReportsInvalidParameterException( "time range is allowed up to 7 days when using an hourly data granularity")); } } else if (granularity.equals("daily") || granularity.equals("day")) { // AWS: time range up to 3 months when using a daily data granularity if (Months.monthsBetween(new DateTime(request.getTimeRangeStart().getTime()), new DateTime(request.getTimeRangeEnd().getTime())).getMonths() > 3) { return Optional.of(new Ec2ReportsInvalidParameterException( "time range is allowed up to 3 months when using a daily data granularity")); } } else { // AWS: time range up to 3 years when using a monthly data granularity. if (Years.yearsBetween(new DateTime(request.getTimeRangeStart().getTime()), new DateTime(request.getTimeRangeEnd().getTime())).getYears() > 3) { return Optional.of(new Ec2ReportsInvalidParameterException( "time range is allowed up to 3 years when using a monthly data granularity")); } } if (request.getGroupBy() != null) { if (request.getGroupBy().getType() == null) return Optional.of(new Ec2ReportsInvalidParameterException( "In group by parameter, type must be specified")); final String groupType = request.getGroupBy().getType().toLowerCase(); final String groupKey = request.getGroupBy().getKey(); if (!Sets.newHashSet("tag", "tags", "instancetype", "instance_type", "platform", "platforms", "availabilityzone", "availability_zone").contains(groupType)) { return Optional.of(new Ec2ReportsInvalidParameterException( "supported types in group by parameter are: tag, instance_type, platform, and availability_zone")); } if ("tag".equals(groupType) || "tags".equals(groupType)) { if (groupKey == null) { return Optional.of(new Ec2ReportsInvalidParameterException( "tag type in group by parameter must also include tag key")); } } } return Optional.empty(); }; final Optional<Ec2ReportsServiceException> error = requestVerifier.apply(request); if (error.isPresent()) { throw error.get(); } final String granularity = request.getGranularity().toLowerCase(); final List<InstanceHourLog> logs = Lists.newArrayList(); if (granularity.equals("hourly") || granularity.equals("hour")) { logs.addAll(InstanceLogs.getInstance().queryHourly(context.getAccountNumber(), request.getTimeRangeStart(), request.getTimeRangeEnd(), request.getFilters())); } else if (granularity.equals("daily") || granularity.equals("day")) { logs.addAll(InstanceLogs.getInstance().queryDaily(context.getAccountNumber(), request.getTimeRangeStart(), request.getTimeRangeEnd(), request.getFilters())); } else { logs.addAll(InstanceLogs.getInstance().queryMonthly(context.getAccountNumber(), request.getTimeRangeStart(), request.getTimeRangeEnd(), request.getFilters())); } Collector<InstanceHourLog, ?, Map<String, List<InstanceHourLog>>> collector = null; Comparator<String> keySorter = String::compareTo; // determines which column appear first if (request.getGroupBy() != null) { final String groupType = request.getGroupBy().getType().toLowerCase(); final String groupKey = request.getGroupBy().getKey(); if ("instancetype".equals(groupType) || "instance_type".equals(groupType)) { collector = groupingBy((log) -> log.getInstanceType(), toList()); keySorter = String::compareTo; // sort by type name is natural } else if ("platform".equals(groupType) || "platforms".equals(groupType)) { collector = groupingBy((log) -> log.getPlatform(), toList()); keySorter = String::compareTo; // linux comes before windows } else if ("availabilityzone".equals(groupType) || "availability_zone".equals(groupType)) { collector = groupingBy((log) -> log.getAvailabilityZone(), toList()); keySorter = String::compareTo; } else if ("tag".equals(groupType) || "tags".equals(groupType)) { // map instanceId to tag value where tag key = group key final Map<String, String> tagValueMap = logs.stream() .collect(groupingBy((log) -> log.getInstanceId(), toList())).entrySet().stream() .map(e -> e.getValue().get(0)) .filter(l -> l.getTags().stream().filter(t -> groupKey.equals(t.getKey())).findAny() .isPresent()) .collect(Collectors.toMap(l -> l.getInstanceId(), l -> l.getTags().stream() .filter(t -> groupKey.equals(t.getKey())).findAny().get().getValue())); logs.stream().forEach(l -> { if (!tagValueMap.containsKey(l.getInstanceId())) tagValueMap.put(l.getInstanceId(), "[UNTAGGED]"); }); collector = groupingBy((log) -> tagValueMap.get(log.getInstanceId()), toList()); keySorter = (s1, s2) -> { if ("[UNTAGGED]".equals(s1) && "[UNTAGGED]".equals(s2)) return 0; else if ("[UNTAGGED]".equals(s1)) return -1; else if ("[UNTAGGED]".equals(s2)) return 1; else return s1.compareTo(s2); }; } else { throw new Ec2ReportsInvalidParameterException( "supported types in group by parameter are: tag, instance_type, platform, and availability_zone"); } } else { collector = groupingBy((log) -> "[INSTANCE HOURS]", toList()); } final Function<Date, AbstractMap.SimpleEntry<Date, Date>> ranger = (logTime) -> { final Calendar start = Calendar.getInstance(); final Calendar end = Calendar.getInstance(); start.setTime(logTime); end.setTime(logTime); if (granularity.equals("hourly") || granularity.equals("hour")) { end.set(Calendar.HOUR_OF_DAY, end.get(Calendar.HOUR_OF_DAY) + 1); } else if (granularity.equals("daily") || granularity.equals("day")) { end.set(Calendar.DAY_OF_MONTH, start.get(Calendar.DAY_OF_MONTH) + 1); start.set(Calendar.HOUR_OF_DAY, 0); end.set(Calendar.HOUR_OF_DAY, 0); } else { end.set(Calendar.MONTH, start.get(Calendar.MONTH) + 1); start.set(Calendar.DAY_OF_MONTH, 1); start.set(Calendar.HOUR_OF_DAY, 0); end.set(Calendar.DAY_OF_MONTH, 1); end.set(Calendar.HOUR_OF_DAY, 0); } for (final int flag : new int[] { Calendar.MINUTE, Calendar.SECOND, Calendar.MILLISECOND }) { start.set(flag, 0); end.set(flag, 0); } return new AbstractMap.SimpleEntry<Date, Date>(start.getTime(), end.getTime()); }; // sum over instance hours whose log_time is the same /* e.g., INPUT: m1.small -> [(i-1d9eb607,2017-03-16 12:00:00), (i-1d9eb607,2017-03-16 13:00:00), (i-fe4a9384,2017-03-16 13:00:00)] OUTPUT: m1.small -> [2017-03-16 12:00:00: 1, 2017-03-16 13:00:00: 2] */ final Map<String, List<InstanceHourLog>> logsByGroupKey = logs.stream().collect(collector); final Map<String, Map<Date, Long>> hoursAtLogTimeByGroupKey = logsByGroupKey.entrySet().stream() .collect(Collectors.toMap(e -> e.getKey(), e -> e.getValue().stream() .collect(groupingBy(l -> l.getLogTime(), summingLong(l -> l.getHours())) // -> Map<String, Map<Date, Long> ))); // key -> [(log_time, hours)...] final Map<String, List<AbstractMap.SimpleEntry<Date, Long>>> instanceHoursAtLogTime = hoursAtLogTimeByGroupKey .entrySet().stream() .collect(Collectors.toMap(e -> e.getKey(), e -> e.getValue().entrySet().stream() .map(e1 -> new AbstractMap.SimpleEntry<Date, Long>(e1.getKey(), e1.getValue())) .collect(toList()))); final StringBuilder sb = new StringBuilder(); sb.append("Start Time,End Time"); for (final String key : instanceHoursAtLogTime.keySet().stream().sorted(keySorter).collect(toList())) { sb.append(String.format(",%s", key)); } // fill-in missing logs (with 0 hours) in the table final Set<Date> distinctLogs = instanceHoursAtLogTime.values().stream().flatMap(e -> e.stream()) .map(kv -> kv.getKey()).distinct().collect(toSet()); for (final String groupKey : instanceHoursAtLogTime.keySet()) { final List<AbstractMap.SimpleEntry<Date, Long>> hours = instanceHoursAtLogTime.get(groupKey); final Set<Date> currentLogs = hours.stream().map(kv -> kv.getKey()).collect(toSet()); final List<AbstractMap.SimpleEntry<Date, Long>> normalized = Lists.newArrayList(hours); for (final Date missing : Sets.difference(distinctLogs, currentLogs)) { normalized.add(new AbstractMap.SimpleEntry<Date, Long>(missing, 0L)); } instanceHoursAtLogTime.put(groupKey, normalized); } final DateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); final Map<Date, String> lines = Maps.newHashMap(); for (final String groupKey : instanceHoursAtLogTime.keySet().stream().sorted(keySorter) .collect(toList())) { for (final AbstractMap.SimpleEntry<Date, Long> hl : instanceHoursAtLogTime.get(groupKey)) { final Date logTime = hl.getKey(); final Long hours = hl.getValue(); if (!lines.containsKey(logTime)) { lines.put(logTime, String.format("%s,%s,%d", df.format(ranger.apply(logTime).getKey()), df.format(ranger.apply(logTime).getValue()), hours)); } else { lines.put(logTime, String.format("%s,%d", lines.get(logTime), hours)); } } } lines.entrySet().stream().sorted((e1, e2) -> e1.getKey().compareTo(e2.getKey())) // order by log time .map(e -> e.getValue()).forEach(s -> sb.append(String.format("\n%s", s))); final ViewInstanceUsageResult result = new ViewInstanceUsageResult(); result.setUsageReport(sb.toString()); response.setResult(result); } catch (final Ec2ReportsServiceException ex) { throw ex; } catch (final Exception ex) { handleException(ex); } return response; }
From source file:com.github.trohovsky.jira.analyzer.IssuesPerMonthStrategy.java
License:Apache License
@Override public void analyze(String jqlQueryTemplate, List<String> queryParameters) { String jqlQuery = String.format(jqlQueryTemplate, queryParameters.toArray()); // adjust the query to correctly order the results, it's required due to creation date int indexOfOrderBy = jqlQuery.indexOf("ORDER BY"); if (indexOfOrderBy != -1) { jqlQuery = jqlQuery.substring(0, indexOfOrderBy - 1); }// w w w . j av a 2s.c o m jqlQuery += " ORDER BY created ASC"; // TODO JRJC-205 Problem when searching issues with 'fields' parameter set final SearchResult searchResult = searchRestClient.searchJql(jqlQuery, 1, 0, null).claim(); DateTime firstIssueCreationDate = null; if (searchResult.getIssues().iterator().hasNext()) { final Issue firstIssue = searchResult.getIssues().iterator().next(); firstIssueCreationDate = firstIssue.getCreationDate(); } int monthDiff = 0; if (firstIssueCreationDate != null) { final DateTime today = new DateTime(); final Months mt = Months.monthsBetween(firstIssueCreationDate, today); monthDiff = mt.getMonths(); } final float issuesPerMonth = (float) searchResult.getTotal() / monthDiff; final SimpleDateFormat formatter = new SimpleDateFormat("MM/dd/yyyy"); String firstIssueCreationDateString = null; if (firstIssueCreationDate != null) { firstIssueCreationDateString = formatter.format(firstIssueCreationDate.toDate()); } else { firstIssueCreationDateString = "None"; } System.out.println(String.format("%s %s %s %s", String.join(" ", queryParameters), searchResult.getTotal(), firstIssueCreationDateString, issuesPerMonth)); }