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]); }
<?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; });