/** * @param ParameterBag $query * @param QueryConfigurationBuilder $builder */ public function getSearchColumns($query, $builder, array $columnConfiguration) { // for each column we need to see if there is a search value $columns = $query->get('columns'); foreach ($columnConfiguration as $i => $c) { // check if there is something search related if (!isset($columns[$i])) { continue; } if ($c->getSearch()->isSearchable()) { // search for this column is available $value = $columns[$i]['search']['value']; if (!$this->isEmpty($value)) { $builder->columnSearch($c->getName(), $columns[$i]['search']['value']); } } } }
/** * @param array $columns incoming column request * @param QueryConfigurationBuilder $builder * @param ColumnConfiguration $column * @param integer $position position of the column in the columnConfiguration loop */ private function addColumnSearchToBuilderIfRequested($columns, $builder, $column, $position) { if ($column->getSearch()->isSearchable()) { // search for this column is available $value = $columns[$position]['search']['value']; if (!$this->isEmpty($value)) { $builder->columnSearch($column->getName(), $value); } } }
/** * @param ParameterBag $query * @param QueryConfigurationBuilder $builder * @param ColumnConfiguration $column * @param integer $position position of the column in the columnConfiguration loop */ private function addColumnSearchToBuilderIfRequested($query, $builder, $column, $position) { $query_key = 'sSearch_' . $position; if ($column->getSearch()->isSearchable() && $query->has($query_key) && !$this->isEmpty($query->get($query_key))) { $builder->columnSearch($column->getName(), $query->get($query_key)); } }
/** * @param ParameterBag $query * @param QueryConfigurationBuilder $builder */ public function getSearchColumns($query, $builder, array $columnConfiguration) { // for each column we need to see if there is a search value foreach ($columnConfiguration as $i => $c) { // check if there is something search related if ($c->getSearch()->isSearchable() && $query->has("sSearch_" . $i) && !$this->isEmpty($query->get("sSearch_" . $i))) { // search for this column is available $builder->columnSearch($c->getName(), $query->get("sSearch_" . $i)); } // check if there is something order related if ($c->getOrder()->isOrderable() && $query->has("iSortCol_" . $i) && !$this->isEmpty($query->get("iSortCol_" . $i))) { // order for this column is available $builder->columnOrder($c->getName(), $query->get("sSortDir_" . $i)); } } }