Tracks the user responsible for creating, modifying, or deleting an Eloquent model

2.0.0 2018-09-19 08:07 UTC


Latest Stable Version CircleCI Travis Build Code Quality StyleCI License

This package provides a trait that tracks the user responsible for creating, modifying, or deleting an Eloquent model.

Accountable will observe any activity on your models and it sets the created_by_user_id, updated_by_user_id, and deleted_by_user_id accordingly using the currently authenticated user.

It also provides you with some useful scope query functions, allowing you to fetch models that were either created, modified, or deleted by a specific user.

Table of Contents


This package can be installed through Composer:

$ composer require bytestgear/laravel-accountable

The package will automatically register itself.

Older Laravel versions (5.4, 5.3, 5.2) require you to add the Accountable service provider in your Laravel config file config/app.php manually:


Optionally, publish the configuration file:

$ php artisan vendor:publish --provider="ByTestGear\Accountable\AccountableServiceProvider" --tag="config"

The configuration file allows you to set the preferred authentication driver and the database column names.

When left untouched, Accountable will use the default authentication driver and the default column names (created_by_user_id, updated_by_user_id, and deleted_by_user_id).


In order to add Accountable to your Laravel application, you'll need to:

  1. Add the required columns to your migration file(s).
  2. Use the trait ByTestGear\Accountable\Traits\Accountable on your model(s).

Please note that due to the nature of Laravel event system, mass updates will not be handled by Accountable.

Using the Migration helper

The migration helper simplifies the process of adding columns to your migration:

use ByTestGear\Accountable\Accountable;

class CreateProjectsTable extends Migration
    public function up()
        Schema::create('projects', function (Blueprint $table) {
            // This will add the required columns

Tip: if you do not use soft-deletes on your model, use Accountable::columns($table, false) to prevent the helper from adding a deleted_by_user_id column.

Using the Trait

Add the Accountable trait on the models you want to track:

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;
use ByTestGear\Accountable\Traits\Accountable;

class Project extends Model
    use Accountable, SoftDeletes;
    protected $table = 'projects';


Setup your model and make sure you are authenticated.

Create a project and show the name of the user that created it:

$project = new Project(['name' => 'Awesome project']);

// Show the name of user that created the project
echo $project->createdBy->name; 

Get all projects created by a specific user:

$user = User::findOrFail(42);

// Get all projects created by user with id 42

You can use the following properties and methods to reveal the user responsible:

// Get the user that created the model

// Get the user that last updated the model

// Get the user that last deleted the model

The following scope queries are at your disposal:

// Retrieve the models either created, updated, 
// or deleted by $user.

// And one extra: get all models that were created 
// by the currently authenticated user.


The package contains integration tests. You can run them using PHPUnit.

$ vendor/bin/phpunit


Refer to CHANGELOG for more information.


Refer to CONTRIBUTING for contributing details.



The MIT License (MIT). Refer to the License for more information.