$service_importance"; } elseif ($service_importance == "Medium") { $service_importance_display = "$service_importance"; } elseif ($service_importance == "Low") { $service_importance_display = "$service_importance"; } else { $service_importance_display = "-"; } // Associated Assets (and their credentials/networks/locations) $sql_assets = mysqli_query( $mysqli, "SELECT * FROM service_assets LEFT JOIN assets ON service_assets.asset_id = assets.asset_id LEFT JOIN asset_interfaces ON interface_asset_id = assets.asset_id AND interface_primary = 1 LEFT JOIN credentials ON service_assets.asset_id = credentials.credential_asset_id LEFT JOIN networks ON interface_network_id = networks.network_id LEFT JOIN locations ON assets.asset_location_id = locations.location_id WHERE service_id = $service_id" ); // Associated credentials $sql_credentials = mysqli_query( $mysqli, "SELECT * FROM service_credentials LEFT JOIN credentials ON service_credentials.credential_id = credentials.credential_id WHERE service_id = $service_id" ); // Associated Domains $sql_domains = mysqli_query( $mysqli, "SELECT * FROM service_domains LEFT JOIN domains ON service_domains.domain_id = domains.domain_id WHERE service_id = $service_id" ); // Associated Certificates $sql_certificates = mysqli_query( $mysqli, "SELECT * FROM service_certificates LEFT JOIN certificates ON service_certificates.certificate_id = certificates.certificate_id WHERE service_id = $service_id" ); // Associated Vendors $sql_vendors = mysqli_query( $mysqli, "SELECT * FROM service_vendors LEFT JOIN vendors ON service_vendors.vendor_id = vendors.vendor_id WHERE service_id = $service_id" ); // Associated Contacts $sql_contacts = mysqli_query( $mysqli, "SELECT * FROM service_contacts LEFT JOIN contacts ON service_contacts.contact_id = contacts.contact_id WHERE service_id = $service_id" ); // Associated Documents $sql_docs = mysqli_query( $mysqli, "SELECT * FROM service_documents LEFT JOIN documents ON service_documents.document_id = documents.document_id WHERE service_id = $service_id" ); // Generate the HTML form content using output buffering. ob_start(); ?>

Service Overview:

Description:
Backup Info:

Notes
0) { echo "
Assets
    "; mysqli_data_seek($sql_assets, 0); while ($row = mysqli_fetch_array($sql_assets)) { $asset_id = intval($row['asset_id']); $asset_name = nullable_htmlentities($row['asset_name']); $ip = !empty($row['interface_ip']) ? '(' . nullable_htmlentities($row['interface_ip']) . ')' : ''; echo "
  • $asset_name$ip
    • "; } echo "
"; } ?> Networks
    "; foreach ($networks as $network) { $network_parts = explode(":", $network); $network_name = $network_parts[0]; $network_vlan = $network_parts[1] ?? ''; echo "
  • $network_name (VLAN $network_vlan)
    • "; } echo "
"; } } ?> Locations
    "; foreach ($location_names as $location) { echo "
  • $location
    • "; } echo "
"; } } ?> 0) { echo "
Domains
    "; mysqli_data_seek($sql_domains, 0); while ($row = mysqli_fetch_array($sql_domains)) { if (!empty($row['domain_name'])) { $domain_name = nullable_htmlentities($row['domain_name']); echo "
  • $domain_name
    • "; } } echo "
"; } ?> 0) { echo "
Certificates
    "; mysqli_data_seek($sql_certificates, 0); while ($row = mysqli_fetch_array($sql_certificates)) { if (!empty($row['certificate_name'])) { $certificate_name = nullable_htmlentities($row['certificate_name']); $certificate_domain = nullable_htmlentities($row['certificate_domain']); echo "
  • $certificate_name ($certificate_domain)
    • "; } } echo "
"; } ?>

Additional Related Items


0) { echo "
Vendors
    "; mysqli_data_seek($sql_vendors, 0); while ($row = mysqli_fetch_array($sql_vendors)) { $vendor_id = intval($row['vendor_id']); $vendor_name = nullable_htmlentities($row['vendor_name']); echo "
  • $vendor_name
    • "; } echo "
"; } ?> 0) { echo "
Contacts
    "; mysqli_data_seek($sql_contacts, 0); while ($row = mysqli_fetch_array($sql_contacts)) { $contact_id = intval($row['contact_id']); $contact_name = nullable_htmlentities($row['contact_name']); echo "
  • $contact_name
    • "; } echo "
"; } ?> 0 || mysqli_num_rows($sql_credentials) > 0) { echo "
Credentials
    "; // Credentials linked to assets mysqli_data_seek($sql_assets, 0); while ($row = mysqli_fetch_array($sql_assets)) { $credential_name = nullable_htmlentities($row['credential_name']); if (!empty($credential_name)) { echo "
  • $credential_name
    • "; } } // Explicitly linked credentials mysqli_data_seek($sql_credentials, 0); while ($row = mysqli_fetch_array($sql_credentials)) { $credential_name = nullable_htmlentities($row['credential_name']); if (!empty($credential_name)) { echo "
  • $credential_name
    • "; } } echo "
"; } ?> URLs
    "; foreach ($urls as $url) { $label = htmlspecialchars(parse_url($url, PHP_URL_HOST) ?: $url); echo "
  • $label
    • "; } echo "
"; } ?> 0) { echo "
Documents
    "; mysqli_data_seek($sql_docs, 0); while ($row = mysqli_fetch_array($sql_docs)) { $document_id = intval($row['document_id']); $document_name = nullable_htmlentities($row['document_name']); echo "
  • $document_name
    • "; } echo "
"; } ?>