private function searchConfigurationDynamic() { $search = new Manager($this); $c = $this->schema()->columns(); foreach ($c as $key => $value) { $t = $this->schema()->columnType($value); if ($t != 'string' and $t != 'text') { $search->value($value, ['field' => $this->aliasField($value)]); } else { $search->like($value, ['before' => true, 'after' => true, 'field' => $this->aliasField($value)]); } } return $search; }
private function searchConfigurationDynamic() { $search = new Manager($this); $c = $this->schema()->columns(); foreach ($c as $key => $value) { $t = $this->schema()->columnType($value); if ($t != 'string' and $t != 'text') { $search->value($value, ['field' => $this->aliasField($value)]); } else { $search->like($value, ['before' => true, 'after' => true, 'field' => $this->aliasField($value)]); } } $search->callback('associacao', ['callback' => function ($query, $args, $manager) { return $query->join(['table' => 'pessoas_associacoes', 'alias' => 'PessoasAssociacoesPesquisa', 'type' => 'INNER', 'conditions' => ['PessoasAssociacoesPesquisa.pessoa_id = Pessoas.id', 'PessoasAssociacoesPesquisa.tipo_associacao' => $args['associacao'], 'PessoasAssociacoesPesquisa.status !=' => 9]]); }]); return $search; }
private function searchConfigurationDynamic() { $search = new Manager($this); $c = $this->schema()->columns(); foreach ($c as $key => $value) { $t = $this->schema()->columnType($value); if ($t != 'string' and $t != 'text') { $search->value($value, ['field' => $this->aliasField($value)]); } else { $search->like($value, ['before' => true, 'after' => true, 'field' => $this->aliasField($value)]); } } $search->callback('barra', ['callback' => function ($query, $args, $manager) { return $query->join(['table' => 'produtos', 'alias' => 'kprodutosbarra', 'type' => 'INNER', 'conditions' => 'kprodutosbarra.id = ProdutosKits.kit_id AND kprodutosbarra.barra RLIKE "' . $args['barra'] . '" AND kprodutosbarra.produto_kit = 1']); }]); $search->callback('nome', ['callback' => function ($query, $args, $manager) { return $query->join(['table' => 'produtos', 'alias' => 'kprodutosnome', 'type' => 'INNER', 'conditions' => 'kprodutosnome.id = ProdutosKits.kit_id AND kprodutosnome.nome RLIKE "' . $args['nome'] . '" AND kprodutosnome.produto_kit = 1']); }]); return $search; }
public function searchConfiguration() { $search = new Manager($this); $search->value('username', ['field' => $this->aliasField('username')])->like('q', ['before' => true, 'after' => true, 'field' => [$this->aliasField('firstname'), $this->aliasField('lastname')]]); return $search; }
public function searchConfiguration() { $search = new Manager($this); $search->value('author', ['label' => '', 'field' => $this->aliasField('author'), 'placeholder' => 'Search by Author'])->like('q', ['label' => '', 'placeholder' => 'Search by Content', 'before' => true, 'after' => true, 'field' => [$this->aliasField('title'), $this->aliasField('body')]]); return $search; }
/** * Construct search configuration * * @return Search\Manager */ public function searchConfiguration() { $search = new Manager($this); $search->value('is_active')->like('name', ['before' => true, 'after' => true, 'field' => 'name'])->like('content', ['before' => true, 'after' => true, 'field' => ['name', 'body']])->finder('active', ['form' => false])->callback('id', ['callback' => [$this, 'onlyThisId']]); return $search; }
public function searchConfiguration() { $search = new Manager($this); $search->value('id_modulo', ['field' => $this->aliasField('id_modulo'), 'filterEmpty' => true])->like('nome', ['before' => true, 'after' => true, 'field' => [$this->aliasField('nome')], 'filterEmpty' => true]); return $search; }