Ordit

Ordit is a Kohana 3.x module that adds automatic auditing to the Official ORM module.

Ordit is a transparent extension that audits all CUD actions on your objects. It includes a Log Viewer to view all Audit logs.

Getting started

Before we use Ordit, we must enable the modules required

Kohana::modules(array(
	...
	'database' => MODPATH.'database',
	'orm' => MODPATH.'orm',
	'ordit' => MODPATH.'ordit',
	...
));

[!!] Ordit requires the ORM module (plus its dependencies) to work.

Setting up the database

You need to create a table in your database to hold all your logs.

A script is included in the module named ordit_logs.sql The script is for a mysql database running the InnoDB engine.

The table is configured as follows:

Table Name :: 
	`ordit_logs`
Columns ::
	`id` INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY
	`model` CHAR(50) NOT NULL,
	`action` CHAR(7) NOT NULL,
	`values` TEXT NOT NULL,
	`user` CHAR(50) NOT NULL,
	`timestamp_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,

Overriding the Ordit::get_username Method

In order to provide the current logged in user's username for auditing, create a class in your classes folder named Ordit that extends the Model_Ordit class. Then override the get_username method to return the current logged in user's username. The example below uses the default Auth module.

class Ordit extends Model_Ordit
{	
	protected function get_username()
	{
		return Auth::instance()->get_user()->username;
	}
}

Auditing Your Models

To enable auditing of your ORM models, you simple extend Ordit.

class Model_Model extends Ordit
{
	...
}

Any CREATE, UPDATE and DELETE actions are automatically and transparently logged. You don't have to do anything else.

Viewing Your Logs

The module includes a log viewer.

You can view logs at (http://site_root/ordit)

[!!]The log viewer was modified from Kohana Log Viewer viewer.

TODO

Log Changes to Related Modules

Currently, changes to related modules are logged as an empty array.

##Improve Viewer

Add pagination to the log results

Add ability to search by currently undefined parameters

thedumbtechguy/Ordit--Kohana-Orm-Audit-Module