Código:
Status
- Aguardando resposta
- Resposta do usuario
- Resposta do admin
[0]. Ticket fechado ou concluido
Paneluser:
- Create:
- insert: id, title, message, date, character, status=1 | table tickets
- Answer:
- update: status=2 | table tickets
- insert: id, ticket_id, message, date, character | table ticket answers
- View:
- select: title, message, date where id and character | table tickets
- select: message, date, character where ticket_id | table ticket answers
- Close:
- update: status=0 | table tickets
Paneladmin:
- Answer:
- update: status=3 | table tickets
- insert: id, ticket_id, message, date, character | table ticket answers
- View:
- Close: