mchus/PriceForge
1
0
Fork 0
Code Issues 4 Pull Requests Actions Packages Releases 2 Activity
Files
v0.4.0
PriceForge/migrations
History
Mikhail Chusavitin c53c484bde Replace competitor discount with price_uplift; stock pricelist detail UI 
- Drop `expected_discount_pct`, add `price_uplift DECIMAL(8,4) DEFAULT 1.3`
  to `qt_competitors` (migration 040); formula: effective_price = price / uplift
- Extend `LoadLotMetrics` to return per-PN qty map (`pnQtysByLot`)
- Add virtual fields `CompetitorNames`, `PriceSpreadPct`, `PartnumberQtys`
  to `PricelistItem`; populate via `enrichWarehouseItems` / `enrichCompetitorItems`
- Competitor quotes filtered to qty > 0 before lot resolution
- New "stock layout" on pricelist detail page for warehouse/competitor:
  Partnumbers column (PN + qty, only qty>0), Поставщик column, no Настройки/Доступно
- Spread badge ±N% shown next to price for competitor rows
- Bible updated: pricelist.md, history.md

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-03-13 12:58:41 +03:00
..
001_add_lot_category.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
002_add_custom_price.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
003_add_is_hidden.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
004_add_price_updated_at.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
005_add_owner_username.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
006_add_local_configuration_versions.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
007_detach_configurations_from_qt_users.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
008_add_app_version_to_configurations.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
009_add_projects.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
010_add_pricelist_sync_status.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
010_add_pricelist_to_configurations.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
011_add_app_version_to_pricelist_sync_status.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
012_add_project_tracker_url.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
013_add_pricelist_source.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
014_add_stock_log.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
015_add_lot_partnumbers.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
016_add_price_level_pricelist_bindings.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
017_update_lot_partnumbers_for_placeholders.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
018_add_stock_ignore_rules.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
019_rename_stock_log_lot_to_partnumber.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
020_add_only_in_stock_to_configurations.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
021_add_pricelist_items_pricelist_lot_index.sql
Fork from QuoteForge → PriceForge
2026-02-07 21:42:26 +03:00
022_add_lot_category_to_pricelist_items.sql
fix: потоковая отправка прогресса создания прайслиста и исправление маппинга колонки категории
2026-02-10 15:17:16 +03:00
023_vendor_partnumber_global_mapping.sql
Implement global vendor mappings with bundle support and seen-based ignore
2026-02-18 19:54:07 +03:00
024_backfill_vendor_seen_from_stock_and_ignore.sql
Implement global vendor mappings with bundle support and seen-based ignore
2026-02-18 19:54:07 +03:00
025_dedup_vendor_seen_by_partnumber.sql
Deduplicate vendor seen by partnumber and fix vendor mappings list
2026-02-20 15:37:41 +03:00
026_add_partnumber_books.sql
Add partnumber book snapshots for QuoteForge integration
2026-02-21 22:16:16 +03:00
027_fix_partnumber_books_version_length.sql
Add partnumber book snapshots for QuoteForge integration
2026-02-21 22:16:16 +03:00
028_add_description_to_partnumber_book_items.sql
Add partnumber book snapshots for QuoteForge integration
2026-02-21 22:16:16 +03:00
029_drop_unused_qt_bom.sql
Refactor scheduler and settings UI
2026-03-07 21:10:20 +03:00
030_add_scheduler_runs.sql
Refactor scheduler and settings UI
2026-03-07 21:10:20 +03:00
031_drop_is_primary_pn.sql
Refactor vendor mappings to canonical PN catalog
2026-03-07 23:11:42 +03:00
032_drop_legacy_vendor_mapping_tables.sql
Refactor vendor mappings to canonical PN catalog
2026-03-07 23:11:42 +03:00
033_add_competitors.sql
Modularize Go files, extract JS to static, implement competitor pricelists
2026-03-13 07:44:10 +03:00
034_add_qty_to_competitor_quotes.sql
Modularize Go files, extract JS to static, implement competitor pricelists
2026-03-13 07:44:10 +03:00
035_competitor_quotes_lot_nullable.sql
Modularize Go files, extract JS to static, implement competitor pricelists
2026-03-13 07:44:10 +03:00
036_competitor_quotes_align_columns.sql
Modularize Go files, extract JS to static, implement competitor pricelists
2026-03-13 07:44:10 +03:00
037_add_currency_to_competitors.sql
Modularize Go files, extract JS to static, implement competitor pricelists
2026-03-13 07:44:10 +03:00
038_add_description_vendor_to_competitor_quotes.sql
Modularize Go files, extract JS to static, implement competitor pricelists
2026-03-13 07:44:10 +03:00
039_add_price_loccur_to_competitor_quotes.sql
Modularize Go files, extract JS to static, implement competitor pricelists
2026-03-13 07:44:10 +03:00
040_competitor_uplift.sql
Replace competitor discount with price_uplift; stock pricelist detail UI
2026-03-13 12:58:41 +03:00