function Main()
{
$this->tpl->set_var("Session", $this->sess->url(""));
$db = new DB_Records();
$sql = sprintf("select %s from %s order by LGUName;", "LGUID", LGU_TABLE);
$db->query($sql);
$this->tpl->set_block("rptsTemplate", "DBList", "DBListBlock");
while ($db->next_record()) {
$lgu = new LGU();
$lgu->selectRecord($db->f("LGUID"));
$this->tpl->set_var("lguName", $lgu->getLGUDB());
$this->tpl->set_var("lguDB", $lgu->getLGUID());
$this->tpl->parse("DBListBlock", "DBList", true);
}
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
function Main()
{
global $DBid;
$this->tpl->set_var("Session", $this->sess->url(""));
$this->tpl->set_var("date", date("F d, Y"));
$this->subRETaxableRealPropertyUnits = 0;
$this->subRETaxableLandArea = 0;
$this->subAGTaxableRealPropertyUnits = 0;
$this->subAGTaxableLandArea = 0;
$this->subCOTaxableRealPropertyUnits = 0;
$this->subCOTaxableLandArea = 0;
$this->subINTaxableRealPropertyUnits = 0;
$this->subINTaxableLandArea = 0;
$this->subMITaxableRealPropertyUnits = 0;
$this->subMITaxableLandArea = 0;
$this->subTITaxableRealPropertyUnits = 0;
$this->subTITaxableLandArea = 0;
$this->subSPTaxableRealPropertyUnits = 0;
$this->subSPTaxableLandArea = 0;
$this->subHOTaxableRealPropertyUnits = 0;
$this->subHOTaxableLandArea = 0;
$this->subSCTaxableRealPropertyUnits = 0;
$this->subSCTaxableLandArea = 0;
$this->subCUTaxableRealPropertyUnits = 0;
$this->subCUTaxableLandArea = 0;
$this->subOTTaxableRealPropertyUnits = 0;
$this->subOTTaxableLandArea = 0;
$this->subGOExemptRealPropertyUnits = 0;
$this->subGOExemptLandArea = 0;
$this->subRLExemptRealPropertyUnits = 0;
$this->subRLExemptLandArea = 0;
$this->subCHExemptRealPropertyUnits = 0;
$this->subCHExemptLandArea = 0;
$this->subEDExemptRealPropertyUnits = 0;
$this->subEDExemptLandArea = 0;
$this->subOTExemptRealPropertyUnits = 0;
$this->subOTExemptLandArea = 0;
$this->subRETaxableLandMarketValue = 0;
$this->subRETaxableLandAssessedValue = 0;
$this->subAGTaxableLandMarketValue = 0;
$this->subAGTaxableLandAssessedValue = 0;
$this->subCOTaxableLandMarketValue = 0;
$this->subCOTaxableLandAssessedValue = 0;
$this->subINTaxableLandMarketValue = 0;
$this->subINTaxableLandAssessedValue = 0;
$this->subMITaxableLandMarketValue = 0;
$this->subMITaxableLandAssessedValue = 0;
$this->subTITaxableLandMarketValue = 0;
$this->subTITaxableLandAssessedValue = 0;
$this->subSPTaxableLandMarketValue = 0;
$this->subSPTaxableLandAssessedValue = 0;
$this->subHOTaxableLandMarketValue = 0;
$this->subHOTaxableLandAssessedValue = 0;
$this->subSCTaxableLandMarketValue = 0;
$this->subSCTaxableLandAssessedValue = 0;
$this->subCUTaxableLandMarketValue = 0;
$this->subCUTaxableLandAssessedValue = 0;
$this->subOTTaxableLandMarketValue = 0;
$this->subOTTaxableLandAssessedValue = 0;
$this->subGOExemptLandMarketValue = 0;
$this->subGOExemptLandAssessedValue = 0;
$this->subRLExemptLandMarketValue = 0;
$this->subRLExemptLandAssessedValue = 0;
$this->subCHExemptLandMarketValue = 0;
$this->subCHExemptLandAssessedValue = 0;
$this->subEDExemptLandMarketValue = 0;
$this->subEDExemptLandAssessedValue = 0;
$this->subOTExemptLandMarketValue = 0;
$this->subOTExemptLandAssessedValue = 0;
$this->subRETaxableBldgLessMarketValue = 0;
$this->subRETaxableBldgLessAssessedValue = 0;
$this->subAGTaxableBldgLessMarketValue = 0;
$this->subAGTaxableBldgLessAssessedValue = 0;
$this->subCOTaxableBldgLessMarketValue = 0;
$this->subCOTaxableBldgLessAssessedValue = 0;
$this->subINTaxableBldgLessMarketValue = 0;
$this->subINTaxableBldgLessAssessedValue = 0;
$this->subMITaxableBldgLessMarketValue = 0;
$this->subMITaxableBldgLessAssessedValue = 0;
$this->subTITaxableBldgLessMarketValue = 0;
$this->subTITaxableBldgLessAssessedValue = 0;
$this->subSPTaxableBldgLessMarketValue = 0;
$this->subSPTaxableBldgLessAssessedValue = 0;
$this->subHOTaxableBldgLessMarketValue = 0;
$this->subHOTaxableBldgLessAssessedValue = 0;
$this->subSCTaxableBldgLessMarketValue = 0;
$this->subSCTaxableBldgLessAssessedValue = 0;
$this->subCUTaxableBldgLessMarketValue = 0;
$this->subCUTaxableBldgLessAssessedValue = 0;
$this->subOTTaxableBldgLessMarketValue = 0;
$this->subOTTaxableBldgLessAssessedValue = 0;
$this->subGOExemptBldgLessMarketValue = 0;
$this->subGOExemptBldgLessAssessedValue = 0;
$this->subRLExemptBldgLessMarketValue = 0;
$this->subRLExemptBldgLessAssessedValue = 0;
$this->subCHExemptBldgLessMarketValue = 0;
$this->subCHExemptBldgLessAssessedValue = 0;
$this->subEDExemptBldgLessMarketValue = 0;
$this->subEDExemptBldgLessAssessedValue = 0;
$this->subOTExemptBldgLessMarketValue = 0;
$this->subOTExemptBldgLessAssessedValue = 0;
$this->subRETaxableBldgOverMarketValue = 0;
$this->subRETaxableBldgOverAssessedValue = 0;
$this->subAGTaxableBldgOverMarketValue = 0;
$this->subAGTaxableBldgOverAssessedValue = 0;
$this->subCOTaxableBldgOverMarketValue = 0;
$this->subCOTaxableBldgOverAssessedValue = 0;
$this->subINTaxableBldgOverMarketValue = 0;
$this->subINTaxableBldgOverAssessedValue = 0;
$this->subMITaxableBldgOverMarketValue = 0;
$this->subMITaxableBldgOverAssessedValue = 0;
$this->subTITaxableBldgOverMarketValue = 0;
$this->subTITaxableBldgOverAssessedValue = 0;
$this->subSPTaxableBldgOverMarketValue = 0;
$this->subSPTaxableBldgOverAssessedValue = 0;
$this->subHOTaxableBldgOverMarketValue = 0;
$this->subHOTaxableBldgOverAssessedValue = 0;
$this->subSCTaxableBldgOverMarketValue = 0;
$this->subSCTaxableBldgOverAssessedValue = 0;
$this->subCUTaxableBldgOverMarketValue = 0;
$this->subCUTaxableBldgOverAssessedValue = 0;
$this->subOTTaxableBldgOverMarketValue = 0;
$this->subOTTaxableBldgOverAssessedValue = 0;
$this->subGOExemptBldgOverMarketValue = 0;
$this->subGOExemptBldgOverAssessedValue = 0;
$this->subRLExemptBldgOverMarketValue = 0;
$this->subRLExemptBldgOverAssessedValue = 0;
$this->subCHExemptBldgOverMarketValue = 0;
$this->subCHExemptBldgOverAssessedValue = 0;
$this->subEDExemptBldgOverMarketValue = 0;
$this->subEDExemptBldgOverAssessedValue = 0;
$this->subOTExemptBldgOverMarketValue = 0;
$this->subOTExemptBldgOverAssessedValue = 0;
$this->subRETaxableMachMarketValue = 0;
$this->subRETaxableMachAssessedValue = 0;
$this->subAGTaxableMachMarketValue = 0;
$this->subAGTaxableMachAssessedValue = 0;
$this->subCOTaxableMachMarketValue = 0;
$this->subCOTaxableMachAssessedValue = 0;
$this->subINTaxableMachMarketValue = 0;
$this->subINTaxableMachAssessedValue = 0;
$this->subMITaxableMachMarketValue = 0;
$this->subMITaxableMachAssessedValue = 0;
$this->subTITaxableMachMarketValue = 0;
$this->subTITaxableMachAssessedValue = 0;
$this->subSPTaxableMachMarketValue = 0;
$this->subSPTaxableMachAssessedValue = 0;
$this->subHOTaxableMachMarketValue = 0;
$this->subHOTaxableMachAssessedValue = 0;
$this->subSCTaxableMachMarketValue = 0;
$this->subSCTaxableMachAssessedValue = 0;
$this->subCUTaxableMachMarketValue = 0;
$this->subCUTaxableMachAssessedValue = 0;
$this->subOTTaxableMachMarketValue = 0;
$this->subOTTaxableMachAssessedValue = 0;
$this->subGOExemptMachMarketValue = 0;
$this->subGOExemptMachAssessedValue = 0;
$this->subRLExemptMachMarketValue = 0;
$this->subRLExemptMachAssessedValue = 0;
$this->subCHExemptMachMarketValue = 0;
$this->subCHExemptMachAssessedValue = 0;
$this->subEDExemptMachMarketValue = 0;
$this->subEDExemptMachAssessedValue = 0;
$this->subOTExemptMachMarketValue = 0;
$this->subOTExemptMachAssessedValue = 0;
$this->subRETaxableOtherMarketValue = 0;
$this->subRETaxableOtherAssessedValue = 0;
$this->subAGTaxableOtherMarketValue = 0;
$this->subAGTaxableOtherAssessedValue = 0;
$this->subCOTaxableOtherMarketValue = 0;
$this->subCOTaxableOtherAssessedValue = 0;
$this->subINTaxableOtherMarketValue = 0;
$this->subINTaxableOtherAssessedValue = 0;
$this->subMITaxableOtherMarketValue = 0;
$this->subMITaxableOtherAssessedValue = 0;
$this->subTITaxableOtherMarketValue = 0;
$this->subTITaxableOtherAssessedValue = 0;
$this->subSPTaxableOtherMarketValue = 0;
$this->subSPTaxableOtherAssessedValue = 0;
$this->subHOTaxableOtherMarketValue = 0;
$this->subHOTaxableOtherAssessedValue = 0;
$this->subSCTaxableOtherMarketValue = 0;
$this->subSCTaxableOtherAssessedValue = 0;
$this->subCUTaxableOtherMarketValue = 0;
$this->subCUTaxableOtherAssessedValue = 0;
$this->subOTTaxableOtherMarketValue = 0;
$this->subOTTaxableOtherAssessedValue = 0;
$this->subGOExemptOtherMarketValue = 0;
$this->subGOExemptOtherAssessedValue = 0;
$this->subRLExemptOtherMarketValue = 0;
$this->subRLExemptOtherAssessedValue = 0;
$this->subCHExemptOtherMarketValue = 0;
$this->subCHExemptOtherAssessedValue = 0;
$this->subEDExemptOtherMarketValue = 0;
$this->subEDExemptOtherAssessedValue = 0;
$this->subOTExemptOtherMarketValue = 0;
$this->subOTExemptOtherAssessedValue = 0;
$this->totalRETaxableMarketValue = 0;
$this->totalRETaxableAssessedValue = 0;
$this->totalAGTaxableMarketValue = 0;
$this->totalAGTaxableAssessedValue = 0;
$this->totalCOTaxableMarketValue = 0;
$this->totalCOTaxableAssessedValue = 0;
$this->totalINTaxableMarketValue = 0;
$this->totalINTaxableAssessedValue = 0;
$this->totalMITaxableMarketValue = 0;
$this->totalMITaxableAssessedValue = 0;
$this->totalTITaxableMarketValue = 0;
$this->totalTITaxableAssessedValue = 0;
$this->totalSPTaxableMarketValue = 0;
$this->totalSPTaxableAssessedValue = 0;
$this->totalHOTaxableMarketValue = 0;
$this->totalHOTaxableAssessedValue = 0;
$this->totalSCTaxableMarketValue = 0;
$this->totalSCTaxableAssessedValue = 0;
$this->totalCUTaxableMarketValue = 0;
$this->totalCUTaxableAssessedValue = 0;
$this->totalOTTaxableMarketValue = 0;
$this->totalOTTaxableAssessedValue = 0;
$this->totalGOExemptMarketValue = 0;
$this->totalGOExemptAssessedValue = 0;
$this->totalRLExemptMarketValue = 0;
$this->totalRLExemptAssessedValue = 0;
$this->totalCHExemptMarketValue = 0;
$this->totalCHExemptAssessedValue = 0;
$this->totalEDExemptMarketValue = 0;
$this->totalEDExemptAssessedValue = 0;
$this->totalOTExemptMarketValue = 0;
$this->totalOTExemptAssessedValue = 0;
$this->totalTaxableRealPropertyUnits = 0;
$this->totalTaxableLandArea = 0;
$this->totalTaxableLandMarketValue = 0;
$this->totalTaxableLandAssessedValue = 0;
$this->totalTaxableBldgLessMarketValue = 0;
$this->totalTaxableBldgLessAssessedValue = 0;
$this->totalTaxableBldgOverMarketValue = 0;
$this->totalTaxableBldgOverAssessedValue = 0;
$this->totalTaxableMachMarketValue = 0;
$this->totalTaxableMachAssessedValue = 0;
$this->totalTaxableOtherMarketValue = 0;
$this->totalTaxableOtherAssessedValue = 0;
$this->totalTaxableMarketValue = 0;
$this->totalTaxableAssessedValue = 0;
$this->totalExemptRealPropertyUnits = 0;
$this->totalExemptLandArea = 0;
$this->totalExemptLandMarketValue = 0;
$this->totalExemptLandAssessedValue = 0;
$this->totalExemptBldgLessMarketValue = 0;
$this->totalExemptBldgLessAssessedValue = 0;
$this->totalExemptBldgOverMarketValue = 0;
$this->totalExemptBldgOverAssessedValue = 0;
$this->totalExemptMachMarketValue = 0;
$this->totalExemptMachAssessedValue = 0;
$this->totalExemptOtherMarketValue = 0;
$this->totalExemptOtherAssessedValue = 0;
$this->totalExemptMarketValue = 0;
$this->totalExemptAssessedValue = 0;
$this->totalRealPropertyUnits = 0;
$this->totalLandArea = 0;
$this->totalLandMarketValue = 0;
$this->totalLandAssessedValue = 0;
$this->totalBldgLessMarketValue = 0;
$this->totalBldgLessAssessedValue = 0;
$this->totalBldgOverMarketValue = 0;
$this->totalBldgOverAssessedValue = 0;
$this->totalMachMarketValue = 0;
$this->totalMachAssessedValue = 0;
$this->totalOtherMarketValue = 0;
$this->totalOtherAssessedValue = 0;
$this->totalMarketValue = 0;
$this->totalAssessedValue = 0;
$ctr = 1;
$this->dbs = "";
foreach ($DBid as $key => $value) {
$lgu = new LGU();
$lgu->selectRecord($value);
$this->dbName = $lgu->getLGUDB();
if ($ctr == 1) {
$this->dbs = $lgu->getLGUName();
} else {
$this->dbs .= " - " . $lgu->getLGUName();
}
$ctr++;
$sql = "SELECT a.reportCode as reportCode, b.actualUse, count(b.propertyID) as rpu, sum( b.assessedValue ) as assessedValue, sum( b.adjustedMarketValue ) as adjustedMarketValue, sum(area) as area" . " FROM LandActualUses a" . " LEFT JOIN Land b ON a.landActualUsesID = b.actualUse" . " GROUP BY a.reportCode;";
$this->computeProperty("Land", $sql);
$sql = "SELECT a.reportCode as reportCode, b.actualUse, count(b.propertyID), sum( b.assessedValue ) as assessedValue, sum( b.adjustedMarketValue ) as adjustedMarketValue" . " FROM ImprovementsBuildingsActualUses a" . " LEFT JOIN ImprovementsBuildings b ON a.improvementsBuildingsActualUsesID = b.actualUse AND b.adjustedMarketValue <= 175000" . " GROUP BY a.reportCode;";
$this->computeProperty("BldgLess", $sql);
$sql = "SELECT a.reportCode as reportCode, b.actualUse, count(b.propertyID), sum( b.assessedValue ) as assessedValue, sum( b.adjustedMarketValue ) as adjustedMarketValue" . " FROM ImprovementsBuildingsActualUses a" . " LEFT JOIN ImprovementsBuildings b ON a.improvementsBuildingsActualUsesID = b.actualUse AND b.adjustedMarketValue > 175000" . " GROUP BY a.reportCode;";
$this->computeProperty("BldgOver", $sql);
$sql = "SELECT a.reportCode as reportCode, b.actualUse, count(b.propertyID), sum( b.assessedValue ) as assessedValue, sum( b.adjustedMarketValue ) as adjustedMarketValue" . " FROM MachineriesActualUses a" . " LEFT JOIN Machineries b ON a.machineriesActualUsesID = b.actualUse" . " GROUP BY a.reportCode;";
$this->computeProperty("Mach", $sql);
$this->countRealPropertyUnits();
}
$this->tpl->set_var("RETaxable_RealPropertyUnits", number_format($this->subRETaxableRealPropertyUnits));
$this->tpl->set_var("RETaxable_LandArea", $this->checkNumericFormat($this->subRETaxableLandArea));
$this->tpl->set_var("AGTaxable_RealPropertyUnits", number_format($this->subAGTaxableRealPropertyUnits));
$this->tpl->set_var("AGTaxable_LandArea", $this->checkNumericFormat($this->subAGTaxableLandArea));
$this->tpl->set_var("COTaxable_RealPropertyUnits", number_format($this->subCOTaxableRealPropertyUnits));
$this->tpl->set_var("COTaxable_LandArea", $this->checkNumericFormat($this->subCOTaxableLandArea));
$this->tpl->set_var("INTaxable_RealPropertyUnits", number_format($this->subINTaxableRealPropertyUnits));
$this->tpl->set_var("INTaxable_LandArea", $this->checkNumericFormat($this->subINTaxableLandArea));
$this->tpl->set_var("MITaxable_RealPropertyUnits", number_format($this->subMITaxableRealPropertyUnits));
$this->tpl->set_var("MITaxable_LandArea", $this->checkNumericFormat($this->subMITaxableLandArea));
$this->tpl->set_var("TITaxable_RealPropertyUnits", number_format($this->subTITaxableRealPropertyUnits));
$this->tpl->set_var("TITaxable_LandArea", $this->checkNumericFormat($this->subTITaxableLandArea));
$this->tpl->set_var("SPTaxable_RealPropertyUnits", number_format($this->subSPTaxableRealPropertyUnits));
$this->tpl->set_var("SPTaxable_LandArea", $this->checkNumericFormat($this->subSPTaxableLandArea));
$this->tpl->set_var("HOTaxable_RealPropertyUnits", number_format($this->subHOTaxableRealPropertyUnits));
$this->tpl->set_var("HOTaxable_LandArea", $this->checkNumericFormat($this->subHOTaxableLandArea));
$this->tpl->set_var("SCTaxable_RealPropertyUnits", number_format($this->subSCTaxableRealPropertyUnits));
$this->tpl->set_var("SCTaxable_LandArea", $this->checkNumericFormat($this->subSCTaxableLandArea));
$this->tpl->set_var("CUTaxable_RealPropertyUnits", number_format($this->subCUTaxableRealPropertyUnits));
$this->tpl->set_var("CUTaxable_LandArea", $this->checkNumericFormat($this->subCUTaxableLandArea));
$this->tpl->set_var("OTTaxable_RealPropertyUnits", number_format($this->subOTTaxableRealPropertyUnits));
$this->tpl->set_var("OTTaxable_LandArea", $this->checkNumericFormat($this->subOTTaxableLandArea));
$this->tpl->set_var("GOExempt_RealPropertyUnits", number_format($this->subGOExemptRealPropertyUnits));
$this->tpl->set_var("GOExempt_LandArea", $this->checkNumericFormat($this->subGOExemptLandArea));
$this->tpl->set_var("RLExempt_RealPropertyUnits", number_format($this->subRLExemptRealPropertyUnits));
$this->tpl->set_var("RLExempt_LandArea", $this->checkNumericFormat($this->subRLExemptLandArea));
$this->tpl->set_var("CHExempt_RealPropertyUnits", number_format($this->subCHExemptRealPropertyUnits));
$this->tpl->set_var("CHExempt_LandArea", $this->checkNumericFormat($this->subCHExemptLandArea));
$this->tpl->set_var("EDExempt_RealPropertyUnits", number_format($this->subEDExemptRealPropertyUnits));
$this->tpl->set_var("EDExempt_LandArea", $this->checkNumericFormat($this->subEDExemptLandArea));
$this->tpl->set_var("OTExempt_RealPropertyUnits", number_format($this->subOTExemptRealPropertyUnits));
$this->tpl->set_var("OTExempt_LandArea", $this->checkNumericFormat($this->subOTExemptLandArea));
$this->tpl->set_var("RETaxable_LandMV", $this->checkNumericFormat($this->subRETaxableLandMarketValue));
$this->tpl->set_var("RETaxable_LandAV", $this->checkNumericFormat($this->subRETaxableLandAssessedValue));
$this->tpl->set_var("AGTaxable_LandMV", $this->checkNumericFormat($this->subAGTaxableLandMarketValue));
$this->tpl->set_var("AGTaxable_LandAV", $this->checkNumericFormat($this->subAGTaxableLandAssessedValue));
$this->tpl->set_var("COTaxable_LandMV", $this->checkNumericFormat($this->subCOTaxableLandMarketValue));
$this->tpl->set_var("COTaxable_LandAV", $this->checkNumericFormat($this->subCOTaxableLandAssessedValue));
$this->tpl->set_var("INTaxable_LandMV", $this->checkNumericFormat($this->subINTaxableLandMarketValue));
$this->tpl->set_var("INTaxable_LandAV", $this->checkNumericFormat($this->subINTaxableLandAssessedValue));
$this->tpl->set_var("MITaxable_LandMV", $this->checkNumericFormat($this->subMITaxableLandMarketValue));
$this->tpl->set_var("MITaxable_LandAV", $this->checkNumericFormat($this->subMITaxableLandAssessedValue));
$this->tpl->set_var("TITaxable_LandMV", $this->checkNumericFormat($this->subTITaxableLandMarketValue));
$this->tpl->set_var("TITaxable_LandAV", $this->checkNumericFormat($this->subTITaxableLandAssessedValue));
$this->tpl->set_var("SPTaxable_LandMV", $this->checkNumericFormat($this->subSPTaxableLandMarketValue));
$this->tpl->set_var("SPTaxable_LandAV", $this->checkNumericFormat($this->subSPTaxableLandAssessedValue));
$this->tpl->set_var("HOTaxable_LandMV", $this->checkNumericFormat($this->subHOTaxableLandMarketValue));
$this->tpl->set_var("HOTaxable_LandAV", $this->checkNumericFormat($this->subHOTaxableLandAssessedValue));
$this->tpl->set_var("SCTaxable_LandMV", $this->checkNumericFormat($this->subSCTaxableLandMarketValue));
$this->tpl->set_var("SCTaxable_LandAV", $this->checkNumericFormat($this->subSCTaxableLandAssessedValue));
$this->tpl->set_var("CUTaxable_LandMV", $this->checkNumericFormat($this->subCUTaxableLandMarketValue));
$this->tpl->set_var("CUTaxable_LandAV", $this->checkNumericFormat($this->subCUTaxableLandAssessedValue));
$this->tpl->set_var("OTTaxable_LandMV", $this->checkNumericFormat($this->subOTTaxableLandMarketValue));
$this->tpl->set_var("OTTaxable_LandAV", $this->checkNumericFormat($this->subOTTaxableLandAssessedValue));
$this->tpl->set_var("GOExempt_LandMV", $this->checkNumericFormat($this->subGOExemptLandMarketValue));
$this->tpl->set_var("GOExempt_LandAV", $this->checkNumericFormat($this->subGOExemptLandAssessedValue));
$this->tpl->set_var("RLExempt_LandMV", $this->checkNumericFormat($this->subRLExemptLandMarketValue));
$this->tpl->set_var("RLExempt_LandAV", $this->checkNumericFormat($this->subRLExemptLandAssessedValue));
$this->tpl->set_var("CHExempt_LandMV", $this->checkNumericFormat($this->subCHExemptLandMarketValue));
$this->tpl->set_var("CHExempt_LandAV", $this->checkNumericFormat($this->subCHExemptLandAssessedValue));
$this->tpl->set_var("EDExempt_LandMV", $this->checkNumericFormat($this->subEDExemptLandMarketValue));
$this->tpl->set_var("EDExempt_LandAV", $this->checkNumericFormat($this->subEDExemptLandAssessedValue));
$this->tpl->set_var("OTExempt_LandMV", $this->checkNumericFormat($this->subOTExemptLandMarketValue));
$this->tpl->set_var("OTExempt_LandAV", $this->checkNumericFormat($this->subOTExemptLandAssessedValue));
$this->tpl->set_var("RETaxable_BldgLessMV", $this->checkNumericFormat($this->subRETaxableBldgLessMarketValue));
$this->tpl->set_var("RETaxable_BldgLessAV", $this->checkNumericFormat($this->subRETaxableBldgLessAssessedValue));
$this->tpl->set_var("AGTaxable_BldgLessMV", $this->checkNumericFormat($this->subAGTaxableBldgLessMarketValue));
$this->tpl->set_var("AGTaxable_BldgLessAV", $this->checkNumericFormat($this->subAGTaxableBldgLessAssessedValue));
$this->tpl->set_var("COTaxable_BldgLessMV", $this->checkNumericFormat($this->subCOTaxableBldgLessMarketValue));
$this->tpl->set_var("COTaxable_BldgLessAV", $this->checkNumericFormat($this->subCOTaxableBldgLessAssessedValue));
$this->tpl->set_var("INTaxable_BldgLessMV", $this->checkNumericFormat($this->subINTaxableBldgLessMarketValue));
$this->tpl->set_var("INTaxable_BldgLessAV", $this->checkNumericFormat($this->subINTaxableBldgLessAssessedValue));
$this->tpl->set_var("MITaxable_BldgLessMV", $this->checkNumericFormat($this->subMITaxableBldgLessMarketValue));
$this->tpl->set_var("MITaxable_BldgLessAV", $this->checkNumericFormat($this->subMITaxableBldgLessAssessedValue));
$this->tpl->set_var("TITaxable_BldgLessMV", $this->checkNumericFormat($this->subTITaxableBldgLessMarketValue));
$this->tpl->set_var("TITaxable_BldgLessAV", $this->checkNumericFormat($this->subTITaxableBldgLessAssessedValue));
$this->tpl->set_var("SPTaxable_BldgLessMV", $this->checkNumericFormat($this->subSPTaxableBldgLessMarketValue));
$this->tpl->set_var("SPTaxable_BldgLessAV", $this->checkNumericFormat($this->subSPTaxableBldgLessAssessedValue));
$this->tpl->set_var("HOTaxable_BldgLessMV", $this->checkNumericFormat($this->subHOTaxableBldgLessMarketValue));
$this->tpl->set_var("HOTaxable_BldgLessAV", $this->checkNumericFormat($this->subHOTaxableBldgLessAssessedValue));
$this->tpl->set_var("SCTaxable_BldgLessMV", $this->checkNumericFormat($this->subSCTaxableBldgLessMarketValue));
$this->tpl->set_var("SCTaxable_BldgLessAV", $this->checkNumericFormat($this->subSCTaxableBldgLessAssessedValue));
$this->tpl->set_var("CUTaxable_BldgLessMV", $this->checkNumericFormat($this->subCUTaxableBldgLessMarketValue));
$this->tpl->set_var("CUTaxable_BldgLessAV", $this->checkNumericFormat($this->subCUTaxableBldgLessAssessedValue));
$this->tpl->set_var("OTTaxable_BldgLessMV", $this->checkNumericFormat($this->subOTTaxableBldgLessMarketValue));
$this->tpl->set_var("OTTaxable_BldgLessAV", $this->checkNumericFormat($this->subOTTaxableBldgLessAssessedValue));
$this->tpl->set_var("GOExempt_BldgLessMV", $this->checkNumericFormat($this->subGOExemptBldgLessMarketValue));
$this->tpl->set_var("GOExempt_BldgLessAV", $this->checkNumericFormat($this->subGOExemptBldgLessAssessedValue));
$this->tpl->set_var("RLExempt_BldgLessMV", $this->checkNumericFormat($this->subRLExemptBldgLessMarketValue));
$this->tpl->set_var("RLExempt_BldgLessAV", $this->checkNumericFormat($this->subRLExemptBldgLessAssessedValue));
$this->tpl->set_var("CHExempt_BldgLessMV", $this->checkNumericFormat($this->subCHExemptBldgLessMarketValue));
$this->tpl->set_var("CHExempt_BldgLessAV", $this->checkNumericFormat($this->subCHExemptBldgLessAssessedValue));
$this->tpl->set_var("EDExempt_BldgLessMV", $this->checkNumericFormat($this->subEDExemptBldgLessMarketValue));
$this->tpl->set_var("EDExempt_BldgLessAV", $this->checkNumericFormat($this->subEDExemptBldgLessAssessedValue));
$this->tpl->set_var("OTExempt_BldgLessMV", $this->checkNumericFormat($this->subOTExemptBldgLessMarketValue));
$this->tpl->set_var("OTExempt_BldgLessAV", $this->checkNumericFormat($this->subOTExemptBldgLessAssessedValue));
$this->tpl->set_var("RETaxable_BldgOverMV", $this->checkNumericFormat($this->subRETaxableBldgOverMarketValue));
$this->tpl->set_var("RETaxable_BldgOverAV", $this->checkNumericFormat($this->subRETaxableBldgOverAssessedValue));
$this->tpl->set_var("AGTaxable_BldgOverMV", $this->checkNumericFormat($this->subAGTaxableBldgOverMarketValue));
$this->tpl->set_var("AGTaxable_BldgOverAV", $this->checkNumericFormat($this->subAGTaxableBldgOverAssessedValue));
$this->tpl->set_var("COTaxable_BldgOverMV", $this->checkNumericFormat($this->subCOTaxableBldgOverMarketValue));
$this->tpl->set_var("COTaxable_BldgOverAV", $this->checkNumericFormat($this->subCOTaxableBldgOverAssessedValue));
$this->tpl->set_var("INTaxable_BldgOverMV", $this->checkNumericFormat($this->subINTaxableBldgOverMarketValue));
$this->tpl->set_var("INTaxable_BldgOverAV", $this->checkNumericFormat($this->subINTaxableBldgOverAssessedValue));
$this->tpl->set_var("MITaxable_BldgOverMV", $this->checkNumericFormat($this->subMITaxableBldgOverMarketValue));
$this->tpl->set_var("MITaxable_BldgOverAV", $this->checkNumericFormat($this->subMITaxableBldgOverAssessedValue));
$this->tpl->set_var("TITaxable_BldgOverMV", $this->checkNumericFormat($this->subTITaxableBldgOverMarketValue));
$this->tpl->set_var("TITaxable_BldgOverAV", $this->checkNumericFormat($this->subTITaxableBldgOverAssessedValue));
$this->tpl->set_var("SPTaxable_BldgOverMV", $this->checkNumericFormat($this->subSPTaxableBldgOverMarketValue));
$this->tpl->set_var("SPTaxable_BldgOverAV", $this->checkNumericFormat($this->subSPTaxableBldgOverAssessedValue));
$this->tpl->set_var("HOTaxable_BldgOverMV", $this->checkNumericFormat($this->subHOTaxableBldgOverMarketValue));
$this->tpl->set_var("HOTaxable_BldgOverAV", $this->checkNumericFormat($this->subHOTaxableBldgOverAssessedValue));
$this->tpl->set_var("SCTaxable_BldgOverMV", $this->checkNumericFormat($this->subSCTaxableBldgOverMarketValue));
$this->tpl->set_var("SCTaxable_BldgOverAV", $this->checkNumericFormat($this->subSCTaxableBldgOverAssessedValue));
$this->tpl->set_var("CUTaxable_BldgOverMV", $this->checkNumericFormat($this->subCUTaxableBldgOverMarketValue));
$this->tpl->set_var("CUTaxable_BldgOverAV", $this->checkNumericFormat($this->subCUTaxableBldgOverAssessedValue));
$this->tpl->set_var("OTTaxable_BldgOverMV", $this->checkNumericFormat($this->subOTTaxableBldgOverMarketValue));
$this->tpl->set_var("OTTaxable_BldgOverAV", $this->checkNumericFormat($this->subOTTaxableBldgOverAssessedValue));
$this->tpl->set_var("GOExempt_BldgOverMV", $this->checkNumericFormat($this->subGOExemptBldgOverMarketValue));
$this->tpl->set_var("GOExempt_BldgOverAV", $this->checkNumericFormat($this->subGOExemptBldgOverAssessedValue));
$this->tpl->set_var("RLExempt_BldgOverMV", $this->checkNumericFormat($this->subRLExemptBldgOverMarketValue));
$this->tpl->set_var("RLExempt_BldgOverAV", $this->checkNumericFormat($this->subRLExemptBldgOverAssessedValue));
$this->tpl->set_var("CHExempt_BldgOverMV", $this->checkNumericFormat($this->subCHExemptBldgOverMarketValue));
$this->tpl->set_var("CHExempt_BldgOverAV", $this->checkNumericFormat($this->subCHExemptBldgOverAssessedValue));
$this->tpl->set_var("EDExempt_BldgOverMV", $this->checkNumericFormat($this->subEDExemptBldgOverMarketValue));
$this->tpl->set_var("EDExempt_BldgOverAV", $this->checkNumericFormat($this->subEDExemptBldgOverAssessedValue));
$this->tpl->set_var("OTExempt_BldgOverMV", $this->checkNumericFormat($this->subOTExemptBldgOverMarketValue));
$this->tpl->set_var("OTExempt_BldgOverAV", $this->checkNumericFormat($this->subOTExemptBldgOverAssessedValue));
$this->tpl->set_var("RETaxable_MachMV", $this->checkNumericFormat($this->subRETaxableMachMarketValue));
$this->tpl->set_var("RETaxable_MachAV", $this->checkNumericFormat($this->subRETaxableMachAssessedValue));
$this->tpl->set_var("AGTaxable_MachMV", $this->checkNumericFormat($this->subAGTaxableMachMarketValue));
$this->tpl->set_var("AGTaxable_MachAV", $this->checkNumericFormat($this->subAGTaxableMachAssessedValue));
$this->tpl->set_var("COTaxable_MachMV", $this->checkNumericFormat($this->subCOTaxableMachMarketValue));
$this->tpl->set_var("COTaxable_MachAV", $this->checkNumericFormat($this->subCOTaxableMachAssessedValue));
$this->tpl->set_var("INTaxable_MachMV", $this->checkNumericFormat($this->subINTaxableMachMarketValue));
$this->tpl->set_var("INTaxable_MachAV", $this->checkNumericFormat($this->subINTaxableMachAssessedValue));
$this->tpl->set_var("MITaxable_MachMV", $this->checkNumericFormat($this->subMITaxableMachMarketValue));
$this->tpl->set_var("MITaxable_MachAV", $this->checkNumericFormat($this->subMITaxableMachAssessedValue));
$this->tpl->set_var("TITaxable_MachMV", $this->checkNumericFormat($this->subTITaxableMachMarketValue));
$this->tpl->set_var("TITaxable_MachAV", $this->checkNumericFormat($this->subTITaxableMachAssessedValue));
$this->tpl->set_var("SPTaxable_MachMV", $this->checkNumericFormat($this->subSPTaxableMachMarketValue));
$this->tpl->set_var("SPTaxable_MachAV", $this->checkNumericFormat($this->subSPTaxableMachAssessedValue));
$this->tpl->set_var("HOTaxable_MachMV", $this->checkNumericFormat($this->subHOTaxableMachMarketValue));
$this->tpl->set_var("HOTaxable_MachAV", $this->checkNumericFormat($this->subHOTaxableMachAssessedValue));
$this->tpl->set_var("SCTaxable_MachMV", $this->checkNumericFormat($this->subSCTaxableMachMarketValue));
$this->tpl->set_var("SCTaxable_MachAV", $this->checkNumericFormat($this->subSCTaxableMachAssessedValue));
$this->tpl->set_var("CUTaxable_MachMV", $this->checkNumericFormat($this->subCUTaxableMachMarketValue));
$this->tpl->set_var("CUTaxable_MachAV", $this->checkNumericFormat($this->subCUTaxableMachAssessedValue));
$this->tpl->set_var("OTTaxable_MachMV", $this->checkNumericFormat($this->subOTTaxableMachMarketValue));
$this->tpl->set_var("OTTaxable_MachAV", $this->checkNumericFormat($this->subOTTaxableMachAssessedValue));
$this->tpl->set_var("GOExempt_MachMV", $this->checkNumericFormat($this->subGOExemptMachMarketValue));
$this->tpl->set_var("GOExempt_MachAV", $this->checkNumericFormat($this->subGOExemptMachAssessedValue));
$this->tpl->set_var("RLExempt_MachMV", $this->checkNumericFormat($this->subRLExemptMachMarketValue));
$this->tpl->set_var("RLExempt_MachAV", $this->checkNumericFormat($this->subRLExemptMachAssessedValue));
$this->tpl->set_var("CHExempt_MachMV", $this->checkNumericFormat($this->subCHExemptMachMarketValue));
$this->tpl->set_var("CHExempt_MachAV", $this->checkNumericFormat($this->subCHExemptMachAssessedValue));
$this->tpl->set_var("EDExempt_MachMV", $this->checkNumericFormat($this->subEDExemptMachMarketValue));
$this->tpl->set_var("EDExempt_MachAV", $this->checkNumericFormat($this->subEDExemptMachAssessedValue));
$this->tpl->set_var("OTExempt_MachMV", $this->checkNumericFormat($this->subOTExemptMachMarketValue));
$this->tpl->set_var("OTExempt_MachAV", $this->checkNumericFormat($this->subOTExemptMachAssessedValue));
$this->tpl->set_var("RETaxable_OtherMV", $this->checkNumericFormat($this->subRETaxableOtherMarketValue));
$this->tpl->set_var("RETaxable_OtherAV", $this->checkNumericFormat($this->subRETaxableOtherAssessedValue));
$this->tpl->set_var("AGTaxable_OtherMV", $this->checkNumericFormat($this->subAGTaxableOtherMarketValue));
$this->tpl->set_var("AGTaxable_OtherAV", $this->checkNumericFormat($this->subAGTaxableOtherAssessedValue));
$this->tpl->set_var("COTaxable_OtherMV", $this->checkNumericFormat($this->subCOTaxableOtherMarketValue));
$this->tpl->set_var("COTaxable_OtherAV", $this->checkNumericFormat($this->subCOTaxableOtherAssessedValue));
$this->tpl->set_var("INTaxable_OtherMV", $this->checkNumericFormat($this->subINTaxableOtherMarketValue));
$this->tpl->set_var("INTaxable_OtherAV", $this->checkNumericFormat($this->subINTaxableOtherAssessedValue));
$this->tpl->set_var("MITaxable_OtherMV", $this->checkNumericFormat($this->subMITaxableOtherMarketValue));
$this->tpl->set_var("MITaxable_OtherAV", $this->checkNumericFormat($this->subMITaxableOtherAssessedValue));
$this->tpl->set_var("TITaxable_OtherMV", $this->checkNumericFormat($this->subTITaxableOtherMarketValue));
$this->tpl->set_var("TITaxable_OtherAV", $this->checkNumericFormat($this->subTITaxableOtherAssessedValue));
$this->tpl->set_var("SPTaxable_OtherMV", $this->checkNumericFormat($this->subSPTaxableOtherMarketValue));
$this->tpl->set_var("SPTaxable_OtherAV", $this->checkNumericFormat($this->subSPTaxableOtherAssessedValue));
$this->tpl->set_var("HOTaxable_OtherMV", $this->checkNumericFormat($this->subHOTaxableOtherMarketValue));
$this->tpl->set_var("HOTaxable_OtherAV", $this->checkNumericFormat($this->subHOTaxableOtherAssessedValue));
$this->tpl->set_var("SCTaxable_OtherMV", $this->checkNumericFormat($this->subSCTaxableOtherMarketValue));
$this->tpl->set_var("SCTaxable_OtherAV", $this->checkNumericFormat($this->subSCTaxableOtherAssessedValue));
$this->tpl->set_var("CUTaxable_OtherMV", $this->checkNumericFormat($this->subCUTaxableOtherMarketValue));
$this->tpl->set_var("CUTaxable_OtherAV", $this->checkNumericFormat($this->subCUTaxableOtherAssessedValue));
$this->tpl->set_var("OTTaxable_OtherMV", $this->checkNumericFormat($this->subOTTaxableOtherMarketValue));
$this->tpl->set_var("OTTaxable_OtherAV", $this->checkNumericFormat($this->subOTTaxableOtherAssessedValue));
$this->tpl->set_var("GOExempt_OtherMV", $this->checkNumericFormat($this->subGOExemptOtherMarketValue));
$this->tpl->set_var("GOExempt_OtherAV", $this->checkNumericFormat($this->subGOExemptOtherAssessedValue));
$this->tpl->set_var("RLExempt_OtherMV", $this->checkNumericFormat($this->subRLExemptOtherMarketValue));
$this->tpl->set_var("RLExempt_OtherAV", $this->checkNumericFormat($this->subRLExemptOtherAssessedValue));
$this->tpl->set_var("CHExempt_OtherMV", $this->checkNumericFormat($this->subCHExemptOtherMarketValue));
$this->tpl->set_var("CHExempt_OtherAV", $this->checkNumericFormat($this->subCHExemptOtherAssessedValue));
$this->tpl->set_var("EDExempt_OtherMV", $this->checkNumericFormat($this->subEDExemptOtherMarketValue));
$this->tpl->set_var("EDExempt_OtherAV", $this->checkNumericFormat($this->subEDExemptOtherAssessedValue));
$this->tpl->set_var("OTExempt_OtherMV", $this->checkNumericFormat($this->subOTExemptOtherMarketValue));
$this->tpl->set_var("OTExempt_OtherAV", $this->checkNumericFormat($this->subOTExemptOtherAssessedValue));
$this->tpl->set_var("RETaxable_TotalMV", $this->checkNumericFormat($this->totalRETaxableMarketValue));
$this->tpl->set_var("RETaxable_TotalAV", $this->checkNumericFormat($this->totalRETaxableAssessedValue));
$this->tpl->set_var("AGTaxable_TotalMV", $this->checkNumericFormat($this->totalAGTaxableMarketValue));
$this->tpl->set_var("AGTaxable_TotalAV", $this->checkNumericFormat($this->totalAGTaxableAssessedValue));
$this->tpl->set_var("COTaxable_TotalMV", $this->checkNumericFormat($this->totalCOTaxableMarketValue));
$this->tpl->set_var("COTaxable_TotalAV", $this->checkNumericFormat($this->totalCOTaxableAssessedValue));
$this->tpl->set_var("INTaxable_TotalMV", $this->checkNumericFormat($this->totalINTaxableMarketValue));
$this->tpl->set_var("INTaxable_TotalAV", $this->checkNumericFormat($this->totalINTaxableAssessedValue));
$this->tpl->set_var("MITaxable_TotalMV", $this->checkNumericFormat($this->totalMITaxableMarketValue));
$this->tpl->set_var("MITaxable_TotalAV", $this->checkNumericFormat($this->totalMITaxableAssessedValue));
$this->tpl->set_var("TITaxable_TotalMV", $this->checkNumericFormat($this->totalTITaxableMarketValue));
$this->tpl->set_var("TITaxable_TotalAV", $this->checkNumericFormat($this->totalTITaxableAssessedValue));
$this->tpl->set_var("SPTaxable_TotalMV", $this->checkNumericFormat($this->totalSPTaxableMarketValue));
$this->tpl->set_var("SPTaxable_TotalAV", $this->checkNumericFormat($this->totalSPTaxableAssessedValue));
$this->tpl->set_var("HOTaxable_TotalMV", $this->checkNumericFormat($this->totalHOTaxableMarketValue));
$this->tpl->set_var("HOTaxable_TotalAV", $this->checkNumericFormat($this->totalHOTaxableAssessedValue));
$this->tpl->set_var("SCTaxable_TotalMV", $this->checkNumericFormat($this->totalSCTaxableMarketValue));
$this->tpl->set_var("SCTaxable_TotalAV", $this->checkNumericFormat($this->totalSCTaxableAssessedValue));
$this->tpl->set_var("CUTaxable_TotalMV", $this->checkNumericFormat($this->totalCUTaxableMarketValue));
$this->tpl->set_var("CUTaxable_TotalAV", $this->checkNumericFormat($this->totalCUTaxableAssessedValue));
$this->tpl->set_var("OTTaxable_TotalMV", $this->checkNumericFormat($this->totalOTTaxableMarketValue));
$this->tpl->set_var("OTTaxable_TotalAV", $this->checkNumericFormat($this->totalOTTaxableAssessedValue));
$this->tpl->set_var("GOExempt_TotalMV", $this->checkNumericFormat($this->totalGOExemptMarketValue));
$this->tpl->set_var("GOExempt_TotalAV", $this->checkNumericFormat($this->totalGOExemptAssessedValue));
$this->tpl->set_var("RLExempt_TotalMV", $this->checkNumericFormat($this->totalRLExemptMarketValue));
$this->tpl->set_var("RLExempt_TotalAV", $this->checkNumericFormat($this->totalRLExemptAssessedValue));
$this->tpl->set_var("CHExempt_TotalMV", $this->checkNumericFormat($this->totalCHExemptMarketValue));
$this->tpl->set_var("CHExempt_TotalAV", $this->checkNumericFormat($this->totalCHExemptAssessedValue));
$this->tpl->set_var("EDExempt_TotalMV", $this->checkNumericFormat($this->totalEDExemptMarketValue));
$this->tpl->set_var("EDExempt_TotalAV", $this->checkNumericFormat($this->totalEDExemptAssessedValue));
$this->tpl->set_var("OTExempt_TotalMV", $this->checkNumericFormat($this->totalOTExemptMarketValue));
$this->tpl->set_var("OTExempt_TotalAV", $this->checkNumericFormat($this->totalOTExemptAssessedValue));
$this->tpl->set_var("Taxable_RealPropertyUnits", number_format($this->totalTaxableRealPropertyUnits));
$this->tpl->set_var("Taxable_LandArea", $this->checkNumericFormat($this->totalTaxableLandArea));
$this->tpl->set_var("Taxable_LandMV", $this->checkNumericFormat($this->totalTaxableLandMarketValue));
$this->tpl->set_var("Taxable_LandAV", $this->checkNumericFormat($this->totalTaxableLandAssessedValue));
$this->tpl->set_var("Taxable_BldgLessMV", $this->checkNumericFormat($this->totalTaxableBldgLessMarketValue));
$this->tpl->set_var("Taxable_BldgLessAV", $this->checkNumericFormat($this->totalTaxableBldgLessAssessedValue));
$this->tpl->set_var("Taxable_BldgOverMV", $this->checkNumericFormat($this->totalTaxableBldgOverMarketValue));
$this->tpl->set_var("Taxable_BldgOverAV", $this->checkNumericFormat($this->totalTaxableBldgOverAssessedValue));
$this->tpl->set_var("Taxable_MachMV", $this->checkNumericFormat($this->totalTaxableMachMarketValue));
$this->tpl->set_var("Taxable_MachAV", $this->checkNumericFormat($this->totalTaxableMachAssessedValue));
$this->tpl->set_var("Taxable_OtherMV", $this->checkNumericFormat($this->totalTaxableOtherMarketValue));
$this->tpl->set_var("Taxable_OtherAV", $this->checkNumericFormat($this->totalTaxableOtherAssessedValue));
$this->tpl->set_var("Taxable_TotalMV", $this->checkNumericFormat($this->totalTaxableMarketValue));
$this->tpl->set_var("Taxable_TotalAV", $this->checkNumericFormat($this->totalTaxableAssessedValue));
$this->tpl->set_var("Exempt_RealPropertyUnits", $this->checkNumericFormat($this->totalExemptRealPropertyUnits));
$this->tpl->set_var("Exempt_LandArea", $this->checkNumericFormat($this->totalExemptLandArea));
$this->tpl->set_var("Exempt_LandMV", $this->checkNumericFormat($this->totalExemptLandMarketValue));
$this->tpl->set_var("Exempt_LandAV", $this->checkNumericFormat($this->totalExemptLandAssessedValue));
$this->tpl->set_var("Exempt_BldgLessMV", $this->checkNumericFormat($this->totalExemptBldgLessMarketValue));
$this->tpl->set_var("Exempt_BldgLessAV", $this->checkNumericFormat($this->totalExemptBldgLessAssessedValue));
$this->tpl->set_var("Exempt_BldgOverMV", $this->checkNumericFormat($this->totalExemptBldgOverMarketValue));
$this->tpl->set_var("Exempt_BldgOverAV", $this->checkNumericFormat($this->totalExemptBldgOverAssessedValue));
$this->tpl->set_var("Exempt_MachMV", $this->checkNumericFormat($this->totalExemptMachMarketValue));
$this->tpl->set_var("Exempt_MachAV", $this->checkNumericFormat($this->totalExemptMachAssessedValue));
$this->tpl->set_var("Exempt_OtherMV", $this->checkNumericFormat($this->totalExemptOtherMarketValue));
$this->tpl->set_var("Exempt_OtherAV", $this->checkNumericFormat($this->totalExemptOtherAssessedValue));
$this->tpl->set_var("Exempt_TotalMV", $this->checkNumericFormat($this->totalExemptMarketValue));
$this->tpl->set_var("Exempt_TotalAV", $this->checkNumericFormat($this->totalExemptAssessedValue));
$this->tpl->set_var("TOTAL_RealPropertyUnits", number_format($this->totalRealPropertyUnits));
$this->tpl->set_var("TOTAL_LandArea", $this->checkNumericFormat($this->totalLandArea));
$this->tpl->set_var("TOTAL_LandMV", $this->checkNumericFormat($this->totalLandMarketValue));
$this->tpl->set_var("TOTAL_LandAV", $this->checkNumericFormat($this->totalLandAssessedValue));
$this->tpl->set_var("TOTAL_BldgLessMV", $this->checkNumericFormat($this->totalBldgLessMarketValue));
$this->tpl->set_var("TOTAL_BldgLessAV", $this->checkNumericFormat($this->totalBldgLessAssessedValue));
$this->tpl->set_var("TOTAL_BldgOverMV", $this->checkNumericFormat($this->totalBldgOverMarketValue));
$this->tpl->set_var("TOTAL_BldgOverAV", $this->checkNumericFormat($this->totalBldgOverAssessedValue));
$this->tpl->set_var("TOTAL_MachMV", $this->checkNumericFormat($this->totalMachMarketValue));
$this->tpl->set_var("TOTAL_MachAV", $this->checkNumericFormat($this->totalMachAssessedValue));
$this->tpl->set_var("TOTAL_OtherMV", $this->checkNumericFormat($this->totalOtherMarketValue));
$this->tpl->set_var("TOTAL_OtherAV", $this->checkNumericFormat($this->totalOtherAssessedValue));
$this->tpl->set_var("TOTAL_TotalMV", $this->checkNumericFormat($this->totalMarketValue));
$this->tpl->set_var("TOTAL_TotalAV", $this->checkNumericFormat($this->totalAssessedValue));
$treasurySettings = new TreasurySettings();
$treasurySettings->selectRecord();
$this->basicTaxRate = $treasurySettings->getPctRPTax() * 100;
$this->sefTaxRate = $treasurySettings->getPctSEF() * 100;
$this->rateOfLevy = $this->basicTaxRate + $this->sefTaxRate;
$this->taxableBasicCollectibles = 0;
$this->taxableSEFCollectibles = 0;
$this->totalBasicCollectibles = 0;
$this->totalSEFCollectibles = 0;
$this->reTaxableBasicCollectibles = $this->totalRETaxableAssessedValue * ($this->basicTaxRate / 100);
$this->reTaxableSEFCollectibles = $this->totalRETaxableAssessedValue * ($this->sefTaxRate / 100);
$this->taxableBasicCollectibles += $this->reTaxableBasicCollectibles;
$this->taxableSEFCollectibles += $this->reTaxableSEFCollectibles;
$this->totalBasicCollectibles += $this->reTaxableBasicCollectibles;
$this->totalSEFCollectibles += $this->reTaxableSEFCollectibles;
$this->tpl->set_var("RETaxable_RateOfLevy", $this->rateOfLevy . "%");
$this->tpl->set_var("RETaxable_BasicCollectibles", $this->checkNumericFormat($this->reTaxableBasicCollectibles));
$this->tpl->set_var("RETaxable_SEFCollectibles", $this->checkNumericFormat($this->reTaxableSEFCollectibles));
$this->agTaxableBasicCollectibles = $this->totalAGTaxableAssessedValue * ($this->basicTaxRate / 100);
$this->agTaxableSEFCollectibles = $this->totalAGTaxableAssessedValue * ($this->sefTaxRate / 100);
$this->taxableBasicCollectibles += $this->agTaxableBasicCollectibles;
$this->taxableSEFCollectibles += $this->agTaxableSEFCollectibles;
$this->totalBasicCollectibles += $this->agTaxableBasicCollectibles;
$this->totalSEFCollectibles += $this->agTaxableSEFCollectibles;
$this->tpl->set_var("AGTaxable_RateOfLevy", $this->rateOfLevy . "%");
$this->tpl->set_var("AGTaxable_BasicCollectibles", $this->checkNumericFormat($this->agTaxableBasicCollectibles));
$this->tpl->set_var("AGTaxable_SEFCollectibles", $this->checkNumericFormat($this->agTaxableSEFCollectibles));
$this->coTaxableBasicCollectibles = $this->totalCOTaxableAssessedValue * ($this->basicTaxRate / 100);
$this->coTaxableSEFCollectibles = $this->totalCOTaxableAssessedValue * ($this->sefTaxRate / 100);
$this->taxableBasicCollectibles += $this->coTaxableBasicCollectibles;
$this->taxableSEFCollectibles += $this->coTaxableSEFCollectibles;
$this->totalBasicCollectibles += $this->coTaxableBasicCollectibles;
$this->totalSEFCollectibles += $this->coTaxableSEFCollectibles;
$this->tpl->set_var("COTaxable_RateOfLevy", $this->rateOfLevy . "%");
$this->tpl->set_var("COTaxable_BasicCollectibles", $this->checkNumericFormat($this->coTaxableBasicCollectibles));
$this->tpl->set_var("COTaxable_SEFCollectibles", $this->checkNumericFormat($this->coTaxableSEFCollectibles));
$this->inTaxableBasicCollectibles = $this->totalINTaxableAssessedValue * ($this->basicTaxRate / 100);
$this->inTaxableSEFCollectibles = $this->totalINTaxableAssessedValue * ($this->sefTaxRate / 100);
$this->taxableBasicCollectibles += $this->inTaxableBasicCollectibles;
$this->taxableSEFCollectibles += $this->inTaxableSEFCollectibles;
$this->totalBasicCollectibles += $this->inTaxableBasicCollectibles;
$this->totalSEFCollectibles += $this->inTaxableSEFCollectibles;
$this->tpl->set_var("INTaxable_RateOfLevy", $this->rateOfLevy . "%");
$this->tpl->set_var("INTaxable_BasicCollectibles", $this->checkNumericFormat($this->inTaxableBasicCollectibles));
$this->tpl->set_var("INTaxable_SEFCollectibles", $this->checkNumericFormat($this->inTaxableSEFCollectibles));
$this->miTaxableBasicCollectibles = $this->totalMITaxableAssessedValue * ($this->basicTaxRate / 100);
$this->miTaxableSEFCollectibles = $this->totalMITaxableAssessedValue * ($this->sefTaxRate / 100);
$this->taxableBasicCollectibles += $this->miTaxableBasicCollectibles;
$this->taxableSEFCollectibles += $this->miTaxableSEFCollectibles;
$this->totalBasicCollectibles += $this->miTaxableBasicCollectibles;
$this->totalSEFCollectibles += $this->miTaxableSEFCollectibles;
$this->tpl->set_var("MITaxable_RateOfLevy", $this->rateOfLevy . "%");
$this->tpl->set_var("MITaxable_BasicCollectibles", $this->checkNumericFormat($this->miTaxableBasicCollectibles));
$this->tpl->set_var("MITaxable_SEFCollectibles", $this->checkNumericFormat($this->miTaxableSEFCollectibles));
$this->tiTaxableBasicCollectibles = $this->totalTITaxableAssessedValue * ($this->basicTaxRate / 100);
$this->tiTaxableSEFCollectibles = $this->totalTITaxableAssessedValue * ($this->sefTaxRate / 100);
$this->taxableBasicCollectibles += $this->tiTaxableBasicCollectibles;
$this->taxableSEFCollectibles += $this->tiTaxableSEFCollectibles;
$this->totalBasicCollectibles += $this->tiTaxableBasicCollectibles;
$this->totalSEFCollectibles += $this->tiTaxableSEFCollectibles;
$this->tpl->set_var("TITaxable_RateOfLevy", $this->rateOfLevy . "%");
$this->tpl->set_var("TITaxable_BasicCollectibles", $this->checkNumericFormat($this->tiTaxableBasicCollectibles));
$this->tpl->set_var("TITaxable_SEFCollectibles", $this->checkNumericFormat($this->tiTaxableSEFCollectibles));
$this->spTaxableBasicCollectibles = $this->totalSPTaxableAssessedValue * ($this->basicTaxRate / 100);
$this->spTaxableSEFCollectibles = $this->totalSPTaxableAssessedValue * ($this->sefTaxRate / 100);
$this->taxableBasicCollectibles += $this->spTaxableBasicCollectibles;
$this->taxableSEFCollectibles += $this->spTaxableSEFCollectibles;
$this->totalBasicCollectibles += $this->spTaxableBasicCollectibles;
$this->totalSEFCollectibles += $this->spTaxableSEFCollectibles;
$this->tpl->set_var("SPTaxable_RateOfLevy", $this->rateOfLevy . "%");
$this->tpl->set_var("SPTaxable_BasicCollectibles", $this->checkNumericFormat($this->spTaxableBasicCollectibles));
$this->tpl->set_var("SPTaxable_SEFCollectibles", $this->checkNumericFormat($this->spTaxableSEFCollectibles));
$this->hoTaxableBasicCollectibles = $this->totalHOTaxableAssessedValue * ($this->basicTaxRate / 100);
$this->hoTaxableSEFCollectibles = $this->totalHOTaxableAssessedValue * ($this->sefTaxRate / 100);
$this->taxableBasicCollectibles += $this->hoTaxableBasicCollectibles;
$this->taxableSEFCollectibles += $this->hoTaxableSEFCollectibles;
$this->totalBasicCollectibles += $this->hoTaxableBasicCollectibles;
$this->totalSEFCollectibles += $this->hoTaxableSEFCollectibles;
$this->tpl->set_var("HOTaxable_RateOfLevy", $this->rateOfLevy . "%");
$this->tpl->set_var("HOTaxable_BasicCollectibles", $this->checkNumericFormat($this->hoTaxableBasicCollectibles));
$this->tpl->set_var("HOTaxable_SEFCollectibles", $this->checkNumericFormat($this->hoTaxableSEFCollectibles));
$this->scTaxableBasicCollectibles = $this->totalSCTaxableAssessedValue * ($this->basicTaxRate / 100);
$this->scTaxableSEFCollectibles = $this->totalSCTaxableAssessedValue * ($this->sefTaxRate / 100);
$this->taxableBasicCollectibles += $this->scTaxableBasicCollectibles;
$this->taxableSEFCollectibles += $this->scTaxableSEFCollectibles;
$this->totalBasicCollectibles += $this->scTaxableBasicCollectibles;
$this->totalSEFCollectibles += $this->scTaxableSEFCollectibles;
$this->tpl->set_var("SCTaxable_RateOfLevy", $this->rateOfLevy . "%");
$this->tpl->set_var("SCTaxable_BasicCollectibles", $this->checkNumericFormat($this->scTaxableBasicCollectibles));
$this->tpl->set_var("SCTaxable_SEFCollectibles", $this->checkNumericFormat($this->scTaxableSEFCollectibles));
$this->cuTaxableBasicCollectibles = $this->totalCUTaxableAssessedValue * ($this->basicTaxRate / 100);
$this->cuTaxableSEFCollectibles = $this->totalCUTaxableAssessedValue * ($this->sefTaxRate / 100);
$this->taxableBasicCollectibles += $this->cuTaxableBasicCollectibles;
$this->taxableSEFCollectibles += $this->cuTaxableSEFCollectibles;
$this->totalBasicCollectibles += $this->cuTaxableBasicCollectibles;
$this->totalSEFCollectibles += $this->cuTaxableSEFCollectibles;
$this->tpl->set_var("CUTaxable_RateOfLevy", $this->rateOfLevy . "%");
$this->tpl->set_var("CUTaxable_BasicCollectibles", $this->checkNumericFormat($this->cuTaxableBasicCollectibles));
$this->tpl->set_var("CUTaxable_SEFCollectibles", $this->checkNumericFormat($this->cuTaxableSEFCollectibles));
$this->otTaxableBasicCollectibles = $this->totalOTTaxableAssessedValue * ($this->basicTaxRate / 100);
$this->otTaxableSEFCollectibles = $this->totalOTTaxableAssessedValue * ($this->sefTaxRate / 100);
$this->taxableBasicCollectibles += $this->otTaxableBasicCollectibles;
$this->taxableSEFCollectibles += $this->otTaxableSEFCollectibles;
$this->totalBasicCollectibles += $this->otTaxableBasicCollectibles;
$this->totalSEFCollectibles += $this->otTaxableSEFCollectibles;
$this->tpl->set_var("OTTaxable_RateOfLevy", $this->rateOfLevy . "%");
$this->tpl->set_var("OTTaxable_BasicCollectibles", $this->checkNumericFormat($this->otTaxableBasicCollectibles));
$this->tpl->set_var("OTTaxable_SEFCollectibles", $this->checkNumericFormat($this->otTaxableSEFCollectibles));
$this->taTaxableBasicCollectibles = $this->totalTaTaxableAssessedValue * ($this->basicTaxRate / 100);
$this->taTaxableSEFCollectibles = $this->totalTaTaxableAssessedValue * ($this->sefTaxRate / 100);
$this->taxableBasicCollectibles += $this->taTaxableBasicCollectibles;
$this->taxableSEFCollectibles += $this->taTaxableSEFCollectibles;
$this->totalBasicCollectibles += $this->taTaxableBasicCollectibles;
$this->totalSEFCollectibles += $this->taTaxableSEFCollectibles;
$this->tpl->set_var("TaTaxable_RateOfLevy", $this->rateOfLevy . "%");
$this->tpl->set_var("TaTaxable_BasicCollectibles", $this->checkNumericFormat($this->taTaxableBasicCollectibles));
$this->tpl->set_var("TaTaxable_SEFCollectibles", $this->checkNumericFormat($this->taTaxableSEFCollectibles));
$this->tpl->set_var("Taxable_RateOfLevy", $this->rateOfLevy . "%");
$this->tpl->set_var("Taxable_BasicCollectibles", $this->checkNumericFormat($this->taxableBasicCollectibles));
$this->tpl->set_var("Taxable_SEFCollectibles", $this->checkNumericFormat($this->taxableSEFCollectibles));
$this->tpl->set_var("TOTAL_RateOfLevy", $this->rateOfLevy . "%");
$this->tpl->set_var("TOTAL_BasicCollectibles", $this->checkNumericFormat($this->totalBasicCollectibles));
$this->tpl->set_var("TOTAL_SEFCollectibles", $this->checkNumericFormat($this->totalSEFCollectibles));
$this->setPageDetailPerms();
$this->tpl->set_var("dbs", $this->dbs);
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
if ($this->reportType == "HTML") {
$this->tpl->p("templatePage");
} else {
$testpdf = new PDFWriter();
$testpdf->setOutputXML($this->tpl->get("templatePage"), "test");
if (isset($this->formArray["print"])) {
$testpdf->writePDF($name);
//,$this->formArray["print"]);
} else {
$testpdf->writePDF($name);
}
}
}
function Main()
{
if (!is_array($this->formArray["DBid"])) {
exit("no LGUs selected");
} else {
foreach ($this->formArray["DBid"] as $dbID) {
$this->dbID = $dbID;
$lgu = new LGU();
$lgu->selectRecord($dbID);
$this->dbName = $lgu->getLGUDB();
$this->db = new DB_SelectLGU($this->dbName);
$this->displayPageHeading();
if ($this->paymentRecords = $this->getFilteredPaymentRecords()) {
// (modifed Dec. 08 but released on February 16, 2005)
// ff two lines commented out: December 08, 2004 in favor of getFilteredPaymentRecords for faster processing.
// if($this->paymentRecords = $this->filterPaymentsByCurrentQuarter()){
// if($this->paymentRecords = $this->filterPaymentsByLocationAndAssignPropertyClassification()){
if (is_array($this->paymentRecords->getArrayList())) {
$list = $this->paymentRecords->getArrayList();
foreach ($list as $payment) {
switch ($payment->getPropertyClassification()) {
case "RE":
$suffixKey = 1;
$this->incrementValues($suffixKey, $payment);
break;
case "AG":
$suffixKey = 2;
$this->incrementValues($suffixKey, $payment);
break;
case "CO":
$suffixKey = 3;
$this->incrementValues($suffixKey, $payment);
break;
case "IN":
$suffixKey = 4;
$this->incrementValues($suffixKey, $payment);
break;
case "MI":
$suffixKey = 5;
$this->incrementValues($suffixKey, $payment);
break;
case "TI":
$suffixKey = 6;
$this->incrementValues($suffixKey, $payment);
break;
case "SP":
$suffixKey = 7;
$this->incrementValues($suffixKey, $payment);
break;
case "HO":
$suffixKey = 8;
$this->incrementValues($suffixKey, $payment);
break;
case "SC":
$suffixKey = 9;
$this->incrementValues($suffixKey, $payment);
break;
case "CU":
$suffixKey = 10;
$this->incrementValues($suffixKey, $payment);
break;
case "CH":
case "ED":
case "GO":
case "OTX":
case "OTE":
case "RL":
default:
$suffixKey = 11;
$this->incrementValues($suffixKey, $payment);
break;
}
}
}
// }
}
}
}
$this->computeTotals();
$this->formatCurrencyFigures();
$this->setForm();
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$testpdf = new PDFWriter();
$testpdf->setOutputXML($this->tpl->get("templatePage"), "test");
if (isset($this->formArray["print"])) {
$testpdf->writePDF($name);
//,$this->formArray["print"]);
} else {
$testpdf->writePDF($name);
}
}
function Main()
{
global $DBid;
$this->tpl->set_var("Session", $this->sess->url(""));
$this->subRETaxableRealPropertyUnits = 0;
$this->subRETaxableLandArea = 0;
$this->subAGTaxableRealPropertyUnits = 0;
$this->subAGTaxableLandArea = 0;
$this->subCOTaxableRealPropertyUnits = 0;
$this->subCOTaxableLandArea = 0;
$this->subINTaxableRealPropertyUnits = 0;
$this->subINTaxableLandArea = 0;
$this->subMITaxableRealPropertyUnits = 0;
$this->subMITaxableLandArea = 0;
$this->subTITaxableRealPropertyUnits = 0;
$this->subTITaxableLandArea = 0;
$this->subSPTaxableRealPropertyUnits = 0;
$this->subSPTaxableLandArea = 0;
$this->subHOTaxableRealPropertyUnits = 0;
$this->subHOTaxableLandArea = 0;
$this->subSCTaxableRealPropertyUnits = 0;
$this->subSCTaxableLandArea = 0;
$this->subCUTaxableRealPropertyUnits = 0;
$this->subCUTaxableLandArea = 0;
$this->subOTTaxableRealPropertyUnits = 0;
$this->subOTTaxableLandArea = 0;
$this->subGOExemptRealPropertyUnits = 0;
$this->subGOExemptLandArea = 0;
$this->subRLExemptRealPropertyUnits = 0;
$this->subRLExemptLandArea = 0;
$this->subCHExemptRealPropertyUnits = 0;
$this->subCHExemptLandArea = 0;
$this->subEDExemptRealPropertyUnits = 0;
$this->subEDExemptLandArea = 0;
$this->subOTExemptRealPropertyUnits = 0;
$this->subOTExemptLandArea = 0;
$this->subRETaxableLandMarketValue = 0;
$this->subRETaxableLandAssessedValue = 0;
$this->subAGTaxableLandMarketValue = 0;
$this->subAGTaxableLandAssessedValue = 0;
$this->subCOTaxableLandMarketValue = 0;
$this->subCOTaxableLandAssessedValue = 0;
$this->subINTaxableLandMarketValue = 0;
$this->subINTaxableLandAssessedValue = 0;
$this->subMITaxableLandMarketValue = 0;
$this->subMITaxableLandAssessedValue = 0;
$this->subTITaxableLandMarketValue = 0;
$this->subTITaxableLandAssessedValue = 0;
$this->subSPTaxableLandMarketValue = 0;
$this->subSPTaxableLandAssessedValue = 0;
$this->subHOTaxableLandMarketValue = 0;
$this->subHOTaxableLandAssessedValue = 0;
$this->subSCTaxableLandMarketValue = 0;
$this->subSCTaxableLandAssessedValue = 0;
$this->subCUTaxableLandMarketValue = 0;
$this->subCUTaxableLandAssessedValue = 0;
$this->subOTTaxableLandMarketValue = 0;
$this->subOTTaxableLandAssessedValue = 0;
$this->subGOExemptLandMarketValue = 0;
$this->subGOExemptLandAssessedValue = 0;
$this->subRLExemptLandMarketValue = 0;
$this->subRLExemptLandAssessedValue = 0;
$this->subCHExemptLandMarketValue = 0;
$this->subCHExemptLandAssessedValue = 0;
$this->subEDExemptLandMarketValue = 0;
$this->subEDExemptLandAssessedValue = 0;
$this->subOTExemptLandMarketValue = 0;
$this->subOTExemptLandAssessedValue = 0;
$this->subRETaxableBldgLessMarketValue = 0;
$this->subRETaxableBldgLessAssessedValue = 0;
$this->subAGTaxableBldgLessMarketValue = 0;
$this->subAGTaxableBldgLessAssessedValue = 0;
$this->subCOTaxableBldgLessMarketValue = 0;
$this->subCOTaxableBldgLessAssessedValue = 0;
$this->subINTaxableBldgLessMarketValue = 0;
$this->subINTaxableBldgLessAssessedValue = 0;
$this->subMITaxableBldgLessMarketValue = 0;
$this->subMITaxableBldgLessAssessedValue = 0;
$this->subTITaxableBldgLessMarketValue = 0;
$this->subTITaxableBldgLessAssessedValue = 0;
$this->subSPTaxableBldgLessMarketValue = 0;
$this->subSPTaxableBldgLessAssessedValue = 0;
$this->subHOTaxableBldgLessMarketValue = 0;
$this->subHOTaxableBldgLessAssessedValue = 0;
$this->subSCTaxableBldgLessMarketValue = 0;
$this->subSCTaxableBldgLessAssessedValue = 0;
$this->subCUTaxableBldgLessMarketValue = 0;
$this->subCUTaxableBldgLessAssessedValue = 0;
$this->subOTTaxableBldgLessMarketValue = 0;
$this->subOTTaxableBldgLessAssessedValue = 0;
$this->subGOExemptBldgLessMarketValue = 0;
$this->subGOExemptBldgLessAssessedValue = 0;
$this->subRLExemptBldgLessMarketValue = 0;
$this->subRLExemptBldgLessAssessedValue = 0;
$this->subCHExemptBldgLessMarketValue = 0;
$this->subCHExemptBldgLessAssessedValue = 0;
$this->subEDExemptBldgLessMarketValue = 0;
$this->subEDExemptBldgLessAssessedValue = 0;
$this->subOTExemptBldgLessMarketValue = 0;
$this->subOTExemptBldgLessAssessedValue = 0;
$this->subRETaxableBldgOverMarketValue = 0;
$this->subRETaxableBldgOverAssessedValue = 0;
$this->subAGTaxableBldgOverMarketValue = 0;
$this->subAGTaxableBldgOverAssessedValue = 0;
$this->subCOTaxableBldgOverMarketValue = 0;
$this->subCOTaxableBldgOverAssessedValue = 0;
$this->subINTaxableBldgOverMarketValue = 0;
$this->subINTaxableBldgOverAssessedValue = 0;
$this->subMITaxableBldgOverMarketValue = 0;
$this->subMITaxableBldgOverAssessedValue = 0;
$this->subTITaxableBldgOverMarketValue = 0;
$this->subTITaxableBldgOverAssessedValue = 0;
$this->subSPTaxableBldgOverMarketValue = 0;
$this->subSPTaxableBldgOverAssessedValue = 0;
$this->subHOTaxableBldgOverMarketValue = 0;
$this->subHOTaxableBldgOverAssessedValue = 0;
$this->subSCTaxableBldgOverMarketValue = 0;
$this->subSCTaxableBldgOverAssessedValue = 0;
$this->subCUTaxableBldgOverMarketValue = 0;
$this->subCUTaxableBldgOverAssessedValue = 0;
$this->subOTTaxableBldgOverMarketValue = 0;
$this->subOTTaxableBldgOverAssessedValue = 0;
$this->subGOExemptBldgOverMarketValue = 0;
$this->subGOExemptBldgOverAssessedValue = 0;
$this->subRLExemptBldgOverMarketValue = 0;
$this->subRLExemptBldgOverAssessedValue = 0;
$this->subCHExemptBldgOverMarketValue = 0;
$this->subCHExemptBldgOverAssessedValue = 0;
$this->subEDExemptBldgOverMarketValue = 0;
$this->subEDExemptBldgOverAssessedValue = 0;
$this->subOTExemptBldgOverMarketValue = 0;
$this->subOTExemptBldgOverAssessedValue = 0;
$this->subRETaxableMachMarketValue = 0;
$this->subRETaxableMachAssessedValue = 0;
$this->subAGTaxableMachMarketValue = 0;
$this->subAGTaxableMachAssessedValue = 0;
$this->subCOTaxableMachMarketValue = 0;
$this->subCOTaxableMachAssessedValue = 0;
$this->subINTaxableMachMarketValue = 0;
$this->subINTaxableMachAssessedValue = 0;
$this->subMITaxableMachMarketValue = 0;
$this->subMITaxableMachAssessedValue = 0;
$this->subTITaxableMachMarketValue = 0;
$this->subTITaxableMachAssessedValue = 0;
$this->subSPTaxableMachMarketValue = 0;
$this->subSPTaxableMachAssessedValue = 0;
$this->subHOTaxableMachMarketValue = 0;
$this->subHOTaxableMachAssessedValue = 0;
$this->subSCTaxableMachMarketValue = 0;
$this->subSCTaxableMachAssessedValue = 0;
$this->subCUTaxableMachMarketValue = 0;
$this->subCUTaxableMachAssessedValue = 0;
$this->subOTTaxableMachMarketValue = 0;
$this->subOTTaxableMachAssessedValue = 0;
$this->subGOExemptMachMarketValue = 0;
$this->subGOExemptMachAssessedValue = 0;
$this->subRLExemptMachMarketValue = 0;
$this->subRLExemptMachAssessedValue = 0;
$this->subCHExemptMachMarketValue = 0;
$this->subCHExemptMachAssessedValue = 0;
$this->subEDExemptMachMarketValue = 0;
$this->subEDExemptMachAssessedValue = 0;
$this->subOTExemptMachMarketValue = 0;
$this->subOTExemptMachAssessedValue = 0;
$this->subRETaxableOtherMarketValue = 0;
$this->subRETaxableOtherAssessedValue = 0;
$this->subAGTaxableOtherMarketValue = 0;
$this->subAGTaxableOtherAssessedValue = 0;
$this->subCOTaxableOtherMarketValue = 0;
$this->subCOTaxableOtherAssessedValue = 0;
$this->subINTaxableOtherMarketValue = 0;
$this->subINTaxableOtherAssessedValue = 0;
$this->subMITaxableOtherMarketValue = 0;
$this->subMITaxableOtherAssessedValue = 0;
$this->subTITaxableOtherMarketValue = 0;
$this->subTITaxableOtherAssessedValue = 0;
$this->subSPTaxableOtherMarketValue = 0;
$this->subSPTaxableOtherAssessedValue = 0;
$this->subHOTaxableOtherMarketValue = 0;
$this->subHOTaxableOtherAssessedValue = 0;
$this->subSCTaxableOtherMarketValue = 0;
$this->subSCTaxableOtherAssessedValue = 0;
$this->subCUTaxableOtherMarketValue = 0;
$this->subCUTaxableOtherAssessedValue = 0;
$this->subOTTaxableOtherMarketValue = 0;
$this->subOTTaxableOtherAssessedValue = 0;
$this->subGOExemptOtherMarketValue = 0;
$this->subGOExemptOtherAssessedValue = 0;
$this->subRLExemptOtherMarketValue = 0;
$this->subRLExemptOtherAssessedValue = 0;
$this->subCHExemptOtherMarketValue = 0;
$this->subCHExemptOtherAssessedValue = 0;
$this->subEDExemptOtherMarketValue = 0;
$this->subEDExemptOtherAssessedValue = 0;
$this->subOTExemptOtherMarketValue = 0;
$this->subOTExemptOtherAssessedValue = 0;
$this->totalRETaxableMarketValue = 0;
$this->totalRETaxableAssessedValue = 0;
$this->totalAGTaxableMarketValue = 0;
$this->totalAGTaxableAssessedValue = 0;
$this->totalCOTaxableMarketValue = 0;
$this->totalCOTaxableAssessedValue = 0;
$this->totalINTaxableMarketValue = 0;
$this->totalINTaxableAssessedValue = 0;
$this->totalMITaxableMarketValue = 0;
$this->totalMITaxableAssessedValue = 0;
$this->totalTITaxableMarketValue = 0;
$this->totalTITaxableAssessedValue = 0;
$this->totalSPTaxableMarketValue = 0;
$this->totalSPTaxableAssessedValue = 0;
$this->totalHOTaxableMarketValue = 0;
$this->totalHOTaxableAssessedValue = 0;
$this->totalSCTaxableMarketValue = 0;
$this->totalSCTaxableAssessedValue = 0;
$this->totalCUTaxableMarketValue = 0;
$this->totalCUTaxableAssessedValue = 0;
$this->totalOTTaxableMarketValue = 0;
$this->totalOTTaxableAssessedValue = 0;
$this->totalGOExemptMarketValue = 0;
$this->totalGOExemptAssessedValue = 0;
$this->totalRLExemptMarketValue = 0;
$this->totalRLExemptAssessedValue = 0;
$this->totalCHExemptMarketValue = 0;
$this->totalCHExemptAssessedValue = 0;
$this->totalEDExemptMarketValue = 0;
$this->totalEDExemptAssessedValue = 0;
$this->totalOTExemptMarketValue = 0;
$this->totalOTExemptAssessedValue = 0;
$this->totalTaxableRealPropertyUnits = 0;
$this->totalTaxableLandArea = 0;
$this->totalTaxableLandMarketValue = 0;
$this->totalTaxableLandAssessedValue = 0;
$this->totalTaxableBldgLessMarketValue = 0;
$this->totalTaxableBldgLessAssessedValue = 0;
$this->totalTaxableBldgOverMarketValue = 0;
$this->totalTaxableBldgOverAssessedValue = 0;
$this->totalTaxableMachMarketValue = 0;
$this->totalTaxableMachAssessedValue = 0;
$this->totalTaxableOtherMarketValue = 0;
$this->totalTaxableOtherAssessedValue = 0;
$this->totalTaxableMarketValue = 0;
$this->totalTaxableAssessedValue = 0;
$this->totalExemptRealPropertyUnits = 0;
$this->totalExemptLandArea = 0;
$this->totalExemptLandMarketValue = 0;
$this->totalExemptLandAssessedValue = 0;
$this->totalExemptBldgLessMarketValue = 0;
$this->totalExemptBldgLessAssessedValue = 0;
$this->totalExemptBldgOverMarketValue = 0;
$this->totalExemptBldgOverAssessedValue = 0;
$this->totalExemptMachMarketValue = 0;
$this->totalExemptMachAssessedValue = 0;
$this->totalExemptOtherMarketValue = 0;
$this->totalExemptOtherAssessedValue = 0;
$this->totalExemptMarketValue = 0;
$this->totalExemptAssessedValue = 0;
$this->totalRealPropertyUnits = 0;
$this->totalLandArea = 0;
$this->totalLandMarketValue = 0;
$this->totalLandAssessedValue = 0;
$this->totalBldgLessMarketValue = 0;
$this->totalBldgLessAssessedValue = 0;
$this->totalBldgOverMarketValue = 0;
$this->totalBldgOverAssessedValue = 0;
$this->totalMachMarketValue = 0;
$this->totalMachAssessedValue = 0;
$this->totalOtherMarketValue = 0;
$this->totalOtherAssessedValue = 0;
$this->totalMarketValue = 0;
$this->totalAssessedValue = 0;
$this->tpl->set_block("rptsTemplate", "DBList", "DBListBlock");
$ctr = 1;
foreach ($DBid as $key => $value) {
$lgu = new LGU();
$lgu->selectRecord($value);
$this->dbName = $lgu->getLGUDB();
if ($ctr == 1) {
$this->tpl->set_var("dbs", $lgu->getLGUName());
} else {
$this->tpl->set_var("dbs", " - " . $lgu->getLGUName());
}
$this->tpl->parse("DBListBlock", "DBList", true);
$ctr++;
$sql = "SELECT a.code, b.actualUse, count(b.propertyID) as rpu, sum( b.assessedValue ) as assessedValue, sum( b.marketValue ) as marketValue, sum(area) as area" . " FROM LandActualUses a" . " LEFT JOIN Land b ON a.landActualUsesID = b.actualUse" . " GROUP BY a.code;";
$this->computeProperty("Land", $sql);
$sql = "SELECT a.code, b.actualUse, count(b.propertyID), sum( b.assessedValue ) as assessedValue, sum( b.marketValue ) as marketValue" . " FROM ImprovementsBuildingsActualUses a" . " LEFT JOIN ImprovementsBuildings b ON a.improvementsBuildingsActualUsesID = b.actualUse AND b.marketValue <= 175000 AND b.assessedValue <= 175000" . " GROUP BY a.code;";
$this->computeProperty("BldgLess", $sql);
$sql = "SELECT a.code, b.actualUse, count(b.propertyID), sum( b.assessedValue ) as assessedValue, sum( b.marketValue ) as marketValue" . " FROM ImprovementsBuildingsActualUses a" . " LEFT JOIN ImprovementsBuildings b ON a.improvementsBuildingsActualUsesID = b.actualUse AND b.marketValue > 175000 AND b.assessedValue > 175000" . " GROUP BY a.code;";
$this->computeProperty("BldgOver", $sql);
$sql = "SELECT a.code, b.actualUse, count(b.propertyID), sum( b.assessedValue ) as assessedValue, sum( b.marketValue ) as marketValue" . " FROM MachineriesActualUses a" . " LEFT JOIN Machineries b ON a.machineriesActualUsesID = b.actualUse" . " GROUP BY a.code;";
$this->computeProperty("Mach", $sql);
}
$this->tpl->set_var("RETaxable_RealPropertyUnits", $this->checkNumericFormat($this->subRETaxableRealPropertyUnits));
$this->tpl->set_var("RETaxable_LandArea", $this->checkNumericFormat($this->subRETaxableLandArea));
$this->tpl->set_var("AGTaxable_RealPropertyUnits", $this->checkNumericFormat($this->subAGTaxableRealPropertyUnits));
$this->tpl->set_var("AGTaxable_LandArea", $this->checkNumericFormat($this->subAGTaxableLandArea));
$this->tpl->set_var("COTaxable_RealPropertyUnits", $this->checkNumericFormat($this->subCOTaxableRealPropertyUnits));
$this->tpl->set_var("COTaxable_LandArea", $this->checkNumericFormat($this->subCOTaxableLandArea));
$this->tpl->set_var("INTaxable_RealPropertyUnits", $this->checkNumericFormat($this->subINTaxableRealPropertyUnits));
$this->tpl->set_var("INTaxable_LandArea", $this->checkNumericFormat($this->subINTaxableLandArea));
$this->tpl->set_var("MITaxable_RealPropertyUnits", $this->checkNumericFormat($this->subMITaxableRealPropertyUnits));
$this->tpl->set_var("MITaxable_LandArea", $this->checkNumericFormat($this->subMITaxableLandArea));
$this->tpl->set_var("TITaxable_RealPropertyUnits", $this->checkNumericFormat($this->subTITaxableRealPropertyUnits));
$this->tpl->set_var("TITaxable_LandArea", $this->checkNumericFormat($this->subTITaxableLandArea));
$this->tpl->set_var("SPTaxable_RealPropertyUnits", $this->checkNumericFormat($this->subSPTaxableRealPropertyUnits));
$this->tpl->set_var("SPTaxable_LandArea", $this->checkNumericFormat($this->subSPTaxableLandArea));
$this->tpl->set_var("HOTaxable_RealPropertyUnits", $this->checkNumericFormat($this->subHOTaxableRealPropertyUnits));
$this->tpl->set_var("HOTaxable_LandArea", $this->checkNumericFormat($this->subHOTaxableLandArea));
$this->tpl->set_var("SCTaxable_RealPropertyUnits", $this->checkNumericFormat($this->subSCTaxableRealPropertyUnits));
$this->tpl->set_var("SCTaxable_LandArea", $this->checkNumericFormat($this->subSCTaxableLandArea));
$this->tpl->set_var("CUTaxable_RealPropertyUnits", $this->checkNumericFormat($this->subCUTaxableRealPropertyUnits));
$this->tpl->set_var("CUTaxable_LandArea", $this->checkNumericFormat($this->subCUTaxableLandArea));
$this->tpl->set_var("OTTaxable_RealPropertyUnits", $this->checkNumericFormat($this->subOTTaxableRealPropertyUnits));
$this->tpl->set_var("OTTaxable_LandArea", $this->checkNumericFormat($this->subOTTaxableLandArea));
$this->tpl->set_var("GOExempt_RealPropertyUnits", $this->checkNumericFormat($this->subGOExemptRealPropertyUnits));
$this->tpl->set_var("GOExempt_LandArea", $this->checkNumericFormat($this->subGOExemptLandArea));
$this->tpl->set_var("RLExempt_RealPropertyUnits", $this->checkNumericFormat($this->subRLExemptRealPropertyUnits));
$this->tpl->set_var("RLExempt_LandArea", $this->checkNumericFormat($this->subRLExemptLandArea));
$this->tpl->set_var("CHExempt_RealPropertyUnits", $this->checkNumericFormat($this->subCHExemptRealPropertyUnits));
$this->tpl->set_var("CHExempt_LandArea", $this->checkNumericFormat($this->subCHExemptLandArea));
$this->tpl->set_var("EDExempt_RealPropertyUnits", $this->checkNumericFormat($this->subEDExemptRealPropertyUnits));
$this->tpl->set_var("EDExempt_LandArea", $this->checkNumericFormat($this->subEDExemptLandArea));
$this->tpl->set_var("OTExempt_RealPropertyUnits", $this->checkNumericFormat($this->subOTExemptRealPropertyUnits));
$this->tpl->set_var("OTExempt_LandArea", $this->checkNumericFormat($this->subOTExemptLandArea));
$this->tpl->set_var("RETaxable_LandMV", $this->checkNumericFormat($this->subRETaxableLandMarketValue));
$this->tpl->set_var("RETaxable_LandAV", $this->checkNumericFormat($this->subRETaxableLandAssessedValue));
$this->tpl->set_var("AGTaxable_LandMV", $this->checkNumericFormat($this->subAGTaxableLandMarketValue));
$this->tpl->set_var("AGTaxable_LandAV", $this->checkNumericFormat($this->subAGTaxableLandAssessedValue));
$this->tpl->set_var("COTaxable_LandMV", $this->checkNumericFormat($this->subCOTaxableLandMarketValue));
$this->tpl->set_var("COTaxable_LandAV", $this->checkNumericFormat($this->subCOTaxableLandAssessedValue));
$this->tpl->set_var("INTaxable_LandMV", $this->checkNumericFormat($this->subINTaxableLandMarketValue));
$this->tpl->set_var("INTaxable_LandAV", $this->checkNumericFormat($this->subINTaxableLandAssessedValue));
$this->tpl->set_var("MITaxable_LandMV", $this->checkNumericFormat($this->subMITaxableLandMarketValue));
$this->tpl->set_var("MITaxable_LandAV", $this->checkNumericFormat($this->subMITaxableLandAssessedValue));
$this->tpl->set_var("TITaxable_LandMV", $this->checkNumericFormat($this->subTITaxableLandMarketValue));
$this->tpl->set_var("TITaxable_LandAV", $this->checkNumericFormat($this->subTITaxableLandAssessedValue));
$this->tpl->set_var("SPTaxable_LandMV", $this->checkNumericFormat($this->subSPTaxableLandMarketValue));
$this->tpl->set_var("SPTaxable_LandAV", $this->checkNumericFormat($this->subSPTaxableLandAssessedValue));
$this->tpl->set_var("HOTaxable_LandMV", $this->checkNumericFormat($this->subHOTaxableLandMarketValue));
$this->tpl->set_var("HOTaxable_LandAV", $this->checkNumericFormat($this->subHOTaxableLandAssessedValue));
$this->tpl->set_var("SCTaxable_LandMV", $this->checkNumericFormat($this->subSCTaxableLandMarketValue));
$this->tpl->set_var("SCTaxable_LandAV", $this->checkNumericFormat($this->subSCTaxableLandAssessedValue));
$this->tpl->set_var("CUTaxable_LandMV", $this->checkNumericFormat($this->subCUTaxableLandMarketValue));
$this->tpl->set_var("CUTaxable_LandAV", $this->checkNumericFormat($this->subCUTaxableLandAssessedValue));
$this->tpl->set_var("OTTaxable_LandMV", $this->checkNumericFormat($this->subOTTaxableLandMarketValue));
$this->tpl->set_var("OTTaxable_LandAV", $this->checkNumericFormat($this->subOTTaxableLandAssessedValue));
$this->tpl->set_var("GOExempt_LandMV", $this->checkNumericFormat($this->subGOExemptLandMarketValue));
$this->tpl->set_var("GOExempt_LandAV", $this->checkNumericFormat($this->subGOExemptLandAssessedValue));
$this->tpl->set_var("RLExempt_LandMV", $this->checkNumericFormat($this->subRLExemptLandMarketValue));
$this->tpl->set_var("RLExempt_LandAV", $this->checkNumericFormat($this->subRLExemptLandAssessedValue));
$this->tpl->set_var("CHExempt_LandMV", $this->checkNumericFormat($this->subCHExemptLandMarketValue));
$this->tpl->set_var("CHExempt_LandAV", $this->checkNumericFormat($this->subCHExemptLandAssessedValue));
$this->tpl->set_var("EDExempt_LandMV", $this->checkNumericFormat($this->subEDExemptLandMarketValue));
$this->tpl->set_var("EDExempt_LandAV", $this->checkNumericFormat($this->subEDExemptLandAssessedValue));
$this->tpl->set_var("OTExempt_LandMV", $this->checkNumericFormat($this->subOTExemptLandMarketValue));
$this->tpl->set_var("OTExempt_LandAV", $this->checkNumericFormat($this->subOTExemptLandAssessedValue));
$this->tpl->set_var("RETaxable_BldgLessMV", $this->checkNumericFormat($this->subRETaxableBldgLessMarketValue));
$this->tpl->set_var("RETaxable_BldgLessAV", $this->checkNumericFormat($this->subRETaxableBldgLessAssessedValue));
$this->tpl->set_var("AGTaxable_BldgLessMV", $this->checkNumericFormat($this->subAGTaxableBldgLessMarketValue));
$this->tpl->set_var("AGTaxable_BldgLessAV", $this->checkNumericFormat($this->subAGTaxableBldgLessAssessedValue));
$this->tpl->set_var("COTaxable_BldgLessMV", $this->checkNumericFormat($this->subCOTaxableBldgLessMarketValue));
$this->tpl->set_var("COTaxable_BldgLessAV", $this->checkNumericFormat($this->subCOTaxableBldgLessAssessedValue));
$this->tpl->set_var("INTaxable_BldgLessMV", $this->checkNumericFormat($this->subINTaxableBldgLessMarketValue));
$this->tpl->set_var("INTaxable_BldgLessAV", $this->checkNumericFormat($this->subINTaxableBldgLessAssessedValue));
$this->tpl->set_var("MITaxable_BldgLessMV", $this->checkNumericFormat($this->subMITaxableBldgLessMarketValue));
$this->tpl->set_var("MITaxable_BldgLessAV", $this->checkNumericFormat($this->subMITaxableBldgLessAssessedValue));
$this->tpl->set_var("TITaxable_BldgLessMV", $this->checkNumericFormat($this->subTITaxableBldgLessMarketValue));
$this->tpl->set_var("TITaxable_BldgLessAV", $this->checkNumericFormat($this->subTITaxableBldgLessAssessedValue));
$this->tpl->set_var("SPTaxable_BldgLessMV", $this->checkNumericFormat($this->subSPTaxableBldgLessMarketValue));
$this->tpl->set_var("SPTaxable_BldgLessAV", $this->checkNumericFormat($this->subSPTaxableBldgLessAssessedValue));
$this->tpl->set_var("HOTaxable_BldgLessMV", $this->checkNumericFormat($this->subHOTaxableBldgLessMarketValue));
$this->tpl->set_var("HOTaxable_BldgLessAV", $this->checkNumericFormat($this->subHOTaxableBldgLessAssessedValue));
$this->tpl->set_var("SCTaxable_BldgLessMV", $this->checkNumericFormat($this->subSCTaxableBldgLessMarketValue));
$this->tpl->set_var("SCTaxable_BldgLessAV", $this->checkNumericFormat($this->subSCTaxableBldgLessAssessedValue));
$this->tpl->set_var("CUTaxable_BldgLessMV", $this->checkNumericFormat($this->subCUTaxableBldgLessMarketValue));
$this->tpl->set_var("CUTaxable_BldgLessAV", $this->checkNumericFormat($this->subCUTaxableBldgLessAssessedValue));
$this->tpl->set_var("OTTaxable_BldgLessMV", $this->checkNumericFormat($this->subOTTaxableBldgLessMarketValue));
$this->tpl->set_var("OTTaxable_BldgLessAV", $this->checkNumericFormat($this->subOTTaxableBldgLessAssessedValue));
$this->tpl->set_var("GOExempt_BldgLessMV", $this->checkNumericFormat($this->subGOExemptBldgLessMarketValue));
$this->tpl->set_var("GOExempt_BldgLessAV", $this->checkNumericFormat($this->subGOExemptBldgLessAssessedValue));
$this->tpl->set_var("RLExempt_BldgLessMV", $this->checkNumericFormat($this->subRLExemptBldgLessMarketValue));
$this->tpl->set_var("RLExempt_BldgLessAV", $this->checkNumericFormat($this->subRLExemptBldgLessAssessedValue));
$this->tpl->set_var("CHExempt_BldgLessMV", $this->checkNumericFormat($this->subCHExemptBldgLessMarketValue));
$this->tpl->set_var("CHExempt_BldgLessAV", $this->checkNumericFormat($this->subCHExemptBldgLessAssessedValue));
$this->tpl->set_var("EDExempt_BldgLessMV", $this->checkNumericFormat($this->subEDExemptBldgLessMarketValue));
$this->tpl->set_var("EDExempt_BldgLessAV", $this->checkNumericFormat($this->subEDExemptBldgLessAssessedValue));
$this->tpl->set_var("OTExempt_BldgLessMV", $this->checkNumericFormat($this->subOTExemptBldgLessMarketValue));
$this->tpl->set_var("OTExempt_BldgLessAV", $this->checkNumericFormat($this->subOTExemptBldgLessAssessedValue));
$this->tpl->set_var("RETaxable_BldgOverMV", $this->checkNumericFormat($this->subRETaxableBldgOverMarketValue));
$this->tpl->set_var("RETaxable_BldgOverAV", $this->checkNumericFormat($this->subRETaxableBldgOverAssessedValue));
$this->tpl->set_var("AGTaxable_BldgOverMV", $this->checkNumericFormat($this->subAGTaxableBldgOverMarketValue));
$this->tpl->set_var("AGTaxable_BldgOverAV", $this->checkNumericFormat($this->subAGTaxableBldgOverAssessedValue));
$this->tpl->set_var("COTaxable_BldgOverMV", $this->checkNumericFormat($this->subCOTaxableBldgOverMarketValue));
$this->tpl->set_var("COTaxable_BldgOverAV", $this->checkNumericFormat($this->subCOTaxableBldgOverAssessedValue));
$this->tpl->set_var("INTaxable_BldgOverMV", $this->checkNumericFormat($this->subINTaxableBldgOverMarketValue));
$this->tpl->set_var("INTaxable_BldgOverAV", $this->checkNumericFormat($this->subINTaxableBldgOverAssessedValue));
$this->tpl->set_var("MITaxable_BldgOverMV", $this->checkNumericFormat($this->subMITaxableBldgOverMarketValue));
$this->tpl->set_var("MITaxable_BldgOverAV", $this->checkNumericFormat($this->subMITaxableBldgOverAssessedValue));
$this->tpl->set_var("TITaxable_BldgOverMV", $this->checkNumericFormat($this->subTITaxableBldgOverMarketValue));
$this->tpl->set_var("TITaxable_BldgOverAV", $this->checkNumericFormat($this->subTITaxableBldgOverAssessedValue));
$this->tpl->set_var("SPTaxable_BldgOverMV", $this->checkNumericFormat($this->subSPTaxableBldgOverMarketValue));
$this->tpl->set_var("SPTaxable_BldgOverAV", $this->checkNumericFormat($this->subSPTaxableBldgOverAssessedValue));
$this->tpl->set_var("HOTaxable_BldgOverMV", $this->checkNumericFormat($this->subHOTaxableBldgOverMarketValue));
$this->tpl->set_var("HOTaxable_BldgOverAV", $this->checkNumericFormat($this->subHOTaxableBldgOverAssessedValue));
$this->tpl->set_var("SCTaxable_BldgOverMV", $this->checkNumericFormat($this->subSCTaxableBldgOverMarketValue));
$this->tpl->set_var("SCTaxable_BldgOverAV", $this->checkNumericFormat($this->subSCTaxableBldgOverAssessedValue));
$this->tpl->set_var("CUTaxable_BldgOverMV", $this->checkNumericFormat($this->subCUTaxableBldgOverMarketValue));
$this->tpl->set_var("CUTaxable_BldgOverAV", $this->checkNumericFormat($this->subCUTaxableBldgOverAssessedValue));
$this->tpl->set_var("OTTaxable_BldgOverMV", $this->checkNumericFormat($this->subOTTaxableBldgOverMarketValue));
$this->tpl->set_var("OTTaxable_BldgOverAV", $this->checkNumericFormat($this->subOTTaxableBldgOverAssessedValue));
$this->tpl->set_var("GOExempt_BldgOverMV", $this->checkNumericFormat($this->subGOExemptBldgOverMarketValue));
$this->tpl->set_var("GOExempt_BldgOverAV", $this->checkNumericFormat($this->subGOExemptBldgOverAssessedValue));
$this->tpl->set_var("RLExempt_BldgOverMV", $this->checkNumericFormat($this->subRLExemptBldgOverMarketValue));
$this->tpl->set_var("RLExempt_BldgOverAV", $this->checkNumericFormat($this->subRLExemptBldgOverAssessedValue));
$this->tpl->set_var("CHExempt_BldgOverMV", $this->checkNumericFormat($this->subCHExemptBldgOverMarketValue));
$this->tpl->set_var("CHExempt_BldgOverAV", $this->checkNumericFormat($this->subCHExemptBldgOverAssessedValue));
$this->tpl->set_var("EDExempt_BldgOverMV", $this->checkNumericFormat($this->subEDExemptBldgOverMarketValue));
$this->tpl->set_var("EDExempt_BldgOverAV", $this->checkNumericFormat($this->subEDExemptBldgOverAssessedValue));
$this->tpl->set_var("OTExempt_BldgOverMV", $this->checkNumericFormat($this->subOTExemptBldgOverMarketValue));
$this->tpl->set_var("OTExempt_BldgOverAV", $this->checkNumericFormat($this->subOTExemptBldgOverAssessedValue));
$this->tpl->set_var("RETaxable_MachMV", $this->checkNumericFormat($this->subRETaxableMachMarketValue));
$this->tpl->set_var("RETaxable_MachAV", $this->checkNumericFormat($this->subRETaxableMachAssessedValue));
$this->tpl->set_var("AGTaxable_MachMV", $this->checkNumericFormat($this->subAGTaxableMachMarketValue));
$this->tpl->set_var("AGTaxable_MachAV", $this->checkNumericFormat($this->subAGTaxableMachAssessedValue));
$this->tpl->set_var("COTaxable_MachMV", $this->checkNumericFormat($this->subCOTaxableMachMarketValue));
$this->tpl->set_var("COTaxable_MachAV", $this->checkNumericFormat($this->subCOTaxableMachAssessedValue));
$this->tpl->set_var("INTaxable_MachMV", $this->checkNumericFormat($this->subINTaxableMachMarketValue));
$this->tpl->set_var("INTaxable_MachAV", $this->checkNumericFormat($this->subINTaxableMachAssessedValue));
$this->tpl->set_var("MITaxable_MachMV", $this->checkNumericFormat($this->subMITaxableMachMarketValue));
$this->tpl->set_var("MITaxable_MachAV", $this->checkNumericFormat($this->subMITaxableMachAssessedValue));
$this->tpl->set_var("TITaxable_MachMV", $this->checkNumericFormat($this->subTITaxableMachMarketValue));
$this->tpl->set_var("TITaxable_MachAV", $this->checkNumericFormat($this->subTITaxableMachAssessedValue));
$this->tpl->set_var("SPTaxable_MachMV", $this->checkNumericFormat($this->subSPTaxableMachMarketValue));
$this->tpl->set_var("SPTaxable_MachAV", $this->checkNumericFormat($this->subSPTaxableMachAssessedValue));
$this->tpl->set_var("HOTaxable_MachMV", $this->checkNumericFormat($this->subHOTaxableMachMarketValue));
$this->tpl->set_var("HOTaxable_MachAV", $this->checkNumericFormat($this->subHOTaxableMachAssessedValue));
$this->tpl->set_var("SCTaxable_MachMV", $this->checkNumericFormat($this->subSCTaxableMachMarketValue));
$this->tpl->set_var("SCTaxable_MachAV", $this->checkNumericFormat($this->subSCTaxableMachAssessedValue));
$this->tpl->set_var("CUTaxable_MachMV", $this->checkNumericFormat($this->subCUTaxableMachMarketValue));
$this->tpl->set_var("CUTaxable_MachAV", $this->checkNumericFormat($this->subCUTaxableMachAssessedValue));
$this->tpl->set_var("OTTaxable_MachMV", $this->checkNumericFormat($this->subOTTaxableMachMarketValue));
$this->tpl->set_var("OTTaxable_MachAV", $this->checkNumericFormat($this->subOTTaxableMachAssessedValue));
$this->tpl->set_var("GOExempt_MachMV", $this->checkNumericFormat($this->subGOExemptMachMarketValue));
$this->tpl->set_var("GOExempt_MachAV", $this->checkNumericFormat($this->subGOExemptMachAssessedValue));
$this->tpl->set_var("RLExempt_MachMV", $this->checkNumericFormat($this->subRLExemptMachMarketValue));
$this->tpl->set_var("RLExempt_MachAV", $this->checkNumericFormat($this->subRLExemptMachAssessedValue));
$this->tpl->set_var("CHExempt_MachMV", $this->checkNumericFormat($this->subCHExemptMachMarketValue));
$this->tpl->set_var("CHExempt_MachAV", $this->checkNumericFormat($this->subCHExemptMachAssessedValue));
$this->tpl->set_var("EDExempt_MachMV", $this->checkNumericFormat($this->subEDExemptMachMarketValue));
$this->tpl->set_var("EDExempt_MachAV", $this->checkNumericFormat($this->subEDExemptMachAssessedValue));
$this->tpl->set_var("OTExempt_MachMV", $this->checkNumericFormat($this->subOTExemptMachMarketValue));
$this->tpl->set_var("OTExempt_MachAV", $this->checkNumericFormat($this->subOTExemptMachAssessedValue));
$this->tpl->set_var("RETaxable_OtherMV", $this->checkNumericFormat($this->subRETaxableOtherMarketValue));
$this->tpl->set_var("RETaxable_OtherAV", $this->checkNumericFormat($this->subRETaxableOtherAssessedValue));
$this->tpl->set_var("AGTaxable_OtherMV", $this->checkNumericFormat($this->subAGTaxableOtherMarketValue));
$this->tpl->set_var("AGTaxable_OtherAV", $this->checkNumericFormat($this->subAGTaxableOtherAssessedValue));
$this->tpl->set_var("COTaxable_OtherMV", $this->checkNumericFormat($this->subCOTaxableOtherMarketValue));
$this->tpl->set_var("COTaxable_OtherAV", $this->checkNumericFormat($this->subCOTaxableOtherAssessedValue));
$this->tpl->set_var("INTaxable_OtherMV", $this->checkNumericFormat($this->subINTaxableOtherMarketValue));
$this->tpl->set_var("INTaxable_OtherAV", $this->checkNumericFormat($this->subINTaxableOtherAssessedValue));
$this->tpl->set_var("MITaxable_OtherMV", $this->checkNumericFormat($this->subMITaxableOtherMarketValue));
$this->tpl->set_var("MITaxable_OtherAV", $this->checkNumericFormat($this->subMITaxableOtherAssessedValue));
$this->tpl->set_var("TITaxable_OtherMV", $this->checkNumericFormat($this->subTITaxableOtherMarketValue));
$this->tpl->set_var("TITaxable_OtherAV", $this->checkNumericFormat($this->subTITaxableOtherAssessedValue));
$this->tpl->set_var("SPTaxable_OtherMV", $this->checkNumericFormat($this->subSPTaxableOtherMarketValue));
$this->tpl->set_var("SPTaxable_OtherAV", $this->checkNumericFormat($this->subSPTaxableOtherAssessedValue));
$this->tpl->set_var("HOTaxable_OtherMV", $this->checkNumericFormat($this->subHOTaxableOtherMarketValue));
$this->tpl->set_var("HOTaxable_OtherAV", $this->checkNumericFormat($this->subHOTaxableOtherAssessedValue));
$this->tpl->set_var("SCTaxable_OtherMV", $this->checkNumericFormat($this->subSCTaxableOtherMarketValue));
$this->tpl->set_var("SCTaxable_OtherAV", $this->checkNumericFormat($this->subSCTaxableOtherAssessedValue));
$this->tpl->set_var("CUTaxable_OtherMV", $this->checkNumericFormat($this->subCUTaxableOtherMarketValue));
$this->tpl->set_var("CUTaxable_OtherAV", $this->checkNumericFormat($this->subCUTaxableOtherAssessedValue));
$this->tpl->set_var("OTTaxable_OtherMV", $this->checkNumericFormat($this->subOTTaxableOtherMarketValue));
$this->tpl->set_var("OTTaxable_OtherAV", $this->checkNumericFormat($this->subOTTaxableOtherAssessedValue));
$this->tpl->set_var("GOExempt_OtherMV", $this->checkNumericFormat($this->subGOExemptOtherMarketValue));
$this->tpl->set_var("GOExempt_OtherAV", $this->checkNumericFormat($this->subGOExemptOtherAssessedValue));
$this->tpl->set_var("RLExempt_OtherMV", $this->checkNumericFormat($this->subRLExemptOtherMarketValue));
$this->tpl->set_var("RLExempt_OtherAV", $this->checkNumericFormat($this->subRLExemptOtherAssessedValue));
$this->tpl->set_var("CHExempt_OtherMV", $this->checkNumericFormat($this->subCHExemptOtherMarketValue));
$this->tpl->set_var("CHExempt_OtherAV", $this->checkNumericFormat($this->subCHExemptOtherAssessedValue));
$this->tpl->set_var("EDExempt_OtherMV", $this->checkNumericFormat($this->subEDExemptOtherMarketValue));
$this->tpl->set_var("EDExempt_OtherAV", $this->checkNumericFormat($this->subEDExemptOtherAssessedValue));
$this->tpl->set_var("OTExempt_OtherMV", $this->checkNumericFormat($this->subOTExemptOtherMarketValue));
$this->tpl->set_var("OTExempt_OtherAV", $this->checkNumericFormat($this->subOTExemptOtherAssessedValue));
$this->tpl->set_var("RETaxable_TotalMV", $this->checkNumericFormat($this->totalRETaxableMarketValue));
$this->tpl->set_var("RETaxable_TotalAV", $this->checkNumericFormat($this->totalRETaxableAssessedValue));
$this->tpl->set_var("AGTaxable_TotalMV", $this->checkNumericFormat($this->totalAGTaxableMarketValue));
$this->tpl->set_var("AGTaxable_TotalAV", $this->checkNumericFormat($this->totalAGTaxableAssessedValue));
$this->tpl->set_var("COTaxable_TotalMV", $this->checkNumericFormat($this->totalCOTaxableMarketValue));
$this->tpl->set_var("COTaxable_TotalAV", $this->checkNumericFormat($this->totalCOTaxableAssessedValue));
$this->tpl->set_var("INTaxable_TotalMV", $this->checkNumericFormat($this->totalINTaxableMarketValue));
$this->tpl->set_var("INTaxable_TotalAV", $this->checkNumericFormat($this->totalINTaxableAssessedValue));
$this->tpl->set_var("MITaxable_TotalMV", $this->checkNumericFormat($this->totalMITaxableMarketValue));
$this->tpl->set_var("MITaxable_TotalAV", $this->checkNumericFormat($this->totalMITaxableAssessedValue));
$this->tpl->set_var("TITaxable_TotalMV", $this->checkNumericFormat($this->totalTITaxableMarketValue));
$this->tpl->set_var("TITaxable_TotalAV", $this->checkNumericFormat($this->totalTITaxableAssessedValue));
$this->tpl->set_var("SPTaxable_TotalMV", $this->checkNumericFormat($this->totalSPTaxableMarketValue));
$this->tpl->set_var("SPTaxable_TotalAV", $this->checkNumericFormat($this->totalSPTaxableAssessedValue));
$this->tpl->set_var("HOTaxable_TotalMV", $this->checkNumericFormat($this->totalHOTaxableMarketValue));
$this->tpl->set_var("HOTaxable_TotalAV", $this->checkNumericFormat($this->totalHOTaxableAssessedValue));
$this->tpl->set_var("SCTaxable_TotalMV", $this->checkNumericFormat($this->totalSCTaxableMarketValue));
$this->tpl->set_var("SCTaxable_TotalAV", $this->checkNumericFormat($this->totalSCTaxableAssessedValue));
$this->tpl->set_var("CUTaxable_TotalMV", $this->checkNumericFormat($this->totalCUTaxableMarketValue));
$this->tpl->set_var("CUTaxable_TotalAV", $this->checkNumericFormat($this->totalCUTaxableAssessedValue));
$this->tpl->set_var("OTTaxable_TotalMV", $this->checkNumericFormat($this->totalOTTaxableMarketValue));
$this->tpl->set_var("OTTaxable_TotalAV", $this->checkNumericFormat($this->totalOTTaxableAssessedValue));
$this->tpl->set_var("GOExempt_TotalMV", $this->checkNumericFormat($this->totalGOExemptMarketValue));
$this->tpl->set_var("GOExempt_TotalAV", $this->checkNumericFormat($this->totalGOExemptAssessedValue));
$this->tpl->set_var("RLExempt_TotalMV", $this->checkNumericFormat($this->totalRLExemptMarketValue));
$this->tpl->set_var("RLExempt_TotalAV", $this->checkNumericFormat($this->totalRLExemptAssessedValue));
$this->tpl->set_var("CHExempt_TotalMV", $this->checkNumericFormat($this->totalCHExemptMarketValue));
$this->tpl->set_var("CHExempt_TotalAV", $this->checkNumericFormat($this->totalCHExemptAssessedValue));
$this->tpl->set_var("EDExempt_TotalMV", $this->checkNumericFormat($this->totalEDExemptMarketValue));
$this->tpl->set_var("EDExempt_TotalAV", $this->checkNumericFormat($this->totalEDExemptAssessedValue));
$this->tpl->set_var("OTExempt_TotalMV", $this->checkNumericFormat($this->totalOTExemptMarketValue));
$this->tpl->set_var("OTExempt_TotalAV", $this->checkNumericFormat($this->totalOTExemptAssessedValue));
$this->tpl->set_var("Taxable_RealPropertyUnits", $this->checkNumericFormat($this->totalTaxableRealPropertyUnits));
$this->tpl->set_var("Taxable_LandArea", $this->checkNumericFormat($this->totalTaxableLandArea));
$this->tpl->set_var("Taxable_LandMV", $this->checkNumericFormat($this->totalTaxableLandMarketValue));
$this->tpl->set_var("Taxable_LandAV", $this->checkNumericFormat($this->totalTaxableLandAssessedValue));
$this->tpl->set_var("Taxable_BldgLessMV", $this->checkNumericFormat($this->totalTaxableBldgLessMarketValue));
$this->tpl->set_var("Taxable_BldgLessAV", $this->checkNumericFormat($this->totalTaxableBldgLessAssessedValue));
$this->tpl->set_var("Taxable_BldgOverMV", $this->checkNumericFormat($this->totalTaxableBldgOverMarketValue));
$this->tpl->set_var("Taxable_BldgOverAV", $this->checkNumericFormat($this->totalTaxableBldgOverAssessedValue));
$this->tpl->set_var("Taxable_MachMV", $this->checkNumericFormat($this->totalTaxableMachMarketValue));
$this->tpl->set_var("Taxable_MachAV", $this->checkNumericFormat($this->totalTaxableMachAssessedValue));
$this->tpl->set_var("Taxable_OtherMV", $this->checkNumericFormat($this->totalTaxableOtherMarketValue));
$this->tpl->set_var("Taxable_OtherAV", $this->checkNumericFormat($this->totalTaxableOtherAssessedValue));
$this->tpl->set_var("Taxable_TotalMV", $this->checkNumericFormat($this->totalTaxableMarketValue));
$this->tpl->set_var("Taxable_TotalAV", $this->checkNumericFormat($this->totalTaxableAssessedValue));
$this->tpl->set_var("Exempt_RealPropertyUnits", $this->checkNumericFormat($this->totalExemptRealPropertyUnits));
$this->tpl->set_var("Exempt_LandArea", $this->checkNumericFormat($this->totalExemptLandArea));
$this->tpl->set_var("Exempt_LandMV", $this->checkNumericFormat($this->totalExemptLandMarketValue));
$this->tpl->set_var("Exempt_LandAV", $this->checkNumericFormat($this->totalExemptLandAssessedValue));
$this->tpl->set_var("Exempt_BldgLessMV", $this->checkNumericFormat($this->totalExemptBldgLessMarketValue));
$this->tpl->set_var("Exempt_BldgLessAV", $this->checkNumericFormat($this->totalExemptBldgLessAssessedValue));
$this->tpl->set_var("Exempt_BldgOverMV", $this->checkNumericFormat($this->totalExemptBldgOverMarketValue));
$this->tpl->set_var("Exempt_BldgOverAV", $this->checkNumericFormat($this->totalExemptBldgOverAssessedValue));
$this->tpl->set_var("Exempt_MachMV", $this->checkNumericFormat($this->totalExemptMachMarketValue));
$this->tpl->set_var("Exempt_MachAV", $this->checkNumericFormat($this->totalExemptMachAssessedValue));
$this->tpl->set_var("Exempt_OtherMV", $this->checkNumericFormat($this->totalExemptOtherMarketValue));
$this->tpl->set_var("Exempt_OtherAV", $this->checkNumericFormat($this->totalExemptOtherAssessedValue));
$this->tpl->set_var("Exempt_TotalMV", $this->checkNumericFormat($this->totalExemptMarketValue));
$this->tpl->set_var("Exempt_TotalAV", $this->checkNumericFormat($this->totalExemptAssessedValue));
$this->tpl->set_var("TOTAL_RealPropertyUnits", $this->checkNumericFormat($this->totalRealPropertyUnits));
$this->tpl->set_var("TOTAL_LandArea", $this->checkNumericFormat($this->totalLandArea));
$this->tpl->set_var("TOTAL_LandMV", $this->checkNumericFormat($this->totalLandMarketValue));
$this->tpl->set_var("TOTAL_LandAV", $this->checkNumericFormat($this->totalLandAssessedValue));
$this->tpl->set_var("TOTAL_BldgLessMV", $this->checkNumericFormat($this->totalBldgLessMarketValue));
$this->tpl->set_var("TOTAL_BldgLessAV", $this->checkNumericFormat($this->totalBldgLessAssessedValue));
$this->tpl->set_var("TOTAL_BldgOverMV", $this->checkNumericFormat($this->totalBldgOverMarketValue));
$this->tpl->set_var("TOTAL_BldgOverAV", $this->checkNumericFormat($this->totalBldgOverAssessedValue));
$this->tpl->set_var("TOTAL_MachMV", $this->checkNumericFormat($this->totalMachMarketValue));
$this->tpl->set_var("TOTAL_MachAV", $this->checkNumericFormat($this->totalMachAssessedValue));
$this->tpl->set_var("TOTAL_OtherMV", $this->checkNumericFormat($this->totalOtherMarketValue));
$this->tpl->set_var("TOTAL_OtherAV", $this->checkNumericFormat($this->totalOtherAssessedValue));
$this->tpl->set_var("TOTAL_TotalMV", $this->checkNumericFormat($this->totalMarketValue));
$this->tpl->set_var("TOTAL_TotalAV", $this->checkNumericFormat($this->totalAssessedValue));
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}