feat: reporting dashboard — case stats, deadline compliance, workload, billing (P1)

Backend: - ReportingService with aggregation queries (CTEs, FILTER clauses) - 4 API endpoints: /api/reports/{cases,deadlines,workload,billing} - Date range filtering via ?from=&to= query params Frontend: - /berichte page with 4 tabs: Akten, Fristen, Auslastung, Abrechnung - recharts: bar/pie/line charts for all report types - Date range picker, CSV export, print-friendly view - Sidebar nav entry with BarChart3 icon Also resolves merge conflicts between role-based, notification, and audit trail branches, and adds missing TS types (AuditLogResponse, Notification, NotificationPreferences).
2026-03-30 11:24:45 +02:00
24 changed files with 1788 additions and 1627 deletions
--- a/backend/cmd/server/main.go
+++ b/backend/cmd/server/main.go
@@ -5,9 +5,6 @@ import (
 	"net/http"
 	"os"

-	"github.com/jmoiron/sqlx"
-	_ "github.com/lib/pq"
-
 	"mgit.msbls.de/m/KanzlAI-mGMT/internal/auth"
 	"mgit.msbls.de/m/KanzlAI-mGMT/internal/config"
 	"mgit.msbls.de/m/KanzlAI-mGMT/internal/db"
@@ -34,21 +31,6 @@ func main() {

 	authMW := auth.NewMiddleware(cfg.SupabaseJWTSecret, database)

-	// Optional: connect to youpc.org database for similar case finder
-	var youpcDB *sqlx.DB
-	if cfg.YouPCDatabaseURL != "" {
-		youpcDB, err = sqlx.Connect("postgres", cfg.YouPCDatabaseURL)
-		if err != nil {
-			slog.Warn("failed to connect to youpc.org database — similar case finder disabled", "error", err)
-			youpcDB = nil
-		} else {
-			youpcDB.SetMaxOpenConns(5)
-			youpcDB.SetMaxIdleConns(2)
-			defer youpcDB.Close()
-			slog.Info("connected to youpc.org database for similar case finder")
-		}
-	}
-
 	// Start CalDAV sync service
 	calDAVSvc := services.NewCalDAVService(database)
 	calDAVSvc.Start()
@@ -59,7 +41,7 @@ func main() {
 	notifSvc.Start()
 	defer notifSvc.Stop()

-	handler := router.New(database, authMW, cfg, calDAVSvc, notifSvc, youpcDB)
+	handler := router.New(database, authMW, cfg, calDAVSvc, notifSvc)

 	slog.Info("starting KanzlAI API server", "port", cfg.Port)
 	if err := http.ListenAndServe(":"+cfg.Port, handler); err != nil {
--- a/backend/internal/auth/middleware.go
+++ b/backend/internal/auth/middleware.go
@@ -35,6 +35,8 @@ func (m *Middleware) RequireAuth(next http.Handler) http.Handler {
 		}

 		ctx := ContextWithUserID(r.Context(), userID)
+		// Tenant resolution is handled by TenantResolver middleware for scoped routes.
+		// Tenant management routes handle their own access control.

 		// Capture IP and user-agent for audit logging
 		ip := r.Header.Get("X-Forwarded-For")
@@ -43,8 +45,6 @@ func (m *Middleware) RequireAuth(next http.Handler) http.Handler {
 		}
 		ctx = ContextWithRequestInfo(ctx, ip, r.UserAgent())

-		// Tenant resolution is handled by TenantResolver middleware for scoped routes.
-		// Tenant management routes handle their own access control.
 		next.ServeHTTP(w, r.WithContext(ctx))
 	})
 }
--- a/backend/internal/auth/tenant_resolver.go
+++ b/backend/internal/auth/tenant_resolver.go
@@ -56,6 +56,7 @@ func (tr *TenantResolver) Resolve(next http.Handler) http.Handler {
 			}

 			tenantID = parsed
+			// Override the role from middleware with the correct one for this tenant
 			r = r.WithContext(ContextWithUserRole(r.Context(), role))
 		} else {
 			// Default to user's first tenant (role already set by middleware)
--- a/backend/internal/auth/tenant_resolver_test.go
+++ b/backend/internal/auth/tenant_resolver_test.go
@@ -15,7 +15,6 @@ type mockTenantLookup struct {
 	hasAccess bool
 	accessErr error
 	role      string
-	noAccess  bool // when true, GetUserRole returns ""
 }

 func (m *mockTenantLookup) FirstTenantForUser(ctx context.Context, userID uuid.UUID) (*uuid.UUID, error) {
@@ -27,18 +26,18 @@ func (m *mockTenantLookup) VerifyAccess(ctx context.Context, userID, tenantID uu
 }

 func (m *mockTenantLookup) GetUserRole(ctx context.Context, userID, tenantID uuid.UUID) (string, error) {
-	if m.noAccess {
-		return "", m.err
-	}
 	if m.role != "" {
 		return m.role, m.err
 	}
-	return "associate", m.err
+	if m.hasAccess {
+		return "associate", m.err
+	}
+	return "", m.err
 }

 func TestTenantResolver_FromHeader(t *testing.T) {
 	tenantID := uuid.New()
-	tr := NewTenantResolver(&mockTenantLookup{role: "partner", hasAccess: true})
+	tr := NewTenantResolver(&mockTenantLookup{hasAccess: true, role: "partner"})

 	var gotTenantID uuid.UUID
 	next := http.HandlerFunc(func(w http.ResponseWriter, r *http.Request) {
@@ -67,7 +66,7 @@ func TestTenantResolver_FromHeader(t *testing.T) {

 func TestTenantResolver_FromHeader_NoAccess(t *testing.T) {
 	tenantID := uuid.New()
-	tr := NewTenantResolver(&mockTenantLookup{noAccess: true})
+	tr := NewTenantResolver(&mockTenantLookup{hasAccess: false})

 	next := http.HandlerFunc(func(w http.ResponseWriter, r *http.Request) {
 		t.Fatal("next should not be called")
--- a/backend/internal/config/config.go
+++ b/backend/internal/config/config.go
@@ -14,7 +14,6 @@ type Config struct {
 	SupabaseJWTSecret string
 	AnthropicAPIKey   string
 	FrontendOrigin    string
-	YouPCDatabaseURL  string // read-only connection to youpc.org Supabase for similar case finder
 }

 func Load() (*Config, error) {
@@ -27,7 +26,6 @@ func Load() (*Config, error) {
 		SupabaseJWTSecret: os.Getenv("SUPABASE_JWT_SECRET"),
 		AnthropicAPIKey:  os.Getenv("ANTHROPIC_API_KEY"),
 		FrontendOrigin:   getEnv("FRONTEND_ORIGIN", "https://kanzlai.msbls.de"),
-		YouPCDatabaseURL: os.Getenv("YOUPC_DATABASE_URL"),
 	}

 	if cfg.DatabaseURL == "" {
--- a/backend/internal/handlers/ai.go
+++ b/backend/internal/handlers/ai.go
@@ -5,8 +5,6 @@ import (
 	"io"
 	"net/http"

-	"github.com/google/uuid"
-
 	"mgit.msbls.de/m/KanzlAI-mGMT/internal/auth"
 	"mgit.msbls.de/m/KanzlAI-mGMT/internal/services"
 )
@@ -117,139 +115,3 @@ func (h *AIHandler) SummarizeCase(w http.ResponseWriter, r *http.Request) {
 		"summary": summary,
 	})
 }
-
-// DraftDocument handles POST /api/ai/draft-document
-// Accepts JSON {"case_id": "uuid", "template_type": "string", "instructions": "string", "language": "de|en|fr"}.
-func (h *AIHandler) DraftDocument(w http.ResponseWriter, r *http.Request) {
-	tenantID, ok := auth.TenantFromContext(r.Context())
-	if !ok {
-		writeError(w, http.StatusForbidden, "missing tenant")
-		return
-	}
-
-	var body struct {
-		CaseID       string `json:"case_id"`
-		TemplateType string `json:"template_type"`
-		Instructions string `json:"instructions"`
-		Language     string `json:"language"`
-	}
-	if err := json.NewDecoder(r.Body).Decode(&body); err != nil {
-		writeError(w, http.StatusBadRequest, "invalid request body")
-		return
-	}
-
-	if body.CaseID == "" {
-		writeError(w, http.StatusBadRequest, "case_id is required")
-		return
-	}
-	if body.TemplateType == "" {
-		writeError(w, http.StatusBadRequest, "template_type is required")
-		return
-	}
-
-	caseID, err := parseUUID(body.CaseID)
-	if err != nil {
-		writeError(w, http.StatusBadRequest, "invalid case_id")
-		return
-	}
-
-	if len(body.Instructions) > maxDescriptionLen {
-		writeError(w, http.StatusBadRequest, "instructions exceeds maximum length")
-		return
-	}
-
-	draft, err := h.ai.DraftDocument(r.Context(), tenantID, caseID, body.TemplateType, body.Instructions, body.Language)
-	if err != nil {
-		internalError(w, "AI document drafting failed", err)
-		return
-	}
-
-	writeJSON(w, http.StatusOK, draft)
-}
-
-// CaseStrategy handles POST /api/ai/case-strategy
-// Accepts JSON {"case_id": "uuid"}.
-func (h *AIHandler) CaseStrategy(w http.ResponseWriter, r *http.Request) {
-	tenantID, ok := auth.TenantFromContext(r.Context())
-	if !ok {
-		writeError(w, http.StatusForbidden, "missing tenant")
-		return
-	}
-
-	var body struct {
-		CaseID string `json:"case_id"`
-	}
-	if err := json.NewDecoder(r.Body).Decode(&body); err != nil {
-		writeError(w, http.StatusBadRequest, "invalid request body")
-		return
-	}
-
-	if body.CaseID == "" {
-		writeError(w, http.StatusBadRequest, "case_id is required")
-		return
-	}
-
-	caseID, err := parseUUID(body.CaseID)
-	if err != nil {
-		writeError(w, http.StatusBadRequest, "invalid case_id")
-		return
-	}
-
-	strategy, err := h.ai.CaseStrategy(r.Context(), tenantID, caseID)
-	if err != nil {
-		internalError(w, "AI case strategy analysis failed", err)
-		return
-	}
-
-	writeJSON(w, http.StatusOK, strategy)
-}
-
-// SimilarCases handles POST /api/ai/similar-cases
-// Accepts JSON {"case_id": "uuid", "description": "string"}.
-func (h *AIHandler) SimilarCases(w http.ResponseWriter, r *http.Request) {
-	tenantID, ok := auth.TenantFromContext(r.Context())
-	if !ok {
-		writeError(w, http.StatusForbidden, "missing tenant")
-		return
-	}
-
-	var body struct {
-		CaseID      string `json:"case_id"`
-		Description string `json:"description"`
-	}
-	if err := json.NewDecoder(r.Body).Decode(&body); err != nil {
-		writeError(w, http.StatusBadRequest, "invalid request body")
-		return
-	}
-
-	if body.CaseID == "" && body.Description == "" {
-		writeError(w, http.StatusBadRequest, "either case_id or description is required")
-		return
-	}
-
-	if len(body.Description) > maxDescriptionLen {
-		writeError(w, http.StatusBadRequest, "description exceeds maximum length")
-		return
-	}
-
-	var caseID uuid.UUID
-	if body.CaseID != "" {
-		var err error
-		caseID, err = parseUUID(body.CaseID)
-		if err != nil {
-			writeError(w, http.StatusBadRequest, "invalid case_id")
-			return
-		}
-	}
-
-	cases, err := h.ai.FindSimilarCases(r.Context(), tenantID, caseID, body.Description)
-	if err != nil {
-		internalError(w, "AI similar case search failed", err)
-		return
-	}
-
-	writeJSON(w, http.StatusOK, map[string]any{
-		"cases": cases,
-		"count": len(cases),
-	})
-}
--- a/backend/internal/handlers/reports.go
+++ b/backend/internal/handlers/reports.go
@@ -0,0 +1,109 @@
+package handlers
+
+import (
+	"net/http"
+	"time"
+
+	"mgit.msbls.de/m/KanzlAI-mGMT/internal/auth"
+	"mgit.msbls.de/m/KanzlAI-mGMT/internal/services"
+)
+
+type ReportHandler struct {
+	svc *services.ReportingService
+}
+
+func NewReportHandler(svc *services.ReportingService) *ReportHandler {
+	return &ReportHandler{svc: svc}
+}
+
+// parseDateRange extracts from/to query params, defaulting to last 12 months.
+func parseDateRange(r *http.Request) (time.Time, time.Time) {
+	now := time.Now()
+	from := time.Date(now.Year()-1, now.Month(), 1, 0, 0, 0, 0, time.UTC)
+	to := time.Date(now.Year(), now.Month(), now.Day(), 23, 59, 59, 0, time.UTC)
+
+	if v := r.URL.Query().Get("from"); v != "" {
+		if t, err := time.Parse("2006-01-02", v); err == nil {
+			from = t
+		}
+	}
+	if v := r.URL.Query().Get("to"); v != "" {
+		if t, err := time.Parse("2006-01-02", v); err == nil {
+			to = time.Date(t.Year(), t.Month(), t.Day(), 23, 59, 59, 0, time.UTC)
+		}
+	}
+
+	return from, to
+}
+
+func (h *ReportHandler) Cases(w http.ResponseWriter, r *http.Request) {
+	tenantID, ok := auth.TenantFromContext(r.Context())
+	if !ok {
+		writeError(w, http.StatusForbidden, "missing tenant")
+		return
+	}
+
+	from, to := parseDateRange(r)
+
+	data, err := h.svc.CaseReport(r.Context(), tenantID, from, to)
+	if err != nil {
+		internalError(w, "failed to generate case report", err)
+		return
+	}
+
+	writeJSON(w, http.StatusOK, data)
+}
+
+func (h *ReportHandler) Deadlines(w http.ResponseWriter, r *http.Request) {
+	tenantID, ok := auth.TenantFromContext(r.Context())
+	if !ok {
+		writeError(w, http.StatusForbidden, "missing tenant")
+		return
+	}
+
+	from, to := parseDateRange(r)
+
+	data, err := h.svc.DeadlineReport(r.Context(), tenantID, from, to)
+	if err != nil {
+		internalError(w, "failed to generate deadline report", err)
+		return
+	}
+
+	writeJSON(w, http.StatusOK, data)
+}
+
+func (h *ReportHandler) Workload(w http.ResponseWriter, r *http.Request) {
+	tenantID, ok := auth.TenantFromContext(r.Context())
+	if !ok {
+		writeError(w, http.StatusForbidden, "missing tenant")
+		return
+	}
+
+	from, to := parseDateRange(r)
+
+	data, err := h.svc.WorkloadReport(r.Context(), tenantID, from, to)
+	if err != nil {
+		internalError(w, "failed to generate workload report", err)
+		return
+	}
+
+	writeJSON(w, http.StatusOK, data)
+}
+
+func (h *ReportHandler) Billing(w http.ResponseWriter, r *http.Request) {
+	tenantID, ok := auth.TenantFromContext(r.Context())
+	if !ok {
+		writeError(w, http.StatusForbidden, "missing tenant")
+		return
+	}
+
+	from, to := parseDateRange(r)
+
+	data, err := h.svc.BillingReport(r.Context(), tenantID, from, to)
+	if err != nil {
+		internalError(w, "failed to generate billing report", err)
+		return
+	}
+
+	writeJSON(w, http.StatusOK, data)
+}
--- a/backend/internal/router/router.go
+++ b/backend/internal/router/router.go
@@ -15,7 +15,7 @@ import (
 	"mgit.msbls.de/m/KanzlAI-mGMT/internal/services"
 )

-func New(db *sqlx.DB, authMW *auth.Middleware, cfg *config.Config, calDAVSvc *services.CalDAVService, notifSvc *services.NotificationService, youpcDB ...*sqlx.DB) http.Handler {
+func New(db *sqlx.DB, authMW *auth.Middleware, cfg *config.Config, calDAVSvc *services.CalDAVService, notifSvc *services.NotificationService) http.Handler {
 	mux := http.NewServeMux()

 	// Services
@@ -35,11 +35,7 @@ func New(db *sqlx.DB, authMW *auth.Middleware, cfg *config.Config, calDAVSvc *se
 	// AI service (optional — only if API key is configured)
 	var aiH *handlers.AIHandler
 	if cfg.AnthropicAPIKey != "" {
-		var ydb *sqlx.DB
-		if len(youpcDB) > 0 {
-			ydb = youpcDB[0]
-		}
-		aiSvc := services.NewAIService(cfg.AnthropicAPIKey, db, ydb)
+		aiSvc := services.NewAIService(cfg.AnthropicAPIKey, db)
 		aiH = handlers.NewAIHandler(aiSvc)
 	}

@@ -48,6 +44,7 @@ func New(db *sqlx.DB, authMW *auth.Middleware, cfg *config.Config, calDAVSvc *se

 	noteSvc := services.NewNoteService(db, auditSvc)
 	dashboardSvc := services.NewDashboardService(db)
+	reportingSvc := services.NewReportingService(db)

 	// Notification handler (optional — nil in tests)
 	var notifH *handlers.NotificationHandler
@@ -65,6 +62,7 @@ func New(db *sqlx.DB, authMW *auth.Middleware, cfg *config.Config, calDAVSvc *se
 	ruleH := handlers.NewDeadlineRuleHandlers(deadlineRuleSvc)
 	calcH := handlers.NewCalculateHandlers(calculator, deadlineRuleSvc)
 	dashboardH := handlers.NewDashboardHandler(dashboardSvc)
+	reportH := handlers.NewReportHandler(reportingSvc)
 	noteH := handlers.NewNoteHandler(noteSvc)
 	eventH := handlers.NewCaseEventHandler(db)
 	docH := handlers.NewDocumentHandler(documentSvc)
@@ -160,6 +158,12 @@ func New(db *sqlx.DB, authMW *auth.Middleware, cfg *config.Config, calDAVSvc *se
 	// Dashboard — all can view
 	scoped.HandleFunc("GET /api/dashboard", dashboardH.Get)

+	// Reports — all can view
+	scoped.HandleFunc("GET /api/reports/cases", reportH.Cases)
+	scoped.HandleFunc("GET /api/reports/deadlines", reportH.Deadlines)
+	scoped.HandleFunc("GET /api/reports/workload", reportH.Workload)
+	scoped.HandleFunc("GET /api/reports/billing", reportH.Billing)
+
 	// Audit log
 	scoped.HandleFunc("GET /api/audit-log", auditH.List)

@@ -175,9 +179,6 @@ func New(db *sqlx.DB, authMW *auth.Middleware, cfg *config.Config, calDAVSvc *se
 		aiLimiter := middleware.NewTokenBucket(5.0/60.0, 10)
 		scoped.HandleFunc("POST /api/ai/extract-deadlines", perm(auth.PermAIExtraction, aiLimiter.LimitFunc(aiH.ExtractDeadlines)))
 		scoped.HandleFunc("POST /api/ai/summarize-case", perm(auth.PermAIExtraction, aiLimiter.LimitFunc(aiH.SummarizeCase)))
-		scoped.HandleFunc("POST /api/ai/draft-document", perm(auth.PermAIExtraction, aiLimiter.LimitFunc(aiH.DraftDocument)))
-		scoped.HandleFunc("POST /api/ai/case-strategy", perm(auth.PermAIExtraction, aiLimiter.LimitFunc(aiH.CaseStrategy)))
-		scoped.HandleFunc("POST /api/ai/similar-cases", perm(auth.PermAIExtraction, aiLimiter.LimitFunc(aiH.SimilarCases)))
 	}

 	// Notifications
--- a/backend/internal/services/ai_service.go
+++ b/backend/internal/services/ai_service.go
@@ -5,7 +5,6 @@ import (
 	"encoding/base64"
 	"encoding/json"
 	"fmt"
-	"strings"
 	"time"

 	"github.com/anthropics/anthropic-sdk-go"
@@ -19,12 +18,11 @@ import (
 type AIService struct {
 	client anthropic.Client
 	db     *sqlx.DB
-	youpcDB *sqlx.DB // read-only connection to youpc.org for similar case finder (may be nil)
 }

-func NewAIService(apiKey string, db *sqlx.DB, youpcDB *sqlx.DB) *AIService {
+func NewAIService(apiKey string, db *sqlx.DB) *AIService {
 	client := anthropic.NewClient(option.WithAPIKey(apiKey))
-	return &AIService{client: client, db: db, youpcDB: youpcDB}
+	return &AIService{client: client, db: db}
 }

 // ExtractedDeadline represents a deadline extracted by AI from a document.
@@ -283,726 +281,3 @@ func (s *AIService) SummarizeCase(ctx context.Context, tenantID, caseID uuid.UUI

 	return summary, nil
 }
-
-// --- Document Drafting ---
-
-// DocumentDraft represents an AI-generated document draft.
-type DocumentDraft struct {
-	Title    string `json:"title"`
-	Content  string `json:"content"`
-	Language string `json:"language"`
-}
-
-// templateDescriptions maps template type IDs to descriptions for Claude.
-var templateDescriptions = map[string]string{
-	"klageschrift":      "Klageschrift (Statement of Claim) — formal complaint initiating legal proceedings",
-	"klageerwiderung":   "Klageerwiderung (Statement of Defence) — formal response to a statement of claim",
-	"abmahnung":         "Abmahnung (Cease and Desist Letter) — formal warning letter demanding cessation of an activity",
-	"schriftsatz":       "Schriftsatz (Legal Brief) — formal legal submission to the court",
-	"berufung":          "Berufungsschrift (Appeal Brief) — formal appeal against a court decision",
-	"antrag":            "Antrag (Motion/Application) — formal application or motion to the court",
-	"stellungnahme":     "Stellungnahme (Statement/Position Paper) — formal response or position paper",
-	"gutachten":         "Gutachten (Legal Opinion/Expert Report) — detailed legal analysis or opinion",
-	"vertrag":           "Vertrag (Contract/Agreement) — legal contract or agreement between parties",
-	"vollmacht":         "Vollmacht (Power of Attorney) — formal authorization document",
-	"upc_claim":         "UPC Statement of Claim — claim filed at the Unified Patent Court",
-	"upc_defence":       "UPC Statement of Defence — defence filed at the Unified Patent Court",
-	"upc_counterclaim":  "UPC Counterclaim for Revocation — counterclaim for patent revocation at the UPC",
-	"upc_injunction":    "UPC Application for Provisional Measures — application for injunctive relief at the UPC",
-}
-
-const draftDocumentSystemPrompt = `You are an expert legal document drafter for German and UPC (Unified Patent Court) patent litigation.
-
-You draft professional legal documents in the requested language, following proper legal formatting conventions.
-
-Guidelines:
- Use proper legal structure with numbered sections and paragraphs
- Include standard legal formalities (headers, salutations, signatures block)
- Reference relevant legal provisions (BGB, ZPO, UPC Rules of Procedure, etc.)
- Use precise legal terminology appropriate for the jurisdiction
- Include placeholders in [BRACKETS] for information that needs to be filled in
- Base the content on the provided case data and instructions
- Output the document as clean text with proper formatting`
-
-// DraftDocument generates an AI-drafted legal document based on case data and a template type.
-func (s *AIService) DraftDocument(ctx context.Context, tenantID, caseID uuid.UUID, templateType, instructions, language string) (*DocumentDraft, error) {
-	if language == "" {
-		language = "de"
-	}
-
-	langLabel := "German"
-	if language == "en" {
-		langLabel = "English"
-	} else if language == "fr" {
-		langLabel = "French"
-	}
-
-	// Load case data
-	var c models.Case
-	if err := s.db.GetContext(ctx, &c,
-		"SELECT * FROM cases WHERE id = $1 AND tenant_id = $2", caseID, tenantID); err != nil {
-		return nil, fmt.Errorf("loading case: %w", err)
-	}
-
-	// Load parties
-	var parties []models.Party
-	_ = s.db.SelectContext(ctx, &parties,
-		"SELECT * FROM parties WHERE case_id = $1 AND tenant_id = $2", caseID, tenantID)
-
-	// Load recent events
-	var events []models.CaseEvent
-	_ = s.db.SelectContext(ctx, &events,
-		"SELECT * FROM case_events WHERE case_id = $1 AND tenant_id = $2 ORDER BY created_at DESC LIMIT 15",
-		caseID, tenantID)
-
-	// Load active deadlines
-	var deadlines []models.Deadline
-	_ = s.db.SelectContext(ctx, &deadlines,
-		"SELECT * FROM deadlines WHERE case_id = $1 AND tenant_id = $2 AND status = 'active' ORDER BY due_date ASC LIMIT 10",
-		caseID, tenantID)
-
-	// Load documents metadata for context
-	var documents []models.Document
-	_ = s.db.SelectContext(ctx, &documents,
-		"SELECT id, title, doc_type, created_at FROM documents WHERE case_id = $1 AND tenant_id = $2 ORDER BY created_at DESC LIMIT 10",
-		caseID, tenantID)
-
-	// Build context
-	var b strings.Builder
-	b.WriteString(fmt.Sprintf("Case: %s — %s\nStatus: %s\n", c.CaseNumber, c.Title, c.Status))
-	if c.Court != nil {
-		b.WriteString(fmt.Sprintf("Court: %s\n", *c.Court))
-	}
-	if c.CourtRef != nil {
-		b.WriteString(fmt.Sprintf("Court Reference: %s\n", *c.CourtRef))
-	}
-	if c.CaseType != nil {
-		b.WriteString(fmt.Sprintf("Type: %s\n", *c.CaseType))
-	}
-
-	if len(parties) > 0 {
-		b.WriteString("\nParties:\n")
-		for _, p := range parties {
-			role := "unknown role"
-			if p.Role != nil {
-				role = *p.Role
-			}
-			b.WriteString(fmt.Sprintf("- %s (%s)", p.Name, role))
-			if p.Representative != nil {
-				b.WriteString(fmt.Sprintf(" — represented by %s", *p.Representative))
-			}
-			b.WriteString("\n")
-		}
-	}
-
-	if len(events) > 0 {
-		b.WriteString("\nRecent Events:\n")
-		for _, e := range events {
-			b.WriteString(fmt.Sprintf("- [%s] %s", e.CreatedAt.Format("2006-01-02"), e.Title))
-			if e.Description != nil {
-				b.WriteString(fmt.Sprintf(": %s", *e.Description))
-			}
-			b.WriteString("\n")
-		}
-	}
-
-	if len(deadlines) > 0 {
-		b.WriteString("\nUpcoming Deadlines:\n")
-		for _, d := range deadlines {
-			b.WriteString(fmt.Sprintf("- %s: due %s\n", d.Title, d.DueDate))
-		}
-	}
-
-	templateDesc, ok := templateDescriptions[templateType]
-	if !ok {
-		templateDesc = templateType
-	}
-
-	prompt := fmt.Sprintf(`Draft a %s for this case in %s.
-
-Document type: %s
-
-Case context:
-%s
-Additional instructions from the lawyer:
-%s
-
-Generate the complete document now.`, templateDesc, langLabel, templateDesc, b.String(), instructions)
-
-	msg, err := s.client.Messages.New(ctx, anthropic.MessageNewParams{
-		Model:     anthropic.ModelClaudeSonnet4_20250514,
-		MaxTokens: 8192,
-		System: []anthropic.TextBlockParam{
-			{Text: draftDocumentSystemPrompt},
-		},
-		Messages: []anthropic.MessageParam{
-			anthropic.NewUserMessage(anthropic.NewTextBlock(prompt)),
-		},
-	})
-	if err != nil {
-		return nil, fmt.Errorf("claude API call: %w", err)
-	}
-
-	var content string
-	for _, block := range msg.Content {
-		if block.Type == "text" {
-			content += block.Text
-		}
-	}
-	if content == "" {
-		return nil, fmt.Errorf("empty response from Claude")
-	}
-
-	title := fmt.Sprintf("%s — %s", templateDesc, c.CaseNumber)
-	return &DocumentDraft{
-		Title:    title,
-		Content:  content,
-		Language: language,
-	}, nil
-}
-
-// --- Case Strategy ---
-
-// StrategyRecommendation represents an AI-generated case strategy analysis.
-type StrategyRecommendation struct {
-	Summary        string           `json:"summary"`
-	NextSteps      []StrategyStep   `json:"next_steps"`
-	RiskAssessment []RiskItem       `json:"risk_assessment"`
-	Timeline       []TimelineItem   `json:"timeline"`
-}
-
-type StrategyStep struct {
-	Priority    string `json:"priority"` // high, medium, low
-	Action      string `json:"action"`
-	Reasoning   string `json:"reasoning"`
-	Deadline    string `json:"deadline,omitempty"`
-}
-
-type RiskItem struct {
-	Level       string `json:"level"` // high, medium, low
-	Risk        string `json:"risk"`
-	Mitigation  string `json:"mitigation"`
-}
-
-type TimelineItem struct {
-	Date        string `json:"date"`
-	Event       string `json:"event"`
-	Importance  string `json:"importance"` // critical, important, routine
-}
-
-type strategyToolInput struct {
-	Summary        string         `json:"summary"`
-	NextSteps      []StrategyStep `json:"next_steps"`
-	RiskAssessment []RiskItem     `json:"risk_assessment"`
-	Timeline       []TimelineItem `json:"timeline"`
-}
-
-var caseStrategyTool = anthropic.ToolParam{
-	Name:        "case_strategy",
-	Description: anthropic.String("Provide strategic case analysis with next steps, risk assessment, and timeline optimization."),
-	InputSchema: anthropic.ToolInputSchemaParam{
-		Properties: map[string]any{
-			"summary": map[string]any{
-				"type":        "string",
-				"description": "Executive summary of the case situation and strategic outlook (2-4 sentences)",
-			},
-			"next_steps": map[string]any{
-				"type":        "array",
-				"description": "Recommended next actions in priority order",
-				"items": map[string]any{
-					"type": "object",
-					"properties": map[string]any{
-						"priority": map[string]any{
-							"type": "string",
-							"enum": []string{"high", "medium", "low"},
-						},
-						"action": map[string]any{
-							"type":        "string",
-							"description": "Specific recommended action",
-						},
-						"reasoning": map[string]any{
-							"type":        "string",
-							"description": "Why this action is recommended",
-						},
-						"deadline": map[string]any{
-							"type":        "string",
-							"description": "Suggested deadline in YYYY-MM-DD format, if applicable",
-						},
-					},
-					"required": []string{"priority", "action", "reasoning"},
-				},
-			},
-			"risk_assessment": map[string]any{
-				"type":        "array",
-				"description": "Key risks and mitigation strategies",
-				"items": map[string]any{
-					"type": "object",
-					"properties": map[string]any{
-						"level": map[string]any{
-							"type": "string",
-							"enum": []string{"high", "medium", "low"},
-						},
-						"risk": map[string]any{
-							"type":        "string",
-							"description": "Description of the risk",
-						},
-						"mitigation": map[string]any{
-							"type":        "string",
-							"description": "Recommended mitigation strategy",
-						},
-					},
-					"required": []string{"level", "risk", "mitigation"},
-				},
-			},
-			"timeline": map[string]any{
-				"type":        "array",
-				"description": "Optimized timeline of upcoming milestones and events",
-				"items": map[string]any{
-					"type": "object",
-					"properties": map[string]any{
-						"date": map[string]any{
-							"type":        "string",
-							"description": "Date in YYYY-MM-DD format",
-						},
-						"event": map[string]any{
-							"type":        "string",
-							"description": "Description of the milestone or event",
-						},
-						"importance": map[string]any{
-							"type": "string",
-							"enum": []string{"critical", "important", "routine"},
-						},
-					},
-					"required": []string{"date", "event", "importance"},
-				},
-			},
-		},
-		Required: []string{"summary", "next_steps", "risk_assessment", "timeline"},
-	},
-}
-
-const caseStrategySystemPrompt = `You are a senior litigation strategist specializing in German law and UPC (Unified Patent Court) patent proceedings.
-
-Analyze the case thoroughly and provide:
-1. An executive summary of the current strategic position
-2. Prioritized next steps with clear reasoning
-3. Risk assessment with mitigation strategies
-4. An optimized timeline of upcoming milestones
-
-Consider:
- Procedural deadlines and their implications
- Strength of the parties' positions based on available information
- Potential settlement opportunities
- Cost-efficiency of different strategic approaches
- UPC-specific procedural peculiarities if applicable (bifurcation, preliminary injunctions, etc.)
-
-Be practical and actionable. Avoid generic advice — tailor recommendations to the specific case data provided.`
-
-// CaseStrategy analyzes a case and returns strategic recommendations.
-func (s *AIService) CaseStrategy(ctx context.Context, tenantID, caseID uuid.UUID) (*StrategyRecommendation, error) {
-	// Load case
-	var c models.Case
-	if err := s.db.GetContext(ctx, &c,
-		"SELECT * FROM cases WHERE id = $1 AND tenant_id = $2", caseID, tenantID); err != nil {
-		return nil, fmt.Errorf("loading case: %w", err)
-	}
-
-	// Load parties
-	var parties []models.Party
-	_ = s.db.SelectContext(ctx, &parties,
-		"SELECT * FROM parties WHERE case_id = $1 AND tenant_id = $2", caseID, tenantID)
-
-	// Load all events
-	var events []models.CaseEvent
-	_ = s.db.SelectContext(ctx, &events,
-		"SELECT * FROM case_events WHERE case_id = $1 AND tenant_id = $2 ORDER BY created_at DESC LIMIT 25",
-		caseID, tenantID)
-
-	// Load all deadlines (active + completed for context)
-	var deadlines []models.Deadline
-	_ = s.db.SelectContext(ctx, &deadlines,
-		"SELECT * FROM deadlines WHERE case_id = $1 AND tenant_id = $2 ORDER BY due_date ASC LIMIT 20",
-		caseID, tenantID)
-
-	// Load documents metadata
-	var documents []models.Document
-	_ = s.db.SelectContext(ctx, &documents,
-		"SELECT id, title, doc_type, created_at FROM documents WHERE case_id = $1 AND tenant_id = $2 ORDER BY created_at DESC LIMIT 15",
-		caseID, tenantID)
-
-	// Build comprehensive context
-	var b strings.Builder
-	b.WriteString(fmt.Sprintf("Case: %s — %s\nStatus: %s\n", c.CaseNumber, c.Title, c.Status))
-	if c.Court != nil {
-		b.WriteString(fmt.Sprintf("Court: %s\n", *c.Court))
-	}
-	if c.CourtRef != nil {
-		b.WriteString(fmt.Sprintf("Court Reference: %s\n", *c.CourtRef))
-	}
-	if c.CaseType != nil {
-		b.WriteString(fmt.Sprintf("Type: %s\n", *c.CaseType))
-	}
-
-	if len(parties) > 0 {
-		b.WriteString("\nParties:\n")
-		for _, p := range parties {
-			role := "unknown"
-			if p.Role != nil {
-				role = *p.Role
-			}
-			b.WriteString(fmt.Sprintf("- %s (%s)", p.Name, role))
-			if p.Representative != nil {
-				b.WriteString(fmt.Sprintf(" — represented by %s", *p.Representative))
-			}
-			b.WriteString("\n")
-		}
-	}
-
-	if len(events) > 0 {
-		b.WriteString("\nCase Events (chronological):\n")
-		for _, e := range events {
-			b.WriteString(fmt.Sprintf("- [%s] %s", e.CreatedAt.Format("2006-01-02"), e.Title))
-			if e.Description != nil {
-				b.WriteString(fmt.Sprintf(": %s", *e.Description))
-			}
-			b.WriteString("\n")
-		}
-	}
-
-	if len(deadlines) > 0 {
-		b.WriteString("\nDeadlines:\n")
-		for _, d := range deadlines {
-			b.WriteString(fmt.Sprintf("- %s: due %s (status: %s)\n", d.Title, d.DueDate, d.Status))
-		}
-	}
-
-	if len(documents) > 0 {
-		b.WriteString("\nDocuments on file:\n")
-		for _, d := range documents {
-			docType := ""
-			if d.DocType != nil {
-				docType = fmt.Sprintf(" [%s]", *d.DocType)
-			}
-			b.WriteString(fmt.Sprintf("- %s%s (%s)\n", d.Title, docType, d.CreatedAt.Format("2006-01-02")))
-		}
-	}
-
-	msg, err := s.client.Messages.New(ctx, anthropic.MessageNewParams{
-		Model:     anthropic.ModelClaudeOpus4_6,
-		MaxTokens: 4096,
-		System: []anthropic.TextBlockParam{
-			{Text: caseStrategySystemPrompt},
-		},
-		Messages: []anthropic.MessageParam{
-			anthropic.NewUserMessage(anthropic.NewTextBlock("Analyze this case and provide strategic recommendations:\n\n" + b.String())),
-		},
-		Tools: []anthropic.ToolUnionParam{
-			{OfTool: &caseStrategyTool},
-		},
-		ToolChoice: anthropic.ToolChoiceParamOfTool("case_strategy"),
-	})
-	if err != nil {
-		return nil, fmt.Errorf("claude API call: %w", err)
-	}
-
-	for _, block := range msg.Content {
-		if block.Type == "tool_use" && block.Name == "case_strategy" {
-			var input strategyToolInput
-			if err := json.Unmarshal(block.Input, &input); err != nil {
-				return nil, fmt.Errorf("parsing strategy output: %w", err)
-			}
-			result := &StrategyRecommendation{
-				Summary:        input.Summary,
-				NextSteps:      input.NextSteps,
-				RiskAssessment: input.RiskAssessment,
-				Timeline:       input.Timeline,
-			}
-			// Cache in database
-			strategyJSON, _ := json.Marshal(result)
-			_, _ = s.db.ExecContext(ctx,
-				"UPDATE cases SET ai_summary = $1, updated_at = $2 WHERE id = $3 AND tenant_id = $4",
-				string(strategyJSON), time.Now(), caseID, tenantID)
-			return result, nil
-		}
-	}
-
-	return nil, fmt.Errorf("no tool_use block in response")
-}
-
-// --- Similar Case Finder ---
-
-// SimilarCase represents a UPC case found to be similar.
-type SimilarCase struct {
-	CaseNumber   string  `json:"case_number"`
-	Title        string  `json:"title"`
-	Court        string  `json:"court"`
-	Date         string  `json:"date"`
-	Relevance    float64 `json:"relevance"`    // 0.0-1.0
-	Explanation  string  `json:"explanation"`   // why this case is similar
-	KeyHoldings  string  `json:"key_holdings"`  // relevant holdings
-	URL          string  `json:"url,omitempty"` // link to youpc.org
-}
-
-// youpcCase represents a case from the youpc.org database.
-type youpcCase struct {
-	ID            string  `db:"id" json:"id"`
-	CaseNumber    *string `db:"case_number" json:"case_number"`
-	Title         *string `db:"title" json:"title"`
-	Court         *string `db:"court" json:"court"`
-	DecisionDate  *string `db:"decision_date" json:"decision_date"`
-	CaseType      *string `db:"case_type" json:"case_type"`
-	Outcome       *string `db:"outcome" json:"outcome"`
-	PatentNumbers *string `db:"patent_numbers" json:"patent_numbers"`
-	Summary       *string `db:"summary" json:"summary"`
-	Claimant      *string `db:"claimant" json:"claimant"`
-	Defendant     *string `db:"defendant" json:"defendant"`
-}
-
-type similarCaseToolInput struct {
-	Cases []struct {
-		CaseID      string  `json:"case_id"`
-		Relevance   float64 `json:"relevance"`
-		Explanation string  `json:"explanation"`
-		KeyHoldings string  `json:"key_holdings"`
-	} `json:"cases"`
-}
-
-var similarCaseTool = anthropic.ToolParam{
-	Name:        "rank_similar_cases",
-	Description: anthropic.String("Rank the provided UPC cases by relevance to the query case and explain why each is similar."),
-	InputSchema: anthropic.ToolInputSchemaParam{
-		Properties: map[string]any{
-			"cases": map[string]any{
-				"type":        "array",
-				"description": "UPC cases ranked by relevance (most relevant first)",
-				"items": map[string]any{
-					"type": "object",
-					"properties": map[string]any{
-						"case_id": map[string]any{
-							"type":        "string",
-							"description": "The ID of the UPC case from the provided list",
-						},
-						"relevance": map[string]any{
-							"type":        "number",
-							"minimum":     0,
-							"maximum":     1,
-							"description": "Relevance score from 0.0 to 1.0",
-						},
-						"explanation": map[string]any{
-							"type":        "string",
-							"description": "Why this case is relevant — what legal issues, parties, patents, or procedural aspects are similar",
-						},
-						"key_holdings": map[string]any{
-							"type":        "string",
-							"description": "Key holdings or legal principles from this case that are relevant",
-						},
-					},
-					"required": []string{"case_id", "relevance", "explanation", "key_holdings"},
-				},
-			},
-		},
-		Required: []string{"cases"},
-	},
-}
-
-const similarCaseSystemPrompt = `You are a UPC (Unified Patent Court) case law expert.
-
-Given a case description and a list of UPC cases from the database, rank the cases by relevance and explain why each one is similar or relevant.
-
-Consider:
- Similar patents or technology areas
- Same parties or representatives
- Similar legal issues (infringement, validity, injunctions, etc.)
- Similar procedural situations
- Relevant legal principles that could apply
-
-Only include cases that are genuinely relevant (relevance > 0.3). Order by relevance descending.`
-
-// FindSimilarCases searches the youpc.org database for similar UPC cases.
-func (s *AIService) FindSimilarCases(ctx context.Context, tenantID, caseID uuid.UUID, description string) ([]SimilarCase, error) {
-	if s.youpcDB == nil {
-		return nil, fmt.Errorf("youpc.org database not configured")
-	}
-
-	// Build query context from the case (if provided) or description
-	var queryText string
-	if caseID != uuid.Nil {
-		var c models.Case
-		if err := s.db.GetContext(ctx, &c,
-			"SELECT * FROM cases WHERE id = $1 AND tenant_id = $2", caseID, tenantID); err != nil {
-			return nil, fmt.Errorf("loading case: %w", err)
-		}
-
-		var parties []models.Party
-		_ = s.db.SelectContext(ctx, &parties,
-			"SELECT * FROM parties WHERE case_id = $1 AND tenant_id = $2", caseID, tenantID)
-
-		var b strings.Builder
-		b.WriteString(fmt.Sprintf("Case: %s — %s\n", c.CaseNumber, c.Title))
-		if c.CaseType != nil {
-			b.WriteString(fmt.Sprintf("Type: %s\n", *c.CaseType))
-		}
-		if c.Court != nil {
-			b.WriteString(fmt.Sprintf("Court: %s\n", *c.Court))
-		}
-		for _, p := range parties {
-			role := ""
-			if p.Role != nil {
-				role = *p.Role
-			}
-			b.WriteString(fmt.Sprintf("Party: %s (%s)\n", p.Name, role))
-		}
-		if description != "" {
-			b.WriteString(fmt.Sprintf("\nAdditional context: %s\n", description))
-		}
-		queryText = b.String()
-	} else if description != "" {
-		queryText = description
-	} else {
-		return nil, fmt.Errorf("either case_id or description must be provided")
-	}
-
-	// Query youpc.org database for candidate cases
-	// Search by text similarity across case titles, summaries, party names
-	var candidates []youpcCase
-	err := s.youpcDB.SelectContext(ctx, &candidates, `
-		SELECT
-			id,
-			case_number,
-			title,
-			court,
-			decision_date,
-			case_type,
-			outcome,
-			patent_numbers,
-			summary,
-			claimant,
-			defendant
-		FROM mlex.cases
-		ORDER BY decision_date DESC NULLS LAST
-		LIMIT 50
-	`)
-	if err != nil {
-		return nil, fmt.Errorf("querying youpc.org cases: %w", err)
-	}
-
-	if len(candidates) == 0 {
-		return []SimilarCase{}, nil
-	}
-
-	// Build candidate list for Claude
-	var candidateText strings.Builder
-	for _, c := range candidates {
-		candidateText.WriteString(fmt.Sprintf("ID: %s\n", c.ID))
-		if c.CaseNumber != nil {
-			candidateText.WriteString(fmt.Sprintf("Case Number: %s\n", *c.CaseNumber))
-		}
-		if c.Title != nil {
-			candidateText.WriteString(fmt.Sprintf("Title: %s\n", *c.Title))
-		}
-		if c.Court != nil {
-			candidateText.WriteString(fmt.Sprintf("Court: %s\n", *c.Court))
-		}
-		if c.DecisionDate != nil {
-			candidateText.WriteString(fmt.Sprintf("Decision Date: %s\n", *c.DecisionDate))
-		}
-		if c.CaseType != nil {
-			candidateText.WriteString(fmt.Sprintf("Type: %s\n", *c.CaseType))
-		}
-		if c.Outcome != nil {
-			candidateText.WriteString(fmt.Sprintf("Outcome: %s\n", *c.Outcome))
-		}
-		if c.PatentNumbers != nil {
-			candidateText.WriteString(fmt.Sprintf("Patents: %s\n", *c.PatentNumbers))
-		}
-		if c.Claimant != nil {
-			candidateText.WriteString(fmt.Sprintf("Claimant: %s\n", *c.Claimant))
-		}
-		if c.Defendant != nil {
-			candidateText.WriteString(fmt.Sprintf("Defendant: %s\n", *c.Defendant))
-		}
-		if c.Summary != nil {
-			candidateText.WriteString(fmt.Sprintf("Summary: %s\n", *c.Summary))
-		}
-		candidateText.WriteString("---\n")
-	}
-
-	prompt := fmt.Sprintf(`Find UPC cases relevant to this matter:
-
-%s
-
-Here are the UPC cases from the database to evaluate:
-
-%s
-
-Rank only the genuinely relevant cases by similarity.`, queryText, candidateText.String())
-
-	msg, err := s.client.Messages.New(ctx, anthropic.MessageNewParams{
-		Model:     anthropic.ModelClaudeSonnet4_20250514,
-		MaxTokens: 4096,
-		System: []anthropic.TextBlockParam{
-			{Text: similarCaseSystemPrompt},
-		},
-		Messages: []anthropic.MessageParam{
-			anthropic.NewUserMessage(anthropic.NewTextBlock(prompt)),
-		},
-		Tools: []anthropic.ToolUnionParam{
-			{OfTool: &similarCaseTool},
-		},
-		ToolChoice: anthropic.ToolChoiceParamOfTool("rank_similar_cases"),
-	})
-	if err != nil {
-		return nil, fmt.Errorf("claude API call: %w", err)
-	}
-
-	for _, block := range msg.Content {
-		if block.Type == "tool_use" && block.Name == "rank_similar_cases" {
-			var input similarCaseToolInput
-			if err := json.Unmarshal(block.Input, &input); err != nil {
-				return nil, fmt.Errorf("parsing similar cases output: %w", err)
-			}
-
-			// Build lookup map for candidate data
-			candidateMap := make(map[string]youpcCase)
-			for _, c := range candidates {
-				candidateMap[c.ID] = c
-			}
-
-			var results []SimilarCase
-			for _, ranked := range input.Cases {
-				if ranked.Relevance < 0.3 {
-					continue
-				}
-				c, ok := candidateMap[ranked.CaseID]
-				if !ok {
-					continue
-				}
-				sc := SimilarCase{
-					Relevance:   ranked.Relevance,
-					Explanation: ranked.Explanation,
-					KeyHoldings: ranked.KeyHoldings,
-				}
-				if c.CaseNumber != nil {
-					sc.CaseNumber = *c.CaseNumber
-				}
-				if c.Title != nil {
-					sc.Title = *c.Title
-				}
-				if c.Court != nil {
-					sc.Court = *c.Court
-				}
-				if c.DecisionDate != nil {
-					sc.Date = *c.DecisionDate
-				}
-				if c.CaseNumber != nil {
-					sc.URL = fmt.Sprintf("https://youpc.org/cases/%s", *c.CaseNumber)
-				}
-				results = append(results, sc)
-			}
-
-			return results, nil
-		}
-	}
-
-	return nil, fmt.Errorf("no tool_use block in response")
-}
--- a/backend/internal/services/reporting_service.go
+++ b/backend/internal/services/reporting_service.go
@@ -0,0 +1,329 @@
+package services
+
+import (
+	"context"
+	"fmt"
+	"time"
+
+	"github.com/google/uuid"
+	"github.com/jmoiron/sqlx"
+)
+
+type ReportingService struct {
+	db *sqlx.DB
+}
+
+func NewReportingService(db *sqlx.DB) *ReportingService {
+	return &ReportingService{db: db}
+}
+
+// --- Case Statistics ---
+
+type CaseStats struct {
+	Period     string `json:"period" db:"period"`
+	Opened     int    `json:"opened" db:"opened"`
+	Closed     int    `json:"closed" db:"closed"`
+	Active     int    `json:"active" db:"active"`
+}
+
+type CasesByType struct {
+	CaseType string `json:"case_type" db:"case_type"`
+	Count    int    `json:"count" db:"count"`
+}
+
+type CasesByCourt struct {
+	Court string `json:"court" db:"court"`
+	Count int    `json:"count" db:"count"`
+}
+
+type CaseReport struct {
+	Monthly  []CaseStats    `json:"monthly"`
+	ByType   []CasesByType  `json:"by_type"`
+	ByCourt  []CasesByCourt `json:"by_court"`
+	Total    CaseReportTotals `json:"total"`
+}
+
+type CaseReportTotals struct {
+	Opened int `json:"opened"`
+	Closed int `json:"closed"`
+	Active int `json:"active"`
+}
+
+func (s *ReportingService) CaseReport(ctx context.Context, tenantID uuid.UUID, from, to time.Time) (*CaseReport, error) {
+	report := &CaseReport{}
+
+	// Monthly breakdown
+	monthlyQuery := `
+		SELECT
+			TO_CHAR(DATE_TRUNC('month', created_at), 'YYYY-MM') AS period,
+			COUNT(*) AS opened,
+			COUNT(*) FILTER (WHERE status IN ('closed', 'archived')) AS closed,
+			COUNT(*) FILTER (WHERE status = 'active') AS active
+		FROM cases
+		WHERE tenant_id = $1 AND created_at >= $2 AND created_at <= $3
+		GROUP BY DATE_TRUNC('month', created_at)
+		ORDER BY DATE_TRUNC('month', created_at)`
+
+	report.Monthly = []CaseStats{}
+	if err := s.db.SelectContext(ctx, &report.Monthly, monthlyQuery, tenantID, from, to); err != nil {
+		return nil, fmt.Errorf("case report monthly: %w", err)
+	}
+
+	// By type
+	typeQuery := `
+		SELECT COALESCE(case_type, 'Sonstiges') AS case_type, COUNT(*) AS count
+		FROM cases
+		WHERE tenant_id = $1 AND created_at >= $2 AND created_at <= $3
+		GROUP BY case_type
+		ORDER BY count DESC`
+
+	report.ByType = []CasesByType{}
+	if err := s.db.SelectContext(ctx, &report.ByType, typeQuery, tenantID, from, to); err != nil {
+		return nil, fmt.Errorf("case report by type: %w", err)
+	}
+
+	// By court
+	courtQuery := `
+		SELECT COALESCE(court, 'Ohne Gericht') AS court, COUNT(*) AS count
+		FROM cases
+		WHERE tenant_id = $1 AND created_at >= $2 AND created_at <= $3
+		GROUP BY court
+		ORDER BY count DESC`
+
+	report.ByCourt = []CasesByCourt{}
+	if err := s.db.SelectContext(ctx, &report.ByCourt, courtQuery, tenantID, from, to); err != nil {
+		return nil, fmt.Errorf("case report by court: %w", err)
+	}
+
+	// Totals
+	totalsQuery := `
+		SELECT
+			COUNT(*) AS opened,
+			COUNT(*) FILTER (WHERE status IN ('closed', 'archived')) AS closed,
+			COUNT(*) FILTER (WHERE status = 'active') AS active
+		FROM cases
+		WHERE tenant_id = $1 AND created_at >= $2 AND created_at <= $3`
+
+	if err := s.db.GetContext(ctx, &report.Total, totalsQuery, tenantID, from, to); err != nil {
+		return nil, fmt.Errorf("case report totals: %w", err)
+	}
+
+	return report, nil
+}
+
+// --- Deadline Compliance ---
+
+type DeadlineCompliance struct {
+	Period       string  `json:"period" db:"period"`
+	Total        int     `json:"total" db:"total"`
+	Met          int     `json:"met" db:"met"`
+	Missed       int     `json:"missed" db:"missed"`
+	Pending      int     `json:"pending" db:"pending"`
+	ComplianceRate float64 `json:"compliance_rate"`
+}
+
+type MissedDeadline struct {
+	ID         uuid.UUID `json:"id" db:"id"`
+	Title      string    `json:"title" db:"title"`
+	DueDate    string    `json:"due_date" db:"due_date"`
+	CaseID     uuid.UUID `json:"case_id" db:"case_id"`
+	CaseNumber string    `json:"case_number" db:"case_number"`
+	CaseTitle  string    `json:"case_title" db:"case_title"`
+	DaysOverdue int      `json:"days_overdue" db:"days_overdue"`
+}
+
+type DeadlineReport struct {
+	Monthly []DeadlineCompliance `json:"monthly"`
+	Missed  []MissedDeadline     `json:"missed"`
+	Total   DeadlineReportTotals `json:"total"`
+}
+
+type DeadlineReportTotals struct {
+	Total          int     `json:"total"`
+	Met            int     `json:"met"`
+	Missed         int     `json:"missed"`
+	Pending        int     `json:"pending"`
+	ComplianceRate float64 `json:"compliance_rate"`
+}
+
+func (s *ReportingService) DeadlineReport(ctx context.Context, tenantID uuid.UUID, from, to time.Time) (*DeadlineReport, error) {
+	report := &DeadlineReport{}
+
+	// Monthly compliance
+	monthlyQuery := `
+		SELECT
+			TO_CHAR(DATE_TRUNC('month', due_date), 'YYYY-MM') AS period,
+			COUNT(*) AS total,
+			COUNT(*) FILTER (WHERE status = 'completed' AND (completed_at IS NULL OR completed_at::date <= due_date)) AS met,
+			COUNT(*) FILTER (WHERE (status = 'completed' AND completed_at::date > due_date) OR (status = 'pending' AND due_date < CURRENT_DATE)) AS missed,
+			COUNT(*) FILTER (WHERE status = 'pending' AND due_date >= CURRENT_DATE) AS pending
+		FROM deadlines
+		WHERE tenant_id = $1 AND due_date >= $2 AND due_date <= $3
+		GROUP BY DATE_TRUNC('month', due_date)
+		ORDER BY DATE_TRUNC('month', due_date)`
+
+	report.Monthly = []DeadlineCompliance{}
+	if err := s.db.SelectContext(ctx, &report.Monthly, monthlyQuery, tenantID, from, to); err != nil {
+		return nil, fmt.Errorf("deadline report monthly: %w", err)
+	}
+
+	// Calculate compliance rates
+	for i := range report.Monthly {
+		completed := report.Monthly[i].Met + report.Monthly[i].Missed
+		if completed > 0 {
+			report.Monthly[i].ComplianceRate = float64(report.Monthly[i].Met) / float64(completed) * 100
+		}
+	}
+
+	// Missed deadlines list
+	missedQuery := `
+		SELECT d.id, d.title, d.due_date, d.case_id, c.case_number, c.title AS case_title,
+			(CURRENT_DATE - d.due_date::date) AS days_overdue
+		FROM deadlines d
+		JOIN cases c ON c.id = d.case_id AND c.tenant_id = d.tenant_id
+		WHERE d.tenant_id = $1 AND d.due_date >= $2 AND d.due_date <= $3
+			AND ((d.status = 'pending' AND d.due_date < CURRENT_DATE)
+				OR (d.status = 'completed' AND d.completed_at::date > d.due_date))
+		ORDER BY d.due_date ASC
+		LIMIT 50`
+
+	report.Missed = []MissedDeadline{}
+	if err := s.db.SelectContext(ctx, &report.Missed, missedQuery, tenantID, from, to); err != nil {
+		return nil, fmt.Errorf("deadline report missed: %w", err)
+	}
+
+	// Totals
+	totalsQuery := `
+		SELECT
+			COUNT(*) AS total,
+			COUNT(*) FILTER (WHERE status = 'completed' AND (completed_at IS NULL OR completed_at::date <= due_date)) AS met,
+			COUNT(*) FILTER (WHERE (status = 'completed' AND completed_at::date > due_date) OR (status = 'pending' AND due_date < CURRENT_DATE)) AS missed,
+			COUNT(*) FILTER (WHERE status = 'pending' AND due_date >= CURRENT_DATE) AS pending
+		FROM deadlines
+		WHERE tenant_id = $1 AND due_date >= $2 AND due_date <= $3`
+
+	if err := s.db.GetContext(ctx, &report.Total, totalsQuery, tenantID, from, to); err != nil {
+		return nil, fmt.Errorf("deadline report totals: %w", err)
+	}
+
+	completed := report.Total.Met + report.Total.Missed
+	if completed > 0 {
+		report.Total.ComplianceRate = float64(report.Total.Met) / float64(completed) * 100
+	}
+
+	return report, nil
+}
+
+// --- Workload ---
+
+type UserWorkload struct {
+	UserID      uuid.UUID `json:"user_id" db:"user_id"`
+	ActiveCases int       `json:"active_cases" db:"active_cases"`
+	Deadlines   int       `json:"deadlines" db:"deadlines"`
+	Overdue     int       `json:"overdue" db:"overdue"`
+	Completed   int       `json:"completed" db:"completed"`
+}
+
+type WorkloadReport struct {
+	Users []UserWorkload `json:"users"`
+}
+
+func (s *ReportingService) WorkloadReport(ctx context.Context, tenantID uuid.UUID, from, to time.Time) (*WorkloadReport, error) {
+	report := &WorkloadReport{}
+
+	query := `
+		WITH user_cases AS (
+			SELECT ca.user_id, COUNT(DISTINCT ca.case_id) AS active_cases
+			FROM case_assignments ca
+			JOIN cases c ON c.id = ca.case_id AND c.tenant_id = $1
+			WHERE c.status = 'active'
+			GROUP BY ca.user_id
+		),
+		user_deadlines AS (
+			SELECT ca.user_id,
+				COUNT(*) AS deadlines,
+				COUNT(*) FILTER (WHERE d.status = 'pending' AND d.due_date < CURRENT_DATE) AS overdue,
+				COUNT(*) FILTER (WHERE d.status = 'completed' AND d.completed_at >= $2 AND d.completed_at <= $3) AS completed
+			FROM case_assignments ca
+			JOIN deadlines d ON d.case_id = ca.case_id AND d.tenant_id = $1
+			WHERE d.due_date >= $2 AND d.due_date <= $3
+			GROUP BY ca.user_id
+		)
+		SELECT
+			COALESCE(uc.user_id, ud.user_id) AS user_id,
+			COALESCE(uc.active_cases, 0) AS active_cases,
+			COALESCE(ud.deadlines, 0) AS deadlines,
+			COALESCE(ud.overdue, 0) AS overdue,
+			COALESCE(ud.completed, 0) AS completed
+		FROM user_cases uc
+		FULL OUTER JOIN user_deadlines ud ON uc.user_id = ud.user_id
+		ORDER BY active_cases DESC`
+
+	report.Users = []UserWorkload{}
+	if err := s.db.SelectContext(ctx, &report.Users, query, tenantID, from, to); err != nil {
+		return nil, fmt.Errorf("workload report: %w", err)
+	}
+
+	return report, nil
+}
+
+// --- Billing (summary from case data) ---
+
+type BillingByMonth struct {
+	Period      string `json:"period" db:"period"`
+	CasesActive int    `json:"cases_active" db:"cases_active"`
+	CasesClosed int    `json:"cases_closed" db:"cases_closed"`
+	CasesNew    int    `json:"cases_new" db:"cases_new"`
+}
+
+type BillingByType struct {
+	CaseType string `json:"case_type" db:"case_type"`
+	Active   int    `json:"active" db:"active"`
+	Closed   int    `json:"closed" db:"closed"`
+	Total    int    `json:"total" db:"total"`
+}
+
+type BillingReport struct {
+	Monthly []BillingByMonth `json:"monthly"`
+	ByType  []BillingByType  `json:"by_type"`
+}
+
+func (s *ReportingService) BillingReport(ctx context.Context, tenantID uuid.UUID, from, to time.Time) (*BillingReport, error) {
+	report := &BillingReport{}
+
+	// Monthly activity for billing overview
+	monthlyQuery := `
+		SELECT
+			TO_CHAR(DATE_TRUNC('month', created_at), 'YYYY-MM') AS period,
+			COUNT(*) FILTER (WHERE status = 'active') AS cases_active,
+			COUNT(*) FILTER (WHERE status IN ('closed', 'archived')) AS cases_closed,
+			COUNT(*) AS cases_new
+		FROM cases
+		WHERE tenant_id = $1 AND created_at >= $2 AND created_at <= $3
+		GROUP BY DATE_TRUNC('month', created_at)
+		ORDER BY DATE_TRUNC('month', created_at)`
+
+	report.Monthly = []BillingByMonth{}
+	if err := s.db.SelectContext(ctx, &report.Monthly, monthlyQuery, tenantID, from, to); err != nil {
+		return nil, fmt.Errorf("billing report monthly: %w", err)
+	}
+
+	// By case type
+	typeQuery := `
+		SELECT
+			COALESCE(case_type, 'Sonstiges') AS case_type,
+			COUNT(*) FILTER (WHERE status = 'active') AS active,
+			COUNT(*) FILTER (WHERE status IN ('closed', 'archived')) AS closed,
+			COUNT(*) AS total
+		FROM cases
+		WHERE tenant_id = $1 AND created_at >= $2 AND created_at <= $3
+		GROUP BY case_type
+		ORDER BY total DESC`
+
+	report.ByType = []BillingByType{}
+	if err := s.db.SelectContext(ctx, &report.ByType, typeQuery, tenantID, from, to); err != nil {
+		return nil, fmt.Errorf("billing report by type: %w", err)
+	}
+
+	return report, nil
+}
--- a/frontend/bun.lock
+++ b/frontend/bun.lock
@@ -14,6 +14,7 @@
        "react": "19.1.0",
        "react-dom": "19.1.0",
        "react-dropzone": "^15.0.0",
+        "recharts": "^3.8.1",
        "sonner": "^2.0.7",
      },
      "devDependencies": {
@@ -244,6 +245,8 @@

    "@open-draft/until": ["@open-draft/until@2.1.0", "", {}, "sha512-U69T3ItWHvLwGg5eJ0n3I62nWuE6ilHlmz7zM0npLBRvPRd7e6NYmg54vvRtP5mZG7kZqZCFVdsTWo7BPtBujg=="],

+    "@reduxjs/toolkit": ["@reduxjs/toolkit@2.11.2", "", { "dependencies": { "@standard-schema/spec": "^1.0.0", "@standard-schema/utils": "^0.3.0", "immer": "^11.0.0", "redux": "^5.0.1", "redux-thunk": "^3.1.0", "reselect": "^5.1.0" }, "peerDependencies": { "react": "^16.9.0 || ^17.0.0 || ^18 || ^19", "react-redux": "^7.2.1 || ^8.1.3 || ^9.0.0" }, "optionalPeers": ["react", "react-redux"] }, "sha512-Kd6kAHTA6/nUpp8mySPqj3en3dm0tdMIgbttnQ1xFMVpufoj+ADi8pXLBsd4xzTRHQa7t/Jv8W5UnCuW4kuWMQ=="],
+
    "@rollup/rollup-android-arm-eabi": ["@rollup/rollup-android-arm-eabi@4.60.0", "", { "os": "android", "cpu": "arm" }, "sha512-WOhNW9K8bR3kf4zLxbfg6Pxu2ybOUbB2AjMDHSQx86LIF4rH4Ft7vmMwNt0loO0eonglSNy4cpD3MKXXKQu0/A=="],

    "@rollup/rollup-android-arm64": ["@rollup/rollup-android-arm64@4.60.0", "", { "os": "android", "cpu": "arm64" }, "sha512-u6JHLll5QKRvjciE78bQXDmqRqNs5M/3GVqZeMwvmjaNODJih/WIrJlFVEihvV0MiYFmd+ZyPr9wxOVbPAG2Iw=="],
@@ -298,6 +301,10 @@

    "@rushstack/eslint-patch": ["@rushstack/eslint-patch@1.16.1", "", {}, "sha512-TvZbIpeKqGQQ7X0zSCvPH9riMSFQFSggnfBjFZ1mEoILW+UuXCKwOoPcgjMwiUtRqFZ8jWhPJc4um14vC6I4ag=="],

+    "@standard-schema/spec": ["@standard-schema/spec@1.1.0", "", {}, "sha512-l2aFy5jALhniG5HgqrD6jXLi/rUWrKvqN/qJx6yoJsgKhblVd+iqqU4RCXavm/jPityDo5TCvKMnpjKnOriy0w=="],
+
+    "@standard-schema/utils": ["@standard-schema/utils@0.3.0", "", {}, "sha512-e7Mew686owMaPJVNNLs55PUvgz371nKgwsc4vxE49zsODpJEnxgxRo2y/OKrqueavXgZNMDVj3DdHFlaSAeU8g=="],
+
    "@supabase/auth-js": ["@supabase/auth-js@2.100.0", "", { "dependencies": { "tslib": "2.8.1" } }, "sha512-pdT3ye3UVRN1Cg0wom6BmyY+XTtp5DiJaYnPi6j8ht5i8Lq8kfqxJMJz9GI9YDKk3w1nhGOPnh6Qz5qpyYm+1w=="],

    "@supabase/functions-js": ["@supabase/functions-js@2.100.0", "", { "dependencies": { "tslib": "2.8.1" } }, "sha512-keLg79RPwP+uiwHuxFPTFgDRxPV46LM4j/swjyR2GKJgWniTVSsgiBHfbIBDcrQwehLepy09b/9QSHUywtKRWQ=="],
@@ -362,6 +369,24 @@

    "@types/aria-query": ["@types/aria-query@5.0.4", "", {}, "sha512-rfT93uj5s0PRL7EzccGMs3brplhcrghnDoV26NqKhCAS1hVo+WdNsPvE/yb6ilfr5hi2MEk6d5EWJTKdxg8jVw=="],

+    "@types/d3-array": ["@types/d3-array@3.2.2", "", {}, "sha512-hOLWVbm7uRza0BYXpIIW5pxfrKe0W+D5lrFiAEYR+pb6w3N2SwSMaJbXdUfSEv+dT4MfHBLtn5js0LAWaO6otw=="],
+
+    "@types/d3-color": ["@types/d3-color@3.1.3", "", {}, "sha512-iO90scth9WAbmgv7ogoq57O9YpKmFBbmoEoCHDB2xMBY0+/KVrqAaCDyCE16dUspeOvIxFFRI+0sEtqDqy2b4A=="],
+
+    "@types/d3-ease": ["@types/d3-ease@3.0.2", "", {}, "sha512-NcV1JjO5oDzoK26oMzbILE6HW7uVXOHLQvHshBUW4UMdZGfiY6v5BeQwh9a9tCzv+CeefZQHJt5SRgK154RtiA=="],
+
+    "@types/d3-interpolate": ["@types/d3-interpolate@3.0.4", "", { "dependencies": { "@types/d3-color": "*" } }, "sha512-mgLPETlrpVV1YRJIglr4Ez47g7Yxjl1lj7YKsiMCb27VJH9W8NVM6Bb9d8kkpG/uAQS5AmbA48q2IAolKKo1MA=="],
+
+    "@types/d3-path": ["@types/d3-path@3.1.1", "", {}, "sha512-VMZBYyQvbGmWyWVea0EHs/BwLgxc+MKi1zLDCONksozI4YJMcTt8ZEuIR4Sb1MMTE8MMW49v0IwI5+b7RmfWlg=="],
+
+    "@types/d3-scale": ["@types/d3-scale@4.0.9", "", { "dependencies": { "@types/d3-time": "*" } }, "sha512-dLmtwB8zkAeO/juAMfnV+sItKjlsw2lKdZVVy6LRr0cBmegxSABiLEpGVmSJJ8O08i4+sGR6qQtb6WtuwJdvVw=="],
+
+    "@types/d3-shape": ["@types/d3-shape@3.1.8", "", { "dependencies": { "@types/d3-path": "*" } }, "sha512-lae0iWfcDeR7qt7rA88BNiqdvPS5pFVPpo5OfjElwNaT2yyekbM0C9vK+yqBqEmHr6lDkRnYNoTBYlAgJa7a4w=="],
+
+    "@types/d3-time": ["@types/d3-time@3.0.4", "", {}, "sha512-yuzZug1nkAAaBlBBikKZTgzCeA+k1uy4ZFwWANOfKw5z5LRhV0gNA7gNkKm7HoK+HRN0wX3EkxGk0fpbWhmB7g=="],
+
+    "@types/d3-timer": ["@types/d3-timer@3.0.2", "", {}, "sha512-Ps3T8E8dZDam6fUyNiMkekK3XUsaUEik+idO9/YjPtfj2qruF8tFBXS7XhtE4iIXBLxhmLjP3SXpLhVf21I9Lw=="],
+
    "@types/estree": ["@types/estree@1.0.8", "", {}, "sha512-dWHzHa2WqEXI/O1E9OjrocMTKJl2mSrEolh1Iomrv6U+JuNwaHXsXx9bLu5gG7BUWFIN0skIQJQ/L1rIex4X6w=="],

    "@types/json-schema": ["@types/json-schema@7.0.15", "", {}, "sha512-5+fP8P8MFNC+AyZCDxrB2pkZFPGzqQWUzpSeuuVLvm8VMcorNYavBqoFcxK8bQz4Qsbn4oUEEem4wDLfcysGHA=="],
@@ -376,6 +401,8 @@

    "@types/statuses": ["@types/statuses@2.0.6", "", {}, "sha512-xMAgYwceFhRA2zY+XbEA7mxYbA093wdiW8Vu6gZPGWy9cmOyU9XesH1tNcEWsKFd5Vzrqx5T3D38PWx1FIIXkA=="],

+    "@types/use-sync-external-store": ["@types/use-sync-external-store@0.0.6", "", {}, "sha512-zFDAD+tlpf2r4asuHEj0XH6pY6i0g5NeAHPn+15wk3BV6JA69eERFXC1gyGThDkVa1zCyKr5jox1+2LbV/AMLg=="],
+
    "@types/ws": ["@types/ws@8.18.1", "", { "dependencies": { "@types/node": "*" } }, "sha512-ThVF6DCVhA8kUGy+aazFQ4kXQ7E1Ty7A3ypFOe0IcJV8O/M511G99AW24irKrW56Wt44yG9+ij8FaqoBGkuBXg=="],

    "@typescript-eslint/eslint-plugin": ["@typescript-eslint/eslint-plugin@8.57.2", "", { "dependencies": { "@eslint-community/regexpp": "^4.12.2", "@typescript-eslint/scope-manager": "8.57.2", "@typescript-eslint/type-utils": "8.57.2", "@typescript-eslint/utils": "8.57.2", "@typescript-eslint/visitor-keys": "8.57.2", "ignore": "^7.0.5", "natural-compare": "^1.4.0", "ts-api-utils": "^2.4.0" }, "peerDependencies": { "@typescript-eslint/parser": "^8.57.2", "eslint": "^8.57.0 || ^9.0.0 || ^10.0.0", "typescript": ">=4.8.4 <6.0.0" } }, "sha512-NZZgp0Fm2IkD+La5PR81sd+g+8oS6JwJje+aRWsDocxHkjyRw0J5L5ZTlN3LI1LlOcGL7ph3eaIUmTXMIjLk0w=="],
@@ -528,6 +555,8 @@

    "cliui": ["cliui@8.0.1", "", { "dependencies": { "string-width": "^4.2.0", "strip-ansi": "^6.0.1", "wrap-ansi": "^7.0.0" } }, "sha512-BSeNnyus75C4//NQ9gQt1/csTXyo/8Sb+afLAkzAptFuMsod9HFokGNudZpi/oQV73hnVK+sR+5PVRMd+Dr7YQ=="],

+    "clsx": ["clsx@2.1.1", "", {}, "sha512-eYm0QWBtUrBWZWG0d386OGAw16Z995PiOVo2B7bjWSbHedGl5e0ZWaq65kOGgUSNesEIDkB9ISbTg/JK9dhCZA=="],
+
    "color-convert": ["color-convert@2.0.1", "", { "dependencies": { "color-name": "~1.1.4" } }, "sha512-RRECPsj7iu/xb5oKYcsFHSppFNnsj/52OVTRKb4zP5onXwVF3zVmmToNcOfGC+CRDpfK/U584fMg38ZHCaElKQ=="],

    "color-name": ["color-name@1.1.4", "", {}, "sha512-dOy+3AuW3a2wNbZHIuMZpTcgjGuLU/uBL/ubcZF9OXbDo8ff4O8yVp5Bf0efS8uEoYo5q4Fx7dY9OgQGXgAsQA=="],
@@ -546,6 +575,28 @@

    "csstype": ["csstype@3.2.3", "", {}, "sha512-z1HGKcYy2xA8AGQfwrn0PAy+PB7X/GSj3UVJW9qKyn43xWa+gl5nXmU4qqLMRzWVLFC8KusUX8T/0kCiOYpAIQ=="],

+    "d3-array": ["d3-array@3.2.4", "", { "dependencies": { "internmap": "1 - 2" } }, "sha512-tdQAmyA18i4J7wprpYq8ClcxZy3SC31QMeByyCFyRt7BVHdREQZ5lpzoe5mFEYZUWe+oq8HBvk9JjpibyEV4Jg=="],
+
+    "d3-color": ["d3-color@3.1.0", "", {}, "sha512-zg/chbXyeBtMQ1LbD/WSoW2DpC3I0mpmPdW+ynRTj/x2DAWYrIY7qeZIHidozwV24m4iavr15lNwIwLxRmOxhA=="],
+
+    "d3-ease": ["d3-ease@3.0.1", "", {}, "sha512-wR/XK3D3XcLIZwpbvQwQ5fK+8Ykds1ip7A2Txe0yxncXSdq1L9skcG7blcedkOX+ZcgxGAmLX1FrRGbADwzi0w=="],
+
+    "d3-format": ["d3-format@3.1.2", "", {}, "sha512-AJDdYOdnyRDV5b6ArilzCPPwc1ejkHcoyFarqlPqT7zRYjhavcT3uSrqcMvsgh2CgoPbK3RCwyHaVyxYcP2Arg=="],
+
+    "d3-interpolate": ["d3-interpolate@3.0.1", "", { "dependencies": { "d3-color": "1 - 3" } }, "sha512-3bYs1rOD33uo8aqJfKP3JWPAibgw8Zm2+L9vBKEHJ2Rg+viTR7o5Mmv5mZcieN+FRYaAOWX5SJATX6k1PWz72g=="],
+
+    "d3-path": ["d3-path@3.1.0", "", {}, "sha512-p3KP5HCf/bvjBSSKuXid6Zqijx7wIfNW+J/maPs+iwR35at5JCbLUT0LzF1cnjbCHWhqzQTIN2Jpe8pRebIEFQ=="],
+
+    "d3-scale": ["d3-scale@4.0.2", "", { "dependencies": { "d3-array": "2.10.0 - 3", "d3-format": "1 - 3", "d3-interpolate": "1.2.0 - 3", "d3-time": "2.1.1 - 3", "d3-time-format": "2 - 4" } }, "sha512-GZW464g1SH7ag3Y7hXjf8RoUuAFIqklOAq3MRl4OaWabTFJY9PN/E1YklhXLh+OQ3fM9yS2nOkCoS+WLZ6kvxQ=="],
+
+    "d3-shape": ["d3-shape@3.2.0", "", { "dependencies": { "d3-path": "^3.1.0" } }, "sha512-SaLBuwGm3MOViRq2ABk3eLoxwZELpH6zhl3FbAoJ7Vm1gofKx6El1Ib5z23NUEhF9AsGl7y+dzLe5Cw2AArGTA=="],
+
+    "d3-time": ["d3-time@3.1.0", "", { "dependencies": { "d3-array": "2 - 3" } }, "sha512-VqKjzBLejbSMT4IgbmVgDjpkYrNWUYJnbCGo874u7MMKIWsILRX+OpX/gTk8MqjpT1A/c6HY2dCA77ZN0lkQ2Q=="],
+
+    "d3-time-format": ["d3-time-format@4.1.0", "", { "dependencies": { "d3-time": "1 - 3" } }, "sha512-dJxPBlzC7NugB2PDLwo9Q8JiTR3M3e4/XANkreKSUxF8vvXKqm1Yfq4Q5dl8budlunRVlUUaDUgFt7eA8D6NLg=="],
+
+    "d3-timer": ["d3-timer@3.0.1", "", {}, "sha512-ndfJ/JxxMd3nw31uyKoY2naivF+r29V+Lc0svZxe1JvvIRmi8hUsrMvdOwgS1o6uBHmiz91geQ0ylPP0aj1VUA=="],
+
    "damerau-levenshtein": ["damerau-levenshtein@1.0.8", "", {}, "sha512-sdQSFB7+llfUcQHUQO3+B8ERRj0Oa4w9POWMI/puGtuf7gFywGmkaLCElnudfTiKZV+NvHqL0ifzdrI8Ro7ESA=="],

    "data-urls": ["data-urls@5.0.0", "", { "dependencies": { "whatwg-mimetype": "^4.0.0", "whatwg-url": "^14.0.0" } }, "sha512-ZYP5VBHshaDAiVZxjbRVcFJpc+4xGgT0bK3vzy1HLN8jTO975HEbuYzZJcHoQEY5K1a0z8YayJkyVETa08eNTg=="],
@@ -562,6 +613,8 @@

    "decimal.js": ["decimal.js@10.6.0", "", {}, "sha512-YpgQiITW3JXGntzdUmyUR1V812Hn8T1YVXhCu+wO3OpS4eU9l4YdD3qjyiKdV6mvV29zapkMeD390UVEf2lkUg=="],

+    "decimal.js-light": ["decimal.js-light@2.5.1", "", {}, "sha512-qIMFpTMZmny+MMIitAB6D7iVPEorVw6YQRWkvarTkT4tBeSLLiHzcwj6q0MmYSFCiVpiqPJTJEYIrpcPzVEIvg=="],
+
    "deep-eql": ["deep-eql@5.0.2", "", {}, "sha512-h5k/5U50IJJFpzfL6nO9jaaumfjO/f2NjK/oYB2Djzm4p9L+3T9qWpZqZ2hAbLPuuYq9wrU08WQyBTL5GbPk5Q=="],

    "deep-is": ["deep-is@0.1.4", "", {}, "sha512-oIPzksmTg4/MriiaYGO+okXDT7ztn/w3Eptv/+gSIdMdKsJo0u4CfYNFJPy+4SKMuCqGw2wxnA+URMg3t8a/bQ=="],
@@ -606,6 +659,8 @@

    "es-to-primitive": ["es-to-primitive@1.3.0", "", { "dependencies": { "is-callable": "^1.2.7", "is-date-object": "^1.0.5", "is-symbol": "^1.0.4" } }, "sha512-w+5mJ3GuFL+NjVtJlvydShqE1eN3h3PbI7/5LAsYJP/2qtuMXjfL2LpHSRqo4b4eSF5K/DH1JXKUAHSB2UW50g=="],

+    "es-toolkit": ["es-toolkit@1.45.1", "", {}, "sha512-/jhoOj/Fx+A+IIyDNOvO3TItGmlMKhtX8ISAHKE90c4b/k1tqaqEZ+uUqfpU8DMnW5cgNJv606zS55jGvza0Xw=="],
+
    "esbuild": ["esbuild@0.21.5", "", { "optionalDependencies": { "@esbuild/aix-ppc64": "0.21.5", "@esbuild/android-arm": "0.21.5", "@esbuild/android-arm64": "0.21.5", "@esbuild/android-x64": "0.21.5", "@esbuild/darwin-arm64": "0.21.5", "@esbuild/darwin-x64": "0.21.5", "@esbuild/freebsd-arm64": "0.21.5", "@esbuild/freebsd-x64": "0.21.5", "@esbuild/linux-arm": "0.21.5", "@esbuild/linux-arm64": "0.21.5", "@esbuild/linux-ia32": "0.21.5", "@esbuild/linux-loong64": "0.21.5", "@esbuild/linux-mips64el": "0.21.5", "@esbuild/linux-ppc64": "0.21.5", "@esbuild/linux-riscv64": "0.21.5", "@esbuild/linux-s390x": "0.21.5", "@esbuild/linux-x64": "0.21.5", "@esbuild/netbsd-x64": "0.21.5", "@esbuild/openbsd-x64": "0.21.5", "@esbuild/sunos-x64": "0.21.5", "@esbuild/win32-arm64": "0.21.5", "@esbuild/win32-ia32": "0.21.5", "@esbuild/win32-x64": "0.21.5" }, "bin": { "esbuild": "bin/esbuild" } }, "sha512-mg3OPMV4hXywwpoDxu3Qda5xCKQi+vCTZq8S9J/EpkhB2HzKXq4SNFZE3+NK93JYxc8VMSep+lOUSC/RVKaBqw=="],

    "escalade": ["escalade@3.2.0", "", {}, "sha512-WUj2qlxaQtO4g6Pq5c29GTcWGDyd8itL8zTlipgECz3JesAiiOKotd8JU6otB3PACgG6xkJUyVhboMS+bje/jA=="],
@@ -646,6 +701,8 @@

    "esutils": ["esutils@2.0.3", "", {}, "sha512-kVscqXk4OCp68SZ0dkgEKVi6/8ij300KBWTJq32P/dYeWTSwK41WyTxalN1eRmA5Z9UU/LX9D7FWSmV9SAYx6g=="],

+    "eventemitter3": ["eventemitter3@5.0.4", "", {}, "sha512-mlsTRyGaPBjPedk6Bvw+aqbsXDtoAyAzm5MO7JgU+yVRyMQ5O8bD4Kcci7BS85f93veegeCPkL8R4GLClnjLFw=="],
+
    "expect-type": ["expect-type@1.3.0", "", {}, "sha512-knvyeauYhqjOYvQ66MznSMs83wmHrCycNEN6Ao+2AeYEfxUIkuiVxdEa1qlGEPK+We3n0THiDciYSsCcgW/DoA=="],

    "fast-deep-equal": ["fast-deep-equal@3.1.3", "", {}, "sha512-f3qQ9oQy9j2AhBe/H9VC91wLmKBCCU/gDOnKNAYG5hswO7BLKj09Hc5HYNz9cGI++xlpDCIgDaitVs03ATR84Q=="],
@@ -736,6 +793,8 @@

    "ignore": ["ignore@5.3.2", "", {}, "sha512-hsBTNUqQTDwkWtcdYI2i06Y/nUBEsNEDJKjWdigLvegy8kDuJAS8uRlpkkcQpyEXL0Z/pjDy5HBmMjRCJ2gq+g=="],

+    "immer": ["immer@10.2.0", "", {}, "sha512-d/+XTN3zfODyjr89gM3mPq1WNX2B8pYsu7eORitdwyA2sBubnTl3laYlBk4sXY5FUa5qTZGBDPJICVbvqzjlbw=="],
+
    "import-fresh": ["import-fresh@3.3.1", "", { "dependencies": { "parent-module": "^1.0.0", "resolve-from": "^4.0.0" } }, "sha512-TR3KfrTZTYLPB6jUjfx6MF9WcWrHL9su5TObK4ZkYgBdWKPOFoSoQIdEuTuR82pmtxH2spWG9h6etwfr1pLBqQ=="],

    "imurmurhash": ["imurmurhash@0.1.4", "", {}, "sha512-JmXMZ6wuvDmLiHEml9ykzqO6lwFbof0GG4IkcGaENdCRDDmMVnny7s5HsIgHCbaq0w2MyPhDqkhTUgS2LU2PHA=="],
@@ -744,6 +803,8 @@

    "internal-slot": ["internal-slot@1.1.0", "", { "dependencies": { "es-errors": "^1.3.0", "hasown": "^2.0.2", "side-channel": "^1.1.0" } }, "sha512-4gd7VpWNQNB4UKKCFFVcp1AVv+FMOgs9NKzjHKusc8jTMhd5eL1NqQqOpE0KzMds804/yHlglp3uxgluOqAPLw=="],

+    "internmap": ["internmap@2.0.3", "", {}, "sha512-5Hh7Y1wQbvY5ooGgPbDaL5iYLAPzMTUrjMulskHLH6wnv/A+1q5rgEaiuqEjB+oxGXIVZs1FF+R/KPN3ZSQYYg=="],
+
    "is-array-buffer": ["is-array-buffer@3.0.5", "", { "dependencies": { "call-bind": "^1.0.8", "call-bound": "^1.0.3", "get-intrinsic": "^1.2.6" } }, "sha512-DDfANUiiG2wC1qawP66qlTugJeL5HyzMpfr8lLK+jMQirGzNod0B12cFB/9q838Ru27sBwfw78/rdoU7RERz6A=="],

    "is-async-function": ["is-async-function@2.1.1", "", { "dependencies": { "async-function": "^1.0.0", "call-bound": "^1.0.3", "get-proto": "^1.0.1", "has-tostringtag": "^1.0.2", "safe-regex-test": "^1.1.0" } }, "sha512-9dgM/cZBnNvjzaMYHVoxxfPj2QXt22Ev7SuuPrs+xav0ukGB0S6d4ydZdEiM48kLx5kDV+QBPrpVnFyefL8kkQ=="],
@@ -978,10 +1039,18 @@

    "react-dropzone": ["react-dropzone@15.0.0", "", { "dependencies": { "attr-accept": "^2.2.4", "file-selector": "^2.1.0", "prop-types": "^15.8.1" }, "peerDependencies": { "react": ">= 16.8 || 18.0.0" } }, "sha512-lGjYV/EoqEjEWPnmiSvH4v5IoIAwQM2W4Z1C0Q/Pw2xD0eVzKPS359BQTUMum+1fa0kH2nrKjuavmTPOGhpLPg=="],

-    "react-is": ["react-is@16.13.1", "", {}, "sha512-24e6ynE2H+OKt4kqsOvNd8kBpV65zoxbA4BVsEOB3ARVWQki/DHzaUoC5KuON/BiccDaCCTZBuOcfZs70kR8bQ=="],
+    "react-is": ["react-is@17.0.2", "", {}, "sha512-w2GsyukL62IJnlaff/nRegPQR94C/XXamvMWmSHRJ4y7Ts/4ocGRmTHvOs8PSE6pB3dWOrD/nueuU5sduBsQ4w=="],
+
+    "react-redux": ["react-redux@9.2.0", "", { "dependencies": { "@types/use-sync-external-store": "^0.0.6", "use-sync-external-store": "^1.4.0" }, "peerDependencies": { "@types/react": "^18.2.25 || ^19", "react": "^18.0 || ^19", "redux": "^5.0.0" }, "optionalPeers": ["@types/react", "redux"] }, "sha512-ROY9fvHhwOD9ySfrF0wmvu//bKCQ6AeZZq1nJNtbDC+kk5DuSuNX/n6YWYF/SYy7bSba4D4FSz8DJeKY/S/r+g=="],
+
+    "recharts": ["recharts@3.8.1", "", { "dependencies": { "@reduxjs/toolkit": "^1.9.0 || 2.x.x", "clsx": "^2.1.1", "decimal.js-light": "^2.5.1", "es-toolkit": "^1.39.3", "eventemitter3": "^5.0.1", "immer": "^10.1.1", "react-redux": "8.x.x || 9.x.x", "reselect": "5.1.1", "tiny-invariant": "^1.3.3", "use-sync-external-store": "^1.2.2", "victory-vendor": "^37.0.2" }, "peerDependencies": { "react": "^16.8.0 || ^17.0.0 || ^18.0.0 || ^19.0.0", "react-dom": "^16.0.0 || ^17.0.0 || ^18.0.0 || ^19.0.0", "react-is": "^16.8.0 || ^17.0.0 || ^18.0.0 || ^19.0.0" } }, "sha512-mwzmO1s9sFL0TduUpwndxCUNoXsBw3u3E/0+A+cLcrSfQitSG62L32N69GhqUrrT5qKcAE3pCGVINC6pqkBBQg=="],

    "redent": ["redent@3.0.0", "", { "dependencies": { "indent-string": "^4.0.0", "strip-indent": "^3.0.0" } }, "sha512-6tDA8g98We0zd0GvVeMT9arEOnTw9qM03L9cJXaCjrip1OO764RDBLBfrB4cwzNGDj5OA5ioymC9GkizgWJDUg=="],

+    "redux": ["redux@5.0.1", "", {}, "sha512-M9/ELqF6fy8FwmkpnF0S3YKOqMyoWJ4+CS5Efg2ct3oY9daQvd/Pc71FpGZsVsbl3Cpb+IIcjBDUnnyBdQbq4w=="],
+
+    "redux-thunk": ["redux-thunk@3.1.0", "", { "peerDependencies": { "redux": "^5.0.0" } }, "sha512-NW2r5T6ksUKXCabzhL9z+h206HQw/NJkcLm1GPImRQ8IzfXwRGqjVhKJGauHirT0DAuyy6hjdnMZaRoAcy0Klw=="],
+
    "reflect.getprototypeof": ["reflect.getprototypeof@1.0.10", "", { "dependencies": { "call-bind": "^1.0.8", "define-properties": "^1.2.1", "es-abstract": "^1.23.9", "es-errors": "^1.3.0", "es-object-atoms": "^1.0.0", "get-intrinsic": "^1.2.7", "get-proto": "^1.0.1", "which-builtin-type": "^1.2.1" } }, "sha512-00o4I+DVrefhv+nX0ulyi3biSHCPDe+yLv5o/p6d/UVlirijB8E16FtfwSAi4g3tcqrQ4lRAqQSoFEZJehYEcw=="],

    "regexp.prototype.flags": ["regexp.prototype.flags@1.5.4", "", { "dependencies": { "call-bind": "^1.0.8", "define-properties": "^1.2.1", "es-errors": "^1.3.0", "get-proto": "^1.0.1", "gopd": "^1.2.0", "set-function-name": "^2.0.2" } }, "sha512-dYqgNSZbDwkaJ2ceRd9ojCGjBq+mOm9LmtXnAnEGyHhN/5R7iDW2TRw3h+o/jCFxus3P2LfWIIiwowAjANm7IA=="],
@@ -990,6 +1059,8 @@

    "requires-port": ["requires-port@1.0.0", "", {}, "sha512-KigOCHcocU3XODJxsu8i/j8T9tzT4adHiecwORRQ0ZZFcp7ahwXuRU1m+yuO90C5ZUyGeGfocHDI14M3L3yDAQ=="],

+    "reselect": ["reselect@5.1.1", "", {}, "sha512-K/BG6eIky/SBpzfHZv/dd+9JBFiS4SWV7FIujVyJRux6e45+73RaUHXLmIR1f7WOMaQ0U1km6qwklRQxpJJY0w=="],
+
    "resolve": ["resolve@1.22.11", "", { "dependencies": { "is-core-module": "^2.16.1", "path-parse": "^1.0.7", "supports-preserve-symlinks-flag": "^1.0.0" }, "bin": { "resolve": "bin/resolve" } }, "sha512-RfqAvLnMl313r7c9oclB1HhUEAezcpLjz95wFH4LVuhk9JF/r22qmVP9AMmOU4vMX7Q8pN8jwNg/CSpdFnMjTQ=="],

    "resolve-from": ["resolve-from@4.0.0", "", {}, "sha512-pb/MYmXstAkysRFx8piNI1tGFNQIFA3vkE3Gq4EuA1dF6gHp/+vgZqsCGJapvy8N3Q+4o7FwvquPJcnZ7RYy4g=="],
@@ -1096,6 +1167,8 @@

    "tapable": ["tapable@2.3.2", "", {}, "sha512-1MOpMXuhGzGL5TTCZFItxCc0AARf1EZFQkGqMm7ERKj8+Hgr5oLvJOVFcC+lRmR8hCe2S3jC4T5D7Vg/d7/fhA=="],

+    "tiny-invariant": ["tiny-invariant@1.3.3", "", {}, "sha512-+FbBPE1o9QAYvviau/qC5SE3caw21q3xkvWKBtja5vgqOWIHHJ3ioaq1VPfn/Szqctz2bU/oYeKd9/z5BL+PVg=="],
+
    "tinybench": ["tinybench@2.9.0", "", {}, "sha512-0+DUvqWMValLmha6lr4kD8iAMK1HzV0/aKnCtWb9v9641TnP/MFb7Pc2bxoxQjTXAErryXVgUOfv2YqNllqGeg=="],

    "tinyexec": ["tinyexec@0.3.2", "", {}, "sha512-KQQR9yN7R5+OSwaK0XQoj22pwHoTlgYqmUscPYoknOoWCWfj/5/ABTMRi69FrKU5ffPVh5QcFikpWJI/P1ocHA=="],
@@ -1152,6 +1225,10 @@

    "url-parse": ["url-parse@1.5.10", "", { "dependencies": { "querystringify": "^2.1.1", "requires-port": "^1.0.0" } }, "sha512-WypcfiRhfeUP9vvF0j6rw0J3hrWrw6iZv3+22h6iRMJ/8z1Tj6XfLP4DsUix5MhMPnXpiHDoKyoZ/bdCkwBCiQ=="],

+    "use-sync-external-store": ["use-sync-external-store@1.6.0", "", { "peerDependencies": { "react": "^16.8.0 || ^17.0.0 || ^18.0.0 || ^19.0.0" } }, "sha512-Pp6GSwGP/NrPIrxVFAIkOQeyw8lFenOHijQWkUTrDvrF4ALqylP2C/KCkeS9dpUM3KvYRQhna5vt7IL95+ZQ9w=="],
+
+    "victory-vendor": ["victory-vendor@37.3.6", "", { "dependencies": { "@types/d3-array": "^3.0.3", "@types/d3-ease": "^3.0.0", "@types/d3-interpolate": "^3.0.1", "@types/d3-scale": "^4.0.2", "@types/d3-shape": "^3.1.0", "@types/d3-time": "^3.0.0", "@types/d3-timer": "^3.0.0", "d3-array": "^3.1.6", "d3-ease": "^3.0.1", "d3-interpolate": "^3.0.1", "d3-scale": "^4.0.2", "d3-shape": "^3.1.0", "d3-time": "^3.0.0", "d3-timer": "^3.0.1" } }, "sha512-SbPDPdDBYp+5MJHhBCAyI7wKM3d5ivekigc2Dk2s7pgbZ9wIgIBYGVw4zGHBml/qTFbexrofXW6Gu4noGxrOwQ=="],
+
    "vite": ["vite@5.4.21", "", { "dependencies": { "esbuild": "^0.21.3", "postcss": "^8.4.43", "rollup": "^4.20.0" }, "optionalDependencies": { "fsevents": "~2.3.3" }, "peerDependencies": { "@types/node": "^18.0.0 || >=20.0.0", "less": "*", "lightningcss": "^1.21.0", "sass": "*", "sass-embedded": "*", "stylus": "*", "sugarss": "*", "terser": "^5.4.0" }, "optionalPeers": ["@types/node", "less", "lightningcss", "sass", "sass-embedded", "stylus", "sugarss", "terser"], "bin": { "vite": "bin/vite.js" } }, "sha512-o5a9xKjbtuhY6Bi5S3+HvbRERmouabWbyUcpXXUA1u+GNUKoROi9byOJ8M0nHbHYHkYICiMlqxkg1KkYmm25Sw=="],

    "vite-node": ["vite-node@2.1.8", "", { "dependencies": { "cac": "^6.7.14", "debug": "^4.3.7", "es-module-lexer": "^1.5.4", "pathe": "^1.1.2", "vite": "^5.0.0" }, "bin": { "vite-node": "vite-node.mjs" } }, "sha512-uPAwSr57kYjAUux+8E2j0q0Fxpn8M9VoyfGiRI8Kfktz9NcYMCenwY5RnZxnF1WTu3TGiYipirIzacLL3VVGFg=="],
@@ -1202,6 +1279,8 @@

    "@eslint-community/eslint-utils/eslint-visitor-keys": ["eslint-visitor-keys@3.4.3", "", {}, "sha512-wpc+LXeiyiisxPlEkUzU6svyS1frIO3Mgxj1fdy7Pm8Ygzguax2N3Fa/D/ag1WqbOprdI+uY6wMUl8/a2G+iag=="],

+    "@reduxjs/toolkit/immer": ["immer@11.1.4", "", {}, "sha512-XREFCPo6ksxVzP4E0ekD5aMdf8WMwmdNaz6vuvxgI40UaEiu6q3p8X52aU6GdyvLY3XXX/8R7JOTXStz/nBbRw=="],
+
    "@tailwindcss/oxide-wasm32-wasi/@emnapi/core": ["@emnapi/core@1.9.1", "", { "dependencies": { "@emnapi/wasi-threads": "1.2.0", "tslib": "^2.4.0" }, "bundled": true }, "sha512-mukuNALVsoix/w1BJwFzwXBN/dHeejQtuVzcDsfOEsdpCumXb/E9j8w11h5S54tT1xhifGfbbSm/ICrObRb3KA=="],

    "@tailwindcss/oxide-wasm32-wasi/@emnapi/runtime": ["@emnapi/runtime@1.9.1", "", { "dependencies": { "tslib": "^2.4.0" }, "bundled": true }, "sha512-VYi5+ZVLhpgK4hQ0TAjiQiZ6ol0oe4mBx7mVv7IflsiEp0OWoVsp/+f9Vc1hOhE0TtkORVrI1GvzyreqpgWtkA=="],
@@ -1254,7 +1333,7 @@

    "pretty-format/ansi-styles": ["ansi-styles@5.2.0", "", {}, "sha512-Cxwpt2SfTzTtXcfOlzGEee8O+c+MmUgGrNiBcXnuWxuFJHe6a5Hz7qwhwe5OgaSYI0IJvkLqWX1ASG+cJOkEiA=="],

-    "pretty-format/react-is": ["react-is@17.0.2", "", {}, "sha512-w2GsyukL62IJnlaff/nRegPQR94C/XXamvMWmSHRJ4y7Ts/4ocGRmTHvOs8PSE6pB3dWOrD/nueuU5sduBsQ4w=="],
+    "prop-types/react-is": ["react-is@16.13.1", "", {}, "sha512-24e6ynE2H+OKt4kqsOvNd8kBpV65zoxbA4BVsEOB3ARVWQki/DHzaUoC5KuON/BiccDaCCTZBuOcfZs70kR8bQ=="],

    "sharp/semver": ["semver@7.7.4", "", { "bin": { "semver": "bin/semver.js" } }, "sha512-vFKC2IEtQnVhpT78h1Yp8wzwrf8CM+MzKMHGJZfBtzhZNycRFnXsHk6E5TxIkkMsgNS7mdX3AGB7x2QM2di4lA=="],

--- a/frontend/package.json
+++ b/frontend/package.json
@@ -20,6 +20,7 @@
    "react": "19.1.0",
    "react-dom": "19.1.0",
    "react-dropzone": "^15.0.0",
+    "recharts": "^3.8.1",
    "sonner": "^2.0.7"
  },
  "devDependencies": {
--- a/frontend/src/app/(app)/berichte/page.tsx
+++ b/frontend/src/app/(app)/berichte/page.tsx
@@ -0,0 +1,262 @@
+"use client";
+
+import { useState } from "react";
+import { useQuery } from "@tanstack/react-query";
+import { api } from "@/lib/api";
+import type {
+  CaseReport,
+  DeadlineReport,
+  WorkloadReport,
+  BillingReport,
+} from "@/lib/types";
+import { Breadcrumb } from "@/components/layout/Breadcrumb";
+import { Skeleton } from "@/components/ui/Skeleton";
+import {
+  AlertTriangle,
+  RefreshCw,
+  Download,
+  Printer,
+  FolderOpen,
+  Clock,
+  Users,
+  Receipt,
+} from "lucide-react";
+import { CasesTab } from "@/components/reports/CasesTab";
+import { DeadlinesTab } from "@/components/reports/DeadlinesTab";
+import { WorkloadTab } from "@/components/reports/WorkloadTab";
+import { BillingTab } from "@/components/reports/BillingTab";
+
+type TabKey = "cases" | "deadlines" | "workload" | "billing";
+
+const TABS: { key: TabKey; label: string; icon: typeof FolderOpen }[] = [
+  { key: "cases", label: "Akten", icon: FolderOpen },
+  { key: "deadlines", label: "Fristen", icon: Clock },
+  { key: "workload", label: "Auslastung", icon: Users },
+  { key: "billing", label: "Abrechnung", icon: Receipt },
+];
+
+function getDefaultDateRange(): { from: string; to: string } {
+  const now = new Date();
+  const from = new Date(now.getFullYear() - 1, now.getMonth(), 1);
+  return {
+    from: from.toISOString().split("T")[0],
+    to: now.toISOString().split("T")[0],
+  };
+}
+
+function ReportSkeleton() {
+  return (
+    <div className="space-y-6">
+      <div className="grid grid-cols-1 gap-4 sm:grid-cols-3">
+        {[1, 2, 3].map((i) => (
+          <Skeleton key={i} className="h-24 rounded-xl" />
+        ))}
+      </div>
+      <Skeleton className="h-72 rounded-xl" />
+      <Skeleton className="h-48 rounded-xl" />
+    </div>
+  );
+}
+
+export default function BerichtePage() {
+  const [activeTab, setActiveTab] = useState<TabKey>("cases");
+  const defaults = getDefaultDateRange();
+  const [from, setFrom] = useState(defaults.from);
+  const [to, setTo] = useState(defaults.to);
+
+  const queryParams = `?from=${from}&to=${to}`;
+
+  const casesQuery = useQuery({
+    queryKey: ["reports", "cases", from, to],
+    queryFn: () => api.get<CaseReport>(`/reports/cases${queryParams}`),
+    enabled: activeTab === "cases",
+  });
+
+  const deadlinesQuery = useQuery({
+    queryKey: ["reports", "deadlines", from, to],
+    queryFn: () => api.get<DeadlineReport>(`/reports/deadlines${queryParams}`),
+    enabled: activeTab === "deadlines",
+  });
+
+  const workloadQuery = useQuery({
+    queryKey: ["reports", "workload", from, to],
+    queryFn: () => api.get<WorkloadReport>(`/reports/workload${queryParams}`),
+    enabled: activeTab === "workload",
+  });
+
+  const billingQuery = useQuery({
+    queryKey: ["reports", "billing", from, to],
+    queryFn: () => api.get<BillingReport>(`/reports/billing${queryParams}`),
+    enabled: activeTab === "billing",
+  });
+
+  const currentQuery = {
+    cases: casesQuery,
+    deadlines: deadlinesQuery,
+    workload: workloadQuery,
+    billing: billingQuery,
+  }[activeTab];
+
+  function exportCSV() {
+    if (!currentQuery.data) return;
+    let csv = "";
+    const data = currentQuery.data;
+
+    if (activeTab === "cases") {
+      const d = data as CaseReport;
+      csv = "Monat,Eroeffnet,Geschlossen,Aktiv\n";
+      csv += d.monthly
+        .map((r) => `${r.period},${r.opened},${r.closed},${r.active}`)
+        .join("\n");
+    } else if (activeTab === "deadlines") {
+      const d = data as DeadlineReport;
+      csv = "Monat,Gesamt,Eingehalten,Versaeumt,Ausstehend,Quote (%)\n";
+      csv += d.monthly
+        .map(
+          (r) =>
+            `${r.period},${r.total},${r.met},${r.missed},${r.pending},${r.compliance_rate.toFixed(1)}`,
+        )
+        .join("\n");
+    } else if (activeTab === "workload") {
+      const d = data as WorkloadReport;
+      csv = "Benutzer-ID,Aktive Akten,Fristen,Ueberfaellig,Erledigt\n";
+      csv += d.users
+        .map(
+          (r) =>
+            `${r.user_id},${r.active_cases},${r.deadlines},${r.overdue},${r.completed}`,
+        )
+        .join("\n");
+    } else if (activeTab === "billing") {
+      const d = data as BillingReport;
+      csv = "Monat,Aktiv,Geschlossen,Neu\n";
+      csv += d.monthly
+        .map(
+          (r) =>
+            `${r.period},${r.cases_active},${r.cases_closed},${r.cases_new}`,
+        )
+        .join("\n");
+    }
+
+    const blob = new Blob([csv], { type: "text/csv;charset=utf-8;" });
+    const url = URL.createObjectURL(blob);
+    const link = document.createElement("a");
+    link.href = url;
+    link.download = `bericht-${activeTab}-${from}-${to}.csv`;
+    link.click();
+    URL.revokeObjectURL(url);
+  }
+
+  return (
+    <div className="animate-fade-in mx-auto max-w-6xl space-y-6 print:max-w-none">
+      <div className="print:hidden">
+        <Breadcrumb items={[{ label: "Berichte" }]} />
+      </div>
+
+      <div className="flex flex-col gap-4 sm:flex-row sm:items-center sm:justify-between">
+        <div>
+          <h1 className="text-lg font-semibold text-neutral-900">Berichte</h1>
+          <p className="mt-0.5 text-sm text-neutral-500">
+            Statistiken und Auswertungen
+          </p>
+        </div>
+
+        <div className="flex items-center gap-3 print:hidden">
+          <div className="flex items-center gap-2 text-sm">
+            <label className="text-neutral-500">Von</label>
+            <input
+              type="date"
+              value={from}
+              onChange={(e) => setFrom(e.target.value)}
+              className="rounded-md border border-neutral-200 bg-white px-2.5 py-1.5 text-sm text-neutral-900 outline-none focus:border-neutral-400"
+            />
+            <label className="text-neutral-500">Bis</label>
+            <input
+              type="date"
+              value={to}
+              onChange={(e) => setTo(e.target.value)}
+              className="rounded-md border border-neutral-200 bg-white px-2.5 py-1.5 text-sm text-neutral-900 outline-none focus:border-neutral-400"
+            />
+          </div>
+
+          <button
+            onClick={exportCSV}
+            disabled={!currentQuery.data}
+            className="inline-flex items-center gap-1.5 rounded-md border border-neutral-200 bg-white px-3 py-1.5 text-sm font-medium text-neutral-700 transition-colors hover:bg-neutral-50 disabled:opacity-50"
+          >
+            <Download className="h-3.5 w-3.5" />
+            CSV
+          </button>
+
+          <button
+            onClick={() => window.print()}
+            className="inline-flex items-center gap-1.5 rounded-md border border-neutral-200 bg-white px-3 py-1.5 text-sm font-medium text-neutral-700 transition-colors hover:bg-neutral-50"
+          >
+            <Printer className="h-3.5 w-3.5" />
+            Drucken
+          </button>
+        </div>
+      </div>
+
+      {/* Tabs */}
+      <div className="border-b border-neutral-200 print:hidden">
+        <nav className="-mb-px flex gap-6">
+          {TABS.map((tab) => (
+            <button
+              key={tab.key}
+              onClick={() => setActiveTab(tab.key)}
+              className={`flex items-center gap-1.5 border-b-2 py-2.5 text-sm font-medium transition-colors ${
+                activeTab === tab.key
+                  ? "border-neutral-900 text-neutral-900"
+                  : "border-transparent text-neutral-500 hover:border-neutral-300 hover:text-neutral-700"
+              }`}
+            >
+              <tab.icon className="h-4 w-4" />
+              {tab.label}
+            </button>
+          ))}
+        </nav>
+      </div>
+
+      {/* Tab content */}
+      {currentQuery.isLoading && <ReportSkeleton />}
+
+      {currentQuery.error && (
+        <div className="py-12 text-center">
+          <div className="mx-auto mb-3 w-fit rounded-xl bg-red-50 p-3">
+            <AlertTriangle className="h-6 w-6 text-red-500" />
+          </div>
+          <h2 className="text-sm font-medium text-neutral-900">
+            Bericht konnte nicht geladen werden
+          </h2>
+          <p className="mt-1 text-sm text-neutral-500">
+            Bitte versuchen Sie es erneut.
+          </p>
+          <button
+            onClick={() => currentQuery.refetch()}
+            className="mt-4 inline-flex items-center gap-1.5 rounded-md bg-neutral-900 px-3 py-1.5 text-sm font-medium text-white transition-colors hover:bg-neutral-800"
+          >
+            <RefreshCw className="h-3.5 w-3.5" />
+            Erneut laden
+          </button>
+        </div>
+      )}
+
+      {!currentQuery.isLoading && !currentQuery.error && currentQuery.data && (
+        <>
+          {activeTab === "cases" && (
+            <CasesTab data={currentQuery.data as CaseReport} />
+          )}
+          {activeTab === "deadlines" && (
+            <DeadlinesTab data={currentQuery.data as DeadlineReport} />
+          )}
+          {activeTab === "workload" && (
+            <WorkloadTab data={currentQuery.data as WorkloadReport} />
+          )}
+          {activeTab === "billing" && (
+            <BillingTab data={currentQuery.data as BillingReport} />
+          )}
+        </>
+      )}
+    </div>
+  );
+}
--- a/frontend/src/app/(app)/cases/[id]/ki/page.tsx
+++ b/frontend/src/app/(app)/cases/[id]/ki/page.tsx
@@ -1,51 +0,0 @@
-"use client";
-
-import { useState } from "react";
-import { useParams } from "next/navigation";
-import { Brain, FileText, Search } from "lucide-react";
-import { CaseStrategy } from "@/components/ai/CaseStrategy";
-import { DocumentDrafter } from "@/components/ai/DocumentDrafter";
-import { SimilarCaseFinder } from "@/components/ai/SimilarCaseFinder";
-
-type AITab = "strategy" | "draft" | "similar";
-
-const TABS: { id: AITab; label: string; icon: typeof Brain }[] = [
-  { id: "strategy", label: "KI-Strategie", icon: Brain },
-  { id: "draft", label: "KI-Entwurf", icon: FileText },
-  { id: "similar", label: "Aehnliche Faelle", icon: Search },
-];
-
-export default function CaseAIPage() {
-  const { id } = useParams<{ id: string }>();
-  const [activeTab, setActiveTab] = useState<AITab>("strategy");
-
-  return (
-    <div>
-      {/* Sub-tabs */}
-      <div className="mb-6 flex gap-1 rounded-lg border border-neutral-200 bg-neutral-50 p-1">
-        {TABS.map((tab) => {
-          const isActive = activeTab === tab.id;
-          return (
-            <button
-              key={tab.id}
-              onClick={() => setActiveTab(tab.id)}
-              className={`inline-flex flex-1 items-center justify-center gap-1.5 rounded-md px-3 py-2 text-sm font-medium transition-colors ${
-                isActive
-                  ? "bg-white text-neutral-900 shadow-sm"
-                  : "text-neutral-500 hover:text-neutral-700"
-              }`}
-            >
-              <tab.icon className="h-4 w-4" />
-              {tab.label}
-            </button>
-          );
-        })}
-      </div>
-
-      {/* Content */}
-      {activeTab === "strategy" && <CaseStrategy caseId={id} />}
-      {activeTab === "draft" && <DocumentDrafter caseId={id} />}
-      {activeTab === "similar" && <SimilarCaseFinder caseId={id} />}
-    </div>
-  );
-}
--- a/frontend/src/app/(app)/cases/[id]/layout.tsx
+++ b/frontend/src/app/(app)/cases/[id]/layout.tsx
@@ -17,7 +17,6 @@ import {
  StickyNote,
  AlertTriangle,
  ScrollText,
-  Brain,
 } from "lucide-react";
 import { format } from "date-fns";
 import { de } from "date-fns/locale";
@@ -49,7 +48,6 @@ const TABS = [
  { segment: "mitarbeiter", label: "Mitarbeiter", icon: UserCheck },
  { segment: "notizen", label: "Notizen", icon: StickyNote },
  { segment: "protokoll", label: "Protokoll", icon: ScrollText },
-  { segment: "ki", label: "KI", icon: Brain },
 ] as const;

 const TAB_LABELS: Record<string, string> = {
@@ -60,7 +58,6 @@ const TAB_LABELS: Record<string, string> = {
  mitarbeiter: "Mitarbeiter",
  notizen: "Notizen",
  protokoll: "Protokoll",
-  ki: "KI",
 };

 function CaseDetailSkeleton() {
--- a/frontend/src/components/ai/CaseStrategy.tsx
+++ b/frontend/src/components/ai/CaseStrategy.tsx
@@ -1,226 +0,0 @@
-"use client";
-
-import { useMutation } from "@tanstack/react-query";
-import { api } from "@/lib/api";
-import type { StrategyRecommendation } from "@/lib/types";
-import {
-  Loader2,
-  Brain,
-  AlertTriangle,
-  ArrowRight,
-  Shield,
-  Calendar,
-  RefreshCw,
-} from "lucide-react";
-
-interface CaseStrategyProps {
-  caseId: string;
-}
-
-const PRIORITY_STYLES = {
-  high: "bg-red-50 text-red-700 border-red-200",
-  medium: "bg-amber-50 text-amber-700 border-amber-200",
-  low: "bg-emerald-50 text-emerald-700 border-emerald-200",
-} as const;
-
-const IMPORTANCE_STYLES = {
-  critical: "border-l-red-500",
-  important: "border-l-amber-500",
-  routine: "border-l-neutral-300",
-} as const;
-
-export function CaseStrategy({ caseId }: CaseStrategyProps) {
-  const mutation = useMutation({
-    mutationFn: () =>
-      api.post<StrategyRecommendation>("/ai/case-strategy", {
-        case_id: caseId,
-      }),
-  });
-
-  if (!mutation.data && !mutation.isPending && !mutation.isError) {
-    return (
-      <div className="flex flex-col items-center gap-3 py-8 text-center">
-        <div className="rounded-xl bg-neutral-100 p-3">
-          <Brain className="h-6 w-6 text-neutral-400" />
-        </div>
-        <div>
-          <p className="text-sm font-medium text-neutral-900">
-            KI-Strategieanalyse
-          </p>
-          <p className="mt-1 text-sm text-neutral-500">
-            Claude analysiert die Akte und gibt strategische Empfehlungen.
-          </p>
-        </div>
-        <button
-          onClick={() => mutation.mutate()}
-          className="inline-flex items-center gap-2 rounded-md bg-neutral-900 px-4 py-2 text-sm font-medium text-white transition-colors hover:bg-neutral-800"
-        >
-          <Brain className="h-4 w-4" />
-          Strategie analysieren
-        </button>
-      </div>
-    );
-  }
-
-  if (mutation.isPending) {
-    return (
-      <div className="flex flex-col items-center gap-3 py-12 text-center">
-        <Loader2 className="h-6 w-6 animate-spin text-neutral-400" />
-        <p className="text-sm text-neutral-500">
-          Claude analysiert die Akte...
-        </p>
-        <p className="text-xs text-neutral-400">
-          Dies kann bis zu 30 Sekunden dauern.
-        </p>
-      </div>
-    );
-  }
-
-  if (mutation.isError) {
-    return (
-      <div className="flex flex-col items-center gap-3 py-8 text-center">
-        <div className="rounded-xl bg-red-50 p-3">
-          <AlertTriangle className="h-6 w-6 text-red-500" />
-        </div>
-        <p className="text-sm text-neutral-900">Analyse fehlgeschlagen</p>
-        <button
-          onClick={() => mutation.mutate()}
-          className="inline-flex items-center gap-1 text-sm text-neutral-500 transition-colors hover:text-neutral-700"
-        >
-          <RefreshCw className="h-3.5 w-3.5" />
-          Erneut versuchen
-        </button>
-      </div>
-    );
-  }
-
-  const data = mutation.data!;
-
-  return (
-    <div className="space-y-6">
-      <div className="flex items-center justify-between">
-        <h3 className="text-sm font-semibold text-neutral-900">
-          KI-Strategieanalyse
-        </h3>
-        <button
-          onClick={() => mutation.mutate()}
-          className="inline-flex items-center gap-1 rounded-md border border-neutral-200 px-2.5 py-1.5 text-xs font-medium text-neutral-600 transition-colors hover:bg-neutral-50"
-        >
-          <RefreshCw className="h-3.5 w-3.5" />
-          Aktualisieren
-        </button>
-      </div>
-
-      {/* Summary */}
-      <div className="rounded-md border border-blue-100 bg-blue-50 px-4 py-3 text-sm text-blue-800">
-        {data.summary}
-      </div>
-
-      {/* Next Steps */}
-      {data.next_steps?.length > 0 && (
-        <div>
-          <h4 className="mb-2 flex items-center gap-1.5 text-xs font-semibold uppercase tracking-wide text-neutral-500">
-            <ArrowRight className="h-3.5 w-3.5" />
-            Naechste Schritte
-          </h4>
-          <div className="space-y-2">
-            {data.next_steps.map((step, i) => (
-              <div
-                key={i}
-                className="rounded-md border border-neutral-200 bg-white px-4 py-3"
-              >
-                <div className="flex items-start gap-3">
-                  <span
-                    className={`mt-0.5 inline-block shrink-0 rounded-full border px-2 py-0.5 text-xs font-medium ${PRIORITY_STYLES[step.priority]}`}
-                  >
-                    {step.priority === "high"
-                      ? "Hoch"
-                      : step.priority === "medium"
-                        ? "Mittel"
-                        : "Niedrig"}
-                  </span>
-                  <div className="min-w-0">
-                    <p className="text-sm font-medium text-neutral-900">
-                      {step.action}
-                    </p>
-                    <p className="mt-1 text-sm text-neutral-500">
-                      {step.reasoning}
-                    </p>
-                    {step.deadline && (
-                      <p className="mt-1 text-xs text-neutral-400">
-                        Frist: {step.deadline}
-                      </p>
-                    )}
-                  </div>
-                </div>
-              </div>
-            ))}
-          </div>
-        </div>
-      )}
-
-      {/* Risk Assessment */}
-      {data.risk_assessment?.length > 0 && (
-        <div>
-          <h4 className="mb-2 flex items-center gap-1.5 text-xs font-semibold uppercase tracking-wide text-neutral-500">
-            <Shield className="h-3.5 w-3.5" />
-            Risikobewertung
-          </h4>
-          <div className="space-y-2">
-            {data.risk_assessment.map((risk, i) => (
-              <div
-                key={i}
-                className="rounded-md border border-neutral-200 bg-white px-4 py-3"
-              >
-                <div className="flex items-start gap-3">
-                  <span
-                    className={`mt-0.5 inline-block shrink-0 rounded-full border px-2 py-0.5 text-xs font-medium ${PRIORITY_STYLES[risk.level]}`}
-                  >
-                    {risk.level === "high"
-                      ? "Hoch"
-                      : risk.level === "medium"
-                        ? "Mittel"
-                        : "Niedrig"}
-                  </span>
-                  <div className="min-w-0">
-                    <p className="text-sm font-medium text-neutral-900">
-                      {risk.risk}
-                    </p>
-                    <p className="mt-1 text-sm text-neutral-500">
-                      Massnahme: {risk.mitigation}
-                    </p>
-                  </div>
-                </div>
-              </div>
-            ))}
-          </div>
-        </div>
-      )}
-
-      {/* Timeline */}
-      {data.timeline?.length > 0 && (
-        <div>
-          <h4 className="mb-2 flex items-center gap-1.5 text-xs font-semibold uppercase tracking-wide text-neutral-500">
-            <Calendar className="h-3.5 w-3.5" />
-            Zeitplan
-          </h4>
-          <div className="space-y-1">
-            {data.timeline.map((item, i) => (
-              <div
-                key={i}
-                className={`border-l-2 py-2 pl-4 ${IMPORTANCE_STYLES[item.importance]}`}
-              >
-                <div className="flex items-baseline gap-2">
-                  <span className="shrink-0 text-xs font-medium text-neutral-400">
-                    {item.date}
-                  </span>
-                  <span className="text-sm text-neutral-900">{item.event}</span>
-                </div>
-              </div>
-            ))}
-          </div>
-        </div>
-      )}
-    </div>
-  );
-}
--- a/frontend/src/components/ai/DocumentDrafter.tsx
+++ b/frontend/src/components/ai/DocumentDrafter.tsx
@@ -1,198 +0,0 @@
-"use client";
-
-import { useState } from "react";
-import { useMutation } from "@tanstack/react-query";
-import { api } from "@/lib/api";
-import type { DocumentDraft, DraftDocumentRequest } from "@/lib/types";
-import { FileText, Loader2, Copy, Check, Download } from "lucide-react";
-
-const TEMPLATES = {
-  klageschrift: "Klageschrift",
-  klageerwiderung: "Klageerwiderung",
-  abmahnung: "Abmahnung",
-  schriftsatz: "Schriftsatz",
-  berufung: "Berufungsschrift",
-  antrag: "Antrag",
-  stellungnahme: "Stellungnahme",
-  gutachten: "Gutachten",
-  vertrag: "Vertrag",
-  vollmacht: "Vollmacht",
-  upc_claim: "UPC Statement of Claim",
-  upc_defence: "UPC Statement of Defence",
-  upc_counterclaim: "UPC Counterclaim for Revocation",
-  upc_injunction: "UPC Provisional Measures",
-} as const;
-
-const LANGUAGES = [
-  { value: "de", label: "Deutsch" },
-  { value: "en", label: "English" },
-  { value: "fr", label: "Francais" },
-] as const;
-
-const inputClass =
-  "w-full rounded-md border border-neutral-200 bg-white px-3 py-2 text-sm text-neutral-900 outline-none transition-colors focus:border-neutral-400 focus:ring-1 focus:ring-neutral-400";
-
-interface DocumentDrafterProps {
-  caseId: string;
-}
-
-export function DocumentDrafter({ caseId }: DocumentDrafterProps) {
-  const [templateType, setTemplateType] = useState("");
-  const [instructions, setInstructions] = useState("");
-  const [language, setLanguage] = useState("de");
-  const [copied, setCopied] = useState(false);
-
-  const mutation = useMutation({
-    mutationFn: (req: DraftDocumentRequest) =>
-      api.post<DocumentDraft>("/ai/draft-document", req),
-  });
-
-  function handleSubmit(e: React.FormEvent) {
-    e.preventDefault();
-    if (!templateType) return;
-    mutation.mutate({
-      case_id: caseId,
-      template_type: templateType,
-      instructions,
-      language,
-    });
-  }
-
-  function handleCopy() {
-    if (mutation.data?.content) {
-      navigator.clipboard.writeText(mutation.data.content);
-      setCopied(true);
-      setTimeout(() => setCopied(false), 2000);
-    }
-  }
-
-  function handleDownload() {
-    if (!mutation.data?.content) return;
-    const blob = new Blob([mutation.data.content], { type: "text/plain;charset=utf-8" });
-    const url = URL.createObjectURL(blob);
-    const a = document.createElement("a");
-    a.href = url;
-    a.download = `${templateType}_entwurf.txt`;
-    a.click();
-    URL.revokeObjectURL(url);
-  }
-
-  return (
-    <div className="space-y-4">
-      <form onSubmit={handleSubmit} className="space-y-3">
-        <div>
-          <label className="mb-1 block text-xs font-medium text-neutral-500">
-            Dokumenttyp
-          </label>
-          <select
-            value={templateType}
-            onChange={(e) => setTemplateType(e.target.value)}
-            className={inputClass}
-            disabled={mutation.isPending}
-          >
-            <option value="">Dokumenttyp waehlen...</option>
-            {Object.entries(TEMPLATES).map(([key, label]) => (
-              <option key={key} value={key}>
-                {label}
-              </option>
-            ))}
-          </select>
-        </div>
-
-        <div>
-          <label className="mb-1 block text-xs font-medium text-neutral-500">
-            Sprache
-          </label>
-          <select
-            value={language}
-            onChange={(e) => setLanguage(e.target.value)}
-            className={inputClass}
-            disabled={mutation.isPending}
-          >
-            {LANGUAGES.map((lang) => (
-              <option key={lang.value} value={lang.value}>
-                {lang.label}
-              </option>
-            ))}
-          </select>
-        </div>
-
-        <div>
-          <label className="mb-1 block text-xs font-medium text-neutral-500">
-            Anweisungen (optional)
-          </label>
-          <textarea
-            value={instructions}
-            onChange={(e) => setInstructions(e.target.value)}
-            placeholder="z.B. 'Fokus auf Patentanspruch 1, besonders die technischen Merkmale...'"
-            rows={3}
-            className={inputClass}
-            disabled={mutation.isPending}
-          />
-        </div>
-
-        <button
-          type="submit"
-          disabled={!templateType || mutation.isPending}
-          className="inline-flex items-center gap-2 rounded-md bg-neutral-900 px-4 py-2 text-sm font-medium text-white transition-colors hover:bg-neutral-800 disabled:opacity-50"
-        >
-          {mutation.isPending ? (
-            <>
-              <Loader2 className="h-4 w-4 animate-spin" />
-              Dokument wird erstellt...
-            </>
-          ) : (
-            <>
-              <FileText className="h-4 w-4" />
-              KI-Entwurf erstellen
-            </>
-          )}
-        </button>
-      </form>
-
-      {mutation.isError && (
-        <div className="rounded-md border border-red-200 bg-red-50 px-4 py-3 text-sm text-red-700">
-          Fehler beim Erstellen des Entwurfs. Bitte versuchen Sie es erneut.
-        </div>
-      )}
-
-      {mutation.data && (
-        <div className="space-y-3">
-          <div className="flex items-center justify-between">
-            <h4 className="text-sm font-medium text-neutral-900">
-              {mutation.data.title}
-            </h4>
-            <div className="flex items-center gap-2">
-              <button
-                onClick={handleCopy}
-                className="inline-flex items-center gap-1 rounded-md border border-neutral-200 px-2.5 py-1.5 text-xs font-medium text-neutral-600 transition-colors hover:bg-neutral-50"
-              >
-                {copied ? (
-                  <>
-                    <Check className="h-3.5 w-3.5 text-emerald-500" />
-                    Kopiert
-                  </>
-                ) : (
-                  <>
-                    <Copy className="h-3.5 w-3.5" />
-                    Kopieren
-                  </>
-                )}
-              </button>
-              <button
-                onClick={handleDownload}
-                className="inline-flex items-center gap-1 rounded-md border border-neutral-200 px-2.5 py-1.5 text-xs font-medium text-neutral-600 transition-colors hover:bg-neutral-50"
-              >
-                <Download className="h-3.5 w-3.5" />
-                Download
-              </button>
-            </div>
-          </div>
-          <pre className="max-h-[600px] overflow-auto whitespace-pre-wrap rounded-md border border-neutral-200 bg-neutral-50 p-4 text-sm text-neutral-800">
-            {mutation.data.content}
-          </pre>
-        </div>
-      )}
-    </div>
-  );
-}
--- a/frontend/src/components/ai/SimilarCaseFinder.tsx
+++ b/frontend/src/components/ai/SimilarCaseFinder.tsx
@@ -1,183 +0,0 @@
-"use client";
-
-import { useState } from "react";
-import { useMutation } from "@tanstack/react-query";
-import { api } from "@/lib/api";
-import type { SimilarCasesResponse } from "@/lib/types";
-import {
-  Loader2,
-  Search,
-  ExternalLink,
-  AlertTriangle,
-  Scale,
-  RefreshCw,
-} from "lucide-react";
-
-interface SimilarCaseFinderProps {
-  caseId: string;
-}
-
-const inputClass =
-  "w-full rounded-md border border-neutral-200 bg-white px-3 py-2 text-sm text-neutral-900 outline-none transition-colors focus:border-neutral-400 focus:ring-1 focus:ring-neutral-400";
-
-function RelevanceBadge({ score }: { score: number }) {
-  const pct = Math.round(score * 100);
-  let color = "bg-neutral-100 text-neutral-600";
-  if (pct >= 80) color = "bg-emerald-50 text-emerald-700";
-  else if (pct >= 60) color = "bg-blue-50 text-blue-700";
-  else if (pct >= 40) color = "bg-amber-50 text-amber-700";
-  return (
-    <span
-      className={`inline-block shrink-0 rounded-full px-2 py-0.5 text-xs font-medium ${color}`}
-    >
-      {pct}%
-    </span>
-  );
-}
-
-export function SimilarCaseFinder({ caseId }: SimilarCaseFinderProps) {
-  const [description, setDescription] = useState("");
-
-  const mutation = useMutation({
-    mutationFn: (req: { case_id: string; description: string }) =>
-      api.post<SimilarCasesResponse>("/ai/similar-cases", req),
-  });
-
-  function handleSearch(e?: React.FormEvent) {
-    e?.preventDefault();
-    mutation.mutate({ case_id: caseId, description });
-  }
-
-  return (
-    <div className="space-y-4">
-      <form onSubmit={handleSearch} className="space-y-3">
-        <div>
-          <label className="mb-1 block text-xs font-medium text-neutral-500">
-            Zusaetzliche Beschreibung (optional)
-          </label>
-          <textarea
-            value={description}
-            onChange={(e) => setDescription(e.target.value)}
-            placeholder="z.B. 'SEP-Lizenzierung im Mobilfunkbereich, FRAND-Verteidigung...'"
-            rows={2}
-            className={inputClass}
-            disabled={mutation.isPending}
-          />
-        </div>
-
-        <button
-          type="submit"
-          disabled={mutation.isPending}
-          className="inline-flex items-center gap-2 rounded-md bg-neutral-900 px-4 py-2 text-sm font-medium text-white transition-colors hover:bg-neutral-800 disabled:opacity-50"
-        >
-          {mutation.isPending ? (
-            <>
-              <Loader2 className="h-4 w-4 animate-spin" />
-              Suche laeuft...
-            </>
-          ) : (
-            <>
-              <Search className="h-4 w-4" />
-              Aehnliche Faelle suchen
-            </>
-          )}
-        </button>
-      </form>
-
-      {mutation.isError && (
-        <div className="flex flex-col items-center gap-3 py-6 text-center">
-          <div className="rounded-xl bg-red-50 p-3">
-            <AlertTriangle className="h-6 w-6 text-red-500" />
-          </div>
-          <p className="text-sm text-neutral-900">Suche fehlgeschlagen</p>
-          <p className="text-xs text-neutral-500">
-            Die youpc.org-Datenbank ist moeglicherweise nicht verfuegbar.
-          </p>
-          <button
-            onClick={() => handleSearch()}
-            className="inline-flex items-center gap-1 text-sm text-neutral-500 transition-colors hover:text-neutral-700"
-          >
-            <RefreshCw className="h-3.5 w-3.5" />
-            Erneut versuchen
-          </button>
-        </div>
-      )}
-
-      {mutation.data && (
-        <div className="space-y-3">
-          <div className="flex items-center justify-between">
-            <p className="text-xs text-neutral-500">
-              {mutation.data.count} aehnliche{" "}
-              {mutation.data.count === 1 ? "Fall" : "Faelle"} gefunden
-            </p>
-            <button
-              onClick={() => handleSearch()}
-              disabled={mutation.isPending}
-              className="inline-flex items-center gap-1 rounded-md border border-neutral-200 px-2.5 py-1.5 text-xs font-medium text-neutral-600 transition-colors hover:bg-neutral-50"
-            >
-              <RefreshCw className="h-3.5 w-3.5" />
-              Aktualisieren
-            </button>
-          </div>
-
-          {mutation.data.cases?.length === 0 && (
-            <div className="flex flex-col items-center gap-2 py-6 text-center">
-              <Scale className="h-6 w-6 text-neutral-300" />
-              <p className="text-sm text-neutral-500">
-                Keine aehnlichen UPC-Faelle gefunden.
-              </p>
-            </div>
-          )}
-
-          {mutation.data.cases?.map((c, i) => (
-            <div
-              key={i}
-              className="rounded-md border border-neutral-200 bg-white px-4 py-3"
-            >
-              <div className="flex items-start justify-between gap-3">
-                <div className="min-w-0 flex-1">
-                  <div className="flex items-center gap-2">
-                    <RelevanceBadge score={c.relevance} />
-                    <span className="text-xs font-medium text-neutral-400">
-                      {c.case_number}
-                    </span>
-                    {c.url && (
-                      <a
-                        href={c.url}
-                        target="_blank"
-                        rel="noopener noreferrer"
-                        className="text-neutral-400 transition-colors hover:text-neutral-600"
-                      >
-                        <ExternalLink className="h-3.5 w-3.5" />
-                      </a>
-                    )}
-                  </div>
-                  <p className="mt-1 text-sm font-medium text-neutral-900">
-                    {c.title}
-                  </p>
-                  <div className="mt-1 flex flex-wrap gap-x-3 text-xs text-neutral-400">
-                    {c.court && <span>{c.court}</span>}
-                    {c.date && <span>{c.date}</span>}
-                  </div>
-                </div>
-              </div>
-
-              <p className="mt-2 text-sm text-neutral-600">{c.explanation}</p>
-
-              {c.key_holdings && (
-                <div className="mt-2 rounded border border-neutral-100 bg-neutral-50 px-3 py-2">
-                  <p className="text-xs font-medium text-neutral-500">
-                    Relevante Entscheidungsgruende
-                  </p>
-                  <p className="mt-0.5 text-xs text-neutral-600">
-                    {c.key_holdings}
-                  </p>
-                </div>
-              )}
-            </div>
-          ))}
-        </div>
-      )}
-    </div>
-  );
-}
--- a/frontend/src/components/layout/Sidebar.tsx
+++ b/frontend/src/components/layout/Sidebar.tsx
@@ -8,6 +8,7 @@ import {
  Clock,
  Calendar,
  Brain,
+  BarChart3,
  Settings,
  Menu,
  X,
@@ -27,6 +28,7 @@ const allNavigation: NavItem[] = [
  { name: "Akten", href: "/cases", icon: FolderOpen },
  { name: "Fristen", href: "/fristen", icon: Clock },
  { name: "Termine", href: "/termine", icon: Calendar },
+  { name: "Berichte", href: "/berichte", icon: BarChart3 },
  { name: "AI Analyse", href: "/ai/extract", icon: Brain, permission: "ai_extraction" },
  { name: "Einstellungen", href: "/einstellungen", icon: Settings, permission: "manage_settings" },
 ];
--- a/frontend/src/components/reports/BillingTab.tsx
+++ b/frontend/src/components/reports/BillingTab.tsx
@@ -0,0 +1,240 @@
+"use client";
+
+import type { BillingReport } from "@/lib/types";
+import {
+  BarChart,
+  Bar,
+  XAxis,
+  YAxis,
+  CartesianGrid,
+  Tooltip,
+  ResponsiveContainer,
+  Legend,
+  LineChart,
+  Line,
+} from "recharts";
+import { Receipt, TrendingUp, FolderOpen } from "lucide-react";
+
+function formatMonth(period: string): string {
+  const [year, month] = period.split("-");
+  const months = [
+    "Jan",
+    "Feb",
+    "Mär",
+    "Apr",
+    "Mai",
+    "Jun",
+    "Jul",
+    "Aug",
+    "Sep",
+    "Okt",
+    "Nov",
+    "Dez",
+  ];
+  return `${months[parseInt(month, 10) - 1]} ${year.slice(2)}`;
+}
+
+export function BillingTab({ data }: { data: BillingReport }) {
+  const chartData = data.monthly.map((m) => ({
+    ...m,
+    name: formatMonth(m.period),
+  }));
+
+  const totalNew = data.monthly.reduce((sum, m) => sum + m.cases_new, 0);
+  const totalClosed = data.monthly.reduce((sum, m) => sum + m.cases_closed, 0);
+  const totalByType = data.by_type.reduce((sum, t) => sum + t.total, 0);
+
+  return (
+    <div className="space-y-6">
+      {/* Summary cards */}
+      <div className="grid grid-cols-1 gap-4 sm:grid-cols-3">
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <div className="flex items-center gap-2 text-sm text-neutral-500">
+            <FolderOpen className="h-4 w-4" />
+            Neue Mandate
+          </div>
+          <p className="mt-2 text-2xl font-semibold text-neutral-900">
+            {totalNew}
+          </p>
+          <p className="mt-1 text-xs text-neutral-500">im Zeitraum</p>
+        </div>
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <div className="flex items-center gap-2 text-sm text-neutral-500">
+            <Receipt className="h-4 w-4" />
+            Abgeschlossen
+          </div>
+          <p className="mt-2 text-2xl font-semibold text-neutral-900">
+            {totalClosed}
+          </p>
+          <p className="mt-1 text-xs text-neutral-500">abrechenbar</p>
+        </div>
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <div className="flex items-center gap-2 text-sm text-neutral-500">
+            <TrendingUp className="h-4 w-4" />
+            Verfahrensarten
+          </div>
+          <p className="mt-2 text-2xl font-semibold text-neutral-900">
+            {data.by_type.length}
+          </p>
+          <p className="mt-1 text-xs text-neutral-500">
+            {totalByType} Akten gesamt
+          </p>
+        </div>
+      </div>
+
+      {/* New cases trend */}
+      <div className="rounded-xl border border-neutral-200 bg-white p-5">
+        <h3 className="mb-4 text-sm font-medium text-neutral-900">
+          Umsatzentwicklung (Mandate)
+        </h3>
+        {chartData.length === 0 ? (
+          <p className="py-8 text-center text-sm text-neutral-400">
+            Keine Daten im gewählten Zeitraum
+          </p>
+        ) : (
+          <ResponsiveContainer width="100%" height={300}>
+            <LineChart data={chartData}>
+              <CartesianGrid strokeDasharray="3 3" stroke="#e5e5e5" />
+              <XAxis dataKey="name" tick={{ fontSize: 12 }} stroke="#a3a3a3" />
+              <YAxis
+                allowDecimals={false}
+                tick={{ fontSize: 12 }}
+                stroke="#a3a3a3"
+              />
+              <Tooltip
+                contentStyle={{
+                  border: "1px solid #e5e5e5",
+                  borderRadius: 8,
+                  fontSize: 13,
+                }}
+              />
+              <Legend wrapperStyle={{ fontSize: 13 }} />
+              <Line
+                type="monotone"
+                dataKey="cases_new"
+                name="Neue Mandate"
+                stroke="#171717"
+                strokeWidth={2}
+                dot={{ fill: "#171717", r: 4 }}
+              />
+              <Line
+                type="monotone"
+                dataKey="cases_closed"
+                name="Abgeschlossen"
+                stroke="#a3a3a3"
+                strokeWidth={2}
+                dot={{ fill: "#a3a3a3", r: 4 }}
+              />
+            </LineChart>
+          </ResponsiveContainer>
+        )}
+      </div>
+
+      {/* By type breakdown */}
+      <div className="grid grid-cols-1 gap-6 lg:grid-cols-2">
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <h3 className="mb-4 text-sm font-medium text-neutral-900">
+            Mandate nach Verfahrensart
+          </h3>
+          {data.by_type.length === 0 ? (
+            <p className="py-8 text-center text-sm text-neutral-400">
+              Keine Daten
+            </p>
+          ) : (
+            <ResponsiveContainer width="100%" height={250}>
+              <BarChart data={data.by_type} layout="vertical">
+                <CartesianGrid strokeDasharray="3 3" stroke="#e5e5e5" />
+                <XAxis
+                  type="number"
+                  allowDecimals={false}
+                  tick={{ fontSize: 12 }}
+                  stroke="#a3a3a3"
+                />
+                <YAxis
+                  type="category"
+                  dataKey="case_type"
+                  tick={{ fontSize: 12 }}
+                  stroke="#a3a3a3"
+                  width={100}
+                />
+                <Tooltip
+                  contentStyle={{
+                    border: "1px solid #e5e5e5",
+                    borderRadius: 8,
+                    fontSize: 13,
+                  }}
+                />
+                <Legend wrapperStyle={{ fontSize: 13 }} />
+                <Bar
+                  dataKey="active"
+                  name="Aktiv"
+                  stackId="a"
+                  fill="#171717"
+                />
+                <Bar
+                  dataKey="closed"
+                  name="Geschlossen"
+                  stackId="a"
+                  fill="#a3a3a3"
+                  radius={[0, 4, 4, 0]}
+                />
+              </BarChart>
+            </ResponsiveContainer>
+          )}
+        </div>
+
+        {/* Summary table */}
+        <div className="rounded-xl border border-neutral-200 bg-white">
+          <div className="border-b border-neutral-100 px-5 py-4">
+            <h3 className="text-sm font-medium text-neutral-900">
+              Zusammenfassung
+            </h3>
+          </div>
+          {data.by_type.length === 0 ? (
+            <p className="px-5 py-8 text-center text-sm text-neutral-400">
+              Keine Daten
+            </p>
+          ) : (
+            <div className="overflow-x-auto">
+              <table className="w-full text-sm">
+                <thead>
+                  <tr className="border-b border-neutral-100 text-left text-neutral-500">
+                    <th className="px-5 py-3 font-medium">Verfahrensart</th>
+                    <th className="px-5 py-3 font-medium text-right">Aktiv</th>
+                    <th className="px-5 py-3 font-medium text-right">
+                      Geschlossen
+                    </th>
+                    <th className="px-5 py-3 font-medium text-right">
+                      Gesamt
+                    </th>
+                  </tr>
+                </thead>
+                <tbody>
+                  {data.by_type.map((t) => (
+                    <tr
+                      key={t.case_type}
+                      className="border-b border-neutral-50 last:border-b-0"
+                    >
+                      <td className="px-5 py-3 text-neutral-900">
+                        {t.case_type}
+                      </td>
+                      <td className="px-5 py-3 text-right text-neutral-600">
+                        {t.active}
+                      </td>
+                      <td className="px-5 py-3 text-right text-neutral-600">
+                        {t.closed}
+                      </td>
+                      <td className="px-5 py-3 text-right font-medium text-neutral-900">
+                        {t.total}
+                      </td>
+                    </tr>
+                  ))}
+                </tbody>
+              </table>
+            </div>
+          )}
+        </div>
+      </div>
+    </div>
+  );
+}
--- a/frontend/src/components/reports/CasesTab.tsx
+++ b/frontend/src/components/reports/CasesTab.tsx
@@ -0,0 +1,223 @@
+"use client";
+
+import type { CaseReport } from "@/lib/types";
+import {
+  BarChart,
+  Bar,
+  XAxis,
+  YAxis,
+  CartesianGrid,
+  Tooltip,
+  ResponsiveContainer,
+  Legend,
+  PieChart,
+  Pie,
+  Cell,
+} from "recharts";
+import { FolderOpen, TrendingUp, TrendingDown } from "lucide-react";
+
+const COLORS = [
+  "#171717",
+  "#525252",
+  "#a3a3a3",
+  "#d4d4d4",
+  "#737373",
+  "#404040",
+  "#e5e5e5",
+  "#262626",
+];
+
+function formatMonth(period: string): string {
+  const [year, month] = period.split("-");
+  const months = [
+    "Jan",
+    "Feb",
+    "Mär",
+    "Apr",
+    "Mai",
+    "Jun",
+    "Jul",
+    "Aug",
+    "Sep",
+    "Okt",
+    "Nov",
+    "Dez",
+  ];
+  return `${months[parseInt(month, 10) - 1]} ${year.slice(2)}`;
+}
+
+export function CasesTab({ data }: { data: CaseReport }) {
+  const chartData = data.monthly.map((m) => ({
+    ...m,
+    name: formatMonth(m.period),
+  }));
+
+  return (
+    <div className="space-y-6">
+      {/* Summary cards */}
+      <div className="grid grid-cols-1 gap-4 sm:grid-cols-3">
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <div className="flex items-center gap-2 text-sm text-neutral-500">
+            <FolderOpen className="h-4 w-4" />
+            Eröffnet
+          </div>
+          <p className="mt-2 text-2xl font-semibold text-neutral-900">
+            {data.total.opened}
+          </p>
+        </div>
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <div className="flex items-center gap-2 text-sm text-neutral-500">
+            <TrendingDown className="h-4 w-4" />
+            Geschlossen
+          </div>
+          <p className="mt-2 text-2xl font-semibold text-neutral-900">
+            {data.total.closed}
+          </p>
+        </div>
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <div className="flex items-center gap-2 text-sm text-neutral-500">
+            <TrendingUp className="h-4 w-4" />
+            Aktiv
+          </div>
+          <p className="mt-2 text-2xl font-semibold text-emerald-600">
+            {data.total.active}
+          </p>
+        </div>
+      </div>
+
+      {/* Bar chart: opened/closed per month */}
+      <div className="rounded-xl border border-neutral-200 bg-white p-5">
+        <h3 className="mb-4 text-sm font-medium text-neutral-900">
+          Akten pro Monat
+        </h3>
+        {chartData.length === 0 ? (
+          <p className="py-8 text-center text-sm text-neutral-400">
+            Keine Daten im gewählten Zeitraum
+          </p>
+        ) : (
+          <ResponsiveContainer width="100%" height={300}>
+            <BarChart data={chartData}>
+              <CartesianGrid strokeDasharray="3 3" stroke="#e5e5e5" />
+              <XAxis dataKey="name" tick={{ fontSize: 12 }} stroke="#a3a3a3" />
+              <YAxis
+                allowDecimals={false}
+                tick={{ fontSize: 12 }}
+                stroke="#a3a3a3"
+              />
+              <Tooltip
+                contentStyle={{
+                  border: "1px solid #e5e5e5",
+                  borderRadius: 8,
+                  fontSize: 13,
+                }}
+              />
+              <Legend wrapperStyle={{ fontSize: 13 }} />
+              <Bar
+                dataKey="opened"
+                name="Eröffnet"
+                fill="#171717"
+                radius={[4, 4, 0, 0]}
+              />
+              <Bar
+                dataKey="closed"
+                name="Geschlossen"
+                fill="#a3a3a3"
+                radius={[4, 4, 0, 0]}
+              />
+            </BarChart>
+          </ResponsiveContainer>
+        )}
+      </div>
+
+      {/* Pie charts row */}
+      <div className="grid grid-cols-1 gap-6 lg:grid-cols-2">
+        {/* By type */}
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <h3 className="mb-4 text-sm font-medium text-neutral-900">
+            Nach Verfahrensart
+          </h3>
+          {data.by_type.length === 0 ? (
+            <p className="py-8 text-center text-sm text-neutral-400">
+              Keine Daten
+            </p>
+          ) : (
+            <div className="flex items-center gap-4">
+              <ResponsiveContainer width="50%" height={200}>
+                <PieChart>
+                  <Pie
+                    data={data.by_type}
+                    dataKey="count"
+                    nameKey="case_type"
+                    cx="50%"
+                    cy="50%"
+                    innerRadius={40}
+                    outerRadius={80}
+                  >
+                    {data.by_type.map((_, i) => (
+                      <Cell
+                        key={i}
+                        fill={COLORS[i % COLORS.length]}
+                      />
+                    ))}
+                  </Pie>
+                  <Tooltip />
+                </PieChart>
+              </ResponsiveContainer>
+              <div className="flex-1 space-y-2">
+                {data.by_type.map((item, i) => (
+                  <div key={i} className="flex items-center gap-2 text-sm">
+                    <div
+                      className="h-3 w-3 rounded-full"
+                      style={{
+                        backgroundColor: COLORS[i % COLORS.length],
+                      }}
+                    />
+                    <span className="text-neutral-600">{item.case_type}</span>
+                    <span className="ml-auto font-medium text-neutral-900">
+                      {item.count}
+                    </span>
+                  </div>
+                ))}
+              </div>
+            </div>
+          )}
+        </div>
+
+        {/* By court */}
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <h3 className="mb-4 text-sm font-medium text-neutral-900">
+            Nach Gericht
+          </h3>
+          {data.by_court.length === 0 ? (
+            <p className="py-8 text-center text-sm text-neutral-400">
+              Keine Daten
+            </p>
+          ) : (
+            <div className="space-y-3">
+              {data.by_court.map((item, i) => {
+                const maxCount = Math.max(...data.by_court.map((c) => c.count));
+                const pct = maxCount > 0 ? (item.count / maxCount) * 100 : 0;
+                return (
+                  <div key={i}>
+                    <div className="flex items-center justify-between text-sm">
+                      <span className="text-neutral-600">{item.court}</span>
+                      <span className="font-medium text-neutral-900">
+                        {item.count}
+                      </span>
+                    </div>
+                    <div className="mt-1 h-2 rounded-full bg-neutral-100">
+                      <div
+                        className="h-2 rounded-full bg-neutral-900 transition-all"
+                        style={{ width: `${pct}%` }}
+                      />
+                    </div>
+                  </div>
+                );
+              })}
+            </div>
+          )}
+        </div>
+      </div>
+    </div>
+  );
+}
--- a/frontend/src/components/reports/DeadlinesTab.tsx
+++ b/frontend/src/components/reports/DeadlinesTab.tsx
@@ -0,0 +1,204 @@
+"use client";
+
+import type { DeadlineReport } from "@/lib/types";
+import Link from "next/link";
+import {
+  LineChart,
+  Line,
+  XAxis,
+  YAxis,
+  CartesianGrid,
+  Tooltip,
+  ResponsiveContainer,
+  Legend,
+} from "recharts";
+import { CheckCircle, XCircle, Clock, AlertTriangle } from "lucide-react";
+
+function formatMonth(period: string): string {
+  const [year, month] = period.split("-");
+  const months = [
+    "Jan",
+    "Feb",
+    "Mär",
+    "Apr",
+    "Mai",
+    "Jun",
+    "Jul",
+    "Aug",
+    "Sep",
+    "Okt",
+    "Nov",
+    "Dez",
+  ];
+  return `${months[parseInt(month, 10) - 1]} ${year.slice(2)}`;
+}
+
+function formatDate(dateStr: string): string {
+  const d = new Date(dateStr);
+  return d.toLocaleDateString("de-DE", {
+    day: "2-digit",
+    month: "2-digit",
+    year: "numeric",
+  });
+}
+
+export function DeadlinesTab({ data }: { data: DeadlineReport }) {
+  const chartData = data.monthly.map((m) => ({
+    ...m,
+    name: formatMonth(m.period),
+    compliance_rate: Math.round(m.compliance_rate * 10) / 10,
+  }));
+
+  const complianceColor =
+    data.total.compliance_rate >= 90
+      ? "text-emerald-600"
+      : data.total.compliance_rate >= 70
+        ? "text-amber-600"
+        : "text-red-600";
+
+  return (
+    <div className="space-y-6">
+      {/* Summary cards */}
+      <div className="grid grid-cols-2 gap-4 sm:grid-cols-4">
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <div className="flex items-center gap-2 text-sm text-neutral-500">
+            <Clock className="h-4 w-4" />
+            Gesamt
+          </div>
+          <p className="mt-2 text-2xl font-semibold text-neutral-900">
+            {data.total.total}
+          </p>
+        </div>
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <div className="flex items-center gap-2 text-sm text-neutral-500">
+            <CheckCircle className="h-4 w-4" />
+            Eingehalten
+          </div>
+          <p className="mt-2 text-2xl font-semibold text-emerald-600">
+            {data.total.met}
+          </p>
+        </div>
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <div className="flex items-center gap-2 text-sm text-neutral-500">
+            <XCircle className="h-4 w-4" />
+            Versäumt
+          </div>
+          <p className="mt-2 text-2xl font-semibold text-red-600">
+            {data.total.missed}
+          </p>
+        </div>
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <div className="flex items-center gap-2 text-sm text-neutral-500">
+            <CheckCircle className="h-4 w-4" />
+            Einhaltungsquote
+          </div>
+          <p className={`mt-2 text-2xl font-semibold ${complianceColor}`}>
+            {data.total.compliance_rate.toFixed(1)}%
+          </p>
+        </div>
+      </div>
+
+      {/* Compliance rate over time */}
+      <div className="rounded-xl border border-neutral-200 bg-white p-5">
+        <h3 className="mb-4 text-sm font-medium text-neutral-900">
+          Fristeneinhaltung im Zeitverlauf
+        </h3>
+        {chartData.length === 0 ? (
+          <p className="py-8 text-center text-sm text-neutral-400">
+            Keine Daten im gewählten Zeitraum
+          </p>
+        ) : (
+          <ResponsiveContainer width="100%" height={300}>
+            <LineChart data={chartData}>
+              <CartesianGrid strokeDasharray="3 3" stroke="#e5e5e5" />
+              <XAxis dataKey="name" tick={{ fontSize: 12 }} stroke="#a3a3a3" />
+              <YAxis
+                domain={[0, 100]}
+                tick={{ fontSize: 12 }}
+                stroke="#a3a3a3"
+                unit="%"
+              />
+              <Tooltip
+                contentStyle={{
+                  border: "1px solid #e5e5e5",
+                  borderRadius: 8,
+                  fontSize: 13,
+                }}
+                formatter={(value) => [`${value}%`, "Quote"]}
+              />
+              <Legend wrapperStyle={{ fontSize: 13 }} />
+              <Line
+                type="monotone"
+                dataKey="compliance_rate"
+                name="Einhaltungsquote"
+                stroke="#171717"
+                strokeWidth={2}
+                dot={{ fill: "#171717", r: 4 }}
+                activeDot={{ r: 6 }}
+              />
+            </LineChart>
+          </ResponsiveContainer>
+        )}
+      </div>
+
+      {/* Missed deadlines table */}
+      <div className="rounded-xl border border-neutral-200 bg-white">
+        <div className="border-b border-neutral-100 px-5 py-4">
+          <h3 className="text-sm font-medium text-neutral-900">
+            Versäumte Fristen
+          </h3>
+        </div>
+        {data.missed.length === 0 ? (
+          <div className="px-5 py-8 text-center">
+            <CheckCircle className="mx-auto h-8 w-8 text-emerald-400" />
+            <p className="mt-2 text-sm text-neutral-500">
+              Keine versäumten Fristen im gewählten Zeitraum
+            </p>
+          </div>
+        ) : (
+          <div className="overflow-x-auto">
+            <table className="w-full text-sm">
+              <thead>
+                <tr className="border-b border-neutral-100 text-left text-neutral-500">
+                  <th className="px-5 py-3 font-medium">Frist</th>
+                  <th className="px-5 py-3 font-medium">Akte</th>
+                  <th className="px-5 py-3 font-medium">Fällig am</th>
+                  <th className="px-5 py-3 font-medium text-right">
+                    Tage überfällig
+                  </th>
+                </tr>
+              </thead>
+              <tbody>
+                {data.missed.map((d) => (
+                  <tr
+                    key={d.id}
+                    className="border-b border-neutral-50 last:border-b-0"
+                  >
+                    <td className="px-5 py-3 text-neutral-900">{d.title}</td>
+                    <td className="px-5 py-3">
+                      <Link
+                        href={`/cases/${d.case_id}`}
+                        className="text-neutral-600 hover:text-neutral-900"
+                      >
+                        {d.case_number} — {d.case_title}
+                      </Link>
+                    </td>
+                    <td className="px-5 py-3 text-neutral-600">
+                      {formatDate(d.due_date)}
+                    </td>
+                    <td className="px-5 py-3 text-right">
+                      <span className="inline-flex items-center gap-1 rounded-full bg-red-50 px-2 py-0.5 text-xs font-medium text-red-700">
+                        <AlertTriangle className="h-3 w-3" />
+                        {d.days_overdue}
+                      </span>
+                    </td>
+                  </tr>
+                ))}
+              </tbody>
+            </table>
+          </div>
+        )}
+      </div>
+    </div>
+  );
+}
--- a/frontend/src/components/reports/WorkloadTab.tsx
+++ b/frontend/src/components/reports/WorkloadTab.tsx
@@ -0,0 +1,187 @@
+"use client";
+
+import type { WorkloadReport } from "@/lib/types";
+import {
+  BarChart,
+  Bar,
+  XAxis,
+  YAxis,
+  CartesianGrid,
+  Tooltip,
+  ResponsiveContainer,
+  Legend,
+} from "recharts";
+import { Users, AlertTriangle, CheckCircle } from "lucide-react";
+
+export function WorkloadTab({ data }: { data: WorkloadReport }) {
+  const chartData = data.users.map((u, i) => ({
+    name: `Nutzer ${i + 1}`,
+    user_id: u.user_id,
+    active_cases: u.active_cases,
+    deadlines: u.deadlines,
+    overdue: u.overdue,
+    completed: u.completed,
+  }));
+
+  const totalCases = data.users.reduce((sum, u) => sum + u.active_cases, 0);
+  const totalOverdue = data.users.reduce((sum, u) => sum + u.overdue, 0);
+  const totalCompleted = data.users.reduce((sum, u) => sum + u.completed, 0);
+
+  return (
+    <div className="space-y-6">
+      {/* Summary cards */}
+      <div className="grid grid-cols-1 gap-4 sm:grid-cols-3">
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <div className="flex items-center gap-2 text-sm text-neutral-500">
+            <Users className="h-4 w-4" />
+            Mitarbeiter
+          </div>
+          <p className="mt-2 text-2xl font-semibold text-neutral-900">
+            {data.users.length}
+          </p>
+          <p className="mt-1 text-xs text-neutral-500">
+            {totalCases} aktive Akten gesamt
+          </p>
+        </div>
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <div className="flex items-center gap-2 text-sm text-neutral-500">
+            <AlertTriangle className="h-4 w-4" />
+            Überfällige Fristen
+          </div>
+          <p className="mt-2 text-2xl font-semibold text-red-600">
+            {totalOverdue}
+          </p>
+        </div>
+        <div className="rounded-xl border border-neutral-200 bg-white p-5">
+          <div className="flex items-center gap-2 text-sm text-neutral-500">
+            <CheckCircle className="h-4 w-4" />
+            Erledigte Fristen
+          </div>
+          <p className="mt-2 text-2xl font-semibold text-emerald-600">
+            {totalCompleted}
+          </p>
+        </div>
+      </div>
+
+      {/* Stacked bar chart */}
+      <div className="rounded-xl border border-neutral-200 bg-white p-5">
+        <h3 className="mb-4 text-sm font-medium text-neutral-900">
+          Auslastung pro Mitarbeiter
+        </h3>
+        {chartData.length === 0 ? (
+          <p className="py-8 text-center text-sm text-neutral-400">
+            Keine Daten im gewählten Zeitraum
+          </p>
+        ) : (
+          <ResponsiveContainer width="100%" height={300}>
+            <BarChart data={chartData}>
+              <CartesianGrid strokeDasharray="3 3" stroke="#e5e5e5" />
+              <XAxis dataKey="name" tick={{ fontSize: 12 }} stroke="#a3a3a3" />
+              <YAxis
+                allowDecimals={false}
+                tick={{ fontSize: 12 }}
+                stroke="#a3a3a3"
+              />
+              <Tooltip
+                contentStyle={{
+                  border: "1px solid #e5e5e5",
+                  borderRadius: 8,
+                  fontSize: 13,
+                }}
+              />
+              <Legend wrapperStyle={{ fontSize: 13 }} />
+              <Bar
+                dataKey="active_cases"
+                name="Aktive Akten"
+                stackId="work"
+                fill="#171717"
+                radius={[0, 0, 0, 0]}
+              />
+              <Bar
+                dataKey="completed"
+                name="Erledigt"
+                stackId="deadlines"
+                fill="#a3a3a3"
+                radius={[0, 0, 0, 0]}
+              />
+              <Bar
+                dataKey="overdue"
+                name="Überfällig"
+                stackId="deadlines"
+                fill="#dc2626"
+                radius={[4, 4, 0, 0]}
+              />
+            </BarChart>
+          </ResponsiveContainer>
+        )}
+      </div>
+
+      {/* Table */}
+      <div className="rounded-xl border border-neutral-200 bg-white">
+        <div className="border-b border-neutral-100 px-5 py-4">
+          <h3 className="text-sm font-medium text-neutral-900">
+            Übersicht pro Mitarbeiter
+          </h3>
+        </div>
+        {data.users.length === 0 ? (
+          <p className="px-5 py-8 text-center text-sm text-neutral-400">
+            Keine Mitarbeiter mit zugewiesenen Akten
+          </p>
+        ) : (
+          <div className="overflow-x-auto">
+            <table className="w-full text-sm">
+              <thead>
+                <tr className="border-b border-neutral-100 text-left text-neutral-500">
+                  <th className="px-5 py-3 font-medium">Mitarbeiter</th>
+                  <th className="px-5 py-3 font-medium text-right">
+                    Aktive Akten
+                  </th>
+                  <th className="px-5 py-3 font-medium text-right">Fristen</th>
+                  <th className="px-5 py-3 font-medium text-right">
+                    Überfällig
+                  </th>
+                  <th className="px-5 py-3 font-medium text-right">
+                    Erledigt
+                  </th>
+                </tr>
+              </thead>
+              <tbody>
+                {data.users.map((u, i) => (
+                  <tr
+                    key={u.user_id}
+                    className="border-b border-neutral-50 last:border-b-0"
+                  >
+                    <td className="px-5 py-3 text-neutral-900">
+                      Nutzer {i + 1}
+                      <span className="ml-2 text-xs text-neutral-400">
+                        {u.user_id.slice(0, 8)}...
+                      </span>
+                    </td>
+                    <td className="px-5 py-3 text-right font-medium text-neutral-900">
+                      {u.active_cases}
+                    </td>
+                    <td className="px-5 py-3 text-right text-neutral-600">
+                      {u.deadlines}
+                    </td>
+                    <td className="px-5 py-3 text-right">
+                      {u.overdue > 0 ? (
+                        <span className="inline-flex items-center rounded-full bg-red-50 px-2 py-0.5 text-xs font-medium text-red-700">
+                          {u.overdue}
+                        </span>
+                      ) : (
+                        <span className="text-neutral-400">0</span>
+                      )}
+                    </td>
+                    <td className="px-5 py-3 text-right text-emerald-600">
+                      {u.completed}
+                    </td>
+                  </tr>
+                ))}
+              </tbody>
+            </table>
+          </div>
+        )}
+      </div>
+    </div>
+  );
+}
--- a/frontend/src/lib/types.ts
+++ b/frontend/src/lib/types.ts
@@ -330,80 +330,148 @@ export interface ExtractionResponse {
  count: number;
 }

-// AI Document Drafting
+// Notification types

-export interface DocumentDraft {
+export interface Notification {
+  id: string;
+  tenant_id: string;
+  user_id: string;
+  type: string;
+  entity_type?: string;
+  entity_id?: string;
  title: string;
-  content: string;
-  language: string;
+  body?: string;
+  sent_at?: string;
+  read_at?: string;
+  created_at: string;
 }

-export interface DraftDocumentRequest {
-  case_id: string;
-  template_type: string;
-  instructions: string;
-  language: string;
+export interface NotificationPreferences {
+  user_id: string;
+  tenant_id: string;
+  deadline_reminder_days: number[];
+  email_enabled: boolean;
+  daily_digest: boolean;
+  created_at: string;
+  updated_at: string;
 }

-export const TEMPLATE_TYPES: Record<string, string> = {
-  klageschrift: "Klageschrift",
-  klageerwiderung: "Klageerwiderung",
-  abmahnung: "Abmahnung",
-  schriftsatz: "Schriftsatz",
-  berufung: "Berufungsschrift",
-  antrag: "Antrag",
-  stellungnahme: "Stellungnahme",
-  gutachten: "Gutachten",
-  vertrag: "Vertrag",
-  vollmacht: "Vollmacht",
-  upc_claim: "UPC Statement of Claim",
-  upc_defence: "UPC Statement of Defence",
-  upc_counterclaim: "UPC Counterclaim for Revocation",
-  upc_injunction: "UPC Provisional Measures",
-};
+export interface NotificationListResponse {
+  data: Notification[];
+  total: number;
+}

-// AI Case Strategy
+// Audit log types

-export interface StrategyStep {
-  priority: "high" | "medium" | "low";
+export interface AuditLogEntry {
+  id: number;
+  tenant_id: string;
+  user_id?: string;
  action: string;
-  reasoning: string;
-  deadline?: string;
+  entity_type: string;
+  entity_id?: string;
+  old_values?: Record<string, unknown>;
+  new_values?: Record<string, unknown>;
+  ip_address?: string;
+  user_agent?: string;
+  created_at: string;
 }

-export interface RiskItem {
-  level: "high" | "medium" | "low";
-  risk: string;
-  mitigation: string;
+export interface AuditLogResponse {
+  entries: AuditLogEntry[];
+  total: number;
+  page: number;
+  limit: number;
 }

-export interface TimelineItem {
-  date: string;
-  event: string;
-  importance: "critical" | "important" | "routine";
+// Reporting types
+
+export interface CaseStats {
+  period: string;
+  opened: number;
+  closed: number;
+  active: number;
 }

-export interface StrategyRecommendation {
-  summary: string;
-  next_steps: StrategyStep[];
-  risk_assessment: RiskItem[];
-  timeline: TimelineItem[];
-}
-
-// AI Similar Case Finder
-
-export interface SimilarCase {
-  case_number: string;
-  title: string;
-  court: string;
-  date: string;
-  relevance: number;
-  explanation: string;
-  key_holdings: string;
-  url?: string;
-}
-
-export interface SimilarCasesResponse {
-  cases: SimilarCase[];
+export interface CasesByType {
+  case_type: string;
  count: number;
 }
+
+export interface CasesByCourt {
+  court: string;
+  count: number;
+}
+
+export interface CaseReport {
+  monthly: CaseStats[];
+  by_type: CasesByType[];
+  by_court: CasesByCourt[];
+  total: {
+    opened: number;
+    closed: number;
+    active: number;
+  };
+}
+
+export interface DeadlineCompliance {
+  period: string;
+  total: number;
+  met: number;
+  missed: number;
+  pending: number;
+  compliance_rate: number;
+}
+
+export interface MissedDeadline {
+  id: string;
+  title: string;
+  due_date: string;
+  case_id: string;
+  case_number: string;
+  case_title: string;
+  days_overdue: number;
+}
+
+export interface DeadlineReport {
+  monthly: DeadlineCompliance[];
+  missed: MissedDeadline[];
+  total: {
+    total: number;
+    met: number;
+    missed: number;
+    pending: number;
+    compliance_rate: number;
+  };
+}
+
+export interface UserWorkload {
+  user_id: string;
+  active_cases: number;
+  deadlines: number;
+  overdue: number;
+  completed: number;
+}
+
+export interface WorkloadReport {
+  users: UserWorkload[];
+}
+
+export interface BillingByMonth {
+  period: string;
+  cases_active: number;
+  cases_closed: number;
+  cases_new: number;
+}
+
+export interface BillingByType {
+  case_type: string;
+  active: number;
+  closed: number;
+  total: number;
+}
+
+export interface BillingReport {
+  monthly: BillingByMonth[];
+  by_type: BillingByType[];
+}