- 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>
- Replace Tailwind CDN (~350KB) with purged local CSS (~22KB)
- Replace htmx unpkg CDN with local static file
- Add Gzip middleware (standard library, sync.Pool) for all responses
- Add Cache-Control: public, max-age=3600 for /static/* assets
- Reduce status polling interval from 5s to 30s
- Add scripts/build-css.sh for CSS regeneration after template changes
- Document in bible-local/operations.md and history.md
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
- Add GetLatestQuotesAllCompetitors() repo method: latest quote per
(competitor_id, partnumber) across all active competitors
- Add RebuildPricelist() service method: loads all quotes, applies each
competitor's discount, aggregates with weighted_median per lot,
creates single combined competitor pricelist
- Add POST /api/competitors/pricelist handler + route
- JS: "Создать прайслист" on competitor tab calls new endpoint instead
of the generic one that required explicit items
This allows recreating the competitor pricelist after new lot mappings
are added, without requiring a new file upload.
Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
Optimize task retention from 5 minutes to 30 seconds to reduce polling overhead since toast notifications are shown only once. Add conditional warehouse pricelist creation via checkbox. Fix category storage in warehouse pricelists to properly load from lot table. Replace SSE with task polling for all long operations. Add comprehensive logging for debugging while minimizing noise from polling endpoints.
Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
- Create new /lot page with two tabs:
1. LOT: component management (formerly in /admin/pricing)
2. Сопоставления: partnumber ↔ LOT mappings (formerly in Warehouse tab)
- Remove LOT tab from Pricing Admin page
- Remove stock mappings section from Warehouse tab
- Update main menu: LOT link now points to /lot
- Default tab in Pricing Admin changed to Estimate
- Add Lot() handler in web.go
- Add /lot route in main.go
Co-Authored-By: Claude Haiku 4.5 <noreply@anthropic.com>
- Added background task manager with goroutine execution and panic recovery
- Replaced SSE streaming with background task execution for:
* Price recalculation (RecalculateAll)
* Stock import (ImportStockLog)
* Pricelist creation (CreateWithProgress)
- Implemented unified polling for task status and DB connection in frontend
- Added task indicator in top bar showing running tasks count
- Added toast notifications for task completion/error
- Tasks automatically cleaned up after 10 minutes
- Tasks show progress (0-100%) with descriptive messages
- Updated handler constructors to receive task manager
- Added API endpoints for task status (/api/tasks, /api/tasks/:id)
Fixes issue with SSE disconnection on slow connections during long-running operations
- Add CSV export functionality for pricelists with download button
- Export includes all pricelist items with proper UTF-8 encoding
- Support both warehouse and estimate pricelist sources
- Remove description column from admin pricing tables
- Show description as tooltip on row hover instead
- Improve table layout by removing redundant column
Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
- Add LOT creation functionality in pricing admin
- New API endpoint POST /api/admin/pricing/lots
- Modal form for creating new LOT with auto-category detection
- Creates entries in both lot and qt_lot_metadata tables
- Implement auto-save for stock mappings
- Auto-save on change for partnumber → LOT mappings
- Visual feedback (orange during save, green on success, red on error)
- Works in both main mappings table and import suggestions
- Improve stock import suggestions UI
- Remove "Причина" column from suggestions table
- Increase LOT and Partnumber column widths to 33% each
- Better visual balance in the table layout
- Disable automatic warehouse pricelist creation on stock_log import
- Import now completes at 100% after stock_log update
- Manual pricelist creation available via UI when needed
- Faster import process without auto-generation overhead
Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
