VirtualVocations

Offsite IT Room Booking and Fault Logging System

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.

Employer Posted:Wednesday, July 23, 2008