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.28 TB

🔧 Quick Actions

✏️ Editing: medicine-details.php

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

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

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

// Get medicine ID from URL
$medicine_id = isset($_GET['id']) ? (int)$_GET['id'] : 0;

if ($medicine_id <= 0) {
    header('Location: medicines-list.php');
    exit();
}

// Fetch medicine details
$medicine_query = "
    SELECT m.*, c.category_name, s.supplier_name,
           DATEDIFF(m.expiry_date, CURDATE()) as days_until_expiry
    FROM medicines m 
    LEFT JOIN medicine_categories c ON m.category_id = c.id 
    LEFT JOIN suppliers s ON m.supplier_id = s.id
    WHERE m.id = ?
";

$stmt = $conn->prepare($medicine_query);
$stmt->bind_param("i", $medicine_id);
$stmt->execute();
$medicine_result = $stmt->get_result();

if ($medicine_result->num_rows == 0) {
    header('Location: medicines-list.php?error=Medicine not found');
    exit();
}

$medicine = $medicine_result->fetch_assoc();

// Fetch sales statistics
$sales_stats_query = "
    SELECT 
        COUNT(DISTINCT si.sale_id) as total_sales,
        SUM(si.quantity) as total_quantity_sold,
        SUM(si.subtotal) as total_revenue,
        MIN(s.sale_date) as first_sale_date,
        MAX(s.sale_date) as last_sale_date,
        AVG(si.quantity) as avg_quantity_per_sale,
        COUNT(DISTINCT s.customer_phone) as unique_customers
    FROM sale_items si
    JOIN sales s ON si.sale_id = s.id
    WHERE si.medicine_id = ?
    AND s.status = 'completed'
";

$stmt2 = $conn->prepare($sales_stats_query);
$stmt2->bind_param("i", $medicine_id);
$stmt2->execute();
$sales_stats_result = $stmt2->get_result();
$sales_stats = $sales_stats_result->fetch_assoc();

// Fetch recent sales history (last 20 sales)
$sales_history_query = "
    SELECT 
        s.id as sale_id,
        s.sale_date,
        s.customer_name,
        s.customer_phone,
        si.quantity,
        si.unit_price,
        si.subtotal,
        s.payment_method,
        s.total_amount,
        pd.doctor_name,
        pd.patient_name
    FROM sale_items si
    JOIN sales s ON si.sale_id = s.id
    LEFT JOIN prescription_details pd ON s.id = pd.sale_id AND si.medicine_id = pd.medicine_id
    WHERE si.medicine_id = ?
    AND s.status = 'completed'
    ORDER BY s.sale_date DESC
    LIMIT 20
";

$stmt3 = $conn->prepare($sales_history_query);
$stmt3->bind_param("i", $medicine_id);
$stmt3->execute();
$sales_history_result = $stmt3->get_result();

// Fetch purchase history
$purchase_history_query = "
    SELECT 
        p.id as purchase_id,
        p.purchase_date,
        p.invoice_number,
        pi.quantity,
        pi.cost_price,
        pi.selling_price,
        pi.mrp_price,
        pi.batch_number,
        pi.expiry_date,
        s.supplier_name
    FROM purchase_items pi
    JOIN purchase_orders p ON pi.purchase_id = p.id
    LEFT JOIN suppliers s ON p.supplier_id = s.id
    WHERE pi.medicine_id = ?
    ORDER BY p.purchase_date DESC
    LIMIT 10
";

$stmt4 = $conn->prepare($purchase_history_query);
$stmt4->bind_param("i", $medicine_id);
$stmt4->execute();
$purchase_history_result = $stmt4->get_result();

// Fetch stock movement (last 30 days)
$stock_movement_query = "
    SELECT 
        'SALE' as type,
        s.sale_date as date,
        si.quantity as quantity,
        'Out' as direction,
        s.id as reference_id,
        CONCAT('Sale #', s.id, ' - ', s.customer_name) as description
    FROM sale_items si
    JOIN sales s ON si.sale_id = s.id
    WHERE si.medicine_id = ?
    AND s.sale_date >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)
    AND s.status = 'completed'
    
    UNION ALL
    
    SELECT 
        'PURCHASE' as type,
        p.purchase_date as date,
        pi.quantity as quantity,
        'In' as direction,
        p.id as reference_id,
        CONCAT('Purchase #', p.id, ' - ', s.supplier_name) as description
    FROM purchase_items pi
    JOIN purchase_orders p ON pi.purchase_id = p.id
    LEFT JOIN suppliers s ON p.supplier_id = s.id
    WHERE pi.medicine_id = ?
    AND p.purchase_date >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)
    
    ORDER BY date DESC
    LIMIT 30
";

$stmt5 = $conn->prepare($stock_movement_query);
$stmt5->bind_param("ii", $medicine_id, $medicine_id);
$stmt5->execute();
$stock_movement_result = $stmt5->get_result();

// Calculate monthly sales for chart
$monthly_sales_query = "
    SELECT 
        DATE_FORMAT(s.sale_date, '%Y-%m') as month,
        SUM(si.quantity) as total_quantity,
        SUM(si.subtotal) as total_revenue,
        COUNT(DISTINCT s.id) as sale_count
    FROM sale_items si
    JOIN sales s ON si.sale_id = s.id
    WHERE si.medicine_id = ?
    AND s.sale_date >= DATE_SUB(CURDATE(), INTERVAL 6 MONTH)
    AND s.status = 'completed'
    GROUP BY DATE_FORMAT(s.sale_date, '%Y-%m')
    ORDER BY month
";

$stmt6 = $conn->prepare($monthly_sales_query);
$stmt6->bind_param("i", $medicine_id);
$stmt6->execute();
$monthly_sales_result = $stmt6->get_result();

// Prepare data for chart
$monthly_labels = [];
$monthly_quantities = [];
$monthly_revenues = [];

while ($monthly = $monthly_sales_result->fetch_assoc()) {
    $monthly_labels[] = date('M Y', strtotime($monthly['month'] . '-01'));
    $monthly_quantities[] = $monthly['total_quantity'];
    $monthly_revenues[] = $monthly['total_revenue'];
}
?>

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

<div class="row">
                    <div class="col-xl-8">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center mb-4">
                                    <h4 class="card-title mb-0">Medicine Information</h4>
                                    <div>
                                        <span class="badge bg-<?php echo $medicine['status'] === 'active' ? 'success' : 'danger'; ?> fs-6">
                                            <?php echo ucfirst($medicine['status']); ?>
                                        </span>
                                    </div>
                                </div>
                                
                                <div class="row">
                                    <div class="col-md-6">
                                        <table class="table table-borderless">
                                            <tr>
                                                <th width="40%">Medicine Name:</th>
                                                <td>
                                                    <strong><?php echo htmlspecialchars($medicine['medicine_name']); ?></strong>
                                                    <?php if ($medicine['requires_prescription']): ?>
                                                        <span class="badge bg-info ms-2">Requires Prescription</span>
                                                    <?php endif; ?>
                                                    <?php if ($medicine['is_narcotic']): ?>
                                                        <span class="badge bg-danger ms-2">Narcotic</span>
                                                    <?php endif; ?>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th>Generic Name:</th>
                                                <td><?php echo htmlspecialchars($medicine['generic_name'] ?: 'N/A'); ?></td>
                                            </tr>
                                            <tr>
                                                <th>Category:</th>
                                                <td><?php echo htmlspecialchars($medicine['category_name']); ?></td>
                                            </tr>
                                            <tr>
                                                <th>Schedule Type:</th>
                                                <td>
                                                    <?php
                                                    $schedule_badge = '';
                                                    switch ($medicine['schedule_type']) {
                                                        case 'H1':
                                                            $schedule_badge = '<span class="badge bg-danger">H1 - Schedule H1</span>';
                                                            break;
                                                        case 'X':
                                                            $schedule_badge = '<span class="badge bg-warning">X - Schedule X</span>';
                                                            break;
                                                        case 'NARCOTIC':
                                                            $schedule_badge = '<span class="badge bg-danger">NARCOTIC</span>';
                                                            break;
                                                        case 'H':
                                                            $schedule_badge = '<span class="badge bg-info">H - Prescription</span>';
                                                            break;
                                                        case 'OTHER':
                                                            $schedule_badge = '<span class="badge bg-secondary">OTHER</span>';
                                                            break;
                                                        default:
                                                            $schedule_badge = '<span class="badge bg-success">G - General</span>';
                                                    }
                                                    echo $schedule_badge;
                                                    ?>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th>Composition:</th>
                                                <td><?php echo htmlspecialchars($medicine['composition'] ?: 'N/A'); ?></td>
                                            </tr>
                                            <tr>
                                                <th>Manufacturer:</th>
                                                <td><?php echo htmlspecialchars($medicine['manufacturer'] ?: 'N/A'); ?></td>
                                            </tr>
                                            <tr>
                                                <th>Supplier:</th>
                                                <td><?php echo htmlspecialchars($medicine['supplier_name'] ?: 'N/A'); ?></td>
                                            </tr>
                                        </table>
                                    </div>
                                    <div class="col-md-6">
                                        <table class="table table-borderless">
                                            <tr>
                                                <th width="40%">Batch Number:</th>
                                                <td><code><?php echo htmlspecialchars($medicine['batch_number']); ?></code></td>
                                            </tr>
                                            <tr>
                                                <th>Expiry Date:</th>
                                                <td>
                                                    <?php 
                                                    echo date('d M Y', strtotime($medicine['expiry_date']));
                                                    $days = $medicine['days_until_expiry'];
                                                    if ($days < 0) {
                                                        echo ' <span class="badge bg-danger">Expired ' . abs($days) . ' days ago</span>';
                                                    } elseif ($days <= 30) {
                                                        echo ' <span class="badge bg-warning">Expires in ' . $days . ' days</span>';
                                                    } else {
                                                        echo ' <span class="badge bg-success">Valid for ' . $days . ' days</span>';
                                                    }
                                                    ?>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th>Stock Quantity:</th>
                                                <td>
                                                    <span class="fs-5"><?php echo $medicine['stock_quantity']; ?></span>
                                                    <?php if ($medicine['stock_quantity'] == 0): ?>
                                                        <span class="badge bg-danger ms-2">Out of Stock</span>
                                                    <?php elseif ($medicine['stock_quantity'] <= $medicine['min_stock_level']): ?>
                                                        <span class="badge bg-warning ms-2">Low Stock (Min: <?php echo $medicine['min_stock_level']; ?>)</span>
                                                    <?php endif; ?>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th>Max Qty per Rx:</th>
                                                <td><?php echo $medicine['max_quantity_per_prescription'] ?: 'No limit'; ?></td>
                                            </tr>
                                            <tr>
                                                <th>Location:</th>
                                                <td>
                                                    <?php if (!empty($medicine['rack_number']) || !empty($medicine['box_number'])): ?>
                                                        <?php if (!empty($medicine['rack_number'])): ?>
                                                            <span class="badge bg-light text-dark">Rack: <?php echo htmlspecialchars($medicine['rack_number']); ?></span>
                                                        <?php endif; ?>
                                                        <?php if (!empty($medicine['box_number'])): ?>
                                                            <span class="badge bg-light text-dark ms-1">Box: <?php echo htmlspecialchars($medicine['box_number']); ?></span>
                                                        <?php endif; ?>
                                                    <?php else: ?>
                                                        <span class="text-muted">Not specified</span>
                                                    <?php endif; ?>
                                                </td>
                                            </tr>
                                            <tr>
                                                <th>HSN Code:</th>
                                                <td><?php echo htmlspecialchars($medicine['hsn_code'] ?: 'N/A'); ?></td>
                                            </tr>
                                            <tr>
                                                <th>GST Rate:</th>
                                                <td><?php echo $medicine['gst_rate']; ?>%</td>
                                            </tr>
                                        </table>
                                    </div>
                                </div>
                                
                                <div class="row mt-3">
                                    <div class="col-12">
                                        <h5 class="mb-3">Pricing Information</h5>
                                        <div class="row">
                                            <div class="col-md-3">
                                                <div class="card bg-light">
                                                    <div class="card-body text-center py-3">
                                                        <h6 class="text-muted mb-2">Cost Price</h6>
                                                        <h4 class="text-primary mb-0">₹<?php echo number_format($medicine['cost_price'], 2); ?></h4>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="col-md-3">
                                                <div class="card bg-light">
                                                    <div class="card-body text-center py-3">
                                                        <h6 class="text-muted mb-2">Selling Price</h6>
                                                        <h4 class="text-success mb-0">₹<?php echo number_format($medicine['selling_price'], 2); ?></h4>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="col-md-3">
                                                <div class="card bg-light">
                                                    <div class="card-body text-center py-3">
                                                        <h6 class="text-muted mb-2">MRP</h6>
                                                        <h4 class="text-info mb-0">₹<?php echo number_format($medicine['mrp'], 2); ?></h4>
                                                    </div>
                                                </div>
                                            </div>
                                            <div class="col-md-3">
                                                <div class="card bg-light">
                                                    <div class="card-body text-center py-3">
                                                        <h6 class="text-muted mb-2">Margin</h6>
                                                        <h4 class="text-warning mb-0">
                                                            <?php 
                                                            $margin = (($medicine['selling_price'] - $medicine['cost_price']) / $medicine['cost_price']) * 100;
                                                            echo number_format($margin, 2) . '%';
                                                            ?>
                                                        </h4>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        
                        
                        <div class="card mt-4">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Sales Statistics</h4>
                                <div class="row">
                                    <div class="col-md-3 col-sm-6">
                                        <div class="text-center">
                                            <h1 class="text-primary"><?php echo $sales_stats['total_sales'] ?: 0; ?></h1>
                                            <p class="text-muted mb-0">Total Sales</p>
                                        </div>
                                    </div>
                                    <div class="col-md-3 col-sm-6">
                                        <div class="text-center">
                                            <h1 class="text-success"><?php echo $sales_stats['total_quantity_sold'] ?: 0; ?></h1>
                                            <p class="text-muted mb-0">Units Sold</p>
                                        </div>
                                    </div>
                                    <div class="col-md-3 col-sm-6">
                                        <div class="text-center">
                                            <h1 class="text-info">₹<?php echo number_format($sales_stats['total_revenue'] ?: 0, 2); ?></h1>
                                            <p class="text-muted mb-0">Total Revenue</p>
                                        </div>
                                    </div>
                                    <div class="col-md-3 col-sm-6">
                                        <div class="text-center">
                                            <h1 class="text-warning"><?php echo $sales_stats['unique_customers'] ?: 0; ?></h1>
                                            <p class="text-muted mb-0">Unique Customers</p>
                                        </div>
                                    </div>
                                </div>
                                
                                <div class="row mt-4">
                                    <div class="col-md-6">
                                        <table class="table table-sm">
                                            <tr>
                                                <th>First Sale Date:</th>
                                                <td><?php echo $sales_stats['first_sale_date'] ? date('d M Y', strtotime($sales_stats['first_sale_date'])) : 'No sales yet'; ?></td>
                                            </tr>
                                            <tr>
                                                <th>Last Sale Date:</th>
                                                <td><?php echo $sales_stats['last_sale_date'] ? date('d M Y', strtotime($sales_stats['last_sale_date'])) : 'No sales yet'; ?></td>
                                            </tr>
                                        </table>
                                    </div>
                                    <div class="col-md-6">
                                        <table class="table table-sm">
                                            <tr>
                                                <th>Avg Qty per Sale:</th>
                                                <td><?php echo number_format($sales_stats['avg_quantity_per_sale'] ?: 0, 2); ?> units</td>
                                            </tr>
                                            <tr>
                                                <th>Avg Revenue per Sale:</th>
                                                <td>
                                                    <?php 
                                                    if ($sales_stats['total_sales'] > 0) {
                                                        $avg_revenue = $sales_stats['total_revenue'] / $sales_stats['total_sales'];
                                                        echo '₹' . number_format($avg_revenue, 2);
                                                    } else {
                                                        echo '₹0.00';
                                                    }
                                                    ?>
                                                </td>
                                            </tr>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    
                    <div class="col-xl-4">
                        
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Sales Trend (Last 6 Months)</h4>
                                <div style="height: 300px;">
                                    <canvas id="monthlySalesChart"></canvas>
                                </div>
                            </div>
                        </div>
                        
                        
                        <div class="card mt-4">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Quick Actions</h4>
                                <div class="d-grid gap-2">
                                    <a href="update-stock.php?id=<?php echo $medicine_id; ?>" class="btn btn-outline-primary">
                                        <i class="mdi mdi-package-variant me-2"></i> Update Stock
                                    </a>
                                    <a href="add-purchase.php?medicine_id=<?php echo $medicine_id; ?>" class="btn btn-outline-success">
                                        <i class="mdi mdi-cart-plus me-2"></i> Add Purchase
                                    </a>
                                    <button type="button" class="btn btn-outline-info" onclick="printMedicineDetails()">
                                        <i class="mdi mdi-printer me-2"></i> Print Details
                                    </button>
                                    <a href="generate-report.php?medicine_id=<?php echo $medicine_id; ?>" class="btn btn-outline-secondary">
                                        <i class="mdi mdi-file-document me-2"></i> Generate Report
                                    </a>
                                </div>
                            </div>
                        </div>
                        
                        
                        <div class="card mt-4">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Stock Valuation</h4>
                                <div class="text-center">
                                    <h1 class="text-success">₹<?php echo number_format($medicine['stock_quantity'] * $medicine['cost_price'], 2); ?></h1>
                                    <p class="text-muted">Current Stock Value (Cost)</p>
                                    <hr>
                                    <p class="mb-1"><small>Potential Revenue: ₹<?php echo number_format($medicine['stock_quantity'] * $medicine['selling_price'], 2); ?></small></p>
                                    <p class="mb-0"><small>Potential Profit: ₹<?php echo number_format($medicine['stock_quantity'] * ($medicine['selling_price'] - $medicine['cost_price']), 2); ?></small></p>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                
                
                <div class="row mt-4">
                    <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 mb-0">Recent Sales History (Last 20 Sales)</h4>
                                    <?php if ($sales_history_result->num_rows > 0): ?>
                                        <a href="sales-report.php?medicine_id=<?php echo $medicine_id; ?>" class="btn btn-sm btn-outline-primary">
                                            View All Sales
                                        </a>
                                    <?php endif; ?>
                                </div>
                                
                                <?php if ($sales_history_result->num_rows > 0): ?>
                                    <div class="table-responsive">
                                        <table class="table table-centered table-hover">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>Sale ID</th>
                                                    <th>Date & Time</th>
                                                    <th>Customer</th>
                                                    <th>Qty</th>
                                                    <th>Unit Price</th>
                                                    <th>Subtotal</th>
                                                    <th>Payment</th>
                                                    <th>Prescription</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php while ($sale = $sales_history_result->fetch_assoc()): ?>
                                                    <tr>
                                                        <td>
                                                            <a href="sale-details.php?id=<?php echo $sale['sale_id']; ?>" class="text-primary">
                                                                #<?php echo $sale['sale_id']; ?>
                                                            </a>
                                                        </td>
                                                        <td><?php echo date('d M Y H:i', strtotime($sale['sale_date'])); ?></td>
                                                        <td>
                                                            <?php if (!empty($sale['customer_name'])): ?>
                                                                <?php echo htmlspecialchars($sale['customer_name']); ?>
                                                                <?php if (!empty($sale['customer_phone'])): ?>
                                                                    <br><small class="text-muted"><?php echo htmlspecialchars($sale['customer_phone']); ?></small>
                                                                <?php endif; ?>
                                                            <?php else: ?>
                                                                <span class="text-muted">Walk-in Customer</span>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td><?php echo $sale['quantity']; ?></td>
                                                        <td>₹<?php echo number_format($sale['unit_price'], 2); ?></td>
                                                        <td><strong>₹<?php echo number_format($sale['subtotal'], 2); ?></strong></td>
                                                        <td>
                                                            <span class="badge bg-light text-dark">
                                                                <?php echo strtoupper($sale['payment_method']); ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <?php if (!empty($sale['doctor_name'])): ?>
                                                                <span class="badge bg-info" title="Prescription Sale">
                                                                    <i class="mdi mdi-file-document"></i>
                                                                    <?php echo htmlspecialchars($sale['doctor_name']); ?>
                                                                    <?php if (!empty($sale['patient_name'])): ?>
                                                                        <br><small>(<?php echo htmlspecialchars($sale['patient_name']); ?>)</small>
                                                                    <?php endif; ?>
                                                                </span>
                                                            <?php else: ?>
                                                                <span class="badge bg-light text-dark">Non-Rx</span>
                                                            <?php endif; ?>
                                                        </td>
                                                    </tr>
                                                <?php endwhile; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                <?php else: ?>
                                    <div class="alert alert-info text-center">
                                        <i class="mdi mdi-information-outline me-2"></i>
                                        No sales history found for this medicine.
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>
                
                
                <div class="row mt-4">
                    <div class="col-md-6">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Purchase History</h4>
                                <?php if ($purchase_history_result->num_rows > 0): ?>
                                    <div class="table-responsive">
                                        <table class="table table-sm">
                                            <thead>
                                                <tr>
                                                    <th>Date</th>
                                                    <th>Batch</th>
                                                    <th>Qty</th>
                                                    <th>Cost</th>
                                                    <th>Supplier</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php while ($purchase = $purchase_history_result->fetch_assoc()): ?>
                                                    <tr>
                                                        <td><?php echo date('d M Y', strtotime($purchase['purchase_date'])); ?></td>
                                                        <td><small><?php echo htmlspecialchars($purchase['batch_number']); ?></small></td>
                                                        <td><?php echo $purchase['quantity']; ?></td>
                                                        <td>₹<?php echo number_format($purchase['cost_price'], 2); ?></td>
                                                        <td><small><?php echo htmlspecialchars($purchase['supplier_name'] ?: 'N/A'); ?></small></td>
                                                    </tr>
                                                <?php endwhile; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                <?php else: ?>
                                    <div class="alert alert-info text-center">
                                        <i class="mdi mdi-information-outline me-2"></i>
                                        No purchase history found.
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-md-6">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Stock Movement (Last 30 Days)</h4>
                                <?php if ($stock_movement_result->num_rows > 0): ?>
                                    <div class="table-responsive">
                                        <table class="table table-sm">
                                            <thead>
                                                <tr>
                                                    <th>Date</th>
                                                    <th>Type</th>
                                                    <th>Qty</th>
                                                    <th>Direction</th>
                                                    <th>Description</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php while ($movement = $stock_movement_result->fetch_assoc()): ?>
                                                    <tr>
                                                        <td><small><?php echo date('d M', strtotime($movement['date'])); ?></small></td>
                                                        <td>
                                                            <span class="badge bg-<?php echo $movement['type'] == 'SALE' ? 'danger' : 'success'; ?>">
                                                                <?php echo $movement['type']; ?>
                                                            </span>
                                                        </td>
                                                        <td><?php echo $movement['quantity']; ?></td>
                                                        <td>
                                                            <span class="badge bg-<?php echo $movement['direction'] == 'In' ? 'success' : 'danger'; ?>">
                                                                <?php echo $movement['direction']; ?>
                                                            </span>
                                                        </td>
                                                        <td><small><?php echo htmlspecialchars($movement['description']); ?></small></td>
                                                    </tr>
                                                <?php endwhile; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                <?php else: ?>
                                    <div class="alert alert-info text-center">
                                        <i class="mdi mdi-information-outline me-2"></i>
                                        No stock movement in last 30 days.
                                    </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')?>

<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>

</body>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: medicine-details.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation