private function ApplyFilter()
{
$fieldNames = array();
$fieldFilters = array();
foreach ($this->dataset->GetFields() as $field) {
if ($this->page->GetSimpleSearchAvailable() && $this->page->GetGrid()->SearchControl instanceof SimpleSearch) {
if ($this->page->GetGrid()->SearchControl->ContainsField($field->GetName())) {
if ($field->GetEngFieldType() != ftBlob) {
$fieldNames[] = $field->GetName();
$fieldFilters[] = new FieldFilter('%' . $this->value . '%', 'ILIKE', true);
}
} else {
if ($this->dataset->IsLookupFieldByPrimaryName($field->GetName()) != null) {
$lookupFieldName = $this->dataset->IsLookupFieldByPrimaryName($field->GetName());
if ($this->page->GetGrid()->SearchControl->ContainsField($lookupFieldName)) {
$fieldNames[] = $lookupFieldName;
$fieldFilters[] = new FieldFilter('%' . $this->value . '%', 'ILIKE', true);
}
}
}
}
}
if (count($fieldFilters) > 0) {
$this->dataset->AddCompositeFieldFilter('OR', $fieldNames, $fieldFilters);
}
}
private function GetFilterConditionAsSQL(Dataset $dataset, FilterCondition $filter)
{
if (count($filter->GetValues()) == 0 && count($filter->GetDisplayValues()) > 0) {
$newFilter = new FilterCondition($dataset->IsLookupFieldByPrimaryName($filter->GetFieldName()), $filter->GetOperator(), $filter->GetDisplayValue(0));
$legacyFilter = $this->CreateLegacyFilter($newFilter);
} else {
$legacyFilter = $this->CreateLegacyFilter($filter);
}
return $this->legacyGenerator->CreateCondition($legacyFilter, $dataset->GetFieldInfoByName($filter->GetFieldName()));
}
private function GetFilterConditionAsSQL(Dataset $dataset, FilterCondition $filter)
{
if ($filter->GetValue(0) == '' && $filter->GetDisplayValue() != '') {
$newFilter = new FilterCondition($dataset->IsLookupFieldByPrimaryName($filter->GetFieldName()), $filter->GetOperator(), $filter->GetDisplayValue());
$legacyFilter = $this->CreateLegacyFilter($newFilter);
return $this->legacyGenerator->CreateCondition($legacyFilter, $dataset->GetFieldInfoByName($newFilter->GetFieldName()));
} else {
$legacyFilter = $this->CreateLegacyFilter($filter);
return $this->legacyGenerator->CreateCondition($legacyFilter, $dataset->GetFieldInfoByName($filter->GetFieldName()));
}
/*return StringUtils::Format('(%s %s %s)',
$filter->GetFieldName(),
$this->GetConditionOperatorAsSQL($filter->GetOperator()),
$this->GetFieldValueAsSQL($filter->GetFieldName(), $filter->GetValue(0))
);*/
}
