Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/medical/admin

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: expiry-alerts.php

<!doctype html>
<html lang="en">

<?php 
include('includes/head.php');

// Database connection
include('includes/db_connection.php');

// Check if medicines table exists
$table_check = $conn->query("SHOW TABLES LIKE 'medicines'");
$medicines_table_exists = $table_check->num_rows > 0;

// Handle actions
if (isset($_GET['action']) && isset($_GET['id'])) {
    $medicine_id = (int)$_GET['id'];
    $action = $_GET['action'];
    
    if ($medicine_id > 0) {
        if ($action === 'deactivate') {
            $update_stmt = $conn->prepare("UPDATE medicines SET status = 'inactive' WHERE id = ?");
            $update_stmt->bind_param("i", $medicine_id);
            
            if ($update_stmt->execute()) {
                $success_message = "Medicine deactivated successfully!";
            } else {
                $error_message = "Error deactivating medicine: " . $conn->error;
            }
        } elseif ($action === 'delete') {
            // Check if medicine has stock before deletion
            $check_stmt = $conn->prepare("SELECT stock_quantity FROM medicines WHERE id = ?");
            $check_stmt->bind_param("i", $medicine_id);
            $check_stmt->execute();
            $result = $check_stmt->get_result();
            $medicine = $result->fetch_assoc();
            
            if ($medicine['stock_quantity'] > 0) {
                $error_message = "Cannot delete medicine with existing stock. Please deactivate instead.";
            } else {
                $delete_stmt = $conn->prepare("DELETE FROM medicines WHERE id = ?");
                $delete_stmt->bind_param("i", $medicine_id);
                
                if ($delete_stmt->execute()) {
                    $success_message = "Medicine deleted successfully!";
                } else {
                    $error_message = "Error deleting medicine: " . $conn->error;
                }
            }
        }
    }
}

// Get filter parameters
$alert_type = isset($_GET['alert_type']) ? $_GET['alert_type'] : 'all';
$category_filter = isset($_GET['category_filter']) ? (int)$_GET['category_filter'] : 0;
$timeframe = isset($_GET['timeframe']) ? $_GET['timeframe'] : '30';

// Build WHERE clause for filtering
$where_conditions = ["m.status = 'active'"];
$query_params = [];
$param_types = '';

// Expiry conditions based on timeframe
if ($alert_type === 'expired' || $alert_type === 'all') {
    $where_conditions[] = "m.expiry_date < CURDATE()";
}

if ($alert_type === 'expiring_soon' || $alert_type === 'all') {
    if ($alert_type === 'all') {
        $where_conditions[count($where_conditions) - 1] = "(m.expiry_date < CURDATE() OR m.expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL ? DAY))";
        $query_params[] = $timeframe;
        $param_types .= 'i';
    } else {
        $where_conditions[] = "m.expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL ? DAY)";
        $query_params[] = $timeframe;
        $param_types .= 'i';
    }
}

if ($category_filter > 0) {
    $where_conditions[] = "m.category_id = ?";
    $query_params[] = $category_filter;
    $param_types .= 'i';
}

$where_clause = '';
if (!empty($where_conditions)) {
    $where_clause = "WHERE " . implode(" AND ", $where_conditions);
}

// Fetch expiry alerts
if ($medicines_table_exists) {
    $query = "
        SELECT m.*, c.category_name,
               DATEDIFF(m.expiry_date, CURDATE()) as days_until_expiry,
               (m.expiry_date < CURDATE()) as is_expired,
               (m.expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL ? DAY)) as is_expiring_soon,
               (m.stock_quantity * m.cost_price) as stock_value
        FROM medicines m 
        LEFT JOIN medicine_categories c ON m.category_id = c.id 
        $where_clause
        ORDER BY 
            m.expiry_date ASC,
            m.stock_quantity DESC
    ";
    
    // Add timeframe parameter for the SELECT clause
    array_unshift($query_params, $timeframe);
    $param_types = 'i' . $param_types;
    
    $stmt = $conn->prepare($query);
    if (!empty($query_params)) {
        $stmt->bind_param($param_types, ...$query_params);
    }
    $stmt->execute();
    $alerts_result = $stmt->get_result();
    
    $total_alerts = $alerts_result->num_rows;
} else {
    $total_alerts = 0;
    $alerts_result = null;
}

