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>'; }