Trouble Ticket System

This project covers the situation where n people work on m projects and only parts of n work on the same projects. Within a project several jobs have to be done, jobs can be ordered several classes. This system addresses this situation and helps people to maintain their projects and tasks.

For each task a ticket can be opened, if it is not being worked on it will be nagged. Communication with the ticket system is done via HTTP so any web browser is fine to connect to it - while it is best viewed with Lynx. Notification and naging takes place via mail.

Jobs are called tickets within this system. Each job can be connected with up to n staff members, where n is a per system defined value. Each ticket is also subordinated one class. Classes can be defined on a per system basis, depending on the special needs of the users. There are single tickets and children which have to be finished before the main ticket can be closed.

The system is database-oriented, it is entirely written in Perl version 5.x. The backend database can be any SQL database that one can access via the Perl DataBase Interface/DBD. Currently only PostgreSQL, MySQL and mSQL as backend databases are supported.