function getAfsID($odID) { $afs = new AFS(); if (!($afsID = $afs->checkAfsID($odID))) { return false; } else { return $afsID; } }
function getTDListOf($id, $type, $year) { $owner = new Owner(); //echo("\$ownerIDArray = \$owner->selectOwner".$type."(".$id.");"); eval("\$ownerIDArray = \$owner->selectOwner" . $type . "(" . $id . ");"); if ($ownerIDArray) { $odArray = ""; foreach ($ownerIDArray as $key => $value) { eval("\$odID = \$owner->selectOD" . $type . "({$value});"); if ($odID) { $odArray[] = $odID; } } unset($owner); if ($odArray) { $afsArray = ""; foreach ($odArray as $key => $value) { $afs = new AFS(); $afsIDArray[] = $afs->checkAfsID($value); } unset($afs); if ($afsIDArray) { $tdRecords = new TDRecords(); $tdIDArray = ""; foreach ($afsIDArray as $tkey => $tvalue) { $td = new TD(); if ($td->selectRecord("", $tvalue, "", "", $year)) { $tdIDArray[] = $td->getTdID(); } unset($td); /* $afs = new AFS; $afs->selectRecord($tvalue); //print_r($afs); //echo "<br>"; $landArray = $afs->getLandArray(); $plantsTreesArray = $afs->getPlantsTreesArray(); $improvementsBuildingsArray = $afs->getImprovementsBuildingsArray(); $machineriesArray = $afs->getMachineriesArray(); unset($afs); if ($landArray){ foreach($landArray as $lkey => $lvalue){ //echo($lvalue->getPropertyID()."<br>"); $td = new TD; if ($td->selectRecord("",$lvalue->getPropertyID(),"Land",$year)){ $tdRecords->setArrayList($td); $tdIDArray[] = $td->getTdID(); } unset($td); } } if ($plantsTreesArray){ foreach($plantsTreesArray as $lkey => $lvalue){ //echo($lvalue->getPropertyID()."<br>"); $td = new TD; if ($td->selectRecord("",$lvalue->getPropertyID(),"PlantsTrees",$year)){ $tdRecords->setArrayList($td); $tdIDArray[] = $td->getTdID(); } unset($td); } } if ($improvementsBuildingsArray){ foreach($improvementsBuildingsArray as $lkey => $lvalue){ //echo($lvalue->getPropertyID()."<br>"); $td = new TD; if ($td->selectRecord("",$lvalue->getPropertyID(),"ImprovementsBuildings",$year)){ $tdRecords->setArrayList($td); $tdIDArray[] = $td->getTdID(); } unset($td); } } if ($machineriesArray){ foreach($machineriesArray as $lkey => $lvalue){ //echo($lvalue->getPropertyID()."<br>"); $td = new TD; if ($td->selectRecord("",$lvalue->getPropertyID(),"Machineries",$year)){ $tdRecords->setArrayList($td); $tdIDArray[] = $td->getTdID(); } unset($td); } }*/ } $ret = $tdIDArray; //print_r($tdRecords->getArrayList()); /*if ($tdRecords->getArrayList()){ $tdRecords->setDomDocument(); if(!$domDoc = $tdRecords->getDomDocument()){ return $ret = false; } else { $xmlStr = $domDoc->dump_mem(true); return $ret = $xmlStr; } } else $ret = false;*/ } else { $ret = false; } } else { $ret = false; } } else { $ret = false; } return $ret; }
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 archiveRecords($odIDArray = "", $archiveValue = "", $userID = "") { $od = new OD(); $ret = false; foreach ($odIDArray as $key => $odID) { if ($od->archiveRecord($odID, $archiveValue, $userID)) { // archive AFS $afs = new AFS(); if ($afsID = $afs->checkAfsID($odID)) { $afs->archiveRecord($afsID, $archiveValue, $userID); } // archive TD $td = new TD(); if ($tdID = $td->checkTdID($afsID)) { $td->archiveRecord($tdID, $archiveValue, $userID); } } $ret = true; } return $ret; }
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; }