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 = SG000042 …)               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 SG000042) · 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, 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