- Fix QZ Tray library loading errors (net::ERR_NAME_NOT_RESOLVED) by switching from CDN to local static file
- Add /labels/api/pairing-keys endpoint to fetch valid printer pairing keys
- Update print_labels.html to use local js/qz-tray.js
- Update print_lost_labels.html to use local js/qz-tray.js
- Update print_lost_labels_new.html to use correct path js/qz-tray.js
- Update fg_scan.html to use local js/qz-tray.js
- API returns active pairing keys from qz_pairing_keys table for printer selection
- Fix Docker build issues:
* Add missing system dependencies (build-essential, python3-dev, libpq-dev)
* Fix requirements.txt formatting (separate Flask-Session and openpyxl)
* Update openpyxl version to 3.1.5 (3.10.0 was invalid)
- Set proper folder permissions for Docker write access (app/ and data/)
- Add comprehensive test data for labels module:
* 8 sample orders (TEST-ORD-001 through TEST-ORD-008)
* Mix of printed/unprinted orders for testing
* Various product types, customers, and delivery dates
* Ready for QZ Tray printing functionality testing
- Include test data generation scripts for future use
- Application now fully containerized and ready for labels/printing testing
- Created import_labels.py with CSV and Excel file processing
- Implemented validation for order rows and date format handling
- Added import-labels route with preview and save functionality
- Created import_labels.html template with new app UI styling
- Added import card to labels module index
- Added openpyxl to requirements.txt for Excel support
- Migrate print_labels.html and print_lost_labels.html to standalone pages with header and theme toggle
- Implement dark/light theme support using data-theme attribute and CSS variables
- Add PDF generation endpoints for single and batch label printing
- Copy pdf_generator.py from original app with full label formatting (80mm x 105mm)
- Fix data response handling to correctly access data.orders from API endpoints
- Synchronize table text sizes across both print pages
- Remove help buttons from print pages
- Database column rename: data_livrara → data_livrare for consistency
- Update routes to use correct database column names
- Add 7 test orders to database (4 unprinted, 3 printed)
- Implement QZ Tray integration with PDF fallback for label printing
- All CSS uses theme variables for dark/light mode synchronization
- Commented out floating help button HTML in print_module.html and print_lost_labels.html
- Commented out floating help button CSS in both templates
- Help page functionality not implemented yet, will be added in future updates
- Allows templates to render without 500 errors
- Created labels module with complete structure in app/modules/labels/
- Implemented print_module.py with database functions:
* get_unprinted_orders_data() - Retrieve unprinted orders from database
* get_printed_orders_data() - Retrieve printed orders from database
* update_order_printed_status() - Mark orders as printed
* search_orders_by_cp_code() - Search orders by production code
- Created routes.py with Flask Blueprint and API endpoints:
* GET /labels/ - Module home page with feature launchers
* GET /labels/print-module - Main label printing interface
* GET /labels/print-lost-labels - Lost label reprinting interface
* GET /labels/api/unprinted-orders - API for unprinted orders
* GET /labels/api/printed-orders - API for printed orders
* POST /labels/api/search-orders - Search orders API
* POST /labels/api/update-printed-status/<id> - Update status API
- Migrated HTML templates from legacy app with theme support:
* print_module.html - Thermal label printing with QZ Tray integration
* print_lost_labels.html - Lost label search and reprint interface
* Added comprehensive CSS variables for dark/light mode theming
* Preserved all original JavaScript functionality for printing
- Created index.html module home page with feature launchers
- Registered labels blueprint in app/__init__.py with /labels prefix
- Added 'Label Printing' module card to dashboard with print icon
All functionality preserved from original implementation:
- QZ Tray thermal printer integration
- JsBarcode barcode generation (horizontal + vertical)
- PDF export fallback
- Session-based authentication for all routes
- Database integration with proper error handling
