$list = array();
$start_date_time = strtotime($start_date);
$end_date_time = strtotime($end_date);
$start_date = date('Ymd H:i:s', $start_date_time);
$end_date = date('Ymd H:i:s', $end_date_time);
$tableName = 'SPLUNK_PING';
if ($chkType == 1) {
$tableName = 'SPLUNK_PING_WW';
} else {
if ($chkType == 2) {
$tableName = 'SPLUNK_PING_IP500';
}
}
$return = PacketLossRate::getLossRateAllCount($start_date, $end_date, $tableName);
$row_count = $return[0]['NUM'];
$list = PacketLossRate::getLossRateAll($start_date, $end_date, $tableName, 0, $row_count);
export_csv($list);
function export_csv($list)
{
$filename = date('YmdHis') . ".csv";
//文件名
header("Content-type:text/csv");
header("Content-Disposition:attachment;filename=" . $filename);
header('Cache-Control:must-revalidate,post-check=0,pre-check=0');
header('Expires:0');
header('Pragma:public');
echo array_to_string($list);
}
function array_to_string($result)
{
$data = i('IP,PING次数,掉包量' . "\n");
$start_date_time = strtotime($start_date);
$end_date_time = strtotime($end_date);
$start_date = date('Ymd H:i:s', $start_date_time);
$end_date = date('Ymd H:i:s', $end_date_time);
$tableName = 'SPLUNK_PING';
if ($chkType == 1) {
$tableName = 'SPLUNK_PING_WW';
} else {
if ($chkType == 2) {
$tableName = 'SPLUNK_PING_IP500';
}
}
$return = PacketLossRate::getLossRateAllCount($start_date, $end_date, $tableName);
$row_count = $return[0]['NUM'];
$page_size = 15;
$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;
$list = PacketLossRate::getLossRateAll($start_date, $end_date, $tableName, $start, $page_size);
foreach ($list as &$item) {
$item['PING'] = number_format($item['PING']);
$item['TIME_OUT'] = number_format($item['TIME_OUT'], 2);
$item['TIME_JG'] = number_format($item['TIME_JG'], 2);
}
$page_html = Pagination::showPager("lossRateAllPc.php?start_date={$start_date}&end_date={$end_date}&chkType={$chkType}", $page_no, 15, $row_count);
Template::assign('list', $list);
Template::assign('page_html', $page_html);
Template::assign('_GET', $_GET);
Template::display('netshow/idc/lossRateAllPc.tpl');
