Project

General

Profile

Work Time Plug in - need to track vacation and sick days

Added by Sergio Mastronardi over 11 years ago

Hi team,

We added 2 new data fields to USERS table
  • AuthorizedVacationHours INT 11
  • AuthorizedSickHours INT 11

With these fields, we know are maintaining them manually via a DB tool edit. What are my options to maintain them within REDMINE UI?

Also, we have a query we created, that allows us to monitor all vacation days and Sick days taken by resources. How can we add this query into the REDMINE view, so our accounting group can easily click this option.

Here is the query for those that may be interested:

select lastname, firstname,auth_vacation,auth_sick_h,sum(case when issue_id = 'redmine_issue_vacation_id' then (hours) else 0 end )as vacation_hours,sum( case when issue_id = 'redmine_issue_vacation_id' then (hours) else 0 end) as sick_hours,auth_vacation - sum(case when issue_id = 'redmine_issue_sick_id' then (hours) else 0 end )as vacation_to_take, auth_sick_h - sum( case when issue_id = 'redmine_issue_vacation_id' then (hours) else 0 end) as sick_hours_to_take
from

(SELECT
time_entries.spent_on,
time_entries.issue_id,
hours,
users.lastname,
users.firstname,
users.auth_vacation,
users.auth_sick_h,
issues.subject
FROM
`bitnami_redmine`.`time_entries`,
`bitnami_redmine`.`users` ,
`bitnami_redmine`.`issues`
WHERE
time_entries.USER_ID = users.ID
AND
time_entries.issue_id = issues.id
AND
time_entries.issue_id in ( 'redmine_issue_vacation_id' , 'redmine_issue_sick_id' )
AND
time_entries.spent_on >= '2012-01-01' and time_entries.spent_on <= '2013-03-25')
a group by
lastname

If a plugin, already exists that does all this, then even better. Please let me know what options I have!

Thanks!
Sergio


    (1-3/3)