Download the PHP package dbrisinajumi/audittrail without Composer
On this page you can find all versions of the php package dbrisinajumi/audittrail. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download dbrisinajumi/audittrail
More information about dbrisinajumi/audittrail
Files in dbrisinajumi/audittrail
Package audittrail
Short Description A reload of the popular audit trail extension
License BSD-2-Clause
Informations about the package audittrail
audittrail
This is basically a modification of a previous extension made by MadSkillsTisdale at http://www.yiiframework.com/extension/audittrail.
I have basically cleaned up some of the code and made a few additions to the behaviour bundled within this extension.
Installing the extension
As such, for these reasons, the module itself has been deleted.
Composer
This extension is listed on packagist.
php copmoser.phar require dbrisinajumi/audittrail
Require https://github.com/uldisn/ace. Listed in Packagist or add in composer:
"repositories":[
{
"type": "vcs",
"url": "https://github.com/yiiext/fancybox-widget"
}
]
Step 1
To install you must first choose a folder in which to place this repository. I have chosen:
/root/backend/extensions/modules
or
/vendor/dbrisinajumi
Since this seems most right to me. Clone this repository to that location.
Step 2
Time to install the table. You can use the migration file provided by the original author of this extension or you can use the SQL file bundled within the migrations folder. Simply run it on your DB server (using PHPMyAdmin or something) and watch the magic unfold.
Step 3
Create alise 'aliases' => array( 'audittrail' => 'vendor.dbrisinajumi.audittrail', )
Reference the AuditTrail
model within your configuration:
'import'=>array(
'audittrail.AuditTrail',
'audittrail.models.*',
'audittrail.behaviors.*',
),
Note You can move AuditTrail
to your models
folder preventing you from having to link it like this.
step 4 - Define modules
-
by ref_models add for shoving in popup related table changes: 'rel_tabel' => 'ref_field' - add to popup changes for table rel_table for records main_table.id = rel_table.ref_field yii_t_category and yii_t_message used for displayng header for table: Yii::t('yii_t_category','yii_t_message')
- By ref_field_sql can define in dialog box shoving instead reference keys show it names. Select must contain column v - label of foreign key.
Step 5
Simply use the behaviour within a model like:
'LoggableBehavior'=> array(
'class' => 'audittrail.behaviors.LoggableBehavior',
)
step 6
For migration in configuration file console add
'aliases' => array(
'audittrail' => 'vendor.dbrisinajumi.audittrail',
)
If table name defined in params, add all params from main config
'params' =>
CMap::mergeArray(
$mainConfig['params'],
array(..))
Epilogue
If your user class is not User
then you may (depending on your setup) need to change the relation within the AuditLog
model to suite your needs.
API
Please note that the below snippets are snippets only and are not tested in a real environment. It is recommend that you use this section as reference and documentation only, do not copy and paste from here.
Custom User Attributes
Some people don't actually have defined users but do have an attribute of the auditable model that would define a unique identification of who edited it. For this end you can use:
'LoggableBehavior'=> array(
'class' => 'vendor.dbrisinajumi.audittrail.behaviors.LoggableBehavior',
'userAttribute' => 'name'
)
Storing Timestamps
The date of the audit log can be changed to used timestamps instead using:
'LoggableBehavior'=> array(
'class' => 'vendor.dbrisinajumi.audittrail.behaviors.LoggableBehavior',
'storeTimestamp' => true
)
Changing the date format
You can adjust the date format using the dateFormat
property of the behaviour:
'LoggableBehavior'=> array(
'class' => 'vendor.dbrisinajumi.audittrail.behaviors.LoggableBehavior',
'dateFormat' => 'Y-m-d H:i:s'
)
Ignoring and allowing specific fields
There is one interesting addition to this version. You can now specify an allowed
set of fields and a ignored
set of fields...or both.
To do this include the behaviour in your models like you normally would:
'LoggableBehavior'=> 'site.backend.extensions.modules.auditTrail.behaviors.LoggableBehavior'
But then add either an ignored
or allowed
(or both) list of fields to the behaviour like so:
'LoggableBehavior'=> array(
'class' => 'vendor.dbrisinajumi.audittrail.behaviors.LoggableBehavior',
'allowed' => array(
'version',
'ns_purchase_description'
),
'ignored' => array(
'ns_purchase_description',
'ns_display_name',
'update_time'
)
)
The names put into the allowed
and ignored
parameters of the behaviour represent field names.
As you will notice I allow the ns_purchase_description
field but also ignore it. When you use the fields in this way ignored
will replace the allowed
and this field will be omitted.
Ignoring a whole class
This is useful if you put the behaviour in a class that extends CActiveRecord which all your own models extend from. This is useful in cases where you want ALL your classes to share the same core (like this behaviour) without having to specify it in every model you create.
'LoggableBehavior'=> array(
'class' => 'vendor.dbrisinajumi.audittrail.behaviors.LoggableBehavior',
'ignored_class' => array(
'ErrorLog', // I use this to log error messages to MYSQL, no need to keep a log of this
),
)
widget audit log grid
$this->widget('vendor.dbrisinajumi.audittrail.components.AudittrailHistory',
array('model'=>$model,'id' => 'audittrail_data_grid')
);
link for popup
Printing out the audit log
Since this no longer uses a module to do its work there is no global configuration for the previously inbuilt audit log to work from. Instead you can insert an audit log like (as an example only, showing an audit of changes to a book title and it's products on a book title page):
$model_ids = array(array($model->id, 'Title'));
foreach($model->products as $id => $product){
$model_ids[] = array($product->id, 'Product');
}
$criteria=new CDbCriteria(array(
'order'=>'stamp DESC',
'with'=>array('user'),
));
$param_id = 0;
foreach( $model_ids as $id_pair ) {
$criteria->addCondition( '( model_id = :id' . $param_id . ' AND model = :model' . $param_id . ' )', 'OR' );
$criteria->params[ ':id' . $param_id ] = $id_pair[0];
$criteria->params[ ':model' . $param_id ] = $id_pair[1];
$param_id++;
}
$this->widget('zii.widgets.grid.CGridView', array(
'id'=>'title-grid',
'dataProvider'=>new CActiveDataProvider('AuditTrail', array(
'criteria'=>$criteria,
'pagination'=>array(
'pageSize'=>100,
)
)),
'columns'=>array(
array(
'name' => 'Author',
'value' => '$data->user ? $data->user->email : ""'
),
'model',
'model_id',
'action',
array(
'name' => 'field',
'value' => '$data->getParent()->getAttributeLabel($data->field)'
),
'old_value',
'new_value',
array(
'name' => 'Date Changed',
'value' => 'date("d-m-Y H:i:s", strtotime($data->stamp))'
)
),
));