[Live-Coding] Laravel Multi-Tenancy with Single Trait
ฝัง
- เผยแพร่เมื่อ 22 ก.ย. 2024
- A demo-project to show you how easy it is to add multi-tenancy to Laravel project. First we do that with observers, but then make it more flexible with a trait.
Project code on Github: github.com/Lar...
Article version with code snippets: laraveldaily.c...
- - - - -
I'm available for freelance Laravel work, check out my Upwork profile: bit.ly/povilas-...
- - - - -
Our daily Laravel blog: laraveldaily.com
Our 50+ Laravel tips in a FREE e-book: bit.ly/laravel-...
Enroll in our online courses: bit.ly/laravel-...
Try our QuickAdminPanel code generator: bit.ly/quickadm...
Follow us on Twitter: bit.ly/twitter-...
![[Live-Coding] Refactor Laravel Controller to be Much Shorter](http://i.ytimg.com/vi/ShrS3HXwzPg/mqdefault.jpg)
![[Live-coding] Laravel Livewire: Parent-Child Form Example](/img/n.gif)
an important note here is that the trait's boot method name must follow the pattern boot+trait_name in order for the method to be called automatically inside the model
Even though this video is quite old now, it's still one of the best introductions to multi-tenancy for Laravel available. The problem is between 2020 and 2021 everyone went on tangent to try and do fancy stuff with multi-tenancy - new plugins - new packages - multi-data - tenant identification by domain name. The bottom line is for most basic multi-tenancy apps scoping and observers are more than enough.
This is just pure perfection and simplicity for something I needed to implement today. Thank you
Brilliant tutorial. Thanks!
One thing that caught me out: The boot method suffix MUST match the class name.
trait MultitenantableTrait {
public static function bootMultitenantableTrait(). //The method name here is boot{classname}
...not
trait MultitenantableTrait {
public static function bootMultitenantable() //no 'trait' on the method name
I know this is probably super obvious to most people, but it took me quite a while to work out what was going on! :-)
Wonderful... Thank you for making this.
Great video, if you want to allow for joins where multiple tables will have the created_by_user_id, you can add this to your trait.
$builder->where($builder->getModel()->getTable() . '.created_by_user_id', auth()->id);
Keep up the good work!
Excellent demonstration, thank you so much for this video
You are super awesome, thank you.
YOU ARE A M A Z I N G !!!!!!!! Tks so much, you saved my life
nice tutorial
Thank you for this tutorial!!!
wow, thank you sir
Yep! Definitely useful, and added to my list of things to implement. Thank you!
Awesome! Coool Man. Thank you very much for this tutorial.
Great and simple!! thank you !!
Thank you
Very Useful. Thanks.
So helpful thank you sooo much. Can you please make one using hyn/multi-tenancy package
Currently not planning it, because that package assumes multi-database setup which is more complicated and requires more effort.
@@LaravelDaily yes, but that is actually the real multi tenancy--when you run multiple domains on the same codebase.
Alin Mazilu totally agree
I'm going to agree with Povilas here. Multiple database and multiple domains sounds very nice until you start realising the extra effort and complexity. There is now some "nice" packages to do it, but at the end of the day after a while the complexity starts to haunt one.
Yeah ...so far....great video Man. I am suscribed.
Great work thank you
Also we can put the belongs to user relation in that Trait
Very good video! Thanks and keep going!
If use Raw query(DB::table) still observerbs and golbal scrop works?
Can we implement the same idea with multi databases from single code base?
Thank you for the great tutorial
Thanks for the video! Where to learn deeper about Observers?
Here it is in the official docs: laravel.com/docs/5.7/eloquent#observers
ty man, so helpful
Thanks bro.
Hi, i want to ask.
i want show data where created_by_user_id id null?
if possible?
I also found one error on frontend for another users not seen any data on frontend also what solution for that.
Is it Multi-Tenancy can be achieved with Policy?
COOL AF
Great example. The only thing I dont get is how the bootMultitenantable() function is called. Is it because Larabel executes everyrhing that starts with bootXxxxc?
what about super admin because of tenant super admin also not seen others records then how give all access to super admin
Hi, my requirement is I want a user to register to multiple hotels with same email id based on different url for hotels like localhost/radisson_london with id =1 and localhost/radisson_stockholm with id =2. and based on the url i want to filter all models with hotel_id.
Or is there any stuff on saas with multi tenancy?
Waow!!
Thank you so much, useful stuff I am going to implement in my current project, Could you please tell me the chrome add-ons, which you are using for form filllup
It's called Form Filler: chrome.google.com/webstore/detail/form-filler/bnjjngeaknajbdcgpfkgnonkmififhfo?hl=en
Hello, excellent explanation. Can I implement the Multi-Tenancy part in my project?
If you're a developer, of course you can :)
Hello! Since the creating method sets the user_id automatically I cant create entities related to different users in my tests. Is there a way to solve this?
U are just amazing is there any package out there for this ?
hello, a query: how do I use the Formrequest class and validate a single field in the whole system; example: a person's identification number must be unique throughout the system. But it does not work because the model only validates return $ builder-> where ('user_id', auth () -> id ()) ... lets me repeat the records. It only validates the unique field if it has been created by the user who is logged in. I would like to know how to make that exception. Thank you
If you want show all to admin user and keep this logic (multi-tenancy)? How you resolve this?
You should add a condition to check whether the authenticated user's role is admin or not, if yes, then you should not filter by its user id, else, do exactly like the video
good tutorial sir
thanks for same
by the way not working on
\DB::table('xyz')->whereRaw('a
Anybody could help me how to pass this trait to allow another trait for checking the whole rows.
I'm using cviebrock/sluggable to create unique slug, but it cannot check the whole table and produce error when different users insert rows that generate identic slug.
Is it better to create model observer for fill only created_by_user_id filed instead put this logic into controller create method like this: Hotel::create($request->validated + ['created_by_user_id' => Auth::id()]), and why if it is?
It's your personal preference
can we use like this if user has many hotel and hotel has many user like many to many table
user
hotel
hotel_user
Multi-tenant with different database conecction?
As I said in the end of this video, this is a much broader topic, requires a full course on it. In short, I can recommend Laravel Tenancy package: laravel-tenancy.com/
how to implement this with api resource?
That is awesome .. how about multi domain each hotel has one domain
Here's a demo: th-cam.com/video/D25CxsZONvc/w-d-xo.html
Nice video thanks a lot, I have a question, if an admin needs to check the info of the users in some admin section when he ask laravel for the multitenantable objects that each user created, wich is the correct way to get the info? I mean the admin wont see it because he didn't created it
For admin, you can use some if-statement to check if he's an admin and then remove the global scope, like User::withoutGlobalScope()->get() if I remember syntax correctly.
Hi Povilas, Its a great tutorial you've put together there. If I could ask your advice please? If I were the have the following scenario how would you go about expanding the bootmultitennantable function to accommodate?
if there was Admin, Agent and User. If the user created their own bookings and therefore each booking belongs to a hotel the user could therefore see all hotels in order to make the booking. Then the agent has access only to the bookings that are in the hotels under his creation. Admin would have access to all hotels and bookings.
Thankyou in advance.
Best regards
Stephen
Hi Stephen. Unfortunately this is not an answer I can give in a short TH-cam comment, would have to set up a real project and play around with variables. If you want me to do it, you can book some of my time, email me povilas@laraveldaily.com
@@PovilasKorop No problem, Thanks for the prompt reply :)
I think I've worked something out however may get in touch soon as getting a little beyond my capabilities.
Best regards
Stephen
The data is actually stored in only one Database right? Is there some way or a package to have a separate Database for each agent?
Yes it's in one database. For multiple databases it's 5x more difficult solution, but I can recommend a package for it - laravel-tenancy.com/
@@PovilasKorop but not working
Hello, could you please help me with a question, please: when I am registering a new booking and, I inspect an item and manually enter an ID of another hotel that has been created by another user, it is being stored. How could I control that, that is, do not let save a hotel ID that has not been created by the user who is logged in. Thank you
Sorry it's impossible to help you without actually seeing the code and the structure, so it's not a help that can be provided in TH-cam comment. Email me povilas@laraveldaily.com with more details and maybe I could help.
How do you feel about Nova?
I was asked that question last year at Laracon EU when Nova was released. Since we have our QuickAdminPanel which is direct competitor, I'm biased to answer. Also, I haven't used Nova myself in production projects so my knowledge is mostly from reviews and opinions I've read online. And there are two types of people:
1. Nova is awesome, Taylor did a brilliant job!
2. Nova looks awesome! But wait, how do you customize X? Oh, you need to create your own components for that? Oh, and there's no good documentation with examples about it? And no Stackoverflow topics? Hmmm...
In other words, Nova seems to be perfect for smaller panels, but heard negative reviews from people who tried to do something custom with it.
@@LaravelDaily Im agree! Nova now is not so stable, but for the moment. I think we have to wait some time, like a year
@@igoreksazonov Say whaaa? Nova was stable from the minute it came out. There is no need for documentation, the code itself tell you how to do things.
Source code through GitHub not working having many errors!!! And there is no vendor folder???
Vendor folder appears only when you run composer install. And what exactly is not working for you, give more details and I can comment.
@@PovilasKorop composer installed already!!. Is we have to installed it for every time?
@@nabeelahmad9896 If you have run "composer install", then there should be a vendor folder generated. For more details, please read how Composer works, I'm not teaching that basic knowledge in this video.
My "auth()->id()" is always returning null. What should i do in this case?
It means you're not logged in.
The login works fine, i can access the user on other pages. Only in the trait returns null.
@@matheusoliveira9516 very weird, so on that page where you use that trait, that page is probably missing the login session? Sorry I can't debug it for you
@@PovilasKorop Yeah, I think it's the session. Thanks man.
@@matheusoliveira9516 How did you solve this issue?
Can you tell me what this admin template name is?
Template is AdminLTE. Generator is our own quickadminpanel.com
FYI, this is multitenancy in a single database..