# Q Tech Logistics Portal - Progress Log

**Last updated:** 21 November 2026
**Programme phase:** Phase 2 - Administration and learner-management portal  
**Current milestone:** Milestone 10 - Assessments and results
**Status:** Ready for review

Legend: Done | In progress | Not started | Waiting for input

## 1. Summary

| Area | Status | Notes |
|---|---|---|
| Public website | Done | Live at www.qtechlogistics.co.za |
| General enquiries | Done | Routed to info@qtechlogistics.co.za |
| Current applications | Done | Routed to admissions@qtechlogistics.co.za through Web3Forms |
| Portal planning | Done | Plan, progress and architecture documents created |
| Hosting validation | Waiting for input | Afrihost capabilities must be verified |
| Laravel and Filament foundation | Done | Local Milestone 6 accepted; hosting validation remains pending |
| Production database and deployment | Waiting for input | Requires verified Afrihost access and credentials |
| Applications and admissions review | Done | Milestone 7 approved for continued local implementation |
| Learner records and documents | Done | Local Milestone 8 implementation ready for review; production inputs remain outstanding |
| Courses and materials | Done | Local Milestone 9 implementation ready for review; production content remains outstanding |
| Assessments and results | Done | Local Milestone 10 implementation ready for review; production rules and content remain outstanding |
| Portal launch | Not started | Milestone 11 |

## 2. Milestone 5 Tracker

- [x] Confirm the public website is completed and live.
- [x] Confirm a separate portal application at portal.qtechlogistics.co.za.
- [x] Verify that the portal hostname resolves to the Afrihost server.
- [x] Verify that the portal hostname responds through the Afrihost LiteSpeed web server.
- [x] Select Laravel, Filament and MySQL.
- [x] Select one application with learner and administrator Filament panels.
- [x] Confirm Learner and Administrator as the first-release roles.
- [x] Confirm one global supporting-document checklist.
- [x] Confirm selective manual migration of historical applications.
- [x] Keep Web3Forms applications active until portal approval.
- [x] Create the portal plan, progress tracker and architecture specification.
- [ ] Verify the Afrihost PHP version and extensions.
- [ ] Verify MySQL provisioning and credentials.
- [ ] Verify SSL and portal-subdomain configuration.
- [ ] Verify private writable storage and document-root control.
- [ ] Verify upload limits and storage quota.
- [ ] Verify cron support.
- [ ] Verify SMTP connectivity.
- [ ] Confirm the available deployment method.
- [ ] Receive the outstanding client inputs.
- [ ] Review and approve Milestone 5.

## 3. Milestone 6 Tracker

- [x] Scaffold a separate Laravel application and retain the existing portal Git repository.
- [x] Install Laravel 13.38.0 and Filament 5.10.3 on PHP 8.4 locally.
- [x] Configure the branded learner panel at `/learner`.
- [x] Configure the staff panel at `/admin`.
- [x] Enable learner registration, login, email verification and password reset.
- [x] Disable public administrator registration.
- [x] Add learner and administrator roles with deny-by-default panel access.
- [x] Add a secure console command for first-administrator creation.
- [x] Configure MySQL environment placeholders without committing credentials.
- [x] Connect the local MAMP `qtechlogistics` database and run all foundation migrations.
- [x] Configure private local storage as the default disk.
- [x] Configure Q Tech SMTP placeholders and the admissions reply address.
- [x] Configure the Africa/Johannesburg application timezone.
- [x] Build the production frontend assets.
- [x] Pass automated route and role-boundary tests.
- [x] Pass PHP formatting and dependency vulnerability checks.
- [ ] Validate migrations, SMTP and authentication against the Afrihost MySQL environment.
- [x] Review and approve Milestone 6 for continued local implementation.

Milestone 6 was accepted for continued implementation when the project owner authorised the next milestone.

## 4. Milestone 7 Tracker

- [x] Seed the three approved courses from the production website content.
- [x] Add learner profiles with first name, surname and phone number.
- [x] Extend learner registration to create the learner profile.
- [x] Add learner-owned draft applications with non-sequential public identifiers and references.
- [x] Support valid website course slugs without creating unknown course records.
- [x] Allow learners to save and edit only their own draft applications.
- [x] Record privacy consent version and time when an application is submitted.
- [x] Lock submitted applications from learner editing.
- [x] Enforce Draft → Submitted → Under Review → Accepted or Unsuccessful transitions.
- [x] Record every transition, actor, time and learner-facing message.
- [x] Add administrator search, course filter and status filter.
- [x] Add private administrator notes that do not appear in the learner panel.
- [x] Add queued email and Filament inbox notifications for submission and status changes.
- [x] Add a dedicated `qtechlogistics_test` database for non-destructive automated testing.
- [x] Apply the six Milestone 7 migrations to the local development database.
- [x] Pass workflow, ownership, policy, notification and route-boundary tests.
- [x] Smoke-test learner login, learner registration and administrator login pages.
- [ ] Review and approve the provisional application fields and privacy-consent wording.
- [ ] Test SMTP delivery after working SMTP credentials are configured.
- [x] Review and approve Milestone 7 for continued local implementation.

