/**
* Find data by excluding multiple values in one field
*
* @param $field
* @param array $values
* @param array $columns
*
* @return mixed
*/
public function findWhereNotIn($field, array $values, $columns = ['*'])
{
$this->applyCriteria();
$model = $this->model->whereNotIn($field, $values)->get($columns);
$this->resetModel();
return $this->parserResult($model);
}
/**
* Add whereNotIn condition for next query.
*
* @param string $column
* @param array $value
*
* @return void
*/
public function whereNotIn($column, array $value)
{
$this->model = $this->model->whereNotIn($column, $value);
return $this;
}
/**
* @return mixed
* Get
* @todo : Cache the Query
*/
public function availableCountries()
{
$selectedCountry = Session::has('user.country') ? Session::get('user.country') : null;
$query = $this->model->whereNotIn('iso_code', [$selectedCountry])->get();
return $query;
}
/**
* Find data by excluding multiple values in one field
*
* @param $field
* @param array $values
*
* @return mixed
*/
public function whereNotIn($field, array $values)
{
$this->applyCriteria();
$this->model = $this->model->whereNotIn($field, $values);
return $this;
}
/**
* @param EloquentBuilder|QueryBuilder|Model $query
* @param string $column
* @param QueryBuilder $subQuery
* @param string $subQueryColumn
*
* @return QueryBuilder
*/
public function scopeWhereNotInSubQuery($query, $column, $subQuery, $subQueryColumn)
{
$subQuery = $subQuery->toSubQuery($subQueryColumn, true);
return $query->whereNotIn($column, $subQuery);
}
