/**
* Instantiate a Pet from a pet table row
* @param array $row a row of the Pet table
* @return \Pet
*/
public static function constructByRow($row)
{
if (isset($row['id'])) {
$pet = new Pet($row['name'], $row['description'], $row['special_needs'], $row['weight'], $row['species'], $row['breed'], $row['age'], $row['sex'], $row['user_id'], $row['adoption_id'], $row['created'], $row['updated'], $row['visibility'], $row['approved']);
$pet->setId($row['id']);
return $pet;
}
return null;
}
/**
* Get all active pets owned by a user
*
* @param int $id
*
* @return array
*/
public function getActivePetsForUser($id)
{
$ret = [];
// Pet variables
$res_id = null;
$owner_id = null;
$species_id = null;
$name = null;
$experience = null;
$brawn = null;
$guts = null;
$essence = null;
$speed = null;
$focus = null;
$grit = null;
$active = null;
// User variables
$username = null;
$email_address = null;
$description = null;
// Species variables
$species = null;
$type = null;
$stats = null;
$this->getActivePetsForUserStatement->bind_param("i", $id);
$this->getActivePetsForUserStatement->execute();
$this->getActivePetsForUserStatement->bind_result($res_id, $owner_id, $species_id, $name, $experience, $brawn, $guts, $essence, $speed, $focus, $grit, $active, $username, $email_address, $description, $species, $type, $stats);
while ($this->getActivePetsForUserStatement->fetch()) {
$newUser = new User($username, $email_address, $description);
$newUser->setId($owner_id);
$newSpecies = new Species($species, $type, $stats);
$newSpecies->setId($species_id);
$newPet = new Pet($newUser, $newSpecies, $name);
$newPet->setId($res_id);
$newPet->setExperience($experience);
$newPet->setBrawn($brawn);
$newPet->setGuts($guts);
$newPet->setEssence($essence);
$newPet->setSpeed($speed);
$newPet->setFocus($focus);
$newPet->setGrit($grit);
$newPet->setActive(boolval($active));
array_push($ret, $newPet);
}
return $ret;
}
