function selectRecordForList($rptopID)
{
if ($rptopID == "") {
return;
}
$this->setDB();
$sql = sprintf("SELECT * FROM %s WHERE rptopID=%s;", RPTOP_TABLE, $rptopID);
$this->db->query($sql);
//echo $sql;
$rptop = new RPTOP();
if ($this->db->next_record()) {
foreach ($this->db->Record as $key => $value) {
switch ($key) {
default:
$this->{$key} = $value;
}
}
///*
$sql = sprintf("SELECT ownerID FROM %s WHERE rptopID = %s;", OWNER_TABLE, $rptopID);
$this->db->query($sql);
//echo $sql;
while ($this->db->next_record()) {
$owner = new Owner();
//echo test;
$owner->selectRecord($this->db->f("ownerID"));
$this->owner = $owner;
}
/*
$sql = sprintf("SELECT * FROM %s WHERE rptopID=%s;",
RPTOPTD_TABLE, $rptopID);
$this->setDB();
//echo $sql;
//*
$this->db->query($sql);
while ($this->db->next_record()) {
$td = new TD;
$td->selectRecord($this->db->f("tdID"));
$this->tdArray[] = $td;
}
$this->setDomDocument();
//*/
/*
$tdRecords = new TDRecords;
$tdRecords->selectRecords($this->rptopID);
$this->tdArray = $tdRecords->getArrayList();
//*/
$this->setDomDocument();
$ret = true;
} else {
$ret = false;
}
return $ret;
}
function selectRecord($odID)
{
if ($odID == "") {
return;
}
$this->setDB();
$sql = sprintf("SELECT * FROM %s WHERE odID=%s;", OD_TABLE, $odID);
$this->db->query($sql);
if ($this->db->next_record()) {
$this->setOdID($this->db->f("odID"));
$this->setLandArea($this->db->f("landArea"));
$this->setHouseTagNumber($this->db->f("houseTagNumber"));
$this->setLotNumber($this->db->f("lotNumber"));
$this->setZoneNumber($this->db->f("zoneNumber"));
$this->setBlockNumber($this->db->f("blockNumber"));
$this->setPsd13($this->db->f("psd13"));
$this->setAffidavitOfOwnership($this->db->f("affidavitOfOwnership"));
$this->setBarangayCertificate($this->db->f("barangayCertificate"));
$this->setLandTagging($this->db->f("landTagging"));
$this->setDateCreated($this->db->f("dateCreated"));
$this->setCreatedBy($this->db->f("createdBy"));
$this->setDateModified($this->db->f("dateModified"));
$this->setModifiedBy($this->db->f("modifiedBy"));
$this->setArchive($this->db->f("archive"));
$this->setTransactionCode($this->db->f("transactionCode"));
$sql = sprintf("SELECT ownerID FROM %s WHERE odID = %s;", OWNER_TABLE, $this->odID);
$this->db->query($sql);
while ($this->db->next_record()) {
$owner = new Owner();
$owner->selectRecord($this->db->f("ownerID"));
$this->owner = $owner;
}
$sql = sprintf("SELECT locationAddressID FROM %s WHERE odID = %s;", LOCATION_TABLE, $this->odID);
$this->db->query($sql);
while ($this->db->next_record()) {
$locationAddress = new LocationAddress();
$locationAddress->selectRecord($this->db->f("locationAddressID"));
$this->locationAddress = $locationAddress;
}
$sql = sprintf("SELECT previousOdID FROM %s WHERE presentOdID = %s;", ODHISTORY_TABLE, $this->odID);
$this->db->query($sql);
while ($this->db->next_record()) {
$this->oldODArray[] = $this->db->f("previousOdID");
}
$this->setDomDocument();
return true;
} else {
return false;
}
}
function addOwnerCompanyRPTOP($rptopID, $ownerID, $companyIDArray)
{
$owner = new Owner();
$owner->selectRecord($ownerID);
$ctr = 0;
foreach ($companyIDArray as $key => $value) {
$owner->deleteOwnerCompany($value);
$owner->insertOwnerCompany($ownerID, $value);
$rptop = new RPTOP();
$rptop->selectRecordForList($rptopID);
$year = $rptop->getTaxableYear();
$tdIDArray = $this->getTDListOf($value, "Company", $year);
foreach ($tdIDArray as $tdKey => $tdValue) {
//echo $tdValue."<br>";
$rptop->insertRptopTd($rptopID, $tdValue);
$ctr++;
}
unset($rptop);
}
unset($owner);
$ret = $ctr;
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 selectRecords($condition = "")
{
$sql = sprintf("select * from %s %s;", OWNER_TABLE, $condition);
$this->setDB();
$this->db->query($sql);
while ($this->db->next_record()) {
$owner = new Owner();
$owner->selectRecord($this->db->f("ownerID"));
$this->arrayList[] = $owner;
}
if (count($this->arrayList) > 0) {
$this->setDomDocument();
$ret = true;
} else {
$ret = false;
}
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;
}
