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;
}
protected function populateState($ordering = null, $direction = null)
{
// Load the filter state.
$search = $this->getUserStateFromRequest($this->context . '.filter.search', 'filter_search');
$this->setState('filter.search', $search);
$order_status = $this->getUserStateFromRequest($this->context . '.filter.order_status', 'filter_order_status', null, 'string');
$this->setState('filter.order_status', $order_status);
$from_time = $this->getUserStateFromRequest($this->context . '.filter.from_time', 'filter_from_time', null, 'string');
$this->setState('filter.from_time', $from_time);
$to_time = $this->getUserStateFromRequest($this->context . '.filter.to_time', 'filter_to_time', null, 'string');
$this->setState('filter.to_time', $to_time);
$type = $this->getUserStateFromRequest($this->context . '.filter.type', 'filter_type', null, 'int');
$this->setState('filter.type', $type);
$destfrom = $this->getUserStateFromRequest($this->context . '.filter.destfrom', 'filter_destfrom', null, 'int');
$this->setState('filter.destfrom', $destfrom);
$destto = $this->getUserStateFromRequest($this->context . '.filter.destto', 'filter_destto', null, 'int');
$this->setState('filter.destto', $destto);
$route_id = $this->getUserStateFromRequest($this->context . '.filter.route_id', 'filter_route_id', null, 'int');
$this->setState('filter.route_id', $route_id);
parent::populateState('i.start', 'ASC');
$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);
}
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);
}
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);
}
function postSaveHook($model, $validData)
{
//save orderinfo
if ($validData['id']) {
AImporter::helper('date');
AImporter::table('orderinfo');
$orderinfo = $this->input->get('orderinfo', array(), 'array');
$orderinfo['params']['start'] = DateHelper::createFromFormatYmd($orderinfo['params']['start']);
$orderinfo['params']['end'] = DateHelper::createFromFormatYmd($orderinfo['params']['end']);
$orderinfo['start'] = $orderinfo['params']['start'];
$orderinfo['params'] = json_encode($orderinfo['params']);
// debug($orderinfo);die;
$db = JFactory::getDbo();
$table = new TableOrderInfo($db);
$table->load(array('order_id' => $validData['id']));
return $table->save($orderinfo);
}
return true;
}
public function search()
{
AImporter::helper('date');
AImporter::model('tours');
$transport_cart = $this->getCart('TransportCart');
$transport_cart->tour = 1;
$transport_cart->saveToSession();
$app = JFactory::getApplication();
$this->cart = $this->getCart();
$this->cart->filter = array();
$this->cart->filter['adult'] = $app->input->getInt('adult');
$this->cart->filter['child'] = $app->input->getInt('child');
$this->cart->filter['infant'] = $app->input->getInt('infant');
$this->cart->filter['cat_id'] = $app->input->getInt('cat_id');
$this->cart->filter['start'] = DateHelper::createFromFormatYmd($app->input->getString('start'));
$this->cart->saveToSession();
$tours = $this->getTour();
// debug($tours);die;
$view = $this->getView('tours', 'html', 'BookProView');
$view->assign('cart', $this->cart);
$view->assign('tours', $tours);
$view->display();
return;
}
/**
* Save subject.
*
* @param boolean $apply
* true state on edit page, false return to browse list
*/
function save($apply = false)
{
$mainframe = JFactory::getApplication();
$db = JFactory::getDbo();
$input = JFactory::getApplication()->input;
$jform = $input->get('jform', array(), 'array');
$frate = $input->get('frate', array(), 'array');
//quote all value to push db
foreach ($frate as &$rate) {
foreach ($rate as $i => $v) {
$rate[$i] = $db->quote($v);
}
}
$rate = reset($frate);
$key = array_keys($rate);
$weekdays = $input->get('weekday', null, 'array');
$state = $input->getInt('state');
$jform['startdate'] = DateHelper::createFromFormatYmd($jform['startdate']);
$jform['enddate'] = DateHelper::createFromFormatYmd($jform['enddate']);
$startdate = new JDate($jform['startdate']);
$enddate = new JDate($jform['enddate']);
$starttoend = $startdate->diff($enddate)->days;
// delete old record
$tour_id = $jform['tour_id'];
try {
$db->transactionStart();
// Delete all existing rate in this duration and fligh route
$query = $db->getQuery(true);
$query->delete('#__bookpro_tourrate')->where('(tour_id=' . $tour_id . '
AND date BETWEEN ' . $db->quote($startdate) . '
AND ' . $db->quote($enddate) . '
AND DATE_FORMAT(date,"%w") IN (' . implode(',', $weekdays) . '))
OR (date < ' . $db->quote(JFactory::getDate('- 10DAYS')->format('Y-m-d') . ' AND tour_id=' . $tour_id) . ')');
$db->setQuery($query);
$db->execute();
$query = $db->getQuery(true);
$query->insert('#__bookpro_tourrate');
$query->columns('tour_id,date,' . implode(',', $key) . ',state');
$values = array();
for ($i = 0; $i <= $starttoend; $i++) {
$dw = (int) $startdate->format('w');
if (in_array("{$dw}", $weekdays)) {
foreach ($frate as $rate) {
$temp = array($jform['tour_id'], $db->quote($startdate->toSql()));
$temp = array_merge($temp, $rate);
$temp[] = $state;
$values[] = implode(',', $temp);
}
}
$startdate = $startdate->add(new DateInterval('P1D'));
}
// Save rate
$query->values($values);
$db->setQuery($query);
$db->execute();
$this->saveLog($frate, $weekdays, $jform);
$db->transactionCommit();
$mainframe->enqueueMessage('Saved successful');
} catch (Exception $e) {
$db->transactionRollback();
JErrorPage::render($e);
$mainframe->enqueueMessage($e->getMessage());
}
// if($apply)
$this->setRedirect(JRoute::_('index.php?option=com_bookpro&view=tourrate&tour_id=' . $tour_id, false));
// else
// $this->setRedirect ( JRoute::_('index.php?option=com_bookpro&view=tours',false) );
}
function search()
{
AImporter::helper('date', 'transport', 'date');
AImporter::model('transports');
$cart = $this->getCart();
$config = JComponentHelper::getParams('com_bookpro');
$input = JFactory::getApplication()->input;
$cart->filter['destfrom'] = $input->getInt('transport_from');
$cart->filter['pad_from'] = $input->getString('transport_padress_from');
$cart->filter['pad_to'] = $input->getString('transport_padress_to');
$cart->filter['destto'] = $input->getInt('transport_to');
$cart->filter['type'] = $input->getInt('transport_type');
$cart->filter['country'] = $input->getInt('transport_country');
$cart->filter['roundtrip'] = $input->getInt('roundtrip');
$cart->filter['adult'] = $input->getInt('transport_adult');
$cart->filter['child'] = $input->getInt('transport_child');
$cart->filter['infant'] = $input->getInt('transport_infant');
$cart->filter['bag'] = $input->getInt('transport_bag');
$cart->start = DateHelper::createFromFormatYmd($input->getString('transport_start'));
if ($cart->filter['roundtrip']) {
$cart->end = DateHelper::createFromFormatYmd($input->getString('transport_return'));
}
$cart->tour = 0;
$cart->tax = $config->get('tax');
$cart->is_airport_shuttle = 0;
//check if destionation is from airport
$dest_from = TransportHelper::getDest($cart->filter['destfrom']);
$dest_to = TransportHelper::getDest($cart->filter['destto']);
if ($dest_from[0]->value == 'AP') {
$cart->is_airport_shuttle = 1;
} else {
if ($dest_to[0]->value == 'AP') {
$cart->is_airport_shuttle = 2;
}
}
//find trips
$trips = $this->getTrip($cart);
if (empty($trips['depart'])) {
JFactory::getApplication()->enqueueMessage(JText::_('COM_BOOKPRO_DEPART_TRIP_NOT_AVAILABLE_WARN'), 'warning');
}
if ($cart->filter['roundtrip']) {
if (empty($trips['return'])) {
//$cart->filter['roundtrip'] = 0;
JFactory::getApplication()->enqueueMessage(JText::_('COM_BOOKPRO_RETURN_TRIP_NOT_AVAILABLE_WARN'), 'warning');
}
}
// debug($trips);die;
$cart->saveToSession();
$view = $this->getView('transporttime', 'html', 'BookProView');
$view->assign('cart', $cart);
$view->assign('trips', $trips);
$view->display();
}