<?php

/**
 * ---------------------------------------------------------------------
 *
 * GLPI - Gestionnaire Libre de Parc Informatique
 *
 * http://glpi-project.org
 *
 * @copyright 2015-2023 Teclib' and contributors.
 * @copyright 2003-2014 by the INDEPNET Development Team.
 * @licence   https://www.gnu.org/licenses/gpl-3.0.html
 *
 * ---------------------------------------------------------------------
 *
 * LICENSE
 *
 * This file is part of GLPI.
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program.  If not, see <https://www.gnu.org/licenses/>.
 *
 * ---------------------------------------------------------------------
 */

use Glpi\Application\View\TemplateRenderer;

/**
 * NetworkName Class
 *
 * represent the internet name of an element.
 * It is compose of the name itself, its domain and one or several IP addresses (IPv4 and/or IPv6).
 * An address can be affected to an item, or can be "free" to be reuse by another item
 * (for instance, in case of maintenance, when you change the network card of a computer,
 *  but not its network information)
 *
 * @since 0.84
 **/
class NetworkName extends FQDNLabel
{
   // From CommonDBChild
    public static $itemtype              = 'itemtype';
    public static $items_id              = 'items_id';
    public $dohistory                    = true;

    protected static $forward_entity_to  = ['IPAddress', 'NetworkAlias'];

    public static $canDeleteOnItemClean  = false;

    public static $checkParentRights     = CommonDBConnexity::HAVE_SAME_RIGHT_ON_ITEM;

    public static $mustBeAttached        = false;

    public static $rightname                   = 'internet';


    public static function getTypeName($nb = 0)
    {
        return _n('Network name', 'Network names', $nb);
    }

    public function useDeletedToLockIfDynamic()
    {
        return false;
    }


    public function defineTabs($options = [])
    {

        $ong  = [];
        $this->addDefaultFormTab($ong);
        $this->addStandardTab('NetworkAlias', $ong, $options);
        $this->addStandardTab('Lock', $ong, $options);
        $this->addStandardTab('Log', $ong, $options);

        return $ong;
    }

    /**
     * Print the network name form
     *
     * @param $ID        integer ID of the item
     * @param $options   array
     *     - target for the Form
     *     - withtemplate template or basic computer
     *
     *@return void
     **/
    public function showForm($ID, array $options = [])
    {
        $this->initForm($ID, $options);

        $recursiveItems = $this->recursivelyGetItems();
        if (count($recursiveItems) != 0) {
            $lastItem               = $recursiveItems[count($recursiveItems) - 1];
            $options['entities_id'] = $lastItem->getField('entities_id');
        }

        $recursive_items_type_data = _n('Associated element', 'Associated elements', Session::getPluralNumber());
        if (count($recursiveItems) > 0) {
            $recursive_items_type_data = $this->displayRecursiveItems($recursiveItems, 'Type', false);
        }

        $display_recursive_items_link = $this->displayRecursiveItems($recursiveItems, 'Link', false);
        $display_dissociate_btn = false;
        if ((count($recursiveItems) > 0) && $this->canUpdate()) {
            $display_dissociate_btn = true;
        }


        TemplateRenderer::getInstance()->display('components/form/networkname.html.twig', [
            'ID'                            => $ID,
            'display_dissociate_btn'        => $display_dissociate_btn,
            'recursive_items_type_data'     => $recursive_items_type_data,
            'display_recursive_items_link'  => $display_recursive_items_link,
            'item'                          => $this,
            'params'                        => $options,
        ]);

        return true;
    }


