i have a team, project, user, role, permissions relationship in laravel. User can have many teams, a team can have many projects and user can have User role, team role and project role. How can i get the user permissions…
I’ve next database structure: friends: id, first_name, last_name, friends_activities: friend_id, user_id, type (enum), created_at, friends_reactions: friend_id, user_id, type (enum), And I need to count all friends_reactions and friends_activity together as e.g. engagements_count. So far I’ve created eloquent relationship in the…
As @JonasStaudenmeir answered on laravel eager loading with limit, which query looks like: User::select('id') ->with([ 'posts' => fn($query) => $query->select(['id', 'user_id'])->limit(4) ]) ->limit(2) ->get(); select `id` from `users` limit 2 select * from (select `id`, `user_id`, row_number() over (partition by…
I have three models: Product Review Score They are linked like this: Product (hasMany) -> Review (hasOne) -> Score Review model: text product_id score_id Score model: value (number) My relation in Product model: public function reviews () { return $this->hasMany(Review::class,…
I am working on the Laravel back-end and I have a some question. Can I put some logic methods to the the models? Get data in specific format, for example. And some like this: public function getAllWithObjects() { $all_photos =…
problem with this is withCount() not changing after when() is applied for example without when() transaction_count is 5000 and after when is applied it still remains 5000 ? it should change according to filter apply in when() public function allUsers(Request…
I'm currently taking Laravel 8 From Scratch by Jeffry Way. I'm currently in episode 54 when I faced the error below after trying to migrate:fresh --seed. I'm pretty sure I followed everything from the start. Can you please help me…
I have a Laravel Livewire model which has two public properties: A string called $tab (which I used to switch between UI tabs) A Model called $myobject (with relationships). Whenever I retrieve my $myobject model, I use the Cache::remember function…
I'm trying to populate a HTML select dropdown with values of a particular column in the database which is an array in this format ["Red","Yellow","Blue"]. I know how to pull the entire product instance for a particular row from DB…
Hello im new to laravel livewire now im trying to sum of two values and result get in another input filed. but laravel i did this using jQuery now im trying livewire instead of jQuery. now im getting 1st input…