Portions created by the Initial Developer are Copyright (C) 2008-2020 the Initial Developer. All Rights Reserved. Contributor(s): Mark J Crane */ //includes files require_once dirname(__DIR__, 2) . "/resources/require.php"; require_once "resources/check_auth.php"; //check permissions if (!permission_exists('contact_address_view')) { echo "access denied"; exit; } //get the address list $sql = "select * from v_contact_addresses "; $sql .= "where domain_uuid = :domain_uuid "; $sql .= "and contact_uuid = :contact_uuid "; $sql .= "order by address_primary desc, address_label asc "; $parameters['domain_uuid'] = $_SESSION['domain_uuid']; $parameters['contact_uuid'] = $contact_uuid ?? ''; $contact_addresses = $database->select($sql, $parameters, 'all'); unset($sql, $parameters); //show if exists if (!empty($contact_addresses)) { //show the content echo "
\n"; $x = 0; foreach ($contact_addresses as $row) { $map_query = $row['address_street']." ".$row['address_extended'].", ".$row['address_locality'].", ".$row['address_region'].", ".$row['address_region'].", ".$row['address_postal_code']; echo "
".escape($row['address_label'])."
\n"; // ($row['address_primary'] ? " " : null)."\n"; echo "
"; echo ""; $previous_data = false; if ($row['address_street']) { echo escape($row['address_street']); $previous_data = true; } if ($row['address_extended']) { echo $previous_data ? ', ' : null; echo escape($row['address_extended']); $previous_data = true; } if ($row['address_locality']) { echo $previous_data ? ', ' : null; echo escape($row['address_locality']); $previous_data = true; } if ($row['address_region']) { echo $previous_data ? ', ' : null; echo escape($row['address_region']); $previous_data = true; } if ($row['address_country']) { echo $previous_data ? ', ' : null; echo escape($row['address_country']); $previous_data = true; } echo ""; echo "
\n"; echo "
\n"; $x++; } echo "
\n"; unset($contact_addresses); } ?>