Eloquent withCount with Conditions and Aliases

To calculate the related records, we use withCount() in Eloquent. But there are a few "advanced" features I want to show you today.
- - - -
Support the channel by checking out my products:
My Laravel courses: laraveldaily.c...
Laravel QuickAdminPanel: quickadminpane...
Livewire Kit Components: livewirekit.com
- - - -
Other places to follow:
My weekly Laravel newsletter: us11.campaign-...
My personal Twitter: / povilaskorop

[@chidiebere]

Thank you. This is an eye opener. Not only with withCount, you have shown what it's possible with other eloquent methods for a situation like this.

[@Niboros]

Thank you for going the extra mile and showcasing the various posibilities how to implement such a feature, and explaining the recommendations.

[@dailyd3n]

Thanks for video. And also u can replace in relations: *_male,female "$this->hasMany(User::class)" to "$this->users()->where(....)" 🙂

[@mibrahim4245]

Sorry but can you explain more with one example? ..

[@p30mehrdad]

you always surprise us with a new useful tip. thank you.😊

[@MorshedulArefinBD]

Excellent Explanation

[@amirulidzham]

Splendid again. Thanks .

[@ekpotosammuel6868]

Thanks for making this video

[@ivan.silicin]

Thank you, just what I need.

[@kinanmissing]

super surprise thank you so much solved my problem

[@bhaveshverma8629]

Thank. Very good 👍👍👍👍👍👍

[@AMoktar]

Thats awesome thanks

[@hadidagher9443]

great video as always, what about this: users->groupBy(x) // 5 groups
How to count groupBy elements?

[@LaravelDaily]

Impossible to answer without exact example: grouping may happen with raw query, with eloquent, with collections, depending on the situation.

[@neerajsinghtangariya2587]

🔥

[@freejobsadda2018]

Hi sir i need code for a project i will pay u money for that

[@entertaint3045]

you r amazing.. do you have vid laravel websocket.. sory out of topic.. 😅😅

[@LaravelDaily]

No, and that's why: twitter.com/PovilasKorop/status/1470640480593801216

[@entertaint3045]

@@LaravelDaily great.. thanks

[@tenzinchemi1459]

Male/Female/Others

[@janugameryt5893]

sir i want simple senario please give me

[@tstarfish8829]

I don't understand why are you adding extra words related:/column:/operator: into hasMany(...) function, when it works also without it. And it is not in the Laravel doc. like that.

[@LaravelDaily]

PHPStorm does that for me automatically, these are hints, not the code.

[@GC_WK2]

why female relation repeat the code? I think better return $this->users()->where('gender','female');

[@LaravelDaily]

Also possible, yes.

[@KnightYoshi]

I'd call `where` off of the existing `users()` method just to prevent that duplication
public function users_male(): HasMany {return $this->users()->where(...);}