Compare commits
8 Commits
mai/knuth/
...
mai/pike/p
| Author | SHA1 | Date | |
|---|---|---|---|
|
|
5758e2c37f | ||
|
|
2c16f26448 | ||
|
|
f0ee5921cf | ||
|
|
ba29fc75c7 | ||
|
|
8350a7e7fb | ||
|
|
42a62d45bf | ||
|
|
f11c411147 | ||
|
|
bd15b4eb38 |
14
.claude/agents/coder.md
Normal file
14
.claude/agents/coder.md
Normal file
@@ -0,0 +1,14 @@
|
|||||||
|
# Coder Agent
|
||||||
|
|
||||||
|
Implementation-focused agent for writing and refactoring code.
|
||||||
|
|
||||||
|
## Instructions
|
||||||
|
|
||||||
|
- Follow existing patterns in the codebase
|
||||||
|
- Write minimal, focused code
|
||||||
|
- Run tests after changes
|
||||||
|
- Commit incrementally with descriptive messages
|
||||||
|
|
||||||
|
## Tools
|
||||||
|
|
||||||
|
All tools available.
|
||||||
14
.claude/agents/researcher.md
Normal file
14
.claude/agents/researcher.md
Normal file
@@ -0,0 +1,14 @@
|
|||||||
|
# Researcher Agent
|
||||||
|
|
||||||
|
Exploration and information gathering agent.
|
||||||
|
|
||||||
|
## Instructions
|
||||||
|
|
||||||
|
- Search broadly, then narrow down
|
||||||
|
- Document findings in structured format
|
||||||
|
- Cite sources and file paths
|
||||||
|
- Summarize key insights, don't dump raw data
|
||||||
|
|
||||||
|
## Tools
|
||||||
|
|
||||||
|
Read-only tools preferred. Use Bash only for non-destructive commands.
|
||||||
14
.claude/agents/reviewer.md
Normal file
14
.claude/agents/reviewer.md
Normal file
@@ -0,0 +1,14 @@
|
|||||||
|
# Reviewer Agent
|
||||||
|
|
||||||
|
Code review agent for checking quality and correctness.
|
||||||
|
|
||||||
|
## Instructions
|
||||||
|
|
||||||
|
- Check for bugs, security issues, and style violations
|
||||||
|
- Verify test coverage for changes
|
||||||
|
- Suggest improvements concisely
|
||||||
|
- Focus on correctness over style preferences
|
||||||
|
|
||||||
|
## Tools
|
||||||
|
|
||||||
|
Read-only tools. No file modifications.
|
||||||
1
.claude/skills/mai-clone
Symbolic link
1
.claude/skills/mai-clone
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-clone
|
||||||
1
.claude/skills/mai-coder
Symbolic link
1
.claude/skills/mai-coder
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-coder
|
||||||
1
.claude/skills/mai-commit
Symbolic link
1
.claude/skills/mai-commit
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-commit
|
||||||
1
.claude/skills/mai-consultant
Symbolic link
1
.claude/skills/mai-consultant
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-consultant
|
||||||
1
.claude/skills/mai-daily
Symbolic link
1
.claude/skills/mai-daily
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-daily
|
||||||
1
.claude/skills/mai-debrief
Symbolic link
1
.claude/skills/mai-debrief
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-debrief
|
||||||
1
.claude/skills/mai-enemy
Symbolic link
1
.claude/skills/mai-enemy
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-enemy
|
||||||
1
.claude/skills/mai-excalidraw
Symbolic link
1
.claude/skills/mai-excalidraw
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-excalidraw
|
||||||
1
.claude/skills/mai-fixer
Symbolic link
1
.claude/skills/mai-fixer
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-fixer
|
||||||
1
.claude/skills/mai-gitster
Symbolic link
1
.claude/skills/mai-gitster
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-gitster
|
||||||
1
.claude/skills/mai-head
Symbolic link
1
.claude/skills/mai-head
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-head
|
||||||
1
.claude/skills/mai-init
Symbolic link
1
.claude/skills/mai-init
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-init
|
||||||
1
.claude/skills/mai-inventor
Symbolic link
1
.claude/skills/mai-inventor
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-inventor
|
||||||
1
.claude/skills/mai-lead
Symbolic link
1
.claude/skills/mai-lead
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-lead
|
||||||
1
.claude/skills/mai-maister
Symbolic link
1
.claude/skills/mai-maister
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-maister
|
||||||
1
.claude/skills/mai-member
Symbolic link
1
.claude/skills/mai-member
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-member
|
||||||
1
.claude/skills/mai-researcher
Symbolic link
1
.claude/skills/mai-researcher
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-researcher
|
||||||
1
.claude/skills/mai-think
Symbolic link
1
.claude/skills/mai-think
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-think
|
||||||
1
.claude/skills/mai-web
Symbolic link
1
.claude/skills/mai-web
Symbolic link
@@ -0,0 +1 @@
|
|||||||
|
/home/m/.mai/skills/mai-web
|
||||||
1
.gitignore
vendored
1
.gitignore
vendored
@@ -45,3 +45,4 @@ tmp/
|
|||||||
|
|
||||||
# TypeScript
|
# TypeScript
|
||||||
*.tsbuildinfo
|
*.tsbuildinfo
|
||||||
|
.worktrees/
|
||||||
|
|||||||
4
.m/.gitignore
vendored
Normal file
4
.m/.gitignore
vendored
Normal file
@@ -0,0 +1,4 @@
|
|||||||
|
workers.json
|
||||||
|
spawn.lock
|
||||||
|
session.yaml
|
||||||
|
config.reference.yaml
|
||||||
168
.m/config.yaml
Normal file
168
.m/config.yaml
Normal file
@@ -0,0 +1,168 @@
|
|||||||
|
provider: claude
|
||||||
|
providers:
|
||||||
|
claude:
|
||||||
|
api_key: ""
|
||||||
|
model: claude-sonnet-4-20250514
|
||||||
|
base_url: https://api.anthropic.com/v1
|
||||||
|
ollama:
|
||||||
|
host: http://localhost:11434
|
||||||
|
model: llama3.2
|
||||||
|
memory:
|
||||||
|
enabled: true
|
||||||
|
backend: ""
|
||||||
|
path: ""
|
||||||
|
url: postgres://mai_memory.your-tenant-id:maiMem6034supa@100.99.98.201:6543/postgres?sslmode=disable
|
||||||
|
group_id: ""
|
||||||
|
cache_ttl: 5m0s
|
||||||
|
auto_load: true
|
||||||
|
embedding_url: ""
|
||||||
|
embedding_model: ""
|
||||||
|
gitea:
|
||||||
|
url: https://mgit.msbls.de
|
||||||
|
repo: m/KanzlAI
|
||||||
|
token: ""
|
||||||
|
sync:
|
||||||
|
enabled: false
|
||||||
|
interval: 0s
|
||||||
|
repos: []
|
||||||
|
auto_queue: false
|
||||||
|
api:
|
||||||
|
api_key: ""
|
||||||
|
basic_auth:
|
||||||
|
username: ""
|
||||||
|
password: ""
|
||||||
|
public_endpoints:
|
||||||
|
- /api/health
|
||||||
|
ui:
|
||||||
|
theme: default
|
||||||
|
show_sidebar: true
|
||||||
|
animation: true
|
||||||
|
persona: true
|
||||||
|
avatar_pack: ""
|
||||||
|
worker:
|
||||||
|
names: []
|
||||||
|
name_scheme: role
|
||||||
|
default_level: standard
|
||||||
|
auto_discard: false
|
||||||
|
max_workers: 5
|
||||||
|
persistent: true
|
||||||
|
head:
|
||||||
|
name: ingeborg
|
||||||
|
max_loops: 50
|
||||||
|
infinity_mode: false
|
||||||
|
capacity:
|
||||||
|
global:
|
||||||
|
max_workers: 5
|
||||||
|
max_heads: 3
|
||||||
|
per_worker:
|
||||||
|
max_tasks_lifetime: 0
|
||||||
|
max_concurrent: 1
|
||||||
|
max_context_tokens: 0
|
||||||
|
per_head:
|
||||||
|
max_workers: 10
|
||||||
|
resources:
|
||||||
|
max_memory_mb: 0
|
||||||
|
max_cpu_percent: 0
|
||||||
|
queue:
|
||||||
|
max_pending: 100
|
||||||
|
stale_task_days: 30
|
||||||
|
workforce:
|
||||||
|
timeouts:
|
||||||
|
task_default: 0s
|
||||||
|
task_max: 0s
|
||||||
|
idle_before_warn: 10m0s
|
||||||
|
idle_before_kill: 30m0s
|
||||||
|
quality_check: 2m0s
|
||||||
|
context:
|
||||||
|
max_tokens_per_worker: 0
|
||||||
|
max_tokens_global: 0
|
||||||
|
warn_threshold: 0.8
|
||||||
|
truncate_strategy: oldest
|
||||||
|
delegation:
|
||||||
|
strategy: skill_match
|
||||||
|
preferred_role: coder
|
||||||
|
auto_delegate: false
|
||||||
|
max_depth: 3
|
||||||
|
allowed_roles:
|
||||||
|
- coder
|
||||||
|
- researcher
|
||||||
|
- fixer
|
||||||
|
peppy:
|
||||||
|
enabled: false
|
||||||
|
style: calm
|
||||||
|
interval: 5m0s
|
||||||
|
emoji: false
|
||||||
|
nudges: true
|
||||||
|
nudge_main: false
|
||||||
|
custom_prompt: ""
|
||||||
|
stall_threshold: 0s
|
||||||
|
restart_enabled: false
|
||||||
|
max_shifts: 0
|
||||||
|
quality_gates:
|
||||||
|
enabled: true
|
||||||
|
checks: []
|
||||||
|
preflight:
|
||||||
|
enabled: false
|
||||||
|
type: ""
|
||||||
|
root: ""
|
||||||
|
checks: []
|
||||||
|
guardrails:
|
||||||
|
enabled: false
|
||||||
|
use_defaults: true
|
||||||
|
output:
|
||||||
|
coder_checks: []
|
||||||
|
researcher_checks: []
|
||||||
|
fixer_checks: []
|
||||||
|
custom_checks: {}
|
||||||
|
global_checks: []
|
||||||
|
tools:
|
||||||
|
role_rules: {}
|
||||||
|
deny_patterns: []
|
||||||
|
allow_patterns: []
|
||||||
|
schemas:
|
||||||
|
report_schemas: {}
|
||||||
|
deliverable_schemas: {}
|
||||||
|
modes:
|
||||||
|
yolo: false
|
||||||
|
self_improvement: false
|
||||||
|
autonomous: false
|
||||||
|
verbose: false
|
||||||
|
improve_interval: 0s
|
||||||
|
predict_interval: 0s
|
||||||
|
layouts:
|
||||||
|
head: ""
|
||||||
|
worker: ""
|
||||||
|
roles: {}
|
||||||
|
dog:
|
||||||
|
name: buddy
|
||||||
|
supabase:
|
||||||
|
url: ""
|
||||||
|
role_key: ""
|
||||||
|
anon_key: ""
|
||||||
|
schema: mai
|
||||||
|
storage:
|
||||||
|
backend: ""
|
||||||
|
postgres:
|
||||||
|
url: ""
|
||||||
|
max_conns: 0
|
||||||
|
min_conns: 0
|
||||||
|
max_conn_lifetime: 0s
|
||||||
|
idle:
|
||||||
|
behavior: wait
|
||||||
|
auto_hire: false
|
||||||
|
prompt: ""
|
||||||
|
git:
|
||||||
|
worktrees:
|
||||||
|
enabled: true
|
||||||
|
delete_branch: false
|
||||||
|
dir: .worktrees
|
||||||
|
phase:
|
||||||
|
enabled: false
|
||||||
|
current: ""
|
||||||
|
allowed_roles: {}
|
||||||
|
goal: ""
|
||||||
|
skills: {}
|
||||||
|
editor: nvim
|
||||||
|
log_level: info
|
||||||
|
project_detection: true
|
||||||
|
tone: professional
|
||||||
22
.mcp.json
Normal file
22
.mcp.json
Normal file
@@ -0,0 +1,22 @@
|
|||||||
|
{
|
||||||
|
"mcpServers": {
|
||||||
|
"mai": {
|
||||||
|
"type": "http",
|
||||||
|
"url": "http://100.99.98.201:8000/mcp",
|
||||||
|
"headers": {
|
||||||
|
"Authorization": "Basic ${SUPABASE_AUTH}"
|
||||||
|
}
|
||||||
|
},
|
||||||
|
"mai-memory": {
|
||||||
|
"command": "mai",
|
||||||
|
"args": [
|
||||||
|
"mcp",
|
||||||
|
"memory"
|
||||||
|
],
|
||||||
|
"env": {
|
||||||
|
"MAI_MEMORY_EMBEDDING_MODEL": "nomic-embed-text",
|
||||||
|
"MAI_MEMORY_EMBEDDING_URL": "https://llm.x.msbls.de"
|
||||||
|
}
|
||||||
|
}
|
||||||
|
}
|
||||||
|
}
|
||||||
@@ -22,8 +22,8 @@ func main() {
|
|||||||
}
|
}
|
||||||
defer database.Close()
|
defer database.Close()
|
||||||
|
|
||||||
authMW := auth.NewMiddleware(cfg.SupabaseJWTSecret)
|
authMW := auth.NewMiddleware(cfg.SupabaseJWTSecret, database)
|
||||||
handler := router.New(database, authMW)
|
handler := router.New(database, authMW, cfg.AnthropicAPIKey)
|
||||||
|
|
||||||
log.Printf("Starting KanzlAI API server on :%s", cfg.Port)
|
log.Printf("Starting KanzlAI API server on :%s", cfg.Port)
|
||||||
if err := http.ListenAndServe(":"+cfg.Port, handler); err != nil {
|
if err := http.ListenAndServe(":"+cfg.Port, handler); err != nil {
|
||||||
|
|||||||
@@ -3,8 +3,14 @@ module mgit.msbls.de/m/KanzlAI-mGMT
|
|||||||
go 1.25.5
|
go 1.25.5
|
||||||
|
|
||||||
require (
|
require (
|
||||||
|
github.com/anthropics/anthropic-sdk-go v1.27.1 // indirect
|
||||||
github.com/golang-jwt/jwt/v5 v5.3.1 // indirect
|
github.com/golang-jwt/jwt/v5 v5.3.1 // indirect
|
||||||
github.com/google/uuid v1.6.0 // indirect
|
github.com/google/uuid v1.6.0 // indirect
|
||||||
github.com/jmoiron/sqlx v1.4.0 // indirect
|
github.com/jmoiron/sqlx v1.4.0 // indirect
|
||||||
github.com/lib/pq v1.12.0 // indirect
|
github.com/lib/pq v1.12.0 // indirect
|
||||||
|
github.com/tidwall/gjson v1.18.0 // indirect
|
||||||
|
github.com/tidwall/match v1.1.1 // indirect
|
||||||
|
github.com/tidwall/pretty v1.2.1 // indirect
|
||||||
|
github.com/tidwall/sjson v1.2.5 // indirect
|
||||||
|
golang.org/x/sync v0.16.0 // indirect
|
||||||
)
|
)
|
||||||
|
|||||||
@@ -1,4 +1,6 @@
|
|||||||
filippo.io/edwards25519 v1.1.0/go.mod h1:BxyFTGdWcka3PhytdK4V28tE5sGfRvvvRV7EaN4VDT4=
|
filippo.io/edwards25519 v1.1.0/go.mod h1:BxyFTGdWcka3PhytdK4V28tE5sGfRvvvRV7EaN4VDT4=
|
||||||
|
github.com/anthropics/anthropic-sdk-go v1.27.1 h1:7DgMZ2Ng3C2mPzJGHA30NXQTZolcF07mHd0tGaLwfzk=
|
||||||
|
github.com/anthropics/anthropic-sdk-go v1.27.1/go.mod h1:qUKmaW+uuPB64iy1l+4kOSvaLqPXnHTTBKH6RVZ7q5Q=
|
||||||
github.com/go-sql-driver/mysql v1.8.1/go.mod h1:wEBSXgmK//2ZFJyE+qWnIsVGmvmEKlqwuVSjsCm7DZg=
|
github.com/go-sql-driver/mysql v1.8.1/go.mod h1:wEBSXgmK//2ZFJyE+qWnIsVGmvmEKlqwuVSjsCm7DZg=
|
||||||
github.com/golang-jwt/jwt/v5 v5.3.1 h1:kYf81DTWFe7t+1VvL7eS+jKFVWaUnK9cB1qbwn63YCY=
|
github.com/golang-jwt/jwt/v5 v5.3.1 h1:kYf81DTWFe7t+1VvL7eS+jKFVWaUnK9cB1qbwn63YCY=
|
||||||
github.com/golang-jwt/jwt/v5 v5.3.1/go.mod h1:fxCRLWMO43lRc8nhHWY6LGqRcf+1gQWArsqaEUEa5bE=
|
github.com/golang-jwt/jwt/v5 v5.3.1/go.mod h1:fxCRLWMO43lRc8nhHWY6LGqRcf+1gQWArsqaEUEa5bE=
|
||||||
@@ -10,3 +12,15 @@ github.com/lib/pq v1.10.9/go.mod h1:AlVN5x4E4T544tWzH6hKfbfQvm3HdbOxrmggDNAPY9o=
|
|||||||
github.com/lib/pq v1.12.0 h1:mC1zeiNamwKBecjHarAr26c/+d8V5w/u4J0I/yASbJo=
|
github.com/lib/pq v1.12.0 h1:mC1zeiNamwKBecjHarAr26c/+d8V5w/u4J0I/yASbJo=
|
||||||
github.com/lib/pq v1.12.0/go.mod h1:/p+8NSbOcwzAEI7wiMXFlgydTwcgTr3OSKMsD2BitpA=
|
github.com/lib/pq v1.12.0/go.mod h1:/p+8NSbOcwzAEI7wiMXFlgydTwcgTr3OSKMsD2BitpA=
|
||||||
github.com/mattn/go-sqlite3 v1.14.22/go.mod h1:Uh1q+B4BYcTPb+yiD3kU8Ct7aC0hY9fxUwlHK0RXw+Y=
|
github.com/mattn/go-sqlite3 v1.14.22/go.mod h1:Uh1q+B4BYcTPb+yiD3kU8Ct7aC0hY9fxUwlHK0RXw+Y=
|
||||||
|
github.com/tidwall/gjson v1.14.2/go.mod h1:/wbyibRr2FHMks5tjHJ5F8dMZh3AcwJEMf5vlfC0lxk=
|
||||||
|
github.com/tidwall/gjson v1.18.0 h1:FIDeeyB800efLX89e5a8Y0BNH+LOngJyGrIWxG2FKQY=
|
||||||
|
github.com/tidwall/gjson v1.18.0/go.mod h1:/wbyibRr2FHMks5tjHJ5F8dMZh3AcwJEMf5vlfC0lxk=
|
||||||
|
github.com/tidwall/match v1.1.1 h1:+Ho715JplO36QYgwN9PGYNhgZvoUSc9X2c80KVTi+GA=
|
||||||
|
github.com/tidwall/match v1.1.1/go.mod h1:eRSPERbgtNPcGhD8UCthc6PmLEQXEWd3PRB5JTxsfmM=
|
||||||
|
github.com/tidwall/pretty v1.2.0/go.mod h1:ITEVvHYasfjBbM0u2Pg8T2nJnzm8xPwvNhhsoaGGjNU=
|
||||||
|
github.com/tidwall/pretty v1.2.1 h1:qjsOFOWWQl+N3RsoF5/ssm1pHmJJwhjlSbZ51I6wMl4=
|
||||||
|
github.com/tidwall/pretty v1.2.1/go.mod h1:ITEVvHYasfjBbM0u2Pg8T2nJnzm8xPwvNhhsoaGGjNU=
|
||||||
|
github.com/tidwall/sjson v1.2.5 h1:kLy8mja+1c9jlljvWTlSazM7cKDRfJuR/bOJhcY5NcY=
|
||||||
|
github.com/tidwall/sjson v1.2.5/go.mod h1:Fvgq9kS/6ociJEDnK0Fk1cpYF4FIW6ZF7LAe+6jwd28=
|
||||||
|
golang.org/x/sync v0.16.0 h1:ycBJEhp9p4vXvUZNszeOq0kGTPghopOL8q0fq3vstxw=
|
||||||
|
golang.org/x/sync v0.16.0/go.mod h1:1dzgHSNfp02xaA81J2MS99Qcpr2w7fw1gpm99rleRqA=
|
||||||
|
|||||||
@@ -8,14 +8,16 @@ import (
|
|||||||
|
|
||||||
"github.com/golang-jwt/jwt/v5"
|
"github.com/golang-jwt/jwt/v5"
|
||||||
"github.com/google/uuid"
|
"github.com/google/uuid"
|
||||||
|
"github.com/jmoiron/sqlx"
|
||||||
)
|
)
|
||||||
|
|
||||||
type Middleware struct {
|
type Middleware struct {
|
||||||
jwtSecret []byte
|
jwtSecret []byte
|
||||||
|
db *sqlx.DB
|
||||||
}
|
}
|
||||||
|
|
||||||
func NewMiddleware(jwtSecret string) *Middleware {
|
func NewMiddleware(jwtSecret string, db *sqlx.DB) *Middleware {
|
||||||
return &Middleware{jwtSecret: []byte(jwtSecret)}
|
return &Middleware{jwtSecret: []byte(jwtSecret), db: db}
|
||||||
}
|
}
|
||||||
|
|
||||||
func (m *Middleware) RequireAuth(next http.Handler) http.Handler {
|
func (m *Middleware) RequireAuth(next http.Handler) http.Handler {
|
||||||
@@ -33,6 +35,17 @@ func (m *Middleware) RequireAuth(next http.Handler) http.Handler {
|
|||||||
}
|
}
|
||||||
|
|
||||||
ctx := ContextWithUserID(r.Context(), userID)
|
ctx := ContextWithUserID(r.Context(), userID)
|
||||||
|
|
||||||
|
// Resolve tenant from user_tenants
|
||||||
|
var tenantID uuid.UUID
|
||||||
|
err = m.db.GetContext(r.Context(), &tenantID,
|
||||||
|
"SELECT tenant_id FROM user_tenants WHERE user_id = $1 LIMIT 1", userID)
|
||||||
|
if err != nil {
|
||||||
|
http.Error(w, "no tenant found for user", http.StatusForbidden)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
ctx = ContextWithTenantID(ctx, tenantID)
|
||||||
|
|
||||||
next.ServeHTTP(w, r.WithContext(ctx))
|
next.ServeHTTP(w, r.WithContext(ctx))
|
||||||
})
|
})
|
||||||
}
|
}
|
||||||
|
|||||||
115
backend/internal/handlers/ai.go
Normal file
115
backend/internal/handlers/ai.go
Normal file
@@ -0,0 +1,115 @@
|
|||||||
|
package handlers
|
||||||
|
|
||||||
|
import (
|
||||||
|
"encoding/json"
|
||||||
|
"io"
|
||||||
|
"net/http"
|
||||||
|
|
||||||
|
"github.com/jmoiron/sqlx"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/services"
|
||||||
|
)
|
||||||
|
|
||||||
|
type AIHandler struct {
|
||||||
|
ai *services.AIService
|
||||||
|
db *sqlx.DB
|
||||||
|
}
|
||||||
|
|
||||||
|
func NewAIHandler(ai *services.AIService, db *sqlx.DB) *AIHandler {
|
||||||
|
return &AIHandler{ai: ai, db: db}
|
||||||
|
}
|
||||||
|
|
||||||
|
// ExtractDeadlines handles POST /api/ai/extract-deadlines
|
||||||
|
// Accepts either multipart/form-data with a "file" PDF field, or JSON {"text": "..."}.
|
||||||
|
func (h *AIHandler) ExtractDeadlines(w http.ResponseWriter, r *http.Request) {
|
||||||
|
contentType := r.Header.Get("Content-Type")
|
||||||
|
|
||||||
|
var pdfData []byte
|
||||||
|
var text string
|
||||||
|
|
||||||
|
// Check if multipart (PDF upload)
|
||||||
|
if len(contentType) >= 9 && contentType[:9] == "multipart" {
|
||||||
|
if err := r.ParseMultipartForm(32 << 20); err != nil { // 32MB max
|
||||||
|
writeError(w, http.StatusBadRequest, "failed to parse multipart form")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
file, _, err := r.FormFile("file")
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "missing 'file' field in multipart form")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
defer file.Close()
|
||||||
|
|
||||||
|
pdfData, err = io.ReadAll(file)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "failed to read uploaded file")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
} else {
|
||||||
|
// Assume JSON body
|
||||||
|
var body struct {
|
||||||
|
Text string `json:"text"`
|
||||||
|
}
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&body); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid request body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
text = body.Text
|
||||||
|
}
|
||||||
|
|
||||||
|
if len(pdfData) == 0 && text == "" {
|
||||||
|
writeError(w, http.StatusBadRequest, "provide either a PDF file or text")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
deadlines, err := h.ai.ExtractDeadlines(r.Context(), pdfData, text)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, "AI extraction failed: "+err.Error())
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, map[string]any{
|
||||||
|
"deadlines": deadlines,
|
||||||
|
"count": len(deadlines),
|
||||||
|
})
|
||||||
|
}
|
||||||
|
|
||||||
|
// SummarizeCase handles POST /api/ai/summarize-case
|
||||||
|
// Accepts JSON {"case_id": "uuid"}.
|
||||||
|
func (h *AIHandler) SummarizeCase(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, err := resolveTenant(r, h.db)
|
||||||
|
if err != nil {
|
||||||
|
handleTenantError(w, err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var body struct {
|
||||||
|
CaseID string `json:"case_id"`
|
||||||
|
}
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&body); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid request body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
if body.CaseID == "" {
|
||||||
|
writeError(w, http.StatusBadRequest, "case_id is required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
caseID, err := parseUUID(body.CaseID)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid case_id")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
summary, err := h.ai.SummarizeCase(r.Context(), tenantID, caseID)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, "AI summarization failed: "+err.Error())
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, map[string]string{
|
||||||
|
"case_id": caseID.String(),
|
||||||
|
"summary": summary,
|
||||||
|
})
|
||||||
|
}
|
||||||
205
backend/internal/handlers/appointments.go
Normal file
205
backend/internal/handlers/appointments.go
Normal file
@@ -0,0 +1,205 @@
|
|||||||
|
package handlers
|
||||||
|
|
||||||
|
import (
|
||||||
|
"database/sql"
|
||||||
|
"encoding/json"
|
||||||
|
"errors"
|
||||||
|
"net/http"
|
||||||
|
"time"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/auth"
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/models"
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/services"
|
||||||
|
)
|
||||||
|
|
||||||
|
type AppointmentHandler struct {
|
||||||
|
svc *services.AppointmentService
|
||||||
|
}
|
||||||
|
|
||||||
|
func NewAppointmentHandler(svc *services.AppointmentService) *AppointmentHandler {
|
||||||
|
return &AppointmentHandler{svc: svc}
|
||||||
|
}
|
||||||
|
|
||||||
|
func (h *AppointmentHandler) List(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusUnauthorized, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
filter := services.AppointmentFilter{}
|
||||||
|
|
||||||
|
if v := r.URL.Query().Get("case_id"); v != "" {
|
||||||
|
id, err := uuid.Parse(v)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid case_id")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
filter.CaseID = &id
|
||||||
|
}
|
||||||
|
if v := r.URL.Query().Get("type"); v != "" {
|
||||||
|
filter.Type = &v
|
||||||
|
}
|
||||||
|
if v := r.URL.Query().Get("start_from"); v != "" {
|
||||||
|
t, err := time.Parse(time.RFC3339, v)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid start_from (use RFC3339)")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
filter.StartFrom = &t
|
||||||
|
}
|
||||||
|
if v := r.URL.Query().Get("start_to"); v != "" {
|
||||||
|
t, err := time.Parse(time.RFC3339, v)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid start_to (use RFC3339)")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
filter.StartTo = &t
|
||||||
|
}
|
||||||
|
|
||||||
|
appointments, err := h.svc.List(r.Context(), tenantID, filter)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, "failed to list appointments")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, appointments)
|
||||||
|
}
|
||||||
|
|
||||||
|
type createAppointmentRequest struct {
|
||||||
|
CaseID *uuid.UUID `json:"case_id"`
|
||||||
|
Title string `json:"title"`
|
||||||
|
Description *string `json:"description"`
|
||||||
|
StartAt time.Time `json:"start_at"`
|
||||||
|
EndAt *time.Time `json:"end_at"`
|
||||||
|
Location *string `json:"location"`
|
||||||
|
AppointmentType *string `json:"appointment_type"`
|
||||||
|
}
|
||||||
|
|
||||||
|
func (h *AppointmentHandler) Create(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusUnauthorized, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var req createAppointmentRequest
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&req); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid request body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if req.Title == "" {
|
||||||
|
writeError(w, http.StatusBadRequest, "title is required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if req.StartAt.IsZero() {
|
||||||
|
writeError(w, http.StatusBadRequest, "start_at is required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
appt := &models.Appointment{
|
||||||
|
TenantID: tenantID,
|
||||||
|
CaseID: req.CaseID,
|
||||||
|
Title: req.Title,
|
||||||
|
Description: req.Description,
|
||||||
|
StartAt: req.StartAt,
|
||||||
|
EndAt: req.EndAt,
|
||||||
|
Location: req.Location,
|
||||||
|
AppointmentType: req.AppointmentType,
|
||||||
|
}
|
||||||
|
|
||||||
|
if err := h.svc.Create(r.Context(), appt); err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, "failed to create appointment")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusCreated, appt)
|
||||||
|
}
|
||||||
|
|
||||||
|
type updateAppointmentRequest struct {
|
||||||
|
CaseID *uuid.UUID `json:"case_id"`
|
||||||
|
Title string `json:"title"`
|
||||||
|
Description *string `json:"description"`
|
||||||
|
StartAt time.Time `json:"start_at"`
|
||||||
|
EndAt *time.Time `json:"end_at"`
|
||||||
|
Location *string `json:"location"`
|
||||||
|
AppointmentType *string `json:"appointment_type"`
|
||||||
|
}
|
||||||
|
|
||||||
|
func (h *AppointmentHandler) Update(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusUnauthorized, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
id, err := uuid.Parse(r.PathValue("id"))
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid appointment id")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
// Fetch existing to verify ownership
|
||||||
|
existing, err := h.svc.GetByID(r.Context(), tenantID, id)
|
||||||
|
if err != nil {
|
||||||
|
if errors.Is(err, sql.ErrNoRows) {
|
||||||
|
writeError(w, http.StatusNotFound, "appointment not found")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
writeError(w, http.StatusInternalServerError, "failed to fetch appointment")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var req updateAppointmentRequest
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&req); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid request body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if req.Title == "" {
|
||||||
|
writeError(w, http.StatusBadRequest, "title is required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if req.StartAt.IsZero() {
|
||||||
|
writeError(w, http.StatusBadRequest, "start_at is required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
existing.CaseID = req.CaseID
|
||||||
|
existing.Title = req.Title
|
||||||
|
existing.Description = req.Description
|
||||||
|
existing.StartAt = req.StartAt
|
||||||
|
existing.EndAt = req.EndAt
|
||||||
|
existing.Location = req.Location
|
||||||
|
existing.AppointmentType = req.AppointmentType
|
||||||
|
|
||||||
|
if err := h.svc.Update(r.Context(), existing); err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, "failed to update appointment")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, existing)
|
||||||
|
}
|
||||||
|
|
||||||
|
func (h *AppointmentHandler) Delete(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusUnauthorized, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
id, err := uuid.Parse(r.PathValue("id"))
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid appointment id")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
if err := h.svc.Delete(r.Context(), tenantID, id); err != nil {
|
||||||
|
writeError(w, http.StatusNotFound, "appointment not found")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
w.WriteHeader(http.StatusNoContent)
|
||||||
|
}
|
||||||
|
|
||||||
89
backend/internal/handlers/calculate.go
Normal file
89
backend/internal/handlers/calculate.go
Normal file
@@ -0,0 +1,89 @@
|
|||||||
|
package handlers
|
||||||
|
|
||||||
|
import (
|
||||||
|
"encoding/json"
|
||||||
|
"net/http"
|
||||||
|
"time"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/models"
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/services"
|
||||||
|
)
|
||||||
|
|
||||||
|
// CalculateHandlers holds handlers for deadline calculation endpoints
|
||||||
|
type CalculateHandlers struct {
|
||||||
|
calculator *services.DeadlineCalculator
|
||||||
|
rules *services.DeadlineRuleService
|
||||||
|
}
|
||||||
|
|
||||||
|
// NewCalculateHandlers creates calculate handlers
|
||||||
|
func NewCalculateHandlers(calc *services.DeadlineCalculator, rules *services.DeadlineRuleService) *CalculateHandlers {
|
||||||
|
return &CalculateHandlers{calculator: calc, rules: rules}
|
||||||
|
}
|
||||||
|
|
||||||
|
// CalculateRequest is the input for POST /api/deadlines/calculate
|
||||||
|
type CalculateRequest struct {
|
||||||
|
ProceedingType string `json:"proceeding_type"`
|
||||||
|
TriggerEventDate string `json:"trigger_event_date"`
|
||||||
|
SelectedRuleIDs []string `json:"selected_rule_ids,omitempty"`
|
||||||
|
}
|
||||||
|
|
||||||
|
// Calculate handles POST /api/deadlines/calculate
|
||||||
|
func (h *CalculateHandlers) Calculate(w http.ResponseWriter, r *http.Request) {
|
||||||
|
var req CalculateRequest
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&req); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid request body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
if req.ProceedingType == "" || req.TriggerEventDate == "" {
|
||||||
|
writeError(w, http.StatusBadRequest, "proceeding_type and trigger_event_date are required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
eventDate, err := time.Parse("2006-01-02", req.TriggerEventDate)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid trigger_event_date format, expected YYYY-MM-DD")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var results []services.CalculatedDeadline
|
||||||
|
|
||||||
|
if len(req.SelectedRuleIDs) > 0 {
|
||||||
|
ruleModels, err := h.rules.GetByIDs(req.SelectedRuleIDs)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, "failed to fetch selected rules")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
results = h.calculator.CalculateFromRules(eventDate, ruleModels)
|
||||||
|
} else {
|
||||||
|
tree, err := h.rules.GetRuleTree(req.ProceedingType)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "unknown proceeding type")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
// Flatten tree to get all rule models
|
||||||
|
var flatNodes []services.RuleTreeNode
|
||||||
|
flattenTree(tree, &flatNodes)
|
||||||
|
|
||||||
|
ruleModels := make([]models.DeadlineRule, 0, len(flatNodes))
|
||||||
|
for _, node := range flatNodes {
|
||||||
|
ruleModels = append(ruleModels, node.DeadlineRule)
|
||||||
|
}
|
||||||
|
results = h.calculator.CalculateFromRules(eventDate, ruleModels)
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, map[string]any{
|
||||||
|
"proceeding_type": req.ProceedingType,
|
||||||
|
"trigger_event_date": req.TriggerEventDate,
|
||||||
|
"deadlines": results,
|
||||||
|
})
|
||||||
|
}
|
||||||
|
|
||||||
|
func flattenTree(nodes []services.RuleTreeNode, result *[]services.RuleTreeNode) {
|
||||||
|
for _, n := range nodes {
|
||||||
|
*result = append(*result, n)
|
||||||
|
if len(n.Children) > 0 {
|
||||||
|
flattenTree(n.Children, result)
|
||||||
|
}
|
||||||
|
}
|
||||||
|
}
|
||||||
158
backend/internal/handlers/cases.go
Normal file
158
backend/internal/handlers/cases.go
Normal file
@@ -0,0 +1,158 @@
|
|||||||
|
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 CaseHandler struct {
|
||||||
|
svc *services.CaseService
|
||||||
|
}
|
||||||
|
|
||||||
|
func NewCaseHandler(svc *services.CaseService) *CaseHandler {
|
||||||
|
return &CaseHandler{svc: svc}
|
||||||
|
}
|
||||||
|
|
||||||
|
func (h *CaseHandler) 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"))
|
||||||
|
|
||||||
|
filter := services.CaseFilter{
|
||||||
|
Status: r.URL.Query().Get("status"),
|
||||||
|
Type: r.URL.Query().Get("type"),
|
||||||
|
Search: r.URL.Query().Get("search"),
|
||||||
|
Limit: limit,
|
||||||
|
Offset: offset,
|
||||||
|
}
|
||||||
|
|
||||||
|
cases, total, err := h.svc.List(r.Context(), tenantID, filter)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, err.Error())
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, map[string]interface{}{
|
||||||
|
"cases": cases,
|
||||||
|
"total": total,
|
||||||
|
})
|
||||||
|
}
|
||||||
|
|
||||||
|
func (h *CaseHandler) 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.CreateCaseInput
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&input); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid JSON body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if input.CaseNumber == "" || input.Title == "" {
|
||||||
|
writeError(w, http.StatusBadRequest, "case_number and title are required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
c, err := h.svc.Create(r.Context(), tenantID, userID, input)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, err.Error())
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusCreated, c)
|
||||||
|
}
|
||||||
|
|
||||||
|
func (h *CaseHandler) Get(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
caseID, err := uuid.Parse(r.PathValue("id"))
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid case ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
detail, err := h.svc.GetByID(r.Context(), tenantID, caseID)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, err.Error())
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if detail == nil {
|
||||||
|
writeError(w, http.StatusNotFound, "case not found")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, detail)
|
||||||
|
}
|
||||||
|
|
||||||
|
func (h *CaseHandler) Update(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 := uuid.Parse(r.PathValue("id"))
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid case ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var input services.UpdateCaseInput
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&input); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid JSON body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
updated, err := h.svc.Update(r.Context(), tenantID, caseID, userID, input)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, err.Error())
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if updated == nil {
|
||||||
|
writeError(w, http.StatusNotFound, "case not found")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, updated)
|
||||||
|
}
|
||||||
|
|
||||||
|
func (h *CaseHandler) Delete(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 := uuid.Parse(r.PathValue("id"))
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid case ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
if err := h.svc.Delete(r.Context(), tenantID, caseID, userID); err != nil {
|
||||||
|
writeError(w, http.StatusNotFound, "case not found")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, map[string]string{"status": "archived"})
|
||||||
|
}
|
||||||
58
backend/internal/handlers/deadline_rules.go
Normal file
58
backend/internal/handlers/deadline_rules.go
Normal file
@@ -0,0 +1,58 @@
|
|||||||
|
package handlers
|
||||||
|
|
||||||
|
import (
|
||||||
|
"net/http"
|
||||||
|
"strconv"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/services"
|
||||||
|
)
|
||||||
|
|
||||||
|
// DeadlineRuleHandlers holds handlers for deadline rule endpoints
|
||||||
|
type DeadlineRuleHandlers struct {
|
||||||
|
rules *services.DeadlineRuleService
|
||||||
|
}
|
||||||
|
|
||||||
|
// NewDeadlineRuleHandlers creates deadline rule handlers
|
||||||
|
func NewDeadlineRuleHandlers(rs *services.DeadlineRuleService) *DeadlineRuleHandlers {
|
||||||
|
return &DeadlineRuleHandlers{rules: rs}
|
||||||
|
}
|
||||||
|
|
||||||
|
// List handles GET /api/deadline-rules
|
||||||
|
// Query params: proceeding_type_id (optional int filter)
|
||||||
|
func (h *DeadlineRuleHandlers) List(w http.ResponseWriter, r *http.Request) {
|
||||||
|
var proceedingTypeID *int
|
||||||
|
if v := r.URL.Query().Get("proceeding_type_id"); v != "" {
|
||||||
|
id, err := strconv.Atoi(v)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid proceeding_type_id")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
proceedingTypeID = &id
|
||||||
|
}
|
||||||
|
|
||||||
|
rules, err := h.rules.List(proceedingTypeID)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, "failed to list deadline rules")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, rules)
|
||||||
|
}
|
||||||
|
|
||||||
|
// GetRuleTree handles GET /api/deadline-rules/{type}
|
||||||
|
// {type} is the proceeding type code (e.g., "INF", "REV")
|
||||||
|
func (h *DeadlineRuleHandlers) GetRuleTree(w http.ResponseWriter, r *http.Request) {
|
||||||
|
typeCode := r.PathValue("type")
|
||||||
|
if typeCode == "" {
|
||||||
|
writeError(w, http.StatusBadRequest, "proceeding type code required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
tree, err := h.rules.GetRuleTree(typeCode)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusNotFound, "proceeding type not found")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, tree)
|
||||||
|
}
|
||||||
162
backend/internal/handlers/deadlines.go
Normal file
162
backend/internal/handlers/deadlines.go
Normal file
@@ -0,0 +1,162 @@
|
|||||||
|
package handlers
|
||||||
|
|
||||||
|
import (
|
||||||
|
"encoding/json"
|
||||||
|
"net/http"
|
||||||
|
|
||||||
|
"github.com/jmoiron/sqlx"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/services"
|
||||||
|
)
|
||||||
|
|
||||||
|
// DeadlineHandlers holds handlers for deadline CRUD endpoints
|
||||||
|
type DeadlineHandlers struct {
|
||||||
|
deadlines *services.DeadlineService
|
||||||
|
db *sqlx.DB
|
||||||
|
}
|
||||||
|
|
||||||
|
// NewDeadlineHandlers creates deadline handlers
|
||||||
|
func NewDeadlineHandlers(ds *services.DeadlineService, db *sqlx.DB) *DeadlineHandlers {
|
||||||
|
return &DeadlineHandlers{deadlines: ds, db: db}
|
||||||
|
}
|
||||||
|
|
||||||
|
// ListForCase handles GET /api/cases/{caseID}/deadlines
|
||||||
|
func (h *DeadlineHandlers) ListForCase(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, err := resolveTenant(r, h.db)
|
||||||
|
if err != nil {
|
||||||
|
handleTenantError(w, err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
caseID, err := parsePathUUID(r, "caseID")
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid case ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
deadlines, err := h.deadlines.ListForCase(tenantID, caseID)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, "failed to list deadlines")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, deadlines)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Create handles POST /api/cases/{caseID}/deadlines
|
||||||
|
func (h *DeadlineHandlers) Create(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, err := resolveTenant(r, h.db)
|
||||||
|
if err != nil {
|
||||||
|
handleTenantError(w, err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
caseID, err := parsePathUUID(r, "caseID")
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid case ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var input services.CreateDeadlineInput
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&input); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid request body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
input.CaseID = caseID
|
||||||
|
|
||||||
|
if input.Title == "" || input.DueDate == "" {
|
||||||
|
writeError(w, http.StatusBadRequest, "title and due_date are required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
deadline, err := h.deadlines.Create(tenantID, input)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, "failed to create deadline")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusCreated, deadline)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Update handles PUT /api/deadlines/{deadlineID}
|
||||||
|
func (h *DeadlineHandlers) Update(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, err := resolveTenant(r, h.db)
|
||||||
|
if err != nil {
|
||||||
|
handleTenantError(w, err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
deadlineID, err := parsePathUUID(r, "deadlineID")
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid deadline ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var input services.UpdateDeadlineInput
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&input); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid request body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
deadline, err := h.deadlines.Update(tenantID, deadlineID, input)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, "failed to update deadline")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if deadline == nil {
|
||||||
|
writeError(w, http.StatusNotFound, "deadline not found")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, deadline)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Complete handles PATCH /api/deadlines/{deadlineID}/complete
|
||||||
|
func (h *DeadlineHandlers) Complete(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, err := resolveTenant(r, h.db)
|
||||||
|
if err != nil {
|
||||||
|
handleTenantError(w, err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
deadlineID, err := parsePathUUID(r, "deadlineID")
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid deadline ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
deadline, err := h.deadlines.Complete(tenantID, deadlineID)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, "failed to complete deadline")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if deadline == nil {
|
||||||
|
writeError(w, http.StatusNotFound, "deadline not found")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, deadline)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Delete handles DELETE /api/deadlines/{deadlineID}
|
||||||
|
func (h *DeadlineHandlers) Delete(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, err := resolveTenant(r, h.db)
|
||||||
|
if err != nil {
|
||||||
|
handleTenantError(w, err)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
deadlineID, err := parsePathUUID(r, "deadlineID")
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid deadline ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
err = h.deadlines.Delete(tenantID, deadlineID)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusNotFound, err.Error())
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, map[string]string{"status": "deleted"})
|
||||||
|
}
|
||||||
90
backend/internal/handlers/helpers.go
Normal file
90
backend/internal/handlers/helpers.go
Normal file
@@ -0,0 +1,90 @@
|
|||||||
|
package handlers
|
||||||
|
|
||||||
|
import (
|
||||||
|
"encoding/json"
|
||||||
|
"net/http"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
"github.com/jmoiron/sqlx"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/auth"
|
||||||
|
)
|
||||||
|
|
||||||
|
func writeJSON(w http.ResponseWriter, status int, v any) {
|
||||||
|
w.Header().Set("Content-Type", "application/json")
|
||||||
|
w.WriteHeader(status)
|
||||||
|
json.NewEncoder(w).Encode(v)
|
||||||
|
}
|
||||||
|
|
||||||
|
func writeError(w http.ResponseWriter, status int, msg string) {
|
||||||
|
writeJSON(w, status, map[string]string{"error": msg})
|
||||||
|
}
|
||||||
|
|
||||||
|
// resolveTenant gets the tenant ID for the authenticated user.
|
||||||
|
// Checks X-Tenant-ID header first, then falls back to user's first tenant.
|
||||||
|
func resolveTenant(r *http.Request, db *sqlx.DB) (uuid.UUID, error) {
|
||||||
|
userID, ok := auth.UserFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
return uuid.Nil, errUnauthorized
|
||||||
|
}
|
||||||
|
|
||||||
|
// Check header first
|
||||||
|
if headerVal := r.Header.Get("X-Tenant-ID"); headerVal != "" {
|
||||||
|
tenantID, err := uuid.Parse(headerVal)
|
||||||
|
if err != nil {
|
||||||
|
return uuid.Nil, errInvalidTenant
|
||||||
|
}
|
||||||
|
// Verify user has access to this tenant
|
||||||
|
var count int
|
||||||
|
err = db.Get(&count,
|
||||||
|
`SELECT COUNT(*) FROM user_tenants WHERE user_id = $1 AND tenant_id = $2`,
|
||||||
|
userID, tenantID)
|
||||||
|
if err != nil || count == 0 {
|
||||||
|
return uuid.Nil, errTenantAccess
|
||||||
|
}
|
||||||
|
return tenantID, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// Fall back to user's first tenant
|
||||||
|
var tenantID uuid.UUID
|
||||||
|
err := db.Get(&tenantID,
|
||||||
|
`SELECT tenant_id FROM user_tenants WHERE user_id = $1 ORDER BY created_at LIMIT 1`,
|
||||||
|
userID)
|
||||||
|
if err != nil {
|
||||||
|
return uuid.Nil, errNoTenant
|
||||||
|
}
|
||||||
|
return tenantID, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
type apiError struct {
|
||||||
|
msg string
|
||||||
|
status int
|
||||||
|
}
|
||||||
|
|
||||||
|
func (e *apiError) Error() string { return e.msg }
|
||||||
|
|
||||||
|
var (
|
||||||
|
errUnauthorized = &apiError{msg: "unauthorized", status: http.StatusUnauthorized}
|
||||||
|
errInvalidTenant = &apiError{msg: "invalid tenant ID", status: http.StatusBadRequest}
|
||||||
|
errTenantAccess = &apiError{msg: "no access to tenant", status: http.StatusForbidden}
|
||||||
|
errNoTenant = &apiError{msg: "no tenant found for user", status: http.StatusBadRequest}
|
||||||
|
)
|
||||||
|
|
||||||
|
// handleTenantError writes the appropriate error response for tenant resolution errors
|
||||||
|
func handleTenantError(w http.ResponseWriter, err error) {
|
||||||
|
if ae, ok := err.(*apiError); ok {
|
||||||
|
writeError(w, ae.status, ae.msg)
|
||||||
|
return
|
||||||
|
}
|
||||||
|
writeError(w, http.StatusInternalServerError, "internal error")
|
||||||
|
}
|
||||||
|
|
||||||
|
// parsePathUUID extracts a UUID from the URL path using PathValue
|
||||||
|
func parsePathUUID(r *http.Request, key string) (uuid.UUID, error) {
|
||||||
|
return uuid.Parse(r.PathValue(key))
|
||||||
|
}
|
||||||
|
|
||||||
|
// parseUUID parses a UUID string
|
||||||
|
func parseUUID(s string) (uuid.UUID, error) {
|
||||||
|
return uuid.Parse(s)
|
||||||
|
}
|
||||||
134
backend/internal/handlers/parties.go
Normal file
134
backend/internal/handlers/parties.go
Normal file
@@ -0,0 +1,134 @@
|
|||||||
|
package handlers
|
||||||
|
|
||||||
|
import (
|
||||||
|
"database/sql"
|
||||||
|
"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 PartyHandler struct {
|
||||||
|
svc *services.PartyService
|
||||||
|
}
|
||||||
|
|
||||||
|
func NewPartyHandler(svc *services.PartyService) *PartyHandler {
|
||||||
|
return &PartyHandler{svc: svc}
|
||||||
|
}
|
||||||
|
|
||||||
|
func (h *PartyHandler) List(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
caseID, err := uuid.Parse(r.PathValue("id"))
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid case ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
parties, err := h.svc.ListByCase(r.Context(), tenantID, caseID)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, err.Error())
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, map[string]interface{}{
|
||||||
|
"parties": parties,
|
||||||
|
})
|
||||||
|
}
|
||||||
|
|
||||||
|
func (h *PartyHandler) 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 := uuid.Parse(r.PathValue("id"))
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid case ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var input services.CreatePartyInput
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&input); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid JSON body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if input.Name == "" {
|
||||||
|
writeError(w, http.StatusBadRequest, "name is required")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
party, err := h.svc.Create(r.Context(), tenantID, caseID, userID, input)
|
||||||
|
if err != nil {
|
||||||
|
if err == sql.ErrNoRows {
|
||||||
|
writeError(w, http.StatusNotFound, "case not found")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
writeError(w, http.StatusInternalServerError, err.Error())
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusCreated, party)
|
||||||
|
}
|
||||||
|
|
||||||
|
func (h *PartyHandler) Update(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
partyID, err := uuid.Parse(r.PathValue("partyId"))
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid party ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
var input services.UpdatePartyInput
|
||||||
|
if err := json.NewDecoder(r.Body).Decode(&input); err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid JSON body")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
updated, err := h.svc.Update(r.Context(), tenantID, partyID, input)
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusInternalServerError, err.Error())
|
||||||
|
return
|
||||||
|
}
|
||||||
|
if updated == nil {
|
||||||
|
writeError(w, http.StatusNotFound, "party not found")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
writeJSON(w, http.StatusOK, updated)
|
||||||
|
}
|
||||||
|
|
||||||
|
func (h *PartyHandler) Delete(w http.ResponseWriter, r *http.Request) {
|
||||||
|
tenantID, ok := auth.TenantFromContext(r.Context())
|
||||||
|
if !ok {
|
||||||
|
writeError(w, http.StatusForbidden, "missing tenant")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
partyID, err := uuid.Parse(r.PathValue("partyId"))
|
||||||
|
if err != nil {
|
||||||
|
writeError(w, http.StatusBadRequest, "invalid party ID")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
if err := h.svc.Delete(r.Context(), tenantID, partyID); err != nil {
|
||||||
|
writeError(w, http.StatusNotFound, "party not found")
|
||||||
|
return
|
||||||
|
}
|
||||||
|
|
||||||
|
w.WriteHeader(http.StatusNoContent)
|
||||||
|
}
|
||||||
@@ -11,17 +11,37 @@ import (
|
|||||||
"mgit.msbls.de/m/KanzlAI-mGMT/internal/services"
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/services"
|
||||||
)
|
)
|
||||||
|
|
||||||
func New(db *sqlx.DB, authMW *auth.Middleware) http.Handler {
|
func New(db *sqlx.DB, authMW *auth.Middleware, anthropicAPIKey string) http.Handler {
|
||||||
mux := http.NewServeMux()
|
mux := http.NewServeMux()
|
||||||
|
|
||||||
// Services
|
// Services
|
||||||
tenantSvc := services.NewTenantService(db)
|
tenantSvc := services.NewTenantService(db)
|
||||||
|
caseSvc := services.NewCaseService(db)
|
||||||
|
partySvc := services.NewPartyService(db)
|
||||||
|
appointmentSvc := services.NewAppointmentService(db)
|
||||||
|
holidaySvc := services.NewHolidayService(db)
|
||||||
|
deadlineSvc := services.NewDeadlineService(db)
|
||||||
|
deadlineRuleSvc := services.NewDeadlineRuleService(db)
|
||||||
|
calculator := services.NewDeadlineCalculator(holidaySvc)
|
||||||
|
|
||||||
|
// AI service (optional — only if API key is configured)
|
||||||
|
var aiH *handlers.AIHandler
|
||||||
|
if anthropicAPIKey != "" {
|
||||||
|
aiSvc := services.NewAIService(anthropicAPIKey, db)
|
||||||
|
aiH = handlers.NewAIHandler(aiSvc, db)
|
||||||
|
}
|
||||||
|
|
||||||
// Middleware
|
// Middleware
|
||||||
tenantResolver := auth.NewTenantResolver(tenantSvc)
|
tenantResolver := auth.NewTenantResolver(tenantSvc)
|
||||||
|
|
||||||
// Handlers
|
// Handlers
|
||||||
tenantH := handlers.NewTenantHandler(tenantSvc)
|
tenantH := handlers.NewTenantHandler(tenantSvc)
|
||||||
|
caseH := handlers.NewCaseHandler(caseSvc)
|
||||||
|
partyH := handlers.NewPartyHandler(partySvc)
|
||||||
|
apptH := handlers.NewAppointmentHandler(appointmentSvc)
|
||||||
|
deadlineH := handlers.NewDeadlineHandlers(deadlineSvc, db)
|
||||||
|
ruleH := handlers.NewDeadlineRuleHandlers(deadlineRuleSvc)
|
||||||
|
calcH := handlers.NewCalculateHandlers(calculator, deadlineRuleSvc)
|
||||||
|
|
||||||
// Public routes
|
// Public routes
|
||||||
mux.HandleFunc("GET /health", handleHealth(db))
|
mux.HandleFunc("GET /health", handleHealth(db))
|
||||||
@@ -39,9 +59,47 @@ func New(db *sqlx.DB, authMW *auth.Middleware) http.Handler {
|
|||||||
|
|
||||||
// Tenant-scoped routes (require tenant context)
|
// Tenant-scoped routes (require tenant context)
|
||||||
scoped := http.NewServeMux()
|
scoped := http.NewServeMux()
|
||||||
scoped.HandleFunc("GET /api/cases", placeholder("cases"))
|
|
||||||
scoped.HandleFunc("GET /api/deadlines", placeholder("deadlines"))
|
// Cases
|
||||||
scoped.HandleFunc("GET /api/appointments", placeholder("appointments"))
|
scoped.HandleFunc("GET /api/cases", caseH.List)
|
||||||
|
scoped.HandleFunc("POST /api/cases", caseH.Create)
|
||||||
|
scoped.HandleFunc("GET /api/cases/{id}", caseH.Get)
|
||||||
|
scoped.HandleFunc("PUT /api/cases/{id}", caseH.Update)
|
||||||
|
scoped.HandleFunc("DELETE /api/cases/{id}", caseH.Delete)
|
||||||
|
|
||||||
|
// Parties
|
||||||
|
scoped.HandleFunc("GET /api/cases/{id}/parties", partyH.List)
|
||||||
|
scoped.HandleFunc("POST /api/cases/{id}/parties", partyH.Create)
|
||||||
|
scoped.HandleFunc("PUT /api/parties/{partyId}", partyH.Update)
|
||||||
|
scoped.HandleFunc("DELETE /api/parties/{partyId}", partyH.Delete)
|
||||||
|
|
||||||
|
// Deadlines
|
||||||
|
scoped.HandleFunc("GET /api/cases/{caseID}/deadlines", deadlineH.ListForCase)
|
||||||
|
scoped.HandleFunc("POST /api/cases/{caseID}/deadlines", deadlineH.Create)
|
||||||
|
scoped.HandleFunc("PUT /api/deadlines/{deadlineID}", deadlineH.Update)
|
||||||
|
scoped.HandleFunc("PATCH /api/deadlines/{deadlineID}/complete", deadlineH.Complete)
|
||||||
|
scoped.HandleFunc("DELETE /api/deadlines/{deadlineID}", deadlineH.Delete)
|
||||||
|
|
||||||
|
// Deadline rules (reference data)
|
||||||
|
scoped.HandleFunc("GET /api/deadline-rules", ruleH.List)
|
||||||
|
scoped.HandleFunc("GET /api/deadline-rules/{type}", ruleH.GetRuleTree)
|
||||||
|
|
||||||
|
// Deadline calculator
|
||||||
|
scoped.HandleFunc("POST /api/deadlines/calculate", calcH.Calculate)
|
||||||
|
|
||||||
|
// Appointments
|
||||||
|
scoped.HandleFunc("GET /api/appointments", apptH.List)
|
||||||
|
scoped.HandleFunc("POST /api/appointments", apptH.Create)
|
||||||
|
scoped.HandleFunc("PUT /api/appointments/{id}", apptH.Update)
|
||||||
|
scoped.HandleFunc("DELETE /api/appointments/{id}", apptH.Delete)
|
||||||
|
|
||||||
|
// AI endpoints
|
||||||
|
if aiH != nil {
|
||||||
|
scoped.HandleFunc("POST /api/ai/extract-deadlines", aiH.ExtractDeadlines)
|
||||||
|
scoped.HandleFunc("POST /api/ai/summarize-case", aiH.SummarizeCase)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Placeholder routes for future phases
|
||||||
scoped.HandleFunc("GET /api/documents", placeholder("documents"))
|
scoped.HandleFunc("GET /api/documents", placeholder("documents"))
|
||||||
|
|
||||||
// Wire: auth -> tenant routes go directly, scoped routes get tenant resolver
|
// Wire: auth -> tenant routes go directly, scoped routes get tenant resolver
|
||||||
|
|||||||
283
backend/internal/services/ai_service.go
Normal file
283
backend/internal/services/ai_service.go
Normal file
@@ -0,0 +1,283 @@
|
|||||||
|
package services
|
||||||
|
|
||||||
|
import (
|
||||||
|
"context"
|
||||||
|
"encoding/base64"
|
||||||
|
"encoding/json"
|
||||||
|
"fmt"
|
||||||
|
"time"
|
||||||
|
|
||||||
|
"github.com/anthropics/anthropic-sdk-go"
|
||||||
|
"github.com/anthropics/anthropic-sdk-go/option"
|
||||||
|
"github.com/google/uuid"
|
||||||
|
"github.com/jmoiron/sqlx"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/models"
|
||||||
|
)
|
||||||
|
|
||||||
|
type AIService struct {
|
||||||
|
client anthropic.Client
|
||||||
|
db *sqlx.DB
|
||||||
|
}
|
||||||
|
|
||||||
|
func NewAIService(apiKey string, db *sqlx.DB) *AIService {
|
||||||
|
client := anthropic.NewClient(option.WithAPIKey(apiKey))
|
||||||
|
return &AIService{client: client, db: db}
|
||||||
|
}
|
||||||
|
|
||||||
|
// ExtractedDeadline represents a deadline extracted by AI from a document.
|
||||||
|
type ExtractedDeadline struct {
|
||||||
|
Title string `json:"title"`
|
||||||
|
DueDate *string `json:"due_date"`
|
||||||
|
DurationValue int `json:"duration_value"`
|
||||||
|
DurationUnit string `json:"duration_unit"`
|
||||||
|
Timing string `json:"timing"`
|
||||||
|
TriggerEvent string `json:"trigger_event"`
|
||||||
|
RuleReference string `json:"rule_reference"`
|
||||||
|
Confidence float64 `json:"confidence"`
|
||||||
|
SourceQuote string `json:"source_quote"`
|
||||||
|
}
|
||||||
|
|
||||||
|
type extractDeadlinesToolInput struct {
|
||||||
|
Deadlines []ExtractedDeadline `json:"deadlines"`
|
||||||
|
}
|
||||||
|
|
||||||
|
var deadlineExtractionTool = anthropic.ToolParam{
|
||||||
|
Name: "extract_deadlines",
|
||||||
|
Description: anthropic.String("Extract all legal deadlines found in the document. Return each deadline with its details."),
|
||||||
|
InputSchema: anthropic.ToolInputSchemaParam{
|
||||||
|
Properties: map[string]any{
|
||||||
|
"deadlines": map[string]any{
|
||||||
|
"type": "array",
|
||||||
|
"description": "List of extracted deadlines",
|
||||||
|
"items": map[string]any{
|
||||||
|
"type": "object",
|
||||||
|
"properties": map[string]any{
|
||||||
|
"title": map[string]any{
|
||||||
|
"type": "string",
|
||||||
|
"description": "Short title describing the deadline (e.g. 'Statement of Defence', 'Reply to Counterclaim')",
|
||||||
|
},
|
||||||
|
"due_date": map[string]any{
|
||||||
|
"type": []string{"string", "null"},
|
||||||
|
"description": "Absolute due date in YYYY-MM-DD format if determinable, null otherwise",
|
||||||
|
},
|
||||||
|
"duration_value": map[string]any{
|
||||||
|
"type": "integer",
|
||||||
|
"description": "Numeric duration value (e.g. 3 for '3 months')",
|
||||||
|
},
|
||||||
|
"duration_unit": map[string]any{
|
||||||
|
"type": "string",
|
||||||
|
"enum": []string{"days", "weeks", "months"},
|
||||||
|
"description": "Unit of the duration period",
|
||||||
|
},
|
||||||
|
"timing": map[string]any{
|
||||||
|
"type": "string",
|
||||||
|
"enum": []string{"after", "before"},
|
||||||
|
"description": "Whether the deadline is before or after the trigger event",
|
||||||
|
},
|
||||||
|
"trigger_event": map[string]any{
|
||||||
|
"type": "string",
|
||||||
|
"description": "The event that triggers this deadline (e.g. 'service of the Statement of Claim')",
|
||||||
|
},
|
||||||
|
"rule_reference": map[string]any{
|
||||||
|
"type": "string",
|
||||||
|
"description": "Legal rule reference (e.g. 'Rule 23 RoP', 'Rule 222 RoP', '§ 276 ZPO')",
|
||||||
|
},
|
||||||
|
"confidence": map[string]any{
|
||||||
|
"type": "number",
|
||||||
|
"minimum": 0,
|
||||||
|
"maximum": 1,
|
||||||
|
"description": "Confidence score from 0.0 to 1.0",
|
||||||
|
},
|
||||||
|
"source_quote": map[string]any{
|
||||||
|
"type": "string",
|
||||||
|
"description": "The exact quote from the document where this deadline was found",
|
||||||
|
},
|
||||||
|
},
|
||||||
|
"required": []string{"title", "duration_value", "duration_unit", "timing", "trigger_event", "rule_reference", "confidence", "source_quote"},
|
||||||
|
},
|
||||||
|
},
|
||||||
|
},
|
||||||
|
Required: []string{"deadlines"},
|
||||||
|
},
|
||||||
|
}
|
||||||
|
|
||||||
|
const extractionSystemPrompt = `You are a legal deadline extraction assistant for German and UPC (Unified Patent Court) patent litigation.
|
||||||
|
|
||||||
|
Your task is to extract all legal deadlines, time limits, and procedural time periods from the provided document.
|
||||||
|
|
||||||
|
For each deadline found, extract:
|
||||||
|
- A clear title describing the deadline
|
||||||
|
- The absolute due date if it can be determined from the document
|
||||||
|
- The duration (value + unit: days/weeks/months)
|
||||||
|
- Whether it runs before or after a trigger event
|
||||||
|
- The trigger event that starts the deadline
|
||||||
|
- The legal rule reference (e.g. Rule 23 RoP, § 276 ZPO)
|
||||||
|
- Your confidence level (0.0-1.0) in the extraction
|
||||||
|
- The exact source quote from the document
|
||||||
|
|
||||||
|
Be thorough: extract every deadline mentioned, including conditional ones. If a deadline references another deadline (e.g. "within 2 months of the defence"), capture that relationship in the trigger_event field.
|
||||||
|
|
||||||
|
If the document contains no deadlines, return an empty list.`
|
||||||
|
|
||||||
|
// ExtractDeadlines sends a document (PDF or text) to Claude for deadline extraction.
|
||||||
|
func (s *AIService) ExtractDeadlines(ctx context.Context, pdfData []byte, text string) ([]ExtractedDeadline, error) {
|
||||||
|
var contentBlocks []anthropic.ContentBlockParamUnion
|
||||||
|
|
||||||
|
if len(pdfData) > 0 {
|
||||||
|
encoded := base64.StdEncoding.EncodeToString(pdfData)
|
||||||
|
contentBlocks = append(contentBlocks, anthropic.ContentBlockParamUnion{
|
||||||
|
OfDocument: &anthropic.DocumentBlockParam{
|
||||||
|
Source: anthropic.DocumentBlockParamSourceUnion{
|
||||||
|
OfBase64: &anthropic.Base64PDFSourceParam{
|
||||||
|
Data: encoded,
|
||||||
|
},
|
||||||
|
},
|
||||||
|
},
|
||||||
|
})
|
||||||
|
contentBlocks = append(contentBlocks, anthropic.NewTextBlock("Extract all legal deadlines from this document."))
|
||||||
|
} else if text != "" {
|
||||||
|
contentBlocks = append(contentBlocks, anthropic.NewTextBlock("Extract all legal deadlines from the following text:\n\n"+text))
|
||||||
|
} else {
|
||||||
|
return nil, fmt.Errorf("either pdf_data or text must be provided")
|
||||||
|
}
|
||||||
|
|
||||||
|
msg, err := s.client.Messages.New(ctx, anthropic.MessageNewParams{
|
||||||
|
Model: anthropic.ModelClaudeSonnet4_5,
|
||||||
|
MaxTokens: 4096,
|
||||||
|
System: []anthropic.TextBlockParam{
|
||||||
|
{Text: extractionSystemPrompt},
|
||||||
|
},
|
||||||
|
Messages: []anthropic.MessageParam{
|
||||||
|
anthropic.NewUserMessage(contentBlocks...),
|
||||||
|
},
|
||||||
|
Tools: []anthropic.ToolUnionParam{
|
||||||
|
{OfTool: &deadlineExtractionTool},
|
||||||
|
},
|
||||||
|
ToolChoice: anthropic.ToolChoiceParamOfTool("extract_deadlines"),
|
||||||
|
})
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("claude API call: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Find the tool_use block in the response
|
||||||
|
for _, block := range msg.Content {
|
||||||
|
if block.Type == "tool_use" && block.Name == "extract_deadlines" {
|
||||||
|
var input extractDeadlinesToolInput
|
||||||
|
if err := json.Unmarshal(block.Input, &input); err != nil {
|
||||||
|
return nil, fmt.Errorf("parsing tool output: %w", err)
|
||||||
|
}
|
||||||
|
return input.Deadlines, nil
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
return nil, fmt.Errorf("no tool_use block in response")
|
||||||
|
}
|
||||||
|
|
||||||
|
const summarizeSystemPrompt = `You are a legal case summary assistant for German and UPC patent litigation case management.
|
||||||
|
|
||||||
|
Given a case's details, recent events, and deadlines, produce a concise 2-3 sentence summary of what matters right now. Focus on:
|
||||||
|
- The most urgent upcoming deadline
|
||||||
|
- Recent significant events
|
||||||
|
- The current procedural stage
|
||||||
|
|
||||||
|
Write in clear, professional language suitable for a lawyer reviewing their case list. Be specific about dates and deadlines.`
|
||||||
|
|
||||||
|
// SummarizeCase generates an AI summary for a case and caches it in the database.
|
||||||
|
func (s *AIService) SummarizeCase(ctx context.Context, tenantID, caseID uuid.UUID) (string, error) {
|
||||||
|
// Load case
|
||||||
|
var c models.Case
|
||||||
|
err := s.db.GetContext(ctx, &c,
|
||||||
|
"SELECT * FROM cases WHERE id = $1 AND tenant_id = $2", caseID, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
return "", fmt.Errorf("loading case: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Load recent events
|
||||||
|
var events []models.CaseEvent
|
||||||
|
if err := s.db.SelectContext(ctx, &events,
|
||||||
|
"SELECT * FROM case_events WHERE case_id = $1 AND tenant_id = $2 ORDER BY created_at DESC LIMIT 10",
|
||||||
|
caseID, tenantID); err != nil {
|
||||||
|
return "", fmt.Errorf("loading events: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Load active deadlines
|
||||||
|
var deadlines []models.Deadline
|
||||||
|
if err := s.db.SelectContext(ctx, &deadlines,
|
||||||
|
"SELECT * FROM deadlines WHERE case_id = $1 AND tenant_id = $2 AND status = 'active' ORDER BY due_date ASC LIMIT 10",
|
||||||
|
caseID, tenantID); err != nil {
|
||||||
|
return "", fmt.Errorf("loading deadlines: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Build context text
|
||||||
|
caseInfo := fmt.Sprintf("Case: %s — %s\nStatus: %s", c.CaseNumber, c.Title, c.Status)
|
||||||
|
if c.Court != nil {
|
||||||
|
caseInfo += fmt.Sprintf("\nCourt: %s", *c.Court)
|
||||||
|
}
|
||||||
|
if c.CourtRef != nil {
|
||||||
|
caseInfo += fmt.Sprintf("\nCourt Reference: %s", *c.CourtRef)
|
||||||
|
}
|
||||||
|
if c.CaseType != nil {
|
||||||
|
caseInfo += fmt.Sprintf("\nType: %s", *c.CaseType)
|
||||||
|
}
|
||||||
|
|
||||||
|
eventText := "\n\nRecent Events:"
|
||||||
|
if len(events) == 0 {
|
||||||
|
eventText += "\nNo events recorded."
|
||||||
|
}
|
||||||
|
for _, e := range events {
|
||||||
|
eventText += fmt.Sprintf("\n- [%s] %s", e.CreatedAt.Format("2006-01-02"), e.Title)
|
||||||
|
if e.Description != nil {
|
||||||
|
eventText += fmt.Sprintf(": %s", *e.Description)
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
deadlineText := "\n\nUpcoming Deadlines:"
|
||||||
|
if len(deadlines) == 0 {
|
||||||
|
deadlineText += "\nNo active deadlines."
|
||||||
|
}
|
||||||
|
for _, d := range deadlines {
|
||||||
|
deadlineText += fmt.Sprintf("\n- %s: due %s (status: %s)", d.Title, d.DueDate, d.Status)
|
||||||
|
if d.Description != nil {
|
||||||
|
deadlineText += fmt.Sprintf(" — %s", *d.Description)
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
prompt := caseInfo + eventText + deadlineText
|
||||||
|
|
||||||
|
msg, err := s.client.Messages.New(ctx, anthropic.MessageNewParams{
|
||||||
|
Model: anthropic.ModelClaudeSonnet4_5,
|
||||||
|
MaxTokens: 512,
|
||||||
|
System: []anthropic.TextBlockParam{
|
||||||
|
{Text: summarizeSystemPrompt},
|
||||||
|
},
|
||||||
|
Messages: []anthropic.MessageParam{
|
||||||
|
anthropic.NewUserMessage(anthropic.NewTextBlock("Summarize the current state of this case:\n\n" + prompt)),
|
||||||
|
},
|
||||||
|
})
|
||||||
|
if err != nil {
|
||||||
|
return "", fmt.Errorf("claude API call: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Extract text from response
|
||||||
|
var summary string
|
||||||
|
for _, block := range msg.Content {
|
||||||
|
if block.Type == "text" {
|
||||||
|
summary += block.Text
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
if summary == "" {
|
||||||
|
return "", fmt.Errorf("empty response from Claude")
|
||||||
|
}
|
||||||
|
|
||||||
|
// Cache summary in database
|
||||||
|
_, err = s.db.ExecContext(ctx,
|
||||||
|
"UPDATE cases SET ai_summary = $1, updated_at = $2 WHERE id = $3 AND tenant_id = $4",
|
||||||
|
summary, time.Now(), caseID, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
return "", fmt.Errorf("caching summary: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
return summary, nil
|
||||||
|
}
|
||||||
109
backend/internal/services/ai_service_test.go
Normal file
109
backend/internal/services/ai_service_test.go
Normal file
@@ -0,0 +1,109 @@
|
|||||||
|
package services
|
||||||
|
|
||||||
|
import (
|
||||||
|
"encoding/json"
|
||||||
|
"testing"
|
||||||
|
)
|
||||||
|
|
||||||
|
func TestDeadlineExtractionToolSchema(t *testing.T) {
|
||||||
|
// Verify the tool schema serializes correctly
|
||||||
|
data, err := json.Marshal(deadlineExtractionTool)
|
||||||
|
if err != nil {
|
||||||
|
t.Fatalf("failed to marshal tool: %v", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
var parsed map[string]any
|
||||||
|
if err := json.Unmarshal(data, &parsed); err != nil {
|
||||||
|
t.Fatalf("failed to unmarshal tool JSON: %v", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
if parsed["name"] != "extract_deadlines" {
|
||||||
|
t.Errorf("expected name 'extract_deadlines', got %v", parsed["name"])
|
||||||
|
}
|
||||||
|
|
||||||
|
schema, ok := parsed["input_schema"].(map[string]any)
|
||||||
|
if !ok {
|
||||||
|
t.Fatal("input_schema is not a map")
|
||||||
|
}
|
||||||
|
|
||||||
|
if schema["type"] != "object" {
|
||||||
|
t.Errorf("expected schema type 'object', got %v", schema["type"])
|
||||||
|
}
|
||||||
|
|
||||||
|
props, ok := schema["properties"].(map[string]any)
|
||||||
|
if !ok {
|
||||||
|
t.Fatal("properties is not a map")
|
||||||
|
}
|
||||||
|
|
||||||
|
deadlines, ok := props["deadlines"].(map[string]any)
|
||||||
|
if !ok {
|
||||||
|
t.Fatal("deadlines property is not a map")
|
||||||
|
}
|
||||||
|
|
||||||
|
if deadlines["type"] != "array" {
|
||||||
|
t.Errorf("expected deadlines type 'array', got %v", deadlines["type"])
|
||||||
|
}
|
||||||
|
|
||||||
|
items, ok := deadlines["items"].(map[string]any)
|
||||||
|
if !ok {
|
||||||
|
t.Fatal("items is not a map")
|
||||||
|
}
|
||||||
|
|
||||||
|
itemProps, ok := items["properties"].(map[string]any)
|
||||||
|
if !ok {
|
||||||
|
t.Fatal("item properties is not a map")
|
||||||
|
}
|
||||||
|
|
||||||
|
expectedFields := []string{"title", "due_date", "duration_value", "duration_unit", "timing", "trigger_event", "rule_reference", "confidence", "source_quote"}
|
||||||
|
for _, field := range expectedFields {
|
||||||
|
if _, ok := itemProps[field]; !ok {
|
||||||
|
t.Errorf("missing expected field %q in item properties", field)
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
required, ok := items["required"].([]any)
|
||||||
|
if !ok {
|
||||||
|
t.Fatal("required is not a list")
|
||||||
|
}
|
||||||
|
if len(required) != 8 {
|
||||||
|
t.Errorf("expected 8 required fields, got %d", len(required))
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
func TestExtractedDeadlineJSON(t *testing.T) {
|
||||||
|
dueDate := "2026-04-15"
|
||||||
|
d := ExtractedDeadline{
|
||||||
|
Title: "Statement of Defence",
|
||||||
|
DueDate: &dueDate,
|
||||||
|
DurationValue: 3,
|
||||||
|
DurationUnit: "months",
|
||||||
|
Timing: "after",
|
||||||
|
TriggerEvent: "service of the Statement of Claim",
|
||||||
|
RuleReference: "Rule 23 RoP",
|
||||||
|
Confidence: 0.95,
|
||||||
|
SourceQuote: "The defendant shall file a defence within 3 months",
|
||||||
|
}
|
||||||
|
|
||||||
|
data, err := json.Marshal(d)
|
||||||
|
if err != nil {
|
||||||
|
t.Fatalf("failed to marshal: %v", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
var parsed ExtractedDeadline
|
||||||
|
if err := json.Unmarshal(data, &parsed); err != nil {
|
||||||
|
t.Fatalf("failed to unmarshal: %v", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
if parsed.Title != d.Title {
|
||||||
|
t.Errorf("title mismatch: %q != %q", parsed.Title, d.Title)
|
||||||
|
}
|
||||||
|
if *parsed.DueDate != *d.DueDate {
|
||||||
|
t.Errorf("due_date mismatch: %q != %q", *parsed.DueDate, *d.DueDate)
|
||||||
|
}
|
||||||
|
if parsed.DurationValue != d.DurationValue {
|
||||||
|
t.Errorf("duration_value mismatch: %d != %d", parsed.DurationValue, d.DurationValue)
|
||||||
|
}
|
||||||
|
if parsed.Confidence != d.Confidence {
|
||||||
|
t.Errorf("confidence mismatch: %f != %f", parsed.Confidence, d.Confidence)
|
||||||
|
}
|
||||||
|
}
|
||||||
135
backend/internal/services/appointment_service.go
Normal file
135
backend/internal/services/appointment_service.go
Normal file
@@ -0,0 +1,135 @@
|
|||||||
|
package services
|
||||||
|
|
||||||
|
import (
|
||||||
|
"context"
|
||||||
|
"fmt"
|
||||||
|
"time"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
"github.com/jmoiron/sqlx"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/models"
|
||||||
|
)
|
||||||
|
|
||||||
|
type AppointmentService struct {
|
||||||
|
db *sqlx.DB
|
||||||
|
}
|
||||||
|
|
||||||
|
func NewAppointmentService(db *sqlx.DB) *AppointmentService {
|
||||||
|
return &AppointmentService{db: db}
|
||||||
|
}
|
||||||
|
|
||||||
|
type AppointmentFilter struct {
|
||||||
|
CaseID *uuid.UUID
|
||||||
|
Type *string
|
||||||
|
StartFrom *time.Time
|
||||||
|
StartTo *time.Time
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *AppointmentService) List(ctx context.Context, tenantID uuid.UUID, filter AppointmentFilter) ([]models.Appointment, error) {
|
||||||
|
query := "SELECT * FROM appointments WHERE tenant_id = $1"
|
||||||
|
args := []any{tenantID}
|
||||||
|
argN := 2
|
||||||
|
|
||||||
|
if filter.CaseID != nil {
|
||||||
|
query += fmt.Sprintf(" AND case_id = $%d", argN)
|
||||||
|
args = append(args, *filter.CaseID)
|
||||||
|
argN++
|
||||||
|
}
|
||||||
|
if filter.Type != nil {
|
||||||
|
query += fmt.Sprintf(" AND appointment_type = $%d", argN)
|
||||||
|
args = append(args, *filter.Type)
|
||||||
|
argN++
|
||||||
|
}
|
||||||
|
if filter.StartFrom != nil {
|
||||||
|
query += fmt.Sprintf(" AND start_at >= $%d", argN)
|
||||||
|
args = append(args, *filter.StartFrom)
|
||||||
|
argN++
|
||||||
|
}
|
||||||
|
if filter.StartTo != nil {
|
||||||
|
query += fmt.Sprintf(" AND start_at <= $%d", argN)
|
||||||
|
args = append(args, *filter.StartTo)
|
||||||
|
argN++
|
||||||
|
}
|
||||||
|
|
||||||
|
query += " ORDER BY start_at ASC"
|
||||||
|
|
||||||
|
var appointments []models.Appointment
|
||||||
|
if err := s.db.SelectContext(ctx, &appointments, query, args...); err != nil {
|
||||||
|
return nil, fmt.Errorf("listing appointments: %w", err)
|
||||||
|
}
|
||||||
|
if appointments == nil {
|
||||||
|
appointments = []models.Appointment{}
|
||||||
|
}
|
||||||
|
return appointments, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *AppointmentService) GetByID(ctx context.Context, tenantID, id uuid.UUID) (*models.Appointment, error) {
|
||||||
|
var a models.Appointment
|
||||||
|
err := s.db.GetContext(ctx, &a, "SELECT * FROM appointments WHERE id = $1 AND tenant_id = $2", id, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("getting appointment: %w", err)
|
||||||
|
}
|
||||||
|
return &a, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *AppointmentService) Create(ctx context.Context, a *models.Appointment) error {
|
||||||
|
a.ID = uuid.New()
|
||||||
|
now := time.Now().UTC()
|
||||||
|
a.CreatedAt = now
|
||||||
|
a.UpdatedAt = now
|
||||||
|
|
||||||
|
_, err := s.db.NamedExecContext(ctx, `
|
||||||
|
INSERT INTO appointments (id, tenant_id, case_id, title, description, start_at, end_at, location, appointment_type, caldav_uid, caldav_etag, created_at, updated_at)
|
||||||
|
VALUES (:id, :tenant_id, :case_id, :title, :description, :start_at, :end_at, :location, :appointment_type, :caldav_uid, :caldav_etag, :created_at, :updated_at)
|
||||||
|
`, a)
|
||||||
|
if err != nil {
|
||||||
|
return fmt.Errorf("creating appointment: %w", err)
|
||||||
|
}
|
||||||
|
return nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *AppointmentService) Update(ctx context.Context, a *models.Appointment) error {
|
||||||
|
a.UpdatedAt = time.Now().UTC()
|
||||||
|
|
||||||
|
result, err := s.db.NamedExecContext(ctx, `
|
||||||
|
UPDATE appointments SET
|
||||||
|
case_id = :case_id,
|
||||||
|
title = :title,
|
||||||
|
description = :description,
|
||||||
|
start_at = :start_at,
|
||||||
|
end_at = :end_at,
|
||||||
|
location = :location,
|
||||||
|
appointment_type = :appointment_type,
|
||||||
|
caldav_uid = :caldav_uid,
|
||||||
|
caldav_etag = :caldav_etag,
|
||||||
|
updated_at = :updated_at
|
||||||
|
WHERE id = :id AND tenant_id = :tenant_id
|
||||||
|
`, a)
|
||||||
|
if err != nil {
|
||||||
|
return fmt.Errorf("updating appointment: %w", err)
|
||||||
|
}
|
||||||
|
rows, err := result.RowsAffected()
|
||||||
|
if err != nil {
|
||||||
|
return fmt.Errorf("checking rows affected: %w", err)
|
||||||
|
}
|
||||||
|
if rows == 0 {
|
||||||
|
return fmt.Errorf("appointment not found")
|
||||||
|
}
|
||||||
|
return nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *AppointmentService) Delete(ctx context.Context, tenantID, id uuid.UUID) error {
|
||||||
|
result, err := s.db.ExecContext(ctx, "DELETE FROM appointments WHERE id = $1 AND tenant_id = $2", id, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
return fmt.Errorf("deleting appointment: %w", err)
|
||||||
|
}
|
||||||
|
rows, err := result.RowsAffected()
|
||||||
|
if err != nil {
|
||||||
|
return fmt.Errorf("checking rows affected: %w", err)
|
||||||
|
}
|
||||||
|
if rows == 0 {
|
||||||
|
return fmt.Errorf("appointment not found")
|
||||||
|
}
|
||||||
|
return nil
|
||||||
|
}
|
||||||
277
backend/internal/services/case_service.go
Normal file
277
backend/internal/services/case_service.go
Normal file
@@ -0,0 +1,277 @@
|
|||||||
|
package services
|
||||||
|
|
||||||
|
import (
|
||||||
|
"context"
|
||||||
|
"database/sql"
|
||||||
|
"fmt"
|
||||||
|
"time"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/models"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
"github.com/jmoiron/sqlx"
|
||||||
|
)
|
||||||
|
|
||||||
|
type CaseService struct {
|
||||||
|
db *sqlx.DB
|
||||||
|
}
|
||||||
|
|
||||||
|
func NewCaseService(db *sqlx.DB) *CaseService {
|
||||||
|
return &CaseService{db: db}
|
||||||
|
}
|
||||||
|
|
||||||
|
type CaseFilter struct {
|
||||||
|
Status string
|
||||||
|
Type string
|
||||||
|
Search string
|
||||||
|
Limit int
|
||||||
|
Offset int
|
||||||
|
}
|
||||||
|
|
||||||
|
type CaseDetail struct {
|
||||||
|
models.Case
|
||||||
|
Parties []models.Party `json:"parties"`
|
||||||
|
RecentEvents []models.CaseEvent `json:"recent_events"`
|
||||||
|
DeadlinesCount int `json:"deadlines_count"`
|
||||||
|
}
|
||||||
|
|
||||||
|
type CreateCaseInput struct {
|
||||||
|
CaseNumber string `json:"case_number"`
|
||||||
|
Title string `json:"title"`
|
||||||
|
CaseType *string `json:"case_type,omitempty"`
|
||||||
|
Court *string `json:"court,omitempty"`
|
||||||
|
CourtRef *string `json:"court_ref,omitempty"`
|
||||||
|
Status string `json:"status"`
|
||||||
|
}
|
||||||
|
|
||||||
|
type UpdateCaseInput struct {
|
||||||
|
CaseNumber *string `json:"case_number,omitempty"`
|
||||||
|
Title *string `json:"title,omitempty"`
|
||||||
|
CaseType *string `json:"case_type,omitempty"`
|
||||||
|
Court *string `json:"court,omitempty"`
|
||||||
|
CourtRef *string `json:"court_ref,omitempty"`
|
||||||
|
Status *string `json:"status,omitempty"`
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *CaseService) List(ctx context.Context, tenantID uuid.UUID, filter CaseFilter) ([]models.Case, int, error) {
|
||||||
|
if filter.Limit <= 0 {
|
||||||
|
filter.Limit = 20
|
||||||
|
}
|
||||||
|
if filter.Limit > 100 {
|
||||||
|
filter.Limit = 100
|
||||||
|
}
|
||||||
|
|
||||||
|
// Build WHERE clause
|
||||||
|
where := "WHERE tenant_id = $1"
|
||||||
|
args := []interface{}{tenantID}
|
||||||
|
argIdx := 2
|
||||||
|
|
||||||
|
if filter.Status != "" {
|
||||||
|
where += fmt.Sprintf(" AND status = $%d", argIdx)
|
||||||
|
args = append(args, filter.Status)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if filter.Type != "" {
|
||||||
|
where += fmt.Sprintf(" AND case_type = $%d", argIdx)
|
||||||
|
args = append(args, filter.Type)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if filter.Search != "" {
|
||||||
|
where += fmt.Sprintf(" AND (title ILIKE $%d OR case_number ILIKE $%d)", argIdx, argIdx)
|
||||||
|
args = append(args, "%"+filter.Search+"%")
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
|
||||||
|
// Count total
|
||||||
|
var total int
|
||||||
|
countQuery := "SELECT COUNT(*) FROM cases " + where
|
||||||
|
if err := s.db.GetContext(ctx, &total, countQuery, args...); err != nil {
|
||||||
|
return nil, 0, fmt.Errorf("counting cases: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Fetch page
|
||||||
|
query := fmt.Sprintf("SELECT * FROM cases %s ORDER BY updated_at DESC LIMIT $%d OFFSET $%d",
|
||||||
|
where, argIdx, argIdx+1)
|
||||||
|
args = append(args, filter.Limit, filter.Offset)
|
||||||
|
|
||||||
|
var cases []models.Case
|
||||||
|
if err := s.db.SelectContext(ctx, &cases, query, args...); err != nil {
|
||||||
|
return nil, 0, fmt.Errorf("listing cases: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
return cases, total, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *CaseService) GetByID(ctx context.Context, tenantID, caseID uuid.UUID) (*CaseDetail, error) {
|
||||||
|
var c models.Case
|
||||||
|
err := s.db.GetContext(ctx, &c,
|
||||||
|
"SELECT * FROM cases WHERE id = $1 AND tenant_id = $2", caseID, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
if err == sql.ErrNoRows {
|
||||||
|
return nil, nil
|
||||||
|
}
|
||||||
|
return nil, fmt.Errorf("getting case: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
detail := &CaseDetail{Case: c}
|
||||||
|
|
||||||
|
// Parties
|
||||||
|
if err := s.db.SelectContext(ctx, &detail.Parties,
|
||||||
|
"SELECT * FROM parties WHERE case_id = $1 AND tenant_id = $2 ORDER BY name",
|
||||||
|
caseID, tenantID); err != nil {
|
||||||
|
return nil, fmt.Errorf("getting parties: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Recent events (last 20)
|
||||||
|
if err := s.db.SelectContext(ctx, &detail.RecentEvents,
|
||||||
|
"SELECT * FROM case_events WHERE case_id = $1 AND tenant_id = $2 ORDER BY created_at DESC LIMIT 20",
|
||||||
|
caseID, tenantID); err != nil {
|
||||||
|
return nil, fmt.Errorf("getting events: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Deadlines count
|
||||||
|
if err := s.db.GetContext(ctx, &detail.DeadlinesCount,
|
||||||
|
"SELECT COUNT(*) FROM deadlines WHERE case_id = $1 AND tenant_id = $2",
|
||||||
|
caseID, tenantID); err != nil {
|
||||||
|
return nil, fmt.Errorf("counting deadlines: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
return detail, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *CaseService) Create(ctx context.Context, tenantID uuid.UUID, userID uuid.UUID, input CreateCaseInput) (*models.Case, error) {
|
||||||
|
if input.Status == "" {
|
||||||
|
input.Status = "active"
|
||||||
|
}
|
||||||
|
|
||||||
|
id := uuid.New()
|
||||||
|
now := time.Now()
|
||||||
|
|
||||||
|
_, err := s.db.ExecContext(ctx,
|
||||||
|
`INSERT INTO cases (id, tenant_id, case_number, title, case_type, court, court_ref, status, metadata, created_at, updated_at)
|
||||||
|
VALUES ($1, $2, $3, $4, $5, $6, $7, $8, '{}', $9, $9)`,
|
||||||
|
id, tenantID, input.CaseNumber, input.Title, input.CaseType, input.Court, input.CourtRef, input.Status, now)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("creating case: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Create case_created event
|
||||||
|
createEvent(ctx, s.db, tenantID, id, userID, "case_created", "Case created", nil)
|
||||||
|
|
||||||
|
var c models.Case
|
||||||
|
if err := s.db.GetContext(ctx, &c, "SELECT * FROM cases WHERE id = $1", id); err != nil {
|
||||||
|
return nil, fmt.Errorf("fetching created case: %w", err)
|
||||||
|
}
|
||||||
|
return &c, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *CaseService) Update(ctx context.Context, tenantID, caseID uuid.UUID, userID uuid.UUID, input UpdateCaseInput) (*models.Case, error) {
|
||||||
|
// Fetch current to detect status change
|
||||||
|
var current models.Case
|
||||||
|
err := s.db.GetContext(ctx, ¤t,
|
||||||
|
"SELECT * FROM cases WHERE id = $1 AND tenant_id = $2", caseID, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
if err == sql.ErrNoRows {
|
||||||
|
return nil, nil
|
||||||
|
}
|
||||||
|
return nil, fmt.Errorf("fetching case for update: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Build SET clause dynamically
|
||||||
|
sets := []string{}
|
||||||
|
args := []interface{}{}
|
||||||
|
argIdx := 1
|
||||||
|
|
||||||
|
if input.CaseNumber != nil {
|
||||||
|
sets = append(sets, fmt.Sprintf("case_number = $%d", argIdx))
|
||||||
|
args = append(args, *input.CaseNumber)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if input.Title != nil {
|
||||||
|
sets = append(sets, fmt.Sprintf("title = $%d", argIdx))
|
||||||
|
args = append(args, *input.Title)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if input.CaseType != nil {
|
||||||
|
sets = append(sets, fmt.Sprintf("case_type = $%d", argIdx))
|
||||||
|
args = append(args, *input.CaseType)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if input.Court != nil {
|
||||||
|
sets = append(sets, fmt.Sprintf("court = $%d", argIdx))
|
||||||
|
args = append(args, *input.Court)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if input.CourtRef != nil {
|
||||||
|
sets = append(sets, fmt.Sprintf("court_ref = $%d", argIdx))
|
||||||
|
args = append(args, *input.CourtRef)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if input.Status != nil {
|
||||||
|
sets = append(sets, fmt.Sprintf("status = $%d", argIdx))
|
||||||
|
args = append(args, *input.Status)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
|
||||||
|
if len(sets) == 0 {
|
||||||
|
return ¤t, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
sets = append(sets, fmt.Sprintf("updated_at = $%d", argIdx))
|
||||||
|
args = append(args, time.Now())
|
||||||
|
argIdx++
|
||||||
|
|
||||||
|
query := fmt.Sprintf("UPDATE cases SET %s WHERE id = $%d AND tenant_id = $%d",
|
||||||
|
joinStrings(sets, ", "), argIdx, argIdx+1)
|
||||||
|
args = append(args, caseID, tenantID)
|
||||||
|
|
||||||
|
if _, err := s.db.ExecContext(ctx, query, args...); err != nil {
|
||||||
|
return nil, fmt.Errorf("updating case: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Log status change event
|
||||||
|
if input.Status != nil && *input.Status != current.Status {
|
||||||
|
desc := fmt.Sprintf("Status changed from %s to %s", current.Status, *input.Status)
|
||||||
|
createEvent(ctx, s.db, tenantID, caseID, userID, "status_changed", desc, nil)
|
||||||
|
}
|
||||||
|
|
||||||
|
var updated models.Case
|
||||||
|
if err := s.db.GetContext(ctx, &updated, "SELECT * FROM cases WHERE id = $1", caseID); err != nil {
|
||||||
|
return nil, fmt.Errorf("fetching updated case: %w", err)
|
||||||
|
}
|
||||||
|
return &updated, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *CaseService) Delete(ctx context.Context, tenantID, caseID uuid.UUID, userID uuid.UUID) error {
|
||||||
|
result, err := s.db.ExecContext(ctx,
|
||||||
|
"UPDATE cases SET status = 'archived', updated_at = $1 WHERE id = $2 AND tenant_id = $3 AND status != 'archived'",
|
||||||
|
time.Now(), caseID, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
return fmt.Errorf("archiving case: %w", err)
|
||||||
|
}
|
||||||
|
rows, _ := result.RowsAffected()
|
||||||
|
if rows == 0 {
|
||||||
|
return sql.ErrNoRows
|
||||||
|
}
|
||||||
|
createEvent(ctx, s.db, tenantID, caseID, userID, "case_archived", "Case archived", nil)
|
||||||
|
return nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func createEvent(ctx context.Context, db *sqlx.DB, tenantID, caseID uuid.UUID, userID uuid.UUID, eventType, title string, description *string) {
|
||||||
|
now := time.Now()
|
||||||
|
db.ExecContext(ctx,
|
||||||
|
`INSERT INTO case_events (id, tenant_id, case_id, event_type, title, description, event_date, created_by, metadata, created_at, updated_at)
|
||||||
|
VALUES ($1, $2, $3, $4, $5, $6, $7, $8, '{}', $7, $7)`,
|
||||||
|
uuid.New(), tenantID, caseID, eventType, title, description, now, userID)
|
||||||
|
}
|
||||||
|
|
||||||
|
func joinStrings(strs []string, sep string) string {
|
||||||
|
result := ""
|
||||||
|
for i, s := range strs {
|
||||||
|
if i > 0 {
|
||||||
|
result += sep
|
||||||
|
}
|
||||||
|
result += s
|
||||||
|
}
|
||||||
|
return result
|
||||||
|
}
|
||||||
99
backend/internal/services/deadline_calculator.go
Normal file
99
backend/internal/services/deadline_calculator.go
Normal file
@@ -0,0 +1,99 @@
|
|||||||
|
package services
|
||||||
|
|
||||||
|
import (
|
||||||
|
"time"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/models"
|
||||||
|
)
|
||||||
|
|
||||||
|
// CalculatedDeadline holds a calculated deadline with adjustment info
|
||||||
|
type CalculatedDeadline struct {
|
||||||
|
RuleCode string `json:"rule_code"`
|
||||||
|
RuleID string `json:"rule_id"`
|
||||||
|
Title string `json:"title"`
|
||||||
|
DueDate string `json:"due_date"`
|
||||||
|
OriginalDueDate string `json:"original_due_date"`
|
||||||
|
WasAdjusted bool `json:"was_adjusted"`
|
||||||
|
}
|
||||||
|
|
||||||
|
// DeadlineCalculator calculates deadlines from rules and event dates
|
||||||
|
type DeadlineCalculator struct {
|
||||||
|
holidays *HolidayService
|
||||||
|
}
|
||||||
|
|
||||||
|
// NewDeadlineCalculator creates a new calculator
|
||||||
|
func NewDeadlineCalculator(holidays *HolidayService) *DeadlineCalculator {
|
||||||
|
return &DeadlineCalculator{holidays: holidays}
|
||||||
|
}
|
||||||
|
|
||||||
|
// CalculateEndDate calculates the end date for a single deadline rule based on an event date.
|
||||||
|
// Adapted from youpc.org CalculateDeadlineEndDate.
|
||||||
|
func (c *DeadlineCalculator) CalculateEndDate(eventDate time.Time, rule models.DeadlineRule) (adjusted time.Time, original time.Time, wasAdjusted bool) {
|
||||||
|
endDate := eventDate
|
||||||
|
|
||||||
|
timing := "after"
|
||||||
|
if rule.Timing != nil {
|
||||||
|
timing = *rule.Timing
|
||||||
|
}
|
||||||
|
|
||||||
|
durationValue := rule.DurationValue
|
||||||
|
durationUnit := rule.DurationUnit
|
||||||
|
|
||||||
|
if timing == "before" {
|
||||||
|
switch durationUnit {
|
||||||
|
case "days":
|
||||||
|
endDate = endDate.AddDate(0, 0, -durationValue)
|
||||||
|
case "weeks":
|
||||||
|
endDate = endDate.AddDate(0, 0, -durationValue*7)
|
||||||
|
case "months":
|
||||||
|
endDate = endDate.AddDate(0, -durationValue, 0)
|
||||||
|
}
|
||||||
|
} else {
|
||||||
|
switch durationUnit {
|
||||||
|
case "days":
|
||||||
|
endDate = endDate.AddDate(0, 0, durationValue)
|
||||||
|
case "weeks":
|
||||||
|
endDate = endDate.AddDate(0, 0, durationValue*7)
|
||||||
|
case "months":
|
||||||
|
endDate = endDate.AddDate(0, durationValue, 0)
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
original = endDate
|
||||||
|
adjusted, _, wasAdjusted = c.holidays.AdjustForNonWorkingDays(endDate)
|
||||||
|
return adjusted, original, wasAdjusted
|
||||||
|
}
|
||||||
|
|
||||||
|
// CalculateFromRules calculates deadlines for a set of rules given an event date.
|
||||||
|
// Returns a list of calculated deadlines with due dates.
|
||||||
|
func (c *DeadlineCalculator) CalculateFromRules(eventDate time.Time, rules []models.DeadlineRule) []CalculatedDeadline {
|
||||||
|
results := make([]CalculatedDeadline, 0, len(rules))
|
||||||
|
|
||||||
|
for _, rule := range rules {
|
||||||
|
var adjusted, original time.Time
|
||||||
|
var wasAdjusted bool
|
||||||
|
|
||||||
|
if rule.DurationValue > 0 {
|
||||||
|
adjusted, original, wasAdjusted = c.CalculateEndDate(eventDate, rule)
|
||||||
|
} else {
|
||||||
|
adjusted = eventDate
|
||||||
|
original = eventDate
|
||||||
|
}
|
||||||
|
|
||||||
|
code := ""
|
||||||
|
if rule.Code != nil {
|
||||||
|
code = *rule.Code
|
||||||
|
}
|
||||||
|
|
||||||
|
results = append(results, CalculatedDeadline{
|
||||||
|
RuleCode: code,
|
||||||
|
RuleID: rule.ID.String(),
|
||||||
|
Title: rule.Name,
|
||||||
|
DueDate: adjusted.Format("2006-01-02"),
|
||||||
|
OriginalDueDate: original.Format("2006-01-02"),
|
||||||
|
WasAdjusted: wasAdjusted,
|
||||||
|
})
|
||||||
|
}
|
||||||
|
|
||||||
|
return results
|
||||||
|
}
|
||||||
141
backend/internal/services/deadline_calculator_test.go
Normal file
141
backend/internal/services/deadline_calculator_test.go
Normal file
@@ -0,0 +1,141 @@
|
|||||||
|
package services
|
||||||
|
|
||||||
|
import (
|
||||||
|
"testing"
|
||||||
|
"time"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/models"
|
||||||
|
)
|
||||||
|
|
||||||
|
func TestCalculateEndDateAfterDays(t *testing.T) {
|
||||||
|
holidays := NewHolidayService(nil)
|
||||||
|
calc := NewDeadlineCalculator(holidays)
|
||||||
|
|
||||||
|
eventDate := time.Date(2026, 3, 25, 0, 0, 0, 0, time.UTC) // Wednesday
|
||||||
|
timing := "after"
|
||||||
|
rule := models.DeadlineRule{
|
||||||
|
ID: uuid.New(),
|
||||||
|
Name: "Test 10 days",
|
||||||
|
DurationValue: 10,
|
||||||
|
DurationUnit: "days",
|
||||||
|
Timing: &timing,
|
||||||
|
}
|
||||||
|
|
||||||
|
adjusted, original, wasAdjusted := calc.CalculateEndDate(eventDate, rule)
|
||||||
|
|
||||||
|
// 25 March + 10 days = 4 April 2026 (Saturday)
|
||||||
|
// Apr 5 = Easter Sunday (holiday), Apr 6 = Easter Monday (holiday) -> adjusted to 7 April (Tuesday)
|
||||||
|
expectedOriginal := time.Date(2026, 4, 4, 0, 0, 0, 0, time.UTC)
|
||||||
|
expectedAdjusted := time.Date(2026, 4, 7, 0, 0, 0, 0, time.UTC)
|
||||||
|
|
||||||
|
if original != expectedOriginal {
|
||||||
|
t.Errorf("original should be %s, got %s", expectedOriginal, original)
|
||||||
|
}
|
||||||
|
if adjusted != expectedAdjusted {
|
||||||
|
t.Errorf("adjusted should be %s, got %s", expectedAdjusted, adjusted)
|
||||||
|
}
|
||||||
|
if !wasAdjusted {
|
||||||
|
t.Error("should have been adjusted (Saturday)")
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
func TestCalculateEndDateBeforeMonths(t *testing.T) {
|
||||||
|
holidays := NewHolidayService(nil)
|
||||||
|
calc := NewDeadlineCalculator(holidays)
|
||||||
|
|
||||||
|
eventDate := time.Date(2026, 6, 15, 0, 0, 0, 0, time.UTC) // Monday
|
||||||
|
timing := "before"
|
||||||
|
rule := models.DeadlineRule{
|
||||||
|
ID: uuid.New(),
|
||||||
|
Name: "Test 2 months before",
|
||||||
|
DurationValue: 2,
|
||||||
|
DurationUnit: "months",
|
||||||
|
Timing: &timing,
|
||||||
|
}
|
||||||
|
|
||||||
|
adjusted, original, wasAdjusted := calc.CalculateEndDate(eventDate, rule)
|
||||||
|
|
||||||
|
// 15 June - 2 months = 15 April 2026 (Wednesday)
|
||||||
|
expected := time.Date(2026, 4, 15, 0, 0, 0, 0, time.UTC)
|
||||||
|
|
||||||
|
if original != expected {
|
||||||
|
t.Errorf("original should be %s, got %s", expected, original)
|
||||||
|
}
|
||||||
|
if adjusted != expected {
|
||||||
|
t.Errorf("adjusted should be %s (not a holiday/weekend), got %s", expected, adjusted)
|
||||||
|
}
|
||||||
|
if wasAdjusted {
|
||||||
|
t.Error("should not have been adjusted (Wednesday)")
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
func TestCalculateEndDateWeeks(t *testing.T) {
|
||||||
|
holidays := NewHolidayService(nil)
|
||||||
|
calc := NewDeadlineCalculator(holidays)
|
||||||
|
|
||||||
|
eventDate := time.Date(2026, 3, 25, 0, 0, 0, 0, time.UTC) // Wednesday
|
||||||
|
timing := "after"
|
||||||
|
rule := models.DeadlineRule{
|
||||||
|
ID: uuid.New(),
|
||||||
|
Name: "Test 2 weeks",
|
||||||
|
DurationValue: 2,
|
||||||
|
DurationUnit: "weeks",
|
||||||
|
Timing: &timing,
|
||||||
|
}
|
||||||
|
|
||||||
|
adjusted, original, _ := calc.CalculateEndDate(eventDate, rule)
|
||||||
|
|
||||||
|
// 25 March + 14 days = 8 April 2026 (Wednesday)
|
||||||
|
expected := time.Date(2026, 4, 8, 0, 0, 0, 0, time.UTC)
|
||||||
|
if original != expected {
|
||||||
|
t.Errorf("original should be %s, got %s", expected, original)
|
||||||
|
}
|
||||||
|
if adjusted != expected {
|
||||||
|
t.Errorf("adjusted should be %s, got %s", expected, adjusted)
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
func TestCalculateFromRules(t *testing.T) {
|
||||||
|
holidays := NewHolidayService(nil)
|
||||||
|
calc := NewDeadlineCalculator(holidays)
|
||||||
|
|
||||||
|
eventDate := time.Date(2026, 3, 25, 0, 0, 0, 0, time.UTC)
|
||||||
|
timing := "after"
|
||||||
|
code := "TEST-1"
|
||||||
|
|
||||||
|
rules := []models.DeadlineRule{
|
||||||
|
{
|
||||||
|
ID: uuid.New(),
|
||||||
|
Code: &code,
|
||||||
|
Name: "Rule A",
|
||||||
|
DurationValue: 7,
|
||||||
|
DurationUnit: "days",
|
||||||
|
Timing: &timing,
|
||||||
|
},
|
||||||
|
{
|
||||||
|
ID: uuid.New(),
|
||||||
|
Name: "Rule B (zero duration)",
|
||||||
|
DurationValue: 0,
|
||||||
|
DurationUnit: "days",
|
||||||
|
},
|
||||||
|
}
|
||||||
|
|
||||||
|
results := calc.CalculateFromRules(eventDate, rules)
|
||||||
|
if len(results) != 2 {
|
||||||
|
t.Fatalf("expected 2 results, got %d", len(results))
|
||||||
|
}
|
||||||
|
|
||||||
|
// Rule A: 25 March + 7 = 1 April (Wednesday)
|
||||||
|
if results[0].DueDate != "2026-04-01" {
|
||||||
|
t.Errorf("Rule A due date should be 2026-04-01, got %s", results[0].DueDate)
|
||||||
|
}
|
||||||
|
if results[0].RuleCode != "TEST-1" {
|
||||||
|
t.Errorf("Rule A code should be TEST-1, got %s", results[0].RuleCode)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Rule B: zero duration -> event date
|
||||||
|
if results[1].DueDate != "2026-03-25" {
|
||||||
|
t.Errorf("Rule B due date should be 2026-03-25, got %s", results[1].DueDate)
|
||||||
|
}
|
||||||
|
}
|
||||||
175
backend/internal/services/deadline_rule_service.go
Normal file
175
backend/internal/services/deadline_rule_service.go
Normal file
@@ -0,0 +1,175 @@
|
|||||||
|
package services
|
||||||
|
|
||||||
|
import (
|
||||||
|
"fmt"
|
||||||
|
|
||||||
|
"github.com/jmoiron/sqlx"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/models"
|
||||||
|
)
|
||||||
|
|
||||||
|
// DeadlineRuleService handles deadline rule queries
|
||||||
|
type DeadlineRuleService struct {
|
||||||
|
db *sqlx.DB
|
||||||
|
}
|
||||||
|
|
||||||
|
// NewDeadlineRuleService creates a new deadline rule service
|
||||||
|
func NewDeadlineRuleService(db *sqlx.DB) *DeadlineRuleService {
|
||||||
|
return &DeadlineRuleService{db: db}
|
||||||
|
}
|
||||||
|
|
||||||
|
// List returns deadline rules, optionally filtered by proceeding type
|
||||||
|
func (s *DeadlineRuleService) List(proceedingTypeID *int) ([]models.DeadlineRule, error) {
|
||||||
|
var rules []models.DeadlineRule
|
||||||
|
var err error
|
||||||
|
|
||||||
|
if proceedingTypeID != nil {
|
||||||
|
err = s.db.Select(&rules,
|
||||||
|
`SELECT id, proceeding_type_id, parent_id, code, name, description,
|
||||||
|
primary_party, event_type, is_mandatory, duration_value, duration_unit,
|
||||||
|
timing, rule_code, deadline_notes, sequence_order, condition_rule_id,
|
||||||
|
alt_duration_value, alt_duration_unit, alt_rule_code, is_active,
|
||||||
|
created_at, updated_at
|
||||||
|
FROM deadline_rules
|
||||||
|
WHERE proceeding_type_id = $1 AND is_active = true
|
||||||
|
ORDER BY sequence_order`, *proceedingTypeID)
|
||||||
|
} else {
|
||||||
|
err = s.db.Select(&rules,
|
||||||
|
`SELECT id, proceeding_type_id, parent_id, code, name, description,
|
||||||
|
primary_party, event_type, is_mandatory, duration_value, duration_unit,
|
||||||
|
timing, rule_code, deadline_notes, sequence_order, condition_rule_id,
|
||||||
|
alt_duration_value, alt_duration_unit, alt_rule_code, is_active,
|
||||||
|
created_at, updated_at
|
||||||
|
FROM deadline_rules
|
||||||
|
WHERE is_active = true
|
||||||
|
ORDER BY proceeding_type_id, sequence_order`)
|
||||||
|
}
|
||||||
|
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("listing deadline rules: %w", err)
|
||||||
|
}
|
||||||
|
return rules, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// RuleTreeNode represents a deadline rule with its children
|
||||||
|
type RuleTreeNode struct {
|
||||||
|
models.DeadlineRule
|
||||||
|
Children []RuleTreeNode `json:"children,omitempty"`
|
||||||
|
}
|
||||||
|
|
||||||
|
// GetRuleTree returns a hierarchical tree of rules for a proceeding type
|
||||||
|
func (s *DeadlineRuleService) GetRuleTree(proceedingTypeCode string) ([]RuleTreeNode, error) {
|
||||||
|
// First resolve proceeding type code to ID
|
||||||
|
var pt models.ProceedingType
|
||||||
|
err := s.db.Get(&pt,
|
||||||
|
`SELECT id, code, name, description, jurisdiction, default_color, sort_order, is_active
|
||||||
|
FROM proceeding_types
|
||||||
|
WHERE code = $1 AND is_active = true`, proceedingTypeCode)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("resolving proceeding type %q: %w", proceedingTypeCode, err)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Get all rules for this proceeding type
|
||||||
|
var rules []models.DeadlineRule
|
||||||
|
err = s.db.Select(&rules,
|
||||||
|
`SELECT id, proceeding_type_id, parent_id, code, name, description,
|
||||||
|
primary_party, event_type, is_mandatory, duration_value, duration_unit,
|
||||||
|
timing, rule_code, deadline_notes, sequence_order, condition_rule_id,
|
||||||
|
alt_duration_value, alt_duration_unit, alt_rule_code, is_active,
|
||||||
|
created_at, updated_at
|
||||||
|
FROM deadline_rules
|
||||||
|
WHERE proceeding_type_id = $1 AND is_active = true
|
||||||
|
ORDER BY sequence_order`, pt.ID)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("listing rules for type %q: %w", proceedingTypeCode, err)
|
||||||
|
}
|
||||||
|
|
||||||
|
return buildTree(rules), nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// GetByIDs returns deadline rules by their IDs
|
||||||
|
func (s *DeadlineRuleService) GetByIDs(ids []string) ([]models.DeadlineRule, error) {
|
||||||
|
if len(ids) == 0 {
|
||||||
|
return nil, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
query, args, err := sqlx.In(
|
||||||
|
`SELECT id, proceeding_type_id, parent_id, code, name, description,
|
||||||
|
primary_party, event_type, is_mandatory, duration_value, duration_unit,
|
||||||
|
timing, rule_code, deadline_notes, sequence_order, condition_rule_id,
|
||||||
|
alt_duration_value, alt_duration_unit, alt_rule_code, is_active,
|
||||||
|
created_at, updated_at
|
||||||
|
FROM deadline_rules
|
||||||
|
WHERE id IN (?) AND is_active = true
|
||||||
|
ORDER BY sequence_order`, ids)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("building IN query: %w", err)
|
||||||
|
}
|
||||||
|
query = s.db.Rebind(query)
|
||||||
|
|
||||||
|
var rules []models.DeadlineRule
|
||||||
|
err = s.db.Select(&rules, query, args...)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("fetching rules by IDs: %w", err)
|
||||||
|
}
|
||||||
|
return rules, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// GetRulesForProceedingType returns all active rules for a proceeding type ID
|
||||||
|
func (s *DeadlineRuleService) GetRulesForProceedingType(proceedingTypeID int) ([]models.DeadlineRule, error) {
|
||||||
|
var rules []models.DeadlineRule
|
||||||
|
err := s.db.Select(&rules,
|
||||||
|
`SELECT id, proceeding_type_id, parent_id, code, name, description,
|
||||||
|
primary_party, event_type, is_mandatory, duration_value, duration_unit,
|
||||||
|
timing, rule_code, deadline_notes, sequence_order, condition_rule_id,
|
||||||
|
alt_duration_value, alt_duration_unit, alt_rule_code, is_active,
|
||||||
|
created_at, updated_at
|
||||||
|
FROM deadline_rules
|
||||||
|
WHERE proceeding_type_id = $1 AND is_active = true
|
||||||
|
ORDER BY sequence_order`, proceedingTypeID)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("listing rules for proceeding type %d: %w", proceedingTypeID, err)
|
||||||
|
}
|
||||||
|
return rules, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// ListProceedingTypes returns all active proceeding types
|
||||||
|
func (s *DeadlineRuleService) ListProceedingTypes() ([]models.ProceedingType, error) {
|
||||||
|
var types []models.ProceedingType
|
||||||
|
err := s.db.Select(&types,
|
||||||
|
`SELECT id, code, name, description, jurisdiction, default_color, sort_order, is_active
|
||||||
|
FROM proceeding_types
|
||||||
|
WHERE is_active = true
|
||||||
|
ORDER BY sort_order`)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("listing proceeding types: %w", err)
|
||||||
|
}
|
||||||
|
return types, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// buildTree converts a flat list of rules into a hierarchical tree
|
||||||
|
func buildTree(rules []models.DeadlineRule) []RuleTreeNode {
|
||||||
|
nodeMap := make(map[string]*RuleTreeNode, len(rules))
|
||||||
|
var roots []RuleTreeNode
|
||||||
|
|
||||||
|
// Create nodes
|
||||||
|
for _, r := range rules {
|
||||||
|
node := RuleTreeNode{DeadlineRule: r}
|
||||||
|
nodeMap[r.ID.String()] = &node
|
||||||
|
}
|
||||||
|
|
||||||
|
// Build tree
|
||||||
|
for _, r := range rules {
|
||||||
|
node := nodeMap[r.ID.String()]
|
||||||
|
if r.ParentID != nil {
|
||||||
|
parentKey := r.ParentID.String()
|
||||||
|
if parent, ok := nodeMap[parentKey]; ok {
|
||||||
|
parent.Children = append(parent.Children, *node)
|
||||||
|
continue
|
||||||
|
}
|
||||||
|
}
|
||||||
|
roots = append(roots, *node)
|
||||||
|
}
|
||||||
|
|
||||||
|
return roots
|
||||||
|
}
|
||||||
180
backend/internal/services/deadline_service.go
Normal file
180
backend/internal/services/deadline_service.go
Normal file
@@ -0,0 +1,180 @@
|
|||||||
|
package services
|
||||||
|
|
||||||
|
import (
|
||||||
|
"database/sql"
|
||||||
|
"fmt"
|
||||||
|
"time"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
"github.com/jmoiron/sqlx"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/models"
|
||||||
|
)
|
||||||
|
|
||||||
|
// DeadlineService handles CRUD operations for case deadlines
|
||||||
|
type DeadlineService struct {
|
||||||
|
db *sqlx.DB
|
||||||
|
}
|
||||||
|
|
||||||
|
// NewDeadlineService creates a new deadline service
|
||||||
|
func NewDeadlineService(db *sqlx.DB) *DeadlineService {
|
||||||
|
return &DeadlineService{db: db}
|
||||||
|
}
|
||||||
|
|
||||||
|
// ListForCase returns all deadlines for a case, scoped to tenant
|
||||||
|
func (s *DeadlineService) ListForCase(tenantID, caseID uuid.UUID) ([]models.Deadline, error) {
|
||||||
|
query := `SELECT id, tenant_id, case_id, title, description, due_date, original_due_date,
|
||||||
|
warning_date, source, rule_id, status, completed_at,
|
||||||
|
caldav_uid, caldav_etag, notes, created_at, updated_at
|
||||||
|
FROM deadlines
|
||||||
|
WHERE tenant_id = $1 AND case_id = $2
|
||||||
|
ORDER BY due_date ASC`
|
||||||
|
|
||||||
|
var deadlines []models.Deadline
|
||||||
|
err := s.db.Select(&deadlines, query, tenantID, caseID)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("listing deadlines for case: %w", err)
|
||||||
|
}
|
||||||
|
return deadlines, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// GetByID returns a single deadline by ID, scoped to tenant
|
||||||
|
func (s *DeadlineService) GetByID(tenantID, deadlineID uuid.UUID) (*models.Deadline, error) {
|
||||||
|
query := `SELECT id, tenant_id, case_id, title, description, due_date, original_due_date,
|
||||||
|
warning_date, source, rule_id, status, completed_at,
|
||||||
|
caldav_uid, caldav_etag, notes, created_at, updated_at
|
||||||
|
FROM deadlines
|
||||||
|
WHERE tenant_id = $1 AND id = $2`
|
||||||
|
|
||||||
|
var d models.Deadline
|
||||||
|
err := s.db.Get(&d, query, tenantID, deadlineID)
|
||||||
|
if err != nil {
|
||||||
|
if err == sql.ErrNoRows {
|
||||||
|
return nil, nil
|
||||||
|
}
|
||||||
|
return nil, fmt.Errorf("getting deadline: %w", err)
|
||||||
|
}
|
||||||
|
return &d, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// CreateDeadlineInput holds the fields for creating a deadline
|
||||||
|
type CreateDeadlineInput struct {
|
||||||
|
CaseID uuid.UUID `json:"case_id"`
|
||||||
|
Title string `json:"title"`
|
||||||
|
Description *string `json:"description,omitempty"`
|
||||||
|
DueDate string `json:"due_date"`
|
||||||
|
WarningDate *string `json:"warning_date,omitempty"`
|
||||||
|
Source string `json:"source"`
|
||||||
|
RuleID *uuid.UUID `json:"rule_id,omitempty"`
|
||||||
|
Notes *string `json:"notes,omitempty"`
|
||||||
|
}
|
||||||
|
|
||||||
|
// Create inserts a new deadline
|
||||||
|
func (s *DeadlineService) Create(tenantID uuid.UUID, input CreateDeadlineInput) (*models.Deadline, error) {
|
||||||
|
id := uuid.New()
|
||||||
|
source := input.Source
|
||||||
|
if source == "" {
|
||||||
|
source = "manual"
|
||||||
|
}
|
||||||
|
|
||||||
|
query := `INSERT INTO deadlines (id, tenant_id, case_id, title, description, due_date,
|
||||||
|
warning_date, source, rule_id, status, notes,
|
||||||
|
created_at, updated_at)
|
||||||
|
VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, 'pending', $10, NOW(), NOW())
|
||||||
|
RETURNING id, tenant_id, case_id, title, description, due_date, original_due_date,
|
||||||
|
warning_date, source, rule_id, status, completed_at,
|
||||||
|
caldav_uid, caldav_etag, notes, created_at, updated_at`
|
||||||
|
|
||||||
|
var d models.Deadline
|
||||||
|
err := s.db.Get(&d, query, id, tenantID, input.CaseID, input.Title, input.Description,
|
||||||
|
input.DueDate, input.WarningDate, source, input.RuleID, input.Notes)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("creating deadline: %w", err)
|
||||||
|
}
|
||||||
|
return &d, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// UpdateDeadlineInput holds the fields for updating a deadline
|
||||||
|
type UpdateDeadlineInput struct {
|
||||||
|
Title *string `json:"title,omitempty"`
|
||||||
|
Description *string `json:"description,omitempty"`
|
||||||
|
DueDate *string `json:"due_date,omitempty"`
|
||||||
|
WarningDate *string `json:"warning_date,omitempty"`
|
||||||
|
Notes *string `json:"notes,omitempty"`
|
||||||
|
Status *string `json:"status,omitempty"`
|
||||||
|
RuleID *uuid.UUID `json:"rule_id,omitempty"`
|
||||||
|
}
|
||||||
|
|
||||||
|
// Update modifies an existing deadline
|
||||||
|
func (s *DeadlineService) Update(tenantID, deadlineID uuid.UUID, input UpdateDeadlineInput) (*models.Deadline, error) {
|
||||||
|
// First check it exists and belongs to tenant
|
||||||
|
existing, err := s.GetByID(tenantID, deadlineID)
|
||||||
|
if err != nil {
|
||||||
|
return nil, err
|
||||||
|
}
|
||||||
|
if existing == nil {
|
||||||
|
return nil, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
query := `UPDATE deadlines SET
|
||||||
|
title = COALESCE($1, title),
|
||||||
|
description = COALESCE($2, description),
|
||||||
|
due_date = COALESCE($3, due_date),
|
||||||
|
warning_date = COALESCE($4, warning_date),
|
||||||
|
notes = COALESCE($5, notes),
|
||||||
|
status = COALESCE($6, status),
|
||||||
|
rule_id = COALESCE($7, rule_id),
|
||||||
|
updated_at = NOW()
|
||||||
|
WHERE id = $8 AND tenant_id = $9
|
||||||
|
RETURNING id, tenant_id, case_id, title, description, due_date, original_due_date,
|
||||||
|
warning_date, source, rule_id, status, completed_at,
|
||||||
|
caldav_uid, caldav_etag, notes, created_at, updated_at`
|
||||||
|
|
||||||
|
var d models.Deadline
|
||||||
|
err = s.db.Get(&d, query, input.Title, input.Description, input.DueDate,
|
||||||
|
input.WarningDate, input.Notes, input.Status, input.RuleID,
|
||||||
|
deadlineID, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("updating deadline: %w", err)
|
||||||
|
}
|
||||||
|
return &d, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// Complete marks a deadline as completed
|
||||||
|
func (s *DeadlineService) Complete(tenantID, deadlineID uuid.UUID) (*models.Deadline, error) {
|
||||||
|
query := `UPDATE deadlines SET
|
||||||
|
status = 'completed',
|
||||||
|
completed_at = $1,
|
||||||
|
updated_at = NOW()
|
||||||
|
WHERE id = $2 AND tenant_id = $3
|
||||||
|
RETURNING id, tenant_id, case_id, title, description, due_date, original_due_date,
|
||||||
|
warning_date, source, rule_id, status, completed_at,
|
||||||
|
caldav_uid, caldav_etag, notes, created_at, updated_at`
|
||||||
|
|
||||||
|
var d models.Deadline
|
||||||
|
err := s.db.Get(&d, query, time.Now(), deadlineID, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
if err == sql.ErrNoRows {
|
||||||
|
return nil, nil
|
||||||
|
}
|
||||||
|
return nil, fmt.Errorf("completing deadline: %w", err)
|
||||||
|
}
|
||||||
|
return &d, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// Delete removes a deadline
|
||||||
|
func (s *DeadlineService) Delete(tenantID, deadlineID uuid.UUID) error {
|
||||||
|
query := `DELETE FROM deadlines WHERE id = $1 AND tenant_id = $2`
|
||||||
|
result, err := s.db.Exec(query, deadlineID, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
return fmt.Errorf("deleting deadline: %w", err)
|
||||||
|
}
|
||||||
|
rows, err := result.RowsAffected()
|
||||||
|
if err != nil {
|
||||||
|
return fmt.Errorf("checking delete result: %w", err)
|
||||||
|
}
|
||||||
|
if rows == 0 {
|
||||||
|
return fmt.Errorf("deadline not found")
|
||||||
|
}
|
||||||
|
return nil
|
||||||
|
}
|
||||||
193
backend/internal/services/holidays.go
Normal file
193
backend/internal/services/holidays.go
Normal file
@@ -0,0 +1,193 @@
|
|||||||
|
package services
|
||||||
|
|
||||||
|
import (
|
||||||
|
"fmt"
|
||||||
|
"strings"
|
||||||
|
"time"
|
||||||
|
|
||||||
|
"github.com/jmoiron/sqlx"
|
||||||
|
)
|
||||||
|
|
||||||
|
// Holiday represents a non-working day
|
||||||
|
type Holiday struct {
|
||||||
|
Date time.Time
|
||||||
|
Name string
|
||||||
|
IsVacation bool // Part of court vacation period
|
||||||
|
IsClosure bool // Single-day closure (public holiday)
|
||||||
|
}
|
||||||
|
|
||||||
|
// HolidayService manages holiday data and non-working day checks
|
||||||
|
type HolidayService struct {
|
||||||
|
db *sqlx.DB
|
||||||
|
// Cached holidays by year
|
||||||
|
cache map[int][]Holiday
|
||||||
|
}
|
||||||
|
|
||||||
|
// NewHolidayService creates a holiday service
|
||||||
|
func NewHolidayService(db *sqlx.DB) *HolidayService {
|
||||||
|
return &HolidayService{
|
||||||
|
db: db,
|
||||||
|
cache: make(map[int][]Holiday),
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
// dbHoliday matches the holidays table schema
|
||||||
|
type dbHoliday struct {
|
||||||
|
ID int `db:"id"`
|
||||||
|
Date time.Time `db:"date"`
|
||||||
|
Name string `db:"name"`
|
||||||
|
Country string `db:"country"`
|
||||||
|
State *string `db:"state"`
|
||||||
|
HolidayType string `db:"holiday_type"`
|
||||||
|
}
|
||||||
|
|
||||||
|
// LoadHolidaysForYear loads holidays from DB for a given year, merges with
|
||||||
|
// German federal holidays, and caches the result.
|
||||||
|
func (s *HolidayService) LoadHolidaysForYear(year int) ([]Holiday, error) {
|
||||||
|
if cached, ok := s.cache[year]; ok {
|
||||||
|
return cached, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
holidays := make([]Holiday, 0, 30)
|
||||||
|
|
||||||
|
// Load from DB if available
|
||||||
|
if s.db != nil {
|
||||||
|
var dbHolidays []dbHoliday
|
||||||
|
err := s.db.Select(&dbHolidays,
|
||||||
|
`SELECT id, date, name, country, state, holiday_type
|
||||||
|
FROM holidays
|
||||||
|
WHERE EXTRACT(YEAR FROM date) = $1
|
||||||
|
ORDER BY date`, year)
|
||||||
|
if err == nil {
|
||||||
|
for _, h := range dbHolidays {
|
||||||
|
holidays = append(holidays, Holiday{
|
||||||
|
Date: h.Date,
|
||||||
|
Name: h.Name,
|
||||||
|
IsClosure: h.HolidayType == "public_holiday" || h.HolidayType == "closure",
|
||||||
|
IsVacation: h.HolidayType == "vacation",
|
||||||
|
})
|
||||||
|
}
|
||||||
|
}
|
||||||
|
// If DB query fails, fall through to hardcoded holidays
|
||||||
|
}
|
||||||
|
|
||||||
|
// Always add German federal holidays (if not already present from DB)
|
||||||
|
federal := germanFederalHolidays(year)
|
||||||
|
existing := make(map[string]bool, len(holidays))
|
||||||
|
for _, h := range holidays {
|
||||||
|
existing[h.Date.Format("2006-01-02")] = true
|
||||||
|
}
|
||||||
|
for _, h := range federal {
|
||||||
|
key := h.Date.Format("2006-01-02")
|
||||||
|
if !existing[key] {
|
||||||
|
holidays = append(holidays, h)
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
s.cache[year] = holidays
|
||||||
|
return holidays, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// IsHoliday checks if a date is a holiday
|
||||||
|
func (s *HolidayService) IsHoliday(date time.Time) *Holiday {
|
||||||
|
year := date.Year()
|
||||||
|
holidays, err := s.LoadHolidaysForYear(year)
|
||||||
|
if err != nil {
|
||||||
|
return nil
|
||||||
|
}
|
||||||
|
|
||||||
|
dateStr := date.Format("2006-01-02")
|
||||||
|
for i := range holidays {
|
||||||
|
if holidays[i].Date.Format("2006-01-02") == dateStr {
|
||||||
|
return &holidays[i]
|
||||||
|
}
|
||||||
|
}
|
||||||
|
return nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// IsNonWorkingDay returns true if the date is a weekend or holiday
|
||||||
|
func (s *HolidayService) IsNonWorkingDay(date time.Time) bool {
|
||||||
|
wd := date.Weekday()
|
||||||
|
if wd == time.Saturday || wd == time.Sunday {
|
||||||
|
return true
|
||||||
|
}
|
||||||
|
return s.IsHoliday(date) != nil
|
||||||
|
}
|
||||||
|
|
||||||
|
// AdjustForNonWorkingDays moves the date to the next working day
|
||||||
|
// if it falls on a weekend or holiday.
|
||||||
|
// Returns adjusted date, original date, and whether adjustment was made.
|
||||||
|
func (s *HolidayService) AdjustForNonWorkingDays(date time.Time) (adjusted time.Time, original time.Time, wasAdjusted bool) {
|
||||||
|
original = date
|
||||||
|
adjusted = date
|
||||||
|
|
||||||
|
// Safety limit: max 30 days forward
|
||||||
|
for i := 0; i < 30 && s.IsNonWorkingDay(adjusted); i++ {
|
||||||
|
adjusted = adjusted.AddDate(0, 0, 1)
|
||||||
|
wasAdjusted = true
|
||||||
|
}
|
||||||
|
|
||||||
|
return adjusted, original, wasAdjusted
|
||||||
|
}
|
||||||
|
|
||||||
|
// ClearCache clears the holiday cache (useful after DB updates)
|
||||||
|
func (s *HolidayService) ClearCache() {
|
||||||
|
s.cache = make(map[int][]Holiday)
|
||||||
|
}
|
||||||
|
|
||||||
|
// germanFederalHolidays returns all German federal public holidays for a year.
|
||||||
|
// These are holidays observed in all 16 German states.
|
||||||
|
func germanFederalHolidays(year int) []Holiday {
|
||||||
|
easterMonth, easterDay := CalculateEasterSunday(year)
|
||||||
|
easter := time.Date(year, time.Month(easterMonth), easterDay, 0, 0, 0, 0, time.UTC)
|
||||||
|
|
||||||
|
holidays := []Holiday{
|
||||||
|
{Date: time.Date(year, time.January, 1, 0, 0, 0, 0, time.UTC), Name: "Neujahr", IsClosure: true},
|
||||||
|
{Date: easter.AddDate(0, 0, -2), Name: "Karfreitag", IsClosure: true},
|
||||||
|
{Date: easter, Name: "Ostersonntag", IsClosure: true},
|
||||||
|
{Date: easter.AddDate(0, 0, 1), Name: "Ostermontag", IsClosure: true},
|
||||||
|
{Date: time.Date(year, time.May, 1, 0, 0, 0, 0, time.UTC), Name: "Tag der Arbeit", IsClosure: true},
|
||||||
|
{Date: easter.AddDate(0, 0, 39), Name: "Christi Himmelfahrt", IsClosure: true},
|
||||||
|
{Date: easter.AddDate(0, 0, 49), Name: "Pfingstsonntag", IsClosure: true},
|
||||||
|
{Date: easter.AddDate(0, 0, 50), Name: "Pfingstmontag", IsClosure: true},
|
||||||
|
{Date: time.Date(year, time.October, 3, 0, 0, 0, 0, time.UTC), Name: "Tag der Deutschen Einheit", IsClosure: true},
|
||||||
|
{Date: time.Date(year, time.December, 25, 0, 0, 0, 0, time.UTC), Name: "1. Weihnachtstag", IsClosure: true},
|
||||||
|
{Date: time.Date(year, time.December, 26, 0, 0, 0, 0, time.UTC), Name: "2. Weihnachtstag", IsClosure: true},
|
||||||
|
}
|
||||||
|
|
||||||
|
return holidays
|
||||||
|
}
|
||||||
|
|
||||||
|
// CalculateEasterSunday computes Easter Sunday using the Anonymous Gregorian algorithm.
|
||||||
|
// Returns month (1-12) and day.
|
||||||
|
func CalculateEasterSunday(year int) (int, int) {
|
||||||
|
a := year % 19
|
||||||
|
b := year / 100
|
||||||
|
c := year % 100
|
||||||
|
d := b / 4
|
||||||
|
e := b % 4
|
||||||
|
f := (b + 8) / 25
|
||||||
|
g := (b - f + 1) / 3
|
||||||
|
h := (19*a + b - d - g + 15) % 30
|
||||||
|
i := c / 4
|
||||||
|
k := c % 4
|
||||||
|
l := (32 + 2*e + 2*i - h - k) % 7
|
||||||
|
m := (a + 11*h + 22*l) / 451
|
||||||
|
month := (h + l - 7*m + 114) / 31
|
||||||
|
day := ((h + l - 7*m + 114) % 31) + 1
|
||||||
|
return month, day
|
||||||
|
}
|
||||||
|
|
||||||
|
// GetHolidaysForYear returns all holidays for a year (for API exposure)
|
||||||
|
func (s *HolidayService) GetHolidaysForYear(year int) ([]Holiday, error) {
|
||||||
|
return s.LoadHolidaysForYear(year)
|
||||||
|
}
|
||||||
|
|
||||||
|
// FormatHolidayList returns a simple string representation of holidays for debugging
|
||||||
|
func FormatHolidayList(holidays []Holiday) string {
|
||||||
|
var b strings.Builder
|
||||||
|
for _, h := range holidays {
|
||||||
|
fmt.Fprintf(&b, "%s: %s\n", h.Date.Format("2006-01-02"), h.Name)
|
||||||
|
}
|
||||||
|
return b.String()
|
||||||
|
}
|
||||||
121
backend/internal/services/holidays_test.go
Normal file
121
backend/internal/services/holidays_test.go
Normal file
@@ -0,0 +1,121 @@
|
|||||||
|
package services
|
||||||
|
|
||||||
|
import (
|
||||||
|
"testing"
|
||||||
|
"time"
|
||||||
|
)
|
||||||
|
|
||||||
|
func TestCalculateEasterSunday(t *testing.T) {
|
||||||
|
tests := []struct {
|
||||||
|
year int
|
||||||
|
wantMonth int
|
||||||
|
wantDay int
|
||||||
|
}{
|
||||||
|
{2024, 3, 31},
|
||||||
|
{2025, 4, 20},
|
||||||
|
{2026, 4, 5},
|
||||||
|
{2027, 3, 28},
|
||||||
|
}
|
||||||
|
|
||||||
|
for _, tt := range tests {
|
||||||
|
m, d := CalculateEasterSunday(tt.year)
|
||||||
|
if m != tt.wantMonth || d != tt.wantDay {
|
||||||
|
t.Errorf("CalculateEasterSunday(%d) = %d-%02d, want %d-%02d",
|
||||||
|
tt.year, m, d, tt.wantMonth, tt.wantDay)
|
||||||
|
}
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
func TestGermanFederalHolidays(t *testing.T) {
|
||||||
|
holidays := germanFederalHolidays(2026)
|
||||||
|
|
||||||
|
// Should have 11 federal holidays
|
||||||
|
if len(holidays) != 11 {
|
||||||
|
t.Fatalf("expected 11 federal holidays, got %d", len(holidays))
|
||||||
|
}
|
||||||
|
|
||||||
|
// Check Neujahr
|
||||||
|
if holidays[0].Name != "Neujahr" {
|
||||||
|
t.Errorf("first holiday should be Neujahr, got %s", holidays[0].Name)
|
||||||
|
}
|
||||||
|
if holidays[0].Date != time.Date(2026, 1, 1, 0, 0, 0, 0, time.UTC) {
|
||||||
|
t.Errorf("Neujahr should be Jan 1, got %s", holidays[0].Date)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Check Karfreitag 2026 (Easter = Apr 5, so Good Friday = Apr 3)
|
||||||
|
found := false
|
||||||
|
for _, h := range holidays {
|
||||||
|
if h.Name == "Karfreitag" {
|
||||||
|
found = true
|
||||||
|
expected := time.Date(2026, 4, 3, 0, 0, 0, 0, time.UTC)
|
||||||
|
if h.Date != expected {
|
||||||
|
t.Errorf("Karfreitag 2026 should be %s, got %s", expected, h.Date)
|
||||||
|
}
|
||||||
|
}
|
||||||
|
}
|
||||||
|
if !found {
|
||||||
|
t.Error("Karfreitag not found in holidays")
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
func TestHolidayServiceIsNonWorkingDay(t *testing.T) {
|
||||||
|
svc := NewHolidayService(nil) // no DB, uses hardcoded holidays
|
||||||
|
|
||||||
|
// Saturday
|
||||||
|
sat := time.Date(2026, 3, 28, 0, 0, 0, 0, time.UTC)
|
||||||
|
if !svc.IsNonWorkingDay(sat) {
|
||||||
|
t.Error("Saturday should be non-working day")
|
||||||
|
}
|
||||||
|
|
||||||
|
// Sunday
|
||||||
|
sun := time.Date(2026, 3, 29, 0, 0, 0, 0, time.UTC)
|
||||||
|
if !svc.IsNonWorkingDay(sun) {
|
||||||
|
t.Error("Sunday should be non-working day")
|
||||||
|
}
|
||||||
|
|
||||||
|
// Regular Monday
|
||||||
|
mon := time.Date(2026, 3, 23, 0, 0, 0, 0, time.UTC)
|
||||||
|
if svc.IsNonWorkingDay(mon) {
|
||||||
|
t.Error("regular Monday should be a working day")
|
||||||
|
}
|
||||||
|
|
||||||
|
// Christmas (Friday Dec 25, 2026)
|
||||||
|
xmas := time.Date(2026, 12, 25, 0, 0, 0, 0, time.UTC)
|
||||||
|
if !svc.IsNonWorkingDay(xmas) {
|
||||||
|
t.Error("Christmas should be non-working day")
|
||||||
|
}
|
||||||
|
|
||||||
|
// New Year
|
||||||
|
newyear := time.Date(2026, 1, 1, 0, 0, 0, 0, time.UTC)
|
||||||
|
if !svc.IsNonWorkingDay(newyear) {
|
||||||
|
t.Error("New Year should be non-working day")
|
||||||
|
}
|
||||||
|
}
|
||||||
|
|
||||||
|
func TestAdjustForNonWorkingDays(t *testing.T) {
|
||||||
|
svc := NewHolidayService(nil)
|
||||||
|
|
||||||
|
// Saturday -> Monday
|
||||||
|
sat := time.Date(2026, 3, 28, 0, 0, 0, 0, time.UTC)
|
||||||
|
adj, orig, adjusted := svc.AdjustForNonWorkingDays(sat)
|
||||||
|
if !adjusted {
|
||||||
|
t.Error("Saturday should be adjusted")
|
||||||
|
}
|
||||||
|
if orig != sat {
|
||||||
|
t.Error("original should be unchanged")
|
||||||
|
}
|
||||||
|
expected := time.Date(2026, 3, 30, 0, 0, 0, 0, time.UTC)
|
||||||
|
if adj != expected {
|
||||||
|
t.Errorf("Saturday should adjust to Monday %s, got %s", expected, adj)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Regular Wednesday -> no adjustment
|
||||||
|
wed := time.Date(2026, 3, 25, 0, 0, 0, 0, time.UTC)
|
||||||
|
adj, _, adjusted = svc.AdjustForNonWorkingDays(wed)
|
||||||
|
if adjusted {
|
||||||
|
t.Error("Wednesday should not be adjusted")
|
||||||
|
}
|
||||||
|
if adj != wed {
|
||||||
|
t.Error("non-adjusted date should be unchanged")
|
||||||
|
}
|
||||||
|
}
|
||||||
152
backend/internal/services/party_service.go
Normal file
152
backend/internal/services/party_service.go
Normal file
@@ -0,0 +1,152 @@
|
|||||||
|
package services
|
||||||
|
|
||||||
|
import (
|
||||||
|
"context"
|
||||||
|
"database/sql"
|
||||||
|
"encoding/json"
|
||||||
|
"fmt"
|
||||||
|
|
||||||
|
"mgit.msbls.de/m/KanzlAI-mGMT/internal/models"
|
||||||
|
|
||||||
|
"github.com/google/uuid"
|
||||||
|
"github.com/jmoiron/sqlx"
|
||||||
|
)
|
||||||
|
|
||||||
|
type PartyService struct {
|
||||||
|
db *sqlx.DB
|
||||||
|
}
|
||||||
|
|
||||||
|
func NewPartyService(db *sqlx.DB) *PartyService {
|
||||||
|
return &PartyService{db: db}
|
||||||
|
}
|
||||||
|
|
||||||
|
type CreatePartyInput struct {
|
||||||
|
Name string `json:"name"`
|
||||||
|
Role *string `json:"role,omitempty"`
|
||||||
|
Representative *string `json:"representative,omitempty"`
|
||||||
|
ContactInfo json.RawMessage `json:"contact_info,omitempty"`
|
||||||
|
}
|
||||||
|
|
||||||
|
type UpdatePartyInput struct {
|
||||||
|
Name *string `json:"name,omitempty"`
|
||||||
|
Role *string `json:"role,omitempty"`
|
||||||
|
Representative *string `json:"representative,omitempty"`
|
||||||
|
ContactInfo json.RawMessage `json:"contact_info,omitempty"`
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *PartyService) ListByCase(ctx context.Context, tenantID, caseID uuid.UUID) ([]models.Party, error) {
|
||||||
|
var parties []models.Party
|
||||||
|
err := s.db.SelectContext(ctx, &parties,
|
||||||
|
"SELECT * FROM parties WHERE case_id = $1 AND tenant_id = $2 ORDER BY name",
|
||||||
|
caseID, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("listing parties: %w", err)
|
||||||
|
}
|
||||||
|
return parties, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *PartyService) Create(ctx context.Context, tenantID, caseID uuid.UUID, userID uuid.UUID, input CreatePartyInput) (*models.Party, error) {
|
||||||
|
// Verify case exists and belongs to tenant
|
||||||
|
var exists bool
|
||||||
|
err := s.db.GetContext(ctx, &exists,
|
||||||
|
"SELECT EXISTS(SELECT 1 FROM cases WHERE id = $1 AND tenant_id = $2)", caseID, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("checking case: %w", err)
|
||||||
|
}
|
||||||
|
if !exists {
|
||||||
|
return nil, sql.ErrNoRows
|
||||||
|
}
|
||||||
|
|
||||||
|
id := uuid.New()
|
||||||
|
contactInfo := input.ContactInfo
|
||||||
|
if contactInfo == nil {
|
||||||
|
contactInfo = json.RawMessage("{}")
|
||||||
|
}
|
||||||
|
|
||||||
|
_, err = s.db.ExecContext(ctx,
|
||||||
|
`INSERT INTO parties (id, tenant_id, case_id, name, role, representative, contact_info)
|
||||||
|
VALUES ($1, $2, $3, $4, $5, $6, $7)`,
|
||||||
|
id, tenantID, caseID, input.Name, input.Role, input.Representative, contactInfo)
|
||||||
|
if err != nil {
|
||||||
|
return nil, fmt.Errorf("creating party: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
// Log event
|
||||||
|
desc := fmt.Sprintf("Party added: %s", input.Name)
|
||||||
|
createEvent(ctx, s.db, tenantID, caseID, userID, "party_added", desc, nil)
|
||||||
|
|
||||||
|
var party models.Party
|
||||||
|
if err := s.db.GetContext(ctx, &party, "SELECT * FROM parties WHERE id = $1", id); err != nil {
|
||||||
|
return nil, fmt.Errorf("fetching created party: %w", err)
|
||||||
|
}
|
||||||
|
return &party, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *PartyService) Update(ctx context.Context, tenantID, partyID uuid.UUID, input UpdatePartyInput) (*models.Party, error) {
|
||||||
|
// Verify party exists and belongs to tenant
|
||||||
|
var current models.Party
|
||||||
|
err := s.db.GetContext(ctx, ¤t,
|
||||||
|
"SELECT * FROM parties WHERE id = $1 AND tenant_id = $2", partyID, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
if err == sql.ErrNoRows {
|
||||||
|
return nil, nil
|
||||||
|
}
|
||||||
|
return nil, fmt.Errorf("fetching party: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
sets := []string{}
|
||||||
|
args := []interface{}{}
|
||||||
|
argIdx := 1
|
||||||
|
|
||||||
|
if input.Name != nil {
|
||||||
|
sets = append(sets, fmt.Sprintf("name = $%d", argIdx))
|
||||||
|
args = append(args, *input.Name)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if input.Role != nil {
|
||||||
|
sets = append(sets, fmt.Sprintf("role = $%d", argIdx))
|
||||||
|
args = append(args, *input.Role)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if input.Representative != nil {
|
||||||
|
sets = append(sets, fmt.Sprintf("representative = $%d", argIdx))
|
||||||
|
args = append(args, *input.Representative)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
if input.ContactInfo != nil {
|
||||||
|
sets = append(sets, fmt.Sprintf("contact_info = $%d", argIdx))
|
||||||
|
args = append(args, input.ContactInfo)
|
||||||
|
argIdx++
|
||||||
|
}
|
||||||
|
|
||||||
|
if len(sets) == 0 {
|
||||||
|
return ¤t, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
query := fmt.Sprintf("UPDATE parties SET %s WHERE id = $%d AND tenant_id = $%d",
|
||||||
|
joinStrings(sets, ", "), argIdx, argIdx+1)
|
||||||
|
args = append(args, partyID, tenantID)
|
||||||
|
|
||||||
|
if _, err := s.db.ExecContext(ctx, query, args...); err != nil {
|
||||||
|
return nil, fmt.Errorf("updating party: %w", err)
|
||||||
|
}
|
||||||
|
|
||||||
|
var updated models.Party
|
||||||
|
if err := s.db.GetContext(ctx, &updated, "SELECT * FROM parties WHERE id = $1", partyID); err != nil {
|
||||||
|
return nil, fmt.Errorf("fetching updated party: %w", err)
|
||||||
|
}
|
||||||
|
return &updated, nil
|
||||||
|
}
|
||||||
|
|
||||||
|
func (s *PartyService) Delete(ctx context.Context, tenantID, partyID uuid.UUID) error {
|
||||||
|
result, err := s.db.ExecContext(ctx,
|
||||||
|
"DELETE FROM parties WHERE id = $1 AND tenant_id = $2", partyID, tenantID)
|
||||||
|
if err != nil {
|
||||||
|
return fmt.Errorf("deleting party: %w", err)
|
||||||
|
}
|
||||||
|
rows, _ := result.RowsAffected()
|
||||||
|
if rows == 0 {
|
||||||
|
return sql.ErrNoRows
|
||||||
|
}
|
||||||
|
return nil
|
||||||
|
}
|
||||||
Reference in New Issue
Block a user