Forum Read Operations

sequenceDiagram autonumber participant B as Browser participant R as Route/Middleware participant FR as ListForumsRequest participant C as ForumController participant S as ForumService participant ER as EnrolmentRepository participant FRep as ForumRepository participant DB as Moodle DB B->>R: GET /api/v1/courses/{courseId}/forums R->>R: auth:sanctum + moodle.active alt Unauthenticated R-->>B: 401 Unauthorized end R->>FR: validate(courseId, per_page?) alt Validation fails FR-->>B: 422 Unprocessable end FR->>C: index(request, courseId) C->>S: list(ListForumsDTO) S->>ER: isEnrolledInCourse(studentId, courseId) ER->>DB: SELECT mdl_enrol + mdl_user_enrolments DB-->>ER: enrolled? alt Not enrolled ER-->>S: false S-->>C: throws ForumAccessDeniedException C-->>B: 403 Forbidden end S->>FRep: listForCourse(dto) FRep->>DB: SELECT forum.* JOIN course_modules WHERE visible=1 DB-->>FRep: LengthAwarePaginator FRep-->>S: paginator S-->>C: paginator C->>S: getDiscussionCountMap(forumIds) S->>FRep: getDiscussionCountMap(forumIds) FRep->>DB: SELECT COUNT(*) FROM forum_discussions GROUP BY forum DB-->>FRep: map[forumId]count FRep-->>S: discussionCountMap S-->>C: discussionCountMap C-->>B: 200 ForumCollection (paginated)

sequenceDiagram autonumber participant B as Browser participant R as Route/Middleware participant C as DiscussionController participant S as ForumService participant ER as EnrolmentRepository participant FRep as ForumRepository participant DRep as DiscussionRepository participant DB as Moodle DB participant Q as Queue B->>R: GET /api/v1/courses/{courseId}/forums/{forumId}/discussions R->>R: auth:sanctum + moodle.active R->>C: index(request, courseId, forumId) C->>S: listDiscussions(ListDiscussionsDTO) S->>ER: isEnrolledInCourse(studentId, courseId) alt Not enrolled S-->>C: throws ForumAccessDeniedException C-->>B: 403 Forbidden end S->>FRep: findForCourse(forumId, courseId) alt Forum not found / invisible FRep-->>S: throws ForumNotFoundException S-->>C: propagates C-->>B: 404 Not Found end FRep->>DB: SELECT forum.* JOIN course_modules WHERE visible=1 DB-->>FRep: MoodleForum S->>DRep: listForForum(dto) DRep->>DB: SELECT forum_discussions JOIN user WHERE timestart/timeend OK ORDER BY pinned DESC DB-->>DRep: LengthAwarePaginator DRep-->>S: paginator S->>Q: dispatch ForumDiscussionListViewed (async) S-->>C: paginator C->>S: getReplyCountMap(discussionIds) S->>DRep: getReplyCountMap(ids) DRep->>DB: COUNT forum_posts WHERE parent>0 GROUP BY discussion DB-->>DRep: map[discussionId]count DRep-->>C: replyCountMap C-->>B: 200 DiscussionCollection (paginated + reply counts)

