Time Tracking Overlap

[Claus]

Hi,

we want to use Tempo for Time Tracking which will be used for each employee as a covenant time table for our payroll accounting.

We are bond to keep tracks of time like

08:00-10:30 Installed tempo Plugin

10:30-12:00 Tested Configuration.

At least it should state something like

08:00-12:00 worked

13:00-18:00 worked

But it is possible for me to enter something like this:

08:00 worked 8h

13:00 worked 5h

So I have a overlap 08:00-16:00 and 13:00-18:00 which will not be forbidden...

What can I do? At least I (employee) want to be able to check this inside Jira bevore I get this timetable to be approved...

[Sverrir Tynes [Tempo] · Accepted solution]

Hi Claus

A similar request is in our tracker https://studio.plugins.atlassian.com/browse/JTMPO-511

I ve commented a link to this post in the issue so please feel free to vote/comment on the issue.

Sverrir Tynes
Tempo support

[Claus]

Maybe a helpfull SQL for MySQL-DB

select
  w.AUTHOR, i.pkey, w.STARTDATE, ADDDATE(w.STARTDATE, INTERVAL w.timeworked/60 MINUTE) as ENDDATE , w.timeworked/60 as WORKED_IN_MIN, w.worklogbody
, case
    when w.startdate = ww.startdate and w.timeworked= ww.timeworked and w.worklogbody = ww.worklogbody
      then 'duplicate entry'
    when w.startdate = ww.startdate and w.timeworked= ww.timeworked 
      then 'duplicate time entry'
    when ww.startdate = w.startdate
      then 'duplicate STARTDATE'
    when ww.startdate > w.startdate and ww.startdate < w.startdate
      then 'second time completely included'
   else 'overlap'
   end as INFO
          , ii.pkey, ww.STARTDATE, ADDDATE(ww.STARTDATE, INTERVAL ww.timeworked/60 MINUTE) as ENDDATE , ww.timeworked/60 as WORKED_IN_MIN, ww.worklogbody
from worklog w
inner join jiraissue i on i.id = w.issueid
inner join worklog ww on w.id <> ww.id
                     and w.AUTHOR = ww.AUTHOR
                     and ww.STARTDATE >= w.STARTDATE and ww.STARTDATE < ADDDATE(w.STARTDATE, INTERVAL w.timeworked/60 MINUTE)
inner join jiraissue ii on ii.id = ww.issueid
order by w.AUTHOR, w.STARTDATE, i.pkey, ww.STARTDATE