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: stock-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 stock update
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['update_stock'])) {
        $medicine_id = isset($_POST['medicine_id']) ? (int)$_POST['medicine_id'] : 0;
        $new_stock = isset($_POST['stock_quantity']) ? (int)$_POST['stock_quantity'] : 0;
        
        if ($medicine_id > 0 && $new_stock >= 0) {
            $update_stmt = $conn->prepare("UPDATE medicines SET stock_quantity = ? WHERE id = ?");
            $update_stmt->bind_param("ii", $new_stock, $medicine_id);
            
            if ($update_stmt->execute()) {
                $success_message = "Stock updated successfully!";
            } else {
                $error_message = "Error updating stock: " . $conn->error;
            }
        } else {
            $error_message = "Invalid stock quantity!";
        }
    }
    
    // Handle bulk stock update
    if (isset($_POST['bulk_update_stock'])) {
        $updates = $_POST['stock_updates'] ?? [];
        $success_count = 0;
        $error_count = 0;
        
        foreach ($updates as $medicine_id => $stock_data) {
            $medicine_id = (int)$medicine_id;
            $new_stock = (int)$stock_data['quantity'];
            
            if ($medicine_id > 0 && $new_stock >= 0) {
                $update_stmt = $conn->prepare("UPDATE medicines SET stock_quantity = ? WHERE id = ?");
                $update_stmt->bind_param("ii", $new_stock, $medicine_id);
                
                if ($update_stmt->execute()) {
                    $success_count++;
                } else {
                    $error_count++;
                }
            }
        }
        
        if ($success_count > 0) {
            $success_message = "Successfully updated stock for $success_count medicine(s)";
        }
        if ($error_count > 0) {
            $error_message = "Failed to update stock for $error_count medicine(s)";
        }
    }
}

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

// 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 ? OR m.manufacturer LIKE ?)";
    $search_term = "%$search%";
    $query_params[] = $search_term;
    $query_params[] = $search_term;
    $query_params[] = $search_term;
    $query_params[] = $search_term;
    $param_types .= 'ssss';
}

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

if (!empty($stock_filter)) {
    if ($stock_filter === 'low_stock') {
        $where_conditions[] = "m.stock_quantity <= m.min_stock_level AND m.stock_quantity > 0";
    } elseif ($stock_filter === 'out_of_stock') {
        $where_conditions[] = "m.stock_quantity = 0";
    } elseif ($stock_filter === 'in_stock') {
        $where_conditions[] = "m.stock_quantity > 0";
    } elseif ($stock_filter === 'expiring_soon') {
        $where_conditions[] = "m.expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 30 DAY)";
    } elseif ($stock_filter === 'expired') {
        $where_conditions[] = "m.expiry_date < CURDATE()";
    }
}

if (!empty($rack_filter)) {
    $where_conditions[] = "m.rack_number LIKE ?";
    $query_params[] = "%$rack_filter%";
    $param_types .= 's';
}

if (!empty($box_filter)) {
    $where_conditions[] = "m.box_number LIKE ?";
    $query_params[] = "%$box_filter%";
    $param_types .= 's';
}

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

// Fetch medicines with stock information
if ($medicines_table_exists) {
    $query = "
        SELECT m.*, c.category_name,
               DATEDIFF(m.expiry_date, CURDATE()) as days_until_expiry,
               (m.stock_quantity <= m.min_stock_level) as is_low_stock,
               (m.expiry_date < CURDATE()) as is_expired,
               (m.expiry_date BETWEEN CURDATE() AND DATE_ADD(CURDATE(), INTERVAL 30 DAY)) as is_expiring_soon
        FROM medicines m 
        LEFT JOIN medicine_categories c ON m.category_id = c.id 
        $where_clause
        ORDER BY 
            CASE 
                WHEN m.stock_quantity = 0 THEN 1
                WHEN m.stock_quantity <= m.min_stock_level THEN 2
                ELSE 3
            END,
            m.rack_number,
            m.box_number,
            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");

// Fetch unique rack numbers for filter
$rack_numbers_result = $conn->query("SELECT DISTINCT rack_number FROM medicines WHERE rack_number IS NOT NULL AND rack_number != '' AND status = 'active' ORDER BY rack_number");

// Fetch unique box numbers for filter
$box_numbers_result = $conn->query("SELECT DISTINCT box_number FROM medicines WHERE box_number IS NOT NULL AND box_number != '' AND status = 'active' ORDER BY box_number");

// Get statistics
$total_stock_value = 0;
$low_stock_value = 0;
$out_of_stock_value = 0;
$expiring_soon_count = 0;
$expired_count = 0;

if ($medicines_table_exists) {
    $stats_query = "
        SELECT 
            COUNT(*) as total,
            SUM(CASE WHEN stock_quantity <= min_stock_level AND stock_quantity > 0 THEN 1 ELSE 0 END) as low_stock,
            SUM(CASE WHEN stock_quantity = 0 THEN 1 ELSE 0 END) as out_of_stock,
            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,
            SUM(stock_quantity * cost_price) as total_value,
            SUM(CASE WHEN stock_quantity <= min_stock_level AND stock_quantity > 0 THEN stock_quantity * cost_price ELSE 0 END) as low_stock_value,
            SUM(CASE WHEN stock_quantity = 0 THEN 0 ELSE stock_quantity * cost_price END) as in_stock_value
        FROM medicines
        WHERE status = 'active'
    ";
    $stats_result = $conn->query($stats_query);
    if ($stats_result) {
        $stats = $stats_result->fetch_assoc();
        $low_stock_count = $stats['low_stock'];
        $out_of_stock_count = $stats['out_of_stock'];
        $expiring_soon_count = $stats['expiring_soon'];
        $expired_count = $stats['expired'];
        $total_stock_value = $stats['total_value'] ?? 0;
        $low_stock_value = $stats['low_stock_value'] ?? 0;
        $in_stock_value = $stats['in_stock_value'] ?? 0;
    }
}
?>

<?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-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_medicines; ?></h4>
                                        <p class="text-muted mb-0">Total Items</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-pill font-size-24 text-primary"></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 $low_stock_count; ?></h4>
                                        <p class="text-muted mb-0">Low Stock</p>
                                       
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-pill 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 $out_of_stock_count; ?></h4>
                                        <p class="text-muted mb-0">Out of Stock</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-pill 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-pill 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 $expired_count; ?></h4>
                                        <p class="text-muted mb-0">Expired</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-pill font-size-24 text-secondary"></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, 2); ?></h4>
                                        <p class="text-muted mb-0">Total Stock Value</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-currency-inr font-size-24 text-success"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<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">Stock Management</h4>
                                    <div>
                                        <button type="button" class="btn btn-outline-info me-2" onclick="printStockReport()">
                                            <i class="mdi mdi-printer me-1"></i> Print Report
                                        </button>
                                        <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-2 mb-4">
                                    <div class="col-md-2">
                                        <input type="text" class="form-control" name="search" placeholder="Search..." 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="stock_filter">
                                            <option value="">All Stock</option>
                                            <option value="low_stock" <?php echo $stock_filter === 'low_stock' ? 'selected' : ''; ?>>Low Stock</option>
                                            <option value="out_of_stock" <?php echo $stock_filter === 'out_of_stock' ? 'selected' : ''; ?>>Out of Stock</option>
                                            <option value="in_stock" <?php echo $stock_filter === 'in_stock' ? 'selected' : ''; ?>>In Stock</option>
                                            <option value="expiring_soon" <?php echo $stock_filter === 'expiring_soon' ? 'selected' : ''; ?>>Expiring Soon</option>
                                            <option value="expired" <?php echo $stock_filter === 'expired' ? 'selected' : ''; ?>>Expired</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" name="rack_filter">
                                            <option value="">All Racks</option>
                                            <?php if ($rack_numbers_result && $rack_numbers_result->num_rows > 0): ?>
                                                <?php while ($rack = $rack_numbers_result->fetch_assoc()): ?>
                                                    <option value="<?php echo htmlspecialchars($rack['rack_number']); ?>" <?php echo $rack_filter == $rack['rack_number'] ? 'selected' : ''; ?>>
                                                        Rack: <?php echo htmlspecialchars($rack['rack_number']); ?>
                                                    </option>
                                                <?php endwhile; ?>
                                            <?php endif; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" name="box_filter">
                                            <option value="">All Boxes</option>
                                            <?php if ($box_numbers_result && $box_numbers_result->num_rows > 0): ?>
                                                <?php while ($box = $box_numbers_result->fetch_assoc()): ?>
                                                    <option value="<?php echo htmlspecialchars($box['box_number']); ?>" <?php echo $box_filter == $box['box_number'] ? 'selected' : ''; ?>>
                                                        Box: <?php echo htmlspecialchars($box['box_number']); ?>
                                                    </option>
                                                <?php endwhile; ?>
                                            <?php endif; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-1">
                                        <button type="submit" class="btn btn-primary w-100">
                                            <i class="mdi mdi-filter"></i>
                                        </button>
                                    </div>
                                    <div class="col-md-1">
                                        <a href="stock-management.php" class="btn btn-secondary w-100">
                                            <i class="mdi mdi-refresh"></i>
                                        </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 Medicines Found</h5>
                                        <p>No medicines 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: ?>
                                    
                                    <form method="POST" action="" id="bulkStockForm">
                                        <div class="table-responsive">
                                            <table class="table table-centered table-nowrap mb-0" id="stockTable">
                                                <thead class="table-light">
                                                    <tr>
                                                        <th>Medicine Name</th>
                                                        <th>Category</th>
                                                        <th>Location</th>
                                                        <th>Batch No.</th>
                                                        <th>Expiry Date</th>
                                                        <th>Current Stock</th>
                                                        <th>Min Stock</th>
                                                        <th>Stock Status</th>
                                                        <th>Expiry Status</th>
                                                        <th>New Stock</th>
                                                        <th>Actions</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    <?php while ($medicine = $medicines_result->fetch_assoc()): ?>
                                                        <?php
                                                        // Determine stock status
                                                        $stock_quantity = $medicine['stock_quantity'];
                                                        $min_stock_level = $medicine['min_stock_level'];
                                                        $days_until_expiry = $medicine['days_until_expiry'];
                                                        
                                                        $stock_badge = '';
                                                        $stock_class = '';
                                                        if ($stock_quantity == 0) {
                                                            $stock_badge = 'Out';
                                                            $stock_class = 'danger';
                                                        } elseif ($stock_quantity <= $min_stock_level) {
                                                            $stock_badge = 'Low';
                                                            $stock_class = 'warning';
                                                        } else {
                                                            $stock_badge = 'OK';
                                                            $stock_class = 'success';
                                                        }
                                                        
                                                        // Determine expiry status
                                                        $expiry_badge = '';
                                                        $expiry_class = '';
                                                        if ($days_until_expiry < 0) {
                                                            $expiry_badge = 'Expired';
                                                            $expiry_class = 'danger';
                                                        } elseif ($days_until_expiry <= 30) {
                                                            $expiry_badge = 'Soon';
                                                            $expiry_class = 'warning';
                                                        } else {
                                                            $expiry_badge = 'Valid';
                                                            $expiry_class = 'success';
                                                        }
                                                        
                                                        // Format location
                                                        $location = '';
                                                        if (!empty($medicine['rack_number'])) {
                                                            $location .= 'Rack: ' . htmlspecialchars($medicine['rack_number']);
                                                        }
                                                        if (!empty($medicine['box_number'])) {
                                                            if (!empty($location)) $location .= '<br>';
                                                            $location .= 'Box: ' . htmlspecialchars($medicine['box_number']);
                                                        }
                                                        if (empty($location)) {
                                                            $location = '<span class="text-muted">-</span>';
                                                        }
                                                        ?>
                                                        <tr class="<?php echo $stock_quantity == 0 ? 'table-danger' : ($stock_quantity <= $min_stock_level ? 'table-warning' : ''); ?>">
                                                            <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><?php echo $location; ?></td>
                                                            <td><?php echo htmlspecialchars($medicine['batch_number']); ?></td>
                                                            <td>
                                                                <?php echo date('d M Y', strtotime($medicine['expiry_date'])); ?>
                                                                <br>
                                                                <small class="text-muted"><?php echo $days_until_expiry; ?> days</small>
                                                            </td>
                                                            <td>
                                                                <strong><?php echo $stock_quantity; ?></strong>
                                                            </td>
                                                            <td><?php echo $min_stock_level; ?></td>
                                                            <td>
                                                                <span class="badge bg-<?php echo $stock_class; ?>">
                                                                    <?php echo $stock_badge; ?>
                                                                </span>
                                                            </td>
                                                            <td>
                                                                <span class="badge bg-<?php echo $expiry_class; ?>">
                                                                    <?php echo $expiry_badge; ?>
                                                                </span>
                                                            </td>
                                                            <td style="width: 120px;">
                                                                <input type="number" 
                                                                       class="form-control form-control-sm stock-input" 
                                                                       name="stock_updates[<?php echo $medicine['id']; ?>][quantity]" 
                                                                       value="<?php echo $stock_quantity; ?>" 
                                                                       min="0" 
                                                                       data-original="<?php echo $stock_quantity; ?>"
                                                                       style="width: 80px;">
                                                            </td>
                                                            <td>
                                                                <div class="d-flex gap-1">
                                                                    <button type="button" 
                                                                            class="btn btn-sm btn-outline-primary" 
                                                                            onclick="quickUpdateStock(<?php echo $medicine['id']; ?>, '<?php echo htmlspecialchars($medicine['medicine_name']); ?>', <?php echo $stock_quantity; ?>)"
                                                                            title="Quick Update">
                                                                        <i class="mdi mdi-update"></i>
                                                                    </button>
                                                                    <a href="edit-medicine.php?id=<?php echo $medicine['id']; ?>" class="btn btn-sm btn-outline-secondary" title="Edit">
                                                                        <i class="mdi mdi-pencil"></i>
                                                                    </a>
                                                                    <button type="button" 
                                                                            class="btn btn-sm btn-outline-success" 
                                                                            onclick="adjustStock(<?php echo $medicine['id']; ?>, '<?php echo htmlspecialchars($medicine['medicine_name']); ?>')"
                                                                            title="Adjust Stock">
                                                                        <i class="mdi mdi-plus-minus"></i>
                                                                    </button>
                                                                </div>
                                                            </td>
                                                        </tr>
                                                    <?php endwhile; ?>
                                                </tbody>
                                            </table>
                                        </div>
                                        
                                        
                                        <div class="row mt-3">
                                            <div class="col-sm-12">
                                                <div class="d-flex justify-content-between align-items-center">
                                                    <div class="text-muted">
                                                        Showing <strong><?php echo $total_medicines; ?></strong> medicine(s)
                                                        <?php if (!empty($search) || !empty($category_filter) || !empty($stock_filter) || !empty($rack_filter) || !empty($box_filter)): ?>
                                                            (filtered results)
                                                        <?php endif; ?>
                                                    </div>
                                                    <div>
                                                        <button type="button" class="btn btn-outline-info me-2" onclick="exportToExcel()">
                                                            <i class="mdi mdi-file-excel me-1"></i> Export Excel
                                                        </button>
                                                        <button type="submit" name="bulk_update_stock" class="btn btn-success">
                                                            <i class="mdi mdi-content-save-all me-1"></i> Save All Changes
                                                        </button>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </form>
                                <?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="quickUpdateModal" tabindex="-1" aria-labelledby="quickUpdateModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="quickUpdateModalLabel">Update Stock</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="update_medicine_id" name="medicine_id">
                    <div class="mb-3">
                        <label for="update_medicine_name" class="form-label">Medicine Name</label>
                        <input type="text" class="form-control" id="update_medicine_name" readonly>
                    </div>
                    <div class="mb-3">
                        <label for="stock_quantity" class="form-label">New Stock Quantity</label>
                        <input type="number" class="form-control" id="stock_quantity" name="stock_quantity" min="0" required>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="update_stock" class="btn btn-primary">Update Stock</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="adjustStockModal" tabindex="-1" aria-labelledby="adjustStockModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="adjustStockModalLabel">Adjust Stock</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="" id="adjustStockForm">
                <div class="modal-body">
                    <input type="hidden" id="adjust_medicine_id" name="medicine_id">
                    <div class="mb-3">
                        <label for="adjust_medicine_name" class="form-label">Medicine Name</label>
                        <input type="text" class="form-control" id="adjust_medicine_name" readonly>
                    </div>
                    <div class="mb-3">
                        <label for="current_stock" class="form-label">Current Stock</label>
                        <input type="number" class="form-control" id="current_stock" readonly>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Adjustment Type</label>
                        <div class="d-flex gap-2">
                            <div class="form-check">
                                <input class="form-check-input" type="radio" name="adjustment_type" id="add_stock" value="add" checked>
                                <label class="form-check-label" for="add_stock">
                                    Add Stock
                                </label>
                            </div>
                            <div class="form-check">
                                <input class="form-check-input" type="radio" name="adjustment_type" id="remove_stock" value="remove">
                                <label class="form-check-label" for="remove_stock">
                                    Remove Stock
                                </label>
                            </div>
                            <div class="form-check">
                                <input class="form-check-input" type="radio" name="adjustment_type" id="set_stock" value="set">
                                <label class="form-check-label" for="set_stock">
                                    Set Stock
                                </label>
                            </div>
                        </div>
                    </div>
                    <div class="mb-3">
                        <label for="adjustment_quantity" class="form-label">Quantity</label>
                        <input type="number" class="form-control" id="adjustment_quantity" name="adjustment_quantity" min="1" value="1" required>
                    </div>
                    <div class="mb-3">
                        <label for="adjustment_reason" class="form-label">Reason (Optional)</label>
                        <textarea class="form-control" id="adjustment_reason" name="adjustment_reason" rows="2" placeholder="e.g., Restocked, Damaged, etc."></textarea>
                    </div>
                    <div id="new_stock_preview" class="alert alert-info">
                        New stock will be: <span id="calculated_stock">0</span>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="button" class="btn btn-primary" onclick="submitAdjustment()">Adjust Stock</button>
                </div>
            </form>
        </div>
    </div>
</div>

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

// Quick stock update modal
    function quickUpdateStock(medicineId, medicineName, currentStock) {
        document.getElementById('update_medicine_id').value = medicineId;
        document.getElementById('update_medicine_name').value = medicineName;
        document.getElementById('stock_quantity').value = currentStock;
        
        const modal = new bootstrap.Modal(document.getElementById('quickUpdateModal'));
        modal.show();
    }

// Adjust stock modal
    function adjustStock(medicineId, medicineName) {
        const row = document.querySelector(`tr:has(input[name="stock_updates[${medicineId}][quantity]"])`);
        const currentStock = row.querySelector('.stock-input').value;
        
        document.getElementById('adjust_medicine_id').value = medicineId;
        document.getElementById('adjust_medicine_name').value = medicineName;
        document.getElementById('current_stock').value = currentStock;
        document.getElementById('adjustment_quantity').value = 1;
        document.getElementById('adjustment_reason').value = '';
        
        // Calculate initial preview
        calculateNewStock();
        
        const modal = new bootstrap.Modal(document.getElementById('adjustStockModal'));
        modal.show();
    }

// Calculate new stock based on adjustment
    function calculateNewStock() {
        const currentStock = parseInt(document.getElementById('current_stock').value);
        const adjustmentType = document.querySelector('input[name="adjustment_type"]:checked').value;
        const adjustmentQty = parseInt(document.getElementById('adjustment_quantity').value) || 0;
        
        let newStock = currentStock;
        
        switch(adjustmentType) {
            case 'add':
                newStock = currentStock + adjustmentQty;
                break;
            case 'remove':
                newStock = currentStock - adjustmentQty;
                if (newStock < 0) newStock = 0;
                break;
            case 'set':
                newStock = adjustmentQty;
                break;
        }
        
        document.getElementById('calculated_stock').textContent = newStock;
    }

// Submit adjustment
    function submitAdjustment() {
        const form = document.getElementById('adjustStockForm');
        const medicineId = document.getElementById('adjust_medicine_id').value;
        const newStock = document.getElementById('calculated_stock').textContent;
        
        // Update the corresponding input in the main form
        const stockInput = document.querySelector(`input[name="stock_updates[${medicineId}][quantity]"]`);
        stockInput.value = newStock;
        stockInput.classList.add('border', 'border-success');
        
        // Close modal
        const modal = bootstrap.Modal.getInstance(document.getElementById('adjustStockModal'));
        modal.hide();
        
        alert('Stock adjustment prepared. Click "Save All Changes" to apply.');
    }

// Highlight changed fields in bulk form
    document.addEventListener('DOMContentLoaded', function() {
        const inputs = document.querySelectorAll('.stock-input');
        inputs.forEach(input => {
            const originalValue = input.getAttribute('data-original');
            
            input.addEventListener('change', function() {
                if (this.value !== originalValue) {
                    this.classList.add('border', 'border-success');
                } else {
                    this.classList.remove('border', 'border-success');
                }
            });
        });
        
        // Add event listeners for adjustment modal
        document.querySelectorAll('input[name="adjustment_type"]').forEach(radio => {
            radio.addEventListener('change', calculateNewStock);
        });
        document.getElementById('adjustment_quantity').addEventListener('input', calculateNewStock);
    });

// Confirm bulk update
    document.getElementById('bulkStockForm').addEventListener('submit', function(e) {
        const changedInputs = document.querySelectorAll('.stock-input.border-success');
        if (changedInputs.length === 0) {
            e.preventDefault();
            alert('No changes detected. Please update at least one stock quantity before saving.');
            return false;
        }
        
        return confirm(`Are you sure you want to update stock for ${changedInputs.length} medicine(s)?`);
    });

// Export to Excel
    function exportToExcel() {
        const table = document.getElementById('stockTable');
        const html = table.outerHTML;
        const blob = new Blob([html], { type: 'application/vnd.ms-excel' });
        const url = URL.createObjectURL(blob);
        const a = document.createElement('a');
        a.href = url;
        a.download = 'stock-report-' + new Date().toISOString().split('T')[0] + '.xls';
        document.body.appendChild(a);
        a.click();
        document.body.removeChild(a);
        URL.revokeObjectURL(url);
    }

// Print stock report
    function printStockReport() {
        const printContent = document.getElementById('stockTable').outerHTML;
        const originalContent = document.body.innerHTML;
        
        document.body.innerHTML = `
            <html>
                <head>
                    <title>Stock Report - <?php echo date('Y-m-d'); ?></title>
                    <style>
                        body { font-family: Arial, sans-serif; }
                        table { width: 100%; border-collapse: collapse; }
                        th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }
                        th { background-color: #f2f2f2; }
                        .table-danger { background-color: #f8d7da; }
                        .table-warning { background-color: #fff3cd; }
                        .badge { padding: 3px 8px; border-radius: 4px; color: white; }
                        .bg-danger { background-color: #dc3545; }
                        .bg-warning { background-color: #ffc107; }
                        .bg-success { background-color: #28a745; }
                        @media print {
                            .no-print { display: none; }
                        }
                    </style>
                </head>
                <body>
                    <h2>Stock Report - <?php echo date('Y-m-d'); ?></h2>
                    <p>Total Items: <?php echo $total_medicines; ?> | Total Value: ₹<?php echo number_format($total_stock_value, 2); ?></p>
                    ${printContent}
                    <div class="no-print">
                        <button onclick="window.print()">Print</button>
                        <button onclick="window.close()">Close</button>
                    </div>
                </body>
            </html>
        `;
        
        window.print();
        document.body.innerHTML = originalContent;
        location.reload();
    }
</script>

</body>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: stock-management.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation