Example #1
0
 /**
  * Display the view
  */
 public function display($tpl = null)
 {
     // get the data
     $this->months = $this->get('Months');
     $this->month_days = $this->get('MonthDays');
     $this->month_start = $this->get('MonthStart');
     $this->month_16 = $this->get('Month16');
     $this->hotels = $this->get('Hotels');
     $this->hotel = $this->get('Hotel');
     $this->inventory = $this->get('Inventory');
     $this->bookings_in_progress = $this->get('BookingsInProgress');
     // filters
     $this->state = $this->get('State');
     // default dates
     $app = JFactory::getApplication();
     $date_format = CHPanelHelper::getDateFormat(JText::_('COM_CHPANEL_LOCALE'));
     // start & end
     $this->start = $app->getUserStateFromRequest('com_chpanel.manage.start', 'start', JFactory::getDate()->format($date_format), 'string');
     $this->end = $app->getUserStateFromRequest('com_chpanel.manage.end', 'end', JFactory::getDate('+ 1 day')->format($date_format), 'string');
     // title
     $date = new JDate('01-' . $this->state->get('filter.month'));
     $this->title = $this->hotel ? $this->hotel->title . ' - ' . $date->format('F Y') : $date->format('F Y');
     // toolbar
     CHPanelHelper::getToolbar('manage');
     // sidebar
     $this->sidebar = JHtmlSidebar::render();
     // display the view layout
     parent::display($tpl);
 }
Example #2
0
 /**
  * Display the view
  */
 public function display($tpl = null)
 {
     // get the data from the model
     $this->item = $this->get('Item');
     $this->translation = $this->get('Translation');
     $this->language = CHPanelHelperLangs::getLangTitle(JRequest::getCmd('lang'));
     $this->params = JComponentHelper::getParams('com_chpanel');
     // create the toolbar
     CHPanelHelper::getToolbar(false, true, $this->item->title . ' (' . JText::sprintf('COM_CHPANEL_TRANSLATION_TITLE', $this->language) . ')');
     // display the view template
     parent::display($tpl);
 }
Example #3
0
 /**
  * Display the view
  */
 public function display($tpl = null)
 {
     // get model data
     $this->info = $this->get('Info');
     $this->banner = $this->get('Banner');
     $this->bookings = $this->get('Bookings');
     $this->checkins = $this->get('Checkins');
     // create the toolbar
     CHPanelHelper::getToolbar('panel');
     // sidebar
     $this->sidebar = JHtmlSidebar::render();
     // display the view layout
     parent::display($tpl);
 }
Example #4
0
 /**
  * Display the view
  */
 public function display($tpl = null)
 {
     // get the data from the model
     $this->items = $this->get('Items');
     $this->pagination = $this->get('Pagination');
     $this->state = $this->get('State');
     // filters
     $this->filterForm = $this->get('FilterForm');
     $this->activeFilters = $this->get('ActiveFilters');
     // toolbar and sidbar
     CHPanelHelper::getToolbar('images', $this->state->get('filter.state') == -2);
     $this->sidebar = JHtmlSidebar::render();
     // display the view template
     parent::display($tpl);
 }
Example #5
0
 /**
  * Display the view
  */
 public function display($tpl = null)
 {
     // get the data from the model
     $this->form = $this->get('Form');
     $this->item = $this->get('Item');
     $this->state = $this->get('State');
     // get the image
     $imageHelper = new CHPanelHelperImage(JComponentHelper::getParams('com_chpanel'));
     $this->image = $imageHelper->getImage($this->item->id, 'rooms');
     // get params
     $this->params = JComponentHelper::getParams('com_chpanel');
     // create the toolbar
     CHPanelHelper::getToolbar(false, $this->item->id, $this->item->title);
     // display the view template
     parent::display($tpl);
 }
Example #6
0
 /**
  * Display the view
  */
 public function display($tpl = null)
 {
     // get the data from the model
     $this->items = $this->get('Items');
     $this->pagination = $this->get('Pagination');
     $this->state = $this->get('State');
     // filters
     $this->filterForm = $this->get('FilterForm');
     $this->activeFilters = $this->get('ActiveFilters');
     // start & end
     $app = JFactory::getApplication();
     $this->date = $app->getUserStateFromRequest('com_chpanel.bookings.date', 'date', '', 'string');
     $this->start = $app->getUserStateFromRequest('com_chpanel.bookings.start', 'start', '', 'string');
     $this->end = $app->getUserStateFromRequest('com_chpanel.bookings.end', 'end', '', 'string');
     // toolbar and sidbar
     CHPanelHelper::getToolbar('bookings', $this->state->get('filter.state') == -2);
     $this->sidebar = JHtmlSidebar::render();
     // display the view template
     parent::display($tpl);
 }
Example #7
0
 /**
  * Display the view
  */
 public function display($tpl = null)
 {
     // get the data from the model
     $this->form = $this->get('Form');
     $this->item = $this->get('Item');
     $this->state = $this->get('State');
     // get params
     $this->params = JComponentHelper::getParams('com_chpanel');
     // get the image
     $imageHelper = new CHPanelHelperImage(JComponentHelper::getParams('com_chpanel'));
     $this->image = $imageHelper->getImage($this->item->id, 'hotels');
     // create the toolbar
     CHPanelHelper::getToolbar(false, $this->item->id, $this->item->title);
     // load com_hotel language (for categories titles)
     $lpath = JPATH_ROOT . '/components/com_hotel';
     JFactory::getLanguage()->load('com_hotel', $lpath, 'en-GB', true);
     JFactory::getLanguage()->load('com_hotel', $lpath, null, true);
     // display the view template
     parent::display($tpl);
 }
Example #8
0
 /**
  * Display the view
  */
 public function display($tpl = null)
 {
     // get the data from the model
     $this->items = $this->get('Items');
     $this->pagination = $this->get('Pagination');
     $this->state = $this->get('State');
     // filters
     $this->filterForm = $this->get('FilterForm');
     $this->activeFilters = $this->get('ActiveFilters');
     // lists
     $this->lists = new stdClass();
     $this->lists->langs = CHPanelHelperLangs::getLangs();
     $this->lists->translations = CHPanelHelperLangs::getTranslations($this->items);
     // toolbar and sidbar
     if ($this->getLayout() !== 'modal') {
         CHPanelHelper::getToolbar('hotels', $this->state->get('filter.state') == -2);
         $this->sidebar = JHtmlSidebar::render();
     }
     // display the view layout
     parent::display($tpl);
 }
Example #9
0
				<div class="form-horizontal">
					<fieldset>
						<legend><?php 
    echo JText::_('COM_CHPANEL_TRANSLATION_IMAGES');
    ?>
</legend>
						<?php 
    foreach ($this->item->images as $i => $image) {
        $field = "image_" . $image->id;
        $label = JText::_('COM_CHPANEL_ANY_IMAGE') . ' #' . ($i + 1);
        CHPanelHelper::renderTranslateText($field, $image->title, @$this->translation->data->{$field}, $label, $gtranslate);
        if ($image->info) {
            echo '<div class="chpanel-translate-image-info">';
            $field = "image_info_" . $image->id;
            $label = ' ';
            CHPanelHelper::renderTranslateTextArea($field, $image->info, @$this->translation->data->{$field}, $label, $gtranslate);
            echo '</div>';
        }
    }
    ?>
					</fieldset>
				</div>

			<?php 
}
?>

        </div>

    </div>
    <!--/main -->
Example #10
0
        <h4><?php 
echo JText::_('COM_CHPANEL_BOOKINGS_FILTER_DATES');
?>
</h4>

        <div class="chpanel-bookings-datefilters">

            <div class="chpanel-bookings-datefilter">
                <label for="chpanel-bookings-date"><?php 
echo JText::_('COM_CHPANEL_BOOKINGS_FILTER_DATE');
?>
</label>
                <select name="date"  id="chpanel-bookings-date" class="input input-medium">
					<?php 
echo JHtml::_('select.options', CHPanelHelper::getBookingFilterDates(), null, null, $this->date, true);
?>
                </select>
            </div>

            <label for="chpanel-bookings-start"><?php 
echo JText::_('COM_CHPANEL_BOOKINGS_FILTER_START');
?>
</label>
            <div class="input-prepend">
                <span class="add-on"><i class="icon-calendar"></i></span>
                <input class="input-small chpanel-bookings-datepicker" name="start" id="chpanel-bookings-start" type="text" value="<?php 
echo $this->start;
?>
" autocomplete="off" readonly="readonly">
            </div>
Example #11
0
echo CHPanelHelper::getControlGroup($params, 'cat100');
?>
					<?php 
