ScanTrack Release Notes

Production Milestone

• ScanTrack 3.0.0 is the stable production go-live release for SaaS deployments
• Enabled multi-tenant architecture with per-tenant SQLite databases
• Added tenant-aware request routing and tenant database context binding

Multi-Tenancy and Isolation

• Added platform tenant registry with seeded tenants for verhuisteam.scantrack.be and mindshift.scantrack.be
• Implemented host-based tenant resolution middleware for strict tenant separation
• Bound JWT authentication to tenant context to prevent cross-tenant token usage
• Isolated tenant uploads and QR assets under tenant-specific paths

Infrastructure and Operations

• Updated Traefik routing for tenant subdomain strategy on .scantrack.be
• Hardened certificate/routing behavior for production-safe tenant host handling
• Added tenant provisioning command to bootstrap and initialize tenant databases

Improvements

• Improved deliveries UI for customer-role users by removing customer-specific filter and table data not needed for their scope
• Improved PWA update rollout by forcing service worker update checks and immediate activation handling
• Changed navigation and document caching strategy to network-first to reduce stale UI after deployments
• Added centralized structured logging and project-level ESLint configuration for better maintainability

Bug Fixes

• Fixed header username rendering by decoding JWT payloads robustly for UTF-8 characters
• Fixed dashboard stats query binding issues and added regression test coverage
• Fixed Traefik rate limiting configuration to apply only to authentication routes
• Added no-cache headers for /sw.js to prevent delayed service worker script updates

Testing and Quality

• Added automated test coverage for health, readiness, and metrics observability endpoints
• Added logger and customer API tests and improved overall coverage reliability

New Features

• Added ZPL label printing support for Zebra printers
• Implemented full PWA support with service worker and offline mode
• Added complete PWA icon set, manifest updates, and custom SVG app icon
• Added comment indicators for packages and deliveries when package photos contain comments

Improvements

• Improved camera scanner modal UX by vertically centering it on package pages
• Enhanced internationalization coverage with complete German localization and missing key translations
• Updated footer to show app version with direct link to release notes
• Removed unused delivery and label UI helper functions for cleaner frontend code

Bug Fixes

• Fixed escaped HTML rendering in dashboard recent activity i18n content
• Normalized delivery and label status handling to align app behavior and tests
• Updated Traefik host rule by removing obsolete www host from ScanTrack routing

🔒 Security Fixes

• Fixed critical SQL injection vulnerability in Delivery.updateStatus() method
• Replaced string concatenation with parameterized queries for database safety
• Enhanced delivery deletion with proper foreign key constraint handling

🚀 New Features

• Role-based UI controls for delivery management with conditional rendering
• User role context passed to all page templates for dynamic UI rendering
• Enhanced authentication middleware with multi-source token support
• Package navigation buttons for moving between packages in same delivery
• Increased maximum photos per multiple upload from 10 to 30

🔧 Improvements

• Admin-only delivery creation and status update controls
• Non-customer user access to package scanning functionality
• Enhanced package status handling with improved photo deletion
• Database migration for delivery statuses (in_transit → fulfilled)
• Centralized delivery status updates using helper functions
• Improved home page column layout for better visual balance
• Package status change events added to dashboard activity feed

🐛 Bug Fixes

• Fixed delivery deletion cascade issues with foreign key constraints
• Resolved SQL injection vulnerability in status update operations
• Fixed authentication middleware token handling
• Improved package status tracking and photo management

🏗️ Infrastructure

• Enhanced security through parameterized database queries
• Improved delivery deletion workflow with proper data cleanup
• Role-based access control integration across all templates
• Authentication middleware improvements for better token handling
• Database schema updates for delivery status consistency

🚀 New Features

• Advanced photo comment system with visual indicators and read-only display
• Yellow exclamation icon on photos with comments (bottom-right corner)
• Comprehensive PDF report generation for packages using same technology as labels
• Delivery package overview in scanning modals (shows other packages in same delivery)
• Enhanced package detail page layout with reordered sections for better UX

🔧 Improvements

• Reorganized package detail page: Delivery Info → Photos → Timeline → Package Details
• Moved Print/Download buttons to Delivery Information card header
• Photo section headers now color-coded by context (Arrival=Blue, Loading=Yellow, Unloading=Green)
• Enhanced photo modal with styled comment boxes and better layout
• Automatic photo capture trigger after package status changes
• Improved comment handling for both new and existing photos

🐛 Bug Fixes

• Fixed photo modal timing issues preventing photo capture after scanning
• Resolved comment column database migration issues
• Fixed JavaScript optional chaining compatibility issues
• Updated Node.js Docker image to version 18 for better compatibility
• Fixed alert container access issues in modal workflows

📊 Data Management

• Database schema migration for photo comments with backward compatibility
• Enhanced photo upload handling with comment persistence
• PDF report generation with package details, delivery info, and photo comments
• Improved multi-photo upload with comment preservation

🏗️ Infrastructure

• Updated Node.js to version 18 for better stability and compatibility
• Downgraded problematic dependencies (i18next, mongodb-memory-server) for compatibility
• Enhanced Docker configuration for production deployment
• Database migration script for schema updates

🚀 New Features

• Advanced label status system with 'assigned' status for QR codes used in packages
• Package assignment to deliveries with custom QR codes and automatic status tracking
• Enhanced QR scanning with automated camera start and status selection modals

🔧 Improvements

• Streamlined package detail view with removed unnecessary fields and enhanced QR code display
• Standardized timestamp handling across all package operations with Brussels timezone
• Improved label management workflow with status filtering and protection for assigned labels
• Enhanced package creation process with automatic timestamp registration
• Cleaned up packages page interface by removing manual package creation button

🐛 Bug Fixes

• Fixed delivery unload condition logic and removed unnecessary in_transit status display
• Corrected timestamp registration for packages created via QR code assignment
• Resolved label status display issues with backward compatibility
• Fixed timezone display inconsistencies across delivery and package views

📊 Data Management

• Database schema migration for label status system (backward compatible)
• Enhanced package status tracking with proper timestamp management
• Improved label lifecycle management with assigned status protection

🚀 New Features

• Complete package scanning internationalization with comprehensive translations
• Dynamic language dropdown that shows language names in user's current language
• Language code translations (en, nl, fr, de) for seamless language switching

🔧 Improvements

• Enhanced packages page with full i18n support for all UI elements
• Added comprehensive package translations to all 4 language files (28 keys each)
• Updated German translations to match other languages' completeness
• Fixed language selector to use template-based translation for dynamic language display
• Improved middleware to provide language codes for proper translation context

🌍 Internationalization

• Complete packages section translations for scanning, filters, tables, and modals
• Language name translations that adapt to user's current language
• Consistent translation structure across all language files
• Proper fallback handling for missing translations

🐛 Bug Fixes

• Fixed EJS template syntax issues in language selector
• Resolved language dropdown translation context problems
• Added missing language code translations to all language files

🚀 New Features

• Logistics-themed login page with animated warehouse background
• Advanced filtering system for deliveries (by customer and status)
• Status filtering for QR code labels management
• Enhanced testing infrastructure with isolated databases

🔧 Improvements

• Comprehensive internationalization (i18n) system with English, Dutch, French, German
• Client-side translation fallback for untranslated keys
• Improved sidebar navigation with proper translation support
• Enhanced video stream cleanup for camera functionality
• Optimized dashboard date handling and customer filtering

🐛 Bug Fixes

• Fixed translation key display issues in sidebar navigation
• Resolved i18n namespace conflicts and missing translations
• Fixed gitignore configuration for database and translation files
• Corrected model bugs in testing infrastructure

🧪 Testing

• Complete test suite overhaul with isolated database testing
• Added comprehensive API endpoint testing
• Enhanced middleware and authentication testing
• Model filtering and pagination test coverage

🚀 New Features

• Complete internationalization (i18n) system with i18next
• Multi-language support: English, Dutch, French, German
• Comprehensive QR code label generation and management
• Advanced camera scanning for QR codes and photo capture
• Package status selection modal for streamlined scanning
• Label assignment system for packages with code-based lookup
• Dynamic dashboard with delivery statistics and activity feeds
• Customer data filtering middleware for role-based access

🔧 Improvements

• Modern responsive UI with mobile-optimized tables
• Enhanced user profile management with photo upload
• Dynamic header updates with real-time user information
• Streamlined authentication with client-side token management
• Admin-only navigation controls for customer and user management
• Package details page with QR generation and photo gallery
• Improved delivery status tracking and package counting

🔒 Security

• Role-based access control with admin restrictions
• Enhanced JWT authentication middleware
• Secure password change endpoints
• Public roles endpoint with proper access controls

🚀 New Features

• Complete SQLite database architecture with proper schema
• Docker containerization with cross-platform support
• Volume mounting for persistent database storage
• Traefik reverse proxy integration for production deployment
• Basic user authentication and session management
• Foundation templates and UI framework (NiceAdmin)

📚 Documentation

• Comprehensive README with setup instructions
• Project overview and feature documentation
• Role-based access explanations
• Development and deployment guidelines

🔧 Infrastructure

• Node.js/Express application foundation
• Database configuration and connection management
• Docker Compose setup for development environment
• Cross-platform compatibility (Windows/Linux/Mac)
• Production-ready container configuration