TC-EVT-007: Event Reporting & Analytics (Detailed)
Current facts. The event attendance report is at
/admin/events/:eventId/attendance (also /admin/reports/events/attendance/:eventId). Manual attendance marking: POST /api/events/admin/attendance/:registrationId/mark (+ /undo, /bulk-mark); insights at GET /api/events/:eventId/insights. Exports are CSV only (no Excel). Wherever this guide names a "QA Test …" event, use a real event from the live list.
WARNING: Reporting and analytics features may vary based on the current implementation status. Some reports may not yet be available. Document which reports exist and which are missing.
Expected Test Data Summary
Based on TC-EVT-001 through TC-EVT-006, the following test events and registrations should exist:
| # | Event | Type | Price | Registrations | Revenue |
|---|---|---|---|---|---|
| 1 | QA Test Coffee Meetup | Free (RSVP) | PHP 0 | 2–3 (testmember, guest, possibly expired) | PHP 0 |
| 2 | QA Test Fellowship Dinner | Paid (PAY_NOW) | PHP 3,000 / 3,500 | 1–2 (testmember at 3,000; guest at 3,500) | PHP 3,000–6,500 |
| 3 | QA Test Board Meeting | Free (RSVP) | PHP 0 | 0 | PHP 0 |
| 4 | QA Test Workshop: Project Management | Paid (PAY_NOW) | PHP 2,500 / 3,000 | 0 | PHP 0 |
| 5 | QA Test Limited Seats | Free (RSVP) | PHP 0 | 3 (full capacity) | PHP 0 |
TC-RPT-01: Event Summary Dashboard
| Step | Action | Expected Result | Test Value |
|---|---|---|---|
| 1 | Open a browser and log in as admin. | Dashboard loads. | admin@rcme.membervu.com / Admin123! |
| 2 | Navigate to Admin > Events or Admin > Reports > Events. | Events management or reporting page loads. | — |
| 3 | Look for summary statistics/cards at the top of the page. |
You should see aggregate metrics such as: • Total Events (includes seeded + QA test events) • Total Registrations • Total Revenue (from paid events) |
— |
| 4 | Verify the total events count includes the QA test events. | Count should be at least 5 (from QA tests) plus any seeded events. Exact number depends on existing seed data. | — |
TC-RPT-02: Per-Event Statistics
| Step | Action | Expected Result | Test Value |
|---|---|---|---|
| 1 | In the events list, find "QA Test Coffee Meetup". Click on it to view its details/stats. | Event detail or stats page opens. | QA Test Coffee Meetup |
| 2 | Look for registration statistics. |
Registered: 2–3 Checked In: 2 (from TC-EVT-006) Attendance Rate: ~100% |
— |
| 3 | Navigate back. Click on "QA Test Fellowship Dinner". | Event detail or stats page opens. | QA Test Fellowship Dinner |
| 4 | Look for revenue statistics. |
Registered: 1–2 Revenue: PHP 3,000–6,500 (depending on whether testmember and/or guest completed payment) Capacity used: 1–2 / 50 |
— |
| 5 | Navigate back. Click on "QA Test Limited Seats". | Event detail or stats page opens. | QA Test Limited Seats |
| 6 | Verify capacity utilization. |
Registered: 3 / 3 (100% capacity) Revenue: PHP 0 (free event) Status should clearly show "Full" or "Sold Out". |
— |
TC-RPT-03: Date Range Filtering
| Step | Action | Expected Result | Test Value |
|---|---|---|---|
| 1 | Navigate to the events report or events list with date filters. | Date range filter controls are visible (date pickers, presets, or dropdown). | — |
| 2 | Select "This Month" as the date range. | Only events occurring in the current month are shown. Events from other months are filtered out. | This Month |
| 3 | Select "This Quarter" (Q2 2026: April–June). | Events from April, May, and June 2026 are displayed. Earlier or later events are filtered out. | This Quarter |
| 4 | Select "This Year" (2026). | All events in 2026 are displayed, including past events from earlier in the year. | This Year |
| 5 | If custom date range is available, set a specific range. | Only events within the specified date range appear. | From: 2026-04-01 To: 2026-06-30 |
SKIP this section if date range filtering is not available on the events page. Note: "Date range filter not implemented for events."
TC-RPT-04: Export Event Report
| Step | Action | Expected Result | Test Value |
|---|---|---|---|
| 1 | On the events list or report page, look for an "Export" or "Download Report" button. | Export button is visible. | — |
| 2 | Click "Export". Select format if prompted (CSV, Excel, PDF). | A file downloads to your computer. The file name should include "events" and possibly a date range. | — |
| 3 | Open the downloaded file. | The file should contain columns such as: Event Name, Date, Venue, Capacity, Registrations, Revenue, Status. The QA test events should be included in the data. | — |
| 4 | Verify "QA Test Fellowship Dinner" row in the export. | Row shows: Name = "QA Test Fellowship Dinner", Revenue = PHP 3,000 or 6,500, Status = "Published". | — |
SKIP this section if the export/download feature is not available. Note: "Event report export not implemented."
TC-RPT-05: Revenue by Event Type
| Step | Action | Expected Result | Test Value |
|---|---|---|---|
| 1 | Look for a "Revenue" section, tab, or chart on the events report page. | Revenue breakdown is displayed, possibly as a chart or table. | — |
| 2 | Verify paid events show revenue amounts. |
"QA Test Fellowship Dinner": PHP 3,000–6,500 "QA Test Workshop: Project Management": PHP 0 (no registrations yet) Free events show PHP 0 revenue. |
— |
| 3 | Check if revenue is grouped by event type or category (if categorization exists). |
If grouping is available: • Dinner events: PHP 3,000–6,500 • Workshop events: PHP 0 • Free events (Coffee, Board Meeting): PHP 0 |
— |
| 4 | Verify total revenue across all events. | Total revenue should match the sum of all paid event registrations. Based on test data: PHP 3,000–6,500 (from the Fellowship Dinner only). | — |
SKIP if revenue reporting is not available. Note: "Revenue analytics not implemented for events."
TC-RPT-06: Member Permission — No Access to Reports
| Step | Action | Expected Result | Test Value |
|---|---|---|---|
| 1 | Log out of admin. Log in as testmember. | Member dashboard loads. | testmember@rcme.membervu.com / Member123! |
| 2 | Attempt to navigate to the admin events report page by typing the URL directly. | You should be redirected to the member dashboard or see an "Access Denied" / "403 Forbidden" page. Regular members should NOT have access to admin event reports. | https://stg-rcme.membervu.com/admin/events/reports |
| 3 | Verify the sidebar does not show admin-only menu items. | The sidebar should NOT show "Admin", "Reports", or "Event Management" links for a regular member. | — |
CLEANUP — Final Cleanup for All Event Tests
Now that all event test cases (TC-EVT-001 through TC-EVT-007) are complete, delete the QA test events:
- Log in as admin or Events Manager.
- Navigate to Admin > Events.
- Delete each QA test event:
- QA Test Coffee Meetup
- QA Test Fellowship Dinner
- QA Test Board Meeting
- QA Test Workshop: Project Management
- QA Test Limited Seats
- QA Test Cancelled Event (if not already removed)
- QA Test Draft Networking Night (if created)
- QA Test Gala Dinner (if created)
- Verify the events list no longer shows any "QA Test" events.
All associated registrations, check-ins, and invoices should be cascade-deleted with the events.