nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

calculating time scripted field in minutes

arige hamdan

Hi,

This script can calculate in minutes, how much time did it take to close an event.

I need to add to this script "skipweekend = Friday and saturday" and skip hours that are not work hours [ work hours = 8 – 17]

Can you please help me with this request?

Thanks a lot.

Best regards

Arige

import com.atlassian.jira.component.ComponentAccessor

import com.atlassian.core.util.DateUtils

import org.apache.log4j.Logger

import org.apache.log4j.Level

import java.text.SimpleDateFormat

import java.util.Date

import java.util.concurrent.TimeUnit

import java.lang.Object

//try

//{

//java.sql.Timestamp start

//java.sql.Timestamp end

def log = Logger.getLogger("com.ayalon.test2")

log.setLevel(Level.ERROR)

def start = issue.getCustomFieldValue(ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName("האירוע החל ב"))

log.debug "Comment Author: " + start;

def end = issue.getCustomFieldValue(ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName("אירוע הסתיים ב"))

log.debug "Comment Author: " + end;

if (start == null) return -1

if (end == null) return -1

SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

Date startDate = formatter.parse(start.toString());

Date endDate = formatter.parse(end.toString());

log.debug "string of startDate" + startDate;

log.debug "string of endDate" + endDate;

long timepassed = (endDate.getTime() - startDate.getTime());

log.debug "Comment Author: " + timepassed;

long minutes = TimeUnit.MILLISECONDS.toMinutes(timepassed);

log.debug minutes

//def diff = (endDate.getTime() - startDate.getTime())/1000/60

//return startDate.getTime().doubleValue()

return minutes

//}catch(e){return 0}

Accepted answers

Joanna Choules

Hi Arige,

I've posted a snippet here with a script that should do this: https://bitbucket.org/snippets/Adaptavist/6egg5E. It is quite a substantial script but hopefully it's relatively clear what it's doing. All you need to add to it is your own code for fetching the two date values in the first place: put that code in the place where the "//code code code" comment is in the script.

Regards,

All comments

Joanna Choules

Hi Arige,

Regards,

arige hamdan

thanks for your help.

i tru it but nothing happened and it calculate nothing

here the script i added

is there something wrong that i am doing?

import groovy.transform.Field
import java.time.*;
import static java.time.DayOfWeek.*;
import static java.time.temporal.ChronoUnit.*;
import static java.time.LocalTime.MIDNIGHT
import static java.time.temporal.TemporalAdjusters.previousOrSame
import static java.time.temporal.TemporalAdjusters.next

@Field def WEEKEND_DAYS = [FRIDAY, SATURDAY]
@Field int WORK_DAY_START_HOUR = 8
@Field int WORK_DAY_END_HOUR = 17

@Field LocalTime WORK_DAY_START = LocalTime.of(WORK_DAY_START_HOUR, 0)
@Field LocalTime WORK_DAY_END = LocalTime.of(WORK_DAY_END_HOUR, 0)
@Field long WORK_DAY_SECONDS = SECONDS.between(WORK_DAY_START, WORK_DAY_END)

Date startDate
Date endDate

// Set values of startDate and endDate here...
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.core.util.DateUtils

import org.apache.log4j.Logger
import org.apache.log4j.Level
import java.text.SimpleDateFormat
import java.util.Date
import java.util.concurrent.TimeUnit
import java.lang.Object
//try
//{
//java.sql.Timestamp start
//java.sql.Timestamp end
def log = Logger.getLogger("com.ayalon.test2")
log.setLevel(Level.DEBUG)

def start = issue.getCustomFieldValue(ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName("האירוע החל ב"))
log.debug "Comment Author: " + start;
def end = issue.getCustomFieldValue(ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName("אירוע הסתיים ב"))
log.debug "Comment Author: " + end;
if (start == null) return -1
if (end == null) return -1

SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date startDate = formatter.parse(start.toString());

Date endDate = formatter.parse(end.toString());

log.debug "string of startDate" + startDate;
log.debug "string of endDate" + endDate;
long timepassed = (endDate.getTime() - startDate.getTime());

log.debug "Comment Author: " + timepassed;
long minutes = TimeUnit.MILLISECONDS.toMinutes(timepassed);

log.debug minutes
//def diff = (endDate.getTime() - startDate.getTime())/1000/60

//return startDate.getTime().doubleValue()
return minutes
//}catch(e){return 0}

