$p_ip = $result['Ip'];
$p_ping_time = date('Y-m-d H:i:s', strtotime($result['ping_time']));
$p_ping_num = $result['ping_num'];
$p_time_out = $result['time_out_num'];
$p_med_ping = $result['med_ping'];
$p_avg_ping = $result['avg_ping'];
try {
$exR = $stmt->execute();
} catch (Exception $e) {
echo $e->getMessage();
Common::TimedTaskLog($log_filename, $e->getMessage());
}
$rCount++;
}
//end of if (is_array($result))
}
//end of foreach ($results as $result)
#新增告警数据
if ($rCount == 0) {
$cronkey = 'icmp_pingip500';
$params = $get_date;
$splunk_sql = $search;
$err_code = 'splunk采集数据为空';
$re_exec = 1;
$remark = 'splunk采集数据为空';
DataAlarmLog::insertDataAlarmLog($cronkey, $params, $splunk_sql, $err_code, $re_exec, $remark);
}
#新增告警数据
$e_time = microtime(true);
echo $log_content = '<br>执行结束 run_time:' . ($e_time - $s_time) . ' 共采集记录数：' . $rCount;
Common::TimedTaskLog($log_filename, $log_content);
if (isset($_SERVER["HTTP_X_REQUESTED_WITH"]) && strtolower($_SERVER["HTTP_X_REQUESTED_WITH"]) == "xmlhttprequest") {
if ($ajaxMethod == 'sendCommand') {
if (!empty($logid)) {
$logItem = DataAlarmLog::getReExecDataAlarmLogForId($logid);
if (!empty($logItem['TASK_FILE']) && !empty($logItem['PARAMS'])) {
DataAlarmLog::updateAlarmStatus($logid, 1, date('Y-m-d H:i:s', time()));
$cmd = PHP_CGI . " " . $_SERVER['DOCUMENT_ROOT'] . $logItem['TASK_FILE'] . " " . $logItem['PARAMS'];
exec($cmd);
}
}
}
} else {
$alarmLog = DataAlarmLog::getDataAlarmLogCount($taskname, $start_date, $end_date);
$row_count = $alarmLog[0]['NUM'];
$page_size = 5;
$page_no = $page_no < 1 ? 1 : $page_no;
$total_page = $row_count % $page_size == 0 ? $row_count / $page_size : ceil($row_count / $page_size);
$total_page = $total_page < 1 ? 1 : $total_page;
$page_no = $page_no > $total_page ? $total_page : $page_no;
$start = ($page_no - 1) * $page_size;
$alarmLog = DataAlarmLog::getDataAlarmLog($taskname, $start_date, $end_date, $start, $page_size);
foreach ($alarmLog as &$item) {
$status = $item['STATUS'];
}
$page_html = Pagination::showPager("splunkDataMonitor.php?start_date={$start_date}&end_date={$end_date}", $page_no, $page_size, $row_count);
Template::assign('alarmLog', $alarmLog);
Template::assign('taskname_list', $taskname_list);
Template::assign('page_html', $page_html);
Template::assign('_GET', $_GET);
Template::display('netshow/splunkdata/splunkDataMonitor.tpl');
}
