import java.time.ZonedDateTime;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.concurrent.TimeUnit;
// Status to be counted
def statusName = "In Progress";
def statusNameCheck = "[${statusName}]";
// Jira date timestamp field format
def timePattern = "yyyy-MM-dd'T'HH:mm:ss.SSSZ";
// Get current time in milliseconds
long currentTime = System.currentTimeMillis();
// Get issue data through API
def issuedata = get("/rest/api/3/issue/${issue.key}?expand=changelog")
.asObject(Map).body;
// Filter changelogs into list
def statusChanges = issuedata.changelog.histories.findAll { it.items.field.contains("status") };
// Get issue created date and format
def issueCreatedDate = new SimpleDateFormat(timePattern).parse(issuedata.fields.created);
// Create a list of long numbers and add 0 as the first item
List<Long> totalStatusTime = [0];
// Calculate time difference between current time and issue created time
def createdDateDiff = System.currentTimeMillis() - issueCreatedDate.getTime();
// Add time difference to totalStatusTime list for the first status in workflow
if (statusName == "New") {
totalStatusTime << createdDateDiff;
}
// Convert statusChanges to a list of strings
def changeItems = statusChanges as List<String>;
// Reverse the list and check each status change
changeItems.reverse().each { item ->
// Get time when the change was made
def createdDate = new SimpleDateFormat(timePattern).parse(item.created).getTime();
long timeDiff = currentTime - createdDate;
logger.info("Time Difference is ${timeDiff}");
// Extract 'from' status
def fromString = "${item.items.fromString}";
// Extract 'to' status
def toString = "${item.items.toString}";
// Subtract time if the 'from' status matches the status to be checked and statuses are different
if (fromString == statusNameCheck && fromString != toString) {
totalStatusTime << -timeDiff;
}
// Add time if the 'to' status matches the status to be checked
if (toString == statusNameCheck) {
totalStatusTime << timeDiff;
}
}
// Sum up the total time and convert it into days, hours, minutes, and seconds
def total = totalStatusTime.sum() as Long;
long DD = TimeUnit.MILLISECONDS.toDays(total);
long HH = TimeUnit.MILLISECONDS.toHours(total) % 24;
long MM = TimeUnit.MILLISECONDS.toMinutes(total) % 60;
long SS = TimeUnit.MILLISECONDS.toSeconds(total) % 60;
// Create a readable string for the duration
String prettyDuration = String.format("%02dd %02dh %02dm %02ds", DD, HH, MM, SS);
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.