PHP backend\models SqlRecord::saveSql Exemples

Exemple #1

Fichier : DbafterEvent.php Projet : BlackCodes/Mymine

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