| Cultural Diversions |

Work Order Web Application

Work Order Application

click for project images

Project Name: Maintenance Database

Client: Brumit Restaurant Group

Industry: Food Service

Date: 2010

Technologies Used: PHP, mysql, html, css, jquery. javascript

Project Description: Develop a internet-based maintenance database system so 35 locations can login, submit a workorder, update workorders, and check the history and status of workorders

Design: The work order/maintenance database was designed using PHP, mysql, html, and css.  The project allows registered users to login and submit work orders.  When the user sumbits a work order special routing protocols automatically emails the work order request to the person responsible for seeing the issue repaired. Work orders may be updated by adding notes or updating its status. These status updates and notes are also emailed to the appropriate individuals.  The database also features an automatic on-call rotation function which displays the current maintenance  technician on call.

Future Enhancements: Add Ajax to the update form.  Add a dashboard based on user roles.

Website Login

Sortable Work Order List

List with JQuery feature clicked opened

Opening a new work order

Adding work order details

Email confirmation after submission

Email Message

Viewing a submitted work order

Work Order Update without Ajax

On Call Application

Viewed 1718 times

Leave a Reply