/**
* Function to update Printer
*
* @param array $a_inventory data fron agent inventory
* @param id $items_id id of the printer
*
* @return nothing
*/
function updatePrinter($a_inventory, $items_id)
{
global $DB;
$printer = new Printer();
$pfPrinter = new PluginFusioninventoryPrinter();
$printer->getFromDB($items_id);
if (!isset($_SESSION['glpiactiveentities_string'])) {
$_SESSION['glpiactiveentities_string'] = $printer->fields['entities_id'];
}
if (!isset($_SESSION['glpiactiveentities'])) {
$_SESSION['glpiactiveentities'] = array($printer->fields['entities_id']);
}
if (!isset($_SESSION['glpiactive_entity'])) {
$_SESSION['glpiactive_entity'] = $printer->fields['entities_id'];
}
// * Printer
$db_printer = $printer->fields;
$a_lockable = PluginFusioninventoryLock::getLockFields('glpi_printers', $items_id);
$a_ret = PluginFusioninventoryToolbox::checkLock($a_inventory['Printer'], $db_printer, $a_lockable);
$a_inventory['Printer'] = $a_ret[0];
$input = $a_inventory['Printer'];
$input['id'] = $items_id;
$printer->update($input);
// * Printer fusion (ext)
$db_printer = array();
$query = "SELECT *\n FROM `" . getTableForItemType("PluginFusioninventoryPrinter") . "`\n WHERE `printers_id` = '{$items_id}'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
foreach ($data as $key => $value) {
$db_printer[$key] = Toolbox::addslashes_deep($value);
}
}
if (count($db_printer) == '0') {
// Add
$a_inventory['PluginFusioninventoryPrinter']['printers_id'] = $items_id;
$pfPrinter->add($a_inventory['PluginFusioninventoryPrinter']);
} else {
// Update
$idtmp = $db_printer['id'];
unset($db_printer['id']);
unset($db_printer['printers_id']);
unset($db_printer['plugin_fusioninventory_configsecurities_id']);
$a_ret = PluginFusioninventoryToolbox::checkLock($a_inventory['PluginFusioninventoryPrinter'], $db_printer);
$a_inventory['PluginFusioninventoryPrinter'] = $a_ret[0];
$input = $a_inventory['PluginFusioninventoryPrinter'];
$input['id'] = $idtmp;
$pfPrinter->update($input);
}
// * Ports
$this->importPorts($a_inventory, $items_id);
// Page counters
$this->importPageCounters($a_inventory['pagecounters'], $items_id);
// Cartridges
$this->importCartridges($a_inventory['cartridge'], $items_id);
}
/**
* 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);
}
/**
* Load an existing item
*
*@return nothing
**/
function load($p_id = '')
{
global $DB, $LINK_ID_TABLE;
if ($p_id != '') {
// existing item : load old values
$this->getFromDB($p_id);
$this->ptcdFields = $this->fields;
$itemtype = array_search($this->table, $LINK_ID_TABLE);
if ($itemtype) {
$this->ptcdLockFields = PluginFusioninventoryLock::getLockFields($itemtype, $p_id);
}
} else {
// new item : initialize all fields to NULL
$query = "SHOW COLUMNS FROM `" . $this->table . "`";
if ($result = $DB->query($query)) {
while ($data = $DB->fetch_array($result)) {
$this->ptcdFields[$data[0]] = NULL;
}
}
}
}
static function showInfo($item)
{
// Manage locks pictures
PluginFusioninventoryLock::showLockIcon('Printer');
$pfPrinter = new PluginFusioninventoryPrinter();
$a_printerextend = current($pfPrinter->find("`printers_id`='" . $item->getID() . "'", "", 1));
if (empty($a_printerextend)) {
return;
}
echo '<table class="tab_glpi" width="100%">';
echo '<tr>';
echo '<th colspan="2">' . __('FusionInventory', 'fusioninventory') . '</th>';
echo '</tr>';
echo '<tr class="tab_bg_1">';
echo '<td>';
echo __('Last inventory', 'fusioninventory');
echo '</td>';
echo '<td>';
echo Html::convDateTime($a_printerextend['last_fusioninventory_update']);
echo '</td>';
echo '</tr>';
echo '<tr class="tab_bg_1">';
echo '<td>';
echo __('Type');
echo '</td>';
echo '<td>';
echo "SNMP";
echo '</td>';
echo '</tr>';
echo "</table>";
}
@package FusionInventory
@author Vincent Mazzoni
@co-author
@copyright Copyright (c) 2010-2014 FusionInventory team
@license AGPL License 3.0 or (at your option) any later version
http://www.gnu.org/licenses/agpl-3.0-standalone.html
@link http://www.fusioninventory.org/
@link http://forge.fusioninventory.org/projects/fusioninventory-for-glpi/
@since 2010
------------------------------------------------------------------------
*/
include "../../../inc/includes.php";
Session::checkLoginUser();
if (isset($_POST["unlock_field_fusioninventory"])) {
$typeright = strtolower($_POST['type']);
if ($typeright == "networkequipment") {
$typeright = "networking";
}
if (Session::haveRight($typeright, UPDATE)) {
if (isset($_POST["lockfield_fusioninventory"]) && count($_POST["lockfield_fusioninventory"])) {
$tab = PluginFusioninventoryLock::exportChecksToArray($_POST["lockfield_fusioninventory"]);
PluginFusioninventoryLock::setLockArray($_POST['type'], $_POST["id"], $tab);
} else {
PluginFusioninventoryLock::setLockArray($_POST['type'], $_POST["id"], array());
}
}
Html::back();
}
Html::footer();
function pluginFusioninventoryInstall($version, $migrationname = 'Migration')
{
global $DB;
ini_set("memory_limit", "-1");
ini_set("max_execution_time", "0");
$migration = new $migrationname($version);
/*
* Load classes
*/
foreach (glob(GLPI_ROOT . '/plugins/fusioninventory/inc/*.php') as $file) {
require_once $file;
}
$migration->displayMessage("Installation of plugin FusionInventory");
// Get informations of plugin
/*
* Clean if Fusion / Tracker has been installed and uninstalled (not clean correctly)
*/
$migration->displayMessage("Clean data from old installation of the plugin");
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype`='5150'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype`='5151'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype`='5152'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype`='5153'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype`='5156'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype`='5157'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype`='5158'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype`='5159'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype`='5161'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype`='5165'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype`='5166'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype`='5167'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype`='5168'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype` LIKE 'PluginFusioninventory%'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype` LIKE 'PluginFusinvinventory%'";
$DB->query($sql);
$sql = "DELETE FROM `glpi_displaypreferences`\n WHERE `itemtype` LIKE 'PluginFusinvsnmp%'";
$DB->query($sql);
// Purge network ports have itemtype tp 5153
$networkPort = new NetworkPort();
$sql = "SELECT * FROM `glpi_networkports`\n WHERE `itemtype`='5153'";
$result = $DB->query($sql);
while ($data = $DB->fetch_array($result)) {
$networkPort->delete(array('id' => $data['id']), 1);
}
/*
* Remove old rules
*/
$migration->displayMessage("Clean rules from old installation of the plugin");
$Rule = new Rule();
$a_rules = $Rule->find("`sub_type`='PluginFusioninventoryInventoryRuleImport'");
foreach ($a_rules as $data) {
$Rule->delete($data);
}
$a_rules = $Rule->find("`sub_type`='PluginFusinvinventoryRuleEntity'");
foreach ($a_rules as $data) {
$Rule->delete($data);
}
$a_rules = $Rule->find("`sub_type`='PluginFusinvinventoryRuleLocation'");
foreach ($a_rules as $data) {
$Rule->delete($data);
}
/*
* Create DB structure
*/
$migration->displayMessage("Creation tables in database");
$DB_file = GLPI_ROOT . "/plugins/fusioninventory/install/mysql/plugin_fusioninventory-empty.sql";
if (!$DB->runFile($DB_file)) {
$migration->displayMessage("Error on creation tables in database");
}
if (!$DB->runFile(GLPI_ROOT . "/plugins/fusioninventory/install/mysql/usbid.sql")) {
$migration->displayMessage("Error on creation table usbid in database");
}
if (!$DB->runFile(GLPI_ROOT . "/plugins/fusioninventory/install/mysql/pciid.sql")) {
$migration->displayMessage("Error on creation table pciid in database");
}
if (!$DB->runFile(GLPI_ROOT . "/plugins/fusioninventory/install/mysql/oui.sql")) {
$migration->displayMessage("Error on creation table oui in database");
}
/*
* Creation of folders
*/
$migration->displayMessage("Creation of folders");
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory')) {
mkdir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory');
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/tmp')) {
mkdir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/tmp');
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/xml')) {
mkdir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/xml');
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/xml/computer')) {
mkdir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/xml/computer');
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/xml/printer')) {
mkdir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/xml/printer');
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/xml/networkequipment')) {
mkdir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/xml/networkequipment');
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/upload')) {
mkdir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/upload');
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/walks')) {
mkdir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/walks');
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/tmpmodels')) {
mkdir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/tmpmodels');
}
/*
* Deploy folders
*/
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/files')) {
mkdir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/files');
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/files/repository')) {
mkdir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/files/repository');
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/files/manifests')) {
mkdir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/files/manifests');
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/files/import')) {
mkdir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/files/import');
}
if (!is_dir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/files/export')) {
mkdir(GLPI_PLUGIN_DOC_DIR . '/fusioninventory/files/export');
}
/*
* Manage profiles
*/
$migration->displayMessage("Initialize profiles");
PluginFusioninventoryProfile::initProfile();
/*
* bug of purge network port when purge unmanaged devices, so we clean
*/
$sql = "SELECT `glpi_networkports`.`id` as nid FROM `glpi_networkports`\n LEFT JOIN `glpi_plugin_fusioninventory_unmanageds`\n ON `glpi_plugin_fusioninventory_unmanageds`.`id` = `glpi_networkports`.`items_id`\n WHERE `itemtype`='PluginFusioninventoryUnmanaged'\n AND `glpi_plugin_fusioninventory_unmanageds`.`id` IS NULL ";
$result = $DB->query($sql);
while ($data = $DB->fetch_array($result)) {
$networkPort->delete(array('id' => $data['nid']), 1);
}
/*
* Add config
*/
$migration->displayMessage("Initialize configuration");
$pfConfig = new PluginFusioninventoryConfig();
$pfConfig->initConfigModule();
$configLogField = new PluginFusioninventoryConfigLogField();
$configLogField->initConfig();
/*
* Register Agent TASKS
*/
$migration->displayMessage("Initialize agent TASKS");
$pfAgentmodule = new PluginFusioninventoryAgentmodule();
$input = array();
$input['modulename'] = "WAKEONLAN";
$input['is_active'] = 0;
$input['exceptions'] = exportArrayToDB(array());
$pfAgentmodule->add($input);
$input = array();
$input['modulename'] = "INVENTORY";
$input['is_active'] = 1;
$input['exceptions'] = exportArrayToDB(array());
$pfAgentmodule->add($input);
$input = array();
$input['modulename'] = "InventoryComputerESX";
$input['is_active'] = 0;
$input['exceptions'] = exportArrayToDB(array());
$pfAgentmodule->add($input);
$input = array();
$input['modulename'] = "NETWORKINVENTORY";
$input['is_active'] = 0;
$input['exceptions'] = exportArrayToDB(array());
$pfAgentmodule->add($input);
$input = array();
$input['modulename'] = "NETWORKDISCOVERY";
$input['is_active'] = 0;
$input['exceptions'] = exportArrayToDB(array());
$pfAgentmodule->add($input);
$input = array();
$input['modulename'] = "DEPLOY";
$input['is_active'] = 0;
$input['exceptions'] = exportArrayToDB(array());
$pfAgentmodule->add($input);
$input = array();
$input['modulename'] = "Collect";
$input['is_active'] = 1;
$input['exceptions'] = exportArrayToDB(array());
$pfAgentmodule->add($input);
/*
* Add cron task
*/
$migration->displayMessage("Initialize cron task");
CronTask::Register('PluginFusioninventoryTask', 'taskscheduler', '60', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
Crontask::Register('PluginFusioninventoryTaskjobstate', 'cleantaskjob', 3600 * 24, array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
Crontask::Register('PluginFusioninventoryNetworkPortLog', 'cleannetworkportlogs', 3600 * 24, array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
CronTask::Register('PluginFusioninventoryTaskjob', 'updatedynamictasks', '60', array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30, 'state' => 0));
Crontask::Register('PluginFusioninventoryAgent', 'cleanoldagents', 3600 * 24, array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30, 'comment' => 'Clean agents not contacted since xxx days'));
Crontask::Register('PluginFusioninventoryAgentWakeup', 'wakeupAgents', 120, array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30, 'comment' => 'Wake agents ups'));
/*
* Create rules
*/
$migration->displayMessage("Create rules");
$pfSetup = new PluginFusioninventorySetup();
$pfSetup->initRules();
/*
* Add notification for configuration management
*/
/*
* Import OCS locks
*/
$migration->displayMessage("Import OCS locks if exists");
$pfLock = new PluginFusioninventoryLock();
$pfLock->importFromOcs();
Crontask::Register('PluginFusioninventoryTaskjobstate', 'cleantaskjob', 3600 * 24, array('mode' => 2, 'allowmode' => 3, 'logs_lifetime' => 30));
$pfNetworkporttype = new PluginFusioninventoryNetworkporttype();
$pfNetworkporttype->init();
require_once GLPI_ROOT . "/plugins/fusioninventory/inc/inventorycomputerstat.class.php";
PluginFusioninventoryInventoryComputerStat::init();
$mode_cli = basename($_SERVER['SCRIPT_NAME']) == "cli_install.php";
}
/**
* @since version 0.85
*
* @see CommonDBTM::processMassiveActionsForOneItemtype()
**/
static function processMassiveActionsForOneItemtype(MassiveAction $ma, CommonDBTM $item, array $ids)
{
$itemtype = $item->getType();
switch ($ma->getAction()) {
case "manage_locks":
if ($itemtype == "NetworkEquipment" || $itemtype == "Printer" || $itemtype == "Computer") {
foreach ($ids as $key) {
if (isset($_POST["lockfield_fusioninventory"]) && count($_POST["lockfield_fusioninventory"])) {
$tab = PluginFusioninventoryLock::exportChecksToArray($_POST["lockfield_fusioninventory"]);
//lock current item
if (PluginFusioninventoryLock::setLockArray($_POST['type'], $key, $tab, $_POST['actionlock'])) {
//set action massive ok for this item
$ma->itemDone($item->getType(), $key, MassiveAction::ACTION_OK);
} else {
// KO
$ma->itemDone($item->getType(), $key, MassiveAction::ACTION_KO);
}
}
}
}
break;
}
}
/**
* Update computer data
*
* @global type $DB
*
* @param php array $a_computerinventory all data from the agent
* @param integer $computers_id id of the computer
* @param boolean $no_history set true if not want history
*
* @return nothing
*/
function updateComputer($a_computerinventory, $computers_id, $no_history, $setdynamic = 0)
{
global $DB, $CFG_GLPI;
$computer = new Computer();
$pfInventoryComputerComputer = new PluginFusioninventoryInventoryComputerComputer();
$item_DeviceProcessor = new Item_DeviceProcessor();
$deviceProcessor = new DeviceProcessor();
$item_DeviceMemory = new Item_DeviceMemory();
$deviceMemory = new DeviceMemory();
$computerVirtualmachine = new ComputerVirtualMachine();
$computerDisk = new ComputerDisk();
$item_DeviceControl = new Item_DeviceControl();
$item_DeviceHardDrive = new Item_DeviceHardDrive();
$item_DeviceDrive = new Item_DeviceDrive();
$item_DeviceGraphicCard = new Item_DeviceGraphicCard();
$item_DeviceNetworkCard = new Item_DeviceNetworkCard();
$item_DeviceSoundCard = new Item_DeviceSoundCard();
$networkPort = new NetworkPort();
$networkName = new NetworkName();
$iPAddress = new IPAddress();
$ipnetwork = new IPNetwork();
$pfInventoryComputerAntivirus = new PluginFusioninventoryInventoryComputerAntivirus();
$pfConfig = new PluginFusioninventoryConfig();
$pfComputerLicenseInfo = new PluginFusioninventoryComputerLicenseInfo();
$computer_Item = new Computer_Item();
$monitor = new Monitor();
$printer = new Printer();
$peripheral = new Peripheral();
// $pfInventoryComputerStorage = new PluginFusioninventoryInventoryComputerStorage();
// $pfInventoryComputerStorage_Storage =
// new PluginFusioninventoryInventoryComputerStorage_Storage();
$computer->getFromDB($computers_id);
$a_lockable = PluginFusioninventoryLock::getLockFields('glpi_computers', $computers_id);
// * Computer
$db_computer = array();
$db_computer = $computer->fields;
$computerName = $a_computerinventory['Computer']['name'];
$a_ret = PluginFusioninventoryToolbox::checkLock($a_computerinventory['Computer'], $db_computer, $a_lockable);
$a_computerinventory['Computer'] = $a_ret[0];
$input = $a_computerinventory['Computer'];
$input['id'] = $computers_id;
$history = TRUE;
if ($no_history) {
$history = FALSE;
}
$input['_no_history'] = $no_history;
PluginFusioninventoryInventoryComputerInventory::addDefaultStateIfNeeded($input);
$computer->update($input, !$no_history);
$this->computer = $computer;
// * Computer fusion (ext)
$db_computer = array();
if ($no_history === FALSE) {
$query = "SELECT * FROM `glpi_plugin_fusioninventory_inventorycomputercomputers`\n WHERE `computers_id` = '{$computers_id}'\n LIMIT 1";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
foreach ($data as $key => $value) {
$data[$key] = Toolbox::addslashes_deep($value);
}
$db_computer = $data;
}
}
if (count($db_computer) == '0') {
// Add
$a_computerinventory['fusioninventorycomputer']['computers_id'] = $computers_id;
$pfInventoryComputerComputer->add($a_computerinventory['fusioninventorycomputer'], array(), FALSE);
} else {
// Update
if (!empty($db_computer['serialized_inventory'])) {
$setdynamic = 0;
}
$idtmp = $db_computer['id'];
unset($db_computer['id']);
unset($db_computer['computers_id']);
$a_ret = PluginFusioninventoryToolbox::checkLock($a_computerinventory['fusioninventorycomputer'], $db_computer);
$a_computerinventory['fusioninventorycomputer'] = $a_ret[0];
$db_computer = $a_ret[1];
$input = $a_computerinventory['fusioninventorycomputer'];
$input['id'] = $idtmp;
$input['_no_history'] = $no_history;
$pfInventoryComputerComputer->update($input, !$no_history);
}
// Put all link item dynamic (in case of update computer not yet inventoried with fusion)
if ($setdynamic == 1) {
$this->setDynamicLinkItems($computers_id);
}
// * Processors
if ($pfConfig->getValue("component_processor") != 0) {
$db_processors = array();
if ($no_history === FALSE) {
$query = "SELECT `glpi_items_deviceprocessors`.`id`, `designation`,\n `frequency`, `frequence`, `frequency_default`,\n `serial`, `manufacturers_id`, `glpi_items_deviceprocessors`.`nbcores`,\n `glpi_items_deviceprocessors`.`nbthreads`\n FROM `glpi_items_deviceprocessors`\n LEFT JOIN `glpi_deviceprocessors`\n ON `deviceprocessors_id`=`glpi_deviceprocessors`.`id`\n WHERE `items_id` = '{$computers_id}'\n AND `itemtype`='Computer'\n AND `is_dynamic`='1'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['id'];
unset($data['id']);
$db_processors[$idtmp] = Toolbox::addslashes_deep($data);
}
}
if (count($db_processors) == 0) {
foreach ($a_computerinventory['processor'] as $a_processor) {
$this->addProcessor($a_processor, $computers_id, $no_history);
}
} else {
// Check all fields from source: 'designation', 'serial', 'manufacturers_id',
// 'frequence'
foreach ($a_computerinventory['processor'] as $key => $arrays) {
$frequence = $arrays['frequence'];
unset($arrays['frequence']);
unset($arrays['frequency']);
unset($arrays['frequency_default']);
foreach ($db_processors as $keydb => $arraydb) {
$frequencedb = $arraydb['frequence'];
unset($arraydb['frequence']);
unset($arraydb['frequency']);
unset($arraydb['frequency_default']);
if ($arrays == $arraydb) {
$a_criteria = $deviceProcessor->getImportCriteria();
$criteriafrequence = $a_criteria['frequence'];
$compare = explode(':', $criteriafrequence);
if ($frequence > $frequencedb - $compare[1] && $frequence < $frequencedb + $compare[1]) {
unset($a_computerinventory['processor'][$key]);
unset($db_processors[$keydb]);
break;
}
}
}
}
if (count($a_computerinventory['processor']) == 0 and count($db_processors) == 0) {
// Nothing to do
} else {
if (count($db_processors) != 0) {
// Delete processor in DB
foreach ($db_processors as $idtmp => $data) {
$item_DeviceProcessor->delete(array('id' => $idtmp), 1);
}
}
if (count($a_computerinventory['processor']) != 0) {
foreach ($a_computerinventory['processor'] as $a_processor) {
$this->addProcessor($a_processor, $computers_id, $no_history);
}
}
}
}
}
// * Memories
if ($pfConfig->getValue("component_memory") != 0) {
$db_memories = array();
if ($no_history === FALSE) {
$query = "SELECT `glpi_items_devicememories`.`id`, `designation`, `size`,\n `frequence`, `serial`, `devicememorytypes_id`,\n `glpi_items_devicememories`.`busID`\n FROM `glpi_items_devicememories`\n LEFT JOIN `glpi_devicememories` ON `devicememories_id`=`glpi_devicememories`.`id`\n WHERE `items_id` = '{$computers_id}'\n AND `itemtype`='Computer'\n AND `is_dynamic`='1'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['id'];
unset($data['id']);
$data1 = Toolbox::addslashes_deep($data);
$db_memories[$idtmp] = $data1;
}
}
if (count($db_memories) == 0) {
foreach ($a_computerinventory['memory'] as $a_memory) {
$this->addMemory($a_memory, $computers_id, $no_history);
}
} else {
// Check all fields from source: 'designation', 'serial', 'size',
// 'devicememorytypes_id', 'frequence'
foreach ($a_computerinventory['memory'] as $key => $arrays) {
$frequence = $arrays['frequence'];
unset($arrays['frequence']);
foreach ($db_memories as $keydb => $arraydb) {
$frequencedb = $arraydb['frequence'];
unset($arraydb['frequence']);
if ($arrays == $arraydb) {
$a_criteria = $deviceMemory->getImportCriteria();
$criteriafrequence = $a_criteria['frequence'];
$compare = explode(':', $criteriafrequence);
if ($frequence > $frequencedb - $compare[1] && $frequence < $frequencedb + $compare[1]) {
unset($a_computerinventory['memory'][$key]);
unset($db_memories[$keydb]);
break;
}
}
}
}
if (count($a_computerinventory['memory']) == 0 and count($db_memories) == 0) {
// Nothing to do
} else {
if (count($db_memories) != 0) {
// Delete memory in DB
foreach ($db_memories as $idtmp => $data) {
$item_DeviceMemory->delete(array('id' => $idtmp), 1);
}
}
if (count($a_computerinventory['memory']) != 0) {
foreach ($a_computerinventory['memory'] as $a_memory) {
$this->addMemory($a_memory, $computers_id, $no_history);
}
}
}
}
}
// * Hard drive
if ($pfConfig->getValue("component_harddrive") != 0) {
$db_harddrives = array();
if ($no_history === FALSE) {
$query = "SELECT `glpi_items_deviceharddrives`.`id`, `serial`,\n `capacity`\n FROM `glpi_items_deviceharddrives`\n WHERE `items_id` = '{$computers_id}'\n AND `itemtype`='Computer'\n AND `is_dynamic`='1'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['id'];
unset($data['id']);
$data1 = Toolbox::addslashes_deep($data);
$data2 = array_map('strtolower', $data1);
$db_harddrives[$idtmp] = $data2;
}
}
if (count($db_harddrives) == 0) {
foreach ($a_computerinventory['harddrive'] as $a_harddrive) {
$this->addHardDisk($a_harddrive, $computers_id, $no_history);
}
} else {
foreach ($a_computerinventory['harddrive'] as $key => $arrays) {
$arrayslower = array_map('strtolower', $arrays);
foreach ($db_harddrives as $keydb => $arraydb) {
if ($arrayslower['serial'] == $arraydb['serial']) {
if ($arraydb['capacity'] == 0 and $arrayslower['capacity'] > 0) {
$input = array('id' => $keydb, 'capacity' => $arrayslower['capacity']);
$item_DeviceHardDrive->update($input);
}
unset($a_computerinventory['harddrive'][$key]);
unset($db_harddrives[$keydb]);
break;
}
}
}
if (count($a_computerinventory['harddrive']) == 0 and count($db_harddrives) == 0) {
// Nothing to do
} else {
if (count($db_harddrives) != 0) {
// Delete hard drive in DB
foreach ($db_harddrives as $idtmp => $data) {
$item_DeviceHardDrive->delete(array('id' => $idtmp), 1);
}
}
if (count($a_computerinventory['harddrive']) != 0) {
foreach ($a_computerinventory['harddrive'] as $a_harddrive) {
$this->addHardDisk($a_harddrive, $computers_id, $no_history);
}
}
}
}
}
// * drive
if ($pfConfig->getValue("component_drive") != 0) {
$db_drives = array();
if ($no_history === FALSE) {
$query = "SELECT `glpi_items_devicedrives`.`id`, `serial`,\n `glpi_devicedrives`.`designation`\n FROM `glpi_items_devicedrives`\n LEFT JOIN `glpi_devicedrives` ON `devicedrives_id`=`glpi_devicedrives`.`id`\n WHERE `items_id` = '{$computers_id}'\n AND `itemtype`='Computer'\n AND `is_dynamic`='1'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['id'];
unset($data['id']);
$data1 = Toolbox::addslashes_deep($data);
$data2 = array_map('strtolower', $data1);
$db_drives[$idtmp] = $data2;
}
}
if (count($db_drives) == 0) {
foreach ($a_computerinventory['drive'] as $a_drive) {
$this->addDrive($a_drive, $computers_id, $no_history);
}
} else {
foreach ($a_computerinventory['drive'] as $key => $arrays) {
$arrayslower = array_map('strtolower', $arrays);
if ($arrayslower['serial'] == '') {
foreach ($db_drives as $keydb => $arraydb) {
if ($arrayslower['designation'] == $arraydb['designation']) {
unset($a_computerinventory['drive'][$key]);
unset($db_drives[$keydb]);
break;
}
}
} else {
foreach ($db_drives as $keydb => $arraydb) {
if ($arrayslower['serial'] == $arraydb['serial']) {
unset($a_computerinventory['drive'][$key]);
unset($db_drives[$keydb]);
break;
}
}
}
}
if (count($a_computerinventory['drive']) == 0 and count($db_drives) == 0) {
// Nothing to do
} else {
if (count($db_drives) != 0) {
// Delete drive in DB
foreach ($db_drives as $idtmp => $data) {
$item_DeviceDrive->delete(array('id' => $idtmp), 1);
}
}
if (count($a_computerinventory['drive']) != 0) {
foreach ($a_computerinventory['drive'] as $a_drive) {
$this->addDrive($a_drive, $computers_id, $no_history);
}
}
}
}
}
// * Graphiccard
if ($pfConfig->getValue("component_graphiccard") != 0) {
$db_graphiccards = array();
if ($no_history === FALSE) {
$query = "SELECT `glpi_items_devicegraphiccards`.`id`, `designation`, `memory`\n FROM `glpi_items_devicegraphiccards`\n LEFT JOIN `glpi_devicegraphiccards`\n ON `devicegraphiccards_id`=`glpi_devicegraphiccards`.`id`\n WHERE `items_id` = '{$computers_id}'\n AND `itemtype`='Computer'\n AND `is_dynamic`='1'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['id'];
unset($data['id']);
if (preg_match("/[^a-zA-Z0-9 \\-_\\(\\)]+/", $data['designation'])) {
$data['designation'] = Toolbox::addslashes_deep($data['designation']);
}
$data['designation'] = trim(strtolower($data['designation']));
$db_graphiccards[$idtmp] = $data;
}
}
if (count($db_graphiccards) == 0) {
foreach ($a_computerinventory['graphiccard'] as $a_graphiccard) {
$this->addGraphicCard($a_graphiccard, $computers_id, $no_history);
}
} else {
// Check all fields from source: 'designation', 'memory'
foreach ($a_computerinventory['graphiccard'] as $key => $arrays) {
$arrays['designation'] = strtolower($arrays['designation']);
foreach ($db_graphiccards as $keydb => $arraydb) {
if ($arrays == $arraydb) {
unset($a_computerinventory['graphiccard'][$key]);
unset($db_graphiccards[$keydb]);
break;
}
}
}
if (count($a_computerinventory['graphiccard']) == 0 and count($db_graphiccards) == 0) {
// Nothing to do
} else {
if (count($db_graphiccards) != 0) {
// Delete graphiccard in DB
foreach ($db_graphiccards as $idtmp => $data) {
$item_DeviceGraphicCard->delete(array('id' => $idtmp), 1);
}
}
if (count($a_computerinventory['graphiccard']) != 0) {
foreach ($a_computerinventory['graphiccard'] as $a_graphiccard) {
$this->addGraphicCard($a_graphiccard, $computers_id, $no_history);
}
}
}
}
}
// * networkcard
if ($pfConfig->getValue("component_networkcard") != 0) {
$db_networkcards = array();
if ($no_history === FALSE) {
$query = "SELECT `glpi_items_devicenetworkcards`.`id`, `designation`, `mac`,\n `manufacturers_id`\n FROM `glpi_items_devicenetworkcards`\n LEFT JOIN `glpi_devicenetworkcards`\n ON `devicenetworkcards_id`=`glpi_devicenetworkcards`.`id`\n WHERE `items_id` = '{$computers_id}'\n AND `itemtype`='Computer'\n AND `is_dynamic`='1'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['id'];
unset($data['id']);
if (preg_match("/[^a-zA-Z0-9 \\-_\\(\\)]+/", $data['designation'])) {
$data['designation'] = Toolbox::addslashes_deep($data['designation']);
}
$data['designation'] = trim(strtolower($data['designation']));
$db_networkcards[$idtmp] = $data;
}
}
if (count($db_networkcards) == 0) {
foreach ($a_computerinventory['networkcard'] as $a_networkcard) {
$this->addNetworkCard($a_networkcard, $computers_id, $no_history);
}
} else {
// Check all fields from source: 'designation', 'mac'
foreach ($a_computerinventory['networkcard'] as $key => $arrays) {
$arrays['designation'] = strtolower($arrays['designation']);
foreach ($db_networkcards as $keydb => $arraydb) {
if ($arrays == $arraydb) {
unset($a_computerinventory['networkcard'][$key]);
unset($db_networkcards[$keydb]);
break;
}
}
}
if (count($a_computerinventory['networkcard']) == 0 and count($db_networkcards) == 0) {
// Nothing to do
} else {
if (count($db_networkcards) != 0) {
// Delete networkcard in DB
foreach ($db_networkcards as $idtmp => $data) {
$item_DeviceNetworkCard->delete(array('id' => $idtmp), 1);
}
}
if (count($a_computerinventory['networkcard']) != 0) {
foreach ($a_computerinventory['networkcard'] as $a_networkcard) {
$this->addNetworkCard($a_networkcard, $computers_id, $no_history);
}
}
}
}
}
// * Sound
if ($pfConfig->getValue("component_soundcard") != 0) {
$db_soundcards = array();
if ($no_history === FALSE) {
$query = "SELECT `glpi_items_devicesoundcards`.`id`, `designation`, `comment`,\n `manufacturers_id` FROM `glpi_items_devicesoundcards`\n LEFT JOIN `glpi_devicesoundcards`\n ON `devicesoundcards_id`=`glpi_devicesoundcards`.`id`\n WHERE `items_id` = '{$computers_id}'\n AND `itemtype`='Computer'\n AND `is_dynamic`='1'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['id'];
unset($data['id']);
$data1 = Toolbox::addslashes_deep($data);
$db_soundcards[$idtmp] = $data1;
}
}
if (count($db_soundcards) == 0) {
foreach ($a_computerinventory['soundcard'] as $a_soundcard) {
$this->addSoundCard($a_soundcard, $computers_id, $no_history);
}
} else {
// Check all fields from source: 'designation', 'memory', 'manufacturers_id'
foreach ($a_computerinventory['soundcard'] as $key => $arrays) {
// $arrayslower = array_map('strtolower', $arrays);
$arrayslower = $arrays;
foreach ($db_soundcards as $keydb => $arraydb) {
if ($arrayslower == $arraydb) {
unset($a_computerinventory['soundcard'][$key]);
unset($db_soundcards[$keydb]);
break;
}
}
}
if (count($a_computerinventory['soundcard']) == 0 and count($db_soundcards) == 0) {
// Nothing to do
} else {
if (count($db_soundcards) != 0) {
// Delete soundcard in DB
foreach ($db_soundcards as $idtmp => $data) {
$item_DeviceSoundCard->delete(array('id' => $idtmp), 1);
}
}
if (count($a_computerinventory['soundcard']) != 0) {
foreach ($a_computerinventory['soundcard'] as $a_soundcard) {
$this->addSoundCard($a_soundcard, $computers_id, $no_history);
}
}
}
}
}
// * Controllers
if ($pfConfig->getValue("component_control") != 0) {
$db_controls = array();
if ($no_history === FALSE) {
$query = "SELECT `glpi_items_devicecontrols`.`id`, `interfacetypes_id`,\n `manufacturers_id`, `designation` FROM `glpi_items_devicecontrols`\n LEFT JOIN `glpi_devicecontrols` ON `devicecontrols_id`=`glpi_devicecontrols`.`id`\n WHERE `items_id` = '{$computers_id}'\n AND `itemtype`='Computer'\n AND `is_dynamic`='1'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['id'];
unset($data['id']);
$data1 = Toolbox::addslashes_deep($data);
$data2 = array_map('strtolower', $data1);
$db_controls[$idtmp] = $data2;
}
}
if (count($db_controls) == 0) {
foreach ($a_computerinventory['controller'] as $a_control) {
$this->addControl($a_control, $computers_id, $no_history);
}
} else {
// Check all fields from source:
foreach ($a_computerinventory['controller'] as $key => $arrays) {
$arrayslower = array_map('strtolower', $arrays);
foreach ($db_controls as $keydb => $arraydb) {
if ($arrayslower == $arraydb) {
unset($a_computerinventory['controller'][$key]);
unset($db_controls[$keydb]);
break;
}
}
}
if (count($a_computerinventory['controller']) == 0 and count($db_controls) == 0) {
// Nothing to do
} else {
if (count($db_controls) != 0) {
// Delete controller in DB
foreach ($db_controls as $idtmp => $data) {
$item_DeviceControl->delete(array('id' => $idtmp), 1);
}
}
if (count($a_computerinventory['controller']) != 0) {
foreach ($a_computerinventory['controller'] as $a_control) {
$this->addControl($a_control, $computers_id, $no_history);
}
}
}
}
}
// * Software
if ($pfConfig->getValue("import_software") != 0) {
$entities_id = 0;
if (count($a_computerinventory['software']) > 0) {
$a_softfirst = current($a_computerinventory['software']);
if (isset($a_softfirst['entities_id'])) {
$entities_id = $a_softfirst['entities_id'];
}
}
$db_software = array();
if ($no_history === FALSE) {
$query = "SELECT `glpi_computers_softwareversions`.`id` as sid,\n `glpi_softwares`.`name`,\n `glpi_softwareversions`.`name` AS version,\n `glpi_softwares`.`manufacturers_id`,\n `glpi_softwareversions`.`entities_id`,\n `glpi_computers_softwareversions`.`is_template_computer`,\n `glpi_computers_softwareversions`.`is_deleted_computer`\n FROM `glpi_computers_softwareversions`\n LEFT JOIN `glpi_softwareversions`\n ON (`glpi_computers_softwareversions`.`softwareversions_id`\n = `glpi_softwareversions`.`id`)\n LEFT JOIN `glpi_softwares`\n ON (`glpi_softwareversions`.`softwares_id` = `glpi_softwares`.`id`)\n WHERE `glpi_computers_softwareversions`.`computers_id` = '{$computers_id}'\n AND `glpi_computers_softwareversions`.`is_dynamic`='1'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['sid'];
unset($data['sid']);
if (preg_match("/[^a-zA-Z0-9 \\-_\\(\\)]+/", $data['name'])) {
$data['name'] = Toolbox::addslashes_deep($data['name']);
}
if (preg_match("/[^a-zA-Z0-9 \\-_\\(\\)]+/", $data['version'])) {
$data['version'] = Toolbox::addslashes_deep($data['version']);
}
$comp_key = strtolower($data['name']) . "\$\$\$\$" . strtolower($data['version']) . "\$\$\$\$" . $data['manufacturers_id'] . "\$\$\$\$" . $data['entities_id'];
$db_software[$comp_key] = $idtmp;
}
}
$lastSoftwareid = 0;
$lastSoftwareVid = 0;
/*
* Schema
*
* LOCK software
* 1/ Add all software
* RELEASE software
*
* LOCK softwareversion
* 2/ Add all software versions
* RELEASE softwareversion
*
* 3/ add version to computer
*
*/
if (count($db_software) == 0) {
// there are no software associated with computer
$nb_unicity = count(FieldUnicity::getUnicityFieldsConfig("Software", $entities_id));
$options = array();
if ($nb_unicity == 0) {
$options['disable_unicity_check'] = TRUE;
}
$a_softwareInventory = array();
$a_softwareVersionInventory = array();
$lastSoftwareid = $this->loadSoftwares($entities_id, $a_computerinventory['software'], $lastSoftwareid);
$queryDBLOCK = "INSERT INTO `glpi_plugin_fusioninventory_dblocksoftwares`\n SET `value`='1'";
$CFG_GLPI["use_log_in_files"] = FALSE;
while (!$DB->query($queryDBLOCK)) {
usleep(100000);
}
$CFG_GLPI["use_log_in_files"] = TRUE;
$this->loadSoftwares($entities_id, $a_computerinventory['software'], $lastSoftwareid);
foreach ($a_computerinventory['software'] as $a_software) {
if (!isset($this->softList[$a_software['name'] . "\$\$\$\$" . $a_software['manufacturers_id']])) {
$this->addSoftware($a_software, $options);
}
}
$queryDBLOCK = "DELETE FROM `glpi_plugin_fusioninventory_dblocksoftwares`\n WHERE `value`='1'";
$DB->query($queryDBLOCK);
$lastSoftwareVid = $this->loadSoftwareVersions($entities_id, $a_computerinventory['software'], $lastSoftwareVid);
$queryDBLOCK = "INSERT INTO `glpi_plugin_fusioninventory_dblocksoftwareversions`\n SET `value`='1'";
$CFG_GLPI["use_log_in_files"] = FALSE;
while (!$DB->query($queryDBLOCK)) {
usleep(100000);
}
$CFG_GLPI["use_log_in_files"] = TRUE;
$this->loadSoftwareVersions($entities_id, $a_computerinventory['software'], $lastSoftwareVid);
foreach ($a_computerinventory['software'] as $a_software) {
$softwares_id = $this->softList[$a_software['name'] . "\$\$\$\$" . $a_software['manufacturers_id']];
if (!isset($this->softVersionList[strtolower($a_software['version']) . "\$\$\$\$" . $softwares_id])) {
$this->addSoftwareVersion($a_software, $softwares_id);
}
}
$queryDBLOCK = "DELETE FROM `glpi_plugin_fusioninventory_dblocksoftwareversions`\n WHERE `value`='1'";
$DB->query($queryDBLOCK);
$a_toinsert = array();
foreach ($a_computerinventory['software'] as $a_software) {
$softwares_id = $this->softList[$a_software['name'] . "\$\$\$\$" . $a_software['manufacturers_id']];
$softwareversions_id = $this->softVersionList[strtolower($a_software['version']) . "\$\$\$\$" . $softwares_id];
$a_tmp = array('computers_id' => $computers_id, 'softwareversions_id' => $softwareversions_id, 'is_dynamic' => 1, 'entities_id' => $a_software['entities_id']);
$a_toinsert[] = "('" . implode("','", $a_tmp) . "')";
}
if (count($a_toinsert) > 0) {
$this->addSoftwareVersionsComputer($a_toinsert);
if (!$no_history) {
foreach ($a_computerinventory['software'] as $a_software) {
$softwares_id = $this->softList[$a_software['name'] . "\$\$\$\$" . $a_software['manufacturers_id']];
$softwareversions_id = $this->softVersionList[strtolower($a_software['version']) . "\$\$\$\$" . $softwares_id];
$changes[0] = '0';
$changes[1] = "";
$changes[2] = $a_software['name'] . " - " . sprintf(__('%1$s (%2$s)'), $a_software['version'], $softwareversions_id);
$this->addPrepareLog($computers_id, 'Computer', 'SoftwareVersion', $changes, Log::HISTORY_INSTALL_SOFTWARE);
$changes[0] = '0';
$changes[1] = "";
$changes[2] = sprintf(__('%1$s (%2$s)'), $computerName, $computers_id);
$this->addPrepareLog($softwareversions_id, 'SoftwareVersion', 'Computer', $changes, Log::HISTORY_INSTALL_SOFTWARE);
}
}
}
} else {
foreach ($a_computerinventory['software'] as $key => $arrayslower) {
if (isset($db_software[$key])) {
unset($a_computerinventory['software'][$key]);
unset($db_software[$key]);
}
}
if (count($a_computerinventory['software']) == 0 && count($db_software) == 0) {
// Nothing to do
} else {
if (count($db_software) > 0) {
// Delete softwares in DB
$a_delete = array();
foreach ($db_software as $idtmp) {
$this->computer_SoftwareVersion->getFromDB($idtmp);
$this->softwareVersion->getFromDB($this->computer_SoftwareVersion->fields['softwareversions_id']);
// $this->computer_SoftwareVersion->delete(array('id'=>$idtmp, '_no_history'=> TRUE), FALSE);
if (!$no_history) {
$changes[0] = '0';
$changes[1] = addslashes($this->computer_SoftwareVersion->getHistoryNameForItem1($this->softwareVersion, 'delete'));
$changes[2] = "";
$this->addPrepareLog($computers_id, 'Computer', 'SoftwareVersion', $changes, Log::HISTORY_UNINSTALL_SOFTWARE);
$changes[0] = '0';
$changes[1] = sprintf(__('%1$s (%2$s)'), $computerName, $computers_id);
$changes[2] = "";
$this->addPrepareLog($idtmp, 'SoftwareVersion', 'Computer', $changes, Log::HISTORY_UNINSTALL_SOFTWARE);
}
}
$query = "DELETE FROM `glpi_computers_softwareversions` " . "WHERE `id` IN ('" . implode("', '", $db_software) . "')";
$DB->query($query);
}
if (count($a_computerinventory['software']) > 0) {
$nb_unicity = count(FieldUnicity::getUnicityFieldsConfig("Software", $entities_id));
$options = array();
if ($nb_unicity == 0) {
$options['disable_unicity_check'] = TRUE;
}
$lastSoftwareid = $this->loadSoftwares($entities_id, $a_computerinventory['software'], $lastSoftwareid);
$queryDBLOCK = "INSERT INTO `glpi_plugin_fusioninventory_dblocksoftwares`\n SET `value`='1'";
$CFG_GLPI["use_log_in_files"] = FALSE;
while (!$DB->query($queryDBLOCK)) {
usleep(100000);
}
$CFG_GLPI["use_log_in_files"] = TRUE;
$this->loadSoftwares($entities_id, $a_computerinventory['software'], $lastSoftwareid);
foreach ($a_computerinventory['software'] as $a_software) {
if (!isset($this->softList[$a_software['name'] . "\$\$\$\$" . $a_software['manufacturers_id']])) {
$this->addSoftware($a_software, $options);
}
}
$queryDBLOCK = "DELETE FROM `glpi_plugin_fusioninventory_dblocksoftwares`\n WHERE `value`='1'";
$DB->query($queryDBLOCK);
$lastSoftwareVid = $this->loadSoftwareVersions($entities_id, $a_computerinventory['software'], $lastSoftwareVid);
$queryDBLOCK = "INSERT INTO `glpi_plugin_fusioninventory_dblocksoftwareversions`\n SET `value`='1'";
$CFG_GLPI["use_log_in_files"] = FALSE;
while (!$DB->query($queryDBLOCK)) {
usleep(100000);
}
$CFG_GLPI["use_log_in_files"] = TRUE;
$this->loadSoftwareVersions($entities_id, $a_computerinventory['software'], $lastSoftwareVid);
foreach ($a_computerinventory['software'] as $a_software) {
$softwares_id = $this->softList[$a_software['name'] . "\$\$\$\$" . $a_software['manufacturers_id']];
if (!isset($this->softVersionList[strtolower($a_software['version']) . "\$\$\$\$" . $softwares_id])) {
$this->addSoftwareVersion($a_software, $softwares_id);
}
}
$queryDBLOCK = "DELETE FROM `glpi_plugin_fusioninventory_dblocksoftwareversions`\n WHERE `value`='1'";
$DB->query($queryDBLOCK);
$a_toinsert = array();
foreach ($a_computerinventory['software'] as $a_software) {
$softwares_id = $this->softList[$a_software['name'] . "\$\$\$\$" . $a_software['manufacturers_id']];
$softwareversions_id = $this->softVersionList[strtolower($a_software['version']) . "\$\$\$\$" . $softwares_id];
$a_tmp = array('computers_id' => $computers_id, 'softwareversions_id' => $softwareversions_id, 'is_dynamic' => 1, 'entities_id' => $a_software['entities_id']);
$a_toinsert[] = "('" . implode("','", $a_tmp) . "')";
}
$this->addSoftwareVersionsComputer($a_toinsert);
if (!$no_history) {
foreach ($a_computerinventory['software'] as $a_software) {
$softwares_id = $this->softList[$a_software['name'] . "\$\$\$\$" . $a_software['manufacturers_id']];
$softwareversions_id = $this->softVersionList[strtolower($a_software['version']) . "\$\$\$\$" . $softwares_id];
$changes[0] = '0';
$changes[1] = "";
$changes[2] = $a_software['name'] . " - " . sprintf(__('%1$s (%2$s)'), $a_software['version'], $softwareversions_id);
$this->addPrepareLog($computers_id, 'Computer', 'SoftwareVersion', $changes, Log::HISTORY_INSTALL_SOFTWARE);
$changes[0] = '0';
$changes[1] = "";
$changes[2] = sprintf(__('%1$s (%2$s)'), $computerName, $computers_id);
$this->addPrepareLog($softwareversions_id, 'SoftwareVersion', 'Computer', $changes, Log::HISTORY_INSTALL_SOFTWARE);
}
}
}
}
}
}
// * Virtualmachines
if ($pfConfig->getValue("import_vm") == 1) {
$db_computervirtualmachine = array();
if ($no_history === FALSE) {
$query = "SELECT `id`, `name`, `uuid`, `virtualmachinesystems_id`\n FROM `glpi_computervirtualmachines`\n WHERE `computers_id` = '{$computers_id}'\n AND `is_dynamic`='1'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['id'];
unset($data['id']);
$data1 = Toolbox::addslashes_deep($data);
$db_computervirtualmachine[$idtmp] = $data1;
}
}
$simplecomputervirtualmachine = array();
if (isset($a_computerinventory['virtualmachine'])) {
foreach ($a_computerinventory['virtualmachine'] as $key => $a_computervirtualmachine) {
$a_field = array('name', 'uuid', 'virtualmachinesystems_id');
foreach ($a_field as $field) {
if (isset($a_computervirtualmachine[$field])) {
$simplecomputervirtualmachine[$key][$field] = $a_computervirtualmachine[$field];
}
}
}
}
foreach ($simplecomputervirtualmachine as $key => $arrays) {
foreach ($db_computervirtualmachine as $keydb => $arraydb) {
if ($arrays == $arraydb) {
$input = array();
$input['id'] = $keydb;
if (isset($a_computerinventory['virtualmachine'][$key]['vcpu'])) {
$input['vcpu'] = $a_computerinventory['virtualmachine'][$key]['vcpu'];
}
if (isset($a_computerinventory['virtualmachine'][$key]['ram'])) {
$input['ram'] = $a_computerinventory['virtualmachine'][$key]['ram'];
}
if (isset($a_computerinventory['virtualmachine'][$key]['virtualmachinetypes_id'])) {
$input['virtualmachinetypes_id'] = $a_computerinventory['virtualmachine'][$key]['virtualmachinetypes_id'];
}
if (isset($a_computerinventory['virtualmachine'][$key]['virtualmachinestates_id'])) {
$input['virtualmachinestates_id'] = $a_computerinventory['virtualmachine'][$key]['virtualmachinestates_id'];
}
$computerVirtualmachine->update($input, !$no_history);
unset($simplecomputervirtualmachine[$key]);
unset($a_computerinventory['virtualmachine'][$key]);
unset($db_computervirtualmachine[$keydb]);
break;
}
}
}
if (count($a_computerinventory['virtualmachine']) == 0 && count($db_computervirtualmachine) == 0) {
// Nothing to do
} else {
if (count($db_computervirtualmachine) != 0) {
// Delete virtualmachine in DB
foreach ($db_computervirtualmachine as $idtmp => $data) {
$computerVirtualmachine->delete(array('id' => $idtmp), 1);
}
}
if (count($a_computerinventory['virtualmachine']) != 0) {
foreach ($a_computerinventory['virtualmachine'] as $a_virtualmachine) {
$a_virtualmachine['computers_id'] = $computers_id;
$computerVirtualmachine->add($a_virtualmachine, array(), !$no_history);
}
}
}
}
if ($pfConfig->getValue("create_vm") == 1) {
// Create VM based on information of section VIRTUALMACHINE
$pfAgent = new PluginFusioninventoryAgent();
// Use ComputerVirtualMachine::getUUIDRestrictRequest to get existant
// vm in computer list
$computervm = new Computer();
if (isset($a_computerinventory['virtualmachine_creation']) && is_array($a_computerinventory['virtualmachine_creation'])) {
foreach ($a_computerinventory['virtualmachine_creation'] as $a_vm) {
// Define location of physical computer (host)
$a_vm['locations_id'] = $computer->fields['locations_id'];
if (isset($a_vm['uuid']) && $a_vm['uuid'] != '') {
$query = "SELECT * FROM `glpi_computers`\n WHERE `uuid` " . ComputerVirtualMachine::getUUIDRestrictRequest($a_vm['uuid']) . "\n LIMIT 1";
// TODO: Add entity search
$result = $DB->query($query);
$computers_vm_id = 0;
while ($data = $DB->fetch_assoc($result)) {
$computers_vm_id = $data['id'];
}
if ($computers_vm_id == 0) {
// Add computer
$a_vm['entities_id'] = $computer->fields['entities_id'];
$computers_vm_id = $computervm->add($a_vm, array(), !$no_history);
// Manage networks
$this->manageNetworkPort($a_vm['networkport'], $computers_vm_id, FALSE);
} else {
if ($pfAgent->getAgentWithComputerid($computers_vm_id) === FALSE) {
// Update computer
$a_vm['id'] = $computers_vm_id;
$computervm->update($a_vm, !$no_history);
// Manage networks
$this->manageNetworkPort($a_vm['networkport'], $computers_vm_id, FALSE);
}
}
}
}
}
}
// * ComputerDisk
if ($pfConfig->getValue("import_volume") != 0) {
$db_computerdisk = array();
if ($no_history === FALSE) {
$query = "SELECT `id`, `name`, `device`, `mountpoint`\n FROM `glpi_computerdisks`\n WHERE `computers_id` = '" . $computers_id . "'\n AND `is_dynamic`='1'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['id'];
unset($data['id']);
$data1 = Toolbox::addslashes_deep($data);
$data2 = array_map('strtolower', $data1);
$db_computerdisk[$idtmp] = $data2;
}
}
$simplecomputerdisk = array();
foreach ($a_computerinventory['computerdisk'] as $key => $a_computerdisk) {
$a_field = array('name', 'device', 'mountpoint');
foreach ($a_field as $field) {
if (isset($a_computerdisk[$field])) {
$simplecomputerdisk[$key][$field] = $a_computerdisk[$field];
}
}
}
foreach ($simplecomputerdisk as $key => $arrays) {
$arrayslower = array_map('strtolower', $arrays);
foreach ($db_computerdisk as $keydb => $arraydb) {
if ($arrayslower == $arraydb) {
$input = array();
$input['id'] = $keydb;
if (isset($a_computerinventory['computerdisk'][$key]['filesystems_id'])) {
$input['filesystems_id'] = $a_computerinventory['computerdisk'][$key]['filesystems_id'];
}
$input['totalsize'] = $a_computerinventory['computerdisk'][$key]['totalsize'];
$input['freesize'] = $a_computerinventory['computerdisk'][$key]['freesize'];
$input['_no_history'] = TRUE;
$computerDisk->update($input, FALSE);
unset($simplecomputerdisk[$key]);
unset($a_computerinventory['computerdisk'][$key]);
unset($db_computerdisk[$keydb]);
break;
}
}
}
if (count($a_computerinventory['computerdisk']) == 0 and count($db_computerdisk) == 0) {
// Nothing to do
} else {
if (count($db_computerdisk) != 0) {
// Delete computerdisk in DB
foreach ($db_computerdisk as $idtmp => $data) {
$computerDisk->delete(array('id' => $idtmp), 1);
}
}
if (count($a_computerinventory['computerdisk']) != 0) {
foreach ($a_computerinventory['computerdisk'] as $a_computerdisk) {
$a_computerdisk['computers_id'] = $computers_id;
$a_computerdisk['is_dynamic'] = 1;
$a_computerdisk['_no_history'] = $no_history;
$computerDisk->add($a_computerdisk, array(), !$no_history);
}
}
}
}
// * Networkports
if ($pfConfig->getValue("component_networkcard") != 0) {
// Get port from unmanaged device if exist
$this->manageNetworkPort($a_computerinventory['networkport'], $computers_id, $no_history);
}
// * Antivirus
$db_antivirus = array();
if ($no_history === FALSE) {
$query = "SELECT `id`, `name`, `version`\n FROM `glpi_plugin_fusioninventory_inventorycomputerantiviruses`\n WHERE `computers_id` = '{$computers_id}'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['id'];
unset($data['id']);
$data1 = Toolbox::addslashes_deep($data);
$data2 = array_map('strtolower', $data1);
$db_antivirus[$idtmp] = $data2;
}
}
$simpleantivirus = array();
foreach ($a_computerinventory['antivirus'] as $key => $a_antivirus) {
$a_field = array('name', 'version');
foreach ($a_field as $field) {
if (isset($a_antivirus[$field])) {
$simpleantivirus[$key][$field] = $a_antivirus[$field];
}
}
}
foreach ($simpleantivirus as $key => $arrays) {
$arrayslower = array_map('strtolower', $arrays);
foreach ($db_antivirus as $keydb => $arraydb) {
if ($arrayslower == $arraydb) {
$input = array();
$input = $a_computerinventory['antivirus'][$key];
$input['id'] = $keydb;
$pfInventoryComputerAntivirus->update($input, !$no_history);
unset($simpleantivirus[$key]);
unset($a_computerinventory['antivirus'][$key]);
unset($db_antivirus[$keydb]);
break;
}
}
}
if (count($a_computerinventory['antivirus']) == 0 and count($db_antivirus) == 0) {
// Nothing to do
} else {
if (count($db_antivirus) != 0) {
foreach ($db_antivirus as $idtmp => $data) {
$pfInventoryComputerAntivirus->delete(array('id' => $idtmp), 1);
}
}
if (count($a_computerinventory['antivirus']) != 0) {
foreach ($a_computerinventory['antivirus'] as $a_antivirus) {
$a_antivirus['computers_id'] = $computers_id;
$pfInventoryComputerAntivirus->add($a_antivirus, array(), !$no_history);
}
}
}
// * Licenseinfo
$db_licenseinfo = array();
if ($no_history === FALSE) {
$query = "SELECT `id`, `name`, `fullname`, `serial`\n FROM `glpi_plugin_fusioninventory_computerlicenseinfos`\n WHERE `computers_id` = '{$computers_id}'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['id'];
unset($data['id']);
$data1 = Toolbox::addslashes_deep($data);
$data2 = array_map('strtolower', $data1);
$db_licenseinfo[$idtmp] = $data2;
}
}
foreach ($a_computerinventory['licenseinfo'] as $key => $arrays) {
$arrayslower = array_map('strtolower', $arrays);
foreach ($db_licenseinfo as $keydb => $arraydb) {
if ($arrayslower == $arraydb) {
unset($a_computerinventory['licenseinfo'][$key]);
unset($db_licenseinfo[$keydb]);
break;
}
}
}
if (count($a_computerinventory['licenseinfo']) == 0 and count($db_licenseinfo) == 0) {
// Nothing to do
} else {
if (count($db_licenseinfo) != 0) {
foreach ($db_licenseinfo as $idtmp => $data) {
$pfComputerLicenseInfo->delete(array('id' => $idtmp), 1);
}
}
if (count($a_computerinventory['licenseinfo']) != 0) {
foreach ($a_computerinventory['licenseinfo'] as $a_licenseinfo) {
$a_licenseinfo['computers_id'] = $computers_id;
$pfComputerLicenseInfo->add($a_licenseinfo, array(), !$no_history);
}
}
}
// * Batteries
/* Standby, see ticket http://forge.fusioninventory.org/issues/1907
$db_batteries = array();
if ($no_history === FALSE) {
$query = "SELECT `id`, `name`, `serial`
FROM `glpi_plugin_fusioninventory_inventorycomputerbatteries`
WHERE `computers_id` = '$computers_id'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['id'];
unset($data['id']);
$data = Toolbox::addslashes_deep($data);
$data = array_map('strtolower', $data);
$db_batteries[$idtmp] = $data;
}
}
$simplebatteries = array();
foreach ($a_computerinventory['batteries'] as $key=>$a_batteries) {
$a_field = array('name', 'serial');
foreach ($a_field as $field) {
if (isset($a_batteries[$field])) {
$simplebatteries[$key][$field] = $a_batteries[$field];
}
}
}
foreach ($simplebatteries as $key => $arrays) {
$arrayslower = array_map('strtolower', $arrays);
foreach ($db_batteries as $keydb => $arraydb) {
if ($arrayslower == $arraydb) {
$input = array();
$input = $a_computerinventory['batteries'][$key];
$input['id'] = $keydb;
$pfInventoryComputerBatteries->update($input);
unset($simplebatteries[$key]);
unset($a_computerinventory['batteries'][$key]);
unset($db_batteries[$keydb]);
break;
}
}
}
if (count($a_computerinventory['batteries']) == 0
AND count($db_batteries) == 0) {
// Nothing to do
} else {
if (count($db_batteries) != 0) {
foreach ($db_batteries as $idtmp => $data) {
$pfInventoryComputerBatteries->delete(array('id'=>$idtmp), 1);
}
}
if (count($a_computerinventory['batteries']) != 0) {
foreach($a_computerinventory['batteries'] as $a_batteries) {
$a_batteries['computers_id'] = $computers_id;
$pfInventoryComputerBatteries->add($a_batteries, array(), FALSE);
}
}
}
*/
$entities_id = $_SESSION["plugin_fusioninventory_entity"];
// * Monitors
$rule = new PluginFusioninventoryInventoryRuleImportCollection();
$a_monitors = array();
foreach ($a_computerinventory['monitor'] as $key => $arrays) {
$input = array();
$input['itemtype'] = "Monitor";
$input['name'] = $arrays['name'];
$input['serial'] = $arrays['serial'];
$data = $rule->processAllRules($input, array(), array('class' => $this, 'return' => TRUE));
if (isset($data['found_equipment'])) {
if ($data['found_equipment'][0] == 0) {
// add monitor
$arrays['entities_id'] = $entities_id;
$a_monitors[] = $monitor->add($arrays);
} else {
$a_monitors[] = $data['found_equipment'][0];
}
}
}
$db_monitors = array();
$query = "SELECT `glpi_monitors`.`id`,\n `glpi_computers_items`.`id` as link_id\n FROM `glpi_computers_items`\n LEFT JOIN `glpi_monitors` ON `items_id`=`glpi_monitors`.`id`\n WHERE `itemtype`='Monitor'\n AND `computers_id`='" . $computers_id . "'\n AND `entities_id`='" . $entities_id . "'\n AND `glpi_computers_items`.`is_dynamic`='1'\n AND `glpi_monitors`.`is_global`='0'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['link_id'];
unset($data['link_id']);
$db_monitors[$idtmp] = $data['id'];
}
if (count($db_monitors) == 0) {
foreach ($a_monitors as $monitors_id) {
$input = array();
$input['computers_id'] = $computers_id;
$input['itemtype'] = 'Monitor';
$input['items_id'] = $monitors_id;
$input['is_dynamic'] = 1;
$input['_no_history'] = $no_history;
$computer_Item->add($input, array(), !$no_history);
}
} else {
// Check all fields from source:
foreach ($a_monitors as $key => $monitors_id) {
foreach ($db_monitors as $keydb => $monits_id) {
if ($monitors_id == $monits_id) {
unset($a_monitors[$key]);
unset($db_monitors[$keydb]);
break;
}
}
}
if (count($a_monitors) == 0 and count($db_monitors) == 0) {
// Nothing to do
} else {
if (count($db_monitors) != 0) {
// Delete monitors links in DB
foreach ($db_monitors as $idtmp => $monits_id) {
$computer_Item->delete(array('id' => $idtmp), 1);
}
}
if (count($a_monitors) != 0) {
foreach ($a_monitors as $key => $monitors_id) {
$input = array();
$input['computers_id'] = $computers_id;
$input['itemtype'] = 'Monitor';
$input['items_id'] = $monitors_id;
$input['is_dynamic'] = 1;
$input['_no_history'] = $no_history;
$computer_Item->add($input, array(), !$no_history);
}
}
}
}
// * Printers
$rule = new PluginFusioninventoryInventoryRuleImportCollection();
$a_printers = array();
foreach ($a_computerinventory['printer'] as $key => $arrays) {
$input = array();
$input['itemtype'] = "Printer";
$input['name'] = $arrays['name'];
$input['serial'] = $arrays['serial'];
$data = $rule->processAllRules($input, array(), array('class' => $this, 'return' => TRUE));
if (isset($data['found_equipment'])) {
if ($data['found_equipment'][0] == 0) {
// add printer
$arrays['entities_id'] = $entities_id;
$a_printers[] = $printer->add($arrays);
} else {
$a_printers[] = $data['found_equipment'][0];
}
}
}
$db_printers = array();
$query = "SELECT `glpi_printers`.`id`, `glpi_computers_items`.`id` as link_id\n FROM `glpi_computers_items`\n LEFT JOIN `glpi_printers` ON `items_id`=`glpi_printers`.`id`\n WHERE `itemtype`='Printer'\n AND `computers_id`='" . $computers_id . "'\n AND `entities_id`='" . $entities_id . "'\n AND `glpi_computers_items`.`is_dynamic`='1'\n AND `glpi_printers`.`is_global`='0'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['link_id'];
unset($data['link_id']);
$db_printers[$idtmp] = $data['id'];
}
if (count($db_printers) == 0) {
foreach ($a_printers as $printers_id) {
$input['entities_id'] = $entities_id;
$input['computers_id'] = $computers_id;
$input['itemtype'] = 'Printer';
$input['items_id'] = $printers_id;
$input['is_dynamic'] = 1;
$input['_no_history'] = $no_history;
$computer_Item->add($input, array(), !$no_history);
}
} else {
// Check all fields from source:
foreach ($a_printers as $key => $printers_id) {
foreach ($db_printers as $keydb => $prints_id) {
if ($printers_id == $prints_id) {
unset($a_printers[$key]);
unset($db_printers[$keydb]);
break;
}
}
}
if (count($a_printers) == 0 and count($db_printers) == 0) {
// Nothing to do
} else {
if (count($db_printers) != 0) {
// Delete printers links in DB
foreach ($db_printers as $idtmp => $data) {
$computer_Item->delete(array('id' => $idtmp), 1);
}
}
if (count($a_printers) != 0) {
foreach ($a_printers as $printers_id) {
$input['entities_id'] = $entities_id;
$input['computers_id'] = $computers_id;
$input['itemtype'] = 'Printer';
$input['items_id'] = $printers_id;
$input['is_dynamic'] = 1;
$input['_no_history'] = $no_history;
$computer_Item->add($input, array(), !$no_history);
}
}
}
}
// * Peripheral
$rule = new PluginFusioninventoryInventoryRuleImportCollection();
$a_peripherals = array();
foreach ($a_computerinventory['peripheral'] as $key => $arrays) {
$input = array();
$input['itemtype'] = "Peripheral";
$input['name'] = $arrays['name'];
$input['serial'] = $arrays['serial'];
$data = $rule->processAllRules($input, array(), array('class' => $this, 'return' => TRUE));
if (isset($data['found_equipment'])) {
if ($data['found_equipment'][0] == 0) {
// add peripheral
$arrays['entities_id'] = $entities_id;
$a_peripherals[] = $peripheral->add($arrays);
} else {
$a_peripherals[] = $data['found_equipment'][0];
}
}
}
$db_peripherals = array();
$query = "SELECT `glpi_peripherals`.`id`, `glpi_computers_items`.`id` as link_id\n FROM `glpi_computers_items`\n LEFT JOIN `glpi_peripherals` ON `items_id`=`glpi_peripherals`.`id`\n WHERE `itemtype`='Peripheral'\n AND `computers_id`='" . $computers_id . "'\n AND `entities_id`='" . $entities_id . "'\n AND `glpi_computers_items`.`is_dynamic`='1'\n AND `glpi_peripherals`.`is_global`='0'";
$result = $DB->query($query);
while ($data = $DB->fetch_assoc($result)) {
$idtmp = $data['link_id'];
unset($data['link_id']);
$db_peripherals[$idtmp] = $data['id'];
}
if (count($db_peripherals) == 0) {
foreach ($a_peripherals as $peripherals_id) {
$input = array();
$input['computers_id'] = $computers_id;
$input['itemtype'] = 'Peripharal';
$input['items_id'] = $peripherals_id;
$input['is_dynamic'] = 1;
$input['_no_history'] = $no_history;
$computer_Item->add($input, array(), !$no_history);
}
} else {
// Check all fields from source:
foreach ($a_peripherals as $key => $peripherals_id) {
foreach ($db_peripherals as $keydb => $periphs_id) {
if ($peripherals_id == $periphs_id) {
unset($a_peripherals[$key]);
unset($db_peripherals[$keydb]);
break;
}
}
}
if (count($a_peripherals) == 0 and count($db_peripherals) == 0) {
// Nothing to do
} else {
if (count($db_peripherals) != 0) {
// Delete peripherals links in DB
foreach ($db_peripherals as $idtmp => $data) {
$computer_Item->delete(array('id' => $idtmp), 1);
}
}
if (count($a_peripherals) != 0) {
foreach ($a_peripherals as $peripherals_id) {
$input = array();
$input['computers_id'] = $computers_id;
$input['itemtype'] = 'Peripharal';
$input['items_id'] = $peripherals_id;
$input['is_dynamic'] = 1;
$input['_no_history'] = $no_history;
$computer_Item->add($input, array(), !$no_history);
}
}
}
}
// * storage
// Manage by uuid to correspond with GLPI data
// $db_storage = array();
// if ($no_history === FALSE) {
// $query = "SELECT `id`, `uuid` FROM ".
// "`glpi_plugin_fusioninventory_inventorycomputerstorages`
// WHERE `computers_id` = '$computers_id'";
// $result = $DB->query($query);
// while ($data = $DB->fetch_assoc($result)) {
// $idtmp = $data['id'];
// unset($data['id']);
// $data = Toolbox::addslashes_deep($data);
// $data = array_map('strtolower', $data);
// $db_storage[$idtmp] = $data;
// }
// }
// if (count($db_storage) == 0) {
// $a_links = array();
// $a_uuid = array();
// foreach ($a_computerinventory['storage'] as $a_storage) {
// $a_storage['computers_id'] = $computers_id;
// $insert_id = $pfInventoryComputerStorage->add($a_storage);
// if (isset($a_storage['uuid'])) {
// $a_uuid[$a_storage['uuid']] = $insert_id;
// if (isset($a_storage['uuid_link'])) {
// if (is_array($a_storage['uuid_link'])) {
// $a_links[$insert_id] = $a_storage['uuid_link'];
// } else {
// $a_links[$insert_id][] = $a_storage['uuid_link'];
// }
// }
// }
// }
// foreach ($a_links as $id=>$data) {
// foreach ($data as $num=>$uuid) {
// $a_links[$id][$num] = $a_uuid[$uuid];
// }
// }
// foreach ($a_links as $id=>$data) {
// foreach ($data as $id2) {
// $input = array();
// $input['plugin_fusioninventory_inventorycomputerstorages_id_1'] = $id;
// $input['plugin_fusioninventory_inventorycomputerstorages_id_2'] = $id2;
// $pfInventoryComputerStorage_Storage->add($input);
// }
// }
// } else {
// // Check only field *** from source:
//
// }
$this->addLog();
}
/**
* Hook after updates
*
* @param $parm
* @return nothing
*
**/
function plugin_item_update_fusioninventory($parm)
{
if (isset($_SESSION["glpiID"]) and $_SESSION["glpiID"] != '') {
// manual task
$plugin = new Plugin();
if ($plugin->isActivated('fusioninventory')) {
// lock fields which have been updated
$type = $parm['type'];
$ID = $parm['ID'];
$fieldsToLock = $parm['updates'];
$lockables = PluginFusioninventoryLockable::getLockableFields('', $type);
$fieldsToLock = array_intersect($fieldsToLock, $lockables);
// do not lock unlockable fields
PluginFusioninventoryLock::addLocks($type, $ID, $fieldsToLock);
}
}
}
/**
* Display informations about computer (bios...)
*
* @param type $computers_id
*/
static function showInfo($item)
{
global $CFG_GLPI;
// Manage locks pictures
PluginFusioninventoryLock::showLockIcon('Computer');
$pfInventoryComputerComputer = new PluginFusioninventoryInventoryComputerComputer();
$a_computerextend = current($pfInventoryComputerComputer->find("`computers_id`='" . $item->getID() . "'", "", 1));
if (empty($a_computerextend)) {
return;
}
echo '<table class="tab_glpi" width="100%">';
echo '<tr>';
echo '<th colspan="2">' . __('FusionInventory', 'fusioninventory') . '</th>';
echo '</tr>';
echo '<tr class="tab_bg_1">';
echo '<td>';
echo __('Last inventory', 'fusioninventory');
echo '</td>';
echo '<td>';
echo Html::convDateTime($a_computerextend['last_fusioninventory_update']);
echo '</td>';
echo '</tr>';
if ($a_computerextend['remote_addr'] != '') {
echo '<tr class="tab_bg_1">';
echo '<td>' . __('Public contact address', 'fusioninventory') . '</td>';
echo '<td>' . $a_computerextend['remote_addr'] . '</td>';
echo '</tr>';
}
$pfAgent = new PluginFusioninventoryAgent();
$pfAgent->showInfoForComputer($item->getID());
if ($a_computerextend['bios_date'] != '') {
echo '<tr class="tab_bg_1">';
echo '<td>' . __('BIOS date', 'fusioninventory') . '</td>';
echo '<td>' . Html::convDate($a_computerextend['bios_date']) . '</td>';
echo '</tr>';
}
if ($a_computerextend['bios_version'] != '') {
echo '<tr class="tab_bg_1">';
echo '<td>' . __('BIOS version', 'fusioninventory') . '</td>';
echo '<td>' . $a_computerextend['bios_version'] . '</td>';
echo '</tr>';
}
if ($a_computerextend['bios_manufacturers_id'] > 0) {
echo '<tr class="tab_bg_1">';
echo '<td>' . __('Manufacturer') . ' :</td>';
echo '<td>';
echo Dropdown::getDropdownName("glpi_manufacturers", $a_computerextend['bios_manufacturers_id']);
echo '</td>';
echo '</tr>';
}
if ($a_computerextend['plugin_fusioninventory_computerarchs_id'] != '') {
echo '<tr class="tab_bg_1">';
echo "<td>" . __('Architecture', 'fusioninventory') . "</td>";
echo '<td>';
echo Dropdown::getDropdownName('glpi_plugin_fusioninventory_computerarchs', $a_computerextend['plugin_fusioninventory_computerarchs_id']);
echo '</td>';
echo '</tr>';
}
if ($a_computerextend['operatingsystem_installationdate'] != '') {
echo '<tr class="tab_bg_1">';
echo "<td>" . __('Operating system') . " - " . __('Installation') . " (" . strtolower(__('Date')) . ")</td>";
echo '<td>' . Html::convDate($a_computerextend['operatingsystem_installationdate']) . '</td>';
echo '</tr>';
}
if ($a_computerextend['winowner'] != '') {
echo '<tr class="tab_bg_1">';
echo '<td>' . __('Owner', 'fusioninventory') . '</td>';
echo '<td>' . $a_computerextend['winowner'] . '</td>';
echo '</tr>';
}
if ($a_computerextend['wincompany'] != '') {
echo '<tr class="tab_bg_1">';
echo '<td>' . __('Company', 'fusioninventory') . '</td>';
echo '<td>' . $a_computerextend['wincompany'] . '</td>';
echo '</tr>';
}
if ($a_computerextend['oscomment'] != '') {
echo '<tr class="tab_bg_1">';
echo "<td>" . __('Comments') . "</td>";
echo '<td>' . $a_computerextend['oscomment'] . '</td>';
echo '</tr>';
}
// Display automatic entity transfer
if (Session::isMultiEntitiesMode()) {
echo '<tr class="tab_bg_1">';
echo '<td>' . __('Automatic entity transfer', 'fusioninventory') . '</td>';
echo '<td>';
$pfEntity = new PluginFusioninventoryEntity();
if ($pfEntity->getValue('transfers_id_auto', $item->fields['entities_id']) == 0) {
echo __('No, locked (by entity configuration)', 'fusioninventory');
} else {
if ($a_computerextend['is_entitylocked'] == 1) {
echo __('No, locked manually', 'fusioninventory');
echo " [ <a href='" . $CFG_GLPI['root_doc'] . "/plugins/fusioninventory/front/computerentitylock.form.php?id=" . $a_computerextend['id'] . "&lock=0'>" . __('Unlock it', 'fusioninventory') . "</a> ]";
} else {
echo __('Yes');
echo " [ <a href='" . $CFG_GLPI['root_doc'] . "/plugins/fusioninventory/front/computerentitylock.form.php?id=" . $a_computerextend['id'] . "&lock=1'>" . __('Lock it', 'fusioninventory') . "</a> ]";
}
}
echo '</td>';
echo '</tr>';
}
echo '</table>';
}
/**
* Display informations about networkequipment (automatic inventory)
*
* @param type $networkequipments_id
*/
static function showInfo($item)
{
// Manage locks pictures
PluginFusioninventoryLock::showLockIcon('NetworkEquipment');
$pfNetworkEquipment = new PluginFusioninventoryNetworkEquipment();
$a_networkequipmentextend = current($pfNetworkEquipment->find("`networkequipments_id`='" . $item->getID() . "'", "", 1));
if (empty($a_networkequipmentextend)) {
return;
}
echo '<table class="tab_glpi" width="100%">';
echo '<tr>';
echo '<th colspan="2">' . __('FusionInventory', 'fusioninventory') . '</th>';
echo '</tr>';
echo '<tr class="tab_bg_1">';
echo '<td>';
echo __('Last inventory', 'fusioninventory');
echo '</td>';
echo '<td>';
echo Html::convDateTime($a_networkequipmentextend['last_fusioninventory_update']);
echo '</td>';
echo '</tr>';
if ($a_networkequipmentextend['uptime'] != '') {
echo '<tr class="tab_bg_1">';
echo '<td>' . __('Uptime', 'fusioninventory') . '</td>';
echo '<td>';
$sysUpTime = $a_networkequipmentextend['uptime'];
$day = 0;
$hour = 0;
$minute = 0;
$sec = 0;
$ticks = 0;
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> " . __('day(s)', 'fusioninventory') . " ";
echo "<b>{$hour}</b> " . __('hour(s)', 'fusioninventory') . " ";
echo "<b>{$minute}</b> " . __('Minute(s)', 'fusioninventory') . " ";
echo " " . __('and') . " <b>{$sec}</b> " . __('sec(s)', 'fusioninventory') . " ";
echo '</td>';
echo '</tr>';
}
echo '</table>';
}
function import_netdiscovery($p_xml, $agentKey)
{
global $DB, $LANG;
$test = '';
$p_criteria = array();
$walks = new PluginFusioninventoryWalk();
$ptap = new PluginFusioninventoryAgentsProcesses();
$pta = new PluginFusioninventoryAgents();
$config_discovery = new PluginFusioninventoryConfig();
$np = new Netport();
$ptud = new PluginFusioninventoryUnknownDevice();
if (isset($p_xml->AGENT->START)) {
$ptap->updateProcess($p_xml->PROCESSNUMBER, array('start_time_discovery' => date("Y-m-d H:i:s")));
} else {
if (isset($p_xml->AGENT->END)) {
$ptap->updateProcess($p_xml->PROCESSNUMBER, array('end_time_discovery' => date("Y-m-d H:i:s")));
} else {
if (isset($p_xml->AGENT->EXIT)) {
$ptap->endProcess($p_xml->PROCESSNUMBER, date("Y-m-d H:i:s"));
} else {
if (isset($p_xml->AGENT->NBIP)) {
$ptap->updateProcess($p_xml->PROCESSNUMBER, array('discovery_nb_ip' => $p_xml->AGENT->NBIP));
}
}
}
}
if (isset($p_xml->AGENT->AGENTVERSION)) {
$agent = $pta->InfosByKey($agentKey);
$agent['fusioninventory_agent_version'] = $p_xml->AGENT->AGENTVERSION;
$agent['last_agent_update'] = date("Y-m-d H:i:s");
$pta->update($agent);
}
$walkdata = '';
$count_discovery_devices = 0;
foreach ($p_xml->DEVICE as $discovery) {
$count_discovery_devices++;
}
$ptap->updateProcess($_SESSION['glpi_plugin_fusioninventory_processnumber'], array('discovery_nb_found' => $count_discovery_devices));
foreach ($p_xml->DEVICE as $discovery) {
if ($discovery->MODELSNMP != "") {
$query = "SELECT *\n FROM `glpi_plugin_fusioninventory_model_infos`\n WHERE `discovery_key`='" . $discovery->MODELSNMP . "'\n LIMIT 0,1;";
$result = $DB->query($query);
$data = $DB->fetch_assoc($result);
$FK_model = $data['ID'];
} else {
$FK_model = 0;
}
$discovery->MAC = strtolower($discovery->MAC);
if (empty($FK_model)) {
$FK_model = 0;
}
unset($p_criteria);
$p_criteria['ip'] = $discovery->IP;
if (!empty($discovery->NETBIOSNAME)) {
$p_criteria['name'] = $discovery->NETBIOSNAME;
} else {
if (!empty($discovery->SNMPHOSTNAME)) {
$p_criteria['name'] = $discovery->SNMPHOSTNAME;
}
}
$p_criteria['serial'] = $discovery->SERIAL;
$p_criteria['macaddr'] = $discovery->MAC;
$discovery_criteria = PluginFusioninventoryDiscovery::criteria($p_criteria);
if (!$discovery_criteria) {
$ptap->updateProcess($_SESSION['glpi_plugin_fusioninventory_processnumber'], array('discovery_nb_import' => '1'));
// Add in unknown device
$ptud->getEmpty();
if (!empty($discovery->NETBIOSNAME)) {
$ptud->fields['name'] = $discovery->NETBIOSNAME;
} else {
if (!empty($discovery->SNMPHOSTNAME)) {
$ptud->fields['name'] = $discovery->SNMPHOSTNAME;
}
}
$ptud->fields['dnsname'] = $discovery->DNSHOSTNAME;
$ptud->fields['FK_entities'] = $discovery->ENTITY;
$ptud->fields['serial'] = $discovery->SERIAL;
$ptud->fields['contact'] = $discovery->USERSESSION;
if (!empty($discovery->WORKGROUP)) {
$ptud->fields['domain'] = Dropdown::importExternal("Domain", $discovery->WORKGROUP, $discovery->ENTITY);
}
$ptud->fields['comments'] = $discovery->DESCRIPTION;
$ptud->fields['type'] = $discovery->TYPE;
$ptud->fields['FK_model_infos'] = $FK_model;
$ptud->fields['FK_snmp_connection'] = $discovery->AUTHSNMP;
if ($discovery->AUTHSNMP != "") {
$ptud->fields['snmp'] = 1;
}
$ptud->fields['location'] = 0;
$ptud->fields['deleted'] = 0;
if ($ptud->fields['domain'] == '') {
$ptud->fields['domain'] = 0;
}
if ($ptud->fields['type'] == '') {
$ptud->fields['type'] = 0;
}
if ($ptud->fields['snmp'] == '') {
$ptud->fields['snmp'] = 0;
}
if ($ptud->fields['FK_model_infos'] == '') {
$ptud->fields['FK_model_infos'] = 0;
}
if ($ptud->fields['FK_snmp_connection'] == '') {
$ptud->fields['FK_snmp_connection'] = 0;
}
if ($ptud->fields['accepted'] == '') {
$ptud->fields['accepted'] = 0;
}
$explodeprocess = explode("/", $_SESSION['glpi_plugin_fusioninventory_processnumber']);
$ptud->fields['FK_agent'] = intval($explodeprocess[1]);
$ptud->fields['hub'] = 0;
$data = $ptud->fields;
unset($data['ID']);
$newID = $ptud->add($data);
unset($data);
// Add networking_port
$port_add["on_device"] = $newID;
$port_add["device_type"] = PLUGIN_FUSIONINVENTORY_MAC_UNKNOWN;
$port_add["ifaddr"] = $discovery->IP;
$port_add['ifmac'] = $discovery->MAC;
$port_add['name'] = $discovery->NETPORTVENDOR;
$port_ID = $np->add($port_add);
unset($port_add);
} else {
# Update device
//echo "discovery_criteria :".$discovery_criteria;
$a_device = explode("||", $discovery_criteria);
// $a_device[0] == id, $a_device[1] = type
$ci = new commonitem();
$ci->getFromDB($a_device[1], $a_device[0]);
$a_lockable = PluginFusioninventoryLock::getLockFields($a_device[1], $a_device[0]);
$data = array();
$data['ID'] = $ci->getField('ID');
if ($a_device[1] == PLUGIN_FUSIONINVENTORY_MAC_UNKNOWN) {
$data['FK_snmp_connection'] = 0;
if ($ci->getField('name') && !in_array('name', $a_lockable)) {
if (!empty($discovery->NETBIOSNAME)) {
$data['name'] = $discovery->NETBIOSNAME;
} else {
if (!empty($discovery->SNMPHOSTNAME)) {
$data['name'] = $discovery->SNMPHOSTNAME;
}
}
}
if ($ci->getField('dnsname') && !in_array('dnsname', $a_lockable)) {
$data['dnsname'] = $discovery->DNSHOSTNAME;
}
if ($ci->getField('FK_entities') && !in_array('FK_entities', $a_lockable)) {
$data['FK_entities'] = $discovery->ENTITY;
}
if ($ci->getField('serial') && !in_array('serial', $a_lockable)) {
$data['serial'] = $discovery->SERIAL;
}
if ($ci->getField('contact') && !in_array('contact', $a_lockable)) {
$data['contact'] = $discovery->USERSESSION;
}
if ($ci->getField('domain') && !in_array('domain', $a_lockable)) {
$data['domain'] = 0;
if (!empty($discovery->WORKGROUP)) {
$data['domain'] = Dropdown::importExternal("Domain", $discovery->WORKGROUP, $discovery->ENTITY);
}
}
if ($ci->getField('FK_snmp_connection') && !in_array('FK_snmp_connection', $a_lockable)) {
$data['FK_snmp_connection'] = $discovery->AUTHSNMP;
}
if ($ci->getField('snmp') && !in_array('snmp', $a_lockable)) {
$data['snmp'] = 0;
if ($discovery->AUTHSNMP != "") {
$data['snmp'] = 1;
}
}
$data['type'] = $discovery->TYPE;
$explodeprocess = explode("/", $_SESSION['glpi_plugin_fusioninventory_processnumber']);
$data['FK_agent'] = intval($explodeprocess[1]);
}
if ($ci->getField('FK_model_infos') && !in_array('FK_model_infos', $a_lockable)) {
$data['FK_model_infos'] = $FK_model;
}
if ($ci->getField('comments') && !in_array('comments', $a_lockable)) {
$data['comments'] = $discovery->DESCRIPTION;
}
if ($a_device[1] == NETWORKING_TYPE) {
if (!in_array('ifaddr', $a_lockable)) {
$data["ifaddr"] = $discovery->IP;
}
if (!in_array('ifmac', $a_lockable)) {
$data['ifmac'] = $discovery->MAC;
}
} else {
// TODO: manage ports
$np = new Netport();
$query = "SELECT ID FROM glpi_networking_ports\n WHERE (on_device = '" . $a_device[0] . "' AND device_type = '" . $a_device[1] . "')\n AND `ifaddr` NOT IN ('', '127.0.0.1')\n ORDER BY name, logical_number";
if ($result = $DB->query($query)) {
if ($DB->numrows($result) == 1) {
$data2 = $DB->fetch_assoc($result);
$np->getFromDB($data2["ID"]);
$port = array();
$port['ID'] = $data2["ID"];
$port["ifaddr"] = $discovery->IP;
$port['ifmac'] = $discovery->MAC;
$port['name'] = $discovery->NETPORTVENDOR;
$np->update($port);
} else {
if ($DB->numrows($result) > 1) {
$ptae = new PluginFusioninventoryAgentsErrors();
$error_input['ID'] = $a_device[0];
$error_input['TYPE'] = $a_device[1];
$error_input['MESSAGE'] = 'Unable to determine network port of device to update with values : ' . $discovery->IP . '(ip),
' . $discovery->MAC . '(mac), ' . $discovery->NETPORTVENDOR . '(name)';
$error_input['agent_type'] = 'NETDISCOVERY';
$ptae->addError($error_input);
}
}
}
}
$ci->obj->update($data);
$ptap->updateProcess($_SESSION['glpi_plugin_fusioninventory_processnumber'], array('discovery_nb_exists' => '1'));
}
}
}
/**
* Hook after updates
*
* @param $parm
* @return nothing
*
**/
function plugin_item_update_fusioninventory($parm)
{
if (isset($_SESSION["glpiID"]) && $_SESSION["glpiID"] != '' && !isset($_SESSION['glpi_fusionionventory_nolock'])) {
// manual task
$plugin = new Plugin();
if ($plugin->isActivated('fusioninventory')) {
// lock fields which have been updated
$type = get_class($parm);
$id = $parm->getField('id');
$fieldsToLock = $parm->updates;
PluginFusioninventoryLock::addLocks($type, $id, $fieldsToLock);
}
}
}
(at your option) any later version.
GLPI is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with GLPI; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
------------------------------------------------------------------------
*/
// Original Author of file: MAZZONI Vincent
// Purpose of file:
// ----------------------------------------------------------------------
define('GLPI_ROOT', '../../..');
include GLPI_ROOT . "/inc/includes.php";
//todo
//PluginFusioninventoryAuth::checkRight("snmp_networking","r");
if (isset($_POST["unlock_field_fusioninventory"])) {
if (isset($_POST["lockfield_fusioninventory"]) && count($_POST["lockfield_fusioninventory"])) {
$tab = PluginFusioninventoryLock::exportChecksToArray($_POST["lockfield_fusioninventory"]);
PluginFusioninventoryLock::setLockArray($_POST['type'], $_POST["ID"], $tab);
} else {
PluginFusioninventoryLock::setLockArray($_POST['type'], $_POST["ID"], array());
}
glpi_header($_SERVER['HTTP_REFERER']);
}
$locks = new PluginFusioninventoryLock();
$locks->showForm($_SERVER["PHP_SELF"], $_POST['type'], $ID);
commonFooter();
/**
* Import discovered device (add / update data in GLPI DB)
*
* @param object $item
*/
function importDevice($item)
{
PluginFusioninventoryLogger::logIfExtradebugAndDebugMode('fusioninventorycommunication', 'Function PluginFusinvsnmpCommunicationNetDiscovery->importDevice().');
$arrayinventory = $_SESSION['SOURCE_XMLDEVICE'];
$input = array();
$input['id'] = $item->getID();
$a_lockable = PluginFusioninventoryLock::getLockFields(getTableForItemType($item->getType()), $item->getID());
if (!in_array('name', $a_lockable)) {
if (isset($arrayinventory['SNMPHOSTNAME']) && !empty($arrayinventory['SNMPHOSTNAME'])) {
$input['name'] = $arrayinventory['SNMPHOSTNAME'];
} else {
if (isset($arrayinventory['NETBIOSNAME']) && !empty($arrayinventory['NETBIOSNAME'])) {
$input['name'] = $arrayinventory['NETBIOSNAME'];
} else {
if (isset($arrayinventory['DNSHOSTNAME']) && !empty($arrayinventory['DNSHOSTNAME'])) {
$input['name'] = $arrayinventory['DNSHOSTNAME'];
}
}
}
}
if (!in_array('serial', $a_lockable)) {
if (isset($arrayinventory['SERIAL'])) {
if (trim($arrayinventory['SERIAL']) != '') {
$input['serial'] = trim($arrayinventory['SERIAL']);
}
}
}
if (isset($input['name']) && $input['name'] == '') {
unset($input['name']);
}
if (isset($input['serial']) && $input['serial'] == '') {
unset($input['serial']);
}
if (isset($arrayinventory['ENTITY']) and !empty($arrayinventory['ENTITY'])) {
$input['entities_id'] = $arrayinventory['ENTITY'];
if (!isset($_SESSION['glpiactiveentities_string'])) {
$_SESSION['glpiactiveentities_string'] = "'" . $arrayinventory['ENTITY'] . "'";
}
}
if (!isset($_SESSION['glpiactiveentities_string'])) {
$_SESSION['glpiactiveentities_string'] = "'" . $item->fields['entities_id'] . "'";
}
switch ($item->getType()) {
case 'Computer':
// don't update this computer, if it is already handled by
// its own agent
if (Dropdown::getDropdownName("glpi_autoupdatesystems", $item->fields['autoupdatesystems_id']) == 'FusionInventory') {
return;
}
if (isset($arrayinventory['WORKGROUP'])) {
$domain = new Domain();
if (!in_array('domains_id', $a_lockable)) {
$input['domains_id'] = $domain->import(array('name' => $arrayinventory['WORKGROUP']));
}
}
$item->update($input);
$this->_updateNetworkInfo($arrayinventory, 'Computer', $item->getID(), 'NetworkPortEthernet', 1);
break;
case 'PluginFusioninventoryUnmanaged':
// Write XML file
if (isset($_SESSION['SOURCE_XMLDEVICE'])) {
PluginFusioninventoryToolbox::writeXML($input['id'], serialize($_SESSION['SOURCE_XMLDEVICE']), 'PluginFusioninventoryUnmanaged');
}
if (!in_array('contact', $a_lockable) && isset($arrayinventory['USERSESSION'])) {
$input['contact'] = $arrayinventory['USERSESSION'];
}
if (!in_array('domain', $a_lockable)) {
if (isset($arrayinventory['WORKGROUP']) && !empty($arrayinventory['WORKGROUP'])) {
$input['domain'] = Dropdown::importExternal("Domain", $arrayinventory['WORKGROUP'], $arrayinventory['ENTITY']);
}
}
if (!empty($arrayinventory['TYPE'])) {
switch ($arrayinventory['TYPE']) {
case '1':
case 'COMPUTER':
$input['item_type'] = 'Computer';
break;
case '2':
case 'NETWORKING':
$input['item_type'] = 'NetworkEquipment';
break;
case '3':
case 'PRINTER':
$input['item_type'] = 'Printer';
break;
}
}
$input['plugin_fusioninventory_agents_id'] = $_SESSION['glpi_plugin_fusioninventory_agentid'];
$this->_updateSNMPInfo($arrayinventory, $input, $item);
$this->_updateNetworkInfo($arrayinventory, 'PluginFusioninventoryUnmanaged', $item->getID(), 'NetworkPortEthernet', 1);
break;
case 'NetworkEquipment':
// Write XML file
if (isset($_SESSION['SOURCE_XMLDEVICE'])) {
PluginFusioninventoryToolbox::writeXML($input['id'], serialize($_SESSION['SOURCE_XMLDEVICE']), 'NetworkEquipment');
}
$item->update($input);
$this->_updateNetworkInfo($arrayinventory, 'NetworkEquipment', $item->getID(), 'NetworkPortAggregate', 0);
$pfNetworkEquipment = new PluginFusioninventoryNetworkEquipment();
$input = $this->_initSpecificInfo('networkequipments_id', $item->getID(), $pfNetworkEquipment);
$this->_updateSNMPInfo($arrayinventory, $input, $pfNetworkEquipment);
break;
case 'Printer':
// Write XML file
if (isset($_SESSION['SOURCE_XMLDEVICE'])) {
PluginFusioninventoryToolbox::writeXML($input['id'], serialize($_SESSION['SOURCE_XMLDEVICE']), 'Printer');
}
$input['have_ethernet'] = '1';
$item->update($input);
$this->_updateNetworkInfo($arrayinventory, 'Printer', $item->getID(), 'NetworkPortEthernet', 1);
$pfPrinter = new PluginFusioninventoryPrinter();
$input = $this->_initSpecificInfo('printers_id', $item->getID(), $pfPrinter);
$this->_updateSNMPInfo($arrayinventory, $input, $pfPrinter);
break;
}
}
/**
* Get lock fields for a record.
*
* @param $p_itemtype Table id.
* @param $p_items_id Line id.
* TODO: check rights
*
*@return array of locked fields
**/
static function getLockFields($p_itemtype, $p_items_id)
{
global $DB;
$db_lock = $DB->fetch_assoc(PluginFusioninventoryLock::getLock($p_itemtype, $p_items_id));
$lock_fields = $db_lock["fields"];
$lock = importArrayFromDB($lock_fields);
return $lock;
}
/**
* Set lockables fields
*
*@param $p_id Lockable id. If 0 creates a new lockable record, else update.
*@param $p_itemtype Table name.
*@param $p_fields Array of fields to set to lockable (ex : "0=>name 1=>comments 2=>contact").
*@param $p_entities_id Entity id.
*@param $p_recursive Recursive lock (0/1).
*TODO: check rights
*
*@return nothing
**/
static function setLockableForm($p_post)
{
global $DB, $LINK_ID_TABLE;
$tableId = array_search($p_post["tableSelect"], $LINK_ID_TABLE);
$_SESSION["glpi_plugin_fusioninventory_lockable_table"] = $tableId;
if (isset($p_post['plugin_fusioninventory_lockable_add']) and isset($p_post['columnSelect']) or isset($_POST['plugin_fusioninventory_lockable_delete']) and isset($p_post['columnLockable'])) {
// delete AND columns to delete
$db_lockable = $DB->fetch_assoc(PluginFusioninventoryLockable::getLockable('', $tableId));
$lockable_id = $db_lockable["id"];
$lockable_fields = $db_lockable["fields"];
$lockable = importArrayFromDB($lockable_fields);
if (isset($p_post['plugin_fusioninventory_lockable_add']) and isset($p_post['columnSelect'])) {
// add
foreach ($p_post['columnSelect'] as $key => $id_value) {
array_push($lockable, $id_value);
}
}
if (isset($_POST['plugin_fusioninventory_lockable_delete']) and isset($p_post['columnLockable'])) {
// delete
foreach ($p_post['columnLockable'] as $key => $id_value) {
$fieldToDel = array_search($id_value, $lockable);
if (isset($lockable[$fieldToDel])) {
$fieldName = $lockable[$fieldToDel];
// TODO add a confirmation request before lockable deletion if locks are defined on this field
unset($lockable[$fieldToDel]);
// field is not lockable any more --> delete all locks on this field
PluginFusioninventoryLock::deleteInAllLockArray($tableId, $fieldName);
}
}
}
PluginFusioninventoryLockable::setLockable($lockable_id, $tableId, exportArrayToDB($lockable), '', '');
}
}