Equipment Tracking Module

QR/RFID/manual equipment location tracking.

Features

• QR code scanning for equipment location updates
• Real-time equipment position tracking
• Stale equipment alerts (>24h warning, >72h critical)
• Last seen overview with color indicators
• Warehouse map integration with equipment overlay
• Equipment type tracking (forklift, scanner, battery, tool)

Permissions

• Workers: Can insert QR scans
• Admin: Full read + write
• Drivers: Read-only

Database Schema

Tables

• equipment_positions: Equipment position records

Key Functions

• recordEquipmentScan(): Record equipment scan
• getLatestEquipmentPositions(tenant_id): Get latest positions
• getEquipmentStaleReport(tenant_id): Get stale equipment
• getEquipmentForMap(tenant_id): Get equipment for map overlay
• validateQR(equipment_id): Validate QR code

Integration

• Maintenance: Links to equipment maintenance records
• Floor Plan: Shows equipment positions on map