This content has been marked as final. Show 4 replies
Do you mean "traffic tickets", "airline tickets", "event tickets", or something else?
Most likely an IT ticket system, where people create tickets when a problem arises, and the IT tech/dept receives the ticket and reacts appropriately.
I do not know of a pre-made system like this, however it would take little programming to set this up. Build it into a web app for easy company distribution. Then create a form that inputs the user's name, department, and problem. If able, use CFMAIL to notify your tech team when a ticket has been filed. Else, you will have to keep a meta refresh page querying from a ticket database to show new tickets in realtime.
We do this at my agency and CFMAIL has been very useful. We get a somewhat large volume of support calls from unplugged cables, printer toner changes, to broken apps. The ticket system allows us to better manage the immediate problems from the ones that can wait. We still take urgent support by phone because sometimes, email just isn't fast enough! :)
Like most other projects, this becomes more of a "people" issue rather than a programming issue.
If you can document the business rules (and get people to agree to them... ugh) then the programming is the easy part.
Make judicious use of primary keys to keep track of individual tickets and tracking of the progress on those tickets and you are on your way.
We also use a forum system like this one for end users, since they don't always get the ticket system thing, easy to ask questions, post bugs, easy to answer, easy to search, easy for others to find the answers.