function displayImprovementsBuildingsList($improvementsBuildingsList)
{
$this->tpl->set_block("rptsTemplate", "ImprovementsBuildingsDBEmpty", "ImprovementsBuildingsDBEmptyBlock");
$this->tpl->set_var("ImprovementsBuildingsDBEmptyBlock", "");
$this->tpl->set_block("rptsTemplate", "defaultImprovementsBuildingsList", "defaultImprovementsBuildingsListBlock");
$this->tpl->set_block("rptsTemplate", "toggleImprovementsBuildingsList", "toggleImprovementsBuildingsListBlock");
if (count($improvementsBuildingsList)) {
//$this->tpl->set_block("rptsTemplate", "hideImprovementsBuildingsList", "hideImprovementsBuildingsListBlock");
$this->tpl->set_block("rptsTemplate", "ImprovementsBuildingsList", "ImprovementsBuildingsListBlock");
$i = 0;
$totalMarketValue = 0;
$totalAssessedValue = 0;
foreach ($improvementsBuildingsList as $key => $value) {
$totalMarketValue += tofloat($value->getAdjustedMarketValue());
$totalAssessedValue += tofloat($value->getAssessedValue());
$this->displayDetails($value);
foreach ($value as $lkey => $lvalue) {
if (is_numeric($lvalue)) {
switch ($lkey) {
case "buildingClassification":
$improvementsBuildingsClasses = new ImprovementsBuildingsClasses();
$improvementsBuildingsClasses->selectRecord($lvalue);
$this->tpl->set_var("buildingClassification", $improvementsBuildingsClasses->getDescription());
break;
case "actualUse":
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
$improvementsBuildingsActualUses->selectRecord($lvalue);
$this->tpl->set_var("actualUse", $improvementsBuildingsActualUses->getDescription());
break;
}
}
}
$this->tpl->set_var("ctr", $i);
$this->tpl->parse("defaultImprovementsBuildingsListBlock", "defaultImprovementsBuildingsList", true);
$this->tpl->parse("toggleImprovementsBuildingsListBlock", "toggleImprovementsBuildingsList", true);
//$this->tpl->parse("hideImprovementsBuildingsListBlock", "hideImprovementsBuildingsList", true);
$this->setImprovementsBuildingsListBlockPerms();
$this->tpl->parse("ImprovementsBuildingsListBlock", "ImprovementsBuildingsList", true);
$i++;
}
$this->formArray["totalMarketValue"] += $totalMarketValue;
$this->formArray["totalAssessedValue"] += $totalAssessedValue;
$this->formArray["bldgTotalMarketValue"] = $totalMarketValue;
$this->formArray["bldgTotalAssessedValue"] = $totalAssessedValue;
$this->tpl->set_var("improvementsBuildingsCtr", $i);
} else {
$this->tpl->set_var("defaultImprovementsBuildingsListBlock", "");
$this->tpl->set_var("toggleImprovementsBuildingsListBlock", "");
}
}
function displayAssessedValues($landList, $plantsTreesList, $improvementsBuildingsList, $machineriesList)
{
$totalMarketValue = 0;
$totalAssessedValue = 0;
$totalArea = 0;
// RC 20091008
$nLandTotalAssessedValue = 0;
$nLandTotalAdjustedMarketValue = 0;
$nLandTotalArea = 0;
$nPlantsTotalAssessedValue = 0;
$nPlantsTotalAdjustedMarketValue = 0;
$nBuildingsTotalAssessedValue = 0;
$nBuildingsTotalAdjustedMarketValue = 0;
$nBuildingsTotalArea = 0;
// RC 20091008
$nMachineriesTotalAssessedValue = 0;
$nMachineriesTotalAdjustedMarketValue = 0;
$swornLandTotal = 0;
$swornImprovementTotal = 0;
$swornOverallTotal = 0;
$i = 1;
$flag = 0;
$counter = 0;
$summlvl = 0;
$summuse = "";
$summcla = "";
//RC 20091001 for summary total by Use & level
if (count($landList)) {
$this->formArray["kindIsLand"] = "X";
// RC 20091006
foreach ($landList as $key => $land) {
if ($i < 5) {
// classification
$landClasses = new LandClasses();
if (is_numeric($land->getClassification())) {
$landClasses->selectRecord($land->getClassification());
$landClassesDescription = $landClasses->getDescription();
$landClassesCode = $landClasses->getCode();
} else {
$landClassesDescription = $land->getClassification();
$landClassesCode = $land->getClassification();
}
// subClass
$landSubclasses = new LandSubclasses();
if (is_numeric($land->getSubClass())) {
$landSubclasses->selectRecord($land->getSubClass());
$landSubclassesDescription = $landSubclasses->getDescription();
$landSubclassesCode = $landSubclasses->getCode();
} else {
$landSubclassesDescription = $land->getSubClass();
$landSubclassesCode = $land->getSubClass();
}
// actualUse
$landActualUses = new LandActualUses();
if (is_numeric($land->getActualUse())) {
$landActualUses->selectRecord($land->getActualUse());
$landActualUsesDescription = $landActualUses->getDescription();
$landActualUsesCode = $landActualUses->getCode();
} else {
$landActualUsesDescription = $land->getActualUse();
$landActualUsesCode = $land->getActualUse();
}
// add pre new
if ($landActualUsesCode == "RE" || $landActualUsesCode == "COM" || $landActualUsesCode == "IND" || $landActualUsesCode == "MI" || $landActualUsesCode == "TI" || $landActualUsesCode == "SP") {
$tempname = $landActualUsesDescription;
$counter += 1;
}
// end of2 add
$totalMarketValue += toFloat($land->getAdjustedMarketValue());
$totalAssessedValue += toFloat($land->getAssessedValue());
$swornLandTotal += toFloat($land->getAdjustedMarketValue());
$swornOverallTotal += toFloat($land->getAdjustedMarketValue());
// display the summary of lands value
if ($counter > 0) {
$this->formArray["propertyActualUse" . $i] = $tempname;
} else {
$this->formArray["propertyActualUse" . $i] = "Agricultural";
}
//RC 20091001 To properly report summary by Actual Use and Level
$thislvl = $land->getAssessmentLevel();
$thisuse = $landActualUsesDescription;
if ($summuse == '') {
//RC first record
$summlvl = $thislvl;
$summuse = $thisuse;
$summcla = $landClassesDescription;
$nLandTotalArea = 0;
$nLandTotalAssessedValue = 0;
$nLandTotalAdjustedMarketValue = 0;
}
if ($summlvl != $thislvl || $summuse != $thisuse) {
//RC print if new assessment level or new actual use
$this->formArray["propertyKind" . $i] = "Land";
$this->formArray["classification" . $i] = $summcla;
$this->formArray["propertyActualUse" . $i] = $summuse;
$this->formArray["findingsTotalArea" . $i] = $nLandTotalArea;
$this->formArray["propertyMarketValue" . $i] = $nLandTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $summlvl . "%";
$this->formArray["propertyAssessedValue" . $i] = $nLandTotalAssessedValue;
$i++;
$nLandTotalAssessedValue = 0;
$nLandTotalAdjustedMarketValue = 0;
$nLandTotalArea = 0;
$summlvl = $thislvl;
$summuse = $thisuse;
$summcla = $landClassesDescription;
}
$nLandTotalAssessedValue += toFloat($land->getAssessedValue());
$nLandTotalAdjustedMarketValue += toFloat($land->getAdjustedMarketValue());
$nLandTotalArea += toFloat($land->getArea());
}
}
$this->formArray["propertyKind" . $i] = "Land";
$this->formArray["classification" . $i] = $summcla;
$this->formArray["propertyActualUse" . $i] = $summuse;
$this->formArray["findingsTotalArea" . $i] = $nLandTotalArea;
$this->formArray["propertyMarketValue" . $i] = $nLandTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $summlvl . "%";
$this->formArray["propertyAssessedValue" . $i] = $nLandTotalAssessedValue;
$i++;
// end of summary of lands
}
if (count($plantsTreesList)) {
$this->formArray["kindIsOthers"] = "X";
// RC 20091006
foreach ($plantsTreesList as $key => $plantsTrees) {
if ($i < 5) {
// productClass
$plantsTreesClasses = new PlantsTreesClasses();
if (is_numeric($plantsTrees->getProductClass())) {
$plantsTreesClasses->selectRecord($plantsTrees->getProductClass());
$plantsTreesClassesDescription = $plantsTreesClasses->getDescription();
$plantsTreesClassesCode = $plantsTreesClasses->getCode();
} else {
$plantsTreesClassesDescription = $plantsTrees->getProductClass();
$plantsTreesClassesCode = $plantsTrees->getProductClass();
}
// actualUse
$plantsTreesActualUses = new PlantsTreesActualUses();
if (is_numeric($plantsTrees->getActualUse())) {
$plantsTreesActualUses->selectRecord($plantsTrees->getActualUse());
$plantsTreesActualUsesDescription = $plantsTreesActualUses->getDescription();
$plantsTreesActualUsesCode = $plantsTreesActualUses->getCode();
} else {
$plantsTreesActualUsesDescription = $plantsTrees->getActualUse();
$plantsTreesActualUsesCode = $plantsTrees->getActualUse();
}
//$this->formArray["propertyKind".($i+1)] = "PlantsTrees";
//$this->formArray["propertyActualUse".($i+1)] =$plantsTreesActualUsesDescription;
//$this->formArray["propertyMarketValue".($i+1)] =$plantsTrees->getAdjustedMarketValue();
//$this->formArray["propertyAssessmentLevel".($i+1)] = $plantsTrees->getAssessmentLevel();
//$this->formArray["propertyAssessedValue".($i+1)] = $plantsTrees->getAssessedValue();
$totalMarketValue += toFloat($plantsTrees->getAdjustedMarketValue());
$totalAssessedValue += toFloat($plantsTrees->getAssessedValue());
$nPlantsTotalAssessedValue += toFloat($plantsTrees->getAssessedValue());
$nPlantsTotalAdjustedMarketValue += toFloat($plantsTrees->getAdjustedMarketValue());
$swornLandTotal += toFloat($plantsTrees->getAdjustedMarketValue());
$swornOverallTotal += toFloat($plantsTrees->getAdjustedMarketValue());
//$i++;
}
}
$this->formArray["propertyKind" . $i] = "PlantTrees";
//inserted May 31, 2008
$this->formArray["classification" . $i] = $plantsTreesClassesDescription;
$this->formArray["propertyActualUse" . $i] = $plantsTreesActualUsesDescription;
$this->formArray["propertyMarketValue" . $i] = $nPlantsTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $plantsTrees->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . $i] = $nPlantsTotalAssessedValue;
$i++;
// additional new line for total of LAND AND PLANT TREES
// $nSwornLandTotal =$nPlantsTotalAdjustedMarketValue + $nLandTotalAdjustedMarketValue;
// $this->formArray["swornLandTotal"] =$nSwornLandTotal; //number_format($nSwornLandTotal,2);
// END
}
if (count($improvementsBuildingsList)) {
$this->formArray["kindIsBuilding"] = "X";
// RC 20091006
// $this->formArray["numberOfStoreys"] = $improvementsBuildings->getNumberOfStoreys();
$nBuildingTotalArea = 0;
$nBuildingTotalAssessedValue = 0;
$nBuildingTotalAdjustedMarketValue = 0;
foreach ($improvementsBuildingsList as $key => $improvementsBuildings) {
if ($i < 5) {
// buildingClassification
$improvementsBuildingsClasses = new ImprovementsBuildingsClasses();
if (is_numeric($improvementsBuildings->getBuildingClassification())) {
$improvementsBuildingsClasses->selectRecord($improvementsBuildings->getBuildingClassification());
$improvementsBuildingsClassesDescription = $improvementsBuildingsClasses->getDescription();
$improvementsBuildingsClassesCode = $improvementsBuildingsClasses->getCode();
} else {
$improvementsBuildingsClassesDescription = $improvementsBuildings->getBuildingClassification();
$improvementsBuildingsClassesCode = $improvementsBuildings->getBuildingClassification();
}
// actualUse
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
if (is_numeric($improvementsBuildings->getActualUse())) {
$improvementsBuildingsActualUses->selectRecord($improvementsBuildings->getActualUse());
$improvementsBuildingsActualUsesDescription = $improvementsBuildingsActualUses->getDescription();
$improvementsBuildingsActualUsesCode = $improvementsBuildingsActualUses->getCode();
} else {
$improvementsBuildingsActualUsesDescription = $improvementsBuildings->getActualUse();
$improvementsBuildingsActualUsesCode = $improvementsBuildings->getActualUse();
}
$totalMarketValue += toFloat($improvementsBuildings->getAdjustedMarketValue());
$totalAssessedValue += toFloat($improvementsBuildings->getAssessedValue());
$totalArea += $improvementsBuildings->getTotalBuildingArea();
// RC 20091008
$thislvl = $improvementsBuildings->getAssessmentLevel();
$thisuse = $improvementsBuildingsActualUsesDescription;
if ($summuse == '') {
//RC first record
$summlvl = $thislvl;
$summuse = $thisuse;
$summcla = $improvementsBuildingsClassesDescription;
}
if ($summlvl != $thislvl || $summuse != $thisuse) {
//RC print if new assessment level or new actual use
$this->formArray["propertyKind" . $i] = "Land";
$this->formArray["classification" . $i] = $summcla;
$this->formArray["propertyActualUse" . $i] = $summuse;
$this->formArray["findingsTotalArea" . $i] = $nBuildingTotalArea;
$this->formArray["propertyMarketValue" . $i] = $nBuildingTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $summlvl . "%";
$this->formArray["propertyAssessedValue" . $i] = $nBuildingTotalAssessedValue;
$i++;
$nBuildingTotalAssessedValue = 0;
$nBuildingTotalAdjustedMarketValue = 0;
$nBuildingTotalArea = 0;
$summlvl = $thislvl;
$summuse = $thisuse;
$summcla = $improvementsBuildingsClassesDescription;
}
$nBuildingTotalAssessedValue += toFloat($improvementsBuildings->getAssessedValue());
$nBuildingTotalAdjustedMarketValue += toFloat($improvementsBuildings->getAdjustedMarketValue());
$nBuildingTotalArea += toFloat($improvementsBuildings->getTotalBuildingArea());
$swornImprovementTotal += toFloat($improvementsBuildings->getAdjustedMarketValue());
$swornOverallTotal += toFloat($improvementsBuildings->getAdjustedMarketValue());
}
}
$this->formArray["propertyKind" . $i] = "ImprovementsBuildings";
$this->formArray["classification" . $i] = $improvementsBuildingsClassesDescription;
$this->formArray["propertyActualUse" . $i] = $improvementsBuildingsActualUsesDescription;
$this->formArray["findingsTotalArea" . $i] = $nBuildingTotalArea;
$this->formArray["propertyMarketValue" . $i] = $nBuildingTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $improvementsBuildings->getAssessmentLevel() . "%";
$this->formArray["propertyAssessedValue" . $i] = $nBuildingTotalAssessedValue;
$i++;
$this->formArray["findingsTotalArea"] = $totalArea;
//RC 20091008
}
if (count($machineriesList)) {
$this->formArray["kindIsMachinery"] = "X";
// RC 20091006
foreach ($machineriesList as $key => $machineries) {
if ($i < 5) {
// kind
$machineriesClasses = new MachineriesClasses();
if (is_numeric($machineries->getKind())) {
$machineriesClasses->selectRecord($machineries->getKind());
$machineriesClassesDescription = $machineriesClasses->getDescription();
$machineriesClassesCode = $machineriesClasses->getCode();
} else {
$machineriesClassesDescription = $machineries->getKind();
$machineriesClassesCode = $machineries->getActualUse();
}
// actualUse
$machineriesActualUses = new MachineriesActualUses();
if (is_numeric($machineries->getActualUse())) {
$machineriesActualUses->selectRecord($machineries->getActualUse());
$machineriesActualUsesDescription = $machineriesActualUses->getDescription();
$machineriesActualUsesCode = $machineriesActualUses->getCode();
} else {
$machineriesActualUsesDescription = $machineries->getActualUse();
$machineriesActualUsesCode = $machineries->getActualUse();
}
$totalMarketValue += toFloat($machineries->getAdjustedMarketValue());
$totalAssessedValue += toFloat($machineries->getAssessedValue());
$nMachineriesTotalAssessedValue += toFloat($machineries->getAssessedValue());
$nMachineriesTotalAdjustedMarketValue += toFloat($machineries->getAdjustedMarketValue());
$swornImprovementTotal += toFloat($machineries->getAdjustedMarketValue());
$swornOverallTotal += toFloat($machineries->getAdjustedMarketValue());
// $i++;
}
}
$this->formArray["propertyKind" . $i] = "Machineries";
$this->formArray["classification" . $i] = $machineriesClassesDescription;
$this->formArray["propertyActualUse" . $i] = $machineriesActualUsesDescription;
$this->formArray["propertyMarketValue" . $i] = $nMachineriesTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $machineries->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . $i] = $nMachineriesTotalAssessedValue;
$i++;
}
// add pre hehe for sworn statement total and machineries
$this->formArray["swornLandTotal"] = $swornLandTotal;
$this->formArray["swornImprovementTotal"] = $swornImprovementTotal;
$this->formArray["swornOverallTotal"] = $swornOverallTotal;
// $nSwornImprovementTotal =$nMachineriesTotalAdjustedMarketValue + $nBuildingsTotalAdjustedMarketValue;
// $this->formArray["swornImprovementTotal"] =$nSwornImprovementTotal;
// $nSwornOverallTotal =$nSwornImprovementTotal + $nSwornLandTotal;
// $this->formArray["swornOverallTotal"] =$nSwornOverallTotal;
// end
$this->formArray["totalMarketValue"] = $totalMarketValue;
$this->formArray["totalAssessedValue"] = $totalAssessedValue;
$this->formArray["totalAssessedValueInWords"] = makewords($totalAssessedValue);
}
function displayImprovementsBuildingsList($improvementsBuildingsList)
{
if (count($improvementsBuildingsList)) {
$i = 0;
foreach ($improvementsBuildingsList as $key => $improvementsBuildings) {
if ($i == 0) {
//$this->formArray["arpNumber"] = $improvementsBuildings->getArpNumber();
//$this->formArray["propertyIndexNumber"] = $improvementsBuildings->getPropertyIndexNumber();
$this->formArray["landPIN"] = $improvementsBuildings->getLandPIN();
$this->displayLandPINDetails();
$this->formArray["foundation"] = $improvementsBuildings->getFoundation();
$this->formArray["windows"] = $improvementsBuildings->getWindows();
$this->formArray["columns"] = $improvementsBuildings->getColumnsBldg();
$this->formArray["stairs"] = $improvementsBuildings->getStairs();
$this->formArray["beams"] = $improvementsBuildings->getBeams();
$this->formArray["partition"] = $improvementsBuildings->getPartition();
$this->formArray["trussFraming"] = $improvementsBuildings->getTrussFraming();
$this->formArray["wallFinish"] = $improvementsBuildings->getWallFinish();
$this->formArray["roof"] = $improvementsBuildings->getRoof();
$this->formArray["electrical"] = $improvementsBuildings->getElectrical();
$this->formArray["exteriorWalls"] = $improvementsBuildings->getExteriorWalls();
$this->formArray["toiletAndBath"] = $improvementsBuildings->getToiletAndBath();
$this->formArray["flooring"] = $improvementsBuildings->getFlooring();
$this->formArray["plumbingSewer"] = $improvementsBuildings->getPlumbingSewer();
$this->formArray["doors"] = $improvementsBuildings->getDoors();
$this->formArray["fixtures"] = $improvementsBuildings->getFixtures();
$this->formArray["ceiling"] = $improvementsBuildings->getCeiling();
$this->formArray["dateConstructed"] = $improvementsBuildings->getDateConstructed();
$this->formArray["structuralTypes"] = $improvementsBuildings->getStructuralTypes();
$this->formArray["dateOccupied"] = $improvementsBuildings->getDateOccupied();
$this->formArray["memoranda"] = $improvementsBuildings->getMemoranda();
// buildingClassification
$improvementsBuildingsClasses = new ImprovementsBuildingsClasses();
if (is_numeric($improvementsBuildings->getBuildingClassification())) {
$improvementsBuildingsClasses->selectRecord($improvementsBuildings->getBuildingClassification());
$this->formArray["classification"] = $improvementsBuildingsClasses->getDescription();
} else {
$this->formArray["classification"] = $improvementsBuildings->getBuildingClassification();
}
$this->formArray["dateCompleted"] = $improvementsBuildings->getDateCompleted();
$this->formArray["bldgPermit"] = $improvementsBuildings->getBuildingPermit();
$this->formArray["areaOfGroundFloor"] = $improvementsBuildings->getAreaOfGroundFloor();
$this->formArray["buildingAge"] = $improvementsBuildings->getBuildingAge();
$this->formArray["totalBuildingArea"] = $improvementsBuildings->getTotalBuildingArea();
$this->formArray["numberOfStoreys"] = $improvementsBuildings->getNumberOfStoreys();
$this->formArray["cctNumber"] = $improvementsBuildings->getCctNumber();
// NCC Modification checked and implemented by K2 : November 18, 2005
// details:
// commented out line 448, changed lines 451 to 455
//$this->formArray["bldgCore1"] = $improvementsBuildings->getBuildingCoreAndAdditionalItems();
$this->formArray["bldgCore1"] = number_format($improvementsBuildings->getUnitValue(), 2);
$this->formArray["depMarketValue"] = $improvementsBuildings->getDepreciatedMarketValue();
$this->formArray["marketValue"] = number_format($improvementsBuildings->getMarketValue(), 2);
$this->formArray["addItems"] = number_format($improvementsBuildings->getAddItems(), 2);
$this->formArray["subTotal"] = "";
$this->formArray["adjustments"] = number_format($improvementsBuildings->getMarketValue() + $improvementsBuildings->getAddItems(), 2);
$this->formArray["depreciationRate"] = $improvementsBuildings->getDepreciationRate();
$this->formArray["subTotal2"] = "";
$this->formArray["depreciationRate"] = $improvementsBuildings->getDepreciationRate();
$this->formArray["accumulatedDepreciation"] = $improvementsBuildings->getAccumulatedDepreciation();
if (is_a($improvementsBuildings->propertyAdministrator, Person)) {
if ($improvementsBuildings->propertyAdministrator->getLastName() != "") {
$this->formArray["administrator"] = $improvementsBuildings->propertyAdministrator->getFullName();
}
if (is_a($improvementsBuildings->propertyAdministrator->addressArray[0], "address")) {
$address1 = $improvementsBuildings->propertyAdministrator->addressArray[0]->getNumber();
if ($address1 != "") {
$address1 .= " ";
}
$address1 .= $improvementsBuildings->propertyAdministrator->addressArray[0]->getStreet();
if ($address1 != "") {
$address1 .= ", ";
}
$address1 .= $improvementsBuildings->propertyAdministrator->addressArray[0]->getBarangay();
$address2 = $improvementsBuildings->propertyAdministrator->addressArray[0]->getDistrict();
if ($address2 != "") {
$address2 .= ", ";
}
$address2 .= $improvementsBuildings->propertyAdministrator->addressArray[0]->getMunicipalityCity();
if ($address2 != "") {
$address2 .= ", ";
}
$address2 .= $improvementsBuildings->propertyAdministrator->addressArray[0]->getProvince();
$this->formArray["adminAddress1"] = $address1;
$this->formArray["adminAddress2"] = $address2;
}
$this->formArray["adminTelno"] = $improvementsBuildings->propertyAdministrator->getTelephone();
}
// recommendingApproval
if (is_numeric($improvementsBuildings->recommendingApproval)) {
$recommendingApproval = new Person();
$recommendingApproval->selectRecord($improvementsBuildings->recommendingApproval);
$this->formArray["recommendingApproval"] = $recommendingApproval->getFullName();
$this->recommendingApproval = $recommendingApproval->getFullName();
} else {
$recommendingApproval = $improvementsBuildings->recommendingApproval;
$this->formArray["recommendingApproval"] = $recommendingApproval;
$this->recommendingApproval = $recommendingApproval;
}
$this->formArray["dateRecommendingApproval"] = $improvementsBuildings->getRecommendingApprovalDate();
// approvedBy
if (is_numeric($improvementsBuildings->approvedBy)) {
$approvedBy = new Person();
$approvedBy->selectRecord($improvementsBuildings->approvedBy);
$this->formArray["approvedBy"] = $approvedBy->getFullName();
$this->approvedBy = $approvedBy->getFullName();
} else {
$approvedBy = $improvementsBuildings->approvedBy;
$this->formArray["approvedBy"] = $approvedBy;
$this->approvedBy = $approvedBy;
}
$this->formArray["dateApprovedBy"] = $improvementsBuildings->getApprovedByDate();
// appraisedBy (assessedBy)
if (is_numeric($improvementsBuildings->appraisedBy)) {
$appraisedBy = new Person();
$appraisedBy->selectRecord($improvementsBuildings->appraisedBy);
$this->formArray["assessedBy"] = $appraisedBy->getFullName();
$this->appraisedBy = $appraisedBy->getFullName();
} else {
$appraisedBy = $improvementsBuildings->appraisedBy;
$this->formArray["assessedBy"] = $appraisedBy;
$this->appraisedBy = $appraisedBy;
}
$this->formArray["dateAssessedBy"] = $improvementsBuildings->getAppraisedByDate();
}
if ($i < 4) {
$this->formArray["kind" . ($i + 1)] = $improvementsBuildings->getKind();
// actualUse
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
if (is_numeric($improvementsBuildings->getActualUse())) {
$improvementsBuildingsActualUses->selectRecord($improvementsBuildings->getActualUse());
$this->formArray["actualUse" . ($i + 1)] = $improvementsBuildingsActualUses->getDescription();
} else {
$this->formArray["actualUse" . ($i + 1)] = $improvementsBuildings->getActualUse();
}
// NCC Modification checked and implemented by K2 : November 18, 2005
// details:
// commented out line 557, added line 558, changed "marketValue" to "depMarketValue"
//$this->formArray["marketValue".($i+1)] = $improvementsBuildings->getMarketValue();
$this->formArray["depMarketValue" . ($i + 1)] = $improvementsBuildings->getDepreciatedMarketValue();
$this->formArray["assessmentLevel" . ($i + 1)] = $improvementsBuildings->getAssessmentLevel();
$this->formArray["assessedValue" . ($i + 1)] = $improvementsBuildings->getAssessedValue();
$this->formArray["total"] += toFloat($this->formArray["assessedValue" . ($i + 1)]);
}
$i++;
}
// NCC Modification checked and implemented by K2 : November 18, 2005
// details:
// added for() loop in lines 572 to 578 that resets values to:
// "kind, actualUse, depMarketValue, assessmentLevel" and "assessedValue"
for ($j = $i; $j < 4; $j++) {
$this->formArray["kind" . ($j + 1)] = '';
$this->formArray["actualUse" . ($j + 1)] = '';
$this->formArray["depMarketValue" . ($j + 1)] = '';
$this->formArray["assessmentLevel" . ($j + 1)] = '';
$this->formArray["assessedValue" . ($j + 1)] = '';
}
}
$this->formArray["valAdjFacTotal"] = $valAdjFacTotal;
$this->formArray["propertyAdjMrktValTotal"] = $propertyAdjMrktValTotal;
$this->formArray["propertyTotal"] = $propertyTotal;
}
function displayAssessedValues($landList, $plantsTreesList, $improvementsBuildingsList, $machineriesList)
{
$totalMarketValue = 0;
$totalAssessedValue = 0;
$nLandTotalAssessedValue = 0;
$nLandTotalAdjustedMarketValue = 0;
$nPlantsTotalAssessedValue = 0;
$nPlantsTotalAdjustedMarketValue = 0;
$nBuildingsTotalAssessedValue = 0;
$nBuildingsTotalAdjustedMarketValue = 0;
$nMachineriesTotalAssessedValue = 0;
$nMachineriesTotalAdjustedMarketValue = 0;
$swornLandTotal = 0;
$swornImprovementTotal = 0;
$swornOverallTotal = 0;
$i = 1;
$flag = 0;
$counter = 0;
if (count($landList)) {
foreach ($landList as $key => $land) {
if ($i < 5) {
// classification
$landClasses = new LandClasses();
if (is_numeric($land->getClassification())) {
$landClasses->selectRecord($land->getClassification());
$landClassesDescription = $landClasses->getDescription();
$landClassesCode = $landClasses->getCode();
} else {
$landClassesDescription = $land->getClassification();
$landClassesCode = $land->getClassification();
}
// subClass
$landSubclasses = new LandSubclasses();
if (is_numeric($land->getSubClass())) {
$landSubclasses->selectRecord($land->getSubClass());
$landSubclassesDescription = $landSubclasses->getDescription();
$landSubclassesCode = $landSubclasses->getCode();
} else {
$landSubclassesDescription = $land->getSubClass();
$landSubclassesCode = $land->getSubClass();
}
// actualUse
$landActualUses = new LandActualUses();
if (is_numeric($land->getActualUse())) {
$landActualUses->selectRecord($land->getActualUse());
$landActualUsesDescription = $landActualUses->getDescription();
$landActualUsesCode = $landActualUses->getCode();
} else {
$landActualUsesDescription = $land->getActualUse();
$landActualUsesCode = $land->getActualUse();
}
// add pre new hehe
if ($landActualUsesCode == "RES" || $landActualUsesCode == "COM" || $landActualUsesCode == "IND" || $landActualUsesCode == "MI" || $landActualUsesCode == "TI" || $landActualUsesCode == "SP") {
$tempname = $landActualUsesDescription;
$counter += 1;
}
// end of add hehe
$totalMarketValue += toFloat($land->getAdjustedMarketValue());
$totalAssessedValue += toFloat($land->getAssessedValue());
$nLandTotalAssessedValue += toFloat($land->getAssessedValue());
$nLandTotalAdjustedMarketValue += toFloat($land->getAdjustedMarketValue());
$swornLandTotal += toFloat($land->getAdjustedMarketValue());
$swornOverallTotal += toFloat($land->getAdjustedMarketValue());
// $this->formArray["propertyKind".($i)] = "Land";
// $this->formArray["propertyActualUse".($i)] = $landActualUsesDescription;
// $this->formArray["propertyMarketValue".($i)] = $land->getAdjustedMarketValue();
// $this->formArray["propertyAssessmentLevel".($i)] = $land->getAssessmentLevel();
// $this->formArray["propertyAssessedValue".($i)] = $land->getAssessedValue();
// $totalMarketValue+=toFloat($land->getAdjustedMarketValue());
// $totalAssessedValue+=toFloat($land->getAssessedValue());
//$i++;
}
}
//}
// display the summary of lands value
if ($counter > 0) {
$this->formArray["propertyActualUse" . $i] = $tempname;
} else {
$this->formArray["propertyActualUse" . $i] = "Agricultural";
}
$this->formArray["propertyKind" . $i] = "Land";
// $this->formArray["propertyActualUse".($i)] = "Agricultural";
$this->formArray["propertyMarketValue" . $i] = $nLandTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $land->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . $i] = $nLandTotalAssessedValue;
$i++;
// end of summary of lands
}
if (count($plantsTreesList)) {
foreach ($plantsTreesList as $key => $plantsTrees) {
if ($i < 5) {
// productClass
$plantsTreesClasses = new PlantsTreesClasses();
if (is_numeric($plantsTrees->getProductClass())) {
$plantsTreesClasses->selectRecord($plantsTrees->getProductClass());
$plantsTreesClassesDescription = $plantsTreesClasses->getDescription();
$plantsTreesClassesCode = $plantsTreesClasses->getCode();
} else {
$plantsTreesClassesDescription = $plantsTrees->getProductClass();
$plantsTreesClassesCode = $plantsTrees->getProductClass();
}
// actualUse
$plantsTreesActualUses = new PlantsTreesActualUses();
if (is_numeric($plantsTrees->getActualUse())) {
$plantsTreesActualUses->selectRecord($plantsTrees->getActualUse());
$plantsTreesActualUsesDescription = $plantsTreesActualUses->getDescription();
$plantsTreesActualUsesCode = $plantsTreesActualUses->getCode();
} else {
$plantsTreesActualUsesDescription = $plantsTrees->getActualUse();
$plantsTreesActualUsesCode = $plantsTrees->getActualUse();
}
//$this->formArray["propertyKind".($i+1)] = "PlantsTrees";
//$this->formArray["propertyActualUse".($i+1)] =$plantsTreesActualUsesDescription;
//$this->formArray["propertyMarketValue".($i+1)] =$plantsTrees->getAdjustedMarketValue();
//$this->formArray["propertyAssessmentLevel".($i+1)] = $plantsTrees->getAssessmentLevel();
//$this->formArray["propertyAssessedValue".($i+1)] = $plantsTrees->getAssessedValue();
$totalMarketValue += toFloat($plantsTrees->getAdjustedMarketValue());
$totalAssessedValue += toFloat($plantsTrees->getAssessedValue());
$nPlantsTotalAssessedValue += toFloat($plantsTrees->getAssessedValue());
$nPlantsTotalAdjustedMarketValue += toFloat($plantsTrees->getAdjustedMarketValue());
$swornLandTotal += toFloat($plantsTrees->getAdjustedMarketValue());
$swornOverallTotal += toFloat($plantsTrees->getAdjustedMarketValue());
//$i++;
}
}
$this->formArray["propertyKind" . $i] = "PlantTrees";
$this->formArray["propertyActualUse" . $i] = $plantsTreesActualUsesDescription;
$this->formArray["propertyMarketValue" . $i] = $nPlantsTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $plantsTrees->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . $i] = $nPlantsTotalAssessedValue;
$i++;
// additional new line for total of LAND AND PLANT TREES
// $nSwornLandTotal =$nPlantsTotalAdjustedMarketValue + $nLandTotalAdjustedMarketValue;
// $this->formArray["swornLandTotal"] =$nSwornLandTotal; //number_format($nSwornLandTotal,2);
// END
}
if (count($improvementsBuildingsList)) {
foreach ($improvementsBuildingsList as $key => $improvementsBuildings) {
if ($i < 5) {
// buildingClassification
$improvementsBuildingsClasses = new ImprovementsBuildingsClasses();
if (is_numeric($improvementsBuildings->getBuildingClassification())) {
$improvementsBuildingsClasses->selectRecord($improvementsBuildings->getBuildingClassification());
$improvementsBuildingsClassesDescription = $improvementsBuildingsClasses->getDescription();
$improvementsBuildingsClassesCode = $improvementsBuildingsClasses->getCode();
} else {
$improvementsBuildingsClassesDescription = $improvementsBuildings->getBuildingClassification();
$improvementsBuildingsClassesCode = $improvementsBuildings->getBuildingClassification();
}
// actualUse
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
if (is_numeric($improvementsBuildings->getActualUse())) {
$improvementsBuildingsActualUses->selectRecord($improvementsBuildings->getActualUse());
$improvementsBuildingsActualUsesDescription = $improvementsBuildingsActualUses->getDescription();
$improvementsBuildingsActualUsesCode = $improvementsBuildingsActualUses->getCode();
} else {
$improvementsBuildingsActualUsesDescription = $improvementsBuildings->getActualUse();
$improvementsBuildingsActualUsesCode = $improvementsBuildings->getActualUse();
}
//$this->formArray["propertyKind".($i+1)] = "ImprovementsBuildings";
//$this->formArray["propertyActualUse".($i+1)] = $improvementsBuildingsActualUsesDescription;
//$this->formArray["propertyMarketValue".($i+1)] = $improvementsBuildings->getAdjustedMarketValue();
//$this->formArray["propertyAssessmentLevel".($i+1)] = $improvementsBuildings->getAssessmentLevel();
//$this->formArray["propertyAssessedValue".($i+1)] = $improvementsBuildings->getAssessedValue();
$totalMarketValue += toFloat($improvementsBuildings->getAdjustedMarketValue());
$totalAssessedValue += toFloat($improvementsBuildings->getAssessedValue());
$nBuildingsTotalAssessedValue += toFloat($improvementsBuildings->getAssessedValue());
$nBuildingsTotalAdjustedMarketValue += toFloat($improvementsBuildings->getAdjustedMarketValue());
$swornImprovementTotal += toFloat($improvementsBuildings->getAdjustedMarketValue());
$swornOverallTotal += toFloat($improvementsBuildings->getAdjustedMarketValue());
// $i++;
}
}
$this->formArray["propertyKind" . $i] = "ImprovementsBuildings";
$this->formArray["propertyActualUse" . $i] = $improvementsBuildingsActualUsesDescription;
$this->formArray["propertyMarketValue" . $i] = $nBuildingsTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $improvementsBuildings->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . $i] = $nBuildingsTotalAssessedValue;
$i++;
}
if (count($machineriesList)) {
foreach ($machineriesList as $key => $machineries) {
if ($i < 5) {
// kind
$machineriesClasses = new MachineriesClasses();
if (is_numeric($machineries->getKind())) {
$machineriesClasses->selectRecord($machineries->getKind());
$machineriesClassesDescription = $machineriesClasses->getDescription();
$machineriesClassesCode = $machineriesClasses->getCode();
} else {
$machineriesClassesDescription = $machineries->getKind();
$machineriesClassesCode = $machineries->getActualUse();
}
// actualUse
$machineriesActualUses = new MachineriesActualUses();
if (is_numeric($machineries->getActualUse())) {
$machineriesActualUses->selectRecord($machineries->getActualUse());
$machineriesActualUsesDescription = $machineriesActualUses->getDescription();
$machineriesActualUsesCode = $machineriesActualUses->getCode();
} else {
$machineriesActualUsesDescription = $machineries->getActualUse();
$machineriesActualUsesCode = $machineries->getActualUse();
}
//$this->formArray["propertyKind".($i+1)] = "Machineries";
//$this->formArray["propertyActualUse".($i+1)] = $machineriesActualUsesDescription;
//$this->formArray["propertyMarketValue".($i+1)] = $machineries->getAdjustedMarketValue();
//$this->formArray["propertyAssessmentLevel".($i+1)] = $machineries->getAssessmentLevel();
//$this->formArray["propertyAssessedValue".($i+1)] = $machineries->getAssessedValue();
$totalMarketValue += toFloat($machineries->getAdjustedMarketValue());
$totalAssessedValue += toFloat($machineries->getAssessedValue());
$nMachineriesTotalAssessedValue += toFloat($machineries->getAssessedValue());
$nMachineriesTotalAdjustedMarketValue += toFloat($machineries->getAdjustedMarketValue());
$swornImprovementTotal += toFloat($machineries->getAdjustedMarketValue());
$swornOverallTotal += toFloat($machineries->getAdjustedMarketValue());
// $i++;
}
}
$this->formArray["propertyKind" . $i] = "Machineries";
$this->formArray["propertyActualUse" . $i] = $machineriesActualUsesDescription;
$this->formArray["propertyMarketValue" . $i] = $nMachineriesTotalAdjustedMarketValue;
$this->formArray["propertyAssessmentLevel" . $i] = $machineries->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . $i] = $nMachineriesTotalAssessedValue;
$i++;
}
// add pre hehe for sworn statement total and machineries
$this->formArray["swornLandTotal"] = $swornLandTotal;
$this->formArray["swornImprovementTotal"] = $swornImprovementTotal;
$this->formArray["swornOverallTotal"] = $swornOverallTotal;
// $nSwornImprovementTotal =$nMachineriesTotalAdjustedMarketValue + $nBuildingsTotalAdjustedMarketValue;
// $this->formArray["swornImprovementTotal"] =$nSwornImprovementTotal;
$grandTotalArea = $findingsTotalArea + $bfindingsFloorArea;
// $this->formArray["swornOverallTotal"] =$nSwornOverallTotal;
// end
$this->formArray["totalMarketValue"] = $totalMarketValue;
$this->formArray["totalAssessedValue"] = $totalAssessedValue;
$this->formArray["totalAssessedValueInWords"] = makewords($totalAssessedValue);
}
function displayImprovementsBuildingsList($improvementsBuildingsList)
{
if (count($improvementsBuildingsList)) {
$improvementsBuildings = $improvementsBuildingsList[0];
$this->tpl->set_var("improvementsBuildings[propertyID]", $this->htmlProperty("propertyID", $improvementsBuildings->getPropertyID()));
$this->tpl->set_var("improvementsBuildings[foundation]", $this->htmlProperty("foundation", $improvementsBuildings->getFoundation()));
$this->tpl->set_var("improvementsBuildings[columnsBldg]", $this->htmlProperty("columnsBldg", $improvementsBuildings->getColumnsBldg()));
$this->tpl->set_var("improvementsBuildings[beams]", $this->htmlProperty("beams", $improvementsBuildings->getBeams()));
$this->tpl->set_var("improvementsBuildings[trussFraming]", $this->htmlProperty("trussFraming", $improvementsBuildings->getTrussFraming()));
$this->tpl->set_var("improvementsBuildings[roof]", $this->htmlProperty("roof", $improvementsBuildings->getRoof()));
$this->tpl->set_var("{improvementsBuildings[kind]", $this->htmlProperty("kind", $improvementsBuildings->getKind()));
foreach ($improvementsBuildings as $ikey => $ivalue) {
if (is_numeric($ivalue)) {
switch ($ikey) {
case "buildingClassification":
$improvementsBuildingsClasses = new ImprovementsBuildingsClasses();
$improvementsBuildingsClasses->selectRecord($ivalue);
$this->tpl->set_var("improvementsBuildings[buildingClassification]", $this->htmlProperty("buildingClassification", $improvementsBuildingsClasses->getDescription()));
break;
case "actualUse":
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
$improvementsBuildingsActualUses->selectRecord($ivalue);
$this->tpl->set_var("improvementsBuildings[actualUse]", $this->htmlProperty("actualUse", $improvementsBuildingsActualUses->getDescription()));
break;
}
}
}
}
}
function getImprovementsBuildingsActualUsesText($improvementsBuildingsActualUsesID)
{
$ImprovementsBuildingsActualUsesDetails = new SoapObject(NCCBIZ . "ImprovementsBuildingsActualUsesDetails.php", "urn:Object");
if (!($xmlStr = $ImprovementsBuildingsActualUsesDetails->getImprovementsBuildingsActualUsesDetails($improvementsBuildingsActualUsesID))) {
return $improvementsBuildingsActualUsesID . "xx";
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
return $improvementsBuildingsActualUsesID . "yy";
} else {
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
$improvementsBuildingsActualUses->parseDomDocument($domDoc);
return $improvementsBuildingsActualUses->getDescription();
}
}
}
function displayImprovementsBuildings($improvementsBuildings)
{
if ($improvementsBuildings) {
$this->displayDetails($improvementsBuildings);
foreach ($improvementsBuildings as $ikey => $ivalue) {
if (is_numeric($pvalue)) {
switch ($ikey) {
case "buildingClassification":
$improvementsBuildingsClasses = new ImprovementsBuildingsClasses();
$improvementsBuildingsClasses->selectRecord($ivalue);
$this->tpl->set_var("buildingClassification", $improvementsBuildingsClasses->getDescription());
break;
case "actualUse":
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
$improvementsBuildingsActualUses->selectRecord($ivalue);
$this->tpl->set_var("actualUse", $improvementsBuildingsActualUses->getDescription());
break;
}
}
}
$this->tpl->parse("ImprovementsBuildingsBlock", "ImprovementsBuildings", true);
} else {
$this->tpl->set_block("TDList", "ImprovementsBuildings", "ImprovementsBuildingsBlock");
$this->tpl->set_var("ImprovementsBuildingsBlock", "");
}
}
function Main()
{
switch ($this->formArray["formAction"]) {
case "view":
$ODList = new SoapObject(NCCBIZ . "ODList.php", "urn:Object");
$condition = $this->filterArchives();
$odRecords = new ODRecords();
if ($odIDArray = $this->selectODRecords($condition)) {
$count = count($odIDArray);
$numOfPages = ceil($count / PAGE_BY);
$pLowerLimit = ($this->formArray["page"] - 1) * PAGE_BY;
$pUpperLimit = $pLowerLimit + PAGE_BY;
$this->tpl->set_var("currentPage", $this->formArray["page"]);
$this->tpl->set_var("numOfPages", $numOfPages);
$this->tpl->set_block("rptsTemplate", "PageListOne", "PageListOneBlock");
for ($p = 1; $p <= $numOfPages; $p++) {
$this->tpl->set_var("page", $p);
$this->initSelected("page", $p);
$this->tpl->parse("PageListOneBlock", "PageListOne", true);
}
for ($p = $pLowerLimit; $p < $pUpperLimit; $p++) {
if ($p < count($odIDArray)) {
$od = new OD();
$od->selectRecord($odIDArray[$p]);
$odRecords->arrayList[] = $od;
}
}
} else {
$this->tpl->set_block("rptsTemplate", "PageNavigationOne", "PageNavigationOneBlock");
$this->tpl->set_var("PageNavigationOneBlock", "");
}
if (!is_array($odRecords->arrayList)) {
$this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
$this->tpl->set_var("message", "properties not found");
$this->tpl->parse("NotFoundBlock", "NotFound", true);
$this->tpl->set_block("rptsTemplate", "Report", "ReportBlock");
$this->tpl->set_var("ReportBlock", "");
} else {
$list = $odRecords->getArrayList();
$noneFound = true;
if (count($list)) {
$this->tpl->set_block("rptsTemplate", "ReportList", "ReportListBlock");
foreach ($list as $key => $value) {
$afs = $this->getAFSDetails($value->getOdID());
if (is_object($afs)) {
$this->tpl->set_var("effectivity", $afs->getEffectivity());
$this->tpl->set_var("propertyIndexNumber", $afs->getPropertyIndexNumber());
$landList = $afs->getLandArray();
$plantsTreesList = $afs->getPlantsTreesArray();
$machineriesList = $afs->getMachineriesArray();
$kind = "";
$class = "";
$remarks = "";
$actualUse = "";
$actualUseReportCode = "";
if (!is_array($improvementsBuildingsList)) {
$this->tpl->set_var("marketValue", number_format($afs->getTotalMarketValue()));
} else {
$kind = "Improvements/Buildings";
$improvementsBuildings = $improvementsBuildingsList[0];
$actualUse = $improvementsBuildings->getActualUse();
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
$improvementsBuildingsActualUses->selectRecord($actualUse);
$actualUse = $improvementsBuildingsActualUses->getDescription();
$actualUseReportCode = $improvementsBuildingsActualUses->getReportCode();
$remarks = $improvementsBuildings->getMemoranda();
$marketValue = 0;
foreach ($improvementsBuildingsList as $impBldg) {
$marketValue += $impBldg->getAdjustedMarketValue();
}
$this->tpl->set_var("marketValue", number_format($marketValue));
}
$this->tpl->set_var("kind", $kind);
$this->tpl->set_var("actualUse", $actualUse);
$this->tpl->set_var("actualUseReportCode", $actualUseReportCode);
$this->tpl->set_var("remarks", $remarks);
}
$oValue = $value->owner;
if (count($oValue->personArray)) {
$firstOwner = $oValue->personArray[0]->getLastName();
$firstOwner .= ", ";
$firstOwner .= $oValue->personArray[0]->getFirstName();
$firstOwner .= " ";
$firstOwner .= substr($oValue->personArray[0]->getMiddleName(), 0, 1) . ".";
$pAddress = $oValue->personArray[0]->addressArray ? $oValue->personArray[0]->addressArray[0]->getFullAddress() : "no address";
$firstOwnerAddress = $pAddress;
$firstOwnerTelephone = $oValue->personArray[0]->getTelephone();
$this->tpl->set_var("firstOwner", $firstOwner);
$this->tpl->set_var("firstOwnerAddress", $firstOwnerAddress);
//$this->tpl->set_var("firstOwnerTelephone", $firstOwnerTelephone);
}
if (count($oValue->companyArray)) {
if ($firstOwner == "") {
$firstOwner = $oValue->companyArray[0]->getCompanyName();
$cAddress = $oValue->companyArray[0]->addressArray ? $oValue->companyArray[0]->addressArray[0]->getFullAddress() : "no \taddress";
$firstOwnerAddress = $cAddress;
$firstOwnerTelephone = $oValue->companyArray[0]->getTelephone();
$this->tpl->set_var("firstOwner", $firstOwner);
$this->tpl->set_var("firstOwnerAddress", $firstOwnerAddress);
//$this->tpl->set_var("firstOwnerTelephone", $firstOwnerTelephone);
}
}
if ($firstOwner != "") {
$this->tpl->set_var("none", "");
if (count($oValue->personArray) + count($oValue->companyArray) > 1) {
$this->tpl->set_var("andOthers", "(and others)");
} else {
$this->tpl->set_var("andOthers", "");
}
} else {
$this->tpl->set_var("none", "none");
$this->tpl->set_var("firstOwner", "");
$this->tpl->set_var("andOthers", "");
$this->tpl->set_var("firstOwnerAddress", "");
$this->tpl->set_var("firstOwnerTelephone", "");
}
if (is_array($oValue->personArray)) {
foreach ($oValue->personArray as $person) {
$ownersArrayList[] = $person->getFullName();
}
}
if (is_array($oValue->companyArray)) {
foreach ($oValue->companyArray as $company) {
$ownersArrayList[] = $company->getCompanyName();
}
}
if (is_array($ownersArrayList)) {
$this->tpl->set_var("ownerNames", implode(",<br>", $ownersArrayList));
} else {
$this->tpl->set_var("ownerNames", "");
}
unset($ownersArrayList);
$locationAddress = $value->locationAddress->getFullAddress();
$this->tpl->set_var("location", $locationAddress);
$noneFound = false;
$this->tpl->parse("ReportListBlock", "ReportList", true);
}
}
if ($noneFound == true) {
$this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
$this->tpl->set_var("message", "properties not found");
$this->tpl->parse("NotFoundBlock", "NotFound", true);
$this->tpl->set_block("rptsTemplate", "Report", "ReportBlock");
$this->tpl->set_var("ReportBlock", "");
} else {
$this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
$this->tpl->set_var("NotFoundBlock", "");
}
}
break;
default:
$this->tpl->set_block("rptsTemplate", "NotFound", "NotFoundBlock");
$this->tpl->set_var("message", "select a location to view report");
$this->tpl->parse("NotFoundBlock", "NotFound", true);
$this->tpl->set_block("rptsTemplate", "Report", "ReportBlock");
$this->tpl->set_var("ReportBlock", "");
break;
}
$this->setForm();
$this->tpl->set_var("Session", $this->sess->url(""));
$this->tpl->set_var("rpts_Session", $this->sess->id);
$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 displayAssessedValues($landList, $plantsTreesList, $improvementsBuildingsList, $machineriesList)
{
$totalMarketValue = 0;
$totalAssessedValue = 0;
$i = 0;
if (count($landList)) {
foreach ($landList as $key => $land) {
if ($i < 4) {
// classification
$landClasses = new LandClasses();
if (is_numeric($land->getClassification())) {
$landClasses->selectRecord($land->getClassification());
$landClassesDescription = $landClasses->getDescription();
$landClassesCode = $landClasses->getCode();
} else {
$landClassesDescription = $land->getClassification();
$landClassesCode = $land->getClassification();
}
// subClass
$landSubclasses = new LandSubclasses();
if (is_numeric($land->getSubClass())) {
$landSubclasses->selectRecord($land->getSubClass());
$landSubclassesDescription = $landSubclasses->getDescription();
$landSubclassesCode = $landSubclasses->getCode();
} else {
$landSubclassesDescription = $land->getSubClass();
$landSubclassesCode = $land->getSubClass();
}
// actualUse
$landActualUses = new LandActualUses();
if (is_numeric($land->getActualUse())) {
$landActualUses->selectRecord($land->getActualUse());
$landActualUsesDescription = $landActualUses->getDescription();
$landActualUsesCode = $landActualUses->getCode();
} else {
$landActualUsesDescription = $land->getActualUse();
$landActualUsesCode = $land->getActualUse();
}
$this->formArray["propertyKind" . ($i + 1)] = "Land";
$this->formArray["propertyActualUse" . ($i + 1)] = $landActualUsesDescription;
$this->formArray["propertyMarketValue" . ($i + 1)] = $land->getMarketValue();
$this->formArray["propertyAssessmentLevel" . ($i + 1)] = $land->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . ($i + 1)] = $land->getAssessedValue();
$totalMarketValue += toFloat($land->getMarketValue());
$totalAssessedValue += toFloat($land->getAssessedValue());
$i++;
}
}
}
if (count($plantsTreesList)) {
foreach ($plantsTreesList as $key => $plantsTrees) {
if ($i < 4) {
// productClass
$plantsTreesClasses = new PlantsTreesClasses();
if (is_numeric($plantsTrees->getProductClass())) {
$plantsTreesClasses->selectRecord($plantsTrees->getProductClass());
$plantsTreesClassesDescription = $plantsTreesClasses->getDescription();
$plantsTreesClassesCode = $plantsTreesClasses->getCode();
} else {
$plantsTreesClassesDescription = $plantsTrees->getProductClass();
$plantsTreesClassesCode = $plantsTrees->getProductClass();
}
// actualUse
$plantsTreesActualUses = new PlantsTreesActualUses();
if (is_numeric($plantsTrees->getActualUse())) {
$plantsTreesActualUses->selectRecord($plantsTrees->getActualUse());
$plantsTreesActualUsesDescription = $plantsTreesActualUses->getDescription();
$plantsTreesActualUsesCode = $plantsTreesActualUses->getCode();
} else {
$plantsTreesActualUsesDescription = $plantsTrees->getActualUse();
$plantsTreesActualUsesCode = $plantsTrees->getActualUse();
}
$this->formArray["propertyKind" . ($i + 1)] = "PlantsTrees";
$this->formArray["propertyActualUse" . ($i + 1)] = $plantsTreesActualUsesDescription;
$this->formArray["propertyMarketValue" . ($i + 1)] = $plantsTrees->getMarketValue();
$this->formArray["propertyAssessmentLevel" . ($i + 1)] = $plantsTrees->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . ($i + 1)] = $plantsTrees->getAssessedValue();
$totalMarketValue += toFloat($plantsTrees->getMarketValue());
$totalAssessedValue += toFloat($plantsTrees->getAssessedValue());
$i++;
}
}
}
if (count($improvementsBuildingsList)) {
foreach ($improvementsBuildingsList as $key => $improvementsBuildings) {
if ($i < 4) {
// buildingClassification
$improvementsBuildingsClasses = new ImprovementsBuildingsClasses();
if (is_numeric($improvementsBuildings->getBuildingClassification())) {
$improvementsBuildingsClasses->selectRecord($improvementsBuildings->getBuildingClassification());
$improvementsBuildingsClassesDescription = $improvementsBuildingsClasses->getDescription();
$improvementsBuildingsClassesCode = $improvementsBuildingsClasses->getCode();
} else {
$improvementsBuildingsClassesDescription = $improvementsBuildings->getBuildingClassification();
$improvementsBuildingsClassesCode = $improvementsBuildings->getBuildingClassification();
}
// actualUse
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
if (is_numeric($improvementsBuildings->getActualUse())) {
$improvementsBuildingsActualUses->selectRecord($improvementsBuildings->getActualUse());
$improvementsBuildingsActualUsesDescription = $improvementsBuildingsActualUses->getDescription();
$improvementsBuildingsActualUsesCode = $improvementsBuildingsActualUses->getCode();
} else {
$improvementsBuildingsActualUsesDescription = $improvementsBuildings->getActualUse();
$improvementsBuildingsActualUsesCode = $improvementsBuildings->getActualUse();
}
$this->formArray["propertyKind" . ($i + 1)] = "ImprovementsBuildings";
$this->formArray["propertyActualUse" . ($i + 1)] = $improvementsBuildingsActualUsesDescription;
$this->formArray["propertyMarketValue" . ($i + 1)] = $improvementsBuildings->getMarketValue();
$this->formArray["propertyAssessmentLevel" . ($i + 1)] = $improvementsBuildings->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . ($i + 1)] = $improvementsBuildings->getAssessedValue();
$totalMarketValue += toFloat($improvementsBuildings->getMarketValue());
$totalAssessedValue += toFloat($improvementsBuildings->getAssessedValue());
$i++;
}
}
}
if (count($machineriesList)) {
foreach ($machineriesList as $key => $machineries) {
if ($i < 4) {
// kind
$machineriesClasses = new MachineriesClasses();
if (is_numeric($machineries->getKind())) {
$machineriesClasses->selectRecord($machineries->getKind());
$machineriesClassesDescription = $machineriesClasses->getDescription();
$machineriesClassesCode = $machineriesClasses->getCode();
} else {
$machineriesClassesDescription = $machineries->getKind();
$machineriesClassesCode = $machineries->getActualUse();
}
// actualUse
$machineriesActualUses = new MachineriesActualUses();
if (is_numeric($machineries->getActualUse())) {
$machineriesActualUses->selectRecord($machineries->getActualUse());
$machineriesActualUsesDescription = $machineriesActualUses->getDescription();
$machineriesActualUsesCode = $machineriesActualUses->getCode();
} else {
$machineriesActualUsesDescription = $machineries->getActualUse();
$machineriesActualUsesCode = $machineries->getActualUse();
}
$this->formArray["propertyKind" . ($i + 1)] = "Machineries";
$this->formArray["propertyActualUse" . ($i + 1)] = $machineriesActualUsesDescription;
$this->formArray["propertyMarketValue" . ($i + 1)] = $machineries->getMarketValue();
$this->formArray["propertyAssessmentLevel" . ($i + 1)] = $machineries->getAssessmentLevel();
$this->formArray["propertyAssessedValue" . ($i + 1)] = $machineries->getAssessedValue();
$totalMarketValue += toFloat($machineries->getMarketValue());
$totalAssessedValue += toFloat($machineries->getAssessedValue());
$i++;
}
}
}
$this->formArray["totalMarketValue"] = $totalMarketValue;
$this->formArray["totalAssessedValue"] = $totalAssessedValue;
$this->formArray["totalAssessedValueInWords"] = makewords($totalAssessedValue);
}
function Main()
{
switch ($this->formArray["formAction"]) {
case "edit":
$this->tpl->set_var("MessageBlock", "");
$ImprovementsBuildingsActualUsesDetails = new SoapObject(NCCBIZ . "ImprovementsBuildingsActualUsesDetails.php", "urn:Object");
if (!($xmlStr = $ImprovementsBuildingsActualUsesDetails->getImprovementsBuildingsActualUsesDetails($this->formArray["improvementsBuildingsActualUsesID"]))) {
$this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
$this->tpl->set_var("TableBlock", "record not found");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
$this->tpl->set_var("TableBlock", "error xmlDoc");
} else {
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
$improvementsBuildingsActualUses->parseDomDocument($domDoc);
$this->formArray["improvementsBuildingsActualUsesID"] = $improvementsBuildingsActualUses->getImprovementsBuildingsActualUsesID();
$this->formArray["code"] = $improvementsBuildingsActualUses->getCode();
$this->formArray["reportCode"] = $improvementsBuildingsActualUses->getReportCode();
$this->formArray["description"] = $improvementsBuildingsActualUses->getDescription();
$this->formArray["rangeLowerBound"] = $improvementsBuildingsActualUses->getRangeLowerBound();
$this->formArray["rangeUpperBound"] = $improvementsBuildingsActualUses->getRangeUpperBound();
$this->formArray["value"] = $improvementsBuildingsActualUses->getValue();
$this->formArray["status"] = $improvementsBuildingsActualUses->getStatus();
}
}
break;
case "save":
if ($this->codeAlreadyExists() == true) {
$this->message = "Error. Cannot Save. Code already exists.";
$this->tpl->set_var("message", $this->message);
$this->tpl->parse("MessageBlock", "Message", true);
break;
} else {
$this->tpl->set_var("MessageBlock", "");
}
$ImprovementsBuildingsActualUsesEncode = new SoapObject(NCCBIZ . "ImprovementsBuildingsActualUsesEncode.php", "urn:Object");
if ($this->formArray["improvementsBuildingsActualUsesID"] != "") {
$ImprovementsBuildingsActualUsesDetails = new SoapObject(NCCBIZ . "ImprovementsBuildingsActualUsesDetails.php", "urn:Object");
if (!($xmlStr = $ImprovementsBuildingsActualUsesDetails->getImprovementsBuildingsActualUsesDetails($this->formArray["improvementsBuildingsActualUsesID"]))) {
exit("record not found");
} else {
if (!($domDoc = domxml_open_mem($xmlStr))) {
$this->tpl->set_block("rptsTemplate", "Table", "TableBlock");
$this->tpl->set_var("TableBlock", "error xmlDoc");
} else {
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
$improvementsBuildingsActualUses->parseDomDocument($domDoc);
$improvementsBuildingsActualUses->setImprovementsBuildingsActualUsesID($this->formArray["improvementsBuildingsActualUsesID"]);
$improvementsBuildingsActualUses->setCode($this->formArray["code"]);
$improvementsBuildingsActualUses->setReportCode($this->formArray["reportCode"]);
$improvementsBuildingsActualUses->setDescription($this->formArray["description"]);
$improvementsBuildingsActualUses->setRangeLowerBound($this->formArray["rangeLowerBound"]);
$improvementsBuildingsActualUses->setRangeUpperBound($this->formArray["rangeUpperBound"]);
$improvementsBuildingsActualUses->setValue($this->formArray["value"]);
$improvementsBuildingsActualUses->setStatus($this->formArray["status"]);
$improvementsBuildingsActualUses->setDomDocument();
$doc = $improvementsBuildingsActualUses->getDomDocument();
$xmlStr = $doc->dump_mem(true);
if (!($ret = $ImprovementsBuildingsActualUsesEncode->updateImprovementsBuildingsActualUses($xmlStr))) {
exit("error update");
}
}
}
} else {
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
$improvementsBuildingsActualUses->setImprovementsBuildingsActualUsesID($this->formArray["improvementsBuildingsActualUsesID"]);
$improvementsBuildingsActualUses->setCode($this->formArray["code"]);
$improvementsBuildingsActualUses->setReportCode($this->formArray["reportCode"]);
$improvementsBuildingsActualUses->setDescription($this->formArray["description"]);
$improvementsBuildingsActualUses->setRangeLowerBound($this->formArray["rangeLowerBound"]);
$improvementsBuildingsActualUses->setRangeUpperBound($this->formArray["rangeUpperBound"]);
$improvementsBuildingsActualUses->setValue($this->formArray["value"]);
$improvementsBuildingsActualUses->setStatus($this->formArray["status"]);
$improvementsBuildingsActualUses->setDomDocument();
$doc = $improvementsBuildingsActualUses->getDomDocument();
$xmlStr = $doc->dump_mem(true);
if (!($ret = $ImprovementsBuildingsActualUsesEncode->saveImprovementsBuildingsActualUses($xmlStr))) {
exit("error save");
}
}
$this->formArray["improvementsBuildingsActualUsesID"] = $ret;
header("location: ImprovementsBuildingsActualUsesClose.php" . $this->sess->url("") . $this->sess->add_query(array("improvementsBuildingsActualUsesID" => $ret)));
//header("location: ImprovementsBuildingsActualUsesEncode.php");
exit;
break;
case "cancel":
header("location: ImprovementsBuildingsActualUsesClose.php" . $this->sess->url("") . $this->sess->add_query(array("improvementsBuildingsActualUsesID" => $ret)));
//header("location: ImprovementsBuildingsActualUsesList.php");
exit;
break;
default:
$this->tpl->set_block("rptsTemplate", "ImprovementsBuildingsActualUsesID", "ImprovementsBuildingsActualUsesIDBlock");
$this->tpl->set_var("ImprovementsBuildingsActualUsesIDBlock", "");
$this->tpl->set_block("rptsTemplate", "ACK", "ACKBlock");
$this->tpl->set_var("ACKBlock", "");
$this->tpl->set_var("MessageBlock", "");
}
$this->setForm();
$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 displayImprovementsBuildingsList($improvementsBuildingsList)
{
if (count($improvementsBuildingsList)) {
foreach ($improvementsBuildingsList as $bkey => $improvementsBuildings) {
// buildingClassification
$improvementsBuildingsClasses = new ImprovementsBuildingsClasses();
if (is_numeric($improvementsBuildings->getBuildingClassification())) {
$improvementsBuildingsClasses->selectRecord($improvementsBuildings->getBuildingClassification());
$improvementsBuildingsClassesDescription = $improvementsBuildingsClasses->getDescription();
$improvementsBuildingsClassesCode = $improvementsBuildingsClasses->getCode();
} else {
$improvementsBuildingsClassesDescription = $improvementsBuildings->getBuildingClassification();
$improvementsBuildingsClassesCode = $improvementsBuildings->getBuildingClassification();
}
// just in case actualUse needs to be drawn from improvementsBuildings
// actualUse
$improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses();
if (is_numeric($improvementsBuildings->getActualUse())) {
$improvementsBuildingsActualUses->selectRecord($improvementsBuildings->getActualUse());
$improvementsBuildingsActualUsesDescription = $improvementsBuildingsActualUses->getDescription();
$improvementsBuildingsActualUsesCode = $improvementsBuildingsActualUses->getCode();
} else {
$improvementsBuildingsActualUsesDescription = $improvementsBuildings->getActualUse();
$improvementsBuildingsActualUsesCode = $improvementsBuildings->getActualUse();
}
if ($this->formArray["p"] <= 24) {
$p = $this->formArray["p"];
$this->formArray["kind" . $p] = $improvementsBuildings->getKind();
$this->formArray["classification" . $p] = $improvementsBuildingsClassesDescription;
$this->formArray["landActualUses" . $p] = $improvementsBuildingsActualUsesDescription;
$this->formArray["propertyMarketValue" . $p] = un_number_format($improvementsBuildings->getAdjustedMarketValue());
$this->formArray["assessmentLevel" . $p] = un_number_format($improvementsBuildings->getAssessmentLevel());
$this->formArray["assessedValue" . $p] = un_number_format($improvementsBuildings->getAssessedValue());
$this->formArray["totalMarketValue"] += un_number_format($this->formArray["propertyMarketValue" . $p]);
$this->formArray["totalAssessedValue"] += un_number_format($this->formArray["assessedValue" . $p]);
$this->formArray["p"]++;
}
}
}
}
