Staff Planner

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
snail85
Forum Newbie
Posts: 2
Joined: Thu Aug 05, 2010 5:10 pm

Staff Planner

Post 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 107 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
internet-solution
Forum Contributor
Posts: 220
Joined: Thu May 27, 2010 6:27 am
Location: UK

Re: Staff Planner

Post by internet-solution »

I would suggest check boxes in each cell instead of reuiring user to put an X.
snail85
Forum Newbie
Posts: 2
Joined: Thu Aug 05, 2010 5:10 pm

Re: Staff Planner

Post 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
manojsemwal1
Forum Contributor
Posts: 217
Joined: Mon Jun 29, 2009 4:13 am
Location: India

Re: Staff Planner

Post 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
Post Reply