echo CHPanelHelper::getControlGroup($params, 'cat200');
?>
					<?php 
echo CHPanelHelper::getControlGroup($params, 'cat300');
?>
					<?php 
echo CHPanelHelper::getControlGroup($params, 'cat400');
?>
					<?php 
echo CHPanelHelper::getControlGroup($params, 'cat500');
?>
					<?php 
echo CHPanelHelper::getControlGroup($params, 'cat600');
?>
                </fieldset>
            </div>

        </div>

        <!-- sidebar -->
        <div class="span3">

            <!-- image -->
            <div class="well">
                <h3><?php 
echo JText::_('COM_CHPANEL_ANY_FIELDSET_IMAGE');
?>
</h3>
Example #12
0
 /**
  * Get the translations and override strings
  */
 private function loadTranslations($items, $ids)
 {
     // get the translations
     $qids = implode(',', $ids);
     $db = JFactory::getDbo();
     $lang = $db->quote(JFactory::getLanguage()->getTag());
     $query_translation = $db->getQuery(true)->select('*')->from('#__chpanel_translations')->where("lang = {$lang}")->where("hotel_id IN ({$qids})");
     $translations = $db->setQuery($query_translation)->loadObjectList('hotel_id');
     if ($translations) {
         foreach ($items as $item) {
             if (isset($translations[$item->id])) {
                 $item = CHPanelHelper::applyTranslation($item, $translations[$item->id]);
             }
         }
     }
     return $items;
 }
Example #13
0
 /**
  * Update inventory
  */
 public function update()
 {
     // get the hotel
     $hotel = $this->getHotel();
     if (!$hotel) {
         $this->setError(JText::_('COM_CHPANEL_MANAGE_ERROR_HOTEL'));
         return false;
     }
     // prepare check
     $db = JFactory::getDbo();
     $app = JFactory::getApplication();
     $date_format = CHPanelHelper::getDateFormat(JText::_('COM_CHPANEL_LOCALE'));
     // start
     $start = $app->getUserStateFromRequest('com_chpanel.manage.start', 'start', JFactory::getDate()->format($date_format), 'string');
     $date_start = new JDate(CHPanelHelper::correctDateFormat($start));
     $this->start_date = $date_start->format('Y-m-d');
     // end
     $end = $app->getUserStateFromRequest('com_chpanel.manage.end', 'end', JFactory::getDate('+ 1 day')->format($date_format), 'string');
     $date_end = new JDate(CHPanelHelper::correctDateFormat($end));
     $this->end_date = $date_end->format('Y-m-d');
     // check dates
     if (!$this->start_date || !$this->end_date) {
         $this->setError(JText::_('COM_CHPANEL_MANAGE_ERROR_DATES'));
         return false;
     }
     // check period
     if ($date_end->format('Ymd') < $date_start->format('Ymd')) {
         $this->setError(JText::_('COM_CHPANEL_MANAGE_ERROR_DATES'));
         return false;
     }
     // check values
     $rids = array();
     foreach ($hotel->rooms as $room) {
         if (JRequest::getString('availability_' . $room->id, '', 'post') != '') {
             $rids[] = $room->id;
         }
         if (JRequest::getString('rate_' . $room->id, '', 'post') != '') {
             $rids[] = $room->id;
         }
     }
     if (!$rids) {
         $this->setError(JText::_('COM_CHPANEL_MANAGE_ERROR_INVENTORY'));
         return false;
     }
     // set filter_month state
     JFactory::getApplication()->setUserState('com_chpanel.manage.filter.month', $date_start->format('m-Y'));
     // get the rooms ids
     $room_ids = array_unique($rids);
     // update inventory per room
     foreach ($room_ids as $room_id) {
         // get the room default rate
         foreach ($hotel->rooms as $room) {
             if ($room->id == $room_id) {
                 $default_rate = $room->rate;
             }
         }
         // get the room current inventory
         $inventory_rows = $this->getRoomInventory($room_id);
         // prepare loop dates
         $date = $date_start->toUnix();
         $while_date = $date_start->format('Ymd');
         $while_end = $date_end->format('Ymd');
         $current_date = $date_start->format('Y-m-d');
         // update inventory
         while ($while_date <= $while_end) {
             // new object query
             $row = new stdClass();
             // get row values
             if (JRequest::getString('availability_' . $room_id, '', 'post') != '') {
                 $row->availability = JRequest::getInt('availability_' . $room_id, 0, 'post');
             }
             if (JRequest::getString('rate_' . $room_id, '', 'post') != '') {
                 $row->rate = JRequest::getFloat('rate_' . $room_id, 0, 'post');
             }
             // update or insert inventory row
             if (isset($inventory_rows[$current_date])) {
                 // update row
                 $row->id = $inventory_rows[$current_date]->id;
                 $db->updateObject('#__chpanel_inventory', $row, 'id');
             } else {
                 // default availability, 0 for new rows
                 if (!isset($row->availability)) {
                     $row->availability = 0;
                 }
                 // default rate, room rack rate
                 if (!isset($row->rate)) {
                     $row->rate = $default_rate;
                 }
                 // insert row
                 $row->room_id = $room_id;
                 $row->date = $current_date;
                 $db->insertObject('#__chpanel_inventory', $row);
             }
             // update loop conditions
             $date = strtotime('+1 day', $date);
             $j_date = JFactory::getDate($date);
             $while_date = $j_date->format('Ymd');
             $current_date = $j_date->format('Y-m-d');
         }
     }
     // return ok
     JFactory::getApplication()->enqueueMessage(JText::_('COM_CHPANEL_MANAGE_APPLY_OK'));
     return true;
 }
