ASP Support Ticket System to support access and mssql databases:
What it needs to do:
Registration Page:
User Name, email, phone, alternate phone, address, address suite/apt, city, state, zip, password, verify password. ( all fields required except address suite / apt ) spam security ( either a random question that has to be answered correctly ( 10 +1= ) or something along that line.
Login field will be their email
Once the user has registered an email is to be sent to the admin and the user with the information.
Ticket system:
Date created
Create an automatic ticket ID ( example would be XX000001 )
Type ( drop down list the is populated from a table )
Manufacture ( drop down list populated from a table )
Model ( drop down list that is populated from a table, but filter to show only the models that are link to the manufacture )
Serial Number
Operating System ( drop down list populated from a table )
Issue ( memo field to allow user to describe the issue )
Status ( Drop down list from table, but only the admin or tech can modify ) when the ticket is created, it will be considered opened.
Need to be able to have the admin, tech add notes to the ticket.
User can reply to the notes .
All notes and replies need to be time stamped and labeled who created the note or reply
Security:
The user can only see the tickets they created along with any notes and replies linked to that ticket.
Techs can only see the tickets and add noted that they are assigned to and can update the status of the ticket
Admin can see all and manage all the tables in the database in a secure admin area of the site ( can not be in the root public site, needs to be in a subfolder )
On the ticket view page it needs to pull in all the data including any notes and replies that are linked to the ticket. Need to show the open tickets only, user can click on history link to view closed tickets.
Tickets can be searchable by ticket number or email ( users can only search for the tickets they submitted )
VERY IMPORTANT – anytime the ticket is updated ( notes added, replies added, status change ) it will email the user, the tech and the admin. Email uses cdosys – must have a table with the email settings, smtp server, username, password, port.
Security is a must ( must be written to keep malicious injection from happening)
NEED THIS ASAP – not worried about the look, I can tweak the layout
This script is for computer service center and they will be using it as a computer check in system as well. This code will be considered proprietary and not for resale.