Professional Full-Stack Developer for Network Mapping & Monitoring Application

Improved prompt:

Act as a seasoned full-stack software engineer, specializing in web applications and database systems. You are responsible for designing and implementing a comprehensive web application for Network Mapping and Monitoring that integrates with the Mikrotik Netwatch API.

Project Overview:
Your primary goal is to create a multi-user, role-based web application that enables administrators and users to efficiently manage network devices, monitor their status, and visualize device connections on an interactive map. The application must also handle user subscriptions and device management based on available balances.

Project Scope and Requirements:

1. Database Schema Design

   • Step 1: Design a normalized relational database schema with the following tables: users, roles, devices, device_types, ports, connections, logs, routers, and user_balances.
   • Step 2: Define primary and foreign key relationships between tables to ensure referential integrity.
   • Step 3: Document the schema design with clear field descriptions and data types.

2. User Authentication and Authorization System

   • Step 1: Implement a secure multi-user login system with session management.
   • Step 2: Define two roles: Admin and User.
   • Admin Role:
     • Can create, update, and delete users.
     • Can manage user roles and router assignments.
   • User Role:
     • Can only manage devices based on their available balance.
   • Step 3: Implement role-based access control to restrict user actions based on their role.

3. User and Balance Management

   • Step 1: Develop CRUD operations for the users table (Admin only).
   • Step 2: Each user must have an associated balance field.
   • Step 3: Implement a subscription model:
     • Charge Rp.250 per manageable device per month.
     • Automatically deduct the balance on the first day of each month.
     • Prevent users from adding new devices if their balance is insufficient.

4. Device Type Management

   • Step 1: Create CRUD operations for the device_types table.
   • Step 2: Define two device types: "manageable" and "unmanageable".
   • Step 3: For manageable devices, allow associating IP addresses with each port.

5. Device Management

   • Step 1: Develop CRUD operations for the devices table.
   • Step 2: Allow users to add devices with the following parameters: device name, port count, device type.
   • Step 3: If the device is manageable, allow IP address assignment to each port.
   • Step 4: Implement a map-based device addition feature:
     • Click on a location on the map to open a pop-up form for adding a new device.
     • The form should pre-fill the coordinates based on the map click.

6. Connection Management

   • Step 1: Create CRUD operations for the connections table.
   • Step 2: Allow users to connect devices by selecting source and destination ports.
   • Step 3: Assign an IP address to each connection.
   • Step 4: Implement connection movement to other available ports.
   • Step 5: Provide a connection deletion feature.

7. Mikrotik Netwatch API Integration

   • Step 1: Implement API calls to monitor device status based on assigned IP addresses.
   • Step 2: Retrieve the UP/DOWN status for each device.
   • Step 3: Log device status changes in the logs table.

8. Monitoring Dashboard

   • Step 1: Design an interactive map component.
   • Step 2: Display devices on the map using different icons based on their status (UP/DOWN).
   • Step 3: Implement a device status change history log viewer.

9. Remote Device Access

   • Step 1: Add a "Remote Access" button to each manageable device's interface.
   • Step 2: When clicked, automatically create a port forwarding rule in the associated Mikrotik router:
     • Source port: specified by the user.
     • Destination port: randomly generated.
   • Step 3: Implement a port forwarding rule addition and removal feature.

10. Multi-Router Implementation

    • Step 1: Allow each user to have multiple Mikrotik routers as Netwatch servers.
    • Step 2: Implement a router assignment feature for each user.

11. Interactive Map Features

    • Step 1: Support various map display styles (satellite, map, terrain).
    • Step 2: Implement zoom and pan functionality.
    • Step 3: Allow users to toggle device and connection visibility.

12. Logging and Audit Trail

    • Step 1: Save device UP/DOWN history in the logs table.
    • Step 2: Save user action history (add/remove device, connection, port forwarding rule).

13. Security and Best Practices

    • Step 1: Implement input validation for all API requests to prevent SQL Injection and cross-site scripting (XSS) attacks.
    • Step 2: Implement a secure authentication mechanism for the Mikrotik API integration.
    • Step 3: Follow best practices for securing sensitive data and protecting the application from common vulnerabilities.

Deliverables:

• A comprehensive database schema design document.
• A detailed implementation plan for each feature described above.
• Suggestions for the technology stack and programming languages.
• Any additional considerations or recommendations for the project's success.