???????????????????? ?????????????????? ÿØÿà JFIF    ÿÛ C    !"$"$ÿÛ C  ÿ p " ÿÄ     ÿÄ   ÿÚ   ÕÔË® (% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤  @ adadasdasdasasdasdas .....................................................................................................................................???????????????????? ?????????????????? ÿØÿà JFIF    ÿÛ C    !"$"$ÿÛ C  ÿ p " ÿÄ     ÿÄ   ÿÚ   ÕÔË® (% aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥ BQ¤¢ X«)X…€¤  @ adadasdasdasasdasdas .....................................................................................................................................beginTransaction(); try { $st = $pdo->prepare("SELECT sa.assignment_id, sa.student_id, sa.started_at, sa.total_possible, a.duration_minutes FROM student_attempts sa JOIN assignments a ON a.id = sa.assignment_id WHERE sa.id = ? FOR UPDATE"); $st->execute([$attempt_id]); $attempt = $st->fetch(PDO::FETCH_ASSOC); if (!$attempt) { $pdo->rollBack(); return ['error' => 'Attempt not found']; } $assignment_id = intval($attempt['assignment_id']); $q = $pdo->prepare(" SELECT q.id AS question_id, q.weight, (SELECT id FROM options WHERE question_id = q.id AND is_correct = 1 LIMIT 1) AS correct_option_id FROM questions q WHERE q.assignment_id = ? "); $q->execute([$assignment_id]); $questions = $q->fetchAll(PDO::FETCH_ASSOC); $aStmt = $pdo->prepare("SELECT question_id, selected_option_id FROM attempt_answers WHERE attempt_id = ?"); $aStmt->execute([$attempt_id]); $answers = []; foreach ($aStmt->fetchAll(PDO::FETCH_ASSOC) as $r) { $answers[$r['question_id']] = $r['selected_option_id']; } $total_obtained = 0.0; foreach ($questions as $ques) { $qid = intval($ques['question_id']); $weight = floatval($ques['weight']); $correct_opt = $ques['correct_option_id'] !== null ? intval($ques['correct_option_id']) : null; $selected = $answers[$qid] ?? null; if ($selected !== null && $correct_opt !== null && intval($selected) === $correct_opt) { $total_obtained += $weight; $up = $pdo->prepare("UPDATE attempt_answers SET is_correct = 1, obtained_marks = ? WHERE attempt_id = ? AND question_id = ?"); $up->execute([$weight, $attempt_id, $qid]); } else { $up = $pdo->prepare("UPDATE attempt_answers SET is_correct = 0, obtained_marks = 0 WHERE attempt_id = ? AND question_id = ?"); $up->execute([$attempt_id, $qid]); } } $update = $pdo->prepare("UPDATE student_attempts SET total_obtained = ?, submitted_at = NOW(), status = ? WHERE id = ?"); $update->execute([$total_obtained, 'submitted', $attempt_id]); $pdo->commit(); return ['success' => true, 'total_obtained' => $total_obtained]; } catch (Exception $e) { if ($pdo->inTransaction()) $pdo->rollBack(); return ['error' => $e->getMessage()]; } } /* ---------- 1) Validate attempt belongs to student & in_progress ---------- */ $stmt = $pdo->prepare(" SELECT sa.*, a.start_datetime, a.end_datetime, a.duration_minutes, a.title AS assignment_title, a.result_visibility, a.status AS assignment_status, a.activation_mode FROM student_attempts sa JOIN assignments a ON a.id = sa.assignment_id WHERE sa.id = ? AND sa.student_id = ? "); $stmt->execute([$attempt_id, $student_id]); // $stmt->execute([$attempt_id]); $attempt = $stmt->fetch(PDO::FETCH_ASSOC); if (!$attempt) { die("Attempt not found."); } $now = new DateTime('now', $serverTz); $start = new DateTime($attempt['start_datetime'], $serverTz); $end = new DateTime($attempt['end_datetime'], $serverTz); // Assignment must be ACTIVE if ($attempt['assignment_status'] !== 'active') { die("Test is not active."); } // Start time must be reached if ($now < $start) { die("Test has not started yet."); } // End time must not be passed if ($now > $end) { die("Test has already ended."); } if (intval($attempt['student_id']) !== $student_id) { die("Unauthorized access to this attempt."); } if ($attempt['status'] !== 'in_progress') { header("Location: result_popup.php?attempt_id=" . $attempt_id); exit; } /* ---------- 2) Compute server-side allowed end time ---------- */ // Use the same server timezone everywhere to avoid flicker caused by UTC/IST mismatch $duration_minutes = intval($attempt['duration_minutes'] ?? 0); $started_at = new DateTime($attempt['started_at'], $serverTz); $allowed_end = clone $started_at; $allowed_end->modify("+{$duration_minutes} minutes"); // Also assignment global end cap $assignment_end = new DateTime($attempt['end_datetime'], $serverTz); // Effective end is min(allowed_end, assignment_end) $effective_end = ($allowed_end < $assignment_end) ? $allowed_end : $assignment_end; $now = new DateTime("now", $serverTz); if ($now > $effective_end) { $res = finalize_attempt_and_compute_marks($pdo, $attempt_id); if (isset($res['success'])) { $pdo->prepare("UPDATE student_attempts SET status = ? WHERE id = ?")->execute(['auto_submitted', $attempt_id]); } header("Location: result_popup.php?attempt_id=" . $attempt_id); exit; } /* ---------- 3) Load all questions + options for this assignment ---------- */ $assignment_id = intval($attempt['assignment_id']); $q = $pdo->prepare("SELECT id, question_text, weight, question_order FROM questions WHERE assignment_id = ? ORDER BY question_order ASC, id ASC"); $q->execute([$assignment_id]); $questions = $q->fetchAll(PDO::FETCH_ASSOC); // Load options for all questions in one query $question_ids = array_column($questions, 'id'); $options = []; if (!empty($question_ids)) { $in = str_repeat('?,', count($question_ids) - 1) . '?'; $optStmt = $pdo->prepare("SELECT id, question_id, option_text FROM options WHERE question_id IN ($in) ORDER BY id ASC"); $optStmt->execute($question_ids); foreach ($optStmt->fetchAll(PDO::FETCH_ASSOC) as $o) { $options[$o['question_id']][] = $o; } } // Load existing saved answers for this attempt $ansStmt = $pdo->prepare("SELECT question_id, selected_option_id FROM attempt_answers WHERE attempt_id = ?"); $ansStmt->execute([$attempt_id]); $savedAnswers = []; foreach ($ansStmt->fetchAll(PDO::FETCH_ASSOC) as $r) { $savedAnswers[intval($r['question_id'])] = $r['selected_option_id'] !== null ? intval($r['selected_option_id']) : null; } // Compute remaining seconds for client timer (use server time) /* Correct Remaining Seconds Calculation */ $server_now = new DateTime("now", $serverTz); $remaining_seconds = intval($effective_end->getTimestamp() - $server_now->getTimestamp()); if ($remaining_seconds < 0) $remaining_seconds = 0; /* ---------- Render page (HTML + embedded JSON for questions) ---------- */ ?> Test — <?= htmlspecialchars($attempt['assignment_title']) ?> — Attempt #<?= htmlspecialchars($attempt_id) ?>
Attempt # · Started at
--:--:--
Time Remaining
Tip: Your answers auto-save. Avoid switching tabs repeatedly.
You switched away — further switches may be recorded.