prepare("SELECT * FROM sms_teachers WHERE teacher_id = ? LIMIT 1");
$stmt->execute([$teacherId]);
$teacher = $stmt->fetch(PDO::FETCH_ASSOC);
$teacherName = $teacher['full_name'] ?? 'Teacher';
$empCode = $teacher['employee_code'] ?? '-';
$photo = !empty($teacher['photo'])
? "/ims/sms/uploads/teachers/" . $teacher['photo']
: "https://ui-avatars.com/api/?name=" .
urlencode($teacherName) . "&background=0ea5e9&color=fff";
$_SESSION['teacher_name'] = $teacherName;
$_SESSION['employee_code'] = $empCode;
$_SESSION['teacher_photo'] = $teacher['photo'] ?? '';
/* ═══════════════════════════════════════════════════════════
Source of truth: sms_timetable stores subject_name / teacher_name
as plain text (no FK ids), so we match on the teacher's full name.
This single query also identifies which classes + subjects
this teacher is actually teaching (independent of class_teacher_id,
which only tells us who the CLASS TEACHER is, not subject allocation).
═══════════════════════════════════════════════════════════ */
$allocStmt = $pdo->prepare("
SELECT
t.class_id,
c.class_name,
c.section,
t.subject_name,
COUNT(*) AS periods_per_week
FROM sms_timetable t
JOIN sms_classes c ON c.class_id = t.class_id
WHERE t.school_id = ?
AND t.teacher_name = ?
AND t.is_break = 0
AND t.status = 'ACTIVE'
AND c.status = 'ACTIVE'
GROUP BY t.class_id, t.subject_name
ORDER BY c.class_name, c.section, t.subject_name
");
$allocStmt->execute([$_SESSION['school_id'], $teacherName]);
$rows = $allocStmt->fetchAll(PDO::FETCH_ASSOC);
/* ─── Cross-reference sms_subjects for subject_code (best-effort match on class_id + name) ─── */
$subjCodeMap = [];
if (!empty($rows)) {
$subjStmt = $pdo->prepare("
SELECT class_id, subject_name, subject_code
FROM sms_subjects
WHERE school_id = ? AND status = 'ACTIVE'
");
$subjStmt->execute([$_SESSION['school_id']]);
foreach ($subjStmt->fetchAll(PDO::FETCH_ASSOC) as $s) {
$subjCodeMap[$s['class_id'] . '|' . strtolower(trim($s['subject_name']))] = $s['subject_code'];
}
}
/* ─── Group rows by class ─── */
$byClass = [];
foreach ($rows as $r) {
$cid = $r['class_id'];
if (!isset($byClass[$cid])) {
$byClass[$cid] = [
'class_name' => $r['class_name'],
'section' => $r['section'],
'subjects' => [],
];
}
$key = $cid . '|' . strtolower(trim($r['subject_name']));
$code = $subjCodeMap[$key] ?? null;
$byClass[$cid]['subjects'][] = [
'subject_name' => $r['subject_name'],
'subject_code' => $code,
'periods_per_week' => (int) $r['periods_per_week'],
];
}
$totalClassesTeaching = count($byClass);
$totalSubjectSlots = array_sum(array_map(fn($c) => count($c['subjects']), $byClass));
$totalPeriodsWeek = array_sum(array_column($rows, 'periods_per_week'));
/* ─── Also flag classes where this teacher is the CLASS TEACHER (from sms_classes) ─── */
$ctStmt = $pdo->prepare("
SELECT class_id FROM sms_classes
WHERE class_teacher_id = ? AND school_id = ? AND status = 'ACTIVE'
");
$ctStmt->execute([$teacherId, $_SESSION['school_id']]);
$classTeacherOf = array_column($ctStmt->fetchAll(PDO::FETCH_ASSOC), 'class_id');
include("includes/header.php");
?>
My Subjects
Subjects and classes allocated to you,
🏫
Classes I Teach
📚
Subject Allocations
🗓️
Periods / Week
📚 My Subject Allocation
Based on your timetable allocation across classes
No subject allocations found yet. Once the school office adds you to the timetable, your subjects will appear here.