Compare commits
1 Commits
mai/pike/p
...
mai/knuth/
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
238811727d |
@@ -35,8 +35,6 @@ func (m *Middleware) RequireAuth(next http.Handler) http.Handler {
|
|||||||
}
|
}
|
||||||
|
|
||||||
ctx := ContextWithUserID(r.Context(), userID)
|
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
|
// Capture IP and user-agent for audit logging
|
||||||
ip := r.Header.Get("X-Forwarded-For")
|
ip := r.Header.Get("X-Forwarded-For")
|
||||||
@@ -45,6 +43,9 @@ func (m *Middleware) RequireAuth(next http.Handler) http.Handler {
|
|||||||
}
|
}
|
||||||
ctx = ContextWithRequestInfo(ctx, ip, r.UserAgent())
|
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))
|
next.ServeHTTP(w, r.WithContext(ctx))
|
||||||
})
|
})
|
||||||
}
|
}
|
||||||
|
|||||||
@@ -56,10 +56,9 @@ func (tr *TenantResolver) Resolve(next http.Handler) http.Handler {
|
|||||||
}
|
}
|
||||||
|
|
||||||
tenantID = parsed
|
tenantID = parsed
|
||||||
// Override the role from middleware with the correct one for this tenant
|
|
||||||
r = r.WithContext(ContextWithUserRole(r.Context(), role))
|
r = r.WithContext(ContextWithUserRole(r.Context(), role))
|
||||||
} else {
|
} else {
|
||||||
// Default to user's first tenant (role already set by middleware)
|
// Default to user's first tenant
|
||||||
first, err := tr.lookup.FirstTenantForUser(r.Context(), userID)
|
first, err := tr.lookup.FirstTenantForUser(r.Context(), userID)
|
||||||
if err != nil {
|
if err != nil {
|
||||||
slog.Error("failed to resolve default tenant", "error", err, "user_id", userID)
|
slog.Error("failed to resolve default tenant", "error", err, "user_id", userID)
|
||||||
@@ -71,6 +70,15 @@ func (tr *TenantResolver) Resolve(next http.Handler) http.Handler {
|
|||||||
return
|
return
|
||||||
}
|
}
|
||||||
tenantID = *first
|
tenantID = *first
|
||||||
|
|
||||||
|
// Also resolve role for default tenant
|
||||||
|
role, err := tr.lookup.GetUserRole(r.Context(), userID, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
slog.Error("failed to get role for default tenant", "error", err, "user_id", userID, "tenant_id", tenantID)
|
||||||
|
http.Error(w, `{"error":"internal error"}`, http.StatusInternalServerError)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
r = r.WithContext(ContextWithUserRole(r.Context(), role))
|
||||||
}
|
}
|
||||||
|
|
||||||
ctx := ContextWithTenantID(r.Context(), tenantID)
|
ctx := ContextWithTenantID(r.Context(), tenantID)
|
||||||
|
|||||||
@@ -86,7 +86,7 @@ func TestTenantResolver_FromHeader_NoAccess(t *testing.T) {
|
|||||||
|
|
||||||
func TestTenantResolver_DefaultsToFirst(t *testing.T) {
|
func TestTenantResolver_DefaultsToFirst(t *testing.T) {
|
||||||
tenantID := uuid.New()
|
tenantID := uuid.New()
|
||||||
tr := NewTenantResolver(&mockTenantLookup{tenantID: &tenantID})
|
tr := NewTenantResolver(&mockTenantLookup{tenantID: &tenantID, role: "owner"})
|
||||||
|
|
||||||
var gotTenantID uuid.UUID
|
var gotTenantID uuid.UUID
|
||||||
next := http.HandlerFunc(func(w http.ResponseWriter, r *http.Request) {
|
next := http.HandlerFunc(func(w http.ResponseWriter, r *http.Request) {
|
||||||
|
|||||||
66
backend/internal/handlers/billing_rates.go
Normal file
66
backend/internal/handlers/billing_rates.go
Normal file
@@ -0,0 +1,66 @@
|
|||||||
|
package handlers
|
||||||
|
|
||||||
|
import (
|
||||||
|
"encoding/json"
|
||||||
|
"net/http"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/auth"
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/services"
|
||||||
|
)
|
||||||
|
|
||||||
|
type BillingRateHandler struct {
|
||||||
|
svc *services.BillingRateService
|
||||||
|
}
|
||||||
|
|
||||||
|
func NewBillingRateHandler(svc *services.BillingRateService) *BillingRateHandler {
|
||||||
|
return &BillingRateHandler{svc: svc}
|
||||||
|
}
|
||||||
|
|
||||||
|
// List handles GET /api/billing-rates
|
||||||
|
func (h *BillingRateHandler) List(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
rates, err := h.svc.List(r.Context(), tenantID)
|
||||||
|
if err != nil {
|
||||||
|
internalError(w, "failed to list billing rates", err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, map[string]any{"billing_rates": rates})
|
||||||
|
}
|
||||||
|
|
||||||
|
// Upsert handles PUT /api/billing-rates
|
||||||
|
func (h *BillingRateHandler) Upsert(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var input services.UpsertBillingRateInput
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&input); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid JSON body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
if input.Rate < 0 {
|
||||||
|
writeError(w, http.StatusBadRequest, "rate must be non-negative")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if input.ValidFrom == "" {
|
||||||
|
writeError(w, http.StatusBadRequest, "valid_from is required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
rate, err := h.svc.Upsert(r.Context(), tenantID, input)
|
||||||
|
if err != nil {
|
||||||
|
internalError(w, "failed to upsert billing rate", err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, rate)
|
||||||
|
}
|
||||||
@@ -198,8 +198,9 @@ func (h *DeadlineHandlers) Delete(w http.ResponseWriter, r *http.Request) {
|
|||||||
return
|
return
|
||||||
}
|
}
|
||||||
|
|
||||||
if err := h.deadlines.Delete(r.Context(), tenantID, deadlineID); err != nil {
|
err = h.deadlines.Delete(r.Context(), tenantID, deadlineID)
|
||||||
writeError(w, http.StatusNotFound, "deadline not found")
|
if err != nil {
|
||||||
|
writeError(w, http.StatusNotFound, err.Error())
|
||||||
return
|
return
|
||||||
}
|
}
|
||||||
|
|
||||||
|
|||||||
170
backend/internal/handlers/invoices.go
Normal file
170
backend/internal/handlers/invoices.go
Normal file
@@ -0,0 +1,170 @@
|
|||||||
|
package handlers
|
||||||
|
|
||||||
|
import (
|
||||||
|
"encoding/json"
|
||||||
|
"net/http"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/auth"
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/services"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
)
|
||||||
|
|
||||||
|
type InvoiceHandler struct {
|
||||||
|
svc *services.InvoiceService
|
||||||
|
}
|
||||||
|
|
||||||
|
func NewInvoiceHandler(svc *services.InvoiceService) *InvoiceHandler {
|
||||||
|
return &InvoiceHandler{svc: svc}
|
||||||
|
}
|
||||||
|
|
||||||
|
// List handles GET /api/invoices?case_id=&status=
|
||||||
|
func (h *InvoiceHandler) List(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var caseID *uuid.UUID
|
||||||
|
if caseStr := r.URL.Query().Get("case_id"); caseStr != "" {
|
||||||
|
parsed, err := uuid.Parse(caseStr)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid case_id")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
caseID = &parsed
|
||||||
|
}
|
||||||
|
|
||||||
|
invoices, err := h.svc.List(r.Context(), tenantID, caseID, r.URL.Query().Get("status"))
|
||||||
|
if err != nil {
|
||||||
|
internalError(w, "failed to list invoices", err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, map[string]any{"invoices": invoices})
|
||||||
|
}
|
||||||
|
|
||||||
|
// Get handles GET /api/invoices/{id}
|
||||||
|
func (h *InvoiceHandler) Get(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
invoiceID, err := parsePathUUID(r, "id")
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid invoice ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
inv, err := h.svc.GetByID(r.Context(), tenantID, invoiceID)
|
||||||
|
if err != nil {
|
||||||
|
internalError(w, "failed to get invoice", err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if inv == nil {
|
||||||
|
writeError(w, http.StatusNotFound, "invoice not found")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, inv)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Create handles POST /api/invoices
|
||||||
|
func (h *InvoiceHandler) Create(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
userID, _ := auth.UserFromContext(r.Context())
|
||||||
|
|
||||||
|
var input services.CreateInvoiceInput
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&input); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid JSON body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
if input.ClientName == "" {
|
||||||
|
writeError(w, http.StatusBadRequest, "client_name is required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if input.CaseID == uuid.Nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "case_id is required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
inv, err := h.svc.Create(r.Context(), tenantID, userID, input)
|
||||||
|
if err != nil {
|
||||||
|
internalError(w, "failed to create invoice", err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusCreated, inv)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Update handles PUT /api/invoices/{id}
|
||||||
|
func (h *InvoiceHandler) Update(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
invoiceID, err := parsePathUUID(r, "id")
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid invoice ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var input services.UpdateInvoiceInput
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&input); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid JSON body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
inv, err := h.svc.Update(r.Context(), tenantID, invoiceID, input)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, err.Error())
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, inv)
|
||||||
|
}
|
||||||
|
|
||||||
|
// UpdateStatus handles PATCH /api/invoices/{id}/status
|
||||||
|
func (h *InvoiceHandler) UpdateStatus(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
invoiceID, err := parsePathUUID(r, "id")
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid invoice ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var body struct {
|
||||||
|
Status string `json:"status"`
|
||||||
|
}
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&body); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid JSON body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if body.Status == "" {
|
||||||
|
writeError(w, http.StatusBadRequest, "status is required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
inv, err := h.svc.UpdateStatus(r.Context(), tenantID, invoiceID, body.Status)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, err.Error())
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, inv)
|
||||||
|
}
|
||||||
@@ -1,109 +0,0 @@
|
|||||||
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)
|
|
||||||
}
|
|
||||||
209
backend/internal/handlers/time_entries.go
Normal file
209
backend/internal/handlers/time_entries.go
Normal file
@@ -0,0 +1,209 @@
|
|||||||
|
package handlers
|
||||||
|
|
||||||
|
import (
|
||||||
|
"encoding/json"
|
||||||
|
"net/http"
|
||||||
|
"strconv"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/auth"
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/services"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
)
|
||||||
|
|
||||||
|
type TimeEntryHandler struct {
|
||||||
|
svc *services.TimeEntryService
|
||||||
|
}
|
||||||
|
|
||||||
|
func NewTimeEntryHandler(svc *services.TimeEntryService) *TimeEntryHandler {
|
||||||
|
return &TimeEntryHandler{svc: svc}
|
||||||
|
}
|
||||||
|
|
||||||
|
// ListForCase handles GET /api/cases/{id}/time-entries
|
||||||
|
func (h *TimeEntryHandler) ListForCase(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
caseID, err := parsePathUUID(r, "id")
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid case ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
entries, err := h.svc.ListForCase(r.Context(), tenantID, caseID)
|
||||||
|
if err != nil {
|
||||||
|
internalError(w, "failed to list time entries", err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, map[string]any{"time_entries": entries})
|
||||||
|
}
|
||||||
|
|
||||||
|
// List handles GET /api/time-entries?case_id=&user_id=&from=&to=
|
||||||
|
func (h *TimeEntryHandler) List(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
limit, _ := strconv.Atoi(r.URL.Query().Get("limit"))
|
||||||
|
offset, _ := strconv.Atoi(r.URL.Query().Get("offset"))
|
||||||
|
limit, offset = clampPagination(limit, offset)
|
||||||
|
|
||||||
|
filter := services.TimeEntryFilter{
|
||||||
|
From: r.URL.Query().Get("from"),
|
||||||
|
To: r.URL.Query().Get("to"),
|
||||||
|
Limit: limit,
|
||||||
|
Offset: offset,
|
||||||
|
}
|
||||||
|
|
||||||
|
if caseStr := r.URL.Query().Get("case_id"); caseStr != "" {
|
||||||
|
caseID, err := uuid.Parse(caseStr)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid case_id")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
filter.CaseID = &caseID
|
||||||
|
}
|
||||||
|
if userStr := r.URL.Query().Get("user_id"); userStr != "" {
|
||||||
|
userID, err := uuid.Parse(userStr)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid user_id")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
filter.UserID = &userID
|
||||||
|
}
|
||||||
|
|
||||||
|
entries, total, err := h.svc.List(r.Context(), tenantID, filter)
|
||||||
|
if err != nil {
|
||||||
|
internalError(w, "failed to list time entries", err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, map[string]any{
|
||||||
|
"time_entries": entries,
|
||||||
|
"total": total,
|
||||||
|
})
|
||||||
|
}
|
||||||
|
|
||||||
|
// Create handles POST /api/cases/{id}/time-entries
|
||||||
|
func (h *TimeEntryHandler) Create(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
userID, _ := auth.UserFromContext(r.Context())
|
||||||
|
|
||||||
|
caseID, err := parsePathUUID(r, "id")
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid case ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var input services.CreateTimeEntryInput
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&input); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid JSON body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
input.CaseID = caseID
|
||||||
|
|
||||||
|
if input.Description == "" {
|
||||||
|
writeError(w, http.StatusBadRequest, "description is required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if input.DurationMinutes <= 0 {
|
||||||
|
writeError(w, http.StatusBadRequest, "duration_minutes must be positive")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if input.Date == "" {
|
||||||
|
writeError(w, http.StatusBadRequest, "date is required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
entry, err := h.svc.Create(r.Context(), tenantID, userID, input)
|
||||||
|
if err != nil {
|
||||||
|
internalError(w, "failed to create time entry", err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusCreated, entry)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Update handles PUT /api/time-entries/{id}
|
||||||
|
func (h *TimeEntryHandler) Update(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
entryID, err := parsePathUUID(r, "id")
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid time entry ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var input services.UpdateTimeEntryInput
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&input); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid JSON body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
entry, err := h.svc.Update(r.Context(), tenantID, entryID, input)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, err.Error())
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, entry)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Delete handles DELETE /api/time-entries/{id}
|
||||||
|
func (h *TimeEntryHandler) Delete(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
entryID, err := parsePathUUID(r, "id")
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid time entry ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
if err := h.svc.Delete(r.Context(), tenantID, entryID); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, err.Error())
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, map[string]string{"status": "deleted"})
|
||||||
|
}
|
||||||
|
|
||||||
|
// Summary handles GET /api/time-entries/summary?group_by=case|user|month&from=&to=
|
||||||
|
func (h *TimeEntryHandler) Summary(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
groupBy := r.URL.Query().Get("group_by")
|
||||||
|
if groupBy == "" {
|
||||||
|
groupBy = "case"
|
||||||
|
}
|
||||||
|
|
||||||
|
summaries, err := h.svc.Summary(r.Context(), tenantID, groupBy,
|
||||||
|
r.URL.Query().Get("from"), r.URL.Query().Get("to"))
|
||||||
|
if err != nil {
|
||||||
|
internalError(w, "failed to get summary", err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, map[string]any{"summary": summaries})
|
||||||
|
}
|
||||||
18
backend/internal/models/billing_rate.go
Normal file
18
backend/internal/models/billing_rate.go
Normal file
@@ -0,0 +1,18 @@
|
|||||||
|
package models
|
||||||
|
|
||||||
|
import (
|
||||||
|
"time"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
)
|
||||||
|
|
||||||
|
type BillingRate struct {
|
||||||
|
ID uuid.UUID `db:"id" json:"id"`
|
||||||
|
TenantID uuid.UUID `db:"tenant_id" json:"tenant_id"`
|
||||||
|
UserID *uuid.UUID `db:"user_id" json:"user_id,omitempty"`
|
||||||
|
Rate float64 `db:"rate" json:"rate"`
|
||||||
|
Currency string `db:"currency" json:"currency"`
|
||||||
|
ValidFrom string `db:"valid_from" json:"valid_from"`
|
||||||
|
ValidTo *string `db:"valid_to" json:"valid_to,omitempty"`
|
||||||
|
CreatedAt time.Time `db:"created_at" json:"created_at"`
|
||||||
|
}
|
||||||
38
backend/internal/models/invoice.go
Normal file
38
backend/internal/models/invoice.go
Normal file
@@ -0,0 +1,38 @@
|
|||||||
|
package models
|
||||||
|
|
||||||
|
import (
|
||||||
|
"encoding/json"
|
||||||
|
"time"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
)
|
||||||
|
|
||||||
|
type Invoice struct {
|
||||||
|
ID uuid.UUID `db:"id" json:"id"`
|
||||||
|
TenantID uuid.UUID `db:"tenant_id" json:"tenant_id"`
|
||||||
|
CaseID uuid.UUID `db:"case_id" json:"case_id"`
|
||||||
|
InvoiceNumber string `db:"invoice_number" json:"invoice_number"`
|
||||||
|
ClientName string `db:"client_name" json:"client_name"`
|
||||||
|
ClientAddress *string `db:"client_address" json:"client_address,omitempty"`
|
||||||
|
Items json.RawMessage `db:"items" json:"items"`
|
||||||
|
Subtotal float64 `db:"subtotal" json:"subtotal"`
|
||||||
|
TaxRate float64 `db:"tax_rate" json:"tax_rate"`
|
||||||
|
TaxAmount float64 `db:"tax_amount" json:"tax_amount"`
|
||||||
|
Total float64 `db:"total" json:"total"`
|
||||||
|
Status string `db:"status" json:"status"`
|
||||||
|
IssuedAt *string `db:"issued_at" json:"issued_at,omitempty"`
|
||||||
|
DueAt *string `db:"due_at" json:"due_at,omitempty"`
|
||||||
|
PaidAt *time.Time `db:"paid_at" json:"paid_at,omitempty"`
|
||||||
|
Notes *string `db:"notes" json:"notes,omitempty"`
|
||||||
|
CreatedBy uuid.UUID `db:"created_by" json:"created_by"`
|
||||||
|
CreatedAt time.Time `db:"created_at" json:"created_at"`
|
||||||
|
UpdatedAt time.Time `db:"updated_at" json:"updated_at"`
|
||||||
|
}
|
||||||
|
|
||||||
|
type InvoiceItem struct {
|
||||||
|
Description string `json:"description"`
|
||||||
|
DurationMinutes int `json:"duration_minutes,omitempty"`
|
||||||
|
HourlyRate float64 `json:"hourly_rate,omitempty"`
|
||||||
|
Amount float64 `json:"amount"`
|
||||||
|
TimeEntryID *string `json:"time_entry_id,omitempty"`
|
||||||
|
}
|
||||||
24
backend/internal/models/time_entry.go
Normal file
24
backend/internal/models/time_entry.go
Normal file
@@ -0,0 +1,24 @@
|
|||||||
|
package models
|
||||||
|
|
||||||
|
import (
|
||||||
|
"time"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
)
|
||||||
|
|
||||||
|
type TimeEntry struct {
|
||||||
|
ID uuid.UUID `db:"id" json:"id"`
|
||||||
|
TenantID uuid.UUID `db:"tenant_id" json:"tenant_id"`
|
||||||
|
CaseID uuid.UUID `db:"case_id" json:"case_id"`
|
||||||
|
UserID uuid.UUID `db:"user_id" json:"user_id"`
|
||||||
|
Date string `db:"date" json:"date"`
|
||||||
|
DurationMinutes int `db:"duration_minutes" json:"duration_minutes"`
|
||||||
|
Description string `db:"description" json:"description"`
|
||||||
|
Activity *string `db:"activity" json:"activity,omitempty"`
|
||||||
|
Billable bool `db:"billable" json:"billable"`
|
||||||
|
Billed bool `db:"billed" json:"billed"`
|
||||||
|
InvoiceID *uuid.UUID `db:"invoice_id" json:"invoice_id,omitempty"`
|
||||||
|
HourlyRate *float64 `db:"hourly_rate" json:"hourly_rate,omitempty"`
|
||||||
|
CreatedAt time.Time `db:"created_at" json:"created_at"`
|
||||||
|
UpdatedAt time.Time `db:"updated_at" json:"updated_at"`
|
||||||
|
}
|
||||||
@@ -31,6 +31,9 @@ func New(db *sqlx.DB, authMW *auth.Middleware, cfg *config.Config, calDAVSvc *se
|
|||||||
storageCli := services.NewStorageClient(cfg.SupabaseURL, cfg.SupabaseServiceKey)
|
storageCli := services.NewStorageClient(cfg.SupabaseURL, cfg.SupabaseServiceKey)
|
||||||
documentSvc := services.NewDocumentService(db, storageCli, auditSvc)
|
documentSvc := services.NewDocumentService(db, storageCli, auditSvc)
|
||||||
assignmentSvc := services.NewCaseAssignmentService(db)
|
assignmentSvc := services.NewCaseAssignmentService(db)
|
||||||
|
timeEntrySvc := services.NewTimeEntryService(db, auditSvc)
|
||||||
|
billingRateSvc := services.NewBillingRateService(db, auditSvc)
|
||||||
|
invoiceSvc := services.NewInvoiceService(db, auditSvc)
|
||||||
|
|
||||||
// AI service (optional — only if API key is configured)
|
// AI service (optional — only if API key is configured)
|
||||||
var aiH *handlers.AIHandler
|
var aiH *handlers.AIHandler
|
||||||
@@ -44,7 +47,6 @@ func New(db *sqlx.DB, authMW *auth.Middleware, cfg *config.Config, calDAVSvc *se
|
|||||||
|
|
||||||
noteSvc := services.NewNoteService(db, auditSvc)
|
noteSvc := services.NewNoteService(db, auditSvc)
|
||||||
dashboardSvc := services.NewDashboardService(db)
|
dashboardSvc := services.NewDashboardService(db)
|
||||||
reportingSvc := services.NewReportingService(db)
|
|
||||||
|
|
||||||
// Notification handler (optional — nil in tests)
|
// Notification handler (optional — nil in tests)
|
||||||
var notifH *handlers.NotificationHandler
|
var notifH *handlers.NotificationHandler
|
||||||
@@ -62,11 +64,13 @@ func New(db *sqlx.DB, authMW *auth.Middleware, cfg *config.Config, calDAVSvc *se
|
|||||||
ruleH := handlers.NewDeadlineRuleHandlers(deadlineRuleSvc)
|
ruleH := handlers.NewDeadlineRuleHandlers(deadlineRuleSvc)
|
||||||
calcH := handlers.NewCalculateHandlers(calculator, deadlineRuleSvc)
|
calcH := handlers.NewCalculateHandlers(calculator, deadlineRuleSvc)
|
||||||
dashboardH := handlers.NewDashboardHandler(dashboardSvc)
|
dashboardH := handlers.NewDashboardHandler(dashboardSvc)
|
||||||
reportH := handlers.NewReportHandler(reportingSvc)
|
|
||||||
noteH := handlers.NewNoteHandler(noteSvc)
|
noteH := handlers.NewNoteHandler(noteSvc)
|
||||||
eventH := handlers.NewCaseEventHandler(db)
|
eventH := handlers.NewCaseEventHandler(db)
|
||||||
docH := handlers.NewDocumentHandler(documentSvc)
|
docH := handlers.NewDocumentHandler(documentSvc)
|
||||||
assignmentH := handlers.NewCaseAssignmentHandler(assignmentSvc)
|
assignmentH := handlers.NewCaseAssignmentHandler(assignmentSvc)
|
||||||
|
timeEntryH := handlers.NewTimeEntryHandler(timeEntrySvc)
|
||||||
|
billingRateH := handlers.NewBillingRateHandler(billingRateSvc)
|
||||||
|
invoiceH := handlers.NewInvoiceHandler(invoiceSvc)
|
||||||
|
|
||||||
// Public routes
|
// Public routes
|
||||||
mux.HandleFunc("GET /health", handleHealth(db))
|
mux.HandleFunc("GET /health", handleHealth(db))
|
||||||
@@ -108,7 +112,7 @@ func New(db *sqlx.DB, authMW *auth.Middleware, cfg *config.Config, calDAVSvc *se
|
|||||||
scoped.HandleFunc("GET /api/cases", caseH.List)
|
scoped.HandleFunc("GET /api/cases", caseH.List)
|
||||||
scoped.HandleFunc("POST /api/cases", perm(auth.PermCreateCase, caseH.Create))
|
scoped.HandleFunc("POST /api/cases", perm(auth.PermCreateCase, caseH.Create))
|
||||||
scoped.HandleFunc("GET /api/cases/{id}", caseH.Get)
|
scoped.HandleFunc("GET /api/cases/{id}", caseH.Get)
|
||||||
scoped.HandleFunc("PUT /api/cases/{id}", caseH.Update) // case-level access checked in handler
|
scoped.HandleFunc("PUT /api/cases/{id}", caseH.Update)
|
||||||
scoped.HandleFunc("DELETE /api/cases/{id}", perm(auth.PermCreateCase, caseH.Delete))
|
scoped.HandleFunc("DELETE /api/cases/{id}", perm(auth.PermCreateCase, caseH.Delete))
|
||||||
|
|
||||||
// Parties — same access as case editing
|
// Parties — same access as case editing
|
||||||
@@ -158,21 +162,15 @@ func New(db *sqlx.DB, authMW *auth.Middleware, cfg *config.Config, calDAVSvc *se
|
|||||||
// Dashboard — all can view
|
// Dashboard — all can view
|
||||||
scoped.HandleFunc("GET /api/dashboard", dashboardH.Get)
|
scoped.HandleFunc("GET /api/dashboard", dashboardH.Get)
|
||||||
|
|
||||||
// Reports — all can view
|
// Audit log — view requires PermViewAuditLog
|
||||||
scoped.HandleFunc("GET /api/reports/cases", reportH.Cases)
|
scoped.HandleFunc("GET /api/audit-log", perm(auth.PermViewAuditLog, auditH.List))
|
||||||
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)
|
|
||||||
|
|
||||||
// Documents — all can upload, delete checked in handler (own vs all)
|
// Documents — all can upload, delete checked in handler (own vs all)
|
||||||
scoped.HandleFunc("GET /api/cases/{id}/documents", docH.ListByCase)
|
scoped.HandleFunc("GET /api/cases/{id}/documents", docH.ListByCase)
|
||||||
scoped.HandleFunc("POST /api/cases/{id}/documents", perm(auth.PermUploadDocuments, docH.Upload))
|
scoped.HandleFunc("POST /api/cases/{id}/documents", perm(auth.PermUploadDocuments, docH.Upload))
|
||||||
scoped.HandleFunc("GET /api/documents/{docId}", docH.Download)
|
scoped.HandleFunc("GET /api/documents/{docId}", docH.Download)
|
||||||
scoped.HandleFunc("GET /api/documents/{docId}/meta", docH.GetMeta)
|
scoped.HandleFunc("GET /api/documents/{docId}/meta", docH.GetMeta)
|
||||||
scoped.HandleFunc("DELETE /api/documents/{docId}", docH.Delete) // permission check inside handler
|
scoped.HandleFunc("DELETE /api/documents/{docId}", docH.Delete)
|
||||||
|
|
||||||
// AI endpoints (rate limited: 5 req/min burst 10 per IP)
|
// AI endpoints (rate limited: 5 req/min burst 10 per IP)
|
||||||
if aiH != nil {
|
if aiH != nil {
|
||||||
@@ -198,6 +196,25 @@ func New(db *sqlx.DB, authMW *auth.Middleware, cfg *config.Config, calDAVSvc *se
|
|||||||
scoped.HandleFunc("GET /api/caldav/status", calDAVH.GetStatus)
|
scoped.HandleFunc("GET /api/caldav/status", calDAVH.GetStatus)
|
||||||
}
|
}
|
||||||
|
|
||||||
|
// Time entries — billing permission for create/update/delete
|
||||||
|
scoped.HandleFunc("GET /api/cases/{id}/time-entries", timeEntryH.ListForCase)
|
||||||
|
scoped.HandleFunc("POST /api/cases/{id}/time-entries", perm(auth.PermManageBilling, timeEntryH.Create))
|
||||||
|
scoped.HandleFunc("GET /api/time-entries", timeEntryH.List)
|
||||||
|
scoped.HandleFunc("GET /api/time-entries/summary", perm(auth.PermManageBilling, timeEntryH.Summary))
|
||||||
|
scoped.HandleFunc("PUT /api/time-entries/{id}", perm(auth.PermManageBilling, timeEntryH.Update))
|
||||||
|
scoped.HandleFunc("DELETE /api/time-entries/{id}", perm(auth.PermManageBilling, timeEntryH.Delete))
|
||||||
|
|
||||||
|
// Billing rates — billing permission required
|
||||||
|
scoped.HandleFunc("GET /api/billing-rates", perm(auth.PermManageBilling, billingRateH.List))
|
||||||
|
scoped.HandleFunc("PUT /api/billing-rates", perm(auth.PermManageBilling, billingRateH.Upsert))
|
||||||
|
|
||||||
|
// Invoices — billing permission required
|
||||||
|
scoped.HandleFunc("GET /api/invoices", perm(auth.PermManageBilling, invoiceH.List))
|
||||||
|
scoped.HandleFunc("POST /api/invoices", perm(auth.PermManageBilling, invoiceH.Create))
|
||||||
|
scoped.HandleFunc("GET /api/invoices/{id}", perm(auth.PermManageBilling, invoiceH.Get))
|
||||||
|
scoped.HandleFunc("PUT /api/invoices/{id}", perm(auth.PermManageBilling, invoiceH.Update))
|
||||||
|
scoped.HandleFunc("PATCH /api/invoices/{id}/status", perm(auth.PermManageBilling, invoiceH.UpdateStatus))
|
||||||
|
|
||||||
// Wire: auth -> tenant routes go directly, scoped routes get tenant resolver
|
// Wire: auth -> tenant routes go directly, scoped routes get tenant resolver
|
||||||
api.Handle("/api/", tenantResolver.Resolve(scoped))
|
api.Handle("/api/", tenantResolver.Resolve(scoped))
|
||||||
|
|
||||||
|
|||||||
88
backend/internal/services/billing_rate_service.go
Normal file
88
backend/internal/services/billing_rate_service.go
Normal file
@@ -0,0 +1,88 @@
|
|||||||
|
package services
|
||||||
|
|
||||||
|
import (
|
||||||
|
"context"
|
||||||
|
"fmt"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
"github.com/jmoiron/sqlx"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/models"
|
||||||
|
)
|
||||||
|
|
||||||
|
type BillingRateService struct {
|
||||||
|
db *sqlx.DB
|
||||||
|
audit *AuditService
|
||||||
|
}
|
||||||
|
|
||||||
|
func NewBillingRateService(db *sqlx.DB, audit *AuditService) *BillingRateService {
|
||||||
|
return &BillingRateService{db: db, audit: audit}
|
||||||
|
}
|
||||||
|
|
||||||
|
type UpsertBillingRateInput struct {
|
||||||
|
UserID *uuid.UUID `json:"user_id,omitempty"`
|
||||||
|
Rate float64 `json:"rate"`
|
||||||
|
Currency string `json:"currency"`
|
||||||
|
ValidFrom string `json:"valid_from"`
|
||||||
|
ValidTo *string `json:"valid_to,omitempty"`
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *BillingRateService) List(ctx context.Context, tenantID uuid.UUID) ([]models.BillingRate, error) {
|
||||||
|
var rates []models.BillingRate
|
||||||
|
err := s.db.SelectContext(ctx, &rates,
|
||||||
|
`SELECT id, tenant_id, user_id, rate, currency, valid_from, valid_to, created_at
|
||||||
|
FROM billing_rates
|
||||||
|
WHERE tenant_id = $1
|
||||||
|
ORDER BY valid_from DESC, user_id NULLS LAST`,
|
||||||
|
tenantID)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("list billing rates: %w", err)
|
||||||
|
}
|
||||||
|
return rates, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *BillingRateService) Upsert(ctx context.Context, tenantID uuid.UUID, input UpsertBillingRateInput) (*models.BillingRate, error) {
|
||||||
|
if input.Currency == "" {
|
||||||
|
input.Currency = "EUR"
|
||||||
|
}
|
||||||
|
|
||||||
|
// Close any existing open-ended rate for this user
|
||||||
|
_, err := s.db.ExecContext(ctx,
|
||||||
|
`UPDATE billing_rates SET valid_to = $3
|
||||||
|
WHERE tenant_id = $1
|
||||||
|
AND (($2::uuid IS NULL AND user_id IS NULL) OR user_id = $2)
|
||||||
|
AND valid_to IS NULL
|
||||||
|
AND valid_from < $3`,
|
||||||
|
tenantID, input.UserID, input.ValidFrom)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("close existing rate: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
var rate models.BillingRate
|
||||||
|
err = s.db.QueryRowxContext(ctx,
|
||||||
|
`INSERT INTO billing_rates (tenant_id, user_id, rate, currency, valid_from, valid_to)
|
||||||
|
VALUES ($1, $2, $3, $4, $5, $6)
|
||||||
|
RETURNING id, tenant_id, user_id, rate, currency, valid_from, valid_to, created_at`,
|
||||||
|
tenantID, input.UserID, input.Rate, input.Currency, input.ValidFrom, input.ValidTo,
|
||||||
|
).StructScan(&rate)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("upsert billing rate: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
s.audit.Log(ctx, "create", "billing_rate", &rate.ID, nil, rate)
|
||||||
|
return &rate, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *BillingRateService) GetCurrentRate(ctx context.Context, tenantID uuid.UUID, userID uuid.UUID, date string) (*float64, error) {
|
||||||
|
var rate float64
|
||||||
|
err := s.db.GetContext(ctx, &rate,
|
||||||
|
`SELECT rate FROM billing_rates
|
||||||
|
WHERE tenant_id = $1 AND (user_id = $2 OR user_id IS NULL)
|
||||||
|
AND valid_from <= $3 AND (valid_to IS NULL OR valid_to >= $3)
|
||||||
|
ORDER BY user_id NULLS LAST LIMIT 1`,
|
||||||
|
tenantID, userID, date)
|
||||||
|
if err != nil {
|
||||||
|
return nil, err
|
||||||
|
}
|
||||||
|
return &rate, nil
|
||||||
|
}
|
||||||
292
backend/internal/services/invoice_service.go
Normal file
292
backend/internal/services/invoice_service.go
Normal file
@@ -0,0 +1,292 @@
|
|||||||
|
package services
|
||||||
|
|
||||||
|
import (
|
||||||
|
"context"
|
||||||
|
"database/sql"
|
||||||
|
"encoding/json"
|
||||||
|
"fmt"
|
||||||
|
"time"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
"github.com/jmoiron/sqlx"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/models"
|
||||||
|
)
|
||||||
|
|
||||||
|
type InvoiceService struct {
|
||||||
|
db *sqlx.DB
|
||||||
|
audit *AuditService
|
||||||
|
}
|
||||||
|
|
||||||
|
func NewInvoiceService(db *sqlx.DB, audit *AuditService) *InvoiceService {
|
||||||
|
return &InvoiceService{db: db, audit: audit}
|
||||||
|
}
|
||||||
|
|
||||||
|
type CreateInvoiceInput struct {
|
||||||
|
CaseID uuid.UUID `json:"case_id"`
|
||||||
|
ClientName string `json:"client_name"`
|
||||||
|
ClientAddress *string `json:"client_address,omitempty"`
|
||||||
|
Items []models.InvoiceItem `json:"items"`
|
||||||
|
TaxRate *float64 `json:"tax_rate,omitempty"`
|
||||||
|
IssuedAt *string `json:"issued_at,omitempty"`
|
||||||
|
DueAt *string `json:"due_at,omitempty"`
|
||||||
|
Notes *string `json:"notes,omitempty"`
|
||||||
|
TimeEntryIDs []uuid.UUID `json:"time_entry_ids,omitempty"`
|
||||||
|
}
|
||||||
|
|
||||||
|
type UpdateInvoiceInput struct {
|
||||||
|
ClientName *string `json:"client_name,omitempty"`
|
||||||
|
ClientAddress *string `json:"client_address,omitempty"`
|
||||||
|
Items []models.InvoiceItem `json:"items,omitempty"`
|
||||||
|
TaxRate *float64 `json:"tax_rate,omitempty"`
|
||||||
|
IssuedAt *string `json:"issued_at,omitempty"`
|
||||||
|
DueAt *string `json:"due_at,omitempty"`
|
||||||
|
Notes *string `json:"notes,omitempty"`
|
||||||
|
}
|
||||||
|
|
||||||
|
const invoiceCols = `id, tenant_id, case_id, invoice_number, client_name, client_address,
|
||||||
|
items, subtotal, tax_rate, tax_amount, total, status, issued_at, due_at, paid_at, notes,
|
||||||
|
created_by, created_at, updated_at`
|
||||||
|
|
||||||
|
func (s *InvoiceService) List(ctx context.Context, tenantID uuid.UUID, caseID *uuid.UUID, status string) ([]models.Invoice, error) {
|
||||||
|
where := "WHERE tenant_id = $1"
|
||||||
|
args := []any{tenantID}
|
||||||
|
argIdx := 2
|
||||||
|
|
||||||
|
if caseID != nil {
|
||||||
|
where += fmt.Sprintf(" AND case_id = $%d", argIdx)
|
||||||
|
args = append(args, *caseID)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if status != "" {
|
||||||
|
where += fmt.Sprintf(" AND status = $%d", argIdx)
|
||||||
|
args = append(args, status)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
|
||||||
|
var invoices []models.Invoice
|
||||||
|
err := s.db.SelectContext(ctx, &invoices,
|
||||||
|
fmt.Sprintf("SELECT %s FROM invoices %s ORDER BY created_at DESC", invoiceCols, where),
|
||||||
|
args...)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("list invoices: %w", err)
|
||||||
|
}
|
||||||
|
return invoices, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *InvoiceService) GetByID(ctx context.Context, tenantID, invoiceID uuid.UUID) (*models.Invoice, error) {
|
||||||
|
var inv models.Invoice
|
||||||
|
err := s.db.GetContext(ctx, &inv,
|
||||||
|
`SELECT `+invoiceCols+` FROM invoices WHERE tenant_id = $1 AND id = $2`,
|
||||||
|
tenantID, invoiceID)
|
||||||
|
if err == sql.ErrNoRows {
|
||||||
|
return nil, nil
|
||||||
|
}
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("get invoice: %w", err)
|
||||||
|
}
|
||||||
|
return &inv, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *InvoiceService) Create(ctx context.Context, tenantID, userID uuid.UUID, input CreateInvoiceInput) (*models.Invoice, error) {
|
||||||
|
tx, err := s.db.BeginTxx(ctx, nil)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("begin tx: %w", err)
|
||||||
|
}
|
||||||
|
defer tx.Rollback()
|
||||||
|
|
||||||
|
// Generate invoice number: RE-YYYY-NNN
|
||||||
|
year := time.Now().Year()
|
||||||
|
var seq int
|
||||||
|
err = tx.GetContext(ctx, &seq,
|
||||||
|
`SELECT COUNT(*) + 1 FROM invoices WHERE tenant_id = $1 AND invoice_number LIKE $2`,
|
||||||
|
tenantID, fmt.Sprintf("RE-%d-%%", year))
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("generate invoice number: %w", err)
|
||||||
|
}
|
||||||
|
invoiceNumber := fmt.Sprintf("RE-%d-%03d", year, seq)
|
||||||
|
|
||||||
|
// Calculate totals
|
||||||
|
taxRate := 19.00
|
||||||
|
if input.TaxRate != nil {
|
||||||
|
taxRate = *input.TaxRate
|
||||||
|
}
|
||||||
|
|
||||||
|
var subtotal float64
|
||||||
|
for _, item := range input.Items {
|
||||||
|
subtotal += item.Amount
|
||||||
|
}
|
||||||
|
taxAmount := subtotal * taxRate / 100
|
||||||
|
total := subtotal + taxAmount
|
||||||
|
|
||||||
|
itemsJSON, err := json.Marshal(input.Items)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("marshal items: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
var inv models.Invoice
|
||||||
|
err = tx.QueryRowxContext(ctx,
|
||||||
|
`INSERT INTO invoices (tenant_id, case_id, invoice_number, client_name, client_address,
|
||||||
|
items, subtotal, tax_rate, tax_amount, total, issued_at, due_at, notes, created_by)
|
||||||
|
VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14)
|
||||||
|
RETURNING `+invoiceCols,
|
||||||
|
tenantID, input.CaseID, invoiceNumber, input.ClientName, input.ClientAddress,
|
||||||
|
itemsJSON, subtotal, taxRate, taxAmount, total, input.IssuedAt, input.DueAt, input.Notes, userID,
|
||||||
|
).StructScan(&inv)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("create invoice: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Mark linked time entries as billed
|
||||||
|
if len(input.TimeEntryIDs) > 0 {
|
||||||
|
query, args, err := sqlx.In(
|
||||||
|
`UPDATE time_entries SET billed = true, invoice_id = ? WHERE tenant_id = ? AND id IN (?)`,
|
||||||
|
inv.ID, tenantID, input.TimeEntryIDs)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("build time entry update: %w", err)
|
||||||
|
}
|
||||||
|
query = tx.Rebind(query)
|
||||||
|
_, err = tx.ExecContext(ctx, query, args...)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("mark time entries billed: %w", err)
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
if err := tx.Commit(); err != nil {
|
||||||
|
return nil, fmt.Errorf("commit: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
s.audit.Log(ctx, "create", "invoice", &inv.ID, nil, inv)
|
||||||
|
return &inv, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *InvoiceService) Update(ctx context.Context, tenantID, invoiceID uuid.UUID, input UpdateInvoiceInput) (*models.Invoice, error) {
|
||||||
|
old, err := s.GetByID(ctx, tenantID, invoiceID)
|
||||||
|
if err != nil {
|
||||||
|
return nil, err
|
||||||
|
}
|
||||||
|
if old == nil {
|
||||||
|
return nil, fmt.Errorf("invoice not found")
|
||||||
|
}
|
||||||
|
if old.Status != "draft" {
|
||||||
|
return nil, fmt.Errorf("can only update draft invoices")
|
||||||
|
}
|
||||||
|
|
||||||
|
// Recalculate totals if items changed
|
||||||
|
var itemsJSON json.RawMessage
|
||||||
|
var subtotal float64
|
||||||
|
taxRate := old.TaxRate
|
||||||
|
|
||||||
|
if input.Items != nil {
|
||||||
|
for _, item := range input.Items {
|
||||||
|
subtotal += item.Amount
|
||||||
|
}
|
||||||
|
itemsJSON, _ = json.Marshal(input.Items)
|
||||||
|
}
|
||||||
|
if input.TaxRate != nil {
|
||||||
|
taxRate = *input.TaxRate
|
||||||
|
}
|
||||||
|
|
||||||
|
if input.Items != nil {
|
||||||
|
taxAmount := subtotal * taxRate / 100
|
||||||
|
total := subtotal + taxAmount
|
||||||
|
|
||||||
|
var inv models.Invoice
|
||||||
|
err = s.db.QueryRowxContext(ctx,
|
||||||
|
`UPDATE invoices SET
|
||||||
|
client_name = COALESCE($3, client_name),
|
||||||
|
client_address = COALESCE($4, client_address),
|
||||||
|
items = $5,
|
||||||
|
subtotal = $6,
|
||||||
|
tax_rate = $7,
|
||||||
|
tax_amount = $8,
|
||||||
|
total = $9,
|
||||||
|
issued_at = COALESCE($10, issued_at),
|
||||||
|
due_at = COALESCE($11, due_at),
|
||||||
|
notes = COALESCE($12, notes),
|
||||||
|
updated_at = now()
|
||||||
|
WHERE tenant_id = $1 AND id = $2
|
||||||
|
RETURNING `+invoiceCols,
|
||||||
|
tenantID, invoiceID, input.ClientName, input.ClientAddress,
|
||||||
|
itemsJSON, subtotal, taxRate, subtotal*taxRate/100, total,
|
||||||
|
input.IssuedAt, input.DueAt, input.Notes,
|
||||||
|
).StructScan(&inv)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("update invoice: %w", err)
|
||||||
|
}
|
||||||
|
s.audit.Log(ctx, "update", "invoice", &inv.ID, old, inv)
|
||||||
|
return &inv, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// Update without changing items
|
||||||
|
var inv models.Invoice
|
||||||
|
err = s.db.QueryRowxContext(ctx,
|
||||||
|
`UPDATE invoices SET
|
||||||
|
client_name = COALESCE($3, client_name),
|
||||||
|
client_address = COALESCE($4, client_address),
|
||||||
|
tax_rate = COALESCE($5, tax_rate),
|
||||||
|
issued_at = COALESCE($6, issued_at),
|
||||||
|
due_at = COALESCE($7, due_at),
|
||||||
|
notes = COALESCE($8, notes),
|
||||||
|
updated_at = now()
|
||||||
|
WHERE tenant_id = $1 AND id = $2
|
||||||
|
RETURNING `+invoiceCols,
|
||||||
|
tenantID, invoiceID, input.ClientName, input.ClientAddress,
|
||||||
|
input.TaxRate, input.IssuedAt, input.DueAt, input.Notes,
|
||||||
|
).StructScan(&inv)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("update invoice: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
s.audit.Log(ctx, "update", "invoice", &inv.ID, old, inv)
|
||||||
|
return &inv, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *InvoiceService) UpdateStatus(ctx context.Context, tenantID, invoiceID uuid.UUID, newStatus string) (*models.Invoice, error) {
|
||||||
|
old, err := s.GetByID(ctx, tenantID, invoiceID)
|
||||||
|
if err != nil {
|
||||||
|
return nil, err
|
||||||
|
}
|
||||||
|
if old == nil {
|
||||||
|
return nil, fmt.Errorf("invoice not found")
|
||||||
|
}
|
||||||
|
|
||||||
|
// Validate transitions
|
||||||
|
validTransitions := map[string][]string{
|
||||||
|
"draft": {"sent", "cancelled"},
|
||||||
|
"sent": {"paid", "cancelled"},
|
||||||
|
"paid": {},
|
||||||
|
"cancelled": {},
|
||||||
|
}
|
||||||
|
allowed := validTransitions[old.Status]
|
||||||
|
valid := false
|
||||||
|
for _, s := range allowed {
|
||||||
|
if s == newStatus {
|
||||||
|
valid = true
|
||||||
|
break
|
||||||
|
}
|
||||||
|
}
|
||||||
|
if !valid {
|
||||||
|
return nil, fmt.Errorf("invalid status transition from %s to %s", old.Status, newStatus)
|
||||||
|
}
|
||||||
|
|
||||||
|
var paidAt *time.Time
|
||||||
|
if newStatus == "paid" {
|
||||||
|
now := time.Now()
|
||||||
|
paidAt = &now
|
||||||
|
}
|
||||||
|
|
||||||
|
var inv models.Invoice
|
||||||
|
err = s.db.QueryRowxContext(ctx,
|
||||||
|
`UPDATE invoices SET status = $3, paid_at = COALESCE($4, paid_at), updated_at = now()
|
||||||
|
WHERE tenant_id = $1 AND id = $2
|
||||||
|
RETURNING `+invoiceCols,
|
||||||
|
tenantID, invoiceID, newStatus, paidAt,
|
||||||
|
).StructScan(&inv)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("update invoice status: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
s.audit.Log(ctx, "update", "invoice", &inv.ID, old, inv)
|
||||||
|
return &inv, nil
|
||||||
|
}
|
||||||
@@ -1,329 +0,0 @@
|
|||||||
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
|
|
||||||
}
|
|
||||||
276
backend/internal/services/time_entry_service.go
Normal file
276
backend/internal/services/time_entry_service.go
Normal file
@@ -0,0 +1,276 @@
|
|||||||
|
package services
|
||||||
|
|
||||||
|
import (
|
||||||
|
"context"
|
||||||
|
"database/sql"
|
||||||
|
"fmt"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
"github.com/jmoiron/sqlx"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/models"
|
||||||
|
)
|
||||||
|
|
||||||
|
type TimeEntryService struct {
|
||||||
|
db *sqlx.DB
|
||||||
|
audit *AuditService
|
||||||
|
}
|
||||||
|
|
||||||
|
func NewTimeEntryService(db *sqlx.DB, audit *AuditService) *TimeEntryService {
|
||||||
|
return &TimeEntryService{db: db, audit: audit}
|
||||||
|
}
|
||||||
|
|
||||||
|
type CreateTimeEntryInput struct {
|
||||||
|
CaseID uuid.UUID `json:"case_id"`
|
||||||
|
Date string `json:"date"`
|
||||||
|
DurationMinutes int `json:"duration_minutes"`
|
||||||
|
Description string `json:"description"`
|
||||||
|
Activity *string `json:"activity,omitempty"`
|
||||||
|
Billable *bool `json:"billable,omitempty"`
|
||||||
|
HourlyRate *float64 `json:"hourly_rate,omitempty"`
|
||||||
|
}
|
||||||
|
|
||||||
|
type UpdateTimeEntryInput struct {
|
||||||
|
Date *string `json:"date,omitempty"`
|
||||||
|
DurationMinutes *int `json:"duration_minutes,omitempty"`
|
||||||
|
Description *string `json:"description,omitempty"`
|
||||||
|
Activity *string `json:"activity,omitempty"`
|
||||||
|
Billable *bool `json:"billable,omitempty"`
|
||||||
|
HourlyRate *float64 `json:"hourly_rate,omitempty"`
|
||||||
|
}
|
||||||
|
|
||||||
|
type TimeEntryFilter struct {
|
||||||
|
CaseID *uuid.UUID
|
||||||
|
UserID *uuid.UUID
|
||||||
|
From string
|
||||||
|
To string
|
||||||
|
Limit int
|
||||||
|
Offset int
|
||||||
|
}
|
||||||
|
|
||||||
|
type TimeEntrySummary struct {
|
||||||
|
GroupKey string `db:"group_key" json:"group_key"`
|
||||||
|
TotalMinutes int `db:"total_minutes" json:"total_minutes"`
|
||||||
|
BillableMinutes int `db:"billable_minutes" json:"billable_minutes"`
|
||||||
|
TotalAmount float64 `db:"total_amount" json:"total_amount"`
|
||||||
|
EntryCount int `db:"entry_count" json:"entry_count"`
|
||||||
|
}
|
||||||
|
|
||||||
|
const timeEntryCols = `id, tenant_id, case_id, user_id, date, duration_minutes, description,
|
||||||
|
activity, billable, billed, invoice_id, hourly_rate, created_at, updated_at`
|
||||||
|
|
||||||
|
func (s *TimeEntryService) ListForCase(ctx context.Context, tenantID, caseID uuid.UUID) ([]models.TimeEntry, error) {
|
||||||
|
var entries []models.TimeEntry
|
||||||
|
err := s.db.SelectContext(ctx, &entries,
|
||||||
|
`SELECT `+timeEntryCols+` FROM time_entries
|
||||||
|
WHERE tenant_id = $1 AND case_id = $2
|
||||||
|
ORDER BY date DESC, created_at DESC`,
|
||||||
|
tenantID, caseID)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("list time entries for case: %w", err)
|
||||||
|
}
|
||||||
|
return entries, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *TimeEntryService) List(ctx context.Context, tenantID uuid.UUID, filter TimeEntryFilter) ([]models.TimeEntry, int, error) {
|
||||||
|
if filter.Limit <= 0 {
|
||||||
|
filter.Limit = 20
|
||||||
|
}
|
||||||
|
if filter.Limit > 100 {
|
||||||
|
filter.Limit = 100
|
||||||
|
}
|
||||||
|
|
||||||
|
where := "WHERE tenant_id = $1"
|
||||||
|
args := []any{tenantID}
|
||||||
|
argIdx := 2
|
||||||
|
|
||||||
|
if filter.CaseID != nil {
|
||||||
|
where += fmt.Sprintf(" AND case_id = $%d", argIdx)
|
||||||
|
args = append(args, *filter.CaseID)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if filter.UserID != nil {
|
||||||
|
where += fmt.Sprintf(" AND user_id = $%d", argIdx)
|
||||||
|
args = append(args, *filter.UserID)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if filter.From != "" {
|
||||||
|
where += fmt.Sprintf(" AND date >= $%d", argIdx)
|
||||||
|
args = append(args, filter.From)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if filter.To != "" {
|
||||||
|
where += fmt.Sprintf(" AND date <= $%d", argIdx)
|
||||||
|
args = append(args, filter.To)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
|
||||||
|
var total int
|
||||||
|
err := s.db.GetContext(ctx, &total,
|
||||||
|
"SELECT COUNT(*) FROM time_entries "+where, args...)
|
||||||
|
if err != nil {
|
||||||
|
return nil, 0, fmt.Errorf("count time entries: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
query := fmt.Sprintf("SELECT %s FROM time_entries %s ORDER BY date DESC, created_at DESC LIMIT $%d OFFSET $%d",
|
||||||
|
timeEntryCols, where, argIdx, argIdx+1)
|
||||||
|
args = append(args, filter.Limit, filter.Offset)
|
||||||
|
|
||||||
|
var entries []models.TimeEntry
|
||||||
|
err = s.db.SelectContext(ctx, &entries, query, args...)
|
||||||
|
if err != nil {
|
||||||
|
return nil, 0, fmt.Errorf("list time entries: %w", err)
|
||||||
|
}
|
||||||
|
return entries, total, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *TimeEntryService) GetByID(ctx context.Context, tenantID, entryID uuid.UUID) (*models.TimeEntry, error) {
|
||||||
|
var entry models.TimeEntry
|
||||||
|
err := s.db.GetContext(ctx, &entry,
|
||||||
|
`SELECT `+timeEntryCols+` FROM time_entries WHERE tenant_id = $1 AND id = $2`,
|
||||||
|
tenantID, entryID)
|
||||||
|
if err == sql.ErrNoRows {
|
||||||
|
return nil, nil
|
||||||
|
}
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("get time entry: %w", err)
|
||||||
|
}
|
||||||
|
return &entry, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *TimeEntryService) Create(ctx context.Context, tenantID, userID uuid.UUID, input CreateTimeEntryInput) (*models.TimeEntry, error) {
|
||||||
|
billable := true
|
||||||
|
if input.Billable != nil {
|
||||||
|
billable = *input.Billable
|
||||||
|
}
|
||||||
|
|
||||||
|
// If no hourly rate provided, look up the current billing rate
|
||||||
|
hourlyRate := input.HourlyRate
|
||||||
|
if hourlyRate == nil {
|
||||||
|
var rate float64
|
||||||
|
err := s.db.GetContext(ctx, &rate,
|
||||||
|
`SELECT rate FROM billing_rates
|
||||||
|
WHERE tenant_id = $1 AND (user_id = $2 OR user_id IS NULL)
|
||||||
|
AND valid_from <= $3 AND (valid_to IS NULL OR valid_to >= $3)
|
||||||
|
ORDER BY user_id NULLS LAST LIMIT 1`,
|
||||||
|
tenantID, userID, input.Date)
|
||||||
|
if err == nil {
|
||||||
|
hourlyRate = &rate
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
var entry models.TimeEntry
|
||||||
|
err := s.db.QueryRowxContext(ctx,
|
||||||
|
`INSERT INTO time_entries (tenant_id, case_id, user_id, date, duration_minutes, description, activity, billable, hourly_rate)
|
||||||
|
VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)
|
||||||
|
RETURNING `+timeEntryCols,
|
||||||
|
tenantID, input.CaseID, userID, input.Date, input.DurationMinutes, input.Description, input.Activity, billable, hourlyRate,
|
||||||
|
).StructScan(&entry)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("create time entry: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
s.audit.Log(ctx, "create", "time_entry", &entry.ID, nil, entry)
|
||||||
|
return &entry, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *TimeEntryService) Update(ctx context.Context, tenantID, entryID uuid.UUID, input UpdateTimeEntryInput) (*models.TimeEntry, error) {
|
||||||
|
old, err := s.GetByID(ctx, tenantID, entryID)
|
||||||
|
if err != nil {
|
||||||
|
return nil, err
|
||||||
|
}
|
||||||
|
if old == nil {
|
||||||
|
return nil, fmt.Errorf("time entry not found")
|
||||||
|
}
|
||||||
|
if old.Billed {
|
||||||
|
return nil, fmt.Errorf("cannot update a billed time entry")
|
||||||
|
}
|
||||||
|
|
||||||
|
var entry models.TimeEntry
|
||||||
|
err = s.db.QueryRowxContext(ctx,
|
||||||
|
`UPDATE time_entries SET
|
||||||
|
date = COALESCE($3, date),
|
||||||
|
duration_minutes = COALESCE($4, duration_minutes),
|
||||||
|
description = COALESCE($5, description),
|
||||||
|
activity = COALESCE($6, activity),
|
||||||
|
billable = COALESCE($7, billable),
|
||||||
|
hourly_rate = COALESCE($8, hourly_rate),
|
||||||
|
updated_at = now()
|
||||||
|
WHERE tenant_id = $1 AND id = $2
|
||||||
|
RETURNING `+timeEntryCols,
|
||||||
|
tenantID, entryID, input.Date, input.DurationMinutes, input.Description, input.Activity, input.Billable, input.HourlyRate,
|
||||||
|
).StructScan(&entry)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("update time entry: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
s.audit.Log(ctx, "update", "time_entry", &entry.ID, old, entry)
|
||||||
|
return &entry, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *TimeEntryService) Delete(ctx context.Context, tenantID, entryID uuid.UUID) error {
|
||||||
|
old, err := s.GetByID(ctx, tenantID, entryID)
|
||||||
|
if err != nil {
|
||||||
|
return err
|
||||||
|
}
|
||||||
|
if old == nil {
|
||||||
|
return fmt.Errorf("time entry not found")
|
||||||
|
}
|
||||||
|
if old.Billed {
|
||||||
|
return fmt.Errorf("cannot delete a billed time entry")
|
||||||
|
}
|
||||||
|
|
||||||
|
_, err = s.db.ExecContext(ctx,
|
||||||
|
`DELETE FROM time_entries WHERE tenant_id = $1 AND id = $2`,
|
||||||
|
tenantID, entryID)
|
||||||
|
if err != nil {
|
||||||
|
return fmt.Errorf("delete time entry: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
s.audit.Log(ctx, "delete", "time_entry", &entryID, old, nil)
|
||||||
|
return nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *TimeEntryService) Summary(ctx context.Context, tenantID uuid.UUID, groupBy string, from, to string) ([]TimeEntrySummary, error) {
|
||||||
|
var groupExpr string
|
||||||
|
switch groupBy {
|
||||||
|
case "user":
|
||||||
|
groupExpr = "user_id::text"
|
||||||
|
case "month":
|
||||||
|
groupExpr = "to_char(date, 'YYYY-MM')"
|
||||||
|
default:
|
||||||
|
groupExpr = "case_id::text"
|
||||||
|
}
|
||||||
|
|
||||||
|
where := "WHERE tenant_id = $1"
|
||||||
|
args := []any{tenantID}
|
||||||
|
argIdx := 2
|
||||||
|
|
||||||
|
if from != "" {
|
||||||
|
where += fmt.Sprintf(" AND date >= $%d", argIdx)
|
||||||
|
args = append(args, from)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if to != "" {
|
||||||
|
where += fmt.Sprintf(" AND date <= $%d", argIdx)
|
||||||
|
args = append(args, to)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
|
||||||
|
query := fmt.Sprintf(`SELECT %s AS group_key,
|
||||||
|
SUM(duration_minutes) AS total_minutes,
|
||||||
|
SUM(CASE WHEN billable THEN duration_minutes ELSE 0 END) AS billable_minutes,
|
||||||
|
SUM(CASE WHEN billable AND hourly_rate IS NOT NULL THEN duration_minutes * hourly_rate / 60.0 ELSE 0 END) AS total_amount,
|
||||||
|
COUNT(*) AS entry_count
|
||||||
|
FROM time_entries %s
|
||||||
|
GROUP BY %s
|
||||||
|
ORDER BY %s`,
|
||||||
|
groupExpr, where, groupExpr, groupExpr)
|
||||||
|
|
||||||
|
var summaries []TimeEntrySummary
|
||||||
|
err := s.db.SelectContext(ctx, &summaries, query, args...)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("time entry summary: %w", err)
|
||||||
|
}
|
||||||
|
return summaries, nil
|
||||||
|
}
|
||||||
@@ -14,7 +14,6 @@
|
|||||||
"react": "19.1.0",
|
"react": "19.1.0",
|
||||||
"react-dom": "19.1.0",
|
"react-dom": "19.1.0",
|
||||||
"react-dropzone": "^15.0.0",
|
"react-dropzone": "^15.0.0",
|
||||||
"recharts": "^3.8.1",
|
|
||||||
"sonner": "^2.0.7",
|
"sonner": "^2.0.7",
|
||||||
},
|
},
|
||||||
"devDependencies": {
|
"devDependencies": {
|
||||||
@@ -245,8 +244,6 @@
|
|||||||
|
|
||||||
"@open-draft/until": ["@open-draft/until@2.1.0", "", {}, "sha512-U69T3ItWHvLwGg5eJ0n3I62nWuE6ilHlmz7zM0npLBRvPRd7e6NYmg54vvRtP5mZG7kZqZCFVdsTWo7BPtBujg=="],
|
"@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-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=="],
|
"@rollup/rollup-android-arm64": ["@rollup/rollup-android-arm64@4.60.0", "", { "os": "android", "cpu": "arm64" }, "sha512-u6JHLll5QKRvjciE78bQXDmqRqNs5M/3GVqZeMwvmjaNODJih/WIrJlFVEihvV0MiYFmd+ZyPr9wxOVbPAG2Iw=="],
|
||||||
@@ -301,10 +298,6 @@
|
|||||||
|
|
||||||
"@rushstack/eslint-patch": ["@rushstack/eslint-patch@1.16.1", "", {}, "sha512-TvZbIpeKqGQQ7X0zSCvPH9riMSFQFSggnfBjFZ1mEoILW+UuXCKwOoPcgjMwiUtRqFZ8jWhPJc4um14vC6I4ag=="],
|
"@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/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=="],
|
"@supabase/functions-js": ["@supabase/functions-js@2.100.0", "", { "dependencies": { "tslib": "2.8.1" } }, "sha512-keLg79RPwP+uiwHuxFPTFgDRxPV46LM4j/swjyR2GKJgWniTVSsgiBHfbIBDcrQwehLepy09b/9QSHUywtKRWQ=="],
|
||||||
@@ -369,24 +362,6 @@
|
|||||||
|
|
||||||
"@types/aria-query": ["@types/aria-query@5.0.4", "", {}, "sha512-rfT93uj5s0PRL7EzccGMs3brplhcrghnDoV26NqKhCAS1hVo+WdNsPvE/yb6ilfr5hi2MEk6d5EWJTKdxg8jVw=="],
|
"@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/estree": ["@types/estree@1.0.8", "", {}, "sha512-dWHzHa2WqEXI/O1E9OjrocMTKJl2mSrEolh1Iomrv6U+JuNwaHXsXx9bLu5gG7BUWFIN0skIQJQ/L1rIex4X6w=="],
|
||||||
|
|
||||||
"@types/json-schema": ["@types/json-schema@7.0.15", "", {}, "sha512-5+fP8P8MFNC+AyZCDxrB2pkZFPGzqQWUzpSeuuVLvm8VMcorNYavBqoFcxK8bQz4Qsbn4oUEEem4wDLfcysGHA=="],
|
"@types/json-schema": ["@types/json-schema@7.0.15", "", {}, "sha512-5+fP8P8MFNC+AyZCDxrB2pkZFPGzqQWUzpSeuuVLvm8VMcorNYavBqoFcxK8bQz4Qsbn4oUEEem4wDLfcysGHA=="],
|
||||||
@@ -401,8 +376,6 @@
|
|||||||
|
|
||||||
"@types/statuses": ["@types/statuses@2.0.6", "", {}, "sha512-xMAgYwceFhRA2zY+XbEA7mxYbA093wdiW8Vu6gZPGWy9cmOyU9XesH1tNcEWsKFd5Vzrqx5T3D38PWx1FIIXkA=="],
|
"@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=="],
|
"@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=="],
|
"@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=="],
|
||||||
@@ -555,8 +528,6 @@
|
|||||||
|
|
||||||
"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=="],
|
"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-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=="],
|
"color-name": ["color-name@1.1.4", "", {}, "sha512-dOy+3AuW3a2wNbZHIuMZpTcgjGuLU/uBL/ubcZF9OXbDo8ff4O8yVp5Bf0efS8uEoYo5q4Fx7dY9OgQGXgAsQA=="],
|
||||||
@@ -575,28 +546,6 @@
|
|||||||
|
|
||||||
"csstype": ["csstype@3.2.3", "", {}, "sha512-z1HGKcYy2xA8AGQfwrn0PAy+PB7X/GSj3UVJW9qKyn43xWa+gl5nXmU4qqLMRzWVLFC8KusUX8T/0kCiOYpAIQ=="],
|
"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=="],
|
"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=="],
|
"data-urls": ["data-urls@5.0.0", "", { "dependencies": { "whatwg-mimetype": "^4.0.0", "whatwg-url": "^14.0.0" } }, "sha512-ZYP5VBHshaDAiVZxjbRVcFJpc+4xGgT0bK3vzy1HLN8jTO975HEbuYzZJcHoQEY5K1a0z8YayJkyVETa08eNTg=="],
|
||||||
@@ -613,8 +562,6 @@
|
|||||||
|
|
||||||
"decimal.js": ["decimal.js@10.6.0", "", {}, "sha512-YpgQiITW3JXGntzdUmyUR1V812Hn8T1YVXhCu+wO3OpS4eU9l4YdD3qjyiKdV6mvV29zapkMeD390UVEf2lkUg=="],
|
"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-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=="],
|
"deep-is": ["deep-is@0.1.4", "", {}, "sha512-oIPzksmTg4/MriiaYGO+okXDT7ztn/w3Eptv/+gSIdMdKsJo0u4CfYNFJPy+4SKMuCqGw2wxnA+URMg3t8a/bQ=="],
|
||||||
@@ -659,8 +606,6 @@
|
|||||||
|
|
||||||
"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-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=="],
|
"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=="],
|
"escalade": ["escalade@3.2.0", "", {}, "sha512-WUj2qlxaQtO4g6Pq5c29GTcWGDyd8itL8zTlipgECz3JesAiiOKotd8JU6otB3PACgG6xkJUyVhboMS+bje/jA=="],
|
||||||
@@ -701,8 +646,6 @@
|
|||||||
|
|
||||||
"esutils": ["esutils@2.0.3", "", {}, "sha512-kVscqXk4OCp68SZ0dkgEKVi6/8ij300KBWTJq32P/dYeWTSwK41WyTxalN1eRmA5Z9UU/LX9D7FWSmV9SAYx6g=="],
|
"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=="],
|
"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=="],
|
"fast-deep-equal": ["fast-deep-equal@3.1.3", "", {}, "sha512-f3qQ9oQy9j2AhBe/H9VC91wLmKBCCU/gDOnKNAYG5hswO7BLKj09Hc5HYNz9cGI++xlpDCIgDaitVs03ATR84Q=="],
|
||||||
@@ -793,8 +736,6 @@
|
|||||||
|
|
||||||
"ignore": ["ignore@5.3.2", "", {}, "sha512-hsBTNUqQTDwkWtcdYI2i06Y/nUBEsNEDJKjWdigLvegy8kDuJAS8uRlpkkcQpyEXL0Z/pjDy5HBmMjRCJ2gq+g=="],
|
"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=="],
|
"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=="],
|
"imurmurhash": ["imurmurhash@0.1.4", "", {}, "sha512-JmXMZ6wuvDmLiHEml9ykzqO6lwFbof0GG4IkcGaENdCRDDmMVnny7s5HsIgHCbaq0w2MyPhDqkhTUgS2LU2PHA=="],
|
||||||
@@ -803,8 +744,6 @@
|
|||||||
|
|
||||||
"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=="],
|
"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-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=="],
|
"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=="],
|
||||||
@@ -1039,18 +978,10 @@
|
|||||||
|
|
||||||
"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-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@17.0.2", "", {}, "sha512-w2GsyukL62IJnlaff/nRegPQR94C/XXamvMWmSHRJ4y7Ts/4ocGRmTHvOs8PSE6pB3dWOrD/nueuU5sduBsQ4w=="],
|
"react-is": ["react-is@16.13.1", "", {}, "sha512-24e6ynE2H+OKt4kqsOvNd8kBpV65zoxbA4BVsEOB3ARVWQki/DHzaUoC5KuON/BiccDaCCTZBuOcfZs70kR8bQ=="],
|
||||||
|
|
||||||
"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=="],
|
"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=="],
|
"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=="],
|
"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=="],
|
||||||
@@ -1059,8 +990,6 @@
|
|||||||
|
|
||||||
"requires-port": ["requires-port@1.0.0", "", {}, "sha512-KigOCHcocU3XODJxsu8i/j8T9tzT4adHiecwORRQ0ZZFcp7ahwXuRU1m+yuO90C5ZUyGeGfocHDI14M3L3yDAQ=="],
|
"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": ["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=="],
|
"resolve-from": ["resolve-from@4.0.0", "", {}, "sha512-pb/MYmXstAkysRFx8piNI1tGFNQIFA3vkE3Gq4EuA1dF6gHp/+vgZqsCGJapvy8N3Q+4o7FwvquPJcnZ7RYy4g=="],
|
||||||
@@ -1167,8 +1096,6 @@
|
|||||||
|
|
||||||
"tapable": ["tapable@2.3.2", "", {}, "sha512-1MOpMXuhGzGL5TTCZFItxCc0AARf1EZFQkGqMm7ERKj8+Hgr5oLvJOVFcC+lRmR8hCe2S3jC4T5D7Vg/d7/fhA=="],
|
"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=="],
|
"tinybench": ["tinybench@2.9.0", "", {}, "sha512-0+DUvqWMValLmha6lr4kD8iAMK1HzV0/aKnCtWb9v9641TnP/MFb7Pc2bxoxQjTXAErryXVgUOfv2YqNllqGeg=="],
|
||||||
|
|
||||||
"tinyexec": ["tinyexec@0.3.2", "", {}, "sha512-KQQR9yN7R5+OSwaK0XQoj22pwHoTlgYqmUscPYoknOoWCWfj/5/ABTMRi69FrKU5ffPVh5QcFikpWJI/P1ocHA=="],
|
"tinyexec": ["tinyexec@0.3.2", "", {}, "sha512-KQQR9yN7R5+OSwaK0XQoj22pwHoTlgYqmUscPYoknOoWCWfj/5/ABTMRi69FrKU5ffPVh5QcFikpWJI/P1ocHA=="],
|
||||||
@@ -1225,10 +1152,6 @@
|
|||||||
|
|
||||||
"url-parse": ["url-parse@1.5.10", "", { "dependencies": { "querystringify": "^2.1.1", "requires-port": "^1.0.0" } }, "sha512-WypcfiRhfeUP9vvF0j6rw0J3hrWrw6iZv3+22h6iRMJ/8z1Tj6XfLP4DsUix5MhMPnXpiHDoKyoZ/bdCkwBCiQ=="],
|
"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": ["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=="],
|
"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=="],
|
||||||
@@ -1279,8 +1202,6 @@
|
|||||||
|
|
||||||
"@eslint-community/eslint-utils/eslint-visitor-keys": ["eslint-visitor-keys@3.4.3", "", {}, "sha512-wpc+LXeiyiisxPlEkUzU6svyS1frIO3Mgxj1fdy7Pm8Ygzguax2N3Fa/D/ag1WqbOprdI+uY6wMUl8/a2G+iag=="],
|
"@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/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=="],
|
"@tailwindcss/oxide-wasm32-wasi/@emnapi/runtime": ["@emnapi/runtime@1.9.1", "", { "dependencies": { "tslib": "^2.4.0" }, "bundled": true }, "sha512-VYi5+ZVLhpgK4hQ0TAjiQiZ6ol0oe4mBx7mVv7IflsiEp0OWoVsp/+f9Vc1hOhE0TtkORVrI1GvzyreqpgWtkA=="],
|
||||||
@@ -1333,7 +1254,7 @@
|
|||||||
|
|
||||||
"pretty-format/ansi-styles": ["ansi-styles@5.2.0", "", {}, "sha512-Cxwpt2SfTzTtXcfOlzGEee8O+c+MmUgGrNiBcXnuWxuFJHe6a5Hz7qwhwe5OgaSYI0IJvkLqWX1ASG+cJOkEiA=="],
|
"pretty-format/ansi-styles": ["ansi-styles@5.2.0", "", {}, "sha512-Cxwpt2SfTzTtXcfOlzGEee8O+c+MmUgGrNiBcXnuWxuFJHe6a5Hz7qwhwe5OgaSYI0IJvkLqWX1ASG+cJOkEiA=="],
|
||||||
|
|
||||||
"prop-types/react-is": ["react-is@16.13.1", "", {}, "sha512-24e6ynE2H+OKt4kqsOvNd8kBpV65zoxbA4BVsEOB3ARVWQki/DHzaUoC5KuON/BiccDaCCTZBuOcfZs70kR8bQ=="],
|
"pretty-format/react-is": ["react-is@17.0.2", "", {}, "sha512-w2GsyukL62IJnlaff/nRegPQR94C/XXamvMWmSHRJ4y7Ts/4ocGRmTHvOs8PSE6pB3dWOrD/nueuU5sduBsQ4w=="],
|
||||||
|
|
||||||
"sharp/semver": ["semver@7.7.4", "", { "bin": { "semver": "bin/semver.js" } }, "sha512-vFKC2IEtQnVhpT78h1Yp8wzwrf8CM+MzKMHGJZfBtzhZNycRFnXsHk6E5TxIkkMsgNS7mdX3AGB7x2QM2di4lA=="],
|
"sharp/semver": ["semver@7.7.4", "", { "bin": { "semver": "bin/semver.js" } }, "sha512-vFKC2IEtQnVhpT78h1Yp8wzwrf8CM+MzKMHGJZfBtzhZNycRFnXsHk6E5TxIkkMsgNS7mdX3AGB7x2QM2di4lA=="],
|
||||||
|
|
||||||
|
|||||||
@@ -20,7 +20,6 @@
|
|||||||
"react": "19.1.0",
|
"react": "19.1.0",
|
||||||
"react-dom": "19.1.0",
|
"react-dom": "19.1.0",
|
||||||
"react-dropzone": "^15.0.0",
|
"react-dropzone": "^15.0.0",
|
||||||
"recharts": "^3.8.1",
|
|
||||||
"sonner": "^2.0.7"
|
"sonner": "^2.0.7"
|
||||||
},
|
},
|
||||||
"devDependencies": {
|
"devDependencies": {
|
||||||
|
|||||||
164
frontend/src/app/(app)/abrechnung/page.tsx
Normal file
164
frontend/src/app/(app)/abrechnung/page.tsx
Normal file
@@ -0,0 +1,164 @@
|
|||||||
|
"use client";
|
||||||
|
|
||||||
|
import { useQuery } from "@tanstack/react-query";
|
||||||
|
import { api } from "@/lib/api";
|
||||||
|
import type { TimeEntry } from "@/lib/types";
|
||||||
|
import { format } from "date-fns";
|
||||||
|
import { de } from "date-fns/locale";
|
||||||
|
import { Timer, Loader2 } from "lucide-react";
|
||||||
|
import { useState } from "react";
|
||||||
|
import Link from "next/link";
|
||||||
|
import { Breadcrumb } from "@/components/layout/Breadcrumb";
|
||||||
|
|
||||||
|
function formatDuration(minutes: number): string {
|
||||||
|
const h = Math.floor(minutes / 60);
|
||||||
|
const m = minutes % 60;
|
||||||
|
if (h === 0) return `${m}min`;
|
||||||
|
if (m === 0) return `${h}h`;
|
||||||
|
return `${h}h ${m}min`;
|
||||||
|
}
|
||||||
|
|
||||||
|
export default function AbrechnungPage() {
|
||||||
|
const [from, setFrom] = useState(() => {
|
||||||
|
const d = new Date();
|
||||||
|
d.setDate(1);
|
||||||
|
return format(d, "yyyy-MM-dd");
|
||||||
|
});
|
||||||
|
const [to, setTo] = useState(() => format(new Date(), "yyyy-MM-dd"));
|
||||||
|
|
||||||
|
const { data, isLoading } = useQuery({
|
||||||
|
queryKey: ["time-entries", from, to],
|
||||||
|
queryFn: () =>
|
||||||
|
api.get<{ time_entries: TimeEntry[]; total: number }>(
|
||||||
|
`/time-entries?from=${from}&to=${to}&limit=100`,
|
||||||
|
),
|
||||||
|
});
|
||||||
|
|
||||||
|
const entries = data?.time_entries ?? [];
|
||||||
|
const totalMinutes = entries.reduce((s, e) => s + e.duration_minutes, 0);
|
||||||
|
const billableMinutes = entries
|
||||||
|
.filter((e) => e.billable)
|
||||||
|
.reduce((s, e) => s + e.duration_minutes, 0);
|
||||||
|
const totalAmount = entries
|
||||||
|
.filter((e) => e.billable && e.hourly_rate)
|
||||||
|
.reduce((s, e) => s + (e.duration_minutes / 60) * (e.hourly_rate ?? 0), 0);
|
||||||
|
|
||||||
|
return (
|
||||||
|
<div className="animate-fade-in">
|
||||||
|
<Breadcrumb
|
||||||
|
items={[
|
||||||
|
{ label: "Dashboard", href: "/dashboard" },
|
||||||
|
{ label: "Abrechnung" },
|
||||||
|
]}
|
||||||
|
/>
|
||||||
|
|
||||||
|
<div className="mt-4 flex flex-col gap-3 sm:flex-row sm:items-center sm:justify-between">
|
||||||
|
<h1 className="text-lg font-semibold text-neutral-900">
|
||||||
|
Zeiterfassung
|
||||||
|
</h1>
|
||||||
|
<Link
|
||||||
|
href="/abrechnung/rechnungen"
|
||||||
|
className="text-sm text-neutral-500 transition-colors hover:text-neutral-700"
|
||||||
|
>
|
||||||
|
Rechnungen ansehen →
|
||||||
|
</Link>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{/* Filters */}
|
||||||
|
<div className="mt-4 flex flex-wrap items-center gap-3">
|
||||||
|
<div className="flex items-center gap-2">
|
||||||
|
<label className="text-xs text-neutral-500">Von</label>
|
||||||
|
<input
|
||||||
|
type="date"
|
||||||
|
value={from}
|
||||||
|
onChange={(e) => setFrom(e.target.value)}
|
||||||
|
className="rounded-md border border-neutral-300 px-2 py-1 text-sm focus:border-neutral-500 focus:outline-none"
|
||||||
|
/>
|
||||||
|
</div>
|
||||||
|
<div className="flex items-center gap-2">
|
||||||
|
<label className="text-xs text-neutral-500">Bis</label>
|
||||||
|
<input
|
||||||
|
type="date"
|
||||||
|
value={to}
|
||||||
|
onChange={(e) => setTo(e.target.value)}
|
||||||
|
className="rounded-md border border-neutral-300 px-2 py-1 text-sm focus:border-neutral-500 focus:outline-none"
|
||||||
|
/>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{/* Summary cards */}
|
||||||
|
<div className="mt-4 grid grid-cols-1 gap-3 sm:grid-cols-3">
|
||||||
|
<div className="rounded-md border border-neutral-200 bg-white p-4">
|
||||||
|
<p className="text-xs text-neutral-500">Gesamt</p>
|
||||||
|
<p className="mt-1 text-xl font-semibold text-neutral-900">
|
||||||
|
{formatDuration(totalMinutes)}
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
<div className="rounded-md border border-neutral-200 bg-white p-4">
|
||||||
|
<p className="text-xs text-neutral-500">Abrechenbar</p>
|
||||||
|
<p className="mt-1 text-xl font-semibold text-neutral-900">
|
||||||
|
{formatDuration(billableMinutes)}
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
<div className="rounded-md border border-neutral-200 bg-white p-4">
|
||||||
|
<p className="text-xs text-neutral-500">Betrag</p>
|
||||||
|
<p className="mt-1 text-xl font-semibold text-neutral-900">
|
||||||
|
{totalAmount.toFixed(2)} EUR
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{/* Entries */}
|
||||||
|
{isLoading ? (
|
||||||
|
<div className="flex items-center justify-center py-8">
|
||||||
|
<Loader2 className="h-5 w-5 animate-spin text-neutral-400" />
|
||||||
|
</div>
|
||||||
|
) : entries.length === 0 ? (
|
||||||
|
<div className="flex flex-col items-center py-12 text-center">
|
||||||
|
<div className="rounded-xl bg-neutral-100 p-3">
|
||||||
|
<Timer className="h-5 w-5 text-neutral-400" />
|
||||||
|
</div>
|
||||||
|
<p className="mt-2 text-sm text-neutral-500">
|
||||||
|
Keine Zeiteintraege im gewaehlten Zeitraum.
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
) : (
|
||||||
|
<div className="mt-4 space-y-2">
|
||||||
|
{entries.map((entry) => (
|
||||||
|
<div
|
||||||
|
key={entry.id}
|
||||||
|
className="flex items-center justify-between rounded-md border border-neutral-200 bg-white px-4 py-3"
|
||||||
|
>
|
||||||
|
<div className="min-w-0 flex-1">
|
||||||
|
<p className="text-sm font-medium text-neutral-900 truncate">
|
||||||
|
{entry.description}
|
||||||
|
</p>
|
||||||
|
<div className="mt-0.5 flex gap-3 text-xs text-neutral-500">
|
||||||
|
<span>
|
||||||
|
{format(new Date(entry.date), "d. MMM yyyy", { locale: de })}
|
||||||
|
</span>
|
||||||
|
<Link
|
||||||
|
href={`/cases/${entry.case_id}/zeiterfassung`}
|
||||||
|
className="hover:text-neutral-700"
|
||||||
|
>
|
||||||
|
Akte ansehen
|
||||||
|
</Link>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
<div className="flex items-center gap-4 ml-4 text-sm">
|
||||||
|
{entry.billable ? (
|
||||||
|
<span className="text-emerald-600">abrechenbar</span>
|
||||||
|
) : (
|
||||||
|
<span className="text-neutral-400">intern</span>
|
||||||
|
)}
|
||||||
|
<span className="font-medium text-neutral-900 whitespace-nowrap">
|
||||||
|
{formatDuration(entry.duration_minutes)}
|
||||||
|
</span>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
))}
|
||||||
|
</div>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
225
frontend/src/app/(app)/abrechnung/rechnungen/[id]/page.tsx
Normal file
225
frontend/src/app/(app)/abrechnung/rechnungen/[id]/page.tsx
Normal file
@@ -0,0 +1,225 @@
|
|||||||
|
"use client";
|
||||||
|
|
||||||
|
import { useQuery, useMutation, useQueryClient } from "@tanstack/react-query";
|
||||||
|
import { useParams } from "next/navigation";
|
||||||
|
import { api } from "@/lib/api";
|
||||||
|
import type { Invoice } from "@/lib/types";
|
||||||
|
import { format } from "date-fns";
|
||||||
|
import { de } from "date-fns/locale";
|
||||||
|
import { Loader2, AlertTriangle } from "lucide-react";
|
||||||
|
import { Breadcrumb } from "@/components/layout/Breadcrumb";
|
||||||
|
|
||||||
|
const STATUS_BADGE: Record<string, string> = {
|
||||||
|
draft: "bg-neutral-100 text-neutral-600",
|
||||||
|
sent: "bg-blue-50 text-blue-700",
|
||||||
|
paid: "bg-emerald-50 text-emerald-700",
|
||||||
|
cancelled: "bg-red-50 text-red-600",
|
||||||
|
};
|
||||||
|
|
||||||
|
const STATUS_LABEL: Record<string, string> = {
|
||||||
|
draft: "Entwurf",
|
||||||
|
sent: "Versendet",
|
||||||
|
paid: "Bezahlt",
|
||||||
|
cancelled: "Storniert",
|
||||||
|
};
|
||||||
|
|
||||||
|
const TRANSITIONS: Record<string, { label: string; next: string }[]> = {
|
||||||
|
draft: [
|
||||||
|
{ label: "Als versendet markieren", next: "sent" },
|
||||||
|
{ label: "Stornieren", next: "cancelled" },
|
||||||
|
],
|
||||||
|
sent: [
|
||||||
|
{ label: "Als bezahlt markieren", next: "paid" },
|
||||||
|
{ label: "Stornieren", next: "cancelled" },
|
||||||
|
],
|
||||||
|
paid: [],
|
||||||
|
cancelled: [],
|
||||||
|
};
|
||||||
|
|
||||||
|
export default function InvoiceDetailPage() {
|
||||||
|
const { id } = useParams<{ id: string }>();
|
||||||
|
const queryClient = useQueryClient();
|
||||||
|
|
||||||
|
const { data: invoice, isLoading, error } = useQuery({
|
||||||
|
queryKey: ["invoice", id],
|
||||||
|
queryFn: () => api.get<Invoice>(`/invoices/${id}`),
|
||||||
|
});
|
||||||
|
|
||||||
|
const statusMutation = useMutation({
|
||||||
|
mutationFn: (status: string) =>
|
||||||
|
api.patch<Invoice>(`/invoices/${id}/status`, { status }),
|
||||||
|
onSuccess: () => {
|
||||||
|
queryClient.invalidateQueries({ queryKey: ["invoice", id] });
|
||||||
|
queryClient.invalidateQueries({ queryKey: ["invoices"] });
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
if (isLoading) {
|
||||||
|
return (
|
||||||
|
<div className="flex items-center justify-center py-12">
|
||||||
|
<Loader2 className="h-5 w-5 animate-spin text-neutral-400" />
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
|
|
||||||
|
if (error || !invoice) {
|
||||||
|
return (
|
||||||
|
<div className="py-12 text-center">
|
||||||
|
<AlertTriangle className="mx-auto h-6 w-6 text-red-500" />
|
||||||
|
<p className="mt-2 text-sm text-neutral-500">
|
||||||
|
Rechnung nicht gefunden.
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
|
|
||||||
|
const items = Array.isArray(invoice.items) ? invoice.items : [];
|
||||||
|
const actions = TRANSITIONS[invoice.status] ?? [];
|
||||||
|
|
||||||
|
return (
|
||||||
|
<div className="animate-fade-in">
|
||||||
|
<Breadcrumb
|
||||||
|
items={[
|
||||||
|
{ label: "Dashboard", href: "/dashboard" },
|
||||||
|
{ label: "Abrechnung", href: "/abrechnung" },
|
||||||
|
{ label: "Rechnungen", href: "/abrechnung/rechnungen" },
|
||||||
|
{ label: invoice.invoice_number },
|
||||||
|
]}
|
||||||
|
/>
|
||||||
|
|
||||||
|
<div className="mt-4 flex flex-col gap-3 sm:flex-row sm:items-start sm:justify-between">
|
||||||
|
<div>
|
||||||
|
<div className="flex items-center gap-3">
|
||||||
|
<h1 className="text-lg font-semibold text-neutral-900">
|
||||||
|
{invoice.invoice_number}
|
||||||
|
</h1>
|
||||||
|
<span
|
||||||
|
className={`rounded-full px-2 py-0.5 text-xs font-medium ${STATUS_BADGE[invoice.status]}`}
|
||||||
|
>
|
||||||
|
{STATUS_LABEL[invoice.status]}
|
||||||
|
</span>
|
||||||
|
</div>
|
||||||
|
<p className="mt-1 text-sm text-neutral-500">
|
||||||
|
{invoice.client_name}
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
<div className="flex gap-2">
|
||||||
|
{actions.map((action) => (
|
||||||
|
<button
|
||||||
|
key={action.next}
|
||||||
|
onClick={() => statusMutation.mutate(action.next)}
|
||||||
|
disabled={statusMutation.isPending}
|
||||||
|
className="rounded-md bg-neutral-900 px-3 py-1.5 text-sm font-medium text-white transition-colors hover:bg-neutral-800 disabled:opacity-50"
|
||||||
|
>
|
||||||
|
{action.label}
|
||||||
|
</button>
|
||||||
|
))}
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{/* Invoice details */}
|
||||||
|
<div className="mt-6 rounded-md border border-neutral-200 bg-white">
|
||||||
|
{/* Client info */}
|
||||||
|
<div className="border-b border-neutral-100 p-4">
|
||||||
|
<p className="text-xs text-neutral-500">Empfaenger</p>
|
||||||
|
<p className="mt-1 text-sm font-medium text-neutral-900">
|
||||||
|
{invoice.client_name}
|
||||||
|
</p>
|
||||||
|
{invoice.client_address && (
|
||||||
|
<p className="mt-0.5 text-sm text-neutral-500 whitespace-pre-line">
|
||||||
|
{invoice.client_address}
|
||||||
|
</p>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{/* Dates */}
|
||||||
|
<div className="flex flex-wrap gap-6 border-b border-neutral-100 p-4">
|
||||||
|
{invoice.issued_at && (
|
||||||
|
<div>
|
||||||
|
<p className="text-xs text-neutral-500">Rechnungsdatum</p>
|
||||||
|
<p className="mt-0.5 text-sm text-neutral-900">
|
||||||
|
{format(new Date(invoice.issued_at), "d. MMMM yyyy", { locale: de })}
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
)}
|
||||||
|
{invoice.due_at && (
|
||||||
|
<div>
|
||||||
|
<p className="text-xs text-neutral-500">Faellig am</p>
|
||||||
|
<p className="mt-0.5 text-sm text-neutral-900">
|
||||||
|
{format(new Date(invoice.due_at), "d. MMMM yyyy", { locale: de })}
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
)}
|
||||||
|
{invoice.paid_at && (
|
||||||
|
<div>
|
||||||
|
<p className="text-xs text-neutral-500">Bezahlt am</p>
|
||||||
|
<p className="mt-0.5 text-sm text-neutral-900">
|
||||||
|
{format(new Date(invoice.paid_at), "d. MMMM yyyy", { locale: de })}
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{/* Line items */}
|
||||||
|
<div className="p-4">
|
||||||
|
<table className="w-full text-sm">
|
||||||
|
<thead>
|
||||||
|
<tr className="border-b border-neutral-100 text-left text-xs text-neutral-500">
|
||||||
|
<th className="pb-2 font-medium">Beschreibung</th>
|
||||||
|
<th className="pb-2 font-medium text-right">Betrag</th>
|
||||||
|
</tr>
|
||||||
|
</thead>
|
||||||
|
<tbody>
|
||||||
|
{items.map((item, i) => (
|
||||||
|
<tr key={i} className="border-b border-neutral-50">
|
||||||
|
<td className="py-2 text-neutral-900">
|
||||||
|
{item.description}
|
||||||
|
{item.duration_minutes && item.hourly_rate && (
|
||||||
|
<span className="ml-2 text-xs text-neutral-400">
|
||||||
|
({Math.floor(item.duration_minutes / 60)}h{" "}
|
||||||
|
{item.duration_minutes % 60}min x {item.hourly_rate} EUR/h)
|
||||||
|
</span>
|
||||||
|
)}
|
||||||
|
</td>
|
||||||
|
<td className="py-2 text-right text-neutral-900">
|
||||||
|
{item.amount.toFixed(2)} EUR
|
||||||
|
</td>
|
||||||
|
</tr>
|
||||||
|
))}
|
||||||
|
</tbody>
|
||||||
|
</table>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{/* Totals */}
|
||||||
|
<div className="border-t border-neutral-200 p-4">
|
||||||
|
<div className="flex justify-end">
|
||||||
|
<div className="w-48 space-y-1">
|
||||||
|
<div className="flex justify-between text-sm">
|
||||||
|
<span className="text-neutral-500">Netto</span>
|
||||||
|
<span>{invoice.subtotal.toFixed(2)} EUR</span>
|
||||||
|
</div>
|
||||||
|
<div className="flex justify-between text-sm">
|
||||||
|
<span className="text-neutral-500">
|
||||||
|
USt. {invoice.tax_rate}%
|
||||||
|
</span>
|
||||||
|
<span>{invoice.tax_amount.toFixed(2)} EUR</span>
|
||||||
|
</div>
|
||||||
|
<div className="flex justify-between border-t border-neutral-200 pt-1 text-sm font-semibold">
|
||||||
|
<span>Gesamt</span>
|
||||||
|
<span>{invoice.total.toFixed(2)} EUR</span>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{/* Notes */}
|
||||||
|
{invoice.notes && (
|
||||||
|
<div className="border-t border-neutral-100 p-4">
|
||||||
|
<p className="text-xs text-neutral-500">Anmerkungen</p>
|
||||||
|
<p className="mt-1 text-sm text-neutral-700">{invoice.notes}</p>
|
||||||
|
</div>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
118
frontend/src/app/(app)/abrechnung/rechnungen/page.tsx
Normal file
118
frontend/src/app/(app)/abrechnung/rechnungen/page.tsx
Normal file
@@ -0,0 +1,118 @@
|
|||||||
|
"use client";
|
||||||
|
|
||||||
|
import { useQuery } from "@tanstack/react-query";
|
||||||
|
import { api } from "@/lib/api";
|
||||||
|
import type { Invoice } from "@/lib/types";
|
||||||
|
import { format } from "date-fns";
|
||||||
|
import { de } from "date-fns/locale";
|
||||||
|
import { Receipt, Loader2 } from "lucide-react";
|
||||||
|
import Link from "next/link";
|
||||||
|
import { useState } from "react";
|
||||||
|
import { Breadcrumb } from "@/components/layout/Breadcrumb";
|
||||||
|
|
||||||
|
const STATUS_BADGE: Record<string, string> = {
|
||||||
|
draft: "bg-neutral-100 text-neutral-600",
|
||||||
|
sent: "bg-blue-50 text-blue-700",
|
||||||
|
paid: "bg-emerald-50 text-emerald-700",
|
||||||
|
cancelled: "bg-red-50 text-red-600",
|
||||||
|
};
|
||||||
|
|
||||||
|
const STATUS_LABEL: Record<string, string> = {
|
||||||
|
draft: "Entwurf",
|
||||||
|
sent: "Versendet",
|
||||||
|
paid: "Bezahlt",
|
||||||
|
cancelled: "Storniert",
|
||||||
|
};
|
||||||
|
|
||||||
|
export default function RechnungenPage() {
|
||||||
|
const [statusFilter, setStatusFilter] = useState("");
|
||||||
|
|
||||||
|
const { data, isLoading } = useQuery({
|
||||||
|
queryKey: ["invoices", statusFilter],
|
||||||
|
queryFn: () => {
|
||||||
|
const params = statusFilter ? `?status=${statusFilter}` : "";
|
||||||
|
return api.get<{ invoices: Invoice[] }>(`/invoices${params}`);
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
const invoices = data?.invoices ?? [];
|
||||||
|
|
||||||
|
return (
|
||||||
|
<div className="animate-fade-in">
|
||||||
|
<Breadcrumb
|
||||||
|
items={[
|
||||||
|
{ label: "Dashboard", href: "/dashboard" },
|
||||||
|
{ label: "Abrechnung", href: "/abrechnung" },
|
||||||
|
{ label: "Rechnungen" },
|
||||||
|
]}
|
||||||
|
/>
|
||||||
|
|
||||||
|
<div className="mt-4 flex items-center justify-between">
|
||||||
|
<h1 className="text-lg font-semibold text-neutral-900">Rechnungen</h1>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{/* Filters */}
|
||||||
|
<div className="mt-4 flex gap-2">
|
||||||
|
{["", "draft", "sent", "paid", "cancelled"].map((s) => (
|
||||||
|
<button
|
||||||
|
key={s}
|
||||||
|
onClick={() => setStatusFilter(s)}
|
||||||
|
className={`rounded-md px-2.5 py-1 text-xs font-medium transition-colors ${
|
||||||
|
statusFilter === s
|
||||||
|
? "bg-neutral-900 text-white"
|
||||||
|
: "bg-neutral-100 text-neutral-600 hover:bg-neutral-200"
|
||||||
|
}`}
|
||||||
|
>
|
||||||
|
{s === "" ? "Alle" : STATUS_LABEL[s]}
|
||||||
|
</button>
|
||||||
|
))}
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{isLoading ? (
|
||||||
|
<div className="flex items-center justify-center py-8">
|
||||||
|
<Loader2 className="h-5 w-5 animate-spin text-neutral-400" />
|
||||||
|
</div>
|
||||||
|
) : invoices.length === 0 ? (
|
||||||
|
<div className="flex flex-col items-center py-12 text-center">
|
||||||
|
<div className="rounded-xl bg-neutral-100 p-3">
|
||||||
|
<Receipt className="h-5 w-5 text-neutral-400" />
|
||||||
|
</div>
|
||||||
|
<p className="mt-2 text-sm text-neutral-500">
|
||||||
|
Keine Rechnungen vorhanden.
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
) : (
|
||||||
|
<div className="mt-4 space-y-2">
|
||||||
|
{invoices.map((inv) => (
|
||||||
|
<Link
|
||||||
|
key={inv.id}
|
||||||
|
href={`/abrechnung/rechnungen/${inv.id}`}
|
||||||
|
className="flex items-center justify-between rounded-md border border-neutral-200 bg-white px-4 py-3 transition-colors hover:bg-neutral-50"
|
||||||
|
>
|
||||||
|
<div>
|
||||||
|
<div className="flex items-center gap-2">
|
||||||
|
<p className="text-sm font-medium text-neutral-900">
|
||||||
|
{inv.invoice_number}
|
||||||
|
</p>
|
||||||
|
<span
|
||||||
|
className={`rounded-full px-2 py-0.5 text-xs font-medium ${STATUS_BADGE[inv.status]}`}
|
||||||
|
>
|
||||||
|
{STATUS_LABEL[inv.status]}
|
||||||
|
</span>
|
||||||
|
</div>
|
||||||
|
<p className="mt-0.5 text-xs text-neutral-500">
|
||||||
|
{inv.client_name}
|
||||||
|
{inv.issued_at &&
|
||||||
|
` — ${format(new Date(inv.issued_at), "d. MMM yyyy", { locale: de })}`}
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
<p className="text-sm font-semibold text-neutral-900">
|
||||||
|
{inv.total.toFixed(2)} EUR
|
||||||
|
</p>
|
||||||
|
</Link>
|
||||||
|
))}
|
||||||
|
</div>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
@@ -1,262 +0,0 @@
|
|||||||
"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>
|
|
||||||
);
|
|
||||||
}
|
|
||||||
@@ -17,6 +17,7 @@ import {
|
|||||||
StickyNote,
|
StickyNote,
|
||||||
AlertTriangle,
|
AlertTriangle,
|
||||||
ScrollText,
|
ScrollText,
|
||||||
|
Timer,
|
||||||
} from "lucide-react";
|
} from "lucide-react";
|
||||||
import { format } from "date-fns";
|
import { format } from "date-fns";
|
||||||
import { de } from "date-fns/locale";
|
import { de } from "date-fns/locale";
|
||||||
@@ -46,6 +47,7 @@ const TABS = [
|
|||||||
{ segment: "dokumente", label: "Dokumente", icon: FileText },
|
{ segment: "dokumente", label: "Dokumente", icon: FileText },
|
||||||
{ segment: "parteien", label: "Parteien", icon: Users },
|
{ segment: "parteien", label: "Parteien", icon: Users },
|
||||||
{ segment: "mitarbeiter", label: "Mitarbeiter", icon: UserCheck },
|
{ segment: "mitarbeiter", label: "Mitarbeiter", icon: UserCheck },
|
||||||
|
{ segment: "zeiterfassung", label: "Zeiterfassung", icon: Timer },
|
||||||
{ segment: "notizen", label: "Notizen", icon: StickyNote },
|
{ segment: "notizen", label: "Notizen", icon: StickyNote },
|
||||||
{ segment: "protokoll", label: "Protokoll", icon: ScrollText },
|
{ segment: "protokoll", label: "Protokoll", icon: ScrollText },
|
||||||
] as const;
|
] as const;
|
||||||
@@ -56,6 +58,7 @@ const TAB_LABELS: Record<string, string> = {
|
|||||||
dokumente: "Dokumente",
|
dokumente: "Dokumente",
|
||||||
parteien: "Parteien",
|
parteien: "Parteien",
|
||||||
mitarbeiter: "Mitarbeiter",
|
mitarbeiter: "Mitarbeiter",
|
||||||
|
zeiterfassung: "Zeiterfassung",
|
||||||
notizen: "Notizen",
|
notizen: "Notizen",
|
||||||
protokoll: "Protokoll",
|
protokoll: "Protokoll",
|
||||||
};
|
};
|
||||||
|
|||||||
306
frontend/src/app/(app)/cases/[id]/zeiterfassung/page.tsx
Normal file
306
frontend/src/app/(app)/cases/[id]/zeiterfassung/page.tsx
Normal file
@@ -0,0 +1,306 @@
|
|||||||
|
"use client";
|
||||||
|
|
||||||
|
import { useQuery, useMutation, useQueryClient } from "@tanstack/react-query";
|
||||||
|
import { useParams } from "next/navigation";
|
||||||
|
import { api } from "@/lib/api";
|
||||||
|
import type { TimeEntry } from "@/lib/types";
|
||||||
|
import { format } from "date-fns";
|
||||||
|
import { de } from "date-fns/locale";
|
||||||
|
import { Timer, Loader2, Plus, Trash2 } from "lucide-react";
|
||||||
|
import { useState } from "react";
|
||||||
|
|
||||||
|
function formatDuration(minutes: number): string {
|
||||||
|
const h = Math.floor(minutes / 60);
|
||||||
|
const m = minutes % 60;
|
||||||
|
if (h === 0) return `${m}min`;
|
||||||
|
if (m === 0) return `${h}h`;
|
||||||
|
return `${h}h ${m}min`;
|
||||||
|
}
|
||||||
|
|
||||||
|
function formatAmount(minutes: number, rate?: number): string {
|
||||||
|
if (!rate) return "-";
|
||||||
|
return `${((minutes / 60) * rate).toFixed(2)} EUR`;
|
||||||
|
}
|
||||||
|
|
||||||
|
const ACTIVITIES = [
|
||||||
|
{ value: "", label: "Keine Kategorie" },
|
||||||
|
{ value: "research", label: "Recherche" },
|
||||||
|
{ value: "drafting", label: "Entwurf" },
|
||||||
|
{ value: "hearing", label: "Verhandlung" },
|
||||||
|
{ value: "call", label: "Telefonat" },
|
||||||
|
{ value: "review", label: "Prüfung" },
|
||||||
|
{ value: "travel", label: "Reise" },
|
||||||
|
{ value: "meeting", label: "Besprechung" },
|
||||||
|
];
|
||||||
|
|
||||||
|
export default function ZeiterfassungPage() {
|
||||||
|
const { id } = useParams<{ id: string }>();
|
||||||
|
const queryClient = useQueryClient();
|
||||||
|
const [showForm, setShowForm] = useState(false);
|
||||||
|
const [desc, setDesc] = useState("");
|
||||||
|
const [hours, setHours] = useState("");
|
||||||
|
const [minutes, setMinutes] = useState("");
|
||||||
|
const [date, setDate] = useState(format(new Date(), "yyyy-MM-dd"));
|
||||||
|
const [activity, setActivity] = useState("");
|
||||||
|
const [billable, setBillable] = useState(true);
|
||||||
|
|
||||||
|
const { data, isLoading } = useQuery({
|
||||||
|
queryKey: ["case-time-entries", id],
|
||||||
|
queryFn: () =>
|
||||||
|
api.get<{ time_entries: TimeEntry[] }>(`/cases/${id}/time-entries`),
|
||||||
|
});
|
||||||
|
|
||||||
|
const createMutation = useMutation({
|
||||||
|
mutationFn: (input: {
|
||||||
|
description: string;
|
||||||
|
duration_minutes: number;
|
||||||
|
date: string;
|
||||||
|
activity?: string;
|
||||||
|
billable: boolean;
|
||||||
|
}) => api.post<TimeEntry>(`/cases/${id}/time-entries`, input),
|
||||||
|
onSuccess: () => {
|
||||||
|
queryClient.invalidateQueries({ queryKey: ["case-time-entries", id] });
|
||||||
|
setShowForm(false);
|
||||||
|
setDesc("");
|
||||||
|
setHours("");
|
||||||
|
setMinutes("");
|
||||||
|
setActivity("");
|
||||||
|
setBillable(true);
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
const deleteMutation = useMutation({
|
||||||
|
mutationFn: (entryId: string) =>
|
||||||
|
api.delete(`/time-entries/${entryId}`),
|
||||||
|
onSuccess: () => {
|
||||||
|
queryClient.invalidateQueries({ queryKey: ["case-time-entries", id] });
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
function handleSubmit(e: React.FormEvent) {
|
||||||
|
e.preventDefault();
|
||||||
|
const totalMinutes = (parseInt(hours || "0") * 60) + parseInt(minutes || "0");
|
||||||
|
if (totalMinutes <= 0 || !desc.trim()) return;
|
||||||
|
createMutation.mutate({
|
||||||
|
description: desc.trim(),
|
||||||
|
duration_minutes: totalMinutes,
|
||||||
|
date,
|
||||||
|
activity: activity || undefined,
|
||||||
|
billable,
|
||||||
|
});
|
||||||
|
}
|
||||||
|
|
||||||
|
if (isLoading) {
|
||||||
|
return (
|
||||||
|
<div className="flex items-center justify-center py-8">
|
||||||
|
<Loader2 className="h-5 w-5 animate-spin text-neutral-400" />
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
|
|
||||||
|
const entries = data?.time_entries ?? [];
|
||||||
|
const totalMinutes = entries.reduce((s, e) => s + e.duration_minutes, 0);
|
||||||
|
const billableMinutes = entries
|
||||||
|
.filter((e) => e.billable)
|
||||||
|
.reduce((s, e) => s + e.duration_minutes, 0);
|
||||||
|
|
||||||
|
return (
|
||||||
|
<div className="space-y-4">
|
||||||
|
{/* Summary bar */}
|
||||||
|
<div className="flex flex-wrap items-center justify-between gap-3">
|
||||||
|
<div className="flex gap-6 text-sm text-neutral-500">
|
||||||
|
<span>
|
||||||
|
Gesamt: <span className="font-medium text-neutral-900">{formatDuration(totalMinutes)}</span>
|
||||||
|
</span>
|
||||||
|
<span>
|
||||||
|
Abrechenbar: <span className="font-medium text-neutral-900">{formatDuration(billableMinutes)}</span>
|
||||||
|
</span>
|
||||||
|
</div>
|
||||||
|
<button
|
||||||
|
onClick={() => setShowForm(!showForm)}
|
||||||
|
className="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"
|
||||||
|
>
|
||||||
|
<Plus className="h-3.5 w-3.5" />
|
||||||
|
Eintrag
|
||||||
|
</button>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{/* Quick add form */}
|
||||||
|
{showForm && (
|
||||||
|
<form
|
||||||
|
onSubmit={handleSubmit}
|
||||||
|
className="rounded-md border border-neutral-200 bg-neutral-50 p-4 space-y-3"
|
||||||
|
>
|
||||||
|
<div>
|
||||||
|
<label className="block text-xs font-medium text-neutral-600 mb-1">
|
||||||
|
Beschreibung
|
||||||
|
</label>
|
||||||
|
<input
|
||||||
|
type="text"
|
||||||
|
value={desc}
|
||||||
|
onChange={(e) => setDesc(e.target.value)}
|
||||||
|
placeholder="Was wurde getan?"
|
||||||
|
className="w-full rounded-md border border-neutral-300 px-3 py-1.5 text-sm focus:border-neutral-500 focus:outline-none"
|
||||||
|
required
|
||||||
|
/>
|
||||||
|
</div>
|
||||||
|
<div className="flex flex-wrap gap-3">
|
||||||
|
<div className="flex-1 min-w-[120px]">
|
||||||
|
<label className="block text-xs font-medium text-neutral-600 mb-1">
|
||||||
|
Dauer
|
||||||
|
</label>
|
||||||
|
<div className="flex gap-2">
|
||||||
|
<div className="flex items-center gap-1">
|
||||||
|
<input
|
||||||
|
type="number"
|
||||||
|
min="0"
|
||||||
|
value={hours}
|
||||||
|
onChange={(e) => setHours(e.target.value)}
|
||||||
|
placeholder="0"
|
||||||
|
className="w-16 rounded-md border border-neutral-300 px-2 py-1.5 text-sm focus:border-neutral-500 focus:outline-none"
|
||||||
|
/>
|
||||||
|
<span className="text-xs text-neutral-500">h</span>
|
||||||
|
</div>
|
||||||
|
<div className="flex items-center gap-1">
|
||||||
|
<input
|
||||||
|
type="number"
|
||||||
|
min="0"
|
||||||
|
max="59"
|
||||||
|
value={minutes}
|
||||||
|
onChange={(e) => setMinutes(e.target.value)}
|
||||||
|
placeholder="0"
|
||||||
|
className="w-16 rounded-md border border-neutral-300 px-2 py-1.5 text-sm focus:border-neutral-500 focus:outline-none"
|
||||||
|
/>
|
||||||
|
<span className="text-xs text-neutral-500">min</span>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
<div className="flex-1 min-w-[120px]">
|
||||||
|
<label className="block text-xs font-medium text-neutral-600 mb-1">
|
||||||
|
Datum
|
||||||
|
</label>
|
||||||
|
<input
|
||||||
|
type="date"
|
||||||
|
value={date}
|
||||||
|
onChange={(e) => setDate(e.target.value)}
|
||||||
|
className="w-full rounded-md border border-neutral-300 px-3 py-1.5 text-sm focus:border-neutral-500 focus:outline-none"
|
||||||
|
/>
|
||||||
|
</div>
|
||||||
|
<div className="flex-1 min-w-[120px]">
|
||||||
|
<label className="block text-xs font-medium text-neutral-600 mb-1">
|
||||||
|
Kategorie
|
||||||
|
</label>
|
||||||
|
<select
|
||||||
|
value={activity}
|
||||||
|
onChange={(e) => setActivity(e.target.value)}
|
||||||
|
className="w-full rounded-md border border-neutral-300 px-3 py-1.5 text-sm focus:border-neutral-500 focus:outline-none"
|
||||||
|
>
|
||||||
|
{ACTIVITIES.map((a) => (
|
||||||
|
<option key={a.value} value={a.value}>
|
||||||
|
{a.label}
|
||||||
|
</option>
|
||||||
|
))}
|
||||||
|
</select>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
<div className="flex items-center justify-between">
|
||||||
|
<label className="flex items-center gap-2 text-sm text-neutral-600">
|
||||||
|
<input
|
||||||
|
type="checkbox"
|
||||||
|
checked={billable}
|
||||||
|
onChange={(e) => setBillable(e.target.checked)}
|
||||||
|
className="rounded border-neutral-300"
|
||||||
|
/>
|
||||||
|
Abrechenbar
|
||||||
|
</label>
|
||||||
|
<div className="flex gap-2">
|
||||||
|
<button
|
||||||
|
type="button"
|
||||||
|
onClick={() => setShowForm(false)}
|
||||||
|
className="rounded-md px-3 py-1.5 text-sm text-neutral-600 transition-colors hover:bg-neutral-100"
|
||||||
|
>
|
||||||
|
Abbrechen
|
||||||
|
</button>
|
||||||
|
<button
|
||||||
|
type="submit"
|
||||||
|
disabled={createMutation.isPending}
|
||||||
|
className="rounded-md bg-neutral-900 px-3 py-1.5 text-sm font-medium text-white transition-colors hover:bg-neutral-800 disabled:opacity-50"
|
||||||
|
>
|
||||||
|
{createMutation.isPending ? "Speichern..." : "Speichern"}
|
||||||
|
</button>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
{createMutation.isError && (
|
||||||
|
<p className="text-sm text-red-600">Fehler beim Speichern.</p>
|
||||||
|
)}
|
||||||
|
</form>
|
||||||
|
)}
|
||||||
|
|
||||||
|
{/* Entries list */}
|
||||||
|
{entries.length === 0 ? (
|
||||||
|
<div className="flex flex-col items-center py-8 text-center">
|
||||||
|
<div className="rounded-xl bg-neutral-100 p-3">
|
||||||
|
<Timer className="h-5 w-5 text-neutral-400" />
|
||||||
|
</div>
|
||||||
|
<p className="mt-2 text-sm text-neutral-500">
|
||||||
|
Keine Zeiteintraege vorhanden.
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
) : (
|
||||||
|
<div className="space-y-2">
|
||||||
|
{entries.map((entry) => (
|
||||||
|
<div
|
||||||
|
key={entry.id}
|
||||||
|
className="flex items-center justify-between rounded-md border border-neutral-200 bg-white px-4 py-3"
|
||||||
|
>
|
||||||
|
<div className="min-w-0 flex-1">
|
||||||
|
<div className="flex items-center gap-2">
|
||||||
|
<p className="text-sm font-medium text-neutral-900 truncate">
|
||||||
|
{entry.description}
|
||||||
|
</p>
|
||||||
|
{entry.activity && (
|
||||||
|
<span className="shrink-0 rounded-full bg-neutral-100 px-2 py-0.5 text-xs text-neutral-500">
|
||||||
|
{ACTIVITIES.find((a) => a.value === entry.activity)?.label ?? entry.activity}
|
||||||
|
</span>
|
||||||
|
)}
|
||||||
|
{!entry.billable && (
|
||||||
|
<span className="shrink-0 rounded-full bg-neutral-100 px-2 py-0.5 text-xs text-neutral-400">
|
||||||
|
nicht abrechenbar
|
||||||
|
</span>
|
||||||
|
)}
|
||||||
|
{entry.billed && (
|
||||||
|
<span className="shrink-0 rounded-full bg-emerald-50 px-2 py-0.5 text-xs text-emerald-700">
|
||||||
|
abgerechnet
|
||||||
|
</span>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
<div className="mt-0.5 flex gap-4 text-xs text-neutral-500">
|
||||||
|
<span>
|
||||||
|
{format(new Date(entry.date), "d. MMM yyyy", { locale: de })}
|
||||||
|
</span>
|
||||||
|
{entry.hourly_rate && (
|
||||||
|
<span>{formatAmount(entry.duration_minutes, entry.hourly_rate)}</span>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
<div className="flex items-center gap-3 ml-4">
|
||||||
|
<span className="text-sm font-medium text-neutral-900 whitespace-nowrap">
|
||||||
|
{formatDuration(entry.duration_minutes)}
|
||||||
|
</span>
|
||||||
|
{!entry.billed && (
|
||||||
|
<button
|
||||||
|
onClick={() => deleteMutation.mutate(entry.id)}
|
||||||
|
className="rounded-md p-1 text-neutral-400 transition-colors hover:bg-red-50 hover:text-red-600"
|
||||||
|
title="Loeschen"
|
||||||
|
>
|
||||||
|
<Trash2 className="h-3.5 w-3.5" />
|
||||||
|
</button>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
))}
|
||||||
|
</div>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
166
frontend/src/app/(app)/einstellungen/abrechnung/page.tsx
Normal file
166
frontend/src/app/(app)/einstellungen/abrechnung/page.tsx
Normal file
@@ -0,0 +1,166 @@
|
|||||||
|
"use client";
|
||||||
|
|
||||||
|
import { useQuery, useMutation, useQueryClient } from "@tanstack/react-query";
|
||||||
|
import { api } from "@/lib/api";
|
||||||
|
import type { BillingRate } from "@/lib/types";
|
||||||
|
import { format } from "date-fns";
|
||||||
|
import { de } from "date-fns/locale";
|
||||||
|
import { Loader2, Plus } from "lucide-react";
|
||||||
|
import { useState } from "react";
|
||||||
|
import { Breadcrumb } from "@/components/layout/Breadcrumb";
|
||||||
|
|
||||||
|
export default function BillingRatesPage() {
|
||||||
|
const queryClient = useQueryClient();
|
||||||
|
const [showForm, setShowForm] = useState(false);
|
||||||
|
const [rate, setRate] = useState("");
|
||||||
|
const [validFrom, setValidFrom] = useState(format(new Date(), "yyyy-MM-dd"));
|
||||||
|
|
||||||
|
const { data, isLoading } = useQuery({
|
||||||
|
queryKey: ["billing-rates"],
|
||||||
|
queryFn: () =>
|
||||||
|
api.get<{ billing_rates: BillingRate[] }>("/billing-rates"),
|
||||||
|
});
|
||||||
|
|
||||||
|
const upsertMutation = useMutation({
|
||||||
|
mutationFn: (input: { rate: number; valid_from: string; currency: string }) =>
|
||||||
|
api.put<BillingRate>("/billing-rates", input),
|
||||||
|
onSuccess: () => {
|
||||||
|
queryClient.invalidateQueries({ queryKey: ["billing-rates"] });
|
||||||
|
setShowForm(false);
|
||||||
|
setRate("");
|
||||||
|
},
|
||||||
|
});
|
||||||
|
|
||||||
|
function handleSubmit(e: React.FormEvent) {
|
||||||
|
e.preventDefault();
|
||||||
|
const rateNum = parseFloat(rate);
|
||||||
|
if (isNaN(rateNum) || rateNum < 0) return;
|
||||||
|
upsertMutation.mutate({
|
||||||
|
rate: rateNum,
|
||||||
|
valid_from: validFrom,
|
||||||
|
currency: "EUR",
|
||||||
|
});
|
||||||
|
}
|
||||||
|
|
||||||
|
const rates = data?.billing_rates ?? [];
|
||||||
|
|
||||||
|
return (
|
||||||
|
<div className="animate-fade-in">
|
||||||
|
<Breadcrumb
|
||||||
|
items={[
|
||||||
|
{ label: "Dashboard", href: "/dashboard" },
|
||||||
|
{ label: "Einstellungen", href: "/einstellungen" },
|
||||||
|
{ label: "Stundensaetze" },
|
||||||
|
]}
|
||||||
|
/>
|
||||||
|
|
||||||
|
<div className="mt-4 flex items-center justify-between">
|
||||||
|
<h1 className="text-lg font-semibold text-neutral-900">
|
||||||
|
Stundensaetze
|
||||||
|
</h1>
|
||||||
|
<button
|
||||||
|
onClick={() => setShowForm(!showForm)}
|
||||||
|
className="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"
|
||||||
|
>
|
||||||
|
<Plus className="h-3.5 w-3.5" />
|
||||||
|
Neuer Satz
|
||||||
|
</button>
|
||||||
|
</div>
|
||||||
|
|
||||||
|
{showForm && (
|
||||||
|
<form
|
||||||
|
onSubmit={handleSubmit}
|
||||||
|
className="mt-4 rounded-md border border-neutral-200 bg-neutral-50 p-4 space-y-3"
|
||||||
|
>
|
||||||
|
<div className="flex flex-wrap gap-3">
|
||||||
|
<div className="flex-1 min-w-[150px]">
|
||||||
|
<label className="block text-xs font-medium text-neutral-600 mb-1">
|
||||||
|
Stundensatz (EUR)
|
||||||
|
</label>
|
||||||
|
<input
|
||||||
|
type="number"
|
||||||
|
min="0"
|
||||||
|
step="0.01"
|
||||||
|
value={rate}
|
||||||
|
onChange={(e) => setRate(e.target.value)}
|
||||||
|
placeholder="z.B. 350.00"
|
||||||
|
className="w-full rounded-md border border-neutral-300 px-3 py-1.5 text-sm focus:border-neutral-500 focus:outline-none"
|
||||||
|
required
|
||||||
|
/>
|
||||||
|
</div>
|
||||||
|
<div className="flex-1 min-w-[150px]">
|
||||||
|
<label className="block text-xs font-medium text-neutral-600 mb-1">
|
||||||
|
Gueltig ab
|
||||||
|
</label>
|
||||||
|
<input
|
||||||
|
type="date"
|
||||||
|
value={validFrom}
|
||||||
|
onChange={(e) => setValidFrom(e.target.value)}
|
||||||
|
className="w-full rounded-md border border-neutral-300 px-3 py-1.5 text-sm focus:border-neutral-500 focus:outline-none"
|
||||||
|
required
|
||||||
|
/>
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
<div className="flex justify-end gap-2">
|
||||||
|
<button
|
||||||
|
type="button"
|
||||||
|
onClick={() => setShowForm(false)}
|
||||||
|
className="rounded-md px-3 py-1.5 text-sm text-neutral-600 hover:bg-neutral-100"
|
||||||
|
>
|
||||||
|
Abbrechen
|
||||||
|
</button>
|
||||||
|
<button
|
||||||
|
type="submit"
|
||||||
|
disabled={upsertMutation.isPending}
|
||||||
|
className="rounded-md bg-neutral-900 px-3 py-1.5 text-sm font-medium text-white hover:bg-neutral-800 disabled:opacity-50"
|
||||||
|
>
|
||||||
|
Speichern
|
||||||
|
</button>
|
||||||
|
</div>
|
||||||
|
</form>
|
||||||
|
)}
|
||||||
|
|
||||||
|
{isLoading ? (
|
||||||
|
<div className="flex items-center justify-center py-8">
|
||||||
|
<Loader2 className="h-5 w-5 animate-spin text-neutral-400" />
|
||||||
|
</div>
|
||||||
|
) : rates.length === 0 ? (
|
||||||
|
<div className="mt-8 text-center">
|
||||||
|
<p className="text-sm text-neutral-500">
|
||||||
|
Noch keine Stundensaetze definiert.
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
) : (
|
||||||
|
<div className="mt-4 space-y-2">
|
||||||
|
{rates.map((r) => (
|
||||||
|
<div
|
||||||
|
key={r.id}
|
||||||
|
className="flex items-center justify-between rounded-md border border-neutral-200 bg-white px-4 py-3"
|
||||||
|
>
|
||||||
|
<div>
|
||||||
|
<p className="text-sm font-medium text-neutral-900">
|
||||||
|
{r.rate.toFixed(2)} {r.currency}/h
|
||||||
|
</p>
|
||||||
|
<p className="mt-0.5 text-xs text-neutral-500">
|
||||||
|
{r.user_id ? `Benutzer: ${r.user_id.slice(0, 8)}...` : "Standard (alle Benutzer)"}
|
||||||
|
</p>
|
||||||
|
</div>
|
||||||
|
<div className="text-right text-xs text-neutral-500">
|
||||||
|
<p>
|
||||||
|
Ab{" "}
|
||||||
|
{format(new Date(r.valid_from), "d. MMM yyyy", { locale: de })}
|
||||||
|
</p>
|
||||||
|
{r.valid_to && (
|
||||||
|
<p>
|
||||||
|
Bis{" "}
|
||||||
|
{format(new Date(r.valid_to), "d. MMM yyyy", { locale: de })}
|
||||||
|
</p>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
</div>
|
||||||
|
))}
|
||||||
|
</div>
|
||||||
|
)}
|
||||||
|
</div>
|
||||||
|
);
|
||||||
|
}
|
||||||
@@ -8,10 +8,10 @@ import {
|
|||||||
Clock,
|
Clock,
|
||||||
Calendar,
|
Calendar,
|
||||||
Brain,
|
Brain,
|
||||||
BarChart3,
|
|
||||||
Settings,
|
Settings,
|
||||||
Menu,
|
Menu,
|
||||||
X,
|
X,
|
||||||
|
Receipt,
|
||||||
} from "lucide-react";
|
} from "lucide-react";
|
||||||
import { useState, useEffect } from "react";
|
import { useState, useEffect } from "react";
|
||||||
import { usePermissions } from "@/lib/hooks/usePermissions";
|
import { usePermissions } from "@/lib/hooks/usePermissions";
|
||||||
@@ -28,7 +28,7 @@ const allNavigation: NavItem[] = [
|
|||||||
{ name: "Akten", href: "/cases", icon: FolderOpen },
|
{ name: "Akten", href: "/cases", icon: FolderOpen },
|
||||||
{ name: "Fristen", href: "/fristen", icon: Clock },
|
{ name: "Fristen", href: "/fristen", icon: Clock },
|
||||||
{ name: "Termine", href: "/termine", icon: Calendar },
|
{ name: "Termine", href: "/termine", icon: Calendar },
|
||||||
{ name: "Berichte", href: "/berichte", icon: BarChart3 },
|
{ name: "Abrechnung", href: "/abrechnung", icon: Receipt, permission: "manage_billing" },
|
||||||
{ name: "AI Analyse", href: "/ai/extract", icon: Brain, permission: "ai_extraction" },
|
{ name: "AI Analyse", href: "/ai/extract", icon: Brain, permission: "ai_extraction" },
|
||||||
{ name: "Einstellungen", href: "/einstellungen", icon: Settings, permission: "manage_settings" },
|
{ name: "Einstellungen", href: "/einstellungen", icon: Settings, permission: "manage_settings" },
|
||||||
];
|
];
|
||||||
|
|||||||
@@ -1,240 +0,0 @@
|
|||||||
"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>
|
|
||||||
);
|
|
||||||
}
|
|
||||||
@@ -1,223 +0,0 @@
|
|||||||
"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>
|
|
||||||
);
|
|
||||||
}
|
|
||||||
@@ -1,204 +0,0 @@
|
|||||||
"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>
|
|
||||||
);
|
|
||||||
}
|
|
||||||
@@ -1,187 +0,0 @@
|
|||||||
"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>
|
|
||||||
);
|
|
||||||
}
|
|
||||||
@@ -223,6 +223,125 @@ export const CASE_ASSIGNMENT_ROLE_LABELS: Record<CaseAssignmentRole, string> = {
|
|||||||
viewer: "Einsicht",
|
viewer: "Einsicht",
|
||||||
};
|
};
|
||||||
|
|
||||||
|
// Time tracking & billing
|
||||||
|
|
||||||
|
export interface TimeEntry {
|
||||||
|
id: string;
|
||||||
|
tenant_id: string;
|
||||||
|
case_id: string;
|
||||||
|
user_id: string;
|
||||||
|
date: string;
|
||||||
|
duration_minutes: number;
|
||||||
|
description: string;
|
||||||
|
activity?: string;
|
||||||
|
billable: boolean;
|
||||||
|
billed: boolean;
|
||||||
|
invoice_id?: string;
|
||||||
|
hourly_rate?: number;
|
||||||
|
created_at: string;
|
||||||
|
updated_at: string;
|
||||||
|
}
|
||||||
|
|
||||||
|
export interface BillingRate {
|
||||||
|
id: string;
|
||||||
|
tenant_id: string;
|
||||||
|
user_id?: string;
|
||||||
|
rate: number;
|
||||||
|
currency: string;
|
||||||
|
valid_from: string;
|
||||||
|
valid_to?: string;
|
||||||
|
created_at: string;
|
||||||
|
}
|
||||||
|
|
||||||
|
export interface InvoiceItem {
|
||||||
|
description: string;
|
||||||
|
duration_minutes?: number;
|
||||||
|
hourly_rate?: number;
|
||||||
|
amount: number;
|
||||||
|
time_entry_id?: string;
|
||||||
|
}
|
||||||
|
|
||||||
|
export interface Invoice {
|
||||||
|
id: string;
|
||||||
|
tenant_id: string;
|
||||||
|
case_id: string;
|
||||||
|
invoice_number: string;
|
||||||
|
client_name: string;
|
||||||
|
client_address?: string;
|
||||||
|
items: InvoiceItem[];
|
||||||
|
subtotal: number;
|
||||||
|
tax_rate: number;
|
||||||
|
tax_amount: number;
|
||||||
|
total: number;
|
||||||
|
status: "draft" | "sent" | "paid" | "cancelled";
|
||||||
|
issued_at?: string;
|
||||||
|
due_at?: string;
|
||||||
|
paid_at?: string;
|
||||||
|
notes?: string;
|
||||||
|
created_by: string;
|
||||||
|
created_at: string;
|
||||||
|
updated_at: string;
|
||||||
|
}
|
||||||
|
|
||||||
|
export interface TimeEntrySummary {
|
||||||
|
group_key: string;
|
||||||
|
total_minutes: number;
|
||||||
|
billable_minutes: number;
|
||||||
|
total_amount: number;
|
||||||
|
entry_count: number;
|
||||||
|
}
|
||||||
|
|
||||||
|
// Notifications
|
||||||
|
export interface Notification {
|
||||||
|
id: string;
|
||||||
|
tenant_id: string;
|
||||||
|
user_id: string;
|
||||||
|
type: string;
|
||||||
|
title: string;
|
||||||
|
body?: string;
|
||||||
|
entity_type?: string;
|
||||||
|
entity_id?: string;
|
||||||
|
sent_at?: string;
|
||||||
|
read_at?: string;
|
||||||
|
created_at: 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 interface NotificationListResponse {
|
||||||
|
notifications: Notification[];
|
||||||
|
data: Notification[];
|
||||||
|
total: number;
|
||||||
|
}
|
||||||
|
|
||||||
|
// Audit log
|
||||||
|
export interface AuditLogEntry {
|
||||||
|
id: number;
|
||||||
|
tenant_id: string;
|
||||||
|
user_id?: string;
|
||||||
|
action: 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 AuditLogResponse {
|
||||||
|
entries: AuditLogEntry[];
|
||||||
|
total: number;
|
||||||
|
}
|
||||||
|
|
||||||
export interface ApiError {
|
export interface ApiError {
|
||||||
error: string;
|
error: string;
|
||||||
status: number;
|
status: number;
|
||||||
@@ -329,149 +448,3 @@ export interface ExtractionResponse {
|
|||||||
deadlines: ExtractedDeadline[];
|
deadlines: ExtractedDeadline[];
|
||||||
count: number;
|
count: number;
|
||||||
}
|
}
|
||||||
|
|
||||||
// Notification types
|
|
||||||
|
|
||||||
export interface Notification {
|
|
||||||
id: string;
|
|
||||||
tenant_id: string;
|
|
||||||
user_id: string;
|
|
||||||
type: string;
|
|
||||||
entity_type?: string;
|
|
||||||
entity_id?: string;
|
|
||||||
title: string;
|
|
||||||
body?: string;
|
|
||||||
sent_at?: string;
|
|
||||||
read_at?: string;
|
|
||||||
created_at: 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 interface NotificationListResponse {
|
|
||||||
data: Notification[];
|
|
||||||
total: number;
|
|
||||||
}
|
|
||||||
|
|
||||||
// Audit log types
|
|
||||||
|
|
||||||
export interface AuditLogEntry {
|
|
||||||
id: number;
|
|
||||||
tenant_id: string;
|
|
||||||
user_id?: string;
|
|
||||||
action: 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 AuditLogResponse {
|
|
||||||
entries: AuditLogEntry[];
|
|
||||||
total: number;
|
|
||||||
page: number;
|
|
||||||
limit: number;
|
|
||||||
}
|
|
||||||
|
|
||||||
// Reporting types
|
|
||||||
|
|
||||||
export interface CaseStats {
|
|
||||||
period: string;
|
|
||||||
opened: number;
|
|
||||||
closed: number;
|
|
||||||
active: number;
|
|
||||||
}
|
|
||||||
|
|
||||||
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[];
|
|
||||||
}
|
|
||||||
|
|||||||
Reference in New Issue
Block a user