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);
}
