Data Layer high complexity backendmobile
0
Dependencies
0
Dependents
9
Entities
0
Integrations

Description

Data access layer managing all CRUD operations for activity corrections, approval records, and associated audit trails within Supabase. Scopes all queries to the coordinator's organizational hierarchy to enforce data isolation. Supports transactional writes that atomically update activity status and insert correction history records.

Feature: Coordinator Activity Approval & Correction

activity-correction-repository

Responsibilities

  • Fetch pending activity registrations scoped to coordinator's org hierarchy
  • Persist approval, rejection, and correction state transitions transactionally
  • Store correction diffs and reasons as immutable audit log entries
  • Query approval history and correction changelog for individual activities

Interfaces

getPendingActivities(orgScope)
getActivityById(activityId)
updateActivityStatus(activityId, status, metadata)
insertCorrectionRecord(activityId, corrections, reason, coordinatorId)
insertRejectionRecord(activityId, reason, coordinatorId)
bulkUpdateStatus(activityIds, status, coordinatorId)
getCorrectionHistory(activityId)
getApprovalAuditLog(orgScope, dateRange)
countPendingByOrg(orgScope)