Company has employees in a department.
They work in shifts. Morning, Evening, Night and General.
Every person has 5 days working. 2 days week-off.
Apart also provides 2 days leave per month which can be accumulated and take a vacation in anytime of the year.
So what I need is a small CMS which can manage all this.
A roster which will show which person is in which shift.
See excel file for roster.
Like this for whole month. In above chart it shows person’s shift. H is for Holiday.
It also shows which shift has how much strength and total strength for the day.
Now any shift person can swap his shift with other person’s shift. This does not count as leave, as the other person will return the leave on his week-off.
So what is required is to
Ad a department
Add their shifts
Swap form (If a person is swapping, it should automatically update the roster as well)
Swap forms are filled and approved by respective manager/Leader.
Once a swap is approved, it should update the roster.
A person has now accumulated say 12 leaves and he wants to go for a vacation for 5 days. He can fill up leave application form which is again approved by manager/leader. If approved, it should update the roster.
So basically, any change, roaster should get updated automatically.
Reports can be generated for no. of people present in a month. No. of people have swaps, leaves etc..!!
All this should work on a local host (windows xp using XAMPP)
Lowest quote gets the deal.