Which is best way to call model function in controller with multiple where condition using Laravel ?

• Create function in model with multiple where condition
• Possibility to use group by with aggregate (Multiple group by as well)
• Use whereIn
• Use Order By

I mean make it dynamically as more you can

Also explain how we can call in controller by using load model first.

via Chebli Mohamed