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

Exemple #1

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

 /**
  * Query builder scope for pending assets
  *
  * @param  Illuminate\Database\Query\Builder $query Query builder instance
  *
  * @return Illuminate\Database\Query\Builder          Modified query builder
  */
 public function scopeAssetsByLocation($query, $location)
 {
     return $query->where(function ($query) use($location) {
         $query->whereHas('assigneduser', function ($query) use($location) {
             $query->where('users.location_id', '=', $location->id);
         })->orWhere(function ($query) use($location) {
             $query->where('assets.rtd_location_id', '=', $location->id);
             $query->whereNull('assets.assigned_to');
         });
     });
 }

Exemple #2

Fichier : Project.php Projet : rafaelvieiras/connect

 /**
  * Querie all not completed projects
  *
  * @param Illuminate\Database\Query\Builder $query
  *
  * @return Illuminate\Database\Query\Builder
  */
 public function scopeOpen($query)
 {
     return $query->whereNull('completed_at');
 }