Eloquent - Where Date >= date(now) and whereNull('date')

Question

I get all items from a table where:

• endDate is >= now
• endDate is NULL
• published equals 1.

This is what I have, but it gives me 0 items:

$items = Items::orderBy(\DB::raw('RAND()'))
  ->where('endDate', '>=', date("Y-m-d"))
  ->whereNull('endDate')
  ->where('published', '1')
  ->whereIn('cid', $this->activeId)
  ->orderBy('id')
  ->paginate(4);

Answer 1

You need to use a closure and the orWhereNull():

->where(function($q) {
    $q->where('endDate', '>=', date("Y-m-d"))
      ->orWhereNull('endDate');
})