Beispiel #1
0
 function Main()
 {
     switch ($this->formArray["formAction"]) {
         case "save":
             $DueEncode = new SoapObject(NCCBIZ . "DueEncode.php", "urn:Object");
             if ($this->formArray["dueID"] != "") {
                 $DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object");
                 if (!($xmlStr = $DueDetails->getDue($this->formArray["dueID"]))) {
                     $this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
                     $this->tpl->set_var("TableBlock", "record not found");
                 } else {
                     if (!($domDoc = domxml_open_mem($xmlStr))) {
                         $this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
                         $this->tpl->set_var("TableBlock", "error xmlDoc");
                     } else {
                         $dueArray = $this->setDues();
                         foreach ($dueArray as $due) {
                             $doc = $due->getDomDocument();
                             $xmlStr = $doc->dump_mem(true);
                             if (!($ret = $DueEncode->updateDue($xmlStr))) {
                                 exit("error update");
                             }
                             unset($doc);
                             unset($xmlStr);
                         }
                     }
                 }
             } else {
                 $dueArray = $this->setDues();
                 foreach ($dueArray as $due) {
                     $doc = $due->getDomDocument();
                     $xmlStr = $doc->dump_mem(true);
                     if (!($ret = $DueEncode->saveDue($xmlStr))) {
                         exit("error saving");
                     }
                     unset($doc);
                     unset($xmlStr);
                 }
             }
             $this->formArray["dueID"] = $ret;
             header("location: DueClose.php" . $this->sess->url("") . $this->sess->add_query(array("rptopID" => $this->formArray["rptopID"])));
             exit($ret);
             break;
         default:
             // grab current tax rates from TreasurySettings
             $treasurySettings = new TreasurySettings();
             $treasurySettings->selectRecord();
             $this->formArray["masterBasicTaxRate"] = $treasurySettings->getPctRPTax();
             $this->formArray["masterSEFTaxRate"] = $treasurySettings->getPctSEF();
             $this->formArray["masterIdleTaxRate"] = $treasurySettings->getPctIdle();
             $this->formArray["discountPeriod"] = $treasurySettings->getDiscountPeriod();
             $TDDetails = new SoapObject(NCCBIZ . "TDDetails.php", "urn:Object");
             if (!($xmlStr = $TDDetails->getTD($this->formArray["tdID"]))) {
                 // xml failed
             } else {
                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                     // domDoc empty
                 } else {
                     $td = new TD();
                     $td->parseDomDocument($domDoc);
                     $this->formArray["afsID"] = $td->getAfsID();
                     $this->formArray["taxDeclarationNumber"] = $td->getTaxDeclarationNumber();
                     $this->formArray["taxBeginsWithTheYear"] = $td->getTaxBeginsWithTheYear();
                 }
             }
             unset($xmlStr);
             unset($domDoc);
             $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object");
             if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) {
                 // xml failed
             } else {
                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                     // domDoc empty
                 } else {
                     $afs = new AFS();
                     $afs->parseDomDocument($domDoc);
                     $this->formArray["assessedValue"] = $afs->getTotalAssessedValue();
                     $this->formArray["taxability"] = $afs->getTaxability();
                     $this->formArray["effectivity"] = $afs->getEffectivity();
                     $this->formArray["propertyType"] = $td->getPropertyType();
                     $this->formArray["idle"] = "No";
                     if ($td->getPropertyType() == "Land") {
                         if (is_array($afs->landArray)) {
                             // if land is stripped
                             if (count($afs->landArray) > 1) {
                                 foreach ($afs->landArray as $land) {
                                     if ($land->getIdle() == "Yes") {
                                         $this->formArray["idle"] = "Yes";
                                         break;
                                     }
                                 }
                             } else {
                                 $this->formArray["idle"] = $afs->landArray[0]->getIdle();
                             }
                         }
                     }
                     if ($this->formArray["idle"] == "") {
                         $this->formArray["idle"] = "No";
                     }
                 }
             }
             if ($this->formArray["dueID"] != "") {
                 $DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object");
                 if (!($xmlStr = $DueDetails->getDue($this->formArray["dueID"]))) {
                     echo "xml failed";
                 } else {
                     //echo $xmlStr;
                     if (!($domDoc = domxml_open_mem($xmlStr))) {
                         echo "error xmlDoc";
                     } else {
                         $due = new Due();
                         $due->parseDomDocument($domDoc);
                         foreach ($due as $key => $value) {
                             switch ($key) {
                                 default:
                                     $this->formArray[$key] = $value;
                             }
                         }
                         $this->formArray["dueDate_str"] = date("F d, Y", strtotime($this->formArray["dueDate"]));
                         $this->formArray["taxDue"] = $due->getTaxDue();
                     }
                 }
             } else {
                 // select RPTOP taxable year from rptopID
                 $RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object");
                 if (!($xmlStr = $RPTOPDetails->getRPTOP($this->formArray["rptopID"]))) {
                     exit("xml failed");
                 } else {
                     if (!($domDoc = domxml_open_mem($xmlStr))) {
                         exit("error domDoc");
                     } else {
                         $rptop = new RPTOP();
                         $rptop->parseDomDocument($domDoc);
                         $this->formArray["taxableYear"] = $rptop->getTaxableYear();
                     }
                 }
                 // display default Due details
                 $this->formArray["dueDate"] = date("Y-n-d", strtotime($this->formArray["taxableYear"] . "-" . $treasurySettings->getAnnualDueDate()));
                 $this->formArray["dueDate_str"] = date("F d, Y", strtotime($this->formArray["dueDate"]));
                 $this->formArray["basicTaxRate"] = $this->formArray["masterBasicTaxRate"];
                 $this->formArray["sefTaxRate"] = $this->formArray["masterSEFTaxRate"];
                 $this->formArray["idleTaxRate"] = $this->formArray["masterIdleTaxRate"];
                 $this->formArray["basicTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["basicTaxRate"];
                 $this->formArray["sefTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["sefTaxRate"];
                 // if land->idle is "Yes", compute idleTax, otherwise set idleTax to zero
                 if ($this->formArray["propertyType"] == "Land") {
                     if ($this->formArray["idle"] == "Yes") {
                         $this->formArray["idleTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["idleTaxRate"];
                     } else {
                         $this->formArray["idleTax"] = "0.00";
                     }
                 }
                 // if afs->taxability is "Exempt", reset computations to zero.
                 if ($this->formArray["taxability"] == "Exempt") {
                     $this->formArray["basicTax"] = 0.0;
                     $this->formArray["sefTax"] = 0.0;
                     $this->formArray["idleTax"] = 0.0;
                 }
                 $this->formArray["taxDue"] = $this->formArray["basicTax"] + $this->formArray["sefTax"] + $this->formArray["idleTax"];
             }
     }
     $this->setForm();
     $this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("dueID" => $this->formArray["dueID"], "tdID" => $this->formArray["tdID"], "rptopID" => $this->formArray["rptopID"])));
     $this->tpl->parse("templatePage", "rptsTemplate");
     $this->tpl->finish("templatePage");
     $this->tpl->p("templatePage");
 }
