]> gitweb.erp-flowers.ru Git - erp24_rep/yii-erp24/.git/commit
projects / erp24_rep / yii-erp24 / .git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 3c68722) | patch
feat(ERP-33): заменить StockHistory (snapshot) на StockState (SCD-2)
authorAleksey Filippov <Aleksey.Filippov@erp-flowers.ru>
Tue, 24 Mar 2026 09:48:40 +0000 (12:48 +0300)
committerAleksey Filippov <Aleksey.Filippov@erp-flowers.ru>
Tue, 24 Mar 2026 09:48:40 +0000 (12:48 +0300)
commit8e0b08fb917460ea9259d9c692ca7a6928d8da0c
tree6fe88500a5aff3ffaad5a158a008fe64685af329tree | snapshot
parent3c68722b2c6446facf1f3c128abaed72db9f4791commit | diff
feat(ERP-33): заменить StockHistory (snapshot) на StockState (SCD-2)

Полная переделка подхода хранения остатков:
- StockHistory (полные снимки 11400 INSERT/запуск) → StockState (SCD-2, 2 SQL)
- Без партиций — одна таблица с valid_from/valid_to (TIMESTAMP)
- valid_to = '2100-01-01 00:00:00' для активных, закрытие на секунду раньше
- is_active boolean для быстрой фильтрации
- batch_ts — единый timestamp пакета на запуск
- Экономия ~78% объёма (660 MB vs 3 GB за 2 года)
- 10 unit-тестов, 29 assertions
12 files changed:
erp24/commands/StockHistoryController.php [deleted file] blob | history
erp24/commands/StockStateController.php [new file with mode: 0644] blob
erp24/migrations/m260221_100000_create_stock_history_table.php [deleted file] blob | history
erp24/migrations/m260221_100000_create_stock_state_table.php [new file with mode: 0644] blob
erp24/records/StockHistory.php [deleted file] blob | history
erp24/records/StockState.php [new file with mode: 0644] blob
erp24/services/CollectResult.php diff | blob | history
erp24/services/DqResult.php diff | blob | history
erp24/services/StockHistoryService.php [deleted file] blob | history
erp24/services/StockStateService.php [new file with mode: 0644] blob
erp24/tests/unit/services/StockHistoryServiceTest.php [deleted file] blob | history
erp24/tests/unit/services/StockStateServiceTest.php [new file with mode: 0644] blob
Unnamed repository; edit this file 'description' to name the repository.