/** * 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); }