コード例 #1
0
 public function getCWRConceptbyTaxonName($taxonName)
 {
     global $db;
     $cwrConcept = new CWRConcept();
     $taxon = TaxonMySQL::getInstance()->getTaxonbyName($taxonName);
     if ($taxon != null) {
         $cwrConcept->setTaxon($taxon);
         $query = "SELECT Concept_Level, Concept_Type FROM concepts WHERE Taxon_ID = " . $taxon->getId() . " and Concept_Level not in ('Crop taxa')";
         $result = $db->getAll($query);
         if (!empty($result)) {
             foreach ($result as $r) {
                 $cwrConcept->setConceptLevel($r['Concept_Level']);
                 $cwrConcept->setConceptType($r['Concept_Type']);
             }
         } else {
             $query = "SELECT Concept_Level, Concept_Type FROM concepts WHERE Taxon_ID IN (SELECT Taxon_ID from species where Valid_Taxon_ID = " . $taxon->getId() . " and Valid_Taxon_ID not in (Taxon_ID)) and Concept_Level not in ('Crop taxa')";
             if (!empty($result)) {
                 foreach ($result as $r) {
                     $cwrConcept->setConceptLevel($r['Concept_Level']);
                     $cwrConcept->setConceptType($r['Concept_Type']);
                 }
             }
         }
         return $cwrConcept;
     } else {
         return null;
     }
 }
コード例 #2
0
 public function getCWRConcept($taxonID)
 {
     global $db;
     $cwrConcept = new CWRConcept($taxonID);
     $taxon = TaxonMySQL::getInstance()->getTaxon($taxonID);
     if ($taxon != null) {
         $cwrConcept->setTaxon($taxon);
         $query = "SELECT Concept_Level, Concept_Type FROM concepts WHERE Taxon_ID = {$taxonID} and Concept_Level not in ('Crop taxa')";
         $result = $db->getAll($query);
         if (!empty($result)) {
             foreach ($result as $r) {
                 $cwrConcept->setConceptLevel($r['Concept_Level']);
                 $cwrConcept->setConceptType($r['Concept_Type']);
             }
         }
         $query = "SELECT Pot_Conf, Description FROM Breeding_data WHERE Taxon_ID = {$taxonID} AND Description = 'Graftstock'";
         $result = $db->getAll($query);
         if (!empty($result)) {
             foreach ($result as $r) {
                 $cwrConcept->setConceptLevel($r['Pot_Conf']);
                 $cwrConcept->setConceptType($r['Description']);
             }
         }
         return $cwrConcept;
     } else {
         return null;
     }
 }