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

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: add-payment.php

<?php
include('includes/head.php');
include('includes/db.php');
include('includes/log-helper.php');

$po_id = (int)($_GET['po_id'] ?? 0);
if ($po_id <= 0) {
    header("Location: purchase-orders.php?msg=Invalid PO ID&type=danger");
    exit;
}

// Get PO details
$po_stmt = $conn->prepare("SELECT * FROM purchase_orders WHERE id = ?");
$po_stmt->bind_param("i", $po_id);
$po_stmt->execute();
$po_result = $po_stmt->get_result();
$purchase_order = $po_result->fetch_assoc();
$po_stmt->close();

if (!$purchase_order) {
    header("Location: purchase-orders.php?msg=Purchase order not found&type=danger");
    exit;
}

// Calculate balance
$balance = $purchase_order['total_amount'] - $purchase_order['given_amount'];

// Check if payments table exists, if not create it
$table_check = $conn->query("SHOW TABLES LIKE 'purchase_order_payments'");
if ($table_check->num_rows == 0) {
    // Create the payments table
    $create_table_sql = "
        CREATE TABLE purchase_order_payments (
            payment_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
            purchase_order_id INT(11) NOT NULL,
            payment_date DATE NOT NULL,
            payment_amount DECIMAL(12,2) NOT NULL,
            payment_method ENUM('cash','bank_transfer','cheque','card','online','other') NOT NULL DEFAULT 'cash',
            reference_number VARCHAR(100) DEFAULT NULL,
            notes TEXT DEFAULT NULL,
            created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
            updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
            FOREIGN KEY (purchase_order_id) REFERENCES purchase_orders(id) ON DELETE CASCADE
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
    ";
    if ($conn->query($create_table_sql)) {
        // Table created successfully
        $payments = [];
    } else {
        die("Error creating payments table: " . $conn->error);
    }
} else {
    // Get payment history if table exists
    $payments_stmt = $conn->prepare("
        SELECT * FROM purchase_order_payments 
        WHERE purchase_order_id = ? 
        ORDER BY payment_date DESC, created_at DESC
    ");
    $payments_stmt->bind_param("i", $po_id);
    $payments_stmt->execute();
    $payments_result = $payments_stmt->get_result();
    $payments = [];
    while ($payment = $payments_result->fetch_assoc()) {
        $payments[] = $payment;
    }
    $payments_stmt->close();
}
?>

<!doctype html>
<html lang="en">
<body data-sidebar="dark">
<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">
                <div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Add Payment - PO #<?= $po_id ?></h4>
                            <div class="page-title-right">
                                <a href="view-purchase-order.php?id=<?= $po_id ?>" class="btn btn-secondary me-2">
                                    <i class="fas fa-arrow-left me-1"></i> Back to PO
                                </a>
                                <a href="purchase-orders.php" class="btn btn-outline-secondary">
                                    <i class="fas fa-list me-1"></i> All POs
                                </a>
                            </div>
                        </div>
                    </div>
                </div>

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

<div class="row">
                    <div class="col-lg-6">
                        
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-4">Add New Payment</h5>

<div class="alert alert-info">
                                    <div class="row">
                                        <div class="col-6">
                                            <strong>Supplier:</strong><br>
                                            <?= htmlspecialchars($purchase_order['supplier_name']) ?>
                                        </div>
                                        <div class="col-6 text-end">
                                            <strong>Total Amount:</strong> ₹<?= number_format($purchase_order['total_amount'], 2) ?><br>
                                            <strong>Paid So Far:</strong> ₹<?= number_format($purchase_order['given_amount'], 2) ?><br>
                                            <strong class="text-danger">Balance Due:</strong> ₹<?= number_format($balance, 2) ?>
                                        </div>
                                    </div>
                                </div>

<form action="process-payment.php" method="POST" id="paymentForm">
                                    <input type="hidden" name="po_id" value="<?= $po_id ?>">
                                    
                                    <div class="row">
                                        <div class="col-md-6 mb-3">
                                            <label for="paymentDate" class="form-label">Payment Date *</label>
                                            <input type="date" id="paymentDate" name="payment_date" class="form-control" value="<?= date('Y-m-d') ?>" required>
                                        </div>
                                        <div class="col-md-6 mb-3">
                                            <label for="paymentAmount" class="form-label">Payment Amount *</label>
                                            <input type="number" id="paymentAmount" name="payment_amount" class="form-control" step="0.01" min="0.01" max="<?= $balance ?>" value="<?= number_format($balance, 2) ?>" required>
                                            <div class="form-text">Maximum: ₹<?= number_format($balance, 2) ?></div>
                                        </div>
                                    </div>

<div class="row">
                                        <div class="col-md-6 mb-3">
                                            <label for="paymentMethod" class="form-label">Payment Method *</label>
                                            <select id="paymentMethod" name="payment_method" class="form-control" required>
                                                <option value="cash">Cash</option>
                                                <option value="bank_transfer">Bank Transfer</option>
                                                <option value="cheque">Cheque</option>
                                                <option value="card">Card</option>
                                                <option value="online">Online Payment</option>
                                                <option value="other">Other</option>
                                            </select>
                                        </div>
                                        <div class="col-md-6 mb-3">
                                            <label for="referenceNumber" class="form-label">Reference Number</label>
                                            <input type="text" id="referenceNumber" name="reference_number" class="form-control" placeholder="e.g., Cheque #, Transaction ID">
                                        </div>
                                    </div>

<div class="row">
                                        <div class="col-12 mb-3">
                                            <label for="paymentNotes" class="form-label">Notes</label>
                                            <textarea id="paymentNotes" name="notes" class="form-control" rows="3" placeholder="Any additional notes about this payment..."></textarea>
                                        </div>
                                    </div>

<div class="row mb-3">
                                        <div class="col-12">
                                            <label class="form-label">Quick Amounts:</label>
                                            <div class="d-flex gap-2 flex-wrap">
                                                <?php
                                                $quick_amounts = [
                                                    $balance * 0.25,
                                                    $balance * 0.50,
                                                    $balance * 0.75,
                                                    $balance
                                                ];
                                                foreach ($quick_amounts as $amount):
                                                    if ($amount > 0):
                                                ?>
                                                    <button type="button" class="btn btn-outline-primary btn-sm quick-amount" data-amount="<?= number_format($amount, 2) ?>">
                                                        ₹<?= number_format($amount, 2) ?>
                                                    </button>
                                                <?php
                                                    endif;
                                                endforeach;
                                                ?>
                                            </div>
                                        </div>
                                    </div>

<div class="text-center mt-4">
                                        <button type="submit" class="btn btn-success btn-lg px-5 me-3">
                                            <i class="fas fa-money-bill-wave me-1"></i> Process Payment
                                        </button>
                                        <a href="view-purchase-order.php?id=<?= $po_id ?>" class="btn btn-secondary btn-lg px-5">
                                            <i class="fas fa-times me-1"></i> Cancel
                                        </a>
                                    </div>
                                </form>
                            </div>
                        </div>
                    </div>

<div class="col-lg-6">
                        
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-4">Payment History</h5>
                                
                                <?php if (!empty($payments)): ?>
                                    <div class="table-responsive">
                                        <table class="table table-sm table-hover">
                                            <thead class="table-light">
                                                <tr>
                                                    <th>Date</th>
                                                    <th>Amount</th>
                                                    <th>Method</th>
                                                    <th>Reference</th>
                                                    <th>Actions</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php foreach ($payments as $payment): ?>
                                                    <tr>
                                                        <td>
                                                            <?= date('M j, Y', strtotime($payment['payment_date'])) ?>
                                                            <br><small class="text-muted"><?= date('g:i A', strtotime($payment['created_at'])) ?></small>
                                                        </td>
                                                        <td>
                                                            <strong class="text-success">₹<?= number_format($payment['payment_amount'], 2) ?></strong>
                                                        </td>
                                                        <td>
                                                            <span class="badge bg-<?= getPaymentMethodBadge($payment['payment_method']) ?>">
                                                                <?= ucfirst(str_replace('_', ' ', $payment['payment_method'])) ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <?= $payment['reference_number'] ? htmlspecialchars($payment['reference_number']) : '<span class="text-muted">N/A</span>' ?>
                                                        </td>
                                                        <td>
                                                            <div class="btn-group btn-group-sm">
                                                                <button type="button" class="btn btn-outline-info" 
                                                                        data-bs-toggle="tooltip" title="View Details"
                                                                        onclick="viewPaymentDetails(<?= $payment['payment_id'] ?>)">
                                                                    <i class="fas fa-eye"></i>
                                                                </button>
                                                                <button type="button" class="btn btn-outline-danger"
                                                                        data-bs-toggle="tooltip" title="Delete Payment"
                                                                        onclick="confirmDeletePayment(<?= $payment['payment_id'] ?>)">
                                                                    <i class="fas fa-trash"></i>
                                                                </button>
                                                            </div>
                                                        </td>
                                                    </tr>
                                                <?php endforeach; ?>
                                            </tbody>
                                            <tfoot class="table-light">
                                                <tr>
                                                    <td colspan="5" class="text-end">
                                                        <strong>Total Paid: ₹<?= number_format($purchase_order['given_amount'], 2) ?></strong>
                                                    </td>
                                                </tr>
                                            </tfoot>
                                        </table>
                                    </div>
                                <?php else: ?>
                                    <div class="text-center py-4">
                                        <i class="fas fa-money-bill-wave fa-3x text-muted mb-3"></i>
                                        <h5 class="text-muted">No Payments Recorded</h5>
                                        <p class="text-muted">No payments have been made for this purchase order yet.</p>
                                        <?php if ($purchase_order['given_amount'] > 0): ?>
                                            <div class="alert alert-warning mt-3">
                                                <small>
                                                    <i class="fas fa-info-circle me-1"></i>
                                                    Previous payments of ₹<?= number_format($purchase_order['given_amount'], 2) ?> were recorded before the payment tracking system was implemented.
                                                </small>
                                            </div>
                                        <?php endif; ?>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>

<div class="card mt-3">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Payment Summary</h5>
                                <div class="row text-center">
                                    <div class="col-4">
                                        <div class="border rounded p-3">
                                            <h4 class="text-primary mb-1">₹<?= number_format($purchase_order['total_amount'], 2) ?></h4>
                                            <small class="text-muted">Total Amount</small>
                                        </div>
                                    </div>
                                    <div class="col-4">
                                        <div class="border rounded p-3">
                                            <h4 class="text-success mb-1">₹<?= number_format($purchase_order['given_amount'], 2) ?></h4>
                                            <small class="text-muted">Paid</small>
                                        </div>
                                    </div>
                                    <div class="col-4">
                                        <div class="border rounded p-3">
                                            <h4 class="text-danger mb-1">₹<?= number_format($balance, 2) ?></h4>
                                            <small class="text-muted">Balance</small>
                                        </div>
                                    </div>
                                </div>
                                
                                
                                <div class="mt-3">
                                    <?php
                                    $paid_percentage = $purchase_order['total_amount'] > 0 ? 
                                        ($purchase_order['given_amount'] / $purchase_order['total_amount']) * 100 : 0;
                                    ?>
                                    <div class="d-flex justify-content-between mb-1">
                                        <small>Payment Progress</small>
                                        <small><?= number_format($paid_percentage, 1) ?>%</small>
                                    </div>
                                    <div class="progress" style="height: 8px;">
                                        <div class="progress-bar 
                                            <?= $paid_percentage == 100 ? 'bg-success' : 
                                               ($paid_percentage >= 50 ? 'bg-warning' : 'bg-danger') ?>" 
                                            role="progressbar" 
                                            style="width: <?= $paid_percentage ?>%" 
                                            aria-valuenow="<?= $paid_percentage ?>" 
                                            aria-valuemin="0" 
                                            aria-valuemax="100">
                                        </div>
                                    </div>
                                </div>

<div class="mt-3 text-center">
                                    <span class="badge bg-<?= getPaymentBadge($purchase_order['payment_status']) ?> fs-6">
                                        <?= $purchase_order['payment_status'] ?>
                                    </span>
                                    <?php if ($purchase_order['payment_status'] == 'Paid'): ?>
                                        <div class="mt-2">
                                            <i class="fas fa-check-circle text-success me-1"></i>
                                            <small class="text-success">Fully Paid</small>
                                        </div>
                                    <?php elseif ($purchase_order['payment_status'] == 'Partially Paid'): ?>
                                        <div class="mt-2">
                                            <i class="fas fa-clock text-warning me-1"></i>
                                            <small class="text-warning">Partially Paid</small>
                                        </div>
                                    <?php else: ?>
                                        <div class="mt-2">
                                            <i class="fas fa-exclamation-triangle text-danger me-1"></i>
                                            <small class="text-danger">Payment Pending</small>
                                        </div>
                                    <?php endif; ?>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <?php include('includes/footer.php'); ?>
    </div>
</div>

<div class="modal fade" id="paymentDetailsModal" tabindex="-1" aria-labelledby="paymentDetailsModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="paymentDetailsModalLabel">Payment Details</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <div class="modal-body" id="paymentDetailsContent">
                
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
            </div>
        </div>
    </div>
</div>

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

// Validate payment amount
    document.getElementById('paymentAmount').addEventListener('input', function() {
        const maxAmount = <?= $balance ?>;
        const currentAmount = parseFloat(this.value) || 0;
        
        if (currentAmount > maxAmount) {
            this.value = maxAmount.toFixed(2);
            alert('Payment amount cannot exceed the balance due of ₹' + maxAmount.toFixed(2));
        }
    });

// Also validate on form submit
    document.getElementById('paymentForm').addEventListener('submit', function(e) {
        const amount = parseFloat(document.getElementById('paymentAmount').value) || 0;
        const maxAmount = <?= $balance ?>;
        
        if (amount > maxAmount) {
            e.preventDefault();
            alert('Payment amount cannot exceed the balance due of ₹' + maxAmount.toFixed(2));
            document.getElementById('paymentAmount').focus();
        }
        
        if (amount <= 0) {
            e.preventDefault();
            alert('Please enter a valid payment amount.');
            document.getElementById('paymentAmount').focus();
        }
    });

// Initialize tooltips
    var tooltipTriggerList = [].slice.call(document.querySelectorAll('[data-bs-toggle="tooltip"]'));
    var tooltipList = tooltipTriggerList.map(function (tooltipTriggerEl) {
        return new bootstrap.Tooltip(tooltipTriggerEl);
    });
});

function confirmDeletePayment(paymentId) {
    if (confirm('Are you sure you want to delete this payment? This action cannot be undone.')) {
        window.location.href = 'delete-payment.php?payment_id=' + paymentId + '&po_id=<?= $po_id ?>';
    }
}
</script>
</body>
</html>

<?php
// Helper functions
function getPaymentMethodBadge($method) {
    $colors = [
        'cash' => 'success',
        'bank_transfer' => 'primary',
        'cheque' => 'info',
        'card' => 'warning',
        'online' => 'danger',
        'other' => 'secondary'
    ];
    return $colors[$method] ?? 'secondary';
}

function getPaymentBadge($status) {
    $colors = [
        'Paid' => 'success',
        'Partially Paid' => 'warning',
        'Unpaid' => 'danger'
    ];
    return $colors[$status] ?? 'secondary';
}

$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: add-payment.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation