Support tickets system
$100-200 USD
Pagado a la entrega
We currently are using a ticketing system that is overly complex for our organization. We are looking for a programmer to create an entirely new system that will be simple. We want it developed in PHP and MySQL so that it can integrate with the other data we have, specifically customer table, employee table, work table and calendar table. We want this to be very clean and iPhone friendly. I have a CSS design I will be providing which will guarantee it displays cleanly on the iPhone.
The ticketing system will have three main views: Support Tickets, LMI Tickets, Your Tickets. When you click on a ticket it takes you to a page to view more details, where there will be buttons with actions like Create Appointment, Create Task, Lock, Close. Lastly, there will be a history page to view closed tickets and you will be able filter by customer or employee, or do a search.
## Deliverables
Here is more information on the ticketing system. A ticket consists of a ticket_id (unique, auto-increment), created_by, owner (both use the emp_id field from the employee table), cust_id (customer id from the customer table), subject, body, priority, queue_name, state (open, locked, closed), and created_timedate.
Tickets exist in two queues: Support and Log Me In and when they come in are marked as state "Open". When you view the Support or Log Me In "list" pages, you will see a list of open tickets sorted by their age (minutes since they were created) and displaying customer and subject. The age is the number you see in our prototype.
When you click on a ticket, you will see more details, including the body of the ticket. You will also have CSS buttons (like the Page 2 seen on this [url removed, login to view] ) to do actions: Make Appointment, Create Task, Lock Ticket. When you Make Appointment, it adds an appointment to the calendar right now (I can provide function that does part of this) and it locks the ticket. When you Create Task, it adds a task in the task table for that customer, and changes ticket state to Closed. Clicking on Lock locks the ticket (changes owner to the user clicking it). Under the details of the ticket, you can also see links to appointments associated with this ticket. You can associate many appointments to a ticket, but only one ticket per appointment. After clicking on the buttons, it should take you to the most logical "list" view (which should be where you came from to look at the details of the ticket).
The third list view is the Yours page. This page shows tickets you have locked but are not closed. Once again in here you can click on tickets to view details, but now there is a "Close" button instead of the Lock button. At the end of this page is also a button to the history page. When you click on this button it should default to taking you to the history page displaying only your closed tickets, with the most recent at top. Here you should be able to filter by employee, customer or do a search (maybe even more filters that you consider pertinent).
Attached is the CSS file, as well as an example layout. We'd like the ticketing system to look exactly like that, with the one exception being we'd like the word "Add" (and only the word "Add") to be right-justified.
You'd see the Support (0) Log Me In (0) Yours (0) on each of those 3 pages. On the History page, you'd see only a link back to "Support" (which is the default view).
Clicking on the word Add will go to the ticket creation page, when you can enter a new ticket by choosing the pertinent information: Customer, Subject, Body, Priority. At this time all tickets created this way go to the Support queue automatically.
We would like the "ticket count" number next to Support, Log Me In and Yours to be orange in color when the number is not zero, and a light shade of gray when it is zero. We'd also like the parenthesis around the number to always be that shade of gray.
It is really important to maintain this website iPhone-friendly, so we'd like to minimize the use of tables and especially never have a table with a specific width in pixels. The examples attached look beautiful on the iphone. It wraps the text that is too wide.
Lastly, we'd like a script to run on our [url removed, login to view] that will unlock all locked tickets. Tickets can't stay locked overnight.
We need files to be Unix-based. If you are working on Windows, please ensure your editing program allows to save in Unix format.
Nº del proyecto: #3805734
Sobre el proyecto
Adjudicado a:
14 freelancers están ofertando un promedio de $142 por este trabajo
