public function actionRecord()
 {
     $view = \Yii::$app->view;
     $view->params['moduleName'] = '操作日志';
     $total = SqlRecord::getSqlRecordTotal();
     $pagination = new Pagination(['defaultPageSize' => \Yii::$app->params['pageSize'], 'totalCount' => $total]);
     $data = SqlRecord::getSqlRecord($pagination->offset, $pagination->limit);
     return $this->render('record', ['data' => $data, 'pagination' => $pagination]);
 }
Exemple #2
0
<?php

use yii\base\Event;
use yii\db\ActiveRecord;
use yii\db\Command;
use backend\models\SqlRecord;
use common\helpers\EasyHelpers;
Event::on(Command::className(), Command::BEFORE_EXECUTE, function ($event) {
    $userId = \Yii::$app->user->id ?: EasyHelpers::pidDecrypt(\Yii::$app->request->_get('usercode', ''));
    if (!$userId) {
        return false;
    }
    $sql = $event->sender->rawSql;
    if (strtolower(substr(trim($sql), 0, 22)) == 'insert into sql_record') {
        return false;
    }
    SqlRecord::saveSql($userId, $sql);
    return;
});