I need a way to track problems and or returns by order number. The systems needs to run on PHP and MySQL.
I don't need anything too fancy. I just need a way to create a ticket. Update the status. Add comments. Close the ticket, Etc...
A MySQL table with a few status types would be good:
Customer wants return
The PHP form would allow me to look at all open problems and closed problem separately.
The form would need at least the following types of data in the form:
Order Number (255 Char or less)
Problem number (Int)
Customer First Name (255 Char or less)
Customer Last Name (255 Char or less)
Additional Info: (LongText)
I was envisioning a php page and two MySQL tables.
Problems (Problem_Number, Order_Number, C_F_Name, C_L_Name, Problem, Add_info, Date_Added, Date_Last_Modified, Date_Resolved, Current_Status) (All of the problem info)
Status (Status_Name) (Open, Closed, Awaiting Return, etc...)