/**
* @param ObjectManager $manager
* @throws \Doctrine\DBAL\DBALException
*/
protected function loadReservations(ObjectManager $manager)
{
echo "\nReservations ... ";
$stmt = $this->connection->executeQuery('SELECT * FROM reservation');
foreach ($stmt->fetchAll() as $record) {
$reservation = new Reservation();
$reservation->setClient($this->getReference('client-' . $record['client_id']));
$reservation->setDestination($this->getReference('destination-' . $record['destination_id']));
$reservation->setUniqid($record['uniqid']);
$reservation->setRoundTrip($record['round_trip']);
$reservation->setNoPax($record['no_pax']);
$reservation->setHotel($record['hotel']);
if ($record['arrival_date']) {
$reservation->setArrivalDate(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['arrival_date'])));
}
$reservation->setArrivalFlightNo($record['arrival_flight_no']);
if ($record['departure_date']) {
$reservation->setDepartureDate(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['departure_date'])));
}
$reservation->setDepartureFlightNo($record['departure_flight_no']);
$reservation->setPrice($record['price']);
$reservation->setComment($record['comment']);
$reservation->setStatus($record['status']);
$reservation->setPaymentDate($record['payment_date']);
$reservation->setCreated(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['created_at'])));
$reservation->setUpdated(\DateTime::createFromFormat('Y-m-d H:i:s', preg_replace('/\\.[0-9]+$/', '', $record['updated_at'])));
$manager->persist($reservation);
$this->addReference("reservation-" . $record['id'], $reservation);
}
}