    public function rawSearchOptions()
    {
        $tab = parent::rawSearchOptions();

        $tab[] = [
            'id'                 => '12',
            'table'              => 'glpi_fqdns',
            'field'              => 'fqdn',
            'name'               => FQDN::getTypeName(1),
            'datatype'           => 'dropdown'
        ];

        $tab[] = [
            'id'                 => '13',
            'table'              => 'glpi_ipaddresses',
            'field'              => 'name',
            'name'               => IPAddress::getTypeName(1),
            'joinparams'         => [
                'jointype'           => 'itemtype_item'
            ],
            'forcegroupby'       => true,
            'massiveaction'      => false,
            'datatype'           => 'dropdown'
        ];

        $tab[] = [
            'id'                 => '20',
            'table'              => $this->getTable(),
            'field'              => 'itemtype',
            'name'               => _n('Type', 'Types', 1),
            'datatype'           => 'itemtype',
            'massiveaction'      => false
        ];

        $tab[] = [
            'id'                 => '21',
            'table'              => $this->getTable(),
            'field'              => 'items_id',
            'name'               => __('ID'),
            'datatype'           => 'integer',
            'massiveaction'      => false
        ];

        return $tab;
    }


    /**
     * @param $tab          array   the array to fill
     * @param $joinparams   array
     **/
    public static function rawSearchOptionsToAdd(array &$tab, array $joinparams)
    {
        $tab[] = [
            'id'                 => '126',
            'table'              => 'glpi_ipaddresses',
            'field'              => 'name',
            'name'               => __('IP'),
            'forcegroupby'       => true,
            'massiveaction'      => false,
            'joinparams'         => [
                'jointype'  => 'mainitemtype_mainitem',
                'condition' => ['NEWTABLE.is_deleted' => 0,
                    'NOT' => ['NEWTABLE.name' => '']
                ]
            ]
        ];

        $tab[] = [
            'id'                 => '127',
            'table'              => 'glpi_networknames',
            'field'              => 'name',
            'name'               => self::getTypeName(Session::getPluralNumber()),
            'forcegroupby'       => true,
            'massiveaction'      => false,
            'joinparams'         => $joinparams
        ];

        $tab[] = [
            'id'                 => '128',
            'table'              => 'glpi_networkaliases',
            'field'              => 'name',
            'name'               => NetworkAlias::getTypeName(Session::getPluralNumber()),
            'forcegroupby'       => true,
            'massiveaction'      => false,
            'joinparams'         => [
                'jointype'   => 'child',
                'beforejoin' => [
                    'table'      => 'glpi_networknames',
                    'joinparams' => $joinparams
                ]
            ]
        ];
    }


    /**
     * \brief Update IPAddress database
     * Update IPAddress database to remove old IPs and add new ones.
     **/
    public function post_workOnItem()
    {

        if (
            (isset($this->input['_ipaddresses']))
            && (is_array($this->input['_ipaddresses']))
        ) {
            $input = ['itemtype' => 'NetworkName',
                'items_id' => $this->getID()
            ];
            foreach ($this->input['_ipaddresses'] as $id => $ip) {
                $ipaddress     = new IPAddress();
                $input['name'] = $ip;
                if ($id < 0) {
                    if (!empty($ip)) {
                        $ipaddress->add($input);
                    }
                } else {
                    if (!empty($ip)) {
                        $input['id'] = $id;
                        $ipaddress->update($input);
                        unset($input['id']);
                    } else {
                        $ipaddress->delete(['id' => $id]);
                    }
                }
            }
        }
    }


    public function post_addItem()
    {

        $this->post_workOnItem();
        parent::post_addItem();
    }


    public function post_updateItem($history = 1)
    {
        global $DB;

        $this->post_workOnItem();
        if (count($this->updates)) {
           // Update Ticket Tco
            if (
                in_array("itemtype", $this->updates)
                || in_array("items_id", $this->updates)
            ) {
                $ip = new IPAddress();
                // Update IPAddress
                foreach (
                    $DB->request(
                        'glpi_ipaddresses',
                        ['itemtype' => 'NetworkName',
                            'items_id' => $this->getID()
                        ]
                    ) as $data
                ) {
                    $ip->update(['id'       => $data['id'],
                        'itemtype' => 'NetworkName',
                        'items_id' => $this->getID()
                    ]);
                }
            }
        }
        parent::post_updateItem($history);
    }


    public function cleanDBonPurge()
    {

        $this->deleteChildrenAndRelationsFromDb(
            [
                IPAddress::class,
                NetworkAlias::class,
            ]
        );
    }


