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: batch-management.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 batch actions
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['update_batch'])) {
        $medicine_id = isset($_POST['medicine_id']) ? (int)$_POST['medicine_id'] : 0;
        $new_batch = isset($_POST['batch_number']) ? trim($_POST['batch_number']) : '';
        $new_expiry = isset($_POST['expiry_date']) ? $_POST['expiry_date'] : '';
        
        if ($medicine_id > 0 && !empty($new_batch) && !empty($new_expiry)) {
            // Check if batch number already exists (excluding current medicine)
            $check_stmt = $conn->prepare("SELECT id FROM medicines WHERE batch_number = ? AND id != ?");
            $check_stmt->bind_param("si", $new_batch, $medicine_id);
            $check_stmt->execute();
            $check_result = $check_stmt->get_result();
            
            if ($check_result->num_rows > 0) {
                $error_message = "Batch number already exists!";
            } else {
                $update_stmt = $conn->prepare("UPDATE medicines SET batch_number = ?, expiry_date = ? WHERE id = ?");
                $update_stmt->bind_param("ssi", $new_batch, $new_expiry, $medicine_id);
                
                if ($update_stmt->execute()) {
                    $success_message = "Batch information updated successfully!";
                } else {
                    $error_message = "Error updating batch: " . $conn->error;
                }
            }
        } else {
            $error_message = "Please fill all required fields!";
        }
    }
}

// Get filter parameters
$batch_filter = isset($_GET['batch_filter']) ? $_GET['batch_filter'] : '';
$category_filter = isset($_GET['category_filter']) ? (int)$_GET['category_filter'] : 0;
$search = isset($_GET['search']) ? $conn->real_escape_string($_GET['search']) : '';

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

if (!empty($search)) {
    $where_conditions[] = "(m.medicine_name LIKE ? OR m.generic_name LIKE ? OR m.batch_number LIKE ?)";
    $search_term = "%$search%";
    $query_params[] = $search_term;
    $query_params[] = $search_term;
    $query_params[] = $search_term;
    $param_types .= 'sss';
}

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

if (!empty($batch_filter)) {
    if ($batch_filter === 'expiring_soon') {
        $where_conditions[] = "m.expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 30 DAY)";
    } elseif ($batch_filter === 'expired') {
        $where_conditions[] = "m.expiry_date < CURDATE()";
    } elseif ($batch_filter === 'expiring_3months') {
        $where_conditions[] = "m.expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 90 DAY)";
    } elseif ($batch_filter === 'expiring_6months') {
        $where_conditions[] = "m.expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 180 DAY)";
    }
}

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

// Fetch medicines with batch information
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 30 DAY)) as is_expiring_soon,
               (SELECT COUNT(*) FROM medicines m2 WHERE m2.medicine_name = m.medicine_name AND m2.status = 'active') as same_medicine_count
        FROM medicines m 
        LEFT JOIN medicine_categories c ON m.category_id = c.id 
        $where_clause
        ORDER BY 
            CASE 
                WHEN m.expiry_date < CURDATE() THEN 1
                WHEN m.expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 30 DAY) THEN 2
                ELSE 3
            END,
            m.expiry_date ASC,
            m.medicine_name
    ";
    
    if (!empty($query_params)) {
        $stmt = $conn->prepare($query);
        $stmt->bind_param($param_types, ...$query_params);
        $stmt->execute();
        $medicines_result = $stmt->get_result();
    } else {
        $medicines_result = $conn->query($query);
    }
    
    $total_medicines = $medicines_result->num_rows;
} else {
    $total_medicines = 0;
    $medicines_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 batch statistics
$total_batches = 0;
$expiring_soon_count = 0;
$expired_count = 0;
$unique_medicines = 0;

if ($medicines_table_exists) {
    $stats_query = "
        SELECT 
            COUNT(*) as total_batches,
            COUNT(DISTINCT medicine_name) as unique_medicines,
            SUM(CASE WHEN expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 30 DAY) THEN 1 ELSE 0 END) as expiring_soon,
            SUM(CASE WHEN expiry_date < CURDATE() THEN 1 ELSE 0 END) as expired
        FROM medicines
        WHERE status = 'active'
    ";
    $stats_result = $conn->query($stats_query);
    if ($stats_result) {
        $stats = $stats_result->fetch_assoc();
        $total_batches = $stats['total_batches'];
        $unique_medicines = $stats['unique_medicines'];
        $expiring_soon_count = $stats['expiring_soon'];
        $expired_count = $stats['expired'];
    }
    
    // Get next 30 days expiry breakdown
    $expiry_breakdown = [];
    for ($i = 0; $i <= 30; $i += 10) {
        $start = $i;
        $end = $i + 9;
        if ($i == 30) $end = 30;
        
        $breakdown_query = $conn->prepare("
            SELECT COUNT(*) as count 
            FROM medicines 
            WHERE expiry_date BETWEEN DATE_ADD(CURDATE(), INTERVAL ? DAY) AND DATE_ADD(CURDATE(), INTERVAL ? DAY)
            AND status = 'active'
        ");
        $breakdown_query->bind_param("ii", $start, $end);
        $breakdown_query->execute();
        $breakdown_result = $breakdown_query->get_result();
        $breakdown_data = $breakdown_result->fetch_assoc();
        
        $expiry_breakdown[] = [
            'range' => $i == 0 ? 'Expired' : ($i == 30 ? '21-30 days' : $start . '-' . $end . ' days'),
            'count' => $breakdown_data['count'],
            'start' => $start,
            'end' => $end
        ];
    }
}
?>

<?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; ?>

<div class="row">
                    <div class="col-xl-3 col-md-6">
                        <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_batches; ?></h4>
                                        <p class="text-muted mb-0">Total Batches</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-package-variant font-size-24 text-primary"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6">
                        <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 $unique_medicines; ?></h4>
                                        <p class="text-muted mb-0">Unique Medicines</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-pill font-size-24 text-info"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-3 col-md-6">
                        <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-3 col-md-6">
                        <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-circle font-size-24 text-danger"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<?php if ($medicines_table_exists && $total_batches > 0): ?>
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Expiry Timeline (Next 30 Days)</h5>
                                <div class="row">
                                    <?php foreach ($expiry_breakdown as $breakdown): ?>
                                        <div class="col-md-2 col-6">
                                            <div class="card border-<?php 
                                                echo $breakdown['start'] == 0 ? 'danger' : 
                                                     ($breakdown['start'] <= 10 ? 'warning' : 'info'); 
                                            ?>">
                                                <div class="card-body text-center p-2">
                                                    <h6 class="mb-1"><?php echo $breakdown['range']; ?></h6>
                                                    <h4 class="mb-0 text-<?php 
                                                        echo $breakdown['start'] == 0 ? 'danger' : 
                                                             ($breakdown['start'] <= 10 ? 'warning' : 'info'); 
                                                    ?>"><?php echo $breakdown['count']; ?></h4>
                                                </div>
                                            </div>
                                        </div>
                                    <?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">Batch Management</h4>
                                    <div>
                                        <a href="medicines-list.php" class="btn btn-outline-primary me-2">
                                            <i class="mdi mdi-format-list-bulleted me-1"></i> View All Medicines
                                        </a>
                                        <a href="add-medicine.php" class="btn btn-primary">
                                            <i class="mdi mdi-plus me-1"></i> Add New Medicine
                                        </a>
                                    </div>
                                </div>

<form method="GET" action="" class="row g-3 mb-4">
                                    <div class="col-md-3">
                                        <input type="text" class="form-control" name="search" placeholder="Search medicines or batches..." value="<?php echo htmlspecialchars($search); ?>">
                                    </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">
                                        <select class="form-select" name="batch_filter">
                                            <option value="">All Batches</option>
                                            <option value="expiring_soon" <?php echo $batch_filter === 'expiring_soon' ? 'selected' : ''; ?>>Expiring Soon (30 days)</option>
                                            <option value="expiring_3months" <?php echo $batch_filter === 'expiring_3months' ? 'selected' : ''; ?>>Expiring in 3 Months</option>
                                            <option value="expiring_6months" <?php echo $batch_filter === 'expiring_6months' ? 'selected' : ''; ?>>Expiring in 6 Months</option>
                                            <option value="expired" <?php echo $batch_filter === 'expired' ? 'selected' : ''; ?>>Expired</option>
                                        </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> Filter
                                        </button>
                                    </div>
                                    <div class="col-md-2">
                                        <a href="batch-management.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_medicines == 0): ?>
                                    <div class="alert alert-info text-center">
                                        <h5>No Batches Found</h5>
                                        <p>No medicine batches found in the database. Add your first medicine to get started.</p>
                                        <a href="add-medicine.php" class="btn btn-primary mt-2">Add First Medicine</a>
                                    </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>Current Batch No.</th>
                                                    <th>Expiry Date</th>
                                                    <th>Days Until Expiry</th>
                                                    <th>Stock Quantity</th>
                                                    <th>Multiple Batches</th>
                                                    <th>Status</th>
                                                    <th>Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php while ($medicine = $medicines_result->fetch_assoc()): ?>
                                                    <?php
                                                    // Determine expiry status
                                                    $days_until_expiry = $medicine['days_until_expiry'];
                                                    $is_expired = $medicine['is_expired'];
                                                    $is_expiring_soon = $medicine['is_expiring_soon'];
                                                    
                                                    $expiry_badge = '';
                                                    $expiry_class = '';
                                                    if ($is_expired) {
                                                        $expiry_badge = 'Expired';
                                                        $expiry_class = 'danger';
                                                    } elseif ($is_expiring_soon) {
                                                        $expiry_badge = 'Expiring Soon';
                                                        $expiry_class = 'warning';
                                                    } else {
                                                        $expiry_badge = 'Valid';
                                                        $expiry_class = 'success';
                                                    }
                                                    
                                                    // Multiple batches indicator
                                                    $multiple_batches = $medicine['same_medicine_count'] > 1;
                                                    ?>
                                                    <tr>
                                                        <td>
                                                            <strong><?php echo htmlspecialchars($medicine['medicine_name']); ?></strong>
                                                            <?php if ($medicine['requires_prescription']): ?>
                                                                <span class="badge bg-info ms-1">Rx</span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td><?php echo htmlspecialchars($medicine['category_name']); ?></td>
                                                        <td>
                                                            <code><?php echo htmlspecialchars($medicine['batch_number']); ?></code>
                                                        </td>
                                                        <td>
                                                            <?php echo date('d M Y', strtotime($medicine['expiry_date'])); ?>
                                                        </td>
                                                        <td>
                                                            <?php if ($is_expired): ?>
                                                                <span class="text-danger">Expired <?php echo abs($days_until_expiry); ?> days ago</span>
                                                            <?php else: ?>
                                                                <span class="<?php echo $is_expiring_soon ? 'text-warning' : 'text-success'; ?>">
                                                                    <?php echo $days_until_expiry; ?> days
                                                                </span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <strong><?php echo $medicine['stock_quantity']; ?></strong>
                                                        </td>
                                                        <td>
                                                            <?php if ($multiple_batches): ?>
                                                                <span class="badge bg-info">
                                                                    <?php echo $medicine['same_medicine_count']; ?> batches
                                                                </span>
                                                            <?php else: ?>
                                                                <span class="badge bg-secondary">Single batch</span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <span class="badge bg-<?php echo $expiry_class; ?>">
                                                                <?php echo $expiry_badge; ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <div class="d-flex gap-1">
                                                                <button type="button" 
                                                                        class="btn btn-sm btn-outline-primary" 
                                                                        onclick="editBatch(<?php echo $medicine['id']; ?>, '<?php echo htmlspecialchars($medicine['medicine_name']); ?>', '<?php echo htmlspecialchars($medicine['batch_number']); ?>', '<?php echo $medicine['expiry_date']; ?>')">
                                                                    <i class="mdi mdi-pencil"></i> Edit
                                                                </button>
                                                                <a href="edit-medicine.php?id=<?php echo $medicine['id']; ?>" class="btn btn-sm btn-outline-secondary">
                                                                    <i class="mdi mdi-eye"></i> View
                                                                </a>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endwhile; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                    
                                    
                                    <div class="row mt-3">
                                        <div class="col-sm-12">
                                            <div class="text-muted">
                                                Showing <strong><?php echo $total_medicines; ?></strong> batch(es)
                                                <?php if (!empty($search) || !empty($category_filter) || !empty($batch_filter)): ?>
                                                    (filtered results)
                                                <?php endif; ?>
                                            </div>
                                        </div>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

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

</div>

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

<div class="modal fade" id="editBatchModal" tabindex="-1" aria-labelledby="editBatchModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="editBatchModalLabel">Update Batch Information</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="">
                <div class="modal-body">
                    <input type="hidden" id="edit_medicine_id" name="medicine_id">
                    <div class="mb-3">
                        <label for="edit_medicine_name" class="form-label">Medicine Name</label>
                        <input type="text" class="form-control" id="edit_medicine_name" readonly>
                    </div>
                    <div class="mb-3">
                        <label for="batch_number" class="form-label">Batch Number <span class="text-danger">*</span></label>
                        <input type="text" class="form-control" id="batch_number" name="batch_number" required>
                        <small class="text-muted">Unique identifier for this batch</small>
                    </div>
                    <div class="mb-3">
                        <label for="expiry_date" class="form-label">Expiry Date <span class="text-danger">*</span></label>
                        <input type="date" class="form-control" id="expiry_date" name="expiry_date" required>
                        <small class="text-muted">Date when this batch expires</small>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="update_batch" class="btn btn-primary">Update Batch</button>
                </div>
            </form>
        </div>
    </div>
</div>

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

// Edit batch modal
    function editBatch(medicineId, medicineName, batchNumber, expiryDate) {
        document.getElementById('edit_medicine_id').value = medicineId;
        document.getElementById('edit_medicine_name').value = medicineName;
        document.getElementById('batch_number').value = batchNumber;
        document.getElementById('expiry_date').value = expiryDate;
        
        // Set minimum date for expiry date (today)
        const today = new Date().toISOString().split('T')[0];
        document.getElementById('expiry_date').min = today;
        
        const modal = new bootstrap.Modal(document.getElementById('editBatchModal'));
        modal.show();
    }

// Form validation for expiry date
    document.addEventListener('DOMContentLoaded', function() {
        const expiryDateField = document.getElementById('expiry_date');
        if (expiryDateField) {
            expiryDateField.addEventListener('change', function() {
                const selectedDate = new Date(this.value);
                const today = new Date();
                
                if (selectedDate <= today) {
                    alert('Expiry date must be in the future!');
                    this.value = '';
                    this.focus();
                }
            });
        }
    });

// Highlight expired and expiring soon rows
    document.addEventListener('DOMContentLoaded', function() {
        const rows = document.querySelectorAll('tbody tr');
        rows.forEach(row => {
            const statusBadge = row.querySelector('.badge');
            if (statusBadge) {
                if (statusBadge.classList.contains('bg-danger')) {
                    row.classList.add('table-danger');
                } else if (statusBadge.classList.contains('bg-warning')) {
                    row.classList.add('table-warning');
                }
            }
        });
    });
</script>

</body>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: batch-management.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation