function getFirstPropertyID() { $ImprovementsBuildingsList = new SoapObject(NCCBIZ . "ImprovementsBuildingsList.php", "urn:Object"); if (!($xmlStr = $ImprovementsBuildingsList->getImprovementsBuildingsList($this->formArray["afsID"]))) { return false; } else { if (!($domDoc = domxml_open_mem($xmlStr))) { return false; } else { $improvementsBuildingsRecords = new ImprovementsBuildingsRecords(); $improvementsBuildingsRecords->parseDomDocument($domDoc); $list = $improvementsBuildingsRecords->getArrayList(); foreach ($list as $key => $value) { $propertyIDList[] = $value->propertyID; } sort($propertyIDList); return $propertyIDList[0]; } } }
function selectRecord($afsID, $limit = "", $odID = "") { if ($afsID == "") { if ($odID != "") { $condition = sprintf("WHERE odID='%s'", fixQuotes($odID)); } else { return; } } else { $condition = sprintf("WHERE afsID='%s'", fixQuotes($afsID)); } $this->setDB(); $sql = sprintf("SELECT * FROM %s %s %s;", AFS_TABLE, $condition, $limit); $this->db->query($sql); if ($this->db->next_record()) { $this->afsID = $this->db->f("afsID"); $this->odID = $this->db->f("odID"); $this->arpNumber = $this->db->f("arpNumber"); $this->propertyIndexNumber = $this->db->f("propertyIndexNumber"); $this->taxability = $this->db->f("taxability"); $this->effectivity = $this->db->f("effectivity"); $this->landTotalMarketValue = $this->db->f("landTotalMarketValue"); $this->landTotalAssessedValue = $this->db->f("landTotalAssessedValue"); $this->plantTotalMarketValue = $this->db->f("plantTotalMarketValue"); $this->plantTotalAssessedValue = $this->db->f("plantTotalAssessedValue"); $this->bldgTotalMarketValue = $this->db->f("bldgTotalMarketValue"); $this->bldgTotalAssessedValue = $this->db->f("bldgTotalAssessedValue"); $this->machTotalMarketValue = $this->db->f("machTotalMarketValue"); $this->machTotalAssessedValue = $this->db->f("machTotalAssessedValue"); $this->totalMarketValue = $this->db->f("totalMarketValue"); $this->totalAssessedValue = $this->db->f("totalAssessedValue"); $this->dateCreated = $this->db->f("dateCreated"); $this->createdBy = $this->db->f("createdBy"); $this->dateModified = $this->db->f("dateModified"); $this->modifiedBy = $this->db->f("modifiedBy"); $this->archive = $this->db->f("archive"); $landRecords = new LandRecords(); $landRecords->selectRecords($this->afsID); $this->landArray = $landRecords->getArrayList(); $improvementsBuildingsRecords = new ImprovementsBuildingsRecords(); $improvementsBuildingsRecords->selectRecords($this->afsID); $this->improvementsBuildingsArray = $improvementsBuildingsRecords->getArrayList(); $plantsTreesRecords = new PlantsTreesRecords(); $plantsTreesRecords->selectRecords($this->afsID); $this->plantsTreesArray = $plantsTreesRecords->getArrayList(); $machineriesRecords = new MachineriesRecords(); $machineriesRecords->selectRecords($this->afsID); $this->machineriesArray = $machineriesRecords->getArrayList(); $this->setDomDocument(); $ret = true; } else { $ret = false; } return $ret; }
function removeImprovementsBuildings($improvementsBuildingsIDArray) { $improvementsBuildingsRecords = new ImprovementsBuildingsRecords(); $rows = $improvementsBuildingsRecords->removeRecords($improvementsBuildingsIDArray); return $rows; }