/**
* Display high detail of each history line
*
* @param $datas array datas of history
* @param $comment boolean 0/1 display comment or not
*
* @return array
* - boolean 0/1 if this log = finish
* - text to display
*
**/
function displayHistoryDetail($datas, $comment = 1)
{
$text = "<td align='center'>";
$text .= Html::convDateTime($datas['date']);
$text .= "</td>";
$finish = 0;
switch ($datas['state']) {
case self::TASK_PREPARED:
$text .= "<td align='center'>";
$text .= __('Prepared', 'fusioninventory');
break;
case self::TASK_STARTED:
$text .= "<td align='center'>";
$text .= __('Started', 'fusioninventory');
break;
case self::TASK_OK:
$text .= "<td style='background-color: rgb(0, 255, 0);-moz-border-radius:" . " 4px;-webkit-border-radius: 4px;-o-border-radius: 4px;padding: 2px;' " . "align='center'>";
$text .= "<strong>" . __('Ok', 'fusioninventory') . "</strong>";
$finish++;
break;
case self::TASK_ERROR_OR_REPLANNED:
$text .= "<td style='background-color: rgb(255, 120, 0);-moz-border-radius: " . "4px;-webkit-border-radius: 4px;-o-border-radius: 4px;padding: 2px;' " . "align='center'>";
$text .= "<strong>" . __('Error / rescheduled', 'fusioninventory') . "</strong>";
$finish++;
break;
case self::TASK_ERROR:
$text .= "<td style='background-color: rgb(255, 0, 0);-moz-border-radius: " . "4px;-webkit-border-radius: 4px;-o-border-radius: 4px;padding: 2px;' " . "align='center'>";
$text .= "<strong>" . __('Error') . "</strong>";
$finish++;
break;
case self::TASK_INFO:
$text .= "<td style='background-color: rgb(255, 200, 0);-moz-border-radius: " . "4px;-webkit-border-radius: 4px;-o-border-radius: 4px;padding: 2px;' " . "align='center'>";
$text .= "<strong>" . __('Info', 'fusioninventory') . "</strong>";
$finish++;
break;
case self::TASK_RUNNING:
$text .= "<td style='background-color: rgb(255, 200, 0);-moz-border-radius: " . "4px;-webkit-border-radius: 4px;-o-border-radius: 4px;padding: 2px;' " . "align='center'>";
$text .= "<strong>" . __('Running') . "</strong>";
break;
default:
$text .= "<td>";
break;
}
$text .= "</td>";
if ($comment == '1') {
$text .= "<td class='fusinv_task_comment'>";
$datas['comment'] = PluginFusioninventoryTaskjoblog::convertComment($datas['comment']);
$text .= $datas['comment'];
$text .= "</td>";
}
return array($finish, $text);
}
/**
* Get logs associated to a jobstate.
*
* since 0.85+1.0
*/
function getLogs($id, $last_date)
{
global $DB;
$fields = array('log.id' => 0, 'log.date' => 1, 'log.comment' => 2, 'log.state' => 3, 'run.id' => 4);
$query = implode("\n", array("SELECT log.`id` AS 'log.id',", "log.`date` AS 'log.date',", "log.`comment` AS 'log.comment',", "log.`state` AS 'log.state',", "run.`uniqid` AS 'run.id'", "FROM `glpi_plugin_fusioninventory_taskjoblogs` AS log", "LEFT JOIN `glpi_plugin_fusioninventory_taskjobstates` AS run", "ON run.`id` = log.`plugin_fusioninventory_taskjobstates_id`", "WHERE run.`id` = " . $id, "AND log.`date` <= '" . $last_date . "'", "ORDER BY log.`id` DESC"));
$res = $DB->query($query);
$logs = array();
while ($result = $res->fetch_row()) {
$run_id = $result[$fields['run.id']];
$logs['run'] = $run_id;
$logs['logs'][] = array('log.id' => $result[$fields['log.id']], 'log.comment' => PluginFusioninventoryTaskjoblog::convertComment($result[$fields['log.comment']]), 'log.date' => $result[$fields['log.date']], 'log.state' => $result[$fields['log.state']]);
}
return $logs;
}
function plugin_fusioninventory_giveItem($type, $id, $data, $num)
{
global $CFG_GLPI;
$searchopt =& Search::getOptions($type);
$table = $searchopt[$id]["table"];
$field = $searchopt[$id]["field"];
switch ($table . '.' . $field) {
case "glpi_plugin_fusioninventory_taskjobs.status":
$pfTaskjobstate = new PluginFusioninventoryTaskjobstate();
return $pfTaskjobstate->stateTaskjob($data['raw']['id'], '200', 'htmlvar', 'simple');
break;
case "glpi_plugin_fusioninventory_agents.version":
$array = importArrayFromDB($data['raw']['ITEM_' . $num]);
$input = "";
foreach ($array as $name => $version) {
$input .= "<strong>" . $name . "</strong> : " . $version . "<br/>";
}
$input .= "*";
$input = str_replace("<br/>*", "", $input);
return $input;
break;
case "glpi_plugin_fusioninventory_credentials.itemtype":
if ($label = PluginFusioninventoryCredential::getLabelByItemtype($data['raw']['ITEM_' . $num])) {
return $label;
} else {
return '';
}
break;
case 'glpi_plugin_fusioninventory_taskjoblogs.state':
$pfTaskjoblog = new PluginFusioninventoryTaskjoblog();
return $pfTaskjoblog->getDivState($data['raw']['ITEM_' . $num]);
break;
case 'glpi_plugin_fusioninventory_taskjoblogs.comment':
$comment = $data['raw']['ITEM_' . $num];
return PluginFusioninventoryTaskjoblog::convertComment($comment);
break;
case 'glpi_plugin_fusioninventory_taskjobstates.plugin_fusioninventory_agents_id':
$pfAgent = new PluginFusioninventoryAgent();
$pfAgent->getFromDB($data['raw']['ITEM_' . $num]);
if (!isset($pfAgent->fields['name'])) {
return NOT_AVAILABLE;
}
$itemtype = PluginFusioninventoryTaskjoblog::getStateItemtype($data['raw']['ITEM_0']);
if ($itemtype == 'PluginFusioninventoryDeployPackage') {
$computer = new Computer();
$computer->getFromDB($pfAgent->fields['computers_id']);
return $computer->getLink(1);
}
return $pfAgent->getLink(1);
break;
case 'glpi_plugin_fusioninventory_ignoredimportdevices.ip':
case 'glpi_plugin_fusioninventory_ignoredimportdevices.mac':
$array = importArrayFromDB($data['raw']['ITEM_' . $num]);
return implode("<br/>", $array);
break;
case 'glpi_plugin_fusioninventory_ignoredimportdevices.method':
$a_methods = PluginFusioninventoryStaticmisc::getmethods();
foreach ($a_methods as $mdata) {
if ($mdata['method'] == $data['raw']['ITEM_' . $num]) {
return $mdata['name'];
}
}
break;
}
if ($table == "glpi_plugin_fusioninventory_agentmodules") {
if ($type == 'Computer') {
$pfAgentmodule = new PluginFusioninventoryAgentmodule();
$a_modules = $pfAgentmodule->find("`modulename`='" . $field . "'");
$data2 = current($a_modules);
if ($table . "." . $field == "glpi_plugin_fusioninventory_agentmodules." . $data2['modulename']) {
if (strstr($data['raw']["ITEM_" . $num . "_0"], '"' . $data['raw']["ITEM_" . $num . "_1"] . '"')) {
if ($data['raw']['ITEM_' . $num] == '0') {
return Dropdown::getYesNo(TRUE);
} else {
return Dropdown::getYesNo(FALSE);
}
}
return Dropdown::getYesNo($data['raw']['ITEM_' . $num]);
}
} else {
$pfAgentmodule = new PluginFusioninventoryAgentmodule();
$a_modules = $pfAgentmodule->find("`modulename`='" . $field . "'");
foreach ($a_modules as $data2) {
if ($table . "." . $field == "glpi_plugin_fusioninventory_agentmodules." . $data2['modulename']) {
if (strstr($data['raw']["ITEM_" . $num . "_0"], '"' . $data['raw']['id'] . '"')) {
if ($data['raw']['ITEM_' . $num] == 0) {
return Dropdown::getYesNo('1');
} else {
return Dropdown::getYesNo('0');
}
}
return Dropdown::getYesNo($data['raw']['ITEM_' . $num]);
}
}
}
}
switch ($type) {
case 'Computer':
if ($table . '.' . $field == 'glpi_plugin_fusioninventory_networkports.id') {
if (strstr($data['raw']["ITEM_{$num}"], "\$")) {
$split = explode("\$\$\$\$", $data['raw']["ITEM_{$num}"]);
$ports = array();
foreach ($split as $portconcat) {
$split2 = explode("....", $portconcat);
if (isset($split2[1])) {
$ports[] = $split2[1];
}
}
$out = implode("<br/>", $ports);
return $out;
}
}
break;
// * Networking List (front/networking.php)
// * Networking List (front/networking.php)
case 'NetworkEquipment':
switch ($table . '.' . $field) {
}
break;
case 'Printer':
if ($table . '.' . $field == 'glpi_plugin_fusioninventory_networkequipments.name') {
if (strstr($data['raw']["ITEM_{$num}"], "\$")) {
$split = explode("\$\$\$\$", $data['raw']["ITEM_{$num}"]);
$out = implode("<br/>", $split);
return $out;
}
}
break;
// * Authentification List (plugins/fusinvsnmp/front/configsecurity.php)
// * Authentification List (plugins/fusinvsnmp/front/configsecurity.php)
case 'PluginFusioninventoryConfigSecurity':
switch ($table . '.' . $field) {
// ** Hidden auth passphrase (SNMP v3)
case "glpi_plugin_fusioninventory_configsecurities.auth_passphrase":
$out = "";
if (empty($data['raw']["ITEM_{$num}"])) {
} else {
$out = "********";
}
return $out;
break;
// ** Hidden priv passphrase (SNMP v3)
// ** Hidden priv passphrase (SNMP v3)
case "glpi_plugin_fusioninventory_configsecurities.priv_passphrase":
$out = "";
if (empty($data['raw']["ITEM_{$num}"])) {
} else {
$out = "********";
}
return $out;
break;
}
break;
// * Unknown mac addresses connectd on switch - report
// (plugins/fusinvsnmp/report/unknown_mac.php)
// * Unknown mac addresses connectd on switch - report
// (plugins/fusinvsnmp/report/unknown_mac.php)
case 'PluginFusioninventoryUnmanaged':
switch ($table . '.' . $field) {
// ** FusionInventory - switch
case "glpi_plugin_fusioninventory_networkequipments.id":
$out = '';
$NetworkPort = new NetworkPort();
$list = explode("\$\$\$\$", $data['raw']["ITEM_{$num}"]);
foreach ($list as $numtmp => $vartmp) {
$NetworkPort->getDeviceData($vartmp, 'PluginFusioninventoryUnmanaged');
$out .= "<a href=\"" . $CFG_GLPI["root_doc"] . "/";
$out .= "plugins/fusioninventory/front/unmanaged.form.php?id=" . $vartmp . "\">";
$out .= $NetworkPort->device_name;
if ($CFG_GLPI["view_ID"]) {
$out .= " (" . $vartmp . ")";
}
$out .= "</a><br/>";
}
return "<center>" . $out . "</center>";
break;
// ** FusionInventory - switch port
// ** FusionInventory - switch port
case "glpi_plugin_fusioninventory_networkports.id":
$out = '';
if (!empty($data['raw']["ITEM_{$num}"])) {
$list = explode("\$\$\$\$", $data['raw']["ITEM_{$num}"]);
$np = new NetworkPort();
foreach ($list as $numtmp => $vartmp) {
$np->getFromDB($vartmp);
$out .= "<a href='" . $CFG_GLPI['root_doc'] . "/front/networkport.form.php?id=" . $vartmp . "'>";
$out .= $np->fields["name"] . "</a><br/>";
}
}
return "<center>" . $out . "</center>";
break;
case "glpi_plugin_fusinvsnmp_unmanageds.type":
$out = '<center> ';
switch ($data['raw']["ITEM_{$num}"]) {
case COMPUTER_TYPE:
$out .= __('Computers');
break;
case NETWORKING_TYPE:
$out .= __('Networks');
break;
case PRINTER_TYPE:
$out .= __('Printers');
break;
case PERIPHERAL_TYPE:
$out .= __('Devices');
break;
case PHONE_TYPE:
$out .= __('Phones');
break;
}
$out .= '</center>';
return $out;
break;
}
break;
// * Ports date connection - report (plugins/fusinvsnmp/report/ports_date_connections.php)
// * Ports date connection - report (plugins/fusinvsnmp/report/ports_date_connections.php)
case 'PluginFusioninventoryNetworkPort':
switch ($table . '.' . $field) {
// ** Name and link of networking device (switch)
case "glpi_plugin_fusioninventory_networkports.id":
$query = "SELECT `glpi_networkequipments`.`name` AS `name`, `glpi_networkequipments`.`id` AS `id`\n FROM `glpi_networkequipments`\n LEFT JOIN `glpi_networkports`\n ON `items_id` = `glpi_networkequipments`.`id`\n LEFT JOIN `glpi_plugin_fusioninventory_networkports`\n ON `glpi_networkports`.`id`=`networkports_id`\n WHERE `glpi_plugin_fusioninventory_networkports`.`id`='" . $data['raw']["ITEM_{$num}"] . "'\n LIMIT 0, 1;";
$result = $DB->query($query);
$data2 = $DB->fetch_assoc($result);
$out = "<a href='" . $CFG_GLPI['root_doc'] . "/front/networking.form.php?id=" . $data2["id"] . "'>";
$out .= $data2["name"] . "</a>";
return "<center>" . $out . "</center>";
break;
// ** Name and link of port of networking device (port of switch)
// ** Name and link of port of networking device (port of switch)
case "glpi_plugin_fusioninventory_networkports.networkports_id":
$NetworkPort = new NetworkPort();
$NetworkPort->getFromDB($data['raw']["ITEM_{$num}"]);
$name = "";
if (isset($NetworkPort->fields["name"])) {
$name = $NetworkPort->fields["name"];
}
$out = "<a href='" . $CFG_GLPI['root_doc'] . "/front/networkport.form.php?id=" . $data['raw']["ITEM_{$num}"];
$out .= "'>" . $name . "</a>";
return "<center>" . $out . "</center>";
break;
// ** Location of switch
// ** Location of switch
case "glpi_locations.id":
$out = Dropdown::getDropdownName("glpi_locations", $data['raw']["ITEM_{$num}"]);
return "<center>" . $out . "</center>";
break;
}
break;
// * range IP list (plugins/fusinvsnmp/front/iprange.php)
// * range IP list (plugins/fusinvsnmp/front/iprange.php)
case 'PluginFusioninventoryIPRange':
switch ($table . '.' . $field) {
// ** Display entity name
case "glpi_entities.name":
if ($data['raw']["ITEM_{$num}"] == '') {
$out = Dropdown::getDropdownName("glpi_entities", $data['raw']["ITEM_{$num}"]);
return "<center>" . $out . "</center>";
}
break;
}
break;
case 'PluginFusioninventoryNetworkPortLog':
switch ($table . '.' . $field) {
// ** Display switch and Port
case "glpi_networkports.id":
$Array_device = PluginFusioninventoryNetworkPort::getUniqueObjectfieldsByportID($data['raw']["ITEM_{$num}"]);
$item = new $Array_device["itemtype"]();
$item->getFromDB($Array_device["items_id"]);
$out = "<div align='center'>" . $item->getLink(1);
$query = "SELECT *\n FROM `glpi_networkports`\n WHERE `id`='" . $data['raw']["ITEM_{$num}"] . "';";
$result = $DB->query($query);
if ($DB->numrows($result) != "0") {
$out .= "<br/><a href='" . $CFG_GLPI['root_doc'] . "/front/networkport.form.php?id=";
$out .= $data['raw']["ITEM_{$num}"] . "'>" . $DB->result($result, 0, "name") . "</a>";
}
$out .= "</td>";
return $out;
break;
// ** Display GLPI field of device
// ** Display GLPI field of device
case "glpi_plugin_fusinvsnmp_networkportlogs.field":
// $out = $FUSIONINVENTORY_MAPPING[NETWORKING_TYPE][$data['raw']["ITEM_$num"]]['name'];
$out = '';
$map = new PluginFusioninventoryMapping();
$mapfields = $map->get('NetworkEquipment', $data['raw']["ITEM_{$num}"]);
if ($mapfields != FALSE) {
$out = _get('_LANG[\'plugin_fusinvsnmp\'][\'mapping\'][$mapfields["locale"]]');
}
return $out;
break;
// ** Display Old Value (before changement of value)
// ** Display Old Value (before changement of value)
case "glpi_plugin_fusinvsnmp_networkportlogs.old_value":
// TODO ADD LINK TO DEVICE
if (substr_count($data['raw']["ITEM_{$num}"], ":") == 5 && empty($data['raw']["ITEM_3"])) {
return "<center><b>" . $data['raw']["ITEM_{$num}"] . "</b></center>";
}
break;
// ** Display New Value (new value modified)
// ** Display New Value (new value modified)
case "glpi_plugin_fusinvsnmp_networkportlogs.new_value":
if (substr_count($data['raw']["ITEM_{$num}"], ":") == 5 && empty($data['raw']["ITEM_3"])) {
return "<center><b>" . $data['raw']["ITEM_{$num}"] . "</b></center>";
}
break;
}
break;
case "PluginFusioninventoryPrinterLog":
switch ($table . '.' . $field) {
case 'glpi_printers.name':
// Search pages in printer history to limit SQL queries
if (isset($_SESSION['glpi_plugin_fusioninventory_history_start'])) {
unset($_SESSION['glpi_plugin_fusioninventory_history_start']);
}
if (isset($_SESSION['glpi_plugin_fusioninventory_history_end'])) {
unset($_SESSION['glpi_plugin_fusioninventory_history_end']);
}
if (isset($_SESSION['glpi_plugin_fusioninventory_date_start']) and isset($_SESSION['glpi_plugin_fusioninventory_date_end'])) {
$query = "SELECT * FROM `glpi_plugin_fusioninventory_printerlogs`\n WHERE `printers_id`='" . $data['raw']['ITEM_0_2'] . "'\n AND `date`>= '" . $_SESSION['glpi_plugin_fusioninventory_date_start'] . "'\n AND `date`<= '" . $_SESSION['glpi_plugin_fusioninventory_date_end'] . " 23:59:59'\n ORDER BY date asc\n LIMIT 1";
$result = $DB->query($query);
while ($data2 = $DB->fetch_array($result)) {
$_SESSION['glpi_plugin_fusioninventory_history_start'] = $data2;
}
$query = "SELECT * FROM `glpi_plugin_fusioninventory_printerlogs`\n WHERE `printers_id`='" . $data['raw']['ITEM_0_2'] . "'\n AND `date`>= '" . $_SESSION['glpi_plugin_fusioninventory_date_start'] . "'\n AND `date`<= '" . $_SESSION['glpi_plugin_fusioninventory_date_end'] . " 23:59:59'\n ORDER BY date desc\n LIMIT 1";
$result = $DB->query($query);
while ($data2 = $DB->fetch_array($result)) {
$_SESSION['glpi_plugin_fusioninventory_history_end'] = $data2;
}
}
return "";
break;
}
switch ($table) {
case 'glpi_plugin_fusioninventory_printerlogs':
if (isset($_SESSION['glpi_plugin_fusioninventory_history_start'][$field]) and isset($_SESSION['glpi_plugin_fusioninventory_history_end'][$field])) {
$counter_start = $_SESSION['glpi_plugin_fusioninventory_history_start'][$field];
$counter_end = $_SESSION['glpi_plugin_fusioninventory_history_end'][$field];
if ($_SESSION['glpi_plugin_fusioninventory_date_start'] == "1970-01-01") {
$counter_start = 0;
}
$number = $counter_end - $counter_start;
if ($number == '0') {
return '-';
} else {
return $number;
}
} else {
return '-';
}
break;
}
break;
}
return "";
}