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

🔧 Quick Actions

✏️ Editing: delete-purchase.php

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

// Check if user is logged in
if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}

// Check if user is admin
if ($_SESSION['user_role'] !== 'admin') {
    $_SESSION['error'] = "You don't have permission to delete purchases.";
    header("Location: purchase-list.php");
    exit();
}

$purchase_id = isset($_GET['id']) ? intval($_GET['id']) : 0;

if ($purchase_id > 0) {
    try {
        // Get purchase details before deletion for logging
        $purchaseQuery = "SELECT p.*, s.supplier_name FROM purchases p 
                         LEFT JOIN suppliers s ON p.supplier_id = s.id 
                         WHERE p.id = $purchase_id";
        $purchaseResult = mysqli_query($conn, $purchaseQuery);
        $purchaseData = mysqli_fetch_assoc($purchaseResult);
        
        if (!$purchaseData) {
            $_SESSION['error'] = "Purchase not found!";
            header("Location: purchase-list.php");
            exit();
        }
        
        // Start transaction
        mysqli_begin_transaction($conn);
        
        // 1. First, get all purchase items to restore product stock
        $itemsQuery = "SELECT pi.product_id, pi.quantity, pr.product_name 
                      FROM purchase_items pi
                      LEFT JOIN products pr ON pi.product_id = pr.id
                      WHERE pi.purchase_id = $purchase_id";
        $itemsResult = mysqli_query($conn, $itemsQuery);
        $items_count = mysqli_num_rows($itemsResult);
        $items_deleted = 0;
        
        // Store items for logging
        $items_details = [];
        while ($item = mysqli_fetch_assoc($itemsResult)) {
            $items_details[] = $item;
            
            // Restore product stock (subtract purchase quantity)
            $product_id = $item['product_id'];
            $quantity = $item['quantity'];
            
            // Check current stock before adjustment
            $checkStockQuery = "SELECT quantity FROM products WHERE id = $product_id";
            $checkStockResult = mysqli_query($conn, $checkStockQuery);
            $stockRow = mysqli_fetch_assoc($checkStockResult);
            $current_stock = $stockRow['quantity'];
            
            // Calculate new stock (current - purchase quantity)
            $new_stock = $current_stock - $quantity;
            
            // Prevent negative stock
            if ($new_stock >= 0) {
                $updateStock = "UPDATE products SET quantity = $new_stock WHERE id = $product_id";
                if (mysqli_query($conn, $updateStock)) {
                    $items_deleted++;
                } else {
                    throw new Exception("Failed to update stock for product ID: $product_id");
                }
            } else {
                // If stock would go negative, set to 0 and log warning
                $updateStock = "UPDATE products SET quantity = 0 WHERE id = $product_id";
                mysqli_query($conn, $updateStock);
                // Log this as a warning
                error_log("Warning: Stock for product ID $product_id would go negative. Set to 0 instead.");
            }
        }
        
        // 2. Update supplier balance (subtract purchase amount from supplier's current balance)
        $supplier_id = $purchaseData['supplier_id'];
        $purchase_amount = $purchaseData['total_amount'];
        
        // Check if supplier exists before updating
        $checkSupplierQuery = "SELECT current_balance FROM suppliers WHERE id = $supplier_id";
        $checkSupplierResult = mysqli_query($conn, $checkSupplierQuery);
        
        if (mysqli_num_rows($checkSupplierResult) > 0) {
            $supplierRow = mysqli_fetch_assoc($checkSupplierResult);
            $current_balance = $supplierRow['current_balance'];
            $new_balance = $current_balance - $purchase_amount;
            
            // Update supplier balance
            $updateSupplier = "UPDATE suppliers SET current_balance = $new_balance WHERE id = $supplier_id";
            if (!mysqli_query($conn, $updateSupplier)) {
                throw new Exception("Failed to update supplier balance: " . mysqli_error($conn));
            }
        }
        
        // 3. Delete purchase items
        $deleteItems = "DELETE FROM purchase_items WHERE purchase_id = $purchase_id";
        if (!mysqli_query($conn, $deleteItems)) {
            throw new Exception("Failed to delete purchase items: " . mysqli_error($conn));
        }
        
        // 4. Delete the purchase
        $deletePurchase = "DELETE FROM purchases WHERE id = $purchase_id";
        if (!mysqli_query($conn, $deletePurchase)) {
            throw new Exception("Failed to delete purchase: " . mysqli_error($conn));
        }
        
        // Log the deletion
        $logDetails = json_encode([
            'purchase_id' => $purchase_id,
            'reference_no' => $purchaseData['reference_no'],
            'supplier' => $purchaseData['supplier_name'],
            'supplier_id' => $supplier_id,
            'amount' => $purchase_amount,
            'items_count' => $items_count,
            'items_deleted' => $items_deleted,
            'deleted_by' => $_SESSION['user_id'],
            'deleted_at' => date('Y-m-d H:i:s')
        ], JSON_PRETTY_PRINT);
        
        $logQuery = "INSERT INTO deletion_logs (table_name, record_id, record_details, deleted_by) 
                    VALUES ('purchases', $purchase_id, '" . mysqli_real_escape_string($conn, $logDetails) . "', '{$_SESSION['user_id']}')";
        mysqli_query($conn, $logQuery);
        
        // Also log in activity logs
        $activity = "Deleted purchase: {$purchaseData['reference_no']} (ID: $purchase_id) from supplier: {$purchaseData['supplier_name']}";
        $activityQuery = "INSERT INTO activity_logs (user_id, activity) 
                         VALUES ({$_SESSION['user_id']}, '" . mysqli_real_escape_string($conn, $activity) . "')";
        mysqli_query($conn, $activityQuery);
        
        mysqli_commit($conn);
        $_SESSION['success'] = "Purchase deleted successfully! Reference: " . htmlspecialchars($purchaseData['reference_no']);
        
    } catch (Exception $e) {
        mysqli_rollback($conn);
        $_SESSION['error'] = "Error deleting purchase: " . $e->getMessage();
        
        // Log the error
        error_log("Purchase deletion failed: " . $e->getMessage() . " | Purchase ID: $purchase_id | User ID: " . $_SESSION['user_id']);
    }
} else {
    $_SESSION['error'] = "Invalid purchase ID!";
}

header("Location: purchase-list.php");
exit();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: delete-purchase.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation