/**
* This fonction search if a services catalog has a resource deleted
*
*/
function servicescatalogMessage()
{
global $DB;
$pmServicescatalog = new PluginMonitoringServicescatalog();
$input = '';
$a_catalogs = array();
$query = "SELECT `plugin_monitoring_servicescatalogs_id` FROM `glpi_plugin_monitoring_businessrulegroups`\n\n LEFT JOIN `glpi_plugin_monitoring_businessrules` ON `glpi_plugin_monitoring_businessrulegroups`.`id` = `plugin_monitoring_businessrulegroups_id`\n\n LEFT JOIN `glpi_plugin_monitoring_services` ON `plugin_monitoring_services_id` = `glpi_plugin_monitoring_services`.`id`\n\n WHERE `glpi_plugin_monitoring_services`.`id` IS NULL";
$result = $DB->query($query);
while ($data = $DB->fetch_array($result)) {
$pmServicescatalog->getFromDB($data['plugin_monitoring_servicescatalogs_id']);
$a_catalogs[$data['plugin_monitoring_servicescatalogs_id']] = $pmServicescatalog->getLink();
}
if (count($a_catalogs) > 0) {
$input = __('Services catalog with resources not available', 'monitoring') . " : <br/>";
$input .= implode(" - ", $a_catalogs);
}
return $input;
}
