public function search($params)
{
$query = new \yii\db\Query();
$dataProvider = new ActiveDataProvider(['query' => $query->from(SqlTracePersqlSearch::tableName()), 'db' => self::getDb(), 'pagination' => ['pageSize' => 50]]);
$query->orderBy('amount desc');
$this->load($params);
if (!$this->validate()) {
return $dataProvider;
}
if ($this->sqlquerytime) {
$this->start_date = $this->sqlquerytime;
$this->end_date = date('Y-m-d 00:00:00', strtotime('+1 day', strtotime($this->sqlquerytime)));
}
$query->andFilterWhere(['databasetype' => $this->databasetype]);
$query->andFilterWhere(['sqlquerytime' => $this->start_date]);
$query->orderBy('amount desc');
return $dataProvider;
}
<?php
/* @var $this yii\web\View */
use yii\widgets\Breadcrumbs;
use backend\models\SqlTracePersqlSearch;
use yii\widgets\LinkPager;
use yii\widgets\ActiveForm;
use yii\helpers\Html;
$this->title = '每天语句查询量';
$params = \Yii::$app->request->get();
//处理时间
$accLogErr = new SqlTracePersqlSearch();
if (!empty($params['SqlTracePersqlSearch']['sqlquerytime'])) {
$accLogErr->sqlquerytime = $params['SqlTracePersqlSearch']['sqlquerytime'];
} else {
$params['SqlTracePersqlSearch']['sqlquerytime'] = date('Y-m-d 00:00:00');
$accLogErr->sqlquerytime = date("Y-m-d 00:00:00");
}
$thisDayErrorsLists = $accLogErr->search($params);
$pager = $thisDayErrorsLists->getPagination();
$datas = $thisDayErrorsLists->getModels();
$begin = $pager->page * $pager->pageSize + 1;
$end = $begin + $pager->pageSize - 1;
if ($begin > $end) {
$begin = $end;
}
?>
<div class="site-index">
<?php
echo Breadcrumbs::widget(['itemTemplate' => "<li><i>{link}</i></li>\n", 'links' => [['label' => '首页']]]);
?>