    /**
     * \brief dettach an address from an item
     *
     * The address can be unaffected, and remain "free"
     *
     * @param integer $items_id  the id of the item
     * @param string  $itemtype  the type of the item
     **/
    public static function unaffectAddressesOfItem($items_id, $itemtype)
    {
        global $DB;

        $iterator = $DB->request([
            'SELECT' => 'id',
            'FROM'   => self::getTable(),
            'WHERE'  => [
                'itemtype'  => $itemtype,
                'items_id'  => $items_id
            ]
        ]);

        foreach ($iterator as $networkNameID) {
            self::unaffectAddressByID($networkNameID['id']);
        }
    }


    /**
     * \brief dettach an address from an item
     *
     * The address can be unaffected, and remain "free"
     *
     * @param integer $networkNameID the id of the NetworkName
     **/
    public static function unaffectAddressByID($networkNameID)
    {
        return self::affectAddress($networkNameID, 0, '');
    }


    /**
     * @param $networkNameID
     * @param $items_id
     * @param $itemtype
     **/
    public static function affectAddress($networkNameID, $items_id, $itemtype)
    {
        $networkName = new self();
        return $networkName->update(['id'       => $networkNameID,
            'items_id' => $items_id,
            'itemtype' => $itemtype
        ]);
    }


    /**
     * Get the full name (internet name) of a NetworkName
     *
     * @param integer $ID  ID of the NetworkName
     *
     * @return string  its internet name, or empty string if invalid NetworkName
     **/
    public static function getInternetNameFromID($ID)
    {

        $networkName = new self();

        if ($networkName->can($ID, READ)) {
            return FQDNLabel::getInternetNameFromLabelAndDomainID(
                $networkName->fields["name"],
                $networkName->fields["fqdns_id"]
            );
        }
        return "";
    }


    /**
     * @param $networkPortID
     **/
    public static function showFormForNetworkPort($networkPortID)
    {
        global $DB, $CFG_GLPI;

        $name         = new self();
        $number_names = 0;

        if ($networkPortID > 0) {
            $iterator = $DB->request([
                'SELECT' => 'id',
                'FROM'   => $name->getTable(),
                'WHERE'  => [
                    'itemtype'     => 'NetworkPort',
                    'items_id'     => $networkPortID,
                    'is_deleted'   => 0
                ]
            ]);
            $numrows = count($iterator);

            if ($numrows > 1) {
                 echo "<tr class='tab_bg_1'><th colspan='4'>" .
                  __("Several network names available! Go to the tab 'Network Name' to manage them.") .
                  "</th></tr>\n";
                  return;
            }

            switch ($numrows) {
                case 1:
                    $result = $iterator->current();
                    $name->getFromDB($result['id']);
                    break;

                case 0:
                    $name->getEmpty();
                    break;
            }
        } else {
            $name->getEmpty();
        }

        echo "<tr class='tab_bg_1'><th colspan='4'>";
       // If the networkname is defined, we must be able to edit it. So we make a link
        if ($name->getID() > 0) {
            echo "<a href='" . $name->getLinkURL() . "'>" . self::getTypeName(1) . "</a>";
            echo "<input type='hidden' name='NetworkName_id' value='" . $name->getID() . "'>&nbsp;\n";
            Html::showSimpleForm(
                $name->getFormURL(),
                'unaffect',
                _sx('button', 'Dissociate'),
                ['id' => $name->getID()],
                $CFG_GLPI["root_doc"] . '/pics/sub_dropdown.png'
            );
        } else {
            echo self::getTypeName(1);
        }
        echo "</th>\n";

        echo "</tr><tr class='tab_bg_1'>";

        echo "<td>" . self::getTypeName(1) . "</td><td>\n";
        echo Html::input('NetworkName_name', ['value' => $name->fields['name']]);
        echo "</td>\n";

        echo "<td>" . FQDN::getTypeName(1) . "</td><td>";
        Dropdown::show(
            getItemTypeForTable(getTableNameForForeignKeyField("fqdns_id")),
            ['value'       => $name->fields["fqdns_id"],
                'name'        => 'NetworkName_fqdns_id',
                'entity'      => $name->getEntityID(),
                'displaywith' => ['view']
            ]
        );
        echo "</td>\n";

        echo "</tr><tr class='tab_bg_1'>\n";

        echo "<td>" . IPAddress::getTypeName(Session::getPluralNumber());
        IPAddress::showAddChildButtonForItemForm($name, 'NetworkName__ipaddresses');
        echo "</td>";
        echo "<td>";
        IPAddress::showChildsForItemForm($name, 'NetworkName__ipaddresses');
        echo "</td>";

       // MoYo : really need to display it here ?
       // make confure because not updatable
       // echo "<td>".IPNetwork::getTypeName(Session::getPluralNumber())."&nbsp;";
       // Html::showToolTip(__('IP network is not included in the database. However, you can see current available networks.'));
       // echo "</td><td>";
       // IPNetwork::showIPNetworkProperties($name->getEntityID());
       // echo "</td>\n";
        echo "<td colspan='2'>&nbsp;</td>";

        echo "</tr>\n";
    }


