<?php
// This file runs automatically via AJAX every minute
session_start();

if (!isset($_SESSION['admin_id'])) {
    http_response_code(401);
    exit;
}

require_once '../config/config.php';
require_once '../config/db.php';

header('Content-Type: application/json');

try {
    // Auto-update tasks that passed deadline to "On Hold"
    $update_query = "UPDATE tbl_tasks 
                     SET status = 'On Hold', 
                         updated_at = NOW() 
                     WHERE deadline_date < CURDATE() 
                     AND status NOT IN ('Completed', 'On Hold')";
    
    mysqli_query($con, $update_query);
    
    $affected_rows = mysqli_affected_rows($con);
    
    echo json_encode([
        'success' => true,
        'updated_count' => $affected_rows,
        'timestamp' => date('Y-m-d H:i:s')
    ]);
    
} catch (Exception $e) {
    echo json_encode([
        'success' => false,
        'message' => $e->getMessage()
    ]);
}
?>