query("SELECT * FROM admit_card WHERE id = '$id'");
$enrollment_no = 0;
if($admit->num_rows){
$a = $admit->fetch_assoc();
$enrollment_no = $a['enrollment_no'];
}
$stu = $con->query("SELECT * FROM students WHERE enrollment_no = '$enrollment_no'");
if ($stu->num_rows > 0 && $admit->num_rows > 0) {
$s = $stu->fetch_assoc();
$c = $con->query("SELECT * FROM centers WHERE id = '".$s['center_id']."'")->fetch_assoc();
$course = $con->query("SELECT * FROM courses WHERE id = '".$s['course_id']."'")->fetch_assoc();
$all_subjects = $con->query("SELECT * FROM subjects WHERE course_id = '".$s['course_id']."' and duration = '".$a['duration']."' and duration_type = '".$a['duration_type']."' ORDER BY is_optional ASC, subject_name ASC");
$subjectsDetails = json_decode($a['subjects'], true);
$selectedSubjects = [];
$selectedSubjectIds = [];
if (!empty($subjectsDetails) && is_array($subjectsDetails)) {
foreach ($subjectsDetails as $sub_id => $sub_data) {
if (isset($sub_data['selected']) && $sub_data['selected'] == '1') {
$selectedSubjectIds[] = $sub_id;
}
}
}
if (empty($selectedSubjectIds)) {
if ($all_subjects && $all_subjects->num_rows > 0) {
$all_subjects->data_seek(0);
$foundOptional = false;
while ($sub = $all_subjects->fetch_assoc()) {
if ($sub['is_optional'] == 0) {
$selectedSubjects[] = $sub;
} else if (!$foundOptional) {
$selectedSubjects[] = $sub;
$foundOptional = true;
}
}
}
} else {
if ($all_subjects && $all_subjects->num_rows > 0) {
$all_subjects->data_seek(0);
while ($sub = $all_subjects->fetch_assoc()) {
if (in_array($sub['id'], $selectedSubjectIds)) {
$selectedSubjects[] = $sub;
}
}
}
}
// --- DETAILS PREPARATION ---
$bg = 'format/admit.jpg';
$photo = 'uploads/students/'.$s['photo'];
// Yahan signature ka path set kiya gaya hai (Folder path check kar lein)
$sign = 'uploads/signatures/'.$s['signature'];
$name = $s['name'];
$father = $s['father'];
$dob = $s['dob'];
$enroll_no = $s['enrollment_no'];
$course_name = isset($course['course_name']) ? $course['course_name'] : 'N/A';
$exam_date = $a['exam_date'];
$exam_time = $a['exam_time'];
$exam_center = $a['exam_center'];
$center_code = isset($c['center_number']) ? $c['center_number'] : '';
$session = $a['session'];
$subjectsDetails = $selectedSubjects;
include 'admit_card.php';
exit;
} else {
echo '';
}
}
?>