function GetLookupValues($sql, $ds, $df, $dlm)
{
global $ReportLanguage;
$rsarr = array();
$rowcnt = 0;
$conn = ewr_Connect();
if ($rs = $conn->Execute($sql)) {
$rowcnt = $rs->RecordCount();
$fldcnt = $rs->FieldCount();
$rsarr = $rs->GetRows();
$rs->Close();
}
$conn->Close();
// Clean output buffer
if (!EWR_DEBUG_ENABLED && ob_get_length()) {
ob_end_clean();
}
// Output
$key = array();
$arr = array();
if (is_array($rsarr) && $rowcnt > 0) {
for ($i = 0; $i < $rowcnt; $i++) {
$row = $rsarr[$i];
if ($dlm != "") {
$cnt = 0;
for ($j = 0; $j < $fldcnt; $j++) {
if (strpos(strval($row[$j]), $dlm) !== FALSE) {
$row[$j] = explode($dlm, $row[$j]);
if (count($row[$j]) > $cnt) {
$cnt = count($row[$j]);
}
} else {
if ($cnt < 1) {
$cnt = 1;
}
}
}
} else {
$cnt = 1;
}
for ($k = 0; $k < $cnt; $k++) {
$val0 = "";
$str0 = "";
$rec = array();
for ($j = 0; $j < $fldcnt; $j++) {
if ($dlm != "" && is_array($row[$j])) {
if (count($row[$j]) > $k) {
$val = $row[$j][$k];
} else {
$val = $row[$j][0];
}
} else {
$val = $row[$j];
}
if ($j == 0) {
$str = ewr_ConvertValue($ds, $val);
$val0 = $val;
$str0 = $str;
} elseif ($j == 1 && is_null($val0)) {
$str = $ReportLanguage->Phrase("NullLabel");
} elseif ($j == 1 && strval($val0) == "") {
$str = $ReportLanguage->Phrase("EmptyLabel");
} elseif ($j == 1) {
$str = ewr_DropDownDisplayValue(ewr_ConvertValue($ds, $val), $ds, $df);
} else {
$str = strval($val);
}
$str = ewr_ConvertToUtf8($str);
$rec[$j] = $str;
}
if (!in_array($str0, $key)) {
$arr[] = $rec;
$key[] = $str0;
}
}
}
}
echo ewr_ArrayToJson($arr);
}
function __construct()
{
global $conn, $ReportLanguage;
// Language object
$ReportLanguage = new crLanguage();
// Parent constuctor
parent::__construct();
// Table object (University_Vs_Rejected_Candidates)
if (!isset($GLOBALS["University_Vs_Rejected_Candidates"])) {
$GLOBALS["University_Vs_Rejected_Candidates"] =& $this;
$GLOBALS["Table"] =& $GLOBALS["University_Vs_Rejected_Candidates"];
}
// Initialize URLs
$this->ExportPrintUrl = $this->PageUrl() . "export=print";
$this->ExportExcelUrl = $this->PageUrl() . "export=excel";
$this->ExportWordUrl = $this->PageUrl() . "export=word";
$this->ExportPdfUrl = $this->PageUrl() . "export=pdf";
// Page ID
if (!defined("EWR_PAGE_ID")) {
define("EWR_PAGE_ID", 'crosstab', TRUE);
}
// Table name (for backward compatibility)
if (!defined("EWR_TABLE_NAME")) {
define("EWR_TABLE_NAME", 'University Vs Rejected Candidates', TRUE);
}
// Start timer
$GLOBALS["gsTimer"] = new crTimer();
// Open connection
$conn = ewr_Connect();
// Export options
$this->ExportOptions = new crListOptions();
$this->ExportOptions->Tag = "div";
$this->ExportOptions->TagClassName = "ewExportOption";
// Search options
$this->SearchOptions = new crListOptions();
$this->SearchOptions->Tag = "div";
$this->SearchOptions->TagClassName = "ewSearchOption";
// Filter options
$this->FilterOptions = new crListOptions();
$this->FilterOptions->Tag = "div";
$this->FilterOptions->TagClassName = "ewFilterOption fUniversity_Vs_Rejected_Candidatescrosstab";
}
function __construct()
{
global $conn, $ReportLanguage;
// Language object
$ReportLanguage = new crLanguage();
// Page ID
if (!defined("EWR_PAGE_ID")) {
define("EWR_PAGE_ID", 'rptdefault', TRUE);
}
// Start timer
$GLOBALS["gsTimer"] = new crTimer();
// Open connection
$conn = ewr_Connect();
}
