PHPackages                             blasttech/laravel-where-plus - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. blasttech/laravel-where-plus

ActiveLibrary[Database & ORM](/categories/database)

blasttech/laravel-where-plus
============================

Extra where scopes for Laravel Eloquent

2.0.3(4y ago)125.2k↓100%1MITPHPPHP >=7.2CI failing

Since Jan 16Pushed 4y ago9 watchersCompare

[ Source](https://github.com/blasttech/laravel-where-plus)[ Packagist](https://packagist.org/packages/blasttech/laravel-where-plus)[ Docs](https://github.com/blasttech/laravel-where-plus)[ RSS](/packages/blasttech-laravel-where-plus/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (6)Dependencies (3)Versions (22)Used By (0)

laravel-where-plus
==================

[](#laravel-where-plus)

Extra where scopes for Laravel Models

Functions:

- whereOrEmptyOrNull($column, $value, $ignore)
- whereInColumn($column, $value)
- whereNotInColumn($column, $value)
- whereIfNull($column, $ifNull, $operator = null, $value = null, $boolean = 'and')

whereOrEmptyOrNull
------------------

[](#whereoremptyornull)

This adds a where condition for when a $column should be equal to $value, but not equal to a $ignore

```
  $query->whereOrEmptyOrNull('Country', $input['country'], '');
```

If $input\['country'\] is not equal to '' then this will be the equivalent of:

```
  $query->where('Country', $input['country']);
```

Otherwise if $input\['country'\] === '' then a where statement isn't added.

Likewise, a default value could be added, eg.

```
$query->whereOrEmptyOrNull('Country', $input['country'], 'Australia');
```

If you wanted to only add a where statement when $input\['country'\] isn't 'Australia'.

This can also be run with an array of columns, e.g.:

```
  $query->whereOrEmptyOrNull([
          'Country' => $input['country'],
          'State' => $input['state'],
          'Locality' => $input['locality']
      ], '', '');
```

which would add where statements for Country, State and Locality if the input fields weren't empty.

whereInColumn
-------------

[](#whereincolumn)

This adds a where condition to only include records where $value is in $column. The value of $column should be a comma delimited list.

For example:

```
  $query->whereInColumn('Country', 'Australia');
```

In SQL, this would be the equivalent of:

```
  WHERE CONCAT(',', `Country`, ',') LIKE '%,Australia,%'
```

whereNotInColumn
----------------

[](#wherenotincolumn)

This adds a where condition to only include records where $value is not in $column. The value of $column should be a comma delimited list.

For example:

```
  $query->whereNotInColumn('Country', 'Australia');
```

In SQL, this would be the equivalent of:

```
  WHERE CONCAT(',', `Country`, ',') NOT LIKE '%,Australia,%'
```

whereIfNull($column, $ifNull, $operator = null, $value = null, $boolean = 'and')
--------------------------------------------------------------------------------

[](#whereifnullcolumn-ifnull-operator--null-value--null-boolean--and)

This adds a where condition with the column wrapped in an SQL 'IFNULL' with the column as the first parameter and $ifNull as the second parameter.

For example:

```
  $query->whereIfNull('Country', 'Australia', '=', 'New Zealand');
```

In SQL, this would be the equivalent of:

```
  WHERE IFNULL(`Country`, 'Australia') = 'New Zealand'
```

Aggregates
----------

[](#aggregates)

### Available scopes

[](#available-scopes)

- addCount
- addSum
- addAvg
- addMin
- addMax

### Example

[](#example)

```
Calls::make()
  ->select(['calltype'])
  ->addCount('id')
  ->addSum('seconds')
  ->addSum('seconds', 'seconds2')
  ->groupBy('calltype');
```

In SQL, this would be the equivalent of:

```
  select calltype, count(id), sum(seconds), sum(charge)
    from calls
   group by calltype
```

Group and Order
---------------

[](#group-and-order)

### Available scopes

[](#available-scopes-1)

- groupByIndex
- orderByIndex

### Example

[](#example-1)

```
Calls::make()
  ->select(['calltype', 'description'])
  ->addSum('charge')
  ->groupByIndex(1, 2);
  ->orderByIndex(1);
```

```
  select calltype, description, sum(charge)
    from calls
   group by 1, 2
   order by 1
```

###  Health Score

35

—

LowBetter than 79% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity27

Limited adoption so far

Community14

Small or concentrated contributor base

Maturity67

Established project with proven stability

 Bus Factor2

2 contributors hold 50%+ of commits

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~80 days

Recently: every ~215 days

Total

17

Last Release

1751d ago

Major Versions

0.1.14 → 2.0.02019-10-08

PHP version history (2 changes)0.1.0PHP >=7.0

2.0.2PHP >=7.2

### Community

Maintainers

![](https://www.gravatar.com/avatar/f99e8c76b2ec65ebcc2c9c346839736e22e9f5d503e23272319937bc60ffe211?d=identicon)[mhkb](/maintainers/mhkb)

---

Top Contributors

[![mhkb](https://avatars.githubusercontent.com/u/4683976?v=4)](https://github.com/mhkb "mhkb (29 commits)")[![ivanhennig](https://avatars.githubusercontent.com/u/6207878?v=4)](https://github.com/ivanhennig "ivanhennig (27 commits)")[![maikenunes](https://avatars.githubusercontent.com/u/4635672?v=4)](https://github.com/maikenunes "maikenunes (4 commits)")

---

Tags

laravelmodeleloquentwhere

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/blasttech-laravel-where-plus/health.svg)

```
[![Health](https://phpackages.com/badges/blasttech-laravel-where-plus/health.svg)](https://phpackages.com/packages/blasttech-laravel-where-plus)
```

###  Alternatives

[mongodb/laravel-mongodb

A MongoDB based Eloquent model and Query builder for Laravel

7.1k7.2M71](/packages/mongodb-laravel-mongodb)[tucker-eric/eloquentfilter

An Eloquent way to filter Eloquent Models

1.8k4.8M26](/packages/tucker-eric-eloquentfilter)[dyrynda/laravel-model-uuid

This package allows you to easily work with UUIDs in your Laravel models.

4802.8M8](/packages/dyrynda-laravel-model-uuid)[spiritix/lada-cache

A Redis based, automated and scalable database caching layer for Laravel

591444.8k2](/packages/spiritix-lada-cache)[pdphilip/elasticsearch

An Elasticsearch implementation of Laravel's Eloquent ORM

145360.2k4](/packages/pdphilip-elasticsearch)[sebastiaanluca/laravel-boolean-dates

Automatically convert Eloquent model boolean attributes to dates (and back).

40111.7k1](/packages/sebastiaanluca-laravel-boolean-dates)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)