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; }