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 Main() { switch ($this->formArray["formAction"]) { case "remove": //echo "removeOwnerRPTOP(".$this->formArray["rptopID"].",".$this->formArray["ownerID"].",".$this->formArray["personID"].",".$this->formArray["companyID"].")"; $OwnerList = new SoapObject(NCCBIZ . "OwnerList.php", "urn:Object"); if (count($this->formArray["personID"]) || count($this->formArray["companyID"])) { if (!($deletedRows = $OwnerList->removeOwnerRPTOP($this->formArray["rptopID"], $this->formArray["ownerID"], $this->formArray["personID"], $this->formArray["companyID"]))) { $this->tpl->set_var("msg", "SOAP failed"); //echo "SOAP failed"; } else { $this->tpl->set_var("msg", $deletedRows . " records deleted"); } } else { $this->tpl->set_var("msg", "0 records deleted"); } header("location: RPTOPDetails.php" . $this->sess->url("") . $this->sess->add_query(array("rptopID" => $this->formArray["rptopID"]))); exit; break; default: $this->tpl->set_var("msg", ""); } //select $RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object"); if (!($xmlStr = $RPTOPDetails->getRPTOP($this->formArray["rptopID"]))) { exit("xml failed"); } else { //echo($xmlStr); if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); $this->tpl->set_var("OwnerListTableBlock", "error xmlDoc"); } else { $rptop = new RPTOP(); $rptop->parseDomDocument($domDoc); //print_r($rptop); foreach ($rptop as $key => $value) { switch ($key) { case "owner": //$RPTOPEncode = new SoapObject(NCCBIZ."RPTOPEncode.php", "urn:Object"); if (is_a($value, "Owner")) { $this->formArray["ownerID"] = $rptop->owner->getOwnerID(); $xmlStr = $rptop->owner->domDocument->dump_mem(true); if (!$xmlStr) { $this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); $this->tpl->set_var("OwnerListTableBlock", ""); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); $this->tpl->set_var("OwnerListTableBlock", "error xmlDoc"); } else { $this->displayOwnerList($domDoc); } } } else { $this->tpl->set_block("rptsTemplate", "PersonList", "PersonListBlock"); $this->tpl->set_var("PersonListBlock", ""); $this->tpl->set_block("rptsTemplate", "CompanyList", "CompanyListBlock"); $this->tpl->set_var("CompanyListBlock", ""); } break; case "cityAssessor": if (is_numeric($value)) { $cityAssessor = new Person(); $cityAssessor->selectRecord($value); $this->tpl->set_var("cityAssessorID", $cityAssessor->getPersonID()); $this->tpl->set_var("cityAssessorName", $cityAssessor->getFullName()); $this->formArray["cityAssessorName"] = $cityAssessor->getFullName(); } else { $cityAssessor = $value; $this->tpl->set_var("cityAssessorID", $cityAssessor); $this->tpl->set_var("cityAssessorName", $cityAssessor); $this->formArray["cityAssessorName"] = $cityAssessor; } break; case "cityTreasurer": if (is_numeric($value)) { $cityTreasurer = new Person(); $cityTreasurer->selectRecord($value); $this->tpl->set_var("cityTreasurerID", $cityTreasurer->getPersonID()); $this->tpl->set_var("cityTreasurerName", $cityTreasurer->getFullName()); $this->formArray["cityTreasurerName"] = $cityTreasurer->getFullName(); } else { $cityTreasurer = $value; $this->tpl->set_var("cityTreasurerID", $cityTreasurer); $this->tpl->set_var("cityTreasurerName", $cityTreasurer); $this->formArray["cityTreasurerName"] = $cityTreasurer; } break; case "tdArray": $this->tpl->set_block("rptsTemplate", "defaultTDList", "defaultTDListBlock"); $this->tpl->set_block("rptsTemplate", "toggleTDList", "toggleTDListBlock"); $this->tpl->set_block("rptsTemplate", "TDList", "TDListBlock"); $tdCtr = 0; if (count($value)) { $this->tpl->set_block("rptsTemplate", "TDDBEmpty", "TDDBEmptyBlock"); $this->tpl->set_var("TDDBEmptyBlock", ""); /* $this->tpl->set_block("TDList", "Land", "LandBlock"); $this->tpl->set_block("TDList", "PlantsTrees", "PlantsTreesBlock"); $this->tpl->set_block("TDList", "ImprovementsBuildings", "ImprovementsBuildingsBlock"); $this->tpl->set_block("TDList", "Machineries", "MachineriesBlock"); */ foreach ($value as $tkey => $tvalue) { //foreach($tvalue as $column => $val){ // $this->tpl->set_var($column,$val); //} $this->tpl->set_var("tdID", $tvalue->getTDID()); $this->tpl->set_var("taxDeclarationNumber", $tvalue->getTaxDeclarationNumber()); $this->tpl->set_var("afsID", $tvalue->getAfsID()); $this->tpl->set_var("cancelsTDNumber", $tvalue->getCancelsTDNumber()); $this->tpl->set_var("canceledByTDNumber", $tvalue->getCanceledByTDNumber()); $this->tpl->set_var("taxBeginsWithTheYear", $tvalue->getTaxBeginsWithTheYear()); $this->tpl->set_var("ceasesWithTheYear", $tvalue->getCeasesWithTheYear()); $this->tpl->set_var("enteredInRPARForBy", $tvalue->getEnteredInRPARForBy()); $this->tpl->set_var("enteredInRPARForYear", $tvalue->getEnteredInRPARForYear()); $this->tpl->set_var("previousOwner", $tvalue->getPreviousOwner()); $this->tpl->set_var("previousAssessedValue", $tvalue->getPreviousAssessedValue()); list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $tvalue->getProvincialAssessorDate()); $this->tpl->set_var("pa_yearValue", removePreZero($dateArr["year"])); $this->tpl->set_var("pa_month", removePreZero($dateArr["month"])); $this->tpl->set_var("pa_dayValue", removePreZero($dateArr["day"])); list($dateArr["year"], $dateArr["month"], $dateArr["day"]) = explode("-", $tvalue->getCityMunicipalAssessorDate()); $this->tpl->set_var("cm_yearValue", removePreZero($dateArr["year"])); $this->tpl->set_var("cm_month", removePreZero($dateArr["month"])); $this->tpl->set_var("cm_dayValue", removePreZero($dateArr["day"])); $this->tpl->set_var("provincialAssessorName", $tvalue->provincialAssessor); $this->tpl->set_var("cityMunicipalAssessorName", $tvalue->cityMunicipalAssessor); //$this->tpl->set_var("assessedValue",$tvalue->getAssessedValue()); $this->tpl->set_var("propertyType", $tvalue->getPropertyType()); $this->tpl->set_var("basicTax", ""); $this->tpl->set_var("sefTax", ""); $this->tpl->set_var("total", ""); //$this->tpl->set_var("basicTax",$tvalue->getBasicTax()); //$this->tpl->set_var("sefTax",$tvalue->getSefTax()); //$this->tpl->set_var("total",$tvalue->getTotal()); $AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object"); if (!($xmlStr = $AFSDetails->getAFS($tvalue->getAfsID()))) { //$this->tpl->set_block("rptsTemplate", "AFSTable", "AFSTableBlock"); //$this->tpl->set_var("AFSTableBlock", "afs not found"); } else { //echo $xmlStr; if (!($domDoc = domxml_open_mem($xmlStr))) { //$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock"); //$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc"); } else { $afs = new AFS(); $afs->parseDomDocument($domDoc); $this->formArray["landTotalMarketValue"] += $afs->getLandTotalMarketValue(); $this->formArray["landTotalAssessedValue"] += $afs->getLandTotalAssessedValue(); $this->formArray["plantTotalMarketValue"] += $afs->getPlantTotalMarketValue(); $this->formArray["plantTotalAssessedValue"] += $afs->getPlantTotalAssessedValue(); $this->formArray["bldgTotalMarketValue"] += $afs->getBldgTotalMarketValue(); $this->formArray["bldgTotalAssessedValue"] += $afs->getBldgTotalAssessedValue(); $this->formArray["machTotalMarketValue"] += $afs->getMachTotalMarketValue(); $this->formArray["machTotalAssessedValue"] += $afs->getMachTotalAssessedValue(); $this->formArray["totalMarketValue"] += $afs->getTotalMarketValue(); $this->formArray["totalAssessedValue"] += $afs->getTotalAssessedValue(); $this->tpl->set_var("marketValue", number_format($afs->getTotalMarketValue(), 2, '.', ',')); $this->tpl->set_var("assessedValue", number_format($afs->getTotalAssessedValue(), 2, '.', ',')); $this->tpl->set_var("taxability", $afs->getTaxability()); $this->tpl->set_var("effectivity", $afs->getEffectivity()); $this->formArray["idle"] = "No"; if ($tvalue->getPropertyType() == "Land") { if (is_array($afs->landArray)) { // if land is stripped if (count($afs->landArray) > 1) { foreach ($afs->landArray as $land) { if ($land->getIdle() == "Yes") { $this->formArray["idle"] = "Yes"; break; } } } else { $this->formArray["idle"] = $afs->landArray[0]->getIdle(); } } } if ($this->formArray["idle"] == "") { $this->formArray["idle"] = "No"; } $this->tpl->set_var("idle", $this->formArray["idle"]); } } // grab Due from tdID $this->formArray["totalTaxDue"] = 0.0; $DueDetails = new SoapObject(NCCBIZ . "DueDetails.php", "urn:Object"); if (!($xmlStr = $DueDetails->getDueFromTdID($tvalue->getTdID(), $rptop->getTaxableYear()))) { $this->tpl->set_var("dueID", ""); $this->tpl->set_var("dueDate", "---/--/--"); $this->tpl->set_var("basicTax", "uncalculated"); $this->tpl->set_var("sefTax", "uncalculated"); $this->tpl->set_var("idleTax", "uncalculated"); $this->tpl->set_var("taxDue", "uncalculated"); } else { if (!($domDoc = domxml_open_mem($xmlStr))) { $this->tpl->set_var("dueDate", "---/--/--"); $this->tpl->set_var("dueID", "uncalculated"); $this->tpl->set_var("basicTax", "uncalculated"); $this->tpl->set_var("sefTax", "uncalculated"); $this->tpl->set_var("idleTax", "uncalculated"); $this->tpl->set_var("taxDue", "uncalculated"); } else { $due = new Due(); $due->parseDomDocument($domDoc); $this->tpl->set_var("dueID", $due->getDueID()); $this->tpl->set_var("dueDate", date("M. d, Y", strtotime($due->getDueDate()))); $this->tpl->set_var("basicTax", formatCurrency($due->getBasicTax())); $this->tpl->set_var("sefTax", formatCurrency($due->getSEFTax())); $this->tpl->set_var("idleTax", formatCurrency($due->getIdleTax())); $this->tpl->set_var("taxDue", formatCurrency($due->getTaxDue())); $this->formArray["totalTaxDue"] += $due->getTaxDue(); } } // refresh tdHistory // insert/update Dues from PreviousTD as BacktaxTD for CurrentTD // if previous TD has no Dues, create a Due and insert as BacktaxTD $this->formArray["taxableYear"] = $rptop->getTaxableYear(); $this->refreshTDHistory($tvalue); $this->tpl->set_var("ctr", $tdCtr); $this->tpl->parse("defaultTDListBlock", "defaultTDList", true); $this->tpl->parse("toggleTDListBlock", "toggleTDList", true); $this->tpl->parse("TDListBlock", "TDList", true); /* $this->tpl->set_var("LandBlock", ""); $this->tpl->set_var("PlantsTreesBlock", ""); $this->tpl->set_var("ImprovementsBuildingsBlock", ""); $this->tpl->set_var("MachineriesBlock", ""); */ $tdCtr++; } } else { $this->tpl->set_var("defaultTDListBlock", "//no default"); $this->tpl->set_var("toggleTDListBlock", "//no Toggle"); $this->tpl->set_var("TDListBlock", ""); } $this->tpl->set_var("tdCtr", $tdCtr); break; case "landTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "landTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "plantTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "plantTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "bldgTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "bldgTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "machTotalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "machTotalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "totalMarketValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; case "totalAssessedValue": if (!$this->formArray[$key]) { $this->formArray[$key] = $value; } break; default: $this->formArray[$key] = $value; } } $this->formArray["totalMarketValue"] = $this->formArray["landTotalMarketValue"] + $this->formArray["plantTotalMarketValue"] + $this->formArray["bldgTotalMarketValue"] + $this->formArray["machTotalMarketValue"]; $this->formArray["totalAssessedValue"] = $this->formArray["landTotalAssessedValue"] + $this->formArray["plantTotalAssessedValue"] + $this->formArray["bldgTotalAssessedValue"] + $this->formArray["machTotalAssessedValue"]; unset($rptop); $AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object"); $rptop = new RPTOP(); $rptop->setRptopID($this->formArray["rptopID"]); $rptop->setLandTotalMarketValue($this->formArray["landTotalMarketValue"]); $rptop->setLandTotalAssessedValue($this->formArray["landTotalAssessedValue"]); $rptop->setPlantTotalMarketValue($this->formArray["plantTotalMarketValue"]); $rptop->setPlantTotalPlantAssessedValue($this->formArray["plantTotalAssessedValue"]); $rptop->setBldgTotalMarketValue($this->formArray["bldgTotalMarketValue"]); $rptop->setBldgTotalAssessedValue($this->formArray["bldgTotalAssessedValue"]); $rptop->setMachTotalMarketValue($this->formArray["machTotalMarketValue"]); $rptop->setMachTotalAssessedValue($this->formArray["machTotalAssessedValue"]); $rptop->setTotalMarketValue($this->formArray["totalMarketValue"]); $rptop->setTotalAssessedValue($this->formArray["totalAssessedValue"]); $rptop->setCreatedBy($this->userID); $rptop->setModifiedBy($this->userID); $rptop->setDomDocument(); $RPTOPEncode = new SoapObject(NCCBIZ . "RPTOPEncode.php", "urn:Object"); $rptop->setDomDocument(); $doc = $rptop->getDomDocument(); $xmlStr = $doc->dump_mem(true); //echo $xmlStr; if (!($ret = $RPTOPEncode->updateRPTOPtotals($xmlStr))) { echo "ret=" . $ret; } //echo $ret; } } $this->setForm(); $this->setPageDetailPerms(); $this->tpl->set_var("uname", $this->user["uname"]); $this->tpl->set_var("today", date("F j, Y")); $this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("rptopID" => $this->formArray["rptopID"], "ownerID" => $this->formArray["ownerID"]))); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); $this->tpl->p("templatePage"); }
function Main() { $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() { $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 getCollectionTargetsForCurrentQuarter($year) { $conditionQuarterEndingDate = date("Y-m-d", strtotime($this->formArray["quarterEndingDate"] . " " . $year)); $conditionQuarterBeginningDate = date("Y-m-d", strtotime($this->formArray["quarterBeginningDate"] . " " . $year)); $sql = "SELECT * FROM " . DUE_TABLE . " WHERE dueDate >= '" . $conditionQuarterBeginningDate . "' AND dueDate <= '" . $conditionQuarterEndingDate . "';"; $db = new DB_RPTS(); $db->query($sql); $dueRecords = new DueRecords(); $dueRecords = new DueRecords(); while ($db->next_record()) { $due = new Due(); $due->selectRecord($db->f("dueID")); $dueRecords->arrayList[] = $due; } if (is_array($dueRecords->arrayList)) { foreach ($dueRecords->arrayList as $due) { if ($due->getDueType() != "Q1") { $this->formArray["basic"] += $due->getBasicTax(); $this->formArray["sef"] += $due->getSefTax(); $this->formArray["idle"] += $due->getIdleTax(); } } } }
function Main() { $this->displayLGUName(); $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))) { 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; $tdContinuousCtr = 1; if (count($value)) { $this->tdPagingArray["tdCount"] = count($value); $this->tdPagingArray["tdPageRecordsCounter"] = 1; $this->tdPagingArray["tdTotalPages"] = ceil($this->tdPagingArray["tdCount"] / $this->tdPagingArray["tdPageBy"]); $this->tdPagingArray["tdPageNumber"] = 1; $this->tpl->set_block("rptsTemplate", "Page", "PageBlock"); $this->tpl->set_block("Page", "FirstPageText", "FirstPageTextBlock"); $this->tpl->set_block("Page", "ContinuedFromPreviousPageText", "ContinuedFromPreviousPageTextBlock"); $this->tpl->set_block("Page", "ContinuedNextPageText", "ContinuedNextPageTextBlock"); $this->tpl->set_block("Page", "Totals", "TotalsBlock"); foreach ($value as $tkey => $tvalue) { $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]) > 13) { $this->formArray["pin" . $tdCtr . "a"] = substr($this->formArray["pin" . $tdCtr], 0, 12); $this->formArray["pin" . $tdCtr . "b"] = substr($this->formArray["pin" . $tdCtr], 12); $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(); $this->formArray["totalMarketValue"] += $this->formArray["marketValue"]; $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(); //WRONG CODE --------------------------------------------------> //$this->formArray["totalBasic"] += $due->getBasicTax(); //$this->formArray["totalSef"] += $due->getSEFTax(); //$this->formArray["totalTaxes"] += $due->getTaxDue(); //-------------------------------------------------------------> } } } } $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"]; //NEW CODE - Argao----Added on 03152008--------------------------------------------> //Computes Grand Totals on Basic, SEF and Total-----By CHT $this->formArray["totalBasic"] = $this->formArray["totalAssessedValue"] * 0.01; $this->formArray["totalSef"] = $this->formArray["totalAssessedValue"] * 0.01; $this->formArray["totalTaxes"] = $this->formArray["totalBasic"] + $this->formArray["totalSef"]; //---------------------------------------------------------------------------------> if ($this->tdPagingArray["tdPageRecordsCounter"] == $this->tdPagingArray["tdPageBy"]) { // if 6 $this->setForm(); $this->resetTDPageRecords(); $this->tpl->set_var("tdPageNumber", $this->tdPagingArray["tdPageNumber"]); $this->tpl->set_var("tdTotalPages", $this->tdPagingArray["tdTotalPages"]); if ($this->tdPagingArray["tdPageNumber"] > 1) { $this->tpl->set_var("FirstPageTextBlock", ""); $this->tpl->parse("ContinuedFromPreviousPageTextBlock", "ContinuedFromPreviousPageText", true); } else { if ($this->tdPagingArray["tdPageNumber"] == 1) { $this->tpl->parse("FirstPageTextBlock", "FirstPageText", true); $this->tpl->set_var("ContinuedFromPreviousPageTextBlock", ""); } } if ($this->tdPagingArray["tdTotalPages"] > 1 && $this->tdPagingArray["tdPageNumber"] < $this->tdPagingArray["tdTotalPages"]) { $this->tpl->parse("ContinuedNextPageTextBlock", "ContinuedNextPageText", true); } else { if ($this->tdPagingArray["tdTotalPages"] == 1) { $this->tpl->set_var("ContinuedNextPageTextBlock", ""); } } if ($this->tdPagingArray["tdTotalPages"] == $this->tdPagingArray["tdPageNumber"]) { $this->tpl->parse("TotalsBlock", "Totals", true); } else { $this->tpl->set_var("TotalsBlock", ""); } $this->tpl->parse("PageBlock", "Page", true); $this->tpl->set_var("FirstPageTextBlock", ""); $this->tpl->set_var("ContinuedFromPreviousPageTextBlock", ""); $this->tpl->set_var("ContinuedNextPageTextBlock", ""); $this->tpl->set_var("TotalsBlock", ""); $this->tdPagingArray["tdPageNumber"]++; $this->formArray["pageNumber"]++; // reset counter $this->tdPagingArray["tdPageRecordsCounter"] = 0; $tdCtr = 0; } else { if ($tdContinuousCtr == $this->tdPagingArray["tdCount"]) { // if this is the last record, and count is still not 6 $this->setForm(); $this->resetTDPageRecords(); $this->tpl->set_var("tdPageNumber", $this->tdPagingArray["tdPageNumber"]); $this->tpl->set_var("tdTotalPages", $this->tdPagingArray["tdTotalPages"]); if ($this->tdPagingArray["tdPageNumber"] > 1) { $this->tpl->set_var("FirstPageTextBlock", ""); $this->tpl->parse("ContinuedFromPreviousPageTextBlock", "ContinuedFromPreviousPageText", true); } else { if ($this->tdPagingArray["tdPageNumber"] == 1) { $this->tpl->parse("FirstPageTextBlock", "FirstPageText", true); $this->tpl->set_var("ContinuedFromPreviousPageTextBlock", ""); } } if ($this->tdPagingArray["tdTotalPages"] > 1 && $this->tdPagingArray["tdPageNumber"] < $this->tdPagingArray["tdTotalPages"]) { $this->tpl->parse("ContinuedNextPageTextBlock", "ContinuedNextPageText", true); } else { if ($this->tdPagingArray["tdTotalPages"] == 1) { $this->tpl->set_var("ContinuedNextPageTextBlock", ""); } } if ($this->tdPagingArray["tdTotalPages"] == $this->tdPagingArray["tdPageNumber"]) { $this->tpl->parse("TotalsBlock", "Totals", true); } else { $this->tpl->set_var("TotalsBlock", ""); } $this->tpl->parse("PageBlock", "Page", true); $this->tpl->set_var("FirstPageTextBlock", ""); $this->tpl->set_var("ContinuedFromPreviousPageTextBlock", ""); $this->tpl->set_var("ContinuedNextPageTextBlock", ""); $this->tpl->set_var("TotalsBlock", ""); $this->tdPagingArray["tdPageNumber"]++; $this->formArray["pageNumber"]++; } } $tdCtr++; $tdContinuousCtr++; $this->tdPagingArray["tdPageRecordsCounter"]++; } } break; default: $this->formArray[$key] = $value; } } unset($rptop); } } $this->tpl->set_block("rptsTemplate", "Totals", "TotalsBlock"); $this->tpl->set_var("TotalsBlock", ""); //$this->setForm(); $this->tpl->parse("templatePage", "rptsTemplate"); $this->tpl->finish("templatePage"); // print_r($this->tpl->get("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); } //header("location: ".$testpdf->pdfPath); }