Portal / SMS / UC-SMS-04
NHHK 2024–2025 HK1 Cán bộ demo
SMS · UC-SMS-04

UC-SMS-04 — Diem ren luyen

Diem ren luyen 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-04.md · Sample data (fake VN)
S1 · Legacy `S8`; remake conduct score list

Legacy S8; remake conduct score list

Load conduct scores by term/student/class and compare totals.

termCodeNHHKkeywordstudentIdsDiemRLHKDiemRLHKTL
SV22010001Nguyễn Văn AnCNTT-K18-01Đang họcQĐ/2025/810Mẫu-1
SV22010015Trần Thị BìnhCNTT-K18-02Tạm dừngQĐ/2025/811Mẫu-2
SV22010028Lê Minh ChâuKT-K18-01Đang họcQĐ/2025/812Mẫu-3
SV22010042Phạm Quốc DũngQTKD-K18-01Nghỉ luônQĐ/2025/813Mẫu-4
SV22010057Hoàng Thu HàNN-K18-03Đang họcQĐ/2025/814Mẫu-5
SV22010063Vũ Đức KhoaCNTT-K18-01Tốt nghiệpQĐ/2025/815Mẫu-6
API: `GET /conduct-scores`. · DB: `SDRLHK.IDDRLHK`, `NHHK`, `IDSV`, `DiemRLHK`, `DiemRLHKTL`, `DiemQuiDoi`, `IDDGCT`, `GCDRLHK`; `SDRLNH.IDSV`, `NamHoc`, `NHHK`, `DiemRLNH`; `SDRLTK.IDSV`, `Diem
S2 · Legacy import/save DGRL; remake import dialog

Legacy import/save DGRL; remake import dialog

Import semester conduct scores with dry-run validation.

API: `POST /conduct-scores/import`. · DB: `SDRLHK.NHHK`, `IDSV`, `DiemRLHK`, `DiemQuiDoi`, `IDDGCT`, `NgayThem`, `MaUser`; optional `SDTPRLHK.NHHK`, `IDSV`, `IDTPRL`, `DiemTPRLHK`.
S3 · Legacy `TongHopRenLuyenHK/NH`; remake aggregate action

Legacy TongHopRenLuyenHK/NH; remake aggregate action

Aggregate semester/year/whole-course conduct scores.

API: `POST /conduct-scores/aggregate`. · DB: Source `SDRLHK`; target `SDRLNH.IDSV`, `NamHoc`, `NHHK`, `DiemRLNH`; `SDRLTK.IDSV`, `DiemRLTK`, `DiemQuiDoi`, `IsTongKet`.
S4 · Legacy online DGRL sync; remake lock/online review panel

Legacy online DGRL sync; remake lock/online review panel

Review online self/CVHT/khoa/truong evaluation and lock/unlock scope.

API: `PUT /conduct-scores/locks`. · DB: `SKetQuaDGRL.IDKetQuaDGRL`, `IDSV`, `NHHK`, `TongDiemSV`, `TongDiemCVHT`, `TongDiemKHOA`, `TongDiemTruong`, `Ngay*DanhGia`; `SKetQuaDGRLCT.IDKetQuaDGRL`, `IDCau
S5 · GAP - exact xep loai/lock enum

GAP - exact xep loai/lock enum

Current docs expose score columns but not the full legacy grade category and lock-state enum mapping.

MãHọ tênLớp/NgànhTrạng tháiGhi chú
SV22010001Nguyễn Văn AnCNTT-K18-01Đang họcQĐ/2025/810
SV22010015Trần Thị BìnhCNTT-K18-02Tạm dừngQĐ/2025/811
SV22010028Lê Minh ChâuKT-K18-01Đang họcQĐ/2025/812
SV22010042Phạm Quốc DũngQTKD-K18-01Nghỉ luônQĐ/2025/813
SV22010057Hoàng Thu HàNN-K18-03Đang họcQĐ/2025/814
SV22010063Vũ Đức KhoaCNTT-K18-01Tốt nghiệpQĐ/2025/815
API: `GET /conduct-scores`, `PUT /conduct-scores/locks`. · DB: Add enum map around `IDDGCT`, `IDDGCTTL`, and any lock columns before full parity.