PHP backend\models SqlTracePersqlSearch::search Examples

Example #1

File: persqlquery.php Project: bfyang5130/tuanlogs

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' => '首页']]]);
?>

    <div class="body-content">
        <div class="panel panel-default">