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: delete-payment.php

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

$payment_id = (int)($_GET['payment_id'] ?? 0);
$po_id = (int)($_GET['po_id'] ?? 0);

if ($payment_id <= 0 || $po_id <= 0) {
    header("Location: purchase-orders.php?msg=Invalid parameters&type=danger");
    exit;
}

// Get payment details before deletion
$stmt = $conn->prepare("
    SELECT * FROM purchase_order_payments 
    WHERE payment_id = ? AND purchase_order_id = ?
");
$stmt->bind_param("ii", $payment_id, $po_id);
$stmt->execute();
$result = $stmt->get_result();
$payment = $result->fetch_assoc();
$stmt->close();

if (!$payment) {
    header("Location: add-payment.php?po_id=$po_id&msg=Payment not found&type=danger");
    exit;
}

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

try {
    // Delete payment record
    $stmt = $conn->prepare("DELETE FROM purchase_order_payments WHERE payment_id = ?");
    $stmt->bind_param("i", $payment_id);
    
    if (!$stmt->execute()) {
        throw new Exception("Failed to delete payment: " . $stmt->error);
    }
    $stmt->close();

// Update PO given amount
    $po_stmt = $conn->prepare("SELECT given_amount, total_amount 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();

$new_given_amount = $purchase_order['given_amount'] - $payment['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 deletion
    logPurchaseOrderAction($conn, $po_id, 'payment_updated', 
        "Payment deleted: ₹" . number_format($payment['payment_amount'], 2) . 
        " | New balance: ₹" . number_format($purchase_order['total_amount'] - $new_given_amount, 2),
        [
            'given_amount' => $purchase_order['given_amount'],
            'payment_status' => $purchase_order['payment_status']
        ],
        [
            'given_amount' => $new_given_amount,
            'payment_status' => $new_payment_status
        ],
        "Payment deleted: ₹{$payment['payment_amount']}"
    );

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

$msg = "Payment of ₹" . number_format($payment['payment_amount'], 2) . " deleted successfully";
    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: delete-payment.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation