nis2-agile/docs/sql
DevEnv nis2-agile 1382530189 [FEAT] Sistema Segnalazioni & Risoluzione AI (feedback)
Adattato da alltax.it — il sistema più maturo testato con utenti reali.

Backend:
- FeedbackController: 6 endpoint (submit, mine, list, show, update, resolve)
- FeedbackService: createReport + classifyWithAI + broadcastResolution
- AIService::classifyFeedback() — 10s timeout, 500 token, JSON puro
- EmailService::sendFeedbackResolved() — broadcast email org
- DB migration 014: tabella feedback_reports

Frontend:
- feedback.js: FAB rosso #EF4444, modal 2 fasi (form → AI → password gate)
- Tab "Le mie segnalazioni" con badge status
- Auto-init su tutte le pagine autenticate (common.js::checkAuth)
- api.js: 6 metodi client; style.css: stili completi

Worker:
- scripts/feedback-worker.php: cron ogni 30 min
  → docker exec nis2-agile-devenv + Claude Code CLI
  → risoluzione autonoma con POST /api/feedback/{id}/resolve

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
2026-03-10 08:51:52 +01:00
..
001_initial_schema.sql [CORE] Initial project scaffold - NIS2 Agile Compliance Platform 2026-02-17 17:50:18 +01:00
002_email_log.sql [FEAT] Add EmailService, RateLimitService, ReportService + integrations 2026-02-17 19:12:46 +01:00
003_voluntary_compliance.sql [FEAT] Visura auto-fill, adesione volontaria, modulo NCR/CAPA 2026-02-18 08:12:57 +01:00
004_ncr_capa.sql [FEAT] Visura auto-fill, adesione volontaria, modulo NCR/CAPA 2026-02-18 08:12:57 +01:00
005_consultant_support.sql [FEAT] Ruolo Consulente + Wizard Registrazione v2 2026-02-20 08:53:30 +01:00
006_security_improvements.sql [FIX] Migration 006: usa stored procedure per indici condizionali 2026-02-20 12:08:44 +01:00
007_services_api.sql [FIX] Migration SQL: INT NOT NULL per FK verso organizations/users (signed) 2026-03-07 13:22:08 +01:00
008_whistleblowing.sql [FIX] Migration SQL: INT NOT NULL per FK verso organizations/users (signed) 2026-03-07 13:22:08 +01:00
009_normative_updates.sql [FIX] Migration SQL: INT NOT NULL per FK verso organizations/users (signed) 2026-03-07 13:22:08 +01:00
010_audit_hash_chain.sql [FEAT] Simulazioni Demo + Audit Trail Certificato SHA-256 2026-03-07 13:56:53 +01:00
011_provisioning.sql [INTEG] Provisioning B2B automatico + fix JWT helpers 2026-03-07 15:02:11 +01:00
012_invites.sql [INVITE] Sistema inviti/licenze B2B + provisioning con invite_token 2026-03-07 15:22:25 +01:00
013_license_ext.sql [DB] Fix migration 013: MySQL 8.0 compat + script deploy idempotente 2026-03-07 16:48:53 +01:00
014_feedback.sql [FEAT] Sistema Segnalazioni & Risoluzione AI (feedback) 2026-03-10 08:51:52 +01:00
deploy_013.sh [DB] Fix migration 013: MySQL 8.0 compat + script deploy idempotente 2026-03-07 16:48:53 +01:00
reset-demo.sql [FIX] reset-demo.sql: gestione trigger audit_log + drop/recreate 2026-03-09 09:51:40 +01:00