aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorarf20 <aruizfernandez05@gmail.com>2024-03-15 17:51:31 +0100
committerarf20 <aruizfernandez05@gmail.com>2024-03-15 17:51:31 +0100
commitcb39042b12948c9dadfc70118e074ba626431203 (patch)
treeee0e5ab31ea1b36a55f9bba0d34b74fb73b4a553
parent7377f6cd21d1069d4392c16bf0d13e3f8b0b8375 (diff)
downloadarfnet2-cstims-cb39042b12948c9dadfc70118e074ba626431203.tar.gz
arfnet2-cstims-cb39042b12948c9dadfc70118e074ba626431203.zip
More design
-rw-r--r--README.md41
1 files 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 }
```