Tertiary Courses LMS (ai-mms)

Screenshot

Step-by-step, screenshot-driven guides for running the LMS from the admin panel — see docs/admin-guide/ :

• Admin guide index — logging in, managing the store
• Changing a course fee
• Changing the currency conversion rate

Tertiary Courses LMS is a complete, production-grade course-registration and learning-management platform built on OpenMage 1.x (Magento 1 LTS) and customised for Tertiary Infotech Academy. Every product is a course (instructor-led trainings, workshops, certifications) — there is no physical inventory or shipping. The storefront is the course-registration portal, and the admin panel is rebranded as a Training Management System for instructors and operations staff.

This system runs as a franchise model:

• 📚 Courseware is supplied and supported by Tertiary Courses Singapore. Franchisees plug into a ready-made catalogue of WSQ / IBF / SkillsFuture-aligned courses — they don't have to author content from scratch.
• 🛠️ Each franchise partner hosts their own server. The same codebase (this repo) is deployed to every partner's own server + database — one store per website, fully independent (own domain, currency, language, pricing, funding hooks). No shared multi-store install, no shared catalogue, no cross-site redirects.
• 🌏 Live partner sites: 🇸🇬 tertiarycourses.com.sg · 🇲🇾 tertiarycourses.com.my · 🇬🇭 tertiarycourses.com.gh.

🤝 Become a franchise partner

Want to run an AI-powered future-tech training academy in your country — with a ready-made WSQ / IBF / SkillsFuture-aligned catalogue and this LMS set up on your own server? 👉 Apply to become a franchise partner — fill in the application form on the website and our team will be in touch.

 FRANCHISE PARTNERS — same codebase, each on its own server + DB
 🇸🇬 com.sg 🇲🇾 com.my 🇬🇭 com.gh
 (one store per site · independent · no cross-site redirects)
 │
 ▼
┌──────────────────────────────────────────────────────────────────────────┐
│ STOREFRONT (Ultimo theme · course-registration portal) │
│ Browse courses → register (cart/checkout) → pay → confirmation email │
└──────────────────────────────────────────────────────────────────────────┘
 │ order = registration
 ▼
┌──────────────────────────────────────────────────────────────────────────┐
│ BACKEND (cron, every 1 min — out-of-band, frontend untouched) │
│ ClassFormation → CourseRunEnrolmentService │
│ │ │ │
│ ▼ ▼ │
│ course_runs (class instance, course_run_enrolments (roster, │
│ class_id = C000042 ...) idempotent INSERT IGNORE) │
└──────────────────────────────────────────────────────────────────────────┘
 │
 ▼
┌──────────────────────────────────────────────────────────────────────────┐
│ ADMIN (Training Management System · dark theme · six-role ACL) │
│ Classes · Rosters · Trainers · Attendance · Certificates · Pro Formas │
└──────────────────────────────────────────────────────────────────────────┘

Franchise data model — six axioms: Product = Course · Class identity = (course_code, title, start_date) · Class storage = one course_runs row (class_id like C000042 — uniform per-site sequence) · Order = Registration · Roster = course_run_enrolments · Users = six-role union with unified accounts.

ai-mms/
├── app/
│ ├── code/
│ │ ├── core/Mage/ # OpenMage LTS core
│ │ ├── local/MMD/ # Custom franchise modules (see below)
│ │ └── community/ # Stripe, HitPay
│ ├── design/ # Storefront + admin templates (.phtml)
│ └── etc/ # local.xml, modules/
├── skin/ # Ultimo theme + dark admin theme (CSS/JS)
├── lib/ # Varien / Zend / Magento libraries
├── migrations/ # Numbered *.sql applied by apply.php on deploy
├── scripts/ # local-dev fixups + maintenance scripts
├── docker/ # entrypoint.sh, php.ini, Apache config
├── docker-compose.yml # Local dev stack (web + MySQL)
└── Dockerfile # Production image

• Docker Desktop installed and running
• A base database dump (courses_mysql2.sql) placed in the project root

# 1. Clone
git clone https://github.com/alfredang/ai-mms.git
cd ai-mms
# 2. Configure environment
cp .env.example .env # set MySQL passwords + API keys
cp app/etc/local.xml.example app/etc/local.xml # match DB credentials to .env
# 3. Build and start the stack
docker compose up -d --build
# 4. Import the base database
docker exec -i ai-mms-db_mysql-1 \
 mysql -u root -p"$MYSQL_ROOT_PASSWORD" "$MYSQL_DATABASE" < courses_mysql2.sql
# 5. Apply migrations (schema + data) via the real runner
docker exec ai-mms-web-1 php /var/www/html/migrations/apply.php
# 6. Apply local-dev fixups (localhost URLs, disable admin captcha, enable products)
for f in scripts/local-dev/*.sql; do
 docker exec -i ai-mms-db_mysql-1 mysql -u root -p"$MYSQL_ROOT_PASSWORD" "$MYSQL_DATABASE" < "$f"
done
# 7. Install Composer dependencies + clear cache
docker exec ai-mms-web-1 bash -c 'cd /var/www/html && composer install --no-dev --optimize-autoloader'
docker exec ai-mms-web-1 bash -c 'rm -rf /var/www/html/var/cache/* /var/www/html/var/full_page_cache/*'

Every franchise partner's server deploys automatically via its own Coolify instance on every push to main (each connected through Coolify's GitHub App git source):

1. Coolify rebuilds the image from the pushed commit.
2. docker/entrypoint.sh clears Magento runtime cache, then runs migrations/apply.php (with retry/backoff while the DB comes up).
3. If migrations fail, the container exits non-zero so Coolify keeps the previous container — traffic is never served against a stale schema.
4. Build timestamp is written to /version.txt; public migration status at /media/migrations-status.json.

User-uploaded media (catalog product/category galleries) is served from Cloudflare R2; theme-baked assets ship inside the image.

Note for contributors: never git push until localhost is verified error-free — production redeploys on every push. Lint changed PHP, confirm rewrites instantiate, hit affected routes, and dry-run new migrations through migrations/apply.php (not the mysql client) before pushing.

1. Fork the repository
2. Create a feature branch: git checkout -b feature/my-change
3. Make your changes and verify locally (lint + route checks + migration dry-run)
4. Commit and open a Pull Request

Issues and feature requests are welcome via GitHub Issues.

This repo ships its AI coding tooling in-repo so every team member uses the same setup. Committed and ready to use after a clone:

• .claude/skills/ — domain skills (openmage-code-reviewer, openmage-module-developer, openmage-frontend-developer, backend-design, seo-audit, lead-magnets, add-country-store, recommended-courses, linkedin-posts, mysql, web-accessibility, ...).
• .claude/agents/ — specialised subagents (security auditor, caching/speed optimiser, mysql tuner, admin-design-consistency, site-health-checker, newsletter-designer, ...).
• .claude/hooks/ — pre/post-tool hooks (PHP lint-on-edit, web-health, leads-capture and newsletter-flyer verifiers) wired via .claude/settings.json.
• .codex/ + AGENTS.md — the Codex-CLI counterparts of the same guidance.

CLAUDE.md / AGENTS.md are the behavioural guardrails both assistants load automatically.

Tertiary Infotech Academy Pte. Ltd. 🌐 tertiarycourses.com.sg · ✉️ enquiry@tertiaryinfotech.com · ☎️ +65 6100 0613

• OpenMage LTS — the maintained Magento 1 fork this platform is built on
• Infortis Ultimo — storefront theme
• SkillsFuture Singapore (SSG), IBF, and HRD Corp — funding frameworks the catalogue aligns to