Skip to content
Permalink
65bba9a024
Switch branches/tags

ocsinventoryng/inc/ocsserver.class.php /
Jump to
Code definitions

No definitions found in this file.

Code navigation not available for this commit

Go to file
  • Go to file
  • Copy path
  • Copy permalink
 
 
Cannot retrieve contributors at this time
3146 lines (2736 sloc) 130 KB
Raw Blame
<?php
/*
* @version $Id: HEADER 15930 2011-10-30 15:47:55Z tsmr $
-------------------------------------------------------------------------
ocsinventoryng plugin for GLPI
Copyright (C) 2015-2016 by the ocsinventoryng Development Team.
https://github.com/pluginsGLPI/ocsinventoryng
-------------------------------------------------------------------------
LICENSE
This file is part of ocsinventoryng.
ocsinventoryng is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
ocsinventoryng 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 ocsinventoryng. If not, see <http://www.gnu.org/licenses/>.
--------------------------------------------------------------------------
*/
if (!defined('GLPI_ROOT')) {
die("Sorry. You can't access directly to this file");
}
/// OCS config class
/**
* Class PluginOcsinventoryngOcsServer
*/
class PluginOcsinventoryngOcsServer extends CommonDBTM {
static $types = ['Computer'];
static $rightname = "plugin_ocsinventoryng";
// From CommonDBTM
public $dohistory = true;
// Connection types
const CONN_TYPE_DB = 0;
const CONN_TYPE_SOAP = 1;
const OCS_VERSION_LIMIT = 4020;
const OCS1_3_VERSION_LIMIT = 5004;
const OCS2_VERSION_LIMIT = 6000;
const OCS2_1_VERSION_LIMIT = 7006;
const OCS2_2_VERSION_LIMIT = 7009;
const ACTION_PURGE_COMPUTER = 0; // Action cronCleanOldAgents : Purge computer
const ACTION_DELETE_COMPUTER = 1; // Action cronCleanOldAgents : delete computer
/**
* @param int $nb
*
* @return translated
*/
static function getTypeName($nb = 0) {
return _n('OCSNG server', 'OCSNG servers', $nb, 'ocsinventoryng');
}
/**
* @param CommonGLPI $item
* @param int $withtemplate
*
* @return string
*/
function getTabNameForItem(CommonGLPI $item, $withtemplate = 0) {
if (!$withtemplate) {
switch ($item->getType()) {
case __CLASS__ :
//If connection to the OCS DB is ok, and all rights are ok too
$ong[1] = __('Test');
if (self::checkOCSconnection($item->getID())
&& self::checkVersion($item->getID())
&& self::checkTraceDeleted($item->getID())
) {
$ong[2] = __('Datas to import', 'ocsinventoryng');
$ong[3] = __('Import options', 'ocsinventoryng');
$ong[4] = __('General history', 'ocsinventoryng');
}
if ($item->getField('ocs_url')) {
$ong[5] = __('OCSNG console', 'ocsinventoryng');
}
return $ong;
}
}
return '';
}
/**
* @param CommonGLPI $item
* @param int $tabnum
* @param int $withtemplate
*
* @return bool
*/
static function displayTabContentForItem(CommonGLPI $item, $tabnum = 1, $withtemplate = 0) {
if ($item->getType() == __CLASS__) {
switch ($tabnum) {
case 1 :
$item->showDBConnectionStatus($item->getID());
break;
case 2 :
$item->ocsFormConfig($item->getID());
break;
case 3 :
$item->ocsFormImportOptions($item->getID());
break;
case 4 :
$item->ocsHistoryConfig($item->getID());
break;
case 5 :
self::showOcsReportsConsole($item->getID());
break;
}
}
return true;
}
/**
* @param array $options
*
* @return array
*/
function defineTabs($options = []) {
$ong = [];
$this->addDefaultFormTab($ong);
$this->addStandardTab(__CLASS__, $ong, $options);
$this->addStandardTab('PluginOcsinventoryngSnmpOcslink', $ong, $options);
$this->addStandardTab('Log', $ong, $options);
return $ong;
}
/**
* @return array
*/
function rawSearchOptions() {
$tab = [];
$tab[] = [
'id' => 'common',
'name' => self::getTypeName(2)
];
$tab[] = [
'id' => '1',
'table' => $this->getTable(),
'field' => 'name',
'name' => __('Name'),
'datatype' => 'itemlink',
'massiveaction' => false,
'itemlink_type' => $this->getType()
];
$tab[] = [
'id' => '3',
'table' => $this->getTable(),
'field' => 'ocs_db_host',
'name' => __('Server')
];
$tab[] = [
'id' => '6',
'table' => $this->getTable(),
'field' => 'is_active',
'name' => __('Active'),
'datatype' => 'bool'
];
$tab[] = [
'id' => '19',
'table' => $this->getTable(),
'field' => 'date_mod',
'name' => __('Last update'),
'datatype' => 'datetime',
'massiveaction' => false,
];
$tab[] = [
'id' => '16',
'table' => $this->getTable(),
'field' => 'comment',
'name' => __('Comments'),
'datatype' => 'text'
];
$tab[] = [
'id' => '17',
'table' => $this->getTable(),
'field' => 'use_massimport',
'name' => __('Expert sync mode', 'ocsinventoryng'),
'datatype' => 'bool'
];
$tab[] = [
'id' => '18',
'table' => $this->getTable(),
'field' => 'ocs_db_utf8',
'name' => __('Database in UTF8', 'ocsinventoryng'),
'datatype' => 'bool'
];
$tab[] = [
'id' => '30',
'table' => $this->getTable(),
'field' => 'id',
'name' => __('ID'),
'datatype' => 'number'
];
return $tab;
}
/**
* Print ocs menu
*
* @param $plugin_ocsinventoryng_ocsservers_id Integer : Id of the ocs config
*
* @return void (display)
* @throws \GlpitestSQLError
*/
static function setupMenu($plugin_ocsinventoryng_ocsservers_id) {
global $CFG_GLPI, $DB;
$name = "";
$ocsservers = [];
$dbu = new DbUtils();
$numberActiveServers = $dbu->countElementsInTable('glpi_plugin_ocsinventoryng_ocsservers', ["is_active" => 1]);
if ($numberActiveServers > 0) {
echo "<form action=\"" . $CFG_GLPI['root_doc'] . "/plugins/ocsinventoryng/front/ocsng.php\"
method='post'>";
echo "<div class='center'><table class='tab_cadre_fixe' width='40%'>";
echo "<tr class='tab_bg_2'><th colspan='2'>" . __('Choice of an OCSNG server', 'ocsinventoryng') .
"</th></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Name') . "</td>";
echo "<td class='center'>";
$query = "SELECT `glpi_plugin_ocsinventoryng_ocsservers`.`id`
FROM `glpi_plugin_ocsinventoryng_ocsservers_profiles`
LEFT JOIN `glpi_plugin_ocsinventoryng_ocsservers`
ON `glpi_plugin_ocsinventoryng_ocsservers_profiles`.`plugin_ocsinventoryng_ocsservers_id`
= `glpi_plugin_ocsinventoryng_ocsservers`.`id`
WHERE `profiles_id`= " . $_SESSION["glpiactiveprofile"]['id'] . "
AND `glpi_plugin_ocsinventoryng_ocsservers`.`is_active`= 1
ORDER BY `name` ASC";
foreach ($DB->request($query) as $data) {
$ocsservers[] = $data['id'];
}
Dropdown::show('PluginOcsinventoryngOcsServer', ["condition" => ["id" => $ocsservers],
"value" => $_SESSION["plugin_ocsinventoryng_ocsservers_id"],
"on_change" => "this.form.submit()",
"display_emptychoice" => false]);
echo "</td></tr>";
echo "<tr class='tab_bg_2'><td colspan='2' class ='center red'>";
echo __('If you not find your OCSNG server in this dropdown, please check if your profile can access it !', 'ocsinventoryng');
echo "</td></tr>";
echo "</table></div>";
Html::closeForm();
}
$sql = "SELECT `name`, `is_active`
FROM `glpi_plugin_ocsinventoryng_ocsservers`
LEFT JOIN `glpi_plugin_ocsinventoryng_ocsservers_profiles`
ON `glpi_plugin_ocsinventoryng_ocsservers_profiles`.`plugin_ocsinventoryng_ocsservers_id` = `glpi_plugin_ocsinventoryng_ocsservers`.`id`
WHERE `glpi_plugin_ocsinventoryng_ocsservers`.`id` = '" . $plugin_ocsinventoryng_ocsservers_id . "'
AND `glpi_plugin_ocsinventoryng_ocsservers_profiles`.`profiles_id`= '" . $_SESSION["glpiactiveprofile"]['id'] . "'";
$result = $DB->query($sql);
$isactive = 0;
if ($DB->numrows($result) > 0) {
$datas = $DB->fetch_array($result);
$name = " : " . $datas["name"];
$isactive = $datas["is_active"];
}
$usemassimport = self::useMassImport();
echo "<div class='center'><table class='tab_cadre_fixe' width='40%'>";
if (Session::haveRight("plugin_ocsinventoryng", READ)) {
echo "<tr><th colspan='4'>";
printf(__('%1$s %2$s'), __('OCSNG server', 'ocsinventoryng'), $name);
echo "</th></tr>";
//config server
if ($isactive) {
echo "<tr class='tab_bg_1'><td class='center b' colspan='" . ($usemassimport ? 2 : 4) . "'>
<a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/ocsserver.form.php?id=$plugin_ocsinventoryng_ocsservers_id'>
<i style='color:cornflowerblue' class='fas fa-cogs fa-3x'
title=\"" . __s('Configuration of OCSNG server', 'ocsinventoryng') . "\"></i>
<br>" . sprintf(__('Configuration of OCSNG server %s', 'ocsinventoryng'), $name) . "
</a></td>";
if ($usemassimport && Session::haveRight("plugin_ocsinventoryng", UPDATE)) {
//config massimport
echo "<td class='center b' colspan='2'>
<a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/config.form.php'>
<i style='color:grey' class='fas fa-sync-alt fa-3x'
title=\"" . __s('Automatic synchronization\'s configuration', 'ocsinventoryng') . "\"></i>
<br>" . __("Automatic synchronization's configuration", 'ocsinventoryng') . "
</a></td>";
}
echo "</tr>\n";
}
}
echo "<tr><th colspan='4'>";
echo __('Setup rules engine', 'ocsinventoryng');
echo "</th></tr>";
echo "<tr class='tab_bg_1'><td class='center b' colspan='2'>
<a href='" . $CFG_GLPI["root_doc"] . "/front/ruleimportentity.php'>" . __('Rules for assigning an item to an entity') . "
</a>";
echo "<br><div class='red'>";
echo __('Setup rules for choose entity on items import', 'ocsinventoryng');
echo "</div></td>";
echo "<td class='center b' colspan='2'>
<a href='" . $CFG_GLPI["root_doc"] . "/front/ruleimportcomputer.php'>" . __('Rules for import and link computers') . "
</a>";
echo "<br><div class='red'>";
echo __('Setup rules for select criteria for items link', 'ocsinventoryng');
echo "</div></td>";
echo "</tr>\n";
echo "</table></div>";
}
/**
* Print ocs menu
*
* @param $plugin_ocsinventoryng_ocsservers_id Integer : Id of the ocs config
*
* @return void (display)
* @throws \GlpitestSQLError
*/
static function importMenu($plugin_ocsinventoryng_ocsservers_id) {
global $CFG_GLPI, $DB;
$name = "";
$ocsservers = [];
$dbu = new DbUtils();
$numberActiveServers = $dbu->countElementsInTable('glpi_plugin_ocsinventoryng_ocsservers',
["is_active" => 1]);
if ($numberActiveServers > 0) {
echo "<form action=\"" . $CFG_GLPI['root_doc'] . "/plugins/ocsinventoryng/front/ocsng.php\"
method='post'>";
echo "<div class='center'><table class='tab_cadre_fixe' width='40%'>";
echo "<tr class='tab_bg_2'><th colspan='2'>" . __('Choice of an OCSNG server', 'ocsinventoryng') .
"</th></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Name') . "</td>";
echo "<td class='center'>";
$query = "SELECT `glpi_plugin_ocsinventoryng_ocsservers`.`id`
FROM `glpi_plugin_ocsinventoryng_ocsservers_profiles`
LEFT JOIN `glpi_plugin_ocsinventoryng_ocsservers`
ON `glpi_plugin_ocsinventoryng_ocsservers_profiles`.`plugin_ocsinventoryng_ocsservers_id` = `glpi_plugin_ocsinventoryng_ocsservers`.`id`
WHERE `profiles_id`= " . $_SESSION["glpiactiveprofile"]['id'] . " AND `glpi_plugin_ocsinventoryng_ocsservers`.`is_active`='1'
ORDER BY `name` ASC";
foreach ($DB->request($query) as $data) {
$ocsservers[] = $data['id'];
}
Dropdown::show('PluginOcsinventoryngOcsServer', ["condition" => ["id" => $ocsservers],
"value" => $_SESSION["plugin_ocsinventoryng_ocsservers_id"],
"on_change" => "this.form.submit()",
"display_emptychoice" => false]);
echo "</td></tr>";
echo "<tr class='tab_bg_2'><td colspan='2' class ='center red'>";
echo __('If you not find your OCSNG server in this dropdown, please check if your profile can access it !', 'ocsinventoryng');
echo "</td></tr>";
echo "</table></div>";
Html::closeForm();
}
$sql = "SELECT `name`, `is_active`
FROM `glpi_plugin_ocsinventoryng_ocsservers`
LEFT JOIN `glpi_plugin_ocsinventoryng_ocsservers_profiles`
ON `glpi_plugin_ocsinventoryng_ocsservers_profiles`.`plugin_ocsinventoryng_ocsservers_id` = `glpi_plugin_ocsinventoryng_ocsservers`.`id`
WHERE `glpi_plugin_ocsinventoryng_ocsservers`.`id` = " . $plugin_ocsinventoryng_ocsservers_id . "
AND `glpi_plugin_ocsinventoryng_ocsservers_profiles`.`profiles_id`= '" . $_SESSION["glpiactiveprofile"]['id'] . "'";
$result = $DB->query($sql);
$isactive = 0;
if ($DB->numrows($result) > 0) {
$datas = $DB->fetch_array($result);
$name = " : " . $datas["name"];
$isactive = $datas["is_active"];
}
$usemassimport = self::useMassImport();
echo "<div class='center'><table class='tab_cadre_fixe' width='40%'>";
echo "<tr><th colspan='" . ($usemassimport ? 4 : 2) . "'>";
printf(__('%1$s %2$s'), __('OCSNG server', 'ocsinventoryng'), $name);
echo "<br>";
if (Session::haveRight("plugin_ocsinventoryng", READ)
&& $isactive) {
echo "<a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/ocsserver.form.php?id=" . $plugin_ocsinventoryng_ocsservers_id . "&forcetab=PluginOcsinventoryngOcsServer\$2'>";
echo __('See Setup : Datas to import before', 'ocsinventoryng');
echo "</a>";
echo "</th></tr>";
}
if (Session::haveRight("plugin_ocsinventoryng", READ)) {
//config server
if ($isactive) {
if (Session::haveRight("plugin_ocsinventoryng_import", READ)) {
//manual import
echo "<tr class='tab_bg_1'>";
if (Session::haveRight("plugin_ocsinventoryng_import", READ)) {
echo "<td class='center b' colspan='2'>
<a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/ocsng.import.php'>";
echo "<i style='color:cornflowerblue' class='fas fa-plus fa-3x'
title=\"" . __s('Import new computers', 'ocsinventoryng') . "\"></i>";
echo "<br>" . __('Import new computers', 'ocsinventoryng') . "
</a></td>";
} else {
echo "<td class='center b' colspan='2'></td>";
}
if ($usemassimport && Session::haveRight("plugin_ocsinventoryng", UPDATE)) {
//threads
echo "<td class='center b' colspan='2'>
<a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/thread.php?plugin_ocsinventoryng_ocsservers_id=" . $plugin_ocsinventoryng_ocsservers_id . "'>
<i style='color:cornflowerblue' class='fas fa-play fa-3x'
title=\"" . __s('Scripts execution of automatic actions', 'ocsinventoryng') . "\"></i>
<br>" . __('Scripts execution of automatic actions', 'ocsinventoryng') . "
</a></td>";
}
echo "</tr>\n";
}
//manual synchro
if (Session::haveRight("plugin_ocsinventoryng_sync", READ)) {
echo "<tr class='tab_bg_1'>";
if (Session::haveRight("plugin_ocsinventoryng_sync", READ) && $isactive) {
echo "<td class='center b' colspan='2'>
<a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/ocsng.sync.php'>
<i style='color:cornflowerblue' class='fas fa-sync-alt fa-3x'
title=\"" . __s('Synchronize computers already imported', 'ocsinventoryng') . "\"></i>
<br>" . __('Synchronize computers already imported', 'ocsinventoryng') . "
</a></td>";
} else {
echo "<td class='center b' colspan='2'></td>";
}
$log = PluginOcsinventoryngConfig::logProcessedComputers();
if ($log && Session::haveRight("plugin_ocsinventoryng_import", READ) && $usemassimport) {
//host imported by thread
echo "<td class='center b' colspan='2'>
<a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/detail.php'>
<i style='color:green' class='fas fa-check fa-3x'
title=\"" . __s('Computers imported by automatic actions', 'ocsinventoryng') . "\"></i>
<br>" . __('Computers imported by automatic actions', 'ocsinventoryng') . "
</a></td>";
} else {
echo "<td class='center b' colspan='2'></td>";
}
echo "</tr>\n";
}
//link
if (Session::haveRight("plugin_ocsinventoryng_link", READ)
|| Session::haveRight("plugin_ocsinventoryng", READ)) {
echo "<tr class='tab_bg_1'>";
if (Session::haveRight("plugin_ocsinventoryng_link", READ) && $isactive) {
echo "<td class='center b' colspan='2'>
<a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/ocsng.link.php'>
<i style='color:firebrick' class='fas fa-arrow-alt-circle-down fa-3x'
title=\"" . __s('Link new OCSNG computers to existing GLPI computers', 'ocsinventoryng') . "\"></i>
<br>" . __('Link new OCSNG computers to existing GLPI computers', 'ocsinventoryng') . "
</a></td>";
} else {
echo "<td class='center b' colspan='2'></td>";
}
if ($usemassimport && Session::haveRight("plugin_ocsinventoryng", UPDATE)) {
//host not imported by thread
echo "<td class='center b' colspan='2'>
<a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/notimportedcomputer.php'>
<i style='color:firebrick' class='fas fa-times fa-3x'
title=\"" . __s('Computers not imported by automatic actions', 'ocsinventoryng') . "\"></i>
<br>" . __('Computers not imported by automatic actions', 'ocsinventoryng') . "
</a></td>";
}
echo "</tr>\n";
}
} else {
echo "<tr class='tab_bg_2'><td class='center red' colspan='2'>";
echo __('The selected server is not active. Import and synchronisation is not available', 'ocsinventoryng');
echo "</td></tr>\n";
}
}
if ((Session::haveRight("plugin_ocsinventoryng_clean", UPDATE)
|| Session::haveRight(static::$rightname, UPDATE))
&& $isactive) {
if (Session::haveRight(static::$rightname, UPDATE)) {
echo "<tr class='tab_bg_1'><td class='center b' colspan='" . ($usemassimport ? 4 : 2) . "'>
<a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/deleted_equiv.php'>
<i style='color:grey' class='fas fa-trash fa-3x'
title=\"" . __s('Clean OCSNG deleted computers', 'ocsinventoryng') . "\"></i>
<br>" . __('Clean OCSNG deleted computers', 'ocsinventoryng') . "
</a></td>";
}
echo "<tr class='tab_bg_1'><td class='center b' colspan='" . ($usemassimport ? 4 : 2) . "'>
<a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/ocsng.clean.php'>
<i style='color:green' class='fas fa-trash fa-3x'
title=\"" . __s('Clean OCSNG deleted computers', 'ocsinventoryng') . "\"></i>
<br>" . __('Clean links between GLPI and OCSNG', 'ocsinventoryng') . "
</a></td><tr>";
}
echo "</table></div>";
}
/**
* Print ocs config form
*
* @param $ID Integer : Id of the ocs config
*
* @return bool
* @internal param form $target target
*/
function ocsFormConfig($ID) {
if (!Session::haveRight("plugin_ocsinventoryng", READ)) {
return false;
}
$this->getFromDB($ID);
echo "<div class='center'>";
echo "<form name='formconfig' id='formconfig' action='" . Toolbox::getItemTypeFormURL("PluginOcsinventoryngOcsServer") . "' method='post'>";
echo "<table class='tab_cadre_fixe'>\n";
echo "<tr><th>";
echo __('All');
echo $JS = <<<JAVASCRIPT
<script type='text/javascript'>
function form_init_all(value) {
if(value != -1) {
var selects = $("form[id='formconfig'] select");
$.each(selects, function(index, select){
if (select.name != "init_all"
&& select.name != "import_otherserial"
&& select.name != "import_location"
&& select.name != "import_group"
&& select.name != "import_contact_num"
&& select.name != "import_use_date"
&& select.name != "import_network") {
$(select).select2('val', value);
}
});
}
}
</script>
JAVASCRIPT;
$values = [-1 => Dropdown::EMPTY_VALUE,
0 => __('No'),
1 => __('Yes')];
Dropdown::showFromArray('init_all', $values, [
'width' => '10%',
'on_change' => "form_init_all(this.value);"
]);
echo "</th></tr>";
echo "<tr class='tab_bg_2'>\n";
echo "<td class='top'>\n";
echo $JS = <<<JAVASCRIPT
<script type='text/javascript'>
function accordion(id, openall) {
if(id == undefined){
id = 'accordion';
}
jQuery(document).ready(function () {
$("#"+id).accordion({
collapsible: true,
//active:[0, 1, 2, 3],
//heightStyle: "content"
});
//if (openall) {
//$('#'+id +' .ui-accordion-content').show();
//}
});
};
</script>
JAVASCRIPT;
echo "<div id='accordion'>";
echo "<h2><a href='#'>" . __('General information', 'ocsinventoryng') . "</a></h2>";
echo "<div>";
echo "<table class='tab_cadre' width='100%'>";
echo "<tr class='tab_bg_2'>";
echo "<th colspan='4'>".
Html::hidden('id', ['value' => $ID]).
__('General information', 'ocsinventoryng') .
"<br><span style='color:red;'>" . __('Warning : the import entity rules depends on selected fields', 'ocsinventoryng') . "</span>\n";
echo "</th></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Name') . "</td>\n<td>";
Dropdown::showYesNo("import_general_name", $this->fields["import_general_name"]);
echo "</td>\n";
echo "<td class='center'>" . __('Operating system') . "</td>\n<td>";
Dropdown::showYesNo("import_general_os", $this->fields["import_general_os"]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'>";
echo "<td class='center'>" . __('Serial of the operating system') . "</td>\n<td>";
Dropdown::showYesNo("import_os_serial", $this->fields["import_os_serial"]);
echo "</td>\n";
echo "<td class='center'>" . __('Serial number') . "</td>\n<td>";
Dropdown::showYesNo("import_general_serial", $this->fields["import_general_serial"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Depends on Bios import', 'ocsinventoryng')));
echo "&nbsp;</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Model') . "</td>\n<td>";
Dropdown::showYesNo("import_general_model", $this->fields["import_general_model"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Depends on Bios import', 'ocsinventoryng')));
echo "&nbsp;</td>\n";
echo "<td class='center'>" . _n('Manufacturer', 'Manufacturers', 1) . "</td>\n<td>";
Dropdown::showYesNo("import_general_manufacturer", $this->fields["import_general_manufacturer"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Depends on Bios import', 'ocsinventoryng')));
echo "&nbsp;</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Type') . "</td>\n<td>";
Dropdown::showYesNo("import_general_type", $this->fields["import_general_type"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Depends on Bios import', 'ocsinventoryng')));
echo "&nbsp;</td>\n";
echo "<td class='center'>" . __('Domain') . "</td>\n<td>";
Dropdown::showYesNo("import_general_domain", $this->fields["import_general_domain"]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'>";
echo "<td class='center'>" . __('Comments') . "</td>\n<td>";
Dropdown::showYesNo("import_general_comment", $this->fields["import_general_comment"]);
echo "</td>\n";
if (self::checkVersion($ID)) {
echo "<td class='center'>" . __('UUID') . "</td>\n<td>";
Dropdown::showYesNo("import_general_uuid", $this->fields["import_general_uuid"]);
} else {
echo "<td class='center'>";
echo Html::hidden('import_general_uuid', ['value' => 0]);
}
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('IP') . "</td>\n<td>";
Dropdown::showYesNo("import_ip", $this->fields["import_ip"]);
echo "</td>\n";
echo "<td colspan='2'></td></tr>\n";
echo "<tr class='tab_bg_2'>";
echo "<th colspan='4'>" . __('User informations', 'ocsinventoryng');
echo "</th></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Alternate username') . "</td>\n<td>";
Dropdown::showYesNo("import_general_contact", $this->fields["import_general_contact"]);
echo "</td>";
echo "<td class='center'>" . __('Affect default group of user by default', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_user_group_default", $this->fields["import_user_group_default"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Depends on contact import', 'ocsinventoryng')));
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Affect user location by default', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_user_location", $this->fields["import_user_location"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Depends on contact import', 'ocsinventoryng')));
echo "</td>\n";
echo "<td class='center'>" . __('Affect first group of user by default', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_user_group", $this->fields["import_user_group"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Depends on contact import', 'ocsinventoryng')));
echo "</td></tr>\n";
echo "</table>";
echo "</div>";
//Components
echo "<h2><a href='#'>" . _n('Component', 'Components', 2) . "</a></h2>";
echo "<div>";
echo "<table class='tab_cadre' width='100%'>";
echo "<th colspan='4'>" . _n('Component', 'Components', 2);
echo "</th></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Processor') . "</td>\n<td>";
Dropdown::showYesNo("import_device_processor", $this->fields["import_device_processor"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('After 7006 version of OCS Inventory NG', 'ocsinventoryng')));
echo "&nbsp;</td>\n";
echo "<td class='center'>" . __('Memory') . "</td>\n<td>";
Dropdown::showYesNo("import_device_memory", $this->fields["import_device_memory"]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Hard drive') . "</td>\n<td>";
Dropdown::showYesNo("import_device_hdd", $this->fields["import_device_hdd"]);
echo "</td>\n";
echo "<td class='center'>" . __('Network card') . "</td>\n<td>";
Dropdown::showYesNo("import_device_iface", $this->fields["import_device_iface"]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Graphics card') . "</td>\n<td>";
Dropdown::showYesNo("import_device_gfxcard", $this->fields["import_device_gfxcard"]);
echo "&nbsp;&nbsp;</td>";
echo "<td class='center'>" . __('Soundcard') . "</td>\n<td>";
Dropdown::showYesNo("import_device_sound", $this->fields["import_device_sound"]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . _n('Drive', 'Drives', 2) . "</td>\n<td>";
Dropdown::showYesNo("import_device_drive", $this->fields["import_device_drive"]);
echo "</td>\n";
echo "<td class='center'>" . __('Modems') . "</td>\n<td>";
Dropdown::showYesNo("import_device_modem", $this->fields["import_device_modem"]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . _n('Port', 'Ports', 2) . "</td>\n<td>";
Dropdown::showYesNo("import_device_port", $this->fields["import_device_port"]);
echo "</td>\n";
echo "<td class='center'>" . __('Bios') . "</td>\n<td>";
Dropdown::showYesNo("import_device_bios", $this->fields["import_device_bios"]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('System board') . "</td>\n<td>";
Dropdown::showYesNo("import_device_motherboard", $this->fields["import_device_motherboard"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('After 7009 version of OCS Inventory NG && Depends on Bios import', 'ocsinventoryng')));
echo "&nbsp;</td>\n";
echo "<td class='center'>" . _n('Controller', 'Controllers', 2) . "</td>\n<td>";
Dropdown::showYesNo("import_device_controller", $this->fields["import_device_controller"]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . _n('Other component', 'Other components', 2) . "</td>\n<td>";
Dropdown::showYesNo("import_device_slot", $this->fields["import_device_slot"]);
echo "</td><td colspan='2'></td></tr>\n";
echo "</table>";
echo "</div>";
//Linked objects
echo "<h2><a href='#'>" . __('Linked objects', 'ocsinventoryng') . "</a></h2>";
echo "<div>";
echo "<table class='tab_cadre' width='100%'>";
echo "<tr><th colspan='4'>" . __('Linked objects', 'ocsinventoryng') . "</th>\n";
$import_array = ["0" => __('No import'),
"1" => __('Global import', 'ocsinventoryng'),
"2" => __('Unit import', 'ocsinventoryng')];
$import_array2 = ["0" => __('No import'),
"1" => __('Global import', 'ocsinventoryng'),
"2" => __('Unit import', 'ocsinventoryng'),
"3" => __('Unit import on serial number', 'ocsinventoryng'),
"4" => __('Unit import serial number only', 'ocsinventoryng')];
$periph = $this->fields["import_periph"];
$monitor = $this->fields["import_monitor"];
$printer = $this->fields["import_printer"];
$software = $this->fields["import_software"];
echo "<tr class='tab_bg_2'><td class='center'>" . _n('Device', 'Devices', 2) . " </td>\n<td>";
Dropdown::showFromArray("import_periph", $import_array, ['value' => $periph]);
echo "</td>\n";
echo "<td class='center'>" . _n('Monitor', 'Monitors', 2) . "</td>\n<td>";
Dropdown::showFromArray("import_monitor", $import_array2, ['value' => $monitor]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Comments') . " " . _n('Monitor', 'Monitors', 2) . " </td>\n<td>";
Dropdown::showYesNo("import_monitor_comment", $this->fields["import_monitor_comment"]);
echo "</td>\n";
echo "<td class='center'>" . _n('Printer', 'Printers', 2) . "</td>\n<td>";
Dropdown::showFromArray("import_printer", $import_array, ['value' => $printer]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . _n('Software', 'Software', 2) . "</td>\n<td>";
$import_array = ["0" => __('No import'),
"1" => __('Unit import', 'ocsinventoryng')];
Dropdown::showFromArray("import_software", $import_array, ['value' => $software]);
echo "</td>\n";
echo "<td class='center'>" . _n('Volume', 'Volumes', 2) . "</td>\n<td>";
Dropdown::showYesNo("import_disk", $this->fields["import_disk"]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Registry', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_registry", $this->fields["import_registry"]);
echo "</td>\n";
//check version
if ($this->fields['ocs_version'] > self::OCS1_3_VERSION_LIMIT) {
echo "<td class='center'>" .
_n('Virtual machine', 'Virtual machines', 2) . "</td>\n<td>";
Dropdown::showYesNo("import_vms", $this->fields["import_vms"]);
echo "</td>\n";
} else {
echo "<td class='center'>";
echo Html::hidden('import_vms', ['value' => 0]);
echo "</td>\n";
}
echo "</tr>\n";
echo "<tr class='tab_bg_2'><td class='center b red' colspan='4'>";
echo __('No import: the plugin will not import these elements', 'ocsinventoryng');
echo "<br>" . __('Global import: everything is imported but the material is globally managed (without duplicate)', 'ocsinventoryng');
echo "<br>" . __("Unit import: everything is imported as it is", 'ocsinventoryng');
echo "</td></tr>";
echo "</table>";
echo "</div>";
//Linked objects
echo "<h2><a href='#'>" . __('OCS Inventory NG plugins', 'ocsinventoryng') . "</a></h2>";
echo "<div>";
echo "<table class='tab_cadre' width='100%'>";
echo "<tr><th colspan='4'>" . __('OCS Inventory NG plugins', 'ocsinventoryng') . "</th>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Microsoft Office licenses', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_officepack", $this->fields["import_officepack"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Depends on software import and OfficePack Plugin for (https://github.com/PluginsOCSInventory-NG/officepack) OCSNG must be installed', 'ocsinventoryng')));
echo "</td><td class='center'>" . __('Antivirus', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_antivirus", $this->fields["import_antivirus"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Security Plugin for OCSNG (https://github.com/PluginsOCSInventory-NG/security) must be installed', 'ocsinventoryng')));
echo "&nbsp;</td>\n";
echo "</tr>";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Uptime', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_uptime", $this->fields["import_uptime"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Uptime Plugin for OCSNG (https://github.com/PluginsOCSInventory-NG/uptime) must be installed', 'ocsinventoryng')));
echo "&nbsp;</td><td class='center'>" . __('Windows Update State', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_winupdatestate", $this->fields["import_winupdatestate"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Winupdate Plugin for OCSNG (https://github.com/PluginsOCSInventory-NG/winupdate) must be installed', 'ocsinventoryng')));
echo "&nbsp;</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Teamviewer', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_teamviewer", $this->fields["import_teamviewer"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Teamviewer Plugin for OCSNG (https://github.com/PluginsOCSInventory-NG/teamviewer) must be installed', 'ocsinventoryng')));
echo "&nbsp;</td><td class='center'>" . __('Proxy Settings', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_proxysetting", $this->fields["import_proxysetting"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Navigator Proxy Setting Plugin for OCSNG (https://github.com/PluginsOCSInventory-NG/navigatorproxysetting) must be installed', 'ocsinventoryng')));
echo "&nbsp;</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Windows Users', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_winusers", $this->fields["import_winusers"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Winusers Plugin for OCSNG (https://github.com/PluginsOCSInventory-NG/winusers) must be installed', 'ocsinventoryng')));
echo "&nbsp;</td>\n";
echo "<td class='center'>" . __('OS Informations', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_osinstall", $this->fields["import_osinstall"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('OSInstall Plugin for OCSNG (https://github.com/PluginsOCSInventory-NG/osinstall) must be installed', 'ocsinventoryng')));
echo "&nbsp;</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Network shares', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_networkshare", $this->fields["import_networkshare"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Networkshare Plugin for OCSNG (https://github.com/PluginsOCSInventory-NG/networkshare) must be installed', 'ocsinventoryng')));
echo "&nbsp;</td>\n";
echo "<td class='center'>" . __('Service', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_service", $this->fields["import_service"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Service Plugin for OCSNG (https://github.com/PluginsOCSInventory-NG/services) must be installed', 'ocsinventoryng')));
echo "&nbsp;</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Running Process', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_runningprocess", $this->fields["import_runningprocess"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Running Process Plugin for OCSNG (https://github.com/PluginsOCSInventory-NG/runningProcess) must be installed', 'ocsinventoryng')));
echo "&nbsp;</td>\n";
echo "<td class='center'>" . __('Customapp', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("import_customapp", $this->fields["import_customapp"]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Customapp Plugin for OCSNG (https://github.com/PluginsOCSInventory-NG/customapp) must be installed', 'ocsinventoryng')));
echo "&nbsp;</td>\n";
echo "</table>";
echo "</div>";
//Administrative information
echo "<h2><a href='#'>" . __('OCSNG administrative information', 'ocsinventoryng') . "</a></h2>";
echo "<div>";
echo "<table class='tab_cadre' width='100%'>";
echo "<th colspan='4'>" . __('OCSNG administrative information', 'ocsinventoryng');
echo "</th></tr>\n";
$opt = PluginOcsinventoryngOcsAdminInfosLink::getColumnListFromAccountInfoTable($ID, 'accountinfo');
$oserial = $opt;
$oserial['ASSETTAG'] = "ASSETTAG";
echo "<table class='tab_cadre' width='100%'>";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Inventory number') . " </td>\n";
echo "<td>";
$link = new PluginOcsinventoryngOcsAdminInfosLink();
$link->getFromDBbyOcsServerIDAndGlpiColumn($ID, "otherserial");
$value = (isset($link->fields["ocs_column"]) ? $link->fields["ocs_column"] : "");
Dropdown::showFromArray("import_otherserial", $oserial, ['value' => $value,
'width' => '100%']);
echo "</td>\n";
echo "<td class='center'>" . __('Location') . " </td>\n";
echo "<td>";
$link = new PluginOcsinventoryngOcsAdminInfosLink();
$link->getFromDBbyOcsServerIDAndGlpiColumn($ID, "locations_id");
$value = (isset($link->fields["ocs_column"]) ? $link->fields["ocs_column"] : "");
Dropdown::showFromArray("import_location", $opt, ['value' => $value,
'width' => '100%']);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Group') . " </td>\n";
echo "<td>";
$link = new PluginOcsinventoryngOcsAdminInfosLink();
$link->getFromDBbyOcsServerIDAndGlpiColumn($ID, "groups_id");
$value = (isset($link->fields["ocs_column"]) ? $link->fields["ocs_column"] : "");
Dropdown::showFromArray("import_group", $opt, ['value' => $value,
'width' => '100%']);
echo "</td>\n";
echo "<td class='center'>" . __('Alternate username number') . " </td>\n";
echo "<td>";
$link = new PluginOcsinventoryngOcsAdminInfosLink();
$link->getFromDBbyOcsServerIDAndGlpiColumn($ID, "contact_num");
$value = (isset($link->fields["ocs_column"]) ? $link->fields["ocs_column"] : "");
Dropdown::showFromArray("import_contact_num", $opt, ['value' => $value,
'width' => '100%']);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Network') . " </td>\n";
echo "<td>";
$link = new PluginOcsinventoryngOcsAdminInfosLink();
$link->getFromDBbyOcsServerIDAndGlpiColumn($ID, "networks_id");
$value = (isset($link->fields["ocs_column"]) ? $link->fields["ocs_column"] : "");
Dropdown::showFromArray("import_network", $opt, ['value' => $value,
'width' => '100%']);
echo "</td>\n";
$opt_date = PluginOcsinventoryngOcsAdminInfosLink::getColumnListFromAccountInfoTable($ID, 'hardware');
echo "<td class='center'>" . __('Startup date') . " </td>\n";
echo "<td>";
$link = new PluginOcsinventoryngOcsAdminInfosLink();
$link->getFromDBbyOcsServerIDAndGlpiColumn($ID, "use_date");
$value = (isset($link->fields["ocs_column"]) ? $link->fields["ocs_column"] : "");
Dropdown::showFromArray("import_use_date", $opt_date, ['value' => $value,
'width' => '100%']);
echo "</td></tr>\n";
echo "</table>";
echo "</div>";
echo "</div>";
echo "<script>accordion();</script>";
echo "</td></tr>\n";
if (Session::haveRight("plugin_ocsinventoryng", UPDATE)) {
echo "<tr class='tab_bg_2 center'><td colspan='4'>";
echo Html::submit(_sx('button', 'Save'), ['name' => 'update']);
echo "</td></tr>\n";
}
echo "</table>\n";
Html::closeForm();
echo "</div>\n";
}
static function getHistoryValues() {
$values = [__('None'),
__('Installation / Update / Uninstallation', 'ocsinventoryng'),
__('Installation / Update', 'ocsinventoryng'),
__('Uninstallation', 'ocsinventoryng')];
return $values;
}
function showHistoryDropdown($name) {
$value = $this->fields[$name];
$values = self::getHistoryValues();
return Dropdown::showFromArray($name, $values, ['value' => $value]);
}
/**
* Print ocs history form
*
* @param $ID Integer : Id of the ocs config
*
*
* @return bool
*/
function ocsHistoryConfig($ID) {
if (!Session::haveRight("plugin_ocsinventoryng", READ)) {
return false;
}
$this->getFromDB($ID);
echo "<div class='center'>";
echo "<form name='historyconfig' id='historyconfig' action='" . Toolbox::getItemTypeFormURL("PluginOcsinventoryngOcsServer") . "' method='post'>";
echo "<table class='tab_cadre_fixe'>\n";
echo "<tr><th colspan ='4'>";
echo __('All');
echo $JS = <<<JAVASCRIPT
<script type='text/javascript'>
function form_init_all(value) {
if(value != -1) {
var selects = $("form[id='historyconfig'] select");
$.each(selects, function(index, select){
if (select.name != "init_all") {
$(select).select2('val', value);
}
});
}
}
</script>
JAVASCRIPT;
$values = [-1 => Dropdown::EMPTY_VALUE,
0 => __('No'),
1 => __('Yes')];
Dropdown::showFromArray('init_all', $values, [
'width' => '10%',
'on_change' => "form_init_all(this.value);"
]);
echo "</th></tr>";
echo "<tr><th colspan='4'>";
echo Html::hidden('id', ['value' => $ID]) . __('General history', 'ocsinventoryng') .
"</th>\n";
echo "</tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Do history', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("dohistory", $this->fields["dohistory"]);
echo "</td>\n";
echo "<td class='center'>" . __('System history', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("history_hardware", $this->fields["history_hardware"]);
echo "&nbsp;";
$fields = __('Operating system');
$fields .= "<br>";
$fields .= __('Serial of the operating system');
$fields .= "<br>";
$fields .= __('Domain');
$fields .= "<br>";
$fields .= __('Alternate username');
$fields .= "<br>";
$fields .= __('Comments');
Html::showToolTip(nl2br($fields));
echo "&nbsp;</td></tr>\n";
//history_bios
echo "<tr class='tab_bg_2'><td class='center'>" . __('Bios history', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("history_bios", $this->fields["history_bios"]);
echo "&nbsp;";
$fields = __('Serial number');
$fields .= "<br>";
$fields .= __('Model');
$fields .= "<br>";
$fields .= _n('Manufacturer', 'Manufacturers', 1);
$fields .= "<br>";
$fields .= __('Type');
$fields .= "<br>";
if (self::checkVersion($ID)) {
$fields .= __('UUID');
}
Html::showToolTip(nl2br($fields));
echo "&nbsp;</td>\n";
echo "<td class='center'>" . __('Devices history', 'ocsinventoryng') . "</td>\n<td>";
$this->showHistoryDropdown("history_devices");
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Volumes history', 'ocsinventoryng') . "</td>\n<td>";
$this->showHistoryDropdown("history_drives");
echo "</td>\n";
echo "<td class='center'>" . __('Network history', 'ocsinventoryng') . "</td>\n<td>";
$this->showHistoryDropdown("history_network");
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Monitor connection history', 'ocsinventoryng') . "</td>\n<td>";
$this->showHistoryDropdown("history_monitor");
echo "</td>\n";
echo "<td class='center'>" . __('Printer connection history', 'ocsinventoryng') . "</td>\n<td>";
$this->showHistoryDropdown("history_printer");
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Peripheral connection history', 'ocsinventoryng') . "</td>\n<td>";
$this->showHistoryDropdown("history_peripheral");
echo "</td>\n";
echo "<td class='center'>" . __('Software connection history', 'ocsinventoryng') . "</td>\n<td>";
$this->showHistoryDropdown("history_software");
echo "<tr class='tab_bg_2'><td class='center'>" . __('Virtual machines history', 'ocsinventoryng') . "</td>\n<td>";
$this->showHistoryDropdown("history_vm");
echo "<td class='center'>" . __('Administrative infos history', 'ocsinventoryng') . "</td>\n<td>";
$this->showHistoryDropdown("history_admininfos");
echo "<tr class='tab_bg_2'><td class='center'>" . __('Plugins history', 'ocsinventoryng') . "</td><td>";
$this->showHistoryDropdown("history_plugins");
echo "</td>\n";
echo "<td class='center'>" . __('OS history', 'ocsinventoryng') . "</td>\n<td>";
$this->showHistoryDropdown("history_os");
echo "</td>\n";
echo "</tr>";
if (Session::haveRight("plugin_ocsinventoryng", UPDATE)) {
echo "<tr class='tab_bg_2 center'><td colspan='4'>";
echo Html::submit(_sx('button', 'Save'), ['name' => 'update']);
echo "</td></tr>\n";
}
echo "</table>\n";
Html::closeForm();
echo "</div>\n";
}
/**
* @param $ID
*
* @internal param $withtemplate (default '')
* @internal param $templateid (default '')
*/
function ocsFormImportOptions($ID) {
$this->getFromDB($ID);
echo "<div class='center'>";
echo "<form name='formconfig' action='" . Toolbox::getItemTypeFormURL("PluginOcsinventoryngOcsServer") . "' method='post'>";
echo "<table class='tab_cadre_fixe'>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Web address of the OCSNG console', 'ocsinventoryng');
echo Html::hidden('id', ['value' => $ID]);
echo "<td>";
echo Html::input('ocs_url', ['type' => 'text',
'value' => $this->fields["ocs_url"],
'size' => 30]);
echo "</td></tr>\n";
echo "<tr><th colspan='2'>" . __('Import options', 'ocsinventoryng') . "</th></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" .
__('Limit the import to the following tags (separator $, nothing for all)', 'ocsinventoryng') . "</td>\n";
echo "<td>";
echo Html::input('tag_limit', ['type' => 'text',
'value' => $this->fields["tag_limit"],
'size' => 30]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" .
__('Exclude the following tags (separator $, nothing for all)', 'ocsinventoryng') .
"</td>\n";
echo "<td>";
echo Html::input('tag_exclude', ['type' => 'text',
'value' => $this->fields["tag_exclude"],
'size' => 30]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Behavior when disconnecting', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showFromArray("deconnection_behavior", ['' => __('Preserve link', 'ocsinventoryng'),
"trash" => __('Put the link in dustbin and add a lock', 'ocsinventoryng'),
"delete" => __('Delete the link permanently', 'ocsinventoryng')], ['value' => $this->fields["deconnection_behavior"]]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center b red' colspan='4'>";
echo __("Define the action to do on link with other objects when computer is disconnecting from them", 'ocsinventoryng');
echo "</td></tr>";
echo "<tr class='tab_bg_2'><td class='center'>" . __('Use the OCSNG software dictionary', 'ocsinventoryng') . "</td>\n<td>";
Dropdown::showYesNo("use_soft_dict", $this->fields["use_soft_dict"]);
echo "</td></tr>\n";
echo "<tr class='tab_bg_2'><td class='center b red' colspan='4'>";
echo __("If Use the OCSNG software dictionary parameter is checked, no software will be imported before you setup them into OCS", 'ocsinventoryng');
echo "</td></tr>";
echo "<tr class='tab_bg_2'><td class='center'>" .
__('Number of items to synchronize via the automatic OCSNG action', 'ocsinventoryng') .
"</td>\n<td>";
Dropdown::showNumber('cron_sync_number', ['value' => $this->fields['cron_sync_number'],
'min' => 1,
'toadd' => [0 => __('None')]]);
echo "</td></tr>";
echo "<tr class='tab_bg_2'><td class='center b red' colspan='4'>";
echo __("The automatic task ocsng is launched only if server is not in expert mode", 'ocsinventoryng');
echo "<br>" . __("The automatic task ocsng only synchronize existant computers, it doesn't import new computers", 'ocsinventoryng');
echo "<br>" . __("If you want to import new computers, disable this parameter, change to expert mode and use script from system", 'ocsinventoryng');
echo "</td></tr>";
echo "<tr class='tab_bg_2'><td class='center'>" .
__('Behavior to the deletion of a computer in OCSNG', 'ocsinventoryng') . "</td>";
echo "<td>";
$actions[0] = Dropdown::EMPTY_VALUE;
$actions[1] = __('Put in trashbin');
$dbu = new DbUtils();
foreach ($dbu->getAllDataFromTable('glpi_states') as $state) {
$actions['STATE_' . $state['id']] = sprintf(__('Change to state %s', 'ocsinventoryng'), $state['name']);
}
Dropdown::showFromArray('deleted_behavior', $actions, ['value' => $this->fields['deleted_behavior']]);
echo "</td></tr>";
echo "<tr class='tab_bg_2'><td class='center' colspan='2'>";
if (Session::haveRight("plugin_ocsinventoryng", UPDATE)) {
echo Html::submit(_sx('button', 'Save'), ['name' => 'update']);
echo "</td></tr>";
}
echo "</table>\n";
Html::closeForm();
echo "</div>";
}
/**
*
*/
function post_getEmpty() {
$this->fields['ocs_db_host'] = "localhost";
$this->fields['ocs_db_name'] = "ocsweb";
$this->fields['ocs_db_user'] = "ocsuser";
$this->fields['ocs_db_utf8'] = 1;
$this->fields['is_active'] = 1;
$this->fields['use_locks'] = 1;
}
/**
* Print simple ocs config form (database part)
*
* @param $ID integer : Id of the ocs config
* @param $options array
* - target form target
*
* @return void (display)
*/
function showForm($ID, $options = []) {
$this->initForm($ID, $options);
$this->showFormHeader($options);
$conn_type_values = [
0 => __('Database', 'ocsinventoryng'),
//1 => __('Webservice (SOAP)', 'ocsinventoryng'),
];
$sync_method_values = [
0 => __("Standard (allow manual actions)", "ocsinventoryng"),
1 => __("Expert (Fully automatic, for large configuration)", "ocsinventoryng")
];
echo "<tr class='tab_bg_1'>";
echo "<td class='center'>" . __('Connection type', 'ocsinventoryng') . "</td>";
echo "<td id='conn_type_container'>";
Dropdown::showFromArray('conn_type', $conn_type_values,
['value' => $this->fields['conn_type']]);
echo "</td>";
echo "<td class='center'>" . __("Active") . "</td>";
echo "<td>";
Dropdown::showYesNo("is_active", $this->isActive());
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td class='center'>" . __("Name") . "</td>";
echo "<td>";
echo Html::input('name', ['type' => 'text',
'value' => $this->fields["name"]]);
echo "</td>";
echo "<td class='center'>";
if ($ID) {
printf(__('%1$s : %2$s'), _n("Version", "Versions", 1), $this->fields["ocs_version"]);
}
echo "</td>";
echo "<td>";
if ($ID) {
printf(__('%1$s : %2$s'), "Checksum", $this->fields["checksum"]);
echo "&nbsp;";
Html::showSimpleForm(Toolbox::getItemTypeFormURL("PluginOcsinventoryngOcsServer"), 'force_checksum',
_sx('button', 'Reload Checksum', 'ocsinventoryng'),
['id' => $ID]);
}
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td class='center'>" . __("Host", "ocsinventoryng") . "</td>";
echo "<td>";
echo Html::input('ocs_db_host', ['type' => 'text',
'value' => $this->fields["ocs_db_host"]]);
echo "&nbsp;";
Html::showToolTip(nl2br(__('Like http://127.0.0.1 for SOAP method', 'ocsinventoryng')));
echo "</td>";
echo "<td class='center'>" . __("Synchronisation method", "ocsinventoryng") . "</td>";
echo "<td>";
Dropdown::showFromArray('use_massimport', $sync_method_values, ['value' => $this->fields['use_massimport']]);
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1 hide_if_soap' ";
if ($this->fields["conn_type"] == self::CONN_TYPE_SOAP) {
echo "style='display:none'";
}
echo "><td class='center'>" . __("Database") . "</td>";
echo "<td>";
echo Html::input('ocs_db_name', ['type' => 'text',
'value' => $this->fields["ocs_db_name"]]);
echo "</td>";
echo "<td class='center'>" . __("Database in UTF8", "ocsinventoryng") . "</td>";
echo "<td>";
Dropdown::showYesNo("ocs_db_utf8", $this->fields["ocs_db_utf8"]);
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td class='center'>" . _n("User", "Users", 1) . "</td>";
echo "<td>";
echo Html::input('ocs_db_user', ['type' => 'text',
'value' => $this->fields["ocs_db_user"]]);
echo "</td>";
echo "<td class='center' rowspan='2'>" . __("Comments") . "</td>";
echo "<td rowspan='2'><textarea cols='45' rows='6' name='comment'>" . $this->fields["comment"] . "</textarea></td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td class='center'>" . __("Password") . "</td>";
echo "<td>";
echo Html::input('ocs_db_passwd', ['type' => 'password',
'autocomplete' => 'off']);
if ($ID) {
echo Html::input('_blank_passwd', ['type' => 'checkbox']);
echo "&nbsp;" . __("Clear");
}
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td class='center'>" . __('Use automatic action for clean old agents & drop from OCSNG software', 'ocsinventoryng') . "</td>";
echo "<td>";
Dropdown::showYesNo("use_cleancron", $this->fields["use_cleancron"], -1, ['on_change' => 'hide_show_cleancron(this.value);']);
echo "</td>";
echo Html::scriptBlock("
function hide_show_cleancron(val) {
var display = (val == 0) ? 'none' : '';
var notdisplay = (val == 0) ? '' : 'none';
document.getElementById('show_cleancron_td1').style.display = display;
document.getElementById('show_cleancron_td2').style.display = display;
document.getElementById('show_cleancron_td3').style.display = notdisplay;
document.getElementById('show_cleancron_tr1').style.display = display;
}");
$style = ($this->fields["use_cleancron"]) ? "" : "style='display: none '";
$notstyle = ($this->fields["use_cleancron"]) ? "style='display: none '" : "";
echo "<td class='center' id='show_cleancron_td1' $style>" . __("Action") . "</td>";
$actions = self::getValuesActionCron();
echo "<td id='show_cleancron_td2' $style>";
Dropdown::showFromArray("action_cleancron", $actions, ['value' => $this->fields["action_cleancron"]]);
echo "</td>";
echo "<td colspan ='2' id='show_cleancron_td3' $notstyle></td>";
echo "</tr>";
echo "<tr class='tab_bg_1' id='show_cleancron_tr1' $style>";
echo "<td class='center'>" . __('Use automatic action restore deleted computer', 'ocsinventoryng') . "</td>";
echo "<td>";
Dropdown::showYesNo("use_restorationcron", $this->fields["use_restorationcron"], -1, ['on_change' => 'hide_show_restorecron(this.value);']);
echo "</td>";
echo Html::scriptBlock("
function hide_show_restorecron(val) {
var display = (val == 0) ? 'none' : '';
var notdisplay = (val == 0) ? '' : 'none';
document.getElementById('show_restorecron_td1').style.display = display;
document.getElementById('show_restorecron_td2').style.display = display;
document.getElementById('show_restorecron_td3').style.display = notdisplay;
}");
$style = ($this->fields["use_restorationcron"]) ? "" : "style='display: none '";
$notstyle = ($this->fields["use_restorationcron"]) ? "style='display: none '" : "";
echo "<td class='center' id='show_restorecron_td1' $style>" . __("Number of days for the restoration of computers from the date of last inventory", "ocsinventoryng") . "</td>";
echo "<td id='show_restorecron_td2' $style>";
Dropdown::showNumber("delay_restorationcron", ['value' => $this->fields["delay_restorationcron"]]);
echo "</td>";
echo "<td colspan ='2' id='show_restorecron_td3' $notstyle></td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td class='center'>" . __('Use automatic action to check entity assignment rules', 'ocsinventoryng');
echo "&nbsp;";
Html::showToolTip(nl2br(__('Use automatic action to check and send a notification for machines that no longer respond the entity and location assignment rules', 'ocsinventoryng')));
echo "</td>";
echo "<td colspan='3'>";
Dropdown::showYesNo("use_checkruleimportentity", $this->fields["use_checkruleimportentity"]);
echo "</td>";
echo "</tr>";
echo "<tr class='tab_bg_1'>";
echo "<td class='center'>" . __('Use automatic locks', 'ocsinventoryng') . "</td>";
echo "<td colspan='3'>";
Dropdown::showYesNo("use_locks", $this->fields["use_locks"]);
echo "</td>";
echo "</tr>";
$this->showFormButtons($options);
}
/**
* check is one of the servers use_mass_import sync mode
*
* @return boolean
* */
static function useMassImport() {
$dbu = new DbUtils();
return $dbu->countElementsInTable('glpi_plugin_ocsinventoryng_ocsservers', ["use_massimport" => 1]);
}
/**
* @param $ID
* */
function showDBConnectionStatus($ID) {
$out = "<br><div class='center'>\n";
$out .= "<table class='tab_cadre_fixe'>";
$out .= "<tr><th>" . __('Connecting to the database', 'ocsinventoryng') . "</th></tr>\n";
$out .= "<tr class='tab_bg_2'>";
if ($ID != -1) {
if (!self::checkOCSconnection($ID)) {
$out .= "<td class='center red'>" . __('Connection to the database failed', 'ocsinventoryng');
} else if (!self::checkVersion($ID)) {
$out .= "<td class='center red'>" . __('Invalid OCSNG Version: RC3 is required', 'ocsinventoryng');
} else if (!self::checkTraceDeleted($ID)) {
$out .= "<td class='center red'>" . __('Invalid OCSNG configuration (TRACE_DELETED must be active)', 'ocsinventoryng');
// TODO
/* } else if (!self::checkConfig(4)) {
$out .= __('Access denied on database (Need write rights on hardware.CHECKSUM necessary)',
'ocsinventoryng');
} else if (!self::checkConfig(8)) {
$out .= __('Access denied on database (Delete rights in deleted_equiv table necessary)',
'ocsinventoryng'); */
} else {
$out .= "<td class='center'>" . __('Connection to database successful', 'ocsinventoryng');
$out .= "</td></tr>\n<tr class='tab_bg_2'>" .
"<td class='center'>" . __('Valid OCSNG configuration and version', 'ocsinventoryng');
}
}
$out .= "</td></tr>\n";
$out .= "</table></div>";
echo $out;
}
/**
* @param datas $input
*
* @return datas
*/
function prepareInputForUpdate($input) {
$adm = new PluginOcsinventoryngOcsAdminInfosLink();
$adm->updateAdminInfo($input);
if (isset($input["ocs_db_passwd"]) && !empty($input["ocs_db_passwd"])) {
$input["ocs_db_passwd"] = rawurlencode(stripslashes($input["ocs_db_passwd"]));
$input["ocs_db_passwd"] = Toolbox::encrypt(stripslashes($input["ocs_db_passwd"]),
GLPIKEY);
} else {
unset($input["ocs_db_passwd"]);
}
if (isset($input["_blank_passwd"]) && $input["_blank_passwd"]) {
$input['ocs_db_passwd'] = '';
}
return $input;
}
/**
*
*/
function pre_updateInDB() {
// Update checksum
$checksum = 0;
if (//$this->fields["import_device_processor"] ||
$this->fields["import_general_contact"]
|| $this->fields["import_general_comment"]
|| $this->fields["import_general_domain"]
|| $this->fields["import_general_os"]
|| $this->fields["import_general_name"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::HARDWARE_FL);
}
if ($this->fields["import_device_bios"]) {
$checksum |= $checksum + pow(2, PluginOcsinventoryngOcsProcess::BIOS_FL);
}
if ($this->fields["import_device_memory"]) {
$checksum |= $checksum + pow(2, PluginOcsinventoryngOcsProcess::MEMORIES_FL);
}
if ($this->fields["import_registry"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::REGISTRY_FL);
}
if ($this->fields["import_device_controller"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::CONTROLLERS_FL);
}
if ($this->fields["import_device_slot"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::SLOTS_FL);
}
if ($this->fields["import_monitor"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::MONITORS_FL);
}
if ($this->fields["import_device_port"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::PORTS_FL);
}
if ($this->fields["import_device_hdd"] || $this->fields["import_device_drive"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::STORAGES_FL);
}
if ($this->fields["import_disk"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::DRIVES_FL);
}
if ($this->fields["import_periph"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::INPUTS_FL);
}
if ($this->fields["import_device_modem"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::MODEMS_FL);
}
if ($this->fields["import_ip"]
|| $this->fields["import_device_iface"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::NETWORKS_FL);
}
if ($this->fields["import_printer"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::PRINTERS_FL);
}
if ($this->fields["import_device_sound"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::SOUNDS_FL);
}
if ($this->fields["import_device_gfxcard"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::VIDEOS_FL);
}
if ($this->fields["import_software"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::SOFTWARES_FL);
}
if ($this->fields["import_vms"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::VIRTUALMACHINES_FL);
}
if ($this->fields["import_device_processor"]) {
$checksum |= pow(2, PluginOcsinventoryngOcsProcess::CPUS_FL);
}
$this->updates[] = "checksum";
$this->fields["checksum"] = $checksum;
}
/**
* @param datas $input
*
* @return bool|datas
*/
function prepareInputForAdd($input) {
global $DB;
// Check if server config does not exists
$query = "SELECT *
FROM `" . $this->getTable() . "`
WHERE `name` = '" . $input['name'] . "';";
$result = $DB->query($query);
if ($DB->numrows($result) > 0) {
Session::addMessageAfterRedirect(__('Unable to add. The OCSNG server already exists.', 'ocsinventoryng'), false, ERROR);
return false;
}
if (isset($input["ocs_db_passwd"]) && !empty($input["ocs_db_passwd"])) {
$input["ocs_db_passwd"] = rawurlencode(stripslashes($input["ocs_db_passwd"]));
$input["ocs_db_passwd"] = Toolbox::encrypt(stripslashes($input["ocs_db_passwd"]),
GLPIKEY);
} else {
unset($input["ocs_db_passwd"]);
}
return $input;
}
/**
*
*/
function post_addItem() {
global $DB;
$query = "INSERT INTO `glpi_plugin_ocsinventoryng_ocsservers_profiles` (`id` ,`plugin_ocsinventoryng_ocsservers_id` , `profiles_id`)
VALUES (NULL , '" . $this->fields['id'] . "', '" . $_SESSION["glpiactiveprofile"]['id'] . "');";
$DB->query($query);
}
/**
*
*/
function cleanDBonPurge() {
$link = new PluginOcsinventoryngOcslink();
$link->deleteByCriteria(['plugin_ocsinventoryng_ocsservers_id' => $this->fields['id']]);
$admin = new PluginOcsinventoryngOcsAdminInfosLink();
$admin->deleteByCriteria(['plugin_ocsinventoryng_ocsservers_id' => $this->fields['id']]);
$server = new PluginOcsinventoryngServer();
$server->deleteByCriteria(['plugin_ocsinventoryng_ocsservers_id' => $this->fields['id']]);
$detail = new PluginOcsinventoryngDetail();
$detail->deleteByCriteria(['plugin_ocsinventoryng_ocsservers_id' => $this->fields['id']]);
$notimported = new PluginOcsinventoryngNotimportedcomputer();
$notimported->deleteByCriteria(['plugin_ocsinventoryng_ocsservers_id' => $this->fields['id']]);
$iplink = new PluginOcsinventoryngIpdiscoverOcslink();
$iplink->deleteByCriteria(['plugin_ocsinventoryng_ocsservers_id' => $this->fields['id']]);
$snmplink = new PluginOcsinventoryngSnmpOcslink();
$snmplink->deleteByCriteria(['plugin_ocsinventoryng_ocsservers_id' => $this->fields['id']]);
$prof = new PluginOcsinventoryngOcsserver_Profile();
$prof->deleteByCriteria(['plugin_ocsinventoryng_ocsservers_id' => $this->fields['id']]);
$thread = new PluginOcsinventoryngThread();
$thread->deleteByCriteria(['plugin_ocsinventoryng_ocsservers_id' => $this->fields['id']]);
unset($_SESSION["plugin_ocsinventoryng_ocsservers_id"]);
// ocsservers_id for RuleImportComputer, OCS_SERVER for RuleImportEntity
Rule::cleanForItemCriteria($this);
Rule::cleanForItemCriteria($this, 'OCS_SERVER');
}
/**
* Get the ocs server id of a machine, by giving the machine id
*
* @param $ID the machine ID
*
* return the ocs server id of the machine
*
* @return int
*/
static function getServerByComputerID($ID) {
global $DB;
$sql = "SELECT `plugin_ocsinventoryng_ocsservers_id`
FROM `glpi_plugin_ocsinventoryng_ocslinks`
WHERE `glpi_plugin_ocsinventoryng_ocslinks`.`computers_id` = $ID";
$result = $DB->query($sql);
if ($DB->numrows($result) > 0) {
$datas = $DB->fetch_array($result);
return $datas["plugin_ocsinventoryng_ocsservers_id"];
}
return -1;
}
/**
* Get a random plugin_ocsinventoryng_ocsservers_id
* use for standard sync server selection
*
* return an ocs server id
* */
static function getRandomServerID() {
global $DB;
$sql = "SELECT `id`
FROM `glpi_plugin_ocsinventoryng_ocsservers`
WHERE `is_active` = 1
AND `use_massimport` = 0
ORDER BY RAND()
LIMIT 1";
$result = $DB->query($sql);
if ($DB->numrows($result) > 0) {
$datas = $DB->fetch_array($result);
return $datas["id"];
}
return -1;
}
/**
* @return int|Value
*/
static function getFirstServer() {
global $DB;
$query = "SELECT `glpi_plugin_ocsinventoryng_ocsservers`.`id`
FROM `glpi_plugin_ocsinventoryng_ocsservers_profiles`
LEFT JOIN `glpi_plugin_ocsinventoryng_ocsservers`
ON `glpi_plugin_ocsinventoryng_ocsservers`.`id` = `glpi_plugin_ocsinventoryng_ocsservers_profiles`.`plugin_ocsinventoryng_ocsservers_id`
WHERE `glpi_plugin_ocsinventoryng_ocsservers`.`is_active`= 1
ORDER BY `glpi_plugin_ocsinventoryng_ocsservers`.`id` ASC LIMIT 1 ";
$results = $DB->query($query);
if ($DB->numrows($results) > 0) {
return $DB->result($results, 0, 'id');
}
return -1;
}
/**
* Get OCSNG mode configuration
*
* Get all config of the OCSNG mode
*
* @param $id int : ID of the OCS config (default value 1)
*
* @return int|null|string[] of $confVar fields or false if unfound.
* @throws \GlpitestSQLError
*/
static function getConfig($id) {
global $DB;
$data = 0;
if (!empty($id)) {
$query = "SELECT *
FROM `glpi_plugin_ocsinventoryng_ocsservers`
WHERE `id` = $id";
$result = $DB->query($query);
if ($result) {
$data = $DB->fetch_assoc($result);
}
}
return $data;
}
/**
* @param $ocs_config
* @param $itemtype
*
* @return mixed
*/
static function getDevicesManagementMode($ocs_config, $itemtype) {
switch ($itemtype) {
case 'Monitor':
return $ocs_config["import_monitor"];
case 'Printer':
return $ocs_config["import_printer"];
case 'Peripheral':
return $ocs_config["import_periph"];
}
}
/**
* Check if OCS connection is still valid
* If not, then establish a new connection on the good server
*
* @param $serverId
*
* @return bool
* @internal param the $plugin_ocsinventoryng_ocsservers_id ocs server id
*
*/
static function checkOCSconnection($serverId) {
return self::getDBocs($serverId)->checkConnection();
}
/**
* Get a connection to the OCS server
*
* @param $serverId the ocs server id
*
* @return PluginOcsinventoryngOcsClient the ocs client (database or soap)
*/
static function getDBocs($serverId) {
$config = self::getConfig($serverId);
if ($config['conn_type'] == self::CONN_TYPE_DB) {
return new PluginOcsinventoryngOcsDbClient(
$serverId, $config['ocs_db_host'], $config['ocs_db_user'],
Toolbox::decrypt($config['ocs_db_passwd'], GLPIKEY), $config['ocs_db_name']
);
} else {
return new PluginOcsinventoryngOcsSoapClient(
$serverId, $config['ocs_db_host'], $config['ocs_db_user'],
Toolbox::decrypt($config['ocs_db_passwd'], GLPIKEY)
);
}
}
/**
* get true if the server is active
*
* @param $serverID
*
* @return bool
*/
static function serverIsActive($serverID) {
$ocsserver = new self();
if ($ocsserver->getFromDB($serverID)) {
return $ocsserver->isActive();
}
return false;
}
/**
* @param $cfg_ocs
*
* @return string
*/
static function getTagLimit($cfg_ocs) {
$WHERE = "";
if (!empty($cfg_ocs["tag_limit"])) {
$splitter = explode("$", trim($cfg_ocs["tag_limit"]));
if (count($splitter)) {
$WHERE = " `accountinfo`.`TAG` = '" . $splitter[0] . "' ";
for ($i = 1; $i < count($splitter); $i++) {
$WHERE .= " OR `accountinfo`.`TAG` = '" . $splitter[$i] . "' ";
}
}
}
if (!empty($cfg_ocs["tag_exclude"])) {
$splitter = explode("$", $cfg_ocs["tag_exclude"]);
if (count($splitter)) {
if (!empty($WHERE)) {
$WHERE .= " AND ";
}
$WHERE .= " `accountinfo`.`TAG` <> '" . $splitter[0] . "' ";
for ($i = 1; $i < count($splitter); $i++) {
$WHERE .= " AND `accountinfo`.`TAG` <> '" . $splitter[$i] . "' ";
}
}
}
return $WHERE;
}
/**
* @param $ID
*
* @return bool
*/
public static function checkVersion($ID) {
$client = self::getDBocs($ID);
$version = $client->getTextConfig('GUI_VERSION');
if ($version) {
$server = new self();
$server->update([
'id' => $ID,
'ocs_version' => $version
]);
}
return true;
if (!$version || ($version < self::OCS_VERSION_LIMIT && strpos($version, '2.0') !== 0)) { // hack for 2.0 RC
return false;
} else {
return true;
}
}
/**
* @param $ID
*
* @return int
*/
public static function checkTraceDeleted($ID) {
$client = self::getDBocs($ID);
return $client->getIntConfig('TRACE_DELETED');
}
/**
* Displays a list of computers that can be cleaned.
*
* @param $plugin_ocsinventoryng_ocsservers_id int : id of ocs server in GLPI
* @param $check string : parameter for HTML input checkbox
* @param $start int : parameter for Html::printPager method
*
*
* @return bool
*/
static function showComputersToClean($show_params) {
global $DB, $CFG_GLPI;
$plugin_ocsinventoryng_ocsservers_id = $show_params["plugin_ocsinventoryng_ocsservers_id"];
$check = $show_params["check"];
$start = $show_params["start"];
self::checkOCSconnection($plugin_ocsinventoryng_ocsservers_id);
if (!Session::haveRight("plugin_ocsinventoryng_clean", READ)) {
return false;
}
$canedit = Session::haveRight("plugin_ocsinventoryng_clean", UPDATE);
// Select unexisting OCS hardware
$ocsClient = self::getDBocs($plugin_ocsinventoryng_ocsservers_id);
$computerOptions = [
'COMPLETE' => '0',
];
$computers = $ocsClient->getComputers($computerOptions);
if (isset($computers['COMPUTERS'])
&& count($computers['COMPUTERS']) > 0) {
$hardware = $computers['COMPUTERS'];
unset($computers);
} else {
$hardware = [];
}
$query = "SELECT `ocsid`
FROM `glpi_plugin_ocsinventoryng_ocslinks`
WHERE `plugin_ocsinventoryng_ocsservers_id`
= $plugin_ocsinventoryng_ocsservers_id";
$result = $DB->query($query);
$ocs_missing = [];
if ($DB->numrows($result) > 0) {
while ($data = $DB->fetch_array($result)) {
$data = Toolbox::clean_cross_side_scripting_deep(Toolbox::addslashes_deep($data));
if (!isset($hardware[$data["ocsid"]])) {
$ocs_missing[$data["ocsid"]] = $data["ocsid"];
}
}
}
//Select unexisting computers
$query_glpi = "SELECT `glpi_plugin_ocsinventoryng_ocslinks`.`entities_id` AS entities_id,
`glpi_plugin_ocsinventoryng_ocslinks`.`ocs_deviceid` AS ocs_deviceid,
`glpi_plugin_ocsinventoryng_ocslinks`.`last_update` AS last_update,
`glpi_plugin_ocsinventoryng_ocslinks`.`ocsid` AS ocsid,
`glpi_plugin_ocsinventoryng_ocslinks`.`id`,
`glpi_computers`.`name` AS name
FROM `glpi_plugin_ocsinventoryng_ocslinks`
LEFT JOIN `glpi_computers`
ON `glpi_computers`.`id` = `glpi_plugin_ocsinventoryng_ocslinks`.`computers_id`
WHERE ((`glpi_computers`.`id` IS NULL
AND `glpi_plugin_ocsinventoryng_ocslinks`.`plugin_ocsinventoryng_ocsservers_id`
= $plugin_ocsinventoryng_ocsservers_id)";
if (count($ocs_missing)) {
$query_glpi .= " OR `ocsid` IN ('" . implode("','", $ocs_missing) . "')";
}
$dbu = new DbUtils();
$query_glpi .= ") " . $dbu->getEntitiesRestrictRequest(" AND", "glpi_plugin_ocsinventoryng_ocslinks");
$result_glpi = $DB->query($query_glpi);
// fetch all links missing between glpi and OCS
$already_linked = [];
if ($DB->numrows($result_glpi) > 0) {
while ($data = $DB->fetch_assoc($result_glpi)) {
$data = Toolbox::clean_cross_side_scripting_deep(Toolbox::addslashes_deep($data));
$already_linked[$data["ocsid"]]["entities_id"] = $data["entities_id"];
$already_linked[$data["ocsid"]]["ocs_deviceid"] = $data["ocs_deviceid"];
$already_linked[$data["ocsid"]]["date"] = $data["last_update"];
$already_linked[$data["ocsid"]]["id"] = $data["id"];
$already_linked[$data["ocsid"]]["in_ocs"] = isset($hardware[$data["ocsid"]]);
if ($data["name"] == null) {
$already_linked[$data["ocsid"]]["in_glpi"] = 0;
} else {
$already_linked[$data["ocsid"]]["in_glpi"] = 1;
}
}
}
echo "<div class='center'>";
echo "<h2>" . __('Clean links between GLPI and OCSNG', 'ocsinventoryng') . "</h2>";
$target = $CFG_GLPI['root_doc'] . '/plugins/ocsinventoryng/front/ocsng.clean.php';
if (($numrows = count($already_linked)) > 0) {
$parameters = "check=$check";
Html::printPager($start, $numrows, $target, $parameters);
// delete end
array_splice($already_linked, $start + $_SESSION['glpilist_limit']);
// delete begin
if ($start > 0) {
array_splice($already_linked, 0, $start);
}
echo "<form method='post' id='ocsng_form' name='ocsng_form' action='" . $target . "'>";
if ($canedit) {
self::checkBox($target);
}
echo "<table class='tab_cadre'>";
echo "<tr><th>" . __('Item') . "</th><th>" . __('Import date in GLPI', 'ocsinventoryng') . "</th>";
echo "<th>" . __('Existing in GLPI', 'ocsinventoryng') . "</th>";
echo "<th>" . __('Existing in OCSNG', 'ocsinventoryng') . "</th>";
if (Session::isMultiEntitiesMode()) {
echo "<th>" . __('Entity') . "</th>";
}
if ($canedit) {
echo "<th>&nbsp;</th>";
}
echo "</tr>\n";
echo "<tr class='tab_bg_1'><td colspan='6' class='center'>";
if ($canedit) {
echo Html::submit(_sx('button', 'Clean'), ['name' => 'clean_ok']);
}
echo "</td></tr>\n";
foreach ($already_linked as $ID => $tab) {
echo "<tr class='tab_bg_2 center'>";
echo "<td>" . $tab["ocs_deviceid"] . "</td>\n";
echo "<td>" . Html::convDateTime($tab["date"]) . "</td>\n";
echo "<td>" . Dropdown::getYesNo($tab["in_glpi"]) . "</td>\n";
echo "<td>" . Dropdown::getYesNo($tab["in_ocs"]) . "</td>\n";
if (Session::isMultiEntitiesMode()) {
echo "<td>" . Dropdown::getDropdownName('glpi_entities', $tab['entities_id']) . "</td>\n";
}
if ($canedit) {
echo "<td><input type='checkbox' name='toclean[" . $tab["id"] . "]' " .
(($check == "all") ? "checked" : "") . "></td>";
}
echo "</tr>\n";
}
echo "<tr class='tab_bg_1'><td colspan='6' class='center'>";
if ($canedit) {
echo Html::submit(_sx('button', 'Clean'), ['name' => 'clean_ok']);
}
echo "</td></tr>";
echo "</table>\n";
Html::closeForm();
Html::printPager($start, $numrows, $target, $parameters);
} else {
echo "<div class='center b '>" . __('No item to clean', 'ocsinventoryng') . "</div>";
echo "<a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/ocsng.php'>";
echo __('Back');
echo "</a>";
}
echo "</div>";
}
/**
* @param $plugin_ocsinventoryng_ocsservers_id
* @param $check
* @param $start
*
* @return bool|void
*/
static function showComputersToSynchronize($show_params) {
global $DB, $CFG_GLPI;
$plugin_ocsinventoryng_ocsservers_id = $show_params["plugin_ocsinventoryng_ocsservers_id"];
$check = $show_params["check"];
$start = $show_params["start"];
self::checkOCSconnection($plugin_ocsinventoryng_ocsservers_id);
if (!Session::haveRight("plugin_ocsinventoryng", UPDATE)
&& !Session::haveRight("plugin_ocsinventoryng_sync", UPDATE)) {
return false;
}
$cfg_ocs = self::getConfig($plugin_ocsinventoryng_ocsservers_id);
// Get linked computer ids in GLPI
$already_linked_query = "SELECT `glpi_plugin_ocsinventoryng_ocslinks`.`ocsid` AS ocsid
FROM `glpi_plugin_ocsinventoryng_ocslinks`
WHERE `glpi_plugin_ocsinventoryng_ocslinks`.`plugin_ocsinventoryng_ocsservers_id`
= $plugin_ocsinventoryng_ocsservers_id";
$already_linked_result = $DB->query($already_linked_query);
if ($DB->numrows($already_linked_result) == 0) {
echo "<div class='center b'>" . __('No new computer to be updated', 'ocsinventoryng');
echo "<br><a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/ocsng.php'>";
echo __('Back');
echo "</a>";
echo "</div>";
return;
}
$already_linked_ids = [];
while ($data = $DB->fetch_assoc($already_linked_result)) {
$already_linked_ids [] = $data['ocsid'];
}
$query = "SELECT MAX(`last_ocs_update`)
FROM `glpi_plugin_ocsinventoryng_ocslinks`
WHERE `plugin_ocsinventoryng_ocsservers_id`=$plugin_ocsinventoryng_ocsservers_id";
$max_date = "0000-00-00 00:00:00";
if ($result = $DB->query($query)) {
if ($DB->numrows($result) > 0) {
$max_date = $DB->result($result, 0, 0);
}
}
// Fetch linked computers from ocs
$ocsClient = self::getDBocs($plugin_ocsinventoryng_ocsservers_id);
$ocsResult = $ocsClient->getComputers([
'ORDER' => 'LASTDATE',
'COMPLETE' => '0',
'FILTER' => [
'IDS' => $already_linked_ids,
'CHECKSUM' => $cfg_ocs["checksum"],
//'INVENTORIED_BEFORE' => 'NOW()',
//'INVENTORIED_SINCE' => $max_date,
]
]);
if (isset($ocsResult['COMPUTERS'])) {
if (count($ocsResult['COMPUTERS']) > 0) {
// Get all ids of the returned computers
$ocs_computer_ids = [];
$hardware = [];
$computers = array_slice($ocsResult['COMPUTERS'], $start, $_SESSION['glpilist_limit']);
foreach ($computers as $computer) {
$ID = $computer['META']['ID'];
$ocs_computer_ids [] = $ID;
$hardware[$ID]["date"] = $computer['META']["LASTDATE"];
$hardware[$ID]["checksum"] = $computer['META']["CHECKSUM"];
$hardware[$ID]["tag"] = $computer['META']["TAG"];
$hardware[$ID]["name"] = addslashes($computer['META']["NAME"]);
}
// Fetch all linked computers from GLPI that were returned from OCS
$query_glpi = "SELECT `glpi_plugin_ocsinventoryng_ocslinks`.`last_update` AS last_update,
`glpi_plugin_ocsinventoryng_ocslinks`.`computers_id` AS computers_id,
`glpi_computers`.`serial` AS serial,
`glpi_plugin_ocsinventoryng_ocslinks`.`ocsid` AS ocsid,
`glpi_computers`.`name` AS name,
`glpi_plugin_ocsinventoryng_ocslinks`.`use_auto_update`,
`glpi_plugin_ocsinventoryng_ocslinks`.`id`
FROM `glpi_plugin_ocsinventoryng_ocslinks`
LEFT JOIN `glpi_computers` ON (`glpi_computers`.`id`= `glpi_plugin_ocsinventoryng_ocslinks`.`computers_id`)
WHERE `glpi_plugin_ocsinventoryng_ocslinks`.`plugin_ocsinventoryng_ocsservers_id`
= $plugin_ocsinventoryng_ocsservers_id
AND `glpi_plugin_ocsinventoryng_ocslinks`.`ocsid` IN (" . implode(',', $ocs_computer_ids) . ")
ORDER BY `glpi_plugin_ocsinventoryng_ocslinks`.`use_auto_update` DESC,
`last_update`,
`name`";
$result_glpi = $DB->query($query_glpi);
// Get all links between glpi and OCS
$already_linked = [];
if ($DB->numrows($result_glpi) > 0) {
while ($data = $DB->fetch_assoc($result_glpi)) {
$data = Toolbox::clean_cross_side_scripting_deep(Toolbox::addslashes_deep($data));
if (isset($hardware[$data["ocsid"]])) {
$already_linked[$data["ocsid"]]["date"] = $data["last_update"];
$already_linked[$data["ocsid"]]["name"] = $data["name"];
if ($_SESSION["glpiis_ids_visible"] || empty($data["name"])) {
$already_linked[$data["ocsid"]]["name"] = sprintf(__('%1$s (%2$s)'), $data["name"], $data["id"]);
}
$already_linked[$data["ocsid"]]["id"] = $data["id"];
$already_linked[$data["ocsid"]]["computers_id"] = $data["computers_id"];
$already_linked[$data["ocsid"]]["serial"] = $data["serial"];
$already_linked[$data["ocsid"]]["ocsid"] = $data["ocsid"];
$already_linked[$data["ocsid"]]["use_auto_update"] = $data["use_auto_update"];
}
}
}
echo "<div class='center'>";
echo "<h2>" . __('Computers updated in OCSNG', 'ocsinventoryng') . "</h2>";
$target = $CFG_GLPI['root_doc'] . '/plugins/ocsinventoryng/front/ocsng.sync.php';
if (($numrows = $ocsResult['TOTAL_COUNT']) > 0) {
$parameters = "check=$check";
Html::printPager($start, $numrows, $target, $parameters);
echo "<form method='post' id='ocsng_form' name='ocsng_form' action='" . $target . "'>";
self::checkBox($target);
echo "<table class='tab_cadre_fixe'>";
$colspan = 6;
if ($_SESSION['glpi_use_mode'] == Session::DEBUG_MODE) {
$colspan = 7;
}
echo "<tr class='tab_bg_1'><td colspan='$colspan' class='center'>";
echo Html::submit(_sx('button', 'Synchronize'),
['name' => 'update_ok']);
echo "</td></tr>\n";
echo "<tr><th>" . __('Update computers', 'ocsinventoryng') . "</th>";
echo "<th>" . __('Serial number') . "</th>";
echo "<th>" . __('Import date in GLPI', 'ocsinventoryng') . "</th>";
echo "<th>" . __('Last OCSNG inventory date', 'ocsinventoryng') . "</th>";
echo "<th>" . __('OCSNG TAG', 'ocsinventoryng') . "</th>";
if ($_SESSION['glpi_use_mode'] == Session::DEBUG_MODE) {
echo "<th>" . __('DEBUG') . "</th>";
}
echo "<th>&nbsp;</th></tr>\n";
foreach ($already_linked as $ID => $tab) {
echo "<tr class='tab_bg_2 center'>";
echo "<td><a href='" . $CFG_GLPI["root_doc"] . "/front/computer.form.php?id=" .
$tab["computers_id"] . "'>" . $tab["name"] . "</a></td>\n";
echo "<td>" . $tab["serial"] . "</td>\n";
echo "<td>" . Html::convDateTime($tab["date"]) . "</td>\n";
echo "<td>" . Html::convDateTime($hardware[$tab["ocsid"]]["date"]) . "</td>\n";
echo "<td>" . $hardware[$tab["ocsid"]]["tag"] . "</td>\n";
if ($_SESSION['glpi_use_mode'] == Session::DEBUG_MODE) {
echo "<td>";
$checksum_server = intval($cfg_ocs["checksum"]);
$checksum_client = intval($hardware[$tab["ocsid"]]["checksum"]);
if ($checksum_client > 0
&& $checksum_client > 0
) {
$result = $checksum_server & $checksum_client;
echo intval($result);
}
echo "</td>";
}
echo "<td><input type='checkbox' name='toupdate[" . $tab["id"] . "]' " .
(($check == "all") ? "checked" : "") . "></td></tr>\n";
}
echo "<tr class='tab_bg_1'><td colspan='$colspan' class='center'>";
echo Html::submit(_sx('button', 'Synchronize'), ['name' => 'update_ok']);
echo Html::hidden('plugin_ocsinventoryng_ocsservers_id',
['value' => $plugin_ocsinventoryng_ocsservers_id]);
echo "</td></tr>";
echo "<tr class='tab_bg_1'><td colspan='$colspan' class='center'>";
self::checkBox($target);
echo "</table>\n";
Html::closeForm();
Html::printPager($start, $numrows, $target, $parameters);
} else {
echo "<br><span class='b'>" . __('Update computers', 'ocsinventoryng') . "</span>";
}
echo "</div>";
} else {
echo "<div class='center b'>" . __('No new computer to be updated', 'ocsinventoryng');
echo "<br><a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/ocsng.php'>";
echo __('Back');
echo "</a>";
echo "</div>";
}
} else {
echo "<div class='center b'>" . __('No new computer to be updated', 'ocsinventoryng');
echo "<br><a href='" . $CFG_GLPI["root_doc"] . "/plugins/ocsinventoryng/front/ocsng.php'>";
echo __('Back');
echo "</a>";
echo "</div>";
}
}
/**
* Display a list of computers to add or to link
*
* @param $show_params
*
* @return bool
* @throws \GlpitestSQLError
* @internal param the $plugin_ocsinventoryng_ocsservers_id ID of the ocs server
* @internal param display $advanced detail about the computer import or not (target entity, matched rules, etc.)
* @internal param indicates $check if checkboxes are checked or not
* @internal param display $start a list of computers starting at rowX
* @internal param a $entities_id list of entities in which computers can be added or linked
* @internal param false $tolinked for an import, true for a link
*
*/
static function showComputersToAdd($show_params) {
global $DB, $CFG_GLPI;
$plugin_ocsinventoryng_ocsservers_id = $show_params["plugin_ocsinventoryng_ocsservers_id"];
$advanced = $show_params["import_mode"];
$check = $show_params["check"];
$start = $show_params["start"];
$entities_id = $show_params["entities_id"];
$tolinked = $show_params["tolinked"];
self::checkOCSconnection($plugin_ocsinventoryng_ocsservers_id);
if (!Session::haveRight("plugin_ocsinventoryng", READ)
&& !Session::haveRight("plugin_ocsinventoryng_import", READ)
&& !Session::haveRight("plugin_ocsinventoryng_link", READ)) {
return false;
}
$caneditimport = Session::haveRight('plugin_ocsinventoryng_import', UPDATE);
$caneditlink = Session::haveRight('plugin_ocsinventoryng_link', UPDATE);
$usecheckbox = ($tolinked && $caneditlink) || (!$tolinked && $caneditimport);
$title = __('Import new computers', 'ocsinventoryng');
if ($tolinked) {
$title = __('Link new OCSNG computers to existing GLPI computers', 'ocsinventoryng');
}
$target = $CFG_GLPI['root_doc'] . '/plugins/ocsinventoryng/front/ocsng.import.php';
if ($tolinked) {
$target = $CFG_GLPI['root_doc'] . '/plugins/ocsinventoryng/front/ocsng.link.php';
}
// Get all links between glpi and OCS
$query_glpi = "SELECT ocsid
FROM `glpi_plugin_ocsinventoryng_ocslinks`
WHERE `plugin_ocsinventoryng_ocsservers_id` = $plugin_ocsinventoryng_ocsservers_id";
$result_glpi = $DB->query($query_glpi);
$already_linked = [];
if ($DB->numrows($result_glpi) > 0) {
while ($data = $DB->fetch_array($result_glpi)) {
$already_linked [] = $data["ocsid"];
}
}
$cfg_ocs = self::getConfig($plugin_ocsinventoryng_ocsservers_id);
$computerOptions = ['ORDER' => 'LASTDATE',
'COMPLETE' => '0',
'FILTER' => [
'EXCLUDE_IDS' => $already_linked
],
'DISPLAY' => [
'CHECKSUM' => PluginOcsinventoryngOcsClient::CHECKSUM_BIOS | PluginOcsinventoryngOcsClient::CHECKSUM_NETWORK_ADAPTERS
],
'ORDER' => 'NAME'
];
if ($cfg_ocs["tag_limit"] and $tag_limit = explode("$", trim($cfg_ocs["tag_limit"]))) {
$computerOptions['FILTER']['TAGS'] = $tag_limit;
}
if ($cfg_ocs["tag_exclude"] and $tag_exclude = explode("$", trim($cfg_ocs["tag_exclude"]))) {
$computerOptions['FILTER']['EXCLUDE_TAGS'] = $tag_exclude;
}
$ocsClient = self::getDBocs($plugin_ocsinventoryng_ocsservers_id);
$allComputers = $ocsClient->countComputers($computerOptions);
if ($start != 0) {
$computerOptions['OFFSET'] = $start;
}
$computerOptions['MAX_RECORDS'] = $_SESSION['glpilist_limit'];
$ocsResult = $ocsClient->getComputers($computerOptions);
$computers = (isset($ocsResult['COMPUTERS']) ? $ocsResult['COMPUTERS'] : []);
$hardware = [];
if (isset($computers)) {
if (count($computers)) {
// Get all hardware from OCS DB
foreach ($computers as $data) {
$data = Toolbox::clean_cross_side_scripting_deep(Toolbox::addslashes_deep($data));
$id = $data['META']['ID'];
$hardware[$id]["date"] = $data['META']["LASTDATE"];
$hardware[$id]["name"] = $data['META']["NAME"];
$hardware[$id]["TAG"] = $data['META']["TAG"];
$hardware[$id]["id"] = $data['META']["ID"];
$hardware[$id]["UUID"] = $data['META']["UUID"];
$contact = $data['META']["USERID"];
if (!empty($contact)) {
$query = "SELECT `id`
FROM `glpi_users`
WHERE `name` = '" . $contact . "';";
$result = $DB->query($query);
$hardware[$id]["locations_id"] = 0;
if ($DB->numrows($result) == 1) {
$user_id = $DB->result($result, 0, 0);
$user = new User();
$user->getFromDB($user_id);
$hardware[$id]["locations_id"] = $user->fields["locations_id"];
}
}
if (isset($data['BIOS']) && count($data['BIOS'])) {
$hardware[$id]["serial"] = $data['BIOS']["SSN"];
$hardware[$id]["model"] = $data['BIOS']["SMODEL"];
$hardware[$id]["manufacturer"] = $data['BIOS']["SMANUFACTURER"];
} else {
$hardware[$id]["serial"] = '';
$hardware[$id]["model"] = '';
$hardware[$id]["manufacturer"] = '';
}
if (isset($data['NETWORKS']) && count($data['NETWORKS'])) {
$hardware[$id]["NETWORKS"] = $data["NETWORKS"];
}
}
if ($tolinked && count($hardware)) {
echo "<div class='center b'>" .
__('Caution! The imported data (see your configuration) will overwrite the existing one', 'ocsinventoryng') . "</div>";
}
echo "<div class='center'>";
if ($numrows = count($allComputers)) {
$parameters = "check=$check";
Html::printPager($start, $numrows, $target, $parameters);
//Show preview form only in import even in multi-entity mode because computer import
//can be refused by a rule
if (!$tolinked) {
echo "<div class='firstbloc'>";
echo "<form method='post' name='ocsng_import_mode' id='ocsng_import_mode'
action='$target'>\n";
echo "<table class='tab_cadre_fixe'>";
echo "<tr><th>" . __('Manual import mode', 'ocsinventoryng') . "</th></tr>\n";
echo "<tr class='tab_bg_1'><td class='center'>";
if ($advanced) {
Html::showSimpleForm($target, 'change_import_mode', __('Disable preview', 'ocsinventoryng'), ['id' => 'false']);
} else {
Html::showSimpleForm($target, 'change_import_mode', __('Enable preview', 'ocsinventoryng'), ['id' => 'true']);
}
echo "</td></tr>";
echo "<tr class='tab_bg_1'><td class='center b'>" .
__('Check first that duplicates have been correctly managed in OCSNG', 'ocsinventoryng') . "</td>";
echo "</tr></table>";
Html::closeForm();
echo "</div>";
}
echo "<form method='post' name='ocsng_form' id='ocsng_form' action='$target'>";
if ($usecheckbox) {
self::checkBox($target);
}
echo "<table class='tab_cadrehov'>";
if ($usecheckbox) {
$nb_cols = 6;
if ($advanced && !$tolinked) {
$nb_cols += 3;
}
if ($tolinked) {
$nb_cols += 1;
}
if (($tolinked && $caneditlink) || (!$tolinked && $caneditimport)) {
$nb_cols += 1;
}
echo "<tr class='tab_bg_1'><td colspan='" . $nb_cols . "' class='center'>";
if (($tolinked && $caneditlink)) {
echo Html::submit(_sx('button', 'Link', 'ocsinventoryng'), ['name' => 'import_ok']);
echo Html::submit(_sx('button', 'Delete link', 'ocsinventoryng'), ['name' => 'delete_link']);
} else if (!$tolinked && $caneditimport) {
echo Html::submit(_sx('button', 'Import'), ['name' => 'import_ok']);
}
}
echo "</td></tr>\n";
echo "<tr>";
if ($usecheckbox) {
echo "<th width='5%'>&nbsp;</th>";
}
echo "<th>" . __('Name') . "</th>\n";
echo "<th>" . __('Manufacturer') . "</th>\n";
echo "<th>" . __('Model') . "</th>\n";
echo "<th>" . _n('Information', 'Informations', 2) . "</th>\n";
echo "<th>" . __('Date') . "</th>\n";
echo "<th>" . __('OCSNG TAG', 'ocsinventoryng') . "</th>\n";
if ($advanced && !$tolinked) {
echo "<th>" . __('Match the rule ?', 'ocsinventoryng') . "</th>\n";
echo "<th>" . __('Destination entity') . "</th>\n";
echo "<th>" . __('Child entities') . "</th>\n";
}
if ($tolinked) {
echo "<th width='30%'>" . __('Item to link', 'ocsinventoryng') . "</th>";
}
echo "</tr>\n";
$rule = new RuleImportEntityCollection();
foreach ($hardware as $ID => $tab) {
//$comp = new Computer();
//$comp->fields["id"] = $tab["id"];
$data = [];
echo "<tr class='tab_bg_2'>";
if ($usecheckbox) {
echo "<td>";
echo "<input type='checkbox' name='toimport[" . $tab["id"] . "]' " .
($check == "all" ? "checked" : "") . ">";
echo "</td>";
}
if ($advanced && !$tolinked) {
$recursive = isset($tab["is_recursive"]) ? $tab["is_recursive"] : 0;
$data = $rule->processAllRules(['ocsservers_id' => $plugin_ocsinventoryng_ocsservers_id,
'_source' => 'ocsinventoryng',
'is_recursive' => $recursive,
], ['is_recursive' => $recursive], ['ocsid' => $tab["id"]]);
}
echo "<td>" . $tab["name"] . "</td>\n";
echo "<td>" . $tab["manufacturer"] . "</td>";
echo "<td>" . $tab["model"] . "</td>";
echo "<td>";
$ssnblacklist = Blacklist::getSerialNumbers();
$ok = 1;
if (!in_array($tab['serial'], $ssnblacklist)) {
printf(__('%1$s : %2$s'), __('Serial number'), $tab["serial"]);
} else {
echo "<span class='red'>";
printf(__('%1$s : %2$s'), __('Blacklisted serial number', 'ocsinventoryng'), $tab["serial"]);
echo "</span>";
$ok = 0;
}
$uuidblacklist = Blacklist::getUUIDs();
if (!in_array($tab['UUID'], $uuidblacklist)) {
echo "<br>";
printf(__('%1$s : %2$s'), __('UUID'), $tab["UUID"]);
} else {
echo "<br>";
echo "<span class='red'>";
printf(__('%1$s : %2$s'), __('Blacklisted UUID', 'ocsinventoryng'), $tab["UUID"]);
echo "</span>";
$ok = 0;
}
if (isset($tab['NETWORKS'])) {
$networks = $tab['NETWORKS'];
$ipblacklist = Blacklist::getIPs();
$macblacklist = Blacklist::getMACs();
foreach ($networks as $opt) {
if (isset($opt['MACADDR'])) {
if (!in_array($opt['MACADDR'], $macblacklist)) {
echo "<br>";
printf(__('%1$s : %2$s'), __('MAC'), $opt['MACADDR']);
} else {
echo "<br>";
echo "<span class='red'>";
printf(__('%1$s : %2$s'), __('Blacklisted MAC', 'ocsinventoryng'), $opt['MACADDR']);
echo "</span>";
//$ok = 0;
}
if (!in_array($opt['IPADDRESS'], $ipblacklist)) {
echo " - ";
printf(__('%1$s : %2$s'), __('IP'), $opt['IPADDRESS']);
} else {
echo " - ";
echo "<span class='red'>";
printf(__('%1$s : %2$s'), __('Blacklisted IP', 'ocsinventoryng'), $opt['IPADDRESS']);
echo "</span>";
//$ok = 0;
}