0.10.1.10-beta

[sassanix]

📦 Release 0.10.1.10 – Warranty Claims, Document URLs, and DB Port Support

This release introduces a complete warranty claims tracking system, adds flexible URL support for documents and invoices, and provides custom database port configuration for deployment flexibility. Users now have more control over claims, document management, and database connectivity.

📝 Warranty Claims Tracking System

✅ End-to-End Claims Management

• Added new warranty_claims table with dates, statuses, claim numbers, descriptions, and resolutions.
• Implemented full REST API with authentication and authorization.
• Introduced claims modal UI with intuitive claim workflows and status badges.
• Defined claim lifecycle statuses: Submitted, In Progress, Approved, Denied, Resolved, Cancelled.
• Added validation, error handling, and database constraints to ensure data integrity.

✅ Result: Users can now create, update, and track warranty claims through a structured workflow with clear lifecycle visibility.

🔗 URL Support for Documents and Invoices

✅ Dual Document Handling

• Added invoice_url, manual_url, and other_document_url columns in migration 043.
• Enhanced Add/Edit warranty modals to accept both file uploads and URLs with icons and responsive design.
• Displayed URLs alongside uploaded files on warranty cards, opening links in new tabs.
• Updated Add Warranty summary to intelligently show file names or URLs.
• Extended backend API and JavaScript logic with robust null safety checks.

✅ Result: Users can attach files, external URLs, or both, ensuring maximum flexibility for document storage and access.

⚙️ Database Port Configuration

✅ Flexible Deployment Options

• Added DB_PORT environment variable support with fallback to 5432.
• Updated backend handlers, Docker configs, and env.example for consistent behavior.

✅ Result: Deployments now support non-standard PostgreSQL ports and multi-instance setups without breaking compatibility.

Modified Files:

• backend/migrations/043_add_document_urls_to_warranties.sql
• backend/migrations/044_create_warranty_claims_table.sql
• backend/warranties_routes.py
• backend/db_handler.py
• backend/fix_permissions.py
• frontend/index.html
• frontend/status.html
• frontend/script.js
• frontend/style.css
• docker-compose.yml
• Docker/docker-compose.yml
• env.example

This update delivers powerful new warranty workflows, flexible document management, and enhanced deployment configuration, paving the way for smoother operations across all environments. 🚀

Screenshots:

---

This discussion was created from the release 0.10.1.10-beta.