Cambodia CMS — end-to-end functional flow

flowchart LR
  subgraph Recruit["1 · Recruit"]
    MKT[Marketing
app_*]
    CDU[CDU / AQA]
  end
  subgraph Admit["2 · Admit"]
    REG1[Registry
offer letters]
    APP[Online / staff
app_applicationform*]
  end
  subgraph Enrol["3 · Enrol"]
    REG2[Registry
r_student / programme]
    FAC1[Faculty
structure / modules]
    SET[Setup
terms / fees]
  end
  subgraph Study["4 · Study"]
    FAC2[Faculty
timetable / results]
    LEC[Lecturer
marks / attendance]
    IH[IH
attendance / marks]
  end
  subgraph Money["5 · Finance"]
    BUR[Bursary
invoice / pay / assist]
  end
  subgraph Life["6 · Student life"]
    SVC[Services
w_* visa / welfare]
    ACC[Accommodation
w_dorm / w_room]
  end
  subgraph Close["7 · Close / report"]
    REP[Reporting]
    BATCH[cambodiabatch
→ portalcambodia]
  end

  MKT --> APP
  CDU -.-> APP
  APP --> REG1
  REG1 --> REG2
  SET --> REG2
  FAC1 --> REG2
  REG2 --> FAC2
  FAC2 --> LEC
  FAC2 --> IH
  REG2 --> BUR
  REG2 --> SVC
  REG2 --> ACC
  FAC2 --> REP
  BUR --> REP
  BATCH -.-> REP
          

mindmap
  root((Cambodia CMS
CMS 0.9))
    Academic
      registry
      faculty
      lecturer
      cdu
      ih
      modulemat
    Student_life
      services
      accommodation
      notice
    Commercial
      bursary
      marketing
      Assist_Limkokwing
    Platform
      setup
      reporting
      cambodiabatch
      portal_api_hooks
      zemail
          

flowchart TD
  A[Marketing / online app
app_applicationform*] --> B[Docs / education
app_docfile · app_applicationeducation]
  B --> C[Registry offer
r_stdofferletter · FetchOfferLetters]
  C --> D[Confirm / enrol SPs
AfterInsertApplicationForm · OnlineReg*]
  D --> E[r_student + r_stdprogram
+ r_stdsemester]
  E --> F[Faculty structure
f_program / f_module]
  E --> G[Bursary fee plan]
          

flowchart LR
  T[Term / structure
f_term · f_program*] --> M[Module enrolment
r_stdmodule]
  M --> TT[Timetable / attendance
r_stdattendance*]
  M --> MARK[Lecturer / IH marks]
  MARK --> RR[Release results]
  RR --> TR[Transcripts / certs
r_studentcert_cambodia]
          

flowchart TD
  FEE[Fee catalog / setup] --> INV[Invoices / instalments
b_*]
  INV --> PAY[Payments / receipts]
  PAY --> STMT[Statements / ageing views]
  INV --> ASSIST[Assist programmes
r_assistscheme* · b_assistbilling*]
  ASSIST --> PROV[AssistProviderCode
Limkokwing]
  PROV -.-> REP[[rep_scholarship]]
          

sequenceDiagram
  participant REG as Registry qrcode_gen.php
  participant QR as qr.limkokwing.net
  participant VER as verification.limkokwing.net
  participant PUB as Certificate PNG

  REG->>REG: short_code KHM-PNH_StdProgramID
  REG->>REG: AES token from StdProgramID
  REG->>QR: POST /api/create_qrcode_api
  Note over REG,QR: name · LUCT · Certificate · short_code · verify URL
  QR-->>REG: JSON Qrcode base64 PNG
  REG->>PUB: StudentID_ProgramCode.png
  Note over VER: Public scan target
/cambodia/token
          

Create API: https://qr.limkokwing.net/api/create_qrcode_api (older scripts also use qrcode.limkokwing.net). Verify: https://verification.limkokwing.net/cambodia/…. Full pack inventory: certificate-qr.html (QR SaaS CI4 + qrcode.sql; Verification → GetStudentCertInfo).

