Add whereIsOrIn method to builder

[tapacko88]

I am converting old CI code to Laravel and in some case I can receive value or array. I am using Builder::macro in project, but propose to add method to builder like:

public function whereIsOrIn (string $column, mixed $values)
{
     return $this->whereIn($column, is_array($values) ? $values : [$values]);
}

What do you think guys?

[crynobone]

You can use the following:

use Illuminate\Support\Arr;

$this->whereIn($column, Arr::wrap($values));

[tapacko88]

Thanks, good decision for first case, but now my situation is more difficult. I can receive NULL as value and in array [null, 1, 3, 5]. I modified my function:

public function whereIsOrIn(string $column, mixed $values)
{
    if (is_array($values)) {
        if (in_array(null, $values, true)) {
            $this->whereIn($column, $values)->orWhereNull($column);
        } else {
            $this->whereIn($column, $values);
        }
    } elseif ($values === null) {
        $this->whereNull($column);
    } else {
        $this->where($column, $values);
    }
}