/**
* Function to import discovered device
*
* @param $items_id id of the device to import
*
* @return nothing
*
**/
function import($items_id, $Import = 0, $NoImport = 0)
{
global $DB;
$NetworkPort = new NetworkPort();
$a_NetworkPorts = $NetworkPort->find("`items_id` = '" . $items_id . "'\n AND `itemtype` = 'PluginFusioninventoryUnmanaged'");
$this->getFromDB($items_id);
$this->fields = Toolbox::addslashes_deep($this->fields);
$data = array();
switch ($this->fields['item_type']) {
case 'Printer':
$Printer = new Printer();
$data["entities_id"] = $this->fields["entities_id"];
if (!empty($this->fields["name"])) {
$data["name"] = $this->fields["name"];
}
$data["locations_id"] = $this->fields["locations_id"];
$data["serial"] = $this->fields["serial"];
$data["otherserial"] = $this->fields["otherserial"];
$data["contact"] = $this->fields["contact"];
$data["domain"] = $this->fields["domain"];
$data["comment"] = $this->fields["comment"];
$data["is_dynamic"] = 1;
$printer_id = $Printer->add($data);
foreach ($a_NetworkPorts as $data_Port) {
$data_Port['items_id'] = $printer_id;
$data_Port['itemtype'] = $Printer->getType();
$NetworkPort->update($data_Port);
}
// Import SNMP
$pfPrinter = new PluginFusioninventoryPrinter();
$_SESSION['glpi_plugins_fusinvsnmp_table'] = "glpi_plugin_fusioninventory_printers";
$query = "SELECT *\n FROM `glpi_plugin_fusioninventory_printers`\n WHERE `printers_id`='" . $printer_id . "' ";
$result = $DB->query($query);
$data = array();
if ($DB->numrows($result) > 0) {
$data = $DB->fetch_assoc($result);
}
$data['sysdescr'] = $this->fields['sysdescr'];
$data['plugin_fusioninventory_configsecurities_id'] = $this->fields['plugin_fusioninventory_configsecurities_id'];
if ($DB->numrows($result) == 0) {
$data['printers_id'] = $printer_id;
$pfPrinter->add($data);
} else {
$pfPrinter->update($data);
}
$this->deleteFromDB($items_id, 1);
$Import++;
break;
case 'NetworkEquipment':
$NetworkEquipment = new NetworkEquipment();
$data["entities_id"] = $this->fields["entities_id"];
if (!empty($this->fields["name"])) {
$data["name"] = $this->fields["name"];
}
$data["locations_id"] = $this->fields["locations_id"];
$data["serial"] = $this->fields["serial"];
$data["otherserial"] = $this->fields["otherserial"];
$data["contact"] = $this->fields["contact"];
$data["domain"] = $this->fields["domain"];
$data["comment"] = $this->fields["comment"];
$data["is_dynamic"] = 1;
// $data_Port = current($a_NetworkPorts);
// $data["ip"] = $data_Port["ip"];
// $data["mac"] = $data_Port["mac"];
$NetworkEquipment_id = $NetworkEquipment->add($data);
foreach ($a_NetworkPorts as $data_Port) {
$data_Port['items_id'] = $NetworkEquipment_id;
$data_Port['itemtype'] = $NetworkEquipment->getType();
$NetworkPort->update($data_Port);
}
$pfNetworkEquipment = new PluginFusioninventoryNetworkEquipment();
$_SESSION['glpi_plugins_fusinvsnmp_table'] = "glpi_plugin_fusioninventory_networkequipments";
$query = "SELECT *\n FROM `glpi_plugin_fusioninventory_networkequipments`\n WHERE `networkequipments_id`='" . $NetworkEquipment_id . "' ";
$result = $DB->query($query);
$data = array();
if ($DB->numrows($result) > 0) {
$data = $DB->fetch_assoc($result);
}
$data['sysdescr'] = $this->fields['sysdescr'];
$data['plugin_fusioninventory_configsecurities_id'] = $this->fields['plugin_fusioninventory_configsecurities_id'];
if ($DB->numrows($result) == 0) {
$data['networkequipments_id'] = $NetworkEquipment_id;
$pfNetworkEquipment->add($data);
} else {
$pfNetworkEquipment->update($data);
}
$this->deleteFromDB($items_id, 1);
$Import++;
break;
case 'Peripheral':
$Peripheral = new Peripheral();
$data["entities_id"] = $this->fields["entities_id"];
if (!empty($this->fields["name"])) {
$data["name"] = $this->fields["name"];
}
$data["locations_id"] = $this->fields["locations_id"];
$data["serial"] = $this->fields["serial"];
$data["otherserial"] = $this->fields["otherserial"];
$data["contact"] = $this->fields["contact"];
$data["comment"] = $this->fields["comment"];
$data["is_dynamic"] = 1;
$Peripheral_id = $Peripheral->add($data);
foreach ($a_NetworkPorts as $data_Port) {
$data_Port['items_id'] = $Peripheral_id;
$data_Port['itemtype'] = $Peripheral->getType();
$NetworkPort->update($data_Port);
}
$this->deleteFromDB($items_id, 1);
$Import++;
break;
case 'Computer':
$Computer = new Computer();
$data["entities_id"] = $this->fields["entities_id"];
if (!empty($this->fields["name"])) {
$data["name"] = $this->fields["name"];
}
$data["locations_id"] = $this->fields["locations_id"];
$data["serial"] = $this->fields["serial"];
$data["otherserial"] = $this->fields["otherserial"];
$data["contact"] = $this->fields["contact"];
$data["domain"] = $this->fields["domain"];
$data["comment"] = $this->fields["comment"];
$data["is_dynamic"] = 1;
$Computer_id = $Computer->add($data);
foreach ($a_NetworkPorts as $data_Port) {
$data_Port['items_id'] = $Computer_id;
$data_Port['itemtype'] = $Computer->getType();
$NetworkPort->update($data_Port);
}
$this->deleteFromDB($items_id, 1);
$Import++;
break;
case 'Phone':
$Phone = new Phone();
$data["entities_id"] = $this->fields["entities_id"];
$data["name"] = $this->fields["name"];
$data["locations_id"] = $this->fields["locations_id"];
$data["serial"] = $this->fields["serial"];
$data["otherserial"] = $this->fields["otherserial"];
$data["contact"] = $this->fields["contact"];
$data["comment"] = $this->fields["comment"];
$data["is_dynamic"] = 1;
$phone_id = $Phone->add($data);
foreach ($a_NetworkPorts as $data_Port) {
$data_Port['items_id'] = $phone_id;
$data_Port['itemtype'] = $Phone->getType();
$NetworkPort->update($data_Port);
}
$this->deleteFromDB($items_id, 1);
$Import++;
break;
default:
$NoImport++;
break;
}
return array($Import, $NoImport);
}
/**
* @test
*/
public function prepareDB()
{
global $DB;
$DB->connect();
$entity = new Entity();
$computer = new Computer();
$pfAgent = new PluginFusioninventoryAgent();
$pfTask = new PluginFusioninventoryTask();
$pfTaskjob = new PluginFusioninventoryTaskjob();
$pfIPRange = new PluginFusioninventoryIPRange();
$networkEquipment = new NetworkEquipment();
$networkPort = new NetworkPort();
$printer = new Printer();
$pfNetworkEquipment = new PluginFusioninventoryNetworkEquipment();
// Create entities
$_SESSION['glpiactive_entity'] = 0;
$DB->query("INSERT INTO `glpi_entities`\n (`id`, `name`, `entities_id`, `completename`, `level`)\n VALUES (1, 'ent1', 0, 'Entité racine > ent1', 2)");
$DB->query("INSERT INTO `glpi_entities`\n (`id`, `name`, `entities_id`, `completename`, `level`)\n VALUES (2, 'ent2', 0, 'Entité racine > ent2', 2)");
$DB->query("INSERT INTO `glpi_entities`\n (`id`, `name`, `entities_id`, `completename`, `level`)\n VALUES (3, 'ent1.1', 1, 'Entité racine > ent1 > ent1.1', 3)");
// Create computers + agents
$input = array('entities_id' => 0, 'name' => 'computer1');
$computers_id = $computer->add($input);
$input = array('entities_id' => 0, 'name' => 'computer1', 'version' => '{"INVENTORY":"v2.3.11"}', 'device_id' => 'computer1', 'useragent' => 'FusionInventory-Agent_v2.3.11', 'computers_id' => $computers_id);
$pfAgent->add($input);
// Create Network Equipments
$input = array('name' => 'sw0', 'entities_id' => 0);
$networkEquipment->add($input);
$input = array('entities_id' => 0, 'name' => 'management', 'items_id' => 1, 'itemtype' => 'NetworkEquipment', 'instantiation_type' => 'NetworkPortAggregate', 'NetworkName__ipaddresses' => array('-1' => '10.0.0.10'));
$networkPort->splitInputForElements($input);
$networkPort->add($input);
$networkPort->updateDependencies(1);
$input = array('networkequipments_id' => 1, 'plugin_fusioninventory_configsecurities_id' => 2);
$pfNetworkEquipment->add($input);
$input = array('name' => 'sw1', 'entities_id' => 1);
$networkEquipment->add($input);
$input = array('entities_id' => 1, 'name' => 'management', 'items_id' => 2, 'itemtype' => 'NetworkEquipment', 'instantiation_type' => 'NetworkPortAggregate', 'NetworkName__ipaddresses' => array('-1' => '10.0.0.11'));
$networkPort->splitInputForElements($input);
$networkPort->add($input);
$networkPort->updateDependencies(1);
$input = array('networkequipments_id' => 2, 'plugin_fusioninventory_configsecurities_id' => 2);
$pfNetworkEquipment->add($input);
$input = array('name' => 'sw2', 'entities_id' => 2);
$networkEquipment->add($input);
$input = array('entities_id' => 2, 'name' => 'management', 'items_id' => 3, 'itemtype' => 'NetworkEquipment', 'instantiation_type' => 'NetworkPortAggregate', 'NetworkName__ipaddresses' => array('-1' => '10.0.0.12'));
$networkPort->splitInputForElements($input);
$networkPort->add($input);
$networkPort->updateDependencies(1);
$input = array('networkequipments_id' => 3, 'plugin_fusioninventory_configsecurities_id' => 2);
$pfNetworkEquipment->add($input);
$input = array('name' => 'sw3/1.1', 'entities_id' => 3);
$networkEquipment->add($input);
$input = array('entities_id' => 3, 'name' => 'management', 'items_id' => 4, 'itemtype' => 'NetworkEquipment', 'instantiation_type' => 'NetworkPortAggregate', 'NetworkName__ipaddresses' => array('-1' => '10.0.0.21'));
$networkPort->splitInputForElements($input);
$networkPort->add($input);
$networkPort->updateDependencies(1);
$input = array('networkequipments_id' => 4, 'plugin_fusioninventory_configsecurities_id' => 2);
$pfNetworkEquipment->add($input);
// Create Printers
// Add IPRange
$input = array('entities_id' => 1, 'name' => 'Office', 'ip_start' => '10.0.0.1', 'ip_end' => '10.0.0.254');
$ipranges_id = $pfIPRange->add($input);
// Allow all agents to do network discovery
$query = "UPDATE `glpi_plugin_fusioninventory_agentmodules` " . " SET `is_active`='1' " . " WHERE `modulename`='NETWORKINVENTORY'";
$DB->query($query);
// create task
$input = array('entities_id' => 0, 'name' => 'network inventory', 'is_active' => 1);
$tasks_id = $pfTask->add($input);
// create taskjob
$input = array('plugin_fusioninventory_tasks_id' => $tasks_id, 'entities_id' => 0, 'name' => 'inventory', 'method' => 'networkinventory', 'targets' => '[{"PluginFusioninventoryIPRange":"' . $ipranges_id . '"}]', 'actors' => '[{"PluginFusioninventoryAgent":"1"}]');
$pfTaskjob->add($input);
}
/**
* Function to update NetworkEquipment
*
* @param array $a_inventory data fron agent inventory
* @param id $items_id id of the networkequipment
*
* @return nothing
*/
function updateNetworkEquipment($a_inventory, $items_id)
{
global $DB;
$networkEquipment = new NetworkEquipment();
$pfNetworkEquipment = new PluginFusioninventoryNetworkEquipment();
$networkEquipment->getFromDB($items_id);
if (!isset($_SESSION['glpiactiveentities_string'])) {
$_SESSION['glpiactiveentities_string'] = $networkEquipment->fields['entities_id'];
}
if (!isset($_SESSION['glpiactiveentities'])) {
$_SESSION['glpiactiveentities'] = array($networkEquipment->fields['entities_id']);
}
if (!isset($_SESSION['glpiactive_entity'])) {
$_SESSION['glpiactive_entity'] = $networkEquipment->fields['entities_id'];
}
// * NetworkEquipment
$db_networkequipment = $networkEquipment->fields;
$a_lockable = PluginFusioninventoryLock::getLockFields('glpi_networkequipments', $items_id);
$a_ret = PluginFusioninventoryToolbox::checkLock($a_inventory['NetworkEquipment'], $db_networkequipment, $a_lockable);
$a_inventory['NetworkEquipment'] = $a_ret[0];
$mac = $a_inventory['NetworkEquipment']['mac'];
unset($a_inventory['NetworkEquipment']['mac']);
$input = $a_inventory['NetworkEquipment'];
$input['id'] = $items_id;
$networkEquipment->update($input);
$this->internalPorts($a_inventory['internalport'], $items_id, $mac, 'Internal');
// * NetworkEquipment fusion (ext)
$db_networkequipment = array();
$query = "SELECT *\n FROM `" . getTableForItemType("PluginFusioninventoryNetworkEquipment") . "`\n WHERE `networkequipments_id` = '{$items_id}'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
foreach ($data as $key => $value) {
$db_networkequipment[$key] = Toolbox::addslashes_deep($value);
}
}
if (count($db_networkequipment) == '0') {
// Add
$a_inventory['PluginFusioninventoryNetworkEquipment']['networkequipments_id'] = $items_id;
$pfNetworkEquipment->add($a_inventory['PluginFusioninventoryNetworkEquipment']);
} else {
// Update
$idtmp = $db_networkequipment['id'];
unset($db_networkequipment['id']);
unset($db_networkequipment['networkequipments_id']);
unset($db_networkequipment['plugin_fusioninventory_configsecurities_id']);
$a_ret = PluginFusioninventoryToolbox::checkLock($a_inventory['PluginFusioninventoryNetworkEquipment'], $db_networkequipment);
$a_inventory['PluginFusioninventoryNetworkEquipment'] = $a_ret[0];
$input = $a_inventory['PluginFusioninventoryNetworkEquipment'];
$input['id'] = $idtmp;
$pfNetworkEquipment->update($input);
}
// * Ports
$this->importPorts($a_inventory, $items_id);
}
