From cb39042b12948c9dadfc70118e074ba626431203 Mon Sep 17 00:00:00 2001 From: arf20 Date: Fri, 15 Mar 2024 17:51:31 +0100 Subject: More design --- README.md | 41 ++++++++++++++++++++++++++++++++++------- 1 file changed, 34 insertions(+), 7 deletions(-) diff --git a/README.md b/README.md index e5241f3..179bef8 100644 --- a/README.md +++ b/README.md @@ -4,7 +4,8 @@ ARFNET2 Client, Service manager and Ticketing system ``` User types: Admin: user, service and ticket management - Helpdesk: read, answer and close tickets only + Helpdesk: read, answer and close tickets + Accountant: view invoices and change status Client: order services and open tickets Report problems with CST or such as password changes to admin@arf20.com @@ -22,9 +23,34 @@ FILES: client.php -> { order.php, openticket.php } shows ordered services and opened tickets helpdesk.php - view and close tickets - admin.php - manage users, services and tickets + view, self-assign and close tickets + accounting.php + view invoices and change status + admin.php -> { manageusers.php, manageservices.php, managetickets.php } + shows users, services, tickets and invoices + + Client: + order.php + add service to account, sends mail to admin@arf20.com to deploy manually + billing is automated + openticket.php + open ticket linked to account and service, sends mail to helpdesk@arf20.com list + then helpdesk answers email and stuff + + Admin: + manageusers.php + form to add, edit and delete user entries + manageservices.php + form to add, edit and delete service entries + managetickets.php + form to add, edit and delete ticket entries (assign, too, sends email to specific helpdesk person) + manageinvoices.php + form to add, edit and delete invoice entries + + Everyday crontab: + makeinvoices.php + when billing for a service is due, generates invoice and sends to client and accounting@arf20.com list + SQL: Database: arfnet2 @@ -34,8 +60,9 @@ Tables: services Available services and management notes etc id autoincrement, name, type, billing, description orders - id autoincrement, service id, instance name, client id, comments + id autoincrement, service id, instance name, client id, order date, specific billing, comments tickets List of tickets - id autoincrement, client id, title, body, status { open, closed, nofix } - + id autoincrement, client id, title, body, status { open, closed, nofix }, asignee + invoices List of invoices + id autoincrement, client id, service id, bill amount, description, date, status { paid, unpaid } ``` -- cgit v1.2.3