Mikhail Chusavitin
5f8aec456b
Unified Quote Journal (parts_log) v3
...
- New unified append-only quote log table parts_log replaces three
separate log tables (stock_log, partnumber_log_competitors, lot_log)
- Migrations 042-049: extend supplier, create parts_log/import_formats/
ignore_rules, rework qt_lot_metadata composite PK, add lead_time_weeks
to pricelist_items, backfill data, migrate ignore rules
- New services: PartsLogBackfillService, ImportFormatService,
UnifiedImportService; new world pricelist type (all supplier types)
- qt_lot_metadata PK changed to (lot_name, pricelist_type); all queries
now filter WHERE pricelist_type='estimate'
- Fix pre-existing bug: qt_component_usage_stats column names
quotes_last30d/quotes_last7d (no underscore) — added explicit gorm tags
- Bible: full table inventory, baseline schema snapshot, updated pricelist/
data-rules/api/history/architecture docs
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com >
2026-03-21 17:25:54 +03:00
Mikhail Chusavitin
f73e3d144d
Vendor mapping: wildcard ignore patterns, bulk CSV import, multi-lot qty
...
- Add glob pattern support (* and ?) for ignore rules stored in
qt_vendor_partnumber_seen (is_pattern flag, migration 041)
- Pattern matching applied in stock/competitor import, partnumber book
snapshot, and vendor mappings list (Go-side via NormalizeKey)
- BulkUpsertMappings: replace N+1 loop with two batch SQL upserts,
validating all lots in a single query (~1500 queries → 3-4)
- CSV import: multi-lot per PN via repeated rows, optional qty column
- CSV export: updated column format vendor;partnumber;lot_name;qty;description;ignore;notes
- UI: ignore patterns section with add/delete, import progress feedback
- Update bible-local/vendor-mapping.md with new CSV format
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com >
2026-03-19 09:41:48 +03:00
Mikhail Chusavitin
3f26a2935a
Refactor vendor mappings to canonical PN catalog
2026-03-07 23:11:42 +03:00
Mikhail Chusavitin
08de9006ef
Refactor partnumber book catalog storage
2026-03-07 22:10:05 +03:00
Mikhail Chusavitin
b2b2f4774c
Refactor scheduler and settings UI
2026-03-07 21:10:20 +03:00
a4457a0a28
Add partnumber book snapshots for QuoteForge integration
...
- Migrations 026-028: qt_partnumber_books + qt_partnumber_book_items
tables; is_primary_pn on lot_partnumbers; version VARCHAR(30);
description VARCHAR(10000) on items (required by QuoteForge sync)
- Service: CreateSnapshot expands bundles, filters empty lot_name and
ignored PNs, copies description, activates new book atomically,
applies GFS retention (7d/5w/12m/10y) with explicit item deletion
- Task type TaskTypePartnumberBookCreate; handlers ListPartnumberBooks
and CreatePartnumberBook; routes GET/POST /api/admin/pricing/partnumber-books
- UI: snapshot list + "Создать снапшот сопоставлений" button with
progress polling on /vendor-mappings page
- Bible: history, api, background-tasks, vendor-mapping updated
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com >
2026-02-21 22:16:16 +03:00
Mikhail Chusavitin
60563509e4
Deduplicate vendor seen by partnumber and fix vendor mappings list
2026-02-20 15:37:41 +03:00
Mikhail Chusavitin
c22328bf03
Implement global vendor mappings with bundle support and seen-based ignore
2026-02-18 19:54:07 +03:00
20309d1f0e
Fork from QuoteForge → PriceForge
...
Renamed module path git.mchus.pro/mchus/quoteforge → git.mchus.pro/mchus/priceforge,
renamed package quoteforge → priceforge, moved binary from cmd/qfs to cmd/pfs.
2026-02-07 21:42:26 +03:00
