malhal/laravel-createdby

A trait that adds createdBy and updatedBy user relations to your models

Laravel-CreatedBy

A trait that adds createdBy and updatedBy user relations to your models., _(*1)

First either update your database or add this to a migration for each model:, _(*2)

$table->unsignedInteger('created_by_id');
$table->unsignedInteger('updated_by_id');
$table->foreign('created_by_id')
    ->references('id')->on('users')
    ->onDelete('cascade');
$table->foreign('updated_by_id')
    ->references('id')->on('users')
    ->onDelete('cascade');

Finally in your model use:, _(*3)

use CreatedBy;

Now whenever a model is created or updated the createdBy and updatedBy relations will be automatically updated., _(*4)

Unfortunately you shouldn't use this trait on the User model when using auto-increment keys, this is due to the limitation in MySQL that a field cannot reference the currently being inserted ID. However you can still make use of the Laravel-CreatedByPolicy with the workaround explained in that project. If you are using UUIDs for keys then this problem won't happen., _(*5)

There are some extra scope features, e.g., _(*6)

To add the join to retrieve the user info from the user table:, _(*7)

$query->withCreatedBy()
$query->withUpdatedBy()

To query based on a user:, _(*8)

$query->whereCreatedBy($user)

To temporarily disable updates on a save:, _(*9)

$model->saveWithoutCreatedBy();

If you would like to utilise this trait as part of a simple secuity model check out the extension of this trait Laravel-CreatedByPolicy., _(*10)

Installation

PHP 5.6.4+ and Laravel 5.3+ are required., _(*11)

To get the latest version of Laravel CreatedBy, simply require the project using Composer:, _(*12)

$ composer require malhal/laravel-createdby dev-master