How To Use groupBy in whereHas laravel

Question

i am using Metable in my project for creating meta for orders
but i have one problem
i want group orders that have same email
this is metable table image : image 1 image 2

i need code like this can work :)

Order::whereHas( 'meta', function($query) {
        $query->where("key" , "gmail");
})->groupBy('meta.value')->get();

and this is meta relation that called by trait 'use Metable' in Order Model:

public function meta(): MorphMany
{
    return $this->morphMany($this->getMetaClassName(), 'metable');
}

Thanks

Kevin Bui · Accepted Answer · 2020-01-08T23:22:39.847

1

This query may work, we start querying from the Meta model:

Meta::with('metable')
    ->whereHasMorph('metable', Order::class)
    ->where('key', 'gmail')
    ->get()
    ->groupBy('value')
    ->map(function ($metaCollection) {
        return $metaCollection->map->metable->unique('id');
    });

edited Jan 08 '20 at 23:22

answered Jan 08 '20 at 22:27

Kevin Bui

2,754
1
14
15

it not worked :( | said Property [value] does not exist on this collection instance. – Dr Web Jan 08 '20 at 22:52
Can you post a different image of the meta table that reveals all column names? – Kevin Bui Jan 08 '20 at 22:53
I know why it failed and updated the answer accordingly, pls check. – Kevin Bui Jan 08 '20 at 23:23
tnx dude , it's workd :) there is anyway that get them from Order not Meta? – Dr Web Jan 08 '20 at 23:27

score 0 · Answer 2 · answered Jan 08 '20 at 23:51

0

This is untested, but I would give it a try to retrive the models from the Order class:

Order::whereHas('meta', function($query) {
    $query->where('key', 'gmail');
})->with(['meta' => function($query) {
    $query->groupBy('value')
}])->get();

answered Jan 08 '20 at 23:51

mdexp

3,492
2
9
20

not worked , this code returnd all objects that have meta ! and groupby not worked – Dr Web Jan 09 '20 at 08:24

score 0 · Answer 3 · edited Jan 09 '20 at 09:56

0

Try this solution instead:

Order::whereHas( 'meta', function($query) {
    $query->where("key" , "gmail")
    $query->groupBy('meta.value');
})->get();

edited Jan 09 '20 at 09:56

sud007

5,824
4
56
63

answered Jan 09 '20 at 09:39

Chinnu

61
8

How To Use groupBy in whereHas laravel

3 Answers3