} # # print IP address # # ip - range if (@$addresses[$n]->class == "compressed-range") { print "<tr class='dhcp'>"; print "\t<td>"; # status icon if ($subnet['pingSubnet'] == "1") { print "\t\t<span class='status status-padded'></span>"; } print $Subnets->transform_to_dotted($addresses[$n]->ip_addr) . ' - ' . $Subnets->transform_to_dotted($addresses[$n]->stopIP) . " (" . $addresses[$n]->numHosts . ")"; print $Addresses->address_type_format_tag($addresses[$n]->state); print "\t</td>"; print "\t<td>" . $Addresses->address_type_index_to_type($addresses[$n]->state) . " (" . _("range") . ")</td>"; print "\t<td>" . $addresses[$n]->description . "</td>"; if ($colspan['dhcp'] != 0) { print "\t<td colspan='{$colspan['dhcp']}' class='unused'></td>"; } // tr ends after! } else { print "<tr>"; # status icon if ($subnet['pingSubnet'] == "1") { //calculate $tDiff = time() - strtotime($addresses[$n]->lastSeen); if ($addresses[$n]->excludePing == "1") { $hStatus = "padded"; $hTooltip = ""; } elseif ($tDiff < $statuses[0]) {
if ($result_addresses[$m]->subnetId != $result_addresses[$m - 1]->subnetId) { //new line $lineCount++; //subnet details $worksheet->write($lineCount, 0, $Subnets->transform_to_dotted($subnet['subnet']) . "/" . $subnet['mask'] . " - " . $subnet['description'] . $vlanText, $format_title); $worksheet->mergeCells($lineCount, 0, $lineCount, $colSpan - 1); //new line $lineCount++; } $m++; $x = 0; $worksheet->write($lineCount, $x, $Subnets->transform_to_dotted($ip['ip_addr']), $format_left); $x++; # state if (in_array('state', $selected_ip_fields)) { $worksheet->write($lineCount, $x, _($Addresses->address_type_index_to_type($ip['state']))); $x++; } $worksheet->write($lineCount, $x, $ip['description']); $x++; $worksheet->write($lineCount, $x, $ip['dns_name']); $x++; # switch if (in_array('switch', $selected_ip_fields)) { if (strlen($ip['switch']) > 0 && $ip['switch'] != 0) { $device = (array) $Tools->fetch_device(null, $ip['switch']); $ip['switch'] = $device != 0 ? $device['hostname'] : ""; } else { $ip['switch'] = ""; } $worksheet->write($lineCount, $x, $ip['switch']);