sequenceDiagram
  participant Cron as cambodiabatchnight.sh
  participant SQL as batch SQL files
  participant SoR as campus2_cambodia
  participant Portal as portalcambodia

  Cron->>SQL: Run portal / registry / bursary / exam / transcript
  SQL->>SoR: Read operational slices
  SQL->>Portal: Dump / refresh *_cam / *_cambodia projections
  Note over Cron: Credentials in night script — not documented here
          

erDiagram
  r_student {
    int SIdx PK
    int StudentID UK
    string StudentNo
  }
  r_stdpersonal {
    int StudentID PK
  }
  r_stdprogram {
    int StdProgramID PK
    int SIdx FK
    int ProgramID FK
  }
  r_stdsemester {
    int StdSemesterID PK
    int StdProgramID FK
    int TermID FK
  }
  r_stdmodule {
    int StdModuleID PK
    int StdSemesterID FK
    int ModuleID FK
  }
  f_program {
    int ProgramID PK
    string ProgramCode
  }
  portal_student_cambodia {
    int StudentID
  }
  r_studentcert_cambodia {
    int StudentID
  }
  r_student ||--|| r_stdpersonal : StudentID
  r_student ||--o{ r_stdprogram : SIdx
  r_stdprogram ||--o{ r_stdsemester : StdProgramID
  r_stdsemester ||--o{ r_stdmodule : StdSemesterID
  r_stdprogram }o--|| f_program : ProgramID
  r_student ||--o| portal_student_cambodia : projects
  r_student ||--o{ r_studentcert_cambodia : certs
          

erDiagram
  app_applicationform {
    int ApplicationID PK
  }
  app_applicationformonline {
    int ApplicationID PK
  }
  app_applicationeducation {
    int ApplicationID FK
  }
  app_docfile {
    int DocFileID PK
    int ApplicationID FK
  }
  r_stdofferletter {
    int StudentID FK
  }
  r_student {
    int SIdx PK
    int StudentID UK
  }
  app_applicationform ||--o| app_applicationformonline : online
  app_applicationform ||--o{ app_applicationeducation : education
  app_applicationform ||--o{ app_docfile : docs
  app_applicationform ||--o| r_student : enrols
  r_student ||--o{ r_stdofferletter : StudentID
          

erDiagram
  r_assistprovider {
    int AssistProviderID PK
    string AssistProviderCode
  }
  r_assistscheme {
    int AssistSchemeID PK
    int AssistProviderID FK
  }
  r_assistschemedetail {
    int AssistSchemeID FK
  }
  b_assistbilling {
    int AssistBillingID PK
  }
  b_assistbillingdetail {
    int AssistBillingID FK
  }
  rep_scholarship {
    string ScholarshipKey
  }
  r_assistprovider ||--o{ r_assistscheme : AssistProviderID
  r_assistscheme ||--o{ r_assistschemedetail : AssistSchemeID
  b_assistbilling ||--o{ b_assistbillingdetail : AssistBillingID
  r_assistprovider -.-> rep_scholarship : reported_via
          

erDiagram
  r_student {
    int SIdx PK
    int StudentID UK
  }
  w_application {
    int ApplicationID PK
    int StudentID FK
  }
  w_insurance {
    int StdInsuranceID PK
    int StudentID FK
  }
  w_insuranceclaim {
    int InsuranceClaimID PK
    int StdInsuranceID FK
  }
  w_dorm {
    int DormID PK
  }
  w_room {
    int RoomID PK
    int DormID FK
  }
  w_occupant {
    int OccupantID PK
    int RoomID FK
    int StudentID FK
  }
  w_charges {
    int ChargeID PK
    int OccupantID FK
  }
  r_student ||--o{ w_application : StudentID
  r_student ||--o{ w_insurance : StudentID
  w_insurance ||--o{ w_insuranceclaim : StdInsuranceID
  w_dorm ||--o{ w_room : DormID
  w_room ||--o{ w_occupant : RoomID
  r_student ||--o{ w_occupant : StudentID
  w_occupant ||--o{ w_charges : OccupantID
          

flowchart TB
  APPLICANT([Applicant / agent])
  STUDENT([Student])
  LECTURER([Lecturer])
  STAFF([Registry · Faculty · Bursary · Services])
  PORTDB([portalcambodia])
  CMS[["Cambodia CMS
PHPMaker desks + campus2_cambodia"]]

  APPLICANT -->|application / docs| CMS
  STAFF -->|operational writes| CMS
  LECTURER -->|marks / attendance| CMS
  CMS -->|invoices / letters / portal data| STUDENT
  CMS -->|nightly batch dumps| PORTDB
          

flowchart LR
  EXT([Applicant]) --> MKT[Marketing desk]
  MKT --> APP[(app_applicationform*)]
  APP --> REG[Registry desk]
  REG --> OFF[(r_stdofferletter)]
  REG --> STU[(r_student / r_stdprogram)]
  STU --> FAC[Faculty structures]
  STU --> BUR[Bursary fee plan]
          

flowchart LR
  SET[Setup / Faculty
term · f_program*] --> ENR[(r_stdmodule)]
  ENR --> TT[Timetable / attendance]
  ENR --> LEC[Lecturer / IH marks]
  LEC --> RES[(results / transcript)]
  RES --> CERT[(r_studentcert_cambodia)]
  RES --> REP[Reporting]
          

flowchart TB
  STU[(r_student)] --> BUR[Bursary desk]
  BUR --> LED[(b_* / b_assistbilling*)]
  LED --> SCH[[rep_scholarship]]
  STU --> SCHEME[(r_assistscheme*)]
  SCHEME --> LED
  BATCH[[cambodiabatch bursary.sql]] -.-> LED
          

flowchart LR
  BATCH[[cambodiabatch
portal · registry · bursary · exam · transcript]] --> DB[(campus2_cambodia)]
  BATCH --> PDB[(portalcambodia
*_cam / *_cambodia)]
  DB --> API[["api_student_* / api_faculty_*"]]
  DB --> PORT[(portal_student_*_cambodia)]
  API -.-> EXT([Future Portal API / M5])
  PORT -.-> EXT
  PDB -.-> EXT
          

flowchart TB
  subgraph KH["LUCT Cambodia CMS"]
    DESKS[Marketing · Registry · Faculty · Bursary
Lecturer · Services · Accommodation · Setup · Reporting]
    DB[("campus2_cambodia")]
    PDB[("portalcambodia")]
    DESKS --> DB
    BATCH[cambodiabatch] --> DB
    BATCH --> PDB
  end
  subgraph Raisd["Raisd — M5+"]
    API[Portal API / ACL]
    AP[Applicant]
    SP[Student]
    LP[Lecturer]
    ST[Staff]
    AP --> API
    SP --> API
    LP --> API
    ST --> API
    API -.->|"CAP-53 CAMBODIA"| DB
  end
          

flowchart TB
  FAMILY["LUCT / ICA EMS family
PHPMaker · r_/f_/b_"]
  CYB["Cyberjaya · cmscbj"]
  LS["Lesotho · campus2_lesotho · M4"]
  BWA["Botswana · cmsbotswana · DTEF"]
  SZ["Eswatini · campus2_eswatini · ssb"]
  KH["Cambodia · campus2_cambodia · Assist"]
  SLE["Sierra Leone · ems_sierraleone · ac_*"]
  RAISD["Raisd portals · CAP-53"]

  FAMILY --> CYB
  FAMILY --> LS
  FAMILY --> BWA
  FAMILY --> SZ
  FAMILY --> KH
  FAMILY --> SLE
  LS ==>|M4 acceptance| RAISD
  CYB -.->|depth reference| RAISD
  BWA -.->|M5| RAISD
  SZ -.->|M5| RAISD
  KH -.->|M5| RAISD
  SLE -.->|M5| RAISD