Beispiel #2
0
 function Main()
 {
     $treasurySettings = new TreasurySettings();
     switch ($this->formArray["formAction"]) {
         case "reset":
             // If TreasurySettings Table doesn't exist, Create table and insert defaults from masterTables
             $treasurySettings->setPenaltyLUT($this->masterTables["penaltyLUT"]);
             $treasurySettings->setAnnualDueDate($this->masterTables["annualDueDate"]);
             $treasurySettings->setPctRPTax($this->masterTables["pctRPTax"]);
             $treasurySettings->setPctSEF($this->masterTables["pctSEF"]);
             $treasurySettings->setPctIdle($this->masterTables["pctIdle"]);
             $treasurySettings->setDiscountPercentage($this->masterTables["discountPercentage"]);
             $treasurySettings->setDiscountPeriod($this->masterTables["discountPeriod"]);
             $treasurySettings->setAdvancedDiscountPercentage($this->masterTables["advancedDiscountPercentage"]);
             $treasurySettings->setQ1AdvancedDiscountPercentage($this->masterTables["q1AdvancedDiscountPercentage"]);
             if (!$treasurySettings->tableExists()) {
                 $treasurySettings->createTable();
                 $treasurySettings->insertRecord();
             } else {
                 $treasurySettings->updateRecord();
             }
             $this->formArray["message"] = "Variables reset to default values.";
             break;
         case "save":
             if ($treasurySettings->tableExists()) {
                 ksort($this->formArray["penaltyLUT"]);
                 reset($this->formArray["penaltyLUT"]);
                 $treasurySettings->setPenaltyLUT($this->formArray["penaltyLUT"]);
                 $treasurySettings->setAnnualDueDate($this->formArray["annualDueDate"]);
                 $treasurySettings->setPctRPTax($this->formArray["pctRPTax"]);
                 $treasurySettings->setPctSEF($this->formArray["pctSEF"]);
                 $treasurySettings->setPctIdle($this->formArray["pctIdle"]);
                 $treasurySettings->setDiscountPercentage($this->formArray["discountPercentage"]);
                 $treasurySettings->setDiscountPeriod($this->formArray["discountPeriod"]);
                 $treasurySettings->setAdvancedDiscountPercentage($this->formArray["advancedDiscountPercentage"]);
                 $treasurySettings->setQ1AdvancedDiscountPercentage($this->formArray["q1AdvancedDiscountPercentage"]);
                 if ($treasurySettings->updateRecord()) {
                     $this->formArray["message"] = "Treasury Settings saved.";
                 } else {
                     $this->formArray["message"] = "Error saving. Try clicking 'Reset' to restore defaults.";
                 }
             } else {
                 $this->formArray["message"] = "Error saving. Try clicking 'Reset' to restore defaults.";
             }
             break;
         default:
             // If TreasurySettings Table doesn't exist, Create table and insert defaults from masterTables (upon installation)
             if (!$treasurySettings->tableExists()) {
                 $treasurySettings->createTable();
             }
             // If somehow no record exists in Treasury Settings, Insert a Record (unlikely to occur)
             if (!$treasurySettings->selectRecord()) {
                 $treasurySettings->setPenaltyLUT($this->masterTables["penaltyLUT"]);
                 $treasurySettings->setAnnualDueDate($this->masterTables["annualDueDate"]);
                 $treasurySettings->setPctRPTax($this->masterTables["pctRPTax"]);
                 $treasurySettings->setPctSEF($this->masterTables["pctSEF"]);
                 $treasurySettings->setPctIdle($this->masterTables["pctIdle"]);
                 $treasurySettings->setDiscountPercentage($this->masterTables["discountPercentage"]);
                 $treasurySettings->setDiscountPeriod($this->masterTables["discountPeriod"]);
                 $treasurySettings->setAdvancedDiscountPercentage($this->masterTables["advancedDiscountPercentage"]);
                 $treasurySettings->setQ1AdvancedDiscountPercentage($this->masterTables["q1AdvancedDiscountPercentage"]);
                 $treasurySettings->insertRecord();
             }
             // If somehow more than 1 record exists in Treasury Settings, delete all records and Insert Record (unlikely to occur)
             if ($treasurySettings->countRecord() > 1) {
                 $treasurySettings->deleteRecord();
                 $treasurySettings->setPenaltyLUT($this->masterTables["penaltyLUT"]);
                 $treasurySettings->setAnnualDueDate($this->masterTables["annualDueDate"]);
                 $treasurySettings->setPctRPTax($this->masterTables["pctRPTax"]);
                 $treasurySettings->setPctSEF($this->masterTables["pctSEF"]);
                 $treasurySettings->setPctIdle($this->masterTables["pctIdle"]);
                 $treasurySettings->setDiscountPercentage($this->masterTables["discountPercentage"]);
                 $treasurySettings->setDiscountPeriod($this->masterTables["discountPeriod"]);
                 $treasurySettings->setAdvancedDiscountPercentage($this->masterTables["advancedDiscountPercentage"]);
                 $treasurySettings->setQ1AdvancedDiscountPercentage($this->masterTables["q1AdvancedDiscountPercentage"]);
                 $treasurySettings->insertRecord();
             }
     }
     if ($treasurySettings->selectRecord()) {
         $this->formArray["penaltyLUT"] = $treasurySettings->getPenaltyLUT();
         $this->formArray["annualDueDate"] = $treasurySettings->getAnnualDueDate();
         $this->formArray["pctRPTax"] = $treasurySettings->getPctRPTax();
         $this->formArray["pctSEF"] = $treasurySettings->getPctSEF();
         $this->formArray["pctIdle"] = $treasurySettings->getPctIdle();
         $this->formArray["discountPercentage"] = $treasurySettings->getDiscountPercentage();
         $this->formArray["discountPeriod"] = $treasurySettings->getDiscountPeriod();
         $this->formArray["advancedDiscountPercentage"] = $treasurySettings->getAdvancedDiscountPercentage();
         $this->formArray["q1AdvancedDiscountPercentage"] = $treasurySettings->getQ1AdvancedDiscountPercentage();
     } else {
         foreach ($this->masterTables as $key => $value) {
             $this->formArray[$key] = $value;
         }
     }
     $this->showPenaltyLUTList();
     $this->setForm();
     $this->tpl->set_var("uname", $this->user["uname"]);
     $this->tpl->set_var("today", date("F j, Y"));
     $this->tpl->set_var("Session", $this->sess->url(""));
     $this->tpl->parse("templatePage", "rptsTemplate");
     $this->tpl->finish("templatePage");
     $this->tpl->p("templatePage");
 }
Beispiel #3
0
 ** Sec. 235. Additional Levy on Real Property for the Special Education Fund.
 ** - A province or city, or a municipality within the Metropolitan Manila Area,
 ** may levy and collect an annual tax of one percent (1%) on the assessed value
 ** of real property which shall be in addition to the basic real property tax.
 ** The proceeds thereof shall exclusively accrue to the Special Education Fund (SEF).
 **/
$pctSEF = 0.01;
/** The $pctIdle is the percentage value of the assessed value that is
 ** the resulting idle land tax  i.e. assessed value * pctIdle = Idle land tax
 **/
$pctIdle = 0.01;
$discountPercentage = 10;
$discountPeriod = "03-31";
$advancedDiscountPercentage = 20;
$q1AdvancedDiscountPercentage = 10;
// Match Defaults against TreasurySettings values in database:
// and make sure $_POST["formAction"] is not "reset" in TreasurySettings admin
$treasurySettings = new TreasurySettings();
if ($treasurySettings->selectRecord() && $_POST["formAction"] != "reset") {
    $penaltyLUT = $treasurySettings->getPenaltyLUT();
    $pctRPTax = $treasurySettings->getPctRPTax();
    $pctSEF = $treasurySettings->getPctSEF();
    $pctIdle = $treasurySettings->getPctIdle();
    $discountPercentage = $treasurySettings->getDiscountPercentage();
    $discountPeriod = $treasurySettings->getDiscountPeriod();
}
## create a function to set these tables and master values from the database
function setMasterValues()
{
    global $penaltyLUT, $pctRPTax, $pctSEF, $pctIdle, $discountPercentage, $discountPeriod, $advancedDiscountPercentage;
}
Beispiel #4
0
 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);
         }
     }
 }
Beispiel #5
0
 function Main()
 {
     switch ($this->formArray["formAction"]) {
         case "delete":
             //print_r($this->formArray);
             if (count($this->formArray["rptopID"]) > 0) {
                 $RPTOPList = new SoapObject(NCCBIZ . "RPTOPList.php", "urn:Object");
                 if (!($deletedRows = $RPTOPList->deleteRPTOP($this->formArray["rptopID"]))) {
                     $this->tpl->set_var("msg", "SOAP failed");
                 } else {
                     $this->tpl->set_var("msg", $deletedRows . " records deleted");
                 }
             } else {
                 $this->tpl->set_var("msg", "0 records deleted");
             }
             break;
         case "updateCalculation":
             if (is_array($this->formArray["rptopID"])) {
                 $RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object");
                 $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object");
                 $DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object");
                 $DueEncode = new SoapObject(NCCBIZ . "DueEncode.php", "urn:Object");
                 $DueList = new SoapObject(NCCBIZ . "DueList.php", "urn:Object");
                 $dueIDArray = array("Annual" => "", "Q1" => "", "Q2" => "", "Q3" => "", "Q4" => "");
                 $treasurySettings = new TreasurySettings();
                 $treasurySettings->selectRecord();
                 $this->formArray["masterBasicTaxRate"] = $treasurySettings->getPctRPTax();
                 $this->formArray["masterSEFTaxRate"] = $treasurySettings->getPctSEF();
                 $this->formArray["masterIdleTaxRate"] = $treasurySettings->getPctIdle();
                 $this->formArray["discountPeriod"] = $treasurySettings->getDiscountPeriod();
                 $this->formArray["annualDueDate"] = $treasurySettings->getAnnualDueDate();
                 foreach ($this->formArray["rptopID"] as $rptopID) {
                     if (!($xmlStr = $RPTOPDetails->getRPTOP($rptopID))) {
                         // error xmlStr
                     } else {
                         if (!($domDoc = domxml_open_mem($xmlStr))) {
                             // error domDoc
                         } else {
                             $rptop = new RPTOP();
                             $rptop->parseDomDocument($domDoc);
                             $this->formArray["taxableYear"] = $rptop->getTaxableYear();
                             $tdArray = $rptop->getTDArray();
                             if (is_array($tdArray)) {
                                 foreach ($tdArray as $td) {
                                     $this->formArray["assessedValue"] = "";
                                     $this->formArray["taxability"] = "";
                                     $this->formArray["idle"] = "";
                                     $this->formArray["tdID"] = $td->getTdID();
                                     $this->formArray["dueID"] = "";
                                     $this->formArray["propertyType"] = $td->getPropertyType();
                                     if (!($afsXmlStr = $AFSDetails->getAFS($td->getAfsID()))) {
                                         // error afsXmlStr
                                     } else {
                                         if (!($afsDomDoc = domxml_open_mem($afsXmlStr))) {
                                             // error afsDomDoc
                                         } else {
                                             $afs = new AFS();
                                             $afs->parseDomDocument($afsDomDoc);
                                             $this->formArray["assessedValue"] = $afs->getTotalAssessedValue();
                                             $this->formArray["taxability"] = $afs->getTaxability();
                                             $this->formArray["effectivity"] = $afs->getEffectivity();
                                             $this->formArray["dueDate"] = date("Y-n-d", strtotime($this->formArray["taxableYear"] . "-" . $this->formArray["annualDueDate"]));
                                             if ($this->formArray["propertyType"] == "Land") {
                                                 if (is_array($afs->getLandArray())) {
                                                     $this->formArray["idle"] = $afs->landArray[0]->getIdle();
                                                 }
                                             }
                                         }
                                     }
                                     if (!($dueXmlStr = $DueList->getDueList($td->getTdID(), $rptop->getTaxableYear()))) {
                                         $this->formArray["dueID"] = "";
                                         $dueIDArray["Annual"] = "";
                                     } else {
                                         if (!($dueDomDoc = domxml_open_mem($dueXmlStr))) {
                                             $this->formArray["dueID"] = "";
                                             $dueIDArray["Annual"] = "";
                                         } else {
                                             //print_r(htmlspecialchars($xmlStr));
                                             //exit;
                                             $dueRecords = new DueRecords();
                                             $dueRecords->parseDomDocument($dueDomDoc);
                                             foreach ($dueRecords->getArrayList() as $due) {
                                                 foreach ($due as $dueKey => $dueValue) {
                                                     switch ($dueKey) {
                                                         case "dueType":
                                                             $dueIDArray[$dueValue] = $due->getDueID();
                                                             break;
                                                     }
                                                 }
                                             }
                                             $this->formArray["dueID"] = $dueIDArray["Annual"];
                                         }
                                     }
                                     $this->formArray["basicTaxRate"] = $this->formArray["masterBasicTaxRate"];
                                     $this->formArray["sefTaxRate"] = $this->formArray["masterSEFTaxRate"];
                                     $this->formArray["idleTaxRate"] = $this->formArray["masterIdleTaxRate"];
                                     $this->formArray["basicTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["basicTaxRate"];
                                     $this->formArray["sefTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["sefTaxRate"];
                                     // if land->idle is "Yes", compute idleTax, otherwise set idleTax to zero
                                     if ($this->formArray["propertyType"] == "Land") {
                                         if ($this->formArray["idle"] == "Yes") {
                                             $this->formArray["idleTax"] = un_number_format($this->formArray["assessedValue"]) * $this->formArray["idleTaxRate"];
                                         } else {
                                             $this->formArray["idleTax"] = "0.00";
                                         }
                                     }
                                     // if afs->taxability is "Exempt", reset computations to zero.
                                     if ($this->formArray["taxability"] == "Exempt") {
                                         $this->formArray["basicTax"] = "0.00";
                                         $this->formArray["sefTax"] = "0.00";
                                         $this->formArray["idleTax"] = "0.00";
                                     }
                                     if ($dueIDArray["Annual"] != "") {
                                         $dueArray = $this->setDues();
                                         foreach ($dueArray as $due) {
                                             $doc = $due->getDomDocument();
                                             $xmlStr = $doc->dump_mem(true);
                                             if (!($ret = $DueEncode->updateDue($xmlStr))) {
                                                 // error update
                                             }
                                             unset($doc);
                                             unset($xmlStr);
                                         }
                                     } else {
                                         $dueArray = $this->setDues();
                                         foreach ($dueArray as $due) {
                                             $doc = $due->getDomDocument();
                                             $xmlStr = $doc->dump_mem(true);
                                             if (!($ret = $DueEncode->saveDue($xmlStr))) {
                                                 // error save
                                             }
                                             unset($doc);
                                             unset($xmlStr);
                                         }
                                     }
                                     $this->formArray["taxableYear"] = $rptop->getTaxableYear();
                                     $this->refreshTDHistory($td);
                                 }
                             }
                             unset($tdArray);
                         }
                     }
                 }
             }
             if ($this->formArray["searchKey"] != "") {
                 $this->formArray["formAction"] = "search";
             } else {
                 $this->formArray["formAction"] = "";
             }
             header("Location: CalculateRPTOPBatch.php" . $this->sess->url("") . "&page=" . $this->formArray["page"] . "&sortBy=" . $this->formArray["sortBy"] . "&sortOrder=" . $this->formArray["sortOrder"] . "&formAction=" . $this->formArray["formAction"] . "&searchKey=" . $this->formArray["searchKey"]);
             exit;
             break;
         case "search":
             $RPTOPList = new SoapObject(NCCBIZ . "RPTOPList.php", "urn:Object");
             $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
             $this->tpl->set_block("rptsTemplate", "PagesList", "PagesListBlock");
             if (!($count = $RPTOPList->getSearchCount($this->formArray["searchKey"]))) {
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $numOfPages = 1;
                 $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                 $this->tpl->set_var("PageNavigatorBlock", "");
             } else {
                 $numOfPages = ceil($count / PAGE_BY);
                 // page list nav
                 $this->formArray["pageLinksInLine"] = 7;
                 if ($this->formArray["page"] < round($this->formArray["pageLinksInLine"] / 2)) {
                     $startPageLinks = 1;
                 } else {
                     $startPageLinks = $this->formArray["page"] - round($this->formArray["pageLinksInLine"] / 2);
                     if ($startPageLinks < 1) {
                         $startPageLinks = 1;
                     }
                 }
                 $endPageLinks = $startPageLinks + ($this->formArray["pageLinksInLine"] - 1);
                 if ($endPageLinks > $numOfPages) {
                     $endPageLinks = $numOfPages;
                 }
                 for ($i = $startPageLinks; $i <= $endPageLinks; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pageListPages", "");
                         $this->tpl->set_var("pageListPagesUrl", "");
                         $this->tpl->set_var("pageListPaged", $i);
                     } else {
                         $this->tpl->set_var("pageListPages", $i);
                         $this->tpl->set_var("pageListPagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                         $this->tpl->set_var("pageListPaged", "");
                     }
                     $this->tpl->parse("PagesListBlock", "PagesList", true);
                 }
                 // drop down nav
                 for ($i = 1; $i <= $numOfPages; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                         $this->tpl->set_var("paged", "selected");
                     } else {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                         $this->tpl->set_var("paged", "");
                     }
                     $this->tpl->parse("PagesBlock", "Pages", true);
                 }
             }
             if ($numOfPages == $this->formArray["page"]) {
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 $this->tpl->set_var("next", $this->formArray["page"] + 1 . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                 $this->tpl->set_var("nextTxt", "next");
             }
             if ($this->formArray["page"] == 1) {
                 $this->tpl->set_var("previousTxt", "");
             } else {
                 $this->tpl->set_var("previous", $this->formArray["page"] - 1 . "&formAction=search&searchKey=" . urlencode($this->formArray["searchKey"]));
                 $this->tpl->set_var("previousTxt", "previous");
             }
             $this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages);
             $condition = $this->sortBlocks();
             if (!($xmlStr = $RPTOPList->searchRPTOP($this->formArray["page"], $condition, $this->formArray["searchKey"]))) {
                 $this->tpl->set_var("pageOf", "");
                 $this->tpl->set_block("rptsTemplate", "RPTOPTable", "RPTOPTableBlock");
                 $this->tpl->set_var("RPTOPTableBlock", "");
                 $this->tpl->set_block("rptsTemplate", "RPTOPDBEmpty", "RPTOPDBEmptyBlock");
                 $this->tpl->set_var("RPTOPDBEmptyBlock", "");
                 $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_var("previousTxt", "");
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                     $this->tpl->set_block("rptsTemplate", "RPTOPListTable", "RPTOPListTableBlock");
                     $this->tpl->set_var("RPTOPListTableBlock", "error xmlDoc");
                 } else {
                     $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
                     $this->tpl->set_var("NotFoundBlock", "");
                     $rptopRecords = new RPTOPRecords();
                     $rptopRecords->parseDomDocument($domDoc);
                     $list = $rptopRecords->getArrayList();
                     if (count($list)) {
                         $this->tpl->set_block("rptsTemplate", "RPTOPDBEmpty", "RPTOPDBEmptyBlock");
                         $this->tpl->set_var("RPTOPDBEmptyBlock", "");
                         $this->tpl->set_block("rptsTemplate", "RPTOPList", "RPTOPListBlock");
                         $this->tpl->set_block("RPTOPList", "PersonList", "PersonListBlock");
                         $this->tpl->set_block("RPTOPList", "CompanyList", "CompanyListBlock");
                         foreach ($list as $key => $value) {
                             $this->tpl->set_var("rptopID", $value->getRptopID());
                             $oValue = $value->owner;
                             $pOwnerStr = "";
                             if (count($oValue->personArray)) {
                                 foreach ($oValue->personArray as $pKey => $pValue) {
                                     $this->tpl->set_var("personID", $pValue->getPersonID());
                                     $this->tpl->set_var("OwnerPerson", $pValue->getFullName());
                                     $this->tpl->parse("PersonListBlock", "PersonList", true);
                                 }
                             }
                             if (count($oValue->companyArray)) {
                                 foreach ($oValue->companyArray as $cKey => $cValue) {
                                     $this->tpl->set_var("companyID", $cValue->getCompanyID());
                                     $this->tpl->set_var("OwnerCompany", $cValue->getCompanyName());
                                     $this->tpl->parse("CompanyListBlock", "CompanyList", true);
                                 }
                             }
                             if (count($oValue->personArray) || count($oValue->companyArray)) {
                                 $this->tpl->set_var("none", "");
                             } else {
                                 $this->tpl->set_var("none", "none");
                             }
                             $this->tpl->set_var("totalMarketValue", number_format($value->getTotalMarketValue(), 2, '.', ','));
                             $this->tpl->set_var("totalAssessedValue", number_format($value->getTotalAssessedValue(), 2, '.', ','));
                             $this->tpl->set_var("taxableYear", $value->getTaxableYear());
                             // grab Dues of rptop to get totalTaxDue
                             $totalTaxDue = 0.0;
                             if (is_array($value->tdArray)) {
                                 foreach ($value->tdArray as $td) {
                                     $DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object");
                                     $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object");
                                     $afsXml = $AFSDetails->getAfs($td->getAfsID());
                                     $afsDomDoc = domxml_open_mem($afsXml);
                                     $afs = new AFS();
                                     $afs->parseDomDocument($afsDomDoc);
                                     if (!($xmlStr = $DueDetails->getDueFromTdID($td->getTdID(), $value->getTaxableYear()))) {
                                         $totalTaxDue = "uncalculated";
                                         break;
                                     } else {
                                         if (!($domDoc = domxml_open_mem($xmlStr))) {
                                             $totalTaxDue = "uncalculated";
                                         } else {
                                             $due = new Due();
                                             $due->parseDomDocument($domDoc);
                                             $totalTaxDue += $due->getTaxDue();
                                         }
                                     }
                                 }
                             } else {
                                 $totalTaxDue = "no TD's";
                             }
                             if (is_numeric($totalTaxDue)) {
                                 $totalTaxDue = formatCurrency($totalTaxDue);
                             }
                             $this->tpl->set_var("totalTaxDue", $totalTaxDue);
                             $this->setRPTOPListBlockPerms();
                             $this->tpl->parse("RPTOPListBlock", "RPTOPList", true);
                             $this->tpl->set_var("PersonListBlock", "");
                             $this->tpl->set_var("CompanyListBlock", "");
                         }
                     } else {
                         $this->tpl->set_block("rptsTemplate", "RPTOPList", "RPTOPListBlock");
                         $this->tpl->set_var("RPTOPListBlock", "huh");
                     }
                 }
             }
             break;
         case "cancel":
             header("location: CalculateRPTOPBatch.php");
             exit;
             break;
         default:
             $this->tpl->set_var("msg", "");
             $RPTOPList = new SoapObject(NCCBIZ . "RPTOPList.php", "urn:Object");
             $this->tpl->set_block("rptsTemplate", "Pages", "PagesBlock");
             $this->tpl->set_block("rptsTemplate", "PagesList", "PagesListBlock");
             $this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
             $this->tpl->set_var("NotFoundBlock", "");
             if (!($count = $RPTOPList->getRPTOPCount())) {
                 $this->tpl->set_var("PagesBlock", "");
                 $this->tpl->set_var("PagesListBlock", "");
                 $this->tpl->set_block("rptsTemplate", "PageNavigator", "PageNavigatorBlock");
                 $this->tpl->set_var("PageNavigatorBlock", "");
             } else {
                 $numOfPages = ceil($count / PAGE_BY);
                 // page list nav
                 $this->formArray["pageLinksInLine"] = 7;
                 if ($this->formArray["page"] < round($this->formArray["pageLinksInLine"] / 2)) {
                     $startPageLinks = 1;
                 } else {
                     $startPageLinks = $this->formArray["page"] - round($this->formArray["pageLinksInLine"] / 2);
                     if ($startPageLinks < 1) {
                         $startPageLinks = 1;
                     }
                 }
                 $endPageLinks = $startPageLinks + ($this->formArray["pageLinksInLine"] - 1);
                 if ($endPageLinks > $numOfPages) {
                     $endPageLinks = $numOfPages;
                 }
                 for ($i = $startPageLinks; $i <= $endPageLinks; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pageListPages", "");
                         $this->tpl->set_var("pageListPagesUrl", "");
                         $this->tpl->set_var("pageListPaged", $i);
                     } else {
                         $this->tpl->set_var("pageListPages", $i);
                         $this->tpl->set_var("pageListPagesUrl", $i);
                         $this->tpl->set_var("pageListPaged", "");
                     }
                     $this->tpl->parse("PagesListBlock", "PagesList", true);
                 }
                 // drop down nav
                 for ($i = 1; $i <= $numOfPages; $i++) {
                     if ($i == $this->formArray["page"]) {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i);
                         $this->tpl->set_var("paged", "selected");
                     } else {
                         $this->tpl->set_var("pages", $i);
                         $this->tpl->set_var("pagesUrl", $i);
                         $this->tpl->set_var("paged", "");
                     }
                     $this->tpl->parse("PagesBlock", "Pages", true);
                 }
             }
             if ($numOfPages == $this->formArray["page"]) {
                 $this->tpl->set_var("nextTxt", "");
             } else {
                 $this->tpl->set_var("next", $this->formArray["page"] + 1);
                 $this->tpl->set_var("nextTxt", "next");
             }
             if ($this->formArray["page"] == 1) {
                 $this->tpl->set_var("previousTxt", "");
             } else {
                 $this->tpl->set_var("previous", $this->formArray["page"] - 1);
                 $this->tpl->set_var("previousTxt", "previous");
             }
             if ($numOfPages == "") {
                 $this->tpl->set_var("pageOf", "");
             } else {
                 $this->tpl->set_var("pageOf", $this->formArray["page"] . " of " . $numOfPages);
             }
             $condition = $this->sortBlocks();
             if (!($xmlStr = $RPTOPList->getRPTOPList($this->formArray["page"], $condition))) {
                 $this->tpl->set_block("rptsTemplate", "RPTOPTable", "RPTOPTableBlock");
                 $this->tpl->set_var("RPTOPTableBlock", "");
             } else {
                 if (!($domDoc = domxml_open_mem($xmlStr))) {
                     $this->tpl->set_block("rptsTemplate", "RPTOPListTable", "RPTOPListTableBlock");
                     $this->tpl->set_var("RPTOPListTableBlock", "");
                 } else {
                     $rptopRecords = new RPTOPRecords();
                     $rptopRecords->parseDomDocument($domDoc);
                     $list = $rptopRecords->getArrayList();
                     if (count($list)) {
                         $this->tpl->set_block("rptsTemplate", "RPTOPDBEmpty", "RPTOPDBEmptyBlock");
                         $this->tpl->set_var("RPTOPDBEmptyBlock", "");
                         $this->tpl->set_block("rptsTemplate", "RPTOPList", "RPTOPListBlock");
                         $this->tpl->set_block("RPTOPList", "PersonList", "PersonListBlock");
                         $this->tpl->set_block("RPTOPList", "CompanyList", "CompanyListBlock");
                         foreach ($list as $key => $value) {
                             $this->tpl->set_var("rptopID", $value->getRptopID());
                             $oValue = $value->owner;
                             $pOwnerStr = "";
                             if (count($oValue->personArray)) {
                                 foreach ($oValue->personArray as $pKey => $pValue) {
                                     $this->tpl->set_var("personID", $pValue->getPersonID());
                                     $this->tpl->set_var("OwnerPerson", $pValue->getFullName());
                                     $this->tpl->parse("PersonListBlock", "PersonList", true);
                                 }
                             }
                             if (count($oValue->companyArray)) {
                                 foreach ($oValue->companyArray as $cKey => $cValue) {
                                     $this->tpl->set_var("companyID", $cValue->getCompanyID());
                                     $this->tpl->set_var("OwnerCompany", $cValue->getCompanyName());
                                     $this->tpl->parse("CompanyListBlock", "CompanyList", true);
                                 }
                             }
                             if (count($oValue->personArray) || count($oValue->companyArray)) {
                                 $this->tpl->set_var("none", "");
                             } else {
                                 $this->tpl->set_var("none", "none");
                             }
                             $this->tpl->set_var("totalMarketValue", number_format($value->getTotalMarketValue(), 2, '.', ','));
                             $this->tpl->set_var("totalAssessedValue", number_format($value->getTotalAssessedValue(), 2, '.', ','));
                             $this->tpl->set_var("taxableYear", $value->getTaxableYear());
                             // grab Dues of rptop to get totalTaxDue
                             $totalTaxDue = 0.0;
                             if (is_array($value->tdArray)) {
                                 foreach ($value->tdArray as $td) {
                                     $DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object");
                                     $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object");
                                     $afsXml = $AFSDetails->getAfs($td->getAfsID());
                                     $afsDomDoc = domxml_open_mem($afsXml);
                                     $afs = new AFS();
                                     $afs->parseDomDocument($afsDomDoc);
                                     if (!($xmlStr = $DueDetails->getDueFromTdID($td->getTdID(), $value->getTaxableYear()))) {
                                         $totalTaxDue = "uncalculated";
                                         break;
                                     } else {
                                         if (!($domDoc = domxml_open_mem($xmlStr))) {
                                             $totalTaxDue = "uncalculated";
                                         } else {
                                             $due = new Due();
                                             $due->parseDomDocument($domDoc);
                                             $totalTaxDue += $due->getTaxDue();
                                         }
                                     }
                                 }
                             } else {
                                 $totalTaxDue = "no TD's";
                             }
                             if (is_numeric($totalTaxDue)) {
                                 $totalTaxDue = formatCurrency($totalTaxDue);
                             }
                             $this->tpl->set_var("totalTaxDue", $totalTaxDue);
                             $this->setRPTOPListBlockPerms();
                             $this->tpl->parse("RPTOPListBlock", "RPTOPList", true);
                             $this->tpl->set_var("PersonListBlock", "");
                             $this->tpl->set_var("CompanyListBlock", "");
                         }
                     } else {
                         $this->tpl->set_block("rptsTemplate", "RPTOPList", "RPTOPListBlock");
                         $this->tpl->set_var("RPTOPListBlock", "huh");
                     }
                 }
             }
     }
     $this->setForm();
     $this->setPageDetailPerms();
     $this->tpl->set_var("uname", $this->user["uname"]);
     $this->tpl->set_var("today", date("F j, Y"));
     $this->tpl->set_var("Session", $this->sess->url(""));
     $this->tpl->parse("templatePage", "rptsTemplate");
     $this->tpl->finish("templatePage");
     $this->tpl->p("templatePage");
 }