Breaking News: Grepper is joining You.com. Read the official announcement!

laravel Don’t Filter by NULL in Collections

Add Answer

Itchy Iguana answered on September 15, 2022 Popularity 3/10 Helpfulness 1/10

answer laravel Don’t Filter by NULL in Collections

related laravel collection filter null

laravel Don’t Filter by NULL in Collections

Comment

-1

 // This works
 $messages = Message::where('read_at is null')->get();
 // Won’t work - will return 0 messages
 $messages = Message::all();
 $unread_messages = $messages->where('read_at is null')->count();
 // Will work
 $unread_messages = $messages->where('read_at', '')->count();

Popularity 3/10 Helpfulness 1/10 Language php

Source: Grepper

Tags: collections filter laravel null php

Link to this answer
Share Copy Link

Contributed on Sep 15 2022

Itchy Iguana

0 Answers Avg Quality 2/10

Closely Related Answers

laravel collection filter null

Comment

$filteredCollection = $po_items->filter(function ($value) { return !is_null($value); });

         dd($filteredCollection);

Popularity 6/10 Helpfulness 7/10 Language php

Source: Grepper

Tags: laravel-collection php null filter laravel-collec

Link to this answer
Share Copy Link

Contributed on Oct 18 2022

Shadow

0 Answers Avg Quality 2/10

laravel collection filter null

Comment

$filteredUsers = $users->filter(function ($user, $key) {
    return $user->role != null;
});

Popularity 5/10 Helpfulness 7/10 Language php

Source: Grepper

Tags: laravel-collection null filter php

Link to this answer
Share Copy Link

Contributed on Oct 18 2022

Shadow

0 Answers Avg Quality 2/10

laravel collection filter null

Comment

 return ProductOptionsModel::query()->where('product_id', $product_id)->with(['product_option_value', 'option'])->get()
            ->map(function ($option) {
                return [
                    'id'                   => $option['id'],
                    'get_lang_type'        => app()->getLocale(),
                    'option_id'            => $option['option_id'],
                    'name'                 => AdminService::trans($option->option->name),
                    'type'                 => $option['type'],
                    'required'             => $option['required'],
                    'product_option_value' => $option->product_option_value->map(function ($value) {
                        if ($value->other_product_id && $value->other_product_id !== 0 && ProductModel::query()->where('status', '!=', 0)
                                ->where('id', '=', $value->other_product_id)->exists()) {
                            return [
                                'id'                => $value->id,
                                'name'              => AdminService::trans($value->option_value->name),
                                'image'             => $value->option_value->image,
                                'product_id'        => $value->product_id,
                                'other_product_id'  => $value->other_product_id ?? 0,
                                'option_id'         => $value->option_id,
                                'product_option_id' => $value->product_option_id,
                                'option_value_id'   => $value->option_value_id,
                                'quantity'          => $value->quantity,
                                'subtract'          => $value->subtract,
                                'price'             => $value->price,
                                'price_prefix'      => $value->price_prefix,
                                'points'            => $value->points,
                                'points_prefix'     => $value->points_prefix,
                                'weight'            => $value->weight,
                                'weight_prefix'     => $value->weight_prefix,
                            ];
                        }
                    })->filter()->toArray(),
                ];
            });

Popularity 4/10 Helpfulness 6/10 Language php

Source: Grepper

Tags: null laravel-collection php filter

Link to this answer
Share Copy Link

Contributed on Oct 18 2022

Shadow

0 Answers Avg Quality 2/10

laravel collection filter null

Comment

    return ProductOptionsModel::query()->where('product_id', $product_id)->with(['product_option_value', 'option'])->get()
            ->map(function ($option) {
                return [
                    'id'                   => $option['id'],
                    'get_lang_type'        => app()->getLocale(),
                    'option_id'            => $option['option_id'],
                    'name'                 => AdminService::trans($option->option->name),
                    'type'                 => $option['type'],
                    'required'             => $option['required'],
                    'product_option_value' => $option->product_option_value->map(function ($value) {
                        if ($value->other_product_id && $value->other_product_id !== 0 && ProductModel::query()->where('status', '!=', 0)
                                ->where('id', '=', $value->other_product_id)->exists()) {
                            return [
                                'id'                => $value->id,
                                'name'              => AdminService::trans($value->option_value->name),
                                'image'             => $value->option_value->image,
                                'product_id'        => $value->product_id,
                                'other_product_id'  => $value->other_product_id ?? 0,
                                'option_id'         => $value->option_id,
                                'product_option_id' => $value->product_option_id,
                                'option_value_id'   => $value->option_value_id,
                                'quantity'          => $value->quantity,
                                'subtract'          => $value->subtract,
                                'price'             => $value->price,
                                'price_prefix'      => $value->price_prefix,
                                'points'            => $value->points,
                                'points_prefix'     => $value->points_prefix,
                                'weight'            => $value->weight,
                                'weight_prefix'     => $value->weight_prefix,
                            ];
                        }
                    })->whereNotNull()->toArray(),
                ];
            });

Popularity 4/10 Helpfulness 6/10 Language php

Source: Grepper

Tags: php filter laravel-collection null

Link to this answer
Share Copy Link

Contributed on Oct 18 2022

Shadow

0 Answers Avg Quality 2/10

laravel Don’t Filter by NULL in Collections

Contents

More Related Answers

laravel Don’t Filter by NULL in Collections

Closely Related Answers

laravel collection filter null

laravel collection filter null

laravel collection filter null

laravel collection filter null

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.