Admin Panel

Role-Based Access Control

Administrator Login

Username: *
Password: *
Role: *

Dashboard -

Customer Management (Read, Insert, Update)

Customer ID:
Full Name:

Product Management (Read, Update)

Product ID:
Update Price:

Note: Cannot delete products

Order Management (Read, Insert, Update)

Order ID:
Update Status:

Inventory Management (Read, Insert, Update)

Store:
Product ID:
Quantity:

Inventory Management (Full CRUD)

Store ID:
Product ID:
Stock Quantity:

Store Management (Read, Update)

Store ID:
Store Type:

Order Tracking (Read Only)

Order ID:

Track orders to manage inventory requirements

Product Information (Read Only)

View product information for inventory management

System Logs

Price History Log

Product ID	Old Price	New Price	Change Date	Admin User
No price changes recorded

Order Status Log

Order ID	Old Status	New Status	Change Date
No status changes recorded

Role Permissions

Admin: Full CRUD permissions on all tables. Can create, modify, and delete database objects. Complete database oversight.
Manager: Read and update permissions on most tables. Can manage inventory, update order statuses, and view reports. Cannot delete critical data.
Sales Staff: Can create and view customer orders, manage customer information. Read access to products and inventory. Cannot modify prices or inventory quantities.
Inventory Manager: Specialized role for inventory and stock control. Can update inventory levels, manage store stock. Read access to orders for inventory tracking.
Read Only: View-only access to all tables for reporting and analysis. Cannot make any changes. Suitable for analysts and auditors.

Admin Panel

Role-Based Access Control

Dashboard -

Product Management (CRUD)

Category Management (CRUD)

Database Objects Management

Customer Management (Read, Insert, Update)

Product Management (Read, Update)

Order Management (Read, Insert, Update)

Inventory Management (Read, Insert, Update)

Customer Management (Read, Insert, Update)

Order Processing (Read, Insert, Update)

Product Catalog (Read Only)

Inventory Management (Full CRUD)

Store Management (Read, Update)

Order Tracking (Read Only)

Product Information (Read Only)

View All Data (Read Only Access)

Reports & Analytics

Data Export

System Logs

Price History Log

Order Status Log

Role Permissions

Product Name:
Price:
Category:

Category Type:
Category Name:

Customer Name:
Email:
Phone:

Search Products: