/jf/web/reports/Emp_Reports_by_Yearsmry.php

Large files files are truncated, but you can click here to view the full file

<?php

if (session_id() == "") session_start(); // Initialize Session data

ob_start();

?>

<?php include_once "phprptinc/ewrcfg5.php"; ?>

<?php include_once "phprptinc/ewmysql.php"; ?>

<?php include_once "phprptinc/ewrfn5.php"; ?>

<?php include_once "phprptinc/ewrusrfn.php"; ?>

<?php



// Global variable for table object

$Emp_Reports_by_Year = NULL;



//

// Table class for Emp Reports by Year

//

class crEmp_Reports_by_Year {

	var $TableVar = 'Emp_Reports_by_Year';

	var $TableName = 'Emp Reports by Year';

	var $TableType = 'REPORT';

	var $ShowCurrentFilter = EWRPT_SHOW_CURRENT_FILTER;

	var $FilterPanelOption = EWRPT_FILTER_PANEL_OPTION;

	var $CurrentOrder; // Current order

	var $CurrentOrderType; // Current order type



	// Table caption

	function TableCaption() {

		global $ReportLanguage;

		return $ReportLanguage->TablePhrase($this->TableVar, "TblCaption");

	}



	// Session Group Per Page

	function getGroupPerPage() {

		return @$_SESSION[EWRPT_PROJECT_VAR . "_" . $this->TableVar . "_grpperpage"];

	}



	function setGroupPerPage($v) {

		@$_SESSION[EWRPT_PROJECT_VAR . "_" . $this->TableVar . "_grpperpage"] = $v;

	}



	// Session Start Group

	function getStartGroup() {

		return @$_SESSION[EWRPT_PROJECT_VAR . "_" . $this->TableVar . "_start"];

	}



	function setStartGroup($v) {

		@$_SESSION[EWRPT_PROJECT_VAR . "_" . $this->TableVar . "_start"] = $v;

	}



	// Session Order By

	function getOrderBy() {

		return @$_SESSION[EWRPT_PROJECT_VAR . "_" . $this->TableVar . "_orderby"];

	}



	function setOrderBy($v) {

		@$_SESSION[EWRPT_PROJECT_VAR . "_" . $this->TableVar . "_orderby"] = $v;

	}



//	var $SelectLimit = TRUE;

	var $full_name;

	var $dob;

	var $joined_company_date;

	var $department_name;

	var $year;

	var $id;

	var $fields = array();

	var $Export; // Export

	var $ExportAll = TRUE;

	var $UseTokenInUrl = EWRPT_USE_TOKEN_IN_URL;

	var $RowType; // Row type

	var $RowTotalType; // Row total type

	var $RowTotalSubType; // Row total subtype

	var $RowGroupLevel; // Row group level

	var $RowAttrs = array(); // Row attributes



	// Reset CSS styles for table object

	function ResetCSS() {

    	$this->RowAttrs["style"] = "";

		$this->RowAttrs["class"] = "";

		foreach ($this->fields as $fld) {

			$fld->ResetCSS();

		}

	}



	//

	// Table class constructor

	//

	function crEmp_Reports_by_Year() {

		global $ReportLanguage;



		// full_name

		$this->full_name = new crField('Emp_Reports_by_Year', 'Emp Reports by Year', 'x_full_name', 'full_name', '`full_name`', 200, EWRPT_DATATYPE_STRING, -1);

		$this->fields['full_name'] =& $this->full_name;

		$this->full_name->DateFilter = "";

		$this->full_name->SqlSelect = "";

		$this->full_name->SqlOrderBy = "";



		// dob

		$this->dob = new crField('Emp_Reports_by_Year', 'Emp Reports by Year', 'x_dob', 'dob', '`dob`', 133, EWRPT_DATATYPE_DATE, 7);

		$this->dob->FldDefaultErrMsg = str_replace("%s", "/", $ReportLanguage->Phrase("IncorrectDateDMY"));

		$this->fields['dob'] =& $this->dob;

		$this->dob->DateFilter = "";

		$this->dob->SqlSelect = "";

		$this->dob->SqlOrderBy = "";



		// joined_company_date

		$this->joined_company_date = new crField('Emp_Reports_by_Year', 'Emp Reports by Year', 'x_joined_company_date', 'joined_company_date', '`joined_company_date`', 133, EWRPT_DATATYPE_DATE, 7);

		$this->joined_company_date->FldDefaultErrMsg = str_replace("%s", "/", $ReportLanguage->Phrase("IncorrectDateDMY"));

		$this->fields['joined_company_date'] =& $this->joined_company_date;

		$this->joined_company_date->DateFilter = "";

		$this->joined_company_date->SqlSelect = "";

		$this->joined_company_date->SqlOrderBy = "";



		// department_name

		$this->department_name = new crField('Emp_Reports_by_Year', 'Emp Reports by Year', 'x_department_name', 'department_name', '`department_name`', 200, EWRPT_DATATYPE_STRING, -1);

		$this->department_name->GroupingFieldId = 1;

		$this->fields['department_name'] =& $this->department_name;

		$this->department_name->DateFilter = "";

		$this->department_name->SqlSelect = "SELECT DISTINCT `department_name` FROM " . $this->SqlFrom();

		$this->department_name->SqlOrderBy = "`department_name`";

		$this->department_name->FldGroupByType = "";

		$this->department_name->FldGroupInt = "0";

		$this->department_name->FldGroupSql = "";



		// year

		$this->year = new crField('Emp_Reports_by_Year', 'Emp Reports by Year', 'x_year', 'year', '`year`', 131, EWRPT_DATATYPE_NUMBER, -1);

		$this->year->GroupingFieldId = 2;

		$this->year->FldDefaultErrMsg = $ReportLanguage->Phrase("IncorrectFloat");

		$this->fields['year'] =& $this->year;

		$this->year->DateFilter = "";

		$this->year->SqlSelect = "SELECT DISTINCT `year` FROM " . $this->SqlFrom();

		$this->year->SqlOrderBy = "`year`";

		$this->year->FldGroupByType = "";

		$this->year->FldGroupInt = "0";

		$this->year->FldGroupSql = "";



		// id

		$this->id = new crField('Emp_Reports_by_Year', 'Emp Reports by Year', 'x_id', 'id', '`id`', 19, EWRPT_DATATYPE_NUMBER, -1);

		$this->id->FldDefaultErrMsg = $ReportLanguage->Phrase("IncorrectInteger");

		$this->fields['id'] =& $this->id;

		$this->id->DateFilter = "";

		$this->id->SqlSelect = "";

		$this->id->SqlOrderBy = "";

	}



	// Multiple column sort

	function UpdateSort(&$ofld, $ctrl) {

		if ($this->CurrentOrder == $ofld->FldName) {

			$sLastSort = $ofld->getSort();

			if ($this->CurrentOrderType == "ASC" || $this->CurrentOrderType == "DESC") {

				$sThisSort = $this->CurrentOrderType;

			} else {

				$sThisSort = ($sLastSort == "ASC") ? "DESC" : "ASC";

			}

			$ofld->setSort($sThisSort);

		} else {

			if ($ofld->GroupingFieldId == 0 && !$ctrl) $ofld->setSort("");

		}

	}



	// Get Sort SQL

	function SortSql() {

		$sDtlSortSql = "";

		$argrps = array();

		foreach ($this->fields as $fld) {

			if ($fld->getSort() <> "") {

				if ($fld->GroupingFieldId > 0) {

					if ($fld->FldGroupSql <> "")

						$argrps[$fld->GroupingFieldId] = str_replace("%s", $fld->FldExpression, $fld->FldGroupSql) . " " . $fld->getSort();

					else

						$argrps[$fld->GroupingFieldId] = $fld->FldExpression . " " . $fld->getSort();

				} else {

					if ($sDtlSortSql <> "") $sDtlSortSql .= ", ";

					$sDtlSortSql .= $fld->FldExpression . " " . $fld->getSort();

				}

			}

		}

		$sSortSql = "";

		foreach ($argrps as $grp) {

			if ($sSortSql <> "") $sSortSql .= ", ";

			$sSortSql .= $grp;

		}

		if ($sDtlSortSql <> "") {

			if ($sSortSql <> "") $sSortSql .= ",";

			$sSortSql .= $sDtlSortSql;

		}

		return $sSortSql;

	}



	// Table level SQL

	function SqlFrom() { // From

		return "`vw__employee_reports_by_year`";

	}



	function SqlSelect() { // Select

		return "SELECT * FROM " . $this->SqlFrom();

	}



	function SqlWhere() { // Where

		return "";

	}



	function SqlGroupBy() { // Group By

		return "";

	}



	function SqlHaving() { // Having

		return "";

	}



	function SqlOrderBy() { // Order By

		return "`department_name` ASC, `year` DESC";

	}



	// Table Level Group SQL

	function SqlFirstGroupField() {

		return "`department_name`";

	}



	function SqlSelectGroup() {

		return "SELECT DISTINCT " . $this->SqlFirstGroupField() . " FROM " . $this->SqlFrom();

	}



	function SqlOrderByGroup() {

		return "`department_name` ASC";

	}



	function SqlSelectAgg() {

		return "SELECT * FROM " . $this->SqlFrom();

	}



	function SqlAggPfx() {

		return "";

	}



	function SqlAggSfx() {

		return "";

	}



	function SqlSelectCount() {

		return "SELECT COUNT(*) FROM " . $this->SqlFrom();

	}



	// Sort URL

	function SortUrl(&$fld) {

		if ($this->Export <> "" ||

			in_array($fld->FldType, array(128, 204, 205))) { // Unsortable data type

				return "";

		} elseif ($fld->Sortable) {

			$sUrlParm = "order=" . urlencode($fld->FldName) . "&ordertype=" . $fld->ReverseSort();

			return ewrpt_CurrentPage() . "?" . $sUrlParm;

		} else {

			return "";

		}

	}



	// Row attributes

	function RowAttributes() {

		$sAtt = "";

		foreach ($this->RowAttrs as $k => $v) {

			if (trim($v) <> "")

				$sAtt .= " " . $k . "=\"" . trim($v) . "\"";

		}

		return $sAtt;

	}



	// Field object by fldvar

	function &fields($fldvar) {

		return $this->fields[$fldvar];

	}



	// Table level events

	// Row Rendering event

	function Row_Rendering() {



		// Enter your code here	

	}



	// Cell Rendered event

	function Cell_Rendered(&$Field, $CurrentValue, &$ViewValue, &$ViewAttrs, &$CellAttrs, &$HrefValue) {



		//$ViewValue = "xxx";

		//$ViewAttrs["style"] = "xxx";



	}



	// Row Rendered event

	function Row_Rendered() {



		// To view properties of field class, use:

		//var_dump($this-><FieldName>); 



	}



	// Load Filters event

	function Filters_Load() {



		// Enter your code here	

		// Example: Register/Unregister Custom Extended Filter

		//ewrpt_RegisterFilter($this-><Field>, 'StartsWithA', 'Starts With A', 'GetStartsWithAFilter');

		//ewrpt_UnregisterFilter($this-><Field>, 'StartsWithA');



	}



	// Page Filter Validated event

	function Page_FilterValidated() {



		// Example:

		//global $MyTable;

		//$MyTable->MyField1->SearchValue = "your search criteria"; // Search value



	}



	// Chart Rendering event

	function Chart_Rendering(&$chart) {



		// var_dump($chart);

	}



	// Chart Rendered event

	function Chart_Rendered($chart, &$chartxml) {



		// Example:	

		//$doc = $chart->XmlDoc; // Get the DOMDocument object

		// Enter your code to manipulate the DOMDocument object here

		//$chartxml = $doc->saveXML(); // Output the XML



	}



	// Email Sending event

	function Email_Sending(&$Email, &$Args) {



		//var_dump($Email); var_dump($Args); exit();

		return TRUE;

	}

}

?>

<?php ewrpt_Header(FALSE) ?>

<?php



// Create page object

$Emp_Reports_by_Year_summary = new crEmp_Reports_by_Year_summary();

$Page =& $Emp_Reports_by_Year_summary;



// Page init

$Emp_Reports_by_Year_summary->Page_Init();



// Page main

$Emp_Reports_by_Year_summary->Page_Main();

?>

<?php include_once "phprptinc/header.php"; ?>

<?php if ($Emp_Reports_by_Year->Export == "" || $Emp_Reports_by_Year->Export == "print" || $Emp_Reports_by_Year->Export == "email") { ?>

<script type="text/javascript">



// Create page object

var Emp_Reports_by_Year_summary = new ewrpt_Page("Emp_Reports_by_Year_summary");



// page properties

Emp_Reports_by_Year_summary.PageID = "summary"; // page ID

Emp_Reports_by_Year_summary.FormID = "fEmp_Reports_by_Yearsummaryfilter"; // form ID

var EWRPT_PAGE_ID = Emp_Reports_by_Year_summary.PageID;



// extend page with Chart_Rendering function

Emp_Reports_by_Year_summary.Chart_Rendering =  

 function(chart, chartid) { // DO NOT CHANGE THIS LINE!



 	//alert(chartid);

 }



// extend page with Chart_Rendered function

Emp_Reports_by_Year_summary.Chart_Rendered =  

 function(chart, chartid) { // DO NOT CHANGE THIS LINE!



 	//alert(chartid);

 }

</script>

<?php } ?>

<?php if ($Emp_Reports_by_Year->Export == "") { ?>

<script language="JavaScript" type="text/javascript">

<!--



// Write your client script here, no need to add script tags.

//-->



</script>

<?php } ?>

<?php if ($Emp_Reports_by_Year->Export == "" || $Emp_Reports_by_Year->Export == "print" || $Emp_Reports_by_Year->Export == "email") { ?>

<script src="<?php echo EWRPT_FUSIONCHARTS_FREE_JSCLASS_FILE; ?>" type="text/javascript"></script>

<?php } ?>

<?php if ($Emp_Reports_by_Year->Export == "") { ?>

<div id="ewrpt_PopupFilter"><div class="bd"></div></div>

<script src="phprptjs/ewrptpop.js" type="text/javascript"></script>

<script type="text/javascript">



// popup fields

<?php $jsdata = ewrpt_GetJsData($Emp_Reports_by_Year->department_name, $Emp_Reports_by_Year->department_name->FldType); ?>

ewrpt_CreatePopup("Emp_Reports_by_Year_department_name", [<?php echo $jsdata ?>]);

<?php $jsdata = ewrpt_GetJsData($Emp_Reports_by_Year->year, $Emp_Reports_by_Year->year->FldType); ?>

ewrpt_CreatePopup("Emp_Reports_by_Year_year", [<?php echo $jsdata ?>]);

</script>

<?php } ?>

<?php if ($Emp_Reports_by_Year->Export == "" || $Emp_Reports_by_Year->Export == "print" || $Emp_Reports_by_Year->Export == "email") { ?>

<!-- Table Container (Begin) -->

<table id="ewContainer" cellspacing="0" cellpadding="0" border="0">

<!-- Top Container (Begin) -->

<tr><td colspan="3"><div id="ewTop" class="phpreportmaker">

<!-- top slot -->

<a name="top"></a>

<?php } ?>

<p class="phpreportmaker ewTitle"><?php echo $Emp_Reports_by_Year->TableCaption() ?>

&nbsp;&nbsp;<?php $Emp_Reports_by_Year_summary->ExportOptions->Render("body"); ?></p>

<?php $Emp_Reports_by_Year_summary->ShowPageHeader(); ?>

<?php $Emp_Reports_by_Year_summary->ShowMessage(); ?>

<br><br>

<?php if ($Emp_Reports_by_Year->Export == "" || $Emp_Reports_by_Year->Export == "print" || $Emp_Reports_by_Year->Export == "email") { ?>

</div></td></tr>

<!-- Top Container (End) -->

<tr>

	<!-- Left Container (Begin) -->

	<td style="vertical-align: top;"><div id="ewLeft" class="phpreportmaker">

	<!-- Left slot -->

	</div></td>

	<!-- Left Container (End) -->

	<!-- Center Container - Report (Begin) -->

	<td style="vertical-align: top;" class="ewPadding"><div id="ewCenter" class="phpreportmaker">

	<!-- center slot -->

<?php } ?>

<!-- summary report starts -->

<div id="report_summary">

<?php if ($Emp_Reports_by_Year->ShowCurrentFilter) { ?>

<div id="ewrptFilterList">

<?php $Emp_Reports_by_Year_summary->ShowFilterList() ?>

</div>

<br>

<?php } ?>

<table class="ewGrid" cellspacing="0"><tr>

	<td class="ewGridContent">

<?php if ($Emp_Reports_by_Year->Export == "") { ?>

<div class="ewGridUpperPanel">

<form action="<?php echo ewrpt_CurrentPage() ?>" name="ewpagerform" id="ewpagerform" class="ewForm">

<table border="0" cellspacing="0" cellpadding="0">

	<tr>

		<td style="white-space: nowrap;">

<?php if (!isset($Pager)) $Pager = new crPrevNextPager($Emp_Reports_by_Year_summary->StartGrp, $Emp_Reports_by_Year_summary->DisplayGrps, $Emp_Reports_by_Year_summary->TotalGrps) ?>

<?php if ($Pager->RecordCount > 0) { ?>

	<table border="0" cellspacing="0" cellpadding="0"><tr><td><span class="phpreportmaker"><?php echo $ReportLanguage->Phrase("Page") ?>&nbsp;</span></td>

<!--first page button-->

	<?php if ($Pager->FirstButton->Enabled) { ?>

	<td><a href="<?php echo ewrpt_CurrentPage() ?>?start=<?php echo $Pager->FirstButton->Start ?>"><img src="phprptimages/first.gif" alt="<?php echo $ReportLanguage->Phrase("PagerFirst") ?>" width="16" height="16" border="0"></a></td>

	<?php } else { ?>

	<td><img src="phprptimages/firstdisab.gif" alt="<?php echo $ReportLanguage->Phrase("PagerFirst") ?>" width="16" height="16" border="0"></td>

	<?php } ?>

<!--previous page button-->

	<?php if ($Pager->PrevButton->Enabled) { ?>

	<td><a href="<?php echo ewrpt_CurrentPage() ?>?start=<?php echo $Pager->PrevButton->Start ?>"><img src="phprptimages/prev.gif" alt="<?php echo $ReportLanguage->Phrase("PagerPrevious") ?>" width="16" height="16" border="0"></a></td>

	<?php } else { ?>

	<td><img src="phprptimages/prevdisab.gif" alt="<?php echo $ReportLanguage->Phrase("PagerPrevious") ?>" width="16" height="16" border="0"></td>

	<?php } ?>

<!--current page number-->

	<td><input type="text" name="pageno" id="pageno" value="<?php echo $Pager->CurrentPage ?>" size="4"></td>

<!--next page button-->

	<?php if ($Pager->NextButton->Enabled) { ?>

	<td><a href="<?php echo ewrpt_CurrentPage() ?>?start=<?php echo $Pager->NextButton->Start ?>"><img src="phprptimages/next.gif" alt="<?php echo $ReportLanguage->Phrase("PagerNext") ?>" width="16" height="16" border="0"></a></td>	

	<?php } else { ?>

	<td><img src="phprptimages/nextdisab.gif" alt="<?php echo $ReportLanguage->Phrase("PagerNext") ?>" width="16" height="16" border="0"></td>

	<?php } ?>

<!--last page button-->

	<?php if ($Pager->LastButton->Enabled) { ?>

	<td><a href="<?php echo ewrpt_CurrentPage() ?>?start=<?php echo $Pager->LastButton->Start ?>"><img src="phprptimages/last.gif" alt="<?php echo $ReportLanguage->Phrase("PagerLast") ?>" width="16" height="16" border="0"></a></td>	

	<?php } else { ?>

	<td><img src="phprptimages/lastdisab.gif" alt="<?php echo $ReportLanguage->Phrase("PagerLast") ?>" width="16" height="16" border="0"></td>

	<?php } ?>

	<td><span class="phpreportmaker">&nbsp;<?php echo $ReportLanguage->Phrase("of") ?> <?php echo $Pager->PageCount ?></span></td>

	</tr></table>

	</td>	

	<td>&nbsp;&nbsp;&nbsp;&nbsp;</td>

	<td>

	<span class="phpreportmaker"><?php echo $ReportLanguage->Phrase("Record") ?> <?php echo $Pager->FromIndex ?> <?php echo $ReportLanguage->Phrase("To") ?> <?php echo $Pager->ToIndex ?> <?php echo $ReportLanguage->Phrase("Of") ?> <?php echo $Pager->RecordCount ?></span>

<?php } else { ?>

	<?php if ($Emp_Reports_by_Year_summary->Filter == "0=101") { ?>

	<span class="phpreportmaker"><?php echo $ReportLanguage->Phrase("EnterSearchCriteria") ?></span>

	<?php } else { ?>

	<span class="phpreportmaker"><?php echo $ReportLanguage->Phrase("NoRecord") ?></span>

	<?php } ?>

<?php } ?>

		</td>

<?php if ($Emp_Reports_by_Year_summary->TotalGrps > 0) { ?>

		<td style="white-space: nowrap;">&nbsp;&nbsp;&nbsp;&nbsp;</td>

		<td align="right" style="vertical-align: top; white-space: nowrap;"><span class="phpreportmaker"><?php echo $ReportLanguage->Phrase("GroupsPerPage"); ?>&nbsp;

<select name="<?php echo EWRPT_TABLE_GROUP_PER_PAGE; ?>" onchange="this.form.submit();">

<option value="1"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 1) echo " selected=\"selected\"" ?>>1</option>

<option value="2"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 2) echo " selected=\"selected\"" ?>>2</option>

<option value="3"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 3) echo " selected=\"selected\"" ?>>3</option>

<option value="4"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 4) echo " selected=\"selected\"" ?>>4</option>

<option value="5"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 5) echo " selected=\"selected\"" ?>>5</option>

<option value="10"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 10) echo " selected=\"selected\"" ?>>10</option>

<option value="20"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 20) echo " selected=\"selected\"" ?>>20</option>

<option value="50"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 50) echo " selected=\"selected\"" ?>>50</option>

<option value="ALL"<?php if ($Emp_Reports_by_Year->getGroupPerPage() == -1) echo " selected=\"selected\"" ?>><?php echo $ReportLanguage->Phrase("AllRecords") ?></option>

</select>

		</span></td>

<?php } ?>

	</tr>

</table>

</form>

</div>

<?php } ?>

<!-- Report Grid (Begin) -->

<div class="ewGridMiddlePanel">

<table class="<?php echo $Emp_Reports_by_Year_summary->ReportTableClass ?>" cellspacing="0">

<?php



// Set the last group to display if not export all

if ($Emp_Reports_by_Year->ExportAll && $Emp_Reports_by_Year->Export <> "") {

	$Emp_Reports_by_Year_summary->StopGrp = $Emp_Reports_by_Year_summary->TotalGrps;

} else {

	$Emp_Reports_by_Year_summary->StopGrp = $Emp_Reports_by_Year_summary->StartGrp + $Emp_Reports_by_Year_summary->DisplayGrps - 1;

}