// Fetch categories for filter dropdown
$categories_result = $conn->query("SELECT id, category_name FROM medicine_categories WHERE status = 'active' ORDER BY category_name");

// Get detailed statistics
$expired_count = 0;
$expiring_soon_count = 0;
$total_stock_value_at_risk = 0;
$critical_alerts = 0;

if ($medicines_table_exists) {
    $stats_query = "
        SELECT 
            SUM(CASE WHEN expiry_date < CURDATE() THEN 1 ELSE 0 END) as expired,
            SUM(CASE WHEN expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL ? DAY) THEN 1 ELSE 0 END) as expiring_soon,
            SUM(CASE WHEN expiry_date < CURDATE() THEN stock_quantity * cost_price ELSE 0 END) as expired_value,
            SUM(CASE WHEN expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL ? DAY) THEN stock_quantity * cost_price ELSE 0 END) as expiring_value,
            SUM(CASE WHEN expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 7 DAY) THEN 1 ELSE 0 END) as critical
        FROM medicines
        WHERE status = 'active'
    ";
    
    $stats_stmt = $conn->prepare($stats_query);
    $stats_stmt->bind_param("ii", $timeframe, $timeframe);
    $stats_stmt->execute();
    $stats_result = $stats_stmt->get_result();
    
    if ($stats_result) {
        $stats = $stats_result->fetch_assoc();
        $expired_count = $stats['expired'];
        $expiring_soon_count = $stats['expiring_soon'];
        $total_stock_value_at_risk = ($stats['expired_value'] + $stats['expiring_value']);
        $critical_alerts = $stats['critical'];
    }
    
    // Get expiry distribution for chart
    $distribution_data = [];
    $ranges = [
        ['label' => 'Expired', 'start' => -365, 'end' => -1, 'color' => 'danger'],
        ['label' => 'Today', 'start' => 0, 'end' => 0, 'color' => 'danger'],
        ['label' => '1-7 days', 'start' => 1, 'end' => 7, 'color' => 'warning'],
        ['label' => '8-30 days', 'start' => 8, 'end' => 30, 'color' => 'info'],
        ['label' => '31-90 days', 'start' => 31, 'end' => 90, 'color' => 'primary'],
        ['label' => '90+ days', 'start' => 91, 'end' => 365, 'color' => 'success']
    ];
    
    foreach ($ranges as $range) {
        $dist_query = $conn->prepare("
            SELECT COUNT(*) as count, SUM(stock_quantity * cost_price) as value
            FROM medicines 
            WHERE status = 'active' 
            AND expiry_date BETWEEN DATE_ADD(CURDATE(), INTERVAL ? DAY) AND DATE_ADD(CURDATE(), INTERVAL ? DAY)
        ");
        $dist_query->bind_param("ii", $range['start'], $range['end']);
        $dist_query->execute();
        $dist_result = $dist_query->get_result();
        $dist_data = $dist_result->fetch_assoc();
        
        $distribution_data[] = [
            'label' => $range['label'],
            'count' => $dist_data['count'],
            'value' => $dist_data['value'] ?? 0,
            'color' => $range['color']
        ];
    }
}
?>

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">

<?php include('includes/topbar.php')?>

<div class="vertical-menu">

<?php include('includes/sidebar.php')?>
            
        </div>
    </div>

<div class="main-content">
        <div class="page-content">
           
            <div class="container-fluid">

<?php if (isset($success_message)): ?>
                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-check-all me-2"></i>
                        <?php echo $success_message; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>
                
                <?php if (isset($error_message)): ?>
                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                        <i class="mdi mdi-block-helper me-2"></i>
                        <?php echo $error_message; ?>
                        <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                    </div>
                <?php endif; ?>

