process-return.php

<?php
// ✅ process-return.php
// Serial no se student ko returned mark karta hai extended_logs mein

if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

require_once 'db_connect.php';

if (!isset($_SESSION['staff_user'])) {
    header('Location: login.php');
    exit();
}

if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    header('Location: manual-return-entry.php');
    exit();
}

$serial_no = strtoupper(trim($_POST['serial_no'] ?? ''));

if (empty($serial_no)) {
    $_SESSION['error'] = 'Serial number enter karein.';
    header('Location: manual-return-entry.php');
    exit();
}

// ── Record dhundo ─────────────────────────────────────────────
$stmt = mysqli_prepare($conn, "SELECT * FROM extended_logs WHERE serial_no = ? LIMIT 1");
mysqli_stmt_bind_param($stmt, 's', $serial_no);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
$record = mysqli_fetch_assoc($result);
mysqli_stmt_close($stmt);

if (!$record) {
    $_SESSION['error'] = "Serial no '$serial_no' nahi mila. Check karein.";
    header('Location: manual-return-entry.php');
    exit();
}

if ($record['status'] === 'Returned') {
    $_SESSION['error'] = "$serial_no pehle se Returned mark hai. (Return time: " 
        . ($record['in_time'] ?? 'N/A') . ")";
    header('Location: manual-return-entry.php');
    exit();
}

// ── Update in_time and in_date ──────────────────────────
$now_time = date('H:i:s');
$now_date = date('Y-m-d');

$upd = mysqli_prepare($conn,
    "UPDATE extended_logs SET status='Returned', in_time=?, in_date=? WHERE id=?"
);
mysqli_stmt_bind_param($upd, 'ssi', $now_time, $now_date, $record['id']);
$ok = mysqli_stmt_execute($upd);
mysqli_stmt_close($upd);

if (!$ok) {
    $_SESSION['error'] = 'Update failed. Please try again.';
    header('Location: manual-return-entry.php');
    exit();
}

// ── Success: confirmation page dikhao ────────────────────────
$_SESSION['return_success'] = [
    'serial_no'    => $serial_no,
    'student_name' => $record['student_name'],
    'roll_no'      => $record['roll_no'],
    'out_date'     => $record['out_date'],
    'out_time'     => $record['out_time'],
    'in_time'      => $now_time,
    'in_date'      => $now_date,
    'pass_type'    => $record['pass_type'],
];

header('Location: return-confirmed.php');
exit();
?>