To add to tip 1. If you want to avoid "if" blocks, you can use the eloquent "when" method. return Property::query() ->when($request->get('rent'), function ($query) use ($request) { return $query->where('rent', 'when($request->get('rent'), fn($query) => $query->where('rent', '

Thank you Andrew! Just what I was looking for, but couldn't find anywhere else!

Great video! I am constantly dealing with dates and expirations within my App, tip 5 is gonna be super helpful!

I'd looking for tip-two to make a streamlined code for a long time , thanks a lot. Extraordinary !

The Tip four that adds requests count attribute will cause extra db call for each technician since to compute the model attributes aggregate query will be executed. To deal with this problem you can use Laravel Eloquent Query Builder `withCount` method like->withCount('requests'). The method will add requests_count attribute for each model with single query

Tip number 4 is what I’ve been seeking for a long time. Thanks a lot

Found your channel recently. Good Stuff, keep going.

I haven't watched complete video but still i believe that this is going to be one of the best video on eloquent... Much love for you keep up the good work

I really like the way you are using to elaborate

Great tips! saved my time so much.

And another great and useful examples. Thank you

Awesome video, I have suggestion you could make a new custom Request for example TenantSearchRequest and you should make all query parameters nullable and add string boolean validation etc, so you could get only those that are inside the request so you don't have to be scared if someone sends you a parameter you don't expect in you API for an example, and you get those parameters with $request->validated() and apply same logic. And one more since you are using PHP storm use laravel ide helper to generate models annotations for intellisense, and you can access requests_count dynamic fields. Cheers mate!

tip 2 is super brand new to me! Thankss

Very useful things..........i almost know all of them but its surely some parts where new. Thanks

Great tips Andrew, I'm wondering what keyboard are you using, there is an audible click that I find very satisfying.

This was an amazing tutorial!

This is brilliant, thank you!

Awesome tips. Please post more video on eloquent tips Andrew.

If you'd like to see the full source code behind this video, I've created a repo for it here: github.com/aschmelyun/video-5-laravel-eloquent-tips Also, if you'd like to directly support these videos and open-source projects, consider sponsoring me on GitHub: github.com/sponsors/aschmelyun

Great Job! Thanks a lot!

for the first optimization, there is also ->when for eloquent queries. No need to write out IF statements

Great tips 👍

You are awesome man, great respect for you! (y)

perfect bro, keep it up

Nice tips 👍👍👍

You are amazing. Thank you

Super helpful!

I think for tip 4, we can also use withCount from Lavaravel 5.2.32 or higher.

Thanks, it help me.

Hi andrew Great tips however i have a question Hoe about including join if conditiions is true Like if a request comes so i want to join a new table into existing eloquent query ...

what text editor are you using ?

thank you Andrew

Super helpful..

Thank you, how queries from relations e.g, products belong to a category and products also belongs to a type, how to get query of categories that their products have a specific type?

Thanks a lot❤️

Amazing video. Please make video Vue js pagination with later with filter queue string.

Very helpful

do you have a video that store json text to database, i'm still strugling with that?

Could you help please - I have inventory system with 2 models (invoice) with relationship items morphMany Item model I need to get item record with MAX date of purchase

For tip 1 u can use ->when($expr, $callback) function

Amazinng!

Hi, thanks for the tips. I have one doubt, why not use built in withCount method to get the count on tip 4 How is your method better than the built in method. Great videos by the way🙂

amazing !!!!

nice video Which extention you use for suggetion

i love this

Have you think in do an tutorial explaining queries for statistics. I haven seen videos about!. Have a good day

Good!

How does the object $poperties know what table to query just by initializing it with Property::query()?

Why we have to write like "uri" or "action" at route code ?

Thanks alot

Subscribed

how are you formatting your return data to look like that?

What's ".test" on your URL project? Is this somehow online?

tip3 is fire

In the first tip what is ::query() method?

Tip 1: You could also use Laravel pipelines. It abstracts the 'ifs' into classes. If you need to add more filters, you just create a new class without modifying your controller classes app(Pipeline::class) ->send($this->model->query()) ->through( Client::class, CallStatus::class , Sort::class )->thenReturn()->get(); An example: It filters this model by client_id, call_status and then sorts them. The filters are run only when they are present in the request

what is the name of IDE that you using in video?

are you doing nuxt js tutorials?

Great

I believe there is no information about ::query method in Laravel docs (your first tip). It's an awesome tip, but I can't believe there's no info about this. Or I missed it?

How about the amount of query executed?

What IDE is used in this video please ?

Hi, can you provide a github repo for this?

esto me salvo la vida User::whereHas('model', function ($query) { $query->where('propiedad', '!=', 'value'); })->with(['model', 'model'])->get();

What ide is that?

Laravel Tips and Tricks - kzfaq.info/get/bejne/odycerqi18fDopc.html

what’s your keyboard 😅?

Diamond content

Way too many commercials interrupting this tutorial. Hard to follow with so many interruptions.

Говнокодик конечно… есть ощущение, что только программисты из СНГ заботятся о качестве кода.

Another tip, You can now use ->latest() in your queries which will getlatest by created date (afaik)

I've been using Mehradsadeghi\FilterQueryString for years. Forget about if's and when's. Let the library do all that work for you. I can't find a cleaner way to do it.

Laravel Tips and Tricks - kzfaq.info/get/bejne/odycerqi18fDopc.html