<?php if ($critical_alerts > 0): ?>
                <div class="alert alert-danger alert-dismissible fade show" role="alert">
                    <h5 class="alert-heading"><i class="mdi mdi-alert-circle me-2"></i> Critical Alert!</h5>
                    <p class="mb-0">You have <strong><?php echo $critical_alerts; ?> medicine(s)</strong> expiring within 7 days that require immediate attention.</p>
                </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-xl-2 col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $total_alerts; ?></h4>
                                        <p class="text-muted mb-0">Total Alerts</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-alert-circle font-size-24 text-warning"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-2 col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $expired_count; ?></h4>
                                        <p class="text-muted mb-0">Expired</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-alert-octagon font-size-24 text-danger"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-2 col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $expiring_soon_count; ?></h4>
                                        <p class="text-muted mb-0">Expiring Soon</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-clock-alert font-size-24 text-warning"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-2 col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $critical_alerts; ?></h4>
                                        <p class="text-muted mb-0">Critical (7 days)</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-fire font-size-24 text-danger"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-2 col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0">₹<?php echo number_format($total_stock_value_at_risk, 2); ?></h4>
                                        <p class="text-muted mb-0">Value at Risk</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-currency-inr font-size-24 text-info"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-2 col-md-4">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex align-items-center">
                                    <div class="flex-grow-1">
                                        <h4 class="mb-0"><?php echo $timeframe; ?> days</h4>
                                        <p class="text-muted mb-0">Alert Window</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-calendar-clock font-size-24 text-primary"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<?php if ($medicines_table_exists && $total_alerts > 0): ?>
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Expiry Distribution</h5>
                                <div class="row">
                                    <?php foreach ($distribution_data as $dist): ?>
                                        <?php if ($dist['count'] > 0): ?>
                                        <div class="col-md-2 col-6 mb-3">
                                            <div class="card border-<?php echo $dist['color']; ?>">
                                                <div class="card-body text-center p-2">
                                                    <h6 class="mb-1 text-<?php echo $dist['color']; ?>"><?php echo $dist['label']; ?></h6>
                                                    <h4 class="mb-0"><?php echo $dist['count']; ?></h4>
                                                    <small class="text-muted">₹<?php echo number_format($dist['value'], 2); ?></small>
                                                </div>
                                            </div>
                                        </div>
                                        <?php endif; ?>
                                    <?php endforeach; ?>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <?php endif; ?>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center mb-4">
                                    <h4 class="card-title">Expiry Alerts</h4>
                                    <div>
                                        <a href="batch-management.php" class="btn btn-outline-primary me-2">
                                            <i class="mdi mdi-package-variant me-1"></i> Batch Management
                                        </a>
                                        <a href="medicines-list.php" class="btn btn-primary">
                                            <i class="mdi mdi-format-list-bulleted me-1"></i> All Medicines
                                        </a>
                                    </div>
                                </div>

<form method="GET" action="" class="row g-3 mb-4">
                                    <div class="col-md-3">
                                        <select class="form-select" name="alert_type">
                                            <option value="all" <?php echo $alert_type === 'all' ? 'selected' : ''; ?>>All Alerts</option>
                                            <option value="expired" <?php echo $alert_type === 'expired' ? 'selected' : ''; ?>>Expired Only</option>
                                            <option value="expiring_soon" <?php echo $alert_type === 'expiring_soon' ? 'selected' : ''; ?>>Expiring Soon Only</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" name="timeframe">
                                            <option value="7" <?php echo $timeframe === '7' ? 'selected' : ''; ?>>7 Days</option>
                                            <option value="15" <?php echo $timeframe === '15' ? 'selected' : ''; ?>>15 Days</option>
                                            <option value="30" <?php echo $timeframe === '30' ? 'selected' : ''; ?>>30 Days</option>
                                            <option value="60" <?php echo $timeframe === '60' ? 'selected' : ''; ?>>60 Days</option>
                                            <option value="90" <?php echo $timeframe === '90' ? 'selected' : ''; ?>>90 Days</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" name="category_filter">
                                            <option value="">All Categories</option>
                                            <?php if ($categories_result && $categories_result->num_rows > 0): ?>
                                                <?php while ($category = $categories_result->fetch_assoc()): ?>
                                                    <option value="<?php echo $category['id']; ?>" <?php echo $category_filter == $category['id'] ? 'selected' : ''; ?>>
                                                        <?php echo htmlspecialchars($category['category_name']); ?>
                                                    </option>
                                                <?php endwhile; ?>
                                            <?php endif; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <button type="submit" class="btn btn-outline-primary w-100">
                                            <i class="mdi mdi-filter me-1"></i> Apply
                                        </button>
                                    </div>
                                    <div class="col-md-2">
                                        <a href="expiry-alerts.php" class="btn btn-outline-secondary w-100">
                                            <i class="mdi mdi-refresh me-1"></i> Reset
                                        </a>
                                    </div>
                                </form>

