E11-F5: Violation Monitoring Report¶
Epic: E11: Blacklist & Security
Size: S (Small)
Problem / Outcome¶
Track and report blocked purchase attempts.
Scope¶
In-Scope:
- Report of blocked attempts: date, name, OIB, event, IP, user account
- Filters by date range, individual, event
- CSV export
Out-of-Scope:
- Automated alerting
Acceptance Criteria¶
- AC1: Report lists all blocked purchase attempts with details
- AC2: Filterable by date range, individual, event
- AC3: Export to CSV available
Data Model Impact¶
No new tables required.
Report query from ViolationLog:
- blocked_at (TIMESTAMP)
- name (from Blacklist join)
- oib (VARCHAR)
- match_name (from Match join)
- ip_address (VARCHAR)
- user_account (from User join if available)
- action_type (ENUM)
Filters:
- date_from, date_to
- oib
- match_id
- user_id
Permissions/Roles¶
- Admin (BLACKADMIN)
How to Verify¶
npm test -- --grep "violation report"
Expected: Report generates with correct data.
Dependencies¶
Implementation Tasks¶
See E11: Blacklist ## Doc References Security Tasks
Doc References¶
Last Updated: January 2026