function getPlantsTreesList($afsID)
{
$plantsTreesRecords = new PlantsTreesRecords();
$plantsTreesRecords->selectRecords($afsID);
if (!($domDoc = $plantsTreesRecords->getDomDocument())) {
return false;
} else {
$xmlStr = $domDoc->dump_mem(true);
return $xmlStr;
}
}
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;
}