function Main()
{
$AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object");
if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) {
exit("afs not found");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
exit("error xmlDoc");
} else {
$afs = new AFS();
$afs->parseDomDocument($domDoc);
$this->formArray["propertyIndexNumber"] = $afs->getPropertyIndexNumber();
$this->formArray["arpNumber"] = $afs->getArpNumber();
$this->formArray["effectivity"] = $afs->getEffectivity();
if ($afs->getTaxability() == "Taxable") {
$this->formArray["isTaxable"] = "X";
$this->formArray["isExempt"] = " ";
} else {
if ($afs->getTaxability() == "Exempt") {
$this->formArray["isExempt"] = "X";
$this->formArray["isTaxable"] = " ";
}
}
$this->displayODAFS($this->formArray["afsID"]);
$this->displayTDDetails();
// if propertyType is "Land", grab Land values plus PlantsTrees values
// if propertyType is "ImprovementsBuildings" or "Machineries", system should later on grab
// "Land" from another AFS from based on bldg->landPin or mach->landPin field
// still needs to be resolved whether to do it this way or not
switch ($this->formArray["propertyType"]) {
case "Land":
$landList = $afs->getLandArray();
$plantsTreesList = $afs->getPlantsTreesArray();
if (is_array($landList)) {
$this->displayLandDetails($landList);
$this->displayLandList($landList);
}
if (is_array($plantsTreesList)) {
$this->displayPlantsTreesList($plantsTreesList);
}
break;
case "ImprovementsBuildings":
$improvementsBuildingsList = $afs->getImprovementsBuildingsArray();
if (is_array($improvementsBuildingsList)) {
$this->displayImprovementsBuildingsList($improvementsBuildingsList);
}
break;
case "Machineries":
$machineriesList = $afs->getMachineriesArray();
if (is_array($machineriesList)) {
$this->displayMachineriesList($machineriesList);
}
break;
}
// UNCOMMENT LINES TO GRAB totalMarketValue and totalAssessedValue from AFS object instead of
// computing from each property:
//$this->formArray["totalMarketValue"] = $afs->getTotalMarketValue();
//$this->formArray["totalAssessedValue"] = $afs->getTotalAssessedValue();
$this->formArray["totalAssessedValueInWords"] = makewords($this->formArray["totalAssessedValue"]);
}
}
$this->setForm();
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$testpdf = new PDFWriter();
$testpdf->setOutputXML($this->tpl->get("templatePage"), "test");
if (isset($this->formArray["print"])) {
$testpdf->writePDF($name);
//,$this->formArray["print"]);
} else {
$testpdf->writePDF($name);
}
// header("location: ".$testpdf->pdfPath);
exit;
}
function Main()
{
$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();
$td = new TD();
$rptop->parseDomDocument($domDoc);
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_a($value, Assessor)) {
$this->tpl->set_var("cityAssessorID", $value->getAssessorID());
$this->tpl->set_var("cityAssessorName", $value->getFullName());
$this->formArray["cityAssessorName"] = $value->getFullName();
} else {
$this->tpl->set_var($key, "");
}
break;
case "cityTreasurer":
if (is_a($value, Assessor)) {
$this->tpl->set_var("cityTreasurerID", $value->getAssessorID());
$this->tpl->set_var("cityTreasurerName", $value->getFullName());
$this->formArray["cityTreasurerName"] = $value->getFullName();
} else {
$this->tpl->set_var($key, "");
}
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;
//echo("count=".count($value)."<br>");
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) {
$td->selectRecord($tvalue->getTdID());
$assessedValue = number_format($td->getAssessedValue(), 2, ".", "");
$propertyType = $td->getPropertyType();
$afsID = $td->getAfsID();
$afs = new AFS();
$afs->selectRecord($afsID);
$PropertyIndexNumber = $afs->getPropertyIndexNumber();
$idleStatus = $td->getIdleStatus();
$formAssessedValue = number_format($td->getAssessedValue(), 2);
if ($propertyType == "Land") {
$formValues['assessedValueLand'] = $formAssessedValue;
$formValues['assessedValueOthers'] = "";
} else {
$formValues['assessedValueLand'] = "";
$formValues['assessedValueOthers'] = $formAssessedValue;
}
$formValues['assessedValue'] = $formAssessedValue;
$formValues['propertyType'] = $propertyType;
$taxDue = new Dues($tvalue->getTdID(), $this->formArray['taxableYear']);
$taxDue->setBasic($assessedValue);
$taxDue->setSEF($assessedValue);
$taxDue->setIdleStatus($idleStatus);
if ($taxDue->getIdleStatus()) {
$taxDue->setIdle($assessedValue);
} else {
$taxDue->setIdle(0);
}
$taxDue->store();
$dueValues['basic'] = number_format($taxDue->getBasic(), 2);
$dueValues['sef'] = number_format($taxDue->getSEF(), 2);
$dueValues['total'] = number_format($taxDue->getBasic() + $taxDue->getSEF(), 2);
$totalValues['totBasic'] += $taxDue->getBasic();
$totalValues['totSEF'] += $taxDue->getSEF();
$totalValues['totTotal'] += $taxDue->getBasic() + $taxDue->getSEF();
$totalValues['totAssessedValue'] += $assessedValue;
$this->tpl->set_var($dueValues);
$tdValues['assessedValue'] = number_format($assessedValue, 2);
$tdValues['tdNumber'] = $tvalue->getTaxDeclarationNumber();
$tdValues['propertyIndexNumber'] = $PropertyIndexNumber;
$this->tpl->set_var($tdValues);
$this->tpl->set_var("ctr", $tdCtr);
$this->tpl->parse("TDListBlock", "TDList", true);
$tdCtr++;
}
} else {
$this->tpl->set_var("TDListBlock", "");
}
$this->tpl->set_var("tdCtr", $tdCtr);
break;
default:
$this->formArray[$key] = $value;
}
}
}
}
$this->setForm();
$this->tpl->set_var("uname", $this->user["uname"]);
$this->tpl->set_var("today", date("F j, Y"));
$this->setPageDetailPerms();
$totalValues['totBasic'] = number_format($totalValues['totBasic'], 2);
$totalValues['totSEF'] = number_format($totalValues['totSEF'], 2);
$totalValues['totTotal'] = number_format($totalValues['totTotal'], 2);
$totalValues['totAssessedValue'] = number_format($totalValues['totAssessedValue'], 2);
$this->tpl->set_var($totalValues);
$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()
{
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("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("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->getAFSForList($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["propertyIndexNumber"] = $afs->getPropertyIndexNumber();
$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, '.', ','));
// get BASIC and SEF
$taxesDue = new Dues($tvalue->getTdID(), $rptop->getTaxableYear(), $afs->getTotalAssessedValue());
$basicTax = number_format($taxesDue->getBasic(), 2);
$sefTax = number_format($taxesDue->getSEF(), 2);
$total = number_format($taxesDue->getBasic() + $taxesDue->getSEF(), 2);
$this->tpl->set_var("basicTax", $basicTax);
$this->tpl->set_var("sefTax", $sefTax);
$this->tpl->set_var("total", $total);
}
}
$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 displayRecords()
{
$this->selectRecords();
$this->tpl->set_block("rptsTemplate", "OwnerPersonList", "OwnerPersonListBlock");
$this->tpl->set_block("OwnerPersonList", "ODList", "ODListBlock");
foreach ($this->arrayList as $person) {
$this->tpl->set_var("personID", $person->getPersonID());
$this->tpl->set_var("lastName", $person->getLastName());
$this->tpl->set_var("firstName", $person->getFirstName());
$this->tpl->set_var("middleName", $person->getMiddleName());
$this->tpl->set_var("gender", $person->getGender());
$this->tpl->set_var("birthday", $person->getBirthday());
$this->tpl->set_var("maritalStatus", $person->getMaritalStatus());
$this->tpl->set_var("tin", $person->getTin());
$this->tpl->set_var("telephone", $person->getTelephone());
$this->tpl->set_var("mobileNumber", $person->getMobileNumber());
$this->tpl->set_var("email", $person->getEmail());
if (is_array($person->addressArray)) {
$address = $person->addressArray[0];
$this->tpl->set_var("address", $address->getFullAddress());
}
// capture OD, AFS, and TD info
$this->setDB();
$sql = sprintf("SELECT DISTINCT(Owner.odID) as odID" . " FROM Owner,OwnerPerson " . " WHERE " . " Owner.ownerID = OwnerPerson.ownerID AND " . " OwnerPerson.personID = '%s' ", $person->getPersonID());
$this->db->query($sql);
while ($this->db->next_record()) {
$od = new OD();
if ($od->selectRecord($this->db->f("odID"))) {
$this->ODArray[] = $od;
$this->tpl->set_var("odID", $od->getOdID());
if (is_object($od->locationAddress)) {
$this->tpl->set_var("locationAddress", $od->locationAddress->getFullAddress());
} else {
$this->tpl->set_var("locationAddress", "");
}
$afs = new AFS();
if ($afs->selectRecord("", "", $od->getOdID(), "")) {
$this->tpl->set_var("afsID", $afs->getAfsID());
$this->tpl->set_var("propertyIndexNumber", $afs->getPropertyIndexNumber());
$this->tpl->set_var("arpNumber", $afs->getArpNumber());
if (is_array($afs->landArray)) {
$this->displayLandList($afs->landArray);
}
if (is_array($afs->plantsTreesArray)) {
$this->displayPlantsTreesList($afs->plantsTreesArray);
}
if (is_array($afs->improvementsBuildingsArray)) {
$this->displayImprovementsBuildingsList($afs->improvementsBuildingsArray);
}
if (is_array($afs->machineriesArray)) {
$this->displayMachineriesList($afs->machineriesArray);
}
$td = new TD();
if ($td->selectRecord("", $afs->getAfsID(), "", "", "")) {
$this->tpl->set_var("tdID", $td->getTdID());
$this->tpl->set_var("taxDeclarationNumber", $td->getTaxDeclarationNumber());
$this->tpl->set_var("propertyType", $td->getPropertyType());
}
}
unset($td);
unset($afs);
unset($od);
$this->tpl->parse("ODListBlock", "ODList", true);
}
}
$this->tpl->parse("OwnerPersonListBlock", "OwnerPersonList", true);
$this->tpl->set_var("ODListBlock", "");
$this->clearPropertyElements();
unset($this->ODArray);
unset($this->AFSArray);
unset($this->TDArray);
unset($this->db);
}
}
function Main()
{
$this->formArray['currentDate'] = date("F d, Y");
$MunicipalityCityDetails = new SoapObject(NCCBIZ . "MunicipalityCityDetails.php", "urn:Object");
#test values
//$this->formArray['municipalityCityID']=1;
if (!($xmlStr = $MunicipalityCityDetails->getMunicipalityCityDetails($this->formArray['municipalityCityID']))) {
#echo($xmlStr);
//exit("xml failed for municipality");
header("Location: " . $this->sess->url("ViewSOA.php") . "&status=2");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
echo "error xmlDoc";
} else {
$MunicipalityCity = new MunicipalityCity();
$MunicipalityCity->parseDomDocument($domDoc);
$this->formArray['municipality'] = $MunicipalityCity->getDescription();
}
}
#test values
//$this->formArray['ownerID']=5;
#echo("ownerID=".$this->formArray['ownerID']."<br>");
// $this->displayOwnerList($this->formArray['ownerID']);
#test values
//$this->formArray["rptopID"]=15;
if ($this->formArray['personID'] != "") {
$person = new Person();
$person->selectRecord($this->formArray['personID']);
$this->tpl->set_var(ownerName, $person->getFullName());
$this->tpl->set_var(ownerNo, $person->getTin());
$address = $person->addressArray[0];
$this->tpl->set_var(ownerAddress, $address->getNumber() . " " . $address->getStreet() . " " . $address->getBarangay() . " " . $address->getDistrict() . " " . $address->getMunicipalitycity() . " " . $address->getProvince());
$db = new DB_RPTS();
$sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=" . $this->formArray['personID'];
$db->query($sql);
} else {
$company = new Company();
$company->selectRecord($this->formArray['companyID']);
$this->tpl->set_var(ownerName, $company->getCompanyName());
$this->tpl->set_var(ownerNo, $company->getCompanyID());
$address = $company->addressArray[0];
$this->tpl->set_var(ownerAddress, $address->getNumber() . " " . $address->getStreet() . " " . $address->getBarangay() . " " . $address->getDistrict() . " " . $address->getMunicipalitycity() . " " . $address->getProvince());
$db = new DB_RPTS();
$sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=" . $this->formArray['companyID'];
$db->query($sql);
}
/*$person = new Person();
$person->selectRecord($this->formArray['personID']);
$this->tpl->set_var(ownerName,$person->getFullName());
$this->tpl->set_var(ownerNo,$person->getTin());
$address = $person->addressArray[0];
$this->tpl->set_var(ownerAddress,$address->getNumber() ." ".$address->getStreet()." ".$address->getBarangay()." ".$address->getDistrict()." ".$address->getMunicipalitycity()." ".$address->getProvince());
$db = new DB_RPTS();
$sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=".$this->formArray['personID'];
$db->query($sql);*/
$this->tpl->set_block("rptsTemplate", "ROW", "RowBlk");
for ($i = 0; $db->next_record(); $i++) {
$rptopID = $db->f("rptopID");
$RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object");
if (!($xmlStr = $RPTOPDetails->getRPTOP($rptopID))) {
// exit("xml failed for RPTOP");
header("Location: " . $this->sess->url("ViewSOA.php") . "&status=1");
} else {
//echo $xmlStr;
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$rptop = new RPTOP();
$td = new TD();
$rptop->parseDomDocument($domDoc);
foreach ($rptop as $key => $value) {
$this->formArray['payableYear'] = $rptop->getTaxableYear();
$rptopID = $rptop->getRptopID();
if ($key == "tdArray") {
$tdCtr = 0;
if (count($value)) {
foreach ($value as $tkey => $tvalue) {
$td->selectRecord($tvalue->getTdID());
$assessedValue = number_format($td->getAssessedValue(), 2, ".", "");
$propertyType = $td->getPropertyType();
$TaxDeclarationNumber = $td->getTaxDeclarationNumber();
// $this->tpl->set_var(kind,$propertyType);
// $this->tpl->set_var(currentTDNo,$TaxDeclarationNumber);
/* $dues = new Dues();
$dues->create($td->getTdID(), "","","","2003");
$this->tpl->set_var(basic,$dues->getBasic());
$totBasic += $dues->getBasic();
$this->tpl->set_var(sef,$dues->getSEF());
$totSEF += $dues->getSEF();
$this->tpl->set_var(total,$dues->getSEF()+$dues->getBasic());
$totTaxDue += $dues->getSEF()+$dues->getBasic();*/
$afsID = $td->getAfsID();
$afs = new AFS();
$afs->selectRecord($afsID);
$od = new OD();
$od->selectRecord($afs->getOdID());
$addr = $od->getLocationAddress();
if (count($addr)) {
$location = $addr->getFullAddress();
// $this->tpl->set_var(location,$addr->getFullAddress());
$munCityID = $addr->getMunicipalityCityID();
// if($munCityID == $this->formArray['municipalityCityID'])
// $this->tpl->set_var(municipality,$addr->getMunicipalityCity());
}
if (count($afs->landArray)) {
foreach ($afs->landArray as $afsKey => $afsValue) {
$actualUse = $afsValue->getActualUse();
$landActualUses = new LandActualUses();
$landActualUses->selectRecord($actualUse);
//$this->tpl->set_var("class",$landActualUses->getCode());
$Code = $landActualUses->getCode();
}
}
if (count($afs->improvementsBuildingsArray)) {
foreach ($afs->improvementsBuildingsArray as $afsKey => $afsValue) {
$actualUse = $afsValue->getActualUse();
$improvementsBuildingsActualUses = new improvementsBuildingsActualUses();
$improvementsBuildingsActualUses->selectRecord($actualUse);
//$this->tpl->set_var("class",$improvementsBuildingsActualUses->getCode());
$Code = $improvementsBuildingsActualUses->getCode();
}
}
//echo $afs->get
// echo $munCityID ."==". $this->formArray['municipalityCityID']."<br>";
if ($munCityID == $this->formArray['municipalityCityID']) {
$this->tpl->set_var(location, $location);
$this->tpl->set_var("class", $Code);
$this->tpl->set_var(kind, $propertyType);
$this->tpl->set_var(currentTDNo, $TaxDeclarationNumber);
$this->tpl->set_var(municipality, $addr->getMunicipalityCity());
$dues = new Dues();
$dues->create($td->getTdID(), "", "", "", "2003");
$totTaxDue += $dues->getSEF() + $dues->getBasic();
$basic = number_format($dues->getBasic(), "2", ".", "");
$this->tpl->set_var(basic, $basic);
$totBasic += $basic;
$sef = number_format($dues->getSEF(), "2", ".", "");
$this->tpl->set_var(sef, $sef);
$totSEF += number_format($sef, "2", ".", "");
$this->tpl->set_var(total, number_format($sef + $basic, "2", ".", ""));
$this->tpl->set_var(marketValue, number_format($afs->getTotalMarketValue(), 2));
$totMarketValue += $afs->getTotalMarketValue();
$this->tpl->set_var(assessedValue, number_format($afs->getTotalAssessedValue(), 2));
$totAssessedValue += $afs->getTotalAssessedValue();
$pIndexNo = $afs->getPropertyIndexNumber();
if ($pIndexNo == "") {
$pIndexNo = "No value specified";
}
$this->tpl->set_var(pin, $pIndexNo);
//echo $afs->getTotalMarketValue();
/* if(count($afs->landArray)){
foreach($afs->landArray as $afsKey => $afsValue){
$this->tpl->set_var(pin,$afsValue->getPropertyIndexNumber());
}
}
*/
$this->tpl->parse("RowBlk", "ROW", true);
}
//else{
// $this->tpl->set_var("RowBlk","");
// }
}
#end foreach($value)
}
#end if coun value
$this->tpl->set_var(totalMarketValue, number_format($totMarketValue, 2));
$this->tpl->set_var(totalAssessedValue, number_format($totAssessedValue, 2));
$this->tpl->set_var(totalBasic, number_format($totBasic, 2));
$this->tpl->set_var(totalSEF, number_format($totSEF, 2));
$this->tpl->set_var(totalTaxDue, number_format($totTaxDue, 2));
}
}
}
// $this->tpl->parse("RowBlk","ROW",true);
}
}
// $owner
/* $RPTOPDetails = new SoapObject(NCCBIZ."RPTOPDetails.php", "urn:Object");
if (!$xmlStr = $RPTOPDetails->getRPTOP($this->formArray["rptopID"])){
//exit("xml failed for RPTOP");
header("Location: ".$this->sess->url("ViewSOA.php")."&status=1");
}
else{
//echo $xmlStr;
if(!$domDoc = domxml_open_mem($xmlStr)) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
}
else {
$rptop = new RPTOP;
$td = new TD();
$rptop->parseDomDocument($domDoc);
$status_report = "";
foreach($rptop as $key => $value){
$this->formArray['payableYear'] = $rptop->getTaxableYear();
$rptopID = $rptop->getRptopID();
if($key=="tdArray"){
$tdCtr = 0;
if (count($value)){
$this->tpl->set_block("rptsTemplate","ROW","RowBlk");
foreach($value as $tkey => $tvalue){
$td->selectRecord($tvalue->getTdID());
$assessedValue = number_format($td->getAssessedValue(),2,".","");
$propertyType = $td->getPropertyType();
$TaxDeclarationNumber = $td->getTaxDeclarationNumber();
//$tdCtr++;
$this->tpl->set_var(kind,$propertyType);
$this->tpl->set_var(currentTDNo,$TaxDeclarationNumber);
/* $dues = new Dues();
$dues->create($td->getTdID(), "","","","2003");
$this->tpl->set_var(basic,$dues->getBasic());
$totBasic += $dues->getBasic();
$this->tpl->set_var(sef,$dues->getSEF());
$totSEF += $dues->getSEF();
$this->tpl->set_var(total,$dues->getSEF()+$dues->getBasic());
$totTaxDue += $dues->getSEF()+$dues->getBasic();*/
/* $afsID = $td->getAfsID();
$afs = new AFS();
$afs->selectRecord($afsID);
$od = new OD();
$od->selectRecord($afs->getOdID());
$addr = $od->getLocationAddress();
if(count($addr)){
$this->tpl->set_var(location,$addr->getFullAddress());
$munCityID = $addr->getMunicipalityCityID();
if($munCityID == $this->formArray['municipalityCityID'])
$this->tpl->set_var(municipality,$addr->getMunicipalityCity());
}
if(count($afs->landArray)){
foreach($afs->landArray as $afsKey => $afsValue){
$actualUse = $afsValue->getActualUse();
$landActualUses = new LandActualUses();
$landActualUses->selectRecord($actualUse);
$this->tpl->set_var("class",$landActualUses->getCode());
}
}
if(count($afs->improvementsBuildingsArray)){
foreach($afs->improvementsBuildingsArray as $afsKey => $afsValue){
$actualUse = $afsValue->getActualUse();
$improvementsBuildingsActualUses = new improvementsBuildingsActualUses();
$improvementsBuildingsActualUses->selectRecord($actualUse);
$this->tpl->set_var("class",$improvementsBuildingsActualUses->getCode());
}
}
//echo $afs->get
if($munCityID == $this->formArray['municipalityCityID']){
$dues = new Dues();
$dues->create($td->getTdID(), "","","","2003");
$this->tpl->set_var(basic,number_format($dues->getBasic(),"2",".",""));
$totBasic += $dues->getBasic();
$this->tpl->set_var(sef,number_format($dues->getSEF(),"2",".",""));
$totSEF += $dues->getSEF();
$this->tpl->set_var(total,number_format($dues->getSEF()+$dues->getBasic(),"2",".",""));
$pIndexNo = $afs->getPropertyIndexNumber();
if($pIndexNo==""){
$pIndexNo = "No value specified";
}
$this->tpl->set_var(pin,$pIndexNo);
$this->tpl->set_var(marketValue,$afs->getTotalMarketValue());
$totMarketValue += $afs->getTotalMarketValue();
$this->tpl->set_var(assessedValue,$afs->getTotalAssessedValue());
$totAssessedValue += $afs->getTotalAssessedValue();
//echo $afs->getTotalMarketValue();
/* if(count($afs->landArray)){
foreach($afs->landArray as $afsKey => $afsValue){
$this->tpl->set_var(pin,$afsValue->getPropertyIndexNumber());
}
}
*/
/* $this->tpl->parse("RowBlk","ROW",true);
}else{
$this->tpl->set_var("RowBlk","");
}
}#end foreach($value)
}#end if coun value
// $this->tpl->set_block("rptsTemplate","STAT",sBlk);
// $this->tpl->set_var(status_report,$status_report);
// $this->tpl->parse(sBlk,"STAT",true);
$this->tpl->set_var(totalMarketValue,$totMarketValue);
$this->tpl->set_var(totalAssessedValue,$totAssessedValue);
$this->tpl->set_var(totalBasic,$totBasic);
$this->tpl->set_var(totalSEF,$totSEF);
$this->tpl->set_var(totalTaxDue,$totTaxDue);
}
}
}
}*/
$this->setForm();
$this->tpl->set_var("Session", $this->sess->url(""));
$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()
{
$this->formArray['currentDate'] = date("F d, Y");
$MunicipalityCityDetails = new SoapObject(NCCBIZ . "MunicipalityCityDetails.php", "urn:Object");
#test values
//$this->formArray['municipalityCityID']=1;
if (!($xmlStr = $MunicipalityCityDetails->getMunicipalityCityDetails($this->formArray['municipalityCityID']))) {
#echo($xmlStr);
exit("xml failed for municipality");
//header("Location: ".$this->sess->url("ViewSOA.php")."&status=2");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
echo "error xmlDoc";
} else {
$MunicipalityCity = new MunicipalityCity();
$MunicipalityCity->parseDomDocument($domDoc);
$this->formArray['municipality'] = $MunicipalityCity->getDescription();
}
}
if ($this->formArray['personID'] != "") {
$person = new Person();
$person->selectRecord($this->formArray['personID']);
$this->tpl->set_var(ownerName, $person->getFullName());
$this->tpl->set_var(ownerNo, $person->getTin());
$address = $person->addressArray[0];
if (is_object($address)) {
$this->tpl->set_var(ownerAddress, $address->getNumber() . " " . $address->getStreet() . " " . $address->getBarangay() . " " . $address->getDistrict() . " " . $address->getMunicipalitycity() . " " . $address->getProvince());
} else {
$this->tpl->set_var(ownerAddress, "");
}
$db = new DB_RPTS();
$sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=" . $this->formArray['personID'];
$db->query($sql);
} else {
$company = new Company();
$company->selectRecord($this->formArray['companyID']);
$this->tpl->set_var(ownerName, $company->getCompanyName());
$this->tpl->set_var(ownerNo, $company->getCompanyID());
$address = $company->addressArray[0];
$this->tpl->set_var(ownerAddress, $address->getNumber() . " " . $address->getStreet() . " " . $address->getBarangay() . " " . $address->getDistrict() . " " . $address->getMunicipalitycity() . " " . $address->getProvince());
$db = new DB_RPTS();
$sql = "SELECT rptopID FROM Owner inner join OwnerPerson on Owner.ownerID=OwnerPerson.ownerID WHERE Owner.rptopID <> '' AND OwnerPerson.personID=" . $this->formArray['companyID'];
$db->query($sql);
}
$ypos = 325;
$this->tpl->set_block("rptsTemplate", "ROW", "RowBlk");
for ($i = 0; $db->next_record(); $i++) {
$rptopID = $db->f("rptopID");
$RPTOPDetails = new SoapObject(NCCBIZ . "RPTOPDetails.php", "urn:Object");
if (!($xmlStr = $RPTOPDetails->getRPTOP($rptopID))) {
// exit("xml failed for RPTOP");
header("Location: " . $this->sess->url("ViewSOA.php") . "&status=1");
} else {
//echo $xmlStr;
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "OwnerListTable", "OwnerListTableBlock");
$this->tpl->set_var("OwnerListTableBlock", "error xmlDoc");
} else {
$rptop = new RPTOP();
$td = new TD();
$rptop->parseDomDocument($domDoc);
foreach ($rptop as $key => $value) {
$this->formArray['payableYear'] = $rptop->getTaxableYear();
$rptopID = $rptop->getRptopID();
if ($key == "tdArray") {
$tdCtr = 0;
if (count($value)) {
foreach ($value as $tkey => $tvalue) {
$td->selectRecord($tvalue->getTdID());
$assessedValue = number_format($td->getAssessedValue(), 2, ".", "");
$propertyType = $td->getPropertyType();
$TaxDeclarationNumber = $td->getTaxDeclarationNumber();
$afsID = $td->getAfsID();
$afs = new AFS();
$afs->selectRecord($afsID);
$od = new OD();
$od->selectRecord($afs->getOdID());
$addr = $od->getLocationAddress();
if (count($addr)) {
$location = strtoupper($addr->getNumber() . " " . substr($addr->getBarangay(), 0, 4) . " " . substr($addr->getMunicipalityCity(), 0, 3) . " " . substr($addr->getProvince(), 0, 3));
$munCityID = $addr->getMunicipalityCityID();
}
if (count($afs->landArray)) {
foreach ($afs->landArray as $afsKey => $afsValue) {
$actualUse = $afsValue->getActualUse();
$landActualUses = new LandActualUses();
$landActualUses->selectRecord($actualUse);
$Code = $landActualUses->getCode();
}
}
if (count($afs->improvementsBuildingsArray)) {
foreach ($afs->improvementsBuildingsArray as $afsKey => $afsValue) {
$actualUse = $afsValue->getActualUse();
$improvementsBuildingsActualUses = new improvementsBuildingsActualUses();
$improvementsBuildingsActualUses->selectRecord($actualUse);
$Code = $improvementsBuildingsActualUses->getCode();
}
}
if ($munCityID == $this->formArray['municipalityCityID']) {
$this->tpl->set_var(location, $location);
$this->tpl->set_var("class", $Code);
$this->tpl->set_var(kind, strtoupper(substr($propertyType, 0, 4)));
$this->tpl->set_var(currentTDNo, $TaxDeclarationNumber);
$this->tpl->set_var(municipality, $addr->getMunicipalityCity());
//$dues = new Dues();
//$dues->create($td->getTdID(),"2003");
//$totTaxDue += $dues->getSEF()+$dues->getBasic();
$dues = new Dues($tvalue->getTdID(), $rptop->getTaxableYear(), $assessedValue);
$paymentPeriod = $dues->getPaymentMode();
$totalTaxDue = $dues->getPaidBasic($paymentPeriod) + $dues->getPaidSEF($paymentPeriod) + $dues->getPaidIdle($paymentPeriod);
if ($dues->getAmnesty()) {
$dues->setPctPenalty(0.0);
} else {
$totalTaxDue += $dues->getPenalty($paymentPeriod);
}
if ($dues->getIsDiscount()) {
$taxDue->setDiscount($totalTaxDue);
$totalTaxDue -= $dues->getDiscount();
}
$interest = $dues->getPctPenalty();
if ($interest > 0 && $paymentPeriod != "Annual") {
$paymentPeriod = "Annual";
}
$basic = number_format($dues->getPaidBasic(), "2", ".", "");
$this->tpl->set_var(basic, $basic);
$totBasic += $basic;
$sef = number_format($dues->getPaidSEF(), "2", ".", "");
$this->tpl->set_var(sef, $sef);
$totSEF += number_format($sef, "2", ".", "");
$this->tpl->set_var(total, number_format($sef + $basic, "2", ".", ""));
$this->tpl->set_var(marketValue, number_format($afs->getTotalMarketValue(), 2));
$totMarketValue += $afs->getTotalMarketValue();
$this->tpl->set_var(assessedValue, number_format($afs->getTotalAssessedValue(), 2));
$totAssessedValue += $afs->getTotalAssessedValue();
$pIndexNo = $afs->getPropertyIndexNumber();
if ($pIndexNo == "") {
$pIndexNo = "No value specified";
}
$ypos = $ypos - 10;
$this->tpl->set_var(ypos, $ypos);
$this->tpl->set_var(pin, $pIndexNo);
$this->tpl->parse("RowBlk", "ROW", true);
}
}
#end foreach($value)
}
#end if coun value
$this->tpl->set_var(totalMarketValue, number_format($totMarketValue, 2));
$this->tpl->set_var(totalAssessedValue, number_format($totAssessedValue, 2));
$this->tpl->set_var(totalBasic, number_format($totBasic, 2));
$this->tpl->set_var(totalSEF, number_format($totSEF, 2));
$this->tpl->set_var(totalTaxDue, number_format($totalTaxDue, 2));
}
}
}
}
}
$this->setForm();
$this->tpl->set_var("Session", $this->sess->url(""));
/* $this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
*/
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$rptrpdf = new PDFWriter();
$rptrpdf->setOutputXML($this->tpl->get('templatePage'), "string");
$rptrpdf->writePDF("viewSOA.pdf");
}
function Main()
{
switch ($this->formArray["formAction"]) {
case "save":
$AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object");
if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) {
exit("error xml");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
exit("error domDoc");
} else {
$AFSEncode = new SoapObject(NCCBIZ . "AFSEncode.php", "urn:Object");
$afs = new AFS();
$afs->parseDomDocument($domDoc);
$afs->setArpNumber($this->formArray["arpNumber"]);
$afs->setPropertyIndexNumber($this->formArray["propertyIndexNumber"]);
$afs->setTaxability($this->formArray["taxability"]);
$afs->setEffectivity($this->formArray["effectivity"]);
$afs->setDomDocument();
$doc = $afs->getDomDocument();
$xmlStr = $doc->dump_mem(true);
if (!($ret = $AFSEncode->updateAFS($xmlStr))) {
exit("error update");
}
}
}
header("location: RPUIdentificationClose.php" . $this->sess->url("") . $this->sess->add_query(array("afsID" => $this->formArray["afsID"])));
exit;
break;
default:
$AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object");
$AFSDetails = new SoapObject(NCCBIZ . "AFSDetails.php", "urn:Object");
if (!($xmlStr = $AFSDetails->getAFS($this->formArray["afsID"]))) {
exit("error xml");
} else {
//echo $xmlStr;
if (!($domDoc = domxml_open_mem($xmlStr))) {
exit("error domDoc");
} else {
$afs = new AFS();
$afs->parseDomDocument($domDoc);
$this->formArray["afsID"] = $afs->getAfsID();
$this->formArray["arpNumber"] = $afs->getArpNumber();
$this->formArray["taxability"] = $afs->getTaxability();
$this->formArray["effectivity"] = $afs->getEffectivity();
$this->formArray["propertyIndexNumber"] = $afs->getPropertyIndexNumber();
}
}
break;
}
$this->setForm();
$this->tpl->set_var("Session", $this->sess->url("") . $this->sess->add_query(array("afsID" => $this->formArray["afsID"])));
$this->tpl->parse("templatePage", "rptsTemplate");
$this->tpl->finish("templatePage");
$this->tpl->p("templatePage");
}
function Main()
{
$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);
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_a($value, Assessor)) {
$this->tpl->set_var("cityAssessorID", $value->getAssessorID());
$this->tpl->set_var("cityAssessorName", $value->getFullName());
$this->formArray["cityAssessorName"] = $value->getFullName();
} else {
$this->tpl->set_var($key, "");
}
break;
case "cityTreasurer":
if (is_a($value, Assessor)) {
$this->tpl->set_var("cityTreasurerID", $value->getAssessorID());
$this->tpl->set_var("cityTreasurerName", $value->getFullName());
$this->formArray["cityTreasurerName"] = $value->getFullName();
} else {
$this->tpl->set_var($key, "");
}
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;
$totalBalance = 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) {
$propertyType = $tvalue->getPropertyType();
$assessedValue = $tvalue->getAssessedValue();
$afs = new AFS();
$afs->selectRecord($tvalue->getAfsID());
$propertyIndexNumber = $afs->getPropertyIndexNumber();
/*$propertyID = $tvalue->getPropertyID();
switch ($propertyType){
case "Land":
$land = new Land;
$land->selectRecord($propertyID);
$assessedValue = $land->getAssessedValue();
$propertyIdentityNumber = $land->getPropertyIndexNumber();
break;
case "PlantsTrees":
$plantsTrees = new PlantsTrees;
$plantsTrees->selectRecord($propertyID);
$assessedValue = $plantsTrees->getAssessedValue();
$PropertyIndexNumber = $plantsTrees->getPropertyIndexNumber();
break;
case "ImprovementsBuildings":
$improvementsBuildings = new ImprovementsBuildings;
$improvementsBuildings->selectRecord($propertyID);
$assessedValue = $improvementsBuildings->getAssessedValue();
$PropertyIndexNumber = $improvementsBuildings->getPropertyIndexNumber();
break;
case "Machineries":
$machineries = new Machineries;
$machineries->selectRecord($propertyID);
$assessedValue = $machineries->getAssessedValue();
$PropertyIndexNumber = $machineries->getPropertyIndexNumber();
break;
default:
break;
}*/
# set or get the due for this TD
//$taxDue = new Dues();
$taxDue = new Dues($tvalue->getTdID(), $rptop->getTaxableYear(), $assessedValue);
//$taxDue->create($tvalue->getTaxDeclarationNumber(), "Jan 1, ".$rptop->getRptopdate());
//$taxDue->setBasic($assessedValue);
//$taxDue->setSEF($assessedValue);
//$taxDue->store();
$dueValues['basic'] = number_format($taxDue->getBasic(), 2);
$dueValues['penalty'] = number_format($taxDue->getPenalty(), 2);
$dueValues['sef'] = number_format($taxDue->getSEF(), 2);
$dueValues['total'] = number_format($taxDue->getBasic() + $taxDue->getSEF() + $taxDue->getPenalty(), 2);
$this->tpl->set_var($dueValues);
$paidValues['paidBasic'] = number_format($taxDue->getPaidBasic(), 2);
$paidValues['paidPenalty'] = number_format($taxDue->getPaidPenalty(), 2);
$paidValues['paidSEF'] = number_format($taxDue->getPaidSEF(), 2);
$paidValues['paidTotal'] = number_format($taxDue->getPaidBasic() + $taxDue->getPaidPenalty() + $taxDue->getPaidSEF(), 2);
$this->tpl->set_var($paidValues);
$balance = round($taxDue->getBasic(), 2) + round($taxDue->getSEF(), 2) + round($taxDue->getPenalty(), 2) - ($taxDue->getPaidBasic() + $taxDue->getPaidPenalty() + $taxDue->getPaidSEF());
$totalBalance += $balance;
$this->tpl->set_var(balance, number_format(abs($balance), 2));
$totalValues['totAssessedValue'] += $assessedValue;
$totalValues['totBasic'] += round($taxDue->getBasic(), 2);
$totalValues['totPenalty'] += round($taxDue->getPenalty(), 2);
$totalValues['totSEF'] += round($taxDue->getSEF(), 2);
$totalValues['totTotal'] += round($taxDue->getBasic(), 2) + round($taxDue->getPenalty(), 2) + round($taxDue->getSEF(), 2);
$totPaidBasic += $taxDue->getPaidBasic();
$totPaidPenalty += $taxDue->getPaidPenalty();
$totPaidSEF += $taxDue->getPaidSEF();
$totPaidTotal += $taxDue->getPaidBasic() + $taxDue->getPaidPenalty() + $taxDue->getPaidSEF();
$totalValues['totPaidBasic'] = number_format($totPaidBasic, 2);
$totalValues['totPaidPenalty'] = number_format($totPaidPenalty, 2);
$totalValues['totPaidSEF'] = number_format($totPaidSEF, 2);
$totalValues['totPaidTotal'] = number_format($totPaidTotal, 2);
$tdValues['assessedValue'] = number_format($assessedValue, 2);
$tdValues['tdNumber'] = $tvalue->getTaxDeclarationNumber();
$tdValues['propertyIndexNumber'] = $propertyIndexNumber;
$this->tpl->set_var($tdValues);
$this->tpl->set_var("ctr", $tdCtr);
$this->tpl->parse("TDListBlock", "TDList", true);
$tdCtr++;
}
} else {
$this->tpl->set_var("TDListBlock", "");
}
$this->tpl->set_var("tdCtr", $tdCtr);
break;
default:
$this->formArray[$key] = $value;
}
}
}
}
$this->setForm();
$this->tpl->set_var("uname", $this->user["uname"]);
$this->tpl->set_var("today", date("F j, Y"));
$this->setPageDetailPerms();
$this->tpl->set_var(totBalance, number_format(abs($totalBalance), 2));
$this->tpl->set_var(amountDue, number_format(abs($totalValues['totTotal'] - un_number_format($totalValues['totPaidTotal'])), 2));
$totalValues['totAssessedValue'] = number_format($totalValues['totAssessedValue'], 2);
$totalValues['totBasic'] = number_format($totalValues['totBasic'], 2);
$totalValues['totPenalty'] = number_format($totalValues['totPenalty'], 2);
$totalValues['totSEF'] = number_format($totalValues['totSEF'], 2);
$totalValues['totTotal'] = number_format($totalValues['totTotal'], 2);
$totPaidalValues['totPaidBasic'] = number_format($totPaidalValues['totPaidBasic'], 2);
$totPaidalValues['totPaidPenalty'] = number_format($totPaidalValues['totPaidPenalty'], 2);
$totPaidalValues['totPaidSEF'] = number_format($totPaidalValues['totPaidSEF'], 2);
$totPaidalValues['totPaidTotal'] = number_format($totPaidalValues['totPaidTotal'], 2);
$this->tpl->set_var($totalValues);
$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()
{
$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);
}
function Main()
{
global $sess;
$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);
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 "taxableYear":
$this->tpl->set_var("taxableYear", $value);
$dueDate = $value;
break;
case "tdArray":
$this->tpl->set_block("rptsTemplate", "TDList", "TDListBlock");
$this->tpl->set_block("rptsTemplate", "JSTDList", "JSTDListBlock");
$this->tpl->set_block("rptsTemplate", "BacktaxTDTable", "BacktaxTDTableBlock");
$this->unpaidTDCount = 0;
if (count($value)) {
$this->tpl->set_block("rptsTemplate", "TDDBEmpty", "TDDBEmptyBlock");
$this->tpl->set_var("TDDBEmptyBlock", "");
foreach ($value as $tkey => $tvalue) {
$propertyType = $tvalue->getPropertyType();
$propertyID = $tvalue->getPropertyID();
$afsID = $tvalue->getAfsID();
$afs = new AFS();
$afs->selectRecord($afsID);
$listValues['propertyIndexNumber'] = $afs->getPropertyIndexNumber();
$assessedValue = $tvalue->getAssessedValue();
#echo("assessedValue=$assessedValue<br7>");
$listValues['taxBeginsWithTheYear'] = $tvalue->getTaxBeginsWithTheYear();
$listValues['tdNum'] = $tvalue->getTaxDeclarationNumber();
$tdID = $tvalue->getTdID();
$listValues['tdID'] = $tdID;
#echo("tdID=$tdID, dueDate=$dueDate<br>");
$dues = new Dues($tdID, $dueDate);
if (!$dues->create($tdID, $dueDate, $assessedValue)) {
$dues->setBasic($assessedValue);
$dues->setSEF($assessedValue);
# check if land is idle, if yes, set assessed value
# getIdleStatus -- temporary function
if ($dues->getIdleStatus() == 1) {
#echo("idle<br>");
$dues->setIdle($assessedValue);
}
}
// Refresh for amnesty and paymentPeriod
if ($this->formArray["formAction"] == "refresh") {
$amnesty = $this->formArray[amnesty];
$dues->setAmnesty($amnesty);
$paymentPeriod = $this->formArray[paymentPeriod];
$dues->setPaymentMode($paymentPeriod);
}
if ($dues->getAmnesty() == "Yes") {
$dues->resetPenalty();
$dues->computePenalty($paymentPeriod, "now");
}
$paymentPeriod = $dues->getPaymentMode();
$amnesty = $dues->getAmnesty();
$dues->store();
switch ($paymentPeriod) {
case 'Quarter':
$this->tpl->set_var("selectedQuarter", "selected");
$this->tpl->set_var("paymentPeriod", $paymentPeriod);
$this->tpl->set_var("installmentNumber", ceil(date("n") / 3));
$this->tpl->set_var("netDueFullAmount", number_format($dues->getTotalDue("Annual"), 2));
break;
default:
#Annual
$this->tpl->set_block("rptsTemplate", "QuarterNetDue", "QuarterNetDueBlock");
$this->tpl->set_var("QuarterNetDueBlock", "");
$this->tpl->set_var("selectedAnnual", "selected");
$this->tpl->set_var("paymentPeriod", $paymentPeriod);
break;
}
//$totalDue = $dues->getTotalDue($paymentPeriod);
$totalDue = $dues->getTotalDue($paymentPeriod);
$basic = $dues->getBasic($paymentPeriod);
$sef = $dues->getSEF($paymentPeriod);
$penalty = $dues->getPenalty($paymentPeriod);
$discount = $dues->getDiscount();
$totalPaid = $dues->getPaidBasic($paymentPeriod) + $dues->getPaidPenalty($paymentPeriod) + $dues->getPaidSEF($paymentPeriod);
$listValues['taxDue'] = $totalDue;
$listValues['basic'] = number_format($basic, 2);
$listValues['sef'] = number_format($sef, 2);
$listValues['penalty'] = number_format($penalty, 2);
$listValues['discount'] = number_format($discount, 2);
$listValues['totalPaid'] = number_format($totalPaid, 2);
$listValues['strTaxDue'] = number_format($totalDue, 2);
//$basic = $dues->getBasic($paymentPeriod);
#echo("basic=$basic<br>");
//$sef = $dues->getSEF($paymentPeriod);
#echo("sef=$sef<br>");
if (!$this->isPriorTDPaid($tdID)) {
$backtaxes = true;
$paidStatus = "<input type=\"checkbox\" name=\"tdID[" . $tdID . "]\" value=\"" . $tdID . "\" onclick=\"javascript: toggle(this, '" . $tdID . "'); updateTotalTaxDue(this," . $tdID . ");\" disabled>";
} else {
$backtaxes = false;
$paidStatus = $totalDue <= 0 ? $basic <= 0 ? "N.A." : "PAID" : "<input type=\"checkbox\" name=\"tdID[" . $tdID . "]\" value=\"" . $tdID . "\" onclick=\"javascript: toggle(this, '" . $tdID . "'); updateTotalTaxDue(this," . $tdID . ");\">";
}
$listValues['paidStatus'] = $paidStatus;
$listValues['tdBgcolor'] = '#f6f6f6';
$this->tpl->set_var($listValues);
$this->tpl->parse("TDListBlock", "TDList", true);
if ($backtaxes) {
$oldestUnpaidTD = $this->unpaidTDArray[count($this->unpaidTDArray) - 1];
$this->displayBacktaxTD($oldestUnpaidTD->getTdID());
$this->displayPriorTDs($tdID);
unset($this->unpaidTDArray);
} else {
$this->displayBacktaxTD($tdID);
$this->tpl->set_var("JSTDListBlock", "");
}
//$this->tpl->parse("BacktaxTDTableBlock", "BacktaxTDTable", true);
}
} else {
$this->tpl->set_block("rptsTemplate", "CheckAll", "CheckAllBlock");
$this->tpl->set_var("CheckAllBlock", "");
$this->tpl->set_var("TDListBlock", "");
}
$this->tpl->set_var("rptopID", $rptopID);
break;
default:
$this->formArray[$key] = $value;
}
}
}
}
$this->setForm();
$this->tpl->set_var("uname", $this->user["uname"]);
$this->tpl->set_var("today", date("F j, Y"));
$this->setPageDetailPerms();
$this->tpl->set_var(amnestyChecked, $amnesty == "Yes" ? " checked" : "");
$this->tpl->set_var("Session", $sess->url("") . $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");
}