Example #14
0
 /**
  * Query
  */
 protected function getListQuery()
 {
     // main query
     $query = $this->_db->getQuery(true);
     $query->select('a.*, a.first_name AS title');
     $query->from('#__chpanel_bookings AS a');
     // joins
     $query->select('h.title AS hotel')->join('LEFT', '#__chpanel_hotels AS h ON h.id = a.hotel_id');
     $query->select('r.title AS room, r.reference')->join('LEFT', '#__chpanel_rooms AS r ON r.id = a.room_id');
     $query->select('l.title AS language_title')->join('LEFT', '#__languages AS l ON l.lang_code = h.language');
     // checked out
     $query->select('uc.name AS editor');
     $query->join('LEFT', '#__users AS uc ON uc.id=a.checked_out_time');
     // status filter
     $status = $this->getState('filter.status');
     if (is_numeric($status)) {
         if ($status % 100 == 0) {
             $statuses = array($status + 1, $status + 2, $status + 3);
             $query->where('a.status IN (' . implode(',', $statuses) . ')');
         } else {
             $query->where('a.status = ' . $status);
         }
     } else {
         $query->where('a.status IN (201,202,203)');
         // confirmed bookings
     }
     // state filter
     $state = $this->getState('filter.state');
     if (is_numeric($state)) {
         $query->where('a.state = ' . (int) $state);
     } else {
         if ($state != '*') {
             $query->where('a.state = 1');
         }
     }
     // search filter
     $search = $this->getState('filter.search');
     if (!empty($search)) {
         if (stripos($search, 'id:') === 0) {
             $query->where('a.id = ' . (int) substr($search, 3));
         } else {
             $search = $this->_db->Quote('%' . $this->_db->escape($search, true) . '%');
             $query->where('(a.first_name LIKE ' . $search . ')');
         }
     }
     // other standard filters
     foreach (array('hotel') as $filter_name) {
         $filter_value = $this->getState('filter.' . $filter_name);
         if (is_numeric($filter_value)) {
             $query->where('a.' . $filter_name . '_id = ' . $filter_value);
         }
     }
     // date filters
     $db = JFactory::getDbo();
     $app = JFactory::getApplication();
     $start = $app->getUserStateFromRequest('com_chpanel.bookings.start', 'start', '', 'string');
     $end = $app->getUserStateFromRequest('com_chpanel.bookings.end', 'end', '', 'string');
     $date = $app->getUserStateFromRequest('com_chpanel.bookings.date', 'date', 'created', 'string');
     if (in_array($date, array('created', 'checkin', 'checkout'))) {
         if ($start) {
             $date_start = new JDate(CHPanelHelper::correctDateFormat($start));
             $query_start = $db->quote($date_start->format('Y-m-d'));
             $query->where("{$query_start} <=  DATE(a.{$date})");
         }
         if ($end) {
             $date_end = new JDate(CHPanelHelper::correctDateFormat($end));
             $query_end = $db->quote($date_end->format('Y-m-d'));
             $query->where("DATE(a.{$date}) <= {$query_end}");
         }
     }
     // ordering clause
     $orderCol = $this->state->get('list.ordering');
     $orderDirn = $this->state->get('list.direction');
     $query->order($this->_db->escape("{$orderCol} {$orderDirn}"));
     // echo nl2br(str_replace('#__', 'jos_', $query));
     return $query;
 }
