I've been waiting for this, but eventually just rolled my own solution. Here it is if anyone also needs this functionality. I'm using the ic_rounded theme and the file to edit is components/com_icagenda/themes/packs/ic_rounded/ic_rounded_events.php. Insert the following code before the line (around line 150 for me): <?php // + infos Text ?>
<?php // Show remaining seats for event ?>
<?php
$tempdb = JFactory::getDbo();
$query = $tempdb->getQuery(true);
$query
->select(array('count(*)', 't1.date', 't2.title', 'JSON_UNQUOTE(JSON_EXTRACT(t2.params,"$.maxReg")) AS capacity', '(JSON_UNQUOTE(JSON_EXTRACT(t2.params,"$.maxReg")) - count(*)) AS available'))
->from($tempdb->quoteName('#__icagenda_registration', 't1'))
->join('LEFT', $tempdb->quoteName('#__icagenda_events', 't2') . ' ON ' . $tempdb->quoteName('t1.eventid') . ' = ' . $tempdb->quoteName('t2.id'))
->where($tempdb->quoteName('t1.date') . ' LIKE "%' . $item->next . '%"')
->where($tempdb->quoteName('t2.title') . ' LIKE "%' . $item->title . '%"')
->where($tempdb->quoteName('t1.state') . ' = "1"')
->group($tempdb->quoteName('title'));
$tempdb->setQuery($query);
$tempResults = $tempdb->loadAssoc();
if ($tempResults["available"] > 0) {
echo $tempResults["available"]." seats available.";
} else {
echo "There are no seats available.";
}
?>I haven't tested it with events that have multiple dates, but this works for me for now at least.
*** Updated 2021/08/17 ***
I've tweaked the code to work correctly with repeat events and to display the correct seats when no bookings have yet been made.
<?php // Show remaining seats for event ?>
<?php
$tempdb = JFactory::getDbo();
$query = $tempdb->getQuery(true);
$query
->select(array('t1.title', 'JSON_UNQUOTE(JSON_EXTRACT(t1.params,"$.maxReg")) AS capacity'))
->from($tempdb->quoteName('#__icagenda_events', 't1'))
->where($tempdb->quoteName('t1.period') . ' LIKE "%' . $evt . '%"')
->where($tempdb->quoteName('t1.title') . ' LIKE "%' . $item->title . '%"');
$tempdb->setQuery($query);
$tempResults = $tempdb->loadAssoc();
$capacity = $tempResults["capacity"];
$query = $tempdb->getQuery(true);
$query
->select(array('count(*)', 't1.date', 't2.title', 'JSON_UNQUOTE(JSON_EXTRACT(t2.params,"$.maxReg")) AS capacity', '(JSON_UNQUOTE(JSON_EXTRACT(t2.params,"$.maxReg")) - count(*)) AS available'))
->from($tempdb->quoteName('#__icagenda_registration', 't1'))
->join('LEFT', $tempdb->quoteName('#__icagenda_events', 't2') . ' ON ' . $tempdb->quoteName('t1.eventid') . ' = ' . $tempdb->quoteName('t2.id'))
->where($tempdb->quoteName('t1.date') . ' LIKE "%' . $evt . '%"')
->where($tempdb->quoteName('t2.title') . ' LIKE "%' . $item->title . '%"')
->where($tempdb->quoteName('t1.state') . ' = "1"')
->group($tempdb->quoteName('title'));
$tempdb->setQuery($query);
$tempResults = $tempdb->loadAssoc();
if ($tempResults == NULL) {
echo "$capacity seats available.";
} elseif ($tempResults["available"] > 0) {
echo $tempResults["available"]." seats available.";
} else {
echo "This venue is fully booked.";
}
?>
