PHP Illuminate\Database\Query\Builder::whereNULL Exemples

Exemple #1

Fichier : Asset.php Projet : jbirdkerr/snipe-it

 /**
  * Query builder scope for RTD assets
  *
  * @param  Illuminate\Database\Query\Builder $query Query builder instance
  *
  * @return Illuminate\Database\Query\Builder          Modified query builder
  */
 public function scopeRTD($query)
 {
     return $query->whereNULL('assigned_to')->whereHas('assetstatus', function ($query) {
         $query->where('deployable', '=', 1)->where('pending', '=', 0)->where('archived', '=', 0);
     });
 }