fish/eloquent-logger

Log Eloquent model changes to a designated logs table

Eloquent Logger

, _(*1)

This Laravel 5 package adds logging functionality to Eloquent models. All changes (create, update, delete) will be recorded in a designated logs table. Updates will record only dirty fields., _(*2)

Installation

Add to composer.json:, _(*3)

"require": {
  "fish/eloquent-logger": "^1.0"
}

Update Composer from the Terminal:, _(*4)

composer update

Add the service provider to the the list of providers in your app.php, _(*5)

Fish\Logger\LoggerServiceProvider

Publish migration:, _(*6)

php artisan logger:init

Run migration:, _(*7)

php artisan migrate

Usage

Use the trait on relevant models. E.g:, _(*8)

namespace App;

use Illuminate\Database\Eloquent\Model;
use Fish\Logger\Logger;

class Post extends Model
{
  use Logger;
}

Retrieving logs for a model:, _(*9)

Post::find(1)->logs

Retrieving model from log (if the action was not deleted):, _(*10)

Fish\Logger\Log::find(1)->loggable;

Retrieve the state of the model at a certain point of time:, _(*11)

Post::find(1)->logs()->stateOn('2015-02-02 13:00:00');

To retrieve the state of a deleted model:, _(*12)

Fish\Logger\Log::entity(Post::class, 1)->stateOn('2016-01-01 12:00:00');

The model will be retrieved even if the passed timestamp occured after it was already deleted., _(*13)

The Log contains the following properties:, _(*14)

• user_id integer: User who did the action. if there is no authenticated user, set to null
• action string: type of action - created, updated or deleted
• before array: state of the model before the action. If the action is created set to null
• after array: state of the model after the action. If the action is deleted set to null
• created_at datetime: action's timestamp

Query helpers

• wasCreated, wasUpdated or wasDeleted - filter by action.
• between - filter by date range.

Example:, _(*15)

Post::find(1)->logs()
            ->wasUpdated()
            ->between('2015-01-01','2015-02-01')
            ->get();