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}"; } }