/**
* 数据库相关的统计
*/
public function actionSqlgraph()
{
$page = Yii::$app->request->get("page");
if (empty($page)) {
$page = 0;
}
$pre_page = $page - 1;
$next_page = $page + 1;
$search_date = Yii::$app->request->get("search_date");
if (empty($search_date)) {
$search_date = date("Y-m-d");
}
$day_data = SqlTraceService::getSqlDayGraph($page, $search_date);
if (empty($day_data)) {
return $this->render('sqlgraph', ['search_date' => $search_date, "pre_page" => $pre_page, "next_page" => $next_page]);
}
$appnames = $day_data["appnames"];
$series['name'] = $day_data["search_date"] . "访问统计";
$series['data'] = $day_data['data']["totalVisit"];
$series['dataLabels']['enabled'] = true;
$series1['name'] = $day_data["search_date"] . "每秒访问频率";
$series1['data'] = $day_data['data']["totalsecondVisit"];
$series1['dataLabels']['enabled'] = true;
$appnameshourshow = $day_data['data']["hourshow"];
$series2 = $day_data['data']["reline24Visit"];
$series3 = $day_data['data']["reline24VisitSc"];
$series4 = $day_data['data']["reline24Time"];
$series5 = $day_data['data']["reline24Timesec"];
return $this->render('sqlgraph', ['search_date' => $search_date, "appnames" => $appnames, "appnameshourshow" => $appnameshourshow, "series" => array($series), "series1" => array($series1), "series2" => $series2, "series3" => $series3, "series4" => $series4, "series5" => $series5, "pre_page" => $pre_page, "next_page" => $next_page]);
}
