Act as a professional full-stack developer. You are tasked with developing a web application for Mapping & Monitoring Networks connected to the Mikrotik Netwatch API.
Your objectives include:
- Building a role-based multi-user system to manage devices and monitor their status (UP/DOWN).
- Mapping devices on an interactive map and managing user balances for device subscriptions.
Step-by-step instructions:
-
Project Structure Setup
- Define tables: users, roles, devices, device_types, ports, connections, logs, routers, and user_balances.
- Provide a normalized schema design with foreign key relationships.
-
Authentication & Authorization
- Implement a multi-user system with login & session management.
- Roles: Admin and User.
- Admin can manage users, roles, and routers.
- Users can only manage devices according to their balance.
-
User & Balance Management
- CRUD operations for users (Admin only).
- Each user has a balance.
- Subscription model: Rp.250 per device/month.
- Automatically deduct balance monthly based on device addition date.
- Prevent device addition if balance is insufficient.
-
Device Type Management (CRUD)
- Devices can be "manageable" or "unmanageable".
- If manageable, assign IP addresses per port.
-
Device Management (CRUD)
- Add devices with port count and name.
- Assign IP addresses to each port if the device is manageable.
- Add devices by clicking on a map (coordinates) → pop-up form appears.
-
Connection Management
- Connect devices by selecting source & destination ports.
- Assign IP addresses to connections.
- Move connections to other available ports.
- Remove connections.
-
Integration with Mikrotik Netwatch API
- Monitor devices based on assigned IPs.
- Retrieve UP/DOWN status.
- Log device status changes.
-
Monitoring Dashboard
- Display devices on a map with various view styles.
- Use different icon colors for UP/DOWN status.
- Show device status change history logs.
-
Remote Device Access
- Add a "Remote" button for each device.
- Clicking the button automatically creates a port forwarding rule in Mikrotik (src-port specified, dst-port random).
- Add/remove port forwarding rules.
-
Multi Router Implementation
- Each user can have more than one Mikrotik router as a Netwatch server.
- Save router assignments per user.
- Interactive Map
- Visualize all devices and connections.
- Support various map display styles.
- Logging & Audit Trail
- Save UP/DOWN history for each device.
- Save user action history (add/remove device, connection, port forwarding).
- Security & Best Practices
- Validate all API requests.
- Protect the application from SQL Injection, XSS, CSRF.
- Use secure authentication for Mikrotik API.