<?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.");
}

$data_res = $db->query("jobcards", "SELECT * FROM jobcards WHERE jc_no = $jc_no");
$data = $data_res->fetch_assoc();

$last_res = $db->query(
    "jobcard_timeline",
    "SELECT *
     FROM jobcard_timeline 
     WHERE jobcard_id = {$data['record_id']} 
     ORDER BY record_id DESC 
     LIMIT 1"
);
?>

<h2>LAST ACTION</h2>

<?php
if ($last_res->num_rows > 0) {
    $last = $last_res->fetch_assoc();
    ?>
    <p><strong><?= $last['type'] ?></strong></p>
    <p><?= $last['date_time'] ?></p>
    <?php
} else {
    ?>
    <p>No actions recorded.</p>
    <?php
}
?>