public function getAnimals()
{
$db = DbManager::getPDO();
$req = "SELECT * FROM Animal an, Adopt ad WHERE an.idAnimal=ad.idAnimal AND ad.idUser="******"";
$res = $db->query($query);
for ($i = 0; $i < count($res); $i++) {
$animal = Animal::getAnimalArrayFromFetch($res[$i]);
$listUsersAnimals[$animal['idAnimal']] = $animal;
}
return $listUsersAnimals;
}
/**
* @return la liste des animaux à l'adoption
*/
public static function getHomelessAnimals()
{
$db = DbManager::getPDO();
$query = "SELECT * FROM Animal WHERE idState='" . self::$STATE_ADOPTION . "';";
$res = $db->query($query)->fetchAll();
for ($i = 0; $i < count($res); $i++) {
$animal = Animal::getAnimalArrayFromFetch($res[$i]);
$listAnimals[$animal['idAnimal']] = $animal;
}
return $listAnimals;
}
public function getAnimals()
{
$db = DbManager::getPDO();
$query = "SELECT * FROM Animal WHERE idShelter = " . $this->idShelter . " AND idState = " . Animal::$STATE_ADOPTION . ";";
$res = $db->query($query)->fetchAll();
for ($i = 0; $i < count($res); $i++) {
$animal = Animal::getAnimalArrayFromFetch($res[$i]);
$listAnimals[$animal['idAnimal']] = $animal;
}
return $listAnimals;
}