d3yii2/d3audittrail

Show audittrail data

, _(*1)

Add to composer require, _(*2)

      "d3yii2/d3audittrail": "dev-master"

Display audittrail data

Add migrations paths

    'controllerMap' => [
        'migrate' => [
            'class' => 'yii\console\controllers\MigrateController',
            'migrationPath' => [
                '@vendor/d3yii2/d3audittrail/migrations',

            ],
        ],
    ],

Define module in console and web

    'modules' => [

        'd3audittrail' => [
            'class' => 'd3yii2\d3audittrail\Module',
        ],
    ]    

define in parameters table name

    'params' => [
        'audittrail.table' => 'tbl_audit_trail'
    ]    

Add to model behaviors

    public function behaviors(): array
    {
        return ArrayHelper::merge(
            parent::behaviors(),
            [
                'sammaye\audittrail\LoggableBehavior'
            ]
        );
    }

Define model label

class Model extends extends \yii\db\ActiveRecord
    /**
    * model label 
    */
    public function tableLabel(): string
    {
        return 'Data Record';
    }

    public static function audittrailHiddedFields()
    {
        return [
            'password'
        ];
    }

    public static function audittrailSqlFields()
    {
        return [
            'client_id' => 'select name from client where id=:id'
        ];
    }

    public static function audittrailRefModels()
    {
        return [
            [
                'model' => TblAuditTrail::class,
                'ref_field' => 'my_id',
                'hidded_fields' => ['a','b'],
                'field_sql' => [
                    'field1' => 'select name from user where id=:id'
                 ]               
            ]           
        ];
    }
}

Add to view button to audittrail controller (unsecure)

    $this->addPageButtons(AuditTrailButton::widget([
                'modelName' => coalmar\delivery\models\CmdDelivery::className(),
                'modelId' => $model->id
    ]));

Add to view button to actual controller (secure)

$this->addPageButtons(ThButton::widget([
    'label' => 'Auditpieraksti',
    'link' => [
        'audit-trail',
        'id' => $model->id,
        'audittrail-ru' => ReturnUrl::getToken('Partija')
    ]
]));

Add to controller action

public function behaviors(): array
{
    return [
        'access' => [
            'class' => AccessControl::class,
            'rules' => [
                [
                    'allow' => true,
                    'actions' => [
                        'audit-trail'
                    ],
                    'roles' => [
                        '@'
                    ],
                ],
            ],
        ],
        'clearFilterState' => ClearFilterStateBehavior::class,
    ];
}

    public function actions()
    {
        return [
            'audit-trail' => [
                'class' => AudittrailListAction::class,
                'modelName' => CwbrProduct::class,
            ]
        ];
    }

Add in kartik grid action column histry button

    $returnUrlToken = ReturnUrl::getToken();
    $columns[] = [
        'class' => ActionColumn::class,
        'template' => '{update}{delete}{audit-trail}',
        'noWrap' => true,
        'urlCreator' =>
            static function ($action, $model, $key) use ($returnUrlToken) {
                return Url::toRoute([
                    '/d3persons/d3p-person-contact/' . $action,
                    'id' => (string)$key,
                    'ru' => $returnUrlToken
                ]);
            },
        'buttons'=>[
            'audit-trail' => static function ($url, $model) {
                return Html::a(
                    '<span class="glyphicon glyphicon-time"></span>', $url, [
                    'title' => Yii::t('d3audittrail', 'Audit trail'),
                ]);
            }
        ]
    ]