// Stop group <= total number of groups

if (intval($Emp_Reports_by_Year_summary->StopGrp) > intval($Emp_Reports_by_Year_summary->TotalGrps))

	$Emp_Reports_by_Year_summary->StopGrp = $Emp_Reports_by_Year_summary->TotalGrps;

$Emp_Reports_by_Year_summary->RecCount = 0;



// Get first row

if ($Emp_Reports_by_Year_summary->TotalGrps > 0) {

	$Emp_Reports_by_Year_summary->GetGrpRow(1);

	$Emp_Reports_by_Year_summary->GrpCount = 1;

}

while (($rsgrp && !$rsgrp->EOF && $Emp_Reports_by_Year_summary->GrpCount <= $Emp_Reports_by_Year_summary->DisplayGrps) || $Emp_Reports_by_Year_summary->ShowFirstHeader) {



	// Show header

	if ($Emp_Reports_by_Year_summary->ShowFirstHeader) {

?>

	<thead>

	<tr>

<td class="ewTableHeader">

<?php if ($Emp_Reports_by_Year->Export <> "") { ?>

<?php echo $Emp_Reports_by_Year->department_name->FldCaption() ?>

<?php } else { ?>

	<table cellspacing="0" class="ewTableHeaderBtn"><tr>

<?php if ($Emp_Reports_by_Year->SortUrl($Emp_Reports_by_Year->department_name) == "") { ?>

		<td style="vertical-align: bottom;"><?php echo $Emp_Reports_by_Year->department_name->FldCaption() ?></td>

<?php } else { ?>

		<td class="ewPointer" onmousedown="ewrpt_Sort(event,'<?php echo $Emp_Reports_by_Year->SortUrl($Emp_Reports_by_Year->department_name) ?>',2);"><?php echo $Emp_Reports_by_Year->department_name->FldCaption() ?></td><td style="width: 10px;">

		<?php if ($Emp_Reports_by_Year->department_name->getSort() == "ASC") { ?><img src="phprptimages/sortup.gif" width="10" height="9" border="0"><?php } elseif ($Emp_Reports_by_Year->department_name->getSort() == "DESC") { ?><img src="phprptimages/sortdown.gif" width="10" height="9" border="0"><?php } ?></td>

<?php } ?>

		<td style="width: 20px;" align="right"><a href="#" onclick="ewrpt_ShowPopup(this.name, 'Emp_Reports_by_Year_department_name', false, '<?php echo $Emp_Reports_by_Year->department_name->RangeFrom; ?>', '<?php echo $Emp_Reports_by_Year->department_name->RangeTo; ?>');return false;" name="x_department_name<?php echo $Emp_Reports_by_Year_summary->Cnt[0][0]; ?>" id="x_department_name<?php echo $Emp_Reports_by_Year_summary->Cnt[0][0]; ?>"><img src="phprptimages/popup.gif" width="15" height="14" border="0" alt="<?php echo $ReportLanguage->Phrase("Filter") ?>"></a></td>

	</tr></table>

<?php } ?>

</td>

<td class="ewTableHeader">

<?php if ($Emp_Reports_by_Year->Export <> "") { ?>

<?php echo $Emp_Reports_by_Year->year->FldCaption() ?>

<?php } else { ?>

	<table cellspacing="0" class="ewTableHeaderBtn"><tr>

<?php if ($Emp_Reports_by_Year->SortUrl($Emp_Reports_by_Year->year) == "") { ?>

		<td style="vertical-align: bottom;"><?php echo $Emp_Reports_by_Year->year->FldCaption() ?></td>

<?php } else { ?>

		<td class="ewPointer" onmousedown="ewrpt_Sort(event,'<?php echo $Emp_Reports_by_Year->SortUrl($Emp_Reports_by_Year->year) ?>',2);"><?php echo $Emp_Reports_by_Year->year->FldCaption() ?></td><td style="width: 10px;">

		<?php if ($Emp_Reports_by_Year->year->getSort() == "ASC") { ?><img src="phprptimages/sortup.gif" width="10" height="9" border="0"><?php } elseif ($Emp_Reports_by_Year->year->getSort() == "DESC") { ?><img src="phprptimages/sortdown.gif" width="10" height="9" border="0"><?php } ?></td>

<?php } ?>

		<td style="width: 20px;" align="right"><a href="#" onclick="ewrpt_ShowPopup(this.name, 'Emp_Reports_by_Year_year', false, '<?php echo $Emp_Reports_by_Year->year->RangeFrom; ?>', '<?php echo $Emp_Reports_by_Year->year->RangeTo; ?>');return false;" name="x_year<?php echo $Emp_Reports_by_Year_summary->Cnt[0][0]; ?>" id="x_year<?php echo $Emp_Reports_by_Year_summary->Cnt[0][0]; ?>"><img src="phprptimages/popup.gif" width="15" height="14" border="0" alt="<?php echo $ReportLanguage->Phrase("Filter") ?>"></a></td>

	</tr></table>

<?php } ?>

</td>

<td class="ewTableHeader">

<?php if ($Emp_Reports_by_Year->Export <> "") { ?>

<?php echo $Emp_Reports_by_Year->full_name->FldCaption() ?>

<?php } else { ?>

	<table cellspacing="0" class="ewTableHeaderBtn"><tr>

<?php if ($Emp_Reports_by_Year->SortUrl($Emp_Reports_by_Year->full_name) == "") { ?>

		<td style="vertical-align: bottom;"><?php echo $Emp_Reports_by_Year->full_name->FldCaption() ?></td>

<?php } else { ?>

		<td class="ewPointer" onmousedown="ewrpt_Sort(event,'<?php echo $Emp_Reports_by_Year->SortUrl($Emp_Reports_by_Year->full_name) ?>',2);"><?php echo $Emp_Reports_by_Year->full_name->FldCaption() ?></td><td style="width: 10px;">

		<?php if ($Emp_Reports_by_Year->full_name->getSort() == "ASC") { ?><img src="phprptimages/sortup.gif" width="10" height="9" border="0"><?php } elseif ($Emp_Reports_by_Year->full_name->getSort() == "DESC") { ?><img src="phprptimages/sortdown.gif" width="10" height="9" border="0"><?php } ?></td>

<?php } ?>

	</tr></table>

<?php } ?>

</td>

<td class="ewTableHeader">

<?php if ($Emp_Reports_by_Year->Export <> "") { ?>

<?php echo $Emp_Reports_by_Year->dob->FldCaption() ?>

<?php } else { ?>

	<table cellspacing="0" class="ewTableHeaderBtn"><tr>

<?php if ($Emp_Reports_by_Year->SortUrl($Emp_Reports_by_Year->dob) == "") { ?>

		<td style="vertical-align: bottom;"><?php echo $Emp_Reports_by_Year->dob->FldCaption() ?></td>

<?php } else { ?>

		<td class="ewPointer" onmousedown="ewrpt_Sort(event,'<?php echo $Emp_Reports_by_Year->SortUrl($Emp_Reports_by_Year->dob) ?>',2);"><?php echo $Emp_Reports_by_Year->dob->FldCaption() ?></td><td style="width: 10px;">

		<?php if ($Emp_Reports_by_Year->dob->getSort() == "ASC") { ?><img src="phprptimages/sortup.gif" width="10" height="9" border="0"><?php } elseif ($Emp_Reports_by_Year->dob->getSort() == "DESC") { ?><img src="phprptimages/sortdown.gif" width="10" height="9" border="0"><?php } ?></td>

<?php } ?>

	</tr></table>

<?php } ?>

</td>

<td class="ewTableHeader">

<?php if ($Emp_Reports_by_Year->Export <> "") { ?>

<?php echo $Emp_Reports_by_Year->joined_company_date->FldCaption() ?>

<?php } else { ?>

	<table cellspacing="0" class="ewTableHeaderBtn"><tr>

<?php if ($Emp_Reports_by_Year->SortUrl($Emp_Reports_by_Year->joined_company_date) == "") { ?>

		<td style="vertical-align: bottom;"><?php echo $Emp_Reports_by_Year->joined_company_date->FldCaption() ?></td>

<?php } else { ?>

		<td class="ewPointer" onmousedown="ewrpt_Sort(event,'<?php echo $Emp_Reports_by_Year->SortUrl($Emp_Reports_by_Year->joined_company_date) ?>',2);"><?php echo $Emp_Reports_by_Year->joined_company_date->FldCaption() ?></td><td style="width: 10px;">

		<?php if ($Emp_Reports_by_Year->joined_company_date->getSort() == "ASC") { ?><img src="phprptimages/sortup.gif" width="10" height="9" border="0"><?php } elseif ($Emp_Reports_by_Year->joined_company_date->getSort() == "DESC") { ?><img src="phprptimages/sortdown.gif" width="10" height="9" border="0"><?php } ?></td>

<?php } ?>

	</tr></table>

<?php } ?>

</td>

	</tr>

	</thead>

	<tbody>

<?php

		$Emp_Reports_by_Year_summary->ShowFirstHeader = FALSE;

	}



	// Build detail SQL

	$sWhere = ewrpt_DetailFilterSQL($Emp_Reports_by_Year->department_name, $Emp_Reports_by_Year->SqlFirstGroupField(), $Emp_Reports_by_Year->department_name->GroupValue());

	if ($Emp_Reports_by_Year_summary->Filter != "")

		$sWhere = "($Emp_Reports_by_Year_summary->Filter) AND ($sWhere)";

	$sSql = ewrpt_BuildReportSql($Emp_Reports_by_Year->SqlSelect(), $Emp_Reports_by_Year->SqlWhere(), $Emp_Reports_by_Year->SqlGroupBy(), $Emp_Reports_by_Year->SqlHaving(), $Emp_Reports_by_Year->SqlOrderBy(), $sWhere, $Emp_Reports_by_Year_summary->Sort);

	$rs = $conn->Execute($sSql);

	$rsdtlcnt = ($rs) ? $rs->RecordCount() : 0;

	if ($rsdtlcnt > 0)

		$Emp_Reports_by_Year_summary->GetRow(1);

	while ($rs && !$rs->EOF) { // Loop detail records

		$Emp_Reports_by_Year_summary->RecCount++;



		// Render detail row

		$Emp_Reports_by_Year->ResetCSS();

		$Emp_Reports_by_Year->RowType = EWRPT_ROWTYPE_DETAIL;

		$Emp_Reports_by_Year_summary->RenderRow();

?>

	<tr<?php echo $Emp_Reports_by_Year->RowAttributes(); ?>>

		<td<?php echo $Emp_Reports_by_Year->department_name->CellAttributes(); ?>>

<span<?php echo $Emp_Reports_by_Year->department_name->ViewAttributes(); ?>><?php echo $Emp_Reports_by_Year->department_name->GroupViewValue; ?></span></td>

		<td<?php echo $Emp_Reports_by_Year->year->CellAttributes(); ?>>

<span<?php echo $Emp_Reports_by_Year->year->ViewAttributes(); ?>><?php echo $Emp_Reports_by_Year->year->GroupViewValue; ?></span></td>

		<td<?php echo $Emp_Reports_by_Year->full_name->CellAttributes() ?>>

<span<?php echo $Emp_Reports_by_Year->full_name->ViewAttributes(); ?>><?php echo $Emp_Reports_by_Year->full_name->ListViewValue(); ?></span></td>

		<td<?php echo $Emp_Reports_by_Year->dob->CellAttributes() ?>>

<span<?php echo $Emp_Reports_by_Year->dob->ViewAttributes(); ?>><?php echo $Emp_Reports_by_Year->dob->ListViewValue(); ?></span></td>

		<td<?php echo $Emp_Reports_by_Year->joined_company_date->CellAttributes() ?>>

<span<?php echo $Emp_Reports_by_Year->joined_company_date->ViewAttributes(); ?>><?php echo $Emp_Reports_by_Year->joined_company_date->ListViewValue(); ?></span></td>

	</tr>

<?php



		// Accumulate page summary

		$Emp_Reports_by_Year_summary->AccumulateSummary();



		// Get next record

		$Emp_Reports_by_Year_summary->GetRow(2);



		// Show Footers

?>

<?php

	} // End detail records loop

?>

<?php

?>

<?php

			$Emp_Reports_by_Year->ResetCSS();

			$Emp_Reports_by_Year->RowType = EWRPT_ROWTYPE_TOTAL;

			$Emp_Reports_by_Year->RowTotalType = EWRPT_ROWTOTAL_GROUP;

			$Emp_Reports_by_Year->RowTotalSubType = EWRPT_ROWTOTAL_FOOTER;

			$Emp_Reports_by_Year->RowGroupLevel = 1;

			$Emp_Reports_by_Year_summary->RenderRow();

?>

	<tr<?php echo $Emp_Reports_by_Year->RowAttributes(); ?>>

		<td colspan="5"<?php echo $Emp_Reports_by_Year->department_name->CellAttributes() ?>><?php echo $ReportLanguage->Phrase("RptSumHead") ?> <?php echo $Emp_Reports_by_Year->department_name->FldCaption() ?>: <?php echo $Emp_Reports_by_Year->department_name->GroupViewValue; ?> (<?php echo ewrpt_FormatNumber($Emp_Reports_by_Year_summary->Cnt[1][0],0,-2,-2,-2); ?><?php echo $ReportLanguage->Phrase("RptDtlRec") ?>)</td></tr>

<?php



			// Reset level 1 summary

			$Emp_Reports_by_Year_summary->ResetLevelSummary(1);

?>

<?php



	// Next group

	$Emp_Reports_by_Year_summary->GetGrpRow(2);

	$Emp_Reports_by_Year_summary->GrpCount++;

} // End while

?>

	</tbody>

	<tfoot>

<?php

if ($Emp_Reports_by_Year_summary->TotalGrps > 0) {

	$Emp_Reports_by_Year->ResetCSS();

	$Emp_Reports_by_Year->RowType = EWRPT_ROWTYPE_TOTAL;

	$Emp_Reports_by_Year->RowTotalType = EWRPT_ROWTOTAL_GRAND;

	$Emp_Reports_by_Year->RowTotalSubType = EWRPT_ROWTOTAL_FOOTER;

	$Emp_Reports_by_Year->RowAttrs["class"] = "ewRptGrandSummary";

	$Emp_Reports_by_Year_summary->RenderRow();

?>

	<!-- tr><td colspan="5"><span class="phpreportmaker">&nbsp;<br></span></td></tr -->

	<tr<?php echo $Emp_Reports_by_Year->RowAttributes(); ?>><td colspan="5"><?php echo $ReportLanguage->Phrase("RptGrandTotal") ?> (<?php echo ewrpt_FormatNumber($Emp_Reports_by_Year_summary->TotCount,0,-2,-2,-2); ?><?php echo $ReportLanguage->Phrase("RptDtlRec") ?>)</td></tr>

<?php } ?>

	</tfoot>

</table>

</div>

<?php if ($Emp_Reports_by_Year_summary->TotalGrps > 0) { ?>

<?php if ($Emp_Reports_by_Year->Export == "") { ?>

<div class="ewGridLowerPanel">

<form action="<?php echo ewrpt_CurrentPage() ?>" name="ewpagerform" id="ewpagerform" class="ewForm">

<table border="0" cellspacing="0" cellpadding="0">

	<tr>

		<td style="white-space: nowrap;">

<?php if (!isset($Pager)) $Pager = new crPrevNextPager($Emp_Reports_by_Year_summary->StartGrp, $Emp_Reports_by_Year_summary->DisplayGrps, $Emp_Reports_by_Year_summary->TotalGrps) ?>

<?php if ($Pager->RecordCount > 0) { ?>

	<table border="0" cellspacing="0" cellpadding="0"><tr><td><span class="phpreportmaker"><?php echo $ReportLanguage->Phrase("Page") ?>&nbsp;</span></td>

<!--first page button-->

	<?php if ($Pager->FirstButton->Enabled) { ?>

	<td><a href="<?php echo ewrpt_CurrentPage() ?>?start=<?php echo $Pager->FirstButton->Start ?>"><img src="phprptimages/first.gif" alt="<?php echo $ReportLanguage->Phrase("PagerFirst") ?>" width="16" height="16" border="0"></a></td>

	<?php } else { ?>

	<td><img src="phprptimages/firstdisab.gif" alt="<?php echo $ReportLanguage->Phrase("PagerFirst") ?>" width="16" height="16" border="0"></td>

	<?php } ?>

<!--previous page button-->

	<?php if ($Pager->PrevButton->Enabled) { ?>

	<td><a href="<?php echo ewrpt_CurrentPage() ?>?start=<?php echo $Pager->PrevButton->Start ?>"><img src="phprptimages/prev.gif" alt="<?php echo $ReportLanguage->Phrase("PagerPrevious") ?>" width="16" height="16" border="0"></a></td>

	<?php } else { ?>

	<td><img src="phprptimages/prevdisab.gif" alt="<?php echo $ReportLanguage->Phrase("PagerPrevious") ?>" width="16" height="16" border="0"></td>

	<?php } ?>

<!--current page number-->

	<td><input type="text" name="pageno" id="pageno" value="<?php echo $Pager->CurrentPage ?>" size="4"></td>

<!--next page button-->

	<?php if ($Pager->NextButton->Enabled) { ?>

	<td><a href="<?php echo ewrpt_CurrentPage() ?>?start=<?php echo $Pager->NextButton->Start ?>"><img src="phprptimages/next.gif" alt="<?php echo $ReportLanguage->Phrase("PagerNext") ?>" width="16" height="16" border="0"></a></td>	

	<?php } else { ?>

	<td><img src="phprptimages/nextdisab.gif" alt="<?php echo $ReportLanguage->Phrase("PagerNext") ?>" width="16" height="16" border="0"></td>

	<?php } ?>

<!--last page button-->

	<?php if ($Pager->LastButton->Enabled) { ?>

	<td><a href="<?php echo ewrpt_CurrentPage() ?>?start=<?php echo $Pager->LastButton->Start ?>"><img src="phprptimages/last.gif" alt="<?php echo $ReportLanguage->Phrase("PagerLast") ?>" width="16" height="16" border="0"></a></td>	

	<?php } else { ?>

	<td><img src="phprptimages/lastdisab.gif" alt="<?php echo $ReportLanguage->Phrase("PagerLast") ?>" width="16" height="16" border="0"></td>

	<?php } ?>

	<td><span class="phpreportmaker">&nbsp;<?php echo $ReportLanguage->Phrase("of") ?> <?php echo $Pager->PageCount ?></span></td>

	</tr></table>

	</td>	

	<td>&nbsp;&nbsp;&nbsp;&nbsp;</td>

	<td>

	<span class="phpreportmaker"><?php echo $ReportLanguage->Phrase("Record") ?> <?php echo $Pager->FromIndex ?> <?php echo $ReportLanguage->Phrase("To") ?> <?php echo $Pager->ToIndex ?> <?php echo $ReportLanguage->Phrase("Of") ?> <?php echo $Pager->RecordCount ?></span>

<?php } else { ?>

	<?php if ($Emp_Reports_by_Year_summary->Filter == "0=101") { ?>

	<span class="phpreportmaker"><?php echo $ReportLanguage->Phrase("EnterSearchCriteria") ?></span>

	<?php } else { ?>

	<span class="phpreportmaker"><?php echo $ReportLanguage->Phrase("NoRecord") ?></span>

	<?php } ?>

<?php } ?>

		</td>

<?php if ($Emp_Reports_by_Year_summary->TotalGrps > 0) { ?>

		<td style="white-space: nowrap;">&nbsp;&nbsp;&nbsp;&nbsp;</td>

		<td align="right" style="vertical-align: top; white-space: nowrap;"><span class="phpreportmaker"><?php echo $ReportLanguage->Phrase("GroupsPerPage"); ?>&nbsp;

<select name="<?php echo EWRPT_TABLE_GROUP_PER_PAGE; ?>" onchange="this.form.submit();">

<option value="1"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 1) echo " selected=\"selected\"" ?>>1</option>

<option value="2"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 2) echo " selected=\"selected\"" ?>>2</option>

<option value="3"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 3) echo " selected=\"selected\"" ?>>3</option>

