Two simple PHP programs needed to be coded for web use.
There are two files and here are the explanation of both files:
Logsheet on the [url removed, login to view]
They log into the website... atvco.
Admin log in will be able to "add/remove a project" and "add/remove users"
Users log in will be able to click on any of the projects they work on to further go into another page.
Type in USERname/Password set by Admin again.
(If you look at the Log Sheet Page in the tabs in the excel sheet file, pretty much all of the catagory links listed in each will have the exact same system.)
So for example -> log in -> Soul Patrol -> Log in -> Editing -> Logsheet..
From there, they have a field where they type in their name, (date and time) will be automatically stored using windows/Os time, they can fill in the catagory, contact name, regarding, etc etc.
The filled chart, will be displayed at the top, while the filling in can be at the very bottom of the page. Admin has the right to remove any entry, etc to keep up the page.
Also this page has to be able to be sorted by any catagory.
That is it, for all the log sheets. As for the "tasks" tab, forget all the task listed in other projects. Just want one central task right at the main page where all users can submit an entry. Same thing, time is recorded by computer time when posted. And it can be sorted by the catagories.
Next: rebelyt [url removed, login to view]
Username password again (admin can add/change/remove users catagories, etc)
Team Contacts is just a regular page that can easy be uploaded and changed.
Schedule -> allow userrs to post their work availability.
Meetings Summary -> thats just a page where the admin can upload *.doc files to be downloaded. Just give thema box to upload the file, and sort it by date
Now, further in.. lets look at the Myspace project:
Username/password again. Setted by admin from the main section.
Templates -> same thing as Meetings Summary, addable .doc and make it downloadble
Training and Band Info -> same thing, .doc download and uploadable sort by date.
Radio Station Log -> a list, admin or user can ENTER new or CHANGE existing. Sorted by the catagories.
Time Sheet -> This is for the employee to sign in and out. So the date and time is automatically record thru the computer time or some central time. So in the morning, they sign in thru this and the time is recorded through some MySQL database, and than sign out at the end of the day. It will automatically calculate their WEEKLY hours worked. Make like two buttons, Sign in and Sign out. Their names will be automatically entered too since its the username.
It is IMPORTANT that each user (cause there are many employees) are unique to each other, so they cant see each other.
So the hours are tallied up for the week, and viewable by ADMIN ... admin can select the user, select the week *date*, and see the number of hours people have worked.
Log sheet and Tasks -> same thing as mentioned in the first .xls file.
20 freelancers are bidding on average $265 for this job
We have over 6 years experience in designing and creating websites in full accordance with our clients requests. All work will be carried out expediently and to your full satisfaction.
I would be pleased to work with you on this. I read through the description you gave as well as the attached files. Please let me know if you have any questions for me.