/** * 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; }