function getTreasurySettings() { $treasurySettings = new TreasurySettings(); $treasurySettings->selectRecord(); return $treasurySettings; }
function Main() { switch ($this->formArray["formAction"]) { case "remove": //echo "removeOwnerRPTOP(".$this->formArray["rptopID"].",".$this->formArray["ownerID"].",".$this->formArray["personID"].",".$this->formArray["companyID"].")"; $OwnerList = new SoapObject(NCCBIZ . "OwnerList.php", "urn:Object"); if (count($this->formArray["personID"]) || count($this->formArray["companyID"])) { if (!($deletedRows = $OwnerList->removeOwnerRPTOP($this->formArray["rptopID"], $this->formArray["ownerID"], $this->formArray["personID"], $this->formArray["companyID"]))) { $this->tpl->set_var("msg", "SOAP failed"); //echo "SOAP failed"; } else { $this->tpl->set_var("msg", $deletedRows . " records deleted"); } } else { $this->tpl->set_var("msg", "0 records deleted"); } header("location: RPTOPDetails.php" . $this->sess->url("") . $this->sess->add_query(array("rptopID" => $this->formArray["rptopID"]))); exit; break; default: $this->tpl->set_var("msg", ""); } //select $RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object"); if (!($xmlStr = $RPTOPDetails->getRPTOP($this->formArray["rptopID"]))) { exit("xml failed"); } else { //echo($xmlStr); if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); $this->tpl->set_var("OwnerListTableBlock", "error xmlDoc"); } else { $rptop = new RPTOP(); $rptop->parseDomDocument($domDoc); //print_r($rptop); foreach ($rptop as $key => $value) { switch ($key) { case "owner": //$RPTOPEncode = new SoapObject(NCCBIZ."RPTOPEncode.php", "urn:Object"); if (is_a($value, "Owner")) { $this->formArray["ownerID"] = $rptop->owner->getOwnerID(); $xmlStr = $rptop->owner->domDocument->dump_mem(true); if (!$xmlStr) { $this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); $this->tpl->set_var("OwnerListTableBlock", ""); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); $this->tpl->set_var("OwnerListTableBlock", "error xmlDoc"); } else { $this->displayOwnerList($domDoc); } } } else { $this->tpl->set_block("rptsTemplate", "PersonList", "PersonListBlock"); $this->tpl->set_var("PersonListBlock", ""); $this->tpl->set_block("rptsTemplate", "CompanyList", "CompanyListBlock"); $this->tpl->set_var("CompanyListBlock", ""); } break; case "cityAssessor": if (is_numeric($value)) { $cityAssessor = new Person(); $cityAssessor->selectRecord($value); $this->tpl->set_var("cityAssessorID", $cityAssessor->getPersonID()); $this->tpl->set_var("cityAssessorName", $cityAssessor->getFullName()); $this->formArray["cityAssessorName"] = $cityAssessor->getFullName(); } else { $cityAssessor = $value; $this->tpl->set_var("cityAssessorID", $cityAssessor); $this->tpl->set_var("cityAssessorName", $cityAssessor); $this->formArray["cityAssessorName"] = $cityAssessor; } break; case "cityTreasurer": if (is_numeric($value)) { $cityTreasurer = new Person(); $cityTreasurer->selectRecord($value); $this->tpl->set_var("cityTreasurerID", $cityTreasurer->getPersonID()); $this->tpl->set_var("cityTreasurerName", $cityTreasurer->getFullName()); $this->formArray["cityTreasurerName"] = $cityTreasurer->getFullName(); } else { $cityTreasurer = $value; $this->tpl->set_var("cityTreasurerID", $cityTreasurer); $this->tpl->set_var("cityTreasurerName", $cityTreasurer); $this->formArray["cityTreasurerName"] = $cityTreasurer; } break; case "tdArray": //$this->tpl->set_block("rptsTemplate", "defaultTDList", "defaultTDListBlock"); //$this->tpl->set_block("rptsTemplate", "toggleTDList", "toggleTDListBlock"); //$this->tpl->set_block("rptsTemplate", "TDList", "TDListBlock"); //$this->tpl->set_block("TDList", "BacktaxesList", "BacktaxesListBlock"); $tdCtr = 0; if (count($value)) { $this->tpl->set_block("rptsTemplate", "TDDBEmpty", "TDDBEmptyBlock"); $this->tpl->set_var("TDDBEmptyBlock", ""); /* $this->tpl->set_block("TDList", "Land", "LandBlock"); $this->tpl->set_block("TDList", "PlantsTrees", "PlantsTreesBlock"); $this->tpl->set_block("TDList", "ImprovementsBuildings", "ImprovementsBuildingsBlock"); $this->tpl->set_block("TDList", "Machineries", "MachineriesBlock"); */ foreach ($value as $tkey => $tvalue) { //foreach($tvalue as $column => $val){ // $this->tpl->set_var($column,$val); //} /* $this->tpl->set_var("tdID",$tvalue->getTDID()); $this->tpl->set_var("taxDeclarationNumber",$tvalue->getTaxDeclarationNumber()); $this->tpl->set_var("afsID",$tvalue->getAfsID()); $this->tpl->set_var("cancelsTDNumber",$tvalue->getCancelsTDNumber()); $this->tpl->set_var("canceledByTDNumber",$tvalue->getCanceledByTDNumber()); $this->tpl->set_var("taxBeginsWithTheYear",$tvalue->getTaxBeginsWithTheYear()); $this->tpl->set_var("ceasesWithTheYear",$tvalue->getCeasesWithTheYear()); $this->tpl->set_var("enteredInRPARForBy",$tvalue->getEnteredInRPARForBy()); $this->tpl->set_var("enteredInRPARForYear",$tvalue->getEnteredInRPARForYear()); $this->tpl->set_var("previousOwner",$tvalue->getPreviousOwner()); $this->tpl->set_var("previousAssessedValue",$tvalue->getPreviousAssessedValue()); list($dateArr["year"],$dateArr["month"],$dateArr["day"]) = explode("-",$tvalue->getProvincialAssessorDate()); $this->tpl->set_var("pa_yearValue",removePreZero($dateArr["year"])); $this->tpl->set_var("pa_month",removePreZero($dateArr["month"])); $this->tpl->set_var("pa_dayValue",removePreZero($dateArr["day"])); list($dateArr["year"],$dateArr["month"],$dateArr["day"]) = explode("-",$tvalue->getCityMunicipalAssessorDate()); $this->tpl->set_var("cm_yearValue",removePreZero($dateArr["year"])); $this->tpl->set_var("cm_month",removePreZero($dateArr["month"])); $this->tpl->set_var("cm_dayValue",removePreZero($dateArr["day"])); $this->tpl->set_var("provincialAssessorName",$tvalue->provincialAssessor); $this->tpl->set_var("cityMunicipalAssessorName",$tvalue->cityMunicipalAssessor); //$this->tpl->set_var("assessedValue",$tvalue->getAssessedValue()); $this->tpl->set_var("propertyType",$tvalue->getPropertyType()); $this->tpl->set_var("basicTax",""); $this->tpl->set_var("sefTax", ""); $this->tpl->set_var("total", ""); //$this->tpl->set_var("basicTax",$tvalue->getBasicTax()); //$this->tpl->set_var("sefTax",$tvalue->getSefTax()); //$this->tpl->set_var("total",$tvalue->getTotal()); */ $this->tdRecord["arpNumber"] = $tvalue->getTaxDeclarationNumber(); $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($tvalue->getAfsID()))) { //$this->tpl->set_block("rptsTemplate", "AFSTable", "AFSTableBlock"); //$this->tpl->set_var("AFSTableBlock", "afs not found"); } else { //echo $xmlStr; if (!($domDoc = domxml_open_mem($xmlStr))) { //$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); //$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $odID = $afs->getOdID(); $od = new OD(); $od->selectRecord($odID); if (is_object($od->locationAddress)) { $locationAddress = $od->getLocationAddress(); $this->tdRecord["location"] = $locationAddress->getBarangay() . ", " . $locationAddress->getMunicipalityCity(); } switch ($tvalue->getPropertyType()) { case "ImprovementsBuildings": if (is_array($afs->getImprovementsBuildingsArray())) { $improvementsBuildings = $afs->improvementsBuildingsArray[0]; $actualUse = $improvementsBuildings->getActualUse(); if (is_numeric($actualUse)) { $improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses(); $improvementsBuildingsActualUses->selectRecord($actualUse); $actualUse = $improvementsBuildingsActualUses->getCode(); //$actualUse = $improvementsBuildingsActualUses->getDescription(); } $this->tdRecord["class"] = $actualUse; } break; case "Machineries": if (is_array($afs->getMachineriesArray())) { $machineries = $afs->machineriesArray[0]; $actualUse = $machineries->getActualUse(); if (is_numeric($actualUse)) { $machineriesActualUses = new MachineriesActualUses(); $machineriesActualUses->selectRecord($actualUse); $actualUse = $machineriesActualUses->getCode(); //$actualUse = $machineriesActualUses->getDescription(); } $this->tdRecord["class"] = $actualUse; } break; case "Land": default: if (is_array($afs->getLandArray())) { $land = $afs->landArray[0]; $actualUse = $land->getActualUse(); if (is_numeric($actualUse)) { $landActualUses = new LandActualUses(); $landActualUses->selectRecord($actualUse); $actualUse = $landActualUses->getCode(); //$actualUse = $landActualUses->getDescription(); } $this->tdRecord["class"] = $actualUse; } else { if (is_array($afs->getPlantsTreesArray())) { if (is_numeric($actualUse)) { $plantsTreesActualUses = new PlantsTreesActualUses(); $plantsTreesActualUses->selectRecord($actualUse); $actualUse = $plantsTreesActualUses->getCode(); //$actualUse = $plantsTreesActualUses->getDescription(); } $this->tdRecord["class"] = $actualUse; } } } $this->formArray["landTotalMarketValue"] += $afs->getLandTotalMarketValue(); $this->formArray["landTotalAssessedValue"] += $afs->getLandTotalAssessedValue(); $this->formArray["plantTotalMarketValue"] += $afs->getPlantTotalMarketValue(); $this->formArray["plantTotalAssessedValue"] += $afs->getPlantTotalAssessedValue(); $this->formArray["bldgTotalMarketValue"] += $afs->getBldgTotalMarketValue(); $this->formArray["bldgTotalAssessedValue"] += $afs->getBldgTotalAssessedValue(); $this->formArray["machTotalMarketValue"] += $afs->getMachTotalMarketValue(); $this->formArray["machTotalAssessedValue"] += $afs->getMachTotalAssessedValue(); $this->formArray["totalMarketValue"] += $afs->getTotalMarketValue(); $this->formArray["totalAssessedValue"] += $afs->getTotalAssessedValue(); $this->tpl->set_var("marketValue", number_format($afs->getTotalMarketValue(), 2, '.', ',')); $this->tpl->set_var("assessedValue", number_format($afs->getTotalAssessedValue(), 2, '.', ',')); $this->tpl->set_var("taxability", $afs->getTaxability()); $this->tpl->set_var("effectivity", $afs->getEffectivity()); $this->formArray["idle"] = "No"; if ($tvalue->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"; } $this->tpl->set_var("idle", $this->formArray["idle"]); } } // grab DueRecords from tdID $DueList = new SoapObject(NCCBIZ . "DueList.php", "urn:Object"); $dueArrayList = array("Annual" => "", "Q1" => "", "Q2" => "", "Q3" => "", "Q4" => ""); if (!($xmlStr = $DueList->getDueList($tvalue->getTdID(), $rptop->getTaxableYear()))) { if ($this->formArray["rptopID"] != "") { $redirectMessage = "Dues are uncalculated. <a href='CalculateRPTOPDetails.php" . $this->sess->url("") . "&rptopID=" . $this->formArray["rptopID"] . "'>Click here</a> to go to calculation page or <a href='SOA.php" . $this->sess->url("") . "'>return to list</a>."; } else { $redirectMessage = "Dues are uncalculated. <a href='SOA.php" . $this->sess->url("") . "'>Click here</a> to return to list."; } exit($redirectMessage); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { if ($this->formArray["rptopID"] != "") { $redirectMessage = "Dues are uncalculated. <a href='CalculateRPTOPDetails.php" . $this->sess->url("") . "&rptopID=" . $this->formArray["rptopID"] . "'>Click here</a> to go to calculation page or <a href='SOA.php" . $this->sess->url("") . "'>return to list</a>."; } else { $redirectMessage = "Dues are uncalculated. <a href='SOA.php" . $this->sess->url("") . "'>Click here</a> to return to list."; } exit($redirectMessage); } else { $dueRecords = new DueRecords(); $dueRecords->parseDomDocument($domDoc); foreach ($dueRecords->getArrayList() as $due) { foreach ($due as $dueKey => $dueValue) { switch ($dueKey) { case "dueType": if ($dueValue == "Annual") { $this->formArray["totalTaxDue"] += $due->getTaxDue(); } $dueArrayList[$dueValue] = $due; $this->tpl->set_var("basicTax[" . $dueValue . "]", formatCurrency($due->getBasicTax())); $this->tpl->set_var("sefTax[" . $dueValue . "]", formatCurrency($due->getSEFTax())); $this->tpl->set_var("idleTax[" . $dueValue . "]", formatCurrency($due->getIdleTax())); $this->tpl->set_var("taxDue[" . $dueValue . "]", formatCurrency($due->getTaxDue())); $this->tpl->set_var("dueDate[" . $dueValue . "]", date("M. d, Y", strtotime($due->getDueDate()))); $dueDateYear = date("Y", strtotime($due->getDueDate())); $this->tdRecord["year"] = $dueDateYear; break; } } } $treasurySettings = new TreasurySettings(); $treasurySettings->selectRecord(); // initialize discountPeriod and discountPercentage for earlyPaymentDiscount $this->tpl->set_var("discountPercentage", $treasurySettings->getDiscountPercentage() . "%"); $this->tpl->set_var("discountPeriod", "January 01, " . $dueDateYear . " - " . date("F d, Y", strtotime($dueDateYear . "-" . $treasurySettings->getDiscountPeriod()))); $this->formArray["discountPercentage"] = $treasurySettings->getDiscountPercentage(); $this->formArray["discountPeriod"] = $treasurySettings->getDiscountPeriod(); $this->formArray["discountPeriod_End"] = strtotime($dueDateYear . "-" . $this->formArray["discountPeriod"]); $this->formArray["discountPeriod_Start"] = strtotime($dueDateYear . "-01-01"); // initialize advancedDiscountPercentage for advancedPayment $this->tpl->set_var("advancedDiscountPercentage", $treasurySettings->getAdvancedDiscountPercentage() . "%"); $this->formArray["advancedDiscountPercentage"] = $treasurySettings->getAdvancedDiscountPercentage(); $this->tpl->set_var("q1AdvancedDiscountPercentage", $treasurySettings->getQ1AdvancedDiscountPercentage() . "%"); $this->formArray["q1AdvancedDiscountPercentage"] = $treasurySettings->getQ1AdvancedDiscountPercentage(); // initialize penaltyLUTArray $penaltyLUTArray = $treasurySettings->getPenaltyLUT(); $this->penaltyLUTArray = $treasurySettings->getPenaltyLUT(); foreach ($dueArrayList as $dKey => $due) { $dueArrayList[$dKey]->setEarlyPaymentDiscountPeriod($this->formArray["discountPeriod"]); $dueArrayList[$dKey]->setEarlyPaymentDiscountPercentage($this->formArray["discountPercentage"]); // compute earlyPaymentDiscount as of today // check if today is within the discountPeriod and compute Discount // AND if today is BEFORE annual dueDate $dueArrayList[$dKey]->setEarlyPaymentDiscount(0.0); if ($due->getDueType() == "Annual") { if (strtotime($this->now) >= $this->formArray["discountPeriod_Start"] && strtotime($this->now) <= $this->formArray["discountPeriod_End"]) { if (strtotime($this->now) <= strtotime($dueArrayList[$dKey]->getDueDate())) { $dueArrayList[$dKey]->setEarlyPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["discountPercentage"] / 100)); } } } else { // if today is BEFORE dueDate if (strtotime($this->now) <= strtotime($due->getDueDate()) && strtotime($this->now) >= $this->formArray["discountPeriod_Start"]) { $dueArrayList[$dKey]->setEarlyPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["discountPercentage"] / 100)); } // commented out Febuary 08, 2005 : Provide Quarterly Discounts // earlyPaymentDiscount aren't given to Quarterly Dues except for Quarter 1 /* if($due->getDueType()=="Q1"){ if(strtotime($this->now) >= $this->formArray["discountPeriod_Start"] && strtotime($this->now) <= $this->formArray["discountPeriod_End"]){ if(strtotime($this->now) <= strtotime($dueArrayList[$dKey]->getDueDate())){ $dueArrayList[$dKey]->setEarlyPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["discountPercentage"]/100)); } } } */ } // compute advancedPaymentDiscount as of today // check if today is BEFORE January 1 of the year of the annual dueDate $dueArrayList[$dKey]->setAdvancedPaymentDiscount(0.0); if (strtotime($this->now) < strtotime(date("Y", strtotime($dueArrayList[$dKey]->getDueDate())) . "-01-01")) { // for advanced payments, give 20% discount to annual dues [advanced discount] // give 10% discount to quarterly dues [early discount] if ($due->getDueType() == "Annual") { $dueArrayList[$dKey]->setAdvancedPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["advancedDiscountPercentage"] / 100)); } else { if ($due->getDueType() == "Q1") { $dueArrayList[$dKey]->setAdvancedPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["q1AdvancedDiscountPercentage"] / 100)); } else { $dueArrayList[$dKey]->setAdvancedPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["discountPercentage"] / 100)); } // commented out: February 08, 2005 // advancedPaymentDiscount aren't given to Quarterly Dues except for Quarter 1 /* if($due->getDueType()=="Q1"){ $dueArrayList[$dKey]->setAdvancedPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["q1AdvancedDiscountPercentage"]/100)); } */ } } $latestPaymentDate[$dKey] = $this->getLatestPaymentDateForDue($dueArrayList[$dKey]); $amountPaidForDue = $this->getAmountPaidForDue($dueArrayList); $latestPaymentDueType = $this->getLatestPaymentDueType($dueArrayList); $amnestyStatus[$dKey] = $this->getAmnestyStatusForDue($dueArrayList[$dKey]); $totalEarlyPaymentDiscount = $this->getTotalEarlyPaymentDiscountForDue($dueArrayList); $totalAdvancedPaymentDiscount = $this->getTotalAdvancedPaymentDiscountForDue($dueArrayList); if ($totalEarlyPaymentDiscount > 0) { $earlyPaymentDiscountForDueType = $this->getTotalEarlyPaymentDiscountForDueType($dueArrayList[$dKey]); if ($earlyPaymentDiscountForDueType > 0) { $dueArrayList[$dKey]->setEarlyPaymentDiscount($earlyPaymentDiscountForDueType); } } if ($totalAdvancedPaymentDiscount > 0) { $advancedPaymentDiscountForDueType = $this->getTotalAdvancedPaymentDiscountForDueType($dueArrayList[$dKey]); if ($advancedPaymentDiscountForDueType > 0) { $dueArrayList[$dKey]->setAdvancedPaymentDiscount($advancedPaymentDiscountForDueType); } } // calculate Penalties verses either today or verses the last paymentDate if ($latestPaymentDate[$dKey] != "" || $latestPaymentDate[$dKey] != "now") { $dueArrayList[$dKey] = $this->computePenalty($latestPaymentDate[$dKey], $dueArrayList[$dKey]); // if balance is 0 leave penalty as is, otherwise calculatePenalty according to date now $balance = round($dueArrayList[$dKey]->getInitialNetDue() - $amountPaidForDue, 4); // 0.1 is used instead of 0 because a lot of balances may end up as 0.002 or so... if ($balance > 0.1) { $dueArrayList[$dKey] = $this->computePenalty($this->now, $dueArrayList[$dKey]); } } else { $dueArrayList[$dKey] = $this->computePenalty($this->now, $dueArrayList[$dKey]); } //print_r($dueArrayList[$dKey]); //echo "<hr>"; $this->tpl->set_var("advancedPaymentDiscount[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getAdvancedPaymentDiscount())); $this->tpl->set_var("earlyPaymentDiscount[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getEarlyPaymentDiscount())); $this->tpl->set_var("monthsOverDue[" . $dKey . "]", $dueArrayList[$dKey]->getMonthsOverDue()); $this->tpl->set_var("penaltyPercentage[" . $dKey . "]", $dueArrayList[$dKey]->getPenaltyPercentage() * 100); $this->tpl->set_var("penalty[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getPenalty())); $this->initialNetDue[$dKey] = $dueArrayList[$dKey]->getInitialNetDue(); if ($amnestyStatus[$dKey]) { $this->initialNetDue[$dKey] -= $dueArrayList[$dKey]->getPenalty(); $this->tpl->set_var("amnesty[" . $dKey . "]", "Yes"); } else { $this->tpl->set_var("amnesty[" . $dKey . "]", "No"); } $this->tpl->set_var("initialNetDue[" . $dKey . "]", formatCurrency($this->initialNetDue[$dKey])); } // out of the loop, // verify balances to make disable penalties and discounts for Annual if ALL QUARTERS have been paid // and to disable penalties and discounts for Quarters if ALL of ANNUAL has been paid // example: Q1, Q2, Q3 and Q4 have been fully paid. Annual should not show any payables. // Likewise if Annual has been fully paid, Q1, Q2, Q3 and Q4 should not show any payables. $totalQuarterlyNetDue = 0; $totalQuarterlyNetDue += $dueArrayList["Q1"]->getBasicTax() + $dueArrayList["Q1"]->getSefTax() + $dueArrayList["Q1"]->getIdleTax(); $totalQuarterlyNetDue -= $dueArrayList["Q1"]->getEarlyPaymentDiscount() + $dueArrayList["Q1"]->getAdvancedPaymentDiscount(); if (!$amnestyStatus["Q1"]) { $totalQuarterlyNetDue += $dueArrayList["Q1"]->getPenalty(); } $totalQuarterlyNetDue += $dueArrayList["Q2"]->getBasicTax() + $dueArrayList["Q2"]->getSefTax() + $dueArrayList["Q2"]->getIdleTax(); $totalQuarterlyNetDue -= $dueArrayList["Q2"]->getEarlyPaymentDiscount() + $dueArrayList["Q2"]->getAdvancedPaymentDiscount(); if (!$amnestyStatus["Q2"]) { $totalQuarterlyNetDue += $dueArrayList["Q2"]->getPenalty(); } $totalQuarterlyNetDue += $dueArrayList["Q3"]->getBasicTax() + $dueArrayList["Q3"]->getSefTax() + $dueArrayList["Q3"]->getIdleTax(); $totalQuarterlyNetDue -= $dueArrayList["Q3"]->getEarlyPaymentDiscount() + $dueArrayList["Q3"]->getAdvancedPaymentDiscount(); if (!$amnestyStatus["Q3"]) { $totalQuarterlyNetDue += $dueArrayList["Q3"]->getPenalty(); } $totalQuarterlyNetDue += $dueArrayList["Q4"]->getBasicTax() + $dueArrayList["Q4"]->getSefTax() + $dueArrayList["Q4"]->getIdleTax(); $totalQuarterlyNetDue -= $dueArrayList["Q4"]->getEarlyPaymentDiscount() + $dueArrayList["Q4"]->getAdvancedPaymentDiscount(); if (!$amnestyStatus["Q4"]) { $totalQuarterlyNetDue += $dueArrayList["Q4"]->getPenalty(); } $totalAnnualNetDue = 0; $totalAnnualNetDue += $dueArrayList["Annual"]->getBasicTax() + $dueArrayList["Annual"]->getSefTax() + $dueArrayList["Annual"]->getIdleTax(); $totalAnnualNetDue -= $dueArrayList["Annual"]->getEarlyPaymentDiscount() + $dueArrayList["Annual"]->getAdvancedPaymentDiscount(); if (!$amnestyStatus["Annual"]) { $totalAnnualNetDue += $dueArrayList["Annual"]->getPenalty(); } if ($latestPaymentDueType != "Annual" && $totalQuarterlyNetDue - $amountPaidForDue <= 0) { // all QUARTERLY DUES have been paid, modify Annual Due values $dueArrayList["Annual"]->setAdvancedPaymentDiscount(0); $dueArrayList["Annual"]->setEarlyPaymentDiscount(0); $dueArrayList["Annual"]->setMonthsOverDue(0); $dueArrayList["Annual"]->setPenaltyPercentage(0); $dueArrayList["Annual"]->setPenalty(0); $this->initialNetDue["Annual"] = $dueArrayList["Annual"]->getInitialNetDue(); $this->tpl->set_var("advancedPaymentDiscount[Annual]", formatCurrency($dueArrayList["Annual"]->getAdvancedPaymentDiscount())); $this->tpl->set_var("earlyPaymentDiscount[Annual]", formatCurrency($dueArrayList["Annual"]->getEarlyPaymentDiscount())); $this->tpl->set_var("monthsOverDue[Annual]", $dueArrayList["Annual"]->getMonthsOverDue()); $this->tpl->set_var("penaltyPercentage[Annual]", $dueArrayList["Annual"]->getPenaltyPercentage() * 100); $this->tpl->set_var("penalty[Annual]", formatCurrency($dueArrayList["Annual"]->getPenalty())); $this->tpl->set_var("amnesty[Annual]", "No"); $this->tpl->set_var("initialNetDue[Annual]", formatCurrency($this->initialNetDue["Annual"])); } else { if ($latestPaymentDueType == "Annual" && $totalAnnualNetDue - $amountPaidForDue <= 0) { // all of ANNUAL Due has been fully paid, modify Quarterly Due values $quarterlyDueKeys = array("Q1", "Q2", "Q3", "Q4"); foreach ($quarterlyDueKeys as $dKey) { $dueArrayList[$dKey]->setAdvancedPaymentDiscount(0); $dueArrayList[$dKey]->setEarlyPaymentDiscount(0); $dueArrayList[$dKey]->setMonthsOverDue(0); $dueArrayList[$dKey]->setPenaltyPercentage(0); $dueArrayList[$dKey]->setPenalty(0); $this->initialNetDue[$dKey] = $dueArrayList[$dKey]->getInitialNetDue(); $this->tpl->set_var("advancedPaymentDiscount[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getAdvancedPaymentDiscount())); $this->tpl->set_var("earlyPaymentDiscount[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getEarlyPaymentDiscount())); $this->tpl->set_var("monthsOverDue[" . $dKey . "]", $dueArrayList[$dKey]->getMonthsOverDue()); $this->tpl->set_var("penaltyPercentage[" . $dKey . "]", $dueArrayList[$dKey]->getPenaltyPercentage() * 100); $this->tpl->set_var("penalty[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getPenalty())); $this->tpl->set_var("amnesty[" . $dKey . "]", "No"); $this->tpl->set_var("initialNetDue[" . $dKey . "]", formatCurrency($this->initialNetDue[$dKey])); } } } } } // display Backtaxes and previousTD Backtaxes $this->formArray["totalBacktaxesBalance"] = 0; $this->displayBacktaxTD($tvalue->getTdID()); $precedingTDArray = $this->getPrecedingTDArray($tvalue); if (is_array($precedingTDArray)) { foreach ($precedingTDArray as $precedingTD) { $this->displayBacktaxTD($precedingTD->getTdID()); } } $this->tpl->set_var("total", number_format($this->formArray["totalBacktaxesDue"], 2)); $this->tpl->set_var("totalBacktaxesBalance", number_format($this->formArray["totalBacktaxesBalance"], 2)); // grab dueID's and backtaxTDID's to run through payments // create $dueIDArray foreach ($dueArrayList as $due) { $this->dueIDArray[] = $due->getDueID(); } $this->displayTotalPaid(); $this->displayNetDue(); $this->tdArrayList[$this->tdRecord["year"] . $this->tdArrayListCounter] = $this->tdRecord; $this->tdArrayListCounter++; unset($this->tdRecord); $this->tpl->set_var("ctr", $tdCtr); //$this->tpl->parse("defaultTDListBlock", "defaultTDList", true); //$this->tpl->parse("toggleTDListBlock", "toggleTDList", true); //$this->tpl->parse("TDListBlock", "TDList", true); //$this->tpl->set_var("BacktaxesListBlock", ""); /* $this->tpl->set_var("LandBlock", ""); $this->tpl->set_var("PlantsTreesBlock", ""); $this->tpl->set_var("ImprovementsBuildingsBlock", ""); $this->tpl->set_var("MachineriesBlock", ""); */ $tdCtr++; } } else { $this->tpl->set_var("defaultTDListBlock", "//no default"); $this->tpl->set_var("toggleTDListBlock", "//no Toggle"); $this->tpl->set_var("TDListBlock", ""); } $this->tpl->set_var("tdCtr", $tdCtr); break; case "landTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "landTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "plantTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "plantTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "bldgTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "bldgTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "machTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "machTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "totalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "totalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; default: $this->formArray[$key] = $value; } } $this->formArray["totalMarketValue"] = $this->formArray["landTotalMarketValue"] + $this->formArray["plantTotalMarketValue"] + $this->formArray["bldgTotalMarketValue"] + $this->formArray["machTotalMarketValue"]; $this->formArray["totalAssessedValue"] = $this->formArray["landTotalAssessedValue"] + $this->formArray["plantTotalAssessedValue"] + $this->formArray["bldgTotalAssessedValue"] + $this->formArray["machTotalAssessedValue"]; unset($rptop); $AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object"); $rptop = new RPTOP(); $rptop->setRptopID($this->formArray["rptopID"]); $rptop->setLandTotalMarketValue($this->formArray["landTotalMarketValue"]); $rptop->setLandTotalAssessedValue($this->formArray["landTotalAssessedValue"]); $rptop->setPlantTotalMarketValue($this->formArray["plantTotalMarketValue"]); $rptop->setPlantTotalPlantAssessedValue($this->formArray["plantTotalAssessedValue"]); $rptop->setBldgTotalMarketValue($this->formArray["bldgTotalMarketValue"]); $rptop->setBldgTotalAssessedValue($this->formArray["bldgTotalAssessedValue"]); $rptop->setMachTotalMarketValue($this->formArray["machTotalMarketValue"]); $rptop->setMachTotalAssessedValue($this->formArray["machTotalAssessedValue"]); $rptop->setTotalMarketValue($this->formArray["totalMarketValue"]); $rptop->setTotalAssessedValue($this->formArray["totalAssessedValue"]); $rptop->setCreatedBy($this->userID); $rptop->setModifiedBy($this->userID); $rptop->setDomDocument(); $RPTOPEncode = new SoapObject(NCCBIZ . "RPTOPEncode.php", "urn:Object"); $rptop->setDomDocument(); $doc = $rptop->getDomDocument(); $xmlStr = $doc->dump_mem(true); //echo $xmlStr; if (!($ret = $RPTOPEncode->updateRPTOPtotals($xmlStr))) { echo "ret=" . $ret; } //echo $ret; } } if (is_array($this->tdArrayList)) { ksort($this->tdArrayList); reset($this->tdArrayList); // $this->tpl->set_block("rptsTemplate", "TDList", "TDListBlock"); $this->tpl->set_block("rptsTemplate", "Page", "PageBlock"); $this->tpl->set_block("Page", "TDList", "TDListBlock"); $this->tpl->set_block("Page", "TotalDue", "TotalDueBlock"); $this->formArray["totalTaxDue"] = 0; $maxRows = 20; $numRows = count($this->tdArrayList); $numPages = ceil($numRows / $maxRows); $rowStr = ""; $j = 0; $page = 0; foreach ($this->tdArrayList as $tdRecord) { ++$j; if ($j > $maxRows) { $this->formArray["tdYPosValue"] = "564"; $this->tpl->set_var("TDListBlock", $rowStr); $this->tpl->set_var("PageNumber", ++$page); if ($page == $numPages) { $this->tpl->set_var("TotalDueBlock", $this->tpl->subst("TotalDue")); } else { $this->tpl->set_var("TotalDueBlock", ""); } $this->tpl->parse("PageBlock", "Page", true); $rowStr = ""; $j = 1; } $this->tpl->set_var("arpNumber", $tdRecord["arpNumber"]); $this->tpl->set_var("class", $tdRecord["class"]); $this->tpl->set_var("location", $tdRecord["location"]); $this->tpl->set_var("year", $tdRecord["year"]); $this->tpl->set_var("taxDue", formatCurrency($tdRecord["taxDue"])); $this->tpl->set_var("tdYPos", $this->formArray["tdYPosValue"]); $this->formArray["tdYPosValue"] -= 15; $this->formArray["totalTaxDue"] += $tdRecord["taxDue"]; $rowStr .= $this->tpl->subst("TDList"); } $this->tpl->set_var("TDListBlock", $rowStr); $this->tpl->set_var("PageNumber", ++$page); if ($page == $numPages) { $this->tpl->set_var("TotalDueBlock", $this->tpl->subst("TotalDue")); } else { $this->tpl->set_var("TotalDueBlock", ""); } $this->tpl->parse("PageBlock", "Page", true); // echo $this->tpl->subst("Page"); /* $maxRows = 5; $numRows = count($this->tdArrayList); $numPages = ceil($numRows/$maxRows); $tdRecord = current($this->tdArrayList); for ($page=0; $page<$numPages; ++$page) { $rowStr = ""; $this->formArray["tdYPosValue"] = "564"; for ($currRow=0; $currRow<$maxRows; ++$currRow) { // $tdRecord = $this->tdArrayList[($page*$maxRows)+$currRow]; $this->tpl->set_var("arpNumber", $tdRecord["arpNumber"]); $this->tpl->set_var("class", $tdRecord["class"]); $this->tpl->set_var("location", $tdRecord["location"]); $this->tpl->set_var("year", $tdRecord["year"]); $this->tpl->set_var("taxDue", formatCurrency($tdRecord["taxDue"])); $this->tpl->set_var("tdYPos", $this->formArray["tdYPosValue"]); $this->formArray["tdYPosValue"]-=15; $rowStr .= $this->tpl->subst("TDList"); $this->formArray["totalTaxDue"] += $tdRecord["taxDue"]; $tdRecord = next($this->tdArrayList); } echo $rowStr; $this->tpl->set_var("TDListBlock", $rowStr); $this->tpl->set_var("PageNum", $page+1); $this->tpl->parse("PageBlock", "Page", true); } foreach($this->tdArrayList as $tdRecord){ $this->tpl->set_var("arpNumber", $tdRecord["arpNumber"]); $this->tpl->set_var("class", $tdRecord["class"]); $this->tpl->set_var("location", $tdRecord["location"]); $this->tpl->set_var("year", $tdRecord["year"]); $this->tpl->set_var("taxDue", formatCurrency($tdRecord["taxDue"])); $this->tpl->set_var("tdYPos", $this->formArray["tdYPosValue"]); $this->formArray["totalTaxDue"] += $tdRecord["taxDue"]; $this->tpl->parse("TDListBlock", "TDList", true); $this->formArray["tdYPosValue"]-=15; } */ } $this->setForm(); /* $this->setPageDetailPerms(); $this->tpl->set_var("uname", $this->user["uname"]); $this->tpl->set_var("today", date("F j, Y",strtotime($this->now))); $this->tpl->set_var("Session", $this->sess->url("").$this->sess->add_query(array("rptopID"=>$this->formArray["rptopID"],"ownerID" => $this->formArray["ownerID"]))); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); */ $this->tpl->set_var("today", date("F j, Y", strtotime($this->now))); $this->setLguDetails(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } // header("location: ".$testpdf->pdfPath); exit; }
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"); }
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"); }
function Main() { switch ($this->formArray["formAction"]) { case "remove": //echo "removeOwnerRPTOP(".$this->formArray["rptopID"].",".$this->formArray["ownerID"].",".$this->formArray["personID"].",".$this->formArray["companyID"].")"; $OwnerList = new SoapObject(NCCBIZ . "OwnerList.php", "urn:Object"); if (count($this->formArray["personID"]) || count($this->formArray["companyID"])) { if (!($deletedRows = $OwnerList->removeOwnerRPTOP($this->formArray["rptopID"], $this->formArray["ownerID"], $this->formArray["personID"], $this->formArray["companyID"]))) { $this->tpl->set_var("msg", "SOAP failed"); //echo "SOAP failed"; } else { $this->tpl->set_var("msg", $deletedRows . " records deleted"); } } else { $this->tpl->set_var("msg", "0 records deleted"); } header("location: RPTOPDetails.php" . $this->sess->url("") . $this->sess->add_query(array("rptopID" => $this->formArray["rptopID"]))); exit; break; default: $this->tpl->set_var("msg", ""); } //select $RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object"); if (!($xmlStr = $RPTOPDetails->getRPTOP($this->formArray["rptopID"]))) { exit("xml failed"); } else { //echo($xmlStr); if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); $this->tpl->set_var("OwnerListTableBlock", "error xmlDoc"); } else { $rptop = new RPTOP(); $rptop->parseDomDocument($domDoc); //print_r($rptop); foreach ($rptop as $key => $value) { switch ($key) { case "owner": //$RPTOPEncode = new SoapObject(NCCBIZ."RPTOPEncode.php", "urn:Object"); if (is_a($value, "Owner")) { $this->formArray["ownerID"] = $rptop->owner->getOwnerID(); $xmlStr = $rptop->owner->domDocument->dump_mem(true); if (!$xmlStr) { $this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); $this->tpl->set_var("OwnerListTableBlock", ""); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); $this->tpl->set_var("OwnerListTableBlock", "error xmlDoc"); } else { $this->displayOwnerList($domDoc); } } } else { $this->tpl->set_block("rptsTemplate", "PersonList", "PersonListBlock"); $this->tpl->set_var("PersonListBlock", ""); $this->tpl->set_block("rptsTemplate", "CompanyList", "CompanyListBlock"); $this->tpl->set_var("CompanyListBlock", ""); } break; case "cityAssessor": if (is_numeric($value)) { $cityAssessor = new Person(); $cityAssessor->selectRecord($value); $this->tpl->set_var("cityAssessorID", $cityAssessor->getPersonID()); $this->tpl->set_var("cityAssessorName", $cityAssessor->getFullName()); $this->formArray["cityAssessorName"] = $cityAssessor->getFullName(); } else { $cityAssessor = $value; $this->tpl->set_var("cityAssessorID", $cityAssessor); $this->tpl->set_var("cityAssessorName", $cityAssessor); $this->formArray["cityAssessorName"] = $cityAssessor; } break; case "cityTreasurer": if (is_numeric($value)) { $cityTreasurer = new Person(); $cityTreasurer->selectRecord($value); $this->tpl->set_var("cityTreasurerID", $cityTreasurer->getPersonID()); $this->tpl->set_var("cityTreasurerName", $cityTreasurer->getFullName()); $this->formArray["cityTreasurerName"] = $cityTreasurer->getFullName(); } else { $cityTreasurer = $value; $this->tpl->set_var("cityTreasurerID", $cityTreasurer); $this->tpl->set_var("cityTreasurerName", $cityTreasurer); $this->formArray["cityTreasurerName"] = $cityTreasurer; } break; case "tdArray": $this->tpl->set_block("rptsTemplate", "defaultTDList", "defaultTDListBlock"); $this->tpl->set_block("rptsTemplate", "toggleTDList", "toggleTDListBlock"); $this->tpl->set_block("rptsTemplate", "TDList", "TDListBlock"); $tdCtr = 0; if (count($value)) { $this->tpl->set_block("rptsTemplate", "TDDBEmpty", "TDDBEmptyBlock"); $this->tpl->set_var("TDDBEmptyBlock", ""); /* $this->tpl->set_block("TDList", "Land", "LandBlock"); $this->tpl->set_block("TDList", "PlantsTrees", "PlantsTreesBlock"); $this->tpl->set_block("TDList", "ImprovementsBuildings", "ImprovementsBuildingsBlock"); $this->tpl->set_block("TDList", "Machineries", "MachineriesBlock"); */ foreach ($value as $tkey => $tvalue) { //foreach($tvalue as $column => $val){ // $this->tpl->set_var($column,$val); //} $this->tpl->set_var("tdID", $tvalue->getTDID()); $this->tpl->set_var("taxDeclarationNumber", $tvalue->getTaxDeclarationNumber()); $this->tpl->set_var("afsID", $tvalue->getAfsID()); $this->tpl->set_var("cancelsTDNumber", $tvalue->getCancelsTDNumber()); $this->tpl->set_var("canceledByTDNumber", $tvalue->getCanceledByTDNumber()); $this->tpl->set_var("taxBeginsWithTheYear", $tvalue->getTaxBeginsWithTheYear()); $this->tpl->set_var("ceasesWithTheYear", $tvalue->getCeasesWithTheYear()); $this->tpl->set_var("enteredInRPARForBy", $tvalue->getEnteredInRPARForBy()); $this->tpl->set_var("enteredInRPARForYear", $tvalue->getEnteredInRPARForYear()); $this->tpl->set_var("previousOwner", $tvalue->getPreviousOwner()); $this->tpl->set_var("previousAssessedValue", $tvalue->getPreviousAssessedValue()); list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $tvalue->getProvincialAssessorDate()); $this->tpl->set_var("pa_yearValue", removePreZero($dateArr["year"])); $this->tpl->set_var("pa_month", removePreZero($dateArr["month"])); $this->tpl->set_var("pa_dayValue", removePreZero($dateArr["day"])); list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $tvalue->getCityMunicipalAssessorDate()); $this->tpl->set_var("cm_yearValue", removePreZero($dateArr["year"])); $this->tpl->set_var("cm_month", removePreZero($dateArr["month"])); $this->tpl->set_var("cm_dayValue", removePreZero($dateArr["day"])); $this->tpl->set_var("provincialAssessorName", $tvalue->provincialAssessor); $this->tpl->set_var("cityMunicipalAssessorName", $tvalue->cityMunicipalAssessor); //$this->tpl->set_var("assessedValue",$tvalue->getAssessedValue()); $this->tpl->set_var("propertyType", $tvalue->getPropertyType()); $this->tpl->set_var("basicTax", ""); $this->tpl->set_var("sefTax", ""); $this->tpl->set_var("total", ""); //$this->tpl->set_var("basicTax",$tvalue->getBasicTax()); //$this->tpl->set_var("sefTax",$tvalue->getSefTax()); //$this->tpl->set_var("total",$tvalue->getTotal()); $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($tvalue->getAfsID()))) { //$this->tpl->set_block("rptsTemplate", "AFSTable", "AFSTableBlock"); //$this->tpl->set_var("AFSTableBlock", "afs not found"); } else { //echo $xmlStr; if (!($domDoc = domxml_open_mem($xmlStr))) { //$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); //$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->formArray["landTotalMarketValue"] += $afs->getLandTotalMarketValue(); $this->formArray["landTotalAssessedValue"] += $afs->getLandTotalAssessedValue(); $this->formArray["plantTotalMarketValue"] += $afs->getPlantTotalMarketValue(); $this->formArray["plantTotalAssessedValue"] += $afs->getPlantTotalAssessedValue(); $this->formArray["bldgTotalMarketValue"] += $afs->getBldgTotalMarketValue(); $this->formArray["bldgTotalAssessedValue"] += $afs->getBldgTotalAssessedValue(); $this->formArray["machTotalMarketValue"] += $afs->getMachTotalMarketValue(); $this->formArray["machTotalAssessedValue"] += $afs->getMachTotalAssessedValue(); $this->formArray["totalMarketValue"] += $afs->getTotalMarketValue(); $this->formArray["totalAssessedValue"] += $afs->getTotalAssessedValue(); $this->tpl->set_var("marketValue", number_format($afs->getTotalMarketValue(), 2, '.', ',')); $this->tpl->set_var("assessedValue", number_format($afs->getTotalAssessedValue(), 2, '.', ',')); $this->tpl->set_var("taxability", $afs->getTaxability()); $this->tpl->set_var("effectivity", $afs->getEffectivity()); $this->formArray["idle"] = "No"; if ($tvalue->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"; } $this->tpl->set_var("idle", $this->formArray["idle"]); } } // grab DueRecords from tdID $this->formArray["totalTaxDue"] = 0.0; $DueList = new SoapObject(NCCBIZ . "DueList.php", "urn:Object"); $dueArrayList = array("Annual" => "", "Q1" => "", "Q2" => "", "Q3" => "", "Q4" => ""); if (!($xmlStr = $DueList->getDueList($tvalue->getTdID()))) { foreach ($dueArrayList as $dueKey => $dueValue) { $this->tpl->set_var("basicTax[" . $dueKey . "]", "uncalculated"); $this->tpl->set_var("sefTax[" . $dueKey . "]", "uncalculated"); $this->tpl->set_var("idleTax[" . $dueKey . "]", "uncalculated"); $this->tpl->set_var("taxDue[" . $dueKey . "]", "uncalculated"); $this->tpl->set_var("dueDate[" . $dueKey . "]", "-"); } } else { if (!($domDoc = domxml_open_mem($xmlStr))) { foreach ($dueArrayList as $dueKey => $dueValue) { $this->tpl->set_var("basicTax[" . $dueKey . "]", "uncalculated"); $this->tpl->set_var("sefTax[" . $dueKey . "]", "uncalculated"); $this->tpl->set_var("idleTax[" . $dueKey . "]", "uncalculated"); $this->tpl->set_var("taxDue[" . $dueKey . "]", "uncalculated"); $this->tpl->set_var("dueDate[" . $dueKey . "]", "-"); } } else { $dueRecords = new DueRecords(); $dueRecords->parseDomDocument($domDoc); foreach ($dueRecords->getArrayList() as $due) { foreach ($due as $dueKey => $dueValue) { switch ($dueKey) { case "dueType": if ($dueValue == "Annual") { $this->formArray["totalTaxDue"] += $due->getTaxDue(); } $dueArrayList[$dueValue] = $due; $this->tpl->set_var("basicTax[" . $dueValue . "]", formatCurrency($due->getBasicTax())); $this->tpl->set_var("sefTax[" . $dueValue . "]", formatCurrency($due->getSEFTax())); $this->tpl->set_var("idleTax[" . $dueValue . "]", formatCurrency($due->getIdleTax())); $this->tpl->set_var("taxDue[" . $dueValue . "]", formatCurrency($due->getTaxDue())); $this->tpl->set_var("dueDate[" . $dueValue . "]", date("M. d, Y", strtotime($due->getDueDate()))); break; } } } $treasurySettings = new TreasurySettings(); $treasurySettings->selectRecord(); // initialize discountPeriod and discountPercentage for earlyPaymentDiscount $this->tpl->set_var("discountPercentage", $treasurySettings->getDiscountPercentage() . "%"); $this->tpl->set_var("discountPeriod", "January 01, " . date("Y") . " - " . date("F d, Y", strtotime(date("Y") . "-" . $treasurySettings->getDiscountPeriod()))); $this->formArray["discountPercentage"] = $treasurySettings->getDiscountPercentage(); $this->formArray["discountPeriod"] = $treasurySettings->getDiscountPeriod(); $this->formArray["discountPeriod_End"] = strtotime(date("Y") . "-" . $this->formArray["discountPeriod"]); $this->formArray["discountPeriod_Start"] = strtotime(date("Y") . "-01-01"); // initialize penaltyLUTArray $penaltyLUTArray = $treasurySettings->getPenaltyLUT(); foreach ($dueArrayList as $dKey => $due) { $dueArrayList[$dKey]->setEarlyPaymentDiscountPeriod($this->formArray["discountPeriod"]); $dueArrayList[$dKey]->setEarlyPaymentDiscountPercentage($this->formArray["discountPercentage"]); // compute earlyPaymentDiscount as of today // check if today is within the discountPeriod and compute Discount if (strtotime($this->now) >= $this->formArray["discountPeriod_Start"] && strtotime($this->now) <= $this->formArray["discountPeriod_End"]) { $dueArrayList[$dKey]->setEarlyPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["discountPercentage"] / 100)); } else { $dueArrayList[$dKey]->setEarlyPaymentDiscount(0.0); } // compute Penalty as of today // check if today is exceeding dueDate and compute penalty if (strtotime($this->now) > strtotime($dueArrayList[$dKey]->getDueDate())) { // count months // numYears = today[year] - dueDate[year] $numYears = date("Y", strtotime($this->now)) - date("Y", strtotime($dueArrayList[$dKey]->getDueDate())); // numMonths = today[month] - dueDate[month] $numMonths = date("n", strtotime($this->now)) - date("n", strtotime($dueArrayList[$dKey]->getDueDate())); // totalMonths = (numYears*12) + numMonths $totalMonths = $numYears * 12 + $numMonths; // associate penaltyPercentage if ($totalMonths >= count($penaltyLUTArray)) { $penaltyPercentage = 0.72; } else { $penaltyPercentage = $penaltyLUTArray[$totalMonths]; } $penalty = $dueArrayList[$dKey]->getTaxDue() * $penaltyPercentage; $dueArrayList[$dKey]->setMonthsOverDue($totalMonths); $dueArrayList[$dKey]->setPenaltyPercentage($penaltyPercentage); $dueArrayList[$dKey]->setPenalty($penalty); } else { $dueArrayList[$dKey]->setMonthsOverDue(0); $dueArrayList[$dKey]->setPenaltyPercentage(0.0); $dueArrayList[$dKey]->setPenalty(0.0); } $this->tpl->set_var("earlyPaymentDiscount[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getEarlyPaymentDiscount())); $this->tpl->set_var("monthsOverDue[" . $dKey . "]", $dueArrayList[$dKey]->getMonthsOverDue()); $this->tpl->set_var("penaltyPercentage[" . $dKey . "]", $dueArrayList[$dKey]->getPenaltyPercentage() * 100); $this->tpl->set_var("penalty[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getPenalty())); } $this->tpl->set_var("netDue", formatCurrency($dueArrayList["Annual"]->getNetDue())); } } $this->tpl->set_var("ctr", $tdCtr); $this->tpl->parse("defaultTDListBlock", "defaultTDList", true); $this->tpl->parse("toggleTDListBlock", "toggleTDList", true); $this->tpl->parse("TDListBlock", "TDList", true); /* $this->tpl->set_var("LandBlock", ""); $this->tpl->set_var("PlantsTreesBlock", ""); $this->tpl->set_var("ImprovementsBuildingsBlock", ""); $this->tpl->set_var("MachineriesBlock", ""); */ $tdCtr++; } } else { $this->tpl->set_var("defaultTDListBlock", "//no default"); $this->tpl->set_var("toggleTDListBlock", "//no Toggle"); $this->tpl->set_var("TDListBlock", ""); } $this->tpl->set_var("tdCtr", $tdCtr); break; case "landTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "landTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "plantTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "plantTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "bldgTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "bldgTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "machTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "machTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "totalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "totalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; default: $this->formArray[$key] = $value; } } $this->formArray["totalMarketValue"] = $this->formArray["landTotalMarketValue"] + $this->formArray["plantTotalMarketValue"] + $this->formArray["bldgTotalMarketValue"] + $this->formArray["machTotalMarketValue"]; $this->formArray["totalAssessedValue"] = $this->formArray["landTotalAssessedValue"] + $this->formArray["plantTotalAssessedValue"] + $this->formArray["bldgTotalAssessedValue"] + $this->formArray["machTotalAssessedValue"]; unset($rptop); $AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object"); $rptop = new RPTOP(); $rptop->setRptopID($this->formArray["rptopID"]); $rptop->setLandTotalMarketValue($this->formArray["landTotalMarketValue"]); $rptop->setLandTotalAssessedValue($this->formArray["landTotalAssessedValue"]); $rptop->setPlantTotalMarketValue($this->formArray["plantTotalMarketValue"]); $rptop->setPlantTotalPlantAssessedValue($this->formArray["plantTotalAssessedValue"]); $rptop->setBldgTotalMarketValue($this->formArray["bldgTotalMarketValue"]); $rptop->setBldgTotalAssessedValue($this->formArray["bldgTotalAssessedValue"]); $rptop->setMachTotalMarketValue($this->formArray["machTotalMarketValue"]); $rptop->setMachTotalAssessedValue($this->formArray["machTotalAssessedValue"]); $rptop->setTotalMarketValue($this->formArray["totalMarketValue"]); $rptop->setTotalAssessedValue($this->formArray["totalAssessedValue"]); $rptop->setCreatedBy($this->userID); $rptop->setModifiedBy($this->userID); $rptop->setDomDocument(); $RPTOPEncode = new SoapObject(NCCBIZ . "RPTOPEncode.php", "urn:Object"); $rptop->setDomDocument(); $doc = $rptop->getDomDocument(); $xmlStr = $doc->dump_mem(true); //echo $xmlStr; if (!($ret = $RPTOPEncode->updateRPTOPtotals($xmlStr))) { echo "ret=" . $ret; } //echo $ret; } } $this->setForm(); $this->setPageDetailPerms(); $this->tpl->set_var("uname", $this->user["uname"]); $this->tpl->set_var("today", date("F j, Y", strtotime($this->now))); $this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("rptopID" => $this->formArray["rptopID"], "ownerID" => $this->formArray["ownerID"]))); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { global $DBid; $this->tpl->set_var("Session", $this->sess->url("")); $this->tpl->set_var("date", date("F d, Y")); $this->subRETaxableRealPropertyUnits = 0; $this->subRETaxableLandArea = 0; $this->subAGTaxableRealPropertyUnits = 0; $this->subAGTaxableLandArea = 0; $this->subCOTaxableRealPropertyUnits = 0; $this->subCOTaxableLandArea = 0; $this->subINTaxableRealPropertyUnits = 0; $this->subINTaxableLandArea = 0; $this->subMITaxableRealPropertyUnits = 0; $this->subMITaxableLandArea = 0; $this->subTITaxableRealPropertyUnits = 0; $this->subTITaxableLandArea = 0; $this->subSPTaxableRealPropertyUnits = 0; $this->subSPTaxableLandArea = 0; $this->subHOTaxableRealPropertyUnits = 0; $this->subHOTaxableLandArea = 0; $this->subSCTaxableRealPropertyUnits = 0; $this->subSCTaxableLandArea = 0; $this->subCUTaxableRealPropertyUnits = 0; $this->subCUTaxableLandArea = 0; $this->subOTTaxableRealPropertyUnits = 0; $this->subOTTaxableLandArea = 0; $this->subGOExemptRealPropertyUnits = 0; $this->subGOExemptLandArea = 0; $this->subRLExemptRealPropertyUnits = 0; $this->subRLExemptLandArea = 0; $this->subCHExemptRealPropertyUnits = 0; $this->subCHExemptLandArea = 0; $this->subEDExemptRealPropertyUnits = 0; $this->subEDExemptLandArea = 0; $this->subOTExemptRealPropertyUnits = 0; $this->subOTExemptLandArea = 0; $this->subRETaxableLandMarketValue = 0; $this->subRETaxableLandAssessedValue = 0; $this->subAGTaxableLandMarketValue = 0; $this->subAGTaxableLandAssessedValue = 0; $this->subCOTaxableLandMarketValue = 0; $this->subCOTaxableLandAssessedValue = 0; $this->subINTaxableLandMarketValue = 0; $this->subINTaxableLandAssessedValue = 0; $this->subMITaxableLandMarketValue = 0; $this->subMITaxableLandAssessedValue = 0; $this->subTITaxableLandMarketValue = 0; $this->subTITaxableLandAssessedValue = 0; $this->subSPTaxableLandMarketValue = 0; $this->subSPTaxableLandAssessedValue = 0; $this->subHOTaxableLandMarketValue = 0; $this->subHOTaxableLandAssessedValue = 0; $this->subSCTaxableLandMarketValue = 0; $this->subSCTaxableLandAssessedValue = 0; $this->subCUTaxableLandMarketValue = 0; $this->subCUTaxableLandAssessedValue = 0; $this->subOTTaxableLandMarketValue = 0; $this->subOTTaxableLandAssessedValue = 0; $this->subGOExemptLandMarketValue = 0; $this->subGOExemptLandAssessedValue = 0; $this->subRLExemptLandMarketValue = 0; $this->subRLExemptLandAssessedValue = 0; $this->subCHExemptLandMarketValue = 0; $this->subCHExemptLandAssessedValue = 0; $this->subEDExemptLandMarketValue = 0; $this->subEDExemptLandAssessedValue = 0; $this->subOTExemptLandMarketValue = 0; $this->subOTExemptLandAssessedValue = 0; $this->subRETaxableBldgLessMarketValue = 0; $this->subRETaxableBldgLessAssessedValue = 0; $this->subAGTaxableBldgLessMarketValue = 0; $this->subAGTaxableBldgLessAssessedValue = 0; $this->subCOTaxableBldgLessMarketValue = 0; $this->subCOTaxableBldgLessAssessedValue = 0; $this->subINTaxableBldgLessMarketValue = 0; $this->subINTaxableBldgLessAssessedValue = 0; $this->subMITaxableBldgLessMarketValue = 0; $this->subMITaxableBldgLessAssessedValue = 0; $this->subTITaxableBldgLessMarketValue = 0; $this->subTITaxableBldgLessAssessedValue = 0; $this->subSPTaxableBldgLessMarketValue = 0; $this->subSPTaxableBldgLessAssessedValue = 0; $this->subHOTaxableBldgLessMarketValue = 0; $this->subHOTaxableBldgLessAssessedValue = 0; $this->subSCTaxableBldgLessMarketValue = 0; $this->subSCTaxableBldgLessAssessedValue = 0; $this->subCUTaxableBldgLessMarketValue = 0; $this->subCUTaxableBldgLessAssessedValue = 0; $this->subOTTaxableBldgLessMarketValue = 0; $this->subOTTaxableBldgLessAssessedValue = 0; $this->subGOExemptBldgLessMarketValue = 0; $this->subGOExemptBldgLessAssessedValue = 0; $this->subRLExemptBldgLessMarketValue = 0; $this->subRLExemptBldgLessAssessedValue = 0; $this->subCHExemptBldgLessMarketValue = 0; $this->subCHExemptBldgLessAssessedValue = 0; $this->subEDExemptBldgLessMarketValue = 0; $this->subEDExemptBldgLessAssessedValue = 0; $this->subOTExemptBldgLessMarketValue = 0; $this->subOTExemptBldgLessAssessedValue = 0; $this->subRETaxableBldgOverMarketValue = 0; $this->subRETaxableBldgOverAssessedValue = 0; $this->subAGTaxableBldgOverMarketValue = 0; $this->subAGTaxableBldgOverAssessedValue = 0; $this->subCOTaxableBldgOverMarketValue = 0; $this->subCOTaxableBldgOverAssessedValue = 0; $this->subINTaxableBldgOverMarketValue = 0; $this->subINTaxableBldgOverAssessedValue = 0; $this->subMITaxableBldgOverMarketValue = 0; $this->subMITaxableBldgOverAssessedValue = 0; $this->subTITaxableBldgOverMarketValue = 0; $this->subTITaxableBldgOverAssessedValue = 0; $this->subSPTaxableBldgOverMarketValue = 0; $this->subSPTaxableBldgOverAssessedValue = 0; $this->subHOTaxableBldgOverMarketValue = 0; $this->subHOTaxableBldgOverAssessedValue = 0; $this->subSCTaxableBldgOverMarketValue = 0; $this->subSCTaxableBldgOverAssessedValue = 0; $this->subCUTaxableBldgOverMarketValue = 0; $this->subCUTaxableBldgOverAssessedValue = 0; $this->subOTTaxableBldgOverMarketValue = 0; $this->subOTTaxableBldgOverAssessedValue = 0; $this->subGOExemptBldgOverMarketValue = 0; $this->subGOExemptBldgOverAssessedValue = 0; $this->subRLExemptBldgOverMarketValue = 0; $this->subRLExemptBldgOverAssessedValue = 0; $this->subCHExemptBldgOverMarketValue = 0; $this->subCHExemptBldgOverAssessedValue = 0; $this->subEDExemptBldgOverMarketValue = 0; $this->subEDExemptBldgOverAssessedValue = 0; $this->subOTExemptBldgOverMarketValue = 0; $this->subOTExemptBldgOverAssessedValue = 0; $this->subRETaxableMachMarketValue = 0; $this->subRETaxableMachAssessedValue = 0; $this->subAGTaxableMachMarketValue = 0; $this->subAGTaxableMachAssessedValue = 0; $this->subCOTaxableMachMarketValue = 0; $this->subCOTaxableMachAssessedValue = 0; $this->subINTaxableMachMarketValue = 0; $this->subINTaxableMachAssessedValue = 0; $this->subMITaxableMachMarketValue = 0; $this->subMITaxableMachAssessedValue = 0; $this->subTITaxableMachMarketValue = 0; $this->subTITaxableMachAssessedValue = 0; $this->subSPTaxableMachMarketValue = 0; $this->subSPTaxableMachAssessedValue = 0; $this->subHOTaxableMachMarketValue = 0; $this->subHOTaxableMachAssessedValue = 0; $this->subSCTaxableMachMarketValue = 0; $this->subSCTaxableMachAssessedValue = 0; $this->subCUTaxableMachMarketValue = 0; $this->subCUTaxableMachAssessedValue = 0; $this->subOTTaxableMachMarketValue = 0; $this->subOTTaxableMachAssessedValue = 0; $this->subGOExemptMachMarketValue = 0; $this->subGOExemptMachAssessedValue = 0; $this->subRLExemptMachMarketValue = 0; $this->subRLExemptMachAssessedValue = 0; $this->subCHExemptMachMarketValue = 0; $this->subCHExemptMachAssessedValue = 0; $this->subEDExemptMachMarketValue = 0; $this->subEDExemptMachAssessedValue = 0; $this->subOTExemptMachMarketValue = 0; $this->subOTExemptMachAssessedValue = 0; $this->subRETaxableOtherMarketValue = 0; $this->subRETaxableOtherAssessedValue = 0; $this->subAGTaxableOtherMarketValue = 0; $this->subAGTaxableOtherAssessedValue = 0; $this->subCOTaxableOtherMarketValue = 0; $this->subCOTaxableOtherAssessedValue = 0; $this->subINTaxableOtherMarketValue = 0; $this->subINTaxableOtherAssessedValue = 0; $this->subMITaxableOtherMarketValue = 0; $this->subMITaxableOtherAssessedValue = 0; $this->subTITaxableOtherMarketValue = 0; $this->subTITaxableOtherAssessedValue = 0; $this->subSPTaxableOtherMarketValue = 0; $this->subSPTaxableOtherAssessedValue = 0; $this->subHOTaxableOtherMarketValue = 0; $this->subHOTaxableOtherAssessedValue = 0; $this->subSCTaxableOtherMarketValue = 0; $this->subSCTaxableOtherAssessedValue = 0; $this->subCUTaxableOtherMarketValue = 0; $this->subCUTaxableOtherAssessedValue = 0; $this->subOTTaxableOtherMarketValue = 0; $this->subOTTaxableOtherAssessedValue = 0; $this->subGOExemptOtherMarketValue = 0; $this->subGOExemptOtherAssessedValue = 0; $this->subRLExemptOtherMarketValue = 0; $this->subRLExemptOtherAssessedValue = 0; $this->subCHExemptOtherMarketValue = 0; $this->subCHExemptOtherAssessedValue = 0; $this->subEDExemptOtherMarketValue = 0; $this->subEDExemptOtherAssessedValue = 0; $this->subOTExemptOtherMarketValue = 0; $this->subOTExemptOtherAssessedValue = 0; $this->totalRETaxableMarketValue = 0; $this->totalRETaxableAssessedValue = 0; $this->totalAGTaxableMarketValue = 0; $this->totalAGTaxableAssessedValue = 0; $this->totalCOTaxableMarketValue = 0; $this->totalCOTaxableAssessedValue = 0; $this->totalINTaxableMarketValue = 0; $this->totalINTaxableAssessedValue = 0; $this->totalMITaxableMarketValue = 0; $this->totalMITaxableAssessedValue = 0; $this->totalTITaxableMarketValue = 0; $this->totalTITaxableAssessedValue = 0; $this->totalSPTaxableMarketValue = 0; $this->totalSPTaxableAssessedValue = 0; $this->totalHOTaxableMarketValue = 0; $this->totalHOTaxableAssessedValue = 0; $this->totalSCTaxableMarketValue = 0; $this->totalSCTaxableAssessedValue = 0; $this->totalCUTaxableMarketValue = 0; $this->totalCUTaxableAssessedValue = 0; $this->totalOTTaxableMarketValue = 0; $this->totalOTTaxableAssessedValue = 0; $this->totalGOExemptMarketValue = 0; $this->totalGOExemptAssessedValue = 0; $this->totalRLExemptMarketValue = 0; $this->totalRLExemptAssessedValue = 0; $this->totalCHExemptMarketValue = 0; $this->totalCHExemptAssessedValue = 0; $this->totalEDExemptMarketValue = 0; $this->totalEDExemptAssessedValue = 0; $this->totalOTExemptMarketValue = 0; $this->totalOTExemptAssessedValue = 0; $this->totalTaxableRealPropertyUnits = 0; $this->totalTaxableLandArea = 0; $this->totalTaxableLandMarketValue = 0; $this->totalTaxableLandAssessedValue = 0; $this->totalTaxableBldgLessMarketValue = 0; $this->totalTaxableBldgLessAssessedValue = 0; $this->totalTaxableBldgOverMarketValue = 0; $this->totalTaxableBldgOverAssessedValue = 0; $this->totalTaxableMachMarketValue = 0; $this->totalTaxableMachAssessedValue = 0; $this->totalTaxableOtherMarketValue = 0; $this->totalTaxableOtherAssessedValue = 0; $this->totalTaxableMarketValue = 0; $this->totalTaxableAssessedValue = 0; $this->totalExemptRealPropertyUnits = 0; $this->totalExemptLandArea = 0; $this->totalExemptLandMarketValue = 0; $this->totalExemptLandAssessedValue = 0; $this->totalExemptBldgLessMarketValue = 0; $this->totalExemptBldgLessAssessedValue = 0; $this->totalExemptBldgOverMarketValue = 0; $this->totalExemptBldgOverAssessedValue = 0; $this->totalExemptMachMarketValue = 0; $this->totalExemptMachAssessedValue = 0; $this->totalExemptOtherMarketValue = 0; $this->totalExemptOtherAssessedValue = 0; $this->totalExemptMarketValue = 0; $this->totalExemptAssessedValue = 0; $this->totalRealPropertyUnits = 0; $this->totalLandArea = 0; $this->totalLandMarketValue = 0; $this->totalLandAssessedValue = 0; $this->totalBldgLessMarketValue = 0; $this->totalBldgLessAssessedValue = 0; $this->totalBldgOverMarketValue = 0; $this->totalBldgOverAssessedValue = 0; $this->totalMachMarketValue = 0; $this->totalMachAssessedValue = 0; $this->totalOtherMarketValue = 0; $this->totalOtherAssessedValue = 0; $this->totalMarketValue = 0; $this->totalAssessedValue = 0; $ctr = 1; $this->dbs = ""; foreach ($DBid as $key => $value) { $lgu = new LGU(); $lgu->selectRecord($value); $this->dbName = $lgu->getLGUDB(); if ($ctr == 1) { $this->dbs = $lgu->getLGUName(); } else { $this->dbs .= " - " . $lgu->getLGUName(); } $ctr++; $sql = "SELECT a.reportCode as reportCode, b.actualUse, count(b.propertyID) as rpu, sum( b.assessedValue ) as assessedValue, sum( b.adjustedMarketValue ) as adjustedMarketValue, sum(area) as area" . " FROM LandActualUses a" . " LEFT JOIN Land b ON a.landActualUsesID = b.actualUse" . " GROUP BY a.reportCode;"; $this->computeProperty("Land", $sql); $sql = "SELECT a.reportCode as reportCode, b.actualUse, count(b.propertyID), sum( b.assessedValue ) as assessedValue, sum( b.adjustedMarketValue ) as adjustedMarketValue" . " FROM ImprovementsBuildingsActualUses a" . " LEFT JOIN ImprovementsBuildings b ON a.improvementsBuildingsActualUsesID = b.actualUse AND b.adjustedMarketValue <= 175000" . " GROUP BY a.reportCode;"; $this->computeProperty("BldgLess", $sql); $sql = "SELECT a.reportCode as reportCode, b.actualUse, count(b.propertyID), sum( b.assessedValue ) as assessedValue, sum( b.adjustedMarketValue ) as adjustedMarketValue" . " FROM ImprovementsBuildingsActualUses a" . " LEFT JOIN ImprovementsBuildings b ON a.improvementsBuildingsActualUsesID = b.actualUse AND b.adjustedMarketValue > 175000" . " GROUP BY a.reportCode;"; $this->computeProperty("BldgOver", $sql); $sql = "SELECT a.reportCode as reportCode, b.actualUse, count(b.propertyID), sum( b.assessedValue ) as assessedValue, sum( b.adjustedMarketValue ) as adjustedMarketValue" . " FROM MachineriesActualUses a" . " LEFT JOIN Machineries b ON a.machineriesActualUsesID = b.actualUse" . " GROUP BY a.reportCode;"; $this->computeProperty("Mach", $sql); $this->countRealPropertyUnits(); } $this->tpl->set_var("RETaxable_RealPropertyUnits", number_format($this->subRETaxableRealPropertyUnits)); $this->tpl->set_var("RETaxable_LandArea", $this->checkNumericFormat($this->subRETaxableLandArea)); $this->tpl->set_var("AGTaxable_RealPropertyUnits", number_format($this->subAGTaxableRealPropertyUnits)); $this->tpl->set_var("AGTaxable_LandArea", $this->checkNumericFormat($this->subAGTaxableLandArea)); $this->tpl->set_var("COTaxable_RealPropertyUnits", number_format($this->subCOTaxableRealPropertyUnits)); $this->tpl->set_var("COTaxable_LandArea", $this->checkNumericFormat($this->subCOTaxableLandArea)); $this->tpl->set_var("INTaxable_RealPropertyUnits", number_format($this->subINTaxableRealPropertyUnits)); $this->tpl->set_var("INTaxable_LandArea", $this->checkNumericFormat($this->subINTaxableLandArea)); $this->tpl->set_var("MITaxable_RealPropertyUnits", number_format($this->subMITaxableRealPropertyUnits)); $this->tpl->set_var("MITaxable_LandArea", $this->checkNumericFormat($this->subMITaxableLandArea)); $this->tpl->set_var("TITaxable_RealPropertyUnits", number_format($this->subTITaxableRealPropertyUnits)); $this->tpl->set_var("TITaxable_LandArea", $this->checkNumericFormat($this->subTITaxableLandArea)); $this->tpl->set_var("SPTaxable_RealPropertyUnits", number_format($this->subSPTaxableRealPropertyUnits)); $this->tpl->set_var("SPTaxable_LandArea", $this->checkNumericFormat($this->subSPTaxableLandArea)); $this->tpl->set_var("HOTaxable_RealPropertyUnits", number_format($this->subHOTaxableRealPropertyUnits)); $this->tpl->set_var("HOTaxable_LandArea", $this->checkNumericFormat($this->subHOTaxableLandArea)); $this->tpl->set_var("SCTaxable_RealPropertyUnits", number_format($this->subSCTaxableRealPropertyUnits)); $this->tpl->set_var("SCTaxable_LandArea", $this->checkNumericFormat($this->subSCTaxableLandArea)); $this->tpl->set_var("CUTaxable_RealPropertyUnits", number_format($this->subCUTaxableRealPropertyUnits)); $this->tpl->set_var("CUTaxable_LandArea", $this->checkNumericFormat($this->subCUTaxableLandArea)); $this->tpl->set_var("OTTaxable_RealPropertyUnits", number_format($this->subOTTaxableRealPropertyUnits)); $this->tpl->set_var("OTTaxable_LandArea", $this->checkNumericFormat($this->subOTTaxableLandArea)); $this->tpl->set_var("GOExempt_RealPropertyUnits", number_format($this->subGOExemptRealPropertyUnits)); $this->tpl->set_var("GOExempt_LandArea", $this->checkNumericFormat($this->subGOExemptLandArea)); $this->tpl->set_var("RLExempt_RealPropertyUnits", number_format($this->subRLExemptRealPropertyUnits)); $this->tpl->set_var("RLExempt_LandArea", $this->checkNumericFormat($this->subRLExemptLandArea)); $this->tpl->set_var("CHExempt_RealPropertyUnits", number_format($this->subCHExemptRealPropertyUnits)); $this->tpl->set_var("CHExempt_LandArea", $this->checkNumericFormat($this->subCHExemptLandArea)); $this->tpl->set_var("EDExempt_RealPropertyUnits", number_format($this->subEDExemptRealPropertyUnits)); $this->tpl->set_var("EDExempt_LandArea", $this->checkNumericFormat($this->subEDExemptLandArea)); $this->tpl->set_var("OTExempt_RealPropertyUnits", number_format($this->subOTExemptRealPropertyUnits)); $this->tpl->set_var("OTExempt_LandArea", $this->checkNumericFormat($this->subOTExemptLandArea)); $this->tpl->set_var("RETaxable_LandMV", $this->checkNumericFormat($this->subRETaxableLandMarketValue)); $this->tpl->set_var("RETaxable_LandAV", $this->checkNumericFormat($this->subRETaxableLandAssessedValue)); $this->tpl->set_var("AGTaxable_LandMV", $this->checkNumericFormat($this->subAGTaxableLandMarketValue)); $this->tpl->set_var("AGTaxable_LandAV", $this->checkNumericFormat($this->subAGTaxableLandAssessedValue)); $this->tpl->set_var("COTaxable_LandMV", $this->checkNumericFormat($this->subCOTaxableLandMarketValue)); $this->tpl->set_var("COTaxable_LandAV", $this->checkNumericFormat($this->subCOTaxableLandAssessedValue)); $this->tpl->set_var("INTaxable_LandMV", $this->checkNumericFormat($this->subINTaxableLandMarketValue)); $this->tpl->set_var("INTaxable_LandAV", $this->checkNumericFormat($this->subINTaxableLandAssessedValue)); $this->tpl->set_var("MITaxable_LandMV", $this->checkNumericFormat($this->subMITaxableLandMarketValue)); $this->tpl->set_var("MITaxable_LandAV", $this->checkNumericFormat($this->subMITaxableLandAssessedValue)); $this->tpl->set_var("TITaxable_LandMV", $this->checkNumericFormat($this->subTITaxableLandMarketValue)); $this->tpl->set_var("TITaxable_LandAV", $this->checkNumericFormat($this->subTITaxableLandAssessedValue)); $this->tpl->set_var("SPTaxable_LandMV", $this->checkNumericFormat($this->subSPTaxableLandMarketValue)); $this->tpl->set_var("SPTaxable_LandAV", $this->checkNumericFormat($this->subSPTaxableLandAssessedValue)); $this->tpl->set_var("HOTaxable_LandMV", $this->checkNumericFormat($this->subHOTaxableLandMarketValue)); $this->tpl->set_var("HOTaxable_LandAV", $this->checkNumericFormat($this->subHOTaxableLandAssessedValue)); $this->tpl->set_var("SCTaxable_LandMV", $this->checkNumericFormat($this->subSCTaxableLandMarketValue)); $this->tpl->set_var("SCTaxable_LandAV", $this->checkNumericFormat($this->subSCTaxableLandAssessedValue)); $this->tpl->set_var("CUTaxable_LandMV", $this->checkNumericFormat($this->subCUTaxableLandMarketValue)); $this->tpl->set_var("CUTaxable_LandAV", $this->checkNumericFormat($this->subCUTaxableLandAssessedValue)); $this->tpl->set_var("OTTaxable_LandMV", $this->checkNumericFormat($this->subOTTaxableLandMarketValue)); $this->tpl->set_var("OTTaxable_LandAV", $this->checkNumericFormat($this->subOTTaxableLandAssessedValue)); $this->tpl->set_var("GOExempt_LandMV", $this->checkNumericFormat($this->subGOExemptLandMarketValue)); $this->tpl->set_var("GOExempt_LandAV", $this->checkNumericFormat($this->subGOExemptLandAssessedValue)); $this->tpl->set_var("RLExempt_LandMV", $this->checkNumericFormat($this->subRLExemptLandMarketValue)); $this->tpl->set_var("RLExempt_LandAV", $this->checkNumericFormat($this->subRLExemptLandAssessedValue)); $this->tpl->set_var("CHExempt_LandMV", $this->checkNumericFormat($this->subCHExemptLandMarketValue)); $this->tpl->set_var("CHExempt_LandAV", $this->checkNumericFormat($this->subCHExemptLandAssessedValue)); $this->tpl->set_var("EDExempt_LandMV", $this->checkNumericFormat($this->subEDExemptLandMarketValue)); $this->tpl->set_var("EDExempt_LandAV", $this->checkNumericFormat($this->subEDExemptLandAssessedValue)); $this->tpl->set_var("OTExempt_LandMV", $this->checkNumericFormat($this->subOTExemptLandMarketValue)); $this->tpl->set_var("OTExempt_LandAV", $this->checkNumericFormat($this->subOTExemptLandAssessedValue)); $this->tpl->set_var("RETaxable_BldgLessMV", $this->checkNumericFormat($this->subRETaxableBldgLessMarketValue)); $this->tpl->set_var("RETaxable_BldgLessAV", $this->checkNumericFormat($this->subRETaxableBldgLessAssessedValue)); $this->tpl->set_var("AGTaxable_BldgLessMV", $this->checkNumericFormat($this->subAGTaxableBldgLessMarketValue)); $this->tpl->set_var("AGTaxable_BldgLessAV", $this->checkNumericFormat($this->subAGTaxableBldgLessAssessedValue)); $this->tpl->set_var("COTaxable_BldgLessMV", $this->checkNumericFormat($this->subCOTaxableBldgLessMarketValue)); $this->tpl->set_var("COTaxable_BldgLessAV", $this->checkNumericFormat($this->subCOTaxableBldgLessAssessedValue)); $this->tpl->set_var("INTaxable_BldgLessMV", $this->checkNumericFormat($this->subINTaxableBldgLessMarketValue)); $this->tpl->set_var("INTaxable_BldgLessAV", $this->checkNumericFormat($this->subINTaxableBldgLessAssessedValue)); $this->tpl->set_var("MITaxable_BldgLessMV", $this->checkNumericFormat($this->subMITaxableBldgLessMarketValue)); $this->tpl->set_var("MITaxable_BldgLessAV", $this->checkNumericFormat($this->subMITaxableBldgLessAssessedValue)); $this->tpl->set_var("TITaxable_BldgLessMV", $this->checkNumericFormat($this->subTITaxableBldgLessMarketValue)); $this->tpl->set_var("TITaxable_BldgLessAV", $this->checkNumericFormat($this->subTITaxableBldgLessAssessedValue)); $this->tpl->set_var("SPTaxable_BldgLessMV", $this->checkNumericFormat($this->subSPTaxableBldgLessMarketValue)); $this->tpl->set_var("SPTaxable_BldgLessAV", $this->checkNumericFormat($this->subSPTaxableBldgLessAssessedValue)); $this->tpl->set_var("HOTaxable_BldgLessMV", $this->checkNumericFormat($this->subHOTaxableBldgLessMarketValue)); $this->tpl->set_var("HOTaxable_BldgLessAV", $this->checkNumericFormat($this->subHOTaxableBldgLessAssessedValue)); $this->tpl->set_var("SCTaxable_BldgLessMV", $this->checkNumericFormat($this->subSCTaxableBldgLessMarketValue)); $this->tpl->set_var("SCTaxable_BldgLessAV", $this->checkNumericFormat($this->subSCTaxableBldgLessAssessedValue)); $this->tpl->set_var("CUTaxable_BldgLessMV", $this->checkNumericFormat($this->subCUTaxableBldgLessMarketValue)); $this->tpl->set_var("CUTaxable_BldgLessAV", $this->checkNumericFormat($this->subCUTaxableBldgLessAssessedValue)); $this->tpl->set_var("OTTaxable_BldgLessMV", $this->checkNumericFormat($this->subOTTaxableBldgLessMarketValue)); $this->tpl->set_var("OTTaxable_BldgLessAV", $this->checkNumericFormat($this->subOTTaxableBldgLessAssessedValue)); $this->tpl->set_var("GOExempt_BldgLessMV", $this->checkNumericFormat($this->subGOExemptBldgLessMarketValue)); $this->tpl->set_var("GOExempt_BldgLessAV", $this->checkNumericFormat($this->subGOExemptBldgLessAssessedValue)); $this->tpl->set_var("RLExempt_BldgLessMV", $this->checkNumericFormat($this->subRLExemptBldgLessMarketValue)); $this->tpl->set_var("RLExempt_BldgLessAV", $this->checkNumericFormat($this->subRLExemptBldgLessAssessedValue)); $this->tpl->set_var("CHExempt_BldgLessMV", $this->checkNumericFormat($this->subCHExemptBldgLessMarketValue)); $this->tpl->set_var("CHExempt_BldgLessAV", $this->checkNumericFormat($this->subCHExemptBldgLessAssessedValue)); $this->tpl->set_var("EDExempt_BldgLessMV", $this->checkNumericFormat($this->subEDExemptBldgLessMarketValue)); $this->tpl->set_var("EDExempt_BldgLessAV", $this->checkNumericFormat($this->subEDExemptBldgLessAssessedValue)); $this->tpl->set_var("OTExempt_BldgLessMV", $this->checkNumericFormat($this->subOTExemptBldgLessMarketValue)); $this->tpl->set_var("OTExempt_BldgLessAV", $this->checkNumericFormat($this->subOTExemptBldgLessAssessedValue)); $this->tpl->set_var("RETaxable_BldgOverMV", $this->checkNumericFormat($this->subRETaxableBldgOverMarketValue)); $this->tpl->set_var("RETaxable_BldgOverAV", $this->checkNumericFormat($this->subRETaxableBldgOverAssessedValue)); $this->tpl->set_var("AGTaxable_BldgOverMV", $this->checkNumericFormat($this->subAGTaxableBldgOverMarketValue)); $this->tpl->set_var("AGTaxable_BldgOverAV", $this->checkNumericFormat($this->subAGTaxableBldgOverAssessedValue)); $this->tpl->set_var("COTaxable_BldgOverMV", $this->checkNumericFormat($this->subCOTaxableBldgOverMarketValue)); $this->tpl->set_var("COTaxable_BldgOverAV", $this->checkNumericFormat($this->subCOTaxableBldgOverAssessedValue)); $this->tpl->set_var("INTaxable_BldgOverMV", $this->checkNumericFormat($this->subINTaxableBldgOverMarketValue)); $this->tpl->set_var("INTaxable_BldgOverAV", $this->checkNumericFormat($this->subINTaxableBldgOverAssessedValue)); $this->tpl->set_var("MITaxable_BldgOverMV", $this->checkNumericFormat($this->subMITaxableBldgOverMarketValue)); $this->tpl->set_var("MITaxable_BldgOverAV", $this->checkNumericFormat($this->subMITaxableBldgOverAssessedValue)); $this->tpl->set_var("TITaxable_BldgOverMV", $this->checkNumericFormat($this->subTITaxableBldgOverMarketValue)); $this->tpl->set_var("TITaxable_BldgOverAV", $this->checkNumericFormat($this->subTITaxableBldgOverAssessedValue)); $this->tpl->set_var("SPTaxable_BldgOverMV", $this->checkNumericFormat($this->subSPTaxableBldgOverMarketValue)); $this->tpl->set_var("SPTaxable_BldgOverAV", $this->checkNumericFormat($this->subSPTaxableBldgOverAssessedValue)); $this->tpl->set_var("HOTaxable_BldgOverMV", $this->checkNumericFormat($this->subHOTaxableBldgOverMarketValue)); $this->tpl->set_var("HOTaxable_BldgOverAV", $this->checkNumericFormat($this->subHOTaxableBldgOverAssessedValue)); $this->tpl->set_var("SCTaxable_BldgOverMV", $this->checkNumericFormat($this->subSCTaxableBldgOverMarketValue)); $this->tpl->set_var("SCTaxable_BldgOverAV", $this->checkNumericFormat($this->subSCTaxableBldgOverAssessedValue)); $this->tpl->set_var("CUTaxable_BldgOverMV", $this->checkNumericFormat($this->subCUTaxableBldgOverMarketValue)); $this->tpl->set_var("CUTaxable_BldgOverAV", $this->checkNumericFormat($this->subCUTaxableBldgOverAssessedValue)); $this->tpl->set_var("OTTaxable_BldgOverMV", $this->checkNumericFormat($this->subOTTaxableBldgOverMarketValue)); $this->tpl->set_var("OTTaxable_BldgOverAV", $this->checkNumericFormat($this->subOTTaxableBldgOverAssessedValue)); $this->tpl->set_var("GOExempt_BldgOverMV", $this->checkNumericFormat($this->subGOExemptBldgOverMarketValue)); $this->tpl->set_var("GOExempt_BldgOverAV", $this->checkNumericFormat($this->subGOExemptBldgOverAssessedValue)); $this->tpl->set_var("RLExempt_BldgOverMV", $this->checkNumericFormat($this->subRLExemptBldgOverMarketValue)); $this->tpl->set_var("RLExempt_BldgOverAV", $this->checkNumericFormat($this->subRLExemptBldgOverAssessedValue)); $this->tpl->set_var("CHExempt_BldgOverMV", $this->checkNumericFormat($this->subCHExemptBldgOverMarketValue)); $this->tpl->set_var("CHExempt_BldgOverAV", $this->checkNumericFormat($this->subCHExemptBldgOverAssessedValue)); $this->tpl->set_var("EDExempt_BldgOverMV", $this->checkNumericFormat($this->subEDExemptBldgOverMarketValue)); $this->tpl->set_var("EDExempt_BldgOverAV", $this->checkNumericFormat($this->subEDExemptBldgOverAssessedValue)); $this->tpl->set_var("OTExempt_BldgOverMV", $this->checkNumericFormat($this->subOTExemptBldgOverMarketValue)); $this->tpl->set_var("OTExempt_BldgOverAV", $this->checkNumericFormat($this->subOTExemptBldgOverAssessedValue)); $this->tpl->set_var("RETaxable_MachMV", $this->checkNumericFormat($this->subRETaxableMachMarketValue)); $this->tpl->set_var("RETaxable_MachAV", $this->checkNumericFormat($this->subRETaxableMachAssessedValue)); $this->tpl->set_var("AGTaxable_MachMV", $this->checkNumericFormat($this->subAGTaxableMachMarketValue)); $this->tpl->set_var("AGTaxable_MachAV", $this->checkNumericFormat($this->subAGTaxableMachAssessedValue)); $this->tpl->set_var("COTaxable_MachMV", $this->checkNumericFormat($this->subCOTaxableMachMarketValue)); $this->tpl->set_var("COTaxable_MachAV", $this->checkNumericFormat($this->subCOTaxableMachAssessedValue)); $this->tpl->set_var("INTaxable_MachMV", $this->checkNumericFormat($this->subINTaxableMachMarketValue)); $this->tpl->set_var("INTaxable_MachAV", $this->checkNumericFormat($this->subINTaxableMachAssessedValue)); $this->tpl->set_var("MITaxable_MachMV", $this->checkNumericFormat($this->subMITaxableMachMarketValue)); $this->tpl->set_var("MITaxable_MachAV", $this->checkNumericFormat($this->subMITaxableMachAssessedValue)); $this->tpl->set_var("TITaxable_MachMV", $this->checkNumericFormat($this->subTITaxableMachMarketValue)); $this->tpl->set_var("TITaxable_MachAV", $this->checkNumericFormat($this->subTITaxableMachAssessedValue)); $this->tpl->set_var("SPTaxable_MachMV", $this->checkNumericFormat($this->subSPTaxableMachMarketValue)); $this->tpl->set_var("SPTaxable_MachAV", $this->checkNumericFormat($this->subSPTaxableMachAssessedValue)); $this->tpl->set_var("HOTaxable_MachMV", $this->checkNumericFormat($this->subHOTaxableMachMarketValue)); $this->tpl->set_var("HOTaxable_MachAV", $this->checkNumericFormat($this->subHOTaxableMachAssessedValue)); $this->tpl->set_var("SCTaxable_MachMV", $this->checkNumericFormat($this->subSCTaxableMachMarketValue)); $this->tpl->set_var("SCTaxable_MachAV", $this->checkNumericFormat($this->subSCTaxableMachAssessedValue)); $this->tpl->set_var("CUTaxable_MachMV", $this->checkNumericFormat($this->subCUTaxableMachMarketValue)); $this->tpl->set_var("CUTaxable_MachAV", $this->checkNumericFormat($this->subCUTaxableMachAssessedValue)); $this->tpl->set_var("OTTaxable_MachMV", $this->checkNumericFormat($this->subOTTaxableMachMarketValue)); $this->tpl->set_var("OTTaxable_MachAV", $this->checkNumericFormat($this->subOTTaxableMachAssessedValue)); $this->tpl->set_var("GOExempt_MachMV", $this->checkNumericFormat($this->subGOExemptMachMarketValue)); $this->tpl->set_var("GOExempt_MachAV", $this->checkNumericFormat($this->subGOExemptMachAssessedValue)); $this->tpl->set_var("RLExempt_MachMV", $this->checkNumericFormat($this->subRLExemptMachMarketValue)); $this->tpl->set_var("RLExempt_MachAV", $this->checkNumericFormat($this->subRLExemptMachAssessedValue)); $this->tpl->set_var("CHExempt_MachMV", $this->checkNumericFormat($this->subCHExemptMachMarketValue)); $this->tpl->set_var("CHExempt_MachAV", $this->checkNumericFormat($this->subCHExemptMachAssessedValue)); $this->tpl->set_var("EDExempt_MachMV", $this->checkNumericFormat($this->subEDExemptMachMarketValue)); $this->tpl->set_var("EDExempt_MachAV", $this->checkNumericFormat($this->subEDExemptMachAssessedValue)); $this->tpl->set_var("OTExempt_MachMV", $this->checkNumericFormat($this->subOTExemptMachMarketValue)); $this->tpl->set_var("OTExempt_MachAV", $this->checkNumericFormat($this->subOTExemptMachAssessedValue)); $this->tpl->set_var("RETaxable_OtherMV", $this->checkNumericFormat($this->subRETaxableOtherMarketValue)); $this->tpl->set_var("RETaxable_OtherAV", $this->checkNumericFormat($this->subRETaxableOtherAssessedValue)); $this->tpl->set_var("AGTaxable_OtherMV", $this->checkNumericFormat($this->subAGTaxableOtherMarketValue)); $this->tpl->set_var("AGTaxable_OtherAV", $this->checkNumericFormat($this->subAGTaxableOtherAssessedValue)); $this->tpl->set_var("COTaxable_OtherMV", $this->checkNumericFormat($this->subCOTaxableOtherMarketValue)); $this->tpl->set_var("COTaxable_OtherAV", $this->checkNumericFormat($this->subCOTaxableOtherAssessedValue)); $this->tpl->set_var("INTaxable_OtherMV", $this->checkNumericFormat($this->subINTaxableOtherMarketValue)); $this->tpl->set_var("INTaxable_OtherAV", $this->checkNumericFormat($this->subINTaxableOtherAssessedValue)); $this->tpl->set_var("MITaxable_OtherMV", $this->checkNumericFormat($this->subMITaxableOtherMarketValue)); $this->tpl->set_var("MITaxable_OtherAV", $this->checkNumericFormat($this->subMITaxableOtherAssessedValue)); $this->tpl->set_var("TITaxable_OtherMV", $this->checkNumericFormat($this->subTITaxableOtherMarketValue)); $this->tpl->set_var("TITaxable_OtherAV", $this->checkNumericFormat($this->subTITaxableOtherAssessedValue)); $this->tpl->set_var("SPTaxable_OtherMV", $this->checkNumericFormat($this->subSPTaxableOtherMarketValue)); $this->tpl->set_var("SPTaxable_OtherAV", $this->checkNumericFormat($this->subSPTaxableOtherAssessedValue)); $this->tpl->set_var("HOTaxable_OtherMV", $this->checkNumericFormat($this->subHOTaxableOtherMarketValue)); $this->tpl->set_var("HOTaxable_OtherAV", $this->checkNumericFormat($this->subHOTaxableOtherAssessedValue)); $this->tpl->set_var("SCTaxable_OtherMV", $this->checkNumericFormat($this->subSCTaxableOtherMarketValue)); $this->tpl->set_var("SCTaxable_OtherAV", $this->checkNumericFormat($this->subSCTaxableOtherAssessedValue)); $this->tpl->set_var("CUTaxable_OtherMV", $this->checkNumericFormat($this->subCUTaxableOtherMarketValue)); $this->tpl->set_var("CUTaxable_OtherAV", $this->checkNumericFormat($this->subCUTaxableOtherAssessedValue)); $this->tpl->set_var("OTTaxable_OtherMV", $this->checkNumericFormat($this->subOTTaxableOtherMarketValue)); $this->tpl->set_var("OTTaxable_OtherAV", $this->checkNumericFormat($this->subOTTaxableOtherAssessedValue)); $this->tpl->set_var("GOExempt_OtherMV", $this->checkNumericFormat($this->subGOExemptOtherMarketValue)); $this->tpl->set_var("GOExempt_OtherAV", $this->checkNumericFormat($this->subGOExemptOtherAssessedValue)); $this->tpl->set_var("RLExempt_OtherMV", $this->checkNumericFormat($this->subRLExemptOtherMarketValue)); $this->tpl->set_var("RLExempt_OtherAV", $this->checkNumericFormat($this->subRLExemptOtherAssessedValue)); $this->tpl->set_var("CHExempt_OtherMV", $this->checkNumericFormat($this->subCHExemptOtherMarketValue)); $this->tpl->set_var("CHExempt_OtherAV", $this->checkNumericFormat($this->subCHExemptOtherAssessedValue)); $this->tpl->set_var("EDExempt_OtherMV", $this->checkNumericFormat($this->subEDExemptOtherMarketValue)); $this->tpl->set_var("EDExempt_OtherAV", $this->checkNumericFormat($this->subEDExemptOtherAssessedValue)); $this->tpl->set_var("OTExempt_OtherMV", $this->checkNumericFormat($this->subOTExemptOtherMarketValue)); $this->tpl->set_var("OTExempt_OtherAV", $this->checkNumericFormat($this->subOTExemptOtherAssessedValue)); $this->tpl->set_var("RETaxable_TotalMV", $this->checkNumericFormat($this->totalRETaxableMarketValue)); $this->tpl->set_var("RETaxable_TotalAV", $this->checkNumericFormat($this->totalRETaxableAssessedValue)); $this->tpl->set_var("AGTaxable_TotalMV", $this->checkNumericFormat($this->totalAGTaxableMarketValue)); $this->tpl->set_var("AGTaxable_TotalAV", $this->checkNumericFormat($this->totalAGTaxableAssessedValue)); $this->tpl->set_var("COTaxable_TotalMV", $this->checkNumericFormat($this->totalCOTaxableMarketValue)); $this->tpl->set_var("COTaxable_TotalAV", $this->checkNumericFormat($this->totalCOTaxableAssessedValue)); $this->tpl->set_var("INTaxable_TotalMV", $this->checkNumericFormat($this->totalINTaxableMarketValue)); $this->tpl->set_var("INTaxable_TotalAV", $this->checkNumericFormat($this->totalINTaxableAssessedValue)); $this->tpl->set_var("MITaxable_TotalMV", $this->checkNumericFormat($this->totalMITaxableMarketValue)); $this->tpl->set_var("MITaxable_TotalAV", $this->checkNumericFormat($this->totalMITaxableAssessedValue)); $this->tpl->set_var("TITaxable_TotalMV", $this->checkNumericFormat($this->totalTITaxableMarketValue)); $this->tpl->set_var("TITaxable_TotalAV", $this->checkNumericFormat($this->totalTITaxableAssessedValue)); $this->tpl->set_var("SPTaxable_TotalMV", $this->checkNumericFormat($this->totalSPTaxableMarketValue)); $this->tpl->set_var("SPTaxable_TotalAV", $this->checkNumericFormat($this->totalSPTaxableAssessedValue)); $this->tpl->set_var("HOTaxable_TotalMV", $this->checkNumericFormat($this->totalHOTaxableMarketValue)); $this->tpl->set_var("HOTaxable_TotalAV", $this->checkNumericFormat($this->totalHOTaxableAssessedValue)); $this->tpl->set_var("SCTaxable_TotalMV", $this->checkNumericFormat($this->totalSCTaxableMarketValue)); $this->tpl->set_var("SCTaxable_TotalAV", $this->checkNumericFormat($this->totalSCTaxableAssessedValue)); $this->tpl->set_var("CUTaxable_TotalMV", $this->checkNumericFormat($this->totalCUTaxableMarketValue)); $this->tpl->set_var("CUTaxable_TotalAV", $this->checkNumericFormat($this->totalCUTaxableAssessedValue)); $this->tpl->set_var("OTTaxable_TotalMV", $this->checkNumericFormat($this->totalOTTaxableMarketValue)); $this->tpl->set_var("OTTaxable_TotalAV", $this->checkNumericFormat($this->totalOTTaxableAssessedValue)); $this->tpl->set_var("GOExempt_TotalMV", $this->checkNumericFormat($this->totalGOExemptMarketValue)); $this->tpl->set_var("GOExempt_TotalAV", $this->checkNumericFormat($this->totalGOExemptAssessedValue)); $this->tpl->set_var("RLExempt_TotalMV", $this->checkNumericFormat($this->totalRLExemptMarketValue)); $this->tpl->set_var("RLExempt_TotalAV", $this->checkNumericFormat($this->totalRLExemptAssessedValue)); $this->tpl->set_var("CHExempt_TotalMV", $this->checkNumericFormat($this->totalCHExemptMarketValue)); $this->tpl->set_var("CHExempt_TotalAV", $this->checkNumericFormat($this->totalCHExemptAssessedValue)); $this->tpl->set_var("EDExempt_TotalMV", $this->checkNumericFormat($this->totalEDExemptMarketValue)); $this->tpl->set_var("EDExempt_TotalAV", $this->checkNumericFormat($this->totalEDExemptAssessedValue)); $this->tpl->set_var("OTExempt_TotalMV", $this->checkNumericFormat($this->totalOTExemptMarketValue)); $this->tpl->set_var("OTExempt_TotalAV", $this->checkNumericFormat($this->totalOTExemptAssessedValue)); $this->tpl->set_var("Taxable_RealPropertyUnits", number_format($this->totalTaxableRealPropertyUnits)); $this->tpl->set_var("Taxable_LandArea", $this->checkNumericFormat($this->totalTaxableLandArea)); $this->tpl->set_var("Taxable_LandMV", $this->checkNumericFormat($this->totalTaxableLandMarketValue)); $this->tpl->set_var("Taxable_LandAV", $this->checkNumericFormat($this->totalTaxableLandAssessedValue)); $this->tpl->set_var("Taxable_BldgLessMV", $this->checkNumericFormat($this->totalTaxableBldgLessMarketValue)); $this->tpl->set_var("Taxable_BldgLessAV", $this->checkNumericFormat($this->totalTaxableBldgLessAssessedValue)); $this->tpl->set_var("Taxable_BldgOverMV", $this->checkNumericFormat($this->totalTaxableBldgOverMarketValue)); $this->tpl->set_var("Taxable_BldgOverAV", $this->checkNumericFormat($this->totalTaxableBldgOverAssessedValue)); $this->tpl->set_var("Taxable_MachMV", $this->checkNumericFormat($this->totalTaxableMachMarketValue)); $this->tpl->set_var("Taxable_MachAV", $this->checkNumericFormat($this->totalTaxableMachAssessedValue)); $this->tpl->set_var("Taxable_OtherMV", $this->checkNumericFormat($this->totalTaxableOtherMarketValue)); $this->tpl->set_var("Taxable_OtherAV", $this->checkNumericFormat($this->totalTaxableOtherAssessedValue)); $this->tpl->set_var("Taxable_TotalMV", $this->checkNumericFormat($this->totalTaxableMarketValue)); $this->tpl->set_var("Taxable_TotalAV", $this->checkNumericFormat($this->totalTaxableAssessedValue)); $this->tpl->set_var("Exempt_RealPropertyUnits", $this->checkNumericFormat($this->totalExemptRealPropertyUnits)); $this->tpl->set_var("Exempt_LandArea", $this->checkNumericFormat($this->totalExemptLandArea)); $this->tpl->set_var("Exempt_LandMV", $this->checkNumericFormat($this->totalExemptLandMarketValue)); $this->tpl->set_var("Exempt_LandAV", $this->checkNumericFormat($this->totalExemptLandAssessedValue)); $this->tpl->set_var("Exempt_BldgLessMV", $this->checkNumericFormat($this->totalExemptBldgLessMarketValue)); $this->tpl->set_var("Exempt_BldgLessAV", $this->checkNumericFormat($this->totalExemptBldgLessAssessedValue)); $this->tpl->set_var("Exempt_BldgOverMV", $this->checkNumericFormat($this->totalExemptBldgOverMarketValue)); $this->tpl->set_var("Exempt_BldgOverAV", $this->checkNumericFormat($this->totalExemptBldgOverAssessedValue)); $this->tpl->set_var("Exempt_MachMV", $this->checkNumericFormat($this->totalExemptMachMarketValue)); $this->tpl->set_var("Exempt_MachAV", $this->checkNumericFormat($this->totalExemptMachAssessedValue)); $this->tpl->set_var("Exempt_OtherMV", $this->checkNumericFormat($this->totalExemptOtherMarketValue)); $this->tpl->set_var("Exempt_OtherAV", $this->checkNumericFormat($this->totalExemptOtherAssessedValue)); $this->tpl->set_var("Exempt_TotalMV", $this->checkNumericFormat($this->totalExemptMarketValue)); $this->tpl->set_var("Exempt_TotalAV", $this->checkNumericFormat($this->totalExemptAssessedValue)); $this->tpl->set_var("TOTAL_RealPropertyUnits", number_format($this->totalRealPropertyUnits)); $this->tpl->set_var("TOTAL_LandArea", $this->checkNumericFormat($this->totalLandArea)); $this->tpl->set_var("TOTAL_LandMV", $this->checkNumericFormat($this->totalLandMarketValue)); $this->tpl->set_var("TOTAL_LandAV", $this->checkNumericFormat($this->totalLandAssessedValue)); $this->tpl->set_var("TOTAL_BldgLessMV", $this->checkNumericFormat($this->totalBldgLessMarketValue)); $this->tpl->set_var("TOTAL_BldgLessAV", $this->checkNumericFormat($this->totalBldgLessAssessedValue)); $this->tpl->set_var("TOTAL_BldgOverMV", $this->checkNumericFormat($this->totalBldgOverMarketValue)); $this->tpl->set_var("TOTAL_BldgOverAV", $this->checkNumericFormat($this->totalBldgOverAssessedValue)); $this->tpl->set_var("TOTAL_MachMV", $this->checkNumericFormat($this->totalMachMarketValue)); $this->tpl->set_var("TOTAL_MachAV", $this->checkNumericFormat($this->totalMachAssessedValue)); $this->tpl->set_var("TOTAL_OtherMV", $this->checkNumericFormat($this->totalOtherMarketValue)); $this->tpl->set_var("TOTAL_OtherAV", $this->checkNumericFormat($this->totalOtherAssessedValue)); $this->tpl->set_var("TOTAL_TotalMV", $this->checkNumericFormat($this->totalMarketValue)); $this->tpl->set_var("TOTAL_TotalAV", $this->checkNumericFormat($this->totalAssessedValue)); $treasurySettings = new TreasurySettings(); $treasurySettings->selectRecord(); $this->basicTaxRate = $treasurySettings->getPctRPTax() * 100; $this->sefTaxRate = $treasurySettings->getPctSEF() * 100; $this->rateOfLevy = $this->basicTaxRate + $this->sefTaxRate; $this->taxableBasicCollectibles = 0; $this->taxableSEFCollectibles = 0; $this->totalBasicCollectibles = 0; $this->totalSEFCollectibles = 0; $this->reTaxableBasicCollectibles = $this->totalRETaxableAssessedValue * ($this->basicTaxRate / 100); $this->reTaxableSEFCollectibles = $this->totalRETaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->reTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->reTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->reTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->reTaxableSEFCollectibles; $this->tpl->set_var("RETaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("RETaxable_BasicCollectibles", $this->checkNumericFormat($this->reTaxableBasicCollectibles)); $this->tpl->set_var("RETaxable_SEFCollectibles", $this->checkNumericFormat($this->reTaxableSEFCollectibles)); $this->agTaxableBasicCollectibles = $this->totalAGTaxableAssessedValue * ($this->basicTaxRate / 100); $this->agTaxableSEFCollectibles = $this->totalAGTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->agTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->agTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->agTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->agTaxableSEFCollectibles; $this->tpl->set_var("AGTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("AGTaxable_BasicCollectibles", $this->checkNumericFormat($this->agTaxableBasicCollectibles)); $this->tpl->set_var("AGTaxable_SEFCollectibles", $this->checkNumericFormat($this->agTaxableSEFCollectibles)); $this->coTaxableBasicCollectibles = $this->totalCOTaxableAssessedValue * ($this->basicTaxRate / 100); $this->coTaxableSEFCollectibles = $this->totalCOTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->coTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->coTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->coTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->coTaxableSEFCollectibles; $this->tpl->set_var("COTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("COTaxable_BasicCollectibles", $this->checkNumericFormat($this->coTaxableBasicCollectibles)); $this->tpl->set_var("COTaxable_SEFCollectibles", $this->checkNumericFormat($this->coTaxableSEFCollectibles)); $this->inTaxableBasicCollectibles = $this->totalINTaxableAssessedValue * ($this->basicTaxRate / 100); $this->inTaxableSEFCollectibles = $this->totalINTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->inTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->inTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->inTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->inTaxableSEFCollectibles; $this->tpl->set_var("INTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("INTaxable_BasicCollectibles", $this->checkNumericFormat($this->inTaxableBasicCollectibles)); $this->tpl->set_var("INTaxable_SEFCollectibles", $this->checkNumericFormat($this->inTaxableSEFCollectibles)); $this->miTaxableBasicCollectibles = $this->totalMITaxableAssessedValue * ($this->basicTaxRate / 100); $this->miTaxableSEFCollectibles = $this->totalMITaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->miTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->miTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->miTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->miTaxableSEFCollectibles; $this->tpl->set_var("MITaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("MITaxable_BasicCollectibles", $this->checkNumericFormat($this->miTaxableBasicCollectibles)); $this->tpl->set_var("MITaxable_SEFCollectibles", $this->checkNumericFormat($this->miTaxableSEFCollectibles)); $this->tiTaxableBasicCollectibles = $this->totalTITaxableAssessedValue * ($this->basicTaxRate / 100); $this->tiTaxableSEFCollectibles = $this->totalTITaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->tiTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->tiTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->tiTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->tiTaxableSEFCollectibles; $this->tpl->set_var("TITaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("TITaxable_BasicCollectibles", $this->checkNumericFormat($this->tiTaxableBasicCollectibles)); $this->tpl->set_var("TITaxable_SEFCollectibles", $this->checkNumericFormat($this->tiTaxableSEFCollectibles)); $this->spTaxableBasicCollectibles = $this->totalSPTaxableAssessedValue * ($this->basicTaxRate / 100); $this->spTaxableSEFCollectibles = $this->totalSPTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->spTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->spTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->spTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->spTaxableSEFCollectibles; $this->tpl->set_var("SPTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("SPTaxable_BasicCollectibles", $this->checkNumericFormat($this->spTaxableBasicCollectibles)); $this->tpl->set_var("SPTaxable_SEFCollectibles", $this->checkNumericFormat($this->spTaxableSEFCollectibles)); $this->hoTaxableBasicCollectibles = $this->totalHOTaxableAssessedValue * ($this->basicTaxRate / 100); $this->hoTaxableSEFCollectibles = $this->totalHOTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->hoTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->hoTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->hoTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->hoTaxableSEFCollectibles; $this->tpl->set_var("HOTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("HOTaxable_BasicCollectibles", $this->checkNumericFormat($this->hoTaxableBasicCollectibles)); $this->tpl->set_var("HOTaxable_SEFCollectibles", $this->checkNumericFormat($this->hoTaxableSEFCollectibles)); $this->scTaxableBasicCollectibles = $this->totalSCTaxableAssessedValue * ($this->basicTaxRate / 100); $this->scTaxableSEFCollectibles = $this->totalSCTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->scTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->scTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->scTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->scTaxableSEFCollectibles; $this->tpl->set_var("SCTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("SCTaxable_BasicCollectibles", $this->checkNumericFormat($this->scTaxableBasicCollectibles)); $this->tpl->set_var("SCTaxable_SEFCollectibles", $this->checkNumericFormat($this->scTaxableSEFCollectibles)); $this->cuTaxableBasicCollectibles = $this->totalCUTaxableAssessedValue * ($this->basicTaxRate / 100); $this->cuTaxableSEFCollectibles = $this->totalCUTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->cuTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->cuTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->cuTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->cuTaxableSEFCollectibles; $this->tpl->set_var("CUTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("CUTaxable_BasicCollectibles", $this->checkNumericFormat($this->cuTaxableBasicCollectibles)); $this->tpl->set_var("CUTaxable_SEFCollectibles", $this->checkNumericFormat($this->cuTaxableSEFCollectibles)); $this->otTaxableBasicCollectibles = $this->totalOTTaxableAssessedValue * ($this->basicTaxRate / 100); $this->otTaxableSEFCollectibles = $this->totalOTTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->otTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->otTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->otTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->otTaxableSEFCollectibles; $this->tpl->set_var("OTTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("OTTaxable_BasicCollectibles", $this->checkNumericFormat($this->otTaxableBasicCollectibles)); $this->tpl->set_var("OTTaxable_SEFCollectibles", $this->checkNumericFormat($this->otTaxableSEFCollectibles)); $this->taTaxableBasicCollectibles = $this->totalTaTaxableAssessedValue * ($this->basicTaxRate / 100); $this->taTaxableSEFCollectibles = $this->totalTaTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->taTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->taTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->taTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->taTaxableSEFCollectibles; $this->tpl->set_var("TaTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("TaTaxable_BasicCollectibles", $this->checkNumericFormat($this->taTaxableBasicCollectibles)); $this->tpl->set_var("TaTaxable_SEFCollectibles", $this->checkNumericFormat($this->taTaxableSEFCollectibles)); $this->tpl->set_var("Taxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("Taxable_BasicCollectibles", $this->checkNumericFormat($this->taxableBasicCollectibles)); $this->tpl->set_var("Taxable_SEFCollectibles", $this->checkNumericFormat($this->taxableSEFCollectibles)); $this->tpl->set_var("TOTAL_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("TOTAL_BasicCollectibles", $this->checkNumericFormat($this->totalBasicCollectibles)); $this->tpl->set_var("TOTAL_SEFCollectibles", $this->checkNumericFormat($this->totalSEFCollectibles)); $this->setPageDetailPerms(); $this->tpl->set_var("dbs", $this->dbs); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); if ($this->reportType == "HTML") { $this->tpl->p("templatePage"); } else { $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } } }
** 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; }
function Main() { $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); foreach ($rptop as $key => $value) { switch ($key) { case "owner": if (is_a($value, "Owner")) { $this->formArray["ownerID"] = $rptop->owner->getOwnerID(); $xmlStr = $rptop->owner->domDocument->dump_mem(true); if (!$xmlStr) { $this->formArray["ownerName"] = ""; } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->formArray["ownerName"] = ""; } else { $this->displayOwnerList($domDoc); } } } else { $this->formArray["ownerNames"] = ""; } break; case "tdArray": $tdCtr = 0; if (count($value)) { foreach ($value as $tkey => $tvalue) { $this->tdRecord["arpNumber"] = $tvalue->getTaxDeclarationNumber(); $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($tvalue->getAfsID()))) { // error xml } else { if (!($domDoc = domxml_open_mem($xmlStr))) { // error domDoc } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $odID = $afs->getOdID(); $od = new OD(); $od->selectRecord($odID); if (is_object($od->locationAddress)) { $locationAddress = $od->getLocationAddress(); $this->tdRecord["location"] = $locationAddress->getBarangay() . ", " . $locationAddress->getMunicipalityCity(); } $this->tdRecord["assessedValue"] = $afs->getTotalAssessedValue(); switch ($tvalue->getPropertyType()) { case "ImprovementsBuildings": if (is_array($afs->getImprovementsBuildingsArray())) { $improvementsBuildings = $afs->improvementsBuildingsArray[0]; $actualUse = $improvementsBuildings->getActualUse(); if (is_numeric($actualUse)) { $improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses(); $improvementsBuildingsActualUses->selectRecord($actualUse); $actualUse = $improvementsBuildingsActualUses->getCode(); //$actualUse = $improvementsBuildingsActualUses->getDescription(); } $this->tdRecord["class"] = $actualUse; } break; case "Machineries": if (is_array($afs->getMachineriesArray())) { $machineries = $afs->machineriesArray[0]; $actualUse = $machineries->getActualUse(); if (is_numeric($actualUse)) { $machineriesActualUses = new MachineriesActualUses(); $machineriesActualUses->selectRecord($actualUse); $actualUse = $machineriesActualUses->getCode(); //$actualUse = $machineriesActualUses->getDescription(); } $this->tdRecord["class"] = $actualUse; } break; case "Land": default: if (is_array($afs->getLandArray())) { $land = $afs->landArray[0]; $actualUse = $land->getActualUse(); if (is_numeric($actualUse)) { $landActualUses = new LandActualUses(); $landActualUses->selectRecord($actualUse); $actualUse = $landActualUses->getCode(); //$actualUse = $landActualUses->getDescription(); } $this->tdRecord["class"] = $actualUse; } else { if (is_array($afs->getPlantsTreesArray())) { if (is_numeric($actualUse)) { $plantsTreesActualUses = new PlantsTreesActualUses(); $plantsTreesActualUses->selectRecord($actualUse); $actualUse = $plantsTreesActualUses->getCode(); //$actualUse = $plantsTreesActualUses->getDescription(); } $this->tdRecord["class"] = $actualUse; } } } } } // grab DueRecords from tdID $DueList = new SoapObject(NCCBIZ . "DueList.php", "urn:Object"); $dueArrayList = array("Annual" => "", "Q1" => "", "Q2" => "", "Q3" => "", "Q4" => ""); if (!($xmlStr = $DueList->getDueList($tvalue->getTdID(), $rptop->getTaxableYear()))) { // error xml // taxDue = uncalculated } else { if (!($domDoc = domxml_open_mem($xmlStr))) { // error domDoc // taxDue = uncalculated } else { $dueRecords = new DueRecords(); $dueRecords->parseDomDocument($domDoc); foreach ($dueRecords->getArrayList() as $due) { foreach ($due as $dueKey => $dueValue) { switch ($dueKey) { case "dueType": if ($dueValue == "Annual") { $this->formArray["totalTaxDue"] += $due->getTaxDue(); $this->tdRecord["basic"] = $due->getBasicTax(); $this->tdRecord["sef"] = $due->getSEFTax(); } $dueArrayList[$dueValue] = $due; $this->tpl->set_var("basicTax[" . $dueValue . "]", formatCurrency($due->getBasicTax())); $this->tpl->set_var("sefTax[" . $dueValue . "]", formatCurrency($due->getSEFTax())); $this->tpl->set_var("idleTax[" . $dueValue . "]", formatCurrency($due->getIdleTax())); $this->tpl->set_var("taxDue[" . $dueValue . "]", formatCurrency($due->getTaxDue())); $this->tpl->set_var("dueDate[" . $dueValue . "]", date("M. d, Y", strtotime($due->getDueDate()))); $dueDateYear = date("Y", strtotime($due->getDueDate())); $this->tdRecord["year"] = $dueDateYear; break; } } } $treasurySettings = new TreasurySettings(); $treasurySettings->selectRecord(); // initialize discountPeriod and discountPercentage for earlyPaymentDiscount $this->tpl->set_var("discountPercentage", $treasurySettings->getDiscountPercentage() . "%"); $this->tpl->set_var("discountPeriod", "January 01, " . $dueDateYear . " - " . date("F d, Y", strtotime($dueDateYear . "-" . $treasurySettings->getDiscountPeriod()))); $this->formArray["discountPercentage"] = $treasurySettings->getDiscountPercentage(); $this->formArray["discountPeriod"] = $treasurySettings->getDiscountPeriod(); $this->formArray["discountPeriod_End"] = strtotime($dueDateYear . "-" . $this->formArray["discountPeriod"]); $this->formArray["discountPeriod_Start"] = strtotime($dueDateYear . "-01-01"); // initialize advancedDiscountPercentage for advancedPayment $this->tpl->set_var("advancedDiscountPercentage", $treasurySettings->getAdvancedDiscountPercentage() . "%"); $this->formArray["advancedDiscountPercentage"] = $treasurySettings->getAdvancedDiscountPercentage(); // initialize penaltyLUTArray $penaltyLUTArray = $treasurySettings->getPenaltyLUT(); $this->penaltyLUTArray = $treasurySettings->getPenaltyLUT(); foreach ($dueArrayList as $dKey => $due) { $dueArrayList[$dKey]->setEarlyPaymentDiscountPeriod($this->formArray["discountPeriod"]); $dueArrayList[$dKey]->setEarlyPaymentDiscountPercentage($this->formArray["discountPercentage"]); // compute earlyPaymentDiscount as of today // check if today is within the discountPeriod and compute Discount // AND if today is BEFORE annual dueDate $dueArrayList[$dKey]->setEarlyPaymentDiscount(0.0); if (strtotime($this->now) >= $this->formArray["discountPeriod_Start"] && strtotime($this->now) <= $this->formArray["discountPeriod_End"]) { if (strtotime($this->now) <= strtotime($dueArrayList[$dKey]->getDueDate())) { $dueArrayList[$dKey]->setEarlyPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["discountPercentage"] / 100)); } } // compute advancedPaymentDiscount as of today // check if today is BEFORE January 1 of the year of the annual dueDate $dueArrayList[$dKey]->setAdvancedPaymentDiscount(0.0); if (strtotime($this->now) < strtotime(date("Y", strtotime($dueArrayList[$dKey]->getDueDate())) . "-01-01")) { $dueArrayList[$dKey]->setAdvancedPaymentDiscount($dueArrayList[$dKey]->getTaxDue() * ($this->formArray["advancedDiscountPercentage"] / 100)); } $latestPaymentDate = $this->getLatestPaymentDate($dueArrayList); $amountPaidForDue = $this->getAmountPaidForDue($dueArrayList); $amnestyStatus = $this->getAmnestyStatusForDue($dueArrayList); // calculate Penalties verses either today or verses the last paymentDate if ($latestPaymentDate != "") { $dueArrayList[$dKey] = $this->computePenalty($latestPaymentDate, $dueArrayList[$dKey]); // if balance is 0 leave penalty as is, otherwise calculatePenalty according to date now $balance = $dueArrayList[$dKey]->getInitialNetDue() - $amountPaidForDue; if (round($balance, 4) > 0) { $dueArrayList[$dKey] = $this->computePenalty($this->now, $dueArrayList[$dKey]); } } else { $dueArrayList[$dKey] = $this->computePenalty($this->now, $dueArrayList[$dKey]); } $this->tpl->set_var("advancedPaymentDiscount[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getAdvancedPaymentDiscount())); $this->tpl->set_var("earlyPaymentDiscount[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getEarlyPaymentDiscount())); $this->tpl->set_var("monthsOverDue[" . $dKey . "]", $dueArrayList[$dKey]->getMonthsOverDue()); $this->tpl->set_var("penaltyPercentage[" . $dKey . "]", $dueArrayList[$dKey]->getPenaltyPercentage() * 100); $this->tpl->set_var("penalty[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getPenalty())); $this->tpl->set_var("initialNetDue[" . $dKey . "]", formatCurrency($dueArrayList[$dKey]->getInitialNetDue())); $this->initialNetDue[$dKey] = $dueArrayList[$dKey]->getInitialNetDue(); if ($amnestyStatus) { $this->initialNetDue[$dKey] -= $dueArrayList[$dKey]->getPenalty(); $this->tpl->set_var("amnesty[" . $dKey . "]", "Yes"); } else { $this->tpl->set_var("amnesty[" . $dKey . "]", "No"); } if ($dKey == "Annual") { $this->tdRecord["penalty"] = $dueArrayList[$dKey]->getPenalty(); } } } } // display Backtaxes and previousTD Backtaxes $this->formArray["totalBacktaxesBalance"] = 0; $this->displayBacktaxTD($tvalue->getTdID()); $precedingTDArray = $this->getPrecedingTDArray($tvalue); if (is_array($precedingTDArray)) { foreach ($precedingTDArray as $precedingTD) { $this->displayBacktaxTD($precedingTD->getTdID()); } } $this->tpl->set_var("total", number_format($this->formArray["totalBacktaxesDue"], 2)); $this->tpl->set_var("totalBacktaxesBalance", number_format($this->formArray["totalBacktaxesBalance"], 2)); // grab dueID's and backtaxTDID's to run through payments // create $dueIDArray foreach ($dueArrayList as $due) { $this->dueIDArray[] = $due->getDueID(); } $this->displayTotalPaid(); $this->displayNetDue(); $this->tdArrayList[$this->tdRecord["year"] . $this->tdArrayListCounter] = $this->tdRecord; $this->tdArrayListCounter++; unset($this->tdRecord); $tdCtr++; } } else { // 0 } $this->tpl->set_var("tdCtr", $tdCtr); break; } } } } if (is_array($this->tdArrayList)) { ksort($this->tdArrayList); reset($this->tdArrayList); $this->tpl->set_block("rptsTemplate", "TDList", "TDListBlock"); $this->formArray["totalTaxDue"] = 0; foreach ($this->tdArrayList as $tdRecord) { $this->tpl->set_var("tdYPos", $this->formArray["tdYPosValue"]); $this->tpl->set_var("arpNumber", $tdRecord["arpNumber"]); $this->tpl->set_var("class", $tdRecord["class"]); if (strlen($tdRecord["location"]) > 25) { $this->formArray["tdYPosValue"] -= 15; } $this->tpl->set_var("location", $tdRecord["location"]); $this->tpl->set_var("year", $tdRecord["year"]); $this->tpl->set_var("assessedValue", formatCurrency($tdRecord["assessedValue"])); $this->tpl->set_var("basic", formatCurrency($tdRecord["basic"])); $this->tpl->set_var("sef", formatCurrency($tdRecord["sef"])); $this->tpl->set_var("penalty", formatCurrency($tdRecord["penalty"])); $this->tpl->set_var("taxDue", formatCurrency($tdRecord["taxDue"])); $this->formArray["totalTaxDue"] += $tdRecord["taxDue"]; $this->tpl->parse("TDListBlock", "TDList", true); $this->formArray["tdYPosValue"] -= 15; } } $this->setForm(); $this->setLguDetails(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } // header("location: ".$testpdf->pdfPath); exit; }
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"); }