README

update_by and created_by fields in your laravel model ?

This is a laravel package that will ease the usage of the normally called created_by and update_by extra fields used to stablish responsabilites on records persistance create or update events, with similar fashion as the "timestamp fields" on Eloquent's models, it automatically fills the fields with the primary key of the currently logged user or with a preconfigured system user id.

Requirements

This package was build taking in mind that you use laravel with an eloquent user model class as auth provider. So before installing, you must make sure that your user eloquent model is set on the providers section of your auth config file like this:

//config/auth.php

'providers' => [
    'users' => [
        'driver' => 'eloquent',
        'model' => App\Models\User::class, // <-- this is the important part
    ],
],

Laravel version.

The Lasted version of this package was tested with laravel 9. Should be compatible with versions above also it should work with laravel 8 too, if you find any issue please open an issue on github

Installation

You can install the package via composer:

composer require kamansoft/laravel-blame

Sometimes your laravel application will perform actions that persist records on the database without an authenticated or logged-in user, You can call this user as System User or any other name you want, but you must specify its id or primary key.

To do so, you can run the system user command or the package install comand:

php artisan blame:install

The above command will publish the package config file, and it will run the system user command with no arguments.

Usage

You must first add the update_by and created_by fields to the table's migration field to use it in your models.

//dabase/migrations/2023_01_02_154102_create_somes_table

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    public function up()
    {
        Schema::create('somes', function (Blueprint $table) {
            $table->uuid('id')->primary();
            $table->string('name');

            $system_user_id = env('BLAME_SYSTEM_USER_ID');
            $table->unsignedBigInteger('created_by')->default($system_user_id);
            $table->unsignedBigInteger('updated_by')->default($system_user_id);
            $table->foreign('created_by')->references('id')->on('users');
            $table->foreign('updated_by')->references('id')->on('users');

            $table->timestamps();
        });
    }

Then make use of the Modelblamer trait on your eloquent models, and its booting method will take care of the rest. Also for the seek of a good practice let your model implement the BlameableInterface on your models. Then your model should look something like this

//app/Models/SomeModel.php

namespace App\Models;


use Illuminate\Database\Eloquent\Model;
use Kamansoft\LaravelBlame\Contracts\ModelBlame;
use Kamansoft\LaravelBlame\Traits\ModelBlamer;

class SomeModel extends Model implements ModelBlame
{

    use ModelBlamer; // <-- this is the important part

Commands

This package ships two artisan commands as tools to ease the package usage simplifying a repetitive task like creating or updating the system user or adding the updated by and created by fields to your model's table.

Blame FIelds Migration command

This command is primary intended to be used when you need to update an existing table, adding the created_by and updated_by fields; it needs an argument with the name of the table to update.

php artisan blame:make:migration some_table_name

When run, the above command will create a new migration file in the database/migrations folder with the name add_blame_fields_to_some_table_name_table with a content similar to this:

//database/migrations/2023_01_02_154102_add_blame_fields_to_some_table_name_table.php
return new class extends Migration
{
    public function up()
    {

        Schema::table('some_table_name', function (Blueprint $table) {
            $system_user_id = env('BLAME_SYSTEM_USER_ID');
            $table->unsignedBigInteger(config('blame.created_by_field_name'))->default($system_user_id);
            $table->unsignedBigInteger(config('blame.updated_by_field_name'))->default($system_user_id);
        });
        Schema::table('some_table_name', function (Blueprint $table) {
            $table->unsignedBigInteger(config('blame.created_by_field_name'))->default(null)->change();
            $table->unsignedBigInteger(config('blame.updated_by_field_name'))->default(null)->change();
        });
        Schema::table('some_table_name', function (Blueprint $table) {
            $table->foreign(config('blame.created_by_field_name'))->references('id')->on('users');
            $table->foreign(config('blame.updated_by_field_name'))->references('id')->on('users');
        });
    }

System User Command

When used with no param or arguments:

php artisan blame:set:systemuser 

This command creates a new laravel user to be used when no user can be retrived with Auth::user().

When run with a value through the optional "--key" param:

php artisan blame:set:systemuser --key=some_user_id

The command will check if a user with that id exists, and if not, it will try to create one with that id.

In both cases, the command will set the created system user primary key or id in the project .env file as BLAME_SYSTEM_USER_ID.