getConnection(); // Recupera i dettagli dell'immobile $stmt = $pdo->prepare("SELECT name, address, zip, city, country FROM home WHERE idhome = ?"); $stmt->execute([$idhome]); $homeDetails = $stmt->fetch(PDO::FETCH_ASSOC); if (!$homeDetails) { die("Immobile non trovato o accesso non autorizzato."); } // Recupera i proprietari associati all'immobile $stmt = $pdo->prepare(" SELECT po.owner_id, po.first_name, po.last_name, po.company_name, po.tax_code, po.email, ho.ownership_percentage, ho.notes FROM home_owners AS ho INNER JOIN property_owners AS po ON ho.owner_id = po.owner_id WHERE ho.home_id = ? "); $stmt->execute([$idhome]); $owners = $stmt->fetchAll(PDO::FETCH_ASSOC); // Recupera tutti i proprietari disponibili dell'utente per la selezione $stmt = $pdo->prepare(" SELECT owner_id, first_name, last_name, company_name, tax_code FROM property_owners WHERE user_id = ? AND owner_id NOT IN ( SELECT owner_id FROM home_owners WHERE home_id = ? ) "); $stmt->execute([$iduserlogin, $idhome]); $availableOwners = $stmt->fetchAll(PDO::FETCH_ASSOC); ?>

Proprietari
"; } ?>
Nome Codice Fiscale % Note Azioni
" . htmlspecialchars($owner['first_name'] . ' ' . $owner['last_name']) . " " . htmlspecialchars($owner['tax_code']) . " " . htmlspecialchars($owner['ownership_percentage']) . " " . htmlspecialchars($owner['notes']) . "
Totale % Proprietà: %

Nessun proprietario associato.

Assegna Proprietari