ScanTrack Release Notes

🚀 New Features

• Added tenant-wide virtual label mode so teams can run package workflows without generated physical QR labels
• Added direct package-flow launch actions from delivery detail and package detail pages when virtual labels are enabled
• Added virtual package creation from the delivery detail page so users can create extra packages on demand during the workflow

🔧 Improvements

• Separated physical and virtual label experiences more clearly by hiding QR label management, removing QR output from package detail, and showing package identifiers instead
• Improved package evidence reports so PDF output reflects the active identification mode and omits QR code image evidence in virtual-label tenants
• Improved warehouse workflow consistency by reusing the existing status and photo pipeline across delivery detail, package detail, and virtual-label entry points
• Expanded automated test coverage across admin, warehouse, driver, and customer roles for virtual label workflows, PDF output, and permission boundaries

🐛 Bug Fixes

• Fixed dashboard recent-activity package links to follow canonical package unique-code URLs instead of legacy numeric package IDs
• Fixed virtual-flow access rules so only roles with valid next actions can start package status changes from delivery and package pages
• Fixed package report generation assertions and PDF verification behavior to support compressed PDF text reliably during automated testing

🚀 New Features

• Added a dedicated platform backoffice host with operator-authenticated access, tenant plans, operator management APIs, and platform audit logs
• Added upload progress feedback when assigning package photos so long-running uploads are visible to users during evidence capture flows
• Added warehouse-location restore-on-create behavior so archived locations can be safely reactivated instead of duplicated

🔧 Improvements

• Improved platform dashboard redirects to preserve the active tab context when moving between backoffice sections
• Improved multi-tenant routing behavior by excluding tenant fallback hosts from platform-host detection and tightening Traefik tenant-domain matching
• Improved package trace consistency by aligning the package detail page and exported PDF reports around current-package timeline context

🐛 Bug Fixes

• Fixed package detail timeline pollution where events from sibling packages in the same delivery could appear under the current package trace
• Fixed package PDF timeline output so reports no longer include unrelated same-delivery package events
• Fixed SQLite startup race conditions in tenant and platform seed upserts by making default domain and operator inserts resilient to unique conflicts
• Fixed platform/tenant host resolution edge cases that could misclassify fallback domains or break tenant routing in reverse-proxy setups

🚀 New Features

• Added tenant warehouse locations with bulk upload/template support and optional warehouse-location assignment during label assignment, package scans, and package detail editing
• Added missing warehouse-location indicators across deliveries, packages, and delivery detail views so unassigned packages are visible at a glance
• Added historical archiving for customers and warehouse locations so deleted records stay available for delivery, package, photo, and audit metadata
• Added package photo metadata/audit enhancements, including original-file sealing and richer traceability for uploaded media
• Added package PDF reporting and dashboard recent-activity deep links to package and order detail pages

🔧 Improvements

• Unified bulk-selection UX across deliveries, packages, labels, customers, and warehouse pages with header checkboxes, cleaner selected-count placement, and consistent action layouts
• Improved table usability with clickable column sorting, broader search support on customer and user lists, and consistent detail/edit button styling
• Expanded customer and warehouse maintenance workflows with demo-file downloads, bulk upload tooling, and consistent inline edit/delete actions
• Improved package and delivery detail visibility with warehouse-location fields, cleaner comment/location warning icon grouping, and clearer Warehouse status wording
• Hardened tenant migration, commit-hook, and TeamCity/Cypress pipeline behavior for more reliable upgrades, testing, and deployment flows

🐛 Bug Fixes

• Fixed historical data loss when deleting customers or warehouse locations by replacing hard deletes with archive behavior
• Fixed customer, user, and warehouse page load failures on legacy tenant databases by ensuring missing archive columns are migrated before use
• Fixed label bulk-action timing issues in end-to-end coverage by waiting for filtered table reloads before asserting selection state
• Fixed package and delivery list inconsistencies around missing-location visibility, action icon alignment, and Warehouse status labels

🚀 New Features

• Added package photo modal rotation controls with responsive sizing improvements for desktop and mobile viewing
• Added localized delivery customer update feedback and profile photo removal translation support

🔧 Improvements

• Improved role-based UI consistency by restricting Profile Settings tab visibility to admin users only
• Improved package detail visibility rules so Timeline & Trace is shown only to admins and still honors the hide toggle
• Improved package status rollback behavior by automatically clearing downstream scan timestamps when moving back to earlier statuses
• Improved scan/photo workflow reliability with stronger camera modal state resets and safer auto-assignment handling

🐛 Bug Fixes

• Fixed package navigation ordering so Previous/Next buttons follow the expected package sequence
• Fixed occasional photo ordering issues by preserving deterministic upload order for multi-photo submissions
• Fixed a scan workflow issue where photos from a previous package could carry over to the next package
• Fixed user form validation to require selecting a customer when creating or updating a user with Customer role
• Fixed delivery creation customer selection to exclude inactive customers
• Fixed package detail information exposure by removing the internal package ID from the visible details section
• Fixed scan status option alignment so status selection matches accepted API scan values

🚀 New Features

