<?php
include "../../root.class.php";
$db = new db_safeguard();

$jc_no = isset($_GET['jc_no']) ? (int)$_GET['jc_no'] : 0;

if ($jc_no === 0) {
    exit("Invalid jobcard.");
}

$res = $db->query(
    "jobcard_timeline",
    "SELECT type, date_time 
     FROM jobcard_timeline 
     WHERE jobcard_id = $jc_no 
     ORDER BY record_id DESC 
     LIMIT 1"
);

$last = $res ? $res->fetch_assoc() : null;
?>

<h2>LAST ACTION</h2>

<?php if ($last) { ?>
    <p><strong><?= $last['type'] ?></strong></p>
    <p><?= $last['date_time'] ?></p>
<?php } else { ?>
    <p>No actions recorded.</p>
<?php } ?>
