Activity Oversight Repository
Component Detail
Data Layer
medium complexity
backend
0
Dependencies
2
Dependents
0
Entities
0
Integrations
Description
Data access layer for admin activity oversight queries. Provides paginated, filterable reads of activities scoped to an organization and write operations for status transitions. Maintains the reviewed_at, updated_by, and rejection_reason fields in the activities table using pure SQL migrations.
activity-oversight-repository
Responsibilities
- Query activities by organization and status with pagination and cursor-based sorting
- Update activity status along with reviewed_at, updated_by, and rejection_reason fields
- Aggregate pending activity counts per organization for dashboard KPI widgets
- Execute bulk status updates atomically within a single database transaction
Interfaces
findByStatus(orgId: string, status: ActivityStatus, page: number, limit: number): Promise<PaginatedActivities>
updateStatus(activityId: string, status: ActivityStatus, reviewerId: string, reason?: string): Promise<void>
bulkUpdateStatus(activityIds: string[], status: ActivityStatus, reviewerId: string): Promise<void>
countPending(orgId: string): Promise<number>
findById(activityId: string): Promise<Activity>
Relationships
Dependents (2)
Components that depend on this component