• Added role-based photo comment management so authorized users can add, edit, and delete comments directly from package photo details
• Added role-aware photo delete controls in package detail so delete actions are shown only to users with permission
• Added display-only "In Process" status mapping support for non-fulfilled delivery states
• Added debounced text search for deliveries and packages to improve filtering performance
• Added unique public delivery IDs with safe backfill support for existing data
• Expanded role behavior: warehouse unloading scan support and admin-only access to the Labels page

🔧 Improvements

• Improved package camera scanner UX with smarter capture flow, zoom controls, refined mobile layout, and larger modal viewport sizing
• Improved delivery detail editing experience by extending editable fields and related translation coverage
• Extended delivery document schema and upload-related localization texts
• Expanded automated edge-case test coverage for deliveries, users, and web route behavior

🐛 Bug Fixes

• Fixed security/administration risk by preventing deletion of the default admin account
• Fixed Zebra print reliability by sending label print requests sequentially with a 1-second delay
• Fixed multipart photo upload handling to preserve full comment values across multi-photo submissions
• Fixed duplicate camera capture/upload scenarios in package photo workflows
• Fixed UI regressions including profile avatar fallback/migration and navbar profile-name overflow

🚀 New Features

• Expanded internationalization coverage across key pages, including Users, Customers, Settings, Profile, Delivery Detail, and shared app shell components
• Added route-level localized page titles via server-side translation mapping so page headers and browser titles consistently match the selected language
• Extended translation structure with additional namespaces and keys for app shell, user management, customer management, settings, profile, delivery detail, and release notes metadata

🔧 Improvements

• Refined Dutch, French, and German translations through a second semantic pass to improve UI wording consistency and reduce mixed-language phrasing
• Localized scanner and photo-assignment runtime messages and modal flows to ensure end-to-end multi-language user experience in package and delivery workflows
• Updated release notes formatting consistency and section heading presentation for improved readability

🐛 Bug Fixes

• Fixed hardcoded or missing translation strings across multiple EJS templates, including form labels, alerts, and status text
• Fixed dashboard title rendering behavior by aligning home page header logic with localized route-provided page titles
• Fixed translation quality issues and ensured locale key parity and placeholder consistency across English, Dutch, French, and German files

🚀 New Features

• Added tenant-level Zebra printer configuration keys (IP and port) to replace hardcoded printer routing in label printing
• Added a new admin-only Tenant Settings tab on Profile to configure Zebra printer host and port per tenant
• Enhanced the package scanner modal flow with a shared anchored action bar for faster repeated photo capture

🔧 Improvements

• Standardized scanner modal dimensions and content layout so action controls stay in a consistent place between scan, preview, and gallery states
• Improved camera scanner mobile UX by moving key actions to stable positions and refining button spacing/order for rapid one-handed usage
• Adjusted mobile scanner behavior and QR box sizing for more reliable camera decoding across device screen sizes

🐛 Bug Fixes

• Fixed profile avatar rendering regressions by normalizing image URLs and adding safe fallback behavior
• Fixed an issue where the last captured photo could be missed during package assignment/upload if it had not been explicitly kept first
• Fixed mobile scanner regressions where the camera opened but QR codes were no longer recognized reliably
• Fixed mobile modal footer clipping so Close and Assign to Package actions remain accessible

🚀 New Features

• Added a global tenant setting to hide the entire "Package Timeline & Trace" card on package detail pages
• Added a new admin Profile setting toggle to control timeline visibility for all users in the tenant
• Enhanced admin photo comment controls so admins can add a comment when none exists, in addition to editing existing comments

🔧 Improvements

• Improved timestamp handling by parsing database timestamps as UTC and rendering them in the configured user timezone
• Extended consistent timezone-aware date rendering across delivery, package, customer, user, label, profile, and dashboard views
• Improved delivery information readability by preserving line breaks in the editable Information field
• Simplified delivery detail header actions by removing the legacy yellow Scan button

🐛 Bug Fixes

• Fixed timezone offset issues where scan timestamps could display incorrect local times in Brussels and other timezones
• Fixed timeline visibility behavior to hide the full timeline card container, not only nested timeline content

🚀 New Features

• Added global admin settings to hide dashboard, hide package scan history, and simplify order status visibility for all users
• Added optional delivery information field at creation and on delivery details, with admin edit support
• Added package photo references (e.g. PH-000123) on package detail views to improve customer support referencing
• Added admin-only in-modal editing of photo comments on package detail page
• Added previous/next navigation in package photo modal with process-order sorting (arrival, loading, unloading)

🔧 Improvements

• Improved delivery details table UX by prioritizing actions and comment visibility indicators per package
• Updated sidebar layout to a more compact width for increased main content space
• Updated login page tagline styling with scoped classes and improved text contrast/accessibility
• Refined ZPL label output for 30x25mm labels, including QR layout optimization and team identifier formatting

🐛 Bug Fixes

• Fixed dashboard navigation visibility behavior when dashboard hiding is enabled
• Fixed package-detail modal reference mismatch where incorrect photo reference could be shown
• Fixed photo modal backdrop darkening on previous/next navigation by reusing the same modal instance
• Fixed delayed frontend updates after photo comment edits by refreshing modal and list state immediately
• Fixed delivery package comment indicator regression so warning icons appear correctly when photo comments exist
• Updated ZPL printer host/port settings for label printing reliability

🎯 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