function TestPDFWriter() { session_cache_limiter("nocache"); $testpdf = new PDFWriter(); $testpdf->setOutputXML("C:/Sites/rpts/nccweb/rptreceipt.xml"); $testpdf->writePDF("rptr.pdf"); }
function Main() { $db = new DB_RPTS(); //$this->formArray['month']= 10; //ex Month january //$this->formArray['year']= 2003; //ex Month january /*$sql = "SELECT DISTINCT payments.dueID FROM payments INNER JOIN dues ON payments.dueID = dues.dueID WHERE MONTH( dues.dueDate ) = '01'"; */ $sql = "SELECT sum( amount ) as amount , YEAR(dues.dueDate) as yearDue, sum( payments.penalty ) as penalty , sum( discount ) as discount, \r\n\t\t\tcollectionDate FROM collections INNER JOIN collectionPayments ON collections.collectionID = collectionPayments.collectionID INNER JOIN payments \r\n\t\t\tON collectionPayments.paymentID = payments.paymentID INNER JOIN dues ON payments.dueID = dues.dueID where \r\n\t\t\tMONTH(collectionDate) = '" . $this->formArray['month'] . "' AND YEAR(collectionDate) = '" . $this->formArray['year'] . "' GROUP BY ( collectionDate ) order by collectionDate desc;"; $ypos = 460; $this->tpl->set_block("rptsTemplate", "ROW", "rBlk"); $db->query($sql); if (count($db->num_rows()) > 0) { for ($i = 0; $db->next_record(); $i++) { if ($db->f("yearDue") == date("Y")) { $this->tpl->set_var(currentYear, $db->f("amount")); $this->tpl->set_var(prevYear, "0.00"); } else { $this->tpl->set_var(prevYear, $db->f("amount")); $this->tpl->set_var(currentYear, "0.00"); } $this->tpl->set_var($db->Record); $this->tpl->set_var(ypos, $ypos); $ypos = $ypos - 10; $this->tpl->parse("rBlk", "ROW", true); } } $this->tpl->parse("report", "rptsTemplate"); $this->tpl->finish("report"); // $this->tpl->p("report"); $rptrpdf = new PDFWriter(); $rptrpdf->setOutputXML($this->tpl->get('report'), "string"); $rptrpdf->writePDF("collectionReport2.pdf"); }
function SamplePDF() { session_cache_limiter("nocache"); $xmlFile = getcwd() . "/samplePDF.xml"; $pdfFile = "samplePDF.pdf"; $testpdf = new PDFWriter(); $testpdf->setOutputXML($xmlFile); $testpdf->writePDF($pdfFile, false); }
function Main() { $db = new DB_RPTS(); $startDate = array(); $endDate = array(); $db->query("SELECT DISTINCT YEAR(dues.dueDate) as dueYear FROM dues"); for ($i = 0; $db->next_record(); $i++) { $startDate[$i][0] = $db->f("dueYear") . "-01-01"; $endDate[$i][0] = $db->f("dueYear") . "-03-31"; $startDate[$i][1] = $db->f("dueYear") . "-04-01"; $endDate[$i][1] = $db->f("dueYear") . "-06-30"; $startDate[$i][2] = $db->f("dueYear") . "-07-01"; $endDate[$i][2] = $db->f("dueYear") . "-09-30"; $startDate[$i][3] = $db->f("dueYear") . "-10-01"; $endDate[$i][3] = $db->f("dueYear") . "-12-31"; } $ypos = 625; $this->tpl->set_block("rptsTemplate", "ROW", "rBlk"); for ($i = 0; $i < count($startDate); $i++) { for ($j = 0; $j < count($startDate[$i]); $j++) { $sql = "SELECT sum( basic ) AS basic, sum( sef ) AS sef, sum( penalty ) AS penalty, sum( paidBasic ) AS paidBasic, \r\n\t\t\t\tsum(paidSEF) as paidSEF,sum( paidPenalty ) AS paidPenalty FROM dues WHERE dues.dueDate between '" . $startDate[$i][$j] . "' AND '" . $endDate[$i][$j] . "' GROUP BY (dues.dueDate) "; $db->query($sql); if ($db->next_record()) { $this->tpl->set_var($db->Record); list($year[$i][$j], $month[$i][$j], $day[$i][$j]) = explode("-", $startDate[$i][$j]); if ($month[$i][$j] == '01') { $quarter = $year[$i][$j] . " Quarter 1 "; } elseif ($month[$i][$j] == '04') { $quarter = $year[$i][$j] . " Quarter 2 "; } elseif ($month[$i][$j] == '07') { $quarter = $year[$i][$j] . " Quarter 3 "; } elseif ($month[$i][$j] == '10') { $quarter = $year[$i][$j] . " Quarter 3 "; } } $this->tpl->set_var(quarter, $quarter); $this->tpl->set_var(ypos, $ypos); $ypos = $ypos - 4; } $this->tpl->parse("rBlk", "ROW", true); } $this->tpl->parse('report', 'rptsTemplate'); $this->tpl->finish('report'); // $this->tpl->p('report'); $rptrpdf = new PDFWriter(); $rptrpdf->setOutputXML($this->tpl->get('report'), "string"); $rptrpdf->writePDF("collectionReport2.pdf"); }
function Main() { $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } //header("location: ".$testpdf->pdfPath); exit; }
function TestPDFWriter() { session_cache_limiter("nocache"); $filename = getcwd() . "/officialrptr.xml"; if (isset($_GET['xmlfile'])) { $filename = getcwd() . "/" . $_GET['xmlfile']; } if (isset($_GET['name'])) { $name = $_GET['name']; } else { $name = "rpts.pdf"; } $testpdf = new PDFWriter(); $testpdf->setOutputXML($filename); if (isset($_GET['print'])) { $testpdf->writePDF($name, $_GET['print']); } else { $testpdf->writePDF($name); } }
function showReceipt($preprinted) { //session_cache_limiter("nocache"); if ($preprinted) { $this->tpl->set_file(array('step3' => 'PayRPTOP3.htm', 'receipt' => 'or.xml')); } else { $this->tpl->set_file(array('receipt1' => 'PayRPTOP3.htm', 'receipt' => 'or.xml')); } # get all the details from the page //if(isset($_POST['tdID'])) $this->setDetails(); // $this->tpl->set_var('ownerAddress',strip_tags($this->tpl->get("ownerAddress"))); $this->tpl->parse('OUT', 'receipt'); $this->tpl->finish('OUT'); $rptrpdf = new PDFWriter(); $rptrpdf->setOutputXML($this->tpl->get('OUT'), "string"); $rptrpdf->writePDF("or.pdf"); //$str = $this->tpl->get('OUT'); //echo $str; // echo to browser // $this->tpl->p('OUT'); //header("location: ".$testpdf->pdfPath); }
function Main() { $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { exit("afs not found"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { exit("error xmlDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->formArray["arpNumber"] = $afs->arpNumber; $this->formArray["propertyIndexNumber"] = $afs->propertyIndexNumber; $this->formArray["taxability"] = $afs->taxability; $this->formArray["effectivity"] = $afs->effectivity; $this->displayODAFS($this->formArray["afsID"]); $this->displayTD($this->formArray["afsID"]); $landList = $afs->getLandArray(); if (count($landList)) { $this->displayLandList($landList); } $plantsTreesList = $afs->getPlantsTreesArray(); if (count($plantsTreesList)) { $this->displayPlantsTreesList($plantsTreesList); } $fp = fopen("/home/site/log/faasland1.xml", "w"); fwrite($fp, "---landitems---\r\n"); fwrite($fp, $this->formArray["landitems"] . "\r\n"); fwrite($fp, "---plantitems---\r\n"); fwrite($fp, $this->formArray["plantitems"] . "\r\n"); fwrite($fp, "---adjitems---\r\n"); fwrite($fp, $this->formArray["adjitems"] . "\r\n"); fwrite($fp, "---summtems---\r\n"); fwrite($fp, $this->formArray["summitems"] . "\r\n"); fclose($fp); } } $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); // $this->tpl->p("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() { $this->getSignatory(); if (is_array($this->formArray["nameListArray"])) { $this->tpl->set_block("rptsTemplate", "Page", "PageBlock"); foreach ($this->formArray["nameListArray"] as $nameList) { $this->tpl->set_var("pageNumber", $this->pageNumber); $this->tpl->set_var("nameList", $nameList); $this->tpl->parse("PageBlock", "Page", true); $this->pageNumber++; } } else { exit("no persons/companies to issue to certificate to"); } $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } }
function Main() { $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { exit("afs not found"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { exit("error xmlDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->formArray["propertyIndexNumber"] = $afs->getPropertyIndexNumber(); $this->formArray["arpNumber"] = $afs->getArpNumber(); $this->formArray["effectivity"] = $afs->getEffectivity(); if ($afs->getTaxability() == "Taxable") { $this->formArray["isTaxable"] = "X"; $this->formArray["isExempt"] = " "; } else { if ($afs->getTaxability() == "Exempt") { $this->formArray["isExempt"] = "X"; $this->formArray["isTaxable"] = " "; } } $this->displayODAFS($this->formArray["afsID"]); $this->displayTDDetails(); // if propertyType is "Land", grab Land values plus PlantsTrees values // if propertyType is "ImprovementsBuildings" or "Machineries", system should later on grab // "Land" from another AFS from based on bldg->landPin or mach->landPin field // still needs to be resolved whether to do it this way or not switch ($this->formArray["propertyType"]) { case "Land": $landList = $afs->getLandArray(); $plantsTreesList = $afs->getPlantsTreesArray(); if (is_array($landList)) { $this->displayLandDetails($landList); $this->displayLandList($landList); } if (is_array($plantsTreesList)) { $this->displayPlantsTreesList($plantsTreesList); } break; case "ImprovementsBuildings": $improvementsBuildingsList = $afs->getImprovementsBuildingsArray(); if (is_array($improvementsBuildingsList)) { $this->displayImprovementsBuildingsList($improvementsBuildingsList); } break; case "Machineries": $machineriesList = $afs->getMachineriesArray(); if (is_array($machineriesList)) { $this->displayMachineriesList($machineriesList); } break; } // UNCOMMENT LINES TO GRAB totalMarketValue and totalAssessedValue from AFS object instead of // computing from each property: //$this->formArray["totalMarketValue"] = $afs->getTotalMarketValue(); //$this->formArray["totalAssessedValue"] = $afs->getTotalAssessedValue(); $this->formArray["totalAssessedValueInWords"] = makewords($this->formArray["totalAssessedValue"]); } } $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } // header("location: ".$testpdf->pdfPath); exit; }
function Main() { $this->displayPageHeading(); $this->tpl->set_block("rptsTemplate", "Page", "PageBlock"); $this->tpl->set_block("Page", "CollectionList", "CollectionListBlock"); $this->tpl->set_block("Page", "GrandTotal", "GrandTotalBlock"); $collectionArrayList = $this->getCollectionArrayList(); if (!is_array($collectionArrayList)) { exit("no results found for the selected owner in collection list or empty database"); } $lineCounter = 0; $continuousLineCounter = 0; $count = count($collectionArrayList); $numOfPages = ceil($count / $this->formArray["collectionLinesPerPage"]); // foreach($collectionArrayList as $key => $value){ // $keyArray[] = $key; // } $tmpOwnerName = ""; for ($collectionCounter = 0; $collectionCounter <= $count; $collectionCounter++) { if ($lineCounter == $this->formArray["collectionLinesPerPage"] || $collectionCounter == $count) { $this->formArray["stYPos"] = $this->formArray["cYPos"] - 30; $this->formArray["gtYPos"] = $this->formArray["stYPos"] - 20; $this->tpl->set_var("stYPos", $this->formArray["stYPos"]); $this->tpl->set_var("gtYPos", $this->formArray["gtYPos"]); $this->tpl->set_var("stBasicTax", formatCurrency($this->formArray["stBasicTax"])); $this->tpl->set_var("stSefTax", formatCurrency($this->formArray["stSefTax"])); $this->tpl->set_var("stTotal", formatCurrency($this->formArray["stTotal"])); if ($this->formArray["pageNumber"] < $numOfPages) { $this->tpl->set_var("GrandTotalBlock", ""); } else { $this->tpl->set_var("gtBasicTax", formatCurrency($this->formArray["gtBasicTax"])); $this->tpl->set_var("gtSefTax", formatCurrency($this->formArray["gtSefTax"])); $this->tpl->set_var("gtTotal", formatCurrency($this->formArray["gtTotal"])); $this->tpl->parse("GrandTotalBlock", "GrandTotal", false); } $this->tpl->set_var("pageNumber", $this->formArray["pageNumber"]); $this->tpl->parse("PageBlock", "Page", true); $this->tpl->set_var("CollectionListBlock", ""); $this->formArray["pageNumber"]++; $this->formArray["cYPos"] = 616; $lineCounter = 0; } $collectionRecordArray = $collectionArrayList[$collectionCounter]; if ($tmpOwnerName != $collectionRecordArray["ownerName"]) { $ownerName = $collectionRecordArray["ownerName"]; } else { $ownerName = "''"; } if (strlen($ownerName) > 22) { $this->tpl->set_var("ownerName", substr($ownerName, 0, 22) . "-"); $this->tpl->set_var("ownerName2", substr($ownerName, 22)); $cYPos2 = $this->formArray["cYPos"] - 12; } else { $this->tpl->set_var("ownerName", $ownerName); $this->tpl->set_var("ownerName2", ""); $cYPos2 = 0; } $tmpOwnerName = $collectionRecordArray["ownerName"]; $this->tpl->set_var("taxDeclarationNumber", $collectionRecordArray["taxDeclarationNumber"]); $this->tpl->set_var("datePaid", $collectionRecordArray["datePaid"]); $this->tpl->set_var("orNumber", $collectionRecordArray["orNumber"]); $this->tpl->set_var("basicTax", formatCurrency($collectionRecordArray["basicTax"])); $this->tpl->set_var("sefTax", formatCurrency($collectionRecordArray["sefTax"])); $this->tpl->set_var("total", formatCurrency($collectionRecordArray["total"])); $this->formArray["stBasicTax"] += $collectionRecordArray["basicTax"]; $this->formArray["stSefTax"] += $collectionRecordArray["sefTax"]; $this->formArray["stTotal"] += $collectionRecordArray["total"]; $this->formArray["gtBasicTax"] += $collectionRecordArray["basicTax"]; $this->formArray["gtSefTax"] += $collectionRecordArray["sefTax"]; $this->formArray["gtTotal"] += $collectionRecordArray["total"]; $this->tpl->set_var("cYPos", $this->formArray["cYPos"]); $this->tpl->set_var("cYPos2", $cYPos2); $this->formArray["cYPos"] -= 12; if ($cYPos2 > 0) { $this->formArray["cYPos"] -= 12; $lineCounter++; } $this->tpl->set_var("i", $continuousLineCounter + 1); $this->tpl->parse("CollectionListBlock", "CollectionList", true); $lineCounter++; $continuousLineCounter++; } $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); // exit; $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } }
function Main() { $this->displayPageHeading(); $this->tpl->set_block("rptsTemplate", "Page", "PageBlock"); $this->tpl->set_var("pageNumber", 1); $this->tpl->set_block("Page", "Row", "RowBlock"); $this->tpl->set_block("Page", "Totals", "TotalsBlock"); $this->formArray["dayArray"] = $this->getDayArrayFromMonthYear(); $totalsArray = array("totalPaidBasic" => 0, "totalPriorBasic" => 0, "totalPenaltyBasic" => 0, "totalDiscountBasic" => 0, "totalPaidSEF" => 0, "totalPriorSEF" => 0, "totalPenaltySEF" => 0, "totalDiscountSEF" => 0); if (is_array($this->formArray["dayArray"])) { foreach ($this->formArray["dayArray"] as $day) { if ($this->paymentRecords = $this->filterPaymentsByDate($this->formArray["year"], $this->formArray["month"], $day)) { if (is_array($this->paymentRecords->getArrayList())) { $list = $this->paymentRecords->getArrayList(); $list2 = $list; $merged = array_merge($list, $list2); $this->formArray["paidBasic"] = 0.0; $this->formArray["priorBasic"] = 0.0; $this->formArray["penaltyBasic"] = 0.0; $this->formArray["discountBasic"] = 0.0; $this->formArray["paidSEF"] = 0.0; $this->formArray["priorSEF"] = 0.0; $this->formArray["penaltySEF"] = 0.0; $this->formArray["discountSEF"] = 0.0; foreach ($list as $payment) { $this->incrementValues($payment); } $totalsArray["totalPaidBasic"] += un_number_format($this->formArray["paidBasic"]); $totalsArray["totalPriorBasic"] += un_number_format($this->formArray["priorBasic"]); $totalsArray["totalPenaltyBasic"] += un_number_format($this->formArray["penaltyBasic"]); $totalsArray["totalDiscountBasic"] += un_number_format($this->formArray["discountBasic"]); $totalsArray["totalPaidSEF"] += un_number_format($this->formArray["paidSEF"]); $totalsArray["totalPriorSEF"] += un_number_format($this->formArray["priorSEF"]); $totalsArray["totalPenaltySEF"] += un_number_format($this->formArray["penaltySEF"]); $totalsArray["totalDiscountSEF"] += un_number_format($this->formArray["discountSEF"]); $this->tpl->set_var("collectionDate", date("M d, Y", strtotime($this->formArray["year"] . "-" . $this->formArray["month"] . "-" . $day))); $this->tpl->set_var("paidBasic", formatCurrency($this->formArray["paidBasic"])); $this->tpl->set_var("priorBasic", formatCurrency($this->formArray["priorBasic"])); $this->tpl->set_var("penaltyBasic", formatCurrency($this->formArray["penaltyBasic"])); $this->tpl->set_var("discountBasic", formatCurrency($this->formArray["discountBasic"])); $this->tpl->set_var("paidSEF", formatCurrency($this->formArray["paidSEF"])); $this->tpl->set_var("priorSEF", formatCurrency($this->formArray["priorSEF"])); $this->tpl->set_var("penaltySEF", formatCurrency($this->formArray["penaltySEF"])); $this->tpl->set_var("discountSEF", formatCurrency($this->formArray["discountSEF"])); $this->tpl->set_var("yposLine", $this->formArray["yposLine"]); $this->tpl->parse("RowBlock", "Row", true); $this->formArray["yposLine"] = $this->formArray["yposLine"] - 10; if ($this->formArray["yposLine"] < 70) { // new page $this->tpl->set_var("TotalsBlock", ""); $this->tpl->set_var("pageNumber", $this->formArray["pageNumber"]); $this->tpl->parse("PageBlock", "Page", true); $this->tpl->set_var("RowBlock", ""); $this->tpl->set_var("TotalsBlock", ""); $this->formArray["yposLine"] = 460; $this->formArray["pageNumber"]++; } } } } } $this->tpl->set_var("totalPages", $this->formArray["pageNumber"]); // last page // print totals: foreach ($totalsArray as $key => $value) { $value = formatCurrency($value); $this->tpl->set_var($key, $value); } $this->tpl->parse("TotalsBlock", "Totals", true); if ($this->formArray["yposLine"] == 460) { if ($this->formArray["pageNumber"] - 1 >= 1) { $this->tpl->set_var("totalPages", $this->formArray["pageNumber"] - 1); } else { $this->tpl->set_var("pageNumber", 1); $this->tpl->set_var("totalPages", 1); $this->tpl->parse("PageBlock", "Page", true); $this->tpl->set_var("RowBlock", ""); $this->tpl->set_var("TotalsBlock", ""); } } else { if ($this->formArray["yposLine"] < 460 && $this->formArray["yposLine"] >= 70) { $this->tpl->set_var("pageNumber", $this->formArray["pageNumber"]); $this->tpl->parse("PageBlock", "Page", true); $this->tpl->set_var("RowBlock", ""); $this->tpl->set_var("TotalsBlock", ""); } } $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } }
function Main() { $this->displayPageHeading(); $this->tpl->set_block("rptsTemplate", "Page", "PageBlock"); $this->tpl->set_block("Page", "TaxRollList", "TaxRollListBlock"); $this->tpl->set_block("Page", "GrandTotal", "GrandTotalBlock"); $taxRollArrayList = $this->getTaxRollArrayList(); if (!is_array($taxRollArrayList)) { exit("no results found for the selected barangay in tax roll or empty database"); } $trLineCounter = 0; $trCount = count($taxRollArrayList); $numOfPages = ceil($trCount / $this->formArray["taxRollLinesPerPage"]); foreach ($taxRollArrayList as $key => $value) { $keyArray[] = $key; } for ($taxRollCounter = 0; $taxRollCounter <= $trCount; $taxRollCounter++) { if ($trLineCounter == $this->formArray["taxRollLinesPerPage"] || $taxRollCounter == $trCount) { $this->formArray["stYPos"] = $this->formArray["trYPos"] - 30; $this->formArray["gtYPos"] = $this->formArray["stYPos"] - 20; $this->tpl->set_var("stYPos", $this->formArray["stYPos"]); $this->tpl->set_var("gtYPos", $this->formArray["gtYPos"]); $this->tpl->set_var("stAssessedValue", formatCurrency($this->formArray["stAssessedValue"])); $this->tpl->set_var("stBasicTax", formatCurrency($this->formArray["stBasicTax"])); $this->tpl->set_var("stSefTax", formatCurrency($this->formArray["stSefTax"])); $this->tpl->set_var("stTotal", formatCurrency($this->formArray["stTotal"])); if ($this->formArray["pageNumber"] < $numOfPages) { $this->tpl->set_var("GrandTotalBlock", ""); } else { $this->tpl->set_var("gtAssessedValue", formatCurrency($this->formArray["gtAssessedValue"])); $this->tpl->set_var("gtBasicTax", formatCurrency($this->formArray["gtBasicTax"])); $this->tpl->set_var("gtSefTax", formatCurrency($this->formArray["gtSefTax"])); $this->tpl->set_var("gtTotal", formatCurrency($this->formArray["gtTotal"])); $this->tpl->parse("GrandTotalBlock", "GrandTotal", false); } $this->tpl->set_var("pageNumber", $this->formArray["pageNumber"]); $this->tpl->parse("PageBlock", "Page", true); $this->tpl->set_var("TaxRollListBlock", ""); $this->formArray["pageNumber"]++; $this->formArray["trYPos"] = 616; $trLineCounter = 0; } $taxRollRecordArray = $taxRollArrayList[$keyArray[$taxRollCounter]]; if (strlen($taxRollRecordArray["ownerName"]) > 20) { $this->tpl->set_var("ownerName", substr($taxRollRecordArray["ownerName"], 0, 25) . "-"); $this->tpl->set_var("ownerName2", substr($taxRollRecordArray["ownerName"], 25)); $trYpos2 = $this->formArray["trYPos"] - 12; } else { $this->tpl->set_var("ownerName", $taxRollRecordArray["ownerName"]); $this->tpl->set_var("ownerName2", ""); $trYpos2 = 0; } $this->tpl->set_var("taxDeclarationNumber", $taxRollRecordArray["taxDeclarationNumber"]); $this->tpl->set_var("actualUse", $taxRollRecordArray["actualUse"]); $this->tpl->set_var("assessedValue", formatCurrency($taxRollRecordArray["assessedValue"])); $this->tpl->set_var("basicTax", formatCurrency($taxRollRecordArray["basicTax"])); $this->tpl->set_var("sefTax", formatCurrency($taxRollRecordArray["sefTax"])); $this->tpl->set_var("total", formatCurrency($taxRollRecordArray["total"])); $this->formArray["stAssessedValue"] += $taxRollRecordArray["assessedValue"]; $this->formArray["stBasicTax"] += $taxRollRecordArray["basicTax"]; $this->formArray["stSefTax"] += $taxRollRecordArray["sefTax"]; $this->formArray["stTotal"] += $taxRollRecordArray["total"]; $this->formArray["gtAssessedValue"] += $taxRollRecordArray["assessedValue"]; $this->formArray["gtBasicTax"] += $taxRollRecordArray["basicTax"]; $this->formArray["gtSefTax"] += $taxRollRecordArray["sefTax"]; $this->formArray["gtTotal"] += $taxRollRecordArray["total"]; $this->tpl->set_var("trYPos", $this->formArray["trYPos"]); $this->tpl->set_var("trYPos2", $trYpos2); $this->formArray["trYPos"] -= 12; if ($trYpos2 > 0) { $this->formArray["trYPos"] -= 12; } $this->tpl->parse("TaxRollListBlock", "TaxRollList", true); $trLineCounter++; } $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } }
function Main() { $propertyType = $this->formArray["propertyType"]; $propertyID = $this->formArray["propertyID"]; switch ($propertyType) { case "Land": $LandDetails = new SoapObject(NCCBIZ . "LandDetails.php", "urn:Object"); if (!($xmlStr = $LandDetails->getLand($propertyID))) { echo "xml failed"; } else { if (!($domDoc = domxml_open_mem($xmlStr))) { echo "error open xml"; } else { $land = new Land(); $land->parseDomDocument($domDoc); $this->formArray["landTotalMarketValue"] += tofloat($land->getMarketValue()); $this->formArray["landTotalAssessedValue"] += tofloat($land->getAssessedValue()); $this->displayLand($land); } } break; case "PlantsTrees": $PlantsTreesDetails = new SoapObject(NCCBIZ . "PlantsTreesDetails.php", "urn:Object"); if (!($xmlStr = $PlantsTreesDetails->getPlantsTrees($propertyID))) { echo "xml failed"; } else { if (!($domDoc = domxml_open_mem($xmlStr))) { echo "error open xml"; } else { $plantsTrees = new PlantsTrees(); $plantsTrees->parseDomDocument($domDoc); //$plantsTrees->selectRecord($propertyID); $this->formArray["plantTotalMarketValue"] += tofloat($plantsTrees->getMarketValue()); $this->formArray["plantTotalAssessedValue"] += tofloat($plantsTrees->getAssessedValue()); $this->displayPlantsTrees($plantsTrees); } } break; case "ImprovementsBuildings": $ImprovementsBuildingsDetails = new SoapObject(NCCBIZ . "ImprovementsBuildingsDetails.php", "urn:Object"); if (!($xmlStr = $ImprovementsBuildingsDetails->getImprovementsBuildings($propertyID))) { echo "xml failed"; } else { if (!($domDoc = domxml_open_mem($xmlStr))) { echo "error open xml"; } else { $improvementsBuildings = new ImprovementsBuildings(); $improvementsBuildings->parseDomDocument($domDoc); $this->formArray["bldgTotalMarketValue"] += tofloat($improvementsBuildings->getMarketValue()); $this->formArray["bldgTotalAssessedValue"] += tofloat($improvementsBuildings->getAssessedValue()); $this->displayImprovementsBuildings($improvementsBuildings); } } break; case "Machineries": $MachineriesDetails = new SoapObject(NCCBIZ . "MachineriesDetails.php", "urn:Object"); if (!($xmlStr = $MachineriesDetails->getMachineries($propertyID))) { echo "xml failed"; } else { if (!($domDoc = domxml_open_mem($xmlStr))) { echo "error open xml"; } else { $machineries = new Machineries(); $machineries->parseDomDocument($domDoc); $this->formArray["machTotalMarketValue"] += tofloat($machineries->getMarketValue()); $this->formArray["machTotalAssessedValue"] += tofloat($machineries->getAssessedValue()); $this->displayMachineries($machineries); } } break; default: echo "wrong property type"; } //$this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } header("location: " . $testpdf->pdfPath); exit; }
function Main() { $db = new DB_RPTS(); if ($this->formArray['quarter'] == "Q1") { $this->formArray['startDate'] = $this->formArray['yearYY'] . "-01-01-"; $this->formArray['endDate'] = $this->formArray['yearYY'] . "-03-31"; $this->formArray['monthEnd'] = "March"; } elseif ($this->formArray['quarter'] == "Q2") { $this->formArray['startDate'] = $this->formArray['yearYY'] . "-04-01-"; $this->formArray['endDate'] = $this->formArray['yearYY'] . "-06-30"; $this->formArray['monthEnd'] = "June"; } elseif ($this->formArray['quarter'] == "Q3") { $this->formArray['startDate'] = $this->formArray['yearYY'] . "-07-01-"; $this->formArray['endDate'] = $this->formArray['yearYY'] . "-09-30"; $this->formArray['monthEnd'] = "September"; } elseif ($this->formArray['quarter'] == "Q4") { $this->formArray['startDate'] = $this->formArray['yearYY'] . "-10-01-"; $this->formArray['endDate'] = $this->formArray['yearYY'] . "-12-31"; $this->formArray['monthEnd'] = "December"; } /*$sql = "SELECT LandActualUses.description as ldesc FROM LandActualUses ". " INNER JOIN ImprovementsBuildingsActualUses ON LandActualUses.description = ImprovementsBuildingsActualUses.description". " INNER JOIN MachineriesActualUses ON MachineriesActualUses.description = ImprovementsBuildingsActualUses.description". " LEFT JOIN PlantsTreesActualUses ON PlantsTreesActualUses.description = ImprovementsBuildingsActualUses.description"; $db->query($sql); */ $buff = array("Residential", "Agricultural", "Commercial", "Industrial", "Mineral", "Timber", "Special", "Hospital", "Scientific", "Cultural", "Other"); $this->tpl->set_block("rptsTemplate", "ROW", "rBlk"); for ($i = 0; $i < count($buff); $i++) { $this->formArray['ldesc'] = $buff[$i]; $this->formArray['specialLevy'] = 0; $this->formArray['totalSpecialLevy'] += $this->formArray['specialLevy']; $this->compute($buff[$i], "Land", "Basic"); $this->compute($buff[$i], "Machineries", "Basic"); $this->compute($buff[$i], "ImprovementsBuildings", "Basic"); $this->compute($buff[$i], "PlantsTrees", "Basic"); $this->formArray['paidBasic'] = $this->paidBasicLand + $this->paidBasicImprovementsBuildings + $this->paidBasicMachineries + $this->paidBasicPlantsTrees; $this->formArray['discountBasic'] = $this->discountBasicLand + $this->discountBasicImprovementsBuildings + $this->discountBasicMachineries + $this->discountBasicPlantsTrees; $this->formArray['priorBasic'] = $this->priorBasicLand + $this->priorBasicImprovementsBuildings + $this->priorBasicMachineries + $this->priorBasicPlantsTrees; $this->formArray['penaltyBasic'] = $this->penaltyBasicLand + $this->penaltyBasicImprovementsBuildings + $this->penaltyBasicMachineries + $this->penaltyBasicPlantsTrees; $this->formArray['priorPenaltyBasic'] = $this->priorPenaltyBasicLand + $this->priorPenaltyBasicImprovementsBuildings + $this->priorPenaltyBasicMachineries + $this->priorPenaltyBasicPlantsTrees; $this->formArray['totalGrossBasic'] = $this->totalGrossBasicLand + $this->totalGrossBasicImprovementsBuildings + $this->totalGrossBasicMachineries + $this->totalGrossBasicPlantsTrees; $this->formArray['totalNetBasic'] = $this->totalNetBasicLand + $this->totalNetBasicImprovementsBuildings + $this->totalNetBasicMachineries + $this->totalNetBasicPlantsTrees; $this->formArray['totalTotalNetBasic'] += $this->formArray['totalNetBasic']; $this->formArray['totalPaidBasic'] += $this->formArray['paidBasic']; $this->formArray['totalDiscountBasic'] += $this->formArray['discountBasic']; $this->formArray['totalPriorBasic'] += $this->formArray['priorBasic']; $this->formArray['totalPenaltyBasic'] += $this->formArray['penaltyBasic']; $this->formArray['totalPriorPenaltyBasic'] += $this->formArray['priorPenaltyBasic']; $this->formArray['totalTotalGrossBasic'] += $this->formArray['totalGrossBasic']; $this->compute($buff[$i], "Land", "Sef"); $this->compute($buff[$i], "Machineries", "Sef"); $this->compute($buff[$i], "ImprovementsBuildings", "Sef"); $this->compute($buff[$i], "PlantsTrees", "Sef"); $this->formArray['paidSEF'] = $this->paidSefLand + $this->paidSefImprovementsBuildings + $this->paidSefMachineries + $this->paidSefPlantsTrees; $this->formArray['discountSEF'] = $this->discountSefLand + $this->discountSefImprovementsBuildings + $this->discountSefMachineries + $this->discountSefPlantsTrees; $this->formArray['priorSEF'] = $this->priorSefLand + $this->priorSefImprovementsBuildings + $this->priorSefMachineries + $this->priorSefPlantsTrees; $this->formArray['penaltySEF'] = $this->penaltySefLand + $this->penaltySefImprovementsBuildings + $this->penaltySefMachineries + $this->penaltySefPlantsTrees; $this->formArray['priorPenaltySEF'] = $this->priorPenaltySefLand + $this->priorPenaltySefImprovementsBuildings + $this->priorPenaltyBasicMachineries + $this->priorPenaltyBasicPlantsTrees; $this->formArray['totalGrossSEF'] = $this->totalGrossSefLand + $this->totalGrossSefImprovementsBuildings + $this->totalGrossSefMachineries + $this->totalGrossSefPlantsTrees; $this->formArray['totalNetSEF'] = $this->totalNetSefLand + $this->totalNetSefImprovementsBuildings + $this->totalNetSefMachineries + $this->totalNetSefPlantsTrees; $this->formArray['totalTotalNetSEF'] += $this->formArray['totalNetSEF']; $this->formArray['totalPaidSEF'] += $this->formArray['paidSEF']; $this->formArray['totalDiscountSEF'] += $this->formArray['discountSEF']; $this->formArray['totalPriorSEF'] += $this->formArray['priorSEF']; $this->formArray['totalPenaltySEF'] += $this->formArray['penaltySEF']; $this->formArray['totalPriorPenaltySEF'] += $this->formArray['priorPenaltySEF']; $this->formArray['totalTotalGrossSEF'] += $this->formArray['totalGrossSEF']; $this->compute($buff[$i], "Land", "Idle"); $this->compute($buff[$i], "Machineries", "Idle"); $this->compute($buff[$i], "ImprovementsBuildings", "Idle"); $this->compute($buff[$i], "PlantsTrees", "Idle"); $this->formArray['paidIdle'] = $this->paidIdleLand + $this->paidIdleImprovementsBuildings + $this->paidIdleMachineries + $this->paidIdlePlantsTrees; $this->formArray['discountIdle'] = $this->discountIdleLand + $this->discountIdleImprovementsBuildings + $this->discountIdleMachineries + $this->discountIdlePlantsTrees; $this->formArray['priorIdle'] = $this->priorIdleLand + $this->priorIdleImprovementsBuildings + $this->priorIdleMachineries + $this->priorIdlePlantsTrees; $this->formArray['penaltyIdle'] = $this->penaltyIdleLand + $this->penaltyIdleImprovementsBuildings + $this->penaltyIdleMachineries + $this->penaltyIdlePlantsTrees; $this->formArray['priorPenaltyIdle'] = $this->priorPenaltyIdleLand + $this->priorPenaltyIdleImprovementsBuildings + $this->priorPenaltyBasicMachineries + $this->priorPenaltyBasicPlantsTrees; $this->formArray['totalGrossIdle'] = $this->totalGrossIdleLand + $this->totalGrossIdleImprovementsBuildings + $this->totalGrossIdleMachineries + $this->totalGrossIdlePlantsTrees; $this->formArray['totalIdle'] = $this->totalNetIdleLand + $this->totalNetIdleImprovementsBuildings + $this->totalNetIdleMachineries + $this->totalNetIdlePlantsTrees; $this->formArray['totalTotalNetIdle'] += $this->formArray['totalNetIdle']; $this->formArray['totalPaidIdle'] += $this->formArray['paidIdle']; $this->formArray['totalDiscountIdle'] += $this->formArray['discountIdle']; $this->formArray['totalPriorIdle'] += $this->formArray['priorIdle']; $this->formArray['totalPenaltyIdle'] += $this->formArray['penaltyIdle']; $this->formArray['totalPriorPenaltyIdle'] += $this->formArray['priorPenaltyIdle']; $this->formArray['totalTotalIdle'] += $this->formArray['totalIdle']; $this->computeTotalNonCash($buff[$i], "Land"); $this->computeTotalNonCash($buff[$i], "ImprovementBuildings"); $this->computeTotalNonCash($buff[$i], "Machineries"); $this->computeTotalNonCash("ldesc", "PlantsTrees"); $this->formArray['totalNonCash'] = $this->totalNoncashLand + $this->totalNoncashImprovementsBuildings + $this->totalNoncashMachineries + $this->totalNoncashPlantsTrees; $this->formArray['grandTotalNetColl'] = $this->formArray['totalNetBasic'] + $this->formArray['totalNetSEF'] + $this->formArray['totalIdle'] + $this->formArray['totalNonCash'] + $this->formArray['specialLevy']; $this->formArray['totalTotalNonCash'] += $this->formArray['totalNonCash']; $this->formArray['totalGrandTotalNetColl'] += $this->formArray['grandTotalNetColl']; $this->formArray['ypos'] = $this->formArray['ypos'] - 10; $this->tpl->set_var($this->formArray); $this->tpl->parse("rBlk", "ROW", true); } $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); //$this->tpl->p("templatePage"); $rptrpdf = new PDFWriter(); $rptrpdf->setOutputXML($this->tpl->get('templatePage'), "string"); $rptrpdf->writePDF("collectionReport.pdf"); }
$ypos1 = 416; $yposx = 428; $yposx1 = 420; } #exit; //if ($i==0) { // $tpl->set_var(rowBlk,"<tr><td colspan=\"27\">No records yet.</td></tr>"); //} $tpl->set_var(startDate, $startDate); $tpl->set_var(endDate, $endDate); $tpl->set_var("Session", $sess->url("")); //$tpl->pparse(report,report); ///* $tpl->parse('report', 'report'); $tpl->finish('report'); $rptrpdf = new PDFWriter(); //exit($tpl->get('report')); $rptrpdf->setOutputXML($tpl->get('report'), "string"); $rptrpdf->writePDF("collectionReport2.pdf"); //*/ page_close(); function writeQuery($var, $startDate, $endDate, $municipalityCityID, $rpuClass) { $sql = "select Receipt.receiptNumber as orNo" . ", Receipt.receiptDate as datePaid" . ", Receipt.receivedFrom as taxpayerName" . ", Barangay.description as barangay" . ", Collection.collectionID" . ", Receipt.receiptID" . ", Payment.paymentID" . ", Due.dueID" . ", TD.tdID" . ", AFS.afsID" . ", OD.odID" . ", MunicipalityCity.description" . " FROM Collection,MunicipalityCity" . " INNER JOIN Receipt ON Receipt.receiptID = Collection.receiptID" . " INNER JOIN Payment ON Payment.paymentID = Collection.paymentID" . " INNER JOIN Due ON Due.dueID = Payment.dueID" . " INNER JOIN TD ON TD.tdID = Due.tdID" . " INNER JOIN AFS ON AFS.afsID = TD.afsID" . " INNER JOIN {$var} ON AFS.afsID = " . $var . ".afsID" . " INNER JOIN " . $var . "ActualUses ON {$var}.actualUse = " . $var . "ActualUses." . strtolower($var) . "ActualUsesID" . " INNER JOIN OD ON OD.odID = AFS.odID" . " INNER JOIN Location ON Location.odID = OD.odID" . " INNER JOIN LocationAddress ON LocationAddress.locationAddressID = Location.locationAddressID" . " INNER JOIN Barangay ON Barangay.barangayID = LocationAddress.barangayID" . " WHERE Receipt.receiptDate between '{$startDate}' AND '{$endDate}'" . " AND MunicipalityCity.municipalityCityID=" . $municipalityCityID . " AND " . $var . "ActualUses.code = '{$rpuClass}' and Payment.status != 'cancelled';"; /* $sql = "select distinct collections.receiptNum as orNo , collections.collectionDate as datePaid , collections.receivedFrom as taxpayerName, ". "Barangay.description as barangay". " FROM collections". " INNER JOIN collectionPayments ON collectionPayments.collectionID = collections.collectionID". " INNER JOIN payments ON payments.paymentID = collectionPayments.paymentID".
function Main() { $eRPTSSettings = new eRPTSSettings(); if ($eRPTSSettings->selectRecord(1)) { $this->tpl->set_var("lguType", strtoupper($eRPTSSettings->getLguType())); $this->tpl->set_var("lguName", strtoupper($eRPTSSettings->getLguName())); } $dbTD = new DB_RPTS(); $dbBacktaxTD = new DB_RPTS(); $dbPaymentBacktaxTD = new DB_RPTS(); $dbPaymentTD = new DB_RPTS(); $dbDues = new DB_RPTS(); // gather TD's $sql = "SELECT Due.dueID as dueID, " . "Due.tdID as tdID, " . "Due.dueType as dueType, " . "Due.dueDate as dueDate, " . "Due.basicTax as basicTax, " . "Due.basicTaxRate as basicTaxRate, " . "Due.sefTax as sefTax, " . "Due.sefTaxRate as sefTaxRate, " . "Due.idleTax as idleTax, " . "Due.idleTaxRate as idleTaxRate, " . "TD.afsID as afsID, " . "TD.propertyType as propertyType, " . "TD.taxDeclarationNumber as taxDeclarationNumber, " . "AFS.odID as odID, " . "AFS.arpNumber as arpNumber, " . "AFS.propertyIndexNumber as propertyIndexNumber, " . "AFS.taxability as taxability, " . "AFS.effectivity as effectivity, " . "AFS.totalMarketValue as totalMarketValue, " . "AFS.totalAssessedValue as totalAssessedValue " . "FROM Due, TD, AFS " . "WHERE Due.tdID = TD.tdID " . "AND TD.afsID = AFS.afsID " . "AND AFS.archive != 'true' " . "AND TD.archive != 'true' " . "AND Due.dueType = 'Annual' " . "AND YEAR(Due.dueDate) <= YEAR(NOW()) " . "AND TD.propertyType LIKE '" . $this->formArray["classification"] . "' " . "GROUP BY Due.tdID, YEAR(Due.dueDate) " . "ORDER BY Due.dueDate DESC"; $dbTD->query($sql); if ($dbTD->nf() > 0) { // gather BacktaxTD's while ($dbTD->next_record()) { $sqlBacktaxTD = "SELECT backtaxTDID, " . "tdID, " . "tdNumber, " . "startYear, " . "endYear, " . "startQuarter, " . "assessedValue, " . "basicRate, " . "sefRate, " . "basicTax, " . "sefTax, " . "idleTax, " . "penalties, " . "paid, " . "balance, " . "total " . "FROM BacktaxTD " . "WHERE tdID='" . $dbTD->f("tdID") . "' " . "ORDER BY startYear ASC "; $dbBacktaxTD->query($sqlBacktaxTD); if ($dbBacktaxTD->nf() > 0) { while ($dbBacktaxTD->next_record()) { $backtaxTDRecordArray[] = $dbBacktaxTD->Record; } } $tdRecordArray[] = array("td" => $dbTD->Record, "backtaxTD" => $backtaxTDRecordArray); unset($backtaxTDRecordArray); } } if (is_array($tdRecordArray)) { // verify whether each TD Record or BacktaxTD Record is delinquent by comparing it to Payment // if it is not in Payment it is considered delinquent // if amountPaid is insufficient to amountDue, it is considered delinquent foreach ($tdRecordArray as $recordArray) { $basicAmountDelinquent = 0; $sefAmountDelinquent = 0; $penalty = 0; $totalDelinquent = 0; // find delinquent backtaxTD's if (is_array($recordArray["backtaxTD"])) { foreach ($recordArray["backtaxTD"] as $backtaxTDRecord) { $basicAmountDelinquent = 0; $sefAmountDelinquent = 0; $penalty = 0; $totalDelinquent = 0; $sqlPaymentBacktaxTD = "SELECT paymentID, " . "dueType, " . "backtaxTDID, " . "taxDue, " . "earlyPaymentDiscount, " . "advancedPaymentDiscount, " . "penalty, " . "amnesty, " . "balanceDue, " . "amountPaid, " . "dueDate, " . "paymentDate " . "FROM Payment " . "WHERE backtaxTDID='" . $backtaxTDRecord["backtaxTDID"] . "' " . "AND status!='cancelled'"; $dbPaymentBacktaxTD->query($sqlPaymentBacktaxTD); if ($dbPaymentBacktaxTD->nf() > 0) { if ($dbPaymentBacktaxTD->next_record()) { // if amountPaid is less than balanceDue, it is delinquent if ($dbPaymentBacktaxTD->f("amountPaid") < $dbPaymentBacktaxTD->f("balanceDue")) { $paidBasic = $backtaxTDRecord["basicRate"] / ($backtaxTDRecord["basicRate"] + $backtaxTDRecord["sefRate"]) * $dbPaymentBacktaxTD->f("amountPaid"); $paidSef = $backtaxTDRecord["sefRate"] / ($backtaxTDRecord["basicRate"] + $backtaxTDRecord["sefRate"]) * $dbPaymentBacktaxTD->f("amountPaid"); $basicAmountDelinquent = $backtaxTDRecord["basicTax"] - $paidBasic; $sefAmountDelinquent = $backtaxTDRecord["sefTax"] - $paidSef; $backtaxTD = new BacktaxTD(); $backtaxTD->selectRecord("", $backtaxTDRecord["backtaxTDID"], ""); $backtaxTD->calculatePenalty(date("Y-m-d")); $penalty = $backtaxTD->getPenalties(); $totalDelinquent = $basicAmountDelinquent + $sefAmountDelinquent + $penalty; $delinquentRecordArray[] = array("propertyIndexNumber" => "", "taxDeclarationNumber" => $backtaxTDRecord["tdNumber"], "yearDelinquent" => $backtaxTDRecord["startYear"], "basicAmountDelinquent" => $basicAmountDelinquent, "sefAmountDelinquent" => $sefAmountDelinquent, "penalty" => $penalty, "totalDelinquent" => $totalDelinquent); } } } else { $paidBasic = $backtaxTDRecord["basicRate"] / ($backtaxTDRecord["basicRate"] + $backtaxTDRecord["sefRate"]) * $backtaxTDRecord["paid"]; $paidSef = $backtaxTDRecord["sefRate"] / ($backtaxTDRecord["basicRate"] + $backtaxTDRecord["sefRate"]) * $backtaxTDRecord["paid"]; $basicAmountDelinquent = $backtaxTDRecord["basicTax"] - $paidBasic; $sefAmountDelinquent = $backtaxTDRecord["sefTax"] - $paidSef; $backtaxTD = new BacktaxTD(); $backtaxTD->selectRecord("", $backtaxTDRecord["backtaxTDID"], ""); $backtaxTD->calculatePenalty(date("Y-m-d")); $penalty = $backtaxTD->getPenalties(); $totalDelinquent = $basicAmountDelinquent + $sefAmountDelinquent + $penalty; $delinquentRecordArray[] = array("propertyIndexNumber" => "", "taxDeclarationNumber" => $backtaxTDRecord["tdNumber"], "yearDelinquent" => $backtaxTDRecord["startYear"], "basicAmountDelinquent" => $basicAmountDelinquent, "sefAmountDelinquent" => $sefAmountDelinquent, "penalty" => $penalty, "totalDelinquent" => $totalDelinquent); } } } // find delinquent TD's if (is_array($recordArray["td"])) { $tdRecord = $recordArray["td"]; $basicAmountDelinquent = 0; $sefAmountDelinquent = 0; $penalty = 0; $totalDelinquent = 0; $sqlPaymentTD = "SELECT paymentID, " . "dueID, " . "dueType, " . "tdID, " . "taxDue, " . "earlyPaymentDiscount, " . "advancedPaymentDiscount, " . "penalty, " . "amnesty, " . "balanceDue, " . "amountPaid, " . "dueDate, " . "paymentDate " . "FROM Payment " . "WHERE tdID='" . $tdRecord["tdID"] . "' " . "AND status!='cancelled'"; $dbPaymentTD->query($sqlPaymentTD); if ($dbPaymentTD->nf() > 0) { while ($dbPaymentTD->next_record()) { if ($dbPaymentTD->f("dueType") == "Annual") { if ($dbPaymentTD->f("amountPaid") < $dbPaymentTD->f("balanceDue")) { $paidBasic = $tdRecord["basicRate"] / ($tdRecord["basicRate"] + $tdRecord["sefRate"]) * $dbPaymentTD->f("amountPaid"); $paidSef = $tdRecord["sefRate"] / ($tdRecord["basicRate"] + $tdRecord["sefRate"]) * $dbPaymentTD->f("amountPaid"); $basicAmountDelinquent = $tdRecord["basicTax"] - $paidBasic; $sefAmountDelinquent = $tdRecord["sefTax"] - $paidSef; $due = new Due(); $due->selectRecord($tdRecord["dueID"]); $due = $this->computePenalty(date("Y-m-d"), $due); $penalty = $due->getPenalty(); $totalDelinquent = $basicAmountDelinquent + $sefAmountDelinquent + $penalty; $delinquentRecordArray[] = array("propertyIndexNumber" => $tdRecord["propertyIndexNumber"], "taxDeclarationNumber" => $tdRecord["taxDeclarationNumber"], "yearDelinquent" => date("Y", strtotime($tdRecord["dueDate"])), "basicAmountDelinquent" => $basicAmountDelinquent, "sefAmountDelinquent" => $sefAmountDelinquent, "penalty" => $penalty, "totalDelinquent" => $totalDelinquent); } break; } else { $tmpPaidQuarterDues[] = $dbPaymentTD->f("dueID"); } } if (is_array($tmpPaidQuarterDues)) { // not all quarters have been paid if less than four if (count($tmpPaidQuarterDues) < 4) { foreach ($tmpPaidQuarterDues as $dueID) { $sqlDueCondition .= " AND Due.dueID!='" . $dueID . "' "; } // grab unpaid quarterly dues that have not been paid before quarterly dueDate $sqlDues = "SELECT Due.dueID as dueID, " . "Due.dueType as dueType, " . "Due.tdID as tdID " . "FROM Due, TD, AFS " . "WHERE TD.afsID = AFS.afsID " . "AND AFS.archive != 'true' " . "AND TD.archive != 'true' " . "AND Due.dueType != 'Annual' " . "AND Due.tdID = '" . $tdRecord["tdID"] . "'" . "AND TD.propertyType LIKE '" . $this->formArray["classification"] . "' " . "AND YEAR(Due.dueDate) <= " . date("Y", strtotime($tdRecord["dueDate"])) . " " . "AND Due.dueDate <= '" . date("Y-m-d") . "' " . $sqlDueCondition . " " . "GROUP BY Due.tdID, Due.dueDate " . "ORDER BY Due.dueDate DESC"; $dbDues->query($sqlDues); while ($dbDues->next_record()) { $due = new Due(); $due->selectRecord($dbDues->f("dueID")); $basicAmountDelinquent += $due->getBasicTax(); $sefAmountDelinquent += $due->getSefTax(); $due = $this->computePenalty(date("Y-m-d"), $due); $penalty += $due->getPenalty(); } $totalDelinquent = $basicAmountDelinquent + $sefAmountDelinquent + $penalty; $delinquentRecordArray[] = array("propertyIndexNumber" => $tdRecord["propertyIndexNumber"], "taxDeclarationNumber" => $tdRecord["taxDeclarationNumber"], "yearDelinquent" => date("Y", strtotime($tdRecord["dueDate"])), "basicAmountDelinquent" => $basicAmountDelinquent, "sefAmountDelinquent" => $sefAmountDelinquent, "penalty" => $penalty, "totalDelinquent" => $totalDelinquent); } unset($sqlDueCondition); unset($tmpPaidQuarterDues); } } else { $basicAmountDelinquent = $tdRecord["basicTax"]; $sefAmountDelinquent = $tdRecord["sefTax"]; $due = new Due(); $due->selectRecord($tdRecord["dueID"]); $due = $this->computePenalty(date("Y-m-d"), $due); $penalty = $due->getPenalty(); $totalDelinquent = $basicAmountDelinquent + $sefAmountDelinquent + $penalty; $delinquentRecordArray[] = array("propertyIndexNumber" => $tdRecord["propertyIndexNumber"], "taxDeclarationNumber" => $tdRecord["taxDeclarationNumber"], "yearDelinquent" => date("Y", strtotime($tdRecord["dueDate"])), "basicAmountDelinquent" => $basicAmountDelinquent, "sefAmountDelinquent" => $sefAmountDelinquent, "penalty" => $penalty, "totalDelinquent" => $totalDelinquent); } } } } // print page if (is_array($delinquentRecordArray)) { $ypos = 615; $decrementYposBy = 12; $linesPerPage = 42; $count = count($delinquentRecordArray); $numOfPages = ceil($count / $linesPerPage); $pageCtr = 1; $lineCtr = 1; $recordCtr = 1; $this->tpl->set_var("classification", $this->formArray["classification"]); $this->tpl->set_var("numOfPages", $numOfPages); $this->tpl->set_block("rptsTemplate", "Page", "PageBlock"); $this->tpl->set_block("Page", "Row", "RowBlock"); $this->tpl->set_block("Page", "Totals", "TotalsBlock"); $totalsArray = array("totalBasicAmountDelinquent" => 0, "totalSefAmountDelinquent" => 0, "totalPenalty" => 0, "totalTotalDelinquent" => 0); foreach ($delinquentRecordArray as $recordArray) { $this->tpl->set_var("ypos", $ypos); $this->tpl->set_var("recordCtr", $recordCtr); // write values $totalsArray["totalBasicAmountDelinquent"] += un_number_format($recordArray["basicAmountDelinquent"]); $totalsArray["totalSefAmountDelinquent"] += un_number_format($recordArray["sefAmountDelinquent"]); $totalsArray["totalPenalty"] += un_number_format($recordArray["penalty"]); $totalsArray["totalTotalDelinquent"] += un_number_format($recordArray["totalDelinquent"]); foreach ($recordArray as $key => $value) { switch ($key) { case "basicAmountDelinquent": case "sefAmountDelinquent": case "penalty": case "totalDelinquent": $value = formatCurrency($value); break; } $this->tpl->set_var($key, $value); } $this->tpl->parse("RowBlock", "Row", true); if ($recordCtr == count($delinquentRecordArray) || $lineCtr == $linesPerPage) { if ($pageCtr == $numOfPages) { foreach ($totalsArray as $key => $value) { $value = formatCurrency($value); $this->tpl->set_var($key, $value); } $this->tpl->parse("TotalsBlock", "Totals", true); } else { $this->tpl->set_var("TotalsBlock", ""); } $this->tpl->set_var("page", $pageCtr); $this->tpl->parse("PageBlock", "Page", true); $this->tpl->set_var("RowBlock", ""); $this->tpl->set_var("TotalsBlock", ""); $ypos = 615; $lineCtr = 0; $pageCtr++; } $lineCtr++; $recordCtr++; $ypos = $ypos - $decrementYposBy; } $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); } } else { exit("no delinquent collectible records to display"); } }
function Main() { $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { exit("afs not found"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { exit("error xmlDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->formArray["arpNumber"] = $afs->arpNumber; $this->formArray["propertyIndexNumber"] = $afs->propertyIndexNumber; $this->formArray["taxability"] = $afs->taxability; $this->formArray["effectivity"] = $afs->effectivity; $this->displayODAFS($this->formArray["afsID"]); $this->displayTD($this->formArray["afsID"]); $this->displayPostingSummary($afs); $improvementsBuildingsList = $afs->getImprovementsBuildingsArray(); if (count($improvementsBuildingsList)) { $this->displayImprovementsBuildingsList($improvementsBuildingsList); } } } $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF("ImprovementsBuildingsFAAS.pdf"); //,$this->formArray["print"]); } else { $testpdf->writePDF("ImprovementsBuildingsFAAS.pdf"); } // header("location: ".$testpdf->pdfPath); exit; }
function Main() { $this->formArray['currentDate'] = date("F d, Y"); $MunicipalityCityDetails = new SoapObject(NCCBIZ . "MunicipalityCityDetails.php", "urn:Object"); #test values //$this->formArray['municipalityCityID']=1; if (!($xmlStr = $MunicipalityCityDetails->getMunicipalityCityDetails($this->formArray['municipalityCityID']))) { #echo($xmlStr); exit("xml failed for municipality"); //header("Location: ".$this->sess->url("ViewSOA.php")."&status=2"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { echo "error xmlDoc"; } else { $MunicipalityCity = new MunicipalityCity(); $MunicipalityCity->parseDomDocument($domDoc); $this->formArray['municipality'] = $MunicipalityCity->getDescription(); } } if ($this->formArray['personID'] != "") { $person = new Person(); $person->selectRecord($this->formArray['personID']); $this->tpl->set_var(ownerName, $person->getFullName()); $this->tpl->set_var(ownerNo, $person->getTin()); $address = $person->addressArray[0]; if (is_object($address)) { $this->tpl->set_var(ownerAddress, $address->getNumber() . " " . $address->getStreet() . " " . $address->getBarangay() . " " . $address->getDistrict() . " " . $address->getMunicipalitycity() . " " . $address->getProvince()); } else { $this->tpl->set_var(ownerAddress, ""); } $db = new DB_RPTS(); $sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=" . $this->formArray['personID']; $db->query($sql); } else { $company = new Company(); $company->selectRecord($this->formArray['companyID']); $this->tpl->set_var(ownerName, $company->getCompanyName()); $this->tpl->set_var(ownerNo, $company->getCompanyID()); $address = $company->addressArray[0]; $this->tpl->set_var(ownerAddress, $address->getNumber() . " " . $address->getStreet() . " " . $address->getBarangay() . " " . $address->getDistrict() . " " . $address->getMunicipalitycity() . " " . $address->getProvince()); $db = new DB_RPTS(); $sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=" . $this->formArray['companyID']; $db->query($sql); } $ypos = 325; $this->tpl->set_block("rptsTemplate", "ROW", "RowBlk"); for ($i = 0; $db->next_record(); $i++) { $rptopID = $db->f("rptopID"); $RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object"); if (!($xmlStr = $RPTOPDetails->getRPTOP($rptopID))) { // exit("xml failed for RPTOP"); header("Location: " . $this->sess->url("ViewSOA.php") . "&status=1"); } 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(); $td = new TD(); $rptop->parseDomDocument($domDoc); foreach ($rptop as $key => $value) { $this->formArray['payableYear'] = $rptop->getTaxableYear(); $rptopID = $rptop->getRptopID(); if ($key == "tdArray") { $tdCtr = 0; if (count($value)) { foreach ($value as $tkey => $tvalue) { $td->selectRecord($tvalue->getTdID()); $assessedValue = number_format($td->getAssessedValue(), 2, ".", ""); $propertyType = $td->getPropertyType(); $TaxDeclarationNumber = $td->getTaxDeclarationNumber(); $afsID = $td->getAfsID(); $afs = new AFS(); $afs->selectRecord($afsID); $od = new OD(); $od->selectRecord($afs->getOdID()); $addr = $od->getLocationAddress(); if (count($addr)) { $location = strtoupper($addr->getNumber() . " " . substr($addr->getBarangay(), 0, 4) . " " . substr($addr->getMunicipalityCity(), 0, 3) . " " . substr($addr->getProvince(), 0, 3)); $munCityID = $addr->getMunicipalityCityID(); } if (count($afs->landArray)) { foreach ($afs->landArray as $afsKey => $afsValue) { $actualUse = $afsValue->getActualUse(); $landActualUses = new LandActualUses(); $landActualUses->selectRecord($actualUse); $Code = $landActualUses->getCode(); } } if (count($afs->improvementsBuildingsArray)) { foreach ($afs->improvementsBuildingsArray as $afsKey => $afsValue) { $actualUse = $afsValue->getActualUse(); $improvementsBuildingsActualUses = new improvementsBuildingsActualUses(); $improvementsBuildingsActualUses->selectRecord($actualUse); $Code = $improvementsBuildingsActualUses->getCode(); } } if ($munCityID == $this->formArray['municipalityCityID']) { $this->tpl->set_var(location, $location); $this->tpl->set_var("class", $Code); $this->tpl->set_var(kind, strtoupper(substr($propertyType, 0, 4))); $this->tpl->set_var(currentTDNo, $TaxDeclarationNumber); $this->tpl->set_var(municipality, $addr->getMunicipalityCity()); //$dues = new Dues(); //$dues->create($td->getTdID(),"2003"); //$totTaxDue += $dues->getSEF()+$dues->getBasic(); $dues = new Dues($tvalue->getTdID(), $rptop->getTaxableYear(), $assessedValue); $paymentPeriod = $dues->getPaymentMode(); $totalTaxDue = $dues->getPaidBasic($paymentPeriod) + $dues->getPaidSEF($paymentPeriod) + $dues->getPaidIdle($paymentPeriod); if ($dues->getAmnesty()) { $dues->setPctPenalty(0.0); } else { $totalTaxDue += $dues->getPenalty($paymentPeriod); } if ($dues->getIsDiscount()) { $taxDue->setDiscount($totalTaxDue); $totalTaxDue -= $dues->getDiscount(); } $interest = $dues->getPctPenalty(); if ($interest > 0 && $paymentPeriod != "Annual") { $paymentPeriod = "Annual"; } $basic = number_format($dues->getPaidBasic(), "2", ".", ""); $this->tpl->set_var(basic, $basic); $totBasic += $basic; $sef = number_format($dues->getPaidSEF(), "2", ".", ""); $this->tpl->set_var(sef, $sef); $totSEF += number_format($sef, "2", ".", ""); $this->tpl->set_var(total, number_format($sef + $basic, "2", ".", "")); $this->tpl->set_var(marketValue, number_format($afs->getTotalMarketValue(), 2)); $totMarketValue += $afs->getTotalMarketValue(); $this->tpl->set_var(assessedValue, number_format($afs->getTotalAssessedValue(), 2)); $totAssessedValue += $afs->getTotalAssessedValue(); $pIndexNo = $afs->getPropertyIndexNumber(); if ($pIndexNo == "") { $pIndexNo = "No value specified"; } $ypos = $ypos - 10; $this->tpl->set_var(ypos, $ypos); $this->tpl->set_var(pin, $pIndexNo); $this->tpl->parse("RowBlk", "ROW", true); } } #end foreach($value) } #end if coun value $this->tpl->set_var(totalMarketValue, number_format($totMarketValue, 2)); $this->tpl->set_var(totalAssessedValue, number_format($totAssessedValue, 2)); $this->tpl->set_var(totalBasic, number_format($totBasic, 2)); $this->tpl->set_var(totalSEF, number_format($totSEF, 2)); $this->tpl->set_var(totalTaxDue, number_format($totalTaxDue, 2)); } } } } } $this->setForm(); $this->tpl->set_var("Session", $this->sess->url("")); /* $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); */ $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $rptrpdf = new PDFWriter(); $rptrpdf->setOutputXML($this->tpl->get('templatePage'), "string"); $rptrpdf->writePDF("viewSOA.pdf"); }
function Main() { $this->setForm(); $this->tpl->set_block("rptsTemplate", "ReceiptPage", "ReceiptPageBlock"); $pageNumber = 1; $ReceiptDetails = new SoapObject(NCCBIZ . "ReceiptDetails.php", "urn:Object"); $CollectionList = new SoapObject(NCCBIZ . "CollectionList.php", "urn:Object"); $PaymentDetails = new SoapObject(NCCBIZ . "PaymentDetails.php", "urn:Object"); foreach ($this->formArray["receiptIDArray"] as $receiptID) { $this->tpl->set_var("pageNumber", $pageNumber); $totalAmountPaid = 0; $eRPTSSettings = $this->getERPTSSettingsDetails(); if ($eRPTSSettings->getLguType() == "City") { $this->setvar("city", $eRPTSSettings->getLguName()); $this->setvar("province", ""); } else { $this->setvar("city", ""); $this->setvar("province", $eRPTSSettings->getLguName()); } if (!($xmlStr = $ReceiptDetails->getReceipt($receiptID))) { //exit("xml failed."); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { //exit("error domDoc"); } else { $receipt = new Receipt(); $receipt->parseDomDocument($domDoc); $this->setvar("prevORNum", $receipt->getPreviousReceiptNumber()); $porMonth = ""; $porDay = ""; $porYear = ""; if ($receipt->getPreviousReceiptDate() != "0000-00-00") { $porMonth = date("F", strtotime($receipt->getPreviousReceiptDate())); $porDay = date("d", strtotime($receipt->getPreviousReceiptDate())); $porYear = date("Y", strtotime($receipt->getPreviousReceiptDate())); } $this->setvar("porMonth", $porMonth); $this->setvar("porDay", $porDay); $this->setvar("porYear", $porYear); $this->setvar("orNum", $receipt->getReceiptNumber()); $orDate = ""; if ($receipt->getReceiptDate() != "0000-00-00") { $orDate = date("F d, Y", strtotime($receipt->getReceiptDate())); } $this->setvar("orDate", $orDate); $this->setvar("receivedFrom", $this->getReceivedFromName($receipt->getReceivedFrom())); $this->setvar("paymentMode", $receipt->getPaymentMode()); if ($receipt->getPaymentMode() == "check") { $this->setvar("checkNumber", "using Check Number : " . $receipt->getCheckNumber()); $this->setvar("dateOfCheck", " dated " . date("F d, Y", strtotime($receipt->getDateOfCheck()))); $this->setvar("draweeBank", "(" . $receipt->getDraweeBank() . ")"); } $this->setvar("cityTreasurer", $this->getPersonName($receipt->getCityTreasurer())); $this->setvar("deputyTreasurer", $this->getPersonName($receipt->getDeputyTreasurer())); if (!($collectionXmlStr = $CollectionList->getCollectionListFromReceiptID($receiptID))) { // xml failed } else { if (!($collectionDomDoc = domxml_open_mem($collectionXmlStr))) { // error domDoc } else { $collectionRecords = new CollectionRecords(); $collectionRecords->parseDomDocument($collectionDomDoc); $collectionArrayList = $collectionRecords->getArrayList(); $i = 0; foreach ($collectionArrayList as $collection) { $i++; if ($i <= 1) { if ($collection->getTaxType() == "basic") { $this->setvar("receiptType", "[ X ] BASIC TAX [ ] SPECIAL EDUCATION FUND"); } else { if ($collection->getTaxType() == "sef") { $this->setvar("receiptType", "[ ] BASIC TAX [ X ] SPECIAL EDUCATION FUND"); } else { if ($collection->getTaxType() == "idle") { $this->setvar("receiptType", "[ ] BASIC TAX [ ] SPECIAL EDUCATION FUND [ X ] IDLE TAX"); } } } } $paymentID = $collection->getPaymentID(); if (!($paymentXmlStr = $PaymentDetails->getPayment($paymentID))) { // xml failed } else { if (!($paymentDomDoc = domxml_open_mem($paymentXmlStr))) { // error domDoc } else { $payment = new Payment(); $payment->parseDomDocument($paymentDomDoc); $assessedValue = 0; // added "orYear" for fix of Feb 08, 2005 $this->formArray["orYear"] = substr($payment->dueDate, 0, 4); $this->setvar("orYear", $this->formArray["orYear"], false); if ($i <= 6) { $this->setvar("ownerName" . $i, $this->getReceivedFromName($receipt->getReceivedFrom())); if ($payment->getDueID() != "" && $payment->getDueID() != "0") { // due payment $due = $this->getDue($payment->getDueID()); $td = $this->getTD($due->getTdID()); $afs = $this->getAFS($td->getAfsID()); $tdNum = $td->getTaxDeclarationNumber(); if ($td->getPropertyType() == "Land") { $this->setvar("assessedValueLand" . $i, $afs->getTotalAssessedValue(), true); } else { $this->setvar("assessedValueOthers" . $i, $afs->getTotalAssessedValue(), true); } $assessedValue = $afs->getTotalAssessedValue(); if ($payment->getDueType() == "Annual") { // commented out: February 08, 2005 // "fullPmt" must be total paid less penalties... (tax due) //$this->setvar("fullPmt".$i,$collection->getBalanceDue(),true); $this->setvar("fullPmt" . $i, $collection->getTaxDue(), true); } else { $this->setvar("num" . $i, $payment->getDueType()); // commented out: February 08, 2005 // $this->setvar("partialPmt".$i,$collection->getBalanceDue(),true); $this->setvar("partialPmt" . $i, $collection->getTaxDue(), true); } } else { if ($payment->getBacktaxTDID() != "" && $payment->getBacktaxTDID() != "0") { // backtaxtd payment $backtaxTD = $this->getBacktaxTD($payment->getBacktaxTDID()); $parentTD = $this->getTD($backtaxTD->getTdID()); $afs = $this->getAFS($parentTD->getAfsID()); $tdNum = $backtaxTD->getTDNumber(); $assessedValue = $backtaxTD->getAssessedValue(); if ($payment->getDueType() == "Annual") { // commented out: February 08, 2005 // $this->setvar("fullPmt".$i,$collection->getBalanceDue(),true); $this->setvar("fullPmt" . $i, $collection->getTaxDue(), true); } else { $this->setvar("num" . $i, $payment->getDueType()); // commented out: February 08, 2005 // $this->setvar("partialPmt".$i,$collection->getBalanceDue(),true); $this->setvar("partialPmt" . $i, $collection->getTaxDue(), true); } } } $od = $this->getOD($afs->getOdID()); $this->setvar("lotAddress" . $i, $od->locationAddress->getStreet() . ", " . $od->locationAddress->getBarangay()); $this->setvar("blockNumber" . $i, $od->getLotNumber() . ", " . $od->getBlockNumber()); $this->setvar("landClass" . $i, $payment->getPropertyClassification()); $this->setvar("tdNum" . $i, $tdNum); $this->setvar("dueDate" . $i, "(" . substr($payment->getDueDate(), 0, 4) . ")"); $this->setvar("assessedValue" . $i, $assessedValue, true); $this->setvar("subTotal" . $i, $collection->getTaxDue(), true); if ($collection->getPenalty() > 0) { if ($collection->getAmnesty() == "true") { // $this->setvar("penalty".$i,round((($collection->getPenalty()/$collection->getTaxDue())*100)) . " % (amnesty)",true); $this->setvar("penalty" . $i, $collection->getPenalty()); } else { // $this->setvar("penalty".$i,round((($collection->getPenalty()/$collection->getTaxDue())*100)) . " %",true); $this->setvar("penalty" . $i, $collection->getPenalty()); } } $this->setvar("grandTotal" . $i, $collection->getAmountPaid(), true); $totalAmountPaid += $collection->getAmountPaid(); //Inserted by cht 07282008 $sefTotal = $total; $netAmountPaid = $totalAmountPaid * 2; //End } } } } } // ORIG //$this->setvar("total",$totalAmountPaid,true); //$this->setvar("amountPaid",$totalAmountPaid,true); //$totalInWords = makewords($totalAmountPaid); $this->setvar("sefTotal", $totalAmountPaid, true); $this->setvar("total", $totalAmountPaid, true); $this->setvar("amountPaid", $netAmountPaid, true); $totalInWords = makewords($netAmountPaid); // $totalInWords = "One Hundred Thousand Two Hundred Thirty Four Pesos And Fifty Seven Centavos Only"; if (strlen($totalInWords) < 62) { $this->setvar("y1TotalInWords", "254"); } else { $this->setvar("y1TotalInWords", "263"); } $this->setvar("totalInWords", $totalInWords); } } } $this->tpl->parse("ReceiptPageBlock", "ReceiptPage", true); $pageNumber++; $this->clearLine(); } //exit; $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } }
function Main() { $eRPTSSettings = new eRPTSSettings(); if ($eRPTSSettings->selectRecord(1)) { $this->tpl->set_var("lguType", strtoupper($eRPTSSettings->getLguType())); $this->tpl->set_var("lguName", strtoupper($eRPTSSettings->getLguName())); } $dbPayment = new DB_RPTS(); $dbTD = new DB_RPTS(); $dbBacktaxTD = new DB_RPTS(); $dbDue = new DB_RPTS(); $dbPaymentTD = new DB_RPTS(); $dbPaymentBacktaxTD = new DB_RPTS(); $dbCollection = new DB_RPTS(); // gather unique TD's and BacktaxTD's from Payments for year $sqlPayment = "SELECT paymentID, " . "tdID, " . "backtaxTDID " . "FROM Payment " . "WHERE status!='cancelled' " . "AND YEAR(paymentDate) LIKE '" . $this->formArray["year"] . "' " . "GROUP BY tdID, backtaxTDID " . "ORDER BY paymentID DESC "; $dbPayment->query($sqlPayment); if ($dbPayment->nf() > 0) { while ($dbPayment->next_record()) { $year = ""; $pageRecord = array("propertyIndexNumber" => "", "tdNumber" => "", "paidBasic" => 0, "paidSef" => 0, "discount" => 0, "basicSef" => 0, "yearDel" => "", "basicDel" => 0, "sefDel" => 0, "penalty" => 0, "totalDel" => 0, "totalAmount" => 0); if ($dbPayment->f("backtaxTDID") != 0) { // ------- start of BacktaxTD condition ------------------------- // // gather BacktaxTD details $sqlBacktaxTD = "SELECT tdNumber as tdNumber, " . "startYear as year " . "FROM BacktaxTD " . "WHERE " . "backtaxTDID = '" . $dbPayment->f("backtaxTDID") . "' "; $dbBacktaxTD->query($sqlBacktaxTD); if ($dbBacktaxTD->next_record()) { $pageRecord["tdNumber"] = $dbBacktaxTD->f("tdNumber"); $year = $dbBacktaxTD->f("year"); } // gather Payments for BacktaxTD for this year $sqlPaymentBacktaxTD = "SELECT * " . "FROM Payment WHERE " . "backtaxTDID='" . $dbPayment->f("backtaxTDID") . "' " . "AND YEAR(paymentDate) LIKE '" . $this->formArray["year"] . "' " . "AND status!='cancelled' " . "ORDER BY paymentID DESC "; $dbPaymentBacktaxTD->query($sqlPaymentBacktaxTD); if ($dbPaymentBacktaxTD->nf() > 0) { while ($dbPaymentBacktaxTD->next_record()) { // gather Collections for Payment $sqlCollection = "SELECT * " . "FROM Collection " . "WHERE paymentID='" . $dbPaymentBacktaxTD->f("paymentID") . "' " . "AND Collection.status!='cancelled' " . "ORDER BY collectionID DESC "; $dbCollection->query($sqlCollection); if ($dbCollection->nf() > 0) { while ($dbCollection->next_record()) { switch ($dbCollection->f("taxType")) { case "basic": // paidBasic $paidBasic = 0; if ($dbCollection->f("amnesty") != "true") { $paidBasic = $dbCollection->f("amountPaid") - $dbCollection->f("penalty"); // penalty, basicDel and totalDel if ($dbCollection->f("penalty") > 0) { $pageRecord["yearDel"] = $year; // basicDel $basicDel = 0; $basicDel = $dbCollection->f("taxDue"); // penalty $penalty = 0; $penalty = $dbCollection->f("penalty"); // totalDel $totalDel = $basicDel + $penalty; $pageRecord["basicDel"] += $basicDel; $pageRecord["penalty"] += $penalty; $pageRecord["totalDel"] += $totalDel; // totalAmount $pageRecord["totalAmount"] += $penalty; } } $paidBasic = $paidBasic + ($dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount")); // discount $discount = $dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount"); // basicSef $basicSef = $paidBasic - $discount; $pageRecord["paidBasic"] += $paidBasic; $pageRecord["discount"] += $discount; $pageRecord["basicSef"] += $basicSef; // totalAmount $pageRecord["totalAmount"] += $basicSef; break; case "sef": // paidSef $paidSef = 0; if ($dbCollection->f("amnesty") != "true") { $paidSef = $dbCollection->f("amountPaid") - $dbCollection->f("penalty"); // penalty, sefDel and totalDel if ($dbCollection->f("penalty") > 0) { $pageRecord["yearDel"] = $year; // sefDel $sefDel = 0; $sefDel = $dbCollection->f("taxDue"); // penalty $penalty = 0; $penalty = $dbCollection->f("penalty"); // totalDel $totalDel = $sefDel + $penalty; $pageRecord["sefDel"] += $sefDel; $pageRecord["penalty"] += $penalty; $pageRecord["totalDel"] += $totalDel; // totalAmount $pageRecord["totalAmount"] += $penalty; } } $paidSef = $paidSef + ($dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount")); // discount $discount = $dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount"); // basicSef $basicSef = $paidSef - $discount; $pageRecord["paidSef"] += $paidSef; $pageRecord["discount"] += $discount; $pageRecord["basicSef"] += $basicSef; // totalAmount $pageRecord["totalAmount"] += $basicSef; break; } } } } } // ------- start of BacktaxTD condition ------------------------- // } else { if ($dbPayment->f("tdID") != 0) { // ------- start of TD condition ------------------------- // // gather TD details $sqlTD = "SELECT AFS.propertyIndexNumber as propertyIndexNumber, " . "TD.taxDeclarationNumber as taxDeclarationNumber " . "FROM TD, AFS " . "WHERE " . "TD.afsID = AFS.afsID " . "AND TD.tdID='" . $dbPayment->f("tdID") . "' " . "AND TD.archive!='true' " . "AND AFS.archive!='true' "; $dbTD->query($sqlTD); if ($dbTD->next_record()) { $pageRecord["propertyIndexNumber"] = $dbTD->f("propertyIndexNumber"); $pageRecord["tdNumber"] = $dbTD->f("taxDeclarationNumber"); } // gather dueDate Year from Due $sqlDue = "SELECT YEAR(dueDate) as year " . "FROM Due " . "WHERE tdID='" . $dbPayment->f("tdID") . "' " . "AND dueType='Annual' "; $dbDue->query($sqlDue); if ($dbDue->next_record()) { $year = $dbDue->f("year"); } // gather Payments for TD for this year $sqlPaymentTD = "SELECT * " . "FROM Payment WHERE " . "tdID='" . $dbPayment->f("tdID") . "' " . "AND YEAR(paymentDate) LIKE '" . $this->formArray["year"] . "' " . "AND status!='cancelled' " . "ORDER BY paymentID DESC "; $dbPaymentTD->query($sqlPaymentTD); if ($dbPaymentTD->nf() > 0) { while ($dbPaymentTD->next_record()) { // gather Collections for Payment $sqlCollection = "SELECT * " . "FROM Collection " . "WHERE paymentID='" . $dbPaymentTD->f("paymentID") . "' " . "AND Collection.status!='cancelled' " . "ORDER BY collectionID DESC "; $dbCollection->query($sqlCollection); if ($dbCollection->nf() > 0) { while ($dbCollection->next_record()) { switch ($dbCollection->f("taxType")) { case "basic": // paidBasic $paidBasic = 0; if ($dbCollection->f("amnesty") != "true") { $paidBasic = $dbCollection->f("amountPaid") - $dbCollection->f("penalty"); // penalty, basicDel and totalDel if ($dbCollection->f("penalty") > 0) { $pageRecord["yearDel"] = $year; // basicDel $basicDel = 0; $basicDel = $dbCollection->f("taxDue"); // penalty $penalty = 0; $penalty = $dbCollection->f("penalty"); // totalDel $totalDel = $basicDel + $penalty; $pageRecord["basicDel"] += $basicDel; $pageRecord["penalty"] += $penalty; $pageRecord["totalDel"] += $totalDel; // totalAmount $pageRecord["totalAmount"] += $penalty; } } $paidBasic = $paidBasic + ($dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount")); // discount $discount = $dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount"); // basicSef $basicSef = $paidBasic - $discount; $pageRecord["paidBasic"] += $paidBasic; $pageRecord["discount"] += $discount; $pageRecord["basicSef"] += $basicSef; // totalAmount $pageRecord["totalAmount"] += $basicSef; break; case "sef": // paidSef $paidSef = 0; if ($dbCollection->f("amnesty") != "true") { $paidSef = $dbCollection->f("amountPaid") - $dbCollection->f("penalty"); // penalty, sefDel and totalDel if ($dbCollection->f("penalty") > 0) { $pageRecord["yearDel"] = $year; // sefDel $sefDel = 0; $sefDel = $dbCollection->f("taxDue"); // penalty $penalty = 0; $penalty = $dbCollection->f("penalty"); // totalDel $totalDel = $sefDel + $penalty; $pageRecord["sefDel"] += $sefDel; $pageRecord["penalty"] += $penalty; $pageRecord["totalDel"] += $totalDel; // totalAmount $pageRecord["totalAmount"] += $penalty; } } $paidSef = $paidSef + ($dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount")); // discount $discount = $dbCollection->f("earlyPaymentDiscount") + $dbCollection->f("advancedPaymentDiscount"); // basicSef $basicSef = $paidSef - $discount; $pageRecord["paidSef"] += $paidSef; $pageRecord["discount"] += $discount; $pageRecord["basicSef"] += $basicSef; // totalAmount $pageRecord["totalAmount"] += $basicSef; break; } } } } } // ------- end of TD condition ------------------------- // } } $pageRecordArrayList[] = $pageRecord; unset($pageRecord); } if (is_array($pageRecordArrayList)) { $ypos = 426; $decrementYposBy = 12; $linesPerPage = 24; $count = count($pageRecordArrayList); $numOfPages = ceil($count / $linesPerPage); $pageCtr = 1; $lineCtr = 1; $recordCtr = 1; $this->tpl->set_var("year", $this->formArray["year"]); $this->tpl->set_var("numOfPages", $numOfPages); $this->tpl->set_block("rptsTemplate", "Page", "PageBlock"); $this->tpl->set_block("Page", "Row", "RowBlock"); $this->tpl->set_block("Page", "Totals", "TotalsBlock"); $totalsArray = array("totalPaidBasic" => 0, "totalPaidSef" => 0, "totalDiscount" => 0, "totalBasicSef" => 0, "totalBasicDel" => 0, "totalSefDel" => 0, "totalPenalty" => 0, "totalTotalDel" => 0, "totalTotalAmount" => 0); foreach ($pageRecordArrayList as $recordArray) { $this->tpl->set_var("ypos", $ypos); $this->tpl->set_var("recordCtr", $recordCtr); // write values $totalsArray["totalPaidBasic"] += un_number_format($recordArray["paidBasic"]); $totalsArray["totalPaidSef"] += un_number_format($recordArray["paidSef"]); $totalsArray["totalDiscount"] += un_number_format($recordArray["discount"]); $totalsArray["totalBasicSef"] += un_number_format($recordArray["basicSef"]); $totalsArray["totalBasicDel"] += un_number_format($recordArray["basicDel"]); $totalsArray["totalSefDel"] += un_number_format($recordArray["sefDel"]); $totalsArray["totalPenalty"] += un_number_format($recordArray["penalty"]); $totalsArray["totalTotalDel"] += un_number_format($recordArray["totalDel"]); $totalsArray["totalTotalAmount"] += un_number_format($recordArray["totalAmount"]); foreach ($recordArray as $key => $value) { switch ($key) { case "paidBasic": case "paidSef": case "discount": case "basicSef": case "basicDel": case "sefDel": case "penalty": case "totalDel": case "totalAmount": $value = formatCurrency($value); break; } $this->tpl->set_var($key, $value); } $this->tpl->parse("RowBlock", "Row", true); if ($recordCtr == count($pageRecordArrayList) || $lineCtr == $linesPerPage) { if ($pageCtr == $numOfPages) { foreach ($totalsArray as $key => $value) { $value = formatCurrency($value); $this->tpl->set_var($key, $value); } $this->tpl->parse("TotalsBlock", "Totals", true); } else { $this->tpl->set_var("TotalsBlock", ""); } $this->tpl->set_var("page", $pageCtr); $this->tpl->parse("PageBlock", "Page", true); $this->tpl->set_var("RowBlock", ""); $this->tpl->set_var("TotalsBlock", ""); $ypos = 426; $lineCtr = 0; $pageCtr++; } $lineCtr++; $recordCtr++; $ypos = $ypos - $decrementYposBy; } $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); } else { exit("no collections to list for " . $this->formArray["year"]); } } else { exit("no collections to list for " . $this->formArray["year"]); } $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } }
function Main() { $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { exit("afs not found"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { exit("error xmlDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->displayODAFS($this->formArray["afsID"]); $this->formArray["propertyIndexNumber"] = $afs->propertyIndexNumber; //inserted this code for arpNumber - renonj $this->formArray["arpNumber"] = $afs->getArpNumber(); $this->formArray["taxability"] = $afs->getTaxability(); //Inserted by CHT 07292008 if ($afs->getTaxability() == "Taxable") { $this->formArray["isTaxable"] = "X"; $this->formArray["isExempt"] = " "; } else { if ($afs->getTaxability() == "Exempt") { $this->formArray["isExempt"] = "X"; $this->formArray["isTaxable"] = " "; } } //End //land $landList = $afs->getLandArray(); if (count($landList)) { $this->displayLandList($landList); } //plantsTrees $plantsTreesList = $afs->getPlantsTreesArray(); if (count($plantsTreesList)) { $this->displayPlantsTreesList($plantsTreesList); } //improvementsBuildings $improvementsBuildingsList = $afs->getImprovementsBuildingsArray(); if (count($improvementsBuildingsList)) { $this->displayImprovementsBuildingsList($improvementsBuildingsList); } //machineries $machineriesList = $afs->getMachineriesArray(); if (count($machineriesList)) { $this->displayMachineriesList($machineriesList); } $this->displayAssessedValues($landList, $plantsTreesList, $improvementsBuildingsList, $machineriesList); $this->displayLGUInfo(); } } $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF("TDSummary.pdf"); //,$this->formArray["print"]); } else { $testpdf->writePDF("TDSummary.pdf"); } // header("location: ".$testpdf->pdfPath); exit; }
function Main() { $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) { exit("afs not found"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { exit("error xmlDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->formArray["arpNumber"] = $afs->arpNumber; $this->formArray["propertyIndexNumber"] = $afs->propertyIndexNumber; $this->displayODAFS($this->formArray["afsID"]); $landList = $afs->getLandArray(); if (count($landList)) { $this->displayLandList($landList); } $plantsTreesList = $afs->getPlantsTreesArray(); if (count($plantsTreesList)) { $this->displayPlantsTreesList($plantsTreesList); } } } $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } //header("location: ".$testpdf->pdfPath); exit; }
function Main() { global $DBid; $this->tpl->set_var("Session", $this->sess->url("")); $this->tpl->set_var("date", date("F d, Y")); $this->subRETaxableRealPropertyUnits = 0; $this->subRETaxableLandArea = 0; $this->subAGTaxableRealPropertyUnits = 0; $this->subAGTaxableLandArea = 0; $this->subCOTaxableRealPropertyUnits = 0; $this->subCOTaxableLandArea = 0; $this->subINTaxableRealPropertyUnits = 0; $this->subINTaxableLandArea = 0; $this->subMITaxableRealPropertyUnits = 0; $this->subMITaxableLandArea = 0; $this->subTITaxableRealPropertyUnits = 0; $this->subTITaxableLandArea = 0; $this->subSPTaxableRealPropertyUnits = 0; $this->subSPTaxableLandArea = 0; $this->subHOTaxableRealPropertyUnits = 0; $this->subHOTaxableLandArea = 0; $this->subSCTaxableRealPropertyUnits = 0; $this->subSCTaxableLandArea = 0; $this->subCUTaxableRealPropertyUnits = 0; $this->subCUTaxableLandArea = 0; $this->subOTTaxableRealPropertyUnits = 0; $this->subOTTaxableLandArea = 0; $this->subGOExemptRealPropertyUnits = 0; $this->subGOExemptLandArea = 0; $this->subRLExemptRealPropertyUnits = 0; $this->subRLExemptLandArea = 0; $this->subCHExemptRealPropertyUnits = 0; $this->subCHExemptLandArea = 0; $this->subEDExemptRealPropertyUnits = 0; $this->subEDExemptLandArea = 0; $this->subOTExemptRealPropertyUnits = 0; $this->subOTExemptLandArea = 0; $this->subRETaxableLandMarketValue = 0; $this->subRETaxableLandAssessedValue = 0; $this->subAGTaxableLandMarketValue = 0; $this->subAGTaxableLandAssessedValue = 0; $this->subCOTaxableLandMarketValue = 0; $this->subCOTaxableLandAssessedValue = 0; $this->subINTaxableLandMarketValue = 0; $this->subINTaxableLandAssessedValue = 0; $this->subMITaxableLandMarketValue = 0; $this->subMITaxableLandAssessedValue = 0; $this->subTITaxableLandMarketValue = 0; $this->subTITaxableLandAssessedValue = 0; $this->subSPTaxableLandMarketValue = 0; $this->subSPTaxableLandAssessedValue = 0; $this->subHOTaxableLandMarketValue = 0; $this->subHOTaxableLandAssessedValue = 0; $this->subSCTaxableLandMarketValue = 0; $this->subSCTaxableLandAssessedValue = 0; $this->subCUTaxableLandMarketValue = 0; $this->subCUTaxableLandAssessedValue = 0; $this->subOTTaxableLandMarketValue = 0; $this->subOTTaxableLandAssessedValue = 0; $this->subGOExemptLandMarketValue = 0; $this->subGOExemptLandAssessedValue = 0; $this->subRLExemptLandMarketValue = 0; $this->subRLExemptLandAssessedValue = 0; $this->subCHExemptLandMarketValue = 0; $this->subCHExemptLandAssessedValue = 0; $this->subEDExemptLandMarketValue = 0; $this->subEDExemptLandAssessedValue = 0; $this->subOTExemptLandMarketValue = 0; $this->subOTExemptLandAssessedValue = 0; $this->subRETaxableBldgLessMarketValue = 0; $this->subRETaxableBldgLessAssessedValue = 0; $this->subAGTaxableBldgLessMarketValue = 0; $this->subAGTaxableBldgLessAssessedValue = 0; $this->subCOTaxableBldgLessMarketValue = 0; $this->subCOTaxableBldgLessAssessedValue = 0; $this->subINTaxableBldgLessMarketValue = 0; $this->subINTaxableBldgLessAssessedValue = 0; $this->subMITaxableBldgLessMarketValue = 0; $this->subMITaxableBldgLessAssessedValue = 0; $this->subTITaxableBldgLessMarketValue = 0; $this->subTITaxableBldgLessAssessedValue = 0; $this->subSPTaxableBldgLessMarketValue = 0; $this->subSPTaxableBldgLessAssessedValue = 0; $this->subHOTaxableBldgLessMarketValue = 0; $this->subHOTaxableBldgLessAssessedValue = 0; $this->subSCTaxableBldgLessMarketValue = 0; $this->subSCTaxableBldgLessAssessedValue = 0; $this->subCUTaxableBldgLessMarketValue = 0; $this->subCUTaxableBldgLessAssessedValue = 0; $this->subOTTaxableBldgLessMarketValue = 0; $this->subOTTaxableBldgLessAssessedValue = 0; $this->subGOExemptBldgLessMarketValue = 0; $this->subGOExemptBldgLessAssessedValue = 0; $this->subRLExemptBldgLessMarketValue = 0; $this->subRLExemptBldgLessAssessedValue = 0; $this->subCHExemptBldgLessMarketValue = 0; $this->subCHExemptBldgLessAssessedValue = 0; $this->subEDExemptBldgLessMarketValue = 0; $this->subEDExemptBldgLessAssessedValue = 0; $this->subOTExemptBldgLessMarketValue = 0; $this->subOTExemptBldgLessAssessedValue = 0; $this->subRETaxableBldgOverMarketValue = 0; $this->subRETaxableBldgOverAssessedValue = 0; $this->subAGTaxableBldgOverMarketValue = 0; $this->subAGTaxableBldgOverAssessedValue = 0; $this->subCOTaxableBldgOverMarketValue = 0; $this->subCOTaxableBldgOverAssessedValue = 0; $this->subINTaxableBldgOverMarketValue = 0; $this->subINTaxableBldgOverAssessedValue = 0; $this->subMITaxableBldgOverMarketValue = 0; $this->subMITaxableBldgOverAssessedValue = 0; $this->subTITaxableBldgOverMarketValue = 0; $this->subTITaxableBldgOverAssessedValue = 0; $this->subSPTaxableBldgOverMarketValue = 0; $this->subSPTaxableBldgOverAssessedValue = 0; $this->subHOTaxableBldgOverMarketValue = 0; $this->subHOTaxableBldgOverAssessedValue = 0; $this->subSCTaxableBldgOverMarketValue = 0; $this->subSCTaxableBldgOverAssessedValue = 0; $this->subCUTaxableBldgOverMarketValue = 0; $this->subCUTaxableBldgOverAssessedValue = 0; $this->subOTTaxableBldgOverMarketValue = 0; $this->subOTTaxableBldgOverAssessedValue = 0; $this->subGOExemptBldgOverMarketValue = 0; $this->subGOExemptBldgOverAssessedValue = 0; $this->subRLExemptBldgOverMarketValue = 0; $this->subRLExemptBldgOverAssessedValue = 0; $this->subCHExemptBldgOverMarketValue = 0; $this->subCHExemptBldgOverAssessedValue = 0; $this->subEDExemptBldgOverMarketValue = 0; $this->subEDExemptBldgOverAssessedValue = 0; $this->subOTExemptBldgOverMarketValue = 0; $this->subOTExemptBldgOverAssessedValue = 0; $this->subRETaxableMachMarketValue = 0; $this->subRETaxableMachAssessedValue = 0; $this->subAGTaxableMachMarketValue = 0; $this->subAGTaxableMachAssessedValue = 0; $this->subCOTaxableMachMarketValue = 0; $this->subCOTaxableMachAssessedValue = 0; $this->subINTaxableMachMarketValue = 0; $this->subINTaxableMachAssessedValue = 0; $this->subMITaxableMachMarketValue = 0; $this->subMITaxableMachAssessedValue = 0; $this->subTITaxableMachMarketValue = 0; $this->subTITaxableMachAssessedValue = 0; $this->subSPTaxableMachMarketValue = 0; $this->subSPTaxableMachAssessedValue = 0; $this->subHOTaxableMachMarketValue = 0; $this->subHOTaxableMachAssessedValue = 0; $this->subSCTaxableMachMarketValue = 0; $this->subSCTaxableMachAssessedValue = 0; $this->subCUTaxableMachMarketValue = 0; $this->subCUTaxableMachAssessedValue = 0; $this->subOTTaxableMachMarketValue = 0; $this->subOTTaxableMachAssessedValue = 0; $this->subGOExemptMachMarketValue = 0; $this->subGOExemptMachAssessedValue = 0; $this->subRLExemptMachMarketValue = 0; $this->subRLExemptMachAssessedValue = 0; $this->subCHExemptMachMarketValue = 0; $this->subCHExemptMachAssessedValue = 0; $this->subEDExemptMachMarketValue = 0; $this->subEDExemptMachAssessedValue = 0; $this->subOTExemptMachMarketValue = 0; $this->subOTExemptMachAssessedValue = 0; $this->subRETaxableOtherMarketValue = 0; $this->subRETaxableOtherAssessedValue = 0; $this->subAGTaxableOtherMarketValue = 0; $this->subAGTaxableOtherAssessedValue = 0; $this->subCOTaxableOtherMarketValue = 0; $this->subCOTaxableOtherAssessedValue = 0; $this->subINTaxableOtherMarketValue = 0; $this->subINTaxableOtherAssessedValue = 0; $this->subMITaxableOtherMarketValue = 0; $this->subMITaxableOtherAssessedValue = 0; $this->subTITaxableOtherMarketValue = 0; $this->subTITaxableOtherAssessedValue = 0; $this->subSPTaxableOtherMarketValue = 0; $this->subSPTaxableOtherAssessedValue = 0; $this->subHOTaxableOtherMarketValue = 0; $this->subHOTaxableOtherAssessedValue = 0; $this->subSCTaxableOtherMarketValue = 0; $this->subSCTaxableOtherAssessedValue = 0; $this->subCUTaxableOtherMarketValue = 0; $this->subCUTaxableOtherAssessedValue = 0; $this->subOTTaxableOtherMarketValue = 0; $this->subOTTaxableOtherAssessedValue = 0; $this->subGOExemptOtherMarketValue = 0; $this->subGOExemptOtherAssessedValue = 0; $this->subRLExemptOtherMarketValue = 0; $this->subRLExemptOtherAssessedValue = 0; $this->subCHExemptOtherMarketValue = 0; $this->subCHExemptOtherAssessedValue = 0; $this->subEDExemptOtherMarketValue = 0; $this->subEDExemptOtherAssessedValue = 0; $this->subOTExemptOtherMarketValue = 0; $this->subOTExemptOtherAssessedValue = 0; $this->totalRETaxableMarketValue = 0; $this->totalRETaxableAssessedValue = 0; $this->totalAGTaxableMarketValue = 0; $this->totalAGTaxableAssessedValue = 0; $this->totalCOTaxableMarketValue = 0; $this->totalCOTaxableAssessedValue = 0; $this->totalINTaxableMarketValue = 0; $this->totalINTaxableAssessedValue = 0; $this->totalMITaxableMarketValue = 0; $this->totalMITaxableAssessedValue = 0; $this->totalTITaxableMarketValue = 0; $this->totalTITaxableAssessedValue = 0; $this->totalSPTaxableMarketValue = 0; $this->totalSPTaxableAssessedValue = 0; $this->totalHOTaxableMarketValue = 0; $this->totalHOTaxableAssessedValue = 0; $this->totalSCTaxableMarketValue = 0; $this->totalSCTaxableAssessedValue = 0; $this->totalCUTaxableMarketValue = 0; $this->totalCUTaxableAssessedValue = 0; $this->totalOTTaxableMarketValue = 0; $this->totalOTTaxableAssessedValue = 0; $this->totalGOExemptMarketValue = 0; $this->totalGOExemptAssessedValue = 0; $this->totalRLExemptMarketValue = 0; $this->totalRLExemptAssessedValue = 0; $this->totalCHExemptMarketValue = 0; $this->totalCHExemptAssessedValue = 0; $this->totalEDExemptMarketValue = 0; $this->totalEDExemptAssessedValue = 0; $this->totalOTExemptMarketValue = 0; $this->totalOTExemptAssessedValue = 0; $this->totalTaxableRealPropertyUnits = 0; $this->totalTaxableLandArea = 0; $this->totalTaxableLandMarketValue = 0; $this->totalTaxableLandAssessedValue = 0; $this->totalTaxableBldgLessMarketValue = 0; $this->totalTaxableBldgLessAssessedValue = 0; $this->totalTaxableBldgOverMarketValue = 0; $this->totalTaxableBldgOverAssessedValue = 0; $this->totalTaxableMachMarketValue = 0; $this->totalTaxableMachAssessedValue = 0; $this->totalTaxableOtherMarketValue = 0; $this->totalTaxableOtherAssessedValue = 0; $this->totalTaxableMarketValue = 0; $this->totalTaxableAssessedValue = 0; $this->totalExemptRealPropertyUnits = 0; $this->totalExemptLandArea = 0; $this->totalExemptLandMarketValue = 0; $this->totalExemptLandAssessedValue = 0; $this->totalExemptBldgLessMarketValue = 0; $this->totalExemptBldgLessAssessedValue = 0; $this->totalExemptBldgOverMarketValue = 0; $this->totalExemptBldgOverAssessedValue = 0; $this->totalExemptMachMarketValue = 0; $this->totalExemptMachAssessedValue = 0; $this->totalExemptOtherMarketValue = 0; $this->totalExemptOtherAssessedValue = 0; $this->totalExemptMarketValue = 0; $this->totalExemptAssessedValue = 0; $this->totalRealPropertyUnits = 0; $this->totalLandArea = 0; $this->totalLandMarketValue = 0; $this->totalLandAssessedValue = 0; $this->totalBldgLessMarketValue = 0; $this->totalBldgLessAssessedValue = 0; $this->totalBldgOverMarketValue = 0; $this->totalBldgOverAssessedValue = 0; $this->totalMachMarketValue = 0; $this->totalMachAssessedValue = 0; $this->totalOtherMarketValue = 0; $this->totalOtherAssessedValue = 0; $this->totalMarketValue = 0; $this->totalAssessedValue = 0; $ctr = 1; $this->dbs = ""; foreach ($DBid as $key => $value) { $lgu = new LGU(); $lgu->selectRecord($value); $this->dbName = $lgu->getLGUDB(); if ($ctr == 1) { $this->dbs = $lgu->getLGUName(); } else { $this->dbs .= " - " . $lgu->getLGUName(); } $ctr++; $sql = "SELECT a.reportCode as reportCode, b.actualUse, count(b.propertyID) as rpu, sum( b.assessedValue ) as assessedValue, sum( b.adjustedMarketValue ) as adjustedMarketValue, sum(area) as area" . " FROM LandActualUses a" . " LEFT JOIN Land b ON a.landActualUsesID = b.actualUse" . " GROUP BY a.reportCode;"; $this->computeProperty("Land", $sql); $sql = "SELECT a.reportCode as reportCode, b.actualUse, count(b.propertyID), sum( b.assessedValue ) as assessedValue, sum( b.adjustedMarketValue ) as adjustedMarketValue" . " FROM ImprovementsBuildingsActualUses a" . " LEFT JOIN ImprovementsBuildings b ON a.improvementsBuildingsActualUsesID = b.actualUse AND b.adjustedMarketValue <= 175000" . " GROUP BY a.reportCode;"; $this->computeProperty("BldgLess", $sql); $sql = "SELECT a.reportCode as reportCode, b.actualUse, count(b.propertyID), sum( b.assessedValue ) as assessedValue, sum( b.adjustedMarketValue ) as adjustedMarketValue" . " FROM ImprovementsBuildingsActualUses a" . " LEFT JOIN ImprovementsBuildings b ON a.improvementsBuildingsActualUsesID = b.actualUse AND b.adjustedMarketValue > 175000" . " GROUP BY a.reportCode;"; $this->computeProperty("BldgOver", $sql); $sql = "SELECT a.reportCode as reportCode, b.actualUse, count(b.propertyID), sum( b.assessedValue ) as assessedValue, sum( b.adjustedMarketValue ) as adjustedMarketValue" . " FROM MachineriesActualUses a" . " LEFT JOIN Machineries b ON a.machineriesActualUsesID = b.actualUse" . " GROUP BY a.reportCode;"; $this->computeProperty("Mach", $sql); $this->countRealPropertyUnits(); } $this->tpl->set_var("RETaxable_RealPropertyUnits", number_format($this->subRETaxableRealPropertyUnits)); $this->tpl->set_var("RETaxable_LandArea", $this->checkNumericFormat($this->subRETaxableLandArea)); $this->tpl->set_var("AGTaxable_RealPropertyUnits", number_format($this->subAGTaxableRealPropertyUnits)); $this->tpl->set_var("AGTaxable_LandArea", $this->checkNumericFormat($this->subAGTaxableLandArea)); $this->tpl->set_var("COTaxable_RealPropertyUnits", number_format($this->subCOTaxableRealPropertyUnits)); $this->tpl->set_var("COTaxable_LandArea", $this->checkNumericFormat($this->subCOTaxableLandArea)); $this->tpl->set_var("INTaxable_RealPropertyUnits", number_format($this->subINTaxableRealPropertyUnits)); $this->tpl->set_var("INTaxable_LandArea", $this->checkNumericFormat($this->subINTaxableLandArea)); $this->tpl->set_var("MITaxable_RealPropertyUnits", number_format($this->subMITaxableRealPropertyUnits)); $this->tpl->set_var("MITaxable_LandArea", $this->checkNumericFormat($this->subMITaxableLandArea)); $this->tpl->set_var("TITaxable_RealPropertyUnits", number_format($this->subTITaxableRealPropertyUnits)); $this->tpl->set_var("TITaxable_LandArea", $this->checkNumericFormat($this->subTITaxableLandArea)); $this->tpl->set_var("SPTaxable_RealPropertyUnits", number_format($this->subSPTaxableRealPropertyUnits)); $this->tpl->set_var("SPTaxable_LandArea", $this->checkNumericFormat($this->subSPTaxableLandArea)); $this->tpl->set_var("HOTaxable_RealPropertyUnits", number_format($this->subHOTaxableRealPropertyUnits)); $this->tpl->set_var("HOTaxable_LandArea", $this->checkNumericFormat($this->subHOTaxableLandArea)); $this->tpl->set_var("SCTaxable_RealPropertyUnits", number_format($this->subSCTaxableRealPropertyUnits)); $this->tpl->set_var("SCTaxable_LandArea", $this->checkNumericFormat($this->subSCTaxableLandArea)); $this->tpl->set_var("CUTaxable_RealPropertyUnits", number_format($this->subCUTaxableRealPropertyUnits)); $this->tpl->set_var("CUTaxable_LandArea", $this->checkNumericFormat($this->subCUTaxableLandArea)); $this->tpl->set_var("OTTaxable_RealPropertyUnits", number_format($this->subOTTaxableRealPropertyUnits)); $this->tpl->set_var("OTTaxable_LandArea", $this->checkNumericFormat($this->subOTTaxableLandArea)); $this->tpl->set_var("GOExempt_RealPropertyUnits", number_format($this->subGOExemptRealPropertyUnits)); $this->tpl->set_var("GOExempt_LandArea", $this->checkNumericFormat($this->subGOExemptLandArea)); $this->tpl->set_var("RLExempt_RealPropertyUnits", number_format($this->subRLExemptRealPropertyUnits)); $this->tpl->set_var("RLExempt_LandArea", $this->checkNumericFormat($this->subRLExemptLandArea)); $this->tpl->set_var("CHExempt_RealPropertyUnits", number_format($this->subCHExemptRealPropertyUnits)); $this->tpl->set_var("CHExempt_LandArea", $this->checkNumericFormat($this->subCHExemptLandArea)); $this->tpl->set_var("EDExempt_RealPropertyUnits", number_format($this->subEDExemptRealPropertyUnits)); $this->tpl->set_var("EDExempt_LandArea", $this->checkNumericFormat($this->subEDExemptLandArea)); $this->tpl->set_var("OTExempt_RealPropertyUnits", number_format($this->subOTExemptRealPropertyUnits)); $this->tpl->set_var("OTExempt_LandArea", $this->checkNumericFormat($this->subOTExemptLandArea)); $this->tpl->set_var("RETaxable_LandMV", $this->checkNumericFormat($this->subRETaxableLandMarketValue)); $this->tpl->set_var("RETaxable_LandAV", $this->checkNumericFormat($this->subRETaxableLandAssessedValue)); $this->tpl->set_var("AGTaxable_LandMV", $this->checkNumericFormat($this->subAGTaxableLandMarketValue)); $this->tpl->set_var("AGTaxable_LandAV", $this->checkNumericFormat($this->subAGTaxableLandAssessedValue)); $this->tpl->set_var("COTaxable_LandMV", $this->checkNumericFormat($this->subCOTaxableLandMarketValue)); $this->tpl->set_var("COTaxable_LandAV", $this->checkNumericFormat($this->subCOTaxableLandAssessedValue)); $this->tpl->set_var("INTaxable_LandMV", $this->checkNumericFormat($this->subINTaxableLandMarketValue)); $this->tpl->set_var("INTaxable_LandAV", $this->checkNumericFormat($this->subINTaxableLandAssessedValue)); $this->tpl->set_var("MITaxable_LandMV", $this->checkNumericFormat($this->subMITaxableLandMarketValue)); $this->tpl->set_var("MITaxable_LandAV", $this->checkNumericFormat($this->subMITaxableLandAssessedValue)); $this->tpl->set_var("TITaxable_LandMV", $this->checkNumericFormat($this->subTITaxableLandMarketValue)); $this->tpl->set_var("TITaxable_LandAV", $this->checkNumericFormat($this->subTITaxableLandAssessedValue)); $this->tpl->set_var("SPTaxable_LandMV", $this->checkNumericFormat($this->subSPTaxableLandMarketValue)); $this->tpl->set_var("SPTaxable_LandAV", $this->checkNumericFormat($this->subSPTaxableLandAssessedValue)); $this->tpl->set_var("HOTaxable_LandMV", $this->checkNumericFormat($this->subHOTaxableLandMarketValue)); $this->tpl->set_var("HOTaxable_LandAV", $this->checkNumericFormat($this->subHOTaxableLandAssessedValue)); $this->tpl->set_var("SCTaxable_LandMV", $this->checkNumericFormat($this->subSCTaxableLandMarketValue)); $this->tpl->set_var("SCTaxable_LandAV", $this->checkNumericFormat($this->subSCTaxableLandAssessedValue)); $this->tpl->set_var("CUTaxable_LandMV", $this->checkNumericFormat($this->subCUTaxableLandMarketValue)); $this->tpl->set_var("CUTaxable_LandAV", $this->checkNumericFormat($this->subCUTaxableLandAssessedValue)); $this->tpl->set_var("OTTaxable_LandMV", $this->checkNumericFormat($this->subOTTaxableLandMarketValue)); $this->tpl->set_var("OTTaxable_LandAV", $this->checkNumericFormat($this->subOTTaxableLandAssessedValue)); $this->tpl->set_var("GOExempt_LandMV", $this->checkNumericFormat($this->subGOExemptLandMarketValue)); $this->tpl->set_var("GOExempt_LandAV", $this->checkNumericFormat($this->subGOExemptLandAssessedValue)); $this->tpl->set_var("RLExempt_LandMV", $this->checkNumericFormat($this->subRLExemptLandMarketValue)); $this->tpl->set_var("RLExempt_LandAV", $this->checkNumericFormat($this->subRLExemptLandAssessedValue)); $this->tpl->set_var("CHExempt_LandMV", $this->checkNumericFormat($this->subCHExemptLandMarketValue)); $this->tpl->set_var("CHExempt_LandAV", $this->checkNumericFormat($this->subCHExemptLandAssessedValue)); $this->tpl->set_var("EDExempt_LandMV", $this->checkNumericFormat($this->subEDExemptLandMarketValue)); $this->tpl->set_var("EDExempt_LandAV", $this->checkNumericFormat($this->subEDExemptLandAssessedValue)); $this->tpl->set_var("OTExempt_LandMV", $this->checkNumericFormat($this->subOTExemptLandMarketValue)); $this->tpl->set_var("OTExempt_LandAV", $this->checkNumericFormat($this->subOTExemptLandAssessedValue)); $this->tpl->set_var("RETaxable_BldgLessMV", $this->checkNumericFormat($this->subRETaxableBldgLessMarketValue)); $this->tpl->set_var("RETaxable_BldgLessAV", $this->checkNumericFormat($this->subRETaxableBldgLessAssessedValue)); $this->tpl->set_var("AGTaxable_BldgLessMV", $this->checkNumericFormat($this->subAGTaxableBldgLessMarketValue)); $this->tpl->set_var("AGTaxable_BldgLessAV", $this->checkNumericFormat($this->subAGTaxableBldgLessAssessedValue)); $this->tpl->set_var("COTaxable_BldgLessMV", $this->checkNumericFormat($this->subCOTaxableBldgLessMarketValue)); $this->tpl->set_var("COTaxable_BldgLessAV", $this->checkNumericFormat($this->subCOTaxableBldgLessAssessedValue)); $this->tpl->set_var("INTaxable_BldgLessMV", $this->checkNumericFormat($this->subINTaxableBldgLessMarketValue)); $this->tpl->set_var("INTaxable_BldgLessAV", $this->checkNumericFormat($this->subINTaxableBldgLessAssessedValue)); $this->tpl->set_var("MITaxable_BldgLessMV", $this->checkNumericFormat($this->subMITaxableBldgLessMarketValue)); $this->tpl->set_var("MITaxable_BldgLessAV", $this->checkNumericFormat($this->subMITaxableBldgLessAssessedValue)); $this->tpl->set_var("TITaxable_BldgLessMV", $this->checkNumericFormat($this->subTITaxableBldgLessMarketValue)); $this->tpl->set_var("TITaxable_BldgLessAV", $this->checkNumericFormat($this->subTITaxableBldgLessAssessedValue)); $this->tpl->set_var("SPTaxable_BldgLessMV", $this->checkNumericFormat($this->subSPTaxableBldgLessMarketValue)); $this->tpl->set_var("SPTaxable_BldgLessAV", $this->checkNumericFormat($this->subSPTaxableBldgLessAssessedValue)); $this->tpl->set_var("HOTaxable_BldgLessMV", $this->checkNumericFormat($this->subHOTaxableBldgLessMarketValue)); $this->tpl->set_var("HOTaxable_BldgLessAV", $this->checkNumericFormat($this->subHOTaxableBldgLessAssessedValue)); $this->tpl->set_var("SCTaxable_BldgLessMV", $this->checkNumericFormat($this->subSCTaxableBldgLessMarketValue)); $this->tpl->set_var("SCTaxable_BldgLessAV", $this->checkNumericFormat($this->subSCTaxableBldgLessAssessedValue)); $this->tpl->set_var("CUTaxable_BldgLessMV", $this->checkNumericFormat($this->subCUTaxableBldgLessMarketValue)); $this->tpl->set_var("CUTaxable_BldgLessAV", $this->checkNumericFormat($this->subCUTaxableBldgLessAssessedValue)); $this->tpl->set_var("OTTaxable_BldgLessMV", $this->checkNumericFormat($this->subOTTaxableBldgLessMarketValue)); $this->tpl->set_var("OTTaxable_BldgLessAV", $this->checkNumericFormat($this->subOTTaxableBldgLessAssessedValue)); $this->tpl->set_var("GOExempt_BldgLessMV", $this->checkNumericFormat($this->subGOExemptBldgLessMarketValue)); $this->tpl->set_var("GOExempt_BldgLessAV", $this->checkNumericFormat($this->subGOExemptBldgLessAssessedValue)); $this->tpl->set_var("RLExempt_BldgLessMV", $this->checkNumericFormat($this->subRLExemptBldgLessMarketValue)); $this->tpl->set_var("RLExempt_BldgLessAV", $this->checkNumericFormat($this->subRLExemptBldgLessAssessedValue)); $this->tpl->set_var("CHExempt_BldgLessMV", $this->checkNumericFormat($this->subCHExemptBldgLessMarketValue)); $this->tpl->set_var("CHExempt_BldgLessAV", $this->checkNumericFormat($this->subCHExemptBldgLessAssessedValue)); $this->tpl->set_var("EDExempt_BldgLessMV", $this->checkNumericFormat($this->subEDExemptBldgLessMarketValue)); $this->tpl->set_var("EDExempt_BldgLessAV", $this->checkNumericFormat($this->subEDExemptBldgLessAssessedValue)); $this->tpl->set_var("OTExempt_BldgLessMV", $this->checkNumericFormat($this->subOTExemptBldgLessMarketValue)); $this->tpl->set_var("OTExempt_BldgLessAV", $this->checkNumericFormat($this->subOTExemptBldgLessAssessedValue)); $this->tpl->set_var("RETaxable_BldgOverMV", $this->checkNumericFormat($this->subRETaxableBldgOverMarketValue)); $this->tpl->set_var("RETaxable_BldgOverAV", $this->checkNumericFormat($this->subRETaxableBldgOverAssessedValue)); $this->tpl->set_var("AGTaxable_BldgOverMV", $this->checkNumericFormat($this->subAGTaxableBldgOverMarketValue)); $this->tpl->set_var("AGTaxable_BldgOverAV", $this->checkNumericFormat($this->subAGTaxableBldgOverAssessedValue)); $this->tpl->set_var("COTaxable_BldgOverMV", $this->checkNumericFormat($this->subCOTaxableBldgOverMarketValue)); $this->tpl->set_var("COTaxable_BldgOverAV", $this->checkNumericFormat($this->subCOTaxableBldgOverAssessedValue)); $this->tpl->set_var("INTaxable_BldgOverMV", $this->checkNumericFormat($this->subINTaxableBldgOverMarketValue)); $this->tpl->set_var("INTaxable_BldgOverAV", $this->checkNumericFormat($this->subINTaxableBldgOverAssessedValue)); $this->tpl->set_var("MITaxable_BldgOverMV", $this->checkNumericFormat($this->subMITaxableBldgOverMarketValue)); $this->tpl->set_var("MITaxable_BldgOverAV", $this->checkNumericFormat($this->subMITaxableBldgOverAssessedValue)); $this->tpl->set_var("TITaxable_BldgOverMV", $this->checkNumericFormat($this->subTITaxableBldgOverMarketValue)); $this->tpl->set_var("TITaxable_BldgOverAV", $this->checkNumericFormat($this->subTITaxableBldgOverAssessedValue)); $this->tpl->set_var("SPTaxable_BldgOverMV", $this->checkNumericFormat($this->subSPTaxableBldgOverMarketValue)); $this->tpl->set_var("SPTaxable_BldgOverAV", $this->checkNumericFormat($this->subSPTaxableBldgOverAssessedValue)); $this->tpl->set_var("HOTaxable_BldgOverMV", $this->checkNumericFormat($this->subHOTaxableBldgOverMarketValue)); $this->tpl->set_var("HOTaxable_BldgOverAV", $this->checkNumericFormat($this->subHOTaxableBldgOverAssessedValue)); $this->tpl->set_var("SCTaxable_BldgOverMV", $this->checkNumericFormat($this->subSCTaxableBldgOverMarketValue)); $this->tpl->set_var("SCTaxable_BldgOverAV", $this->checkNumericFormat($this->subSCTaxableBldgOverAssessedValue)); $this->tpl->set_var("CUTaxable_BldgOverMV", $this->checkNumericFormat($this->subCUTaxableBldgOverMarketValue)); $this->tpl->set_var("CUTaxable_BldgOverAV", $this->checkNumericFormat($this->subCUTaxableBldgOverAssessedValue)); $this->tpl->set_var("OTTaxable_BldgOverMV", $this->checkNumericFormat($this->subOTTaxableBldgOverMarketValue)); $this->tpl->set_var("OTTaxable_BldgOverAV", $this->checkNumericFormat($this->subOTTaxableBldgOverAssessedValue)); $this->tpl->set_var("GOExempt_BldgOverMV", $this->checkNumericFormat($this->subGOExemptBldgOverMarketValue)); $this->tpl->set_var("GOExempt_BldgOverAV", $this->checkNumericFormat($this->subGOExemptBldgOverAssessedValue)); $this->tpl->set_var("RLExempt_BldgOverMV", $this->checkNumericFormat($this->subRLExemptBldgOverMarketValue)); $this->tpl->set_var("RLExempt_BldgOverAV", $this->checkNumericFormat($this->subRLExemptBldgOverAssessedValue)); $this->tpl->set_var("CHExempt_BldgOverMV", $this->checkNumericFormat($this->subCHExemptBldgOverMarketValue)); $this->tpl->set_var("CHExempt_BldgOverAV", $this->checkNumericFormat($this->subCHExemptBldgOverAssessedValue)); $this->tpl->set_var("EDExempt_BldgOverMV", $this->checkNumericFormat($this->subEDExemptBldgOverMarketValue)); $this->tpl->set_var("EDExempt_BldgOverAV", $this->checkNumericFormat($this->subEDExemptBldgOverAssessedValue)); $this->tpl->set_var("OTExempt_BldgOverMV", $this->checkNumericFormat($this->subOTExemptBldgOverMarketValue)); $this->tpl->set_var("OTExempt_BldgOverAV", $this->checkNumericFormat($this->subOTExemptBldgOverAssessedValue)); $this->tpl->set_var("RETaxable_MachMV", $this->checkNumericFormat($this->subRETaxableMachMarketValue)); $this->tpl->set_var("RETaxable_MachAV", $this->checkNumericFormat($this->subRETaxableMachAssessedValue)); $this->tpl->set_var("AGTaxable_MachMV", $this->checkNumericFormat($this->subAGTaxableMachMarketValue)); $this->tpl->set_var("AGTaxable_MachAV", $this->checkNumericFormat($this->subAGTaxableMachAssessedValue)); $this->tpl->set_var("COTaxable_MachMV", $this->checkNumericFormat($this->subCOTaxableMachMarketValue)); $this->tpl->set_var("COTaxable_MachAV", $this->checkNumericFormat($this->subCOTaxableMachAssessedValue)); $this->tpl->set_var("INTaxable_MachMV", $this->checkNumericFormat($this->subINTaxableMachMarketValue)); $this->tpl->set_var("INTaxable_MachAV", $this->checkNumericFormat($this->subINTaxableMachAssessedValue)); $this->tpl->set_var("MITaxable_MachMV", $this->checkNumericFormat($this->subMITaxableMachMarketValue)); $this->tpl->set_var("MITaxable_MachAV", $this->checkNumericFormat($this->subMITaxableMachAssessedValue)); $this->tpl->set_var("TITaxable_MachMV", $this->checkNumericFormat($this->subTITaxableMachMarketValue)); $this->tpl->set_var("TITaxable_MachAV", $this->checkNumericFormat($this->subTITaxableMachAssessedValue)); $this->tpl->set_var("SPTaxable_MachMV", $this->checkNumericFormat($this->subSPTaxableMachMarketValue)); $this->tpl->set_var("SPTaxable_MachAV", $this->checkNumericFormat($this->subSPTaxableMachAssessedValue)); $this->tpl->set_var("HOTaxable_MachMV", $this->checkNumericFormat($this->subHOTaxableMachMarketValue)); $this->tpl->set_var("HOTaxable_MachAV", $this->checkNumericFormat($this->subHOTaxableMachAssessedValue)); $this->tpl->set_var("SCTaxable_MachMV", $this->checkNumericFormat($this->subSCTaxableMachMarketValue)); $this->tpl->set_var("SCTaxable_MachAV", $this->checkNumericFormat($this->subSCTaxableMachAssessedValue)); $this->tpl->set_var("CUTaxable_MachMV", $this->checkNumericFormat($this->subCUTaxableMachMarketValue)); $this->tpl->set_var("CUTaxable_MachAV", $this->checkNumericFormat($this->subCUTaxableMachAssessedValue)); $this->tpl->set_var("OTTaxable_MachMV", $this->checkNumericFormat($this->subOTTaxableMachMarketValue)); $this->tpl->set_var("OTTaxable_MachAV", $this->checkNumericFormat($this->subOTTaxableMachAssessedValue)); $this->tpl->set_var("GOExempt_MachMV", $this->checkNumericFormat($this->subGOExemptMachMarketValue)); $this->tpl->set_var("GOExempt_MachAV", $this->checkNumericFormat($this->subGOExemptMachAssessedValue)); $this->tpl->set_var("RLExempt_MachMV", $this->checkNumericFormat($this->subRLExemptMachMarketValue)); $this->tpl->set_var("RLExempt_MachAV", $this->checkNumericFormat($this->subRLExemptMachAssessedValue)); $this->tpl->set_var("CHExempt_MachMV", $this->checkNumericFormat($this->subCHExemptMachMarketValue)); $this->tpl->set_var("CHExempt_MachAV", $this->checkNumericFormat($this->subCHExemptMachAssessedValue)); $this->tpl->set_var("EDExempt_MachMV", $this->checkNumericFormat($this->subEDExemptMachMarketValue)); $this->tpl->set_var("EDExempt_MachAV", $this->checkNumericFormat($this->subEDExemptMachAssessedValue)); $this->tpl->set_var("OTExempt_MachMV", $this->checkNumericFormat($this->subOTExemptMachMarketValue)); $this->tpl->set_var("OTExempt_MachAV", $this->checkNumericFormat($this->subOTExemptMachAssessedValue)); $this->tpl->set_var("RETaxable_OtherMV", $this->checkNumericFormat($this->subRETaxableOtherMarketValue)); $this->tpl->set_var("RETaxable_OtherAV", $this->checkNumericFormat($this->subRETaxableOtherAssessedValue)); $this->tpl->set_var("AGTaxable_OtherMV", $this->checkNumericFormat($this->subAGTaxableOtherMarketValue)); $this->tpl->set_var("AGTaxable_OtherAV", $this->checkNumericFormat($this->subAGTaxableOtherAssessedValue)); $this->tpl->set_var("COTaxable_OtherMV", $this->checkNumericFormat($this->subCOTaxableOtherMarketValue)); $this->tpl->set_var("COTaxable_OtherAV", $this->checkNumericFormat($this->subCOTaxableOtherAssessedValue)); $this->tpl->set_var("INTaxable_OtherMV", $this->checkNumericFormat($this->subINTaxableOtherMarketValue)); $this->tpl->set_var("INTaxable_OtherAV", $this->checkNumericFormat($this->subINTaxableOtherAssessedValue)); $this->tpl->set_var("MITaxable_OtherMV", $this->checkNumericFormat($this->subMITaxableOtherMarketValue)); $this->tpl->set_var("MITaxable_OtherAV", $this->checkNumericFormat($this->subMITaxableOtherAssessedValue)); $this->tpl->set_var("TITaxable_OtherMV", $this->checkNumericFormat($this->subTITaxableOtherMarketValue)); $this->tpl->set_var("TITaxable_OtherAV", $this->checkNumericFormat($this->subTITaxableOtherAssessedValue)); $this->tpl->set_var("SPTaxable_OtherMV", $this->checkNumericFormat($this->subSPTaxableOtherMarketValue)); $this->tpl->set_var("SPTaxable_OtherAV", $this->checkNumericFormat($this->subSPTaxableOtherAssessedValue)); $this->tpl->set_var("HOTaxable_OtherMV", $this->checkNumericFormat($this->subHOTaxableOtherMarketValue)); $this->tpl->set_var("HOTaxable_OtherAV", $this->checkNumericFormat($this->subHOTaxableOtherAssessedValue)); $this->tpl->set_var("SCTaxable_OtherMV", $this->checkNumericFormat($this->subSCTaxableOtherMarketValue)); $this->tpl->set_var("SCTaxable_OtherAV", $this->checkNumericFormat($this->subSCTaxableOtherAssessedValue)); $this->tpl->set_var("CUTaxable_OtherMV", $this->checkNumericFormat($this->subCUTaxableOtherMarketValue)); $this->tpl->set_var("CUTaxable_OtherAV", $this->checkNumericFormat($this->subCUTaxableOtherAssessedValue)); $this->tpl->set_var("OTTaxable_OtherMV", $this->checkNumericFormat($this->subOTTaxableOtherMarketValue)); $this->tpl->set_var("OTTaxable_OtherAV", $this->checkNumericFormat($this->subOTTaxableOtherAssessedValue)); $this->tpl->set_var("GOExempt_OtherMV", $this->checkNumericFormat($this->subGOExemptOtherMarketValue)); $this->tpl->set_var("GOExempt_OtherAV", $this->checkNumericFormat($this->subGOExemptOtherAssessedValue)); $this->tpl->set_var("RLExempt_OtherMV", $this->checkNumericFormat($this->subRLExemptOtherMarketValue)); $this->tpl->set_var("RLExempt_OtherAV", $this->checkNumericFormat($this->subRLExemptOtherAssessedValue)); $this->tpl->set_var("CHExempt_OtherMV", $this->checkNumericFormat($this->subCHExemptOtherMarketValue)); $this->tpl->set_var("CHExempt_OtherAV", $this->checkNumericFormat($this->subCHExemptOtherAssessedValue)); $this->tpl->set_var("EDExempt_OtherMV", $this->checkNumericFormat($this->subEDExemptOtherMarketValue)); $this->tpl->set_var("EDExempt_OtherAV", $this->checkNumericFormat($this->subEDExemptOtherAssessedValue)); $this->tpl->set_var("OTExempt_OtherMV", $this->checkNumericFormat($this->subOTExemptOtherMarketValue)); $this->tpl->set_var("OTExempt_OtherAV", $this->checkNumericFormat($this->subOTExemptOtherAssessedValue)); $this->tpl->set_var("RETaxable_TotalMV", $this->checkNumericFormat($this->totalRETaxableMarketValue)); $this->tpl->set_var("RETaxable_TotalAV", $this->checkNumericFormat($this->totalRETaxableAssessedValue)); $this->tpl->set_var("AGTaxable_TotalMV", $this->checkNumericFormat($this->totalAGTaxableMarketValue)); $this->tpl->set_var("AGTaxable_TotalAV", $this->checkNumericFormat($this->totalAGTaxableAssessedValue)); $this->tpl->set_var("COTaxable_TotalMV", $this->checkNumericFormat($this->totalCOTaxableMarketValue)); $this->tpl->set_var("COTaxable_TotalAV", $this->checkNumericFormat($this->totalCOTaxableAssessedValue)); $this->tpl->set_var("INTaxable_TotalMV", $this->checkNumericFormat($this->totalINTaxableMarketValue)); $this->tpl->set_var("INTaxable_TotalAV", $this->checkNumericFormat($this->totalINTaxableAssessedValue)); $this->tpl->set_var("MITaxable_TotalMV", $this->checkNumericFormat($this->totalMITaxableMarketValue)); $this->tpl->set_var("MITaxable_TotalAV", $this->checkNumericFormat($this->totalMITaxableAssessedValue)); $this->tpl->set_var("TITaxable_TotalMV", $this->checkNumericFormat($this->totalTITaxableMarketValue)); $this->tpl->set_var("TITaxable_TotalAV", $this->checkNumericFormat($this->totalTITaxableAssessedValue)); $this->tpl->set_var("SPTaxable_TotalMV", $this->checkNumericFormat($this->totalSPTaxableMarketValue)); $this->tpl->set_var("SPTaxable_TotalAV", $this->checkNumericFormat($this->totalSPTaxableAssessedValue)); $this->tpl->set_var("HOTaxable_TotalMV", $this->checkNumericFormat($this->totalHOTaxableMarketValue)); $this->tpl->set_var("HOTaxable_TotalAV", $this->checkNumericFormat($this->totalHOTaxableAssessedValue)); $this->tpl->set_var("SCTaxable_TotalMV", $this->checkNumericFormat($this->totalSCTaxableMarketValue)); $this->tpl->set_var("SCTaxable_TotalAV", $this->checkNumericFormat($this->totalSCTaxableAssessedValue)); $this->tpl->set_var("CUTaxable_TotalMV", $this->checkNumericFormat($this->totalCUTaxableMarketValue)); $this->tpl->set_var("CUTaxable_TotalAV", $this->checkNumericFormat($this->totalCUTaxableAssessedValue)); $this->tpl->set_var("OTTaxable_TotalMV", $this->checkNumericFormat($this->totalOTTaxableMarketValue)); $this->tpl->set_var("OTTaxable_TotalAV", $this->checkNumericFormat($this->totalOTTaxableAssessedValue)); $this->tpl->set_var("GOExempt_TotalMV", $this->checkNumericFormat($this->totalGOExemptMarketValue)); $this->tpl->set_var("GOExempt_TotalAV", $this->checkNumericFormat($this->totalGOExemptAssessedValue)); $this->tpl->set_var("RLExempt_TotalMV", $this->checkNumericFormat($this->totalRLExemptMarketValue)); $this->tpl->set_var("RLExempt_TotalAV", $this->checkNumericFormat($this->totalRLExemptAssessedValue)); $this->tpl->set_var("CHExempt_TotalMV", $this->checkNumericFormat($this->totalCHExemptMarketValue)); $this->tpl->set_var("CHExempt_TotalAV", $this->checkNumericFormat($this->totalCHExemptAssessedValue)); $this->tpl->set_var("EDExempt_TotalMV", $this->checkNumericFormat($this->totalEDExemptMarketValue)); $this->tpl->set_var("EDExempt_TotalAV", $this->checkNumericFormat($this->totalEDExemptAssessedValue)); $this->tpl->set_var("OTExempt_TotalMV", $this->checkNumericFormat($this->totalOTExemptMarketValue)); $this->tpl->set_var("OTExempt_TotalAV", $this->checkNumericFormat($this->totalOTExemptAssessedValue)); $this->tpl->set_var("Taxable_RealPropertyUnits", number_format($this->totalTaxableRealPropertyUnits)); $this->tpl->set_var("Taxable_LandArea", $this->checkNumericFormat($this->totalTaxableLandArea)); $this->tpl->set_var("Taxable_LandMV", $this->checkNumericFormat($this->totalTaxableLandMarketValue)); $this->tpl->set_var("Taxable_LandAV", $this->checkNumericFormat($this->totalTaxableLandAssessedValue)); $this->tpl->set_var("Taxable_BldgLessMV", $this->checkNumericFormat($this->totalTaxableBldgLessMarketValue)); $this->tpl->set_var("Taxable_BldgLessAV", $this->checkNumericFormat($this->totalTaxableBldgLessAssessedValue)); $this->tpl->set_var("Taxable_BldgOverMV", $this->checkNumericFormat($this->totalTaxableBldgOverMarketValue)); $this->tpl->set_var("Taxable_BldgOverAV", $this->checkNumericFormat($this->totalTaxableBldgOverAssessedValue)); $this->tpl->set_var("Taxable_MachMV", $this->checkNumericFormat($this->totalTaxableMachMarketValue)); $this->tpl->set_var("Taxable_MachAV", $this->checkNumericFormat($this->totalTaxableMachAssessedValue)); $this->tpl->set_var("Taxable_OtherMV", $this->checkNumericFormat($this->totalTaxableOtherMarketValue)); $this->tpl->set_var("Taxable_OtherAV", $this->checkNumericFormat($this->totalTaxableOtherAssessedValue)); $this->tpl->set_var("Taxable_TotalMV", $this->checkNumericFormat($this->totalTaxableMarketValue)); $this->tpl->set_var("Taxable_TotalAV", $this->checkNumericFormat($this->totalTaxableAssessedValue)); $this->tpl->set_var("Exempt_RealPropertyUnits", $this->checkNumericFormat($this->totalExemptRealPropertyUnits)); $this->tpl->set_var("Exempt_LandArea", $this->checkNumericFormat($this->totalExemptLandArea)); $this->tpl->set_var("Exempt_LandMV", $this->checkNumericFormat($this->totalExemptLandMarketValue)); $this->tpl->set_var("Exempt_LandAV", $this->checkNumericFormat($this->totalExemptLandAssessedValue)); $this->tpl->set_var("Exempt_BldgLessMV", $this->checkNumericFormat($this->totalExemptBldgLessMarketValue)); $this->tpl->set_var("Exempt_BldgLessAV", $this->checkNumericFormat($this->totalExemptBldgLessAssessedValue)); $this->tpl->set_var("Exempt_BldgOverMV", $this->checkNumericFormat($this->totalExemptBldgOverMarketValue)); $this->tpl->set_var("Exempt_BldgOverAV", $this->checkNumericFormat($this->totalExemptBldgOverAssessedValue)); $this->tpl->set_var("Exempt_MachMV", $this->checkNumericFormat($this->totalExemptMachMarketValue)); $this->tpl->set_var("Exempt_MachAV", $this->checkNumericFormat($this->totalExemptMachAssessedValue)); $this->tpl->set_var("Exempt_OtherMV", $this->checkNumericFormat($this->totalExemptOtherMarketValue)); $this->tpl->set_var("Exempt_OtherAV", $this->checkNumericFormat($this->totalExemptOtherAssessedValue)); $this->tpl->set_var("Exempt_TotalMV", $this->checkNumericFormat($this->totalExemptMarketValue)); $this->tpl->set_var("Exempt_TotalAV", $this->checkNumericFormat($this->totalExemptAssessedValue)); $this->tpl->set_var("TOTAL_RealPropertyUnits", number_format($this->totalRealPropertyUnits)); $this->tpl->set_var("TOTAL_LandArea", $this->checkNumericFormat($this->totalLandArea)); $this->tpl->set_var("TOTAL_LandMV", $this->checkNumericFormat($this->totalLandMarketValue)); $this->tpl->set_var("TOTAL_LandAV", $this->checkNumericFormat($this->totalLandAssessedValue)); $this->tpl->set_var("TOTAL_BldgLessMV", $this->checkNumericFormat($this->totalBldgLessMarketValue)); $this->tpl->set_var("TOTAL_BldgLessAV", $this->checkNumericFormat($this->totalBldgLessAssessedValue)); $this->tpl->set_var("TOTAL_BldgOverMV", $this->checkNumericFormat($this->totalBldgOverMarketValue)); $this->tpl->set_var("TOTAL_BldgOverAV", $this->checkNumericFormat($this->totalBldgOverAssessedValue)); $this->tpl->set_var("TOTAL_MachMV", $this->checkNumericFormat($this->totalMachMarketValue)); $this->tpl->set_var("TOTAL_MachAV", $this->checkNumericFormat($this->totalMachAssessedValue)); $this->tpl->set_var("TOTAL_OtherMV", $this->checkNumericFormat($this->totalOtherMarketValue)); $this->tpl->set_var("TOTAL_OtherAV", $this->checkNumericFormat($this->totalOtherAssessedValue)); $this->tpl->set_var("TOTAL_TotalMV", $this->checkNumericFormat($this->totalMarketValue)); $this->tpl->set_var("TOTAL_TotalAV", $this->checkNumericFormat($this->totalAssessedValue)); $treasurySettings = new TreasurySettings(); $treasurySettings->selectRecord(); $this->basicTaxRate = $treasurySettings->getPctRPTax() * 100; $this->sefTaxRate = $treasurySettings->getPctSEF() * 100; $this->rateOfLevy = $this->basicTaxRate + $this->sefTaxRate; $this->taxableBasicCollectibles = 0; $this->taxableSEFCollectibles = 0; $this->totalBasicCollectibles = 0; $this->totalSEFCollectibles = 0; $this->reTaxableBasicCollectibles = $this->totalRETaxableAssessedValue * ($this->basicTaxRate / 100); $this->reTaxableSEFCollectibles = $this->totalRETaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->reTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->reTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->reTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->reTaxableSEFCollectibles; $this->tpl->set_var("RETaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("RETaxable_BasicCollectibles", $this->checkNumericFormat($this->reTaxableBasicCollectibles)); $this->tpl->set_var("RETaxable_SEFCollectibles", $this->checkNumericFormat($this->reTaxableSEFCollectibles)); $this->agTaxableBasicCollectibles = $this->totalAGTaxableAssessedValue * ($this->basicTaxRate / 100); $this->agTaxableSEFCollectibles = $this->totalAGTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->agTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->agTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->agTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->agTaxableSEFCollectibles; $this->tpl->set_var("AGTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("AGTaxable_BasicCollectibles", $this->checkNumericFormat($this->agTaxableBasicCollectibles)); $this->tpl->set_var("AGTaxable_SEFCollectibles", $this->checkNumericFormat($this->agTaxableSEFCollectibles)); $this->coTaxableBasicCollectibles = $this->totalCOTaxableAssessedValue * ($this->basicTaxRate / 100); $this->coTaxableSEFCollectibles = $this->totalCOTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->coTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->coTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->coTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->coTaxableSEFCollectibles; $this->tpl->set_var("COTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("COTaxable_BasicCollectibles", $this->checkNumericFormat($this->coTaxableBasicCollectibles)); $this->tpl->set_var("COTaxable_SEFCollectibles", $this->checkNumericFormat($this->coTaxableSEFCollectibles)); $this->inTaxableBasicCollectibles = $this->totalINTaxableAssessedValue * ($this->basicTaxRate / 100); $this->inTaxableSEFCollectibles = $this->totalINTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->inTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->inTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->inTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->inTaxableSEFCollectibles; $this->tpl->set_var("INTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("INTaxable_BasicCollectibles", $this->checkNumericFormat($this->inTaxableBasicCollectibles)); $this->tpl->set_var("INTaxable_SEFCollectibles", $this->checkNumericFormat($this->inTaxableSEFCollectibles)); $this->miTaxableBasicCollectibles = $this->totalMITaxableAssessedValue * ($this->basicTaxRate / 100); $this->miTaxableSEFCollectibles = $this->totalMITaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->miTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->miTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->miTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->miTaxableSEFCollectibles; $this->tpl->set_var("MITaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("MITaxable_BasicCollectibles", $this->checkNumericFormat($this->miTaxableBasicCollectibles)); $this->tpl->set_var("MITaxable_SEFCollectibles", $this->checkNumericFormat($this->miTaxableSEFCollectibles)); $this->tiTaxableBasicCollectibles = $this->totalTITaxableAssessedValue * ($this->basicTaxRate / 100); $this->tiTaxableSEFCollectibles = $this->totalTITaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->tiTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->tiTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->tiTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->tiTaxableSEFCollectibles; $this->tpl->set_var("TITaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("TITaxable_BasicCollectibles", $this->checkNumericFormat($this->tiTaxableBasicCollectibles)); $this->tpl->set_var("TITaxable_SEFCollectibles", $this->checkNumericFormat($this->tiTaxableSEFCollectibles)); $this->spTaxableBasicCollectibles = $this->totalSPTaxableAssessedValue * ($this->basicTaxRate / 100); $this->spTaxableSEFCollectibles = $this->totalSPTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->spTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->spTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->spTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->spTaxableSEFCollectibles; $this->tpl->set_var("SPTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("SPTaxable_BasicCollectibles", $this->checkNumericFormat($this->spTaxableBasicCollectibles)); $this->tpl->set_var("SPTaxable_SEFCollectibles", $this->checkNumericFormat($this->spTaxableSEFCollectibles)); $this->hoTaxableBasicCollectibles = $this->totalHOTaxableAssessedValue * ($this->basicTaxRate / 100); $this->hoTaxableSEFCollectibles = $this->totalHOTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->hoTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->hoTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->hoTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->hoTaxableSEFCollectibles; $this->tpl->set_var("HOTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("HOTaxable_BasicCollectibles", $this->checkNumericFormat($this->hoTaxableBasicCollectibles)); $this->tpl->set_var("HOTaxable_SEFCollectibles", $this->checkNumericFormat($this->hoTaxableSEFCollectibles)); $this->scTaxableBasicCollectibles = $this->totalSCTaxableAssessedValue * ($this->basicTaxRate / 100); $this->scTaxableSEFCollectibles = $this->totalSCTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->scTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->scTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->scTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->scTaxableSEFCollectibles; $this->tpl->set_var("SCTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("SCTaxable_BasicCollectibles", $this->checkNumericFormat($this->scTaxableBasicCollectibles)); $this->tpl->set_var("SCTaxable_SEFCollectibles", $this->checkNumericFormat($this->scTaxableSEFCollectibles)); $this->cuTaxableBasicCollectibles = $this->totalCUTaxableAssessedValue * ($this->basicTaxRate / 100); $this->cuTaxableSEFCollectibles = $this->totalCUTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->cuTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->cuTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->cuTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->cuTaxableSEFCollectibles; $this->tpl->set_var("CUTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("CUTaxable_BasicCollectibles", $this->checkNumericFormat($this->cuTaxableBasicCollectibles)); $this->tpl->set_var("CUTaxable_SEFCollectibles", $this->checkNumericFormat($this->cuTaxableSEFCollectibles)); $this->otTaxableBasicCollectibles = $this->totalOTTaxableAssessedValue * ($this->basicTaxRate / 100); $this->otTaxableSEFCollectibles = $this->totalOTTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->otTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->otTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->otTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->otTaxableSEFCollectibles; $this->tpl->set_var("OTTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("OTTaxable_BasicCollectibles", $this->checkNumericFormat($this->otTaxableBasicCollectibles)); $this->tpl->set_var("OTTaxable_SEFCollectibles", $this->checkNumericFormat($this->otTaxableSEFCollectibles)); $this->taTaxableBasicCollectibles = $this->totalTaTaxableAssessedValue * ($this->basicTaxRate / 100); $this->taTaxableSEFCollectibles = $this->totalTaTaxableAssessedValue * ($this->sefTaxRate / 100); $this->taxableBasicCollectibles += $this->taTaxableBasicCollectibles; $this->taxableSEFCollectibles += $this->taTaxableSEFCollectibles; $this->totalBasicCollectibles += $this->taTaxableBasicCollectibles; $this->totalSEFCollectibles += $this->taTaxableSEFCollectibles; $this->tpl->set_var("TaTaxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("TaTaxable_BasicCollectibles", $this->checkNumericFormat($this->taTaxableBasicCollectibles)); $this->tpl->set_var("TaTaxable_SEFCollectibles", $this->checkNumericFormat($this->taTaxableSEFCollectibles)); $this->tpl->set_var("Taxable_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("Taxable_BasicCollectibles", $this->checkNumericFormat($this->taxableBasicCollectibles)); $this->tpl->set_var("Taxable_SEFCollectibles", $this->checkNumericFormat($this->taxableSEFCollectibles)); $this->tpl->set_var("TOTAL_RateOfLevy", $this->rateOfLevy . "%"); $this->tpl->set_var("TOTAL_BasicCollectibles", $this->checkNumericFormat($this->totalBasicCollectibles)); $this->tpl->set_var("TOTAL_SEFCollectibles", $this->checkNumericFormat($this->totalSEFCollectibles)); $this->setPageDetailPerms(); $this->tpl->set_var("dbs", $this->dbs); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); if ($this->reportType == "HTML") { $this->tpl->p("templatePage"); } else { $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } } }
function Main() { $this->displayPageHeading(); if ($this->paymentRecords = $this->getFilteredPaymentRecords()) { // (modifed Dec. 08 but released on February 16, 2005) // ff two lines commented out: December 08, 2004 in favor of getFilteredPaymentRecords for faster processing. // if($this->paymentRecords = $this->filterPaymentsByCurrentQuarter()){ // if($this->paymentRecords = $this->filterPaymentsByLocationAndAssignPropertyClassification()){ if (is_array($this->paymentRecords->getArrayList())) { $list = $this->paymentRecords->getArrayList(); foreach ($list as $payment) { switch ($payment->getPropertyClassification()) { case "RE": $suffixKey = 1; $this->incrementValues($suffixKey, $payment); break; case "AG": $suffixKey = 2; $this->incrementValues($suffixKey, $payment); break; case "CO": $suffixKey = 3; $this->incrementValues($suffixKey, $payment); break; case "IN": $suffixKey = 4; $this->incrementValues($suffixKey, $payment); break; case "MI": $suffixKey = 5; $this->incrementValues($suffixKey, $payment); break; case "TI": $suffixKey = 6; $this->incrementValues($suffixKey, $payment); break; case "SP": $suffixKey = 7; $this->incrementValues($suffixKey, $payment); break; case "HO": $suffixKey = 8; $this->incrementValues($suffixKey, $payment); break; case "SC": $suffixKey = 9; $this->incrementValues($suffixKey, $payment); break; case "CU": $suffixKey = 10; $this->incrementValues($suffixKey, $payment); break; case "CH": case "ED": case "GO": case "OTX": case "OTE": case "RL": default: $suffixKey = 11; $this->incrementValues($suffixKey, $payment); break; } } } // } } $this->computeTotals(); $this->formatCurrencyFigures(); $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); //exit; $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } }
function Main() { $RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object"); $this->tpl->set_block("rptsTemplate", "Page", "PageBlock"); // start batch loop $rptopIDArray = $this->formArray["rptopIDArray"]; foreach ($rptopIDArray as $key => $rptopID) { $this->formArray["rptopID"] = $rptopID; $this->pageNumber++; if (!($xmlStr = $RPTOPDetails->getRPTOP($this->formArray["rptopID"]))) { exit("xml failed"); } else { //echo($xmlStr); if (!($domDoc = domxml_open_mem($xmlStr))) { exit("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) { // xml failed } else { if (!($domDoc = domxml_open_mem($xmlStr))) { // error domdoc } else { $this->displayOwnerList($domDoc); } } } break; case "cityAssessor": if (is_numeric($value)) { $cityAssessor = new Person(); $cityAssessor->selectRecord($value); $this->formArray["municipalAssessor"] = $cityAssessor->getName(); } else { $cityAssessor = $value; $this->formArray["municipalAssessor"] = $cityAssessor; } break; case "cityTreasurer": if (is_numeric($value)) { $cityTreasurer = new Person(); $cityTreasurer->selectRecord($value); $this->formArray["municipalTreasurer"] = $cityTreasurer->getName(); } else { $cityTreasurer = $value; $this->formArray["municipalTreasurer"] = $cityTreasurer; } break; case "tdArray": $tdCtr = 1; $tdPageNumber = 1; // RC 20091012 Modified to handle multiple page RPTOPS $totalBasic = 0; $totalSef = 0; $totalTaxes = 0; if (count($value)) { $tdTotalPages = intval((count($value) - 1) / 6) + 1; //RC 20091012 Calculate 1 to 6 = 1. foreach ($value as $tkey => $tvalue) { if ($tdCtr > 6) { // RC 20091012 Deal with multiple page RPTOP (i.e. more than 6 TDs) $this->formArray["tdPageNumber"] = $tdPageNumber; $this->formArray["tdTotalPages"] = $tdTotalPages; $this->formArray["totalOnLastPage"] = "Please Refer to Totals on Last Page..."; $this->setForm(); // generate page of output $this->clearDetails(); // clear the values from Form $this->pageNumber++; //increment PDF Page Number $tdPageNumber++; $tdCtr = 1; //reset count for lines on new page of RPTOP $this->formArray["totalOnLastPage"] = ""; } $this->formArray["arpNumber" . $tdCtr] = $tvalue->getTaxDeclarationNumber(); // word wrap arpNumber if (strlen($this->formArray["arpNumber" . $tdCtr]) > 13) { $this->formArray["arpNumber" . $tdCtr . "a"] = substr($this->formArray["arpNumber" . $tdCtr], 0, 12); $this->formArray["arpNumber" . $tdCtr . "b"] = substr($this->formArray["arpNumber" . $tdCtr], 12); $this->formArray["arpNumber" . $tdCtr] = ""; } $this->formArray["afsID"] = $tvalue->getAfsID(); $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($tvalue->getAfsID()))) { // xml failed } else { if (!($domDoc = domxml_open_mem($xmlStr))) { // error domDoc } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->formArray["odID"] = $afs->getOdID(); $od = new OD(); $od->selectRecord($this->formArray["odID"]); $locationNumber = $od->locationAddress->getNumber(); $locationStreet = $od->locationAddress->getStreet(); $locationBarangay = $od->locationAddress->getBarangay(); $locationDistrict = $od->locationAddress->getDistrict(); $locationMunicipalityCity = $od->locationAddress->getMunicipalityCity(); $locationProvince = $od->locationAddress->getProvince(); $this->formArray["location" . $tdCtr] = $locationNumber . " " . $locationStreet . " " . $locationBarangay; // word wrap location if (strlen($this->formArray["location" . $tdCtr]) > 26) { $this->formArray["location" . $tdCtr . "a"] = $locationNumber . " " . $locationStreet; $this->formArray["location" . $tdCtr . "b"] = $locationBarangay; $this->formArray["location" . $tdCtr] = ""; } $this->formArray["province"] = $locationProvince; $this->formArray["municipalityCity"] = strtoupper($locationMunicipalityCity); $this->formArray["area" . $tdCtr] = $od->getLandArea(); $this->formArray["lotNo" . $tdCtr] = $od->getLotNumber(); $this->formArray["pin" . $tdCtr] = $afs->getPropertyIndexNumber(); // word wrap pin if (strlen($this->formArray["pin" . $tdCtr]) > 25) { $this->formArray["pin" . $tdCtr . "a"] = substr($this->formArray["pin" . $tdCtr], 0, 25); $this->formArray["pin" . $tdCtr . "b"] = substr($this->formArray["pin" . $tdCtr], 25); $this->formArray["pin" . $tdCtr] = ""; } $landList = $afs->getLandArray(); $plantsTreesList = $afs->getPlantsTreesArray(); $improvementsBuildingsList = $afs->getImprovementsBuildingsArray(); $machineriesList = $afs->getMachineriesArray(); $kind = ""; $actualUse = ""; if (count($landList)) { $kind = "Land"; $land = $landList[0]; $actualUse = $land->getActualUse(); $landActualUses = new LandActualUses(); $landActualUses->selectRecord($actualUse); $actualUse = $landActualUses->getDescription(); $actualUseReportCode = $landActualUses->getReportCode(); } else { if (count($plantsTreesList)) { $kind = "Land"; $plantsTrees = $plantsTreesList[0]; $actualUse = $plantsTrees->getActualUse(); $plantsTreesActualUses = new PlantsTreesActualUses(); $plantsTreesActualUses->selectRecord($actualUse); $actualUse = $plantsTreesActualUses->getDescription(); $actualUseReportCode = $plantsTreesActualUses->getReportCode(); } else { if (count($improvementsBuildingsList)) { $kind = "Improvements/Buildings"; $improvementsBuildings = $improvementsBuildingsList[0]; $actualUse = $improvementsBuildings->getActualUse(); $improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses(); $improvementsBuildingsActualUses->selectRecord($actualUse); $actualUse = $improvementsBuildingsActualUses->getDescription(); $actualUseReportCode = $improvementsBuildingsActualUses->getReportCode(); } else { if (count($machineriesList)) { $kind = "Machineries"; $machineries = $machineriesList[0]; $actualUse = $machineries->getActualUse(); $machineriesActualUses = new MachineriesActualUses(); $machineriesActualUses->selectRecord($actualUse); $actualUse = $machineriesActualUses->getDescription(); $actualUseReportCode = $machineriesActualUses->getReportCode(); } } } } eval(REPORT_CODE_LIST); foreach ($reportCodeList as $key => $reportCode) { if ($reportCode["code"] == $actualUseReportCode) { $reportCodeDescription = $reportCode["description"]; break; } } $this->formArray["classification" . $tdCtr] = $reportCodeDescription; $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["marketValue" . $tdCtr] += $afs->getTotalMarketValue(); $this->formArray["assessedValue" . $tdCtr] += $afs->getTotalAssessedValue(); //RC $this->formArray["totalMarketValue"] += $this->formArray["marketValue"]; //RC $this->formArray["totalAssessedValue"] += $this->formArray["assessedValue"]; // grab Due from tdID $this->formArray["totalTaxDue"] = 0.0; $DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object"); if (!($xmlStr = $DueDetails->getDueFromTdID($tvalue->getTdID()))) { $this->formArray["basic" . $tdCtr] = ""; $this->formArray["sef" . $tdCtr] = ""; $this->formArray["totalTax" . $tdCtr] = ""; $this->formArray["totalBasic"] += 0; $this->formArray["totalSef"] += 0; $this->formArray["totalTaxes"] += 0; } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->formArray["basic" . $tdCtr] = ""; $this->formArray["sef" . $tdCtr] = ""; $this->formArray["totalTax" . $tdCtr] = ""; $this->formArray["totalBasic"] += 0; $this->formArray["totalSef"] += 0; $this->formArray["totalTaxes"] += 0; } else { $due = new Due(); $due->parseDomDocument($domDoc); $this->formArray["basic" . $tdCtr] = $due->getBasicTax(); $this->formArray["sef" . $tdCtr] = $due->getSEFTax(); $this->formArray["totalTax" . $tdCtr] = $due->getTaxDue(); /* RC 20091012 revised to not print total until last page of RPTOP $this->formArray["totalBasic"] += $due->getBasicTax(); $this->formArray["totalSef"] += $due->getSEFTax(); $this->formArray["totalTaxes"] += $due->getTaxDue(); */ $totalBasic += $due->getBasicTax(); $totalSef += $due->getSEFTax(); $totalTaxes += $due->getTaxDue(); } } } } $tdCtr++; } } break; default: $this->formArray[$key] = $value; } } $this->formArray["tdPageNumber"] = $tdPageNumber; $this->formArray["tdTotalPages"] = $tdTotalPages; $this->formArray["totalBasic"] += $totalBasic; // RC 20091012 set values for last page of RPTOP $this->formArray["totalSef"] += $totalSef; $this->formArray["totalTaxes"] += $totalTaxes; $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); } } $this->setForm(); // send XML to file $this->clearForm(); // clear the XML form values } // end batch loop $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); $testpdf->writePDF("RPTOPBatch.pdf"); // popup the IE Save to File thingee... exit; }
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() { $eRPTSSettings = new eRPTSSettings(); if ($eRPTSSettings->selectRecord(1)) { $this->tpl->set_var("lguType", strtoupper($eRPTSSettings->getLguType())); $this->tpl->set_var("lguName", strtoupper($eRPTSSettings->getLguName())); } $dbTD = new DB_RPTS(); $dbBacktaxTD = new DB_RPTS(); $dbPaymentBacktaxTD = new DB_RPTS(); $dbPaymentTD = new DB_RPTS(); $dbCollectionBacktaxTD = new DB_RPTS(); $dbCollectionTD = new DB_RPTS(); $dbDue = new DB_RPTS(); // gather TD's $sql = "SELECT Due.dueID as dueID, " . "Due.tdID as tdID, " . "Due.dueType as dueType, " . "Due.dueDate as dueDate, " . "Due.basicTax as basicTax, " . "Due.basicTaxRate as basicTaxRate, " . "Due.sefTax as sefTax, " . "Due.sefTaxRate as sefTaxRate, " . "Due.idleTax as idleTax, " . "Due.idleTaxRate as idleTaxRate, " . "TD.afsID as afsID, " . "TD.propertyType as propertyType, " . "TD.taxDeclarationNumber as taxDeclarationNumber, " . "AFS.odID as odID, " . "AFS.arpNumber as arpNumber, " . "AFS.propertyIndexNumber as propertyIndexNumber, " . "AFS.taxability as taxability, " . "AFS.effectivity as effectivity, " . "AFS.totalMarketValue as totalMarketValue, " . "AFS.totalAssessedValue as totalAssessedValue " . "FROM Due, TD, AFS " . "WHERE Due.tdID = TD.tdID " . "AND TD.afsID = AFS.afsID " . "AND AFS.archive != 'true' " . "AND TD.archive != 'true' " . "AND Due.dueType = 'Annual' " . "AND TD.propertyType LIKE '" . $this->formArray["classification"] . "' " . "GROUP BY Due.tdID, YEAR(Due.dueDate) " . "ORDER BY Due.dueDate DESC"; $dbTD->query($sql); if ($dbTD->nf() > 0) { // gather BacktaxTD's while ($dbTD->next_record()) { $sqlBacktaxTD = "SELECT backtaxTDID, " . "tdID, " . "tdNumber, " . "startYear, " . "endYear, " . "startQuarter, " . "assessedValue, " . "basicRate, " . "sefRate, " . "basicTax, " . "sefTax, " . "idleTax, " . "penalties, " . "paid, " . "balance, " . "total " . "FROM BacktaxTD " . "WHERE tdID='" . $dbTD->f("tdID") . "' " . "ORDER BY startYear ASC "; $dbBacktaxTD->query($sqlBacktaxTD); if ($dbBacktaxTD->nf() > 0) { while ($dbBacktaxTD->next_record()) { $backtaxTDRecordArray[] = $dbBacktaxTD->Record; } } $tdRecordArray[] = array("td" => $dbTD->Record, "backtaxTD" => $backtaxTDRecordArray); unset($backtaxTDRecordArray); } } if (is_array($tdRecordArray)) { foreach ($tdRecordArray as $recordArray) { // gather backtaxTD details if (is_array($recordArray["backtaxTD"])) { foreach ($recordArray["backtaxTD"] as $backtaxTDRecord) { $paidBasic = 0; $paidSEF = 0; $paidPenalty = 0; $totalTaxCollected = 0; $basic = 0; $sef = 0; $penalty = 0; $totalCollectible = 0; // get totalTaxCollected $sqlPaymentBacktaxTD = "SELECT paymentID, " . "dueType, " . "backtaxTDID, " . "taxDue, " . "earlyPaymentDiscount, " . "advancedPaymentDiscount, " . "penalty, " . "amnesty, " . "balanceDue, " . "amountPaid, " . "dueDate, " . "paymentDate " . "FROM Payment " . "WHERE backtaxTDID='" . $backtaxTDRecord["backtaxTDID"] . "' " . "AND status!='cancelled'"; $dbPaymentBacktaxTD->query($sqlPaymentBacktaxTD); if ($dbPaymentBacktaxTD->nf() > 0) { while ($dbPaymentBacktaxTD->next_record()) { $sqlCollectionBacktaxTD = "SELECT * " . "FROM Collection " . "WHERE paymentID='" . $dbPaymentBacktaxTD->f("paymentID") . "' " . "AND status!='cancelled' "; $dbCollectionBacktaxTD->query($sqlCollectionBacktaxTD); if ($dbCollectionBacktaxTD->nf() > 0) { while ($dbCollectionBacktaxTD->next_record()) { switch ($dbCollectionBacktaxTD->f("taxType")) { case "basic": if ($dbCollectionBacktaxTD->f("amnesty") != "true") { $paidBasic += $dbCollectionBacktaxTD->f("amountPaid") - $dbCollectionBacktaxTD->f("penalty"); $paidPenalty += $dbCollectionBacktaxTD->f("penalty"); $totalTaxCollected += $dbCollectionBacktaxTD->f("amountPaid"); } else { $paidBasic += $dbCollectionBacktaxTD->f("amountPaid"); $totalTaxCollected += $paidBasic; } break; case "sef": if ($dbCollectionBacktaxTD->f("amnesty") != "true") { $paidSEF += $dbCollectionBacktaxTD->f("amountPaid") - $dbCollectionBacktaxTD->f("penalty"); $paidPenalty += $dbCollectionBacktaxTD->f("penalty"); $totalTaxCollected += $dbCollectionBacktaxTD->f("amountPaid"); } else { $paidSEF += $dbCollectionBacktaxTD->f("amountPaid"); $totalTaxCollected += $paidSEF; } break; } } } } } // get totalCollectible $basic = $backtaxTDRecord["basicTax"]; $sef = $backtaxTDRecord["sefTax"]; $backtaxTD = new BacktaxTD(); $backtaxTD->selectRecord("", $backtaxTDRecord["backtaxTDID"], ""); $backtaxTD->calculatePenalty(date("Y-m-d")); $penalty = $backtaxTD->getPenalties(); $totalCollectible = $basic + $sef + $penalty; $lineRecordArray[] = array("propertyIndexNumber" => "TD#:" . $backtaxTDRecord["tdNumber"] . " (" . $backtaxTDRecord["startYear"] . ")", "tdNumber" => $backtaxTDRecord["tdNumber"], "paidBasic" => $paidBasic, "paidSEF" => $paidSEF, "paidPenalty" => $paidPenalty, "totalTaxCollected" => $totalTaxCollected, "basic" => $basic, "sef" => $sef, "penalty" => $penalty, "totalCollectible" => $totalCollectible); } } $paidBasic = 0; $paidSEF = 0; $paidPenalty = 0; $totalTaxCollected = 0; $basic = 0; $sef = 0; $penalty = 0; $totalCollectible = 0; // gather TD details if (is_array($recordArray["td"])) { $tdRecord = $recordArray["td"]; // get totalTaxCollected $sqlPaymentTD = "SELECT paymentID, " . "dueType, " . "backtaxTDID, " . "taxDue, " . "earlyPaymentDiscount, " . "advancedPaymentDiscount, " . "penalty, " . "amnesty, " . "balanceDue, " . "amountPaid, " . "dueDate, " . "paymentDate " . "FROM Payment " . "WHERE tdID='" . $tdRecord["tdID"] . "' " . "AND status!='cancelled'"; $dbPaymentTD->query($sqlPaymentTD); if ($dbPaymentTD->nf() > 0) { while ($dbPaymentTD->next_record()) { $sqlCollectionTD = "SELECT * " . "FROM Collection " . "WHERE paymentID='" . $dbPaymentTD->f("paymentID") . "' " . "AND status!='cancelled' "; $dbCollectionTD->query($sqlCollectionTD); if ($dbCollectionTD->nf() > 0) { while ($dbCollectionTD->next_record()) { switch ($dbCollectionTD->f("taxType")) { case "basic": if ($dbCollectionTD->f("amnesty") != "true") { $paidBasic += $dbCollectionTD->f("amountPaid") - $dbCollectionTD->f("penalty"); $paidPenalty += $dbCollectionTD->f("penalty"); $totalTaxCollected += $dbCollectionTD->f("amountPaid"); } else { $paidBasic += $dbCollectionTD->f("amountPaid"); $totalTaxCollected += $paidBasic; } break; case "sef": if ($dbCollectionTD->f("amnesty") != "true") { $paidSEF += $dbCollectionTD->f("amountPaid") - $dbCollectionTD->f("penalty"); $paidPenalty += $dbCollectionTD->f("penalty"); $totalTaxCollected += $dbCollectionTD->f("amountPaid"); } else { $paidSEF += $dbCollectionTD->f("amountPaid"); $totalTaxCollected += $paidSEF; } break; } } } } } // get totalCollectible $due = new Due(); if ($due->selectRecord($tdRecord["dueID"])) { $basic = $due->getBasicTax(); $sef = $due->getSefTax(); $due = $this->computePenalty(date("Y-m-d"), $due); $penalty = $due->getPenalty(); $totalCollectible = $basic + $sef + $penalty; } $lineRecordArray[] = array("propertyIndexNumber" => $tdRecord["propertyIndexNumber"], "tdNumber" => $tdRecord["taxDeclarationNumber"], "paidBasic" => $paidBasic, "paidSEF" => $paidSEF, "paidPenalty" => $paidPenalty, "totalTaxCollected" => $totalTaxCollected, "basic" => $basic, "sef" => $sef, "penalty" => $penalty, "totalCollectible" => $totalCollectible); } } } // print page if (is_array($lineRecordArray)) { $ypos = 400; $decrementYposBy = 12; $linesPerPage = 20; $count = count($lineRecordArray); $numOfPages = ceil($count / $linesPerPage); $pageCtr = 1; $lineCtr = 1; $recordCtr = 1; $this->tpl->set_var("classification", $this->formArray["classification"]); $this->tpl->set_var("numOfPages", $numOfPages); $this->tpl->set_block("rptsTemplate", "Page", "PageBlock"); $this->tpl->set_block("Page", "Row", "RowBlock"); $this->tpl->set_block("Page", "Totals", "TotalsBlock"); $totalsArray = array("totalPaidBasic" => 0, "totalPaidSEF" => 0, "totalPaidPenalty" => 0, "totalTotalTaxCollected" => 0, "totalBasic" => 0, "totalSef" => 0, "totalPenalty" => 0, "totalTotalCollectible" => 0); foreach ($lineRecordArray as $recordArray) { $this->tpl->set_var("ypos", $ypos); $this->tpl->set_var("recordCtr", $recordCtr); // tally totals $totalsArray["totalPaidBasic"] += un_number_format($recordArray["paidBasic"]); $totalsArray["totalPaidSEF"] += un_number_format($recordArray["paidSEF"]); $totalsArray["totalPaidPenalty"] += un_number_format($recordArray["paidPenalty"]); $totalsArray["totalTotalTaxCollected"] += un_number_format($recordArray["totalTaxCollected"]); $totalsArray["totalBasic"] += un_number_format($recordArray["basic"]); $totalsArray["totalSef"] += un_number_format($recordArray["sef"]); $totalsArray["totalPenalty"] += un_number_format($recordArray["penalty"]); $totalsArray["totalTotalCollectible"] += un_number_format($recordArray["totalCollectible"]); // write values foreach ($recordArray as $key => $value) { switch ($key) { case "paidBasic": case "paidSEF": case "paidPenalty": case "totalTaxCollected": case "basic": case "sef": case "penalty": case "totalCollectible": $value = formatCurrency($value); break; } $this->tpl->set_var($key, $value); } $this->tpl->parse("RowBlock", "Row", true); if ($recordCtr == count($lineRecordArray) || $lineCtr == $linesPerPage) { if ($pageCtr == $numOfPages) { foreach ($totalsArray as $key => $value) { $value = formatCurrency($value); $this->tpl->set_var($key, $value); } $this->tpl->parse("TotalsBlock", "Totals", true); } else { $this->tpl->set_var("TotalsBlock", ""); } $this->tpl->set_var("page", $pageCtr); $this->tpl->parse("PageBlock", "Page", true); $this->tpl->set_var("RowBlock", ""); $this->tpl->set_var("TotalsBlock", ""); $ypos = 400; $lineCtr = 0; $pageCtr++; } $lineCtr++; $recordCtr++; $ypos = $ypos - $decrementYposBy; } $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); } } else { exit("no records to display"); } }
function showReceipt($preprinted) { if ($preprinted) { $this->tpl->set_file(array('step3' => 'PayRPTOP3.htm', 'receipt' => 'pprptreceipt.xml')); } else { $this->tpl->set_file(array('step3' => 'PayRPTOP3.htm', 'receipt' => 'rptreceipt.xml')); } # get all the details from the page if (isset($_POST['tdID'])) { $this->setDetails(); } $this->tpl->set_var('ownerAddress', strip_tags($this->tpl->get("ownerAddress"))); $this->tpl->parse('OUT', 'receipt'); $this->tpl->finish('OUT'); $rptrpdf = new PDFWriter(); $rptrpdf->setOutputXML($this->tpl->get("OUT"), "string"); $rptrpdf->writePDF("rptr.pdf"); // echo to browser // $tpl->p('OUT'); }
function Main() { $this->getSignatory(); if (is_array($this->formArray["personCompanyIDArray"])) { $this->tpl->set_block("rptsTemplate", "Page", "PageBlock"); foreach ($this->formArray["personCompanyIDArray"] as $personCompanyID) { $this->tpl->set_var("pageNumber", $this->pageNumber); switch ($this->formArray["ownerType"]) { case "Company": $company = new Company(); $company->selectRecord($personCompanyID); $nameList = $company->getCompanyName(); break; case "Person": default: $person = new Person(); $person->selectRecord($personCompanyID); $nameList = $person->getName(); break; } $this->tpl->set_var("nameList", $nameList); $tdNumberList = ""; $tdArray = $this->getTDArrayFromOwner($personCompanyID); if (is_array($tdArray)) { foreach ($tdArray as $td) { if ($tdNumberList != "") { $tdNumberList .= "\n"; } $tdNumberList .= $this->getTDNumberListLine($td); } } $this->tpl->set_var("tdNumberList", $tdNumberList); $this->tpl->parse("PageBlock", "Page", true); $this->pageNumber++; } } else { exit("no owners selected"); } $this->setLguDetails(); $this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $testpdf = new PDFWriter(); $testpdf->setOutputXML($this->tpl->get("templatePage"), "test"); if (isset($this->formArray["print"])) { $testpdf->writePDF($name); //,$this->formArray["print"]); } else { $testpdf->writePDF($name); } }