Implement Core Hierarchy Service
epic-organizational-hierarchy-management-admin-portal-task-007 — Build the high-complexity service layer that encapsulates all hierarchy business logic. Provide methods for tree traversal, node lifecycle management (create/rename/move/delete), member count computation, and search. Coordinate between organization unit repository and hierarchy cache. This is the primary service consumed by admin portal and access scope.
Acceptance Criteria
Technical Requirements
Execution Context
Tier 3 - 413 tasks
Can start after Tier 2 completes
Implementation Notes
Implement as a Riverpod-managed service class HierarchyService injected via a Provider. Internal dependencies: OrganizationUnitRepository (data layer), HierarchyStructureValidator (task-005), and HierarchyCache (in-memory LRU cache keyed by organizationId). The repository handles raw Supabase queries; the service handles business rules. Use a recursive CTE Postgres function (get_organization_tree) invoked via supabase.rpc() to fetch the full tree in one round-trip — avoid assembling the tree client-side from a flat list.
For moveNode, fetch the ancestor path of the proposed new parent before calling the validator (one additional query). For Realtime subscriptions, subscribe to the organization_units table filtered by organization_id and pipe changes through a StreamController exposed as watchSubtree(). The cache should store the last fetched tree per organizationId and be invalidated on any write operation to force a fresh fetch on next read. NHF's 1400-chapter structure makes caching especially important for the admin portal's performance.
Testing Requirements
Unit tests with mocked OrganizationUnitRepository covering all service methods including edge cases: moving a node to its own descendant (circular), deleting a node with children, renaming to a name that conflicts with a sibling. Integration tests against a local Supabase instance for: tree load with 50+ nodes, concurrent write conflict handling, Realtime stream emission on update. Use flutter_test and mockito for unit tests. Test coverage target: 90% of service class lines.
Performance test: load NHF-scale mock tree (1400 nodes) and assert response within 1.5s.
If the AccessScopeService and the Supabase RLS policies use different logic to determine accessible units, a coordinator could see data in the client that RLS blocks server-side, causing confusing empty states, or worse, RLS could block data the scope service declares accessible.
Mitigation & Contingency
Mitigation: Define the canonical scope computation in a single Supabase Postgres function shared by both the RLS policies and the RPC endpoint called by AccessScopeService. The client-side service calls this RPC rather than reimplementing the logic, ensuring a single source of truth.
Contingency: Add integration tests that execute the same access decision through both the RLS policy path and the AccessScopeService path and assert identical results. Use these as regression guards in the CI pipeline.
When a user switches active chapter via the ChapterSwitcher, widgets that are already built may not receive the context-change event if they subscribe incorrectly to the ActiveChapterState BLoC, leading to stale data being displayed under the new chapter context.
Mitigation & Contingency
Mitigation: Use Riverpod's ref.watch on the active chapter provider at the root of each scoped data subtree rather than at individual leaf widgets. Trigger a global data refresh by invalidating all scoped providers when the chapter changes.
Contingency: Add an app-level chapter-change listener that forces a full navigation stack reset to the home screen on chapter switch, guaranteeing all widgets rebuild from scratch with the new context. Accept the UX cost of navigation reset for correctness.
Non-technical organization administrators may find the hierarchy management interface too complex for the structural changes they need to make frequently (e.g., chapter renaming, coordinator reassignment), leading to low adoption and continued reliance on manual processes.
Mitigation & Contingency
Mitigation: Conduct usability testing with at least one NHF administrator before finalizing the admin portal screen layout. Prioritize the most common operations (rename, reparent, add child) as primary actions in the UI. Include inline help text and confirmation dialogs with plain-language descriptions of consequences.
Contingency: Provide a simplified 'quick edit' mode that exposes only the three most common operations (rename, deactivate, add child) and hides advanced structural operations behind an 'Advanced' toggle.