public function save(Guest $guest)
{
if (is_null($guest->id())) {
// insert
$stmt = $this->pdo->prepare('INSERT INTO guests
(firstName, lastName, emailAddress, phoneNumber, address, paymentAmount)
VALUES
(:firstName, :lastName, :emailAddress,
:phoneNumber, :address, :paymentAmount)');
} else {
// update
$stmt = $this->pdo->prepare('UPDATE guests
SET firstName = :firstName,
lastName = :lastName,
emailAddress = :emailAddress,
phoneNumber = :phoneNumber,
address = :address,
paymentAmount = :paymentAmount
WHERE id = :guestId');
$stmt->bindValue('guestId', $guest->id());
}
$stmt->bindValue('firstName', $guest->firstName());
$stmt->bindValue('lastName', $guest->lastName());
$stmt->bindValue('emailAddress', $guest->emailAddress());
$stmt->bindValue('phoneNumber', $guest->phoneNumber());
$stmt->bindValue('address', $guest->address());
$stmt->bindValue('paymentAmount', $guest->paymentAmount()->getConvertedAmount());
return $stmt->execute();
}
public function getByGuest(Guest $guest)
{
$stmt = $this->pdo->prepare('SELECT * FROM transactions WHERE guestId = :guestId');
$stmt->bindValue(':guestId', $guest->id());
$stmt->execute();
$res = [];
foreach ($stmt->fetchAll(PDO::FETCH_OBJ) as $transaction) {
$res[] = $this->mapper($transaction);
}
return $res;
}
private function updateGuestInfo(Guest $guest, ParameterBag $input)
{
$guest->setFirstName($input->get('firstName'));
$guest->setLastName($input->get('lastName'));
$guest->setEmailAddress($input->get('emailAddress'));
$guest->setPhoneNumber((int) $input->get('phoneNumber'));
$guest->setAddress($input->get('address'));
$this->guest->save($guest);
return $guest;
}
