function RenderRow()
{
global $conn, $Security, $ReportLanguage;
// Set up summary values
$colcnt = $this->ColCount + 1;
$this->SummaryCellAttrs =& ewr_InitArray($colcnt, NULL);
$this->SummaryViewAttrs =& ewr_InitArray($colcnt, NULL);
$this->SummaryLinkAttrs =& ewr_InitArray($colcnt, NULL);
$this->SummaryCurrentValue =& ewr_InitArray($colcnt, NULL);
$this->SummaryViewValue =& ewr_InitArray($colcnt, NULL);
$rowsmry = 0;
$rowcnt = 0;
if ($this->RowTotalType == EWR_ROWTOTAL_GRAND) {
// Grand total
// Aggregate SQL
$sSql = ewr_BuildReportSql(str_replace("<DistinctColumnFields>", $this->DistinctColumnFields, $this->getSqlSelectAgg()), $this->getSqlWhere(), $this->getSqlGroupByAgg(), "", "", $this->Filter, "");
$rsagg = $conn->Execute($sSql);
if ($rsagg && !$rsagg->EOF) {
$rsagg->MoveFirst();
}
}
for ($i = 1; $i <= $this->ColCount; $i++) {
if ($this->Col[$i]->Visible) {
if ($this->RowType == EWR_ROWTYPE_DETAIL) {
// Detail row
$thisval = $this->Val[$i];
} elseif ($this->RowTotalType == EWR_ROWTOTAL_GROUP) {
// Group total
$thisval = $this->Smry[$i][$this->RowGroupLevel];
} elseif ($this->RowTotalType == EWR_ROWTOTAL_PAGE) {
// Page total
$thisval = $this->Smry[$i][0];
} elseif ($this->RowTotalType == EWR_ROWTOTAL_GRAND) {
// Grand total
$thisval = $rsagg && !$rsagg->EOF ? $rsagg->fields[$i + 1 - 1] : 0;
}
$this->SummaryCurrentValue[$i - 1] = $thisval;
$rowsmry = ewr_SummaryValue($rowsmry, $thisval, $this->getSummaryType());
}
}
if ($this->RowTotalType == EWR_ROWTOTAL_GRAND) {
// Grand total
if ($rsagg) {
$rsagg->Close();
}
}
$this->SummaryCurrentValue[$this->ColCount] = $rowsmry;
// Call Row_Rendering event
$this->Row_Rendering();
//
// Render view codes
//
if ($this->RowType == EWR_ROWTYPE_TOTAL) {
// Summary row
// University
$this->University->GroupViewValue = $this->University->GroupOldValue();
$this->University->CellAttrs["class"] = $this->RowGroupLevel == 1 ? "ewRptGrpSummary1" : "ewRptGrpField1";
// Set up summary values
$scvcnt = count($this->SummaryCurrentValue);
for ($i = 0; $i < $scvcnt; $i++) {
$this->SummaryViewValue[$i] = $this->SummaryCurrentValue[$i];
$this->SummaryViewAttrs[$i]["style"] = "";
$this->SummaryCellAttrs[$i]["style"] = "";
$this->SummaryCellAttrs[$i]["class"] = $this->RowTotalType == EWR_ROWTOTAL_GROUP ? "ewRptGrpSummary" . $this->RowGroupLevel : "";
}
// University
$this->University->HrefValue = "";
} else {
// University
$this->University->GroupViewValue = $this->University->GroupValue();
$this->University->CellAttrs["class"] = "ewRptGrpField1";
if ($this->University->GroupValue() == $this->University->GroupOldValue() && !$this->ChkLvlBreak(1)) {
$this->University->GroupViewValue = " ";
}
// Set up summary values
$scvcnt = count($this->SummaryCurrentValue);
for ($i = 0; $i < $scvcnt; $i++) {
$this->SummaryViewValue[$i] = $this->SummaryCurrentValue[$i];
$this->SummaryViewAttrs[$i]["style"] = "";
$this->SummaryCellAttrs[$i]["style"] = "";
$this->SummaryCellAttrs[$i]["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
}
// University
$this->University->HrefValue = "";
}
// Call Cell_Rendered event
if ($this->RowType == EWR_ROWTYPE_TOTAL) {
// Summary row
// University
$this->CurrentIndex = 0;
// Current index
$CurrentValue = $this->University->GroupOldValue();
$ViewValue =& $this->University->GroupViewValue;
$ViewAttrs =& $this->University->ViewAttrs;
$CellAttrs =& $this->University->CellAttrs;
$HrefValue =& $this->University->HrefValue;
$LinkAttrs =& $this->University->LinkAttrs;
$this->Cell_Rendered($this->University, $CurrentValue, $ViewValue, $ViewAttrs, $CellAttrs, $HrefValue, $LinkAttrs);
for ($i = 0; $i < $scvcnt; $i++) {
$this->CurrentIndex = $i;
$CurrentValue = $this->SummaryCurrentValue[$i];
$ViewValue =& $this->SummaryViewValue[$i];
$ViewAttrs =& $this->SummaryViewAttrs[$i];
$CellAttrs =& $this->SummaryCellAttrs[$i];
$HrefValue = "";
$LinkAttrs =& $this->SummaryLinkAttrs[$i];
$this->Cell_Rendered($this->COUNT28candidate_candStatusID29, $CurrentValue, $ViewValue, $ViewAttrs, $CellAttrs, $HrefValue, $LinkAttrs);
}
} else {
// University
$this->CurrentIndex = 0;
// Group index
$CurrentValue = $this->University->GroupValue();
$ViewValue =& $this->University->GroupViewValue;
$ViewAttrs =& $this->University->ViewAttrs;
$CellAttrs =& $this->University->CellAttrs;
$HrefValue =& $this->University->HrefValue;
$LinkAttrs =& $this->University->LinkAttrs;
$this->Cell_Rendered($this->University, $CurrentValue, $ViewValue, $ViewAttrs, $CellAttrs, $HrefValue, $LinkAttrs);
for ($i = 0; $i < $scvcnt; $i++) {
$this->CurrentIndex = $i;
$CurrentValue = $this->SummaryCurrentValue[$i];
$ViewValue =& $this->SummaryViewValue[$i];
$ViewAttrs =& $this->SummaryViewAttrs[$i];
$CellAttrs =& $this->SummaryCellAttrs[$i];
$HrefValue = "";
$LinkAttrs =& $this->SummaryLinkAttrs[$i];
$this->Cell_Rendered($this->COUNT28candidate_candStatusID29, $CurrentValue, $ViewValue, $ViewAttrs, $CellAttrs, $HrefValue, $LinkAttrs);
}
}
// Call Row_Rendered event
$this->Row_Rendered();
$this->SetupFieldCount();
}
function RenderRow()
{
global $conn, $rs, $Security, $ReportLanguage;
if ($this->RowTotalType == EWR_ROWTOTAL_GRAND && !$this->GrandSummarySetup) {
// Grand total
$bGotCount = FALSE;
$bGotSummary = FALSE;
// Get total count from sql directly
$sSql = ewr_BuildReportSql($this->getSqlSelectCount(), $this->getSqlWhere(), $this->getSqlGroupBy(), $this->getSqlHaving(), "", $this->Filter, "");
$rstot = $conn->Execute($sSql);
if ($rstot) {
$this->TotCount = $rstot->RecordCount() > 1 ? $rstot->RecordCount() : $rstot->fields[0];
$rstot->Close();
$bGotCount = TRUE;
} else {
$this->TotCount = 0;
}
// Get total from sql directly
$sSql = ewr_BuildReportSql($this->getSqlSelectAgg(), $this->getSqlWhere(), $this->getSqlGroupBy(), $this->getSqlHaving(), "", $this->Filter, "");
$sSql = $this->getSqlAggPfx() . $sSql . $this->getSqlAggSfx();
$rsagg = $conn->Execute($sSql);
if ($rsagg) {
$this->GrandCnt[1] = $this->TotCount;
$this->GrandSmry[1] = $rsagg->fields("sum_job_offered_candidates");
$this->GrandCnt[2] = $this->TotCount;
$rsagg->Close();
$bGotSummary = TRUE;
}
// Accumulate grand summary from detail records
if (!$bGotCount || !$bGotSummary) {
$sSql = ewr_BuildReportSql($this->getSqlSelect(), $this->getSqlWhere(), $this->getSqlGroupBy(), $this->getSqlHaving(), "", $this->Filter, "");
$rs = $conn->Execute($sSql);
if ($rs) {
$this->GetRow(1);
while (!$rs->EOF) {
$this->AccumulateGrandSummary();
$this->GetRow(2);
}
$rs->Close();
}
}
$this->GrandSummarySetup = TRUE;
// No need to set up again
}
// Call Row_Rendering event
$this->Row_Rendering();
//
// Render view codes
//
if ($this->RowType == EWR_ROWTYPE_TOTAL) {
// Summary row
// Job_Name
$this->Job_Name->GroupViewValue = $this->Job_Name->GroupOldValue();
$this->Job_Name->CellAttrs["class"] = $this->RowGroupLevel == 1 ? "ewRptGrpSummary1" : "ewRptGrpField1";
$this->Job_Name->GroupViewValue = ewr_DisplayGroupValue($this->Job_Name, $this->Job_Name->GroupViewValue);
$this->Job_Name->GroupSummaryOldValue = $this->Job_Name->GroupSummaryValue;
$this->Job_Name->GroupSummaryValue = $this->Job_Name->GroupViewValue;
$this->Job_Name->GroupSummaryViewValue = $this->Job_Name->GroupSummaryOldValue != $this->Job_Name->GroupSummaryValue ? $this->Job_Name->GroupSummaryValue : " ";
// Job_Offered_Candidates
$this->Job_Offered_Candidates->SumViewValue = $this->Job_Offered_Candidates->SumValue;
$this->Job_Offered_Candidates->CellAttrs["class"] = $this->RowTotalType == EWR_ROWTOTAL_PAGE || $this->RowTotalType == EWR_ROWTOTAL_GRAND ? "ewRptGrpAggregate" : "ewRptGrpSummary" . $this->RowGroupLevel;
// Job_Name
$this->Job_Name->HrefValue = "";
// Job_Offered_Candidates
$this->Job_Offered_Candidates->HrefValue = "";
// dateCreated
$this->dateCreated->HrefValue = "";
} else {
// Job_Name
$this->Job_Name->GroupViewValue = $this->Job_Name->GroupValue();
$this->Job_Name->CellAttrs["class"] = "ewRptGrpField1";
$this->Job_Name->GroupViewValue = ewr_DisplayGroupValue($this->Job_Name, $this->Job_Name->GroupViewValue);
if ($this->Job_Name->GroupValue() == $this->Job_Name->GroupOldValue() && !$this->ChkLvlBreak(1)) {
$this->Job_Name->GroupViewValue = " ";
}
// Job_Offered_Candidates
$this->Job_Offered_Candidates->ViewValue = $this->Job_Offered_Candidates->CurrentValue;
$this->Job_Offered_Candidates->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
// dateCreated
$this->dateCreated->ViewValue = $this->dateCreated->CurrentValue;
$this->dateCreated->ViewValue = ewr_FormatDateTime($this->dateCreated->ViewValue, 5);
$this->dateCreated->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
$this->dateCreated->CellAttrs["style"] = "white-space: nowrap;";
// Job_Name
$this->Job_Name->HrefValue = "";
// Job_Offered_Candidates
$this->Job_Offered_Candidates->HrefValue = "";
// dateCreated
$this->dateCreated->HrefValue = "";
}
// Call Cell_Rendered event
if ($this->RowType == EWR_ROWTYPE_TOTAL) {
// Summary row
// Job_Name
$CurrentValue = $this->Job_Name->GroupViewValue;
$ViewValue =& $this->Job_Name->GroupViewValue;
$ViewAttrs =& $this->Job_Name->ViewAttrs;
$CellAttrs =& $this->Job_Name->CellAttrs;
$HrefValue =& $this->Job_Name->HrefValue;
$LinkAttrs =& $this->Job_Name->LinkAttrs;
$this->Cell_Rendered($this->Job_Name, $CurrentValue, $ViewValue, $ViewAttrs, $CellAttrs, $HrefValue, $LinkAttrs);
// Job_Offered_Candidates
$CurrentValue = $this->Job_Offered_Candidates->SumValue;
$ViewValue =& $this->Job_Offered_Candidates->SumViewValue;
$ViewAttrs =& $this->Job_Offered_Candidates->ViewAttrs;
$CellAttrs =& $this->Job_Offered_Candidates->CellAttrs;
$HrefValue =& $this->Job_Offered_Candidates->HrefValue;
$LinkAttrs =& $this->Job_Offered_Candidates->LinkAttrs;
$this->Cell_Rendered($this->Job_Offered_Candidates, $CurrentValue, $ViewValue, $ViewAttrs, $CellAttrs, $HrefValue, $LinkAttrs);
} else {
// Job_Name
$CurrentValue = $this->Job_Name->GroupValue();
$ViewValue =& $this->Job_Name->GroupViewValue;
$ViewAttrs =& $this->Job_Name->ViewAttrs;
$CellAttrs =& $this->Job_Name->CellAttrs;
$HrefValue =& $this->Job_Name->HrefValue;
$LinkAttrs =& $this->Job_Name->LinkAttrs;
$this->Cell_Rendered($this->Job_Name, $CurrentValue, $ViewValue, $ViewAttrs, $CellAttrs, $HrefValue, $LinkAttrs);
// Job_Offered_Candidates
$CurrentValue = $this->Job_Offered_Candidates->CurrentValue;
$ViewValue =& $this->Job_Offered_Candidates->ViewValue;
$ViewAttrs =& $this->Job_Offered_Candidates->ViewAttrs;
$CellAttrs =& $this->Job_Offered_Candidates->CellAttrs;
$HrefValue =& $this->Job_Offered_Candidates->HrefValue;
$LinkAttrs =& $this->Job_Offered_Candidates->LinkAttrs;
$this->Cell_Rendered($this->Job_Offered_Candidates, $CurrentValue, $ViewValue, $ViewAttrs, $CellAttrs, $HrefValue, $LinkAttrs);
// dateCreated
$CurrentValue = $this->dateCreated->CurrentValue;
$ViewValue =& $this->dateCreated->ViewValue;
$ViewAttrs =& $this->dateCreated->ViewAttrs;
$CellAttrs =& $this->dateCreated->CellAttrs;
$HrefValue =& $this->dateCreated->HrefValue;
$LinkAttrs =& $this->dateCreated->LinkAttrs;
$this->Cell_Rendered($this->dateCreated, $CurrentValue, $ViewValue, $ViewAttrs, $CellAttrs, $HrefValue, $LinkAttrs);
}
// Call Row_Rendered event
$this->Row_Rendered();
$this->SetupFieldCount();
}
function LoadColumnValues($filter = "")
{
global $conn;
global $ReportLanguage;
// Build SQL
$sSql = ewr_BuildReportSql($this->getSqlDistinctSelect(), $this->getSqlDistinctWhere(), "", "", $this->getSqlDistinctOrderBy(), $filter, "");
// Load recordset
$rscol = $conn->Execute($sSql);
// Get distinct column count
$this->ColCount = $rscol ? $rscol->RecordCount() : 0;
/* Uncomment to show phrase
if ($this->ColCount == 0) {
if ($rscol) $rscol->Close();
echo "<p>" . $ReportLanguage->Phrase("NoDistinctColVals") . $sSql . "</p>";
exit();
}
*/
$this->Col =& ewr_Init2DArray($this->ColCount + 1, 2, NULL);
$colcnt = 0;
while (!$rscol->EOF) {
if (is_null($rscol->fields[0])) {
$wrkValue = EWR_NULL_VALUE;
$wrkCaption = $ReportLanguage->Phrase("NullLabel");
} elseif ($rscol->fields[0] == "") {
$wrkValue = EWR_EMPTY_VALUE;
$wrkCaption = $ReportLanguage->Phrase("EmptyLabel");
} else {
$wrkValue = $rscol->fields[0];
$wrkCaption = $rscol->fields[0];
}
$colcnt++;
$this->Col[$colcnt] = new crCrosstabColumn($wrkValue, $wrkCaption, TRUE);
$rscol->MoveNext();
}
$rscol->Close();
// Update crosstab sql
$sSqlFlds = "";
for ($colcnt = 1; $colcnt <= $this->ColCount; $colcnt++) {
$sFld = ewr_CrossTabField($this->getSummaryType(), $this->getSummaryField(), $this->getColumnField(), $this->getColumnDateType(), $this->Col[$colcnt]->Value, "", "C" . $colcnt);
if ($sSqlFlds != "") {
$sSqlFlds .= ", ";
}
$sSqlFlds .= $sFld;
}
$this->DistinctColumnFields = $sSqlFlds;
}
function RenderRow()
{
global $conn, $rs, $Security, $ReportLanguage;
if ($this->RowTotalType == EWR_ROWTOTAL_GRAND && !$this->GrandSummarySetup) {
// Grand total
$bGotCount = FALSE;
$bGotSummary = FALSE;
// Get total count from sql directly
$sSql = ewr_BuildReportSql($this->getSqlSelectCount(), $this->getSqlWhere(), $this->getSqlGroupBy(), $this->getSqlHaving(), "", $this->Filter, "");
$rstot = $conn->Execute($sSql);
if ($rstot) {
$this->TotCount = $rstot->RecordCount() > 1 ? $rstot->RecordCount() : $rstot->fields[0];
$rstot->Close();
$bGotCount = TRUE;
} else {
$this->TotCount = 0;
}
$bGotSummary = TRUE;
// Accumulate grand summary from detail records
if (!$bGotCount || !$bGotSummary) {
$sSql = ewr_BuildReportSql($this->getSqlSelect(), $this->getSqlWhere(), $this->getSqlGroupBy(), $this->getSqlHaving(), "", $this->Filter, "");
$rs = $conn->Execute($sSql);
if ($rs) {
$this->GetRow(1);
while (!$rs->EOF) {
$this->AccumulateGrandSummary();
$this->GetRow(2);
}
$rs->Close();
}
}
$this->GrandSummarySetup = TRUE;
// No need to set up again
}
// Call Row_Rendering event
$this->Row_Rendering();
//
// Render view codes
//
if ($this->RowType == EWR_ROWTYPE_TOTAL) {
// Summary row
// Count(messages.message)
$this->Count28messages_message29->HrefValue = "";
// timeta
$this->timeta->HrefValue = "";
} else {
// Count(messages.message)
$this->Count28messages_message29->ViewValue = $this->Count28messages_message29->CurrentValue;
$this->Count28messages_message29->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
// timeta
$this->timeta->ViewValue = $this->timeta->CurrentValue;
$this->timeta->ViewValue = ewr_FormatDateTime($this->timeta->ViewValue, 7);
$this->timeta->CellAttrs["class"] = $this->RecCount % 2 != 1 ? "ewTableAltRow" : "ewTableRow";
// Count(messages.message)
$this->Count28messages_message29->HrefValue = "";
// timeta
$this->timeta->HrefValue = "";
}
// Call Cell_Rendered event
if ($this->RowType == EWR_ROWTYPE_TOTAL) {
// Summary row
} else {
// Count(messages.message)
$CurrentValue = $this->Count28messages_message29->CurrentValue;
$ViewValue =& $this->Count28messages_message29->ViewValue;
$ViewAttrs =& $this->Count28messages_message29->ViewAttrs;
$CellAttrs =& $this->Count28messages_message29->CellAttrs;
$HrefValue =& $this->Count28messages_message29->HrefValue;
$LinkAttrs =& $this->Count28messages_message29->LinkAttrs;
$this->Cell_Rendered($this->Count28messages_message29, $CurrentValue, $ViewValue, $ViewAttrs, $CellAttrs, $HrefValue, $LinkAttrs);
// timeta
$CurrentValue = $this->timeta->CurrentValue;
$ViewValue =& $this->timeta->ViewValue;
$ViewAttrs =& $this->timeta->ViewAttrs;
$CellAttrs =& $this->timeta->CellAttrs;
$HrefValue =& $this->timeta->HrefValue;
$LinkAttrs =& $this->timeta->LinkAttrs;
$this->Cell_Rendered($this->timeta, $CurrentValue, $ViewValue, $ViewAttrs, $CellAttrs, $HrefValue, $LinkAttrs);
}
// Call Row_Rendered event
$this->Row_Rendered();
$this->SetupFieldCount();
}
function ewr_LoadSelectionFromFilter(&$fld, $filter, &$sel, $af = "")
{
$sel = "";
if ($af != "") {
// Set up advanced filter first
$ar = is_array($af) ? $af : array($af);
$cnt = count($ar);
for ($i = 0; $i < $cnt; $i++) {
if (substr($ar[$i], 0, 2) == "@@") {
if (!is_array($sel)) {
$sel = array();
}
$sel[] = $ar[$i];
}
}
}
if ($filter != "") {
$sSql = ewr_BuildReportSql($fld->SqlSelect, "", "", "", $fld->SqlOrderBy, $filter, "");
ewr_LoadArrayFromSql($sSql, $sel);
}
}
