How to remove duplicates in collection?

Question

I have collection in Laravel:

Collection {#450 ▼
  #items: array:2 [▼
    0 => Announcement {#533 ▶}
    1 => Announcement {#553 ▶}
  ]
}

It is the same items. How ti delete one of them?

Full code is:

public function announcements()
    {

        $announcements = $this->categories_ann->map(function ($c) {
            return $c->announcements->map(function ($a) {
                $a->subsribed = true;

                return $a;
            });
        });

        $flattened = $announcements->groupBy("id")->flatten();

        return $flattened;
    }

check this https://stackoverflow.com/questions/43993581/removing-the-duplicates-from-the-object/43993750#43993750 — Nikhil Radadiya, May 25 '17 at 05:45

score 77 · Accepted Answer · answered May 24 '17 at 22:43

77

$unique = $collection->unique();

answered May 24 '17 at 22:43

MevlütÖzdemir

3,180
1
23
28

And if you try: $unique = $collection->flatten()->unique(); – MevlütÖzdemir May 24 '17 at 22:46
1

The same situation – Blablacar May 24 '17 at 22:52
1

`$flattened = $announcements->flatten()->unique(); $flattened->all();` – Blablacar May 24 '17 at 22:52
I have this relations, that returns me duplicates. I tried to use here groupby: `public function announcements() { return $this->belongsToMany('App\Announcement')->start()->groupBy("id"); }` – Blablacar May 24 '17 at 23:03
Yes, but only announcements on which user subsribed – Blablacar May 24 '17 at 23:17
For actually eliminating duplicate models in a collection, for me it worked this approach: $unique = $collection->unique('id'); $final = $unique->values()->all(); – Mariana Marica Sep 10 '21 at 11:20

score 44 · Answer 2 · answered Aug 29 '18 at 21:29

$collection = collect([
    ['name' => 'iPhone 6', 'brand' => 'Apple', 'type' => 'phone'],
    ['name' => 'iPhone 5', 'brand' => 'Apple', 'type' => 'phone'],
    ['name' => 'Apple Watch', 'brand' => 'Apple', 'type' => 'watch'],
    ['name' => 'Galaxy S6', 'brand' => 'Samsung', 'type' => 'phone'],
    ['name' => 'Galaxy Gear', 'brand' => 'Samsung', 'type' => 'watch'],
]);

Then let's say you want the brand to be unique, in this case you should only get two brands 'Apple', and 'Samsung'

$unique = $collection->unique('brand');

$unique->values()->all();
/*
    [
        ['name' => 'iPhone 6', 'brand' => 'Apple', 'type' => 'phone'],
        ['name' => 'Galaxy S6', 'brand' => 'Samsung', 'type' => 'phone'],
    ]
*/

This is taken from https://laravel.com/docs/master/collections#method-unique

score 0 · Answer 3 · answered Jan 21 '21 at 12:14

0

You can unique the data set from the SQL level with groupBy + Max Try below

YourModelName::select(DB::raw('max(`town_short_name`) as town' 'town_long_name'))
        ->groupBy(['town_short_name'])
        ->without('postalCode','country','countryState')
        ->where('town_short_name','like','%'.$townName.'%')
        ->limit(100)
        ->orderBy('town_short_name');

answered Jan 21 '21 at 12:14

Chameera W. Ashan

346
4
7

This is not what the OP asked for. – henritroyat Jan 25 '23 at 13:04

How to remove duplicates in collection?

3 Answers3

Linked