diff options
author | arf20 <aruizfernandez05@gmail.com> | 2024-03-15 17:51:31 +0100 |
---|---|---|
committer | arf20 <aruizfernandez05@gmail.com> | 2024-03-15 17:51:31 +0100 |
commit | cb39042b12948c9dadfc70118e074ba626431203 (patch) | |
tree | ee0e5ab31ea1b36a55f9bba0d34b74fb73b4a553 | |
parent | 7377f6cd21d1069d4392c16bf0d13e3f8b0b8375 (diff) | |
download | arfnet2-cstims-cb39042b12948c9dadfc70118e074ba626431203.tar.gz arfnet2-cstims-cb39042b12948c9dadfc70118e074ba626431203.zip |
More design
-rw-r--r-- | README.md | 41 |
1 files changed, 34 insertions, 7 deletions
@@ -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 } ``` |