Show Facilities on reservationasset

Luxuria Quickstart - Hub:

When creating a new Reservation Asset there are facilities that can be checked. However, I do not see where they are being displayed for each Reservation Asset on the front end. I need to be able to display the Reservation Asset's Facilities so the customers will know what facilities are available for each Asset.

Same thing for the Room Type Facilities, how can I show what facilities are available for each room type?

Hi, I show facilities on reservationasset this way:

1. Make backup of your site
2.. You should change function onReservationAssetPrepareData in file plugins/solidres/hub/hub.php. After strings:

// Load the facility data from the database.
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('facility_id')
->from($db->quoteName('#__sr_facility_reservation_asset_xref'))
->where('reservation_asset_id = ' . (int) $id );
$data->facility_id = $db->setQuery($query)->loadColumn();

// Load the theme data from the database
$query->clear();
$query->select('theme_id')
->from($db->quoteName('#__sr_reservation_asset_theme_xref'))
->where('reservation_asset_id = ' . (int) $id );
$data->theme_id = $db->setQuery($query)->loadColumn();

I added changed strings:

// Load the facility data from the database with titles
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query->select('*')
->from($db->quoteName('#__sr_facilities').' AS facilities')
->join('INNER', $db->quoteName('#__sr_facility_reservation_asset_xref').' AS res_facilities ON res_facilities.facility_id = facilities.id')
->where('reservation_asset_id = ' . (int) $id );
$data->facility_id2 = $db->setQuery($query)->loadObjectList();


// Load the theme data from the database with titles
$query->clear();
$query->select('*')
->from($db->quoteName('#__sr_themes').' AS themes')
->join('INNER', $db->quoteName('#__sr_reservation_asset_theme_xref').' AS res_themes ON res_themes.theme_id = themes.id')
->where('reservation_asset_id = ' . (int) $id );
$data->theme_id2 = $db->setQuery($query)->loadObjectList();

3. And then in reservationasset template - components/com_solidres/views/reservationasset/tmpl/default - insert code like this:

( for themes)

<?php foreach($this->item->theme_id2 as $theme ) : ;?>
<div class="theme-block">
<p><?php echo $theme->title ;?></p>
</div>
<?php endforeach ;?>


(for facilities)


<?php foreach($this->item->facility_id2 as $facility ) : ;?>
<div class="facility-block">
<p><?php echo $facility->title ;?></p>
</div>
<?php endforeach ;?>


You can style it as you want. You can draw icons for each facility and name it as _ID_.png (where _ID_ is ID of your facility) and show icons near your facility name.
You can add other information from theme and facility like description, id etc.

And do not forget to make backup of your site before making changes

Like this

sory i can not attache screen shot

It's small