function ShowFilterList()
{
global $Report16;
global $ReportLanguage;
// Initialize
$sFilterList = "";
// Field paper_name
$sExtWrk = "";
$sWrk = "";
if (is_array($Report16->paper_name->SelectionList)) {
$sWrk = ewrpt_JoinArray($Report16->paper_name->SelectionList, ", ", EWRPT_DATATYPE_STRING);
}
if ($sExtWrk != "" || $sWrk != "") {
$sFilterList .= $Report16->paper_name->FldCaption() . "<br />";
}
if ($sExtWrk != "") {
$sFilterList .= " {$sExtWrk}<br />";
}
if ($sWrk != "") {
$sFilterList .= " {$sWrk}<br />";
}
// Field grade
$sExtWrk = "";
$sWrk = "";
if (is_array($Report16->grade->SelectionList)) {
$sWrk = ewrpt_JoinArray($Report16->grade->SelectionList, ", ", EWRPT_DATATYPE_STRING);
}
if ($sExtWrk != "" || $sWrk != "") {
$sFilterList .= $Report16->grade->FldCaption() . "<br />";
}
if ($sExtWrk != "") {
$sFilterList .= " {$sExtWrk}<br />";
}
if ($sWrk != "") {
$sFilterList .= " {$sWrk}<br />";
}
// Show Filters
if ($sFilterList != "") {
echo $ReportLanguage->Phrase("CurrentFilters") . "<br />{$sFilterList}";
}
}
function ewrpt_FilterSQL(&$fld, $fn, $ft)
{
$ar = $fld->SelectionList;
$af = $fld->AdvancedFilters;
$gt = $fld->FldGroupByType;
$gi = $fld->FldGroupInt;
$sql = $fld->FldGroupSql;
if (!is_array($ar)) {
return TRUE;
} else {
$sqlwrk = "";
$i = 0;
foreach ($ar as $value) {
if ($value == EWRPT_EMPTY_VALUE) {
// Empty string
$sqlwrk .= "{$fn} = '' OR ";
} elseif ($value == EWRPT_NULL_VALUE) {
// Null value
$sqlwrk .= "{$fn} IS NULL OR ";
} elseif (substr($value, 0, 2) == "@@") {
// Advanced filter
if (is_array($af)) {
$afsql = ewrpt_AdvancedFilterSQL($af, $value);
// Process popup filter
if (!is_null($afsql)) {
$sqlwrk .= str_replace("@@fld@@", $fn, $afsql) . " OR ";
}
}
} elseif ($sql != "") {
$sqlwrk .= str_replace("%s", $fn, $sql) . " = '" . $value . "' OR ";
} else {
$sqlwrk .= "{$fn} IN (" . ewrpt_JoinArray($ar, ", ", $ft, $i) . ") OR ";
break;
}
$i++;
}
}
if ($sqlwrk != "") {
$sqlwrk = "(" . substr($sqlwrk, 0, -4) . ")";
}
return $sqlwrk;
}
function ShowFilterList()
{
global $Report2;
global $ReportLanguage;
// Initialize
$sFilterList = "";
// Field Branch
$sExtWrk = "";
$sWrk = "";
if (is_array($Report2->Branch->SelectionList)) {
$sWrk = ewrpt_JoinArray($Report2->Branch->SelectionList, ", ", EWRPT_DATATYPE_STRING);
}
if ($sExtWrk != "" || $sWrk != "") {
$sFilterList .= $Report2->Branch->FldCaption() . "<br />";
}
if ($sExtWrk != "") {
$sFilterList .= " {$sExtWrk}<br />";
}
if ($sWrk != "") {
$sFilterList .= " {$sWrk}<br />";
}
// Field Confirm
$sExtWrk = "";
$sWrk = "";
if (is_array($Report2->Confirm->SelectionList)) {
$sWrk = ewrpt_JoinArray($Report2->Confirm->SelectionList, ", ", EWRPT_DATATYPE_NUMBER);
}
if ($sExtWrk != "" || $sWrk != "") {
$sFilterList .= $Report2->Confirm->FldCaption() . "<br />";
}
if ($sExtWrk != "") {
$sFilterList .= " {$sExtWrk}<br />";
}
if ($sWrk != "") {
$sFilterList .= " {$sWrk}<br />";
}
// Field Class Name
$sExtWrk = "";
$sWrk = "";
if (is_array($Report2->Class_Name->SelectionList)) {
$sWrk = ewrpt_JoinArray($Report2->Class_Name->SelectionList, ", ", EWRPT_DATATYPE_STRING);
}
if ($sExtWrk != "" || $sWrk != "") {
$sFilterList .= $Report2->Class_Name->FldCaption() . "<br />";
}
if ($sExtWrk != "") {
$sFilterList .= " {$sExtWrk}<br />";
}
if ($sWrk != "") {
$sFilterList .= " {$sWrk}<br />";
}
// Show Filters
if ($sFilterList != "") {
echo $ReportLanguage->Phrase("CurrentFilters") . "<br />{$sFilterList}";
}
}
