function display($tpl = null)
 {
     $this->config = JBFactory::getConfig();
     $input = JFactory::getApplication()->input;
     AImporter::model('tour');
     $cart = JModelLegacy::getInstance('TourCart', 'bookpro');
     $cart->load();
     $cart->clear();
     $model = new BookProModelTour();
     $id = $input->getInt('id');
     $this->tour = $model->getComplexItem($id);
     $this->itineraries = TourHelper::buildItinerary($id);
     //$this->packages	= $packages;
     $date = TourHelper::getDateFirstInPackagerateFromTourid($this->tour->id);
     $this->date = JFactory::getDate($date)->format(DateHelper::getConvertDateFormat('P'));
     $this->tour->rdate = $this->date;
     $dispatcher = JDispatcher::getInstance();
     //$this->_prepareDocument();
     //		$dispatcher		= JDispatcher::getInstance();
     //		$this->event 	= new stdClass();
     //		JPluginHelper::importPlugin('bookpro');
     //		$results 		= $dispatcher->trigger('onBookproProductAfterTitle', array ($this->tour));
     //		$this->event->afterDisplayTitle=isset($results[0])?$results[0]:null;
     parent::display($tpl);
 }

 /**
  * Print passenger manifest to pdf
  */
 function exportpdf()
 {
     AImporter::model('passengers');
     $app = JFactory::getApplication();
     $input = $app->input;
     AImporter::helper('pdf', 'date');
     $model = new BookproModelpassengers(array('ignore_request' => 0));
     if ($app->isAdmin()) {
         $ticket_view = $this->getView('passengers', 'html', 'BookProView');
     } else {
         $ticket_view = $this->getView('AgentPassengers', 'html', 'BookProView');
         $ticket_view->is_admin = 1;
     }
     $ticket_view->setModel($model, true);
     $ticket_view->setLayout('report');
     ob_start();
     $ticket_view->display();
     $pdf = ob_get_contents();
     ob_end_clean();
     $order = new JObject();
     $order->name = 'Tour_report' . '_export_time_' . JHtml::date('now', 'Y-m-d-H-i-s');
     $order->fontsize = 7;
     PrintPdfHelper::printTicket($pdf, $order, 'P');
     return;
 }

 /**
  * Save subject.
  *
  * @param boolean $apply true state on edit page, false return to browse list
  */
 function save($apply = false)
 {
     $task = $this->getTask();
     JRequest::checkToken() or jexit('Invalid Token');
     $mainframe = JFactory::getApplication();
     $input = $mainframe->input;
     $post = JRequest::get('post');
     $post['desc'] = JRequest::getVar('desc', '', 'post', 'string', JREQUEST_ALLOWRAW);
     $post['jform']['meal'] = implode(';', $post['jform']['meal']);
     //debug($post['jform']); die;
     $db = JFactory::getDbo();
     AImporter::table('itinerary');
     $Table = new TableItinerary($db);
     $Table->bind($post['jform']);
     $Table->store();
     $id = $Table->id;
     if ($id !== false) {
         $mainframe->enqueueMessage(JText::_('Successfully saved'), 'message');
     } else {
         $mainframe->enqueueMessage(JText::_('Save failed'), 'error');
     }
     if ($task != 'save') {
         $mainframe->redirect('index.php?option=com_bookpro&view=itinerary&layout=edit&id=' . $id);
     } else {
         $mainframe->redirect('index.php?option=com_bookpro&view=itineraries');
     }
 }

 protected function populateState($ordering = null, $direction = null)
 {
     AImporter::helper('date');
     parent::populateState();
     $app = JFactory::getApplication();
     $id = JRequest::getVar('id', 0, '', 'int');
     $this->setState('passengerlist.id', $id);
     // Load the filter state.
     $search = $this->getUserStateFromRequest($this->context . '.filter.search', 'filter_search');
     $this->setState('filter.search', $search);
     $order_id = $this->getUserStateFromRequest($this->context . '.filter.order_id', 'filter_order_id', null, 'int');
     $this->setState('filter.order_id', $order_id);
     $tour_id = $this->getUserStateFromRequest($this->context . '.filter.tour_id', 'filter_tour_id', null, 'int');
     $this->setState('filter.tour_id', $tour_id);
     $depart_date = $this->getUserStateFromRequest($this->context . '.filter.depart_date', 'filter_depart_date', null);
     $depart_date = DateHelper::createFromFormatYmd($depart_date);
     $this->setState('filter.depart_date', $depart_date);
     $order_status = $this->getUserStateFromRequest($this->context . '.filter.order_status', 'filter_order_status', null, 'string');
     $this->setState('filter.order_status', $order_status);
     $value = $app->getUserStateFromRequest($this->context . '.ordercol', 'filter_order', $ordering);
     $this->setState('list.ordering', $value);
     $value = $app->getUserStateFromRequest($this->context . '.orderdirn', 'filter_order_Dir', $direction);
     $this->setState('list.direction', $value);
     $fromdate = $this->getUserStateFromRequest($this->context . '.filter.from_date', 'filter_from_date', null, 'string');
     $fromdate = DateHelper::createFromFormatYmd($fromdate);
     $this->setState('filter.from_date', $fromdate);
     $todate = $this->getUserStateFromRequest($this->context . '.filter.to_date', 'filter_to_date', null, 'string');
     $todate = DateHelper::createFromFormatYmd($todate);
     $this->setState('filter.to_date', $todate);
 }

 function exportPDF()
 {
     $app = JFactory::getApplication();
     $input = $app->input;
     AImporter::helper('pdf', 'date');
     AImporter::model('transportreports');
     $model = new BookproModelTransportReports();
     $depart_date = DateHelper::createFromFormatYmd($input->get('filter_depart_date'));
     $state = $model->getState();
     $state->set('list.limit', NULL);
     $state->set('list.start', 0);
     $state->set('list.ordering', 'pickup');
     $state->set('list.direction', 'ASC');
     if ($app->isAdmin()) {
         $ticket_view = $this->getView('Transportreports', 'html', 'BookProView');
     } else {
         $ticket_view = $this->getView('AgentTransportreports', 'html', 'BookProView');
         $ticket_view->is_admin = 1;
     }
     $ticket_view->setModel($model, true);
     $ticket_view->setLayout('report');
     ob_start();
     $ticket_view->display();
     $pdf = ob_get_contents();
     ob_end_clean();
     //get flight name
     $order = new JObject();
     $order->name = "transport_report" . $input->get('filter_depart_date') . '_' . JHtml::_('date', 'now', 'YmdHis');
     $order->fontsize = 9;
     PrintPdfHelper::printTicket($pdf, $order, 'P');
     return;
 }

 function __construct()
 {
     parent::__construct();
     if (!class_exists('TablePackagerate')) {
         AImporter::table('packagerate');
     }
     $this->_table = $this->getTable('packagerate');
 }

 static function getItems($ids = null, $model = false)
 {
     if (empty($model)) {
         AImporter::model('vehicles');
         $model = new BookproModelVehicles();
     }
     return $model->getItemByIds($ids);
 }

 public function getType()
 {
     AImporter::helper('transport');
     $type = TransportHelper::getType();
     $options = array();
     $options[] = JHTML::_('select.option', '', JText::_('COM_BOOKPRO_TYPE'), 'value', 'text');
     $options = array_merge($options, $type);
     return JHTML::_('select.genericlist', $options, 'filter_type', ' class="inputbox" ', 'value', 'text', $this->state->get('filter.type'), 'filter_type');
 }

 function getCustomerSelectBox($select)
 {
     AImporter::model('customers');
     $model = new BookProModelCustomers();
     $state = $model->getState();
     $state->set('list.start', 0);
     $state->set('list.limit', 0);
     $fullList = $model->getItems();
     //getData();
     return AHtml::getFilterSelect('user_id', 'Select Customer', $fullList, $select, false, '', 'id', 'firstname');
 }

 public function display($tpl = null)
 {
     AImporter::model('vehicles');
     $model = new BookproModelVehicles();
     $this->items = $model->getTypes();
     if (count($error = $this->get('Errors'))) {
         JError::raiseError(500, implode("\n", $errors));
         return false;
     }
     $this->addToolbar();
     parent::display($tpl);
 }

 function getCitySelectBox($select)
 {
     AImporter::model('airports');
     $model = new BookProModelAirports();
     $state = $model->getState();
     $state->set('list.start', 0);
     $state->set('list.limit', 0);
     $state->set('list.state', 1);
     $state->set('list.province', 1);
     $state->set('list.parent_id', 1);
     $fullList = $model->getItems();
     return JHTML::_('select.genericlist', $fullList, 'jform[city]', ' class="inputbox" ', 'id', 'title', $select, 'jform[city]');
 }

 protected function saveOrderInfo()
 {
     //save order info
     AImporter::table('orderinfo');
     AImporter::helper('date');
     $this->orderinfo['params']['start'] = DateHelper::createFromFormatYmd($this->orderinfo['params']['start']);
     $this->orderinfo['params']['end'] = DateHelper::createFromFormatYmd($this->orderinfo['params']['end']);
     $orderinfo = $this->orderinfo;
     $orderinfo['order_id'] = $this->table->id;
     $orderinfo['params'] = json_encode($this->orderinfo['params']);
     $orderinfo['start'] = $this->orderinfo['params']['start'];
     $TableOrderinfo = new TableOrderInfo($this->_db);
     return $TableOrderinfo->save($orderinfo);
 }

 protected function getOptions()
 {
     AImporter::helper('vehicle');
     $db = JFactory::getDBO();
     $query = $db->getQuery(true);
     $query->select('id AS value, title AS text');
     $query->from('#__bookpro_vehicle');
     $query->where('state = 1');
     $db->setQuery($query);
     $options = array();
     $options = $db->loadObjectList();
     $options = array_merge(parent::getOptions(), $options);
     return $options;
 }

 static function getDayWeek($name)
 {
     AImporter::helper('date');
     $days = DateHelper::dayofweek();
     $daysweek = array();
     foreach ($days as $key => $value) {
         $object = new stdClass();
         $object->key = $key;
         $object->value = $value;
         $daysweek[] = $object;
     }
     $selected = array_keys($days);
     return AHtml::checkBoxList($daysweek, $name, '', $selected, 'key', 'value');
 }

 public function delete()
 {
     JSession::checkToken() or die(JText::_('JINVALID_TOKEN'));
     $cid = JFactory::getApplication()->input->getInt('cid');
     if (!$cid) {
         $this->setMessage('Delete failed!');
     } else {
         AImporter::table('vehicletype');
         $db = JFactory::getDbo();
         $table = new TableVehicleType($db);
         $table->load($cid);
         $result = $table->delete();
     }
     if ($result) {
         $this->setMessage('Delete successfull!');
     } else {
         $this->setMessage('Delete failed!');
     }
     $this->directView();
 }

 function deleteRateDate()
 {
     $id = JRequest::getInt('id', 0);
     $db = JFactory::getDbo();
     $query = $db->getQuery(true);
     if ($id) {
         $query->delete('#__bookpro_tourrate');
         $query->where('id=' . $id);
         $db->setQuery($query);
         $db->query();
     }
     $calendar_attributes = array('min_select_year' => JFactory::getDate('-1 years')->format('Y'), 'max_select_year' => JFactory::getDate('+1 years')->format('Y'));
     if (isset($_REQUEST['action']) and $_REQUEST['action'] == 'pn_get_month_cal') {
         require_once JPATH_COMPONENT_ADMINISTRATOR . '/classes/calendar.php';
         AImporter::css('calendar');
         $calendar = new PN_Calendar($calendar_attributes);
         echo $calendar->draw(array(), $_REQUEST['year'], $_REQUEST['month']);
         exit;
     }
 }

 public function postRequest()
 {
     $token = JSession::checkToken();
     if (!$token) {
         die('Invail request');
     }
     $app = jfactory::getApplication();
     AImporter::helper('email');
     AImporter::classes('order/custom');
     $order = new BookproCustomOrder();
     $order->orderinfo = $this->input->get('orderinfo', array(), 'array');
     $order->customer = $_POST;
     $db = JFactory::getDbo();
     if ($order->save()) {
         $mail = new EmailHelper($order->table->id);
         $mail->sendMail();
         $app->enqueueMessage(JText::_('COM_BOOKPRO_CUSTOM_THANKS_FOR_BOOKING'));
     }
     $app->redirect('index.php?option=com_bookpro&view=customservice');
     return;
 }

 function getObjectByID($id)
 {
     AImporter::model('orderinfos', 'customer');
     $query = 'SELECT `obj`.*, c.mobile,c.firstname,c.email FROM `' . $this->_table->getTableName() . '` AS `obj` ';
     $query .= 'LEFT JOIN `#__bookpro_customer` AS `c` ON `c`.`id` = `obj`.`user_id` ';
     $query .= 'WHERE `obj`.`id` = ' . (int) $id;
     $this->_db->setQuery($query);
     $obj =& $this->_db->loadObject();
     //load orderinfo
     $infosmode = new BookProModelOrderinfos();
     $infolists = array('order_id' => $id);
     $infosmode->init($infolists);
     $infos = $infosmode->getData();
     $obj->infos = $infos;
     //load customer
     $customerModel = new BookProModelCustomer();
     //$customerModel->setId($obj->user_id);
     $customer = $customerModel->getItem($obj->user_id);
     //getObject();
     $obj->customer = $customer;
     return $obj;
 }

 public function __construct($id = false, $typeChart = false, $option = false, $title = false)
 {
     if (!class_exists('BookProHelper')) {
         AImporter::helper('bookpro');
     }
     //Check is backend or frontend
     if (JFactory::getApplication()->isAdmin()) {
         $this->isBackend = true;
     } else {
         $this->isBackend = false;
     }
     $this->isAgent = BookProHelper::isAgent();
     if ($id) {
         $this->id = $id;
     }
     if ($typeChart) {
         $this->typeChart = $typeChart;
     } else {
         $this->typeChart = 'LineChart';
     }
     $this->optionChart = $option;
     $this->titleChart = $title;
 }

 private function getPlugins()
 {
     $dispatcher = JDispatcher::getInstance();
     AImporter::helper('plugin');
     $payment_plugins = PluginHelper::getPluginsWithEvent('onBookproGetPaymentPlugins');
     $plugins = array();
     if ($payment_plugins) {
         foreach ($payment_plugins as $plugin) {
             $results = $dispatcher->trigger("onBookproGetPaymentOptions", array($plugin->element, ''));
             if (in_array(true, $results, true)) {
                 $plugins[] = $plugin;
             }
         }
     }
     if (count($plugins) == 1) {
         $plugins[0]->checked = true;
         ob_start();
         $this->getPaymentForm($plugins[0]->element);
         $html = json_decode(ob_get_contents());
         ob_end_clean();
         $this->assign('payment_form_div', $html->msg);
     }
     $this->assign('plugins', $plugins);
 }