| Cursus | Voortgang | Status | Deadline | Actie |
|---|---|---|---|---|
| Geen trainingen toegewezen | ||||
| Certificaat | Score | Datum | Ref |
|---|---|---|---|
| {c["title"]} | {c["quiz_score"]}% | {c["passed"]} | {c["certificate_ref"]} |
| Nog geen certificaten | |||
| Cursus | Categorie | Voortgang | Status | Deadline | Actie |
|---|---|---|---|---|---|
| Geen trainingen | |||||
| Training | Score | Status | Referentie |
|---|---|---|---|
| Nog geen certificaten behaald | |||
Cursus niet gevonden.
', 'courses') content = conn.execute("SELECT * FROM lms_course_content WHERE elearning_module_id=? ORDER BY display_order", (module_id,)).fetchall() enrollment = conn.execute("SELECT * FROM lms_enrollments WHERE employee_id=? AND elearning_module_id=?", (emp_id, module_id)).fetchone() # Auto-create enrollment if missing if not enrollment: conn.execute("INSERT OR IGNORE INTO lms_enrollments (employee_id, elearning_module_id, status) VALUES (?,?, 'not_started')", (emp_id, module_id)) conn.commit() enrollment = conn.execute("SELECT * FROM lms_enrollments WHERE employee_id=? AND elearning_module_id=?", (emp_id, module_id)).fetchone() # Mark as in_progress if enrollment and enrollment['status'] == 'not_started': conn.execute("UPDATE lms_enrollments SET status='in_progress', started_at=datetime('now'), last_accessed_at=datetime('now') WHERE id=?", (enrollment['id'],)) conn.commit() # Update last accessed if enrollment: conn.execute("UPDATE lms_enrollments SET last_accessed_at=datetime('now') WHERE id=?", (enrollment['id'],)) conn.commit() finally: conn.close() # Build content tabs content_tabs = "" iframe_src = "" for i, c in enumerate(content): active = 'btn-primary' if i == 0 else 'btn-sm' fname = c['file_name'] or os.path.basename(c['file_path']) content_tabs += f'{fname}\n' if i == 0: iframe_src = f"{BASE_PATH}/lms/serve-content/{c['id']}" # If no linked content, check if module has content_html if not content and module['content_html']: iframe_src = f"{BASE_PATH}/lms/serve-content-inline/{module_id}" content_tabs = 'Inline content' pct = enrollment['progress_percent'] or 0 if enrollment else 0 quiz_url = f"{BASE_PATH}/lms/course/{module_id}/quiz" complete_url = f"{BASE_PATH}/lms/course/{module_id}/complete" body = f"""Content niet gevonden.
", 404 fpath = c['file_path'] if os.path.exists(fpath): with open(fpath, 'r', encoding='utf-8') as f: return f.read() return f"Bestand niet gevonden op server: {fpath}
", 404 @lms_bp.route('/serve-content-inline/Geen content beschikbaar.
", 404 @lms_bp.route('/course/Module niet gevonden.
', 'courses') # Try loading quiz questions from module questions = [] if module['quiz_questions']: try: questions = json.loads(module['quiz_questions']) except (json.JSONDecodeError, TypeError): pass # Check if there's a linked quiz HTML file conn = get_db() try: quiz_content = conn.execute("SELECT * FROM lms_course_content WHERE elearning_module_id=? AND file_name LIKE '%quiz%'", (module_id,)).fetchone() finally: conn.close() if quiz_content and os.path.exists(quiz_content['file_path']): # Serve external quiz HTML in iframe quiz_src = f"{BASE_PATH}/lms/serve-content/{quiz_content['id']}" body = f"""De quiz wordt automatisch nagekeken. Resultaat wordt opgeslagen na afronding.
""" return _page(f'Quiz: {module["title"]}', body, 'courses') # Built-in quiz rendering from quiz_questions JSON if not questions: body = f"""Geen quiz beschikbaar voor deze module.
Terug naar cursus{i+1}. {q.get("question","")}
{opts}| ID | Titel | Categorie | Status | Inschrijvingen | Gem. Score | Slagings% | Acties |
|---|---|---|---|---|---|---|---|
| Geen cursussen | |||||||
| ID | Type | Bestand | Pad | Primair |
|---|---|---|---|---|
| Geen content gekoppeld | ||||
| Medew. | Naam | Cursus | Status | Score | Deadline | Actie |
|---|---|---|---|---|---|---|
| Geen inschrijvingen | ||||||
| Medewerker | Functie | {mod_headers}
|---|
✅ Actief ⚠️ Vervalt binnen 30 dagen ❌ Verlopen/Ontbreekt — Niet verplicht
""" return _page('Compliance', body, 'admin-compliance') @lms_bp.route('/admin/compliance/matrix') def admin_compliance_matrix(): return redirect(f"{BASE_PATH}/lms/admin/compliance") @lms_bp.route('/admin/compliance/expired') def admin_compliance_expired(): conn = get_db() try: expired = conn.execute(""" SELECT e.first_name, e.last_name, e.employee_number, m.title, enr.completed_at, cr.valid_period_days, date(enr.completed_at, '+' || cr.valid_period_days || ' days') as expiry_date FROM lms_enrollments enr JOIN employees e ON e.id=enr.employee_id JOIN elearning_modules m ON m.id=enr.elearning_module_id LEFT JOIN lms_compliance_rules cr ON cr.elearning_module_id=enr.elearning_module_id WHERE enr.final_passed=1 AND cr.is_mandatory=1 AND date(enr.completed_at, '+' || cr.valid_period_days || ' days') < date('now') ORDER BY expiry_date """).fetchall() finally: conn.close() rows = "".join(f"""| Nr | Naam | Training | Status | Vervaldatum |
|---|---|---|---|---|
| Geen verlopen trainingen | ||||
| Nr | Naam | Training | Status | Vervaldatum |
|---|---|---|---|---|
| Geen nakomende vervallen | ||||
| Cursus | Inschrijvingen | Voltooid | Completion | Gem. Score | Details |
|---|---|---|---|---|---|
| Geen data | |||||
| Nr | Naam | Status | Score | Voortgang |
|---|---|---|---|---|
| Geen inschrijvingen | ||||
| Medewerker | Poging | Score | Correct | Resultaat | Datum |
|---|---|---|---|---|---|
| Geen quiz-resultaten | |||||
| Training | Status | Voortgang | Score |
|---|---|---|---|
| Geen trainingen | |||
| Training | Score | Referentie |
|---|---|---|
| Geen certificaten | ||