Exemple #1
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;
 }
Exemple #2
0
 function getFirstPropertyID()
 {
     $PlantsTreesList = new SoapObject(NCCBIZ . "PlantsTreesList.php", "urn:Object");
     if (!($xmlStr = $PlantsTreesList->getPlantsTreesList($this->formArray["afsID"]))) {
         return false;
     } else {
         if (!($domDoc = domxml_open_mem($xmlStr))) {
             return false;
         } else {
             $plantsTreesRecords = new PlantsTreesRecords();
             $plantsTreesRecords->parseDomDocument($domDoc);
             $list = $plantsTreesRecords->getArrayList();
             foreach ($list as $key => $value) {
                 $propertyIDList[] = $value->propertyID;
             }
             sort($propertyIDList);
             return $propertyIDList[0];
         }
     }
 }
Exemple #3
0
 function removePlantsTrees($plantsTreesIDArray)
 {
     $plantsTreesRecords = new PlantsTreesRecords();
     $rows = $plantsTreesRecords->removeRecords($plantsTreesIDArray);
     return $rows;
 }