How to make one view to display the activities of all tenants in single (possibly different) App.

[nelson8013]

I am building a school management application for schools and the Spatie Multi-tenant package has helped make the app tenant aware.

Now, I need to create an admin view that shows all schools (tenants), the number of parents in the school, number of students, number of teachers, etc.

Can anyone help?

Technical Details:

1. Database: Multiple Databases (one DB per tenant).
2. Spatie multi-tenant v1.

[masterix21]

What are your doubts about it?

[nelson8013]

I do not have any doubts. I just want to create another page (possibly a different app) where I can see all activities of all the tenants. In an admin panel showing the total count of teachers, students, and parents per school.

[nelson8013]

@masterix21 Please do you know how I might go about achieving this? If you want, I can share additional detail to help you guide me. In the unlikely event that you cannot help me, please kindly refer me to someone within the community that can assist me.

Thanks In advance Luca

[bayangan]

You only need to loop all the tenants with

Tenant::all()->eachCurrent(function(Tenant $tenant) { 
  //here $tenant is make current, so the switching db is already done
  //you can use query against db to mine data, for eg querying teachers table which exist in tenant db
});

[nelson8013]

Thank you so much bayangan. This has been very helpful.

…

On Sat, Jun 25, 2022 at 5:34 PM bayangan ***@***.***> wrote: You only need to loop all the tenants with Tenant::all()->eachCurrent(function($tenant) { //here $tenant is make current, so the switching db is already done //you can use query against db to mine data, for eg querying teachers table which exist in tenant db }); — Reply to this email directly, view it on GitHub <#369 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ADAPCYGEWWSKKMZJXOC3J43VQ4YHRANCNFSM5YJEZH3A> . You are receiving this because you authored the thread.Message ID: ***@***.*** com>

[masterix21]

IMHO the use of a stats counter is better. Take a look:
https://github.com/spatie/laravel-stats

[nelson8013]

Thanks, I'll check it out.

…

On Mon, Jun 27, 2022, 23:12 Luca Longo ***@***.***> wrote: IMHO the use of a stats counter is better. Take a look: https://github.com/spatie/laravel-stats — Reply to this email directly, view it on GitHub <#369 (reply in thread)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ADAPCYFS2CT5N3RCBLRYZRTVRIROBANCNFSM5YJEZH3A> . You are receiving this because you authored the thread.Message ID: ***@***.*** com>