text-nowrap"> $vendor_name"; } else { $vendor_display = "N/A"; } if ($software_expire) { $software_expire_ago = timeAgo($software_expire); $software_expire_display = ""; // Convert the expiry date to a timestamp $software_expire_timestamp = strtotime($row['software_expire']); $current_timestamp = time(); // Get current timestamp // Calculate the difference in days $days_until_expiry = ($software_expire_timestamp - $current_timestamp) / (60 * 60 * 24); // Determine the class based on the number of days until expiry if ($days_until_expiry <= 0) { $tr_class = "table-secondary"; } elseif ($days_until_expiry <= 7) { $tr_class = "table-danger"; } elseif ($days_until_expiry <= 45) { $tr_class = "table-warning"; } else { $tr_class = ''; } } else { $software_expire_display = "N/A"; $tr_class = ''; } $software_created_at = nullable_htmlentities($row['software_created_at']); $seat_count = 0; // Asset Licenses $asset_licenses_sql = mysqli_query($mysqli, "SELECT asset_id FROM software_assets WHERE software_id = $software_id"); $asset_licenses_array = array(); while ($row = mysqli_fetch_array($asset_licenses_sql)) { $asset_licenses_array[] = intval($row['asset_id']); $seat_count = $seat_count + 1; } $asset_licenses = implode(',', $asset_licenses_array); // Contact Licenses $contact_licenses_sql = mysqli_query($mysqli, "SELECT contact_id FROM software_contacts WHERE software_id = $software_id"); $contact_licenses_array = array(); while ($row = mysqli_fetch_array($contact_licenses_sql)) { $contact_licenses_array[] = intval($row['contact_id']); $seat_count = $seat_count + 1; } $contact_licenses = implode(',', $contact_licenses_array); ?>

Software	Type	License Type	Seats	Expire	Vendor	Client	Action
$software_version"; ?>							Edit Archive and Remove Licenses Delete and Remove Licenses