Milestone 7 was accepted for continued implementation when the project owner requested the next implementable steps.

## 5. Milestone 8 Tracker

- [x] Add administrator-managed global document requirements with required, active and display-order settings.
- [x] Synchronise active checklist items to existing and newly registered learners.
- [x] Add learner-owned document records with non-sequential public identifiers.
- [x] Store every upload as an immutable version while keeping one current version.
- [x] Store files on the private disk outside the public web root.
- [x] Generate random stored names and retain a sanitised original display name.
- [x] Provisionally validate PDF, JPEG and PNG extensions and detected MIME types.
- [x] Add a configurable provisional 5 MB application limit.
- [x] Allow verified learners with submitted applications to upload and replace their own documents.
- [x] Add owner- and administrator-authorised downloads through a rate-limited controller.
- [x] Deny guest, unrelated-learner and superseded-version downloads.
- [x] Add administrator document search, filters, download, approval and changes-required actions.
- [x] Require a learner-facing message when changes are requested.
- [x] Add queued learner and administrator document notifications.
- [x] Add selective manual capture of historical applications with an optional password-setup email.
- [x] Record historical source and original received date without falsely recording portal privacy consent.
- [x] Display each learner's active document checklist, current files and review outcomes on their application page.
- [x] Display the applicant's complete document history on the administrator application page with secure download and review-record links.
- [x] Pass private-storage, MIME, replacement, review, ownership, route and historical-capture tests.
- [ ] Enter and approve the client's final global checklist.
- [ ] Confirm production file types and size limit against Afrihost.
- [ ] Approve privacy wording and retention/deletion rules.
- [ ] Test queued SMTP delivery with working credentials.
- [x] Review and approve Milestone 8 for continued local implementation.

Production document collection remains disabled until the unchecked client and hosting decisions are completed.

## 6. Milestone 9 Tracker

- [x] Add administrator-managed learner enrolments.
- [x] Add bulk course-offer creation for accepted applicants, filtered by selected course.
- [x] Add a learner My courses page, course-offer notifications and learner-owned offer acceptance.
- [x] Add administrator management of all verified and unverified portal accounts with account-type visibility.
- [x] Add secure administrator creation of learner and administrator accounts with password-setup emails.
- [x] Group administrator navigation into accounts/admissions, course delivery and assessments.
- [x] Group learner navigation into admissions, learning and assessments.
- [x] Add active, suspended, completed and cancelled enrolment states.
- [x] Support optional access start and end dates.
- [x] Restrict enrolment management to administrators.
- [x] Add administrator-managed private course-material uploads.
- [x] Support draft and published material states and display ordering.
- [x] Store material files outside the public web root.
- [x] Add policy-controlled, rate-limited material downloads.
- [x] Limit learner listings and downloads to published materials for current active enrolments.
- [x] Deny guest, unrelated-learner, suspended, expired and future-enrolment access.
- [x] Add automated workflow, ownership, download and panel-boundary tests.
- [ ] Receive and upload the approved initial course materials.
- [ ] Confirm production material file types and size limit against Afrihost.
- [ ] Review and approve Milestone 9.

## 7. Milestone 10 Tracker

- [x] Add administrator-managed assessment instructions, deadlines, maximum scores and publication state.
- [x] Limit learner assessment listings to published records for current active enrolments.
- [x] Add private learner submissions with stable receipt references and optional assessor notes.
- [x] Allow file replacement before the deadline while deleting the superseded private file.
- [x] Add learner receipt and administrator new-submission notifications.
- [x] Add administrator submission listing, detail and secure file download.
- [x] Add private draft results with score, competency outcome and feedback.
- [x] Require a separate deliberate action to publish a result to its learner.
- [x] Notify the learner when a result is published.
- [x] Deny guest, unrelated-learner, draft-assessment, inactive-enrolment and draft-result access.
- [x] Add automated workflow, ownership, publication and panel-boundary tests.
- [ ] Receive and enter the approved initial assessment instructions.
- [ ] Confirm scoring, competency outcome and publication rules with the client.
- [ ] Confirm production submission file types and size limit against Afrihost.
- [ ] Review and approve Milestone 10.

## 8. Later Milestones

| Milestone | Status | Main outcome |
|---|---|---|
| 10 - Assessments and results | Ready for review | Submissions, feedback and published results |
| 11 - Migration, testing, training and launch | Not started | Approved production portal |

## 9. Decisions

| Date | Decision | Reason |
|---|---|---|
| 3 October 2026 | Complete the public website before the portal | Protects the website launch and separates secure workflows |
| 11 October 2026 | Implement and approve one milestone at a time | Keeps scope and review controlled |
| 21 October 2026 | Begin Phase 2 after the production website launch | The public website is complete |
| 21 October 2026 | Use a separate portal project | Protects the production Nuxt website |
| 21 October 2026 | Use Laravel, Filament and MySQL on Afrihost | Matches the selected hosting environment |
| 21 October 2026 | Use learner and administrator Filament panels | Shares data and authentication while separating experiences |
| 21 October 2026 | Use one global document checklist | Keeps the first release simple |
| 21 October 2026 | Capture selected historical applications manually | Avoids an out-of-scope bulk importer |
| 21 October 2026 | Replace Web3Forms applications only after portal approval | Prevents disruption to admissions |
| 21 October 2026 | Start Milestone 6 before account-specific hosting validation is complete | Explicit project-owner direction to jump to the next implementable milestone; deployment remains blocked |
| 21 October 2026 | Use Laravel 13.38.0 and Filament 5.10.3 | Current local PHP 8.4 runtime supports this security baseline |
| 22 October 2026 | Begin Milestone 7 after the project owner requested the next implementation | Continues the approved roadmap without starting document uploads |
| 22 October 2026 | Reuse the production website's application fields and three course records | Keeps website and portal content consistent while client confirmation remains pending |
| 22 October 2026 | Use a separate automated-test database | Prevents tests from resetting the local development database |
| 22 October 2026 | Begin Milestone 8 after the project owner requested the next implementable steps | Continues the one-milestone-at-a-time roadmap without starting course delivery |
| 22 October 2026 | Leave the production checklist empty until client approval | Avoids inventing required personal documents while allowing the workflow to be tested |
| 22 October 2026 | Use versioned private files and policy-controlled downloads | Preserves replacement history without exposing learner documents publicly |
| 21 November 2026 | Begin Milestone 9 at the project owner's direction | Continues the approved roadmap with enrolment-controlled private learning materials |
| 21 November 2026 | Keep course materials on private storage with policy-controlled downloads | Prevents direct public file access and enforces current enrolment at request time |
| 21 November 2026 | Begin Milestone 10 at the project owner's direction | Continues the approved roadmap with enrolment-controlled assessments and private results |
| 21 November 2026 | Keep results private until a separate administrator publication action | Prevents draft scores, outcomes and feedback from leaking to learners |
| 21 November 2026 | Use shared Q-Tech branding on both portal sidebars | Keeps the administrator and learner experiences visually consistent while preserving panel separation |

## 10. Inputs Still Required

| Input | Needed by | Status |
|---|---|---|
| Supporting-document names and required/optional setting | Milestone 8 | Workflow implemented; waiting for approved content |
| Upload size and approved file types | Milestone 8 | Provisional PDF/JPEG/PNG and 5 MB implemented; waiting for approval and hosting check |
| Data-retention and deletion period | Milestone 8 | Deletion disabled; waiting for client/legal review |
| First administrator's name and email | Milestone 6 | Waiting for client |
| Final application fields and consent wording | Milestone 7 | Provisional website wording implemented; waiting for client review |
| Assessment score, outcome and publication rules | Milestone 10 | Provisional score plus Competent/Not yet competent workflow implemented; waiting for approval |
| Initial course materials | Milestone 9 | Workflow implemented; waiting for approved files |
| Material file types and production size limit | Milestone 9 | Provisional office documents, PDF, text, JPEG and PNG up to 20 MB; waiting for approval and hosting check |
| Initial assessment instructions | Milestone 10 | Workflow implemented; waiting for approved content |
| Historical applications to capture | Milestone 11 | Waiting for client |
| Afrihost runtime, database, storage, cron and deployment details | Milestone 5 | Waiting for validation |

Local development database credentials are configured only in the ignored `.env` file and are not committed.

## 11. Hosting Evidence Collected

| Check | Result | Evidence |
|---|---|---|
| Portal DNS | Verified | portal.qtechlogistics.co.za resolves to 197.242.159.145 |
| Public website DNS | Verified | www.qtechlogistics.co.za resolves to the same Afrihost address |
| Portal HTTP reachability | Verified | Afrihost LiteSpeed responds and currently serves its placeholder page |
| Portal application deployment | Not started | Local foundation is ready for review; the Afrihost placeholder remains unchanged |
| Portal HTTPS | Not verified | Must be confirmed from the hosting panel and browser after SSL is configured |
| PHP, extensions, MySQL, storage, cron, SMTP and backups | Not verified | Require account-specific cPanel or CWP inspection |
| Local MySQL development database | Verified | MAMP connection succeeded; Milestone 8 migrations and the three approved course seeds are applied as of 22 October 2026 |

## 12. Current Risks

| Risk | Control |
|---|---|
| Shared hosting may not meet current Laravel requirements | Complete the readiness gate before deployment |
| Document and retention rules are not approved | Keep production uploads disabled |
| Existing applications are stored in email | Manually capture only active records selected by the client |
| Later milestone content is not yet supplied | Track it without expanding the current milestone |
| SMTP has not been tested | Keep notifications queued and validate delivery before production deployment |
| Application wording remains subject to client confirmation | Treat current website wording as provisional and version the recorded consent |

## 13. Next Action

Test and review the Milestone 10 assessment, submission, receipt, draft-result and publication workflows with representative learner files. Confirm the scoring rules, outcome terminology, initial instructions, production submission types and size limit, then approve Milestone 10 before launch preparation. The earlier document-checklist, privacy, retention, content and hosting gates remain mandatory before production launch.
