Oliver/ac-tool
1
0
Fork 0
Code Issues Pull requests Projects Releases Packages Wiki Activity Actions
36 commits 1 branch 0 tags 796 KiB
Commit graph

3 commits

Author SHA1 Message Date
Vadym Samoilenko
8da149b84e Migrate storage from JSON files to PostgreSQL (asyncpg) 
- Add asyncpg connection pool (db/pool.py) with JSONB codec registration
- Add schema.sql with users, clients, dropdown_categories, export_templates, sheets tables
- Add migrate_json.py one-time migration script for existing JSON data
- Rewrite user_store, sheets/manager, api/clients, api/dropdowns, api/export as async DB-backed
- Update all callers (auth, sheets, admin, ai_command, export) to await async functions
- Add postgres:16-alpine service to docker-compose with named volume and health check
- App container depends_on postgres; DATABASE_URL injected via env
- Schema applied automatically on startup; global categories seeded if DB is empty

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
 2026-03-23 19:51:37 +00:00
Vadym Samoilenko
6c93915768 Add custom CSV export template (per-client, per-user, global) 
- Backend: export template system with priority chain:
  client template > user template > global template > built-in default
- New /api/export/template endpoints for any logged-in user (GET/POST/DELETE)
- Admin endpoints for global and per-client export templates
- detect_csv_template() auto-maps CSV headers to internal fields
- Frontend: ExportTemplateEditor component (upload CSV → map columns → save)
- AdminClientsPage: export template section per client card
- SheetPage: ⚙ button next to "Export CSV" opens inline template editor

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
 2026-03-23 19:29:22 +00:00
Vadym Samoilenko
72c50b2c92 Initial commit — AC Tool unified application 
Merges ac-helper (PHP Activation Calendar) and brief-extractor (Python AI)
into a single Docker app with React/TypeScript frontend.

Features:
- Brief upload → AI extraction → review → Activation Calendar import
- Handsontable v17 spreadsheet with dependent dropdowns (148 categories)
- AI natural language commands via Gemini (YOLO mode, voice input)
- Azure AD MSAL SPA PKCE authentication, user roles (user/admin)
- CSV Activation Calendar export
- Real-time WebSocket job progress
- Admin: user management, dropdown Excel upload
- Multi-stage Dockerfile, docker-compose, nginx proxy instructions

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
 2026-03-23 13:24:46 +00:00