一、連接linux服務器，創建數據文件?

　　php yii migrate/create user_log

　　

二、修改數據文件

console/migrations/m150721_032220_admin_log.php

<?phpuse yii\db\Schema; use yii\db\Migration;class m150721_032220_admin_log extends Migration {public function up(){$tableOptions = null;if ($this->db->driverName === 'mysql') {$tableOptions = 'CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB COMMENT="后臺操作記錄"';}$this->createTable('{{%admin_log}}', [//'name'=>Schema::TYPE_STRING.'(200) PRIMARY KEY NOT NULL','id'=>Schema::TYPE_PK,'admin_id'=>Schema::TYPE_INTEGER.'(10) UNSIGNED NOT NULL COMMENT "操作用戶ID"','admin_name'=>Schema::TYPE_STRING.'(200) NOT NULL COMMENT "操作用戶名"','addtime'=>Schema::TYPE_INTEGER.'(10) NOT NULL COMMENT "記錄時間"','admin_ip'=>Schema::TYPE_STRING.'(200) NOT NULL COMMENT "操作用戶IP"','admin_agent'=>Schema::TYPE_STRING.'(200) NOT NULL COMMENT "操作用戶瀏覽器代理商"','title'=>Schema::TYPE_STRING.'(200) NOT NULL COMMENT "記錄描述"','model'=>Schema::TYPE_STRING.'(200) NOT NULL COMMENT "操作模塊（例：文章）"','type'=>Schema::TYPE_STRING.'(200) NOT NULL COMMENT "操作類型（例：添加）"','handle_id'=>Schema::TYPE_INTEGER.'(10) NOT NULL COMMENT "操作對象ID"','result'=>Schema::TYPE_TEXT.' NOT NULL COMMENT "操作結果"','describe'=>Schema::TYPE_TEXT.' NOT NULL COMMENT "備注"',], $tableOptions);}public function down(){$this->dropTable('{{%admin_log}}');} }

?三、根據數據文件生成數據表

　　php yii migrate

　　

四、創建操作記錄的控制器、模型、視圖

　　控制器

　　

<?phpnamespace backend\controllers;use backend\components\BaseController; use common\models\AdminLog; use yii; use yii\data\ActiveDataProvider;class AdminLogController extends BaseController {public function actionIndex(){$dataProvider = new ActiveDataProvider(['query' => AdminLog::find(),'sort' => ['defaultOrder' => ['addtime' => SORT_DESC]],]);return $this->render('index',['dataProvider' => $dataProvider]);}public function actionView($id){return $this->render('view',['model'=>AdminLog::findOne($id),]);}}

模型

<?phpnamespace common\models;use Yii;/*** This is the model class for table "{{%article}}".**/ class AdminLog extends \yii\db\ActiveRecord {/*** @inheritdoc*/public static function tableName(){return '{{%admin_log}}';}/*** @inheritdoc*/public function attributeLabels(){return ['id'=>'操作記錄ID','title'=>'操作記錄描述','addtime'=>'記錄時間','admin_name'=>'操作人姓名','admin_ip'=>'操作人IP地址','admin_agent'=>'操作人瀏覽器代理商','controller'=>'操作控制器名稱','action'=>'操作類型','objId'=>'操作數據編號','result'=>'操作結果',];}public static function saveLog($controller ,$action,$result,$objId){$model = new self;$model->admin_ip = Yii::$app->request->userIP;$headers = Yii::$app->request->headers;$model->addtime = time();if ($headers->has('User-Agent')) {$model->admin_agent = $headers->get('User-Agent');}$model->admin_id = Yii::$app->user->identity->id;$model->admin_name = Yii::$app->user->identity->email;$controllers = ['article','video','collection','collection-album','category','banner','exchange','user','admin'];if(!in_array(strtolower($controller),$controllers)) $controller = '';$actions = ['create','update','delete','login','logout'];if(!in_array(strtolower($action),$actions))$action = '';$model->controller = $controller;$model->action = $action;$model->result = $result;$model->objId = $objId;$model->title = $model->admin_name.' '.$model->action.' '.$model->controller;$model->save(false);} }

視圖

index視圖

<?phpuse yii\grid\GridView;/* @var $this yii\web\View */ /* @var $dataProvider yii\data\ActiveDataProvider */$this->title = '操作記錄'; $this->params['breadcrumbs'][] = $this->title; ?> <div class="handle-index"><?= GridView::widget(['dataProvider' => $dataProvider,'columns' => ['title',['attribute'=>'addtime','value'=>function($model){return date('Y-m-d H:i:s',$model->addtime);},],['class' => 'yii\grid\ActionColumn','template'=>'{view}']],'tableOptions'=>['class' => 'table table-striped']]); ?></div> view視圖

<?phpuse yii\widgets\DetailView;/* @var $this yii\web\View */ /* @var $model backend\models\Admin */$this->title = '操作記錄： '.$model->title; $this->params['breadcrumbs'][] = ['label' => '操作記錄', 'url' => ['index']]; $this->params['breadcrumbs'][] = $this->title; ?> <div class="admin-view"><?= DetailView::widget(['model' => $model,'attributes' => ['id','admin_name','addtime:datetime','admin_ip','admin_agent','controller','action','objId','result'],]) ?></div>

五、實現記錄添加

控制器中調用

public function actionCreate(){$model = new Banner();$model->status=Banner::STATUS_DISPLAY;if ($model->load(Yii::$app->request->post()) && $model->save()) {//保存操作記錄 \common\models\AdminLog::saveLog('banner','create',$model->searchById($model->primaryKey),$model->primaryKey);Yii::$app->session->setFlash('success','Banner【'.$model->title.'】發布成功');return $this->redirect(['index']);} else {return $this->render('create', ['model' => $model,]);}}
public function searchById($id){
if (($model = Banner::findOne($id)) !== null) {
return json_encode($model->toArray());
} else {
throw new \yii\web\NotFoundHttpException('The requested page does not exist.');
}
} ?

?

轉載于:https://www.cnblogs.com/personalnote/p/4664046.html

總結

以上是生活随笔為你收集整理的YII2 实现后台操作记录日志的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。