prepare("SELECT COUNT(*) AS total_homes FROM home WHERE iduser = ?");
$queryHomes->bind_param('i', $iduserlogin);
$queryHomes->execute();
$resultHomes = $queryHomes->get_result();
$totalHomes = $resultHomes->fetch_assoc()['total_homes'];
// Calcolo del numero di persone
$queryOwners = $conn->prepare("SELECT COUNT(*) AS total_owners FROM property_owners WHERE user_id = ?");
$queryOwners->bind_param('i', $iduserlogin);
$queryOwners->execute();
$resultOwners = $queryOwners->get_result();
$totalOwners = $resultOwners->fetch_assoc()['total_owners'];
// Numero di documenti (placeholder per ora)
// Calcolo del numero di documenti
$queryDocuments = $conn->prepare("
SELECT COUNT(*) AS total_documents
FROM doc_storage
LEFT JOIN home ON doc_storage.idhome = home.idhome
WHERE home.iduser = ?
");
$queryDocuments->bind_param('i', $iduserlogin);
$queryDocuments->execute();
$resultDocuments = $queryDocuments->get_result();
$totalDocuments = $resultDocuments->fetch_assoc()['total_documents'];
// Recupera l'id utente loggato
// Query per ottenere le case dell'utente
$sql = "
SELECT
h.idhome,
h.name,
h.address,
h.zip,
h.city,
h.country,
h.mainphoto,
COUNT(ho.owner_id) AS owner_count,
SUM(ho.ownership_percentage) AS total_ownership,
GROUP_CONCAT(
CASE
WHEN po.owner_type = 'individual'
THEN CONCAT(po.first_name, ' ', po.last_name, ' (', ho.ownership_percentage, '%)')
ELSE CONCAT(po.company_name, ' (', ho.ownership_percentage, '%)')
END
SEPARATOR '\n'
) AS owner_names
FROM
home h
LEFT JOIN
home_owners ho ON h.idhome = ho.home_id
LEFT JOIN
property_owners po ON ho.owner_id = po.owner_id
WHERE
h.iduser = ?
GROUP BY
h.idhome
";
$stmt = $conn->prepare($sql);
$stmt->bind_param('i', $iduserlogin);
$stmt->execute();
$result = $stmt->get_result();
?>
Elenco dei tuoi immobili
![<?php echo htmlspecialchars($row['name']); ?>](mainphoto/<?php echo htmlspecialchars($row['mainphoto'] ?? 'default.jpg'); ?>)