Page 1 of 1

Staff Planner

Posted: Thu Aug 05, 2010 5:27 pm
by snail85
Hello there.

I am planning to design a staff planner to keep track of staff. The system we have at the moment is based on an excel spreadsheet. On the vertical is the staff names , the horizontal is the date. Currently an 'X' is placed in a cell to denote a member of staff was present on that day (please see diagram below). I would like to replicate this using PHP and MYSQL.
planner.gif
planner.gif (2.71 KiB) Viewed 109 times

Basically it would have to be a table that is fully editable on the web. Please note I'm planning to add many more features to this after I've got the basic design sorted.

I'm really looking for any suggestions as to the best way to go about this.

Thanks,

Craig

Re: Staff Planner

Posted: Fri Aug 06, 2010 6:58 am
by internet-solution
I would suggest check boxes in each cell instead of reuiring user to put an X.

Re: Staff Planner

Posted: Fri Aug 06, 2010 7:20 am
by snail85
Hi thanks for the reply.

I was intitially thinking of doing something like that but we will be using different letters to denote differents things which is why the user has to be able to enter text. For example an employee who is offshore would be denoted by an 'O' , one who is on holiday a 'H' etc.

Has anyone got any suggestions of how to get round this ?

Thanks,

Craig

Re: Staff Planner

Posted: Fri Aug 06, 2010 8:20 am
by manojsemwal1
you can use selection button and put the mark inside that like O,H,P,A by default it should be P if user get leave or absent admin can select the status and locked it .its depends on day like if day has changed the the last day value will be printed in the front of emp.selection value will be activate only presend day.

i think this concept will be help to you.

manoj