/**
* Update TAG information in glpi_plugin_ocsinventoryng_ocslinks table
*
* @param $line_links array : data from glpi_plugin_ocsinventoryng_ocslinks table
* @param $line_ocs array : data from ocs tables
*
* @return string : current tag of computer on update
**/
static function updateTag($line_links, $line_ocs)
{
global $DB, $PluginOcsinventoryngDBocs;
$query_ocs = "SELECT `accountinfo`.`TAG` AS TAG\n FROM `hardware`\n INNER JOIN `accountinfo`\n ON (`hardware`.`ID` = `accountinfo`.`HARDWARE_ID`)\n WHERE `hardware`.`ID` = '" . $line_links["ocsid"] . "'";
$result_ocs = $PluginOcsinventoryngDBocs->query($query_ocs);
if ($PluginOcsinventoryngDBocs->numrows($result_ocs) == 1) {
$data_ocs = Toolbox::addslashes_deep($PluginOcsinventoryngDBocs->fetch_array($result_ocs));
$query = "UPDATE `glpi_plugin_ocsinventoryng_ocslinks`\n SET `tag` = '" . $data_ocs["TAG"] . "'\n WHERE `id` = '" . $line_links["id"] . "'";
if ($DB->query($query)) {
$changes[0] = '0';
$changes[1] = $line_links["tag"];
$changes[2] = $data_ocs["TAG"];
PluginOcsinventoryngOcslink::history($line_links["computers_id"], $changes, PluginOcsinventoryngOcslink::HISTORY_OCS_TAGCHANGED);
return $data_ocs["TAG"];
}
}
}
/**
* Update TAG information in glpi_plugin_ocsinventoryng_ocslinks table
*
* @param $line_links array : data from glpi_plugin_ocsinventoryng_ocslinks table
* @param $line_ocs array : data from ocs tables
*
* @return string : current tag of computer on update
**/
static function updateTag($line_links, $line_ocs)
{
global $DB;
$ocsClient = self::getDBocs($line_links["plugin_ocsinventoryng_ocsservers_id"]);
$options = array();
$computer = $ocsClient->getComputer($line_links["ocsid"], $options);
if ($computer) {
$data_ocs = Toolbox::addslashes_deep($computer["META"]);
if (isset($data_ocs["TAG"]) && isset($line_links["tag"]) && $data_ocs["TAG"] != $line_links["tag"]) {
$query = "UPDATE `glpi_plugin_ocsinventoryng_ocslinks`\n SET `tag` = '" . $data_ocs["TAG"] . "'\n WHERE `id` = '" . $line_links["id"] . "'";
if ($DB->query($query)) {
$changes[0] = '0';
$changes[1] = $line_links["tag"];
$changes[2] = $data_ocs["TAG"];
PluginOcsinventoryngOcslink::history($line_links["computers_id"], $changes, PluginOcsinventoryngOcslink::HISTORY_OCS_TAGCHANGED);
return $data_ocs["TAG"];
}
}
}
}
