protected function process() { $this->method = 'GET'; //database save switch ($this->action) { case "search": // prepare the WHERE clause foreach ($this->fields as $field) { $field->getValue(); $field->getNewValue(); $value = $field->new_value; //query scope $query_scope = $field->query_scope; $query_scope_params = $field->query_scope_params; if ($query_scope) { if (is_a($query_scope, '\\Closure')) { array_unshift($query_scope_params, $value); array_unshift($query_scope_params, $this->query); $this->query = call_user_func_array($query_scope, $query_scope_params); } elseif (isset($this->model) && method_exists($this->model, "scope" . $query_scope)) { $query_scope = "scope" . $query_scope; array_unshift($query_scope_params, $value); array_unshift($query_scope_params, $this->query); $this->query = call_user_func_array([$this->model, $query_scope], $query_scope_params); } continue; } //detect if where should be deep (on relation) $deep_where = false; if (isset($this->model) && $field->relation != null) { $rel_type = get_class($field->relation); if (is_a($field->relation, 'Illuminate\\Database\\Eloquent\\Relations\\HasOne') || is_a($field->relation, 'Illuminate\\Database\\Eloquent\\Relations\\HasMany') || is_a($field->relation, 'Illuminate\\Database\\Eloquent\\Relations\\BelongsTo') || is_a($field->relation, 'Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany')) { if (is_a($field->relation, 'Illuminate\\Database\\Eloquent\\Relations\\BelongsTo') and in_array($field->type, array('select', 'radiogroup', 'autocomplete'))) { $deep_where = false; } else { $deep_where = true; } } } if ($value != "" or is_array($value) and count($value)) { if (strpos($field->name, "_copy") > 0) { $name = substr($field->db_name, 0, strpos($field->db_name, "_copy")); } else { $name = $field->db_name; } //$value = $field->value; if ($deep_where) { //exception for multiple value fields on BelongsToMany if (is_a($field->relation, 'Illuminate\\Database\\Eloquent\\Relations\\BelongsToMany') || is_a($field->relation, 'Illuminate\\Database\\Eloquent\\Relations\\BelongsTo') and in_array($field->type, array('tags', 'checks', 'multiselect'))) { $values = explode($field->serialization_sep, $value); if ($field->clause == 'wherein') { $this->query = $this->query->whereHas($field->rel_name, function ($q) use($field, $values) { $q->whereIn($field->rel_fq_key, $values); }); } if ($field->clause == 'where') { foreach ($values as $v) { $this->query = $this->query->whereHas($field->rel_name, function ($q) use($field, $v) { $q->where($field->rel_fq_key, '=', $v); }); } } continue; } switch ($field->clause) { case "like": $this->query = $this->query->whereHas($field->rel_name, function ($q) use($field, $value) { $q->where($field->rel_field, 'LIKE', '%' . $value . '%'); }); break; case "orlike": $this->query = $this->query->orWhereHas($field->rel_name, function ($q) use($field, $value) { $q->where($field->rel_field, 'LIKE', '%' . $value . '%'); }); break; case "where": $this->query = $this->query->whereHas($field->rel_name, function ($q) use($field, $value) { $q->where($field->rel_field, $field->operator, $value); }); break; case "orwhere": $this->query = $this->query->orWhereHas($field->rel_name, function ($q) use($field, $value) { $q->where($field->rel_field, $field->operator, $value); }); break; case "wherebetween": $values = explode($field->serialization_sep, $value); $this->query = $this->query->whereHas($field->rel_name, function ($q) use($field, $values) { if ($values[0] != '' and $values[1] == '') { $q->where($field->rel_field, ">=", $values[0]); } elseif ($values[0] == '' and $values[1] != '') { $q->where($field->rel_field, "<=", $values[1]); } elseif ($values[0] != '' and $values[1] != '') { //we avoid "whereBetween" because a bug in laravel 4.1 $q->where(function ($query) use($field, $values) { return $query->where($field->rel_field, ">=", $values[0])->where($field->rel_field, "<=", $values[1]); }); } }); break; case "orwherebetween": $values = explode($field->serialization_sep, $value); $this->query = $this->query->orWhereHas($field->rel_name, function ($q) use($field, $values) { if ($values[0] != '' and $values[1] == '') { $q->orWhere($field->rel_field, ">=", $values[0]); } elseif ($values[0] == '' and $values[1] != '') { $q->orWhere($field->rel_field, "<=", $values[1]); } elseif ($values[0] != '' and $values[1] != '') { //we avoid "whereBetween" because a bug in laravel 4.1 $q->orWhere(function ($query) use($field, $values) { return $query->where($field->rel_field, ">=", $values[0])->where($field->rel_field, "<=", $values[1]); }); } }); break; } //not deep, where is on main entity } else { switch ($field->clause) { case "like": $this->query = $this->query->where($name, 'LIKE', '%' . $value . '%'); break; case "orlike": $this->query = $this->query->orWhere($name, 'LIKE', '%' . $value . '%'); break; case "where": $this->query = $this->query->where($name, $field->operator, $value); break; case "orwhere": $this->query = $this->query->orWhere($name, $field->operator, $value); break; case "wherein": $this->query = $this->query->whereIn($name, explode($field->serialization_sep, $value)); break; case "wherebetween": $values = explode($field->serialization_sep, $value); if (count($values) == 2) { if ($values[0] != '' and $values[1] == '') { $this->query = $this->query->where($name, ">=", $values[0]); } elseif ($values[0] == '' and $values[1] != '') { $this->query = $this->query->where($name, "<=", $values[1]); } elseif ($values[0] != '' and $values[1] != '') { //we avoid "whereBetween" because a bug in laravel 4.1 $this->query = $this->query->where(function ($query) use($name, $values) { return $query->where($name, ">=", $values[0])->where($name, "<=", $values[1]); }); } } break; case "orwherebetween": $values = explode($field->serialization_sep, $value); if (count($values) == 2) { if ($values[0] != '' and $values[1] == '') { $this->query = $this->query->orWhere($name, ">=", $values[0]); } elseif ($values[0] == '' and $values[1] != '') { $this->query = $this->query->orWhere($name, "<=", $values[1]); } elseif ($values[0] != '' and $values[1] != '') { //we avoid "whereBetween" because a bug in laravel 4.1 $this->query = $this->query->orWhere(function ($query) use($name, $values) { return $query->where($name, ">=", $values[0])->where($name, "<=", $values[1]); }); } } break; } } } } // dd($this->query->toSql()); break; case "reset": $this->process_status = "show"; return true; break; default: return false; } }
/** * Build wildcard query filters. * * @param \Illuminate\Database\Eloquent\Builder|\Illuminate\Database\Query\Builder $query * @param array $fields * @param array $keyword * @param string $group * * @return void */ protected function buildWildcardQueryFilters($query, array $fields, array $keyword = []) { foreach ($fields as $field) { if (Str::contains($field, '.') && $query instanceof Builder) { list($relation, $field) = explode('.', $field, 2); $query->orWhereHas($relation, function ($query) use($field, $keyword) { $this->buildWildcardQueryFilterWithKeyword($query, $field, $keyword, 'where'); }); } else { $this->buildWildcardQueryFilterWithKeyword($query, $field, $keyword, 'orWhere'); } } }