<?php
require_once __DIR__ . '/../../connect.php';

$driverID = filterRequest("driverID");

$sql = "SELECT * FROM `notificationCaptain`
        WHERE (`driverID` = :driverID OR `driverID` = 'all')
        AND `dateCreated` > DATE_SUB(NOW(), INTERVAL 7 DAY)
        ORDER BY `dateCreated` DESC
        LIMIT 50";

$stmt = $con->prepare($sql);
$stmt->bindParam(':driverID', $driverID, PDO::PARAM_STR);
$stmt->execute();

$notifications = $stmt->fetchAll(PDO::FETCH_ASSOC);

if ($notifications) {
    jsonSuccess($notifications);
} else {
    jsonError("No notification data found");
}
?>