.
* ---------------------------------------------------------------------
*/
include ('../inc/includes.php');
Session::checkRight("reports", READ);
if (isset($_POST["prise"]) && $_POST["prise"]) {
Html::header(Report::getTypeName(Session::getPluralNumber()), $_SERVER['PHP_SELF'], "tools", "report");
Report::title();
$name = Dropdown::getDropdownName("glpi_netpoints", $_POST["prise"]);
// Titre
echo "
".sprintf(__('Network report by outlet: %s'), $name).
"
";
Report::reportForNetworkInformations(
'glpi_netpoints', //from
['PORT_1' => 'id', 'glpi_networkportethernets' => 'networkports_id'], //joincrit
['glpi_netpoints.id' => (int) $_POST["prise"]], //where
['glpi_locations.completename AS extra'], //select
[
'glpi_locations' => [
'ON' => [
'glpi_locations' => 'id',
'glpi_netpoints' => 'locations_id'
]
]
], //left join
[
'glpi_networkportethernets' => [
'ON' => [
'glpi_networkportethernets' => 'netpoints_id',
'glpi_netpoints' => 'id'
]
]
], //inner join
[], //order
Location::getTypeName()
);
Html::footer();
} else {
Html::redirect($CFG_GLPI['root_doc']."/front/report.networking.php");
}