The login page for the admin panel of the ticketing system.
The user (non-staff) area, where clients can submit tickets or review the status of open tickets. They may also view their entire ticket history. For those clients who prefer email, the ticketing system routinely checks an email account such that users may email the CPR&M address directly and a ticket will automatically be generated from the email.
Admin interface for the ticketing system, to be used by Tufts Fletcher School CPR&M staff members. Additional mySQL database columns and tables, SQL calls via PHP, and interface changes were made to integrate the due date and department fields.
The CPR&M Office requested a way to track the time spent per help topic. They also wanted to access a number of other statistics for their annual marketing reports. I built this following their feedback via PHP and a new mySQL table. For each type of report they generate on the Reports page, there is a corresponding pie chart, table, and downloadable Excel document.
The CPR&M Office requested the ability to add, edit, and remove academic departments. I configured the interface to point to this new "Departments" page, which is populated from a newly-created mySQL table and SQL commands via PHP. Users can also edit the department for each ticket in the system.
Custom code made these feature requests happen. Users can attach files, enter the time spent per response or note, and mark the ticket status as "closed" or "pending."
Custom modification: Staff members can mark tickets as "pending" when an issue requires a response from the client.
gLike
Ticketing System for Tufts University
A custom ticketing system used to track issues, feature requests, and any interaction with the CPR&M Office at Tufts University's The Fletcher School. This system is based off of osTicket, but uses many custom PHP-based functions and configurations to address the CPR&M Office's needs.