/**
* Show the aliases contained by the alias
*
* @param $item the FQDN owning the aliases
* @param $withtemplate integer withtemplate param
**/
static function showForFQDN(CommonGLPI $item, $withtemplate)
{
global $DB;
$alias = new self();
$address = new NetworkName();
$item->check($item->getID(), 'r');
$canedit = $item->can($item->getID(), 'w');
if (isset($_POST["start"])) {
$start = $_POST["start"];
} else {
$start = 0;
}
if (!empty($_POST["order"])) {
$order = $_POST["order"];
} else {
$order = "alias";
}
$number = countElementsInTable($alias->getTable(), "`fqdns_id`='" . $item->getID() . "'");
echo "<br><div class='center'>";
if ($number < 1) {
echo "<table class='tab_cadre_fixe'>";
echo "<tr><th>" . self::getTypeName(1) . "</th><th>" . __('No item found') . "</th></tr>";
echo "</table>\n";
} else {
Html::printAjaxPager(self::getTypeName($number), $start, $number);
echo "<table class='tab_cadre_fixe'><tr>";
echo "<th><a href='javascript:reloadTab(\"order=alias\");'>" . self::getTypeName(1) . "</a></th>";
// Alias
echo "<th><a href='javascript:reloadTab(\"order=realname\");'>" . __("Computer's name") . "</a></th>";
echo "<th>" . __('Comments') . "</th>";
echo "</tr>\n";
Session::initNavigateListItems($item->getType(), sprintf(__('%1$s = %2$s'), self::getTypeName(1), $item->fields['name']));
$query = "SELECT `glpi_networkaliases`.`id` AS alias_id,\n `glpi_networkaliases`.`name` AS alias,\n `glpi_networknames`.`id` AS address_id,\n `glpi_networkaliases`.`comment` AS comment\n FROM `glpi_networkaliases`, `glpi_networknames`\n WHERE `glpi_networkaliases`.`fqdns_id` = '" . $item->getID() . "'\n AND `glpi_networknames`.`id` = `glpi_networkaliases`.`networknames_id`\n ORDER BY `{$order}`\n LIMIT " . $_SESSION['glpilist_limit'] . "\n OFFSET {$start}";
foreach ($DB->request($query) as $data) {
Session::addToNavigateListItems($alias->getType(), $data["alias_id"]);
if ($address->getFromDB($data["address_id"])) {
echo "<tr class='tab_bg_1'>";
echo "<td><a href='" . $alias->getFormURL() . '?id=' . $data['alias_id'] . "'>" . $data['alias'] . "</a></td>";
echo "<td><a href='" . $address->getLinkURL() . "'>" . $address->getInternetName() . "</a></td>";
echo "<td>" . $data['comment'] . "</td>";
echo "</tr>\n";
}
}
echo "</table>\n";
Html::printAjaxPager(self::getTypeName($number), $start, $number);
}
echo "</div>\n";
}