sequenceDiagram autonumber participant B as Browser participant R as Route/Middleware participant C as PostController participant S as ForumService participant ER as EnrolmentRepository participant FRep as ForumRepository participant DRep as DiscussionRepository participant PRep as PostRepository participant CR as ContextResolver participant FR2 as FileRepository participant DB as Moodle DB participant Q as Queue B->>R: GET /api/v1/courses/{courseId}/forums/{forumId}/discussions/{discussionId}/posts R->>R: auth:sanctum + moodle.active R->>C: index(request, courseId, forumId, discussionId) C->>S: listPosts(ListPostsDTO) S->>ER: isEnrolledInCourse(studentId, courseId) alt Not enrolled C-->>B: 403 Forbidden end S->>FRep: findForCourse(forumId, courseId) alt Forum not found C-->>B: 404 Forum Not Found end S->>DRep: findForForum(discussionId, forumId) alt Discussion not found C-->>B: 404 Discussion Not Found end S->>PRep: listForDiscussion(dto) PRep->>DB: SELECT forum_posts JOIN user WHERE deleted=0 ORDER BY created ASC DB-->>PRep: LengthAwarePaginator PRep-->>S: paginator S->>Q: dispatch ForumPostListViewed (async) S-->>C: paginator C->>S: getPostAttachmentsMap(postIds, forumId, courseId) S->>FRep: getCourseModuleId(forumId, courseId) FRep->>DB: SELECT cm.id FROM course_modules DB-->>FRep: courseModuleId S->>CR: resolve(Module, courseModuleId) CR->>DB: SELECT id FROM context WHERE contextlevel=70 Note over CR: Cached 24h DB-->>CR: contextId S->>FR2: findAllByContextIds([contextId], mod_forum, attachment) FR2->>DB: SELECT * FROM mdl_files WHERE component=mod_forum filearea=attachment DB-->>FR2: Collection of MoodleFile S->>S: groupBy(itemid=postId), filter to page postIds S->>S: attachmentUrl(file) → MoodleFileUrl::pluginfileUrl() → HMAC signed URL C-->>B: 200 PostCollection (paginated + signed URLs)

flowchart TD A([HTTP Request]) --> B{auth:sanctum\nmoodle.active} B -->|Invalid token| Z1([401 Unauthorized]) B -->|Valid| C[FormRequest validates\nroute params] C -->|Invalid params| Z2([422 Validation Error]) C -->|Valid| D[Service::assertEnrolled\nstudentId + courseId] D -->|Not enrolled| Z3([403 Forbidden]) D -->|Enrolled| E{Which endpoint?} E -->|GET /forums| F[ForumRepository\nlistForCourse\nJOIN course_modules\nvisible=1] F --> F1[getDiscussionCountMap\nbatch COUNT visible discussions] F1 --> F2([200 ForumCollection\npaginated]) E -->|GET /discussions| G[ForumRepository\nfindForCourse\nverify forum visible] G -->|Not found| Z4([404 Forum Not Found]) G -->|Found| H[DiscussionRepository\nlistForForum\ntimestart+timeend filter\nJOIN user for author] H --> H1[dispatch ForumDiscussionListViewed\nasync on queue] H1 --> H2[getReplyCountMap\nCOUNT posts WHERE parent>0] H2 --> H3([200 DiscussionCollection\nwith reply counts]) E -->|GET /posts| I[ForumRepository\nfindForCourse] I -->|Not found| Z5([404 Forum Not Found]) I -->|Found| J[DiscussionRepository\nfindForForum] J -->|Not found| Z6([404 Discussion Not Found]) J -->|Found| K[PostRepository\nlistForDiscussion\nglobal scope deleted=0\nJOIN user for author] K --> K1[dispatch ForumPostListViewed\nasync on queue] K1 --> L[getPostAttachmentsMap\nresolve contextId via cache] L --> M[FileRepository\nbatch-fetch mod_forum/attachment\nfrom mdl_files] M --> N[groupBy postId\nMoodleFileUrl::pluginfileUrl\nHMAC-signed URL per file] N --> O([200 PostCollection\nwith signed attachment URLs]) style Z1 fill:#7f1d1d,color:#fca5a5,stroke:#ef4444 style Z2 fill:#7f1d1d,color:#fca5a5,stroke:#ef4444 style Z3 fill:#7f1d1d,color:#fca5a5,stroke:#ef4444 style Z4 fill:#7f1d1d,color:#fca5a5,stroke:#ef4444 style Z5 fill:#7f1d1d,color:#fca5a5,stroke:#ef4444 style Z6 fill:#7f1d1d,color:#fca5a5,stroke:#ef4444 style F2 fill:#064e3b,color:#6ee7b7,stroke:#10b981 style H3 fill:#064e3b,color:#6ee7b7,stroke:#10b981 style O fill:#064e3b,color:#6ee7b7,stroke:#10b981