PHP Illuminate\Database\Query Builder::addNestedWhereQuery Examples

addNestedWhereQuery() public method

Add another query builder as a nested where to the query builder.

public addNestedWhereQuery ( Builder | static $query, string $boolean = 'and' )
$query	Builder | static
$boolean	string

Example #1

File: Builder.php Project: aysenli/laravel-admin-1

 /**
  * Add a basic where clause to the query.
  *
  * @param  string  $column
  * @param  string  $operator
  * @param  mixed   $value
  * @param  string  $boolean
  * @return \Illuminate\Database\Eloquent\Builder|static
  */
 public function where($column, $operator = null, $value = null, $boolean = 'and')
 {
     if ($column instanceof Closure) {
         $query = $this->model->newQuery();
         call_user_func($column, $query);
         $this->query->addNestedWhereQuery($query->getQuery(), $boolean);
     } else {
         $this->query->where($column, $operator, $value, $boolean);
     }
     return $this;
 }

Example #2

File: Builder.php Project: visualturk/framework

 /**
  * Add a basic where clause to the query.
  *
  * @param  string  $column
  * @param  string  $operator
  * @param  mixed   $value
  * @param  string  $boolean
  * @return $this
  */
 public function where($column, $operator = null, $value = null, $boolean = 'and')
 {
     if ($column instanceof Closure) {
         $query = $this->model->newQueryWithoutScopes();
         call_user_func($column, $query);
         $this->query->addNestedWhereQuery($query->getQuery(), $boolean);
     } else {
         call_user_func_array(array($this->query, 'where'), func_get_args());
     }
     return $this;
 }

Example #3

File: _ide_helper.php Project: satriashp/tour

 /**
  * Add another query builder as a nested where to the query builder.
  *
  * @param \Illuminate\Database\Query\Builder|static $query
  * @param string $boolean
  * @return $this 
  * @static 
  */
 public static function addNestedWhereQuery($query, $boolean = 'and')
 {
     return \Illuminate\Database\Query\Builder::addNestedWhereQuery($query, $boolean);
 }