    /**
     * @since 0.84
     *
     * @param $itemtype
     * @param $base            HTMLTableBase object
     * @param $super           HTMLTableSuperHeader object (default NULL
     * @param $father          HTMLTableHeader object (default NULL)
     * @param $options   array
     **/
    public static function getHTMLTableHeader(
        $itemtype,
        HTMLTableBase $base,
        HTMLTableSuperHeader $super = null,
        HTMLTableHeader $father = null,
        array $options = []
    ) {

        $column_name = __CLASS__;
        if (
            isset($options['massiveactionnetworkname'])
            && $options['massiveactionnetworkname']
        ) {
            $delete_all_column = $base->addHeader(
                'delete',
                Html::getCheckAllAsCheckbox('mass' . __CLASS__ .
                                                                            $options['rand']),
                $super,
                $father
            );
            $delete_all_column->setHTMLClass('center');
        }
        if (!isset($options['dont_display'][$column_name])) {
            $content = self::getTypeName();
            if (isset($options['column_links'][$column_name])) {
                $content = "<a href='" . $options['column_links'][$column_name] . "'>$content</a>";
            }
            $father = $base->addHeader($column_name, $content, $super, $father);
            $father->setItemType('NetworkName');

            if (isset($options['display_isDynamic']) && ($options['display_isDynamic'])) {
                $father = $base->addHeader(
                    $column_name . '_dynamic',
                    __('Automatic inventory'),
                    $super,
                    $father
                );
            }
        }

        NetworkAlias::getHTMLTableHeader(__CLASS__, $base, $super, $father, $options);
        IPAddress::getHTMLTableHeader(__CLASS__, $base, $super, $father, $options);
    }


    /**
     * @since 0.84
     *
     * @param $row             HTMLTableRow object (default NULL)
     * @param $item            CommonDBTM object (default NULL)
     * @param $father          HTMLTableCell object (default NULL)
     * @param $options   array
     **/
    public static function getHTMLTableCellsForItem(
        HTMLTableRow $row = null,
        CommonDBTM $item = null,
        HTMLTableCell $father = null,
        array $options = []
    ) {
        global $DB;

        $column_name = __CLASS__;

        if (empty($item)) {
            if (empty($father)) {
                return;
            }
            $item = $father->getItem();
        }

        $table = static::getTable();
        $criteria = [
            'SELECT' => [
                "$table.id"
            ],
            'FROM'   => $table,
            'WHERE'  => []
        ];

        switch ($item->getType()) {
            case 'FQDN':
                $criteria['ORDERBY'] = "$table.name";

                if (isset($options['order'])) {
                    switch ($options['order']) {
                        case 'name':
                            break;

                        case 'ip':
                            $criteria['LEFT JOIN'] = [
                                'glpi_ipaddresses'   => [
                                    'glpi_ipaddresses'   => 'items_id',
                                    $table               => 'id', [
                                        'AND' => [
                                            'glpi_ipaddresses.itemtype'   => self::getType(),
                                            'glpi_ipaddresses.is_deleted' => 0
                                        ]
                                    ]
                                ]
                            ];
                            $criteria['ORDERBY'] = [
                                new QueryExpression("ISNULL (" . $DB->quoteName('glpi_ipaddresses.id') . ")"),
                                'glpi_ipaddresses.binary_3',
                                'glpi_ipaddresses.binary_2',
                                'glpi_ipaddresses.binary_1',
                                'glpi_ipaddresses.binary_0'
                            ];
                            break;

                        case 'alias':
                            $criteria['LEFT JOIN'] = [
                                'glpi_networkaliases'   => [
                                    'ON'  => [
                                        'glpi_networkaliases'   => 'networknames_id',
                                        $table                  => 'id'
                                    ]
                                ]
                            ];
                            $criteria['ORDERBY'] = [
                                new QueryExpression("ISNULL (" . $DB->quoteName('glpi_networkaliases.name') . ")"),
                                'glpi_networkaliases.name'
                            ];
                            break;
                    }
                }

                $criteria['WHERE'] = [
                    "$table.fqdns_id"    => $item->fields['id'],
                    "$table.is_deleted"  => 0
                ];
                break;

            case 'NetworkPort':
                $criteria['WHERE'] = [
                    'itemtype'     => $item->getType(),
                    'items_id'     => $item->getID(),
                    'is_deleted'   => 0
                ];
                break;

            case 'NetworkEquipment':
                $criteria['INNER JOIN'] = [
                    'glpi_networkports'  => [
                        'ON'  => [
                            'glpi_networkports'  => 'id',
                            $table               => 'items_id', [
                                'AND' => [
                                    "$table.itemtype"    => 'NetworkPort',
                                    "$table.is_deleted"  => 0
                                ]
                            ]
                        ]
                    ]
                ];
                $criteria['WHERE'] = [
                    'glpi_networkports.itemtype'  => $item->getType(),
                    'glpi_networkports.items_id'  => $item->getID()
                ];
                break;
        }

        if (isset($options['SQL_options'])) {
            $criteria = array_merge($criteria, $options['SQL_options']);
        }

        $canedit              = (isset($options['canedit']) && $options['canedit']);
        $createRow            = (isset($options['createRow']) && $options['createRow']);
        $options['createRow'] = false;
        $address              = new self();

        $iterator = $DB->request($criteria);
        foreach ($iterator as $line) {
            if ($address->getFromDB($line["id"])) {
                if ($createRow) {
                    $row = $row->createAnotherRow();
                }

                if (
                    isset($options['massiveactionnetworkname'])
                    && $options['massiveactionnetworkname']
                ) {
                    $header      = $row->getGroup()->getHeaderByName('Internet', 'delete');
                    $cell_value  = Html::getMassiveActionCheckBox(__CLASS__, $line["id"]);
                    $row->addCell($header, $cell_value, $father);
                }

                $internetName = $address->getInternetName();
                if (empty($internetName)) {
                    $internetName = "(" . $line["id"] . ")";
                }
                $content  = $internetName;
                if (Session::haveRight('internet', READ)) {
                    $content  = "<a href='" . $address->getLinkURL() . "'>" . $internetName . "</a>";
                }

                if (!isset($options['dont_display'][$column_name])) {
                    $header              = $row->getGroup()->getHeaderByName('Internet', $column_name);
                    $name_cell           = $row->addCell($header, $content, $father, $address);
                    if (isset($options['display_isDynamic']) && ($options['display_isDynamic'])) {
                        $dyn_header   = $row->getGroup()->getHeaderByName(
                            'Internet',
                            $column_name . '_dynamic'
                        );
                        $dynamic_cell = $row->addCell(
                            $dyn_header,
                            Dropdown::getYesNo($address->fields['is_dynamic']),
                            $name_cell
                        );
                        $father_for_children = $dynamic_cell;
                    } else {
                        $father_for_children = $name_cell;
                    }
                } else {
                    $father_for_children = $father;
                }

                NetworkAlias::getHTMLTableCellsForItem($row, $address, $father_for_children, $options);
                IPAddress::getHTMLTableCellsForItem($row, $address, $father_for_children, $options);
            }
        }
    }


    /**
     * \brief Show names for an item from its form
     * Beware that the rendering can be different if readden from direct item form (ie : add new
     * NetworkName, remove, ...) or if readden from item of the item (for instance from the computer
     * form through NetworkPort::ShowForItem).
     *
     * @param $item                     CommonGLPI object
     * @param $withtemplate   integer   withtemplate param (default 0)
     **/
    public static function showForItem(CommonDBTM $item, $withtemplate = 0)
    {
        $ID = $item->getID();
        if (!$item->can($ID, READ)) {
            return false;
        }

        $rand = mt_rand();

        if (
            ($item->getType() == 'NetworkPort')
            && Session::haveRight('internet', UPDATE)
            && $item->canUpdateItem()
        ) {
            $items_id = $item->getID();
            $itemtype = $item->getType();

            echo "<div class='firstbloc'>\n";
            echo "<form method='post' action='" . static::getFormURL() . "'>\n";
            echo "<table class='tab_cadre_fixe'>\n";
            echo "<tr><th colspan='4'>" . __('Add a network name') . "</th></tr>";

            echo "<tr class='tab_bg_1'><td class='right'>";
            echo "<input type='hidden' name='items_id' value='$items_id'>\n";
            echo "<input type='hidden' name='itemtype' value='$itemtype'>\n";
            echo __('Not associated');
            echo "</td><td class='left'>";
            self::dropdown([
                'name'      => 'addressID',
                'condition' => ['items_id' => 0]
            ]);
            echo "</td><td class='left'>";
            echo "<input type='submit' name='assign_address' value='" . _sx('button', 'Associate') .
                "' class='btn btn-primary'>";
            echo "</td>";
            if (static::canCreate()) {
                echo "<td class='right' width='30%'>";
                echo "<a href=\"" . static::getFormURL() . "?items_id=$items_id&amp;itemtype=$itemtype\">";
                echo __('Create a new network name') . "</a>";
                echo "</td>";
            }
            echo "</tr>\n";

            echo "</table>\n";
            Html::closeForm();
            echo "</div>\n";
        }

        $table_options = ['createRow' => true];
        $start = 0;

        if (
            ($item->getType() == 'FQDN')
            || ($item->getType() == 'NetworkEquipment')
        ) {
            if (isset($_GET["start"])) {
                $start = $_GET["start"];
            }

            if (!empty($_GET["order"])) {
                $table_options['order'] = $_GET["order"];
            } else {
                $table_options['order'] = 'name';
            }

            if ($item->getType() == 'FQDN') {
                $table_options['column_links'] = ['NetworkName'
                                                         => 'javascript:reloadTab("order=name");',
                    'NetworkAlias'
                                                         => 'javascript:reloadTab("order=alias");',
                    'IPAddress'
                                                         => 'javascript:reloadTab("order=ip");'
                ];
            }

            $table_options['SQL_options']  = [
                'LIMIT'  => $_SESSION['glpilist_limit'],
                'START'  => $start
            ];

            $canedit = false;
        } else {
            $canedit = Session::haveRight('internet', UPDATE) && $item->canUpdateItem();
        }

        $table_options['canedit']                  = false;
        $table_options['rand']                     = $rand;
        $table_options['massiveactionnetworkname'] = $canedit;
        $table                                     = new HTMLTableMain();
        $column                                    = $table->addHeader(
            'Internet',
            self::getTypeName(Session::getPluralNumber())
        );
        $t_group                                   = $table->createGroup('Main', '');

        self::getHTMLTableHeader(__CLASS__, $t_group, $column, null, $table_options);

        $t_row   = $t_group->createRow();

        self::getHTMLTableCellsForItem($t_row, $item, null, $table_options);

        if ($table->getNumberOfRows() > 0) {
            $number = $table->getNumberOfRows();
            if ($item->getType() == 'FQDN') {
                $number = min($_SESSION['glpilist_limit'], $table->getNumberOfRows());
                Html::printAjaxPager(self::getTypeName(Session::getPluralNumber()), $start, self::countForItem($item));
            }
            Session::initNavigateListItems(
                __CLASS__,
                //TRANS : %1$s is the itemtype name,
                                 //        %2$s is the name of the item (used for headings of a list)
                                        sprintf(
                                            __('%1$s = %2$s'),
                                            $item->getTypeName(1),
                                            $item->getName()
                                        )
            );
            if ($canedit && $number) {
                 Html::openMassiveActionsForm('mass' . __CLASS__ . $rand);
                 $massiveactionparams = ['num_displayed'    => min($_SESSION['glpilist_limit'], $number),
                     'container'        => 'mass' . __CLASS__ . $rand
                 ];
                 Html::showMassiveActions($massiveactionparams);
            }

            $table->display(['display_title_for_each_group'          => false,
                'display_thead'                         => false,
                'display_tfoot'                         => false,
                'display_header_on_foot_for_each_group' => true
            ]);

            if ($canedit && $number) {
                 $massiveactionparams['ontop'] = false;
                 Html::showMassiveActions($massiveactionparams);
                 Html::closeForm();
            }

            if ($item->getType() == 'FQDN') {
                Html::printAjaxPager(self::getTypeName(Session::getPluralNumber()), $start, self::countForItem($item));
            }
        } else {
            echo "<table class='tab_cadre_fixe'><tr><th>" . __('No network name found') . "</th></tr>";
            echo "</table>";
        }
    }


    public static function displayTabContentForItem(CommonGLPI $item, $tabnum = 1, $withtemplate = 0)
    {

        switch ($item->getType()) {
            case 'NetworkPort':
            case 'FQDN':
            case 'NetworkEquipment':
                self::showForItem($item, $withtemplate);
                break;
        }
        return true;
    }


    /**
     * @param $item      CommonDBTM object
     **/
    public static function countForItem(CommonDBTM $item)
    {
        global $DB;

        switch ($item->getType()) {
            case 'FQDN':
                return countElementsInTable(
                    'glpi_networknames',
                    ['fqdns_id'   => $item->fields["id"],
                        'is_deleted' => 0
                    ]
                );

            case 'NetworkPort':
                return countElementsInTable(
                    'glpi_networknames',
                    ['itemtype'   => $item->getType(),
                        'items_id'   => $item->getID(),
                        'is_deleted' => 0
                    ]
                );

            case 'NetworkEquipment':
                 $result = $DB->request([
                     'SELECT'          => ['COUNT DISTINCT' => 'glpi_networknames.id AS cpt'],
                     'FROM'            => 'glpi_networknames',
                     'INNER JOIN'       => [
                         'glpi_networkports'  => [
                             'ON' => [
                                 'glpi_networknames'  => 'items_id',
                                 'glpi_networkports'  => 'id', [
                                     'AND' => [
                                         'glpi_networknames.itemtype' => 'NetworkPort'
                                     ]
                                 ]
                             ]
                         ]
                     ],
                     'WHERE'           => [
                         'glpi_networkports.itemtype'     => $item->getType(),
                         'glpi_networkports.items_id'     => $item->getID(),
                         'glpi_networkports.is_deleted'   => 0,
                         'glpi_networknames.is_deleted'   => 0
                     ]
                 ])->current();

                return (int)$result['cpt'];
        }
    }


    public function getTabNameForItem(CommonGLPI $item, $withtemplate = 0)
    {

        if (
            $item->getID()
            && $item->can($item->getField('id'), READ)
        ) {
            $nb = 0;
            if ($_SESSION['glpishow_count_on_tabs']) {
                $nb = self::countForItem($item);
            }
            return self::createTabEntry(self::getTypeName(Session::getPluralNumber()), $nb);
        }
        return '';
    }
}
