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

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: bulk-payment.php

<?php

header('Content-Type: application/json');

// Include database configuration
include('config/config.php');

// Check connection
if (!$conn) {
    echo json_encode(['success' => false, 'message' => 'Database connection failed']);
    exit;
}

// Get JSON data
$input = json_decode(file_get_contents('php://input'), true);

if (!$input || !isset($input['payments']) || !is_array($input['payments'])) {
    echo json_encode(['success' => false, 'message' => 'Invalid request data']);
    exit;
}

$payments = $input['payments'];
$payment_method = isset($input['payment_method']) ? mysqli_real_escape_string($conn, $input['payment_method']) : '';
$reference_no = isset($input['reference_no']) ? mysqli_real_escape_string($conn, $input['reference_no']) : '';
$payment_date = isset($input['payment_date']) ? $input['payment_date'] : date('Y-m-d');
$notes = isset($input['notes']) ? mysqli_real_escape_string($conn, $input['notes']) : '';
$created_by = $_SESSION['user_id'];

if (empty($payment_method)) {
    echo json_encode(['success' => false, 'message' => 'Payment method is required']);
    exit;
}

// Start transaction
mysqli_begin_transaction($conn);

try {
    $processed_payments = [];
    $payment_date_time = $payment_date . ' ' . date('H:i:s');
    
    foreach ($payments as $payment) {
        $order_id = intval($payment['order_id']);
        $payment_amount = floatval($payment['amount']);
        
        if ($order_id <= 0 || $payment_amount <= 0) {
            continue; // Skip invalid payments
        }
        
        // 1. Get current order details
        $sql_order = "SELECT * FROM orders WHERE id = ? FOR UPDATE";
        $stmt_order = mysqli_prepare($conn, $sql_order);
        mysqli_stmt_bind_param($stmt_order, 'i', $order_id);
        mysqli_stmt_execute($stmt_order);
        $order_result = mysqli_stmt_get_result($stmt_order);
        
        if (!$order = mysqli_fetch_assoc($order_result)) {
            mysqli_stmt_close($stmt_order);
            continue; // Skip if order not found
        }
        
        // Check if payment amount exceeds pending amount
        if ($payment_amount > $order['pending_amount']) {
            mysqli_stmt_close($stmt_order);
            throw new Exception('Payment amount exceeds pending amount for order #' . $order['order_number']);
        }
        
        $customer_id = $order['customer_id'];
        
        // 2. Update order payment details
        $new_paid = $order['paid_amount'] + $payment_amount;
        $new_pending = $order['pending_amount'] - $payment_amount;
        $payment_status = $new_pending == 0 ? 'paid' : ($new_pending < $order['total_amount'] ? 'partial' : 'pending');
        
        $sql_update_order = "UPDATE orders 
                            SET paid_amount = ?, 
                                pending_amount = ?, 
                                payment_status = ?,
                                payment_date = ?
                            WHERE id = ?";
        
        $stmt_update = mysqli_prepare($conn, $sql_update_order);
        mysqli_stmt_bind_param($stmt_update, 'ddssi', $new_paid, $new_pending, $payment_status, $payment_date_time, $order_id);
        
        if (!mysqli_stmt_execute($stmt_update)) {
            mysqli_stmt_close($stmt_order);
            mysqli_stmt_close($stmt_update);
            throw new Exception('Failed to update order #' . $order['order_number']);
        }
        
        // 3. Update customer balance
        $sql_update_customer = "UPDATE customers 
                               SET current_balance = current_balance - ? 
                               WHERE id = ?";
        
        $stmt_customer = mysqli_prepare($conn, $sql_update_customer);
        mysqli_stmt_bind_param($stmt_customer, 'di', $payment_amount, $customer_id);
        
        if (!mysqli_stmt_execute($stmt_customer)) {
            mysqli_stmt_close($stmt_order);
            mysqli_stmt_close($stmt_update);
            mysqli_stmt_close($stmt_customer);
            throw new Exception('Failed to update customer balance for order #' . $order['order_number']);
        }
        
        // 4. Generate payment ID for each payment
        $payment_id = 'BPAY' . date('Ymd') . str_pad(rand(1, 9999), 4, '0', STR_PAD_LEFT);
        
        // 5. Insert into transactions table
        $sql_transaction = "INSERT INTO transactions 
                           (customer_id, order_id, payment_id, type, amount, payment_method, reference_no, notes, created_by) 
                           VALUES (?, ?, ?, 'payment', ?, ?, ?, ?, ?)";
        
        $stmt_transaction = mysqli_prepare($conn, $sql_transaction);
        $type = 'payment';
        mysqli_stmt_bind_param($stmt_transaction, 'iisdsssi', $customer_id, $order_id, $payment_id, $payment_amount, $payment_method, $reference_no, $notes, $created_by);
        
        if (!mysqli_stmt_execute($stmt_transaction)) {
            mysqli_stmt_close($stmt_order);
            mysqli_stmt_close($stmt_update);
            mysqli_stmt_close($stmt_customer);
            mysqli_stmt_close($stmt_transaction);
            throw new Exception('Failed to record transaction for order #' . $order['order_number']);
        }
        
        $transaction_id = mysqli_insert_id($conn);
        
        // 6. Insert into payment_history table
        $sql_payment_history = "INSERT INTO payment_history 
                               (order_id, transaction_id, amount_paid, payment_method, reference_no, notes, created_by) 
                               VALUES (?, ?, ?, ?, ?, ?, ?)";
        
        $stmt_history = mysqli_prepare($conn, $sql_payment_history);
        mysqli_stmt_bind_param($stmt_history, 'iidsssi', $order_id, $transaction_id, $payment_amount, $payment_method, $reference_no, $notes, $created_by);
        
        if (!mysqli_stmt_execute($stmt_history)) {
            mysqli_stmt_close($stmt_order);
            mysqli_stmt_close($stmt_update);
            mysqli_stmt_close($stmt_customer);
            mysqli_stmt_close($stmt_transaction);
            mysqli_stmt_close($stmt_history);
            throw new Exception('Failed to record payment history for order #' . $order['order_number']);
        }
        
        // 7. Update customer's last purchase date if order is fully paid
        if ($payment_status == 'paid') {
            $sql_update_last_purchase = "UPDATE customers 
                                        SET last_purchase_date = CURDATE() 
                                        WHERE id = ?";
            
            $stmt_last_purchase = mysqli_prepare($conn, $sql_update_last_purchase);
            mysqli_stmt_bind_param($stmt_last_purchase, 'i', $customer_id);
            mysqli_stmt_execute($stmt_last_purchase);
            mysqli_stmt_close($stmt_last_purchase);
        }
        
        // Store processed payment info
        $processed_payments[] = [
            'order_id' => $order_id,
            'order_number' => $order['order_number'],
            'payment_amount' => $payment_amount,
            'new_pending' => $new_pending,
            'fully_paid' => $payment_status == 'paid',
            'payment_id' => $payment_id
        ];
        
        // Close statements for this payment
        mysqli_stmt_close($stmt_order);
        mysqli_stmt_close($stmt_update);
        mysqli_stmt_close($stmt_customer);
        mysqli_stmt_close($stmt_transaction);
        mysqli_stmt_close($stmt_history);
    }
    
    if (empty($processed_payments)) {
        throw new Exception('No valid payments to process');
    }
    
    // Commit transaction
    mysqli_commit($conn);
    
    echo json_encode([
        'success' => true,
        'message' => 'Bulk payment processed successfully',
        'processed_count' => count($processed_payments),
        'processed_payments' => $processed_payments
    ]);
    
} catch (Exception $e) {
    // Rollback transaction on error
    mysqli_rollback($conn);
    echo json_encode([
        'success' => false,
        'message' => 'Bulk payment failed: ' . $e->getMessage()
    ]);
}

mysqli_close($conn);
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: bulk-payment.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation