function showForm($items_id, $itemtype)
{
$rule = new PluginFusioninventoryInventoryRuleImport();
$pfAgent = new PluginFusioninventoryAgent();
echo "<table class='tab_cadre_fixe' cellpadding='1'>";
echo "<tr>";
echo "<th colspan='4'>";
echo __('Rule import logs', 'fusioninventory');
echo "</th>";
echo "</tr>";
echo "<tr>";
echo "<th>";
echo __('Date');
echo "</th>";
echo "<th>";
echo __('Rule name');
echo "</th>";
echo "<th>";
echo __('Agent', 'fusioninventory');
echo "</th>";
echo "<th>";
echo __('Module', 'fusioninventory');
echo "</th>";
echo "</tr>";
$allData = $this->find("`itemtype`='" . $itemtype . "'\n AND `items_id`='" . $items_id . "'", "`date` DESC");
foreach ($allData as $data) {
echo "<tr class='tab_bg_1'>";
echo "<td align='center'>";
echo Html::convDateTime($data['date']);
echo "</td>";
echo "<td align='center'>";
if ($rule->getFromDB($data['rules_id'])) {
echo $rule->getLink(1);
}
echo "</td>";
echo "<td align='center'>";
if ($pfAgent->getFromDB($data['plugin_fusioninventory_agents_id'])) {
echo $pfAgent->getLink(1);
}
echo "</td>";
echo "<td>";
$a_methods = PluginFusioninventoryStaticmisc::getmethods();
foreach ($a_methods as $mdata) {
if ($mdata['method'] == $data['method']) {
echo $mdata['name'];
}
}
echo "</td>";
echo "</tr>";
}
echo "</table>";
}
/**
* Display detail of each history line
*
* @param $agents_id integer id of the agent
* @param $uniqid integer uniq id of each taskjobs runing
* @param $width integer how large in pixel display array
*
* @return value all text to display
*
**/
function showHistoryInDetail($agents_id, $uniqid, $width = "950")
{
global $CFG_GLPI;
$pfTaskjobstate = new PluginFusioninventoryTaskjobstate();
$pfAgent = new PluginFusioninventoryAgent();
$text = "<center><table class='tab_cadrehov' style='width: " . $width . "px'>";
$a_jobstates = $pfTaskjobstate->find('`plugin_fusioninventory_agents_id`="' . $agents_id . '" ' . 'AND `uniqid`="' . $uniqid . '"', '`id` DESC');
$a_devices_merged = array();
foreach ($a_jobstates as $data) {
$displayforceend = 0;
$a_history = $this->find('`plugin_fusioninventory_taskjobstates_id` = "' . $data['id'] . '"', 'id');
if (strstr(exportArrayToDB($a_history), "Merged with ")) {
$classname = $data['itemtype'];
$Class = new $classname();
$Class->getFromDB($data['items_id']);
$a_devices_merged[] = $Class->getLink(1) . " (" . $Class->getTypeName() . ")";
} else {
$text .= "<tr>";
$text .= "<th colspan='2'><img src='" . $CFG_GLPI['root_doc'] . "/pics/puce.gif' />" . __('Process number', 'fusioninventory') . " : " . $data['id'] . "</th>";
$text .= "<th>";
$text .= __('Date');
$text .= "</th>";
$text .= "<th>";
$text .= __('Status');
$text .= "</th>";
$text .= "<th>";
$text .= __('Comments');
$text .= "</th>";
$text .= "</tr>";
$text .= "<tr class='tab_bg_1'>";
$text .= "<th colspan='2'>";
$text .= __('Agent', 'fusioninventory');
$text .= "</th>";
$a_return = $this->displayHistoryDetail(array_shift($a_history));
$count = $a_return[0];
$text .= $a_return[1];
$displayforceend += $count;
$text .= "</tr>";
$text .= "<tr class='tab_bg_1'>";
$text .= "<td colspan='2'>";
$pfAgent->getFromDB($data['plugin_fusioninventory_agents_id']);
$text .= $pfAgent->getLink(1);
$text .= "</td>";
$a_return = $this->displayHistoryDetail(array_shift($a_history));
$count = $a_return[0];
$text .= $a_return[1];
$displayforceend += $count;
$text .= "</tr>";
$text .= "<tr class='tab_bg_1'>";
$text .= "<th colspan='2'>";
$text .= __('Definition', 'fusioninventory');
$text .= "<sup>(" . (count($a_devices_merged) + 1) . ")</sup>";
$text .= "</th>";
$a_return = $this->displayHistoryDetail(array_shift($a_history));
$count = $a_return[0];
$text .= $a_return[1];
$displayforceend += $count;
$text .= "</tr>";
$text .= "<tr class='tab_bg_1'>";
$text .= "<td colspan='2'>";
if (!empty($data["itemtype"])) {
$device = new $data["itemtype"]();
$device->getFromDB($data["items_id"]);
$text .= $device->getLink(1);
$text .= " ";
$text .= "(" . $device->getTypeName() . ")";
}
$text .= "</td>";
$a_return = $this->displayHistoryDetail(array_shift($a_history));
$count = $a_return[0];
$text .= $a_return[1];
$displayforceend += $count;
$text .= "</tr>";
while (count($a_history) != 0) {
if (count($a_devices_merged) > 0) {
$text .= "<tr class='tab_bg_1'>";
$text .= "<td colspan='2'>";
$text .= array_pop($a_devices_merged);
$text .= "</td>";
$a_return = $this->displayHistoryDetail(array_shift($a_history));
$count = $a_return[0];
$text .= $a_return[1];
$displayforceend += $count;
$text .= "</tr>";
} else {
$text .= "<tr class='tab_bg_1'>";
$text .= "<td colspan='2' rowspan='" . count($a_history) . "'>";
$text .= "</td>";
$a_return = $this->displayHistoryDetail(array_shift($a_history));
$count = $a_return[0];
$text .= $a_return[1];
$displayforceend += $count;
$text .= "</tr>";
while (count($a_history) != 0) {
$text .= "<tr class='tab_bg_1'>";
$a_return = $this->displayHistoryDetail(array_shift($a_history));
$count = $a_return[0];
$text .= $a_return[1];
$displayforceend += $count;
$text .= "</tr>";
}
}
}
$display = 1;
while (count($a_devices_merged) != 0) {
$text .= "<tr class='tab_bg_1'>";
$text .= "<td colspan='2'>";
$text .= array_pop($a_devices_merged);
$text .= "</td>";
if ($display == "1") {
$text .= "<td colspan='3' rowspan='" . (count($a_devices_merged) + 1) . "'></td>";
$display = 0;
}
$text .= "</tr>";
}
$text .= "<tr class='tab_bg_4'>";
$text .= "<td colspan='5' height='4'>";
$text .= "</td>";
$text .= "</tr>";
}
}
$text .= "</table></center>";
return $text;
}
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 "";
}
function display($options = array())
{
global $DB, $CFG_GLPI;
$pfAgent = new PluginFusioninventoryAgent();
$pfTaskjobstate = new PluginFusioninventoryTaskjobstate();
$pfTaskjoblog = new PluginFusioninventoryTaskjoblog();
$pfStateInventory = new PluginFusioninventoryStateInventory();
$pfTaskjob = new PluginFusioninventoryTaskjob();
$start = 0;
if (isset($_REQUEST["start"])) {
$start = $_REQUEST["start"];
}
// Total Number of events
$querycount = "SELECT count(*) AS cpt FROM `glpi_plugin_fusioninventory_taskjobstates`\n LEFT JOIN `glpi_plugin_fusioninventory_taskjobs`\n ON `plugin_fusioninventory_taskjobs_id` = `glpi_plugin_fusioninventory_taskjobs`.`id`\n WHERE `method` = 'networkdiscovery'\n GROUP BY `uniqid`\n ORDER BY `uniqid` DESC ";
$resultcount = $DB->query($querycount);
$number = $DB->numrows($resultcount);
// Display the pager
Html::printPager($start, $number, $CFG_GLPI['root_doc'] . "/plugins/fusioninventory/front/stateinventory.php", '');
echo "<table class='tab_cadre_fixe'>";
echo "<tr class='tab_bg_1'>";
echo "<th>" . __('Unique id', 'fusioninventory') . "</th>";
echo "<th>" . __('Task job', 'fusioninventory') . "</th>";
echo "<th>" . __('Agent', 'fusioninventory') . "</th>";
echo "<th>" . __('Status') . "</th>";
echo "<th>" . __('Starting date', 'fusioninventory') . "</th>";
echo "<th>" . __('Ending date', 'fusioninventory') . "</th>";
echo "<th>" . __('Total duration') . "</th>";
echo "<th>" . __('Threads number', 'fusioninventory') . "</th>";
echo "<th>" . __('Total discovery devices', 'fusioninventory') . "</th>";
echo "<th>" . __('Devices not imported', 'fusioninventory') . "</th>";
echo "<th>" . __('Devices linked', 'fusioninventory') . "</th>";
echo "<th>" . __('Devices imported', 'fusioninventory') . "</th>";
echo "</tr>";
$sql = "SELECT `glpi_plugin_fusioninventory_taskjobstates`.*\n FROM `glpi_plugin_fusioninventory_taskjobstates`\n LEFT JOIN `glpi_plugin_fusioninventory_taskjobs`\n ON `plugin_fusioninventory_taskjobs_id` = `glpi_plugin_fusioninventory_taskjobs`.`id`\n WHERE `method` = 'networkdiscovery'\n GROUP BY `uniqid`\n ORDER BY `uniqid` DESC\n LIMIT " . intval($start) . ", " . intval($_SESSION['glpilist_limit']);
$result = $DB->query($sql);
while ($data = $DB->fetch_array($result)) {
echo "<tr class='tab_bg_1'>";
echo "<td>" . $data['uniqid'] . "</td>";
$pfTaskjob->getFromDB($data['plugin_fusioninventory_taskjobs_id']);
echo "<td>" . $pfTaskjob->getLink() . "</td>";
$pfAgent->getFromDB($data['plugin_fusioninventory_agents_id']);
echo "<td>" . $pfAgent->getLink(1) . "</td>";
$nb_found = 0;
$nb_threads = 0;
$start_date = "";
$end_date = "";
$notimporteddevices = 0;
$updateddevices = 0;
$createddevices = 0;
$a_taskjobstates = $pfTaskjobstate->find("`uniqid`='" . $data['uniqid'] . "'");
foreach ($a_taskjobstates as $datastate) {
$a_taskjoblog = $pfTaskjoblog->find("`plugin_fusioninventory_taskjobstates_id`='" . $datastate['id'] . "'");
foreach ($a_taskjoblog as $taskjoblog) {
if (strstr($taskjoblog['comment'], " ==devicesfound==")) {
$nb_found += str_replace(" ==devicesfound==", "", $taskjoblog['comment']);
} else {
if (strstr($taskjoblog['comment'], "==importdenied==")) {
$notimporteddevices++;
} else {
if (strstr($taskjoblog['comment'], "==updatetheitem==")) {
$updateddevices++;
} else {
if (strstr($taskjoblog['comment'], "==addtheitem==")) {
$createddevices++;
} else {
if ($taskjoblog['state'] == "1") {
$nb_threads = str_replace(" threads", "", $taskjoblog['comment']);
$start_date = $taskjoblog['date'];
}
}
}
}
}
if ($taskjoblog['state'] == "2" or $taskjoblog['state'] == "3" or $taskjoblog['state'] == "4" or $taskjoblog['state'] == "5") {
if (!strstr($taskjoblog['comment'], 'Merged with ')) {
$end_date = $taskjoblog['date'];
}
}
}
}
// State
echo "<td>";
switch ($data['state']) {
case 0:
echo __('Prepared', 'fusioninventory');
break;
case 1:
case 2:
echo __('Started', 'fusioninventory');
break;
case 3:
echo __('Finished tasks', 'fusioninventory');
break;
}
echo "</td>";
echo "<td>" . Html::convDateTime($start_date) . "</td>";
echo "<td>" . Html::convDateTime($end_date) . "</td>";
if ($end_date == '') {
$end_date = date("Y-m-d H:i:s");
}
if ($start_date == '') {
echo "<td>-</td>";
} else {
$interval = '';
if (phpversion() >= 5.3) {
$date1 = new DateTime($start_date);
$date2 = new DateTime($end_date);
$interval = $date1->diff($date2);
$display_date = '';
if ($interval->h > 0) {
$display_date .= $interval->h . "h ";
} else {
if ($interval->i > 0) {
$display_date .= $interval->i . "min ";
}
}
echo "<td>" . $display_date . $interval->s . "s</td>";
} else {
$interval = $pfStateInventory->date_diff($start_date, $end_date);
}
}
echo "<td>" . $nb_threads . "</td>";
echo "<td>" . $nb_found . "</td>";
echo "<td>" . $notimporteddevices . "</td>";
echo "<td>" . $updateddevices . "</td>";
echo "<td>" . $createddevices . "</td>";
echo "</tr>";
}
echo "</table>";
}
