function GetDropDownFilter(&$fld, $FldVal, $FldOpr)
{
$FldName = $fld->FldName;
$FldExpression = $fld->FldExpression;
$FldDataType = $fld->FldDataType;
$FldDelimiter = $fld->FldDelimiter;
$FldVal = strval($FldVal);
$sWrk = "";
if ($FldVal == EWR_NULL_VALUE) {
$sWrk = $FldExpression . " IS NULL";
} elseif ($FldVal == EWR_NOT_NULL_VALUE) {
$sWrk = $FldExpression . " IS NOT NULL";
} elseif ($FldVal == EWR_EMPTY_VALUE) {
$sWrk = $FldExpression . " = ''";
} elseif ($FldVal == EWR_ALL_VALUE) {
$sWrk = "1 = 1";
} else {
if (substr($FldVal, 0, 2) == "@@") {
$sWrk = $this->GetCustomFilter($fld, $FldVal);
} elseif ($FldDelimiter != "" && trim($FldVal) != "") {
$sWrk = ewr_GetMultiSearchSql($FldExpression, trim($FldVal));
} else {
if ($FldVal != "" && $FldVal != EWR_INIT_VALUE) {
if ($FldDataType == EWR_DATATYPE_DATE && $FldOpr != "") {
$sWrk = ewr_DateFilterString($FldExpression, $FldOpr, $FldVal, $FldDataType);
} else {
$sWrk = ewr_FilterString("=", $FldVal, $FldDataType);
if ($sWrk != "") {
$sWrk = $FldExpression . $sWrk;
}
}
}
}
}
return $sWrk;
}
function ewr_FilterSQL(&$fld, $fn, $ft)
{
$ar = $fld->SelectionList;
$af = $fld->AdvancedFilters;
$gt = $fld->FldGroupByType;
$gi = $fld->FldGroupInt;
$sql = $fld->FldGroupSql;
$dlm = $fld->FldDelimiter;
if (!is_array($ar)) {
return TRUE;
} else {
$sqlwrk = "";
$i = 0;
foreach ($ar as $value) {
if ($value == EWR_EMPTY_VALUE) {
// Empty string
$sqlwrk .= "{$fn} = '' OR ";
} elseif ($value == EWR_NULL_VALUE) {
// Null value
$sqlwrk .= "{$fn} IS NULL OR ";
} elseif (substr($value, 0, 2) == "@@") {
// Advanced filter
if (is_array($af)) {
$afsql = ewr_AdvancedFilterSQL($af, $fn, $value);
// Process popup filter
if (!is_null($afsql)) {
$sqlwrk .= $afsql . " OR ";
}
}
} elseif ($sql != "") {
$sqlwrk .= str_replace("%s", $fn, $sql) . " = '" . $value . "' OR ";
} elseif ($dlm != "") {
$sql = ewr_GetMultiSearchSql($fn, trim($value));
if ($sql != "") {
$sqlwrk .= $sql . " OR ";
}
} else {
$sqlwrk .= "{$fn} IN (" . ewr_JoinArray($ar, ", ", $ft, $i) . ") OR ";
break;
}
$i++;
}
}
if ($sqlwrk != "") {
$sqlwrk = "(" . substr($sqlwrk, 0, -4) . ")";
}
return $sqlwrk;
}
