Lager Guru v3.7.0

Release date: 2025-01-28
Git tag: v3.7.0
Branch: feature/werkstatt-asset-module

🔥 Summary

This release introduces the Werkstatt & Asset Management module, a comprehensive enterprise-grade asset and storage unit tracking system. Based on Tool Pro concepts and adapted for Lager Guru's multi-tenant architecture, this module provides full configurability with no hardcoded domain names.

✨ Added

Werkstatt & Asset Management Module (Enterprise Edition)

• Complete Asset Management: Full CRUD operations for assets (tools, machines, devices, parts)
• Storage Unit Management: Manage storage locations (drawers, cabinets, shelves, lockers)
• Configuration UI: Dedicated interface for managing asset types, storage unit types, and conditions
• Asset Checkout/Return: Track asset usage with checkout and return functionality
• Usage History: Complete audit trail of asset usage
• QR/Barcode Scanning: Support for QR code and barcode scanning
• Maintenance Integration: Integration with existing Maintenance module
• Safety Integration: Integration with Safety module for incidents and training

Database Schema

• 7 New Tables:
  • asset_types - Configurable asset categories
  • storage_unit_types - Configurable storage types
  • asset_conditions - Configurable condition states
  • storage_units - Physical storage locations
  • assets - Asset inventory
  • asset_usage_logs - Usage tracking
  • asset_maintenance_links - Maintenance integration
• RLS Policies: Full Row-Level Security for tenant isolation
• Audit Fields: Created/updated timestamps on all tables
• Indexes: Optimized indexes for performance

UI Components

• AssetList: Complete asset management interface
• StorageUnitList: Storage unit management interface
• AssetUsageControls: Checkout/return functionality
• WerkstattConfig: Configuration management for types and conditions
• AssetScanner: QR/barcode scanning interface

Navigation & Integration

• New Navigation Section: "Werkstatt & Assets" in admin panel
• Edition-Based Access: Available only for Enterprise edition tenants
• Role-Based Access: Admin and worker roles supported
• Module Access Control: Integrated with edition resolver system

🔧 Improved

Form Handling

• Controlled Components: Fixed Select component issues with proper controlled state
• Loading States: Added loading indicators for better UX
• Empty States: Clear messages when no data is available
• Error Handling: Improved error messages and validation

Internationalization

• Translations: Added translations for Werkstatt module (DE, EN, BG)
• Consistent Naming: Consistent terminology across all languages
• UI Labels: All UI elements properly translated

Code Quality

• Type Safety: Full TypeScript types for all entities
• API Functions: Comprehensive API functions for all operations
• Error Handling: Proper error handling throughout
• Code Organization: Well-structured component hierarchy

🐛 Fixed

• Select Component Issues: Fixed empty string values causing Radix UI errors
• Form State Management: Fixed form state issues with controlled components
• Translation Keys: Fixed missing translation keys for Werkstatt module
• Default Exports: Fixed React.lazy import issues with default exports
• Navigation Visibility: Fixed module visibility in admin panel
• Type Conversions: Fixed type conversion issues in Select components

🔒 Security

• RLS Policies: All tables protected with Row-Level Security
• Tenant Isolation: Full tenant isolation maintained
• Access Control: Role-based access control implemented
• Audit Trail: Complete audit trail for all operations

⚙ Migration Notes

Required Migration

Run the migration file: supabase/migrations/20250128000000_werkstatt_asset_module.sql

No Breaking Changes

• All changes are additive
• Existing functionality remains unchanged
• Backward compatible with all existing data
• No API contract changes

Initial Setup

1. Run the database migration
2. Access Werkstatt module (Enterprise edition only)
3. Create asset types, storage unit types, and conditions via Configuration UI
4. Start creating assets and storage units

📦 Download / View Release

View Release on GitHub

Related Documentation

• Werkstatt & Asset Management Guide
• Enterprise Modules
• Edition System
• Database Migrations