From: David T. <tom...@ho...> - 2009-01-05 06:35:38
|
Hi, happy new year everyone I have finished debugung the allowances calculations for absence management (holiday, glidetime). There are two reports, and I think they are now consistent with each other. I have checked this into the SVN trunk, and also updated the old /tag/timesheet.ng-1.3.1 branch and renamed it to /branches/timesheet.ng-1.3.x. We can make the /tag version when we are happy with the v1.3.1. I did check-out the /branches/exp_installer version but it didn't work for me for a clean install. Not sure if it is just a mySQL problem yet... Cheers From: tom...@ho...To: tsh...@li...Subject: Absence managementDate: Thu, 18 Dec 2008 09:41:29 +0100 Hi to anyone listening.. I checked everything in that I have been working on last night. Different types of absences/leave can be entered on the absences pages. This is only monthly and to half-day granularity, that's how we have been using it. Public holidays can be entered, and appear on the calendar, but there is no user interface yet to manage these. There is an example SQL script to add public holidays. The new table timesheet_absences holds this info, with the impicit rule that an entry with a null user id applies to all users. The holiday calculation is working according to the new timesheet_allowances table. Again there is no user interface yet to manage this table. I tried to put the rule in that every user gets an initial allowance entry (of zero). Normally holiday allowance is added yearly, and this works. I use the earliest entry in this table as the user's "start date" i.e. when he joined the company/system. Glide-time is held in a similar way but is much more complicated to calculate. You need to calculate the worked-time (from the times entered), the required working-time (attendance) - you need to exclude public holidays and other things, and in our system you could compensate the time, or have it paid out. Compensation is an absence to record, and paying out hours should be represented by a negative entry in the glide-time allowance table. The glide-time calculation is messy and not well implemented, and on the monthly report the calculation is wrong. And it needs to be more flexible/configurable. But the basics are there. At least no one has to use this who doesn't want too, because it can be switched off (set ACL to none) on the config page. Cheers Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! Try it! _________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/ |