<?php if (!$medicines_table_exists): ?>
                                    <div class="alert alert-warning text-center">
                                        <h5>No Medicines Table Found</h5>
                                        <p>The medicines table hasn't been created yet. Add your first medicine to create the table automatically.</p>
                                        <a href="add-medicine.php" class="btn btn-primary mt-2">Add First Medicine</a>
                                    </div>
                                <?php elseif ($total_alerts == 0): ?>
                                    <div class="alert alert-success text-center">
                                        <h5>No Expiry Alerts!</h5>
                                        <p>Great news! No medicines are expired or expiring soon based on your current filters.</p>
                                        <div class="mt-3">
                                            <a href="medicines-list.php" class="btn btn-primary me-2">View All Medicines</a>
                                            <a href="batch-management.php" class="btn btn-outline-primary">Batch Management</a>
                                        </div>
                                    </div>
                                <?php else: ?>
                                    <div class="table-responsive">
                                        <table class="table table-centered table-nowrap mb-0">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>Medicine Name</th>
                                                    <th>Category</th>
                                                    <th>Batch No.</th>
                                                    <th>Expiry Date</th>
                                                    <th>Days Left</th>
                                                    <th>Stock Qty</th>
                                                    <th>Stock Value</th>
                                                    <th>Alert Level</th>
                                                    <th>Recommended Action</th>
                                                    <th>Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php while ($alert = $alerts_result->fetch_assoc()): ?>
                                                    <?php
                                                    // Determine alert level and recommended action
                                                    $days_until_expiry = $alert['days_until_expiry'];
                                                    $is_expired = $alert['is_expired'];
                                                    $is_expiring_soon = $alert['is_expiring_soon'];
                                                    $stock_value = $alert['stock_value'];
                                                    
                                                    $alert_level = '';
                                                    $alert_class = '';
                                                    $recommended_action = '';
                                                    $action_class = '';
                                                    
                                                    if ($is_expired) {
                                                        $alert_level = 'CRITICAL - EXPIRED';
                                                        $alert_class = 'danger';
                                                        $recommended_action = 'Remove from shelf immediately';
                                                        $action_class = 'danger';
                                                    } elseif ($days_until_expiry <= 7) {
                                                        $alert_level = 'HIGH - Urgent';
                                                        $alert_class = 'danger';
                                                        $recommended_action = 'Prioritize sales/return';
                                                        $action_class = 'warning';
                                                    } elseif ($days_until_expiry <= 30) {
                                                        $alert_level = 'MEDIUM - Attention';
                                                        $alert_class = 'warning';
                                                        $recommended_action = 'Monitor closely';
                                                        $action_class = 'info';
                                                    } else {
                                                        $alert_level = 'LOW - Watch';
                                                        $alert_class = 'info';
                                                        $recommended_action = 'Normal monitoring';
                                                        $action_class = 'secondary';
                                                    }
                                                    ?>
                                                    <tr class="<?php echo $is_expired ? 'table-danger' : ($days_until_expiry <= 7 ? 'table-warning' : ''); ?>">
                                                        <td>
                                                            <strong><?php echo htmlspecialchars($alert['medicine_name']); ?></strong>
                                                            <?php if ($alert['requires_prescription']): ?>
                                                                <span class="badge bg-info ms-1">Rx</span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td><?php echo htmlspecialchars($alert['category_name']); ?></td>
                                                        <td>
                                                            <code><?php echo htmlspecialchars($alert['batch_number']); ?></code>
                                                        </td>
                                                        <td>
                                                            <?php echo date('d M Y', strtotime($alert['expiry_date'])); ?>
                                                        </td>
                                                        <td>
                                                            <?php if ($is_expired): ?>
                                                                <span class="text-danger">
                                                                    <strong>Expired <?php echo abs($days_until_expiry); ?> days ago</strong>
                                                                </span>
                                                            <?php else: ?>
                                                                <span class="<?php echo $days_until_expiry <= 7 ? 'text-danger' : ($days_until_expiry <= 30 ? 'text-warning' : 'text-info'); ?>">
                                                                    <strong><?php echo $days_until_expiry; ?> days</strong>
                                                                </span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <strong><?php echo $alert['stock_quantity']; ?></strong>
                                                        </td>
                                                        <td>
                                                            <strong class="text-danger">₹<?php echo number_format($stock_value, 2); ?></strong>
                                                        </td>
                                                        <td>
                                                            <span class="badge bg-<?php echo $alert_class; ?>">
                                                                <?php echo $alert_level; ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <span class="badge bg-<?php echo $action_class; ?>">
                                                                <?php echo $recommended_action; ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <div class="d-flex gap-1">
                                                                <a href="edit-medicine.php?id=<?php echo $alert['id']; ?>" class="btn btn-sm btn-outline-primary">
                                                                    <i class="mdi mdi-pencil"></i>
                                                                </a>
                                                                <a href="?action=deactivate&id=<?php echo $alert['id']; ?>" 
                                                                   class="btn btn-sm btn-outline-warning"
                                                                   onclick="return confirm('Deactivate this medicine? It will be removed from active inventory.')">
                                                                    <i class="mdi mdi-eye-off"></i>
                                                                </a>
                                                                <?php if ($alert['stock_quantity'] == 0): ?>
                                                                <a href="?action=delete&id=<?php echo $alert['id']; ?>" 
                                                                   class="btn btn-sm btn-outline-danger"
                                                                   onclick="return confirm('Permanently delete this medicine? This action cannot be undone.')">
                                                                    <i class="mdi mdi-delete"></i>
                                                                </a>
                                                                <?php endif; ?>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endwhile; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                    
                                    
                                    <div class="row mt-3">
                                        <div class="col-sm-6">
                                            <div class="text-muted">
                                                Showing <strong><?php echo $total_alerts; ?></strong> alert(s)
                                                <?php if (!empty($alert_type) || !empty($category_filter)): ?>
                                                    (filtered results)
                                                <?php endif; ?>
                                            </div>
                                        </div>
                                        <div class="col-sm-6 text-end">
                                            <button type="button" class="btn btn-outline-success" onclick="printAlerts()">
                                                <i class="mdi mdi-printer me-1"></i> Print Report
                                            </button>
                                        </div>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

