public function getSpeciesByCropCode()
{
global $db;
$query = "select s.*, c.Crop_code from cwr_occurrences_species c join species s on s.Valid_Taxon_ID = c.Valid_Taxon_ID \n WHERE c.Crop_code in ('avena','bambara','bean','cajanus','cicer','cowpea','daucus','eggplant','eleusine',\n 'faba_bean','helianthus','hordeum','ipomoea','lathyrus','lens','lima_bean','malus','medicago','musa',\n 'pennisetum','pisum','potato','rice','secale','sorghum','triticum','vetch') \n group by s.Taxon_ID order by c.Crop_code";
$result = $db->getAll($query);
$species = array();
foreach ($result as $r) {
// Se obtiene la informacion de la specie de acuerdo al crop code ingresado
$specie = new Specie();
$specie->setTaxonomy($r["Scientific_Name"]);
$specie->setTaxonID($r["Taxon_ID"]);
$specie->setValidTaxonID($r["Valid_Taxon_ID"]);
$specie->setCommonName($r["Common_Name"]);
$specie->setCropCode($r["Crop_code"]);
array_push($species, $specie);
}
return $species;
}
