✏ EDIT: clear_notifications.php

<?php
// Endpoint to mark all notifications as viewed for the admin panel.  After
// invoking this script, the dashboard will no longer show any unread
// notifications until new records are added to the monitored tables.
session_start();
require_once __DIR__ . '/../includes/config.php';

header('Content-Type: application/json');
// Prevent caching to ensure changes propagate immediately
header('Cache-Control: no-cache, must-revalidate');
header('Expires: 0');

// Ensure only authenticated administrators can perform this action
if (empty($_SESSION['admin_user'])) {
    echo json_encode(['error' => 'Unauthorized']);
    exit;
}

// Define the database tables that support notification viewing
$tables = [
    'appointments',
    'service_bookings',
    'parts_bookings',
    'enquiries'
];

// For each table, if an `is_viewed` column exists, mark all unseen entries as viewed
foreach ($tables as $table) {
    // Check if the table exists
    $checkRes = $conn->query("SHOW TABLES LIKE '$table'");
    if ($checkRes && $checkRes->num_rows > 0) {
        // Check if the table has an is_viewed column
        $colRes = $conn->query("SHOW COLUMNS FROM `$table` LIKE 'is_viewed'");
        if ($colRes && $colRes->num_rows > 0) {
            // Update all rows where is_viewed is 0 or NULL
            $conn->query("UPDATE `$table` SET is_viewed = 1 WHERE is_viewed = 0 OR is_viewed IS NULL");
        }
    }
}

// Return a simple success message
echo json_encode(['status' => 'cleared']);
exit;

[✗] CANCEL