<option value="4"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 4) echo " selected=\"selected\"" ?>>4</option>

<option value="5"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 5) echo " selected=\"selected\"" ?>>5</option>

<option value="10"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 10) echo " selected=\"selected\"" ?>>10</option>

<option value="20"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 20) echo " selected=\"selected\"" ?>>20</option>

<option value="50"<?php if ($Emp_Reports_by_Year_summary->DisplayGrps == 50) echo " selected=\"selected\"" ?>>50</option>

<option value="ALL"<?php if ($Emp_Reports_by_Year->getGroupPerPage() == -1) echo " selected=\"selected\"" ?>><?php echo $ReportLanguage->Phrase("AllRecords") ?></option>

</select>

		</span></td>

<?php } ?>

	</tr>

</table>

</form>

</div>

<?php } ?>

<?php } ?>

</td></tr></table>

</div>

<!-- Summary Report Ends -->

<?php if ($Emp_Reports_by_Year->Export == "" || $Emp_Reports_by_Year->Export == "print" || $Emp_Reports_by_Year->Export == "email") { ?>

	</div><br></td>

	<!-- Center Container - Report (End) -->

	<!-- Right Container (Begin) -->

	<td style="vertical-align: top;"><div id="ewRight" class="phpreportmaker">

	<!-- Right slot -->

	</div></td>

	<!-- Right Container (End) -->

</tr>

<!-- Bottom Container (Begin) -->

<tr><td colspan="3"><div id="ewBottom" class="phpreportmaker">

	<!-- Bottom slot -->

	</div><br></td></tr>

<!-- Bottom Container (End) -->

</table>

<!-- Table Container (End) -->

<?php } ?>

<?php $Emp_Reports_by_Year_summary->ShowPageFooter(); ?>

<?php if (EWRPT_DEBUG_ENABLED) echo ewrpt_DebugMsg(); ?>

<?php



// Close recordsets

if ($rsgrp) $rsgrp->Close();

if ($rs) $rs->Close();

?>

<?php if ($Emp_Reports_by_Year->Export == "") { ?>

<script language="JavaScript" type="text/javascript">

<!--



// Write your table-specific startup script here

// document.write("page loaded");

//-->



</script>

<?php } ?>

<?php include_once "phprptinc/footer.php"; ?>

<?php

$Emp_Reports_by_Year_summary->Page_Terminate();

?>

<?php



//

// Page class

//

class crEmp_Reports_by_Year_summary {



	// Page ID

	var $PageID = 'summary';



	// Table name

	var $TableName = 'Emp Reports by Year';



	// Page object name

	var $PageObjName = 'Emp_Reports_by_Year_summary';



	// Page name

	function PageName() {

		return ewrpt_CurrentPage();

	}



	// Page URL

