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, u2.full_name as settled_by_name FROM payment_settlements ps JOIN users u ON ps.supplier_id = u.user_id JOIN users u2 ON ps.settled_by = u2.user_id WHERE ps.settlement_id = ? ", "i", [$settlement_id]); if (!$settlement) { die("Payment settlement not found. Go back"); } // Handle form submission if ($_SERVER['REQUEST_METHOD'] === 'POST') { $payment_date = $_POST['payment_date']; $amount = floatval($_POST['amount']); $payment_mode = $_POST['payment_mode']; $reference_number = trim($_POST['reference_number']); $notes = trim($_POST['notes']); // Validation if (empty($payment_date) || $amount <= 0) { $error = "Please fill all required fields with valid values"; } else { // Update settlement $sql = "UPDATE payment_settlements SET $date_column = ?, amount = ?, payment_mode = ?, reference_number = ?, notes = ? WHERE settlement_id = ?"; if (executeQuery($sql, "sdsssi", [$payment_date, $amount, $payment_mode, $reference_number, $notes, $settlement_id])) { logActivity($_SESSION['user_id'], 'UPDATE', 'payment_settlements', "Edited payment settlement #$settlement_id"); $success = "Payment settlement updated successfully!"; // Reload settlement data $settlement = fetchSingle(" SELECT ps.*, u.full_name as supplier_name, u2.full_name as settled_by_name FROM payment_settlements ps JOIN users u ON ps.supplier_id = u.user_id JOIN users u2 ON ps.settled_by = u2.user_id WHERE ps.settlement_id = ? ", "i", [$settlement_id]); } else { $error = "Failed to update payment settlement"; } } } // Get date value $date_value = isset($settlement[$date_column]) ? $settlement[$date_column] : (isset($settlement['payment_date']) ? $settlement['payment_date'] : ''); $page_title = 'Edit Payment Settlement'; require_once __DIR__ . '/../includes/header.php'; ?>

Edit Payment Settlement #

Current Details

₹

Edit Payment Settlement

Cancel 🗑️ Delete Payment