SMS · UC-SMS-12

UC-SMS-12 — Bao cao / in an SMS

Bao cao / in an SMS based on legacy SMS source. This UC assumes `SDMSV`/`SSVHK` hub data already exists and does not require QLTS runtime.

Nguồn: docs/modules/sms/use-cases/UC-SMS-12.md · Sample data (fake VN)

S1 · Legacy `SBB/Report/UCT`; remake report catalog

Legacy SBB/Report/UCT; remake report catalog

Load report list and available export actions.

termCodeNHHKkeywordreportId

API: `GET /reports`. · DB:

`HReport.IDHReport`, `IDReport`, `IDSubReport`, `MergeHoTen`, `DoCaoChiTiet`; source read models must only read domain tables, not mutate them.

S2 · Student/profile roster report

Student/profile roster report

Export list-style SMS report from student hub.

reportIdtermCodeclassIdstudentIdskeywordHienDienSVpdf/xlsx/docx dryRun

API: `POST /reports/{reportId}/export`. · DB:

`SDMSV.IDSV`, `MaSV`, `HoLotSV`, `TenSV`, `TenDayDu`, `IDLop`, `HienDienSV2`; `SSVHK.IDSVHK`, `NHHK`, `IDSV`, `IDLop`, `HienDienSV`, `GCSVHKDiemDanh`.

S3 · Conduct/certificate/scholarship/insurance reports

Conduct/certificate/scholarship/insurance reports

Export reports backed by already-smoked UC data.

reportIdtermCodestudentIdsIDGCNIDKHHBHKIDDotBHSV

API: `POST /reports/{reportId}/export`. · DB:

Conduct: `SDRLHK.IDSV`, `NHHK`, `DiemRLHK`, `DiemQuiDoi`; certificate: `SGCNSV.IDGCNSV`, `IDSV`, `NHHK`, `IDGCN`, `SOCNSV`, `TrangThaiGCNSV`; scholarship: `SDSH

S4 · GAP - print template registry

GAP - print template registry

Current docs list `HReport` columns but do not map each `reportId` to title, template file, parameters, output fields, or Crystal/DevExpress layout.

keywordtermCode

Mã	Họ tên	Lớp/Ngành	Trạng thái	Ghi chú
SV22010001	Nguyễn Văn An	CNTT-K18-01	Đang học	QĐ/2025/810
SV22010015	Trần Thị Bình	CNTT-K18-02	Tạm dừng	QĐ/2025/811
SV22010028	Lê Minh Châu	KT-K18-01	Đang học	QĐ/2025/812
SV22010042	Phạm Quốc Dũng	QTKD-K18-01	Nghỉ luôn	QĐ/2025/813
SV22010057	Hoàng Thu Hà	NN-K18-03	Đang học	QĐ/2025/814
SV22010063	Vũ Đức Khoa	CNTT-K18-01	Tốt nghiệp	QĐ/2025/815

API: `GET /reports`, `POST /reports/{reportId}/export`. · DB: `HReport.IDReport`, `IDSubReport`; add template registry and parameter map before full report smoke.