Maintenance Module

Equipment maintenance tracking and service scheduling.

Features

• Equipment management (forklifts, scanners, batteries, tools)
• Service scheduling with automatic date calculations
• Maintenance log tracking with cost tracking
• Upcoming service warnings (7 days) and overdue alerts
• Service calendar view
• Equipment status management (ok, needs_service, in_repair)
• Driver warnings for assigned equipment

Permissions

• Admin: Full access to equipment + maintenance_logs
• Maintenance Worker: Can add logs but cannot modify equipment settings
• Drivers / other workers: Read-only access to equipment status, no write access

Database Schema

Tables

• equipment: Equipment master data
• maintenance_logs: Maintenance log records

Key Functions

• getAllEquipment(tenant_id): Get all equipment
• getEquipmentDetails(id): Get equipment details
• getMaintenanceLogs(equipmentId): Get maintenance logs
• addMaintenanceLog(): Add maintenance log (updates service dates)
• updateEquipmentStatus(id, status): Update equipment status
• getUpcomingServiceSchedule(): Get upcoming services

Integration

• Equipment Tracking: Links equipment positions to maintenance records
• Driver Dashboard: Shows warnings for assigned equipment