I am looking for a script that will be used as a basic ticket system that prints customer
details and unique work order number to a pre-printed workshop report sheet, my preference is to
use PHP and mysql.
1. I am looking for a form that will allow a user to submit personal details (name, address
etc), or search database if details have previously been submitted.
2. Once details are submitted I want them to be printed to specific fields on pre-printed paper
and an email notification sent to an admin account.
3. The print needs to include a unique reference/ticket number
4. printout needs to be in duplicate.
5. I would like to query the database and output email addresses to a csv or text file so I can
send out email shots, based on tickets submitted in the last week, 1-six months and year+.
6. I would also like to pull up a ticket/case no history for any user.
7. I would like ticket status Opened, In-Progress, Confirm, Closed, with a status page showing
current open/in-progress/confirm tickets.