<?php include('includes/footer.php')?>
    </div>

</div>

<?php include('includes/rightbar.php')?>

<?php include('includes/scripts.php')?>

// Print alerts report
    function printAlerts() {
        window.print();
    }

// Auto-refresh every 5 minutes to check for new alerts
    setInterval(function() {
        // Check if there are critical alerts (expiring in 7 days)
        const criticalRows = document.querySelectorAll('.table-warning, .table-danger');
        if (criticalRows.length > 0) {
            // Show notification badge
            document.title = `(${criticalRows.length}) Expiry Alerts - Medical Shop`;
        }
    }, 300000); // 5 minutes

// Highlight rows based on urgency
    document.addEventListener('DOMContentLoaded', function() {
        const rows = document.querySelectorAll('tbody tr');
        rows.forEach(row => {
            const daysCell = row.querySelector('td:nth-child(5)');
            if (daysCell) {
                const text = daysCell.textContent.toLowerCase();
                if (text.includes('expired')) {
                    row.classList.add('expired-highlight');
                } else if (text.includes('0 days') || text.includes('1 day')) {
                    row.classList.add('critical-highlight');
                }
            }
        });
    });

// Add some CSS for highlights
    const style = document.createElement('style');
    style.textContent = `
        .expired-highlight {
            animation: blink-expired 2s infinite;
        }
        .critical-highlight {
            animation: blink-critical 1s infinite;
        }
        @keyframes blink-expired {
            0%, 50% { background-color: rgba(220, 53, 69, 0.1); }
            51%, 100% { background-color: transparent; }
        }
        @keyframes blink-critical {
            0%, 50% { background-color: rgba(255, 193, 7, 0.2); }
            51%, 100% { background-color: transparent; }
        }
        @media print {
            .btn, .alert, .card:not(.main-card) { display: none !important; }
            .main-card { border: none !important; box-shadow: none !important; }
        }
    `;
    document.head.appendChild(style);
</script>

</body>

</html>
<?php
// Close database connection
if (isset($conn)) {
    $conn->close();
}

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: expiry-alerts.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation