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; } } }

How to restrict logging work log for previous month

Sadaf Jabin

Hi,

Can we restrict the user from logging work for previous month. As per the scenario, I am trying to disable the time spent field in the Log Work Screen, if the Date Started is having a value of previous month. I tried behavior but in vain. Here is my script that I am trying to write using a listener:

import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.issue.CustomFieldManager;
import com.atlassian.jira.issue.Issue;
import com.atlassian.jira.issue.fields.CustomField;
import com.onresolve.jira.groovy.user.FormField
import com.atlassian.jira.issue.worklog.*
import com.atlassian.jira.issue.MutableIssue

CustomField timespentField = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName("Time Spent")
CustomField startDateField = ComponentAccessor.getCustomFieldManager().getCustomFieldObjectByName("Date Started")
def today=new Date().format("yyyy-MM-dd")
//def issue = event.issue as Issue
MutableIssue issue = event.issue as MutableIssue
//def startDateVal = issue.getCustomFieldValue(startDateField) as Date
log.error(issue.getCustomFieldValue(startDateField))
def customFieldManager = ComponentAccessor.getCustomFieldManager()
def change = event?.getChangeLog()?.getRelated("ChildChangeItem").find {it.field == "Date Started"}
log.error("change is "+ change)
if(change){
    def startDateVal = issue.getCustomFieldValue(startDateField) as Date
    log.error("start date is "+ startDateVal)
   def month=startDateVal.format("MM")
    def year=startDateVal.format("yyyy")
    Calendar cacheCalendar = Calendar.instance
    cacheCalendar.set(Calendar.MONTH, (Integer.parseInt(month)+1));
    cacheCalendar.set(Calendar.YEAR, Integer.parseInt(year));
    def cutoffDate=cacheCalendar.time.format("yyyy-MM-05")
    def monthStart=startDateVal.format("yyyy-MM-01")
    log.error("Month Start:"+monthStart+"....cutOffDate:"+cutoffDate)
    if(monthStart<=today && today<cutoffDate){
              timespentField.hide();
        issue.timespentField.setVisible(false)
    }
    else {
       getFieldById("log-work-time-logged").setHidden(false)
       timespentField.setRequired(false)
    }
}

Any help will be highly appreciated.

Accepted answers

Sadaf Jabin

Hi,

I was able to resolve the problem with script listener.

Logic: Whenever work is logged with a date older than 30 days, we update the worklog date to current date.

Script Listener Events: Issue Worklog Updated, Work Logged on Issue

Script:

import com.atlassian.jira.issue.CustomFieldManager;
import com.atlassian.jira.issue.fields.CustomField;
import com.atlassian.jira.ComponentManager
import com.atlassian.jira.issue.IssueManager;
import com.atlassian.jira.issue.Issue;
import com.atlassian.jira.issue.MutableIssue;
import com.atlassian.jira.issue.customfields.manager.OptionsManager
import com.onresolve.scriptrunner.runner.ScriptRunnerImpl
import com.onresolve.scriptrunner.runner.customisers.PluginModule
import com.onresolve.scriptrunner.runner.customisers.WithPlugin
import java.lang.Object
import com.atlassian.jira.issue.worklog.WorklogImpl2
import java.text.SimpleDateFormat
import com.atlassian.crowd.embedded.api.User
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.worklog.DefaultWorklogManager
import com.atlassian.jira.security.roles.ProjectRoleManager
import com.atlassian.jira.issue.worklog.Worklog
import com.atlassian.jira.datetime.LocalDate
import com.atlassian.jira.issue.worklog.*

