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