Featured Project:
Nationwide Paintball Booking System
One of my significant improvements while working for Nationwide Paintball was the progress I made on improving their internal booking system. The goal was to create a system that could provide improved managerial, financial, marketing and sales data collection. The system was originally built in PHP as a simple portal to view bookings made online through the public website. Very little functionality had been built to accomodate managers and sales agents who relied heavily on the system for their day-to-day tasks in the company.
From the original system, I had built and released a few versions to be used in production. The improved versions benefitted from enhanced features like:
- javascript tabbed menus
- adding/editing/deleting records on-the-fly via AJAX
- activity log (audit-trail) recording of changes for each system-based and user-based record edit
- color-coding record notices
- integration with website bookings by customers
- Google Map - using the Google map API, I displayed a webpage with custom directions from the customer's postal code to a remote paintball site
- tabular listings with access to more information on each customer
- much faster access to paintball site information (sales agents were phone-based)
- integration with marketing promotions and sales information
Nationwide Paintball Admin Dashboard home page
Nationwide Paintball Admin edit record page
The editing of a record was one of the most common tasks for the sales agents. This page was very sophisticated as it queried numerous bits of data and was responsible for keeping that data accurate and reliable. Some of the unique features of this page included:
- AJAX calculation for the balance owing on an account,
- AJAX calculation for applying any promotional discounts, and updating the balance
- keeping a background activity log (audit-trail) of any changes made by the logged-in sales agent editing the record
- retrieving and updating payment information
- adding notes to the record by any sales agents
Nationwide Paintball Admin confirmation letter
This confirmation letter which would be printed as a PDF and e-mailed (or mailed) to a customer. It included a handy Google map to the paintball site location, from the postal code provided by the customer as well as driving directions. It also included information about the booking like the location, on-site contact number, and date of the booking.
