Need Help with staff managment calender ???

[scarface83]

Hi All,

 

this is my first ever post , im pretty new to php and need some help.

 

 

im in the process of setting up a site, to save me some time at work, im using php 5 and mysql 5.

 

at the moment to track my staff absence, lateness etc i use a calender in excel and format the cell colour with the relevent colour in the legend

eg red= late

blue = holiday

 

 

what i want to do is have a calender from april to april which you select the staff memeber from a drop down and they have there own calender when you click on the date for example the 1st of march you get some options echoed on the page for example , late , sick , holiday and when you click on an option say for example late it changes the cell back ground to the corresponding colour in the legend , which i this case would be red , also if i switch back to the staff member it would display the lateness or sickness etc logged aginst them in databse on the calender

 

 

any help with this would be great

 

thanks

 

 

[gazever]

Hi,

 

I should be able to help you with this one, I have created something similar (however using flat file database as mysql isnt avaliable on my clients server) It is an avaliabilty calendar for his two vacation homes in florida, it basically loads each text file, per month then styles it into a calendar using css classes for, low, mid, high, booked, but these can be customised for your exact usages. I have the calendar set up so it displays for the next twelve months from the current month, if the file for the 12month doesnt exist, it generates it, using default values, i.e. low, mid, high, (late, sick, holiday in your case etc). I then have an admin section that will change to whatever state you want on each day, you will need to customise it to your exact requirement. But this works on a drop down list of the states, filling in the present values by looping through the file.

 

I am a new to php so the code isn't as optimised as it could be, but it works, perhaps you could help me with the optimisation.

 

I still have some work to do on this but will post you the code shortly, perhaps you could send me a PM to remind me.

 

Gaz

[scarface83]

thats great thanks, a few people have suggested i look into an event calender but i want to keep it as simple as possible