<?php
// TEMP: show errors while testing. Remove these two lines once it's stable.
error_reporting(E_ALL);
ini_set('display_errors', 1);

include('../../mpd/dbPeggy2.php');

// Simple helper for safe output
function h($str) {
    return htmlspecialchars($str === null ? '' : $str, ENT_QUOTES, 'UTF-8');
}

// Read filters from GET (compatible with older PHP)
$filterCity   = isset($_GET['city'])   ? trim($_GET['city'])   : '';
$filterRadius = isset($_GET['radius']) ? trim($_GET['radius']) : ''; // "10", "25", "50", "100"

$posts     = [];
$errorMsg  = '';
$infoMsg   = '';
$centerLat = null;
$centerLng = null;

// Validate radius – treat as valid only if numeric
$radiusNumeric = null;
if ($filterRadius !== '' && is_numeric($filterRadius)) {
    $radiusNumeric = (float)$filterRadius;
}

/*
 * STEP 1: Look up coordinates for the selected town/city in pcode1
 * We try pcode1.city, pcode1.place, and pcode1.town so it is forgiving.
 */
if ($db && $filterCity !== '' && $radiusNumeric !== null) {
    $sqlGeo = "SELECT latitude, longitude
               FROM pcode1
               WHERE city = ?
                  OR place = ?
                  OR town = ?
               LIMIT 1";
    $stmtGeo = $db->prepare($sqlGeo);

    if ($stmtGeo) {
        $stmtGeo->bind_param("sss", $filterCity, $filterCity, $filterCity);
        if ($stmtGeo->execute()) {
            $stmtGeo->bind_result($lat, $lng);
            if ($stmtGeo->fetch()) {
                $centerLat = (float)$lat;
                $centerLng = (float)$lng;
            } else {
                $infoMsg = "Could not find coordinates for '{$filterCity}' in location table. "
                         . "Filtering will use the town/city name only.";
            }
        } else {
            $errorMsg = "Geo lookup error: " . $stmtGeo->error;
        }
        $stmtGeo->close();
    } else {
        $errorMsg = "Geo lookup error: could not prepare statement.";
    }
}

/*
 * STEP 2: Fetch landlord posts, using radius (Haversine) when possible,
 * otherwise simple filtering by city (or all posts if no filter).
 */
if (!$db) {
    $errorMsg = 'Database connection error.';
} elseif ($errorMsg === '') {

    // 2A. We have city + radius + coords -> use Haversine
    if ($filterCity !== '' && $radiusNumeric !== null && $centerLat !== null && $centerLng !== null) {
        // Earth radius ~3959 miles
        $sql = "
            SELECT 
                l.id,
                l.gender,
                l.first_name,
                l.last_name,
                l.comments,
                l.event2,
                l.city,
                p.latitude,
                p.longitude,
                (3959 * ACOS(
                    COS(RADIANS(?)) * COS(RADIANS(p.latitude)) *
                    COS(RADIANS(p.longitude) - RADIANS(?)) +
                    SIN(RADIANS(?)) * SIN(RADIANS(p.latitude))
                )) AS distance
            FROM gbrLANDLORD l
            JOIN pcode1 p
                ON  l.city = p.city
                OR  l.city = p.place
                OR  l.city = p.town
            HAVING distance <= ?
            ORDER BY distance ASC, l.id DESC
        ";

        $stmt = $db->prepare($sql);
        if ($stmt === false) {
            $errorMsg = 'Database query error: could not prepare statement.';
        } else {
            // lat, lng, lat, radius
            $stmt->bind_param("dddd", $centerLat, $centerLng, $centerLat, $radiusNumeric);
            if ($stmt->execute()) {
                if (method_exists($stmt, 'get_result')) {
                    // Easiest path if mysqlnd is available
                    $result = $stmt->get_result();
                    while ($row = $result->fetch_assoc()) {
                        $posts[] = $row;
                    }
                } else {
                    // Fallback if get_result() is not available
                    $stmt->bind_result(
                        $id,
                        $gender,
                        $first_name,
                        $last_name,
                        $comments,
                        $event2,
                        $city,
                        $plat,
                        $plng,
                        $distance
                    );
                    while ($stmt->fetch()) {
                        $posts[] = [
                            'id'         => $id,
                            'gender'     => $gender,
                            'first_name' => $first_name,
                            'last_name'  => $last_name,
                            'comments'   => $comments,
                            'event2'     => $event2,
                            'city'       => $city,
                            'distance'   => $distance
                        ];
                    }
                }
                $stmt->close();
            } else {
                $errorMsg = 'Database query error: ' . $stmt->error;
                $stmt->close();
            }
        }

    // 2B. Fallback: no valid radius or no coords -> simple name-based or full listing
    } else {
        $sql   = "SELECT id, gender, first_name, last_name, comments, event2, city
                  FROM gbrLANDLORD";
        $types = '';
        $args  = [];

        if (