	function PageUrl() {

		$PageUrl = ewrpt_CurrentPage() . "?";

		global $Emp_Reports_by_Year;

		if ($Emp_Reports_by_Year->UseTokenInUrl) $PageUrl .= "t=" . $Emp_Reports_by_Year->TableVar . "&"; // Add page token

		return $PageUrl;

	}



	// Export URLs

	var $ExportPrintUrl;

	var $ExportExcelUrl;

	var $ExportWordUrl;

	var $ExportPdfUrl;

	var $ReportTableClass;



	// Message

	function getMessage() {

		return @$_SESSION[EWRPT_SESSION_MESSAGE];

	}



	function setMessage($v) {

		if (@$_SESSION[EWRPT_SESSION_MESSAGE] <> "") { // Append

			$_SESSION[EWRPT_SESSION_MESSAGE] .= "<br>" . $v;

		} else {

			$_SESSION[EWRPT_SESSION_MESSAGE] = $v;

		}

	}



	// Show message

	function ShowMessage() {

		$sMessage = $this->getMessage();

		$this->Message_Showing($sMessage);

		if ($sMessage <> "") { // Message in Session, display

			echo "<p><span class=\"ewMessage\">" . $sMessage . "</span></p>";

			$_SESSION[EWRPT_SESSION_MESSAGE] = ""; // Clear message in Session

		}

	}

	var $PageHeader;

	var $PageFooter;



	// Show Page Header

	function ShowPageHeader() {

		$sHeader = $this->PageHeader;

		$this->Page_DataRendering($sHeader);

		if ($sHeader <> "") { // Header exists, display

			echo "<p><span class=\"phpreportmaker\">" . $sHeader . "</span></p>";

		}

	}



	// Show Page Footer

	function ShowPageFooter() {

		$sFooter = $this->PageFooter;

		$this->Page_DataRendered($sFooter);

		if ($sFooter <> "") { // Fotoer exists, display

			echo "<p><span class=\"phpreportmaker\">" . $sFooter . "</span></p>";

		}

	}



	// Validate page request

	function IsPageRequest() {

		global $Emp_Reports_by_Year;

		if ($Emp_Reports_by_Year->UseTokenInUrl) {

			if (ewrpt_IsHttpPost())

				return ($Emp_Reports_by_Year->TableVar == @$_POST("t"));

			if (@$_GET["t"] <> "")

				return ($Emp_Reports_by_Year->TableVar == @$_GET["t"]);

		} else {

			return TRUE;

		}

	}



	//

	// Page class constructor

	//

	function crEmp_Reports_by_Year_summary() {

		global $conn, $ReportLanguage;



		// Language object

		$ReportLanguage = new crLanguage();



		// Table object (Emp_Reports_by_Year)

		$GLOBALS["Emp_Reports_by_Year"] = new crEmp_Reports_by_Year();

		$GLOBALS["Table"] =& $GLOBALS["Emp_Reports_by_Year"];



		// 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("EWRPT_PAGE_ID"))

			define("EWRPT_PAGE_ID", 'summary', TRUE);



		// Table name (for backward compatibility)

		if (!defined("EWRPT_TABLE_NAME"))

			define("EWRPT_TABLE_NAME", 'Emp Reports by Year', TRUE);



		// Start timer

		$GLOBALS["gsTimer"] = new crTimer();



		// Open connection

		$conn = ewrpt_Connect();



		// Export options

		$this->ExportOptions = new crListOptions();

		$this->ExportOptions->Tag = "span";

		$this->ExportOptions->Separator = "&nbsp;&nbsp;";

	}



	// 

	//  Page_Init

	//

	function Page_Init() {

		global $gsExport, $gsExportFile, $ReportLanguage, $Security;

		global $Emp_Reports_by_Year;



		// Get export parameters

		if (@$_GET["export"] <> "") {

			$Emp_Reports_by_Year->Export = $_GET["export"];

		}

		$gsExport = $Emp_Reports_by_Year->Export; // Get export parameter, used in header

		$gsExportFile = $Emp_Reports_by_Year->TableVar; // Get export file, used in header

		if ($Emp_Reports_by_Year->Export == "excel") {

			header('Content-Type: application/vnd.ms-excel;charset=utf-8');

			header('Content-Disposition: attachment; filename=' . $gsExportFile .'.xls');

		}

		if ($Emp_Reports_by_Year->Export == "word") {

			header('Content-Type: application/vnd.ms-word;charset=utf-8');

			header('Content-Disposition: attachment; filename=' . $gsExportFile .'.doc');

		}



		// Setup export options

		$this->SetupExportOptions();



		// Global Page Loading event (in userfn*.php)

		Page_Loading();



		// Page Load event

		$this->Page_Load();

	}



	// Set up export options

	function SetupExportOptions() {

		global $ReportLanguage, $Emp_Reports_by_Year;



		// Printer friendly

		$item =& $this->ExportOptions->Add("print");

		$item->Body = "<a href=\"" . $this->ExportPrintUrl . "\">" . $ReportLanguage->Phrase("PrinterFriendly") . "</a>";

		$item->Visible = TRUE;



		// Export to Excel

		$item =& $this->ExportOptions->Add("excel");

		$item->Body = "<a href=\"" . $this->ExportExcelUrl . "\">" . $ReportLanguage->Phrase("ExportToExcel") . "</a>";

		$item->Visible = TRUE;



		// Export to Word

		$item =& $this->ExportOptions->Add("word");

		$item->Body = "<a href=\"" . $this->ExportWordUrl . "\">" . $ReportLanguage->Phrase("ExportToWord") . "</a>";

		$item->Visible = TRUE;



		// Export to Pdf

		$item =& $this->ExportOptions->Add("pdf");

		$item->Body = "<a href=\"" . $this->ExportPdfUrl . "\">" . $ReportLanguage->Phrase("ExportToPDF") . "</a>";

		$item->Visible = FALSE;



		// Uncomment codes below to show export to Pdf link

//		$item->Visible = FALSE;

		// Export to Email



		$item =& $this->ExportOptions->Add("email");

		$item->Body = "<a name=\"emf_Emp_Reports_by_Year\" id=\"emf_Emp_Reports_by_Year\" href=\"javascript:void(0);\" onclick=\"ewrpt_EmailDialogShow({lnk:'emf_Emp_Reports_by_Year',hdr:ewLanguage.Phrase('ExportToEmail')});\">" . $ReportLanguage->Phrase("ExportToEmail") . "</a>";

		$item->Visible = FALSE;



		// Reset filter

		$item =& $this->ExportOptions->Add("resetfilter");

		$item->Body = "<a href=\"" . ewrpt_CurrentPage() . "?cmd=reset\">" . $ReportLanguage->Phrase("ResetAllFilter") . "</a>";

		$item->Visible = TRUE;

		$this->SetupExportOptionsExt();



		// Hide options for export

		if ($Emp_Reports_by_Year->Export <> "")

			$this->ExportOptions->HideAllOptions();



		// Set up table class

		if ($Emp_Reports_by_Year->Export == "word" || $Emp_Reports_by_Year->Export == "excel" || $Emp_Reports_by_Year->Export == "pdf")

			$this->ReportTableClass = "ewTable";

		else

			$this->ReportTableClass = "ewTable ewTableSeparate";

	}



	//

	// Page_Terminate

	//

