query("DESCRIBE payment_settlements"); if ($result) { $columns = []; while ($row = $result->fetch_assoc()) { $columns[] = $row['Field']; } if (in_array('date', $columns)) { $date_column = 'date'; } elseif (in_array('settlement_date', $columns)) { $date_column = 'settlement_date'; } } } catch (Exception $e) { // Use default } // Get settlement entry $settlement = fetchSingle(" SELECT ps.*, u.full_name as supplier_name FROM payment_settlements ps JOIN users u ON ps.supplier_id = u.user_id WHERE ps.settlement_id = ? ", "i", [$settlement_id]); if (!$settlement) { header("Location: pending_payments.php?error=notfound"); exit(); } $date_value = isset($settlement[$date_column]) ? $settlement[$date_column] : (isset($settlement['payment_date']) ? $settlement['payment_date'] : ''); // Handle confirmation if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['confirm'])) { // Delete the settlement entry $sql = "DELETE FROM payment_settlements WHERE settlement_id = ?"; if (executeQuery($sql, "i", [$settlement_id])) { logActivity($_SESSION['user_id'], 'DELETE', 'payment_settlements', "Deleted payment settlement #$settlement_id"); header("Location: pending_payments.php?success=payment_deleted"); exit(); } else { $error = "Failed to delete payment settlement"; } } $page_title = 'Delete Payment'; require_once __DIR__ . '/../includes/header.php'; ?>

Delete Payment Settlement

⚠️ Confirm Deletion

Are you sure you want to delete this payment settlement? This action cannot be undone!

Supplier:
Payment Date:
Amount:	₹
Payment Mode:
Reference:
Notes:

⚠️ Warning: Deleting this payment will increase the supplier's pending amount by ₹