0) { // Retrieve owner details $queryOwner = $conn->prepare(" SELECT first_name, last_name, company_name, owner_type FROM property_owners WHERE owner_id = ? AND user_id = ? "); $queryOwner->bind_param('ii', $owner_id, $iduserlogin); $queryOwner->execute(); $resultOwner = $queryOwner->get_result(); $ownerDetails = $resultOwner->fetch_assoc(); if (!$ownerDetails) { die('Errore: Proprietario non trovato o accesso non autorizzato.'); } // Set display name if ($ownerDetails['owner_type'] === 'individual') { $ownerName = $ownerDetails['first_name'] . ' ' . $ownerDetails['last_name']; } else { $ownerName = $ownerDetails['company_name']; } // Make owner_id available to JavaScript echo ""; } else { die('Errore: ID proprietario non valido.'); } } else { die('Errore: Accesso non autorizzato.'); } // Set default slug to "person" $docpage = "person"; // Retrieve page_id for the "person" slug $queryPageId = $conn->prepare("SELECT idpages FROM pages WHERE slug = ?"); $queryPageId->bind_param('s', $docpage); $queryPageId->execute(); $resultPageId = $queryPageId->get_result(); $pageData = $resultPageId->fetch_assoc(); if ($pageData) { $page_id = $pageData['idpages']; // Page ID found } else { die("Errore: Pagina non valida."); // Slug not found } // Retrieve documents associated with page_id, including sections $queryDocuments = $conn->prepare(" SELECT d.*, s.section_name AS section_name FROM documents d LEFT JOIN sections s ON d.idsections = s.idsections WHERE d.page_id = ? ORDER BY s.section_name, d.document_name "); $queryDocuments->bind_param('i', $page_id); $queryDocuments->execute(); $resultDocuments = $queryDocuments->get_result(); $documents = []; while ($row = $resultDocuments->fetch_assoc()) { $documents[$row['section_name']][] = $row; } // Retrieve already uploaded documents for this entity $queryLoadedDocuments = $conn->prepare(" SELECT * FROM doc_storage WHERE owner_id = ? "); $queryLoadedDocuments->bind_param('i', $owner_id); $queryLoadedDocuments->execute(); $resultLoadedDocuments = $queryLoadedDocuments->get_result(); $loadedDocuments = []; while ($row = $resultLoadedDocuments->fetch_assoc()) { $loadedDocuments[$row['document_id']][] = $row; } ?> Documenti della Casa

Documenti per:

$sectionDocuments) { ?>

(Obbligatorio)"; ?> 0) echo " - Max: " . $document['max_documents']; ?>


Trascina qui i documenti o clicca per caricare
Documenti già caricati:
Nome Documento Data Caricamento Azioni