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/footwear

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: purchase-details.php

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

// Check if user is logged in
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}

$purchase_id = isset($_GET['id']) ? intval($_GET['id']) : 0;

// Fetch purchase details
$query = "SELECT p.*, s.supplier_name, s.phone as supplier_phone, s.email as supplier_email, 
          s.address as supplier_address, s.gst_number, s.company_name,
          u.email as created_by_email
          FROM purchases p
          LEFT JOIN suppliers s ON p.supplier_id = s.id
          LEFT JOIN users u ON p.created_by = u.id
          WHERE p.id = $purchase_id";

$result = mysqli_query($conn, $query);
$purchase = mysqli_fetch_assoc($result);

if (!$purchase) {
    $_SESSION['error'] = "Purchase not found!";
    header("Location: purchase-list.php");
    exit();
}

// Fetch purchase items with product details
$itemsQuery = "SELECT pi.*, pr.product_name, pr.product_code, b.brand_name, 
               pr.color, pr.size, pr.category_id, c.category_name,
               pr.customer_price as selling_price
               FROM purchase_items pi
               LEFT JOIN products pr ON pi.product_id = pr.id
               LEFT JOIN brands b ON pr.brand_id = b.id
               LEFT JOIN categories c ON pr.category_id = c.id
               WHERE pi.purchase_id = $purchase_id
               ORDER BY pi.id";
$itemsResult = mysqli_query($conn, $itemsQuery);

// Calculate totals
$total_items = 0;
$total_quantity = 0;
$items_total = 0;
$itemsArray = [];

while ($item = mysqli_fetch_assoc($itemsResult)) {
    $itemsArray[] = $item;
    $total_items++;
    $total_quantity += $item['quantity'];
    $items_total += $item['total_price'];
}
?>

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

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

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

<div id="layout-wrapper">

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

<div class="vertical-menu">
    <div data-simplebar class="h-100">
        <?php include('includes/sidebar.php'); ?>
    </div>
</div>

<div class="main-content">
    <div class="page-content">
        <div class="container-fluid">

<?php if (isset($_SESSION['success'])): ?>
                <div class="alert alert-success alert-dismissible fade show" role="alert">
                    <?php echo htmlspecialchars($_SESSION['success']); ?>
                    <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                </div>
                <?php unset($_SESSION['success']); ?>
            <?php endif; ?>
            
            <?php if (isset($_SESSION['error'])): ?>
                <div class="alert alert-danger alert-dismissible fade show" role="alert">
                    <?php echo htmlspecialchars($_SESSION['error']); ?>
                    <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                </div>
                <?php unset($_SESSION['error']); ?>
            <?php endif; ?>

<div class="row">
                <div class="col-xl-12">
                    <div class="card">
                        <div class="card-body">
                            
                            <div class="row mb-4">
                                <div class="col-md-6">
                                    <h5 class="text-primary border-bottom pb-2 mb-3">Purchase Information</h5>
                                    <table class="table table-sm table-borderless">
                                        <tr>
                                            <td width="40%"><strong>Reference No:</strong></td>
                                            <td>
                                                <span class="badge bg-primary fs-6"><?php echo htmlspecialchars($purchase['reference_no']); ?></span>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td><strong>Purchase Date:</strong></td>
                                            <td><?php echo date('d/m/Y', strtotime($purchase['purchase_date'])); ?></td>
                                        </tr>
                                        <tr>
                                            <td><strong>Payment Method:</strong></td>
                                            <td>
                                                <span class="badge bg-info">
                                                    <?php echo ucfirst($purchase['payment_method']); ?>
                                                </span>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td><strong>Total Amount:</strong></td>
                                            <td><h5 class="text-success mb-0">₹ <?php echo number_format($purchase['total_amount'], 2); ?></h5></td>
                                        </tr>
                                        <tr>
                                            <td><strong>Created By:</strong></td>
                                            <td><?php echo htmlspecialchars($purchase['created_by_email']); ?></td>
                                        </tr>
                                        <tr>
                                            <td><strong>Created At:</strong></td>
                                            <td><?php echo date('d/m/Y h:i A', strtotime($purchase['created_at'])); ?></td>
                                        </tr>
                                    </table>
                                </div>
                                <div class="col-md-6">
                                    <h5 class="text-primary border-bottom pb-2 mb-3">Supplier Information</h5>
                                    <table class="table table-sm table-borderless">
                                        <tr>
                                            <td width="40%"><strong>Supplier:</strong></td>
                                            <td>
                                                <h6 class="mb-0"><?php echo htmlspecialchars($purchase['supplier_name']); ?></h6>
                                                <?php if (!empty($purchase['company_name'])): ?>
                                                    <small class="text-muted"><?php echo htmlspecialchars($purchase['company_name']); ?></small>
                                                <?php endif; ?>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td><strong>Phone:</strong></td>
                                            <td>
                                                <a href="tel:<?php echo htmlspecialchars($purchase['supplier_phone']); ?>" class="text-decoration-none">
                                                    <i class="fas fa-phone me-1"></i><?php echo htmlspecialchars($purchase['supplier_phone']); ?>
                                                </a>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td><strong>Email:</strong></td>
                                            <td>
                                                <?php if (!empty($purchase['supplier_email'])): ?>
                                                    <a href="mailto:<?php echo htmlspecialchars($purchase['supplier_email']); ?>" class="text-decoration-none">
                                                        <i class="fas fa-envelope me-1"></i><?php echo htmlspecialchars($purchase['supplier_email']); ?>
                                                    </a>
                                                <?php else: ?>
                                                    <span class="text-muted">Not provided</span>
                                                <?php endif; ?>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td><strong>GST Number:</strong></td>
                                            <td><?php echo !empty($purchase['gst_number']) ? htmlspecialchars($purchase['gst_number']) : '<span class="text-muted">Not provided</span>'; ?></td>
                                        </tr>
                                        <tr>
                                            <td><strong>Address:</strong></td>
                                            <td><?php echo !empty($purchase['supplier_address']) ? htmlspecialchars($purchase['supplier_address']) : '<span class="text-muted">Not provided</span>'; ?></td>
                                        </tr>
                                    </table>
                                </div>
                            </div>

<div class="row">
                                <div class="col-12">
                                    <h5 class="text-primary border-bottom pb-2 mb-3">Purchase Items</h5>
                                    <div class="table-responsive">
                                        <table class="table table-bordered table-hover">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>#</th>
                                                    <th>Product</th>
                                                    <th>Code</th>
                                                    <th>Brand</th>
                                                    <th>Category</th>
                                                    <th>Color/Size</th>
                                                    <th class="text-end">Quantity</th>
                                                    <th class="text-end">Unit Cost</th>
                                                    <th class="text-end">Selling Price</th>
                                                    <th class="text-end">Total Cost</th>
                                                    <th class="text-end">Profit</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php if (!empty($itemsArray)): ?>
                                                    <?php $counter = 1; $total_cost = 0; $total_profit = 0; ?>
                                                    <?php foreach ($itemsArray as $item): ?>
                                                        <?php 
                                                        $item_total = $item['quantity'] * $item['unit_price'];
                                                        $selling_price = $item['selling_price'] ?? 0;
                                                        $selling_total = $item['quantity'] * $selling_price;
                                                        $item_profit = $selling_total - $item_total;
                                                        $total_cost += $item_total;
                                                        $total_profit += $item_profit;
                                                        ?>
                                                        <tr>
                                                            <td><?php echo $counter++; ?></td>
                                                            <td>
                                                                <strong><?php echo htmlspecialchars($item['product_name']); ?></strong>
                                                            </td>
                                                            <td>
                                                                <span class="badge bg-info"><?php echo htmlspecialchars($item['product_code'] ?? 'N/A'); ?></span>
                                                            </td>
                                                            <td>
                                                                <?php echo !empty($item['brand_name']) ? htmlspecialchars($item['brand_name']) : '<span class="text-muted">N/A</span>'; ?>
                                                            </td>
                                                            <td>
                                                                <?php echo !empty($item['category_name']) ? htmlspecialchars($item['category_name']) : '<span class="text-muted">N/A</span>'; ?>
                                                            </td>
                                                            <td>
                                                                <?php echo htmlspecialchars($item['color'] ?: 'N/A'); ?> / 
                                                                <?php echo htmlspecialchars($item['size'] ?: 'N/A'); ?>
                                                            </td>
                                                            <td class="text-end">
                                                                <span class="badge bg-primary"><?php echo $item['quantity']; ?></span>
                                                            </td>
                                                            <td class="text-end">₹ <?php echo number_format($item['unit_price'], 2); ?></td>
                                                            <td class="text-end">₹ <?php echo number_format($selling_price, 2); ?></td>
                                                            <td class="text-end">
                                                                <strong>₹ <?php echo number_format($item_total, 2); ?></strong>
                                                            </td>
                                                            <td class="text-end">
                                                                <span class="badge bg-<?php echo ($item_profit >= 0) ? 'success' : 'danger'; ?>">
                                                                    ₹ <?php echo number_format($item_profit, 2); ?>
                                                                </span>
                                                            </td>
                                                        </tr>
                                                    <?php endforeach; ?>
                                                <?php else: ?>
                                                    <tr>
                                                        <td colspan="11" class="text-center py-4">
                                                            <div class="text-muted">
                                                                <i class="fas fa-box-open fa-2x mb-3"></i>
                                                                <h5>No items found for this purchase</h5>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endif; ?>
                                            </tbody>
                                            <tfoot class="table-light">
                                                <tr>
                                                    <td colspan="6" class="text-end"><strong>Totals:</strong></td>
                                                    <td class="text-end">
                                                        <strong><?php echo $total_quantity; ?> units</strong>
                                                    </td>
                                                    <td class="text-end"></td>
                                                    <td class="text-end"></td>
                                                    <td class="text-end">
                                                        <h5 class="text-primary mb-0">₹ <?php echo number_format($total_cost, 2); ?></h5>
                                                    </td>
                                                    <td class="text-end">
                                                        <h5 class="text-<?php echo ($total_profit >= 0) ? 'success' : 'danger'; ?> mb-0">
                                                            ₹ <?php echo number_format($total_profit, 2); ?>
                                                        </h5>
                                                    </td>
                                                </tr>
                                            </tfoot>
                                        </table>
                                    </div>
                                </div>
                            </div>

