Problem:
Large East Coast retailer needs a trouble ticketing system to track the repair and replacement of
point of sale equipment, primarily the thermal printers used to print customer receipts.
Solution:
Clean, robust, user-friendly trouble ticket system written in PHP and backed by a MySQL database.
We looked at several pre-existing open source trouble ticketing systems, but
while there were some excellent projects, they were all more complicated and
featureful than the client needed. The system we developed not only tracks
tickets, complete with e-mail notification of ticket status, but includes
interfaces allowing the administrator account to add/modify users, stores,
products and shipping methods.
A feature that I'm proud of is an elegant method to sort (in ascending or
descending order) tickets on several useful fields and constrain them by user,
store or ticket status.
Because I was able to utilize several libraries that I've developed over the
years, total billing for this project was just under 40 hours.
Technologies Used:
PHP, MySQL, CSS, JavaScript. A little Perl to
parse the clients nasty spreadsheet of store address and contact information.
|