	function Page_Terminate($url = "") {

		global $conn;

		global $ReportLanguage;

		global $Emp_Reports_by_Year;



		// Page Unload event

		$this->Page_Unload();



		// Global Page Unloaded event (in userfn*.php)

		Page_Unloaded();



		// Export to Email (use ob_file_contents for PHP)

		if ($Emp_Reports_by_Year->Export == "email") {

			$sContent = ob_get_contents();

			$this->ExportEmail($sContent);

			ob_end_clean();



			 // Close connection

			$conn->Close();

			header("Location: " . ewrpt_CurrentPage());

			exit();

		}



		// Export to PDF (use ob_file_contents for PHP)

		if ($Emp_Reports_by_Year->Export == "pdf") {

			$sContent = ob_get_contents();

			$this->ExportPDF($sContent);

			ob_end_clean();



			 // Close connection

			$conn->Close();

		}



		 // Close connection

		$conn->Close();



		// Go to URL if specified

		if ($url <> "") {

			if (!EWRPT_DEBUG_ENABLED && ob_get_length())

				ob_end_clean();

			header("Location: " . $url);

		}

		exit();

	}



	// Initialize common variables

	var $ExportOptions; // Export options



	// Paging variables

	var $RecCount = 0; // Record count

	var $StartGrp = 0; // Start group

	var $StopGrp = 0; // Stop group

	var $TotalGrps = 0; // Total groups

	var $GrpCount = 0; // Group count

	var $DisplayGrps = 10; // Groups per page

	var $GrpRange = 10;

	var $Sort = "";

	var $Filter = "";

	var $UserIDFilter = "";



	// Clear field for ext filter

	var $ClearExtFilter = "";

	var $FilterApplied;

	var $ShowFirstHeader;

	var $Cnt, $Col, $Val, $Smry, $Mn, $Mx, $GrandSmry, $GrandMn, $GrandMx;

	var $TotCount;



	//

	// Page main

	//

	function Page_Main() {

		global $Emp_Reports_by_Year;

		global $rs;

		global $rsgrp;

		global $gsFormError;



		// Aggregate variables

		// 1st dimension = no of groups (level 0 used for grand total)

		// 2nd dimension = no of fields



		$nDtls = 4;

		$nGrps = 3;

		$this->Val =& ewrpt_InitArray($nDtls, 0);

		$this->Cnt =& ewrpt_Init2DArray($nGrps, $nDtls, 0);

		$this->Smry =& ewrpt_Init2DArray($nGrps, $nDtls, 0);

		$this->Mn =& ewrpt_Init2DArray($nGrps, $nDtls, NULL);

		$this->Mx =& ewrpt_Init2DArray($nGrps, $nDtls, NULL);

		$this->GrandSmry =& ewrpt_InitArray($nDtls, 0);

		$this->GrandMn =& ewrpt_InitArray($nDtls, NULL);

		$this->GrandMx =& ewrpt_InitArray($nDtls, NULL);



		// Set up if accumulation required

		$this->Col = array(FALSE, FALSE, FALSE, FALSE);



		// Set up groups per page dynamically

		$this->SetUpDisplayGrps();

		$Emp_Reports_by_Year->department_name->SelectionList = "";

		$Emp_Reports_by_Year->department_name->DefaultSelectionList = "";

		$Emp_Reports_by_Year->department_name->ValueList = "";

		$Emp_Reports_by_Year->year->SelectionList = "";

		$Emp_Reports_by_Year->year->DefaultSelectionList = "";

		$Emp_Reports_by_Year->year->ValueList = "";



		// Load default filter values

		$this->LoadDefaultFilters();



		// Load custom filters

		$Emp_Reports_by_Year->Filters_Load();



		// Set up popup filter

		$this->SetupPopup();



		// Extended filter

		$sExtendedFilter = "";



		// Build popup filter

		$sPopupFilter = $this->GetPopupFilter();



		//ewrpt_SetDebugMsg("popup filter: " . $sPopupFilter);

		if ($sPopupFilter <> "") {

			if ($this->Filter <> "")

				$this->Filter = "($this->Filter) AND ($sPopupFilter)";

			else

				$this->Filter = $sPopupFilter;

		}



		// Check if filter applied

		$this->FilterApplied = $this->CheckFilter();

		$this->ExportOptions->GetItem("resetfilter")->Visible = $this->FilterApplied;



		// Get sort

		$this->Sort = $this->GetSort();



		// Get total group count

		$sGrpSort = ewrpt_UpdateSortFields($Emp_Reports_by_Year->SqlOrderByGroup(), $this->Sort, 2); // Get grouping field only

		$sSql = ewrpt_BuildReportSql($Emp_Reports_by_Year->SqlSelectGroup(), $Emp_Reports_by_Year->SqlWhere(), $Emp_Reports_by_Year->SqlGroupBy(), $Emp_Reports_by_Year->SqlHaving(), $Emp_Reports_by_Year->SqlOrderByGroup(), $this->Filter, $sGrpSort);

		$this->TotalGrps = $this->GetGrpCnt($sSql);

		if ($this->DisplayGrps <= 0) // Display all groups

			$this->DisplayGrps = $this->TotalGrps;

		$this->StartGrp = 1;



		// Show header

		$this->ShowFirstHeader = ($this->TotalGrps > 0);



		//$this->ShowFirstHeader = TRUE; // Uncomment to always show header

		// Set up start position if not export all



		if ($Emp_Reports_by_Year->ExportAll && $Emp_Reports_by_Year->Export <> "")

		    $this->DisplayGrps = $this->TotalGrps;

		else

			$this->SetUpStartGroup(); 



		// Hide all options if export

		if ($Emp_Reports_by_Year->Export <> "") {

			$this->ExportOptions->HideAllOptions();

		}



		// Get current page groups

		$rsgrp = $this->GetGrpRs($sSql, $this->StartGrp, $this->DisplayGrps);



		// Init detail recordset

		$rs = NULL;

	}



	// Check level break

	function ChkLvlBreak($lvl) {

		global $Emp_Reports_by_Year;

		switch ($lvl) {

			case 1:

				return (is_null($Emp_Reports_by_Year->department_name->CurrentValue) && !is_null($Emp_Reports_by_Year->department_name->OldValue)) ||

					(!is_null($Emp_Reports_by_Year->department_name->CurrentValue) && is_null($Emp_Reports_by_Year->department_name->OldValue)) ||

					($Emp_Reports_by_Year->department_name->GroupValue() <> $Emp_Reports_by_Year->department_name->GroupOldValue());

			case 2:

				return (is_null($Emp_Reports_by_Year->year->CurrentValue) && !is_null($Emp_Reports_by_Year->year->OldValue)) ||

					(!is_null($Emp_Reports_by_Year->year->CurrentValue) && is_null($Emp_Reports_by_Year->year->OldValue)) ||

					($Emp_Reports_by_Year->year->GroupValue() <> $Emp_Reports_by_Year->year->GroupOldValue()) || $this->ChkLvlBreak(1); // Recurse upper level

		}

	}



	// Accummulate summary

	function AccumulateSummary() {

		$cntx = count($this->Smry);

		for ($ix = 0; $ix < $cntx; $ix++) {

			$cnty = count($this->Smry[$ix]);

			for ($iy = 1; $iy < $cnty; $iy++) {

				$this->Cnt[$ix][$iy]++;

				if ($this->Col[$iy]) {

					$valwrk = $this->Val[$iy];

					if (is_null($valwrk) || !is_numeric($valwrk)) {



						// skip

					} else {

						$this->Smry[$ix][$iy] += $valwrk;

						if (is_null($this->Mn[$ix][$iy])) {

							$this->Mn[$ix][$iy] = $valwrk;

							$this->Mx[$ix][$iy] = $valwrk;

						} else {

							if ($this->Mn[$ix][$iy] > $valwrk) $this->Mn[$ix][$iy] = $valwrk;

							if ($this->Mx[$ix][$iy] < $valwrk) $this->Mx[$ix][$iy] = $valwrk;

						}

					}

				}

			}

		}

		$cntx = count($this->Smry);

		for ($ix = 1; $ix < $cntx; $ix++) {

			$this->Cnt[$ix][0]++;

		}

	}



	// Reset level summary

	function ResetLevelSummary($lvl) {



		// Clear summary values

		$cntx = count($this->Smry);

		fo…