82 lines
2.6 KiB
PHP
82 lines
2.6 KiB
PHP
<?php
|
|
/**
|
|
* ---------------------------------------------------------------------
|
|
* GLPI - Gestionnaire Libre de Parc Informatique
|
|
* Copyright (C) 2015-2020 Teclib' and contributors.
|
|
*
|
|
* http://glpi-project.org
|
|
*
|
|
* based on GLPI - Gestionnaire Libre de Parc Informatique
|
|
* Copyright (C) 2003-2014 by the INDEPNET Development Team.
|
|
*
|
|
* ---------------------------------------------------------------------
|
|
*
|
|
* LICENSE
|
|
*
|
|
* This file is part of GLPI.
|
|
*
|
|
* GLPI 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 2 of the License, or
|
|
* (at your option) any later version.
|
|
*
|
|
* GLPI 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 GLPI. If not, see <http://www.gnu.org/licenses/>.
|
|
* ---------------------------------------------------------------------
|
|
*/
|
|
|
|
include ('../inc/includes.php');
|
|
|
|
Session::checkRight("reports", READ);
|
|
|
|
if (isset($_POST["locations_id"]) && $_POST["locations_id"]) {
|
|
Html::header(Report::getTypeName(Session::getPluralNumber()), $_SERVER['PHP_SELF'], "tools", "report");
|
|
|
|
Report::title();
|
|
|
|
// Titre
|
|
$name = Dropdown::getDropdownName("glpi_locations", $_POST["locations_id"]);
|
|
echo "<div class='center spaced'><h2>".sprintf(__('Network report by location: %s'), $name).
|
|
"</h2></div>";
|
|
|
|
$where = [];
|
|
if (!empty($_POST['locations_id'])) {
|
|
$sons = getSonsOf('glpi_locations', $_POST['locations_id']);
|
|
$where = ['glpi_locations.id' => $sons];
|
|
}
|
|
|
|
Report::reportForNetworkInformations(
|
|
'glpi_locations', //from
|
|
['PORT_1' => 'id', 'glpi_networkportethernets' => 'networkports_id'], //joincrit
|
|
$where, //where
|
|
['glpi_netpoints.name AS extra'], //select
|
|
[], //left join
|
|
[
|
|
'glpi_netpoints' => [
|
|
'ON' => [
|
|
'glpi_netpoints' => 'locations_id',
|
|
'glpi_locations' => 'id'
|
|
]
|
|
],
|
|
'glpi_networkportethernets' => [
|
|
'ON' => [
|
|
'glpi_networkportethernets' => 'netpoints_id',
|
|
'glpi_netpoints' => 'id'
|
|
]
|
|
]
|
|
], //inner join
|
|
['glpi_locations.completename', 'PORT_1.name'], //order
|
|
Netpoint::getTypeName()
|
|
);
|
|
|
|
Html::footer();
|
|
|
|
} else {
|
|
Html::redirect($CFG_GLPI['root_doc']."/front/report.networking.php");
|
|
}
|