def start = LocalDateTime.ofInstant(startDate.toInstant(), ZoneId.systemDefault())
def end = LocalDateTime.ofInstant(endDate.toInstant(), ZoneId.systemDefault())

/* We normalise the time range to (almost) a whole number of weeks, going from the
immediately preceding Sunday midnight to the immediately following Friday midnight,
while keeping track of how much extra time we add by doing so. The total time can
then be calculated as a simple multiple of the number of weeks, minus the additional
time introduced by normalisation. */

def startCorrectionSeconds
def sundayMidnightBeforeStart = start.with(previousOrSame(SUNDAY)).with(MIDNIGHT)
if (start.dayOfWeek in WEEKEND_DAYS) {
/* If it's the weekend then we're always adding five full working days' worth
of seconds. */
startCorrectionSeconds = 5 * WORK_DAY_SECONDS
} else {
/* Otherwise we calculate the number of full working days preceding, convert
to seconds, and add the number of extra seconds in the current, incomplete day. */
def secondsSinceWorkDayStart = clampSeconds(SECONDS.between(WORK_DAY_START, start.toLocalTime()))
def daysSinceSunday = DAYS.between(sundayMidnightBeforeStart, start)
startCorrectionSeconds = daysSinceSunday * WORK_DAY_SECONDS + secondsSinceWorkDayStart
}

def endCorrectionSeconds
def fridayMidnightAfterEnd = end.with(next(FRIDAY)).with(MIDNIGHT)
//Have to special-case Sunday midnight to avoid double counting
if (end.dayOfWeek in WEEKEND_DAYS || end.dayOfWeek == SUNDAY && end.toLocalTime() == MIDNIGHT) {
/* If it's the weekend then we're always adding five full working days' worth
of seconds. */
endCorrectionSeconds = 5 * WORK_DAY_SECONDS
} else {
/* Otherwise we calculate the number of full working days following, convert
to seconds, and add the number of extra seconds in the current, incomplete day. */
def secondsUntilWorkDayEnd = clampSeconds(SECONDS.between(end.toLocalTime(), WORK_DAY_END))
def daysUntilFriday = DAYS.between(end, fridayMidnightAfterEnd)
endCorrectionSeconds = secondsUntilWorkDayEnd + daysUntilFriday * WORK_DAY_SECONDS
}

def daysBetween = DAYS.between(sundayMidnightBeforeStart, fridayMidnightAfterEnd)

/* We're measuring from Sunday midnight to Friday midnight, so we always expect
to get a positive number of days which is two fewer than a whole number of weeks. */
assert daysBetween > 0 && (daysBetween + 2) % 7 == 0

/* Add 2 to get a multiple of 7, divide by 7 to get number of weeks, multiply by 5
to get number of work days. */
def workDaysBetween = ((daysBetween + 2) / 7) * 5
log.info([workDaysBetween, startCorrectionSeconds, endCorrectionSeconds])
def secondsBetween = workDaysBetween * WORK_DAY_SECONDS - (startCorrectionSeconds + endCorrectionSeconds)

return Math.round(secondsBetween / 60.0 as Double)

//***************************************************

/* If a time falls before the start, or after the end, of a work day, then the
difference between that time and the start/end of the day might be negative, or
larger than the length of a work day.
In either case we only want to count the seconds that are part of the work day,
so we use this function to restrict the value into that range. */
long clampSeconds(long seconds) {
Math.max(0, Math.min(WORK_DAY_SECONDS, seconds))
}

Joanna Choules

Hi Arige,

You don't need to paste the entirety of your previous script into the middle of the new one: you just need the part where you fetch the values of the two date fields. Pasting in the return statement is a particularly bad idea as that will just abort the script halfway through without doing any of the actual calculation.

Regards,

arige hamdan

Capture script error 30.8.JPG HI'

thank for the response

After trying to paste just the part where i fetch the values of the two date fields, i get 2 errorrs see screenshots attached.

can you tell me please what i am still doing wrong

thank

Joanna Choules

Hi Arige,

It looks like the problem here is that the values you retrieve from the issue are getting stored in the "start" and "end" variables, whereas they should be stored in the "startDate" and "endDate" variables, as pointed out in the preceding code comment. You should be able to resolve this by changing these lines:

def start = issue.getCustomFieldValue(...)
def end = issue.getCustomFieldValue(...)
if (start == null) ...
if (end == null) ...

to these:

startDate = issue.getCustomFieldValue(...)
def end = issue.getCustomFieldValue(...)
if (startDate == null) ...
if (endDate == null) ...

Regards,

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server