PLEASE FULLY UNDERSTAND THE PROJECT BEFORE BIDDING.
I am looking for a web based program that will help me manage and schedule our camera crew for our church. The program is not critical, but would be nice to have. It would probably suit a new coder to RentaCoder or a student looking for a project to do.
The system can be written in PHP, AJAX or anything else that will run on a Linux platform. The database would be MySQL.
## Deliverables
I am looking for a web based program that will help me manage and schedule our camera crew for our church. The program is not critical, but would be nice to have. It would probably suit a new coder to RentaCoder or a student looking for a project to do.
The system can be written in PHP, AJAX or anything else that will run on a Linux platform. The database would be MySQL.
**Current Scenario**
We currently have 4 Camera positions, Camera 1, Camera 2, Camera 3 & Camera 4, however we currently only use 2, Camera 2 and Camera 3. We use 2 cameramen per camera i.e. 2 shifts. We also have a Floor Director per service and a Director (Always a director).
Our Sunday service always has a Director, Floor Director & currently 4 cameramen (based on 2 cameras with 2 shifts)
Our Wednesday service always has a Director and at least 2 Cameramen (based on the fact that we normally only use 1 camera (camera 2) on a Wednesday. However we sometimes have trainees on a Wednesday night and we normally put them on Camera 3.
We have 3 times a year where we have meetings twice a day for a whole week. Morning meetings (1 camera) & Evening meetings (2 cameras).
Our cameramen are all volunteers and we often need to work around their schedule. Some cameramen are only prepared to work 1 Sunday a month, others can only operate camera 2 and not camera 3.
Currently our pool of resources consists of 4 Directors, 3 Floor Directors & 13 Cameramen and 5 Trainees. This of course can increase and some directors can be floor directors and cameramen, some floor directors can be cameramen. We could also have trainee Floor Directors and Trainee Directors.
**Ideal Solution**
Ideally the system would automatically create a schedule once a month based on the criteria for the meetings (i.e. this is a 1 camera service or a 2 camera service).
The system will evenly spread the workload based on the criteria i.e. Peter can’t be on camera every service just because he is available.
Each Resource would be able to administer their own calendar, so the system would know if they are available or not on a given service (remember there are times when there can be two services per day and they might not be available in the morning but could be available in the afternoon.
The system would email the schedule or link to the resources.
Once a schedule has been published a resource could request the system to do a shift swop with another resource. The system would generate an email to the new resource to accept or decline the swop.
The system could generate schedules months in advance and would automatically refresh the schedule with the latest information as it becomes available. Once a schedule is published i.e. 2 weeks before the beginning of that month the schedule is then fixed and only changes via swop requests could be executed.
Please ask questions to fully understand what is required.