PHP, MySQL, JavaScript, XHTML + CSS required as minimum

IT Booking System
My business has around 30 IT rooms located around the work buildings and requires a booking system in order to effectively delegate rooms to workers and colleagues throughout the day. The system must be web based in order to allow access to it from all workstations via the companies intranet facilities.

Specifications

• System must be web based, MySQL back-end database and preferably PHP
• Front-end web interface must be XHTML/CSS compliant
• Interface to dynamically find available rooms based on specific criteria e.g. no. of computers need, date/time of booking etc.
• Filtering process above must be dynamic through the use of JavaScript and AJAX requiring no page reloads
• Database of rooms with number of computers, location etc.
• Must integrate with existing MySQL database of business events and holidays to prevent bookings on certain days / weeks
• Rooms must be bookable 2 weeks in advance for a period of 1 hour per booking
• Timetable of rooms to be printable on request from/to any given dates
• Various reports on frequency of room bookings by particular staff and departments
• Automatic email notification to staff for reminders about bookings

Fault Logging System
Along with the booking system I require a fault logging system. Also web based, it will need to be accessible across the business intranet to log problems with computers. Users should be able to report location, the problem they are having, description of the fault and date and time it occurred. Once entered into the system the fault must be assigned to a specific technician based on his workload, work times, specialities etc.. which will be held in a database. Users should be able to track the fault's process via a front-end web page.

Specifications

• System must be web based as described above
• Front-end to allow user to enter details about the fault that has occurred
• Computer IP/name recorded upon submission if user is using the malfunctioning computer to report the fault
• Integrate with room database described in IT booking system for list of rooms which the computer is in if not reporting fault from the malfunctioning computer
• Database of technicians along with specialities and work times etc.
• Automatic fault assignment to suitable technicians based on workload, work times etc. in database
• Jobs automatically prioritised in terms of urgency, priority and time in the job queue plus other factors
• Per-technician job list of assigned faults for printing
• Technician to be able to set progress of job as in progress, complete etc.
• User should be able to track their reported faults via front-end web page
• Automatic email notification to the user upon fault submission and change in status of the fault via technicians (described above)

Administration system
Finally, I require an administration system for the two above systems, ideally integrated into a single, again web based, interface.

Specifications

• Addition, editing and deletion of technicians and rooms
• Reassignment of faults to different technicians
• Deletion and editing of bookings
• Blacklisting of specific dates/times when rooms cannot be booked, ideally with option to be recursive e.g. every week on same day at same time etc.
• Print various reports on booking trends across departments/individuals and fault logging efficiency etc.

Exact reports to produce are yet to be decided upon.

Reply or send quotes directly to contact [at] craigsworks.com

Thread to the advertising section.

Good luck!