Is it possible to make a global hook so that the where('mandt','=','120') condition is added to all queries in the database?

Question

Laravel

I want to add a separate mandt field to all tables in the database, in which there will be a site identifier and in order to determine for which site the data is selected from this field. Is it possible to somehow add a global hook so that the where('mandt','=','120') condition is added to all queries to the database?
ps yes, I know that separate databases are better for speed, but in this case the load is minimal and this is not critical.

Answer 1

You have Model.php in the App folder, if not, then you need to create it, but in theory it is there and all your models should inherit
it. You need to write a global scope request in it

<?php
namespace App;

use Illuminate\Database\Eloquent\Model as Eloquent;

abstract class Model extends Eloquent
{
    public static function boot()
    {
        parent::boot();
        static::addGlobalScope('mandt', function (\Illuminate\Database\Eloquent\Builder $builder) {
            $builder->where('mandt', '=', '120');
        });
    }
}

Answer 2

You need to create your own class inheritor of the model and override the main methods in it, such as

class MyModel extends Illuminate\Database\Eloquent\Model {
    public function save(...){
        this->where(....);
        parent::save();
    }
}

add the necessary modifications inside the methods, then inherit all created models from the new class. I think the idea is clear - classic OOP.

Answer 3

I just came up with the idea, by analogy with SoftDeletes, to do