def issue = event.issue as Issue
WorklogManager worklogManager = ComponentAccessor.getWorklogManager()
List worklogs = worklogManager.getByIssue(issue)
def last_worklog=worklogs.last()
def author = last_worklog.getAuthorKey()
def dateformat= new SimpleDateFormat("yyyy/MM/dd");
Date date = new Date();
def componentManager = ComponentManager.getInstance()
ProjectRoleManager projectRoleManager = ComponentManager.getComponentInstanceOfType(ProjectRoleManager.class) as ProjectRoleManager
def UsersRole = projectRoleManager.getProjectRole("Users")
long timespent = 1
def last_logged=last_worklog.getTimeSpent()
Calendar cal = Calendar.getInstance();
cal.add(Calendar.DATE, -30);
Date todate1 = cal.getTime();
def date_limit = dateformat.format(todate1);
def last_worklog_date=dateformat.format(last_worklog.getStartDate())
log.error(dateformat.parse(last_worklog_date).before(dateformat.parse(date_limit)))
if(last_worklog.getTimeSpent()>1 && dateformat.parse(last_worklog_date).before(dateformat.parse(date_limit))){
String comment=last_logged+'sec logged by '+author+' on date '+last_worklog_date
def worklog = new WorklogImpl2(issue, last_worklog.getId(), author, comment, new Date(), null, null,last_logged, UsersRole)
worklogManager.update(issue.reporter, worklog, 0L, true)
}

Thanks,

Sadaf Jabin

All comments

MoroSystems Support

Hi Sadaf,

did you considered to use some plugin? I think the Tempo Timesheets plugin should be able to disable logging of work for previous month.

Best regards,

Ondřej

Sadaf Jabin

Hi Ondřej,

Thanks for your response.

I am actually looking for a solution without having to involve additional plugins. It would be great if you could suggest in that line.

Thanks,

Sadaf Jabin

Hi,

I was able to resolve the problem with script listener.

Logic: Whenever work is logged with a date older than 30 days, we update the worklog date to current date.

Script Listener Events: Issue Worklog Updated, Work Logged on Issue

Script:

Thanks,

Sadaf Jabin

Prasanth Duggirala_9wbvyd

Hi How can restrict by Future Date to team log the work?

Sadaf Jabin

HI Prasanth,

Could you please elaborate the problem statement.

Thanks,
Sadaf Jabin

Prasanth Duggirala_9wbvyd

My team members are logging work hours for Future date how can we restrict this.

mvinod

Hi Sadaf Jabin,

Did you get any solution from the users or still waiting for the inputs, actually i too want to implement the same and i would like to know how and where we need to implement the logic to validate the work log "Date Started " field in the work log screen

Sadaf Jabin

@mvinodPlease refer to the first answer. I was able to acheive the restriction using the shared script.

mvinod

Thanks for your reply , Sadaf Jabin!

To implement the code , i have navigated to the "Create Listeners" screen under Script Runner. (Listeners -> Create -> Create Listeners).

Now, i am not aware where do we need to place the code and how to debug the code to validate the Date Started value from the Log Work screen.

mvinod

Hi @ Sadaf Jabin / @Swarna_Radha ,

I have created a new Custom listener and placed the script code which was shared by Sadaf_Jabin on Nov 07, 2019.

PFA screen shoots for the reference.

Now, am not hot to cross check whether the script is running or not (or) do we need to do any other option to make it work. Since in the screen shots it says it was not yet executed in the Execution history column.

Also kindly let me know, where do we need to view the error log details after the execution of the code.

mvinod

Thanks for the update Sadaf.

I tried the same and it is allowing me to log hours for the April Month, at the same time the code also got executed successfully. PFA screen shot for reference.

Could you please let me know, where do we can see the logs now, Since the code was executed successfully right.

Sadaf Jabin

@mvinod Can you please share the screenshot of the worklog tab of the issue where you logged the effort. Th work will be logged successfully but the worklog date will appear as the current date.

mvinod

@Sadaf Jabin It seems like the date was get updated in the work log tab with the user selected date.

PFB screen shots

Listener Log Screen

mvinod

@Sadaf Jabin Could you please let us know , how to debug this code or where to see the logger value which was get executed by this Custom Listener

unknown

Tempo doesn't solve this issue

vangapalli jangaiah

Any one help me to disable to edit work log entry

Welcome!

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

Quick Links

Find more posts tagged with

scriptrunner

jira

listener

script-listener