Change due dates of template - scriptrunner?

Reto Eggenberger

Hi all

I have a template with tasks. Kind of a timetable. 

On the template only the difference between the dates matter. Task 2 is ten days later den Task 1 ...

Now I want a possibility to change all the due dates. Say I want to start the timetable on 01.11.2016. The result should be:

• 01.11.2016 ...
• 10.11.2016 ...
• 14.11.2016 ...

The same difference between 01.11.2016 and 01.01.2000 gets applied to all the due dates. Or according to the offset in brackets.

• Ideal would be, if the date gets asked on creation of the page.
• Or a button to change the date.
• Or an event listener which changes all the due dates automatically.

I think with the Scriptrunner Add-On this should be possible, but I don't know where to start ...

Thanks for any hints on this.

Reto

due_dates_101116_083724_AM.jpg

Reto Eggenberger

I found a way to change the values according to a offset in brackets with scriptrunner. Works perfect. 

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.regex.Pattern;
import java.util.regex.Matcher;
import java.util.Calendar;
Date date = new SimpleDateFormat("dd.MM.yyyy").parse("${parameters.releasedate}");
SimpleDateFormat isord = new SimpleDateFormat("yyyy-MM-dd");
SimpleDateFormat rd = new SimpleDateFormat("dd.MM.yyyy");
Calendar cal = Calendar.getInstance();
String[] lines = body.split("\\</li\\>", -1);
body = "";
for (int i = 0; i < lines.length; i++) {
    Pattern p = Pattern.compile("\\[(.*?)\\]");
    Matcher m = p.matcher(lines[i]);
    while(m.find()) {
        cal = Calendar.getInstance();
        cal.setTime(date);
        cal.add(Calendar.DATE, Integer.parseInt(m.group(1)));
        lines[i] = lines[i].replaceAll("01.01.2000",rd.format(cal.getTime())).replaceAll("2000-01-01",isord.format(cal.getTime()));
    }
    body = body + lines[i];
}
body;

But I made a huge mistake...

The change is only to the visual layer. The dates are stored as they are without the offset. Doesn't work with reminders and so on ...