Example #15
0
					<?php 
} else {
    ?>

						<p class="alert alert-warning"><?php 
    echo JText::_('COM_CHPANEL_PANEL_CHECKINS_NO');
    ?>
</p>

					<?php 
}
?>

                    <div class="clearfix">
						<?php 
$today = JFactory::getDate()->format(CHPanelHelper::getDateFormat(JText::_('COM_CHPANEL_LOCALE')));
$link = JRoute::_('index.php?option=com_chpanel&view=bookings&filter[hotel]=&filter[status]=&filter[state]=&list[fullordering]=a.checkin%20ASC&date=checkin&end=&start=' . $today);
?>
                        <a class="btn btn-small pull-right" href="<?php 
echo $link;
?>
"><?php 
echo JText::_('COM_CHPANEL_PANEL_VIEW_MORE');
?>
</a>
                    </div>

                </div>

            </div> 
Example #16
0
 * @author		Xavier Pallicer <*****@*****.**>
 */
defined('_JEXEC') or die;
JHtml::_('formbehavior.chosen', 'select');
$context = 'items';
$listOrder = $this->escape($this->state->get('list.ordering'));
$listDirn = $this->escape($this->state->get('list.direction'));
$saveOrder = $listOrder == 'a.ordering';
if ($saveOrder) {
    JHtml::_('sortablelist.sortable', 'articleList', 'adminForm', strtolower($listDirn), 'index.php?option=com_chpanel&task=' . $context . '.saveOrderAjax&tmpl=component');
}
$archived = $this->state->get('filter.state') == 2 ? true : false;
$trashed = $this->state->get('filter.state') == -2 ? true : false;
$imageHelper = new CHPanelHelperImage(JComponentHelper::getParams('com_chpanel'));
$image_path = JURI::root() . "/images/chpanel/{$context}/";
$types = CHPanelHelper::defaultTypes();
?>

<!-- adminForm -->
<form action="<?php 
echo JRoute::_('index.php?option=com_chpanel&view=' . $context);
?>
" method="post" name="adminForm" id="adminForm">

    <!-- main -->
    <div id="j-main-container" class="span12">

        <!-- search tools -->
		<?php 
echo JLayoutHelper::render('joomla.searchtools.default', array('view' => $this));
?>
Example #17
0
<?php

/**
 * @package     CHPanel
 * @copyright	Copyright (C) CloudHotelier. All rights reserved.
 * @license		GNU GPLv2 <http://www.gnu.org/licenses/gpl.html>
 * @author		Xavier Pallicer <*****@*****.**>
 */
defined('_JEXEC') or die;
JHtml::_('formbehavior.chosen', 'select');
// options
$lang = substr(JFactory::getLanguage()->getTag(), 0, 2);
$checkfields = JText::_('COM_CHPANEL_ANY_ERROR_CHECKFIELDS');
$weekstart = JText::_('COM_CHPANEL_LOCALE_WEEKSTART');
$dateformat = str_replace('Y', 'yyyy', str_replace('m', 'mm', str_replace('d', 'dd', CHPanelHelper::getDateFormat(JText::_('COM_CHPANEL_LOCALE')))));
$options = array();
$options[] = "checkfields: '{$checkfields}'";
$options[] = "datepicker_format: '{$dateformat}'";
$options[] = "datepicker_lang: '{$lang}'";
$options[] = "datepicker_weekstart: '{$weekstart}'";
JFactory::getDocument()->addScriptDeclaration("window.chpanel_options = {" . implode(",\n", $options) . "};");
// load datepicker
JHtml::stylesheet(JUri::base() . 'components/com_chpanel/assets/datepicker/css/datepicker.css');
JHtml::script(JUri::base() . 'components/com_chpanel/assets/datepicker/js/bootstrap-datepicker.js');
if ($lang != 'en') {
    JHtml::script(JUri::base() . "components/com_chpanel/assets/datepicker/js/locales/bootstrap-datepicker.{$lang}.js");
}
// tooltip
JHtml::_('bootstrap.tooltip');
?>