public function getCWRSpeciesTaxon($taxon)
{
global $db;
$query = "SELECT c.CWR_Scientific_Name, c.FPCAT, c.Crop_Code FROM cwr_occurrences_species c \n JOIN species s ON s.Valid_Taxon_ID = c.Valid_Taxon_ID\n where s.Scientific_Name = '" . str_replace("_", " ", $taxon) . "' AND c.FPCAT IS NOT NULL AND s.Main_Crop = 0 LIMIT 1";
$result = $db->getAll($query);
$specie = new Specie();
$specie->setTaxonomy(str_replace("_", " ", $result[0]["CWR_Scientific_Name"]));
$specie->setFPC($result[0]["FPCAT"]);
$specie->setCropCode($result[0]["Crop_Code"]);
return $specie;
}
public function getCWRSpeciesTaxon($taxon)
{
global $db;
//Query para traer taxon
$query = "SELECT s.Valid_Taxon_ID \n\t\tFROM species as s \n\t\twhere s.Scientific_Name = '" . str_replace("_", " ", $taxon) . "' AND s.Main_Crop = 0 LIMIT 1";
$result = $db->getAll($query);
//Query para datos adicionales
$query = "SELECT c.CWR_Scientific_Name, c.FPCAT, c.Crop_Code \n\t\tFROM cwr_occurrences_species as c\n\t\twhere c.Valid_Taxon_ID =" . $result[0]["Valid_Taxon_ID"] . " AND c.FPCAT IS NOT NULL LIMIT 1";
$result = $db->getAll($query);
$specie = new Specie();
$specie->setTaxonomy(str_replace("_", " ", $result[0]["CWR_Scientific_Name"]));
$specie->setFPC($result[0]["FPCAT"]);
$specie->setCropCode($result[0]["Crop_Code"]);
return $specie;
}
