Changes between Version 1 and Version 2 of IssuingCertificate

Timestamp:

01/22/26 03:52:58 (15 hours ago)

Author:

221296

Comment:

--

IssuingCertificate

@@ -3 +3 @@
 ==== Actors: **System (automatic)**
 
-**1.** The user successfully completes the course.
+**1.** Course Completion Verification.
 
-**2.** The system generates and stores a certificate.
+{{{#!sql
+UPDATE enrollment
+SET completion_status = 'COMPLETED',
+    progress_percentage = 100
+WHERE enrollment_id = :enrollmentId;
+
+}}}
+
+
+**2.** Certificate Generation.
 
 {{{#!sql
 INSERT INTO certificate (enrollment_id, issue_date, certificate_code, status)
-VALUES (1, CURRENT_DATE, 'CERT-2026-0001', 'ISSUED');
+VALUES (
+    :enrollmentId,
+    CURRENT_DATE,
+    :certificateCode,
+    'ISSUED'
+);