コード例 #1
0
 function type_other($type = 'average')
 {
     global $DB;
     $pmService = new PluginMonitoringService();
     $pmServiceevent = new PluginMonitoringServiceevent();
     $pmComponent = new PluginMonitoringComponent();
     $pmPerfdataDetail = new PluginMonitoringPerfdataDetail();
     $a_date = PluginMonitoringCustomitem_Common::getTimeRange($this->fields);
     $val = 0;
     $a_val = array();
     $nb_val = 0;
     $a_tocheck = array('warn' => 0, 'crit' => 0, 'limit' => 0);
     $a_types = array('warn', 'crit', 'limit');
     for ($i = 0; $i < count($a_types); $i++) {
         if (is_numeric($this->fields['aggregate_' . $a_types[$i]])) {
             $a_ret[$a_types[$i]] = $this->fields['aggregate_' . $a_types[$i]];
         } else {
             $a_ret[$a_types[$i]] = 0;
             $a_tocheck[$a_types[$i]] = 1;
         }
     }
     $items = importArrayFromDB($this->fields['aggregate_items']);
     foreach ($items as $itemtype => $data) {
         switch ($itemtype) {
             case 'PluginMonitoringService':
                 foreach ($data as $items_id => $data2) {
                     $pmService->getFromDB($items_id);
                     $_SESSION['plugin_monitoring_checkinterval'] = PluginMonitoringComponent::getTimeBetween2Checks($pmService->fields['plugin_monitoring_components_id']);
                     $pmComponent->getFromDB($pmService->fields['plugin_monitoring_components_id']);
                     $query = "SELECT * FROM `glpi_plugin_monitoring_serviceevents`\n                     WHERE `plugin_monitoring_services_id`='" . $items_id . "'\n                        AND `date` >= '" . $a_date['begin'] . "'\n                     ORDER BY `date`";
                     $result = $DB->query($query);
                     $ret = $pmServiceevent->getData($result, $pmComponent->fields['graph_template'], $a_date['begin'], $a_date['end']);
                     foreach ($data2 as $a_perfdatadetails) {
                         $pmPerfdataDetail->getFromDB($a_perfdatadetails['perfdatadetails_id']);
                         $nb_val += count($ret[0][$pmPerfdataDetail->fields['dsname' . $a_perfdatadetails['perfdatadetails_dsname']]]);
                         $val += array_sum($ret[0][$pmPerfdataDetail->fields['dsname' . $a_perfdatadetails['perfdatadetails_dsname']]]);
                         $a_val = array_merge($a_val, $ret[0][$pmPerfdataDetail->fields['dsname' . $a_perfdatadetails['perfdatadetails_dsname']]]);
                     }
                     // for manage warn, crit and limit
                     foreach ($a_tocheck as $other_type => $num_type) {
                         if ($num_type == 1) {
                             $other_items = importArrayFromDB($this->fields['aggregate_' . $other_type]);
                             foreach ($other_items[$itemtype][$items_id] as $a_perfdatadetails) {
                                 $pmPerfdataDetail->getFromDB($a_perfdatadetails['perfdatadetails_id']);
                                 $a_ret[$other_type] += array_sum($ret[0][$pmPerfdataDetail->fields['dsname' . $a_perfdatadetails['perfdatadetails_dsname']]]);
                             }
                         }
                     }
                 }
                 break;
             case 'PluginMonitoringComponentscatalog':
                 $pmComponentscatalog = new PluginMonitoringComponentscatalog();
                 foreach ($data as $items_id => $data2) {
                     $ret = $pmComponentscatalog->getInfoOfCatalog(str_replace('id', '', $items_id));
                     $a_hosts = $ret[6];
                     foreach ($data2['PluginMonitoringComponent'] as $items_id_components => $data4) {
                         $query = "SELECT * FROM `glpi_plugin_monitoring_services`\n                        WHERE `plugin_monitoring_components_id`='" . str_replace('id', '', $items_id_components) . "'\n                           AND `plugin_monitoring_componentscatalogs_hosts_id` IN\n                              ('" . implode("','", $a_hosts) . "')\n                           AND `entities_id` IN (" . $_SESSION['glpiactiveentities_string'] . ")";
                         $result = $DB->query($query);
                         while ($dataq = $DB->fetch_array($result)) {
                             $pmService->getFromDB($dataq['id']);
                             $_SESSION['plugin_monitoring_checkinterval'] = PluginMonitoringComponent::getTimeBetween2Checks($pmService->fields['plugin_monitoring_components_id']);
                             $pmComponent->getFromDB($dataq['plugin_monitoring_components_id']);
                             $query = "SELECT * FROM `glpi_plugin_monitoring_serviceevents`\n                           WHERE `plugin_monitoring_services_id`='" . $dataq['id'] . "'\n                              AND `date` >= '" . $a_date['begin'] . "'\n                           ORDER BY `date`";
                             $result = $DB->query($query);
                             $ret = $pmServiceevent->getData($result, $pmComponent->fields['graph_template'], $a_date['begin'], $a_date['end']);
                             foreach ($data4 as $a_perfdatadetails) {
                                 $pmPerfdataDetail->getFromDB($a_perfdatadetails['perfdatadetails_id']);
                                 $nb_val += count($ret[0][$pmPerfdataDetail->fields['dsname' . $a_perfdatadetails['perfdatadetails_dsname']]]);
                                 $val += array_sum($ret[0][$pmPerfdataDetail->fields['dsname' . $a_perfdatadetails['perfdatadetails_dsname']]]);
                                 $a_val = array_merge($a_val, $ret[0][$pmPerfdataDetail->fields['dsname' . $a_perfdatadetails['perfdatadetails_dsname']]]);
                             }
                             // for manage warn, crit and limit
                             foreach ($a_tocheck as $other_type => $num_type) {
                                 if ($num_type == 1) {
                                     $other_items = importArrayFromDB($this->fields['aggregate_' . $other_type]);
                                     foreach ($other_items[$itemtype][$items_id]['PluginMonitoringComponent'][$items_id_components] as $a_perfdatadetails) {
                                         $pmPerfdataDetail->getFromDB($a_perfdatadetails['perfdatadetails_id']);
                                         $a_ret[$other_type] += array_sum($ret[0][$pmPerfdataDetail->fields['dsname' . $a_perfdatadetails['perfdatadetails_dsname']]]);
                                     }
                                 }
                             }
                         }
                     }
                 }
                 break;
         }
     }
     if ($nb_val != 0) {
         if ($type == 'average') {
             $val = $val / $nb_val;
         } else {
             if ($type == 'median') {
                 sort($a_val);
                 $count = count($a_val);
                 //total numbers in array
                 $middleval = floor(($count - 1) / 2);
                 // find the middle value, or the lowest middle value
                 if ($count % 2) {
                     // odd number, middle is the median
                     $median = $a_val[$middleval];
                 } else {
                     // even number, calculate avg of 2 medians
                     $low = $arr[$middleval];
                     $high = $arr[$middleval + 1];
                     $median = ($low + $high) / 2;
                 }
                 $val = $median;
             }
         }
     }
     foreach ($a_tocheck as $other_type => $num_type) {
         if ($num_type == 1) {
             $a_ret[$other_type] = $a_ret[$other_type] / $nb_val;
         }
     }
     $a_ret['val'] = $val;
     return $a_ret;
 }