AuditTrail.php

<?php

namespace sammaye\audittrail;

use Yii;
use yii\db\ActiveRecord;

/**
 * The followings are the available columns in table 'tbl_audit_trail':
 * @var integer $id
 * @var string $new_value
 * @var string $old_value
 * @var string $action
 * @var string $model
 * @var string $field
 * @var string $stamp
 * @var integer $user_id
 * @var string $model_id
 */
class AuditTrail extends ActiveRecord
{
    private $_message_category = 'audittrail';

	/**
	 * @return string the associated database table name
	 */
	public static function tableName()
	{
		if(isset(Yii::$app->params['audittrail.table'])){
			return Yii::$app->params['audittrail.table'];
		}else{
			return '{{%audit_trail}}';
		}
	}

    /**
     * @return \yii\db\Connection the database connection used by this AR class.
     */
    public static function getDb()
    {
        if (isset(Yii::$app->params['audittrail.db'])) {
            return Yii::$app->get(Yii::$app->params['audittrail.db']);
        } else  {
            return parent::getDb();
        }
        // return Yii::$app->get('dbUser');
    }

    public function init()
    {
        parent::init();

        \Yii::$app->i18n->translations[$this->_message_category] = [
            'class' => 'yii\i18n\PhpMessageSource',
        ];
    }

	/**
	 * @return array customized attribute labels (name=>label)
	 */
	public function attributeLabels()
	{
		return [
			'id' => Yii::t('audittrail','ID'),
			'old_value' => Yii::t('audittrail','Old Value'),
			'new_value' => Yii::t('audittrail','New Value'),
			'action' => Yii::t('audittrail','Action'),
			'model' => Yii::t('audittrail','Type'),
			'field' => Yii::t('audittrail','Field'),
			'stamp' => Yii::t('audittrail','Stamp'),
			'user_id' => Yii::t('audittrail','User'),
			'model_id' => Yii::t('audittrail','ID'),
		];
	}

	/**
	 * @return array validation rules for model attributes.
	 */
	public function rules()
	{
		return [
			[['action', 'model', 'stamp', 'model_id'], 'required'],
			['action', 'string', 'max' => 255],
			['model', 'string', 'max' => 255],
			['field', 'string', 'max' => 255],
			['model_id', 'string', 'max' => 255],
			['user_id', 'string', 'max' => 255],
			[['old_value', 'new_value'], 'safe']
		];
	}

	public static function recently($query)
	{
		$query->orderBy(['[[stamp]]' => SORT_DESC]);
	}

	public function getUser()
	{
		if(isset(Yii::$app->params['audittrail.model']) && isset(Yii::$app->params['audittrail.model'])){
			return $this->hasOne(Yii::$app->params['audittrail.model'], ['id' => 'user_id']);
		}else{
			return $this->hasOne('common\models\User', ['id' => 'user_id']);
		}
	}

	public function getParent(){
		$model_name =
			(
				isset(Yii::$app->params['audittrail.FQNPrefix']) &&
				rtrim(Yii::$app->params['audittrail.FQNPrefix'], '\\') ?
				rtrim(Yii::$app->params['audittrail.FQNPrefix'], '\\') . '\\' :
				''
			) . $this->model;
		return new $model_name;
	}
}