function updateLandSubclasses($xmlStr) { if (!($domDoc = domxml_open_mem($xmlStr))) { return false; } $landSubclasses = new LandSubclasses(); $landSubclasses->parseDomDocument($domDoc); $ret = $landSubclasses->updateRecord(); return $ret; }
function getLandSubclassesDetails($landSubclassesID) { $landSubclasses = new LandSubclasses(); $landSubclasses->selectRecord($landSubclassesID); if (!($domDoc = $landSubclasses->getDomDocument())) { return false; } else { $xmlStr = $domDoc->dump_mem(true); return $xmlStr; } }
function displayLandList($landList) { $this->tpl->set_block("rptsTemplate", "LandDBEmpty", "LandDBEmptyBlock"); $this->tpl->set_var("LandDBEmptyBlock", ""); $this->tpl->set_block("rptsTemplate", "defaultLandList", "defaultLandListBlock"); $this->tpl->set_block("rptsTemplate", "toggleLandList", "toggleLandListBlock"); //echo $this->formArray["totalMarketValue"]; if (count($landList)) { //$this->tpl->set_block("rptsTemplate", "hideLandList", "hideLandListBlock"); $this->tpl->set_block("rptsTemplate", "LandList", "LandListBlock"); $i = 0; $totalMarketValue = 0; $totalAssessedValue = 0; foreach ($landList 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 "classification": $landClasses = new LandClasses(); $landClasses->selectRecord($lvalue); $this->tpl->set_var("classification", $landClasses->getDescription()); break; case "subClass": $landSubclasses = new LandSubclasses(); $landSubclasses->selectRecord($lvalue); $this->tpl->set_var("subClass", $landSubclasses->getDescription()); break; case "actualUse": $landActualUses = new LandActualUses(); $landActualUses->selectRecord($lvalue); $this->tpl->set_var("actualUse", $landActualUses->getDescription()); break; } } } $this->tpl->set_var("ctr", $i); $this->tpl->parse("defaultLandListBlock", "defaultLandList", true); $this->tpl->parse("toggleLandListBlock", "toggleLandList", true); //$this->tpl->parse("hideLandListBlock", "hideLandList", true); $this->setLandListBlockPerms(); $this->tpl->parse("LandListBlock", "LandList", true); $i++; } $this->formArray["totalMarketValue"] += $totalMarketValue; $this->formArray["totalAssessedValue"] += $totalAssessedValue; $this->formArray["landTotalMarketValue"] = $totalMarketValue; $this->formArray["landTotalAssessedValue"] = $totalAssessedValue; $this->tpl->set_var("landCtr", $i); } else { $this->tpl->set_var("defaultLandListBlock", ""); $this->tpl->set_var("toggleLandListBlock", ""); } }
function displayLandList($landList) { $landTotal = 0; if (count($landList)) { $l = 0; foreach ($landList as $key => $land) { if ($this->pl == 0) { //$this->formArray["arpNumber"] = $land->getArpNumber(); //$this->formArray["propertyIndexNumber"] = $land->getPropertyIndexNumber(); $this->formArray["octTctNumber"] = $land->getOctTctNumber(); $this->formArray["surveyNumber"] = $land->getSurveyNumber(); $this->formArray["north"] = $land->getNorth(); $this->formArray["east"] = $land->getEast(); $this->formArray["south"] = $land->getSouth(); $this->formArray["west"] = $land->getWest(); $this->formArray["taxability"] = $land->getTaxability(); $this->formArray["effectivity"] = $land->getEffectivity(); $this->formArray["memoranda"] = $land->getMemoranda(); if (is_a($land->propertyAdministrator, Person)) { $this->formArray["administrator"] = $land->propertyAdministrator->getFullName(); if (is_a($land->propertyAdministrator->addressArray[0], "address")) { $address1 = $land->propertyAdministrator->addressArray[0]->getNumber(); $address1 .= " " . $land->propertyAdministrator->addressArray[0]->getStreet(); $address1 .= ", " . $land->propertyAdministrator->addressArray[0]->getBarangay(); $address2 = $land->propertyAdministrator->addressArray[0]->getDistrict(); $address2 .= ", " . $land->propertyAdministrator->addressArray[0]->getMunicipalityCity(); $address2 .= ", " . $land->propertyAdministrator->addressArray[0]->getProvince(); $this->formArray["adminAddress1"] = $address1; $this->formArray["adminAddress2"] = $address2; } $this->formArray["adminTelno"] = $land->propertyAdministrator->getTelephone(); } // recommendingApproval if (is_numeric($land->recommendingApproval)) { $recommendingApproval = new Person(); $recommendingApproval->selectRecord($land->recommendingApproval); $this->formArray["recommendingApproval"] = $recommendingApproval->getFullName(); $this->recommendingApproval = $recommendingApproval->getFullName(); } else { $recommendingApproval = $land->recommendingApproval; $this->formArray["recommendingApproval"] = $recommendingApproval; $this->recommendingApproval = $recommendingApproval; } $this->formArray["dateRecommendingApproval"] = $land->getRecommendingApprovalDate(); // approvedBy if (is_numeric($land->approvedBy)) { $approvedBy = new Person(); $approvedBy->selectRecord($land->approvedBy); $this->formArray["approvedBy"] = $approvedBy->getFullName(); $this->approvedBy = $approvedBy->getFullName(); } else { $approvedBy = $land->approvedBy; $this->formArray["approvedBy"] = $approvedBy; $this->approvedBy = $approvedBy; } $this->formArray["dateApprovedBy"] = $land->getApprovedByDate(); // appraisedBy (assessedBy) if (is_numeric($land->appraisedBy)) { $appraisedBy = new Person(); $appraisedBy->selectRecord($land->appraisedBy); $this->formArray["assessedBy"] = $appraisedBy->getFullName(); $this->appraisedBy = $appraisedBy->getFullName(); } else { $appraisedBy = $land->appraisedBy; $this->formArray["assessedBy"] = $appraisedBy; $this->appraisedBy = $appraisedBy; } $this->formArray["dateAssessedBy"] = $land->getAppraisedByDate(); } if ($l < 9) { // classification $landClasses = new LandClasses(); if (is_numeric($land->getClassification())) { $landClasses->selectRecord($land->getClassification()); $this->formArray["classification" . ($l + 1)] = $landClasses->getDescription(); } else { $this->formArray["classification" . ($l + 1)] = $land->getClassification(); } // subClass $landSubclasses = new LandSubclasses(); if (is_numeric($land->getSubClass())) { $landSubclasses->selectRecord($land->getSubClass()); $this->formArray["subClass" . ($l + 1)] = $landSubclasses->getDescription(); } else { $this->formArray["subClass" . ($l + 1)] = $land->getSubClass(); } $this->formArray["area" . ($l + 1)] = $land->getArea() . " " . $this->getUnit($land->getUnit); // actualUse $landActualUses = new LandActualUses(); if (is_numeric($land->getActualUse())) { $landActualUses->selectRecord($land->getActualUse()); $this->formArray["landActualUse" . ($l + 1)] = $landActualUses->getDescription(); } else { $this->formArray["landActualUse" . ($l + 1)] = $land->getActualUse(); } $this->formArray["unitValue" . ($l + 1)] = $land->getUnitValue(); $this->formArray["landMrktVal" . ($l + 1)] = $land->getMarketValue(); $landTotal = $landTotal + toFloat($land->getMarketValue()); } if ($this->pl < 6) { $this->formArray["valAdjFacMrktVal" . ($this->pl + 1)] = $land->getMarketValue(); $this->formArray["adjFacTxt" . ($this->pl + 1)] = $land->getAdjustmentFactor(); $this->formArray["adjFacInt" . ($this->pl + 1)] = "L"; $this->formArray["adjustment" . ($this->pl + 1)] = $land->getPercentAdjustment(); $this->formArray["valueAdjustment" . ($this->pl + 1)] = $land->getValueAdjustment(); $this->formArray["valAdjFacAdjMrktVal" . ($this->pl + 1)] = $land->getAdjustedMarketValue(); $this->formArray["valAdjFacTotal"] = $this->formArray["valAdjFacTotal"] + toFloat($land->getAdjustedMarketValue()); } if ($this->pl < 5) { $this->formArray["kind" . ($this->pl + 1)] = "Land"; $this->formArray["propertyActualUse" . ($this->pl + 1)] = $land->getActualUse(); $this->formArray["propertyAdjMrktVal" . ($this->pl + 1)] = $land->getAdjustedMarketValue(); $this->formArray["level" . ($this->pl + 1)] = $land->getAssessmentLevel(); $this->formArray["assessedValue" . ($this->pl + 1)] = $land->getAssessedValue(); $this->formArray["propertyAdjMrktValTotal"] = $this->formArray["propertyAdjMrktValTotal"] + toFloat($land->getAdjustedMarketValue()); $this->formArray["propertyTotal"] = $this->formArray["propertyTotal"] + toFloat($land->getAssessedValue()); } $l++; $this->pl++; } } $this->formArray["landTotal"] = $landTotal; }
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 displayLandList($landList) { if (count($landList)) { $land = $landList[0]; $this->tpl->set_var("land[propertyID]", $this->htmlProperty("propertyID", $land->getPropertyID())); $this->tpl->set_var("land[octTctNumber]", $this->htmlProperty("octTctNumber", $land->getOctTctNumber())); $this->tpl->set_var("land[surveyNumber]", $this->htmlProperty("surveyNumber", $land->getSurveyNumber())); $this->tpl->set_var("land[north]", $this->htmlProperty("north", $land->getNorth())); $this->tpl->set_var("land[south]", $this->htmlProperty("south", $land->getSouth())); $this->tpl->set_var("land[east]", $this->htmlProperty("east", $land->getEast())); $this->tpl->set_var("land[west]", $this->htmlProperty("west", $land->getWest())); $this->tpl->set_var("land[description]", $this->htmlProperty("description", $land->getKind())); foreach ($land as $lkey => $lvalue) { if (is_numeric($lvalue)) { switch ($lkey) { case "classification": $landClasses = new LandClasses(); $landClasses->selectRecord($lvalue); $this->tpl->set_var("land[classification]", $this->htmlProperty("classification", $landClasses->getDescription())); break; case "subClass": $landSubclasses = new LandSubclasses(); $landSubclasses->selectRecord($lvalue); $this->tpl->set_var("land[subClass]", $this->htmlProperty("subClass", $landSubclasses->getDescription())); break; case "actualUse": $landActualUses = new LandActualUses(); $landActualUses->selectRecord($lvalue); $this->tpl->set_var("land[actualUse]", $this->htmlProperty("actualUse", $landActualUses->getDescription())); break; } } } $this->tpl->set_var("land[area]", $this->htmlProperty("area", $land->getArea() . " " . $land->getUnit())); } }
function CreateNewRPU_AFS_TD($odID, $userID = "", $transactionCode = "", $copyOwner = true, $copyAFS = true, $copyTD = false) { $od = new OD(); $od->selectRecord($odID); unset($od->oldODArray); $od->setTransactionCode($transactionCode); $od->setOldODArray($odID); // create new OD $ownerID = $od->owner->getOwnerID(); $newOdID = $od->insertRecord(); $newOwnerID = $od->newOwnerID; $od->setDomDocument(); // associate existing Owner to new OD $owner = new Owner(); $owner->selectRecord($ownerID); if (count($owner->personArray)) { foreach ($owner->personArray as $personKey => $personValue) { if ($copyOwner) { $owner->insertOwnerPerson($newOwnerID, $personValue->getPersonID()); } } } if (count($owner->companyArray)) { foreach ($owner->companyArray as $companyKey => $companyValue) { if ($copyOwner) { $owner->insertOwnerCompany($newOwnerID, $companyValue->getCompanyID()); } } } // create new AFS and associate existing properties to new AFS $afs = new AFS(); $afsID = $afs->checkAfsID($odID); $afs->selectRecord($afsID); $afs->setOdID($newOdID); $afs->effectivity = date("Y") + 1; // new arpNumber is blank $afs->arpNumber = ""; // retain PIN except for Consolidation and Subdivision if ($transactionCode == "SD" || $transactionCode == "CS") { $afs->propertyIndexNumber = ""; } $afs->setDomDocument(); if ($copyAFS) { $newAfsID = $afs->insertRecord(); if (count($afs->landArray)) { foreach ($afs->landArray as $landKey => $landValue) { $landValue->setPropertyID(""); $landValue->setAfsID($newAfsID); if (is_object($landValue->propertyAdministrator)) { $landValue->propertyAdministrator->setPersonID(""); } else { $landValue->propertyAdministrator = new Person(); $landValue->propertyAdministrator->setPersonID(""); } // set unitValue from SubClass $landSubclasses = new LandSubclasses(); $landSubclasses->selectRecord(intVal($landValue->subClass)); $landValue->setUnitValue($landSubclasses->getValue()); // set assessmentLevel from ActualUse $landActualUses = new LandActualUses(); $landActualUses->selectRecord(intVal($landValue->actualUse)); $landValue->setAssessmentLevel($landActualUses->getValue()); $landValue->calculateMarketValue(); $landValue->calculateValueAdjustment(); $landValue->calculateAdjustedMarketValue(); $landValue->calculateAssessedValue(); $newP = $landValue->insertRecord(); } } if (count($afs->plantsTreesArray)) { foreach ($afs->plantsTreesArray as $plantsTreesKey => $plantsTreesValue) { $plantsTreesValue->setPropertyID(""); $plantsTreesValue->setAfsID($newAfsID); if (is_object($plantsTreesValue->propertyAdministrator)) { $plantsTreesValue->propertyAdministrator->setPersonID(""); } else { $plantsTreesValue->propertyAdministrator = new Person(); $plantsTreesValue->propertyAdministrator->setPersonID(""); } // set unitPrice from ProductClass $plantsTreesClasses = new PlantsTreesClasses(); $plantsTreesClasses->selectRecord(intVal($plantsTreesValue->productClass)); $plantsTreesValue->setUnitPrice($plantsTreesClasses->getValue()); // set assessmentLevel from ActualUse $plantsTreesActualUses = new PlantsTreesActualUses(); $plantsTreesActualUses->selectRecord(intVal($plantsTreesValue->actualUse)); $plantsTreesValue->setAssessmentLevel($plantsTreesActualUses->getValue()); $plantsTreesValue->calculateMarketValue(); $plantsTreesValue->calculateValueAdjustment(); $plantsTreesValue->calculateAdjustedMarketValue(); $plantsTreesValue->calculateAssessedValue(); $newP = $plantsTreesValue->insertRecord(); } } if (count($afs->improvementsBuildingsArray)) { foreach ($afs->improvementsBuildingsArray as $improvementsBuildingsKey => $improvementsBuildingsValue) { $improvementsBuildingsValue->setPropertyID(""); $improvementsBuildingsValue->setAfsID($newAfsID); if (is_object($improvementsBuildingsValue->propertyAdministrator)) { $improvementsBuildingsValue->propertyAdministrator->setPersonID(""); } else { $improvementsBuildingsValue->propertyAdministrator = new Person(); $improvementsBuildingsValue->propertyAdministrator->setPersonID(""); } // set unitValue from BuildingClassification $improvementsBuildingsClasses = new ImprovementsBuildingsClasses(); $improvementsBuildingsClasses->selectRecord(intVal($improvementsBuildingsValue->buildingClassification)); $improvementsBuildingsValue->setUnitValue($improvementsBuildingsClasses->getValue()); // this if() line added : November 05 2004: // if master table unit value is not 0, update this unit value with the master table unit value // otherwise, retain this unit value as it is the old one. if ($improvementsBuildingsClasses->getValue() != 0) { $improvementsBuildingsValue->setUnitValue($improvementsBuildingsClasses->getValue()); } // set assessmentLevel from ActualUse $improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses(); $improvementsBuildingsActualUses->selectRecord(intVal($improvementsBuildingsValue->actualUse)); $improvementsBuildingsValue->setAssessmentLevel($improvementsBuildingsActualUses->getValue()); $improvementsBuildingsValue->calculateMarketValue(); $improvementsBuildingsValue->calculateAccumulatedDepreciation(); $improvementsBuildingsValue->calculatedDepreciatedMarketValue(); $improvementsBuildingsValue->calculateAdjustedMarketValue(); $improvementsBuildingsValue->calculateAssessedValue(); $newP = $improvementsBuildingsValue->insertRecord(); } } if (count($afs->machineriesArray)) { foreach ($afs->machineriesArray as $machineriesKey => $machineriesValue) { $machineriesValue->setPropertyID(""); $machineriesValue->setAfsID($newAfsID); if (is_object($machineriesValue->propertyAdministrator)) { $machineriesValue->propertyAdministrator->setPersonID(""); } else { $machineriesValue->propertyAdministrator = new Person(); $machineriesValue->propertyAdministrator->setPersonID(""); } // set assessmentLevel from ActualUse $machineriesActualUses = new MachineriesActualUses(); $machineriesActualUses->selectRecord(intVal($machineriesValue->actualUse)); $machineriesValue->setAssessmentLevel($machineriesActualUses->getValue()); $machineriesValue->calculateMarketValue(); $machineriesValue->calculateDepreciatedMarketValue(); $machineriesValue->calculateAdjustedMarketValue(); $machineriesValue->calculateAssessedValue(); $newP = $machineriesValue->insertRecord(); } } } return $newOdID; }
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 displayLand($land) { if ($land) { $this->displayDetails($land); foreach ($land as $lkey => $lvalue) { if (is_numeric($lvalue)) { switch ($lkey) { case "classification": $landClasses = new LandClasses(); $landClasses->selectRecord($lvalue); $this->tpl->set_var("classification", $landClasses->getDescription()); break; case "subClass": $landSubclasses = new LandSubclasses(); $landSubclasses->selectRecord($lvalue); $this->tpl->set_var("subClass", $landSubclasses->getDescription()); break; case "actualUse": $landActualUses = new LandActualUses(); $landActualUses->selectRecord($lvalue); $this->tpl->set_var("actualUse", $landActualUses->getDescription()); break; } } } $this->tpl->parse("LandBlock", "Land", true); } else { $this->tpl->set_var("LandBlock", ""); } }
function displayLandList($landList) { $landTotal = 0; $finalUnit = ''; if (count($landList)) { $l = 0; $landitems = ''; $adjitems = ''; $totalarea = 0; $adjcount = $this->formArray["adjcount"]; $adjfact = ''; $percadj = 0; $markval = 0; $valuadj = 0; $adjmark = 0; $summcount = $this->formArray["summcount"]; $summuse = ''; $summadj = 0; $summlvl = 0; $summasv = 0; $mixedUnits = 0; foreach ($landList as $key => $land) { if ($this->pl == 0) { //$this->formArray["taxDeclarationNumber"] = $land->getTaxDeclarationNumber(); //$this->formArray["propertyIndexNumber"] = $land->getPropertyIndexNumber(); $this->formArray["Numberlot"] = $land->propertyAdministrator->getemail(); $this->formArray["octTctNumber"] = $land->getOctTctNumber(); $this->formArray["Numbersurvey"] = $land->getSurveyNumber(); $this->formArray["north"] = $land->getNorth(); $this->formArray["east"] = $land->getEast(); $this->formArray["south"] = $land->getSouth(); $this->formArray["west"] = $land->getWest(); //$this->formArray["taxability"] = $land->getTaxability(); //$this->formArray["effectivity"] = $land->getEffectivity(); //$this->formArray["memoranda"] = $td->getMemoranda(); if (is_a($land->propertyAdministrator, Person)) { if ($land->propertyAdministrator->getLastName() != "") { $this->formArray["administrator"] = $land->propertyAdministrator->getFullName(); } if (is_a($land->propertyAdministrator->addressArray[0], "address")) { $address1 = $land->propertyAdministrator->addressArray[0]->getNumber(); if ($address1 != "") { $address1 .= " "; } $address1 .= $land->propertyAdministrator->addressArray[0]->getStreet(); if ($address1 != "") { $address1 .= ", "; } $address1 .= $land->propertyAdministrator->addressArray[0]->getBarangay(); $address2 = $land->propertyAdministrator->addressArray[0]->getDistrict(); if ($address2 != "") { $address2 .= ", "; } $address2 .= $land->propertyAdministrator->addressArray[0]->getMunicipalityCity(); if ($address2 != "") { $address2 .= ", "; } $address2 .= $land->propertyAdministrator->addressArray[0]->getProvince(); $this->formArray["adminAddress1"] = $address1; $this->formArray["adminAddress2"] = $address2; } $this->formArray["adminTelno"] = $land->propertyAdministrator->getTelephone(); } // recommendingApproval if (is_numeric($land->recommendingApproval)) { $recommendingApproval = new Person(); $recommendingApproval->selectRecord($land->recommendingApproval); $this->formArray["recommendingApproval"] = strtoupper($recommendingApproval->getFullName()); $this->recommendingApproval = $recommendingApproval->getFullName(); } else { $recommendingApproval = $land->recommendingApproval; $this->formArray["recommendingApproval"] = strtoupper($recommendingApproval); $this->recommendingApproval = $recommendingApproval; } $this->formArray["dateRecommendingApproval"] = $land->getRecommendingApprovalDate(); // approvedBy if (is_numeric($land->approvedBy)) { $approvedBy = new Person(); $approvedBy->selectRecord($land->approvedBy); $this->formArray["approvedBy"] = strtoupper($approvedBy->getFullName()); $this->approvedBy = $approvedBy->getFullName(); } else { $approvedBy = $land->approvedBy; $this->formArray["approvedBy"] = strtoupper($approvedBy); $this->approvedBy = $approvedBy; } $this->formArray["dateApprovedBy"] = $land->getApprovedByDate(); // appraisedBy (assessedBy) if (is_numeric($land->appraisedBy)) { $appraisedBy = new Person(); $appraisedBy->selectRecord($land->appraisedBy); $this->formArray["assessedBy"] = $appraisedBy->getFullName(); $this->appraisedBy = $appraisedBy->getFullName(); } else { $appraisedBy = $land->appraisedBy; $this->formArray["assessedBy"] = $appraisedBy; $this->appraisedBy = $appraisedBy; } $this->formArray["dateAssessedBy"] = $land->getAppraisedByDate(); } // Land Appraisal $this->formArray["landstart"] -= 19; $offset = $this->formArray["landstart"]; // 5 Change to 11 if ($l < 11) { // classification $landClasses = new LandClasses(); if (is_numeric($land->getClassification())) { $landClasses->selectRecord($land->getClassification()); $this->formArray["classification" . ($l + 1)] = $landClasses->getDescription(); } else { $this->formArray["classification" . ($l + 1)] = $land->getClassification(); } $landitems .= '<textitem xpos="55" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . $this->formArray["classification" . ($l + 1)] . '</textitem>' . "\r\n"; // subClass $landSubclasses = new LandSubclasses(); if (is_numeric($land->getSubClass())) { $landSubclasses->selectRecord($land->getSubClass()); $this->formArray["subClass" . ($l + 1)] = $landSubclasses->getDescription(); } else { $this->formArray["subClass" . ($l + 1)] = $land->getSubClass(); } $landitems .= '<textitem xpos="125" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . $this->formArray["subClass" . ($l + 1)] . '</textitem>' . "\r\n"; if (strlen($finalUnit) == 0) { if ($land->getUnit() != "square meters") { $finalUnit = "has."; } else { $finalUnit = "sqm."; } } else { if ($finalUnit != $land->getUnit()) { $mixedUnits = 1; $finalUnit = "has."; } else { $finalUnit = "sqm."; } } if ($land->getUnit() != "square meters") { $runArea = number_format((double) $land->getArea(), 4) . " has."; $totalarea += (double) $land->getArea() * 10000; } else { $runArea = number_format((double) $land->getArea(), 2) . " sqm."; $totalarea += (double) $land->getArea(); } // $this->formArray["area".($l+1)] = number_format($land->getArea(),4)." ".($land->getUnit()=="square meters")?"sqm.":"has."; $landitems .= '<textitem xpos="297" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . $runArea . '</textitem>' . "\r\n"; // actualUse==========with round off========= $landActualUses = new LandActualUses(); if (is_numeric($land->getActualUse())) { $landActualUses->selectRecord($land->getActualUse()); $this->formArray["landActualUse" . ($l + 1)] = $landActualUses->getDescription(); } else { $this->formArray["landActualUse" . ($l + 1)] = $land->getActualUse(); } $landitems .= '<textitem xpos="305" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . $this->formArray["landActualUse" . ($l + 1)] . '</textitem>' . "\r\n"; $this->formArray["unitValue" . ($l + 1)] = $land->getUnitValue(); $uvx = str_replace(',', '', $this->formArray["unitValue" . ($l + 1)]); $landitems .= '<textitem xpos="437" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($uvx, 2) . '</textitem>' . "\r\n"; $this->formArray["landMrktVal" . ($l + 1)] = number_format($land->getMarketValue(), 2); $landitems .= '<textitem xpos="540" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . $this->formArray["landMrktVal" . ($l + 1)] . '</textitem>' . "\r\n"; $landTotal = $landTotal + toFloat($land->getMarketValue()); $landitems .= '<lineitem x1="50" y1="' . ($offset - 8) . '" x2="550" y2="' . ($offset - 8) . '">blurb</lineitem>'; } if ($this->pl < 11) { if ($percadj != (double) $land->getPercentAdjustment()) { if ($markval > 0) { $adjcount++; $this->formArray["adjstart"] -= 14; $offset = $this->formArray["adjstart"]; $adjitems .= '<textitem xpos="147" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($markval, 2) . ' (L)' . '</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="155" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . $adjfact . '</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="405" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($percadj) . '%</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="475" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($valuadj, 2) . '</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="545" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($adjmark, 2) . '</textitem>' . "\r\n"; $adjitems .= '<lineitem x1="50" y1="' . ($offset - 5) . '" x2="550" y2="' . ($offset - 5) . '">blurb</lineitem>'; } $percadj = (double) $land->getPercentAdjustment(); $adjfact = $land->getAdjustmentFactor(); $markval = 0; $valuadj = 0; $adjmark = 0; } $markval += (double) $land->getMarketValue(); $valuadj += (double) $land->getValueAdjustment(); $adjmark += (double) $land->getAdjustedMarketValue(); $this->formArray["valAdjFacMrktVal" . ($this->pl + 1)] = $land->getMarketValue(); $this->formArray["adjFacTxt" . ($this->pl + 1)] = $land->getAdjustmentFactor(); $this->formArray["adjFacInt" . ($this->pl + 1)] = "L"; $this->formArray["adjustment" . ($this->pl + 1)] = $land->getPercentAdjustment(); $this->formArray["valueAdjustment" . ($this->pl + 1)] = $land->getValueAdjustment(); $this->formArray["valAdjFacAdjMrktVal" . ($this->pl + 1)] = $land->getAdjustedMarketValue(); $this->formArray["valAdjFacTotal"] = $this->formArray["valAdjFacTotal"] + toFloat($land->getAdjustedMarketValue()); } // 8 to 11 if ($this->pl < 11) { $this->formArray["kind" . ($this->pl + 1)] = "Land"; //if(is_numeric($land->getActualUse())){ $landActualUses->selectRecord($land->getActualUse()); $this->formArray["propertyActualUse" . ($this->pl + 1)] = $landActualUses->getDescription(); //} //else{ // $this->formArray["propertyActualUse".($this->pl+1)] = $land->getActualUse(); //} $this->formArray["propertyAdjMrktVal" . ($this->pl + 1)] = $land->getAdjustedMarketValue(); $this->formArray["level" . ($this->pl + 1)] = $land->getAssessmentLevel(); $this->formArray["assessedValue" . ($this->pl + 1)] = $land->getAssessedValue(); $this->formArray["propertyAdjMrktValTotal"] = $this->formArray["propertyAdjMrktValTotal"] + toFloat($land->getAdjustedMarketValue()); $this->formArray["propertyTotal"] = $this->formArray["propertyTotal"] + toFloat($land->getAssessedValue()); /* $summkind = ''; $summuse = ''; $summadj = 0; $summlvl = 0; $summasv = 0; */ //if ($summuse <> $landActualUses->getDescription()) { //Printing of Property Assessment Summ $thislvl = (double) $land->getAssessmentLevel(); $thisuse = $landActualUses->getDescription(); if ($summlvl != $thislvl || $summuse != $thisuse) { if ($summasv > 0) { $summcount++; $this->formArray["summstart"] -= 14; $offset = $this->formArray["summstart"]; $summitems .= '<textitem xpos="55" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . 'LAND' . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="155" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . htmlentities($summuse) . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="405" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summadj, 2) . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="475" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summlvl, 2) . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="545" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summasv, 2) . '</textitem>' . "\r\n"; $summitems .= '<lineitem x1="50" y1="' . ($offset - 5) . '" x2="550" y2="' . ($offset - 5) . '">blurb</lineitem>'; } $summuse = $thisuse; $summlvl = $thislvl; $summadj = 0; $summasv = 0; } $summadj += (double) $land->getAdjustedMarketValue(); $summasv += toFloat($land->getAssessedValue()); //(double)$land->getAssessedValue(); } $l++; $this->pl++; } //This is for the Value Adjustment Factor if ($markval > 0) { $adjcount++; $this->formArray["adjstart"] -= 14; $offset = $this->formArray["adjstart"]; $adjitems .= '<textitem xpos="147" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($markval, 2) . ' (L)' . '</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="155" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . $adjfact . '</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="405" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($percadj) . '%</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="475" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($valuadj, 2) . '</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="545" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($adjmark, 2) . '</textitem>' . "\r\n"; $adjitems .= '<lineitem x1="50" y1="' . ($offset - 5) . '" x2="550" y2="' . ($offset - 5) . '">blurb</lineitem>'; } //EN - This is for the Property Assesment Summary if ($summasv > 0) { //EN 20090930 change summasv to markval (reversed 20091001) $summcount++; $this->formArray["summstart"] -= 14; $offset = $this->formArray["summstart"]; $summitems .= '<textitem xpos="55" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . 'LAND' . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="155" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . htmlentities($summuse) . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="405" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summadj, 2) . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="475" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summlvl, 2) . '</textitem>' . "\r\n"; // Inserted 08222008 $summasv = round($summadj * ($summlvl / 100), -1); //EN - round to nearest ten peso 2009-09-30 //EN - change $adjmark to $summadj 2009-09-30 $summitems .= '<textitem xpos="545" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summasv, 2) . '</textitem>' . "\r\n"; $summitems .= '<lineitem x1="50" y1="' . ($offset - 5) . '" x2="550" y2="' . ($offset - 5) . '">blurb</lineitem>'; } // 5 change to 11 for ($ll = $l; $ll < 11; $ll++) { $this->formArray["landstart"] -= 19; $offset = $this->formArray["landstart"]; $landitems .= '<lineitem x1="50" y1="' . ($offset - 8) . '" x2="550" y2="' . ($offset - 8) . '">blurb</lineitem>'; } $this->formArray["adjcount"] += $adjcount; $this->formArray["adjitems"] .= $adjitems; $this->formArray["summcount"] += $summcount; $this->formArray["summitems"] .= $summitems; $this->formArray["landitems"] = $landitems; //if ($mixedUnits) { if ($finalUnit == 'has.') { $this->formArray["totalarea"] = number_format($totalarea / 10000, 4) . ' has.'; } else { $this->formArray["totalarea"] = number_format($totalarea, 2) . ' sqm.'; } // $this->formArray["totalarea"] = number_format($totalarea,4); } $this->formArray["landTotal"] = $landTotal; }
function updateStatus($statusIDArray = "") { $rows = 0; $this->selectRecords(); foreach ($this->arrayList as $key => $value) { $value->status = "inactive"; $value->updateRecord(); } foreach ($statusIDArray as $key => $value) { $landSubclasses = new LandSubclasses(); $landSubclasses->selectRecord($value); $landSubclasses->status = "active"; $landSubclasses->updateRecord(); $rows++; } return $rows; }
function CreateNewRPU_AFS_TDGenRevBrgy($odID, $userID = "", $transactionCode = "", $copyOwner = true, $copyAFS = true, $copyTD = true) { $link = mysql_connect(MYSQLDBHOST, MYSQLDBUSER, MYSQLDBPWD); mysql_select_db(MYSQLDBNAME, $link); $sql = "select Person.firstName, Person.lastName from Person, Owner, OwnerPerson " . "where Person.personID = OwnerPerson.personID and OwnerPerson.ownerID = Owner.ownerID and Owner.odID = " . $odID; $rs = mysql_query($sql, $link); $prevowners = ''; while ($row = mysql_fetch_assoc($rs)) { $prevowners .= $row['firstName'] . ' ' . $row['lastName'] . ', '; } $prevowners = substr($prevowners, 0, strlen($prevowners) - 2); $sql = "select AFS.totalAssessedValue from AFS where AFS.odID = " . $odID; $rs = mysql_query($sql, $link); $prevassdval = 0; if ($row = mysql_fetch_assoc($rs)) { $prevassdval = $row['totalAssessedValue']; } $od = new OD(); $od->selectRecord($odID); unset($od->oldODArray); $od->setTransactionCode($transactionCode); $od->setOldODArray($odID); // create new OD $ownerID = $od->owner->getOwnerID(); $newOdID = $od->insertRecord(); $newOwnerID = $od->newOwnerID; $od->setDomDocument(); // associate existing Owner to new OD $owner = new Owner(); $owner->selectRecord($ownerID); if (count($owner->personArray)) { foreach ($owner->personArray as $personKey => $personValue) { if ($copyOwner) { $owner->insertOwnerPerson($newOwnerID, $personValue->getPersonID()); } } } if (count($owner->companyArray)) { foreach ($owner->companyArray as $companyKey => $companyValue) { if ($copyOwner) { $owner->insertOwnerCompany($newOwnerID, $companyValue->getCompanyID()); } } } // create new AFS and associate existing properties to new AFS $afs = new AFS(); $afsID = $afs->checkAfsID($odID); $afs->selectRecord($afsID); $afs->setOdID($newOdID); $afs->effectivity = date("Y") + 1; // new arpNumber is blank //$afs->arpNumber = ""; // retain PIN except for Consolidation and Subdivision //if($transactionCode=="SD" || $transactionCode=="CS"){ $afs->propertyIndexNumber = ""; //} $afs->setDomDocument(); $newAFSID = $afs->insertRecord(); $afs->arpNumber = '(' . $newAFSID . ')'; $afs->updateRecord(); if ($copyAFS) { if ($copyTD) { $td = new TD(); $td->taxDeclarationNumber = $afs->arpNumber; $td->afsID = $newAFSID; $td->previousOwner = $prevowners; $td->previousAssessedValue = $prevassdval; $td->setDomDocument(); $newTDID = $td->insertRecord(); } if (count($afs->landArray)) { foreach ($afs->landArray as $landKey => $landValue) { $landValue->setPropertyID(""); $landValue->setAfsID($newAFSID); $landValue->propertyAdministrator->setPersonID(""); // set unitValue from SubClass $landSubclasses = new LandSubclasses(); $landSubclasses->selectRecord(intVal($landValue->subClass)); $landValue->setUnitValue($landSubclasses->getValue()); // set assessmentLevel from ActualUse $landActualUses = new LandActualUses(); $landActualUses->selectRecord(intVal($landValue->actualUse)); $landValue->setAssessmentLevel($landActualUses->getValue()); $landValue->calculateMarketValue(); $landValue->calculateValueAdjustment(); $landValue->calculateAdjustedMarketValue(); $landValue->calculateAssessedValue(); $landValue->memoranda = GENERALREVISION_DEFAULT_MEMORANDA; $landValue->appraisedByDate = ""; $landValue->recommendingApprovalDate = ""; $landValue->approvedByDate = ""; $newP = $landValue->insertRecord(); } } if (count($afs->plantsTreesArray)) { foreach ($afs->plantsTreesArray as $plantsTreesKey => $plantsTreesValue) { $plantsTreesValue->setPropertyID(""); $plantsTreesValue->setAfsID($newAFSID); $plantsTreesValue->propertyAdministrator->setPersonID(""); // set unitPrice from ProductClass $plantsTreesClasses = new PlantsTreesClasses(); $plantsTreesClasses->selectRecord(intVal($plantsTreesValue->productClass)); $plantsTreesValue->setUnitPrice($plantsTreesClasses->getValue()); // set assessmentLevel from ActualUse $plantsTreesActualUses = new PlantsTreesActualUses(); $plantsTreesActualUses->selectRecord(intVal($plantsTreesValue->actualUse)); $plantsTreesValue->setAssessmentLevel($plantsTreesActualUses->getValue()); $plantsTreesValue->calculateMarketValue(); $plantsTreesValue->calculateValueAdjustment(); $plantsTreesValue->calculateAdjustedMarketValue(); $plantsTreesValue->calculateAssessedValue(); $plantsTreesValue->memoranda = GENERALREVISION_DEFAULT_MEMORANDA; $plantsTreesValue->appraisedByDate = ""; $plantsTreesValue->recommendingApprovalDate = ""; $plantsTreesValue->approvedByDate = ""; $newP = $plantsTreesValue->insertRecord(); } } if (count($afs->improvementsBuildingsArray)) { foreach ($afs->improvementsBuildingsArray as $improvementsBuildingsKey => $improvementsBuildingsValue) { $improvementsBuildingsValue->setPropertyID(""); $improvementsBuildingsValue->setAfsID($newAFSID); $improvementsBuildingsValue->propertyAdministrator->setPersonID(""); // set unitValue from BuildingClassification $improvementsBuildingsClasses = new ImprovementsBuildingsClasses(); $improvementsBuildingsClasses->selectRecord(intVal($improvementsBuildingsValue->buildingClassification)); $improvementsBuildingsValue->setUnitValue($improvementsBuildingsClasses->getValue()); // set assessmentLevel from ActualUse $improvementsBuildingsActualUses = new ImprovementsBuildingsActualUses(); $improvementsBuildingsActualUses->selectRecord(intVal($improvementsBuildingsValue->actualUse)); $improvementsBuildingsValue->setAssessmentLevel($improvementsBuildingsActualUses->getValue()); $improvementsBuildingsValue->calculateMarketValue(); $improvementsBuildingsValue->calculateAccumulatedDepreciation(); $improvementsBuildingsValue->calculatedDepreciatedMarketValue(); $improvementsBuildingsValue->calculateAdjustedMarketValue(); $improvementsBuildingsValue->calculateAssessedValue(); $improvementsBuildingsValue->memoranda = GENERALREVISION_DEFAULT_MEMORANDA; $improvementsBuildingsValue->appraisedByDate = ""; $improvementsBuildingsValue->recommendingApprovalDate = ""; $improvementsBuildingsValue->approvedByDate = ""; $newP = $improvementsBuildingsValue->insertRecord(); } } if (count($afs->machineriesArray)) { foreach ($afs->machineriesArray as $machineriesKey => $machineriesValue) { $machineriesValue->setPropertyID(""); $machineriesValue->setAfsID($newAFSID); $machineriesValue->propertyAdministrator->setPersonID(""); // set assessmentLevel from ActualUse $machineriesActualUses = new MachineriesActualUses(); $machineriesActualUses->selectRecord(intVal($machineriesValue->actualUse)); $machineriesValue->setAssessmentLevel($machineriesActualUses->getValue()); $machineriesValue->calculateMarketValue(); $machineriesValue->calculateDepreciatedMarketValue(); $machineriesValue->calculateAdjustedMarketValue(); $machineriesValue->calculateAssessedValue(); $machineriesValue->memoranda = GENERALREVISION_DEFAULT_MEMORANDA; $machineriesValue->appraisedByDate = ""; $machineriesValue->recommendingApprovalDate = ""; $machineriesValue->approvedByDate = ""; $newP = $machineriesValue->insertRecord(); } } } $sql = "update AFS set archive = 'true' where AFS.odID = " . $odID; mysql_query($sql, $link); $sql = "update OD set archive = 'true' where OD.odID = " . $odID; mysql_query($sql, $link); $sql = "update TD set archive = 'true' where TD.afsID = " . $afsID; mysql_query($sql, $link); mysql_close($link); return $newOdID; echo "OD - " . $odID . "->" . $newOdID . "<br>"; echo "Owner - " . $ownerID . "->" . $newOwnerID . "<br>"; echo "AFS - " . $afsID . "->" . $newAFSID . "<br>" . $newP; }
function displayLandList($landList) { if (count($landList)) { // NCC Modification checked and implemented by K2 : November 21, 2005 // details: // added lines 145 to 151 with lines 146 and 147 commented out $items = ''; //$offset = 470; //$fp = fopen("/home/site/log/td.log","w+"); $mv = 0; $al = 0; $av = 0; foreach ($landList as $lkey => $land) { // 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(); } // just in case subClass and actualUse needs to be drawn from land // 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(); $landActualUsesReportCode = $landActualUses->getReportCode(); } else { $landActualUsesDescription = $land->getActualUse(); $landActualUsesCode = $land->getActualUse(); $landActualUsesReportCode = $landActualUses->getReportCode(); } // NCC Modification checked and implemented by K2 : November 21, 2005 // details: // - changed `if($this->formArray["p"] <= 3)` to `if(...<=10)` in line 200 // - opted not to comment out if() line as done in NCC version // - added lines 201 to 228 // - added lines 255 to 275 commenting out lines 273 and 274 if ($this->formArray["p"] <= 10) { $lvl = number_format($land->getAssessmentLevel(), 2); if ($al != $lvl) { if ($av > 0) { $this->formArray["ypos"] -= 13; $offset = $this->formArray["ypos"]; $items .= "<textitem xpos=\"25\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"left\">" . "Land" . "</textitem>"; $items .= "<textitem xpos=\"115\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"9\" align=\"left\">" . $ld . "</textitem>"; $items .= "<textitem xpos=\"337\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . number_format($mv, 2) . "</textitem>"; // danny : changed $al to $lvl and added '%' suffix in xml $items .= "<textitem xpos=\"430\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . $lvl . "%</textitem>"; $items .= "<textitem xpos=\"558\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . number_format($av, 2) . "</textitem>"; $offsetx = $offset - 3; $items .= "<lineitem x1=\"25\" y1=\"" . $offsetx . "\" x2=\"105\" y2=\"" . $offsetx . "\">blurb</lineitem>"; $items .= "<lineitem x1=\"115\" y1=\"" . $offsetx . "\" x2=\"228\" y2=\"" . $offsetx . "\">blurb</lineitem>"; $items .= "<lineitem x1=\"244\" y1=\"" . $offsetx . "\" x2=\"337\" y2=\"" . $offsetx . "\">blurb</lineitem>"; $items .= "<lineitem x1=\"358\" y1=\"" . $offsetx . "\" x2=\"445\" y2=\"" . $offsetx . "\">blurb</lineitem>"; $items .= "<lineitem x1=\"457\" y1=\"" . $offsetx . "\" x2=\"558\" y2=\"" . $offsetx . "\">blurb</lineitem>"; } $av = 0; $mv = 0; // danny = changed `$al = $lvl` back to 0 .. don't understand why $al's need to be compared. $al = 0; } $ld = $landClassesDescription; $mv += $land->getAdjustedMarketValue(); $av += un_number_format($land->getAssessedValue()); $p = $this->formArray["p"]; $this->formArray["kind" . $p] = $land->getKind(); $this->formArray["classification" . $p] = $landClassesDescription; $this->formArray["landActualUse" . $p] = $land->getActualUse(); $this->formArray["marketValue" . $p] = formatCurrency($land->getMarketValue()); $this->formArray["assessmentLevel" . $p] = $land->getAssessmentLevel(); $this->formArray["assessedValue" . $p] = formatCurrency($land->getAssessedValue()); } else { if ($this->formArray["p"] > 10) { $this->formArray["othersCount"]++; $this->formArray["othersMV"] += toFloat($land->getMarketValue()); $this->formArray["othersAV"] += toFloat($land->getAssessedValue()); $this->formArray["kindOthers"] = "Plus " . $this->formArray["othersCount"] . " other(s): P" . formatCurrency($this->formArray["othersMV"]) . " (MV), P" . formatCurrency($this->formArray["othersAV"]) . " (AV)"; /* if($this->formArray["kindOthers"]!="") $this->formArray["kindOthers"] .= "; "; if($this->formArray["kindOthers"]==""){ $this->formArray["kindOthers"] = "Others: "; } $this->formArray["kindOthers"] .= $land->getKind(); $this->formArray["kindOthers"] .= " MV=P".formatCurrency($land->getMarketValue()); $this->formArray["kindOthers"] .= " AV=P".formatCurrency($land->getAssessedValue()); */ } } $this->formArray["totalMarketValue"] += toFloat($land->getMarketValue()); $this->formArray["totalAssessedValue"] += toFloat($land->getAssessedValue()); $this->formArray["p"]++; } if ($av > 0) { $this->formArray["ypos"] -= 13; $offset = $this->formArray["ypos"]; $items .= "<textitem xpos=\"25\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"left\">" . "Land" . "</textitem>"; $items .= "<textitem xpos=\"115\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"9\" align=\"left\">" . $ld . "</textitem>"; $items .= "<textitem xpos=\"337\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . number_format($mv, 2) . "</textitem>"; $items .= "<textitem xpos=\"430\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . $lvl . "%</textitem>"; $items .= "<textitem xpos=\"558\" ypos=\"" . $offset . "\" font=\"Helvetica\" size=\"10\" align=\"right\">" . number_format($av, 2) . "</textitem>"; $offsetx = $offset - 3; $items .= "<lineitem x1=\"25\" y1=\"" . $offsetx . "\" x2=\"105\" y2=\"" . $offsetx . "\">blurb</lineitem>"; $items .= "<lineitem x1=\"115\" y1=\"" . $offsetx . "\" x2=\"228\" y2=\"" . $offsetx . "\">blurb</lineitem>"; $items .= "<lineitem x1=\"244\" y1=\"" . $offsetx . "\" x2=\"337\" y2=\"" . $offsetx . "\">blurb</lineitem>"; $items .= "<lineitem x1=\"358\" y1=\"" . $offsetx . "\" x2=\"445\" y2=\"" . $offsetx . "\">blurb</lineitem>"; $items .= "<lineitem x1=\"457\" y1=\"" . $offsetx . "\" x2=\"558\" y2=\"" . $offsetx . "\">blurb</lineitem>"; } //fwrite($fp,$items."\r\n"); //fclose($fp); $this->formArray["landitems"] = $items; } }
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 Main() { switch ($this->formArray["formAction"]) { case "edit": $this->tpl->set_var("MessageBlock", ""); $LandSubclassesDetails = new SoapObject(NCCBIZ . "LandSubclassesDetails.php", "urn:Object"); if (!($xmlStr = $LandSubclassesDetails->getLandSubclassesDetails($this->formArray["landSubclassesID"]))) { $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 { $landSubclasses = new LandSubclasses(); $landSubclasses->parseDomDocument($domDoc); $this->formArray["landSubclassesID"] = $landSubclasses->getLandSubclassesID(); $this->formArray["code"] = $landSubclasses->getCode(); $this->formArray["description"] = $landSubclasses->getDescription(); $this->formArray["value"] = $landSubclasses->getValue(); $this->formArray["status"] = $landSubclasses->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", ""); } $LandSubclassesEncode = new SoapObject(NCCBIZ . "LandSubclassesEncode.php", "urn:Object"); if ($this->formArray["landSubclassesID"] != "") { $LandSubclassesDetails = new SoapObject(NCCBIZ . "LandSubclassesDetails.php", "urn:Object"); if (!($xmlStr = $LandSubclassesDetails->getLandSubclassesDetails($this->formArray["landSubclassesID"]))) { 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 { $landSubclasses = new LandSubclasses(); $landSubclasses->parseDomDocument($domDoc); $landSubclasses->setLandSubclassesID($this->formArray["landSubclassesID"]); $landSubclasses->setCode($this->formArray["code"]); $landSubclasses->setDescription($this->formArray["description"]); $landSubclasses->setValue($this->formArray["value"]); $landSubclasses->setStatus($this->formArray["status"]); $landSubclasses->setDomDocument(); $doc = $landSubclasses->getDomDocument(); $xmlStr = $doc->dump_mem(true); if (!($ret = $LandSubclassesEncode->updateLandSubclasses($xmlStr))) { exit("error update"); } } } } else { $landSubclasses = new LandSubclasses(); $landSubclasses->setLandSubclassesID($this->formArray["landSubclassesID"]); $landSubclasses->setCode($this->formArray["code"]); $landSubclasses->setDescription($this->formArray["description"]); $landSubclasses->setValue($this->formArray["value"]); $landSubclasses->setStatus($this->formArray["status"]); $landSubclasses->setDomDocument(); $doc = $landSubclasses->getDomDocument(); $xmlStr = $doc->dump_mem(true); if (!($ret = $LandSubclassesEncode->saveLandSubclasses($xmlStr))) { exit("error save"); } } $this->formArray["landSubclassesID"] = $ret; header("location: LandSubclassesClose.php" . $this->sess->url("") . $this->sess->add_query(array("landSubclassesID" => $ret))); //header("location: LandSubclassesEncode.php"); exit; break; case "cancel": header("location: LandSubclassesClose.php" . $this->sess->url("") . $this->sess->add_query(array("landSubclassesID" => $ret))); //header("location: LandSubclassesList.php"); exit; break; default: $this->tpl->set_block("rptsTemplate", "LandSubclassesID", "LandSubclassesIDBlock"); $this->tpl->set_var("LandSubclassesIDBlock", ""); $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 displayLandList($landList) { $landTotal = 0; if (count($landList)) { $l = 0; $landitems = ''; $adjitems = ''; $totalarea = 0; $adjcount = $this->formArray["adjcount"]; $adjfact = ''; $percadj = 0; $markval = 0; $valuadj = 0; $adjmark = 0; $summcount = $this->formArray["summcount"]; $summuse = ''; $summadj = 0; $summlvl = 0; $summasv = 0; foreach ($landList as $key => $land) { if ($this->pl == 0) { //$this->formArray["arpNumber"] = $land->getArpNumber(); //$this->formArray["propertyIndexNumber"] = $land->getPropertyIndexNumber(); $this->formArray["octTctNumber"] = $land->getOctTctNumber(); $this->formArray["surveyNumber"] = $land->getSurveyNumber(); $this->formArray["north"] = $land->getNorth(); $this->formArray["east"] = $land->getEast(); $this->formArray["south"] = $land->getSouth(); $this->formArray["west"] = $land->getWest(); //$this->formArray["taxability"] = $land->getTaxability(); //$this->formArray["effectivity"] = $land->getEffectivity(); $this->formArray["memoranda"] = $land->getMemoranda(); if (is_a($land->propertyAdministrator, Person)) { if ($land->propertyAdministrator->getLastName() != "") { $this->formArray["administrator"] = $land->propertyAdministrator->getFullName(); } if (is_a($land->propertyAdministrator->addressArray[0], "address")) { $address1 = $land->propertyAdministrator->addressArray[0]->getNumber(); if ($address1 != "") { $address1 .= " "; } $address1 .= $land->propertyAdministrator->addressArray[0]->getStreet(); if ($address1 != "") { $address1 .= ", "; } $address1 .= $land->propertyAdministrator->addressArray[0]->getBarangay(); $address2 = $land->propertyAdministrator->addressArray[0]->getDistrict(); if ($address2 != "") { $address2 .= ", "; } $address2 .= $land->propertyAdministrator->addressArray[0]->getMunicipalityCity(); if ($address2 != "") { $address2 .= ", "; } $address2 .= $land->propertyAdministrator->addressArray[0]->getProvince(); $this->formArray["adminAddress1"] = $address1; $this->formArray["adminAddress2"] = $address2; } $this->formArray["adminTelno"] = $land->propertyAdministrator->getTelephone(); } // recommendingApproval if (is_numeric($land->recommendingApproval)) { $recommendingApproval = new Person(); $recommendingApproval->selectRecord($land->recommendingApproval); $this->formArray["recommendingApproval"] = $recommendingApproval->getFullName(); $this->recommendingApproval = $recommendingApproval->getFullName(); } else { $recommendingApproval = $land->recommendingApproval; $this->formArray["recommendingApproval"] = $recommendingApproval; $this->recommendingApproval = $recommendingApproval; } $this->formArray["dateRecommendingApproval"] = $land->getRecommendingApprovalDate(); // approvedBy if (is_numeric($land->approvedBy)) { $approvedBy = new Person(); $approvedBy->selectRecord($land->approvedBy); $this->formArray["approvedBy"] = $approvedBy->getFullName(); $this->approvedBy = $approvedBy->getFullName(); } else { $approvedBy = $land->approvedBy; $this->formArray["approvedBy"] = $approvedBy; $this->approvedBy = $approvedBy; } $this->formArray["dateApprovedBy"] = $land->getApprovedByDate(); // appraisedBy (assessedBy) if (is_numeric($land->appraisedBy)) { $appraisedBy = new Person(); $appraisedBy->selectRecord($land->appraisedBy); $this->formArray["assessedBy"] = $appraisedBy->getFullName(); $this->appraisedBy = $appraisedBy->getFullName(); } else { $appraisedBy = $land->appraisedBy; $this->formArray["assessedBy"] = $appraisedBy; $this->appraisedBy = $appraisedBy; } $this->formArray["dateAssessedBy"] = $land->getAppraisedByDate(); } $this->formArray["landstart"] -= 19; $offset = $this->formArray["landstart"]; if ($l < 5) { // classification $landClasses = new LandClasses(); if (is_numeric($land->getClassification())) { $landClasses->selectRecord($land->getClassification()); $this->formArray["classification" . ($l + 1)] = $landClasses->getDescription(); } else { $this->formArray["classification" . ($l + 1)] = $land->getClassification(); } $landitems .= '<textitem xpos="55" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . $this->formArray["classification" . ($l + 1)] . '</textitem>' . "\r\n"; // subClass $landSubclasses = new LandSubclasses(); if (is_numeric($land->getSubClass())) { $landSubclasses->selectRecord($land->getSubClass()); $this->formArray["subClass" . ($l + 1)] = $landSubclasses->getDescription(); } else { $this->formArray["subClass" . ($l + 1)] = $land->getSubClass(); } $landitems .= '<textitem xpos="125" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . $this->formArray["subClass" . ($l + 1)] . '</textitem>' . "\r\n"; $this->formArray["area" . ($l + 1)] = $land->getArea() . " " . $this->getUnit($land->getUnit); $totalarea += (double) $land->getArea(); $landitems .= '<textitem xpos="297" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . $this->formArray["area" . ($l + 1)] . '</textitem>' . "\r\n"; // actualUse $landActualUses = new LandActualUses(); if (is_numeric($land->getActualUse())) { $landActualUses->selectRecord($land->getActualUse()); $this->formArray["landActualUse" . ($l + 1)] = $landActualUses->getDescription(); } else { $this->formArray["landActualUse" . ($l + 1)] = $land->getActualUse(); } $landitems .= '<textitem xpos="305" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . $this->formArray["landActualUse" . ($l + 1)] . '</textitem>' . "\r\n"; $this->formArray["unitValue" . ($l + 1)] = $land->getUnitValue(); $landitems .= '<textitem xpos="437" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . $this->formArray["unitValue" . ($l + 1)] . '</textitem>' . "\r\n"; $this->formArray["landMrktVal" . ($l + 1)] = number_format($land->getMarketValue(), 2); $landitems .= '<textitem xpos="540" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . $this->formArray["landMrktVal" . ($l + 1)] . '</textitem>' . "\r\n"; $landTotal = $landTotal + toFloat($land->getMarketValue()); $landitems .= '<lineitem x1="50" y1="' . ($offset - 8) . '" x2="550" y2="' . ($offset - 8) . '">blurb</lineitem>'; } if ($this->pl < 5) { if ($percadj != (double) $land->getPercentAdjustment()) { if ($markval > 0) { $adjcount++; $this->formArray["adjstart"] -= 14; $offset = $this->formArray["adjstart"]; $adjitems .= '<textitem xpos="147" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($markval, 2) . ' (L)' . '</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="155" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . $adjfact . '</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="405" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($percadj, 2) . '</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="475" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($valuadj, 2) . '</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="545" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($adjmark, 2) . '</textitem>' . "\r\n"; $adjitems .= '<lineitem x1="50" y1="' . ($offset - 5) . '" x2="550" y2="' . ($offset - 5) . '">blurb</lineitem>'; } $percadj = (double) $land->getPercentAdjustment(); $adjfact = $land->getAdjustmentFactor(); $markval = 0; $valuadj = 0; $adjmark = 0; } $markval += (double) $land->getMarketValue(); $valuadj += (double) $land->getValueAdjustment(); $adjmark += (double) $land->getAdjustedMarketValue(); $this->formArray["valAdjFacMrktVal" . ($this->pl + 1)] = $land->getMarketValue(); $this->formArray["adjFacTxt" . ($this->pl + 1)] = $land->getAdjustmentFactor(); $this->formArray["adjFacInt" . ($this->pl + 1)] = "L"; $this->formArray["adjustment" . ($this->pl + 1)] = $land->getPercentAdjustment(); $this->formArray["valueAdjustment" . ($this->pl + 1)] = $land->getValueAdjustment(); $this->formArray["valAdjFacAdjMrktVal" . ($this->pl + 1)] = $land->getAdjustedMarketValue(); $this->formArray["valAdjFacTotal"] = $this->formArray["valAdjFacTotal"] + toFloat($land->getAdjustedMarketValue()); } if ($this->pl < 5) { $this->formArray["kind" . ($this->pl + 1)] = "Land"; //if(is_numeric($land->getActualUse())){ $landActualUses->selectRecord($land->getActualUse()); $this->formArray["propertyActualUse" . ($this->pl + 1)] = $landActualUses->getDescription(); //} //else{ // $this->formArray["propertyActualUse".($this->pl+1)] = $land->getActualUse(); //} $this->formArray["propertyAdjMrktVal" . ($this->pl + 1)] = $land->getAdjustedMarketValue(); $this->formArray["level" . ($this->pl + 1)] = $land->getAssessmentLevel(); $this->formArray["assessedValue" . ($this->pl + 1)] = $land->getAssessedValue(); $this->formArray["propertyAdjMrktValTotal"] = $this->formArray["propertyAdjMrktValTotal"] + toFloat($land->getAdjustedMarketValue()); $this->formArray["propertyTotal"] = $this->formArray["propertyTotal"] + toFloat($land->getAssessedValue()); /* $summkind = ''; $summuse = ''; $summadj = 0; $summlvl = 0; $summasv = 0; */ if ($summuse != $landActualUses->getDescription()) { if ($summasv > 0) { $summcount++; $this->formArray["summstart"] -= 14; $offset = $this->formArray["summstart"]; $summitems .= '<textitem xpos="55" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . 'LAND' . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="155" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . htmlentities($summuse) . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="405" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summadj, 2) . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="475" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summlvl, 2) . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="545" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summasv, 2) . '</textitem>' . "\r\n"; $summitems .= '<lineitem x1="50" y1="' . ($offset - 5) . '" x2="550" y2="' . ($offset - 5) . '">blurb</lineitem>'; } $summuse = $landActualUses->getDescription(); $summlvl = (double) $land->getAssessmentLevel(); $summadj = 0; $summasv = 0; } $summadj += (double) $land->getAdjustedMarketValue(); $summasv += toFloat($land->getAssessedValue()); //(double)$land->getAssessedValue(); } $l++; $this->pl++; } if ($markval > 0) { $adjcount++; $this->formArray["adjstart"] -= 14; $offset = $this->formArray["adjstart"]; $adjitems .= '<textitem xpos="147" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($markval, 2) . ' (L)' . '</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="155" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . $adjfact . '</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="405" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($percadj, 2) . '</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="475" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($valuadj, 2) . '</textitem>' . "\r\n"; $adjitems .= '<textitem xpos="545" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($adjmark, 2) . '</textitem>' . "\r\n"; $adjitems .= '<lineitem x1="50" y1="' . ($offset - 5) . '" x2="550" y2="' . ($offset - 5) . '">blurb</lineitem>'; } if ($summasv > 0) { $summcount++; $this->formArray["summstart"] -= 14; $offset = $this->formArray["summstart"]; $summitems .= '<textitem xpos="55" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . 'LAND' . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="155" ypos="' . $offset . '" font="Helvetica" size="8" align="left">' . htmlentities($summuse) . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="405" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summadj, 2) . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="475" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summlvl, 2) . '</textitem>' . "\r\n"; $summitems .= '<textitem xpos="545" ypos="' . $offset . '" font="Helvetica" size="8" align="right">' . number_format($summasv, 2) . '</textitem>' . "\r\n"; $summitems .= '<lineitem x1="50" y1="' . ($offset - 5) . '" x2="550" y2="' . ($offset - 5) . '">blurb</lineitem>'; } for ($ll = $l; $ll < 5; $ll++) { $this->formArray["landstart"] -= 19; $offset = $this->formArray["landstart"]; $landitems .= '<lineitem x1="50" y1="' . ($offset - 8) . '" x2="550" y2="' . ($offset - 8) . '">blurb</lineitem>'; } $this->formArray["adjcount"] += $adjcount; $this->formArray["adjitems"] .= $adjitems; $this->formArray["summcount"] += $summcount; $this->formArray["summitems"] .= $summitems; $this->formArray["landitems"] = $landitems; $this->formArray["totalarea"] = number_format($totalarea, 4); } $this->formArray["landTotal"] = $landTotal; }
function displayLandList($landList) { if (count($landList)) { foreach ($landList as $lkey => $land) { // 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(); } //edited May 27, 2008 // just in case subClass and actualUse needs to be drawn from land // 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(); $landActualUsesReportCode = $landActualUses->getReportCode(); } else { $landActualUsesDescription = $land->getActualUse(); $landActualUsesCode = $land->getActualUse(); $landActualUsesReportCode = $landActualUses->getReportCode(); } // edited this code from (3 to 8) if ($this->formArray["p"] <= 24) { $p = $this->formArray["p"]; $this->formArray["kind" . $p] = $land->getKind(); //edited May 27, 2008 //$this->formArray["classification".$p] = $land->getDescription(); $this->formArray["classification" . $p] = $landClassesDescription; $this->formArray["landActualUses" . $p] = $landActualUsesDescription; //edited May 31, 2008 $this->formArray["propertyMarketValue" . $p] = un_number_format($land->getAdjustedMarketValue()); $this->formArray["assessmentLevel" . $p] = un_number_format($land->getAssessmentLevel()); $this->formArray["assessedValue" . $p] = un_number_format($land->getAssessedValue()); $this->formArray["area" . $p] = $land->getArea(); $this->formArray["unit" . $p] = $land->getUnit(); $this->formArray["totalMarketValue"] += un_number_format($this->formArray["propertyMarketValue" . $p]); $this->formArray["totalAssessedValue"] += un_number_format($this->formArray["assessedValue" . $p]); $this->formArray["p"]++; } } } }