prepare($sql); $stmt->bind_param("i", $supplier_id); $stmt->execute(); $result = $stmt->get_result(); $supplier = $result->fetch_assoc(); if (!$supplier) { $error = "Supplier not found"; } // Get total supply from supply table $sql = "SELECT COALESCE(SUM(total_amount), 0) as total_supply FROM supply WHERE supplier_id = ?"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $supplier_id); $stmt->execute(); $result = $stmt->get_result(); $supply_data = $result->fetch_assoc(); $total_supply = $supply_data['total_supply']; // Get all payment settlements for this supplier $sql = "SELECT s.settlement_id, s.supplier_id, s.amount, s.payment_date, s.settlement_date, s.payment_mode, s.reference_number, s.upi_ref, s.notes, s.settled_by, s.created_at, u.full_name as settled_by_name FROM payment_settlements s LEFT JOIN users u ON s.settled_by = u.user_id WHERE s.supplier_id = ? ORDER BY s.created_at DESC"; $stmt = $conn->prepare($sql); $stmt->bind_param("i", $supplier_id); $stmt->execute(); $result = $stmt->get_result(); $settlements = []; $total_paid = 0; while ($row = $result->fetch_assoc()) { $settlements[] = $row; $total_paid += floatval($row['amount']); } $pending_amount = $total_supply - $total_paid; } catch (Exception $e) { $error = "Database error: " . $e->getMessage(); $supplier = null; $settlements = []; $total_supply = 0; $total_paid = 0; $pending_amount = 0; } $page_title = 'Payment History' . ($supplier ? ' - ' . htmlspecialchars($supplier['full_name']) : ''); require_once __DIR__ . '/../includes/header.php'; ?>