product_lot_sequence_per_product/CHANGELOG.md

# Changelog

All notable changes to the Product Lot Sequence Per Product module will be documented in this file.

## [1.1.1] - 2024-11-20

### Fixed
- **Date Format Code Support**
  - Fixed batch sequence allocation to properly handle date format codes like `%(y)s`, `%(month)s`, `%(day)s`
  - Updated `_allocate_sequence_batch()` method to interpolate date codes before formatting
  - Fixed `_compute_next_serial()` to show correct preview with date codes
  - Added comprehensive test suite for date format codes

### Changed
- **models/stock_lot.py**
  - Enhanced `_allocate_sequence_batch()` with date interpolation logic
  
- **models/stock_move.py**
  - Enhanced `_allocate_sequence_batch()` with date interpolation logic
  
- **models/product_template.py**
  - Enhanced `_compute_next_serial()` to properly display date-formatted sequences

### Added
- **tests/test_date_format.py** (new)
  - Test for `%(y)s%(month)s%(day)s` format
  - Test for full year `%(year)s` format
  - Test for batch generation with date codes
  - Test for complex date formats
  - Test for date codes with suffix
  - Test for all available date format codes

### Removed
- **Inventory Adjustment Auto-Generation** (rolled back)
  - Removed automatic lot generation in physical inventory adjustments
  - Removed `models/stock_quant.py`
  - Removed `views/stock_quant_views.xml`
  - Feature was causing issues in production workflow

## [1.1.0] - 2024-11-20

### Added
- **Performance Optimizations**
  - Batch sequence allocation using PostgreSQL's `generate_series()` function
  - Batch lot record creation for efficient database operations
  - Smart threshold detection (automatically optimizes for quantities > 10)
  - Product grouping for mixed-product batch operations
  - Performance logging for monitoring and debugging

- **Auto-Generation in Inventory Adjustments**
  - Automatic lot/serial number generation during physical inventory counts
  - Support for both lot-tracked and serial-tracked products
  - Batch optimization for large quantity adjustments
  - Seamless integration with existing inventory adjustment workflow

- **Test Suites**
  - Comprehensive performance test suite (`tests/test_performance.py`)
  - Inventory adjustment test suite (`tests/test_inventory_adjustment.py`)
  - Tests for small, medium, large, and very large batches
  - Edge case and integration tests

- **Documentation**
  - PERFORMANCE_OPTIMIZATION.md - Detailed technical documentation
  - INSTALLATION.md - Installation and upgrade guide
  - QUICK_START.md - Quick reference for users
  - Enhanced README.md with performance information

### Changed
- **models/stock_lot.py**
  - Modified `create()` method to support batch processing
  - Added `_allocate_sequence_batch()` method for efficient sequence allocation
  - Added product grouping logic for mixed-product operations
  - Added performance logging

- **models/stock_move.py**
  - Modified `_create_lot_ids_from_move_line_vals()` for batch lot creation
  - Modified `action_generate_lot_line_vals()` to use batch allocation
  - Added `_allocate_sequence_batch()` method
  - Added smart threshold detection
  - Added performance logging

- **models/stock_quant.py**
  - Modified `_get_inventory_move_values()` to support auto-generation
  - Added `action_apply_inventory()` override for batch generation
  - Added support for serial-tracked products with quantity > 1
  - Added performance logging

- **models/__init__.py**
  - Added import for `stock_quant` module

- **__manifest__.py**
  - Updated version to 1.1.0
  - Added detailed description
  - Added category and summary
  - Added license information

### Performance Improvements
- **8-10x speedup** for large batch operations (500+ units)
- **100x faster** sequence allocation (single query vs N queries)
- **10x faster** lot creation (batch operation vs individual creates)
- Tested and optimized for up to 500,000 units

### Backward Compatibility
- ✓ Fully backward compatible with version 1.0
- ✓ No breaking changes
- ✓ No data migration required
- ✓ Existing functionality preserved
- ✓ Manual lot entry still works

## [1.0.0] - 2024-XX-XX

### Added
- Initial release
- Per-product lot/serial number sequence configuration
- Custom sequence prefix configuration on product form
- Automatic lot generation in incoming receipts
- Automatic lot generation in manufacturing orders
- Manual lot generation support
- Fallback to global sequence when no custom sequence configured
- UI enhancements to avoid "0" lot numbers
- Integration with Inventory tab on product form

### Features
- `lot_sequence_id` field on `product.template`
- `serial_prefix_format` computed field for easy configuration
- `next_serial` computed field to show next lot number
- Override of `stock.lot.create()` for custom sequence usage
- Override of `stock.move` methods for UI integration
- Override of `stock.move.line._prepare_new_lot_vals()` for normalization
- Override of `mrp.production._prepare_stock_lot_values()` for manufacturing

### Dependencies
- stock (Odoo core)
- mrp (Odoo core)

### Documentation
- README.md with feature description and usage instructions
- Technical details and configuration guide

---

## Version Numbering

This project follows [Semantic Versioning](https://semver.org/):
- MAJOR version for incompatible API changes
- MINOR version for new functionality in a backward compatible manner
- PATCH version for backward compatible bug fixes

## Upgrade Path

### From 1.0.0 to 1.1.0
1. Backup database
2. Update module files
3. Upgrade module via Odoo UI or CLI
4. No configuration changes required
5. Test with small batch to verify
6. Performance improvements are automatic

### Future Versions
- 1.1.x: Bug fixes and minor improvements
- 1.2.x: Additional features (async generation, caching, etc.)
- 2.0.x: Major changes (if any breaking changes needed)

## Support

For issues, questions, or contributions:
1. Check documentation (README.md, QUICK_START.md, PERFORMANCE_OPTIMIZATION.md)
2. Review test suites for usage examples
3. Check logs for detailed error information
4. Verify database and Odoo configuration

## License

LGPL-3 - See LICENSE file for details

## Contributors

- Initial development and optimization
- Performance testing and benchmarking
- Documentation and test suite creation

## Acknowledgments

- Odoo community for the base framework
- PostgreSQL for powerful database features
- Users who provided feedback and testing