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/ecommer.in/public_html/billing/medical

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: view-purchase.php

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

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

// Safety: ensure $conn is mysqli
if (!($conn instanceof mysqli)) {
    die("Database connection error. Check includes/db_connection.php");
}
$conn->set_charset("utf8mb4");
$conn->query("SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci");

// Helper to escape output
function e($v) { return htmlspecialchars($v ?? '', ENT_QUOTES, 'UTF-8'); }

// Get purchase ID
$purchase_id = isset($_GET['id']) ? (int)$_GET['id'] : 0;
if ($purchase_id <= 0) {
    header('Location: purchase-orders.php');
    exit;
}

// Fetch purchase details
$po_stmt = $conn->prepare("
    SELECT po.*, s.supplier_name, s.contact_person, s.phone as supplier_phone, 
           s.email as supplier_email, s.address as supplier_address, s.gst_number as supplier_gst
    FROM purchase_orders po
    LEFT JOIN suppliers s ON po.supplier_id = s.id
    WHERE po.id = ? AND po.status <> 'deleted'
    LIMIT 1
");
$po_stmt->bind_param("i", $purchase_id);
$po_stmt->execute();
$po_res = $po_stmt->get_result();
$purchase = $po_res->fetch_assoc();
$po_stmt->close();

if (!$purchase) {
    header('Location: purchase-orders.php');
    exit;
}

// Fetch purchase items
$items_stmt = $conn->prepare("
    SELECT pi.*, m.medicine_name, m.generic_name, m.composition, m.manufacturer, 
           m.rack_number as med_rack, m.box_number as med_box, m.hsn_code,
           c.category_name
    FROM purchase_items pi
    LEFT JOIN medicines m ON pi.medicine_id = m.id
    LEFT JOIN medicine_categories c ON m.category_id = c.id
    WHERE pi.purchase_id = ?
    ORDER BY pi.id ASC
");
$items_stmt->bind_param("i", $purchase_id);
$items_stmt->execute();
$items_res = $items_stmt->get_result();
$items = [];
while ($row = $items_res->fetch_assoc()) {
    $items[] = $row;
}
$items_stmt->close();

// Close connection
$conn->close();
?>

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

<div id="layout-wrapper">
    <?php include('includes/topbar.php'); ?>

<div class="row">
                    <div class="col-lg-8">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-start mb-4">
                                    <div>
                                        <h5 class="card-title mb-1">Purchase Order #<?php echo e($purchase['invoice_number']); ?></h5>
                                        <p class="text-muted mb-0">Date: <?php echo e($purchase['purchase_date']); ?></p>
                                    </div>
                                    <div>
                                        <span class="badge bg-<?php 
                                            if ($purchase['status'] === 'completed') echo 'success';
                                            elseif ($purchase['status'] === 'cancelled') echo 'danger';
                                            else echo 'warning';
                                        ?> fs-6"><?php echo strtoupper(e($purchase['status'])); ?></span>
                                    </div>
                                </div>

<div class="row mb-4">
                                    <div class="col-md-6">
                                        <h6 class="mb-3">Supplier Information</h6>
                                        <p class="mb-1"><strong><?php echo e($purchase['supplier_name']); ?></strong></p>
                                        <?php if (!empty($purchase['contact_person'])): ?>
                                            <p class="mb-1">Contact: <?php echo e($purchase['contact_person']); ?></p>
                                        <?php endif; ?>
                                        <?php if (!empty($purchase['supplier_phone'])): ?>
                                            <p class="mb-1">Phone: <?php echo e($purchase['supplier_phone']); ?></p>
                                        <?php endif; ?>
                                        <?php if (!empty($purchase['supplier_email'])): ?>
                                            <p class="mb-1">Email: <?php echo e($purchase['supplier_email']); ?></p>
                                        <?php endif; ?>
                                        <?php if (!empty($purchase['supplier_address'])): ?>
                                            <p class="mb-1">Address: <?php echo e($purchase['supplier_address']); ?></p>
                                        <?php endif; ?>
                                        <?php if (!empty($purchase['supplier_gst'])): ?>
                                            <p class="mb-1">GST: <?php echo e($purchase['supplier_gst']); ?></p>
                                        <?php endif; ?>
                                    </div>
                                    <div class="col-md-6">
                                        <h6 class="mb-3">Payment Information</h6>
                                        <p class="mb-1"><strong>Status:</strong> 
                                            <span class="badge bg-<?php 
                                                if ($purchase['payment_status'] === 'paid') echo 'success';
                                                elseif ($purchase['payment_status'] === 'partial') echo 'warning';
                                                else echo 'secondary';
                                            ?>"><?php echo strtoupper(e($purchase['payment_status'])); ?></span>
                                        </p>
                                        <p class="mb-1"><strong>Method:</strong> <?php echo e($purchase['payment_method']); ?></p>
                                        <p class="mb-1"><strong>Total Amount:</strong> ₹<?php echo number_format($purchase['total_amount'], 2); ?></p>
                                        <p class="mb-1"><strong>Tax Amount:</strong> ₹<?php echo number_format($purchase['tax_amount'], 2); ?></p>
                                        <p class="mb-1"><strong>Grand Total:</strong> ₹<?php echo number_format($purchase['grand_total'], 2); ?></p>
                                    </div>
                                </div>

<?php if (!empty($purchase['notes'])): ?>
                                <div class="mb-4">
                                    <h6>Notes</h6>
                                    <div class="border rounded p-3 bg-light">
                                        <?php echo nl2br(e($purchase['notes'])); ?>
                                    </div>
                                </div>
                                <?php endif; ?>

<h6 class="mb-3">Purchase Items (<?php echo count($items); ?>)</h6>
                                <div class="table-responsive">
                                    <table class="table table-bordered">
                                        <thead class="table-light">
                                            <tr>
                                                <th>#</th>
                                                <th>Medicine Name</th>
                                                <th>Batch No.</th>
                                                <th>Expiry Date</th>
                                                <th>Category</th>
                                                <th>Quantity</th>
                                                <th>Cost Price</th>
                                                <th>Selling Price</th>
                                                <th>MRP</th>
                                                <th>Tax %</th>
                                                <th>Subtotal</th>
                                                <th>Tax Amount</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php if (count($items) > 0): 
                                                $counter = 1;
                                                foreach ($items as $item): 
                                            ?>
                                            <tr>
                                                <td><?php echo $counter++; ?></td>
                                                <td>
                                                    <div><strong><?php echo e($item['medicine_name']); ?></strong></div>
                                                    <?php if (!empty($item['generic_name'])): ?>
                                                        <small class="text-muted"><?php echo e($item['generic_name']); ?></small>
                                                    <?php endif; ?>
                                                    <?php if (!empty($item['manufacturer'])): ?>
                                                        <div><small>Mfg: <?php echo e($item['manufacturer']); ?></small></div>
                                                    <?php endif; ?>
                                                </td>
                                                <td><?php echo e($item['batch_number']); ?></td>
                                                <td><?php echo e($item['expiry_date']); ?></td>
                                                <td><?php echo e($item['category_name'] ?? 'N/A'); ?></td>
                                                <td><?php echo e($item['quantity']); ?></td>
                                                <td>₹<?php echo number_format($item['cost_price'], 2); ?></td>
                                                <td>₹<?php echo number_format($item['selling_price'], 2); ?></td>
                                                <td>₹<?php echo number_format($item['mrp_price'], 2); ?></td>
                                                <td><?php echo number_format($item['tax_rate'], 2); ?>%</td>
                                                <td>₹<?php echo number_format($item['subtotal'], 2); ?></td>
                                                <td>₹<?php echo number_format($item['tax_amount'], 2); ?></td>
                                            </tr>
                                            <?php endforeach; else: ?>
                                            <tr>
                                                <td colspan="12" class="text-center">No items found</td>
                                            </tr>
                                            <?php endif; ?>
                                        </tbody>
                                        <tfoot class="table-light">
                                            <tr>
                                                <td colspan="9" class="text-end"><strong>Total:</strong></td>
                                                <td colspan="3">
                                                    <strong>₹<?php echo number_format($purchase['total_amount'], 2); ?></strong>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td colspan="9" class="text-end"><strong>Total Tax:</strong></td>
                                                <td colspan="3">
                                                    <strong>₹<?php echo number_format($purchase['tax_amount'], 2); ?></strong>
                                                </td>
                                            </tr>
                                            <tr class="table-active">
                                                <td colspan="9" class="text-end"><strong>Grand Total:</strong></td>
                                                <td colspan="3">
                                                    <strong class="fs-5">₹<?php echo number_format($purchase['grand_total'], 2); ?></strong>
                                                </td>
                                            </tr>
                                        </tfoot>
                                    </table>
                                </div>

<div class="d-flex gap-2 mt-4">
                                    <a href="purchase-list.php" class="btn btn-secondary">
                                        <i class="mdi mdi-arrow-left me-1"></i> Back to List
                                    </a>
                                    <a href="print-purchase.php?id=<?php echo $purchase_id; ?>" target="_blank" class="btn btn-outline-primary">
                                        <i class="mdi mdi-printer me-1"></i> Print
                                    </a>

</div>
                            </div>
                        </div>
                    </div>

<div class="col-lg-4">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-4">Summary</h5>
                                
                                <div class="mb-3">
                                    <label class="form-label">Purchase ID</label>
                                    <input type="text" class="form-control" value="#<?php echo e($purchase['id']); ?>" readonly>
                                </div>
                                
                                <div class="mb-3">
                                    <label class="form-label">Invoice Number</label>
                                    <input type="text" class="form-control" value="<?php echo e($purchase['invoice_number']); ?>" readonly>
                                </div>
                                
                                <div class="mb-3">
                                    <label class="form-label">Purchase Date</label>
                                    <input type="text" class="form-control" value="<?php echo e($purchase['purchase_date']); ?>" readonly>
                                </div>
                                
                                <div class="mb-3">
                                    <label class="form-label">Supplier</label>
                                    <input type="text" class="form-control" value="<?php echo e($purchase['supplier_name']); ?>" readonly>
                                </div>
                                
                                <div class="mb-3">
                                    <label class="form-label">Payment Status</label>
                                    <input type="text" class="form-control" value="<?php echo e($purchase['payment_status']); ?>" readonly>
                                </div>
                                
                                <div class="mb-3">
                                    <label class="form-label">Payment Method</label>
                                    <input type="text" class="form-control" value="<?php echo e($purchase['payment_method']); ?>" readonly>
                                </div>
                                
                                <div class="mb-3">
                                    <label class="form-label">Order Status</label>
                                    <input type="text" class="form-control" value="<?php echo e($purchase['status']); ?>" readonly>
                                </div>
                                
                                <hr>
                                
                                <div class="d-flex justify-content-between mb-2">
                                    <span>Total Items:</span>
                                    <span><?php echo count($items); ?></span>
                                </div>
                                
                                <div class="d-flex justify-content-between mb-2">
                                    <span>Total Amount:</span>
                                    <span>₹<?php echo number_format($purchase['total_amount'], 2); ?></span>
                                </div>
                                
                                <div class="d-flex justify-content-between mb-2">
                                    <span>Tax Amount:</span>
                                    <span>₹<?php echo number_format($purchase['tax_amount'], 2); ?></span>
                                </div>
                                
                                <div class="d-flex justify-content-between mb-3">
                                    <span><strong>Grand Total:</strong></span>
                                    <span><strong>₹<?php echo number_format($purchase['grand_total'], 2); ?></strong></span>
                                </div>
                                
                                <div class="d-grid gap-2">
                                    <a href="edit-purchase.php?id=<?php echo $purchase_id; ?>" class="btn btn-primary">
                                        <i class="mdi mdi-pencil me-1"></i> Edit Purchase
                                    </a>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

</div>
        </div>

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

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

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view-purchase.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation