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/vkmobiles/admin

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: sales-view.php

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

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

<div id="layout-wrapper">

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

<div class="vertical-menu">

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

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

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

// Check if sale ID is provided
                if (!isset($_GET['id']) || empty($_GET['id'])) {
                    echo '<div class="alert alert-danger">Sale ID is required.</div>';
                    include('includes/footer.php');
                    exit();
                }

$sale_id = intval($_GET['id']);

// Get sale details
                $sale_sql = "SELECT s.*, c.customer_name, c.customer_phone, c.customer_email, c.customer_address 
                            FROM sales s 
                            LEFT JOIN customers c ON s.customer_id = c.id 
                            WHERE s.id = $sale_id";
                $sale_result = $conn->query($sale_sql);

if ($sale_result->num_rows == 0) {
                    echo '<div class="alert alert-danger">Sale not found.</div>';
                    include('includes/footer.php');
                    exit();
                }

$sale = $sale_result->fetch_assoc();

// Get sale items with brand information
                $items_sql = "SELECT si.*, p.product_name, p.model, p.imei_number_1, p.imei_number_2, p.serial_number, p.warranty_period, b.brand_name
                             FROM sale_items si 
                             JOIN products p ON si.product_id = p.id 
                             LEFT JOIN brands b ON p.brand_id = b.id
                             WHERE si.sale_id = $sale_id";
                $items_result = $conn->query($items_sql);

// Get credit payment information if any
                $credit_sql = "SELECT * FROM credit_payments WHERE sale_id = $sale_id";
                $credit_result = $conn->query($credit_sql);
                $credit_info = $credit_result->num_rows > 0 ? $credit_result->fetch_assoc() : null;

// Get payment transactions
                $transactions_sql = "SELECT * FROM credit_payment_transactions WHERE credit_payment_id IN (SELECT id FROM credit_payments WHERE sale_id = $sale_id) ORDER BY payment_date DESC";
                $transactions_result = $conn->query($transactions_sql);

// Get returns for this sale with brand information
                $returns_sql = "SELECT sr.*, p.product_name, p.model, b.brand_name 
                               FROM sales_returns sr 
                               JOIN products p ON sr.product_id = p.id 
                               LEFT JOIN brands b ON p.brand_id = b.id
                               WHERE sr.sale_id = $sale_id 
                               ORDER BY sr.return_date DESC";
                $returns_result = $conn->query($returns_sql);
                ?>

<div class="row mb-3 d-block d-lg-none">
                    <div class="col-12">
                        <div class="d-flex justify-content-between align-items-center">
                            <h4 class="mb-0">Sale #<?php echo $sale['sale_number']; ?></h4>
                            <div class="dropdown">
                                <button class="btn btn-primary dropdown-toggle" type="button" data-bs-toggle="dropdown">
                                    <i class="fas fa-cog"></i>
                                </button>
                                <ul class="dropdown-menu">
                                    <li><a class="dropdown-item" href="sales-receipt.php?id=<?php echo $sale_id; ?>" target="_blank"><i class="fas fa-print me-2"></i>Print Receipt</a></li>
                                    <?php if ($sale['status'] == 'completed'): ?>
                                        <li><a class="dropdown-item" href="#" data-bs-toggle="modal" data-bs-target="#returnModal"><i class="fas fa-undo me-2"></i>Process Return</a></li>
                                        <li><a class="dropdown-item" href="#" data-bs-toggle="modal" data-bs-target="#cancelModal"><i class="fas fa-times me-2"></i>Cancel Sale</a></li>
                                    <?php endif; ?>
                                    
                                    <li><a class="dropdown-item" href="sales-new.php"><i class="fas fa-arrow-left me-2"></i>Back to New Sale</a></li>
                                </ul>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mb-3 d-none d-lg-flex">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Sale Details - <?php echo $sale['sale_number']; ?></h4>
                            <div class="d-flex gap-2">
                                <a href="sales-receipt.php?id=<?php echo $sale_id; ?>" class="btn btn-success" target="_blank">
                                    <i class="fas fa-print me-2"></i>Print Receipt
                                </a>
                                <?php if ($sale['status'] == 'completed'): ?>
                                    <button type="button" class="btn btn-warning" data-bs-toggle="modal" data-bs-target="#returnModal">
                                        <i class="fas fa-undo me-2"></i>Process Return
                                    </button>
                                <?php endif; ?>
                                <?php if ($sale['status'] == 'completed'): ?>
                                    <button type="button" class="btn btn-outline-danger" data-bs-toggle="modal" data-bs-target="#cancelModal">
                                        <i class="fas fa-times me-2"></i>Cancel Sale
                                    </button>
                                <?php endif; ?>
                                
                                <a href="sales-new.php" class="btn btn-secondary">
                                    <i class="fas fa-arrow-left me-2"></i>Back to New Sale
                                </a>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    
                    <div class="col-lg-8 mb-4">
                        
                        <div class="card mb-3">
                            <div class="card-header bg-light">
                                <h6 class="card-title mb-0">
                                    <i class="fas fa-info-circle me-2"></i>Sale Summary
                                </h6>
                            </div>
                            <div class="card-body">
                                <div class="row">
                                    <div class="col-6 col-sm-3 mb-2">
                                        <small class="text-muted d-block">Sale Number</small>
                                        <strong><?php echo $sale['sale_number']; ?></strong>
                                    </div>
                                    <div class="col-6 col-sm-3 mb-2">
                                        <small class="text-muted d-block">Sale Date</small>
                                        <strong><?php echo date('M j, Y', strtotime($sale['sale_date'])); ?></strong>
                                    </div>
                                    <div class="col-6 col-sm-3 mb-2">
                                        <small class="text-muted d-block">Status</small>
                                        <span class="badge bg-<?php echo $sale['status'] == 'completed' ? 'success' : ($sale['status'] == 'cancelled' ? 'danger' : 'warning'); ?>">
                                            <?php echo ucfirst($sale['status']); ?>
                                        </span>
                                    </div>
                                    <div class="col-6 col-sm-3 mb-2">
                                        <small class="text-muted d-block">Payment</small>
                                        <span class="badge bg-<?php echo $sale['payment_status'] == 'paid' ? 'success' : ($sale['payment_status'] == 'partial' ? 'warning' : 'danger'); ?>">
                                            <?php echo ucfirst($sale['payment_status']); ?>
                                        </span>
                                    </div>
                                </div>
                                <div class="row mt-2">
                                    <div class="col-6 col-sm-3 mb-2">
                                        <small class="text-muted d-block">Total</small>
                                        <strong class="text-success">₹<?php echo number_format($sale['total_amount'], 2); ?></strong>
                                    </div>
                                    <div class="col-6 col-sm-3 mb-2">
                                        <small class="text-muted d-block">Paid</small>
                                        <strong class="text-primary">₹<?php echo number_format($sale['paid_amount'], 2); ?></strong>
                                    </div>
                                    <div class="col-6 col-sm-3 mb-2">
                                        <small class="text-muted d-block">Due</small>
                                        <strong class="text-danger">₹<?php echo number_format($sale['due_amount'], 2); ?></strong>
                                    </div>
                                    <div class="col-6 col-sm-3 mb-2">
                                        <small class="text-muted d-block">Payment Type</small>
                                        <strong><?php echo ucwords(str_replace('_', ' ', $sale['payment_type'])); ?></strong>
                                    </div>
                                </div>
                            </div>
                        </div>

<div class="card mb-3">
                            <div class="card-header bg-light">
                                <h6 class="card-title mb-0">
                                    <i class="fas fa-shopping-cart me-2"></i>Products Sold
                                    <span class="badge bg-primary ms-2"><?php echo $items_result->num_rows; ?></span>
                                </h6>
                            </div>
                            <div class="card-body p-0">
                                
                                <div class="table-responsive d-none d-md-block">
                                    <table class="table table-bordered table-hover mb-0">
                                        <thead class="table-dark">
                                            <tr>
                                                <th width="5%">#</th>
                                                <th width="30%">Product</th>
                                                <th width="20%">IMEI/Serial</th>
                                                <th width="10%" class="text-center">Qty</th>
                                                <th width="15%" class="text-end">Price</th>
                                                <th width="15%" class="text-end">Total</th>
                                                <th width="5%" class="text-center">Warranty</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php 
                                            $subtotal = 0;
                                            $counter = 1;
                                            if ($items_result->num_rows > 0) {
                                                while($item = $items_result->fetch_assoc()) {
                                                    $item_total = $item['quantity'] * $item['unit_price'];
                                                    $subtotal += $item_total;
                                            ?>
                                            <tr>
                                                <td class="text-center"><?php echo $counter++; ?></td>
                                                <td>
                                                    <strong><?php echo htmlspecialchars($item['product_name']); ?></strong>
                                                    <br>
                                                    <small class="text-muted">
                                                        <?php echo htmlspecialchars($item['brand_name'] ?? 'No Brand'); ?> - <?php echo htmlspecialchars($item['model']); ?>
                                                    </small>
                                                </td>
                                                <td>
                                                    <?php if (!empty($item['imei_number_1'])): ?>
                                                        <small>IMEI1: <?php echo $item['imei_number_1']; ?></small>
                                                        <?php if (!empty($item['imei_number_2'])): ?>
                                                            <br><small>IMEI2: <?php echo $item['imei_number_2']; ?></small>
                                                        <?php endif; ?>
                                                    <?php elseif (!empty($item['serial_number'])): ?>
                                                        <small>S/N: <?php echo $item['serial_number']; ?></small>
                                                    <?php else: ?>
                                                        <small class="text-muted">N/A</small>
                                                    <?php endif; ?>
                                                </td>
                                                <td class="text-center"><?php echo $item['quantity']; ?></td>
                                                <td class="text-end">₹<?php echo number_format($item['unit_price'], 2); ?></td>
                                                <td class="text-end text-success fw-bold">₹<?php echo number_format($item_total, 2); ?></td>
                                                <td class="text-center">
                                                    <?php if (!empty($item['warranty_period'])): ?>
                                                        <span class="badge bg-info"><?php echo $item['warranty_period']; ?></span>
                                                    <?php else: ?>
                                                        <span class="badge bg-secondary">No</span>
                                                    <?php endif; ?>
                                                </td>
                                            </tr>
                                            <?php 
                                                }
                                            } else {
                                            ?>
                                            <tr>
                                                <td colspan="7" class="text-center py-4">
                                                    <i class="fas fa-box-open display-4 text-muted"></i>
                                                    <h5 class="mt-2">No Products Found</h5>
                                                </td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>

<div class="d-block d-md-none">
                                    <?php 
                                    $items_result->data_seek(0);
                                    $counter = 1;
                                    if ($items_result->num_rows > 0) {
                                        while($item = $items_result->fetch_assoc()) {
                                            $item_total = $item['quantity'] * $item['unit_price'];
                                    ?>
                                    <div class="card m-2 border">
                                        <div class="card-body">
                                            <div class="d-flex justify-content-between align-items-start mb-2">
                                                <strong><?php echo htmlspecialchars($item['product_name']); ?></strong>
                                                <span class="badge bg-primary">#<?php echo $counter++; ?></span>
                                            </div>
                                            <p class="text-muted small mb-2">
                                                <?php echo htmlspecialchars($item['brand_name'] ?? 'No Brand'); ?> - <?php echo htmlspecialchars($item['model']); ?>
                                            </p>
                                            
                                            <?php if (!empty($item['imei_number_1'])): ?>
                                                <div class="mb-2">
                                                    <small class="text-muted d-block">IMEI1:</small>
                                                    <small><?php echo $item['imei_number_1']; ?></small>
                                                    <?php if (!empty($item['imei_number_2'])): ?>
                                                        <small class="text-muted d-block mt-1">IMEI2:</small>
                                                        <small><?php echo $item['imei_number_2']; ?></small>
                                                    <?php endif; ?>
                                                </div>
                                            <?php elseif (!empty($item['serial_number'])): ?>
                                                <div class="mb-2">
                                                    <small class="text-muted d-block">Serial:</small>
                                                    <small><?php echo $item['serial_number']; ?></small>
                                                </div>
                                            <?php endif; ?>
                                            
                                            <div class="row text-center">
                                                <div class="col-4">
                                                    <small class="text-muted d-block">Qty</small>
                                                    <strong><?php echo $item['quantity']; ?></strong>
                                                </div>
                                                <div class="col-4">
                                                    <small class="text-muted d-block">Price</small>
                                                    <strong>₹<?php echo number_format($item['unit_price'], 2); ?></strong>
                                                </div>
                                                <div class="col-4">
                                                    <small class="text-muted d-block">Total</small>
                                                    <strong class="text-success">₹<?php echo number_format($item_total, 2); ?></strong>
                                                </div>
                                            </div>
                                            
                                            <div class="text-center mt-2">
                                                <?php if (!empty($item['warranty_period'])): ?>
                                                    <span class="badge bg-info">Warranty: <?php echo $item['warranty_period']; ?></span>
                                                <?php else: ?>
                                                    <span class="badge bg-secondary">No Warranty</span>
                                                <?php endif; ?>
                                            </div>
                                        </div>
                                    </div>
                                    <?php 
                                        }
                                    } else {
                                    ?>
                                    <div class="text-center py-4">
                                        <i class="fas fa-box-open display-4 text-muted"></i>
                                        <h5 class="mt-2">No Products Found</h5>
                                    </div>
                                    <?php } ?>
                                </div>

<div class="p-3 border-top">
                                    <div class="row text-center">
                                        <div class="col-6 col-md-3 mb-2">
                                            <small class="text-muted d-block">Subtotal</small>
                                            <strong>₹<?php echo number_format($subtotal, 2); ?></strong>
                                        </div>
                                        <?php if ($sale['total_amount'] != $subtotal): ?>
                                        <div class="col-6 col-md-3 mb-2">
                                            <small class="text-muted d-block">Adjustment</small>
                                            <strong>₹<?php echo number_format($sale['total_amount'] - $subtotal, 2); ?></strong>
                                        </div>
                                        <?php endif; ?>
                                        <div class="col-6 col-md-3 mb-2">
                                            <small class="text-muted d-block">Grand Total</small>
                                            <strong class="text-success">₹<?php echo number_format($sale['total_amount'], 2); ?></strong>
                                        </div>
                                        <div class="col-6 col-md-3 mb-2">
                                            <small class="text-muted d-block">Due Amount</small>
                                            <strong class="text-danger">₹<?php echo number_format($sale['due_amount'], 2); ?></strong>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

<?php if ($returns_result->num_rows > 0): ?>
                        <div class="card">
                            <div class="card-header bg-light">
                                <h6 class="card-title mb-0">
                                    <i class="fas fa-undo me-2"></i>Return History
                                    <span class="badge bg-warning ms-2"><?php echo $returns_result->num_rows; ?></span>
                                </h6>
                            </div>
                            <div class="card-body p-0">
                                
                                <div class="table-responsive d-none d-md-block">
                                    <table class="table table-bordered table-hover mb-0">
                                        <thead class="table-dark">
                                            <tr>
                                                <th>Return #</th>
                                                <th>Product</th>
                                                <th class="text-center">Qty</th>
                                                <th class="text-end">Refund</th>
                                                <th class="text-center">Type</th>
                                                <th class="text-center">Date</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php while($return = $returns_result->fetch_assoc()): ?>
                                            <tr>
                                                <td><strong><?php echo $return['return_number']; ?></strong></td>
                                                <td>
                                                    <?php echo htmlspecialchars($return['product_name']); ?>
                                                    <br>
                                                    <small class="text-muted">
                                                        <?php echo htmlspecialchars($return['brand_name'] ?? 'No Brand'); ?> <?php echo htmlspecialchars($return['model']); ?>
                                                    </small>
                                                </td>
                                                <td class="text-center"><?php echo $return['return_quantity']; ?></td>
                                                <td class="text-end text-success fw-bold">₹<?php echo number_format($return['refund_amount'], 2); ?></td>
                                                <td class="text-center">
                                                    <span class="badge bg-<?php echo $return['return_type'] == 'refund' ? 'success' : ($return['return_type'] == 'exchange' ? 'warning' : 'info'); ?>">
                                                        <?php echo ucfirst($return['return_type']); ?>
                                                    </span>
                                                </td>
                                                <td class="text-center"><?php echo date('M j, Y', strtotime($return['return_date'])); ?></td>
                                            </tr>
                                            <?php endwhile; ?>
                                        </tbody>
                                    </table>
                                </div>

<div class="d-block d-md-none">
                                    <?php 
                                    $returns_result->data_seek(0);
                                    while($return = $returns_result->fetch_assoc()): 
                                    ?>
                                    <div class="card m-2 border">
                                        <div class="card-body">
                                            <div class="d-flex justify-content-between align-items-start mb-2">
                                                <strong><?php echo $return['return_number']; ?></strong>
                                                <span class="badge bg-<?php echo $return['return_type'] == 'refund' ? 'success' : ($return['return_type'] == 'exchange' ? 'warning' : 'info'); ?>">
                                                    <?php echo ucfirst($return['return_type']); ?>
                                                </span>
                                            </div>
                                            <p class="mb-2">
                                                <strong><?php echo htmlspecialchars($return['product_name']); ?></strong>
                                                <br>
                                                <small class="text-muted">
                                                    <?php echo htmlspecialchars($return['brand_name'] ?? 'No Brand'); ?> <?php echo htmlspecialchars($return['model']); ?>
                                                </small>
                                            </p>
                                            <div class="row text-center">
                                                <div class="col-4">
                                                    <small class="text-muted d-block">Qty</small>
                                                    <strong><?php echo $return['return_quantity']; ?></strong>
                                                </div>
                                                <div class="col-4">
                                                    <small class="text-muted d-block">Refund</small>
                                                    <strong class="text-success">₹<?php echo number_format($return['refund_amount'], 2); ?></strong>
                                                </div>
                                                <div class="col-4">
                                                    <small class="text-muted d-block">Date</small>
                                                    <strong><?php echo date('M j', strtotime($return['return_date'])); ?></strong>
                                                </div>
                                            </div>
                                            <?php if (!empty($return['return_reason'])): ?>
                                                <div class="mt-2">
                                                    <small class="text-muted d-block">Reason:</small>
                                                    <small><?php echo htmlspecialchars($return['return_reason']); ?></small>
                                                </div>
                                            <?php endif; ?>
                                        </div>
                                    </div>
                                    <?php endwhile; ?>
                                </div>
                            </div>
                        </div>
                        <?php endif; ?>
                    </div>

<div class="col-lg-4">
                        
                        <div class="card mb-3">
                            <div class="card-header bg-light">
                                <h6 class="card-title mb-0">
                                    <i class="fas fa-user me-2"></i>Customer Information
                                </h6>
                            </div>
                            <div class="card-body">
                                <div class="text-center mb-3">
                                    <div class="avatar-lg mx-auto mb-2">
                                        <div class="avatar-title bg-soft-primary text-primary rounded-circle">
                                            <i class="fas fa-user fa-lg"></i>
                                        </div>
                                    </div>
                                    <h6 class="mb-1"><?php echo htmlspecialchars($sale['customer_name']); ?></h6>
                                    <p class="text-muted small mb-2">Customer since <?php echo date('M Y', strtotime($sale['created_at'])); ?></p>
                                </div>
                                
                                <div class="list-group list-group-flush">
                                    <div class="list-group-item d-flex justify-content-between align-items-center px-0">
                                        <span class="text-muted">
                                            <i class="fas fa-phone me-2"></i>Phone
                                        </span>
                                        <strong><?php echo htmlspecialchars($sale['customer_phone']); ?></strong>
                                    </div>
                                    <?php if (!empty($sale['customer_email'])): ?>
                                    <div class="list-group-item d-flex justify-content-between align-items-center px-0">
                                        <span class="text-muted">
                                            <i class="fas fa-envelope me-2"></i>Email
                                        </span>
                                        <small><?php echo htmlspecialchars($sale['customer_email']); ?></small>
                                    </div>
                                    <?php endif; ?>
                                </div>

<?php if (!empty($sale['customer_address'])): ?>
                                <div class="mt-3">
                                    <small class="text-muted d-block mb-1">
                                        <i class="fas fa-map-marker-alt me-1"></i>Address
                                    </small>
                                    <p class="small mb-0"><?php echo nl2br(htmlspecialchars($sale['customer_address'])); ?></p>
                                </div>
                                <?php endif; ?>

<div class="row g-2 mt-3">
                                    <div class="col-6">
                                        <a href="customer-details.php?id=<?php echo $sale['customer_id']; ?>" class="btn btn-outline-primary w-100 btn-sm">
                                            <i class="fas fa-eye me-1"></i>Profile
                                        </a>
                                    </div>
                                    <div class="col-6">
                                        
                                        <a href="sales-new.php?customer_id=<?php echo $sale['customer_id']; ?>" class="btn btn-outline-success w-100 btn-sm">
                                            <i class="fas fa-plus me-1"></i>New Sale
                                        </a>
                                    </div>
                                </div>
                            </div>
                        </div>

<?php if ($sale['payment_status'] != 'paid' && $sale['due_amount'] > 0 && $credit_info): ?>
                        <div class="card mb-3">
                            <div class="card-header bg-light">
                                <h6 class="card-title mb-0">
                                    <i class="fas fa-money-bill-wave me-2"></i>Record Payment
                                </h6>
                            </div>
                            <div class="card-body">
                                <form method="POST" action="">
                                    <div class="mb-3">
                                        <label class="form-label small fw-bold">Amount to Pay</label>
                                        <input type="number" class="form-control form-control-sm" name="amount_paid" step="0.01" min="0.01" max="<?php echo $sale['due_amount']; ?>" value="<?php echo $sale['due_amount']; ?>" required>
                                        <small class="form-text text-muted">Due: ₹<?php echo number_format($sale['due_amount'], 2); ?></small>
                                    </div>
                                    <div class="mb-3">
                                        <label class="form-label small fw-bold">Payment Method</label>
                                        <select class="form-select form-select-sm" name="payment_method" required>
                                            <option value="cash">Cash</option>
                                            <option value="card">Card</option>
                                            <option value="upi">UPI</option>
                                            <option value="bank_transfer">Bank Transfer</option>
                                        </select>
                                    </div>
                                    <div class="mb-3">
                                        <label class="form-label small fw-bold">Reference Number</label>
                                        <input type="text" class="form-control form-control-sm" name="reference_number" placeholder="Transaction ID, UPI Ref, etc.">
                                    </div>
                                    <div class="mb-3">
                                        <label class="form-label small fw-bold">Notes</label>
                                        <textarea class="form-control form-control-sm" name="notes" rows="2" placeholder="Any additional notes..."></textarea>
                                    </div>
                                    <button type="submit" name="add_payment" class="btn btn-success w-100 btn-sm">
                                        <i class="fas fa-check-circle me-2"></i>Record Payment
                                    </button>
                                </form>
                            </div>
                        </div>
                        <?php endif; ?>

<?php if ($transactions_result->num_rows > 0): ?>
                        <div class="card mb-3">
                            <div class="card-header bg-light">
                                <h6 class="card-title mb-0">
                                    <i class="fas fa-history me-2"></i>Payment History
                                    <span class="badge bg-info ms-2"><?php echo $transactions_result->num_rows; ?></span>
                                </h6>
                            </div>
                            <div class="card-body p-0">
                                <div style="max-height: 300px; overflow-y: auto;">
                                    <?php 
                                    $transactions_result->data_seek(0);
                                    while($transaction = $transactions_result->fetch_assoc()): 
                                    ?>
                                    <div class="border-bottom p-3">
                                        <div class="d-flex justify-content-between align-items-center mb-1">
                                            <strong class="text-success">₹<?php echo number_format($transaction['amount_paid'], 2); ?></strong>
                                            <small class="text-muted"><?php echo date('M j, g:i A', strtotime($transaction['payment_date'])); ?></small>
                                        </div>
                                        <div class="d-flex justify-content-between align-items-center">
                                            <small class="text-capitalize"><?php echo $transaction['payment_method']; ?></small>
                                            <?php if (!empty($transaction['reference_number'])): ?>
                                                <small class="text-muted">Ref: <?php echo $transaction['reference_number']; ?></small>
                                            <?php endif; ?>
                                        </div>
                                        <?php if (!empty($transaction['notes'])): ?>
                                            <small class="text-muted d-block mt-1"><?php echo $transaction['notes']; ?></small>
                                        <?php endif; ?>
                                    </div>
                                    <?php endwhile; ?>
                                </div>
                            </div>
                        </div>
                        <?php endif; ?>

<?php if (!empty($sale['notes'])): ?>
                        <div class="card">
                            <div class="card-header bg-light">
                                <h6 class="card-title mb-0">
                                    <i class="fas fa-sticky-note me-2"></i>Sale Notes
                                </h6>
                            </div>
                            <div class="card-body">
                                <p class="small mb-0"><?php echo nl2br(htmlspecialchars($sale['notes'])); ?></p>
                            </div>
                        </div>
                        <?php endif; ?>
                    </div>
                </div>

</div>
            
        </div>

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

</div>

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

<div class="modal fade" id="returnModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Process Return</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="sales-return.php">
                <input type="hidden" name="sale_id" value="<?php echo $sale_id; ?>">
                <div class="modal-body">
                    <div class="mb-3">
                        <label class="form-label">Select Product</label>
                        <select class="form-select" name="product_id" required>
                            <option value="">Choose product...</option>
                            <?php
                            $items_result->data_seek(0);
                            while($item = $items_result->fetch_assoc()): 
                            ?>
                            <option value="<?php echo $item['product_id']; ?>">
                                <?php echo htmlspecialchars($item['product_name']); ?> - <?php echo htmlspecialchars($item['brand_name'] ?? 'No Brand'); ?>
                            </option>
                            <?php endwhile; ?>
                        </select>
                    </div>
                    <div class="row">
                        <div class="col-6">
                            <div class="mb-3">
                                <label class="form-label">Quantity</label>
                                <input type="number" class="form-control" name="return_quantity" value="1" min="1" required>
                            </div>
                        </div>
                        <div class="col-6">
                            <div class="mb-3">
                                <label class="form-label">Refund (₹)</label>
                                <input type="number" class="form-control" name="refund_amount" step="0.01" min="0" required>
                            </div>
                        </div>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Return Type</label>
                        <select class="form-select" name="return_type" required>
                            <option value="refund">Refund</option>
                            <option value="exchange">Exchange</option>
                            <option value="credit">Store Credit</option>
                        </select>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Reason</label>
                        <textarea class="form-control" name="return_reason" rows="2" required placeholder="Reason for return..."></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="process_return" class="btn btn-warning">Process Return</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="cancelModal" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Cancel Sale</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="">
                <div class="modal-body">
                    <div class="alert alert-warning mb-3">
                        <i class="fas fa-exclamation-triangle me-2"></i>
                        <strong>Warning:</strong> This action cannot be undone.
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Cancellation Reason</label>
                        <textarea class="form-control" name="cancellation_reason" rows="3" required placeholder="Reason for cancellation..."></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Keep Sale</button>
                    <button type="submit" name="cancel_sale" class="btn btn-danger">Confirm</button>
                </div>
            </form>
        </div>
    </div>
</div>

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

/* Responsive improvements */
@media (max-width: 768px) {
    .card-body {
        padding: 1rem;
    }
    .table-responsive {
        font-size: 0.8rem;
    }
    .btn-group-vertical .btn {
        margin-bottom: 0.25rem;
    }
}

@media (max-width: 576px) {
    .container-fluid {
        padding: 0.5rem;
    }
    .card {
        margin-bottom: 0.5rem;
    }
    .row > * {
        padding: 0.25rem;
    }
}

/* Better touch targets for mobile */
.btn, .form-control, .form-select {
    min-height: 44px;
}

/* Improve readability on small screens */
@media (max-width: 768px) {
    body {
        font-size: 14px;
    }
    h4, h5, h6 {
        font-size: 1.1rem;
    }
}
</style>

</body>
</html>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sales-view.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation