/**
* Display the view
*/
public function display($tpl = null)
{
$lang = JFactory::getLanguage();
$this->items = $this->get('Items');
$this->pagination = $this->get('Pagination');
$this->state = $this->get('State');
$this->roomTypes = $this->get('RoomTypesOptions');
$this->reservationStatuses = JHotelReservationHelper::getReservationStatuses();
$this->paymentStatuses = JHotelReservationHelper::getPaymentStatuses();
$hotels = $this->get('Hotels');
$this->hotels = checkHotels(JFactory::getUser()->id, $hotels);
//var_dump($this->hotels);
// Check for errors.
$layout = JRequest::getVar("layout");
if (isset($layout)) {
$tpl = $layout;
}
$this->setLayout('default');
JHotelReservationHelper::addSubmenu('reservations');
if (count($errors = $this->get('Errors'))) {
JError::raiseError(500, implode("\n", $errors));
return false;
}
$this->addToolbar();
parent::display($tpl);
}
public function exportToCSV()
{
$this->reservationStatuses = JHotelReservationHelper::getReservationStatuses();
$this->paymentStatuses = JHotelReservationHelper::getPaymentStatuses();
$this->populateState();
$reservations = $this->getItems();
$csv_output = "id;name;hotel;voucher;check in;check out;created at;adults;children;rooms;status;payment status" . "\n";
foreach ($reservations as $item) {
$reservationStatus = $this->reservationStatuses[$item->reservation_status];
$paymentStatus = $this->paymentStatuses[$item->payment_status];
$csv_output .= "{$item->confirmation_id};{$item->first_name} {$item->last_name};{$item->hotel_name};{$item->voucher};{$item->start_date};{$item->end_date};{$item->created};{$item->total_adults};{$item->total_children};{$item->rooms};{$reservationStatus};{$paymentStatus};";
$csv_output .= "\n";
}
ob_clean();
$fileName = "jhotel_reservations_listing";
header("Content-type: application/vnd.ms-excel");
header("Content-disposition: csv" . date("Y-m-d") . ".csv");
header("Content-disposition: filename=" . $fileName . ".csv");
print $csv_output;
}
