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.3 TB

🔧 Quick Actions

✏️ Editing: process-payment.php

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

if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    header("Location: purchase-orders.php?msg=Invalid request&type=danger");
    exit;
}

$po_id = (int)($_POST['po_id'] ?? 0);
$payment_date = $_POST['payment_date'] ?? '';
$payment_amount = (float)($_POST['payment_amount'] ?? 0);
$payment_method = $_POST['payment_method'] ?? 'cash';
$reference_number = trim($_POST['reference_number'] ?? '');
$notes = trim($_POST['notes'] ?? '');

if ($po_id <= 0 || empty($payment_date) || $payment_amount <= 0) {
    header("Location: add-payment.php?po_id=$po_id&msg=Invalid payment data&type=danger");
    exit;
}

// 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)) {
        header("Location: add-payment.php?po_id=$po_id&msg=Error creating payments table: " . $conn->error . "&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 and validate payment amount
$balance = $purchase_order['total_amount'] - $purchase_order['given_amount'];
if ($payment_amount > $balance) {
    header("Location: add-payment.php?po_id=$po_id&msg=Payment amount exceeds balance due&type=danger");
    exit;
}

// Start transaction
$conn->begin_transaction();

try {
    // Insert payment record
    $stmt = $conn->prepare("
        INSERT INTO purchase_order_payments 
        (purchase_order_id, payment_date, payment_amount, payment_method, reference_number, notes)
        VALUES (?, ?, ?, ?, ?, ?)
    ");
    $stmt->bind_param("isdsss", $po_id, $payment_date, $payment_amount, $payment_method, $reference_number, $notes);
    
    if (!$stmt->execute()) {
        throw new Exception("Failed to record payment: " . $stmt->error);
    }
    $payment_id = $stmt->insert_id;
    $stmt->close();

// Update PO given amount
    $new_given_amount = $purchase_order['given_amount'] + $payment_amount;
    $new_payment_status = ($new_given_amount >= $purchase_order['total_amount']) ? 'Paid' : 
                         ($new_given_amount > 0 ? 'Partially Paid' : 'Unpaid');
    
    $stmt = $conn->prepare("
        UPDATE purchase_orders 
        SET given_amount = ?, payment_status = ?, updated_at = CURRENT_TIMESTAMP 
        WHERE id = ?
    ");
    $stmt->bind_param("dsi", $new_given_amount, $new_payment_status, $po_id);
    
    if (!$stmt->execute()) {
        throw new Exception("Failed to update purchase order: " . $stmt->error);
    }
    $stmt->close();

// Log the payment
    logPurchaseOrderAction($conn, $po_id, 'payment_updated', 
        "Payment recorded: ₹" . number_format($payment_amount, 2) . 
        " via " . ucfirst(str_replace('_', ' ', $payment_method)) . 
        " | New balance: ₹" . number_format($balance - $payment_amount, 2),
        [
            'given_amount' => $purchase_order['given_amount'],
            'payment_status' => $purchase_order['payment_status'],
            'balance' => $balance
        ],
        [
            'given_amount' => $new_given_amount,
            'payment_status' => $new_payment_status,
            'balance' => $balance - $payment_amount
        ],
        "Payment recorded: ₹{$payment_amount}"
    );

// Commit transaction
    $conn->commit();

$msg = "Payment of ₹" . number_format($payment_amount, 2) . " recorded successfully. " .
           "New balance: ₹" . number_format($balance - $payment_amount, 2);
    
    header("Location: add-payment.php?po_id=$po_id&msg=" . urlencode($msg) . "&type=success");
    
} catch (Exception $e) {
    // Rollback transaction on error
    $conn->rollback();
    header("Location: add-payment.php?po_id=$po_id&msg=" . urlencode($e->getMessage()) . "&type=danger");
}

$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: process-payment.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation