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: supplier-medicines.php

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

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

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

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

// Check if supplier exists
if ($supplier_id > 0) {
    $supplier_stmt = $conn->prepare("SELECT * FROM suppliers WHERE id = ?");
    $supplier_stmt->bind_param("i", $supplier_id);
    $supplier_stmt->execute();
    $supplier_result = $supplier_stmt->get_result();
    
    if ($supplier_result->num_rows > 0) {
        $supplier = $supplier_result->fetch_assoc();
    } else {
        // Redirect if supplier doesn't exist
        header("Location: suppliers-list.php");
        exit();
    }
} else {
    // Redirect if no supplier ID
    header("Location: suppliers-list.php");
    exit();
}

// Handle search and filter
$search = isset($_GET['search']) ? $conn->real_escape_string($_GET['search']) : '';
$category_filter = isset($_GET['category_filter']) ? (int)$_GET['category_filter'] : '';
$status_filter = isset($_GET['status_filter']) ? $_GET['status_filter'] : '';
$schedule_filter = isset($_GET['schedule_filter']) ? $_GET['schedule_filter'] : '';

// Build WHERE clause for medicines query
$where_conditions = ["m.supplier_id = ?"];
$query_params = [$supplier_id];
$param_types = "i";

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 (!empty($category_filter)) {
    $where_conditions[] = "m.category_id = ?";
    $query_params[] = $category_filter;
    $param_types .= 'i';
}

if (!empty($status_filter)) {
    $where_conditions[] = "m.status = ?";
    $query_params[] = $status_filter;
    $param_types .= 's';
}

if (!empty($schedule_filter)) {
    if ($schedule_filter == 'H1') {
        $where_conditions[] = "(m.schedule_type = 'H1' OR m.schedule_type = 'H')";
    } else if ($schedule_filter == 'X') {
        $where_conditions[] = "m.schedule_type = 'X'";
    } else if ($schedule_filter == 'G') {
        $where_conditions[] = "(m.schedule_type IS NULL OR m.schedule_type = 'G')";
    }
}

$where_clause = "WHERE " . implode(" AND ", $where_conditions);

// Fetch medicines for this supplier
$query = "
    SELECT m.*, 
           c.category_name,
           IFNULL(SUM(si.quantity), 0) as total_sold,
           (
               SELECT SUM(quantity) 
               FROM purchase_items pi 
               JOIN purchase_orders po ON pi.purchase_id = po.id 
               WHERE pi.medicine_id = m.id AND po.supplier_id = m.supplier_id
           ) as total_purchased,
           DATEDIFF(m.expiry_date, CURDATE()) as days_to_expiry
    FROM medicines m
    LEFT JOIN medicine_categories c ON m.category_id = c.id
    LEFT JOIN sale_items si ON m.id = si.medicine_id
    $where_clause
    GROUP BY m.id
    ORDER BY m.medicine_name ASC
";

$stmt = $conn->prepare($query);
if ($stmt) {
    $stmt->bind_param($param_types, ...$query_params);
    $stmt->execute();
    $medicines_result = $stmt->get_result();
    $total_medicines = $medicines_result->num_rows;
} else {
    $error_message = "Error preparing query: " . $conn->error;
    $total_medicines = 0;
    $medicines_result = null;
}

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

// Get statistics for this supplier
$stats_query = "
    SELECT 
        COUNT(*) as total_medicines,
        SUM(m.stock_quantity) as total_stock,
        SUM(m.stock_quantity * m.cost_price) as total_inventory_value,
        SUM(m.stock_quantity * m.selling_price) as total_selling_value,
        SUM(CASE WHEN m.schedule_type IN ('H1', 'H', 'X') THEN 1 ELSE 0 END) as schedule_drugs,
        SUM(CASE WHEN m.requires_prescription = 1 THEN 1 ELSE 0 END) as prescription_drugs,
        COUNT(CASE WHEN DATEDIFF(m.expiry_date, CURDATE()) <= 90 THEN 1 END) as expiring_soon,
        COUNT(CASE WHEN m.stock_quantity <= m.min_stock_level THEN 1 END) as low_stock
    FROM medicines m
    WHERE m.supplier_id = ?
";

$stats_stmt = $conn->prepare($stats_query);
$stats_stmt->bind_param("i", $supplier_id);
$stats_stmt->execute();
$stats_result = $stats_stmt->get_result();
$stats = $stats_result->fetch_assoc();

// Get purchase history summary
$purchase_summary_query = "
    SELECT 
        COUNT(DISTINCT po.id) as total_orders,
        SUM(pi.quantity) as total_items_purchased,
        SUM(pi.subtotal) as total_purchase_value,
        MAX(po.purchase_date) as last_purchase_date
    FROM purchase_orders po
    JOIN purchase_items pi ON po.id = pi.purchase_id
    JOIN medicines m ON pi.medicine_id = m.id
    WHERE po.supplier_id = ?
    AND po.status = 'completed'
";

$purchase_stmt = $conn->prepare($purchase_summary_query);
$purchase_stmt->bind_param("i", $supplier_id);
$purchase_stmt->execute();
$purchase_summary = $purchase_stmt->get_result()->fetch_assoc();

// Close statements
if (isset($supplier_stmt)) $supplier_stmt->close();
if (isset($stmt)) $stmt->close();
if (isset($stats_stmt)) $stats_stmt->close();
if (isset($purchase_stmt)) $purchase_stmt->close();
?>

<?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-12">
                        <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                            <h4 class="mb-sm-0">Supplier Medicines</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li>
                                    <li class="breadcrumb-item"><a href="suppliers-list.php">Suppliers</a></li>
                                    <li class="breadcrumb-item active"><?php echo htmlspecialchars($supplier['supplier_name']); ?></li>
                                </ol>
                            </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-start">
                                    <div>
                                        <h4 class="card-title mb-3"><?php echo htmlspecialchars($supplier['supplier_name']); ?></h4>
                                        <div class="row">
                                            <div class="col-md-6">
                                                <?php if (!empty($supplier['contact_person'])): ?>
                                                    <p class="mb-1"><strong>Contact Person:</strong> <?php echo htmlspecialchars($supplier['contact_person']); ?></p>
                                                <?php endif; ?>
                                                <?php if (!empty($supplier['phone'])): ?>
                                                    <p class="mb-1"><strong>Phone:</strong> <?php echo htmlspecialchars($supplier['phone']); ?></p>
                                                <?php endif; ?>
                                                <?php if (!empty($supplier['email'])): ?>
                                                    <p class="mb-1"><strong>Email:</strong> <?php echo htmlspecialchars($supplier['email']); ?></p>
                                                <?php endif; ?>
                                            </div>
                                            <div class="col-md-6">
                                                <?php if (!empty($supplier['gst_number'])): ?>
                                                    <p class="mb-1"><strong>GST Number:</strong> <?php echo htmlspecialchars($supplier['gst_number']); ?></p>
                                                <?php endif; ?>
                                                <?php if (!empty($supplier['address'])): ?>
                                                    <p class="mb-1"><strong>Address:</strong> <?php echo nl2br(htmlspecialchars($supplier['address'])); ?></p>
                                                <?php endif; ?>
                                            </div>
                                        </div>
                                    </div>
                                    <div class="text-end">
                                        <span class="badge bg-<?php echo $supplier['status'] == 'active' ? 'success' : 'secondary'; ?> fs-6">
                                            <?php echo $supplier['status'] == 'active' ? 'Active' : 'Inactive'; ?>
                                        </span>
                                        <div class="mt-2">
                                            <a href="edit-supplier.php?id=<?php echo $supplier_id; ?>" class="btn btn-sm btn-outline-primary">
                                                <i class="mdi mdi-pencil me-1"></i> Edit Supplier
                                            </a>
                                            <a href="suppliers-list.php" class="btn btn-sm btn-outline-secondary">
                                                <i class="mdi mdi-arrow-left me-1"></i> Back to List
                                            </a>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-xl-2 col-md-3 col-sm-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 $stats['total_medicines'] ?? 0; ?></h4>
                                        <p class="text-muted mb-0">Total Medicines</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-3 col-sm-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 $stats['total_stock'] ?? 0; ?></h4>
                                        <p class="text-muted mb-0">Total Stock</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-package-variant font-size-24 text-info"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-2 col-md-3 col-sm-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 $purchase_summary['total_orders'] ?? 0; ?></h4>
                                        <p class="text-muted mb-0">Total Orders</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-cart font-size-24 text-success"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-2 col-md-3 col-sm-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 $stats['schedule_drugs'] ?? 0; ?></h4>
                                        <p class="text-muted mb-0">Schedule Drugs</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-alert-circle font-size-24 text-warning"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-2 col-md-3 col-sm-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 $stats['low_stock'] ?? 0; ?></h4>
                                        <p class="text-muted mb-0">Low Stock</p>
                                    </div>
                                    <div class="flex-shrink-0">
                                        <i class="mdi mdi-alert font-size-24 text-danger"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                    
                    <div class="col-xl-2 col-md-3 col-sm-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 $stats['expiring_soon'] ?? 0; ?></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-orange"></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">Medicines from <?php echo htmlspecialchars($supplier['supplier_name']); ?></h4>
                                    <div>
                                        <button type="button" class="btn btn-outline-info me-2" onclick="printSupplierMedicinesReport()">
                                            <i class="mdi mdi-printer me-1"></i> Print Report
                                        </button>
                                        <a href="add-medicine.php?supplier=<?php echo $supplier_id; ?>" class="btn btn-primary">
                                            <i class="mdi mdi-plus me-1"></i> Add Medicine
                                        </a>
                                    </div>
                                </div>

<form method="GET" action="" class="row g-2 mb-4">
                                    <input type="hidden" name="id" value="<?php echo $supplier_id; ?>">
                                    <div class="col-md-3">
                                        <input type="text" class="form-control" name="search" placeholder="Search medicines..." value="<?php echo htmlspecialchars($search); ?>">
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" name="category_filter">
                                            <option value="">All Categories</option>
                                            <?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; ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" name="status_filter">
                                            <option value="">All Status</option>
                                            <option value="active" <?php echo $status_filter === 'active' ? 'selected' : ''; ?>>Active</option>
                                            <option value="inactive" <?php echo $status_filter === 'inactive' ? 'selected' : ''; ?>>Inactive</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" name="schedule_filter">
                                            <option value="">All Schedules</option>
                                            <option value="G" <?php echo $schedule_filter === 'G' ? 'selected' : ''; ?>>General</option>
                                            <option value="H1" <?php echo $schedule_filter === 'H1' ? 'selected' : ''; ?>>Schedule H1/H</option>
                                            <option value="X" <?php echo $schedule_filter === 'X' ? 'selected' : ''; ?>>Schedule X</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <button type="submit" class="btn btn-primary w-100">
                                            <i class="mdi mdi-filter"></i> Filter
                                        </button>
                                    </div>
                                    <div class="col-md-1">
                                        <a href="supplier-medicines.php?id=<?php echo $supplier_id; ?>" class="btn btn-secondary w-100">
                                            <i class="mdi mdi-refresh"></i>
                                        </a>
                                    </div>
                                </form>

<?php if ($total_medicines == 0): ?>
                                    <div class="alert alert-info text-center">
                                        <h5>No Medicines Found</h5>
                                        <p>No medicines found from this supplier. Add your first medicine to get started.</p>
                                        <a href="add-medicine.php?supplier=<?php echo $supplier_id; ?>" class="btn btn-primary mt-2">
                                            <i class="mdi mdi-plus me-1"></i> Add Medicine
                                        </a>
                                    </div>
                                <?php else: ?>
                                    <div class="table-responsive">
                                        <table class="table table-centered table-nowrap mb-0" id="medicinesTable">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>Medicine Name</th>
                                                    <th>Batch</th>
                                                    <th>Category</th>
                                                    <th>Stock</th>
                                                    <th>Price</th>
                                                    <th>Schedule</th>
                                                    <th>Expiry</th>
                                                    <th>Status</th>
                                                    <th>Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php while ($medicine = $medicines_result->fetch_assoc()): ?>
                                                    <?php
                                                    // Format schedule type
                                                    $schedule_badge = '';
                                                    if (!empty($medicine['schedule_type'])) {
                                                        $badge_class = '';
                                                        switch ($medicine['schedule_type']) {
                                                            case 'H1':
                                                            case 'H':
                                                                $badge_class = 'bg-warning';
                                                                $schedule_text = 'H1';
                                                                break;
                                                            case 'X':
                                                                $badge_class = 'bg-danger';
                                                                $schedule_text = 'X';
                                                                break;
                                                            default:
                                                                $badge_class = 'bg-info';
                                                                $schedule_text = $medicine['schedule_type'];
                                                        }
                                                        $schedule_badge = '<span class="badge ' . $badge_class . '">' . $schedule_text . '</span>';
                                                    }
                                                    
                                                    // Format expiry date
                                                    $expiry_class = '';
                                                    $expiry_text = date('d M Y', strtotime($medicine['expiry_date']));
                                                    if ($medicine['days_to_expiry'] <= 0) {
                                                        $expiry_class = 'text-danger';
                                                        $expiry_text .= ' <span class="badge bg-danger">Expired</span>';
                                                    } elseif ($medicine['days_to_expiry'] <= 90) {
                                                        $expiry_class = 'text-warning';
                                                        $expiry_text .= ' <span class="badge bg-warning">Soon</span>';
                                                    }
                                                    
                                                    // Format stock status
                                                    $stock_class = '';
                                                    $stock_text = $medicine['stock_quantity'];
                                                    if ($medicine['stock_quantity'] <= $medicine['min_stock_level']) {
                                                        $stock_class = 'text-danger';
                                                        $stock_text .= ' <span class="badge bg-danger">Low</span>';
                                                    } elseif ($medicine['stock_quantity'] == 0) {
                                                        $stock_class = 'text-danger';
                                                        $stock_text .= ' <span class="badge bg-danger">Out</span>';
                                                    }
                                                    
                                                    // Status badge
                                                    $status_badge = $medicine['status'] == 'active' ? 
                                                        '<span class="badge bg-success">Active</span>' : 
                                                        '<span class="badge bg-secondary">Inactive</span>';
                                                    ?>
                                                    <tr>
                                                        <td>
                                                            <strong><?php echo htmlspecialchars($medicine['medicine_name']); ?></strong>
                                                            <?php if (!empty($medicine['generic_name'])): ?>
                                                                <br><small class="text-muted"><?php echo htmlspecialchars($medicine['generic_name']); ?></small>
                                                            <?php endif; ?>
                                                            <?php if ($medicine['requires_prescription']): ?>
                                                                <br><small class="badge bg-info">Rx Required</small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td><?php echo htmlspecialchars($medicine['batch_number']); ?></td>
                                                        <td><?php echo htmlspecialchars($medicine['category_name']); ?></td>
                                                        <td class="<?php echo $stock_class; ?>">
                                                            <?php echo $stock_text; ?>
                                                            <?php if ($medicine['total_purchased'] > 0): ?>
                                                                <br><small class="text-muted">Purchased: <?php echo $medicine['total_purchased']; ?></small>
                                                            <?php endif; ?>
                                                            <?php if ($medicine['total_sold'] > 0): ?>
                                                                <br><small class="text-muted">Sold: <?php echo $medicine['total_sold']; ?></small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td>
                                                            <strong>₹<?php echo number_format($medicine['selling_price'], 2); ?></strong>
                                                            <br><small class="text-muted">Cost: ₹<?php echo number_format($medicine['cost_price'], 2); ?></small>
                                                            <br><small class="text-muted">MRP: ₹<?php echo number_format($medicine['mrp'], 2); ?></small>
                                                        </td>
                                                        <td><?php echo $schedule_badge; ?></td>
                                                        <td class="<?php echo $expiry_class; ?>">
                                                            <?php echo $expiry_text; ?>
                                                            <?php if ($medicine['days_to_expiry'] > 0): ?>
                                                                <br><small class="text-muted"><?php echo $medicine['days_to_expiry']; ?> days left</small>
                                                            <?php endif; ?>
                                                        </td>
                                                        <td><?php echo $status_badge; ?></td>
                                                        <td>
                                                            <div class="d-flex gap-1">
                                                                <a href="edit-medicine.php?id=<?php echo $medicine['id']; ?>" class="btn btn-sm btn-outline-primary" title="Edit">
                                                                    <i class="mdi mdi-pencil"></i>
                                                                </a>
                                                                <a href="medicine-details.php?id=<?php echo $medicine['id']; ?>" class="btn btn-sm btn-outline-info" title="View Details">
                                                                    <i class="mdi mdi-eye"></i>
                                                                </a>
                                                                <a href="purchase-medicine.php?medicine=<?php echo $medicine['id']; ?>&supplier=<?php echo $supplier_id; ?>" class="btn btn-sm btn-outline-success" title="Purchase">
                                                                    <i class="mdi mdi-cart-plus"></i>
                                                                </a>
                                                            </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) from this supplier
                                                    <?php if (!empty($search) || !empty($category_filter) || !empty($status_filter) || !empty($schedule_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>
                                                    <?php if ($stats['total_inventory_value'] > 0): ?>
                                                        <span class="badge bg-success fs-6">
                                                            Inventory Value: ₹<?php echo number_format($stats['total_inventory_value'], 2); ?>
                                                        </span>
                                                    <?php endif; ?>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>

<?php if (!empty($purchase_summary['total_orders']) && $purchase_summary['total_orders'] > 0): ?>
                <div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Purchase History</h4>
                                <div class="table-responsive">
                                    <table class="table table-centered table-nowrap mb-0">
                                        <thead class="table-light">
                                            <tr>
                                                <th>Summary</th>
                                                <th>Value</th>
                                                <th>Details</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <tr>
                                                <td>Total Orders</td>
                                                <td><strong><?php echo $purchase_summary['total_orders']; ?></strong> orders</td>
                                                <td><a href="purchase-history.php?supplier=<?php echo $supplier_id; ?>" class="btn btn-sm btn-outline-primary">View All Orders</a></td>
                                            </tr>
                                            <tr>
                                                <td>Total Items Purchased</td>
                                                <td><strong><?php echo $purchase_summary['total_items_purchased']; ?></strong> items</td>
                                                <td>Average: <?php echo round($purchase_summary['total_items_purchased'] / $purchase_summary['total_orders']); ?> items per order</td>
                                            </tr>
                                            <tr>
                                                <td>Total Purchase Value</td>
                                                <td><strong>₹<?php echo number_format($purchase_summary['total_purchase_value'], 2); ?></strong></td>
                                                <td>Average: ₹<?php echo number_format($purchase_summary['total_purchase_value'] / $purchase_summary['total_orders'], 2); ?> per order</td>
                                            </tr>
                                            <tr>
                                                <td>Last Purchase</td>
                                                <td><strong><?php echo date('d M Y', strtotime($purchase_summary['last_purchase_date'])); ?></strong></td>
                                                <td><?php echo date('l', strtotime($purchase_summary['last_purchase_date'])); ?></td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <?php endif; ?>

</div>
            
        </div>

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

</div>

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

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

// Print supplier medicines report
    function printSupplierMedicinesReport() {
        const printContent = document.getElementById('medicinesTable').outerHTML;
        const originalContent = document.body.innerHTML;
        
        document.body.innerHTML = `
            <html>
                <head>
                    <title>Medicines Report - <?php echo htmlspecialchars($supplier['supplier_name']); ?></title>
                    <style>
                        body { font-family: Arial, sans-serif; }
                        table { width: 100%; border-collapse: collapse; margin-top: 20px; }
                        th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }
                        th { background-color: #f2f2f2; font-weight: bold; }
                        .badge { padding: 3px 8px; border-radius: 4px; color: white; font-size: 12px; }
                        .bg-success { background-color: #28a745; }
                        .bg-secondary { background-color: #6c757d; }
                        .bg-primary { background-color: #007bff; }
                        .bg-warning { background-color: #ffc107; }
                        .bg-danger { background-color: #dc3545; }
                        .bg-info { background-color: #17a2b8; }
                        @media print {
                            .no-print { display: none; }
                        }
                    </style>
                </head>
                <body>
                    <h2>Medicines from <?php echo htmlspecialchars($supplier['supplier_name']); ?></h2>
                    <p>Supplier: <?php echo htmlspecialchars($supplier['supplier_name']); ?></p>
                    <p>Contact: <?php echo htmlspecialchars($supplier['phone'] ?? 'N/A'); ?> | Email: <?php echo htmlspecialchars($supplier['email'] ?? 'N/A'); ?></p>
                    <p>Total Medicines: <?php echo $total_medicines; ?> | Total Stock: <?php echo $stats['total_stock'] ?? 0; ?> | Inventory Value: ₹<?php echo number_format($stats['total_inventory_value'] ?? 0, 2); ?></p>
                    <p>Report Date: <?php echo date('Y-m-d'); ?></p>
                    ${printContent}
                    <div class="no-print">
                        <button onclick="window.print()" style="padding: 10px 20px; margin: 20px; background: #007bff; color: white; border: none; cursor: pointer;">Print</button>
                        <button onclick="window.close()" style="padding: 10px 20px; margin: 20px; background: #6c757d; color: white; border: none; cursor: pointer;">Close</button>
                    </div>
                </body>
            </html>
        `;
        
        window.print();
        document.body.innerHTML = originalContent;
        location.reload();
    }

// Quick search functionality
    document.addEventListener('DOMContentLoaded', function() {
        const searchInput = document.querySelector('input[name="search"]');
        if (searchInput) {
            searchInput.addEventListener('keyup', function(e) {
                if (e.key === 'Enter') {
                    e.target.form.submit();
                }
            });
        }
    });
</script>

</body>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: supplier-medicines.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation