function showForm($target, $ID)
{
global $DB, $CFG_GLPI, $LANG;
$history = new PluginFusioninventorySnmphistory();
if (!PluginFusioninventory::haveRight("snmp_networking", "r")) {
return false;
}
if (PluginFusioninventory::haveRight("snmp_networking", "w")) {
$canedit = true;
} else {
$canedit = false;
}
include GLPI_ROOT . "/plugins/fusioninventory/inc_constants/snmp.mapping.constant.php";
$this->ID = $ID;
$nw = new Netwire();
$CommonItem = new CommonItem();
$plugin_fusioninventory_snmp = new PluginFusioninventorySNMP();
echo "<script type='text/javascript' src='" . GLPI_ROOT . "/lib/extjs/adapter/prototype/prototype.js'></script>";
echo "<script type='text/javascript' src='" . GLPI_ROOT . "/lib/extjs/adapter/prototype/effects.js'></script>";
if (!($data = $this->find("`FK_networking`='" . $ID . "'", '', 1))) {
// Add in database if not exist
$input['FK_networking'] = $ID;
$ID_tn = $this->add($input);
$this->getFromDB($ID_tn);
} else {
foreach ($data as $ID_tn => $datas) {
$this->fields = $data[$ID_tn];
}
}
$PID = $this->fields['last_PID_update'];
// Form networking informations
echo "<div align='center'>\n <form method='post' name='snmp_form' id='snmp_form' action=\"" . $target . "\">";
echo "<table class='tab_cadre' cellpadding='5' width='950'>";
echo "<tr class='tab_bg_1'>";
echo "<th colspan='3'>";
echo $LANG['plugin_fusioninventory']["snmp"][11];
echo "</th>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td align='center'>" . $LANG['plugin_fusioninventory']["profile"][24] . "</td>";
echo "<td align='center'>";
$query_models = "SELECT * \n FROM `glpi_plugin_fusioninventory_model_infos`\n WHERE `device_type`!='2'\n AND `device_type`!='0';";
$result_models = $DB->query($query_models);
$exclude_models = array();
while ($data_models = $DB->fetch_array($result_models)) {
$exclude_models[] = $data_models['ID'];
}
Dropdown::show("PluginFusioninventoryModelInfos", array('name' => "model_infos", 'value' => $this->fields['FK_model_infos'], 'comments' => 0, 'used' => $exclude_models));
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td align='center'>" . $LANG['plugin_fusioninventory']["functionalities"][43] . "</td>";
echo "<td align='center'>";
PluginFusioninventorySNMP::auth_dropdown($this->fields['FK_snmp_connection']);
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1 center'>";
echo "<td>";
echo " <input type='submit' name='GetRightModel'\n value='" . $LANG['plugin_fusioninventory']["model_info"][13] . "' class='submit'/></td>";
echo "<td>";
echo "<input type='hidden' name='ID' value='" . $ID . "'>";
echo "<input type='submit' name='update' value=\"" . $LANG["buttons"][7] . "\" class='submit' >";
echo "</td>";
echo "</tr>";
echo "</table></form>";
// Remote action of agent
$pfit = new PluginFusioninventoryTask();
$pfit->RemoteStateAgent($target, $ID, NETWORKING_TYPE, array('INVENTORY' => 1));
// SNMP Informations
// echo "<div align='center'>
echo "<form method='post' name='snmp_form' id='snmp_form' action=\"" . $target . "\">";
echo "<table class='tab_cadre' cellpadding='5' width='950'>";
echo "<tr class='tab_bg_1'>";
echo "<th colspan='3'>";
echo $LANG['plugin_fusioninventory']["title"][1];
echo "</th>";
echo "</tr>";
echo "<tr class='tab_bg_1 center'>";
echo "<td colspan='2' height='30'>";
echo $LANG['plugin_fusioninventory']["snmp"][52] . ": " . convDateTime($this->fields['last_fusioninventory_update']);
echo "</td>";
echo "</tr>";
// Get link field to detect if cpu, memory and uptime are get onthis network device
$Array_Object_TypeNameConstant = $plugin_fusioninventory_snmp->GetLinkOidToFields($ID, NETWORKING_TYPE);
$mapping_name = array();
foreach ($Array_Object_TypeNameConstant as $object => $mapping_type_name) {
$mapping_name[$mapping_type_name] = "1";
}
if (isset($mapping_name['uptime']) and $mapping_name['uptime'] == "1") {
echo "<tr class='tab_bg_1 center'>";
echo "<td>" . $LANG['plugin_fusioninventory']["snmp"][12] . "</td>";
echo "<td>";
$sysUpTime = $this->fields['uptime'];
if (strstr($sysUpTime, "days")) {
list($day, $hour, $minute, $sec, $ticks) = sscanf($sysUpTime, "%d days, %d:%d:%d.%d");
} else {
if (strstr($sysUpTime, "hours")) {
$day = 0;
list($hour, $minute, $sec, $ticks) = sscanf($sysUpTime, "%d hours, %d:%d.%d");
} else {
if (strstr($sysUpTime, "minutes")) {
$day = 0;
$hour = 0;
list($minute, $sec, $ticks) = sscanf($sysUpTime, "%d minutes, %d.%d");
} else {
if ($sysUpTime == "0") {
$day = 0;
$hour = 0;
$minute = 0;
$sec = 0;
} else {
list($hour, $minute, $sec, $ticks) = sscanf($sysUpTime, "%d:%d:%d.%d");
$day = 0;
}
}
}
}
echo "<b>{$day}</b> " . $LANG["stats"][31] . " ";
echo "<b>{$hour}</b> " . $LANG["job"][21] . " ";
echo "<b>{$minute}</b> " . $LANG["job"][22] . " ";
echo " " . strtolower($LANG["rulesengine"][42]) . " <b>{$sec}</b> " . $LANG["stats"][34] . " ";
echo "</td>";
echo "</tr>";
}
if (isset($mapping_name['cpu']) and $mapping_name['cpu'] == "1" or isset($mapping_name['cpuuser']) and $mapping_name['cpuuser'] == "1" and (isset($mapping_name['cpusystem']) and $mapping_name['cpusystem'] == "1")) {
echo "<tr class='tab_bg_1 center'>";
echo "<td>" . $LANG['plugin_fusioninventory']["snmp"][13] . "</td>";
echo "<td>";
PluginFusioninventoryDisplay::bar($this->fields['cpu'], '', 'inverse');
echo "</td>";
echo "</tr>";
}
if (isset($mapping_name['memory']) and $mapping_name['memory'] == "1") {
echo "<tr class='tab_bg_1 center'>";
echo "<td>" . $LANG['plugin_fusioninventory']["snmp"][14] . "</td>";
echo "<td>";
$query2 = "SELECT *\n FROM `glpi_networking`\n WHERE `ID`='" . $ID . "';";
$result2 = $DB->query($query2);
$data2 = $DB->fetch_assoc($result2);
if (empty($data2["ram"])) {
$ram_pourcentage = 0;
} else {
$ram_pourcentage = ceil(100 * ($data2["ram"] - $this->fields['memory']) / $data2["ram"]);
}
PluginFusioninventoryDisplay::bar($ram_pourcentage, " (" . ($data2["ram"] - $this->fields['memory']) . " Mo / " . $data2["ram"] . " Mo)", 'inverse');
echo "</td>";
echo "</tr>";
}
echo "</table></form>";
// ********************************************************************************************** //
// *********************************** METTRE TABLEAU DES PORTS ********************************* //
// ********************************************************************************************** //
function ByteSize($bytes, $sizeoct = 1024)
{
$size = $bytes / $sizeoct;
if ($size < $sizeoct) {
$size = number_format($size, 0);
$size .= ' K';
} else {
if ($size / $sizeoct < $sizeoct) {
$size = number_format($size / $sizeoct, 0);
$size .= ' M';
} else {
if ($size / $sizeoct / $sizeoct < $sizeoct) {
$size = number_format($size / $sizeoct / $sizeoct, 0);
$size .= ' G';
} else {
if ($size / $sizeoct / $sizeoct / $sizeoct < $sizeoct) {
$size = number_format($size / $sizeoct / $sizeoct / $sizeoct, 0);
$size .= ' T';
}
}
}
}
return $size;
}
$query = "\n\t\tSELECT *,glpi_plugin_fusioninventory_networking_ports.ifmac as ifmacinternal\n\t\t\n\t\tFROM glpi_plugin_fusioninventory_networking_ports\n\n\t\tLEFT JOIN glpi_networking_ports\n\t\tON glpi_plugin_fusioninventory_networking_ports.FK_networking_ports = glpi_networking_ports.ID \n\t\tWHERE glpi_networking_ports.on_device='" . $ID . "'\n\t\tORDER BY logical_number ";
echo "<script type='text/javascript'>\nfunction close_array(id){\n\tdocument.getElementById('plusmoins'+id).innerHTML = '<img src=\\'" . GLPI_ROOT . "/pics/collapse.gif\\''+\n 'onClick=\\'Effect.Fade(\"viewfollowup'+id+'\");appear_array('+id+');\\' />';\n} \nfunction appear_array(id){\n\tdocument.getElementById('plusmoins'+id).innerHTML = '<img src=\\'" . GLPI_ROOT . "/pics/expand.gif\\''+\n 'onClick=\\'Effect.Appear(\"viewfollowup'+id+'\");close_array('+id+');\\' />';\n}\t\t\n\t\t\n\t\t</script>";
echo "<table class='tab_cadre' cellpadding='5' width='1100'>";
echo "<tr class='tab_bg_1'>";
$query_array = "SELECT *\n FROM `glpi_display`\n WHERE `type`='" . PLUGIN_FUSIONINVENTORY_SNMP_NETWORKING_PORTS . "'\n AND `FK_users`='0'\n ORDER BY `rank`;";
$result_array = $DB->query($query_array);
echo "<th colspan='" . (mysql_num_rows($result_array) + 2) . "'>";
echo $LANG['plugin_fusioninventory']["snmp"][40];
$result = $DB->query($query);
echo ' (' . $DB->numrows($result) . ')';
if ($_SESSION["glpilanguage"] == "fr_FR") {
$url_legend = "https://forge.indepnet.net/wiki/fusioninventory/Fr_VI_visualisationsdonnees_2_reseau";
} else {
$url_legend = "https://forge.indepnet.net/wiki/fusioninventory/En_VI_visualisationsdonnees_2_reseau";
}
echo " <a href='" . $url_legend . "'>[ " . $LANG['plugin_fusioninventory']["functionalities"][6] . " ]</a>";
echo "</th>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo '<th><img alt="Sélectionnez les éléments à afficher par défaut"
title="Sélectionnez les éléments à afficher par défaut"
src="' . GLPI_ROOT . '/pics/options_search.png" class="pointer"
onclick="var w = window.open(\'' . GLPI_ROOT . '/front/popup.php?popup=search_config&type=5157\' ,\'glpipopup\',
\'height=400,
width=1000, top=100, left=100, scrollbars=yes\' ); w.focus();"></th>';
echo "<th>" . $LANG["common"][16] . "</th>";
$query_array = "SELECT * \n FROM `glpi_display`\n WHERE `type`='5157'\n AND `FK_users`='0'\n ORDER BY `rank`;";
$result_array = $DB->query($query_array);
while ($data_array = $DB->fetch_array($result_array)) {
echo "<th>";
switch ($data_array['num']) {
case 2:
echo $LANG['plugin_fusioninventory']["snmp"][42];
break;
case 3:
echo $LANG['plugin_fusioninventory']["snmp"][43];
break;
case 4:
echo $LANG['plugin_fusioninventory']["snmp"][44];
break;
case 5:
echo $LANG['plugin_fusioninventory']["snmp"][45];
break;
case 6:
echo $LANG['plugin_fusioninventory']["snmp"][46];
break;
case 7:
echo $LANG['plugin_fusioninventory']["snmp"][47];
break;
case 8:
echo $LANG['plugin_fusioninventory']["snmp"][48];
break;
case 9:
echo $LANG['plugin_fusioninventory']["snmp"][49];
break;
case 10:
echo $LANG['plugin_fusioninventory']["snmp"][51];
break;
case 11:
echo $LANG['plugin_fusioninventory']["mapping"][115];
break;
case 12:
echo $LANG["networking"][17];
break;
case 13:
echo $LANG['plugin_fusioninventory']["snmp"][50];
break;
case 14:
echo $LANG["networking"][56];
break;
case 15:
echo $LANG['plugin_fusioninventory']["snmp"][41];
break;
}
echo "</th>";
}
echo "</tr>";
// Fin de l'entête du tableau
if ($result) {
while ($data = $DB->fetch_array($result)) {
$background_img = "";
if ($data["trunk"] == "1" and (strstr($data["ifstatus"], "up") or strstr($data["ifstatus"], "1"))) {
$background_img = " style='background-image: url(\"" . GLPI_ROOT . "/plugins/fusioninventory/pics/port_trunk.png\"); '";
} else {
if ($data["trunk"] == "-1" and (strstr($data["ifstatus"], "up") or strstr($data["ifstatus"], "1"))) {
$background_img = " style='background-image: url(\"" . GLPI_ROOT . "/plugins/fusioninventory/pics/multiple_mac_addresses.png\"); '";
} else {
if (strstr($data["ifstatus"], "up") or strstr($data["ifstatus"], "1")) {
$background_img = " style='background-image: url(\"" . GLPI_ROOT . "/plugins/fusioninventory/pics/connected_trunk.png\"); '";
}
}
}
echo "<tr class='tab_bg_1 center' height='40'" . $background_img . ">";
echo "<td id='plusmoins" . $data["ID"] . "'><img src='" . GLPI_ROOT . "/pics/expand.gif' onClick='Effect.Appear(\"viewfollowup" . $data["ID"] . "\");close_array(" . $data["ID"] . ");' /></td>";
echo "<td><a href='networking.port.php?ID=" . $data["ID"] . "'>" . $data["name"] . "</a></td>";
$query_array = "SELECT *\n FROM `glpi_display`\n WHERE `type`='5157'\n AND `FK_users`='0'\n ORDER BY `rank`;";
$result_array = $DB->query($query_array);
while ($data_array = $DB->fetch_array($result_array)) {
switch ($data_array['num']) {
case 2:
echo "<td>" . $data["ifmtu"] . "</td>";
break;
case 3:
echo "<td>" . ByteSize($data["ifspeed"], 1000) . "bps</td>";
break;
case 4:
echo "<td>";
if (strstr($data["ifstatus"], "up") or strstr($data["ifinternalstatus"], "1")) {
echo "<img src='" . GLPI_ROOT . "/pics/greenbutton.png'/>";
} else {
if (strstr($data["ifstatus"], "down") or strstr($data["ifinternalstatus"], "2")) {
echo "<img src='" . GLPI_ROOT . "/pics/redbutton.png'/>";
} else {
if (strstr($data["ifstatus"], "testing") or strstr($data["ifinternalstatus"], "3")) {
echo "<img src='" . GLPI_ROOT . "/plugins/fusioninventory/pics/yellowbutton.png'/>";
}
}
}
echo "</td>";
break;
case 5:
echo "<td>" . $data["iflastchange"] . "</td>";
break;
case 6:
echo "<td>";
if ($data["ifinoctets"] == "0") {
echo "-";
} else {
echo ByteSize($data["ifinoctets"], 1000) . "o";
}
echo "</td>";
break;
case 7:
if ($data["ifinerrors"] == "0") {
echo "<td>-";
} else {
echo "<td background='#cf9b9b' class='tab_bg_1_2'>";
echo $data["ifinerrors"];
}
echo "</td>";
break;
case 8:
echo "<td>";
if ($data["ifinoctets"] == "0") {
echo "-";
} else {
echo ByteSize($data["ifoutoctets"], 1000) . "o";
}
echo "</td>";
break;
case 9:
if ($data["ifouterrors"] == "0") {
echo "<td>-";
} else {
echo "<td background='#cf9b9b' class='tab_bg_1_2'>";
echo $data["ifouterrors"];
}
echo "</td>";
break;
case 10:
echo "<td>" . $data["portduplex"] . "</td>";
break;
case 11:
// ** internal mac
echo "<td>" . $data["ifmac"] . "</td>";
break;
case 12:
// ** Mac address and link to device which are connected to this port
$opposite_port = $nw->getOppositeContact($data["FK_networking_ports"]);
if ($opposite_port != "") {
$query_device = "SELECT * \n FROM `glpi_networking_ports`\n WHERE `ID`='" . $opposite_port . "';";
$result_device = $DB->query($query_device);
$data_device = $DB->fetch_assoc($result_device);
$CommonItem->getFromDB($data_device["device_type"], $data_device["on_device"]);
$link1 = $CommonItem->getLink(1);
$link = str_replace($CommonItem->getName(0), $data_device["ifmac"], $CommonItem->getLink());
$link2 = str_replace($CommonItem->getName(0), $data_device["ifaddr"], $CommonItem->getLink());
if ($data_device["device_type"] == PLUGIN_FUSIONINVENTORY_MAC_UNKNOWN) {
if ($CommonItem->getField("accepted") == "1") {
echo "<td style='background:#bfec75'\n class='tab_bg_1_2'>" . $link1;
} else {
echo "<td background='#cf9b9b'\n class='tab_bg_1_2'>" . $link1;
}
if (!empty($link)) {
echo "<br/>" . $link;
}
if (!empty($link2)) {
echo "<br/>" . $link2;
}
echo "</td>";
} else {
echo "<td>" . $link1;
if (!empty($link)) {
echo "<br/>" . $link;
}
if (!empty($link2)) {
echo "<br/>" . $link2;
}
echo "</td>";
}
} else {
echo "<td></td>";
}
break;
case 13:
// ** Connection status
echo "<td>";
if (strstr($data["ifstatus"], "up") or strstr($data["ifstatus"], "1")) {
echo "<img src='" . GLPI_ROOT . "/pics/greenbutton.png'/>";
} else {
if (strstr($data["ifstatus"], "down") or strstr($data["ifstatus"], "2")) {
echo "<img src='" . GLPI_ROOT . "/pics/redbutton.png'/>";
} else {
if (strstr($data["ifstatus"], "testing") or strstr($data["ifstatus"], "3")) {
echo "<img src='" . GLPI_ROOT . "/plugins/fusioninventory/pics/yellowbutton.png'/>";
} else {
if (strstr($data["ifstatus"], "dormant") or strstr($data["ifstatus"], "5")) {
echo "<img src='" . GLPI_ROOT . "/plugins/fusioninventory/pics/orangebutton.png'/>";
}
}
}
}
echo "</td>";
break;
case 14:
echo "<td>";
$canedit = haveRight("networking", "w");
$used = array();
$query_vlan = "SELECT * FROM glpi_networking_vlan WHERE FK_port='" . $data["ID"] . "'";
$result_vlan = $DB->query($query_vlan);
if ($DB->numrows($result_vlan) > 0) {
echo "<table cellpadding='0' cellspacing='0'>";
while ($line = $DB->fetch_array($result_vlan)) {
$used[] = $line["FK_vlan"];
$a_vlan = Dropdown::getDropdownName("glpi_dropdown_vlan", $line["FK_vlan"], 1);
echo "<tr><td>" . $a_vlan['name'] . " [" . $a_vlan['comments'] . "]";
echo "</td><td>";
if ($canedit) {
echo "<a href='" . $CFG_GLPI["root_doc"] . "/front/networking.port.php?unassign_vlan=unassigned&ID=" . $line["ID"] . "'>";
echo "<img src=\"" . $CFG_GLPI["root_doc"] . "/pics/delete2.png\" alt='" . $LANG['buttons'][6] . "' title='" . $LANG['buttons'][6] . "'></a>";
} else {
echo " ";
}
echo "</td></tr>";
}
echo "</table>";
} else {
echo " ";
}
echo "</td>";
break;
case 15:
//Port description
echo "<td>" . $data["ifdescr"] . "</td>";
break;
}
}
echo "</tr>";
// Historique
echo "\n\t\t\t\t<tr style='display: none;' id='viewfollowup" . $data["ID"] . "'>\n\t\t\t\t\t<td colspan='" . (mysql_num_rows($result_array) + 2) . "'>" . PluginFusioninventorySnmphistory::showHistory($data["ID"]) . "</td>\n\t\t\t\t</tr>\n\t\t\t\t";
}
}
echo "</table>";
}
function showForm($p_target, $p_itemtype, $p_items_id)
{
global $DB, $LANG, $SEARCH_OPTION;
echo "<div width='50%'>";
$lockable_fields = PluginFusioninventoryLockable::getLockableFields('', $p_itemtype);
$locked = PluginFusioninventoryLock::getLockFields($p_itemtype, $p_items_id);
if (count($locked)) {
foreach ($locked as $key => $val) {
if (!in_array($val, $lockable_fields)) {
unset($locked[$key]);
}
}
} else {
$locked = array();
}
include_once GLPI_ROOT . '/plugins/fusioninventory/inc_constants/mapping.fields.constant.php';
$CommonItem = new CommonItem();
$CommonItem->getFromDB($p_itemtype, $p_items_id);
echo "<form method='post' action=\"{$p_target}\">";
echo "<input type='hidden' name='ID' value='{$p_items_id}'>";
echo "<input type='hidden' name='type' value='{$p_itemtype}'>";
echo "<table class='tab_cadre'>";
echo "<tr><th> " . $LANG['plugin_fusioninventory']["functionalities"][73] . " </th>";
echo "<th> " . $LANG['plugin_fusioninventory']["functionalities"][74] . " </th>";
echo "<th> " . $LANG['plugin_fusioninventory']["functionalities"][75] . " </th></tr>";
foreach ($lockable_fields as $key => $val) {
if (in_array($val, $locked)) {
$checked = 'checked';
} else {
$checked = '';
}
echo "<tr class='tab_bg_1'><td>" . $FUSIONINVENTORY_MAPPING_FIELDS[$val] . "</td>\n <td>" . $CommonItem->getField($val) . "</td><td align='center'><input type='checkbox' name='lockfield_fusioninventory[" . $val . "]' {$checked}></td></tr>";
}
echo "<tr class='tab_bg_2'><td align='center' colspan='3'>\n <input class='submit' type='submit' name='unlock_field_fusioninventory'\n value='" . $LANG['buttons'][7] . "'></td></tr>";
echo "</table>";
echo "</form>";
echo "</div>";
}
/**
* Show printer graph form
*
*@param $p_target
*@param $p_ID
*@return nothing (print the form)
**/
function showFormPrinter_graph($p_target, $p_ID)
{
global $FUSIONINVENTORY_MAPPING, $LANG;
include_once GLPI_ROOT . "/plugins/fusioninventory/inc_constants/snmp.mapping.constant.php";
$target = $p_target;
$where = '';
$begin = '';
$end = '';
$timeUnit = 'date';
$graphField = 'pages_total';
$printersComp = array();
if (isset($_SESSION['glpi_plugin_fusioninventory_graph_begin'])) {
$begin = $_SESSION['glpi_plugin_fusioninventory_graph_begin'];
}
if ($begin == 'NULL' or $begin == '') {
$begin = date("Y-m-01");
}
// first day of current month
if (isset($_SESSION['glpi_plugin_fusioninventory_graph_end'])) {
$end = $_SESSION['glpi_plugin_fusioninventory_graph_end'];
}
if ($end == 'NULL' or $end == '') {
$end = date("Y-m-d");
}
// today
if (isset($_SESSION['glpi_plugin_fusioninventory_graph_timeUnit'])) {
$timeUnit = $_SESSION['glpi_plugin_fusioninventory_graph_timeUnit'];
}
if (isset($_SESSION['glpi_plugin_fusioninventory_graph_graphField'])) {
$graphField = $_SESSION['glpi_plugin_fusioninventory_graph_graphField'];
}
if (!isset($_SESSION['glpi_plugin_fusioninventory_graph_printersComp'])) {
$_SESSION['glpi_plugin_fusioninventory_graph_printersComp'] = array();
}
if (isset($_SESSION['glpi_plugin_fusioninventory_graph_printerCompAdd'])) {
$printerCompAdd = $_SESSION['glpi_plugin_fusioninventory_graph_printerCompAdd'];
if (!key_exists($printerCompAdd, $_SESSION['glpi_plugin_fusioninventory_graph_printersComp'])) {
$ci = new CommonItem();
if ($ci->getFromDB(PRINTER_TYPE, $printerCompAdd)) {
$_SESSION['glpi_plugin_fusioninventory_graph_printersComp'][$printerCompAdd] = $ci->getField('name');
}
}
} elseif (isset($_SESSION['glpi_plugin_fusioninventory_graph_printerCompRemove'])) {
unset($_SESSION['glpi_plugin_fusioninventory_graph_printersComp'][$_SESSION['glpi_plugin_fusioninventory_graph_printerCompRemove']]);
}
$printers = $_SESSION['glpi_plugin_fusioninventory_graph_printersComp'];
$printersView = $printers;
// printers without the current printer
if (isset($printersView[$p_ID])) {
unset($printersView[$p_ID]);
} else {
$ci = new CommonItem();
if ($ci->getFromDB(PRINTER_TYPE, $p_ID)) {
$printers[$p_ID] = $ci->getField('name');
}
}
$printersList = '';
foreach ($printers as $printer) {
if ($printersList != '') {
$printersList .= '<BR>';
}
$printersList .= $printer;
}
$printersIds = "";
foreach (array_keys($printers) as $printerId) {
if ($printersIds != '') {
$printersIds .= ', ';
}
$printersIds .= $printerId;
}
$where = " WHERE `FK_printers` IN(" . $printersIds . ")";
if ($begin != '' || $end != '') {
$where .= " AND " . $this->getDateRequest("`date`", $begin, $end);
}
switch ($timeUnit) {
case 'date':
$group = "GROUP BY `FK_printers`, `year`, `month`, `date`";
break;
case 'week':
$group = "GROUP BY `FK_printers`, `year`, `month`, `week`";
break;
case 'month':
$group = "GROUP BY `FK_printers`, `year`, `month`";
break;
case 'year':
$group = "GROUP BY `FK_printers`, `year`";
break;
}
$query = "SELECT `FK_printers`, `date`, WEEK(`date`) AS `week`,\n MONTH(`date`) AS `month`, YEAR(`date`) AS `year`,\n SUM(`{$graphField}`) AS `{$graphField}`\n FROM `glpi_plugin_fusioninventory_printers_history`" . $where . $group . "\n ORDER BY `date`, `FK_printers`";
echo "<form method='post' name='printerGraph_form' id='printerGraph_form'\n action='" . $p_target . "'>";
echo "<table class='tab_cadre_fixe' cellpadding='2'>";
echo "<tr>";
echo "<th colspan='4'>" . $LANG['plugin_fusioninventory']["prt_history"][20] . "</th>";
echo "</tr>";
echo "<tr class='tab_bg_1'><td class='left'>" . $LANG['plugin_fusioninventory']["prt_history"][30] . " :</td><td class='left' colspan='2'>";
$elementsField = array('pages_total' => $FUSIONINVENTORY_MAPPING[PRINTER_TYPE]['pagecountertotalpages']['shortname'], 'pages_n_b' => $FUSIONINVENTORY_MAPPING[PRINTER_TYPE]['pagecounterblackpages']['shortname'], 'pages_color' => $FUSIONINVENTORY_MAPPING[PRINTER_TYPE]['pagecountercolorpages']['shortname'], 'pages_recto_verso' => $FUSIONINVENTORY_MAPPING[PRINTER_TYPE]['pagecounterrectoversopages']['shortname'], 'scanned' => $FUSIONINVENTORY_MAPPING[PRINTER_TYPE]['pagecounterscannedpages']['shortname'], 'pages_total_print' => $FUSIONINVENTORY_MAPPING[PRINTER_TYPE]['pagecountertotalpages_print']['shortname'], 'pages_n_b_print' => $FUSIONINVENTORY_MAPPING[PRINTER_TYPE]['pagecounterblackpages_print']['shortname'], 'pages_color_print' => $FUSIONINVENTORY_MAPPING[PRINTER_TYPE]['pagecountercolorpages_print']['shortname'], 'pages_total_copy' => $FUSIONINVENTORY_MAPPING[PRINTER_TYPE]['pagecountertotalpages_copy']['shortname'], 'pages_n_b_copy' => $FUSIONINVENTORY_MAPPING[PRINTER_TYPE]['pagecounterblackpages_copy']['shortname'], 'pages_color_copy' => $FUSIONINVENTORY_MAPPING[PRINTER_TYPE]['pagecountercolorpages_copy']['shortname'], 'pages_total_fax' => $FUSIONINVENTORY_MAPPING[PRINTER_TYPE]['pagecountertotalpages_fax']['shortname']);
Dropdown::showFromArray('graph_graphField', $elementsField, array('value' => $graphField));
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'><td class='left'>" . $LANG['search'][8] . " :</td>\n <td class='left' colspan='2'>";
showDateFormItem("graph_begin", $begin);
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'><td class='left'>" . $LANG['search'][9] . " :</td>\n <td class='left' colspan='2'>";
showDateFormItem("graph_end", $end);
echo "<tr class='tab_bg_1'><td class='left'>" . $LANG['plugin_fusioninventory']["prt_history"][31] . " :</td>\n <td class='left' colspan='2'>";
$elementsTime = array('date' => $LANG['plugin_fusioninventory']["prt_history"][34], 'week' => $LANG['plugin_fusioninventory']["prt_history"][35], 'month' => $LANG['plugin_fusioninventory']["prt_history"][36], 'year' => $LANG['plugin_fusioninventory']["prt_history"][37]);
Dropdown::showFromArray('graph_timeUnit', $elementsTime, array('value' => $timeUnit));
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'><td class='left'>" . $LANG['Menu'][2] . " :</td>\n <td class='left' colspan='2'>";
echo $printersList;
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center' colspan='3'>\n <input type='submit' class=\"submit\" name='graph_plugin_fusioninventory_printer_period'\n value='" . $LANG["buttons"][7] . "'>";
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'><td class='left'>" . $LANG['plugin_fusioninventory']["prt_history"][32] . " :</td><td class='left'>";
Computer_Item::dropdownConnect(PRINTER_TYPE, PRINTER_TYPE, "graph_printerCompAdd", -1, 0, array_keys($printers));
echo "</td><td class='left'>\n";
echo "<input type='submit' value=\"" . $LANG['buttons'][8] . "\" class='submit' name='graph_plugin_fusioninventory_printer_add'>";
echo "</td></tr>\n";
echo "<tr class='tab_bg_1'><td class='left'>" . $LANG['plugin_fusioninventory']["prt_history"][33] . " :</td>\n <td class='left'>";
$printersTmp = $printersView;
$printersTmp[0] = "-----";
asort($printersTmp);
Dropdown::showFromArray('graph_printerCompRemove', $printersTmp);
echo "</td><td class='left'>\n";
echo "<input type='submit' value=\"" . $LANG['buttons'][6] . "\" class='submit' name='graph_plugin_fusioninventory_printer_remove'>";
echo "</td></tr>\n";
echo "</table>";
echo "</form>";
echo "<div class=center>";
$title = $elementsField[$graphField];
if (count($printers)) {
$ptg = new PluginFusioninventoryGraph($query, $graphField, $timeUnit, $printers, $title);
}
echo '</div>';
}
