'That location no longer exists.']);
exit;
}
$client_id = intval($location['location_client_id']);
enforceClientAccess();
$location_name = escapeHtml($location['location_name']);
$location_address_text = locationAddressText($location, true);
$location_map_url = locationMapUrl($location);
$location_directions_url = locationDirectionsUrl($location);
$location_phone = contactPhoneLink($location['location_phone'], $location['location_phone_country_code'], $location['location_phone_extension']);
$location_hours = escapeHtml($location['location_hours']);
$location_notes = escapeHtml($location['location_notes']);
$location_archived = !empty($location['location_archived_at']);
$can_edit = lookupUserPermission('module_client') >= 2 && !$location_archived;
$can_support = lookupUserPermission('module_support') >= 1;
$people = $assets = $networks = [];
$open_tickets = [];
$sql = mysqli_query($mysqli, "SELECT contact_id, contact_name, contact_title, contact_photo, contact_client_id, contact_phone, contact_phone_country_code, contact_extension
FROM contacts WHERE contact_location_id = $location_id AND contact_archived_at IS NULL ORDER BY contact_primary DESC, contact_name ASC");
while ($row = mysqli_fetch_assoc($sql)) {
$people[] = $row;
}
if ($can_support) {
$sql = mysqli_query($mysqli, "SELECT asset_id, asset_name, asset_type, asset_make, asset_model, interface_ip FROM assets
LEFT JOIN asset_interfaces ON interface_asset_id = asset_id AND interface_primary = 1
WHERE asset_location_id = $location_id AND asset_archived_at IS NULL ORDER BY asset_type ASC, asset_name ASC");
while ($row = mysqli_fetch_assoc($sql)) {
$assets[] = $row;
}
$sql = mysqli_query($mysqli, "SELECT network_id, network_name, network_type, network, network_vlan, network_gateway FROM networks
WHERE network_location_id = $location_id AND network_archived_at IS NULL ORDER BY network_name ASC");
while ($row = mysqli_fetch_assoc($sql)) {
$networks[] = $row;
}
$open_tickets = ticketRows("tickets.ticket_location_id = $location_id AND " . TICKET_OPEN_SQL);
}
$quick_tabs = array_filter([
'people' => ['label' => 'People', 'count' => count($people)],
'assets' => ['label' => 'Assets', 'count' => count($assets)],
'networks' => ['label' => 'Networks', 'count' => count($networks)],
'tickets' => ['label' => 'Open tickets', 'count' => count($open_tickets)],
], function ($tab) {
return $tab['count'] > 0;
});
$first_tab = array_key_first($quick_tabs);
$quick_id = "location-quick-$location_id";
ob_start();
?>