<div class="row mt-4">
                                <div class="col-md-12">
                                    <div class="card">
                                        <div class="card-body">
                                            <h5 class="text-primary border-bottom pb-2 mb-3">Additional Information</h5>
                                            <div class="row">
                                                <div class="col-md-6">
                                                    <h6><i class="fas fa-sticky-note me-2"></i>Notes:</h6>
                                                    <div class="p-3 bg-light rounded">
                                                        <?php if (!empty($purchase['notes'])): ?>
                                                            <?php echo nl2br(htmlspecialchars($purchase['notes'])); ?>
                                                        <?php else: ?>
                                                            <span class="text-muted">No notes provided</span>
                                                        <?php endif; ?>
                                                    </div>
                                                </div>
                                                <div class="col-md-6">
                                                    <h6><i class="fas fa-info-circle me-2"></i>Summary:</h6>
                                                    <div class="p-3 bg-light rounded">
                                                        <ul class="list-unstyled mb-0">
                                                            <li><strong>Total Items:</strong> <?php echo $total_items; ?></li>
                                                            <li><strong>Total Quantity:</strong> <?php echo $total_quantity; ?></li>
                                                            <li><strong>Total Cost:</strong> ₹ <?php echo number_format($total_cost, 2); ?></li>
                                                            <li><strong>Estimated Profit:</strong> ₹ <?php echo number_format($total_profit, 2); ?></li>
                                                            <li><strong>Profit Margin:</strong> 
                                                                <?php 
                                                                $margin = $total_cost > 0 ? ($total_profit / $total_cost * 100) : 0;
                                                                echo number_format($margin, 2) . '%';
                                                                ?>
                                                            </li>
                                                        </ul>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </div>

<div class="row mt-4">
                                <div class="col-md-12">
                                    <div class="d-flex justify-content-center gap-2">
                                        <a href="edit-purchase.php?id=<?php echo $purchase_id; ?>" class="btn btn-warning">
                                            <i class="fas fa-edit me-1"></i> Edit Purchase
                                        </a>
                                        <button type="button" class="btn btn-danger" onclick="confirmDelete()">
                                            <i class="fas fa-trash me-1"></i> Delete Purchase
                                        </button>
                                    </div>
                                </div>
                            </div>

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

</div>
    </div>

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

</div>

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

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: purchase-details.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation