static function isThisItemCheckRuleNetworkport($parm)
{
global $DB;
$pmComponentscatalog_rule = new self();
$pmService = new PluginMonitoringService();
$pmSearch = new PluginMonitoringSearch();
$a_networkports_id = array();
if (get_class($parm) == 'PluginMonitoringNetworkport') {
$a_networkports_id[$parm->fields['networkports_id']] = $parm->fields['items_id'];
} else {
if (get_class($parm) == 'NetworkEquipment') {
$query = "SELECT * FROM `glpi_plugin_monitoring_networkports`\n WHERE `items_id`='" . $parm->fields['id'] . "'";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
$a_networkports_id[$data['networkports_id']] = $parm->fields['id'];
}
}
}
foreach ($a_networkports_id as $networkports_id => $networkequipments_id) {
$a_find = array();
$query = "SELECT * FROM `" . $pmComponentscatalog_rule->getTable() . "`\n WHERE `itemtype`='PluginMonitoringNetworkport'";
$result = $DB->query($query);
$get_tmp = array();
if (isset($_GET)) {
$get_tmp = $_GET;
}
while ($data = $DB->fetch_array($result)) {
if (isset($_SESSION["glpisearchcount"][$data['itemtype']])) {
unset($_SESSION["glpisearchcount"][$data['itemtype']]);
}
if (isset($_SESSION["glpisearchcount2"][$data['itemtype']])) {
unset($_SESSION["glpisearchcount2"][$data['itemtype']]);
}
$_GET = importArrayFromDB($data['condition']);
$_GET["glpisearchcount"] = count($_GET['field']);
if (isset($_GET['field2'])) {
$_GET["glpisearchcount2"] = count($_GET['field2']);
}
if (!isset($_SESSION['glpiactiveentities_string'])) {
$_SESSION['glpiactiveentities_string'] = $parm->fields['entities_id'];
}
Search::manageGetValues($data['itemtype']);
$resultr = $pmSearch->constructSQL("PluginMonitoringNetworkport", $_GET, $networkports_id);
if ($DB->numrows($resultr) > 0) {
$a_find[$data['plugin_monitoring_componentscalalog_id']][$networkports_id] = 1;
} else {
if (!isset($a_find[$data['plugin_monitoring_componentscalalog_id']][$networkports_id])) {
$a_find[$data['plugin_monitoring_componentscalalog_id']][$networkports_id] = 0;
}
}
}
if (count($get_tmp) > 0) {
$_GET = $get_tmp;
}
$pmComponentscatalog_Host = new PluginMonitoringComponentscatalog_Host();
foreach ($a_find as $componentscalalog_id => $datan) {
foreach ($datan as $networkports_id => $is_present) {
// Get all networports in this rule
if ($is_present == '0') {
// * Remove from dynamic if present
$query = "SELECT `glpi_plugin_monitoring_services`.`id`,\n `glpi_plugin_monitoring_componentscatalogs_hosts`.`id` as hid\n FROM `glpi_plugin_monitoring_services`\n LEFT JOIN `glpi_plugin_monitoring_componentscatalogs_hosts` ON\n `plugin_monitoring_componentscatalogs_hosts_id` = `glpi_plugin_monitoring_componentscatalogs_hosts`.`id`\n WHERE `plugin_monitoring_componentscalalog_id`='" . $componentscalalog_id . "'\n AND `itemtype`='NetworkEquipment'\n AND `items_id`='" . $networkequipments_id . "'\n AND `is_static`='0'\n AND `networkports_id`='" . $networkports_id . "'";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
$pmComponentscatalog_Host->getFromDB($data['hid']);
$_SESSION['plugin_monitoring_hosts'] = $pmComponentscatalog_Host->fields;
$pmService->delete(array('id' => $data['id']));
}
} else {
// add if not present
// * Add componentscatalogs_hosts if not exist
$componentscatalogs_hosts_id = 0;
$query = "SELECT * FROM `glpi_plugin_monitoring_componentscatalogs_hosts`\n WHERE `plugin_monitoring_componentscalalog_id`='" . $componentscalalog_id . "'\n AND `itemtype`='NetworkEquipment'\n AND `items_id`='" . $networkequipments_id . "'\n LIMIT 1";
$result = $DB->query($query);
if ($DB->numrows($result) == '0') {
$input = array();
$input['plugin_monitoring_componentscalalog_id'] = $componentscalalog_id;
$input['is_static'] = '0';
$input['itemtype'] = "NetworkEquipment";
$input['items_id'] = $networkequipments_id;
$componentscatalogs_hosts_id = $pmComponentscatalog_Host->add($input);
} else {
$a_componentscatalogs_hosts = $DB->fetch_assoc($result);
$componentscatalogs_hosts_id = $a_componentscatalogs_hosts['id'];
}
// * Add service if not exist
$pmComponentscatalog_Host->linkComponentsToItem($componentscalalog_id, $componentscatalogs_hosts_id, $networkports_id);
}
}
}
}
}
static function getItemsDynamicly($parm)
{
global $DB;
$pmDisplayview_rule = new PluginMonitoringDisplayview_rule();
$pmDisplayview_item = new PluginMonitoringDisplayview_item();
$pmDisplayview = new PluginMonitoringDisplayview();
$pmSearch = new PluginMonitoringSearch();
$pmService = new PluginMonitoringService();
$devices_present = array();
if ($pmDisplayview_rule->getFromDB($parm->fields['id'])) {
if ($pmDisplayview->getFromDB($pmDisplayview_rule->fields['plugin_monitoring_displayviews_id'])) {
// Load right entity
$default_entity = 0;
if (isset($_SESSION['glpiactive_entity'])) {
$default_entity = $_SESSION['glpiactive_entity'];
}
$entities_isrecursive = 0;
if (isset($_SESSION['glpiactiveentities']) and count($_SESSION['glpiactiveentities']) > 1) {
$entities_isrecursive = 1;
}
Session::changeActiveEntities($pmDisplayview->fields['entities_id'], $pmDisplayview->fields['is_recursive']);
$get_tmp = '';
$itemtype = $pmDisplayview_rule->fields['itemtype'];
if (isset($_GET)) {
$get_tmp = $_GET;
}
if (isset($_SESSION["glpisearchcount"][$pmDisplayview_rule->fields['itemtype']])) {
unset($_SESSION["glpisearchcount"][$pmDisplayview_rule->fields['itemtype']]);
}
if (isset($_SESSION["glpisearchcount2"][$pmDisplayview_rule->fields['itemtype']])) {
unset($_SESSION["glpisearchcount2"][$pmDisplayview_rule->fields['itemtype']]);
}
$_GET = importArrayFromDB($pmDisplayview_rule->fields['condition']);
$_GET["glpisearchcount"] = count($_GET['field']);
if (isset($_GET['field2'])) {
$_GET["glpisearchcount2"] = count($_GET['field2']);
}
$params = Search::manageParams($pmDisplayview_rule->fields['itemtype'], $_GET);
// Search::manageGetValues($pmDisplayview_rule->fields['itemtype']);
$queryd = "SELECT * FROM `glpi_plugin_monitoring_displayviews_items`\n WHERE `plugin_monitoring_displayviews_id`='" . $pmDisplayview_rule->fields["plugin_monitoring_displayviews_id"] . "'\n AND `itemtype`='" . $pmDisplayview_rule->fields['type'] . "'\n AND `extra_infos`='" . $pmDisplayview_rule->fields['itemtype'] . "'";
$result = $DB->query($queryd);
while ($data = $DB->fetch_array($result)) {
$devices_present[$data['items_id']] = $data['id'];
}
$glpilist_limit = $_SESSION['glpilist_limit'];
$_SESSION['glpilist_limit'] = 500000;
$result = $pmSearch->constructSQL($itemtype, $_GET);
$_SESSION['glpilist_limit'] = $glpilist_limit;
while ($data = $DB->fetch_array($result)) {
if (!isset($devices_present[$data['id']])) {
// Verify this device has one or more resources
$query_h = "SELECT * FROM `glpi_plugin_monitoring_componentscatalogs_hosts`" . " LEFT JOIN `glpi_plugin_monitoring_services`" . " ON `plugin_monitoring_componentscatalogs_hosts_id`=" . " `glpi_plugin_monitoring_componentscatalogs_hosts`.`id`" . " WHERE `items_id`='" . $data['id'] . "'" . " AND `itemtype`='" . $pmDisplayview_rule->fields['itemtype'] . "'" . " AND `glpi_plugin_monitoring_services`.`id` IS NOT NULL";
$result_h = $DB->query($query_h);
if ($DB->numrows($result_h) > 0) {
$input = array();
$input['plugin_monitoring_displayviews_id'] = $pmDisplayview_rule->fields["plugin_monitoring_displayviews_id"];
$input['x'] = '1';
$input['y'] = '1';
$input['items_id'] = $data['id'];
$input['itemtype'] = $pmDisplayview_rule->fields['type'];
$input['extra_infos'] = $pmDisplayview_rule->fields['itemtype'];
$pmDisplayview_item->add($input);
}
} else {
// Verify this device has one or more resources
$query_h = "SELECT * FROM `glpi_plugin_monitoring_componentscatalogs_hosts`" . " LEFT JOIN `glpi_plugin_monitoring_services`" . " ON `plugin_monitoring_componentscatalogs_hosts_id`=" . " `glpi_plugin_monitoring_componentscatalogs_hosts`.`id`" . " WHERE `items_id`='" . $data['id'] . "'" . " AND `itemtype`='" . $pmDisplayview_rule->fields['itemtype'] . "'" . " AND `glpi_plugin_monitoring_services`.`id` IS NOT NULL";
$result_h = $DB->query($query_h);
if ($DB->numrows($result_h) > 0) {
unset($devices_present[$data['id']]);
}
}
}
// Reload current entity
Session::changeActiveEntities($default_entity, $entities_isrecursive);
} else {
$pmDisplayview->delete(array('id' => $pmDisplayview_rule->fields['plugin_monitoring_displayviews_id']));
}
}
foreach ($devices_present as $id) {
$pmDisplayview_item->delete(array('id' => $id));
}
return true;
}
