I need a simple website created that will display client ticket information and allow commenting and uploading of files. It will use smtp to email comments to relevant users and will also take emails and add a record in the DB.
You must create the database structure. You can use any server-side language you wish. For DB, I prefer MySQL, but open to MSSQL. You will need to deploy it for me on my server. It can run from linux or windows box. Feel free to use framework like joomla/drupal/etc.
It will be a simple white page with no formatting, just standard text, with links and tables.
The site will be password protected. The client will need to to login to view info. So you will need some authentication.
The home page will show List of tickets for that user.
If user clicks on ticket, it will show ticket details, in another frame or table to the right.
There will be input field to enter comments. The comment will show name of user who submitted it.
They will be able to change display priority level of the ticket. From 1-5.
They can attach a file to the ticket.
They can delete the ticket or edit it.
They can change the status of the ticket. The status text will all be different color.
The page will refresh anytime an action is taken.
The client should be able to send an email to an address (i can provide imap/smtp account) and the server should create a ticket or post a comment based on the subject of the email (or it can be based on the email address as well, can create separate accounts).
THe client should also get comments to their tickets in their inbox. So server will use smtp to send email as well.
More details are below. If you do well and can be trusted, I will give you more work.
**On Home page:**
-Show Client name
-Ticket table fields:
**On ticket detail page:**
all of the above
time stamp of ticket
list of all comments
user that submitted comment
time stamp of comment
+delete button for ticket (confirm y/n dialog)
+input box for new comment, with submit button.
priority level (1-5)
status (New, In Progress, Needs Review, Review Complete, Done, Trashed)